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

Crystal Cruises
Crystal Symphony
Crystal Symphony

Valid: 2 May 2019 - 30 Jun 2019

71 night cruise from Athens to Auckland onboard Crystal Symphony
All onboard meals including dining in all specialty venues (once per venue~)
Complimentary select fine wines, Champagnes and premium spirits
Open-bar service throughout the ship
All non-alcoholic beverages including bottled water, specialty coffee drinks, soft drinks, fresh juices and Afternoon Tea service
Gratuities for housekeeping, bar and dining staff throughout the ship
Early embarkation luncheon
24 hour room service
Crystal Visions Enrichment & Entertainment Programmes
Port charges & government fees
Complimentary Wi-Fi
Pillow menu

Special Conditions

*Conditions apply: Valid for sales to 30 Jun 2019, unless sold out prior. Prices are cruise only, inclusive of all taxes, charges & gratuities (which are subject to change). Prices are based on lead in staterooms for the best available fares at time of publication (02 May 2019) & include savings. Supplements apply for other stateroom categories & dates. Airfares, hotels & transfers are additional. Confirmation of booking must be secured by a non-refundable deposit of 20% within the period specified at time of booking. Final payment is required no later than 120 days prior to sailing. Crystal Cruises offers each guest the opportunity to dine at least once on a complimentary basis in Prego and at least once in Umi Uma or the Sushi Bar. Additional specialty restaurant reservations are subject to US$30pp fee, subject to availability. Further conditions apply. Price/offer is subject to change or may be withdrawn without notice.

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

Total elapsed time: 0.23572874069214

# Query Time
(1) connect 0.00086402893066406
(2) DESCRIBE `specials` 0.0055251121520996
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'grand-journey-athens-to-auckland-savings-') AND (orchid_available = 1) LIMIT 1 0.0014200210571289
(4) DESCRIBE `cruises` 0.0037899017333984
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82994))) 0.00073599815368652
(6) DESCRIBE `avid_specials` 0.0014560222625732
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1549109 and class = 'Special') OR (item_id = 82994 and class = 'Cruise') OR (item_id = 66 AND class = 'Ship') OR (item_id = 14 AND class = 'CruiseLine') OR (item_id = 40 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.0014371871948242
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1549109') 0.00040316581726074
(9) DESCRIBE `ships` 0.0027430057525635
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 66))) 0.00046706199645996
(11) DESCRIBE `ships` 0.0033450126647949
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '66') 0.00031304359436035
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00031805038452148
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025701522827148
(15) DESCRIBE `itineraries` 0.0014638900756836
(16) DESCRIBE `ports` 0.0013821125030518
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033783912658691
(18) DESCRIBE `ports` 0.0012741088867188
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002901554107666
(20) DESCRIBE `ports` 0.0014021396636963
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00033402442932129
(22) DESCRIBE `specialsailingdates` 0.0010299682617188
(23) DESCRIBE `sailingdates` 0.001133918762207
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 520640))) 0.00043296813964844
(25) DESCRIBE `ports` 0.0012650489807129
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00029516220092773
(27) DESCRIBE `ports` 0.0013151168823242
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028514862060547
(29) DESCRIBE `ports` 0.0012369155883789
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 197))) 0.0002901554107666
(31) DESCRIBE `ports` 0.0012950897216797
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '197') 0.00027203559875488
(33) DESCRIBE `ports` 0.0012290477752686
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00027799606323242
(35) DESCRIBE `ports` 0.0012280941009521
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00026082992553711
(37) DESCRIBE `ports` 0.001223087310791
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00032997131347656
(39) DESCRIBE `ports` 0.0017209053039551
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00037097930908203
(41) DESCRIBE `ports` 0.0018448829650879
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00040006637573242
(43) DESCRIBE `ports` 0.0018119812011719
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00037693977355957
(45) DESCRIBE `ports` 0.0015838146209717
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00030684471130371
(47) DESCRIBE `ports` 0.0013320446014404
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00028514862060547
(49) DESCRIBE `ports` 0.0013089179992676
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00028800964355469
(51) DESCRIBE `ports` 0.0012350082397461
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00027012825012207
(53) DESCRIBE `ports` 0.0013771057128906
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00032401084899902
(55) DESCRIBE `ports` 0.001453161239624
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00026917457580566
(57) DESCRIBE `ports` 0.001230001449585
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00032401084899902
(59) DESCRIBE `ports` 0.0012960433959961
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0003209114074707
(61) DESCRIBE `ports` 0.0016508102416992
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003359317779541
(63) DESCRIBE `ports` 0.0012650489807129
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00034594535827637
(65) DESCRIBE `ports` 0.001270055770874
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00029206275939941
(67) DESCRIBE `ports` 0.0014019012451172
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00027108192443848
(69) DESCRIBE `ports` 0.001230001449585
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.0003049373626709
(71) DESCRIBE `ports` 0.0012588500976562
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00029492378234863
(73) DESCRIBE `ports` 0.0012569427490234
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2592))) 0.00029087066650391
(75) DESCRIBE `ports` 0.0014078617095947
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2592') 0.00027012825012207
(77) DESCRIBE `ports` 0.0012540817260742
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2592))) 0.00031018257141113
(79) DESCRIBE `ports` 0.0012991428375244
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2592') 0.00027108192443848
(81) DESCRIBE `ports` 0.0015139579772949
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 816))) 0.0003349781036377
(83) DESCRIBE `ports` 0.0013599395751953
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '816') 0.00028491020202637
(85) DESCRIBE `ports` 0.0013937950134277
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003058910369873
(87) DESCRIBE `ports` 0.0012450218200684
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00027203559875488
(89) DESCRIBE `ports` 0.0013999938964844
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00030279159545898
(91) DESCRIBE `ports` 0.0012691020965576
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00026893615722656
(93) DESCRIBE `ports` 0.0012919902801514
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00028705596923828
(95) DESCRIBE `ports` 0.0012369155883789
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00026917457580566
(97) DESCRIBE `ports` 0.0012650489807129
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00033903121948242
(99) DESCRIBE `ports` 0.0012271404266357
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00029706954956055
(101) DESCRIBE `ports` 0.0012829303741455
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.0003209114074707
(103) DESCRIBE `ports` 0.0013129711151123
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00028777122497559
(105) DESCRIBE `ports` 0.0012321472167969
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00030112266540527
(107) DESCRIBE `ports` 0.0012340545654297
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00032687187194824
(109) DESCRIBE `ports` 0.0012290477752686
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.0002892017364502
(111) DESCRIBE `ports` 0.0012249946594238
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00026988983154297
(113) DESCRIBE `ports` 0.001227855682373
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00029110908508301
(115) DESCRIBE `ports` 0.0012810230255127
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00027704238891602
(117) DESCRIBE `ports` 0.0012490749359131
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00028896331787109
(119) DESCRIBE `ports` 0.0012938976287842
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00026988983154297
(121) DESCRIBE `ports` 0.0012450218200684
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00037503242492676
(123) DESCRIBE `ports` 0.0013368129730225
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.0002748966217041
(125) DESCRIBE `ports` 0.0008540153503418
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.0003049373626709
(127) DESCRIBE `ports` 0.0016648769378662
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00028014183044434
(129) DESCRIBE `ports` 0.0012378692626953
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00034880638122559
(131) DESCRIBE `ports` 0.0012609958648682
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00026488304138184
(133) DESCRIBE `ports` 0.0013129711151123
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029778480529785
(135) DESCRIBE `ports` 0.0012698173522949
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002748966217041
(137) DESCRIBE `ports` 0.0013489723205566
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00030899047851562
(139) DESCRIBE `ports` 0.00124192237854
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002739429473877
(141) DESCRIBE `ports` 0.0013148784637451
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.0003049373626709
(143) DESCRIBE `ports` 0.0012490749359131
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00032496452331543
(145) DESCRIBE `ports` 0.0013141632080078
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00029110908508301
(147) DESCRIBE `ports` 0.0012960433959961
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00027108192443848
(149) DESCRIBE `ports` 0.0012340545654297
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00028204917907715
(151) DESCRIBE `ports` 0.0014369487762451
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00032186508178711
(153) DESCRIBE `ports` 0.0013959407806396
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00029492378234863
(155) DESCRIBE `ports` 0.0013189315795898
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00026607513427734
(157) DESCRIBE `ports` 0.0012400150299072
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00027799606323242
(159) DESCRIBE `ports` 0.0012919902801514
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00027608871459961
(161) DESCRIBE `ports` 0.0012309551239014
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00027585029602051
(163) DESCRIBE `ports` 0.0013229846954346
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0002601146697998
(165) DESCRIBE `ports` 0.0013577938079834
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00029993057250977
(167) DESCRIBE `ports` 0.0013229846954346
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00027108192443848
(169) DESCRIBE `ports` 0.0012249946594238
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2044))) 0.00028896331787109
(171) DESCRIBE `ports` 0.0012838840484619
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2044') 0.00027203559875488
(173) DESCRIBE `ports` 0.0012619495391846
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00037598609924316
(175) DESCRIBE `ports` 0.0012750625610352
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0003199577331543
(177) DESCRIBE `ports` 0.0012528896331787
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00028800964355469
(179) DESCRIBE `ports` 0.0013208389282227
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00027585029602051
(181) DESCRIBE `ports` 0.0012989044189453
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00029206275939941
(183) DESCRIBE `ports` 0.0013089179992676
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00033092498779297
(185) DESCRIBE `ports` 0.0012860298156738
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002892017364502
(187) DESCRIBE `ports` 0.0012271404266357
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030112266540527
(189) DESCRIBE `ports` 0.0013501644134521
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038981437683105
(191) DESCRIBE `ports` 0.0012681484222412
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(193) DESCRIBE `ports` 0.0013110637664795
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028705596923828
(195) DESCRIBE `ports` 0.0012340545654297
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033187866210938
(197) DESCRIBE `ports` 0.0015730857849121
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5565))) 0.00042295455932617
(199) DESCRIBE `ports` 0.0016670227050781
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5565') 0.00039196014404297
(201) DESCRIBE `ports` 0.001600980758667
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034689903259277
(203) DESCRIBE `ports` 0.0013959407806396
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027608871459961
(205) DESCRIBE `specialsmultipricing` 0.0012571811676025
(206) DESCRIBE `leadpricing` 0.0011420249938965
(207) DESCRIBE `specialspricing` 0.0012459754943848
(208) DESCRIBE `cabins` 0.0013861656188965
(209) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 15537))) 0.00030994415283203
(210) DESCRIBE `cabins` 0.00130295753479
(211) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 11754))) 0.00029897689819336
(212) DESCRIBE `cabins` 0.0014379024505615
(213) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2536))) 0.00030183792114258
(214) DESCRIBE `cabins` 0.0012609958648682
(215) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7970))) 0.00030207633972168
(216) DESCRIBE `currencies` 0.0011081695556641
(217) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00027894973754883
(218) DESCRIBE `currencies` 0.0010249614715576
(219) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00040507316589355
(220) DESCRIBE `currencies` 0.00019407272338867
(221) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.0002739429473877
(222) DESCRIBE `currencies` 0.0010569095611572
(223) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00045204162597656
(224) DESCRIBE `cruiselines` 0.0020871162414551
(225) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) 0.00040006637573242
(226) DESCRIBE `orchid_image` 0.001446008682251
(227) DESCRIBE `cruiselines` 0.0017850399017334
(228) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '14') 0.00029110908508301
(229) DESCRIBE `cruises` 0.0029551982879639
(230) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82994') 0.00031900405883789
(231) DESCRIBE `deckplans` 0.0013778209686279
(232) DESCRIBE `cabins` 0.0014979839324951
(233) DESCRIBE `shipphotos` 0.0013439655303955
(234) DESCRIBE `cruiselines` 0.0018150806427002
(235) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) 0.00037789344787598
(236) DESCRIBE `orchid_image` 0.0013608932495117
(237) DESCRIBE `cruiselines` 0.0017540454864502
(238) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '14') 0.00030088424682617
(239) DESCRIBE `cruises` 0.0034852027893066
(240) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71276, 11517, 41973, 77699, 11516, 77664, 77701, 66527, 71429, 54751)) ORDER BY FIND_IN_SET(id, '71276,11517,41973,77699,11516,77664,77701,66527,71429,54751') 0.0010900497436523
(241) DESCRIBE `cruiselines` 0.001147985458374
(242) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '33', '264', '23', '29', '218', '18', '47', '20', '140', '151', '37', '26', '24', '258', '14', '114', '191', '8', '15')) ORDER BY FIND_IN_SET(id, '120,212,33,264,23,29,218,18,47,20,140,151,37,26,24,258,14,114,191,8,15') 0.0019071102142334
(243) DESCRIBE `ships` 0.0029690265655518
(244) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '1767', '1013', '701', '163', '517', '1282', '75', '1159', '717', '441', '933', '1409', '616', '678', '1266', '160', '401', '451', '1398', '1402', '1819', '66', '105', '111', '147', '148', '162', '253', '390', '404', '573', '582', '652', '768', '1032', '1284', '1412', '1672', '10', '74', '98', '124', '223', '262', '287', '291', '314', '327', '332', '338', '406', '485', '580', '590', '665', '770', '780', '791', '1008', '1021', '1135', '1168', '1193', '1205', '1303', '1328', '1330', '1393', '1410', '1411', '1519', '1569', '1587', '1631', '1682', '1739', '1773')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,1767,1013,701,163,517,1282,75,1159,717,441,933,1409,616,678,1266,160,401,451,1398,1402,1819,66,105,111,147,148,162,253,390,404,573,582,652,768,1032,1284,1412,1672,10,74,98,124,223,262,287,291,314,327,332,338,406,485,580,590,665,770,780,791,1008,1021,1135,1168,1193,1205,1303,1328,1330,1393,1410,1411,1519,1569,1587,1631,1682,1739,1773') 0.0076370239257812
(245) DESCRIBE `cruisetypes` 0.0014278888702393
(246) DESCRIBE `destinations` 0.0020699501037598
(247) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '8', '22', '50', '35', '48', '12', '2', '29', '49', '34', '26', '53', '28', '55', '7', '11', '21', '37', '40')) ORDER BY FIND_IN_SET(id, '54,39,43,8,22,50,35,48,12,2,29,49,34,26,53,28,55,7,11,21,37,40') 0.0011880397796631