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

 
 
 
  • Pandaw Cruises
    Sabaidee Pandaw

    Sabaidee Pandaw

    The RV Sabaidee is our seventeenth ship to the Pandaw Flotilla which was constructed to meet demand on our very popular Laos to China route...

    Star Rating River
  • UnCruise Adventures
    Safari Endeavour

    Safari Endeavour

    The ambience aboard the 86-guest Safari Endeavour is casual elegance with a full menu of upscale amenities. Its new design is exquisitely appointed with features...

    Star Rating Specialty
  • UnCruise Adventures
    Safari Explorer

    Safari Explorer

    The Safari Explorer, our flagship, is a 36-guest luxury yacht perfectly designed for "luxury in the pursuit of adventure." Features include an intimate Wine Library...

    Star Rating Specialty
  • UnCruise Adventures
    Safari Quest

    Safari Quest

    Aboard the 22-guest Safari Quest, unwind with upscale amenities, attentive service, comfortable staterooms, and warm public spaces for a welcome experience. Guests enjoy the casually...

    Star Rating 5 Star
  • UnCruise Adventures
    Safari Voyager

    Safari Voyager

    Currently undergoing extensive renovations, the 64-guest Safari Voyager offers personal comforts, included amenities, exclusivity, and luxury accommodations. Guests will enjoy breathtaking views from four public...

    Star Rating Specialty
  • APT
    Samatha

    Samatha

    APT’s brand-new boutique river ship, the RV Samatha, takes luxury river cruising to a new level. Join us aboard the finest vessel to grace the...

    Star Rating River
  • APT
    Sanctuary Yangzi Explorer

    Sanctuary Yangzi Explorer

    The Sanctuary Yangzi Explorer is the smallest, most exclusive and most luxurious ship cruising the Yangtze River. It offers the level of intimacy, facilities, comfort...

    Star Rating River
  • Uniworld Boutique River Cruises
    Sanctuary Yangzi Explorer

    Sanctuary Yangzi Explorer

    The newest ship on the Yangtze is a sanctuary of lavish features, with the largest cabins and suites on the river—all with private balconies, and...

    Star Rating River
  • Uniworld Boutique River Cruises
    Sao Gabriel

    Sao Gabriel

    Debuting on March 26, 2020, S.S. São Gabriel will be the newest ship on the Douro river. Designed to embody the beautiful Douro River Valley...

    Star Rating River
  • Tauck
    Sapphire

    Sapphire

    One of the 361-foot (110-meter) riverboats in Tauck's Destination Fleet, this newly redesigned riverboat debuts in 2017 with a new deck plan optimized for the...

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

Total elapsed time: 0.26771354675293

# Query Time
(1) connect 0.0011940002441406
(2) DESCRIBE `ships` 0.0061399936676025
(3) DESCRIBE `cruiselines` 0.0041658878326416
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00088405609130859
(5) DESCRIBE `orchid_image` 0.0020959377288818
(6) DESCRIBE `cruiselines` 0.0025260448455811
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0004570484161377
(8) DESCRIBE `ships` 0.0035941600799561
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1664') 0.00052285194396973
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040888786315918
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034284591674805
(12) DESCRIBE `avid_specials` 0.0018630027770996
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1664 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.0011460781097412
(14) DESCRIBE `cruiselines` 0.0025870800018311
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00050210952758789
(16) DESCRIBE `orchid_image` 0.0021789073944092
(17) DESCRIBE `cruiselines` 0.0032651424407959
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00045895576477051
(19) DESCRIBE `ships` 0.0039079189300537
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '988') 0.00045990943908691
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035500526428223
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040292739868164
(23) DESCRIBE `avid_specials` 0.0016791820526123
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 988 AND class = 'Ship') OR (item_id = 208 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.0011281967163086
(25) DESCRIBE `cruiselines` 0.002593994140625
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00044584274291992
(27) DESCRIBE `orchid_image` 0.0019938945770264
(28) DESCRIBE `cruiselines` 0.0026628971099854
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00040602684020996
(30) DESCRIBE `ships` 0.0035800933837891
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '704') 0.0003659725189209
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041794776916504
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038814544677734
(34) DESCRIBE `avid_specials` 0.0015950202941895
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 704 AND class = 'Ship') OR (item_id = 208 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.0012059211730957
(36) DESCRIBE `cruiselines` 0.0024619102478027
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.0004429817199707
(38) DESCRIBE `orchid_image` 0.0019989013671875
(39) DESCRIBE `cruiselines` 0.0024418830871582
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00039196014404297
(41) DESCRIBE `ships` 0.0034170150756836
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '666') 0.00037693977355957
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037622451782227
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(45) DESCRIBE `avid_specials` 0.0016670227050781
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 666 AND class = 'Ship') OR (item_id = 208 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.0011038780212402
(47) DESCRIBE `cruiselines` 0.0027780532836914
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00062084197998047
(49) DESCRIBE `orchid_image` 0.0027868747711182
(50) DESCRIBE `cruiselines` 0.0030081272125244
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00049304962158203
(52) DESCRIBE `ships` 0.0040278434753418
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1109') 0.00042295455932617
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035881996154785
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040388107299805
(56) DESCRIBE `avid_specials` 0.0018510818481445
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1109 AND class = 'Ship') OR (item_id = 208 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.0012118816375732
(58) DESCRIBE `cruiselines` 0.0027840137481689
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00069284439086914
(60) DESCRIBE `orchid_image` 0.0031299591064453
(61) DESCRIBE `cruiselines` 0.0040011405944824
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00059819221496582
(63) DESCRIBE `ships` 0.0049309730529785
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1299') 0.00063300132751465
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035691261291504
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036716461181641
(67) DESCRIBE `avid_specials` 0.0019412040710449
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1299 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.0011439323425293
(69) DESCRIBE `cruiselines` 0.0028150081634521
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00043916702270508
(71) DESCRIBE `orchid_image` 0.0021169185638428
(72) DESCRIBE `cruiselines` 0.0027320384979248
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00039792060852051
(74) DESCRIBE `ships` 0.0035860538482666
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '987') 0.00038814544677734
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041294097900391
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(78) DESCRIBE `avid_specials` 0.0021028518676758
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 987 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.0011160373687744
(80) DESCRIBE `cruiselines` 0.0026009082794189
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00042200088500977
(82) DESCRIBE `orchid_image` 0.0020461082458496
(83) DESCRIBE `cruiselines` 0.0031499862670898
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.0005040168762207
(85) DESCRIBE `ships` 0.005216121673584
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1732') 0.0005800724029541
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049805641174316
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005030632019043
(89) DESCRIBE `avid_specials` 0.0024299621582031
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1732 AND class = 'Ship') OR (item_id = 96 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.0018022060394287
(91) DESCRIBE `cruiselines` 0.0025370121002197
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.0004878044128418
(93) DESCRIBE `orchid_image` 0.002180814743042
(94) DESCRIBE `cruiselines` 0.0031869411468506
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00047993659973145
(96) DESCRIBE `ships` 0.0038039684295654
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1806') 0.00047111511230469
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034880638122559
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033688545227051
(100) DESCRIBE `avid_specials` 0.0017490386962891
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1806 AND class = 'Ship') OR (item_id = 96 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.001115083694458
(102) DESCRIBE `cruiselines` 0.0025169849395752
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00041103363037109
(104) DESCRIBE `orchid_image` 0.0020589828491211
(105) DESCRIBE `cruiselines` 0.0024590492248535
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.00038695335388184
(107) DESCRIBE `ships` 0.0034980773925781
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '672') 0.00040316581726074
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039386749267578
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(111) DESCRIBE `avid_specials` 0.0019409656524658
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 672 AND class = 'Ship') OR (item_id = 153 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.0013139247894287
(113) DESCRIBE `cruises` 0.005234956741333
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (289, 11516, 21383, 27115, 29614, 34151, 36659, 38574, 38578, 39686)) ORDER BY FIND_IN_SET(id, '289,11516,21383,27115,29614,34151,36659,38574,38578,39686') 0.0025360584259033
(115) DESCRIBE `cruiselines` 0.0030350685119629
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '183', '7', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '91', '206', '33', '170', '262', '114', '24', '28', '14', '156', '50', '191', '258', '195', '37', '16', '153', '208', '187', '36', '49', '47', '88', '216', '251', '141', '151', '212', '181', '4', '110', '118', '59', '30', '264', '140', '73', '115', '48', '147', '159', '261', '108', '213', '209', '276', '211', '113', '90', '38', '57', '82', '184', '35', '95', '180', '52', '244', '105', '64', '134', '172', '257', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,183,7,18,101,8,120,31,131,29,96,15,103,91,206,33,170,262,114,24,28,14,156,50,191,258,195,37,16,153,208,187,36,49,47,88,216,251,141,151,212,181,4,110,118,59,30,264,140,73,115,48,147,159,261,108,213,209,276,211,113,90,38,57,82,184,35,95,180,52,244,105,64,134,172,257,245,177') 0.007951021194458
(117) DESCRIBE `ships` 0.0057330131530762
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1744', '732', '517', '726', '737', '258', '1417', '780', '855', '1717', '1588', '207', '1324', '1291', '1794', '874', '1594', '1199', '454', '871', '977', '1572', '1359', '1272', '404', '1766', '974', '1237', '22', '330', '461', '770', '21', '1032', '393', '716', '797', '1292', '1424', '28', '66', '1682', '434', '521', '1348', '553', '738', '1134', '332', '333', '711', '265', '349', '766', '1415', '792', '857', '858', '1423', '1501', '11', '1260', '1422', '9', '1419', '1420', '1768', '10', '585', '739', '1421', '34', '439', '1418', '1677', '25', '31', '36', '378', '407', '163', '455', '715', '1678', '24', '542', '1205', '3', '674', '1132', '657', '39', '1460', '1607', '1141', '837', '882', '1008', '1721', '1067', '520', '1402', '1773', '1302', '385', '1569', '1574', '1742', '35', '386', '1012', '113', '966', '1135', '37', '850', '1372', '1554', '1555', '63', '160', '1168', '1852', '573', '610', '30', '1233', '1454', '338', '626', '1319', '1602', '98', '768', '986', '1021', '1455', '1822', '285', '1505', '1811', '38', '451', '503', '1373', '1676', '1284', '352', '1398', '1413', '1259', '1411', '1733', '111', '547', '1410', '148', '198', '817', '1088', '1193', '43', '108', '286', '314', '406', '1282', '375', '748', '1722', '116', '526', '1320', '1323', '1437', '1579', '1782', '340', '970', '1108', '1308', '508', '1266', '1738', '327', '627', '854', '1325', '1711', '124', '390', '480', '582', '1586', '1808', '590', '1028', '1063', '1571', '485', '1145', '1552', '348', '394', '883', '119', '944', '1149', '1208', '1321', '1412', '1492', '1724', '335', '616', '791', '462', '658', '704', '1245', '1575', '1587', '70', '75', '114', '223', '1672', '1068', '4', '82', '441', '652', '1027', '1810', '69', '351', '405', '545', '1157', '1289', '147', '678', '1461', '1809', '162', '325', '683', '722', '1801', '401', '958', '1318', '1408', '78', '403', '884', '1330', '1463', '1853', '105', '201', '291', '601', '988', '1303', '149', '287', '341', '1188', '1236', '262', '389', '651', '1820', '776', '790', '818', '1159', '1367', '1526', '1539', '123', '483', '580', '1013', '1073', '1139', '1151', '1486', '1540', '81', '1019', '1037', '1172', '266', '423', '673', '1704', '1772', '639', '1326', '1327', '1573', '1730', '1771', '290', '1743', '45', '574', '635', '796', '968', '1043', '1426', '1474', '1757', '644', '852', '1035', '1040', '1160', '1217', '1715', '84', '751', '775', '795', '1344', '1681', '1716', '1095', '1143', '1144', '1358', '1405', '1452', '1453', '212', '324', '717', '1223', '1226', '1229', '1338', '1343', '1604', '972', '1048', '1163', '1283', '1409', '1663', '1740', '709', '905', '1029', '1045', '1449', '1758', '14', '151', '665', '1137', '1206', '1647', '885', '1146', '1150', '1152', '1448', '1673', '417', '643', '701', '1136', '1262', '1351', '1483', '1807', '1833', '150', '769', '851', '1025', '1090', '1109', '1293', '1746', '707', '973', '1026', '1042', '1230', '1231', '1750', '1787', '208', '448', '453', '467', '1051', '1052', '1140', '1322', '1329', '1749', '1791', '253', '740', '1055', '1071', '1154', '1196', '1340', '1458', '1519', '1599', '1649', '1713', '1723', '1751', '1759', '1806', '663', '954', '1044', '1049', '1224', '1366', '1368', '1459', '1580', '1609', '1632', '1714', '1816', '27', '559', '666', '784', '920', '996', '1050', '1148', '1274', '1294', '1354', '1360', '1361', '1362', '1389', '1601', '1708', '1805', '205', '886', '914', '921', '923', '927', '1047', '1072', '1339', '1350', '1352', '1788', '1823', '93', '915', '916', '926', '930', '931', '1036', '1301', '1854', '479', '703', '888', '924', '965', '1039', '1596', '1650', '1664', '1674', '1679', '299', '300', '422', '1004', '1020', '1054', '1225', '1451', '1468', '1626', '937', '1445')) ORDER BY FIND_IN_SET(id, '1761,1744,732,517,726,737,258,1417,780,855,1717,1588,207,1324,1291,1794,874,1594,1199,454,871,977,1572,1359,1272,404,1766,974,1237,22,330,461,770,21,1032,393,716,797,1292,1424,28,66,1682,434,521,1348,553,738,1134,332,333,711,265,349,766,1415,792,857,858,1423,1501,11,1260,1422,9,1419,1420,1768,10,585,739,1421,34,439,1418,1677,25,31,36,378,407,163,455,715,1678,24,542,1205,3,674,1132,657,39,1460,1607,1141,837,882,1008,1721,1067,520,1402,1773,1302,385,1569,1574,1742,35,386,1012,113,966,1135,37,850,1372,1554,1555,63,160,1168,1852,573,610,30,1233,1454,338,626,1319,1602,98,768,986,1021,1455,1822,285,1505,1811,38,451,503,1373,1676,1284,352,1398,1413,1259,1411,1733,111,547,1410,148,198,817,1088,1193,43,108,286,314,406,1282,375,748,1722,116,526,1320,1323,1437,1579,1782,340,970,1108,1308,508,1266,1738,327,627,854,1325,1711,124,390,480,582,1586,1808,590,1028,1063,1571,485,1145,1552,348,394,883,119,944,1149,1208,1321,1412,1492,1724,335,616,791,462,658,704,1245,1575,1587,70,75,114,223,1672,1068,4,82,441,652,1027,1810,69,351,405,545,1157,1289,147,678,1461,1809,162,325,683,722,1801,401,958,1318,1408,78,403,884,1330,1463,1853,105,201,291,601,988,1303,149,287,341,1188,1236,262,389,651,1820,776,790,818,1159,1367,1526,1539,123,483,580,1013,1073,1139,1151,1486,1540,81,1019,1037,1172,266,423,673,1704,1772,639,1326,1327,1573,1730,1771,290,1743,45,574,635,796,968,1043,1426,1474,1757,644,852,1035,1040,1160,1217,1715,84,751,775,795,1344,1681,1716,1095,1143,1144,1358,1405,1452,1453,212,324,717,1223,1226,1229,1338,1343,1604,972,1048,1163,1283,1409,1663,1740,709,905,1029,1045,1449,1758,14,151,665,1137,1206,1647,885,1146,1150,1152,1448,1673,417,643,701,1136,1262,1351,1483,1807,1833,150,769,851,1025,1090,1109,1293,1746,707,973,1026,1042,1230,1231,1750,1787,208,448,453,467,1051,1052,1140,1322,1329,1749,1791,253,740,1055,1071,1154,1196,1340,1458,1519,1599,1649,1713,1723,1751,1759,1806,663,954,1044,1049,1224,1366,1368,1459,1580,1609,1632,1714,1816,27,559,666,784,920,996,1050,1148,1274,1294,1354,1360,1361,1362,1389,1601,1708,1805,205,886,914,921,923,927,1047,1072,1339,1350,1352,1788,1823,93,915,916,926,930,931,1036,1301,1854,479,703,888,924,965,1039,1596,1650,1664,1674,1679,299,300,422,1004,1020,1054,1225,1451,1468,1626,937,1445') 0.05590295791626
(119) DESCRIBE `cruisetypes` 0.0014410018920898
(120) DESCRIBE `destinations` 0.0026090145111084
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '38', '40', '28', '30', '26', '7', '49', '45', '48', '11', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,43,25,37,9,2,8,44,55,53,39,38,40,28,30,26,7,49,45,48,11,21,29,52,34,10,46,56,32') 0.0031771659851074