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

Total elapsed time: 0.5692241191864

# Query Time
(1) connect 0.00079107284545898
(2) DESCRIBE `cruises` 0.0034589767456055
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (78975, 34184, 34156, 56631, 49599, 56474, 57661, 58526, 59149, 65902)) ORDER BY FIND_IN_SET(id, '78975,34184,34156,56631,49599,56474,57661,58526,59149,65902') 0.0012938976287842
(4) DESCRIBE `cruises` 0.0028769969940186
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78975') 0.00039005279541016
(6) DESCRIBE `ships` 0.0026021003723145
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 454))) 0.00037193298339844
(8) DESCRIBE `ships` 0.0027048587799072
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '454') 0.00033783912658691
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(12) DESCRIBE `itineraries` 0.0014281272888184
(13) DESCRIBE `ports` 0.0014059543609619
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00035405158996582
(15) DESCRIBE `ports` 0.0012588500976562
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00030088424682617
(17) DESCRIBE `ports` 0.0013840198516846
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00026988983154297
(19) DESCRIBE `sailingdates` 0.0012760162353516
(20) DESCRIBE `ports` 0.001366138458252
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0001220703125
(22) DESCRIBE `ports` 0.001305103302002
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00027704238891602
(24) DESCRIBE `ports` 0.0015180110931396
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.0003199577331543
(26) DESCRIBE `ports` 0.0012919902801514
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00029587745666504
(28) DESCRIBE `ports` 0.0012500286102295
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 314))) 0.0002899169921875
(30) DESCRIBE `ports` 0.001331090927124
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '314') 0.0002739429473877
(32) DESCRIBE `ports` 0.0013720989227295
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00031208992004395
(34) DESCRIBE `ports` 0.0012609958648682
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.00027108192443848
(36) DESCRIBE `ports` 0.0010828971862793
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00032210350036621
(38) DESCRIBE `ports` 0.0012822151184082
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00037002563476562
(40) DESCRIBE `ports` 0.00130295753479
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00028800964355469
(42) DESCRIBE `ports` 0.0012340545654297
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00012397766113281
(44) DESCRIBE `ports` 0.0013070106506348
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00028800964355469
(46) DESCRIBE `ports` 0.0015029907226562
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00026798248291016
(48) DESCRIBE `avid_specials` 0.0011651515960693
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78975 and class = 'Cruise') OR (item_id = 454 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 12 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.0010700225830078
(50) DESCRIBE `cruiselines` 0.0018231868743896
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00031900405883789
(52) DESCRIBE `orchid_image` 0.0016078948974609
(53) DESCRIBE `cruiselines` 0.001917839050293
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00040793418884277
(55) DESCRIBE `cruises` 0.0028259754180908
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34184') 0.00035905838012695
(57) DESCRIBE `ships` 0.0027399063110352
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 37))) 0.00038504600524902
(59) DESCRIBE `ships` 0.0028250217437744
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '37') 0.00037598609924316
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032401084899902
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 7.0095062255859E-5
(63) DESCRIBE `itineraries` 0.001741886138916
(64) DESCRIBE `ports` 0.0016779899597168
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00041079521179199
(66) DESCRIBE `ports` 0.0014059543609619
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00030398368835449
(68) DESCRIBE `ports` 0.0013279914855957
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0
(70) DESCRIBE `sailingdates` 0.0010659694671631
(71) DESCRIBE `ports` 0.0016701221466064
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00034117698669434
(73) DESCRIBE `ports` 0.0020270347595215
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0
(75) DESCRIBE `ports` 0.0013060569763184
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00029802322387695
(77) DESCRIBE `ports` 0.0017111301422119
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0
(79) DESCRIBE `ports` 0.001276969909668
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0003209114074707
(81) DESCRIBE `ports` 0.0015430450439453
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00035595893859863
(83) DESCRIBE `ports` 0.0015339851379395
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00099682807922363
(85) DESCRIBE `ports` 0.0011601448059082
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0002739429473877
(87) DESCRIBE `ports` 0.0012471675872803
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00029397010803223
(89) DESCRIBE `ports` 0.0012369155883789
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.0011680126190186
(91) DESCRIBE `ports` 0.0004279613494873
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00042104721069336
(93) DESCRIBE `ports` 0.0012710094451904
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0
(95) DESCRIBE `ports` 0.00098896026611328
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00029706954956055
(97) DESCRIBE `ports` 0.0019180774688721
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00010108947753906
(99) DESCRIBE `ports` 0.0016028881072998
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0
(101) DESCRIBE `ports` 0.0011930465698242
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00027203559875488
(103) DESCRIBE `ports` 0.0016779899597168
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00030088424682617
(105) DESCRIBE `ports` 0.00062894821166992
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00032711029052734
(107) DESCRIBE `ports` 0.0012750625610352
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00075411796569824
(109) DESCRIBE `ports` 0.0010988712310791
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00027108192443848
(111) DESCRIBE `ports` 0.0012831687927246
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0
(113) DESCRIBE `ports` 0.0013120174407959
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00034904479980469
(115) DESCRIBE `avid_specials` 0.0013940334320068
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34184 and class = 'Cruise') OR (item_id = 37 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.0010128021240234
(117) DESCRIBE `cruiselines` 0.0018389225006104
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0
(119) DESCRIBE `orchid_image` 0.0015490055084229
(120) DESCRIBE `cruiselines` 0.001856803894043
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00030303001403809
(122) DESCRIBE `cruises` 0.0026009082794189
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34156') 0.00035810470581055
(124) DESCRIBE `ships` 0.0027468204498291
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 30))) 0.00050997734069824
(126) DESCRIBE `ships` 0.0030739307403564
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '30') 0.00046801567077637
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028896331787109
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027298927307129
(130) DESCRIBE `itineraries` 0.0005030632019043
(131) DESCRIBE `ports` 0.0014998912811279
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00032591819763184
(133) DESCRIBE `ports` 0.0021431446075439
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0
(135) DESCRIBE `ports` 0.0014040470123291
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.0004420280456543
(137) DESCRIBE `sailingdates` 0.0012791156768799
(138) DESCRIBE `ports` 0.0018181800842285
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00040698051452637
(140) DESCRIBE `ports` 0.0013139247894287
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 9.0599060058594E-6
(142) DESCRIBE `ports` 0.0027749538421631
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00042009353637695
(144) DESCRIBE `ports` 0.0017168521881104
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00043487548828125
(146) DESCRIBE `ports` 0.0020380020141602
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00045895576477051
(148) DESCRIBE `ports` 0.0019710063934326
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00044703483581543
(150) DESCRIBE `ports` 0.0018749237060547
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00044107437133789
(152) DESCRIBE `ports` 0.0018651485443115
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00045108795166016
(154) DESCRIBE `ports` 0.0018019676208496
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00042295455932617
(156) DESCRIBE `ports` 0.001943826675415
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.0006258487701416
(158) DESCRIBE `ports` 0.0020310878753662
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.0004429817199707
(160) DESCRIBE `ports` 0.0019450187683105
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00038719177246094
(162) DESCRIBE `ports` 0.0018248558044434
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00040984153747559
(164) DESCRIBE `ports` 0.0017590522766113
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00035381317138672
(166) DESCRIBE `ports` 0.0016729831695557
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00042104721069336
(168) DESCRIBE `ports` 0.0019590854644775
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00039100646972656
(170) DESCRIBE `ports` 0.0018839836120605
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00044798851013184
(172) DESCRIBE `ports` 0.0018758773803711
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00051999092102051
(174) DESCRIBE `ports` 0.0019018650054932
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00047612190246582
(176) DESCRIBE `ports` 0.0020229816436768
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00047397613525391
(178) DESCRIBE `ports` 0.0019149780273438
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004420280456543
(180) DESCRIBE `ports` 0.0019221305847168
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00046992301940918
(182) DESCRIBE `avid_specials` 0.0015878677368164
(183) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34156 and class = 'Cruise') OR (item_id = 30 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.0020511150360107
(184) DESCRIBE `cruiselines` 0.0026199817657471
(185) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00057601928710938
(186) DESCRIBE `orchid_image` 0.0020909309387207
(187) DESCRIBE `cruiselines` 0.0027248859405518
(188) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00034713745117188
(189) DESCRIBE `cruises` 0.0034818649291992
(190) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56631') 0.0005800724029541
(191) DESCRIBE `ships` 0.0036611557006836
(192) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 9))) 0.00058102607727051
(193) DESCRIBE `ships` 0.0036721229553223
(194) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '9') 0.0004880428314209
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003058910369873
(197) DESCRIBE `itineraries` 0.0021607875823975
(198) DESCRIBE `ports` 0.0018839836120605
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00044417381286621
(200) DESCRIBE `ports` 0.0018291473388672
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00038695335388184
(202) DESCRIBE `ports` 0.0017569065093994
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00037121772766113
(204) DESCRIBE `sailingdates` 0.0015089511871338
(205) DESCRIBE `ports` 0.0019009113311768
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00042104721069336
(207) DESCRIBE `ports` 0.0017600059509277
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.0004429817199707
(209) DESCRIBE `ports` 0.0017218589782715
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.0004119873046875
(211) DESCRIBE `ports` 0.001784086227417
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00039291381835938
(213) DESCRIBE `ports` 0.0018270015716553
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00041890144348145
(215) DESCRIBE `ports` 0.0017940998077393
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00035810470581055
(217) DESCRIBE `ports` 0.0016238689422607
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00033307075500488
(219) DESCRIBE `ports` 0.001662015914917
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00038814544677734
(221) DESCRIBE `avid_specials` 0.001507043838501
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56631 and class = 'Cruise') OR (item_id = 9 AND class = 'Ship') OR (item_id = 218 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.0017871856689453
(223) DESCRIBE `cruiselines` 0.0025010108947754
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0004580020904541
(225) DESCRIBE `orchid_image` 0.0018751621246338
(226) DESCRIBE `cruiselines` 0.002424955368042
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00040102005004883
(228) DESCRIBE `cruises` 0.0032038688659668
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49599') 0.00045609474182129
(230) DESCRIBE `ships` 0.0027740001678467
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 285))) 0.0004580020904541
(232) DESCRIBE `ships` 0.0030319690704346
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '285') 0.00040006637573242
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(236) DESCRIBE `itineraries` 0.0017108917236328
(237) DESCRIBE `ports` 0.0015199184417725
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00033807754516602
(239) DESCRIBE `ports` 0.001460075378418
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00030016899108887
(241) DESCRIBE `ports` 0.0016238689422607
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00030899047851562
(243) DESCRIBE `sailingdates` 0.0015640258789062
(244) DESCRIBE `ports` 0.0016748905181885
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00037097930908203
(246) DESCRIBE `ports` 0.0013399124145508
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00028610229492188
(248) DESCRIBE `ports` 0.0014309883117676
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00033092498779297
(250) DESCRIBE `ports` 0.0013408660888672
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028204917907715
(252) DESCRIBE `ports` 0.0013000965118408
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00030684471130371
(254) DESCRIBE `ports` 0.0012638568878174
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00027894973754883
(256) DESCRIBE `avid_specials` 0.0011990070343018
(257) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49599 and class = 'Cruise') OR (item_id = 285 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 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.0015778541564941
(258) DESCRIBE `cruiselines` 0.0022621154785156
(259) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042605400085449
(260) DESCRIBE `orchid_image` 0.0018270015716553
(261) DESCRIBE `cruiselines` 0.0020768642425537
(262) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00031709671020508
(263) DESCRIBE `cruises` 0.0028879642486572
(264) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56474') 0.00033712387084961
(265) DESCRIBE `ships` 0.0026798248291016
(266) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 439))) 0.00046300888061523
(267) DESCRIBE `ships` 0.0027198791503906
(268) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '439') 0.00032901763916016
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030779838562012
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(271) DESCRIBE `itineraries` 0.001417875289917
(272) DESCRIBE `ports` 0.0014181137084961
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00034809112548828
(274) DESCRIBE `ports` 0.0012960433959961
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00031018257141113
(276) DESCRIBE `ports` 0.0013828277587891
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00030088424682617
(278) DESCRIBE `sailingdates` 0.0012669563293457
(279) DESCRIBE `ports` 0.0018079280853271
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00038385391235352
(281) DESCRIBE `ports` 0.0013430118560791
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00052118301391602
(283) DESCRIBE `ports` 0.0013620853424072
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0004279613494873
(285) DESCRIBE `ports` 0.0014231204986572
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00030899047851562
(287) DESCRIBE `ports` 0.0014050006866455
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00031900405883789
(289) DESCRIBE `ports` 0.0013530254364014
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00028181076049805
(291) DESCRIBE `avid_specials` 0.001168966293335
(292) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56474 and class = 'Cruise') OR (item_id = 439 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0010819435119629
(293) DESCRIBE `cruiselines` 0.0018529891967773
(294) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00040292739868164
(295) DESCRIBE `orchid_image` 0.0016348361968994
(296) DESCRIBE `cruiselines` 0.0018658638000488
(297) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00030398368835449
(298) DESCRIBE `cruises` 0.0028150081634521
(299) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57661') 0.00032615661621094
(300) DESCRIBE `ships` 0.0025041103363037
(301) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 857))) 0.00034308433532715
(302) DESCRIBE `ships` 0.0026109218597412
(303) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '857') 0.00028800964355469
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026512145996094
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025415420532227
(306) DESCRIBE `itineraries` 0.0016779899597168
(307) DESCRIBE `ports` 0.001392126083374
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00041604042053223
(309) DESCRIBE `ports` 0.0013370513916016
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00029301643371582
(311) DESCRIBE `ports` 0.0012779235839844
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.0002899169921875
(313) DESCRIBE `sailingdates` 0.0011298656463623
(314) DESCRIBE `ports` 0.001349925994873
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00032687187194824
(316) DESCRIBE `ports` 0.0015108585357666
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00029110908508301
(318) DESCRIBE `ports` 0.0012650489807129
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00030398368835449
(320) DESCRIBE `ports` 0.0014088153839111
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00031709671020508
(322) DESCRIBE `ports` 0.0012891292572021
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00039982795715332
(324) DESCRIBE `ports` 0.0014100074768066
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00030398368835449
(326) DESCRIBE `ports` 0.0012471675872803
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00031185150146484
(328) DESCRIBE `ports` 0.0013260841369629
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00028204917907715
(330) DESCRIBE `ports` 0.0014050006866455
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00033712387084961
(332) DESCRIBE `ports` 0.0014581680297852
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00029706954956055
(334) DESCRIBE `avid_specials` 0.0012400150299072
(335) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57661 and class = 'Cruise') OR (item_id = 857 AND class = 'Ship') OR (item_id = 195 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.0010027885437012
(336) DESCRIBE `cruiselines` 0.0020749568939209
(337) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.00037693977355957
(338) DESCRIBE `orchid_image` 0.0014982223510742
(339) DESCRIBE `cruiselines` 0.0019009113311768
(340) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00034284591674805
(341) DESCRIBE `cruises` 0.0025501251220703
(342) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58526') 0.00054311752319336
(343) DESCRIBE `ships` 0.0026760101318359
(344) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 10))) 0.0004730224609375
(345) DESCRIBE `ships` 0.0025830268859863
(346) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '10') 0.00033688545227051
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025320053100586
(349) DESCRIBE `itineraries` 0.0012807846069336
(350) DESCRIBE `ports` 0.00130295753479
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.00031495094299316
(352) DESCRIBE `ports` 0.0014519691467285
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.00035595893859863
(354) DESCRIBE `ports` 0.0012900829315186
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2240') 0.00028705596923828
(356) DESCRIBE `sailingdates` 0.0010991096496582
(357) DESCRIBE `ports` 0.0015759468078613
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.00034880638122559
(359) DESCRIBE `ports` 0.0013279914855957
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2240') 0.0003058910369873
(361) DESCRIBE `ports` 0.001356840133667
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030303001403809
(363) DESCRIBE `ports` 0.0014529228210449
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00030398368835449
(365) DESCRIBE `ports` 0.0014798641204834
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.00033807754516602
(367) DESCRIBE `ports` 0.0014560222625732
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2240') 0.00030994415283203
(369) DESCRIBE `avid_specials` 0.0012950897216797
(370) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58526 and class = 'Cruise') OR (item_id = 10 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0011680126190186
(371) DESCRIBE `cruiselines` 0.0018229484558105
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00040316581726074
(373) DESCRIBE `orchid_image` 0.0014970302581787
(374) DESCRIBE `cruiselines` 0.0018131732940674
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00031399726867676
(376) DESCRIBE `cruises` 0.0035359859466553
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59149') 0.00037884712219238
(378) DESCRIBE `ships` 0.0028209686279297
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 731))) 0.00039911270141602
(380) DESCRIBE `ships` 0.003075122833252
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '731') 0.00031805038452148
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027084350585938
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024890899658203
(384) DESCRIBE `itineraries` 0.0014779567718506
(385) DESCRIBE `ports` 0.0013229846954346
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00033092498779297
(387) DESCRIBE `ports` 0.0013248920440674
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00029206275939941
(389) DESCRIBE `ports` 0.0012960433959961
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00027799606323242
(391) DESCRIBE `sailingdates` 0.0011720657348633
(392) DESCRIBE `ports` 0.00130295753479
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00031185150146484
(394) DESCRIBE `ports` 0.0013489723205566
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00030207633972168
(396) DESCRIBE `ports` 0.0012390613555908
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1690))) 0.00031900405883789
(398) DESCRIBE `ports` 0.0012359619140625
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1690') 0.00031709671020508
(400) DESCRIBE `ports` 0.0012998580932617
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00028800964355469
(402) DESCRIBE `ports` 0.0016510486602783
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00027084350585938
(404) DESCRIBE `ports` 0.0013711452484131
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00029206275939941
(406) DESCRIBE `ports` 0.0013229846954346
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00027084350585938
(408) DESCRIBE `ports` 0.0013489723205566
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00029397010803223
(410) DESCRIBE `ports` 0.0012519359588623
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00036311149597168
(412) DESCRIBE `ports` 0.0012969970703125
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00030899047851562
(414) DESCRIBE `ports` 0.0014350414276123
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00036501884460449
(416) DESCRIBE `ports` 0.0017318725585938
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00046586990356445
(418) DESCRIBE `ports` 0.0016539096832275
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00030398368835449
(420) DESCRIBE `avid_specials` 0.0012190341949463
(421) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59149 and class = 'Cruise') OR (item_id = 731 AND class = 'Ship') OR (item_id = 168 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.00099301338195801
(422) DESCRIBE `cruiselines` 0.0018770694732666
(423) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 168))) 0.00033712387084961
(424) DESCRIBE `orchid_image` 0.0013968944549561
(425) DESCRIBE `cruiselines` 0.0021209716796875
(426) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '168') 0.00030803680419922
(427) DESCRIBE `cruises` 0.0025629997253418
(428) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65902') 0.00034618377685547
(429) DESCRIBE `ships` 0.0027220249176025
(430) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1552))) 0.0004570484161377
(431) DESCRIBE `ships` 0.0028538703918457
(432) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1552') 0.00050091743469238
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026416778564453
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(435) DESCRIBE `itineraries` 0.00166916847229
(436) DESCRIBE `ports` 0.0016510486602783
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00054788589477539
(438) DESCRIBE `ports` 0.0017430782318115
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00056195259094238
(440) DESCRIBE `ports` 0.0018060207366943
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.0003809928894043
(442) DESCRIBE `sailingdates` 0.0011439323425293
(443) DESCRIBE `ports` 0.0016810894012451
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00043392181396484
(445) DESCRIBE `ports` 0.0013129711151123
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00035905838012695
(447) DESCRIBE `ports` 0.0012760162353516
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00033307075500488
(449) DESCRIBE `ports` 0.0013058185577393
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00028085708618164
(451) DESCRIBE `ports` 0.0013508796691895
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00028491020202637
(453) DESCRIBE `ports` 0.001284122467041
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00026607513427734
(455) DESCRIBE `ports` 0.0012650489807129
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3164))) 0.00033903121948242
(457) DESCRIBE `ports` 0.0014848709106445
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3164') 0.00032711029052734
(459) DESCRIBE `ports` 0.0013761520385742
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0003819465637207
(461) DESCRIBE `ports` 0.00130295753479
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00034403800964355
(463) DESCRIBE `ports` 0.001323938369751
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00030207633972168
(465) DESCRIBE `ports` 0.0013489723205566
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00031399726867676
(467) DESCRIBE `ports` 0.0014140605926514
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00044107437133789
(469) DESCRIBE `ports` 0.0014579296112061
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00033903121948242
(471) DESCRIBE `ports` 0.0012919902801514
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00034618377685547
(473) DESCRIBE `ports` 0.0013279914855957
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00032591819763184
(475) DESCRIBE `avid_specials` 0.0012598037719727
(476) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65902 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.00099396705627441
(477) DESCRIBE `cruiselines` 0.0018761157989502
(478) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00030612945556641
(479) DESCRIBE `orchid_image` 0.0013840198516846
(480) DESCRIBE `cruiselines` 0.0018839836120605
(481) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00034189224243164
(482) DESCRIBE `cruiselines` 0.0020978450775146
(483) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '12', '8', '18', '171', '221', '144', '31', '101', '103', '232', '131', '96', '50', '29', '239', '258', '15', '191', '251', '206', '33', '91', '114', '170', '37', '14', '16', '24', '268', '262', '36', '256', '28', '120', '195', '47', '240', '208', '146', '110', '156', '174', '187', '220', '141', '153', '118', '229', '108', '49', '151', '128', '35', '30', '216', '168', '196', '181', '236', '88', '4', '200', '212', '38', '264', '73', '225', '238', '159', '90', '211', '39', '147', '115', '140', '184', '249', '59', '48', '257', '275', '219', '132', '213', '276', '230', '113', '182', '261', '64', '188', '237', '57', '180', '95', '248', '235', '209', '62', '231', '52', '116', '266', '105', '82', '177', '119', '134', '244', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,12,8,18,171,221,144,31,101,103,232,131,96,50,29,239,258,15,191,251,206,33,91,114,170,37,14,16,24,268,262,36,256,28,120,195,47,240,208,146,110,156,174,187,220,141,153,118,229,108,49,151,128,35,30,216,168,196,181,236,88,4,200,212,38,264,73,225,238,159,90,211,39,147,115,140,184,249,59,48,257,275,219,132,213,276,230,113,182,261,64,188,237,57,180,95,248,235,209,62,231,52,116,266,105,82,177,119,134,244,210,224,245') 0.0068490505218506
(484) DESCRIBE `ships` 0.0029778480529785
(485) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1127', '1554', '1555', '1247', '1324', '517', '1032', '974', '797', '21', '22', '461', '1292', '393', '207', '28', '977', '1205', '330', '258', '480', '1291', '1599', '737', '1199', '1010', '1417', '11', '10', '780', '349', '439', '9', '333', '404', '739', '1135', '986', '1359', '14', '454', '1272', '265', '1677', '855', '1237', '24', '25', '731', '1067', '859', '817', '1594', '770', '1607', '113', '1481', '1588', '3', '31', '37', '38', '837', '34', '378', '985', '1239', '1372', '542', '407', '390', '39', '1320', '30', '43', '748', '1579', '36', '970', '1012', '573', '726', '1323', '1402', '1744', '66', '854', '1376', '1768', '526', '582', '1245', '27', '1422', '1424', '327', '332', '882', '1413', '590', '1420', '1552', '1411', '1419', '1423', '1284', '1418', '1421', '1586', '35', '791', '792', '1410', '441', '674', '1773', '585', '1587', '1183', '1415', '455', '1184', '114', '580', '857', '1501', '858', '1176', '711', '1193', '1382', '434', '462', '1236', '1405', '1574', '162', '722', '1215', '1682', '325', '160', '1742', '452', '639', '285', '1021', '1141', '1454', '78', '119', '658', '683', '852', '81', '1008', '1412', '69', '1168', '338', '1095', '1408', '1678', '1760', '1373', '1572', '163', '678', '1172', '869', '1082', '776', '850', '1319', '211', '335', '1630', '111', '253', '610', '1782', '45', '314', '403', '503', '1302', '1383', '1569', '1628', '124', '348', '451', '1259', '1384', '70', '340', '405', '4', '116', '766', '968', '1711', '635', '966', '626', '651', '851', '944', '1159', '148', '286', '386', '553', '63', '324', '385', '508', '749', '768', '1303', '1330', '123', '262', '389', '559', '1068', '1260', '1455', '198', '485', '616', '1266', '1301', '375', '406', '467', '1088', '1108', '1325', '1632', '1672', '84', '291', '784', '1212', '1562', '1575', '287', '1195', '108', '483', '716', '1208', '1781', '98', '421', '1639', '290', '401', '1064', '1571', '394', '1398', '1492', '1614', '1645', '1721', '652', '657', '1308', '883', '954', '147', '150', '152', '341', '1321', '1389', '1724', '149', '151', '223', '704', '874', '1139', '1486', '1611', '1722', '775', '885', '1269', '1539', '1601', '1717', '1268', '1615', '547', '958', '1289', '1557', '1738', '105', '1143', '1326', '1327', '1437', '545', '717', '1771', '351', '516', '1040', '1075', '1704', '75', '790', '818', '1270', '1471', '1679', '868', '1063', '1151', '1213', '1282', '1673', '1684', '796', '823', '1367', '479', '574', '665', '1013', '1214', '1262', '1318', '1676', '1740', '82', '93', '205', '701', '1561', '1766', '520', '1043', '1218', '1460', '1526', '1540', '1566', '644', '673', '715', '988', '1144', '1157', '743', '751', '1137', '1223', '1226', '1344', '212', '266', '669', '884', '1027', '1029', '1163', '1229', '1343', '1409', '1602', '1716', '201', '795', '1160', '1217', '1283', '1452', '1453', '1604', '707', '769', '1025', '1090', '1414', '1612', '1613', '1055', '1073', '1136', '1216', '1426', '1448', '1713', '1715', '417', '448', '601', '695', '905', '996', '1019', '1026', '1110', '1145', '1233', '1243', '1253', '1458', '1496', '1714', '643', '1188', '1211', '1743', '1772', '1783', '74', '888', '973', '997', '1034', '1149', '1351', '1358', '1366', '1404', '1516', '1609', '811', '1049', '1150', '1196', '1222', '1231', '1241', '1345', '1360', '1361', '1362', '1368', '1395', '1449', '1459', '1522', '1619', '1647', '1730', '618', '666', '920', '921', '927', '931', '1047', '1152', '1230', '1354', '1474', '1627', '1663', '1729', '261', '423', '733', '914', '923', '993', '1004', '1322', '1348', '1517', '1518', '1567', '1580', '663', '740', '836', '915', '916', '926', '930', '1037', '1042', '1072', '1138', '1521', '1674', '1708', '1751', '453', '494', '499', '703', '709')) ORDER BY FIND_IN_SET(id, '1761,1127,1554,1555,1247,1324,517,1032,974,797,21,22,461,1292,393,207,28,977,1205,330,258,480,1291,1599,737,1199,1010,1417,11,10,780,349,439,9,333,404,739,1135,986,1359,14,454,1272,265,1677,855,1237,24,25,731,1067,859,817,1594,770,1607,113,1481,1588,3,31,37,38,837,34,378,985,1239,1372,542,407,390,39,1320,30,43,748,1579,36,970,1012,573,726,1323,1402,1744,66,854,1376,1768,526,582,1245,27,1422,1424,327,332,882,1413,590,1420,1552,1411,1419,1423,1284,1418,1421,1586,35,791,792,1410,441,674,1773,585,1587,1183,1415,455,1184,114,580,857,1501,858,1176,711,1193,1382,434,462,1236,1405,1574,162,722,1215,1682,325,160,1742,452,639,285,1021,1141,1454,78,119,658,683,852,81,1008,1412,69,1168,338,1095,1408,1678,1760,1373,1572,163,678,1172,869,1082,776,850,1319,211,335,1630,111,253,610,1782,45,314,403,503,1302,1383,1569,1628,124,348,451,1259,1384,70,340,405,4,116,766,968,1711,635,966,626,651,851,944,1159,148,286,386,553,63,324,385,508,749,768,1303,1330,123,262,389,559,1068,1260,1455,198,485,616,1266,1301,375,406,467,1088,1108,1325,1632,1672,84,291,784,1212,1562,1575,287,1195,108,483,716,1208,1781,98,421,1639,290,401,1064,1571,394,1398,1492,1614,1645,1721,652,657,1308,883,954,147,150,152,341,1321,1389,1724,149,151,223,704,874,1139,1486,1611,1722,775,885,1269,1539,1601,1717,1268,1615,547,958,1289,1557,1738,105,1143,1326,1327,1437,545,717,1771,351,516,1040,1075,1704,75,790,818,1270,1471,1679,868,1063,1151,1213,1282,1673,1684,796,823,1367,479,574,665,1013,1214,1262,1318,1676,1740,82,93,205,701,1561,1766,520,1043,1218,1460,1526,1540,1566,644,673,715,988,1144,1157,743,751,1137,1223,1226,1344,212,266,669,884,1027,1029,1163,1229,1343,1409,1602,1716,201,795,1160,1217,1283,1452,1453,1604,707,769,1025,1090,1414,1612,1613,1055,1073,1136,1216,1426,1448,1713,1715,417,448,601,695,905,996,1019,1026,1110,1145,1233,1243,1253,1458,1496,1714,643,1188,1211,1743,1772,1783,74,888,973,997,1034,1149,1351,1358,1366,1404,1516,1609,811,1049,1150,1196,1222,1231,1241,1345,1360,1361,1362,1368,1395,1449,1459,1522,1619,1647,1730,618,666,920,921,927,931,1047,1152,1230,1354,1474,1627,1663,1729,261,423,733,914,923,993,1004,1322,1348,1517,1518,1567,1580,663,740,836,915,916,926,930,1037,1042,1072,1138,1521,1674,1708,1751,453,494,499,703,709') 0.041785001754761
(486) DESCRIBE `cruisetypes` 0.0017421245574951
(487) DESCRIBE `destinations` 0.002500057220459
(488) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '44', '55', '53', '39', '26', '38', '28', '49', '7', '40', '11', '21', '48', '56', '30', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,44,55,53,39,26,38,28,49,7,40,11,21,48,56,30,46,29,45,34,10,52,32') 0.002065896987915