or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 0.24126052856445

# Query Time
(1) connect 0.0012681484222412
(2) DESCRIBE `cruises` 0.0044219493865967
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45260, 45259)) ORDER BY FIND_IN_SET(id, '45258,45260,45259') 0.0014572143554688
(4) DESCRIBE `cruises` 0.004310131072998
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00065803527832031
(6) DESCRIBE `ships` 0.0040929317474365
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00082015991210938
(8) DESCRIBE `ships` 0.0041601657867432
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00065898895263672
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037479400634766
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037813186645508
(12) DESCRIBE `itineraries` 0.0022189617156982
(13) DESCRIBE `ports` 0.0025010108947754
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00057101249694824
(15) DESCRIBE `ports` 0.002155065536499
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00050592422485352
(17) DESCRIBE `ports` 0.0025320053100586
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00051188468933105
(19) DESCRIBE `sailingdates` 0.0024640560150146
(20) DESCRIBE `ports` 0.0022070407867432
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00060796737670898
(22) DESCRIBE `ports` 0.0021829605102539
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00057697296142578
(24) DESCRIBE `ports` 0.0023319721221924
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.0007169246673584
(26) DESCRIBE `ports` 0.0030708312988281
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.0006098747253418
(28) DESCRIBE `ports` 0.0021090507507324
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044894218444824
(30) DESCRIBE `ports` 0.0019581317901611
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00041699409484863
(32) DESCRIBE `ports` 0.0017890930175781
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044703483581543
(34) DESCRIBE `ports` 0.0019700527191162
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00048303604125977
(36) DESCRIBE `ports` 0.0017910003662109
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00049901008605957
(38) DESCRIBE `ports` 0.0019598007202148
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00043702125549316
(40) DESCRIBE `ports` 0.0018031597137451
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00050616264343262
(42) DESCRIBE `ports` 0.0017001628875732
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00034189224243164
(44) DESCRIBE `ports` 0.001533031463623
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00036883354187012
(46) DESCRIBE `ports` 0.0017459392547607
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00048303604125977
(48) DESCRIBE `ports` 0.0021378993988037
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00048494338989258
(50) DESCRIBE `ports` 0.0019462108612061
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038504600524902
(52) DESCRIBE `ports` 0.0015830993652344
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00041389465332031
(54) DESCRIBE `ports` 0.0017540454864502
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00038790702819824
(56) DESCRIBE `avid_specials` 0.001716136932373
(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.0013818740844727
(58) DESCRIBE `cruiselines` 0.0025382041931152
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00051283836364746
(60) DESCRIBE `orchid_image` 0.0021240711212158
(61) DESCRIBE `cruiselines` 0.0030291080474854
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00053906440734863
(63) DESCRIBE `cruises` 0.0035920143127441
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00049996376037598
(65) DESCRIBE `ships` 0.004101037979126
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00064301490783691
(67) DESCRIBE `ships` 0.0035591125488281
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00060105323791504
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037693977355957
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034308433532715
(71) DESCRIBE `itineraries` 0.0019629001617432
(72) DESCRIBE `ports` 0.0020661354064941
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00063300132751465
(74) DESCRIBE `ports` 0.0021321773529053
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00055789947509766
(76) DESCRIBE `ports` 0.0020318031311035
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00044798851013184
(78) DESCRIBE `sailingdates` 0.0018231868743896
(79) DESCRIBE `ports` 0.0023670196533203
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00054597854614258
(81) DESCRIBE `ports` 0.0024540424346924
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00055885314941406
(83) DESCRIBE `ports` 0.0025479793548584
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.0006718635559082
(85) DESCRIBE `ports` 0.0020670890808105
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00047898292541504
(87) DESCRIBE `ports` 0.0018980503082275
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00048995018005371
(89) DESCRIBE `ports` 0.0019328594207764
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00040507316589355
(91) DESCRIBE `ports` 0.0019068717956543
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00048303604125977
(93) DESCRIBE `ports` 0.0021049976348877
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00046682357788086
(95) DESCRIBE `ports` 0.002079963684082
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00050616264343262
(97) DESCRIBE `ports` 0.0020298957824707
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.0004420280456543
(99) DESCRIBE `ports` 0.002007007598877
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004880428314209
(101) DESCRIBE `ports` 0.002007007598877
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00046801567077637
(103) DESCRIBE `avid_specials` 0.0019059181213379
(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.0021140575408936
(105) DESCRIBE `cruiselines` 0.0029959678649902
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00058913230895996
(107) DESCRIBE `orchid_image` 0.0022931098937988
(108) DESCRIBE `cruiselines` 0.0027289390563965
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00044012069702148
(110) DESCRIBE `cruises` 0.0035738945007324
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00060296058654785
(112) DESCRIBE `ships` 0.0041379928588867
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00068187713623047
(114) DESCRIBE `ships` 0.0039770603179932
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00053191184997559
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035810470581055
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035905838012695
(118) DESCRIBE `itineraries` 0.0019919872283936
(119) DESCRIBE `ports` 0.0019600391387939
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045895576477051
(121) DESCRIBE `ports` 0.0019011497497559
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00043201446533203
(123) DESCRIBE `ports` 0.0018720626831055
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00038599967956543
(125) DESCRIBE `sailingdates` 0.0019059181213379
(126) DESCRIBE `ports` 0.0021419525146484
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004429817199707
(128) DESCRIBE `ports` 0.0017402172088623
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00039505958557129
(130) DESCRIBE `ports` 0.0017549991607666
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00033903121948242
(132) DESCRIBE `ports` 0.0020971298217773
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00048685073852539
(134) DESCRIBE `ports` 0.0021259784698486
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00042104721069336
(136) DESCRIBE `ports` 0.0018510818481445
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00046205520629883
(138) DESCRIBE `ports` 0.0020468235015869
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00045585632324219
(140) DESCRIBE `ports` 0.0019829273223877
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00041890144348145
(142) DESCRIBE `ports` 0.0019001960754395
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0004889965057373
(144) DESCRIBE `ports` 0.0019240379333496
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00049114227294922
(146) DESCRIBE `ports` 0.0016450881958008
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00044393539428711
(148) DESCRIBE `ports` 0.0016129016876221
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00036001205444336
(150) DESCRIBE `avid_specials` 0.0014541149139404
(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.0013000965118408
(152) DESCRIBE `cruiselines` 0.0022819042205811
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00045394897460938
(154) DESCRIBE `orchid_image` 0.0022718906402588
(155) DESCRIBE `cruiselines` 0.0022678375244141
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.0003669261932373
(157) DESCRIBE `ships` 0.0038878917694092
(158) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00075292587280273
(159) DESCRIBE `cruisetypes` 0.0015149116516113
(160) DESCRIBE `destinations` 0.00211501121521
(161) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00056004524230957
(162) DESCRIBE `cruiselines` 0.0029668807983398
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0004889965057373
(164) DESCRIBE `cruiselines` 0.0030250549316406
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00045490264892578