or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

Sign up to our newsletter and become the first to know about our latest deals and promotions

Sapphire Princess

Sapphire Princess

Calypso Pool

Sapphire Princess

Grand Casino

Sapphire Princess

Churchill Lounge

Sapphire Princess

Club Fusion

Sapphire Princess

International Dining Room

Sapphire Princess

Sabatini's

Sapphire Princess

Santa Fe Dining Room

Sapphire Princess

Skywalkers Nightclub

Sapphire 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: 88

Total elapsed time: 0.056127309799194

# Query Time
(1) connect 0.0004279613494873
(2) DESCRIBE `specials` 0.0021960735321045
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'spotlight-on-asia-malaysia-thailand-vietnam-grand-adventure') AND (orchid_available = 1) LIMIT 1 0.0011069774627686
(4) DESCRIBE `cruises` 0.001338005065918
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 70013))) 0.00053501129150391
(6) DESCRIBE `avid_specials` 0.00063490867614746
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1431423 and class = 'Special') OR (item_id = 70013 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0018048286437988
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1431423') 0.00021100044250488
(9) DESCRIBE `ships` 0.0013320446014404
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00025606155395508
(11) DESCRIBE `ships` 0.0012869834899902
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00023603439331055
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023293495178223
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022697448730469
(15) DESCRIBE `itineraries` 0.0009920597076416
(16) DESCRIBE `ports` 0.00071406364440918
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022411346435547
(18) DESCRIBE `ports` 0.0006711483001709
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019502639770508
(20) DESCRIBE `ports` 0.0006721019744873
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018501281738281
(22) DESCRIBE `specialsailingdates` 0.00057601928710938
(23) DESCRIBE `sailingdates` 0.00063610076904297
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 439426))) 0.00034499168395996
(25) DESCRIBE `ports` 0.00071310997009277
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020503997802734
(27) DESCRIBE `ports` 0.00066685676574707
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023007392883301
(29) DESCRIBE `ports` 0.00065803527832031
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00019383430480957
(31) DESCRIBE `ports` 0.00065708160400391
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.0001978874206543
(33) DESCRIBE `ports` 0.00065922737121582
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.0001981258392334
(35) DESCRIBE `ports` 0.00066709518432617
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00017285346984863
(37) DESCRIBE `ports` 0.00064897537231445
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020790100097656
(39) DESCRIBE `ports` 0.00067496299743652
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017499923706055
(41) DESCRIBE `ports` 0.00065398216247559
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 444))) 0.00019478797912598
(43) DESCRIBE `ports` 0.00072693824768066
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '444') 0.00017595291137695
(45) DESCRIBE `ports` 0.00071310997009277
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00020289421081543
(47) DESCRIBE `ports` 0.00066399574279785
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00017595291137695
(49) DESCRIBE `ports` 0.00077009201049805
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00020003318786621
(51) DESCRIBE `ports` 0.00067496299743652
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00020098686218262
(53) DESCRIBE `ports` 0.00072288513183594
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00022196769714355
(55) DESCRIBE `ports` 0.00076103210449219
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00018000602722168
(57) DESCRIBE `ports` 0.00065994262695312
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00019598007202148
(59) DESCRIBE `ports` 0.00070309638977051
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00019502639770508
(61) DESCRIBE `ports` 0.00066804885864258
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019979476928711
(63) DESCRIBE `ports` 0.00065898895263672
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017595291137695
(65) DESCRIBE `specialsmultipricing` 0.00066113471984863
(66) DESCRIBE `leadpricing` 0.00061917304992676
(67) DESCRIBE `specials` 0.0018908977508545
(68) DESCRIBE `currencies` 0.00058197975158691
(69) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00019001960754395
(70) DESCRIBE `cruiselines` 0.0009300708770752
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021696090698242
(72) DESCRIBE `orchid_image` 0.00074195861816406
(73) DESCRIBE `cruiselines` 0.00092387199401855
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018191337585449
(75) DESCRIBE `cruises` 0.0011918544769287
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70013') 0.00021696090698242
(77) DESCRIBE `deckplans` 0.00076484680175781
(78) DESCRIBE `cabins` 0.00078797340393066
(79) DESCRIBE `shipphotos` 0.00064802169799805
(80) DESCRIBE `cruises` 0.0016350746154785
(81) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66959, 11517, 45259, 69465, 66859, 66414, 67892, 69524, 66478, 66529)) ORDER BY FIND_IN_SET(id, '66959,11517,45259,69465,66859,66414,67892,69524,66478,66529') 0.0014379024505615
(82) DESCRIBE `cruiselines` 0.0010378360748291
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('47', '33', '101', '19', '18', '8', '15', '218', '23', '151', '114', '20', '24', '120', '212', '30', '180', '262')) ORDER BY FIND_IN_SET(id, '47,33,101,19,18,8,15,218,23,151,114,20,24,120,212,30,180,262') 0.00070595741271973
(84) DESCRIBE `ships` 0.0014879703521729
(85) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '160', '1359', '1139', '888', '1266', '78', '1282', '683', '780', '1237', '406', '521', '616', '1029', '1303', '1672', '1676', '45', '258', '313', '404', '585', '669', '973', '1163', '5', '74', '98', '150', '163', '335', '349', '441', '580', '582', '652', '678', '722', '766', '769', '795', '968', '977', '1013', '1088', '1159', '1262', '1302', '1492', '1539', '1587', '1673', '1674')) ORDER BY FIND_IN_SET(id, '517,160,1359,1139,888,1266,78,1282,683,780,1237,406,521,616,1029,1303,1672,1676,45,258,313,404,585,669,973,1163,5,74,98,150,163,335,349,441,580,582,652,678,722,766,769,795,968,977,1013,1088,1159,1262,1302,1492,1539,1587,1673,1674') 0.0021591186523438
(86) DESCRIBE `cruisetypes` 0.00069403648376465
(87) DESCRIBE `destinations` 0.00089001655578613
(88) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '50', '35', '54', '48', '11', '29', '12', '26', '28', '39', '49', '2', '21', '25', '37', '40', '8', '38', '53')) ORDER BY FIND_IN_SET(id, '22,43,50,35,54,48,11,29,12,26,28,39,49,2,21,25,37,40,8,38,53') 0.00087285041809082