or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Avalon Waterways
    Avalon Impression

    Avalon Impression

    In addition to the Avalon Poetry II® and Avalon Illumination®, the striking Avalon Impression? graced the waters of Europe's Rhine, Main, and Danube Rivers in...

    Star Rating River
  • Avalon Waterways
    Avalon Panorama

    Avalon Panorama

    A brand new kind of ship, the Avalon Panorama set sail in 2011, taking inspired design to a whole new level. A unique 'Suite Ship',...

    Star Rating River
  • Avalon Waterways
    Avalon Passion

    Avalon Passion

    2016 was another big year for Avalon, as we expand our fleet of innovative Suite Ships? once again. In addition to the Avalon Imagery II®,...

    Star Rating River
  • Avalon Waterways
    Avalon Poetry II

    Avalon Poetry II

    New to the legendary waters of Europe in 2014, the Avalon Poetry II® offers a delightfully intimate cruise setting along the Rhine, Main, and Danube...

    Star Rating River
  • Avalon Waterways

    Avalon Saigon

    The Avalon Saigon was specifically designed to offer an intimate experience with a maximum of 36 guests, so you can truly immerse yourself in the...

    Star Rating River
  • Avalon Waterways
    Avalon Siem Reap

    Avalon Siem Reap

    The Avalon Siem Reap was specifically designed to offer an intimate experience with a maximum of 36 guests, so you can truly immerse yourself in...

    Star Rating River
  • Avalon Waterways
    Avalon Tapestry

    Avalon Tapestry

    The innovative Avalon Tapestry introduced an award-winning concept to river cruising: the impressive Silent Drive System, which separates the engines from the guests for a...

    Star Rating River
  • Avalon Waterways
    Avalon Tapestry II

    Avalon Tapestry II

    The Avalon Tapestry II® is a true haven on the river - two full decks of Panorama Suites with Wall-to-Wall Panoramic Windows that transform the...

    Star Rating River
  • Avalon Waterways
    Avalon Tranquility II

    Avalon Tranquility II

    Another exciting Suite Ship graces the rivers of Europe in 2015. The intimate setting of the Avalon Tranquility II® features two full decks of Panorama...

    Star Rating River
  • Avalon Waterways
    Avalon View

    Avalon View

    The Avalon View is the newest addition to the 2020 Avalon Suite Ship fleet. With the youngest fleet of ships on Europe's waterways, Avalon Waterways...

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

Total elapsed time: 0.21925783157349

# Query Time
(1) connect 0.00072813034057617
(2) DESCRIBE `ships` 0.0031321048736572
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` 0.00034689903259277
(4) connect 0.0046689510345459
(5) SELECT DISTINCT `ships`.* FROM `ships` ORDER BY `name` ASC LIMIT 10 OFFSET 110 0.01654314994812
(6) DESCRIBE `cruiselines` 0.0024199485778809
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.0003809928894043
(8) DESCRIBE `orchid_image` 0.00177001953125
(9) DESCRIBE `cruiselines` 0.0018460750579834
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00034999847412109
(11) DESCRIBE `ships` 0.0034501552581787
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1138') 0.00042390823364258
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031208992004395
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(15) DESCRIBE `avid_specials` 0.00124192237854
(16) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1138 AND class = 'Ship') OR (item_id = 101 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.0012531280517578
(17) DESCRIBE `cruiselines` 0.0020029544830322
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00042581558227539
(19) DESCRIBE `orchid_image` 0.0018351078033447
(20) DESCRIBE `cruiselines` 0.0018129348754883
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00048995018005371
(22) DESCRIBE `ships` 0.002938985824585
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '888') 0.00037693977355957
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031495094299316
(26) DESCRIBE `avid_specials` 0.0012619495391846
(27) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 888 AND class = 'Ship') OR (item_id = 101 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.001194953918457
(28) DESCRIBE `cruiselines` 0.0019469261169434
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00035691261291504
(30) DESCRIBE `orchid_image` 0.0014469623565674
(31) DESCRIBE `cruiselines` 0.0019521713256836
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00029301643371582
(33) DESCRIBE `ships` 0.0025680065155029
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1318') 0.00051999092102051
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003509521484375
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032997131347656
(37) DESCRIBE `avid_specials` 0.001366138458252
(38) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1318 AND class = 'Ship') OR (item_id = 101 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.0011839866638184
(39) DESCRIBE `cruiselines` 0.0019340515136719
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00031709671020508
(41) DESCRIBE `orchid_image` 0.001413106918335
(42) DESCRIBE `cruiselines` 0.0017719268798828
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00027608871459961
(44) DESCRIBE `ships` 0.0026090145111084
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1139') 0.00029397010803223
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028586387634277
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026893615722656
(48) DESCRIBE `avid_specials` 0.0012578964233398
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1139 AND class = 'Ship') OR (item_id = 101 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.00099802017211914
(50) DESCRIBE `cruiselines` 0.0019271373748779
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00048112869262695
(52) DESCRIBE `orchid_image` 0.0017149448394775
(53) DESCRIBE `cruiselines` 0.0018260478973389
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00033783912658691
(55) DESCRIBE `ships` 0.0030641555786133
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00051093101501465
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035214424133301
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003361701965332
(59) DESCRIBE `avid_specials` 0.0017218589782715
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1594 AND class = 'Ship') OR (item_id = 101 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
(61) DESCRIBE `cruiselines` 0.0020408630371094
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00038814544677734
(63) DESCRIBE `orchid_image` 0.0015130043029785
(64) DESCRIBE `cruiselines` 0.0019969940185547
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00036311149597168
(66) DESCRIBE `ships` 0.0029458999633789
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00047993659973145
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(70) DESCRIBE `avid_specials` 0.0015110969543457
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1237 AND class = 'Ship') OR (item_id = 101 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.0011379718780518
(72) DESCRIBE `cruiselines` 0.0026450157165527
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.0004730224609375
(74) DESCRIBE `orchid_image` 0.00166916847229
(75) DESCRIBE `cruiselines` 0.0019850730895996
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00041985511779785
(77) DESCRIBE `ships` 0.0030210018157959
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '551') 0.00046992301940918
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027179718017578
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026106834411621
(81) DESCRIBE `avid_specials` 0.0014359951019287
(82) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 551 AND class = 'Ship') OR (item_id = 101 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.0011560916900635
(83) DESCRIBE `cruiselines` 0.0029001235961914
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00029897689819336
(85) DESCRIBE `orchid_image` 0.0014159679412842
(86) DESCRIBE `cruiselines` 0.0018138885498047
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00027990341186523
(88) DESCRIBE `ships` 0.0026588439941406
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1223') 0.00037002563476562
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048089027404785
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023198127746582
(92) DESCRIBE `avid_specials` 0.0013611316680908
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1223 AND class = 'Ship') OR (item_id = 101 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.001046895980835
(94) DESCRIBE `cruiselines` 0.0020041465759277
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00043106079101562
(96) DESCRIBE `orchid_image` 0.0016300678253174
(97) DESCRIBE `cruiselines` 0.0020039081573486
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00031208992004395
(99) DESCRIBE `ships` 0.0027248859405518
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1224') 0.00038886070251465
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003659725189209
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(103) DESCRIBE `avid_specials` 0.0011861324310303
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1224 AND class = 'Ship') OR (item_id = 101 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.0010251998901367
(105) DESCRIBE `cruiselines` 0.0018360614776611
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.0003969669342041
(107) DESCRIBE `orchid_image` 0.0013749599456787
(108) DESCRIBE `cruiselines` 0.001957893371582
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00032401084899902
(110) DESCRIBE `ships` 0.0032670497894287
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1818') 0.00034594535827637
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025081634521484
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(114) DESCRIBE `avid_specials` 0.0016498565673828
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1818 AND class = 'Ship') OR (item_id = 101 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.0011141300201416
(116) DESCRIBE `cruises` 0.0029771327972412
(117) SELECT `cruises`.* FROM `cruises` WHERE (id IN (10649, 34153, 34175, 34197, 38147, 38149, 40592, 40595, 45258, 45260)) ORDER BY FIND_IN_SET(id, '10649,34153,34175,34197,38147,38149,40592,40595,45258,45260') 0.0015578269958496
(118) DESCRIBE `cruiselines` 0.0022480487823486
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '8', '7', '131', '96', '171', '103', '33', '156', '120', '15', '262', '191', '29', '31', '258', '91', '208', '50', '28', '14', '187', '251', '114', '49', '212', '24', '47', '37', '206', '16', '153', '151', '36', '170', '110', '118', '181', '264', '195', '4', '30', '88', '59', '108', '159', '141', '140', '73', '35', '216', '90', '113', '147', '211', '57', '180', '64', '257', '261', '38', '48', '115', '276', '213', '184', '95', '105', '52', '82', '244', '209', '177', '134', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,144,183,12,23,20,101,18,8,7,131,96,171,103,33,156,120,15,262,191,29,31,258,91,208,50,28,14,187,251,114,49,212,24,47,37,206,16,153,151,36,170,110,118,181,264,195,4,30,88,59,108,159,141,140,73,35,216,90,113,147,211,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.0043351650238037
(120) DESCRIBE `ships` 0.002875804901123
(121) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '1744', '1588', '977', '517', '1594', '1555', '454', '1794', '1237', '780', '1272', '974', '1717', '1032', '1359', '258', '797', '1292', '22', '461', '21', '330', '770', '393', '404', '28', '1677', '986', '1348', '1205', '716', '1415', '349', '674', '333', '11', '10', '207', '739', '1067', '439', '521', '9', '715', '25', '24', '163', '738', '882', '3', '480', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '792', '1768', '265', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '285', '1163', '1410', '14', '1068', '1302', '1411', '1413', '1526', '314', '526', '748', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1417', '34', '38', '43', '327', '582', '854', '1063', '1259', '31', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1208', '1266', '678', '1139', '1157', '1492', '114', '1587', '1766', '401', '406', '850', '1245', '1318', '4', '335', '351', '451', '545', '616', '1028', '1412', '1672', '386', '704', '1461', '212', '547', '658', '1722', '39', '84', '722', '1236', '1326', '1327', '1782', '30', '35', '36', '148', '340', '403', '1012', '1040', '1289', '385', '988', '1330', '1398', '1408', '325', '601', '1108', '1303', '1575', '1711', '27', '287', '683', '966', '291', '652', '1043', '1172', '105', '201', '389', '508', '627', '639', '78', '818', '1168', '394', '1223', '111', '852', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '1740', '123', '290', '673', '1029', '1160', '1217', '1282', '1343', '1418', '1421', '1424', '1452', '1453', '1801', '1037', '1229', '1426', '1604', '266', '1373', '1405', '45', '348', '701', '1095', '1226', '1704', '559', '768', '905', '1137', '1283', '1358', '1809', '253', '972', '1136', '1448', '223', '1150', '69', '341', '574', '851', '968', '98', '151', '651', '709', '973', '1409', '324', '1055', '1724', '1808', '108', '150', '643', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '857', '858', '954', '996', '1714', '75', '663', '769', '885', '1035', '1042', '1206', '1632', '1751', '467', '884', '1154', '1360', '1361', '1368', '1459', '1574', '1609', '1708', '1723', '1750', '666', '1049', '1362', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '423', '790', '1051', '1681', '147', '703', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '375', '1054', '152', '422', '483', '516', '707', '1075', '1224', '1486', '1601', '81', '1047', '1052', '1445', '1676', '796', '886', '937', '1036', '1572', '1679', '93', '116', '1048', '1138', '1262', '1351', '1437', '1465', '1781', '1045', '1329', '1539', '1673', '74', '149', '420', '1519', '1807', '644', '1060', '1109', '1146', '1444', '1468', '198', '503', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '656', '1073', '1151', '1254', '1389', '1581', '1749', '1791', '795', '982', '1294', '1367', '1540', '1645', '1684', '1806', '452', '1064', '1140', '1800', '1816', '421', '761', '808', '1044', '1805', '493', '965', '1788', '479', '494', '687', '1297', '1624', '1674', '1706', '1053', '1158', '1241', '1626', '671', '883', '1156', '1195', '1316', '1571', '1709', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '1792', '299', '300', '685', '692', '1451')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,1744,1588,977,517,1594,1555,454,1794,1237,780,1272,974,1717,1032,1359,258,797,1292,22,461,21,330,770,393,404,28,1677,986,1348,1205,716,1415,349,674,333,11,10,207,739,1067,439,521,9,715,25,24,163,738,882,3,480,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,792,1768,265,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,285,1163,1410,14,1068,1302,1411,1413,1526,314,526,748,1320,1323,1579,855,286,390,405,573,970,1417,34,38,43,327,582,854,1063,1259,31,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1552,1284,1811,119,162,441,1159,1193,1208,1266,678,1139,1157,1492,114,1587,1766,401,406,850,1245,1318,4,335,351,451,545,616,1028,1412,1672,386,704,1461,212,547,658,1722,39,84,722,1236,1326,1327,1782,30,35,36,148,340,403,1012,1040,1289,385,988,1330,1398,1408,325,601,1108,1303,1575,1711,27,287,683,966,291,652,1043,1172,105,201,389,508,627,639,78,818,1168,394,1223,111,852,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,1740,123,290,673,1029,1160,1217,1282,1343,1418,1421,1424,1452,1453,1801,1037,1229,1426,1604,266,1373,1405,45,348,701,1095,1226,1704,559,768,905,1137,1283,1358,1809,253,972,1136,1448,223,1150,69,341,574,851,968,98,151,651,709,973,1409,324,1055,1724,1808,108,150,643,1230,1231,1458,1474,1501,1713,1730,1767,82,857,858,954,996,1714,75,663,769,885,1035,1042,1206,1632,1751,467,884,1154,1360,1361,1368,1459,1574,1609,1708,1723,1750,666,1049,1362,1772,1148,1322,1483,1771,665,888,944,423,790,1051,1681,147,703,717,784,1020,1071,1188,1293,1301,1580,70,375,1054,152,422,483,516,707,1075,1224,1486,1601,81,1047,1052,1445,1676,796,886,937,1036,1572,1679,93,116,1048,1138,1262,1351,1437,1465,1781,1045,1329,1539,1673,74,149,420,1519,1807,644,1060,1109,1146,1444,1468,198,503,1039,1050,1143,1196,1232,1350,205,419,656,1073,1151,1254,1389,1581,1749,1791,795,982,1294,1367,1540,1645,1684,1806,452,1064,1140,1800,1816,421,761,808,1044,1805,493,965,1788,479,494,687,1297,1624,1674,1706,1053,1158,1241,1626,671,883,1156,1195,1316,1571,1709,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1792,299,300,685,692,1451') 0.041959047317505
(122) DESCRIBE `cruisetypes` 0.0024399757385254
(123) DESCRIBE `destinations` 0.0030078887939453
(124) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '40', '48', '7', '29', '21', '45', '44', '30', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,2,37,8,39,53,26,28,38,49,55,11,40,48,7,29,21,45,44,30,34,10,52,46,56,32') 0.0034940242767334