or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

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.70460867881775

# Query Time
(1) connect 0.0005497932434082
(2) DESCRIBE `cruises` 0.0024111270904541
(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.0017209053039551
(4) DESCRIBE `cruises` 0.0022430419921875
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68973') 0.00031900405883789
(6) DESCRIBE `ships` 0.0020442008972168
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00041484832763672
(8) DESCRIBE `ships` 0.0013551712036133
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0001981258392334
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017690658569336
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016498565673828
(12) DESCRIBE `itineraries` 0.00089311599731445
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68973') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065398216247559
(14) DESCRIBE `ports` 0.0010201930999756
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023698806762695
(16) DESCRIBE `ports` 0.00066614151000977
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00026106834411621
(18) DESCRIBE `ports` 0.00099897384643555
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00025510787963867
(20) DESCRIBE `sailingdates` 0.00090718269348145
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68973') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00080394744873047
(22) DESCRIBE `ports` 0.0012161731719971
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002439022064209
(24) DESCRIBE `ports` 0.00067400932312012
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019693374633789
(26) DESCRIBE `ports` 0.00066113471984863
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019097328186035
(28) DESCRIBE `ports` 0.00066709518432617
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017380714416504
(30) DESCRIBE `ports` 0.00066399574279785
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 374))) 0.0002741813659668
(32) DESCRIBE `ports` 0.000762939453125
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '374') 0.0002439022064209
(34) DESCRIBE `ports` 0.00098299980163574
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00022411346435547
(36) DESCRIBE `ports` 0.0006721019744873
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00018787384033203
(38) DESCRIBE `ports` 0.00068783760070801
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022196769714355
(40) DESCRIBE `ports` 0.00075316429138184
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018405914306641
(42) DESCRIBE `ports` 0.00066208839416504
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.0001990795135498
(44) DESCRIBE `ports` 0.00066900253295898
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.00018405914306641
(46) DESCRIBE `ports` 0.00066089630126953
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00024890899658203
(48) DESCRIBE `ports` 0.0009000301361084
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00019311904907227
(50) DESCRIBE `ports` 0.00072908401489258
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00022101402282715
(52) DESCRIBE `ports` 0.0006861686706543
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00020909309387207
(54) DESCRIBE `ports` 0.00069904327392578
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4402))) 0.00020599365234375
(56) DESCRIBE `ports` 0.00076699256896973
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4402') 0.00018596649169922
(58) DESCRIBE `ports` 0.0006709098815918
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00024890899658203
(60) DESCRIBE `ports` 0.00072598457336426
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0001988410949707
(62) DESCRIBE `ports` 0.00074911117553711
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3183))) 0.00022411346435547
(64) DESCRIBE `ports` 0.0007319450378418
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3183') 0.00019097328186035
(66) DESCRIBE `ports` 0.00069308280944824
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.0002138614654541
(68) DESCRIBE `ports` 0.00079607963562012
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00026297569274902
(70) DESCRIBE `ports` 0.00075292587280273
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00026416778564453
(72) DESCRIBE `ports` 0.00081586837768555
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00019192695617676
(74) DESCRIBE `ports` 0.00071191787719727
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020694732666016
(76) DESCRIBE `ports` 0.00066494941711426
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017809867858887
(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.0042510032653809
(79) DESCRIBE `avid_specials` 0.0007779598236084
(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.0011019706726074
(81) DESCRIBE `cruiselines` 0.001060962677002
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00023603439331055
(83) DESCRIBE `orchid_image` 0.00076389312744141
(84) DESCRIBE `cruiselines` 0.00091886520385742
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00019598007202148
(86) DESCRIBE `cruises` 0.0013480186462402
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69033') 0.00025391578674316
(88) DESCRIBE `ships` 0.0012989044189453
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00027179718017578
(90) DESCRIBE `ships` 0.0013768672943115
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00021100044250488
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017786026000977
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017094612121582
(94) DESCRIBE `itineraries` 0.00073885917663574
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063705444335938
(96) DESCRIBE `ports` 0.0008389949798584
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00029301643371582
(98) DESCRIBE `ports` 0.00095009803771973
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020694732666016
(100) DESCRIBE `ports` 0.0007021427154541
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020217895507812
(102) DESCRIBE `sailingdates` 0.00061798095703125
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058889389038086
(104) DESCRIBE `ports` 0.00070691108703613
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021195411682129
(106) DESCRIBE `ports` 0.00067305564880371
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017714500427246
(108) DESCRIBE `ports` 0.00065898895263672
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019097328186035
(110) DESCRIBE `ports` 0.00067591667175293
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017595291137695
(112) DESCRIBE `ports` 0.0006568431854248
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019598007202148
(114) DESCRIBE `ports` 0.00066518783569336
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018715858459473
(116) DESCRIBE `ports` 0.00070905685424805
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00022792816162109
(118) DESCRIBE `ports` 0.0010218620300293
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.00021696090698242
(120) DESCRIBE `ports` 0.0008089542388916
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00022387504577637
(122) DESCRIBE `ports` 0.00071501731872559
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018405914306641
(124) DESCRIBE `ports` 0.0006709098815918
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00021195411682129
(126) DESCRIBE `ports` 0.00066590309143066
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00018310546875
(128) DESCRIBE `ports` 0.00066804885864258
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4402))) 0.00022292137145996
(130) DESCRIBE `ports` 0.00069594383239746
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4402') 0.00018095970153809
(132) DESCRIBE `ports` 0.00069785118103027
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00020098686218262
(134) DESCRIBE `ports` 0.00067806243896484
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00017690658569336
(136) DESCRIBE `ports` 0.00068807601928711
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3183))) 0.00021195411682129
(138) DESCRIBE `ports` 0.00070714950561523
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3183') 0.00018811225891113
(140) DESCRIBE `ports` 0.00065493583679199
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.00020503997802734
(142) DESCRIBE `ports` 0.00067591667175293
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00018692016601562
(144) DESCRIBE `ports` 0.00069808959960938
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020909309387207
(146) DESCRIBE `ports` 0.00065493583679199
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00021696090698242
(148) DESCRIBE `ports` 0.00067806243896484
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0001990795135498
(150) DESCRIBE `ports` 0.0006561279296875
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017595291137695
(152) DESCRIBE `ports` 0.00065088272094727
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00019001960754395
(154) DESCRIBE `ports` 0.00067996978759766
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00018620491027832
(156) DESCRIBE `ports` 0.00065898895263672
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00019502639770508
(158) DESCRIBE `ports` 0.00071191787719727
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00017404556274414
(160) DESCRIBE `ports` 0.00067591667175293
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.0001981258392334
(162) DESCRIBE `ports` 0.00066018104553223
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00020289421081543
(164) DESCRIBE `ports` 0.00068497657775879
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0001978874206543
(166) DESCRIBE `ports` 0.00068998336791992
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018000602722168
(168) DESCRIBE `ports` 0.0006568431854248
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019502639770508
(170) DESCRIBE `ports` 0.0007321834564209
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018310546875
(172) DESCRIBE `ports` 0.00070905685424805
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019621849060059
(174) DESCRIBE `ports` 0.00069308280944824
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(176) DESCRIBE `ports` 0.00068497657775879
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00022006034851074
(178) DESCRIBE `ports` 0.0006711483001709
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018692016601562
(180) DESCRIBE `ports` 0.00071811676025391
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00027894973754883
(182) DESCRIBE `ports` 0.0007328987121582
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00019407272338867
(184) DESCRIBE `ports` 0.00068783760070801
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022006034851074
(186) DESCRIBE `ports` 0.00066089630126953
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018095970153809
(188) DESCRIBE `ports` 0.00065994262695312
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020599365234375
(190) DESCRIBE `ports` 0.00068807601928711
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021600723266602
(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.0042870044708252
(193) DESCRIBE `avid_specials` 0.00077199935913086
(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.0011119842529297
(195) DESCRIBE `cruiselines` 0.0009920597076416
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00023293495178223
(197) DESCRIBE `orchid_image` 0.00079894065856934
(198) DESCRIBE `cruiselines` 0.00094389915466309
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00026297569274902
(200) DESCRIBE `cruises` 0.0014419555664062
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68974') 0.00025105476379395
(202) DESCRIBE `ships` 0.001399040222168
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00029587745666504
(204) DESCRIBE `ships` 0.0013210773468018
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0002129077911377
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018000602722168
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001678466796875
(208) DESCRIBE `itineraries` 0.00074887275695801
(209) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68974') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058794021606445
(210) DESCRIBE `ports` 0.0008699893951416
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002439022064209
(212) DESCRIBE `ports` 0.00068998336791992
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021100044250488
(214) DESCRIBE `ports` 0.00066518783569336
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00038695335388184
(216) DESCRIBE `sailingdates` 0.00078797340393066
(217) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68974') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047898292541504
(218) DESCRIBE `ports` 0.00081086158752441
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022411346435547
(220) DESCRIBE `ports` 0.00067687034606934
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018692016601562
(222) DESCRIBE `ports` 0.00072503089904785
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020003318786621
(224) DESCRIBE `ports` 0.00069689750671387
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018000602722168
(226) DESCRIBE `ports` 0.00067019462585449
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0001978874206543
(228) DESCRIBE `ports` 0.00081801414489746
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018095970153809
(230) DESCRIBE `ports` 0.00067806243896484
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00020408630371094
(232) DESCRIBE `ports` 0.00066900253295898
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00018191337585449
(234) DESCRIBE `ports` 0.0006859302520752
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0001990795135498
(236) DESCRIBE `ports` 0.00066804885864258
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018191337585449
(238) DESCRIBE `ports` 0.00066804885864258
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.0002131462097168
(240) DESCRIBE `ports` 0.00078010559082031
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00018882751464844
(242) DESCRIBE `ports` 0.0007331371307373
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00036120414733887
(244) DESCRIBE `ports` 0.00069308280944824
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0001838207244873
(246) DESCRIBE `ports` 0.00066804885864258
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020313262939453
(248) DESCRIBE `ports` 0.00066900253295898
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(250) DESCRIBE `ports` 0.00072407722473145
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020599365234375
(252) DESCRIBE `ports` 0.00073599815368652
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018596649169922
(254) DESCRIBE `ports` 0.00067591667175293
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00023007392883301
(256) DESCRIBE `ports` 0.00069403648376465
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018596649169922
(258) DESCRIBE `ports` 0.00067901611328125
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00020909309387207
(260) DESCRIBE `ports` 0.00073099136352539
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.0001990795135498
(262) DESCRIBE `ports` 0.00068306922912598
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021696090698242
(264) DESCRIBE `ports` 0.00070095062255859
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018906593322754
(266) DESCRIBE `ports` 0.00074100494384766
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021195411682129
(268) DESCRIBE `ports` 0.00067591667175293
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018882751464844
(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.0045199394226074
(271) DESCRIBE `avid_specials` 0.00086307525634766
(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.0012102127075195
(273) DESCRIBE `cruiselines` 0.0011410713195801
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00025200843811035
(275) DESCRIBE `orchid_image` 0.00078892707824707
(276) DESCRIBE `cruiselines` 0.0010359287261963
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00020980834960938
(278) DESCRIBE `cruises` 0.0013759136199951
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72411') 0.00030207633972168
(280) DESCRIBE `ships` 0.0013880729675293
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00028085708618164
(282) DESCRIBE `ships` 0.0013501644134521
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00019097328186035
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017809867858887
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001680850982666
(286) DESCRIBE `itineraries` 0.00068402290344238
(287) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72411') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00075101852416992
(288) DESCRIBE `ports` 0.00096797943115234
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025796890258789
(290) DESCRIBE `ports` 0.00067996978759766
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022387504577637
(292) DESCRIBE `ports` 0.00066900253295898
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(294) DESCRIBE `sailingdates` 0.00059914588928223
(295) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72411') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059294700622559
(296) DESCRIBE `ports` 0.0007789134979248
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022506713867188
(298) DESCRIBE `ports` 0.0006859302520752
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022602081298828
(300) DESCRIBE `ports` 0.00098991394042969
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022602081298828
(302) DESCRIBE `ports` 0.00069499015808105
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018692016601562
(304) DESCRIBE `ports` 0.00078201293945312
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00020408630371094
(306) DESCRIBE `ports` 0.00066995620727539
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00020599365234375
(308) DESCRIBE `ports` 0.00083112716674805
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00024318695068359
(310) DESCRIBE `ports` 0.00068283081054688
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00020694732666016
(312) DESCRIBE `ports` 0.00066494941711426
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0001990795135498
(314) DESCRIBE `ports` 0.00093221664428711
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017905235290527
(316) DESCRIBE `ports` 0.00068998336791992
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.0001981258392334
(318) DESCRIBE `ports` 0.00066995620727539
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00017404556274414
(320) DESCRIBE `ports` 0.00074195861816406
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0001990795135498
(322) DESCRIBE `ports` 0.00076794624328613
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018906593322754
(324) DESCRIBE `ports` 0.0010421276092529
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00026202201843262
(326) DESCRIBE `ports` 0.00070786476135254
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00018906593322754
(328) DESCRIBE `ports` 0.0007469654083252
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00021195411682129
(330) DESCRIBE `ports` 0.0006861686706543
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0001981258392334
(332) DESCRIBE `ports` 0.0006861686706543
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00023913383483887
(334) DESCRIBE `ports` 0.00069403648376465
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.0001838207244873
(336) DESCRIBE `ports` 0.00068211555480957
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020480155944824
(338) DESCRIBE `ports` 0.00074005126953125
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00018978118896484
(340) DESCRIBE `ports` 0.00067496299743652
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020194053649902
(342) DESCRIBE `ports` 0.00068807601928711
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00018095970153809
(344) DESCRIBE `ports` 0.0007328987121582
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00026702880859375
(346) DESCRIBE `ports` 0.0010240077972412
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00027012825012207
(348) DESCRIBE `ports` 0.0010590553283691
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024700164794922
(350) DESCRIBE `ports` 0.00069999694824219
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001828670501709
(352) DESCRIBE `ports` 0.00069999694824219
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00025796890258789
(354) DESCRIBE `ports` 0.00092196464538574
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023007392883301
(356) DESCRIBE `ports` 0.0010740756988525
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00027012825012207
(358) DESCRIBE `ports` 0.00072216987609863
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018906593322754
(360) DESCRIBE `ports` 0.00074601173400879
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00022602081298828
(362) DESCRIBE `ports` 0.0007479190826416
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00019097328186035
(364) DESCRIBE `ports` 0.00067496299743652
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00022482872009277
(366) DESCRIBE `ports` 0.00066518783569336
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00018906593322754
(368) DESCRIBE `ports` 0.00072813034057617
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00022792816162109
(370) DESCRIBE `ports` 0.00073599815368652
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00017499923706055
(372) DESCRIBE `ports` 0.00068092346191406
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00019693374633789
(374) DESCRIBE `ports` 0.00070405006408691
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018596649169922
(376) DESCRIBE `ports` 0.00067591667175293
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021004676818848
(378) DESCRIBE `ports` 0.00073599815368652
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00022387504577637
(380) DESCRIBE `ports` 0.00096416473388672
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00026297569274902
(382) DESCRIBE `ports` 0.00097012519836426
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00022387504577637
(384) DESCRIBE `ports` 0.00098800659179688
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00025796890258789
(386) DESCRIBE `ports` 0.0009770393371582
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00023293495178223
(388) DESCRIBE `ports` 0.00095796585083008
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00025391578674316
(390) DESCRIBE `ports` 0.0010011196136475
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00022387504577637
(392) DESCRIBE `ports` 0.00098919868469238
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002598762512207
(394) DESCRIBE `ports` 0.00097393989562988
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00022482872009277
(396) DESCRIBE `ports` 0.0010130405426025
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002598762512207
(398) DESCRIBE `ports` 0.00097513198852539
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025701522827148
(400) DESCRIBE `ports` 0.0010590553283691
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00027704238891602
(402) DESCRIBE `ports` 0.00097298622131348
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0002589225769043
(404) DESCRIBE `ports` 0.0009770393371582
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00027799606323242
(406) DESCRIBE `ports` 0.00098013877868652
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00024914741516113
(408) DESCRIBE `ports` 0.00097393989562988
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00026988983154297
(410) DESCRIBE `ports` 0.0010180473327637
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00025415420532227
(412) DESCRIBE `ports` 0.00095391273498535
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00026607513427734
(414) DESCRIBE `ports` 0.00099396705627441
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00023508071899414
(416) DESCRIBE `ports` 0.00099802017211914
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00027298927307129
(418) DESCRIBE `ports` 0.0010428428649902
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0002591609954834
(420) DESCRIBE `ports` 0.0010020732879639
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.0002739429473877
(422) DESCRIBE `ports` 0.0010039806365967
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00024008750915527
(424) DESCRIBE `ports` 0.00098490715026855
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00028491020202637
(426) DESCRIBE `ports` 0.00096988677978516
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00025200843811035
(428) DESCRIBE `ports` 0.001046895980835
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00026988983154297
(430) DESCRIBE `ports` 0.00098919868469238
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00023698806762695
(432) DESCRIBE `ports` 0.00099706649780273
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00026488304138184
(434) DESCRIBE `ports` 0.00088596343994141
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00022292137145996
(436) DESCRIBE `ports` 0.00086092948913574
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00026202201843262
(438) DESCRIBE `ports` 0.00087904930114746
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00022292137145996
(440) DESCRIBE `ports` 0.0006859302520752
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00019693374633789
(442) DESCRIBE `ports` 0.00070285797119141
(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.0044019222259521
(445) DESCRIBE `avid_specials` 0.00083613395690918
(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.0010991096496582
(447) DESCRIBE `cruiselines` 0.0010402202606201
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00024008750915527
(449) DESCRIBE `orchid_image` 0.00075101852416992
(450) DESCRIBE `cruiselines` 0.0010180473327637
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0002291202545166
(452) DESCRIBE `cruises` 0.0016570091247559
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69034') 0.00025105476379395
(454) DESCRIBE `ships` 0.001323938369751
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.0003058910369873
(456) DESCRIBE `ships` 0.0013868808746338
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00019383430480957
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017809867858887
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016498565673828
(460) DESCRIBE `itineraries` 0.00069785118103027
(461) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69034') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068902969360352
(462) DESCRIBE `ports` 0.001129150390625
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033903121948242
(464) DESCRIBE `ports` 0.00073599815368652
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023508071899414
(466) DESCRIBE `ports` 0.00067901611328125
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019192695617676
(468) DESCRIBE `sailingdates` 0.00060105323791504
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69034') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004270076751709
(470) DESCRIBE `ports` 0.00072193145751953
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021719932556152
(472) DESCRIBE `ports` 0.00072407722473145
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018119812011719
(474) DESCRIBE `ports` 0.00066089630126953
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019502639770508
(476) DESCRIBE `ports` 0.00071215629577637
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017595291137695
(478) DESCRIBE `ports` 0.0006859302520752
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00020718574523926
(480) DESCRIBE `ports` 0.00066804885864258
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00017690658569336
(482) DESCRIBE `ports` 0.00066900253295898
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020194053649902
(484) DESCRIBE `ports` 0.00075411796569824
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00024199485778809
(486) DESCRIBE `ports` 0.00086188316345215
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020003318786621
(488) DESCRIBE `ports` 0.00067901611328125
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017786026000977
(490) DESCRIBE `ports` 0.00066614151000977
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00019502639770508
(492) DESCRIBE `ports` 0.00066208839416504
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00017499923706055
(494) DESCRIBE `ports` 0.00066113471984863
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0001978874206543
(496) DESCRIBE `ports` 0.00065803527832031
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017714500427246
(498) DESCRIBE `ports` 0.00073099136352539
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00019502639770508
(500) DESCRIBE `ports` 0.00066208839416504
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00021886825561523
(502) DESCRIBE `ports` 0.00094795227050781
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00023913383483887
(504) DESCRIBE `ports` 0.00068497657775879
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018000602722168
(506) DESCRIBE `ports` 0.00079989433288574
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.0002589225769043
(508) DESCRIBE `ports` 0.00069189071655273
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00019311904907227
(510) DESCRIBE `ports` 0.0006709098815918
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020313262939453
(512) DESCRIBE `ports` 0.0010170936584473
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00023388862609863
(514) DESCRIBE `ports` 0.00093507766723633
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00026297569274902
(516) DESCRIBE `ports` 0.00090599060058594
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00023889541625977
(518) DESCRIBE `ports` 0.00092697143554688
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00025296211242676
(520) DESCRIBE `ports` 0.0010039806365967
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00026106834411621
(522) DESCRIBE `ports` 0.001039981842041
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028300285339355
(524) DESCRIBE `ports` 0.0010530948638916
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024294853210449
(526) DESCRIBE `ports` 0.0010321140289307
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002739429473877
(528) DESCRIBE `ports` 0.00097203254699707
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026798248291016
(530) DESCRIBE `ports` 0.0010190010070801
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020885467529297
(532) DESCRIBE `ports` 0.00068902969360352
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00019621849060059
(534) DESCRIBE `ports` 0.0006721019744873
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.0001981258392334
(536) DESCRIBE `ports` 0.00066900253295898
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00018906593322754
(538) DESCRIBE `ports` 0.00068402290344238
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.0001988410949707
(540) DESCRIBE `ports` 0.0006709098815918
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.0002288818359375
(542) DESCRIBE `ports` 0.00091385841369629
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00020503997802734
(544) DESCRIBE `ports` 0.00069403648376465
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018787384033203
(546) DESCRIBE `ports` 0.00066518783569336
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00019502639770508
(548) DESCRIBE `ports` 0.00069093704223633
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00019502639770508
(550) DESCRIBE `ports` 0.00067496299743652
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020408630371094
(552) DESCRIBE `ports` 0.00066804885864258
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00020790100097656
(554) DESCRIBE `ports` 0.00066399574279785
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00019693374633789
(556) DESCRIBE `ports` 0.00066804885864258
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00022196769714355
(558) DESCRIBE `ports` 0.00072503089904785
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00019693374633789
(560) DESCRIBE `ports` 0.00066995620727539
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018882751464844
(562) DESCRIBE `ports` 0.00065994262695312
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00019502639770508
(564) DESCRIBE `ports` 0.0006718635559082
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018405914306641
(566) DESCRIBE `ports` 0.00066590309143066
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0001981258392334
(568) DESCRIBE `ports` 0.00065803527832031
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019001960754395
(570) DESCRIBE `ports` 0.00065994262695312
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00018882751464844
(572) DESCRIBE `ports` 0.00065898895263672
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018501281738281
(574) DESCRIBE `ports` 0.0006859302520752
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00018882751464844
(576) DESCRIBE `ports` 0.00074505805969238
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018501281738281
(578) DESCRIBE `ports` 0.00065803527832031
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00019001960754395
(580) DESCRIBE `ports` 0.00065803527832031
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018405914306641
(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.0042450428009033
(583) DESCRIBE `avid_specials` 0.00065803527832031
(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.0010709762573242
(585) DESCRIBE `cruiselines` 0.00097298622131348
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00022506713867188
(587) DESCRIBE `orchid_image` 0.00073981285095215
(588) DESCRIBE `cruiselines` 0.00098395347595215
(589) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00018000602722168
(590) DESCRIBE `cruises` 0.0013179779052734
(591) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68975') 0.0001988410949707
(592) DESCRIBE `ships` 0.001276969909668
(593) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00025296211242676
(594) DESCRIBE `ships` 0.0012907981872559
(595) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00018692016601562
(596) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(597) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001671314239502
(598) DESCRIBE `itineraries` 0.00067496299743652
(599) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68975') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053596496582031
(600) DESCRIBE `ports` 0.0010080337524414
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024986267089844
(602) DESCRIBE `ports` 0.00072908401489258
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021004676818848
(604) DESCRIBE `ports` 0.00067806243896484
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018906593322754
(606) DESCRIBE `sailingdates` 0.00062799453735352
(607) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68975') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043201446533203
(608) DESCRIBE `ports` 0.0010209083557129
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027894973754883
(610) DESCRIBE `ports` 0.0010199546813965
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023698806762695
(612) DESCRIBE `ports` 0.00095510482788086
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026893615722656
(614) DESCRIBE `ports` 0.00095510482788086
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023484230041504
(616) DESCRIBE `ports` 0.00095391273498535
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00027108192443848
(618) DESCRIBE `ports` 0.00096583366394043
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.0002598762512207
(620) DESCRIBE `ports` 0.00098395347595215
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00027203559875488
(622) DESCRIBE `ports` 0.00095891952514648
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00023913383483887
(624) DESCRIBE `ports` 0.00098991394042969
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00026583671569824
(626) DESCRIBE `ports` 0.00097799301147461
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00024199485778809
(628) DESCRIBE `ports` 0.0010049343109131
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00027084350585938
(630) DESCRIBE `ports` 0.00097990036010742
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00023698806762695
(632) DESCRIBE `ports` 0.00097799301147461
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00026106834411621
(634) DESCRIBE `ports` 0.0010039806365967
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00023603439331055
(636) DESCRIBE `ports` 0.00094699859619141
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00026702880859375
(638) DESCRIBE `ports` 0.0010111331939697
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00023198127746582
(640) DESCRIBE `ports` 0.00095295906066895
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00028014183044434
(642) DESCRIBE `ports` 0.00096011161804199
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00023698806762695
(644) DESCRIBE `ports` 0.00097393989562988
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00027680397033691
(646) DESCRIBE `ports` 0.0010008811950684
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00024080276489258
(648) DESCRIBE `ports` 0.00098609924316406
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00026798248291016
(650) DESCRIBE `ports` 0.00099086761474609
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00024008750915527
(652) DESCRIBE `ports` 0.0010011196136475
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00026488304138184
(654) DESCRIBE `ports` 0.00099587440490723
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00025606155395508
(656) DESCRIBE `ports` 0.00097513198852539
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00026488304138184
(658) DESCRIBE `ports` 0.00096297264099121
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00023889541625977
(660) DESCRIBE `ports` 0.0009610652923584
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028085708618164
(662) DESCRIBE `ports` 0.0009918212890625
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023889541625977
(664) DESCRIBE `ports` 0.00098991394042969
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027203559875488
(666) DESCRIBE `ports` 0.00098490715026855
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024104118347168
(668) DESCRIBE `ports` 0.00099015235900879
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026893615722656
(670) DESCRIBE `ports` 0.0009608268737793
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024294853210449
(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.0077869892120361
(673) DESCRIBE `avid_specials` 0.0009148120880127
(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.0017080307006836
(675) DESCRIBE `cruiselines` 0.0014810562133789
(676) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00029897689819336
(677) DESCRIBE `orchid_image` 0.0010750293731689
(678) DESCRIBE `cruiselines` 0.0014200210571289
(679) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00028800964355469
(680) DESCRIBE `cruises` 0.0018999576568604
(681) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69037') 0.00029802322387695
(682) DESCRIBE `ships` 0.0019030570983887
(683) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00037288665771484
(684) DESCRIBE `ships` 0.001471996307373
(685) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00023317337036133
(686) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017905235290527
(687) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016593933105469
(688) DESCRIBE `itineraries` 0.00070309638977051
(689) DESCRIBE `ports` 0.00073719024658203
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022697448730469
(691) DESCRIBE `ports` 0.00069117546081543
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021004676818848
(693) DESCRIBE `ports` 0.0006561279296875
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018906593322754
(695) DESCRIBE `sailingdates` 0.0005950927734375
(696) DESCRIBE `ports` 0.00068998336791992
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022315979003906
(698) DESCRIBE `ports` 0.00067782402038574
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001838207244873
(700) DESCRIBE `ports` 0.000701904296875
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024819374084473
(702) DESCRIBE `ports` 0.00096297264099121
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023698806762695
(704) DESCRIBE `ports` 0.0009920597076416
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026583671569824
(706) DESCRIBE `ports` 0.00097894668579102
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023603439331055
(708) DESCRIBE `ports` 0.00097489356994629
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002748966217041
(710) DESCRIBE `ports` 0.00096678733825684
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00020694732666016
(712) DESCRIBE `ports` 0.00068998336791992
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00021100044250488
(714) DESCRIBE `ports` 0.00075793266296387
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023984909057617
(716) DESCRIBE `ports` 0.00098299980163574
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.0002739429473877
(718) DESCRIBE `ports` 0.00093889236450195
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00025105476379395
(720) DESCRIBE `ports` 0.00096297264099121
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.0002129077911377
(722) DESCRIBE `ports` 0.00070786476135254
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00018501281738281
(724) DESCRIBE `ports` 0.00071096420288086
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00020408630371094
(726) DESCRIBE `ports` 0.00067996978759766
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018405914306641
(728) DESCRIBE `ports` 0.00067591667175293
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00020003318786621
(730) DESCRIBE `ports` 0.00068020820617676
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018310546875
(732) DESCRIBE `ports` 0.00081706047058105
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021600723266602
(734) DESCRIBE `ports` 0.00071001052856445
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018501281738281
(736) DESCRIBE `ports` 0.00067305564880371
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00021004676818848
(738) DESCRIBE `ports` 0.00067901611328125
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00020480155944824
(740) DESCRIBE `ports` 0.00067496299743652
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020217895507812
(742) DESCRIBE `ports` 0.00068783760070801
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018501281738281
(744) DESCRIBE `ports` 0.00069904327392578
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020503997802734
(746) DESCRIBE `ports` 0.00068306922912598
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018906593322754
(748) DESCRIBE `ports` 0.00066995620727539
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020217895507812
(750) DESCRIBE `ports` 0.00067782402038574
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018405914306641
(752) DESCRIBE `ports` 0.0006871223449707
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020003318786621
(754) DESCRIBE `ports` 0.00068092346191406
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018405914306641
(756) DESCRIBE `ports` 0.00081610679626465
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021886825561523
(758) DESCRIBE `ports` 0.00069594383239746
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018787384033203
(760) DESCRIBE `ports` 0.00068998336791992
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00022196769714355
(762) DESCRIBE `ports` 0.00093984603881836
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0002751350402832
(764) DESCRIBE `ports` 0.00096797943115234
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00027704238891602
(766) DESCRIBE `ports` 0.00092101097106934
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00023794174194336
(768) DESCRIBE `ports` 0.00086712837219238
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022101402282715
(770) DESCRIBE `ports` 0.00070405006408691
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0002140998840332
(772) DESCRIBE `ports` 0.00070905685424805
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020313262939453
(774) DESCRIBE `ports` 0.00068211555480957
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00022315979003906
(776) DESCRIBE `ports` 0.0011110305786133
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00024104118347168
(778) DESCRIBE `ports` 0.00073504447937012
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.0001990795135498
(780) DESCRIBE `ports` 0.00072407722473145
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00021505355834961
(782) DESCRIBE `ports` 0.00069499015808105
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00021004676818848
(784) DESCRIBE `ports` 0.00069403648376465
(785) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00023603439331055
(786) DESCRIBE `ports` 0.00070595741271973
(787) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00018906593322754
(788) DESCRIBE `ports` 0.00067806243896484
(789) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00021195411682129
(790) DESCRIBE `ports` 0.00072193145751953
(791) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0002140998840332
(792) DESCRIBE `ports` 0.00069904327392578
(793) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00020313262939453
(794) DESCRIBE `ports` 0.00068402290344238
(795) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00018501281738281
(796) DESCRIBE `ports` 0.00068998336791992
(797) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 634))) 0.00020408630371094
(798) DESCRIBE `ports` 0.00068402290344238
(799) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '634') 0.00018000602722168
(800) DESCRIBE `ports` 0.00068402290344238
(801) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00020790100097656
(802) DESCRIBE `ports` 0.00067901611328125
(803) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.0001838207244873
(804) DESCRIBE `ports` 0.00070691108703613
(805) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00021505355834961
(806) DESCRIBE `ports` 0.00070714950561523
(807) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00019311904907227
(808) DESCRIBE `ports` 0.00076794624328613
(809) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00025391578674316
(810) DESCRIBE `ports` 0.00072312355041504
(811) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00019478797912598
(812) DESCRIBE `ports` 0.0006721019744873
(813) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.0002131462097168
(814) DESCRIBE `ports` 0.00067901611328125
(815) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00018596649169922
(816) DESCRIBE `ports` 0.00069189071655273
(817) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00025796890258789
(818) DESCRIBE `ports` 0.00072884559631348
(819) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00018906593322754
(820) DESCRIBE `ports` 0.00068402290344238
(821) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00021100044250488
(822) DESCRIBE `ports` 0.00068402290344238
(823) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00018405914306641
(824) DESCRIBE `ports` 0.00067710876464844
(825) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00020194053649902
(826) DESCRIBE `ports` 0.00072598457336426
(827) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018405914306641
(828) DESCRIBE `ports` 0.00068402290344238
(829) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020217895507812
(830) DESCRIBE `ports` 0.00068998336791992
(831) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018501281738281
(832) DESCRIBE `ports` 0.00090289115905762
(833) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00027298927307129
(834) DESCRIBE `ports` 0.0009620189666748
(835) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00024700164794922
(836) 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.0044958591461182
(837) DESCRIBE `avid_specials` 0.00073099136352539
(838) 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.0010900497436523
(839) DESCRIBE `cruiselines` 0.00098705291748047
(840) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00022792816162109
(841) DESCRIBE `orchid_image` 0.00074410438537598
(842) DESCRIBE `cruiselines` 0.00094199180603027
(843) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00017905235290527
(844) DESCRIBE `cruises` 0.0013649463653564
(845) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69036') 0.00020599365234375
(846) DESCRIBE `ships` 0.0013031959533691
(847) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00029993057250977
(848) DESCRIBE `ships` 0.001276969909668
(849) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00018787384033203
(850) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018906593322754
(851) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016379356384277
(852) DESCRIBE `itineraries` 0.00066709518432617
(853) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69036') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004429817199707
(854) DESCRIBE `ports` 0.0007319450378418
(855) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021505355834961
(856) DESCRIBE `ports` 0.00067305564880371
(857) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0001990795135498
(858) DESCRIBE `ports` 0.00070309638977051
(859) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(860) DESCRIBE `sailingdates` 0.00060606002807617
(861) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69036') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003960132598877
(862) DESCRIBE `ports` 0.00069403648376465
(863) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0001990795135498
(864) DESCRIBE `ports` 0.00067400932312012
(865) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018191337585449
(866) DESCRIBE `ports` 0.00068306922912598
(867) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020313262939453
(868) DESCRIBE `ports` 0.00067400932312012
(869) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018215179443359
(870) DESCRIBE `ports` 0.00067901611328125
(871) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019693374633789
(872) DESCRIBE `ports` 0.00068497657775879
(873) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(874) DESCRIBE `ports` 0.00067996978759766
(875) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020003318786621
(876) DESCRIBE `ports` 0.00069999694824219
(877) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018191337585449
(878) DESCRIBE `ports` 0.00067305564880371
(879) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0001978874206543
(880) DESCRIBE `ports` 0.00067496299743652
(881) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00020885467529297
(882) DESCRIBE `ports` 0.00067019462585449
(883) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.0001990795135498
(884) DESCRIBE `ports` 0.00067281723022461
(885) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00018501281738281
(886) DESCRIBE `ports` 0.00069403648376465
(887) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00020194053649902
(888) DESCRIBE `ports` 0.00067615509033203
(889) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00018095970153809
(890) DESCRIBE `ports` 0.0006709098815918
(891) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00019693374633789
(892) DESCRIBE `ports` 0.00069904327392578
(893) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018119812011719
(894) DESCRIBE `ports` 0.00067305564880371
(895) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.0001978874206543
(896) DESCRIBE `ports` 0.0007169246673584
(897) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018095970153809
(898) DESCRIBE `ports` 0.00072216987609863
(899) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021481513977051
(900) DESCRIBE `ports` 0.00067591667175293
(901) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018215179443359
(902) DESCRIBE `ports` 0.00070595741271973
(903) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020098686218262
(904) DESCRIBE `ports` 0.00068998336791992
(905) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018095970153809
(906) DESCRIBE `ports` 0.00071406364440918
(907) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00021505355834961
(908) DESCRIBE `ports` 0.00067496299743652
(909) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019598007202148
(910) DESCRIBE `ports` 0.00066995620727539
(911) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00019693374633789
(912) DESCRIBE `ports` 0.00073504447937012
(913) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018095970153809
(914) DESCRIBE `ports` 0.00068902969360352
(915) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020599365234375
(916) DESCRIBE `ports` 0.00076198577880859
(917) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00034809112548828
(918) DESCRIBE `ports` 0.00086212158203125
(919) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002281665802002
(920) DESCRIBE `ports` 0.00072288513183594
(921) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018715858459473
(922) DESCRIBE `ports` 0.00071597099304199
(923) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021886825561523
(924) DESCRIBE `ports` 0.00070285797119141
(925) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00019097328186035
(926) DESCRIBE `ports` 0.0006868839263916
(927) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0002131462097168
(928) DESCRIBE `ports` 0.00068902969360352
(929) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020194053649902
(930) DESCRIBE `ports` 0.00071597099304199
(931) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00020503997802734
(932) DESCRIBE `ports` 0.00069284439086914
(933) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00018596649169922
(934) DESCRIBE `ports` 0.00067710876464844
(935) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020503997802734
(936) DESCRIBE `ports` 0.00069308280944824
(937) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019001960754395
(938) DESCRIBE `ports` 0.00069999694824219
(939) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021791458129883
(940) DESCRIBE `ports` 0.00073814392089844
(941) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00046300888061523
(942) DESCRIBE `ports` 0.00092983245849609
(943) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00022792816162109
(944) DESCRIBE `ports` 0.00069379806518555
(945) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00018692016601562
(946) DESCRIBE `ports` 0.00071501731872559
(947) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00020503997802734
(948) DESCRIBE `ports` 0.00069284439086914
(949) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.0001838207244873
(950) DESCRIBE `ports` 0.00067400932312012
(951) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00021195411682129
(952) DESCRIBE `ports` 0.00067996978759766
(953) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00019001960754395
(954) DESCRIBE `ports` 0.00073504447937012
(955) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020599365234375
(956) DESCRIBE `ports` 0.00067615509033203
(957) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018405914306641
(958) DESCRIBE `ports` 0.00068807601928711
(959) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0001988410949707
(960) DESCRIBE `ports` 0.00066995620727539
(961) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018310546875
(962) DESCRIBE `ports` 0.00066709518432617
(963) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020289421081543
(964) DESCRIBE `ports` 0.00071501731872559
(965) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018715858459473
(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.004464864730835
(967) DESCRIBE `avid_specials` 0.00075387954711914
(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.0011460781097412
(969) DESCRIBE `cruiselines` 0.0010919570922852
(970) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00022482872009277
(971) DESCRIBE `orchid_image` 0.00079512596130371
(972) DESCRIBE `cruiselines` 0.0009620189666748
(973) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00019097328186035
(974) DESCRIBE `cruises` 0.0018851757049561
(975) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68976') 0.00028586387634277
(976) DESCRIBE `ships` 0.0019118785858154
(977) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.0003659725189209
(978) DESCRIBE `ships` 0.0019090175628662
(979) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00024604797363281
(980) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024580955505371
(981) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021791458129883
(982) DESCRIBE `itineraries` 0.00069689750671387
(983) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68976') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042200088500977
(984) DESCRIBE `ports` 0.00078105926513672
(985) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023603439331055
(986) DESCRIBE `ports` 0.00069212913513184
(987) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020694732666016
(988) DESCRIBE `ports` 0.00068497657775879
(989) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019502639770508
(990) DESCRIBE `sailingdates` 0.00061202049255371
(991) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68976') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047707557678223
(992) DESCRIBE `ports` 0.00071597099304199
(993) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022006034851074
(994) DESCRIBE `ports` 0.0006859302520752
(995) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019097328186035
(996) DESCRIBE `ports` 0.00067806243896484
(997) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021100044250488
(998) DESCRIBE `ports` 0.00099897384643555
(999) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026392936706543
(1000) DESCRIBE `ports` 0.0010230541229248
(1001) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024604797363281
(1002) DESCRIBE `ports` 0.00072503089904785
(1003) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00021600723266602
(1004) DESCRIBE `ports` 0.00071382522583008
(1005) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00022006034851074
(1006) DESCRIBE `ports` 0.00069499015808105
(1007) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00019383430480957
(1008) DESCRIBE `ports` 0.00069212913513184
(1009) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00022006034851074
(1010) DESCRIBE `ports` 0.00073504447937012
(1011) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0001981258392334
(1012) DESCRIBE `ports` 0.00068902969360352
(1013) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00027298927307129
(1014) DESCRIBE `ports` 0.00072193145751953
(1015) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00019192695617676
(1016) DESCRIBE `ports` 0.00090789794921875
(1017) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00025486946105957
(1018) DESCRIBE `ports` 0.00095820426940918
(1019) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00027108192443848
(1020) DESCRIBE `ports` 0.00095987319946289
(1021) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00027012825012207
(1022) DESCRIBE `ports` 0.00089597702026367
(1023) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00020313262939453
(1024) DESCRIBE `ports` 0.00069594383239746
(1025) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.0002131462097168
(1026) DESCRIBE `ports` 0.00068402290344238
(1027) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00019192695617676
(1028) DESCRIBE `ports` 0.00067710876464844
(1029) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00023198127746582
(1030) DESCRIBE `ports` 0.00068306922912598
(1031) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00019216537475586
(1032) DESCRIBE `ports` 0.00067996978759766
(1033) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.000244140625
(1034) DESCRIBE `ports` 0.0010139942169189
(1035) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0002140998840332
(1036) DESCRIBE `ports` 0.00069808959960938
(1037) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00022006034851074
(1038) DESCRIBE `ports` 0.00068783760070801
(1039) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019192695617676
(1040) DESCRIBE `ports` 0.00069904327392578
(1041) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020599365234375
(1042) DESCRIBE `ports` 0.00068187713623047
(1043) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018978118896484
(1044) DESCRIBE `ports` 0.00068306922912598
(1045) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00024604797363281
(1046) DESCRIBE `ports` 0.00067901611328125
(1047) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019097328186035
(1048) DESCRIBE `ports` 0.00067305564880371
(1049) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021004676818848
(1050) DESCRIBE `ports` 0.00070476531982422
(1051) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019407272338867
(1052) DESCRIBE `ports` 0.00067400932312012
(1053) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021600723266602
(1054) DESCRIBE `ports` 0.00075101852416992
(1055) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025677680969238
(1056) DESCRIBE `ports` 0.00089287757873535
(1057) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002601146697998
(1058) DESCRIBE `ports` 0.00081205368041992
(1059) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00020813941955566
(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.0043230056762695
(1061) DESCRIBE `avid_specials` 0.00078892707824707
(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.0011148452758789
(1063) DESCRIBE `cruiselines` 0.0010149478912354
(1064) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00023102760314941
(1065) DESCRIBE `orchid_image` 0.00075507164001465
(1066) DESCRIBE `cruiselines` 0.000946044921875
(1067) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00020694732666016
(1068) DESCRIBE `cruises` 0.0014958381652832
(1069) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69035') 0.00032806396484375
(1070) DESCRIBE `ships` 0.0015828609466553
(1071) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.0003049373626709
(1072) DESCRIBE `ships` 0.0014040470123291
(1073) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00021004676818848
(1074) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017499923706055
(1075) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016593933105469
(1076) DESCRIBE `itineraries` 0.00073981285095215
(1077) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69035') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066399574279785
(1078) DESCRIBE `ports` 0.00085306167602539
(1079) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00024700164794922
(1080) DESCRIBE `ports` 0.00071191787719727
(1081) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020790100097656
(1082) DESCRIBE `ports` 0.0007021427154541
(1083) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00020599365234375
(1084) DESCRIBE `sailingdates` 0.00063586235046387
(1085) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69035') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043702125549316
(1086) DESCRIBE `ports` 0.00081992149353027
(1087) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00024509429931641
(1088) DESCRIBE `ports` 0.00072407722473145
(1089) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00020599365234375
(1090) DESCRIBE `ports` 0.00073003768920898
(1091) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002138614654541
(1092) DESCRIBE `ports` 0.00069212913513184
(1093) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019598007202148
(1094) DESCRIBE `ports` 0.00070309638977051
(1095) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0002129077911377
(1096) DESCRIBE `ports` 0.0009920597076416
(1097) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00024509429931641
(1098) DESCRIBE `ports` 0.00076818466186523
(1099) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030612945556641
(1100) DESCRIBE `ports` 0.00072789192199707
(1101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00022315979003906
(1102) DESCRIBE `ports` 0.00073003768920898
(1103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00023102760314941
(1104) DESCRIBE `ports` 0.000762939453125
(1105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00019001960754395
(1106) DESCRIBE `ports` 0.00067400932312012
(1107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00021100044250488
(1108) DESCRIBE `ports` 0.00072407722473145
(1109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00018715858459473
(1110) DESCRIBE `ports` 0.00068211555480957
(1111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020885467529297
(1112) DESCRIBE `ports` 0.00069212913513184
(1113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00025701522827148
(1114) DESCRIBE `ports` 0.0010662078857422
(1115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00029897689819336
(1116) DESCRIBE `ports` 0.0010671615600586
(1117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00026416778564453
(1118) DESCRIBE `ports` 0.00098586082458496
(1119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00026297569274902
(1120) DESCRIBE `ports` 0.0010218620300293
(1121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00024890899658203
(1122) DESCRIBE `ports` 0.0010130405426025
(1123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00027799606323242
(1124) DESCRIBE `ports` 0.00096988677978516
(1125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00025200843811035
(1126) DESCRIBE `ports` 0.00074100494384766
(1127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00023317337036133
(1128) DESCRIBE `ports` 0.0006871223449707
(1129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00019097328186035
(1130) DESCRIBE `ports` 0.00070095062255859
(1131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00023102760314941
(1132) DESCRIBE `ports` 0.00076699256896973
(1133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019097328186035
(1134) DESCRIBE `ports` 0.0006711483001709
(1135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00020909309387207
(1136) DESCRIBE `ports` 0.00067710876464844
(1137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00020003318786621
(1138) DESCRIBE `ports` 0.00069808959960938
(1139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 634))) 0.00020694732666016
(1140) DESCRIBE `ports` 0.00070500373840332
(1141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '634') 0.0001828670501709
(1142) DESCRIBE `ports` 0.00069093704223633
(1143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00020194053649902
(1144) DESCRIBE `ports` 0.00067400932312012
(1145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00028896331787109
(1146) DESCRIBE `ports` 0.0009009838104248
(1147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00029897689819336
(1148) DESCRIBE `ports` 0.00073003768920898
(1149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00020408630371094
(1150) DESCRIBE `ports` 0.00069308280944824
(1151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00021219253540039
(1152) DESCRIBE `ports` 0.00072598457336426
(1153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0001981258392334
(1154) DESCRIBE `ports` 0.00069689750671387
(1155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00021719932556152
(1156) DESCRIBE `ports` 0.00074291229248047
(1157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00020003318786621
(1158) DESCRIBE `ports` 0.00071597099304199
(1159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00021004676818848
(1160) DESCRIBE `ports` 0.00071501731872559
(1161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00018596649169922
(1162) DESCRIBE `ports` 0.00070095062255859
(1163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00020813941955566
(1164) DESCRIBE `ports` 0.00068497657775879
(1165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00018596649169922
(1166) DESCRIBE `ports` 0.00071191787719727
(1167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00020408630371094
(1168) DESCRIBE `ports` 0.00069499015808105
(1169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018310546875
(1170) DESCRIBE `ports` 0.00068306922912598
(1171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020503997802734
(1172) DESCRIBE `ports` 0.00066900253295898
(1173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018405914306641
(1174) DESCRIBE `ports` 0.00069499015808105
(1175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020599365234375
(1176) DESCRIBE `ports` 0.00068497657775879
(1177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018310546875
(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.0044388771057129
(1179) DESCRIBE `avid_specials` 0.00081992149353027
(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.0012660026550293
(1181) DESCRIBE `cruiselines` 0.0010819435119629
(1182) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00025510787963867
(1183) DESCRIBE `orchid_image` 0.00078916549682617
(1184) DESCRIBE `cruiselines` 0.0010299682617188
(1185) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00021982192993164
(1186) DESCRIBE `ships` 0.0015430450439453
(1187) SELECT `ships`.* FROM `ships` WHERE (id IN ('823')) ORDER BY FIND_IN_SET(id, '823') 0.00030803680419922
(1188) DESCRIBE `cruisetypes` 0.00062108039855957
(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.024881839752197
(1190) DESCRIBE `destinations` 0.0011749267578125
(1191) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '28', '49', '21', '25')) ORDER BY FIND_IN_SET(id, '22,28,49,21,25') 0.00055098533630371
(1192) DESCRIBE `cruiselines` 0.0011200904846191
(1193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0002589225769043
(1194) DESCRIBE `cruiselines` 0.0012428760528564
(1195) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0002741813659668