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

Itinerary for Cruise Orchestra, Germany UK Iceland Greenland ex Hamburg Return

Day Port Arrive Depart
Day 1 Hamburg, Germany 06:00 PM
Day 2 At Sea
Day 3 Invergordon, Scotland 08:00 AM 06:00 PM
Day 4 At Sea
Day 5 Seysdisfjordur, Iceland 08:00 AM 05:00 PM
Day 6 Akureyri, Iceland 09:00 AM 07:00 PM
Day 7 At Sea
Day 8 At Sea
Day 9 At Sea
Day 10 Nuuk, Greenland 06:00 AM 04:00 PM
Day 11 Ilulissat, Greenland 04:00 PM overnight
Day 12 Ilulissat, Greenland 06:00 PM
Day 13 At Sea
Day 14 Qaqortoq, Greenland 09:00 AM 09:00 PM
Day 15 At Sea
Day 16 At Sea
Day 17 Isafjordur, Iceland 07:00 AM 07:00 PM
Day 18 Reykjavik, Iceland 08:00 AM 06:00 PM
Day 19 At Sea
Day 20 Kirkwall, Scotland 08:00 AM 06:00 PM
Day 21 At Sea
Day 22 Hamburg, Germany 08:00 AM

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

Total elapsed time: 1.3068509101868

# Query Time
(1) connect 0.013899803161621
(2) DESCRIBE `cruises` 0.004349946975708
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'orchestra-germany-uk-iceland-greenland-ex-hamburg-return') AND (orchid_available = 1) LIMIT 1 0.88083600997925
(4) DESCRIBE `avid_specials` 0.0020968914031982
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76574 and class = 'Cruise') OR (item_id = 610 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018880367279053
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76574') 0.00045204162597656
(7) DESCRIBE `ships` 0.0043261051177979
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00078701972961426
(9) DESCRIBE `ships` 0.0055921077728271
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.0005500316619873
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036287307739258
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044488906860352
(13) DESCRIBE `itineraries` 0.0020179748535156
(14) DESCRIBE `ports` 0.0023369789123535
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.0024118423461914
(16) DESCRIBE `ports` 0.034442901611328
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00049901008605957
(18) DESCRIBE `ports` 0.0019409656524658
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00062084197998047
(20) DESCRIBE `sailingdates` 0.0017499923706055
(21) DESCRIBE `ports` 0.0045468807220459
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00063204765319824
(23) DESCRIBE `ports` 0.0021421909332275
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.0004279613494873
(25) DESCRIBE `ports` 0.0019850730895996
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00048398971557617
(27) DESCRIBE `ports` 0.0019698143005371
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00043606758117676
(29) DESCRIBE `ports` 0.0020089149475098
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.0004880428314209
(31) DESCRIBE `ports` 0.0020380020141602
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00042605400085449
(33) DESCRIBE `ports` 0.0019650459289551
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.0011229515075684
(35) DESCRIBE `ports` 0.0020339488983154
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00056290626525879
(37) DESCRIBE `ports` 0.0027310848236084
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00075793266296387
(39) DESCRIBE `ports` 0.0024170875549316
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00056695938110352
(41) DESCRIBE `ports` 0.0047330856323242
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00057697296142578
(43) DESCRIBE `ports` 0.0026199817657471
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00050902366638184
(45) DESCRIBE `ports` 0.0024352073669434
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.0005338191986084
(47) DESCRIBE `ports` 0.0057868957519531
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00081396102905273
(49) DESCRIBE `ports` 0.0049200057983398
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00063610076904297
(51) DESCRIBE `ports` 0.0029780864715576
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00050091743469238
(53) DESCRIBE `ports` 0.002964973449707
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00050783157348633
(55) DESCRIBE `ports` 0.0028321743011475
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00088810920715332
(57) DESCRIBE `ports` 0.0058870315551758
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00094890594482422
(59) DESCRIBE `ports` 0.0020320415496826
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00048398971557617
(61) DESCRIBE `ports` 0.0020420551300049
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.0010700225830078
(63) DESCRIBE `ports` 0.0021309852600098
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00044918060302734
(65) DESCRIBE `ports` 0.002032995223999
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00050210952758789
(67) DESCRIBE `ports` 0.0027499198913574
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00053310394287109
(69) DESCRIBE `cruiselines` 0.0029900074005127
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00059318542480469
(71) DESCRIBE `orchid_image` 0.0025718212127686
(72) DESCRIBE `cruiselines` 0.0032641887664795
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00065493583679199
(74) DESCRIBE `cabins` 0.0022718906402588
(75) DESCRIBE `deckplans` 0.0020949840545654
(76) DESCRIBE `shipphotos` 0.0021390914916992
(77) DESCRIBE `ports` 0.0023410320281982
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00053095817565918
(79) DESCRIBE `ports` 0.0021688938140869
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00055480003356934
(81) DESCRIBE `ports` 0.0022079944610596
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00050783157348633
(83) DESCRIBE `ports` 0.0017139911651611
(84) DESCRIBE `ports` 0.0019969940185547
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00053715705871582
(86) DESCRIBE `ports` 0.0021171569824219
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.0005500316619873
(88) DESCRIBE `ports` 0.0022420883178711
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00059795379638672
(90) DESCRIBE `ports` 0.0020380020141602
(91) DESCRIBE `ports` 0.0019049644470215
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00050711631774902
(93) DESCRIBE `ports` 0.0020439624786377
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00047016143798828
(95) DESCRIBE `ports` 0.0021688938140869
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00053095817565918
(97) DESCRIBE `ports` 0.002187967300415
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00054597854614258
(99) DESCRIBE `ports` 0.0023279190063477
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.0005040168762207
(101) DESCRIBE `ports` 0.0029230117797852
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00062012672424316
(103) DESCRIBE `ports` 0.0029680728912354
(104) DESCRIBE `ports` 0.0024359226226807
(105) DESCRIBE `ports` 0.0020909309387207
(106) DESCRIBE `ports` 0.0021100044250488
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00055098533630371
(108) DESCRIBE `ports` 0.0020828247070312
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00049304962158203
(110) DESCRIBE `ports` 0.0019910335540771
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00048685073852539
(112) DESCRIBE `ports` 0.0020890235900879
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00051116943359375
(114) DESCRIBE `ports` 0.0020840167999268
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00047993659973145
(116) DESCRIBE `ports` 0.001990795135498
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00057697296142578
(118) DESCRIBE `ports` 0.0021629333496094
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.0023040771484375
(120) DESCRIBE `ports` 0.0046980381011963
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00062799453735352
(122) DESCRIBE `ports` 0.0023350715637207
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00051403045654297
(124) DESCRIBE `ports` 0.0026018619537354
(125) DESCRIBE `ports` 0.0042359828948975
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00062918663024902
(127) DESCRIBE `ports` 0.0021309852600098
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.0016801357269287
(129) DESCRIBE `ports` 0.0039670467376709
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00095701217651367
(131) DESCRIBE `ports` 0.00229811668396
(132) DESCRIBE `ports` 0.0019760131835938
(133) DESCRIBE `ports` 0.0018298625946045
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00070691108703613
(135) DESCRIBE `ports` 0.0024640560150146
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00060296058654785
(137) DESCRIBE `ports` 0.0022990703582764
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00053596496582031
(139) DESCRIBE `ports` 0.0019979476928711
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00050997734069824
(141) DESCRIBE `ports` 0.0034129619598389
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00053095817565918
(143) DESCRIBE `ports` 0.0023899078369141
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00105881690979
(145) DESCRIBE `ports` 0.0024428367614746
(146) DESCRIBE `ports` 0.0019748210906982
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00053715705871582
(148) DESCRIBE `ports` 0.0020468235015869
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00049114227294922
(150) DESCRIBE `ports` 0.0020360946655273
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00053906440734863
(152) DESCRIBE `ports` 0.0021770000457764
(153) DESCRIBE `ports` 0.0019121170043945
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00049686431884766
(155) DESCRIBE `ports` 0.0018918514251709
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00064492225646973
(157) DESCRIBE `ports` 0.0023210048675537
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00050711631774902
(159) DESCRIBE `cruises` 0.0041911602020264
(160) SELECT `cruises`.* FROM `cruises` WHERE (id IN (23656, 34153, 34164, 34205, 34711, 38185, 44275, 44276, 46389, 47981)) ORDER BY FIND_IN_SET(id, '23656,34153,34164,34205,34711,38185,44275,44276,46389,47981') 0.0018150806427002
(161) DESCRIBE `cruiselines` 0.0036118030548096
(162) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '183', '19', '23', '12', '7', '20', '131', '18', '8', '144', '171', '221', '31', '103', '101', '268', '15', '232', '156', '96', '258', '239', '50', '251', '29', '206', '33', '191', '114', '91', '212', '14', '24', '120', '28', '37', '187', '16', '170', '262', '49', '256', '36', '204', '110', '47', '208', '195', '240', '146', '220', '181', '153', '118', '174', '229', '30', '151', '88', '108', '128', '141', '159', '35', '216', '236', '168', '196', '4', '249', '38', '200', '264', '90', '211', '238', '73', '225', '140', '113', '147', '39', '275', '57', '132', '184', '59', '213', '48', '257', '64', '276', '261', '182', '219', '230', '115', '188', '237', '95', '180', '231', '248', '52', '116', '266', '209', '105', '82', '235', '244', '62', '134', '119', '177', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,26,183,19,23,12,7,20,131,18,8,144,171,221,31,103,101,268,15,232,156,96,258,239,50,251,29,206,33,191,114,91,212,14,24,120,28,37,187,16,170,262,49,256,36,204,110,47,208,195,240,146,220,181,153,118,174,229,30,151,88,108,128,141,159,35,216,236,168,196,4,249,38,200,264,90,211,238,73,225,140,113,147,39,275,57,132,184,59,213,48,257,64,276,261,182,219,230,115,188,237,95,180,231,248,52,116,266,209,105,82,235,244,62,134,119,177,210,224,245') 0.010103940963745
(163) DESCRIBE `ships` 0.0041570663452148
(164) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1324', '1555', '1272', '517', '1794', '780', '986', '974', '1032', '258', '1292', '22', '461', '21', '797', '393', '330', '28', '977', '207', '1599', '1205', '480', '349', '11', '10', '439', '1291', '737', '333', '1010', '9', '404', '739', '1199', '1588', '1135', '1417', '265', '726', '817', '1677', '14', '855', '24', '882', '25', '770', '454', '711', '1607', '3', '113', '731', '1067', '1481', '859', '1359', '1372', '34', '38', '31', '37', '657', '837', '378', '585', '1461', '1744', '985', '1237', '1768', '1239', '542', '1163', '66', '1526', '1413', '748', '390', '1320', '1411', '1579', '1323', '1402', '1424', '332', '526', '970', '1410', '1419', '1420', '1422', '1423', '1594', '43', '573', '327', '854', '1418', '1421', '582', '1773', '39', '407', '1012', '1454', '30', '36', '590', '958', '27', '1013', '1586', '674', '791', '792', '1284', '1415', '1308', '580', '1303', '1326', '1327', '84', '114', '1552', '441', '1183', '335', '455', '1184', '1587', '1682', '35', '1245', '1193', '1236', '1742', '386', '162', '1348', '160', '325', '722', '1412', '385', '639', '434', '521', '601', '1408', '1678', '81', '1168', '452', '683', '852', '857', '1172', '1215', '1382', '1501', '858', '1021', '1176', '775', '1019', '1289', '1376', '119', '1574', '78', '201', '338', '658', '1008', '1160', '1405', '1716', '285', '673', '766', '1159', '1217', '1229', '1604', '1373', '1426', '1782', '610', '776', '1095', '1226', '1743', '111', '462', '850', '1137', '1141', '1711', '69', '211', '644', '678', '1136', '1319', '1325', '1448', '163', '286', '1383', '1384', '1628', '45', '253', '520', '851', '1358', '403', '818', '266', '314', '651', '749', '1068', '1259', '1266', '1455', '151', '968', '1458', '1569', '1630', '451', '508', '1108', '1632', '348', '467', '626', '1516', '1572', '4', '150', '1302', '1330', '1360', '1361', '1362', '63', '324', '375', '405', '869', '966', '1260', '1368', '1459', '1627', '70', '148', '389', '421', '485', '616', '663', '768', '944', '1639', '1751', '1760', '116', '262', '291', '553', '885', '1064', '1148', '1517', '1562', '1672', '1708', '108', '1301', '1322', '123', '340', '1139', '1195', '1614', '1721', '124', '287', '1343', '1452', '1521', '1580', '1581', '98', '703', '784', '954', '1088', '1717', '198', '883', '1020', '152', '290', '1212', '1321', '1575', '1724', '635', '652', '1208', '1486', '1492', '1611', '1722', '1750', '1781', '516', '1344', '1601', '147', '483', '1615', '394', '401', '796', '1150', '1398', '1714', '1738', '341', '1143', '1231', '1269', '1437', '1445', '1522', '223', '406', '559', '1230', '1496', '1539', '1771', '1040', '1075', '1268', '149', '886', '1262', '1444', '1571', '1679', '1681', '547', '717', '1151', '1270', '1557', '1593', '1673', '1684', '545', '656', '704', '716', '1367', '982', '1254', '1318', '1676', '74', '105', '761', '1740', '1766', '494', '1043', '1073', '1514', '1518', '1645', '75', '205', '574', '1144', '1157', '1218', '1566', '1704', '1767', '751', '790', '1223', '1561', '1728', '715', '1027', '1029', '1063', '1213', '1389', '82', '351', '627', '795', '808', '1082', '1453', '1471', '1540', '93', '212', '687', '868', '1025', '1090', '1146', '1158', '1283', '1612', '1613', '1706', '1709', '1729', '1772', '479', '503', '823', '1055', '1713', '1715', '665', '905', '996', '1026', '1214', '1233', '1282', '1316', '1342', '1515', '1791', '493', '767', '1145', '1188', '1297', '1409', '1783', '884', '888', '973', '1034', '1089', '1149', '1156', '1341', '1351', '1366', '1404', '1609', '695', '707', '979', '988', '1024', '1049', '1155', '1196', '1216', '1222', '1345', '1647', '1710', '1730', '417', '666', '685', '920', '921', '927', '931', '1047', '1113', '1296', '1311', '1340', '1354', '1788')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1324,1555,1272,517,1794,780,986,974,1032,258,1292,22,461,21,797,393,330,28,977,207,1599,1205,480,349,11,10,439,1291,737,333,1010,9,404,739,1199,1588,1135,1417,265,726,817,1677,14,855,24,882,25,770,454,711,1607,3,113,731,1067,1481,859,1359,1372,34,38,31,37,657,837,378,585,1461,1744,985,1237,1768,1239,542,1163,66,1526,1413,748,390,1320,1411,1579,1323,1402,1424,332,526,970,1410,1419,1420,1422,1423,1594,43,573,327,854,1418,1421,582,1773,39,407,1012,1454,30,36,590,958,27,1013,1586,674,791,792,1284,1415,1308,580,1303,1326,1327,84,114,1552,441,1183,335,455,1184,1587,1682,35,1245,1193,1236,1742,386,162,1348,160,325,722,1412,385,639,434,521,601,1408,1678,81,1168,452,683,852,857,1172,1215,1382,1501,858,1021,1176,775,1019,1289,1376,119,1574,78,201,338,658,1008,1160,1405,1716,285,673,766,1159,1217,1229,1604,1373,1426,1782,610,776,1095,1226,1743,111,462,850,1137,1141,1711,69,211,644,678,1136,1319,1325,1448,163,286,1383,1384,1628,45,253,520,851,1358,403,818,266,314,651,749,1068,1259,1266,1455,151,968,1458,1569,1630,451,508,1108,1632,348,467,626,1516,1572,4,150,1302,1330,1360,1361,1362,63,324,375,405,869,966,1260,1368,1459,1627,70,148,389,421,485,616,663,768,944,1639,1751,1760,116,262,291,553,885,1064,1148,1517,1562,1672,1708,108,1301,1322,123,340,1139,1195,1614,1721,124,287,1343,1452,1521,1580,1581,98,703,784,954,1088,1717,198,883,1020,152,290,1212,1321,1575,1724,635,652,1208,1486,1492,1611,1722,1750,1781,516,1344,1601,147,483,1615,394,401,796,1150,1398,1714,1738,341,1143,1231,1269,1437,1445,1522,223,406,559,1230,1496,1539,1771,1040,1075,1268,149,886,1262,1444,1571,1679,1681,547,717,1151,1270,1557,1593,1673,1684,545,656,704,716,1367,982,1254,1318,1676,74,105,761,1740,1766,494,1043,1073,1514,1518,1645,75,205,574,1144,1157,1218,1566,1704,1767,751,790,1223,1561,1728,715,1027,1029,1063,1213,1389,82,351,627,795,808,1082,1453,1471,1540,93,212,687,868,1025,1090,1146,1158,1283,1612,1613,1706,1709,1729,1772,479,503,823,1055,1713,1715,665,905,996,1026,1214,1233,1282,1316,1342,1515,1791,493,767,1145,1188,1297,1409,1783,884,888,973,1034,1089,1149,1156,1341,1351,1366,1404,1609,695,707,979,988,1024,1049,1155,1196,1216,1222,1345,1647,1710,1730,417,666,685,920,921,927,931,1047,1113,1296,1311,1340,1354,1788') 0.079707860946655
(165) DESCRIBE `cruisetypes` 0.0024769306182861
(166) DESCRIBE `destinations` 0.0029940605163574
(167) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '9', '37', '43', '2', '8', '39', '44', '53', '55', '26', '28', '38', '49', '11', '21', '40', '7', '48', '56', '46', '30', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,9,37,43,2,8,39,44,53,55,26,28,38,49,11,21,40,7,48,56,46,30,29,45,34,10,52,32') 0.0035059452056885