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

Total elapsed time: 0.7154688835144

# Query Time
(1) connect 0.0013339519500732
(2) DESCRIBE `cruises` 0.0051839351654053
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75670, 75790, 75791, 75792, 77804, 77805, 77806, 77807, 77808, 77809)) ORDER BY FIND_IN_SET(id, '75670,75790,75791,75792,77804,77805,77806,77807,77808,77809') 0.001939058303833
(4) DESCRIBE `cruises` 0.0036211013793945
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75670') 0.00041103363037109
(6) DESCRIBE `ships` 0.0046000480651855
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00057411193847656
(8) DESCRIBE `ships` 0.003680944442749
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00048398971557617
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038599967956543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(12) DESCRIBE `itineraries` 0.0019590854644775
(13) DESCRIBE `ports` 0.0021839141845703
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044918060302734
(15) DESCRIBE `ports` 0.0017590522766113
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046086311340332
(17) DESCRIBE `ports` 0.0018720626831055
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00037693977355957
(19) DESCRIBE `sailingdates` 0.0016899108886719
(20) DESCRIBE `ports` 0.0018949508666992
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0004119873046875
(22) DESCRIBE `ports` 0.0021419525146484
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00050187110900879
(24) DESCRIBE `ports` 0.0017590522766113
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.0003809928894043
(26) DESCRIBE `ports` 0.0021579265594482
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00048685073852539
(28) DESCRIBE `ports` 0.0019810199737549
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00054788589477539
(30) DESCRIBE `ports` 0.0019099712371826
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00038599967956543
(32) DESCRIBE `ports` 0.0026969909667969
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00048017501831055
(34) DESCRIBE `ports` 0.0018570423126221
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.0005638599395752
(36) DESCRIBE `ports` 0.0019600391387939
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00041794776916504
(38) DESCRIBE `ports` 0.00177001953125
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00040698051452637
(40) DESCRIBE `ports` 0.0018072128295898
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00039005279541016
(42) DESCRIBE `ports` 0.001762866973877
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00045394897460938
(44) DESCRIBE `ports` 0.0019021034240723
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041913986206055
(46) DESCRIBE `ports` 0.0018520355224609
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038790702819824
(48) DESCRIBE `avid_specials` 0.0017340183258057
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75670 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 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.0011730194091797
(50) DESCRIBE `cruiselines` 0.0027940273284912
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00040793418884277
(52) DESCRIBE `orchid_image` 0.0020549297332764
(53) DESCRIBE `cruiselines` 0.0026359558105469
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00037097930908203
(55) DESCRIBE `cruises` 0.004425048828125
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75790') 0.00052094459533691
(57) DESCRIBE `ships` 0.0047659873962402
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00060701370239258
(59) DESCRIBE `ships` 0.0038251876831055
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00055193901062012
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037693977355957
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048184394836426
(63) DESCRIBE `itineraries` 0.001878023147583
(64) DESCRIBE `ports` 0.0019800662994385
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043487548828125
(66) DESCRIBE `ports` 0.0018608570098877
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045299530029297
(68) DESCRIBE `ports` 0.0019571781158447
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041007995605469
(70) DESCRIBE `sailingdates` 0.0016279220581055
(71) DESCRIBE `ports` 0.0020580291748047
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004429817199707
(73) DESCRIBE `ports` 0.0027029514312744
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043201446533203
(75) DESCRIBE `ports` 0.0020360946655273
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00056886672973633
(77) DESCRIBE `ports` 0.0027928352355957
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00060915946960449
(79) DESCRIBE `ports` 0.0031528472900391
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00088381767272949
(81) DESCRIBE `ports` 0.0028729438781738
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00061416625976562
(83) DESCRIBE `ports` 0.0030021667480469
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00071096420288086
(85) DESCRIBE `ports` 0.0029280185699463
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00051784515380859
(87) DESCRIBE `ports` 0.0025198459625244
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056099891662598
(89) DESCRIBE `ports` 0.0023159980773926
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00060415267944336
(91) DESCRIBE `avid_specials` 0.0019950866699219
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75790 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012960433959961
(93) DESCRIBE `cruiselines` 0.0028030872344971
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00069499015808105
(95) DESCRIBE `orchid_image` 0.002331018447876
(96) DESCRIBE `cruiselines` 0.0030150413513184
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00054287910461426
(98) DESCRIBE `cruises` 0.0043339729309082
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75791') 0.00056815147399902
(100) DESCRIBE `ships` 0.0045418739318848
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00089001655578613
(102) DESCRIBE `ships` 0.0044128894805908
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00058484077453613
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039911270141602
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(106) DESCRIBE `itineraries` 0.0018711090087891
(107) DESCRIBE `ports` 0.0017631053924561
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041913986206055
(109) DESCRIBE `ports` 0.0017719268798828
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041604042053223
(111) DESCRIBE `ports` 0.0018410682678223
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037503242492676
(113) DESCRIBE `sailingdates` 0.0015430450439453
(114) DESCRIBE `ports` 0.0018680095672607
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039505958557129
(116) DESCRIBE `ports` 0.0019140243530273
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037193298339844
(118) DESCRIBE `ports` 0.0017421245574951
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044679641723633
(120) DESCRIBE `ports` 0.0017240047454834
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003669261932373
(122) DESCRIBE `ports` 0.0018091201782227
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037097930908203
(124) DESCRIBE `ports` 0.0017540454864502
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00042009353637695
(126) DESCRIBE `ports` 0.0017287731170654
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00046300888061523
(128) DESCRIBE `ports` 0.0019321441650391
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00043010711669922
(130) DESCRIBE `ports` 0.0025629997253418
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063109397888184
(132) DESCRIBE `ports` 0.0027151107788086
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053596496582031
(134) DESCRIBE `avid_specials` 0.0023999214172363
(135) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75791 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017778873443604
(136) DESCRIBE `cruiselines` 0.0029008388519287
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00053906440734863
(138) DESCRIBE `orchid_image` 0.0020041465759277
(139) DESCRIBE `cruiselines` 0.0025930404663086
(140) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00039005279541016
(141) DESCRIBE `cruises` 0.0033838748931885
(142) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75792') 0.00039887428283691
(143) DESCRIBE `ships` 0.0034058094024658
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.0010099411010742
(145) DESCRIBE `ships` 0.0051209926605225
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00065398216247559
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037598609924316
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035405158996582
(149) DESCRIBE `itineraries` 0.0020220279693604
(150) DESCRIBE `ports` 0.0027799606323242
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061511993408203
(152) DESCRIBE `ports` 0.0026488304138184
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060796737670898
(154) DESCRIBE `ports` 0.0026860237121582
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054001808166504
(156) DESCRIBE `sailingdates` 0.002234935760498
(157) DESCRIBE `ports` 0.0025289058685303
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056314468383789
(159) DESCRIBE `ports` 0.0024900436401367
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054383277893066
(161) DESCRIBE `ports` 0.0024771690368652
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00060105323791504
(163) DESCRIBE `ports` 0.0024600028991699
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00060200691223145
(165) DESCRIBE `ports` 0.0024430751800537
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00058293342590332
(167) DESCRIBE `ports` 0.0025038719177246
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00051093101501465
(169) DESCRIBE `ports` 0.0024619102478027
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00059008598327637
(171) DESCRIBE `ports` 0.002432107925415
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00057721138000488
(173) DESCRIBE `ports` 0.0025699138641357
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00059103965759277
(175) DESCRIBE `ports` 0.0025761127471924
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00056600570678711
(177) DESCRIBE `ports` 0.0025339126586914
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00074005126953125
(179) DESCRIBE `ports` 0.0028090476989746
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061893463134766
(181) DESCRIBE `avid_specials` 0.0023679733276367
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75792 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022199153900146
(183) DESCRIBE `cruiselines` 0.0036098957061768
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00060319900512695
(185) DESCRIBE `orchid_image` 0.0028598308563232
(186) DESCRIBE `cruiselines` 0.003727912902832
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00059199333190918
(188) DESCRIBE `cruises` 0.0048918724060059
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77804') 0.0005650520324707
(190) DESCRIBE `ships` 0.0050308704376221
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.0008089542388916
(192) DESCRIBE `ships` 0.0050380229949951
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00075101852416992
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055599212646484
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048208236694336
(196) DESCRIBE `itineraries` 0.0026431083679199
(197) DESCRIBE `ports` 0.0046939849853516
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062394142150879
(199) DESCRIBE `ports` 0.005756139755249
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066518783569336
(201) DESCRIBE `ports` 0.0025420188903809
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054311752319336
(203) DESCRIBE `sailingdates` 0.002173900604248
(204) DESCRIBE `ports` 0.0025830268859863
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059103965759277
(206) DESCRIBE `ports` 0.0025160312652588
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052595138549805
(208) DESCRIBE `ports` 0.0024740695953369
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00054812431335449
(210) DESCRIBE `ports` 0.0027129650115967
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00056695938110352
(212) DESCRIBE `ports` 0.0027198791503906
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00055217742919922
(214) DESCRIBE `ports` 0.0025498867034912
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00052499771118164
(216) DESCRIBE `ports` 0.0025269985198975
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0005340576171875
(218) DESCRIBE `ports` 0.0024580955505371
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00056600570678711
(220) DESCRIBE `ports` 0.0024869441986084
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00072598457336426
(222) DESCRIBE `ports` 0.0024838447570801
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00054001808166504
(224) DESCRIBE `ports` 0.0024709701538086
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056815147399902
(226) DESCRIBE `ports` 0.0025379657745361
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006098747253418
(228) DESCRIBE `avid_specials` 0.0023720264434814
(229) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77804 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021069049835205
(230) DESCRIBE `cruiselines` 0.0035979747772217
(231) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00060582160949707
(232) DESCRIBE `orchid_image` 0.0030310153961182
(233) DESCRIBE `cruiselines` 0.003972053527832
(234) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00059103965759277
(235) DESCRIBE `cruises` 0.0048291683197021
(236) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77805') 0.00049304962158203
(237) DESCRIBE `ships` 0.0043959617614746
(238) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00088596343994141
(239) DESCRIBE `ships` 0.0040929317474365
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00055980682373047
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045490264892578
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(243) DESCRIBE `itineraries` 0.0019738674163818
(244) DESCRIBE `ports` 0.0017919540405273
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049710273742676
(246) DESCRIBE `ports` 0.0019559860229492
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(248) DESCRIBE `ports` 0.0018138885498047
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055909156799316
(250) DESCRIBE `sailingdates` 0.0023801326751709
(251) DESCRIBE `ports` 0.0019450187683105
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056195259094238
(253) DESCRIBE `ports` 0.00199294090271
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039100646972656
(255) DESCRIBE `ports` 0.001835823059082
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00039982795715332
(257) DESCRIBE `ports` 0.0017797946929932
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0004279613494873
(259) DESCRIBE `ports` 0.0022070407867432
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045108795166016
(261) DESCRIBE `ports` 0.0018258094787598
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038790702819824
(263) DESCRIBE `avid_specials` 0.001680850982666
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77805 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 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.0011599063873291
(265) DESCRIBE `cruiselines` 0.0025949478149414
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047588348388672
(267) DESCRIBE `orchid_image` 0.0022799968719482
(268) DESCRIBE `cruiselines` 0.0026140213012695
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00047397613525391
(270) DESCRIBE `cruises` 0.0036249160766602
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77806') 0.00042581558227539
(272) DESCRIBE `ships` 0.00345778465271
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00057291984558105
(274) DESCRIBE `ships` 0.0036680698394775
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00051593780517578
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039315223693848
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004570484161377
(278) DESCRIBE `itineraries` 0.0017940998077393
(279) DESCRIBE `ports` 0.0019650459289551
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(281) DESCRIBE `ports` 0.0018460750579834
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041818618774414
(283) DESCRIBE `ports` 0.0017588138580322
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042295455932617
(285) DESCRIBE `sailingdates` 0.0015730857849121
(286) DESCRIBE `ports` 0.0017800331115723
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041794776916504
(288) DESCRIBE `ports` 0.0018610954284668
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046801567077637
(290) DESCRIBE `ports` 0.0018379688262939
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0004119873046875
(292) DESCRIBE `ports` 0.0022859573364258
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00047707557678223
(294) DESCRIBE `ports` 0.0020251274108887
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00051307678222656
(296) DESCRIBE `ports` 0.0019550323486328
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00038599967956543
(298) DESCRIBE `ports` 0.0018079280853271
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00043511390686035
(300) DESCRIBE `ports` 0.0018370151519775
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038409233093262
(302) DESCRIBE `ports` 0.0019030570983887
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048112869262695
(304) DESCRIBE `ports` 0.0018460750579834
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00068402290344238
(306) DESCRIBE `avid_specials` 0.0016498565673828
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77806 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012800693511963
(308) DESCRIBE `cruiselines` 0.0027890205383301
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00057697296142578
(310) DESCRIBE `orchid_image` 0.0021591186523438
(311) DESCRIBE `cruiselines` 0.0027430057525635
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00049304962158203
(313) DESCRIBE `cruises` 0.0049068927764893
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77807') 0.00063490867614746
(315) DESCRIBE `ships` 0.0053479671478271
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00089812278747559
(317) DESCRIBE `ships` 0.0052070617675781
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00074219703674316
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049591064453125
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047612190246582
(321) DESCRIBE `itineraries` 0.0026230812072754
(322) DESCRIBE `ports` 0.0025711059570312
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00068497657775879
(324) DESCRIBE `ports` 0.0029890537261963
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00079989433288574
(326) DESCRIBE `ports` 0.002993106842041
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00070786476135254
(328) DESCRIBE `sailingdates` 0.0025510787963867
(329) DESCRIBE `ports` 0.0030279159545898
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00077605247497559
(331) DESCRIBE `ports` 0.0021488666534424
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049400329589844
(333) DESCRIBE `ports` 0.0019941329956055
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00075411796569824
(335) DESCRIBE `ports` 0.0022449493408203
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00052714347839355
(337) DESCRIBE `ports` 0.0021839141845703
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00055694580078125
(339) DESCRIBE `ports` 0.0020759105682373
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00048398971557617
(341) DESCRIBE `ports` 0.0021660327911377
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00060105323791504
(343) DESCRIBE `ports` 0.0021328926086426
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00053095817565918
(345) DESCRIBE `ports` 0.0021469593048096
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00066304206848145
(347) DESCRIBE `ports` 0.0021650791168213
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00046014785766602
(349) DESCRIBE `ports` 0.0019888877868652
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(351) DESCRIBE `ports` 0.0023231506347656
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041508674621582
(353) DESCRIBE `avid_specials` 0.0018820762634277
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77807 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015251636505127
(355) DESCRIBE `cruiselines` 0.0028789043426514
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00055480003356934
(357) DESCRIBE `orchid_image` 0.0021588802337646
(358) DESCRIBE `cruiselines` 0.002640962600708
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040793418884277
(360) DESCRIBE `cruises` 0.0045921802520752
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77808') 0.00045180320739746
(362) DESCRIBE `ships` 0.0045008659362793
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00084900856018066
(364) DESCRIBE `ships` 0.0043220520019531
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00069808959960938
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(368) DESCRIBE `itineraries` 0.0017910003662109
(369) DESCRIBE `ports` 0.0023338794708252
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0027449131011963
(371) DESCRIBE `ports` 0.002079963684082
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057387351989746
(373) DESCRIBE `ports` 0.0024280548095703
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044608116149902
(375) DESCRIBE `sailingdates` 0.0019879341125488
(376) DESCRIBE `ports` 0.0018749237060547
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048613548278809
(378) DESCRIBE `ports` 0.0019149780273438
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00064682960510254
(380) DESCRIBE `ports` 0.0021390914916992
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00054216384887695
(382) DESCRIBE `ports` 0.0021920204162598
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00042200088500977
(384) DESCRIBE `ports` 0.0020229816436768
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00075793266296387
(386) DESCRIBE `ports` 0.00229811668396
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00042581558227539
(388) DESCRIBE `ports` 0.0025820732116699
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062298774719238
(390) DESCRIBE `ports` 0.0018768310546875
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003969669342041
(392) DESCRIBE `avid_specials` 0.001676082611084
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77808 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 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.0013139247894287
(394) DESCRIBE `cruiselines` 0.0025949478149414
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00044393539428711
(396) DESCRIBE `orchid_image` 0.0023021697998047
(397) DESCRIBE `cruiselines` 0.0025339126586914
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00054121017456055
(399) DESCRIBE `cruises` 0.00341796875
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77809') 0.00038790702819824
(401) DESCRIBE `ships` 0.0035531520843506
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.0007021427154541
(403) DESCRIBE `ships` 0.0035479068756104
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00180983543396
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040602684020996
(407) DESCRIBE `itineraries` 0.0018031597137451
(408) DESCRIBE `ports` 0.0018091201782227
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049400329589844
(410) DESCRIBE `ports` 0.001762866973877
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051093101501465
(412) DESCRIBE `ports` 0.0018198490142822
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003809928894043
(414) DESCRIBE `sailingdates` 0.0016129016876221
(415) DESCRIBE `ports` 0.0017709732055664
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052189826965332
(417) DESCRIBE `ports` 0.0018279552459717
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039505958557129
(419) DESCRIBE `ports` 0.0018229484558105
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00039887428283691
(421) DESCRIBE `ports` 0.0019600391387939
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00042605400085449
(423) DESCRIBE `ports` 0.0021510124206543
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00041413307189941
(425) DESCRIBE `ports` 0.0018260478973389
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00039410591125488
(427) DESCRIBE `ports` 0.0018339157104492
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041079521179199
(429) DESCRIBE `ports` 0.0018079280853271
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050806999206543
(431) DESCRIBE `avid_specials` 0.0015830993652344
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77809 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012109279632568
(433) DESCRIBE `cruiselines` 0.002532958984375
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00050997734069824
(435) DESCRIBE `orchid_image` 0.0021440982818604
(436) DESCRIBE `cruiselines` 0.0030229091644287
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040793418884277
(438) DESCRIBE `cruisetypes` 0.0018231868743896
(439) DESCRIBE `destinations` 0.0025959014892578
(440) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00070095062255859
(441) DESCRIBE `cruiselines` 0.0028929710388184
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045895576477051
(443) DESCRIBE `ships` 0.0037078857421875
(444) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00063514709472656
(445) DESCRIBE `cruiselines` 0.0026419162750244
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047898292541504
(447) DESCRIBE `ships` 0.0040290355682373
(448) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00061702728271484