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

Total elapsed time: 0.41137027740479

# Query Time
(1) connect 0.0009920597076416
(2) DESCRIBE `cruises` 0.004364013671875
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (79402, 79406, 79484)) ORDER BY FIND_IN_SET(id, '79402,79406,79484') 0.0026290416717529
(4) DESCRIBE `cruises` 0.0042331218719482
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79402') 0.00053191184997559
(6) DESCRIBE `ships` 0.0041069984436035
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.0010979175567627
(8) DESCRIBE `ships` 0.0041449069976807
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.0005490779876709
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036191940307617
(12) DESCRIBE `itineraries` 0.0019731521606445
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79402') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0033957958221436
(14) DESCRIBE `ports` 0.0022139549255371
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0017819404602051
(16) DESCRIBE `ports` 0.0053749084472656
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.005526065826416
(18) DESCRIBE `ports` 0.0027899742126465
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.0032601356506348
(20) DESCRIBE `sailingdates` 0.0056650638580322
(21) DESCRIBE `ports` 0.0023000240325928
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00056719779968262
(23) DESCRIBE `ports` 0.0020160675048828
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00047206878662109
(25) DESCRIBE `ports` 0.0021429061889648
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00053095817565918
(27) DESCRIBE `ports` 0.0022931098937988
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00046801567077637
(29) DESCRIBE `ports` 0.0019340515136719
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00047516822814941
(31) DESCRIBE `ports` 0.0027530193328857
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00047802925109863
(33) DESCRIBE `ports` 0.0018341541290283
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00061893463134766
(35) DESCRIBE `ports` 0.0018260478973389
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00045204162597656
(37) DESCRIBE `ports` 0.0023510456085205
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.00055193901062012
(39) DESCRIBE `ports` 0.0019190311431885
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.00042104721069336
(41) DESCRIBE `ports` 0.0017509460449219
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3919))) 0.00049710273742676
(43) DESCRIBE `ports` 0.0018110275268555
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3919') 0.00044083595275879
(45) DESCRIBE `ports` 0.0018610954284668
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00040388107299805
(47) DESCRIBE `ports` 0.0018489360809326
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00038599967956543
(49) 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.010335922241211
(50) DESCRIBE `avid_specials` 0.0019938945770264
(51) 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.001694917678833
(52) DESCRIBE `cruiselines` 0.0028131008148193
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00056195259094238
(54) DESCRIBE `orchid_image` 0.0021359920501709
(55) DESCRIBE `cruiselines` 0.0031211376190186
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00051689147949219
(57) DESCRIBE `cruises` 0.0052058696746826
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79406') 0.00068092346191406
(59) DESCRIBE `ships` 0.0042181015014648
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00060510635375977
(61) DESCRIBE `ships` 0.0040719509124756
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.0005490779876709
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0008389949798584
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042390823364258
(65) DESCRIBE `itineraries` 0.0022249221801758
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79406') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007929801940918
(67) DESCRIBE `ports` 0.002769947052002
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00078582763671875
(69) DESCRIBE `ports` 0.0026791095733643
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00048589706420898
(71) DESCRIBE `ports` 0.0023951530456543
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0005180835723877
(73) DESCRIBE `sailingdates` 0.0017330646514893
(74) DESCRIBE `ports` 0.0024919509887695
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00046396255493164
(76) DESCRIBE `ports` 0.0021090507507324
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.000701904296875
(78) DESCRIBE `ports` 0.0024600028991699
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00044798851013184
(80) DESCRIBE `ports` 0.0020430088043213
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00055098533630371
(82) DESCRIBE `ports` 0.0019700527191162
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00045895576477051
(84) DESCRIBE `ports` 0.0018777847290039
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00040102005004883
(86) DESCRIBE `ports` 0.0018668174743652
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3919))) 0.00044894218444824
(88) DESCRIBE `ports` 0.0024359226226807
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3919') 0.00044703483581543
(90) DESCRIBE `ports` 0.0023858547210693
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.0005040168762207
(92) DESCRIBE `ports` 0.0024478435516357
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.00060009956359863
(94) DESCRIBE `ports` 0.0031449794769287
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.0006861686706543
(96) DESCRIBE `ports` 0.0027971267700195
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00067687034606934
(98) DESCRIBE `ports` 0.0019800662994385
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00045609474182129
(100) DESCRIBE `ports` 0.0020670890808105
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.0003819465637207
(102) DESCRIBE `ports` 0.0018081665039062
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00039100646972656
(104) DESCRIBE `ports` 0.0019021034240723
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00037384033203125
(106) DESCRIBE `ports` 0.0019049644470215
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00047492980957031
(108) DESCRIBE `ports` 0.001924991607666
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00046896934509277
(110) 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.0091419219970703
(111) DESCRIBE `avid_specials` 0.0025911331176758
(112) 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.0018529891967773
(113) DESCRIBE `cruiselines` 0.002842903137207
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00065517425537109
(115) DESCRIBE `orchid_image` 0.0023350715637207
(116) DESCRIBE `cruiselines` 0.0024211406707764
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.0004730224609375
(118) DESCRIBE `cruises` 0.0045020580291748
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79484') 0.00051689147949219
(120) DESCRIBE `ships` 0.0037410259246826
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00074505805969238
(122) DESCRIBE `ships` 0.0042669773101807
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00051307678222656
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034213066101074
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(126) DESCRIBE `itineraries` 0.001878023147583
(127) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79484') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0042250156402588
(128) DESCRIBE `ports` 0.0024468898773193
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00099301338195801
(130) DESCRIBE `ports` 0.0018389225006104
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0005340576171875
(132) DESCRIBE `ports` 0.0018608570098877
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.0004279613494873
(134) DESCRIBE `sailingdates` 0.0021800994873047
(135) DESCRIBE `ports` 0.0022420883178711
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00054097175598145
(137) DESCRIBE `ports` 0.0023560523986816
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.0004420280456543
(139) DESCRIBE `ports` 0.0016908645629883
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2151))) 0.00046706199645996
(141) DESCRIBE `ports` 0.0021178722381592
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2151') 0.00046300888061523
(143) DESCRIBE `ports` 0.0020341873168945
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 832))) 0.00046086311340332
(145) DESCRIBE `ports` 0.0019161701202393
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '832') 0.0004279613494873
(147) DESCRIBE `ports` 0.0019299983978271
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5618))) 0.00046110153198242
(149) DESCRIBE `ports` 0.0018410682678223
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5618') 0.00042414665222168
(151) DESCRIBE `ports` 0.0017940998077393
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5618))) 0.00051307678222656
(153) DESCRIBE `ports` 0.0017831325531006
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5618') 0.00033402442932129
(155) DESCRIBE `ports` 0.001676082611084
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2928))) 0.00068497657775879
(157) DESCRIBE `ports` 0.0020709037780762
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2928') 0.00042915344238281
(159) 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.0090489387512207
(160) DESCRIBE `avid_specials` 0.0019271373748779
(161) 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.0016660690307617
(162) DESCRIBE `cruiselines` 0.0025219917297363
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00049996376037598
(164) DESCRIBE `orchid_image` 0.002112865447998
(165) DESCRIBE `cruiselines` 0.0026588439941406
(166) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00047206878662109
(167) DESCRIBE `cruisetypes` 0.0017461776733398
(168) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '12') AND (cruises_and_specials.cruiseline_id = '88') AND (cruises_and_specials.ship_id = '385') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.085851192474365
(169) DESCRIBE `cruiselines` 0.0037548542022705
(170) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.0010139942169189
(171) DESCRIBE `ships` 0.0057549476623535
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00059795379638672
(173) DESCRIBE `destinations` 0.0027859210968018
(174) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 12))) 0.00054001808166504
(175) DESCRIBE `destinations` 0.0029771327972412
(176) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 12))) 0.00061202049255371
(177) DESCRIBE `cruiselines` 0.0030479431152344
(178) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00057315826416016
(179) DESCRIBE `ships` 0.0042550563812256
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.0007319450378418