or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Total elapsed time: 0.37094473838806

# Query Time
(1) connect 0.00064492225646973
(2) DESCRIBE `cruises` 0.0018949508666992
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41033, 41031, 68313, 68314, 41319, 41318, 66883, 40978, 40857, 40997)) ORDER BY FIND_IN_SET(id, '41033,41031,68313,68314,41319,41318,66883,40978,40857,40997') 0.00091695785522461
(4) DESCRIBE `specials` 0.0028409957885742
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1230240') AND (specials.orchid_available = 1) LIMIT 1 0.00053596496582031
(6) DESCRIBE `specials` 0.0025680065155029
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230240') 0.00030112266540527
(8) DESCRIBE `ships` 0.0018529891967773
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1035))) 0.00036311149597168
(10) DESCRIBE `ships` 0.0018761157989502
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1035') 0.00022196769714355
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015807151794434
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014495849609375
(14) DESCRIBE `itineraries` 0.00067996978759766
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005800724029541
(16) DESCRIBE `ports` 0.00076794624328613
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00022006034851074
(18) DESCRIBE `ports` 0.0006110668182373
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0001838207244873
(20) DESCRIBE `ports` 0.00061917304992676
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018501281738281
(22) DESCRIBE `specialsailingdates` 0.00053501129150391
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1230240') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00046205520629883
(24) DESCRIBE `sailingdates` 0.00067687034606934
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395983))) 0.00022006034851074
(26) DESCRIBE `sailingdates` 0.00058698654174805
(27) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395984))) 0.00017595291137695
(28) DESCRIBE `ports` 0.00064301490783691
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0002131462097168
(30) DESCRIBE `ports` 0.00078105926513672
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00037693977355957
(32) DESCRIBE `ports` 0.0010848045349121
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00026392936706543
(34) DESCRIBE `ports` 0.00086593627929688
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00021815299987793
(36) DESCRIBE `ports` 0.00088787078857422
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00026988983154297
(38) DESCRIBE `ports` 0.00092196464538574
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00021982192993164
(40) DESCRIBE `ports` 0.00088310241699219
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 940))) 0.00023508071899414
(42) DESCRIBE `ports` 0.00081300735473633
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '940') 0.00021696090698242
(44) DESCRIBE `ports` 0.00084495544433594
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00024890899658203
(46) DESCRIBE `ports` 0.00087213516235352
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00022101402282715
(48) DESCRIBE `ports` 0.00087785720825195
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.000244140625
(50) DESCRIBE `ports` 0.00090789794921875
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021481513977051
(52) DESCRIBE `ports` 0.00093817710876465
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00027108192443848
(54) DESCRIBE `ports` 0.00089812278747559
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.00021982192993164
(56) DESCRIBE `ports` 0.00083708763122559
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00025105476379395
(58) DESCRIBE `ports` 0.00068283081054688
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00016188621520996
(60) DESCRIBE `ports` 0.00060009956359863
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00017881393432617
(62) DESCRIBE `ports` 0.00058913230895996
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00016212463378906
(64) DESCRIBE `cruises` 0.0016839504241943
(65) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41033))) 0.00029182434082031
(66) DESCRIBE `avid_specials` 0.00055408477783203
(67) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230240 and class = 'Special') OR (item_id = 41033 and class = 'Cruise') OR (item_id = 1035 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00083804130554199
(68) DESCRIBE `cruiselines` 0.00093197822570801
(69) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00021910667419434
(70) DESCRIBE `orchid_image` 0.00068783760070801
(71) DESCRIBE `cruiselines` 0.00083279609680176
(72) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018405914306641
(73) DESCRIBE `specials` 0.0017058849334717
(74) SELECT `specials`.* FROM `specials` WHERE (id = '1225938') AND (specials.orchid_available = 1) LIMIT 1 0.00034904479980469
(75) DESCRIBE `specials` 0.001676082611084
(76) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225938') 0.00020813941955566
(77) DESCRIBE `ships` 0.0011200904846191
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00022983551025391
(79) DESCRIBE `ships` 0.0011200904846191
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00021100044250488
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016212463378906
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(83) DESCRIBE `itineraries` 0.00064396858215332
(84) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41031') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00033712387084961
(85) DESCRIBE `ports` 0.00061488151550293
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019598007202148
(87) DESCRIBE `ports` 0.0006110668182373
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017905235290527
(89) DESCRIBE `ports` 0.00059604644775391
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001680850982666
(91) DESCRIBE `specialsailingdates` 0.00049114227294922
(92) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1225938') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00050592422485352
(93) DESCRIBE `sailingdates` 0.00055193901062012
(94) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395478))) 0.00017404556274414
(95) DESCRIBE `ports` 0.0005950927734375
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018501281738281
(97) DESCRIBE `ports` 0.00060415267944336
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016188621520996
(99) DESCRIBE `ports` 0.00059103965759277
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017786026000977
(101) DESCRIBE `ports` 0.00059103965759277
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016188621520996
(103) DESCRIBE `ports` 0.00057816505432129
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018405914306641
(105) DESCRIBE `ports` 0.00058698654174805
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015687942504883
(107) DESCRIBE `ports` 0.00058794021606445
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00019693374633789
(109) DESCRIBE `ports` 0.00058484077453613
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00017499923706055
(111) DESCRIBE `ports` 0.00058484077453613
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018978118896484
(113) DESCRIBE `ports` 0.00064301490783691
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016283988952637
(115) DESCRIBE `ports` 0.00058102607727051
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017499923706055
(117) DESCRIBE `ports` 0.00060296058654785
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015687942504883
(119) DESCRIBE `cruises` 0.00111985206604
(120) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00025606155395508
(121) DESCRIBE `avid_specials` 0.0005488395690918
(122) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225938 and class = 'Special') OR (item_id = 41031 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00081396102905273
(123) DESCRIBE `cruiselines` 0.00083684921264648
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022983551025391
(125) DESCRIBE `orchid_image` 0.00069189071655273
(126) DESCRIBE `cruiselines` 0.00082111358642578
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00017499923706055
(128) DESCRIBE `specials` 0.0016260147094727
(129) SELECT `specials`.* FROM `specials` WHERE (id = '1294017') AND (specials.orchid_available = 1) LIMIT 1 0.00033307075500488
(130) DESCRIBE `specials` 0.0015909671783447
(131) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294017') 0.00018620491027832
(132) DESCRIBE `ships` 0.0010988712310791
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00027918815612793
(134) DESCRIBE `ships` 0.0011270046234131
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00016403198242188
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015878677368164
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014805793762207
(138) DESCRIBE `itineraries` 0.00058794021606445
(139) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68313') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046801567077637
(140) DESCRIBE `ports` 0.0007011890411377
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00021004676818848
(142) DESCRIBE `ports` 0.00063896179199219
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0001838207244873
(144) DESCRIBE `ports` 0.00059890747070312
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00016403198242188
(146) DESCRIBE `specialsailingdates` 0.00049400329589844
(147) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1294017') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00058794021606445
(148) DESCRIBE `sailingdates` 0.00054502487182617
(149) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430746))) 0.00017595291137695
(150) DESCRIBE `sailingdates` 0.00052213668823242
(151) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430747))) 0.00019621849060059
(152) DESCRIBE `sailingdates` 0.00054097175598145
(153) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430748))) 0.00017189979553223
(154) DESCRIBE `sailingdates` 0.00052189826965332
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430749))) 0.00019383430480957
(156) DESCRIBE `sailingdates` 0.00052309036254883
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430750))) 0.00017118453979492
(158) DESCRIBE `sailingdates` 0.00053000450134277
(159) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430751))) 0.00017094612121582
(160) DESCRIBE `sailingdates` 0.0005190372467041
(161) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430752))) 0.00017094612121582
(162) DESCRIBE `sailingdates` 0.00052309036254883
(163) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430753))) 0.00017189979553223
(164) DESCRIBE `sailingdates` 0.00051498413085938
(165) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430754))) 0.00017094612121582
(166) DESCRIBE `sailingdates` 0.00051593780517578
(167) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430756))) 0.00016498565673828
(168) DESCRIBE `sailingdates` 0.00052404403686523
(169) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430757))) 0.00021004676818848
(170) DESCRIBE `sailingdates` 0.00052404403686523
(171) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430758))) 0.00021886825561523
(172) DESCRIBE `sailingdates` 0.00053310394287109
(173) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430759))) 0.00017404556274414
(174) DESCRIBE `ports` 0.00060796737670898
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00020003318786621
(176) DESCRIBE `ports` 0.00058794021606445
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00017905235290527
(178) DESCRIBE `ports` 0.00058507919311523
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00018310546875
(180) DESCRIBE `ports` 0.00058698654174805
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00015902519226074
(182) DESCRIBE `ports` 0.00058984756469727
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00020790100097656
(184) DESCRIBE `ports` 0.00058197975158691
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00015997886657715
(186) DESCRIBE `ports` 0.00059700012207031
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00018811225891113
(188) DESCRIBE `ports` 0.00058794021606445
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00016498565673828
(190) DESCRIBE `ports` 0.0005948543548584
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00018000602722168
(192) DESCRIBE `ports` 0.00059390068054199
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00015592575073242
(194) DESCRIBE `ports` 0.00058484077453613
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00018692016601562
(196) DESCRIBE `ports` 0.00061297416687012
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00015902519226074
(198) DESCRIBE `cruises` 0.001121997833252
(199) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68313))) 0.00024795532226562
(200) DESCRIBE `avid_specials` 0.00055289268493652
(201) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294017 and class = 'Special') OR (item_id = 68313 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00081706047058105
(202) DESCRIBE `cruiselines` 0.00084805488586426
(203) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00020289421081543
(204) DESCRIBE `orchid_image` 0.00065016746520996
(205) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '38') 0.028076887130737
(206) DESCRIBE `cruiselines` 0.0010941028594971
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00020098686218262
(208) DESCRIBE `specials` 0.0015780925750732
(209) SELECT `specials`.* FROM `specials` WHERE (id = '1294018') AND (specials.orchid_available = 1) LIMIT 1 0.00033378601074219
(210) DESCRIBE `specials` 0.0016078948974609
(211) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294018') 0.00017905235290527
(212) DESCRIBE `ships` 0.0011351108551025
(213) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00023007392883301
(214) DESCRIBE `ships` 0.001410961151123
(215) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00018596649169922
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014781951904297
(218) DESCRIBE `itineraries` 0.00062894821166992
(219) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68314') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00031900405883789
(220) DESCRIBE `ports` 0.00069403648376465
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00019288063049316
(222) DESCRIBE `ports` 0.00058317184448242
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00017309188842773
(224) DESCRIBE `ports` 0.00058698654174805
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00015592575073242
(226) DESCRIBE `specialsailingdates` 0.00048708915710449
(227) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1294018') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00045990943908691
(228) DESCRIBE `sailingdates` 0.00058317184448242
(229) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430766))) 0.00020694732666016
(230) DESCRIBE `sailingdates` 0.00062990188598633
(231) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430767))) 0.00020408630371094
(232) DESCRIBE `sailingdates` 0.00056195259094238
(233) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430768))) 0.00017595291137695
(234) DESCRIBE `sailingdates` 0.00052094459533691
(235) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430769))) 0.00016999244689941
(236) DESCRIBE `sailingdates` 0.00055098533630371
(237) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430770))) 0.00017118453979492
(238) DESCRIBE `sailingdates` 0.00053501129150391
(239) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430771))) 0.00017094612121582
(240) DESCRIBE `sailingdates` 0.00052189826965332
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430772))) 0.00016999244689941
(242) DESCRIBE `sailingdates` 0.00053811073303223
(243) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430773))) 0.00018906593322754
(244) DESCRIBE `sailingdates` 0.00053787231445312
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430774))) 0.00016617774963379
(246) DESCRIBE `sailingdates` 0.00057888031005859
(247) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430776))) 0.00017213821411133
(248) DESCRIBE `sailingdates` 0.00057816505432129
(249) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430777))) 0.00016903877258301
(250) DESCRIBE `sailingdates` 0.00055313110351562
(251) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430778))) 0.0001678466796875
(252) DESCRIBE `sailingdates` 0.00052309036254883
(253) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430779))) 0.00017094612121582
(254) DESCRIBE `ports` 0.0006558895111084
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0001990795135498
(256) DESCRIBE `ports` 0.00061702728271484
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00016999244689941
(258) DESCRIBE `ports` 0.0006108283996582
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00019097328186035
(260) DESCRIBE `ports` 0.00066900253295898
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00018692016601562
(262) DESCRIBE `ports` 0.00062704086303711
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.0001828670501709
(264) DESCRIBE `ports` 0.00058603286743164
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00015807151794434
(266) DESCRIBE `ports` 0.0006110668182373
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00017881393432617
(268) DESCRIBE `ports` 0.00061392784118652
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00016212463378906
(270) DESCRIBE `ports` 0.00064778327941895
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00021600723266602
(272) DESCRIBE `ports` 0.00061511993408203
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00016379356384277
(274) DESCRIBE `ports` 0.00061917304992676
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00018095970153809
(276) DESCRIBE `ports` 0.0006251335144043
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00016593933105469
(278) DESCRIBE `cruises` 0.0012698173522949
(279) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68314))) 0.00051093101501465
(280) DESCRIBE `avid_specials` 0.0010030269622803
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294018 and class = 'Special') OR (item_id = 68314 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016090869903564
(282) DESCRIBE `cruiselines` 0.00098586082458496
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00023078918457031
(284) DESCRIBE `orchid_image` 0.00070905685424805
(285) DESCRIBE `cruiselines` 0.00085711479187012
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018882751464844
(287) DESCRIBE `specials` 0.0016767978668213
(288) SELECT `specials`.* FROM `specials` WHERE (id = '1221851') AND (specials.orchid_available = 1) LIMIT 1 0.00037789344787598
(289) DESCRIBE `specials` 0.0016989707946777
(290) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221851') 0.00022602081298828
(291) DESCRIBE `ships` 0.0012400150299072
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1064))) 0.00026082992553711
(293) DESCRIBE `ships` 0.0011861324310303
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1064') 0.00019192695617676
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016212463378906
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(297) DESCRIBE `itineraries` 0.00066709518432617
(298) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41319') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039887428283691
(299) DESCRIBE `ports` 0.00071406364440918
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021910667419434
(301) DESCRIBE `ports` 0.00061416625976562
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022387504577637
(303) DESCRIBE `ports` 0.00060105323791504
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00017690658569336
(305) DESCRIBE `specialsailingdates` 0.00050592422485352
(306) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1221851') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00041699409484863
(307) DESCRIBE `sailingdates` 0.000579833984375
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396366))) 0.00018095970153809
(309) DESCRIBE `ports` 0.00061607360839844
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00019288063049316
(311) DESCRIBE `ports` 0.00060296058654785
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018405914306641
(313) DESCRIBE `ports` 0.00059103965759277
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00018000602722168
(315) DESCRIBE `ports` 0.00059318542480469
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00016379356384277
(317) DESCRIBE `ports` 0.00058317184448242
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00017786026000977
(319) DESCRIBE `ports` 0.00058984756469727
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00015687942504883
(321) DESCRIBE `ports` 0.00062108039855957
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00019192695617676
(323) DESCRIBE `ports` 0.00059914588928223
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00015783309936523
(325) DESCRIBE `ports` 0.0005950927734375
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0001828670501709
(327) DESCRIBE `ports` 0.0006098747253418
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00016522407531738
(329) DESCRIBE `ports` 0.00058794021606445
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00018095970153809
(331) DESCRIBE `ports` 0.00060319900512695
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00015902519226074
(333) DESCRIBE `cruises` 0.001201868057251
(334) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41319))) 0.00026607513427734
(335) DESCRIBE `avid_specials` 0.00054502487182617
(336) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221851 and class = 'Special') OR (item_id = 41319 and class = 'Cruise') OR (item_id = 1064 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00081777572631836
(337) DESCRIBE `cruiselines` 0.00088596343994141
(338) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00020909309387207
(339) DESCRIBE `orchid_image` 0.0006568431854248
(340) DESCRIBE `cruiselines` 0.00087881088256836
(341) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018692016601562
(342) DESCRIBE `specials` 0.0019221305847168
(343) SELECT `specials`.* FROM `specials` WHERE (id = '1221755') AND (specials.orchid_available = 1) LIMIT 1 0.00039505958557129
(344) DESCRIBE `specials` 0.0016319751739502
(345) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221755') 0.00019693374633789
(346) DESCRIBE `ships` 0.0011999607086182
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1064))) 0.00025200843811035
(348) DESCRIBE `ships` 0.0011651515960693
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1064') 0.00019407272338867
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(352) DESCRIBE `itineraries` 0.00062108039855957
(353) DESCRIBE `ports` 0.00060892105102539
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0001990795135498
(355) DESCRIBE `ports` 0.00058889389038086
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00018596649169922
(357) DESCRIBE `ports` 0.00060701370239258
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019407272338867
(359) DESCRIBE `specialsailingdates` 0.00060701370239258
(360) DESCRIBE `sailingdates` 0.0005650520324707
(361) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396350))) 0.00022196769714355
(362) DESCRIBE `ports` 0.00064277648925781
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020003318786621
(364) DESCRIBE `ports` 0.00060892105102539
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019311904907227
(366) DESCRIBE `ports` 0.00063085556030273
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00019407272338867
(368) DESCRIBE `ports` 0.00061511993408203
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00016212463378906
(370) DESCRIBE `ports` 0.00059008598327637
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00018596649169922
(372) DESCRIBE `ports` 0.00058603286743164
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00016093254089355
(374) DESCRIBE `ports` 0.00062108039855957
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00017809867858887
(376) DESCRIBE `ports` 0.00060510635375977
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00016617774963379
(378) DESCRIBE `ports` 0.00076699256896973
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022411346435547
(380) DESCRIBE `ports` 0.00079798698425293
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00017690658569336
(382) DESCRIBE `ports` 0.00060009956359863
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00018906593322754
(384) DESCRIBE `ports` 0.00062918663024902
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00016617774963379
(386) DESCRIBE `cruises` 0.0012102127075195
(387) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41318))) 0.00029110908508301
(388) DESCRIBE `avid_specials` 0.00058293342590332
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221755 and class = 'Special') OR (item_id = 41318 and class = 'Cruise') OR (item_id = 1064 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00084090232849121
(390) DESCRIBE `cruiselines` 0.00088095664978027
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00021600723266602
(392) DESCRIBE `orchid_image` 0.00065207481384277
(393) DESCRIBE `cruiselines` 0.00083494186401367
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00020885467529297
(395) DESCRIBE `specials` 0.0016050338745117
(396) SELECT `specials`.* FROM `specials` WHERE (id = '1294179') AND (specials.orchid_available = 1) LIMIT 1 0.00033402442932129
(397) DESCRIBE `specials` 0.0017359256744385
(398) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294179') 0.00024080276489258
(399) DESCRIBE `ships` 0.001183032989502
(400) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 644))) 0.00026416778564453
(401) DESCRIBE `ships` 0.001288890838623
(402) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '644') 0.00021004676818848
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016117095947266
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014996528625488
(405) DESCRIBE `itineraries` 0.00059390068054199
(406) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66883') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004730224609375
(407) DESCRIBE `ports` 0.00069189071655273
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00022983551025391
(409) DESCRIBE `ports` 0.00065183639526367
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00016903877258301
(411) DESCRIBE `ports` 0.00059604644775391
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00018596649169922
(413) DESCRIBE `specialsailingdates` 0.00071287155151367
(414) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1294179') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0008540153503418
(415) DESCRIBE `sailingdates` 0.0010049343109131
(416) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419771))) 0.00031280517578125
(417) DESCRIBE `sailingdates` 0.00087618827819824
(418) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419772))) 0.00036001205444336
(419) DESCRIBE `sailingdates` 0.00080704689025879
(420) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419773))) 0.0002129077911377
(421) DESCRIBE `sailingdates` 0.00064516067504883
(422) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419774))) 0.00020384788513184
(423) DESCRIBE `sailingdates` 0.00067305564880371
(424) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419775))) 0.00020503997802734
(425) DESCRIBE `sailingdates` 0.00073504447937012
(426) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419776))) 0.00020098686218262
(427) DESCRIBE `sailingdates` 0.00058412551879883
(428) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419777))) 0.00017499923706055
(429) DESCRIBE `sailingdates` 0.0005340576171875
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419778))) 0.00017404556274414
(431) DESCRIBE `sailingdates` 0.00052809715270996
(432) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419779))) 0.00016903877258301
(433) DESCRIBE `sailingdates` 0.00052690505981445
(434) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419780))) 0.00017285346984863
(435) DESCRIBE `ports` 0.00061893463134766
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00019288063049316
(437) DESCRIBE `ports` 0.00059294700622559
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00017309188842773
(439) DESCRIBE `ports` 0.00058603286743164
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 189))) 0.00019311904907227
(441) DESCRIBE `ports` 0.00060391426086426
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '189') 0.00017094612121582
(443) DESCRIBE `ports` 0.00074481964111328
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00021505355834961
(445) DESCRIBE `ports` 0.00073480606079102
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00018596649169922
(447) DESCRIBE `ports` 0.00065302848815918
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00018692016601562
(449) DESCRIBE `ports` 0.00060915946960449
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00016498565673828
(451) DESCRIBE `cruises` 0.0012130737304688
(452) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66883))) 0.00030398368835449
(453) DESCRIBE `avid_specials` 0.0005638599395752
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294179 and class = 'Special') OR (item_id = 66883 and class = 'Cruise') OR (item_id = 644 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00086688995361328
(455) DESCRIBE `cruiselines` 0.00096893310546875
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00022602081298828
(457) DESCRIBE `orchid_image` 0.00069189071655273
(458) DESCRIBE `cruiselines` 0.00088095664978027
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00019001960754395
(460) DESCRIBE `specials` 0.0017008781433105
(461) SELECT `specials`.* FROM `specials` WHERE (id = '1230460') AND (specials.orchid_available = 1) LIMIT 1 0.00039100646972656
(462) DESCRIBE `specials` 0.0024368762969971
(463) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230460') 0.00039386749267578
(464) DESCRIBE `ships` 0.0017459392547607
(465) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1060))) 0.00042510032653809
(466) DESCRIBE `ships` 0.0018110275268555
(467) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1060') 0.00028800964355469
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021696090698242
(469) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017881393432617
(470) DESCRIBE `itineraries` 0.00088906288146973
(471) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40978') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054192543029785
(472) DESCRIBE `ports` 0.001168966293335
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00029492378234863
(474) DESCRIBE `ports` 0.00098109245300293
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00026416778564453
(476) DESCRIBE `ports` 0.00081205368041992
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00022101402282715
(478) DESCRIBE `specialsailingdates` 0.00069808959960938
(479) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1230460') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00058102607727051
(480) DESCRIBE `sailingdates` 0.00077605247497559
(481) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396113))) 0.00026893615722656
(482) DESCRIBE `ports` 0.00064992904663086
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020503997802734
(484) DESCRIBE `ports` 0.00059986114501953
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00016880035400391
(486) DESCRIBE `ports` 0.00060606002807617
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00019192695617676
(488) DESCRIBE `ports` 0.00060510635375977
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00017404556274414
(490) DESCRIBE `ports` 0.00063896179199219
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00018906593322754
(492) DESCRIBE `ports` 0.00065302848815918
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00017094612121582
(494) DESCRIBE `ports` 0.0006110668182373
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00019192695617676
(496) DESCRIBE `ports` 0.00059294700622559
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00016689300537109
(498) DESCRIBE `ports` 0.00063896179199219
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00023698806762695
(500) DESCRIBE `ports` 0.00079798698425293
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00021505355834961
(502) DESCRIBE `ports` 0.00078606605529785
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.000244140625
(504) DESCRIBE `ports` 0.000701904296875
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.00016903877258301
(506) DESCRIBE `ports` 0.00059890747070312
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00018596649169922
(508) DESCRIBE `ports` 0.00065112113952637
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00016903877258301
(510) DESCRIBE `ports` 0.00058412551879883
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00018620491027832
(512) DESCRIBE `ports` 0.00059008598327637
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00016403198242188
(514) DESCRIBE `ports` 0.00062799453735352
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00019001960754395
(516) DESCRIBE `ports` 0.00059413909912109
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00016379356384277
(518) DESCRIBE `cruises` 0.0011470317840576
(519) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40978))) 0.00028204917907715
(520) DESCRIBE `avid_specials` 0.00059008598327637
(521) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230460 and class = 'Special') OR (item_id = 40978 and class = 'Cruise') OR (item_id = 1060 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00084304809570312
(522) DESCRIBE `cruiselines` 0.00087499618530273
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00021791458129883
(524) DESCRIBE `orchid_image` 0.00065517425537109
(525) DESCRIBE `cruiselines` 0.00084090232849121
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018119812011719
(527) DESCRIBE `specials` 0.0016031265258789
(528) SELECT `specials`.* FROM `specials` WHERE (id = '1233937') AND (specials.orchid_available = 1) LIMIT 1 0.00037503242492676
(529) DESCRIBE `specials` 0.0018601417541504
(530) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1233937') 0.00023698806762695
(531) DESCRIBE `ships` 0.0011448860168457
(532) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1040))) 0.00023317337036133
(533) DESCRIBE `ships` 0.0011570453643799
(534) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1040') 0.00016498565673828
(535) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016498565673828
(536) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015401840209961
(537) DESCRIBE `itineraries` 0.00061702728271484
(538) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40857') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041103363037109
(539) DESCRIBE `ports` 0.00081610679626465
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00024509429931641
(541) DESCRIBE `ports` 0.00076603889465332
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00022196769714355
(543) DESCRIBE `ports` 0.00078797340393066
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00020194053649902
(545) DESCRIBE `specialsailingdates` 0.00064516067504883
(546) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1233937') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00051403045654297
(547) DESCRIBE `sailingdates` 0.00057291984558105
(548) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395839))) 0.00017094612121582
(549) DESCRIBE `ports` 0.00061988830566406
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00021696090698242
(551) DESCRIBE `ports` 0.00069403648376465
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00020098686218262
(553) DESCRIBE `ports` 0.00060009956359863
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00019311904907227
(555) DESCRIBE `ports` 0.00059890747070312
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00016212463378906
(557) DESCRIBE `ports` 0.00066304206848145
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00019288063049316
(559) DESCRIBE `ports` 0.00059413909912109
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00016188621520996
(561) DESCRIBE `ports` 0.00058603286743164
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00019121170043945
(563) DESCRIBE `ports` 0.00059795379638672
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00016283988952637
(565) DESCRIBE `ports` 0.00059413909912109
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1068))) 0.00018906593322754
(567) DESCRIBE `ports` 0.00063586235046387
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1068') 0.00016903877258301
(569) DESCRIBE `ports` 0.00058293342590332
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00018310546875
(571) DESCRIBE `ports` 0.00058507919311523
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00015997886657715
(573) DESCRIBE `cruises` 0.0011250972747803
(574) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40857))) 0.00026893615722656
(575) DESCRIBE `avid_specials` 0.00055909156799316
(576) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1233937 and class = 'Special') OR (item_id = 40857 and class = 'Cruise') OR (item_id = 1040 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013530254364014
(577) DESCRIBE `cruiselines` 0.0011348724365234
(578) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00026798248291016
(579) DESCRIBE `orchid_image` 0.00085592269897461
(580) DESCRIBE `cruiselines` 0.0010850429534912
(581) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00017213821411133
(582) DESCRIBE `specials` 0.0015969276428223
(583) SELECT `specials`.* FROM `specials` WHERE (id = '1235956') AND (specials.orchid_available = 1) LIMIT 1 0.00030803680419922
(584) DESCRIBE `specials` 0.0015149116516113
(585) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1235956') 0.00020813941955566
(586) DESCRIBE `ships` 0.0011289119720459
(587) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1036))) 0.00023603439331055
(588) DESCRIBE `ships` 0.0011260509490967
(589) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1036') 0.0001680850982666
(590) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(591) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(592) DESCRIBE `itineraries` 0.00058293342590332
(593) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40997') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00032687187194824
(594) DESCRIBE `ports` 0.00061893463134766
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00019598007202148
(596) DESCRIBE `ports` 0.00064396858215332
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00017905235290527
(598) DESCRIBE `ports` 0.00060391426086426
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00016593933105469
(600) DESCRIBE `specialsailingdates` 0.0005028247833252
(601) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1235956') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00041413307189941
(602) DESCRIBE `sailingdates` 0.00056695938110352
(603) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395862))) 0.00017309188842773
(604) DESCRIBE `ports` 0.00063300132751465
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00019383430480957
(606) DESCRIBE `ports` 0.00064206123352051
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00019288063049316
(608) DESCRIBE `ports` 0.00065112113952637
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1599))) 0.00019693374633789
(610) DESCRIBE `ports` 0.00060892105102539
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1599') 0.00017023086547852
(612) DESCRIBE `ports` 0.00062298774719238
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00018501281738281
(614) DESCRIBE `ports` 0.00061607360839844
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00015997886657715
(616) DESCRIBE `ports` 0.00059700012207031
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1591))) 0.00019407272338867
(618) DESCRIBE `ports` 0.00058698654174805
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1591') 0.00015997886657715
(620) DESCRIBE `ports` 0.00060200691223145
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00018000602722168
(622) DESCRIBE `ports` 0.00060105323791504
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00015902519226074
(624) DESCRIBE `ports` 0.00059008598327637
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1071))) 0.00017213821411133
(626) DESCRIBE `ports` 0.00060391426086426
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1071') 0.00015497207641602
(628) DESCRIBE `ports` 0.00061988830566406
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00019288063049316
(630) DESCRIBE `ports` 0.00058722496032715
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1597') 0.00016403198242188
(632) DESCRIBE `ports` 0.00063896179199219
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00022006034851074
(634) DESCRIBE `ports` 0.00086402893066406
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1597') 0.0002281665802002
(636) DESCRIBE `cruises` 0.0017280578613281
(637) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40997))) 0.00038695335388184
(638) DESCRIBE `avid_specials` 0.0006401538848877
(639) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1235956 and class = 'Special') OR (item_id = 40997 and class = 'Cruise') OR (item_id = 1036 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013558864593506
(640) DESCRIBE `cruiselines` 0.00088405609130859
(641) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022315979003906
(642) DESCRIBE `orchid_image` 0.00065898895263672
(643) DESCRIBE `cruiselines` 0.00092005729675293
(644) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018811225891113
(645) DESCRIBE `cruiselines` 0.0011160373687744
(646) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '141', '38', '101', '47', '191', '23', '263', '18', '33', '218', '24', '30', '268', '28', '29', '151', '91', '187', '8')) ORDER BY FIND_IN_SET(id, '144,141,38,101,47,191,23,263,18,33,218,24,30,268,28,29,151,91,187,8') 0.00081515312194824
(647) DESCRIBE `ships` 0.0019030570983887
(648) SELECT `ships`.* FROM `ships` WHERE (id IN ('189', '517', '744', '1205', '635', '1063', '1224', '163', '743', '1456', '1579', '785', '1064', '1068', '644', '1468', '1232', '1035', '1036', '1154', '150', '451', '972', '1045', '1047', '1206', '616', '1138', '75', '111', '340', '349', '709', '1052', '1060', '1106', '1325', '1409', '108', '394', '406', '547', '657', '683', '768', '786', '1040', '1044', '1049', '1062', '1168', '1293', '1318', '1457', '1465', '81', '151', '152', '223', '253', '313', '341', '348', '542', '792', '966', '1038', '1043', '1050', '1051', '1055', '1135', '1139', '1223', '1266', '1302', '1371', '1389', '1398', '1483', '1514', '1515', '1517', '1522', '1575', '1593')) ORDER BY FIND_IN_SET(id, '189,517,744,1205,635,1063,1224,163,743,1456,1579,785,1064,1068,644,1468,1232,1035,1036,1154,150,451,972,1045,1047,1206,616,1138,75,111,340,349,709,1052,1060,1106,1325,1409,108,394,406,547,657,683,768,786,1040,1044,1049,1062,1168,1293,1318,1457,1465,81,151,152,223,253,313,341,348,542,792,966,1038,1043,1050,1051,1055,1135,1139,1223,1266,1302,1371,1389,1398,1483,1514,1515,1517,1522,1575,1593') 0.0031750202178955
(649) DESCRIBE `cruisetypes` 0.00086092948913574
(650) DESCRIBE `destinations` 0.00085902214050293
(651) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '35', '22', '43', '54', '30', '12', '2', '40', '26', '48', '8', '11', '9', '10', '25', '29', '38', '53')) ORDER BY FIND_IN_SET(id, '50,35,22,43,54,30,12,2,40,26,48,8,11,9,10,25,29,38,53') 0.00072693824768066