or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  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: 882

Total elapsed time: 0.61323618888855

# Query Time
(1) connect 0.001884937286377
(2) DESCRIBE `cruises` 0.0019969940185547
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71154, 61130, 61951, 61952, 61953, 61131, 67024, 69031, 61954, 72604)) ORDER BY FIND_IN_SET(id, '71154,61130,61951,61952,61953,61131,67024,69031,61954,72604') 0.0020649433135986
(4) DESCRIBE `cruises` 0.0021259784698486
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.00034117698669434
(6) DESCRIBE `ships` 0.0018980503082275
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00036001205444336
(8) DESCRIBE `ships` 0.0017578601837158
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00031399726867676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019288063049316
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018095970153809
(12) DESCRIBE `itineraries` 0.00094509124755859
(13) DESCRIBE `ports` 0.0011420249938965
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003199577331543
(15) DESCRIBE `ports` 0.001011848449707
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0002751350402832
(17) DESCRIBE `ports` 0.00095009803771973
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00022792816162109
(19) DESCRIBE `sailingdates` 0.00072002410888672
(20) DESCRIBE `ports` 0.001427173614502
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040197372436523
(22) DESCRIBE `ports` 0.0010731220245361
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00029492378234863
(24) DESCRIBE `ports` 0.00089907646179199
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00026822090148926
(26) DESCRIBE `ports` 0.00088381767272949
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00023913383483887
(28) DESCRIBE `avid_specials` 0.00080204010009766
(29) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014128684997559
(30) DESCRIBE `cruiselines` 0.0013420581817627
(31) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00029397010803223
(32) DESCRIBE `orchid_image` 0.0009911060333252
(33) DESCRIBE `cruiselines` 0.0013179779052734
(34) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00026702880859375
(35) DESCRIBE `cruises` 0.0018620491027832
(36) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61130') 0.00035905838012695
(37) DESCRIBE `ships` 0.0017850399017334
(38) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0003960132598877
(39) DESCRIBE `ships` 0.0017580986022949
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00027108192443848
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019288063049316
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018596649169922
(43) DESCRIBE `itineraries` 0.0009150505065918
(44) DESCRIBE `ports` 0.0012621879577637
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033092498779297
(46) DESCRIBE `ports` 0.00097203254699707
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00026512145996094
(48) DESCRIBE `ports` 0.00096893310546875
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00025296211242676
(50) DESCRIBE `sailingdates` 0.00084114074707031
(51) DESCRIBE `ports` 0.00088691711425781
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028014183044434
(53) DESCRIBE `ports` 0.00081491470336914
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00022101402282715
(55) DESCRIBE `ports` 0.00080108642578125
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00025796890258789
(57) DESCRIBE `ports` 0.00087594985961914
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00024104118347168
(59) DESCRIBE `ports` 0.00082302093505859
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027203559875488
(61) DESCRIBE `ports` 0.00082182884216309
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002291202545166
(63) DESCRIBE `ports` 0.0008549690246582
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024294853210449
(65) DESCRIBE `ports` 0.00079894065856934
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002138614654541
(67) DESCRIBE `ports` 0.00082206726074219
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00023818016052246
(69) DESCRIBE `ports` 0.0007939338684082
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00022315979003906
(71) DESCRIBE `ports` 0.0009009838104248
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00027108192443848
(73) DESCRIBE `ports` 0.00094294548034668
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002439022064209
(75) DESCRIBE `ports` 0.00094079971313477
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00026917457580566
(77) DESCRIBE `ports` 0.00082898139953613
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00022292137145996
(79) DESCRIBE `ports` 0.00089097023010254
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00025510787963867
(81) DESCRIBE `ports` 0.00084710121154785
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00022101402282715
(83) DESCRIBE `ports` 0.00089287757873535
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00026512145996094
(85) DESCRIBE `ports` 0.00083088874816895
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0002291202545166
(87) DESCRIBE `ports` 0.00088596343994141
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00024104118347168
(89) DESCRIBE `ports` 0.00086688995361328
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00024008750915527
(91) DESCRIBE `ports` 0.00087594985961914
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00026607513427734
(93) DESCRIBE `ports` 0.00086498260498047
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00024080276489258
(95) DESCRIBE `ports` 0.00091719627380371
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00028204917907715
(97) DESCRIBE `ports` 0.0008690357208252
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.0002281665802002
(99) DESCRIBE `ports` 0.0008552074432373
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00032997131347656
(101) DESCRIBE `ports` 0.00095987319946289
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00030708312988281
(103) DESCRIBE `ports` 0.00091290473937988
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00028705596923828
(105) DESCRIBE `ports` 0.00087404251098633
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00022196769714355
(107) DESCRIBE `ports` 0.00090408325195312
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00028109550476074
(109) DESCRIBE `ports` 0.00089597702026367
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00022578239440918
(111) DESCRIBE `ports` 0.0008699893951416
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00024199485778809
(113) DESCRIBE `ports` 0.00089097023010254
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00024104118347168
(115) DESCRIBE `ports` 0.00087308883666992
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00027012825012207
(117) DESCRIBE `ports` 0.00091791152954102
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00025200843811035
(119) DESCRIBE `ports` 0.00089097023010254
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0003058910369873
(121) DESCRIBE `ports` 0.0010199546813965
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00027203559875488
(123) DESCRIBE `ports` 0.00088691711425781
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028419494628906
(125) DESCRIBE `ports` 0.00095701217651367
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00028300285339355
(127) DESCRIBE `ports` 0.00092101097106934
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00028610229492188
(129) DESCRIBE `ports` 0.00087308883666992
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00024914741516113
(131) DESCRIBE `ports` 0.00089001655578613
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00031900405883789
(133) DESCRIBE `ports` 0.00089907646179199
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00023913383483887
(135) DESCRIBE `ports` 0.0009000301361084
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00032806396484375
(137) DESCRIBE `ports` 0.00098490715026855
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.0002751350402832
(139) DESCRIBE `ports` 0.00086307525634766
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 633))) 0.00027084350585938
(141) DESCRIBE `ports` 0.00087404251098633
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '633') 0.00024795532226562
(143) DESCRIBE `ports` 0.00085592269897461
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1154))) 0.0002901554107666
(145) DESCRIBE `ports` 0.00090599060058594
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1154') 0.00024008750915527
(147) DESCRIBE `ports` 0.00085115432739258
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2594))) 0.00025582313537598
(149) DESCRIBE `ports` 0.00088381767272949
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2594') 0.00025796890258789
(151) DESCRIBE `ports` 0.00093293190002441
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 802))) 0.00028014183044434
(153) DESCRIBE `ports` 0.00084781646728516
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '802') 0.00023412704467773
(155) DESCRIBE `ports` 0.00089788436889648
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00028586387634277
(157) DESCRIBE `ports` 0.00092601776123047
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00025320053100586
(159) DESCRIBE `ports` 0.00093197822570801
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.0003049373626709
(161) DESCRIBE `ports` 0.00094389915466309
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00026702880859375
(163) DESCRIBE `ports` 0.00091218948364258
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 64))) 0.00028085708618164
(165) DESCRIBE `ports` 0.00088787078857422
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '64') 0.00027012825012207
(167) DESCRIBE `ports` 0.00089502334594727
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1170))) 0.0002901554107666
(169) DESCRIBE `ports` 0.00091409683227539
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1170') 0.00031590461730957
(171) DESCRIBE `ports` 0.00093817710876465
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00028109550476074
(173) DESCRIBE `ports` 0.00087594985961914
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00024795532226562
(175) DESCRIBE `ports` 0.00086307525634766
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00026702880859375
(177) DESCRIBE `ports` 0.0009000301361084
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00022792816162109
(179) DESCRIBE `avid_specials` 0.00079488754272461
(180) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61130 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 40 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.0014560222625732
(181) DESCRIBE `cruiselines` 0.0014159679412842
(182) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0003361701965332
(183) DESCRIBE `orchid_image` 0.001086950302124
(184) DESCRIBE `cruiselines` 0.0013711452484131
(185) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00029611587524414
(186) DESCRIBE `cruises` 0.001910924911499
(187) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61951') 0.0003349781036377
(188) DESCRIBE `ships` 0.0018529891967773
(189) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00042295455932617
(190) DESCRIBE `ships` 0.0018138885498047
(191) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.00033712387084961
(192) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019693374633789
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(194) DESCRIBE `itineraries` 0.00093197822570801
(195) DESCRIBE `ports` 0.0011520385742188
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030899047851562
(197) DESCRIBE `ports` 0.00092911720275879
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027203559875488
(199) DESCRIBE `ports` 0.00090193748474121
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024700164794922
(201) DESCRIBE `sailingdates` 0.00078296661376953
(202) DESCRIBE `ports` 0.0010709762573242
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003349781036377
(204) DESCRIBE `ports` 0.0008389949798584
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026392936706543
(206) DESCRIBE `ports` 0.00081801414489746
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026488304138184
(208) DESCRIBE `ports` 0.00068402290344238
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019097328186035
(210) DESCRIBE `ports` 0.00070095062255859
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020408630371094
(212) DESCRIBE `ports` 0.00094890594482422
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026917457580566
(214) DESCRIBE `ports` 0.00095605850219727
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00024795532226562
(216) DESCRIBE `ports` 0.00077700614929199
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00018692016601562
(218) DESCRIBE `ports` 0.00063395500183105
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00020909309387207
(220) DESCRIBE `ports` 0.00067615509033203
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00023102760314941
(222) DESCRIBE `ports` 0.00094890594482422
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00035190582275391
(224) DESCRIBE `ports` 0.00081110000610352
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.0001990795135498
(226) DESCRIBE `ports` 0.00078392028808594
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00023198127746582
(228) DESCRIBE `ports` 0.0007178783416748
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0002129077911377
(230) DESCRIBE `ports` 0.00064611434936523
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026488304138184
(232) DESCRIBE `ports` 0.00078201293945312
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0001990795135498
(234) DESCRIBE `ports` 0.00076103210449219
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00027012825012207
(236) DESCRIBE `ports` 0.0009307861328125
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00024890899658203
(238) DESCRIBE `ports` 0.00091099739074707
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00027894973754883
(240) DESCRIBE `ports` 0.00093698501586914
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00025796890258789
(242) DESCRIBE `ports` 0.00093317031860352
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00027203559875488
(244) DESCRIBE `ports` 0.00065112113952637
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018787384033203
(246) DESCRIBE `ports` 0.0005950927734375
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019502639770508
(248) DESCRIBE `ports` 0.00077009201049805
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017404556274414
(250) DESCRIBE `ports` 0.00060391426086426
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021195411682129
(252) DESCRIBE `ports` 0.00060510635375977
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0001671314239502
(254) DESCRIBE `ports` 0.00066804885864258
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00020790100097656
(256) DESCRIBE `ports` 0.00064396858215332
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00017905235290527
(258) DESCRIBE `ports` 0.00064301490783691
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00024294853210449
(260) DESCRIBE `ports` 0.00066089630126953
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00017380714416504
(262) DESCRIBE `ports` 0.00062298774719238
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00019598007202148
(264) DESCRIBE `ports` 0.00062704086303711
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00023889541625977
(266) DESCRIBE `ports` 0.00060796737670898
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 812))) 0.00019598007202148
(268) DESCRIBE `ports` 0.00069499015808105
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '812') 0.00019001960754395
(270) DESCRIBE `ports` 0.00074410438537598
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00019407272338867
(272) DESCRIBE `ports` 0.00085806846618652
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00022196769714355
(274) DESCRIBE `ports` 0.00089311599731445
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00021505355834961
(276) DESCRIBE `ports` 0.00073885917663574
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00017809867858887
(278) DESCRIBE `ports` 0.00066304206848145
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00022792816162109
(280) DESCRIBE `ports` 0.00096797943115234
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00024890899658203
(282) DESCRIBE `ports` 0.00094294548034668
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00028395652770996
(284) DESCRIBE `ports` 0.0010101795196533
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00027894973754883
(286) DESCRIBE `ports` 0.00095605850219727
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00031709671020508
(288) DESCRIBE `ports` 0.00093984603881836
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00025701522827148
(290) DESCRIBE `ports` 0.00095200538635254
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2969))) 0.00029492378234863
(292) DESCRIBE `ports` 0.00097203254699707
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2969') 0.00036501884460449
(294) DESCRIBE `ports` 0.00097894668579102
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2969))) 0.00029492378234863
(296) DESCRIBE `ports` 0.0010650157928467
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2969') 0.00031304359436035
(298) DESCRIBE `ports` 0.00088882446289062
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00027799606323242
(300) DESCRIBE `ports` 0.0010039806365967
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00027608871459961
(302) DESCRIBE `ports` 0.0010170936584473
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4224))) 0.00033092498779297
(304) DESCRIBE `ports` 0.0010020732879639
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4224') 0.00025606155395508
(306) DESCRIBE `ports` 0.00086283683776855
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031089782714844
(308) DESCRIBE `ports` 0.0010230541229248
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002589225769043
(310) DESCRIBE `ports` 0.0010750293731689
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00026106834411621
(312) DESCRIBE `ports` 0.0010569095611572
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00029587745666504
(314) DESCRIBE `ports` 0.0010139942169189
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031495094299316
(316) DESCRIBE `ports` 0.0010099411010742
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00029897689819336
(318) DESCRIBE `avid_specials` 0.00099086761474609
(319) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61951 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 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.0015039443969727
(320) DESCRIBE `cruiselines` 0.0014150142669678
(321) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00037598609924316
(322) DESCRIBE `orchid_image` 0.0010530948638916
(323) DESCRIBE `cruiselines` 0.0011861324310303
(324) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00026202201843262
(325) DESCRIBE `cruises` 0.001460075378418
(326) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61952') 0.00024700164794922
(327) DESCRIBE `ships` 0.0011839866638184
(328) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00040102005004883
(329) DESCRIBE `ships` 0.0019049644470215
(330) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.00026392936706543
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020909309387207
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020694732666016
(333) DESCRIBE `itineraries` 0.0010221004486084
(334) DESCRIBE `ports` 0.001162052154541
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034999847412109
(336) DESCRIBE `ports` 0.00094485282897949
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025415420532227
(338) DESCRIBE `ports` 0.00092196464538574
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023603439331055
(340) DESCRIBE `sailingdates` 0.00082516670227051
(341) DESCRIBE `ports` 0.0010380744934082
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025510787963867
(343) DESCRIBE `ports` 0.00092101097106934
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025701522827148
(345) DESCRIBE `ports` 0.00097894668579102
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(347) DESCRIBE `ports` 0.00080609321594238
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002140998840332
(349) DESCRIBE `ports` 0.00087094306945801
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031185150146484
(351) DESCRIBE `ports` 0.00099086761474609
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026392936706543
(353) DESCRIBE `ports` 0.00092005729675293
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00027894973754883
(355) DESCRIBE `ports` 0.00093293190002441
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00024795532226562
(357) DESCRIBE `ports` 0.00095796585083008
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00028109550476074
(359) DESCRIBE `ports` 0.0009009838104248
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00023198127746582
(361) DESCRIBE `ports` 0.00093197822570801
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00028800964355469
(363) DESCRIBE `ports` 0.00092196464538574
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.000244140625
(365) DESCRIBE `ports` 0.00097990036010742
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00033402442932129
(367) DESCRIBE `ports` 0.00099802017211914
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00020885467529297
(369) DESCRIBE `ports` 0.00062704086303711
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00019311904907227
(371) DESCRIBE `ports` 0.00059700012207031
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018191337585449
(373) DESCRIBE `ports` 0.00066709518432617
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00027012825012207
(375) DESCRIBE `ports` 0.00094199180603027
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00024008750915527
(377) DESCRIBE `ports` 0.00095605850219727
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.0002751350402832
(379) DESCRIBE `ports` 0.00094294548034668
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00024104118347168
(381) DESCRIBE `ports` 0.00097894668579102
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00026202201843262
(383) DESCRIBE `ports` 0.00093698501586914
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00023603439331055
(385) DESCRIBE `ports` 0.0010008811950684
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028300285339355
(387) DESCRIBE `ports` 0.0009760856628418
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00028395652770996
(389) DESCRIBE `ports` 0.00094103813171387
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00031089782714844
(391) DESCRIBE `ports` 0.00097799301147461
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020384788513184
(393) DESCRIBE `ports` 0.00071811676025391
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00022101402282715
(395) DESCRIBE `ports` 0.00064301490783691
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.0002291202545166
(397) DESCRIBE `ports` 0.00067400932312012
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00021100044250488
(399) DESCRIBE `ports` 0.00071191787719727
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00018215179443359
(401) DESCRIBE `ports` 0.00060510635375977
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00021600723266602
(403) DESCRIBE `ports` 0.00063180923461914
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00017595291137695
(405) DESCRIBE `ports` 0.00069594383239746
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 812))) 0.00020003318786621
(407) DESCRIBE `ports` 0.00067615509033203
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '812') 0.00020790100097656
(409) DESCRIBE `ports` 0.0006101131439209
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00022983551025391
(411) DESCRIBE `ports` 0.0007469654083252
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00018000602722168
(413) DESCRIBE `avid_specials` 0.0005650520324707
(414) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61952 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 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.00094008445739746
(415) DESCRIBE `cruiselines` 0.00095510482788086
(416) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00022292137145996
(417) DESCRIBE `orchid_image` 0.00069785118103027
(418) DESCRIBE `cruiselines` 0.00088095664978027
(419) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00037193298339844
(420) DESCRIBE `cruises` 0.0020599365234375
(421) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61953') 0.00038504600524902
(422) DESCRIBE `ships` 0.0019769668579102
(423) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00041317939758301
(424) DESCRIBE `ships` 0.0018160343170166
(425) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.00027799606323242
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001988410949707
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(428) DESCRIBE `itineraries` 0.00084114074707031
(429) DESCRIBE `ports` 0.00086593627929688
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025796890258789
(431) DESCRIBE `ports` 0.0006251335144043
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019001960754395
(433) DESCRIBE `ports` 0.00087118148803711
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(435) DESCRIBE `sailingdates` 0.00084114074707031
(436) DESCRIBE `ports` 0.00095295906066895
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031113624572754
(438) DESCRIBE `ports` 0.00090980529785156
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025486946105957
(440) DESCRIBE `ports` 0.00082516670227051
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025486946105957
(442) DESCRIBE `ports` 0.00090694427490234
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025105476379395
(444) DESCRIBE `ports` 0.00089883804321289
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029206275939941
(446) DESCRIBE `ports` 0.00091004371643066
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024890899658203
(448) DESCRIBE `ports` 0.00095200538635254
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00027894973754883
(450) DESCRIBE `ports` 0.0009310245513916
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00026297569274902
(452) DESCRIBE `ports` 0.0010499954223633
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00028800964355469
(454) DESCRIBE `ports` 0.00093793869018555
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00028300285339355
(456) DESCRIBE `ports` 0.00098299980163574
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00029897689819336
(458) DESCRIBE `ports` 0.00089788436889648
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.0002439022064209
(460) DESCRIBE `ports` 0.00090885162353516
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00028491020202637
(462) DESCRIBE `ports` 0.00095796585083008
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0002138614654541
(464) DESCRIBE `ports` 0.00076913833618164
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00028705596923828
(466) DESCRIBE `ports` 0.00092601776123047
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00026512145996094
(468) DESCRIBE `ports` 0.00096487998962402
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00029778480529785
(470) DESCRIBE `ports` 0.0010240077972412
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00025701522827148
(472) DESCRIBE `ports` 0.00094389915466309
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.0005028247833252
(474) DESCRIBE `ports` 0.0010490417480469
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00026607513427734
(476) DESCRIBE `ports` 0.00096297264099121
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0002739429473877
(478) DESCRIBE `ports` 0.0009150505065918
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00023984909057617
(480) DESCRIBE `ports` 0.0009620189666748
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029897689819336
(482) DESCRIBE `ports` 0.00091004371643066
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023794174194336
(484) DESCRIBE `ports` 0.00092911720275879
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00027990341186523
(486) DESCRIBE `ports` 0.00093197822570801
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00028705596923828
(488) DESCRIBE `avid_specials` 0.00094318389892578
(489) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61953 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 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.0014991760253906
(490) DESCRIBE `cruiselines` 0.0015628337860107
(491) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00034594535827637
(492) DESCRIBE `orchid_image` 0.0012421607971191
(493) DESCRIBE `cruiselines` 0.0013999938964844
(494) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00028014183044434
(495) DESCRIBE `cruises` 0.0018990039825439
(496) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61131') 0.00034999847412109
(497) DESCRIBE `ships` 0.0017940998077393
(498) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00040102005004883
(499) DESCRIBE `ships` 0.0016789436340332
(500) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00025796890258789
(501) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019288063049316
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018405914306641
(503) DESCRIBE `itineraries` 0.00086593627929688
(504) DESCRIBE `ports` 0.00083303451538086
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027108192443848
(506) DESCRIBE `ports` 0.00082182884216309
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00024986267089844
(508) DESCRIBE `ports` 0.00081396102905273
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00021696090698242
(510) DESCRIBE `sailingdates` 0.00073599815368652
(511) DESCRIBE `ports` 0.00096607208251953
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030803680419922
(513) DESCRIBE `ports` 0.00092005729675293
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024008750915527
(515) DESCRIBE `ports` 0.00085592269897461
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00026297569274902
(517) DESCRIBE `ports` 0.00082802772521973
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00022482872009277
(519) DESCRIBE `ports` 0.00083804130554199
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027298927307129
(521) DESCRIBE `ports` 0.00087690353393555
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025200843811035
(523) DESCRIBE `ports` 0.00088191032409668
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025486946105957
(525) DESCRIBE `ports` 0.0008091926574707
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021481513977051
(527) DESCRIBE `ports` 0.00080108642578125
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00026178359985352
(529) DESCRIBE `ports` 0.00088381767272949
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00024700164794922
(531) DESCRIBE `ports` 0.00086688995361328
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00026893615722656
(533) DESCRIBE `ports` 0.00083613395690918
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00022292137145996
(535) DESCRIBE `ports` 0.00082802772521973
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00025296211242676
(537) DESCRIBE `ports` 0.00090789794921875
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.0002741813659668
(539) DESCRIBE `ports` 0.00090694427490234
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00028419494628906
(541) DESCRIBE `ports` 0.00088596343994141
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00023102760314941
(543) DESCRIBE `ports` 0.00078201293945312
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00027704238891602
(545) DESCRIBE `ports` 0.00082302093505859
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00023102760314941
(547) DESCRIBE `avid_specials` 0.00084996223449707
(548) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61131 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 40 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.00089597702026367
(549) DESCRIBE `cruiselines` 0.0009300708770752
(550) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00021481513977051
(551) DESCRIBE `orchid_image` 0.00075101852416992
(552) DESCRIBE `cruiselines` 0.00099086761474609
(553) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0001990795135498
(554) DESCRIBE `cruises` 0.0020010471343994
(555) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67024') 0.00049996376037598
(556) DESCRIBE `ships` 0.0018999576568604
(557) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1017))) 0.00057005882263184
(558) DESCRIBE `ships` 0.0019571781158447
(559) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1017') 0.00034213066101074
(560) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002138614654541
(561) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(562) DESCRIBE `itineraries` 0.0010490417480469
(563) DESCRIBE `ports` 0.0012068748474121
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00032806396484375
(565) DESCRIBE `ports` 0.0010440349578857
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034308433532715
(567) DESCRIBE `ports` 0.0010340213775635
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00025486946105957
(569) DESCRIBE `sailingdates` 0.00078916549682617
(570) DESCRIBE `ports` 0.0010380744934082
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031208992004395
(572) DESCRIBE `ports` 0.0009758472442627
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00024890899658203
(574) DESCRIBE `ports` 0.0009758472442627
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00029802322387695
(576) DESCRIBE `ports` 0.0010201930999756
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00031805038452148
(578) DESCRIBE `ports` 0.00098395347595215
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.0003058910369873
(580) DESCRIBE `ports` 0.0010030269622803
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00028777122497559
(582) DESCRIBE `ports` 0.0010108947753906
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031399726867676
(584) DESCRIBE `ports` 0.0010690689086914
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00029921531677246
(586) DESCRIBE `ports` 0.001007080078125
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033807754516602
(588) DESCRIBE `ports` 0.00098896026611328
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002439022064209
(590) DESCRIBE `ports` 0.00094079971313477
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00031304359436035
(592) DESCRIBE `ports` 0.00098991394042969
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00024914741516113
(594) DESCRIBE `ports` 0.00085020065307617
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00026106834411621
(596) DESCRIBE `ports` 0.00089097023010254
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00027012825012207
(598) DESCRIBE `ports` 0.00096702575683594
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00029110908508301
(600) DESCRIBE `ports` 0.00094699859619141
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00024890899658203
(602) DESCRIBE `ports` 0.0009918212890625
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00030899047851562
(604) DESCRIBE `ports` 0.00097107887268066
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00025296211242676
(606) DESCRIBE `ports` 0.00093507766723633
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00027704238891602
(608) DESCRIBE `ports` 0.00089597702026367
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00029301643371582
(610) DESCRIBE `ports` 0.0010020732879639
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00028610229492188
(612) DESCRIBE `ports` 0.00092005729675293
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00026297569274902
(614) DESCRIBE `ports` 0.00095009803771973
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00032687187194824
(616) DESCRIBE `ports` 0.0010190010070801
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00027704238891602
(618) DESCRIBE `avid_specials` 0.00089716911315918
(619) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67024 and class = 'Cruise') OR (item_id = 1017 AND class = 'Ship') OR (item_id = 136 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015208721160889
(620) DESCRIBE `cruiselines` 0.0013139247894287
(621) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 136))) 0.00031900405883789
(622) DESCRIBE `orchid_image` 0.0010690689086914
(623) DESCRIBE `cruiselines` 0.0014419555664062
(624) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '136') 0.00029993057250977
(625) DESCRIBE `cruises` 0.0018999576568604
(626) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69031') 0.00030899047851562
(627) DESCRIBE `ships` 0.0025529861450195
(628) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.00052213668823242
(629) DESCRIBE `ships` 0.0020160675048828
(630) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00034213066101074
(631) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022482872009277
(632) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(633) DESCRIBE `itineraries` 0.0013480186462402
(634) DESCRIBE `ports` 0.001413106918335
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00049185752868652
(636) DESCRIBE `ports` 0.0011241436004639
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.0002748966217041
(638) DESCRIBE `ports` 0.00078392028808594
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00021600723266602
(640) DESCRIBE `sailingdates` 0.00069499015808105
(641) DESCRIBE `ports` 0.0014090538024902
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.0003359317779541
(643) DESCRIBE `ports` 0.0010740756988525
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00028300285339355
(645) DESCRIBE `ports` 0.0009770393371582
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00029611587524414
(647) DESCRIBE `ports` 0.0011310577392578
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.00037789344787598
(649) DESCRIBE `ports` 0.0010640621185303
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5593))) 0.00027012825012207
(651) DESCRIBE `ports` 0.00083398818969727
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5593') 0.0002288818359375
(653) DESCRIBE `ports` 0.0007789134979248
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00024294853210449
(655) DESCRIBE `ports` 0.00082015991210938
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00021886825561523
(657) DESCRIBE `ports` 0.00081205368041992
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0002589225769043
(659) DESCRIBE `ports` 0.00095391273498535
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00024104118347168
(661) DESCRIBE `ports` 0.0009160041809082
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00026392936706543
(663) DESCRIBE `ports` 0.00093293190002441
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00024986267089844
(665) DESCRIBE `ports` 0.00090479850769043
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00027084350585938
(667) DESCRIBE `ports` 0.00089907646179199
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00024914741516113
(669) DESCRIBE `ports` 0.00096797943115234
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00030684471130371
(671) DESCRIBE `ports` 0.00093197822570801
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00023984909057617
(673) DESCRIBE `ports` 0.00079202651977539
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00030088424682617
(675) DESCRIBE `ports` 0.00089693069458008
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00026822090148926
(677) DESCRIBE `ports` 0.0008080005645752
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00030803680419922
(679) DESCRIBE `ports` 0.0010440349578857
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.0002741813659668
(681) DESCRIBE `ports` 0.00093483924865723
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0002899169921875
(683) DESCRIBE `ports` 0.00097298622131348
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00024604797363281
(685) DESCRIBE `ports` 0.00093197822570801
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0002741813659668
(687) DESCRIBE `ports` 0.00094795227050781
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00025296211242676
(689) DESCRIBE `ports` 0.00095200538635254
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00026893615722656
(691) DESCRIBE `ports` 0.00092506408691406
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00023603439331055
(693) DESCRIBE `ports` 0.00091290473937988
(694) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00027203559875488
(695) DESCRIBE `ports` 0.00089907646179199
(696) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00026082992553711
(697) DESCRIBE `ports` 0.00089597702026367
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00026607513427734
(699) DESCRIBE `ports` 0.00091195106506348
(700) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00022292137145996
(701) DESCRIBE `ports` 0.00090217590332031
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00024914741516113
(703) DESCRIBE `ports` 0.00089907646179199
(704) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00024104118347168
(705) DESCRIBE `ports` 0.00091814994812012
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00026798248291016
(707) DESCRIBE `ports` 0.00096702575683594
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00024199485778809
(709) DESCRIBE `ports` 0.00090718269348145
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00026488304138184
(711) DESCRIBE `ports` 0.0009920597076416
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00024509429931641
(713) DESCRIBE `ports` 0.00091695785522461
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00025200843811035
(715) DESCRIBE `ports` 0.00090694427490234
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00022983551025391
(717) DESCRIBE `ports` 0.00088405609130859
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00025391578674316
(719) DESCRIBE `ports` 0.000885009765625
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00021910667419434
(721) DESCRIBE `ports` 0.00090694427490234
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00026798248291016
(723) DESCRIBE `ports` 0.00093817710876465
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00024008750915527
(725) DESCRIBE `ports` 0.00097107887268066
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004270076751709
(727) DESCRIBE `ports` 0.0010619163513184
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028800964355469
(729) DESCRIBE `ports` 0.0009758472442627
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031018257141113
(731) DESCRIBE `ports` 0.00078916549682617
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026798248291016
(733) DESCRIBE `ports` 0.00078320503234863
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00028800964355469
(735) DESCRIBE `ports` 0.00098896026611328
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00027680397033691
(737) DESCRIBE `ports` 0.0012249946594238
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00031805038452148
(739) DESCRIBE `ports` 0.0010361671447754
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00026679039001465
(741) DESCRIBE `avid_specials` 0.00094699859619141
(742) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69031 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 54 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.0015110969543457
(743) DESCRIBE `cruiselines` 0.0014231204986572
(744) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00032901763916016
(745) DESCRIBE `orchid_image` 0.00099802017211914
(746) DESCRIBE `cruiselines` 0.0015251636505127
(747) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00032305717468262
(748) DESCRIBE `cruises` 0.0020182132720947
(749) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61954') 0.00043511390686035
(750) DESCRIBE `ships` 0.002025842666626
(751) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 483))) 0.00038695335388184
(752) DESCRIBE `ships` 0.0018398761749268
(753) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '483') 0.00030303001403809
(754) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002140998840332
(755) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(756) DESCRIBE `itineraries` 0.00099802017211914
(757) DESCRIBE `ports` 0.0013689994812012
(758) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(759) DESCRIBE `ports` 0.00097107887268066
(760) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002591609954834
(761) DESCRIBE `ports` 0.00098180770874023
(762) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(763) DESCRIBE `sailingdates` 0.00089812278747559
(764) DESCRIBE `ports` 0.0010640621185303
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(766) DESCRIBE `ports` 0.00085997581481934
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002448558807373
(768) DESCRIBE `ports` 0.0010039806365967
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002748966217041
(770) DESCRIBE `ports` 0.00098896026611328
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026321411132812
(772) DESCRIBE `ports` 0.00095796585083008
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029921531677246
(774) DESCRIBE `ports` 0.00098013877868652
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00041317939758301
(776) DESCRIBE `ports` 0.00087404251098633
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 498))) 0.00028610229492188
(778) DESCRIBE `ports` 0.00094985961914062
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '498') 0.00028204917907715
(780) DESCRIBE `ports` 0.00098609924316406
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00028109550476074
(782) DESCRIBE `ports` 0.00084590911865234
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00023317337036133
(784) DESCRIBE `ports` 0.00088405609130859
(785) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00028491020202637
(786) DESCRIBE `ports` 0.0009758472442627
(787) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00024986267089844
(788) DESCRIBE `ports` 0.00081396102905273
(789) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00025796890258789
(790) DESCRIBE `ports` 0.00094294548034668
(791) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00030016899108887
(792) DESCRIBE `ports` 0.00091195106506348
(793) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026202201843262
(794) DESCRIBE `ports` 0.00095009803771973
(795) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00022292137145996
(796) DESCRIBE `ports` 0.00087308883666992
(797) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026988983154297
(798) DESCRIBE `ports` 0.00099682807922363
(799) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00022387504577637
(800) DESCRIBE `avid_specials` 0.00075292587280273
(801) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61954 and class = 'Cruise') OR (item_id = 483 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 40 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.001676082611084
(802) DESCRIBE `cruiselines` 0.0014290809631348
(803) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00032401084899902
(804) DESCRIBE `orchid_image` 0.0010430812835693
(805) DESCRIBE `cruiselines` 0.0016920566558838
(806) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00030899047851562
(807) DESCRIBE `cruises` 0.0021090507507324
(808) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72604') 0.00032401084899902
(809) DESCRIBE `ships` 0.0016710758209229
(810) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.0003821849822998
(811) DESCRIBE `ships` 0.0017621517181396
(812) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00028181076049805
(813) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00021982192993164
(814) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00020480155944824
(815) DESCRIBE `itineraries` 0.0010361671447754
(816) DESCRIBE `ports` 0.001101016998291
(817) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.0003199577331543
(818) DESCRIBE `ports` 0.00096797943115234
(819) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.00026988983154297
(820) DESCRIBE `ports` 0.00090694427490234
(821) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '469') 0.00024509429931641
(822) DESCRIBE `sailingdates` 0.00079703330993652
(823) DESCRIBE `ports` 0.00094079971313477
(824) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.00023388862609863
(825) DESCRIBE `ports` 0.00084185600280762
(826) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '469') 0.00023293495178223
(827) DESCRIBE `ports` 0.00071287155151367
(828) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2274))) 0.0001981258392334
(829) DESCRIBE `ports` 0.00075507164001465
(830) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2274') 0.0002288818359375
(831) DESCRIBE `ports` 0.00089693069458008
(832) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00026106834411621
(833) DESCRIBE `ports` 0.00098395347595215
(834) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.00025677680969238
(835) DESCRIBE `ports` 0.00091314315795898
(836) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 311))) 0.00026512145996094
(837) DESCRIBE `ports` 0.00091695785522461
(838) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '311') 0.00023794174194336
(839) DESCRIBE `ports` 0.00091886520385742
(840) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00054407119750977
(841) DESCRIBE `ports` 0.0011122226715088
(842) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00028514862060547
(843) DESCRIBE `ports` 0.0010018348693848
(844) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00030517578125
(845) DESCRIBE `ports` 0.0009009838104248
(846) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00025010108947754
(847) DESCRIBE `ports` 0.001007080078125
(848) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00029206275939941
(849) DESCRIBE `ports` 0.0009150505065918
(850) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00025010108947754
(851) DESCRIBE `ports` 0.00087690353393555
(852) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 672))) 0.00026297569274902
(853) DESCRIBE `ports` 0.00089097023010254
(854) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '672') 0.00024080276489258
(855) DESCRIBE `ports` 0.0009150505065918
(856) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2274))) 0.00027704238891602
(857) DESCRIBE `ports` 0.00089311599731445
(858) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2274') 0.00028491020202637
(859) DESCRIBE `ports` 0.00093913078308105
(860) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00028610229492188
(861) DESCRIBE `ports` 0.00088095664978027
(862) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00018906593322754
(863) DESCRIBE `ports` 0.00068902969360352
(864) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00023698806762695
(865) DESCRIBE `ports` 0.00072288513183594
(866) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0002288818359375
(867) DESCRIBE `ports` 0.00085997581481934
(868) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026798248291016
(869) DESCRIBE `ports` 0.00087594985961914
(870) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024604797363281
(871) DESCRIBE `avid_specials` 0.00083208084106445
(872) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72604 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 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.0014760494232178
(873) DESCRIBE `cruiselines` 0.0013809204101562
(874) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00038695335388184
(875) DESCRIBE `orchid_image` 0.0011730194091797
(876) DESCRIBE `cruiselines` 0.001859188079834
(877) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '101', '120', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '229', '140', '170', '225', '275', '59', '108', '115', '113', '180', '73', '269', '264', '188', '240', '88', '219', '276', '57', '52', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '224', '245', '177', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,101,120,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,229,140,170,225,275,59,108,115,113,180,73,269,264,188,240,88,219,276,57,52,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,224,245,177,257,210,223,263,251') 0.0051541328430176
(878) DESCRIBE `ships` 0.0023581981658936
(879) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '10', '349', '974', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '817', '520', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '31', '573', '1285', '1586', '30', '36', '38', '39', '378', '434', '590', '792', '34', '35', '37', '1012', '327', '526', '970', '43', '1376', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1382', '1405', '338', '716', '1088', '1176', '1292', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '1575', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '253', '857', '1149', '1236', '111', '285', '852', '966', '1095', '1284', '59', '93', '403', '451', '610', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '75', '616', '666', '784', '1150', '1301', '1501', '9', '823', '996', '1587', '81', '455', '503', '776', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1366', '1372', '1411', '1571', '108', '313', '790', '1141', '1241', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '883', '1253', '74', '98', '147', '394', '937', '1579', '1172', '1454', '335', '938', '994', '1087', '66', '70', '341', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1439', '715', '973', '1023', '1043', '1144', '1262', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1481', '1543', '1594', '448', '717', '1090', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1110', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811', '858', '888')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,10,349,974,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,817,520,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,31,573,1285,1586,30,36,38,39,378,434,590,792,34,35,37,1012,327,526,970,43,1376,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1382,1405,338,716,1088,1176,1292,1417,1569,1639,993,1455,314,678,722,837,1233,1575,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,253,857,1149,1236,111,285,852,966,1095,1284,59,93,403,451,610,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,75,616,666,784,1150,1301,1501,9,823,996,1587,81,455,503,776,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1366,1372,1411,1571,108,313,790,1141,1241,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,883,1253,74,98,147,394,937,1579,1172,1454,335,938,994,1087,66,70,341,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1439,715,973,1023,1043,1144,1262,1545,494,673,1136,1137,1240,1282,1303,1437,1481,1543,1594,448,717,1090,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1110,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,915,916,926,1001,1072,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811,858,888') 0.030740022659302
(880) DESCRIBE `cruisetypes` 0.0011708736419678
(881) DESCRIBE `destinations` 0.0011930465698242
(882) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.0013840198516846