or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  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: 496

Total elapsed time: 0.4682035446167

# Query Time
(1) connect 0.00093412399291992
(2) DESCRIBE `cruises` 0.0023190975189209
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66217, 70232, 57778, 64004, 64189, 44059, 46506, 57671, 57770, 71193)) ORDER BY FIND_IN_SET(id, '66217,70232,57778,64004,64189,44059,46506,57671,57770,71193') 0.0017209053039551
(4) DESCRIBE `cruises` 0.0020020008087158
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66217') 0.0002901554107666
(6) DESCRIBE `ships` 0.0012960433959961
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1241))) 0.00025677680969238
(8) DESCRIBE `ships` 0.0012309551239014
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1241') 0.00019502639770508
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015115737915039
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014209747314453
(12) DESCRIBE `itineraries` 0.000640869140625
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66217') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046205520629883
(14) DESCRIBE `ports` 0.00073790550231934
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00023102760314941
(16) DESCRIBE `ports` 0.00059700012207031
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00018811225891113
(18) DESCRIBE `ports` 0.00058913230895996
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00017094612121582
(20) DESCRIBE `sailingdates` 0.0005190372467041
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66217') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049710273742676
(22) DESCRIBE `ports` 0.00087308883666992
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.0002739429473877
(24) DESCRIBE `ports` 0.00063610076904297
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00022101402282715
(26) DESCRIBE `ports` 0.0005958080291748
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00020289421081543
(28) DESCRIBE `ports` 0.00059914588928223
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00019502639770508
(30) DESCRIBE `ports` 0.00063180923461914
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00021100044250488
(32) DESCRIBE `ports` 0.00058221817016602
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00018000602722168
(34) DESCRIBE `avid_specials` 0.00053000450134277
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66217 and class = 'Cruise') OR (item_id = 1241 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.00089788436889648
(36) DESCRIBE `cruiselines` 0.00086712837219238
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00019407272338867
(38) DESCRIBE `orchid_image` 0.00070714950561523
(39) DESCRIBE `cruiselines` 0.00084710121154785
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00018501281738281
(41) DESCRIBE `cruises` 0.0012428760528564
(42) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70232') 0.00020909309387207
(43) DESCRIBE `ships` 0.0011539459228516
(44) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1618))) 0.00023102760314941
(45) DESCRIBE `ships` 0.0013108253479004
(46) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1618') 0.00017380714416504
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016307830810547
(48) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019311904907227
(49) DESCRIBE `itineraries` 0.00076508522033691
(50) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70232') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066184997558594
(51) DESCRIBE `ports` 0.0009920597076416
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00021982192993164
(53) DESCRIBE `ports` 0.00072503089904785
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00018906593322754
(55) DESCRIBE `ports` 0.00086379051208496
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00024604797363281
(57) DESCRIBE `sailingdates` 0.0007939338684082
(58) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70232') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062298774719238
(59) DESCRIBE `ports` 0.00071620941162109
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00022292137145996
(61) DESCRIBE `ports` 0.00059795379638672
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016903877258301
(63) DESCRIBE `ports` 0.00059080123901367
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0002140998840332
(65) DESCRIBE `ports` 0.00058293342590332
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00017499923706055
(67) DESCRIBE `ports` 0.00058197975158691
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00018095970153809
(69) DESCRIBE `ports` 0.00059199333190918
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00015902519226074
(71) DESCRIBE `ports` 0.0005791187286377
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00017404556274414
(73) DESCRIBE `ports` 0.00058889389038086
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016498565673828
(75) DESCRIBE `ports` 0.00063610076904297
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00018191337585449
(77) DESCRIBE `ports` 0.00060892105102539
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00015997886657715
(79) DESCRIBE `ports` 0.00066995620727539
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00018215179443359
(81) DESCRIBE `ports` 0.00059986114501953
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00020694732666016
(83) DESCRIBE `ports` 0.00064802169799805
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00022387504577637
(85) DESCRIBE `ports` 0.00058412551879883
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00015997886657715
(87) DESCRIBE `ports` 0.00058102607727051
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00017786026000977
(89) DESCRIBE `ports` 0.00060796737670898
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00015997886657715
(91) DESCRIBE `ports` 0.00057291984558105
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5690))) 0.00017285346984863
(93) DESCRIBE `ports` 0.0005791187286377
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5690') 0.00015997886657715
(95) DESCRIBE `ports` 0.0005800724029541
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5690))) 0.00017404556274414
(97) DESCRIBE `ports` 0.00058293342590332
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5690') 0.00015878677368164
(99) DESCRIBE `ports` 0.0005800724029541
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00018405914306641
(101) DESCRIBE `ports` 0.00058412551879883
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00016307830810547
(103) DESCRIBE `ports` 0.00058197975158691
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00017809867858887
(105) DESCRIBE `ports` 0.00057792663574219
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00016093254089355
(107) DESCRIBE `avid_specials` 0.00052809715270996
(108) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70232 and class = 'Cruise') OR (item_id = 1618 AND class = 'Ship') OR (item_id = 110 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.00086307525634766
(109) DESCRIBE `cruiselines` 0.0008540153503418
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.00020098686218262
(111) DESCRIBE `orchid_image` 0.00073099136352539
(112) DESCRIBE `cruiselines` 0.00080108642578125
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.00017285346984863
(114) DESCRIBE `cruises` 0.0016689300537109
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57778') 0.00023102760314941
(116) DESCRIBE `ships` 0.001176118850708
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1376))) 0.00023889541625977
(118) DESCRIBE `ships` 0.001129150390625
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1376') 0.00017309188842773
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(122) DESCRIBE `itineraries` 0.00059914588928223
(123) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57778') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043416023254395
(124) DESCRIBE `ports` 0.00063490867614746
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00023102760314941
(126) DESCRIBE `ports` 0.00059103965759277
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00020813941955566
(128) DESCRIBE `ports` 0.00058698654174805
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00019693374633789
(130) DESCRIBE `sailingdates` 0.00052905082702637
(131) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57778') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066280364990234
(132) DESCRIBE `ports` 0.00075602531433105
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.0002589225769043
(134) DESCRIBE `ports` 0.00059795379638672
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00020384788513184
(136) DESCRIBE `ports` 0.00063419342041016
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00022697448730469
(138) DESCRIBE `ports` 0.00059390068054199
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.0001990795135498
(140) DESCRIBE `ports` 0.00059390068054199
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00018095970153809
(142) DESCRIBE `ports` 0.00058507919311523
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00016522407531738
(144) DESCRIBE `ports` 0.00058603286743164
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00021004676818848
(146) DESCRIBE `ports` 0.00058817863464355
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00018787384033203
(148) DESCRIBE `ports` 0.0005958080291748
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00020718574523926
(150) DESCRIBE `ports` 0.00058197975158691
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0001988410949707
(152) DESCRIBE `ports` 0.00059008598327637
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00018811225891113
(154) DESCRIBE `ports` 0.00060892105102539
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00020480155944824
(156) DESCRIBE `ports` 0.00065302848815918
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00022792816162109
(158) DESCRIBE `ports` 0.00060200691223145
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00020003318786621
(160) DESCRIBE `ports` 0.00062012672424316
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00026607513427734
(162) DESCRIBE `ports` 0.00060200691223145
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00020909309387207
(164) DESCRIBE `avid_specials` 0.00057411193847656
(165) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57778 and class = 'Cruise') OR (item_id = 1376 AND class = 'Ship') OR (item_id = 174 AND class = 'CruiseLine') OR (item_id = 54 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.0008699893951416
(166) DESCRIBE `cruiselines` 0.00093603134155273
(167) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00026297569274902
(168) DESCRIBE `orchid_image` 0.00075316429138184
(169) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '174') 0.039019823074341
(170) DESCRIBE `cruiselines` 0.0012369155883789
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00025701522827148
(172) DESCRIBE `cruises` 0.0014851093292236
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64004') 0.00024986267089844
(174) DESCRIBE `ships` 0.0012259483337402
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 28))) 0.00025391578674316
(176) DESCRIBE `ships` 0.0017259120941162
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '28') 0.00028014183044434
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020003318786621
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(180) DESCRIBE `itineraries` 0.00093698501586914
(181) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64004') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052285194396973
(182) DESCRIBE `ports` 0.00071382522583008
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00022482872009277
(184) DESCRIBE `ports` 0.00068497657775879
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00018310546875
(186) DESCRIBE `ports` 0.00064587593078613
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00019192695617676
(188) DESCRIBE `sailingdates` 0.00064587593078613
(189) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64004') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095391273498535
(190) DESCRIBE `ports` 0.0013730525970459
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00030708312988281
(192) DESCRIBE `ports` 0.0009310245513916
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00023698806762695
(194) DESCRIBE `ports` 0.0009160041809082
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00024986267089844
(196) DESCRIBE `ports` 0.00093221664428711
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00023508071899414
(198) DESCRIBE `ports` 0.00092101097106934
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.0002899169921875
(200) DESCRIBE `ports` 0.00090312957763672
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.0002288818359375
(202) DESCRIBE `ports` 0.00093293190002441
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00024604797363281
(204) DESCRIBE `ports` 0.00094008445739746
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00022697448730469
(206) DESCRIBE `ports` 0.00087904930114746
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00025796890258789
(208) DESCRIBE `ports` 0.00090622901916504
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00023889541625977
(210) DESCRIBE `ports` 0.00086688995361328
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00027585029602051
(212) DESCRIBE `ports` 0.00092506408691406
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00023603439331055
(214) DESCRIBE `ports` 0.00094890594482422
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00028800964355469
(216) DESCRIBE `ports` 0.0009160041809082
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00021481513977051
(218) DESCRIBE `avid_specials` 0.00066399574279785
(219) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64004 and class = 'Cruise') OR (item_id = 28 AND class = 'Ship') OR (item_id = 218 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.0012409687042236
(220) DESCRIBE `cruiselines` 0.00099086761474609
(221) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00025510787963867
(222) DESCRIBE `orchid_image` 0.00066208839416504
(223) DESCRIBE `cruiselines` 0.00098800659179688
(224) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00025010108947754
(225) DESCRIBE `cruises` 0.0019519329071045
(226) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64189') 0.00032401084899902
(227) DESCRIBE `ships` 0.0019149780273438
(228) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 759))) 0.0003819465637207
(229) DESCRIBE `ships` 0.0019469261169434
(230) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '759') 0.00028109550476074
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020194053649902
(232) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019097328186035
(233) DESCRIBE `itineraries` 0.000885009765625
(234) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64189') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056791305541992
(235) DESCRIBE `ports` 0.0010190010070801
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00029206275939941
(237) DESCRIBE `ports` 0.00093293190002441
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.0002892017364502
(239) DESCRIBE `ports` 0.00093793869018555
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00023102760314941
(241) DESCRIBE `sailingdates` 0.00065088272094727
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64189') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075912475585938
(243) DESCRIBE `ports` 0.0011589527130127
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.0002448558807373
(245) DESCRIBE `ports` 0.00064992904663086
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00018715858459473
(247) DESCRIBE `ports` 0.0006101131439209
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.0001990795135498
(249) DESCRIBE `ports` 0.0007178783416748
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00017905235290527
(251) DESCRIBE `avid_specials` 0.00055289268493652
(252) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64189 and class = 'Cruise') OR (item_id = 759 AND class = 'Ship') OR (item_id = 177 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.0008549690246582
(253) DESCRIBE `cruiselines` 0.00091099739074707
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 177))) 0.00022411346435547
(255) DESCRIBE `orchid_image` 0.00082015991210938
(256) DESCRIBE `cruiselines` 0.00089478492736816
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '177') 0.00024104118347168
(258) DESCRIBE `cruises` 0.0016410350799561
(259) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44059') 0.0002739429473877
(260) DESCRIBE `ships` 0.0016429424285889
(261) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1110))) 0.00032782554626465
(262) DESCRIBE `ships` 0.0017411708831787
(263) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1110') 0.0002748966217041
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019407272338867
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018095970153809
(266) DESCRIBE `itineraries` 0.00088810920715332
(267) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '44059') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061893463134766
(268) DESCRIBE `ports` 0.0009150505065918
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.0002448558807373
(270) DESCRIBE `ports` 0.00078701972961426
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00021600723266602
(272) DESCRIBE `ports` 0.00072193145751953
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00022506713867188
(274) DESCRIBE `sailingdates` 0.00068497657775879
(275) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '44059') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0009160041809082
(276) DESCRIBE `ports` 0.00096988677978516
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00024795532226562
(278) DESCRIBE `ports` 0.00076007843017578
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00018596649169922
(280) DESCRIBE `ports` 0.0007169246673584
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00022196769714355
(282) DESCRIBE `ports` 0.00074005126953125
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00017905235290527
(284) DESCRIBE `ports` 0.00059986114501953
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00018715858459473
(286) DESCRIBE `ports` 0.0006110668182373
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00016498565673828
(288) DESCRIBE `ports` 0.00059103965759277
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00018596649169922
(290) DESCRIBE `ports` 0.00063800811767578
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00021100044250488
(292) DESCRIBE `ports` 0.00083804130554199
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4811))) 0.00027894973754883
(294) DESCRIBE `ports` 0.0008389949798584
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4811') 0.00019192695617676
(296) DESCRIBE `ports` 0.00061702728271484
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00021696090698242
(298) DESCRIBE `ports` 0.00068497657775879
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00022196769714355
(300) DESCRIBE `avid_specials` 0.00067996978759766
(301) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44059 and class = 'Cruise') OR (item_id = 1110 AND class = 'Ship') OR (item_id = 219 AND class = 'CruiseLine') OR (item_id = 54 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.001554012298584
(302) DESCRIBE `cruiselines` 0.001406192779541
(303) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 219))) 0.00041699409484863
(304) DESCRIBE `orchid_image` 0.0011260509490967
(305) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '219') 0.043281078338623
(306) DESCRIBE `cruiselines` 0.0015590190887451
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '219') 0.00027179718017578
(308) DESCRIBE `cruises` 0.0013980865478516
(309) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46506') 0.0003049373626709
(310) DESCRIBE `ships` 0.0019791126251221
(311) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1176))) 0.00027108192443848
(312) DESCRIBE `ships` 0.0013511180877686
(313) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1176') 0.00022292137145996
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(316) DESCRIBE `itineraries` 0.00066208839416504
(317) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '46506') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053191184997559
(318) DESCRIBE `ports` 0.00086092948913574
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.00021505355834961
(320) DESCRIBE `ports` 0.00062799453735352
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.00017619132995605
(322) DESCRIBE `ports` 0.00067901611328125
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4532') 0.00016498565673828
(324) DESCRIBE `sailingdates` 0.00055408477783203
(325) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46506') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079083442687988
(326) DESCRIBE `ports` 0.0011799335479736
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.00023794174194336
(328) DESCRIBE `ports` 0.00072813034057617
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4532') 0.00021100044250488
(330) DESCRIBE `ports` 0.00074195861816406
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00022697448730469
(332) DESCRIBE `ports` 0.00081086158752441
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00019598007202148
(334) DESCRIBE `ports` 0.00075101852416992
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017404556274414
(336) DESCRIBE `ports` 0.00058317184448242
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015783309936523
(338) DESCRIBE `ports` 0.0005800724029541
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017809867858887
(340) DESCRIBE `ports` 0.00060105323791504
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016212463378906
(342) DESCRIBE `ports` 0.00058293342590332
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.00016999244689941
(344) DESCRIBE `ports` 0.0005791187286377
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4532') 0.00015401840209961
(346) DESCRIBE `avid_specials` 0.00057816505432129
(347) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46506 and class = 'Cruise') OR (item_id = 1176 AND class = 'Ship') OR (item_id = 225 AND class = 'CruiseLine') OR (item_id = 55 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.00094223022460938
(348) DESCRIBE `cruiselines` 0.00095295906066895
(349) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 225))) 0.0002739429473877
(350) DESCRIBE `orchid_image` 0.00076007843017578
(351) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '225') 0.037178993225098
(352) DESCRIBE `cruiselines` 0.0011360645294189
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '225') 0.00023794174194336
(354) DESCRIBE `cruises` 0.0013628005981445
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57671') 0.00024294853210449
(356) DESCRIBE `ships` 0.0013399124145508
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 858))) 0.00024986267089844
(358) DESCRIBE `ships` 0.0014269351959229
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '858') 0.00019097328186035
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018095970153809
(362) DESCRIBE `itineraries` 0.00069499015808105
(363) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57671') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00033283233642578
(364) DESCRIBE `ports` 0.00081706047058105
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00031304359436035
(366) DESCRIBE `ports` 0.00090193748474121
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00019097328186035
(368) DESCRIBE `ports` 0.00068902969360352
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00017118453979492
(370) DESCRIBE `sailingdates` 0.0007469654083252
(371) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57671') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050878524780273
(372) DESCRIBE `ports` 0.00099897384643555
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00026798248291016
(374) DESCRIBE `ports` 0.0007469654083252
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00017094612121582
(376) DESCRIBE `ports` 0.00082087516784668
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00019383430480957
(378) DESCRIBE `ports` 0.00065112113952637
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00016689300537109
(380) DESCRIBE `ports` 0.00077199935913086
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00019693374633789
(382) DESCRIBE `ports` 0.00063896179199219
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00020003318786621
(384) DESCRIBE `ports` 0.00081610679626465
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00021505355834961
(386) DESCRIBE `ports` 0.0007021427154541
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.0001680850982666
(388) DESCRIBE `ports` 0.00059795379638672
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00022506713867188
(390) DESCRIBE `ports` 0.00060796737670898
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00017499923706055
(392) DESCRIBE `avid_specials` 0.00052905082702637
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57671 and class = 'Cruise') OR (item_id = 858 AND class = 'Ship') OR (item_id = 195 AND class = 'CruiseLine') OR (item_id = 55 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.00093817710876465
(394) DESCRIBE `cruiselines` 0.00091004371643066
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.0002291202545166
(396) DESCRIBE `orchid_image` 0.00071597099304199
(397) DESCRIBE `cruiselines` 0.00086808204650879
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00017809867858887
(399) DESCRIBE `cruises` 0.0012500286102295
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57770') 0.00019502639770508
(401) DESCRIBE `ships` 0.0011608600616455
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1376))) 0.00023198127746582
(403) DESCRIBE `ships` 0.0012531280517578
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1376') 0.00018095970153809
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014400482177734
(407) DESCRIBE `itineraries` 0.00068211555480957
(408) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57770') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045609474182129
(409) DESCRIBE `ports` 0.00078701972961426
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00030303001403809
(411) DESCRIBE `ports` 0.00066399574279785
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00021100044250488
(413) DESCRIBE `ports` 0.0006871223449707
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00019407272338867
(415) DESCRIBE `sailingdates` 0.00063490867614746
(416) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57770') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062894821166992
(417) DESCRIBE `ports` 0.00084900856018066
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00025510787963867
(419) DESCRIBE `ports` 0.00060415267944336
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00025796890258789
(421) DESCRIBE `ports` 0.00059795379638672
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.0002129077911377
(423) DESCRIBE `ports` 0.00060200691223145
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00019478797912598
(425) DESCRIBE `ports` 0.00064897537231445
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00020098686218262
(427) DESCRIBE `ports` 0.0005950927734375
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00019192695617676
(429) DESCRIBE `ports` 0.00074100494384766
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00024008750915527
(431) DESCRIBE `ports` 0.0006260871887207
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00018405914306641
(433) DESCRIBE `ports` 0.00072693824768066
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00023698806762695
(435) DESCRIBE `ports` 0.00071501731872559
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00019311904907227
(437) DESCRIBE `avid_specials` 0.00057792663574219
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57770 and class = 'Cruise') OR (item_id = 1376 AND class = 'Ship') OR (item_id = 174 AND class = 'CruiseLine') OR (item_id = 54 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.00093388557434082
(439) DESCRIBE `cruiselines` 0.0010671615600586
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00026917457580566
(441) DESCRIBE `orchid_image` 0.00095319747924805
(442) DESCRIBE `cruiselines` 0.00095105171203613
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00019001960754395
(444) DESCRIBE `cruises` 0.0012400150299072
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71193') 0.00022602081298828
(446) DESCRIBE `ships` 0.0012071132659912
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503))) 0.00027585029602051
(448) DESCRIBE `ships` 0.0016288757324219
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '503') 0.00027704238891602
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020480155944824
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019717216491699
(452) DESCRIBE `itineraries` 0.00083804130554199
(453) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71193') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060606002807617
(454) DESCRIBE `ports` 0.00062894821166992
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00022006034851074
(456) DESCRIBE `ports` 0.00058794021606445
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00020098686218262
(458) DESCRIBE `ports` 0.0005950927734375
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00021600723266602
(460) DESCRIBE `sailingdates` 0.00057697296142578
(461) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71193') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055813789367676
(462) DESCRIBE `ports` 0.00079798698425293
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00026106834411621
(464) DESCRIBE `ports` 0.00065207481384277
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00018692016601562
(466) DESCRIBE `ports` 0.00066804885864258
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5444))) 0.00019693374633789
(468) DESCRIBE `ports` 0.0005948543548584
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5444') 0.00017714500427246
(470) DESCRIBE `ports` 0.0005950927734375
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5444))) 0.00018882751464844
(472) DESCRIBE `ports` 0.0006411075592041
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5444') 0.00018811225891113
(474) DESCRIBE `ports` 0.00079703330993652
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.0002591609954834
(476) DESCRIBE `ports` 0.00061202049255371
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00025796890258789
(478) DESCRIBE `ports` 0.00068807601928711
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00024104118347168
(480) DESCRIBE `ports` 0.00074410438537598
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.0001978874206543
(482) DESCRIBE `avid_specials` 0.00054597854614258
(483) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71193 and class = 'Cruise') OR (item_id = 503 AND class = 'Ship') OR (item_id = 115 AND class = 'CruiseLine') OR (item_id = 54 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.00086212158203125
(484) DESCRIBE `cruiselines` 0.00091290473937988
(485) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115))) 0.00021696090698242
(486) DESCRIBE `orchid_image` 0.00068807601928711
(487) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '115') 0.038424015045166
(488) DESCRIBE `cruiselines` 0.0014739036560059
(489) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115') 0.0002589225769043
(490) DESCRIBE `cruiselines` 0.0015950202941895
(491) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '120', '101', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '225', '229', '140', '170', '275', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '188', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '177', '224', '245', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,120,101,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,225,229,140,170,275,59,108,115,113,180,73,269,264,240,88,219,276,57,52,188,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,177,224,245,257,210,223,263,251') 0.0046520233154297
(492) DESCRIBE `ships` 0.0021770000457764
(493) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '974', '10', '349', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '520', '817', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '30', '31', '37', '573', '1285', '1586', '36', '38', '39', '378', '434', '590', '792', '34', '35', '1012', '1376', '327', '526', '970', '43', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1176', '1292', '1382', '1405', '338', '716', '1088', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '1575', '253', '857', '1149', '1236', '111', '285', '610', '852', '966', '1095', '1284', '59', '93', '403', '451', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '9', '75', '616', '666', '784', '1150', '1301', '1501', '503', '996', '1587', '81', '455', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1241', '1366', '1372', '1411', '1571', '108', '313', '776', '1141', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '823', '883', '1253', '74', '98', '147', '394', '937', '1579', '1087', '1172', '1454', '335', '938', '994', '66', '70', '341', '790', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1262', '1439', '715', '973', '1023', '1043', '1144', '1481', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1543', '1594', '448', '717', '1090', '1110', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '858', '915', '916', '926', '1001', '1072', '1082', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,974,10,349,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,520,817,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,30,31,37,573,1285,1586,36,38,39,378,434,590,792,34,35,1012,1376,327,526,970,43,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1176,1292,1382,1405,338,716,1088,1417,1569,1639,993,1455,314,678,722,837,1233,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,1575,253,857,1149,1236,111,285,610,852,966,1095,1284,59,93,403,451,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,9,75,616,666,784,1150,1301,1501,503,996,1587,81,455,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1241,1366,1372,1411,1571,108,313,776,1141,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,823,883,1253,74,98,147,394,937,1579,1087,1172,1454,335,938,994,66,70,341,790,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1262,1439,715,973,1023,1043,1144,1481,1545,494,673,1136,1137,1240,1282,1303,1437,1543,1594,448,717,1090,1110,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,858,915,916,926,1001,1072,1082,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811') 0.03028392791748
(494) DESCRIBE `cruisetypes` 0.00093793869018555
(495) DESCRIBE `destinations` 0.00089907646179199
(496) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.00089001655578613