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

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

Astor

Cruise and Maritime Voyages
Astor

ASTOR is a stylish fully stabilised and air-conditioned cruise liner with capacity for 620 guests. She has seven passenger decks. Her wide range of public facilities include the very impressive Waldorf Restaurant offering a traditional two sitting fixed time dining option and, as an alternative more informal experience, the stylish Übersee Club Bistro.

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

# Query Time
(1) connect 0.00060606002807617
(2) DESCRIBE `ships` 0.0024709701538086
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'astor') LIMIT 1 0.0030901432037354
(4) DESCRIBE `avid_specials` 0.001107931137085
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1106 AND class = 'Ship') OR (item_id = 187 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.001025915145874
(6) DESCRIBE `cruiselines` 0.0010900497436523
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00024890899658203
(8) DESCRIBE `orchid_image` 0.00075912475585938
(9) DESCRIBE `cruiselines` 0.000946044921875
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00020194053649902
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1106') 0.00019693374633789
(12) DESCRIBE `deckplans` 0.0013689994812012
(13) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '1106') ORDER BY `level` ASC 0.0032260417938232
(14) DESCRIBE `cabins` 0.00075602531433105
(15) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '1106') ORDER BY `cabin_order` ASC 0.022289991378784
(16) DESCRIBE `shipphotos` 0.0011780261993408
(17) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '1106') 0.00098299980163574
(18) DESCRIBE `cruises` 0.0021209716796875
(19) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72468, 72486, 72487, 72488, 72489, 72490, 72491, 72492, 72493, 72494)) ORDER BY FIND_IN_SET(id, '72468,72486,72487,72488,72489,72490,72491,72492,72493,72494') 0.0011420249938965
(20) DESCRIBE `cruiselines` 0.0012810230255127
(21) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('187')) ORDER BY FIND_IN_SET(id, '187') 0.00031614303588867
(22) DESCRIBE `cruisetypes` 0.00068187713623047
(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 = '1106') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.027196884155273
(24) DESCRIBE `destinations` 0.0011539459228516
(25) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '40', '35')) ORDER BY FIND_IN_SET(id, '8,40,35') 0.0004119873046875
(26) DESCRIBE `ships` 0.0013530254364014
(27) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1106))) 0.00026798248291016
(28) DESCRIBE `ships` 0.0014698505401611
(29) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1106))) 0.00027918815612793