or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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

Total elapsed time: 0.38989400863647

# Query Time
(1) connect 0.001039981842041
(2) DESCRIBE `cruises` 0.0023078918457031
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (64382, 57769, 44597, 63046, 63037, 63250, 63249, 63251, 62546, 57765)) ORDER BY FIND_IN_SET(id, '64382,57769,44597,63046,63037,63250,63249,63251,62546,57765') 0.0012891292572021
(4) DESCRIBE `cruises` 0.0016460418701172
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64382') 0.00026106834411621
(6) DESCRIBE `ships` 0.0013430118560791
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.0002751350402832
(8) DESCRIBE `ships` 0.0013289451599121
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00023984909057617
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(12) DESCRIBE `itineraries` 0.00068402290344238
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64382') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0016698837280273
(14) DESCRIBE `ports` 0.0012741088867188
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00032615661621094
(16) DESCRIBE `ports` 0.0010290145874023
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00027179718017578
(18) DESCRIBE `ports` 0.0010190010070801
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002591609954834
(20) DESCRIBE `sailingdates` 0.00089311599731445
(21) DESCRIBE `ports` 0.0010530948638916
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023913383483887
(23) DESCRIBE `ports` 0.00079107284545898
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020790100097656
(25) DESCRIBE `ports` 0.00073695182800293
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00021100044250488
(27) DESCRIBE `ports` 0.00067901611328125
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00019288063049316
(29) DESCRIBE `ports` 0.00067901611328125
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00020503997802734
(31) DESCRIBE `ports` 0.00067806243896484
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00022101402282715
(33) DESCRIBE `ports` 0.0006711483001709
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.0002129077911377
(35) DESCRIBE `ports` 0.00068402290344238
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00018906593322754
(37) DESCRIBE `ports` 0.0006861686706543
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020885467529297
(39) DESCRIBE `ports` 0.00068211555480957
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018787384033203
(41) DESCRIBE `ports` 0.00070405006408691
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 444))) 0.00020313262939453
(43) DESCRIBE `ports` 0.00066089630126953
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '444') 0.00018310546875
(45) DESCRIBE `ports` 0.00067996978759766
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.0001990795135498
(47) DESCRIBE `ports` 0.00069999694824219
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00018095970153809
(49) DESCRIBE `ports` 0.00066995620727539
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00021791458129883
(51) DESCRIBE `ports` 0.00069499015808105
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018000602722168
(53) DESCRIBE `ports` 0.00066399574279785
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00020194053649902
(55) DESCRIBE `ports` 0.00066709518432617
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00018692016601562
(57) DESCRIBE `ports` 0.00066399574279785
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00021195411682129
(59) DESCRIBE `ports` 0.00071501731872559
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00018692016601562
(61) DESCRIBE `ports` 0.00078296661376953
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00021100044250488
(63) DESCRIBE `ports` 0.00072813034057617
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00018596649169922
(65) DESCRIBE `ports` 0.00071001052856445
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021100044250488
(67) DESCRIBE `ports` 0.00066089630126953
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0001990795135498
(69) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64382') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0091891288757324
(70) DESCRIBE `avid_specials` 0.00088405609130859
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64382 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010578632354736
(72) DESCRIBE `cruiselines` 0.0010440349578857
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00026106834411621
(74) DESCRIBE `orchid_image` 0.00084996223449707
(75) DESCRIBE `cruiselines` 0.00097393989562988
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0002129077911377
(77) DESCRIBE `cruises` 0.0012969970703125
(78) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57769') 0.00022411346435547
(79) DESCRIBE `ships` 0.0013201236724854
(80) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00048398971557617
(81) DESCRIBE `ships` 0.0015280246734619
(82) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.0001978874206543
(83) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(85) DESCRIBE `itineraries` 0.00071310997009277
(86) DESCRIBE `ports` 0.0008089542388916
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00026702880859375
(88) DESCRIBE `ports` 0.00068283081054688
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00019407272338867
(90) DESCRIBE `ports` 0.00067520141601562
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00020289421081543
(92) DESCRIBE `sailingdates` 0.00059413909912109
(93) DESCRIBE `ports` 0.00068402290344238
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00020289421081543
(95) DESCRIBE `ports` 0.00074100494384766
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033688545227051
(97) DESCRIBE `ports` 0.00084304809570312
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3064))) 0.00021910667419434
(99) DESCRIBE `ports` 0.00069499015808105
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3064') 0.00021100044250488
(101) DESCRIBE `ports` 0.00066304206848145
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00020909309387207
(103) DESCRIBE `ports` 0.00066590309143066
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00017690658569336
(105) DESCRIBE `ports` 0.00065994262695312
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00020694732666016
(107) DESCRIBE `ports` 0.00066018104553223
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00017404556274414
(109) DESCRIBE `ports` 0.00065994262695312
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0001988410949707
(111) DESCRIBE `ports` 0.00074005126953125
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00017595291137695
(113) DESCRIBE `ports` 0.00067782402038574
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2472))) 0.00021004676818848
(115) DESCRIBE `ports` 0.0006568431854248
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2472') 0.00017380714416504
(117) DESCRIBE `ports` 0.00068378448486328
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00019502639770508
(119) DESCRIBE `ports` 0.0006561279296875
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018000602722168
(121) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57769') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0055270195007324
(122) DESCRIBE `avid_specials` 0.00089192390441895
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57769 and class = 'Cruise') OR (item_id = 253 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015349388122559
(124) DESCRIBE `cruiselines` 0.0014629364013672
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00027322769165039
(126) DESCRIBE `orchid_image` 0.00078511238098145
(127) DESCRIBE `cruiselines` 0.00092601776123047
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020098686218262
(129) DESCRIBE `cruises` 0.0014841556549072
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44597') 0.00022983551025391
(131) DESCRIBE `ships` 0.0012719631195068
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00026798248291016
(133) DESCRIBE `ships` 0.0016560554504395
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00023698806762695
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022792816162109
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019717216491699
(137) DESCRIBE `itineraries` 0.00081682205200195
(138) DESCRIBE `ports` 0.00073814392089844
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00030303001403809
(140) DESCRIBE `ports` 0.00090694427490234
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024318695068359
(142) DESCRIBE `ports` 0.00073814392089844
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019288063049316
(144) DESCRIBE `sailingdates` 0.00063300132751465
(145) DESCRIBE `ports` 0.00070500373840332
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002140998840332
(147) DESCRIBE `ports` 0.00073790550231934
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002131462097168
(149) DESCRIBE `ports` 0.00067400932312012
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020289421081543
(151) DESCRIBE `ports` 0.0007331371307373
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00022077560424805
(153) DESCRIBE `ports` 0.00088596343994141
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00025701522827148
(155) DESCRIBE `ports` 0.00088214874267578
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00022196769714355
(157) DESCRIBE `ports` 0.00091195106506348
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00028014183044434
(159) DESCRIBE `ports` 0.00069999694824219
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00023794174194336
(161) DESCRIBE `ports` 0.0010769367218018
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029778480529785
(163) DESCRIBE `ports` 0.0010290145874023
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00025486946105957
(165) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '44597') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0089738368988037
(166) DESCRIBE `avid_specials` 0.0010919570922852
(167) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44597 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018138885498047
(168) DESCRIBE `cruiselines` 0.0015110969543457
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00033211708068848
(170) DESCRIBE `orchid_image` 0.0011849403381348
(171) DESCRIBE `cruiselines` 0.0013320446014404
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00026512145996094
(173) DESCRIBE `cruises` 0.0018599033355713
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63046') 0.00027298927307129
(175) DESCRIBE `ships` 0.0018310546875
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00033903121948242
(177) DESCRIBE `ships` 0.0019068717956543
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00028395652770996
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022411346435547
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021505355834961
(181) DESCRIBE `itineraries` 0.00096607208251953
(182) DESCRIBE `ports` 0.00098013877868652
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00029206275939941
(184) DESCRIBE `ports` 0.00094199180603027
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.000244140625
(186) DESCRIBE `ports` 0.00075292587280273
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00019598007202148
(188) DESCRIBE `sailingdates` 0.00059890747070312
(189) DESCRIBE `ports` 0.0008389949798584
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00023603439331055
(191) DESCRIBE `ports` 0.00069904327392578
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018882751464844
(193) DESCRIBE `ports` 0.00066304206848145
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.0001978874206543
(195) DESCRIBE `ports` 0.00078010559082031
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00017905235290527
(197) DESCRIBE `ports` 0.00073099136352539
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00020289421081543
(199) DESCRIBE `ports` 0.00074195861816406
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00019693374633789
(201) DESCRIBE `ports` 0.00071978569030762
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00021004676818848
(203) DESCRIBE `ports` 0.00081515312194824
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00017213821411133
(205) DESCRIBE `ports` 0.0006568431854248
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020003318786621
(207) DESCRIBE `ports` 0.00066804885864258
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00017404556274414
(209) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63046') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.005389928817749
(210) DESCRIBE `avid_specials` 0.00084185600280762
(211) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63046 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 53 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.0012249946594238
(212) DESCRIBE `cruiselines` 0.0013220310211182
(213) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00029397010803223
(214) DESCRIBE `orchid_image` 0.0010499954223633
(215) DESCRIBE `cruiselines` 0.0017299652099609
(216) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00030207633972168
(217) DESCRIBE `cruises` 0.0017910003662109
(218) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63037') 0.00031900405883789
(219) DESCRIBE `ships` 0.0018680095672607
(220) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00035715103149414
(221) DESCRIBE `ships` 0.0018510818481445
(222) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.0002598762512207
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023698806762695
(224) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(225) DESCRIBE `itineraries` 0.00095820426940918
(226) DESCRIBE `ports` 0.0011370182037354
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00032401084899902
(228) DESCRIBE `ports` 0.0008690357208252
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00025081634521484
(230) DESCRIBE `ports` 0.00095415115356445
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00024604797363281
(232) DESCRIBE `sailingdates` 0.00066399574279785
(233) DESCRIBE `ports` 0.00072813034057617
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00023198127746582
(235) DESCRIBE `ports` 0.00067710876464844
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00023412704467773
(237) DESCRIBE `ports` 0.0010330677032471
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0002138614654541
(239) DESCRIBE `ports` 0.00067305564880371
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00017881393432617
(241) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63037') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0055210590362549
(242) DESCRIBE `avid_specials` 0.00085783004760742
(243) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63037 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 34 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.0010528564453125
(244) DESCRIBE `cruiselines` 0.00105881690979
(245) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024509429931641
(246) DESCRIBE `orchid_image` 0.00079798698425293
(247) DESCRIBE `cruiselines` 0.00097012519836426
(248) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00021696090698242
(249) DESCRIBE `cruises` 0.001331090927124
(250) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63250') 0.00034689903259277
(251) DESCRIBE `ships` 0.0021810531616211
(252) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.0004279613494873
(253) DESCRIBE `ships` 0.0015060901641846
(254) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00023102760314941
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016689300537109
(257) DESCRIBE `itineraries` 0.00072002410888672
(258) DESCRIBE `ports` 0.00083684921264648
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025415420532227
(260) DESCRIBE `ports` 0.00070309638977051
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019502639770508
(262) DESCRIBE `ports` 0.0006709098815918
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023293495178223
(264) DESCRIBE `sailingdates` 0.0005948543548584
(265) DESCRIBE `ports` 0.00073504447937012
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025701522827148
(267) DESCRIBE `ports` 0.00079798698425293
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019192695617676
(269) DESCRIBE `ports` 0.00073599815368652
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0002140998840332
(271) DESCRIBE `ports` 0.0010409355163574
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00023913383483887
(273) DESCRIBE `ports` 0.00066900253295898
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020980834960938
(275) DESCRIBE `ports` 0.00068116188049316
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00023198127746582
(277) DESCRIBE `ports` 0.0010349750518799
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00029110908508301
(279) DESCRIBE `ports` 0.00099587440490723
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00023508071899414
(281) DESCRIBE `ports` 0.00095605850219727
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00023794174194336
(283) DESCRIBE `ports` 0.00077390670776367
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.0001978874206543
(285) DESCRIBE `ports` 0.00066804885864258
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00023007392883301
(287) DESCRIBE `ports` 0.00066709518432617
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00020813941955566
(289) DESCRIBE `ports` 0.00065803527832031
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00020813941955566
(291) DESCRIBE `ports` 0.0006568431854248
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00017404556274414
(293) DESCRIBE `ports` 0.00066494941711426
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00019598007202148
(295) DESCRIBE `ports` 0.00071120262145996
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00017595291137695
(297) DESCRIBE `ports` 0.00065994262695312
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0001978874206543
(299) DESCRIBE `ports` 0.00067996978759766
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017809867858887
(301) DESCRIBE `ports` 0.00067591667175293
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0001978874206543
(303) DESCRIBE `ports` 0.00066208839416504
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00017905235290527
(305) DESCRIBE `ports` 0.00067996978759766
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0001981258392334
(307) DESCRIBE `ports` 0.00068306922912598
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00021696090698242
(309) DESCRIBE `ports` 0.0006721019744873
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 409))) 0.00020003318786621
(311) DESCRIBE `ports` 0.00065708160400391
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '409') 0.00018000602722168
(313) DESCRIBE `ports` 0.00069594383239746
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00020289421081543
(315) DESCRIBE `ports` 0.00074005126953125
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.0001978874206543
(317) DESCRIBE `ports` 0.00067806243896484
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1494))) 0.00020790100097656
(319) DESCRIBE `ports` 0.00065708160400391
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1494') 0.00017786026000977
(321) DESCRIBE `ports` 0.0006568431854248
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 407))) 0.00019717216491699
(323) DESCRIBE `ports` 0.00066614151000977
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '407') 0.00017786026000977
(325) DESCRIBE `ports` 0.00065398216247559
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026202201843262
(327) DESCRIBE `ports` 0.00084304809570312
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022983551025391
(329) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63250') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0054690837860107
(330) DESCRIBE `avid_specials` 0.00083494186401367
(331) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63250 and class = 'Cruise') OR (item_id = 1135 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.0010650157928467
(332) DESCRIBE `cruiselines` 0.0011730194091797
(333) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023102760314941
(334) DESCRIBE `orchid_image` 0.00075793266296387
(335) DESCRIBE `cruiselines` 0.00090909004211426
(336) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018811225891113
(337) DESCRIBE `cruises` 0.0012898445129395
(338) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63249') 0.0002129077911377
(339) DESCRIBE `ships` 0.0012919902801514
(340) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00024700164794922
(341) DESCRIBE `ships` 0.0012550354003906
(342) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00020408630371094
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(345) DESCRIBE `itineraries` 0.0007178783416748
(346) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63249') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085210800170898
(347) DESCRIBE `ports` 0.0013070106506348
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032901763916016
(349) DESCRIBE `ports` 0.001068115234375
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028514862060547
(351) DESCRIBE `ports` 0.001060962677002
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00027799606323242
(353) DESCRIBE `sailingdates` 0.00095295906066895
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63249') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007021427154541
(355) DESCRIBE `ports` 0.0012059211730957
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030899047851562
(357) DESCRIBE `ports` 0.0010819435119629
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030112266540527
(359) DESCRIBE `ports` 0.0011279582977295
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00030398368835449
(361) DESCRIBE `ports` 0.0010089874267578
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00025701522827148
(363) DESCRIBE `ports` 0.0011069774627686
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00034403800964355
(365) DESCRIBE `ports` 0.0011417865753174
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0002901554107666
(367) DESCRIBE `ports` 0.0010991096496582
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00030088424682617
(369) DESCRIBE `ports` 0.0011270046234131
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00028705596923828
(371) DESCRIBE `ports` 0.0010490417480469
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00028800964355469
(373) DESCRIBE `ports` 0.0010440349578857
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00026416778564453
(375) DESCRIBE `ports` 0.0010590553283691
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00033783912658691
(377) DESCRIBE `ports` 0.0012078285217285
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00029087066650391
(379) DESCRIBE `ports` 0.0009770393371582
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00029492378234863
(381) DESCRIBE `ports` 0.0010218620300293
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00026297569274902
(383) DESCRIBE `ports` 0.0010659694671631
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.0002739429473877
(385) DESCRIBE `ports` 0.0010550022125244
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00023221969604492
(387) DESCRIBE `ports` 0.00097489356994629
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026488304138184
(389) DESCRIBE `ports` 0.0010030269622803
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024795532226562
(391) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63249') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0099360942840576
(392) DESCRIBE `avid_specials` 0.001288890838623
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63249 and class = 'Cruise') OR (item_id = 1135 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.0019409656524658
(394) DESCRIBE `cruiselines` 0.0017240047454834
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037813186645508
(396) DESCRIBE `orchid_image` 0.0012679100036621
(397) DESCRIBE `cruiselines` 0.0015180110931396
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029206275939941
(399) DESCRIBE `cruises` 0.001633882522583
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63251') 0.0002601146697998
(401) DESCRIBE `ships` 0.001295804977417
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00026416778564453
(403) DESCRIBE `ships` 0.0012660026550293
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00018692016601562
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(407) DESCRIBE `itineraries` 0.00066208839416504
(408) DESCRIBE `ports` 0.00067806243896484
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021004676818848
(410) DESCRIBE `ports` 0.00069189071655273
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020003318786621
(412) DESCRIBE `ports` 0.00066399574279785
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017905235290527
(414) DESCRIBE `sailingdates` 0.00060606002807617
(415) DESCRIBE `ports` 0.00066995620727539
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019598007202148
(417) DESCRIBE `ports` 0.00066184997558594
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017786026000977
(419) DESCRIBE `ports` 0.00065994262695312
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00023889541625977
(421) DESCRIBE `ports` 0.00066614151000977
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00018000602722168
(423) DESCRIBE `ports` 0.00066494941711426
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00020313262939453
(425) DESCRIBE `ports` 0.00066113471984863
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00018906593322754
(427) DESCRIBE `ports` 0.00065994262695312
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019598007202148
(429) DESCRIBE `ports` 0.00066208839416504
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018000602722168
(431) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63251') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0053529739379883
(432) DESCRIBE `avid_specials` 0.00080084800720215
(433) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63251 and class = 'Cruise') OR (item_id = 542 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.0010030269622803
(434) DESCRIBE `cruiselines` 0.0010380744934082
(435) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022602081298828
(436) DESCRIBE `orchid_image` 0.00075697898864746
(437) DESCRIBE `cruiselines` 0.00097513198852539
(438) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019598007202148
(439) DESCRIBE `cruises` 0.0012989044189453
(440) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62546') 0.00034689903259277
(441) DESCRIBE `ships` 0.0019659996032715
(442) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00038385391235352
(443) DESCRIBE `ships` 0.0014770030975342
(444) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00021100044250488
(445) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(447) DESCRIBE `itineraries` 0.0007169246673584
(448) DESCRIBE `ports` 0.00072503089904785
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029301643371582
(450) DESCRIBE `ports` 0.0009307861328125
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00027298927307129
(452) DESCRIBE `ports` 0.00091195106506348
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00022792816162109
(454) DESCRIBE `sailingdates` 0.0007789134979248
(455) DESCRIBE `ports` 0.00078701972961426
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029301643371582
(457) DESCRIBE `ports` 0.00077199935913086
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00020813941955566
(459) DESCRIBE `ports` 0.00072288513183594
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00021505355834961
(461) DESCRIBE `ports` 0.00068283081054688
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00017809867858887
(463) DESCRIBE `ports` 0.00069594383239746
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020098686218262
(465) DESCRIBE `ports` 0.00073003768920898
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00017690658569336
(467) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62546') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0053219795227051
(468) DESCRIBE `avid_specials` 0.00081491470336914
(469) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62546 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010271072387695
(470) DESCRIBE `cruiselines` 0.0010290145874023
(471) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023007392883301
(472) DESCRIBE `orchid_image` 0.00076413154602051
(473) DESCRIBE `cruiselines` 0.0010378360748291
(474) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020098686218262
(475) DESCRIBE `cruises` 0.0014610290527344
(476) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57765') 0.00023794174194336
(477) DESCRIBE `ships` 0.0013430118560791
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00028395652770996
(479) DESCRIBE `ships` 0.0014288425445557
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00020289421081543
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001671314239502
(483) DESCRIBE `itineraries` 0.00067806243896484
(484) DESCRIBE `ports` 0.00070095062255859
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00027894973754883
(486) DESCRIBE `ports` 0.00067400932312012
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00020194053649902
(488) DESCRIBE `ports` 0.00072503089904785
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00018095970153809
(490) DESCRIBE `sailingdates` 0.00059318542480469
(491) DESCRIBE `ports` 0.00072813034057617
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00022101402282715
(493) DESCRIBE `ports` 0.00070405006408691
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00018882751464844
(495) DESCRIBE `ports` 0.0006711483001709
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00020694732666016
(497) DESCRIBE `ports` 0.00066995620727539
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00018000602722168
(499) DESCRIBE `ports` 0.00068902969360352
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00020217895507812
(501) DESCRIBE `ports` 0.00066995620727539
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018501281738281
(503) DESCRIBE `ports` 0.00069689750671387
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00019693374633789
(505) DESCRIBE `ports` 0.00071406364440918
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00017213821411133
(507) DESCRIBE `ports` 0.00070691108703613
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00020599365234375
(509) DESCRIBE `ports` 0.00072598457336426
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00018095970153809
(511) DESCRIBE `ports` 0.00066208839416504
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00020194053649902
(513) DESCRIBE `ports` 0.00066995620727539
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00018906593322754
(515) DESCRIBE `ports` 0.00081801414489746
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00026798248291016
(517) DESCRIBE `ports` 0.00091099739074707
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00023412704467773
(519) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57765') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.005810022354126
(520) DESCRIBE `avid_specials` 0.00090885162353516
(521) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57765 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.0011191368103027
(522) DESCRIBE `cruiselines` 0.0010559558868408
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00025701522827148
(524) DESCRIBE `orchid_image` 0.00080084800720215
(525) DESCRIBE `cruiselines` 0.001101016998291
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00027918815612793
(527) DESCRIBE `ships` 0.002202033996582
(528) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '1021', '406', '678', '434', '253', '451', '105', '290', '348', '580', '98', '291', '341', '1409')) ORDER BY FIND_IN_SET(id, '1135,349,542,1021,406,678,434,253,451,105,290,348,580,98,291,341,1409') 0.00095605850219727
(529) DESCRIBE `cruisetypes` 0.00089097023010254
(530) DESCRIBE `destinations` 0.0012550354003906
(531) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '43', '8', '48', '22', '53', '26', '40', '34', '29', '37', '21', '38', '11', '25', '49', '28', '30')) ORDER BY FIND_IN_SET(id, '12,35,2,43,8,48,22,53,26,40,34,29,37,21,38,11,25,49,28,30') 0.0012409687042236
(532) DESCRIBE `cruiselines` 0.0019798278808594
(533) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00038313865661621
(534) DESCRIBE `cruiselines` 0.00189208984375
(535) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00039792060852051