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
    Kalaw Pandaw

    Kalaw Pandaw

    Pandaw are delighted to announce the launch of one of their latest ships.

    As more and more river cruise ships are announced, mainly for the now...

    Star Rating River
  • CroisiEurope
    Kalaw Pandaw

    Kalaw Pandaw

    Kalaw Pandaw:

    Amenities on board: outdoor and indoor restaurant, bar, laundry service, sun deck, fair trade shop, reading room and library.

    Activities on board: many guided visits,...

    Star Rating River
  • Pandaw Cruises
    Kalay Pandaw

    Kalay Pandaw

    The RY Kalay Pandaw. Paul Strachan's colonial luxury yacht, based in Mandalay, Myanmar.

    The RY Kalay Pandaw with one Owner's Suite and four guest state...

    Star Rating River
  • Pandaw Cruises
    Kanee Pandaw

    Kanee Pandaw

    Pandaw are delighted to announce the construction of a new fourteen cabin K-class ship for Burma, now renamed Myanmar. These ultra-shallow twin decked K class...

    Star Rating River
  • Heritage Expeditions
    Kapitan Khlebnikov

    Kapitan Khlebnikov

    The latest addition to Heritage Expeditions' fleet, legendary Russian icebreaker and former research vessel Kapitan Khlebnikov holds the passenger ship record for the most crossings...

    Star Rating Specialty
  • Pandaw Cruises
    Katha Pandaw

    Katha Pandaw

    Our beautifully crafted Pandaw ships were built locally in Saigon. Each ship, hand finished in brass and teak by traditional craftsmen are in themselves objects...

    Star Rating River
  • Pandaw Cruises
    Kha Byoo Pandaw

    Kha Byoo Pandaw

    As more and more river cruise ships are announced, mainly for the now congested Pagan to Mandalay sector, Pandaw are maintaining their edge going further...

    Star Rating River
  • Kimberley Quest
    Kimberley Quest II

    Kimberley Quest II

    The Kimberley Quest II has been designed for relaxing and exploring the Kimberley coastline in complete comfort and style.

    Our custom-built vessel is fully air-conditioned, equipped...

    Star Rating Specialty
  • Pandaw Cruises
    Kindat Pandaw

    Kindat Pandaw

    Pandaw are delighted to announce the launch of one of their latest ships.

    As more and more river cruise ships are announced, mainly for the now...

    Star Rating River
  • Hurtigruten
    Kong Harald

    Kong Harald

    Norway's reigning monarch, a seasoned sailor, lends his name to this remarkable vessel.

    MS Kong Harald was refurbished in 2016 and now features a modern,...

    Star Rating Specialty
 

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

# Query Time
(1) connect 0.00094985961914062
(2) DESCRIBE `ships` 0.0044729709625244
(3) DESCRIBE `cruiselines` 0.0031299591064453
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00085806846618652
(5) DESCRIBE `orchid_image` 0.0025708675384521
(6) DESCRIBE `cruiselines` 0.0028200149536133
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0004429817199707
(8) DESCRIBE `ships` 0.0038471221923828
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1240') 0.00056099891662598
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042510032653809
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(12) DESCRIBE `avid_specials` 0.0017127990722656
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1240 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.0017890930175781
(14) DESCRIBE `cruiselines` 0.0028989315032959
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00047612190246582
(16) DESCRIBE `orchid_image` 0.0025770664215088
(17) DESCRIBE `cruiselines` 0.0037841796875
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00042200088500977
(19) DESCRIBE `ships` 0.0034160614013672
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1510') 0.00039410591125488
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034499168395996
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(23) DESCRIBE `avid_specials` 0.0023388862609863
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1510 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.0011789798736572
(25) DESCRIBE `cruiselines` 0.0025680065155029
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00043606758117676
(27) DESCRIBE `orchid_image` 0.0021390914916992
(28) DESCRIBE `cruiselines` 0.0030529499053955
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00056004524230957
(30) DESCRIBE `ships` 0.003931999206543
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1242') 0.00053715705871582
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033307075500488
(34) DESCRIBE `avid_specials` 0.002032995223999
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1242 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.0011439323425293
(36) DESCRIBE `cruiselines` 0.0028481483459473
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00049400329589844
(38) DESCRIBE `orchid_image` 0.002269983291626
(39) DESCRIBE `cruiselines` 0.0027980804443359
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0004570484161377
(41) DESCRIBE `ships` 0.0046179294586182
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1829') 0.00048112869262695
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035309791564941
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(45) DESCRIBE `avid_specials` 0.001708984375
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1829 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.0011410713195801
(47) DESCRIBE `cruiselines` 0.0026800632476807
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105))) 0.00049495697021484
(49) DESCRIBE `orchid_image` 0.0024590492248535
(50) DESCRIBE `cruiselines` 0.0030391216278076
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '105') 0.00053811073303223
(52) DESCRIBE `ships` 0.0037910938262939
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1786') 0.00059914588928223
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003659725189209
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041413307189941
(56) DESCRIBE `avid_specials` 0.0019969940185547
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1786 AND class = 'Ship') OR (item_id = 105 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.0011930465698242
(58) DESCRIBE `cruiselines` 0.0029881000518799
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00048589706420898
(60) DESCRIBE `orchid_image` 0.0023469924926758
(61) DESCRIBE `cruiselines` 0.0025849342346191
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00047898292541504
(63) DESCRIBE `ships` 0.0036120414733887
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '993') 0.00042986869812012
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035715103149414
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(67) DESCRIBE `avid_specials` 0.0018179416656494
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 993 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.0012290477752686
(69) DESCRIBE `cruiselines` 0.0025780200958252
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00043916702270508
(71) DESCRIBE `orchid_image` 0.0020790100097656
(72) DESCRIBE `cruiselines` 0.0026979446411133
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00043511390686035
(74) DESCRIBE `ships` 0.0036389827728271
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1241') 0.0005340576171875
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035691261291504
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045204162597656
(78) DESCRIBE `avid_specials` 0.0022008419036865
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1241 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.0013489723205566
(80) DESCRIBE `cruiselines` 0.0026178359985352
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 64))) 0.00047683715820312
(82) DESCRIBE `orchid_image` 0.0020489692687988
(83) DESCRIBE `cruiselines` 0.0026750564575195
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '64') 0.00051498413085938
(85) DESCRIBE `ships` 0.0038609504699707
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '516') 0.00044608116149902
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035810470581055
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042009353637695
(89) DESCRIBE `avid_specials` 0.0016880035400391
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 516 AND class = 'Ship') OR (item_id = 64 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.0012390613555908
(91) DESCRIBE `cruiselines` 0.0026588439941406
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00044488906860352
(93) DESCRIBE `orchid_image` 0.0025341510772705
(94) DESCRIBE `cruiselines` 0.0026421546936035
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00045609474182129
(96) DESCRIBE `ships` 0.0038290023803711
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1243') 0.00048613548278809
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037693977355957
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037097930908203
(100) DESCRIBE `avid_specials` 0.0017681121826172
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1243 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.0012109279632568
(102) DESCRIBE `cruiselines` 0.0028469562530518
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00045609474182129
(104) DESCRIBE `orchid_image` 0.0021312236785889
(105) DESCRIBE `cruiselines` 0.0030210018157959
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00052404403686523
(107) DESCRIBE `ships` 0.0036489963531494
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '30') 0.00066494941711426
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042319297790527
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034499168395996
(111) DESCRIBE `avid_specials` 0.0018038749694824
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 30 AND class = 'Ship') OR (item_id = 7 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.0013082027435303
(113) DESCRIBE `cruises` 0.0038008689880371
(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.0026731491088867
(115) DESCRIBE `cruiselines` 0.0037789344787598
(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.007051944732666
(117) DESCRIBE `ships` 0.0038459300994873
(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.073811054229736
(119) DESCRIBE `cruisetypes` 0.0025539398193359
(120) DESCRIBE `destinations` 0.0034458637237549
(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.0040569305419922