or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 0.28362226486206

# Query Time
(1) connect 0.00074100494384766
(2) DESCRIBE `specials` 0.0055351257324219
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '106-night-world-cruise-aboard-sea-princess') AND (orchid_available = 1) LIMIT 1 0.00091290473937988
(4) DESCRIBE `cruises` 0.0026240348815918
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79614))) 0.00051307678222656
(6) DESCRIBE `avid_specials` 0.0012140274047852
(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.0011389255523682
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1487512') 0.00029110908508301
(9) DESCRIBE `ships` 0.0030930042266846
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00037503242492676
(11) DESCRIBE `ships` 0.0027217864990234
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00034093856811523
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031280517578125
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(15) DESCRIBE `itineraries` 0.0014729499816895
(16) DESCRIBE `ports` 0.0017480850219727
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043487548828125
(18) DESCRIBE `ports` 0.0022399425506592
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00039505958557129
(20) DESCRIBE `ports` 0.0017549991607666
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040197372436523
(22) DESCRIBE `specialsailingdates` 0.0015068054199219
(23) DESCRIBE `sailingdates` 0.0016119480133057
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493173))) 0.00055480003356934
(25) DESCRIBE `ports` 0.0017759799957275
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042200088500977
(27) DESCRIBE `ports` 0.0017039775848389
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028800964355469
(29) DESCRIBE `ports` 0.001352071762085
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00031900405883789
(31) DESCRIBE `ports` 0.0015418529510498
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00033903121948242
(33) DESCRIBE `ports` 0.0013389587402344
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030708312988281
(35) DESCRIBE `ports` 0.0018332004547119
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039386749267578
(37) DESCRIBE `ports` 0.0016319751739502
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036787986755371
(39) DESCRIBE `ports` 0.0014760494232178
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00031399726867676
(41) DESCRIBE `ports` 0.0015528202056885
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00033116340637207
(43) DESCRIBE `ports` 0.0013530254364014
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00029397010803223
(45) DESCRIBE `ports` 0.0016610622406006
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00038504600524902
(47) DESCRIBE `ports` 0.0016310214996338
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00029301643371582
(49) DESCRIBE `ports` 0.0014100074768066
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00036811828613281
(51) DESCRIBE `ports` 0.0016868114471436
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00029778480529785
(53) DESCRIBE `ports` 0.0014770030975342
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00031208992004395
(55) DESCRIBE `ports` 0.0015978813171387
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00043201446533203
(57) DESCRIBE `ports` 0.0017850399017334
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00041794776916504
(59) DESCRIBE `ports` 0.0017838478088379
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00033402442932129
(61) DESCRIBE `ports` 0.0013148784637451
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00043010711669922
(63) DESCRIBE `ports` 0.0016660690307617
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0003199577331543
(65) DESCRIBE `ports` 0.0014750957489014
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00038290023803711
(67) DESCRIBE `ports` 0.0013959407806396
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00031304359436035
(69) DESCRIBE `ports` 0.0014019012451172
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00030994415283203
(71) DESCRIBE `ports` 0.001406192779541
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00030088424682617
(73) DESCRIBE `ports` 0.0014760494232178
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00042009353637695
(75) DESCRIBE `ports` 0.0013120174407959
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00028204917907715
(77) DESCRIBE `ports` 0.0013999938964844
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00031900405883789
(79) DESCRIBE `ports` 0.0019741058349609
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00044703483581543
(81) DESCRIBE `ports` 0.0017130374908447
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00059819221496582
(83) DESCRIBE `ports` 0.0018339157104492
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00043201446533203
(85) DESCRIBE `ports` 0.0017638206481934
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003349781036377
(87) DESCRIBE `ports` 0.0015430450439453
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032305717468262
(89) DESCRIBE `ports` 0.0013089179992676
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003960132598877
(91) DESCRIBE `ports` 0.0014379024505615
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00030684471130371
(93) DESCRIBE `ports` 0.001370906829834
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0003049373626709
(95) DESCRIBE `ports` 0.0013060569763184
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028800964355469
(97) DESCRIBE `ports` 0.0013167858123779
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034999847412109
(99) DESCRIBE `ports` 0.0014209747314453
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003201961517334
(101) DESCRIBE `ports` 0.0016491413116455
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00035405158996582
(103) DESCRIBE `ports` 0.0015981197357178
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00029110908508301
(105) DESCRIBE `ports` 0.0016660690307617
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036501884460449
(107) DESCRIBE `ports` 0.0013020038604736
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028705596923828
(109) DESCRIBE `ports` 0.00146484375
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 274))) 0.00033807754516602
(111) DESCRIBE `ports` 0.0014419555664062
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '274') 0.00027799606323242
(113) DESCRIBE `ports` 0.0013551712036133
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00037097930908203
(115) DESCRIBE `ports` 0.0018079280853271
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00038385391235352
(117) DESCRIBE `ports` 0.0017249584197998
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00043892860412598
(119) DESCRIBE `ports` 0.0018830299377441
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00040197372436523
(121) DESCRIBE `ports` 0.0018730163574219
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.0003819465637207
(123) DESCRIBE `ports` 0.001521110534668
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00030994415283203
(125) DESCRIBE `ports` 0.0014669895172119
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00033903121948242
(127) DESCRIBE `ports` 0.0014140605926514
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00028705596923828
(129) DESCRIBE `ports` 0.001309871673584
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.00034499168395996
(131) DESCRIBE `ports` 0.0015649795532227
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00030899047851562
(133) DESCRIBE `ports` 0.0015139579772949
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00031089782714844
(135) DESCRIBE `ports` 0.0013289451599121
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00033688545227051
(137) DESCRIBE `ports` 0.0015590190887451
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.0003509521484375
(139) DESCRIBE `ports` 0.0014340877532959
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00034713745117188
(141) DESCRIBE `ports` 0.0018520355224609
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 800))) 0.00040411949157715
(143) DESCRIBE `ports` 0.0016839504241943
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '800') 0.00032997131347656
(145) DESCRIBE `ports` 0.0013821125030518
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00037312507629395
(147) DESCRIBE `ports` 0.0015168190002441
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.0003211498260498
(149) DESCRIBE `ports` 0.0014350414276123
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00032997131347656
(151) DESCRIBE `ports` 0.0013220310211182
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00030899047851562
(153) DESCRIBE `ports` 0.00205397605896
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00047588348388672
(155) DESCRIBE `ports` 0.0014700889587402
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00038409233093262
(157) DESCRIBE `ports` 0.0014469623565674
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00034117698669434
(159) DESCRIBE `ports` 0.0013840198516846
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00029611587524414
(161) DESCRIBE `ports` 0.0018229484558105
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00056004524230957
(163) DESCRIBE `ports` 0.0019469261169434
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00042104721069336
(165) DESCRIBE `ports` 0.0018420219421387
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00040411949157715
(167) DESCRIBE `ports` 0.0014841556549072
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00033116340637207
(169) DESCRIBE `ports` 0.0015349388122559
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037789344787598
(171) DESCRIBE `ports` 0.0021138191223145
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0005800724029541
(173) DESCRIBE `ports` 0.002277135848999
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00050711631774902
(175) DESCRIBE `ports` 0.0018551349639893
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00044894218444824
(177) DESCRIBE `ports` 0.0018479824066162
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00055313110351562
(179) DESCRIBE `ports` 0.0019631385803223
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00051093101501465
(181) DESCRIBE `ports` 0.0018858909606934
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00047397613525391
(183) DESCRIBE `ports` 0.0019629001617432
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00041484832763672
(185) DESCRIBE `ports` 0.0018401145935059
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00042605400085449
(187) DESCRIBE `ports` 0.0018630027770996
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00041103363037109
(189) DESCRIBE `ports` 0.001777172088623
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00044107437133789
(191) DESCRIBE `ports` 0.0015499591827393
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00037693977355957
(193) DESCRIBE `ports` 0.001755952835083
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 880))) 0.00045895576477051
(195) DESCRIBE `ports` 0.0015609264373779
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '880') 0.00038790702819824
(197) DESCRIBE `ports` 0.0015981197357178
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) 0.0003972053527832
(199) DESCRIBE `ports` 0.0014369487762451
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') 0.00031805038452148
(201) DESCRIBE `ports` 0.0014970302581787
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1332))) 0.00038695335388184
(203) DESCRIBE `ports` 0.0015959739685059
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1332') 0.00041389465332031
(205) DESCRIBE `ports` 0.0015738010406494
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00035285949707031
(207) DESCRIBE `ports` 0.0017409324645996
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00038719177246094
(209) DESCRIBE `ports` 0.0018718242645264
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00040793418884277
(211) DESCRIBE `ports` 0.0018858909606934
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00038695335388184
(213) DESCRIBE `ports` 0.0015721321105957
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00041294097900391
(215) DESCRIBE `ports` 0.0017030239105225
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00049591064453125
(217) DESCRIBE `ports` 0.0018448829650879
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00068902969360352
(219) DESCRIBE `ports` 0.0016019344329834
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034499168395996
(221) DESCRIBE `specialsmultipricing` 0.0014550685882568
(222) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1487512' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.00045204162597656
(223) DESCRIBE `leadpricing` 0.0014569759368896
(224) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1487512') LIMIT 1 0.00034904479980469
(225) DESCRIBE `specials` 0.0046401023864746
(226) SELECT `specials`.* FROM `specials` WHERE (id= '1487512') AND (specials.orchid_available = 1) LIMIT 1 0.00060296058654785
(227) DESCRIBE `currencies` 0.0013089179992676
(228) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00030303001403809
(229) DESCRIBE `cruiselines` 0.0026600360870361
(230) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00049877166748047
(231) DESCRIBE `orchid_image` 0.0017590522766113
(232) DESCRIBE `cruiselines` 0.0021560192108154
(233) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00035691261291504
(234) DESCRIBE `cruises` 0.0029451847076416
(235) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79614') 0.00039792060852051
(236) DESCRIBE `deckplans` 0.001406192779541
(237) DESCRIBE `cabins` 0.0014948844909668
(238) DESCRIBE `shipphotos` 0.0020859241485596
(239) DESCRIBE `cruiselines` 0.0028040409088135
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00055313110351562
(241) DESCRIBE `orchid_image` 0.0019619464874268
(242) DESCRIBE `cruiselines` 0.0025351047515869
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00042986869812012
(244) DESCRIBE `cruises` 0.0036840438842773
(245) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75092, 71061, 56368, 75087, 63940, 71423, 63941, 43678, 67915, 75085)) ORDER BY FIND_IN_SET(id, '75092,71061,56368,75087,63940,71423,63941,43678,67915,75085') 0.0015289783477783
(246) DESCRIBE `cruiselines` 0.0022439956665039
(247) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '33', '218', '114', '23', '18', '191', '264', '20', '140', '24', '19', '29', '4', '91', '151')) ORDER BY FIND_IN_SET(id, '212,33,218,114,23,18,191,264,20,140,24,19,29,4,91,151') 0.0012669563293457
(248) DESCRIBE `ships` 0.0027279853820801
(249) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '160', '1282', '163', '1159', '1266', '1767', '1772', '1788', '1032', '338', '451', '547', '1262', '75', '162', '404', '580', '1073', '1205', '1491', '1539', '4', '74', '105', '147', '452', '622', '626', '652', '669', '678', '717', '741', '835', '1108', '1168', '1193', '1415', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,160,1282,163,1159,1266,1767,1772,1788,1032,338,451,547,1262,75,162,404,580,1073,1205,1491,1539,4,74,105,147,452,622,626,652,669,678,717,741,835,1108,1168,1193,1415,1540,1569,1711') 0.0039870738983154
(250) DESCRIBE `cruisetypes` 0.002007007598877
(251) DESCRIBE `destinations` 0.0025398731231689
(252) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '49', '2', '28', '40', '50', '8', '35', '53', '55', '34', '11', '29', '38', '54', '25', '26', '37', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,49,2,28,40,50,8,35,53,55,34,11,29,38,54,25,26,37,45,52') 0.0022239685058594