or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • 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
  • 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 our fleet of authentic paddlewheelers, and the newest on U.S. rivers, the American Countess, offers many of the same exciting heartland...

    Star Rating River
  • American Queen Steamboat Company
    American Duchess

    American Duchess

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

    Star Rating River
  • American Queen Steamboat Company
    American Empress

    American Empress

    Proudly serving as the largest overnight riverboat west of the Mississippi River, the American Empress delivers classic elegance and modern luxury on a grand...

    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
 

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

# Query Time
(1) connect 0.0013442039489746
(2) DESCRIBE `ships` 0.005079984664917
(3) DESCRIBE `cruiselines` 0.016110897064209
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0010039806365967
(5) DESCRIBE `orchid_image` 0.0041248798370361
(6) DESCRIBE `cruiselines` 0.0094339847564697
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00064492225646973
(8) DESCRIBE `ships` 0.0061769485473633
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1427') 0.0010149478912354
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040411949157715
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0010449886322021
(12) DESCRIBE `avid_specials` 0.0051741600036621
(13) 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.0059449672698975
(14) DESCRIBE `cruiselines` 0.0030660629272461
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00084090232849121
(16) DESCRIBE `orchid_image` 0.015729904174805
(17) DESCRIBE `ships` 0.018126964569092
(18) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '872') 0.00055885314941406
(19) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038599967956543
(20) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040197372436523
(21) DESCRIBE `avid_specials` 0.0019199848175049
(22) 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.0055201053619385
(23) DESCRIBE `cruiselines` 0.010135889053345
(24) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00068092346191406
(25) DESCRIBE `orchid_image` 0.0043749809265137
(26) DESCRIBE `cruiselines` 0.014332056045532
(27) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00089502334594727
(28) DESCRIBE `ships` 0.0046250820159912
(29) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1373') 0.00074100494384766
(30) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041079521179199
(31) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003669261932373
(32) DESCRIBE `avid_specials` 0.0018119812011719
(33) 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.0019230842590332
(34) DESCRIBE `cruiselines` 0.0030059814453125
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00058603286743164
(36) DESCRIBE `orchid_image` 0.0022211074829102
(37) DESCRIBE `cruiselines` 0.0028660297393799
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.0004880428314209
(39) DESCRIBE `ships` 0.022919893264771
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1486') 0.00068497657775879
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037693977355957
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036191940307617
(43) DESCRIBE `avid_specials` 0.010019063949585
(44) 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.0027680397033691
(45) DESCRIBE `cruiselines` 0.0097451210021973
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00075793266296387
(47) DESCRIBE `orchid_image` 0.0026078224182129
(48) DESCRIBE `cruiselines` 0.0073540210723877
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00062799453735352
(50) DESCRIBE `ships` 0.0052261352539062
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1601') 0.00071287155151367
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038385391235352
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039911270141602
(54) DESCRIBE `avid_specials` 0.0021259784698486
(55) 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.0038619041442871
(56) DESCRIBE `cruiselines` 0.0032610893249512
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0019922256469727
(58) DESCRIBE `orchid_image` 0.0026340484619141
(59) DESCRIBE `cruiselines` 0.0037579536437988
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0010790824890137
(61) DESCRIBE `ships` 0.0084049701690674
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1791') 0.0011701583862305
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044012069702148
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044107437133789
(65) DESCRIBE `avid_specials` 0.010696172714233
(66) 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.0043249130249023
(67) DESCRIBE `cruiselines` 0.008997917175293
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00090599060058594
(69) DESCRIBE `orchid_image` 0.0042150020599365
(70) DESCRIBE `cruiselines` 0.0030009746551514
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00053215026855469
(72) DESCRIBE `ships` 0.0040369033813477
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.000701904296875
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036096572875977
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035810470581055
(76) DESCRIBE `avid_specials` 0.0019559860229492
(77) 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.0021231174468994
(78) DESCRIBE `cruiselines` 0.0053942203521729
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00068187713623047
(80) DESCRIBE `orchid_image` 0.0023999214172363
(81) DESCRIBE `cruiselines` 0.0032370090484619
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00053715705871582
(83) DESCRIBE `ships` 0.0053989887237549
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00056195259094238
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037002563476562
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041007995605469
(87) DESCRIBE `avid_specials` 0.0019850730895996
(88) 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.0026888847351074
(89) DESCRIBE `cruiselines` 0.011699914932251
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00083208084106445
(91) DESCRIBE `orchid_image` 0.0027449131011963
(92) DESCRIBE `cruiselines` 0.0031530857086182
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00085115432739258
(94) DESCRIBE `ships` 0.010884046554565
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1724') 0.00073003768920898
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038909912109375
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00084805488586426
(98) DESCRIBE `avid_specials` 0.0018470287322998
(99) 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.0022070407867432
(100) DESCRIBE `cruiselines` 0.012732028961182
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00084900856018066
(102) DESCRIBE `orchid_image` 0.0025911331176758
(103) DESCRIBE `cruiselines` 0.0037248134613037
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00058889389038086
(105) DESCRIBE `ships` 0.0039689540863037
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '954') 0.00059890747070312
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038504600524902
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00069499015808105
(109) DESCRIBE `avid_specials` 0.0018830299377441
(110) 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.0021238327026367
(111) DESCRIBE `cruises` 0.0069489479064941
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (23656, 34153, 34164, 34205, 34711, 38185, 44275, 44276, 46389, 47981)) ORDER BY FIND_IN_SET(id, '23656,34153,34164,34205,34711,38185,44275,44276,46389,47981') 0.0016350746154785
(113) DESCRIBE `cruiselines` 0.0042910575866699
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '183', '19', '23', '12', '7', '20', '131', '18', '8', '144', '171', '221', '31', '103', '101', '268', '15', '232', '156', '96', '258', '239', '50', '251', '29', '206', '33', '191', '114', '91', '212', '14', '24', '120', '28', '37', '187', '16', '170', '262', '49', '256', '36', '204', '110', '47', '208', '195', '240', '146', '220', '181', '153', '118', '174', '229', '30', '151', '88', '108', '128', '141', '159', '35', '216', '236', '168', '196', '4', '249', '38', '200', '264', '90', '211', '238', '73', '225', '140', '113', '147', '39', '275', '57', '132', '184', '59', '213', '48', '257', '64', '276', '261', '182', '219', '230', '115', '188', '237', '95', '180', '231', '248', '52', '116', '266', '209', '105', '82', '235', '244', '62', '134', '119', '177', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,26,183,19,23,12,7,20,131,18,8,144,171,221,31,103,101,268,15,232,156,96,258,239,50,251,29,206,33,191,114,91,212,14,24,120,28,37,187,16,170,262,49,256,36,204,110,47,208,195,240,146,220,181,153,118,174,229,30,151,88,108,128,141,159,35,216,236,168,196,4,249,38,200,264,90,211,238,73,225,140,113,147,39,275,57,132,184,59,213,48,257,64,276,261,182,219,230,115,188,237,95,180,231,248,52,116,266,209,105,82,235,244,62,134,119,177,210,224,245') 0.013268947601318
(115) DESCRIBE `ships` 0.0046870708465576
(116) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1324', '1555', '1272', '517', '1794', '780', '986', '974', '1032', '258', '1292', '22', '461', '21', '797', '393', '330', '28', '977', '207', '1599', '1205', '480', '349', '11', '10', '439', '1291', '737', '333', '1010', '9', '404', '739', '1199', '1588', '1135', '1417', '265', '726', '817', '1677', '14', '855', '24', '882', '25', '770', '454', '711', '1607', '3', '113', '731', '1067', '1481', '859', '1359', '1372', '34', '38', '31', '37', '657', '837', '378', '585', '1461', '1744', '985', '1237', '1768', '1239', '542', '1163', '66', '1526', '1413', '748', '390', '1320', '1411', '1579', '1323', '1402', '1424', '332', '526', '970', '1410', '1419', '1420', '1422', '1423', '1594', '43', '573', '327', '854', '1418', '1421', '582', '1773', '39', '407', '1012', '1454', '30', '36', '590', '958', '27', '1013', '1586', '674', '791', '792', '1284', '1415', '1308', '580', '1303', '1326', '1327', '84', '114', '1552', '441', '1183', '335', '455', '1184', '1587', '1682', '35', '1245', '1193', '1236', '1742', '386', '162', '1348', '160', '325', '722', '1412', '385', '639', '434', '521', '601', '1408', '1678', '81', '1168', '452', '683', '852', '857', '1172', '1215', '1382', '1501', '858', '1021', '1176', '775', '1019', '1289', '1376', '119', '1574', '78', '201', '338', '658', '1008', '1160', '1405', '1716', '285', '673', '766', '1159', '1217', '1229', '1604', '1373', '1426', '1782', '610', '776', '1095', '1226', '1743', '111', '462', '850', '1137', '1141', '1711', '69', '211', '644', '678', '1136', '1319', '1325', '1448', '163', '286', '1383', '1384', '1628', '45', '253', '520', '851', '1358', '403', '818', '266', '314', '651', '749', '1068', '1259', '1266', '1455', '151', '968', '1458', '1569', '1630', '451', '508', '1108', '1632', '348', '467', '626', '1516', '1572', '4', '150', '1302', '1330', '1360', '1361', '1362', '63', '324', '375', '405', '869', '966', '1260', '1368', '1459', '1627', '70', '148', '389', '421', '485', '616', '663', '768', '944', '1639', '1751', '1760', '116', '262', '291', '553', '885', '1064', '1148', '1517', '1562', '1672', '1708', '108', '1301', '1322', '123', '340', '1139', '1195', '1614', '1721', '124', '287', '1343', '1452', '1521', '1580', '1581', '98', '703', '784', '954', '1088', '1717', '198', '883', '1020', '152', '290', '1212', '1321', '1575', '1724', '635', '652', '1208', '1486', '1492', '1611', '1722', '1750', '1781', '516', '1344', '1601', '147', '483', '1615', '394', '401', '796', '1150', '1398', '1714', '1738', '341', '1143', '1231', '1269', '1437', '1445', '1522', '223', '406', '559', '1230', '1496', '1539', '1771', '1040', '1075', '1268', '149', '886', '1262', '1444', '1571', '1679', '1681', '547', '717', '1151', '1270', '1557', '1593', '1673', '1684', '545', '656', '704', '716', '1367', '982', '1254', '1318', '1676', '74', '105', '761', '1740', '1766', '494', '1043', '1073', '1514', '1518', '1645', '75', '205', '574', '1144', '1157', '1218', '1566', '1704', '1767', '751', '790', '1223', '1561', '1728', '715', '1027', '1029', '1063', '1213', '1389', '82', '351', '627', '795', '808', '1082', '1453', '1471', '1540', '93', '212', '687', '868', '1025', '1090', '1146', '1158', '1283', '1612', '1613', '1706', '1709', '1729', '1772', '479', '503', '823', '1055', '1713', '1715', '665', '905', '996', '1026', '1214', '1233', '1282', '1316', '1342', '1515', '1791', '493', '767', '1145', '1188', '1297', '1409', '1783', '884', '888', '973', '1034', '1089', '1149', '1156', '1341', '1351', '1366', '1404', '1609', '695', '707', '979', '988', '1024', '1049', '1155', '1196', '1216', '1222', '1345', '1647', '1710', '1730', '417', '666', '685', '920', '921', '927', '931', '1047', '1113', '1296', '1311', '1340', '1354', '1788')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1324,1555,1272,517,1794,780,986,974,1032,258,1292,22,461,21,797,393,330,28,977,207,1599,1205,480,349,11,10,439,1291,737,333,1010,9,404,739,1199,1588,1135,1417,265,726,817,1677,14,855,24,882,25,770,454,711,1607,3,113,731,1067,1481,859,1359,1372,34,38,31,37,657,837,378,585,1461,1744,985,1237,1768,1239,542,1163,66,1526,1413,748,390,1320,1411,1579,1323,1402,1424,332,526,970,1410,1419,1420,1422,1423,1594,43,573,327,854,1418,1421,582,1773,39,407,1012,1454,30,36,590,958,27,1013,1586,674,791,792,1284,1415,1308,580,1303,1326,1327,84,114,1552,441,1183,335,455,1184,1587,1682,35,1245,1193,1236,1742,386,162,1348,160,325,722,1412,385,639,434,521,601,1408,1678,81,1168,452,683,852,857,1172,1215,1382,1501,858,1021,1176,775,1019,1289,1376,119,1574,78,201,338,658,1008,1160,1405,1716,285,673,766,1159,1217,1229,1604,1373,1426,1782,610,776,1095,1226,1743,111,462,850,1137,1141,1711,69,211,644,678,1136,1319,1325,1448,163,286,1383,1384,1628,45,253,520,851,1358,403,818,266,314,651,749,1068,1259,1266,1455,151,968,1458,1569,1630,451,508,1108,1632,348,467,626,1516,1572,4,150,1302,1330,1360,1361,1362,63,324,375,405,869,966,1260,1368,1459,1627,70,148,389,421,485,616,663,768,944,1639,1751,1760,116,262,291,553,885,1064,1148,1517,1562,1672,1708,108,1301,1322,123,340,1139,1195,1614,1721,124,287,1343,1452,1521,1580,1581,98,703,784,954,1088,1717,198,883,1020,152,290,1212,1321,1575,1724,635,652,1208,1486,1492,1611,1722,1750,1781,516,1344,1601,147,483,1615,394,401,796,1150,1398,1714,1738,341,1143,1231,1269,1437,1445,1522,223,406,559,1230,1496,1539,1771,1040,1075,1268,149,886,1262,1444,1571,1679,1681,547,717,1151,1270,1557,1593,1673,1684,545,656,704,716,1367,982,1254,1318,1676,74,105,761,1740,1766,494,1043,1073,1514,1518,1645,75,205,574,1144,1157,1218,1566,1704,1767,751,790,1223,1561,1728,715,1027,1029,1063,1213,1389,82,351,627,795,808,1082,1453,1471,1540,93,212,687,868,1025,1090,1146,1158,1283,1612,1613,1706,1709,1729,1772,479,503,823,1055,1713,1715,665,905,996,1026,1214,1233,1282,1316,1342,1515,1791,493,767,1145,1188,1297,1409,1783,884,888,973,1034,1089,1149,1156,1341,1351,1366,1404,1609,695,707,979,988,1024,1049,1155,1196,1216,1222,1345,1647,1710,1730,417,666,685,920,921,927,931,1047,1113,1296,1311,1340,1354,1788') 0.069728851318359
(117) DESCRIBE `cruisetypes` 0.0023617744445801
(118) DESCRIBE `destinations` 0.0048980712890625
(119) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '9', '37', '43', '2', '8', '39', '44', '53', '55', '26', '28', '38', '49', '11', '21', '40', '7', '48', '56', '46', '30', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,9,37,43,2,8,39,44,53,55,26,28,38,49,11,21,40,7,48,56,46,30,29,45,34,10,52,32') 0.0080420970916748