or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • 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 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
  • American Queen Steamboat Company
    American Queen

    American Queen

    The largest steamboat ever built, the grand American Queen is a gracious and elegant triumph of American ingenuity.

    Although filled with today’s modern amenities, her rooms...

    Star Rating 4 Star
  • American Cruise Lines
    American Song

    American Song

    With a capacity of 190 guests, the new line of modern riverboats from American Cruise Lines were developed to exceed all guest expectations. Carefully crafted,...

    Star Rating River
  • American Cruise Lines
    American Spirit

    American Spirit

    Small ship cruising with American Cruise Lines is not like cruising on a mega-ship for days on the open sea. Small ships, like the American...

    Star Rating 2 Star
  • American Cruise Lines
    American Star

    American Star

    American Star entered service in June 2007. Similar to the American Spirit, it will offer guests the same unique style of cruising that has become...

    Star Rating 2 Star
  • Holland America Line
    Amsterdam

    Amsterdam

    The ms Amsterdam is the third ship to bear the name of the Dutch capital in Holland America Line's over 135-year history. Built at the...

    Star Rating 5 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: 121

Total elapsed time: 0.19509744644165

# Query Time
(1) connect 0.00087404251098633
(2) DESCRIBE `ships` 0.0045218467712402
(3) DESCRIBE `cruiselines` 0.0023798942565918
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00066184997558594
(5) DESCRIBE `orchid_image` 0.002392053604126
(6) DESCRIBE `cruiselines` 0.0027430057525635
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00050902366638184
(8) DESCRIBE `ships` 0.0032079219818115
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1601') 0.00048398971557617
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036382675170898
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032496452331543
(12) DESCRIBE `avid_specials` 0.0015571117401123
(13) 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.0015928745269775
(14) DESCRIBE `cruiselines` 0.0024471282958984
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00047016143798828
(16) DESCRIBE `orchid_image` 0.0019831657409668
(17) DESCRIBE `cruiselines` 0.0022180080413818
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00040698051452637
(19) DESCRIBE `ships` 0.0029618740081787
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00045180320739746
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(23) DESCRIBE `avid_specials` 0.0017218589782715
(24) 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.0013899803161621
(25) DESCRIBE `cruiselines` 0.0019280910491943
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00036001205444336
(27) DESCRIBE `orchid_image` 0.0015759468078613
(28) DESCRIBE `cruiselines` 0.0017950534820557
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00069308280944824
(30) DESCRIBE `ships` 0.0026280879974365
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00068879127502441
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034189224243164
(34) DESCRIBE `avid_specials` 0.0017800331115723
(35) 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.0010299682617188
(36) DESCRIBE `cruiselines` 0.001957893371582
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00034499168395996
(38) DESCRIBE `orchid_image` 0.0015838146209717
(39) DESCRIBE `cruiselines` 0.0018060207366943
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00037407875061035
(41) DESCRIBE `ships` 0.0025970935821533
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1724') 0.00032997131347656
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(45) DESCRIBE `avid_specials` 0.0011208057403564
(46) 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.0010139942169189
(47) DESCRIBE `cruiselines` 0.0019309520721436
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.0003349781036377
(49) DESCRIBE `orchid_image` 0.0014498233795166
(50) DESCRIBE `cruiselines` 0.0017809867858887
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00029897689819336
(52) DESCRIBE `ships` 0.0038251876831055
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '954') 0.00036191940307617
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025391578674316
(56) DESCRIBE `avid_specials` 0.001201868057251
(57) 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.0010678768157959
(58) DESCRIBE `cruiselines` 0.0020759105682373
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00050997734069824
(60) DESCRIBE `orchid_image` 0.0015549659729004
(61) DESCRIBE `cruiselines` 0.0020101070404053
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00039315223693848
(63) DESCRIBE `ships` 0.0030310153961182
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0003359317779541
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028705596923828
(67) DESCRIBE `avid_specials` 0.0013480186462402
(68) 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.0011990070343018
(69) DESCRIBE `cruiselines` 0.0021460056304932
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00038599967956543
(71) DESCRIBE `orchid_image` 0.0016441345214844
(72) DESCRIBE `cruiselines` 0.0018739700317383
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00030088424682617
(74) DESCRIBE `ships` 0.0025820732116699
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1632') 0.00029897689819336
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027680397033691
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(78) DESCRIBE `avid_specials` 0.0023128986358643
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1632 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.0010218620300293
(80) DESCRIBE `cruiselines` 0.0018868446350098
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00032806396484375
(82) DESCRIBE `orchid_image` 0.0014030933380127
(83) DESCRIBE `cruiselines` 0.0018041133880615
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00030899047851562
(85) DESCRIBE `ships` 0.0025601387023926
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '467') 0.00027585029602051
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.0002751350402832
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00025105476379395
(89) DESCRIBE `avid_specials` 0.0011560916900635
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 467 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.0010170936584473
(91) DESCRIBE `cruiselines` 0.0018751621246338
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00035214424133301
(93) DESCRIBE `orchid_image` 0.0013840198516846
(94) DESCRIBE `cruiselines` 0.0017988681793213
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00031685829162598
(96) DESCRIBE `ships` 0.003342866897583
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '639') 0.00031208992004395
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00027298927307129
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00025391578674316
(100) DESCRIBE `avid_specials` 0.0011298656463623
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 639 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.0010628700256348
(102) DESCRIBE `cruiselines` 0.0018019676208496
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00034093856811523
(104) DESCRIBE `orchid_image` 0.0013799667358398
(105) DESCRIBE `cruiselines` 0.0017969608306885
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00029397010803223
(107) DESCRIBE `ships` 0.0025649070739746
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '74') 0.00032901763916016
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026297569274902
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025081634521484
(111) DESCRIBE `avid_specials` 0.0011160373687744
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74 AND class = 'Ship') OR (item_id = 18 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.0010619163513184
(113) DESCRIBE `cruises` 0.0027759075164795
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (15922, 27131, 32348, 34155, 38581, 38675, 38682, 40897, 40967, 41316)) ORDER BY FIND_IN_SET(id, '15922,27131,32348,34155,38581,38675,38682,40897,40967,41316') 0.001039981842041
(115) DESCRIBE `cruiselines` 0.001924991607666
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '171', '23', '144', '18', '31', '20', '101', '8', '183', '96', '12', '120', '191', '50', '103', '221', '29', '15', '33', '268', '37', '156', '28', '91', '262', '114', '110', '141', '131', '208', '153', '187', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '204', '4', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '264', '90', '195', '216', '188', '182', '261', '136', '146', '159', '213', '237', '211', '115', '168', '196', '180', '73', '209', '57', '95', '248', '59', '219', '52', '184', '231', '170', '225', '229', '108', '88', '230', '276', '82', '244', '132', '269', '105', '275', '48', '119', '240', '116', '64', '266', '38', '134', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,171,23,144,18,31,20,101,8,183,96,12,120,191,50,103,221,29,15,33,268,37,156,28,91,262,114,110,141,131,208,153,187,14,232,24,118,49,181,258,151,36,212,30,206,140,204,4,256,238,249,220,16,239,47,174,113,35,264,90,195,216,188,182,261,136,146,159,213,237,211,115,168,196,180,73,209,57,95,248,59,219,52,184,231,170,225,229,108,88,230,276,82,244,132,269,105,275,48,119,240,116,64,266,38,134,224,210') 0.0048418045043945
(117) DESCRIBE `ships` 0.002953052520752
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '977', '1199', '1247', '1554', '1555', '1291', '1359', '1272', '1588', '1067', '1237', '1599', '407', '258', '1594', '27', '22', '21', '461', '28', '37', '38', '34', '378', '31', '393', '726', '817', '1424', '349', '1135', '30', '1012', '36', '39', '1422', '780', '1419', '1423', '1420', '1421', '1418', '35', '1415', '462', '113', '404', '452', '1677', '24', '766', '265', '1405', '11', '439', '1245', '711', '10', '330', '1215', '1574', '9', '585', '455', '542', '1141', '674', '124', '739', '770', '635', '1572', '1607', '5', '792', '797', '207', '1460', '3', '573', '974', '116', '340', '520', '553', '1454', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1284', '1302', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '1068', '582', '1323', '434', '1260', '421', '559', '993', '1259', '1575', '327', '590', '883', '1586', '81', '286', '970', '1678', '119', '406', '526', '678', '78', '854', '1571', '375', '616', '14', '454', '722', '850', '855', '1236', '1492', '547', '823', '1266', '1569', '114', '405', '1008', '1064', '1139', '1208', '1308', '84', '441', '403', '784', '732', '1319', '1330', '1348', '1437', '348', '657', '966', '1088', '1108', '1282', '1587', '1672', '111', '163', '652', '1321', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1027', '1159', '1243', '1376', '148', '351', '683', '1151', '1471', '1526', '314', '483', '1013', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '291', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '149', '335', '716', '743', '852', '968', '1063', '1168', '1233', '1413', '1604', '152', '610', '818', '884', '1223', '1303', '1345', '1452', '1453', '1581', '1711', '82', '401', '669', '769', '1025', '1043', '1090', '1136', '1145', '1283', '1301', '1373', '1552', '45', '150', '151', '352', '790', '796', '1241', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1226', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1150', '1448', '1463', '266', '1409', '1449', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1055', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1049', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '493', '1037', '1470', '1474', '1580', '1627', '618', '836', '1224', '1444', '1518', '423', '837', '1176', '1382', '1417', '1521', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1138', '1196', '1262', '1593', '672', '709', '857', '1054', '1148', '1445', '1486', '1517', '1522', '1619', '671', '717', '972', '1017', '1042', '1051', '1352', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1053', '1134', '1384', '1481', '1628', '313', '420', '982', '1028', '1322', '1358', '1383', '1501', '1515', '1676', '453', '749', '937', '958', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1071', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1189', '1232', '1274', '1293', '1297', '1338', '1355', '1035', '1048', '1679', '1681', '1697', '70', '212', '288', '1060', '1089')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,977,1199,1247,1554,1555,1291,1359,1272,1588,1067,1237,1599,407,258,1594,27,22,21,461,28,37,38,34,378,31,393,726,817,1424,349,1135,30,1012,36,39,1422,780,1419,1423,1420,1421,1418,35,1415,462,113,404,452,1677,24,766,265,1405,11,439,1245,711,10,330,1215,1574,9,585,455,542,1141,674,124,739,770,635,1572,1607,5,792,797,207,1460,3,573,974,116,340,520,553,1454,25,1372,1455,160,1193,874,517,580,1021,1284,1302,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,1068,582,1323,434,1260,421,559,993,1259,1575,327,590,883,1586,81,286,970,1678,119,406,526,678,78,854,1571,375,616,14,454,722,850,855,1236,1492,547,823,1266,1569,114,405,1008,1064,1139,1208,1308,84,441,403,784,732,1319,1330,1348,1437,348,657,966,1088,1108,1282,1587,1672,111,163,652,1321,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1027,1159,1243,1376,148,351,683,1151,1471,1526,314,483,1013,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,291,673,768,1040,1137,1144,1157,1343,98,149,335,716,743,852,968,1063,1168,1233,1413,1604,152,610,818,884,1223,1303,1345,1452,1453,1581,1711,82,401,669,769,1025,1043,1090,1136,1145,1283,1301,1373,1552,45,150,151,352,790,796,1241,201,223,485,776,882,1160,1717,59,108,467,503,1152,1226,1539,1738,324,341,639,905,988,1149,1150,1448,1463,266,1409,1449,1540,417,871,885,1253,1411,1647,105,601,811,1055,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1049,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,493,1037,1470,1474,1580,1627,618,836,1224,1444,1518,423,837,1176,1382,1417,1521,1229,1404,1407,1410,1716,204,422,643,985,1138,1196,1262,1593,672,709,857,1054,1148,1445,1486,1517,1522,1619,671,717,972,1017,1042,1051,1352,1713,1715,781,994,1175,1714,479,480,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1053,1134,1384,1481,1628,313,420,982,1028,1322,1358,1383,1501,1515,1676,453,749,937,958,1439,1461,1645,1708,1743,775,999,1052,1071,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1189,1232,1274,1293,1297,1338,1355,1035,1048,1679,1681,1697,70,212,288,1060,1089') 0.040711879730225
(119) DESCRIBE `cruisetypes` 0.0017130374908447
(120) DESCRIBE `destinations` 0.0019469261169434
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '40', '26', '38', '11', '7', '30', '48', '21', '49', '45', '44', '56', '29', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,39,55,28,40,26,38,11,7,30,48,21,49,45,44,56,29,34,10,52,46,32') 0.0026869773864746