or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Fantastic Fly/Cruise/Stay Packages with Blue Lagoon Cruises
  3. Catch up on Cruising: Latest news in bite size
  4. First Time Cruisers review of Carnival Spirit
  5. REVIEW: Norwegian Star – Greek Isles and Croatia Cruise

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

A-Rosa Aqua

A-Rosa Cruises
A-Rosa Aqua

The modern cruise ships of A-ROSA offer a lot of open space. At 125 to 135 metres, the ships spend space for various activities and a generous design of the public areas. The roomy cabins are air-conditioned, sometimes with French balcony, elegant and comfortably furnished.

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

# Query Time
(1) connect 0.00068998336791992
(2) DESCRIBE `ships` 0.0017919540405273
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'a-rosa-aqua') LIMIT 1 0.00064802169799805
(4) DESCRIBE `avid_specials` 0.00098991394042969
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1218 AND class = 'Ship') OR (item_id = 239 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.0020589828491211
(6) DESCRIBE `cruiselines` 0.0011100769042969
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00029301643371582
(8) DESCRIBE `orchid_image` 0.00086402893066406
(9) DESCRIBE `cruiselines` 0.0010299682617188
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00021600723266602
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1218') 0.00037908554077148
(12) DESCRIBE `deckplans` 0.0009911060333252
(13) DESCRIBE `cabins` 0.00075984001159668
(14) DESCRIBE `shipphotos` 0.00063991546630859
(15) DESCRIBE `cruises` 0.0019960403442383
(16) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73054, 66013)) ORDER BY FIND_IN_SET(id, '73054,66013') 0.00056695938110352
(17) DESCRIBE `cruiselines` 0.0010130405426025
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('239')) ORDER BY FIND_IN_SET(id, '239') 0.00026392936706543
(19) DESCRIBE `cruisetypes` 0.00055789947509766
(20) DESCRIBE `destinations` 0.00087714195251465
(21) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50') 0.00025701522827148
(22) DESCRIBE `ships` 0.0014078617095947
(23) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1218))) 0.00027084350585938
(24) DESCRIBE `ships` 0.0017020702362061
(25) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1218))) 0.00029683113098145