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

 
 
 
  • Daniele

    Daniele

    Welcome aboard the Daniele - a piloted river barge (or peniche) that doubles as your floating hotel.

    Boat Layout: Spacious lounge with bar, dining area,...

    Star Rating River
  • CroisiEurope
    Deborah

    Deborah

    The barge "Déborah” cruises the Canal Latéral à la Loire.

    These custom designed canal barges have been equipped with maximum comfort in mind for unforgettable and...

    Star Rating River
  • Delfin Amazon Cruises
    Delfin I

    Delfin I

    The highest standards are set for impeccable service, unique style and superb cuisine. Delphin 1 will take you one step beyond luxury, where comfort and...

    Star Rating River
  • Delfin Amazon Cruises
    Delfin II

    Delfin II

    Delfin II was launched in March 2009. It's fourteen large guest suites include four master suites with 180 degree panoramic windows and ten suites -...

    Star Rating River
  • Lindblad Expeditions
    Delfin II

    Delfin II

    Delfin II is a stately riverboat, recently built for the express purpose of exploring deep into the Peruvian Amazon at the headwaters of this mighty...

    Star Rating River
  • Delfin Amazon Cruises
    Delfin III

    Delfin III

    Our newest vessel, the Delfin III, offers guests an immersive rainforest experience while simultaneously treating them to the highest levels of luxury. This brand new...

    Star Rating River
  • DescaradA
    DescaradA

    DescaradA

    DescaradA takes you for a trip of a lifetime catering to your every need from delicious gourmet food to fun activities and moments of complete...

    Star Rating Specialty
  • Princess Cruises
    Diamond Princess

    Diamond Princess

    Diamond Princess is a treasure trove of exceptional delights waiting to be discovered. Dine on freshly prepared sashimi in Kai Sushi, watch street performers in...

    Star Rating 4 Star
  • Disney Cruise Line
    Disney Dream

    Disney Dream

    The Disney Dream™ is the majestic third ship in the Disney Cruise Line fleet. Boasting 14 towering decks.

    Building on the classic style of the previous...

    Star Rating 4 Star
  • Disney Cruise Line
    Disney Fantasy

    Disney Fantasy

    Building on the classic style of her sister ship, the Disney Dream, the Disney Fantasy™ is the regal fourth cruise liner in the expanding Disney...

    Star Rating 4 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: 119

Total elapsed time: 0.18831491470337

# Query Time
(1) connect 0.00062894821166992
(2) DESCRIBE `ships` 0.0035028457641602
(3) DESCRIBE `cruiselines` 0.0024318695068359
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.0005180835723877
(5) DESCRIBE `orchid_image` 0.0015671253204346
(6) DESCRIBE `ships` 0.0025219917297363
(7) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1461') 0.00033211708068848
(8) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(9) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031590461730957
(10) DESCRIBE `avid_specials` 0.001121997833252
(11) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1461 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.0010209083557129
(12) DESCRIBE `cruiselines` 0.0018799304962158
(13) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00034093856811523
(14) DESCRIBE `orchid_image` 0.0015430450439453
(15) DESCRIBE `cruiselines` 0.0017068386077881
(16) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00029611587524414
(17) DESCRIBE `ships` 0.0031590461730957
(18) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1371') 0.00037002563476562
(19) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029706954956055
(20) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025081634521484
(21) DESCRIBE `avid_specials` 0.0011310577392578
(22) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1371 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.0010340213775635
(23) DESCRIBE `cruiselines` 0.0018570423126221
(24) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.0003211498260498
(25) DESCRIBE `orchid_image` 0.0013968944549561
(26) DESCRIBE `cruiselines` 0.0018308162689209
(27) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00029516220092773
(28) DESCRIBE `ships` 0.0025739669799805
(29) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '857') 0.00026893615722656
(30) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028896331787109
(31) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(32) DESCRIBE `avid_specials` 0.0011088848114014
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 857 AND class = 'Ship') OR (item_id = 195 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.00099015235900879
(34) DESCRIBE `cruiselines` 0.0025010108947754
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.00030803680419922
(36) DESCRIBE `orchid_image` 0.0014951229095459
(37) DESCRIBE `cruiselines` 0.00177001953125
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00035285949707031
(39) DESCRIBE `ships` 0.0035181045532227
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '858') 0.00032806396484375
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028800964355469
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032496452331543
(43) DESCRIBE `avid_specials` 0.0020499229431152
(44) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 858 AND class = 'Ship') OR (item_id = 195 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.001060962677002
(45) DESCRIBE `cruiselines` 0.0018980503082275
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.00032901763916016
(47) DESCRIBE `orchid_image` 0.0015349388122559
(48) DESCRIBE `cruiselines` 0.0017518997192383
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.00028705596923828
(50) DESCRIBE `ships` 0.0027930736541748
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1175') 0.00029516220092773
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034308433532715
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032806396484375
(54) DESCRIBE `avid_specials` 0.0014650821685791
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1175 AND class = 'Ship') OR (item_id = 110 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.0015091896057129
(56) DESCRIBE `cruiselines` 0.0020620822906494
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.00039386749267578
(58) DESCRIBE `orchid_image` 0.0015280246734619
(59) DESCRIBE `cruiselines` 0.0017828941345215
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00028109550476074
(61) DESCRIBE `ships` 0.0025928020477295
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1501') 0.00029516220092773
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024890899658203
(65) DESCRIBE `avid_specials` 0.0011410713195801
(66) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1501 AND class = 'Ship') OR (item_id = 195 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.00096607208251953
(67) DESCRIBE `cruiselines` 0.0017261505126953
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 194))) 0.00036811828613281
(69) DESCRIBE `orchid_image` 0.0014100074768066
(70) DESCRIBE `cruiselines` 0.0020859241485596
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '194') 0.00029397010803223
(72) DESCRIBE `ships` 0.0028669834136963
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '846') 0.00026512145996094
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00052905082702637
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019097328186035
(76) DESCRIBE `avid_specials` 0.0010950565338135
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 846 AND class = 'Ship') OR (item_id = 194 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.0010180473327637
(78) DESCRIBE `cruiselines` 0.0018081665039062
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00044393539428711
(80) DESCRIBE `orchid_image` 0.0012819766998291
(81) DESCRIBE `cruiselines` 0.002418041229248
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031685829162598
(83) DESCRIBE `ships` 0.0029449462890625
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00037002563476562
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028896331787109
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(87) DESCRIBE `avid_specials` 0.0011570453643799
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 349 AND class = 'Ship') OR (item_id = 23 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.0012218952178955
(89) DESCRIBE `cruiselines` 0.0023171901702881
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00036501884460449
(91) DESCRIBE `orchid_image` 0.0017518997192383
(92) DESCRIBE `cruiselines` 0.0020198822021484
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00030803680419922
(94) DESCRIBE `ships` 0.0025458335876465
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0.00028395652770996
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024986267089844
(98) DESCRIBE `avid_specials` 0.0012168884277344
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 837 AND class = 'Ship') OR (item_id = 16 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
(100) DESCRIBE `cruiselines` 0.0017449855804443
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00037193298339844
(102) DESCRIBE `orchid_image` 0.0018279552459717
(103) DESCRIBE `cruiselines` 0.0019450187683105
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00034809112548828
(105) DESCRIBE `ships` 0.0025901794433594
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '944') 0.00030303001403809
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031089782714844
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032520294189453
(109) DESCRIBE `avid_specials` 0.0011630058288574
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 944 AND class = 'Ship') OR (item_id = 16 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.0010268688201904
(111) DESCRIBE `cruises` 0.0027828216552734
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (21450, 29602, 32923, 33074, 33075, 33084, 33087, 33089, 33090, 33092)) ORDER BY FIND_IN_SET(id, '21450,29602,32923,33074,33075,33084,33087,33089,33090,33092') 0.0010099411010742
(113) DESCRIBE `cruiselines` 0.0023190975189209
(114) 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', '262', '15', '29', '191', '120', '91', '258', '33', '50', '28', '251', '14', '114', '49', '206', '212', '24', '37', '187', '16', '36', '47', '170', '110', '118', '181', '208', '195', '153', '151', '30', '88', '108', '141', '159', '140', '59', '73', '90', '216', '4', '35', '264', '147', '211', '113', '57', '180', '38', '64', '48', '213', '257', '261', '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,262,15,29,191,120,91,258,33,50,28,251,14,114,49,206,212,24,37,187,16,36,47,170,110,118,181,208,195,153,151,30,88,108,141,159,140,59,73,90,216,4,35,264,147,211,113,57,180,38,64,48,213,257,261,276,115,95,184,52,105,244,82,209,134,177,245') 0.004086971282959
(115) DESCRIBE `ships` 0.0031640529632568
(116) 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', '1717', '1032', '1292', '22', '461', '797', '21', '330', '770', '393', '986', '28', '1677', '404', '407', '674', '1348', '1205', '1415', '716', '207', '1260', '1599', '11', '333', '739', '10', '439', '9', '349', '480', '1067', '715', '1135', '521', '882', '1607', '553', '766', '1008', '737', '1291', '24', '265', '1455', '817', '25', '1199', '792', '711', '1742', '3', '610', '352', '1768', '332', '63', '462', '1372', '66', '520', '1417', '113', '626', '1068', '657', '855', '14', '1738', '585', '1163', '1302', '748', '1413', '1526', '1411', '34', '38', '738', '1410', '1721', '31', '37', '526', '1323', '1579', '542', '837', '1320', '1773', '314', '378', '573', '1063', '970', '43', '327', '390', '854', '1402', '1569', '582', '590', '1259', '81', '452', '1454', '1682', '163', '958', '1013', '1088', '1586', '791', '212', '1284', '1319', '1193', '1208', '1157', '114', '1492', '1552', '401', '441', '1308', '39', '335', '580', '1266', '1587', '30', '36', '84', '405', '455', '850', '1012', '1245', '1678', '35', '351', '1326', '1327', '27', '406', '545', '547', '1461', '386', '1236', '1412', '1420', '1422', '340', '722', '385', '451', '658', '1040', '1398', '1418', '1421', '1424', '601', '1303', '1419', '1423', '162', '325', '1043', '1408', '148', '508', '683', '966', '1172', '1330', '1575', '1782', '1168', '1289', '287', '389', '434', '639', '1108', '1711', '1740', '78', '201', '160', '1021', '1743', '124', '394', '776', '852', '111', '119', '627', '775', '1019', '1344', '1715', '485', '559', '1037', '1159', '1217', '1325', '1716', '338', '1160', '1229', '1343', '1452', '1453', '1604', '751', '1426', '285', '673', '678', '1226', '1373', '45', '266', '1095', '1137', '1405', '105', '1358', '1448', '1704', '286', '403', '857', '858', '1136', '1150', '1501', '253', '818', '851', '69', '701', '768', '905', '968', '1141', '1283', '1801', '98', '291', '651', '1809', '151', '223', '574', '643', '1139', '1230', '1231', '1574', '1713', '324', '616', '1055', '1458', '1714', '82', '108', '150', '341', '348', '790', '954', '1474', '663', '709', '1360', '1361', '1368', '1459', '1609', '1632', '1672', '1708', '75', '467', '769', '884', '1049', '1206', '1362', '1724', '1751', '1808', '4', '375', '885', '1035', '1042', '1223', '1722', '1750', '1767', '149', '652', '1051', '1148', '1409', '944', '1322', '123', '1321', '70', '262', '290', '1301', '644', '665', '703', '784', '1020', '1483', '1771', '423', '1047', '1293', '1580', '116', '152', '483', '516', '1445', '1572', '1601', '1681', '147', '421', '422', '1054', '1486', '707', '1262', '1282', '1581', '93', '198', '1052', '1318', '1437', '1676', '1679', '1781', '796', '886', '1539', '1766', '1036', '1075', '717', '1045', '1060', '1064', '1143', '1673', '74', '420', '704', '1048', '1444', '1465', '1684', '973', '1073', '1151', '1389', '205', '419', '656', '883', '982', '1039', '1367', '1146', '1232', '1254', '1571', '503', '1050', '1350', '1540', '1195', '1749', '1791', '635', '795', '808', '1806', '479', '494', '687', '761', '1044', '1772', '1144', '1297', '1647', '1706', '1805', '1807', '493', '965', '1025', '1029', '1053', '1090', '1158', '1404', '1645', '1709', '1788', '733', '767', '972', '1027', '1316', '1342', '1624', '1674', '695', '1241', '1626', '1697', '1730', '240', '979', '988', '1028', '1113', '1155', '1156', '1295', '1340', '1341', '1471', '996', '1089', '1188', '1296', '299', '300', '888', '1024', '1233', '1351', '1451', '1710', '692', '997', '1026', '1142', '1145', '1196', '1339', '1640', '1757', '666', '685', '962', '1034', '1038', '1138', '1149', '1298', '1345', '1366', '1631', '1792')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,977,1588,1744,1555,1594,454,1794,517,1237,1272,780,974,1359,258,1717,1032,1292,22,461,797,21,330,770,393,986,28,1677,404,407,674,1348,1205,1415,716,207,1260,1599,11,333,739,10,439,9,349,480,1067,715,1135,521,882,1607,553,766,1008,737,1291,24,265,1455,817,25,1199,792,711,1742,3,610,352,1768,332,63,462,1372,66,520,1417,113,626,1068,657,855,14,1738,585,1163,1302,748,1413,1526,1411,34,38,738,1410,1721,31,37,526,1323,1579,542,837,1320,1773,314,378,573,1063,970,43,327,390,854,1402,1569,582,590,1259,81,452,1454,1682,163,958,1013,1088,1586,791,212,1284,1319,1193,1208,1157,114,1492,1552,401,441,1308,39,335,580,1266,1587,30,36,84,405,455,850,1012,1245,1678,35,351,1326,1327,27,406,545,547,1461,386,1236,1412,1420,1422,340,722,385,451,658,1040,1398,1418,1421,1424,601,1303,1419,1423,162,325,1043,1408,148,508,683,966,1172,1330,1575,1782,1168,1289,287,389,434,639,1108,1711,1740,78,201,160,1021,1743,124,394,776,852,111,119,627,775,1019,1344,1715,485,559,1037,1159,1217,1325,1716,338,1160,1229,1343,1452,1453,1604,751,1426,285,673,678,1226,1373,45,266,1095,1137,1405,105,1358,1448,1704,286,403,857,858,1136,1150,1501,253,818,851,69,701,768,905,968,1141,1283,1801,98,291,651,1809,151,223,574,643,1139,1230,1231,1574,1713,324,616,1055,1458,1714,82,108,150,341,348,790,954,1474,663,709,1360,1361,1368,1459,1609,1632,1672,1708,75,467,769,884,1049,1206,1362,1724,1751,1808,4,375,885,1035,1042,1223,1722,1750,1767,149,652,1051,1148,1409,944,1322,123,1321,70,262,290,1301,644,665,703,784,1020,1483,1771,423,1047,1293,1580,116,152,483,516,1445,1572,1601,1681,147,421,422,1054,1486,707,1262,1282,1581,93,198,1052,1318,1437,1676,1679,1781,796,886,1539,1766,1036,1075,717,1045,1060,1064,1143,1673,74,420,704,1048,1444,1465,1684,973,1073,1151,1389,205,419,656,883,982,1039,1367,1146,1232,1254,1571,503,1050,1350,1540,1195,1749,1791,635,795,808,1806,479,494,687,761,1044,1772,1144,1297,1647,1706,1805,1807,493,965,1025,1029,1053,1090,1158,1404,1645,1709,1788,733,767,972,1027,1316,1342,1624,1674,695,1241,1626,1697,1730,240,979,988,1028,1113,1155,1156,1295,1340,1341,1471,996,1089,1188,1296,299,300,888,1024,1233,1351,1451,1710,692,997,1026,1142,1145,1196,1339,1640,1757,666,685,962,1034,1038,1138,1149,1298,1345,1366,1631,1792') 0.044800043106079
(117) DESCRIBE `cruisetypes` 0.0015249252319336
(118) DESCRIBE `destinations` 0.002457857131958
(119) 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.0019359588623047