or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 0.99287700653076

# Query Time
(1) connect 0.001399040222168
(2) DESCRIBE `cruises` 0.0044398307800293
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73726, 71184, 44087, 66355, 77472, 77740, 71185, 77478, 77742, 73262)) ORDER BY FIND_IN_SET(id, '73726,71184,44087,66355,77472,77740,71185,77478,77742,73262') 0.0028882026672363
(4) DESCRIBE `cruises` 0.0043737888336182
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73726') 0.0005791187286377
(6) DESCRIBE `ships` 0.0042150020599365
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00066590309143066
(8) DESCRIBE `ships` 0.0040550231933594
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00054502487182617
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030016899108887
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028800964355469
(12) DESCRIBE `itineraries` 0.0019979476928711
(13) DESCRIBE `ports` 0.0021851062774658
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00048208236694336
(15) DESCRIBE `ports` 0.0016582012176514
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00042295455932617
(17) DESCRIBE `ports` 0.0019931793212891
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00044703483581543
(19) DESCRIBE `sailingdates` 0.0017290115356445
(20) DESCRIBE `ports` 0.0023760795593262
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00052213668823242
(22) DESCRIBE `ports` 0.0020291805267334
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00039005279541016
(24) DESCRIBE `ports` 0.0018918514251709
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00052499771118164
(26) DESCRIBE `ports` 0.0020627975463867
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00046706199645996
(28) DESCRIBE `ports` 0.0020210742950439
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00057816505432129
(30) DESCRIBE `ports` 0.0022130012512207
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00056314468383789
(32) DESCRIBE `ports` 0.0017621517181396
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00046205520629883
(34) DESCRIBE `ports` 0.0018839836120605
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00048208236694336
(36) DESCRIBE `ports` 0.0019190311431885
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00049209594726562
(38) DESCRIBE `ports` 0.0019471645355225
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00045680999755859
(40) DESCRIBE `ports` 0.0021829605102539
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00077486038208008
(42) DESCRIBE `ports` 0.0026540756225586
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.0005340576171875
(44) DESCRIBE `ports` 0.0025928020477295
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00062918663024902
(46) DESCRIBE `ports` 0.0018310546875
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00041103363037109
(48) DESCRIBE `ports` 0.0017280578613281
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00042891502380371
(50) DESCRIBE `ports` 0.0017960071563721
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.0003969669342041
(52) DESCRIBE `ports` 0.0017368793487549
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00041985511779785
(54) DESCRIBE `ports` 0.0017740726470947
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00041794776916504
(56) DESCRIBE `avid_specials` 0.0016219615936279
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73726 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 43 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.0017790794372559
(58) DESCRIBE `cruiselines` 0.0028479099273682
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00049304962158203
(60) DESCRIBE `orchid_image` 0.0024738311767578
(61) DESCRIBE `cruiselines` 0.0033400058746338
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00055313110351562
(63) DESCRIBE `cruises` 0.0045428276062012
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71184') 0.00070691108703613
(65) DESCRIBE `ships` 0.0052189826965332
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00070405006408691
(67) DESCRIBE `ships` 0.0040719509124756
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00055217742919922
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043296813964844
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(71) DESCRIBE `itineraries` 0.0020298957824707
(72) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71184') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0021228790283203
(73) DESCRIBE `ports` 0.0026900768280029
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00083303451538086
(75) DESCRIBE `ports` 0.002673864364624
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0010209083557129
(77) DESCRIBE `ports` 0.002051830291748
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00044107437133789
(79) DESCRIBE `sailingdates` 0.0017619132995605
(80) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71184') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011520385742188
(81) DESCRIBE `ports` 0.0021162033081055
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00049901008605957
(83) DESCRIBE `ports` 0.0020010471343994
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00046396255493164
(85) DESCRIBE `ports` 0.0019059181213379
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1104))) 0.0004580020904541
(87) DESCRIBE `ports` 0.0019869804382324
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1104') 0.00047397613525391
(89) DESCRIBE `ports` 0.0024478435516357
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00056791305541992
(91) DESCRIBE `ports` 0.0024588108062744
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00048112869262695
(93) DESCRIBE `ports` 0.0021629333496094
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1115))) 0.00063896179199219
(95) DESCRIBE `ports` 0.0024468898773193
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1115') 0.00068879127502441
(97) DESCRIBE `ports` 0.0020179748535156
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1115))) 0.00076198577880859
(99) DESCRIBE `ports` 0.0021100044250488
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1115') 0.00051093101501465
(101) DESCRIBE `ports` 0.00199294090271
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.0005490779876709
(103) DESCRIBE `ports` 0.0020267963409424
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00067400932312012
(105) DESCRIBE `ports` 0.0018990039825439
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.00065994262695312
(107) DESCRIBE `ports` 0.0020060539245605
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00049996376037598
(109) DESCRIBE `ports` 0.0022079944610596
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 506))) 0.00060391426086426
(111) DESCRIBE `ports` 0.0027251243591309
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '506') 0.00062894821166992
(113) DESCRIBE `ports` 0.0031380653381348
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00055217742919922
(115) DESCRIBE `ports` 0.0022461414337158
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00046181678771973
(117) DESCRIBE `ports` 0.0023038387298584
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00062084197998047
(119) DESCRIBE `ports` 0.0025959014892578
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00048494338989258
(121) DESCRIBE `ports` 0.0019989013671875
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1998))) 0.00050997734069824
(123) DESCRIBE `ports` 0.0020639896392822
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1998') 0.00049614906311035
(125) DESCRIBE `ports` 0.0020039081573486
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00049805641174316
(127) DESCRIBE `ports` 0.0020589828491211
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00047588348388672
(129) DESCRIBE `ports` 0.0019400119781494
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 743))) 0.0005040168762207
(131) DESCRIBE `ports` 0.0019941329956055
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '743') 0.0004429817199707
(133) DESCRIBE `ports` 0.0019280910491943
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2924))) 0.00049901008605957
(135) DESCRIBE `ports` 0.0019469261169434
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2924') 0.0004580020904541
(137) DESCRIBE `ports` 0.0019280910491943
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00050902366638184
(139) DESCRIBE `ports` 0.0019760131835938
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00050878524780273
(141) DESCRIBE `ports` 0.0020380020141602
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00057291984558105
(143) DESCRIBE `ports` 0.0021219253540039
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00053286552429199
(145) DESCRIBE `ports` 0.0021030902862549
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00053787231445312
(147) DESCRIBE `ports` 0.0020439624786377
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00047421455383301
(149) DESCRIBE `avid_specials` 0.0018439292907715
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71184 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.00201416015625
(151) DESCRIBE `cruiselines` 0.0029289722442627
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0006411075592041
(153) DESCRIBE `orchid_image` 0.0039119720458984
(154) DESCRIBE `cruiselines` 0.0028080940246582
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00063896179199219
(156) DESCRIBE `cruises` 0.0039489269256592
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44087') 0.00056004524230957
(158) DESCRIBE `ships` 0.0037338733673096
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00064992904663086
(160) DESCRIBE `ships` 0.0039870738983154
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00063109397888184
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003819465637207
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036311149597168
(164) DESCRIBE `itineraries` 0.0019409656524658
(165) DESCRIBE `ports` 0.00199294090271
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00050997734069824
(167) DESCRIBE `ports` 0.0018749237060547
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00047111511230469
(169) DESCRIBE `ports` 0.0017728805541992
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00040507316589355
(171) DESCRIBE `sailingdates` 0.001554012298584
(172) DESCRIBE `ports` 0.001945972442627
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00047802925109863
(174) DESCRIBE `ports` 0.0018439292907715
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00042080879211426
(176) DESCRIBE `ports` 0.002018928527832
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1104))) 0.00046205520629883
(178) DESCRIBE `ports` 0.0021100044250488
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1104') 0.00047802925109863
(180) DESCRIBE `ports` 0.0019700527191162
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00049805641174316
(182) DESCRIBE `ports` 0.0019619464874268
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00045180320739746
(184) DESCRIBE `ports` 0.0019772052764893
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1115))) 0.0005340576171875
(186) DESCRIBE `ports` 0.002140998840332
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1115') 0.0004880428314209
(188) DESCRIBE `ports` 0.0020508766174316
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1115))) 0.00053620338439941
(190) DESCRIBE `ports` 0.0025138854980469
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1115') 0.00045680999755859
(192) DESCRIBE `ports` 0.001863956451416
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.0004730224609375
(194) DESCRIBE `ports` 0.0019199848175049
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00046396255493164
(196) DESCRIBE `ports` 0.0022289752960205
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.0005500316619873
(198) DESCRIBE `ports` 0.0019559860229492
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00058412551879883
(200) DESCRIBE `ports` 0.0023789405822754
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 506))) 0.00052499771118164
(202) DESCRIBE `ports` 0.0021750926971436
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '506') 0.00044417381286621
(204) DESCRIBE `ports` 0.0019969940185547
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00052905082702637
(206) DESCRIBE `ports` 0.0019772052764893
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00050115585327148
(208) DESCRIBE `ports` 0.0024540424346924
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00053215026855469
(210) DESCRIBE `ports` 0.0020380020141602
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00044798851013184
(212) DESCRIBE `avid_specials` 0.0018320083618164
(213) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44087 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0021679401397705
(214) DESCRIBE `cruiselines` 0.003000020980835
(215) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00064802169799805
(216) DESCRIBE `orchid_image` 0.0023810863494873
(217) DESCRIBE `cruiselines` 0.0026419162750244
(218) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00076794624328613
(219) DESCRIBE `cruises` 0.0040559768676758
(220) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66355') 0.00060796737670898
(221) DESCRIBE `ships` 0.0038189888000488
(222) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00071597099304199
(223) DESCRIBE `ships` 0.0041370391845703
(224) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.00052309036254883
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054812431335449
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(227) DESCRIBE `itineraries` 0.0020098686218262
(228) DESCRIBE `ports` 0.0025990009307861
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.00063776969909668
(230) DESCRIBE `ports` 0.0020339488983154
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.0004570484161377
(232) DESCRIBE `ports` 0.001945972442627
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '467') 0.00047397613525391
(234) DESCRIBE `sailingdates` 0.0016970634460449
(235) DESCRIBE `ports` 0.0021960735321045
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.00051403045654297
(237) DESCRIBE `ports` 0.0020430088043213
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '467') 0.00043416023254395
(239) DESCRIBE `ports` 0.0021572113037109
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 617))) 0.00046300888061523
(241) DESCRIBE `ports` 0.0017309188842773
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '617') 0.00045585632324219
(243) DESCRIBE `ports` 0.0018129348754883
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4817))) 0.00043821334838867
(245) DESCRIBE `ports` 0.0018057823181152
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4817') 0.00045490264892578
(247) DESCRIBE `ports` 0.0017571449279785
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4929))) 0.00045490264892578
(249) DESCRIBE `ports` 0.0018501281738281
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4929') 0.00046181678771973
(251) DESCRIBE `ports` 0.0018730163574219
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2132))) 0.00045394897460938
(253) DESCRIBE `ports` 0.0018908977508545
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2132') 0.00040602684020996
(255) DESCRIBE `ports` 0.0018699169158936
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00045108795166016
(257) DESCRIBE `ports` 0.0014829635620117
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00035381317138672
(259) DESCRIBE `ports` 0.0015480518341064
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00033307075500488
(261) DESCRIBE `ports` 0.0014228820800781
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00035691261291504
(263) DESCRIBE `avid_specials` 0.0014851093292236
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66355 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.0016260147094727
(265) DESCRIBE `cruiselines` 0.002791166305542
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00061607360839844
(267) DESCRIBE `orchid_image` 0.0024168491363525
(268) DESCRIBE `cruiselines` 0.0026628971099854
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00054502487182617
(270) DESCRIBE `cruises` 0.0039570331573486
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77472') 0.00053882598876953
(272) DESCRIBE `ships` 0.0040950775146484
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00071501731872559
(274) DESCRIBE `ships` 0.003727912902832
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00048089027404785
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(278) DESCRIBE `itineraries` 0.0019059181213379
(279) DESCRIBE `ports` 0.002230167388916
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00059700012207031
(281) DESCRIBE `ports` 0.0021500587463379
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00054216384887695
(283) DESCRIBE `ports` 0.0018479824066162
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00040411949157715
(285) DESCRIBE `sailingdates` 0.0014638900756836
(286) DESCRIBE `ports` 0.0020179748535156
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00037789344787598
(288) DESCRIBE `ports` 0.001349925994873
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.0003199577331543
(290) DESCRIBE `ports` 0.001558780670166
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 621))) 0.00034308433532715
(292) DESCRIBE `ports` 0.0013389587402344
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '621') 0.00029182434082031
(294) DESCRIBE `ports` 0.0012879371643066
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00037908554077148
(296) DESCRIBE `ports` 0.001338005065918
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.0003209114074707
(298) DESCRIBE `ports` 0.0013530254364014
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2924))) 0.00030779838562012
(300) DESCRIBE `ports` 0.0013198852539062
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2924') 0.00036287307739258
(302) DESCRIBE `ports` 0.0016489028930664
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00035500526428223
(304) DESCRIBE `ports` 0.0013678073883057
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00029778480529785
(306) DESCRIBE `ports` 0.00130295753479
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00034713745117188
(308) DESCRIBE `ports` 0.0013689994812012
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00029182434082031
(310) DESCRIBE `ports` 0.0013859272003174
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 506))) 0.00030183792114258
(312) DESCRIBE `ports` 0.0013060569763184
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '506') 0.00027894973754883
(314) DESCRIBE `ports` 0.0015490055084229
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00040507316589355
(316) DESCRIBE `ports` 0.0016629695892334
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0004119873046875
(318) DESCRIBE `avid_specials` 0.0015788078308105
(319) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77472 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.0017588138580322
(320) DESCRIBE `cruiselines` 0.0025730133056641
(321) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00060391426086426
(322) DESCRIBE `orchid_image` 0.0025260448455811
(323) DESCRIBE `cruiselines` 0.0023989677429199
(324) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00041985511779785
(325) DESCRIBE `cruises` 0.0031189918518066
(326) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77740') 0.00055694580078125
(327) DESCRIBE `ships` 0.0039501190185547
(328) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00066804885864258
(329) DESCRIBE `ships` 0.0034160614013672
(330) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.00045108795166016
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00033307075500488
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00033998489379883
(333) DESCRIBE `itineraries` 0.0015029907226562
(334) DESCRIBE `ports` 0.001417875289917
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00034189224243164
(336) DESCRIBE `ports` 0.0013020038604736
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00034809112548828
(338) DESCRIBE `ports` 0.0014419555664062
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.0003049373626709
(340) DESCRIBE `sailingdates` 0.0014219284057617
(341) DESCRIBE `ports` 0.0019409656524658
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00039410591125488
(343) DESCRIBE `ports` 0.0015380382537842
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00032591819763184
(345) DESCRIBE `ports` 0.0015051364898682
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00036001205444336
(347) DESCRIBE `ports` 0.0014340877532959
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0003821849822998
(349) DESCRIBE `ports` 0.0015449523925781
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1639))) 0.00041890144348145
(351) DESCRIBE `ports` 0.0019750595092773
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1639') 0.00038480758666992
(353) DESCRIBE `ports` 0.0016779899597168
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00042510032653809
(355) DESCRIBE `ports` 0.0024118423461914
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00043392181396484
(357) DESCRIBE `ports` 0.001924991607666
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00046396255493164
(359) DESCRIBE `ports` 0.0019340515136719
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00041818618774414
(361) DESCRIBE `ports` 0.0018739700317383
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00066590309143066
(363) DESCRIBE `ports` 0.001802921295166
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00036215782165527
(365) DESCRIBE `avid_specials` 0.0015490055084229
(366) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77740 and class = 'Cruise') OR (item_id = 1282 AND class = 'Ship') OR (item_id = 33 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.0020701885223389
(367) DESCRIBE `cruiselines` 0.0030360221862793
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00059700012207031
(369) DESCRIBE `orchid_image` 0.0025420188903809
(370) DESCRIBE `cruiselines` 0.0031239986419678
(371) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00053787231445312
(372) DESCRIBE `cruises` 0.0032889842987061
(373) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71185') 0.00045490264892578
(374) DESCRIBE `ships` 0.0032129287719727
(375) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00049281120300293
(376) DESCRIBE `ships` 0.0031559467315674
(377) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.0005500316619873
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033402442932129
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030708312988281
(380) DESCRIBE `itineraries` 0.0019690990447998
(381) DESCRIBE `ports` 0.0019829273223877
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0006108283996582
(383) DESCRIBE `ports` 0.0021369457244873
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00046610832214355
(385) DESCRIBE `ports` 0.0020370483398438
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00053691864013672
(387) DESCRIBE `sailingdates` 0.0017759799957275
(388) DESCRIBE `ports` 0.0021200180053711
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00048995018005371
(390) DESCRIBE `ports` 0.0019030570983887
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00040793418884277
(392) DESCRIBE `ports` 0.0018351078033447
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1998))) 0.00044512748718262
(394) DESCRIBE `ports` 0.0017540454864502
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1998') 0.00042510032653809
(396) DESCRIBE `ports` 0.0015799999237061
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00035190582275391
(398) DESCRIBE `ports` 0.0016460418701172
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00030994415283203
(400) DESCRIBE `ports` 0.0013179779052734
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 743))) 0.00029492378234863
(402) DESCRIBE `ports` 0.0012600421905518
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '743') 0.00030016899108887
(404) DESCRIBE `ports` 0.0015010833740234
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2924))) 0.00035810470581055
(406) DESCRIBE `ports` 0.0016028881072998
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2924') 0.00036311149597168
(408) DESCRIBE `ports` 0.0016839504241943
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00053191184997559
(410) DESCRIBE `ports` 0.0014910697937012
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00029206275939941
(412) DESCRIBE `ports` 0.0018348693847656
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00043702125549316
(414) DESCRIBE `ports` 0.0016210079193115
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00034785270690918
(416) DESCRIBE `ports` 0.0017530918121338
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00038909912109375
(418) DESCRIBE `ports` 0.0013458728790283
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00028395652770996
(420) DESCRIBE `ports` 0.001521110534668
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1104))) 0.00031900405883789
(422) DESCRIBE `ports` 0.0013470649719238
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1104') 0.00028204917907715
(424) DESCRIBE `ports` 0.0014641284942627
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00031590461730957
(426) DESCRIBE `ports` 0.0014379024505615
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00029706954956055
(428) DESCRIBE `ports` 0.0013768672943115
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1115))) 0.00037503242492676
(430) DESCRIBE `ports` 0.0016000270843506
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1115') 0.00030684471130371
(432) DESCRIBE `ports` 0.0016219615936279
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1115))) 0.00037407875061035
(434) DESCRIBE `ports` 0.0013840198516846
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1115') 0.00034499168395996
(436) DESCRIBE `ports` 0.0014801025390625
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.00037193298339844
(438) DESCRIBE `ports` 0.001439094543457
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00029897689819336
(440) DESCRIBE `ports` 0.0014669895172119
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.0004420280456543
(442) DESCRIBE `ports` 0.0014081001281738
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00030303001403809
(444) DESCRIBE `ports` 0.0014779567718506
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 506))) 0.00031304359436035
(446) DESCRIBE `ports` 0.0014050006866455
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '506') 0.00038003921508789
(448) DESCRIBE `ports` 0.0014548301696777
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00037002563476562
(450) DESCRIBE `ports` 0.001784086227417
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00032210350036621
(452) DESCRIBE `ports` 0.0014309883117676
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00042104721069336
(454) DESCRIBE `ports` 0.0019350051879883
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00042390823364258
(456) DESCRIBE `avid_specials` 0.0021770000457764
(457) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71185 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0020489692687988
(458) DESCRIBE `cruiselines` 0.0031940937042236
(459) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00063395500183105
(460) DESCRIBE `orchid_image` 0.0024311542510986
(461) DESCRIBE `cruiselines` 0.003126859664917
(462) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00055193901062012
(463) DESCRIBE `cruises` 0.0041661262512207
(464) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77478') 0.0006110668182373
(465) DESCRIBE `ships` 0.004788875579834
(466) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00076198577880859
(467) DESCRIBE `ships` 0.0042829513549805
(468) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00061392784118652
(469) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(471) DESCRIBE `itineraries` 0.0021340847015381
(472) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77478') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013699531555176
(473) DESCRIBE `ports` 0.0023589134216309
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00053191184997559
(475) DESCRIBE `ports` 0.0020339488983154
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00055098533630371
(477) DESCRIBE `ports` 0.0022001266479492
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00048017501831055
(479) DESCRIBE `sailingdates` 0.0017988681793213
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77478') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011920928955078
(481) DESCRIBE `ports` 0.0040969848632812
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0013718605041504
(483) DESCRIBE `ports` 0.0047969818115234
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0027389526367188
(485) DESCRIBE `ports` 0.0059409141540527
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5963))) 0.00062203407287598
(487) DESCRIBE `ports` 0.0028340816497803
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5963') 0.00049304962158203
(489) DESCRIBE `ports` 0.0021250247955322
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00068306922912598
(491) DESCRIBE `ports` 0.0028269290924072
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00054597854614258
(493) DESCRIBE `ports` 0.0024559497833252
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2850))) 0.001230001449585
(495) DESCRIBE `ports` 0.002100944519043
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2850') 0.0017759799957275
(497) DESCRIBE `ports` 0.0020599365234375
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00043702125549316
(499) DESCRIBE `ports` 0.001910924911499
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00040698051452637
(501) DESCRIBE `ports` 0.001845121383667
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 506))) 0.00039792060852051
(503) DESCRIBE `ports` 0.002094030380249
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '506') 0.00043606758117676
(505) DESCRIBE `ports` 0.0019760131835938
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 745))) 0.00047898292541504
(507) DESCRIBE `ports` 0.0020949840545654
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '745') 0.00045418739318848
(509) DESCRIBE `ports` 0.0018348693847656
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00042605400085449
(511) DESCRIBE `ports` 0.0019209384918213
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00040793418884277
(513) DESCRIBE `ports` 0.0023300647735596
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00057482719421387
(515) DESCRIBE `ports` 0.0021250247955322
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00042200088500977
(517) DESCRIBE `ports` 0.0019700527191162
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2924))) 0.00044894218444824
(519) DESCRIBE `ports` 0.002047061920166
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2924') 0.00044894218444824
(521) DESCRIBE `ports` 0.002000093460083
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 621))) 0.00046586990356445
(523) DESCRIBE `ports` 0.0020899772644043
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '621') 0.00042104721069336
(525) DESCRIBE `ports` 0.0018980503082275
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00045895576477051
(527) DESCRIBE `ports` 0.0019969940185547
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00046086311340332
(529) DESCRIBE `ports` 0.0021169185638428
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 743))) 0.0004730224609375
(531) DESCRIBE `ports` 0.0020930767059326
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '743') 0.00043606758117676
(533) DESCRIBE `ports` 0.001978874206543
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00048184394836426
(535) DESCRIBE `ports` 0.0019779205322266
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00051784515380859
(537) DESCRIBE `avid_specials` 0.0017430782318115
(538) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77478 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.0018429756164551
(539) DESCRIBE `cruiselines` 0.0028870105743408
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00059199333190918
(541) DESCRIBE `orchid_image` 0.0023109912872314
(542) DESCRIBE `cruiselines` 0.0028350353240967
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00052189826965332
(544) DESCRIBE `cruises` 0.0038571357727051
(545) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77742') 0.00065803527832031
(546) DESCRIBE `ships` 0.0040578842163086
(547) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00066113471984863
(548) DESCRIBE `ships` 0.0041399002075195
(549) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.00056695938110352
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035595893859863
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00033807754516602
(552) DESCRIBE `itineraries` 0.0019359588623047
(553) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77742') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010778903961182
(554) DESCRIBE `ports` 0.0022268295288086
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00051093101501465
(556) DESCRIBE `ports` 0.0020418167114258
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00054001808166504
(558) DESCRIBE `ports` 0.002155065536499
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00044107437133789
(560) DESCRIBE `sailingdates` 0.0017781257629395
(561) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77742') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00094985961914062
(562) DESCRIBE `ports` 0.0017681121826172
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00042605400085449
(564) DESCRIBE `ports` 0.0017199516296387
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00042104721069336
(566) DESCRIBE `ports` 0.0017590522766113
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00041794776916504
(568) DESCRIBE `ports` 0.0016489028930664
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00046610832214355
(570) DESCRIBE `ports` 0.0022139549255371
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00050997734069824
(572) DESCRIBE `ports` 0.0021049976348877
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00044083595275879
(574) DESCRIBE `ports` 0.0017328262329102
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00043892860412598
(576) DESCRIBE `ports` 0.0017900466918945
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00043702125549316
(578) DESCRIBE `ports` 0.0019309520721436
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2342))) 0.0004429817199707
(580) DESCRIBE `ports` 0.0019669532775879
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2342') 0.0004279613494873
(582) DESCRIBE `ports` 0.0020971298217773
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 500))) 0.00047993659973145
(584) DESCRIBE `ports` 0.002324104309082
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '500') 0.0004429817199707
(586) DESCRIBE `ports` 0.002173900604248
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0005190372467041
(588) DESCRIBE `ports` 0.0019330978393555
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00043892860412598
(590) DESCRIBE `ports` 0.0019800662994385
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 621))) 0.0005040168762207
(592) DESCRIBE `ports` 0.0019919872283936
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '621') 0.00041604042053223
(594) DESCRIBE `ports` 0.0018332004547119
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0004270076751709
(596) DESCRIBE `ports` 0.0016109943389893
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00037407875061035
(598) DESCRIBE `ports` 0.0017240047454834
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2924))) 0.00042605400085449
(600) DESCRIBE `ports` 0.0015921592712402
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2924') 0.00034809112548828
(602) DESCRIBE `ports` 0.0015590190887451
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00037312507629395
(604) DESCRIBE `ports` 0.0017330646514893
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00039100646972656
(606) DESCRIBE `ports` 0.0016770362854004
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.0004420280456543
(608) DESCRIBE `ports` 0.0017540454864502
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00040292739868164
(610) DESCRIBE `ports` 0.0016529560089111
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 506))) 0.00042009353637695
(612) DESCRIBE `ports` 0.0017549991607666
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '506') 0.00046181678771973
(614) DESCRIBE `ports` 0.0020051002502441
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00044989585876465
(616) DESCRIBE `ports` 0.0019209384918213
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00040698051452637
(618) DESCRIBE `avid_specials` 0.0018749237060547
(619) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77742 and class = 'Cruise') OR (item_id = 1282 AND class = 'Ship') OR (item_id = 33 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.0028970241546631
(620) DESCRIBE `cruiselines` 0.008357048034668
(621) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0006098747253418
(622) DESCRIBE `orchid_image` 0.0060009956359863
(623) DESCRIBE `cruiselines` 0.0030138492584229
(624) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00048398971557617
(625) DESCRIBE `cruises` 0.0039968490600586
(626) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73262') 0.00053811073303223
(627) DESCRIBE `ships` 0.0043480396270752
(628) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00060415267944336
(629) DESCRIBE `ships` 0.0042471885681152
(630) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.0005640983581543
(631) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032496452331543
(632) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(633) DESCRIBE `itineraries` 0.002108097076416
(634) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73262') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010559558868408
(635) DESCRIBE `ports` 0.0024077892303467
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00054287910461426
(637) DESCRIBE `ports` 0.0019791126251221
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00039887428283691
(639) DESCRIBE `ports` 0.0018930435180664
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00060510635375977
(641) DESCRIBE `sailingdates` 0.0017988681793213
(642) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73262') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011131763458252
(643) DESCRIBE `ports` 0.0021708011627197
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00049781799316406
(645) DESCRIBE `ports` 0.0020980834960938
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00048995018005371
(647) DESCRIBE `ports` 0.0022611618041992
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2132))) 0.00065302848815918
(649) DESCRIBE `ports` 0.0022528171539307
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2132') 0.00043296813964844
(651) DESCRIBE `ports` 0.0018339157104492
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2132))) 0.0004270076751709
(653) DESCRIBE `ports` 0.0018529891967773
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2132') 0.00082993507385254
(655) DESCRIBE `ports` 0.0021231174468994
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 625))) 0.00072503089904785
(657) DESCRIBE `ports` 0.0022978782653809
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '625') 0.0010180473327637
(659) DESCRIBE `ports` 0.0023958683013916
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4929))) 0.0006108283996582
(661) DESCRIBE `ports` 0.001939058303833
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4929') 0.00043082237243652
(663) DESCRIBE `ports` 0.0017170906066895
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3040))) 0.00044393539428711
(665) DESCRIBE `ports` 0.001727819442749
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3040') 0.00040197372436523
(667) DESCRIBE `ports` 0.0018320083618164
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2828))) 0.00063395500183105
(669) DESCRIBE `ports` 0.0021708011627197
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2828') 0.00046300888061523
(671) DESCRIBE `ports` 0.002234935760498
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 617))) 0.00051212310791016
(673) DESCRIBE `ports` 0.0020551681518555
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '617') 0.00045108795166016
(675) DESCRIBE `ports` 0.0019989013671875
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5602))) 0.00053119659423828
(677) DESCRIBE `ports` 0.0019898414611816
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5602') 0.00044083595275879
(679) DESCRIBE `ports` 0.001945972442627
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.00046205520629883
(681) DESCRIBE `ports` 0.0023610591888428
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '467') 0.00066781044006348
(683) DESCRIBE `avid_specials` 0.0031008720397949
(684) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73262 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.002161979675293
(685) DESCRIBE `cruiselines` 0.0028550624847412
(686) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00081515312194824
(687) DESCRIBE `orchid_image` 0.011677980422974
(688) DESCRIBE `cruiselines` 0.0036580562591553
(689) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00052499771118164
(690) DESCRIBE `ships` 0.004310131072998
(691) SELECT `ships`.* FROM `ships` WHERE (id IN ('160', '162', '1159', '163', '1266', '1282')) ORDER BY FIND_IN_SET(id, '160,162,1159,163,1266,1282') 0.0013799667358398
(692) DESCRIBE `cruisetypes` 0.0019800662994385
(693) DESCRIBE `destinations` 0.0025439262390137
(694) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '43', '48', '38', '49', '2', '28', '35', '26', '11', '21', '53', '25', '34', '8', '40')) ORDER BY FIND_IN_SET(id, '22,12,43,48,38,49,2,28,35,26,11,21,53,25,34,8,40') 0.0019159317016602
(695) DESCRIBE `cruiselines` 0.0031201839447021
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00065493583679199
(697) DESCRIBE `cruiselines` 0.0031731128692627
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00061988830566406