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

Total elapsed time: 0.68292808532715

# Query Time
(1) connect 0.0010600090026855
(2) DESCRIBE `cruises` 0.0040929317474365
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57755, 75190, 56233, 78074, 75284, 62815, 77977, 61574, 80643, 80644)) ORDER BY FIND_IN_SET(id, '57755,75190,56233,78074,75284,62815,77977,61574,80643,80644') 0.0014259815216064
(4) DESCRIBE `cruises` 0.0034217834472656
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57755') 0.0003809928894043
(6) DESCRIBE `ships` 0.0034720897674561
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 818))) 0.0004420280456543
(8) DESCRIBE `ships` 0.0035638809204102
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00037717819213867
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035285949707031
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034403800964355
(12) DESCRIBE `itineraries` 0.0018138885498047
(13) DESCRIBE `ports` 0.0017731189727783
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00045490264892578
(15) DESCRIBE `ports` 0.0022242069244385
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00044894218444824
(17) DESCRIBE `ports` 0.0021028518676758
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0003819465637207
(19) DESCRIBE `sailingdates` 0.0017929077148438
(20) DESCRIBE `ports` 0.0020618438720703
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00040197372436523
(22) DESCRIBE `ports` 0.0019381046295166
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00041389465332031
(24) DESCRIBE `ports` 0.0019679069519043
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00039505958557129
(26) DESCRIBE `ports` 0.0017349720001221
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00037002563476562
(28) DESCRIBE `ports` 0.0018749237060547
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00039887428283691
(30) DESCRIBE `ports` 0.0017609596252441
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00040602684020996
(32) DESCRIBE `ports` 0.0017609596252441
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00039911270141602
(34) DESCRIBE `ports` 0.0018191337585449
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00037598609924316
(36) DESCRIBE `ports` 0.0018749237060547
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00055694580078125
(38) DESCRIBE `ports` 0.0017509460449219
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00037503242492676
(40) DESCRIBE `ports` 0.0017359256744385
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00041389465332031
(42) DESCRIBE `ports` 0.0017781257629395
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00036787986755371
(44) DESCRIBE `ports` 0.0020110607147217
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 648))) 0.00045299530029297
(46) DESCRIBE `ports` 0.0022389888763428
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '648') 0.00045323371887207
(48) DESCRIBE `ports` 0.0017499923706055
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00044679641723633
(50) DESCRIBE `ports` 0.0019440650939941
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00047898292541504
(52) DESCRIBE `ports` 0.0020451545715332
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00049901008605957
(54) DESCRIBE `ports` 0.0020129680633545
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00049400329589844
(56) DESCRIBE `avid_specials` 0.0020999908447266
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57755 and class = 'Cruise') OR (item_id = 818 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 25 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.001410961151123
(58) DESCRIBE `cruiselines` 0.0038750171661377
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00069403648376465
(60) DESCRIBE `orchid_image` 0.0026590824127197
(61) DESCRIBE `cruiselines` 0.0033161640167236
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00052285194396973
(63) DESCRIBE `cruises` 0.0045249462127686
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75190') 0.00055599212646484
(65) DESCRIBE `ships` 0.004317045211792
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1479))) 0.00067591667175293
(67) DESCRIBE `ships` 0.0039360523223877
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1479') 0.0005040168762207
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035595893859863
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034618377685547
(71) DESCRIBE `itineraries` 0.0018138885498047
(72) DESCRIBE `ports` 0.0018198490142822
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.0004119873046875
(74) DESCRIBE `ports` 0.001906156539917
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00047707557678223
(76) DESCRIBE `ports` 0.0017428398132324
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00037813186645508
(78) DESCRIBE `sailingdates` 0.0015819072723389
(79) DESCRIBE `ports` 0.0018210411071777
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00046396255493164
(81) DESCRIBE `ports` 0.0019989013671875
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00044107437133789
(83) DESCRIBE `ports` 0.0018808841705322
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00041294097900391
(85) DESCRIBE `ports` 0.0019938945770264
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00037097930908203
(87) DESCRIBE `ports` 0.0017399787902832
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00043606758117676
(89) DESCRIBE `ports` 0.0018990039825439
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00041007995605469
(91) DESCRIBE `ports` 0.0017509460449219
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00039291381835938
(93) DESCRIBE `ports` 0.0018000602722168
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00037217140197754
(95) DESCRIBE `ports` 0.0017540454864502
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00039505958557129
(97) DESCRIBE `ports` 0.0017399787902832
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00036883354187012
(99) DESCRIBE `ports` 0.0017781257629395
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00042581558227539
(101) DESCRIBE `ports` 0.0019769668579102
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00037908554077148
(103) DESCRIBE `avid_specials` 0.0016438961029053
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75190 and class = 'Cruise') OR (item_id = 1479 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 49 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.001255989074707
(105) DESCRIBE `cruiselines` 0.0025179386138916
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00041317939758301
(107) DESCRIBE `orchid_image` 0.0019421577453613
(108) DESCRIBE `cruiselines` 0.0025219917297363
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0003821849822998
(110) DESCRIBE `cruises` 0.0038321018218994
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56233') 0.00049495697021484
(112) DESCRIBE `ships` 0.0036649703979492
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.0005040168762207
(114) DESCRIBE `ships` 0.003615140914917
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00040507316589355
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035881996154785
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034904479980469
(118) DESCRIBE `itineraries` 0.0017409324645996
(119) DESCRIBE `ports` 0.0017509460449219
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00040221214294434
(121) DESCRIBE `ports` 0.0020620822906494
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.0004580020904541
(123) DESCRIBE `ports` 0.0017838478088379
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00037717819213867
(125) DESCRIBE `sailingdates` 0.0016419887542725
(126) DESCRIBE `ports` 0.0019938945770264
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00046205520629883
(128) DESCRIBE `ports` 0.0017340183258057
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00037312507629395
(130) DESCRIBE `ports` 0.0019199848175049
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00042390823364258
(132) DESCRIBE `ports` 0.0019381046295166
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00037908554077148
(134) DESCRIBE `ports` 0.0018041133880615
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00040006637573242
(136) DESCRIBE `ports` 0.0017950534820557
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00044608116149902
(138) DESCRIBE `ports` 0.0018057823181152
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00041317939758301
(140) DESCRIBE `ports` 0.0018050670623779
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00036907196044922
(142) DESCRIBE `ports` 0.0017199516296387
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00038695335388184
(144) DESCRIBE `ports` 0.0017249584197998
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00036811828613281
(146) DESCRIBE `ports` 0.0019321441650391
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00047397613525391
(148) DESCRIBE `ports` 0.0020198822021484
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00038003921508789
(150) DESCRIBE `ports` 0.0018329620361328
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00039005279541016
(152) DESCRIBE `ports` 0.0017578601837158
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00036907196044922
(154) DESCRIBE `avid_specials` 0.0016779899597168
(155) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56233 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0011179447174072
(156) DESCRIBE `cruiselines` 0.0025091171264648
(157) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00042319297790527
(158) DESCRIBE `orchid_image` 0.002108097076416
(159) DESCRIBE `cruiselines` 0.0026590824127197
(160) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0003960132598877
(161) DESCRIBE `cruises` 0.0033488273620605
(162) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78074') 0.00039386749267578
(163) DESCRIBE `ships` 0.0035419464111328
(164) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00048708915710449
(165) DESCRIBE `ships` 0.0035400390625
(166) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00039196014404297
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036096572875977
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034999847412109
(169) DESCRIBE `itineraries` 0.0019290447235107
(170) DESCRIBE `ports` 0.0018839836120605
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00046205520629883
(172) DESCRIBE `ports` 0.0019500255584717
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00052595138549805
(174) DESCRIBE `ports` 0.0017528533935547
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.0003809928894043
(176) DESCRIBE `sailingdates` 0.0016238689422607
(177) DESCRIBE `ports` 0.0017638206481934
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00047898292541504
(179) DESCRIBE `ports` 0.0020449161529541
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00055503845214844
(181) DESCRIBE `ports` 0.0019311904907227
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00040793418884277
(183) DESCRIBE `ports` 0.00193190574646
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00038003921508789
(185) DESCRIBE `ports` 0.0018341541290283
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00041699409484863
(187) DESCRIBE `ports` 0.0017521381378174
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0004119873046875
(189) DESCRIBE `ports` 0.0017459392547607
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00039792060852051
(191) DESCRIBE `ports` 0.0019600391387939
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00037503242492676
(193) DESCRIBE `ports` 0.0017430782318115
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00041818618774414
(195) DESCRIBE `ports` 0.0018889904022217
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00051093101501465
(197) DESCRIBE `ports` 0.0017910003662109
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00041580200195312
(199) DESCRIBE `ports` 0.0019419193267822
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00037813186645508
(201) DESCRIBE `avid_specials` 0.0015599727630615
(202) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78074 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0011658668518066
(203) DESCRIBE `cruiselines` 0.0025680065155029
(204) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00057411193847656
(205) DESCRIBE `orchid_image` 0.0020408630371094
(206) DESCRIBE `cruiselines` 0.0024559497833252
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00042605400085449
(208) DESCRIBE `cruises` 0.0035910606384277
(209) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75284') 0.00041294097900391
(210) DESCRIBE `ships` 0.0035130977630615
(211) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00051593780517578
(212) DESCRIBE `ships` 0.0040688514709473
(213) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00041794776916504
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00044107437133789
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003509521484375
(216) DESCRIBE `itineraries` 0.0019750595092773
(217) DESCRIBE `ports` 0.0018119812011719
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00041389465332031
(219) DESCRIBE `ports` 0.0017728805541992
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00046801567077637
(221) DESCRIBE `ports` 0.0017468929290771
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00038409233093262
(223) DESCRIBE `sailingdates` 0.0016829967498779
(224) DESCRIBE `ports` 0.0018448829650879
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00045990943908691
(226) DESCRIBE `ports` 0.0018720626831055
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00040006637573242
(228) DESCRIBE `ports` 0.0018620491027832
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00039887428283691
(230) DESCRIBE `ports` 0.0017869472503662
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00037598609924316
(232) DESCRIBE `ports` 0.0017449855804443
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.0003969669342041
(234) DESCRIBE `ports` 0.0018398761749268
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00037503242492676
(236) DESCRIBE `ports` 0.0019559860229492
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00056314468383789
(238) DESCRIBE `ports` 0.0020079612731934
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00038409233093262
(240) DESCRIBE `avid_specials` 0.0015590190887451
(241) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75284 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0015020370483398
(242) DESCRIBE `cruiselines` 0.0036540031433105
(243) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00057601928710938
(244) DESCRIBE `orchid_image` 0.0029749870300293
(245) DESCRIBE `cruiselines` 0.0034928321838379
(246) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00058293342590332
(247) DESCRIBE `cruises` 0.0051319599151611
(248) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62815') 0.00058484077453613
(249) DESCRIBE `ships` 0.0038390159606934
(250) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00046491622924805
(251) DESCRIBE `ships` 0.0036458969116211
(252) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00038886070251465
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038909912109375
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00037002563476562
(255) DESCRIBE `itineraries` 0.0017518997192383
(256) DESCRIBE `ports` 0.0018889904022217
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00046992301940918
(258) DESCRIBE `ports` 0.0018329620361328
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00040507316589355
(260) DESCRIBE `ports` 0.0017979145050049
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00037908554077148
(262) DESCRIBE `sailingdates` 0.0016279220581055
(263) DESCRIBE `ports` 0.0028290748596191
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00044488906860352
(265) DESCRIBE `ports` 0.0019960403442383
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00038313865661621
(267) DESCRIBE `ports` 0.0020039081573486
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00041699409484863
(269) DESCRIBE `ports` 0.0021908283233643
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00046300888061523
(271) DESCRIBE `ports` 0.0021169185638428
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00044798851013184
(273) DESCRIBE `ports` 0.0020248889923096
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00038814544677734
(275) DESCRIBE `avid_specials` 0.0016500949859619
(276) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62815 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0012049674987793
(277) DESCRIBE `cruiselines` 0.0026378631591797
(278) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00045919418334961
(279) DESCRIBE `orchid_image` 0.0020668506622314
(280) DESCRIBE `cruiselines` 0.0026018619537354
(281) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00039005279541016
(282) DESCRIBE `cruises` 0.0039999485015869
(283) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77977') 0.00058102607727051
(284) DESCRIBE `ships` 0.004011869430542
(285) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00054097175598145
(286) DESCRIBE `ships` 0.0037908554077148
(287) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00047802925109863
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038886070251465
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034904479980469
(290) DESCRIBE `itineraries` 0.0020160675048828
(291) DESCRIBE `ports` 0.0020270347595215
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00069499015808105
(293) DESCRIBE `ports` 0.0018351078033447
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00038886070251465
(295) DESCRIBE `ports` 0.0017991065979004
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00038385391235352
(297) DESCRIBE `sailingdates` 0.0016281604766846
(298) DESCRIBE `ports` 0.0018210411071777
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00053095817565918
(300) DESCRIBE `ports` 0.0018069744110107
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00037503242492676
(302) DESCRIBE `ports` 0.0018129348754883
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00042605400085449
(304) DESCRIBE `ports` 0.0018608570098877
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00037479400634766
(306) DESCRIBE `ports` 0.0019750595092773
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00064706802368164
(308) DESCRIBE `ports` 0.0021100044250488
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00048518180847168
(310) DESCRIBE `ports` 0.0019938945770264
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00043702125549316
(312) DESCRIBE `ports` 0.0018320083618164
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00038814544677734
(314) DESCRIBE `ports` 0.0019440650939941
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00041007995605469
(316) DESCRIBE `ports` 0.0024440288543701
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00046706199645996
(318) DESCRIBE `avid_specials` 0.0016200542449951
(319) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77977 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 26 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.0013358592987061
(320) DESCRIBE `cruiselines` 0.0030081272125244
(321) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00046110153198242
(322) DESCRIBE `orchid_image` 0.0026180744171143
(323) DESCRIBE `cruiselines` 0.002910852432251
(324) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00044488906860352
(325) DESCRIBE `cruises` 0.0036849975585938
(326) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61574') 0.0004279613494873
(327) DESCRIBE `ships` 0.0036509037017822
(328) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.0005028247833252
(329) DESCRIBE `ships` 0.0034980773925781
(330) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00052380561828613
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00048303604125977
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00050497055053711
(333) DESCRIBE `itineraries` 0.0025749206542969
(334) DESCRIBE `ports` 0.001849889755249
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00045299530029297
(336) DESCRIBE `ports` 0.0019619464874268
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00039792060852051
(338) DESCRIBE `ports` 0.0019359588623047
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0004270076751709
(340) DESCRIBE `sailingdates` 0.0017330646514893
(341) DESCRIBE `ports` 0.0018460750579834
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00043702125549316
(343) DESCRIBE `ports` 0.0024228096008301
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00043892860412598
(345) DESCRIBE `ports` 0.0020079612731934
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00044894218444824
(347) DESCRIBE `ports` 0.0018930435180664
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00040292739868164
(349) DESCRIBE `ports` 0.0017800331115723
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1842))) 0.00050616264343262
(351) DESCRIBE `ports` 0.002626895904541
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1842') 0.00037503242492676
(353) DESCRIBE `ports` 0.00201416015625
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00044679641723633
(355) DESCRIBE `ports` 0.0018188953399658
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00038290023803711
(357) DESCRIBE `ports` 0.0019149780273438
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00041794776916504
(359) DESCRIBE `ports` 0.0018289089202881
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00041604042053223
(361) DESCRIBE `ports` 0.0020201206207275
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 685))) 0.00048708915710449
(363) DESCRIBE `ports` 0.0019240379333496
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '685') 0.00044608116149902
(365) DESCRIBE `ports` 0.0019171237945557
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00043296813964844
(367) DESCRIBE `ports` 0.0019218921661377
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00039410591125488
(369) DESCRIBE `ports` 0.0018332004547119
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.00046992301940918
(371) DESCRIBE `ports` 0.0018861293792725
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00041103363037109
(373) DESCRIBE `ports` 0.0019128322601318
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 600))) 0.00043082237243652
(375) DESCRIBE `ports` 0.001971960067749
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '600') 0.00042510032653809
(377) DESCRIBE `ports` 0.0018839836120605
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00046420097351074
(379) DESCRIBE `ports` 0.0020589828491211
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00043606758117676
(381) DESCRIBE `ports` 0.0019547939300537
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00043487548828125
(383) DESCRIBE `ports` 0.0019209384918213
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00041294097900391
(385) DESCRIBE `ports` 0.0019750595092773
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0004429817199707
(387) DESCRIBE `ports` 0.002291202545166
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00041794776916504
(389) DESCRIBE `ports` 0.0019910335540771
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00049400329589844
(391) DESCRIBE `ports` 0.0022661685943604
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00064492225646973
(393) DESCRIBE `ports` 0.0019240379333496
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0006411075592041
(395) DESCRIBE `ports` 0.0026330947875977
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00044798851013184
(397) DESCRIBE `avid_specials` 0.0017290115356445
(398) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61574 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 28 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.0012331008911133
(399) DESCRIBE `cruiselines` 0.0028450489044189
(400) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00064492225646973
(401) DESCRIBE `orchid_image` 0.0023269653320312
(402) DESCRIBE `cruiselines` 0.0027649402618408
(403) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00054121017456055
(404) DESCRIBE `cruises` 0.0036170482635498
(405) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80643') 0.0003960132598877
(406) DESCRIBE `ships` 0.0034430027008057
(407) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00049400329589844
(408) DESCRIBE `ships` 0.00360107421875
(409) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00037693977355957
(410) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036001205444336
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034999847412109
(412) DESCRIBE `itineraries` 0.0017261505126953
(413) DESCRIBE `ports` 0.0018608570098877
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043106079101562
(415) DESCRIBE `ports` 0.0019128322601318
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041604042053223
(417) DESCRIBE `ports` 0.0017678737640381
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00047183036804199
(419) DESCRIBE `sailingdates` 0.0017268657684326
(420) DESCRIBE `ports` 0.0021569728851318
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049304962158203
(422) DESCRIBE `ports` 0.0022759437561035
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046396255493164
(424) DESCRIBE `ports` 0.0019848346710205
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058221817016602
(426) DESCRIBE `ports` 0.00201416015625
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00079512596130371
(428) DESCRIBE `ports` 0.0020308494567871
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00048708915710449
(430) DESCRIBE `ports` 0.0023608207702637
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00047206878662109
(432) DESCRIBE `ports` 0.0019989013671875
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00050902366638184
(434) DESCRIBE `ports` 0.0020081996917725
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00046396255493164
(436) DESCRIBE `ports` 0.0019538402557373
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00054407119750977
(438) DESCRIBE `ports` 0.0019669532775879
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0005800724029541
(440) DESCRIBE `avid_specials` 0.0018579959869385
(441) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80643 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0017139911651611
(442) DESCRIBE `cruiselines` 0.0028901100158691
(443) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00057506561279297
(444) DESCRIBE `orchid_image` 0.0021920204162598
(445) DESCRIBE `cruiselines` 0.0032579898834229
(446) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00057578086853027
(447) DESCRIBE `cruises` 0.0041098594665527
(448) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80644') 0.00069308280944824
(449) DESCRIBE `ships` 0.0040559768676758
(450) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00071120262145996
(451) DESCRIBE `ships` 0.0043611526489258
(452) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.0006110668182373
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0004570484161377
(454) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003659725189209
(455) DESCRIBE `itineraries` 0.0019898414611816
(456) DESCRIBE `ports` 0.0022671222686768
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00055694580078125
(458) DESCRIBE `ports` 0.0020079612731934
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00059795379638672
(460) DESCRIBE `ports` 0.002065896987915
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0005040168762207
(462) DESCRIBE `sailingdates` 0.001784086227417
(463) DESCRIBE `ports` 0.002288818359375
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00068879127502441
(465) DESCRIBE `ports` 0.0023708343505859
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0005190372467041
(467) DESCRIBE `ports` 0.0020899772644043
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006411075592041
(469) DESCRIBE `ports` 0.0020999908447266
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055289268493652
(471) DESCRIBE `avid_specials` 0.0019581317901611
(472) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80644 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0014939308166504
(473) DESCRIBE `cruiselines` 0.0028729438781738
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00059199333190918
(475) DESCRIBE `orchid_image` 0.0021011829376221
(476) DESCRIBE `cruiselines` 0.0025711059570312
(477) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00039911270141602
(478) DESCRIBE `ships` 0.004054069519043
(479) SELECT `ships`.* FROM `ships` WHERE (id IN ('1454', '1308', '818', '1730', '1479')) ORDER BY FIND_IN_SET(id, '1454,1308,818,1730,1479') 0.001276969909668
(480) DESCRIBE `cruisetypes` 0.0019090175628662
(481) DESCRIBE `destinations` 0.002371072769165
(482) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '21', '28', '8', '25', '26', '49', '35', '30', '55')) ORDER BY FIND_IN_SET(id, '40,21,28,8,25,26,49,35,30,55') 0.0019640922546387
(483) DESCRIBE `cruiselines` 0.0028581619262695
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00042486190795898
(485) DESCRIBE `cruiselines` 0.0034759044647217
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00076198577880859