or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. REVIEW: P & O Australia’s Pacific Aria
  3. Catch Up on Cruising: Latest News in bite size!
  4. Asian Adventures with Zuleika from the Cruise Factor Team
  5. A short cruise is a good cruise!!

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

Total elapsed time: 0.75352048873901

# Query Time
(1) connect 0.00055408477783203
(2) DESCRIBE `cruises` 0.0020730495452881
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69039, 69003, 69040, 69004, 74795, 69042, 69041, 70048, 74735, 69044)) ORDER BY FIND_IN_SET(id, '69039,69003,69040,69004,74795,69042,69041,70048,74735,69044') 0.0010709762573242
(4) DESCRIBE `cruises` 0.0017578601837158
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69039') 0.0002892017364502
(6) DESCRIBE `ships` 0.0015301704406738
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00028395652770996
(8) DESCRIBE `ships` 0.0013859272003174
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0002129077911377
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018405914306641
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017189979553223
(12) DESCRIBE `itineraries` 0.0010309219360352
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69039') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013279914855957
(14) DESCRIBE `ports` 0.0012578964233398
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00027108192443848
(16) DESCRIBE `ports` 0.00073003768920898
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020599365234375
(18) DESCRIBE `ports` 0.00075697898864746
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00021696090698242
(20) DESCRIBE `sailingdates` 0.00067901611328125
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69039') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041794776916504
(22) DESCRIBE `ports` 0.0010251998901367
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00028491020202637
(24) DESCRIBE `ports` 0.00086188316345215
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0002129077911377
(26) DESCRIBE `ports` 0.00074315071105957
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00022101402282715
(28) DESCRIBE `ports` 0.00071287155151367
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019097328186035
(30) DESCRIBE `ports` 0.00081419944763184
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0002601146697998
(32) DESCRIBE `ports` 0.00080704689025879
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00027012825012207
(34) DESCRIBE `ports` 0.00071501731872559
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00022292137145996
(36) DESCRIBE `ports` 0.000701904296875
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00019407272338867
(38) DESCRIBE `ports` 0.00070595741271973
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.00021505355834961
(40) DESCRIBE `ports` 0.0007331371307373
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00019598007202148
(42) DESCRIBE `ports` 0.00072002410888672
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0002291202545166
(44) DESCRIBE `ports` 0.0006868839263916
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00019121170043945
(46) DESCRIBE `ports` 0.00070810317993164
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00028800964355469
(48) DESCRIBE `ports` 0.00075483322143555
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00021505355834961
(50) DESCRIBE `ports` 0.00086498260498047
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00021195411682129
(52) DESCRIBE `ports` 0.00096511840820312
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00020289421081543
(54) DESCRIBE `ports` 0.00068402290344238
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.00029420852661133
(56) DESCRIBE `ports` 0.00084686279296875
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00020194053649902
(58) DESCRIBE `ports` 0.00073504447937012
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00022387504577637
(60) DESCRIBE `ports` 0.00078701972961426
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00019192695617676
(62) DESCRIBE `ports` 0.00075197219848633
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.00022006034851074
(64) DESCRIBE `ports` 0.00076198577880859
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.00024199485778809
(66) DESCRIBE `ports` 0.00071287155151367
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00024294853210449
(68) DESCRIBE `ports` 0.00068402290344238
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00019216537475586
(70) DESCRIBE `ports` 0.00089311599731445
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00021791458129883
(72) DESCRIBE `ports` 0.00076413154602051
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00019502639770508
(74) DESCRIBE `ports` 0.00097799301147461
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.0002288818359375
(76) DESCRIBE `ports` 0.00093388557434082
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00025510787963867
(78) DESCRIBE `ports` 0.00083398818969727
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00022482872009277
(80) DESCRIBE `ports` 0.00072813034057617
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00019001960754395
(82) DESCRIBE `ports` 0.00071501731872559
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4273))) 0.00020599365234375
(84) DESCRIBE `ports` 0.00071001052856445
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4273') 0.00018906593322754
(86) DESCRIBE `ports` 0.00072908401489258
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.0002138614654541
(88) DESCRIBE `ports` 0.00069308280944824
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00026416778564453
(90) DESCRIBE `ports` 0.00069499015808105
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00020790100097656
(92) DESCRIBE `ports` 0.00073099136352539
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00019216537475586
(94) DESCRIBE `ports` 0.00069594383239746
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.0002131462097168
(96) DESCRIBE `ports` 0.00067687034606934
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00018811225891113
(98) DESCRIBE `ports` 0.00067806243896484
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1062))) 0.00021100044250488
(100) DESCRIBE `ports` 0.00078606605529785
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1062') 0.00019192695617676
(102) DESCRIBE `ports` 0.00065994262695312
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.00021195411682129
(104) DESCRIBE `ports` 0.00066995620727539
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.0002138614654541
(106) DESCRIBE `ports` 0.00065898895263672
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00021100044250488
(108) DESCRIBE `ports` 0.00067782402038574
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00019192695617676
(110) DESCRIBE `ports` 0.00066709518432617
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2619))) 0.00020718574523926
(112) DESCRIBE `ports` 0.00066685676574707
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2619') 0.00021910667419434
(114) DESCRIBE `ports` 0.00066184997558594
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00020289421081543
(116) DESCRIBE `ports` 0.00069689750671387
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00018620491027832
(118) DESCRIBE `ports` 0.00065994262695312
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020408630371094
(120) DESCRIBE `ports` 0.00069618225097656
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018095970153809
(122) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69039') AND (sailingdate >= '2018-04-24') 0.0058469772338867
(123) DESCRIBE `avid_specials` 0.00094795227050781
(124) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69039 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 49 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.0011129379272461
(125) DESCRIBE `cruiselines` 0.0010809898376465
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00025200843811035
(127) DESCRIBE `orchid_image` 0.0010480880737305
(128) DESCRIBE `cruiselines` 0.0012249946594238
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00030994415283203
(130) DESCRIBE `cruises` 0.0016741752624512
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69003') 0.00026392936706543
(132) DESCRIBE `ships` 0.0014359951019287
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00031304359436035
(134) DESCRIBE `ships` 0.0014708042144775
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00020408630371094
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017404556274414
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00019598007202148
(138) DESCRIBE `itineraries` 0.00078201293945312
(139) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69003') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006718635559082
(140) DESCRIBE `ports` 0.0010428428649902
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031089782714844
(142) DESCRIBE `ports` 0.00096297264099121
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00024700164794922
(144) DESCRIBE `ports` 0.00069904327392578
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019097328186035
(146) DESCRIBE `sailingdates` 0.0006098747253418
(147) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69003') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056910514831543
(148) DESCRIBE `ports` 0.00084090232849121
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00022602081298828
(150) DESCRIBE `ports` 0.00068116188049316
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00021600723266602
(152) DESCRIBE `ports` 0.00090384483337402
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020885467529297
(154) DESCRIBE `ports` 0.00077605247497559
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018405914306641
(156) DESCRIBE `ports` 0.00075197219848633
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020503997802734
(158) DESCRIBE `ports` 0.00068998336791992
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017905235290527
(160) DESCRIBE `ports` 0.00067400932312012
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00027704238891602
(162) DESCRIBE `ports` 0.00085616111755371
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00018596649169922
(164) DESCRIBE `ports` 0.00080299377441406
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.00020098686218262
(166) DESCRIBE `ports` 0.0015308856964111
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00026106834411621
(168) DESCRIBE `ports` 0.0010590553283691
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00030708312988281
(170) DESCRIBE `ports` 0.0011210441589355
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00026702880859375
(172) DESCRIBE `ports` 0.0010330677032471
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00029611587524414
(174) DESCRIBE `ports` 0.00084495544433594
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00019598007202148
(176) DESCRIBE `ports` 0.00073003768920898
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00027680397033691
(178) DESCRIBE `ports` 0.00072193145751953
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00020003318786621
(180) DESCRIBE `ports` 0.00066995620727539
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.00020408630371094
(182) DESCRIBE `ports` 0.00072503089904785
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00020503997802734
(184) DESCRIBE `ports` 0.00076985359191895
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.0002129077911377
(186) DESCRIBE `ports` 0.00068211555480957
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00019383430480957
(188) DESCRIBE `ports` 0.00069999694824219
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.00022006034851074
(190) DESCRIBE `ports` 0.00067710876464844
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.00019383430480957
(192) DESCRIBE `ports` 0.00066614151000977
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00020289421081543
(194) DESCRIBE `ports` 0.00075197219848633
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00020909309387207
(196) DESCRIBE `ports` 0.00067305564880371
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00020909309387207
(198) DESCRIBE `ports` 0.00070881843566895
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00020098686218262
(200) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69003') AND (sailingdate >= '2018-04-24') 0.0055267810821533
(201) DESCRIBE `avid_specials` 0.00098109245300293
(202) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69003 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 49 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.0010619163513184
(203) DESCRIBE `cruiselines` 0.0010530948638916
(204) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00024914741516113
(205) DESCRIBE `orchid_image` 0.00083708763122559
(206) DESCRIBE `cruiselines` 0.0011789798736572
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00024509429931641
(208) DESCRIBE `cruises` 0.001460075378418
(209) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69040') 0.0002598762512207
(210) DESCRIBE `ships` 0.0032060146331787
(211) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00035905838012695
(212) DESCRIBE `ships` 0.0015120506286621
(213) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.0002140998840332
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018095970153809
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001671314239502
(216) DESCRIBE `itineraries` 0.00078010559082031
(217) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69040') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001054048538208
(218) DESCRIBE `ports` 0.00099301338195801
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00026321411132812
(220) DESCRIBE `ports` 0.00070405006408691
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00022101402282715
(222) DESCRIBE `ports` 0.00088095664978027
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00020217895507812
(224) DESCRIBE `sailingdates` 0.00063705444335938
(225) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69040') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003969669342041
(226) DESCRIBE `ports` 0.00081896781921387
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00023984909057617
(228) DESCRIBE `ports` 0.00076794624328613
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00020599365234375
(230) DESCRIBE `ports` 0.00091004371643066
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00035691261291504
(232) DESCRIBE `ports` 0.00078415870666504
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.0002140998840332
(234) DESCRIBE `ports` 0.00076007843017578
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00023698806762695
(236) DESCRIBE `ports` 0.00095200538635254
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00028300285339355
(238) DESCRIBE `ports` 0.0011270046234131
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00039410591125488
(240) DESCRIBE `ports` 0.00081515312194824
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00020480155944824
(242) DESCRIBE `ports` 0.00068902969360352
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00023198127746582
(244) DESCRIBE `ports` 0.00081491470336914
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.0002288818359375
(246) DESCRIBE `ports` 0.00069093704223633
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4273))) 0.00020694732666016
(248) DESCRIBE `ports` 0.00067996978759766
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4273') 0.00020790100097656
(250) DESCRIBE `ports` 0.00070500373840332
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.00022101402282715
(252) DESCRIBE `ports` 0.00068497657775879
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00018906593322754
(254) DESCRIBE `ports` 0.00071477890014648
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00020813941955566
(256) DESCRIBE `ports` 0.00069904327392578
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00019097328186035
(258) DESCRIBE `ports` 0.00071501731872559
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00026297569274902
(260) DESCRIBE `ports` 0.00073003768920898
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00019693374633789
(262) DESCRIBE `ports` 0.00070595741271973
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1062))) 0.00021004676818848
(264) DESCRIBE `ports` 0.00071501731872559
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1062') 0.00019502639770508
(266) DESCRIBE `ports` 0.000762939453125
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.00022292137145996
(268) DESCRIBE `ports` 0.00072407722473145
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.00023412704467773
(270) DESCRIBE `ports` 0.00093317031860352
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00028395652770996
(272) DESCRIBE `ports` 0.00082683563232422
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00021004676818848
(274) DESCRIBE `ports` 0.00080299377441406
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2619))) 0.00020813941955566
(276) DESCRIBE `ports` 0.00070095062255859
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2619') 0.00019383430480957
(278) DESCRIBE `ports` 0.00068783760070801
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00021481513977051
(280) DESCRIBE `ports` 0.00075006484985352
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00023198127746582
(282) DESCRIBE `ports` 0.00067901611328125
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00022506713867188
(284) DESCRIBE `ports` 0.00076079368591309
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019311904907227
(286) DESCRIBE `ports` 0.00068402290344238
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00021982192993164
(288) DESCRIBE `ports` 0.00069308280944824
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00019311904907227
(290) DESCRIBE `ports` 0.0009620189666748
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.0002748966217041
(292) DESCRIBE `ports` 0.0010139942169189
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.0003211498260498
(294) DESCRIBE `ports` 0.0011088848114014
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00033998489379883
(296) DESCRIBE `ports` 0.0011351108551025
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00031089782714844
(298) DESCRIBE `ports` 0.0010719299316406
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00030303001403809
(300) DESCRIBE `ports` 0.0011019706726074
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00031399726867676
(302) DESCRIBE `ports` 0.0011289119720459
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.0023097991943359
(304) DESCRIBE `ports` 0.001121997833252
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00027680397033691
(306) DESCRIBE `ports` 0.0010840892791748
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.00030207633972168
(308) DESCRIBE `ports` 0.0010330677032471
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00028395652770996
(310) DESCRIBE `ports` 0.0010800361633301
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00027608871459961
(312) DESCRIBE `ports` 0.0010149478912354
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00025320053100586
(314) DESCRIBE `ports` 0.00094294548034668
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00028204917907715
(316) DESCRIBE `ports` 0.00099897384643555
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00023412704467773
(318) DESCRIBE `ports` 0.0009620189666748
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00025701522827148
(320) DESCRIBE `ports` 0.00097894668579102
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00024890899658203
(322) DESCRIBE `ports` 0.00099492073059082
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00027990341186523
(324) DESCRIBE `ports` 0.0010709762573242
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00026416778564453
(326) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69040') AND (sailingdate >= '2018-04-24') 0.01010799407959
(327) DESCRIBE `avid_specials` 0.0012609958648682
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69040 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 21 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.0020170211791992
(329) DESCRIBE `cruiselines` 0.0016300678253174
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0003209114074707
(331) DESCRIBE `orchid_image` 0.0011670589447021
(332) DESCRIBE `cruiselines` 0.0013971328735352
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00028419494628906
(334) DESCRIBE `cruises` 0.002263069152832
(335) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69004') 0.00036406517028809
(336) DESCRIBE `ships` 0.0020980834960938
(337) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00037121772766113
(338) DESCRIBE `ships` 0.0020949840545654
(339) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00031495094299316
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023484230041504
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022292137145996
(342) DESCRIBE `itineraries` 0.0011279582977295
(343) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69004') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055789947509766
(344) DESCRIBE `ports` 0.0013599395751953
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00032305717468262
(346) DESCRIBE `ports` 0.0010240077972412
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00030708312988281
(348) DESCRIBE `ports` 0.0010020732879639
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00026488304138184
(350) DESCRIBE `sailingdates` 0.00087714195251465
(351) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69004') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049400329589844
(352) DESCRIBE `ports` 0.001140832901001
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00027298927307129
(354) DESCRIBE `ports` 0.00071191787719727
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00025510787963867
(356) DESCRIBE `ports` 0.00085186958312988
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00026392936706543
(358) DESCRIBE `ports` 0.00082111358642578
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00022315979003906
(360) DESCRIBE `ports` 0.00080394744873047
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00023508071899414
(362) DESCRIBE `ports` 0.00073099136352539
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00020503997802734
(364) DESCRIBE `ports` 0.00071191787719727
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.0002140998840332
(366) DESCRIBE `ports` 0.00076007843017578
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00026512145996094
(368) DESCRIBE `ports` 0.0008690357208252
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00022315979003906
(370) DESCRIBE `ports` 0.0020630359649658
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.0003819465637207
(372) DESCRIBE `ports` 0.00092220306396484
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4273))) 0.00025486946105957
(374) DESCRIBE `ports` 0.00078988075256348
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4273') 0.0002131462097168
(376) DESCRIBE `ports` 0.00078916549682617
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.00021600723266602
(378) DESCRIBE `ports` 0.00070810317993164
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00018596649169922
(380) DESCRIBE `ports` 0.0007171630859375
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00020384788513184
(382) DESCRIBE `ports` 0.00067305564880371
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00018620491027832
(384) DESCRIBE `ports` 0.00086092948913574
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00023102760314941
(386) DESCRIBE `ports` 0.00076699256896973
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00018596649169922
(388) DESCRIBE `ports` 0.00066494941711426
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1062))) 0.00021696090698242
(390) DESCRIBE `ports` 0.00070405006408691
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1062') 0.00018191337585449
(392) DESCRIBE `ports` 0.00068187713623047
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.00021195411682129
(394) DESCRIBE `ports` 0.0006709098815918
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.00018906593322754
(396) DESCRIBE `ports` 0.00070405006408691
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00021004676818848
(398) DESCRIBE `ports` 0.0006709098815918
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.0001828670501709
(400) DESCRIBE `ports` 0.00092601776123047
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2619))) 0.00024509429931641
(402) DESCRIBE `ports` 0.00082302093505859
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2619') 0.00018906593322754
(404) DESCRIBE `ports` 0.00072193145751953
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00022196769714355
(406) DESCRIBE `ports` 0.00090312957763672
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00019097328186035
(408) DESCRIBE `ports` 0.00067400932312012
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020909309387207
(410) DESCRIBE `ports` 0.0007779598236084
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0001838207244873
(412) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69004') AND (sailingdate >= '2018-04-24') 0.0057740211486816
(413) DESCRIBE `avid_specials` 0.00084114074707031
(414) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69004 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 21 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.0013580322265625
(415) DESCRIBE `cruiselines` 0.0010361671447754
(416) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00026893615722656
(417) DESCRIBE `orchid_image` 0.00077009201049805
(418) DESCRIBE `cruiselines` 0.00094103813171387
(419) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00023102760314941
(420) DESCRIBE `cruises` 0.0020039081573486
(421) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74795') 0.00032401084899902
(422) DESCRIBE `ships` 0.001662015914917
(423) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00029301643371582
(424) DESCRIBE `ships` 0.0013859272003174
(425) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00027894973754883
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017809867858887
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016689300537109
(428) DESCRIBE `itineraries` 0.00075697898864746
(429) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74795') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014171600341797
(430) DESCRIBE `ports` 0.0013399124145508
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00029397010803223
(432) DESCRIBE `ports` 0.00073504447937012
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00021100044250488
(434) DESCRIBE `ports` 0.00073003768920898
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00020194053649902
(436) DESCRIBE `sailingdates` 0.00086021423339844
(437) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74795') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057411193847656
(438) DESCRIBE `ports` 0.00078797340393066
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00026679039001465
(440) DESCRIBE `ports` 0.00072693824768066
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.0001838207244873
(442) DESCRIBE `ports` 0.00070309638977051
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.0001990795135498
(444) DESCRIBE `ports` 0.00069904327392578
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00019192695617676
(446) DESCRIBE `ports` 0.00065898895263672
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00025606155395508
(448) DESCRIBE `ports` 0.00068187713623047
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00017905235290527
(450) DESCRIBE `ports` 0.00067996978759766
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4273))) 0.00021505355834961
(452) DESCRIBE `ports` 0.0007011890411377
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4273') 0.00017905235290527
(454) DESCRIBE `ports` 0.00066804885864258
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.00021982192993164
(456) DESCRIBE `ports` 0.00068306922912598
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00018000602722168
(458) DESCRIBE `ports` 0.00065994262695312
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00022006034851074
(460) DESCRIBE `ports` 0.00066709518432617
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00018095970153809
(462) DESCRIBE `ports` 0.00072193145751953
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00021696090698242
(464) DESCRIBE `ports` 0.00065994262695312
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00018095970153809
(466) DESCRIBE `ports` 0.00067496299743652
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1062))) 0.00019979476928711
(468) DESCRIBE `ports` 0.00065517425537109
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1062') 0.00017809867858887
(470) DESCRIBE `ports` 0.00065898895263672
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.0001981258392334
(472) DESCRIBE `ports` 0.00067400932312012
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.00017786026000977
(474) DESCRIBE `ports` 0.00067996978759766
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00019693374633789
(476) DESCRIBE `ports` 0.00065779685974121
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00018095970153809
(478) DESCRIBE `ports` 0.00066184997558594
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2619))) 0.00019598007202148
(480) DESCRIBE `ports` 0.00067496299743652
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2619') 0.00018000602722168
(482) DESCRIBE `ports` 0.00065779685974121
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2685))) 0.00021505355834961
(484) DESCRIBE `ports` 0.00074100494384766
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2685') 0.00017809867858887
(486) DESCRIBE `ports` 0.00066304206848145
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0001981258392334
(488) DESCRIBE `ports` 0.00066900253295898
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0001828670501709
(490) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74795') AND (sailingdate >= '2018-04-24') 0.0055909156799316
(491) DESCRIBE `avid_specials` 0.00076603889465332
(492) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74795 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 21 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.0011820793151855
(493) DESCRIBE `cruiselines` 0.0010631084442139
(494) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0002892017364502
(495) DESCRIBE `orchid_image` 0.00078201293945312
(496) DESCRIBE `cruiselines` 0.00092196464538574
(497) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00019192695617676
(498) DESCRIBE `cruises` 0.0016579627990723
(499) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69042') 0.00025606155395508
(500) DESCRIBE `ships` 0.0015308856964111
(501) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00026702880859375
(502) DESCRIBE `ships` 0.0013000965118408
(503) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00018715858459473
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018000602722168
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016999244689941
(506) DESCRIBE `itineraries` 0.00066900253295898
(507) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69042') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001054048538208
(508) DESCRIBE `ports` 0.00092697143554688
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00024294853210449
(510) DESCRIBE `ports` 0.00085186958312988
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0001990795135498
(512) DESCRIBE `ports` 0.00067996978759766
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00023889541625977
(514) DESCRIBE `sailingdates` 0.00081992149353027
(515) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69042') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047993659973145
(516) DESCRIBE `ports` 0.001046895980835
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00030303001403809
(518) DESCRIBE `ports` 0.00096607208251953
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00025105476379395
(520) DESCRIBE `ports` 0.00093889236450195
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00023102760314941
(522) DESCRIBE `ports` 0.00071811676025391
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017714500427246
(524) DESCRIBE `ports` 0.00073003768920898
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00021886825561523
(526) DESCRIBE `ports` 0.00066685676574707
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018906593322754
(528) DESCRIBE `ports` 0.00072121620178223
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00023412704467773
(530) DESCRIBE `ports` 0.00069689750671387
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00018501281738281
(532) DESCRIBE `ports` 0.00075888633728027
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.0002591609954834
(534) DESCRIBE `ports` 0.00092816352844238
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00026106834411621
(536) DESCRIBE `ports` 0.00099515914916992
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00027990341186523
(538) DESCRIBE `ports` 0.00089216232299805
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.0002129077911377
(540) DESCRIBE `ports` 0.00074195861816406
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00021791458129883
(542) DESCRIBE `ports` 0.00071001052856445
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00018000602722168
(544) DESCRIBE `ports` 0.00073003768920898
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00041103363037109
(546) DESCRIBE `ports` 0.00086092948913574
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.0001990795135498
(548) DESCRIBE `ports` 0.00067496299743652
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.0002291202545166
(550) DESCRIBE `ports` 0.00068902969360352
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00018692016601562
(552) DESCRIBE `ports` 0.00065708160400391
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00019598007202148
(554) DESCRIBE `ports` 0.00066184997558594
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00019216537475586
(556) DESCRIBE `ports` 0.0006561279296875
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00019693374633789
(558) DESCRIBE `ports` 0.00082302093505859
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00017595291137695
(560) DESCRIBE `ports` 0.00069689750671387
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00021004676818848
(562) DESCRIBE `ports` 0.00066018104553223
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00017595291137695
(564) DESCRIBE `ports` 0.00065994262695312
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00021100044250488
(566) DESCRIBE `ports` 0.00069189071655273
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017595291137695
(568) DESCRIBE `ports` 0.00077080726623535
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00022101402282715
(570) DESCRIBE `ports` 0.00076794624328613
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00025606155395508
(572) DESCRIBE `ports` 0.00082015991210938
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020098686218262
(574) DESCRIBE `ports` 0.000701904296875
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0002288818359375
(576) DESCRIBE `ports` 0.00069499015808105
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.000244140625
(578) DESCRIBE `ports` 0.00067400932312012
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00017404556274414
(580) DESCRIBE `ports` 0.00065803527832031
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.0001988410949707
(582) DESCRIBE `ports` 0.00081110000610352
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00017595291137695
(584) DESCRIBE `ports` 0.00065803527832031
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020718574523926
(586) DESCRIBE `ports` 0.00065398216247559
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018692016601562
(588) DESCRIBE `ports` 0.00064778327941895
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00019311904907227
(590) DESCRIBE `ports` 0.00066208839416504
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00017595291137695
(592) DESCRIBE `ports` 0.00076413154602051
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5935))) 0.00019693374633789
(594) DESCRIBE `ports` 0.00069093704223633
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5935') 0.00018692016601562
(596) DESCRIBE `ports` 0.00065708160400391
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00019407272338867
(598) DESCRIBE `ports` 0.00072598457336426
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00017404556274414
(600) DESCRIBE `ports` 0.00069189071655273
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021600723266602
(602) DESCRIBE `ports` 0.00070405006408691
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00017905235290527
(604) DESCRIBE `ports` 0.0006711483001709
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00022006034851074
(606) DESCRIBE `ports` 0.00075387954711914
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018000602722168
(608) DESCRIBE `ports` 0.00066494941711426
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020289421081543
(610) DESCRIBE `ports` 0.0006871223449707
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00020003318786621
(612) DESCRIBE `ports` 0.00065898895263672
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020384788513184
(614) DESCRIBE `ports` 0.0006871223449707
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00017499923706055
(616) DESCRIBE `ports` 0.00068283081054688
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00020408630371094
(618) DESCRIBE `ports` 0.00070095062255859
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0002138614654541
(620) DESCRIBE `ports` 0.000701904296875
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021600723266602
(622) DESCRIBE `ports` 0.0006709098815918
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018119812011719
(624) DESCRIBE `ports` 0.0006718635559082
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4013))) 0.0001981258392334
(626) DESCRIBE `ports` 0.00068092346191406
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4013') 0.00021505355834961
(628) DESCRIBE `ports` 0.00072908401489258
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00021600723266602
(630) DESCRIBE `ports` 0.00072407722473145
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019192695617676
(632) DESCRIBE `ports` 0.00068402290344238
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020003318786621
(634) DESCRIBE `ports` 0.0006861686706543
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00022411346435547
(636) DESCRIBE `ports` 0.0006871223449707
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020003318786621
(638) DESCRIBE `ports` 0.00065898895263672
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017690658569336
(640) DESCRIBE `ports` 0.00065803527832031
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020480155944824
(642) DESCRIBE `ports` 0.00067901611328125
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00019288063049316
(644) DESCRIBE `ports` 0.0007178783416748
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00021195411682129
(646) DESCRIBE `ports` 0.00069904327392578
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00019001960754395
(648) DESCRIBE `ports` 0.00071096420288086
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029897689819336
(650) DESCRIBE `ports` 0.00068783760070801
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00021481513977051
(652) DESCRIBE `ports` 0.00072002410888672
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020694732666016
(654) DESCRIBE `ports` 0.00066208839416504
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017595291137695
(656) DESCRIBE `ports` 0.00065517425537109
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0001978874206543
(658) DESCRIBE `ports` 0.00090408325195312
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022602081298828
(660) DESCRIBE `ports` 0.00087809562683105
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026202201843262
(662) DESCRIBE `ports` 0.00072288513183594
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(664) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69042') AND (sailingdate >= '2018-04-24') 0.0059690475463867
(665) DESCRIBE `avid_specials` 0.0008389949798584
(666) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69042 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.0010759830474854
(667) DESCRIBE `cruiselines` 0.0010080337524414
(668) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00023794174194336
(669) DESCRIBE `orchid_image` 0.00077009201049805
(670) DESCRIBE `cruiselines` 0.0010750293731689
(671) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.0002129077911377
(672) DESCRIBE `cruises` 0.0012359619140625
(673) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69041') 0.00021600723266602
(674) DESCRIBE `ships` 0.0012469291687012
(675) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00024700164794922
(676) DESCRIBE `ships` 0.0012400150299072
(677) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00018692016601562
(678) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(679) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016593933105469
(680) DESCRIBE `itineraries` 0.00072002410888672
(681) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69041') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00040817260742188
(682) DESCRIBE `ports` 0.00076794624328613
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00022101402282715
(684) DESCRIBE `ports` 0.00075697898864746
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020003318786621
(686) DESCRIBE `ports` 0.0006871223449707
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018787384033203
(688) DESCRIBE `sailingdates` 0.0005950927734375
(689) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69041') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040793418884277
(690) DESCRIBE `ports` 0.00075912475585938
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0002601146697998
(692) DESCRIBE `ports` 0.00069999694824219
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00021910667419434
(694) DESCRIBE `ports` 0.00065994262695312
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00019001960754395
(696) DESCRIBE `ports` 0.00065803527832031
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017809867858887
(698) DESCRIBE `ports` 0.00069904327392578
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00019097328186035
(700) DESCRIBE `ports` 0.00065207481384277
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017404556274414
(702) DESCRIBE `ports` 0.00069093704223633
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.0002131462097168
(704) DESCRIBE `ports` 0.00066709518432617
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00020909309387207
(706) DESCRIBE `ports` 0.00065302848815918
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.0001978874206543
(708) DESCRIBE `ports` 0.00066113471984863
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00023508071899414
(710) DESCRIBE `ports` 0.00098490715026855
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00027298927307129
(712) DESCRIBE `ports` 0.00097107887268066
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00025486946105957
(714) DESCRIBE `ports` 0.00098705291748047
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00022506713867188
(716) DESCRIBE `ports` 0.00068998336791992
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00019383430480957
(718) DESCRIBE `ports` 0.00069093704223633
(719) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00021100044250488
(720) DESCRIBE `ports` 0.00067591667175293
(721) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00018119812011719
(722) DESCRIBE `ports` 0.00067305564880371
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.00022220611572266
(724) DESCRIBE `ports` 0.00066518783569336
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00017690658569336
(726) DESCRIBE `ports` 0.00065708160400391
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.0001978874206543
(728) DESCRIBE `ports` 0.00067400932312012
(729) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00022387504577637
(730) DESCRIBE `ports` 0.00066709518432617
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00020289421081543
(732) DESCRIBE `ports` 0.00065898895263672
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00018000602722168
(734) DESCRIBE `ports` 0.00069308280944824
(735) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1092))) 0.00020217895507812
(736) DESCRIBE `ports` 0.00084400177001953
(737) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1092') 0.00018787384033203
(738) DESCRIBE `ports` 0.00070691108703613
(739) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020503997802734
(740) DESCRIBE `ports` 0.00066804885864258
(741) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018310546875
(742) DESCRIBE `ports` 0.00066208839416504
(743) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020217895507812
(744) DESCRIBE `ports` 0.00065898895263672
(745) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00025010108947754
(746) DESCRIBE `ports` 0.00067806243896484
(747) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0001978874206543
(748) DESCRIBE `ports` 0.00065994262695312
(749) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018000602722168
(750) DESCRIBE `ports` 0.00065803527832031
(751) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00020003318786621
(752) DESCRIBE `ports` 0.0006709098815918
(753) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00019502639770508
(754) DESCRIBE `ports` 0.00070786476135254
(755) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00020098686218262
(756) DESCRIBE `ports` 0.00069499015808105
(757) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018596649169922
(758) DESCRIBE `ports` 0.00066494941711426
(759) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020790100097656
(760) DESCRIBE `ports` 0.00071096420288086
(761) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018000602722168
(762) DESCRIBE `ports` 0.00074195861816406
(763) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00019693374633789
(764) DESCRIBE `ports` 0.00072288513183594
(765) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018095970153809
(766) DESCRIBE `ports` 0.00065803527832031
(767) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5935))) 0.00019311904907227
(768) DESCRIBE `ports` 0.00070500373840332
(769) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5935') 0.00026798248291016
(770) DESCRIBE `ports` 0.0009770393371582
(771) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00026297569274902
(772) DESCRIBE `ports` 0.00093579292297363
(773) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00023102760314941
(774) DESCRIBE `ports` 0.00095105171203613
(775) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00029206275939941
(776) DESCRIBE `ports` 0.00091886520385742
(777) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00023412704467773
(778) DESCRIBE `ports` 0.0010299682617188
(779) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00027608871459961
(780) DESCRIBE `ports` 0.00091004371643066
(781) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0002439022064209
(782) DESCRIBE `ports` 0.00098681449890137
(783) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0002748966217041
(784) DESCRIBE `ports` 0.0010409355163574
(785) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00024294853210449
(786) DESCRIBE `ports` 0.00098991394042969
(787) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00027990341186523
(788) DESCRIBE `ports` 0.00099015235900879
(789) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00025200843811035
(790) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69041') AND (sailingdate >= '2018-04-24') 0.010365962982178
(791) DESCRIBE `avid_specials` 0.0011711120605469
(792) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69041 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 49 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.0018579959869385
(793) DESCRIBE `cruiselines` 0.0016970634460449
(794) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00030899047851562
(795) DESCRIBE `orchid_image` 0.001107931137085
(796) DESCRIBE `cruiselines` 0.0014369487762451
(797) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00032496452331543
(798) DESCRIBE `cruises` 0.0018720626831055
(799) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70048') 0.00030922889709473
(800) DESCRIBE `ships` 0.0018680095672607
(801) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.0003659725189209
(802) DESCRIBE `ships` 0.0020029544830322
(803) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00027203559875488
(804) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022983551025391
(805) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023102760314941
(806) DESCRIBE `itineraries` 0.00098586082458496
(807) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70048') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063991546630859
(808) DESCRIBE `ports` 0.0011229515075684
(809) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00029897689819336
(810) DESCRIBE `ports` 0.00098490715026855
(811) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00025701522827148
(812) DESCRIBE `ports` 0.00096583366394043
(813) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00024104118347168
(814) DESCRIBE `sailingdates` 0.00092101097106934
(815) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70048') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055408477783203
(816) DESCRIBE `ports` 0.0010519027709961
(817) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00028800964355469
(818) DESCRIBE `ports` 0.0009760856628418
(819) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00025582313537598
(820) DESCRIBE `ports` 0.0009758472442627
(821) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00026202201843262
(822) DESCRIBE `ports` 0.00098395347595215
(823) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00024199485778809
(824) DESCRIBE `ports` 0.00098896026611328
(825) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0002748966217041
(826) DESCRIBE `ports` 0.00098919868469238
(827) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00024104118347168
(828) DESCRIBE `ports` 0.00099492073059082
(829) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00028085708618164
(830) DESCRIBE `ports` 0.0011060237884521
(831) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00025701522827148
(832) DESCRIBE `ports` 0.00099396705627441
(833) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.00027894973754883
(834) DESCRIBE `ports` 0.0010228157043457
(835) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00028896331787109
(836) DESCRIBE `ports` 0.00096416473388672
(837) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00028300285339355
(838) DESCRIBE `ports` 0.00092887878417969
(839) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00024509429931641
(840) DESCRIBE `ports` 0.0009160041809082
(841) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00029897689819336
(842) DESCRIBE `ports` 0.0009150505065918
(843) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00025296211242676
(844) DESCRIBE `ports` 0.00095486640930176
(845) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00027298927307129
(846) DESCRIBE `ports` 0.00091695785522461
(847) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00023221969604492
(848) DESCRIBE `ports` 0.00088000297546387
(849) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.00024986267089844
(850) DESCRIBE `ports` 0.00098180770874023
(851) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00024604797363281
(852) DESCRIBE `ports` 0.00095605850219727
(853) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.0002598762512207
(854) DESCRIBE `ports` 0.00096797943115234
(855) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00025606155395508
(856) DESCRIBE `ports` 0.00097298622131348
(857) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00026488304138184
(858) DESCRIBE `ports` 0.00095510482788086
(859) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00025105476379395
(860) DESCRIBE `ports` 0.00099992752075195
(861) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00028395652770996
(862) DESCRIBE `ports` 0.00098681449890137
(863) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00026893615722656
(864) DESCRIBE `ports` 0.00099611282348633
(865) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00028586387634277
(866) DESCRIBE `ports` 0.00097990036010742
(867) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00026202201843262
(868) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70048') AND (sailingdate >= '2018-04-24') 0.01040506362915
(869) DESCRIBE `avid_specials` 0.00095009803771973
(870) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70048 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016679763793945
(871) DESCRIBE `cruiselines` 0.0014140605926514
(872) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0002899169921875
(873) DESCRIBE `orchid_image` 0.0025150775909424
(874) DESCRIBE `cruiselines` 0.0014522075653076
(875) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00028681755065918
(876) DESCRIBE `cruises` 0.0019621849060059
(877) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74735') 0.00029611587524414
(878) DESCRIBE `ships` 0.0019271373748779
(879) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00033402442932129
(880) DESCRIBE `ships` 0.0018730163574219
(881) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00023198127746582
(882) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021982192993164
(883) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023198127746582
(884) DESCRIBE `itineraries` 0.00095486640930176
(885) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74735') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001227855682373
(886) DESCRIBE `ports` 0.0010509490966797
(887) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00028705596923828
(888) DESCRIBE `ports` 0.00099015235900879
(889) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00024795532226562
(890) DESCRIBE `ports` 0.00096821784973145
(891) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00023794174194336
(892) DESCRIBE `sailingdates` 0.00089001655578613
(893) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74735') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064802169799805
(894) DESCRIBE `ports` 0.0011050701141357
(895) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00027108192443848
(896) DESCRIBE `ports` 0.00067806243896484
(897) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0001981258392334
(898) DESCRIBE `ports` 0.00067877769470215
(899) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00021600723266602
(900) DESCRIBE `ports` 0.00076198577880859
(901) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00018692016601562
(902) DESCRIBE `ports` 0.00069689750671387
(903) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.00020790100097656
(904) DESCRIBE `ports` 0.00067687034606934
(905) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00018811225891113
(906) DESCRIBE `ports` 0.00066995620727539
(907) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00020503997802734
(908) DESCRIBE `ports` 0.00081110000610352
(909) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00018620491027832
(910) DESCRIBE `ports` 0.00066208839416504
(911) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00020098686218262
(912) DESCRIBE `ports` 0.0009150505065918
(913) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00024199485778809
(914) DESCRIBE `ports` 0.00097799301147461
(915) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00023102760314941
(916) DESCRIBE `ports` 0.00070500373840332
(917) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00018715858459473
(918) DESCRIBE `ports` 0.0006709098815918
(919) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2259))) 0.00020313262939453
(920) DESCRIBE `ports` 0.00068402290344238
(921) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2259') 0.00020718574523926
(922) DESCRIBE `ports` 0.00086593627929688
(923) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00020790100097656
(924) DESCRIBE `ports` 0.00069379806518555
(925) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00020098686218262
(926) DESCRIBE `ports` 0.00090599060058594
(927) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00022006034851074
(928) DESCRIBE `ports` 0.00073504447937012
(929) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00018787384033203
(930) DESCRIBE `ports` 0.00067400932312012
(931) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00020909309387207
(932) DESCRIBE `ports` 0.00069713592529297
(933) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00018692016601562
(934) DESCRIBE `ports` 0.00082111358642578
(935) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020790100097656
(936) DESCRIBE `ports` 0.0006859302520752
(937) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018310546875
(938) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74735') AND (sailingdate >= '2018-04-24') 0.0055010318756104
(939) DESCRIBE `avid_specials` 0.00073003768920898
(940) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74735 and class = 'Cruise') OR (item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine') OR (item_id = 49 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.0010700225830078
(941) DESCRIBE `cruiselines` 0.00097799301147461
(942) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00050187110900879
(943) DESCRIBE `orchid_image` 0.0010249614715576
(944) DESCRIBE `cruiselines` 0.00096797943115234
(945) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00020790100097656
(946) DESCRIBE `cruises` 0.0014190673828125
(947) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69044') 0.00027203559875488
(948) DESCRIBE `ships` 0.0012998580932617
(949) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 823))) 0.00026798248291016
(950) DESCRIBE `ships` 0.001270055770874
(951) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00023818016052246
(952) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023412704467773
(953) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022721290588379
(954) DESCRIBE `itineraries` 0.00070714950561523
(955) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69044') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048494338989258
(956) DESCRIBE `ports` 0.00082898139953613
(957) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00023889541625977
(958) DESCRIBE `ports` 0.00067305564880371
(959) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00020885467529297
(960) DESCRIBE `ports` 0.00066900253295898
(961) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00019311904907227
(962) DESCRIBE `sailingdates` 0.00060415267944336
(963) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69044') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036406517028809
(964) DESCRIBE `ports` 0.0006859302520752
(965) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00020885467529297
(966) DESCRIBE `ports` 0.000823974609375
(967) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00025296211242676
(968) DESCRIBE `ports` 0.00081300735473633
(969) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00024294853210449
(970) DESCRIBE `ports` 0.00069403648376465
(971) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00018906593322754
(972) DESCRIBE `ports` 0.00067806243896484
(973) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0002140998840332
(974) DESCRIBE `ports` 0.00070095062255859
(975) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018692016601562
(976) DESCRIBE `ports` 0.00066900253295898
(977) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020694732666016
(978) DESCRIBE `ports` 0.00066399574279785
(979) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018692016601562
(980) DESCRIBE `ports` 0.00067687034606934
(981) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020313262939453
(982) DESCRIBE `ports` 0.00066494941711426
(983) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018692016601562
(984) DESCRIBE `ports` 0.00066494941711426
(985) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00020503997802734
(986) DESCRIBE `ports` 0.00073814392089844
(987) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00018882751464844
(988) DESCRIBE `ports` 0.00066995620727539
(989) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.0002129077911377
(990) DESCRIBE `ports` 0.00068998336791992
(991) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018715858459473
(992) DESCRIBE `ports` 0.00066685676574707
(993) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020718574523926
(994) DESCRIBE `ports` 0.0006721019744873
(995) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019311904907227
(996) DESCRIBE `ports` 0.00068402290344238
(997) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021100044250488
(998) DESCRIBE `ports` 0.00067305564880371
(999) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00020098686218262
(1000) DESCRIBE `ports` 0.00066804885864258
(1001) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5935))) 0.00024509429931641
(1002) DESCRIBE `ports` 0.00068902969360352
(1003) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5935') 0.0001828670501709
(1004) DESCRIBE `ports` 0.00066614151000977
(1005) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.0001981258392334
(1006) DESCRIBE `ports` 0.00073504447937012
(1007) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00020885467529297
(1008) DESCRIBE `ports` 0.00072884559631348
(1009) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00028204917907715
(1010) DESCRIBE `ports` 0.00084209442138672
(1011) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00026893615722656
(1012) DESCRIBE `ports` 0.00068402290344238
(1013) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0002138614654541
(1014) DESCRIBE `ports` 0.00096607208251953
(1015) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00020599365234375
(1016) DESCRIBE `ports` 0.00074982643127441
(1017) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00024986267089844
(1018) DESCRIBE `ports` 0.00075602531433105
(1019) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00024008750915527
(1020) DESCRIBE `ports` 0.00069689750671387
(1021) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00022482872009277
(1022) DESCRIBE `ports` 0.00068306922912598
(1023) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00021100044250488
(1024) DESCRIBE `ports` 0.00070691108703613
(1025) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00021100044250488
(1026) DESCRIBE `ports` 0.0007479190826416
(1027) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00026178359985352
(1028) DESCRIBE `ports` 0.00079894065856934
(1029) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022506713867188
(1030) DESCRIBE `ports` 0.00080609321594238
(1031) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00024199485778809
(1032) DESCRIBE `ports` 0.0009300708770752
(1033) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4013))) 0.0002138614654541
(1034) DESCRIBE `ports` 0.00066995620727539
(1035) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4013') 0.00018596649169922
(1036) DESCRIBE `ports` 0.00078606605529785
(1037) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00027203559875488
(1038) DESCRIBE `ports` 0.00081396102905273
(1039) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019192695617676
(1040) DESCRIBE `ports` 0.00071477890014648
(1041) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00023698806762695
(1042) DESCRIBE `ports` 0.00089406967163086
(1043) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019598007202148
(1044) DESCRIBE `ports` 0.00067400932312012
(1045) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020790100097656
(1046) DESCRIBE `ports` 0.00079488754272461
(1047) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00019693374633789
(1048) DESCRIBE `ports` 0.00069212913513184
(1049) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020694732666016
(1050) DESCRIBE `ports` 0.00076007843017578
(1051) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00022411346435547
(1052) DESCRIBE `ports` 0.0006871223449707
(1053) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00025701522827148
(1054) DESCRIBE `ports` 0.00074195861816406
(1055) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00024700164794922
(1056) DESCRIBE `ports` 0.0010240077972412
(1057) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00034713745117188
(1058) DESCRIBE `ports` 0.001054048538208
(1059) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002589225769043
(1060) DESCRIBE `ports` 0.00096297264099121
(1061) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00025486946105957
(1062) DESCRIBE `ports` 0.00077700614929199
(1063) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022697448730469
(1064) DESCRIBE `ports` 0.00069808959960938
(1065) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020694732666016
(1066) DESCRIBE `ports` 0.00067901611328125
(1067) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00019311904907227
(1068) DESCRIBE `ports` 0.00074005126953125
(1069) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00020885467529297
(1070) DESCRIBE `ports` 0.00067377090454102
(1071) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00019097328186035
(1072) DESCRIBE `ports` 0.0010058879852295
(1073) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00023293495178223
(1074) DESCRIBE `ports` 0.00070810317993164
(1075) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00025796890258789
(1076) DESCRIBE `ports` 0.00079989433288574
(1077) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00022411346435547
(1078) DESCRIBE `ports` 0.00073695182800293
(1079) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00021505355834961
(1080) DESCRIBE `ports` 0.00072312355041504
(1081) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00021505355834961
(1082) DESCRIBE `ports` 0.00068187713623047
(1083) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00023102760314941
(1084) DESCRIBE `ports` 0.00084614753723145
(1085) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00021696090698242
(1086) DESCRIBE `ports` 0.0008080005645752
(1087) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00025105476379395
(1088) DESCRIBE `ports` 0.00099015235900879
(1089) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00029206275939941
(1090) DESCRIBE `ports` 0.0010387897491455
(1091) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00026512145996094
(1092) DESCRIBE `ports` 0.0010321140289307
(1093) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00029087066650391
(1094) DESCRIBE `ports` 0.00099992752075195
(1095) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00021505355834961
(1096) DESCRIBE `ports` 0.00069785118103027
(1097) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00025701522827148
(1098) DESCRIBE `ports` 0.00077199935913086
(1099) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00024580955505371
(1100) DESCRIBE `ports` 0.00074219703674316
(1101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021600723266602
(1102) DESCRIBE `ports` 0.00066900253295898
(1103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018787384033203
(1104) DESCRIBE `ports` 0.00070595741271973
(1105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00025296211242676
(1106) DESCRIBE `ports` 0.00095796585083008
(1107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00025081634521484
(1108) DESCRIBE `ports` 0.0010130405426025
(1109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027680397033691
(1110) DESCRIBE `ports` 0.0010089874267578
(1111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00025820732116699
(1112) DESCRIBE `ports` 0.00092983245849609
(1113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027298927307129
(1114) DESCRIBE `ports` 0.00085091590881348
(1115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019502639770508
(1116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69044') AND (sailingdate >= '2018-04-24') 0.0063939094543457
(1117) DESCRIBE `avid_specials` 0.0010449886322021
(1118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69044 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.0010199546813965
(1119) DESCRIBE `cruiselines` 0.0010268688201904
(1120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00030517578125
(1121) DESCRIBE `orchid_image` 0.00077986717224121
(1122) DESCRIBE `cruiselines` 0.00094795227050781
(1123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00022006034851074
(1124) DESCRIBE `ships` 0.0022249221801758
(1125) SELECT `ships`.* FROM `ships` WHERE (id IN ('823')) ORDER BY FIND_IN_SET(id, '823') 0.0004279613494873
(1126) DESCRIBE `cruisetypes` 0.00095415115356445
(1127) 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.037545919418335
(1128) DESCRIBE `destinations` 0.0016241073608398
(1129) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '28', '49', '40', '21', '25', '35', '26', '30', '52')) ORDER BY FIND_IN_SET(id, '22,28,49,40,21,25,35,26,30,52') 0.0011649131774902
(1130) DESCRIBE `cruiselines` 0.0076990127563477
(1131) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0003809928894043
(1132) DESCRIBE `cruiselines` 0.0012540817260742
(1133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00031805038452148