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

Total elapsed time: 0.3528311252594

# Query Time
(1) connect 0.001352071762085
(2) DESCRIBE `cruises` 0.00547194480896
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (79402, 79406, 79484)) ORDER BY FIND_IN_SET(id, '79402,79406,79484') 0.0018560886383057
(4) DESCRIBE `cruises` 0.004457950592041
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79402') 0.00074195861816406
(6) DESCRIBE `ships` 0.0055501461029053
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00069594383239746
(8) DESCRIBE `ships` 0.0043971538543701
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00087308883666992
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00057005882263184
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040507316589355
(12) DESCRIBE `itineraries` 0.0024251937866211
(13) DESCRIBE `ports` 0.0027980804443359
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00062012672424316
(15) DESCRIBE `ports` 0.0027110576629639
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00059103965759277
(17) DESCRIBE `ports` 0.0026729106903076
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00057196617126465
(19) DESCRIBE `sailingdates` 0.0022702217102051
(20) DESCRIBE `ports` 0.0025508403778076
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00059819221496582
(22) DESCRIBE `ports` 0.0025119781494141
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00055408477783203
(24) DESCRIBE `ports` 0.0025780200958252
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00057506561279297
(26) DESCRIBE `ports` 0.0025191307067871
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00053310394287109
(28) DESCRIBE `ports` 0.0021851062774658
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00039291381835938
(30) DESCRIBE `ports` 0.0020210742950439
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00042009353637695
(32) DESCRIBE `ports` 0.001903772354126
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00046300888061523
(34) DESCRIBE `ports` 0.0020220279693604
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00037980079650879
(36) DESCRIBE `ports` 0.0021200180053711
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.00040483474731445
(38) DESCRIBE `ports` 0.0018138885498047
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.00036501884460449
(40) DESCRIBE `ports` 0.0017189979553223
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3919))) 0.00052785873413086
(42) DESCRIBE `ports` 0.0020840167999268
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3919') 0.00043606758117676
(44) DESCRIBE `ports` 0.0019919872283936
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00044488906860352
(46) DESCRIBE `ports` 0.0027809143066406
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00054693222045898
(48) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79402') AND (sailingdate >= '2020-02-01') AND (sailingdate <= '2020-03-29') 0.013751029968262
(49) DESCRIBE `avid_specials` 0.0024499893188477
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79402 and class = 'Cruise') OR (item_id = 385 AND class = 'Ship') OR (item_id = 88 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.0023329257965088
(51) DESCRIBE `cruiselines` 0.0036261081695557
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.0006709098815918
(53) DESCRIBE `orchid_image` 0.0031118392944336
(54) DESCRIBE `cruiselines` 0.0038561820983887
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.0006868839263916
(56) DESCRIBE `cruises` 0.0052390098571777
(57) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79406') 0.00064301490783691
(58) DESCRIBE `ships` 0.0052390098571777
(59) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00067996978759766
(60) DESCRIBE `ships` 0.0047237873077393
(61) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00060105323791504
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004570484161377
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045394897460938
(64) DESCRIBE `itineraries` 0.0025849342346191
(65) DESCRIBE `ports` 0.0021030902862549
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00047111511230469
(67) DESCRIBE `ports` 0.0020108222961426
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00040698051452637
(69) DESCRIBE `ports` 0.0027041435241699
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00056695938110352
(71) DESCRIBE `sailingdates` 0.0018839836120605
(72) DESCRIBE `ports` 0.0021440982818604
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00049304962158203
(74) DESCRIBE `ports` 0.0021660327911377
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00046801567077637
(76) DESCRIBE `ports` 0.0022099018096924
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00055885314941406
(78) DESCRIBE `ports` 0.0021779537200928
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00038504600524902
(80) DESCRIBE `ports` 0.0020830631256104
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00077080726623535
(82) DESCRIBE `ports` 0.0028159618377686
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00053000450134277
(84) DESCRIBE `ports` 0.0022261142730713
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3919))) 0.0005340576171875
(86) DESCRIBE `ports` 0.0018970966339111
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3919') 0.00050592422485352
(88) DESCRIBE `ports` 0.0025680065155029
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.00047421455383301
(90) DESCRIBE `ports` 0.0020210742950439
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.0004570484161377
(92) DESCRIBE `ports` 0.0022470951080322
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00043010711669922
(94) DESCRIBE `ports` 0.0023009777069092
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00048398971557617
(96) DESCRIBE `ports` 0.0023579597473145
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00039482116699219
(98) DESCRIBE `ports` 0.0025119781494141
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00042486190795898
(100) DESCRIBE `ports` 0.0022249221801758
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00055885314941406
(102) DESCRIBE `ports` 0.0023279190063477
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00045990943908691
(104) DESCRIBE `ports` 0.0021371841430664
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0005180835723877
(106) DESCRIBE `ports` 0.0028090476989746
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00060606002807617
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79406') AND (sailingdate >= '2020-02-01') AND (sailingdate <= '2020-03-29') 0.010673046112061
(109) DESCRIBE `avid_specials` 0.0026199817657471
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79406 and class = 'Cruise') OR (item_id = 385 AND class = 'Ship') OR (item_id = 88 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.0020999908447266
(111) DESCRIBE `cruiselines` 0.0037121772766113
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00065493583679199
(113) DESCRIBE `orchid_image` 0.0029230117797852
(114) DESCRIBE `cruiselines` 0.0036649703979492
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.0005791187286377
(116) DESCRIBE `cruises` 0.0050308704376221
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79484') 0.00062203407287598
(118) DESCRIBE `ships` 0.0052270889282227
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00088691711425781
(120) DESCRIBE `ships` 0.0059731006622314
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00072908401489258
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047397613525391
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00055193901062012
(124) DESCRIBE `itineraries` 0.0028581619262695
(125) DESCRIBE `ports` 0.0034060478210449
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00072622299194336
(127) DESCRIBE `ports` 0.0028581619262695
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0006711483001709
(129) DESCRIBE `ports` 0.0027740001678467
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00066304206848145
(131) DESCRIBE `sailingdates` 0.0021991729736328
(132) DESCRIBE `ports` 0.0028409957885742
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00071001052856445
(134) DESCRIBE `ports` 0.002877950668335
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00065493583679199
(136) DESCRIBE `ports` 0.0027091503143311
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2151))) 0.00061202049255371
(138) DESCRIBE `ports` 0.0028340816497803
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2151') 0.00058484077453613
(140) DESCRIBE `ports` 0.0036990642547607
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 832))) 0.00069308280944824
(142) DESCRIBE `ports` 0.0037469863891602
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '832') 0.00061798095703125
(144) DESCRIBE `ports` 0.0025999546051025
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5618))) 0.00069499015808105
(146) DESCRIBE `ports` 0.0029239654541016
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5618') 0.00060796737670898
(148) DESCRIBE `ports` 0.0022768974304199
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5618))) 0.00063395500183105
(150) DESCRIBE `ports` 0.0023899078369141
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5618') 0.00065207481384277
(152) DESCRIBE `ports` 0.0019760131835938
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2928))) 0.0004570484161377
(154) DESCRIBE `ports` 0.0020971298217773
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2928') 0.0004570484161377
(156) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79484') AND (sailingdate >= '2020-02-01') AND (sailingdate <= '2020-03-29') 0.011353969573975
(157) DESCRIBE `avid_specials` 0.0025370121002197
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79484 and class = 'Cruise') OR (item_id = 385 AND class = 'Ship') OR (item_id = 88 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.0013689994812012
(159) DESCRIBE `cruiselines` 0.0041229724884033
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00072383880615234
(161) DESCRIBE `orchid_image` 0.0031459331512451
(162) DESCRIBE `cruiselines` 0.0039799213409424
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00061297416687012
(164) DESCRIBE `cruisetypes` 0.0025501251220703
(165) DESCRIBE `cruiselines` 0.0037868022918701
(166) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00060606002807617
(167) DESCRIBE `ships` 0.0052609443664551
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.0012001991271973
(169) DESCRIBE `destinations` 0.0039730072021484
(170) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 12))) 0.00077986717224121
(171) DESCRIBE `destinations` 0.0039520263671875
(172) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 12))) 0.00072193145751953
(173) DESCRIBE `cruiselines` 0.0029919147491455
(174) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00057601928710938
(175) DESCRIBE `ships` 0.0049610137939453
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00068879127502441