or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Total elapsed time: 0.31039237976074

# Query Time
(1) connect 0.00075411796569824
(2) DESCRIBE `cruises` 0.001777172088623
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41315, 67049, 34153, 40855, 56476, 56639, 58528, 58948, 63992, 68344)) ORDER BY FIND_IN_SET(id, '41315,67049,34153,40855,56476,56639,58528,58948,63992,68344') 0.0011448860168457
(4) DESCRIBE `cruises` 0.0014100074768066
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41315') 0.00025391578674316
(6) DESCRIBE `ships` 0.0012800693511963
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1064))) 0.00028491020202637
(8) DESCRIBE `ships` 0.0012850761413574
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1064') 0.00024008750915527
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001978874206543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017309188842773
(12) DESCRIBE `itineraries` 0.00074315071105957
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41315') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057697296142578
(14) DESCRIBE `ports` 0.00084400177001953
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022697448730469
(16) DESCRIBE `ports` 0.00075197219848633
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021600723266602
(18) DESCRIBE `ports` 0.00071096420288086
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018692016601562
(20) DESCRIBE `sailingdates` 0.00061202049255371
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41315') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00065207481384277
(22) DESCRIBE `ports` 0.00081300735473633
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021481513977051
(24) DESCRIBE `ports` 0.00066995620727539
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018692016601562
(26) DESCRIBE `ports` 0.00066399574279785
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00022697448730469
(28) DESCRIBE `ports` 0.00089406967163086
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00050210952758789
(30) DESCRIBE `ports` 0.0014641284942627
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.0003659725189209
(32) DESCRIBE `ports` 0.0011768341064453
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.0003199577331543
(34) DESCRIBE `ports` 0.0012149810791016
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00034999847412109
(36) DESCRIBE `ports` 0.0011579990386963
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00035285949707031
(38) DESCRIBE `ports` 0.0015861988067627
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00036096572875977
(40) DESCRIBE `ports` 0.0011978149414062
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00032281875610352
(42) DESCRIBE `ports` 0.0011541843414307
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00041103363037109
(44) DESCRIBE `ports` 0.0011489391326904
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00031590461730957
(46) DESCRIBE `ports` 0.0011770725250244
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00035285949707031
(48) DESCRIBE `ports` 0.0011470317840576
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00031709671020508
(50) DESCRIBE `avid_specials` 0.0010511875152588
(51) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41315 and class = 'Cruise') OR (item_id = 1064 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019080638885498
(52) DESCRIBE `cruiselines` 0.0016307830810547
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00021815299987793
(54) DESCRIBE `orchid_image` 0.00076389312744141
(55) DESCRIBE `cruiselines` 0.00090789794921875
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018715858459473
(57) DESCRIBE `cruises` 0.0022530555725098
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67049') 0.0002589225769043
(59) DESCRIBE `ships` 0.0016489028930664
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1572))) 0.00028491020202637
(61) DESCRIBE `ships` 0.0013859272003174
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1572') 0.00020503997802734
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018596649169922
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019502639770508
(65) DESCRIBE `itineraries` 0.00067591667175293
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67049') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010299682617188
(67) DESCRIBE `ports` 0.0008080005645752
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00023198127746582
(69) DESCRIBE `ports` 0.00067305564880371
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.0001990795135498
(71) DESCRIBE `ports` 0.00069594383239746
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00023102760314941
(73) DESCRIBE `sailingdates` 0.00077414512634277
(74) DESCRIBE `ports` 0.0009150505065918
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00024509429931641
(76) DESCRIBE `ports` 0.00068116188049316
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00019311904907227
(78) DESCRIBE `ports` 0.00066518783569336
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5636))) 0.00021886825561523
(80) DESCRIBE `ports` 0.00068402290344238
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5636') 0.00018596649169922
(82) DESCRIBE `ports` 0.00066590309143066
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5107))) 0.0002129077911377
(84) DESCRIBE `ports` 0.00066280364990234
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5107') 0.00018715858459473
(86) DESCRIBE `ports` 0.00068902969360352
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5637))) 0.00021505355834961
(88) DESCRIBE `ports` 0.00066089630126953
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5637') 0.00018310546875
(90) DESCRIBE `ports` 0.00067400932312012
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5638))) 0.00020289421081543
(92) DESCRIBE `ports` 0.00066113471984863
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5638') 0.00018191337585449
(94) DESCRIBE `ports` 0.00068998336791992
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5639))) 0.0001978874206543
(96) DESCRIBE `ports` 0.00067710876464844
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5639') 0.00020408630371094
(98) DESCRIBE `ports` 0.00065803527832031
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00020098686218262
(100) DESCRIBE `ports` 0.00065803527832031
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00018095970153809
(102) DESCRIBE `avid_specials` 0.00060296058654785
(103) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67049 and class = 'Cruise') OR (item_id = 1572 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 30 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.00097799301147461
(104) DESCRIBE `cruiselines` 0.00097203254699707
(105) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00021791458129883
(106) DESCRIBE `orchid_image` 0.00081586837768555
(107) DESCRIBE `cruises` 0.0013449192047119
(108) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34153') 0.000244140625
(109) DESCRIBE `ships` 0.00136399269104
(110) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 38))) 0.00024199485778809
(111) DESCRIBE `ships` 0.0012760162353516
(112) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '38') 0.00018119812011719
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018501281738281
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016999244689941
(115) DESCRIBE `itineraries` 0.00066709518432617
(116) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34153') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049710273742676
(117) DESCRIBE `ports` 0.0012080669403076
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00026488304138184
(119) DESCRIBE `ports` 0.00070405006408691
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.0002138614654541
(121) DESCRIBE `ports` 0.00074315071105957
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00019693374633789
(123) DESCRIBE `sailingdates` 0.0006098747253418
(124) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34153') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072002410888672
(125) DESCRIBE `ports` 0.00086712837219238
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00023794174194336
(127) DESCRIBE `ports` 0.00067710876464844
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00018906593322754
(129) DESCRIBE `ports` 0.00069999694824219
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020098686218262
(131) DESCRIBE `ports` 0.00066685676574707
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00018215179443359
(133) DESCRIBE `ports` 0.00066900253295898
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00020790100097656
(135) DESCRIBE `ports` 0.00068807601928711
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00018501281738281
(137) DESCRIBE `ports` 0.0006709098815918
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00025081634521484
(139) DESCRIBE `ports` 0.00067877769470215
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00018405914306641
(141) DESCRIBE `ports` 0.00077414512634277
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00020384788513184
(143) DESCRIBE `ports` 0.00066995620727539
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00018620491027832
(145) DESCRIBE `ports` 0.00072908401489258
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00021100044250488
(147) DESCRIBE `ports` 0.00068807601928711
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00018620491027832
(149) DESCRIBE `ports` 0.00066804885864258
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00021791458129883
(151) DESCRIBE `ports` 0.00075793266296387
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00021219253540039
(153) DESCRIBE `ports` 0.00067996978759766
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00020599365234375
(155) DESCRIBE `ports` 0.00069284439086914
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00018596649169922
(157) DESCRIBE `ports` 0.00081992149353027
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00020909309387207
(159) DESCRIBE `ports` 0.0006709098815918
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00019216537475586
(161) DESCRIBE `ports` 0.0006718635559082
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00021100044250488
(163) DESCRIBE `ports` 0.00066304206848145
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00022697448730469
(165) DESCRIBE `ports` 0.00066518783569336
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020599365234375
(167) DESCRIBE `ports` 0.00067901611328125
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018191337585449
(169) DESCRIBE `avid_specials` 0.00062394142150879
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34153 and class = 'Cruise') OR (item_id = 38 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.00096011161804199
(171) DESCRIBE `cruiselines` 0.0014209747314453
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00023412704467773
(173) DESCRIBE `orchid_image` 0.00074386596679688
(174) DESCRIBE `cruiselines` 0.00094008445739746
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00019407272338867
(176) DESCRIBE `cruises` 0.0012609958648682
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40855') 0.00021600723266602
(178) DESCRIBE `ships` 0.001384973526001
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1048))) 0.000244140625
(180) DESCRIBE `ships` 0.0012581348419189
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1048') 0.00017499923706055
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017094612121582
(184) DESCRIBE `itineraries` 0.00064802169799805
(185) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40855') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082683563232422
(186) DESCRIBE `ports` 0.00076603889465332
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00021600723266602
(188) DESCRIBE `ports` 0.00066804885864258
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00020003318786621
(190) DESCRIBE `ports` 0.00066590309143066
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00018596649169922
(192) DESCRIBE `sailingdates` 0.00062799453735352
(193) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '40855') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00033807754516602
(194) DESCRIBE `ports` 0.00083303451538086
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00020909309387207
(196) DESCRIBE `ports` 0.00071907043457031
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00020408630371094
(198) DESCRIBE `ports` 0.00085306167602539
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00021195411682129
(200) DESCRIBE `ports` 0.00066709518432617
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018501281738281
(202) DESCRIBE `ports` 0.0006861686706543
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00020289421081543
(204) DESCRIBE `ports` 0.00066900253295898
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00018405914306641
(206) DESCRIBE `ports` 0.00066494941711426
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00020003318786621
(208) DESCRIBE `ports` 0.00068092346191406
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.0001978874206543
(210) DESCRIBE `ports` 0.00069904327392578
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1068))) 0.00021100044250488
(212) DESCRIBE `ports` 0.0007321834564209
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1068') 0.00018596649169922
(214) DESCRIBE `ports` 0.00066804885864258
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0002281665802002
(216) DESCRIBE `ports` 0.00071096420288086
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00020098686218262
(218) DESCRIBE `avid_specials` 0.00064516067504883
(219) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40855 and class = 'Cruise') OR (item_id = 1048 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010380744934082
(220) DESCRIBE `cruiselines` 0.001107931137085
(221) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00024795532226562
(222) DESCRIBE `orchid_image` 0.00084209442138672
(223) DESCRIBE `cruiselines` 0.00093603134155273
(224) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019598007202148
(225) DESCRIBE `cruises` 0.0012931823730469
(226) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56476') 0.00021505355834961
(227) DESCRIBE `ships` 0.0012431144714355
(228) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 439))) 0.0002748966217041
(229) DESCRIBE `ships` 0.0012390613555908
(230) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '439') 0.00018191337585449
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(232) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(233) DESCRIBE `itineraries` 0.00067591667175293
(234) DESCRIBE `ports` 0.0007469654083252
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00021100044250488
(236) DESCRIBE `ports` 0.00065994262695312
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0002281665802002
(238) DESCRIBE `ports` 0.00071597099304199
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00017786026000977
(240) DESCRIBE `sailingdates` 0.00059223175048828
(241) DESCRIBE `ports` 0.00086188316345215
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00022721290588379
(243) DESCRIBE `ports` 0.0006709098815918
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00019097328186035
(245) DESCRIBE `ports` 0.00067615509033203
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020313262939453
(247) DESCRIBE `ports` 0.00066399574279785
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018191337585449
(249) DESCRIBE `ports` 0.00065803527832031
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2298))) 0.00019407272338867
(251) DESCRIBE `ports` 0.0006868839263916
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2298') 0.00017595291137695
(253) DESCRIBE `ports` 0.00066781044006348
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00022387504577637
(255) DESCRIBE `ports` 0.00074291229248047
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00018310546875
(257) DESCRIBE `avid_specials` 0.00067019462585449
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56476 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.0009620189666748
(259) DESCRIBE `cruiselines` 0.00098180770874023
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00024604797363281
(261) DESCRIBE `orchid_image` 0.00079679489135742
(262) DESCRIBE `cruiselines` 0.00092101097106934
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00018811225891113
(264) DESCRIBE `cruises` 0.0012481212615967
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56639') 0.00021696090698242
(266) DESCRIBE `ships` 0.0013091564178467
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 9))) 0.00026798248291016
(268) DESCRIBE `ships` 0.0015270709991455
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '9') 0.00025701522827148
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(272) DESCRIBE `itineraries` 0.00071406364440918
(273) DESCRIBE `ports` 0.00067877769470215
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00025081634521484
(275) DESCRIBE `ports` 0.0007469654083252
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00020003318786621
(277) DESCRIBE `ports` 0.00066494941711426
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00018596649169922
(279) DESCRIBE `sailingdates` 0.00060200691223145
(280) DESCRIBE `ports` 0.00069785118103027
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00020599365234375
(282) DESCRIBE `ports` 0.00069212913513184
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00018692016601562
(284) DESCRIBE `ports` 0.00070405006408691
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00020098686218262
(286) DESCRIBE `ports` 0.00066304206848145
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00018119812011719
(288) DESCRIBE `ports` 0.00067996978759766
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0002140998840332
(290) DESCRIBE `ports` 0.00066900253295898
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018191337585449
(292) DESCRIBE `ports` 0.00066089630126953
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00020694732666016
(294) DESCRIBE `ports` 0.00069403648376465
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00018906593322754
(296) DESCRIBE `avid_specials` 0.00060105323791504
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56639 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.00096011161804199
(298) DESCRIBE `cruiselines` 0.00096702575683594
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00022196769714355
(300) DESCRIBE `orchid_image` 0.00074887275695801
(301) DESCRIBE `cruiselines` 0.00098299980163574
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00020098686218262
(303) DESCRIBE `cruises` 0.0012609958648682
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58528') 0.0002140998840332
(305) DESCRIBE `ships` 0.00130295753479
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 10))) 0.00026702880859375
(307) DESCRIBE `ships` 0.0014498233795166
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '10') 0.00020003318786621
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(311) DESCRIBE `itineraries` 0.00067400932312012
(312) DESCRIBE `ports` 0.00074005126953125
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.00021886825561523
(314) DESCRIBE `ports` 0.00066709518432617
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.0001981258392334
(316) DESCRIBE `ports` 0.0006721019744873
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2240') 0.00021219253540039
(318) DESCRIBE `sailingdates` 0.00060009956359863
(319) DESCRIBE `ports` 0.00090813636779785
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.00028896331787109
(321) DESCRIBE `ports` 0.00067806243896484
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2240') 0.00019502639770508
(323) DESCRIBE `ports` 0.00066781044006348
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0001990795135498
(325) DESCRIBE `ports` 0.00066304206848145
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00017690658569336
(327) DESCRIBE `ports` 0.00066089630126953
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020194053649902
(329) DESCRIBE `ports` 0.00072097778320312
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018095970153809
(331) DESCRIBE `ports` 0.00069618225097656
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2240))) 0.0001981258392334
(333) DESCRIBE `ports` 0.00066304206848145
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2240') 0.00018095970153809
(335) DESCRIBE `avid_specials` 0.00060701370239258
(336) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58528 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.0010180473327637
(337) DESCRIBE `cruiselines` 0.00097298622131348
(338) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00021696090698242
(339) DESCRIBE `orchid_image` 0.0007469654083252
(340) DESCRIBE `cruiselines` 0.00094199180603027
(341) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00018405914306641
(342) DESCRIBE `cruises` 0.0012519359588623
(343) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58948') 0.0001978874206543
(344) DESCRIBE `ships` 0.0012619495391846
(345) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1404))) 0.00025081634521484
(346) DESCRIBE `ships` 0.0012748241424561
(347) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1404') 0.00025105476379395
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023198127746582
(349) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021481513977051
(350) DESCRIBE `itineraries` 0.00074982643127441
(351) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58948') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053906440734863
(352) DESCRIBE `ports` 0.00070714950561523
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00022411346435547
(354) DESCRIBE `ports` 0.00070285797119141
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00020098686218262
(356) DESCRIBE `ports` 0.00066184997558594
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00018405914306641
(358) DESCRIBE `sailingdates` 0.00060009956359863
(359) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58948') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048494338989258
(360) DESCRIBE `ports` 0.00070095062255859
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00020480155944824
(362) DESCRIBE `ports` 0.00066804885864258
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00018501281738281
(364) DESCRIBE `ports` 0.00066900253295898
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00019979476928711
(366) DESCRIBE `ports` 0.00067806243896484
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.0001990795135498
(368) DESCRIBE `ports` 0.00066399574279785
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 659))) 0.00020790100097656
(370) DESCRIBE `ports` 0.00066494941711426
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '659') 0.00018191337585449
(372) DESCRIBE `ports` 0.00065994262695312
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2991))) 0.00020194053649902
(374) DESCRIBE `ports` 0.00066614151000977
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2991') 0.00018191337585449
(376) DESCRIBE `ports` 0.00066494941711426
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 660))) 0.00020194053649902
(378) DESCRIBE `ports` 0.00067710876464844
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '660') 0.00018095970153809
(380) DESCRIBE `ports` 0.00067996978759766
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00019979476928711
(382) DESCRIBE `ports` 0.00066208839416504
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00018000602722168
(384) DESCRIBE `ports` 0.00071096420288086
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.0001990795135498
(386) DESCRIBE `ports` 0.00066399574279785
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00018095970153809
(388) DESCRIBE `avid_specials` 0.00060200691223145
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58948 and class = 'Cruise') OR (item_id = 1404 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 49 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.0010080337524414
(390) DESCRIBE `cruiselines` 0.00096487998962402
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00021481513977051
(392) DESCRIBE `orchid_image` 0.00075292587280273
(393) DESCRIBE `cruiselines` 0.00098299980163574
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00040102005004883
(395) DESCRIBE `cruises` 0.0083248615264893
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63992') 0.00028491020202637
(397) DESCRIBE `ships` 0.0047760009765625
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) 0.00026106834411621
(399) DESCRIBE `ships` 0.0012450218200684
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') 0.00019001960754395
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(403) DESCRIBE `itineraries` 0.0006561279296875
(404) DESCRIBE `ports` 0.00068092346191406
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002131462097168
(406) DESCRIBE `ports` 0.00066781044006348
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020384788513184
(408) DESCRIBE `ports` 0.00068187713623047
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018477439880371
(410) DESCRIBE `sailingdates` 0.00060486793518066
(411) DESCRIBE `ports` 0.00082087516784668
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002140998840332
(413) DESCRIBE `ports` 0.00067901611328125
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018906593322754
(415) DESCRIBE `ports` 0.00066709518432617
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00022292137145996
(417) DESCRIBE `ports` 0.00067305564880371
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00018811225891113
(419) DESCRIBE `ports` 0.00066399574279785
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020885467529297
(421) DESCRIBE `ports` 0.00071907043457031
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018405914306641
(423) DESCRIBE `ports` 0.00068998336791992
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020003318786621
(425) DESCRIBE `ports` 0.00066590309143066
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018191337585449
(427) DESCRIBE `avid_specials` 0.00061297416687012
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63992 and class = 'Cruise') OR (item_id = 333 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.0009911060333252
(429) DESCRIBE `cruiselines` 0.0010700225830078
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0002291202545166
(431) DESCRIBE `orchid_image` 0.00078701972961426
(432) DESCRIBE `cruiselines` 0.00096797943115234
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00018882751464844
(434) DESCRIBE `cruises` 0.001255989074707
(435) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68344') 0.0002140998840332
(436) DESCRIBE `ships` 0.0012471675872803
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00026988983154297
(438) DESCRIBE `ships` 0.0012450218200684
(439) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00018405914306641
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001828670501709
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018191337585449
(442) DESCRIBE `itineraries` 0.00067806243896484
(443) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68344') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077509880065918
(444) DESCRIBE `ports` 0.00069904327392578
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00022387504577637
(446) DESCRIBE `ports` 0.0006721019744873
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00019979476928711
(448) DESCRIBE `ports` 0.00066709518432617
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018405914306641
(450) DESCRIBE `sailingdates` 0.00060200691223145
(451) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68344') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004727840423584
(452) DESCRIBE `ports` 0.0006859302520752
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020384788513184
(454) DESCRIBE `ports` 0.00066804885864258
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00020980834960938
(456) DESCRIBE `ports` 0.00066494941711426
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3294))) 0.00020790100097656
(458) DESCRIBE `ports` 0.00066804885864258
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3294') 0.00018095970153809
(460) DESCRIBE `ports` 0.00066709518432617
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00020194053649902
(462) DESCRIBE `ports` 0.00066590309143066
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.00018215179443359
(464) DESCRIBE `ports` 0.00066089630126953
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00020289421081543
(466) DESCRIBE `ports` 0.00069308280944824
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00018191337585449
(468) DESCRIBE `ports` 0.00069093704223633
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00020289421081543
(470) DESCRIBE `ports` 0.00066184997558594
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018692016601562
(472) DESCRIBE `ports` 0.00067806243896484
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0001990795135498
(474) DESCRIBE `ports` 0.00066685676574707
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018215179443359
(476) DESCRIBE `avid_specials` 0.00059986114501953
(477) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68344 and class = 'Cruise') OR (item_id = 385 AND class = 'Ship') OR (item_id = 88 AND class = 'CruiseLine') OR (item_id = 22 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.00098395347595215
(478) DESCRIBE `cruiselines` 0.0010321140289307
(479) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00022792816162109
(480) DESCRIBE `orchid_image` 0.0007481575012207
(481) DESCRIBE `cruiselines` 0.00092387199401855
(482) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00018596649169922
(483) DESCRIBE `cruiselines` 0.0010321140289307
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '96', '144', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '118', '24', '220', '114', '262', '204', '181', '187', '258', '256', '47', '36', '212', '30', '16', '151', '191', '14', '249', '153', '211', '195', '238', '141', '174', '216', '35', '239', '4', '213', '113', '159', '168', '196', '188', '146', '136', '90', '237', '209', '73', '170', '180', '59', '115', '225', '229', '140', '95', '219', '57', '108', '231', '269', '184', '52', '132', '248', '276', '88', '275', '38', '182', '261', '264', '244', '82', '230', '105', '116', '266', '39', '64', '48', '119', '240', '224', '245', '210', '134', '251')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,31,18,101,183,20,7,8,96,144,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,118,24,220,114,262,204,181,187,258,256,47,36,212,30,16,151,191,14,249,153,211,195,238,141,174,216,35,239,4,213,113,159,168,196,188,146,136,90,237,209,73,170,180,59,115,225,229,140,95,219,57,108,231,269,184,52,132,248,276,88,275,38,182,261,264,244,82,230,105,116,266,39,64,48,119,240,224,245,210,134,251') 0.0029008388519287
(485) DESCRIBE `ships` 0.0016939640045166
(486) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '22', '1424', '461', '1599', '28', '21', '817', '1422', '1594', '393', '1419', '1420', '1423', '1418', '1421', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '439', '1574', '9', '10', '207', '542', '1067', '1245', '585', '674', '770', '330', '404', '1272', '455', '974', '124', '1455', '1460', '792', '1215', '553', '797', '5', '739', '871', '116', '573', '1572', '25', '3', '520', '855', '1607', '14', '78', '711', '1193', '340', '434', '1021', '1302', '1402', '253', '1586', '390', '1284', '748', '1172', '43', '559', '580', '1581', '462', '765', '285', '791', '1320', '1323', '874', '658', '405', '1139', '590', '678', '286', '582', '883', '119', '327', '526', '731', '859', '970', '454', '854', '406', '81', '823', '610', '722', '850', '1236', '1027', '1569', '114', '993', '1348', '1319', '1415', '1614', '30', '31', '34', '35', '36', '37', '38', '82', '378', '403', '1008', '1012', '1326', '1327', '1678', '39', '160', '333', '547', '1330', '451', '1205', '1325', '163', '348', '351', '784', '966', '1454', '338', '657', '84', '262', '701', '1575', '325', '521', '683', '1143', '732', '287', '352', '1318', '4', '111', '508', '1088', '1108', '1151', '1157', '1471', '1579', '389', '1032', '1075', '1134', '1367', '290', '314', '751', '1214', '1233', '1308', '335', '1145', '1223', '1345', '93', '1013', '1321', '1405', '162', '1137', '1344', '1376', '291', '394', '483', '651', '673', '1144', '1343', '1587', '45', '852', '1604', '545', '988', '1149', '1452', '1453', '1615', '152', '401', '1025', '1090', '1095', '1136', '1283', '1724', '98', '441', '882', '968', '1168', '1243', '1373', '1413', '626', '716', '768', '1163', '1301', '1398', '59', '148', '149', '150', '769', '986', '1382', '1417', '1492', '1526', '75', '151', '639', '669', '905', '1150', '1176', '1226', '1292', '1448', '201', '1449', '324', '776', '973', '1647', '223', '417', '601', '616', '837', '996', '1241', '1458', '1552', '1602', '108', '313', '467', '1026', '1411', '266', '341', '857', '1231', '1489', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '74', '421', '666', '704', '851', '1055', '1152', '1362', '1368', '1372', '480', '885', '1230', '1260', '1384', '1516', '105', '147', '574', '888', '1383', '1408', '1470', '1628', '1717', '503', '790', '1054', '1154', '1208', '1224', '1518', '749', '1505', '1571', '208', '1672', '205', '332', '494', '652', '796', '884', '1253', '1501', '1521', '1611', '422', '618', '811', '818', '836', '985', '1148', '123', '493', '1068', '1486', '1517', '1522', '1632', '204', '212', '423', '937', '938', '1409', '1612', '1682', '448', '485', '1138', '1593', '1639', '994', '995', '1410', '66', '972', '1141', '375', '1017', '1303', '1461', '1539', '1627', '1064', '1601', '420', '1073', '1437', '1514', '1028', '1229', '1254', '1481', '1515', '1613', '1716', '453', '487', '665', '1259', '1412', '1684', '1175', '1189', '1262', '1619', '70', '717', '795', '958', '1159', '1713', '1715', '775', '1053', '1266', '1439', '1714', '715', '738', '1011', '1240', '1704', '1274', '1606', '69', '419', '1106', '1110', '1192', '1360', '1361', '1385', '1459', '944', '1183', '1184', '1347', '808', '1058', '1089', '1338', '1339', '1342', '1474', '1543', '1545', '1160', '1195', '1322', '1708', '62', '488', '798', '886', '1071', '1298', '1311', '1404', '1723', '225', '1158', '1310', '1645', '1649', '1697', '1729', '17', '299', '300', '997', '1043', '1087', '1132', '1355', '1358', '1451', '1629', '479', '672', '821', '1023', '1063', '1217', '1257', '1312', '1540', '288', '555', '692', '707', '1047', '1109', '1140', '1282', '1329', '1350', '1426', '1546')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,22,1424,461,1599,28,21,817,1422,1594,393,1419,1420,1423,1418,1421,1135,349,1359,452,780,113,766,265,24,11,439,1574,9,10,207,542,1067,1245,585,674,770,330,404,1272,455,974,124,1455,1460,792,1215,553,797,5,739,871,116,573,1572,25,3,520,855,1607,14,78,711,1193,340,434,1021,1302,1402,253,1586,390,1284,748,1172,43,559,580,1581,462,765,285,791,1320,1323,874,658,405,1139,590,678,286,582,883,119,327,526,731,859,970,454,854,406,81,823,610,722,850,1236,1027,1569,114,993,1348,1319,1415,1614,30,31,34,35,36,37,38,82,378,403,1008,1012,1326,1327,1678,39,160,333,547,1330,451,1205,1325,163,348,351,784,966,1454,338,657,84,262,701,1575,325,521,683,1143,732,287,352,1318,4,111,508,1088,1108,1151,1157,1471,1579,389,1032,1075,1134,1367,290,314,751,1214,1233,1308,335,1145,1223,1345,93,1013,1321,1405,162,1137,1344,1376,291,394,483,651,673,1144,1343,1587,45,852,1604,545,988,1149,1452,1453,1615,152,401,1025,1090,1095,1136,1283,1724,98,441,882,968,1168,1243,1373,1413,626,716,768,1163,1301,1398,59,148,149,150,769,986,1382,1417,1492,1526,75,151,639,669,905,1150,1176,1226,1292,1448,201,1449,324,776,973,1647,223,417,601,616,837,996,1241,1458,1552,1602,108,313,467,1026,1411,266,341,857,1231,1489,954,1029,1034,1285,1366,1496,1609,1711,74,421,666,704,851,1055,1152,1362,1368,1372,480,885,1230,1260,1384,1516,105,147,574,888,1383,1408,1470,1628,1717,503,790,1054,1154,1208,1224,1518,749,1505,1571,208,1672,205,332,494,652,796,884,1253,1501,1521,1611,422,618,811,818,836,985,1148,123,493,1068,1486,1517,1522,1632,204,212,423,937,938,1409,1612,1682,448,485,1138,1593,1639,994,995,1410,66,972,1141,375,1017,1303,1461,1539,1627,1064,1601,420,1073,1437,1514,1028,1229,1254,1481,1515,1613,1716,453,487,665,1259,1412,1684,1175,1189,1262,1619,70,717,795,958,1159,1713,1715,775,1053,1266,1439,1714,715,738,1011,1240,1704,1274,1606,69,419,1106,1110,1192,1360,1361,1385,1459,944,1183,1184,1347,808,1058,1089,1338,1339,1342,1474,1543,1545,1160,1195,1322,1708,62,488,798,886,1071,1298,1311,1404,1723,225,1158,1310,1645,1649,1697,1729,17,299,300,997,1043,1087,1132,1355,1358,1451,1629,479,672,821,1023,1063,1217,1257,1312,1540,288,555,692,707,1047,1109,1140,1282,1329,1350,1426,1546') 0.024696111679077
(487) DESCRIBE `cruisetypes` 0.0010058879852295
(488) DESCRIBE `destinations` 0.0010509490966797
(489) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '28', '26', '55', '11', '21', '38', '40', '49', '7', '44', '48', '30', '29', '10', '56', '45', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,28,26,55,11,21,38,40,49,7,44,48,30,29,10,56,45,34,52,46,32') 0.0010778903961182