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

# Query Time
(1) connect 0.00050187110900879
(2) DESCRIBE `specials` 0.0023388862609863
(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.0008540153503418
(4) DESCRIBE `cruises` 0.001255989074707
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74790))) 0.00029110908508301
(6) DESCRIBE `avid_specials` 0.000640869140625
(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.0016717910766602
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1442170') 0.00028085708618164
(9) DESCRIBE `ships` 0.0021002292633057
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 888))) 0.00034308433532715
(11) DESCRIBE `ships` 0.0018560886383057
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '888') 0.00020408630371094
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017905235290527
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(15) DESCRIBE `itineraries` 0.00088405609130859
(16) DESCRIBE `ports` 0.0007178783416748
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00022506713867188
(18) DESCRIBE `ports` 0.00081396102905273
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00025606155395508
(20) DESCRIBE `ports` 0.00092196464538574
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00023818016052246
(22) DESCRIBE `specialsailingdates` 0.00079703330993652
(23) DESCRIBE `sailingdates` 0.00076389312744141
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 472038))) 0.00025796890258789
(25) DESCRIBE `ports` 0.00068283081054688
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00023603439331055
(27) DESCRIBE `ports` 0.00066518783569336
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019502639770508
(29) DESCRIBE `ports` 0.0009000301361084
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00025796890258789
(31) DESCRIBE `ports` 0.00090599060058594
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00021982192993164
(33) DESCRIBE `ports` 0.00096797943115234
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00025296211242676
(35) DESCRIBE `ports` 0.00071287155151367
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019097328186035
(37) DESCRIBE `ports` 0.00077199935913086
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00021100044250488
(39) DESCRIBE `ports` 0.00067305564880371
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.00017595291137695
(41) DESCRIBE `ports` 0.00072693824768066
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00026679039001465
(43) DESCRIBE `ports` 0.00088882446289062
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.00022006034851074
(45) DESCRIBE `ports` 0.00093603134155273
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00028204917907715
(47) DESCRIBE `ports` 0.00074100494384766
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0001828670501709
(49) DESCRIBE `ports` 0.00074601173400879
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019598007202148
(51) DESCRIBE `ports` 0.00072598457336426
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018000602722168
(53) DESCRIBE `ports` 0.00066494941711426
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019502639770508
(55) DESCRIBE `ports` 0.00066518783569336
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00017714500427246
(57) DESCRIBE `ports` 0.00069522857666016
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4277))) 0.00019598007202148
(59) DESCRIBE `ports` 0.00066709518432617
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4277') 0.00023603439331055
(61) DESCRIBE `ports` 0.00097107887268066
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026392936706543
(63) DESCRIBE `ports` 0.00086498260498047
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00022315979003906
(65) DESCRIBE `ports` 0.00088906288146973
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00024795532226562
(67) DESCRIBE `ports` 0.00090694427490234
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021791458129883
(69) DESCRIBE `ports` 0.00084900856018066
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00023102760314941
(71) DESCRIBE `ports` 0.00070095062255859
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00022602081298828
(73) DESCRIBE `specialsmultipricing` 0.00066709518432617
(74) DESCRIBE `leadpricing` 0.00062394142150879
(75) DESCRIBE `specials` 0.0022871494293213
(76) DESCRIBE `currencies` 0.00089406967163086
(77) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00026798248291016
(78) DESCRIBE `cruiselines` 0.00099802017211914
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00021481513977051
(80) DESCRIBE `orchid_image` 0.00078010559082031
(81) DESCRIBE `cruiselines` 0.0009300708770752
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00019693374633789
(83) DESCRIBE `cruises` 0.0016458034515381
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74790') 0.00024294853210449
(85) DESCRIBE `deckplans` 0.0009608268737793
(86) DESCRIBE `cabins` 0.0010008811950684
(87) DESCRIBE `shipphotos` 0.00089597702026367
(88) DESCRIBE `cruises` 0.0018119812011719
(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.00081682205200195
(90) DESCRIBE `cruiselines` 0.0010790824890137
(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.00080394744873047
(92) DESCRIBE `ships` 0.0013680458068848
(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.0022001266479492
(94) DESCRIBE `cruisetypes` 0.0010747909545898
(95) DESCRIBE `destinations` 0.00092101097106934
(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.00096297264099121