or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Fantastic Fly/Cruise/Stay Packages with Blue Lagoon Cruises
  3. Catch up on Cruising: Latest news in bite size
  4. First Time Cruisers review of Carnival Spirit
  5. REVIEW: Norwegian Star – Greek Isles and Croatia Cruise

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 599

Total elapsed time: 0.37904071807861

# Query Time
(1) connect 0.00063300132751465
(2) DESCRIBE `cruises` 0.0017271041870117
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62665, 68109, 70033, 62661, 69259, 68315, 73186, 63133, 62653, 74759)) ORDER BY FIND_IN_SET(id, '62665,68109,70033,62661,69259,68315,73186,63133,62653,74759') 0.0013079643249512
(4) DESCRIBE `cruises` 0.0014641284942627
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00024986267089844
(6) DESCRIBE `ships` 0.0013668537139893
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00034022331237793
(8) DESCRIBE `ships` 0.001446008682251
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00022006034851074
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(12) DESCRIBE `itineraries` 0.00067710876464844
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62665') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066494941711426
(14) DESCRIBE `ports` 0.00099396705627441
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00024890899658203
(16) DESCRIBE `ports` 0.00070309638977051
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020384788513184
(18) DESCRIBE `ports` 0.00077199935913086
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0001978874206543
(20) DESCRIBE `sailingdates` 0.00064301490783691
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62665') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068497657775879
(22) DESCRIBE `ports` 0.0010309219360352
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00027704238891602
(24) DESCRIBE `ports` 0.00069999694824219
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0001978874206543
(26) DESCRIBE `ports` 0.00066995620727539
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020909309387207
(28) DESCRIBE `ports` 0.0006718635559082
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018501281738281
(30) DESCRIBE `ports` 0.00073599815368652
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(32) DESCRIBE `ports` 0.00066089630126953
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018405914306641
(34) DESCRIBE `ports` 0.0006859302520752
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021886825561523
(36) DESCRIBE `ports` 0.00072002410888672
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0001990795135498
(38) DESCRIBE `ports` 0.0006721019744873
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020790100097656
(40) DESCRIBE `ports` 0.0006711483001709
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018692016601562
(42) DESCRIBE `ports` 0.00069189071655273
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020289421081543
(44) DESCRIBE `ports` 0.00066995620727539
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001981258392334
(46) DESCRIBE `ports` 0.00067591667175293
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022315979003906
(48) DESCRIBE `ports` 0.00066804885864258
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018191337585449
(50) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62665') AND (sailingdate >= '2018-12-21') 0.0073378086090088
(51) DESCRIBE `avid_specials` 0.00079798698425293
(52) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62665 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0010719299316406
(53) DESCRIBE `cruiselines` 0.00098681449890137
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023579597473145
(55) DESCRIBE `orchid_image` 0.00078701972961426
(56) DESCRIBE `cruiselines` 0.00092506408691406
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00025296211242676
(58) DESCRIBE `cruises` 0.0018038749694824
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68109') 0.00029802322387695
(60) DESCRIBE `ships` 0.0013279914855957
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00026178359985352
(62) DESCRIBE `ships` 0.0012679100036621
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00019097328186035
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019502639770508
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(66) DESCRIBE `itineraries` 0.00067806243896484
(67) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68109') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069093704223633
(68) DESCRIBE `ports` 0.0010769367218018
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0002892017364502
(70) DESCRIBE `ports` 0.00097799301147461
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00025320053100586
(72) DESCRIBE `ports` 0.00094103813171387
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00024080276489258
(74) DESCRIBE `sailingdates` 0.0007011890411377
(75) DESCRIBE `ports` 0.0006868839263916
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021505355834961
(77) DESCRIBE `ports` 0.00068902969360352
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018596649169922
(79) DESCRIBE `ports` 0.00066304206848145
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00019598007202148
(81) DESCRIBE `ports` 0.00065898895263672
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00020813941955566
(83) DESCRIBE `ports` 0.00066494941711426
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020217895507812
(85) DESCRIBE `ports` 0.0006721019744873
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018191337585449
(87) DESCRIBE `ports` 0.00067305564880371
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(89) DESCRIBE `ports` 0.00066685676574707
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017905235290527
(91) DESCRIBE `ports` 0.00065803527832031
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019693374633789
(93) DESCRIBE `ports` 0.00068402290344238
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017499923706055
(95) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68109') AND (sailingdate >= '2018-12-21') 0.0054550170898438
(96) DESCRIBE `avid_specials` 0.0011858940124512
(97) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68109 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 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.001596212387085
(98) DESCRIBE `cruiselines` 0.0016851425170898
(99) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00039911270141602
(100) DESCRIBE `orchid_image` 0.0010499954223633
(101) DESCRIBE `cruiselines` 0.0010530948638916
(102) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00023484230041504
(103) DESCRIBE `cruises` 0.00148606300354
(104) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70033') 0.00037002563476562
(105) DESCRIBE `ships` 0.0014140605926514
(106) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00028896331787109
(107) DESCRIBE `ships` 0.001305103302002
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.0002140998840332
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017809867858887
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0001671314239502
(111) DESCRIBE `itineraries` 0.00070309638977051
(112) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058197975158691
(113) DESCRIBE `ports` 0.00091099739074707
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00027203559875488
(115) DESCRIBE `ports` 0.00075888633728027
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020384788513184
(117) DESCRIBE `ports` 0.00069594383239746
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019407272338867
(119) DESCRIBE `sailingdates` 0.00060296058654785
(120) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005800724029541
(121) DESCRIBE `ports` 0.00081992149353027
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022792816162109
(123) DESCRIBE `ports` 0.00070405006408691
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00026488304138184
(125) DESCRIBE `ports` 0.00096702575683594
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00021791458129883
(127) DESCRIBE `ports` 0.00068092346191406
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018000602722168
(129) DESCRIBE `ports` 0.00071215629577637
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0001981258392334
(131) DESCRIBE `ports` 0.0006709098815918
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017881393432617
(133) DESCRIBE `ports` 0.00066709518432617
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00020098686218262
(135) DESCRIBE `ports` 0.00068092346191406
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00018405914306641
(137) DESCRIBE `ports` 0.00067496299743652
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020003318786621
(139) DESCRIBE `ports` 0.0006718635559082
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017690658569336
(141) DESCRIBE `ports` 0.00065994262695312
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0001988410949707
(143) DESCRIBE `ports` 0.00065803527832031
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00017809867858887
(145) DESCRIBE `ports` 0.00066709518432617
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021910667419434
(147) DESCRIBE `ports` 0.00065803527832031
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018501281738281
(149) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70033') AND (sailingdate >= '2018-12-21') 0.0051398277282715
(150) DESCRIBE `avid_specials` 0.00096607208251953
(151) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70033 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.00097298622131348
(152) DESCRIBE `cruiselines` 0.0010550022125244
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025606155395508
(154) DESCRIBE `orchid_image` 0.00089693069458008
(155) DESCRIBE `cruiselines` 0.0010969638824463
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002138614654541
(157) DESCRIBE `cruises` 0.0013570785522461
(158) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00024914741516113
(159) DESCRIBE `ships` 0.0013689994812012
(160) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00035500526428223
(161) DESCRIBE `ships` 0.0013871192932129
(162) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00020980834960938
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(165) DESCRIBE `itineraries` 0.00068783760070801
(166) DESCRIBE `ports` 0.0013880729675293
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00035500526428223
(168) DESCRIBE `ports` 0.0010929107666016
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00028800964355469
(170) DESCRIBE `ports` 0.00094413757324219
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023984909057617
(172) DESCRIBE `sailingdates` 0.00084304809570312
(173) DESCRIBE `ports` 0.0014491081237793
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00026702880859375
(175) DESCRIBE `ports` 0.00096702575683594
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023889541625977
(177) DESCRIBE `ports` 0.00073814392089844
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022006034851074
(179) DESCRIBE `ports` 0.0006859302520752
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019478797912598
(181) DESCRIBE `ports` 0.00066208839416504
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021195411682129
(183) DESCRIBE `ports` 0.00068283081054688
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018906593322754
(185) DESCRIBE `ports` 0.00065898895263672
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019383430480957
(187) DESCRIBE `ports` 0.00066709518432617
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018692016601562
(189) DESCRIBE `ports` 0.00068402290344238
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019502639770508
(191) DESCRIBE `ports` 0.00065803527832031
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017905235290527
(193) DESCRIBE `ports` 0.00066304206848145
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00021219253540039
(195) DESCRIBE `ports` 0.00070786476135254
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018596649169922
(197) DESCRIBE `ports` 0.00066590309143066
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0001978874206543
(199) DESCRIBE `ports` 0.00067996978759766
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017905235290527
(201) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62661') AND (sailingdate >= '2018-12-21') 0.005302906036377
(202) DESCRIBE `avid_specials` 0.00091290473937988
(203) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0010840892791748
(204) DESCRIBE `cruiselines` 0.0010299682617188
(205) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025391578674316
(206) DESCRIBE `orchid_image` 0.00084280967712402
(207) DESCRIBE `cruiselines` 0.0009768009185791
(208) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002281665802002
(209) DESCRIBE `cruises` 0.0013082027435303
(210) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69259') 0.00022506713867188
(211) DESCRIBE `ships` 0.0012807846069336
(212) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00031304359436035
(213) DESCRIBE `ships` 0.0014228820800781
(214) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00022697448730469
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020217895507812
(217) DESCRIBE `itineraries` 0.00074911117553711
(218) DESCRIBE `ports` 0.00080204010009766
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00023698806762695
(220) DESCRIBE `ports` 0.00074601173400879
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00020313262939453
(222) DESCRIBE `ports` 0.00069904327392578
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00019717216491699
(224) DESCRIBE `sailingdates` 0.00062012672424316
(225) DESCRIBE `ports` 0.00077486038208008
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00023508071899414
(227) DESCRIBE `ports` 0.00069093704223633
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00019598007202148
(229) DESCRIBE `ports` 0.00073003768920898
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2442))) 0.00020694732666016
(231) DESCRIBE `ports` 0.00088000297546387
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2442') 0.0002138614654541
(233) DESCRIBE `ports` 0.00071096420288086
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00023913383483887
(235) DESCRIBE `ports` 0.00070405006408691
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00020480155944824
(237) DESCRIBE `ports` 0.00067591667175293
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00021100044250488
(239) DESCRIBE `ports` 0.00072407722473145
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00019192695617676
(241) DESCRIBE `ports` 0.00068211555480957
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00022411346435547
(243) DESCRIBE `ports` 0.00087285041809082
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0002140998840332
(245) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69259') AND (sailingdate >= '2018-12-21') 0.0051610469818115
(246) DESCRIBE `avid_specials` 0.00086712837219238
(247) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69259 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0010180473327637
(248) DESCRIBE `cruiselines` 0.0011148452758789
(249) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024604797363281
(250) DESCRIBE `orchid_image` 0.00085902214050293
(251) DESCRIBE `cruiselines` 0.00095987319946289
(252) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00023102760314941
(253) DESCRIBE `cruises` 0.0013699531555176
(254) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68315') 0.00026202201843262
(255) DESCRIBE `ships` 0.0013589859008789
(256) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00032401084899902
(257) DESCRIBE `ships` 0.0012931823730469
(258) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.0002129077911377
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002138614654541
(261) DESCRIBE `itineraries` 0.00068020820617676
(262) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68315') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061202049255371
(263) DESCRIBE `ports` 0.00078797340393066
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00022506713867188
(265) DESCRIBE `ports` 0.00066804885864258
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00019502639770508
(267) DESCRIBE `ports` 0.00067400932312012
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00018906593322754
(269) DESCRIBE `sailingdates` 0.00062298774719238
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68315') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00074291229248047
(271) DESCRIBE `ports` 0.00094699859619141
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00025320053100586
(273) DESCRIBE `ports` 0.00069594383239746
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00019097328186035
(275) DESCRIBE `ports` 0.00067496299743652
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00021100044250488
(277) DESCRIBE `ports` 0.00067400932312012
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00018310546875
(279) DESCRIBE `ports` 0.00069999694824219
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00020098686218262
(281) DESCRIBE `ports` 0.00066804885864258
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00017809867858887
(283) DESCRIBE `ports` 0.00066113471984863
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00021696090698242
(285) DESCRIBE `ports` 0.00067281723022461
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00017309188842773
(287) DESCRIBE `ports` 0.0006558895111084
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00019598007202148
(289) DESCRIBE `ports` 0.00065398216247559
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00017285346984863
(291) DESCRIBE `ports` 0.00068998336791992
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00020480155944824
(293) DESCRIBE `ports` 0.00065803527832031
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00017499923706055
(295) DESCRIBE `ports` 0.00066280364990234
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00020503997802734
(297) DESCRIBE `ports` 0.0006868839263916
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00017905235290527
(299) DESCRIBE `ports` 0.00066399574279785
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00020694732666016
(301) DESCRIBE `ports` 0.00068402290344238
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00018000602722168
(303) DESCRIBE `ports` 0.0006859302520752
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00020790100097656
(305) DESCRIBE `ports` 0.00066709518432617
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.0001838207244873
(307) DESCRIBE `ports` 0.00067687034606934
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00024080276489258
(309) DESCRIBE `ports` 0.00065803527832031
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00018000602722168
(311) DESCRIBE `ports` 0.00075292587280273
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00019216537475586
(313) DESCRIBE `ports` 0.00066113471984863
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017499923706055
(315) DESCRIBE `ports` 0.0006558895111084
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00019598007202148
(317) DESCRIBE `ports` 0.00065398216247559
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00018000602722168
(319) DESCRIBE `ports` 0.00067520141601562
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00020003318786621
(321) DESCRIBE `ports` 0.00065922737121582
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.0001828670501709
(323) DESCRIBE `ports` 0.00065994262695312
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00019502639770508
(325) DESCRIBE `ports` 0.00069904327392578
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00017595291137695
(327) DESCRIBE `ports` 0.00066208839416504
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00020408630371094
(329) DESCRIBE `ports` 0.00069689750671387
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00018501281738281
(331) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68315') AND (sailingdate >= '2018-12-21') 0.0052940845489502
(332) DESCRIBE `avid_specials` 0.00081300735473633
(333) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68315 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 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.00098395347595215
(334) DESCRIBE `cruiselines` 0.00097298622131348
(335) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00026488304138184
(336) DESCRIBE `orchid_image` 0.00079798698425293
(337) DESCRIBE `cruiselines` 0.00095701217651367
(338) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019502639770508
(339) DESCRIBE `cruises` 0.001331090927124
(340) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73186') 0.00021910667419434
(341) DESCRIBE `ships` 0.0012671947479248
(342) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00027203559875488
(343) DESCRIBE `ships` 0.001317024230957
(344) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00020003318786621
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018000602722168
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016880035400391
(347) DESCRIBE `itineraries` 0.00069594383239746
(348) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73186') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054121017456055
(349) DESCRIBE `ports` 0.00074005126953125
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022602081298828
(351) DESCRIBE `ports` 0.00068402290344238
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020098686218262
(353) DESCRIBE `ports` 0.00066709518432617
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001981258392334
(355) DESCRIBE `sailingdates` 0.0006868839263916
(356) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73186') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054812431335449
(357) DESCRIBE `ports` 0.00078082084655762
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025105476379395
(359) DESCRIBE `ports` 0.00070500373840332
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019288063049316
(361) DESCRIBE `ports` 0.00066804885864258
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020599365234375
(363) DESCRIBE `ports` 0.00069880485534668
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018000602722168
(365) DESCRIBE `ports` 0.00067615509033203
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020194053649902
(367) DESCRIBE `ports` 0.00066494941711426
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018000602722168
(369) DESCRIBE `ports` 0.00068402290344238
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00020384788513184
(371) DESCRIBE `ports` 0.00068998336791992
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.0001828670501709
(373) DESCRIBE `ports` 0.00066280364990234
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00019598007202148
(375) DESCRIBE `ports` 0.00070500373840332
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017881393432617
(377) DESCRIBE `ports` 0.00066399574279785
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020098686218262
(379) DESCRIBE `ports` 0.00066280364990234
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018000602722168
(381) DESCRIBE `ports` 0.00069499015808105
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002291202545166
(383) DESCRIBE `ports` 0.00080180168151855
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002601146697998
(385) DESCRIBE `ports` 0.00074982643127441
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00023889541625977
(387) DESCRIBE `ports` 0.00068092346191406
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00018787384033203
(389) DESCRIBE `ports` 0.00066518783569336
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020098686218262
(391) DESCRIBE `ports` 0.00074505805969238
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018215179443359
(393) DESCRIBE `ports` 0.00066709518432617
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020885467529297
(395) DESCRIBE `ports` 0.0007169246673584
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019216537475586
(397) DESCRIBE `ports` 0.00073814392089844
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00021886825561523
(399) DESCRIBE `ports` 0.00067400932312012
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018787384033203
(401) DESCRIBE `ports` 0.00067591667175293
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023007392883301
(403) DESCRIBE `ports` 0.00074291229248047
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020909309387207
(405) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73186') AND (sailingdate >= '2018-12-21') 0.0053730010986328
(406) DESCRIBE `avid_specials` 0.0010950565338135
(407) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73186 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.00099301338195801
(408) DESCRIBE `cruiselines` 0.0010159015655518
(409) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023198127746582
(410) DESCRIBE `orchid_image` 0.00083422660827637
(411) DESCRIBE `cruiselines` 0.0010261535644531
(412) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00022792816162109
(413) DESCRIBE `cruises` 0.0013151168823242
(414) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63133') 0.00024008750915527
(415) DESCRIBE `ships` 0.0014228820800781
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00026988983154297
(417) DESCRIBE `ships` 0.0013220310211182
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00020813941955566
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018119812011719
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(421) DESCRIBE `itineraries` 0.00071287155151367
(422) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63133') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043892860412598
(423) DESCRIBE `ports` 0.00087594985961914
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.000244140625
(425) DESCRIBE `ports` 0.00069522857666016
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00019979476928711
(427) DESCRIBE `ports` 0.00068402290344238
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00019502639770508
(429) DESCRIBE `sailingdates` 0.00061893463134766
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63133') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055599212646484
(431) DESCRIBE `ports` 0.00093197822570801
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00025582313537598
(433) DESCRIBE `ports` 0.00067496299743652
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00018906593322754
(435) DESCRIBE `ports` 0.00066900253295898
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00020599365234375
(437) DESCRIBE `ports` 0.00065398216247559
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.0002129077911377
(439) DESCRIBE `ports` 0.00065994262695312
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00019693374633789
(441) DESCRIBE `ports` 0.00066113471984863
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00017690658569336
(443) DESCRIBE `ports` 0.00066304206848145
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00024914741516113
(445) DESCRIBE `ports` 0.00078511238098145
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00018692016601562
(447) DESCRIBE `ports` 0.00074291229248047
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00020289421081543
(449) DESCRIBE `ports` 0.00070595741271973
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00017881393432617
(451) DESCRIBE `ports` 0.00071191787719727
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.0001981258392334
(453) DESCRIBE `ports` 0.00068306922912598
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00017905235290527
(455) DESCRIBE `ports` 0.00066304206848145
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00020694732666016
(457) DESCRIBE `ports` 0.00066590309143066
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00017905235290527
(459) DESCRIBE `ports` 0.00066709518432617
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00023889541625977
(461) DESCRIBE `ports` 0.00067782402038574
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00018191337585449
(463) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63133') AND (sailingdate >= '2018-12-21') 0.0053911209106445
(464) DESCRIBE `avid_specials` 0.00084400177001953
(465) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63133 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 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.00098299980163574
(466) DESCRIBE `cruiselines` 0.00098705291748047
(467) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025010108947754
(468) DESCRIBE `orchid_image` 0.00084805488586426
(469) DESCRIBE `cruiselines` 0.00093698501586914
(470) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020694732666016
(471) DESCRIBE `cruises` 0.0012810230255127
(472) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62653') 0.00021719932556152
(473) DESCRIBE `ships` 0.0014450550079346
(474) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00025796890258789
(475) DESCRIBE `ships` 0.0012550354003906
(476) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00019192695617676
(477) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(479) DESCRIBE `itineraries` 0.00094699859619141
(480) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62653') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054597854614258
(481) DESCRIBE `ports` 0.00082087516784668
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00027203559875488
(483) DESCRIBE `ports` 0.0007319450378418
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00021791458129883
(485) DESCRIBE `ports` 0.0006709098815918
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00018906593322754
(487) DESCRIBE `sailingdates` 0.0006721019744873
(488) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62653') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040888786315918
(489) DESCRIBE `ports` 0.0007319450378418
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00021195411682129
(491) DESCRIBE `ports` 0.00070500373840332
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00019097328186035
(493) DESCRIBE `ports` 0.0006711483001709
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00020003318786621
(495) DESCRIBE `ports` 0.00066018104553223
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00017595291137695
(497) DESCRIBE `ports` 0.00071287155151367
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00020599365234375
(499) DESCRIBE `ports` 0.00066304206848145
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00017595291137695
(501) DESCRIBE `ports` 0.00071620941162109
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00025105476379395
(503) DESCRIBE `ports` 0.00070905685424805
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00018000602722168
(505) DESCRIBE `ports` 0.00065779685974121
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00019502639770508
(507) DESCRIBE `ports` 0.00065493583679199
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00017499923706055
(509) DESCRIBE `ports` 0.00071215629577637
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00020003318786621
(511) DESCRIBE `ports` 0.00065898895263672
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00017595291137695
(513) DESCRIBE `ports` 0.00069618225097656
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00020194053649902
(515) DESCRIBE `ports` 0.00069999694824219
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00018095970153809
(517) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62653') AND (sailingdate >= '2018-12-21') 0.0056900978088379
(518) DESCRIBE `avid_specials` 0.00093984603881836
(519) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62653 and class = 'Cruise') OR (item_id = 738 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0010120868682861
(520) DESCRIBE `cruiselines` 0.0010900497436523
(521) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025105476379395
(522) DESCRIBE `orchid_image` 0.00076699256896973
(523) DESCRIBE `cruiselines` 0.00095391273498535
(524) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0001990795135498
(525) DESCRIBE `cruises` 0.0013959407806396
(526) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74759') 0.000244140625
(527) DESCRIBE `ships` 0.0012848377227783
(528) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.0002899169921875
(529) DESCRIBE `ships` 0.0012829303741455
(530) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.0001981258392334
(531) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(532) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001671314239502
(533) DESCRIBE `itineraries` 0.00069499015808105
(534) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74759') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055098533630371
(535) DESCRIBE `ports` 0.00071501731872559
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00022602081298828
(537) DESCRIBE `ports` 0.00066709518432617
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00019407272338867
(539) DESCRIBE `ports` 0.00066518783569336
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0001828670501709
(541) DESCRIBE `sailingdates` 0.00061702728271484
(542) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74759') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054287910461426
(543) DESCRIBE `ports` 0.00073719024658203
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00023603439331055
(545) DESCRIBE `ports` 0.00083303451538086
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0001978874206543
(547) DESCRIBE `ports` 0.00074291229248047
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00020384788513184
(549) DESCRIBE `ports` 0.00067710876464844
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00018119812011719
(551) DESCRIBE `ports` 0.00067400932312012
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00020408630371094
(553) DESCRIBE `ports` 0.0007178783416748
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00019598007202148
(555) DESCRIBE `ports` 0.00070500373840332
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 811))) 0.0001990795135498
(557) DESCRIBE `ports` 0.00066900253295898
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '811') 0.00018000602722168
(559) DESCRIBE `ports` 0.00066590309143066
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 400))) 0.00019311904907227
(561) DESCRIBE `ports` 0.00068402290344238
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '400') 0.00017380714416504
(563) DESCRIBE `ports` 0.00066184997558594
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00019693374633789
(565) DESCRIBE `ports` 0.0010101795196533
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00019693374633789
(567) DESCRIBE `ports` 0.0006721019744873
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00020480155944824
(569) DESCRIBE `ports` 0.00072193145751953
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00018501281738281
(571) DESCRIBE `ports` 0.00068187713623047
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4494))) 0.0002129077911377
(573) DESCRIBE `ports` 0.00067901611328125
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4494') 0.00020599365234375
(575) DESCRIBE `ports` 0.00081491470336914
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00031900405883789
(577) DESCRIBE `ports` 0.00094413757324219
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00020885467529297
(579) DESCRIBE `ports` 0.00066804885864258
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00020194053649902
(581) DESCRIBE `ports` 0.00073099136352539
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0001828670501709
(583) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74759') AND (sailingdate >= '2018-12-21') 0.0063071250915527
(584) DESCRIBE `avid_specials` 0.00090885162353516
(585) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74759 and class = 'Cruise') OR (item_id = 352 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0010120868682861
(586) DESCRIBE `cruiselines` 0.0010201930999756
(587) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.000244140625
(588) DESCRIBE `orchid_image` 0.00098085403442383
(589) DESCRIBE `cruiselines` 0.0012228488922119
(590) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00023388862609863
(591) DESCRIBE `ships` 0.0015511512756348
(592) SELECT `ships`.* FROM `ships` WHERE (id IN ('1599', '1359', '1067', '462', '766', '553', '1717', '407', '1415', '738', '977', '452', '352', '726', '610', '674', '1588')) ORDER BY FIND_IN_SET(id, '1599,1359,1067,462,766,553,1717,407,1415,738,977,452,352,726,610,674,1588') 0.0011439323425293
(593) DESCRIBE `cruisetypes` 0.00093317031860352
(594) DESCRIBE `destinations` 0.00099897384643555
(595) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '52', '40', '38', '28', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,52,40,38,28,35') 0.00057005882263184
(596) DESCRIBE `cruiselines` 0.0010280609130859
(597) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024914741516113
(598) DESCRIBE `cruiselines` 0.0010218620300293
(599) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023818016052246