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

Total elapsed time: 0.30019855499268

# Query Time
(1) connect 0.00073981285095215
(2) DESCRIBE `cruises` 0.0022439956665039
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (43678, 63476, 73379, 66243, 63723, 63485, 63869, 67660, 43647, 63483)) ORDER BY FIND_IN_SET(id, '43678,63476,73379,66243,63723,63485,63869,67660,43647,63483') 0.0018060207366943
(4) DESCRIBE `cruises` 0.0021498203277588
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43678') 0.00046801567077637
(6) DESCRIBE `ships` 0.0023319721221924
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00046300888061523
(8) DESCRIBE `ships` 0.002072811126709
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.0003049373626709
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001988410949707
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(12) DESCRIBE `itineraries` 0.00098896026611328
(13) DESCRIBE `ports` 0.0011501312255859
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00033903121948242
(15) DESCRIBE `ports` 0.00088286399841309
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00024890899658203
(17) DESCRIBE `ports` 0.00083684921264648
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0002439022064209
(19) DESCRIBE `sailingdates` 0.00076985359191895
(20) DESCRIBE `ports` 0.00097799301147461
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00025486946105957
(22) DESCRIBE `ports` 0.0006721019744873
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018596649169922
(24) DESCRIBE `ports` 0.00063705444335938
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.0001988410949707
(26) DESCRIBE `ports` 0.00061702728271484
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00020599365234375
(28) DESCRIBE `ports` 0.00063896179199219
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00017905235290527
(30) DESCRIBE `ports` 0.00058388710021973
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00015997886657715
(32) DESCRIBE `ports` 0.00058412551879883
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00018215179443359
(34) DESCRIBE `ports` 0.00058794021606445
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00016403198242188
(36) DESCRIBE `ports` 0.00059390068054199
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00018310546875
(38) DESCRIBE `ports` 0.00058293342590332
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00016617774963379
(40) DESCRIBE `ports` 0.00058889389038086
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00017380714416504
(42) DESCRIBE `ports` 0.00058603286743164
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00015783309936523
(44) DESCRIBE `ports` 0.00058579444885254
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00016880035400391
(46) DESCRIBE `ports` 0.0006248950958252
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00020313262939453
(48) DESCRIBE `ports` 0.0005948543548584
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00022292137145996
(50) DESCRIBE `ports` 0.00058794021606445
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00016093254089355
(52) DESCRIBE `avid_specials` 0.00054693222045898
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43678 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011501312255859
(54) DESCRIBE `cruiselines` 0.0014379024505615
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032687187194824
(56) DESCRIBE `orchid_image` 0.0011661052703857
(57) DESCRIBE `cruiselines` 0.0012969970703125
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00023198127746582
(59) DESCRIBE `cruises` 0.0014450550079346
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63476') 0.00022006034851074
(61) DESCRIBE `ships` 0.0012481212615967
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00023603439331055
(63) DESCRIBE `ships` 0.0012009143829346
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00019598007202148
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(67) DESCRIBE `itineraries` 0.00063490867614746
(68) DESCRIBE `ports` 0.00074386596679688
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00027585029602051
(70) DESCRIBE `ports` 0.00094413757324219
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00023794174194336
(72) DESCRIBE `ports` 0.00088000297546387
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00024604797363281
(74) DESCRIBE `sailingdates` 0.00083708763122559
(75) DESCRIBE `ports` 0.0010838508605957
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00029206275939941
(77) DESCRIBE `ports` 0.00089001655578613
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0002589225769043
(79) DESCRIBE `ports` 0.00089001655578613
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00026607513427734
(81) DESCRIBE `ports` 0.00089001655578613
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00028800964355469
(83) DESCRIBE `ports` 0.00091814994812012
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00028109550476074
(85) DESCRIBE `ports` 0.00091409683227539
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00023198127746582
(87) DESCRIBE `ports` 0.00086808204650879
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00025200843811035
(89) DESCRIBE `ports` 0.00089597702026367
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00017714500427246
(91) DESCRIBE `ports` 0.00060296058654785
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00018692016601562
(93) DESCRIBE `ports` 0.00066900253295898
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019097328186035
(95) DESCRIBE `ports` 0.00068497657775879
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020313262939453
(97) DESCRIBE `ports` 0.00063490867614746
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00017809867858887
(99) DESCRIBE `avid_specials` 0.00060606002807617
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63476 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0010120868682861
(101) DESCRIBE `cruiselines` 0.00098896026611328
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023412704467773
(103) DESCRIBE `orchid_image` 0.00082492828369141
(104) DESCRIBE `cruiselines` 0.00085115432739258
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017809867858887
(106) DESCRIBE `cruises` 0.0012350082397461
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73379') 0.00019693374633789
(108) DESCRIBE `ships` 0.0012412071228027
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1193))) 0.00025701522827148
(110) DESCRIBE `ships` 0.001270055770874
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1193') 0.00018119812011719
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015807151794434
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014805793762207
(114) DESCRIBE `itineraries` 0.00063896179199219
(115) DESCRIBE `ports` 0.00063204765319824
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020790100097656
(117) DESCRIBE `ports` 0.00059795379638672
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020194053649902
(119) DESCRIBE `ports` 0.00061416625976562
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017309188842773
(121) DESCRIBE `sailingdates` 0.0005500316619873
(122) DESCRIBE `ports` 0.00066590309143066
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00038290023803711
(124) DESCRIBE `ports` 0.00078606605529785
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020098686218262
(126) DESCRIBE `ports` 0.00066304206848145
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00019288063049316
(128) DESCRIBE `ports` 0.00065207481384277
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00017786026000977
(130) DESCRIBE `ports` 0.00060391426086426
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00025486946105957
(132) DESCRIBE `ports` 0.00091695785522461
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018906593322754
(134) DESCRIBE `ports` 0.00065088272094727
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00023794174194336
(136) DESCRIBE `ports` 0.00066685676574707
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00022411346435547
(138) DESCRIBE `ports` 0.00084400177001953
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00026297569274902
(140) DESCRIBE `ports` 0.00064802169799805
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018095970153809
(142) DESCRIBE `ports` 0.0005950927734375
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001990795135498
(144) DESCRIBE `ports` 0.0006709098815918
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018501281738281
(146) DESCRIBE `avid_specials` 0.00075793266296387
(147) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73379 and class = 'Cruise') OR (item_id = 1193 AND class = 'Ship') OR (item_id = 20 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.0013859272003174
(148) DESCRIBE `cruiselines` 0.001270055770874
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00031089782714844
(150) DESCRIBE `orchid_image` 0.00097990036010742
(151) DESCRIBE `cruiselines` 0.0011289119720459
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00025105476379395
(153) DESCRIBE `cruises` 0.0013489723205566
(154) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66243') 0.00025796890258789
(155) DESCRIBE `ships` 0.0012791156768799
(156) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 212))) 0.00024890899658203
(157) DESCRIBE `ships` 0.0012760162353516
(158) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '212') 0.00019693374633789
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016093254089355
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014901161193848
(161) DESCRIBE `itineraries` 0.00063705444335938
(162) DESCRIBE `ports` 0.00092291831970215
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00024795532226562
(164) DESCRIBE `ports` 0.00067496299743652
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00020313262939453
(166) DESCRIBE `ports` 0.00064492225646973
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00017786026000977
(168) DESCRIBE `sailingdates` 0.00059604644775391
(169) DESCRIBE `ports` 0.0009610652923584
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00027608871459961
(171) DESCRIBE `ports` 0.00079798698425293
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00024318695068359
(173) DESCRIBE `ports` 0.00063204765319824
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00020503997802734
(175) DESCRIBE `ports` 0.00067687034606934
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00017905235290527
(177) DESCRIBE `ports` 0.0006098747253418
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00019502639770508
(179) DESCRIBE `ports` 0.00060296058654785
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00017094612121582
(181) DESCRIBE `ports` 0.00063800811767578
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00018692016601562
(183) DESCRIBE `ports` 0.00063991546630859
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00022101402282715
(185) DESCRIBE `ports` 0.00078988075256348
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00024294853210449
(187) DESCRIBE `ports` 0.00090980529785156
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00022482872009277
(189) DESCRIBE `ports` 0.00080394744873047
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00020790100097656
(191) DESCRIBE `ports` 0.00064611434936523
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00017595291137695
(193) DESCRIBE `ports` 0.00059914588928223
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00019121170043945
(195) DESCRIBE `ports` 0.00059103965759277
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00016617774963379
(197) DESCRIBE `ports` 0.00059199333190918
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00018310546875
(199) DESCRIBE `ports` 0.00064706802368164
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00016307830810547
(201) DESCRIBE `ports` 0.00060009956359863
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00019288063049316
(203) DESCRIBE `ports` 0.00066113471984863
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.0001981258392334
(205) DESCRIBE `ports` 0.00059390068054199
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00018596649169922
(207) DESCRIBE `ports` 0.00059390068054199
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00016403198242188
(209) DESCRIBE `ports` 0.00061702728271484
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00018095970153809
(211) DESCRIBE `ports` 0.00058603286743164
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00016188621520996
(213) DESCRIBE `ports` 0.00064206123352051
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00021910667419434
(215) DESCRIBE `ports` 0.00059890747070312
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00017189979553223
(217) DESCRIBE `ports` 0.00060319900512695
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00019598007202148
(219) DESCRIBE `ports` 0.00060606002807617
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018906593322754
(221) DESCRIBE `avid_specials` 0.00069999694824219
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66243 and class = 'Cruise') OR (item_id = 212 AND class = 'Ship') OR (item_id = 20 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.0016350746154785
(223) DESCRIBE `cruiselines` 0.0013570785522461
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00029993057250977
(225) DESCRIBE `orchid_image` 0.00094103813171387
(226) DESCRIBE `cruiselines` 0.0011398792266846
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00023794174194336
(228) DESCRIBE `cruises` 0.0021049976348877
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63723') 0.00031399726867676
(230) DESCRIBE `ships` 0.0019769668579102
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00038886070251465
(232) DESCRIBE `ships` 0.0020220279693604
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00029182434082031
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021791458129883
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021219253540039
(236) DESCRIBE `itineraries` 0.0010199546813965
(237) DESCRIBE `ports` 0.0010089874267578
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029492378234863
(239) DESCRIBE `ports` 0.00088191032409668
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023412704467773
(241) DESCRIBE `ports` 0.00087094306945801
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021004676818848
(243) DESCRIBE `sailingdates` 0.00061488151550293
(244) DESCRIBE `ports` 0.00070500373840332
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023293495178223
(246) DESCRIBE `ports` 0.00072908401489258
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021100044250488
(248) DESCRIBE `ports` 0.00071811676025391
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2168))) 0.00024008750915527
(250) DESCRIBE `ports` 0.00070095062255859
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2168') 0.00017499923706055
(252) DESCRIBE `ports` 0.00067305564880371
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00026607513427734
(254) DESCRIBE `ports` 0.00072312355041504
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00018692016601562
(256) DESCRIBE `ports` 0.00059914588928223
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0001981258392334
(258) DESCRIBE `ports` 0.00063300132751465
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00017213821411133
(260) DESCRIBE `ports` 0.00060606002807617
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00017905235290527
(262) DESCRIBE `ports` 0.00065517425537109
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00016188621520996
(264) DESCRIBE `ports` 0.00060796737670898
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00020408630371094
(266) DESCRIBE `ports` 0.00061607360839844
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00016903877258301
(268) DESCRIBE `ports` 0.00059199333190918
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00019192695617676
(270) DESCRIBE `ports` 0.00063109397888184
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00018215179443359
(272) DESCRIBE `ports` 0.00065398216247559
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00018501281738281
(274) DESCRIBE `ports` 0.00058794021606445
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00016188621520996
(276) DESCRIBE `avid_specials` 0.0006110668182373
(277) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63723 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 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.00093698501586914
(278) DESCRIBE `cruiselines` 0.00087118148803711
(279) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0001990795135498
(280) DESCRIBE `orchid_image` 0.00067996978759766
(281) DESCRIBE `cruiselines` 0.00083708763122559
(282) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018095970153809
(283) DESCRIBE `cruises` 0.0012531280517578
(284) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63485') 0.0002131462097168
(285) DESCRIBE `ships` 0.0011940002441406
(286) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1088))) 0.00023913383483887
(287) DESCRIBE `ships` 0.0012381076812744
(288) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1088') 0.00018906593322754
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015997886657715
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015115737915039
(291) DESCRIBE `itineraries` 0.00064206123352051
(292) DESCRIBE `ports` 0.00068783760070801
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00027799606323242
(294) DESCRIBE `ports` 0.00067806243896484
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020098686218262
(296) DESCRIBE `ports` 0.00067901611328125
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00021004676818848
(298) DESCRIBE `sailingdates` 0.00056600570678711
(299) DESCRIBE `ports` 0.00095510482788086
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00027108192443848
(301) DESCRIBE `ports` 0.00062704086303711
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018310546875
(303) DESCRIBE `ports` 0.00060296058654785
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0001990795135498
(305) DESCRIBE `ports` 0.00063300132751465
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00016999244689941
(307) DESCRIBE `ports` 0.00063991546630859
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00020909309387207
(309) DESCRIBE `ports` 0.00059890747070312
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00020408630371094
(311) DESCRIBE `ports` 0.00068402290344238
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00020313262939453
(313) DESCRIBE `ports` 0.0007171630859375
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018692016601562
(315) DESCRIBE `ports` 0.00071287155151367
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0001978874206543
(317) DESCRIBE `ports` 0.000762939453125
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00024294853210449
(319) DESCRIBE `ports` 0.0011570453643799
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00028896331787109
(321) DESCRIBE `ports` 0.0008549690246582
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00025486946105957
(323) DESCRIBE `avid_specials` 0.0008389949798584
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63485 and class = 'Cruise') OR (item_id = 1088 AND class = 'Ship') OR (item_id = 20 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.0015139579772949
(325) DESCRIBE `cruiselines` 0.0013630390167236
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030708312988281
(327) DESCRIBE `orchid_image` 0.0011000633239746
(328) DESCRIBE `cruiselines` 0.0013880729675293
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027108192443848
(330) DESCRIBE `cruises` 0.0015959739685059
(331) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63869') 0.00025510787963867
(332) DESCRIBE `ships` 0.0012848377227783
(333) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 574))) 0.0002748966217041
(334) DESCRIBE `ships` 0.0012879371643066
(335) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '574') 0.00018906593322754
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014901161193848
(338) DESCRIBE `itineraries` 0.00066399574279785
(339) DESCRIBE `ports` 0.00064706802368164
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00021004676818848
(341) DESCRIBE `ports` 0.00060105323791504
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00018715858459473
(343) DESCRIBE `ports` 0.0006248950958252
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00017285346984863
(345) DESCRIBE `sailingdates` 0.00053787231445312
(346) DESCRIBE `ports` 0.00093197822570801
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029897689819336
(348) DESCRIBE `ports` 0.00080609321594238
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0001838207244873
(350) DESCRIBE `ports` 0.00058913230895996
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00019001960754395
(352) DESCRIBE `ports` 0.00068211555480957
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017404556274414
(354) DESCRIBE `ports` 0.0006110668182373
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00018692016601562
(356) DESCRIBE `ports` 0.00059890747070312
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00017118453979492
(358) DESCRIBE `ports` 0.00066685676574707
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00023293495178223
(360) DESCRIBE `ports` 0.00067615509033203
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00017499923706055
(362) DESCRIBE `ports` 0.00062298774719238
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0001838207244873
(364) DESCRIBE `ports` 0.00066399574279785
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018405914306641
(366) DESCRIBE `ports` 0.00061893463134766
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00019502639770508
(368) DESCRIBE `ports` 0.00064706802368164
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0001990795135498
(370) DESCRIBE `avid_specials` 0.00059890747070312
(371) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63869 and class = 'Cruise') OR (item_id = 574 AND class = 'Ship') OR (item_id = 20 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.00087380409240723
(372) DESCRIBE `cruiselines` 0.00090909004211426
(373) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002439022064209
(374) DESCRIBE `orchid_image` 0.00081419944763184
(375) DESCRIBE `cruiselines` 0.001007080078125
(376) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00023794174194336
(377) DESCRIBE `cruises` 0.0014019012451172
(378) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67660') 0.00034594535827637
(379) DESCRIBE `ships` 0.0016348361968994
(380) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00030279159545898
(381) DESCRIBE `ships` 0.0013461112976074
(382) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00017881393432617
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015902519226074
(384) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014901161193848
(385) DESCRIBE `itineraries` 0.00061392784118652
(386) DESCRIBE `ports` 0.00069594383239746
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00021219253540039
(388) DESCRIBE `ports` 0.00060105323791504
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00017881393432617
(390) DESCRIBE `ports` 0.00063896179199219
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00019311904907227
(392) DESCRIBE `sailingdates` 0.00053501129150391
(393) DESCRIBE `ports` 0.00077915191650391
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00022506713867188
(395) DESCRIBE `ports` 0.0006260871887207
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00017404556274414
(397) DESCRIBE `ports` 0.00059318542480469
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00018501281738281
(399) DESCRIBE `ports` 0.00059795379638672
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00016689300537109
(401) DESCRIBE `ports` 0.00060009956359863
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00018715858459473
(403) DESCRIBE `ports` 0.00058794021606445
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00016593933105469
(405) DESCRIBE `ports` 0.00059080123901367
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00020408630371094
(407) DESCRIBE `ports` 0.00064992904663086
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00017094612121582
(409) DESCRIBE `ports` 0.00059700012207031
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 685))) 0.00018811225891113
(411) DESCRIBE `ports` 0.00060510635375977
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '685') 0.00019478797912598
(413) DESCRIBE `ports` 0.00076389312744141
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00018787384033203
(415) DESCRIBE `ports` 0.00060796737670898
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00018000602722168
(417) DESCRIBE `ports` 0.0006108283996582
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00021481513977051
(419) DESCRIBE `ports` 0.0006411075592041
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00016999244689941
(421) DESCRIBE `ports` 0.00063800811767578
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00022006034851074
(423) DESCRIBE `ports` 0.00067806243896484
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00016999244689941
(425) DESCRIBE `avid_specials` 0.00066304206848145
(426) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67660 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 28 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.00084495544433594
(427) DESCRIBE `cruiselines` 0.00085711479187012
(428) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002138614654541
(429) DESCRIBE `orchid_image` 0.00072312355041504
(430) DESCRIBE `cruiselines` 0.00086784362792969
(431) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019383430480957
(432) DESCRIBE `cruises` 0.0013551712036133
(433) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43647') 0.00038719177246094
(434) DESCRIBE `ships` 0.0021510124206543
(435) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00033092498779297
(436) DESCRIBE `ships` 0.0020689964294434
(437) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.0003209114074707
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001981258392334
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(440) DESCRIBE `itineraries` 0.0011038780212402
(441) DESCRIBE `ports` 0.0010180473327637
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003049373626709
(443) DESCRIBE `ports` 0.00080204010009766
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002288818359375
(445) DESCRIBE `ports` 0.00080108642578125
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00023198127746582
(447) DESCRIBE `sailingdates` 0.00081491470336914
(448) DESCRIBE `ports` 0.0013759136199951
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030899047851562
(450) DESCRIBE `ports` 0.00086712837219238
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00025391578674316
(452) DESCRIBE `ports` 0.00095200538635254
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2559))) 0.00026798248291016
(454) DESCRIBE `ports` 0.0008091926574707
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2559') 0.00022101402282715
(456) DESCRIBE `ports` 0.00088715553283691
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0002601146697998
(458) DESCRIBE `ports` 0.00089812278747559
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00023984909057617
(460) DESCRIBE `ports` 0.00094819068908691
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00028204917907715
(462) DESCRIBE `ports` 0.00082302093505859
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00022006034851074
(464) DESCRIBE `ports` 0.00084495544433594
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00026512145996094
(466) DESCRIBE `ports` 0.00087594985961914
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00023388862609863
(468) DESCRIBE `avid_specials` 0.00082492828369141
(469) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43647 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.0015060901641846
(470) DESCRIBE `cruiselines` 0.0014588832855225
(471) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00037407875061035
(472) DESCRIBE `orchid_image` 0.0011417865753174
(473) DESCRIBE `cruiselines` 0.0014059543609619
(474) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027012825012207
(475) DESCRIBE `cruises` 0.0023410320281982
(476) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63483') 0.00033020973205566
(477) DESCRIBE `ships` 0.0018410682678223
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 626))) 0.00026297569274902
(479) DESCRIBE `ships` 0.0012722015380859
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '626') 0.00021696090698242
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(483) DESCRIBE `itineraries` 0.00065398216247559
(484) DESCRIBE `ports` 0.00066089630126953
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0002138614654541
(486) DESCRIBE `ports` 0.00063896179199219
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00018596649169922
(488) DESCRIBE `ports` 0.00061488151550293
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00018000602722168
(490) DESCRIBE `sailingdates` 0.00054121017456055
(491) DESCRIBE `ports` 0.00060796737670898
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00020718574523926
(493) DESCRIBE `ports` 0.00062894821166992
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00016999244689941
(495) DESCRIBE `ports` 0.00058197975158691
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018596649169922
(497) DESCRIBE `ports` 0.00058913230895996
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016188621520996
(499) DESCRIBE `ports` 0.00059008598327637
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00019192695617676
(501) DESCRIBE `ports` 0.00061702728271484
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00020098686218262
(503) DESCRIBE `ports` 0.00059294700622559
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00019478797912598
(505) DESCRIBE `ports` 0.00060510635375977
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00016617774963379
(507) DESCRIBE `ports` 0.00060796737670898
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00022101402282715
(509) DESCRIBE `ports` 0.00059604644775391
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00016689300537109
(511) DESCRIBE `ports` 0.00059103965759277
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.0001828670501709
(513) DESCRIBE `ports` 0.00060892105102539
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00018715858459473
(515) DESCRIBE `ports` 0.00059914588928223
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00021195411682129
(517) DESCRIBE `ports` 0.00060701370239258
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00016498565673828
(519) DESCRIBE `avid_specials` 0.0006709098815918
(520) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63483 and class = 'Cruise') OR (item_id = 626 AND class = 'Ship') OR (item_id = 20 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.0008847713470459
(521) DESCRIBE `cruiselines` 0.0009160041809082
(522) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020503997802734
(523) DESCRIBE `orchid_image` 0.00073790550231934
(524) DESCRIBE `cruiselines` 0.00082302093505859
(525) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018191337585449
(526) DESCRIBE `ships` 0.0016770362854004
(527) SELECT `ships`.* FROM `ships` WHERE (id IN ('770', '405', '1193', '404', '1008', '1088', '93', '314', '574', '212', '626', '1569', '485', '665', '448')) ORDER BY FIND_IN_SET(id, '770,405,1193,404,1008,1088,93,314,574,212,626,1569,485,665,448') 0.00077104568481445
(528) DESCRIBE `cruisetypes` 0.00069594383239746
(529) DESCRIBE `destinations` 0.00082588195800781
(530) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '22', '2', '10', '29', '28', '48', '26', '53', '11', '37', '38', '25', '35', '43', '8', '21', '34')) ORDER BY FIND_IN_SET(id, '12,9,22,2,10,29,28,48,26,53,11,37,38,25,35,43,8,21,34') 0.00071191787719727
(531) DESCRIBE `cruiselines` 0.00095510482788086
(532) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002291202545166
(533) DESCRIBE `cruiselines` 0.0011780261993408
(534) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023484230041504