or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • CroisiEurope
    Amalia Rodrigues

    Amalia Rodrigues

    Europe’s largest river cruise operator, CroisiEurope, has announced that it will inaugurate its newest ship - the MS Amalia Rodrigues - in Porto on 20th...

    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
  • AMA Waterways
    AmaLyra

    AmaLyra

    Introduced in 2009, the AmaLyra quickly earned a "Best New River Cruise Ship" distinction. Striking contemporary artwork is a hallmark of this luxurious vessel. Marvel...

    Star Rating River
  • APT
    AmaLyra

    AmaLyra

    MS AmaLyra 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
    AmaMagna

    AmaMagna

    As imagined by AmaWaterways co-owner and president, Rudi Schreiner, the “godfather of river cruising,” the AmaMagna is nearly twice the width of traditional European river...

    Star Rating River
  • AMA Waterways
    AmaMora

    AmaMora

    Sister ship to the AmaLea, the AmaMora is an incredible twin-balcony ship launching in 2019 with generous personal space, multiple dining choices and exceptional stateroom...

    Star Rating River
  • AMA Waterways
    AmaPrima

    AmaPrima

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

    Star Rating River
  • APT
    AmaPrima

    AmaPrima

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

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

# Query Time
(1) connect 0.00092315673828125
(2) DESCRIBE `ships` 0.0039670467376709
(3) DESCRIBE `cruiselines` 0.0027329921722412
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00061702728271484
(5) DESCRIBE `orchid_image` 0.0018031597137451
(6) DESCRIBE `cruiselines` 0.0022680759429932
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00038599967956543
(8) DESCRIBE `ships` 0.0036180019378662
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1740') 0.00043988227844238
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036096572875977
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033688545227051
(12) DESCRIBE `avid_specials` 0.0017800331115723
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1740 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.0012209415435791
(14) DESCRIBE `cruiselines` 0.0021190643310547
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00039386749267578
(16) DESCRIBE `orchid_image` 0.0015299320220947
(17) DESCRIBE `cruiselines` 0.0017280578613281
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00029301643371582
(19) DESCRIBE `ships` 0.0025410652160645
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '935') 0.00027608871459961
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002601146697998
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024104118347168
(23) DESCRIBE `avid_specials` 0.0013329982757568
(24) 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.0012760162353516
(25) DESCRIBE `cruiselines` 0.002310037612915
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00044417381286621
(27) DESCRIBE `orchid_image` 0.0014379024505615
(28) DESCRIBE `cruiselines` 0.0018401145935059
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00031399726867676
(30) DESCRIBE `ships` 0.0026590824127197
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1011') 0.00030612945556641
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032401084899902
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034594535827637
(34) DESCRIBE `avid_specials` 0.0016641616821289
(35) 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.0014159679412842
(36) DESCRIBE `cruiselines` 0.0022060871124268
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00039982795715332
(38) DESCRIBE `orchid_image` 0.0015478134155273
(39) DESCRIBE `cruiselines` 0.0030081272125244
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00035595893859863
(41) DESCRIBE `ships` 0.0029990673065186
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '761') 0.0004119873046875
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028586387634277
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(45) DESCRIBE `avid_specials` 0.0013790130615234
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 761 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.0010159015655518
(47) DESCRIBE `cruiselines` 0.0018889904022217
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003352165222168
(49) DESCRIBE `orchid_image` 0.0015420913696289
(50) DESCRIBE `cruiselines` 0.0018699169158936
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00035691261291504
(52) DESCRIBE `ships` 0.0030298233032227
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '804') 0.00035905838012695
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032210350036621
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002601146697998
(56) DESCRIBE `avid_specials` 0.001230001449585
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 804 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.00097417831420898
(58) DESCRIBE `cruiselines` 0.0017821788787842
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.0003361701965332
(60) DESCRIBE `orchid_image` 0.0015368461608887
(61) DESCRIBE `cruiselines` 0.0022120475769043
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00033807754516602
(63) DESCRIBE `ships` 0.0028190612792969
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1743') 0.00042200088500977
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031304359436035
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(67) DESCRIBE `avid_specials` 0.0014009475708008
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1743 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.0011608600616455
(69) DESCRIBE `cruiselines` 0.0021548271179199
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00040602684020996
(71) DESCRIBE `orchid_image` 0.0016388893127441
(72) DESCRIBE `cruiselines` 0.0018351078033447
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00031304359436035
(74) DESCRIBE `ships` 0.002763032913208
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1750') 0.00031614303588867
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026321411132812
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024580955505371
(78) DESCRIBE `avid_specials` 0.0013890266418457
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1750 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.0019371509552002
(80) DESCRIBE `cruiselines` 0.0024099349975586
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00043678283691406
(82) DESCRIBE `orchid_image` 0.0015711784362793
(83) DESCRIBE `cruiselines` 0.0020499229431152
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 7.8201293945312E-5
(85) DESCRIBE `ships` 0.0029671192169189
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1019') 0.00032997131347656
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030398368835449
(89) DESCRIBE `avid_specials` 0.0013740062713623
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1019 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.0012040138244629
(91) DESCRIBE `cruiselines` 0.0023839473724365
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00046896934509277
(93) DESCRIBE `orchid_image` 0.0014960765838623
(94) DESCRIBE `cruiselines` 0.0018901824951172
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00035905838012695
(96) DESCRIBE `ships` 0.0028049945831299
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1164') 0.00055480003356934
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003209114074707
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(100) DESCRIBE `avid_specials` 0.0016639232635498
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1164 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.0015659332275391
(102) DESCRIBE `cruiselines` 0.0026271343231201
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00063586235046387
(104) DESCRIBE `orchid_image` 0.0018939971923828
(105) DESCRIBE `cruiselines` 0.0021510124206543
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.0003669261932373
(107) DESCRIBE `ships` 0.0031769275665283
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1158') 0.00046801567077637
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027298927307129
(111) DESCRIBE `avid_specials` 0.0014631748199463
(112) 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.0011558532714844
(113) DESCRIBE `cruises` 0.0037660598754883
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (29952, 34156, 34163, 34184, 38950, 40591, 42483, 44221, 44275, 44276)) ORDER BY FIND_IN_SET(id, '29952,34156,34163,34184,38950,40591,42483,44221,44275,44276') 0.0020449161529541
(115) DESCRIBE `cruiselines` 0.0028622150421143
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '23', '7', '12', '20', '171', '18', '144', '8', '101', '31', '131', '50', '96', '239', '29', '103', '15', '191', '91', '206', '120', '37', '16', '114', '33', '262', '24', '268', '28', '14', '174', '221', '110', '156', '208', '187', '141', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '4', '212', '36', '264', '225', '238', '140', '184', '249', '232', '159', '90', '230', '113', '182', '213', '136', '276', '47', '188', '237', '261', '57', '64', '180', '73', '248', '35', '95', '209', '52', '231', '146', '195', '116', '219', '59', '82', '119', '256', '196', '105', '134', '244', '115', '168', '170', '229', '240', '204', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,23,7,12,20,171,18,144,8,101,31,131,50,96,239,29,103,15,191,91,206,120,37,16,114,33,262,24,268,28,14,174,221,110,156,208,187,141,153,118,49,151,211,30,258,216,181,88,4,212,36,264,225,238,140,184,249,232,159,90,230,113,182,213,136,276,47,188,237,261,57,64,180,73,248,35,95,209,52,231,146,195,116,219,59,82,119,256,196,105,134,244,115,168,170,229,240,204,48,224') 0.0056920051574707
(117) DESCRIBE `ships` 0.003101110458374
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '977', '1291', '258', '1199', '1359', '1599', '349', '454', '1135', '1272', '404', '780', '855', '1677', '986', '1067', '1237', '265', '1594', '837', '1607', '37', '38', '34', '22', '27', '21', '31', '378', '407', '461', '28', '770', '1376', '1588', '393', '817', '542', '39', '30', '36', '1012', '1245', '573', '1552', '1402', '1424', '35', '726', '792', '66', '585', '330', '1415', '462', '332', '1284', '1744', '113', '1422', '882', '1176', '1419', '1423', '1760', '24', '711', '1574', '9', '11', '1405', '1420', '1418', '1421', '439', '455', '434', '1215', '10', '580', '766', '1021', '1193', '1141', '78', '739', '452', '69', '81', '1454', '1572', '1372', '1682', '3', '674', '1008', '1095', '635', '678', '124', '338', '1373', '1168', '1319', '5', '335', '340', '116', '43', '253', '553', '850', '1569', '1678', '70', '1302', '148', '285', '1172', '111', '160', '451', '25', '348', '658', '944', '1260', '4', '390', '874', '966', '1159', '1247', '1259', '386', '716', '748', '385', '405', '626', '651', '1108', '616', '791', '1320', '1330', '1562', '314', '1088', '1323', '1325', '63', '389', '406', '768', '784', '286', '683', '1455', '1645', '207', '508', '582', '590', '970', '1672', '287', '327', '375', '1195', '1587', '119', '483', '526', '749', '1575', '84', '108', '291', '559', '1068', '1236', '401', '722', '854', '98', '394', '520', '1208', '1398', '1460', '163', '290', '657', '1742', '485', '1571', '1586', '150', '652', '775', '776', '1492', '403', '421', '704', '1268', '147', '151', '152', '341', '1064', '1266', '1269', '114', '1308', '123', '223', '547', '1289', '1321', '149', '1539', '325', '883', '954', '993', '105', '262', '517', '715', '958', '1711', '45', '351', '1270', '1389', '1471', '1724', '75', '1139', '1243', '1282', '1486', '1601', '1722', '1143', '1557', '1717', '545', '717', '790', '441', '1526', '1561', '1579', '1738', '324', '823', '885', '1013', '1075', '1151', '1214', '1326', '1327', '1437', '162', '333', '673', '1303', '1367', '93', '205', '516', '796', '968', '1040', '1318', '1704', '818', '1301', '1540', '82', '212', '701', '1063', '1216', '1348', '1602', '743', '988', '1043', '1218', '1344', '201', '751', '769', '852', '1137', '1144', '1217', '1262', '1343', '1676', '1740', '574', '732', '1160', '1409', '1566', '1766', '795', '884', '1283', '1452', '1453', '1604', '266', '639', '738', '1025', '1090', '1136', '1157', '1163', '1721', '448', '601', '669', '811', '1073', '1223', '1226', '1241', '1253', '1426', '1449', '14', '905', '1019', '1027', '1029', '1229', '1411', '1496', '1632', '1716', '467', '1152', '1358', '1413', '1474', '997', '1188', '1448', '1619', '74', '610', '1055', '1150', '1345', '1351', '1673', '1713', '1715', '417', '494', '836', '996', '1026', '1047', '1145', '1233', '1322', '1408', '1410', '1458', '1647', '1663', '1714', '643', '1743', '423', '453', '618', '709', '888', '973', '1034', '1149', '1231', '1366', '1404', '1522', '1580', '1609', '208', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1489', '1505', '1516', '1593', '1730', '666', '920', '921', '927', '931', '1004', '1017', '1042', '1230', '1354', '1508', '1606', '1627', '1649', '1729', '352', '493', '521', '914', '923', '1106', '1140', '1154', '1444', '1517', '1518', '1567', '499', '663', '915', '916', '926', '930', '1003', '1072', '1138', '1514', '1674', '1708', '1751', '479', '703', '924', '972', '1001', '1020', '1052', '1175', '1352', '1515', '1521', '1596', '1723', '422', '665', '671', '781', '938', '1005', '1045', '1054', '1254', '1285', '1412', '1463', '937', '1051', '1053', '1091', '1092', '1445', '1650', '1681', '1684', '672')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,977,1291,258,1199,1359,1599,349,454,1135,1272,404,780,855,1677,986,1067,1237,265,1594,837,1607,37,38,34,22,27,21,31,378,407,461,28,770,1376,1588,393,817,542,39,30,36,1012,1245,573,1552,1402,1424,35,726,792,66,585,330,1415,462,332,1284,1744,113,1422,882,1176,1419,1423,1760,24,711,1574,9,11,1405,1420,1418,1421,439,455,434,1215,10,580,766,1021,1193,1141,78,739,452,69,81,1454,1572,1372,1682,3,674,1008,1095,635,678,124,338,1373,1168,1319,5,335,340,116,43,253,553,850,1569,1678,70,1302,148,285,1172,111,160,451,25,348,658,944,1260,4,390,874,966,1159,1247,1259,386,716,748,385,405,626,651,1108,616,791,1320,1330,1562,314,1088,1323,1325,63,389,406,768,784,286,683,1455,1645,207,508,582,590,970,1672,287,327,375,1195,1587,119,483,526,749,1575,84,108,291,559,1068,1236,401,722,854,98,394,520,1208,1398,1460,163,290,657,1742,485,1571,1586,150,652,775,776,1492,403,421,704,1268,147,151,152,341,1064,1266,1269,114,1308,123,223,547,1289,1321,149,1539,325,883,954,993,105,262,517,715,958,1711,45,351,1270,1389,1471,1724,75,1139,1243,1282,1486,1601,1722,1143,1557,1717,545,717,790,441,1526,1561,1579,1738,324,823,885,1013,1075,1151,1214,1326,1327,1437,162,333,673,1303,1367,93,205,516,796,968,1040,1318,1704,818,1301,1540,82,212,701,1063,1216,1348,1602,743,988,1043,1218,1344,201,751,769,852,1137,1144,1217,1262,1343,1676,1740,574,732,1160,1409,1566,1766,795,884,1283,1452,1453,1604,266,639,738,1025,1090,1136,1157,1163,1721,448,601,669,811,1073,1223,1226,1241,1253,1426,1449,14,905,1019,1027,1029,1229,1411,1496,1632,1716,467,1152,1358,1413,1474,997,1188,1448,1619,74,610,1055,1150,1345,1351,1673,1713,1715,417,494,836,996,1026,1047,1145,1233,1322,1408,1410,1458,1647,1663,1714,643,1743,423,453,618,709,888,973,1034,1149,1231,1366,1404,1522,1580,1609,208,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1489,1505,1516,1593,1730,666,920,921,927,931,1004,1017,1042,1230,1354,1508,1606,1627,1649,1729,352,493,521,914,923,1106,1140,1154,1444,1517,1518,1567,499,663,915,916,926,930,1003,1072,1138,1514,1674,1708,1751,479,703,924,972,1001,1020,1052,1175,1352,1515,1521,1596,1723,422,665,671,781,938,1005,1045,1054,1254,1285,1412,1463,937,1051,1053,1091,1092,1445,1650,1681,1684,672') 0.05193305015564
(119) DESCRIBE `cruisetypes` 0.0020899772644043
(120) DESCRIBE `destinations` 0.0027239322662354
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '28', '26', '55', '38', '40', '7', '30', '21', '48', '11', '49', '45', '29', '44', '56', '10', '34', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,53,39,28,26,55,38,40,7,30,21,48,11,49,45,29,44,56,10,34,52,32,46') 0.0029118061065674