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

Total elapsed time: 0.4426326751709

# Query Time
(1) connect 0.00061392784118652
(2) DESCRIBE `cruises` 0.0021591186523438
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70200, 62620, 62650, 62661, 72548, 62662, 71451, 64924, 67958, 70352)) ORDER BY FIND_IN_SET(id, '70200,62620,62650,62661,72548,62662,71451,64924,67958,70352') 0.0010001659393311
(4) DESCRIBE `cruises` 0.0015439987182617
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70200') 0.00027704238891602
(6) DESCRIBE `ships` 0.0013611316680908
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00027894973754883
(8) DESCRIBE `ships` 0.0012640953063965
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00019502639770508
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(12) DESCRIBE `itineraries` 0.00082683563232422
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70200') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079107284545898
(14) DESCRIBE `ports` 0.00096297264099121
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00027203559875488
(16) DESCRIBE `ports` 0.00085687637329102
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023698806762695
(18) DESCRIBE `ports` 0.00069785118103027
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020194053649902
(20) DESCRIBE `sailingdates` 0.00062108039855957
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70200') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062704086303711
(22) DESCRIBE `ports` 0.00081586837768555
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024700164794922
(24) DESCRIBE `ports` 0.00071501731872559
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001981258392334
(26) DESCRIBE `ports` 0.00069499015808105
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00029301643371582
(28) DESCRIBE `ports` 0.00083804130554199
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.0002129077911377
(30) DESCRIBE `ports` 0.00067996978759766
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00024986267089844
(32) DESCRIBE `ports` 0.00095605850219727
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00027608871459961
(34) DESCRIBE `ports` 0.0011129379272461
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2130))) 0.0003058910369873
(36) DESCRIBE `ports` 0.0010809898376465
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2130') 0.00025105476379395
(38) DESCRIBE `ports` 0.00098109245300293
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00027203559875488
(40) DESCRIBE `ports` 0.00097799301147461
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.0002739429473877
(42) DESCRIBE `ports` 0.0010678768157959
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00035500526428223
(44) DESCRIBE `ports` 0.0010819435119629
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00027108192443848
(46) DESCRIBE `ports` 0.0010700225830078
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00029110908508301
(48) DESCRIBE `ports` 0.00092697143554688
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00028014183044434
(50) DESCRIBE `ports` 0.0010421276092529
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031590461730957
(52) DESCRIBE `ports` 0.0010979175567627
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029897689819336
(54) DESCRIBE `ports` 0.00095200538635254
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0002901554107666
(56) DESCRIBE `ports` 0.00098514556884766
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0002748966217041
(58) DESCRIBE `ports` 0.0010159015655518
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00030303001403809
(60) DESCRIBE `ports` 0.0010910034179688
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00027894973754883
(62) DESCRIBE `ports` 0.0010509490966797
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00035595893859863
(64) DESCRIBE `ports` 0.0010659694671631
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00034308433532715
(66) DESCRIBE `ports` 0.0010700225830078
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00029587745666504
(68) DESCRIBE `ports` 0.0010149478912354
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00028705596923828
(70) DESCRIBE `ports` 0.001060962677002
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1135))) 0.00027704238891602
(72) DESCRIBE `ports` 0.0010011196136475
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1135') 0.0002589225769043
(74) DESCRIBE `ports` 0.0010159015655518
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1135))) 0.00028586387634277
(76) DESCRIBE `ports` 0.0010330677032471
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1135') 0.00026202201843262
(78) DESCRIBE `ports` 0.00098490715026855
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030112266540527
(80) DESCRIBE `ports` 0.001046895980835
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00031709671020508
(82) DESCRIBE `ports` 0.0010781288146973
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00032401084899902
(84) DESCRIBE `ports` 0.0010709762573242
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00027799606323242
(86) DESCRIBE `ports` 0.001007080078125
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031208992004395
(88) DESCRIBE `ports` 0.0013530254364014
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0002598762512207
(90) DESCRIBE `ports` 0.0010199546813965
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00030183792114258
(92) DESCRIBE `ports` 0.0010640621185303
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00029087066650391
(94) DESCRIBE `ports` 0.0010697841644287
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029897689819336
(96) DESCRIBE `ports` 0.001101016998291
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0002741813659668
(98) DESCRIBE `ports` 0.0010240077972412
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030398368835449
(100) DESCRIBE `ports` 0.0010919570922852
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00026202201843262
(102) DESCRIBE `avid_specials` 0.00095415115356445
(103) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70200 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 38 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.001788854598999
(104) DESCRIBE `cruiselines` 0.0018031597137451
(105) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030994415283203
(106) DESCRIBE `orchid_image` 0.00086522102355957
(107) DESCRIBE `cruiselines` 0.0010640621185303
(108) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00025105476379395
(109) DESCRIBE `cruises` 0.0018970966339111
(110) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62620') 0.00026893615722656
(111) DESCRIBE `ships` 0.0015599727630615
(112) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00031208992004395
(113) DESCRIBE `ships` 0.0014469623565674
(114) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00018811225891113
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017213821411133
(117) DESCRIBE `itineraries` 0.00078892707824707
(118) DESCRIBE `ports` 0.0007929801940918
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023603439331055
(120) DESCRIBE `ports` 0.0007331371307373
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002448558807373
(122) DESCRIBE `ports` 0.00077295303344727
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00021195411682129
(124) DESCRIBE `sailingdates` 0.00072312355041504
(125) DESCRIBE `ports` 0.00075387954711914
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025296211242676
(127) DESCRIBE `ports` 0.0010061264038086
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002448558807373
(129) DESCRIBE `ports` 0.0010027885437012
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.0002901554107666
(131) DESCRIBE `ports` 0.00093603134155273
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00019598007202148
(133) DESCRIBE `ports` 0.0011899471282959
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00027203559875488
(135) DESCRIBE `ports` 0.00098013877868652
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00023698806762695
(137) DESCRIBE `ports` 0.00097203254699707
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2130))) 0.00027203559875488
(139) DESCRIBE `ports` 0.0009160041809082
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2130') 0.0002439022064209
(141) DESCRIBE `ports` 0.00096392631530762
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00027298927307129
(143) DESCRIBE `ports` 0.00099301338195801
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00024700164794922
(145) DESCRIBE `ports` 0.00096607208251953
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00027203559875488
(147) DESCRIBE `ports` 0.0010819435119629
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00026488304138184
(149) DESCRIBE `ports` 0.00072193145751953
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00022411346435547
(151) DESCRIBE `ports` 0.00068807601928711
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00018692016601562
(153) DESCRIBE `ports` 0.00086593627929688
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021505355834961
(155) DESCRIBE `ports` 0.00069713592529297
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019598007202148
(157) DESCRIBE `avid_specials` 0.0008089542388916
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62620 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 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.00088191032409668
(159) DESCRIBE `cruiselines` 0.0012059211730957
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045490264892578
(161) DESCRIBE `orchid_image` 0.0012121200561523
(162) DESCRIBE `cruiselines` 0.0014970302581787
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00029420852661133
(164) DESCRIBE `cruises` 0.0021371841430664
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62650') 0.00027298927307129
(166) DESCRIBE `ships` 0.0020861625671387
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00039291381835938
(168) DESCRIBE `ships` 0.00211501121521
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00030016899108887
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022792816162109
(172) DESCRIBE `itineraries` 0.00099396705627441
(173) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62650') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00076699256896973
(174) DESCRIBE `ports` 0.0010888576507568
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.0002751350402832
(176) DESCRIBE `ports` 0.0011320114135742
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00028491020202637
(178) DESCRIBE `ports` 0.0010478496551514
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00025796890258789
(180) DESCRIBE `sailingdates` 0.00090503692626953
(181) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62650') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073099136352539
(182) DESCRIBE `ports` 0.0010561943054199
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00027894973754883
(184) DESCRIBE `ports` 0.00091695785522461
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00024509429931641
(186) DESCRIBE `ports` 0.0010170936584473
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00031208992004395
(188) DESCRIBE `ports` 0.0013689994812012
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00030016899108887
(190) DESCRIBE `ports` 0.0010859966278076
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00035691261291504
(192) DESCRIBE `ports` 0.0010671615600586
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00027894973754883
(194) DESCRIBE `ports` 0.0010581016540527
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00030303001403809
(196) DESCRIBE `ports` 0.0010881423950195
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00028491020202637
(198) DESCRIBE `ports` 0.0010559558868408
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00032997131347656
(200) DESCRIBE `ports` 0.0011320114135742
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00031900405883789
(202) DESCRIBE `ports` 0.0011258125305176
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00035715103149414
(204) DESCRIBE `ports` 0.012481212615967
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00039792060852051
(206) DESCRIBE `avid_specials` 0.0014050006866455
(207) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62650 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 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.0011160373687744
(208) DESCRIBE `cruiselines` 0.0011298656463623
(209) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00027894973754883
(210) DESCRIBE `orchid_image` 0.00092506408691406
(211) DESCRIBE `cruiselines` 0.00098395347595215
(212) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00023007392883301
(213) DESCRIBE `cruises` 0.0024938583374023
(214) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.0003361701965332
(215) DESCRIBE `ships` 0.0020508766174316
(216) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.0004730224609375
(217) DESCRIBE `ships` 0.0023729801177979
(218) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00032901763916016
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023198127746582
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022292137145996
(221) DESCRIBE `itineraries` 0.0010230541229248
(222) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063896179199219
(223) DESCRIBE `ports` 0.0090970993041992
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0004420280456543
(225) DESCRIBE `ports` 0.00089597702026367
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020599365234375
(227) DESCRIBE `ports` 0.00089287757873535
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023508071899414
(229) DESCRIBE `sailingdates` 0.00074887275695801
(230) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62661') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056099891662598
(231) DESCRIBE `ports` 0.0013718605041504
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00034523010253906
(233) DESCRIBE `ports` 0.0011861324310303
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028204917907715
(235) DESCRIBE `ports` 0.0010688304901123
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031399726867676
(237) DESCRIBE `ports` 0.0011060237884521
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002739429473877
(239) DESCRIBE `ports` 0.0010809898376465
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00030803680419922
(241) DESCRIBE `ports` 0.0010721683502197
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0002748966217041
(243) DESCRIBE `ports` 0.0010941028594971
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00029420852661133
(245) DESCRIBE `ports` 0.0011179447174072
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00031805038452148
(247) DESCRIBE `ports` 0.0010960102081299
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030517578125
(249) DESCRIBE `ports` 0.001107931137085
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026917457580566
(251) DESCRIBE `ports` 0.0010471343994141
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028395652770996
(253) DESCRIBE `ports` 0.0010600090026855
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0002598762512207
(255) DESCRIBE `ports` 0.001068115234375
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029206275939941
(257) DESCRIBE `ports` 0.0010898113250732
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00026106834411621
(259) DESCRIBE `avid_specials` 0.0010371208190918
(260) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0019350051879883
(261) DESCRIBE `cruiselines` 0.0016040802001953
(262) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003960132598877
(263) DESCRIBE `orchid_image` 0.0012850761413574
(264) DESCRIBE `cruiselines` 0.0016019344329834
(265) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032186508178711
(266) DESCRIBE `cruises` 0.0022509098052979
(267) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72548') 0.00034499168395996
(268) DESCRIBE `ships` 0.002249002456665
(269) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00041413307189941
(270) DESCRIBE `ships` 0.0014209747314453
(271) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00051093101501465
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028586387634277
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(274) DESCRIBE `itineraries` 0.0011801719665527
(275) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72548') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067520141601562
(276) DESCRIBE `ports` 0.0010988712310791
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00031495094299316
(278) DESCRIBE `ports` 0.00095009803771973
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00026297569274902
(280) DESCRIBE `ports` 0.00096988677978516
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00025510787963867
(282) DESCRIBE `sailingdates` 0.00084805488586426
(283) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72548') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066709518432617
(284) DESCRIBE `ports` 0.0010359287261963
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00032687187194824
(286) DESCRIBE `ports` 0.00094795227050781
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00025296211242676
(288) DESCRIBE `ports` 0.00092101097106934
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00028514862060547
(290) DESCRIBE `ports` 0.0010011196136475
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00025486946105957
(292) DESCRIBE `ports` 0.00096511840820312
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00027799606323242
(294) DESCRIBE `ports` 0.00097298622131348
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00023698806762695
(296) DESCRIBE `ports` 0.00092792510986328
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00027990341186523
(298) DESCRIBE `ports` 0.00098705291748047
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00025081634521484
(300) DESCRIBE `ports` 0.00094389915466309
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00028300285339355
(302) DESCRIBE `ports` 0.0009000301361084
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00023508071899414
(304) DESCRIBE `ports` 0.00086712837219238
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00027990341186523
(306) DESCRIBE `ports` 0.00087594985961914
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00022220611572266
(308) DESCRIBE `ports` 0.00088596343994141
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00030088424682617
(310) DESCRIBE `ports` 0.00093698501586914
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.0002598762512207
(312) DESCRIBE `avid_specials` 0.00094199180603027
(313) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72548 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 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.0017349720001221
(314) DESCRIBE `cruiselines` 0.0016129016876221
(315) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003809928894043
(316) DESCRIBE `orchid_image` 0.0011248588562012
(317) DESCRIBE `cruiselines` 0.0013248920440674
(318) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027585029602051
(319) DESCRIBE `cruises` 0.001384973526001
(320) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62662') 0.00024604797363281
(321) DESCRIBE `ships` 0.001323938369751
(322) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00029587745666504
(323) DESCRIBE `ships` 0.0013039112091064
(324) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00021195411682129
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018215179443359
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(327) DESCRIBE `itineraries` 0.00075602531433105
(328) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62662') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00044608116149902
(329) DESCRIBE `ports` 0.0007328987121582
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023007392883301
(331) DESCRIBE `ports` 0.00068092346191406
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021004676818848
(333) DESCRIBE `ports` 0.00069999694824219
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023007392883301
(335) DESCRIBE `sailingdates` 0.00062799453735352
(336) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62662') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066709518432617
(337) DESCRIBE `ports` 0.0015280246734619
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041818618774414
(339) DESCRIBE `ports` 0.0010590553283691
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029516220092773
(341) DESCRIBE `ports` 0.00080513954162598
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00022315979003906
(343) DESCRIBE `ports` 0.00068116188049316
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018811225891113
(345) DESCRIBE `ports` 0.00069689750671387
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020503997802734
(347) DESCRIBE `ports` 0.00067591667175293
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00019097328186035
(349) DESCRIBE `ports` 0.00069499015808105
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024604797363281
(351) DESCRIBE `ports` 0.00067782402038574
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019502639770508
(353) DESCRIBE `ports` 0.0006711483001709
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022697448730469
(355) DESCRIBE `ports` 0.00068402290344238
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018692016601562
(357) DESCRIBE `ports` 0.00066184997558594
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00022101402282715
(359) DESCRIBE `ports` 0.0006718635559082
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017905235290527
(361) DESCRIBE `ports` 0.00070095062255859
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021004676818848
(363) DESCRIBE `ports` 0.0006711483001709
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017905235290527
(365) DESCRIBE `avid_specials` 0.00063490867614746
(366) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62662 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.00096607208251953
(367) DESCRIBE `cruiselines` 0.0011019706726074
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024700164794922
(369) DESCRIBE `orchid_image` 0.00082588195800781
(370) DESCRIBE `cruiselines` 0.00094509124755859
(371) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020599365234375
(372) DESCRIBE `cruises` 0.0012850761413574
(373) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71451') 0.0002138614654541
(374) DESCRIBE `ships` 0.0012791156768799
(375) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00024700164794922
(376) DESCRIBE `ships` 0.0012450218200684
(377) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00018692016601562
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018787384033203
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001671314239502
(380) DESCRIBE `itineraries` 0.00073599815368652
(381) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71451') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061893463134766
(382) DESCRIBE `ports` 0.0014231204986572
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030994415283203
(384) DESCRIBE `ports` 0.00098299980163574
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00023198127746582
(386) DESCRIBE `ports` 0.0010650157928467
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00029277801513672
(388) DESCRIBE `sailingdates` 0.00088119506835938
(389) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71451') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068116188049316
(390) DESCRIBE `ports` 0.00077199935913086
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00023818016052246
(392) DESCRIBE `ports` 0.00068902969360352
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018811225891113
(394) DESCRIBE `ports` 0.0006721019744873
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020885467529297
(396) DESCRIBE `ports` 0.00068211555480957
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018310546875
(398) DESCRIBE `ports` 0.000701904296875
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020718574523926
(400) DESCRIBE `ports` 0.00072598457336426
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018787384033203
(402) DESCRIBE `ports` 0.00074386596679688
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020503997802734
(404) DESCRIBE `ports` 0.00067901611328125
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018715858459473
(406) DESCRIBE `ports` 0.00093293190002441
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00024580955505371
(408) DESCRIBE `ports` 0.00072097778320312
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00020289421081543
(410) DESCRIBE `ports` 0.0006859302520752
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00024700164794922
(412) DESCRIBE `ports` 0.00067305564880371
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00023484230041504
(414) DESCRIBE `ports` 0.000946044921875
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00027990341186523
(416) DESCRIBE `ports` 0.00099992752075195
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00025796890258789
(418) DESCRIBE `avid_specials` 0.00098800659179688
(419) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71451 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0012500286102295
(420) DESCRIBE `cruiselines` 0.0010621547698975
(421) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024199485778809
(422) DESCRIBE `orchid_image` 0.00076198577880859
(423) DESCRIBE `cruiselines` 0.00092577934265137
(424) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020194053649902
(425) DESCRIBE `cruises` 0.0016589164733887
(426) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64924') 0.00026702880859375
(427) DESCRIBE `ships` 0.0015192031860352
(428) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00033998489379883
(429) DESCRIBE `ships` 0.0020129680633545
(430) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00028181076049805
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(433) DESCRIBE `itineraries` 0.00077700614929199
(434) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64924') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060081481933594
(435) DESCRIBE `ports` 0.00084900856018066
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00024890899658203
(437) DESCRIBE `ports` 0.00086712837219238
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00024700164794922
(439) DESCRIBE `ports` 0.00072097778320312
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00020313262939453
(441) DESCRIBE `sailingdates` 0.00087618827819824
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64924') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059318542480469
(443) DESCRIBE `ports` 0.0011141300201416
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00030517578125
(445) DESCRIBE `ports` 0.00070595741271973
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00022101402282715
(447) DESCRIBE `ports` 0.00072288513183594
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3646))) 0.00020885467529297
(449) DESCRIBE `ports` 0.0006871223449707
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3646') 0.00018596649169922
(451) DESCRIBE `ports` 0.00067687034606934
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00023913383483887
(453) DESCRIBE `ports` 0.00067996978759766
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00018596649169922
(455) DESCRIBE `ports` 0.00067806243896484
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00020599365234375
(457) DESCRIBE `ports` 0.00070095062255859
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00018811225891113
(459) DESCRIBE `avid_specials` 0.00061202049255371
(460) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64924 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.00098395347595215
(461) DESCRIBE `cruiselines` 0.0010190010070801
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022602081298828
(463) DESCRIBE `orchid_image` 0.00094389915466309
(464) DESCRIBE `cruiselines` 0.0010178089141846
(465) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020503997802734
(466) DESCRIBE `cruises` 0.0012590885162354
(467) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67958') 0.00028109550476074
(468) DESCRIBE `ships` 0.0012590885162354
(469) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00026321411132812
(470) DESCRIBE `ships` 0.0012979507446289
(471) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00018596649169922
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018191337585449
(473) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017380714416504
(474) DESCRIBE `itineraries` 0.00067996978759766
(475) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67958') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064802169799805
(476) DESCRIBE `ports` 0.00070095062255859
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00024604797363281
(478) DESCRIBE `ports` 0.00069403648376465
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020003318786621
(480) DESCRIBE `ports` 0.00067496299743652
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018000602722168
(482) DESCRIBE `sailingdates` 0.0006101131439209
(483) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67958') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005800724029541
(484) DESCRIBE `ports` 0.00074410438537598
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00021100044250488
(486) DESCRIBE `ports` 0.00068092346191406
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018310546875
(488) DESCRIBE `ports` 0.00066995620727539
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00023508071899414
(490) DESCRIBE `ports` 0.00063681602478027
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00019407272338867
(492) DESCRIBE `ports` 0.0007319450378418
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020813941955566
(494) DESCRIBE `ports` 0.00068402290344238
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00019502639770508
(496) DESCRIBE `ports` 0.00069499015808105
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00020599365234375
(498) DESCRIBE `ports` 0.00067305564880371
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00018477439880371
(500) DESCRIBE `ports` 0.00068187713623047
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00021219253540039
(502) DESCRIBE `ports` 0.00072288513183594
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018906593322754
(504) DESCRIBE `ports` 0.0006711483001709
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020408630371094
(506) DESCRIBE `ports` 0.00069499015808105
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018501281738281
(508) DESCRIBE `ports` 0.00071001052856445
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020718574523926
(510) DESCRIBE `ports` 0.00067996978759766
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00020098686218262
(512) DESCRIBE `ports` 0.00066995620727539
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019717216491699
(514) DESCRIBE `ports` 0.0007319450378418
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018191337585449
(516) DESCRIBE `ports` 0.00070595741271973
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00021505355834961
(518) DESCRIBE `ports` 0.00073695182800293
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00025796890258789
(520) DESCRIBE `ports` 0.0010862350463867
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00032687187194824
(522) DESCRIBE `ports` 0.0010318756103516
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00020194053649902
(524) DESCRIBE `ports` 0.00069594383239746
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00020694732666016
(526) DESCRIBE `ports` 0.00069189071655273
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018811225891113
(528) DESCRIBE `ports` 0.00097990036010742
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032687187194824
(530) DESCRIBE `ports` 0.00080013275146484
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019693374633789
(532) DESCRIBE `ports` 0.00098991394042969
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00026607513427734
(534) DESCRIBE `ports` 0.00099086761474609
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00024700164794922
(536) DESCRIBE `avid_specials` 0.00084185600280762
(537) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67958 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.00097107887268066
(538) DESCRIBE `cruiselines` 0.00099992752075195
(539) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00029993057250977
(540) DESCRIBE `orchid_image` 0.00082111358642578
(541) DESCRIBE `cruiselines` 0.00094890594482422
(542) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021505355834961
(543) DESCRIBE `cruises` 0.0020229816436768
(544) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70352') 0.00028705596923828
(545) DESCRIBE `ships` 0.0013749599456787
(546) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00030994415283203
(547) DESCRIBE `ships` 0.0015389919281006
(548) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00033378601074219
(549) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023818016052246
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023508071899414
(551) DESCRIBE `itineraries` 0.00091385841369629
(552) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70352') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089120864868164
(553) DESCRIBE `ports` 0.0012640953063965
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00036096572875977
(555) DESCRIBE `ports` 0.0011320114135742
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00028395652770996
(557) DESCRIBE `ports` 0.0010209083557129
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00027298927307129
(559) DESCRIBE `sailingdates` 0.00090312957763672
(560) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70352') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00080108642578125
(561) DESCRIBE `ports` 0.0010979175567627
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00027680397033691
(563) DESCRIBE `ports` 0.00072312355041504
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00020098686218262
(565) DESCRIBE `ports` 0.00070595741271973
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.0002131462097168
(567) DESCRIBE `ports` 0.0006861686706543
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00019001960754395
(569) DESCRIBE `ports` 0.00069785118103027
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1761))) 0.00024509429931641
(571) DESCRIBE `ports` 0.00067591667175293
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1761') 0.00019097328186035
(573) DESCRIBE `ports` 0.00069093704223633
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00023603439331055
(575) DESCRIBE `ports` 0.00071310997009277
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00018787384033203
(577) DESCRIBE `ports` 0.00067400932312012
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2870))) 0.00020718574523926
(579) DESCRIBE `ports` 0.00069403648376465
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2870') 0.00018501281738281
(581) DESCRIBE `ports` 0.00067496299743652
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00023984909057617
(583) DESCRIBE `ports` 0.00070619583129883
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00018882751464844
(585) DESCRIBE `ports` 0.00067996978759766
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00021600723266602
(587) DESCRIBE `ports` 0.00067687034606934
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018692016601562
(589) DESCRIBE `avid_specials` 0.0006260871887207
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70352 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 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.0009770393371582
(591) DESCRIBE `cruiselines` 0.00096511840820312
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022411346435547
(593) DESCRIBE `orchid_image` 0.00075817108154297
(594) DESCRIBE `cruiselines` 0.00093293190002441
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00025200843811035
(596) DESCRIBE `ships` 0.0025069713592529
(597) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1359', '407', '1599', '1067', '726', '452', '766', '462', '1588', '1415', '553', '610', '352', '674', '738')) ORDER BY FIND_IN_SET(id, '977,1359,407,1599,1067,726,452,766,462,1588,1415,553,610,352,674,738') 0.00099420547485352
(598) DESCRIBE `cruisetypes` 0.00090384483337402
(599) 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 = '19') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.025846004486084
(600) DESCRIBE `destinations` 0.001162052154541
(601) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '28', '25', '52', '26', '45', '38', '40', '35', '21', '37', '49', '48')) ORDER BY FIND_IN_SET(id, '22,12,28,25,52,26,45,38,40,35,21,37,49,48') 0.0009610652923584
(602) DESCRIBE `cruiselines` 0.0010700225830078
(603) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002439022064209
(604) DESCRIBE `cruiselines` 0.00097107887268066
(605) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022506713867188