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

 
 
 
  • European Waterways
    Athos

    Athos

    Athos was originally built as a commercial sand, grain and wine barge and converted into a luxury hotel barge in 1982. Her association with wine...

    Star Rating River
  • Nomads of the Seas
    Atmosphere

    Atmosphere

    Nomads of the Seas, Patagonian adventure acquire an entire new meaning aboard the Atmosphere.

    Guillermo Rodríguez, Chilean renowned chef, and President of the Chilean chapter of...

    Star Rating 5 Star
  • P&O International
    Aurora

    Aurora

    Family-friendly, mid-sized ship

    Aurora is a mid-sized cruise ship, instantly recognisable thanks to her elegant tiered stern. Like Oriana, Aurora is designed as a classic...

    Star Rating 4 Star
  • Avalon Waterways
    Avalon Artistry II

    Avalon Artistry II

    The Avalon Artistry II® delivers an intimate setting, along with two full decks of suites featuring Wall-to-Wall Panoramic Windows that transform the living space into...

    Star Rating River
  • Avalon Waterways
    Avalon Envision

    Avalon Envision

    The Avalon Envision is the newest addition to the 2019 Avalon Suite Ship fleet. With the youngest fleet of ships on Europe's waterways, Avalon continues...

    Star Rating River
  • Avalon Waterways
    Avalon Expression

    Avalon Expression

    The Avalon Expression® adds to our unique offering of Suite Ships. The Expression's two full decks of suites feature Wall-to-Wall Panoramic Windows that transform the...

    Star Rating River
  • Avalon Waterways
    Avalon Illumination

    Avalon Illumination

    The beautiful Avalon Illumination® has graced the waterways of Europe since 2014. Like its sister ship, the Avalon Expression, the Illumination features two full decks...

    Star Rating River
  • Avalon Waterways
    Avalon Imagery II

    Avalon Imagery II

    The Avalon Imagery II is a true haven on the river - two full decks of Panorama Suites with Wall-to-Wall Panoramic Windows that transform the...

    Star Rating River
  • Avalon Waterways
    Avalon Impression

    Avalon Impression

    In addition to the Avalon Poetry II® and Avalon Illumination®, the striking Avalon Impression? graced the waters of Europe's Rhine, Main, and Danube Rivers in...

    Star Rating River
  • Avalon Waterways
    Avalon Panorama

    Avalon Panorama

    A brand new kind of ship, the Avalon Panorama set sail in 2011, taking inspired design to a whole new level. A unique 'Suite Ship',...

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

# Query Time
(1) connect 0.000885009765625
(2) DESCRIBE `ships` 0.0056099891662598
(3) DESCRIBE `cruiselines` 0.0038609504699707
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) 0.00091195106506348
(5) DESCRIBE `orchid_image` 0.0025200843811035
(6) DESCRIBE `cruiselines` 0.0029609203338623
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '206') 0.00073814392089844
(8) DESCRIBE `ships` 0.0056600570678711
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '923') 0.00070691108703613
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00057196617126465
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005190372467041
(12) DESCRIBE `avid_specials` 0.0028588771820068
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 923 AND class = 'Ship') OR (item_id = 206 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.0022938251495361
(14) DESCRIBE `cruiselines` 0.0041670799255371
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 177))) 0.00089812278747559
(16) DESCRIBE `orchid_image` 0.0027680397033691
(17) DESCRIBE `cruiselines` 0.0033349990844727
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '177') 0.00046300888061523
(19) DESCRIBE `ships` 0.0039200782775879
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '759') 0.00051498413085938
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044512748718262
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036287307739258
(23) DESCRIBE `avid_specials` 0.0017158985137939
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 759 AND class = 'Ship') OR (item_id = 177 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.0012869834899902
(25) DESCRIBE `cruiselines` 0.0033121109008789
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00062799453735352
(27) DESCRIBE `orchid_image` 0.0030848979949951
(28) DESCRIBE `cruiselines` 0.0037100315093994
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00066399574279785
(30) DESCRIBE `ships` 0.0050389766693115
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '205') 0.00063800811767578
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004730224609375
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00057601928710938
(34) DESCRIBE `avid_specials` 0.0023059844970703
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 205 AND class = 'Ship') OR (item_id = 50 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.0020740032196045
(36) DESCRIBE `cruiselines` 0.0036079883575439
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00060820579528809
(38) DESCRIBE `orchid_image` 0.002795934677124
(39) DESCRIBE `cruiselines` 0.003507137298584
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00052785873413086
(41) DESCRIBE `ships` 0.005012035369873
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1028') 0.0005338191986084
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004889965057373
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044703483581543
(45) DESCRIBE `avid_specials` 0.0022599697113037
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1028 AND class = 'Ship') OR (item_id = 101 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.0019369125366211
(47) DESCRIBE `cruiselines` 0.003558874130249
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00060892105102539
(49) DESCRIBE `orchid_image` 0.0027821063995361
(50) DESCRIBE `cruiselines` 0.0034868717193604
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.0005490779876709
(52) DESCRIBE `ships` 0.0035991668701172
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1723') 0.00045013427734375
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034880638122559
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(56) DESCRIBE `avid_specials` 0.0016369819641113
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1723 AND class = 'Ship') OR (item_id = 101 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.0012152194976807
(58) DESCRIBE `cruiselines` 0.0026249885559082
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00042200088500977
(60) DESCRIBE `orchid_image` 0.0023329257965088
(61) DESCRIBE `cruiselines` 0.0038928985595703
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00058984756469727
(63) DESCRIBE `ships` 0.0051310062408447
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1029') 0.00065279006958008
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051283836364746
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049400329589844
(67) DESCRIBE `avid_specials` 0.0017449855804443
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1029 AND class = 'Ship') OR (item_id = 101 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.0011141300201416
(69) DESCRIBE `cruiselines` 0.0030100345611572
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00056600570678711
(71) DESCRIBE `orchid_image` 0.0023131370544434
(72) DESCRIBE `cruiselines` 0.0029010772705078
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.0005040168762207
(74) DESCRIBE `ships` 0.0037069320678711
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1154') 0.00063204765319824
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003669261932373
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035214424133301
(78) DESCRIBE `avid_specials` 0.0017850399017334
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1154 AND class = 'Ship') OR (item_id = 101 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.001431941986084
(80) DESCRIBE `cruiselines` 0.0030570030212402
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00046777725219727
(82) DESCRIBE `orchid_image` 0.0020980834960938
(83) DESCRIBE `cruiselines` 0.0031290054321289
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00042605400085449
(85) DESCRIBE `ships` 0.0051989555358887
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1321') 0.00049400329589844
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00057601928710938
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035309791564941
(89) DESCRIBE `avid_specials` 0.0018548965454102
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1321 AND class = 'Ship') OR (item_id = 101 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.0015668869018555
(91) DESCRIBE `cruiselines` 0.0028657913208008
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00055789947509766
(93) DESCRIBE `orchid_image` 0.0026412010192871
(94) DESCRIBE `cruiselines` 0.0033731460571289
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00042915344238281
(96) DESCRIBE `ships` 0.0070230960845947
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1138') 0.00062108039855957
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047206878662109
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049591064453125
(100) DESCRIBE `avid_specials` 0.002316951751709
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1138 AND class = 'Ship') OR (item_id = 101 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.001460075378418
(102) DESCRIBE `cruiselines` 0.0034871101379395
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00059103965759277
(104) DESCRIBE `orchid_image` 0.0030109882354736
(105) DESCRIBE `cruiselines` 0.0031890869140625
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00058102607727051
(107) DESCRIBE `ships` 0.0043399333953857
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '888') 0.00062894821166992
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00056004524230957
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00065398216247559
(111) DESCRIBE `avid_specials` 0.0027880668640137
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 888 AND class = 'Ship') OR (item_id = 101 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.0026180744171143
(113) DESCRIBE `cruises` 0.0047578811645508
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (13509, 13510, 34149, 38147, 38149, 40872, 40876, 45258, 45260, 48299)) ORDER BY FIND_IN_SET(id, '13509,13510,34149,38147,38149,40872,40876,45258,45260,48299') 0.0020411014556885
(115) DESCRIBE `cruiselines` 0.0032289028167725
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '12', '144', '183', '20', '120', '101', '31', '18', '8', '131', '7', '96', '206', '91', '170', '33', '103', '15', '50', '156', '262', '24', '29', '191', '14', '195', '258', '37', '16', '28', '153', '36', '47', '208', '114', '187', '49', '216', '88', '251', '141', '212', '151', '181', '110', '118', '4', '264', '30', '59', '115', '140', '73', '108', '159', '48', '147', '211', '113', '213', '276', '38', '35', '90', '57', '95', '180', '52', '244', '172', '64', '261', '184', '257', '82', '134', '105', '209', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,12,144,183,20,120,101,31,18,8,131,7,96,206,91,170,33,103,15,50,156,262,24,29,191,14,195,258,37,16,28,153,36,47,208,114,187,49,216,88,251,141,212,151,181,110,118,4,264,30,59,115,140,73,108,159,48,147,211,113,213,276,38,35,90,57,95,180,52,244,172,64,261,184,257,82,134,105,209,245,177') 0.0075948238372803
(117) DESCRIBE `ships` 0.0056660175323486
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '517', '1744', '732', '737', '1417', '726', '855', '1588', '207', '1291', '1324', '454', '1794', '1594', '1199', '1717', '874', '977', '1554', '1555', '780', '521', '1237', '871', '1272', '974', '258', '1032', '1359', '1572', '22', '461', '797', '265', '1424', '21', '330', '393', '404', '770', '1292', '716', '28', '1766', '1348', '520', '1677', '1419', '1423', '1422', '1420', '66', '1418', '1421', '1682', '333', '349', '332', '857', '858', '1134', '1501', '1415', '738', '1205', '163', '715', '11', '10', '439', '739', '9', '25', '1067', '1260', '24', '674', '1678', '455', '542', '837', '657', '3', '1768', '986', '1607', '1008', '1402', '434', '1132', '1460', '1574', '610', '882', '113', '627', '1141', '1302', '1773', '503', '792', '407', '1135', '385', '386', '553', '1721', '1742', '573', '1569', '850', '63', '160', '1168', '1454', '1455', '1233', '1372', '1602', '480', '626', '766', '817', '966', '352', '711', '1319', '98', '285', '1021', '198', '585', '1284', '1413', '116', '883', '1411', '338', '1410', '1822', '111', '1193', '1259', '1738', '1811', '1676', '314', '526', '1266', '1308', '1320', '1323', '1579', '1733', '43', '108', '286', '462', '970', '1088', '124', '508', '854', '1108', '327', '390', '1571', '394', '582', '590', '1552', '485', '1145', '1586', '748', '1063', '1722', '441', '1782', '944', '1463', '1492', '1711', '348', '791', '1149', '1245', '1321', '70', '119', '405', '406', '1028', '1068', '1208', '1412', '1587', '1599', '162', '335', '545', '34', '114', '351', '616', '658', '958', '1027', '1672', '4', '31', '37', '38', '69', '401', '1157', '82', '378', '451', '547', '678', '1289', '105', '704', '1318', '1461', '340', '644', '722', '1139', '1159', '635', '652', '1236', '14', '325', '403', '1303', '1330', '1408', '1526', '148', '601', '1013', '1398', '201', '580', '1188', '1367', '78', '341', '389', '651', '683', '1151', '1801', '1809', '262', '1172', '1326', '1327', '287', '291', '639', '1019', '1575', '123', '36', '818', '988', '1405', '1743', '212', '852', '1037', '1040', '1043', '1704', '1808', '39', '483', '776', '1160', '1282', '1344', '1426', '1573', '1715', '1724', '1730', '30', '84', '266', '290', '701', '775', '1217', '1223', '1716', '574', '673', '1012', '1143', '1144', '1163', '1343', '1373', '1452', '1453', '1772', '35', '324', '751', '768', '790', '968', '1029', '1095', '1226', '1229', '1358', '1604', '45', '75', '27', '1283', '1474', '1740', '905', '1035', '1045', '1137', '1152', '1449', '1647', '1771', '709', '972', '1136', '1325', '1409', '1448', '1681', '151', '253', '417', '885', '1025', '1055', '1090', '1150', '223', '851', '1206', '643', '769', '884', '1026', '1048', '1351', '150', '973', '1230', '1231', '1458', '1483', '1713', '1750', '663', '954', '1071', '1714', '1751', '559', '665', '666', '1042', '1049', '1051', '1140', '1293', '1322', '1366', '1632', '1723', '1758', '208', '467', '784', '1052', '1146', '1154', '1196', '1329', '1360', '1361', '1368', '1459', '1580', '1708', '93', '423', '920', '1148', '1362', '1649', '1807', '1833', '147', '453', '707', '921', '923', '1109', '1262', '1301', '1340', '1354', '1519', '1609', '1791', '205', '703', '740', '888', '914', '915', '927', '1020', '1039', '1050', '1072', '1224', '1274', '1350', '1352', '717', '796', '886', '916', '924', '926', '930', '931', '996', '1389', '1539', '1601', '1679', '1749', '730', '1044', '1073', '1294', '1339', '1468', '1596', '1759', '1767', '1788', '1806', '422', '479', '1004', '1036', '1047', '1054', '1075', '1241', '1816', '152', '516', '1445', '1486', '1664', '1673', '1805', '74', '149', '1823', '81', '299', '300', '671', '672', '795', '1060', '1437', '1451', '493', '656', '965', '1225', '1232', '1240', '1254', '1256', '1540', '1626')) ORDER BY FIND_IN_SET(id, '1761,517,1744,732,737,1417,726,855,1588,207,1291,1324,454,1794,1594,1199,1717,874,977,1554,1555,780,521,1237,871,1272,974,258,1032,1359,1572,22,461,797,265,1424,21,330,393,404,770,1292,716,28,1766,1348,520,1677,1419,1423,1422,1420,66,1418,1421,1682,333,349,332,857,858,1134,1501,1415,738,1205,163,715,11,10,439,739,9,25,1067,1260,24,674,1678,455,542,837,657,3,1768,986,1607,1008,1402,434,1132,1460,1574,610,882,113,627,1141,1302,1773,503,792,407,1135,385,386,553,1721,1742,573,1569,850,63,160,1168,1454,1455,1233,1372,1602,480,626,766,817,966,352,711,1319,98,285,1021,198,585,1284,1413,116,883,1411,338,1410,1822,111,1193,1259,1738,1811,1676,314,526,1266,1308,1320,1323,1579,1733,43,108,286,462,970,1088,124,508,854,1108,327,390,1571,394,582,590,1552,485,1145,1586,748,1063,1722,441,1782,944,1463,1492,1711,348,791,1149,1245,1321,70,119,405,406,1028,1068,1208,1412,1587,1599,162,335,545,34,114,351,616,658,958,1027,1672,4,31,37,38,69,401,1157,82,378,451,547,678,1289,105,704,1318,1461,340,644,722,1139,1159,635,652,1236,14,325,403,1303,1330,1408,1526,148,601,1013,1398,201,580,1188,1367,78,341,389,651,683,1151,1801,1809,262,1172,1326,1327,287,291,639,1019,1575,123,36,818,988,1405,1743,212,852,1037,1040,1043,1704,1808,39,483,776,1160,1282,1344,1426,1573,1715,1724,1730,30,84,266,290,701,775,1217,1223,1716,574,673,1012,1143,1144,1163,1343,1373,1452,1453,1772,35,324,751,768,790,968,1029,1095,1226,1229,1358,1604,45,75,27,1283,1474,1740,905,1035,1045,1137,1152,1449,1647,1771,709,972,1136,1325,1409,1448,1681,151,253,417,885,1025,1055,1090,1150,223,851,1206,643,769,884,1026,1048,1351,150,973,1230,1231,1458,1483,1713,1750,663,954,1071,1714,1751,559,665,666,1042,1049,1051,1140,1293,1322,1366,1632,1723,1758,208,467,784,1052,1146,1154,1196,1329,1360,1361,1368,1459,1580,1708,93,423,920,1148,1362,1649,1807,1833,147,453,707,921,923,1109,1262,1301,1340,1354,1519,1609,1791,205,703,740,888,914,915,927,1020,1039,1050,1072,1224,1274,1350,1352,717,796,886,916,924,926,930,931,996,1389,1539,1601,1679,1749,730,1044,1073,1294,1339,1468,1596,1759,1767,1788,1806,422,479,1004,1036,1047,1054,1075,1241,1816,152,516,1445,1486,1664,1673,1805,74,149,1823,81,299,300,671,672,795,1060,1437,1451,493,656,965,1225,1232,1240,1254,1256,1540,1626') 0.083789825439453
(119) DESCRIBE `cruisetypes` 0.0019819736480713
(120) DESCRIBE `destinations` 0.0027539730072021
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '37', '9', '25', '2', '8', '44', '55', '53', '39', '38', '28', '30', '26', '40', '11', '7', '48', '45', '29', '21', '49', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,37,9,25,2,8,44,55,53,39,38,28,30,26,40,11,7,48,45,29,21,49,34,52,10,46,56,32') 0.0029499530792236