or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

MSC Divina

MSC Cruises
MSC Divina

Look out for our new goddess of the seas, MSC Divina, the third ship in the Fantasia Class. Modelled on her sister-ships, MSC Splendida and MSC Fantasia, she features some remarkable enhancements.

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

Total elapsed time: 0.044953584671021

# Query Time
(1) connect 0.00078988075256348
(2) DESCRIBE `ships` 0.0033619403839111
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'msc-divina') LIMIT 1 0.0049970149993896
(4) DESCRIBE `avid_specials` 0.0015659332275391
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 977 AND class = 'Ship') OR (item_id = 19 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.0010559558868408
(6) DESCRIBE `cruiselines` 0.0020418167114258
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00033307075500488
(8) DESCRIBE `orchid_image` 0.0014748573303223
(9) DESCRIBE `cruiselines` 0.0017688274383545
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028109550476074
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00028204917907715
(12) DESCRIBE `deckplans` 0.0020320415496826
(13) DESCRIBE `cabins` 0.0013091564178467
(14) DESCRIBE `shipphotos` 0.0012178421020508
(15) DESCRIBE `cruises` 0.0038938522338867
(16) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73153, 73154, 77260, 69089, 77259, 77261, 77262, 77263, 45899, 69088)) ORDER BY FIND_IN_SET(id, '73153,73154,77260,69089,77259,77261,77262,77263,45899,69088') 0.0023751258850098
(17) DESCRIBE `cruiselines` 0.0029659271240234
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('19')) ORDER BY FIND_IN_SET(id, '19') 0.00055599212646484
(19) DESCRIBE `cruisetypes` 0.0014770030975342
(20) DESCRIBE `destinations` 0.002324104309082
(21) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '38', '9')) ORDER BY FIND_IN_SET(id, '22,12,38,9') 0.00085997581481934
(22) DESCRIBE `ships` 0.0035309791564941
(23) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00048089027404785
(24) DESCRIBE `ships` 0.0035030841827393
(25) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00047516822814941