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

Total elapsed time: 0.3218355178833

# Query Time
(1) connect 0.0011870861053467
(2) DESCRIBE `cruises` 0.004626989364624
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45260, 45259, 45259)) ORDER BY FIND_IN_SET(id, '45258,45260,45259,45259') 0.0028049945831299
(4) DESCRIBE `cruises` 0.00478196144104
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.0003359317779541
(6) DESCRIBE `ships` 0.0027878284454346
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0016469955444336
(8) DESCRIBE `ships` 0.003870964050293
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00047206878662109
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033807754516602
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003049373626709
(12) DESCRIBE `itineraries` 0.0020718574523926
(13) DESCRIBE `ports` 0.0017600059509277
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040602684020996
(15) DESCRIBE `ports` 0.0015740394592285
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00029802322387695
(17) DESCRIBE `ports` 0.0013329982757568
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00027608871459961
(19) DESCRIBE `sailingdates` 0.0012249946594238
(20) DESCRIBE `ports` 0.0017290115356445
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00037384033203125
(22) DESCRIBE `ports` 0.0018701553344727
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00035977363586426
(24) DESCRIBE `ports` 0.001629114151001
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00049209594726562
(26) DESCRIBE `ports` 0.0023729801177979
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00057601928710938
(28) DESCRIBE `ports` 0.0018758773803711
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00055503845214844
(30) DESCRIBE `ports` 0.0020561218261719
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0011100769042969
(32) DESCRIBE `ports` 0.0019969940185547
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00046610832214355
(34) DESCRIBE `ports` 0.0015139579772949
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 1.3113021850586E-5
(36) DESCRIBE `ports` 0.0021510124206543
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00021219253540039
(38) DESCRIBE `ports` 0.0014111995697021
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0
(40) DESCRIBE `ports` 0.0010840892791748
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0013859272003174
(42) DESCRIBE `ports` 0.0019450187683105
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00041103363037109
(44) DESCRIBE `ports` 0.0018880367279053
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00047397613525391
(46) DESCRIBE `ports` 0.0019099712371826
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00043082237243652
(48) DESCRIBE `ports` 0.0015699863433838
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00041294097900391
(50) DESCRIBE `ports` 0.0013511180877686
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00031304359436035
(52) DESCRIBE `ports` 0.0013167858123779
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00029301643371582
(54) DESCRIBE `ports` 0.0012521743774414
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00027608871459961
(56) DESCRIBE `avid_specials` 0.0011289119720459
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0012772083282471
(58) DESCRIBE `cruiselines` 0.0027999877929688
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00048398971557617
(60) DESCRIBE `orchid_image` 0.0020430088043213
(61) DESCRIBE `cruiselines` 0.0021159648895264
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00036215782165527
(63) DESCRIBE `cruises` 0.0026721954345703
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00035810470581055
(65) DESCRIBE `ships` 0.0029940605163574
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00057792663574219
(67) DESCRIBE `ships` 0.0037591457366943
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00037908554077148
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027298927307129
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030207633972168
(71) DESCRIBE `itineraries` 0.0019299983978271
(72) DESCRIBE `ports` 0.0021450519561768
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0
(74) DESCRIBE `ports` 0.0025618076324463
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00057578086853027
(76) DESCRIBE `ports` 0.00187087059021
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00034213066101074
(78) DESCRIBE `sailingdates` 0.0023841857910156
(79) DESCRIBE `ports` 0.0022540092468262
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00050115585327148
(81) DESCRIBE `ports` 0.0015649795532227
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00029706954956055
(83) DESCRIBE `ports` 0.0022399425506592
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00059318542480469
(85) DESCRIBE `ports` 0.0020618438720703
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00043916702270508
(87) DESCRIBE `ports` 0.0019190311431885
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00047206878662109
(89) DESCRIBE `ports` 0.0018379688262939
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00034213066101074
(91) DESCRIBE `ports` 0.0012860298156738
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00036501884460449
(93) DESCRIBE `ports` 0.0013730525970459
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0003502368927002
(95) DESCRIBE `ports` 0.0016970634460449
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.0004119873046875
(97) DESCRIBE `ports` 0.0018019676208496
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00041699409484863
(99) DESCRIBE `ports` 0.0017380714416504
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00041890144348145
(101) DESCRIBE `ports` 0.0018069744110107
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0003809928894043
(103) DESCRIBE `avid_specials` 0.0015301704406738
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0010819435119629
(105) DESCRIBE `cruiselines` 0.0019710063934326
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0003359317779541
(107) DESCRIBE `orchid_image` 0.0015051364898682
(108) DESCRIBE `cruiselines` 0.0026168823242188
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00040602684020996
(110) DESCRIBE `cruises` 0.0030598640441895
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00045418739318848
(112) DESCRIBE `ships` 0.0038731098175049
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00051212310791016
(114) DESCRIBE `ships` 0.0030040740966797
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00034618377685547
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026106834411621
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024890899658203
(118) DESCRIBE `itineraries` 0.0014009475708008
(119) DESCRIBE `ports` 0.0013079643249512
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00031805038452148
(121) DESCRIBE `ports` 0.0014379024505615
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00038290023803711
(123) DESCRIBE `ports` 0.0017998218536377
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00035309791564941
(125) DESCRIBE `sailingdates` 0.0016801357269287
(126) DESCRIBE `ports` 0.0018649101257324
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00041103363037109
(128) DESCRIBE `ports` 0.0013840198516846
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00033783912658691
(130) DESCRIBE `ports` 0.0015919208526611
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.0003809928894043
(132) DESCRIBE `ports` 0.001533031463623
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00033903121948242
(134) DESCRIBE `ports` 0.0013558864593506
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00030279159545898
(136) DESCRIBE `ports` 0.0014529228210449
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00029301643371582
(138) DESCRIBE `ports` 0.0014739036560059
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.0003809928894043
(140) DESCRIBE `ports` 0.0014739036560059
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.0003359317779541
(142) DESCRIBE `ports` 0.0013949871063232
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00031495094299316
(144) DESCRIBE `ports` 0.0013399124145508
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00030517578125
(146) DESCRIBE `ports` 0.0015580654144287
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032520294189453
(148) DESCRIBE `ports` 0.0015521049499512
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00030684471130371
(150) DESCRIBE `avid_specials` 0.0013000965118408
(151) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0012209415435791
(152) DESCRIBE `cruiselines` 0.0022280216217041
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00049209594726562
(154) DESCRIBE `orchid_image` 0.0018510818481445
(155) DESCRIBE `cruiselines` 0.0019640922546387
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00036001205444336
(157) DESCRIBE `specials` 0.0052518844604492
(158) DESCRIBE `specials` 0.004910945892334
(159) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1589465') 0.0006251335144043
(160) DESCRIBE `ships` 0.0026350021362305
(161) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00043487548828125
(162) DESCRIBE `ships` 0.0025670528411865
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00037407875061035
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026988983154297
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002589225769043
(166) DESCRIBE `itineraries` 0.0013179779052734
(167) DESCRIBE `ports` 0.0012922286987305
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032997131347656
(169) DESCRIBE `ports` 0.0021979808807373
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00039982795715332
(171) DESCRIBE `ports` 0.0017509460449219
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00042605400085449
(173) DESCRIBE `specialsailingdates` 0.0014657974243164
(174) DESCRIBE `sailingdates` 0.0015759468078613
(175) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504342))) 0.00075411796569824
(176) DESCRIBE `sailingdates` 0.0014679431915283
(177) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504343))) 0.00036406517028809
(178) DESCRIBE `sailingdates` 0.0016269683837891
(179) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504344))) 0.00046896934509277
(180) DESCRIBE `sailingdates` 0.0018060207366943
(181) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504345))) 0.00039005279541016
(182) DESCRIBE `sailingdates` 0.0017499923706055
(183) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504353))) 0.0004279613494873
(184) DESCRIBE `sailingdates` 0.0017271041870117
(185) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504354))) 0.0003809928894043
(186) DESCRIBE `sailingdates` 0.0015060901641846
(187) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504355))) 0.00032401084899902
(188) DESCRIBE `sailingdates` 0.0018620491027832
(189) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504356))) 0.00032591819763184
(190) DESCRIBE `sailingdates` 0.0016038417816162
(191) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504357))) 0.00041818618774414
(192) DESCRIBE `sailingdates` 0.0017321109771729
(193) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504358))) 0.00043582916259766
(194) DESCRIBE `sailingdates` 0.0017848014831543
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504359))) 0.00040698051452637
(196) DESCRIBE `ports` 0.0019149780273438
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00046896934509277
(198) DESCRIBE `ports` 0.0022518634796143
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040793418884277
(200) DESCRIBE `ports` 0.0019690990447998
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00044798851013184
(202) DESCRIBE `ports` 0.0018820762634277
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00042200088500977
(204) DESCRIBE `ports` 0.0018680095672607
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00047779083251953
(206) DESCRIBE `ports` 0.0018789768218994
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038790702819824
(208) DESCRIBE `ports` 0.0018839836120605
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00041413307189941
(210) DESCRIBE `ports` 0.0019078254699707
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00038385391235352
(212) DESCRIBE `ports` 0.0018889904022217
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00042915344238281
(214) DESCRIBE `ports` 0.0019779205322266
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00039505958557129
(216) DESCRIBE `ports` 0.0030031204223633
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045490264892578
(218) DESCRIBE `ports` 0.0019471645355225
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040602684020996
(220) DESCRIBE `cruises` 0.00370192527771
(221) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00064611434936523
(222) DESCRIBE `avid_specials` 0.0018599033355713
(223) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1589465 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0019738674163818
(224) DESCRIBE `cruiselines` 0.019901990890503
(225) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0013959407806396
(226) DESCRIBE `orchid_image` 0.0023009777069092
(227) DESCRIBE `cruiselines` 0.0031321048736572
(228) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00045204162597656
(229) DESCRIBE `ships` 0.0036900043487549
(230) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00067400932312012
(231) DESCRIBE `cruisetypes` 0.0012829303741455
(232) DESCRIBE `destinations` 0.0024919509887695
(233) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00064396858215332
(234) DESCRIBE `cruiselines` 0.0028440952301025
(235) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00044393539428711
(236) DESCRIBE `cruiselines` 0.0024740695953369
(237) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00040721893310547