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

Total elapsed time: 0.40181183815002

# Query Time
(1) connect 0.00060105323791504
(2) DESCRIBE `cruises` 0.0022940635681152
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63631, 64454, 63632, 72464, 64444, 63893, 64792, 67016, 61580, 69938)) ORDER BY FIND_IN_SET(id, '63631,64454,63632,72464,64444,63893,64792,67016,61580,69938') 0.0017979145050049
(4) DESCRIBE `cruises` 0.0020678043365479
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63631') 0.00034308433532715
(6) DESCRIBE `ships` 0.0017788410186768
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00040698051452637
(8) DESCRIBE `ships` 0.0016920566558838
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.0002892017364502
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018501281738281
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017309188842773
(12) DESCRIBE `itineraries` 0.00094294548034668
(13) DESCRIBE `ports` 0.0010929107666016
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00030612945556641
(15) DESCRIBE `ports` 0.00089097023010254
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00025200843811035
(17) DESCRIBE `ports` 0.00084114074707031
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00023007392883301
(19) DESCRIBE `sailingdates` 0.00074505805969238
(20) DESCRIBE `ports` 0.00094485282897949
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00028300285339355
(22) DESCRIBE `ports` 0.00081777572631836
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00021600723266602
(24) DESCRIBE `ports` 0.00083303451538086
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00022983551025391
(26) DESCRIBE `ports` 0.00077986717224121
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00020098686218262
(28) DESCRIBE `ports` 0.00077986717224121
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2142))) 0.00024509429931641
(30) DESCRIBE `ports` 0.00081992149353027
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2142') 0.00021195411682129
(32) DESCRIBE `ports` 0.00078010559082031
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3022))) 0.00024700164794922
(34) DESCRIBE `ports` 0.00084400177001953
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3022') 0.0002131462097168
(36) DESCRIBE `ports` 0.00082015991210938
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.00023007392883301
(38) DESCRIBE `ports` 0.00083398818969727
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.00020718574523926
(40) DESCRIBE `ports` 0.00082206726074219
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1097))) 0.00027108192443848
(42) DESCRIBE `ports` 0.00082278251647949
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1097') 0.00022077560424805
(44) DESCRIBE `ports` 0.00077700614929199
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00023412704467773
(46) DESCRIBE `ports` 0.00078105926513672
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00020289421081543
(48) DESCRIBE `ports` 0.00077104568481445
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.0002288818359375
(50) DESCRIBE `ports` 0.00083613395690918
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00021505355834961
(52) DESCRIBE `ports` 0.0008389949798584
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 689))) 0.00023317337036133
(54) DESCRIBE `ports` 0.00085616111755371
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '689') 0.0002129077911377
(56) DESCRIBE `ports` 0.00083279609680176
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.00023102760314941
(58) DESCRIBE `ports` 0.00086402893066406
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '467') 0.00019693374633789
(60) DESCRIBE `ports` 0.00075411796569824
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00023794174194336
(62) DESCRIBE `ports` 0.00077295303344727
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.0002129077911377
(64) DESCRIBE `ports` 0.00077700614929199
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00023603439331055
(66) DESCRIBE `ports` 0.00078797340393066
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00024509429931641
(68) DESCRIBE `ports` 0.00086784362792969
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2147))) 0.00023388862609863
(70) DESCRIBE `ports` 0.00084209442138672
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2147') 0.00020885467529297
(72) DESCRIBE `ports` 0.00083017349243164
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00023293495178223
(74) DESCRIBE `ports` 0.00083494186401367
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00021696090698242
(76) DESCRIBE `ports` 0.00093197822570801
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00029516220092773
(78) DESCRIBE `ports` 0.00086498260498047
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00021600723266602
(80) DESCRIBE `avid_specials` 0.00076103210449219
(81) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63631 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 48 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.001568078994751
(82) DESCRIBE `cruiselines` 0.001384973526001
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00029706954956055
(84) DESCRIBE `orchid_image` 0.0010530948638916
(85) DESCRIBE `cruiselines` 0.0014111995697021
(86) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00026607513427734
(87) DESCRIBE `cruises` 0.0016388893127441
(88) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64454') 0.00030994415283203
(89) DESCRIBE `ships` 0.0016779899597168
(90) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1302))) 0.00038599967956543
(91) DESCRIBE `ships` 0.0017929077148438
(92) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1302') 0.00028514862060547
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00020408630371094
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00019097328186035
(95) DESCRIBE `itineraries` 0.00089788436889648
(96) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64454') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077390670776367
(97) DESCRIBE `ports` 0.0010061264038086
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026798248291016
(99) DESCRIBE `ports` 0.00077509880065918
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022721290588379
(101) DESCRIBE `ports` 0.00078296661376953
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022697448730469
(103) DESCRIBE `sailingdates` 0.00077199935913086
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64454') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075697898864746
(105) DESCRIBE `ports` 0.0010240077972412
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043296813964844
(107) DESCRIBE `ports` 0.00091290473937988
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022697448730469
(109) DESCRIBE `ports` 0.00080204010009766
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00024819374084473
(111) DESCRIBE `ports` 0.00082612037658691
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00022602081298828
(113) DESCRIBE `ports` 0.00080490112304688
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00025701522827148
(115) DESCRIBE `ports` 0.00086784362792969
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00024580955505371
(117) DESCRIBE `ports` 0.00087094306945801
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0002589225769043
(119) DESCRIBE `ports` 0.0012259483337402
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00027298927307129
(121) DESCRIBE `ports` 0.00082612037658691
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00025200843811035
(123) DESCRIBE `ports` 0.0008389949798584
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00021600723266602
(125) DESCRIBE `ports` 0.0008389949798584
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00025200843811035
(127) DESCRIBE `ports` 0.00081801414489746
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00021982192993164
(129) DESCRIBE `ports` 0.001176118850708
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00026202201843262
(131) DESCRIBE `ports` 0.00084400177001953
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00023317337036133
(133) DESCRIBE `ports` 0.0010390281677246
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027298927307129
(135) DESCRIBE `ports` 0.0008540153503418
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022101402282715
(137) DESCRIBE `ports` 0.00083804130554199
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00023221969604492
(139) DESCRIBE `ports` 0.00081896781921387
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00020217895507812
(141) DESCRIBE `ports` 0.00083398818969727
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00048995018005371
(143) DESCRIBE `ports` 0.0010859966278076
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00024700164794922
(145) DESCRIBE `ports` 0.0015699863433838
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00027322769165039
(147) DESCRIBE `ports` 0.00092601776123047
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.0002140998840332
(149) DESCRIBE `ports` 0.00077009201049805
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00023412704467773
(151) DESCRIBE `ports` 0.00077390670776367
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00021004676818848
(153) DESCRIBE `ports` 0.00079584121704102
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00023603439331055
(155) DESCRIBE `ports` 0.00081801414489746
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.0002140998840332
(157) DESCRIBE `ports` 0.00085186958312988
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00024700164794922
(159) DESCRIBE `ports` 0.00085616111755371
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00021600723266602
(161) DESCRIBE `ports` 0.00090599060058594
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00024890899658203
(163) DESCRIBE `ports` 0.00084304809570312
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00021195411682129
(165) DESCRIBE `ports` 0.001025915145874
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032401084899902
(167) DESCRIBE `ports` 0.00070595741271973
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001838207244873
(169) DESCRIBE `avid_specials` 0.00058889389038086
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64454 and class = 'Cruise') OR (item_id = 1302 AND class = 'Ship') OR (item_id = 18 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
(171) DESCRIBE `cruiselines` 0.00097799301147461
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00026583671569824
(173) DESCRIBE `orchid_image` 0.00076913833618164
(174) DESCRIBE `cruiselines` 0.00089311599731445
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020503997802734
(176) DESCRIBE `cruises` 0.0014371871948242
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63632') 0.00024509429931641
(178) DESCRIBE `ships` 0.0018460750579834
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00035500526428223
(180) DESCRIBE `ships` 0.0019600391387939
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00029993057250977
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022101402282715
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020098686218262
(184) DESCRIBE `itineraries` 0.001032829284668
(185) DESCRIBE `ports` 0.00095105171203613
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00044918060302734
(187) DESCRIBE `ports` 0.0011038780212402
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.0002601146697998
(189) DESCRIBE `ports` 0.00086283683776855
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00023484230041504
(191) DESCRIBE `sailingdates` 0.00077700614929199
(192) DESCRIBE `ports` 0.00062298774719238
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00021004676818848
(194) DESCRIBE `ports` 0.00065088272094727
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00016498565673828
(196) DESCRIBE `ports` 0.00065207481384277
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00017809867858887
(198) DESCRIBE `ports` 0.00063896179199219
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00016307830810547
(200) DESCRIBE `ports` 0.00065279006958008
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2142))) 0.00018095970153809
(202) DESCRIBE `ports` 0.00059223175048828
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2142') 0.00016212463378906
(204) DESCRIBE `ports` 0.00061893463134766
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3022))) 0.00029611587524414
(206) DESCRIBE `ports` 0.00061297416687012
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3022') 0.00016403198242188
(208) DESCRIBE `ports` 0.00059008598327637
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.00018000602722168
(210) DESCRIBE `ports` 0.00060391426086426
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.00016307830810547
(212) DESCRIBE `ports` 0.00059700012207031
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1097))) 0.00017905235290527
(214) DESCRIBE `ports` 0.00058412551879883
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1097') 0.00016093254089355
(216) DESCRIBE `ports` 0.00061583518981934
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00018000602722168
(218) DESCRIBE `ports` 0.00058698654174805
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00016498565673828
(220) DESCRIBE `ports` 0.00062203407287598
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00018620491027832
(222) DESCRIBE `ports` 0.00070595741271973
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00034618377685547
(224) DESCRIBE `avid_specials` 0.00091814994812012
(225) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63632 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 48 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.0016939640045166
(226) DESCRIBE `cruiselines` 0.0014400482177734
(227) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00030803680419922
(228) DESCRIBE `orchid_image` 0.0010409355163574
(229) DESCRIBE `cruiselines` 0.0013439655303955
(230) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00026917457580566
(231) DESCRIBE `cruises` 0.0020878314971924
(232) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72464') 0.00032401084899902
(233) DESCRIBE `ships` 0.0019750595092773
(234) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00035595893859863
(235) DESCRIBE `ships` 0.0018320083618164
(236) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00027298927307129
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020790100097656
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022482872009277
(239) DESCRIBE `itineraries` 0.00097298622131348
(240) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72464') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077295303344727
(241) DESCRIBE `ports` 0.0010480880737305
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024199485778809
(243) DESCRIBE `ports` 0.00064802169799805
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018692016601562
(245) DESCRIBE `ports` 0.0006101131439209
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017499923706055
(247) DESCRIBE `sailingdates` 0.00053811073303223
(248) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72464') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059700012207031
(249) DESCRIBE `ports` 0.00081610679626465
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021004676818848
(251) DESCRIBE `ports` 0.00060796737670898
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001680850982666
(253) DESCRIBE `ports` 0.00059413909912109
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00026178359985352
(255) DESCRIBE `ports` 0.0006110668182373
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016903877258301
(257) DESCRIBE `ports` 0.00060510635375977
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00018596649169922
(259) DESCRIBE `ports` 0.00059604644775391
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00016403198242188
(261) DESCRIBE `ports` 0.00060009956359863
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00018000602722168
(263) DESCRIBE `ports` 0.00058817863464355
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0001671314239502
(265) DESCRIBE `ports` 0.00058698654174805
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00021886825561523
(267) DESCRIBE `ports` 0.00060105323791504
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00016498565673828
(269) DESCRIBE `ports` 0.00059008598327637
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00017786026000977
(271) DESCRIBE `ports` 0.00058698654174805
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00015997886657715
(273) DESCRIBE `ports` 0.00058412551879883
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00019288063049316
(275) DESCRIBE `ports` 0.00058603286743164
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00016593933105469
(277) DESCRIBE `ports` 0.00059199333190918
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018501281738281
(279) DESCRIBE `ports` 0.00060892105102539
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018000602722168
(281) DESCRIBE `ports` 0.00058817863464355
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00018215179443359
(283) DESCRIBE `ports` 0.00058698654174805
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00015807151794434
(285) DESCRIBE `ports` 0.00060701370239258
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00018191337585449
(287) DESCRIBE `ports` 0.00058603286743164
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00015997886657715
(289) DESCRIBE `ports` 0.00058221817016602
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018095970153809
(291) DESCRIBE `ports` 0.00062203407287598
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016212463378906
(293) DESCRIBE `avid_specials` 0.00053310394287109
(294) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72464 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 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.00086092948913574
(295) DESCRIBE `cruiselines` 0.00091910362243652
(296) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00019288063049316
(297) DESCRIBE `orchid_image` 0.00065517425537109
(298) DESCRIBE `cruiselines` 0.00080585479736328
(299) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00016689300537109
(300) DESCRIBE `cruises` 0.0014050006866455
(301) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64444') 0.00022315979003906
(302) DESCRIBE `ships` 0.0011708736419678
(303) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1302))) 0.00025105476379395
(304) DESCRIBE `ships` 0.0011470317840576
(305) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1302') 0.00017905235290527
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016093254089355
(307) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0001530647277832
(308) DESCRIBE `itineraries` 0.00059819221496582
(309) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64444') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039196014404297
(310) DESCRIBE `ports` 0.00077700614929199
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019311904907227
(312) DESCRIBE `ports` 0.00060105323791504
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018501281738281
(314) DESCRIBE `ports` 0.00063705444335938
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017380714416504
(316) DESCRIBE `sailingdates` 0.00053906440734863
(317) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64444') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036811828613281
(318) DESCRIBE `ports` 0.00068211555480957
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018811225891113
(320) DESCRIBE `ports` 0.00059294700622559
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016403198242188
(322) DESCRIBE `ports` 0.00059294700622559
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00018501281738281
(324) DESCRIBE `ports` 0.00058579444885254
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016212463378906
(326) DESCRIBE `ports` 0.00058889389038086
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00018000602722168
(328) DESCRIBE `ports` 0.00061202049255371
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00016403198242188
(330) DESCRIBE `ports` 0.00058698654174805
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00018501281738281
(332) DESCRIBE `ports` 0.00069904327392578
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.0003809928894043
(334) DESCRIBE `ports` 0.001060962677002
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00024795532226562
(336) DESCRIBE `ports` 0.00093889236450195
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00022315979003906
(338) DESCRIBE `ports` 0.00083398818969727
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00023388862609863
(340) DESCRIBE `ports` 0.00087404251098633
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00024986267089844
(342) DESCRIBE `ports` 0.00087308883666992
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00025415420532227
(344) DESCRIBE `ports` 0.00086617469787598
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00021910667419434
(346) DESCRIBE `ports` 0.00089502334594727
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025510787963867
(348) DESCRIBE `ports` 0.00088596343994141
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022315979003906
(350) DESCRIBE `avid_specials` 0.00074505805969238
(351) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64444 and class = 'Cruise') OR (item_id = 1302 AND class = 'Ship') OR (item_id = 18 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.0015769004821777
(352) DESCRIBE `cruiselines` 0.0012490749359131
(353) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00031805038452148
(354) DESCRIBE `orchid_image` 0.0009770393371582
(355) DESCRIBE `cruiselines` 0.001230001449585
(356) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00029802322387695
(357) DESCRIBE `cruises` 0.0014572143554688
(358) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63893') 0.00025486946105957
(359) DESCRIBE `ships` 0.0011298656463623
(360) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00024700164794922
(361) DESCRIBE `ships` 0.0011720657348633
(362) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.00018501281738281
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016212463378906
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015401840209961
(365) DESCRIBE `itineraries` 0.00062918663024902
(366) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63893') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050783157348633
(367) DESCRIBE `ports` 0.00066018104553223
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00022006034851074
(369) DESCRIBE `ports` 0.00060296058654785
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00021505355834961
(371) DESCRIBE `ports` 0.00078296661376953
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00018405914306641
(373) DESCRIBE `sailingdates` 0.00058603286743164
(374) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63893') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039386749267578
(375) DESCRIBE `ports` 0.00068211555480957
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00020503997802734
(377) DESCRIBE `ports` 0.00066900253295898
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00016999244689941
(379) DESCRIBE `ports` 0.00059318542480469
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00017619132995605
(381) DESCRIBE `ports` 0.00058817863464355
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00015997886657715
(383) DESCRIBE `ports` 0.0006868839263916
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00018692016601562
(385) DESCRIBE `ports` 0.00074219703674316
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.0001678466796875
(387) DESCRIBE `ports` 0.0006098747253418
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00019097328186035
(389) DESCRIBE `ports` 0.00061202049255371
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00016999244689941
(391) DESCRIBE `ports` 0.00060486793518066
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00019383430480957
(393) DESCRIBE `ports` 0.00060391426086426
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00017094612121582
(395) DESCRIBE `avid_specials` 0.00055098533630371
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63893 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 53 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00091195106506348
(397) DESCRIBE `cruiselines` 0.00090813636779785
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021004676818848
(399) DESCRIBE `orchid_image` 0.00070405006408691
(400) DESCRIBE `cruiselines` 0.00086307525634766
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018692016601562
(402) DESCRIBE `cruises` 0.0011270046234131
(403) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64792') 0.00020217895507812
(404) DESCRIBE `ships` 0.0011420249938965
(405) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.0002288818359375
(406) DESCRIBE `ships` 0.0011239051818848
(407) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00017285346984863
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019598007202148
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019407272338867
(410) DESCRIBE `itineraries` 0.00070619583129883
(411) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64792') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050497055053711
(412) DESCRIBE `ports` 0.00066494941711426
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021004676818848
(414) DESCRIBE `ports` 0.0005958080291748
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0001828670501709
(416) DESCRIBE `ports` 0.00067496299743652
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017595291137695
(418) DESCRIBE `sailingdates` 0.00056195259094238
(419) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64792') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003509521484375
(420) DESCRIBE `ports` 0.00060677528381348
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018095970153809
(422) DESCRIBE `ports` 0.00060892105102539
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016307830810547
(424) DESCRIBE `ports` 0.00058889389038086
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00025296211242676
(426) DESCRIBE `ports` 0.00061607360839844
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016498565673828
(428) DESCRIBE `ports` 0.00062704086303711
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00018501281738281
(430) DESCRIBE `ports` 0.0005948543548584
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00016689300537109
(432) DESCRIBE `ports` 0.00058913230895996
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00018501281738281
(434) DESCRIBE `ports` 0.00061297416687012
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018787384033203
(436) DESCRIBE `ports` 0.00059795379638672
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00018095970153809
(438) DESCRIBE `ports` 0.00079584121704102
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00025796890258789
(440) DESCRIBE `ports` 0.00078916549682617
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024294853210449
(442) DESCRIBE `ports` 0.00079178810119629
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00020480155944824
(444) DESCRIBE `avid_specials` 0.00071501731872559
(445) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64792 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 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.00087404251098633
(446) DESCRIBE `cruiselines` 0.00093507766723633
(447) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021600723266602
(448) DESCRIBE `orchid_image` 0.00066804885864258
(449) DESCRIBE `cruiselines` 0.00084209442138672
(450) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00022101402282715
(451) DESCRIBE `cruises` 0.0013079643249512
(452) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67016') 0.00023198127746582
(453) DESCRIBE `ships` 0.0011420249938965
(454) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.0002439022064209
(455) DESCRIBE `ships` 0.0011560916900635
(456) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.00018596649169922
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016117095947266
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001518726348877
(459) DESCRIBE `itineraries` 0.00063204765319824
(460) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67016') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051403045654297
(461) DESCRIBE `ports` 0.00084400177001953
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00021910667419434
(463) DESCRIBE `ports` 0.00060200691223145
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00020503997802734
(465) DESCRIBE `ports` 0.00060319900512695
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00017189979553223
(467) DESCRIBE `sailingdates` 0.00055503845214844
(468) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67016') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055098533630371
(469) DESCRIBE `ports` 0.00062012672424316
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00019097328186035
(471) DESCRIBE `ports` 0.00061392784118652
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00016617774963379
(473) DESCRIBE `ports` 0.00058817863464355
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00018000602722168
(475) DESCRIBE `ports` 0.00059199333190918
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016903877258301
(477) DESCRIBE `ports` 0.00062799453735352
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0001838207244873
(479) DESCRIBE `ports` 0.00059080123901367
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00016403198242188
(481) DESCRIBE `ports` 0.00060105323791504
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00017905235290527
(483) DESCRIBE `ports` 0.00059199333190918
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00016307830810547
(485) DESCRIBE `ports` 0.00059604644775391
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00018000602722168
(487) DESCRIBE `ports` 0.00069499015808105
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0002131462097168
(489) DESCRIBE `ports` 0.00078487396240234
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00022006034851074
(491) DESCRIBE `ports` 0.00064802169799805
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.0001680850982666
(493) DESCRIBE `avid_specials` 0.00054192543029785
(494) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67016 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 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.00086593627929688
(495) DESCRIBE `cruiselines` 0.00098109245300293
(496) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0002291202545166
(497) DESCRIBE `orchid_image` 0.0008552074432373
(498) DESCRIBE `cruiselines` 0.00093889236450195
(499) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00021505355834961
(500) DESCRIBE `cruises` 0.0012478828430176
(501) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61580') 0.00025010108947754
(502) DESCRIBE `ships` 0.0011560916900635
(503) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00023698806762695
(504) DESCRIBE `ships` 0.0011541843414307
(505) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00018596649169922
(506) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016283988952637
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001530647277832
(508) DESCRIBE `itineraries` 0.00064301490783691
(509) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61580') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063300132751465
(510) DESCRIBE `ports` 0.00072002410888672
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022792816162109
(512) DESCRIBE `ports` 0.00060391426086426
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00018692016601562
(514) DESCRIBE `ports` 0.00059795379638672
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017118453979492
(516) DESCRIBE `sailingdates` 0.00054192543029785
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61580') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055789947509766
(518) DESCRIBE `ports` 0.00069403648376465
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002129077911377
(520) DESCRIBE `ports` 0.0006248950958252
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00016903877258301
(522) DESCRIBE `ports` 0.00060391426086426
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00019192695617676
(524) DESCRIBE `ports` 0.00059604644775391
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00016999244689941
(526) DESCRIBE `ports` 0.0006260871887207
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00018596649169922
(528) DESCRIBE `ports` 0.00059318542480469
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00016307830810547
(530) DESCRIBE `ports` 0.00062298774719238
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00017809867858887
(532) DESCRIBE `ports` 0.00060582160949707
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00016307830810547
(534) DESCRIBE `ports` 0.00059008598327637
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00018191337585449
(536) DESCRIBE `ports` 0.00058794021606445
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00016283988952637
(538) DESCRIBE `ports` 0.00062918663024902
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00018906593322754
(540) DESCRIBE `ports` 0.00059199333190918
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00015878677368164
(542) DESCRIBE `ports` 0.00058412551879883
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00017905235290527
(544) DESCRIBE `ports` 0.00060510635375977
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00016212463378906
(546) DESCRIBE `ports` 0.00059103965759277
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00017809867858887
(548) DESCRIBE `ports` 0.00059103965759277
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00016498565673828
(550) DESCRIBE `ports` 0.00063300132751465
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00019407272338867
(552) DESCRIBE `ports` 0.00060796737670898
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00016903877258301
(554) DESCRIBE `ports` 0.00062799453735352
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020217895507812
(556) DESCRIBE `ports` 0.00059700012207031
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00016593933105469
(558) DESCRIBE `ports` 0.00060319900512695
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00018596649169922
(560) DESCRIBE `ports` 0.00080609321594238
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00016903877258301
(562) DESCRIBE `ports` 0.00059700012207031
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00018310546875
(564) DESCRIBE `ports` 0.00059890747070312
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00016307830810547
(566) DESCRIBE `ports` 0.00058603286743164
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00018119812011719
(568) DESCRIBE `ports` 0.00058913230895996
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00016498565673828
(570) DESCRIBE `ports` 0.00060796737670898
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00017213821411133
(572) DESCRIBE `ports` 0.00058317184448242
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00018191337585449
(574) DESCRIBE `ports` 0.00063395500183105
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00018787384033203
(576) DESCRIBE `ports` 0.00059700012207031
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00018000602722168
(578) DESCRIBE `ports` 0.00063204765319824
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00018787384033203
(580) DESCRIBE `ports` 0.00062990188598633
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00017094612121582
(582) DESCRIBE `ports` 0.00063395500183105
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 192))) 0.00018596649169922
(584) DESCRIBE `ports` 0.00070595741271973
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '192') 0.00023579597473145
(586) DESCRIBE `ports` 0.00074315071105957
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00021791458129883
(588) DESCRIBE `ports` 0.00059700012207031
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00016689300537109
(590) DESCRIBE `ports` 0.0006110668182373
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00019001960754395
(592) DESCRIBE `ports` 0.0006859302520752
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00017189979553223
(594) DESCRIBE `ports` 0.00063681602478027
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00022196769714355
(596) DESCRIBE `ports` 0.00061416625976562
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00016593933105469
(598) DESCRIBE `avid_specials` 0.00054097175598145
(599) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61580 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00087714195251465
(600) DESCRIBE `cruiselines` 0.0011129379272461
(601) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023412704467773
(602) DESCRIBE `orchid_image` 0.00069594383239746
(603) DESCRIBE `cruiselines` 0.00088810920715332
(604) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020098686218262
(605) DESCRIBE `cruises` 0.001276969909668
(606) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69938') 0.00024199485778809
(607) DESCRIBE `ships` 0.00118088722229
(608) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00026488304138184
(609) DESCRIBE `ships` 0.0011801719665527
(610) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00019311904907227
(611) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018000602722168
(612) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015401840209961
(613) DESCRIBE `itineraries` 0.00069284439086914
(614) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69938') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058698654174805
(615) DESCRIBE `ports` 0.00075888633728027
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023198127746582
(617) DESCRIBE `ports` 0.00061583518981934
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018692016601562
(619) DESCRIBE `ports` 0.00063490867614746
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017380714416504
(621) DESCRIBE `sailingdates` 0.0005490779876709
(622) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69938') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053000450134277
(623) DESCRIBE `ports` 0.00068902969360352
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020694732666016
(625) DESCRIBE `ports` 0.0006101131439209
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016999244689941
(627) DESCRIBE `ports` 0.00059080123901367
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00017786026000977
(629) DESCRIBE `ports` 0.00064492225646973
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0001671314239502
(631) DESCRIBE `ports` 0.00060081481933594
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00018906593322754
(633) DESCRIBE `ports` 0.00060701370239258
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016498565673828
(635) DESCRIBE `ports` 0.00060200691223145
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00020313262939453
(637) DESCRIBE `ports` 0.0006108283996582
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00017094612121582
(639) DESCRIBE `ports` 0.00059390068054199
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00018882751464844
(641) DESCRIBE `ports` 0.00060105323791504
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0001680850982666
(643) DESCRIBE `ports` 0.00061988830566406
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018596649169922
(645) DESCRIBE `ports` 0.00060200691223145
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016903877258301
(647) DESCRIBE `ports` 0.00060892105102539
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00018501281738281
(649) DESCRIBE `ports` 0.00063490867614746
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00016903877258301
(651) DESCRIBE `ports` 0.00068998336791992
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00018596649169922
(653) DESCRIBE `ports` 0.0005948543548584
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00016403198242188
(655) DESCRIBE `ports` 0.0005948543548584
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00018501281738281
(657) DESCRIBE `ports` 0.00061988830566406
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00019407272338867
(659) DESCRIBE `ports` 0.00059700012207031
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 664))) 0.00019001960754395
(661) DESCRIBE `ports` 0.00059294700622559
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '664') 0.00016689300537109
(663) DESCRIBE `ports` 0.00059080123901367
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00017404556274414
(665) DESCRIBE `ports` 0.00059604644775391
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00015997886657715
(667) DESCRIBE `ports` 0.00058794021606445
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2152))) 0.00018501281738281
(669) DESCRIBE `ports` 0.00058698654174805
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2152') 0.00016498565673828
(671) DESCRIBE `ports` 0.00059390068054199
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00018095970153809
(673) DESCRIBE `ports` 0.00059008598327637
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016403198242188
(675) DESCRIBE `ports` 0.00058913230895996
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018501281738281
(677) DESCRIBE `ports` 0.00061821937561035
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016903877258301
(679) DESCRIBE `avid_specials` 0.00058102607727051
(680) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69938 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 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.00089287757873535
(681) DESCRIBE `cruiselines` 0.00092816352844238
(682) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021815299987793
(683) DESCRIBE `orchid_image` 0.00071001052856445
(684) DESCRIBE `cruiselines` 0.00084590911865234
(685) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018882751464844
(686) DESCRIBE `ships` 0.0014629364013672
(687) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '78', '340', '547', '657', '82', '84', '401', '1302', '1607', '75', '81', '313', '74', '335')) ORDER BY FIND_IN_SET(id, '792,78,340,547,657,82,84,401,1302,1607,75,81,313,74,335') 0.00072693824768066
(688) DESCRIBE `cruisetypes` 0.00072407722473145
(689) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '18') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.03273606300354
(690) DESCRIBE `destinations` 0.0015020370483398
(691) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '12', '11', '25', '48', '43', '22', '35', '26', '38', '37', '40', '53', '49', '21', '34', '28', '29', '10', '8', '9', '30')) ORDER BY FIND_IN_SET(id, '2,12,11,25,48,43,22,35,26,38,37,40,53,49,21,34,28,29,10,8,9,30') 0.0011179447174072
(692) DESCRIBE `cruiselines` 0.0016841888427734
(693) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00033712387084961
(694) DESCRIBE `cruiselines` 0.0015890598297119
(695) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0003199577331543