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

Total elapsed time: 0.8561999797821

# Query Time
(1) connect 0.00055694580078125
(2) DESCRIBE `cruises` 0.0018768310546875
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68973, 69033, 68974, 72411, 69034, 68975, 69037, 69036, 68976, 69035)) ORDER BY FIND_IN_SET(id, '68973,69033,68974,72411,69034,68975,69037,69036,68976,69035') 0.0014090538024902
(4) DESCRIBE `cruises` 0.0016880035400391
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68973') 0.00026702880859375
(6) DESCRIBE `ships` 0.0014441013336182
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00028395652770996
(8) DESCRIBE `ships` 0.001295804977417
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00021791458129883
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017404556274414
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016498565673828
(12) DESCRIBE `itineraries` 0.0008080005645752
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68973') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067687034606934
(14) DESCRIBE `ports` 0.0014548301696777
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00028681755065918
(16) DESCRIBE `ports` 0.00095486640930176
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023484230041504
(18) DESCRIBE `ports` 0.0010538101196289
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00024509429931641
(20) DESCRIBE `sailingdates` 0.00084400177001953
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68973') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062918663024902
(22) DESCRIBE `ports` 0.00074386596679688
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022006034851074
(24) DESCRIBE `ports` 0.0006861686706543
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019717216491699
(26) DESCRIBE `ports` 0.00072193145751953
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00024104118347168
(28) DESCRIBE `ports` 0.00070309638977051
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001990795135498
(30) DESCRIBE `ports` 0.00070595741271973
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 374))) 0.00021004676818848
(32) DESCRIBE `ports` 0.00068116188049316
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '374') 0.00018310546875
(34) DESCRIBE `ports` 0.00069618225097656
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00019598007202148
(36) DESCRIBE `ports` 0.00097203254699707
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00024890899658203
(38) DESCRIBE `ports` 0.0009770393371582
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002748966217041
(40) DESCRIBE `ports` 0.0010170936584473
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00024318695068359
(42) DESCRIBE `ports` 0.0010898113250732
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00026297569274902
(44) DESCRIBE `ports` 0.00095319747924805
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.0002291202545166
(46) DESCRIBE `ports` 0.00095820426940918
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00023508071899414
(48) DESCRIBE `ports` 0.00072503089904785
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018596649169922
(50) DESCRIBE `ports` 0.00075483322143555
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00049901008605957
(52) DESCRIBE `ports` 0.0011818408966064
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00027203559875488
(54) DESCRIBE `ports` 0.0011000633239746
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4402))) 0.0003049373626709
(56) DESCRIBE `ports` 0.0011129379272461
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4402') 0.00029110908508301
(58) DESCRIBE `ports` 0.0010640621185303
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00033903121948242
(60) DESCRIBE `ports` 0.001060962677002
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00027894973754883
(62) DESCRIBE `ports` 0.0010719299316406
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3183))) 0.00031208992004395
(64) DESCRIBE `ports` 0.0010719299316406
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3183') 0.00027918815612793
(66) DESCRIBE `ports` 0.0011000633239746
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.00030899047851562
(68) DESCRIBE `ports` 0.0011310577392578
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00034689903259277
(70) DESCRIBE `ports` 0.0010521411895752
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00037002563476562
(72) DESCRIBE `ports` 0.0010819435119629
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0002899169921875
(74) DESCRIBE `ports` 0.0011510848999023
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032997131347656
(76) DESCRIBE `ports` 0.0010647773742676
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028109550476074
(78) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68973') AND (sailingdate >= '2018-04-24') 0.013193130493164
(79) DESCRIBE `avid_specials` 0.0012729167938232
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68973 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0017900466918945
(81) DESCRIBE `cruiselines` 0.0016489028930664
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00048208236694336
(83) DESCRIBE `orchid_image` 0.0010018348693848
(84) DESCRIBE `cruiselines` 0.0016870498657227
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00037908554077148
(86) DESCRIBE `cruises` 0.0024101734161377
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69033') 0.00046706199645996
(88) DESCRIBE `ships` 0.0022039413452148
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00041317939758301
(90) DESCRIBE `ships` 0.0020689964294434
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00034499168395996
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022697448730469
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022602081298828
(94) DESCRIBE `itineraries` 0.0011501312255859
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081086158752441
(96) DESCRIBE `ports` 0.0015490055084229
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040006637573242
(98) DESCRIBE `ports` 0.0011250972747803
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00035786628723145
(100) DESCRIBE `ports` 0.0011389255523682
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028300285339355
(102) DESCRIBE `sailingdates` 0.0009760856628418
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077295303344727
(104) DESCRIBE `ports` 0.001622200012207
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040602684020996
(106) DESCRIBE `ports` 0.001262903213501
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00032806396484375
(108) DESCRIBE `ports` 0.0011909008026123
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038814544677734
(110) DESCRIBE `ports` 0.001227855682373
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028395652770996
(112) DESCRIBE `ports` 0.0011520385742188
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00034403800964355
(114) DESCRIBE `ports` 0.0011429786682129
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00025391578674316
(116) DESCRIBE `ports` 0.00091695785522461
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00029802322387695
(118) DESCRIBE `ports` 0.0011019706726074
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.00029993057250977
(120) DESCRIBE `ports` 0.0010600090026855
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00037813186645508
(122) DESCRIBE `ports` 0.00092101097106934
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00020790100097656
(124) DESCRIBE `ports` 0.00069379806518555
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00023293495178223
(126) DESCRIBE `ports` 0.00073409080505371
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00021505355834961
(128) DESCRIBE `ports` 0.00076889991760254
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4402))) 0.00025606155395508
(130) DESCRIBE `ports` 0.0008089542388916
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4402') 0.00020503997802734
(132) DESCRIBE `ports` 0.00073695182800293
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00030207633972168
(134) DESCRIBE `ports` 0.00091099739074707
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00021910667419434
(136) DESCRIBE `ports` 0.000701904296875
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3183))) 0.00021696090698242
(138) DESCRIBE `ports` 0.00068092346191406
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3183') 0.00022697448730469
(140) DESCRIBE `ports` 0.00074911117553711
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.0002439022064209
(142) DESCRIBE `ports` 0.00073790550231934
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00020217895507812
(144) DESCRIBE `ports` 0.00074410438537598
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00023889541625977
(146) DESCRIBE `ports` 0.00075101852416992
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00020885467529297
(148) DESCRIBE `ports` 0.00076603889465332
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023889541625977
(150) DESCRIBE `ports` 0.00071001052856445
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019693374633789
(152) DESCRIBE `ports` 0.00068187713623047
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00025081634521484
(154) DESCRIBE `ports` 0.00070810317993164
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00019407272338867
(156) DESCRIBE `ports` 0.00079107284545898
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0002288818359375
(158) DESCRIBE `ports` 0.00074911117553711
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00020694732666016
(160) DESCRIBE `ports` 0.0007021427154541
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.00022602081298828
(162) DESCRIBE `ports` 0.00077104568481445
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00020313262939453
(164) DESCRIBE `ports` 0.00069713592529297
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0002448558807373
(166) DESCRIBE `ports` 0.00072288513183594
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00021505355834961
(168) DESCRIBE `ports` 0.00082302093505859
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00028514862060547
(170) DESCRIBE `ports` 0.00099802017211914
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00024795532226562
(172) DESCRIBE `ports` 0.00096797943115234
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00021696090698242
(174) DESCRIBE `ports` 0.00077986717224121
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00023317337036133
(176) DESCRIBE `ports` 0.0006859302520752
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021815299987793
(178) DESCRIBE `ports` 0.0006859302520752
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00019097328186035
(180) DESCRIBE `ports` 0.00074100494384766
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00021600723266602
(182) DESCRIBE `ports` 0.00070905685424805
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.0001978874206543
(184) DESCRIBE `ports` 0.00068902969360352
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028586387634277
(186) DESCRIBE `ports` 0.00089406967163086
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023984909057617
(188) DESCRIBE `ports` 0.0011630058288574
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029110908508301
(190) DESCRIBE `ports` 0.00078606605529785
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020003318786621
(192) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69033') AND (sailingdate >= '2018-04-24') 0.0052850246429443
(193) DESCRIBE `avid_specials` 0.00094413757324219
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69033 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0010499954223633
(195) DESCRIBE `cruiselines` 0.0011579990386963
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00026488304138184
(197) DESCRIBE `orchid_image` 0.00086498260498047
(198) DESCRIBE `cruiselines` 0.001288890838623
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0002751350402832
(200) DESCRIBE `cruises` 0.0014638900756836
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68974') 0.00030994415283203
(202) DESCRIBE `ships` 0.0017769336700439
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00041103363037109
(204) DESCRIBE `ships` 0.0015358924865723
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00026798248291016
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021696090698242
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017118453979492
(208) DESCRIBE `itineraries` 0.00089693069458008
(209) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68974') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085902214050293
(210) DESCRIBE `ports` 0.0014960765838623
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00034499168395996
(212) DESCRIBE `ports` 0.0011260509490967
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023508071899414
(214) DESCRIBE `ports` 0.00070619583129883
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019598007202148
(216) DESCRIBE `sailingdates` 0.00064492225646973
(217) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68974') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051784515380859
(218) DESCRIBE `ports` 0.00079178810119629
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00025701522827148
(220) DESCRIBE `ports` 0.00068998336791992
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001978874206543
(222) DESCRIBE `ports` 0.00067710876464844
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020289421081543
(224) DESCRIBE `ports` 0.00078797340393066
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020098686218262
(226) DESCRIBE `ports` 0.00070405006408691
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020098686218262
(228) DESCRIBE `ports` 0.00068092346191406
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00023293495178223
(230) DESCRIBE `ports` 0.00078010559082031
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00020885467529297
(232) DESCRIBE `ports` 0.00068902969360352
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00018501281738281
(234) DESCRIBE `ports` 0.00074195861816406
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0002291202545166
(236) DESCRIBE `ports` 0.00068998336791992
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00019001960754395
(238) DESCRIBE `ports` 0.00072717666625977
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.00025105476379395
(240) DESCRIBE `ports` 0.00071501731872559
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00018692016601562
(242) DESCRIBE `ports` 0.00067591667175293
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00023317337036133
(244) DESCRIBE `ports` 0.00075507164001465
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0001981258392334
(246) DESCRIBE `ports` 0.0006709098815918
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020885467529297
(248) DESCRIBE `ports` 0.00070095062255859
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00022006034851074
(250) DESCRIBE `ports` 0.00083303451538086
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020694732666016
(252) DESCRIBE `ports` 0.00068092346191406
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0001990795135498
(254) DESCRIBE `ports` 0.00072002410888672
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021481513977051
(256) DESCRIBE `ports` 0.00070095062255859
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00020909309387207
(258) DESCRIBE `ports` 0.00071406364440918
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00023198127746582
(260) DESCRIBE `ports` 0.00072598457336426
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00025010108947754
(262) DESCRIBE `ports` 0.00092005729675293
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002589225769043
(264) DESCRIBE `ports` 0.00093698501586914
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00034594535827637
(266) DESCRIBE `ports` 0.0011310577392578
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033402442932129
(268) DESCRIBE `ports` 0.00084304809570312
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00025200843811035
(270) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68974') AND (sailingdate >= '2018-04-24') 0.0086259841918945
(271) DESCRIBE `avid_specials` 0.00093889236450195
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68974 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.001086950302124
(273) DESCRIBE `cruiselines` 0.0011031627655029
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00026106834411621
(275) DESCRIBE `orchid_image` 0.00089097023010254
(276) DESCRIBE `cruiselines` 0.0010581016540527
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00025200843811035
(278) DESCRIBE `cruises` 0.0014238357543945
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72411') 0.00024700164794922
(280) DESCRIBE `ships` 0.0013668537139893
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00040793418884277
(282) DESCRIBE `ships` 0.0016050338745117
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00027012825012207
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00019502639770508
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022506713867188
(286) DESCRIBE `itineraries` 0.00082302093505859
(287) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72411') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084304809570312
(288) DESCRIBE `ports` 0.0010719299316406
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029277801513672
(290) DESCRIBE `ports` 0.00071501731872559
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022506713867188
(292) DESCRIBE `ports` 0.00072193145751953
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020194053649902
(294) DESCRIBE `sailingdates` 0.00069785118103027
(295) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72411') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059986114501953
(296) DESCRIBE `ports` 0.00082182884216309
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026607513427734
(298) DESCRIBE `ports` 0.0010221004486084
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026297569274902
(300) DESCRIBE `ports` 0.00076913833618164
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023007392883301
(302) DESCRIBE `ports` 0.00075387954711914
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019693374633789
(304) DESCRIBE `ports` 0.00068807601928711
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00022506713867188
(306) DESCRIBE `ports` 0.00075888633728027
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00025606155395508
(308) DESCRIBE `ports` 0.0010061264038086
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0002439022064209
(310) DESCRIBE `ports` 0.0007472038269043
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00020003318786621
(312) DESCRIBE `ports` 0.00068521499633789
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00022006034851074
(314) DESCRIBE `ports` 0.0007021427154541
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00020980834960938
(316) DESCRIBE `ports` 0.00080204010009766
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020790100097656
(318) DESCRIBE `ports` 0.00067806243896484
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00019001960754395
(320) DESCRIBE `ports` 0.00071310997009277
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0002129077911377
(322) DESCRIBE `ports` 0.00068092346191406
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00019192695617676
(324) DESCRIBE `ports` 0.00069212913513184
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00026106834411621
(326) DESCRIBE `ports` 0.00075817108154297
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.0001981258392334
(328) DESCRIBE `ports` 0.00069189071655273
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00021696090698242
(330) DESCRIBE `ports` 0.00080704689025879
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00020503997802734
(332) DESCRIBE `ports` 0.00070714950561523
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00021100044250488
(334) DESCRIBE `ports` 0.00069999694824219
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00018787384033203
(336) DESCRIBE `ports` 0.00073790550231934
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00021719932556152
(338) DESCRIBE `ports` 0.00072193145751953
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00021004676818848
(340) DESCRIBE `ports` 0.00098085403442383
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00024318695068359
(342) DESCRIBE `ports` 0.00077199935913086
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00019717216491699
(344) DESCRIBE `ports` 0.00089597702026367
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00027322769165039
(346) DESCRIBE `ports` 0.001054048538208
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00020194053649902
(348) DESCRIBE `ports` 0.00068807601928711
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027298927307129
(350) DESCRIBE `ports` 0.00083303451538086
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002131462097168
(352) DESCRIBE `ports` 0.00081992149353027
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00028300285339355
(354) DESCRIBE `ports` 0.00076603889465332
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002901554107666
(356) DESCRIBE `ports` 0.0009758472442627
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003058910369873
(358) DESCRIBE `ports` 0.0011081695556641
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00028014183044434
(360) DESCRIBE `ports` 0.0010919570922852
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00034809112548828
(362) DESCRIBE `ports` 0.00080585479736328
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00021910667419434
(364) DESCRIBE `ports` 0.0007481575012207
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00029397010803223
(366) DESCRIBE `ports` 0.001032829284668
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00025796890258789
(368) DESCRIBE `ports` 0.0010640621185303
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00030183792114258
(370) DESCRIBE `ports` 0.00111985206604
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00028491020202637
(372) DESCRIBE `ports` 0.0010659694671631
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00028395652770996
(374) DESCRIBE `ports` 0.00078988075256348
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00020003318786621
(376) DESCRIBE `ports` 0.00072312355041504
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021696090698242
(378) DESCRIBE `ports` 0.00070810317993164
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00019288063049316
(380) DESCRIBE `ports` 0.00069284439086914
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00022602081298828
(382) DESCRIBE `ports` 0.00074887275695801
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00020289421081543
(384) DESCRIBE `ports` 0.00068807601928711
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00024890899658203
(386) DESCRIBE `ports` 0.00071001052856445
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00020003318786621
(388) DESCRIBE `ports` 0.00071382522583008
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0002129077911377
(390) DESCRIBE `ports` 0.00078487396240234
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019502639770508
(392) DESCRIBE `ports` 0.00069904327392578
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00023317337036133
(394) DESCRIBE `ports` 0.00079607963562012
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00022697448730469
(396) DESCRIBE `ports` 0.00069904327392578
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00023388862609863
(398) DESCRIBE `ports` 0.00074601173400879
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00021219253540039
(400) DESCRIBE `ports` 0.00077390670776367
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00022006034851074
(402) DESCRIBE `ports` 0.00071597099304199
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0001981258392334
(404) DESCRIBE `ports` 0.00072193145751953
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021505355834961
(406) DESCRIBE `ports` 0.0007169246673584
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00019407272338867
(408) DESCRIBE `ports` 0.00068211555480957
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00027012825012207
(410) DESCRIBE `ports` 0.00069785118103027
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00019383430480957
(412) DESCRIBE `ports` 0.00071310997009277
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022482872009277
(414) DESCRIBE `ports` 0.00077390670776367
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00020003318786621
(416) DESCRIBE `ports` 0.00068998336791992
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00023913383483887
(418) DESCRIBE `ports` 0.0010030269622803
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00021505355834961
(420) DESCRIBE `ports` 0.00075912475585938
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00022411346435547
(422) DESCRIBE `ports` 0.0008080005645752
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00023293495178223
(424) DESCRIBE `ports` 0.00085806846618652
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00024199485778809
(426) DESCRIBE `ports` 0.00068402290344238
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00019097328186035
(428) DESCRIBE `ports` 0.00068402290344238
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00021219253540039
(430) DESCRIBE `ports` 0.00086307525634766
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00019383430480957
(432) DESCRIBE `ports` 0.00077199935913086
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00021600723266602
(434) DESCRIBE `ports` 0.0006868839263916
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019001960754395
(436) DESCRIBE `ports` 0.0009000301361084
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0002739429473877
(438) DESCRIBE `ports` 0.00072193145751953
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00020003318786621
(440) DESCRIBE `ports` 0.00069308280944824
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020599365234375
(442) DESCRIBE `ports` 0.00068998336791992
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019001960754395
(444) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72411') AND (sailingdate >= '2018-04-24') 0.0051929950714111
(445) DESCRIBE `avid_specials` 0.00089597702026367
(446) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72411 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0012850761413574
(447) DESCRIBE `cruiselines` 0.0016629695892334
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00028800964355469
(449) DESCRIBE `orchid_image` 0.0009148120880127
(450) DESCRIBE `cruiselines` 0.0011820793151855
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00023293495178223
(452) DESCRIBE `cruises` 0.0023739337921143
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69034') 0.00041103363037109
(454) DESCRIBE `ships` 0.0025501251220703
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00052094459533691
(456) DESCRIBE `ships` 0.0024499893188477
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00037789344787598
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023698806762695
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022482872009277
(460) DESCRIBE `itineraries` 0.0011649131774902
(461) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69034') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00095701217651367
(462) DESCRIBE `ports` 0.0014579296112061
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034308433532715
(464) DESCRIBE `ports` 0.0010499954223633
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030207633972168
(466) DESCRIBE `ports` 0.0011460781097412
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032305717468262
(468) DESCRIBE `sailingdates` 0.001007080078125
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69034') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062799453735352
(470) DESCRIBE `ports` 0.0014760494232178
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00053501129150391
(472) DESCRIBE `ports` 0.001230001449585
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027298927307129
(474) DESCRIBE `ports` 0.0010240077972412
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027704238891602
(476) DESCRIBE `ports` 0.0011038780212402
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028896331787109
(478) DESCRIBE `ports` 0.001086950302124
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00034403800964355
(480) DESCRIBE `ports` 0.0010800361633301
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00026679039001465
(482) DESCRIBE `ports` 0.0010929107666016
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00030994415283203
(484) DESCRIBE `ports` 0.0010628700256348
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0002598762512207
(486) DESCRIBE `ports` 0.0010180473327637
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00029921531677246
(488) DESCRIBE `ports` 0.0010428428649902
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00026679039001465
(490) DESCRIBE `ports` 0.0010030269622803
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00027799606323242
(492) DESCRIBE `ports` 0.0010280609130859
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00024890899658203
(494) DESCRIBE `ports` 0.0010099411010742
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00031709671020508
(496) DESCRIBE `ports` 0.00097417831420898
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00025081634521484
(498) DESCRIBE `ports` 0.0010149478912354
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00028395652770996
(500) DESCRIBE `ports` 0.0010368824005127
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.0002589225769043
(502) DESCRIBE `ports` 0.0010621547698975
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00029301643371582
(504) DESCRIBE `ports` 0.0010769367218018
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0002748966217041
(506) DESCRIBE `ports` 0.0010309219360352
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00029492378234863
(508) DESCRIBE `ports` 0.0010440349578857
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00024986267089844
(510) DESCRIBE `ports` 0.00099611282348633
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00034809112548828
(512) DESCRIBE `ports` 0.0010051727294922
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00026488304138184
(514) DESCRIBE `ports` 0.0010778903961182
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00029706954956055
(516) DESCRIBE `ports` 0.00092983245849609
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0002598762512207
(518) DESCRIBE `ports` 0.0010371208190918
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00028085708618164
(520) DESCRIBE `ports` 0.0010099411010742
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00024890899658203
(522) DESCRIBE `ports` 0.0010068416595459
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030398368835449
(524) DESCRIBE `ports` 0.0010640621185303
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024795532226562
(526) DESCRIBE `ports` 0.00098299980163574
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002741813659668
(528) DESCRIBE `ports` 0.0010190010070801
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023913383483887
(530) DESCRIBE `ports` 0.0010418891906738
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00044918060302734
(532) DESCRIBE `ports` 0.0012059211730957
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023794174194336
(534) DESCRIBE `ports` 0.00078296661376953
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00022602081298828
(536) DESCRIBE `ports` 0.00091099739074707
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.0002589225769043
(538) DESCRIBE `ports` 0.00092506408691406
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00026607513427734
(540) DESCRIBE `ports` 0.00090694427490234
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00023603439331055
(542) DESCRIBE `ports` 0.00092387199401855
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.0002741813659668
(544) DESCRIBE `ports` 0.00088286399841309
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00023508071899414
(546) DESCRIBE `ports` 0.00087690353393555
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00022697448730469
(548) DESCRIBE `ports` 0.00071191787719727
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.000244140625
(550) DESCRIBE `ports` 0.00070786476135254
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00022101402282715
(552) DESCRIBE `ports` 0.0007171630859375
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00020909309387207
(554) DESCRIBE `ports` 0.00073790550231934
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0002288818359375
(556) DESCRIBE `ports` 0.00070095062255859
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00019598007202148
(558) DESCRIBE `ports` 0.00067901611328125
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00021100044250488
(560) DESCRIBE `ports` 0.00068092346191406
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019502639770508
(562) DESCRIBE `ports` 0.00070405006408691
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00021481513977051
(564) DESCRIBE `ports` 0.00072884559631348
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00021219253540039
(566) DESCRIBE `ports` 0.00072908401489258
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00022411346435547
(568) DESCRIBE `ports` 0.00075101852416992
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019717216491699
(570) DESCRIBE `ports` 0.00074481964111328
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002439022064209
(572) DESCRIBE `ports` 0.00070381164550781
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025606155395508
(574) DESCRIBE `ports` 0.00078082084655762
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020790100097656
(576) DESCRIBE `ports` 0.00068402290344238
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00022006034851074
(578) DESCRIBE `ports` 0.00072479248046875
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002288818359375
(580) DESCRIBE `ports` 0.00070405006408691
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00024604797363281
(582) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69034') AND (sailingdate >= '2018-04-24') 0.0096940994262695
(583) DESCRIBE `avid_specials` 0.0011060237884521
(584) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69034 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.001021146774292
(585) DESCRIBE `cruiselines` 0.0010571479797363
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00027894973754883
(587) DESCRIBE `orchid_image` 0.001209020614624
(588) DESCRIBE `cruiselines` 0.001539945602417
(589) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00031495094299316
(590) DESCRIBE `cruises` 0.0018160343170166
(591) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68975') 0.00025415420532227
(592) DESCRIBE `ships` 0.00130295753479
(593) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.0002748966217041
(594) DESCRIBE `ships` 0.0014519691467285
(595) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00020313262939453
(596) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018000602722168
(597) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001990795135498
(598) DESCRIBE `itineraries` 0.00074195861816406
(599) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68975') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066709518432617
(600) DESCRIBE `ports` 0.00093317031860352
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002591609954834
(602) DESCRIBE `ports` 0.00073480606079102
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022602081298828
(604) DESCRIBE `ports` 0.00071310997009277
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020194053649902
(606) DESCRIBE `sailingdates` 0.000946044921875
(607) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68975') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061297416687012
(608) DESCRIBE `ports` 0.00082492828369141
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023198127746582
(610) DESCRIBE `ports` 0.00080490112304688
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019288063049316
(612) DESCRIBE `ports` 0.0006859302520752
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020313262939453
(614) DESCRIBE `ports` 0.00070905685424805
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018620491027832
(616) DESCRIBE `ports` 0.00067806243896484
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00020694732666016
(618) DESCRIBE `ports` 0.0007171630859375
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00023794174194336
(620) DESCRIBE `ports` 0.00074100494384766
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00024795532226562
(622) DESCRIBE `ports` 0.00069093704223633
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00019311904907227
(624) DESCRIBE `ports` 0.00069308280944824
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00021100044250488
(626) DESCRIBE `ports` 0.00072598457336426
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018692016601562
(628) DESCRIBE `ports` 0.00067400932312012
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020503997802734
(630) DESCRIBE `ports` 0.00069808959960938
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018596649169922
(632) DESCRIBE `ports` 0.00067996978759766
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020599365234375
(634) DESCRIBE `ports` 0.00093817710876465
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00027298927307129
(636) DESCRIBE `ports` 0.0008089542388916
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00024795532226562
(638) DESCRIBE `ports` 0.00074100494384766
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.0001990795135498
(640) DESCRIBE `ports` 0.00069308280944824
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00021886825561523
(642) DESCRIBE `ports` 0.00077509880065918
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00020694732666016
(644) DESCRIBE `ports` 0.00077509880065918
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00022411346435547
(646) DESCRIBE `ports` 0.00080204010009766
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00020599365234375
(648) DESCRIBE `ports` 0.00075101852416992
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00024986267089844
(650) DESCRIBE `ports` 0.00069499015808105
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00019121170043945
(652) DESCRIBE `ports` 0.000762939453125
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00023102760314941
(654) DESCRIBE `ports` 0.00069713592529297
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00018882751464844
(656) DESCRIBE `ports` 0.00068211555480957
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00023603439331055
(658) DESCRIBE `ports` 0.00078797340393066
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0001990795135498
(660) DESCRIBE `ports` 0.00081205368041992
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027012825012207
(662) DESCRIBE `ports` 0.00080394744873047
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019598007202148
(664) DESCRIBE `ports` 0.00076603889465332
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021576881408691
(666) DESCRIBE `ports` 0.00067996978759766
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018811225891113
(668) DESCRIBE `ports` 0.00066685676574707
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020503997802734
(670) DESCRIBE `ports` 0.00070309638977051
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018787384033203
(672) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68975') AND (sailingdate >= '2018-04-24') 0.0065619945526123
(673) DESCRIBE `avid_specials` 0.00096487998962402
(674) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68975 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0018658638000488
(675) DESCRIBE `cruiselines` 0.0015890598297119
(676) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00034499168395996
(677) DESCRIBE `orchid_image` 0.001154899597168
(678) DESCRIBE `cruiselines` 0.0014359951019287
(679) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00031495094299316
(680) DESCRIBE `cruises` 0.0019810199737549
(681) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69037') 0.00032520294189453
(682) DESCRIBE `ships` 0.0014510154724121
(683) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00028800964355469
(684) DESCRIBE `ships` 0.0017769336700439
(685) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0004580020904541
(686) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023198127746582
(687) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020408630371094
(688) DESCRIBE `itineraries` 0.0010941028594971
(689) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69037') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070619583129883
(690) DESCRIBE `ports` 0.0014441013336182
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034880638122559
(692) DESCRIBE `ports` 0.0010101795196533
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026988983154297
(694) DESCRIBE `ports` 0.0010221004486084
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029301643371582
(696) DESCRIBE `sailingdates` 0.00094985961914062
(697) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69037') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056600570678711
(698) DESCRIBE `ports` 0.0011179447174072
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031399726867676
(700) DESCRIBE `ports` 0.0010669231414795
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002589225769043
(702) DESCRIBE `ports` 0.0009911060333252
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029206275939941
(704) DESCRIBE `ports` 0.00099587440490723
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026607513427734
(706) DESCRIBE `ports` 0.0010309219360352
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029397010803223
(708) DESCRIBE `ports` 0.0010120868682861
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026106834411621
(710) DESCRIBE `ports` 0.00099015235900879
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029206275939941
(712) DESCRIBE `ports` 0.0010080337524414
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00024914741516113
(714) DESCRIBE `ports` 0.00099492073059082
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029277801513672
(716) DESCRIBE `ports` 0.0010359287261963
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00024890899658203
(718) DESCRIBE `ports` 0.00098085403442383
(719) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00030088424682617
(720) DESCRIBE `ports` 0.00105881690979
(721) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.0002601146697998
(722) DESCRIBE `ports` 0.00097918510437012
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00027108192443848
(724) DESCRIBE `ports` 0.00099611282348633
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00024509429931641
(726) DESCRIBE `ports` 0.00099992752075195
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00027108192443848
(728) DESCRIBE `ports` 0.00098919868469238
(729) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00024199485778809
(730) DESCRIBE `ports` 0.00098991394042969
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.0002739429473877
(732) DESCRIBE `ports` 0.00096988677978516
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00024080276489258
(734) DESCRIBE `ports` 0.00095391273498535
(735) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00027203559875488
(736) DESCRIBE `ports` 0.00098204612731934
(737) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00026106834411621
(738) DESCRIBE `ports` 0.0010640621185303
(739) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031805038452148
(740) DESCRIBE `ports` 0.0010340213775635
(741) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00024604797363281
(742) DESCRIBE `ports` 0.00097799301147461
(743) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00029611587524414
(744) DESCRIBE `ports` 0.00098609924316406
(745) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00024294853210449
(746) DESCRIBE `ports` 0.00095319747924805
(747) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00026988983154297
(748) DESCRIBE `ports` 0.00096893310546875
(749) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00024890899658203
(750) DESCRIBE `ports` 0.0010020732879639
(751) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00029206275939941
(752) DESCRIBE `ports` 0.0010159015655518
(753) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00029921531677246
(754) DESCRIBE `ports` 0.00098204612731934
(755) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00028395652770996
(756) DESCRIBE `ports` 0.00098013877868652
(757) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00024604797363281
(758) DESCRIBE `ports` 0.00096416473388672
(759) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00027704238891602
(760) DESCRIBE `ports` 0.00099587440490723
(761) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00024890899658203
(762) DESCRIBE `ports` 0.00098490715026855
(763) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00027799606323242
(764) DESCRIBE `ports` 0.00098800659179688
(765) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00025010108947754
(766) DESCRIBE `ports` 0.00098395347595215
(767) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00029110908508301
(768) DESCRIBE `ports` 0.00097799301147461
(769) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.000244140625
(770) DESCRIBE `ports` 0.00097894668579102
(771) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00028610229492188
(772) DESCRIBE `ports` 0.00099587440490723
(773) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00025820732116699
(774) DESCRIBE `ports` 0.0010080337524414
(775) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00028514862060547
(776) DESCRIBE `ports` 0.00098705291748047
(777) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024795532226562
(778) DESCRIBE `ports` 0.0009770393371582
(779) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00029301643371582
(780) DESCRIBE `ports` 0.0010030269622803
(781) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.000244140625
(782) DESCRIBE `ports` 0.0009760856628418
(783) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00027203559875488
(784) DESCRIBE `ports` 0.00098109245300293
(785) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.000244140625
(786) DESCRIBE `ports` 0.00096607208251953
(787) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0002748966217041
(788) DESCRIBE `ports` 0.00095510482788086
(789) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00024104118347168
(790) DESCRIBE `ports` 0.00097990036010742
(791) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00027298927307129
(792) DESCRIBE `ports` 0.00097990036010742
(793) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00024509429931641
(794) DESCRIBE `ports` 0.00099301338195801
(795) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00027012825012207
(796) DESCRIBE `ports` 0.00098109245300293
(797) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.0002439022064209
(798) DESCRIBE `ports` 0.00098013877868652
(799) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 634))) 0.00027203559875488
(800) DESCRIBE `ports` 0.001086950302124
(801) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '634') 0.00038003921508789
(802) DESCRIBE `ports` 0.0010771751403809
(803) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00027298927307129
(804) DESCRIBE `ports` 0.0010459423065186
(805) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00026702880859375
(806) DESCRIBE `ports` 0.0010750293731689
(807) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00030088424682617
(808) DESCRIBE `ports` 0.00099301338195801
(809) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00026392936706543
(810) DESCRIBE `ports` 0.00099515914916992
(811) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00029897689819336
(812) DESCRIBE `ports` 0.0010740756988525
(813) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00030016899108887
(814) DESCRIBE `ports` 0.0010139942169189
(815) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00028800964355469
(816) DESCRIBE `ports` 0.0009768009185791
(817) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00024199485778809
(818) DESCRIBE `ports` 0.00089001655578613
(819) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0003058910369873
(820) DESCRIBE `ports` 0.00096583366394043
(821) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0002439022064209
(822) DESCRIBE `ports` 0.0009000301361084
(823) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00027108192443848
(824) DESCRIBE `ports` 0.00099015235900879
(825) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00028085708618164
(826) DESCRIBE `ports` 0.0010781288146973
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00030207633972168
(828) DESCRIBE `ports` 0.0010080337524414
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00027608871459961
(830) DESCRIBE `ports` 0.0010201930999756
(831) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00030112266540527
(832) DESCRIBE `ports` 0.00098204612731934
(833) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.0002589225769043
(834) DESCRIBE `ports` 0.00095701217651367
(835) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00030899047851562
(836) DESCRIBE `ports` 0.0011270046234131
(837) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00029206275939941
(838) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69037') AND (sailingdate >= '2018-04-24') 0.0098440647125244
(839) DESCRIBE `avid_specials` 0.0010888576507568
(840) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69037 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0016908645629883
(841) DESCRIBE `cruiselines` 0.0015602111816406
(842) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00054097175598145
(843) DESCRIBE `orchid_image` 0.0014500617980957
(844) DESCRIBE `cruiselines` 0.001507043838501
(845) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0003049373626709
(846) DESCRIBE `cruises` 0.0020358562469482
(847) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69036') 0.0003349781036377
(848) DESCRIBE `ships` 0.0019621849060059
(849) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00037813186645508
(850) DESCRIBE `ships` 0.0021140575408936
(851) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00031113624572754
(852) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023794174194336
(853) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022101402282715
(854) DESCRIBE `itineraries` 0.0010850429534912
(855) DESCRIBE `ports` 0.0012609958648682
(856) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039315223693848
(857) DESCRIBE `ports` 0.0012969970703125
(858) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033807754516602
(859) DESCRIBE `ports` 0.001046895980835
(860) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029516220092773
(861) DESCRIBE `sailingdates` 0.0009310245513916
(862) DESCRIBE `ports` 0.0011389255523682
(863) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032782554626465
(864) DESCRIBE `ports` 0.0010578632354736
(865) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(866) DESCRIBE `ports` 0.0010659694671631
(867) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031208992004395
(868) DESCRIBE `ports` 0.0010788440704346
(869) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030398368835449
(870) DESCRIBE `ports` 0.0010251998901367
(871) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031900405883789
(872) DESCRIBE `ports` 0.00098609924316406
(873) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00025606155395508
(874) DESCRIBE `ports` 0.0010309219360352
(875) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00028681755065918
(876) DESCRIBE `ports` 0.0010349750518799
(877) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00025701522827148
(878) DESCRIBE `ports` 0.0010950565338135
(879) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029706954956055
(880) DESCRIBE `ports` 0.0010759830474854
(881) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027203559875488
(882) DESCRIBE `ports` 0.001025915145874
(883) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00029110908508301
(884) DESCRIBE `ports` 0.0010848045349121
(885) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00027298927307129
(886) DESCRIBE `ports` 0.0010209083557129
(887) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00034213066101074
(888) DESCRIBE `ports` 0.0010368824005127
(889) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.0002741813659668
(890) DESCRIBE `ports` 0.0010621547698975
(891) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00028800964355469
(892) DESCRIBE `ports` 0.00098800659179688
(893) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.0002598762512207
(894) DESCRIBE `ports` 0.0010511875152588
(895) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00028800964355469
(896) DESCRIBE `ports` 0.00099992752075195
(897) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00026679039001465
(898) DESCRIBE `ports` 0.0010340213775635
(899) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00032591819763184
(900) DESCRIBE `ports` 0.0011429786682129
(901) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00026988983154297
(902) DESCRIBE `ports` 0.0010430812835693
(903) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031113624572754
(904) DESCRIBE `ports` 0.0011041164398193
(905) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00027990341186523
(906) DESCRIBE `ports` 0.001101016998291
(907) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00035500526428223
(908) DESCRIBE `ports` 0.001101016998291
(909) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00028800964355469
(910) DESCRIBE `ports` 0.00079989433288574
(911) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00023198127746582
(912) DESCRIBE `ports` 0.0007941722869873
(913) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00022101402282715
(914) DESCRIBE `ports` 0.0007319450378418
(915) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00029492378234863
(916) DESCRIBE `ports` 0.00076198577880859
(917) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00023221969604492
(918) DESCRIBE `ports` 0.00069689750671387
(919) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021815299987793
(920) DESCRIBE `ports` 0.00087594985961914
(921) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0004119873046875
(922) DESCRIBE `ports` 0.0011880397796631
(923) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00034999847412109
(924) DESCRIBE `ports` 0.0010018348693848
(925) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00025200843811035
(926) DESCRIBE `ports` 0.0010430812835693
(927) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0002892017364502
(928) DESCRIBE `ports` 0.0010068416595459
(929) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00025200843811035
(930) DESCRIBE `ports` 0.0010240077972412
(931) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00028300285339355
(932) DESCRIBE `ports` 0.00097799301147461
(933) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00024795532226562
(934) DESCRIBE `ports` 0.00096702575683594
(935) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00027990341186523
(936) DESCRIBE `ports` 0.0010461807250977
(937) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00025606155395508
(938) DESCRIBE `ports` 0.0011110305786133
(939) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00025796890258789
(940) DESCRIBE `ports` 0.00076103210449219
(941) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00020503997802734
(942) DESCRIBE `ports` 0.00068402290344238
(943) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00020503997802734
(944) DESCRIBE `ports` 0.00074601173400879
(945) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00061583518981934
(946) DESCRIBE `ports` 0.0012989044189453
(947) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00032305717468262
(948) DESCRIBE `ports` 0.0010631084442139
(949) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00026583671569824
(950) DESCRIBE `ports` 0.0010170936584473
(951) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00028800964355469
(952) DESCRIBE `ports` 0.0010600090026855
(953) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.0002589225769043
(954) DESCRIBE `ports` 0.0012350082397461
(955) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00037908554077148
(956) DESCRIBE `ports` 0.0011060237884521
(957) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00028109550476074
(958) DESCRIBE `ports` 0.0010170936584473
(959) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00029897689819336
(960) DESCRIBE `ports` 0.00099301338195801
(961) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00028014183044434
(962) DESCRIBE `ports` 0.00098800659179688
(963) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00033187866210938
(964) DESCRIBE `ports` 0.001101016998291
(965) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00032615661621094
(966) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69036') AND (sailingdate >= '2018-04-24') 0.010982036590576
(967) DESCRIBE `avid_specials` 0.0011489391326904
(968) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69036 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0015900135040283
(969) DESCRIBE `cruiselines` 0.0014388561248779
(970) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00030803680419922
(971) DESCRIBE `orchid_image` 0.0010678768157959
(972) DESCRIBE `cruiselines` 0.0014700889587402
(973) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0003349781036377
(974) DESCRIBE `cruises` 0.0019009113311768
(975) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68976') 0.0003049373626709
(976) DESCRIBE `ships` 0.0018439292907715
(977) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00051307678222656
(978) DESCRIBE `ships` 0.0021541118621826
(979) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00029802322387695
(980) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021100044250488
(981) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002129077911377
(982) DESCRIBE `itineraries` 0.0010049343109131
(983) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68976') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005650520324707
(984) DESCRIBE `ports` 0.0011510848999023
(985) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003058910369873
(986) DESCRIBE `ports` 0.00089597702026367
(987) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026202201843262
(988) DESCRIBE `ports` 0.00092697143554688
(989) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027704238891602
(990) DESCRIBE `sailingdates` 0.00084996223449707
(991) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68976') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062084197998047
(992) DESCRIBE `ports` 0.001230001449585
(993) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039505958557129
(994) DESCRIBE `ports` 0.0011260509490967
(995) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029110908508301
(996) DESCRIBE `ports` 0.0010819435119629
(997) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032186508178711
(998) DESCRIBE `ports` 0.0010368824005127
(999) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026607513427734
(1000) DESCRIBE `ports` 0.0010218620300293
(1001) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(1002) DESCRIBE `ports` 0.00095891952514648
(1003) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002589225769043
(1004) DESCRIBE `ports` 0.0010068416595459
(1005) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029301643371582
(1006) DESCRIBE `ports` 0.0010700225830078
(1007) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026202201843262
(1008) DESCRIBE `ports` 0.0010089874267578
(1009) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031304359436035
(1010) DESCRIBE `ports` 0.0011200904846191
(1011) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00028896331787109
(1012) DESCRIBE `ports` 0.0012640953063965
(1013) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00028204917907715
(1014) DESCRIBE `ports` 0.0007789134979248
(1015) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.0002601146697998
(1016) DESCRIBE `ports` 0.00099682807922363
(1017) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00030612945556641
(1018) DESCRIBE `ports` 0.00076985359191895
(1019) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00020408630371094
(1020) DESCRIBE `ports` 0.00072407722473145
(1021) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00023698806762695
(1022) DESCRIBE `ports` 0.00068807601928711
(1023) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00019502639770508
(1024) DESCRIBE `ports` 0.00073599815368652
(1025) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00028705596923828
(1026) DESCRIBE `ports` 0.00093984603881836
(1027) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00021195411682129
(1028) DESCRIBE `ports` 0.00087285041809082
(1029) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00023818016052246
(1030) DESCRIBE `ports` 0.00077676773071289
(1031) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0001988410949707
(1032) DESCRIBE `ports` 0.00068402290344238
(1033) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00027108192443848
(1034) DESCRIBE `ports` 0.00083208084106445
(1035) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00021886825561523
(1036) DESCRIBE `ports` 0.00068402290344238
(1037) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00030422210693359
(1038) DESCRIBE `ports` 0.00071978569030762
(1039) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00020694732666016
(1040) DESCRIBE `ports` 0.00067996978759766
(1041) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00021600723266602
(1042) DESCRIBE `ports` 0.00069808959960938
(1043) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019001960754395
(1044) DESCRIBE `ports` 0.00069093704223633
(1045) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00026988983154297
(1046) DESCRIBE `ports` 0.00099396705627441
(1047) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025415420532227
(1048) DESCRIBE `ports` 0.00097894668579102
(1049) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00029301643371582
(1050) DESCRIBE `ports` 0.0010309219360352
(1051) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00026106834411621
(1052) DESCRIBE `ports` 0.00074601173400879
(1053) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00022602081298828
(1054) DESCRIBE `ports` 0.00095391273498535
(1055) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00020480155944824
(1056) DESCRIBE `ports` 0.00071406364440918
(1057) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00030207633972168
(1058) DESCRIBE `ports` 0.00099492073059082
(1059) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025820732116699
(1060) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68976') AND (sailingdate >= '2018-04-24') 0.0057480335235596
(1061) DESCRIBE `avid_specials` 0.00095200538635254
(1062) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68976 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 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.0028078556060791
(1063) DESCRIBE `cruiselines` 0.0011069774627686
(1064) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00026893615722656
(1065) DESCRIBE `orchid_image` 0.00080680847167969
(1066) DESCRIBE `cruiselines` 0.00093889236450195
(1067) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00020289421081543
(1068) DESCRIBE `cruises` 0.0013289451599121
(1069) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69035') 0.00022220611572266
(1070) DESCRIBE `ships` 0.0015189647674561
(1071) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00028395652770996
(1072) DESCRIBE `ships` 0.0014791488647461
(1073) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00030112266540527
(1074) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002291202545166
(1075) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002140998840332
(1076) DESCRIBE `itineraries` 0.00083398818969727
(1077) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69035') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069284439086914
(1078) DESCRIBE `ports` 0.001093864440918
(1079) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00028085708618164
(1080) DESCRIBE `ports` 0.00069594383239746
(1081) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021195411682129
(1082) DESCRIBE `ports` 0.00072002410888672
(1083) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00022387504577637
(1084) DESCRIBE `sailingdates` 0.00070595741271973
(1085) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69035') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044393539428711
(1086) DESCRIBE `ports` 0.00074601173400879
(1087) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00023698806762695
(1088) DESCRIBE `ports` 0.0007319450378418
(1089) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00020003318786621
(1090) DESCRIBE `ports` 0.00068497657775879
(1091) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00025010108947754
(1092) DESCRIBE `ports` 0.00072216987609863
(1093) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00021100044250488
(1094) DESCRIBE `ports` 0.00091695785522461
(1095) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00028204917907715
(1096) DESCRIBE `ports` 0.00080013275146484
(1097) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00020098686218262
(1098) DESCRIBE `ports` 0.00068211555480957
(1099) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00022006034851074
(1100) DESCRIBE `ports` 0.00072121620178223
(1101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00019192695617676
(1102) DESCRIBE `ports` 0.00082612037658691
(1103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00028109550476074
(1104) DESCRIBE `ports` 0.0010449886322021
(1105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0002439022064209
(1106) DESCRIBE `ports` 0.00091385841369629
(1107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00022697448730469
(1108) DESCRIBE `ports` 0.000701904296875
(1109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00019407272338867
(1110) DESCRIBE `ports` 0.00068211555480957
(1111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021886825561523
(1112) DESCRIBE `ports` 0.00075078010559082
(1113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00020599365234375
(1114) DESCRIBE `ports` 0.00068116188049316
(1115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022482872009277
(1116) DESCRIBE `ports` 0.00067901611328125
(1117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00022506713867188
(1118) DESCRIBE `ports` 0.00069785118103027
(1119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.0002140998840332
(1120) DESCRIBE `ports` 0.00072598457336426
(1121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00019097328186035
(1122) DESCRIBE `ports` 0.00070285797119141
(1123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00021886825561523
(1124) DESCRIBE `ports` 0.00072598457336426
(1125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00019407272338867
(1126) DESCRIBE `ports` 0.00067687034606934
(1127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00024795532226562
(1128) DESCRIBE `ports` 0.00072813034057617
(1129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00019693374633789
(1130) DESCRIBE `ports` 0.00067806243896484
(1131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00021982192993164
(1132) DESCRIBE `ports` 0.00069785118103027
(1133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019288063049316
(1134) DESCRIBE `ports` 0.00067400932312012
(1135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00021100044250488
(1136) DESCRIBE `ports` 0.0006721019744873
(1137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00019192695617676
(1138) DESCRIBE `ports` 0.00071096420288086
(1139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 634))) 0.00021910667419434
(1140) DESCRIBE `ports` 0.00069689750671387
(1141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '634') 0.00019192695617676
(1142) DESCRIBE `ports` 0.00070881843566895
(1143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00022387504577637
(1144) DESCRIBE `ports` 0.00068497657775879
(1145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00019001960754395
(1146) DESCRIBE `ports` 0.00066399574279785
(1147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00021910667419434
(1148) DESCRIBE `ports` 0.00067806243896484
(1149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00019502639770508
(1150) DESCRIBE `ports` 0.00068187713623047
(1151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00028300285339355
(1152) DESCRIBE `ports` 0.00073409080505371
(1153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00021004676818848
(1154) DESCRIBE `ports` 0.00082707405090332
(1155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.000244140625
(1156) DESCRIBE `ports` 0.00076103210449219
(1157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00019979476928711
(1158) DESCRIBE `ports` 0.0007021427154541
(1159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0002140998840332
(1160) DESCRIBE `ports` 0.00082302093505859
(1161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00026202201843262
(1162) DESCRIBE `ports` 0.00076794624328613
(1163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00023007392883301
(1164) DESCRIBE `ports` 0.00080990791320801
(1165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0002601146697998
(1166) DESCRIBE `ports` 0.00077295303344727
(1167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00025796890258789
(1168) DESCRIBE `ports` 0.00089812278747559
(1169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00019288063049316
(1170) DESCRIBE `ports` 0.00068902969360352
(1171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0002439022064209
(1172) DESCRIBE `ports` 0.0009160041809082
(1173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00026488304138184
(1174) DESCRIBE `ports` 0.00090885162353516
(1175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00024890899658203
(1176) DESCRIBE `ports` 0.00074911117553711
(1177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0001988410949707
(1178) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69035') AND (sailingdate >= '2018-04-24') 0.005620002746582
(1179) DESCRIBE `avid_specials` 0.0010268688201904
(1180) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69035 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 28 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013630390167236
(1181) DESCRIBE `cruiselines` 0.001147985458374
(1182) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00029706954956055
(1183) DESCRIBE `orchid_image` 0.0011501312255859
(1184) DESCRIBE `cruiselines` 0.0011651515960693
(1185) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00024604797363281
(1186) DESCRIBE `ships` 0.0019211769104004
(1187) SELECT `ships`.* FROM `ships` WHERE (id IN ('823')) ORDER BY FIND_IN_SET(id, '823') 0.00052785873413086
(1188) DESCRIBE `cruisetypes` 0.00075912475585938
(1189) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '188') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.031741857528687
(1190) DESCRIBE `destinations` 0.0013411045074463
(1191) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '28', '49', '40', '25', '21', '26', '30', '35', '52')) ORDER BY FIND_IN_SET(id, '22,28,49,40,25,21,26,30,35,52') 0.0012009143829346
(1192) DESCRIBE `cruiselines` 0.0014219284057617
(1193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00031900405883789
(1194) DESCRIBE `cruiselines` 0.0014150142669678
(1195) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00045013427734375