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

Total elapsed time: 0.44597125053406

# Query Time
(1) connect 0.00065493583679199
(2) DESCRIBE `cruises` 0.0021800994873047
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66914, 49107, 63047, 49109, 66915, 66917, 66918, 49111, 66916, 66919)) ORDER BY FIND_IN_SET(id, '66914,49107,63047,49109,66915,66917,66918,49111,66916,66919') 0.00092387199401855
(4) DESCRIBE `cruises` 0.0017290115356445
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66914') 0.00032901763916016
(6) DESCRIBE `ships` 0.0014059543609619
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00035691261291504
(8) DESCRIBE `ships` 0.0016210079193115
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00027894973754883
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020503997802734
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001990795135498
(12) DESCRIBE `itineraries` 0.00079989433288574
(13) DESCRIBE `ports` 0.0010290145874023
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00025391578674316
(15) DESCRIBE `ports` 0.00067520141601562
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020098686218262
(17) DESCRIBE `ports` 0.00075602531433105
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00022792816162109
(19) DESCRIBE `sailingdates` 0.00069284439086914
(20) DESCRIBE `ports` 0.00086116790771484
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027608871459961
(22) DESCRIBE `ports` 0.00085210800170898
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00020503997802734
(24) DESCRIBE `ports` 0.00085806846618652
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00024890899658203
(26) DESCRIBE `ports` 0.00086307525634766
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00019693374633789
(28) DESCRIBE `ports` 0.00084710121154785
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030303001403809
(30) DESCRIBE `ports` 0.00077605247497559
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0001988410949707
(32) DESCRIBE `ports` 0.00072693824768066
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020599365234375
(34) DESCRIBE `ports` 0.0007779598236084
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018811225891113
(36) DESCRIBE `ports` 0.00068807601928711
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002131462097168
(38) DESCRIBE `ports` 0.00069713592529297
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020217895507812
(40) DESCRIBE `ports` 0.00074195861816406
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020694732666016
(42) DESCRIBE `ports` 0.00074005126953125
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018501281738281
(44) DESCRIBE `ports` 0.00066709518432617
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020289421081543
(46) DESCRIBE `ports` 0.0006709098815918
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019001960754395
(48) DESCRIBE `ports` 0.00068497657775879
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00024700164794922
(50) DESCRIBE `ports` 0.00076603889465332
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018882751464844
(52) DESCRIBE `ports` 0.00067806243896484
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020313262939453
(54) DESCRIBE `ports` 0.0007789134979248
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00024008750915527
(56) DESCRIBE `ports` 0.0006709098815918
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022697448730469
(58) DESCRIBE `ports` 0.00072193145751953
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00022196769714355
(60) DESCRIBE `ports` 0.00067305564880371
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020599365234375
(62) DESCRIBE `ports` 0.0006871223449707
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0001838207244873
(64) DESCRIBE `ports` 0.00066900253295898
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0001988410949707
(66) DESCRIBE `ports` 0.00070595741271973
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019311904907227
(68) DESCRIBE `ports` 0.00067901611328125
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00023198127746582
(70) DESCRIBE `ports` 0.00070595741271973
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00019502639770508
(72) DESCRIBE `ports` 0.00065994262695312
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027203559875488
(74) DESCRIBE `ports` 0.00085091590881348
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00021505355834961
(76) DESCRIBE `avid_specials` 0.00070691108703613
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66914 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0011160373687744
(78) DESCRIBE `cruiselines` 0.0010519027709961
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00024294853210449
(80) DESCRIBE `orchid_image` 0.0007779598236084
(81) DESCRIBE `cruiselines` 0.00094985961914062
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.0002129077911377
(83) DESCRIBE `cruises` 0.0012669563293457
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49107') 0.00022697448730469
(85) DESCRIBE `ships` 0.001291036605835
(86) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00025606155395508
(87) DESCRIBE `ships` 0.0013480186462402
(88) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00019502639770508
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018191337585449
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016999244689941
(91) DESCRIBE `itineraries` 0.00075316429138184
(92) DESCRIBE `ports` 0.00080299377441406
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027108192443848
(94) DESCRIBE `ports` 0.00071978569030762
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020599365234375
(96) DESCRIBE `ports` 0.00072216987609863
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0001978874206543
(98) DESCRIBE `sailingdates` 0.0006101131439209
(99) DESCRIBE `ports` 0.0007939338684082
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00024604797363281
(101) DESCRIBE `ports` 0.00070500373840332
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00021600723266602
(103) DESCRIBE `ports` 0.00067496299743652
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0002131462097168
(105) DESCRIBE `ports` 0.00071501731872559
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019001960754395
(107) DESCRIBE `ports` 0.0006721019744873
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020790100097656
(109) DESCRIBE `ports` 0.0006861686706543
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018906593322754
(111) DESCRIBE `ports` 0.00068402290344238
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021791458129883
(113) DESCRIBE `ports` 0.00089001655578613
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002129077911377
(115) DESCRIBE `ports` 0.00081920623779297
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020813941955566
(117) DESCRIBE `ports` 0.00092720985412598
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020694732666016
(119) DESCRIBE `ports` 0.00088191032409668
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031089782714844
(121) DESCRIBE `ports` 0.00096297264099121
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025296211242676
(123) DESCRIBE `ports` 0.00073885917663574
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021696090698242
(125) DESCRIBE `ports` 0.00095105171203613
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00024700164794922
(127) DESCRIBE `ports` 0.0008080005645752
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00025606155395508
(129) DESCRIBE `ports` 0.0010738372802734
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00034189224243164
(131) DESCRIBE `ports` 0.0011529922485352
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031518936157227
(133) DESCRIBE `ports` 0.00098490715026855
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00026202201843262
(135) DESCRIBE `ports` 0.00095105171203613
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00023198127746582
(137) DESCRIBE `ports` 0.00089907646179199
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00027203559875488
(139) DESCRIBE `ports` 0.0010080337524414
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00032496452331543
(141) DESCRIBE `ports` 0.0010859966278076
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00027799606323242
(143) DESCRIBE `ports` 0.00075387954711914
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00030398368835449
(145) DESCRIBE `ports` 0.00082492828369141
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.0002288818359375
(147) DESCRIBE `ports` 0.00092291831970215
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00026392936706543
(149) DESCRIBE `ports` 0.00094103813171387
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00023603439331055
(151) DESCRIBE `ports` 0.00089788436889648
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4186))) 0.00031399726867676
(153) DESCRIBE `ports` 0.00096011161804199
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4186') 0.0002601146697998
(155) DESCRIBE `avid_specials` 0.00080394744873047
(156) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49107 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0010190010070801
(157) DESCRIBE `cruiselines` 0.0010879039764404
(158) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00023698806762695
(159) DESCRIBE `orchid_image` 0.00079178810119629
(160) DESCRIBE `cruiselines` 0.001007080078125
(161) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00020790100097656
(162) DESCRIBE `cruises` 0.0012998580932617
(163) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63047') 0.00022602081298828
(164) DESCRIBE `ships` 0.001378059387207
(165) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00030612945556641
(166) DESCRIBE `ships` 0.001701831817627
(167) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00035214424133301
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018811225891113
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017285346984863
(170) DESCRIBE `itineraries` 0.0008847713470459
(171) DESCRIBE `ports` 0.00083303451538086
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00026679039001465
(173) DESCRIBE `ports` 0.00080585479736328
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021791458129883
(175) DESCRIBE `ports` 0.00075602531433105
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020194053649902
(177) DESCRIBE `sailingdates` 0.00063014030456543
(178) DESCRIBE `ports` 0.00071001052856445
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023078918457031
(180) DESCRIBE `ports` 0.00076699256896973
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00022697448730469
(182) DESCRIBE `ports` 0.00069808959960938
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00020599365234375
(184) DESCRIBE `ports` 0.00075721740722656
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00018095970153809
(186) DESCRIBE `ports` 0.00067806243896484
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00021600723266602
(188) DESCRIBE `ports` 0.00068402290344238
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.0002129077911377
(190) DESCRIBE `ports` 0.00068879127502441
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0002140998840332
(192) DESCRIBE `ports` 0.00070786476135254
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00018715858459473
(194) DESCRIBE `ports` 0.00071978569030762
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021600723266602
(196) DESCRIBE `ports` 0.00069499015808105
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019097328186035
(198) DESCRIBE `ports` 0.0006859302520752
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021481513977051
(200) DESCRIBE `ports` 0.00072288513183594
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0001981258392334
(202) DESCRIBE `ports` 0.00070309638977051
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00021505355834961
(204) DESCRIBE `ports` 0.0006859302520752
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00018715858459473
(206) DESCRIBE `ports` 0.00069904327392578
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022220611572266
(208) DESCRIBE `ports` 0.00070285797119141
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019598007202148
(210) DESCRIBE `ports` 0.00072717666625977
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023293495178223
(212) DESCRIBE `ports` 0.00070285797119141
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019192695617676
(214) DESCRIBE `ports` 0.00067496299743652
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029778480529785
(216) DESCRIBE `ports` 0.00074100494384766
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00024318695068359
(218) DESCRIBE `ports` 0.0010299682617188
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030684471130371
(220) DESCRIBE `ports` 0.00095009803771973
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023889541625977
(222) DESCRIBE `ports` 0.00095891952514648
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028109550476074
(224) DESCRIBE `ports` 0.00078701972961426
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020194053649902
(226) DESCRIBE `ports` 0.00097298622131348
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030398368835449
(228) DESCRIBE `ports` 0.00095510482788086
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00023603439331055
(230) DESCRIBE `ports` 0.00095701217651367
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026106834411621
(232) DESCRIBE `ports` 0.00095891952514648
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00023698806762695
(234) DESCRIBE `avid_specials` 0.00083398818969727
(235) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63047 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.001187801361084
(236) DESCRIBE `cruiselines` 0.0014491081237793
(237) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.0003352165222168
(238) DESCRIBE `orchid_image` 0.00084400177001953
(239) DESCRIBE `cruiselines` 0.0013129711151123
(240) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00030899047851562
(241) DESCRIBE `cruises` 0.0021529197692871
(242) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49109') 0.00034189224243164
(243) DESCRIBE `ships` 0.0015771389007568
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00029206275939941
(245) DESCRIBE `ships` 0.001410961151123
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00021600723266602
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018310546875
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020885467529297
(249) DESCRIBE `itineraries` 0.00072717666625977
(250) DESCRIBE `ports` 0.00080418586730957
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00023293495178223
(252) DESCRIBE `ports` 0.00094699859619141
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026321411132812
(254) DESCRIBE `ports` 0.0010199546813965
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030303001403809
(256) DESCRIBE `sailingdates` 0.00067591667175293
(257) DESCRIBE `ports` 0.00073790550231934
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00022697448730469
(259) DESCRIBE `ports` 0.00072503089904785
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0001990795135498
(261) DESCRIBE `ports` 0.00071883201599121
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00022482872009277
(263) DESCRIBE `ports` 0.0006871223449707
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00020098686218262
(265) DESCRIBE `ports` 0.0010190010070801
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0002598762512207
(267) DESCRIBE `ports` 0.00076198577880859
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019502639770508
(269) DESCRIBE `ports` 0.00072598457336426
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00024700164794922
(271) DESCRIBE `ports` 0.00068092346191406
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00018596649169922
(273) DESCRIBE `ports` 0.00067901611328125
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002138614654541
(275) DESCRIBE `ports` 0.00068020820617676
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018692016601562
(277) DESCRIBE `ports` 0.00069093704223633
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021004676818848
(279) DESCRIBE `ports` 0.00071382522583008
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018501281738281
(281) DESCRIBE `ports` 0.00074601173400879
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021100044250488
(283) DESCRIBE `ports` 0.00069189071655273
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018405914306641
(285) DESCRIBE `ports` 0.00068998336791992
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023794174194336
(287) DESCRIBE `ports` 0.0007469654083252
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018787384033203
(289) DESCRIBE `ports` 0.00068283081054688
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021195411682129
(291) DESCRIBE `ports` 0.0007178783416748
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020480155944824
(293) DESCRIBE `ports` 0.0007331371307373
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002589225769043
(295) DESCRIBE `ports` 0.00076007843017578
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019502639770508
(297) DESCRIBE `ports` 0.00069689750671387
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.00021219253540039
(299) DESCRIBE `ports` 0.00068998336791992
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00018596649169922
(301) DESCRIBE `ports` 0.00067710876464844
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00024986267089844
(303) DESCRIBE `ports` 0.00076198577880859
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020289421081543
(305) DESCRIBE `ports` 0.0007178783416748
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021004676818848
(307) DESCRIBE `ports` 0.00070405006408691
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019311904907227
(309) DESCRIBE `avid_specials` 0.00062704086303711
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49109 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.00098800659179688
(311) DESCRIBE `cruiselines` 0.0010659694671631
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.0002439022064209
(313) DESCRIBE `orchid_image` 0.0007789134979248
(314) DESCRIBE `cruiselines` 0.0010240077972412
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.0002140998840332
(316) DESCRIBE `cruises` 0.001309871673584
(317) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66915') 0.0002288818359375
(318) DESCRIBE `ships` 0.0013108253479004
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00026893615722656
(320) DESCRIBE `ships` 0.0013720989227295
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00020694732666016
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018310546875
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017189979553223
(324) DESCRIBE `itineraries` 0.0008080005645752
(325) DESCRIBE `ports` 0.00094294548034668
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00027298927307129
(327) DESCRIBE `ports` 0.0008089542388916
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00024294853210449
(329) DESCRIBE `ports` 0.0007178783416748
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020790100097656
(331) DESCRIBE `sailingdates` 0.00061583518981934
(332) DESCRIBE `ports` 0.00081300735473633
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.000244140625
(334) DESCRIBE `ports` 0.00069904327392578
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019502639770508
(336) DESCRIBE `ports` 0.0007479190826416
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00024199485778809
(338) DESCRIBE `ports` 0.00077414512634277
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019407272338867
(340) DESCRIBE `ports` 0.00077104568481445
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.00021600723266602
(342) DESCRIBE `ports` 0.00068998336791992
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00019598007202148
(344) DESCRIBE `ports` 0.00077700614929199
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00024795532226562
(346) DESCRIBE `ports` 0.00069093704223633
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018811225891113
(348) DESCRIBE `ports` 0.00067806243896484
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020599365234375
(350) DESCRIBE `ports` 0.00077104568481445
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020408630371094
(352) DESCRIBE `ports` 0.00075602531433105
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021600723266602
(354) DESCRIBE `ports` 0.00074601173400879
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025701522827148
(356) DESCRIBE `ports` 0.00072693824768066
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022101402282715
(358) DESCRIBE `ports` 0.00095987319946289
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002589225769043
(360) DESCRIBE `ports` 0.001035213470459
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00035309791564941
(362) DESCRIBE `ports` 0.00097489356994629
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020599365234375
(364) DESCRIBE `ports` 0.00079703330993652
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00024795532226562
(366) DESCRIBE `ports` 0.00071501731872559
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019502639770508
(368) DESCRIBE `ports` 0.0007169246673584
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00021004676818848
(370) DESCRIBE `ports` 0.00080704689025879
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00018787384033203
(372) DESCRIBE `ports` 0.00075197219848633
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00026583671569824
(374) DESCRIBE `ports` 0.0009620189666748
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031709671020508
(376) DESCRIBE `ports` 0.0010380744934082
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00023412704467773
(378) DESCRIBE `ports` 0.00090789794921875
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00019693374633789
(380) DESCRIBE `ports` 0.00076699256896973
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023698806762695
(382) DESCRIBE `ports` 0.00096487998962402
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019097328186035
(384) DESCRIBE `avid_specials` 0.00061988830566406
(385) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66915 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0011508464813232
(386) DESCRIBE `cruiselines` 0.0010390281677246
(387) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00024104118347168
(388) DESCRIBE `orchid_image` 0.00092482566833496
(389) DESCRIBE `cruiselines` 0.0010249614715576
(390) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00029516220092773
(391) DESCRIBE `cruises` 0.0015461444854736
(392) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66917') 0.00024104118347168
(393) DESCRIBE `ships` 0.0014121532440186
(394) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00028514862060547
(395) DESCRIBE `ships` 0.001410961151123
(396) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00028300285339355
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024008750915527
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022101402282715
(399) DESCRIBE `itineraries` 0.0009610652923584
(400) DESCRIBE `ports` 0.00092005729675293
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00030088424682617
(402) DESCRIBE `ports` 0.0007321834564209
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0002138614654541
(404) DESCRIBE `ports` 0.00074911117553711
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020384788513184
(406) DESCRIBE `sailingdates` 0.00065302848815918
(407) DESCRIBE `ports` 0.0010128021240234
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00031781196594238
(409) DESCRIBE `ports` 0.00084590911865234
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00021004676818848
(411) DESCRIBE `ports` 0.00069093704223633
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.0002748966217041
(413) DESCRIBE `ports` 0.00097012519836426
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00023794174194336
(415) DESCRIBE `ports` 0.00088310241699219
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00028800964355469
(417) DESCRIBE `ports` 0.00097107887268066
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00021505355834961
(419) DESCRIBE `ports` 0.00082588195800781
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00022101402282715
(421) DESCRIBE `ports` 0.00071597099304199
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019288063049316
(423) DESCRIBE `ports` 0.00068998336791992
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021195411682129
(425) DESCRIBE `ports` 0.00070405006408691
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020313262939453
(427) DESCRIBE `ports` 0.00072598457336426
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00027203559875488
(429) DESCRIBE `ports` 0.00096392631530762
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020408630371094
(431) DESCRIBE `ports` 0.00072503089904785
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 163))) 0.00021886825561523
(433) DESCRIBE `ports` 0.00067996978759766
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '163') 0.0001828670501709
(435) DESCRIBE `ports` 0.00068211555480957
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00030398368835449
(437) DESCRIBE `ports` 0.0010190010070801
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00021600723266602
(439) DESCRIBE `ports` 0.00072312355041504
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.00022697448730469
(441) DESCRIBE `ports` 0.00069499015808105
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00018978118896484
(443) DESCRIBE `ports` 0.0007319450378418
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00027894973754883
(445) DESCRIBE `ports` 0.00082612037658691
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.000244140625
(447) DESCRIBE `ports` 0.0009000301361084
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00025606155395508
(449) DESCRIBE `ports` 0.00092911720275879
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00023889541625977
(451) DESCRIBE `avid_specials` 0.00088882446289062
(452) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66917 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0015420913696289
(453) DESCRIBE `cruiselines` 0.0010941028594971
(454) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00026392936706543
(455) DESCRIBE `orchid_image` 0.00079703330993652
(456) DESCRIBE `cruiselines` 0.0012648105621338
(457) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00026893615722656
(458) DESCRIBE `cruises` 0.0018608570098877
(459) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66918') 0.00030183792114258
(460) DESCRIBE `ships` 0.0021731853485107
(461) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00042605400085449
(462) DESCRIBE `ships` 0.0023410320281982
(463) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00042200088500977
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023984909057617
(465) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023293495178223
(466) DESCRIBE `itineraries` 0.0012340545654297
(467) DESCRIBE `ports` 0.0011169910430908
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00034999847412109
(469) DESCRIBE `ports` 0.0010440349578857
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0002901554107666
(471) DESCRIBE `ports` 0.0010828971862793
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00026893615722656
(473) DESCRIBE `sailingdates` 0.00088310241699219
(474) DESCRIBE `ports` 0.0010459423065186
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00033092498779297
(476) DESCRIBE `ports` 0.0011060237884521
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.0002741813659668
(478) DESCRIBE `ports` 0.001054048538208
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00032305717468262
(480) DESCRIBE `ports` 0.0010988712310791
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00025296211242676
(482) DESCRIBE `ports` 0.0010190010070801
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.00027585029602051
(484) DESCRIBE `ports` 0.00097393989562988
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00024890899658203
(486) DESCRIBE `ports` 0.0010130405426025
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00029182434082031
(488) DESCRIBE `ports` 0.0010249614715576
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00025200843811035
(490) DESCRIBE `ports` 0.0010929107666016
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 163))) 0.00028395652770996
(492) DESCRIBE `ports` 0.001046895980835
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '163') 0.00028800964355469
(494) DESCRIBE `ports` 0.0009760856628418
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028014183044434
(496) DESCRIBE `ports` 0.0010230541229248
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025200843811035
(498) DESCRIBE `ports` 0.0010139942169189
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028491020202637
(500) DESCRIBE `ports` 0.00099682807922363
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00023984909057617
(502) DESCRIBE `ports` 0.001025915145874
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028705596923828
(504) DESCRIBE `ports` 0.0011308193206787
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00026202201843262
(506) DESCRIBE `ports` 0.0010149478912354
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00031495094299316
(508) DESCRIBE `ports` 0.00099396705627441
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00027108192443848
(510) DESCRIBE `ports` 0.0010368824005127
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029182434082031
(512) DESCRIBE `ports` 0.0010600090026855
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028586387634277
(514) DESCRIBE `avid_specials` 0.0010499954223633
(515) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66918 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0020787715911865
(516) DESCRIBE `cruiselines` 0.0017340183258057
(517) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00042581558227539
(518) DESCRIBE `orchid_image` 0.0013518333435059
(519) DESCRIBE `cruiselines` 0.0015158653259277
(520) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00029897689819336
(521) DESCRIBE `cruises` 0.0016500949859619
(522) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49111') 0.00025105476379395
(523) DESCRIBE `ships` 0.0013439655303955
(524) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00042581558227539
(525) DESCRIBE `ships` 0.0020709037780762
(526) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00029110908508301
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018692016601562
(528) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017404556274414
(529) DESCRIBE `itineraries` 0.00081419944763184
(530) DESCRIBE `ports` 0.0007789134979248
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.000244140625
(532) DESCRIBE `ports` 0.00071096420288086
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00022697448730469
(534) DESCRIBE `ports` 0.00090909004211426
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00024509429931641
(536) DESCRIBE `sailingdates` 0.00081801414489746
(537) DESCRIBE `ports` 0.00083708763122559
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026106834411621
(539) DESCRIBE `ports` 0.00087094306945801
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00020599365234375
(541) DESCRIBE `ports` 0.00089693069458008
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00022792816162109
(543) DESCRIBE `ports` 0.00072407722473145
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00020289421081543
(545) DESCRIBE `ports` 0.00069403648376465
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00022196769714355
(547) DESCRIBE `ports` 0.00072789192199707
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019502639770508
(549) DESCRIBE `ports` 0.00068807601928711
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0002131462097168
(551) DESCRIBE `ports` 0.00073409080505371
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019383430480957
(553) DESCRIBE `ports` 0.00072097778320312
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022196769714355
(555) DESCRIBE `ports` 0.00070500373840332
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002129077911377
(557) DESCRIBE `ports` 0.00070095062255859
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022411346435547
(559) DESCRIBE `ports` 0.00069499015808105
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019192695617676
(561) DESCRIBE `ports` 0.00074982643127441
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00027298927307129
(563) DESCRIBE `ports` 0.00088286399841309
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00024509429931641
(565) DESCRIBE `ports` 0.0010428428649902
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00030994415283203
(567) DESCRIBE `ports` 0.00099802017211914
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.0002138614654541
(569) DESCRIBE `ports` 0.00081300735473633
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0002288818359375
(571) DESCRIBE `ports` 0.00069594383239746
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00021004676818848
(573) DESCRIBE `ports` 0.00068497657775879
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00029397010803223
(575) DESCRIBE `ports` 0.00078511238098145
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00025606155395508
(577) DESCRIBE `ports` 0.00096893310546875
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00030112266540527
(579) DESCRIBE `ports` 0.00079202651977539
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00020599365234375
(581) DESCRIBE `ports` 0.00077104568481445
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00036501884460449
(583) DESCRIBE `ports` 0.0008549690246582
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00020098686218262
(585) DESCRIBE `ports` 0.00069999694824219
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00026297569274902
(587) DESCRIBE `ports` 0.00073003768920898
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020790100097656
(589) DESCRIBE `avid_specials` 0.00086688995361328
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49111 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.001629114151001
(591) DESCRIBE `cruiselines` 0.0010421276092529
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00032997131347656
(593) DESCRIBE `orchid_image` 0.00083088874816895
(594) DESCRIBE `cruiselines` 0.00095486640930176
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00022196769714355
(596) DESCRIBE `cruises` 0.0012772083282471
(597) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66916') 0.00023102760314941
(598) DESCRIBE `ships` 0.0014970302581787
(599) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00028800964355469
(600) DESCRIBE `ships` 0.0016059875488281
(601) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00022387504577637
(602) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018715858459473
(603) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017285346984863
(604) DESCRIBE `itineraries` 0.00075411796569824
(605) DESCRIBE `ports` 0.00090718269348145
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00025415420532227
(607) DESCRIBE `ports` 0.00067496299743652
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00020384788513184
(609) DESCRIBE `ports` 0.00067996978759766
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020313262939453
(611) DESCRIBE `sailingdates` 0.00061678886413574
(612) DESCRIBE `ports` 0.00076103210449219
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00024199485778809
(614) DESCRIBE `ports` 0.00069499015808105
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00024890899658203
(616) DESCRIBE `ports` 0.00072097778320312
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00022006034851074
(618) DESCRIBE `ports` 0.00070714950561523
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00024604797363281
(620) DESCRIBE `ports` 0.00088000297546387
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5458))) 0.00028109550476074
(622) DESCRIBE `ports` 0.00071382522583008
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5458') 0.00020384788513184
(624) DESCRIBE `ports` 0.00090479850769043
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3134))) 0.00026702880859375
(626) DESCRIBE `ports` 0.00098800659179688
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3134') 0.00028204917907715
(628) DESCRIBE `ports` 0.0010089874267578
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031399726867676
(630) DESCRIBE `ports` 0.00098490715026855
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0002601146697998
(632) DESCRIBE `ports` 0.0009918212890625
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00030183792114258
(634) DESCRIBE `ports` 0.0010418891906738
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00030684471130371
(636) DESCRIBE `ports` 0.0012900829315186
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0003659725189209
(638) DESCRIBE `ports` 0.00081300735473633
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00022602081298828
(640) DESCRIBE `ports` 0.00071811676025391
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031709671020508
(642) DESCRIBE `ports` 0.0010759830474854
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0002589225769043
(644) DESCRIBE `ports` 0.0010299682617188
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00022196769714355
(646) DESCRIBE `ports` 0.00069808959960938
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0001981258392334
(648) DESCRIBE `ports` 0.0007169246673584
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021719932556152
(650) DESCRIBE `ports` 0.00071001052856445
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019001960754395
(652) DESCRIBE `ports` 0.00067996978759766
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00022506713867188
(654) DESCRIBE `ports` 0.00068783760070801
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019001960754395
(656) DESCRIBE `ports` 0.00068211555480957
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00020980834960938
(658) DESCRIBE `ports` 0.00069117546081543
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00019383430480957
(660) DESCRIBE `ports` 0.00069117546081543
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00021696090698242
(662) DESCRIBE `ports` 0.00067782402038574
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00018095970153809
(664) DESCRIBE `avid_specials` 0.00063896179199219
(665) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66916 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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
(666) DESCRIBE `cruiselines` 0.00099587440490723
(667) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00022602081298828
(668) DESCRIBE `orchid_image` 0.00077104568481445
(669) DESCRIBE `cruiselines` 0.00096416473388672
(670) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.0001978874206543
(671) DESCRIBE `cruises` 0.0012869834899902
(672) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66919') 0.00022196769714355
(673) DESCRIBE `ships` 0.0013220310211182
(674) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.0002751350402832
(675) DESCRIBE `ships` 0.0013401508331299
(676) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00020408630371094
(677) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018501281738281
(678) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016999244689941
(679) DESCRIBE `itineraries` 0.00068998336791992
(680) DESCRIBE `ports` 0.00071406364440918
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023984909057617
(682) DESCRIBE `ports` 0.0006871223449707
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00020813941955566
(684) DESCRIBE `ports` 0.00068092346191406
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019192695617676
(686) DESCRIBE `sailingdates` 0.00064706802368164
(687) DESCRIBE `ports` 0.0007319450378418
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00026202201843262
(689) DESCRIBE `ports` 0.00089097023010254
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00021100044250488
(691) DESCRIBE `ports` 0.00095486640930176
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00021600723266602
(693) DESCRIBE `ports` 0.00069499015808105
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00019001960754395
(695) DESCRIBE `ports` 0.00071096420288086
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021195411682129
(697) DESCRIBE `ports` 0.00067996978759766
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018715858459473
(699) DESCRIBE `ports` 0.00077009201049805
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021100044250488
(701) DESCRIBE `ports` 0.00076007843017578
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019001960754395
(703) DESCRIBE `ports` 0.0006871223449707
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023198127746582
(705) DESCRIBE `ports` 0.00098490715026855
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002140998840332
(707) DESCRIBE `ports` 0.00071287155151367
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022602081298828
(709) DESCRIBE `ports` 0.00073003768920898
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020408630371094
(711) DESCRIBE `ports` 0.0006859302520752
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022006034851074
(713) DESCRIBE `ports` 0.00072407722473145
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023484230041504
(715) DESCRIBE `ports` 0.0010170936584473
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028610229492188
(717) DESCRIBE `ports` 0.00097513198852539
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023913383483887
(719) DESCRIBE `ports` 0.00095081329345703
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00026822090148926
(721) DESCRIBE `ports` 0.00073099136352539
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00018882751464844
(723) DESCRIBE `ports` 0.00067400932312012
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0002138614654541
(725) DESCRIBE `ports` 0.00067615509033203
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019192695617676
(727) DESCRIBE `ports` 0.00072789192199707
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00022506713867188
(729) DESCRIBE `ports` 0.00075292587280273
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00020289421081543
(731) DESCRIBE `ports` 0.00069904327392578
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00026106834411621
(733) DESCRIBE `ports` 0.00069284439086914
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00018906593322754
(735) DESCRIBE `ports` 0.00067496299743652
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.0002131462097168
(737) DESCRIBE `ports` 0.00071907043457031
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00019502639770508
(739) DESCRIBE `ports` 0.00069713592529297
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.0002129077911377
(741) DESCRIBE `ports` 0.00068402290344238
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.0001828670501709
(743) DESCRIBE `ports` 0.00071287155151367
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026512145996094
(745) DESCRIBE `ports` 0.00085282325744629
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026798248291016
(747) DESCRIBE `avid_specials` 0.00071501731872559
(748) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66919 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0010042190551758
(749) DESCRIBE `cruiselines` 0.0010459423065186
(750) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00027990341186523
(751) DESCRIBE `orchid_image` 0.00084400177001953
(752) DESCRIBE `cruiselines` 0.0010139942169189
(753) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00023293495178223
(754) DESCRIBE `ships` 0.0015361309051514
(755) SELECT `ships`.* FROM `ships` WHERE (id IN ('225')) ORDER BY FIND_IN_SET(id, '225') 0.00032997131347656
(756) DESCRIBE `cruisetypes` 0.00067305564880371
(757) DESCRIBE `cruiselines` 0.0010550022125244
(758) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00026106834411621
(759) DESCRIBE `destinations` 0.00091409683227539
(760) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00026893615722656
(761) DESCRIBE `destinations` 0.0011579990386963
(762) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00027084350585938
(763) DESCRIBE `cruiselines` 0.0014100074768066
(764) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00030708312988281