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

Total elapsed time: 0.37917423248291

# Query Time
(1) connect 0.00045990943908691
(2) DESCRIBE `cruises` 0.0020890235900879
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63485, 63881, 64571, 43647, 25176, 41654, 69348, 66243, 63719, 63444)) ORDER BY FIND_IN_SET(id, '63485,63881,64571,43647,25176,41654,69348,66243,63719,63444') 0.0014371871948242
(4) DESCRIBE `cruises` 0.0016179084777832
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63485') 0.00025415420532227
(6) DESCRIBE `ships` 0.0012588500976562
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1088))) 0.00023984909057617
(8) DESCRIBE `ships` 0.0012450218200684
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1088') 0.00020980834960938
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021719932556152
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(12) DESCRIBE `itineraries` 0.00072598457336426
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63485') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005950927734375
(14) DESCRIBE `ports` 0.00073003768920898
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024795532226562
(16) DESCRIBE `ports` 0.00062298774719238
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018906593322754
(18) DESCRIBE `ports` 0.0006248950958252
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017404556274414
(20) DESCRIBE `sailingdates` 0.00054693222045898
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63485') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00093293190002441
(22) DESCRIBE `ports` 0.0010809898376465
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025606155395508
(24) DESCRIBE `ports` 0.00066614151000977
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018000602722168
(26) DESCRIBE `ports` 0.00059390068054199
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00020599365234375
(28) DESCRIBE `ports` 0.00061297416687012
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00016307830810547
(30) DESCRIBE `ports` 0.00060701370239258
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.0001828670501709
(32) DESCRIBE `ports` 0.00063014030456543
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00017595291137695
(34) DESCRIBE `ports` 0.00061321258544922
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00017380714416504
(36) DESCRIBE `ports` 0.0006258487701416
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00016498565673828
(38) DESCRIBE `ports` 0.00063419342041016
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00018596649169922
(40) DESCRIBE `ports` 0.00064992904663086
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016307830810547
(42) DESCRIBE `ports` 0.0005958080291748
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018787384033203
(44) DESCRIBE `ports` 0.00059008598327637
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016498565673828
(46) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63485') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0048058032989502
(47) DESCRIBE `avid_specials` 0.00096821784973145
(48) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63485 and class = 'Cruise') OR (item_id = 1088 AND class = 'Ship') OR (item_id = 20 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.0015180110931396
(49) DESCRIBE `cruiselines` 0.0012128353118896
(50) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030016899108887
(51) DESCRIBE `orchid_image` 0.0010039806365967
(52) DESCRIBE `cruiselines` 0.00088214874267578
(53) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020217895507812
(54) DESCRIBE `cruises` 0.0012609958648682
(55) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63881') 0.00021195411682129
(56) DESCRIBE `ships` 0.0011751651763916
(57) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 314))) 0.00023007392883301
(58) DESCRIBE `ships` 0.0012140274047852
(59) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '314') 0.00017404556274414
(60) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001530647277832
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014209747314453
(62) DESCRIBE `itineraries` 0.00062203407287598
(63) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63881') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063514709472656
(64) DESCRIBE `ports` 0.00068402290344238
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0002140998840332
(66) DESCRIBE `ports` 0.00061702728271484
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00017499923706055
(68) DESCRIBE `ports` 0.00058603286743164
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016307830810547
(70) DESCRIBE `sailingdates` 0.00054407119750977
(71) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63881') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057196617126465
(72) DESCRIBE `ports` 0.000701904296875
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0002129077911377
(74) DESCRIBE `ports` 0.00059103965759277
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016903877258301
(76) DESCRIBE `ports` 0.00064206123352051
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00018095970153809
(78) DESCRIBE `ports` 0.00058698654174805
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00015997886657715
(80) DESCRIBE `ports` 0.00058913230895996
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00021100044250488
(82) DESCRIBE `ports` 0.0007941722869873
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00015807151794434
(84) DESCRIBE `ports` 0.00058698654174805
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.0001981258392334
(86) DESCRIBE `ports` 0.00063800811767578
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00016093254089355
(88) DESCRIBE `ports` 0.00062394142150879
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00017499923706055
(90) DESCRIBE `ports` 0.00062394142150879
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00017905235290527
(92) DESCRIBE `ports` 0.00060009956359863
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0001978874206543
(94) DESCRIBE `ports` 0.00065398216247559
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00015997886657715
(96) DESCRIBE `ports` 0.00062298774719238
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00017690658569336
(98) DESCRIBE `ports` 0.00058102607727051
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00037503242492676
(100) DESCRIBE `ports` 0.00086188316345215
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020503997802734
(102) DESCRIBE `ports` 0.0010578632354736
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0003349781036377
(104) DESCRIBE `ports` 0.0011370182037354
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00021100044250488
(106) DESCRIBE `ports` 0.0006721019744873
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00017690658569336
(108) DESCRIBE `ports` 0.00069785118103027
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020813941955566
(110) DESCRIBE `ports` 0.00066113471984863
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017189979553223
(112) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63881') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0053319931030273
(113) DESCRIBE `avid_specials` 0.00066685676574707
(114) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63881 and class = 'Cruise') OR (item_id = 314 AND class = 'Ship') OR (item_id = 20 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.0010089874267578
(115) DESCRIBE `cruiselines` 0.0010380744934082
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022006034851074
(117) DESCRIBE `orchid_image` 0.000762939453125
(118) DESCRIBE `cruiselines` 0.00095200538635254
(119) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018000602722168
(120) DESCRIBE `cruises` 0.0014009475708008
(121) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64571') 0.00021100044250488
(122) DESCRIBE `ships` 0.0013470649719238
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 665))) 0.00023794174194336
(124) DESCRIBE `ships` 0.0013740062713623
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '665') 0.00020289421081543
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022602081298828
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(128) DESCRIBE `itineraries` 0.0007178783416748
(129) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64571') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005791187286377
(130) DESCRIBE `ports` 0.00069713592529297
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022101402282715
(132) DESCRIBE `ports` 0.00068283081054688
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022602081298828
(134) DESCRIBE `ports` 0.0006721019744873
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001828670501709
(136) DESCRIBE `sailingdates` 0.00059819221496582
(137) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64571') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006260871887207
(138) DESCRIBE `ports` 0.00069999694824219
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020813941955566
(140) DESCRIBE `ports` 0.0006868839263916
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001828670501709
(142) DESCRIBE `ports` 0.00065898895263672
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020503997802734
(144) DESCRIBE `ports` 0.00065803527832031
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017714500427246
(146) DESCRIBE `ports` 0.00070095062255859
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00027918815612793
(148) DESCRIBE `ports` 0.00069999694824219
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018000602722168
(150) DESCRIBE `ports` 0.00083208084106445
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00020599365234375
(152) DESCRIBE `ports` 0.00066399574279785
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00018000602722168
(154) DESCRIBE `ports` 0.00065898895263672
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00019192695617676
(156) DESCRIBE `ports` 0.00066399574279785
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00017499923706055
(158) DESCRIBE `ports` 0.00068497657775879
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00022101402282715
(160) DESCRIBE `ports` 0.00066018104553223
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00018095970153809
(162) DESCRIBE `ports` 0.00067496299743652
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020003318786621
(164) DESCRIBE `ports` 0.00066089630126953
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017309188842773
(166) DESCRIBE `ports` 0.0007021427154541
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002138614654541
(168) DESCRIBE `ports` 0.00069499015808105
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018000602722168
(170) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64571') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0053410530090332
(171) DESCRIBE `avid_specials` 0.00065183639526367
(172) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64571 and class = 'Cruise') OR (item_id = 665 AND class = 'Ship') OR (item_id = 20 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.00096416473388672
(173) DESCRIBE `cruiselines` 0.0009758472442627
(174) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021600723266602
(175) DESCRIBE `orchid_image` 0.00076889991760254
(176) DESCRIBE `cruiselines` 0.00092911720275879
(177) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018310546875
(178) DESCRIBE `cruises` 0.0013761520385742
(179) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43647') 0.00020408630371094
(180) DESCRIBE `ships` 0.0013718605041504
(181) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00024914741516113
(182) DESCRIBE `ships` 0.0013220310211182
(183) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.0001990795135498
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020599365234375
(185) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002131462097168
(186) DESCRIBE `itineraries` 0.00075411796569824
(187) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '43647') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055789947509766
(188) DESCRIBE `ports` 0.0010769367218018
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002601146697998
(190) DESCRIBE `ports` 0.00060606002807617
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018215179443359
(192) DESCRIBE `ports` 0.0005950927734375
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017690658569336
(194) DESCRIBE `sailingdates` 0.00053691864013672
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '43647') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083613395690918
(196) DESCRIBE `ports` 0.00089097023010254
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023698806762695
(198) DESCRIBE `ports` 0.00061702728271484
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017404556274414
(200) DESCRIBE `ports` 0.00059199333190918
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2559))) 0.00018620491027832
(202) DESCRIBE `ports` 0.00059390068054199
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2559') 0.00019097328186035
(204) DESCRIBE `ports` 0.00059008598327637
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00018191337585449
(206) DESCRIBE `ports` 0.00059294700622559
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00016188621520996
(208) DESCRIBE `ports` 0.00058794021606445
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00019407272338867
(210) DESCRIBE `ports` 0.00058507919311523
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00017595291137695
(212) DESCRIBE `ports` 0.00058603286743164
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001838207244873
(214) DESCRIBE `ports` 0.00058817863464355
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016283988952637
(216) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '43647') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0047848224639893
(217) DESCRIBE `avid_specials` 0.00074100494384766
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43647 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.00090909004211426
(219) DESCRIBE `cruiselines` 0.00093197822570801
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023412704467773
(221) DESCRIBE `orchid_image` 0.00066089630126953
(222) DESCRIBE `cruiselines` 0.00081110000610352
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00016593933105469
(224) DESCRIBE `cruises` 0.0011639595031738
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.00018310546875
(226) DESCRIBE `ships` 0.001168966293335
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00025105476379395
(228) DESCRIBE `ships` 0.0011429786682129
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00016498565673828
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015616416931152
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(232) DESCRIBE `itineraries` 0.0005950927734375
(233) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '25176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051188468933105
(234) DESCRIBE `ports` 0.00063896179199219
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0001978874206543
(236) DESCRIBE `ports` 0.00058698654174805
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00016999244689941
(238) DESCRIBE `ports` 0.00058698654174805
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00016188621520996
(240) DESCRIBE `sailingdates` 0.00052404403686523
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '25176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005640983581543
(242) DESCRIBE `ports` 0.00069904327392578
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00019502639770508
(244) DESCRIBE `ports` 0.00058484077453613
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00016999244689941
(246) DESCRIBE `ports` 0.00058412551879883
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00017404556274414
(248) DESCRIBE `ports` 0.0005800724029541
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.0001678466796875
(250) DESCRIBE `ports` 0.00058102607727051
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00018405914306641
(252) DESCRIBE `ports` 0.0005800724029541
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00016212463378906
(254) DESCRIBE `ports` 0.00058102607727051
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0001680850982666
(256) DESCRIBE `ports` 0.00057792663574219
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00015902519226074
(258) DESCRIBE `ports` 0.00057792663574219
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00016903877258301
(260) DESCRIBE `ports` 0.00057506561279297
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00015997886657715
(262) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '25176') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0045650005340576
(263) DESCRIBE `avid_specials` 0.00069618225097656
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.00088810920715332
(265) DESCRIBE `cruiselines` 0.00095891952514648
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021815299987793
(267) DESCRIBE `orchid_image` 0.00069284439086914
(268) DESCRIBE `cruiselines` 0.00082302093505859
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018477439880371
(270) DESCRIBE `cruises` 0.0012950897216797
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41654') 0.00022196769714355
(272) DESCRIBE `ships` 0.0012021064758301
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1008))) 0.00029087066650391
(274) DESCRIBE `ships` 0.0012397766113281
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1008') 0.00017619132995605
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015807151794434
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014805793762207
(278) DESCRIBE `itineraries` 0.00059199333190918
(279) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41654') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049209594726562
(280) DESCRIBE `ports` 0.0006260871887207
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00026202201843262
(282) DESCRIBE `ports` 0.00074601173400879
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00019097328186035
(284) DESCRIBE `ports` 0.00064611434936523
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00021219253540039
(286) DESCRIBE `sailingdates` 0.00056791305541992
(287) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41654') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006411075592041
(288) DESCRIBE `ports` 0.00068902969360352
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00021004676818848
(290) DESCRIBE `ports` 0.00058889389038086
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00016093254089355
(292) DESCRIBE `ports` 0.00058603286743164
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00017786026000977
(294) DESCRIBE `ports` 0.00058698654174805
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0001530647277832
(296) DESCRIBE `ports` 0.00058698654174805
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00016903877258301
(298) DESCRIBE `ports` 0.00066590309143066
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00018501281738281
(300) DESCRIBE `ports` 0.0007321834564209
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0002291202545166
(302) DESCRIBE `ports` 0.00063204765319824
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00017690658569336
(304) DESCRIBE `ports` 0.00062894821166992
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00017690658569336
(306) DESCRIBE `ports` 0.00061798095703125
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00015807151794434
(308) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41654') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0048418045043945
(309) DESCRIBE `avid_specials` 0.00086402893066406
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41654 and class = 'Cruise') OR (item_id = 1008 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.00092887878417969
(311) DESCRIBE `cruiselines` 0.00092792510986328
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022602081298828
(313) DESCRIBE `orchid_image` 0.00071907043457031
(314) DESCRIBE `cruiselines` 0.000885009765625
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00025415420532227
(316) DESCRIBE `cruises` 0.0012459754943848
(317) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69348') 0.00020694732666016
(318) DESCRIBE `ships` 0.0012218952178955
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00024008750915527
(320) DESCRIBE `ships` 0.0012588500976562
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.00018692016601562
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015997886657715
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014901161193848
(324) DESCRIBE `itineraries` 0.00064301490783691
(325) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69348') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050187110900879
(326) DESCRIBE `ports` 0.00063085556030273
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001990795135498
(328) DESCRIBE `ports` 0.00069093704223633
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022006034851074
(330) DESCRIBE `ports` 0.0007021427154541
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019097328186035
(332) DESCRIBE `sailingdates` 0.00058984756469727
(333) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69348') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041913986206055
(334) DESCRIBE `ports` 0.00077199935913086
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020885467529297
(336) DESCRIBE `ports` 0.00069689750671387
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018405914306641
(338) DESCRIBE `ports` 0.00072503089904785
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2559))) 0.00020217895507812
(340) DESCRIBE `ports` 0.00071597099304199
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2559') 0.00018596649169922
(342) DESCRIBE `ports` 0.00066900253295898
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00021886825561523
(344) DESCRIBE `ports` 0.00060486793518066
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00016593933105469
(346) DESCRIBE `ports` 0.00081491470336914
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022292137145996
(348) DESCRIBE `ports` 0.00063204765319824
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017905235290527
(350) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69348') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0046257972717285
(351) DESCRIBE `avid_specials` 0.00074291229248047
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69348 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.00090312957763672
(353) DESCRIBE `cruiselines` 0.0009000301361084
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021100044250488
(355) DESCRIBE `orchid_image` 0.00071406364440918
(356) DESCRIBE `cruiselines` 0.00090503692626953
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0001990795135498
(358) DESCRIBE `cruises` 0.0012578964233398
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66243') 0.00026988983154297
(360) DESCRIBE `ships` 0.001633882522583
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 212))) 0.0019991397857666
(362) DESCRIBE `ships` 0.0017621517181396
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '212') 0.00023007392883301
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016188621520996
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015091896057129
(366) DESCRIBE `itineraries` 0.00068092346191406
(367) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66243') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056195259094238
(368) DESCRIBE `ports` 0.00097990036010742
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.000244140625
(370) DESCRIBE `ports` 0.00059700012207031
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00018000602722168
(372) DESCRIBE `ports` 0.00060105323791504
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00017714500427246
(374) DESCRIBE `sailingdates` 0.00054502487182617
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66243') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062203407287598
(376) DESCRIBE `ports` 0.00069594383239746
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00022196769714355
(378) DESCRIBE `ports` 0.00060796737670898
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00017189979553223
(380) DESCRIBE `ports` 0.00059604644775391
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00018000602722168
(382) DESCRIBE `ports` 0.00059986114501953
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00019288063049316
(384) DESCRIBE `ports` 0.00063109397888184
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00018000602722168
(386) DESCRIBE `ports` 0.0005950927734375
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00017285346984863
(388) DESCRIBE `ports` 0.0005950927734375
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00018501281738281
(390) DESCRIBE `ports` 0.00059103965759277
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00016498565673828
(392) DESCRIBE `ports` 0.00060009956359863
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00019598007202148
(394) DESCRIBE `ports` 0.00063610076904297
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00017690658569336
(396) DESCRIBE `ports` 0.00060486793518066
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0001990795135498
(398) DESCRIBE `ports` 0.00059604644775391
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00016593933105469
(400) DESCRIBE `ports` 0.00066900253295898
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.0001828670501709
(402) DESCRIBE `ports` 0.00059008598327637
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00016498565673828
(404) DESCRIBE `ports` 0.00059103965759277
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00018095970153809
(406) DESCRIBE `ports` 0.00062394142150879
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00016212463378906
(408) DESCRIBE `ports` 0.00059390068054199
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00020122528076172
(410) DESCRIBE `ports` 0.00070691108703613
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00017499923706055
(412) DESCRIBE `ports` 0.00061798095703125
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00019693374633789
(414) DESCRIBE `ports` 0.00065302848815918
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00018596649169922
(416) DESCRIBE `ports` 0.00060796737670898
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00018692016601562
(418) DESCRIBE `ports` 0.00059700012207031
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00016403198242188
(420) DESCRIBE `ports` 0.00058889389038086
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.0001828670501709
(422) DESCRIBE `ports` 0.00059890747070312
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.0001680850982666
(424) DESCRIBE `ports` 0.00059700012207031
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00018906593322754
(426) DESCRIBE `ports` 0.00059199333190918
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00017118453979492
(428) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66243') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0047519207000732
(429) DESCRIBE `avid_specials` 0.00084304809570312
(430) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66243 and class = 'Cruise') OR (item_id = 212 AND class = 'Ship') OR (item_id = 20 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.0011410713195801
(431) DESCRIBE `cruiselines` 0.0012040138244629
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00027799606323242
(433) DESCRIBE `orchid_image` 0.00072908401489258
(434) DESCRIBE `cruiselines` 0.00090885162353516
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019693374633789
(436) DESCRIBE `cruises` 0.0021061897277832
(437) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63719') 0.00031113624572754
(438) DESCRIBE `ships` 0.0018868446350098
(439) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0003819465637207
(440) DESCRIBE `ships` 0.0020289421081543
(441) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00029611587524414
(442) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(443) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(444) DESCRIBE `itineraries` 0.0009920597076416
(445) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63719') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077009201049805
(446) DESCRIBE `ports` 0.001237154006958
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036096572875977
(448) DESCRIBE `ports` 0.0010569095611572
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(450) DESCRIBE `ports` 0.00095915794372559
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023794174194336
(452) DESCRIBE `sailingdates` 0.00078296661376953
(453) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63719') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051093101501465
(454) DESCRIBE `ports` 0.0012340545654297
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059294700622559
(456) DESCRIBE `ports` 0.0014159679412842
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034594535827637
(458) DESCRIBE `ports` 0.0011730194091797
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00038886070251465
(460) DESCRIBE `ports` 0.0011780261993408
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00037288665771484
(462) DESCRIBE `ports` 0.0012130737304688
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00034999847412109
(464) DESCRIBE `ports` 0.0011820793151855
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00035214424133301
(466) DESCRIBE `ports` 0.0011739730834961
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00035500526428223
(468) DESCRIBE `ports` 0.0012071132659912
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0003201961517334
(470) DESCRIBE `ports` 0.0011661052703857
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00020790100097656
(472) DESCRIBE `ports` 0.00071310997009277
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00024008750915527
(474) DESCRIBE `ports` 0.00078797340393066
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00020217895507812
(476) DESCRIBE `ports` 0.00067400932312012
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00022411346435547
(478) DESCRIBE `ports` 0.00066804885864258
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00020980834960938
(480) DESCRIBE `ports` 0.00066995620727539
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0001828670501709
(482) DESCRIBE `ports` 0.00068116188049316
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00019717216491699
(484) DESCRIBE `ports` 0.00066494941711426
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00017786026000977
(486) DESCRIBE `ports` 0.00068998336791992
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00022196769714355
(488) DESCRIBE `ports` 0.00070095062255859
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0001838207244873
(490) DESCRIBE `ports` 0.00067305564880371
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00022315979003906
(492) DESCRIBE `ports` 0.00068783760070801
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018906593322754
(494) DESCRIBE `ports` 0.0006711483001709
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00020718574523926
(496) DESCRIBE `ports` 0.00069689750671387
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00019192695617676
(498) DESCRIBE `ports` 0.0007319450378418
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021219253540039
(500) DESCRIBE `ports` 0.0006711483001709
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018787384033203
(502) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63719') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0053830146789551
(503) DESCRIBE `avid_specials` 0.00087118148803711
(504) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63719 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 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.0010511875152588
(505) DESCRIBE `cruiselines` 0.0010130405426025
(506) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023603439331055
(507) DESCRIBE `orchid_image` 0.00079107284545898
(508) DESCRIBE `cruiselines` 0.00092911720275879
(509) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019311904907227
(510) DESCRIBE `cruises` 0.0020520687103271
(511) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63444') 0.00029420852661133
(512) DESCRIBE `ships` 0.0019199848175049
(513) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00036001205444336
(514) DESCRIBE `ships` 0.0015389919281006
(515) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.0002439022064209
(516) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(517) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014805793762207
(518) DESCRIBE `itineraries` 0.00073003768920898
(519) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63444') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048708915710449
(520) DESCRIBE `ports` 0.00072121620178223
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021004676818848
(522) DESCRIBE `ports` 0.00060486793518066
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00017690658569336
(524) DESCRIBE `ports` 0.00064301490783691
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018000602722168
(526) DESCRIBE `sailingdates` 0.00053906440734863
(527) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63444') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038313865661621
(528) DESCRIBE `ports` 0.00075101852416992
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021791458129883
(530) DESCRIBE `ports` 0.00060915946960449
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017189979553223
(532) DESCRIBE `ports` 0.00059008598327637
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00021505355834961
(534) DESCRIBE `ports` 0.00060892105102539
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00016593933105469
(536) DESCRIBE `ports` 0.00059795379638672
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00019001960754395
(538) DESCRIBE `ports` 0.00063705444335938
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00016689300537109
(540) DESCRIBE `ports` 0.0006411075592041
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00018787384033203
(542) DESCRIBE `ports` 0.00059890747070312
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.0001680850982666
(544) DESCRIBE `ports` 0.00061798095703125
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 685))) 0.00021910667419434
(546) DESCRIBE `ports` 0.00065302848815918
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '685') 0.00022196769714355
(548) DESCRIBE `ports` 0.00087904930114746
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.0002129077911377
(550) DESCRIBE `ports` 0.00066804885864258
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00017404556274414
(552) DESCRIBE `ports` 0.00059294700622559
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.00018095970153809
(554) DESCRIBE `ports` 0.00060796737670898
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00016403198242188
(556) DESCRIBE `ports` 0.00058698654174805
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00023508071899414
(558) DESCRIBE `ports` 0.00058507919311523
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018501281738281
(560) DESCRIBE `ports` 0.0006110668182373
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00017595291137695
(562) DESCRIBE `ports` 0.00058388710021973
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00015997886657715
(564) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63444') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0046570301055908
(565) DESCRIBE `avid_specials` 0.00077509880065918
(566) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63444 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 28 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.00098109245300293
(567) DESCRIBE `cruiselines` 0.0010740756988525
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030803680419922
(569) DESCRIBE `orchid_image` 0.00072622299194336
(570) DESCRIBE `cruiselines` 0.00088191032409668
(571) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020098686218262
(572) DESCRIBE `ships` 0.0015192031860352
(573) SELECT `ships`.* FROM `ships` WHERE (id IN ('405', '1088', '93', '314', '404', '574', '665', '770', '1008', '1193', '212', '448', '485', '626')) ORDER BY FIND_IN_SET(id, '405,1088,93,314,404,574,665,770,1008,1193,212,448,485,626') 0.00075197219848633
(574) DESCRIBE `cruisetypes` 0.00059390068054199
(575) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.02492094039917
(576) DESCRIBE `destinations` 0.0010340213775635
(577) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '29', '53', '28', '37', '43')) ORDER BY FIND_IN_SET(id, '12,9,29,53,28,37,43') 0.00054597854614258
(578) DESCRIBE `cruiselines` 0.0011258125305176
(579) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032591819763184
(580) DESCRIBE `cruiselines` 0.001478910446167
(581) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00029706954956055