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

Princess Cruises
Sea Princess
Sea Princess

Valid: 2 Oct 2018 - 30 Apr 2019

- 106 night cruise aboard Sea Princess
- Main meals & entertainment on board
- Port charges & government fees

Up to $1000 on board credit per person

Complimentary Mini-Bar set up for Suites only

Past Princess Guests can also get an extra savings of up to $1000 per person

Special Conditions

Cruise based on twin share, includes port charges, government taxes and all applicable discounts. For new bookings only. All fares and taxes are subject to change without notice up until full payment is received. Subject to availability & currency fluctuations. Credit card payments will incur a fee. Additional conditions may apply. Valid for sale till 30/04/2019 unless sold out prior. A first deposit will be required within 3 days of booking and a 2nd deposit will be required before final payment. Full terms and conditions will be advised at the time of booking

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

Total elapsed time: 0.68082809448242

# Query Time
(1) connect 0.0010471343994141
(2) DESCRIBE `specials` 0.0079870223999023
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '106-night-world-cruise-aboard-sea-princess') AND (orchid_available = 1) LIMIT 1 0.0015389919281006
(4) DESCRIBE `cruises` 0.0042788982391357
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79614))) 0.00087189674377441
(6) DESCRIBE `avid_specials` 0.0017120838165283
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1487512 and class = 'Special') OR (item_id = 79614 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0018420219421387
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1487512') 0.00053191184997559
(9) DESCRIBE `ships` 0.0045089721679688
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00072097778320312
(11) DESCRIBE `ships` 0.0044498443603516
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00059390068054199
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(15) DESCRIBE `itineraries` 0.0020418167114258
(16) DESCRIBE `ports` 0.0025920867919922
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00059914588928223
(18) DESCRIBE `ports` 0.0027658939361572
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054621696472168
(20) DESCRIBE `ports` 0.0020630359649658
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040793418884277
(22) DESCRIBE `specialsailingdates` 0.0016739368438721
(23) DESCRIBE `sailingdates` 0.0020740032196045
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493173))) 0.00052690505981445
(25) DESCRIBE `ports` 0.0023109912872314
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00056314468383789
(27) DESCRIBE `ports` 0.0021481513977051
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00048518180847168
(29) DESCRIBE `ports` 0.0020959377288818
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00051999092102051
(31) DESCRIBE `ports` 0.012351989746094
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0035641193389893
(33) DESCRIBE `ports` 0.0071501731872559
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063300132751465
(35) DESCRIBE `ports` 0.0021750926971436
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052618980407715
(37) DESCRIBE `ports` 0.0019171237945557
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00052118301391602
(39) DESCRIBE `ports` 0.0018348693847656
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040817260742188
(41) DESCRIBE `ports` 0.0021789073944092
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.0005040168762207
(43) DESCRIBE `ports` 0.0020430088043213
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.0004580020904541
(45) DESCRIBE `ports` 0.0020499229431152
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00054001808166504
(47) DESCRIBE `ports` 0.0021021366119385
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00046396255493164
(49) DESCRIBE `ports` 0.0020239353179932
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00046801567077637
(51) DESCRIBE `ports` 0.0020251274108887
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00045108795166016
(53) DESCRIBE `ports` 0.0020191669464111
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00050687789916992
(55) DESCRIBE `ports` 0.002068042755127
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00046515464782715
(57) DESCRIBE `ports` 0.0020079612731934
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00048208236694336
(59) DESCRIBE `ports` 0.012065887451172
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.01697301864624
(61) DESCRIBE `ports` 0.0027041435241699
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052189826965332
(63) DESCRIBE `ports` 0.0023031234741211
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00046181678771973
(65) DESCRIBE `ports` 0.0019900798797607
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00044584274291992
(67) DESCRIBE `ports` 0.0019810199737549
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00042009353637695
(69) DESCRIBE `ports` 0.0019700527191162
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00050783157348633
(71) DESCRIBE `ports` 0.0019428730010986
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00044989585876465
(73) DESCRIBE `ports` 0.0019450187683105
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00044107437133789
(75) DESCRIBE `ports` 0.0018470287322998
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00048017501831055
(77) DESCRIBE `ports` 0.0018579959869385
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045895576477051
(79) DESCRIBE `ports` 0.010926961898804
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00051999092102051
(81) DESCRIBE `ports` 0.0020339488983154
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.0005040168762207
(83) DESCRIBE `ports` 0.017828941345215
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.0015010833740234
(85) DESCRIBE `ports` 0.0020570755004883
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057411193847656
(87) DESCRIBE `ports` 0.0019910335540771
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00046586990356445
(89) DESCRIBE `ports` 0.0025548934936523
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00069713592529297
(91) DESCRIBE `ports` 0.0019338130950928
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00046706199645996
(93) DESCRIBE `ports` 0.0017979145050049
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00047087669372559
(95) DESCRIBE `ports` 0.0018329620361328
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00037884712219238
(97) DESCRIBE `ports` 0.0016510486602783
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043487548828125
(99) DESCRIBE `ports` 0.0018248558044434
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00042510032653809
(101) DESCRIBE `ports` 0.0018391609191895
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00046396255493164
(103) DESCRIBE `ports` 0.0019569396972656
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00043201446533203
(105) DESCRIBE `ports` 0.0019261837005615
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00054502487182617
(107) DESCRIBE `ports` 0.0020580291748047
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00051498413085938
(109) DESCRIBE `ports` 0.0026159286499023
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 274))) 0.00054407119750977
(111) DESCRIBE `ports` 0.0019371509552002
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '274') 0.00045394897460938
(113) DESCRIBE `ports` 0.0018539428710938
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00041604042053223
(115) DESCRIBE `ports` 0.0021131038665771
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00045204162597656
(117) DESCRIBE `ports` 0.0025398731231689
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00076198577880859
(119) DESCRIBE `ports` 0.0020380020141602
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00053191184997559
(121) DESCRIBE `ports` 0.0020079612731934
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00056910514831543
(123) DESCRIBE `ports` 0.0025260448455811
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00052785873413086
(125) DESCRIBE `ports` 0.040746212005615
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0043549537658691
(127) DESCRIBE `ports` 0.0087411403656006
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.014381170272827
(129) DESCRIBE `ports` 0.0036790370941162
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.0014410018920898
(131) DESCRIBE `ports` 0.002406120300293
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00086498260498047
(133) DESCRIBE `ports` 0.0020709037780762
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00050783157348633
(135) DESCRIBE `ports` 0.013865947723389
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.0013928413391113
(137) DESCRIBE `ports` 0.0038480758666992
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.0020740032196045
(139) DESCRIBE `ports` 0.0038461685180664
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.0015039443969727
(141) DESCRIBE `ports` 0.0021657943725586
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 800))) 0.00051403045654297
(143) DESCRIBE `ports` 0.0019690990447998
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '800') 0.00046610832214355
(145) DESCRIBE `ports` 0.0019669532775879
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00050902366638184
(147) DESCRIBE `ports` 0.0020279884338379
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00044512748718262
(149) DESCRIBE `ports` 0.001986026763916
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00044488906860352
(151) DESCRIBE `ports` 0.0019738674163818
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00043892860412598
(153) DESCRIBE `ports` 0.0017569065093994
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00051593780517578
(155) DESCRIBE `ports` 0.0020701885223389
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00046491622924805
(157) DESCRIBE `ports` 0.0019800662994385
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00046992301940918
(159) DESCRIBE `ports` 0.0020918846130371
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00069308280944824
(161) DESCRIBE `ports` 0.001957893371582
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0004730224609375
(163) DESCRIBE `ports` 0.0019090175628662
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00044798851013184
(165) DESCRIBE `ports` 0.0019130706787109
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0005640983581543
(167) DESCRIBE `ports` 0.0019440650939941
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0004730224609375
(169) DESCRIBE `ports` 0.0018889904022217
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044512748718262
(171) DESCRIBE `ports` 0.0018520355224609
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00045299530029297
(173) DESCRIBE `ports` 0.001910924911499
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00045585632324219
(175) DESCRIBE `ports` 0.037163972854614
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00054502487182617
(177) DESCRIBE `ports` 0.0034151077270508
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00069189071655273
(179) DESCRIBE `ports` 0.0020759105682373
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00044393539428711
(181) DESCRIBE `ports` 0.0017468929290771
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00048589706420898
(183) DESCRIBE `ports` 0.0023379325866699
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00055313110351562
(185) DESCRIBE `ports` 0.0020418167114258
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00051689147949219
(187) DESCRIBE `ports` 0.0020179748535156
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00046610832214355
(189) DESCRIBE `ports` 0.00205397605896
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00060892105102539
(191) DESCRIBE `ports` 0.0020630359649658
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00048208236694336
(193) DESCRIBE `ports` 0.0019359588623047
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 880))) 0.00051188468933105
(195) DESCRIBE `ports` 0.0019299983978271
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '880') 0.00045013427734375
(197) DESCRIBE `ports` 0.0019869804382324
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) 0.0020229816436768
(199) DESCRIBE `ports` 0.015085935592651
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') 0.00050711631774902
(201) DESCRIBE `ports` 0.0022821426391602
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1332))) 0.00047206878662109
(203) DESCRIBE `ports` 0.0018930435180664
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1332') 0.00048089027404785
(205) DESCRIBE `ports` 0.0019540786743164
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00046515464782715
(207) DESCRIBE `ports` 0.0018279552459717
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00040817260742188
(209) DESCRIBE `ports` 0.0021500587463379
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00046396255493164
(211) DESCRIBE `ports` 0.0022101402282715
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00054097175598145
(213) DESCRIBE `ports` 0.0019409656524658
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.021378040313721
(215) DESCRIBE `ports` 0.011645078659058
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00045084953308105
(217) DESCRIBE `ports` 0.0019137859344482
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046396255493164
(219) DESCRIBE `ports` 0.0020210742950439
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046014785766602
(221) DESCRIBE `specialsmultipricing` 0.0021309852600098
(222) DESCRIBE `leadpricing` 0.0020079612731934
(223) DESCRIBE `specials` 0.0060369968414307
(224) DESCRIBE `currencies` 0.0019359588623047
(225) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00047111511230469
(226) DESCRIBE `cruiselines` 0.0030829906463623
(227) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00066184997558594
(228) DESCRIBE `orchid_image` 0.002471923828125
(229) DESCRIBE `cruiselines` 0.003587007522583
(230) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00045108795166016
(231) DESCRIBE `cruises` 0.0074431896209717
(232) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79614') 0.00052499771118164
(233) DESCRIBE `deckplans` 0.0020987987518311
(234) DESCRIBE `cabins` 0.0020730495452881
(235) DESCRIBE `shipphotos` 0.0055379867553711
(236) DESCRIBE `cruiselines` 0.003032922744751
(237) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00051593780517578
(238) DESCRIBE `orchid_image` 0.002227783203125
(239) DESCRIBE `cruiselines` 0.0027108192443848
(240) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00049591064453125
(241) DESCRIBE `cruises` 0.023825883865356
(242) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45260, 45259, 71399, 71400, 11517, 56860, 56889, 67266, 67378, 67915)) ORDER BY FIND_IN_SET(id, '45260,45259,71399,71400,11517,56860,56889,67266,67378,67915') 0.0046200752258301
(243) DESCRIBE `cruiselines` 0.032308101654053
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '218', '47', '264', '33', '191', '18', '14', '20', '23', '29', '24', '114', '8', '213', '4')) ORDER BY FIND_IN_SET(id, '120,212,218,47,264,33,191,18,14,20,23,29,24,114,8,213,4') 0.0058639049530029
(245) DESCRIBE `ships` 0.016932964324951
(246) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '517', '1767', '1013', '701', '441', '163', '1032', '1205', '401', '1168', '1398', '1788', '66', '390', '451', '461', '683', '1303', '9', '10', '21', '22', '24', '25', '27', '105', '404', '439', '547', '582', '970', '1008', '1320', '1372', '1579', '1749', '1773', '1791', '3', '4', '11', '28', '74', '148', '160', '327', '332', '333', '335', '340', '626', '669', '678', '739', '792', '1073', '1243', '1262', '1302', '1347', '1385', '1539', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,517,1767,1013,701,441,163,1032,1205,401,1168,1398,1788,66,390,451,461,683,1303,9,10,21,22,24,25,27,105,404,439,547,582,970,1008,1320,1372,1579,1749,1773,1791,3,4,11,28,74,148,160,327,332,333,335,340,626,669,678,739,792,1073,1243,1262,1302,1347,1385,1539,1540,1569,1711') 0.009354829788208
(247) DESCRIBE `cruisetypes` 0.0019011497497559
(248) DESCRIBE `destinations` 0.0030200481414795
(249) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '12', '8', '2', '53', '35', '9', '29', '40', '48', '55', '22', '26', '34', '7', '25', '30', '49', '56')) ORDER BY FIND_IN_SET(id, '54,39,43,12,8,2,53,35,9,29,40,48,55,22,26,34,7,25,30,49,56') 0.0021688938140869