or, enquire about your chosen options

  1. Should I buy a beverage package?
  2. SPOTLIGHT ON: Viking Ocean and River Cruises
  3. Catch Up on Cruising: Latest News in bite size!
  4. Catch Up on Cruising: Latest News in bite size!
  5. REVIEW: P & O Australia’s Pacific Aria

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 Fantasia

MSC Cruises
MSC Fantasia

MSC Fantasia is the largest cruise ship ever built for a European ship owner. Greater in length than the height of the Eiffel Tower,she has 1,637 staterooms, 80% oceanview, many with private balconies. The flagship from MSC Cruises is a masterpiece of Italian style: a perfect mix of advanced technology, elegance and exclusive services.

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

Total elapsed time: 0.13480806350708

# Query Time
(1) connect 0.000701904296875
(2) DESCRIBE `ships` 0.0031430721282959
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'msc-fantasia') LIMIT 1 0.0055301189422607
(4) DESCRIBE `avid_specials` 0.0015561580657959
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 726 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.0011029243469238
(6) DESCRIBE `cruiselines` 0.0018630027770996
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034809112548828
(8) DESCRIBE `orchid_image` 0.001514196395874
(9) DESCRIBE `cruiselines` 0.0017838478088379
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00033116340637207
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00047183036804199
(12) DESCRIBE `deckplans` 0.0016570091247559
(13) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '726') ORDER BY `level` ASC 0.0045030117034912
(14) DESCRIBE `cabins` 0.001600980758667
(15) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '726') ORDER BY `cabin_order` ASC 0.056212902069092
(16) DESCRIBE `shipphotos` 0.0015571117401123
(17) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '726') 0.0011360645294189
(18) DESCRIBE `cruises` 0.0040488243103027
(19) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67997, 70257, 67999, 67998, 72121, 72124, 72125, 72126, 72127, 72129)) ORDER BY FIND_IN_SET(id, '67997,70257,67999,67998,72121,72124,72125,72126,72127,72129') 0.0015919208526611
(20) DESCRIBE `cruiselines` 0.0028200149536133
(21) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('19')) ORDER BY FIND_IN_SET(id, '19') 0.00051712989807129
(22) DESCRIBE `cruisetypes` 0.0011742115020752
(23) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.ship_id = '726') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.030495166778564
(24) DESCRIBE `destinations` 0.0019288063049316
(25) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '37', '38')) ORDER BY FIND_IN_SET(id, '22,37,38') 0.00063300132751465
(26) DESCRIBE `ships` 0.0025918483734131
(27) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00045084953308105
(28) DESCRIBE `ships` 0.0031559467315674
(29) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00038695335388184