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

 
 
 
  • 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
  • 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
  • American Cruise Lines
    America

    America

    The America is American Cruise Lines’ eighth ship and its second brand-new vessel to launch in 2016. America is the finest Mississippi paddlewheeler ever built,...

    Star Rating River
  • American Cruise Lines
    American Constellation

    American Constellation

    The American Constellation is the latest small coastal cruise ship from American Cruise Lines. Uniquely designed to navigate the inland waterways of the East Coast...

    Star Rating Specialty
  • American Cruise Lines
    American Constitution

    American Constitution

    The newly-announced American Constitution is scheduled to begin cruising the East Coast in spring of 2018. With a capacity of 175 passengers, the American Constitution...

    Star Rating Specialty
  • American Queen Steamboat Company
    American Countess

    American Countess

    The latest addition to the American Queen Steamboat Company’s fleet of authentic paddle wheelers, the American Countess, offers many of the same exciting heartland and...

    Star Rating River
  • American Queen Steamboat Company
    American Duchess

    American Duchess

    American Duchess was the first all-suite paddle wheeler on U.S. rivers, a floating, intimate masterpiece that can carry up to 166 guests through America's heartland....

    Star Rating River
  • American Queen Steamboat Company
    American Empress

    American Empress

    Proudly serving America’s western rivers, the American Empress delivers classic elegance and modern luxury on a grand scale. One step onboard and you will quickly...

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

# Query Time
(1) connect 0.0013530254364014
(2) DESCRIBE `ships` 0.0064599514007568
(3) DESCRIBE `cruiselines` 0.0044929981231689
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0010669231414795
(5) DESCRIBE `orchid_image` 0.0031280517578125
(6) DESCRIBE `cruiselines` 0.0039708614349365
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00068187713623047
(8) DESCRIBE `ships` 0.0052750110626221
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1478') 0.00077414512634277
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052785873413086
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051093101501465
(12) DESCRIBE `avid_specials` 0.0027060508728027
(13) 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.001680850982666
(14) DESCRIBE `cruiselines` 0.0031638145446777
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.000762939453125
(16) DESCRIBE `orchid_image` 0.0033440589904785
(17) DESCRIBE `cruiselines` 0.0039830207824707
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00064802169799805
(19) DESCRIBE `ships` 0.0054619312286377
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1322') 0.00096797943115234
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050497055053711
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050592422485352
(23) DESCRIBE `avid_specials` 0.002622127532959
(24) 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.0022189617156982
(25) DESCRIBE `cruiselines` 0.003978967666626
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00078892707824707
(27) DESCRIBE `orchid_image` 0.0031490325927734
(28) DESCRIBE `cruiselines` 0.0039548873901367
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00063705444335938
(30) DESCRIBE `ships` 0.0056078433990479
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1466') 0.00069904327392578
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050687789916992
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049400329589844
(34) DESCRIBE `avid_specials` 0.0027689933776855
(35) 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.002065896987915
(36) DESCRIBE `cruiselines` 0.0037188529968262
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00083088874816895
(38) DESCRIBE `orchid_image` 0.0029199123382568
(39) DESCRIBE `ships` 0.0044119358062744
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '872') 0.00046491622924805
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(43) DESCRIBE `avid_specials` 0.0017950534820557
(44) 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.0015528202056885
(45) DESCRIBE `cruiselines` 0.0040478706359863
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00066709518432617
(47) DESCRIBE `orchid_image` 0.0030701160430908
(48) DESCRIBE `cruiselines` 0.0041780471801758
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00065112113952637
(50) DESCRIBE `ships` 0.0053651332855225
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1373') 0.00069093704223633
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048589706420898
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00056099891662598
(54) DESCRIBE `avid_specials` 0.0025780200958252
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1373 AND class = 'Ship') OR (item_id = 103 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.0023448467254639
(56) DESCRIBE `cruiselines` 0.0042088031768799
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00049996376037598
(58) DESCRIBE `orchid_image` 0.0028190612792969
(59) DESCRIBE `cruiselines` 0.0034880638122559
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00045204162597656
(61) DESCRIBE `ships` 0.0037028789520264
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1486') 0.00052690505981445
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003669261932373
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00043416023254395
(65) DESCRIBE `avid_specials` 0.0017170906066895
(66) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1486 AND class = 'Ship') OR (item_id = 103 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.001107931137085
(67) DESCRIBE `cruiselines` 0.0031797885894775
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00062298774719238
(69) DESCRIBE `orchid_image` 0.0028650760650635
(70) DESCRIBE `cruiselines` 0.0030241012573242
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00066518783569336
(72) DESCRIBE `ships` 0.005295991897583
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1601') 0.00076103210449219
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00048518180847168
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046992301940918
(76) DESCRIBE `avid_specials` 0.0024101734161377
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1601 AND class = 'Ship') OR (item_id = 103 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.002112865447998
(78) DESCRIBE `cruiselines` 0.0039489269256592
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0006568431854248
(80) DESCRIBE `orchid_image` 0.0031230449676514
(81) DESCRIBE `cruiselines` 0.0040421485900879
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00061988830566406
(83) DESCRIBE `ships` 0.0054118633270264
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1791') 0.00095796585083008
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00069284439086914
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052714347839355
(87) DESCRIBE `avid_specials` 0.0020949840545654
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1791 AND class = 'Ship') OR (item_id = 212 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.0013020038604736
(89) DESCRIBE `cruiselines` 0.0027458667755127
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0005030632019043
(91) DESCRIBE `orchid_image` 0.0024349689483643
(92) DESCRIBE `cruiselines` 0.0030448436737061
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00046896934509277
(94) DESCRIBE `ships` 0.0046939849853516
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00066399574279785
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044703483581543
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038290023803711
(98) DESCRIBE `avid_specials` 0.0019960403442383
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1526 AND class = 'Ship') OR (item_id = 212 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.0019299983978271
(100) DESCRIBE `cruiselines` 0.0036149024963379
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00058984756469727
(102) DESCRIBE `orchid_image` 0.0025830268859863
(103) DESCRIBE `cruiselines` 0.0041332244873047
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00062918663024902
(105) DESCRIBE `ships` 0.0053708553314209
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00063586235046387
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047016143798828
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046491622924805
(109) DESCRIBE `avid_specials` 0.0023870468139648
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1163 AND class = 'Ship') OR (item_id = 212 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.0025079250335693
(111) DESCRIBE `cruises` 0.0046048164367676
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34151, 34171, 34192, 47265, 52232, 52645, 53647, 54751, 55527, 56672)) ORDER BY FIND_IN_SET(id, '34151,34171,34192,47265,52232,52645,53647,54751,55527,56672') 0.0026578903198242
(113) DESCRIBE `cruiselines` 0.0040709972381592
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '101', '31', '183', '8', '120', '131', '96', '29', '103', '206', '15', '91', '262', '24', '114', '33', '14', '156', '170', '28', '258', '191', '50', '153', '195', '37', '208', '49', '187', '16', '251', '36', '88', '47', '151', '216', '212', '141', '181', '118', '4', '110', '140', '59', '147', '261', '213', '48', '30', '211', '73', '276', '209', '159', '82', '95', '113', '57', '115', '90', '184', '244', '264', '108', '52', '180', '64', '105', '35', '38', '134', '245', '257')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,101,31,183,8,120,131,96,29,103,206,15,91,262,24,114,33,14,156,170,28,258,191,50,153,195,37,208,49,187,16,251,36,88,47,151,216,212,141,181,118,4,110,140,59,147,261,213,48,30,211,73,276,209,159,82,95,113,57,115,90,184,244,264,108,52,180,64,105,35,38,134,245,257') 0.0072288513183594
(115) DESCRIBE `ships` 0.0064609050750732
(116) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '1324', '258', '517', '1588', '780', '737', '1417', '871', '1717', '207', '855', '1766', '1572', '404', '1794', '454', '977', '770', '874', '1291', '1594', '1359', '1272', '1134', '66', '738', '1424', '22', '434', '1199', '21', '265', '330', '461', '393', '553', '1032', '332', '1768', '28', '716', '333', '974', '1260', '1419', '1423', '1422', '1292', '1418', '1420', '1421', '1682', '766', '1237', '521', '1348', '1415', '797', '715', '349', '585', '711', '455', '1678', '9', '674', '1132', '407', '792', '25', '439', '657', '11', '163', '739', '10', '1852', '857', '858', '1460', '1677', '542', '1501', '3', '24', '520', '1008', '1233', '1721', '1569', '1822', '34', '39', '966', '1505', '1811', '31', '36', '378', '1742', '1676', '35', '385', '1012', '1141', '1402', '1455', '626', '1168', '386', '768', '850', '986', '1302', '1372', '1373', '817', '1607', '98', '1413', '1282', '338', '451', '1319', '1410', '1773', '1782', '1411', '837', '1602', '113', '352', '547', '1259', '1733', '148', '573', '1021', '1145', '111', '160', '314', '508', '882', '883', '1398', '1437', '1454', '1574', '108', '285', '375', '1063', '1135', '1205', '1284', '627', '1149', '1308', '198', '610', '1722', '37', '1028', '1088', '1193', '340', '286', '748', '1067', '1068', '1808', '30', '63', '485', '526', '1323', '1810', '970', '1157', '1320', '1321', '1325', '1412', '1579', '1711', '327', '406', '1461', '1586', '1809', '43', '124', '348', '390', '394', '582', '854', '1492', '1724', '1801', '38', '462', '616', '82', '116', '223', '590', '1208', '1571', '1672', '1853', '1027', '1108', '1575', '652', '119', '351', '1318', '1408', '1738', '1820', '884', '114', '147', '944', '1139', '1266', '1486', '1587', '78', '678', '958', '1188', '75', '81', '149', '441', '683', '704', '791', '1772', '1326', '1327', '1771', '4', '70', '201', '291', '325', '545', '1367', '105', '287', '401', '423', '580', '601', '1037', '1043', '1151', '1289', '1330', '1757', '335', '658', '722', '776', '790', '818', '988', '1040', '1073', '1552', '162', '403', '651', '1019', '1704', '341', '389', '1013', '1172', '1236', '1539', '1223', '1303', '266', '1740', '290', '639', '751', '796', '1029', '1715', '1743', '1758', '45', '69', '123', '262', '852', '1035', '1160', '1163', '1206', '1344', '1426', '1474', '1526', '84', '972', '1146', '1150', '1217', '1226', '1229', '1338', '1452', '1453', '1540', '1604', '1716', '417', '673', '795', '1143', '1144', '1283', '1343', '1358', '1483', '1807', '1833', '405', '643', '775', '851', '905', '1048', '1136', '1293', '1448', '1681', '1746', '503', '574', '717', '968', '1042', '1045', '1159', '1230', '1231', '1262', '1787', '324', '467', '1026', '1051', '1137', '1573', '1749', '1791', '483', '635', '885', '1140', '1154', '1340', '1351', '1458', '1663', '1723', '1759', '1806', '663', '709', '954', '1224', '1366', '1368', '1459', '1609', '1632', '1751', '559', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1025', '1044', '1072', '1090', '1095', '1196', '1339', '1601', '1673', '1714', '1788', '1823', '448', '480', '886', '915', '916', '926', '930', '931', '1055', '1322', '1649', '1750', '1854', '208', '665', '703', '924', '1047', '1052', '1596', '1650', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1245', '1352', '1451', '1580', '1730', '151', '453', '937', '1109', '487', '672', '740', '888', '1152', '1256', '1301', '1409', '1449', '1519', '205', '671', '769', '821', '1232', '1294', '1445', '1816', '212', '516', '707', '1005', '1060', '1463', '1792', '1821', '93', '150', '420', '761', '932', '969', '1038', '1071', '1075', '1664', '74', '419')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,1324,258,517,1588,780,737,1417,871,1717,207,855,1766,1572,404,1794,454,977,770,874,1291,1594,1359,1272,1134,66,738,1424,22,434,1199,21,265,330,461,393,553,1032,332,1768,28,716,333,974,1260,1419,1423,1422,1292,1418,1420,1421,1682,766,1237,521,1348,1415,797,715,349,585,711,455,1678,9,674,1132,407,792,25,439,657,11,163,739,10,1852,857,858,1460,1677,542,1501,3,24,520,1008,1233,1721,1569,1822,34,39,966,1505,1811,31,36,378,1742,1676,35,385,1012,1141,1402,1455,626,1168,386,768,850,986,1302,1372,1373,817,1607,98,1413,1282,338,451,1319,1410,1773,1782,1411,837,1602,113,352,547,1259,1733,148,573,1021,1145,111,160,314,508,882,883,1398,1437,1454,1574,108,285,375,1063,1135,1205,1284,627,1149,1308,198,610,1722,37,1028,1088,1193,340,286,748,1067,1068,1808,30,63,485,526,1323,1810,970,1157,1320,1321,1325,1412,1579,1711,327,406,1461,1586,1809,43,124,348,390,394,582,854,1492,1724,1801,38,462,616,82,116,223,590,1208,1571,1672,1853,1027,1108,1575,652,119,351,1318,1408,1738,1820,884,114,147,944,1139,1266,1486,1587,78,678,958,1188,75,81,149,441,683,704,791,1772,1326,1327,1771,4,70,201,291,325,545,1367,105,287,401,423,580,601,1037,1043,1151,1289,1330,1757,335,658,722,776,790,818,988,1040,1073,1552,162,403,651,1019,1704,341,389,1013,1172,1236,1539,1223,1303,266,1740,290,639,751,796,1029,1715,1743,1758,45,69,123,262,852,1035,1160,1163,1206,1344,1426,1474,1526,84,972,1146,1150,1217,1226,1229,1338,1452,1453,1540,1604,1716,417,673,795,1143,1144,1283,1343,1358,1483,1807,1833,405,643,775,851,905,1048,1136,1293,1448,1681,1746,503,574,717,968,1042,1045,1159,1230,1231,1262,1787,324,467,1026,1051,1137,1573,1749,1791,483,635,885,1140,1154,1340,1351,1458,1663,1723,1759,1806,663,709,954,1224,1366,1368,1459,1609,1632,1751,559,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,666,914,921,923,927,1025,1044,1072,1090,1095,1196,1339,1601,1673,1714,1788,1823,448,480,886,915,916,926,930,931,1055,1322,1649,1750,1854,208,665,703,924,1047,1052,1596,1650,299,300,422,1004,1020,1036,1039,1054,1225,1245,1352,1451,1580,1730,151,453,937,1109,487,672,740,888,1152,1256,1301,1409,1449,1519,205,671,769,821,1232,1294,1445,1816,212,516,707,1005,1060,1463,1792,1821,93,150,420,761,932,969,1038,1071,1075,1664,74,419') 0.090910196304321
(117) DESCRIBE `cruisetypes` 0.0024199485778809
(118) DESCRIBE `destinations` 0.003957986831665
(119) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '2', '37', '9', '8', '44', '39', '55', '53', '26', '38', '28', '49', '40', '30', '11', '21', '45', '29', '7', '48', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,2,37,9,8,44,39,55,53,26,38,28,49,40,30,11,21,45,29,7,48,34,52,10,46,56,32') 0.0042839050292969