or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 0.35028839111328

# Query Time
(1) connect 0.0012059211730957
(2) DESCRIBE `cruises` 0.004817008972168
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (79402, 79406, 79484)) ORDER BY FIND_IN_SET(id, '79402,79406,79484') 0.0024640560150146
(4) DESCRIBE `cruises` 0.0038819313049316
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79402') 0.00052404403686523
(6) DESCRIBE `ships` 0.0037720203399658
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00060296058654785
(8) DESCRIBE `ships` 0.0037600994110107
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00060415267944336
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00077199935913086
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00097799301147461
(12) DESCRIBE `itineraries` 0.002655029296875
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79402') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010459423065186
(14) DESCRIBE `ports` 0.0020899772644043
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00053000450134277
(16) DESCRIBE `ports` 0.0019659996032715
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00052499771118164
(18) DESCRIBE `ports` 0.0021719932556152
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00063896179199219
(20) DESCRIBE `sailingdates` 0.0018510818481445
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '79402') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011520385742188
(22) DESCRIBE `ports` 0.0024619102478027
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00059390068054199
(24) DESCRIBE `ports` 0.0022931098937988
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00047016143798828
(26) DESCRIBE `ports` 0.0019791126251221
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0011990070343018
(28) DESCRIBE `ports` 0.0022110939025879
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00045609474182129
(30) DESCRIBE `ports` 0.0018711090087891
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.0006108283996582
(32) DESCRIBE `ports` 0.0027449131011963
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00048708915710449
(34) DESCRIBE `ports` 0.0021190643310547
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00057101249694824
(36) DESCRIBE `ports` 0.0019478797912598
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00046300888061523
(38) DESCRIBE `ports` 0.0019509792327881
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.00045514106750488
(40) DESCRIBE `ports` 0.0020031929016113
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.00042295455932617
(42) DESCRIBE `ports` 0.0019500255584717
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3919))) 0.00048708915710449
(44) DESCRIBE `ports` 0.0019960403442383
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3919') 0.00044107437133789
(46) DESCRIBE `ports` 0.0019099712371826
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00045490264892578
(48) DESCRIBE `ports` 0.0019547939300537
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00044798851013184
(50) 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.012755155563354
(51) DESCRIBE `avid_specials` 0.0019400119781494
(52) 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.0016930103302002
(53) DESCRIBE `cruiselines` 0.0034170150756836
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00080394744873047
(55) DESCRIBE `orchid_image` 0.0037848949432373
(56) DESCRIBE `cruiselines` 0.0037350654602051
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00049996376037598
(58) DESCRIBE `cruises` 0.0043148994445801
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79406') 0.00058197975158691
(60) DESCRIBE `ships` 0.0039539337158203
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00090813636779785
(62) DESCRIBE `ships` 0.0037569999694824
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00048303604125977
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053310394287109
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045418739318848
(66) DESCRIBE `itineraries` 0.0025410652160645
(67) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79406') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085902214050293
(68) DESCRIBE `ports` 0.0023348331451416
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00048589706420898
(70) DESCRIBE `ports` 0.0019149780273438
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00040388107299805
(72) DESCRIBE `ports` 0.0019149780273438
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00038909912109375
(74) DESCRIBE `sailingdates` 0.001762866973877
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '79406') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00080013275146484
(76) DESCRIBE `ports` 0.0021510124206543
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00043487548828125
(78) DESCRIBE `ports` 0.0023660659790039
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00049614906311035
(80) DESCRIBE `ports` 0.0020670890808105
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00046896934509277
(82) DESCRIBE `ports` 0.002079963684082
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00053501129150391
(84) DESCRIBE `ports` 0.0021069049835205
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00048685073852539
(86) DESCRIBE `ports` 0.0019128322601318
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00042891502380371
(88) DESCRIBE `ports` 0.0016679763793945
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3919))) 0.00041699409484863
(90) DESCRIBE `ports` 0.0019180774688721
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3919') 0.00034999847412109
(92) DESCRIBE `ports` 0.0016038417816162
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.0004119873046875
(94) DESCRIBE `ports` 0.0017180442810059
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.00036096572875977
(96) DESCRIBE `ports` 0.0017099380493164
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00042200088500977
(98) DESCRIBE `ports` 0.0016908645629883
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00036907196044922
(100) DESCRIBE `ports` 0.001762866973877
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00040006637573242
(102) DESCRIBE `ports` 0.0018069744110107
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00039887428283691
(104) DESCRIBE `ports` 0.0017240047454834
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6012))) 0.00036096572875977
(106) DESCRIBE `ports` 0.0023989677429199
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6012') 0.00046396255493164
(108) DESCRIBE `ports` 0.0019829273223877
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0006110668182373
(110) DESCRIBE `ports` 0.0020480155944824
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00047516822814941
(112) 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.0085499286651611
(113) DESCRIBE `avid_specials` 0.0020709037780762
(114) 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.0020849704742432
(115) DESCRIBE `cruiselines` 0.0030281543731689
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00054693222045898
(117) DESCRIBE `orchid_image` 0.0022621154785156
(118) DESCRIBE `cruiselines` 0.002871036529541
(119) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00046610832214355
(120) DESCRIBE `cruises` 0.0036630630493164
(121) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79484') 0.00053095817565918
(122) DESCRIBE `ships` 0.0037128925323486
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00065279006958008
(124) DESCRIBE `ships` 0.0040140151977539
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00052809715270996
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036811828613281
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030899047851562
(128) DESCRIBE `itineraries` 0.0019659996032715
(129) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79484') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010330677032471
(130) DESCRIBE `ports` 0.0020229816436768
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00044894218444824
(132) DESCRIBE `ports` 0.0016608238220215
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0004420280456543
(134) DESCRIBE `ports` 0.0020661354064941
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00046801567077637
(136) DESCRIBE `sailingdates` 0.0018689632415771
(137) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '79484') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078916549682617
(138) DESCRIBE `ports` 0.0022199153900146
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00059294700622559
(140) DESCRIBE `ports` 0.0019919872283936
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.0004420280456543
(142) DESCRIBE `ports` 0.0021469593048096
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2151))) 0.00060582160949707
(144) DESCRIBE `ports` 0.0020768642425537
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2151') 0.0004429817199707
(146) DESCRIBE `ports` 0.0021300315856934
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 832))) 0.00055503845214844
(148) DESCRIBE `ports` 0.002051830291748
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '832') 0.00040197372436523
(150) DESCRIBE `ports` 0.0017960071563721
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5618))) 0.00043201446533203
(152) DESCRIBE `ports` 0.0019080638885498
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5618') 0.00043702125549316
(154) DESCRIBE `ports` 0.0019710063934326
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5618))) 0.00046396255493164
(156) DESCRIBE `ports` 0.0025060176849365
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5618') 0.0005958080291748
(158) DESCRIBE `ports` 0.0021178722381592
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2928))) 0.0004270076751709
(160) DESCRIBE `ports` 0.0019900798797607
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2928') 0.00040102005004883
(162) 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.0074918270111084
(163) DESCRIBE `avid_specials` 0.0020420551300049
(164) 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.0017189979553223
(165) DESCRIBE `cruiselines` 0.0026509761810303
(166) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00054097175598145
(167) DESCRIBE `orchid_image` 0.0021548271179199
(168) DESCRIBE `cruiselines` 0.002810001373291
(169) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.0004279613494873
(170) DESCRIBE `cruisetypes` 0.0019409656524658
(171) 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.046991109848022
(172) DESCRIBE `cruiselines` 0.0039989948272705
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.0013561248779297
(174) DESCRIBE `ships` 0.0040597915649414
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.0023529529571533
(176) DESCRIBE `destinations` 0.0031001567840576
(177) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 12))) 0.0012271404266357
(178) DESCRIBE `destinations` 0.0028350353240967
(179) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 12))) 0.00061893463134766
(180) DESCRIBE `cruiselines` 0.0030109882354736
(181) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.0006411075592041
(182) DESCRIBE `ships` 0.0039610862731934
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00063490867614746