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

Total elapsed time: 0.48863410949707

# Query Time
(1) connect 0.0010459423065186
(2) DESCRIBE `cruises` 0.0021040439605713
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68830, 71463, 74522, 52647, 56886, 59167, 71194, 71283, 59297, 61130)) ORDER BY FIND_IN_SET(id, '68830,71463,74522,52647,56886,59167,71194,71283,59297,61130') 0.0018310546875
(4) DESCRIBE `cruises` 0.0023207664489746
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68830') 0.00036191940307617
(6) DESCRIBE `ships` 0.0018610954284668
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00037384033203125
(8) DESCRIBE `ships` 0.0020289421081543
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00026106834411621
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018692016601562
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(12) DESCRIBE `itineraries` 0.00084209442138672
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68830') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068092346191406
(14) DESCRIBE `ports` 0.0013279914855957
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00034785270690918
(16) DESCRIBE `ports` 0.0010600090026855
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030803680419922
(18) DESCRIBE `ports` 0.0010421276092529
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026488304138184
(20) DESCRIBE `sailingdates` 0.00083303451538086
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68830') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057601928710938
(22) DESCRIBE `ports` 0.0013298988342285
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00034713745117188
(24) DESCRIBE `ports` 0.00098299980163574
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026106834411621
(26) DESCRIBE `ports` 0.00093197822570801
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002739429473877
(28) DESCRIBE `ports` 0.00098013877868652
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00030803680419922
(30) DESCRIBE `ports` 0.00096893310546875
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00032401084899902
(32) DESCRIBE `ports` 0.00118088722229
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00031805038452148
(34) DESCRIBE `ports` 0.0010271072387695
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1350))) 0.00030088424682617
(36) DESCRIBE `ports` 0.0010571479797363
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1350') 0.00028800964355469
(38) DESCRIBE `ports` 0.00096392631530762
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031304359436035
(40) DESCRIBE `ports` 0.0009160041809082
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00023102760314941
(42) DESCRIBE `avid_specials` 0.00088095664978027
(43) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68830 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.0016679763793945
(44) DESCRIBE `cruiselines` 0.0014369487762451
(45) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00039792060852051
(46) DESCRIBE `orchid_image` 0.0011019706726074
(47) DESCRIBE `cruiselines` 0.0013689994812012
(48) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00028800964355469
(49) DESCRIBE `cruises` 0.0023059844970703
(50) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71463') 0.00035691261291504
(51) DESCRIBE `ships` 0.0019848346710205
(52) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1141))) 0.00037217140197754
(53) DESCRIBE `ships` 0.0023601055145264
(54) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1141') 0.00037121772766113
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024580955505371
(56) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(57) DESCRIBE `itineraries` 0.00097322463989258
(58) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71463') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052809715270996
(59) DESCRIBE `ports` 0.00082993507385254
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00025486946105957
(61) DESCRIBE `ports` 0.0010180473327637
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00032496452331543
(63) DESCRIBE `ports` 0.00099778175354004
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00022292137145996
(65) DESCRIBE `sailingdates` 0.0007481575012207
(66) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71463') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068497657775879
(67) DESCRIBE `ports` 0.0011489391326904
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00029492378234863
(69) DESCRIBE `ports` 0.00086808204650879
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.0002439022064209
(71) DESCRIBE `ports` 0.00090289115905762
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.0002589225769043
(73) DESCRIBE `ports` 0.00086498260498047
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00023198127746582
(75) DESCRIBE `ports` 0.00087618827819824
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00024580955505371
(77) DESCRIBE `ports` 0.00087285041809082
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00025701522827148
(79) DESCRIBE `avid_specials` 0.00086092948913574
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71463 and class = 'Cruise') OR (item_id = 1141 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014641284942627
(81) DESCRIBE `cruiselines` 0.0013589859008789
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00028896331787109
(83) DESCRIBE `orchid_image` 0.00096607208251953
(84) DESCRIBE `cruiselines` 0.0012059211730957
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00025796890258789
(86) DESCRIBE `cruises` 0.0018200874328613
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74522') 0.0003199577331543
(88) DESCRIBE `ships` 0.0019948482513428
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 555))) 0.00042390823364258
(90) DESCRIBE `ships` 0.0020029544830322
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '555') 0.00032305717468262
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002138614654541
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020217895507812
(94) DESCRIBE `itineraries` 0.0010011196136475
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74522') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062108039855957
(96) DESCRIBE `ports` 0.00092601776123047
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00035405158996582
(98) DESCRIBE `ports` 0.00089812278747559
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00028896331787109
(100) DESCRIBE `ports` 0.00085711479187012
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00025296211242676
(102) DESCRIBE `sailingdates` 0.00073981285095215
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74522') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070500373840332
(104) DESCRIBE `ports` 0.0011849403381348
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00032210350036621
(106) DESCRIBE `ports` 0.00074911117553711
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00022602081298828
(108) DESCRIBE `ports` 0.00088381767272949
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5423))) 0.00028491020202637
(110) DESCRIBE `ports` 0.00075912475585938
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5423') 0.000244140625
(112) DESCRIBE `ports` 0.00085592269897461
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0002589225769043
(114) DESCRIBE `ports` 0.00089621543884277
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00022101402282715
(116) DESCRIBE `ports` 0.00077104568481445
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00023508071899414
(118) DESCRIBE `ports` 0.00084519386291504
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00024795532226562
(120) DESCRIBE `ports` 0.00093722343444824
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00026607513427734
(122) DESCRIBE `ports` 0.00083494186401367
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00023579597473145
(124) DESCRIBE `avid_specials` 0.00078392028808594
(125) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74522 and class = 'Cruise') OR (item_id = 555 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001450777053833
(126) DESCRIBE `cruiselines` 0.0013828277587891
(127) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00031089782714844
(128) DESCRIBE `orchid_image` 0.0010459423065186
(129) DESCRIBE `cruiselines` 0.0015060901641846
(130) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00029683113098145
(131) DESCRIBE `cruises` 0.0021059513092041
(132) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52647') 0.00032997131347656
(133) DESCRIBE `ships` 0.0019450187683105
(134) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 21))) 0.00041508674621582
(135) DESCRIBE `ships` 0.0020530223846436
(136) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '21') 0.00031590461730957
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002129077911377
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(139) DESCRIBE `itineraries` 0.001021146774292
(140) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '52647') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064396858215332
(141) DESCRIBE `ports` 0.0014290809631348
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033712387084961
(143) DESCRIBE `ports` 0.0009307861328125
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00034189224243164
(145) DESCRIBE `ports` 0.0010340213775635
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00027298927307129
(147) DESCRIBE `sailingdates` 0.00081300735473633
(148) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '52647') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0020689964294434
(149) DESCRIBE `ports` 0.0013837814331055
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0003359317779541
(151) DESCRIBE `ports` 0.0012550354003906
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034904479980469
(153) DESCRIBE `ports` 0.00090694427490234
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00022196769714355
(155) DESCRIBE `ports` 0.0007319450378418
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00027298927307129
(157) DESCRIBE `ports` 0.00081706047058105
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00028514862060547
(159) DESCRIBE `ports` 0.00098109245300293
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00019502639770508
(161) DESCRIBE `avid_specials` 0.00059008598327637
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52647 and class = 'Cruise') OR (item_id = 21 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0013899803161621
(163) DESCRIBE `cruiselines` 0.0011358261108398
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00038981437683105
(165) DESCRIBE `orchid_image` 0.00087499618530273
(166) DESCRIBE `cruiselines` 0.0012919902801514
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00024795532226562
(168) DESCRIBE `cruises` 0.0022149085998535
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56886') 0.00030899047851562
(170) DESCRIBE `ships` 0.001882791519165
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 461))) 0.00043702125549316
(172) DESCRIBE `ships` 0.0020239353179932
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '461') 0.00035810470581055
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022006034851074
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(176) DESCRIBE `itineraries` 0.0011398792266846
(177) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56886') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00073885917663574
(178) DESCRIBE `ports` 0.001230001449585
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00032186508178711
(180) DESCRIBE `ports` 0.0010089874267578
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00028204917907715
(182) DESCRIBE `ports` 0.00098609924316406
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00024604797363281
(184) DESCRIBE `sailingdates` 0.00079584121704102
(185) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56886') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011279582977295
(186) DESCRIBE `ports` 0.0011889934539795
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00032496452331543
(188) DESCRIBE `ports` 0.00096297264099121
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0002598762512207
(190) DESCRIBE `ports` 0.00084185600280762
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00028800964355469
(192) DESCRIBE `ports` 0.00086116790771484
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00023579597473145
(194) DESCRIBE `ports` 0.0007169246673584
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00025200843811035
(196) DESCRIBE `ports` 0.00091409683227539
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00022101402282715
(198) DESCRIBE `avid_specials` 0.00087404251098633
(199) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56886 and class = 'Cruise') OR (item_id = 461 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.0014898777008057
(200) DESCRIBE `cruiselines` 0.0013258457183838
(201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00032210350036621
(202) DESCRIBE `orchid_image` 0.001093864440918
(203) DESCRIBE `cruiselines` 0.0011491775512695
(204) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00025701522827148
(205) DESCRIBE `cruises` 0.0018150806427002
(206) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59167') 0.00042200088500977
(207) DESCRIBE `ships` 0.0014388561248779
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 480))) 0.0003659725189209
(209) DESCRIBE `ships` 0.0017480850219727
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '480') 0.00027894973754883
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019502639770508
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020098686218262
(213) DESCRIBE `itineraries` 0.00093698501586914
(214) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59167') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059986114501953
(215) DESCRIBE `ports` 0.0009150505065918
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00026488304138184
(217) DESCRIBE `ports` 0.00083708763122559
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00023603439331055
(219) DESCRIBE `ports` 0.00086879730224609
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00022101402282715
(221) DESCRIBE `sailingdates` 0.00074195861816406
(222) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59167') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001007080078125
(223) DESCRIBE `ports` 0.0012741088867188
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00037598609924316
(225) DESCRIBE `ports` 0.0010578632354736
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00023293495178223
(227) DESCRIBE `ports` 0.00077199935913086
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0002138614654541
(229) DESCRIBE `ports` 0.0009310245513916
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00023007392883301
(231) DESCRIBE `ports` 0.00083494186401367
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00024700164794922
(233) DESCRIBE `ports` 0.00088977813720703
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00022196769714355
(235) DESCRIBE `ports` 0.00078201293945312
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00020194053649902
(237) DESCRIBE `ports` 0.00089812278747559
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.0002140998840332
(239) DESCRIBE `avid_specials` 0.00079202651977539
(240) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59167 and class = 'Cruise') OR (item_id = 480 AND class = 'Ship') OR (item_id = 108 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.0014989376068115
(241) DESCRIBE `cruiselines` 0.00118088722229
(242) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 108))) 0.00026488304138184
(243) DESCRIBE `orchid_image` 0.00093603134155273
(244) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '108') 0.043722867965698
(245) DESCRIBE `cruiselines` 0.00164794921875
(246) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '108') 0.00031304359436035
(247) DESCRIBE `cruises` 0.0021059513092041
(248) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71194') 0.00036501884460449
(249) DESCRIBE `ships` 0.0024988651275635
(250) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503))) 0.00054717063903809
(251) DESCRIBE `ships` 0.0021259784698486
(252) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '503') 0.00037908554077148
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002138614654541
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020313262939453
(255) DESCRIBE `itineraries` 0.0010268688201904
(256) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71194') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065016746520996
(257) DESCRIBE `ports` 0.0010299682617188
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5444))) 0.00026583671569824
(259) DESCRIBE `ports` 0.00079178810119629
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5444))) 0.00027799606323242
(261) DESCRIBE `ports` 0.00087809562683105
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5444') 0.0002140998840332
(263) DESCRIBE `sailingdates` 0.00061988830566406
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71194') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052595138549805
(265) DESCRIBE `ports` 0.00082612037658691
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5444))) 0.0002291202545166
(267) DESCRIBE `ports` 0.0006718635559082
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5444') 0.0002140998840332
(269) DESCRIBE `ports` 0.00066804885864258
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00027298927307129
(271) DESCRIBE `ports` 0.00084996223449707
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00021004676818848
(273) DESCRIBE `ports` 0.00065803527832031
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00027894973754883
(275) DESCRIBE `ports` 0.00071811676025391
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00024008750915527
(277) DESCRIBE `avid_specials` 0.00071001052856445
(278) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71194 and class = 'Cruise') OR (item_id = 503 AND class = 'Ship') OR (item_id = 115 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.0014829635620117
(279) DESCRIBE `cruiselines` 0.0013210773468018
(280) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115))) 0.00032496452331543
(281) DESCRIBE `orchid_image` 0.00095987319946289
(282) DESCRIBE `cruiselines` 0.001168966293335
(283) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115') 0.00025701522827148
(284) DESCRIBE `cruises` 0.0018658638000488
(285) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71283') 0.00032496452331543
(286) DESCRIBE `ships` 0.0024800300598145
(287) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.00051093101501465
(288) DESCRIBE `ships` 0.0021169185638428
(289) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.00041007995605469
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002138614654541
(291) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019693374633789
(292) DESCRIBE `itineraries` 0.0010130405426025
(293) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71283') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067996978759766
(294) DESCRIBE `ports` 0.0010449886322021
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030899047851562
(296) DESCRIBE `ports` 0.00093793869018555
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00026607513427734
(298) DESCRIBE `ports` 0.00091195106506348
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00024795532226562
(300) DESCRIBE `sailingdates` 0.00081491470336914
(301) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71283') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063395500183105
(302) DESCRIBE `ports` 0.00079894065856934
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021600723266602
(304) DESCRIBE `ports` 0.00060796737670898
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018501281738281
(306) DESCRIBE `ports` 0.00083708763122559
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026392936706543
(308) DESCRIBE `ports` 0.00092482566833496
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025796890258789
(310) DESCRIBE `avid_specials` 0.00071001052856445
(311) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71283 and class = 'Cruise') OR (item_id = 258 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.00088095664978027
(312) DESCRIBE `cruiselines` 0.0011630058288574
(313) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00035214424133301
(314) DESCRIBE `orchid_image` 0.00096392631530762
(315) DESCRIBE `cruiselines` 0.0012249946594238
(316) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00025105476379395
(317) DESCRIBE `cruises` 0.0015439987182617
(318) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59297') 0.00037598609924316
(319) DESCRIBE `ships` 0.0013699531555176
(320) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1414))) 0.00026488304138184
(321) DESCRIBE `ships` 0.0015609264373779
(322) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1414') 0.00025010108947754
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021505355834961
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020503997802734
(325) DESCRIBE `itineraries` 0.0010190010070801
(326) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59297') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063800811767578
(327) DESCRIBE `ports` 0.00078296661376953
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00030016899108887
(329) DESCRIBE `ports` 0.00080585479736328
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00027918815612793
(331) DESCRIBE `ports` 0.00087308883666992
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00025701522827148
(333) DESCRIBE `sailingdates` 0.00077509880065918
(334) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59297') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049209594726562
(335) DESCRIBE `ports` 0.0010120868682861
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0003352165222168
(337) DESCRIBE `ports` 0.00094103813171387
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00029110908508301
(339) DESCRIBE `ports` 0.0009160041809082
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00027108192443848
(341) DESCRIBE `ports` 0.00084710121154785
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00023984909057617
(343) DESCRIBE `ports` 0.00091290473937988
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00032210350036621
(345) DESCRIBE `ports` 0.00092697143554688
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00026607513427734
(347) DESCRIBE `avid_specials` 0.00074601173400879
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59297 and class = 'Cruise') OR (item_id = 1414 AND class = 'Ship') OR (item_id = 240 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.0015180110931396
(349) DESCRIBE `cruiselines` 0.0011870861053467
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 240))) 0.00026488304138184
(351) DESCRIBE `orchid_image` 0.0011000633239746
(352) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '240') 0.037316083908081
(353) DESCRIBE `cruiselines` 0.0015938282012939
(354) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '240') 0.0002739429473877
(355) DESCRIBE `cruises` 0.0016729831695557
(356) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61130') 0.00043606758117676
(357) DESCRIBE `ships` 0.0014569759368896
(358) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00031685829162598
(359) DESCRIBE `ships` 0.0012590885162354
(360) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00025200843811035
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019598007202148
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002131462097168
(363) DESCRIBE `itineraries` 0.00084686279296875
(364) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61130') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089788436889648
(365) DESCRIBE `ports` 0.0012621879577637
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002899169921875
(367) DESCRIBE `ports` 0.00089693069458008
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00019598007202148
(369) DESCRIBE `ports` 0.00071597099304199
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00020217895507812
(371) DESCRIBE `sailingdates` 0.00067281723022461
(372) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61130') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00065302848815918
(373) DESCRIBE `ports` 0.001101016998291
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002448558807373
(375) DESCRIBE `ports` 0.00092196464538574
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00025582313537598
(377) DESCRIBE `ports` 0.00089311599731445
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00022506713867188
(379) DESCRIBE `ports` 0.00067019462585449
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00019097328186035
(381) DESCRIBE `ports` 0.00063300132751465
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019502639770508
(383) DESCRIBE `ports` 0.00063490867614746
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017595291137695
(385) DESCRIBE `ports` 0.00061202049255371
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020694732666016
(387) DESCRIBE `ports` 0.00071406364440918
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022006034851074
(389) DESCRIBE `ports` 0.00072503089904785
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00019693374633789
(391) DESCRIBE `ports` 0.00073790550231934
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.0002448558807373
(393) DESCRIBE `ports` 0.00074195861816406
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00028586387634277
(395) DESCRIBE `ports` 0.00098681449890137
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002589225769043
(397) DESCRIBE `ports` 0.0009758472442627
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00026488304138184
(399) DESCRIBE `ports` 0.00093698501586914
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00025510787963867
(401) DESCRIBE `ports` 0.001168966293335
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00041413307189941
(403) DESCRIBE `ports` 0.0011169910430908
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00028204917907715
(405) DESCRIBE `ports` 0.001007080078125
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00030398368835449
(407) DESCRIBE `ports` 0.0010309219360352
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00034308433532715
(409) DESCRIBE `ports` 0.0010190010070801
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00028586387634277
(411) DESCRIBE `ports` 0.001060962677002
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00029993057250977
(413) DESCRIBE `ports` 0.0010139942169189
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00030708312988281
(415) DESCRIBE `ports` 0.0010149478912354
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00025200843811035
(417) DESCRIBE `ports` 0.00092005729675293
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00029611587524414
(419) DESCRIBE `ports` 0.00098109245300293
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.00028896331787109
(421) DESCRIBE `ports` 0.0010130405426025
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00032401084899902
(423) DESCRIBE `ports` 0.00099802017211914
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00024819374084473
(425) DESCRIBE `ports` 0.00098490715026855
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00030207633972168
(427) DESCRIBE `ports` 0.00096011161804199
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00026297569274902
(429) DESCRIBE `ports` 0.00095510482788086
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00027680397033691
(431) DESCRIBE `ports` 0.00090503692626953
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00030112266540527
(433) DESCRIBE `ports` 0.0009758472442627
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0002899169921875
(435) DESCRIBE `ports` 0.0010039806365967
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00024199485778809
(437) DESCRIBE `ports` 0.00097203254699707
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00031208992004395
(439) DESCRIBE `ports` 0.0010089874267578
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00023984909057617
(441) DESCRIBE `ports` 0.00091409683227539
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00028705596923828
(443) DESCRIBE `ports` 0.00098013877868652
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0002739429473877
(445) DESCRIBE `ports` 0.00098800659179688
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00030994415283203
(447) DESCRIBE `ports` 0.0009911060333252
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00028109550476074
(449) DESCRIBE `ports` 0.0010020732879639
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00030207633972168
(451) DESCRIBE `ports` 0.00098586082458496
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00029802322387695
(453) DESCRIBE `ports` 0.0011248588562012
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0003209114074707
(455) DESCRIBE `ports` 0.00094413757324219
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00025200843811035
(457) DESCRIBE `ports` 0.00092577934265137
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00027203559875488
(459) DESCRIBE `ports` 0.00096797943115234
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00025582313537598
(461) DESCRIBE `ports` 0.00093698501586914
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 633))) 0.00029301643371582
(463) DESCRIBE `ports` 0.0010068416595459
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '633') 0.00030398368835449
(465) DESCRIBE `ports` 0.0010559558868408
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1154))) 0.00029110908508301
(467) DESCRIBE `ports` 0.0009300708770752
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1154') 0.00025486946105957
(469) DESCRIBE `ports` 0.00091195106506348
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2594))) 0.00025105476379395
(471) DESCRIBE `ports` 0.00097298622131348
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2594') 0.0002589225769043
(473) DESCRIBE `ports` 0.001039981842041
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 802))) 0.00029301643371582
(475) DESCRIBE `ports` 0.00096797943115234
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '802') 0.00026106834411621
(477) DESCRIBE `ports` 0.00094699859619141
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00027704238891602
(479) DESCRIBE `ports` 0.00091814994812012
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00024700164794922
(481) DESCRIBE `ports` 0.00096583366394043
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00030016899108887
(483) DESCRIBE `ports` 0.00095295906066895
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00026106834411621
(485) DESCRIBE `ports` 0.00095605850219727
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 64))) 0.00030612945556641
(487) DESCRIBE `ports` 0.0009310245513916
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '64') 0.00028610229492188
(489) DESCRIBE `ports` 0.00091099739074707
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1170))) 0.00027608871459961
(491) DESCRIBE `ports` 0.00094318389892578
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1170') 0.00023007392883301
(493) DESCRIBE `ports` 0.0008549690246582
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.0002739429473877
(495) DESCRIBE `ports` 0.0010321140289307
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00031614303588867
(497) DESCRIBE `ports` 0.0010361671447754
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00029397010803223
(499) DESCRIBE `ports` 0.00098705291748047
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00024580955505371
(501) DESCRIBE `avid_specials` 0.0007469654083252
(502) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61130 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.0014188289642334
(503) DESCRIBE `cruiselines` 0.0011990070343018
(504) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00028085708618164
(505) DESCRIBE `orchid_image` 0.0011279582977295
(506) DESCRIBE `cruiselines` 0.0015170574188232
(507) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00036406517028809
(508) DESCRIBE `cruiselines` 0.0017690658569336
(509) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '120', '101', '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', '225', '229', '140', '170', '275', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '188', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '177', '224', '245', '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,120,101,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,225,229,140,170,275,59,108,115,113,180,73,269,264,240,88,219,276,57,52,188,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,177,224,245,257,210,223,263,251') 0.0047070980072021
(510) DESCRIBE `ships` 0.0024161338806152
(511) 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', '974', '10', '349', '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', '520', '817', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '30', '31', '37', '573', '1285', '1586', '36', '38', '39', '378', '434', '590', '792', '34', '35', '1012', '1376', '327', '526', '970', '43', '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', '1176', '1292', '1382', '1405', '338', '716', '1088', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '1575', '253', '857', '1149', '1236', '111', '285', '610', '852', '966', '1095', '1284', '59', '93', '403', '451', '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', '9', '75', '616', '666', '784', '1150', '1301', '1501', '503', '996', '1587', '81', '455', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1241', '1366', '1372', '1411', '1571', '108', '313', '776', '1141', '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', '823', '883', '1253', '74', '98', '147', '394', '937', '1579', '1087', '1172', '1454', '335', '938', '994', '66', '70', '341', '790', '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', '1262', '1439', '715', '973', '1023', '1043', '1144', '1481', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1543', '1594', '448', '717', '1090', '1110', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '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', '858', '915', '916', '926', '1001', '1072', '1082', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811')) 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,974,10,349,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,520,817,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,30,31,37,573,1285,1586,36,38,39,378,434,590,792,34,35,1012,1376,327,526,970,43,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,1176,1292,1382,1405,338,716,1088,1417,1569,1639,993,1455,314,678,722,837,1233,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,1575,253,857,1149,1236,111,285,610,852,966,1095,1284,59,93,403,451,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,9,75,616,666,784,1150,1301,1501,503,996,1587,81,455,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1241,1366,1372,1411,1571,108,313,776,1141,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,823,883,1253,74,98,147,394,937,1579,1087,1172,1454,335,938,994,66,70,341,790,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,1262,1439,715,973,1023,1043,1144,1481,1545,494,673,1136,1137,1240,1282,1303,1437,1543,1594,448,717,1090,1110,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,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,858,915,916,926,1001,1072,1082,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811') 0.030615091323853
(512) DESCRIBE `cruisetypes` 0.0011911392211914
(513) DESCRIBE `destinations` 0.0021481513977051
(514) 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.0014657974243164