or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 1.0090253353119

# Query Time
(1) connect 0.00095701217651367
(2) DESCRIBE `cruises` 0.0030360221862793
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71561, 66738, 71553, 50388, 66814, 67054, 68269, 78973, 72002, 66879)) ORDER BY FIND_IN_SET(id, '71561,66738,71553,50388,66814,67054,68269,78973,72002,66879') 0.0026991367340088
(4) DESCRIBE `cruises` 0.0028171539306641
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71561') 0.00043296813964844
(6) DESCRIBE `ships` 0.0036211013793945
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 401))) 0.00060296058654785
(8) DESCRIBE `ships` 0.0036940574645996
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '401') 0.00043678283691406
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029397010803223
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030207633972168
(12) DESCRIBE `itineraries` 0.0017609596252441
(13) DESCRIBE `ports` 0.0027458667755127
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00018692016601562
(15) DESCRIBE `ports` 0.0013558864593506
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046396255493164
(17) DESCRIBE `ports` 0.0013501644134521
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00027894973754883
(19) DESCRIBE `sailingdates` 0.0012581348419189
(20) DESCRIBE `ports` 0.0013179779052734
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00030899047851562
(22) DESCRIBE `ports` 0.0013859272003174
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00027585029602051
(24) DESCRIBE `ports` 0.0012462139129639
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00037312507629395
(26) DESCRIBE `ports` 0.0017499923706055
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00035786628723145
(28) DESCRIBE `ports` 0.0017311573028564
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00038409233093262
(30) DESCRIBE `ports` 0.0027039051055908
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00039815902709961
(32) DESCRIBE `ports` 0.0018129348754883
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00043392181396484
(34) DESCRIBE `ports` 0.0017480850219727
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00036191940307617
(36) DESCRIBE `ports` 0.0015618801116943
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00039005279541016
(38) DESCRIBE `ports` 0.0016288757324219
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00036215782165527
(40) DESCRIBE `ports` 0.0016529560089111
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00037503242492676
(42) DESCRIBE `ports` 0.0013601779937744
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00029301643371582
(44) DESCRIBE `ports` 0.0014381408691406
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00030803680419922
(46) DESCRIBE `ports` 0.00130295753479
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00031900405883789
(48) DESCRIBE `ports` 0.0017240047454834
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00067019462585449
(50) DESCRIBE `ports` 0.001906156539917
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00049901008605957
(52) DESCRIBE `ports` 0.0019738674163818
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046992301940918
(54) DESCRIBE `ports` 0.0020558834075928
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00044798851013184
(56) DESCRIBE `ports` 0.0019118785858154
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045394897460938
(58) DESCRIBE `ports` 0.0019640922546387
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00044798851013184
(60) DESCRIBE `ports` 0.0019991397857666
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 536))) 0.00045490264892578
(62) DESCRIBE `ports` 0.002112865447998
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '536') 0.00042200088500977
(64) DESCRIBE `ports` 0.0018889904022217
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00047183036804199
(66) DESCRIBE `ports` 0.0020198822021484
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00045514106750488
(68) DESCRIBE `ports` 0.0019619464874268
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00049614906311035
(70) DESCRIBE `ports` 0.0018830299377441
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00082707405090332
(72) DESCRIBE `ports` 0.0018281936645508
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00043201446533203
(74) DESCRIBE `ports` 0.0018870830535889
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00050687789916992
(76) DESCRIBE `ports` 0.0019619464874268
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00046801567077637
(78) DESCRIBE `ports` 0.0018908977508545
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00040984153747559
(80) DESCRIBE `ports` 0.0020699501037598
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00040483474731445
(82) DESCRIBE `ports` 0.0020420551300049
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00039482116699219
(84) DESCRIBE `ports` 0.0036580562591553
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00034499168395996
(86) DESCRIBE `ports` 0.0014071464538574
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00034308433532715
(88) DESCRIBE `ports` 0.0043671131134033
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00050902366638184
(90) DESCRIBE `ports` 0.0018889904022217
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00039386749267578
(92) DESCRIBE `ports` 0.0018839836120605
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00045013427734375
(94) DESCRIBE `ports` 0.0018010139465332
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00039100646972656
(96) DESCRIBE `ports` 0.0017812252044678
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00042295455932617
(98) DESCRIBE `ports` 0.0034229755401611
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.0005040168762207
(100) DESCRIBE `ports` 0.0069980621337891
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00054597854614258
(102) DESCRIBE `ports` 0.0017869472503662
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00038886070251465
(104) DESCRIBE `ports` 0.0016250610351562
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0004417896270752
(106) DESCRIBE `ports` 0.0017280578613281
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00038290023803711
(108) DESCRIBE `avid_specials` 0.0015380382537842
(109) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71561 and class = 'Cruise') OR (item_id = 401 AND class = 'Ship') OR (item_id = 18 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.0030190944671631
(110) DESCRIBE `cruiselines` 0.0038869380950928
(111) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00064396858215332
(112) DESCRIBE `orchid_image` 0.0016391277313232
(113) DESCRIBE `cruiselines` 0.0029990673065186
(114) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00053191184997559
(115) DESCRIBE `cruises` 0.004302978515625
(116) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66738') 0.00048995018005371
(117) DESCRIBE `ships` 0.0035710334777832
(118) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 618))) 0.00057506561279297
(119) DESCRIBE `ships` 0.0038571357727051
(120) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '618') 0.00050806999206543
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034594535827637
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032997131347656
(123) DESCRIBE `itineraries` 0.0018770694732666
(124) DESCRIBE `ports` 0.0020060539245605
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00050115585327148
(126) DESCRIBE `ports` 0.0016930103302002
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.0004270076751709
(128) DESCRIBE `ports` 0.0017030239105225
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00039196014404297
(130) DESCRIBE `sailingdates` 0.0014801025390625
(131) DESCRIBE `ports` 0.0019419193267822
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00043106079101562
(133) DESCRIBE `ports` 0.0026650428771973
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00042200088500977
(135) DESCRIBE `ports` 0.0018270015716553
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00043606758117676
(137) DESCRIBE `ports` 0.0018370151519775
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00040984153747559
(139) DESCRIBE `ports` 0.0017719268798828
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00044107437133789
(141) DESCRIBE `ports` 0.0015261173248291
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00034689903259277
(143) DESCRIBE `ports` 0.0016539096832275
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.00061702728271484
(145) DESCRIBE `ports` 0.0018219947814941
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00041007995605469
(147) DESCRIBE `ports` 0.0014450550079346
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.00037097930908203
(149) DESCRIBE `ports` 0.0023119449615479
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00016617774963379
(151) DESCRIBE `ports` 0.0031180381774902
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00043797492980957
(153) DESCRIBE `ports` 0.0017280578613281
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00039815902709961
(155) DESCRIBE `ports` 0.00189208984375
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00040197372436523
(157) DESCRIBE `ports` 0.0018999576568604
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00038504600524902
(159) DESCRIBE `ports` 0.0017120838165283
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00050091743469238
(161) DESCRIBE `ports` 0.0016360282897949
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00037908554077148
(163) DESCRIBE `ports` 0.0017340183258057
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00046086311340332
(165) DESCRIBE `ports` 0.0018641948699951
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00040292739868164
(167) DESCRIBE `ports` 0.0016298294067383
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00033688545227051
(169) DESCRIBE `ports` 0.0012969970703125
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00046491622924805
(171) DESCRIBE `ports` 0.0016510486602783
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0003349781036377
(173) DESCRIBE `ports` 0.0018959045410156
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00040411949157715
(175) DESCRIBE `ports` 0.0020358562469482
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00048184394836426
(177) DESCRIBE `ports` 0.0018599033355713
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00040602684020996
(179) DESCRIBE `ports` 0.0015900135040283
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00044393539428711
(181) DESCRIBE `ports` 0.0016000270843506
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00032615661621094
(183) DESCRIBE `ports` 0.0015890598297119
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1029))) 0.00036716461181641
(185) DESCRIBE `ports` 0.0015268325805664
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1029') 0.00029110908508301
(187) DESCRIBE `ports` 0.001572847366333
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2373))) 0.00040197372436523
(189) DESCRIBE `ports` 0.0016548633575439
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2373') 0.00031900405883789
(191) DESCRIBE `ports` 0.0020749568939209
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00036001205444336
(193) DESCRIBE `ports` 0.0025439262390137
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.0004580020904541
(195) DESCRIBE `ports` 0.0018088817596436
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 163))) 0.00039911270141602
(197) DESCRIBE `ports` 0.0016450881958008
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '163') 0.00043702125549316
(199) DESCRIBE `ports` 0.0016469955444336
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00038480758666992
(201) DESCRIBE `ports` 0.001676082611084
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00035810470581055
(203) DESCRIBE `ports` 0.0016717910766602
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00037693977355957
(205) DESCRIBE `ports` 0.0016610622406006
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00038599967956543
(207) DESCRIBE `ports` 0.0016160011291504
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035190582275391
(209) DESCRIBE `ports` 0.0016720294952393
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00032496452331543
(211) DESCRIBE `avid_specials` 0.001474142074585
(212) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66738 and class = 'Cruise') OR (item_id = 618 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017850399017334
(213) DESCRIBE `cruiselines` 0.0024471282958984
(214) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00041794776916504
(215) DESCRIBE `orchid_image` 0.0018689632415771
(216) DESCRIBE `cruiselines` 0.0023810863494873
(217) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00036501884460449
(218) DESCRIBE `cruises` 0.0033290386199951
(219) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71553') 0.0005791187286377
(220) DESCRIBE `ships` 0.003493070602417
(221) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 401))) 0.00062894821166992
(222) DESCRIBE `ships` 0.0037269592285156
(223) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '401') 0.00047922134399414
(224) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003359317779541
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003201961517334
(226) DESCRIBE `itineraries` 0.0018200874328613
(227) DESCRIBE `ports` 0.0019040107727051
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00039100646972656
(229) DESCRIBE `ports` 0.00164794921875
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00043702125549316
(231) DESCRIBE `ports` 0.0019059181213379
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00033783912658691
(233) DESCRIBE `sailingdates` 0.0015058517456055
(234) DESCRIBE `ports` 0.0019040107727051
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00041580200195312
(236) DESCRIBE `ports` 0.0014209747314453
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0003049373626709
(238) DESCRIBE `ports` 0.0015549659729004
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00042295455932617
(240) DESCRIBE `ports` 0.0016050338745117
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00031280517578125
(242) DESCRIBE `ports` 0.0016410350799561
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00033783912658691
(244) DESCRIBE `ports` 0.0029020309448242
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00047206878662109
(246) DESCRIBE `ports` 0.0018341541290283
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00045204162597656
(248) DESCRIBE `ports` 0.0018529891967773
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00047898292541504
(250) DESCRIBE `ports` 0.0018348693847656
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00050091743469238
(252) DESCRIBE `ports` 0.0018820762634277
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00043010711669922
(254) DESCRIBE `ports` 0.0018570423126221
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0004570484161377
(256) DESCRIBE `ports` 0.0018599033355713
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00042414665222168
(258) DESCRIBE `ports` 0.001910924911499
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00048494338989258
(260) DESCRIBE `ports` 0.0019700527191162
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00050902366638184
(262) DESCRIBE `ports` 0.0019979476928711
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00049400329589844
(264) DESCRIBE `ports` 0.001986026763916
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00068807601928711
(266) DESCRIBE `ports` 0.0020380020141602
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049686431884766
(268) DESCRIBE `ports` 0.0018379688262939
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040316581726074
(270) DESCRIBE `ports` 0.0017499923706055
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045418739318848
(272) DESCRIBE `ports` 0.0017950534820557
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00041508674621582
(274) DESCRIBE `ports` 0.0018861293792725
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 536))) 0.00045084953308105
(276) DESCRIBE `ports` 0.0018329620361328
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '536') 0.00041294097900391
(278) DESCRIBE `ports` 0.0018868446350098
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00045490264892578
(280) DESCRIBE `ports` 0.001884937286377
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00041508674621582
(282) DESCRIBE `avid_specials` 0.0016200542449951
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71553 and class = 'Cruise') OR (item_id = 401 AND class = 'Ship') OR (item_id = 18 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.0018479824066162
(284) DESCRIBE `cruiselines` 0.002669095993042
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00053286552429199
(286) DESCRIBE `orchid_image` 0.002269983291626
(287) DESCRIBE `cruiselines` 0.0031001567840576
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00058388710021973
(289) DESCRIBE `cruises` 0.0037150382995605
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50388') 0.00056290626525879
(291) DESCRIBE `ships` 0.0037200450897217
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00044989585876465
(293) DESCRIBE `ships` 0.0032498836517334
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00040984153747559
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(297) DESCRIBE `itineraries` 0.001737117767334
(298) DESCRIBE `ports` 0.00205397605896
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00050020217895508
(300) DESCRIBE `ports` 0.0017838478088379
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00065183639526367
(302) DESCRIBE `ports` 0.0023419857025146
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00054097175598145
(304) DESCRIBE `sailingdates` 0.0014870166778564
(305) DESCRIBE `ports` 0.002094030380249
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.0003509521484375
(307) DESCRIBE `ports` 0.0019040107727051
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00052404403686523
(309) DESCRIBE `ports` 0.0019369125366211
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00046992301940918
(311) DESCRIBE `ports` 0.0018420219421387
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00042295455932617
(313) DESCRIBE `ports` 0.0017931461334229
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3264))) 0.00032711029052734
(315) DESCRIBE `ports` 0.0018951892852783
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3264') 0.00042819976806641
(317) DESCRIBE `ports` 0.001147985458374
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00041699409484863
(319) DESCRIBE `ports` 0.0019259452819824
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00046396255493164
(321) DESCRIBE `ports` 0.0020840167999268
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00039982795715332
(323) DESCRIBE `ports` 0.0018391609191895
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00043892860412598
(325) DESCRIBE `ports` 0.0026779174804688
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.0014069080352783
(327) DESCRIBE `ports` 0.0010380744934082
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0
(329) DESCRIBE `ports` 0.0016229152679443
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00053501129150391
(331) DESCRIBE `ports` 0.0013630390167236
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.0001990795135498
(333) DESCRIBE `ports` 0.0013070106506348
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00052094459533691
(335) DESCRIBE `ports` 0.0023260116577148
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00025200843811035
(337) DESCRIBE `ports` 0.001594066619873
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00044012069702148
(339) DESCRIBE `ports` 0.0021030902862549
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 1.1920928955078E-5
(341) DESCRIBE `ports` 0.0017321109771729
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.000579833984375
(343) DESCRIBE `ports` 0.0012898445129395
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00040793418884277
(345) DESCRIBE `ports` 0.0016670227050781
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 3.504753112793E-5
(347) DESCRIBE `ports` 0.0017740726470947
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00040793418884277
(349) DESCRIBE `avid_specials` 0.0015568733215332
(350) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50388 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 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.0025181770324707
(351) DESCRIBE `cruiselines` 0.0020349025726318
(352) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00043511390686035
(353) DESCRIBE `orchid_image` 0.0018148422241211
(354) DESCRIBE `cruiselines` 0.0023999214172363
(355) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00089001655578613
(356) DESCRIBE `cruises` 0.0031659603118896
(357) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66814') 0.00048089027404785
(358) DESCRIBE `ships` 0.0032498836517334
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00052094459533691
(360) DESCRIBE `ships` 0.0034949779510498
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.0004580020904541
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031781196594238
(364) DESCRIBE `itineraries` 0.00154709815979
(365) DESCRIBE `ports` 0.0016908645629883
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040602684020996
(367) DESCRIBE `ports` 0.0015249252319336
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037312507629395
(369) DESCRIBE `ports` 0.0016000270843506
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(371) DESCRIBE `sailingdates` 0.0013909339904785
(372) DESCRIBE `ports` 0.0012788772583008
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040698051452637
(374) DESCRIBE `ports` 0.0015289783477783
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(376) DESCRIBE `ports` 0.0023298263549805
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00024199485778809
(378) DESCRIBE `ports` 0.0016131401062012
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0003960132598877
(380) DESCRIBE `ports` 0.0015890598297119
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00038480758666992
(382) DESCRIBE `ports` 0.001884937286377
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00042486190795898
(384) DESCRIBE `ports` 0.0018641948699951
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0005800724029541
(386) DESCRIBE `ports` 0.0017719268798828
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00026702880859375
(388) DESCRIBE `ports` 0.0015819072723389
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00037693977355957
(390) DESCRIBE `ports` 0.0015461444854736
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00035500526428223
(392) DESCRIBE `ports` 0.0016779899597168
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00045514106750488
(394) DESCRIBE `ports` 0.001521110534668
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00023794174194336
(396) DESCRIBE `ports` 0.0016729831695557
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00040411949157715
(398) DESCRIBE `ports` 0.0015740394592285
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0003659725189209
(400) DESCRIBE `ports` 0.0015320777893066
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00043797492980957
(402) DESCRIBE `ports` 0.0016019344329834
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00035405158996582
(404) DESCRIBE `ports` 0.0015361309051514
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00037407875061035
(406) DESCRIBE `ports` 0.0015048980712891
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00034093856811523
(408) DESCRIBE `ports` 0.0015671253204346
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00036406517028809
(410) DESCRIBE `ports` 0.0015530586242676
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00036191940307617
(412) DESCRIBE `ports` 0.0017359256744385
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00037407875061035
(414) DESCRIBE `ports` 0.0017290115356445
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00036001205444336
(416) DESCRIBE `ports` 0.0012969970703125
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0003659725189209
(418) DESCRIBE `ports` 0.0012691020965576
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00028705596923828
(420) DESCRIBE `ports` 0.0012869834899902
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035810470581055
(422) DESCRIBE `ports` 0.0013809204101562
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031208992004395
(424) DESCRIBE `avid_specials` 0.0012269020080566
(425) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66814 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.0010650157928467
(426) DESCRIBE `cruiselines` 0.0021858215332031
(427) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00036883354187012
(428) DESCRIBE `orchid_image` 0.0015521049499512
(429) DESCRIBE `cruiselines` 0.0018408298492432
(430) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00031709671020508
(431) DESCRIBE `cruises` 0.0024850368499756
(432) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67054') 0.00041604042053223
(433) DESCRIBE `ships` 0.002626895904541
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1294))) 0.00045013427734375
(435) DESCRIBE `ships` 0.0027890205383301
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1294') 0.00040698051452637
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026988983154297
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029611587524414
(439) DESCRIBE `itineraries` 0.0014369487762451
(440) DESCRIBE `ports` 0.0016989707946777
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.0004889965057373
(442) DESCRIBE `ports` 0.0015919208526611
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00043797492980957
(444) DESCRIBE `ports` 0.0018060207366943
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00096011161804199
(446) DESCRIBE `sailingdates` 0.0011239051818848
(447) DESCRIBE `ports` 0.0020570755004883
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00034213066101074
(449) DESCRIBE `ports` 0.001352071762085
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00030803680419922
(451) DESCRIBE `ports` 0.0013868808746338
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00031495094299316
(453) DESCRIBE `ports` 0.0013577938079834
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00077199935913086
(455) DESCRIBE `ports` 0.00099897384643555
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00033187866210938
(457) DESCRIBE `ports` 0.0015718936920166
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00031399726867676
(459) DESCRIBE `ports` 0.0015041828155518
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4811))) 0.00095987319946289
(461) DESCRIBE `ports` 0.0010859966278076
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4811') 0.00030398368835449
(463) DESCRIBE `ports` 0.0019071102142334
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00034117698669434
(465) DESCRIBE `ports` 0.0015480518341064
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00033211708068848
(467) DESCRIBE `ports` 0.0017101764678955
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4812))) 0.00042605400085449
(469) DESCRIBE `ports` 0.0013830661773682
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4812') 0.00030016899108887
(471) DESCRIBE `ports` 0.0013039112091064
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003058910369873
(473) DESCRIBE `ports` 0.0012729167938232
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0002892017364502
(475) DESCRIBE `ports` 0.0013689994812012
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4813))) 0.0003199577331543
(477) DESCRIBE `ports` 0.0013720989227295
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4813') 0.00040006637573242
(479) DESCRIBE `ports` 0.0017600059509277
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4891))) 0.00044918060302734
(481) DESCRIBE `ports` 0.0019009113311768
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4891') 0.00049805641174316
(483) DESCRIBE `ports` 0.0018188953399658
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4911))) 0.00043106079101562
(485) DESCRIBE `ports` 0.0017509460449219
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4911') 0.00039005279541016
(487) DESCRIBE `ports` 0.0017299652099609
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5541))) 0.00042104721069336
(489) DESCRIBE `ports` 0.0017068386077881
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5541') 0.00039386749267578
(491) DESCRIBE `ports` 0.0017740726470947
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00041103363037109
(493) DESCRIBE `ports` 0.0021750926971436
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00052309036254883
(495) DESCRIBE `ports` 0.0019760131835938
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5542))) 0.0003960132598877
(497) DESCRIBE `ports` 0.0016980171203613
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5542') 0.0004580020904541
(499) DESCRIBE `ports` 0.0016739368438721
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4915))) 0.00046086311340332
(501) DESCRIBE `ports` 0.0019919872283936
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4915') 0.00047087669372559
(503) DESCRIBE `ports` 0.0017588138580322
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4915))) 0.00045084953308105
(505) DESCRIBE `ports` 0.0020809173583984
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4915') 0.00046491622924805
(507) DESCRIBE `avid_specials` 0.0017049312591553
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67054 and class = 'Cruise') OR (item_id = 1294 AND class = 'Ship') OR (item_id = 120 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.0016419887542725
(509) DESCRIBE `cruiselines` 0.002471923828125
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0005180835723877
(511) DESCRIBE `orchid_image` 0.001701831817627
(512) DESCRIBE `cruiselines` 0.0019810199737549
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00031590461730957
(514) DESCRIBE `cruises` 0.0025539398193359
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68269') 0.00032401084899902
(516) DESCRIBE `ships` 0.0033900737762451
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 266))) 0.00058293342590332
(518) DESCRIBE `ships` 0.0036759376525879
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '266') 0.00030994415283203
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003049373626709
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002591609954834
(522) DESCRIBE `itineraries` 0.0015759468078613
(523) DESCRIBE `ports` 0.0017209053039551
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0012190341949463
(525) DESCRIBE `ports` 0.0011630058288574
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0013439655303955
(527) DESCRIBE `ports` 0.0010018348693848
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00032305717468262
(529) DESCRIBE `sailingdates` 0.0019090175628662
(530) DESCRIBE `ports` 0.0018219947814941
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0
(532) DESCRIBE `ports` 0.001878023147583
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0
(534) DESCRIBE `ports` 0.0019328594207764
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0004420280456543
(536) DESCRIBE `ports` 0.0014870166778564
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00037384033203125
(538) DESCRIBE `ports` 0.0017600059509277
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00043892860412598
(540) DESCRIBE `ports` 0.0017001628875732
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00037598609924316
(542) DESCRIBE `ports` 0.0019102096557617
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1149))) 0.00040602684020996
(544) DESCRIBE `ports` 0.0018510818481445
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1149') 0.0012528896331787
(546) DESCRIBE `ports` 0.0018200874328613
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00033116340637207
(548) DESCRIBE `ports` 0.0013730525970459
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00032997131347656
(550) DESCRIBE `ports` 0.0015029907226562
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00032901763916016
(552) DESCRIBE `ports` 0.00136399269104
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.0002901554107666
(554) DESCRIBE `ports` 0.0013539791107178
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00032496452331543
(556) DESCRIBE `ports` 0.0014760494232178
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00028014183044434
(558) DESCRIBE `ports` 0.0012710094451904
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00033402442932129
(560) DESCRIBE `ports` 0.0015740394592285
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00028800964355469
(562) DESCRIBE `ports` 0.0012748241424561
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00037384033203125
(564) DESCRIBE `ports` 0.0016970634460449
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.0003659725189209
(566) DESCRIBE `ports` 0.0016660690307617
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00040197372436523
(568) DESCRIBE `ports` 0.001704216003418
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00038003921508789
(570) DESCRIBE `ports` 0.0015931129455566
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00046586990356445
(572) DESCRIBE `ports` 0.0015830993652344
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00035905838012695
(574) DESCRIBE `ports` 0.0017299652099609
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00041699409484863
(576) DESCRIBE `ports` 0.0019230842590332
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.0003960132598877
(578) DESCRIBE `avid_specials` 0.0015161037445068
(579) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68269 and class = 'Cruise') OR (item_id = 266 AND class = 'Ship') OR (item_id = 49 AND class = 'CruiseLine') OR (item_id = 55 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.0016169548034668
(580) DESCRIBE `cruiselines` 0.0023078918457031
(581) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.0004270076751709
(582) DESCRIBE `orchid_image` 0.0015580654144287
(583) DESCRIBE `cruiselines` 0.0019099712371826
(584) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.00041007995605469
(585) DESCRIBE `cruises` 0.0026509761810303
(586) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78973') 0.0004420280456543
(587) DESCRIBE `ships` 0.0030019283294678
(588) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 454))) 0.00051212310791016
(589) DESCRIBE `ships` 0.0031218528747559
(590) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '454') 0.00056195259094238
(591) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034117698669434
(592) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(593) DESCRIBE `itineraries` 0.0014288425445557
(594) DESCRIBE `ports` 0.0018689632415771
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0006098747253418
(596) DESCRIBE `ports` 0.0015740394592285
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00041294097900391
(598) DESCRIBE `ports` 0.0019259452819824
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00050687789916992
(600) DESCRIBE `sailingdates` 0.0016829967498779
(601) DESCRIBE `ports` 0.0021300315856934
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00055098533630371
(603) DESCRIBE `ports` 0.0018999576568604
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.0004580020904541
(605) DESCRIBE `ports` 0.002161979675293
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00048494338989258
(607) DESCRIBE `ports` 0.00177001953125
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00038719177246094
(609) DESCRIBE `ports` 0.0018839836120605
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 314))) 0.00048518180847168
(611) DESCRIBE `ports` 0.0019440650939941
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '314') 0.0004279613494873
(613) DESCRIBE `ports` 0.0018110275268555
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00043702125549316
(615) DESCRIBE `ports` 0.0016329288482666
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.00037598609924316
(617) DESCRIBE `ports` 0.0017330646514893
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00040006637573242
(619) DESCRIBE `ports` 0.0013809204101562
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00029397010803223
(621) DESCRIBE `ports` 0.0013220310211182
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00038313865661621
(623) DESCRIBE `ports` 0.00199294090271
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00035500526428223
(625) DESCRIBE `ports` 0.0015699863433838
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00047397613525391
(627) DESCRIBE `ports` 0.0019371509552002
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00036096572875977
(629) DESCRIBE `ports` 0.0018279552459717
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.0004270076751709
(631) DESCRIBE `ports` 0.0017180442810059
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00036406517028809
(633) DESCRIBE `ports` 0.00097298622131348
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.0005180835723877
(635) DESCRIBE `ports` 0.0018861293792725
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00045394897460938
(637) DESCRIBE `ports` 0.0016050338745117
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00040698051452637
(639) DESCRIBE `ports` 0.0016179084777832
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00035190582275391
(641) DESCRIBE `ports` 0.0017061233520508
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00046706199645996
(643) DESCRIBE `ports` 0.0016608238220215
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00035309791564941
(645) DESCRIBE `ports` 0.0016751289367676
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00044798851013184
(647) DESCRIBE `ports` 0.0015020370483398
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.0002901554107666
(649) DESCRIBE `ports` 0.00148606300354
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00035810470581055
(651) DESCRIBE `ports` 0.0014829635620117
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00032615661621094
(653) DESCRIBE `ports` 0.0021359920501709
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00048112869262695
(655) DESCRIBE `ports` 0.0019087791442871
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00039410591125488
(657) DESCRIBE `avid_specials` 0.0015430450439453
(658) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78973 and class = 'Cruise') OR (item_id = 454 AND class = 'Ship') OR (item_id = 12 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.0011231899261475
(659) DESCRIBE `cruiselines` 0.0020308494567871
(660) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00038290023803711
(661) DESCRIBE `orchid_image` 0.0024480819702148
(662) DESCRIBE `cruiselines` 0.0021188259124756
(663) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00037789344787598
(664) DESCRIBE `cruises` 0.0030179023742676
(665) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72002') 0.00043487548828125
(666) DESCRIBE `ships` 0.0036129951477051
(667) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1663))) 0.00043487548828125
(668) DESCRIBE `ships` 0.0030460357666016
(669) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1663') 0.00049400329589844
(670) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003058910369873
(671) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031399726867676
(672) DESCRIBE `itineraries` 0.001223087310791
(673) DESCRIBE `ports` 0.0013339519500732
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0004270076751709
(675) DESCRIBE `ports` 0.0014088153839111
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00048089027404785
(677) DESCRIBE `ports` 0.0016491413116455
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033903121948242
(679) DESCRIBE `sailingdates` 0.0011370182037354
(680) DESCRIBE `ports` 0.0017719268798828
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00041484832763672
(682) DESCRIBE `ports` 0.0017480850219727
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00049185752868652
(684) DESCRIBE `ports` 0.0015869140625
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00035810470581055
(686) DESCRIBE `ports` 0.0015048980712891
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003509521484375
(688) DESCRIBE `ports` 0.0015740394592285
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00046992301940918
(690) DESCRIBE `ports` 0.0017409324645996
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00038003921508789
(692) DESCRIBE `ports` 0.0018069744110107
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00044488906860352
(694) DESCRIBE `ports` 0.0018370151519775
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00039505958557129
(696) DESCRIBE `ports` 0.0017828941345215
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00049805641174316
(698) DESCRIBE `ports` 0.001345157623291
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00053501129150391
(700) DESCRIBE `ports` 0.0012741088867188
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1030))) 0.00030708312988281
(702) DESCRIBE `ports` 0.0012741088867188
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1030') 0.00037288665771484
(704) DESCRIBE `ports` 0.0014619827270508
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00042200088500977
(706) DESCRIBE `ports` 0.0013580322265625
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00030612945556641
(708) DESCRIBE `ports` 0.0013120174407959
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00033807754516602
(710) DESCRIBE `ports` 0.0014309883117676
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00055909156799316
(712) DESCRIBE `ports` 0.0015058517456055
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034189224243164
(714) DESCRIBE `ports` 0.0012850761413574
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027585029602051
(716) DESCRIBE `ports` 0.0013527870178223
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030684471130371
(718) DESCRIBE `ports` 0.0012969970703125
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00035715103149414
(720) DESCRIBE `ports` 0.0018191337585449
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00046181678771973
(722) DESCRIBE `ports` 0.0021970272064209
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.0003960132598877
(724) DESCRIBE `ports` 0.0018520355224609
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00043892860412598
(726) DESCRIBE `ports` 0.0015408992767334
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00031495094299316
(728) DESCRIBE `ports` 0.0012860298156738
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040817260742188
(730) DESCRIBE `ports` 0.0013880729675293
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030708312988281
(732) DESCRIBE `ports` 0.0014791488647461
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00033187866210938
(734) DESCRIBE `ports` 0.00130295753479
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00029587745666504
(736) DESCRIBE `ports` 0.0015490055084229
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033903121948242
(738) DESCRIBE `ports` 0.0013320446014404
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029587745666504
(740) DESCRIBE `avid_specials` 0.0015029907226562
(741) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72002 and class = 'Cruise') OR (item_id = 1663 AND class = 'Ship') OR (item_id = 184 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010819435119629
(742) DESCRIBE `cruiselines` 0.002068042755127
(743) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 184))) 0.00037193298339844
(744) DESCRIBE `orchid_image` 0.0016798973083496
(745) DESCRIBE `cruiselines` 0.0021109580993652
(746) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '184') 0.00035500526428223
(747) DESCRIBE `cruises` 0.0029439926147461
(748) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66879') 0.00040006637573242
(749) DESCRIBE `ships` 0.0029370784759521
(750) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 325))) 0.00057387351989746
(751) DESCRIBE `ships` 0.0025432109832764
(752) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '325') 0
(753) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(754) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025391578674316
(755) DESCRIBE `itineraries` 0.0013890266418457
(756) DESCRIBE `ports` 0.0027499198913574
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00014305114746094
(758) DESCRIBE `ports` 0.0014469623565674
(759) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0003662109375
(760) DESCRIBE `ports` 0.00088906288146973
(761) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00041604042053223
(762) DESCRIBE `sailingdates` 0.0019199848175049
(763) DESCRIBE `ports` 0.0017650127410889
(764) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 6.6041946411133E-5
(765) DESCRIBE `ports` 0.0017750263214111
(766) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0011749267578125
(767) DESCRIBE `ports` 0.0012979507446289
(768) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2152))) 0.00041007995605469
(769) DESCRIBE `ports` 0.0014128684997559
(770) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2152') 0.00033402442932129
(771) DESCRIBE `ports` 0.0013132095336914
(772) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00084781646728516
(773) DESCRIBE `ports` 0.0011842250823975
(774) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.0002739429473877
(775) DESCRIBE `ports` 0.0019130706787109
(776) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.0003809928894043
(777) DESCRIBE `ports` 0.0013220310211182
(778) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0010900497436523
(779) DESCRIBE `ports` 0.00052809715270996
(780) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00031185150146484
(781) DESCRIBE `ports` 0.0012519359588623
(782) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0
(783) DESCRIBE `ports` 0.00089216232299805
(784) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00030398368835449
(785) DESCRIBE `ports` 0.0020711421966553
(786) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0
(787) DESCRIBE `ports` 0.0012741088867188
(788) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.0003049373626709
(789) DESCRIBE `ports` 0.0016248226165771
(790) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00026702880859375
(791) DESCRIBE `ports` 0.0012500286102295
(792) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00040197372436523
(793) DESCRIBE `ports` 0.0016670227050781
(794) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00031089782714844
(795) DESCRIBE `ports` 0.0013730525970459
(796) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00030398368835449
(797) DESCRIBE `ports` 0.001291036605835
(798) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00029897689819336
(799) DESCRIBE `ports` 0.0012550354003906
(800) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1185))) 0.00037097930908203
(801) DESCRIBE `ports` 0.0016181468963623
(802) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1185') 0.00032997131347656
(803) DESCRIBE `ports` 0.0015218257904053
(804) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00039196014404297
(805) DESCRIBE `ports` 0.0015850067138672
(806) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00029301643371582
(807) DESCRIBE `avid_specials` 0.0014631748199463
(808) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66879 and class = 'Cruise') OR (item_id = 325 AND class = 'Ship') OR (item_id = 8 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.0014231204986572
(809) DESCRIBE `cruiselines` 0.0022640228271484
(810) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00034809112548828
(811) DESCRIBE `orchid_image` 0.0018360614776611
(812) DESCRIBE `cruiselines` 0.0022809505462646
(813) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00034689903259277
(814) DESCRIBE `cruiselines` 0.0030088424682617
(815) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '12', '8', '18', '171', '221', '144', '31', '101', '103', '232', '131', '96', '50', '29', '239', '258', '15', '191', '251', '206', '33', '91', '114', '170', '37', '14', '16', '24', '268', '262', '36', '256', '28', '120', '195', '47', '240', '208', '146', '110', '156', '174', '187', '220', '141', '153', '118', '229', '108', '49', '151', '128', '35', '30', '216', '168', '196', '181', '236', '88', '4', '200', '212', '38', '264', '73', '225', '238', '159', '90', '211', '39', '147', '115', '140', '184', '249', '59', '48', '257', '275', '219', '132', '213', '276', '230', '113', '182', '261', '64', '188', '237', '57', '180', '95', '248', '235', '209', '62', '231', '52', '116', '266', '105', '82', '177', '119', '134', '244', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,12,8,18,171,221,144,31,101,103,232,131,96,50,29,239,258,15,191,251,206,33,91,114,170,37,14,16,24,268,262,36,256,28,120,195,47,240,208,146,110,156,174,187,220,141,153,118,229,108,49,151,128,35,30,216,168,196,181,236,88,4,200,212,38,264,73,225,238,159,90,211,39,147,115,140,184,249,59,48,257,275,219,132,213,276,230,113,182,261,64,188,237,57,180,95,248,235,209,62,231,52,116,266,105,82,177,119,134,244,210,224,245') 0.0073609352111816
(816) DESCRIBE `ships` 0.0034840106964111
(817) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1127', '1554', '1555', '1247', '1324', '517', '1032', '974', '797', '21', '22', '461', '1292', '393', '207', '28', '977', '1205', '330', '258', '480', '1291', '1599', '737', '1199', '1010', '1417', '11', '10', '780', '349', '439', '9', '333', '404', '739', '1135', '986', '1359', '14', '454', '1272', '265', '1677', '855', '1237', '24', '25', '731', '1067', '859', '817', '1594', '770', '1607', '113', '1481', '1588', '3', '31', '37', '38', '837', '34', '378', '985', '1239', '1372', '542', '407', '390', '39', '1320', '30', '43', '748', '1579', '36', '970', '1012', '573', '726', '1323', '1402', '1744', '66', '854', '1376', '1768', '526', '582', '1245', '27', '1422', '1424', '327', '332', '882', '1413', '590', '1420', '1552', '1411', '1419', '1423', '1284', '1418', '1421', '1586', '35', '791', '792', '1410', '441', '674', '1773', '585', '1587', '1183', '1415', '455', '1184', '114', '580', '857', '1501', '858', '1176', '711', '1193', '1382', '434', '462', '1236', '1405', '1574', '162', '722', '1215', '1682', '325', '160', '1742', '452', '639', '285', '1021', '1141', '1454', '78', '119', '658', '683', '852', '81', '1008', '1412', '69', '1168', '338', '1095', '1408', '1678', '1760', '1373', '1572', '163', '678', '1172', '869', '1082', '776', '850', '1319', '211', '335', '1630', '111', '253', '610', '1782', '45', '314', '403', '503', '1302', '1383', '1569', '1628', '124', '348', '451', '1259', '1384', '70', '340', '405', '4', '116', '766', '968', '1711', '635', '966', '626', '651', '851', '944', '1159', '148', '286', '386', '553', '63', '324', '385', '508', '749', '768', '1303', '1330', '123', '262', '389', '559', '1068', '1260', '1455', '198', '485', '616', '1266', '1301', '375', '406', '467', '1088', '1108', '1325', '1632', '1672', '84', '291', '784', '1212', '1562', '1575', '287', '1195', '108', '483', '716', '1208', '1781', '98', '421', '1639', '290', '401', '1064', '1571', '394', '1398', '1492', '1614', '1645', '1721', '652', '657', '1308', '883', '954', '147', '150', '152', '341', '1321', '1389', '1724', '149', '151', '223', '704', '874', '1139', '1486', '1611', '1722', '775', '885', '1269', '1539', '1601', '1717', '1268', '1615', '547', '958', '1289', '1557', '1738', '105', '1143', '1326', '1327', '1437', '545', '717', '1771', '351', '516', '1040', '1075', '1704', '75', '790', '818', '1270', '1471', '1679', '868', '1063', '1151', '1213', '1282', '1673', '1684', '796', '823', '1367', '479', '574', '665', '1013', '1214', '1262', '1318', '1676', '1740', '82', '93', '205', '701', '1561', '1766', '520', '1043', '1218', '1460', '1526', '1540', '1566', '644', '673', '715', '988', '1144', '1157', '743', '751', '1137', '1223', '1226', '1344', '212', '266', '669', '884', '1027', '1029', '1163', '1229', '1343', '1409', '1602', '1716', '201', '795', '1160', '1217', '1283', '1452', '1453', '1604', '707', '769', '1025', '1090', '1414', '1612', '1613', '1055', '1073', '1136', '1216', '1426', '1448', '1713', '1715', '417', '448', '601', '695', '905', '996', '1019', '1026', '1110', '1145', '1233', '1243', '1253', '1458', '1496', '1714', '643', '1188', '1211', '1743', '1772', '1783', '74', '888', '973', '997', '1034', '1149', '1351', '1358', '1366', '1404', '1516', '1609', '811', '1049', '1150', '1196', '1222', '1231', '1241', '1345', '1360', '1361', '1362', '1368', '1395', '1449', '1459', '1522', '1619', '1647', '1730', '618', '666', '920', '921', '927', '931', '1047', '1152', '1230', '1354', '1474', '1627', '1663', '1729', '261', '423', '733', '914', '923', '993', '1004', '1322', '1348', '1517', '1518', '1567', '1580', '663', '740', '836', '915', '916', '926', '930', '1037', '1042', '1072', '1138', '1521', '1674', '1708', '1751', '453', '494', '499', '703', '709')) ORDER BY FIND_IN_SET(id, '1761,1127,1554,1555,1247,1324,517,1032,974,797,21,22,461,1292,393,207,28,977,1205,330,258,480,1291,1599,737,1199,1010,1417,11,10,780,349,439,9,333,404,739,1135,986,1359,14,454,1272,265,1677,855,1237,24,25,731,1067,859,817,1594,770,1607,113,1481,1588,3,31,37,38,837,34,378,985,1239,1372,542,407,390,39,1320,30,43,748,1579,36,970,1012,573,726,1323,1402,1744,66,854,1376,1768,526,582,1245,27,1422,1424,327,332,882,1413,590,1420,1552,1411,1419,1423,1284,1418,1421,1586,35,791,792,1410,441,674,1773,585,1587,1183,1415,455,1184,114,580,857,1501,858,1176,711,1193,1382,434,462,1236,1405,1574,162,722,1215,1682,325,160,1742,452,639,285,1021,1141,1454,78,119,658,683,852,81,1008,1412,69,1168,338,1095,1408,1678,1760,1373,1572,163,678,1172,869,1082,776,850,1319,211,335,1630,111,253,610,1782,45,314,403,503,1302,1383,1569,1628,124,348,451,1259,1384,70,340,405,4,116,766,968,1711,635,966,626,651,851,944,1159,148,286,386,553,63,324,385,508,749,768,1303,1330,123,262,389,559,1068,1260,1455,198,485,616,1266,1301,375,406,467,1088,1108,1325,1632,1672,84,291,784,1212,1562,1575,287,1195,108,483,716,1208,1781,98,421,1639,290,401,1064,1571,394,1398,1492,1614,1645,1721,652,657,1308,883,954,147,150,152,341,1321,1389,1724,149,151,223,704,874,1139,1486,1611,1722,775,885,1269,1539,1601,1717,1268,1615,547,958,1289,1557,1738,105,1143,1326,1327,1437,545,717,1771,351,516,1040,1075,1704,75,790,818,1270,1471,1679,868,1063,1151,1213,1282,1673,1684,796,823,1367,479,574,665,1013,1214,1262,1318,1676,1740,82,93,205,701,1561,1766,520,1043,1218,1460,1526,1540,1566,644,673,715,988,1144,1157,743,751,1137,1223,1226,1344,212,266,669,884,1027,1029,1163,1229,1343,1409,1602,1716,201,795,1160,1217,1283,1452,1453,1604,707,769,1025,1090,1414,1612,1613,1055,1073,1136,1216,1426,1448,1713,1715,417,448,601,695,905,996,1019,1026,1110,1145,1233,1243,1253,1458,1496,1714,643,1188,1211,1743,1772,1783,74,888,973,997,1034,1149,1351,1358,1366,1404,1516,1609,811,1049,1150,1196,1222,1231,1241,1345,1360,1361,1362,1368,1395,1449,1459,1522,1619,1647,1730,618,666,920,921,927,931,1047,1152,1230,1354,1474,1627,1663,1729,261,423,733,914,923,993,1004,1322,1348,1517,1518,1567,1580,663,740,836,915,916,926,930,1037,1042,1072,1138,1521,1674,1708,1751,453,494,499,703,709') 0.043791055679321
(818) DESCRIBE `cruisetypes` 0.0015060901641846
(819) DESCRIBE `destinations` 0.0021908283233643
(820) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '44', '55', '53', '39', '26', '38', '28', '49', '7', '40', '11', '21', '48', '56', '30', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,44,55,53,39,26,38,28,49,7,40,11,21,48,56,30,46,29,45,34,10,52,32') 0.0025041103363037