or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 776

Total elapsed time: 0.98629283905029

# Query Time
(1) connect 0.00093793869018555
(2) DESCRIBE `cruises` 0.0041470527648926
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69152, 69227, 69228, 69115, 69186, 69229, 72824, 69141, 69130, 69131)) ORDER BY FIND_IN_SET(id, '69152,69227,69228,69115,69186,69229,72824,69141,69130,69131') 0.0018761157989502
(4) DESCRIBE `cruises` 0.0028681755065918
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69152') 0.00070405006408691
(6) DESCRIBE `ships` 0.0031559467315674
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00045108795166016
(8) DESCRIBE `ships` 0.0030860900878906
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00041484832763672
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031685829162598
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(12) DESCRIBE `itineraries` 0.0017790794372559
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69152') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098609924316406
(14) DESCRIBE `ports` 0.0021021366119385
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00054597854614258
(16) DESCRIBE `ports` 0.0019190311431885
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00040793418884277
(18) DESCRIBE `ports` 0.0014920234680176
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00029802322387695
(20) DESCRIBE `sailingdates` 0.0016329288482666
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69152') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00092506408691406
(22) DESCRIBE `ports` 0.0018088817596436
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0004270076751709
(24) DESCRIBE `ports` 0.0019338130950928
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00038909912109375
(26) DESCRIBE `ports` 0.0018508434295654
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0003969669342041
(28) DESCRIBE `ports` 0.0018758773803711
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0003359317779541
(30) DESCRIBE `ports` 0.001633882522583
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00037288665771484
(32) DESCRIBE `ports` 0.0016629695892334
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00036787986755371
(34) DESCRIBE `ports` 0.0017077922821045
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00037813186645508
(36) DESCRIBE `ports` 0.0017621517181396
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00037002563476562
(38) DESCRIBE `ports` 0.0017271041870117
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0004730224609375
(40) DESCRIBE `ports` 0.0017640590667725
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00038480758666992
(42) DESCRIBE `ports` 0.0017821788787842
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00070309638977051
(44) DESCRIBE `ports` 0.0018470287322998
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0004119873046875
(46) DESCRIBE `ports` 0.0017600059509277
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00047397613525391
(48) DESCRIBE `ports` 0.0018959045410156
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00036978721618652
(50) DESCRIBE `ports` 0.0016119480133057
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00038003921508789
(52) DESCRIBE `ports` 0.0017061233520508
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00044107437133789
(54) DESCRIBE `ports` 0.001884937286377
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0004270076751709
(56) DESCRIBE `ports` 0.0017499923706055
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00039577484130859
(58) DESCRIBE `ports` 0.0020029544830322
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.0006110668182373
(60) DESCRIBE `ports` 0.0017211437225342
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00038313865661621
(62) DESCRIBE `ports` 0.0018389225006104
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00042009353637695
(64) DESCRIBE `ports` 0.0016438961029053
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00040698051452637
(66) DESCRIBE `ports` 0.0017871856689453
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00043678283691406
(68) DESCRIBE `ports` 0.0017960071563721
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.0004429817199707
(70) DESCRIBE `ports` 0.0020511150360107
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00054788589477539
(72) DESCRIBE `ports` 0.0019478797912598
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00035715103149414
(74) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69152') AND (sailingdate >= '2019-03-19') 0.0088839530944824
(75) DESCRIBE `avid_specials` 0.0015459060668945
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69152 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010700225830078
(77) DESCRIBE `cruiselines` 0.0027132034301758
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00056004524230957
(79) DESCRIBE `orchid_image` 0.0021669864654541
(80) DESCRIBE `cruiselines` 0.0030429363250732
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00046396255493164
(82) DESCRIBE `cruises` 0.0036239624023438
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69227') 0.00048708915710449
(84) DESCRIBE `ships` 0.0036349296569824
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00061202049255371
(86) DESCRIBE `ships` 0.0036959648132324
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00048303604125977
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034022331237793
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046300888061523
(90) DESCRIBE `itineraries` 0.0018949508666992
(91) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69227') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010569095611572
(92) DESCRIBE `ports` 0.0020430088043213
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044393539428711
(94) DESCRIBE `ports` 0.0018630027770996
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049400329589844
(96) DESCRIBE `ports` 0.0018398761749268
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003821849822998
(98) DESCRIBE `sailingdates` 0.0015501976013184
(99) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69227') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079989433288574
(100) DESCRIBE `ports` 0.0021190643310547
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047802925109863
(102) DESCRIBE `ports` 0.0018150806427002
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003960132598877
(104) DESCRIBE `ports` 0.0018160343170166
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00041007995605469
(106) DESCRIBE `ports` 0.0017619132995605
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00038790702819824
(108) DESCRIBE `ports` 0.0017158985137939
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00041317939758301
(110) DESCRIBE `ports` 0.0018119812011719
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00041389465332031
(112) DESCRIBE `ports` 0.0018870830535889
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00048613548278809
(114) DESCRIBE `ports` 0.00201416015625
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00046086311340332
(116) DESCRIBE `ports` 0.0018858909606934
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00045204162597656
(118) DESCRIBE `ports` 0.0019209384918213
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00045013427734375
(120) DESCRIBE `ports` 0.001816987991333
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045490264892578
(122) DESCRIBE `ports` 0.0018720626831055
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00051617622375488
(124) DESCRIBE `ports` 0.0018310546875
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00039386749267578
(126) DESCRIBE `ports` 0.0018570423126221
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00042605400085449
(128) DESCRIBE `ports` 0.001882791519165
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00042414665222168
(130) DESCRIBE `ports` 0.0019299983978271
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00038909912109375
(132) DESCRIBE `ports` 0.0016980171203613
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00042104721069336
(134) DESCRIBE `ports` 0.0017940998077393
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00046491622924805
(136) DESCRIBE `ports` 0.0018270015716553
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) 0.00041818618774414
(138) DESCRIBE `ports` 0.0017709732055664
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') 0.00044703483581543
(140) DESCRIBE `ports` 0.0017890930175781
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044989585876465
(142) DESCRIBE `ports` 0.0019450187683105
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040006637573242
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69227') AND (sailingdate >= '2019-03-19') 0.0091779232025146
(145) DESCRIBE `avid_specials` 0.001812219619751
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69227 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017750263214111
(147) DESCRIBE `cruiselines` 0.002734899520874
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00055503845214844
(149) DESCRIBE `orchid_image` 0.0021309852600098
(150) DESCRIBE `cruiselines` 0.0027041435241699
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00055193901062012
(152) DESCRIBE `cruises` 0.0039119720458984
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69228') 0.00046586990356445
(154) DESCRIBE `ships` 0.0035519599914551
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00058698654174805
(156) DESCRIBE `ships` 0.0034208297729492
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00046491622924805
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003209114074707
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030684471130371
(160) DESCRIBE `itineraries` 0.001751184463501
(161) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69228') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071501731872559
(162) DESCRIBE `ports` 0.0021121501922607
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054407119750977
(164) DESCRIBE `ports` 0.001694917678833
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042581558227539
(166) DESCRIBE `ports` 0.0016710758209229
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043797492980957
(168) DESCRIBE `sailingdates` 0.0014529228210449
(169) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69228') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070691108703613
(170) DESCRIBE `ports` 0.0019218921661377
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051712989807129
(172) DESCRIBE `ports` 0.0018539428710938
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00052309036254883
(174) DESCRIBE `ports` 0.0017390251159668
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0004420280456543
(176) DESCRIBE `ports` 0.0017590522766113
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00040912628173828
(178) DESCRIBE `ports` 0.0017378330230713
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00040507316589355
(180) DESCRIBE `ports` 0.001701831817627
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00037002563476562
(182) DESCRIBE `ports` 0.0016529560089111
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00046420097351074
(184) DESCRIBE `ports` 0.0016582012176514
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00038599967956543
(186) DESCRIBE `ports` 0.0019059181213379
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00045514106750488
(188) DESCRIBE `ports` 0.0018670558929443
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00040602684020996
(190) DESCRIBE `ports` 0.0015568733215332
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042104721069336
(192) DESCRIBE `ports` 0.0021910667419434
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0007789134979248
(194) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69228') AND (sailingdate >= '2019-03-19') 0.0084190368652344
(195) DESCRIBE `avid_specials` 0.0019268989562988
(196) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69228 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013229846954346
(197) DESCRIBE `cruiselines` 0.0025501251220703
(198) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00043892860412598
(199) DESCRIBE `orchid_image` 0.0018429756164551
(200) DESCRIBE `cruiselines` 0.0029909610748291
(201) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00055193901062012
(202) DESCRIBE `cruises` 0.0030062198638916
(203) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69115') 0.00047922134399414
(204) DESCRIBE `ships` 0.0035009384155273
(205) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00064492225646973
(206) DESCRIBE `ships` 0.0035820007324219
(207) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00041389465332031
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(210) DESCRIBE `itineraries` 0.0015349388122559
(211) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69115') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083804130554199
(212) DESCRIBE `ports` 0.001594066619873
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00046491622924805
(214) DESCRIBE `ports` 0.0018050670623779
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00040292739868164
(216) DESCRIBE `ports` 0.0017869472503662
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00042009353637695
(218) DESCRIBE `sailingdates` 0.0016160011291504
(219) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69115') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075697898864746
(220) DESCRIBE `ports` 0.002126932144165
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00048613548278809
(222) DESCRIBE `ports` 0.0020530223846436
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00043988227844238
(224) DESCRIBE `ports` 0.0018820762634277
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00049090385437012
(226) DESCRIBE `ports` 0.0019290447235107
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00043416023254395
(228) DESCRIBE `ports` 0.0018818378448486
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00060105323791504
(230) DESCRIBE `ports` 0.0019049644470215
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00043296813964844
(232) DESCRIBE `ports` 0.0019078254699707
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3927))) 0.00041103363037109
(234) DESCRIBE `ports` 0.0014140605926514
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3927') 0.0003049373626709
(236) DESCRIBE `ports` 0.001338005065918
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 542))) 0.00038695335388184
(238) DESCRIBE `ports` 0.0016429424285889
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '542') 0.00034904479980469
(240) DESCRIBE `ports` 0.0015299320220947
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00034713745117188
(242) DESCRIBE `ports` 0.0013289451599121
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00029993057250977
(244) DESCRIBE `ports` 0.0013191699981689
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00032520294189453
(246) DESCRIBE `ports` 0.001370906829834
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00034785270690918
(248) DESCRIBE `ports` 0.0015599727630615
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00044798851013184
(250) DESCRIBE `ports` 0.001629114151001
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0003960132598877
(252) DESCRIBE `ports` 0.001439094543457
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0003199577331543
(254) DESCRIBE `ports` 0.0015830993652344
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00043487548828125
(256) DESCRIBE `ports` 0.001708984375
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00036001205444336
(258) DESCRIBE `ports` 0.0015079975128174
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00030994415283203
(260) DESCRIBE `ports` 0.0013060569763184
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2932))) 0.00031208992004395
(262) DESCRIBE `ports` 0.0013740062713623
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2932') 0.00037503242492676
(264) DESCRIBE `ports` 0.0018889904022217
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00047612190246582
(266) DESCRIBE `ports` 0.00199294090271
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00044083595275879
(268) DESCRIBE `ports` 0.0018830299377441
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00042200088500977
(270) DESCRIBE `ports` 0.0015292167663574
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00040984153747559
(272) DESCRIBE `ports` 0.0016469955444336
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00045680999755859
(274) DESCRIBE `ports` 0.0018670558929443
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.0004119873046875
(276) DESCRIBE `ports` 0.0019140243530273
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.0004570484161377
(278) DESCRIBE `ports` 0.0016059875488281
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00037288665771484
(280) DESCRIBE `ports` 0.0016400814056396
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00049996376037598
(282) DESCRIBE `ports` 0.0016520023345947
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.0004279613494873
(284) DESCRIBE `ports` 0.0016770362854004
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00034308433532715
(286) DESCRIBE `ports` 0.0016698837280273
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00031614303588867
(288) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69115') AND (sailingdate >= '2019-03-19') 0.0063691139221191
(289) DESCRIBE `avid_specials` 0.001600980758667
(290) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69115 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012500286102295
(291) DESCRIBE `cruiselines` 0.0021538734436035
(292) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0003960132598877
(293) DESCRIBE `orchid_image` 0.0015900135040283
(294) DESCRIBE `cruiselines` 0.0024127960205078
(295) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0003821849822998
(296) DESCRIBE `cruises` 0.0030298233032227
(297) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69186') 0.00045084953308105
(298) DESCRIBE `ships` 0.0031290054321289
(299) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00047683715820312
(300) DESCRIBE `ships` 0.0027740001678467
(301) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00041699409484863
(302) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003209114074707
(304) DESCRIBE `itineraries` 0.0017311573028564
(305) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69186') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081586837768555
(306) DESCRIBE `ports` 0.0020530223846436
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00044012069702148
(308) DESCRIBE `ports` 0.0018329620361328
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00044894218444824
(310) DESCRIBE `ports` 0.0020508766174316
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00050187110900879
(312) DESCRIBE `sailingdates` 0.0017540454864502
(313) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69186') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007171630859375
(314) DESCRIBE `ports` 0.0022411346435547
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00049614906311035
(316) DESCRIBE `ports` 0.0018339157104492
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.0041840076446533
(318) DESCRIBE `ports` 0.0027079582214355
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00046110153198242
(320) DESCRIBE `ports` 0.0019159317016602
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00038695335388184
(322) DESCRIBE `ports` 0.0018839836120605
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00043106079101562
(324) DESCRIBE `ports` 0.0047848224639893
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00048208236694336
(326) DESCRIBE `ports` 0.0017378330230713
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00040388107299805
(328) DESCRIBE `ports` 0.004889965057373
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00038790702819824
(330) DESCRIBE `ports` 0.0028350353240967
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.0025172233581543
(332) DESCRIBE `ports` 0.0015301704406738
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00037717819213867
(334) DESCRIBE `ports` 0.0018711090087891
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00033903121948242
(336) DESCRIBE `ports` 0.0021648406982422
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00041604042053223
(338) DESCRIBE `ports` 0.002479076385498
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00039005279541016
(340) DESCRIBE `ports` 0.0017869472503662
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00037598609924316
(342) DESCRIBE `ports` 0.0018050670623779
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.0004420280456543
(344) DESCRIBE `ports` 0.0017139911651611
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0004119873046875
(346) DESCRIBE `ports` 0.0019569396972656
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00032281875610352
(348) DESCRIBE `ports` 0.0014138221740723
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00034880638122559
(350) DESCRIBE `ports` 0.0013117790222168
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031208992004395
(352) DESCRIBE `ports` 0.001270055770874
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029897689819336
(354) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69186') AND (sailingdate >= '2019-03-19') 0.0065879821777344
(355) DESCRIBE `avid_specials` 0.0032110214233398
(356) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69186 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019738674163818
(357) DESCRIBE `cruiselines` 0.0024728775024414
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0004580020904541
(359) DESCRIBE `orchid_image` 0.0018720626831055
(360) DESCRIBE `cruiselines` 0.0023219585418701
(361) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00041890144348145
(362) DESCRIBE `cruises` 0.0035088062286377
(363) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69229') 0.00046515464782715
(364) DESCRIBE `ships` 0.0033290386199951
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00049114227294922
(366) DESCRIBE `ships` 0.0029969215393066
(367) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00033712387084961
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026583671569824
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034999847412109
(370) DESCRIBE `itineraries` 0.0013611316680908
(371) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69229') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065493583679199
(372) DESCRIBE `ports` 0.0014538764953613
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034904479980469
(374) DESCRIBE `ports` 0.0015490055084229
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003972053527832
(376) DESCRIBE `ports` 0.0018951892852783
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041890144348145
(378) DESCRIBE `sailingdates` 0.0012869834899902
(379) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69229') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059103965759277
(380) DESCRIBE `ports` 0.0015230178833008
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003509521484375
(382) DESCRIBE `ports` 0.0014550685882568
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038504600524902
(384) DESCRIBE `ports` 0.0014278888702393
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00036501884460449
(386) DESCRIBE `ports` 0.0013580322265625
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.0003058910369873
(388) DESCRIBE `ports` 0.0017349720001221
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00030612945556641
(390) DESCRIBE `ports` 0.0016770362854004
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00038599967956543
(392) DESCRIBE `ports` 0.0019268989562988
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00042104721069336
(394) DESCRIBE `ports` 0.001924991607666
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00041794776916504
(396) DESCRIBE `ports` 0.0019171237945557
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) 0.00040316581726074
(398) DESCRIBE `ports` 0.001723051071167
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') 0.00036096572875977
(400) DESCRIBE `ports` 0.0016880035400391
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042295455932617
(402) DESCRIBE `ports` 0.0016849040985107
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035405158996582
(404) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69229') AND (sailingdate >= '2019-03-19') 0.0086731910705566
(405) DESCRIBE `avid_specials` 0.0018730163574219
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69229 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017428398132324
(407) DESCRIBE `cruiselines` 0.0027530193328857
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00049710273742676
(409) DESCRIBE `orchid_image` 0.0020909309387207
(410) DESCRIBE `cruiselines` 0.0026462078094482
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00048017501831055
(412) DESCRIBE `cruises` 0.0051770210266113
(413) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72824') 0.00058388710021973
(414) DESCRIBE `ships` 0.0039072036743164
(415) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00061988830566406
(416) DESCRIBE `ships` 0.003242015838623
(417) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00047898292541504
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027108192443848
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(420) DESCRIBE `itineraries` 0.0015828609466553
(421) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72824') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011601448059082
(422) DESCRIBE `ports` 0.0018351078033447
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00050997734069824
(424) DESCRIBE `ports` 0.001884937286377
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00033283233642578
(426) DESCRIBE `ports` 0.0016229152679443
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00045680999755859
(428) DESCRIBE `sailingdates` 0.0014669895172119
(429) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72824') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0008699893951416
(430) DESCRIBE `ports` 0.0019760131835938
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0004730224609375
(432) DESCRIBE `ports` 0.0019559860229492
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00040507316589355
(434) DESCRIBE `ports` 0.0016109943389893
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00036501884460449
(436) DESCRIBE `ports` 0.0014259815216064
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00043106079101562
(438) DESCRIBE `ports` 0.001906156539917
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00044798851013184
(440) DESCRIBE `ports` 0.0016610622406006
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0003809928894043
(442) DESCRIBE `ports` 0.0018579959869385
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1973))) 0.0003809928894043
(444) DESCRIBE `ports` 0.0015668869018555
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1973') 0.00034403800964355
(446) DESCRIBE `ports` 0.0014350414276123
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00036096572875977
(448) DESCRIBE `ports` 0.0013251304626465
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00028300285339355
(450) DESCRIBE `ports` 0.0013659000396729
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00040197372436523
(452) DESCRIBE `ports` 0.00154709815979
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00030899047851562
(454) DESCRIBE `ports` 0.0015010833740234
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00033116340637207
(456) DESCRIBE `ports` 0.0014510154724121
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00033688545227051
(458) DESCRIBE `ports` 0.0014839172363281
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.0003211498260498
(460) DESCRIBE `ports` 0.0013730525970459
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0003509521484375
(462) DESCRIBE `ports` 0.0015621185302734
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0003209114074707
(464) DESCRIBE `ports` 0.0016319751739502
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00035405158996582
(466) DESCRIBE `ports` 0.0018138885498047
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00064611434936523
(468) DESCRIBE `ports` 0.0020279884338379
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00043797492980957
(470) DESCRIBE `ports` 0.0018289089202881
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00044798851013184
(472) DESCRIBE `ports` 0.001816987991333
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00040197372436523
(474) DESCRIBE `ports` 0.0018808841705322
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00040292739868164
(476) DESCRIBE `ports` 0.0017828941345215
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00035595893859863
(478) DESCRIBE `ports` 0.0016779899597168
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5613))) 0.00044989585876465
(480) DESCRIBE `ports` 0.0018689632415771
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5613') 0.00039219856262207
(482) DESCRIBE `ports` 0.001568078994751
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00044512748718262
(484) DESCRIBE `ports` 0.0017449855804443
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00046801567077637
(486) DESCRIBE `ports` 0.0017979145050049
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00038886070251465
(488) DESCRIBE `ports` 0.0018179416656494
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00040507316589355
(490) DESCRIBE `ports` 0.0019140243530273
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00040292739868164
(492) DESCRIBE `ports` 0.0017130374908447
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00038480758666992
(494) DESCRIBE `ports` 0.0017189979553223
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00043511390686035
(496) DESCRIBE `ports` 0.0016231536865234
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0003509521484375
(498) DESCRIBE `ports` 0.0015661716461182
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0003809928894043
(500) DESCRIBE `ports` 0.0016999244689941
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00034999847412109
(502) DESCRIBE `ports` 0.0017318725585938
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) 0.00041389465332031
(504) DESCRIBE `ports` 0.0013511180877686
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') 0.00035810470581055
(506) DESCRIBE `ports` 0.001816987991333
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00042891502380371
(508) DESCRIBE `ports` 0.0019040107727051
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0004119873046875
(510) DESCRIBE `ports` 0.0016767978668213
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003361701965332
(512) DESCRIBE `ports` 0.0013391971588135
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002892017364502
(514) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72824') AND (sailingdate >= '2019-03-19') 0.0054171085357666
(515) DESCRIBE `avid_specials` 0.0015120506286621
(516) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72824 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010709762573242
(517) DESCRIBE `cruiselines` 0.0020809173583984
(518) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00057792663574219
(519) DESCRIBE `orchid_image` 0.0021800994873047
(520) DESCRIBE `cruiselines` 0.002810001373291
(521) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00052809715270996
(522) DESCRIBE `cruises` 0.0029029846191406
(523) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69141') 0.00040602684020996
(524) DESCRIBE `ships` 0.0034899711608887
(525) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00054287910461426
(526) DESCRIBE `ships` 0.002924919128418
(527) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00036096572875977
(528) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028896331787109
(529) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028800964355469
(530) DESCRIBE `itineraries` 0.0016310214996338
(531) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69141') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079703330993652
(532) DESCRIBE `ports` 0.0018229484558105
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00042080879211426
(534) DESCRIBE `ports` 0.0013420581817627
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00033712387084961
(536) DESCRIBE `ports` 0.0013859272003174
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00032401084899902
(538) DESCRIBE `sailingdates` 0.0011429786682129
(539) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69141') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053191184997559
(540) DESCRIBE `ports` 0.0016088485717773
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0004570484161377
(542) DESCRIBE `ports` 0.0017280578613281
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0002899169921875
(544) DESCRIBE `ports` 0.0014150142669678
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00035309791564941
(546) DESCRIBE `ports` 0.0013902187347412
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.0003349781036377
(548) DESCRIBE `ports` 0.0016059875488281
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00031590461730957
(550) DESCRIBE `ports` 0.001474142074585
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00033998489379883
(552) DESCRIBE `ports` 0.001366138458252
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1973))) 0.00030779838562012
(554) DESCRIBE `ports` 0.0014309883117676
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1973') 0.00057601928710938
(556) DESCRIBE `ports` 0.0019528865814209
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00043797492980957
(558) DESCRIBE `ports` 0.0018119812011719
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00046801567077637
(560) DESCRIBE `ports` 0.0018258094787598
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00039005279541016
(562) DESCRIBE `ports` 0.0014011859893799
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00029397010803223
(564) DESCRIBE `ports` 0.0013630390167236
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00030088424682617
(566) DESCRIBE `ports` 0.0012900829315186
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00028395652770996
(568) DESCRIBE `ports` 0.0015888214111328
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00036096572875977
(570) DESCRIBE `ports` 0.0014359951019287
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00030994415283203
(572) DESCRIBE `ports` 0.0013480186462402
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034213066101074
(574) DESCRIBE `ports` 0.0017590522766113
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00039982795715332
(576) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69141') AND (sailingdate >= '2019-03-19') 0.0057289600372314
(577) DESCRIBE `avid_specials` 0.0016179084777832
(578) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69141 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015499591827393
(579) DESCRIBE `cruiselines` 0.002932071685791
(580) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00041985511779785
(581) DESCRIBE `orchid_image` 0.001816987991333
(582) DESCRIBE `cruiselines` 0.0020411014556885
(583) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00033402442932129
(584) DESCRIBE `cruises` 0.0031578540802002
(585) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69130') 0.00043296813964844
(586) DESCRIBE `ships` 0.0036928653717041
(587) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00065302848815918
(588) DESCRIBE `ships` 0.0031261444091797
(589) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00054001808166504
(590) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034999847412109
(591) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031113624572754
(592) DESCRIBE `itineraries` 0.001539945602417
(593) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69130') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079178810119629
(594) DESCRIBE `ports` 0.0017669200897217
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.0004889965057373
(596) DESCRIBE `ports` 0.0014679431915283
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00031495094299316
(598) DESCRIBE `ports` 0.0018301010131836
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00039505958557129
(600) DESCRIBE `sailingdates` 0.0012600421905518
(601) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69130') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006871223449707
(602) DESCRIBE `ports` 0.0019659996032715
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00049805641174316
(604) DESCRIBE `ports` 0.0015859603881836
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00032901763916016
(606) DESCRIBE `ports` 0.0020060539245605
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00043606758117676
(608) DESCRIBE `ports` 0.0014328956604004
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00044083595275879
(610) DESCRIBE `ports` 0.0015549659729004
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00047588348388672
(612) DESCRIBE `ports` 0.0015461444854736
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00033211708068848
(614) DESCRIBE `ports` 0.001507043838501
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00035595893859863
(616) DESCRIBE `ports` 0.0014960765838623
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00028800964355469
(618) DESCRIBE `ports` 0.001270055770874
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1780))) 0.00030112266540527
(620) DESCRIBE `ports` 0.0013878345489502
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1780') 0.0003659725189209
(622) DESCRIBE `ports` 0.0018038749694824
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1743))) 0.0003972053527832
(624) DESCRIBE `ports` 0.0017170906066895
(625) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1743') 0.00038909912109375
(626) DESCRIBE `ports` 0.0018179416656494
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00042891502380371
(628) DESCRIBE `ports` 0.0032639503479004
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00041890144348145
(630) DESCRIBE `ports` 0.0017170906066895
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1873))) 0.00042605400085449
(632) DESCRIBE `ports` 0.0016920566558838
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1873') 0.00035190582275391
(634) DESCRIBE `ports` 0.0017728805541992
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00048303604125977
(636) DESCRIBE `ports` 0.0018830299377441
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.0003511905670166
(638) DESCRIBE `ports` 0.002357006072998
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00043106079101562
(640) DESCRIBE `ports` 0.0016191005706787
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00035285949707031
(642) DESCRIBE `ports` 0.0014438629150391
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00036096572875977
(644) DESCRIBE `ports` 0.0014228820800781
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00035905838012695
(646) DESCRIBE `ports` 0.0016829967498779
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00043606758117676
(648) DESCRIBE `ports` 0.0014698505401611
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00031805038452148
(650) DESCRIBE `ports` 0.0012869834899902
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.00036001205444336
(652) DESCRIBE `ports` 0.0014479160308838
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00039410591125488
(654) DESCRIBE `ports` 0.0014481544494629
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1458))) 0.00037407875061035
(656) DESCRIBE `ports` 0.0014619827270508
(657) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1458') 0.00032591819763184
(658) DESCRIBE `ports` 0.0017220973968506
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00034093856811523
(660) DESCRIBE `ports` 0.0014278888702393
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00028491020202637
(662) DESCRIBE `ports` 0.0013868808746338
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00040078163146973
(664) DESCRIBE `ports` 0.0014300346374512
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00034117698669434
(666) DESCRIBE `ports` 0.0013899803161621
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.00038695335388184
(668) DESCRIBE `ports` 0.0016028881072998
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00051498413085938
(670) DESCRIBE `ports` 0.0019571781158447
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) 0.00045490264892578
(672) DESCRIBE `ports` 0.0019009113311768
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') 0.00040507316589355
(674) DESCRIBE `ports` 0.0018470287322998
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.00046086311340332
(676) DESCRIBE `ports` 0.0021071434020996
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00039005279541016
(678) DESCRIBE `ports` 0.0013699531555176
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00032591819763184
(680) DESCRIBE `ports` 0.0013790130615234
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.0003058910369873
(682) DESCRIBE `ports` 0.0013000965118408
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034809112548828
(684) DESCRIBE `ports` 0.0015029907226562
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035214424133301
(686) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69130') AND (sailingdate >= '2019-03-19') 0.0055551528930664
(687) DESCRIBE `avid_specials` 0.001410961151123
(688) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69130 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011038780212402
(689) DESCRIBE `cruiselines` 0.002007007598877
(690) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00040602684020996
(691) DESCRIBE `orchid_image` 0.0015468597412109
(692) DESCRIBE `cruiselines` 0.0025229454040527
(693) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00044417381286621
(694) DESCRIBE `cruises` 0.0032191276550293
(695) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69131') 0.00052094459533691
(696) DESCRIBE `ships` 0.0039870738983154
(697) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00068211555480957
(698) DESCRIBE `ships` 0.0035679340362549
(699) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00048589706420898
(700) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038886070251465
(701) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032901763916016
(702) DESCRIBE `itineraries` 0.0018298625946045
(703) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69131') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065112113952637
(704) DESCRIBE `ports` 0.0016851425170898
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00038409233093262
(706) DESCRIBE `ports` 0.0016191005706787
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00037598609924316
(708) DESCRIBE `ports` 0.0017120838165283
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00037097930908203
(710) DESCRIBE `sailingdates` 0.0015029907226562
(711) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69131') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064396858215332
(712) DESCRIBE `ports` 0.0019488334655762
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00040197372436523
(714) DESCRIBE `ports` 0.0015830993652344
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00034284591674805
(716) DESCRIBE `ports` 0.0014550685882568
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00035500526428223
(718) DESCRIBE `ports` 0.0014188289642334
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00036811828613281
(720) DESCRIBE `ports` 0.00160813331604
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00033402442932129
(722) DESCRIBE `ports` 0.0015139579772949
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00029993057250977
(724) DESCRIBE `ports` 0.0012509822845459
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00033378601074219
(726) DESCRIBE `ports` 0.0015208721160889
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00031900405883789
(728) DESCRIBE `ports` 0.0013740062713623
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1780))) 0.00034403800964355
(730) DESCRIBE `ports` 0.0015559196472168
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1780') 0.00029611587524414
(732) DESCRIBE `ports` 0.0016131401062012
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1743))) 0.00034213066101074
(734) DESCRIBE `ports` 0.0014808177947998
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1743') 0.0003361701965332
(736) DESCRIBE `ports` 0.0014569759368896
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00039386749267578
(738) DESCRIBE `ports` 0.0017340183258057
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00052094459533691
(740) DESCRIBE `ports` 0.0016179084777832
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1873))) 0.0003960132598877
(742) DESCRIBE `ports` 0.0014169216156006
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1873') 0.00034499168395996
(744) DESCRIBE `ports` 0.0019090175628662
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00045514106750488
(746) DESCRIBE `ports` 0.0015239715576172
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00042915344238281
(748) DESCRIBE `ports` 0.0018370151519775
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00052094459533691
(750) DESCRIBE `ports` 0.0018479824066162
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00036907196044922
(752) DESCRIBE `ports` 0.0014610290527344
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00046181678771973
(754) DESCRIBE `ports` 0.0021190643310547
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00053095817565918
(756) DESCRIBE `ports` 0.0019478797912598
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.0004119873046875
(758) DESCRIBE `ports` 0.0017950534820557
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00037503242492676
(760) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69131') AND (sailingdate >= '2019-03-19') 0.0063629150390625
(761) DESCRIBE `avid_specials` 0.0020101070404053
(762) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69131 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015058517456055
(763) DESCRIBE `cruiselines` 0.0021681785583496
(764) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0004270076751709
(765) DESCRIBE `orchid_image` 0.0018420219421387
(766) DESCRIBE `cruiselines` 0.0021419525146484
(767) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043606758117676
(768) DESCRIBE `ships` 0.0037357807159424
(769) SELECT `ships`.* FROM `ships` WHERE (id IN ('850', '1319', '508', '1108', '966', '394')) ORDER BY FIND_IN_SET(id, '850,1319,508,1108,966,394') 0.0012578964233398
(770) DESCRIBE `cruisetypes` 0.0017869472503662
(771) DESCRIBE `destinations` 0.0022480487823486
(772) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '40', '12', '2', '26', '38', '28', '43', '21', '37', '11', '35', '48', '49', '25', '10', '45', '30', '52', '34', '8', '32', '55')) ORDER BY FIND_IN_SET(id, '22,40,12,2,26,38,28,43,21,37,11,35,48,49,25,10,45,30,52,34,8,32,55') 0.0017127990722656
(773) DESCRIBE `cruiselines` 0.0028209686279297
(774) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00040912628173828
(775) DESCRIBE `cruiselines` 0.0031270980834961
(776) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00054502487182617