or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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

Total elapsed time: 0.40308499336243

# Query Time
(1) connect 0.00053310394287109
(2) DESCRIBE `cruises` 0.0015280246734619
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63786, 63787, 40596, 40591, 68831, 40593, 57675, 57673, 57674, 66748)) ORDER BY FIND_IN_SET(id, '63786,63787,40596,40591,68831,40593,57675,57673,57674,66748') 0.0010349750518799
(4) DESCRIBE `specials` 0.0019040107727051
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1393342') AND (specials.orchid_available = 1) LIMIT 1 0.00036907196044922
(6) DESCRIBE `specials` 0.0017199516296387
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1393342') 0.00018906593322754
(8) DESCRIBE `ships` 0.0012080669403076
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00021505355834961
(10) DESCRIBE `ships` 0.0011260509490967
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00016093254089355
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001680850982666
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014805793762207
(14) DESCRIBE `itineraries` 0.0006248950958252
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63786') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041079521179199
(16) DESCRIBE `ports` 0.00065183639526367
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018715858459473
(18) DESCRIBE `ports` 0.00058102607727051
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018000602722168
(20) DESCRIBE `ports` 0.00073599815368652
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017094612121582
(22) DESCRIBE `specialsailingdates` 0.00064921379089355
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1393342') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00043702125549316
(24) DESCRIBE `sailingdates` 0.00056791305541992
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 401051))) 0.00023698806762695
(26) DESCRIBE `ports` 0.00082206726074219
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(28) DESCRIBE `ports` 0.00071597099304199
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002288818359375
(30) DESCRIBE `ports` 0.00074410438537598
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00019288063049316
(32) DESCRIBE `ports` 0.00064301490783691
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018310546875
(34) DESCRIBE `ports` 0.00062990188598633
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0001838207244873
(36) DESCRIBE `ports` 0.00058388710021973
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00016093254089355
(38) DESCRIBE `ports` 0.00057888031005859
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00017595291137695
(40) DESCRIBE `ports` 0.00057888031005859
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00015997886657715
(42) DESCRIBE `ports` 0.00057411193847656
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00017809867858887
(44) DESCRIBE `ports` 0.00057697296142578
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00015997886657715
(46) DESCRIBE `ports` 0.00059008598327637
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00017905235290527
(48) DESCRIBE `ports` 0.00057792663574219
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00016403198242188
(50) DESCRIBE `ports` 0.00058913230895996
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00017809867858887
(52) DESCRIBE `ports` 0.00064492225646973
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00015997886657715
(54) DESCRIBE `ports` 0.00057697296142578
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00016903877258301
(56) DESCRIBE `ports` 0.00062894821166992
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00015997886657715
(58) DESCRIBE `ports` 0.00061702728271484
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00017714500427246
(60) DESCRIBE `ports` 0.00056695938110352
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00016403198242188
(62) DESCRIBE `ports` 0.00056695938110352
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00017309188842773
(64) DESCRIBE `ports` 0.00057101249694824
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0001530647277832
(66) DESCRIBE `ports` 0.00057005882263184
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00017094612121582
(68) DESCRIBE `ports` 0.00056695938110352
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00015497207641602
(70) DESCRIBE `ports` 0.00056910514831543
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017309188842773
(72) DESCRIBE `ports` 0.00059795379638672
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016188621520996
(74) DESCRIBE `ports` 0.00056719779968262
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0001680850982666
(76) DESCRIBE `ports` 0.00056910514831543
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00016212463378906
(78) DESCRIBE `ports` 0.00057601928710938
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00016999244689941
(80) DESCRIBE `ports` 0.00056695938110352
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00016307830810547
(82) DESCRIBE `ports` 0.00067806243896484
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00018596649169922
(84) DESCRIBE `ports` 0.00062012672424316
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.0001678466796875
(86) DESCRIBE `ports` 0.0005950927734375
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00017118453979492
(88) DESCRIBE `ports` 0.00057101249694824
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00016689300537109
(90) DESCRIBE `ports` 0.00057005882263184
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00023007392883301
(92) DESCRIBE `ports` 0.00072312355041504
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.0001990795135498
(94) DESCRIBE `ports` 0.00084304809570312
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00024580955505371
(96) DESCRIBE `ports` 0.00080513954162598
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00019001960754395
(98) DESCRIBE `ports` 0.00058889389038086
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(100) DESCRIBE `ports` 0.00084710121154785
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022196769714355
(102) DESCRIBE `cruises` 0.0018560886383057
(103) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63786))) 0.00044584274291992
(104) DESCRIBE `avid_specials` 0.00085210800170898
(105) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1393342 and class = 'Special') OR (item_id = 63786 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.000946044921875
(106) DESCRIBE `cruiselines` 0.00089192390441895
(107) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022196769714355
(108) DESCRIBE `orchid_image` 0.00075197219848633
(109) DESCRIBE `cruiselines` 0.00079894065856934
(110) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018310546875
(111) DESCRIBE `specials` 0.0020790100097656
(112) SELECT `specials`.* FROM `specials` WHERE (id = '1393320') AND (specials.orchid_available = 1) LIMIT 1 0.00035595893859863
(113) DESCRIBE `specials` 0.0018348693847656
(114) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1393320') 0.00019407272338867
(115) DESCRIBE `ships` 0.0011601448059082
(116) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00021791458129883
(117) DESCRIBE `ships` 0.0011231899261475
(118) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00016689300537109
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001530647277832
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001680850982666
(121) DESCRIBE `itineraries` 0.00059795379638672
(122) DESCRIBE `ports` 0.00061297416687012
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001978874206543
(124) DESCRIBE `ports` 0.00058698654174805
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(126) DESCRIBE `ports` 0.00058293342590332
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001680850982666
(128) DESCRIBE `specialsailingdates` 0.0005488395690918
(129) DESCRIBE `sailingdates` 0.00053191184997559
(130) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 401052))) 0.00021696090698242
(131) DESCRIBE `ports` 0.00064492225646973
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023007392883301
(133) DESCRIBE `ports` 0.00059413909912109
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016593933105469
(135) DESCRIBE `ports` 0.00061202049255371
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00018095970153809
(137) DESCRIBE `ports` 0.00058698654174805
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00016021728515625
(139) DESCRIBE `ports` 0.00060200691223145
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00018787384033203
(141) DESCRIBE `ports` 0.00059700012207031
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00017690658569336
(143) DESCRIBE `ports` 0.00058603286743164
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0001978874206543
(145) DESCRIBE `ports` 0.0006258487701416
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00016188621520996
(147) DESCRIBE `ports` 0.0005950927734375
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00022292137145996
(149) DESCRIBE `ports` 0.00061488151550293
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00021505355834961
(151) DESCRIBE `ports` 0.00063920021057129
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00018715858459473
(153) DESCRIBE `ports` 0.00062298774719238
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00016212463378906
(155) DESCRIBE `ports` 0.00071191787719727
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00019097328186035
(157) DESCRIBE `ports` 0.00059199333190918
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00016188621520996
(159) DESCRIBE `ports` 0.0006251335144043
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00017595291137695
(161) DESCRIBE `ports` 0.0005948543548584
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00015711784362793
(163) DESCRIBE `ports` 0.00058984756469727
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0001828670501709
(165) DESCRIBE `ports` 0.00063180923461914
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00016283988952637
(167) DESCRIBE `ports` 0.00058484077453613
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00019407272338867
(169) DESCRIBE `ports` 0.0005950927734375
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0001671314239502
(171) DESCRIBE `ports` 0.00061702728271484
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00021100044250488
(173) DESCRIBE `ports` 0.00069808959960938
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00016403198242188
(175) DESCRIBE `ports` 0.00058698654174805
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018596649169922
(177) DESCRIBE `ports` 0.00060606002807617
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001838207244873
(179) DESCRIBE `cruises` 0.001183032989502
(180) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63787))) 0.0002748966217041
(181) DESCRIBE `avid_specials` 0.00067710876464844
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1393320 and class = 'Special') OR (item_id = 63787 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0013630390167236
(183) DESCRIBE `cruiselines` 0.0012061595916748
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00028514862060547
(185) DESCRIBE `orchid_image` 0.00068402290344238
(186) DESCRIBE `cruiselines` 0.0010919570922852
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0001838207244873
(188) DESCRIBE `specials` 0.0018389225006104
(189) SELECT `specials`.* FROM `specials` WHERE (id = '1396706') AND (specials.orchid_available = 1) LIMIT 1 0.00034999847412109
(190) DESCRIBE `specials` 0.0020840167999268
(191) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396706') 0.00025510787963867
(192) DESCRIBE `ships` 0.0011429786682129
(193) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.0002281665802002
(194) DESCRIBE `ships` 0.001176118850708
(195) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00017094612121582
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001521110534668
(197) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014305114746094
(198) DESCRIBE `itineraries` 0.00058197975158691
(199) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40596') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053787231445312
(200) DESCRIBE `ports` 0.00062799453735352
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00018692016601562
(202) DESCRIBE `ports` 0.00058603286743164
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00021910667419434
(204) DESCRIBE `ports` 0.00083708763122559
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00023388862609863
(206) DESCRIBE `specialsailingdates` 0.00070285797119141
(207) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1396706') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00068902969360352
(208) DESCRIBE `sailingdates` 0.00085806846618652
(209) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423580))) 0.00023198127746582
(210) DESCRIBE `sailingdates` 0.00054216384887695
(211) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423585))) 0.00016903877258301
(212) DESCRIBE `sailingdates` 0.00055313110351562
(213) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423586))) 0.00017905235290527
(214) DESCRIBE `ports` 0.00060582160949707
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00021910667419434
(216) DESCRIBE `ports` 0.00059103965759277
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016999244689941
(218) DESCRIBE `ports` 0.0014851093292236
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00019407272338867
(220) DESCRIBE `ports` 0.00059795379638672
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015687942504883
(222) DESCRIBE `ports` 0.00058579444885254
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020194053649902
(224) DESCRIBE `ports` 0.00058197975158691
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016212463378906
(226) DESCRIBE `ports` 0.00058507919311523
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017189979553223
(228) DESCRIBE `ports` 0.00058794021606445
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018787384033203
(230) DESCRIBE `ports` 0.0007319450378418
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020694732666016
(232) DESCRIBE `ports` 0.00072312355041504
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00019097328186035
(234) DESCRIBE `ports` 0.00066399574279785
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00019693374633789
(236) DESCRIBE `ports` 0.00066995620727539
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00023412704467773
(238) DESCRIBE `ports` 0.00080585479736328
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00021219253540039
(240) DESCRIBE `ports` 0.00089716911315918
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00024008750915527
(242) DESCRIBE `ports` 0.00093388557434082
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00028610229492188
(244) DESCRIBE `ports` 0.00094509124755859
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00022101402282715
(246) DESCRIBE `cruises` 0.0018761157989502
(247) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40596))) 0.00041604042053223
(248) DESCRIBE `avid_specials` 0.00096416473388672
(249) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396706 and class = 'Special') OR (item_id = 40596 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 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.0016279220581055
(250) DESCRIBE `cruiselines` 0.0013480186462402
(251) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00029087066650391
(252) DESCRIBE `orchid_image` 0.00087809562683105
(253) DESCRIBE `cruiselines` 0.0010449886322021
(254) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00020790100097656
(255) DESCRIBE `specials` 0.0028378963470459
(256) DESCRIBE `specials` 0.0020780563354492
(257) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396701') 0.00029301643371582
(258) DESCRIBE `ships` 0.0013000965118408
(259) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00027203559875488
(260) DESCRIBE `ships` 0.0012118816375732
(261) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00017786026000977
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001671314239502
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014400482177734
(264) DESCRIBE `itineraries` 0.00081586837768555
(265) DESCRIBE `ports` 0.00068092346191406
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00023913383483887
(267) DESCRIBE `ports` 0.0007169246673584
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00027203559875488
(269) DESCRIBE `ports` 0.00059294700622559
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00017404556274414
(271) DESCRIBE `specialsailingdates` 0.00057888031005859
(272) DESCRIBE `sailingdates` 0.00063490867614746
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423482))) 0.00023007392883301
(274) DESCRIBE `sailingdates` 0.00075793266296387
(275) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463858))) 0.00038599967956543
(276) DESCRIBE `sailingdates` 0.00077199935913086
(277) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423484))) 0.00018906593322754
(278) DESCRIBE `sailingdates` 0.00062298774719238
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423487))) 0.00027894973754883
(280) DESCRIBE `sailingdates` 0.00067687034606934
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423488))) 0.00019001960754395
(282) DESCRIBE `sailingdates` 0.00072693824768066
(283) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463859))) 0.00020003318786621
(284) DESCRIBE `ports` 0.0007328987121582
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0002140998840332
(286) DESCRIBE `ports` 0.00076889991760254
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00020885467529297
(288) DESCRIBE `ports` 0.00078392028808594
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00025701522827148
(290) DESCRIBE `ports` 0.00062990188598633
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00021004676818848
(292) DESCRIBE `ports` 0.00062990188598633
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020813941955566
(294) DESCRIBE `ports` 0.00083613395690918
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00021004676818848
(296) DESCRIBE `ports` 0.00067305564880371
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00025010108947754
(298) DESCRIBE `ports` 0.00067806243896484
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.0002140998840332
(300) DESCRIBE `cruises` 0.0015780925750732
(301) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) 0.00040006637573242
(302) DESCRIBE `avid_specials` 0.00063896179199219
(303) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396701 and class = 'Special') OR (item_id = 40591 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 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.00083303451538086
(304) DESCRIBE `cruiselines` 0.00084710121154785
(305) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00020217895507812
(306) DESCRIBE `orchid_image` 0.00069403648376465
(307) DESCRIBE `cruiselines` 0.0008549690246582
(308) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0001680850982666
(309) DESCRIBE `specials` 0.0019059181213379
(310) SELECT `specials`.* FROM `specials` WHERE (id = '1394193') AND (specials.orchid_available = 1) LIMIT 1 0.0006251335144043
(311) DESCRIBE `specials` 0.0028440952301025
(312) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1394193') 0.00035309791564941
(313) DESCRIBE `ships` 0.0019791126251221
(314) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00034284591674805
(315) DESCRIBE `ships` 0.0018761157989502
(316) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0002591609954834
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020885467529297
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(319) DESCRIBE `itineraries` 0.00094199180603027
(320) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68831') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067496299743652
(321) DESCRIBE `ports` 0.00097298622131348
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00028300285339355
(323) DESCRIBE `ports` 0.00088906288146973
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00027298927307129
(325) DESCRIBE `ports` 0.00087714195251465
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0002439022064209
(327) DESCRIBE `specialsailingdates` 0.00077700614929199
(328) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1394193') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00065302848815918
(329) DESCRIBE `sailingdates` 0.00086092948913574
(330) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 432462))) 0.00025606155395508
(331) DESCRIBE `sailingdates` 0.00077319145202637
(332) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 432463))) 0.00023508071899414
(333) DESCRIBE `ports` 0.00090694427490234
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029277801513672
(335) DESCRIBE `ports` 0.00094103813171387
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00023293495178223
(337) DESCRIBE `ports` 0.00086784362792969
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00025296211242676
(339) DESCRIBE `ports` 0.00088095664978027
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00021886825561523
(341) DESCRIBE `ports` 0.00089192390441895
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00025820732116699
(343) DESCRIBE `ports` 0.00089597702026367
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00022506713867188
(345) DESCRIBE `ports` 0.00088095664978027
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00026106834411621
(347) DESCRIBE `ports` 0.00088787078857422
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00023102760314941
(349) DESCRIBE `ports` 0.00074887275695801
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00020790100097656
(351) DESCRIBE `ports` 0.00063300132751465
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00017881393432617
(353) DESCRIBE `ports` 0.00059986114501953
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0001978874206543
(355) DESCRIBE `ports` 0.00062179565429688
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00017905235290527
(357) DESCRIBE `ports` 0.00058913230895996
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0002129077911377
(359) DESCRIBE `ports` 0.00059103965759277
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00017094612121582
(361) DESCRIBE `ports` 0.00063681602478027
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00019502639770508
(363) DESCRIBE `ports` 0.00060200691223145
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00016999244689941
(365) DESCRIBE `ports` 0.0006098747253418
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00022292137145996
(367) DESCRIBE `ports` 0.00068879127502441
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00021791458129883
(369) DESCRIBE `cruises` 0.0017549991607666
(370) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68831))) 0.00036716461181641
(371) DESCRIBE `avid_specials` 0.00078296661376953
(372) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1394193 and class = 'Special') OR (item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0014879703521729
(373) DESCRIBE `cruiselines` 0.0014169216156006
(374) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00027894973754883
(375) DESCRIBE `orchid_image` 0.00096607208251953
(376) DESCRIBE `cruiselines` 0.001276969909668
(377) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00025701522827148
(378) DESCRIBE `specials` 0.002072811126709
(379) SELECT `specials`.* FROM `specials` WHERE (id = '1396711') AND (specials.orchid_available = 1) LIMIT 1 0.00043678283691406
(380) DESCRIBE `specials` 0.0023210048675537
(381) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396711') 0.00035691261291504
(382) DESCRIBE `ships` 0.0015511512756348
(383) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00026798248291016
(384) DESCRIBE `ships` 0.0013391971588135
(385) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00021004676818848
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001828670501709
(388) DESCRIBE `itineraries` 0.00072503089904785
(389) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40593') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048708915710449
(390) DESCRIBE `ports` 0.00087285041809082
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00025510787963867
(392) DESCRIBE `ports` 0.00084209442138672
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00020003318786621
(394) DESCRIBE `ports` 0.00088191032409668
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00022101402282715
(396) DESCRIBE `specialsailingdates` 0.00070810317993164
(397) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1396711') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00059795379638672
(398) DESCRIBE `sailingdates` 0.00066709518432617
(399) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423520))) 0.00025796890258789
(400) DESCRIBE `sailingdates` 0.00061297416687012
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423522))) 0.00024914741516113
(402) DESCRIBE `sailingdates` 0.00064802169799805
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423523))) 0.00018882751464844
(404) DESCRIBE `sailingdates` 0.00055885314941406
(405) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423524))) 0.00019693374633789
(406) DESCRIBE `sailingdates` 0.00053501129150391
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423526))) 0.00023698806762695
(408) DESCRIBE `sailingdates` 0.00063180923461914
(409) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423527))) 0.00018501281738281
(410) DESCRIBE `ports` 0.00071907043457031
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00024986267089844
(412) DESCRIBE `ports` 0.00061702728271484
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00018787384033203
(414) DESCRIBE `ports` 0.00067687034606934
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00024008750915527
(416) DESCRIBE `ports` 0.00080490112304688
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00021195411682129
(418) DESCRIBE `ports` 0.00082492828369141
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00023388862609863
(420) DESCRIBE `ports` 0.00077915191650391
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00020909309387207
(422) DESCRIBE `ports` 0.00074386596679688
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018882751464844
(424) DESCRIBE `ports` 0.00061511993408203
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0001671314239502
(426) DESCRIBE `ports` 0.00058698654174805
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00019001960754395
(428) DESCRIBE `ports` 0.00062012672424316
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016593933105469
(430) DESCRIBE `cruises` 0.001237154006958
(431) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40593))) 0.00031018257141113
(432) DESCRIBE `avid_specials` 0.00062394142150879
(433) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396711 and class = 'Special') OR (item_id = 40593 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 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.0008389949798584
(434) DESCRIBE `cruiselines` 0.00090694427490234
(435) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00021100044250488
(436) DESCRIBE `orchid_image` 0.00068402290344238
(437) DESCRIBE `cruiselines` 0.0011930465698242
(438) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00022292137145996
(439) DESCRIBE `specials` 0.0019271373748779
(440) SELECT `specials`.* FROM `specials` WHERE (id = '1396515') AND (specials.orchid_available = 1) LIMIT 1 0.00039911270141602
(441) DESCRIBE `specials` 0.0023670196533203
(442) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396515') 0.00035595893859863
(443) DESCRIBE `ships` 0.001554012298584
(444) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00026798248291016
(445) DESCRIBE `ships` 0.0014021396636963
(446) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00026702880859375
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016498565673828
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001521110534668
(449) DESCRIBE `itineraries` 0.00067806243896484
(450) DESCRIBE `ports` 0.00066804885864258
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00022196769714355
(452) DESCRIBE `ports` 0.00059294700622559
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018882751464844
(454) DESCRIBE `ports` 0.00064682960510254
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00019311904907227
(456) DESCRIBE `specialsailingdates` 0.00052499771118164
(457) DESCRIBE `sailingdates` 0.00069308280944824
(458) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423707))) 0.00025105476379395
(459) DESCRIBE `sailingdates` 0.00059103965759277
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423708))) 0.00019598007202148
(461) DESCRIBE `sailingdates` 0.00053787231445312
(462) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423709))) 0.00017285346984863
(463) DESCRIBE `ports` 0.00063800811767578
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00023603439331055
(465) DESCRIBE `ports` 0.00061798095703125
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018596649169922
(467) DESCRIBE `ports` 0.00059008598327637
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00024890899658203
(469) DESCRIBE `ports` 0.00080394744873047
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00022387504577637
(471) DESCRIBE `ports` 0.00083589553833008
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00024795532226562
(473) DESCRIBE `ports` 0.00080204010009766
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00022697448730469
(475) DESCRIBE `ports` 0.00081396102905273
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00024795532226562
(477) DESCRIBE `ports` 0.00087404251098633
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00022721290588379
(479) DESCRIBE `ports` 0.00091195106506348
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00024914741516113
(481) DESCRIBE `ports` 0.00085592269897461
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00022315979003906
(483) DESCRIBE `ports` 0.00086307525634766
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00025200843811035
(485) DESCRIBE `ports` 0.00088691711425781
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0002601146697998
(487) DESCRIBE `cruises` 0.0020301342010498
(488) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57675))) 0.0003969669342041
(489) DESCRIBE `avid_specials` 0.00082111358642578
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396515 and class = 'Special') OR (item_id = 57675 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0015969276428223
(491) DESCRIBE `cruiselines` 0.0012500286102295
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0002899169921875
(493) DESCRIBE `orchid_image` 0.00099992752075195
(494) DESCRIBE `cruiselines` 0.0012240409851074
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00025010108947754
(496) DESCRIBE `specials` 0.0026671886444092
(497) SELECT `specials`.* FROM `specials` WHERE (id = '1396505') AND (specials.orchid_available = 1) LIMIT 1 0.00046801567077637
(498) DESCRIBE `specials` 0.002528190612793
(499) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396505') 0.00028395652770996
(500) DESCRIBE `ships` 0.0017659664154053
(501) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00034022331237793
(502) DESCRIBE `ships` 0.0017650127410889
(503) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00026798248291016
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021004676818848
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001990795135498
(506) DESCRIBE `itineraries` 0.00091886520385742
(507) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57673') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053000450134277
(508) DESCRIBE `ports` 0.0011801719665527
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00028395652770996
(510) DESCRIBE `ports` 0.00081896781921387
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019097328186035
(512) DESCRIBE `ports` 0.00065183639526367
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018310546875
(514) DESCRIBE `specialsailingdates` 0.00053095817565918
(515) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1396505') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00045204162597656
(516) DESCRIBE `sailingdates` 0.00065708160400391
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423855))) 0.0001981258392334
(518) DESCRIBE `sailingdates` 0.00055384635925293
(519) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423857))) 0.00016999244689941
(520) DESCRIBE `sailingdates` 0.00054121017456055
(521) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423858))) 0.00017213821411133
(522) DESCRIBE `ports` 0.00064492225646973
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020122528076172
(524) DESCRIBE `ports` 0.0006871223449707
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017714500427246
(526) DESCRIBE `ports` 0.00058293342590332
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00017786026000977
(528) DESCRIBE `ports` 0.00060701370239258
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00017881393432617
(530) DESCRIBE `ports` 0.00060701370239258
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.0001838207244873
(532) DESCRIBE `ports` 0.00071597099304199
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.0001680850982666
(534) DESCRIBE `ports` 0.0006561279296875
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00017905235290527
(536) DESCRIBE `ports` 0.00062298774719238
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00016093254089355
(538) DESCRIBE `ports` 0.00063085556030273
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00017881393432617
(540) DESCRIBE `ports` 0.00059294700622559
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00016093254089355
(542) DESCRIBE `ports` 0.00057506561279297
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020503997802734
(544) DESCRIBE `ports` 0.00060796737670898
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017309188842773
(546) DESCRIBE `ports` 0.00058698654174805
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00018715858459473
(548) DESCRIBE `ports` 0.0006411075592041
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00016403198242188
(550) DESCRIBE `ports` 0.00058817863464355
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00017380714416504
(552) DESCRIBE `ports` 0.00059103965759277
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00015902519226074
(554) DESCRIBE `ports` 0.00061297416687012
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00018405914306641
(556) DESCRIBE `ports` 0.00058913230895996
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00016999244689941
(558) DESCRIBE `ports` 0.00058197975158691
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00019192695617676
(560) DESCRIBE `ports` 0.00060391426086426
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00016498565673828
(562) DESCRIBE `ports` 0.00058794021606445
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00018596649169922
(564) DESCRIBE `ports` 0.00060296058654785
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00016903877258301
(566) DESCRIBE `ports` 0.00064802169799805
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020194053649902
(568) DESCRIBE `ports` 0.0006251335144043
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00017595291137695
(570) DESCRIBE `cruises` 0.0013179779052734
(571) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57673))) 0.00029087066650391
(572) DESCRIBE `avid_specials` 0.00068306922912598
(573) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396505 and class = 'Special') OR (item_id = 57673 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.00084400177001953
(574) DESCRIBE `cruiselines` 0.0009150505065918
(575) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0002288818359375
(576) DESCRIBE `orchid_image` 0.00067496299743652
(577) DESCRIBE `cruiselines` 0.00083589553833008
(578) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00017619132995605
(579) DESCRIBE `specials` 0.0026381015777588
(580) SELECT `specials`.* FROM `specials` WHERE (id = '1396495') AND (specials.orchid_available = 1) LIMIT 1 0.00060796737670898
(581) DESCRIBE `specials` 0.0026919841766357
(582) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396495') 0.00030183792114258
(583) DESCRIBE `ships` 0.0016241073608398
(584) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00030708312988281
(585) DESCRIBE `ships` 0.0015480518341064
(586) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00022006034851074
(587) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019192695617676
(588) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(589) DESCRIBE `itineraries` 0.00079512596130371
(590) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57674') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041699409484863
(591) DESCRIBE `ports` 0.00096702575683594
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0002739429473877
(593) DESCRIBE `ports` 0.00081205368041992
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0002288818359375
(595) DESCRIBE `ports` 0.0006859302520752
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018692016601562
(597) DESCRIBE `specialsailingdates` 0.00069499015808105
(598) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1396495') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00046086311340332
(599) DESCRIBE `sailingdates` 0.00095009803771973
(600) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423781))) 0.00024509429931641
(601) DESCRIBE `sailingdates` 0.00052499771118164
(602) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423783))) 0.00016903877258301
(603) DESCRIBE `sailingdates` 0.00070285797119141
(604) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423784))) 0.00021982192993164
(605) DESCRIBE `ports` 0.00087714195251465
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00025796890258789
(607) DESCRIBE `ports` 0.00062394142150879
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018095970153809
(609) DESCRIBE `ports` 0.00067806243896484
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00018692016601562
(611) DESCRIBE `ports` 0.00062799453735352
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.0002129077911377
(613) DESCRIBE `ports` 0.00079488754272461
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00022006034851074
(615) DESCRIBE `ports` 0.00078606605529785
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00020098686218262
(617) DESCRIBE `ports` 0.00077414512634277
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00022482872009277
(619) DESCRIBE `ports` 0.00077104568481445
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00023007392883301
(621) DESCRIBE `ports` 0.00061297416687012
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00019097328186035
(623) DESCRIBE `ports` 0.00066280364990234
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00016498565673828
(625) DESCRIBE `ports` 0.0005958080291748
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018310546875
(627) DESCRIBE `ports` 0.00059700012207031
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0002138614654541
(629) DESCRIBE `cruises` 0.0012469291687012
(630) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57674))) 0.00027012825012207
(631) DESCRIBE `avid_specials` 0.00057291984558105
(632) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396495 and class = 'Special') OR (item_id = 57674 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.00090885162353516
(633) DESCRIBE `cruiselines` 0.00085806846618652
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00020885467529297
(635) DESCRIBE `orchid_image` 0.00066113471984863
(636) DESCRIBE `cruiselines` 0.0008540153503418
(637) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00017905235290527
(638) DESCRIBE `specials` 0.002025842666626
(639) SELECT `specials`.* FROM `specials` WHERE (id = '1394201') AND (specials.orchid_available = 1) LIMIT 1 0.00046205520629883
(640) DESCRIBE `specials` 0.001986026763916
(641) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1394201') 0.00020503997802734
(642) DESCRIBE `ships` 0.0011749267578125
(643) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00026082992553711
(644) DESCRIBE `ships` 0.0012350082397461
(645) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00019097328186035
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016498565673828
(647) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018715858459473
(648) DESCRIBE `itineraries` 0.00061583518981934
(649) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66748') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053095817565918
(650) DESCRIBE `ports` 0.00082612037658691
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00022697448730469
(652) DESCRIBE `ports` 0.0005950927734375
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00021505355834961
(654) DESCRIBE `ports` 0.00064706802368164
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00017285346984863
(656) DESCRIBE `specialsailingdates` 0.00057601928710938
(657) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1394201') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00045514106750488
(658) DESCRIBE `sailingdates` 0.0005950927734375
(659) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 457860))) 0.00017189979553223
(660) DESCRIBE `sailingdates` 0.00053691864013672
(661) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 432259))) 0.00018000602722168
(662) DESCRIBE `ports` 0.00075697898864746
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020289421081543
(664) DESCRIBE `ports` 0.00066900253295898
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00017189979553223
(666) DESCRIBE `ports` 0.00058698654174805
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00018596649169922
(668) DESCRIBE `ports` 0.00059914588928223
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00016498565673828
(670) DESCRIBE `ports` 0.00062108039855957
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00020813941955566
(672) DESCRIBE `ports` 0.00063705444335938
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00017404556274414
(674) DESCRIBE `ports` 0.00067496299743652
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00017714500427246
(676) DESCRIBE `ports` 0.00058889389038086
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00020003318786621
(678) DESCRIBE `ports` 0.00063610076904297
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00023794174194336
(680) DESCRIBE `ports` 0.0008699893951416
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00018596649169922
(682) DESCRIBE `ports` 0.0006251335144043
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00018692016601562
(684) DESCRIBE `ports` 0.00059604644775391
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0001671314239502
(686) DESCRIBE `ports` 0.00062012672424316
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00034403800964355
(688) DESCRIBE `ports` 0.00059795379638672
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00017189979553223
(690) DESCRIBE `ports` 0.00059294700622559
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00023198127746582
(692) DESCRIBE `ports` 0.00061297416687012
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00016498565673828
(694) DESCRIBE `ports` 0.00059604644775391
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00019502639770508
(696) DESCRIBE `ports` 0.00064301490783691
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00016403198242188
(698) DESCRIBE `cruises` 0.0012118816375732
(699) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66748))) 0.00030303001403809
(700) DESCRIBE `avid_specials` 0.00057005882263184
(701) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1394201 and class = 'Special') OR (item_id = 66748 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.00085902214050293
(702) DESCRIBE `cruiselines` 0.00090193748474121
(703) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00022697448730469
(704) DESCRIBE `orchid_image` 0.00071501731872559
(705) DESCRIBE `cruiselines` 0.00086879730224609
(706) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00020217895507812
(707) DESCRIBE `cruiselines` 0.0011739730834961
(708) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('213', '191', '23', '33', '18', '26', '114', '15', '212', '216', '8', '101', '151', '91', '218', '28', '37', '14', '20', '29', '19', '24', '187', '258')) ORDER BY FIND_IN_SET(id, '213,191,23,33,18,26,114,15,212,216,8,101,151,91,218,28,37,14,20,29,19,24,187,258') 0.00093293190002441
(709) DESCRIBE `ships` 0.0015969276428223
(710) SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '1347', '1032', '1023', '163', '547', '1266', '1385', '1539', '855', '78', '780', '262', '451', '1013', '1282', '1526', '1579', '542', '616', '1154', '1672', '75', '82', '98', '258', '287', '290', '332', '341', '406', '580', '585', '678', '683', '790', '850', '968', '1022', '1029', '1135', '1402', '43', '74', '84', '105', '111', '223', '253', '286', '291', '335', '348', '349', '352', '389', '403', '404', '508', '573', '582', '652', '657', '711', '722', '748', '770', '776', '884', '888', '966', '1108', '1163', '1189', '1223', '1285', '1302', '1308', '1319', '1320', '1323', '1325', '1409', '1413', '1571')) ORDER BY FIND_IN_SET(id, '1205,1347,1032,1023,163,547,1266,1385,1539,855,78,780,262,451,1013,1282,1526,1579,542,616,1154,1672,75,82,98,258,287,290,332,341,406,580,585,678,683,790,850,968,1022,1029,1135,1402,43,74,84,105,111,223,253,286,291,335,348,349,352,389,403,404,508,573,582,652,657,711,722,748,770,776,884,888,966,1108,1163,1189,1223,1285,1302,1308,1319,1320,1323,1325,1409,1413,1571') 0.0033090114593506
(711) DESCRIBE `cruisetypes` 0.0009160041809082
(712) DESCRIBE `destinations` 0.0013890266418457
(713) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '22', '54', '55', '8', '35', '12', '39', '50', '11', '21', '26', '40', '48', '25', '37', '49', '29', '53')) ORDER BY FIND_IN_SET(id, '2,43,22,54,55,8,35,12,39,50,11,21,26,40,48,25,37,49,29,53') 0.0011208057403564