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

Total elapsed time: 0.33396553993225

# Query Time
(1) connect 0.0005640983581543
(2) DESCRIBE `cruises` 0.001701831817627
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65888, 41778, 41780, 63370, 55703, 65889, 50857, 41776, 65890, 65912)) ORDER BY FIND_IN_SET(id, '65888,41778,41780,63370,55703,65889,50857,41776,65890,65912') 0.00086188316345215
(4) DESCRIBE `cruises` 0.0020670890808105
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65888') 0.00031805038452148
(6) DESCRIBE `ships` 0.0014290809631348
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00025105476379395
(8) DESCRIBE `ships` 0.0012481212615967
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00017905235290527
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017380714416504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(12) DESCRIBE `itineraries` 0.00071191787719727
(13) DESCRIBE `ports` 0.00069594383239746
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023508071899414
(15) DESCRIBE `ports` 0.00086283683776855
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025200843811035
(17) DESCRIBE `ports` 0.00084710121154785
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023007392883301
(19) DESCRIBE `sailingdates` 0.00081300735473633
(20) DESCRIBE `ports` 0.0009458065032959
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029087066650391
(22) DESCRIBE `ports` 0.00096511840820312
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023198127746582
(24) DESCRIBE `ports` 0.00069689750671387
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020885467529297
(26) DESCRIBE `ports` 0.00066995620727539
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018596649169922
(28) DESCRIBE `ports` 0.00065898895263672
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00021004676818848
(30) DESCRIBE `ports` 0.00066089630126953
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00018787384033203
(32) DESCRIBE `ports` 0.00071501731872559
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020313262939453
(34) DESCRIBE `ports` 0.00067520141601562
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00017595291137695
(36) DESCRIBE `ports` 0.00073814392089844
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0001988410949707
(38) DESCRIBE `ports` 0.00068497657775879
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017499923706055
(40) DESCRIBE `ports` 0.00070810317993164
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019502639770508
(42) DESCRIBE `ports` 0.00068211555480957
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017404556274414
(44) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65888') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0053701400756836
(45) DESCRIBE `avid_specials` 0.00073719024658203
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65888 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00095891952514648
(47) DESCRIBE `cruiselines` 0.0009918212890625
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022101402282715
(49) DESCRIBE `orchid_image` 0.00078392028808594
(50) DESCRIBE `cruiselines` 0.00097489356994629
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018882751464844
(52) DESCRIBE `cruises` 0.0012869834899902
(53) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00020289421081543
(54) DESCRIBE `ships` 0.001331090927124
(55) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00026392936706543
(56) DESCRIBE `ships` 0.0012819766998291
(57) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00018095970153809
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(60) DESCRIBE `itineraries` 0.00076699256896973
(61) DESCRIBE `ports` 0.00075101852416992
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021004676818848
(63) DESCRIBE `ports` 0.00071310997009277
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019001960754395
(65) DESCRIBE `ports` 0.00081896781921387
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(67) DESCRIBE `sailingdates` 0.00060296058654785
(68) DESCRIBE `ports` 0.00068378448486328
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(70) DESCRIBE `ports` 0.00066304206848145
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(72) DESCRIBE `ports` 0.00074100494384766
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019097328186035
(74) DESCRIBE `ports` 0.00069618225097656
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017499923706055
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41778') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0055279731750488
(77) DESCRIBE `avid_specials` 0.00063109397888184
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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
(79) DESCRIBE `cruiselines` 0.0010511875152588
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023007392883301
(81) DESCRIBE `orchid_image` 0.00080394744873047
(82) DESCRIBE `cruiselines` 0.00099992752075195
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018095970153809
(84) DESCRIBE `cruises` 0.0014009475708008
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41780') 0.00020503997802734
(86) DESCRIBE `ships` 0.0013201236724854
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00027894973754883
(88) DESCRIBE `ships` 0.001291036605835
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00018191337585449
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(92) DESCRIBE `itineraries` 0.0006568431854248
(93) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41780') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011570453643799
(94) DESCRIBE `ports` 0.00098299980163574
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028109550476074
(96) DESCRIBE `ports` 0.00097107887268066
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026297569274902
(98) DESCRIBE `ports` 0.00096607208251953
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001838207244873
(100) DESCRIBE `sailingdates` 0.00060606002807617
(101) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41780') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084209442138672
(102) DESCRIBE `ports` 0.00072288513183594
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020599365234375
(104) DESCRIBE `ports` 0.00067901611328125
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001828670501709
(106) DESCRIBE `ports` 0.00079011917114258
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020098686218262
(108) DESCRIBE `ports` 0.00066399574279785
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00019097328186035
(110) DESCRIBE `ports` 0.00072789192199707
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00019407272338867
(112) DESCRIBE `ports` 0.00068116188049316
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017619132995605
(114) DESCRIBE `ports` 0.00066304206848145
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0001978874206543
(116) DESCRIBE `ports` 0.00082898139953613
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017905235290527
(118) DESCRIBE `ports` 0.00066399574279785
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(120) DESCRIBE `ports` 0.00068402290344238
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017786026000977
(122) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41780') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0061788558959961
(123) DESCRIBE `avid_specials` 0.00080704689025879
(124) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41780 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00098609924316406
(125) DESCRIBE `cruiselines` 0.0010340213775635
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022792816162109
(127) DESCRIBE `orchid_image` 0.00075101852416992
(128) DESCRIBE `cruiselines` 0.0009758472442627
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00019502639770508
(130) DESCRIBE `cruises` 0.0013298988342285
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63370') 0.0002288818359375
(132) DESCRIBE `ships` 0.0012879371643066
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00025105476379395
(134) DESCRIBE `ships` 0.001338005065918
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00023388862609863
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(138) DESCRIBE `itineraries` 0.00070285797119141
(139) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63370') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012879371643066
(140) DESCRIBE `ports` 0.00071191787719727
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002140998840332
(142) DESCRIBE `ports` 0.00068998336791992
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(144) DESCRIBE `ports` 0.00069379806518555
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018191337585449
(146) DESCRIBE `sailingdates` 0.00062799453735352
(147) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63370') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041699409484863
(148) DESCRIBE `ports` 0.00069212913513184
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020599365234375
(150) DESCRIBE `ports` 0.00072312355041504
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(152) DESCRIBE `ports` 0.00067305564880371
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020098686218262
(154) DESCRIBE `ports` 0.00066399574279785
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018095970153809
(156) DESCRIBE `ports` 0.00068092346191406
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00019598007202148
(158) DESCRIBE `ports` 0.00066399574279785
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017499923706055
(160) DESCRIBE `ports` 0.00066494941711426
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0001990795135498
(162) DESCRIBE `ports` 0.00071096420288086
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018405914306641
(164) DESCRIBE `ports` 0.00066590309143066
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020003318786621
(166) DESCRIBE `ports` 0.00065994262695312
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017905235290527
(168) DESCRIBE `ports` 0.00069594383239746
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020313262939453
(170) DESCRIBE `ports` 0.00066304206848145
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(172) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63370') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0053920745849609
(173) DESCRIBE `avid_specials` 0.00066399574279785
(174) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63370 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00090217590332031
(175) DESCRIBE `cruiselines` 0.0009760856628418
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022697448730469
(177) DESCRIBE `orchid_image` 0.00075006484985352
(178) DESCRIBE `cruiselines` 0.00091290473937988
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018095970153809
(180) DESCRIBE `cruises` 0.0012490749359131
(181) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00019097328186035
(182) DESCRIBE `ships` 0.0012879371643066
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00024509429931641
(184) DESCRIBE `ships` 0.0012400150299072
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00018119812011719
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017786026000977
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(188) DESCRIBE `itineraries` 0.00065207481384277
(189) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55703') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048494338989258
(190) DESCRIBE `ports` 0.00068402290344238
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020384788513184
(192) DESCRIBE `ports` 0.00066900253295898
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(194) DESCRIBE `ports` 0.00066304206848145
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018191337585449
(196) DESCRIBE `sailingdates` 0.0006110668182373
(197) DESCRIBE `ports` 0.00067806243896484
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001990795135498
(199) DESCRIBE `ports` 0.00068020820617676
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018191337585449
(201) DESCRIBE `ports` 0.00069189071655273
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00020098686218262
(203) DESCRIBE `ports` 0.00066304206848145
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00019693374633789
(205) DESCRIBE `ports` 0.00066184997558594
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001990795135498
(207) DESCRIBE `ports` 0.00066995620727539
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(209) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55703') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0054750442504883
(210) DESCRIBE `avid_specials` 0.0007479190826416
(211) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.00091290473937988
(212) DESCRIBE `cruiselines` 0.0011329650878906
(213) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022196769714355
(214) DESCRIBE `orchid_image` 0.00076103210449219
(215) DESCRIBE `cruiselines` 0.0009300708770752
(216) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00019502639770508
(217) DESCRIBE `cruises` 0.0013101100921631
(218) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65889') 0.00022006034851074
(219) DESCRIBE `ships` 0.0012738704681396
(220) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00025105476379395
(221) DESCRIBE `ships` 0.0012650489807129
(222) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00018405914306641
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(224) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020503997802734
(225) DESCRIBE `itineraries` 0.00067687034606934
(226) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65889') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079107284545898
(227) DESCRIBE `ports` 0.00075292587280273
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021600723266602
(229) DESCRIBE `ports` 0.00074291229248047
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020194053649902
(231) DESCRIBE `ports` 0.00067305564880371
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021600723266602
(233) DESCRIBE `sailingdates` 0.00070500373840332
(234) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65889') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045084953308105
(235) DESCRIBE `ports` 0.00072193145751953
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022411346435547
(237) DESCRIBE `ports` 0.00072216987609863
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018882751464844
(239) DESCRIBE `ports` 0.00070786476135254
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00021100044250488
(241) DESCRIBE `ports` 0.00074410438537598
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00018405914306641
(243) DESCRIBE `ports` 0.00075507164001465
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020718574523926
(245) DESCRIBE `ports` 0.00068211555480957
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00020408630371094
(247) DESCRIBE `ports` 0.00079703330993652
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00022697448730469
(249) DESCRIBE `ports` 0.00068807601928711
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00020909309387207
(251) DESCRIBE `ports` 0.00069594383239746
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00019717216491699
(253) DESCRIBE `ports` 0.00067496299743652
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017905235290527
(255) DESCRIBE `ports` 0.00069999694824219
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020194053649902
(257) DESCRIBE `ports` 0.00066709518432617
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(259) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65889') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0056819915771484
(260) DESCRIBE `avid_specials` 0.00066304206848145
(261) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65889 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00091290473937988
(262) DESCRIBE `cruiselines` 0.0010108947753906
(263) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021791458129883
(264) DESCRIBE `orchid_image` 0.00075101852416992
(265) DESCRIBE `cruiselines` 0.00095486640930176
(266) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018215179443359
(267) DESCRIBE `cruises` 0.0012600421905518
(268) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.0002129077911377
(269) DESCRIBE `ships` 0.0012638568878174
(270) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00023913383483887
(271) DESCRIBE `ships` 0.001255989074707
(272) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00018596649169922
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017881393432617
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(275) DESCRIBE `itineraries` 0.0006558895111084
(276) DESCRIBE `ports` 0.00072216987609863
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021982192993164
(278) DESCRIBE `ports` 0.0006871223449707
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019979476928711
(280) DESCRIBE `ports` 0.00069093704223633
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(282) DESCRIBE `sailingdates` 0.00063395500183105
(283) DESCRIBE `ports` 0.00071215629577637
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020003318786621
(285) DESCRIBE `ports` 0.00068807601928711
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018191337585449
(287) DESCRIBE `ports` 0.00066184997558594
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0002281665802002
(289) DESCRIBE `ports` 0.00067591667175293
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00018191337585449
(291) DESCRIBE `ports` 0.00070381164550781
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0001990795135498
(293) DESCRIBE `ports` 0.00066494941711426
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018000602722168
(295) DESCRIBE `ports` 0.00066089630126953
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00019407272338867
(297) DESCRIBE `ports` 0.00069594383239746
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017595291137695
(299) DESCRIBE `ports` 0.00065803527832031
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0002288818359375
(301) DESCRIBE `ports` 0.00066399574279785
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018119812011719
(303) DESCRIBE `ports` 0.00067400932312012
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(305) DESCRIBE `ports` 0.00065708160400391
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020813941955566
(307) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50857') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0053448677062988
(308) DESCRIBE `avid_specials` 0.0006411075592041
(309) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00091195106506348
(310) DESCRIBE `cruiselines` 0.0010268688201904
(311) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022196769714355
(312) DESCRIBE `orchid_image` 0.0007779598236084
(313) DESCRIBE `cruiselines` 0.00092601776123047
(314) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00021719932556152
(315) DESCRIBE `cruises` 0.0013139247894287
(316) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00019097328186035
(317) DESCRIBE `ships` 0.0013229846954346
(318) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00023913383483887
(319) DESCRIBE `ships` 0.001276969909668
(320) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00018405914306641
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(323) DESCRIBE `itineraries` 0.00066208839416504
(324) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41776') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00036001205444336
(325) DESCRIBE `ports` 0.00074911117553711
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022792816162109
(327) DESCRIBE `ports` 0.00069189071655273
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020003318786621
(329) DESCRIBE `ports` 0.00068187713623047
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018501281738281
(331) DESCRIBE `sailingdates` 0.00060915946960449
(332) DESCRIBE `ports` 0.0007779598236084
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023603439331055
(334) DESCRIBE `ports` 0.00074195861816406
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019478797912598
(336) DESCRIBE `ports` 0.00069689750671387
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020217895507812
(338) DESCRIBE `ports` 0.00071406364440918
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00018405914306641
(340) DESCRIBE `ports` 0.00068998336791992
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00019598007202148
(342) DESCRIBE `ports` 0.00074100494384766
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017809867858887
(344) DESCRIBE `ports` 0.00079798698425293
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020098686218262
(346) DESCRIBE `ports` 0.00067687034606934
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018000602722168
(348) DESCRIBE `ports` 0.0006868839263916
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023198127746582
(350) DESCRIBE `ports` 0.00066614151000977
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001828670501709
(352) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41776') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0055229663848877
(353) DESCRIBE `avid_specials` 0.00066208839416504
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.0009009838104248
(355) DESCRIBE `cruiselines` 0.0010898113250732
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022196769714355
(357) DESCRIBE `orchid_image` 0.00082206726074219
(358) DESCRIBE `cruiselines` 0.0011460781097412
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00021004676818848
(360) DESCRIBE `cruises` 0.0014660358428955
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65890') 0.00022196769714355
(362) DESCRIBE `ships` 0.0014369487762451
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00024104118347168
(364) DESCRIBE `ships` 0.0015280246734619
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00021791458129883
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(368) DESCRIBE `itineraries` 0.00079011917114258
(369) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65890') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005040168762207
(370) DESCRIBE `ports` 0.00074195861816406
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021696090698242
(372) DESCRIBE `ports` 0.00068283081054688
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021195411682129
(374) DESCRIBE `ports` 0.00070500373840332
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(376) DESCRIBE `sailingdates` 0.00061321258544922
(377) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65890') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00032806396484375
(378) DESCRIBE `ports` 0.0010759830474854
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025701522827148
(380) DESCRIBE `ports` 0.0010712146759033
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(382) DESCRIBE `ports` 0.0011849403381348
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00023484230041504
(384) DESCRIBE `ports` 0.00076103210449219
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00019192695617676
(386) DESCRIBE `ports` 0.0011579990386963
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020980834960938
(388) DESCRIBE `ports` 0.00069713592529297
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019407272338867
(390) DESCRIBE `ports` 0.00079202651977539
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00020813941955566
(392) DESCRIBE `ports` 0.00069594383239746
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00018191337585449
(394) DESCRIBE `ports` 0.00093793869018555
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0002140998840332
(396) DESCRIBE `ports` 0.0007169246673584
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00019288063049316
(398) DESCRIBE `ports` 0.00082588195800781
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.0002140998840332
(400) DESCRIBE `ports` 0.00081920623779297
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00023007392883301
(402) DESCRIBE `ports` 0.0010321140289307
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023102760314941
(404) DESCRIBE `ports` 0.0010218620300293
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020503997802734
(406) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65890') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0056462287902832
(407) DESCRIBE `avid_specials` 0.0011730194091797
(408) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65890 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.0017280578613281
(409) DESCRIBE `cruiselines` 0.0016858577728271
(410) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00026106834411621
(411) DESCRIBE `orchid_image` 0.0010709762573242
(412) DESCRIBE `cruiselines` 0.0016298294067383
(413) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027298927307129
(414) DESCRIBE `cruises` 0.0020098686218262
(415) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65912') 0.00032520294189453
(416) DESCRIBE `ships` 0.0013971328735352
(417) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00025510787963867
(418) DESCRIBE `ships` 0.0015199184417725
(419) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00021505355834961
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(421) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017881393432617
(422) DESCRIBE `itineraries` 0.0007328987121582
(423) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65912') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042295455932617
(424) DESCRIBE `ports` 0.0014901161193848
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00033283233642578
(426) DESCRIBE `ports` 0.00095200538635254
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00026082992553711
(428) DESCRIBE `ports` 0.0010061264038086
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00026702880859375
(430) DESCRIBE `sailingdates` 0.00084614753723145
(431) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65912') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.000640869140625
(432) DESCRIBE `ports` 0.001046895980835
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00030207633972168
(434) DESCRIBE `ports` 0.0008089542388916
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00020098686218262
(436) DESCRIBE `ports` 0.00068402290344238
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00020980834960938
(438) DESCRIBE `ports` 0.00069808959960938
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00018596649169922
(440) DESCRIBE `ports` 0.00067996978759766
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020599365234375
(442) DESCRIBE `ports` 0.00068211555480957
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018596649169922
(444) DESCRIBE `ports` 0.00073504447937012
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020217895507812
(446) DESCRIBE `ports` 0.00067806243896484
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018620491027832
(448) DESCRIBE `ports` 0.00067687034606934
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020384788513184
(450) DESCRIBE `ports` 0.00080609321594238
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00020289421081543
(452) DESCRIBE `ports` 0.00080490112304688
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00030517578125
(454) DESCRIBE `ports` 0.00098514556884766
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00030303001403809
(456) DESCRIBE `ports` 0.0011978149414062
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00026702880859375
(458) DESCRIBE `ports` 0.00091314315795898
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00021219253540039
(460) DESCRIBE `ports` 0.00081300735473633
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00023698806762695
(462) DESCRIBE `ports` 0.00081110000610352
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0002140998840332
(464) DESCRIBE `ports` 0.00078415870666504
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0002288818359375
(466) DESCRIBE `ports` 0.00072693824768066
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019311904907227
(468) DESCRIBE `ports` 0.0012140274047852
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055718421936035
(470) DESCRIBE `ports` 0.0014529228210449
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037312507629395
(472) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65912') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.011279106140137
(473) DESCRIBE `avid_specials` 0.0014050006866455
(474) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65912 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00099301338195801
(475) DESCRIBE `cruiselines` 0.00099396705627441
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023484230041504
(477) DESCRIBE `orchid_image` 0.00078701972961426
(478) DESCRIBE `cruiselines` 0.00096011161804199
(479) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00020313262939453
(480) DESCRIBE `ships` 0.0014481544494629
(481) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288')) ORDER BY FIND_IN_SET(id, '4,288') 0.00036811828613281
(482) DESCRIBE `cruisetypes` 0.00057196617126465
(483) DESCRIBE `destinations` 0.00089597702026367
(484) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00033783912658691
(485) DESCRIBE `cruiselines` 0.00096297264099121
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023579597473145
(487) DESCRIBE `cruiselines` 0.00098490715026855
(488) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0002448558807373