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

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

# Query Time
(1) connect 0.0015478134155273
(2) DESCRIBE `specials` 0.020885944366455
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'circle-pacific-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0016889572143555
(4) DESCRIBE `cruises` 0.0075149536132812
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79643))) 0.0039761066436768
(6) DESCRIBE `avid_specials` 0.011162042617798
(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.0047500133514404
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1490159') 0.00094008445739746
(9) DESCRIBE `ships` 0.0048768520355225
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.0016391277313232
(11) DESCRIBE `ships` 0.013366222381592
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00046801567077637
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(15) DESCRIBE `itineraries` 0.0018870830535889
(16) DESCRIBE `ports` 0.016134977340698
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045299530029297
(18) DESCRIBE `ports` 0.010438919067383
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006561279296875
(20) DESCRIBE `ports` 0.0028769969940186
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049090385437012
(22) DESCRIBE `specialsailingdates` 0.0019409656524658
(23) DESCRIBE `sailingdates` 0.030184030532837
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493202))) 0.0060098171234131
(25) DESCRIBE `ports` 0.040208101272583
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053977966308594
(27) DESCRIBE `ports` 0.010957002639771
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061297416687012
(29) DESCRIBE `ports` 0.0023059844970703
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00063896179199219
(31) DESCRIBE `ports` 0.0038149356842041
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00076389312744141
(33) DESCRIBE `ports` 0.0024950504302979
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00045895576477051
(35) DESCRIBE `ports` 0.0027730464935303
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00048017501831055
(37) DESCRIBE `ports` 0.019913911819458
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00048184394836426
(39) DESCRIBE `ports` 0.0046141147613525
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.0005180835723877
(41) DESCRIBE `ports` 0.015168905258179
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00088405609130859
(43) DESCRIBE `ports` 0.012259960174561
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00057005882263184
(45) DESCRIBE `ports` 0.0042300224304199
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00058102607727051
(47) DESCRIBE `ports` 0.0054209232330322
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00060582160949707
(49) DESCRIBE `ports` 0.0022001266479492
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00043702125549316
(51) DESCRIBE `ports` 0.0017070770263672
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00039291381835938
(53) DESCRIBE `ports` 0.0015649795532227
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00040507316589355
(55) DESCRIBE `ports` 0.02354907989502
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00051784515380859
(57) DESCRIBE `ports` 0.0038669109344482
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00056600570678711
(59) DESCRIBE `ports` 0.0023348331451416
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.0013959407806396
(61) DESCRIBE `ports` 0.018840074539185
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.001816987991333
(63) DESCRIBE `ports` 0.011467218399048
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0025360584259033
(65) DESCRIBE `ports` 0.012359142303467
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00059413909912109
(67) DESCRIBE `ports` 0.035887956619263
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.0053329467773438
(69) DESCRIBE `ports` 0.0085530281066895
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00058698654174805
(71) DESCRIBE `ports` 0.0021531581878662
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00039982795715332
(73) DESCRIBE `ports` 0.0018270015716553
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00042915344238281
(75) DESCRIBE `ports` 0.024930953979492
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00058388710021973
(77) DESCRIBE `ports` 0.0022571086883545
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.0004570484161377
(79) DESCRIBE `ports` 0.0048661231994629
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.0004429817199707
(81) DESCRIBE `ports` 0.001945972442627
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00047993659973145
(83) DESCRIBE `ports` 0.0021188259124756
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00050497055053711
(85) DESCRIBE `ports` 0.0018889904022217
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00044608116149902
(87) DESCRIBE `ports` 0.0018670558929443
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00038790702819824
(89) DESCRIBE `ports` 0.001863956451416
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00048089027404785
(91) DESCRIBE `ports` 0.06088399887085
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00030517578125
(93) DESCRIBE `ports` 0.0024819374084473
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00032186508178711
(95) DESCRIBE `ports` 0.0018119812011719
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00034093856811523
(97) DESCRIBE `ports` 0.0017030239105225
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00038909912109375
(99) DESCRIBE `ports` 0.0016870498657227
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00038695335388184
(101) DESCRIBE `ports` 0.0016920566558838
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00036287307739258
(103) DESCRIBE `ports` 0.0018320083618164
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00034904479980469
(105) DESCRIBE `ports` 0.0021100044250488
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00043201446533203
(107) DESCRIBE `ports` 0.0023400783538818
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00046515464782715
(109) DESCRIBE `ports` 0.0020179748535156
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0004420280456543
(111) DESCRIBE `ports` 0.0019600391387939
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00037503242492676
(113) DESCRIBE `ports` 0.0048351287841797
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00052499771118164
(115) DESCRIBE `ports` 0.030606031417847
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00064396858215332
(117) DESCRIBE `ports` 0.010579109191895
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00089001655578613
(119) DESCRIBE `ports` 0.002377986907959
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00040912628173828
(121) DESCRIBE `ports` 0.002418041229248
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00041484832763672
(123) DESCRIBE `ports` 0.0023138523101807
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.0035359859466553
(125) DESCRIBE `ports` 0.010354995727539
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.003014087677002
(127) DESCRIBE `ports` 0.003593921661377
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00045084953308105
(129) DESCRIBE `ports` 0.0054960250854492
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0010697841644287
(131) DESCRIBE `ports` 0.0032260417938232
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00035500526428223
(133) DESCRIBE `ports` 0.0052080154418945
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0017468929290771
(135) DESCRIBE `ports` 0.013176918029785
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00044798851013184
(137) DESCRIBE `ports` 0.007533073425293
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0003659725189209
(139) DESCRIBE `ports` 0.0031208992004395
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00099897384643555
(141) DESCRIBE `ports` 0.0032238960266113
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00039815902709961
(143) DESCRIBE `ports` 0.0019481182098389
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00038695335388184
(145) DESCRIBE `ports` 0.0026509761810303
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00052714347839355
(147) DESCRIBE `ports` 0.0020439624786377
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.010272026062012
(149) DESCRIBE `ports` 0.0078930854797363
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00039100646972656
(151) DESCRIBE `ports` 0.0032179355621338
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00054502487182617
(153) DESCRIBE `ports` 0.0044710636138916
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00046491622924805
(155) DESCRIBE `ports` 0.0016899108886719
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00032901763916016
(157) DESCRIBE `ports` 0.0025880336761475
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00040388107299805
(159) DESCRIBE `ports` 0.0025029182434082
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.0004889965057373
(161) DESCRIBE `ports` 0.0059568881988525
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00040912628173828
(163) DESCRIBE `ports` 0.0064239501953125
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00091195106506348
(165) DESCRIBE `ports` 0.0047688484191895
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00059103965759277
(167) DESCRIBE `ports` 0.0038421154022217
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00045013427734375
(169) DESCRIBE `ports` 0.00174880027771
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00041484832763672
(171) DESCRIBE `ports` 0.0047481060028076
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.0051259994506836
(173) DESCRIBE `ports` 0.011018037796021
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00038790702819824
(175) DESCRIBE `ports` 0.01905083656311
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00048184394836426
(177) DESCRIBE `ports` 0.0018990039825439
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00048208236694336
(179) DESCRIBE `ports` 0.0030801296234131
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0013198852539062
(181) DESCRIBE `specialsmultipricing` 0.0045020580291748
(182) DESCRIBE `leadpricing` 0.0031979084014893
(183) DESCRIBE `specialspricing` 0.00547194480896
(184) DESCRIBE `cabins` 0.0019021034240723
(185) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2655))) 0.0004270076751709
(186) DESCRIBE `currencies` 0.0015039443969727
(187) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00035190582275391
(188) DESCRIBE `cruiselines` 0.0029611587524414
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0004122257232666
(190) DESCRIBE `orchid_image` 0.0019321441650391
(191) DESCRIBE `cruiselines` 0.0031499862670898
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0004429817199707
(193) DESCRIBE `cruises` 0.004176139831543
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79643') 0.00083398818969727
(195) DESCRIBE `deckplans` 0.0025029182434082
(196) DESCRIBE `cabins` 0.0025019645690918
(197) DESCRIBE `shipphotos` 0.0023729801177979
(198) DESCRIBE `cruises` 0.0040550231933594
(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.0021259784698486
(200) DESCRIBE `cruiselines` 0.0053229331970215
(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.0049331188201904
(202) DESCRIBE `ships` 0.0050160884857178
(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.0081980228424072
(204) DESCRIBE `cruisetypes` 0.0015709400177002
(205) DESCRIBE `destinations` 0.026819944381714
(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.0023059844970703