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

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

    American Harmony

    Coming in 2019, American Harmony, the second in a new series of modern riverboats, will make its debut on the Lower Mississippi River. Like her...

    Star Rating River
  • American Cruise Lines
    American Pride

    American Pride

    American Pride (previously Queen of the Mississippi) offers an unparalleled experience never before available on the Columbia and Snake Rivers. Aboard American Pride, guests will...

    Star Rating River
  • American Queen Steamboat Company
    American Queen

    American Queen

    As one of the largest steamboats ever built, the grand American Queen is a gracious and elegant triumph of American ingenuity. Although filled with...

    Star Rating 4 Star
 

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

# Query Time
(1) connect 0.0016388893127441
(2) DESCRIBE `ships` 0.0051689147949219
(3) DESCRIBE `cruiselines` 0.0040791034698486
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.0011639595031738
(5) DESCRIBE `orchid_image` 0.0028738975524902
(6) DESCRIBE `ships` 0.0056588649749756
(7) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '872') 0.00079703330993652
(8) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00094699859619141
(9) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005190372467041
(10) DESCRIBE `avid_specials` 0.0022280216217041
(11) 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.0020339488983154
(12) DESCRIBE `cruiselines` 0.0039589405059814
(13) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.0007171630859375
(14) DESCRIBE `orchid_image` 0.0031430721282959
(15) DESCRIBE `cruiselines` 0.0035221576690674
(16) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00060796737670898
(17) DESCRIBE `ships` 0.0050570964813232
(18) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1373') 0.00056600570678711
(19) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035881996154785
(20) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034189224243164
(21) DESCRIBE `avid_specials` 0.0016870498657227
(22) 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.0013601779937744
(23) DESCRIBE `cruiselines` 0.0031888484954834
(24) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00054788589477539
(25) DESCRIBE `orchid_image` 0.0033969879150391
(26) DESCRIBE `cruiselines` 0.005263090133667
(27) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00083708763122559
(28) DESCRIBE `ships` 0.0046360492706299
(29) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1486') 0.00060892105102539
(30) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00043201446533203
(31) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040292739868164
(32) DESCRIBE `avid_specials` 0.0021438598632812
(33) 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.0021388530731201
(34) DESCRIBE `cruiselines` 0.0039849281311035
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00062894821166992
(36) DESCRIBE `orchid_image` 0.0027680397033691
(37) DESCRIBE `cruiselines` 0.0034291744232178
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00055503845214844
(39) DESCRIBE `ships` 0.0047738552093506
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1601') 0.00060606002807617
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0004570484161377
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00067806243896484
(43) DESCRIBE `avid_specials` 0.002795934677124
(44) 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.0039849281311035
(45) DESCRIBE `cruiselines` 0.0060188770294189
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00093603134155273
(47) DESCRIBE `orchid_image` 0.00357985496521
(48) DESCRIBE `cruiselines` 0.0041470527648926
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00066399574279785
(50) DESCRIBE `ships` 0.0052299499511719
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1791') 0.00068807601928711
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003960132598877
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043201446533203
(54) DESCRIBE `avid_specials` 0.0023260116577148
(55) 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.0024080276489258
(56) DESCRIBE `cruiselines` 0.0036261081695557
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00081014633178711
(58) DESCRIBE `orchid_image` 0.003040075302124
(59) DESCRIBE `cruiselines` 0.0037200450897217
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00071501731872559
(61) DESCRIBE `ships` 0.0064220428466797
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00074005126953125
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00058197975158691
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050711631774902
(65) DESCRIBE `avid_specials` 0.0026919841766357
(66) 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.0018270015716553
(67) DESCRIBE `cruiselines` 0.0035290718078613
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00058579444885254
(69) DESCRIBE `orchid_image` 0.0026750564575195
(70) DESCRIBE `cruiselines` 0.0031659603118896
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00054788589477539
(72) DESCRIBE `ships` 0.0042049884796143
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00052404403686523
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040721893310547
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003509521484375
(76) DESCRIBE `avid_specials` 0.0019941329956055
(77) 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.001680850982666
(78) DESCRIBE `cruiselines` 0.0030450820922852
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00063204765319824
(80) DESCRIBE `orchid_image` 0.0028409957885742
(81) DESCRIBE `cruiselines` 0.0034918785095215
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00057601928710938
(83) DESCRIBE `ships` 0.0047860145568848
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1724') 0.00065207481384277
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045204162597656
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046205520629883
(87) DESCRIBE `avid_specials` 0.0023910999298096
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1724 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.0019340515136719
(89) DESCRIBE `cruiselines` 0.0034229755401611
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00077104568481445
(91) DESCRIBE `orchid_image` 0.0028131008148193
(92) DESCRIBE `cruiselines` 0.0040807723999023
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00063204765319824
(94) DESCRIBE `ships` 0.0051519870758057
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '954') 0.00058412551879883
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005028247833252
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035810470581055
(98) DESCRIBE `avid_specials` 0.0022578239440918
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 954 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.0015919208526611
(100) DESCRIBE `cruiselines` 0.0032110214233398
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00054311752319336
(102) DESCRIBE `orchid_image` 0.0025479793548584
(103) DESCRIBE `cruiselines` 0.0027921199798584
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00042581558227539
(105) DESCRIBE `ships` 0.003838062286377
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0008399486541748
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041103363037109
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037097930908203
(109) DESCRIBE `avid_specials` 0.0019509792327881
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1013 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.0013890266418457
(111) DESCRIBE `cruises` 0.0039279460906982
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (10649, 13509, 13510, 34157, 34181, 34203, 38122, 38147, 38149, 41318)) ORDER BY FIND_IN_SET(id, '10649,13509,13510,34157,34181,34203,38122,38147,38149,41318') 0.0019078254699707
(113) DESCRIBE `cruiselines` 0.0031290054321289
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '144', '183', '12', '23', '20', '101', '31', '18', '8', '131', '7', '120', '96', '171', '103', '156', '33', '15', '262', '29', '191', '258', '91', '50', '153', '16', '208', '28', '37', '14', '187', '114', '49', '251', '212', '24', '47', '141', '151', '206', '36', '110', '170', '118', '181', '4', '88', '264', '30', '195', '59', '108', '159', '73', '140', '35', '216', '90', '147', '113', '276', '180', '211', '95', '57', '52', '64', '257', '261', '115', '48', '184', '38', '213', '105', '82', '177', '244', '209', '134', '245')) ORDER BY FIND_IN_SET(id, '218,77,19,26,144,183,12,23,20,101,31,18,8,131,7,120,96,171,103,156,33,15,262,29,191,258,91,50,153,16,208,28,37,14,187,114,49,251,212,24,47,141,151,206,36,110,170,118,181,4,88,264,30,195,59,108,159,73,140,35,216,90,147,113,276,180,211,95,57,52,64,257,261,115,48,184,38,213,105,82,177,244,209,134,245') 0.0061938762664795
(115) DESCRIBE `ships` 0.0062971115112305
(116) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '1744', '732', '726', '517', '1588', '977', '1594', '1555', '1794', '454', '1237', '1717', '780', '1272', '974', '1359', '258', '1032', '797', '1424', '22', '461', '1292', '21', '330', '770', '393', '404', '28', '1677', '1419', '1423', '1420', '1422', '1348', '1418', '1421', '716', '986', '1205', '349', '1415', '333', '521', '674', '11', '1067', '10', '439', '715', '739', '9', '25', '837', '24', '738', '207', '455', '1607', '3', '882', '1260', '1678', '163', '480', '1135', '407', '113', '553', '1141', '1682', '1008', '1402', '1599', '1773', '434', '1768', '610', '766', '1455', '160', '792', '520', '352', '1742', '1569', '265', '332', '711', '817', '1454', '63', '66', '573', '1372', '626', '657', '1021', '1284', '1721', '1602', '462', '542', '285', '585', '1308', '883', '1163', '1302', '1413', '1526', '1738', '737', '1291', '1410', '1411', '314', '526', '1068', '1320', '1323', '1579', '14', '286', '390', '970', '1199', '1266', '43', '327', '582', '748', '854', '1259', '1063', '124', '405', '590', '31', '34', '38', '855', '1088', '1552', '1822', '37', '1013', '1586', '1811', '1463', '378', '635', '944', '1321', '1766', '791', '958', '1733', '119', '441', '1417', '1587', '70', '1193', '1208', '1492', '114', '162', '1245', '678', '1027', '1139', '1157', '4', '386', '401', '850', '1028', '1159', '69', '351', '406', '545', '580', '616', '1318', '1722', '658', '1412', '1672', '1782', '335', '704', '1289', '1461', '547', '1711', '340', '451', '722', '325', '385', '403', '1236', '1326', '1327', '1330', '212', '601', '683', '1108', '1233', '1408', '39', '84', '148', '627', '652', '1040', '1188', '1303', '1367', '1398', '30', '35', '36', '966', '1012', '1151', '1575', '508', '988', '1172', '27', '201', '287', '291', '389', '639', '818', '1043', '1168', '105', '394', '776', '78', '111', '341', '852', '1019', '1223', '1743', '262', '338', '1037', '1344', '1801', '123', '290', '485', '751', '775', '1217', '1282', '1426', '1715', '1716', '673', '701', '1143', '1144', '1160', '1325', '1343', '1452', '1453', '45', '266', '1029', '1226', '1229', '1405', '1604', '1740', '1809', '483', '1319', '1704', '348', '1095', '1358', '905', '1137', '1283', '1373', '968', '972', '1035', '1136', '1152', '1448', '223', '253', '559', '574', '768', '769', '1025', '1090', '1150', '1724', '1808', '151', '417', '651', '851', '1730', '98', '116', '709', '1026', '1045', '1351', '1474', '108', '324', '973', '1055', '1145', '1409', '150', '643', '663', '1206', '1230', '1231', '1458', '1713', '82', '885', '954', '1714', '1772', '1042', '1149', '1154', '1366', '1632', '1750', '1751', '1771', '467', '996', '1196', '1360', '1361', '1368', '1459', '1501', '1609', '1708', '1723', '666', '857', '858', '884', '1049', '1052', '1322', '1362', '1483', '1681', '208', '665', '1071', '1148', '1580', '423', '784', '790', '888', '1048', '1649', '703', '1051', '1293', '1301', '1574', '1020', '1140', '1352', '147', '1054', '1224', '1389', '1571', '1676', '75', '205', '375', '707', '1047', '1601', '152', '516', '886', '1036', '1039', '1075', '1445', '1486', '1758', '81', '422', '796', '1146', '1262', '1329', '1679', '671', '717', '1073', '1256', '1287', '1465', '1539', '1572', '1807', '93', '149', '672', '937', '1109', '1138', '1286', '1437', '1468', '1519', '1781', '503', '1050', '1350', '1371', '1673', '74', '420', '656', '743', '1232', '1444', '1749', '1791', '198', '821', '1044', '1060', '1254', '1294', '1540', '1806', '419', '795', '1663', '1816', '421', '644', '982', '1805', '744', '808', '965', '1645', '1684', '1788', '1823', '493', '494', '761', '969', '999', '1084', '1674', '1767', '1800', '1053', '1240', '1624', '1626', '1650', '452', '479', '687', '1156', '1158', '1241', '1297', '1581')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,1744,732,726,517,1588,977,1594,1555,1794,454,1237,1717,780,1272,974,1359,258,1032,797,1424,22,461,1292,21,330,770,393,404,28,1677,1419,1423,1420,1422,1348,1418,1421,716,986,1205,349,1415,333,521,674,11,1067,10,439,715,739,9,25,837,24,738,207,455,1607,3,882,1260,1678,163,480,1135,407,113,553,1141,1682,1008,1402,1599,1773,434,1768,610,766,1455,160,792,520,352,1742,1569,265,332,711,817,1454,63,66,573,1372,626,657,1021,1284,1721,1602,462,542,285,585,1308,883,1163,1302,1413,1526,1738,737,1291,1410,1411,314,526,1068,1320,1323,1579,14,286,390,970,1199,1266,43,327,582,748,854,1259,1063,124,405,590,31,34,38,855,1088,1552,1822,37,1013,1586,1811,1463,378,635,944,1321,1766,791,958,1733,119,441,1417,1587,70,1193,1208,1492,114,162,1245,678,1027,1139,1157,4,386,401,850,1028,1159,69,351,406,545,580,616,1318,1722,658,1412,1672,1782,335,704,1289,1461,547,1711,340,451,722,325,385,403,1236,1326,1327,1330,212,601,683,1108,1233,1408,39,84,148,627,652,1040,1188,1303,1367,1398,30,35,36,966,1012,1151,1575,508,988,1172,27,201,287,291,389,639,818,1043,1168,105,394,776,78,111,341,852,1019,1223,1743,262,338,1037,1344,1801,123,290,485,751,775,1217,1282,1426,1715,1716,673,701,1143,1144,1160,1325,1343,1452,1453,45,266,1029,1226,1229,1405,1604,1740,1809,483,1319,1704,348,1095,1358,905,1137,1283,1373,968,972,1035,1136,1152,1448,223,253,559,574,768,769,1025,1090,1150,1724,1808,151,417,651,851,1730,98,116,709,1026,1045,1351,1474,108,324,973,1055,1145,1409,150,643,663,1206,1230,1231,1458,1713,82,885,954,1714,1772,1042,1149,1154,1366,1632,1750,1751,1771,467,996,1196,1360,1361,1368,1459,1501,1609,1708,1723,666,857,858,884,1049,1052,1322,1362,1483,1681,208,665,1071,1148,1580,423,784,790,888,1048,1649,703,1051,1293,1301,1574,1020,1140,1352,147,1054,1224,1389,1571,1676,75,205,375,707,1047,1601,152,516,886,1036,1039,1075,1445,1486,1758,81,422,796,1146,1262,1329,1679,671,717,1073,1256,1287,1465,1539,1572,1807,93,149,672,937,1109,1138,1286,1437,1468,1519,1781,503,1050,1350,1371,1673,74,420,656,743,1232,1444,1749,1791,198,821,1044,1060,1254,1294,1540,1806,419,795,1663,1816,421,644,982,1805,744,808,965,1645,1684,1788,1823,493,494,761,969,999,1084,1674,1767,1800,1053,1240,1624,1626,1650,452,479,687,1156,1158,1241,1297,1581') 0.09333610534668
(117) DESCRIBE `cruisetypes` 0.0024960041046143
(118) DESCRIBE `destinations` 0.0038859844207764
(119) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '9', '43', '25', '37', '2', '8', '39', '53', '28', '38', '26', '44', '49', '11', '55', '40', '48', '7', '21', '29', '30', '45', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,9,43,25,37,2,8,39,53,28,38,26,44,49,11,55,40,48,7,21,29,30,45,34,10,52,46,56,32') 0.0039761066436768