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

Total elapsed time: 0.94305539131165

# Query Time
(1) connect 0.0015408992767334
(2) DESCRIBE `cruises` 0.0049760341644287
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75749, 21382, 41693, 59158, 59342, 67386, 78908, 59178, 56615, 75150)) ORDER BY FIND_IN_SET(id, '75749,21382,41693,59158,59342,67386,78908,59178,56615,75150') 0.0029070377349854
(4) DESCRIBE `cruises` 0.0057811737060547
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75749') 0.00074601173400879
(6) DESCRIBE `ships` 0.0046188831329346
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1594))) 0.00052285194396973
(8) DESCRIBE `ships` 0.0046029090881348
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00068497657775879
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051784515380859
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055694580078125
(12) DESCRIBE `itineraries` 0.0029358863830566
(13) DESCRIBE `ports` 0.0029189586639404
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00068998336791992
(15) DESCRIBE `ports` 0.0031499862670898
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00066518783569336
(17) DESCRIBE `ports` 0.0029571056365967
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00059795379638672
(19) DESCRIBE `sailingdates` 0.0025029182434082
(20) DESCRIBE `ports` 0.0029699802398682
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0006260871887207
(22) DESCRIBE `ports` 0.0027592182159424
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00063014030456543
(24) DESCRIBE `ports` 0.0027799606323242
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00059890747070312
(26) DESCRIBE `ports` 0.0028510093688965
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00055789947509766
(28) DESCRIBE `ports` 0.0029220581054688
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00060200691223145
(30) DESCRIBE `ports` 0.0027980804443359
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00055789947509766
(32) DESCRIBE `ports` 0.0028030872344971
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0005800724029541
(34) DESCRIBE `ports` 0.0029008388519287
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00053691864013672
(36) DESCRIBE `ports` 0.0026619434356689
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00060796737670898
(38) DESCRIBE `ports` 0.0027689933776855
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00059294700622559
(40) DESCRIBE `ports` 0.0027370452880859
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00059199333190918
(42) DESCRIBE `ports` 0.0027718544006348
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00055789947509766
(44) DESCRIBE `ports` 0.0030097961425781
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00060606002807617
(46) DESCRIBE `ports` 0.0027379989624023
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00062084197998047
(48) DESCRIBE `ports` 0.0027050971984863
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00064992904663086
(50) DESCRIBE `ports` 0.0027971267700195
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0005950927734375
(52) DESCRIBE `ports` 0.002763032913208
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00056314468383789
(54) DESCRIBE `ports` 0.0027890205383301
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00054192543029785
(56) DESCRIBE `ports` 0.002985954284668
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00061988830566406
(58) DESCRIBE `ports` 0.0028238296508789
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00066208839416504
(60) DESCRIBE `ports` 0.0027399063110352
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00059390068054199
(62) DESCRIBE `ports` 0.0026929378509521
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00056290626525879
(64) DESCRIBE `ports` 0.0027289390563965
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00060105323791504
(66) DESCRIBE `ports` 0.0027561187744141
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00056695938110352
(68) DESCRIBE `ports` 0.0027318000793457
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00064587593078613
(70) DESCRIBE `ports` 0.0027530193328857
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00065779685974121
(72) DESCRIBE `ports` 0.0028300285339355
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00069808959960938
(74) DESCRIBE `ports` 0.0026760101318359
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00055885314941406
(76) DESCRIBE `avid_specials` 0.0026228427886963
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75749 and class = 'Cruise') OR (item_id = 1594 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023081302642822
(78) DESCRIBE `cruiselines` 0.0037689208984375
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00045394897460938
(80) DESCRIBE `orchid_image` 0.002061128616333
(81) DESCRIBE `cruiselines` 0.0025591850280762
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00038790702819824
(83) DESCRIBE `cruises` 0.0032999515533447
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '21382') 0.00043201446533203
(85) DESCRIBE `ships` 0.0036630630493164
(86) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.0005030632019043
(87) DESCRIBE `ships` 0.0036220550537109
(88) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00043010711669922
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033903121948242
(91) DESCRIBE `itineraries` 0.0018479824066162
(92) DESCRIBE `ports` 0.0022058486938477
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00046491622924805
(94) DESCRIBE `ports` 0.0019741058349609
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00043106079101562
(96) DESCRIBE `ports` 0.0019221305847168
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00041604042053223
(98) DESCRIBE `sailingdates` 0.0025119781494141
(99) DESCRIBE `ports` 0.0020430088043213
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00050115585327148
(101) DESCRIBE `ports` 0.0018391609191895
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00040578842163086
(103) DESCRIBE `ports` 0.0018432140350342
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00049185752868652
(105) DESCRIBE `ports` 0.0022590160369873
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00048303604125977
(107) DESCRIBE `ports` 0.0025348663330078
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1161))) 0.0004420280456543
(109) DESCRIBE `ports` 0.0019850730895996
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1161') 0.00040388107299805
(111) DESCRIBE `ports` 0.001863956451416
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00041913986206055
(113) DESCRIBE `ports` 0.0018360614776611
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00047683715820312
(115) DESCRIBE `ports` 0.0020320415496826
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00060796737670898
(117) DESCRIBE `ports` 0.0019741058349609
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00041007995605469
(119) DESCRIBE `ports` 0.00193190574646
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00043201446533203
(121) DESCRIBE `ports` 0.0019409656524658
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00039219856262207
(123) DESCRIBE `ports` 0.0019519329071045
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3052))) 0.00049901008605957
(125) DESCRIBE `ports` 0.001798152923584
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3052') 0.00040197372436523
(127) DESCRIBE `ports` 0.0019621849060059
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.0004420280456543
(129) DESCRIBE `ports` 0.002748966217041
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00041294097900391
(131) DESCRIBE `ports` 0.0018329620361328
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00053787231445312
(133) DESCRIBE `ports` 0.0019838809967041
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00041604042053223
(135) DESCRIBE `ports` 0.0018541812896729
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00044012069702148
(137) DESCRIBE `ports` 0.0022671222686768
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00055193901062012
(139) DESCRIBE `ports` 0.0026319026947021
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00062298774719238
(141) DESCRIBE `ports` 0.0028090476989746
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00043702125549316
(143) DESCRIBE `ports` 0.0025749206542969
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00062108039855957
(145) DESCRIBE `ports` 0.0027799606323242
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00063800811767578
(147) DESCRIBE `ports` 0.0027079582214355
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00062084197998047
(149) DESCRIBE `ports` 0.0031640529632568
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00078487396240234
(151) DESCRIBE `ports` 0.0076220035552979
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00066494941711426
(153) DESCRIBE `ports` 0.0025670528411865
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00058102607727051
(155) DESCRIBE `ports` 0.0024330615997314
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00056791305541992
(157) DESCRIBE `ports` 0.0023040771484375
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00049781799316406
(159) DESCRIBE `ports` 0.0020589828491211
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00050783157348633
(161) DESCRIBE `ports` 0.0019669532775879
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00057816505432129
(163) DESCRIBE `avid_specials` 0.0021200180053711
(164) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 21382 and class = 'Cruise') OR (item_id = 14 AND class = 'Ship') OR (item_id = 35 AND class = 'CruiseLine') OR (item_id = 46 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.0016980171203613
(165) DESCRIBE `cruiselines` 0.003432035446167
(166) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.00062799453735352
(167) DESCRIBE `orchid_image` 0.0020580291748047
(168) DESCRIBE `cruiselines` 0.0038728713989258
(169) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.0005490779876709
(170) DESCRIBE `cruises` 0.0045580863952637
(171) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41693') 0.0004429817199707
(172) DESCRIBE `ships` 0.0037930011749268
(173) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00057506561279297
(174) DESCRIBE `ships` 0.0035228729248047
(175) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00044608116149902
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035786628723145
(177) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00044918060302734
(178) DESCRIBE `itineraries` 0.0018270015716553
(179) DESCRIBE `ports` 0.0019760131835938
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045108795166016
(181) DESCRIBE `ports` 0.0018680095672607
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00058722496032715
(183) DESCRIBE `ports` 0.0018620491027832
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00048494338989258
(185) DESCRIBE `sailingdates` 0.0016138553619385
(186) DESCRIBE `ports` 0.0022869110107422
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00054311752319336
(188) DESCRIBE `ports` 0.0018250942230225
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00063109397888184
(190) DESCRIBE `ports` 0.0028059482574463
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00063085556030273
(192) DESCRIBE `ports` 0.0023610591888428
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.0003809928894043
(194) DESCRIBE `ports` 0.0017881393432617
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00046992301940918
(196) DESCRIBE `ports` 0.0018320083618164
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00038290023803711
(198) DESCRIBE `ports` 0.0018310546875
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00041604042053223
(200) DESCRIBE `ports` 0.0018389225006104
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00039005279541016
(202) DESCRIBE `ports` 0.0017809867858887
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044488906860352
(204) DESCRIBE `ports` 0.0020251274108887
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00042510032653809
(206) DESCRIBE `ports` 0.0019690990447998
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00052094459533691
(208) DESCRIBE `ports` 0.0018670558929443
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00054001808166504
(210) DESCRIBE `ports` 0.0019030570983887
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00039911270141602
(212) DESCRIBE `ports` 0.0018191337585449
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00043702125549316
(214) DESCRIBE `ports` 0.0019199848175049
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00046396255493164
(216) DESCRIBE `ports` 0.0019509792327881
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00039196014404297
(218) DESCRIBE `ports` 0.0021297931671143
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00045514106750488
(220) DESCRIBE `ports` 0.0018930435180664
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00040292739868164
(222) DESCRIBE `ports` 0.0019798278808594
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00057697296142578
(224) DESCRIBE `ports` 0.0023000240325928
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00060296058654785
(226) DESCRIBE `avid_specials` 0.0019509792327881
(227) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41693 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 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.0014681816101074
(228) DESCRIBE `cruiselines` 0.0026788711547852
(229) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00057291984558105
(230) DESCRIBE `orchid_image` 0.0024900436401367
(231) DESCRIBE `cruiselines` 0.0037021636962891
(232) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00077104568481445
(233) DESCRIBE `cruises` 0.0053231716156006
(234) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59158') 0.00054287910461426
(235) DESCRIBE `ships` 0.0046181678771973
(236) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 730))) 0.00054192543029785
(237) DESCRIBE `ships` 0.00372314453125
(238) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '730') 0.00044798851013184
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038504600524902
(241) DESCRIBE `itineraries` 0.0020899772644043
(242) DESCRIBE `sailingdates` 0.0016739368438721
(243) DESCRIBE `itineraries` 0.0018949508666992
(244) DESCRIBE `itineraries` 0.0018351078033447
(245) DESCRIBE `avid_specials` 0.0017540454864502
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59158 and class = 'Cruise') OR (item_id = 730 AND class = 'Ship') OR (item_id = 172 AND class = 'CruiseLine') OR (item_id = 44 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.0011858940124512
(247) DESCRIBE `cruiselines` 0.0026741027832031
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 172))) 0.00051522254943848
(249) DESCRIBE `orchid_image` 0.0024838447570801
(250) DESCRIBE `cruiselines` 0.0028679370880127
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '172') 0.00042104721069336
(252) DESCRIBE `cruises` 0.0053811073303223
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59342') 0.00049304962158203
(254) DESCRIBE `ships` 0.0044560432434082
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1417))) 0.00089812278747559
(256) DESCRIBE `ships` 0.0042598247528076
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1417') 0.00053000450134277
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043702125549316
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00053811073303223
(260) DESCRIBE `itineraries` 0.0021090507507324
(261) DESCRIBE `sailingdates` 0.0018241405487061
(262) DESCRIBE `itineraries` 0.0022430419921875
(263) DESCRIBE `itineraries` 0.0019857883453369
(264) DESCRIBE `avid_specials` 0.0017819404602051
(265) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59342 and class = 'Cruise') OR (item_id = 1417 AND class = 'Ship') OR (item_id = 170 AND class = 'CruiseLine') OR (item_id = 44 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.001201868057251
(266) DESCRIBE `cruiselines` 0.0028269290924072
(267) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 170))) 0.0004889965057373
(268) DESCRIBE `orchid_image` 0.0020060539245605
(269) DESCRIBE `cruiselines` 0.0027709007263184
(270) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '170') 0.00043797492980957
(271) DESCRIBE `cruises` 0.0039260387420654
(272) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67386') 0.00051093101501465
(273) DESCRIBE `ships` 0.0042300224304199
(274) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1408))) 0.00069785118103027
(275) DESCRIBE `ships` 0.0042178630828857
(276) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1408') 0.00043416023254395
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037097930908203
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039196014404297
(279) DESCRIBE `itineraries` 0.0017681121826172
(280) DESCRIBE `ports` 0.0023369789123535
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00043892860412598
(282) DESCRIBE `ports` 0.001945972442627
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00040411949157715
(284) DESCRIBE `ports` 0.0019960403442383
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00037693977355957
(286) DESCRIBE `sailingdates` 0.0017249584197998
(287) DESCRIBE `ports` 0.0025579929351807
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00054407119750977
(289) DESCRIBE `ports` 0.0026290416717529
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00048208236694336
(291) DESCRIBE `ports` 0.0019259452819824
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00041103363037109
(293) DESCRIBE `ports` 0.0025091171264648
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0005190372467041
(295) DESCRIBE `ports` 0.0019168853759766
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.0004580020904541
(297) DESCRIBE `ports` 0.0020689964294434
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.0003969669342041
(299) DESCRIBE `ports` 0.0020909309387207
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3643))) 0.00046300888061523
(301) DESCRIBE `ports` 0.0020499229431152
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3643') 0.00044894218444824
(303) DESCRIBE `ports` 0.00193190574646
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00050187110900879
(305) DESCRIBE `ports` 0.0019299983978271
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00049495697021484
(307) DESCRIBE `ports` 0.0020961761474609
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00054216384887695
(309) DESCRIBE `ports` 0.0020570755004883
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00041580200195312
(311) DESCRIBE `ports` 0.0019659996032715
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.0004429817199707
(313) DESCRIBE `ports` 0.0019340515136719
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00046920776367188
(315) DESCRIBE `ports` 0.001957893371582
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0004570484161377
(317) DESCRIBE `ports` 0.0018308162689209
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00053501129150391
(319) DESCRIBE `ports` 0.0020480155944824
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00052714347839355
(321) DESCRIBE `ports` 0.0021591186523438
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00038695335388184
(323) DESCRIBE `avid_specials` 0.001884937286377
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67386 and class = 'Cruise') OR (item_id = 1408 AND class = 'Ship') OR (item_id = 258 AND class = 'CruiseLine') OR (item_id = 50 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.0020809173583984
(325) DESCRIBE `cruiselines` 0.0032370090484619
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 258))) 0.00053501129150391
(327) DESCRIBE `orchid_image` 0.0023939609527588
(328) DESCRIBE `cruiselines` 0.0026688575744629
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '258') 0.0005180835723877
(330) DESCRIBE `cruises` 0.0041649341583252
(331) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78908') 0.00069308280944824
(332) DESCRIBE `ships` 0.0052437782287598
(333) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1289))) 0.00078105926513672
(334) DESCRIBE `ships` 0.0042390823364258
(335) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1289') 0.0006558895111084
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048995018005371
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046300888061523
(338) DESCRIBE `itineraries` 0.0023181438446045
(339) DESCRIBE `ports` 0.0029349327087402
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00056886672973633
(341) DESCRIBE `ports` 0.0018711090087891
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00042200088500977
(343) DESCRIBE `ports` 0.0023291110992432
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00041580200195312
(345) DESCRIBE `sailingdates` 0.0016920566558838
(346) DESCRIBE `ports` 0.0021679401397705
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00043892860412598
(348) DESCRIBE `ports` 0.0023179054260254
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00045204162597656
(350) DESCRIBE `ports` 0.0019149780273438
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.0027761459350586
(352) DESCRIBE `ports` 0.003032922744751
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00058794021606445
(354) DESCRIBE `ports` 0.0043339729309082
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00057601928710938
(356) DESCRIBE `ports` 0.0022070407867432
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00039815902709961
(358) DESCRIBE `ports` 0.0020499229431152
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00041294097900391
(360) DESCRIBE `ports` 0.0019159317016602
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00050187110900879
(362) DESCRIBE `ports` 0.0018100738525391
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00049710273742676
(364) DESCRIBE `ports` 0.0022001266479492
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00043416023254395
(366) DESCRIBE `ports` 0.0019330978393555
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00042986869812012
(368) DESCRIBE `ports` 0.0020089149475098
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00041007995605469
(370) DESCRIBE `ports` 0.0021421909332275
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00070905685424805
(372) DESCRIBE `ports` 0.0025529861450195
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00052189826965332
(374) DESCRIBE `ports` 0.0022990703582764
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4828))) 0.00042200088500977
(376) DESCRIBE `ports` 0.0019209384918213
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4828') 0.00040912628173828
(378) DESCRIBE `ports` 0.0019710063934326
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00045013427734375
(380) DESCRIBE `ports` 0.0023980140686035
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00045394897460938
(382) DESCRIBE `ports` 0.0018758773803711
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00042581558227539
(384) DESCRIBE `ports` 0.0017778873443604
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00038790702819824
(386) DESCRIBE `avid_specials` 0.0017189979553223
(387) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78908 and class = 'Cruise') OR (item_id = 1289 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012731552124023
(388) DESCRIBE `cruiselines` 0.0028641223907471
(389) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00043702125549316
(390) DESCRIBE `orchid_image` 0.0023047924041748
(391) DESCRIBE `cruiselines` 0.0024969577789307
(392) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00046396255493164
(393) DESCRIBE `cruises` 0.003777027130127
(394) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59178') 0.00049805641174316
(395) DESCRIBE `ships` 0.0036849975585938
(396) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 480))) 0.00048708915710449
(397) DESCRIBE `ships` 0.0035421848297119
(398) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '480') 0.00039410591125488
(399) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003659725189209
(400) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034785270690918
(401) DESCRIBE `itineraries` 0.0020220279693604
(402) DESCRIBE `ports` 0.0018348693847656
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00048995018005371
(404) DESCRIBE `ports` 0.0019209384918213
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00047111511230469
(406) DESCRIBE `ports` 0.0018758773803711
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00037789344787598
(408) DESCRIBE `sailingdates` 0.0023179054260254
(409) DESCRIBE `ports` 0.0023748874664307
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00045609474182129
(411) DESCRIBE `ports` 0.0018630027770996
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00040698051452637
(413) DESCRIBE `ports` 0.001978874206543
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00042200088500977
(415) DESCRIBE `ports` 0.002032995223999
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00038909912109375
(417) DESCRIBE `ports` 0.0024280548095703
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00049090385437012
(419) DESCRIBE `ports` 0.0021369457244873
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0004570484161377
(421) DESCRIBE `ports` 0.0018610954284668
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00040197372436523
(423) DESCRIBE `ports` 0.0022728443145752
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00059008598327637
(425) DESCRIBE `ports` 0.0020918846130371
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00043296813964844
(427) DESCRIBE `ports` 0.0020861625671387
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00040197372436523
(429) DESCRIBE `ports` 0.0019237995147705
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00040507316589355
(431) DESCRIBE `ports` 0.0019121170043945
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00043582916259766
(433) DESCRIBE `ports` 0.0025529861450195
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00066685676574707
(435) DESCRIBE `ports` 0.0025920867919922
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.0004878044128418
(437) DESCRIBE `avid_specials` 0.0022501945495605
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59178 and class = 'Cruise') OR (item_id = 480 AND class = 'Ship') OR (item_id = 108 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019180774688721
(439) DESCRIBE `cruiselines` 0.0037071704864502
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 108))) 0.00065803527832031
(441) DESCRIBE `orchid_image` 0.0031578540802002
(442) DESCRIBE `cruiselines` 0.0039329528808594
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '108') 0.0005948543548584
(444) DESCRIBE `cruises` 0.0050108432769775
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56615') 0.00090718269348145
(446) DESCRIBE `ships` 0.0050990581512451
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 739))) 0.0008540153503418
(448) DESCRIBE `ships` 0.0050489902496338
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '739') 0.00063514709472656
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046586990356445
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045490264892578
(452) DESCRIBE `itineraries` 0.0025949478149414
(453) DESCRIBE `ports` 0.0026259422302246
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00059390068054199
(455) DESCRIBE `ports` 0.002856969833374
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00065088272094727
(457) DESCRIBE `ports` 0.0027258396148682
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0006248950958252
(459) DESCRIBE `sailingdates` 0.0026590824127197
(460) DESCRIBE `ports` 0.0030241012573242
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00060510635375977
(462) DESCRIBE `ports` 0.0025930404663086
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0005640983581543
(464) DESCRIBE `ports` 0.0025200843811035
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00055408477783203
(466) DESCRIBE `ports` 0.002439022064209
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00053811073303223
(468) DESCRIBE `ports` 0.0022790431976318
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2298))) 0.0004730224609375
(470) DESCRIBE `ports` 0.0019659996032715
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2298') 0.0004880428314209
(472) DESCRIBE `ports` 0.0018417835235596
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00044989585876465
(474) DESCRIBE `ports` 0.0018839836120605
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0005040168762207
(476) DESCRIBE `avid_specials` 0.0016200542449951
(477) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56615 and class = 'Cruise') OR (item_id = 739 AND class = 'Ship') OR (item_id = 218 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.0011529922485352
(478) DESCRIBE `cruiselines` 0.003183126449585
(479) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0005650520324707
(480) DESCRIBE `orchid_image` 0.0020308494567871
(481) DESCRIBE `cruiselines` 0.0025641918182373
(482) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00041389465332031
(483) DESCRIBE `cruises` 0.0034859180450439
(484) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75150') 0.00044703483581543
(485) DESCRIBE `ships` 0.0040550231933594
(486) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 11))) 0.00057196617126465
(487) DESCRIBE `ships` 0.003662109375
(488) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '11') 0.0004570484161377
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034594535827637
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003361701965332
(491) DESCRIBE `itineraries` 0.0018630027770996
(492) DESCRIBE `ports` 0.0019359588623047
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00044894218444824
(494) DESCRIBE `ports` 0.0019240379333496
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00041007995605469
(496) DESCRIBE `ports` 0.002295970916748
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00046300888061523
(498) DESCRIBE `sailingdates` 0.0022640228271484
(499) DESCRIBE `ports` 0.003277063369751
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00070381164550781
(501) DESCRIBE `ports` 0.0028331279754639
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00069499015808105
(503) DESCRIBE `ports` 0.0029280185699463
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0006861686706543
(505) DESCRIBE `ports` 0.0029439926147461
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.0005800724029541
(507) DESCRIBE `ports` 0.0028369426727295
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00064396858215332
(509) DESCRIBE `ports` 0.0025599002838135
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00038719177246094
(511) DESCRIBE `ports` 0.0028111934661865
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00064992904663086
(513) DESCRIBE `ports` 0.002871036529541
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040388107299805
(515) DESCRIBE `avid_specials` 0.0017120838165283
(516) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75150 and class = 'Cruise') OR (item_id = 11 AND class = 'Ship') OR (item_id = 218 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.0011200904846191
(517) DESCRIBE `cruiselines` 0.002640962600708
(518) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00051784515380859
(519) DESCRIBE `orchid_image` 0.0023059844970703
(520) DESCRIBE `cruiselines` 0.0027101039886475
(521) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00041508674621582
(522) DESCRIBE `cruiselines` 0.0029811859130859
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '170', '262', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '16', '208', '187', '36', '49', '47', '88', '216', '251', '151', '141', '212', '181', '4', '110', '118', '59', '30', '140', '73', '115', '147', '261', '264', '48', '213', '159', '108', '276', '209', '211', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '35', '105', '64', '134', '257', '172', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,170,262,114,24,28,14,156,191,50,258,195,37,153,16,208,187,36,49,47,88,216,251,151,141,212,181,4,110,118,59,30,140,73,115,147,261,264,48,213,159,108,276,209,211,113,90,57,82,184,95,38,180,52,244,35,105,64,134,257,172,245,177') 0.0071280002593994
(524) DESCRIBE `ships` 0.0043671131134033
(525) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '855', '1324', '1588', '1717', '207', '1794', '1291', '874', '871', '1594', '977', '1199', '1572', '454', '1766', '1359', '404', '1272', '770', '22', '330', '461', '1032', '974', '21', '393', '1237', '66', '716', '1424', '28', '797', '1292', '434', '738', '1682', '553', '1134', '332', '521', '1348', '265', '333', '711', '349', '766', '1768', '1415', '1260', '11', '857', '1419', '1423', '9', '585', '858', '1422', '1501', '1677', '10', '715', '792', '1418', '1420', '1421', '739', '163', '407', '439', '25', '34', '455', '31', '36', '378', '1678', '1132', '3', '24', '39', '657', '542', '674', '1205', '1460', '1008', '1141', '1721', '520', '837', '1067', '1607', '385', '1569', '1302', '1402', '1742', '1773', '386', '966', '1852', '113', '882', '1168', '35', '160', '1012', '1372', '850', '1233', '1454', '1574', '1822', '573', '626', '1135', '1455', '1505', '1811', '37', '98', '338', '768', '1319', '1602', '1676', '610', '30', '63', '285', '1021', '451', '1373', '352', '1284', '986', '1413', '38', '817', '1259', '1733', '547', '1282', '1411', '148', '1398', '1410', '108', '111', '314', '503', '1193', '1722', '1782', '43', '375', '406', '1088', '286', '1308', '1437', '748', '1108', '1711', '198', '340', '508', '526', '627', '1320', '1323', '1579', '116', '970', '1063', '1808', '1145', '1738', '124', '327', '485', '854', '883', '1325', '1586', '390', '582', '1571', '348', '590', '1149', '394', '1028', '1208', '1266', '119', '335', '1492', '1552', '1321', '1724', '480', '616', '944', '1068', '1412', '1575', '223', '791', '1587', '1672', '1810', '70', '82', '114', '652', '704', '1157', '75', '658', '1461', '1809', '4', '147', '545', '1027', '1801', '351', '441', '462', '678', '1289', '683', '1853', '69', '162', '325', '884', '988', '78', '201', '403', '405', '601', '722', '1245', '1318', '1330', '1408', '105', '401', '958', '1820', '291', '790', '1188', '1303', '149', '287', '341', '389', '818', '1073', '1139', '1486', '123', '262', '580', '651', '776', '1236', '81', '483', '1037', '1539', '1772', '1159', '1326', '1327', '1367', '1526', '1704', '1771', '423', '673', '1013', '1151', '1172', '1463', '1540', '266', '796', '1019', '1043', '1757', '290', '1040', '1554', '1555', '45', '574', '639', '968', '1474', '1573', '1730', '635', '1035', '1426', '1743', '84', '751', '775', '795', '1160', '1223', '1681', '1715', '852', '1217', '1338', '1344', '1740', '324', '717', '1029', '1283', '1716', '1758', '972', '1095', '1143', '1144', '1163', '1206', '1226', '1229', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '665', '709', '905', '1045', '1048', '1146', '1150', '151', '212', '417', '643', '1405', '1483', '1673', '1807', '1833', '644', '851', '885', '1136', '1137', '1152', '1262', '1293', '1448', '1449', '1746', '1042', '1230', '1231', '1351', '1647', '1787', '467', '769', '1026', '1051', '1109', '1749', '1791', '150', '453', '1025', '1090', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '208', '448', '663', '707', '954', '973', '1224', '1366', '1368', '1459', '1519', '1609', '1632', '1649', '1750', '1751', '1816', '559', '701', '740', '920', '996', '1044', '1049', '1050', '1052', '1148', '1196', '1274', '1329', '1354', '1360', '1361', '1362', '1601', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1055', '1071', '1072', '1294', '1322', '1339', '1580', '1714', '1788', '1823', '14', '886', '915', '916', '926', '930', '931', '1047', '1599', '1854', '205', '703', '784', '924', '1039', '1350', '1352', '1389', '1596', '1650', '93', '253', '299', '300', '422', '1004', '1020', '1036', '1054', '1225', '1451', '1664', '479', '888', '937', '965', '1626', '1674', '27', '487', '672', '999', '1256')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,855,1324,1588,1717,207,1794,1291,874,871,1594,977,1199,1572,454,1766,1359,404,1272,770,22,330,461,1032,974,21,393,1237,66,716,1424,28,797,1292,434,738,1682,553,1134,332,521,1348,265,333,711,349,766,1768,1415,1260,11,857,1419,1423,9,585,858,1422,1501,1677,10,715,792,1418,1420,1421,739,163,407,439,25,34,455,31,36,378,1678,1132,3,24,39,657,542,674,1205,1460,1008,1141,1721,520,837,1067,1607,385,1569,1302,1402,1742,1773,386,966,1852,113,882,1168,35,160,1012,1372,850,1233,1454,1574,1822,573,626,1135,1455,1505,1811,37,98,338,768,1319,1602,1676,610,30,63,285,1021,451,1373,352,1284,986,1413,38,817,1259,1733,547,1282,1411,148,1398,1410,108,111,314,503,1193,1722,1782,43,375,406,1088,286,1308,1437,748,1108,1711,198,340,508,526,627,1320,1323,1579,116,970,1063,1808,1145,1738,124,327,485,854,883,1325,1586,390,582,1571,348,590,1149,394,1028,1208,1266,119,335,1492,1552,1321,1724,480,616,944,1068,1412,1575,223,791,1587,1672,1810,70,82,114,652,704,1157,75,658,1461,1809,4,147,545,1027,1801,351,441,462,678,1289,683,1853,69,162,325,884,988,78,201,403,405,601,722,1245,1318,1330,1408,105,401,958,1820,291,790,1188,1303,149,287,341,389,818,1073,1139,1486,123,262,580,651,776,1236,81,483,1037,1539,1772,1159,1326,1327,1367,1526,1704,1771,423,673,1013,1151,1172,1463,1540,266,796,1019,1043,1757,290,1040,1554,1555,45,574,639,968,1474,1573,1730,635,1035,1426,1743,84,751,775,795,1160,1223,1681,1715,852,1217,1338,1344,1740,324,717,1029,1283,1716,1758,972,1095,1143,1144,1163,1206,1226,1229,1343,1358,1409,1452,1453,1604,1663,665,709,905,1045,1048,1146,1150,151,212,417,643,1405,1483,1673,1807,1833,644,851,885,1136,1137,1152,1262,1293,1448,1449,1746,1042,1230,1231,1351,1647,1787,467,769,1026,1051,1109,1749,1791,150,453,1025,1090,1140,1154,1340,1458,1723,1759,1806,208,448,663,707,954,973,1224,1366,1368,1459,1519,1609,1632,1649,1750,1751,1816,559,701,740,920,996,1044,1049,1050,1052,1148,1196,1274,1329,1354,1360,1361,1362,1601,1708,1713,1805,666,914,921,923,927,1055,1071,1072,1294,1322,1339,1580,1714,1788,1823,14,886,915,916,926,930,931,1047,1599,1854,205,703,784,924,1039,1350,1352,1389,1596,1650,93,253,299,300,422,1004,1020,1036,1054,1225,1451,1664,479,888,937,965,1626,1674,27,487,672,999,1256') 0.084947109222412
(526) DESCRIBE `cruisetypes` 0.0019710063934326
(527) DESCRIBE `destinations` 0.0024368762969971
(528) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '48', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,48,21,29,52,34,10,46,56,32') 0.0028641223907471