or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

Sign up to our newsletter and become the first to know about our latest deals and promotions

We'd love to hear from You

Please either call us toll-free on 0800 60 82 60 or complete your details below, let us know how we can be of help, and we'll be in touch.

You are enquiring about: A-Rosa Cruises

How would you prefer to be contacted?

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

Total elapsed time: 0.090780258178711

# Query Time
(1) connect 0.00048494338989258
(2) DESCRIBE `cruiselines` 0.0029549598693848
(3) SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'a-rosa-cruises') AND (orchid_available = 1) LIMIT 1 0.0014748573303223
(4) DESCRIBE `cruises` 0.0039699077606201
(5) SELECT `cruises`.* FROM `cruises` WHERE (id IN (23656, 34156, 34174, 34195, 40852, 41172, 44275, 44276, 49176, 49177)) ORDER BY FIND_IN_SET(id, '23656,34156,34174,34195,40852,41172,44275,44276,49176,49177') 0.0015451908111572
(6) DESCRIBE `cruiselines` 0.002924919128418
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '171', '23', '144', '18', '31', '20', '101', '8', '183', '96', '12', '120', '191', '50', '103', '221', '29', '15', '33', '131', '268', '37', '156', '28', '91', '262', '110', '114', '141', '208', '187', '153', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '4', '204', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '90', '264', '195', '216', '188', '182', '261', '136', '146', '159', '213', '237', '211', '115', '168', '196', '180', '73', '209', '57', '95', '248', '59', '219', '52', '184', '231', '170', '229', '225', '108', '88', '230', '276', '82', '244', '269', '105', '132', '275', '48', '119', '240', '116', '64', '266', '38', '134', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,171,23,144,18,31,20,101,8,183,96,12,120,191,50,103,221,29,15,33,131,268,37,156,28,91,262,110,114,141,208,187,153,14,232,24,118,49,181,258,151,36,212,30,206,140,4,204,256,238,249,220,16,239,47,174,113,35,90,264,195,216,188,182,261,136,146,159,213,237,211,115,168,196,180,73,209,57,95,248,59,219,52,184,231,170,229,225,108,88,230,276,82,244,269,105,132,275,48,119,240,116,64,266,38,134,224,210') 0.0073649883270264
(8) DESCRIBE `ships` 0.0041139125823975
(9) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '977', '1199', '1247', '1554', '1555', '1291', '1359', '1272', '1588', '1067', '1237', '1599', '407', '258', '1594', '27', '22', '21', '461', '37', '38', '28', '34', '378', '31', '393', '726', '817', '1424', '1135', '30', '349', '36', '39', '1012', '780', '1422', '1419', '1423', '1420', '1418', '1421', '35', '1415', '462', '113', '404', '452', '1677', '24', '766', '265', '1405', '11', '439', '1245', '711', '10', '330', '1215', '1574', '9', '585', '455', '542', '1141', '674', '124', '739', '770', '635', '1572', '1607', '5', '792', '207', '797', '1460', '3', '573', '974', '340', '553', '1454', '116', '520', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1302', '1284', '1471', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '582', '1323', '434', '1068', '1260', '421', '559', '993', '1259', '1575', '327', '590', '883', '1586', '81', '286', '970', '1678', '119', '406', '526', '678', '78', '854', '1571', '375', '616', '14', '454', '722', '850', '855', '1236', '1492', '547', '823', '1266', '1569', '114', '405', '1008', '1064', '1139', '1208', '1308', '84', '441', '403', '784', '732', '1319', '1330', '1348', '1437', '657', '966', '1088', '1108', '1282', '1587', '1672', '163', '348', '652', '1321', '111', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1159', '1243', '1376', '148', '351', '683', '1151', '1526', '314', '483', '1013', '1027', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '291', '335', '716', '743', '852', '1063', '1168', '1413', '149', '152', '610', '818', '884', '968', '1223', '1303', '1345', '1452', '1453', '1604', '1711', '401', '669', '769', '958', '1025', '1043', '1090', '1136', '1233', '1283', '1301', '1373', '1552', '45', '82', '150', '151', '352', '790', '796', '1145', '1241', '1581', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1226', '1448', '266', '1150', '1409', '1449', '1463', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1055', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '1049', '1470', '1474', '1580', '1627', '493', '618', '836', '1037', '1224', '1444', '423', '837', '1382', '1417', '1518', '1521', '1176', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1196', '1593', '709', '857', '1054', '1138', '1262', '1445', '1486', '1517', '1522', '1619', '671', '672', '717', '972', '1017', '1042', '1051', '1148', '1322', '1352', '1358', '1426', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '663', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1019', '1053', '1134', '1384', '1481', '313', '420', '1028', '1217', '1383', '1501', '1515', '1628', '1676', '453', '749', '937', '982', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1071', '1189', '1232', '1274', '1293', '1338', '1355', '1035', '1048', '1297', '1679', '1681', '1697', '70')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,977,1199,1247,1554,1555,1291,1359,1272,1588,1067,1237,1599,407,258,1594,27,22,21,461,37,38,28,34,378,31,393,726,817,1424,1135,30,349,36,39,1012,780,1422,1419,1423,1420,1418,1421,35,1415,462,113,404,452,1677,24,766,265,1405,11,439,1245,711,10,330,1215,1574,9,585,455,542,1141,674,124,739,770,635,1572,1607,5,792,207,797,1460,3,573,974,340,553,1454,116,520,25,1372,1455,160,1193,874,517,580,1021,1302,1284,1471,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,582,1323,434,1068,1260,421,559,993,1259,1575,327,590,883,1586,81,286,970,1678,119,406,526,678,78,854,1571,375,616,14,454,722,850,855,1236,1492,547,823,1266,1569,114,405,1008,1064,1139,1208,1308,84,441,403,784,732,1319,1330,1348,1437,657,966,1088,1108,1282,1587,1672,163,348,652,1321,111,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1159,1243,1376,148,351,683,1151,1526,314,483,1013,1027,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,673,768,1040,1137,1144,1157,1343,98,291,335,716,743,852,1063,1168,1413,149,152,610,818,884,968,1223,1303,1345,1452,1453,1604,1711,401,669,769,958,1025,1043,1090,1136,1233,1283,1301,1373,1552,45,82,150,151,352,790,796,1145,1241,1581,201,223,485,776,882,1160,1717,59,108,467,503,1152,1539,1738,324,341,639,905,988,1149,1226,1448,266,1150,1409,1449,1463,1540,417,871,885,1253,1411,1647,105,601,811,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1055,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,1049,1470,1474,1580,1627,493,618,836,1037,1224,1444,423,837,1382,1417,1518,1521,1176,1229,1404,1407,1410,1716,204,422,643,985,1196,1593,709,857,1054,1138,1262,1445,1486,1517,1522,1619,671,672,717,972,1017,1042,1051,1148,1322,1352,1358,1426,1713,1715,781,994,1175,1714,479,480,663,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1019,1053,1134,1384,1481,313,420,1028,1217,1383,1501,1515,1628,1676,453,749,937,982,1439,1461,1645,1708,1743,775,999,1052,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1071,1189,1232,1274,1293,1338,1355,1035,1048,1297,1679,1681,1697,70') 0.059174776077271
(10) DESCRIBE `cruisetypes` 0.0017709732055664
(11) DESCRIBE `destinations` 0.0024309158325195
(12) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '40', '26', '38', '11', '7', '30', '48', '21', '49', '45', '44', '56', '29', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,39,55,28,40,26,38,11,7,30,48,21,49,45,44,56,29,34,10,52,46,32') 0.0025699138641357