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

Avalon Panorama

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

Total elapsed time: 0.07145619392395

# Query Time
(1) connect 0.00055313110351562
(2) DESCRIBE `specials` 0.0035359859466553
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'active-discovery-on-the-danube-2-400-air-credit-per-couple') AND (orchid_available = 1) LIMIT 1 0.00098395347595215
(4) DESCRIBE `cruises` 0.0016679763793945
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74790))) 0.00033092498779297
(6) DESCRIBE `avid_specials` 0.00066280364990234
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1442170 and class = 'Special') OR (item_id = 74790 and class = 'Cruise') OR (item_id = 888 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 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.0009617805480957
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1442170') 0.00020599365234375
(9) DESCRIBE `ships` 0.0017390251159668
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 888))) 0.00030207633972168
(11) DESCRIBE `ships` 0.0015478134155273
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '888') 0.00024604797363281
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002129077911377
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017595291137695
(15) DESCRIBE `itineraries` 0.00081491470336914
(16) DESCRIBE `ports` 0.00083279609680176
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0002439022064209
(18) DESCRIBE `ports` 0.00076198577880859
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00022983551025391
(20) DESCRIBE `ports` 0.0006718635559082
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00018501281738281
(22) DESCRIBE `specialsailingdates` 0.00058698654174805
(23) DESCRIBE `sailingdates` 0.00064396858215332
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 472038))) 0.00022292137145996
(25) DESCRIBE `ports` 0.00067591667175293
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00025415420532227
(27) DESCRIBE `ports` 0.00066685676574707
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00018310546875
(29) DESCRIBE `ports` 0.00065803527832031
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00020694732666016
(31) DESCRIBE `ports` 0.00068402290344238
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00018000602722168
(33) DESCRIBE `ports` 0.00065517425537109
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00019288063049316
(35) DESCRIBE `ports` 0.00065398216247559
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00018715858459473
(37) DESCRIBE `ports` 0.00096702575683594
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00026392936706543
(39) DESCRIBE `ports` 0.00096297264099121
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.00023198127746582
(41) DESCRIBE `ports` 0.0010249614715576
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00025796890258789
(43) DESCRIBE `ports` 0.00097799301147461
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.00023603439331055
(45) DESCRIBE `ports` 0.0010700225830078
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00026488304138184
(47) DESCRIBE `ports` 0.00096893310546875
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023102760314941
(49) DESCRIBE `ports` 0.0010001659393311
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00025796890258789
(51) DESCRIBE `ports` 0.00095486640930176
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023698806762695
(53) DESCRIBE `ports` 0.00099992752075195
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00028300285339355
(55) DESCRIBE `ports` 0.001060962677002
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00024318695068359
(57) DESCRIBE `ports` 0.00094699859619141
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4277))) 0.00026178359985352
(59) DESCRIBE `ports` 0.00097799301147461
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4277') 0.00022983551025391
(61) DESCRIBE `ports` 0.00098800659179688
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026583671569824
(63) DESCRIBE `ports` 0.0009920597076416
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00024104118347168
(65) DESCRIBE `ports` 0.00097799301147461
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0002589225769043
(67) DESCRIBE `ports` 0.00099611282348633
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021505355834961
(69) DESCRIBE `ports` 0.00096607208251953
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0002589225769043
(71) DESCRIBE `ports` 0.00088381767272949
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021219253540039
(73) DESCRIBE `specialsmultipricing` 0.00091099739074707
(74) DESCRIBE `leadpricing` 0.00087094306945801
(75) DESCRIBE `specials` 0.0026290416717529
(76) DESCRIBE `currencies` 0.00080013275146484
(77) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00026512145996094
(78) DESCRIBE `cruiselines` 0.0013778209686279
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00026297569274902
(80) DESCRIBE `orchid_image` 0.0010290145874023
(81) DESCRIBE `cruiselines` 0.0013480186462402
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00029206275939941
(83) DESCRIBE `cruises` 0.001823902130127
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74790') 0.0002739429473877
(85) DESCRIBE `deckplans` 0.00091409683227539
(86) DESCRIBE `cabins` 0.00097298622131348
(87) DESCRIBE `shipphotos` 0.00088095664978027
(88) DESCRIBE `cruises` 0.0018289089202881
(89) 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.00076985359191895
(90) DESCRIBE `cruiselines` 0.0010719299316406
(91) 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.00075101852416992
(92) DESCRIBE `ships` 0.0013248920440674
(93) 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.002514123916626
(94) DESCRIBE `cruisetypes` 0.00096797943115234
(95) DESCRIBE `destinations` 0.00092911720275879
(96) 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.00096011161804199