or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  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

 
 
 
  • AMA Waterways
    AmaBella

    AmaBella

    The MS AmaBella offers the ultimate in custom-designed luxury. This 161-passenger vessel features a combination of amenities and design details never before seen on the...

    Star Rating River
  • APT
    AmaBella

    AmaBella

    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
    AmaCello

    AmaCello

    Decorated in a vibrant palette of gold and orange, the AmaCello debuted in 2008. Most staterooms feature French balconies and range in size from 170-255...

    Star Rating River
  • APT
    AmaCello

    AmaCello

    MS AmaCello 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
    AmaCerto

    AmaCerto

    Inspired by classic ocean yachts, the AmaCerto provides the most distinctive river cruise experience. A magnificent glass elevator is one of the unique design elements...

    Star Rating River
  • APT
    AmaCerto

    AmaCerto

    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
    AmaDante

    AmaDante

    The custom-designed AmaDante was introduced in 2008 and features spacious staterooms ranging in size from 170-255 sq. ft. most with French balconies. All staterooms include...

    Star Rating River
  • APT
    AmaDante

    AmaDante

    MS AmaDante 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
    AmaDara

    AmaDara

    The brand-new 124-passenger AmaDara (2015) features Luxury Suites (452 sq. ft.), Suites (334 sq. ft.) and spacious standard staterooms (226 sq. ft.), all of which...

    Star Rating River
  • APT
    AmaDara

    AmaDara

    The 124-passenger AmaDara (2015) features Luxury Suites (452 sq. ft.), Suites (334 sq. ft.) and spacious standard staterooms (226 sq. ft.), all of which have...

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

# Query Time
(1) connect 0.00049495697021484
(2) DESCRIBE `ships` 0.0019681453704834
(3) DESCRIBE `cruiselines` 0.0015480518341064
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00035786628723145
(5) DESCRIBE `orchid_image` 0.00093793869018555
(6) DESCRIBE `cruiselines` 0.0010490417480469
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00023198127746582
(8) DESCRIBE `ships` 0.001492977142334
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '960') 0.00023698806762695
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019717216491699
(12) DESCRIBE `avid_specials` 0.00073099136352539
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 960 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.0010790824890137
(14) DESCRIBE `cruiselines` 0.0013179779052734
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00029277801513672
(16) DESCRIBE `orchid_image` 0.00093817710876465
(17) DESCRIBE `cruiselines` 0.0011289119720459
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00024318695068359
(19) DESCRIBE `ships` 0.0015990734100342
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '808') 0.00029897689819336
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019097328186035
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022196769714355
(23) DESCRIBE `avid_specials` 0.0010819435119629
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 808 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.0017201900482178
(25) DESCRIBE `cruiselines` 0.001777172088623
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.0005030632019043
(27) DESCRIBE `orchid_image` 0.0013251304626465
(28) DESCRIBE `cruiselines` 0.0015659332275391
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00036883354187012
(30) DESCRIBE `ships` 0.0023910999298096
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '656') 0.00033688545227051
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002439022064209
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021886825561523
(34) DESCRIBE `avid_specials` 0.0010321140289307
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 656 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.0016469955444336
(36) DESCRIBE `cruiselines` 0.0015659332275391
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003509521484375
(38) DESCRIBE `orchid_image` 0.0013308525085449
(39) DESCRIBE `cruiselines` 0.0016639232635498
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00032401084899902
(41) DESCRIBE `ships` 0.002129077911377
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '798') 0.00030517578125
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002748966217041
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022101402282715
(45) DESCRIBE `avid_specials` 0.00099492073059082
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 798 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.0016942024230957
(47) DESCRIBE `cruiselines` 0.0015890598297119
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00036215782165527
(49) DESCRIBE `orchid_image` 0.0011849403381348
(50) DESCRIBE `cruiselines` 0.0015299320220947
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00029301643371582
(52) DESCRIBE `ships` 0.0021588802337646
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '958') 0.00036406517028809
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00053811073303223
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022411346435547
(56) DESCRIBE `avid_specials` 0.001054048538208
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 958 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.0016670227050781
(58) DESCRIBE `cruiselines` 0.0016598701477051
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00038480758666992
(60) DESCRIBE `orchid_image` 0.0013220310211182
(61) DESCRIBE `cruiselines` 0.0015549659729004
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00032591819763184
(63) DESCRIBE `ships` 0.0023608207702637
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '978') 0.00034809112548828
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022387504577637
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002140998840332
(67) DESCRIBE `avid_specials` 0.0010709762573242
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 978 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.0016539096832275
(69) DESCRIBE `cruiselines` 0.0016469955444336
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00038504600524902
(71) DESCRIBE `orchid_image` 0.0013220310211182
(72) DESCRIBE `cruiselines` 0.0015571117401123
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00032711029052734
(74) DESCRIBE `ships` 0.0015439987182617
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '663') 0.00022792816162109
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017595291137695
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020098686218262
(78) DESCRIBE `avid_specials` 0.00091004371643066
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 663 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.0017039775848389
(80) DESCRIBE `cruiselines` 0.001662015914917
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00038409233093262
(82) DESCRIBE `orchid_image` 0.001140832901001
(83) DESCRIBE `cruiselines` 0.0011138916015625
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00028300285339355
(85) DESCRIBE `ships` 0.0022149085998535
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '800') 0.00037407875061035
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023913383483887
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022101402282715
(89) DESCRIBE `avid_specials` 0.0010800361633301
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 800 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.001751184463501
(91) DESCRIBE `cruiselines` 0.00154709815979
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00041007995605469
(93) DESCRIBE `orchid_image` 0.0013010501861572
(94) DESCRIBE `cruiselines` 0.0015180110931396
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00030803680419922
(96) DESCRIBE `ships` 0.0024280548095703
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1289') 0.00042104721069336
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021791458129883
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020813941955566
(100) DESCRIBE `avid_specials` 0.0010299682617188
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1289 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.0017111301422119
(102) DESCRIBE `cruiselines` 0.0016810894012451
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00034213066101074
(104) DESCRIBE `orchid_image` 0.00098800659179688
(105) DESCRIBE `cruiselines` 0.0011389255523682
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00029802322387695
(107) DESCRIBE `ships` 0.0022778511047363
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1369') 0.0002741813659668
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022602081298828
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001981258392334
(111) DESCRIBE `avid_specials` 0.0010077953338623
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1369 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.0011610984802246
(113) DESCRIBE `cruises` 0.0025441646575928
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4424, 11517, 22963, 23463, 24582, 27114, 29015, 34157, 34171, 34192)) ORDER BY FIND_IN_SET(id, '4424,11517,22963,23463,24582,27114,29015,34157,34171,34192') 0.0012600421905518
(115) DESCRIBE `cruiselines` 0.0018339157104492
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '26', '19', '183', '77', '23', '7', '18', '20', '144', '8', '12', '171', '221', '120', '232', '101', '103', '96', '50', '208', '29', '37', '15', '206', '131', '91', '156', '204', '220', '33', '24', '28', '256', '36', '110', '114', '268', '258', '16', '191', '181', '187', '174', '195', '141', '211', '118', '47', '153', '14', '262', '30', '49', '216', '239', '35', '238', '151', '168', '196', '4', '146', '212', '249', '159', '115', '229', '136', '170', '225', '108', '209', '240', '140', '275', '59', '73', '180', '269', '88', '219', '276', '184', '248', '213', '52', '38', '182', '264', '132', '188', '90', '57', '113', '261', '244', '82', '95', '200', '230', '39', '231', '48', '62', '116', '236', '64', '266', '119', '235', '223', '177', '257', '263', '105', '245', '134', '224', '251')) ORDER BY FIND_IN_SET(id, '218,26,19,183,77,23,7,18,20,144,8,12,171,221,120,232,101,103,96,50,208,29,37,15,206,131,91,156,204,220,33,24,28,256,36,110,114,268,258,16,191,181,187,174,195,141,211,118,47,153,14,262,30,49,216,239,35,238,151,168,196,4,146,212,249,159,115,229,136,170,225,108,209,240,140,275,59,73,180,269,88,219,276,184,248,213,52,38,182,264,132,188,90,57,113,261,244,82,95,200,230,39,231,48,62,116,236,64,266,119,235,223,177,257,263,105,245,134,224,251') 0.0051350593566895
(117) DESCRIBE `ships` 0.0025639533996582
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '22', '461', '21', '27', '977', '258', '393', '207', '113', '1359', '517', '1272', '439', '974', '1135', '24', '855', '10', '797', '1460', '407', '349', '14', '1581', '1215', '1599', '726', '330', '1067', '25', '265', '731', '859', '770', '452', '739', '585', '780', '405', '520', '766', '462', '28', '542', '817', '1199', '1376', '1291', '792', '1205', '1415', '31', '1032', '30', '36', '38', '39', '378', '791', '34', '35', '37', '1012', '1323', '327', '573', '1285', '1588', '351', '590', '970', '1245', '434', '1348', '526', '454', '553', '1586', '43', '521', '1193', '1614', '1402', '986', '333', '404', '340', '580', '711', '11', '882', '78', '163', '716', '1405', '1176', '1417', '116', '1021', '338', '480', '325', '701', '837', '1382', '1134', '993', '4', '657', '610', '722', '732', '59', '286', '678', '1639', '1455', '82', '124', '765', '857', '683', '253', '503', '850', '1095', '1237', '1284', '1615', '406', '985', '1236', '84', '111', '547', '1168', '441', '1075', '114', '451', '852', '966', '160', '769', '988', '1449', '1501', '1008', '1319', '1373', '5', '45', '1243', '9', '81', '401', '1302', '1383', '1384', '1489', '1628', '639', '1088', '93', '784', '455', '854', '616', '749', '968', '1607', '314', '574', '1141', '1301', '1602', '212', '390', '483', '666', '1109', '75', '348', '885', '996', '1241', '1325', '1372', '1552', '1587', '324', '626', '748', '954', '1320', '1569', '285', '290', '658', '704', '776', '150', '508', '582', '3', '108', '313', '651', '851', '1411', '148', '291', '1027', '1087', '1292', '1574', '119', '669', '1068', '1398', '332', '403', '674', '1505', '652', '1253', '1571', '74', '151', '352', '1139', '1408', '147', '208', '223', '394', '467', '768', '1064', '1308', '1330', '70', '1486', '98', '335', '485', '883', '1413', '1454', '1612', '66', '69', '123', '937', '1260', '1611', '149', '341', '790', '1172', '1355', '262', '775', '938', '944', '1345', '152', '823', '874', '1108', '1145', '1159', '1579', '559', '1017', '1233', '1575', '375', '884', '958', '1157', '1183', '1184', '1326', '1327', '1461', '1613', '162', '665', '1195', '796', '1058', '1149', '105', '287', '738', '1106', '1189', '1224', '1439', '1632', '389', '1011', '1481', '448', '673', '1240', '1262', '1601', '479', '1013', '205', '751', '1410', '1412', '1471', '1526', '204', '715', '1063', '1082', '1132', '1223', '1303', '1492', '288', '635', '717', '1043', '1110', '1143', '1318', '1539', '1545', '1136', '1137', '1344', '1437', '1543', '1594', '1090', '1163', '1274', '1282', '1283', '1343', '1546', '1025', '1144', '1150', '1151', '1160', '1239', '1338', '1367', '1452', '1453', '417', '601', '905', '1322', '1604', '17', '201', '385', '386', '743', '795', '997', '1037', '1073', '1148', '1448', '266', '545', '618', '818', '821', '1217', '1231', '1358', '62', '1321', '1458', '1649', '225', '672', '692', '811', '1026', '1049', '1259', '1289', '1350', '1426', '1463', '1541', '421', '920', '927', '973', '1034', '1040', '1047', '1055', '1140', '1147', '1230', '1257', '1362', '1366', '1368', '1496', '1533', '1538', '1678', '211', '453', '931', '1003', '1004', '1054', '1146', '1154', '1354', '1389', '1508', '1516', '1518', '1558', '1609', '198', '422', '687', '695', '733', '858', '914', '921', '923', '930', '994', '995', '1002', '1019', '1042', '1051', '1152', '1226', '1261', '1351', '1407', '1509', '1521', '1532', '1540', '487', '627', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1470', '1559', '1561', '1593', '1596', '1650', '261', '703', '707', '785', '836', '924', '990', '1048', '1208', '1266', '1445', '1474', '1647', '1697', '420', '504', '671', '761', '798', '1020', '1045', '1092', '1580', '1629')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,22,461,21,27,977,258,393,207,113,1359,517,1272,439,974,1135,24,855,10,797,1460,407,349,14,1581,1215,1599,726,330,1067,25,265,731,859,770,452,739,585,780,405,520,766,462,28,542,817,1199,1376,1291,792,1205,1415,31,1032,30,36,38,39,378,791,34,35,37,1012,1323,327,573,1285,1588,351,590,970,1245,434,1348,526,454,553,1586,43,521,1193,1614,1402,986,333,404,340,580,711,11,882,78,163,716,1405,1176,1417,116,1021,338,480,325,701,837,1382,1134,993,4,657,610,722,732,59,286,678,1639,1455,82,124,765,857,683,253,503,850,1095,1237,1284,1615,406,985,1236,84,111,547,1168,441,1075,114,451,852,966,160,769,988,1449,1501,1008,1319,1373,5,45,1243,9,81,401,1302,1383,1384,1489,1628,639,1088,93,784,455,854,616,749,968,1607,314,574,1141,1301,1602,212,390,483,666,1109,75,348,885,996,1241,1325,1372,1552,1587,324,626,748,954,1320,1569,285,290,658,704,776,150,508,582,3,108,313,651,851,1411,148,291,1027,1087,1292,1574,119,669,1068,1398,332,403,674,1505,652,1253,1571,74,151,352,1139,1408,147,208,223,394,467,768,1064,1308,1330,70,1486,98,335,485,883,1413,1454,1612,66,69,123,937,1260,1611,149,341,790,1172,1355,262,775,938,944,1345,152,823,874,1108,1145,1159,1579,559,1017,1233,1575,375,884,958,1157,1183,1184,1326,1327,1461,1613,162,665,1195,796,1058,1149,105,287,738,1106,1189,1224,1439,1632,389,1011,1481,448,673,1240,1262,1601,479,1013,205,751,1410,1412,1471,1526,204,715,1063,1082,1132,1223,1303,1492,288,635,717,1043,1110,1143,1318,1539,1545,1136,1137,1344,1437,1543,1594,1090,1163,1274,1282,1283,1343,1546,1025,1144,1150,1151,1160,1239,1338,1367,1452,1453,417,601,905,1322,1604,17,201,385,386,743,795,997,1037,1073,1148,1448,266,545,618,818,821,1217,1231,1358,62,1321,1458,1649,225,672,692,811,1026,1049,1259,1289,1350,1426,1463,1541,421,920,927,973,1034,1040,1047,1055,1140,1147,1230,1257,1362,1366,1368,1496,1533,1538,1678,211,453,931,1003,1004,1054,1146,1154,1354,1389,1508,1516,1518,1558,1609,198,422,687,695,733,858,914,921,923,930,994,995,1002,1019,1042,1051,1152,1226,1261,1351,1407,1509,1521,1532,1540,487,627,663,915,916,926,1001,1072,1293,1404,1470,1559,1561,1593,1596,1650,261,703,707,785,836,924,990,1048,1208,1266,1445,1474,1647,1697,420,504,671,761,798,1020,1045,1092,1580,1629') 0.024518966674805
(119) DESCRIBE `cruisetypes` 0.001270055770874
(120) DESCRIBE `destinations` 0.001399040222168
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '2', '9', '43', '37', '8', '53', '55', '39', '28', '26', '44', '40', '38', '11', '21', '48', '7', '49', '52', '56', '10', '29', '46', '34', '30', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,2,9,43,37,8,53,55,39,28,26,44,40,38,11,21,48,7,49,52,56,10,29,46,34,30,45,32') 0.0014629364013672