or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 1.2480523586273

# Query Time
(1) connect 0.0019309520721436
(2) DESCRIBE `cruises` 0.0041091442108154
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76406, 61411, 76353, 72818, 76352, 61419, 76401, 61420, 76215, 84402)) ORDER BY FIND_IN_SET(id, '76406,61411,76353,72818,76352,61419,76401,61420,76215,84402') 0.0023539066314697
(4) DESCRIBE `cruises` 0.0049550533294678
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76406') 0.00061202049255371
(6) DESCRIBE `ships` 0.0054531097412109
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00079798698425293
(8) DESCRIBE `ships` 0.0037341117858887
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00049686431884766
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041007995605469
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(12) DESCRIBE `itineraries` 0.0018610954284668
(13) DESCRIBE `ports` 0.0021650791168213
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046300888061523
(15) DESCRIBE `ports` 0.0023701190948486
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052905082702637
(17) DESCRIBE `ports` 0.0029010772705078
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00063300132751465
(19) DESCRIBE `sailingdates` 0.0022668838500977
(20) DESCRIBE `ports` 0.0025589466094971
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00056004524230957
(22) DESCRIBE `ports` 0.0017650127410889
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046110153198242
(24) DESCRIBE `ports` 0.0018789768218994
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00042009353637695
(26) DESCRIBE `ports` 0.0018129348754883
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00036716461181641
(28) DESCRIBE `ports` 0.0017619132995605
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00039196014404297
(30) DESCRIBE `ports` 0.0018210411071777
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00039505958557129
(32) DESCRIBE `ports` 0.0022668838500977
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.0004880428314209
(34) DESCRIBE `ports` 0.0018420219421387
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.0003509521484375
(36) DESCRIBE `ports` 0.002202033996582
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1637))) 0.0004119873046875
(38) DESCRIBE `ports` 0.0018148422241211
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1637') 0.00036907196044922
(40) DESCRIBE `ports` 0.0017910003662109
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00040602684020996
(42) DESCRIBE `ports` 0.001816987991333
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00040602684020996
(44) DESCRIBE `ports` 0.0018579959869385
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00042295455932617
(46) DESCRIBE `ports` 0.0018439292907715
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00038003921508789
(48) DESCRIBE `ports` 0.0017740726470947
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00043678283691406
(50) DESCRIBE `ports` 0.0017881393432617
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00037312507629395
(52) DESCRIBE `ports` 0.0018739700317383
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00039410591125488
(54) DESCRIBE `ports` 0.0017859935760498
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00039005279541016
(56) DESCRIBE `ports` 0.001878023147583
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00045514106750488
(58) DESCRIBE `ports` 0.0020980834960938
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00046992301940918
(60) DESCRIBE `ports` 0.0018761157989502
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0005958080291748
(62) DESCRIBE `ports` 0.0018908977508545
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00043201446533203
(64) DESCRIBE `ports` 0.0019590854644775
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00048518180847168
(66) DESCRIBE `ports` 0.0018548965454102
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0003821849822998
(68) DESCRIBE `ports` 0.0017631053924561
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00040102005004883
(70) DESCRIBE `ports` 0.0017638206481934
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.00038909912109375
(72) DESCRIBE `ports` 0.0019071102142334
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00042295455932617
(74) DESCRIBE `ports` 0.0019540786743164
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.0003809928894043
(76) DESCRIBE `ports` 0.0021598339080811
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00047779083251953
(78) DESCRIBE `ports` 0.001917839050293
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00037598609924316
(80) DESCRIBE `ports` 0.0020139217376709
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00041913986206055
(82) DESCRIBE `ports` 0.0017910003662109
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00047492980957031
(84) DESCRIBE `ports` 0.0021889209747314
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00040817260742188
(86) DESCRIBE `ports` 0.0017449855804443
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00046801567077637
(88) DESCRIBE `ports` 0.0018231868743896
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00050187110900879
(90) DESCRIBE `ports` 0.0018250942230225
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00040602684020996
(92) DESCRIBE `avid_specials` 0.001662015914917
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76406 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.0024518966674805
(94) DESCRIBE `cruiselines` 0.0026450157165527
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046682357788086
(96) DESCRIBE `orchid_image` 0.0023040771484375
(97) DESCRIBE `cruiselines` 0.0026569366455078
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00040602684020996
(99) DESCRIBE `cruises` 0.0039031505584717
(100) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61411') 0.00037097930908203
(101) DESCRIBE `ships` 0.0036981105804443
(102) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.0005500316619873
(103) DESCRIBE `ships` 0.0034310817718506
(104) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00047397613525391
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044107437133789
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042581558227539
(107) DESCRIBE `itineraries` 0.0019609928131104
(108) DESCRIBE `ports` 0.0023519992828369
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00058507919311523
(110) DESCRIBE `ports` 0.0020010471343994
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046992301940918
(112) DESCRIBE `ports` 0.0018181800842285
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00045919418334961
(114) DESCRIBE `sailingdates` 0.0015299320220947
(115) DESCRIBE `ports` 0.0019569396972656
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052285194396973
(117) DESCRIBE `ports` 0.0018408298492432
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038599967956543
(119) DESCRIBE `ports` 0.002612829208374
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00059318542480469
(121) DESCRIBE `ports` 0.0027408599853516
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00055098533630371
(123) DESCRIBE `ports` 0.0027601718902588
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00048303604125977
(125) DESCRIBE `ports` 0.0020661354064941
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00039100646972656
(127) DESCRIBE `ports` 0.0021090507507324
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00038003921508789
(129) DESCRIBE `ports` 0.0017790794372559
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00037384033203125
(131) DESCRIBE `ports` 0.0017468929290771
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1637))) 0.00044798851013184
(133) DESCRIBE `ports` 0.0025420188903809
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1637') 0.00038003921508789
(135) DESCRIBE `ports` 0.0018641948699951
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.0003960132598877
(137) DESCRIBE `ports` 0.0021359920501709
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00038981437683105
(139) DESCRIBE `ports` 0.0018978118896484
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.0005640983581543
(141) DESCRIBE `ports` 0.0021820068359375
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00044417381286621
(143) DESCRIBE `ports` 0.0025730133056641
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00041294097900391
(145) DESCRIBE `ports` 0.0021569728851318
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00048494338989258
(147) DESCRIBE `ports` 0.002424955368042
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00053501129150391
(149) DESCRIBE `ports` 0.0023279190063477
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00045394897460938
(151) DESCRIBE `ports` 0.0026350021362305
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00038814544677734
(153) DESCRIBE `ports` 0.0024430751800537
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00037407875061035
(155) DESCRIBE `ports` 0.0022130012512207
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00055980682373047
(157) DESCRIBE `ports` 0.0024571418762207
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039911270141602
(159) DESCRIBE `ports` 0.002640962600708
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00046610832214355
(161) DESCRIBE `ports` 0.0028390884399414
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00038909912109375
(163) DESCRIBE `avid_specials` 0.0016641616821289
(164) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61411 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.0012340545654297
(165) DESCRIBE `cruiselines` 0.0027379989624023
(166) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046896934509277
(167) DESCRIBE `orchid_image` 0.0025229454040527
(168) DESCRIBE `cruiselines` 0.002673864364624
(169) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0003809928894043
(170) DESCRIBE `cruises` 0.0054168701171875
(171) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76353') 0.00060200691223145
(172) DESCRIBE `ships` 0.0052530765533447
(173) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0007169246673584
(174) DESCRIBE `ships` 0.0051250457763672
(175) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00062108039855957
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046586990356445
(177) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049614906311035
(178) DESCRIBE `itineraries` 0.0028932094573975
(179) DESCRIBE `ports` 0.0026531219482422
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00056099891662598
(181) DESCRIBE `ports` 0.0029549598693848
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00054502487182617
(183) DESCRIBE `ports` 0.002730131149292
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039291381835938
(185) DESCRIBE `sailingdates` 0.001835823059082
(186) DESCRIBE `ports` 0.0018589496612549
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043201446533203
(188) DESCRIBE `ports` 0.0027029514312744
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042009353637695
(190) DESCRIBE `ports` 0.0021600723266602
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00055193901062012
(192) DESCRIBE `ports` 0.0032479763031006
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00062203407287598
(194) DESCRIBE `ports` 0.0034451484680176
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00059700012207031
(196) DESCRIBE `ports` 0.003040075302124
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00063896179199219
(198) DESCRIBE `ports` 0.0025589466094971
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00058197975158691
(200) DESCRIBE `ports` 0.0026328563690186
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00051116943359375
(202) DESCRIBE `ports` 0.0027251243591309
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.00060296058654785
(204) DESCRIBE `ports` 0.0029730796813965
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00055789947509766
(206) DESCRIBE `ports` 0.0024340152740479
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00050091743469238
(208) DESCRIBE `ports` 0.0021920204162598
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00055217742919922
(210) DESCRIBE `ports` 0.0026829242706299
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00058603286743164
(212) DESCRIBE `ports` 0.0026209354400635
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00060510635375977
(214) DESCRIBE `ports` 0.002547025680542
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00047516822814941
(216) DESCRIBE `ports` 0.0021710395812988
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0005190372467041
(218) DESCRIBE `ports` 0.0027649402618408
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00059199333190918
(220) DESCRIBE `ports` 0.0022280216217041
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00042009353637695
(222) DESCRIBE `ports` 0.0026900768280029
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00049209594726562
(224) DESCRIBE `ports` 0.0026750564575195
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00057601928710938
(226) DESCRIBE `ports` 0.0025300979614258
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1873))) 0.00045919418334961
(228) DESCRIBE `ports` 0.0025858879089355
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1873') 0.00043392181396484
(230) DESCRIBE `ports` 0.0022919178009033
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00043916702270508
(232) DESCRIBE `ports` 0.0019059181213379
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00038909912109375
(234) DESCRIBE `ports` 0.0025520324707031
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1743))) 0.0004270076751709
(236) DESCRIBE `ports` 0.0018081665039062
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1743') 0.00045514106750488
(238) DESCRIBE `ports` 0.002025842666626
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1780))) 0.00041413307189941
(240) DESCRIBE `ports` 0.0018351078033447
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1780') 0.00039386749267578
(242) DESCRIBE `ports` 0.0024340152740479
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00051283836364746
(244) DESCRIBE `ports` 0.0021729469299316
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00039982795715332
(246) DESCRIBE `ports` 0.0022668838500977
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00046610832214355
(248) DESCRIBE `ports` 0.0022671222686768
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00045990943908691
(250) DESCRIBE `ports` 0.0022938251495361
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00041294097900391
(252) DESCRIBE `ports` 0.0019011497497559
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00042891502380371
(254) DESCRIBE `ports` 0.0020580291748047
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00043582916259766
(256) DESCRIBE `ports` 0.0018110275268555
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00038599967956543
(258) DESCRIBE `avid_specials` 0.0018470287322998
(259) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76353 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 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.0020871162414551
(260) DESCRIBE `cruiselines` 0.0041751861572266
(261) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00051093101501465
(262) DESCRIBE `orchid_image` 0.0032539367675781
(263) DESCRIBE `cruiselines` 0.0038561820983887
(264) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00047707557678223
(265) DESCRIBE `cruises` 0.0040340423583984
(266) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72818') 0.00040388107299805
(267) DESCRIBE `ships` 0.0036180019378662
(268) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00057387351989746
(269) DESCRIBE `ships` 0.0045688152313232
(270) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00046300888061523
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050997734069824
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039005279541016
(273) DESCRIBE `itineraries` 0.0020718574523926
(274) DESCRIBE `ports` 0.0021321773529053
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041913986206055
(276) DESCRIBE `ports` 0.0023419857025146
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046014785766602
(278) DESCRIBE `ports` 0.0022192001342773
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004119873046875
(280) DESCRIBE `sailingdates` 0.0020589828491211
(281) DESCRIBE `ports` 0.0022728443145752
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046706199645996
(283) DESCRIBE `ports` 0.0020978450775146
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040507316589355
(285) DESCRIBE `ports` 0.0025231838226318
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00041985511779785
(287) DESCRIBE `ports` 0.0025768280029297
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00037503242492676
(289) DESCRIBE `ports` 0.0017898082733154
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0003960132598877
(291) DESCRIBE `ports` 0.0019428730010986
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00042080879211426
(293) DESCRIBE `ports` 0.0025880336761475
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00047087669372559
(295) DESCRIBE `ports` 0.001755952835083
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00038599967956543
(297) DESCRIBE `ports` 0.0018119812011719
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00039291381835938
(299) DESCRIBE `ports` 0.0026209354400635
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00038719177246094
(301) DESCRIBE `ports` 0.001823902130127
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00044894218444824
(303) DESCRIBE `ports` 0.0018181800842285
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.00038003921508789
(305) DESCRIBE `ports` 0.0020511150360107
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 311))) 0.00053811073303223
(307) DESCRIBE `ports` 0.0022640228271484
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '311') 0.0005190372467041
(309) DESCRIBE `ports` 0.0027899742126465
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00060081481933594
(311) DESCRIBE `ports` 0.0022051334381104
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00041604042053223
(313) DESCRIBE `ports` 0.0021779537200928
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00059294700622559
(315) DESCRIBE `ports` 0.0025618076324463
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00051593780517578
(317) DESCRIBE `ports` 0.0031099319458008
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00058102607727051
(319) DESCRIBE `ports` 0.0026009082794189
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00053095817565918
(321) DESCRIBE `ports` 0.0025539398193359
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 672))) 0.00057101249694824
(323) DESCRIBE `ports` 0.0026149749755859
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '672') 0.00052905082702637
(325) DESCRIBE `ports` 0.0026600360870361
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00056290626525879
(327) DESCRIBE `ports` 0.0026440620422363
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00058293342590332
(329) DESCRIBE `ports` 0.0025899410247803
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2286))) 0.00062298774719238
(331) DESCRIBE `ports` 0.0030150413513184
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2286') 0.00050783157348633
(333) DESCRIBE `ports` 0.0028641223907471
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0005040168762207
(335) DESCRIBE `ports` 0.0034689903259277
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00052118301391602
(337) DESCRIBE `ports` 0.0026838779449463
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00056099891662598
(339) DESCRIBE `ports` 0.0031299591064453
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00054407119750977
(341) DESCRIBE `ports` 0.0023331642150879
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00055694580078125
(343) DESCRIBE `ports` 0.0033519268035889
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00046706199645996
(345) DESCRIBE `ports` 0.0028300285339355
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4467))) 0.00056195259094238
(347) DESCRIBE `ports` 0.0037589073181152
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4467') 0.00057697296142578
(349) DESCRIBE `ports` 0.0032949447631836
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005958080291748
(351) DESCRIBE `ports` 0.003040075302124
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00066685676574707
(353) DESCRIBE `avid_specials` 0.0024359226226807
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72818 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 55 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013289451599121
(355) DESCRIBE `cruiselines` 0.0047709941864014
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00078296661376953
(357) DESCRIBE `orchid_image` 0.0033278465270996
(358) DESCRIBE `cruiselines` 0.0050411224365234
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0006718635559082
(360) DESCRIBE `cruises` 0.0045599937438965
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76352') 0.00059604644775391
(362) DESCRIBE `ships` 0.0051050186157227
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00051307678222656
(364) DESCRIBE `ships` 0.0036709308624268
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00048089027404785
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044894218444824
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051307678222656
(368) DESCRIBE `itineraries` 0.0021419525146484
(369) DESCRIBE `ports` 0.0031280517578125
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004580020904541
(371) DESCRIBE `ports` 0.0028190612792969
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00053095817565918
(373) DESCRIBE `ports` 0.0024950504302979
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037980079650879
(375) DESCRIBE `sailingdates` 0.0027468204498291
(376) DESCRIBE `ports` 0.0022239685058594
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00045490264892578
(378) DESCRIBE `ports` 0.0019440650939941
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040006637573242
(380) DESCRIBE `ports` 0.0022540092468262
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00050806999206543
(382) DESCRIBE `ports` 0.0019550323486328
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00046491622924805
(384) DESCRIBE `ports` 0.0019540786743164
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00040793418884277
(386) DESCRIBE `ports` 0.0019700527191162
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00043416023254395
(388) DESCRIBE `ports` 0.0024030208587646
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00043606758117676
(390) DESCRIBE `ports` 0.0027070045471191
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00039196014404297
(392) DESCRIBE `ports` 0.0026559829711914
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.00054693222045898
(394) DESCRIBE `ports` 0.0028529167175293
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00045299530029297
(396) DESCRIBE `ports` 0.00295090675354
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00066113471984863
(398) DESCRIBE `ports` 0.0029170513153076
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00066208839416504
(400) DESCRIBE `ports` 0.0020408630371094
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00047016143798828
(402) DESCRIBE `ports` 0.0020809173583984
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00040388107299805
(404) DESCRIBE `avid_specials` 0.0017669200897217
(405) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76352 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 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.0013160705566406
(406) DESCRIBE `cruiselines` 0.0026481151580811
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00045490264892578
(408) DESCRIBE `orchid_image` 0.0029330253601074
(409) DESCRIBE `cruiselines` 0.0030691623687744
(410) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00041103363037109
(411) DESCRIBE `cruises` 0.0041959285736084
(412) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61419') 0.00045108795166016
(413) DESCRIBE `ships` 0.003709077835083
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00066184997558594
(415) DESCRIBE `ships` 0.0047640800476074
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00046205520629883
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045299530029297
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048112869262695
(419) DESCRIBE `itineraries` 0.0025219917297363
(420) DESCRIBE `ports` 0.0031349658966064
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00063896179199219
(422) DESCRIBE `ports` 0.0023069381713867
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00065207481384277
(424) DESCRIBE `ports` 0.0021560192108154
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00051188468933105
(426) DESCRIBE `sailingdates` 0.002993106842041
(427) DESCRIBE `ports` 0.00288987159729
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00060701370239258
(429) DESCRIBE `ports` 0.0027470588684082
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046014785766602
(431) DESCRIBE `ports` 0.0025730133056641
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00045895576477051
(433) DESCRIBE `ports` 0.002108097076416
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00069499015808105
(435) DESCRIBE `ports` 0.0022039413452148
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00045180320739746
(437) DESCRIBE `ports` 0.0022249221801758
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00067901611328125
(439) DESCRIBE `ports` 0.0029318332672119
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00058293342590332
(441) DESCRIBE `ports` 0.0027480125427246
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00062799453735352
(443) DESCRIBE `ports` 0.0030391216278076
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00045394897460938
(445) DESCRIBE `ports` 0.0028378963470459
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00044894218444824
(447) DESCRIBE `ports` 0.002830982208252
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00049591064453125
(449) DESCRIBE `ports` 0.002763032913208
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00056791305541992
(451) DESCRIBE `ports` 0.0027899742126465
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00074601173400879
(453) DESCRIBE `ports` 0.0032258033752441
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00050902366638184
(455) DESCRIBE `ports` 0.0028700828552246
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00057291984558105
(457) DESCRIBE `ports` 0.003507137298584
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00052595138549805
(459) DESCRIBE `ports` 0.0023109912872314
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052309036254883
(461) DESCRIBE `ports` 0.0020420551300049
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049519538879395
(463) DESCRIBE `avid_specials` 0.001737117767334
(464) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61419 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0013418197631836
(465) DESCRIBE `cruiselines` 0.0031089782714844
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0004570484161377
(467) DESCRIBE `orchid_image` 0.0022211074829102
(468) DESCRIBE `cruiselines` 0.0043110847473145
(469) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00054502487182617
(470) DESCRIBE `cruises` 0.0062570571899414
(471) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76401') 0.00058102607727051
(472) DESCRIBE `ships` 0.0052840709686279
(473) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0005030632019043
(474) DESCRIBE `ships` 0.0064899921417236
(475) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00067687034606934
(476) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054407119750977
(477) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052905082702637
(478) DESCRIBE `itineraries` 0.0026929378509521
(479) DESCRIBE `ports` 0.002007007598877
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004730224609375
(481) DESCRIBE `ports` 0.0019519329071045
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049996376037598
(483) DESCRIBE `ports` 0.0026650428771973
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044393539428711
(485) DESCRIBE `sailingdates` 0.0022780895233154
(486) DESCRIBE `ports` 0.0024921894073486
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054001808166504
(488) DESCRIBE `ports` 0.0026299953460693
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00056910514831543
(490) DESCRIBE `ports` 0.0020670890808105
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00048089027404785
(492) DESCRIBE `ports` 0.0019779205322266
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00039505958557129
(494) DESCRIBE `ports` 0.0027918815612793
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00044584274291992
(496) DESCRIBE `ports` 0.0028281211853027
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00049209594726562
(498) DESCRIBE `ports` 0.0027110576629639
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00046205520629883
(500) DESCRIBE `ports` 0.0028319358825684
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00039410591125488
(502) DESCRIBE `ports` 0.0025639533996582
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00050592422485352
(504) DESCRIBE `ports` 0.0029280185699463
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0005640983581543
(506) DESCRIBE `ports` 0.0027480125427246
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00063085556030273
(508) DESCRIBE `ports` 0.002795934677124
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00042819976806641
(510) DESCRIBE `ports` 0.0032238960266113
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00049281120300293
(512) DESCRIBE `ports` 0.0023348331451416
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00042891502380371
(514) DESCRIBE `ports` 0.0021660327911377
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050997734069824
(516) DESCRIBE `ports` 0.0019810199737549
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046300888061523
(518) DESCRIBE `ports` 0.0022821426391602
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00059795379638672
(520) DESCRIBE `ports` 0.0021181106567383
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00060486793518066
(522) DESCRIBE `ports` 0.0024290084838867
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00053715705871582
(524) DESCRIBE `ports` 0.0025789737701416
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00053000450134277
(526) DESCRIBE `ports` 0.003154993057251
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00056910514831543
(528) DESCRIBE `ports` 0.0025680065155029
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00041985511779785
(530) DESCRIBE `ports` 0.0019509792327881
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00043106079101562
(532) DESCRIBE `ports` 0.0018160343170166
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00038814544677734
(534) DESCRIBE `ports` 0.001798152923584
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00053119659423828
(536) DESCRIBE `ports` 0.0020060539245605
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041294097900391
(538) DESCRIBE `avid_specials` 0.0020170211791992
(539) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76401 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0017569065093994
(540) DESCRIBE `cruiselines` 0.0026431083679199
(541) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00049090385437012
(542) DESCRIBE `orchid_image` 0.0027201175689697
(543) DESCRIBE `cruiselines` 0.0042459964752197
(544) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00049591064453125
(545) DESCRIBE `cruises` 0.0041091442108154
(546) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61420') 0.00046801567077637
(547) DESCRIBE `ships` 0.0045669078826904
(548) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00055313110351562
(549) DESCRIBE `ships` 0.0041038990020752
(550) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00050210952758789
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036501884460449
(552) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035810470581055
(553) DESCRIBE `itineraries` 0.002147912979126
(554) DESCRIBE `ports` 0.0019640922546387
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048112869262695
(556) DESCRIBE `ports` 0.0020339488983154
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049018859863281
(558) DESCRIBE `ports` 0.0021378993988037
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041413307189941
(560) DESCRIBE `sailingdates` 0.0018649101257324
(561) DESCRIBE `ports` 0.0028908252716064
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046396255493164
(563) DESCRIBE `ports` 0.0025889873504639
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00047397613525391
(565) DESCRIBE `ports` 0.0024380683898926
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.0004279613494873
(567) DESCRIBE `ports` 0.0020170211791992
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00044894218444824
(569) DESCRIBE `ports` 0.0027248859405518
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00054097175598145
(571) DESCRIBE `ports` 0.0024399757385254
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00052905082702637
(573) DESCRIBE `ports` 0.0025370121002197
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00051403045654297
(575) DESCRIBE `ports` 0.0021529197692871
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00041294097900391
(577) DESCRIBE `ports` 0.0026290416717529
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00045394897460938
(579) DESCRIBE `ports` 0.0026798248291016
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0003969669342041
(581) DESCRIBE `ports` 0.0026731491088867
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00043702125549316
(583) DESCRIBE `ports` 0.0026450157165527
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00046014785766602
(585) DESCRIBE `ports` 0.0020461082458496
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00043582916259766
(587) DESCRIBE `ports` 0.0019679069519043
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00039792060852051
(589) DESCRIBE `ports` 0.0019969940185547
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046682357788086
(591) DESCRIBE `ports` 0.0019629001617432
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00047898292541504
(593) DESCRIBE `avid_specials` 0.001802921295166
(594) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61420 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0014297962188721
(595) DESCRIBE `cruiselines` 0.0033199787139893
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00048708915710449
(597) DESCRIBE `orchid_image` 0.0030488967895508
(598) DESCRIBE `cruiselines` 0.0035979747772217
(599) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043010711669922
(600) DESCRIBE `cruises` 0.0042130947113037
(601) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76215') 0.00043106079101562
(602) DESCRIBE `ships` 0.0044589042663574
(603) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00056886672973633
(604) DESCRIBE `ships` 0.0044589042663574
(605) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.0004889965057373
(606) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037097930908203
(607) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047993659973145
(608) DESCRIBE `itineraries` 0.0027840137481689
(609) DESCRIBE `ports` 0.0029628276824951
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058317184448242
(611) DESCRIBE `ports` 0.0025241374969482
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060701370239258
(613) DESCRIBE `ports` 0.0029630661010742
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.000640869140625
(615) DESCRIBE `sailingdates` 0.0026791095733643
(616) DESCRIBE `ports` 0.002608060836792
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047802925109863
(618) DESCRIBE `ports` 0.0026919841766357
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044798851013184
(620) DESCRIBE `ports` 0.0022759437561035
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048208236694336
(622) DESCRIBE `ports` 0.0023179054260254
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00042986869812012
(624) DESCRIBE `ports` 0.0019049644470215
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 454))) 0.00040912628173828
(626) DESCRIBE `ports` 0.0024938583374023
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '454') 0.00044107437133789
(628) DESCRIBE `ports` 0.0029261112213135
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045609474182129
(630) DESCRIBE `ports` 0.0018649101257324
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00052499771118164
(632) DESCRIBE `ports` 0.0018680095672607
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0004270076751709
(634) DESCRIBE `ports` 0.0019290447235107
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00050115585327148
(636) DESCRIBE `ports` 0.0019171237945557
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 82))) 0.00043487548828125
(638) DESCRIBE `ports` 0.0018641948699951
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '82') 0.00046491622924805
(640) DESCRIBE `ports` 0.0025649070739746
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00067782402038574
(642) DESCRIBE `ports` 0.0018620491027832
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00045299530029297
(644) DESCRIBE `ports` 0.0024821758270264
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00049090385437012
(646) DESCRIBE `ports` 0.0021131038665771
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00046110153198242
(648) DESCRIBE `ports` 0.0028510093688965
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.0004270076751709
(650) DESCRIBE `ports` 0.0023989677429199
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00040698051452637
(652) DESCRIBE `ports` 0.0019900798797607
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00041294097900391
(654) DESCRIBE `ports` 0.0024130344390869
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00041913986206055
(656) DESCRIBE `ports` 0.002295970916748
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059))) 0.00042915344238281
(658) DESCRIBE `ports` 0.0025529861450195
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059') 0.00041508674621582
(660) DESCRIBE `ports` 0.0028271675109863
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480))) 0.00047612190246582
(662) DESCRIBE `ports` 0.0027151107788086
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480') 0.0004730224609375
(664) DESCRIBE `ports` 0.0033669471740723
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00048494338989258
(666) DESCRIBE `ports` 0.0022408962249756
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00041794776916504
(668) DESCRIBE `ports` 0.0024690628051758
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00057005882263184
(670) DESCRIBE `ports` 0.0027010440826416
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.00054121017456055
(672) DESCRIBE `ports` 0.0026259422302246
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00056600570678711
(674) DESCRIBE `ports` 0.0028040409088135
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00050497055053711
(676) DESCRIBE `ports` 0.003026008605957
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00060796737670898
(678) DESCRIBE `ports` 0.003026008605957
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00050711631774902
(680) DESCRIBE `ports` 0.0029611587524414
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00057506561279297
(682) DESCRIBE `ports` 0.0029618740081787
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00054502487182617
(684) DESCRIBE `ports` 0.0025348663330078
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00057291984558105
(686) DESCRIBE `ports` 0.0031991004943848
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00058698654174805
(688) DESCRIBE `ports` 0.002593994140625
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2472))) 0.0005791187286377
(690) DESCRIBE `ports` 0.0025160312652588
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2472') 0.00061297416687012
(692) DESCRIBE `ports` 0.0025820732116699
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00087094306945801
(694) DESCRIBE `ports` 0.013151884078979
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004880428314209
(696) DESCRIBE `avid_specials` 0.0018689632415771
(697) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76215 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 8 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.0012950897216797
(698) DESCRIBE `cruiselines` 0.0026168823242188
(699) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0052731037139893
(700) DESCRIBE `orchid_image` 0.0022988319396973
(701) DESCRIBE `cruiselines` 0.0034470558166504
(702) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00052309036254883
(703) DESCRIBE `cruises` 0.0035989284515381
(704) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84402') 0.00045990943908691
(705) DESCRIBE `ships` 0.0035490989685059
(706) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00047802925109863
(707) DESCRIBE `ships` 0.0035018920898438
(708) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00056004524230957
(709) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004420280456543
(710) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(711) DESCRIBE `itineraries` 0.0021100044250488
(712) DESCRIBE `ports` 0.0018520355224609
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047898292541504
(714) DESCRIBE `ports` 0.0020420551300049
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044512748718262
(716) DESCRIBE `ports` 0.0018091201782227
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038790702819824
(718) DESCRIBE `sailingdates` 0.0016429424285889
(719) DESCRIBE `ports` 0.0018789768218994
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042510032653809
(721) DESCRIBE `ports` 0.0018248558044434
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043606758117676
(723) DESCRIBE `ports` 0.0019500255584717
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041007995605469
(725) DESCRIBE `ports` 0.0020880699157715
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00054001808166504
(727) DESCRIBE `ports` 0.006227970123291
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 454))) 0.00050711631774902
(729) DESCRIBE `ports` 0.0020098686218262
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '454') 0.00037407875061035
(731) DESCRIBE `ports` 0.001957893371582
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044393539428711
(733) DESCRIBE `ports` 0.0020661354064941
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00039792060852051
(735) DESCRIBE `ports` 0.0033340454101562
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0014739036560059
(737) DESCRIBE `ports` 0.0021820068359375
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00041413307189941
(739) DESCRIBE `ports` 0.0018599033355713
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 82))) 0.00045418739318848
(741) DESCRIBE `ports` 0.0019268989562988
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '82') 0.00043201446533203
(743) DESCRIBE `ports` 0.001878023147583
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00046205520629883
(745) DESCRIBE `ports` 0.0022280216217041
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00042104721069336
(747) DESCRIBE `ports` 0.002471923828125
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00072789192199707
(749) DESCRIBE `ports` 0.0027589797973633
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00059795379638672
(751) DESCRIBE `ports` 0.0026469230651855
(752) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00064301490783691
(753) DESCRIBE `ports` 0.0026669502258301
(754) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00056791305541992
(755) DESCRIBE `ports` 0.0027298927307129
(756) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00060486793518066
(757) DESCRIBE `ports` 0.0027549266815186
(758) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00040221214294434
(759) DESCRIBE `avid_specials` 0.0046169757843018
(760) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84402 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 8 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.0013871192932129
(761) DESCRIBE `cruiselines` 0.0034201145172119
(762) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00052595138549805
(763) DESCRIBE `orchid_image` 0.002877950668335
(764) DESCRIBE `cruiselines` 0.0036940574645996
(765) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00054502487182617
(766) DESCRIBE `ships` 0.0052120685577393
(767) SELECT `ships`.* FROM `ships` WHERE (id IN ('966', '850', '1319', '1108', '508', '394')) ORDER BY FIND_IN_SET(id, '966,850,1319,1108,508,394') 0.0017850399017334
(768) DESCRIBE `cruisetypes` 0.0022749900817871
(769) DESCRIBE `destinations` 0.0033841133117676
(770) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '26', '37', '2', '38', '35', '43', '28', '21', '11', '48', '49', '8', '30', '45', '10', '52', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,26,37,2,38,35,43,28,21,11,48,49,8,30,45,10,52,25,34,32,55') 0.0034000873565674
(771) DESCRIBE `cruiselines` 0.0037069320678711
(772) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00068807601928711
(773) DESCRIBE `cruiselines` 0.0038080215454102
(774) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00069308280944824