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

Total elapsed time: 0.70716977119446

# Query Time
(1) connect 0.00088310241699219
(2) DESCRIBE `cruises` 0.0022459030151367
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (61951, 61952, 61953, 61131, 67024, 69031, 61954, 72604, 62036, 65383)) ORDER BY FIND_IN_SET(id, '61951,61952,61953,61131,67024,69031,61954,72604,62036,65383') 0.0018661022186279
(4) DESCRIBE `cruises` 0.0020918846130371
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61951') 0.00036311149597168
(6) DESCRIBE `ships` 0.0021598339080811
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00039219856262207
(8) DESCRIBE `ships` 0.0020139217376709
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.0003352165222168
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(12) DESCRIBE `itineraries` 0.001359224319458
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61951') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010359287261963
(14) DESCRIBE `ports` 0.001154899597168
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(16) DESCRIBE `ports` 0.00088095664978027
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024604797363281
(18) DESCRIBE `ports` 0.0011940002441406
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025200843811035
(20) DESCRIBE `sailingdates` 0.00060796737670898
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61951') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005638599395752
(22) DESCRIBE `ports` 0.0007328987121582
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022387504577637
(24) DESCRIBE `ports` 0.00063300132751465
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017786026000977
(26) DESCRIBE `ports` 0.00059318542480469
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018906593322754
(28) DESCRIBE `ports` 0.00060486793518066
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017690658569336
(30) DESCRIBE `ports` 0.00078201293945312
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024294853210449
(32) DESCRIBE `ports` 0.00089788436889648
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00023293495178223
(34) DESCRIBE `ports` 0.00092697143554688
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00034594535827637
(36) DESCRIBE `ports` 0.00072407722473145
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00018501281738281
(38) DESCRIBE `ports` 0.00063705444335938
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00018882751464844
(40) DESCRIBE `ports` 0.00059390068054199
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.0001828670501709
(42) DESCRIBE `ports` 0.00058603286743164
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00020599365234375
(44) DESCRIBE `ports` 0.00074291229248047
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00017905235290527
(46) DESCRIBE `ports` 0.00059413909912109
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00019478797912598
(48) DESCRIBE `ports` 0.00060486793518066
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00018882751464844
(50) DESCRIBE `ports` 0.00064897537231445
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0002138614654541
(52) DESCRIBE `ports` 0.00061416625976562
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00020718574523926
(54) DESCRIBE `ports` 0.00060510635375977
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00018095970153809
(56) DESCRIBE `ports` 0.00064802169799805
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017404556274414
(58) DESCRIBE `ports` 0.00061893463134766
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00018405914306641
(60) DESCRIBE `ports` 0.0006258487701416
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00016903877258301
(62) DESCRIBE `ports` 0.00065112113952637
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00019311904907227
(64) DESCRIBE `ports` 0.00062394142150879
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00017905235290527
(66) DESCRIBE `ports` 0.00059294700622559
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020503997802734
(68) DESCRIBE `ports` 0.00072407722473145
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020217895507812
(70) DESCRIBE `ports` 0.00060820579528809
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00018596649169922
(72) DESCRIBE `ports` 0.0006110668182373
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002138614654541
(74) DESCRIBE `ports` 0.00068283081054688
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00021505355834961
(76) DESCRIBE `ports` 0.00071120262145996
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00017905235290527
(78) DESCRIBE `ports` 0.00060200691223145
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00018715858459473
(80) DESCRIBE `ports` 0.00061798095703125
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00016403198242188
(82) DESCRIBE `ports` 0.00058984756469727
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00018906593322754
(84) DESCRIBE `ports` 0.00060391426086426
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00018501281738281
(86) DESCRIBE `ports` 0.00060606002807617
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 812))) 0.00023102760314941
(88) DESCRIBE `ports` 0.00060105323791504
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '812') 0.00019288063049316
(90) DESCRIBE `ports` 0.00068902969360352
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00024199485778809
(92) DESCRIBE `ports` 0.00060701370239258
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0002129077911377
(94) DESCRIBE `ports` 0.00073695182800293
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00026202201843262
(96) DESCRIBE `ports` 0.00094699859619141
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00022387504577637
(98) DESCRIBE `ports` 0.00092601776123047
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00024604797363281
(100) DESCRIBE `ports` 0.00094294548034668
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00023889541625977
(102) DESCRIBE `ports` 0.00093603134155273
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00026702880859375
(104) DESCRIBE `ports` 0.000946044921875
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00027585029602051
(106) DESCRIBE `ports` 0.0010509490966797
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00032305717468262
(108) DESCRIBE `ports` 0.001035213470459
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.0002601146697998
(110) DESCRIBE `ports` 0.00094294548034668
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2969))) 0.00029206275939941
(112) DESCRIBE `ports` 0.00099802017211914
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2969') 0.00024199485778809
(114) DESCRIBE `ports` 0.00096487998962402
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2969))) 0.00034189224243164
(116) DESCRIBE `ports` 0.0011179447174072
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2969') 0.00028109550476074
(118) DESCRIBE `ports` 0.00097894668579102
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00029993057250977
(120) DESCRIBE `ports` 0.00098609924316406
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00023007392883301
(122) DESCRIBE `ports` 0.00091195106506348
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4224))) 0.00027108192443848
(124) DESCRIBE `ports` 0.00096988677978516
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4224') 0.00024700164794922
(126) DESCRIBE `ports` 0.00095796585083008
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00027203559875488
(128) DESCRIBE `ports` 0.0009610652923584
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00024509429931641
(130) DESCRIBE `ports` 0.00092196464538574
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00025796890258789
(132) DESCRIBE `ports` 0.00091004371643066
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00023317337036133
(134) DESCRIBE `ports` 0.00089907646179199
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00025820732116699
(136) DESCRIBE `ports` 0.00091195106506348
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00032997131347656
(138) DESCRIBE `avid_specials` 0.00086116790771484
(139) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61951 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017330646514893
(140) DESCRIBE `cruiselines` 0.001471996307373
(141) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00032997131347656
(142) DESCRIBE `orchid_image` 0.0011320114135742
(143) DESCRIBE `cruiselines` 0.001446008682251
(144) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00030207633972168
(145) DESCRIBE `cruises` 0.0021500587463379
(146) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61952') 0.00043416023254395
(147) DESCRIBE `ships` 0.0020959377288818
(148) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00063419342041016
(149) DESCRIBE `ships` 0.0020210742950439
(150) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.00029301643371582
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018715858459473
(153) DESCRIBE `itineraries` 0.00084805488586426
(154) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61952') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066304206848145
(155) DESCRIBE `ports` 0.00094795227050781
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002739429473877
(157) DESCRIBE `ports` 0.00080394744873047
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022697448730469
(159) DESCRIBE `ports` 0.00083518028259277
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021815299987793
(161) DESCRIBE `sailingdates` 0.00072598457336426
(162) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61952') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047707557678223
(163) DESCRIBE `ports` 0.00089597702026367
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002601146697998
(165) DESCRIBE `ports` 0.00080084800720215
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020694732666016
(167) DESCRIBE `ports` 0.00075697898864746
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022006034851074
(169) DESCRIBE `ports` 0.00075912475585938
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(171) DESCRIBE `ports` 0.00081491470336914
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00026202201843262
(173) DESCRIBE `ports` 0.00085806846618652
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00021910667419434
(175) DESCRIBE `ports` 0.00076723098754883
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00023007392883301
(177) DESCRIBE `ports` 0.00076103210449219
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00020217895507812
(179) DESCRIBE `ports` 0.00079798698425293
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00022602081298828
(181) DESCRIBE `ports` 0.00076198577880859
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.0001988410949707
(183) DESCRIBE `ports` 0.00078010559082031
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00025796890258789
(185) DESCRIBE `ports` 0.00080704689025879
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00021481513977051
(187) DESCRIBE `ports` 0.00081014633178711
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00024890899658203
(189) DESCRIBE `ports` 0.000823974609375
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00021600723266602
(191) DESCRIBE `ports` 0.00082898139953613
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00025296211242676
(193) DESCRIBE `ports` 0.00081682205200195
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00020909309387207
(195) DESCRIBE `ports` 0.0007939338684082
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00023603439331055
(197) DESCRIBE `ports` 0.00080704689025879
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0002138614654541
(199) DESCRIBE `ports` 0.00082206726074219
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00024318695068359
(201) DESCRIBE `ports` 0.0008080005645752
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00021004676818848
(203) DESCRIBE `ports` 0.00080108642578125
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00026702880859375
(205) DESCRIBE `ports` 0.00078511238098145
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00019693374633789
(207) DESCRIBE `ports` 0.00075697898864746
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022292137145996
(209) DESCRIBE `ports` 0.00077986717224121
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020098686218262
(211) DESCRIBE `ports` 0.00076699256896973
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023484230041504
(213) DESCRIBE `ports` 0.0008549690246582
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00021886825561523
(215) DESCRIBE `ports` 0.00083613395690918
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00025320053100586
(217) DESCRIBE `ports` 0.00085616111755371
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00021100044250488
(219) DESCRIBE `ports` 0.00081396102905273
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.000244140625
(221) DESCRIBE `ports` 0.00081610679626465
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00020098686218262
(223) DESCRIBE `ports` 0.00075507164001465
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00022411346435547
(225) DESCRIBE `ports` 0.00076389312744141
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00021815299987793
(227) DESCRIBE `ports` 0.00079011917114258
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 812))) 0.00022792816162109
(229) DESCRIBE `ports` 0.00080490112304688
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '812') 0.00020599365234375
(231) DESCRIBE `ports` 0.00079607963562012
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00023198127746582
(233) DESCRIBE `ports` 0.00081110000610352
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00021195411682129
(235) DESCRIBE `avid_specials` 0.00072193145751953
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61952 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013659000396729
(237) DESCRIBE `cruiselines` 0.0011489391326904
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00025677680969238
(239) DESCRIBE `orchid_image` 0.00085902214050293
(240) DESCRIBE `cruiselines` 0.001107931137085
(241) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00022602081298828
(242) DESCRIBE `cruises` 0.0016481876373291
(243) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61953') 0.00024580955505371
(244) DESCRIBE `ships` 0.001816987991333
(245) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00039196014404297
(246) DESCRIBE `ships` 0.0020749568939209
(247) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.0003209114074707
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022506713867188
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020599365234375
(250) DESCRIBE `itineraries` 0.0010240077972412
(251) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61953') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051999092102051
(252) DESCRIBE `ports` 0.0010771751403809
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029397010803223
(254) DESCRIBE `ports` 0.00092196464538574
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023198127746582
(256) DESCRIBE `ports` 0.0008549690246582
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024104118347168
(258) DESCRIBE `sailingdates` 0.00079512596130371
(259) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61953') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050187110900879
(260) DESCRIBE `ports` 0.0013217926025391
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(262) DESCRIBE `ports` 0.00091886520385742
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024199485778809
(264) DESCRIBE `ports` 0.00089478492736816
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026297569274902
(266) DESCRIBE `ports` 0.00091385841369629
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023698806762695
(268) DESCRIBE `ports` 0.00095105171203613
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00028300285339355
(270) DESCRIBE `ports` 0.00092601776123047
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024008750915527
(272) DESCRIBE `ports` 0.00095200538635254
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00025820732116699
(274) DESCRIBE `ports` 0.00091004371643066
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00023317337036133
(276) DESCRIBE `ports` 0.00092005729675293
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00025296211242676
(278) DESCRIBE `ports` 0.00088000297546387
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.0002281665802002
(280) DESCRIBE `ports` 0.00093793869018555
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00026106834411621
(282) DESCRIBE `ports` 0.00091099739074707
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00023198127746582
(284) DESCRIBE `ports` 0.0009620189666748
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00028085708618164
(286) DESCRIBE `ports` 0.0009911060333252
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00024318695068359
(288) DESCRIBE `ports` 0.00094294548034668
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00027108192443848
(290) DESCRIBE `ports` 0.0009300708770752
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00025415420532227
(292) DESCRIBE `ports` 0.00099587440490723
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00028085708618164
(294) DESCRIBE `ports` 0.00095200538635254
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00024104118347168
(296) DESCRIBE `ports` 0.00092005729675293
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00026178359985352
(298) DESCRIBE `ports` 0.00095200538635254
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00024318695068359
(300) DESCRIBE `ports` 0.00089192390441895
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00025415420532227
(302) DESCRIBE `ports` 0.00091814994812012
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.0002288818359375
(304) DESCRIBE `ports` 0.00088000297546387
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00025296211242676
(306) DESCRIBE `ports` 0.0009620189666748
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.000244140625
(308) DESCRIBE `ports` 0.00092291831970215
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024914741516113
(310) DESCRIBE `ports` 0.00091314315795898
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022387504577637
(312) DESCRIBE `avid_specials` 0.00081205368041992
(313) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61953 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00164794921875
(314) DESCRIBE `cruiselines` 0.0014028549194336
(315) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00031495094299316
(316) DESCRIBE `orchid_image` 0.001025915145874
(317) DESCRIBE `cruiselines` 0.0013580322265625
(318) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00028800964355469
(319) DESCRIBE `cruises` 0.002065896987915
(320) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61131') 0.00035905838012695
(321) DESCRIBE `ships` 0.0019910335540771
(322) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00033211708068848
(323) DESCRIBE `ships` 0.0017211437225342
(324) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00024294853210449
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019407272338867
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001981258392334
(327) DESCRIBE `itineraries` 0.00097894668579102
(328) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61131') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00093388557434082
(329) DESCRIBE `ports` 0.0010218620300293
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027799606323242
(331) DESCRIBE `ports` 0.00082802772521973
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027704238891602
(333) DESCRIBE `ports` 0.00081801414489746
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00022292137145996
(335) DESCRIBE `sailingdates` 0.00077414512634277
(336) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61131') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078105926513672
(337) DESCRIBE `ports` 0.0010411739349365
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029993057250977
(339) DESCRIBE `ports` 0.00094509124755859
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026488304138184
(341) DESCRIBE `ports` 0.00093793869018555
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00030708312988281
(343) DESCRIBE `ports` 0.0010740756988525
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00031113624572754
(345) DESCRIBE `ports` 0.00095200538635254
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028014183044434
(347) DESCRIBE `ports` 0.0010378360748291
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025701522827148
(349) DESCRIBE `ports` 0.00092887878417969
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027990341186523
(351) DESCRIBE `ports` 0.00095605850219727
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(353) DESCRIBE `ports` 0.0009911060333252
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00027012825012207
(355) DESCRIBE `ports` 0.00092792510986328
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00026583671569824
(357) DESCRIBE `ports` 0.00092911720275879
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00027990341186523
(359) DESCRIBE `ports` 0.00094103813171387
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024294853210449
(361) DESCRIBE `ports` 0.00092196464538574
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00038290023803711
(363) DESCRIBE `ports` 0.00098681449890137
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00024819374084473
(365) DESCRIBE `ports` 0.00087904930114746
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00027799606323242
(367) DESCRIBE `ports` 0.00096416473388672
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00026178359985352
(369) DESCRIBE `ports` 0.00091981887817383
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00029087066650391
(371) DESCRIBE `ports` 0.00098776817321777
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00026583671569824
(373) DESCRIBE `avid_specials` 0.00088191032409668
(374) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61131 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016791820526123
(375) DESCRIBE `cruiselines` 0.0015041828155518
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00034403800964355
(377) DESCRIBE `orchid_image` 0.0011358261108398
(378) DESCRIBE `cruiselines` 0.001533031463623
(379) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00029683113098145
(380) DESCRIBE `cruises` 0.0021471977233887
(381) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67024') 0.0004880428314209
(382) DESCRIBE `ships` 0.0020859241485596
(383) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1017))) 0.00041890144348145
(384) DESCRIBE `ships` 0.0018270015716553
(385) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1017') 0.00030303001403809
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(388) DESCRIBE `itineraries` 0.00091409683227539
(389) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67024') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084710121154785
(390) DESCRIBE `ports` 0.0010578632354736
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034499168395996
(392) DESCRIBE `ports` 0.00093507766723633
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00026202201843262
(394) DESCRIBE `ports` 0.00082993507385254
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00022101402282715
(396) DESCRIBE `sailingdates` 0.00072884559631348
(397) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67024') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007178783416748
(398) DESCRIBE `ports` 0.0010089874267578
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00029802322387695
(400) DESCRIBE `ports` 0.00088691711425781
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00022697448730469
(402) DESCRIBE `ports` 0.00091004371643066
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00027799606323242
(404) DESCRIBE `ports` 0.00094294548034668
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00024914741516113
(406) DESCRIBE `ports` 0.000885009765625
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00026321411132812
(408) DESCRIBE `ports` 0.00091004371643066
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.000244140625
(410) DESCRIBE `ports` 0.00089287757873535
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031900405883789
(412) DESCRIBE `ports` 0.00092697143554688
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00026607513427734
(414) DESCRIBE `ports` 0.00098705291748047
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029802322387695
(416) DESCRIBE `ports` 0.00094795227050781
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028896331787109
(418) DESCRIBE `ports` 0.0011019706726074
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00034308433532715
(420) DESCRIBE `ports` 0.0009920597076416
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00026607513427734
(422) DESCRIBE `ports` 0.0010359287261963
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00044608116149902
(424) DESCRIBE `ports` 0.0011739730834961
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00028705596923828
(426) DESCRIBE `ports` 0.00092816352844238
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00028800964355469
(428) DESCRIBE `ports` 0.00097012519836426
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00027298927307129
(430) DESCRIBE `ports` 0.00097012519836426
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002751350402832
(432) DESCRIBE `ports` 0.0010280609130859
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026702880859375
(434) DESCRIBE `ports` 0.00097298622131348
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00029706954956055
(436) DESCRIBE `ports` 0.0010058879852295
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00027608871459961
(438) DESCRIBE `ports` 0.00099611282348633
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00030207633972168
(440) DESCRIBE `ports` 0.0011081695556641
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00039792060852051
(442) DESCRIBE `ports` 0.00099706649780273
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00024890899658203
(444) DESCRIBE `ports` 0.00092411041259766
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00024986267089844
(446) DESCRIBE `avid_specials` 0.00082302093505859
(447) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67024 and class = 'Cruise') OR (item_id = 1017 AND class = 'Ship') OR (item_id = 136 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014879703521729
(448) DESCRIBE `cruiselines` 0.0014641284942627
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 136))) 0.0003809928894043
(450) DESCRIBE `orchid_image` 0.0012500286102295
(451) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '136') 0.053370952606201
(452) DESCRIBE `cruiselines` 0.0016300678253174
(453) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '136') 0.00027084350585938
(454) DESCRIBE `cruises` 0.0023279190063477
(455) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69031') 0.00037479400634766
(456) DESCRIBE `ships` 0.0021131038665771
(457) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.00052118301391602
(458) DESCRIBE `ships` 0.0022509098052979
(459) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00036191940307617
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022482872009277
(461) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036191940307617
(462) DESCRIBE `itineraries` 0.0010709762573242
(463) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69031') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00099492073059082
(464) DESCRIBE `ports` 0.0013740062713623
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00036191940307617
(466) DESCRIBE `ports` 0.0010619163513184
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00031113624572754
(468) DESCRIBE `ports` 0.0010499954223633
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00066113471984863
(470) DESCRIBE `sailingdates` 0.00099802017211914
(471) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69031') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00085592269897461
(472) DESCRIBE `ports` 0.0013840198516846
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00031495094299316
(474) DESCRIBE `ports` 0.00096893310546875
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00026106834411621
(476) DESCRIBE `ports` 0.0010380744934082
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00028204917907715
(478) DESCRIBE `ports` 0.0010058879852295
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00026297569274902
(480) DESCRIBE `ports` 0.00091814994812012
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00029993057250977
(482) DESCRIBE `ports` 0.0010011196136475
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00031399726867676
(484) DESCRIBE `ports` 0.0010421276092529
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00030112266540527
(486) DESCRIBE `ports` 0.00097298622131348
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00025415420532227
(488) DESCRIBE `ports` 0.001032829284668
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00033187866210938
(490) DESCRIBE `ports` 0.0010209083557129
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00028705596923828
(492) DESCRIBE `ports` 0.0011000633239746
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00031018257141113
(494) DESCRIBE `ports` 0.00098991394042969
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0002899169921875
(496) DESCRIBE `ports` 0.00090599060058594
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00026798248291016
(498) DESCRIBE `ports` 0.00093317031860352
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00024890899658203
(500) DESCRIBE `ports` 0.00089383125305176
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00030398368835449
(502) DESCRIBE `ports` 0.001032829284668
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00029182434082031
(504) DESCRIBE `ports` 0.00096917152404785
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00027704238891602
(506) DESCRIBE `ports` 0.00095295906066895
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00024700164794922
(508) DESCRIBE `ports` 0.00089597702026367
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00027108192443848
(510) DESCRIBE `ports` 0.00095891952514648
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00025415420532227
(512) DESCRIBE `ports` 0.00092983245849609
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00034093856811523
(514) DESCRIBE `ports` 0.00099587440490723
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00030207633972168
(516) DESCRIBE `ports` 0.00093698501586914
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00029706954956055
(518) DESCRIBE `ports` 0.0010371208190918
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00027585029602051
(520) DESCRIBE `ports` 0.0010209083557129
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00028014183044434
(522) DESCRIBE `ports` 0.0010039806365967
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00026297569274902
(524) DESCRIBE `ports` 0.00099492073059082
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00039005279541016
(526) DESCRIBE `ports` 0.0011489391326904
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00025510787963867
(528) DESCRIBE `ports` 0.00096011161804199
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00028705596923828
(530) DESCRIBE `ports` 0.0010271072387695
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00026106834411621
(532) DESCRIBE `ports` 0.00094199180603027
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00031805038452148
(534) DESCRIBE `ports` 0.0011391639709473
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0006251335144043
(536) DESCRIBE `ports` 0.002385139465332
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00041580200195312
(538) DESCRIBE `ports` 0.0011451244354248
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00027894973754883
(540) DESCRIBE `ports` 0.00095486640930176
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00030994415283203
(542) DESCRIBE `ports` 0.00093889236450195
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00025606155395508
(544) DESCRIBE `ports` 0.00093603134155273
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00028610229492188
(546) DESCRIBE `ports` 0.00094795227050781
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00025606155395508
(548) DESCRIBE `ports` 0.00095391273498535
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00032520294189453
(550) DESCRIBE `ports` 0.0010240077972412
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00027012825012207
(552) DESCRIBE `ports` 0.0011401176452637
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028610229492188
(554) DESCRIBE `ports` 0.00090909004211426
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0022737979888916
(556) DESCRIBE `ports` 0.0012869834899902
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043106079101562
(558) DESCRIBE `ports` 0.0051429271697998
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030398368835449
(560) DESCRIBE `ports` 0.0009760856628418
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00025796890258789
(562) DESCRIBE `ports` 0.00094699859619141
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00021696090698242
(564) DESCRIBE `ports` 0.00085592269897461
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00030303001403809
(566) DESCRIBE `ports` 0.00092601776123047
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00022006034851074
(568) DESCRIBE `ports` 0.00089693069458008
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00024604797363281
(570) DESCRIBE `ports` 0.00086617469787598
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00024104118347168
(572) DESCRIBE `avid_specials` 0.00083804130554199
(573) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69031 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 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.0014779567718506
(574) DESCRIBE `cruiselines` 0.0015079975128174
(575) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00032210350036621
(576) DESCRIBE `orchid_image` 0.0010941028594971
(577) DESCRIBE `cruiselines` 0.0014359951019287
(578) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00027990341186523
(579) DESCRIBE `cruises` 0.0022759437561035
(580) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61954') 0.00033378601074219
(581) DESCRIBE `ships` 0.0023560523986816
(582) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00041699409484863
(583) DESCRIBE `ships` 0.0022928714752197
(584) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.00070500373840332
(585) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019383430480957
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(587) DESCRIBE `itineraries` 0.0010089874267578
(588) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61954') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055193901062012
(589) DESCRIBE `ports` 0.0010979175567627
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049710273742676
(591) DESCRIBE `ports` 0.0011289119720459
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044512748718262
(593) DESCRIBE `ports` 0.001215934753418
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028109550476074
(595) DESCRIBE `sailingdates` 0.00085687637329102
(596) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61954') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005030632019043
(597) DESCRIBE `ports` 0.001011848449707
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042009353637695
(599) DESCRIBE `ports` 0.0010449886322021
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025320053100586
(601) DESCRIBE `ports` 0.00091314315795898
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027704238891602
(603) DESCRIBE `ports` 0.0009160041809082
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022315979003906
(605) DESCRIBE `ports` 0.0010378360748291
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025582313537598
(607) DESCRIBE `ports` 0.0008699893951416
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.002485990524292
(609) DESCRIBE `ports` 0.0011699199676514
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00035405158996582
(611) DESCRIBE `ports` 0.0033879280090332
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00030899047851562
(613) DESCRIBE `ports` 0.0010790824890137
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00027918815612793
(615) DESCRIBE `ports` 0.00095391273498535
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00048494338989258
(617) DESCRIBE `ports` 0.00098204612731934
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00040102005004883
(619) DESCRIBE `ports` 0.0012140274047852
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00024890899658203
(621) DESCRIBE `ports` 0.00087499618530273
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00025510787963867
(623) DESCRIBE `ports` 0.0011129379272461
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00022411346435547
(625) DESCRIBE `ports` 0.0010099411010742
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026798248291016
(627) DESCRIBE `ports` 0.0015590190887451
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00024294853210449
(629) DESCRIBE `ports` 0.00089406967163086
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00034189224243164
(631) DESCRIBE `ports` 0.001011848449707
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0020909309387207
(633) DESCRIBE `avid_specials` 0.0011138916015625
(634) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61954 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018289089202881
(635) DESCRIBE `cruiselines` 0.0014491081237793
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00047016143798828
(637) DESCRIBE `orchid_image` 0.0022139549255371
(638) DESCRIBE `cruiselines` 0.0027310848236084
(639) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00029301643371582
(640) DESCRIBE `cruises` 0.0072309970855713
(641) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72604') 0.00044894218444824
(642) DESCRIBE `ships` 0.021860122680664
(643) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.00055909156799316
(644) DESCRIBE `ships` 0.0024161338806152
(645) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00037908554077148
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00019216537475586
(647) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00017094612121582
(648) DESCRIBE `itineraries` 0.0010831356048584
(649) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72604') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007021427154541
(650) DESCRIBE `ports` 0.0011909008026123
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.00028705596923828
(652) DESCRIBE `ports` 0.00081801414489746
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.0002601146697998
(654) DESCRIBE `ports` 0.00097084045410156
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '469') 0.00026702880859375
(656) DESCRIBE `sailingdates` 0.00084209442138672
(657) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72604') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00081801414489746
(658) DESCRIBE `ports` 0.0010890960693359
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.00029993057250977
(660) DESCRIBE `ports` 0.00089120864868164
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '469') 0.00023388862609863
(662) DESCRIBE `ports` 0.0008089542388916
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2274))) 0.00027012825012207
(664) DESCRIBE `ports` 0.00082492828369141
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2274') 0.00024104118347168
(666) DESCRIBE `ports` 0.00081706047058105
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00026607513427734
(668) DESCRIBE `ports` 0.00097990036010742
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.00038790702819824
(670) DESCRIBE `ports` 0.0011081695556641
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 311))) 0.0004279613494873
(672) DESCRIBE `ports` 0.00097489356994629
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '311') 0.000244140625
(674) DESCRIBE `ports` 0.00099396705627441
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00029182434082031
(676) DESCRIBE `ports` 0.00093698501586914
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00026702880859375
(678) DESCRIBE `ports` 0.00092887878417969
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.0002751350402832
(680) DESCRIBE `ports` 0.00097393989562988
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.0002591609954834
(682) DESCRIBE `ports` 0.00098586082458496
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00030303001403809
(684) DESCRIBE `ports` 0.00088810920715332
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00024700164794922
(686) DESCRIBE `ports` 0.00085997581481934
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 672))) 0.00025486946105957
(688) DESCRIBE `ports` 0.00091314315795898
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '672') 0.0002601146697998
(690) DESCRIBE `ports` 0.00093698501586914
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2274))) 0.00025820732116699
(692) DESCRIBE `ports` 0.00082612037658691
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2274') 0.00022602081298828
(694) DESCRIBE `ports` 0.00082898139953613
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00024318695068359
(696) DESCRIBE `ports` 0.0008549690246582
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00023412704467773
(698) DESCRIBE `ports` 0.00090980529785156
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0002601146697998
(700) DESCRIBE `ports` 0.00093507766723633
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00026106834411621
(702) DESCRIBE `ports` 0.0010089874267578
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027108192443848
(704) DESCRIBE `ports` 0.00091409683227539
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019693374633789
(706) DESCRIBE `avid_specials` 0.00077104568481445
(707) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72604 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 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.0014770030975342
(708) DESCRIBE `cruiselines` 0.001270055770874
(709) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00029993057250977
(710) DESCRIBE `orchid_image` 0.00090885162353516
(711) DESCRIBE `cruises` 0.0022950172424316
(712) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62036') 0.00039386749267578
(713) DESCRIBE `ships` 0.0019237995147705
(714) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 784))) 0.00035309791564941
(715) DESCRIBE `ships` 0.0019600391387939
(716) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '784') 0.00040006637573242
(717) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002129077911377
(718) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020599365234375
(719) DESCRIBE `itineraries` 0.0012731552124023
(720) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62036') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089311599731445
(721) DESCRIBE `ports` 0.0014228820800781
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00032210350036621
(723) DESCRIBE `ports` 0.00089097023010254
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00028610229492188
(725) DESCRIBE `ports` 0.00085115432739258
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00024104118347168
(727) DESCRIBE `sailingdates` 0.00071191787719727
(728) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62036') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047707557678223
(729) DESCRIBE `ports` 0.00092196464538574
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00027298927307129
(731) DESCRIBE `ports` 0.00087499618530273
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00027203559875488
(733) DESCRIBE `ports` 0.00085806846618652
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00024199485778809
(735) DESCRIBE `ports` 0.00078582763671875
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00020503997802734
(737) DESCRIBE `ports` 0.00076985359191895
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00023388862609863
(739) DESCRIBE `ports` 0.00085902214050293
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00021505355834961
(741) DESCRIBE `ports` 0.00083303451538086
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00024986267089844
(743) DESCRIBE `ports` 0.00087499618530273
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00021505355834961
(745) DESCRIBE `ports` 0.00082898139953613
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00024104118347168
(747) DESCRIBE `ports` 0.00086593627929688
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.0002129077911377
(749) DESCRIBE `ports` 0.0008399486541748
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0002448558807373
(751) DESCRIBE `ports` 0.00083708763122559
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00021505355834961
(753) DESCRIBE `ports` 0.00083208084106445
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00022721290588379
(755) DESCRIBE `ports` 0.00082993507385254
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00022387504577637
(757) DESCRIBE `ports` 0.00090217590332031
(758) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00025415420532227
(759) DESCRIBE `ports` 0.00087404251098633
(760) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00023579597473145
(761) DESCRIBE `ports` 0.00086092948913574
(762) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00025105476379395
(763) DESCRIBE `ports` 0.00085186958312988
(764) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.00021600723266602
(765) DESCRIBE `ports` 0.00083303451538086
(766) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00024008750915527
(767) DESCRIBE `ports` 0.00084590911865234
(768) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00026202201843262
(769) DESCRIBE `ports` 0.00085091590881348
(770) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 824))) 0.0002439022064209
(771) DESCRIBE `ports` 0.00084900856018066
(772) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '824') 0.00024199485778809
(773) DESCRIBE `ports` 0.00086307525634766
(774) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00024294853210449
(775) DESCRIBE `ports` 0.00084900856018066
(776) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00021815299987793
(777) DESCRIBE `avid_specials` 0.00078296661376953
(778) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62036 and class = 'Cruise') OR (item_id = 784 AND class = 'Ship') OR (item_id = 50 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.001539945602417
(779) DESCRIBE `cruiselines` 0.0014090538024902
(780) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00030207633972168
(781) DESCRIBE `orchid_image` 0.00099396705627441
(782) DESCRIBE `cruiselines` 0.0012550354003906
(783) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00025200843811035
(784) DESCRIBE `cruises` 0.001990795135498
(785) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65383') 0.00029802322387695
(786) DESCRIBE `ships` 0.0018830299377441
(787) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 454))) 0.0003809928894043
(788) DESCRIBE `ships` 0.0021340847015381
(789) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '454') 0.00029993057250977
(790) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021982192993164
(791) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(792) DESCRIBE `itineraries` 0.00099778175354004
(793) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65383') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070285797119141
(794) DESCRIBE `ports` 0.001154899597168
(795) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00029706954956055
(796) DESCRIBE `ports` 0.00089502334594727
(797) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00026297569274902
(798) DESCRIBE `ports` 0.0009300708770752
(799) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00023484230041504
(800) DESCRIBE `sailingdates` 0.00086092948913574
(801) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65383') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072193145751953
(802) DESCRIBE `ports` 0.0011720657348633
(803) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00030612945556641
(804) DESCRIBE `ports` 0.00094103813171387
(805) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00023794174194336
(806) DESCRIBE `ports` 0.00093293190002441
(807) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00025606155395508
(808) DESCRIBE `ports` 0.00090599060058594
(809) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00022602081298828
(810) DESCRIBE `ports` 0.00088977813720703
(811) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00024890899658203
(812) DESCRIBE `ports` 0.00089907646179199
(813) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00022506713867188
(814) DESCRIBE `ports` 0.00089311599731445
(815) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00027108192443848
(816) DESCRIBE `ports` 0.0009620189666748
(817) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00022292137145996
(818) DESCRIBE `ports` 0.00091195106506348
(819) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00026297569274902
(820) DESCRIBE `ports` 0.00094699859619141
(821) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00024199485778809
(822) DESCRIBE `ports` 0.00087904930114746
(823) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00026392936706543
(824) DESCRIBE `ports` 0.00091385841369629
(825) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.0002281665802002
(826) DESCRIBE `ports` 0.00090503692626953
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0002448558807373
(828) DESCRIBE `ports` 0.00089716911315918
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00022220611572266
(830) DESCRIBE `ports` 0.0009160041809082
(831) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00024890899658203
(832) DESCRIBE `ports` 0.0010180473327637
(833) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00025415420532227
(834) DESCRIBE `ports` 0.00091099739074707
(835) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 622))) 0.00024795532226562
(836) DESCRIBE `ports` 0.00090813636779785
(837) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '622') 0.00025010108947754
(838) DESCRIBE `ports` 0.0008997917175293
(839) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00023889541625977
(840) DESCRIBE `ports` 0.0009300708770752
(841) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.0002598762512207
(842) DESCRIBE `ports` 0.00089216232299805
(843) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00022482872009277
(844) DESCRIBE `ports` 0.00094103813171387
(845) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00022292137145996
(846) DESCRIBE `ports` 0.00089406967163086
(847) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00024604797363281
(848) DESCRIBE `ports` 0.00088000297546387
(849) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00022602081298828
(850) DESCRIBE `ports` 0.00089001655578613
(851) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00025820732116699
(852) DESCRIBE `ports` 0.00086212158203125
(853) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00025606155395508
(854) DESCRIBE `ports` 0.0009160041809082
(855) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.0002589225769043
(856) DESCRIBE `ports` 0.00083112716674805
(857) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00023102760314941
(858) DESCRIBE `avid_specials` 0.00082302093505859
(859) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65383 and class = 'Cruise') OR (item_id = 454 AND class = 'Ship') OR (item_id = 12 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.0015602111816406
(860) DESCRIBE `cruiselines` 0.0014200210571289
(861) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00031089782714844
(862) DESCRIBE `orchid_image` 0.0010120868682861
(863) DESCRIBE `cruiselines` 0.0013129711151123
(864) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.0002739429473877
(865) DESCRIBE `cruiselines` 0.0016701221466064
(866) 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.0035660266876221
(867) DESCRIBE `ships` 0.0017900466918945
(868) 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.024706125259399
(869) DESCRIBE `cruisetypes` 0.0011529922485352
(870) DESCRIBE `destinations` 0.0014381408691406
(871) 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.0014400482177734