or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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: 586

Total elapsed time: 0.49684286117554

# Query Time
(1) connect 0.00058293342590332
(2) DESCRIBE `cruises` 0.0020420551300049
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62665, 73127, 68109, 62661, 62653, 70033, 69259, 67957, 68315, 73186)) ORDER BY FIND_IN_SET(id, '62665,73127,68109,62661,62653,70033,69259,67957,68315,73186') 0.0016250610351562
(4) DESCRIBE `cruises` 0.0020930767059326
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00030899047851562
(6) DESCRIBE `ships` 0.0018939971923828
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00039505958557129
(8) DESCRIBE `ships` 0.0018579959869385
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00025582313537598
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021100044250488
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(12) DESCRIBE `itineraries` 0.00094914436340332
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62665') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067281723022461
(14) DESCRIBE `ports` 0.0013251304626465
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00034499168395996
(16) DESCRIBE `ports` 0.00099802017211914
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028491020202637
(18) DESCRIBE `ports` 0.00097203254699707
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026798248291016
(20) DESCRIBE `sailingdates` 0.00087594985961914
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62665') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010099411010742
(22) DESCRIBE `ports` 0.0014450550079346
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00051093101501465
(24) DESCRIBE `ports` 0.0011730194091797
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00030207633972168
(26) DESCRIBE `ports` 0.0010530948638916
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031614303588867
(28) DESCRIBE `ports` 0.0010800361633301
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00041007995605469
(30) DESCRIBE `ports` 0.0010371208190918
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043988227844238
(32) DESCRIBE `ports` 0.0010840892791748
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002901554107666
(34) DESCRIBE `ports` 0.0010619163513184
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0003209114074707
(36) DESCRIBE `ports` 0.00084018707275391
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00023388862609863
(38) DESCRIBE `ports` 0.00083780288696289
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0003058910369873
(40) DESCRIBE `ports` 0.0010480880737305
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029206275939941
(42) DESCRIBE `ports` 0.0010721683502197
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032210350036621
(44) DESCRIBE `ports` 0.0010859966278076
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002899169921875
(46) DESCRIBE `ports` 0.0010771751403809
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00033712387084961
(48) DESCRIBE `ports` 0.0011470317840576
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00034189224243164
(50) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62665') AND (sailingdate >= '2018-12-21') 0.0089678764343262
(51) DESCRIBE `avid_specials` 0.0011730194091797
(52) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62665 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.011457204818726
(53) DESCRIBE `cruiselines` 0.0015451908111572
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034499168395996
(55) DESCRIBE `orchid_image` 0.0010428428649902
(56) DESCRIBE `cruiselines` 0.0013089179992676
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027799606323242
(58) DESCRIBE `cruises` 0.0019137859344482
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73127') 0.0003669261932373
(60) DESCRIBE `ships` 0.0019290447235107
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00043010711669922
(62) DESCRIBE `ships` 0.001957893371582
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00030899047851562
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019502639770508
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(66) DESCRIBE `itineraries` 0.00096511840820312
(67) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73127') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011718273162842
(68) DESCRIBE `ports` 0.0012719631195068
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00029587745666504
(70) DESCRIBE `ports` 0.0008242130279541
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00024986267089844
(72) DESCRIBE `ports` 0.00081300735473633
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0001828670501709
(74) DESCRIBE `sailingdates` 0.000762939453125
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73127') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067710876464844
(76) DESCRIBE `ports` 0.0008690357208252
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00025486946105957
(78) DESCRIBE `ports` 0.00075721740722656
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00024890899658203
(80) DESCRIBE `ports` 0.00083303451538086
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00040292739868164
(82) DESCRIBE `ports` 0.0010828971862793
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027179718017578
(84) DESCRIBE `ports` 0.0010340213775635
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00033998489379883
(86) DESCRIBE `ports` 0.00097203254699707
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00022506713867188
(88) DESCRIBE `ports` 0.0009000301361084
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00031805038452148
(90) DESCRIBE `ports` 0.00079703330993652
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0001828670501709
(92) DESCRIBE `ports` 0.00069284439086914
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00021100044250488
(94) DESCRIBE `ports` 0.00065207481384277
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00022387504577637
(96) DESCRIBE `ports` 0.00062894821166992
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00019288063049316
(98) DESCRIBE `ports` 0.00064611434936523
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00016903877258301
(100) DESCRIBE `ports` 0.0006711483001709
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00019693374633789
(102) DESCRIBE `ports` 0.0006258487701416
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0001671314239502
(104) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73127') AND (sailingdate >= '2018-12-21') 0.0048658847808838
(105) DESCRIBE `avid_specials` 0.00098800659179688
(106) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73127 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0014708042144775
(107) DESCRIBE `cruiselines` 0.00099897384643555
(108) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00026798248291016
(109) DESCRIBE `orchid_image` 0.00081396102905273
(110) DESCRIBE `cruiselines` 0.0010428428649902
(111) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028395652770996
(112) DESCRIBE `cruises` 0.0019190311431885
(113) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68109') 0.0002739429473877
(114) DESCRIBE `ships` 0.0013260841369629
(115) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.0002739429473877
(116) DESCRIBE `ships` 0.0012938976287842
(117) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00020384788513184
(118) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(120) DESCRIBE `itineraries` 0.00067806243896484
(121) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68109') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082588195800781
(122) DESCRIBE `ports` 0.0010571479797363
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024509429931641
(124) DESCRIBE `ports` 0.00073790550231934
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00025486946105957
(126) DESCRIBE `ports` 0.00089001655578613
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00025105476379395
(128) DESCRIBE `sailingdates` 0.00065398216247559
(129) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68109') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061297416687012
(130) DESCRIBE `ports` 0.00078892707824707
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00023102760314941
(132) DESCRIBE `ports` 0.00068092346191406
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018596649169922
(134) DESCRIBE `ports` 0.00062322616577148
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00024199485778809
(136) DESCRIBE `ports` 0.0006258487701416
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016689300537109
(138) DESCRIBE `ports` 0.00058293342590332
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00018596649169922
(140) DESCRIBE `ports` 0.00061607360839844
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00016093254089355
(142) DESCRIBE `ports` 0.00058603286743164
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00018000602722168
(144) DESCRIBE `ports` 0.00059103965759277
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017094612121582
(146) DESCRIBE `ports` 0.00066280364990234
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019121170043945
(148) DESCRIBE `ports` 0.00060606002807617
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017809867858887
(150) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68109') AND (sailingdate >= '2018-12-21') 0.0059640407562256
(151) DESCRIBE `avid_specials` 0.0012671947479248
(152) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68109 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0012178421020508
(153) DESCRIBE `cruiselines` 0.0010709762573242
(154) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00028896331787109
(155) DESCRIBE `orchid_image` 0.00082111358642578
(156) DESCRIBE `cruiselines` 0.001924991607666
(157) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003199577331543
(158) DESCRIBE `cruises` 0.0015859603881836
(159) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00029397010803223
(160) DESCRIBE `ships` 0.0017070770263672
(161) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00032997131347656
(162) DESCRIBE `ships` 0.0012381076812744
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00018692016601562
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015592575073242
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014591217041016
(166) DESCRIBE `itineraries` 0.00060200691223145
(167) DESCRIBE `ports` 0.00062990188598633
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019288063049316
(169) DESCRIBE `ports` 0.00059199333190918
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00017786026000977
(171) DESCRIBE `ports` 0.00059604644775391
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00016498565673828
(173) DESCRIBE `sailingdates` 0.00055694580078125
(174) DESCRIBE `ports` 0.00075984001159668
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021791458129883
(176) DESCRIBE `ports` 0.00061511993408203
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017380714416504
(178) DESCRIBE `ports` 0.00062298774719238
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021719932556152
(180) DESCRIBE `ports` 0.00059795379638672
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016593933105469
(182) DESCRIBE `ports` 0.00065207481384277
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00019192695617676
(184) DESCRIBE `ports` 0.00063490867614746
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00017094612121582
(186) DESCRIBE `ports` 0.0005948543548584
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00018405914306641
(188) DESCRIBE `ports` 0.00059390068054199
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00017118453979492
(190) DESCRIBE `ports` 0.00074887275695801
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0001988410949707
(192) DESCRIBE `ports` 0.00072884559631348
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021600723266602
(194) DESCRIBE `ports` 0.00092792510986328
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026488304138184
(196) DESCRIBE `ports` 0.00089693069458008
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00022697448730469
(198) DESCRIBE `ports` 0.00089502334594727
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024700164794922
(200) DESCRIBE `ports` 0.00082492828369141
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00020885467529297
(202) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62661') AND (sailingdate >= '2018-12-21') 0.0097391605377197
(203) DESCRIBE `avid_specials` 0.0010330677032471
(204) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0014979839324951
(205) DESCRIBE `cruiselines` 0.0012879371643066
(206) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00028419494628906
(207) DESCRIBE `orchid_image` 0.00098299980163574
(208) DESCRIBE `cruiselines` 0.0012660026550293
(209) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00024700164794922
(210) DESCRIBE `cruises` 0.0017061233520508
(211) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62653') 0.00027799606323242
(212) DESCRIBE `ships` 0.0020091533660889
(213) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00038290023803711
(214) DESCRIBE `ships` 0.0020160675048828
(215) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.0002739429473877
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019001960754395
(218) DESCRIBE `itineraries` 0.0009307861328125
(219) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62653') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001270055770874
(220) DESCRIBE `ports` 0.0010960102081299
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00027108192443848
(222) DESCRIBE `ports` 0.00092911720275879
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00023579597473145
(224) DESCRIBE `ports` 0.00088906288146973
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00022482872009277
(226) DESCRIBE `sailingdates` 0.00077295303344727
(227) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62653') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070381164550781
(228) DESCRIBE `ports` 0.0012149810791016
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003049373626709
(230) DESCRIBE `ports` 0.00084900856018066
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00023293495178223
(232) DESCRIBE `ports` 0.00090885162353516
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00025105476379395
(234) DESCRIBE `ports` 0.0006411075592041
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00017809867858887
(236) DESCRIBE `ports` 0.00059795379638672
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00020718574523926
(238) DESCRIBE `ports` 0.00080585479736328
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00035905838012695
(240) DESCRIBE `ports` 0.0010201930999756
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00026798248291016
(242) DESCRIBE `ports` 0.0015759468078613
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00037479400634766
(244) DESCRIBE `ports` 0.0010380744934082
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00031399726867676
(246) DESCRIBE `ports` 0.00097799301147461
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00026988983154297
(248) DESCRIBE `ports` 0.00090980529785156
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00025701522827148
(250) DESCRIBE `ports` 0.0010199546813965
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00029897689819336
(252) DESCRIBE `ports` 0.00090599060058594
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00026106834411621
(254) DESCRIBE `ports` 0.00083684921264648
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00023794174194336
(256) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62653') AND (sailingdate >= '2018-12-21') 0.0083601474761963
(257) DESCRIBE `avid_specials` 0.001115083694458
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62653 and class = 'Cruise') OR (item_id = 738 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0013890266418457
(259) DESCRIBE `cruiselines` 0.0010418891906738
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024199485778809
(261) DESCRIBE `orchid_image` 0.00072383880615234
(262) DESCRIBE `cruiselines` 0.0012400150299072
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00026988983154297
(264) DESCRIBE `cruises` 0.0020358562469482
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70033') 0.0003359317779541
(266) DESCRIBE `ships` 0.0017759799957275
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00035715103149414
(268) DESCRIBE `ships` 0.0017950534820557
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00026798248291016
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00019097328186035
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018095970153809
(272) DESCRIBE `itineraries` 0.00084090232849121
(273) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012729167938232
(274) DESCRIBE `ports` 0.00097489356994629
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00029397010803223
(276) DESCRIBE `ports` 0.00079894065856934
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019001960754395
(278) DESCRIBE `ports` 0.00065302848815918
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017595291137695
(280) DESCRIBE `sailingdates` 0.00053596496582031
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005640983581543
(282) DESCRIBE `ports` 0.00077605247497559
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022721290588379
(284) DESCRIBE `ports` 0.00060915946960449
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017690658569336
(286) DESCRIBE `ports` 0.00059986114501953
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018692016601562
(288) DESCRIBE `ports` 0.00059008598327637
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016307830810547
(290) DESCRIBE `ports` 0.00062298774719238
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00029993057250977
(292) DESCRIBE `ports` 0.0010318756103516
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00023579597473145
(294) DESCRIBE `ports` 0.0008399486541748
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00025510787963867
(296) DESCRIBE `ports` 0.00081014633178711
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00018405914306641
(298) DESCRIBE `ports` 0.00074601173400879
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020003318786621
(300) DESCRIBE `ports` 0.00064587593078613
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00020313262939453
(302) DESCRIBE `ports` 0.00066995620727539
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00021219253540039
(304) DESCRIBE `ports` 0.0007319450378418
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00020503997802734
(306) DESCRIBE `ports` 0.00070500373840332
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018906593322754
(308) DESCRIBE `ports` 0.00064706802368164
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018501281738281
(310) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70033') AND (sailingdate >= '2018-12-21') 0.0050959587097168
(311) DESCRIBE `avid_specials` 0.0009920597076416
(312) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70033 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.00146484375
(313) DESCRIBE `cruiselines` 0.0012760162353516
(314) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023198127746582
(315) DESCRIBE `orchid_image` 0.00073409080505371
(316) DESCRIBE `cruiselines` 0.00084900856018066
(317) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019502639770508
(318) DESCRIBE `cruises` 0.0022330284118652
(319) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69259') 0.00034618377685547
(320) DESCRIBE `ships` 0.0022900104522705
(321) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.0004420280456543
(322) DESCRIBE `ships` 0.0022070407867432
(323) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00032997131347656
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019693374633789
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(326) DESCRIBE `itineraries` 0.00098299980163574
(327) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69259') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012221336364746
(328) DESCRIBE `ports` 0.0011720657348633
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00030779838562012
(330) DESCRIBE `ports` 0.0010139942169189
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00027298927307129
(332) DESCRIBE `ports` 0.00084590911865234
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0002439022064209
(334) DESCRIBE `sailingdates` 0.0010290145874023
(335) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69259') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070285797119141
(336) DESCRIBE `ports` 0.0010440349578857
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0002899169921875
(338) DESCRIBE `ports` 0.00095295906066895
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00023889541625977
(340) DESCRIBE `ports` 0.00088787078857422
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2442))) 0.00023508071899414
(342) DESCRIBE `ports` 0.00066304206848145
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2442') 0.00017595291137695
(344) DESCRIBE `ports` 0.00074505805969238
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00020194053649902
(346) DESCRIBE `ports` 0.00084614753723145
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00025200843811035
(348) DESCRIBE `ports` 0.00089502334594727
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00026082992553711
(350) DESCRIBE `ports` 0.00092601776123047
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00023078918457031
(352) DESCRIBE `ports` 0.00091195106506348
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00021791458129883
(354) DESCRIBE `ports` 0.00075387954711914
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00018000602722168
(356) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69259') AND (sailingdate >= '2018-12-21') 0.0047991275787354
(357) DESCRIBE `avid_specials` 0.00073409080505371
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69259 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.00095415115356445
(359) DESCRIBE `cruiselines` 0.00095796585083008
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002129077911377
(361) DESCRIBE `orchid_image` 0.00069594383239746
(362) DESCRIBE `cruiselines` 0.00082087516784668
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027799606323242
(364) DESCRIBE `cruises` 0.0020608901977539
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67957') 0.00030398368835449
(366) DESCRIBE `ships` 0.0016450881958008
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00024104118347168
(368) DESCRIBE `ships` 0.0012381076812744
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00017189979553223
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014519691467285
(372) DESCRIBE `itineraries` 0.00063586235046387
(373) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67957') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049400329589844
(374) DESCRIBE `ports` 0.00076985359191895
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019693374633789
(376) DESCRIBE `ports` 0.00064301490783691
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00016903877258301
(378) DESCRIBE `ports` 0.00059080123901367
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016999244689941
(380) DESCRIBE `sailingdates` 0.00052404403686523
(381) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67957') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00085806846618652
(382) DESCRIBE `ports` 0.00072097778320312
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020909309387207
(384) DESCRIBE `ports` 0.00061392784118652
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016593933105469
(386) DESCRIBE `ports` 0.0008089542388916
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00018715858459473
(388) DESCRIBE `ports` 0.00063395500183105
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016403198242188
(390) DESCRIBE `ports` 0.00062322616577148
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00017499923706055
(392) DESCRIBE `ports` 0.0005950927734375
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00015878677368164
(394) DESCRIBE `ports` 0.00059008598327637
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.0001838207244873
(396) DESCRIBE `ports` 0.00063800811767578
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0001671314239502
(398) DESCRIBE `ports` 0.00059199333190918
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00018215179443359
(400) DESCRIBE `ports` 0.0007929801940918
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00021195411682129
(402) DESCRIBE `ports` 0.00059890747070312
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00018310546875
(404) DESCRIBE `ports` 0.00061511993408203
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016403198242188
(406) DESCRIBE `ports` 0.00060796737670898
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00017809867858887
(408) DESCRIBE `ports` 0.00059318542480469
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00015783309936523
(410) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67957') AND (sailingdate >= '2018-12-21') 0.0047550201416016
(411) DESCRIBE `avid_specials` 0.00082302093505859
(412) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67957 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0014779567718506
(413) DESCRIBE `cruiselines` 0.0013980865478516
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025296211242676
(415) DESCRIBE `orchid_image` 0.00075411796569824
(416) DESCRIBE `cruiselines` 0.0010080337524414
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019192695617676
(418) DESCRIBE `cruises` 0.0016160011291504
(419) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68315') 0.00021886825561523
(420) DESCRIBE `ships` 0.0015208721160889
(421) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00026798248291016
(422) DESCRIBE `ships` 0.0013360977172852
(423) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.0001990795135498
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015616416931152
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014495849609375
(426) DESCRIBE `itineraries` 0.0006258487701416
(427) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68315') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012309551239014
(428) DESCRIBE `ports` 0.00081205368041992
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00023984909057617
(430) DESCRIBE `ports` 0.00078296661376953
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00027799606323242
(432) DESCRIBE `ports` 0.00093197822570801
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.0002281665802002
(434) DESCRIBE `sailingdates` 0.0010080337524414
(435) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68315') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070810317993164
(436) DESCRIBE `ports` 0.00088787078857422
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00024199485778809
(438) DESCRIBE `ports` 0.00068378448486328
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00017595291137695
(440) DESCRIBE `ports` 0.00059700012207031
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00018906593322754
(442) DESCRIBE `ports` 0.00059199333190918
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00016689300537109
(444) DESCRIBE `ports` 0.00061702728271484
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00017881393432617
(446) DESCRIBE `ports` 0.00058794021606445
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00016212463378906
(448) DESCRIBE `ports` 0.00064897537231445
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00017786026000977
(450) DESCRIBE `ports` 0.00062799453735352
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00016212463378906
(452) DESCRIBE `ports` 0.00087904930114746
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00038909912109375
(454) DESCRIBE `ports` 0.0011320114135742
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00028181076049805
(456) DESCRIBE `ports` 0.00095796585083008
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00033402442932129
(458) DESCRIBE `ports` 0.0010049343109131
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00028395652770996
(460) DESCRIBE `ports` 0.00098085403442383
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00034189224243164
(462) DESCRIBE `ports` 0.0010900497436523
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00045204162597656
(464) DESCRIBE `ports` 0.0010619163513184
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00025200843811035
(466) DESCRIBE `ports` 0.00085997581481934
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00022506713867188
(468) DESCRIBE `ports` 0.00085115432739258
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00025796890258789
(470) DESCRIBE `ports` 0.00086712837219238
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00022196769714355
(472) DESCRIBE `ports` 0.0008399486541748
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00023603439331055
(474) DESCRIBE `ports` 0.00083708763122559
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00021505355834961
(476) DESCRIBE `ports` 0.00083804130554199
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00023818016052246
(478) DESCRIBE `ports` 0.00084209442138672
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00021100044250488
(480) DESCRIBE `ports` 0.00083708763122559
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.000244140625
(482) DESCRIBE `ports` 0.00088310241699219
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00024890899658203
(484) DESCRIBE `ports` 0.0009300708770752
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00031185150146484
(486) DESCRIBE `ports` 0.0010149478912354
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00025200843811035
(488) DESCRIBE `ports` 0.00086784362792969
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00024700164794922
(490) DESCRIBE `ports` 0.00094914436340332
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00025296211242676
(492) DESCRIBE `ports` 0.00095391273498535
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00029802322387695
(494) DESCRIBE `ports` 0.00091814994812012
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00022792816162109
(496) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68315') AND (sailingdate >= '2018-12-21') 0.008275032043457
(497) DESCRIBE `avid_specials` 0.0010600090026855
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68315 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 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.0014710426330566
(499) DESCRIBE `cruiselines` 0.001399040222168
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030708312988281
(501) DESCRIBE `orchid_image` 0.00098395347595215
(502) DESCRIBE `cruiselines` 0.001227855682373
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00025320053100586
(504) DESCRIBE `cruises` 0.0019059181213379
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73186') 0.00029492378234863
(506) DESCRIBE `ships` 0.0018990039825439
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00038814544677734
(508) DESCRIBE `ships` 0.0020349025726318
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00029301643371582
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00020885467529297
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00019598007202148
(512) DESCRIBE `itineraries` 0.00095796585083008
(513) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73186') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062680244445801
(514) DESCRIBE `ports` 0.0011940002441406
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030207633972168
(516) DESCRIBE `ports` 0.00087809562683105
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024008750915527
(518) DESCRIBE `ports` 0.00091004371643066
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00024294853210449
(520) DESCRIBE `sailingdates` 0.00082802772521973
(521) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73186') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.010638952255249
(522) DESCRIBE `ports` 0.00092411041259766
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024700164794922
(524) DESCRIBE `ports` 0.00065994262695312
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018501281738281
(526) DESCRIBE `ports` 0.00068807601928711
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00029492378234863
(528) DESCRIBE `ports` 0.00091886520385742
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00078701972961426
(530) DESCRIBE `ports` 0.0006558895111084
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020003318786621
(532) DESCRIBE `ports` 0.00081801414489746
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00022387504577637
(534) DESCRIBE `ports` 0.00082707405090332
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.0064311027526855
(536) DESCRIBE `ports` 0.00089192390441895
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00020694732666016
(538) DESCRIBE `ports` 0.00062394142150879
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020790100097656
(540) DESCRIBE `ports` 0.0006868839263916
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017905235290527
(542) DESCRIBE `ports` 0.00062704086303711
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00022602081298828
(544) DESCRIBE `ports` 0.00066900253295898
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00019502639770508
(546) DESCRIBE `ports` 0.00060200691223145
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024604797363281
(548) DESCRIBE `ports` 0.00088906288146973
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0047671794891357
(550) DESCRIBE `ports` 0.0009300708770752
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00024008750915527
(552) DESCRIBE `ports` 0.0006248950958252
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00018692016601562
(554) DESCRIBE `ports` 0.00063085556030273
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00019288063049316
(556) DESCRIBE `ports` 0.00060606002807617
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00017189979553223
(558) DESCRIBE `ports` 0.00060296058654785
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020003318786621
(560) DESCRIBE `ports` 0.0080249309539795
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00034904479980469
(562) DESCRIBE `ports` 0.00082302093505859
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020098686218262
(564) DESCRIBE `ports` 0.00073909759521484
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018692016601562
(566) DESCRIBE `ports` 0.00062108039855957
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001981258392334
(568) DESCRIBE `ports` 0.00060415267944336
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017404556274414
(570) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73186') AND (sailingdate >= '2018-12-21') 0.0046579837799072
(571) DESCRIBE `avid_specials` 0.00083398818969727
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73186 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.00099897384643555
(573) DESCRIBE `cruiselines` 0.00096607208251953
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024199485778809
(575) DESCRIBE `orchid_image` 0.00072717666625977
(576) DESCRIBE `cruiselines` 0.00089097023010254
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020599365234375
(578) DESCRIBE `ships` 0.0073308944702148
(579) SELECT `ships`.* FROM `ships` WHERE (id IN ('1599', '1359', '1067', '462', '766', '553', '407', '1415', '738', '977', '452', '726', '610', '674', '1588')) ORDER BY FIND_IN_SET(id, '1599,1359,1067,462,766,553,407,1415,738,977,452,726,610,674,1588') 0.00080394744873047
(580) DESCRIBE `cruisetypes` 0.0008549690246582
(581) DESCRIBE `destinations` 0.0054340362548828
(582) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '52', '40', '45', '38', '28', '35')) ORDER BY FIND_IN_SET(id, '22,12,52,40,45,38,28,35') 0.0026688575744629
(583) DESCRIBE `cruiselines` 0.0067369937896729
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036501884460449
(585) DESCRIBE `cruiselines` 0.0073750019073486
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00146484375