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

Total elapsed time: 0.40606880187988

# Query Time
(1) connect 0.0006859302520752
(2) DESCRIBE `cruises` 0.0025110244750977
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70654, 66525, 70581, 66527, 54648, 59347, 66474, 66503, 66516, 68050)) ORDER BY FIND_IN_SET(id, '70654,66525,70581,66527,54648,59347,66474,66503,66516,68050') 0.0015380382537842
(4) DESCRIBE `cruises` 0.002169132232666
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70654') 0.00024008750915527
(6) DESCRIBE `ships` 0.0013771057128906
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00025486946105957
(8) DESCRIBE `ships` 0.0012509822845459
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00018191337585449
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019478797912598
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(12) DESCRIBE `itineraries` 0.00066709518432617
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70654') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010449886322021
(14) DESCRIBE `ports` 0.00077509880065918
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022792816162109
(16) DESCRIBE `ports` 0.00067305564880371
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020503997802734
(18) DESCRIBE `ports` 0.00070405006408691
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018501281738281
(20) DESCRIBE `sailingdates` 0.000762939453125
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70654') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050997734069824
(22) DESCRIBE `ports` 0.00069999694824219
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020694732666016
(24) DESCRIBE `ports` 0.00082087516784668
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001990795135498
(26) DESCRIBE `ports` 0.00068092346191406
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00021100044250488
(28) DESCRIBE `ports` 0.00075984001159668
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018501281738281
(30) DESCRIBE `ports` 0.00072193145751953
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020599365234375
(32) DESCRIBE `ports` 0.00066399574279785
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018095970153809
(34) DESCRIBE `ports` 0.00074505805969238
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020003318786621
(36) DESCRIBE `ports` 0.00067782402038574
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018191337585449
(38) DESCRIBE `ports` 0.00066804885864258
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020003318786621
(40) DESCRIBE `ports` 0.00071883201599121
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018191337585449
(42) DESCRIBE `ports` 0.00069904327392578
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020003318786621
(44) DESCRIBE `ports` 0.00069403648376465
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018095970153809
(46) DESCRIBE `ports` 0.00069189071655273
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00020599365234375
(48) DESCRIBE `ports` 0.00071001052856445
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.0001828670501709
(50) DESCRIBE `ports` 0.00070309638977051
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026893615722656
(52) DESCRIBE `ports` 0.00069904327392578
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0001828670501709
(54) DESCRIBE `ports` 0.00066208839416504
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020003318786621
(56) DESCRIBE `ports` 0.00066804885864258
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018119812011719
(58) DESCRIBE `ports` 0.00069093704223633
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0001990795135498
(60) DESCRIBE `ports` 0.00066304206848145
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018191337585449
(62) DESCRIBE `ports` 0.00077414512634277
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(64) DESCRIBE `ports` 0.00077986717224121
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019097328186035
(66) DESCRIBE `ports` 0.00080108642578125
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00028681755065918
(68) DESCRIBE `ports` 0.00098085403442383
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00019407272338867
(70) DESCRIBE `ports` 0.00068092346191406
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020885467529297
(72) DESCRIBE `ports` 0.00070714950561523
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018501281738281
(74) DESCRIBE `ports` 0.00069999694824219
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020909309387207
(76) DESCRIBE `ports` 0.0006721019744873
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00020909309387207
(78) DESCRIBE `ports` 0.00075101852416992
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00020813941955566
(80) DESCRIBE `ports` 0.00065779685974121
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00018501281738281
(82) DESCRIBE `ports` 0.00065302848815918
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020909309387207
(84) DESCRIBE `ports` 0.00093889236450195
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0002601146697998
(86) DESCRIBE `ports` 0.00072407722473145
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021219253540039
(88) DESCRIBE `ports` 0.00071501731872559
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018000602722168
(90) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70654') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.010383129119873
(91) DESCRIBE `avid_specials` 0.00089311599731445
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70654 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.0010240077972412
(93) DESCRIBE `cruiselines` 0.001046895980835
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022697448730469
(95) DESCRIBE `orchid_image` 0.0007469654083252
(96) DESCRIBE `cruiselines` 0.00092101097106934
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020122528076172
(98) DESCRIBE `cruises` 0.0013010501861572
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66525') 0.00029206275939941
(100) DESCRIBE `ships` 0.001446008682251
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.0002448558807373
(102) DESCRIBE `ships` 0.0012609958648682
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00019001960754395
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(106) DESCRIBE `itineraries` 0.00070500373840332
(107) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66525') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057291984558105
(108) DESCRIBE `ports` 0.00074505805969238
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022315979003906
(110) DESCRIBE `ports` 0.00066995620727539
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019478797912598
(112) DESCRIBE `ports` 0.00066804885864258
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018000602722168
(114) DESCRIBE `sailingdates` 0.00061798095703125
(115) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66525') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042986869812012
(116) DESCRIBE `ports` 0.00069904327392578
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022292137145996
(118) DESCRIBE `ports` 0.00068402290344238
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017595291137695
(120) DESCRIBE `ports` 0.00068807601928711
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019598007202148
(122) DESCRIBE `ports` 0.00066685676574707
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017404556274414
(124) DESCRIBE `ports` 0.00065422058105469
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019502639770508
(126) DESCRIBE `ports` 0.00066089630126953
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017404556274414
(128) DESCRIBE `ports` 0.00066804885864258
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020503997802734
(130) DESCRIBE `ports` 0.00066804885864258
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00017499923706055
(132) DESCRIBE `ports` 0.00067710876464844
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0001988410949707
(134) DESCRIBE `ports` 0.00068497657775879
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018000602722168
(136) DESCRIBE `ports` 0.00071811676025391
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0001988410949707
(138) DESCRIBE `ports` 0.00068998336791992
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023388862609863
(140) DESCRIBE `ports` 0.00072598457336426
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00030994415283203
(142) DESCRIBE `ports` 0.00069999694824219
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00018501281738281
(144) DESCRIBE `ports` 0.00066900253295898
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020098686218262
(146) DESCRIBE `ports` 0.00067806243896484
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018119812011719
(148) DESCRIBE `ports` 0.00066614151000977
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020503997802734
(150) DESCRIBE `ports` 0.00066494941711426
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00019502639770508
(152) DESCRIBE `ports` 0.00066709518432617
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0001978874206543
(154) DESCRIBE `ports` 0.00068998336791992
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00020098686218262
(156) DESCRIBE `ports` 0.00072908401489258
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020790100097656
(158) DESCRIBE `ports` 0.00073099136352539
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018310546875
(160) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66525') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.005591869354248
(161) DESCRIBE `avid_specials` 0.00066018104553223
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66525 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.00090694427490234
(163) DESCRIBE `cruiselines` 0.001011848449707
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021910667419434
(165) DESCRIBE `orchid_image` 0.00074100494384766
(166) DESCRIBE `cruiselines` 0.0011398792266846
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00021004676818848
(168) DESCRIBE `cruises` 0.0013928413391113
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70581') 0.00022983551025391
(170) DESCRIBE `ships` 0.0012922286987305
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00026798248291016
(172) DESCRIBE `ships` 0.0012519359588623
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00018501281738281
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020718574523926
(176) DESCRIBE `itineraries` 0.00069189071655273
(177) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70581') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005180835723877
(178) DESCRIBE `ports` 0.00083112716674805
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023984909057617
(180) DESCRIBE `ports` 0.00071978569030762
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020408630371094
(182) DESCRIBE `ports` 0.00067591667175293
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018501281738281
(184) DESCRIBE `sailingdates` 0.00060701370239258
(185) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70581') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043916702270508
(186) DESCRIBE `ports` 0.00069499015808105
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020694732666016
(188) DESCRIBE `ports` 0.00076198577880859
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001828670501709
(190) DESCRIBE `ports` 0.00069189071655273
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00020790100097656
(192) DESCRIBE `ports` 0.00068902969360352
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00018000602722168
(194) DESCRIBE `ports` 0.00066494941711426
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00020217895507812
(196) DESCRIBE `ports` 0.00066590309143066
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018000602722168
(198) DESCRIBE `ports` 0.00066614151000977
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00019478797912598
(200) DESCRIBE `ports` 0.00066900253295898
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00018906593322754
(202) DESCRIBE `ports` 0.00066423416137695
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021195411682129
(204) DESCRIBE `ports` 0.00066614151000977
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018000602722168
(206) DESCRIBE `ports` 0.00066399574279785
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0002291202545166
(208) DESCRIBE `ports` 0.00066590309143066
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018000602722168
(210) DESCRIBE `ports` 0.00066494941711426
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00020718574523926
(212) DESCRIBE `ports` 0.00066709518432617
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00017905235290527
(214) DESCRIBE `ports` 0.00073385238647461
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00020003318786621
(216) DESCRIBE `ports` 0.00066900253295898
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00018787384033203
(218) DESCRIBE `ports` 0.00069403648376465
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020122528076172
(220) DESCRIBE `ports` 0.00066494941711426
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018095970153809
(222) DESCRIBE `ports` 0.00066900253295898
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019502639770508
(224) DESCRIBE `ports` 0.00067901611328125
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017786026000977
(226) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70581') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0054931640625
(227) DESCRIBE `avid_specials` 0.0007169246673584
(228) 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.00093197822570801
(229) DESCRIBE `cruiselines` 0.0010900497436523
(230) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024795532226562
(231) DESCRIBE `orchid_image` 0.00078201293945312
(232) DESCRIBE `cruiselines` 0.00091409683227539
(233) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018501281738281
(234) DESCRIBE `cruises` 0.0012669563293457
(235) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66527') 0.0002140998840332
(236) DESCRIBE `ships` 0.0012669563293457
(237) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00024700164794922
(238) DESCRIBE `ships` 0.0012569427490234
(239) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00018692016601562
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021910667419434
(242) DESCRIBE `itineraries` 0.00066995620727539
(243) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66527') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00033998489379883
(244) DESCRIBE `ports` 0.00069999694824219
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00023102760314941
(246) DESCRIBE `ports` 0.00066900253295898
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00019693374633789
(248) DESCRIBE `ports` 0.00066709518432617
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00018215179443359
(250) DESCRIBE `sailingdates` 0.00065898895263672
(251) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66527') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069117546081543
(252) DESCRIBE `ports` 0.0011630058288574
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00027799606323242
(254) DESCRIBE `ports` 0.00068807601928711
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00019407272338867
(256) DESCRIBE `ports` 0.00070905685424805
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020408630371094
(258) DESCRIBE `ports` 0.00068187713623047
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00022578239440918
(260) DESCRIBE `ports` 0.00071597099304199
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00021195411682129
(262) DESCRIBE `ports` 0.00072908401489258
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017714500427246
(264) DESCRIBE `ports` 0.00072717666625977
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0001981258392334
(266) DESCRIBE `ports` 0.00084781646728516
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018501281738281
(268) DESCRIBE `ports` 0.00067305564880371
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.0001990795135498
(270) DESCRIBE `ports` 0.00067019462585449
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00017905235290527
(272) DESCRIBE `ports` 0.00069904327392578
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00019717216491699
(274) DESCRIBE `ports` 0.00066900253295898
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00017809867858887
(276) DESCRIBE `ports` 0.00066804885864258
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00019288063049316
(278) DESCRIBE `ports` 0.00066614151000977
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00017499923706055
(280) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66527') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0056800842285156
(281) DESCRIBE `avid_specials` 0.00093197822570801
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66527 and class = 'Cruise') OR (item_id = 98 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.0010688304901123
(283) DESCRIBE `cruiselines` 0.0010349750518799
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023102760314941
(285) DESCRIBE `orchid_image` 0.00075984001159668
(286) DESCRIBE `cruiselines` 0.00094413757324219
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0002140998840332
(288) DESCRIBE `cruises` 0.0022211074829102
(289) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54648') 0.00035786628723145
(290) DESCRIBE `ships` 0.0023620128631592
(291) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00037598609924316
(292) DESCRIBE `ships` 0.001384973526001
(293) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00020599365234375
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(296) DESCRIBE `itineraries` 0.00072598457336426
(297) DESCRIBE `ports` 0.00076198577880859
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00023984909057617
(299) DESCRIBE `ports` 0.00069713592529297
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021195411682129
(301) DESCRIBE `ports` 0.00067305564880371
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019001960754395
(303) DESCRIBE `sailingdates` 0.00060391426086426
(304) DESCRIBE `ports` 0.00071620941162109
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020909309387207
(306) DESCRIBE `ports` 0.00067400932312012
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018596649169922
(308) DESCRIBE `ports` 0.00073599815368652
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020408630371094
(310) DESCRIBE `ports` 0.0006711483001709
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017905235290527
(312) DESCRIBE `ports` 0.00068807601928711
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019407272338867
(314) DESCRIBE `ports` 0.00066900253295898
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017690658569336
(316) DESCRIBE `ports` 0.00066590309143066
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019288063049316
(318) DESCRIBE `ports` 0.00066995620727539
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017595291137695
(320) DESCRIBE `ports` 0.00066399574279785
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020718574523926
(322) DESCRIBE `ports` 0.00066089630126953
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00017905235290527
(324) DESCRIBE `ports` 0.00066304206848145
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00019192695617676
(326) DESCRIBE `ports` 0.00066304206848145
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00020813941955566
(328) DESCRIBE `ports` 0.00069212913513184
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020003318786621
(330) DESCRIBE `ports` 0.00066590309143066
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00017499923706055
(332) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54648') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0054681301116943
(333) DESCRIBE `avid_specials` 0.00067591667175293
(334) 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.00091099739074707
(335) DESCRIBE `cruiselines` 0.00098800659179688
(336) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022101402282715
(337) DESCRIBE `orchid_image` 0.0008080005645752
(338) DESCRIBE `cruiselines` 0.00092387199401855
(339) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020289421081543
(340) DESCRIBE `cruises` 0.0012509822845459
(341) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59347') 0.00020599365234375
(342) DESCRIBE `ships` 0.0012710094451904
(343) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00024294853210449
(344) DESCRIBE `ships` 0.0012490749359131
(345) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.0001990795135498
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(348) DESCRIBE `itineraries` 0.00066995620727539
(349) DESCRIBE `ports` 0.00069403648376465
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00021004676818848
(351) DESCRIBE `ports` 0.00067520141601562
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020098686218262
(353) DESCRIBE `ports` 0.00067305564880371
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018191337585449
(355) DESCRIBE `sailingdates` 0.00063896179199219
(356) DESCRIBE `ports` 0.00073599815368652
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020599365234375
(358) DESCRIBE `ports` 0.0006711483001709
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00019097328186035
(360) DESCRIBE `ports` 0.00066804885864258
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019502639770508
(362) DESCRIBE `ports` 0.00067019462585449
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018596649169922
(364) DESCRIBE `ports` 0.0006859302520752
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019216537475586
(366) DESCRIBE `ports` 0.00067496299743652
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018596649169922
(368) DESCRIBE `ports` 0.00085115432739258
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00023198127746582
(370) DESCRIBE `ports` 0.00078010559082031
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00039505958557129
(372) DESCRIBE `ports` 0.00087404251098633
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00021195411682129
(374) DESCRIBE `ports` 0.00070095062255859
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018787384033203
(376) DESCRIBE `ports` 0.00067901611328125
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00019693374633789
(378) DESCRIBE `ports` 0.00067710876464844
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00017595291137695
(380) DESCRIBE `ports` 0.00071001052856445
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00019598007202148
(382) DESCRIBE `ports` 0.00068497657775879
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00019407272338867
(384) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '59347') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0056018829345703
(385) DESCRIBE `avid_specials` 0.00076603889465332
(386) 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.00093388557434082
(387) DESCRIBE `cruiselines` 0.0010230541229248
(388) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023007392883301
(389) DESCRIBE `orchid_image` 0.00080990791320801
(390) DESCRIBE `cruiselines` 0.0010178089141846
(391) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020599365234375
(392) DESCRIBE `cruises` 0.001431941986084
(393) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66474') 0.0002140998840332
(394) DESCRIBE `ships` 0.0012960433959961
(395) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00026202201843262
(396) DESCRIBE `ships` 0.0013270378112793
(397) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00018811225891113
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019311904907227
(399) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(400) DESCRIBE `itineraries` 0.00076603889465332
(401) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66474') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0008080005645752
(402) DESCRIBE `ports` 0.00075411796569824
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0002131462097168
(404) DESCRIBE `ports` 0.00067591667175293
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020122528076172
(406) DESCRIBE `ports` 0.00069713592529297
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00017809867858887
(408) DESCRIBE `sailingdates` 0.00060796737670898
(409) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66474') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003359317779541
(410) DESCRIBE `ports` 0.00071120262145996
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0001981258392334
(412) DESCRIBE `ports` 0.00067615509033203
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00017714500427246
(414) DESCRIBE `ports` 0.00067305564880371
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00019502639770508
(416) DESCRIBE `ports` 0.00066590309143066
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00017499923706055
(418) DESCRIBE `ports` 0.00066590309143066
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020194053649902
(420) DESCRIBE `ports` 0.0006859302520752
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00022482872009277
(422) DESCRIBE `ports` 0.00069284439086914
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00019717216491699
(424) DESCRIBE `ports` 0.00067305564880371
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018191337585449
(426) DESCRIBE `ports` 0.00068998336791992
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 646))) 0.0002129077911377
(428) DESCRIBE `ports` 0.00068020820617676
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '646') 0.00017905235290527
(430) DESCRIBE `ports` 0.00068306922912598
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0002281665802002
(432) DESCRIBE `ports` 0.00067305564880371
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018191337585449
(434) DESCRIBE `ports` 0.00066614151000977
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00019192695617676
(436) DESCRIBE `ports` 0.00065898895263672
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018405914306641
(438) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66474') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0056190490722656
(439) DESCRIBE `avid_specials` 0.00076389312744141
(440) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66474 and class = 'Cruise') OR (item_id = 406 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.00096797943115234
(441) DESCRIBE `cruiselines` 0.0010168552398682
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023603439331055
(443) DESCRIBE `orchid_image` 0.00078701972961426
(444) DESCRIBE `cruiselines` 0.00092005729675293
(445) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019288063049316
(446) DESCRIBE `cruises` 0.0012638568878174
(447) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66503') 0.00023794174194336
(448) DESCRIBE `ships` 0.0012638568878174
(449) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00025200843811035
(450) DESCRIBE `ships` 0.0012359619140625
(451) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00018501281738281
(452) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020503997802734
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(454) DESCRIBE `itineraries` 0.00069117546081543
(455) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66503') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034403800964355
(456) DESCRIBE `ports` 0.00072598457336426
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020790100097656
(458) DESCRIBE `ports` 0.00067400932312012
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020003318786621
(460) DESCRIBE `ports` 0.00069522857666016
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00017809867858887
(462) DESCRIBE `sailingdates` 0.00061702728271484
(463) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66503') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039792060852051
(464) DESCRIBE `ports` 0.00084114074707031
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00023794174194336
(466) DESCRIBE `ports` 0.00071597099304199
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00021719932556152
(468) DESCRIBE `ports` 0.00069308280944824
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00020885467529297
(470) DESCRIBE `ports` 0.00068497657775879
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00019502639770508
(472) DESCRIBE `ports` 0.00068187713623047
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00022101402282715
(474) DESCRIBE `ports` 0.00070309638977051
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00020003318786621
(476) DESCRIBE `ports` 0.00068187713623047
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019502639770508
(478) DESCRIBE `ports` 0.00068092346191406
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018715858459473
(480) DESCRIBE `ports` 0.00066804885864258
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019693374633789
(482) DESCRIBE `ports` 0.0007479190826416
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018000602722168
(484) DESCRIBE `ports` 0.00070619583129883
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020503997802734
(486) DESCRIBE `ports` 0.0006718635559082
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017905235290527
(488) DESCRIBE `ports` 0.00087499618530273
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00023794174194336
(490) DESCRIBE `ports` 0.00067591667175293
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019288063049316
(492) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66503') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0055840015411377
(493) DESCRIBE `avid_specials` 0.00082898139953613
(494) 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.00095605850219727
(495) DESCRIBE `cruiselines` 0.0010089874267578
(496) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023007392883301
(497) DESCRIBE `orchid_image` 0.00074481964111328
(498) DESCRIBE `cruiselines` 0.00094509124755859
(499) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019598007202148
(500) DESCRIBE `cruises` 0.0016078948974609
(501) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66516') 0.00025701522827148
(502) DESCRIBE `ships` 0.0012860298156738
(503) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00026202201843262
(504) DESCRIBE `ships` 0.0012538433074951
(505) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00017809867858887
(506) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(508) DESCRIBE `itineraries` 0.00069308280944824
(509) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66516') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00031709671020508
(510) DESCRIBE `ports` 0.00072097778320312
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020694732666016
(512) DESCRIBE `ports` 0.00067400932312012
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019693374633789
(514) DESCRIBE `ports` 0.00067496299743652
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001981258392334
(516) DESCRIBE `sailingdates` 0.00059986114501953
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66516') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038313865661621
(518) DESCRIBE `ports` 0.00070905685424805
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019502639770508
(520) DESCRIBE `ports` 0.00066900253295898
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017595291137695
(522) DESCRIBE `ports` 0.00066208839416504
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019979476928711
(524) DESCRIBE `ports` 0.00069904327392578
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017595291137695
(526) DESCRIBE `ports` 0.00066304206848145
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019192695617676
(528) DESCRIBE `ports` 0.00065898895263672
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017499923706055
(530) DESCRIBE `ports` 0.00077199935913086
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00043582916259766
(532) DESCRIBE `ports` 0.001215934753418
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00026297569274902
(534) DESCRIBE `ports` 0.0009760856628418
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00027203559875488
(536) DESCRIBE `ports` 0.0010108947753906
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00025200843811035
(538) DESCRIBE `ports` 0.0010027885437012
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025701522827148
(540) DESCRIBE `ports` 0.00099587440490723
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022602081298828
(542) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66516') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0063979625701904
(543) DESCRIBE `avid_specials` 0.00075292587280273
(544) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66516 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.00092887878417969
(545) DESCRIBE `cruiselines` 0.0010020732879639
(546) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00027799606323242
(547) DESCRIBE `orchid_image` 0.00077390670776367
(548) DESCRIBE `cruiselines` 0.00095701217651367
(549) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018596649169922
(550) DESCRIBE `cruises` 0.0016369819641113
(551) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68050') 0.00025296211242676
(552) DESCRIBE `ships` 0.0013110637664795
(553) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00026512145996094
(554) DESCRIBE `ships` 0.0012791156768799
(555) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00019288063049316
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(558) DESCRIBE `itineraries` 0.00070095062255859
(559) DESCRIBE `ports` 0.00069904327392578
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022602081298828
(561) DESCRIBE `ports` 0.00067400932312012
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019598007202148
(563) DESCRIBE `ports` 0.00073003768920898
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024080276489258
(565) DESCRIBE `sailingdates` 0.0007469654083252
(566) DESCRIBE `ports` 0.0010597705841064
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003359317779541
(568) DESCRIBE `ports` 0.0010719299316406
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002448558807373
(570) DESCRIBE `ports` 0.00070905685424805
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00021100044250488
(572) DESCRIBE `ports` 0.00067782402038574
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00019097328186035
(574) DESCRIBE `ports` 0.0006709098815918
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00020003318786621
(576) DESCRIBE `ports` 0.00067782402038574
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018978118896484
(578) DESCRIBE `ports` 0.0006721019744873
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00019097328186035
(580) DESCRIBE `ports` 0.00067782402038574
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00017309188842773
(582) DESCRIBE `ports` 0.00066494941711426
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019502639770508
(584) DESCRIBE `ports` 0.00073099136352539
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018095970153809
(586) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68050') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0055210590362549
(587) DESCRIBE `avid_specials` 0.00077104568481445
(588) 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.00093388557434082
(589) DESCRIBE `cruiselines` 0.0009920597076416
(590) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022602081298828
(591) DESCRIBE `orchid_image` 0.00075101852416992
(592) DESCRIBE `cruiselines` 0.0010218620300293
(593) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018501281738281
(594) DESCRIBE `ships` 0.0013728141784668
(595) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '542', '434', '1135', '678', '1021', '253', '290', '348', '580', '451', '291', '98', '406', '341', '105', '1409')) ORDER BY FIND_IN_SET(id, '349,542,434,1135,678,1021,253,290,348,580,451,291,98,406,341,105,1409') 0.00074100494384766
(596) DESCRIBE `cruisetypes` 0.00059294700622559
(597) 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 = '23') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.027350902557373
(598) DESCRIBE `destinations` 0.0012240409851074
(599) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '35', '22', '26', '12', '40', '21', '34', '43', '48', '11', '8', '38', '25', '53', '29', '49', '28')) ORDER BY FIND_IN_SET(id, '2,35,22,26,12,40,21,34,43,48,11,8,38,25,53,29,49,28') 0.0009610652923584
(600) DESCRIBE `cruiselines` 0.0014619827270508
(601) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00030708312988281
(602) DESCRIBE `cruiselines` 0.0010280609130859
(603) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023698806762695