or, enquire about your chosen options

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

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

Total elapsed time: 0.36791729927063

# Query Time
(1) connect 0.00055694580078125
(2) DESCRIBE `cruises` 0.0017471313476562
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67838, 62516, 64101, 67862, 70581, 54648, 59347, 66503, 68050, 66524)) ORDER BY FIND_IN_SET(id, '67838,62516,64101,67862,70581,54648,59347,66503,68050,66524') 0.001101016998291
(4) DESCRIBE `cruises` 0.0017499923706055
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67838') 0.00025105476379395
(6) DESCRIBE `ships` 0.0012860298156738
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00025510787963867
(8) DESCRIBE `ships` 0.0012500286102295
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00017905235290527
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016188621520996
(12) DESCRIBE `itineraries` 0.00066804885864258
(13) DESCRIBE `ports` 0.00067996978759766
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00020408630371094
(15) DESCRIBE `ports` 0.00068306922912598
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00019001960754395
(17) DESCRIBE `ports` 0.00065898895263672
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00017285346984863
(19) DESCRIBE `sailingdates` 0.0005948543548584
(20) DESCRIBE `ports` 0.00069379806518555
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00019192695617676
(22) DESCRIBE `ports` 0.00066614151000977
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00017499923706055
(24) DESCRIBE `ports` 0.00065708160400391
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00019407272338867
(26) DESCRIBE `ports` 0.0006871223449707
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00017499923706055
(28) DESCRIBE `ports` 0.00066184997558594
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00019693374633789
(30) DESCRIBE `ports` 0.00072097778320312
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00017285346984863
(32) DESCRIBE `ports` 0.00066399574279785
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00018692016601562
(34) DESCRIBE `ports` 0.00065708160400391
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00016999244689941
(36) DESCRIBE `ports` 0.00072717666625977
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00022506713867188
(38) DESCRIBE `ports` 0.00068807601928711
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00017404556274414
(40) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67838') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0054728984832764
(41) DESCRIBE `avid_specials` 0.00064492225646973
(42) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67838 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00091814994812012
(43) DESCRIBE `cruiselines` 0.0010039806365967
(44) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021791458129883
(45) DESCRIBE `orchid_image` 0.00076818466186523
(46) DESCRIBE `cruiselines` 0.00090813636779785
(47) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018191337585449
(48) DESCRIBE `cruises` 0.0013470649719238
(49) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62516') 0.00020599365234375
(50) DESCRIBE `ships` 0.0012729167938232
(51) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00023198127746582
(52) DESCRIBE `ships` 0.0012650489807129
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00017499923706055
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017714500427246
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(56) DESCRIBE `itineraries` 0.00066208839416504
(57) DESCRIBE `ports` 0.00071501731872559
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020694732666016
(59) DESCRIBE `ports` 0.00073790550231934
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019383430480957
(61) DESCRIBE `ports` 0.00078582763671875
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017905235290527
(63) DESCRIBE `sailingdates` 0.00064182281494141
(64) DESCRIBE `ports` 0.00068497657775879
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00022196769714355
(66) DESCRIBE `ports` 0.00066804885864258
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017905235290527
(68) DESCRIBE `ports` 0.00066089630126953
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00019502639770508
(70) DESCRIBE `ports` 0.00067782402038574
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.0002140998840332
(72) DESCRIBE `ports` 0.00073790550231934
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00020503997802734
(74) DESCRIBE `ports` 0.00067901611328125
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00017786026000977
(76) DESCRIBE `ports` 0.00068807601928711
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020599365234375
(78) DESCRIBE `ports` 0.00066089630126953
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00023412704467773
(80) DESCRIBE `ports` 0.00078582763671875
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00019621849060059
(82) DESCRIBE `ports` 0.00069594383239746
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00017714500427246
(84) DESCRIBE `ports` 0.00066399574279785
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0001981258392334
(86) DESCRIBE `ports` 0.00066113471984863
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00017595291137695
(88) DESCRIBE `ports` 0.00068402290344238
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00020289421081543
(90) DESCRIBE `ports` 0.00066494941711426
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00018095970153809
(92) DESCRIBE `ports` 0.00066804885864258
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020194053649902
(94) DESCRIBE `ports` 0.00066709518432617
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017619132995605
(96) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62516') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0053718090057373
(97) DESCRIBE `avid_specials` 0.00063920021057129
(98) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62516 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.00091099739074707
(99) DESCRIBE `cruiselines` 0.0010130405426025
(100) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021696090698242
(101) DESCRIBE `orchid_image` 0.00079083442687988
(102) DESCRIBE `cruiselines` 0.0010409355163574
(103) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018501281738281
(104) DESCRIBE `cruises` 0.0014259815216064
(105) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64101') 0.00019693374633789
(106) DESCRIBE `ships` 0.0012819766998291
(107) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00027084350585938
(108) DESCRIBE `ships` 0.0013091564178467
(109) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00017690658569336
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019693374633789
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(112) DESCRIBE `itineraries` 0.00067710876464844
(113) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64101') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00096011161804199
(114) DESCRIBE `ports` 0.00069713592529297
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0002129077911377
(116) DESCRIBE `ports` 0.0007021427154541
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00019693374633789
(118) DESCRIBE `ports` 0.00066208839416504
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00017905235290527
(120) DESCRIBE `sailingdates` 0.00063586235046387
(121) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64101') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082302093505859
(122) DESCRIBE `ports` 0.00074291229248047
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00020098686218262
(124) DESCRIBE `ports` 0.00076794624328613
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00018215179443359
(126) DESCRIBE `ports` 0.00075697898864746
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00020313262939453
(128) DESCRIBE `ports` 0.00077486038208008
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00017595291137695
(130) DESCRIBE `ports` 0.00066590309143066
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.0001981258392334
(132) DESCRIBE `ports` 0.00070285797119141
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00019216537475586
(134) DESCRIBE `ports` 0.0006711483001709
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00019311904907227
(136) DESCRIBE `ports` 0.00072407722473145
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018596649169922
(138) DESCRIBE `ports` 0.00067400932312012
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00019598007202148
(140) DESCRIBE `ports` 0.00066518783569336
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00018000602722168
(142) DESCRIBE `ports` 0.00073790550231934
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00019693374633789
(144) DESCRIBE `ports` 0.00069904327392578
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00018119812011719
(146) DESCRIBE `ports` 0.00066399574279785
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020194053649902
(148) DESCRIBE `ports` 0.00066184997558594
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017690658569336
(150) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64101') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0054008960723877
(151) DESCRIBE `avid_specials` 0.00064206123352051
(152) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64101 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010080337524414
(153) DESCRIBE `cruiselines` 0.0010149478912354
(154) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021791458129883
(155) DESCRIBE `orchid_image` 0.00079798698425293
(156) DESCRIBE `cruiselines` 0.00094103813171387
(157) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033688545227051
(158) DESCRIBE `cruises` 0.0018959045410156
(159) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67862') 0.0003058910369873
(160) DESCRIBE `ships` 0.002129077911377
(161) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00026106834411621
(162) DESCRIBE `ships` 0.0013868808746338
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00022506713867188
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(166) DESCRIBE `itineraries` 0.00072407722473145
(167) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67862') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014159679412842
(168) DESCRIBE `ports` 0.0010640621185303
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00038409233093262
(170) DESCRIBE `ports` 0.00097894668579102
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00025296211242676
(172) DESCRIBE `ports` 0.00083208084106445
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00018596649169922
(174) DESCRIBE `sailingdates` 0.0006108283996582
(175) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67862') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043702125549316
(176) DESCRIBE `ports` 0.00070905685424805
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00019502639770508
(178) DESCRIBE `ports` 0.00095009803771973
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.0002291202545166
(180) DESCRIBE `ports` 0.00098395347595215
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00025296211242676
(182) DESCRIBE `ports` 0.00096607208251953
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00024509429931641
(184) DESCRIBE `ports` 0.00099802017211914
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00024986267089844
(186) DESCRIBE `ports` 0.00088691711425781
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00019502639770508
(188) DESCRIBE `ports` 0.00069189071655273
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0001990795135498
(190) DESCRIBE `ports` 0.00083684921264648
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00017499923706055
(192) DESCRIBE `ports` 0.00067400932312012
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00019216537475586
(194) DESCRIBE `ports` 0.00069594383239746
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00017809867858887
(196) DESCRIBE `ports` 0.00087809562683105
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.0001988410949707
(198) DESCRIBE `ports` 0.0006709098815918
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00017714500427246
(200) DESCRIBE `ports` 0.00069308280944824
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00019693374633789
(202) DESCRIBE `ports` 0.00066304206848145
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00017690658569336
(204) DESCRIBE `ports` 0.00066590309143066
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00019693374633789
(206) DESCRIBE `ports` 0.00066900253295898
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017619132995605
(208) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67862') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.005263090133667
(209) DESCRIBE `avid_specials` 0.00065016746520996
(210) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67862 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009160041809082
(211) DESCRIBE `cruiselines` 0.00098109245300293
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0002291202545166
(213) DESCRIBE `orchid_image` 0.00077104568481445
(214) DESCRIBE `cruiselines` 0.00092220306396484
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00032186508178711
(216) DESCRIBE `cruises` 0.0013179779052734
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70581') 0.00020289421081543
(218) DESCRIBE `ships` 0.0012698173522949
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00023102760314941
(220) DESCRIBE `ships` 0.0013489723205566
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00018906593322754
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021481513977051
(224) DESCRIBE `itineraries` 0.00078392028808594
(225) DESCRIBE `ports` 0.00072503089904785
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024294853210449
(227) DESCRIBE `ports` 0.00076794624328613
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019717216491699
(229) DESCRIBE `ports` 0.00091099739074707
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023889541625977
(231) DESCRIBE `sailingdates` 0.00084209442138672
(232) DESCRIBE `ports` 0.0010840892791748
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022697448730469
(234) DESCRIBE `ports` 0.00069499015808105
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018405914306641
(236) DESCRIBE `ports` 0.00067305564880371
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0001978874206543
(238) DESCRIBE `ports` 0.00068378448486328
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00017619132995605
(240) DESCRIBE `ports` 0.00066685676574707
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00020503997802734
(242) DESCRIBE `ports` 0.0006721019744873
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00019717216491699
(244) DESCRIBE `ports` 0.00071501731872559
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00022101402282715
(246) DESCRIBE `ports` 0.00068211555480957
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00017404556274414
(248) DESCRIBE `ports` 0.00071597099304199
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019693374633789
(250) DESCRIBE `ports` 0.00066614151000977
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017786026000977
(252) DESCRIBE `ports` 0.00069093704223633
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0001978874206543
(254) DESCRIBE `ports` 0.00193190574646
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0040891170501709
(256) DESCRIBE `ports` 0.00092816352844238
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00021195411682129
(258) DESCRIBE `ports` 0.00069713592529297
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00018215179443359
(260) DESCRIBE `ports` 0.00071811676025391
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00020503997802734
(262) DESCRIBE `ports` 0.00075197219848633
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00018000602722168
(264) DESCRIBE `ports` 0.00068998336791992
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0001981258392334
(266) DESCRIBE `ports` 0.00072288513183594
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017905235290527
(268) DESCRIBE `ports` 0.00070405006408691
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0001988410949707
(270) DESCRIBE `ports` 0.00068521499633789
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017690658569336
(272) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70581') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0053300857543945
(273) DESCRIBE `avid_specials` 0.0006859302520752
(274) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70581 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 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.0010421276092529
(275) DESCRIBE `cruiselines` 0.0011088848114014
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0002899169921875
(277) DESCRIBE `orchid_image` 0.0007789134979248
(278) DESCRIBE `cruiselines` 0.00099301338195801
(279) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018906593322754
(280) DESCRIBE `cruises` 0.001410961151123
(281) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54648') 0.00020694732666016
(282) DESCRIBE `ships` 0.0013010501861572
(283) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00025701522827148
(284) DESCRIBE `ships` 0.0015299320220947
(285) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00022196769714355
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(288) DESCRIBE `itineraries` 0.00078678131103516
(289) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '54648') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012381076812744
(290) DESCRIBE `ports` 0.00073695182800293
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021505355834961
(292) DESCRIBE `ports` 0.00073599815368652
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020599365234375
(294) DESCRIBE `ports` 0.00083589553833008
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018811225891113
(296) DESCRIBE `sailingdates` 0.00063896179199219
(297) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '54648') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012111663818359
(298) DESCRIBE `ports` 0.00080990791320801
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022411346435547
(300) DESCRIBE `ports` 0.0010700225830078
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00023412704467773
(302) DESCRIBE `ports` 0.00068092346191406
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00026679039001465
(304) DESCRIBE `ports` 0.00091290473937988
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018692016601562
(306) DESCRIBE `ports` 0.00066804885864258
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0001978874206543
(308) DESCRIBE `ports` 0.00070095062255859
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018119812011719
(310) DESCRIBE `ports` 0.00067710876464844
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019693374633789
(312) DESCRIBE `ports` 0.00067996978759766
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017905235290527
(314) DESCRIBE `ports` 0.00068902969360352
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00023984909057617
(316) DESCRIBE `ports` 0.00067305564880371
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0001828670501709
(318) DESCRIBE `ports` 0.00074505805969238
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00021100044250488
(320) DESCRIBE `ports` 0.00078296661376953
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00018501281738281
(322) DESCRIBE `ports` 0.00067305564880371
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020098686218262
(324) DESCRIBE `ports` 0.00067400932312012
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00020313262939453
(326) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54648') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0087969303131104
(327) DESCRIBE `avid_specials` 0.00083589553833008
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54648 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.0010008811950684
(329) DESCRIBE `cruiselines` 0.0010318756103516
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0002288818359375
(331) DESCRIBE `orchid_image` 0.00076603889465332
(332) DESCRIBE `cruiselines` 0.00095105171203613
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018596649169922
(334) DESCRIBE `cruises` 0.001276969909668
(335) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59347') 0.00021100044250488
(336) DESCRIBE `ships` 0.0012590885162354
(337) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00023889541625977
(338) DESCRIBE `ships` 0.0012609958648682
(339) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00018692016601562
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018692016601562
(342) DESCRIBE `itineraries` 0.00066494941711426
(343) DESCRIBE `ports` 0.00072717666625977
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00024294853210449
(345) DESCRIBE `ports` 0.00067400932312012
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00023388862609863
(347) DESCRIBE `ports` 0.00069189071655273
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018095970153809
(349) DESCRIBE `sailingdates` 0.0006411075592041
(350) DESCRIBE `ports` 0.00070500373840332
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020313262939453
(352) DESCRIBE `ports` 0.00067281723022461
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018119812011719
(354) DESCRIBE `ports` 0.00067782402038574
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019717216491699
(356) DESCRIBE `ports` 0.00066280364990234
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00020313262939453
(358) DESCRIBE `ports` 0.0006709098815918
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0001978874206543
(360) DESCRIBE `ports` 0.00075316429138184
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017189979553223
(362) DESCRIBE `ports` 0.00065708160400391
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00019288063049316
(364) DESCRIBE `ports` 0.0006709098815918
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018095970153809
(366) DESCRIBE `ports` 0.00066208839416504
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00021696090698242
(368) DESCRIBE `ports` 0.00076389312744141
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017285346984863
(370) DESCRIBE `ports` 0.00066208839416504
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00019407272338867
(372) DESCRIBE `ports` 0.0006561279296875
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00017309188842773
(374) DESCRIBE `ports` 0.00067496299743652
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00019097328186035
(376) DESCRIBE `ports` 0.00065994262695312
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00019001960754395
(378) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '59347') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0055301189422607
(379) DESCRIBE `avid_specials` 0.00066304206848145
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59347 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.00098705291748047
(381) DESCRIBE `cruiselines` 0.0010139942169189
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022602081298828
(383) DESCRIBE `orchid_image` 0.00075411796569824
(384) DESCRIBE `cruiselines` 0.00090193748474121
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018310546875
(386) DESCRIBE `cruises` 0.0012660026550293
(387) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66503') 0.0001981258392334
(388) DESCRIBE `ships` 0.0018448829650879
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00032711029052734
(390) DESCRIBE `ships` 0.001849889755249
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00021791458129883
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(394) DESCRIBE `itineraries` 0.00092601776123047
(395) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66503') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012409687042236
(396) DESCRIBE `ports` 0.00099086761474609
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00026106834411621
(398) DESCRIBE `ports` 0.00095081329345703
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00024700164794922
(400) DESCRIBE `ports` 0.00096797943115234
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00024509429931641
(402) DESCRIBE `sailingdates` 0.00077605247497559
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66503') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076198577880859
(404) DESCRIBE `ports` 0.00072002410888672
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020217895507812
(406) DESCRIBE `ports` 0.00070405006408691
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00019097328186035
(408) DESCRIBE `ports` 0.00066590309143066
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00019693374633789
(410) DESCRIBE `ports` 0.00069689750671387
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00018596649169922
(412) DESCRIBE `ports` 0.0007319450378418
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020098686218262
(414) DESCRIBE `ports` 0.00066900253295898
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00020503997802734
(416) DESCRIBE `ports` 0.00065779685974121
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019097328186035
(418) DESCRIBE `ports` 0.00073599815368652
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017690658569336
(420) DESCRIBE `ports` 0.00072503089904785
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019621849060059
(422) DESCRIBE `ports` 0.00070405006408691
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017499923706055
(424) DESCRIBE `ports` 0.00075602531433105
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019383430480957
(426) DESCRIBE `ports` 0.00075411796569824
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018596649169922
(428) DESCRIBE `ports` 0.00066804885864258
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0001981258392334
(430) DESCRIBE `ports` 0.00069904327392578
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017595291137695
(432) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66503') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0053670406341553
(433) DESCRIBE `avid_specials` 0.00087189674377441
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66503 and class = 'Cruise') OR (item_id = 253 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.0010209083557129
(435) DESCRIBE `cruiselines` 0.00098204612731934
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021791458129883
(437) DESCRIBE `orchid_image` 0.00082898139953613
(438) DESCRIBE `cruiselines` 0.0009150505065918
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019598007202148
(440) DESCRIBE `cruises` 0.0012528896331787
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68050') 0.00018692016601562
(442) DESCRIBE `ships` 0.0012619495391846
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00023508071899414
(444) DESCRIBE `ships` 0.0012619495391846
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00017809867858887
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(448) DESCRIBE `itineraries` 0.0006711483001709
(449) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68050') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011329650878906
(450) DESCRIBE `ports` 0.00072813034057617
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022697448730469
(452) DESCRIBE `ports` 0.00067806243896484
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020098686218262
(454) DESCRIBE `ports` 0.0006868839263916
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018000602722168
(456) DESCRIBE `sailingdates` 0.00063395500183105
(457) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68050') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075387954711914
(458) DESCRIBE `ports` 0.000762939453125
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019598007202148
(460) DESCRIBE `ports` 0.00068211555480957
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017595291137695
(462) DESCRIBE `ports` 0.00068998336791992
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00020599365234375
(464) DESCRIBE `ports` 0.00076198577880859
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00017905235290527
(466) DESCRIBE `ports` 0.00067400932312012
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00022602081298828
(468) DESCRIBE `ports` 0.00070405006408691
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018000602722168
(470) DESCRIBE `ports` 0.0006711483001709
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00019097328186035
(472) DESCRIBE `ports` 0.00066494941711426
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00017285346984863
(474) DESCRIBE `ports` 0.00069212913513184
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020813941955566
(476) DESCRIBE `ports` 0.00066995620727539
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017690658569336
(478) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68050') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0054221153259277
(479) DESCRIBE `avid_specials` 0.00071096420288086
(480) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68050 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 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.00092792510986328
(481) DESCRIBE `cruiselines` 0.00099587440490723
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00025701522827148
(483) DESCRIBE `orchid_image` 0.00076389312744141
(484) DESCRIBE `cruiselines` 0.0010361671447754
(485) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018405914306641
(486) DESCRIBE `cruises` 0.0012750625610352
(487) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66524') 0.00019311904907227
(488) DESCRIBE `ships` 0.0012860298156738
(489) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00023007392883301
(490) DESCRIBE `ships` 0.0013139247894287
(491) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00017809867858887
(492) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(493) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(494) DESCRIBE `itineraries` 0.00066184997558594
(495) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66524') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00201416015625
(496) DESCRIBE `ports` 0.00080299377441406
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022506713867188
(498) DESCRIBE `ports` 0.00071501731872559
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0001990795135498
(500) DESCRIBE `ports` 0.00067615509033203
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018310546875
(502) DESCRIBE `sailingdates` 0.00064301490783691
(503) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66524') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050711631774902
(504) DESCRIBE `ports` 0.00072002410888672
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020813941955566
(506) DESCRIBE `ports` 0.00069999694824219
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018191337585449
(508) DESCRIBE `ports` 0.00071907043457031
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00020813941955566
(510) DESCRIBE `ports` 0.00068497657775879
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00018596649169922
(512) DESCRIBE `ports` 0.00069093704223633
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020313262939453
(514) DESCRIBE `ports` 0.00067687034606934
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018191337585449
(516) DESCRIBE `ports` 0.00074386596679688
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0001990795135498
(518) DESCRIBE `ports` 0.00067687034606934
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00020194053649902
(520) DESCRIBE `ports` 0.0007331371307373
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3719))) 0.00020313262939453
(522) DESCRIBE `ports` 0.00067901611328125
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3719') 0.00018095970153809
(524) DESCRIBE `ports` 0.0006709098815918
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020718574523926
(526) DESCRIBE `ports` 0.00071597099304199
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00018000602722168
(528) DESCRIBE `ports` 0.00072383880615234
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020503997802734
(530) DESCRIBE `ports` 0.00070786476135254
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019288063049316
(532) DESCRIBE `ports` 0.00067019462585449
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019502639770508
(534) DESCRIBE `ports` 0.0007021427154541
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017905235290527
(536) DESCRIBE `ports` 0.0006711483001709
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020194053649902
(538) DESCRIBE `ports` 0.00066995620727539
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017905235290527
(540) DESCRIBE `ports` 0.00066614151000977
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0001981258392334
(542) DESCRIBE `ports` 0.00069093704223633
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018000602722168
(544) DESCRIBE `ports` 0.00066900253295898
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00019621849060059
(546) DESCRIBE `ports` 0.00066900253295898
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018095970153809
(548) DESCRIBE `ports` 0.00070500373840332
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020313262939453
(550) DESCRIBE `ports` 0.00067281723022461
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017905235290527
(552) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66524') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.005403995513916
(553) DESCRIBE `avid_specials` 0.00065708160400391
(554) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66524 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 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.00093698501586914
(555) DESCRIBE `cruiselines` 0.00097298622131348
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024604797363281
(557) DESCRIBE `orchid_image` 0.00076007843017578
(558) DESCRIBE `cruiselines` 0.0009160041809082
(559) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018310546875
(560) DESCRIBE `ships` 0.0014269351959229
(561) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '1135', '542', '434', '1021', '678', '406', '253', '348', '580', '290', '451', '98', '105', '291', '341', '1409')) ORDER BY FIND_IN_SET(id, '349,1135,542,434,1021,678,406,253,348,580,290,451,98,105,291,341,1409') 0.00075888633728027
(562) DESCRIBE `cruisetypes` 0.00060606002807617
(563) DESCRIBE `destinations` 0.00090789794921875
(564) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '43', '22', '48', '53', '8', '26', '34', '40', '38', '29', '21', '37', '11', '25', '28', '30', '49')) ORDER BY FIND_IN_SET(id, '12,35,2,43,22,48,53,8,26,34,40,38,29,21,37,11,25,28,30,49') 0.00081801414489746
(565) DESCRIBE `cruiselines` 0.00097107887268066
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023889541625977
(567) DESCRIBE `cruiselines` 0.0010240077972412
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022792816162109