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

    Kaladan 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
  • 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
  • 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
    Kapuas Pandaw

    Kapuas Pandaw

    Pandaw are delighted to announce the acquisition of a new ship to be deployed to West Kalimantan, Borneo. This charming ten cabin river ship, originally...

    Star Rating River
  • 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
 

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

# Query Time
(1) connect 0.00086498260498047
(2) DESCRIBE `ships` 0.0041930675506592
(3) DESCRIBE `cruiselines` 0.0025060176849365
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00059604644775391
(5) DESCRIBE `orchid_image` 0.001572847366333
(6) DESCRIBE `cruiselines` 0.0020129680633545
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00017690658569336
(8) DESCRIBE `ships` 0.0027811527252197
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1263') 0.00044512748718262
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026512145996094
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002741813659668
(12) DESCRIBE `avid_specials` 0.0011751651763916
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1263 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.001039981842041
(14) DESCRIBE `cruiselines` 0.0021328926086426
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00034093856811523
(16) DESCRIBE `orchid_image` 0.0018811225891113
(17) DESCRIBE `cruiselines` 0.0018718242645264
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00028800964355469
(19) DESCRIBE `ships` 0.002532958984375
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1240') 0.0003199577331543
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028586387634277
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(23) DESCRIBE `avid_specials` 0.0013139247894287
(24) 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.0010030269622803
(25) DESCRIBE `cruiselines` 0.0017960071563721
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00033998489379883
(27) DESCRIBE `orchid_image` 0.001471996307373
(28) DESCRIBE `cruiselines` 0.0017328262329102
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00028395652770996
(30) DESCRIBE `ships` 0.0025691986083984
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1510') 0.00029301643371582
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031113624572754
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(34) DESCRIBE `avid_specials` 0.0013790130615234
(35) 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.0010387897491455
(36) DESCRIBE `cruiselines` 0.0019900798797607
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0003349781036377
(38) DESCRIBE `orchid_image` 0.0014221668243408
(39) DESCRIBE `cruiselines` 0.0018839836120605
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00036120414733887
(41) DESCRIBE `ships` 0.0036981105804443
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1242') 0.0004889965057373
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034284591674805
(45) DESCRIBE `avid_specials` 0.0015671253204346
(46) 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.0013289451599121
(47) DESCRIBE `cruiselines` 0.0023288726806641
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105))) 0.00044703483581543
(49) DESCRIBE `orchid_image` 0.0015139579772949
(50) DESCRIBE `cruiselines` 0.0018270015716553
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '105') 0.00031495094299316
(52) DESCRIBE `ships` 0.0027730464935303
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1786') 0.00040507316589355
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00029611587524414
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025701522827148
(56) DESCRIBE `avid_specials` 0.0011920928955078
(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.0010230541229248
(58) DESCRIBE `cruiselines` 0.002249002456665
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00040888786315918
(60) DESCRIBE `orchid_image` 0.0014989376068115
(61) DESCRIBE `cruiselines` 0.0022070407867432
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00034308433532715
(63) DESCRIBE `ships` 0.002877950668335
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1565') 0.00034713745117188
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 6.3180923461914E-5
(67) DESCRIBE `avid_specials` 0.0011579990386963
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1565 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.0010089874267578
(69) DESCRIBE `cruiselines` 0.0018758773803711
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00032806396484375
(71) DESCRIBE `orchid_image` 0.0018038749694824
(72) DESCRIBE `cruiselines` 0.002532958984375
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00020289421081543
(74) DESCRIBE `ships` 0.0029900074005127
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '993') 0.00037217140197754
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002748966217041
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 6.6041946411133E-5
(78) DESCRIBE `avid_specials` 0.0011510848999023
(79) 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.0010080337524414
(80) DESCRIBE `cruiselines` 0.0017919540405273
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00030899047851562
(82) DESCRIBE `orchid_image` 0.001600980758667
(83) DESCRIBE `cruiselines` 0.0019969940185547
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00028610229492188
(85) DESCRIBE `ships` 0.0024528503417969
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1241') 0.00037002563476562
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030398368835449
(89) DESCRIBE `avid_specials` 0.0011470317840576
(90) 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.0010771751403809
(91) DESCRIBE `cruiselines` 0.0018618106842041
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 64))) 0.0003201961517334
(93) DESCRIBE `orchid_image` 0.001460075378418
(94) DESCRIBE `cruiselines` 0.00217604637146
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '64') 0.00036382675170898
(96) DESCRIBE `ships` 0.0029299259185791
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '516') 0.00034213066101074
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027012825012207
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003669261932373
(100) DESCRIBE `avid_specials` 0.0013749599456787
(101) 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.0015909671783447
(102) DESCRIBE `cruiselines` 0.0021748542785645
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00033092498779297
(104) DESCRIBE `orchid_image` 0.0014569759368896
(105) DESCRIBE `cruiselines` 0.0021231174468994
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00030207633972168
(107) DESCRIBE `ships` 0.0025649070739746
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1243') 0.00031685829162598
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026392936706543
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(111) DESCRIBE `avid_specials` 0.0011959075927734
(112) 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.0013418197631836
(113) DESCRIBE `cruises` 0.003087043762207
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (8256, 10650, 13508, 20574, 21382, 28851, 29120, 34150, 34161, 34188)) ORDER BY FIND_IN_SET(id, '8256,10650,13508,20574,21382,28851,29120,34150,34161,34188') 0.0012099742889404
(115) DESCRIBE `cruiselines` 0.0021331310272217
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '183', '12', '144', '20', '23', '18', '7', '131', '8', '101', '96', '171', '103', '156', '31', '15', '262', '29', '191', '120', '91', '258', '33', '50', '28', '251', '14', '114', '49', '212', '206', '24', '37', '187', '16', '36', '47', '170', '110', '208', '118', '181', '195', '153', '151', '30', '88', '108', '141', '159', '140', '59', '73', '90', '216', '4', '35', '264', '147', '211', '113', '57', '180', '38', '64', '48', '257', '261', '213', '276', '115', '95', '184', '52', '105', '244', '82', '209', '134', '177', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,183,12,144,20,23,18,7,131,8,101,96,171,103,156,31,15,262,29,191,120,91,258,33,50,28,251,14,114,49,212,206,24,37,187,16,36,47,170,110,208,118,181,195,153,151,30,88,108,141,159,140,59,73,90,216,4,35,264,147,211,113,57,180,38,64,48,257,261,213,276,115,95,184,52,105,244,82,209,134,177,245') 0.0042409896850586
(117) DESCRIBE `ships` 0.0030450820922852
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '977', '1588', '1744', '1555', '1594', '454', '1794', '517', '1237', '1272', '780', '974', '1359', '258', '407', '1717', '1032', '1292', '22', '461', '797', '330', '21', '393', '770', '986', '28', '1677', '404', '1348', '674', '1205', '1415', '716', '207', '1260', '11', '1599', '333', '739', '10', '439', '9', '349', '480', '715', '1067', '521', '1135', '882', '1607', '553', '738', '766', '737', '1008', '1291', '24', '265', '817', '25', '1455', '1199', '792', '610', '711', '1742', '3', '352', '1768', '332', '63', '462', '1372', '520', '1417', '66', '113', '626', '1068', '657', '855', '14', '1738', '585', '1302', '1163', '748', '1413', '1526', '34', '1410', '1411', '1721', '31', '37', '38', '526', '542', '837', '1320', '1323', '1579', '1773', '314', '378', '573', '1063', '970', '43', '854', '1402', '327', '390', '452', '582', '590', '1259', '1569', '81', '1454', '1682', '163', '1088', '1586', '1013', '212', '791', '958', '1284', '1319', '1208', '1193', '114', '1157', '1552', '1492', '39', '335', '401', '441', '580', '1266', '1308', '1587', '30', '36', '84', '405', '850', '1012', '1245', '455', '1326', '1327', '1678', '27', '35', '351', '406', '545', '1461', '386', '547', '1236', '1412', '1420', '722', '340', '385', '451', '658', '1040', '1398', '1418', '1421', '1424', '601', '1303', '1419', '1422', '1423', '162', '1043', '1408', '148', '325', '508', '683', '966', '1172', '1330', '1575', '1782', '1168', '1289', '287', '434', '639', '1108', '1711', '1740', '78', '201', '389', '160', '1021', '124', '394', '852', '1743', '119', '627', '776', '1019', '1344', '1715', '111', '485', '775', '1037', '1159', '1716', '291', '338', '559', '1160', '1217', '1229', '1325', '1343', '1452', '1453', '1604', '751', '1426', '285', '673', '678', '1226', '1373', '45', '1095', '1137', '1405', '105', '266', '1704', '286', '403', '857', '1136', '1150', '1358', '1448', '1501', '253', '818', '858', '69', '701', '768', '851', '1141', '1801', '905', '968', '1283', '1809', '98', '151', '223', '574', '643', '651', '1139', '1574', '1713', '324', '616', '1055', '1230', '1231', '1458', '1714', '82', '108', '150', '341', '348', '790', '954', '1474', '663', '709', '1368', '1459', '1609', '1632', '1672', '1708', '75', '467', '769', '884', '1049', '1206', '1360', '1361', '1362', '1724', '1751', '1808', '4', '375', '885', '1035', '1042', '1223', '1722', '1750', '1767', '149', '652', '1051', '1148', '1409', '944', '123', '1321', '1322', '70', '262', '1301', '290', '644', '665', '703', '784', '1020', '1483', '1771', '423', '1047', '1293', '1580', '116', '152', '516', '1445', '1601', '1681', '147', '422', '483', '1054', '1486', '1572', '421', '707', '1262', '1282', '1581', '93', '198', '1052', '1318', '1437', '1676', '1679', '1781', '796', '886', '1539', '1766', '1036', '1075', '717', '1045', '1060', '1064', '1673', '74', '420', '704', '1048', '1143', '1444', '1465', '1684', '973', '1073', '1151', '1389', '205', '656', '883', '982', '1039', '1367', '419', '996', '1146', '1232', '1254', '1571', '503', '1050', '1350', '1540', '1195', '1749', '1791', '635', '795', '808', '1806', '479', '494', '687', '761', '1044', '1772', '1297', '1706', '1805', '1807', '493', '965', '1025', '1029', '1053', '1090', '1144', '1158', '1404', '1647', '1709', '1788', '733', '767', '937', '972', '1027', '1316', '1342', '1624', '1645', '1674', '695', '1241', '1626', '1697', '1730', '240', '979', '1028', '1113', '1155', '1156', '1295', '1340', '1341', '1471', '1089', '1188', '1296', '299', '300', '888', '988', '1024', '1233', '1351', '1451', '1710', '692', '1026', '1145', '1196', '1339', '1640', '1757', '666', '685', '962', '997', '1034', '1038', '1138', '1142', '1298', '1366', '1631', '1792', '836')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,977,1588,1744,1555,1594,454,1794,517,1237,1272,780,974,1359,258,407,1717,1032,1292,22,461,797,330,21,393,770,986,28,1677,404,1348,674,1205,1415,716,207,1260,11,1599,333,739,10,439,9,349,480,715,1067,521,1135,882,1607,553,738,766,737,1008,1291,24,265,817,25,1455,1199,792,610,711,1742,3,352,1768,332,63,462,1372,520,1417,66,113,626,1068,657,855,14,1738,585,1302,1163,748,1413,1526,34,1410,1411,1721,31,37,38,526,542,837,1320,1323,1579,1773,314,378,573,1063,970,43,854,1402,327,390,452,582,590,1259,1569,81,1454,1682,163,1088,1586,1013,212,791,958,1284,1319,1208,1193,114,1157,1552,1492,39,335,401,441,580,1266,1308,1587,30,36,84,405,850,1012,1245,455,1326,1327,1678,27,35,351,406,545,1461,386,547,1236,1412,1420,722,340,385,451,658,1040,1398,1418,1421,1424,601,1303,1419,1422,1423,162,1043,1408,148,325,508,683,966,1172,1330,1575,1782,1168,1289,287,434,639,1108,1711,1740,78,201,389,160,1021,124,394,852,1743,119,627,776,1019,1344,1715,111,485,775,1037,1159,1716,291,338,559,1160,1217,1229,1325,1343,1452,1453,1604,751,1426,285,673,678,1226,1373,45,1095,1137,1405,105,266,1704,286,403,857,1136,1150,1358,1448,1501,253,818,858,69,701,768,851,1141,1801,905,968,1283,1809,98,151,223,574,643,651,1139,1574,1713,324,616,1055,1230,1231,1458,1714,82,108,150,341,348,790,954,1474,663,709,1368,1459,1609,1632,1672,1708,75,467,769,884,1049,1206,1360,1361,1362,1724,1751,1808,4,375,885,1035,1042,1223,1722,1750,1767,149,652,1051,1148,1409,944,123,1321,1322,70,262,1301,290,644,665,703,784,1020,1483,1771,423,1047,1293,1580,116,152,516,1445,1601,1681,147,422,483,1054,1486,1572,421,707,1262,1282,1581,93,198,1052,1318,1437,1676,1679,1781,796,886,1539,1766,1036,1075,717,1045,1060,1064,1673,74,420,704,1048,1143,1444,1465,1684,973,1073,1151,1389,205,656,883,982,1039,1367,419,996,1146,1232,1254,1571,503,1050,1350,1540,1195,1749,1791,635,795,808,1806,479,494,687,761,1044,1772,1297,1706,1805,1807,493,965,1025,1029,1053,1090,1144,1158,1404,1647,1709,1788,733,767,937,972,1027,1316,1342,1624,1645,1674,695,1241,1626,1697,1730,240,979,1028,1113,1155,1156,1295,1340,1341,1471,1089,1188,1296,299,300,888,988,1024,1233,1351,1451,1710,692,1026,1145,1196,1339,1640,1757,666,685,962,997,1034,1038,1138,1142,1298,1366,1631,1792,836') 0.041595935821533
(119) DESCRIBE `cruisetypes` 0.0019199848175049
(120) DESCRIBE `destinations` 0.0016779899597168
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '9', '43', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '21', '40', '7', '48', '45', '29', '44', '30', '10', '34', '46', '52', '32', '56')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,9,43,2,37,8,39,53,26,28,38,49,55,11,21,40,7,48,45,29,44,30,10,34,46,52,32,56') 0.0041871070861816