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

Total elapsed time: 0.42986536026001

# Query Time
(1) connect 0.0010659694671631
(2) DESCRIBE `cruises` 0.0022120475769043
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62664, 62674, 64863, 64881, 64923, 70196, 70241, 57133, 62665, 62690)) ORDER BY FIND_IN_SET(id, '62664,62674,64863,64881,64923,70196,70241,57133,62665,62690') 0.0014841556549072
(4) DESCRIBE `cruises` 0.0020570755004883
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62664') 0.00034284591674805
(6) DESCRIBE `ships` 0.0018949508666992
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.0003659725189209
(8) DESCRIBE `ships` 0.0016460418701172
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.0002589225769043
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019311904907227
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022792816162109
(12) DESCRIBE `itineraries` 0.00093793869018555
(13) DESCRIBE `ports` 0.0011718273162842
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031495094299316
(15) DESCRIBE `ports` 0.00098514556884766
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00026702880859375
(17) DESCRIBE `ports` 0.00089406967163086
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028085708618164
(19) DESCRIBE `sailingdates` 0.00090312957763672
(20) DESCRIBE `ports` 0.0013511180877686
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033688545227051
(22) DESCRIBE `ports` 0.0010359287261963
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022292137145996
(24) DESCRIBE `ports` 0.0007479190826416
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029110908508301
(26) DESCRIBE `ports` 0.00081586837768555
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00024104118347168
(28) DESCRIBE `ports` 0.00079894065856934
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024509429931641
(30) DESCRIBE `ports` 0.00088787078857422
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0002448558807373
(32) DESCRIBE `ports` 0.00096487998962402
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027608871459961
(34) DESCRIBE `ports` 0.0009160041809082
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003211498260498
(36) DESCRIBE `ports` 0.0010430812835693
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00031304359436035
(38) DESCRIBE `ports` 0.00088596343994141
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00023984909057617
(40) DESCRIBE `ports` 0.0008699893951416
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00027203559875488
(42) DESCRIBE `ports` 0.0010099411010742
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029516220092773
(44) DESCRIBE `ports` 0.0010831356048584
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00037693977355957
(46) DESCRIBE `ports` 0.0010459423065186
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00034689903259277
(48) DESCRIBE `avid_specials` 0.0009770393371582
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62664 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.0033788681030273
(50) DESCRIBE `cruiselines` 0.001655101776123
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034379959106445
(52) DESCRIBE `orchid_image` 0.0011980533599854
(53) DESCRIBE `cruiselines` 0.0015268325805664
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031590461730957
(55) DESCRIBE `cruises` 0.0023808479309082
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62674') 0.0003969669342041
(57) DESCRIBE `ships` 0.0018670558929443
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00058102607727051
(59) DESCRIBE `ships` 0.0023729801177979
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00036287307739258
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021100044250488
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(63) DESCRIBE `itineraries` 0.00095510482788086
(64) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62674') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013570785522461
(65) DESCRIBE `ports` 0.002640962600708
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00089192390441895
(67) DESCRIBE `ports` 0.0011630058288574
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00034999847412109
(69) DESCRIBE `ports` 0.0010800361633301
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00028681755065918
(71) DESCRIBE `sailingdates` 0.00089907646179199
(72) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62674') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051498413085938
(73) DESCRIBE `ports` 0.0012121200561523
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00034189224243164
(75) DESCRIBE `ports` 0.0010240077972412
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0002751350402832
(77) DESCRIBE `ports` 0.00085997581481934
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 769))) 0.00030899047851562
(79) DESCRIBE `ports` 0.0010340213775635
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '769') 0.00028300285339355
(81) DESCRIBE `ports` 0.00096416473388672
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.00028419494628906
(83) DESCRIBE `ports` 0.00091195106506348
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00023818016052246
(85) DESCRIBE `ports` 0.00091695785522461
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.00028395652770996
(87) DESCRIBE `ports` 0.00090885162353516
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00024008750915527
(89) DESCRIBE `ports` 0.00096821784973145
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00029110908508301
(91) DESCRIBE `ports` 0.00095796585083008
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00027203559875488
(93) DESCRIBE `ports` 0.00088000297546387
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.0002598762512207
(95) DESCRIBE `ports` 0.00095796585083008
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00029301643371582
(97) DESCRIBE `avid_specials` 0.00094199180603027
(98) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62674 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0017139911651611
(99) DESCRIBE `cruiselines` 0.0015068054199219
(100) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038599967956543
(101) DESCRIBE `orchid_image` 0.0012679100036621
(102) DESCRIBE `cruiselines` 0.0017549991607666
(103) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003201961517334
(104) DESCRIBE `cruises` 0.0019071102142334
(105) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64863') 0.0003659725189209
(106) DESCRIBE `ships` 0.001924991607666
(107) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00039911270141602
(108) DESCRIBE `ships` 0.0018789768218994
(109) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00033211708068848
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020503997802734
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(112) DESCRIBE `itineraries` 0.00097298622131348
(113) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64863') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012350082397461
(114) DESCRIBE `ports` 0.0010647773742676
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030899047851562
(116) DESCRIBE `ports` 0.0012760162353516
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00028800964355469
(118) DESCRIBE `ports` 0.00085997581481934
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00021195411682129
(120) DESCRIBE `sailingdates` 0.00070714950561523
(121) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64863') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042009353637695
(122) DESCRIBE `ports` 0.0010201930999756
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00031781196594238
(124) DESCRIBE `ports` 0.00097203254699707
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00025582313537598
(126) DESCRIBE `ports` 0.00097393989562988
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00026416778564453
(128) DESCRIBE `ports` 0.00091981887817383
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00023508071899414
(130) DESCRIBE `ports` 0.00087118148803711
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00036883354187012
(132) DESCRIBE `ports` 0.0010650157928467
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027203559875488
(134) DESCRIBE `ports` 0.00095200538635254
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00032186508178711
(136) DESCRIBE `ports` 0.00105881690979
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00031018257141113
(138) DESCRIBE `ports` 0.0010170936584473
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00041699409484863
(140) DESCRIBE `ports` 0.0011911392211914
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00031805038452148
(142) DESCRIBE `ports` 0.0010740756988525
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00032520294189453
(144) DESCRIBE `ports` 0.0010020732879639
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00026392936706543
(146) DESCRIBE `ports` 0.00095200538635254
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00031518936157227
(148) DESCRIBE `ports` 0.0010190010070801
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00029420852661133
(150) DESCRIBE `avid_specials` 0.0009310245513916
(151) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64863 and class = 'Cruise') OR (item_id = 407 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.001798152923584
(152) DESCRIBE `cruiselines` 0.0015170574188232
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034999847412109
(154) DESCRIBE `orchid_image` 0.0011379718780518
(155) DESCRIBE `cruiselines` 0.0014758110046387
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003209114074707
(157) DESCRIBE `cruises` 0.0033309459686279
(158) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64881') 0.00037002563476562
(159) DESCRIBE `ships` 0.0021061897277832
(160) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00043320655822754
(161) DESCRIBE `ships` 0.0023670196533203
(162) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00036883354187012
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(165) DESCRIBE `itineraries` 0.00097203254699707
(166) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64881') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010859966278076
(167) DESCRIBE `ports` 0.0012111663818359
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00032186508178711
(169) DESCRIBE `ports` 0.0010168552398682
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00026297569274902
(171) DESCRIBE `ports` 0.00093293190002441
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00024914741516113
(173) DESCRIBE `sailingdates` 0.00083804130554199
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64881') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049901008605957
(175) DESCRIBE `ports` 0.0011529922485352
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00030207633972168
(177) DESCRIBE `ports` 0.00092411041259766
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00023913383483887
(179) DESCRIBE `ports` 0.00090909004211426
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00027298927307129
(181) DESCRIBE `ports` 0.00095009803771973
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00027203559875488
(183) DESCRIBE `ports` 0.0010850429534912
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.00029397010803223
(185) DESCRIBE `ports` 0.00092720985412598
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00025701522827148
(187) DESCRIBE `ports` 0.00093603134155273
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 769))) 0.00025486946105957
(189) DESCRIBE `ports` 0.00089478492736816
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '769') 0.00022602081298828
(191) DESCRIBE `ports` 0.00093197822570801
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1589))) 0.00024986267089844
(193) DESCRIBE `ports` 0.00091910362243652
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1589') 0.00024604797363281
(195) DESCRIBE `ports` 0.00096893310546875
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00028395652770996
(197) DESCRIBE `ports` 0.00093317031860352
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00023412704467773
(199) DESCRIBE `avid_specials` 0.00082898139953613
(200) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64881 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0016930103302002
(201) DESCRIBE `cruiselines` 0.0016870498657227
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038290023803711
(203) DESCRIBE `orchid_image` 0.0011630058288574
(204) DESCRIBE `cruiselines` 0.0013480186462402
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002598762512207
(206) DESCRIBE `cruises` 0.0017311573028564
(207) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64923') 0.00032305717468262
(208) DESCRIBE `ships` 0.0017218589782715
(209) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00035905838012695
(210) DESCRIBE `ships` 0.0019240379333496
(211) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00034379959106445
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022006034851074
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(214) DESCRIBE `itineraries` 0.0010750293731689
(215) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64923') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001183032989502
(216) DESCRIBE `ports` 0.0012760162353516
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00032711029052734
(218) DESCRIBE `ports` 0.00097393989562988
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00026082992553711
(220) DESCRIBE `ports` 0.00092411041259766
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00024795532226562
(222) DESCRIBE `sailingdates` 0.00083804130554199
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64923') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054597854614258
(224) DESCRIBE `ports` 0.00124192237854
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00035500526428223
(226) DESCRIBE `ports` 0.0010509490966797
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00025796890258789
(228) DESCRIBE `ports` 0.0009310245513916
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3646))) 0.00025391578674316
(230) DESCRIBE `ports` 0.00093698501586914
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3646') 0.00023603439331055
(232) DESCRIBE `ports` 0.00091099739074707
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3646))) 0.00027084350585938
(234) DESCRIBE `ports` 0.00098204612731934
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3646') 0.00044488906860352
(236) DESCRIBE `ports` 0.0012378692626953
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00022292137145996
(238) DESCRIBE `ports` 0.0006251335144043
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00017786026000977
(240) DESCRIBE `avid_specials` 0.00064897537231445
(241) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64923 and class = 'Cruise') OR (item_id = 462 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.0013880729675293
(242) DESCRIBE `cruiselines` 0.0013320446014404
(243) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031018257141113
(244) DESCRIBE `orchid_image` 0.0011649131774902
(245) DESCRIBE `cruiselines` 0.0012938976287842
(246) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027704238891602
(247) DESCRIBE `cruises` 0.0021460056304932
(248) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70196') 0.00033211708068848
(249) DESCRIBE `ships` 0.0018858909606934
(250) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.0005180835723877
(251) DESCRIBE `ships` 0.0018570423126221
(252) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00030899047851562
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019502639770508
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018715858459473
(255) DESCRIBE `itineraries` 0.00092792510986328
(256) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70196') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012919902801514
(257) DESCRIBE `ports` 0.0013060569763184
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003669261932373
(259) DESCRIBE `ports` 0.00099897384643555
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00029182434082031
(261) DESCRIBE `ports` 0.00098896026611328
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002741813659668
(263) DESCRIBE `sailingdates` 0.00083589553833008
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70196') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045895576477051
(265) DESCRIBE `ports` 0.0010390281677246
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031208992004395
(267) DESCRIBE `ports` 0.00095295906066895
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00027894973754883
(269) DESCRIBE `ports` 0.0010209083557129
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00028204917907715
(271) DESCRIBE `ports` 0.00087404251098633
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00022578239440918
(273) DESCRIBE `ports` 0.00087904930114746
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00026893615722656
(275) DESCRIBE `ports` 0.00089311599731445
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00024199485778809
(277) DESCRIBE `ports` 0.00092697143554688
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00026106834411621
(279) DESCRIBE `ports` 0.00090694427490234
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00023317337036133
(281) DESCRIBE `ports` 0.00092911720275879
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00026583671569824
(283) DESCRIBE `ports` 0.0009150505065918
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00029587745666504
(285) DESCRIBE `ports` 0.0010049343109131
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003049373626709
(287) DESCRIBE `ports` 0.00094294548034668
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00025105476379395
(289) DESCRIBE `ports` 0.00094389915466309
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00029110908508301
(291) DESCRIBE `ports` 0.0010111331939697
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00027203559875488
(293) DESCRIBE `ports` 0.00097203254699707
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00029420852661133
(295) DESCRIBE `ports` 0.00094294548034668
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00025606155395508
(297) DESCRIBE `ports` 0.00090193748474121
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00027203559875488
(299) DESCRIBE `ports` 0.00091814994812012
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00023508071899414
(301) DESCRIBE `ports` 0.00090789794921875
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2130))) 0.00034403800964355
(303) DESCRIBE `ports` 0.0010080337524414
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2130') 0.00026392936706543
(305) DESCRIBE `ports` 0.00095009803771973
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00027990341186523
(307) DESCRIBE `ports` 0.00092291831970215
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00024509429931641
(309) DESCRIBE `ports` 0.00097012519836426
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00028586387634277
(311) DESCRIBE `ports` 0.00098991394042969
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00028109550476074
(313) DESCRIBE `ports` 0.001011848449707
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005040168762207
(315) DESCRIBE `ports` 0.0018360614776611
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00047612190246582
(317) DESCRIBE `avid_specials` 0.0012550354003906
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70196 and class = 'Cruise') OR (item_id = 977 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.0018949508666992
(319) DESCRIBE `cruiselines` 0.0018970966339111
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0004730224609375
(321) DESCRIBE `orchid_image` 0.0011670589447021
(322) DESCRIBE `cruiselines` 0.0013048648834229
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00035214424133301
(324) DESCRIBE `cruises` 0.0021522045135498
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70241') 0.00060391426086426
(326) DESCRIBE `ships` 0.0019998550415039
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00045084953308105
(328) DESCRIBE `ships` 0.0019559860229492
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00034999847412109
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021982192993164
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020003318786621
(332) DESCRIBE `itineraries` 0.0010819435119629
(333) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70241') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012259483337402
(334) DESCRIBE `ports` 0.0011770725250244
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00031185150146484
(336) DESCRIBE `ports` 0.00098299980163574
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00028514862060547
(338) DESCRIBE `ports` 0.0009000301361084
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00024008750915527
(340) DESCRIBE `sailingdates` 0.00081896781921387
(341) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70241') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046396255493164
(342) DESCRIBE `ports` 0.0011279582977295
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00031208992004395
(344) DESCRIBE `ports` 0.00096392631530762
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00026893615722656
(346) DESCRIBE `ports` 0.00098681449890137
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00028586387634277
(348) DESCRIBE `ports` 0.00095295906066895
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00027894973754883
(350) DESCRIBE `ports` 0.00095486640930176
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00026392936706543
(352) DESCRIBE `ports` 0.00091695785522461
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00023984909057617
(354) DESCRIBE `ports` 0.00087904930114746
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00026702880859375
(356) DESCRIBE `ports` 0.00091099739074707
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00024199485778809
(358) DESCRIBE `ports` 0.0009150505065918
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.0002589225769043
(360) DESCRIBE `ports` 0.00085306167602539
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00024509429931641
(362) DESCRIBE `ports` 0.00089883804321289
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00028109550476074
(364) DESCRIBE `ports` 0.00092697143554688
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00027298927307129
(366) DESCRIBE `ports` 0.00092005729675293
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00027084350585938
(368) DESCRIBE `ports` 0.00094008445739746
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00025606155395508
(370) DESCRIBE `ports` 0.00085592269897461
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00027704238891602
(372) DESCRIBE `ports` 0.00098490715026855
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00025606155395508
(374) DESCRIBE `ports` 0.00089502334594727
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00028800964355469
(376) DESCRIBE `ports` 0.00096917152404785
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00024986267089844
(378) DESCRIBE `ports` 0.00096988677978516
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00026512145996094
(380) DESCRIBE `ports` 0.00086593627929688
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00021004676818848
(382) DESCRIBE `ports` 0.00084590911865234
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00029587745666504
(384) DESCRIBE `ports` 0.00091099739074707
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00022578239440918
(386) DESCRIBE `ports` 0.00084185600280762
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1806))) 0.00027799606323242
(388) DESCRIBE `ports` 0.00096297264099121
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1806') 0.00025510787963867
(390) DESCRIBE `ports` 0.0008690357208252
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00029087066650391
(392) DESCRIBE `ports` 0.00099492073059082
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.0002748966217041
(394) DESCRIBE `ports` 0.0009000301361084
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00026512145996094
(396) DESCRIBE `ports` 0.00091719627380371
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00023198127746582
(398) DESCRIBE `avid_specials` 0.00077390670776367
(399) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70241 and class = 'Cruise') OR (item_id = 726 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.0015289783477783
(400) DESCRIBE `cruiselines` 0.0013370513916016
(401) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030994415283203
(402) DESCRIBE `orchid_image` 0.0010299682617188
(403) DESCRIBE `cruiselines` 0.0019409656524658
(404) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032305717468262
(405) DESCRIBE `cruises` 0.002032995223999
(406) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57133') 0.00038886070251465
(407) DESCRIBE `ships` 0.0023348331451416
(408) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00048279762268066
(409) DESCRIBE `ships` 0.0019829273223877
(410) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00032401084899902
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002131462097168
(412) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(413) DESCRIBE `itineraries` 0.00105881690979
(414) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57133') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010230541229248
(415) DESCRIBE `ports` 0.0012898445129395
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033283233642578
(417) DESCRIBE `ports` 0.00094699859619141
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00026416778564453
(419) DESCRIBE `ports` 0.00085306167602539
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00023102760314941
(421) DESCRIBE `sailingdates` 0.00073504447937012
(422) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57133') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050020217895508
(423) DESCRIBE `ports` 0.0010030269622803
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00028204917907715
(425) DESCRIBE `ports` 0.00082015991210938
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00026702880859375
(427) DESCRIBE `ports` 0.00085806846618652
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.0003049373626709
(429) DESCRIBE `ports` 0.0009920597076416
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00026106834411621
(431) DESCRIBE `ports` 0.00080585479736328
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00024294853210449
(433) DESCRIBE `ports` 0.00078797340393066
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00021600723266602
(435) DESCRIBE `ports` 0.00078201293945312
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00024604797363281
(437) DESCRIBE `ports` 0.000823974609375
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00023508071899414
(439) DESCRIBE `ports` 0.00086092948913574
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00026297569274902
(441) DESCRIBE `ports` 0.00080323219299316
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00022196769714355
(443) DESCRIBE `ports` 0.00079512596130371
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024795532226562
(445) DESCRIBE `ports` 0.00080013275146484
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00021600723266602
(447) DESCRIBE `avid_specials` 0.00075387954711914
(448) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57133 and class = 'Cruise') OR (item_id = 977 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.0014519691467285
(449) DESCRIBE `cruiselines` 0.0014228820800781
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031590461730957
(451) DESCRIBE `orchid_image` 0.0010502338409424
(452) DESCRIBE `cruiselines` 0.0014610290527344
(453) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00033378601074219
(454) DESCRIBE `cruises` 0.0019309520721436
(455) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00032496452331543
(456) DESCRIBE `ships` 0.0013258457183838
(457) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.0003058910369873
(458) DESCRIBE `ships` 0.001427173614502
(459) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00023889541625977
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(461) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001530647277832
(462) DESCRIBE `itineraries` 0.0010049343109131
(463) DESCRIBE `ports` 0.00071215629577637
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00027894973754883
(465) DESCRIBE `ports` 0.00088310241699219
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00037002563476562
(467) DESCRIBE `ports` 0.0013079643249512
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027704238891602
(469) DESCRIBE `sailingdates` 0.00084018707275391
(470) DESCRIBE `ports` 0.0013799667358398
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00033092498779297
(472) DESCRIBE `ports` 0.00095701217651367
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00023794174194336
(474) DESCRIBE `ports` 0.00096487998962402
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030398368835449
(476) DESCRIBE `ports` 0.0010120868682861
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028204917907715
(478) DESCRIBE `ports` 0.00096297264099121
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029492378234863
(480) DESCRIBE `ports` 0.00097799301147461
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024199485778809
(482) DESCRIBE `ports` 0.00092697143554688
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00028491020202637
(484) DESCRIBE `ports` 0.0011260509490967
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00027203559875488
(486) DESCRIBE `ports` 0.00097393989562988
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00028300285339355
(488) DESCRIBE `ports` 0.00093197822570801
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00021696090698242
(490) DESCRIBE `ports` 0.00085091590881348
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031399726867676
(492) DESCRIBE `ports` 0.0010139942169189
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026988983154297
(494) DESCRIBE `ports` 0.00092101097106934
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026392936706543
(496) DESCRIBE `ports` 0.00079202651977539
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00022697448730469
(498) DESCRIBE `avid_specials` 0.00095701217651367
(499) 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.0016329288482666
(500) DESCRIBE `cruiselines` 0.0014791488647461
(501) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036716461181641
(502) DESCRIBE `orchid_image` 0.0012829303741455
(503) DESCRIBE `cruiselines` 0.0015630722045898
(504) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003049373626709
(505) DESCRIBE `cruises` 0.002112865447998
(506) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62690') 0.00033187866210938
(507) DESCRIBE `ships` 0.0017859935760498
(508) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00035881996154785
(509) DESCRIBE `ships` 0.0018758773803711
(510) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00034499168395996
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001981258392334
(512) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(513) DESCRIBE `itineraries` 0.0010340213775635
(514) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62690') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051498413085938
(515) DESCRIBE `ports` 0.0011420249938965
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00050902366638184
(517) DESCRIBE `ports` 0.0009310245513916
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00026988983154297
(519) DESCRIBE `ports` 0.00095009803771973
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00028705596923828
(521) DESCRIBE `sailingdates` 0.00090694427490234
(522) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62690') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046300888061523
(523) DESCRIBE `ports` 0.0011019706726074
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00029301643371582
(525) DESCRIBE `ports` 0.00097894668579102
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00025606155395508
(527) DESCRIBE `ports` 0.00099015235900879
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00038790702819824
(529) DESCRIBE `ports` 0.0010180473327637
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00024890899658203
(531) DESCRIBE `ports` 0.000946044921875
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0002739429473877
(533) DESCRIBE `ports` 0.0009758472442627
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00024700164794922
(535) DESCRIBE `ports` 0.0010290145874023
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00027585029602051
(537) DESCRIBE `ports` 0.00094795227050781
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0002589225769043
(539) DESCRIBE `ports` 0.00094509124755859
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00029492378234863
(541) DESCRIBE `ports` 0.0010700225830078
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00027799606323242
(543) DESCRIBE `ports` 0.00098395347595215
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030994415283203
(545) DESCRIBE `ports` 0.001244068145752
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00027108192443848
(547) DESCRIBE `ports` 0.0009911060333252
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00028514862060547
(549) DESCRIBE `ports` 0.00091695785522461
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00023698806762695
(551) DESCRIBE `avid_specials` 0.0018401145935059
(552) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62690 and class = 'Cruise') OR (item_id = 407 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.0011448860168457
(553) DESCRIBE `cruiselines` 0.0010561943054199
(554) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025486946105957
(555) DESCRIBE `orchid_image` 0.00076389312744141
(556) DESCRIBE `cruiselines` 0.0012049674987793
(557) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027298927307129
(558) DESCRIBE `ships` 0.0021898746490479
(559) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1359', '407', '726', '452', '1599', '1067', '553', '462', '766', '1415', '1588', '610', '674', '352', '738')) ORDER BY FIND_IN_SET(id, '977,1359,407,726,452,1599,1067,553,462,766,1415,1588,610,674,352,738') 0.0012729167938232
(560) DESCRIBE `cruisetypes` 0.0010271072387695
(561) DESCRIBE `destinations` 0.0014081001281738
(562) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '52', '28', '25', '26', '37', '45', '38', '40', '35', '21', '49', '48')) ORDER BY FIND_IN_SET(id, '22,12,52,28,25,26,37,45,38,40,35,21,49,48') 0.0010848045349121
(563) DESCRIBE `cruiselines` 0.0013720989227295
(564) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003361701965332
(565) DESCRIBE `cruiselines` 0.0015158653259277
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00033903121948242