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

Total elapsed time: 0.21171641349792

# Query Time
(1) connect 0.00081586837768555
(2) DESCRIBE `specials` 0.005836009979248
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'circle-pacific-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0011839866638184
(4) DESCRIBE `cruises` 0.0036678314208984
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79643))) 0.00069999694824219
(6) DESCRIBE `avid_specials` 0.0016269683837891
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1490159 and class = 'Special') OR (item_id = 79643 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 40 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.0010941028594971
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1490159') 0.00030183792114258
(9) DESCRIBE `ships` 0.0031478404998779
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00037384033203125
(11) DESCRIBE `ships` 0.0029971599578857
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00034809112548828
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(15) DESCRIBE `itineraries` 0.0013060569763184
(16) DESCRIBE `ports` 0.001539945602417
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040507316589355
(18) DESCRIBE `ports` 0.0012829303741455
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029706954956055
(20) DESCRIBE `ports` 0.0013840198516846
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034093856811523
(22) DESCRIBE `specialsailingdates` 0.0014338493347168
(23) DESCRIBE `sailingdates` 0.0011940002441406
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493202))) 0.00033998489379883
(25) DESCRIBE `ports` 0.0013282299041748
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(27) DESCRIBE `ports` 0.0015230178833008
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029706954956055
(29) DESCRIBE `ports` 0.0015261173248291
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031185150146484
(31) DESCRIBE `ports` 0.0014269351959229
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00030398368835449
(33) DESCRIBE `ports` 0.0013101100921631
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00031900405883789
(35) DESCRIBE `ports` 0.0014529228210449
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00031399726867676
(37) DESCRIBE `ports` 0.001331090927124
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00030303001403809
(39) DESCRIBE `ports` 0.0014619827270508
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00034713745117188
(41) DESCRIBE `ports` 0.0015749931335449
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00022101402282715
(43) DESCRIBE `ports` 0.0014839172363281
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040197372436523
(45) DESCRIBE `ports` 0.001662015914917
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00038504600524902
(47) DESCRIBE `ports` 0.0015239715576172
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00030112266540527
(49) DESCRIBE `ports` 0.0013930797576904
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00044107437133789
(51) DESCRIBE `ports` 0.0019137859344482
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00031805038452148
(53) DESCRIBE `ports` 0.0015261173248291
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00034713745117188
(55) DESCRIBE `ports` 0.0014591217041016
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00032615661621094
(57) DESCRIBE `ports` 0.0014441013336182
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00034999847412109
(59) DESCRIBE `ports` 0.0014400482177734
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00032615661621094
(61) DESCRIBE `ports` 0.001471996307373
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00034093856811523
(63) DESCRIBE `ports` 0.0014240741729736
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00031685829162598
(65) DESCRIBE `ports` 0.0014059543609619
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00040793418884277
(67) DESCRIBE `ports` 0.0014560222625732
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00030016899108887
(69) DESCRIBE `ports` 0.0013930797576904
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00040197372436523
(71) DESCRIBE `ports` 0.0013811588287354
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00029706954956055
(73) DESCRIBE `ports` 0.0014259815216064
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00031018257141113
(75) DESCRIBE `ports` 0.0013699531555176
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00027012825012207
(77) DESCRIBE `ports` 0.001338005065918
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00029087066650391
(79) DESCRIBE `ports` 0.0013470649719238
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00038886070251465
(81) DESCRIBE `ports` 0.0013318061828613
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00029301643371582
(83) DESCRIBE `ports` 0.0012750625610352
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00029492378234863
(85) DESCRIBE `ports` 0.0015058517456055
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.0004580020904541
(87) DESCRIBE `ports` 0.0012950897216797
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00032901763916016
(89) DESCRIBE `ports` 0.0013930797576904
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00029397010803223
(91) DESCRIBE `ports` 0.0013980865478516
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00027799606323242
(93) DESCRIBE `ports` 0.0014469623565674
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00033903121948242
(95) DESCRIBE `ports` 0.001410961151123
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00046896934509277
(97) DESCRIBE `ports` 0.0014779567718506
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00032711029052734
(99) DESCRIBE `ports` 0.0013861656188965
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00032782554626465
(101) DESCRIBE `ports` 0.0014030933380127
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0003209114074707
(103) DESCRIBE `ports` 0.0014350414276123
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00029611587524414
(105) DESCRIBE `ports` 0.0013799667358398
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0003199577331543
(107) DESCRIBE `ports` 0.0014169216156006
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00030303001403809
(109) DESCRIBE `ports` 0.0014128684997559
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00033998489379883
(111) DESCRIBE `ports` 0.0014078617095947
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00012612342834473
(113) DESCRIBE `ports` 0.0014309883117676
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034999847412109
(115) DESCRIBE `ports` 0.001399040222168
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00034308433532715
(117) DESCRIBE `ports` 0.0013918876647949
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043201446533203
(119) DESCRIBE `ports` 0.0014300346374512
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00031208992004395
(121) DESCRIBE `ports` 0.0014820098876953
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0003960132598877
(123) DESCRIBE `ports` 0.0014169216156006
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00018787384033203
(125) DESCRIBE `ports` 0.0014400482177734
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00033116340637207
(127) DESCRIBE `ports` 0.0013968944549561
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030303001403809
(129) DESCRIBE `ports` 0.00140380859375
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00033211708068848
(131) DESCRIBE `ports` 0.0014388561248779
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00032520294189453
(133) DESCRIBE `ports` 0.0014457702636719
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00034308433532715
(135) DESCRIBE `ports` 0.0014069080352783
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00030708312988281
(137) DESCRIBE `ports` 0.0014009475708008
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00032615661621094
(139) DESCRIBE `ports` 0.0014050006866455
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00029611587524414
(141) DESCRIBE `ports` 0.0014579296112061
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00033903121948242
(143) DESCRIBE `ports` 0.0013799667358398
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00032496452331543
(145) DESCRIBE `ports` 0.0013880729675293
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00032401084899902
(147) DESCRIBE `ports` 0.0014801025390625
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00029802322387695
(149) DESCRIBE `ports` 0.0013828277587891
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00033092498779297
(151) DESCRIBE `ports` 0.0014019012451172
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00030708312988281
(153) DESCRIBE `ports` 0.0014028549194336
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00032997131347656
(155) DESCRIBE `ports` 0.0014188289642334
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00030899047851562
(157) DESCRIBE `ports` 0.0014359951019287
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00035214424133301
(159) DESCRIBE `ports` 0.0013980865478516
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00036311149597168
(161) DESCRIBE `ports` 0.0013880729675293
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00032687187194824
(163) DESCRIBE `ports` 0.0014619827270508
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00030398368835449
(165) DESCRIBE `ports` 0.0013899803161621
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00033187866210938
(167) DESCRIBE `ports` 0.0014050006866455
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00031900405883789
(169) DESCRIBE `ports` 0.0014550685882568
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00033402442932129
(171) DESCRIBE `ports` 0.0015809535980225
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00030899047851562
(173) DESCRIBE `ports` 0.001474142074585
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00032496452331543
(175) DESCRIBE `ports` 0.001417875289917
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00029993057250977
(177) DESCRIBE `ports` 0.001471996307373
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027585029602051
(179) DESCRIBE `ports` 0.0015320777893066
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031805038452148
(181) DESCRIBE `specialsmultipricing` 0.0018608570098877
(182) DESCRIBE `leadpricing` 0.0012550354003906
(183) DESCRIBE `specialspricing` 0.0014979839324951
(184) DESCRIBE `cabins` 0.0012698173522949
(185) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2655))) 0.00033712387084961
(186) DESCRIBE `currencies` 0.0011360645294189
(187) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00027585029602051
(188) DESCRIBE `cruiselines` 0.0017929077148438
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037503242492676
(190) DESCRIBE `orchid_image` 0.0014159679412842
(191) DESCRIBE `cruiselines` 0.0017449855804443
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028896331787109
(193) DESCRIBE `cruises` 0.0026149749755859
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79643') 0.00030612945556641
(195) DESCRIBE `deckplans` 0.0011820793151855
(196) DESCRIBE `cabins` 0.001492977142334
(197) DESCRIBE `shipphotos` 0.0012269020080566
(198) DESCRIBE `cruises` 0.0032229423522949
(199) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 48303, 45260, 71399, 71400, 11517, 56860, 56889, 67266, 67378)) ORDER BY FIND_IN_SET(id, '45259,48303,45260,71399,71400,11517,56860,56889,67266,67378') 0.0012581348419189
(200) DESCRIBE `cruiselines` 0.0020649433135986
(201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '218', '47', '264', '191', '33', '18', '14', '20', '23', '29', '24', '114', '8', '213', '4')) ORDER BY FIND_IN_SET(id, '120,212,218,47,264,191,33,18,14,20,23,29,24,114,8,213,4') 0.0013720989227295
(202) DESCRIBE `ships` 0.0027379989624023
(203) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '517', '1767', '1013', '701', '441', '163', '1205', '1032', '401', '1168', '1398', '1788', '66', '390', '451', '461', '683', '1303', '9', '10', '21', '22', '24', '25', '27', '105', '404', '439', '547', '582', '970', '1008', '1320', '1372', '1579', '1749', '1773', '1791', '3', '4', '11', '28', '74', '148', '160', '327', '332', '333', '335', '340', '626', '669', '678', '739', '792', '1073', '1243', '1262', '1302', '1347', '1385', '1539', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,517,1767,1013,701,441,163,1205,1032,401,1168,1398,1788,66,390,451,461,683,1303,9,10,21,22,24,25,27,105,404,439,547,582,970,1008,1320,1372,1579,1749,1773,1791,3,4,11,28,74,148,160,327,332,333,335,340,626,669,678,739,792,1073,1243,1262,1302,1347,1385,1539,1540,1569,1711') 0.0067188739776611
(204) DESCRIBE `cruisetypes` 0.0016229152679443
(205) DESCRIBE `destinations` 0.0018231868743896
(206) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '12', '8', '2', '53', '35', '9', '29', '40', '48', '55', '22', '26', '34', '7', '25', '30', '49', '56')) ORDER BY FIND_IN_SET(id, '54,39,43,12,8,2,53,35,9,29,40,48,55,22,26,34,7,25,30,49,56') 0.0014522075653076