or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Luftner Cruises
    Amadeus Silver II

    Amadeus Silver II

    The ‘AMADEUS Silver II’ is the second 135m vessel in the AMADEUS fleet and will continue the success of its sister vessel as well as...

    Star Rating River
  • Luftner Cruises
    Amadeus Silver III

    Amadeus Silver III

    With two 135m “SILVER” Line vessels already having been commissioned in the last three years, the AMADEUS SILVER III will be in operation from 2016....

    Star Rating River
  • Luftner Cruises
    Amadeus Symphony

    Amadeus Symphony

    AMADEUS SYMPHONY, a member of the prestigious Amadeus Premium fleet, ranks among the most beautiful passenger vessels plying Europe’s great rivers. Spacious cabins and suites...

    Star Rating River
  • AMA Waterways
    AmaDolce

    AmaDolce

    The AmaDolce made its debut in 2009. It features luxurious staterooms, most with French balconies, and includes spacious marble-appointed bathrooms, showers and multi-jet shower heads;...

    Star Rating River
  • APT
    AmaDolce

    AmaDolce

    MS AmaDolce is an Aria Class River Ship.

    Aria River Ships are among the finest river ships you’ll find not just in Europe, but anywhere in...

    Star Rating River
  • AMA Waterways
    AmaKristina

    AmaKristina

    The AmaKristina – set to debut in 2017 – is a sister ship to the AmaViola and features the most advanced design of any river...

    Star Rating River
  • APT
    AmaKristina

    AmaKristina

    Leading the way in luxury and comfort, our Concerto River Ships represent a revolution in ship design. They are the grandest ships on Europe’s rivers...

    Star Rating River
  • AMA Waterways
    AmaLea

    AmaLea

    The AmaLea – set to debut in 2018 – is a sister ship to the AmaKristina and features the most advanced design of any river...

    Star Rating River
  • AMA Waterways
    AmaLotus

    AmaLotus

    The 124-passenger AmaLotus features ultra-spacious 624-sq. ft. Suites; ten Jr. Suites at 290 sq. ft. and standard staterooms at 226 sq. ft., with 90 percent...

    Star Rating River
  • APT
    AmaLotus

    AmaLotus

    As part of our commitment to your unforgettable Mekong River cruise, we’ve improved our already luxurious RV AmaLotus with a stylish refurbishment launching in 2016....

    Star Rating River
 

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

Total elapsed time: 0.12161540985107

# Query Time
(1) connect 0.0004730224609375
(2) DESCRIBE `ships` 0.0016591548919678
(3) DESCRIBE `cruiselines` 0.0016069412231445
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00037884712219238
(5) DESCRIBE `orchid_image` 0.0010719299316406
(6) DESCRIBE `cruiselines` 0.0014710426330566
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00029897689819336
(8) DESCRIBE `ships` 0.0018990039825439
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1328') 0.00030207633972168
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020503997802734
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021696090698242
(12) DESCRIBE `avid_specials` 0.0010268688201904
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1328 AND class = 'Ship') OR (item_id = 140 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.0014801025390625
(14) DESCRIBE `cruiselines` 0.0011990070343018
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00025486946105957
(16) DESCRIBE `orchid_image` 0.00078105926513672
(17) DESCRIBE `cruiselines` 0.00093603134155273
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00021505355834961
(19) DESCRIBE `ships` 0.0013301372528076
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1393') 0.00029087066650391
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022006034851074
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015592575073242
(23) DESCRIBE `avid_specials` 0.00087404251098633
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1393 AND class = 'Ship') OR (item_id = 140 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.0010828971862793
(25) DESCRIBE `cruiselines` 0.0013289451599121
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00025391578674316
(27) DESCRIBE `orchid_image` 0.00080990791320801
(28) DESCRIBE `cruiselines` 0.0011329650878906
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00023794174194336
(30) DESCRIBE `ships` 0.001594066619873
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '623') 0.00022101402282715
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019383430480957
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018095970153809
(34) DESCRIBE `avid_specials` 0.00072789192199707
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 623 AND class = 'Ship') OR (item_id = 140 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.00130295753479
(36) DESCRIBE `cruiselines` 0.0011820793151855
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00031304359436035
(38) DESCRIBE `orchid_image` 0.00096797943115234
(39) DESCRIBE `cruiselines` 0.00090408325195312
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.0002138614654541
(41) DESCRIBE `ships` 0.0012249946594238
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '703') 0.00019216537475586
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016283988952637
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016689300537109
(45) DESCRIBE `avid_specials` 0.00060796737670898
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 703 AND class = 'Ship') OR (item_id = 131 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.00090885162353516
(47) DESCRIBE `cruiselines` 0.00095605850219727
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00035810470581055
(49) DESCRIBE `orchid_image` 0.0010709762573242
(50) DESCRIBE `cruiselines` 0.0013349056243896
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.0002751350402832
(52) DESCRIBE `ships` 0.0018069744110107
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '801') 0.0002448558807373
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017285346984863
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001518726348877
(56) DESCRIBE `avid_specials` 0.00066709518432617
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 801 AND class = 'Ship') OR (item_id = 181 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.00093388557434082
(58) DESCRIBE `cruiselines` 0.00111985206604
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00033092498779297
(60) DESCRIBE `orchid_image` 0.0011699199676514
(61) DESCRIBE `cruiselines` 0.0012578964233398
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00027990341186523
(63) DESCRIBE `ships` 0.001676082611084
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1426') 0.00022006034851074
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021004676818848
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019097328186035
(67) DESCRIBE `avid_specials` 0.00076603889465332
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1426 AND class = 'Ship') OR (item_id = 131 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.0013961791992188
(69) DESCRIBE `cruiselines` 0.0012600421905518
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003058910369873
(71) DESCRIBE `orchid_image` 0.00094890594482422
(72) DESCRIBE `cruiselines` 0.0013659000396729
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00029897689819336
(74) DESCRIBE `ships` 0.0017440319061279
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1480') 0.0003209114074707
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021696090698242
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019407272338867
(78) DESCRIBE `avid_specials` 0.00093984603881836
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480 AND class = 'Ship') OR (item_id = 181 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.0015301704406738
(80) DESCRIBE `cruiselines` 0.0014770030975342
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.0003349781036377
(82) DESCRIBE `orchid_image` 0.0010130405426025
(83) DESCRIBE `cruiselines` 0.0011970996856689
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00027322769165039
(85) DESCRIBE `ships` 0.0018129348754883
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1580') 0.00025200843811035
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020098686218262
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020408630371094
(89) DESCRIBE `avid_specials` 0.00083613395690918
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1580 AND class = 'Ship') OR (item_id = 131 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.0014448165893555
(91) DESCRIBE `cruiselines` 0.0012929439544678
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00027298927307129
(93) DESCRIBE `orchid_image` 0.0010111331939697
(94) DESCRIBE `cruiselines` 0.0012779235839844
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00025486946105957
(96) DESCRIBE `ships` 0.001859188079834
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '935') 0.00025010108947754
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019097328186035
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018191337585449
(100) DESCRIBE `avid_specials` 0.00077199935913086
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 935 AND class = 'Ship') OR (item_id = 131 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.0014278888702393
(102) DESCRIBE `cruiselines` 0.0012600421905518
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00029587745666504
(104) DESCRIBE `orchid_image` 0.0010161399841309
(105) DESCRIBE `cruiselines` 0.001331090927124
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00029087066650391
(107) DESCRIBE `ships` 0.0012519359588623
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1011') 0.00017499923706055
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015687942504883
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(111) DESCRIBE `avid_specials` 0.0005800724029541
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1011 AND class = 'Ship') OR (item_id = 181 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.0012931823730469
(113) DESCRIBE `cruises` 0.0017960071563721
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34157, 34171, 34192, 38802, 41031, 44275, 44276, 49176, 49177, 49599)) ORDER BY FIND_IN_SET(id, '34157,34171,34192,38802,41031,44275,44276,49176,49177,49599') 0.00072097778320312
(115) DESCRIBE `cruiselines` 0.0011799335479736
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '101', '120', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '229', '140', '170', '225', '275', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '188', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '224', '245', '177', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,101,120,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,229,140,170,225,275,59,108,115,113,180,73,269,264,240,88,219,276,57,52,188,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,224,245,177,257,210,223,263,251') 0.0029580593109131
(117) DESCRIBE `ships` 0.0018680095672607
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '10', '349', '974', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '817', '520', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '31', '573', '1285', '1586', '30', '36', '38', '39', '378', '434', '590', '792', '34', '35', '37', '1012', '327', '526', '970', '43', '1376', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1382', '1405', '338', '716', '1088', '1176', '1292', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '1575', '253', '857', '1149', '1236', '111', '285', '852', '966', '1095', '1284', '59', '93', '403', '451', '610', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '75', '616', '666', '784', '1150', '1301', '1501', '9', '996', '1587', '81', '455', '503', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1366', '1372', '1411', '1571', '108', '313', '776', '1141', '1241', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '823', '883', '1253', '74', '98', '147', '394', '937', '1579', '1172', '1454', '335', '938', '994', '1087', '66', '70', '341', '790', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1439', '715', '973', '1023', '1043', '1144', '1262', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1481', '1543', '1594', '448', '717', '1090', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1110', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811', '858', '888')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,10,349,974,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,817,520,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,31,573,1285,1586,30,36,38,39,378,434,590,792,34,35,37,1012,327,526,970,43,1376,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1382,1405,338,716,1088,1176,1292,1417,1569,1639,993,1455,314,678,722,837,1233,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,1575,253,857,1149,1236,111,285,852,966,1095,1284,59,93,403,451,610,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,75,616,666,784,1150,1301,1501,9,996,1587,81,455,503,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1366,1372,1411,1571,108,313,776,1141,1241,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,823,883,1253,74,98,147,394,937,1579,1172,1454,335,938,994,1087,66,70,341,790,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1439,715,973,1023,1043,1144,1262,1545,494,673,1136,1137,1240,1282,1303,1437,1481,1543,1594,448,717,1090,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1110,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,915,916,926,1001,1072,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811,858,888') 0.02371883392334
(119) DESCRIBE `cruisetypes` 0.0008699893951416
(120) DESCRIBE `destinations` 0.0013458728790283
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.0015289783477783