or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

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

Total elapsed time: 0.58335661888123

# Query Time
(1) connect 0.0016429424285889
(2) DESCRIBE `cruises` 0.0033459663391113
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57883, 59144, 59240, 59344, 62049, 62161, 65818, 65901, 66309, 69256)) ORDER BY FIND_IN_SET(id, '57883,59144,59240,59344,62049,62161,65818,65901,66309,69256') 0.0017750263214111
(4) DESCRIBE `cruises` 0.0030441284179688
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57883') 8.392333984375E-5
(6) DESCRIBE `ships` 0.0033910274505615
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1382))) 0.00051498413085938
(8) DESCRIBE `ships` 0.0027310848236084
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1382') 0.00031304359436035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(12) DESCRIBE `itineraries` 0.0013179779052734
(13) DESCRIBE `ports` 0.0020449161529541
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00047588348388672
(15) DESCRIBE `ports` 0.0016839504241943
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00043177604675293
(17) DESCRIBE `ports` 0.0013549327850342
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00039410591125488
(19) DESCRIBE `sailingdates` 0.0014941692352295
(20) DESCRIBE `ports` 0.0017020702362061
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.0003960132598877
(22) DESCRIBE `ports` 0.0016999244689941
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00036096572875977
(24) DESCRIBE `ports` 0.0017569065093994
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00044393539428711
(26) DESCRIBE `ports` 0.0017960071563721
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00041103363037109
(28) DESCRIBE `ports` 0.0016591548919678
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00036096572875977
(30) DESCRIBE `ports` 0.0017778873443604
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00046300888061523
(32) DESCRIBE `ports` 0.0018839836120605
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3100))) 0.00038909912109375
(34) DESCRIBE `ports` 0.0017499923706055
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3100') 0.00030398368835449
(36) DESCRIBE `ports` 0.0012919902801514
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0
(38) DESCRIBE `ports` 0.0012581348419189
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00027799606323242
(40) DESCRIBE `ports` 0.00189208984375
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3332))) 0.00014400482177734
(42) DESCRIBE `ports` 0.0012459754943848
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3332') 0.00029897689819336
(44) DESCRIBE `ports` 0.0015931129455566
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00040316581726074
(46) DESCRIBE `ports` 0.0015311241149902
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00031208992004395
(48) DESCRIBE `avid_specials` 0.00124192237854
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57883 and class = 'Cruise') OR (item_id = 1382 AND class = 'Ship') OR (item_id = 256 AND class = 'CruiseLine') OR (item_id = 54 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.0011048316955566
(50) DESCRIBE `cruiselines` 0.0028741359710693
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 256))) 0.00056910514831543
(52) DESCRIBE `orchid_image` 0.0022678375244141
(53) DESCRIBE `cruiselines` 0.0026261806488037
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '256') 0.00037193298339844
(55) DESCRIBE `cruises` 0.0026569366455078
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59144') 0.00035595893859863
(57) DESCRIBE `ships` 0.0026319026947021
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 859))) 0.0004119873046875
(59) DESCRIBE `ships` 0.0026102066040039
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '859') 0.00034689903259277
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030303001403809
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024914741516113
(63) DESCRIBE `itineraries` 0.0013108253479004
(64) DESCRIBE `ports` 0.0014839172363281
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00038790702819824
(66) DESCRIBE `ports` 0.0014090538024902
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00034594535827637
(68) DESCRIBE `ports` 0.0013179779052734
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00028610229492188
(70) DESCRIBE `sailingdates` 0.0011489391326904
(71) DESCRIBE `ports` 0.0014009475708008
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00033020973205566
(73) DESCRIBE `ports` 0.0013191699981689
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00028800964355469
(75) DESCRIBE `ports` 0.0012760162353516
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0.00038909912109375
(77) DESCRIBE `ports` 0.0015501976013184
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00039005279541016
(79) DESCRIBE `ports` 0.0010790824890137
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00031900405883789
(81) DESCRIBE `ports` 0.0015311241149902
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00030088424682617
(83) DESCRIBE `ports` 0.0014100074768066
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0.00032806396484375
(85) DESCRIBE `ports` 0.0012831687927246
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00031399726867676
(87) DESCRIBE `ports` 0.0012450218200684
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029206275939941
(89) DESCRIBE `ports` 0.0012359619140625
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028896331787109
(91) DESCRIBE `ports` 0.0012569427490234
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00028586387634277
(93) DESCRIBE `ports` 0.0013079643249512
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00026607513427734
(95) DESCRIBE `avid_specials` 0.0011360645294189
(96) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59144 and class = 'Cruise') OR (item_id = 859 AND class = 'Ship') OR (item_id = 196 AND class = 'CruiseLine') OR (item_id = 55 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.0010180473327637
(97) DESCRIBE `cruiselines` 0.0019397735595703
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 196))) 0.00034093856811523
(99) DESCRIBE `orchid_image` 0.001431941986084
(100) DESCRIBE `cruiselines` 0.0017681121826172
(101) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '196') 0.00033783912658691
(102) DESCRIBE `cruises` 0.0023717880249023
(103) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59240') 0.00036096572875977
(104) DESCRIBE `ships` 0.0024690628051758
(105) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00035905838012695
(106) DESCRIBE `ships` 0.0025489330291748
(107) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00030016899108887
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026321411132812
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031280517578125
(110) DESCRIBE `itineraries` 0.0013060569763184
(111) DESCRIBE `ports` 0.0013411045074463
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00033903121948242
(113) DESCRIBE `ports` 0.0012431144714355
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00031590461730957
(115) DESCRIBE `ports` 0.0013978481292725
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00032496452331543
(117) DESCRIBE `sailingdates` 0.0011568069458008
(118) DESCRIBE `ports` 0.0013718605041504
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0003199577331543
(120) DESCRIBE `ports` 0.0012459754943848
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00027918815612793
(122) DESCRIBE `ports` 0.0012350082397461
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00030303001403809
(124) DESCRIBE `ports` 0.0014150142669678
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00030684471130371
(126) DESCRIBE `ports` 0.0014240741729736
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00027585029602051
(128) DESCRIBE `ports` 0.0012848377227783
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00027203559875488
(130) DESCRIBE `ports` 0.0013840198516846
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00031805038452148
(132) DESCRIBE `ports` 0.0014481544494629
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00036191940307617
(134) DESCRIBE `avid_specials` 0.0015900135040283
(135) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59240 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 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.0017139911651611
(136) DESCRIBE `cruiselines` 0.002572774887085
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034403800964355
(138) DESCRIBE `orchid_image` 0.0014398097991943
(139) DESCRIBE `cruiselines` 0.0025429725646973
(140) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044608116149902
(141) DESCRIBE `cruises` 0.0034980773925781
(142) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59344') 0.00049209594726562
(143) DESCRIBE `ships` 0.0035688877105713
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1417))) 0.00057291984558105
(145) DESCRIBE `ships` 0.0038371086120605
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1417') 0.00035214424133301
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028109550476074
(149) DESCRIBE `itineraries` 0.001492977142334
(150) DESCRIBE `ports` 0.0013039112091064
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00046682357788086
(152) DESCRIBE `ports` 0.0013279914855957
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00029611587524414
(154) DESCRIBE `ports` 0.0014410018920898
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.0003659725189209
(156) DESCRIBE `sailingdates` 0.0011229515075684
(157) DESCRIBE `ports` 0.0013349056243896
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00032591819763184
(159) DESCRIBE `ports` 0.0013461112976074
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00039291381835938
(161) DESCRIBE `ports` 0.0013301372528076
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1690))) 0.00059103965759277
(163) DESCRIBE `ports` 0.0014650821685791
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1690') 0.00036001205444336
(165) DESCRIBE `ports` 0.0017368793487549
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00042510032653809
(167) DESCRIBE `ports` 0.0014159679412842
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00041604042053223
(169) DESCRIBE `ports` 0.001539945602417
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00043821334838867
(171) DESCRIBE `ports` 0.0016601085662842
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00037884712219238
(173) DESCRIBE `ports` 0.0015637874603271
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00038909912109375
(175) DESCRIBE `ports` 0.0015990734100342
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00033712387084961
(177) DESCRIBE `ports` 0.0015900135040283
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.0003199577331543
(179) DESCRIBE `ports` 0.0015261173248291
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00032591819763184
(181) DESCRIBE `avid_specials` 0.0011889934539795
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59344 and class = 'Cruise') OR (item_id = 1417 AND class = 'Ship') OR (item_id = 170 AND class = 'CruiseLine') OR (item_id = 44 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.0015408992767334
(183) DESCRIBE `cruiselines` 0.0022828578948975
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 170))) 0.00036096572875977
(185) DESCRIBE `orchid_image` 0.0018501281738281
(186) DESCRIBE `cruiselines` 0.0026180744171143
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '170') 0.00042986869812012
(188) DESCRIBE `cruises` 0.0035610198974609
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62049') 0.00058889389038086
(190) DESCRIBE `ships` 0.003324031829834
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1045))) 0.00044584274291992
(192) DESCRIBE `ships` 0.0029370784759521
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1045') 0.00038504600524902
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002739429473877
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025582313537598
(196) DESCRIBE `itineraries` 0.0014359951019287
(197) DESCRIBE `ports` 0.001716136932373
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00053000450134277
(199) DESCRIBE `ports` 0.001727819442749
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00041294097900391
(201) DESCRIBE `ports` 0.0015671253204346
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00041413307189941
(203) DESCRIBE `sailingdates` 0.0015339851379395
(204) DESCRIBE `ports` 0.0018930435180664
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00046706199645996
(206) DESCRIBE `ports` 0.0017669200897217
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00048112869262695
(208) DESCRIBE `ports` 0.0017228126525879
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00043606758117676
(210) DESCRIBE `ports` 0.0018618106842041
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00041389465332031
(212) DESCRIBE `ports` 0.0018928050994873
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00058102607727051
(214) DESCRIBE `ports` 0.0019230842590332
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00043296813964844
(216) DESCRIBE `ports` 0.0016510486602783
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00041103363037109
(218) DESCRIBE `ports` 0.0016038417816162
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00048589706420898
(220) DESCRIBE `ports` 0.0015461444854736
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00036907196044922
(222) DESCRIBE `ports` 0.001662015914917
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00029301643371582
(224) DESCRIBE `avid_specials` 0.0011470317840576
(225) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62049 and class = 'Cruise') OR (item_id = 1045 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0011088848114014
(226) DESCRIBE `cruiselines` 0.0021021366119385
(227) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0004580020904541
(228) DESCRIBE `orchid_image` 0.0014569759368896
(229) DESCRIBE `cruiselines` 0.0018210411071777
(230) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00035691261291504
(231) DESCRIBE `cruises` 0.0030210018157959
(232) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00058913230895996
(233) DESCRIBE `ships` 0.0031120777130127
(234) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00037479400634766
(235) DESCRIBE `ships` 0.002694845199585
(236) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00035691261291504
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026798248291016
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026798248291016
(239) DESCRIBE `itineraries` 0.0013549327850342
(240) DESCRIBE `ports` 0.0013439655303955
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044417381286621
(242) DESCRIBE `ports` 0.0012919902801514
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(244) DESCRIBE `ports` 0.0015270709991455
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037908554077148
(246) DESCRIBE `sailingdates` 0.0011680126190186
(247) DESCRIBE `ports` 0.0018370151519775
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003669261932373
(249) DESCRIBE `ports` 0.0013978481292725
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039887428283691
(251) DESCRIBE `ports` 0.0016520023345947
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00039815902709961
(253) DESCRIBE `ports` 0.0014059543609619
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00036406517028809
(255) DESCRIBE `ports` 0.00164794921875
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(257) DESCRIBE `ports` 0.0013101100921631
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032401084899902
(259) DESCRIBE `avid_specials` 0.0012960433959961
(260) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0016570091247559
(261) DESCRIBE `cruiselines` 0.0022101402282715
(262) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00074911117553711
(263) DESCRIBE `orchid_image` 0.0016767978668213
(264) DESCRIBE `cruiselines` 0.0024070739746094
(265) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00037217140197754
(266) DESCRIBE `cruises` 0.0028209686279297
(267) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65818') 0.00039196014404297
(268) DESCRIBE `ships` 0.0033268928527832
(269) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 837))) 0.00046300888061523
(270) DESCRIBE `ships` 0.0033550262451172
(271) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0.00044608116149902
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(274) DESCRIBE `itineraries` 0.001694917678833
(275) DESCRIBE `ports` 0.0015711784362793
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00041007995605469
(277) DESCRIBE `ports` 0.009260892868042
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0005500316619873
(279) DESCRIBE `ports` 0.0011091232299805
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00046300888061523
(281) DESCRIBE `sailingdates` 0.0015931129455566
(282) DESCRIBE `ports` 0.0016269683837891
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00034904479980469
(284) DESCRIBE `ports` 0.0016269683837891
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00046801567077637
(286) DESCRIBE `ports` 0.011833906173706
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00054097175598145
(288) DESCRIBE `ports` 0.0021481513977051
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00033211708068848
(290) DESCRIBE `ports` 0.0056049823760986
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00040698051452637
(292) DESCRIBE `ports` 0.0016689300537109
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00042986869812012
(294) DESCRIBE `ports` 0.0019030570983887
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00043296813964844
(296) DESCRIBE `ports` 0.0018119812011719
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00036406517028809
(298) DESCRIBE `avid_specials` 0.001619815826416
(299) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65818 and class = 'Cruise') OR (item_id = 837 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 9 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.0016539096832275
(300) DESCRIBE `cruiselines` 0.0025639533996582
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00039100646972656
(302) DESCRIBE `orchid_image` 0.001777172088623
(303) DESCRIBE `cruiselines` 0.0027070045471191
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00041604042053223
(305) DESCRIBE `cruises` 0.0031611919403076
(306) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65901') 0.0004429817199707
(307) DESCRIBE `ships` 0.0032188892364502
(308) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1552))) 0.0005488395690918
(309) DESCRIBE `ships` 0.0033619403839111
(310) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1552') 0.00041580200195312
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00067901611328125
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 6.7949295043945E-5
(313) DESCRIBE `itineraries` 0.0016438961029053
(314) DESCRIBE `ports` 0.0016138553619385
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00043201446533203
(316) DESCRIBE `ports` 0.0014739036560059
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00040006637573242
(318) DESCRIBE `ports` 0.001500129699707
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00037789344787598
(320) DESCRIBE `sailingdates` 0.0012009143829346
(321) DESCRIBE `ports` 0.0018877983093262
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00048708915710449
(323) DESCRIBE `ports` 0.0017349720001221
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00046205520629883
(325) DESCRIBE `ports` 0.0014088153839111
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00032806396484375
(327) DESCRIBE `ports` 0.0013411045074463
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00031805038452148
(329) DESCRIBE `ports` 0.0014500617980957
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3164))) 0.00034594535827637
(331) DESCRIBE `ports` 0.0013360977172852
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3164') 0.00030994415283203
(333) DESCRIBE `ports` 0.0013079643249512
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3164))) 0.00035405158996582
(335) DESCRIBE `ports` 0.0017399787902832
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3164') 0.00035285949707031
(337) DESCRIBE `ports` 0.0018179416656494
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00040602684020996
(339) DESCRIBE `ports` 0.0018939971923828
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00038599967956543
(341) DESCRIBE `ports` 0.0017480850219727
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00037002563476562
(343) DESCRIBE `ports` 0.0013389587402344
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00032401084899902
(345) DESCRIBE `ports` 0.0013270378112793
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 3.504753112793E-5
(347) DESCRIBE `ports` 0.0012810230255127
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00036311149597168
(349) DESCRIBE `ports` 0.0014188289642334
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00038504600524902
(351) DESCRIBE `ports` 0.0012891292572021
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00041890144348145
(353) DESCRIBE `ports` 0.0012469291687012
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00043606758117676
(355) DESCRIBE `ports` 0.0013298988342285
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00043892860412598
(357) DESCRIBE `avid_specials` 0.0015158653259277
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65901 and class = 'Cruise') OR (item_id = 1552 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 54 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.0010020732879639
(359) DESCRIBE `cruiselines` 0.0019760131835938
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00033307075500488
(361) DESCRIBE `orchid_image` 0.0013999938964844
(362) DESCRIBE `cruiselines` 0.002284049987793
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00034999847412109
(364) DESCRIBE `cruises` 0.0028941631317139
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66309') 0.00039005279541016
(366) DESCRIBE `ships` 0.0027220249176025
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1270))) 0.00041604042053223
(368) DESCRIBE `ships` 0.002979040145874
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1270') 0.00035905838012695
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028610229492188
(372) DESCRIBE `itineraries` 0.0013151168823242
(373) DESCRIBE `ports` 0.0012860298156738
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00031805038452148
(375) DESCRIBE `ports` 0.0012669563293457
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00032281875610352
(377) DESCRIBE `ports` 0.0012898445129395
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0002751350402832
(379) DESCRIBE `sailingdates` 0.0011241436004639
(380) DESCRIBE `ports` 0.0013508796691895
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00031900405883789
(382) DESCRIBE `ports` 0.001366138458252
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00029301643371582
(384) DESCRIBE `ports` 0.0013790130615234
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00034713745117188
(386) DESCRIBE `ports` 0.0015060901641846
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00034594535827637
(388) DESCRIBE `ports` 0.0013749599456787
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00039100646972656
(390) DESCRIBE `ports` 0.0013689994812012
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00031018257141113
(392) DESCRIBE `ports` 0.001737117767334
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00044083595275879
(394) DESCRIBE `ports` 0.0018670558929443
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00010991096496582
(396) DESCRIBE `ports` 0.0016028881072998
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00037789344787598
(398) DESCRIBE `ports` 0.0013890266418457
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00031018257141113
(400) DESCRIBE `avid_specials` 0.0012118816375732
(401) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66309 and class = 'Cruise') OR (item_id = 1270 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine') OR (item_id = 50 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.0010390281677246
(402) DESCRIBE `cruiselines` 0.0020468235015869
(403) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00043106079101562
(404) DESCRIBE `orchid_image` 0.0019900798797607
(405) DESCRIBE `cruiselines` 0.0018839836120605
(406) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00046515464782715
(407) DESCRIBE `cruises` 0.0029938220977783
(408) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69256') 0.00055599212646484
(409) DESCRIBE `ships` 0.0029890537261963
(410) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00097203254699707
(411) DESCRIBE `ships` 0.0027918815612793
(412) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00036096572875977
(413) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036287307739258
(415) DESCRIBE `itineraries` 0.001777172088623
(416) DESCRIBE `ports` 0.0014429092407227
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00038290023803711
(418) DESCRIBE `ports` 0.0013840198516846
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00039100646972656
(420) DESCRIBE `ports` 0.001863956451416
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00036501884460449
(422) DESCRIBE `sailingdates` 0.0011589527130127
(423) DESCRIBE `ports` 0.0015110969543457
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00041508674621582
(425) DESCRIBE `ports` 0.0014400482177734
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00032687187194824
(427) DESCRIBE `ports` 0.001345157623291
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00034904479980469
(429) DESCRIBE `ports` 0.0015151500701904
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00032401084899902
(431) DESCRIBE `ports` 0.0014970302581787
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00040507316589355
(433) DESCRIBE `ports` 0.0017178058624268
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00038290023803711
(435) DESCRIBE `ports` 0.0014679431915283
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0003669261932373
(437) DESCRIBE `ports` 0.0015599727630615
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0003659725189209
(439) DESCRIBE `avid_specials` 0.0014171600341797
(440) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69256 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0016138553619385
(441) DESCRIBE `cruiselines` 0.0023910999298096
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0004270076751709
(443) DESCRIBE `orchid_image` 0.0017609596252441
(444) DESCRIBE `cruiselines` 0.002079963684082
(445) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003509521484375
(446) DESCRIBE `cruiselines` 0.0026290416717529
(447) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '19', '26', '77', '23', '7', '12', '20', '18', '171', '8', '144', '101', '31', '103', '50', '131', '96', '29', '239', '15', '258', '191', '33', '91', '206', '37', '120', '16', '114', '24', '262', '268', '28', '14', '174', '110', '208', '156', '221', '187', '141', '153', '118', '49', '151', '211', '30', '216', '181', '88', '4', '212', '36', '264', '225', '238', '140', '159', '184', '249', '90', '230', '113', '213', '182', '276', '136', '261', '47', '57', '64', '237', '188', '232', '180', '35', '248', '73', '95', '209', '231', '52', '116', '146', '219', '82', '119', '59', '134', '105', '195', '244', '115', '168', '196', '170', '240', '256', '229', '204')) ORDER BY FIND_IN_SET(id, '183,218,19,26,77,23,7,12,20,18,171,8,144,101,31,103,50,131,96,29,239,15,258,191,33,91,206,37,120,16,114,24,262,268,28,14,174,110,208,156,221,187,141,153,118,49,151,211,30,216,181,88,4,212,36,264,225,238,140,159,184,249,90,230,113,213,182,276,136,261,47,57,64,237,188,232,180,35,248,73,95,209,231,52,116,146,219,82,119,59,134,105,195,244,115,168,196,170,240,256,229,204') 0.0064430236816406
(448) DESCRIBE `ships` 0.0036079883575439
(449) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '977', '258', '1291', '1199', '1599', '1359', '349', '454', '439', '1135', '1272', '404', '780', '855', '1677', '986', '1067', '265', '1237', '1594', '1607', '837', '34', '37', '38', '770', '1588', '22', '27', '817', '21', '31', '378', '461', '28', '407', '393', '1376', '542', '39', '1012', '30', '36', '1245', '573', '970', '1402', '1552', '726', '585', '35', '66', '1424', '1744', '330', '332', '1768', '792', '1284', '1413', '1411', '1415', '1422', '113', '882', '1420', '462', '1176', '1419', '1423', '1410', '1418', '1421', '1587', '24', '711', '11', '1405', '1574', '9', '434', '455', '1773', '10', '580', '1760', '722', '1215', '160', '162', '1021', '1193', '766', '1141', '452', '658', '739', '78', '81', '1682', '69', '1454', '1572', '674', '1008', '1372', '3', '163', '1095', '678', '338', '852', '1168', '1412', '1319', '1373', '1408', '43', '124', '335', '1678', '253', '635', '850', '1302', '1172', '116', '1569', '70', '285', '340', '1159', '1236', '111', '553', '348', '451', '1259', '4', '944', '966', '968', '25', '390', '1108', '1260', '148', '386', '626', '748', '1266', '385', '616', '651', '683', '716', '1330', '314', '389', '768', '791', '1320', '63', '405', '784', '1088', '1323', '1455', '1562', '508', '874', '1195', '1325', '286', '406', '590', '749', '1632', '1645', '287', '375', '559', '582', '1068', '1672', '84', '108', '291', '327', '483', '526', '1575', '119', '467', '1208', '98', '394', '401', '1742', '854', '1398', '207', '290', '657', '45', '421', '485', '1492', '1571', '1064', '1586', '147', '150', '151', '652', '776', '114', '152', '704', '1308', '123', '149', '341', '403', '520', '639', '1268', '1460', '223', '547', '775', '883', '954', '1269', '1289', '1539', '1321', '1711', '325', '1389', '1724', '262', '1139', '1486', '1601', '1722', '105', '715', '958', '1557', '1717', '351', '790', '1471', '75', '324', '545', '717', '1243', '1270', '1282', '1738', '1143', '1303', '1326', '1327', '1437', '441', '1526', '1771', '516', '517', '885', '993', '1040', '1075', '1214', '1579', '1704', '93', '205', '574', '796', '823', '1013', '1151', '1561', '333', '665', '673', '701', '818', '1063', '1301', '1367', '82', '988', '1218', '1318', '1540', '212', '743', '1247', '1262', '1676', '1740', '1043', '1566', '1602', '1766', '751', '769', '1137', '1216', '1344', '201', '266', '884', '1144', '1157', '1217', '1343', '1409', '1721', '795', '1073', '1160', '1223', '1226', '1283', '1348', '1604', '14', '448', '1027', '1029', '1229', '1253', '1426', '1452', '1453', '1716', '601', '669', '738', '1025', '1090', '1136', '1163', '732', '811', '905', '1241', '1449', '1496', '1619', '610', '1019', '1055', '1152', '1358', '1448', '1673', '1713', '1715', '74', '417', '996', '997', '1026', '1145', '1188', '1233', '1458', '1714', '643', '1150', '1351', '1663', '1743', '494', '836', '888', '973', '1034', '1149', '1231', '1345', '1366', '1404', '1474', '1516', '1609', '1772', '618', '851', '1047', '1049', '1196', '1222', '1322', '1360', '1361', '1362', '1368', '1459', '1522', '1647', '1730', '423', '453', '666', '709', '920', '921', '927', '931', '1004', '1230', '1354', '1470', '1508', '1627', '1729', '208', '914', '923', '1017', '1037', '1042', '1407', '1517', '1518', '1567', '1580', '1606', '352', '663', '915', '916', '926', '930', '1003', '1072', '1138', '1140', '1187', '1489', '1505', '1593', '1649', '1674', '1708', '1751', '499', '695', '703', '924', '972', '1001', '1020', '1154', '1352', '1444', '1514', '1521', '1596', '1723', '422', '479', '493', '671', '938', '1005', '1054', '1175', '1515', '1767', '781', '937', '1051', '1650', '1679', '1681', '1684', '672', '1052', '1091', '1092', '1254', '1445')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,977,258,1291,1199,1599,1359,349,454,439,1135,1272,404,780,855,1677,986,1067,265,1237,1594,1607,837,34,37,38,770,1588,22,27,817,21,31,378,461,28,407,393,1376,542,39,1012,30,36,1245,573,970,1402,1552,726,585,35,66,1424,1744,330,332,1768,792,1284,1413,1411,1415,1422,113,882,1420,462,1176,1419,1423,1410,1418,1421,1587,24,711,11,1405,1574,9,434,455,1773,10,580,1760,722,1215,160,162,1021,1193,766,1141,452,658,739,78,81,1682,69,1454,1572,674,1008,1372,3,163,1095,678,338,852,1168,1412,1319,1373,1408,43,124,335,1678,253,635,850,1302,1172,116,1569,70,285,340,1159,1236,111,553,348,451,1259,4,944,966,968,25,390,1108,1260,148,386,626,748,1266,385,616,651,683,716,1330,314,389,768,791,1320,63,405,784,1088,1323,1455,1562,508,874,1195,1325,286,406,590,749,1632,1645,287,375,559,582,1068,1672,84,108,291,327,483,526,1575,119,467,1208,98,394,401,1742,854,1398,207,290,657,45,421,485,1492,1571,1064,1586,147,150,151,652,776,114,152,704,1308,123,149,341,403,520,639,1268,1460,223,547,775,883,954,1269,1289,1539,1321,1711,325,1389,1724,262,1139,1486,1601,1722,105,715,958,1557,1717,351,790,1471,75,324,545,717,1243,1270,1282,1738,1143,1303,1326,1327,1437,441,1526,1771,516,517,885,993,1040,1075,1214,1579,1704,93,205,574,796,823,1013,1151,1561,333,665,673,701,818,1063,1301,1367,82,988,1218,1318,1540,212,743,1247,1262,1676,1740,1043,1566,1602,1766,751,769,1137,1216,1344,201,266,884,1144,1157,1217,1343,1409,1721,795,1073,1160,1223,1226,1283,1348,1604,14,448,1027,1029,1229,1253,1426,1452,1453,1716,601,669,738,1025,1090,1136,1163,732,811,905,1241,1449,1496,1619,610,1019,1055,1152,1358,1448,1673,1713,1715,74,417,996,997,1026,1145,1188,1233,1458,1714,643,1150,1351,1663,1743,494,836,888,973,1034,1149,1231,1345,1366,1404,1474,1516,1609,1772,618,851,1047,1049,1196,1222,1322,1360,1361,1362,1368,1459,1522,1647,1730,423,453,666,709,920,921,927,931,1004,1230,1354,1470,1508,1627,1729,208,914,923,1017,1037,1042,1407,1517,1518,1567,1580,1606,352,663,915,916,926,930,1003,1072,1138,1140,1187,1489,1505,1593,1649,1674,1708,1751,499,695,703,924,972,1001,1020,1154,1352,1444,1514,1521,1596,1723,422,479,493,671,938,1005,1054,1175,1515,1767,781,937,1051,1650,1679,1681,1684,672,1052,1091,1092,1254,1445') 0.044405937194824
(450) DESCRIBE `cruisetypes` 0.0017609596252441
(451) DESCRIBE `destinations` 0.0028510093688965
(452) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '2', '43', '8', '39', '53', '28', '26', '38', '55', '40', '7', '48', '30', '21', '11', '49', '45', '29', '44', '56', '34', '10', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,2,43,8,39,53,28,26,38,55,40,7,48,30,21,11,49,45,29,44,56,34,10,52,32,46') 0.0024421215057373