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

Sun Princess

Sun Princess

Atrium

Sun Princess

International Cafe

Sun Princess

Kai Sushi

Sun Princess

Salon

Sun Princess

Princess Theatre

Sun Princess

Riviera Deck

Sun Princess

Sterling Steakhouse

Sun Princess

Wheelhouse Bar

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.2244086265564

# Query Time
(1) connect 0.00072097778320312
(2) DESCRIBE `specials` 0.0053060054779053
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'circle-pacific-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0010268688201904
(4) DESCRIBE `cruises` 0.0030689239501953
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79643))) 0.00073409080505371
(6) DESCRIBE `avid_specials` 0.0016589164733887
(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.0016779899597168
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1490159') 0.00035810470581055
(9) DESCRIBE `ships` 0.0031788349151611
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00041818618774414
(11) DESCRIBE `ships` 0.0033111572265625
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00041985511779785
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(15) DESCRIBE `itineraries` 0.0018200874328613
(16) DESCRIBE `ports` 0.0019190311431885
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046181678771973
(18) DESCRIBE `ports` 0.001863956451416
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039792060852051
(20) DESCRIBE `ports` 0.0019228458404541
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037598609924316
(22) DESCRIBE `specialsailingdates` 0.0014259815216064
(23) DESCRIBE `sailingdates` 0.0015480518341064
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493202))) 0.00042390823364258
(25) DESCRIBE `ports` 0.0017719268798828
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(27) DESCRIBE `ports` 0.0017349720001221
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036001205444336
(29) DESCRIBE `ports` 0.0017738342285156
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040793418884277
(31) DESCRIBE `ports` 0.0019209384918213
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034999847412109
(33) DESCRIBE `ports` 0.0017499923706055
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00037598609924316
(35) DESCRIBE `ports` 0.0017340183258057
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00038814544677734
(37) DESCRIBE `ports` 0.0017790794372559
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00041604042053223
(39) DESCRIBE `ports` 0.0018208026885986
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00040102005004883
(41) DESCRIBE `ports` 0.0018401145935059
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00048208236694336
(43) DESCRIBE `ports` 0.0018539428710938
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00036120414733887
(45) DESCRIBE `ports` 0.0017821788787842
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00045180320739746
(47) DESCRIBE `ports` 0.0017919540405273
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00043511390686035
(49) DESCRIBE `ports` 0.0017590522766113
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00039815902709961
(51) DESCRIBE `ports` 0.0017910003662109
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00036883354187012
(53) DESCRIBE `ports` 0.0019879341125488
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00041580200195312
(55) DESCRIBE `ports` 0.0017778873443604
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00036287307739258
(57) DESCRIBE `ports` 0.0019409656524658
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00045299530029297
(59) DESCRIBE `ports` 0.0018069744110107
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00036001205444336
(61) DESCRIBE `ports` 0.0014359951019287
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00031089782714844
(63) DESCRIBE `ports` 0.0013890266418457
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00046396255493164
(65) DESCRIBE `ports` 0.0013420581817627
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00029611587524414
(67) DESCRIBE `ports` 0.0013201236724854
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00027084350585938
(69) DESCRIBE `ports` 0.0014469623565674
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00037097930908203
(71) DESCRIBE `ports` 0.0014200210571289
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00030016899108887
(73) DESCRIBE `ports` 0.0013089179992676
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00028300285339355
(75) DESCRIBE `ports` 0.0012600421905518
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00028491020202637
(77) DESCRIBE `ports` 0.001399040222168
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00030517578125
(79) DESCRIBE `ports` 0.0012650489807129
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00025796890258789
(81) DESCRIBE `ports` 0.0016200542449951
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00035595893859863
(83) DESCRIBE `ports` 0.0015809535980225
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00032806396484375
(85) DESCRIBE `ports` 0.0012619495391846
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00030994415283203
(87) DESCRIBE `ports` 0.0012710094451904
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00028300285339355
(89) DESCRIBE `ports` 0.0012350082397461
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00029897689819336
(91) DESCRIBE `ports` 0.001370906829834
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00031208992004395
(93) DESCRIBE `ports` 0.0013620853424072
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00034379959106445
(95) DESCRIBE `ports` 0.0012550354003906
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.0002751350402832
(97) DESCRIBE `ports` 0.0014259815216064
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00037884712219238
(99) DESCRIBE `ports` 0.0014128684997559
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00032615661621094
(101) DESCRIBE `ports` 0.0015559196472168
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00033402442932129
(103) DESCRIBE `ports` 0.0013182163238525
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00034189224243164
(105) DESCRIBE `ports` 0.0012350082397461
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00029110908508301
(107) DESCRIBE `ports` 0.001237154006958
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00027704238891602
(109) DESCRIBE `ports` 0.0015990734100342
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00030994415283203
(111) DESCRIBE `ports` 0.0016670227050781
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00039315223693848
(113) DESCRIBE `ports` 0.0018081665039062
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00044894218444824
(115) DESCRIBE `ports` 0.0014369487762451
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00031185150146484
(117) DESCRIBE `ports` 0.0012760162353516
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0003821849822998
(119) DESCRIBE `ports` 0.0013909339904785
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00038790702819824
(121) DESCRIBE `ports` 0.0017910003662109
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00037217140197754
(123) DESCRIBE `ports` 0.0012459754943848
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00027704238891602
(125) DESCRIBE `ports` 0.0012390613555908
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00030779838562012
(127) DESCRIBE `ports` 0.0015649795532227
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00031399726867676
(129) DESCRIBE `ports` 0.0015909671783447
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00032496452331543
(131) DESCRIBE `ports` 0.0015640258789062
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00033688545227051
(133) DESCRIBE `ports` 0.0016310214996338
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00034904479980469
(135) DESCRIBE `ports` 0.0015380382537842
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00040006637573242
(137) DESCRIBE `ports` 0.0016560554504395
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00034403800964355
(139) DESCRIBE `ports` 0.0014328956604004
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00028300285339355
(141) DESCRIBE `ports` 0.0013129711151123
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00031208992004395
(143) DESCRIBE `ports` 0.0012381076812744
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00030398368835449
(145) DESCRIBE `ports` 0.0013120174407959
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00031805038452148
(147) DESCRIBE `ports` 0.0013048648834229
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00032997131347656
(149) DESCRIBE `ports` 0.0012569427490234
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00029611587524414
(151) DESCRIBE `ports` 0.0012381076812744
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00029706954956055
(153) DESCRIBE `ports` 0.001338005065918
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00033187866210938
(155) DESCRIBE `ports` 0.0012998580932617
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00032687187194824
(157) DESCRIBE `ports` 0.0016558170318604
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.0003509521484375
(159) DESCRIBE `ports` 0.0018649101257324
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00029802322387695
(161) DESCRIBE `ports` 0.0013768672943115
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00031280517578125
(163) DESCRIBE `ports` 0.0013329982757568
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00027799606323242
(165) DESCRIBE `ports` 0.0012941360473633
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00030684471130371
(167) DESCRIBE `ports` 0.0016651153564453
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00029110908508301
(169) DESCRIBE `ports` 0.0013630390167236
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00030398368835449
(171) DESCRIBE `ports` 0.0013108253479004
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00027608871459961
(173) DESCRIBE `ports` 0.00130295753479
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00028491020202637
(175) DESCRIBE `ports` 0.0013861656188965
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00026798248291016
(177) DESCRIBE `ports` 0.001349925994873
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031208992004395
(179) DESCRIBE `ports` 0.0014700889587402
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034499168395996
(181) DESCRIBE `specialsmultipricing` 0.0013799667358398
(182) DESCRIBE `leadpricing` 0.001349925994873
(183) DESCRIBE `specialspricing` 0.0012028217315674
(184) DESCRIBE `cabins` 0.0015139579772949
(185) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2655))) 0.00034093856811523
(186) DESCRIBE `currencies` 0.0012180805206299
(187) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00033903121948242
(188) DESCRIBE `cruiselines` 0.0018880367279053
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00032496452331543
(190) DESCRIBE `orchid_image` 0.0016679763793945
(191) DESCRIBE `cruiselines` 0.0023260116577148
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00042915344238281
(193) DESCRIBE `cruises` 0.0032069683074951
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79643') 0.00044703483581543
(195) DESCRIBE `deckplans` 0.0014779567718506
(196) DESCRIBE `cabins` 0.0012869834899902
(197) DESCRIBE `shipphotos` 0.001615047454834
(198) DESCRIBE `cruises` 0.003741979598999
(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.001478910446167
(200) DESCRIBE `cruiselines` 0.0020530223846436
(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.0014259815216064
(202) DESCRIBE `ships` 0.0027880668640137
(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.0060827732086182
(204) DESCRIBE `cruisetypes` 0.0018980503082275
(205) DESCRIBE `destinations` 0.0023648738861084
(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.0018720626831055