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

Total elapsed time: 0.4467670917511

# Query Time
(1) connect 0.0006108283996582
(2) DESCRIBE `cruises` 0.002094030380249
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68822, 70412, 34185, 52327, 59121, 64318, 71285, 57674, 13510, 29119)) ORDER BY FIND_IN_SET(id, '68822,70412,34185,52327,59121,64318,71285,57674,13510,29119') 0.0014979839324951
(4) DESCRIBE `cruises` 0.0020148754119873
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68822') 0.00045299530029297
(6) DESCRIBE `ships` 0.0022330284118652
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1000))) 0.00052404403686523
(8) DESCRIBE `ships` 0.0018289089202881
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1000') 0.00049996376037598
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019693374633789
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017285346984863
(12) DESCRIBE `itineraries` 0.00096797943115234
(13) DESCRIBE `ports` 0.0012009143829346
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00036501884460449
(15) DESCRIBE `ports` 0.00093984603881836
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00026702880859375
(17) DESCRIBE `ports` 0.00086212158203125
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00025200843811035
(19) DESCRIBE `sailingdates` 0.00075387954711914
(20) DESCRIBE `ports` 0.00091695785522461
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00030994415283203
(22) DESCRIBE `ports` 0.00091981887817383
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00024890899658203
(24) DESCRIBE `ports` 0.00082898139953613
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00025701522827148
(26) DESCRIBE `ports` 0.00083684921264648
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00023198127746582
(28) DESCRIBE `ports` 0.00080490112304688
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3476))) 0.00025486946105957
(30) DESCRIBE `ports` 0.0008080005645752
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3476') 0.0002291202545166
(32) DESCRIBE `ports` 0.00080394744873047
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2138))) 0.00026106834411621
(34) DESCRIBE `ports` 0.00089097023010254
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2138') 0.00024104118347168
(36) DESCRIBE `ports` 0.0007789134979248
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3281))) 0.00023913383483887
(38) DESCRIBE `ports` 0.00078606605529785
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3281') 0.0002131462097168
(40) DESCRIBE `ports` 0.00099396705627441
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00027799606323242
(42) DESCRIBE `ports` 0.00094890594482422
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00024199485778809
(44) DESCRIBE `ports` 0.00089216232299805
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00026607513427734
(46) DESCRIBE `ports` 0.00098705291748047
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00024795532226562
(48) DESCRIBE `avid_specials` 0.00094103813171387
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68822 and class = 'Cruise') OR (item_id = 1000 AND class = 'Ship') OR (item_id = 141 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.0016500949859619
(50) DESCRIBE `cruiselines` 0.0015327930450439
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00037598609924316
(52) DESCRIBE `orchid_image` 0.0011398792266846
(53) DESCRIBE `cruiselines` 0.0014469623565674
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00030899047851562
(55) DESCRIBE `cruises` 0.0018699169158936
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70412') 0.00034999847412109
(57) DESCRIBE `ships` 0.0016918182373047
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1272))) 0.00040483474731445
(59) DESCRIBE `ships` 0.0019550323486328
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1272') 0.00032997131347656
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(63) DESCRIBE `itineraries` 0.00093984603881836
(64) DESCRIBE `ports` 0.0011820793151855
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034713745117188
(66) DESCRIBE `ports` 0.0010631084442139
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031900405883789
(68) DESCRIBE `ports` 0.0010409355163574
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003049373626709
(70) DESCRIBE `sailingdates` 0.00090599060058594
(71) DESCRIBE `ports` 0.0013527870178223
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043487548828125
(73) DESCRIBE `ports` 0.0010631084442139
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(75) DESCRIBE `ports` 0.00097799301147461
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00031185150146484
(77) DESCRIBE `ports` 0.0011978149414062
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00033807754516602
(79) DESCRIBE `ports` 0.0010440349578857
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00032687187194824
(81) DESCRIBE `ports` 0.00098109245300293
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026297569274902
(83) DESCRIBE `ports` 0.00087094306945801
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032687187194824
(85) DESCRIBE `ports` 0.00093889236450195
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025105476379395
(87) DESCRIBE `ports` 0.00088000297546387
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00027585029602051
(89) DESCRIBE `ports` 0.00093507766723633
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00024795532226562
(91) DESCRIBE `ports` 0.00092196464538574
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00028586387634277
(93) DESCRIBE `ports` 0.00090503692626953
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00025081634521484
(95) DESCRIBE `ports` 0.00094985961914062
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031208992004395
(97) DESCRIBE `ports` 0.00098705291748047
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026488304138184
(99) DESCRIBE `avid_specials` 0.00087904930114746
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70412 and class = 'Cruise') OR (item_id = 1272 AND class = 'Ship') OR (item_id = 12 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.0014829635620117
(101) DESCRIBE `cruiselines` 0.0017540454864502
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.0005800724029541
(103) DESCRIBE `orchid_image` 0.0013718605041504
(104) DESCRIBE `cruiselines` 0.0016019344329834
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00034594535827637
(106) DESCRIBE `cruises` 0.0019760131835938
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34185') 0.0003809928894043
(108) DESCRIBE `ships` 0.0017530918121338
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 38))) 0.00040411949157715
(110) DESCRIBE `ships` 0.0018939971923828
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '38') 0.00036311149597168
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025296211242676
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021100044250488
(114) DESCRIBE `itineraries` 0.0011649131774902
(115) DESCRIBE `ports` 0.0012409687042236
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00037384033203125
(117) DESCRIBE `ports` 0.0010910034179688
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00030207633972168
(119) DESCRIBE `ports` 0.00099396705627441
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00028204917907715
(121) DESCRIBE `sailingdates` 0.00095295906066895
(122) DESCRIBE `ports` 0.0012710094451904
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00038599967956543
(124) DESCRIBE `ports` 0.0011320114135742
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00036120414733887
(126) DESCRIBE `ports` 0.0011279582977295
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00038599967956543
(128) DESCRIBE `ports` 0.001021146774292
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00029611587524414
(130) DESCRIBE `ports` 0.0010430812835693
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0003199577331543
(132) DESCRIBE `ports` 0.0010659694671631
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00028014183044434
(134) DESCRIBE `ports` 0.00094103813171387
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00033688545227051
(136) DESCRIBE `ports` 0.0010437965393066
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00030088424682617
(138) DESCRIBE `ports` 0.00089406967163086
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00029706954956055
(140) DESCRIBE `ports` 0.00096297264099121
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.0002739429473877
(142) DESCRIBE `ports` 0.00099802017211914
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00028610229492188
(144) DESCRIBE `ports` 0.0010020732879639
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00026702880859375
(146) DESCRIBE `ports` 0.00089693069458008
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00028300285339355
(148) DESCRIBE `ports` 0.00089001655578613
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00026392936706543
(150) DESCRIBE `ports` 0.0010111331939697
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00037598609924316
(152) DESCRIBE `ports` 0.0011749267578125
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00035190582275391
(154) DESCRIBE `ports` 0.0012588500976562
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00043702125549316
(156) DESCRIBE `ports` 0.0011260509490967
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00028204917907715
(158) DESCRIBE `ports` 0.00093817710876465
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00028800964355469
(160) DESCRIBE `ports` 0.00089597702026367
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00027704238891602
(162) DESCRIBE `ports` 0.0010299682617188
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00033903121948242
(164) DESCRIBE `ports` 0.001025915145874
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00028300285339355
(166) DESCRIBE `avid_specials` 0.0009760856628418
(167) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34185 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.001716136932373
(168) DESCRIBE `cruiselines` 0.0015468597412109
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00034904479980469
(170) DESCRIBE `orchid_image` 0.0010659694671631
(171) DESCRIBE `cruiselines` 0.0013129711151123
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00032496452331543
(173) DESCRIBE `cruises` 0.0021958351135254
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52327') 0.00031805038452148
(175) DESCRIBE `ships` 0.0015220642089844
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568))) 0.00033092498779297
(177) DESCRIBE `ships` 0.0020668506622314
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568') 0.0003809928894043
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021600723266602
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020194053649902
(181) DESCRIBE `itineraries` 0.0011169910430908
(182) DESCRIBE `ports` 0.001054048538208
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00036096572875977
(184) DESCRIBE `ports` 0.0010409355163574
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00031590461730957
(186) DESCRIBE `ports` 0.0010590553283691
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00026416778564453
(188) DESCRIBE `sailingdates` 0.00081491470336914
(189) DESCRIBE `ports` 0.001190185546875
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0003359317779541
(191) DESCRIBE `ports` 0.0011799335479736
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00034117698669434
(193) DESCRIBE `ports` 0.0010409355163574
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00028491020202637
(195) DESCRIBE `ports` 0.00089097023010254
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00020384788513184
(197) DESCRIBE `avid_specials` 0.00082993507385254
(198) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52327 and class = 'Cruise') OR (item_id = 568 AND class = 'Ship') OR (item_id = 134 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.00093913078308105
(199) DESCRIBE `cruiselines` 0.0012178421020508
(200) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 134))) 0.0003199577331543
(201) DESCRIBE `orchid_image` 0.00089907646179199
(202) DESCRIBE `cruiselines` 0.0016119480133057
(203) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134') 0.00035905838012695
(204) DESCRIBE `cruises` 0.0021510124206543
(205) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59121') 0.00039482116699219
(206) DESCRIBE `ships` 0.0023269653320312
(207) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1405))) 0.00057697296142578
(208) DESCRIBE `ships` 0.0017988681793213
(209) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1405') 0.00029110908508301
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019216537475586
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016903877258301
(212) DESCRIBE `itineraries` 0.0010039806365967
(213) DESCRIBE `ports` 0.0012001991271973
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00031495094299316
(215) DESCRIBE `ports` 0.00089097023010254
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00026607513427734
(217) DESCRIBE `ports` 0.00085592269897461
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00024604797363281
(219) DESCRIBE `sailingdates` 0.00089716911315918
(220) DESCRIBE `ports` 0.0014331340789795
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00037813186645508
(222) DESCRIBE `ports` 0.0013668537139893
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00029110908508301
(224) DESCRIBE `ports` 0.0010249614715576
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00030016899108887
(226) DESCRIBE `ports` 0.0010251998901367
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00029683113098145
(228) DESCRIBE `ports` 0.0010209083557129
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00033307075500488
(230) DESCRIBE `ports` 0.00094103813171387
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00027084350585938
(232) DESCRIBE `ports` 0.00099301338195801
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00030398368835449
(234) DESCRIBE `ports` 0.00098991394042969
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00025391578674316
(236) DESCRIBE `ports` 0.00094294548034668
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00029301643371582
(238) DESCRIBE `ports` 0.0013089179992676
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00036215782165527
(240) DESCRIBE `ports` 0.0010850429534912
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00032401084899902
(242) DESCRIBE `ports` 0.00097203254699707
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00029802322387695
(244) DESCRIBE `ports` 0.00098109245300293
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00031185150146484
(246) DESCRIBE `ports` 0.00097107887268066
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00032210350036621
(248) DESCRIBE `ports` 0.00091409683227539
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00031208992004395
(250) DESCRIBE `ports` 0.00095295906066895
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00025486946105957
(252) DESCRIBE `ports` 0.00089597702026367
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00030398368835449
(254) DESCRIBE `ports` 0.0010261535644531
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00028300285339355
(256) DESCRIBE `ports` 0.00095295906066895
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00031590461730957
(258) DESCRIBE `ports` 0.00097990036010742
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00026392936706543
(260) DESCRIBE `ports` 0.00093507766723633
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00034093856811523
(262) DESCRIBE `ports` 0.00092196464538574
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00026202201843262
(264) DESCRIBE `avid_specials` 0.00096893310546875
(265) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59121 and class = 'Cruise') OR (item_id = 1405 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.0016450881958008
(266) DESCRIBE `cruiselines` 0.001507043838501
(267) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00036406517028809
(268) DESCRIBE `orchid_image` 0.0011999607086182
(269) DESCRIBE `cruiselines` 0.001615047454834
(270) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00038003921508789
(271) DESCRIBE `cruises` 0.0021920204162598
(272) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64318') 0.00033211708068848
(273) DESCRIBE `ships` 0.0019829273223877
(274) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 123))) 0.0004730224609375
(275) DESCRIBE `ships` 0.0020120143890381
(276) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '123') 0.00034904479980469
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021791458129883
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020313262939453
(279) DESCRIBE `itineraries` 0.0010430812835693
(280) DESCRIBE `ports` 0.00083804130554199
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00027990341186523
(282) DESCRIBE `ports` 0.00093293190002441
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00030303001403809
(284) DESCRIBE `ports` 0.0009911060333252
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00026702880859375
(286) DESCRIBE `sailingdates` 0.00081706047058105
(287) DESCRIBE `ports` 0.0010440349578857
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00030708312988281
(289) DESCRIBE `ports` 0.0010449886322021
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00029897689819336
(291) DESCRIBE `ports` 0.0010459423065186
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0003509521484375
(293) DESCRIBE `ports` 0.0012240409851074
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00031876564025879
(295) DESCRIBE `ports` 0.0011088848114014
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00038313865661621
(297) DESCRIBE `ports` 0.0010981559753418
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00040197372436523
(299) DESCRIBE `ports` 0.0010108947753906
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0003199577331543
(301) DESCRIBE `ports` 0.0010378360748291
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00028705596923828
(303) DESCRIBE `avid_specials` 0.00094294548034668
(304) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64318 and class = 'Cruise') OR (item_id = 123 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017168521881104
(305) DESCRIBE `cruiselines` 0.0015959739685059
(306) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00035405158996582
(307) DESCRIBE `orchid_image` 0.0011501312255859
(308) DESCRIBE `cruiselines` 0.0017631053924561
(309) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00033187866210938
(310) DESCRIBE `cruises` 0.0022079944610596
(311) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71285') 0.00041818618774414
(312) DESCRIBE `ships` 0.0020809173583984
(313) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00047206878662109
(314) DESCRIBE `ships` 0.0021951198577881
(315) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.0003809928894043
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021910667419434
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020909309387207
(318) DESCRIBE `itineraries` 0.0013191699981689
(319) DESCRIBE `ports` 0.0011920928955078
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033020973205566
(321) DESCRIBE `ports` 0.0010349750518799
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034117698669434
(323) DESCRIBE `ports` 0.0010478496551514
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026988983154297
(325) DESCRIBE `sailingdates` 0.00086808204650879
(326) DESCRIBE `ports` 0.0011470317840576
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034213066101074
(328) DESCRIBE `ports` 0.0010750293731689
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030088424682617
(330) DESCRIBE `ports` 0.00098896026611328
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00034904479980469
(332) DESCRIBE `ports` 0.0011360645294189
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00031781196594238
(334) DESCRIBE `ports` 0.0010340213775635
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(336) DESCRIBE `ports` 0.0010600090026855
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027799606323242
(338) DESCRIBE `ports` 0.001072883605957
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036406517028809
(340) DESCRIBE `ports` 0.0010309219360352
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029516220092773
(342) DESCRIBE `avid_specials` 0.00096893310546875
(343) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71285 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014810562133789
(344) DESCRIBE `cruiselines` 0.0015549659729004
(345) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00034308433532715
(346) DESCRIBE `orchid_image` 0.0011429786682129
(347) DESCRIBE `cruiselines` 0.0013558864593506
(348) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00032305717468262
(349) DESCRIBE `cruises` 0.01298189163208
(350) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57674') 0.0003969669342041
(351) DESCRIBE `ships` 0.0020949840545654
(352) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00051712989807129
(353) DESCRIBE `ships` 0.0023250579833984
(354) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00038790702819824
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021004676818848
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019502639770508
(357) DESCRIBE `itineraries` 0.0011310577392578
(358) DESCRIBE `ports` 0.0011909008026123
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00031805038452148
(360) DESCRIBE `ports` 0.00093913078308105
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00040197372436523
(362) DESCRIBE `ports` 0.0010471343994141
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00028705596923828
(364) DESCRIBE `sailingdates` 0.0008690357208252
(365) DESCRIBE `ports` 0.0012719631195068
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00037622451782227
(367) DESCRIBE `ports` 0.0010020732879639
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00027012825012207
(369) DESCRIBE `ports` 0.00089097023010254
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00029611587524414
(371) DESCRIBE `ports` 0.00093603134155273
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00026583671569824
(373) DESCRIBE `ports` 0.0010330677032471
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00028896331787109
(375) DESCRIBE `ports` 0.0010180473327637
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00028085708618164
(377) DESCRIBE `ports` 0.00094485282897949
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00027799606323242
(379) DESCRIBE `ports` 0.0009608268737793
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00032186508178711
(381) DESCRIBE `ports` 0.00096702575683594
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028800964355469
(383) DESCRIBE `ports` 0.00092816352844238
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028300285339355
(385) DESCRIBE `ports` 0.0009148120880127
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00028705596923828
(387) DESCRIBE `ports` 0.00092887878417969
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00027608871459961
(389) DESCRIBE `avid_specials` 0.00087904930114746
(390) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0015480518341064
(391) DESCRIBE `cruiselines` 0.0014200210571289
(392) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00039887428283691
(393) DESCRIBE `orchid_image` 0.0011191368103027
(394) DESCRIBE `cruiselines` 0.0014729499816895
(395) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00028610229492188
(396) DESCRIBE `cruises` 0.0020949840545654
(397) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '13510') 0.00036716461181641
(398) DESCRIBE `ships` 0.0020081996917725
(399) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.00049901008605957
(400) DESCRIBE `ships` 0.0021271705627441
(401) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00036907196044922
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020790100097656
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019502639770508
(404) DESCRIBE `itineraries` 0.0010559558868408
(405) DESCRIBE `ports` 0.001209020614624
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00034499168395996
(407) DESCRIBE `ports` 0.0010061264038086
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00026297569274902
(409) DESCRIBE `ports` 0.00095582008361816
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00030112266540527
(411) DESCRIBE `sailingdates` 0.00092601776123047
(412) DESCRIBE `ports` 0.001356840133667
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00049901008605957
(414) DESCRIBE `ports` 0.001115083694458
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00024294853210449
(416) DESCRIBE `ports` 0.0008399486541748
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00025010108947754
(418) DESCRIBE `ports` 0.00084304809570312
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00021696090698242
(420) DESCRIBE `ports` 0.00081586837768555
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00026297569274902
(422) DESCRIBE `ports` 0.0008690357208252
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.0002288818359375
(424) DESCRIBE `ports` 0.0008242130279541
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00038599967956543
(426) DESCRIBE `ports` 0.0012631416320801
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00031399726867676
(428) DESCRIBE `ports` 0.0010271072387695
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00030899047851562
(430) DESCRIBE `ports` 0.0010478496551514
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00030279159545898
(432) DESCRIBE `ports` 0.0010790824890137
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00049901008605957
(434) DESCRIBE `ports` 0.0011491775512695
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00031805038452148
(436) DESCRIBE `ports` 0.0011069774627686
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00032210350036621
(438) DESCRIBE `ports` 0.0010900497436523
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00029802322387695
(440) DESCRIBE `ports` 0.0010170936584473
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00039887428283691
(442) DESCRIBE `ports` 0.0011470317840576
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00032401084899902
(444) DESCRIBE `avid_specials` 0.0010631084442139
(445) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 13510 and class = 'Cruise') OR (item_id = 14 AND class = 'Ship') OR (item_id = 35 AND class = 'CruiseLine') OR (item_id = 46 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.0016391277313232
(446) DESCRIBE `cruiselines` 0.0016970634460449
(447) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.0004270076751709
(448) DESCRIBE `orchid_image` 0.0012822151184082
(449) DESCRIBE `cruiselines` 0.0015730857849121
(450) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.0003511905670166
(451) DESCRIBE `cruises` 0.0023138523101807
(452) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '29119') 0.00043797492980957
(453) DESCRIBE `ships` 0.0020179748535156
(454) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 837))) 0.00044918060302734
(455) DESCRIBE `ships` 0.0019969940185547
(456) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0.00034785270690918
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(459) DESCRIBE `itineraries` 0.0010571479797363
(460) DESCRIBE `ports` 0.0011441707611084
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033807754516602
(462) DESCRIBE `ports` 0.00099587440490723
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00032997131347656
(464) DESCRIBE `ports` 0.0011758804321289
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00037908554077148
(466) DESCRIBE `sailingdates` 0.00091195106506348
(467) DESCRIBE `ports` 0.0013160705566406
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00034689903259277
(469) DESCRIBE `ports` 0.0010571479797363
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00030398368835449
(471) DESCRIBE `ports` 0.0010230541229248
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00051093101501465
(473) DESCRIBE `ports` 0.0011498928070068
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0003511905670166
(475) DESCRIBE `ports` 0.0010738372802734
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00033092498779297
(477) DESCRIBE `ports` 0.00096011161804199
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00025796890258789
(479) DESCRIBE `ports` 0.00095200538635254
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00027608871459961
(481) DESCRIBE `ports` 0.00082182884216309
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0002448558807373
(483) DESCRIBE `avid_specials` 0.00081110000610352
(484) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 29119 and class = 'Cruise') OR (item_id = 837 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014820098876953
(485) DESCRIBE `cruiselines` 0.0013659000396729
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00037598609924316
(487) DESCRIBE `orchid_image` 0.0010700225830078
(488) DESCRIBE `cruiselines` 0.0069839954376221
(489) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00042510032653809
(490) DESCRIBE `cruiselines` 0.0017099380493164
(491) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '101', '120', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '229', '140', '170', '225', '275', '59', '108', '115', '113', '180', '73', '269', '264', '188', '240', '88', '219', '276', '57', '52', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '224', '245', '177', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,101,120,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,229,140,170,225,275,59,108,115,113,180,73,269,264,188,240,88,219,276,57,52,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,224,245,177,257,210,223,263,251') 0.0044841766357422
(492) DESCRIBE `ships` 0.0022480487823486
(493) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '10', '349', '974', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '817', '520', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '31', '573', '1285', '1586', '30', '36', '38', '39', '378', '434', '590', '792', '34', '35', '37', '1012', '327', '526', '970', '43', '1376', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1382', '1405', '338', '716', '1088', '1176', '1292', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '1575', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '253', '857', '1149', '1236', '111', '285', '852', '966', '1095', '1284', '59', '93', '403', '451', '610', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '75', '616', '666', '784', '1150', '1301', '1501', '9', '823', '996', '1587', '81', '455', '503', '776', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1366', '1372', '1411', '1571', '108', '313', '790', '1141', '1241', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '883', '1253', '74', '98', '147', '394', '937', '1579', '1172', '1454', '335', '938', '994', '1087', '66', '70', '341', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1439', '715', '973', '1023', '1043', '1144', '1262', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1481', '1543', '1594', '448', '717', '1090', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1110', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811', '858', '888')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,10,349,974,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,817,520,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,31,573,1285,1586,30,36,38,39,378,434,590,792,34,35,37,1012,327,526,970,43,1376,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1382,1405,338,716,1088,1176,1292,1417,1569,1639,993,1455,314,678,722,837,1233,1575,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,253,857,1149,1236,111,285,852,966,1095,1284,59,93,403,451,610,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,75,616,666,784,1150,1301,1501,9,823,996,1587,81,455,503,776,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1366,1372,1411,1571,108,313,790,1141,1241,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,883,1253,74,98,147,394,937,1579,1172,1454,335,938,994,1087,66,70,341,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1439,715,973,1023,1043,1144,1262,1545,494,673,1136,1137,1240,1282,1303,1437,1481,1543,1594,448,717,1090,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1110,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,915,916,926,1001,1072,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811,858,888') 0.031686067581177
(494) DESCRIBE `cruisetypes` 0.0015139579772949
(495) DESCRIBE `destinations` 0.0027139186859131
(496) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.0016269683837891