or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

Sign up to our newsletter and become the first to know about our latest deals and promotions

Cruise Ships

Search for Cruise Ships

 
 
 
  • 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
  • Panama Marine Adventures
    Discovery

    Discovery

    Passenger numbers on the Discovery are limited to just 24, ensuring everyone can enjoy serenity and privacy together with the excitement and closeness of a...

    Star Rating Specialty
  • 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
  • Disney Cruise Line
    Disney Magic

    Disney Magic

    From the hearts and minds of the dream-makers at Disney come the most imaginative vessel afloat: The Disney Magic®. Step aboard and discover a ship...

    Star Rating 4 Star
  • Disney Cruise Line
    Disney Wonder

    Disney Wonder

    From the hearts and minds of the dream-makers at Disney come the most imaginative vessel afloat: The Disney Wonder®. Step aboard and discover a ship...

    Star Rating 4 Star
  • CroisiEurope
    Douce France

    Douce France

    CroisiEurope has a fleet of 27 Prestige category boats with cabins, which ply the most beautiful rivers in Europe. Spacious and light, they offer a...

    Star Rating River
  • Nicko Tours
    Douro Cruiser

    Douro Cruiser

    Welcome on board our MS DOURO CRUISER. You are guaranteed the best views here! Relay on the sun deck and enjoy the magnificent landscape of...

    Star Rating River
  • Riviera Travel
    Douro Elegance

    Douro Elegance

    We are absolutely thrilled to announce that for 2017 our highly successful Douro cruise on Portugal’s most spectacular waterway will be operated on a brand...

    Star Rating 5 Star
  • Travelmarvel
    Douro Queen

    Douro Queen

    Relax beside the pool, enjoy a cool drink in the lounge or take an afternoon siesta in your air-conditioned stateroom aboard the stunning ms Douro...

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

Total elapsed time: 0.16319966316223

# Query Time
(1) connect 0.00057387351989746
(2) DESCRIBE `ships` 0.0025699138641357
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'd') 0.0071899890899658
(4) connect 0.00055313110351562
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'd') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.0080780982971191
(6) DESCRIBE `cruiselines` 0.0020179748535156
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037407875061035
(8) DESCRIBE `orchid_image` 0.0012040138244629
(9) DESCRIBE `cruiselines` 0.0015950202941895
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031113624572754
(11) DESCRIBE `ships` 0.0023598670959473
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00034999847412109
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021100044250488
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019383430480957
(15) DESCRIBE `avid_specials` 0.00130295753479
(16) 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.0018970966339111
(17) DESCRIBE `cruiselines` 0.0016450881958008
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 224))) 0.00045299530029297
(19) DESCRIBE `orchid_image` 0.0012609958648682
(20) DESCRIBE `cruiselines` 0.0015091896057129
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '224') 0.00029516220092773
(22) DESCRIBE `ships` 0.0023150444030762
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1173') 0.00034284591674805
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025010108947754
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020813941955566
(26) DESCRIBE `avid_specials` 0.0010230541229248
(27) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1173 AND class = 'Ship') OR (item_id = 224 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.0016610622406006
(28) DESCRIBE `cruiselines` 0.0016410350799561
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.0003359317779541
(30) DESCRIBE `orchid_image` 0.0012021064758301
(31) DESCRIBE `cruiselines` 0.0015220642089844
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00034809112548828
(33) DESCRIBE `ships` 0.002255916595459
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0.00034093856811523
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023007392883301
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022602081298828
(37) DESCRIBE `avid_specials` 0.0010480880737305
(38) 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.0015981197357178
(39) DESCRIBE `cruiselines` 0.0018730163574219
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00035715103149414
(41) DESCRIBE `orchid_image` 0.0011827945709229
(42) DESCRIBE `cruiselines` 0.0014979839324951
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00026702880859375
(44) DESCRIBE `ships` 0.0020360946655273
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '944') 0.00033092498779297
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(48) DESCRIBE `avid_specials` 0.00099802017211914
(49) 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.0016369819641113
(50) DESCRIBE `cruiselines` 0.0015370845794678
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00034689903259277
(52) DESCRIBE `orchid_image` 0.0011069774627686
(53) DESCRIBE `cruiselines` 0.0014069080352783
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00030303001403809
(55) DESCRIBE `ships` 0.0019729137420654
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '69') 0.00027179718017578
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023102760314941
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(59) DESCRIBE `avid_specials` 0.00094008445739746
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69 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.0016570091247559
(61) DESCRIBE `cruiselines` 0.0016481876373291
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00036001205444336
(63) DESCRIBE `orchid_image` 0.0012111663818359
(64) DESCRIBE `cruiselines` 0.0015559196472168
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00029611587524414
(66) DESCRIBE `ships` 0.0021591186523438
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '70') 0.00032401084899902
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024199485778809
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022006034851074
(70) DESCRIBE `avid_specials` 0.0010538101196289
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70 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.0016660690307617
(72) DESCRIBE `cruiselines` 0.0015220642089844
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00036191940307617
(74) DESCRIBE `orchid_image` 0.0011928081512451
(75) DESCRIBE `cruiselines` 0.001410961151123
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00027704238891602
(77) DESCRIBE `ships` 0.0021300315856934
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1036') 0.00031304359436035
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023603439331055
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022506713867188
(81) DESCRIBE `avid_specials` 0.0010421276092529
(82) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1036 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.0017590522766113
(83) DESCRIBE `cruiselines` 0.0016400814056396
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.0003659725189209
(85) DESCRIBE `orchid_image` 0.0011880397796631
(86) DESCRIBE `cruiselines` 0.0010321140289307
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00020480155944824
(88) DESCRIBE `ships` 0.0017778873443604
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1543') 0.00029611587524414
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021219253540039
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019717216491699
(92) DESCRIBE `avid_specials` 0.00088310241699219
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1543 AND class = 'Ship') OR (item_id = 204 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.0016298294067383
(94) DESCRIBE `cruiselines` 0.0013511180877686
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 268))) 0.00031280517578125
(96) DESCRIBE `orchid_image` 0.0010509490966797
(97) DESCRIBE `cruiselines` 0.0012180805206299
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '268') 0.00025200843811035
(99) DESCRIBE `ships` 0.0017349720001221
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1516') 0.00023412704467773
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016212463378906
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014805793762207
(103) DESCRIBE `avid_specials` 0.0006108283996582
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1516 AND class = 'Ship') OR (item_id = 268 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.0009157657623291
(105) DESCRIBE `cruiselines` 0.0009160041809082
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00022602081298828
(107) DESCRIBE `orchid_image` 0.00095105171203613
(108) DESCRIBE `cruiselines` 0.0012280941009521
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00026392936706543
(110) DESCRIBE `ships` 0.0016560554504395
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1485') 0.0002589225769043
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019311904907227
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018191337585449
(114) DESCRIBE `avid_specials` 0.00088095664978027
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1485 AND class = 'Ship') OR (item_id = 249 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.0014381408691406
(116) DESCRIBE `cruises` 0.0025269985198975
(117) SELECT `cruises`.* FROM `cruises` WHERE (id IN (13509, 13510, 29119, 34165, 34185, 38147, 38149, 40591, 40596, 41360)) ORDER BY FIND_IN_SET(id, '13509,13510,29119,34165,34185,38147,38149,40591,40596,41360') 0.0013561248779297
(118) DESCRIBE `cruiselines` 0.0017669200897217
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '101', '120', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '35', '151', '238', '196', '168', '249', '159', '4', '146', '136', '209', '229', '140', '170', '225', '275', '188', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '248', '182', '184', '132', '90', '261', '237', '95', '244', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '224', '245', '177', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '77,218,26,171,19,183,31,23,20,7,18,144,8,12,221,101,120,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,35,151,238,196,168,249,159,4,146,136,209,229,140,170,225,275,188,59,108,115,113,180,73,269,264,240,88,219,276,57,52,248,182,184,132,90,261,237,95,244,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,224,245,177,257,210,223,263,251') 0.004796028137207
(120) DESCRIBE `ships` 0.0025730133056641
(121) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '10', '349', '974', '855', '407', '770', '871', '1599', '1460', '797', '404', '14', '1581', '1215', '265', '330', '1067', '739', '25', '874', '1572', '726', '859', '585', '731', '711', '452', '542', '766', '780', '817', '520', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '573', '1285', '1586', '30', '31', '36', '38', '378', '434', '590', '792', '34', '35', '37', '1012', '39', '327', '526', '970', '43', '1376', '1614', '553', '163', '1348', '1027', '580', '1245', '454', '78', '1326', '1327', '1402', '340', '333', '986', '882', '1008', '521', '11', '1134', '325', '116', '1021', '1325', '547', '1382', '1405', '338', '716', '1013', '1088', '1176', '1292', '1417', '1569', '1639', '993', '1455', '314', '722', '837', '1233', '1575', '124', '678', '701', '823', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '657', '765', '1075', '253', '480', '1149', '1236', '111', '852', '857', '966', '1095', '1137', '59', '93', '285', '403', '451', '1284', '1526', '84', '160', '406', '441', '610', '1163', '1343', '1373', '114', '626', '1136', '1168', '1319', '1383', '1384', '1452', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1448', '1607', '1243', '1489', '1602', '75', '666', '1150', '1301', '1501', '9', '784', '996', '1458', '1587', '81', '455', '616', '776', '954', '1026', '348', '503', '574', '5', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1366', '1372', '1411', '1571', '108', '313', '790', '1241', '390', '651', '1068', '1141', '1318', '1320', '1552', '123', '287', '291', '704', '884', '1208', '1224', '1492', '582', '148', '658', '1344', '1611', '1647', '3', '332', '652', '1139', '1148', '1408', '150', '208', '467', '669', '1064', '1398', '1505', '483', '674', '1308', '1321', '1413', '1453', '1486', '1612', '212', '223', '768', '883', '1253', '74', '98', '147', '394', '937', '1579', '1172', '1454', '335', '938', '994', '1087', '66', '70', '341', '995', '1108', '262', '485', '559', '1154', '1231', '1539', '151', '958', '1157', '1347', '1461', '1613', '149', '1017', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '775', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1439', '715', '973', '1023', '1043', '1144', '1262', '1545', '494', '673', '1240', '1282', '1303', '1437', '1481', '1543', '1594', '448', '717', '1090', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1716', '1025', '1106', '1110', '1151', '1160', '1226', '1367', '417', '905', '1063', '1274', '1322', '288', '601', '635', '743', '1037', '493', '795', '818', '821', '1217', '1338', '1358', '1714', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '672', '1049', '1339', '1426', '1541', '385', '421', '618', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,10,349,974,855,407,770,871,1599,1460,797,404,14,1581,1215,265,330,1067,739,25,874,1572,726,859,585,731,711,452,542,766,780,817,520,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,573,1285,1586,30,31,36,38,378,434,590,792,34,35,37,1012,39,327,526,970,43,1376,1614,553,163,1348,1027,580,1245,454,78,1326,1327,1402,340,333,986,882,1008,521,11,1134,325,116,1021,1325,547,1382,1405,338,716,1013,1088,1176,1292,1417,1569,1639,993,1455,314,722,837,1233,1575,124,678,701,823,850,1345,1615,4,162,683,732,119,286,1145,82,657,765,1075,253,480,1149,1236,111,852,857,966,1095,1137,59,93,285,403,451,1284,1526,84,160,406,441,610,1163,1343,1373,114,626,1136,1168,1319,1383,1384,1452,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1448,1607,1243,1489,1602,75,666,1150,1301,1501,9,784,996,1458,1587,81,455,616,776,954,1026,348,503,574,5,290,324,389,854,1109,1260,508,851,885,1366,1372,1411,1571,108,313,790,1241,390,651,1068,1141,1318,1320,1552,123,287,291,704,884,1208,1224,1492,582,148,658,1344,1611,1647,3,332,652,1139,1148,1408,150,208,467,669,1064,1398,1505,483,674,1308,1321,1413,1453,1486,1612,212,223,768,883,1253,74,98,147,394,937,1579,1172,1454,335,938,994,1087,66,70,341,995,1108,262,485,559,1154,1231,1539,151,958,1157,1347,1461,1613,149,1017,69,375,944,1058,1159,1230,1355,1362,1368,152,775,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1439,715,973,1023,1043,1144,1262,1545,494,673,1240,1282,1303,1437,1481,1543,1594,448,717,1090,1132,1214,1229,1266,1283,1471,1546,1716,1025,1106,1110,1151,1160,1226,1367,417,905,1063,1274,1322,288,601,635,743,1037,493,795,818,821,1217,1338,1358,1714,62,386,997,1073,1649,1704,17,201,266,479,672,1049,1339,1426,1541,385,421,618,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,915,916,926,1001,1072,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811') 0.02557897567749
(122) DESCRIBE `cruisetypes` 0.0012719631195068
(123) DESCRIBE `destinations` 0.0016191005706787
(124) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '21', '40', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,21,40,49,48,7,30,29,56,52,10,34,46,45,32') 0.0017218589782715