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

 
 
 
  • CroisiEurope
    Van Gogh

    Van Gogh

    Carefully maintained and partially renovated each year, the CroisiEurope fleet is largely made up of recently built vessels, less than five years old, all with...

    Star Rating River
  • Variety Cruises
    Variety Voyager

    Variety Voyager

    The new build 68m/223ft state of the art Mega Yacht accommodates just 72 passengers in 36 cabins. Built under the latest International “Safety of Life...

    Star Rating Specialty
  • Varuna

    Varuna

    Designed specifically to navigate the twists and turns of the Ganges, the Varuna opens up a whole new side of India to G Adventures travellers....

    Star Rating River
  • CroisiEurope
    Vasco de Gama

    Vasco de Gama

    Carefully maintained and partially renovated each year, the CroisiEurope fleet is largely made up of recently built vessels, less than five years old, all with...

    Star Rating River
  • Holland America Line
    Veendam

    Veendam

    Grandly proportioned and recently enhanced, the ms Veendam offers an onboard experience defined by spacious comfort and the latest Signature of Excellence features and amenities....

    Star Rating 5 Star
     
    VIEW & VERANDAH Move up, get more - Upgrade Event Book selected 2018/19 Cruises or Land+Sea journeys and receive stateroom upgrades, on board credit and discounts off shore excursions. T&C's apply.
  • P&O International
    Ventura

    Ventura

    Family-friendly, larger ship

    Ventura is one of the largest cruise ships in the P&O Cruises fleet. Ventura is where you’ll find an incredible choice of...

    Star Rating 4 Star
  • Hurtigruten
    Vesteralen

    Vesteralen

    Vesterålen was the name of the first coastal ship and is carried proudly by her modern counterpart.

    MS Vesterålen was built in 1983 and is named...

    Star Rating Specialty
  • CroisiEurope
    Victor Hugo

    Victor Hugo

    Carefully maintained and partially renovated each year, the CroisiEurope fleet is largely made up of recently built vessels, less than five years old, all with...

    Star Rating River
  • Avalon Waterways
    Victoria Anna

    Victoria Anna

    The Victoria Anna, built in 2006 and renovated in 2010, is setting the standard for Yangtze river cruising. A three-story atrium lobby welcomes guests to...

    Star Rating River
  • Uniworld Boutique River Cruise Collection
    Victoria Anna

    Victoria Anna

    Uniworld in partnership with Victoria Cruises offers you the most beautiful cruise ships on the Yangtze River. A true pioneer and innovator, Victoria Cruises delivers...

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

Total elapsed time: 0.10804915428162

# Query Time
(1) connect 0.00066900253295898
(2) DESCRIBE `ships` 0.0021288394927979
(3) DESCRIBE `cruiselines` 0.0018160343170166
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0003960132598877
(5) DESCRIBE `orchid_image` 0.0010819435119629
(6) DESCRIBE `cruiselines` 0.0012571811676025
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00028705596923828
(8) DESCRIBE `ships` 0.0021579265594482
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1051') 0.00028705596923828
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022292137145996
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021004676818848
(12) DESCRIBE `avid_specials` 0.00095295906066895
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1051 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.0015950202941895
(14) DESCRIBE `cruiselines` 0.001478910446167
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00031399726867676
(16) DESCRIBE `orchid_image` 0.0010008811950684
(17) DESCRIBE `cruiselines` 0.0012369155883789
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00026106834411621
(19) DESCRIBE `ships` 0.0018329620361328
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1000') 0.0003349781036377
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022101402282715
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020694732666016
(23) DESCRIBE `avid_specials` 0.00098514556884766
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1000 AND class = 'Ship') OR (item_id = 141 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.0015230178833008
(25) DESCRIBE `cruiselines` 0.0014231204986572
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00032591819763184
(27) DESCRIBE `orchid_image` 0.00077509880065918
(28) DESCRIBE `ships` 0.0020239353179932
(29) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1450') 0.00032711029052734
(30) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016283988952637
(31) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(32) DESCRIBE `avid_specials` 0.00071310997009277
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1450 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.00085091590881348
(34) DESCRIBE `cruiselines` 0.00094509124755859
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00025010108947754
(36) DESCRIBE `orchid_image` 0.00075793266296387
(37) DESCRIBE `cruiselines` 0.00084781646728516
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0001990795135498
(39) DESCRIBE `ships` 0.0012450218200684
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1062') 0.00018095970153809
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016117095947266
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015401840209961
(43) DESCRIBE `avid_specials` 0.00070619583129883
(44) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1062 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.0008847713470459
(45) DESCRIBE `cruiselines` 0.00091910362243652
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0002281665802002
(47) DESCRIBE `orchid_image` 0.00069785118103027
(48) DESCRIBE `cruiselines` 0.00091719627380371
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00019693374633789
(50) DESCRIBE `ships` 0.0019140243530273
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00022697448730469
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015115737915039
(54) DESCRIBE `avid_specials` 0.00057196617126465
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81 AND class = 'Ship') OR (item_id = 18 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.00090813636779785
(56) DESCRIBE `cruiselines` 0.00089502334594727
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.0002129077911377
(58) DESCRIBE `orchid_image` 0.00065708160400391
(59) DESCRIBE `cruiselines` 0.00079584121704102
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00017499923706055
(61) DESCRIBE `ships` 0.001244068145752
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '651') 0.00037598609924316
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016188621520996
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015807151794434
(65) DESCRIBE `avid_specials` 0.0006871223449707
(66) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 651 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.00094103813171387
(67) DESCRIBE `cruiselines` 0.00093984603881836
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00021505355834961
(69) DESCRIBE `orchid_image` 0.0007171630859375
(70) DESCRIBE `cruiselines` 0.00082492828369141
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.0001978874206543
(72) DESCRIBE `ships` 0.0012509822845459
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '39') 0.00018692016601562
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00015377998352051
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00014305114746094
(76) DESCRIBE `avid_specials` 0.0005950927734375
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 39 AND class = 'Ship') OR (item_id = 7 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.00085997581481934
(78) DESCRIBE `cruiselines` 0.00087189674377441
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0002129077911377
(80) DESCRIBE `orchid_image` 0.00072002410888672
(81) DESCRIBE `cruiselines` 0.00084614753723145
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0001981258392334
(83) DESCRIBE `ships` 0.0011749267578125
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1044') 0.00016403198242188
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001521110534668
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014305114746094
(87) DESCRIBE `avid_specials` 0.00057077407836914
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1044 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.00083494186401367
(89) DESCRIBE `cruiselines` 0.00095891952514648
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00019717216491699
(91) DESCRIBE `orchid_image` 0.00065493583679199
(92) DESCRIBE `cruiselines` 0.00080609321594238
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00017309188842773
(94) DESCRIBE `ships` 0.0012049674987793
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '600') 0.00018191337585449
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015091896057129
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014209747314453
(98) DESCRIBE `avid_specials` 0.00060796737670898
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 600 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.00089311599731445
(100) DESCRIBE `cruiselines` 0.00086808204650879
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00021910667419434
(102) DESCRIBE `orchid_image` 0.00067996978759766
(103) DESCRIBE `cruiselines` 0.00086021423339844
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00018501281738281
(105) DESCRIBE `ships` 0.0012929439544678
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '984') 0.00018095970153809
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014114379882812
(109) DESCRIBE `avid_specials` 0.00068807601928711
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 984 AND class = 'Ship') OR (item_id = 96 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
(111) DESCRIBE `cruises` 0.002086877822876
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34157, 34171, 34192, 38802, 41031, 44275, 44276, 49176, 49177, 49599)) ORDER BY FIND_IN_SET(id, '34157,34171,34192,38802,41031,44275,44276,49176,49177,49599') 0.0010170936584473
(113) DESCRIBE `cruiselines` 0.0016899108886719
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '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', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '229', '140', '170', '225', '275', '59', '108', '115', '113', '180', '73', '269', '264', '188', '240', '88', '219', '276', '57', '52', '248', '182', '184', '132', '90', '261', '237', '244', '95', '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, '218,77,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,151,35,238,168,196,249,159,4,146,136,209,229,140,170,225,275,59,108,115,113,180,73,269,264,188,240,88,219,276,57,52,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,224,245,177,257,210,223,263,251') 0.0043418407440186
(115) DESCRIBE `ships` 0.0018770694732666
(116) 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', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '817', '520', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '31', '573', '1285', '1586', '30', '36', '38', '39', '378', '434', '590', '792', '34', '35', '37', '1012', '327', '526', '970', '43', '1376', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1382', '1405', '338', '716', '1088', '1176', '1292', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '1575', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '253', '857', '1149', '1236', '111', '285', '852', '966', '1095', '1284', '59', '93', '403', '451', '610', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '75', '616', '666', '784', '1150', '1301', '1501', '9', '823', '996', '1587', '81', '455', '503', '776', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1366', '1372', '1411', '1571', '108', '313', '790', '1141', '1241', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '883', '1253', '74', '98', '147', '394', '937', '1579', '1172', '1454', '335', '938', '994', '1087', '66', '70', '341', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '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', '1136', '1137', '1240', '1282', '1303', '1437', '1481', '1543', '1594', '448', '717', '1090', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1110', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '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', '858', '888')) 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,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,817,520,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,31,573,1285,1586,30,36,38,39,378,434,590,792,34,35,37,1012,327,526,970,43,1376,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1382,1405,338,716,1088,1176,1292,1417,1569,1639,993,1455,314,678,722,837,1233,1575,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,253,857,1149,1236,111,285,852,966,1095,1284,59,93,403,451,610,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,75,616,666,784,1150,1301,1501,9,823,996,1587,81,455,503,776,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1366,1372,1411,1571,108,313,790,1141,1241,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,883,1253,74,98,147,394,937,1579,1172,1454,335,938,994,1087,66,70,341,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,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,1136,1137,1240,1282,1303,1437,1481,1543,1594,448,717,1090,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1110,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,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,858,888') 0.019848108291626
(117) DESCRIBE `cruisetypes` 0.0011119842529297
(118) DESCRIBE `destinations` 0.0012061595916748
(119) 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', '40', '21', '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,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.0014801025390625