or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • APT
    AmaReina

    AmaReina

    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
    AmaReina

    AmaReina

    This 164-passenger vessel boasts spacious staterooms with our exclusive Twin Balconies, a choice of dining venues, a heated pool with swim-up bar, in-room Internet access...

    Star Rating River
  • European Waterways
    Amaryllis

    Amaryllis

    The eight passenger ultra deluxe Amaryllis is a 40 meter Dutch hull, vintage 1962, and sister ship to Fleur de Lys. She was converted into...

    Star Rating River
  • AMA Waterways
    AmaSerena

    AmaSerena

    The AmaSerena is a sister ship to the AmaPrima and features the most advanced design of any river cruise vessel currently in operation. Our exclusive...

    Star Rating River
  • APT
    AmaSerena

    AmaSerena

    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
    AmaSiena

    AmaSiena

    Sister ship to the award-winning AmaKristina, the elegant 156-passenger AmaSiena is a warm, inviting ship offering plenty of space for guests to unwind. From comfortable...

    Star Rating River
  • AMA Waterways
    AmaSonata

    AmaSonata

    This 164-passenger vessel boasts spacious staterooms with our exclusive Twin Balconies, a choice of dining venues, a heated pool with swim-up bar, in-room Internet access...

    Star Rating River
  • APT
    AmaSonata

    AmaSonata

    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
  • APT
    AmaStella

    AmaStella

    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
    AmaStella

    AmaStella

    The AmaStella – is a sister ship to the AmaSerena and features the most advanced design of any river cruise vessel currently in operation. Our...

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

# Query Time
(1) connect 0.000762939453125
(2) DESCRIBE `ships` 0.0044970512390137
(3) DESCRIBE `cruiselines` 0.0018279552459717
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00060200691223145
(5) DESCRIBE `orchid_image` 0.0016360282897949
(6) DESCRIBE `cruiselines` 0.0018670558929443
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00016403198242188
(8) DESCRIBE `ships` 0.0025510787963867
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1158') 2.2172927856445E-5
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025081634521484
(12) DESCRIBE `avid_specials` 0.0011348724365234
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1158 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.0010650157928467
(14) DESCRIBE `cruiselines` 0.0020020008087158
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00044894218444824
(16) DESCRIBE `orchid_image` 0.0051391124725342
(17) DESCRIBE `cruiselines` 0.0020191669464111
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00034284591674805
(19) DESCRIBE `ships` 0.0027110576629639
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1161') 0.00029397010803223
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002598762512207
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050902366638184
(23) DESCRIBE `avid_specials` 0.0011241436004639
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1161 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.0010120868682861
(25) DESCRIBE `cruiselines` 0.0019350051879883
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) 0.00040698051452637
(27) DESCRIBE `orchid_image` 0.0014858245849609
(28) DESCRIBE `cruiselines` 0.0019800662994385
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '206') 3.504753112793E-5
(30) DESCRIBE `ships` 0.0037400722503662
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1069') 0.00035810470581055
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031900405883789
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029897689819336
(34) DESCRIBE `avid_specials` 0.0012450218200684
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1069 AND class = 'Ship') OR (item_id = 206 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.0014958381652832
(36) DESCRIBE `cruiselines` 0.0022830963134766
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00037813186645508
(38) DESCRIBE `orchid_image` 0.0015640258789062
(39) DESCRIBE `cruiselines` 0.0021531581878662
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00031495094299316
(41) DESCRIBE `ships` 0.0030181407928467
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1217') 0.00033402442932129
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032997131347656
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029993057250977
(45) DESCRIBE `avid_specials` 0.0011451244354248
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1217 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.0010068416595459
(47) DESCRIBE `cruiselines` 0.0019948482513428
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00038003921508789
(49) DESCRIBE `orchid_image` 0.0017349720001221
(50) DESCRIBE `cruiselines` 0.0017430782318115
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00031590461730957
(52) DESCRIBE `ships` 0.0025260448455811
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1443') 0.00035905838012695
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028800964355469
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(56) DESCRIBE `avid_specials` 0.0011470317840576
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1443 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.00099992752075195
(58) DESCRIBE `cruiselines` 0.0020580291748047
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00035190582275391
(60) DESCRIBE `orchid_image` 0.0019969940185547
(61) DESCRIBE `cruiselines` 0.0023670196533203
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00036478042602539
(63) DESCRIBE `ships` 0.002532958984375
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1792') 0.00032496452331543
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032496452331543
(67) DESCRIBE `avid_specials` 0.0015041828155518
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1792 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.0011179447174072
(69) DESCRIBE `cruiselines` 0.0019330978393555
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00023198127746582
(71) DESCRIBE `orchid_image` 0.0016508102416992
(72) DESCRIBE `cruiselines` 0.0034031867980957
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00048398971557617
(74) DESCRIBE `ships` 0.0032961368560791
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1160') 0.00030684471130371
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025320053100586
(78) DESCRIBE `avid_specials` 0.0012640953063965
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1160 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.0010080337524414
(80) DESCRIBE `cruiselines` 0.0018408298492432
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00032591819763184
(82) DESCRIBE `orchid_image` 0.0013818740844727
(83) DESCRIBE `cruiselines` 0.0017640590667725
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00028800964355469
(85) DESCRIBE `ships` 0.0025098323822021
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1162') 0.00028800964355469
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(89) DESCRIBE `avid_specials` 0.0011870861053467
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1162 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.0010049343109131
(91) DESCRIBE `cruiselines` 0.0017459392547607
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003349781036377
(93) DESCRIBE `orchid_image` 0.0013959407806396
(94) DESCRIBE `cruiselines` 0.0018501281738281
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00029110908508301
(96) DESCRIBE `ships` 0.0026099681854248
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1309') 0.00030088424682617
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027084350585938
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(100) DESCRIBE `avid_specials` 0.0015380382537842
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1309 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.0010061264038086
(102) DESCRIBE `cruiselines` 0.0018329620361328
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00032901763916016
(104) DESCRIBE `orchid_image` 0.0013730525970459
(105) DESCRIBE `cruiselines` 0.0018618106842041
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00027894973754883
(107) DESCRIBE `ships` 0.0025088787078857
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1358') 0.0003199577331543
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026297569274902
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(111) DESCRIBE `avid_specials` 0.0013730525970459
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1358 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.0013000965118408
(113) DESCRIBE `cruises` 0.0042071342468262
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (8256, 10650, 13508, 20574, 21382, 28851, 29120, 34150, 34161, 34188)) ORDER BY FIND_IN_SET(id, '8256,10650,13508,20574,21382,28851,29120,34150,34161,34188') 0.0016939640045166
(115) DESCRIBE `cruiselines` 0.0033209323883057
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '183', '12', '144', '20', '23', '18', '7', '131', '8', '101', '96', '171', '103', '156', '31', '15', '262', '29', '191', '120', '91', '258', '33', '50', '28', '251', '14', '114', '49', '212', '206', '24', '37', '187', '16', '36', '47', '170', '110', '208', '118', '181', '195', '153', '151', '30', '88', '108', '141', '159', '140', '59', '73', '90', '216', '4', '35', '264', '147', '211', '113', '57', '180', '38', '64', '48', '257', '261', '213', '276', '115', '95', '184', '52', '105', '244', '82', '209', '134', '177', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,183,12,144,20,23,18,7,131,8,101,96,171,103,156,31,15,262,29,191,120,91,258,33,50,28,251,14,114,49,212,206,24,37,187,16,36,47,170,110,208,118,181,195,153,151,30,88,108,141,159,140,59,73,90,216,4,35,264,147,211,113,57,180,38,64,48,257,261,213,276,115,95,184,52,105,244,82,209,134,177,245') 0.02451491355896
(117) DESCRIBE `ships` 0.0050301551818848
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '977', '1588', '1744', '1555', '1594', '454', '1794', '517', '1237', '1272', '780', '974', '1359', '258', '407', '1717', '1032', '1292', '22', '461', '797', '330', '21', '393', '770', '986', '28', '1677', '404', '1348', '674', '1205', '1415', '716', '207', '1260', '11', '1599', '333', '739', '10', '439', '9', '349', '480', '715', '1067', '521', '1135', '882', '1607', '553', '738', '766', '737', '1008', '1291', '24', '265', '817', '25', '1455', '1199', '792', '610', '711', '1742', '3', '352', '1768', '332', '63', '462', '1372', '520', '1417', '66', '113', '626', '1068', '657', '855', '14', '1738', '585', '1302', '1163', '748', '1413', '1526', '34', '1410', '1411', '1721', '31', '37', '38', '526', '542', '837', '1320', '1323', '1579', '1773', '314', '378', '573', '1063', '970', '43', '854', '1402', '327', '390', '452', '582', '590', '1259', '1569', '81', '1454', '1682', '163', '1088', '1586', '1013', '212', '791', '958', '1284', '1319', '1208', '1193', '114', '1157', '1552', '1492', '39', '335', '401', '441', '580', '1266', '1308', '1587', '30', '36', '84', '405', '850', '1012', '1245', '455', '1326', '1327', '1678', '27', '35', '351', '406', '545', '1461', '386', '547', '1236', '1412', '1420', '722', '340', '385', '451', '658', '1040', '1398', '1418', '1421', '1424', '601', '1303', '1419', '1422', '1423', '162', '1043', '1408', '148', '325', '508', '683', '966', '1172', '1330', '1575', '1782', '1168', '1289', '287', '434', '639', '1108', '1711', '1740', '78', '201', '389', '160', '1021', '124', '394', '852', '1743', '119', '627', '776', '1019', '1344', '1715', '111', '485', '775', '1037', '1159', '1716', '291', '338', '559', '1160', '1217', '1229', '1325', '1343', '1452', '1453', '1604', '751', '1426', '285', '673', '678', '1226', '1373', '45', '1095', '1137', '1405', '105', '266', '1704', '286', '403', '857', '1136', '1150', '1358', '1448', '1501', '253', '818', '858', '69', '701', '768', '851', '1141', '1801', '905', '968', '1283', '1809', '98', '151', '223', '574', '643', '651', '1139', '1574', '1713', '324', '616', '1055', '1230', '1231', '1458', '1714', '82', '108', '150', '341', '348', '790', '954', '1474', '663', '709', '1368', '1459', '1609', '1632', '1672', '1708', '75', '467', '769', '884', '1049', '1206', '1360', '1361', '1362', '1724', '1751', '1808', '4', '375', '885', '1035', '1042', '1223', '1722', '1750', '1767', '149', '652', '1051', '1148', '1409', '944', '123', '1321', '1322', '70', '262', '1301', '290', '644', '665', '703', '784', '1020', '1483', '1771', '423', '1047', '1293', '1580', '116', '152', '516', '1445', '1601', '1681', '147', '422', '483', '1054', '1486', '1572', '421', '707', '1262', '1282', '1581', '93', '198', '1052', '1318', '1437', '1676', '1679', '1781', '796', '886', '1539', '1766', '1036', '1075', '717', '1045', '1060', '1064', '1673', '74', '420', '704', '1048', '1143', '1444', '1465', '1684', '973', '1073', '1151', '1389', '205', '656', '883', '982', '1039', '1367', '419', '996', '1146', '1232', '1254', '1571', '503', '1050', '1350', '1540', '1195', '1749', '1791', '635', '795', '808', '1806', '479', '494', '687', '761', '1044', '1772', '1297', '1706', '1805', '1807', '493', '965', '1025', '1029', '1053', '1090', '1144', '1158', '1404', '1647', '1709', '1788', '733', '767', '937', '972', '1027', '1316', '1342', '1624', '1645', '1674', '695', '1241', '1626', '1697', '1730', '240', '979', '1028', '1113', '1155', '1156', '1295', '1340', '1341', '1471', '1089', '1188', '1296', '299', '300', '888', '988', '1024', '1233', '1351', '1451', '1710', '692', '1026', '1145', '1196', '1339', '1640', '1757', '666', '685', '962', '997', '1034', '1038', '1138', '1142', '1298', '1366', '1631', '1792', '836')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,977,1588,1744,1555,1594,454,1794,517,1237,1272,780,974,1359,258,407,1717,1032,1292,22,461,797,330,21,393,770,986,28,1677,404,1348,674,1205,1415,716,207,1260,11,1599,333,739,10,439,9,349,480,715,1067,521,1135,882,1607,553,738,766,737,1008,1291,24,265,817,25,1455,1199,792,610,711,1742,3,352,1768,332,63,462,1372,520,1417,66,113,626,1068,657,855,14,1738,585,1302,1163,748,1413,1526,34,1410,1411,1721,31,37,38,526,542,837,1320,1323,1579,1773,314,378,573,1063,970,43,854,1402,327,390,452,582,590,1259,1569,81,1454,1682,163,1088,1586,1013,212,791,958,1284,1319,1208,1193,114,1157,1552,1492,39,335,401,441,580,1266,1308,1587,30,36,84,405,850,1012,1245,455,1326,1327,1678,27,35,351,406,545,1461,386,547,1236,1412,1420,722,340,385,451,658,1040,1398,1418,1421,1424,601,1303,1419,1422,1423,162,1043,1408,148,325,508,683,966,1172,1330,1575,1782,1168,1289,287,434,639,1108,1711,1740,78,201,389,160,1021,124,394,852,1743,119,627,776,1019,1344,1715,111,485,775,1037,1159,1716,291,338,559,1160,1217,1229,1325,1343,1452,1453,1604,751,1426,285,673,678,1226,1373,45,1095,1137,1405,105,266,1704,286,403,857,1136,1150,1358,1448,1501,253,818,858,69,701,768,851,1141,1801,905,968,1283,1809,98,151,223,574,643,651,1139,1574,1713,324,616,1055,1230,1231,1458,1714,82,108,150,341,348,790,954,1474,663,709,1368,1459,1609,1632,1672,1708,75,467,769,884,1049,1206,1360,1361,1362,1724,1751,1808,4,375,885,1035,1042,1223,1722,1750,1767,149,652,1051,1148,1409,944,123,1321,1322,70,262,1301,290,644,665,703,784,1020,1483,1771,423,1047,1293,1580,116,152,516,1445,1601,1681,147,422,483,1054,1486,1572,421,707,1262,1282,1581,93,198,1052,1318,1437,1676,1679,1781,796,886,1539,1766,1036,1075,717,1045,1060,1064,1673,74,420,704,1048,1143,1444,1465,1684,973,1073,1151,1389,205,656,883,982,1039,1367,419,996,1146,1232,1254,1571,503,1050,1350,1540,1195,1749,1791,635,795,808,1806,479,494,687,761,1044,1772,1297,1706,1805,1807,493,965,1025,1029,1053,1090,1144,1158,1404,1647,1709,1788,733,767,937,972,1027,1316,1342,1624,1645,1674,695,1241,1626,1697,1730,240,979,1028,1113,1155,1156,1295,1340,1341,1471,1089,1188,1296,299,300,888,988,1024,1233,1351,1451,1710,692,1026,1145,1196,1339,1640,1757,666,685,962,997,1034,1038,1138,1142,1298,1366,1631,1792,836') 0.11451697349548
(119) DESCRIBE `cruisetypes` 0.0019581317901611
(120) DESCRIBE `destinations` 0.0031421184539795
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '9', '43', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '21', '40', '7', '48', '45', '29', '44', '30', '10', '34', '46', '52', '32', '56')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,9,43,2,37,8,39,53,26,28,38,49,55,11,21,40,7,48,45,29,44,30,10,34,46,52,32,56') 0.0031280517578125