or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  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: 1214

Total elapsed time: 0.67357707023621

# Query Time
(1) connect 0.00057601928710938
(2) DESCRIBE `cruises` 0.0018219947814941
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68973, 69033, 68974, 68974, 72411, 69034, 69034, 68975, 69037, 69036)) ORDER BY FIND_IN_SET(id, '68973,69033,68974,68974,72411,69034,69034,68975,69037,69036') 0.0013351440429688
(4) DESCRIBE `cruises` 0.0021381378173828
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68973') 0.00024509429931641
(6) DESCRIBE `ships` 0.0011792182922363
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.0002291202545166
(8) DESCRIBE `ships` 0.0011341571807861
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00015616416931152
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015401840209961
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016307830810547
(12) DESCRIBE `itineraries` 0.00079107284545898
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68973') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070500373840332
(14) DESCRIBE `ports` 0.00060915946960449
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00018119812011719
(16) DESCRIBE `ports` 0.00058412551879883
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00018095970153809
(18) DESCRIBE `ports` 0.00058078765869141
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00015497207641602
(20) DESCRIBE `sailingdates` 0.00052309036254883
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68973') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047993659973145
(22) DESCRIBE `ports` 0.00062298774719238
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00017094612121582
(24) DESCRIBE `ports` 0.00064706802368164
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00015401840209961
(26) DESCRIBE `ports` 0.0005791187286377
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0001671314239502
(28) DESCRIBE `ports` 0.00060009956359863
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001530647277832
(30) DESCRIBE `ports` 0.0005958080291748
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 374))) 0.00019502639770508
(32) DESCRIBE `ports` 0.00058913230895996
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '374') 0.0001528263092041
(34) DESCRIBE `ports` 0.00057411193847656
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00016689300537109
(36) DESCRIBE `ports` 0.0005791187286377
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00017094612121582
(38) DESCRIBE `ports` 0.00061297416687012
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019311904907227
(40) DESCRIBE `ports` 0.00060415267944336
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00016307830810547
(42) DESCRIBE `ports` 0.00057291984558105
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00016903877258301
(44) DESCRIBE `ports` 0.00057411193847656
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.0002140998840332
(46) DESCRIBE `ports` 0.0010659694671631
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00026297569274902
(48) DESCRIBE `ports` 0.00068402290344238
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018906593322754
(50) DESCRIBE `ports` 0.00095701217651367
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00027799606323242
(52) DESCRIBE `ports` 0.00073385238647461
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00018596649169922
(54) DESCRIBE `ports` 0.00070285797119141
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4402))) 0.00025582313537598
(56) DESCRIBE `ports` 0.00083518028259277
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4402') 0.00022101402282715
(58) DESCRIBE `ports` 0.00076198577880859
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00022602081298828
(60) DESCRIBE `ports` 0.00069499015808105
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00018501281738281
(62) DESCRIBE `ports` 0.00070095062255859
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3183))) 0.00022196769714355
(64) DESCRIBE `ports` 0.00069117546081543
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3183') 0.00019693374633789
(66) DESCRIBE `ports` 0.00082302093505859
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.00020289421081543
(68) DESCRIBE `ports` 0.00072288513183594
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00018000602722168
(70) DESCRIBE `ports` 0.00088715553283691
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00022602081298828
(72) DESCRIBE `ports` 0.00078606605529785
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00019097328186035
(74) DESCRIBE `ports` 0.00093579292297363
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021195411682129
(76) DESCRIBE `ports` 0.00081300735473633
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019598007202148
(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.0079741477966309
(79) DESCRIBE `avid_specials` 0.00085902214050293
(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.0013659000396729
(81) DESCRIBE `cruiselines` 0.0014748573303223
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00028896331787109
(83) DESCRIBE `orchid_image` 0.00072097778320312
(84) DESCRIBE `cruiselines` 0.0011289119720459
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00017118453979492
(86) DESCRIBE `cruises` 0.0013959407806396
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69033') 0.00018906593322754
(88) DESCRIBE `ships` 0.0012199878692627
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00022101402282715
(90) DESCRIBE `ships` 0.0013110637664795
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00016403198242188
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015997886657715
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015401840209961
(94) DESCRIBE `itineraries` 0.00071001052856445
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045299530029297
(96) DESCRIBE `ports` 0.00080299377441406
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00025701522827148
(98) DESCRIBE `ports` 0.00060415267944336
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00017690658569336
(100) DESCRIBE `ports` 0.00067901611328125
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00016188621520996
(102) DESCRIBE `sailingdates` 0.00064396858215332
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048208236694336
(104) DESCRIBE `ports` 0.00075411796569824
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00018000602722168
(106) DESCRIBE `ports` 0.00060105323791504
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00016307830810547
(108) DESCRIBE `ports` 0.00067877769470215
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0001838207244873
(110) DESCRIBE `ports` 0.0010340213775635
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00016403198242188
(112) DESCRIBE `ports` 0.00062298774719238
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00017499923706055
(114) DESCRIBE `ports` 0.00080299377441406
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019288063049316
(116) DESCRIBE `ports` 0.00060105323791504
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00017619132995605
(118) DESCRIBE `ports` 0.00067996978759766
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.00016021728515625
(120) DESCRIBE `ports` 0.00070381164550781
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001828670501709
(122) DESCRIBE `ports` 0.00059819221496582
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00015997886657715
(124) DESCRIBE `ports` 0.00068807601928711
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00018501281738281
(126) DESCRIBE `ports` 0.00066399574279785
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00015902519226074
(128) DESCRIBE `ports` 0.00058889389038086
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4402))) 0.00017499923706055
(130) DESCRIBE `ports` 0.00078892707824707
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4402') 0.00016403198242188
(132) DESCRIBE `ports` 0.00059604644775391
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00019598007202148
(134) DESCRIBE `ports` 0.00068402290344238
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00015902519226074
(136) DESCRIBE `ports` 0.0006861686706543
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3183))) 0.00018692016601562
(138) DESCRIBE `ports` 0.00058889389038086
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3183') 0.00016117095947266
(140) DESCRIBE `ports` 0.00077199935913086
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.00017905235290527
(142) DESCRIBE `ports` 0.00062108039855957
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00015807151794434
(144) DESCRIBE `ports` 0.00058412551879883
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00018215179443359
(146) DESCRIBE `ports` 0.00070095062255859
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027012825012207
(148) DESCRIBE `ports` 0.00061702728271484
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00018000602722168
(150) DESCRIBE `ports` 0.00062108039855957
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00015902519226074
(152) DESCRIBE `ports` 0.00069499015808105
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00021982192993164
(154) DESCRIBE `ports` 0.0006401538848877
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00015807151794434
(156) DESCRIBE `ports` 0.00078392028808594
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00017595291137695
(158) DESCRIBE `ports` 0.00059294700622559
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00017189979553223
(160) DESCRIBE `ports` 0.00067400932312012
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.00018000602722168
(162) DESCRIBE `ports` 0.00058984756469727
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00016689300537109
(164) DESCRIBE `ports` 0.00066399574279785
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00023007392883301
(166) DESCRIBE `ports` 0.00081396102905273
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00019598007202148
(168) DESCRIBE `ports` 0.00061702728271484
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00017309188842773
(170) DESCRIBE `ports` 0.00058889389038086
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00016689300537109
(172) DESCRIBE `ports` 0.00075292587280273
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00017213821411133
(174) DESCRIBE `ports` 0.00059914588928223
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00015783309936523
(176) DESCRIBE `ports` 0.00059008598327637
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00019598007202148
(178) DESCRIBE `ports` 0.00073599815368652
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00016212463378906
(180) DESCRIBE `ports` 0.00061392784118652
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00017499923706055
(182) DESCRIBE `ports` 0.00066995620727539
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00016403198242188
(184) DESCRIBE `ports` 0.00059294700622559
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017595291137695
(186) DESCRIBE `ports` 0.00075817108154297
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016188621520996
(188) DESCRIBE `ports` 0.00058889389038086
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018000602722168
(190) DESCRIBE `ports` 0.00063705444335938
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018477439880371
(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.004626989364624
(193) DESCRIBE `avid_specials` 0.00061392784118652
(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.00094699859619141
(195) DESCRIBE `cruiselines` 0.0011129379272461
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0001981258392334
(197) DESCRIBE `orchid_image` 0.00070095062255859
(198) DESCRIBE `cruiselines` 0.001183032989502
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0001828670501709
(200) DESCRIBE `specials` 0.0022048950195312
(201) SELECT `specials`.* FROM `specials` WHERE (id = '1381997') AND (specials.orchid_available = 1) LIMIT 1 0.00036001205444336
(202) DESCRIBE `specials` 0.001967191696167
(203) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1381997') 0.0001828670501709
(204) DESCRIBE `ships` 0.0014448165893555
(205) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00024890899658203
(206) DESCRIBE `ships` 0.001410961151123
(207) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00018501281738281
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016403198242188
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015115737915039
(210) DESCRIBE `itineraries` 0.00075697898864746
(211) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68974') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048089027404785
(212) DESCRIBE `ports` 0.00097799301147461
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00024986267089844
(214) DESCRIBE `ports` 0.00059890747070312
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019502639770508
(216) DESCRIBE `ports` 0.00097179412841797
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00023293495178223
(218) DESCRIBE `specialsailingdates` 0.0005958080291748
(219) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1381997') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00051093101501465
(220) DESCRIBE `sailingdates` 0.00064897537231445
(221) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 433072))) 0.00021100044250488
(222) DESCRIBE `ports` 0.00072407722473145
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021600723266602
(224) DESCRIBE `ports` 0.00071907043457031
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019598007202148
(226) DESCRIBE `ports` 0.0006871223449707
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020480155944824
(228) DESCRIBE `ports` 0.00068402290344238
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019407272338867
(230) DESCRIBE `ports` 0.00070309638977051
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020790100097656
(232) DESCRIBE `ports` 0.00069499015808105
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018906593322754
(234) DESCRIBE `ports` 0.00068187713623047
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00024199485778809
(236) DESCRIBE `ports` 0.00068187713623047
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00018310546875
(238) DESCRIBE `ports` 0.0006711483001709
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00021195411682129
(240) DESCRIBE `ports` 0.000701904296875
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018692016601562
(242) DESCRIBE `ports` 0.00082015991210938
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.0002601146697998
(244) DESCRIBE `ports` 0.00069689750671387
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00018906593322754
(246) DESCRIBE `ports` 0.00071501731872559
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00021195411682129
(248) DESCRIBE `ports` 0.00068092346191406
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018692016601562
(250) DESCRIBE `ports` 0.00067901611328125
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00025606155395508
(252) DESCRIBE `ports` 0.00069904327392578
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018906593322754
(254) DESCRIBE `ports` 0.00068402290344238
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00021791458129883
(256) DESCRIBE `ports` 0.00072312355041504
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018596649169922
(258) DESCRIBE `ports` 0.0006709098815918
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00024604797363281
(260) DESCRIBE `ports` 0.00068283081054688
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018405914306641
(262) DESCRIBE `ports` 0.00068998336791992
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.0002598762512207
(264) DESCRIBE `ports` 0.00067806243896484
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00018501281738281
(266) DESCRIBE `ports` 0.00069189071655273
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020289421081543
(268) DESCRIBE `ports` 0.00068783760070801
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018715858459473
(270) DESCRIBE `ports` 0.00068497657775879
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020313262939453
(272) DESCRIBE `ports` 0.00070500373840332
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(274) DESCRIBE `cruises` 0.0016050338745117
(275) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68974))) 0.00031900405883789
(276) DESCRIBE `avid_specials` 0.00070786476135254
(277) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1381997 and class = 'Special') OR (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.0010218620300293
(278) DESCRIBE `cruiselines` 0.00096917152404785
(279) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00023603439331055
(280) DESCRIBE `orchid_image` 0.00078701972961426
(281) DESCRIBE `cruiselines` 0.00097799301147461
(282) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00024986267089844
(283) DESCRIBE `cruises` 0.0014309883117676
(284) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68974') 0.00024890899658203
(285) DESCRIBE `ships` 0.0014019012451172
(286) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00029087066650391
(287) DESCRIBE `ships` 0.0015242099761963
(288) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00020217895507812
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018882751464844
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017213821411133
(291) DESCRIBE `itineraries` 0.00073099136352539
(292) DESCRIBE `ports` 0.0007178783416748
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00025296211242676
(294) DESCRIBE `ports` 0.0006859302520752
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020217895507812
(296) DESCRIBE `ports` 0.00070905685424805
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019288063049316
(298) DESCRIBE `sailingdates` 0.00060892105102539
(299) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68974') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041580200195312
(300) DESCRIBE `ports` 0.00075411796569824
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002288818359375
(302) DESCRIBE `ports` 0.00071501731872559
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020098686218262
(304) DESCRIBE `ports` 0.00072193145751953
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002140998840332
(306) DESCRIBE `ports` 0.00067400932312012
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018692016601562
(308) DESCRIBE `ports` 0.00067996978759766
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020813941955566
(310) DESCRIBE `ports` 0.00069904327392578
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018501281738281
(312) DESCRIBE `ports` 0.00067615509033203
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00020289421081543
(314) DESCRIBE `ports` 0.00073909759521484
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00018692016601562
(316) DESCRIBE `ports` 0.00067687034606934
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00020503997802734
(318) DESCRIBE `ports` 0.00073790550231934
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018811225891113
(320) DESCRIBE `ports` 0.00069999694824219
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.00020885467529297
(322) DESCRIBE `ports` 0.00071191787719727
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00018787384033203
(324) DESCRIBE `ports` 0.00067400932312012
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00022697448730469
(326) DESCRIBE `ports` 0.00071001052856445
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018978118896484
(328) DESCRIBE `ports` 0.00069594383239746
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020003318786621
(330) DESCRIBE `ports` 0.0006859302520752
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018620491027832
(332) DESCRIBE `ports` 0.00068092346191406
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020408630371094
(334) DESCRIBE `ports` 0.00068497657775879
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00019001960754395
(336) DESCRIBE `ports` 0.0007011890411377
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021505355834961
(338) DESCRIBE `ports` 0.00069189071655273
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00019383430480957
(340) DESCRIBE `ports` 0.00068092346191406
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00022387504577637
(342) DESCRIBE `ports` 0.00069284439086914
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00018787384033203
(344) DESCRIBE `ports` 0.00068402290344238
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020503997802734
(346) DESCRIBE `ports` 0.00068092346191406
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019001960754395
(348) DESCRIBE `ports` 0.00073003768920898
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020408630371094
(350) DESCRIBE `ports` 0.00071501731872559
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018692016601562
(352) 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.0054740905761719
(353) DESCRIBE `avid_specials` 0.0010368824005127
(354) 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.0010850429534912
(355) DESCRIBE `cruiselines` 0.0010290145874023
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00024008750915527
(357) DESCRIBE `orchid_image` 0.00078201293945312
(358) DESCRIBE `cruiselines` 0.0012390613555908
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00021696090698242
(360) DESCRIBE `cruises` 0.0017790794372559
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72411') 0.0002751350402832
(362) DESCRIBE `ships` 0.0015671253204346
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00027298927307129
(364) DESCRIBE `ships` 0.0015039443969727
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0002291202545166
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020599365234375
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017094612121582
(368) DESCRIBE `itineraries` 0.00073409080505371
(369) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72411') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00076389312744141
(370) DESCRIBE `ports` 0.0009770393371582
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029206275939941
(372) DESCRIBE `ports` 0.00073885917663574
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020599365234375
(374) DESCRIBE `ports` 0.00067996978759766
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019288063049316
(376) DESCRIBE `sailingdates` 0.00061583518981934
(377) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72411') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062108039855957
(378) DESCRIBE `ports` 0.0011000633239746
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026297569274902
(380) DESCRIBE `ports` 0.0007178783416748
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019717216491699
(382) DESCRIBE `ports` 0.0006861686706543
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020408630371094
(384) DESCRIBE `ports` 0.0007021427154541
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019288063049316
(386) DESCRIBE `ports` 0.00089192390441895
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00020694732666016
(388) DESCRIBE `ports` 0.00067782402038574
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00018501281738281
(390) DESCRIBE `ports` 0.00070905685424805
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020813941955566
(392) DESCRIBE `ports` 0.00086808204650879
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018501281738281
(394) DESCRIBE `ports` 0.00074505805969238
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00021600723266602
(396) DESCRIBE `ports` 0.00066995620727539
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018310546875
(398) DESCRIBE `ports` 0.0007021427154541
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.0002129077911377
(400) DESCRIBE `ports` 0.00090789794921875
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00025105476379395
(402) DESCRIBE `ports` 0.0007479190826416
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020718574523926
(404) DESCRIBE `ports` 0.0007021427154541
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018405914306641
(406) DESCRIBE `ports` 0.00092792510986328
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00021600723266602
(408) DESCRIBE `ports` 0.00067996978759766
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00018405914306641
(410) DESCRIBE `ports` 0.00072383880615234
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00020098686218262
(412) DESCRIBE `ports` 0.00072002410888672
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018477439880371
(414) DESCRIBE `ports` 0.00070691108703613
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00020217895507812
(416) DESCRIBE `ports` 0.0006721019744873
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00023198127746582
(418) DESCRIBE `ports` 0.00067400932312012
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020194053649902
(420) DESCRIBE `ports` 0.00067400932312012
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00018215179443359
(422) DESCRIBE `ports` 0.00070095062255859
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0001990795135498
(424) DESCRIBE `ports` 0.00067400932312012
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00018405914306641
(426) DESCRIBE `ports` 0.00066995620727539
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020098686218262
(428) DESCRIBE `ports` 0.00081992149353027
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00018906593322754
(430) DESCRIBE `ports` 0.00069999694824219
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(432) DESCRIBE `ports` 0.00067400932312012
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018405914306641
(434) DESCRIBE `ports` 0.00066590309143066
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00023508071899414
(436) DESCRIBE `ports` 0.00066900253295898
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018191337585449
(438) DESCRIBE `ports` 0.00065994262695312
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0001988410949707
(440) DESCRIBE `ports` 0.00068402290344238
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018310546875
(442) DESCRIBE `ports` 0.00066804885864258
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00020003318786621
(444) DESCRIBE `ports` 0.00066614151000977
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00018215179443359
(446) DESCRIBE `ports` 0.00092482566833496
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00026988983154297
(448) DESCRIBE `ports` 0.0007021427154541
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00019001960754395
(450) DESCRIBE `ports` 0.00069189071655273
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00019979476928711
(452) DESCRIBE `ports` 0.00066900253295898
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018191337585449
(454) DESCRIBE `ports` 0.0006718635559082
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00020003318786621
(456) DESCRIBE `ports` 0.00078010559082031
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018215179443359
(458) DESCRIBE `ports` 0.0006709098815918
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020003318786621
(460) DESCRIBE `ports` 0.00068211555480957
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018095970153809
(462) DESCRIBE `ports` 0.00075507164001465
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020909309387207
(464) DESCRIBE `ports` 0.0006709098815918
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018191337585449
(466) DESCRIBE `ports` 0.00069808959960938
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020194053649902
(468) DESCRIBE `ports` 0.00066995620727539
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018405914306641
(470) DESCRIBE `ports` 0.0006859302520752
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020098686218262
(472) DESCRIBE `ports` 0.00066995620727539
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018310546875
(474) DESCRIBE `ports` 0.00067496299743652
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020813941955566
(476) DESCRIBE `ports` 0.00067019462585449
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018215179443359
(478) DESCRIBE `ports` 0.00066781044006348
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020790100097656
(480) DESCRIBE `ports` 0.00066399574279785
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018191337585449
(482) DESCRIBE `ports` 0.00068902969360352
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00020122528076172
(484) DESCRIBE `ports` 0.00066781044006348
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00020503997802734
(486) DESCRIBE `ports` 0.00066900253295898
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021791458129883
(488) DESCRIBE `ports` 0.00067496299743652
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018310546875
(490) DESCRIBE `ports` 0.00066995620727539
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00020217895507812
(492) DESCRIBE `ports` 0.00068497657775879
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00018405914306641
(494) DESCRIBE `ports` 0.00066804885864258
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020217895507812
(496) DESCRIBE `ports` 0.00070786476135254
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018405914306641
(498) DESCRIBE `ports` 0.00072002410888672
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00026202201843262
(500) DESCRIBE `ports` 0.00095009803771973
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00020003318786621
(502) DESCRIBE `ports` 0.00069499015808105
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00021195411682129
(504) DESCRIBE `ports` 0.00067281723022461
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00018596649169922
(506) DESCRIBE `ports` 0.00067496299743652
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00020503997802734
(508) DESCRIBE `ports` 0.00070500373840332
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00018405914306641
(510) DESCRIBE `ports` 0.0006711483001709
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00020694732666016
(512) DESCRIBE `ports` 0.00072097778320312
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00018405914306641
(514) DESCRIBE `ports` 0.0006721019744873
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020408630371094
(516) DESCRIBE `ports` 0.00066995620727539
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018501281738281
(518) DESCRIBE `ports` 0.00070285797119141
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0001990795135498
(520) DESCRIBE `ports` 0.00066709518432617
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018596649169922
(522) DESCRIBE `ports` 0.00068807601928711
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00022602081298828
(524) DESCRIBE `ports` 0.00067305564880371
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0001838207244873
(526) 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.005234956741333
(527) DESCRIBE `avid_specials` 0.00074505805969238
(528) 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.0010969638824463
(529) DESCRIBE `cruiselines` 0.0010130405426025
(530) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00026321411132812
(531) DESCRIBE `orchid_image` 0.0007929801940918
(532) DESCRIBE `cruiselines` 0.0011007785797119
(533) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00020909309387207
(534) DESCRIBE `specials` 0.0030620098114014
(535) SELECT `specials`.* FROM `specials` WHERE (id = '1382003') AND (specials.orchid_available = 1) LIMIT 1 0.00055599212646484
(536) DESCRIBE `specials` 0.0028741359710693
(537) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1382003') 0.00034189224243164
(538) DESCRIBE `ships` 0.0019769668579102
(539) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00038003921508789
(540) DESCRIBE `ships` 0.0018329620361328
(541) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00025796890258789
(542) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021791458129883
(543) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020813941955566
(544) DESCRIBE `itineraries` 0.00096511840820312
(545) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69034') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063705444335938
(546) DESCRIBE `ports` 0.00076699256896973
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022196769714355
(548) DESCRIBE `ports` 0.00060296058654785
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017786026000977
(550) DESCRIBE `ports` 0.00063705444335938
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(552) DESCRIBE `specialsailingdates` 0.00050902366638184
(553) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1382003') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00046491622924805
(554) DESCRIBE `sailingdates` 0.00056004524230957
(555) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 433366))) 0.00017499923706055
(556) DESCRIBE `ports` 0.00061607360839844
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019097328186035
(558) DESCRIBE `ports` 0.00071907043457031
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021791458129883
(560) DESCRIBE `ports` 0.00081396102905273
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024700164794922
(562) DESCRIBE `ports` 0.00088906288146973
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021910667419434
(564) DESCRIBE `ports` 0.00084495544433594
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00026702880859375
(566) DESCRIBE `ports` 0.00076198577880859
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00021004676818848
(568) DESCRIBE `ports` 0.00084614753723145
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00025010108947754
(570) DESCRIBE `ports` 0.00085592269897461
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00022006034851074
(572) DESCRIBE `ports` 0.00080490112304688
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00026106834411621
(574) DESCRIBE `ports` 0.00084900856018066
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00021505355834961
(576) DESCRIBE `ports` 0.00081110000610352
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.0002439022064209
(578) DESCRIBE `ports` 0.0007929801940918
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.0002138614654541
(580) DESCRIBE `ports` 0.00077986717224121
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00023388862609863
(582) DESCRIBE `ports` 0.00074601173400879
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00021195411682129
(584) DESCRIBE `ports` 0.0008690357208252
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00024890899658203
(586) DESCRIBE `ports` 0.0009610652923584
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00022506713867188
(588) DESCRIBE `ports` 0.00078201293945312
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00023603439331055
(590) DESCRIBE `ports` 0.00087499618530273
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00025606155395508
(592) DESCRIBE `ports` 0.00092697143554688
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.0002448558807373
(594) DESCRIBE `ports` 0.00083398818969727
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.0002131462097168
(596) DESCRIBE `ports` 0.00081682205200195
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0002291202545166
(598) DESCRIBE `ports` 0.00084686279296875
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00017118453979492
(600) DESCRIBE `ports` 0.00083303451538086
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00022697448730469
(602) DESCRIBE `ports` 0.00087189674377441
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00020790100097656
(604) DESCRIBE `ports` 0.00080418586730957
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00023102760314941
(606) DESCRIBE `ports` 0.00085115432739258
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00017905235290527
(608) DESCRIBE `ports` 0.0008242130279541
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021696090698242
(610) DESCRIBE `ports` 0.00086092948913574
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020503997802734
(612) DESCRIBE `ports` 0.00078916549682617
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00024604797363281
(614) DESCRIBE `ports` 0.00094008445739746
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00017905235290527
(616) DESCRIBE `ports` 0.00060892105102539
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00018095970153809
(618) DESCRIBE `ports` 0.00059103965759277
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00016188621520996
(620) DESCRIBE `ports` 0.00069284439086914
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00018310546875
(622) DESCRIBE `ports` 0.00058794021606445
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00016307830810547
(624) DESCRIBE `ports` 0.00059080123901367
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00018000602722168
(626) DESCRIBE `ports` 0.0005958080291748
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00016283988952637
(628) DESCRIBE `ports` 0.00066399574279785
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00018000602722168
(630) DESCRIBE `ports` 0.00062704086303711
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00016093254089355
(632) DESCRIBE `ports` 0.00058507919311523
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00017619132995605
(634) DESCRIBE `ports` 0.00093698501586914
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00016593933105469
(636) DESCRIBE `ports` 0.00059390068054199
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00018215179443359
(638) DESCRIBE `ports` 0.00059294700622559
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00016307830810547
(640) DESCRIBE `ports` 0.00065207481384277
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00018811225891113
(642) DESCRIBE `ports` 0.0006401538848877
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00016498565673828
(644) DESCRIBE `ports` 0.00059199333190918
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00017881393432617
(646) DESCRIBE `ports` 0.0005958080291748
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00017118453979492
(648) DESCRIBE `ports` 0.00060296058654785
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00017714500427246
(650) DESCRIBE `ports` 0.00058412551879883
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00016188621520996
(652) DESCRIBE `ports` 0.00060081481933594
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00019288063049316
(654) DESCRIBE `ports` 0.00063300132751465
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00016093254089355
(656) DESCRIBE `ports` 0.00059700012207031
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0001828670501709
(658) DESCRIBE `ports` 0.00061607360839844
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00016212463378906
(660) DESCRIBE `ports` 0.00061392784118652
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00018191337585449
(662) DESCRIBE `ports` 0.00059604644775391
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00016283988952637
(664) DESCRIBE `ports` 0.00060200691223145
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00018191337585449
(666) DESCRIBE `ports` 0.00063014030456543
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00016403198242188
(668) DESCRIBE `cruises` 0.0012109279632568
(669) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69034))) 0.00028586387634277
(670) DESCRIBE `avid_specials` 0.00059390068054199
(671) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1382003 and class = 'Special') OR (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.00087404251098633
(672) DESCRIBE `cruiselines` 0.00087594985961914
(673) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00021195411682129
(674) DESCRIBE `orchid_image` 0.00068116188049316
(675) DESCRIBE `cruiselines` 0.00086617469787598
(676) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00019407272338867
(677) DESCRIBE `cruises` 0.0017819404602051
(678) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69034') 0.00023698806762695
(679) DESCRIBE `ships` 0.0012669563293457
(680) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00026488304138184
(681) DESCRIBE `ships` 0.001244068145752
(682) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00017380714416504
(683) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016403198242188
(684) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001530647277832
(685) DESCRIBE `itineraries` 0.00062704086303711
(686) DESCRIBE `ports` 0.00070786476135254
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021982192993164
(688) DESCRIBE `ports` 0.00059008598327637
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001978874206543
(690) DESCRIBE `ports` 0.00060606002807617
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017213821411133
(692) DESCRIBE `sailingdates` 0.00055408477783203
(693) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69034') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003819465637207
(694) DESCRIBE `ports` 0.00064802169799805
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020503997802734
(696) DESCRIBE `ports` 0.00069808959960938
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00024008750915527
(698) DESCRIBE `ports` 0.0010659694671631
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025606155395508
(700) DESCRIBE `ports` 0.00092005729675293
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023889541625977
(702) DESCRIBE `ports` 0.00093889236450195
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.0002601146697998
(704) DESCRIBE `ports` 0.00094294548034668
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00023293495178223
(706) DESCRIBE `ports` 0.00097799301147461
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00026702880859375
(708) DESCRIBE `ports` 0.0010330677032471
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00023293495178223
(710) DESCRIBE `ports` 0.00087881088256836
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00025796890258789
(712) DESCRIBE `ports` 0.00093507766723633
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00022411346435547
(714) DESCRIBE `ports` 0.00080490112304688
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00019288063049316
(716) DESCRIBE `ports` 0.00065493583679199
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00017690658569336
(718) DESCRIBE `ports` 0.00061178207397461
(719) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019216537475586
(720) DESCRIBE `ports` 0.00060200691223145
(721) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00016307830810547
(722) DESCRIBE `ports` 0.00064492225646973
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00018310546875
(724) DESCRIBE `ports` 0.00065016746520996
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00016903877258301
(726) DESCRIBE `ports` 0.00060296058654785
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00022983551025391
(728) DESCRIBE `ports` 0.00078701972961426
(729) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00020098686218262
(730) DESCRIBE `ports` 0.00075793266296387
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00024700164794922
(732) DESCRIBE `ports` 0.00080204010009766
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.0002129077911377
(734) DESCRIBE `ports` 0.0007779598236084
(735) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00023198127746582
(736) DESCRIBE `ports` 0.00077509880065918
(737) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00020098686218262
(738) DESCRIBE `ports` 0.00075507164001465
(739) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00021791458129883
(740) DESCRIBE `ports` 0.00075316429138184
(741) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00017285346984863
(742) DESCRIBE `ports` 0.00060296058654785
(743) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00019192695617676
(744) DESCRIBE `ports` 0.0006098747253418
(745) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00020003318786621
(746) DESCRIBE `ports` 0.00060105323791504
(747) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019192695617676
(748) DESCRIBE `ports` 0.00060701370239258
(749) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016593933105469
(750) DESCRIBE `ports` 0.0005950927734375
(751) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00018596649169922
(752) DESCRIBE `ports` 0.00061392784118652
(753) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00016403198242188
(754) DESCRIBE `ports` 0.00058794021606445
(755) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00017786026000977
(756) DESCRIBE `ports` 0.00060296058654785
(757) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00016593933105469
(758) DESCRIBE `ports` 0.00060009956359863
(759) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00018310546875
(760) DESCRIBE `ports` 0.00060081481933594
(761) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00016903877258301
(762) DESCRIBE `ports` 0.00060892105102539
(763) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00018000602722168
(764) DESCRIBE `ports` 0.0006098747253418
(765) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00016307830810547
(766) DESCRIBE `ports` 0.00058889389038086
(767) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00018215179443359
(768) DESCRIBE `ports` 0.00063610076904297
(769) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00016498565673828
(770) DESCRIBE `ports` 0.00059294700622559
(771) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00018787384033203
(772) DESCRIBE `ports` 0.00060391426086426
(773) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00016689300537109
(774) DESCRIBE `ports` 0.00063300132751465
(775) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00019311904907227
(776) DESCRIBE `ports` 0.00059604644775391
(777) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00016379356384277
(778) DESCRIBE `ports` 0.00064992904663086
(779) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0001838207244873
(780) DESCRIBE `ports` 0.00060009956359863
(781) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00016403198242188
(782) DESCRIBE `ports` 0.00058913230895996
(783) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00018501281738281
(784) DESCRIBE `ports` 0.00060701370239258
(785) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018191337585449
(786) DESCRIBE `ports` 0.00059008598327637
(787) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00017905235290527
(788) DESCRIBE `ports` 0.00060915946960449
(789) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.0001671314239502
(790) DESCRIBE `ports` 0.00060296058654785
(791) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00018596649169922
(792) DESCRIBE `ports` 0.00061202049255371
(793) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018310546875
(794) DESCRIBE `ports` 0.00060391426086426
(795) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0001838207244873
(796) DESCRIBE `ports` 0.0006260871887207
(797) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00016903877258301
(798) DESCRIBE `ports` 0.00060391426086426
(799) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00019311904907227
(800) DESCRIBE `ports` 0.00060796737670898
(801) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00016689300537109
(802) DESCRIBE `ports` 0.00062894821166992
(803) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00018501281738281
(804) DESCRIBE `ports` 0.0006110668182373
(805) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0002140998840332
(806) 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.0046470165252686
(807) DESCRIBE `avid_specials` 0.00077009201049805
(808) 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.00090503692626953
(809) DESCRIBE `cruiselines` 0.00086712837219238
(810) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00020503997802734
(811) DESCRIBE `orchid_image` 0.00068879127502441
(812) DESCRIBE `cruiselines` 0.0011131763458252
(813) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00021910667419434
(814) DESCRIBE `cruises` 0.0013010501861572
(815) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68975') 0.00020503997802734
(816) DESCRIBE `ships` 0.0012049674987793
(817) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00024914741516113
(818) DESCRIBE `ships` 0.0011820793151855
(819) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0001978874206543
(820) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015401840209961
(821) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00014901161193848
(822) DESCRIBE `itineraries` 0.00059795379638672
(823) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68975') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037193298339844
(824) DESCRIBE `ports` 0.00062799453735352
(825) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019693374633789
(826) DESCRIBE `ports` 0.00057888031005859
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00016903877258301
(828) DESCRIBE `ports` 0.00061202049255371
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015997886657715
(830) DESCRIBE `sailingdates` 0.0005791187286377
(831) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68975') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00035810470581055
(832) DESCRIBE `ports` 0.00063395500183105
(833) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018215179443359
(834) DESCRIBE `ports` 0.0006260871887207
(835) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015783309936523
(836) DESCRIBE `ports` 0.00058603286743164
(837) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019097328186035
(838) DESCRIBE `ports` 0.00061392784118652
(839) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015592575073242
(840) DESCRIBE `ports` 0.00059294700622559
(841) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00017404556274414
(842) DESCRIBE `ports` 0.0006401538848877
(843) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.0001680850982666
(844) DESCRIBE `ports` 0.00062108039855957
(845) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0001828670501709
(846) DESCRIBE `ports` 0.00063514709472656
(847) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0001671314239502
(848) DESCRIBE `ports` 0.00058412551879883
(849) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00017404556274414
(850) DESCRIBE `ports` 0.00062894821166992
(851) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00016903877258301
(852) DESCRIBE `ports` 0.00060606002807617
(853) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00017499923706055
(854) DESCRIBE `ports` 0.00058698654174805
(855) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00015687942504883
(856) DESCRIBE `ports` 0.00058603286743164
(857) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00018310546875
(858) DESCRIBE `ports` 0.00058698654174805
(859) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00015807151794434
(860) DESCRIBE `ports` 0.00058698654174805
(861) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00018215179443359
(862) DESCRIBE `ports` 0.00059986114501953
(863) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00018000602722168
(864) DESCRIBE `ports` 0.00058794021606445
(865) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00019097328186035
(866) DESCRIBE `ports` 0.00058197975158691
(867) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00016403198242188
(868) DESCRIBE `ports` 0.00058197975158691
(869) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00019192695617676
(870) DESCRIBE `ports` 0.00059890747070312
(871) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00016593933105469
(872) DESCRIBE `ports` 0.00060796737670898
(873) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00018811225891113
(874) DESCRIBE `ports` 0.00061583518981934
(875) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00021719932556152
(876) DESCRIBE `ports` 0.00088000297546387
(877) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0002739429473877
(878) DESCRIBE `ports` 0.00090813636779785
(879) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00022602081298828
(880) DESCRIBE `ports` 0.00089216232299805
(881) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0002439022064209
(882) DESCRIBE `ports` 0.00088715553283691
(883) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0002288818359375
(884) DESCRIBE `ports` 0.00087904930114746
(885) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026988983154297
(886) DESCRIBE `ports` 0.00090813636779785
(887) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022983551025391
(888) DESCRIBE `ports` 0.00091695785522461
(889) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00025010108947754
(890) DESCRIBE `ports` 0.00090193748474121
(891) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023603439331055
(892) DESCRIBE `ports` 0.00084090232849121
(893) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020790100097656
(894) DESCRIBE `ports` 0.00060296058654785
(895) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016307830810547
(896) 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.0047361850738525
(897) DESCRIBE `avid_specials` 0.00076603889465332
(898) 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.00092697143554688
(899) DESCRIBE `cruiselines` 0.00090909004211426
(900) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00022387504577637
(901) DESCRIBE `orchid_image` 0.00069808959960938
(902) DESCRIBE `cruiselines` 0.00083589553833008
(903) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00018811225891113
(904) DESCRIBE `cruises` 0.0012388229370117
(905) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69037') 0.00023603439331055
(906) DESCRIBE `ships` 0.001255989074707
(907) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00025796890258789
(908) DESCRIBE `ships` 0.0012640953063965
(909) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00017595291137695
(910) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015592575073242
(911) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00014495849609375
(912) DESCRIBE `itineraries` 0.00059199333190918
(913) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69037') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046110153198242
(914) DESCRIBE `ports` 0.0010430812835693
(915) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002901554107666
(916) DESCRIBE `ports` 0.00068092346191406
(917) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019598007202148
(918) DESCRIBE `ports` 0.00066995620727539
(919) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017595291137695
(920) DESCRIBE `sailingdates` 0.00064492225646973
(921) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69037') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041794776916504
(922) DESCRIBE `ports` 0.0014159679412842
(923) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027298927307129
(924) DESCRIBE `ports` 0.00077295303344727
(925) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020384788513184
(926) DESCRIBE `ports` 0.00072884559631348
(927) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021100044250488
(928) DESCRIBE `ports` 0.0006871223449707
(929) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019407272338867
(930) DESCRIBE `ports` 0.00067496299743652
(931) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021600723266602
(932) DESCRIBE `ports` 0.00070095062255859
(933) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019311904907227
(934) DESCRIBE `ports` 0.00072407722473145
(935) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002131462097168
(936) DESCRIBE `ports` 0.00070500373840332
(937) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018596649169922
(938) DESCRIBE `ports` 0.00066494941711426
(939) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020289421081543
(940) DESCRIBE `ports` 0.00067591667175293
(941) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018882751464844
(942) DESCRIBE `ports` 0.000701904296875
(943) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00021195411682129
(944) DESCRIBE `ports` 0.00066995620727539
(945) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00018596649169922
(946) DESCRIBE `ports` 0.00071001052856445
(947) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00020503997802734
(948) DESCRIBE `ports` 0.00069999694824219
(949) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00019097328186035
(950) DESCRIBE `ports` 0.00067710876464844
(951) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00022196769714355
(952) DESCRIBE `ports` 0.0007321834564209
(953) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00021100044250488
(954) DESCRIBE `ports` 0.00066804885864258
(955) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00020408630371094
(956) DESCRIBE `ports` 0.00068783760070801
(957) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018811225891113
(958) DESCRIBE `ports` 0.0006718635559082
(959) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020384788513184
(960) DESCRIBE `ports` 0.00066804885864258
(961) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018811225891113
(962) DESCRIBE `ports` 0.00070691108703613
(963) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020694732666016
(964) DESCRIBE `ports` 0.00066304206848145
(965) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018692016601562
(966) DESCRIBE `ports` 0.00067591667175293
(967) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0002291202545166
(968) DESCRIBE `ports` 0.0006861686706543
(969) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00020098686218262
(970) DESCRIBE `ports` 0.0007929801940918
(971) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020480155944824
(972) DESCRIBE `ports` 0.00071501731872559
(973) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019502639770508
(974) DESCRIBE `ports` 0.00066494941711426
(975) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021100044250488
(976) DESCRIBE `ports` 0.00066590309143066
(977) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018811225891113
(978) DESCRIBE `ports` 0.00070595741271973
(979) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020599365234375
(980) DESCRIBE `ports` 0.00066518783569336
(981) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018620491027832
(982) DESCRIBE `ports` 0.00067496299743652
(983) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00020790100097656
(984) DESCRIBE `ports` 0.00066804885864258
(985) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018405914306641
(986) DESCRIBE `ports` 0.00066804885864258
(987) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020408630371094
(988) DESCRIBE `ports` 0.00067901611328125
(989) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018405914306641
(990) DESCRIBE `ports` 0.00066304206848145
(991) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00020217895507812
(992) DESCRIBE `ports` 0.00066304206848145
(993) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00018501281738281
(994) DESCRIBE `ports` 0.00068402290344238
(995) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021100044250488
(996) DESCRIBE `ports` 0.00066590309143066
(997) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019001960754395
(998) DESCRIBE `ports` 0.00066804885864258
(999) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00025200843811035
(1000) DESCRIBE `ports` 0.00094819068908691
(1001) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00026416778564453
(1002) DESCRIBE `ports` 0.00091004371643066
(1003) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.0002739429473877
(1004) DESCRIBE `ports` 0.0010030269622803
(1005) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.0002591609954834
(1006) DESCRIBE `ports` 0.0010459423065186
(1007) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00029397010803223
(1008) DESCRIBE `ports` 0.00098919868469238
(1009) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00030088424682617
(1010) DESCRIBE `ports` 0.00092101097106934
(1011) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00027298927307129
(1012) DESCRIBE `ports` 0.00098800659179688
(1013) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00025582313537598
(1014) DESCRIBE `ports` 0.00099492073059082
(1015) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00028896331787109
(1016) DESCRIBE `ports` 0.001068115234375
(1017) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019693374633789
(1018) DESCRIBE `ports` 0.00068187713623047
(1019) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00021815299987793
(1020) DESCRIBE `ports` 0.0006868839263916
(1021) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00019121170043945
(1022) DESCRIBE `ports` 0.00066995620727539
(1023) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 634))) 0.00020194053649902
(1024) DESCRIBE `ports` 0.00066399574279785
(1025) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '634') 0.00018501281738281
(1026) DESCRIBE `ports` 0.00073504447937012
(1027) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00020503997802734
(1028) DESCRIBE `ports` 0.00094819068908691
(1029) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.0002131462097168
(1030) DESCRIBE `ports` 0.000701904296875
(1031) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00022602081298828
(1032) DESCRIBE `ports` 0.00069212913513184
(1033) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00019288063049316
(1034) DESCRIBE `ports` 0.0006861686706543
(1035) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00021004676818848
(1036) DESCRIBE `ports` 0.00071096420288086
(1037) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018787384033203
(1038) DESCRIBE `ports` 0.00066995620727539
(1039) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00021100044250488
(1040) DESCRIBE `ports` 0.00070881843566895
(1041) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00023603439331055
(1042) DESCRIBE `ports` 0.0010991096496582
(1043) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00029301643371582
(1044) DESCRIBE `ports` 0.001072883605957
(1045) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.000244140625
(1046) DESCRIBE `ports` 0.00082993507385254
(1047) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00027704238891602
(1048) DESCRIBE `ports` 0.0010359287261963
(1049) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00025701522827148
(1050) DESCRIBE `ports` 0.0010120868682861
(1051) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00033116340637207
(1052) DESCRIBE `ports` 0.0010380744934082
(1053) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00026583671569824
(1054) DESCRIBE `ports` 0.001060962677002
(1055) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00029301643371582
(1056) DESCRIBE `ports` 0.0010788440704346
(1057) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00029301643371582
(1058) DESCRIBE `ports` 0.00095582008361816
(1059) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00028204917907715
(1060) DESCRIBE `ports` 0.0010168552398682
(1061) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00025796890258789
(1062) 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.0097119808197021
(1063) DESCRIBE `avid_specials` 0.001162052154541
(1064) 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.0019290447235107
(1065) DESCRIBE `cruiselines` 0.001046895980835
(1066) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00024604797363281
(1067) DESCRIBE `orchid_image` 0.00076699256896973
(1068) DESCRIBE `cruiselines` 0.00092291831970215
(1069) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00020003318786621
(1070) DESCRIBE `specials` 0.0020308494567871
(1071) SELECT `specials`.* FROM `specials` WHERE (id = '1382012') AND (specials.orchid_available = 1) LIMIT 1 0.00039386749267578
(1072) DESCRIBE `specials` 0.0019700527191162
(1073) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1382012') 0.0002140998840332
(1074) DESCRIBE `ships` 0.001431941986084
(1075) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00026202201843262
(1076) DESCRIBE `ships` 0.0013899803161621
(1077) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00019192695617676
(1078) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017714500427246
(1079) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00019979476928711
(1080) DESCRIBE `itineraries` 0.00076389312744141
(1081) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69036') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060606002807617
(1082) DESCRIBE `ports` 0.00078105926513672
(1083) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023317337036133
(1084) DESCRIBE `ports` 0.00067615509033203
(1085) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023007392883301
(1086) DESCRIBE `ports` 0.00067806243896484
(1087) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019288063049316
(1088) DESCRIBE `specialsailingdates` 0.00059318542480469
(1089) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1382012') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00054001808166504
(1090) DESCRIBE `sailingdates` 0.00060915946960449
(1091) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 433368))) 0.00019598007202148
(1092) DESCRIBE `ports` 0.00067687034606934
(1093) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021505355834961
(1094) DESCRIBE `ports` 0.0007479190826416
(1095) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018906593322754
(1096) DESCRIBE `ports` 0.00066614151000977
(1097) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020599365234375
(1098) DESCRIBE `ports` 0.00066494941711426
(1099) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(1100) DESCRIBE `ports` 0.00066399574279785
(1101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(1102) DESCRIBE `ports` 0.00066900253295898
(1103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019001960754395
(1104) DESCRIBE `ports` 0.00070810317993164
(1105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00026392936706543
(1106) DESCRIBE `ports` 0.00088000297546387
(1107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002131462097168
(1108) DESCRIBE `ports` 0.00071287155151367
(1109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00021195411682129
(1110) DESCRIBE `ports` 0.00072598457336426
(1111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00019693374633789
(1112) DESCRIBE `ports` 0.00068497657775879
(1113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 580))) 0.00022101402282715
(1114) DESCRIBE `ports` 0.00067591667175293
(1115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '580') 0.00018501281738281
(1116) DESCRIBE `ports` 0.00066399574279785
(1117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00020098686218262
(1118) DESCRIBE `ports` 0.00068902969360352
(1119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00018405914306641
(1120) DESCRIBE `ports` 0.00066781044006348
(1121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00020408630371094
(1122) DESCRIBE `ports` 0.00066208839416504
(1123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.0001828670501709
(1124) DESCRIBE `ports` 0.00066399574279785
(1125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00023889541625977
(1126) DESCRIBE `ports` 0.00066804885864258
(1127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018715858459473
(1128) DESCRIBE `ports` 0.00069499015808105
(1129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020980834960938
(1130) DESCRIBE `ports` 0.00070905685424805
(1131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018596649169922
(1132) DESCRIBE `ports` 0.00066494941711426
(1133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020909309387207
(1134) DESCRIBE `ports` 0.00066590309143066
(1135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018405914306641
(1136) DESCRIBE `ports` 0.00066494941711426
(1137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020503997802734
(1138) DESCRIBE `ports` 0.00068306922912598
(1139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018310546875
(1140) DESCRIBE `ports` 0.00066280364990234
(1141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00019979476928711
(1142) DESCRIBE `ports` 0.00066494941711426
(1143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00021219253540039
(1144) DESCRIBE `ports` 0.00066399574279785
(1145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021100044250488
(1146) DESCRIBE `ports` 0.00068902969360352
(1147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019288063049316
(1148) DESCRIBE `ports` 0.0006859302520752
(1149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00020289421081543
(1150) DESCRIBE `ports` 0.00065994262695312
(1151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00018405914306641
(1152) DESCRIBE `ports` 0.00074410438537598
(1153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00037598609924316
(1154) DESCRIBE `ports` 0.00097894668579102
(1155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00017189979553223
(1156) DESCRIBE `ports` 0.00060510635375977
(1157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00018787384033203
(1158) DESCRIBE `ports` 0.00059199333190918
(1159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00016498565673828
(1160) DESCRIBE `ports` 0.00058579444885254
(1161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00018310546875
(1162) DESCRIBE `ports` 0.0006110668182373
(1163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00016498565673828
(1164) DESCRIBE `ports` 0.00058794021606445
(1165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0001838207244873
(1166) DESCRIBE `ports` 0.00060200691223145
(1167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00016403198242188
(1168) DESCRIBE `ports` 0.0006098747253418
(1169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00019192695617676
(1170) DESCRIBE `ports` 0.00059199333190918
(1171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00016498565673828
(1172) DESCRIBE `ports` 0.00057697296142578
(1173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00018191337585449
(1174) DESCRIBE `ports` 0.00060391426086426
(1175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00016498565673828
(1176) DESCRIBE `ports` 0.00058293342590332
(1177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2566))) 0.00017881393432617
(1178) DESCRIBE `ports` 0.00058293342590332
(1179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2566') 0.00015997886657715
(1180) DESCRIBE `ports` 0.00060200691223145
(1181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00018000602722168
(1182) DESCRIBE `ports` 0.00058698654174805
(1183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00015997886657715
(1184) DESCRIBE `ports` 0.00058507919311523
(1185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00017809867858887
(1186) DESCRIBE `ports` 0.00059604644775391
(1187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00016188621520996
(1188) DESCRIBE `ports` 0.0005791187286377
(1189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00017499923706055
(1190) DESCRIBE `ports` 0.00058317184448242
(1191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00016212463378906
(1192) DESCRIBE `ports` 0.00063085556030273
(1193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00018882751464844
(1194) DESCRIBE `ports` 0.00062298774719238
(1195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00016689300537109
(1196) DESCRIBE `cruises` 0.0012540817260742
(1197) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69036))) 0.00028491020202637
(1198) DESCRIBE `avid_specials` 0.0006859302520752
(1199) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1382012 and class = 'Special') OR (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.00087094306945801
(1200) DESCRIBE `cruiselines` 0.0008540153503418
(1201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00025105476379395
(1202) DESCRIBE `orchid_image` 0.00066208839416504
(1203) DESCRIBE `cruiselines` 0.0009300708770752
(1204) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0002131462097168
(1205) DESCRIBE `ships` 0.0015230178833008
(1206) SELECT `ships`.* FROM `ships` WHERE (id IN ('823')) ORDER BY FIND_IN_SET(id, '823') 0.00032401084899902
(1207) DESCRIBE `cruisetypes` 0.00061202049255371
(1208) 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.025976896286011
(1209) DESCRIBE `destinations` 0.00098896026611328
(1210) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '28', '40', '49', '21', '25', '30', '35', '52')) ORDER BY FIND_IN_SET(id, '22,28,40,49,21,25,30,35,52') 0.00061988830566406
(1211) DESCRIBE `cruiselines` 0.0010039806365967
(1212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00023794174194336
(1213) DESCRIBE `cruiselines` 0.0010268688201904
(1214) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0002439022064209