or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 0.22695064544678

# Query Time
(1) connect 0.00090289115905762
(2) DESCRIBE `cruises` 0.0037860870361328
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 45258, 45260)) ORDER BY FIND_IN_SET(id, '45259,45258,45260') 0.0013020038604736
(4) DESCRIBE `cruises` 0.0039849281311035
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00044512748718262
(6) DESCRIBE `ships` 0.0039918422698975
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0014388561248779
(8) DESCRIBE `ships` 0.0041050910949707
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00050806999206543
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035500526428223
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033211708068848
(12) DESCRIBE `itineraries` 0.0018751621246338
(13) DESCRIBE `ports` 0.0015549659729004
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00039291381835938
(15) DESCRIBE `ports` 0.0019490718841553
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 5.4121017456055E-5
(17) DESCRIBE `ports` 0.0019149780273438
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00080609321594238
(19) DESCRIBE `sailingdates` 0.0017001628875732
(20) DESCRIBE `ports` 0.0020217895507812
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00046300888061523
(22) DESCRIBE `ports` 0.0022850036621094
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00045895576477051
(24) DESCRIBE `ports` 0.0019309520721436
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00046491622924805
(26) DESCRIBE `ports` 0.0018770694732666
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00042414665222168
(28) DESCRIBE `ports` 0.0018770694732666
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00045394897460938
(30) DESCRIBE `ports` 0.0019340515136719
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00038599967956543
(32) DESCRIBE `ports` 0.0018150806427002
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00041794776916504
(34) DESCRIBE `ports` 0.0017969608306885
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00046896934509277
(36) DESCRIBE `ports` 0.0018680095672607
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0010669231414795
(38) DESCRIBE `ports` 0.0011861324310303
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040912628173828
(40) DESCRIBE `avid_specials` 0.001121997833252
(41) 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.0021460056304932
(42) DESCRIBE `cruiselines` 0.0027658939361572
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00043010711669922
(44) DESCRIBE `orchid_image` 0.0021331310272217
(45) DESCRIBE `cruiselines` 0.0025579929351807
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00043296813964844
(47) DESCRIBE `cruises` 0.003748893737793
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00046682357788086
(49) DESCRIBE `ships` 0.0038340091705322
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0010349750518799
(51) DESCRIBE `ships` 0.0041649341583252
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00054717063903809
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033998489379883
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031709671020508
(55) DESCRIBE `itineraries` 0.0020091533660889
(56) DESCRIBE `ports` 0.0023388862609863
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00053191184997559
(58) DESCRIBE `ports` 0.0020849704742432
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00049805641174316
(60) DESCRIBE `ports` 0.0020079612731934
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00043702125549316
(62) DESCRIBE `sailingdates` 0.0017111301422119
(63) DESCRIBE `ports` 0.0020790100097656
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00050497055053711
(65) DESCRIBE `ports` 0.0019731521606445
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041294097900391
(67) DESCRIBE `ports` 0.0011200904846191
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.0012428760528564
(69) DESCRIBE `ports` 0.0018310546875
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.0012421607971191
(71) DESCRIBE `ports` 0.0013370513916016
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044512748718262
(73) DESCRIBE `ports` 0.0018248558044434
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00029897689819336
(75) DESCRIBE `ports` 0.0013608932495117
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00029802322387695
(77) DESCRIBE `ports` 0.0012919902801514
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00028800964355469
(79) DESCRIBE `ports` 0.0012660026550293
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00031805038452148
(81) DESCRIBE `ports` 0.0013079643249512
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00028896331787109
(83) DESCRIBE `ports` 0.0014309883117676
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00031399726867676
(85) DESCRIBE `ports` 0.0012991428375244
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00033712387084961
(87) DESCRIBE `ports` 0.0013949871063232
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00032401084899902
(89) DESCRIBE `ports` 0.0013008117675781
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00034594535827637
(91) DESCRIBE `ports` 0.0012660026550293
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00029492378234863
(93) DESCRIBE `ports` 0.0012979507446289
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00032997131347656
(95) DESCRIBE `ports` 0.0015277862548828
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032281875610352
(97) DESCRIBE `ports` 0.0013480186462402
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0002901554107666
(99) DESCRIBE `avid_specials` 0.0011861324310303
(100) 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.0011398792266846
(101) DESCRIBE `cruiselines` 0.0020871162414551
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00030708312988281
(103) DESCRIBE `orchid_image` 0.0020668506622314
(104) DESCRIBE `cruiselines` 0.0018830299377441
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00033712387084961
(106) DESCRIBE `cruises` 0.0033438205718994
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00044608116149902
(108) DESCRIBE `ships` 0.0029339790344238
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00043797492980957
(110) DESCRIBE `ships` 0.0028681755065918
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00035214424133301
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030899047851562
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030088424682617
(114) DESCRIBE `itineraries` 0.0014259815216064
(115) DESCRIBE `ports` 0.0015089511871338
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00036406517028809
(117) DESCRIBE `ports` 0.0013768672943115
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003209114074707
(119) DESCRIBE `ports` 0.0015640258789062
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00036907196044922
(121) DESCRIBE `sailingdates` 0.0013580322265625
(122) DESCRIBE `ports` 0.0018360614776611
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00037693977355957
(124) DESCRIBE `ports` 0.0014309883117676
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0003209114074707
(126) DESCRIBE `ports` 0.0013430118560791
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00033807754516602
(128) DESCRIBE `ports` 0.001370906829834
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00030303001403809
(130) DESCRIBE `ports` 0.0017509460449219
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00034999847412109
(132) DESCRIBE `ports` 0.0016880035400391
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00093388557434082
(134) DESCRIBE `ports` 0.0010731220245361
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00032782554626465
(136) DESCRIBE `ports` 0.0013678073883057
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00029397010803223
(138) DESCRIBE `ports` 0.0012919902801514
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00033903121948242
(140) DESCRIBE `ports` 0.0022408962249756
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00031089782714844
(142) DESCRIBE `ports` 0.0013501644134521
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00034904479980469
(144) DESCRIBE `ports` 0.0015349388122559
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041890144348145
(146) DESCRIBE `avid_specials` 0.0011968612670898
(147) 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.0011148452758789
(148) DESCRIBE `cruiselines` 0.023434162139893
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 8.2015991210938E-5
(150) DESCRIBE `orchid_image` 0.0021870136260986
(151) DESCRIBE `cruiselines` 0.0032081604003906
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00048112869262695
(153) DESCRIBE `ships` 0.0041658878326416
(154) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00062799453735352
(155) DESCRIBE `cruisetypes` 0.0016648769378662
(156) DESCRIBE `destinations` 0.002687931060791
(157) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00055789947509766
(158) DESCRIBE `cruiselines` 0.0034780502319336
(159) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00039482116699219
(160) DESCRIBE `cruiselines` 0.0031139850616455
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0005030632019043