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

Your 'Cruise Ship' has been chosenClear this filter or visit another page to change

Sun Princess

Princess Cruises
Sun Princess

Sun Princess truly lights up the seas, serving up tantalizing cuisine, dazzling live entertainment and new experiences with our Discovery at SEA™ programs. Relax in The Sanctuary, a tranquil haven reserved for adults, or put your feet up at Movies Under the Stars®, whatever you decide to do, your time on board will be unforgettable.

Enquire about this cruise ship »

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

Total elapsed time: 0.096471548080444

# Query Time
(1) connect 0.0011661052703857
(2) DESCRIBE `ships` 0.0048332214355469
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'sun-princess') LIMIT 1 0.0033209323883057
(4) DESCRIBE `avid_specials` 0.002331018447876
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018179416656494
(6) DESCRIBE `cruiselines` 0.0027620792388916
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00082182884216309
(8) DESCRIBE `orchid_image` 0.0022051334381104
(9) DESCRIBE `cruiselines` 0.0030369758605957
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00054097175598145
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00039792060852051
(12) DESCRIBE `deckplans` 0.002000093460083
(13) DESCRIBE `cabins` 0.002094030380249
(14) DESCRIBE `shipphotos` 0.0021359920501709
(15) DESCRIBE `cruises` 0.0039379596710205
(16) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69340, 45723, 64098, 73423, 69346, 76322, 29569, 58280, 76227, 76228)) ORDER BY FIND_IN_SET(id, '69340,45723,64098,73423,69346,76322,29569,58280,76227,76228') 0.0018389225006104
(17) DESCRIBE `cruiselines` 0.0029909610748291
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23')) ORDER BY FIND_IN_SET(id, '23') 0.00064516067504883
(19) DESCRIBE `cruisetypes` 0.0022060871124268
(20) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.ship_id = '105') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.042001008987427
(21) DESCRIBE `destinations` 0.0029101371765137
(22) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35', '8', '40', '43')) ORDER BY FIND_IN_SET(id, '35,8,40,43') 0.0013191699981689
(23) DESCRIBE `ships` 0.0035698413848877
(24) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00049805641174316
(25) DESCRIBE `ships` 0.004450798034668
(26) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00063920021057129