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

 
 
 
  • Costa Cruises
    Costa Diadema

    Costa Diadema

    The fleet's new flagship whose name (Italian for "tiara") says it all. Costa Diadema offers the most complete, innovative and surprising experiences you could have...

    Star Rating 4 Star
  • Costa Cruises
    Costa Fascinosa

    Costa Fascinosa

    With the natural elegance of a diva and the charm of a work of art, Costa Fascinosa is the rising star of the Costa fleet....

    Star Rating 4 Star
  • Costa Cruises
    Costa Favolosa

    Costa Favolosa

    Like an enchanted fairytale castle, Costa Favolosa is surrounded by magic, decorated with precious materials and furnishings and perfected by state-of-the-art technology. Soaring, gothic-style spaces...

    Star Rating 4 Star
  • Costa Cruises
    Costa Fortuna

    Costa Fortuna

    Costa Fortuna - Museum at Sea.

    Ship of Artwork:
    There are almost five thousand works of art on board (painting/posters/ship models/maritime objects etc.)

    Ship of Fortune:
    Chinese...

    Star Rating Not Rated
  • Costa Cruises
    Costa Luminosa

    Costa Luminosa

    A new star has appeared in the Costa firmament: Costa Luminosa, a ship dazzling with light. Elegant, sophisticated and fitted out with the most precious...

    Star Rating 4 Star
  • Costa Cruises
    Costa Magica

    Costa Magica

    Costa Magica is a spectacular holiday destination. You’ll find the ambience and style of the public areas and swimming pools are inspired by some of...

    Star Rating 4 Star
  • Costa Cruises
    Costa Mediterranea

    Costa Mediterranea

    Fun, colourful and bright, the Costa Mediterranea cruise will enchant you as soon as you enter the main Hall, with its panoramic glass lifts...

    Star Rating 4 Star
  • Costa Cruises
    Costa neoRiviera

    Costa neoRiviera

    With Costa neoRiviera you'll discover a new way to travel for connoisseurs: longer stopovers you can enjoy to the full, exclusive and unusual destinations, away...

    Star Rating Not Rated
  • Costa Cruises
    Costa neoRomantica

    Costa neoRomantica

    The Costa neoRomantica cruise ship epitomizes Costa's devotion to Italian design. Richly embellished public rooms feature rare woods and Carrara marble, exquisitely detailed by the...

    Star Rating 3 Star
  • Costa Cruises
    Costa Pacifica

    Costa Pacifica

    In tune with the sea: Costa Pacifica is born
    Imagine the most thrilling music of all times and transfer it to a ship that encapsulates...

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

Total elapsed time: 0.27201247215271

# Query Time
(1) connect 0.0011529922485352
(2) DESCRIBE `ships` 0.0043299198150635
(3) DESCRIBE `cruiselines` 0.0035028457641602
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00073099136352539
(5) DESCRIBE `orchid_image` 0.0023288726806641
(6) DESCRIBE `cruiselines` 0.0027859210968018
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00048208236694336
(8) DESCRIBE `ships` 0.0035948753356934
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1272') 0.00050592422485352
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(12) DESCRIBE `avid_specials` 0.0023410320281982
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1272 AND class = 'Ship') OR (item_id = 12 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.0018727779388428
(14) DESCRIBE `cruiselines` 0.0037169456481934
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00065994262695312
(16) DESCRIBE `orchid_image` 0.0023930072784424
(17) DESCRIBE `cruiselines` 0.0026168823242188
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00042510032653809
(19) DESCRIBE `ships` 0.0035631656646729
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '986') 0.00051498413085938
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(23) DESCRIBE `avid_specials` 0.0019679069519043
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 986 AND class = 'Ship') OR (item_id = 12 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.001276969909668
(25) DESCRIBE `cruiselines` 0.0026648044586182
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00046396255493164
(27) DESCRIBE `orchid_image` 0.002263069152832
(28) DESCRIBE `cruiselines` 0.0030410289764404
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00040602684020996
(30) DESCRIBE `ships` 0.0039641857147217
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '882') 0.00037503242492676
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041103363037109
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037097930908203
(34) DESCRIBE `avid_specials` 0.0019629001617432
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 882 AND class = 'Ship') OR (item_id = 12 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.0011601448059082
(36) DESCRIBE `cruiselines` 0.0025398731231689
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.0004730224609375
(38) DESCRIBE `orchid_image` 0.0021090507507324
(39) DESCRIBE `cruiselines` 0.0029590129852295
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00041389465332031
(41) DESCRIBE `ships` 0.0035910606384277
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1677') 0.00043487548828125
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034785270690918
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003359317779541
(45) DESCRIBE `avid_specials` 0.0018620491027832
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1677 AND class = 'Ship') OR (item_id = 12 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.0012269020080566
(47) DESCRIBE `cruiselines` 0.00270676612854
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00056099891662598
(49) DESCRIBE `orchid_image` 0.0023190975189209
(50) DESCRIBE `cruiselines` 0.0025959014892578
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00039792060852051
(52) DESCRIBE `ships` 0.0035538673400879
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '715') 0.00036978721618652
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038409233093262
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(56) DESCRIBE `avid_specials` 0.0016639232635498
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 715 AND class = 'Ship') OR (item_id = 12 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.0013959407806396
(58) DESCRIBE `cruiselines` 0.0024869441986084
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00054216384887695
(60) DESCRIBE `orchid_image` 0.0021491050720215
(61) DESCRIBE `cruiselines` 0.0025780200958252
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00042200088500977
(63) DESCRIBE `ships` 0.003993034362793
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '454') 0.00046801567077637
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043082237243652
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042080879211426
(67) DESCRIBE `avid_specials` 0.0020949840545654
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 454 AND class = 'Ship') OR (item_id = 12 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.0017738342285156
(69) DESCRIBE `cruiselines` 0.0030651092529297
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00055885314941406
(71) DESCRIBE `orchid_image` 0.002187967300415
(72) DESCRIBE `cruiselines` 0.0025949478149414
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.0004429817199707
(74) DESCRIBE `ships` 0.0037209987640381
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '351') 0.0004889965057373
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048089027404785
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044703483581543
(78) DESCRIBE `avid_specials` 0.0020768642425537
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 351 AND class = 'Ship') OR (item_id = 12 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.0013110637664795
(80) DESCRIBE `cruiselines` 0.0026040077209473
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00050210952758789
(82) DESCRIBE `orchid_image` 0.0021491050720215
(83) DESCRIBE `cruiselines` 0.0034379959106445
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00043916702270508
(85) DESCRIBE `ships` 0.0036640167236328
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1195') 0.00057411193847656
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00039982795715332
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034499168395996
(89) DESCRIBE `avid_specials` 0.0016129016876221
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1195 AND class = 'Ship') OR (item_id = 12 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.0013079643249512
(91) DESCRIBE `cruiselines` 0.0025768280029297
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00049710273742676
(93) DESCRIBE `orchid_image` 0.0019140243530273
(94) DESCRIBE `cruiselines` 0.0024950504302979
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.0003969669342041
(96) DESCRIBE `ships` 0.003511905670166
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '62') 0.00042891502380371
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00037097930908203
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034093856811523
(100) DESCRIBE `avid_specials` 0.0015640258789062
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62 AND class = 'Ship') OR (item_id = 12 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.001133918762207
(102) DESCRIBE `cruiselines` 0.0025279521942139
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00048208236694336
(104) DESCRIBE `orchid_image` 0.0021121501922607
(105) DESCRIBE `cruiselines` 0.0032529830932617
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00053095817565918
(107) DESCRIBE `ships` 0.0045537948608398
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '716') 0.00058794021606445
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048589706420898
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040793418884277
(111) DESCRIBE `avid_specials` 0.0020301342010498
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 716 AND class = 'Ship') OR (item_id = 12 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.0017049312591553
(113) DESCRIBE `cruises` 0.0046589374542236
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (25397, 34153, 34711, 52512, 52647, 53527, 54185, 56846, 57661, 59167)) ORDER BY FIND_IN_SET(id, '25397,34153,34711,52512,52647,53527,54185,56846,57661,59167') 0.0016889572143555
(115) DESCRIBE `cruiselines` 0.003385066986084
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '183', '101', '8', '31', '120', '131', '29', '96', '103', '15', '206', '91', '262', '33', '24', '114', '170', '14', '28', '156', '258', '191', '50', '195', '37', '153', '208', '16', '49', '187', '36', '88', '47', '251', '151', '216', '141', '212', '181', '4', '118', '110', '59', '140', '30', '147', '48', '261', '73', '213', '211', '276', '209', '115', '159', '264', '108', '113', '82', '57', '90', '95', '184', '244', '52', '180', '38', '64', '35', '105', '134', '257', '245')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,183,101,8,31,120,131,29,96,103,15,206,91,262,33,24,114,170,14,28,156,258,191,50,195,37,153,208,16,49,187,36,88,47,251,151,216,141,212,181,4,118,110,59,140,30,147,48,261,73,213,211,276,209,115,159,264,108,113,82,57,90,95,184,244,52,180,38,64,35,105,134,257,245') 0.007216215133667
(117) DESCRIBE `ships` 0.0039219856262207
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '258', '517', '1324', '780', '737', '1417', '1588', '1717', '855', '871', '207', '1794', '1766', '1291', '874', '977', '1572', '454', '1594', '404', '1359', '770', '1272', '1199', '22', '66', '21', '330', '461', '1032', '393', '738', '1134', '434', '1424', '716', '974', '553', '28', '265', '1237', '332', '1292', '1682', '333', '797', '1768', '521', '1348', '349', '1260', '1419', '1423', '1422', '1418', '1420', '1421', '1415', '766', '711', '715', '9', '163', '792', '455', '11', '25', '407', '1678', '10', '439', '739', '857', '585', '674', '858', '1132', '1501', '1677', '657', '3', '24', '34', '542', '36', '378', '1460', '31', '39', '520', '1008', '1721', '1852', '966', '1141', '1569', '1233', '385', '1607', '1742', '1822', '1505', '1811', '386', '1168', '1372', '1402', '1676', '1302', '35', '626', '837', '1012', '1455', '1773', '768', '850', '1373', '98', '1205', '113', '986', '1319', '451', '817', '1602', '338', '573', '882', '1282', '1413', '160', '1135', '1574', '1021', '1067', '1410', '1782', '352', '610', '1259', '1284', '1411', '1733', '285', '547', '1454', '37', '111', '63', '148', '1398', '30', '108', '198', '314', '375', '1063', '1437', '508', '1145', '1193', '1722', '627', '883', '1088', '1308', '286', '1808', '38', '748', '1149', '43', '340', '406', '526', '970', '1320', '1323', '1579', '1711', '485', '1028', '124', '327', '1108', '1325', '394', '854', '1068', '1586', '116', '348', '390', '582', '1492', '1810', '590', '1157', '1321', '1412', '1571', '1724', '1738', '616', '1461', '1809', '119', '223', '1208', '1575', '1672', '1801', '82', '462', '652', '944', '1853', '114', '351', '791', '1027', '1587', '147', '704', '503', '545', '678', '884', '1266', '1318', '1408', '1552', '1820', '4', '70', '75', '78', '335', '683', '658', '1139', '1486', '201', '325', '401', '441', '722', '958', '988', '1188', '1289', '1330', '81', '149', '162', '291', '601', '1772', '403', '790', '1326', '1327', '1771', '105', '287', '580', '776', '1073', '1367', '69', '389', '423', '651', '1037', '1043', '1151', '1236', '1303', '1704', '1757', '818', '1040', '1539', '123', '262', '341', '1013', '1019', '266', '405', '1172', '290', '480', '483', '673', '796', '1223', '1526', '45', '639', '1159', '1474', '1540', '1740', '84', '751', '1029', '1338', '1715', '1743', '1758', '795', '852', '1035', '1160', '1163', '1206', '1245', '1344', '1426', '1681', '635', '968', '972', '1146', '1150', '1217', '1226', '1229', '1452', '1453', '1573', '1604', '1716', '324', '417', '643', '709', '717', '1143', '1144', '1283', '1343', '1358', '1483', '1807', '1833', '574', '775', '851', '905', '1048', '1136', '1262', '1293', '1448', '1746', '1042', '1045', '1095', '1230', '1231', '1663', '1787', '467', '885', '1026', '1051', '1137', '1730', '1749', '1791', '1140', '1154', '1340', '1351', '1409', '1458', '1463', '1723', '1759', '1806', '663', '665', '954', '1224', '1366', '1368', '1459', '1609', '1632', '1673', '1751', '151', '559', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '212', '448', '666', '914', '921', '923', '927', '1025', '1044', '1055', '1072', '1090', '1152', '1196', '1339', '1449', '1601', '1714', '1788', '1823', '208', '453', '886', '915', '916', '926', '930', '931', '1109', '1322', '1649', '1750', '1816', '1854', '703', '769', '924', '1047', '1052', '1519', '1596', '1650', '150', '299', '300', '422', '740', '1004', '1020', '1036', '1039', '1054', '1225', '1352', '1451', '1580', '707', '937', '1294', '1389', '479', '487', '672', '888', '1071', '1256', '1301', '1329', '93', '205', '671', '821', '1232', '1445', '1664', '516', '644', '784', '1005', '1060', '1350', '1405', '1626', '1792', '1821')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,258,517,1324,780,737,1417,1588,1717,855,871,207,1794,1766,1291,874,977,1572,454,1594,404,1359,770,1272,1199,22,66,21,330,461,1032,393,738,1134,434,1424,716,974,553,28,265,1237,332,1292,1682,333,797,1768,521,1348,349,1260,1419,1423,1422,1418,1420,1421,1415,766,711,715,9,163,792,455,11,25,407,1678,10,439,739,857,585,674,858,1132,1501,1677,657,3,24,34,542,36,378,1460,31,39,520,1008,1721,1852,966,1141,1569,1233,385,1607,1742,1822,1505,1811,386,1168,1372,1402,1676,1302,35,626,837,1012,1455,1773,768,850,1373,98,1205,113,986,1319,451,817,1602,338,573,882,1282,1413,160,1135,1574,1021,1067,1410,1782,352,610,1259,1284,1411,1733,285,547,1454,37,111,63,148,1398,30,108,198,314,375,1063,1437,508,1145,1193,1722,627,883,1088,1308,286,1808,38,748,1149,43,340,406,526,970,1320,1323,1579,1711,485,1028,124,327,1108,1325,394,854,1068,1586,116,348,390,582,1492,1810,590,1157,1321,1412,1571,1724,1738,616,1461,1809,119,223,1208,1575,1672,1801,82,462,652,944,1853,114,351,791,1027,1587,147,704,503,545,678,884,1266,1318,1408,1552,1820,4,70,75,78,335,683,658,1139,1486,201,325,401,441,722,958,988,1188,1289,1330,81,149,162,291,601,1772,403,790,1326,1327,1771,105,287,580,776,1073,1367,69,389,423,651,1037,1043,1151,1236,1303,1704,1757,818,1040,1539,123,262,341,1013,1019,266,405,1172,290,480,483,673,796,1223,1526,45,639,1159,1474,1540,1740,84,751,1029,1338,1715,1743,1758,795,852,1035,1160,1163,1206,1245,1344,1426,1681,635,968,972,1146,1150,1217,1226,1229,1452,1453,1573,1604,1716,324,417,643,709,717,1143,1144,1283,1343,1358,1483,1807,1833,574,775,851,905,1048,1136,1262,1293,1448,1746,1042,1045,1095,1230,1231,1663,1787,467,885,1026,1051,1137,1730,1749,1791,1140,1154,1340,1351,1409,1458,1463,1723,1759,1806,663,665,954,1224,1366,1368,1459,1609,1632,1673,1751,151,559,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,212,448,666,914,921,923,927,1025,1044,1055,1072,1090,1152,1196,1339,1449,1601,1714,1788,1823,208,453,886,915,916,926,930,931,1109,1322,1649,1750,1816,1854,703,769,924,1047,1052,1519,1596,1650,150,299,300,422,740,1004,1020,1036,1039,1054,1225,1352,1451,1580,707,937,1294,1389,479,487,672,888,1071,1256,1301,1329,93,205,671,821,1232,1445,1664,516,644,784,1005,1060,1350,1405,1626,1792,1821') 0.065840005874634
(119) DESCRIBE `cruisetypes` 0.0018250942230225
(120) DESCRIBE `destinations` 0.0028631687164307
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '2', '9', '8', '44', '55', '39', '53', '26', '38', '28', '40', '30', '49', '11', '21', '7', '45', '29', '48', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,2,9,8,44,55,39,53,26,38,28,40,30,49,11,21,7,45,29,48,52,34,10,46,56,32') 0.0030839443206787