or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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
    AmaVenita

    AmaVenita

    The AmaVenita, which debuted in 2015, is a sister ship to the AmaCerto and features the most advanced design of any river cruise vessel currently...

    Star Rating River
  • APT
    AmaVerde

    AmaVerde

    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
    AmaVerde

    AmaVerde

    AmaVerde made her debut on the Danube in 2011, the 161-passenger AmaVerde is our second "Twin Balcony" vessel in Europe. Sharing the distinction of having...

    Star Rating River
  • AMA Waterways
    AmaVida

    AmaVida

    The AmaVida brings AmaWaterways’ distinctive standard of excellence to the Douro River in Portugal. This grand 106-passenger vessel features balconies in the majority of its...

    Star Rating River
  • APT
    AmaVida

    AmaVida

    The luxurious MS AmaVida has been custom-designed and built with Portugal's beautiful Douro River in mind. Thread your way through this picturesque slice of Europe...

    Star Rating River
  • APT
    AmaViola

    AmaViola

    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
    AmaViola

    AmaViola

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

    Star Rating River
  • CroisiEurope
    Amazon Discovery

    Amazon Discovery

    Amazon Discovery.

    Star Rating River
  • Pandaw Cruises
    Amazon Dream

    Amazon Dream

    Our partner ship, the Amazon Dream, offers a comfortable base from where we explore; all cabins are air-conditioned and well appointed and you will be...

    Star Rating River
  • Amazon Explorer

    Amazon Explorer

    Our Amazon Explorer tours are designed around our first class 19th century style riverboat. Ecologically designed with the fragile Amazon river and surrounding environment in...

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

Total elapsed time: 0.21423506736755

# Query Time
(1) connect 0.0009770393371582
(2) DESCRIBE `ships` 0.0042400360107422
(3) DESCRIBE `cruiselines` 0.0025069713592529
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.0005950927734375
(5) DESCRIBE `orchid_image` 0.0019052028656006
(6) DESCRIBE `cruiselines` 0.0021748542785645
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00033712387084961
(8) DESCRIBE `ships` 0.0025880336761475
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1598') 0.00032997131347656
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035691261291504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046300888061523
(12) DESCRIBE `avid_specials` 0.0014340877532959
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1598 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.0016500949859619
(14) DESCRIBE `cruiselines` 0.0025038719177246
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003669261932373
(16) DESCRIBE `orchid_image` 0.001680850982666
(17) DESCRIBE `cruiselines` 0.0018370151519775
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00031614303588867
(19) DESCRIBE `ships` 0.0025420188903809
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '886') 0.00029587745666504
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027298927307129
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028586387634277
(23) DESCRIBE `avid_specials` 0.0013928413391113
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 886 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.0011231899261475
(25) DESCRIBE `cruiselines` 0.0019638538360596
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00034689903259277
(27) DESCRIBE `orchid_image` 0.0015621185302734
(28) DESCRIBE `cruiselines` 0.0018219947814941
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00029301643371582
(30) DESCRIBE `ships` 0.0027899742126465
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '959') 0.00034213066101074
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(34) DESCRIBE `avid_specials` 0.001427173614502
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 959 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.0011670589447021
(36) DESCRIBE `cruiselines` 0.00211501121521
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00036883354187012
(38) DESCRIBE `orchid_image` 0.0016758441925049
(39) DESCRIBE `cruiselines` 0.0018270015716553
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00029897689819336
(41) DESCRIBE `ships` 0.0026040077209473
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1020') 0.00031900405883789
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034189224243164
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002739429473877
(45) DESCRIBE `avid_specials` 0.0012729167938232
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1020 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.0012450218200684
(47) DESCRIBE `cruiselines` 0.0021440982818604
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003659725189209
(49) DESCRIBE `orchid_image` 0.0015101432800293
(50) DESCRIBE `cruiselines` 0.0019338130950928
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.0003211498260498
(52) DESCRIBE `ships` 0.0029709339141846
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1166') 0.00038981437683105
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027585029602051
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035214424133301
(56) DESCRIBE `avid_specials` 0.0017068386077881
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1166 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.0017280578613281
(58) DESCRIBE `cruiselines` 0.0026140213012695
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00046896934509277
(60) DESCRIBE `orchid_image` 0.0020639896392822
(61) DESCRIBE `cruiselines` 0.0018379688262939
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.0003659725189209
(63) DESCRIBE `ships` 0.0026350021362305
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1478') 0.00033998489379883
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026416778564453
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(67) DESCRIBE `avid_specials` 0.0011711120605469
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1478 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.0014350414276123
(69) DESCRIBE `cruiselines` 0.001884937286377
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00033307075500488
(71) DESCRIBE `orchid_image` 0.0014359951019287
(72) DESCRIBE `cruiselines` 0.0025391578674316
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00038599967956543
(74) DESCRIBE `ships` 0.0027589797973633
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1322') 0.00032210350036621
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(78) DESCRIBE `avid_specials` 0.0011930465698242
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1322 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.00097894668579102
(80) DESCRIBE `cruiselines` 0.0018320083618164
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00043821334838867
(82) DESCRIBE `orchid_image` 0.0020830631256104
(83) DESCRIBE `cruiselines` 0.002579927444458
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00041294097900391
(85) DESCRIBE `ships` 0.0036740303039551
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1466') 0.0003972053527832
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(89) DESCRIBE `avid_specials` 0.0016911029815674
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1466 AND class = 'Ship') OR (item_id = 144 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.0018320083618164
(91) DESCRIBE `cruiselines` 0.0027730464935303
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0005040168762207
(93) DESCRIBE `orchid_image` 0.0022730827331543
(94) DESCRIBE `cruiselines` 0.0028159618377686
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00043392181396484
(96) DESCRIBE `ships` 0.0036189556121826
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1427') 0.00053310394287109
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033402442932129
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032281875610352
(100) DESCRIBE `avid_specials` 0.0012898445129395
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1427 AND class = 'Ship') OR (item_id = 120 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.0010719299316406
(102) DESCRIBE `cruiselines` 0.0021460056304932
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00040078163146973
(104) DESCRIBE `orchid_image` 0.0013940334320068
(105) DESCRIBE `ships` 0.0035719871520996
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '872') 0.00047588348388672
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035595893859863
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035786628723145
(109) DESCRIBE `avid_specials` 0.0017709732055664
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 872 AND class = 'Ship') OR (item_id = 171 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.0018060207366943
(111) DESCRIBE `cruises` 0.0032179355621338
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4424, 11516, 21383, 22963, 24925, 27115, 29065, 29591, 29609, 34155)) ORDER BY FIND_IN_SET(id, '4424,11516,21383,22963,24925,27115,29065,29591,29609,34155') 0.0012578964233398
(113) DESCRIBE `cruiselines` 0.0018949508666992
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '7', '12', '23', '171', '20', '18', '144', '31', '101', '8', '131', '96', '239', '29', '15', '191', '120', '183', '103', '50', '206', '91', '16', '262', '221', '33', '24', '28', '114', '110', '268', '156', '37', '208', '141', '14', '187', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '212', '4', '36', '232', '225', '238', '140', '184', '249', '159', '113', '90', '47', '230', '182', '136', '213', '256', '261', '35', '237', '188', '174', '57', '180', '64', '264', '73', '248', '146', '195', '95', '52', '115', '204', '209', '59', '168', '196', '219', '231', '116', '82', '229', '119', '170', '244', '134', '105', '240', '276', '48', '108', '275', '132', '224', '210', '269')) ORDER BY FIND_IN_SET(id, '218,19,77,26,7,12,23,171,20,18,144,31,101,8,131,96,239,29,15,191,120,183,103,50,206,91,16,262,221,33,24,28,114,110,268,156,37,208,141,14,187,153,118,49,151,211,30,258,216,181,88,212,4,36,232,225,238,140,184,249,159,113,90,47,230,182,136,213,256,261,35,237,188,174,57,180,64,264,73,248,146,195,95,52,115,204,209,59,168,196,219,231,116,82,229,119,170,244,134,105,240,276,48,108,275,132,224,210,269') 0.0048408508300781
(115) DESCRIBE `ships` 0.0030310153961182
(116) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '258', '1291', '977', '1359', '454', '1599', '1272', '855', '986', '1237', '404', '1594', '780', '1677', '1067', '1588', '837', '37', '38', '34', '22', '27', '378', '461', '21', '28', '407', '31', '393', '1607', '817', '1135', '1247', '1554', '1555', '1012', '30', '36', '349', '39', '1424', '726', '35', '1422', '462', '1415', '792', '1423', '585', '882', '1245', '1419', '1420', '1421', '1176', '1418', '1215', '1574', '113', '330', '1405', '24', '711', '11', '439', '1744', '9', '10', '265', '766', '455', '452', '542', '1141', '1193', '78', '739', '81', '635', '1572', '69', '124', '674', '3', '1095', '1454', '770', '1008', '1372', '5', '850', '874', '338', '116', '340', '573', '1168', '580', '1471', '1021', '1569', '553', '1284', '43', '70', '1302', '25', '66', '160', '253', '285', '332', '405', '716', '1402', '148', '451', '658', '944', '1678', '111', '390', '1562', '4', '748', '1172', '386', '520', '797', '966', '1259', '1260', '1460', '385', '626', '791', '1320', '1323', '406', '1455', '974', '1088', '1108', '1325', '286', '314', '678', '351', '590', '768', '582', '970', '1195', '1373', '1575', '63', '119', '327', '434', '508', '526', '108', '335', '375', '616', '993', '1587', '559', '854', '207', '84', '394', '401', '722', '1208', '1266', '517', '1398', '1492', '1571', '657', '775', '1068', '1268', '150', '421', '1236', '1586', '485', '1308', '1672', '114', '403', '704', '1742', '147', '152', '547', '784', '883', '105', '151', '1064', '1289', '1319', '223', '325', '652', '683', '958', '1269', '1724', '123', '149', '262', '348', '715', '1321', '1270', '75', '163', '389', '483', '1243', '1389', '1143', '1159', '1282', '1561', '1330', '1437', '1557', '14', '441', '1013', '1526', '1579', '1711', '287', '717', '1139', '1151', '1214', '1326', '1327', '1348', '162', '333', '545', '790', '796', '1367', '1722', '290', '732', '823', '1216', '1301', '1539', '1717', '93', '651', '1738', '291', '884', '968', '1075', '1318', '201', '673', '1540', '1602', '82', '98', '212', '769', '818', '1063', '1137', '1144', '1303', '1344', '45', '516', '743', '852', '1040', '1160', '1343', '1704', '751', '776', '1163', '1217', '1452', '1453', '1604', '701', '1043', '1218', '1283', '1409', '1426', '1566', '1682', '266', '324', '341', '521', '811', '885', '988', '1025', '1027', '1090', '1136', '1157', '1241', '1449', '448', '669', '1253', '1413', '1552', '1632', '1676', '1740', '467', '574', '738', '795', '1019', '1073', '1223', '1358', '1411', '639', '905', '1152', '1226', '1233', '1345', '1376', '1448', '1474', '601', '888', '1150', '1721', '494', '1029', '1145', '1647', '74', '417', '997', '1055', '1229', '1322', '1408', '1458', '1716', '1026', '1188', '1580', '618', '709', '836', '1149', '1231', '1351', '1410', '1463', '1489', '1496', '1505', '1619', '1663', '205', '208', '666', '954', '973', '1034', '1047', '1222', '1366', '1713', '1715', '204', '352', '423', '493', '610', '996', '1049', '1230', '1714', '643', '851', '1154', '1262', '1362', '1368', '1407', '1444', '1516', '1609', '1673', '1743', '663', '920', '927', '1017', '1404', '1567', '1606', '499', '703', '921', '931', '1004', '1020', '1037', '1187', '1196', '1285', '1354', '1360', '1361', '1459', '1470', '1508', '1627', '731', '859', '914', '923', '1042', '1175', '1518', '503', '915', '916', '926', '930', '1003', '1045', '1072', '1106', '1138', '1486', '1517', '1521', '422', '479', '781', '924', '972', '1092', '1254', '1352', '1412', '1522', '1596', '1708', '1751', '17', '671', '1001', '1091', '1240', '1593', '1723', '453', '656', '665', '938', '1005', '1051', '1054', '1148', '1445', '1514', '1729', '420', '672', '937', '1684', '1002', '1052', '1601', '1679', '1681', '1697')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,258,1291,977,1359,454,1599,1272,855,986,1237,404,1594,780,1677,1067,1588,837,37,38,34,22,27,378,461,21,28,407,31,393,1607,817,1135,1247,1554,1555,1012,30,36,349,39,1424,726,35,1422,462,1415,792,1423,585,882,1245,1419,1420,1421,1176,1418,1215,1574,113,330,1405,24,711,11,439,1744,9,10,265,766,455,452,542,1141,1193,78,739,81,635,1572,69,124,674,3,1095,1454,770,1008,1372,5,850,874,338,116,340,573,1168,580,1471,1021,1569,553,1284,43,70,1302,25,66,160,253,285,332,405,716,1402,148,451,658,944,1678,111,390,1562,4,748,1172,386,520,797,966,1259,1260,1460,385,626,791,1320,1323,406,1455,974,1088,1108,1325,286,314,678,351,590,768,582,970,1195,1373,1575,63,119,327,434,508,526,108,335,375,616,993,1587,559,854,207,84,394,401,722,1208,1266,517,1398,1492,1571,657,775,1068,1268,150,421,1236,1586,485,1308,1672,114,403,704,1742,147,152,547,784,883,105,151,1064,1289,1319,223,325,652,683,958,1269,1724,123,149,262,348,715,1321,1270,75,163,389,483,1243,1389,1143,1159,1282,1561,1330,1437,1557,14,441,1013,1526,1579,1711,287,717,1139,1151,1214,1326,1327,1348,162,333,545,790,796,1367,1722,290,732,823,1216,1301,1539,1717,93,651,1738,291,884,968,1075,1318,201,673,1540,1602,82,98,212,769,818,1063,1137,1144,1303,1344,45,516,743,852,1040,1160,1343,1704,751,776,1163,1217,1452,1453,1604,701,1043,1218,1283,1409,1426,1566,1682,266,324,341,521,811,885,988,1025,1027,1090,1136,1157,1241,1449,448,669,1253,1413,1552,1632,1676,1740,467,574,738,795,1019,1073,1223,1358,1411,639,905,1152,1226,1233,1345,1376,1448,1474,601,888,1150,1721,494,1029,1145,1647,74,417,997,1055,1229,1322,1408,1458,1716,1026,1188,1580,618,709,836,1149,1231,1351,1410,1463,1489,1496,1505,1619,1663,205,208,666,954,973,1034,1047,1222,1366,1713,1715,204,352,423,493,610,996,1049,1230,1714,643,851,1154,1262,1362,1368,1407,1444,1516,1609,1673,1743,663,920,927,1017,1404,1567,1606,499,703,921,931,1004,1020,1037,1187,1196,1285,1354,1360,1361,1459,1470,1508,1627,731,859,914,923,1042,1175,1518,503,915,916,926,930,1003,1045,1072,1106,1138,1486,1517,1521,422,479,781,924,972,1092,1254,1352,1412,1522,1596,1708,1751,17,671,1001,1091,1240,1593,1723,453,656,665,938,1005,1051,1054,1148,1445,1514,1729,420,672,937,1684,1002,1052,1601,1679,1681,1697') 0.053644895553589
(117) DESCRIBE `cruisetypes` 0.0017490386962891
(118) DESCRIBE `destinations` 0.0024919509887695
(119) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '55', '39', '38', '28', '7', '40', '26', '30', '48', '11', '21', '29', '45', '49', '56', '44', '10', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,55,39,38,28,7,40,26,30,48,11,21,29,45,49,56,44,10,34,52,46,32') 0.0018270015716553