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

Total elapsed time: 0.90510010719299

# Query Time
(1) connect 0.0011000633239746
(2) DESCRIBE `cruises` 0.004349946975708
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74683, 66877, 73259, 41359, 65709, 69839, 69894, 72369, 52236, 69851)) ORDER BY FIND_IN_SET(id, '74683,66877,73259,41359,65709,69839,69894,72369,52236,69851') 0.0032339096069336
(4) DESCRIBE `cruises` 0.0036880970001221
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74683') 0.00058507919311523
(6) DESCRIBE `ships` 0.0038321018218994
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.00064897537231445
(8) DESCRIBE `ships` 0.0037271976470947
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.00059199333190918
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039291381835938
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047397613525391
(12) DESCRIBE `itineraries` 0.0020229816436768
(13) DESCRIBE `ports` 0.0021069049835205
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052404403686523
(15) DESCRIBE `ports` 0.0018482208251953
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00047898292541504
(17) DESCRIBE `ports` 0.0018579959869385
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0004429817199707
(19) DESCRIBE `sailingdates` 0.0016791820526123
(20) DESCRIBE `ports` 0.0020787715911865
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052499771118164
(22) DESCRIBE `ports` 0.0021781921386719
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00079512596130371
(24) DESCRIBE `ports` 0.0021939277648926
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0012609958648682
(26) DESCRIBE `ports` 0.0017180442810059
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00039410591125488
(28) DESCRIBE `ports` 0.0019080638885498
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00049901008605957
(30) DESCRIBE `ports` 0.0020780563354492
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00046110153198242
(32) DESCRIBE `ports` 0.0018889904022217
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00049400329589844
(34) DESCRIBE `ports` 0.0019772052764893
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00044393539428711
(36) DESCRIBE `ports` 0.0018830299377441
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00046801567077637
(38) DESCRIBE `ports` 0.0019221305847168
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.0004429817199707
(40) DESCRIBE `ports` 0.0019161701202393
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00044989585876465
(42) DESCRIBE `ports` 0.0016899108886719
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00040411949157715
(44) DESCRIBE `ports` 0.0016770362854004
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.0004420280456543
(46) DESCRIBE `ports` 0.0018100738525391
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00039815902709961
(48) DESCRIBE `ports` 0.0017368793487549
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2939))) 0.00049996376037598
(50) DESCRIBE `ports` 0.0019431114196777
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2939') 0.00041818618774414
(52) DESCRIBE `ports` 0.0017828941345215
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 816))) 0.0004119873046875
(54) DESCRIBE `ports` 0.0013141632080078
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '816') 0.00030684471130371
(56) DESCRIBE `ports` 0.0016090869903564
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00040817260742188
(58) DESCRIBE `ports` 0.0016961097717285
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00031781196594238
(60) DESCRIBE `ports` 0.0013070106506348
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00037813186645508
(62) DESCRIBE `ports` 0.0017368793487549
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00040507316589355
(64) DESCRIBE `avid_specials` 0.0012681484222412
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74683 and class = 'Cruise') OR (item_id = 352 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0016191005706787
(66) DESCRIBE `cruiselines` 0.0023460388183594
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00035500526428223
(68) DESCRIBE `orchid_image` 0.0020270347595215
(69) DESCRIBE `cruiselines` 0.0028009414672852
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00048398971557617
(71) DESCRIBE `cruises` 0.0029959678649902
(72) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66877') 0.00043416023254395
(73) DESCRIBE `ships` 0.0035429000854492
(74) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 325))) 0.00044798851013184
(75) DESCRIBE `ships` 0.0036699771881104
(76) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '325') 0.00039792060852051
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026512145996094
(78) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027012825012207
(79) DESCRIBE `itineraries` 0.0015900135040283
(80) DESCRIBE `ports` 0.0022430419921875
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00050187110900879
(82) DESCRIBE `ports` 0.0020890235900879
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00047588348388672
(84) DESCRIBE `ports` 0.0019550323486328
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00058698654174805
(86) DESCRIBE `sailingdates` 0.0015790462493896
(87) DESCRIBE `ports` 0.0017931461334229
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00048613548278809
(89) DESCRIBE `ports` 0.001619815826416
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00039100646972656
(91) DESCRIBE `ports` 0.0016498565673828
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2152))) 0.00040912628173828
(93) DESCRIBE `ports` 0.0016598701477051
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2152') 0.00036001205444336
(95) DESCRIBE `ports` 0.0015649795532227
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00046110153198242
(97) DESCRIBE `ports` 0.0016200542449951
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00038886070251465
(99) DESCRIBE `ports` 0.0016708374023438
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00059103965759277
(101) DESCRIBE `ports` 0.0028228759765625
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00039219856262207
(103) DESCRIBE `ports` 0.0016148090362549
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00039887428283691
(105) DESCRIBE `ports` 0.0016109943389893
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00037193298339844
(107) DESCRIBE `ports` 0.001572847366333
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00038981437683105
(109) DESCRIBE `ports` 0.0015599727630615
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00035500526428223
(111) DESCRIBE `ports` 0.0016250610351562
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00039100646972656
(113) DESCRIBE `ports` 0.0016820430755615
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00037503242492676
(115) DESCRIBE `ports` 0.0016298294067383
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00039911270141602
(117) DESCRIBE `ports` 0.0015699863433838
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00037789344787598
(119) DESCRIBE `ports` 0.0015931129455566
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00038480758666992
(121) DESCRIBE `ports` 0.0015628337860107
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00037121772766113
(123) DESCRIBE `ports` 0.0015950202941895
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00040102005004883
(125) DESCRIBE `ports` 0.0016138553619385
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00038313865661621
(127) DESCRIBE `avid_specials` 0.0014970302581787
(128) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66877 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.0015969276428223
(129) DESCRIBE `cruiselines` 0.0024027824401855
(130) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00046610832214355
(131) DESCRIBE `orchid_image` 0.001943826675415
(132) DESCRIBE `cruiselines` 0.0020921230316162
(133) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.0010249614715576
(134) DESCRIBE `cruises` 0.0038490295410156
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73259') 0.00055885314941406
(136) DESCRIBE `ships` 0.003093957901001
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00047016143798828
(138) DESCRIBE `ships` 0.0032870769500732
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.00045299530029297
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030899047851562
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(142) DESCRIBE `itineraries` 0.0015389919281006
(143) DESCRIBE `ports` 0.0017588138580322
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00051999092102051
(145) DESCRIBE `ports` 0.0014021396636963
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.0003349781036377
(147) DESCRIBE `ports` 0.0015549659729004
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00036811828613281
(149) DESCRIBE `sailingdates` 0.0016660690307617
(150) DESCRIBE `ports` 0.0021669864654541
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00051498413085938
(152) DESCRIBE `ports` 0.0020949840545654
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00047802925109863
(154) DESCRIBE `ports` 0.0020380020141602
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00049400329589844
(156) DESCRIBE `ports` 0.0018470287322998
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00040793418884277
(158) DESCRIBE `ports` 0.0018999576568604
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00049400329589844
(160) DESCRIBE `ports` 0.0017662048339844
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00032615661621094
(162) DESCRIBE `ports` 0.0014190673828125
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00042104721069336
(164) DESCRIBE `ports` 0.001863956451416
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00086593627929688
(166) DESCRIBE `ports` 0.0018208026885986
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2132))) 0.00038814544677734
(168) DESCRIBE `ports` 0.0014829635620117
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2132') 0.00033712387084961
(170) DESCRIBE `ports` 0.0013649463653564
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2132))) 0.00032901763916016
(172) DESCRIBE `ports` 0.0013489723205566
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2132') 0.00030303001403809
(174) DESCRIBE `ports` 0.0013468265533447
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4929))) 0.00034689903259277
(176) DESCRIBE `ports` 0.0013840198516846
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4929') 0.0003201961517334
(178) DESCRIBE `ports` 0.0014419555664062
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3040))) 0.00038409233093262
(180) DESCRIBE `ports` 0.0013351440429688
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3040') 0.0003199577331543
(182) DESCRIBE `ports` 0.0017428398132324
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 617))) 0.00047016143798828
(184) DESCRIBE `ports` 0.001957893371582
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '617') 0.00043582916259766
(186) DESCRIBE `ports` 0.0020110607147217
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.00039005279541016
(188) DESCRIBE `ports` 0.0017709732055664
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '467') 0.00040102005004883
(190) DESCRIBE `avid_specials` 0.0016169548034668
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73259 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 48 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.0012578964233398
(192) DESCRIBE `cruiselines` 0.0021038055419922
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00043702125549316
(194) DESCRIBE `orchid_image` 0.0017569065093994
(195) DESCRIBE `cruiselines` 0.002781867980957
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00049400329589844
(197) DESCRIBE `cruises` 0.0032131671905518
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41359') 0.00051689147949219
(199) DESCRIBE `ships` 0.0038449764251709
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1071))) 0.0010759830474854
(201) DESCRIBE `ships` 0.0037860870361328
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1071') 0.00049805641174316
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034499168395996
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00081086158752441
(205) DESCRIBE `itineraries` 0.00142502784729
(206) DESCRIBE `ports` 0.0014820098876953
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00032806396484375
(208) DESCRIBE `ports` 0.0012509822845459
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00027990341186523
(210) DESCRIBE `ports` 0.0012919902801514
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0002751350402832
(212) DESCRIBE `sailingdates` 0.0011148452758789
(213) DESCRIBE `ports` 0.0013771057128906
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00032901763916016
(215) DESCRIBE `ports` 0.0012671947479248
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00035309791564941
(217) DESCRIBE `ports` 0.001554012298584
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00040698051452637
(219) DESCRIBE `ports` 0.0018980503082275
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0003209114074707
(221) DESCRIBE `ports` 0.0014710426330566
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00032281875610352
(223) DESCRIBE `ports` 0.00146484375
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00035905838012695
(225) DESCRIBE `ports` 0.0014359951019287
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00031113624572754
(227) DESCRIBE `ports` 0.001288890838623
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00040197372436523
(229) DESCRIBE `ports` 0.0015819072723389
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00031518936157227
(231) DESCRIBE `ports` 0.001338005065918
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00032806396484375
(233) DESCRIBE `ports` 0.0014030933380127
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00037693977355957
(235) DESCRIBE `ports` 0.0014059543609619
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00030398368835449
(237) DESCRIBE `ports` 0.0013060569763184
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00038790702819824
(239) DESCRIBE `ports` 0.0013308525085449
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00036382675170898
(241) DESCRIBE `ports` 0.0017919540405273
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00036096572875977
(243) DESCRIBE `ports` 0.0019049644470215
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00040411949157715
(245) DESCRIBE `ports` 0.0017170906066895
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00044012069702148
(247) DESCRIBE `ports` 0.001701831817627
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00037097930908203
(249) DESCRIBE `ports` 0.001535177230835
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.0003819465637207
(251) DESCRIBE `ports` 0.0012609958648682
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00028514862060547
(253) DESCRIBE `ports` 0.0014891624450684
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00039505958557129
(255) DESCRIBE `ports` 0.0014989376068115
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00053000450134277
(257) DESCRIBE `ports` 0.0015239715576172
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00049901008605957
(259) DESCRIBE `ports` 0.0017430782318115
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00041007995605469
(261) DESCRIBE `ports` 0.0016119480133057
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00031805038452148
(263) DESCRIBE `ports` 0.0014021396636963
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00028204917907715
(265) DESCRIBE `ports` 0.0014619827270508
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00038790702819824
(267) DESCRIBE `ports` 0.0013320446014404
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0003349781036377
(269) DESCRIBE `ports` 0.0011510848999023
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043392181396484
(271) DESCRIBE `ports` 0.00177001953125
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00041103363037109
(273) DESCRIBE `ports` 0.0019750595092773
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00046110153198242
(275) DESCRIBE `ports` 0.0017569065093994
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00035881996154785
(277) DESCRIBE `avid_specials` 0.0016109943389893
(278) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41359 and class = 'Cruise') OR (item_id = 1071 AND class = 'Ship') OR (item_id = 144 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.0020260810852051
(279) DESCRIBE `cruiselines` 0.0024499893188477
(280) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00046396255493164
(281) DESCRIBE `orchid_image` 0.0020380020141602
(282) DESCRIBE `cruiselines` 0.0026659965515137
(283) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00046396255493164
(284) DESCRIBE `cruises` 0.0035479068756104
(285) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65709') 0.00048303604125977
(286) DESCRIBE `ships` 0.0036289691925049
(287) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 768))) 0.00063991546630859
(288) DESCRIBE `ships` 0.0037782192230225
(289) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '768') 0.00051116943359375
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027108192443848
(291) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025606155395508
(292) DESCRIBE `itineraries` 0.0014669895172119
(293) DESCRIBE `ports` 0.0017659664154053
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040411949157715
(295) DESCRIBE `ports` 0.0014491081237793
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00041699409484863
(297) DESCRIBE `ports` 0.0018739700317383
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043106079101562
(299) DESCRIBE `sailingdates` 0.0016579627990723
(300) DESCRIBE `ports` 0.0021359920501709
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049710273742676
(302) DESCRIBE `ports` 0.0019359588623047
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00044584274291992
(304) DESCRIBE `ports` 0.0018210411071777
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00045084953308105
(306) DESCRIBE `ports` 0.0018219947814941
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00042605400085449
(308) DESCRIBE `ports` 0.0019199848175049
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.0005650520324707
(310) DESCRIBE `ports` 0.0022850036621094
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00045394897460938
(312) DESCRIBE `ports` 0.0023200511932373
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0
(314) DESCRIBE `ports` 0.0022251605987549
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00046706199645996
(316) DESCRIBE `ports` 0.0018470287322998
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00049281120300293
(318) DESCRIBE `ports` 0.0018560886383057
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00043392181396484
(320) DESCRIBE `ports` 0.0017430782318115
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00038599967956543
(322) DESCRIBE `ports` 0.0017268657684326
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00044989585876465
(324) DESCRIBE `ports` 0.0019080638885498
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.0003809928894043
(326) DESCRIBE `ports` 0.0015408992767334
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00036287307739258
(328) DESCRIBE `ports` 0.001727819442749
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044918060302734
(330) DESCRIBE `ports` 0.0016679763793945
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00037598609924316
(332) DESCRIBE `avid_specials` 0.0013978481292725
(333) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65709 and class = 'Cruise') OR (item_id = 768 AND class = 'Ship') OR (item_id = 29 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.0013749599456787
(334) DESCRIBE `cruiselines` 0.0026519298553467
(335) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.0005040168762207
(336) DESCRIBE `orchid_image` 0.0020999908447266
(337) DESCRIBE `cruises` 0.0036280155181885
(338) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69839') 0.00055813789367676
(339) DESCRIBE `ships` 0.003870964050293
(340) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1539))) 0.00042605400085449
(341) DESCRIBE `ships` 0.0037388801574707
(342) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1539') 0.00044703483581543
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00087809562683105
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(345) DESCRIBE `itineraries` 0.0019350051879883
(346) DESCRIBE `ports` 0.0019690990447998
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2115))) 0.00046801567077637
(348) DESCRIBE `ports` 0.0017988681793213
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2115))) 0.00047898292541504
(350) DESCRIBE `ports` 0.0018270015716553
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2115') 0.0018930435180664
(352) DESCRIBE `sailingdates` 0.0016801357269287
(353) DESCRIBE `ports` 0.0017380714416504
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2115))) 0.00045299530029297
(355) DESCRIBE `ports` 0.0017061233520508
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2115') 0.00057792663574219
(357) DESCRIBE `ports` 0.0018560886383057
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1701))) 0.00045490264892578
(359) DESCRIBE `ports` 0.0020740032196045
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1701') 0.00039100646972656
(361) DESCRIBE `ports` 0.0020241737365723
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00073385238647461
(363) DESCRIBE `ports` 0.00189208984375
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00041317939758301
(365) DESCRIBE `ports` 0.0019931793212891
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5685))) 0.0010519027709961
(367) DESCRIBE `ports` 0.0018191337585449
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5685') 0.00084996223449707
(369) DESCRIBE `ports` 0.001802921295166
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5686))) 0.00045990943908691
(371) DESCRIBE `ports` 0.0019729137420654
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5686') 0.00038695335388184
(373) DESCRIBE `ports` 0.0016679763793945
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2387))) 0.00046396255493164
(375) DESCRIBE `ports` 0.0019950866699219
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2387') 0.00054812431335449
(377) DESCRIBE `ports` 0.0027689933776855
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00054121017456055
(379) DESCRIBE `ports` 0.0020239353179932
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00054192543029785
(381) DESCRIBE `avid_specials` 0.0017449855804443
(382) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69839 and class = 'Cruise') OR (item_id = 1539 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 30 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.0040469169616699
(383) DESCRIBE `cruiselines` 0.0031638145446777
(384) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00062894821166992
(385) DESCRIBE `orchid_image` 0.0025079250335693
(386) DESCRIBE `cruiselines` 0.0030078887939453
(387) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.000518798828125
(388) DESCRIBE `cruises` 0.0033359527587891
(389) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69894') 0.00049495697021484
(390) DESCRIBE `ships` 0.0036139488220215
(391) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.0005497932434082
(392) DESCRIBE `ships` 0.0036520957946777
(393) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.000518798828125
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(396) DESCRIBE `itineraries` 0.0017399787902832
(397) DESCRIBE `ports` 0.0019769668579102
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046992301940918
(399) DESCRIBE `ports` 0.0016109943389893
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049495697021484
(401) DESCRIBE `ports` 0.0021030902862549
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005190372467041
(403) DESCRIBE `sailingdates` 0.0017189979553223
(404) DESCRIBE `ports` 0.002223014831543
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052380561828613
(406) DESCRIBE `ports` 0.0021541118621826
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042891502380371
(408) DESCRIBE `ports` 0.0018138885498047
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00039410591125488
(410) DESCRIBE `ports` 0.0016188621520996
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00038409233093262
(412) DESCRIBE `ports` 0.0014951229095459
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00043797492980957
(414) DESCRIBE `ports` 0.001777172088623
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042295455932617
(416) DESCRIBE `ports` 0.0019199848175049
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00056910514831543
(418) DESCRIBE `ports` 0.0020840167999268
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00048398971557617
(420) DESCRIBE `ports` 0.0019891262054443
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00044512748718262
(422) DESCRIBE `ports` 0.0016851425170898
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00033712387084961
(424) DESCRIBE `ports` 0.0016119480133057
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00038385391235352
(426) DESCRIBE `ports` 0.0016369819641113
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0004270076751709
(428) DESCRIBE `ports` 0.0019941329956055
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00044512748718262
(430) DESCRIBE `ports` 0.0016791820526123
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0003669261932373
(432) DESCRIBE `ports` 0.0015649795532227
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00038599967956543
(434) DESCRIBE `ports` 0.0016458034515381
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00035214424133301
(436) DESCRIBE `ports` 0.0014150142669678
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035810470581055
(438) DESCRIBE `ports` 0.001356840133667
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004429817199707
(440) DESCRIBE `avid_specials` 0.0013940334320068
(441) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69894 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 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.0015048980712891
(442) DESCRIBE `cruiselines` 0.0020971298217773
(443) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00038814544677734
(444) DESCRIBE `orchid_image` 0.0017580986022949
(445) DESCRIBE `cruiselines` 0.002018928527832
(446) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041913986206055
(447) DESCRIBE `cruises` 0.0026800632476807
(448) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72369') 0.00036001205444336
(449) DESCRIBE `ships` 0.0027809143066406
(450) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00047588348388672
(451) DESCRIBE `ships` 0.0029499530792236
(452) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00033998489379883
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027203559875488
(454) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(455) DESCRIBE `itineraries` 0.001446008682251
(456) DESCRIBE `ports` 0.0020020008087158
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041007995605469
(458) DESCRIBE `ports` 0.0018279552459717
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043606758117676
(460) DESCRIBE `ports` 0.0016269683837891
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030803680419922
(462) DESCRIBE `sailingdates` 0.0013549327850342
(463) DESCRIBE `ports` 0.001413106918335
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00039100646972656
(465) DESCRIBE `ports` 0.0015339851379395
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003199577331543
(467) DESCRIBE `ports` 0.0016019344329834
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00034999847412109
(469) DESCRIBE `ports` 0.0012340545654297
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00024890899658203
(471) DESCRIBE `ports` 0.0019600391387939
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00033116340637207
(473) DESCRIBE `ports` 0.001629114151001
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00039505958557129
(475) DESCRIBE `ports` 0.0017950534820557
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00042414665222168
(477) DESCRIBE `ports` 0.0018758773803711
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00051712989807129
(479) DESCRIBE `ports` 0.00180983543396
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00040411949157715
(481) DESCRIBE `ports` 0.0019018650054932
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00034809112548828
(483) DESCRIBE `ports` 0.0016810894012451
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00043201446533203
(485) DESCRIBE `ports` 0.0019810199737549
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00032711029052734
(487) DESCRIBE `ports` 0.0018470287322998
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2151))) 0.00049686431884766
(489) DESCRIBE `ports` 0.0019679069519043
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2151') 0.00046801567077637
(491) DESCRIBE `ports` 0.0019340515136719
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047397613525391
(493) DESCRIBE `ports` 0.002485990524292
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049400329589844
(495) DESCRIBE `avid_specials` 0.0016629695892334
(496) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72369 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0021531581878662
(497) DESCRIBE `cruiselines` 0.0026378631591797
(498) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00037097930908203
(499) DESCRIBE `orchid_image` 0.0023181438446045
(500) DESCRIBE `cruiselines` 0.0028581619262695
(501) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00041413307189941
(502) DESCRIBE `cruises` 0.0038580894470215
(503) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52236') 0.00046300888061523
(504) DESCRIBE `ships` 0.004004955291748
(505) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1291))) 0.0012509822845459
(506) DESCRIBE `ships` 0.0040810108184814
(507) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1291') 0.00013995170593262
(508) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039291381835938
(509) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033998489379883
(510) DESCRIBE `itineraries` 0.0015449523925781
(511) DESCRIBE `ports` 0.0022790431976318
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 8.702278137207E-5
(513) DESCRIBE `ports` 0.0015828609466553
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 6.8902969360352E-5
(515) DESCRIBE `ports` 0.0016918182373047
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00021219253540039
(517) DESCRIBE `sailingdates` 0.0011360645294189
(518) DESCRIBE `ports` 0.0052638053894043
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00044488906860352
(520) DESCRIBE `ports` 0.0018150806427002
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00033712387084961
(522) DESCRIBE `ports` 0.0018699169158936
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00044488906860352
(524) DESCRIBE `ports` 0.0019619464874268
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00042295455932617
(526) DESCRIBE `ports` 0.0024471282958984
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00034809112548828
(528) DESCRIBE `ports` 0.0020360946655273
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.00033783912658691
(530) DESCRIBE `ports` 0.0014100074768066
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2663))) 0.00033903121948242
(532) DESCRIBE `ports` 0.0015618801116943
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2663') 0.00036501884460449
(534) DESCRIBE `ports` 0.0019938945770264
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.0004580020904541
(536) DESCRIBE `ports` 0.0016729831695557
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00032806396484375
(538) DESCRIBE `ports` 0.0015361309051514
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4179))) 0.00034403800964355
(540) DESCRIBE `ports` 0.0013799667358398
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4179') 0.00058102607727051
(542) DESCRIBE `ports` 0.0015499591827393
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5374))) 0.00041007995605469
(544) DESCRIBE `ports` 0.0022799968719482
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5374') 0.0004730224609375
(546) DESCRIBE `ports` 0.0021588802337646
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00051093101501465
(548) DESCRIBE `ports` 0.0021100044250488
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00041007995605469
(550) DESCRIBE `ports` 0.0020339488983154
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00074100494384766
(552) DESCRIBE `ports` 0.0019497871398926
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00065183639526367
(554) DESCRIBE `ports` 0.0014960765838623
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00058197975158691
(556) DESCRIBE `ports` 0.0015239715576172
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0
(558) DESCRIBE `ports` 0.0029199123382568
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.0068991184234619
(560) DESCRIBE `ports` 0.0021989345550537
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.0088431835174561
(562) DESCRIBE `avid_specials` 0.0018391609191895
(563) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52236 and class = 'Cruise') OR (item_id = 1291 AND class = 'Ship') OR (item_id = 171 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.0021040439605713
(564) DESCRIBE `cruiselines` 0.0023078918457031
(565) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00040102005004883
(566) DESCRIBE `orchid_image` 0.0079290866851807
(567) DESCRIBE `cruises` 0.0036158561706543
(568) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69851') 0.00050806999206543
(569) DESCRIBE `ships` 0.0033879280090332
(570) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1137))) 0.00053787231445312
(571) DESCRIBE `ships` 0.0033459663391113
(572) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1137') 0.00042080879211426
(573) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003211498260498
(574) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030398368835449
(575) DESCRIBE `itineraries` 0.0016820430755615
(576) DESCRIBE `ports` 0.0019991397857666
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00049996376037598
(578) DESCRIBE `ports` 0.0017430782318115
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00042009353637695
(580) DESCRIBE `ports` 0.0018100738525391
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0060329437255859
(582) DESCRIBE `sailingdates` 0.001507043838501
(583) DESCRIBE `ports` 0.002518892288208
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00048208236694336
(585) DESCRIBE `ports` 0.0022389888763428
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0001220703125
(587) DESCRIBE `ports` 0.0018179416656494
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00057697296142578
(589) DESCRIBE `ports` 0.0024070739746094
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00049185752868652
(591) DESCRIBE `ports` 0.0017569065093994
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00041699409484863
(593) DESCRIBE `ports` 0.0018928050994873
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00045585632324219
(595) DESCRIBE `ports` 0.0020439624786377
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00046992301940918
(597) DESCRIBE `ports` 0.0020911693572998
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00046896934509277
(599) DESCRIBE `ports` 0.0016801357269287
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00060796737670898
(601) DESCRIBE `ports` 0.0021522045135498
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00048184394836426
(603) DESCRIBE `ports` 0.0020210742950439
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00046396255493164
(605) DESCRIBE `ports` 0.0018799304962158
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00043392181396484
(607) DESCRIBE `ports` 0.0024349689483643
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00046706199645996
(609) DESCRIBE `ports` 0.0019199848175049
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00042891502380371
(611) DESCRIBE `ports` 0.0019891262054443
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00049400329589844
(613) DESCRIBE `ports` 0.0020949840545654
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00014901161193848
(615) DESCRIBE `ports` 0.0026350021362305
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00053691864013672
(617) DESCRIBE `ports` 0.0012400150299072
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00033903121948242
(619) DESCRIBE `ports` 0.0010018348693848
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 6.7949295043945E-5
(621) DESCRIBE `ports` 0.0014898777008057
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00040102005004883
(623) DESCRIBE `ports` 0.0015208721160889
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00010991096496582
(625) DESCRIBE `ports` 0.0018479824066162
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00061202049255371
(627) DESCRIBE `ports` 0.0015950202941895
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00034499168395996
(629) DESCRIBE `ports` 0.0014779567718506
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00029706954956055
(631) DESCRIBE `avid_specials` 0.0011398792266846
(632) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69851 and class = 'Cruise') OR (item_id = 1137 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0010309219360352
(633) DESCRIBE `cruiselines` 0.00217604637146
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00056004524230957
(635) DESCRIBE `orchid_image` 0.0018808841705322
(636) DESCRIBE `cruiselines` 0.0026249885559082
(637) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00042295455932617
(638) DESCRIBE `cruiselines` 0.0027139186859131
(639) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '19', '26', '77', '23', '7', '12', '20', '18', '171', '8', '144', '101', '31', '103', '50', '131', '96', '29', '239', '15', '258', '191', '33', '91', '206', '37', '120', '16', '114', '24', '262', '268', '28', '14', '174', '110', '208', '156', '221', '187', '141', '153', '118', '49', '151', '211', '30', '216', '181', '88', '4', '212', '36', '264', '225', '238', '140', '159', '184', '249', '90', '230', '113', '213', '182', '276', '136', '261', '47', '57', '64', '237', '188', '232', '180', '35', '248', '73', '95', '209', '231', '52', '116', '146', '219', '82', '119', '59', '134', '105', '195', '244', '115', '168', '196', '170', '240', '256', '229', '204')) ORDER BY FIND_IN_SET(id, '183,218,19,26,77,23,7,12,20,18,171,8,144,101,31,103,50,131,96,29,239,15,258,191,33,91,206,37,120,16,114,24,262,268,28,14,174,110,208,156,221,187,141,153,118,49,151,211,30,216,181,88,4,212,36,264,225,238,140,159,184,249,90,230,113,213,182,276,136,261,47,57,64,237,188,232,180,35,248,73,95,209,231,52,116,146,219,82,119,59,134,105,195,244,115,168,196,170,240,256,229,204') 0.0067129135131836
(640) DESCRIBE `ships` 0.004906177520752
(641) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '977', '258', '1291', '1199', '1599', '1359', '349', '454', '439', '1135', '1272', '404', '780', '855', '1677', '986', '1067', '265', '1237', '1594', '1607', '837', '34', '37', '38', '770', '1588', '22', '27', '817', '21', '31', '378', '461', '28', '407', '393', '1376', '542', '39', '1012', '30', '36', '1245', '573', '970', '1402', '1552', '726', '585', '35', '66', '1424', '1744', '330', '332', '1768', '792', '1284', '1413', '1411', '1415', '1422', '113', '882', '1420', '462', '1176', '1419', '1423', '1410', '1418', '1421', '1587', '24', '711', '11', '1405', '1574', '9', '434', '455', '1773', '10', '580', '1760', '722', '1215', '160', '162', '1021', '1193', '766', '1141', '452', '658', '739', '78', '81', '1682', '69', '1454', '1572', '674', '1008', '1372', '3', '163', '1095', '678', '338', '852', '1168', '1412', '1319', '1373', '1408', '43', '124', '335', '1678', '253', '635', '850', '1302', '1172', '116', '1569', '70', '285', '340', '1159', '1236', '111', '553', '348', '451', '1259', '4', '944', '966', '968', '25', '390', '1108', '1260', '148', '386', '626', '748', '1266', '385', '616', '651', '683', '716', '1330', '314', '389', '768', '791', '1320', '63', '405', '784', '1088', '1323', '1455', '1562', '508', '874', '1195', '1325', '286', '406', '590', '749', '1632', '1645', '287', '375', '559', '582', '1068', '1672', '84', '108', '291', '327', '483', '526', '1575', '119', '467', '1208', '98', '394', '401', '1742', '854', '1398', '207', '290', '657', '45', '421', '485', '1492', '1571', '1064', '1586', '147', '150', '151', '652', '776', '114', '152', '704', '1308', '123', '149', '341', '403', '520', '639', '1268', '1460', '223', '547', '775', '883', '954', '1269', '1289', '1539', '1321', '1711', '325', '1389', '1724', '262', '1139', '1486', '1601', '1722', '105', '715', '958', '1557', '1717', '351', '790', '1471', '75', '324', '545', '717', '1243', '1270', '1282', '1738', '1143', '1303', '1326', '1327', '1437', '441', '1526', '1771', '516', '517', '885', '993', '1040', '1075', '1214', '1579', '1704', '93', '205', '574', '796', '823', '1013', '1151', '1561', '333', '665', '673', '701', '818', '1063', '1301', '1367', '82', '988', '1218', '1318', '1540', '212', '743', '1247', '1262', '1676', '1740', '1043', '1566', '1602', '1766', '751', '769', '1137', '1216', '1344', '201', '266', '884', '1144', '1157', '1217', '1343', '1409', '1721', '795', '1073', '1160', '1223', '1226', '1283', '1348', '1604', '14', '448', '1027', '1029', '1229', '1253', '1426', '1452', '1453', '1716', '601', '669', '738', '1025', '1090', '1136', '1163', '732', '811', '905', '1241', '1449', '1496', '1619', '610', '1019', '1055', '1152', '1358', '1448', '1673', '1713', '1715', '74', '417', '996', '997', '1026', '1145', '1188', '1233', '1458', '1714', '643', '1150', '1351', '1663', '1743', '494', '836', '888', '973', '1034', '1149', '1231', '1345', '1366', '1404', '1474', '1516', '1609', '1772', '618', '851', '1047', '1049', '1196', '1222', '1322', '1360', '1361', '1362', '1368', '1459', '1522', '1647', '1730', '423', '453', '666', '709', '920', '921', '927', '931', '1004', '1230', '1354', '1470', '1508', '1627', '1729', '208', '914', '923', '1017', '1037', '1042', '1407', '1517', '1518', '1567', '1580', '1606', '352', '663', '915', '916', '926', '930', '1003', '1072', '1138', '1140', '1187', '1489', '1505', '1593', '1649', '1674', '1708', '1751', '499', '695', '703', '924', '972', '1001', '1020', '1154', '1352', '1444', '1514', '1521', '1596', '1723', '422', '479', '493', '671', '938', '1005', '1054', '1175', '1515', '1767', '781', '937', '1051', '1650', '1679', '1681', '1684', '672', '1052', '1091', '1092', '1254', '1445')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,977,258,1291,1199,1599,1359,349,454,439,1135,1272,404,780,855,1677,986,1067,265,1237,1594,1607,837,34,37,38,770,1588,22,27,817,21,31,378,461,28,407,393,1376,542,39,1012,30,36,1245,573,970,1402,1552,726,585,35,66,1424,1744,330,332,1768,792,1284,1413,1411,1415,1422,113,882,1420,462,1176,1419,1423,1410,1418,1421,1587,24,711,11,1405,1574,9,434,455,1773,10,580,1760,722,1215,160,162,1021,1193,766,1141,452,658,739,78,81,1682,69,1454,1572,674,1008,1372,3,163,1095,678,338,852,1168,1412,1319,1373,1408,43,124,335,1678,253,635,850,1302,1172,116,1569,70,285,340,1159,1236,111,553,348,451,1259,4,944,966,968,25,390,1108,1260,148,386,626,748,1266,385,616,651,683,716,1330,314,389,768,791,1320,63,405,784,1088,1323,1455,1562,508,874,1195,1325,286,406,590,749,1632,1645,287,375,559,582,1068,1672,84,108,291,327,483,526,1575,119,467,1208,98,394,401,1742,854,1398,207,290,657,45,421,485,1492,1571,1064,1586,147,150,151,652,776,114,152,704,1308,123,149,341,403,520,639,1268,1460,223,547,775,883,954,1269,1289,1539,1321,1711,325,1389,1724,262,1139,1486,1601,1722,105,715,958,1557,1717,351,790,1471,75,324,545,717,1243,1270,1282,1738,1143,1303,1326,1327,1437,441,1526,1771,516,517,885,993,1040,1075,1214,1579,1704,93,205,574,796,823,1013,1151,1561,333,665,673,701,818,1063,1301,1367,82,988,1218,1318,1540,212,743,1247,1262,1676,1740,1043,1566,1602,1766,751,769,1137,1216,1344,201,266,884,1144,1157,1217,1343,1409,1721,795,1073,1160,1223,1226,1283,1348,1604,14,448,1027,1029,1229,1253,1426,1452,1453,1716,601,669,738,1025,1090,1136,1163,732,811,905,1241,1449,1496,1619,610,1019,1055,1152,1358,1448,1673,1713,1715,74,417,996,997,1026,1145,1188,1233,1458,1714,643,1150,1351,1663,1743,494,836,888,973,1034,1149,1231,1345,1366,1404,1474,1516,1609,1772,618,851,1047,1049,1196,1222,1322,1360,1361,1362,1368,1459,1522,1647,1730,423,453,666,709,920,921,927,931,1004,1230,1354,1470,1508,1627,1729,208,914,923,1017,1037,1042,1407,1517,1518,1567,1580,1606,352,663,915,916,926,930,1003,1072,1138,1140,1187,1489,1505,1593,1649,1674,1708,1751,499,695,703,924,972,1001,1020,1154,1352,1444,1514,1521,1596,1723,422,479,493,671,938,1005,1054,1175,1515,1767,781,937,1051,1650,1679,1681,1684,672,1052,1091,1092,1254,1445') 0.059400081634521
(642) DESCRIBE `cruisetypes` 0.0019221305847168
(643) DESCRIBE `destinations` 0.00360107421875
(644) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '2', '43', '8', '39', '53', '28', '26', '38', '55', '40', '7', '48', '30', '21', '11', '49', '45', '29', '44', '56', '34', '10', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,2,43,8,39,53,28,26,38,55,40,7,48,30,21,11,49,45,29,44,56,34,10,52,32,46') 0.0024838447570801