or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 1.551201581955

# Query Time
(1) connect 0.0018038749694824
(2) DESCRIBE `cruises` 0.0044209957122803
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71154, 80327, 81625, 66281, 66282, 66283, 66284, 66257, 66285, 74136)) ORDER BY FIND_IN_SET(id, '71154,80327,81625,66281,66282,66283,66284,66257,66285,74136') 0.0028181076049805
(4) DESCRIBE `cruises` 0.0043120384216309
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.0006110668182373
(6) DESCRIBE `ships` 0.0054380893707275
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00075078010559082
(8) DESCRIBE `ships` 0.0041038990020752
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00075006484985352
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037407875061035
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033688545227051
(12) DESCRIBE `itineraries` 0.0023419857025146
(13) DESCRIBE `ports` 0.0028650760650635
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00062108039855957
(15) DESCRIBE `ports` 0.0022640228271484
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00053095817565918
(17) DESCRIBE `ports` 0.0038549900054932
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00077104568481445
(19) DESCRIBE `sailingdates` 0.0050981044769287
(20) DESCRIBE `ports` 0.0023260116577148
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00053787231445312
(22) DESCRIBE `ports` 0.0030539035797119
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00057291984558105
(24) DESCRIBE `ports` 0.0068891048431396
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00058317184448242
(26) DESCRIBE `ports` 0.0047550201416016
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00051093101501465
(28) DESCRIBE `avid_specials` 0.0018539428710938
(29) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020430088043213
(30) DESCRIBE `cruiselines` 0.0032210350036621
(31) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00059700012207031
(32) DESCRIBE `orchid_image` 0.0022900104522705
(33) DESCRIBE `cruiselines` 0.0033719539642334
(34) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00052499771118164
(35) DESCRIBE `cruises` 0.0038959980010986
(36) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80327') 0.00051116943359375
(37) DESCRIBE `ships` 0.0040900707244873
(38) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.00065803527832031
(39) DESCRIBE `ships` 0.0042338371276855
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00062108039855957
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003819465637207
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036311149597168
(43) DESCRIBE `itineraries` 0.0019969940185547
(44) DESCRIBE `ports` 0.0023300647735596
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00052213668823242
(46) DESCRIBE `ports` 0.0021119117736816
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.0004880428314209
(48) DESCRIBE `ports` 0.002068042755127
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00045108795166016
(50) DESCRIBE `sailingdates` 0.0017859935760498
(51) DESCRIBE `ports` 0.0026850700378418
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00050616264343262
(53) DESCRIBE `ports` 0.0019600391387939
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00047516822814941
(55) DESCRIBE `ports` 0.0020010471343994
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00046682357788086
(57) DESCRIBE `ports` 0.0022549629211426
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00047898292541504
(59) DESCRIBE `avid_specials` 0.002079963684082
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80327 and class = 'Cruise') OR (item_id = 1761 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020520687103271
(61) DESCRIBE `cruiselines` 0.0031630992889404
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00062298774719238
(63) DESCRIBE `orchid_image` 0.0024800300598145
(64) DESCRIBE `cruiselines` 0.0037171840667725
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00059795379638672
(66) DESCRIBE `cruises` 0.0039219856262207
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81625') 0.00058412551879883
(68) DESCRIBE `ships` 0.0043468475341797
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 644))) 0.00076818466186523
(70) DESCRIBE `ships` 0.0065491199493408
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '644') 0.0013430118560791
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036287307739258
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(74) DESCRIBE `itineraries` 0.0021359920501709
(75) DESCRIBE `ports` 0.003154993057251
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00064206123352051
(77) DESCRIBE `ports` 0.0035979747772217
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0006718635559082
(79) DESCRIBE `ports` 0.0022528171539307
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00045490264892578
(81) DESCRIBE `sailingdates` 0.0017538070678711
(82) DESCRIBE `ports` 0.0033309459686279
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00052905082702637
(84) DESCRIBE `ports` 0.0028250217437744
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.0020031929016113
(86) DESCRIBE `ports` 0.0080339908599854
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3506))) 0.0007178783416748
(88) DESCRIBE `ports` 0.0033400058746338
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3506') 0.00054097175598145
(90) DESCRIBE `ports` 0.002932071685791
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00052905082702637
(92) DESCRIBE `ports` 0.0020840167999268
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00045585632324219
(94) DESCRIBE `avid_specials` 0.0018460750579834
(95) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81625 and class = 'Cruise') OR (item_id = 644 AND class = 'Ship') OR (item_id = 38 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.0019519329071045
(96) DESCRIBE `cruiselines` 0.0030848979949951
(97) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00060009956359863
(98) DESCRIBE `orchid_image` 0.0025131702423096
(99) DESCRIBE `cruiselines` 0.0035591125488281
(100) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00056600570678711
(101) DESCRIBE `cruises` 0.004396915435791
(102) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66281') 0.0005958080291748
(103) DESCRIBE `ships` 0.0040559768676758
(104) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00068497657775879
(105) DESCRIBE `ships` 0.0041511058807373
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.0010969638824463
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00084185600280762
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037598609924316
(109) DESCRIBE `itineraries` 0.002155065536499
(110) DESCRIBE `ports` 0.00242018699646
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00057315826416016
(112) DESCRIBE `ports` 0.0023541450500488
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00056886672973633
(114) DESCRIBE `ports` 0.0025711059570312
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00053691864013672
(116) DESCRIBE `sailingdates` 0.0025010108947754
(117) DESCRIBE `ports` 0.003303050994873
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00077295303344727
(119) DESCRIBE `ports` 0.0021889209747314
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004730224609375
(121) DESCRIBE `ports` 0.0027849674224854
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0010290145874023
(123) DESCRIBE `ports` 0.0022931098937988
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00074291229248047
(125) DESCRIBE `ports` 0.0022871494293213
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048112869262695
(127) DESCRIBE `ports` 0.0020160675048828
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00047206878662109
(129) DESCRIBE `ports` 0.0024659633636475
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00055313110351562
(131) DESCRIBE `ports` 0.001990795135498
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00044393539428711
(133) DESCRIBE `ports` 0.0019619464874268
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00046992301940918
(135) DESCRIBE `ports` 0.0020031929016113
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00056600570678711
(137) DESCRIBE `ports` 0.0019679069519043
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00049686431884766
(139) DESCRIBE `ports` 0.0020689964294434
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.0045361518859863
(141) DESCRIBE `ports` 0.006871223449707
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.0015559196472168
(143) DESCRIBE `ports` 0.0088989734649658
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.0005640983581543
(145) DESCRIBE `ports` 0.0028750896453857
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.0014450550079346
(147) DESCRIBE `ports` 0.0029311180114746
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00054788589477539
(149) DESCRIBE `ports` 0.0024540424346924
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00066399574279785
(151) DESCRIBE `ports` 0.0023939609527588
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.0031030178070068
(153) DESCRIBE `ports` 0.0026669502258301
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00099015235900879
(155) DESCRIBE `ports` 0.0041220188140869
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00057387351989746
(157) DESCRIBE `ports` 0.0029640197753906
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0005500316619873
(159) DESCRIBE `ports` 0.0021510124206543
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047397613525391
(161) DESCRIBE `ports` 0.0019371509552002
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00054287910461426
(163) DESCRIBE `ports` 0.0019879341125488
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00050902366638184
(165) DESCRIBE `ports` 0.0019397735595703
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00062298774719238
(167) DESCRIBE `ports` 0.001967191696167
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00041699409484863
(169) DESCRIBE `ports` 0.002234935760498
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00058102607727051
(171) DESCRIBE `ports` 0.0025570392608643
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00056195259094238
(173) DESCRIBE `ports` 0.0022978782653809
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00062894821166992
(175) DESCRIBE `ports` 0.0021431446075439
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00053787231445312
(177) DESCRIBE `ports` 0.002147912979126
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00054693222045898
(179) DESCRIBE `ports` 0.0021140575408936
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00068783760070801
(181) DESCRIBE `ports` 0.0019919872283936
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00049901008605957
(183) DESCRIBE `ports` 0.0020239353179932
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00044488906860352
(185) DESCRIBE `ports` 0.0019171237945557
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00057697296142578
(187) DESCRIBE `ports` 0.0026171207427979
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00063896179199219
(189) DESCRIBE `ports` 0.011055946350098
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.0011000633239746
(191) DESCRIBE `ports` 0.0032401084899902
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.0010099411010742
(193) DESCRIBE `ports` 0.0071518421173096
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00054383277893066
(195) DESCRIBE `ports` 0.0024149417877197
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00050997734069824
(197) DESCRIBE `ports` 0.0019810199737549
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049018859863281
(199) DESCRIBE `ports` 0.0023031234741211
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00053095817565918
(201) DESCRIBE `ports` 0.0020649433135986
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00050902366638184
(203) DESCRIBE `ports` 0.001971960067749
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00044012069702148
(205) DESCRIBE `ports` 0.002068042755127
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00047111511230469
(207) DESCRIBE `ports` 0.0018739700317383
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00043797492980957
(209) DESCRIBE `ports` 0.0018429756164551
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044703483581543
(211) DESCRIBE `ports` 0.0020520687103271
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044393539428711
(213) DESCRIBE `ports` 0.0018670558929443
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00049209594726562
(215) DESCRIBE `ports` 0.0019111633300781
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00048685073852539
(217) DESCRIBE `ports` 0.0022249221801758
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00058817863464355
(219) DESCRIBE `ports` 0.0022251605987549
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00073885917663574
(221) DESCRIBE `ports` 0.0032138824462891
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00064802169799805
(223) DESCRIBE `ports` 0.0022299289703369
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.0004279613494873
(225) DESCRIBE `ports` 0.0018320083618164
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00045180320739746
(227) DESCRIBE `ports` 0.0025639533996582
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00051784515380859
(229) DESCRIBE `ports` 0.0045239925384521
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00055503845214844
(231) DESCRIBE `ports` 0.0020351409912109
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0017898082733154
(233) DESCRIBE `ports` 0.0026900768280029
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.0015501976013184
(235) DESCRIBE `ports` 0.002716064453125
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00045990943908691
(237) DESCRIBE `avid_specials` 0.0016529560089111
(238) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66281 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019521713256836
(239) DESCRIBE `cruiselines` 0.002755880355835
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005490779876709
(241) DESCRIBE `orchid_image` 0.0022101402282715
(242) DESCRIBE `cruiselines` 0.0029070377349854
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050497055053711
(244) DESCRIBE `cruises` 0.0035998821258545
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66282') 0.00057315826416016
(246) DESCRIBE `ships` 0.0044040679931641
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00073599815368652
(248) DESCRIBE `ships` 0.0040950775146484
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.0005650520324707
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036716461181641
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046110153198242
(252) DESCRIBE `itineraries` 0.0021259784698486
(253) DESCRIBE `ports` 0.0024750232696533
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00063991546630859
(255) DESCRIBE `ports` 0.0021560192108154
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00063204765319824
(257) DESCRIBE `ports` 0.0024189949035645
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00056815147399902
(259) DESCRIBE `sailingdates` 0.0020101070404053
(260) DESCRIBE `ports` 0.002310037612915
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00076198577880859
(262) DESCRIBE `ports` 0.0024869441986084
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00049209594726562
(264) DESCRIBE `ports` 0.0020139217376709
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0007321834564209
(266) DESCRIBE `ports` 0.0020270347595215
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00064206123352051
(268) DESCRIBE `ports` 0.0034608840942383
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00054311752319336
(270) DESCRIBE `ports` 0.0020527839660645
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00045609474182129
(272) DESCRIBE `ports` 0.0020079612731934
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00056695938110352
(274) DESCRIBE `ports` 0.0090558528900146
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00083279609680176
(276) DESCRIBE `ports` 0.0032680034637451
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00053691864013672
(278) DESCRIBE `ports` 0.0022730827331543
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00051689147949219
(280) DESCRIBE `ports` 0.0024189949035645
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00062203407287598
(282) DESCRIBE `ports` 0.0023891925811768
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00050806999206543
(284) DESCRIBE `ports` 0.0023319721221924
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00054192543029785
(286) DESCRIBE `ports` 0.0020701885223389
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00054383277893066
(288) DESCRIBE `ports` 0.0021650791168213
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00052094459533691
(290) DESCRIBE `ports` 0.0021669864654541
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00049090385437012
(292) DESCRIBE `ports` 0.0022590160369873
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.0042729377746582
(294) DESCRIBE `ports` 0.0026860237121582
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.0011990070343018
(296) DESCRIBE `ports` 0.0077338218688965
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.0023751258850098
(298) DESCRIBE `ports` 0.0026659965515137
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00054097175598145
(300) DESCRIBE `ports` 0.0077121257781982
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00066494941711426
(302) DESCRIBE `ports` 0.0037539005279541
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047183036804199
(304) DESCRIBE `ports` 0.0021460056304932
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052404403686523
(306) DESCRIBE `ports` 0.0020661354064941
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047206878662109
(308) DESCRIBE `ports` 0.0020170211791992
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00051689147949219
(310) DESCRIBE `ports` 0.0021011829376221
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00052785873413086
(312) DESCRIBE `ports` 0.0021839141845703
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00051116943359375
(314) DESCRIBE `ports` 0.0019521713256836
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00043392181396484
(316) DESCRIBE `ports` 0.0019340515136719
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00051403045654297
(318) DESCRIBE `ports` 0.0019800662994385
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00047588348388672
(320) DESCRIBE `ports` 0.0020830631256104
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00055384635925293
(322) DESCRIBE `ports` 0.002331018447876
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00057697296142578
(324) DESCRIBE `ports` 0.0020649433135986
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00053691864013672
(326) DESCRIBE `ports` 0.0020899772644043
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00043797492980957
(328) DESCRIBE `ports` 0.0019290447235107
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00046706199645996
(330) DESCRIBE `ports` 0.0020058155059814
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00052690505981445
(332) DESCRIBE `ports` 0.0024950504302979
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00058388710021973
(334) DESCRIBE `ports` 0.0021181106567383
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00048995018005371
(336) DESCRIBE `ports` 0.0019588470458984
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0005040168762207
(338) DESCRIBE `ports` 0.0021309852600098
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00052595138549805
(340) DESCRIBE `ports` 0.0021011829376221
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0020360946655273
(342) DESCRIBE `ports` 0.0027689933776855
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00076484680175781
(344) DESCRIBE `ports` 0.0020971298217773
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0005180835723877
(346) DESCRIBE `ports` 0.0020651817321777
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00050616264343262
(348) DESCRIBE `ports` 0.0020360946655273
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00051188468933105
(350) DESCRIBE `ports` 0.0020880699157715
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00046300888061523
(352) DESCRIBE `ports` 0.0019030570983887
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049996376037598
(354) DESCRIBE `ports` 0.0021560192108154
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00048398971557617
(356) DESCRIBE `ports` 0.0020771026611328
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00050091743469238
(358) DESCRIBE `ports` 0.0020029544830322
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00063204765319824
(360) DESCRIBE `ports` 0.0020980834960938
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00051307678222656
(362) DESCRIBE `ports` 0.0019278526306152
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00072813034057617
(364) DESCRIBE `ports` 0.0021431446075439
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00061798095703125
(366) DESCRIBE `ports` 0.0026369094848633
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00065088272094727
(368) DESCRIBE `ports` 0.0021531581878662
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00054407119750977
(370) DESCRIBE `ports` 0.0028798580169678
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00068116188049316
(372) DESCRIBE `avid_specials` 0.0019991397857666
(373) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66282 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019960403442383
(374) DESCRIBE `cruiselines` 0.0029821395874023
(375) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00061583518981934
(376) DESCRIBE `orchid_image` 0.0034689903259277
(377) DESCRIBE `cruiselines` 0.0039680004119873
(378) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00090599060058594
(379) DESCRIBE `cruises` 0.0045928955078125
(380) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66283') 0.00057315826416016
(381) DESCRIBE `ships` 0.0061337947845459
(382) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.0010621547698975
(383) DESCRIBE `ships` 0.0069141387939453
(384) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00053119659423828
(385) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040912628173828
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032377243041992
(387) DESCRIBE `itineraries` 0.002112865447998
(388) DESCRIBE `ports` 0.0022480487823486
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00047397613525391
(390) DESCRIBE `ports` 0.0022192001342773
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00065112113952637
(392) DESCRIBE `ports` 0.0021219253540039
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00085806846618652
(394) DESCRIBE `sailingdates` 0.0018470287322998
(395) DESCRIBE `ports` 0.002249002456665
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0006718635559082
(397) DESCRIBE `ports` 0.0021059513092041
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00049805641174316
(399) DESCRIBE `ports` 0.0021519660949707
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00058698654174805
(401) DESCRIBE `ports` 0.0021400451660156
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00041317939758301
(403) DESCRIBE `ports` 0.001788854598999
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00052499771118164
(405) DESCRIBE `ports` 0.0020461082458496
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00049114227294922
(407) DESCRIBE `ports` 0.0017271041870117
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00077080726623535
(409) DESCRIBE `ports` 0.0023469924926758
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00049090385437012
(411) DESCRIBE `ports` 0.0019707679748535
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00049304962158203
(413) DESCRIBE `ports` 0.0020468235015869
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00045084953308105
(415) DESCRIBE `ports` 0.0020341873168945
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00050806999206543
(417) DESCRIBE `ports` 0.002051830291748
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00043296813964844
(419) DESCRIBE `ports` 0.0019879341125488
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00050616264343262
(421) DESCRIBE `ports` 0.0021848678588867
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00047087669372559
(423) DESCRIBE `ports` 0.0020248889923096
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.0005340576171875
(425) DESCRIBE `ports` 0.0022819042205811
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00059199333190918
(427) DESCRIBE `ports` 0.0022611618041992
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00053787231445312
(429) DESCRIBE `ports` 0.0021610260009766
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00045990943908691
(431) DESCRIBE `ports` 0.0022010803222656
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00057196617126465
(433) DESCRIBE `ports` 0.0022392272949219
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00051283836364746
(435) DESCRIBE `ports` 0.0022330284118652
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00055193901062012
(437) DESCRIBE `ports` 0.0031948089599609
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00052380561828613
(439) DESCRIBE `ports` 0.0027909278869629
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00055980682373047
(441) DESCRIBE `ports` 0.002140998840332
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00050806999206543
(443) DESCRIBE `ports` 0.0019538402557373
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00051498413085938
(445) DESCRIBE `ports` 0.0018970966339111
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00046491622924805
(447) DESCRIBE `ports` 0.0019221305847168
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00047898292541504
(449) DESCRIBE `ports` 0.0019137859344482
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00050592422485352
(451) DESCRIBE `ports` 0.0019080638885498
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00049996376037598
(453) DESCRIBE `ports` 0.0019948482513428
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00045180320739746
(455) DESCRIBE `ports` 0.0019361972808838
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00047516822814941
(457) DESCRIBE `ports` 0.0020370483398438
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.0004889965057373
(459) DESCRIBE `ports` 0.0020349025726318
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.0004580020904541
(461) DESCRIBE `ports` 0.0020461082458496
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00047612190246582
(463) DESCRIBE `ports` 0.0020170211791992
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00047397613525391
(465) DESCRIBE `ports` 0.0020458698272705
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.0005638599395752
(467) DESCRIBE `ports` 0.0020110607147217
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00052499771118164
(469) DESCRIBE `ports` 0.0018727779388428
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00042009353637695
(471) DESCRIBE `ports` 0.001802921295166
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00045609474182129
(473) DESCRIBE `ports` 0.0017449855804443
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0004580020904541
(475) DESCRIBE `ports` 0.0017261505126953
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040888786315918
(477) DESCRIBE `ports` 0.0018248558044434
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035881996154785
(479) DESCRIBE `ports` 0.002410888671875
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00057506561279297
(481) DESCRIBE `ports` 0.0023379325866699
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00059413909912109
(483) DESCRIBE `ports` 0.002161979675293
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00050806999206543
(485) DESCRIBE `ports` 0.0021059513092041
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00047802925109863
(487) DESCRIBE `ports` 0.0019290447235107
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00057697296142578
(489) DESCRIBE `ports` 0.002065896987915
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00055503845214844
(491) DESCRIBE `avid_specials` 0.0019741058349609
(492) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66283 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002032995223999
(493) DESCRIBE `cruiselines` 0.0027849674224854
(494) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005948543548584
(495) DESCRIBE `orchid_image` 0.0021030902862549
(496) DESCRIBE `cruiselines` 0.0026748180389404
(497) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050210952758789
(498) DESCRIBE `cruises` 0.0043799877166748
(499) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66284') 0.00072002410888672
(500) DESCRIBE `ships` 0.0041999816894531
(501) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00064182281494141
(502) DESCRIBE `ships` 0.0041389465332031
(503) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00049996376037598
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(506) DESCRIBE `itineraries` 0.0016250610351562
(507) DESCRIBE `ports` 0.0020151138305664
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005030632019043
(509) DESCRIBE `ports` 0.0019950866699219
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00048303604125977
(511) DESCRIBE `ports` 0.0017850399017334
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003199577331543
(513) DESCRIBE `sailingdates` 0.0016720294952393
(514) DESCRIBE `ports` 0.002032995223999
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005640983581543
(516) DESCRIBE `ports` 0.0021281242370605
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00055909156799316
(518) DESCRIBE `ports` 0.0018219947814941
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00053787231445312
(520) DESCRIBE `ports` 0.002047061920166
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00047183036804199
(522) DESCRIBE `ports` 0.0019299983978271
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048208236694336
(524) DESCRIBE `ports` 0.0022540092468262
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00050187110900879
(526) DESCRIBE `ports` 0.0020060539245605
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0005347728729248
(528) DESCRIBE `ports` 0.0020101070404053
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00045919418334961
(530) DESCRIBE `ports` 0.0019629001617432
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00055909156799316
(532) DESCRIBE `ports` 0.0019290447235107
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00049901008605957
(534) DESCRIBE `ports` 0.00223708152771
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00064396858215332
(536) DESCRIBE `ports` 0.0020239353179932
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00052404403686523
(538) DESCRIBE `ports` 0.0020031929016113
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00051593780517578
(540) DESCRIBE `ports` 0.0019748210906982
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00049304962158203
(542) DESCRIBE `ports` 0.0018410682678223
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00049996376037598
(544) DESCRIBE `ports` 0.0019919872283936
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00048708915710449
(546) DESCRIBE `ports` 0.0021340847015381
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00060796737670898
(548) DESCRIBE `ports` 0.0020928382873535
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00052595138549805
(550) DESCRIBE `ports` 0.0020909309387207
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00055408477783203
(552) DESCRIBE `ports` 0.0020349025726318
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00049591064453125
(554) DESCRIBE `ports` 0.0021100044250488
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00053000450134277
(556) DESCRIBE `ports` 0.0020709037780762
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00048589706420898
(558) DESCRIBE `ports` 0.0020358562469482
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00053000450134277
(560) DESCRIBE `ports` 0.0020670890808105
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047588348388672
(562) DESCRIBE `ports` 0.0020959377288818
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.0005340576171875
(564) DESCRIBE `ports` 0.0019979476928711
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00045490264892578
(566) DESCRIBE `ports` 0.0021018981933594
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00052189826965332
(568) DESCRIBE `ports` 0.0020241737365723
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00048112869262695
(570) DESCRIBE `ports` 0.0020651817321777
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00056600570678711
(572) DESCRIBE `ports` 0.0021419525146484
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00049901008605957
(574) DESCRIBE `ports` 0.0021398067474365
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00054001808166504
(576) DESCRIBE `ports` 0.0019838809967041
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00045299530029297
(578) DESCRIBE `ports` 0.0020828247070312
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00049591064453125
(580) DESCRIBE `ports` 0.0020589828491211
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00046110153198242
(582) DESCRIBE `ports` 0.0016498565673828
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00050616264343262
(584) DESCRIBE `ports` 0.0019590854644775
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00045013427734375
(586) DESCRIBE `ports` 0.001939058303833
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00061798095703125
(588) DESCRIBE `ports` 0.001835823059082
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00046801567077637
(590) DESCRIBE `ports` 0.0020530223846436
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00055193901062012
(592) DESCRIBE `ports` 0.0021910667419434
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0005190372467041
(594) DESCRIBE `ports` 0.0040309429168701
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00099396705627441
(596) DESCRIBE `ports` 0.0048580169677734
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00065422058105469
(598) DESCRIBE `ports` 0.0019819736480713
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00060701370239258
(600) DESCRIBE `ports` 0.0021090507507324
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00059795379638672
(602) DESCRIBE `ports` 0.0020270347595215
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00053000450134277
(604) DESCRIBE `ports` 0.0019388198852539
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00040793418884277
(606) DESCRIBE `avid_specials` 0.0017940998077393
(607) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66284 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019569396972656
(608) DESCRIBE `cruiselines` 0.002899169921875
(609) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005950927734375
(610) DESCRIBE `orchid_image` 0.0023648738861084
(611) DESCRIBE `cruiselines` 0.0031611919403076
(612) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00073790550231934
(613) DESCRIBE `cruises` 0.012232065200806
(614) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66257') 0.0011138916015625
(615) DESCRIBE `ships` 0.024672985076904
(616) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.000823974609375
(617) DESCRIBE `ships` 0.0041708946228027
(618) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00054121017456055
(619) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037503242492676
(620) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036215782165527
(621) DESCRIBE `itineraries` 0.0021059513092041
(622) DESCRIBE `ports` 0.0022449493408203
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00053095817565918
(624) DESCRIBE `ports` 0.0018939971923828
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00095295906066895
(626) DESCRIBE `ports` 0.0015568733215332
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00046110153198242
(628) DESCRIBE `sailingdates` 0.0018069744110107
(629) DESCRIBE `ports` 0.0021741390228271
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00060296058654785
(631) DESCRIBE `ports` 0.0019369125366211
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00045204162597656
(633) DESCRIBE `ports` 0.0018930435180664
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00049114227294922
(635) DESCRIBE `ports` 0.0018970966339111
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00043296813964844
(637) DESCRIBE `ports` 0.001849889755249
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047492980957031
(639) DESCRIBE `ports` 0.0019559860229492
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00045299530029297
(641) DESCRIBE `ports` 0.0019011497497559
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047516822814941
(643) DESCRIBE `ports` 0.0018899440765381
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041890144348145
(645) DESCRIBE `ports` 0.0018100738525391
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00047397613525391
(647) DESCRIBE `ports` 0.0018520355224609
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00042390823364258
(649) DESCRIBE `ports` 0.0019588470458984
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00058889389038086
(651) DESCRIBE `ports` 0.0019221305847168
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00050592422485352
(653) DESCRIBE `ports` 0.0018620491027832
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00046300888061523
(655) DESCRIBE `ports` 0.001774787902832
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00038790702819824
(657) DESCRIBE `ports` 0.0019059181213379
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00049686431884766
(659) DESCRIBE `ports` 0.0019571781158447
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00049781799316406
(661) DESCRIBE `ports` 0.00201416015625
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00050520896911621
(663) DESCRIBE `ports` 0.0018651485443115
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00039386749267578
(665) DESCRIBE `ports` 0.0017390251159668
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00045180320739746
(667) DESCRIBE `ports` 0.0019102096557617
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00034308433532715
(669) DESCRIBE `ports` 0.0015439987182617
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00044393539428711
(671) DESCRIBE `ports` 0.0017428398132324
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00040817260742188
(673) DESCRIBE `ports` 0.001924991607666
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00045108795166016
(675) DESCRIBE `ports` 0.0016999244689941
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00037884712219238
(677) DESCRIBE `ports` 0.0015928745269775
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00056791305541992
(679) DESCRIBE `ports` 0.0014791488647461
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00031208992004395
(681) DESCRIBE `ports` 0.0015099048614502
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.0003509521484375
(683) DESCRIBE `ports` 0.0016269683837891
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00048398971557617
(685) DESCRIBE `ports` 0.0019991397857666
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00049018859863281
(687) DESCRIBE `ports` 0.0017051696777344
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00037503242492676
(689) DESCRIBE `ports` 0.0016219615936279
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00043821334838867
(691) DESCRIBE `ports` 0.0016641616821289
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00045204162597656
(693) DESCRIBE `ports` 0.0020530223846436
(694) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00048398971557617
(695) DESCRIBE `ports` 0.0018689632415771
(696) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00042414665222168
(697) DESCRIBE `ports` 0.0016090869903564
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00046491622924805
(699) DESCRIBE `ports` 0.0016839504241943
(700) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00039005279541016
(701) DESCRIBE `ports` 0.0016639232635498
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00035500526428223
(703) DESCRIBE `ports` 0.0015308856964111
(704) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00030803680419922
(705) DESCRIBE `ports` 0.0013217926025391
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00034713745117188
(707) DESCRIBE `ports` 0.0016710758209229
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00033998489379883
(709) DESCRIBE `ports` 0.0014030933380127
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034403800964355
(711) DESCRIBE `ports` 0.0014879703521729
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033020973205566
(713) DESCRIBE `ports` 0.0013461112976074
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033307075500488
(715) DESCRIBE `ports` 0.0014438629150391
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037288665771484
(717) DESCRIBE `avid_specials` 0.0012609958648682
(718) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66257 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015609264373779
(719) DESCRIBE `cruiselines` 0.0022149085998535
(720) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043296813964844
(721) DESCRIBE `orchid_image` 0.0017979145050049
(722) DESCRIBE `cruiselines` 0.0024409294128418
(723) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00036406517028809
(724) DESCRIBE `cruises` 0.0031909942626953
(725) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66285') 0.00047397613525391
(726) DESCRIBE `ships` 0.0035600662231445
(727) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00055503845214844
(728) DESCRIBE `ships` 0.0038208961486816
(729) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00045490264892578
(730) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(731) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(732) DESCRIBE `itineraries` 0.0019049644470215
(733) DESCRIBE `ports` 0.002086877822876
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0006721019744873
(735) DESCRIBE `ports` 0.0019440650939941
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003969669342041
(737) DESCRIBE `ports` 0.0018880367279053
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00046110153198242
(739) DESCRIBE `sailingdates` 0.001539945602417
(740) DESCRIBE `ports` 0.0023329257965088
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00085997581481934
(742) DESCRIBE `ports` 0.002234935760498
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004432201385498
(744) DESCRIBE `ports` 0.0015890598297119
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00047087669372559
(746) DESCRIBE `ports` 0.0017189979553223
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00041508674621582
(748) DESCRIBE `ports` 0.0018100738525391
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00051689147949219
(750) DESCRIBE `ports` 0.0020580291748047
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00043010711669922
(752) DESCRIBE `ports` 0.0020930767059326
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048494338989258
(754) DESCRIBE `ports` 0.002216100692749
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00040912628173828
(756) DESCRIBE `ports` 0.0019278526306152
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00063610076904297
(758) DESCRIBE `ports` 0.0020999908447266
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00043106079101562
(760) DESCRIBE `ports` 0.0019419193267822
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00047993659973145
(762) DESCRIBE `ports` 0.0019900798797607
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00051498413085938
(764) DESCRIBE `ports` 0.0021770000457764
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00061392784118652
(766) DESCRIBE `ports` 0.0021340847015381
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00047588348388672
(768) DESCRIBE `ports` 0.0019149780273438
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00050997734069824
(770) DESCRIBE `ports` 0.0020921230316162
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00045514106750488
(772) DESCRIBE `ports` 0.002129077911377
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00054788589477539
(774) DESCRIBE `ports` 0.0021109580993652
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00052499771118164
(776) DESCRIBE `ports` 0.0022070407867432
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00064992904663086
(778) DESCRIBE `ports` 0.0023589134216309
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.0006098747253418
(780) DESCRIBE `ports` 0.0021851062774658
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00061893463134766
(782) DESCRIBE `ports` 0.0025811195373535
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00054121017456055
(784) DESCRIBE `ports` 0.0020351409912109
(785) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0005500316619873
(786) DESCRIBE `ports` 0.0020179748535156
(787) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047898292541504
(788) DESCRIBE `ports` 0.0020031929016113
(789) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.0005791187286377
(790) DESCRIBE `ports` 0.0023980140686035
(791) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00049996376037598
(792) DESCRIBE `ports` 0.0023829936981201
(793) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00096487998962402
(794) DESCRIBE `ports` 0.0021309852600098
(795) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00049901008605957
(796) DESCRIBE `ports` 0.0022029876708984
(797) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00053691864013672
(798) DESCRIBE `ports` 0.0021500587463379
(799) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00064587593078613
(800) DESCRIBE `ports` 0.0020477771759033
(801) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00054597854614258
(802) DESCRIBE `ports` 0.0021591186523438
(803) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00054192543029785
(804) DESCRIBE `ports` 0.0020167827606201
(805) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.0005490779876709
(806) DESCRIBE `ports` 0.0019540786743164
(807) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00052213668823242
(808) DESCRIBE `ports` 0.0020339488983154
(809) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00059700012207031
(810) DESCRIBE `ports` 0.0020599365234375
(811) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00052905082702637
(812) DESCRIBE `ports` 0.0021100044250488
(813) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00060701370239258
(814) DESCRIBE `ports` 0.0020811557769775
(815) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00057196617126465
(816) DESCRIBE `ports` 0.0020248889923096
(817) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00058984756469727
(818) DESCRIBE `ports` 0.0021181106567383
(819) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00059103965759277
(820) DESCRIBE `ports` 0.001953125
(821) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052189826965332
(822) DESCRIBE `ports` 0.001884937286377
(823) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00042390823364258
(824) DESCRIBE `avid_specials` 0.0016469955444336
(825) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66285 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 40 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019268989562988
(826) DESCRIBE `cruiselines` 0.0028510093688965
(827) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00056791305541992
(828) DESCRIBE `orchid_image` 0.0022141933441162
(829) DESCRIBE `cruiselines` 0.0026500225067139
(830) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047802925109863
(831) DESCRIBE `cruises` 0.0032720565795898
(832) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74136') 0.00042295455932617
(833) DESCRIBE `ships` 0.0034308433532715
(834) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.00058984756469727
(835) DESCRIBE `ships` 0.0039567947387695
(836) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00048303604125977
(837) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042009353637695
(838) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(839) DESCRIBE `itineraries` 0.0021021366119385
(840) DESCRIBE `ports` 0.0023031234741211
(841) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00055193901062012
(842) DESCRIBE `ports` 0.0022249221801758
(843) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00057792663574219
(844) DESCRIBE `ports` 0.0033681392669678
(845) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00090694427490234
(846) DESCRIBE `sailingdates` 0.0019540786743164
(847) DESCRIBE `ports` 0.0021929740905762
(848) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00054287910461426
(849) DESCRIBE `ports` 0.0020151138305664
(850) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00049686431884766
(851) DESCRIBE `ports` 0.0018630027770996
(852) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00062012672424316
(853) DESCRIBE `ports` 0.0021519660949707
(854) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00054192543029785
(855) DESCRIBE `ports` 0.0018157958984375
(856) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00046110153198242
(857) DESCRIBE `ports` 0.0023829936981201
(858) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.0006101131439209
(859) DESCRIBE `ports` 0.0019750595092773
(860) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.0005488395690918
(861) DESCRIBE `ports` 0.0018742084503174
(862) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00043392181396484
(863) DESCRIBE `ports` 0.0018410682678223
(864) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00043416023254395
(865) DESCRIBE `ports` 0.0019190311431885
(866) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00047492980957031
(867) DESCRIBE `ports` 0.0021390914916992
(868) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00051021575927734
(869) DESCRIBE `ports` 0.0025231838226318
(870) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00048494338989258
(871) DESCRIBE `ports` 0.0019149780273438
(872) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00051403045654297
(873) DESCRIBE `ports` 0.0019180774688721
(874) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0004580020904541
(875) DESCRIBE `ports` 0.0025858879089355
(876) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00056004524230957
(877) DESCRIBE `ports` 0.0022051334381104
(878) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00050997734069824
(879) DESCRIBE `ports` 0.0031092166900635
(880) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00058603286743164
(881) DESCRIBE `ports` 0.0025300979614258
(882) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00081086158752441
(883) DESCRIBE `ports` 0.0031111240386963
(884) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00064182281494141
(885) DESCRIBE `ports` 0.0025351047515869
(886) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00054287910461426
(887) DESCRIBE `ports` 0.0020148754119873
(888) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00049495697021484
(889) DESCRIBE `ports` 0.0020921230316162
(890) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00034809112548828
(891) DESCRIBE `ports` 0.0015349388122559
(892) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042104721069336
(893) DESCRIBE `ports` 0.0017318725585938
(894) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00065398216247559
(895) DESCRIBE `ports` 0.0020151138305664
(896) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.0005190372467041
(897) DESCRIBE `ports` 0.0018479824066162
(898) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.00040292739868164
(899) DESCRIBE `ports` 0.0018808841705322
(900) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00054097175598145
(901) DESCRIBE `ports` 0.0019149780273438
(902) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00043392181396484
(903) DESCRIBE `ports` 0.0029599666595459
(904) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.0011131763458252
(905) DESCRIBE `ports` 0.0028760433197021
(906) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00055193901062012
(907) DESCRIBE `ports` 0.0021350383758545
(908) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00047087669372559
(909) DESCRIBE `ports` 0.0017650127410889
(910) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00041079521179199
(911) DESCRIBE `avid_specials` 0.0015249252319336
(912) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74136 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 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.0018939971923828
(913) DESCRIBE `cruiselines` 0.0030360221862793
(914) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00059795379638672
(915) DESCRIBE `orchid_image` 0.0022528171539307
(916) DESCRIBE `cruiselines` 0.0029768943786621
(917) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00053310394287109
(918) DESCRIBE `cruiselines` 0.0030391216278076
(919) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '183', '19', '23', '12', '7', '20', '131', '18', '8', '144', '171', '221', '31', '103', '101', '268', '15', '232', '156', '96', '258', '239', '50', '251', '29', '206', '33', '191', '114', '91', '212', '14', '24', '120', '28', '37', '187', '16', '170', '262', '49', '256', '36', '204', '110', '47', '208', '195', '240', '146', '220', '181', '153', '118', '174', '229', '30', '151', '88', '108', '128', '141', '159', '35', '216', '236', '168', '196', '4', '249', '38', '200', '264', '90', '211', '238', '73', '225', '140', '113', '147', '39', '275', '57', '132', '184', '59', '213', '48', '257', '64', '276', '261', '182', '219', '230', '115', '188', '237', '95', '180', '231', '248', '52', '116', '266', '209', '105', '82', '235', '244', '62', '134', '119', '177', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,26,183,19,23,12,7,20,131,18,8,144,171,221,31,103,101,268,15,232,156,96,258,239,50,251,29,206,33,191,114,91,212,14,24,120,28,37,187,16,170,262,49,256,36,204,110,47,208,195,240,146,220,181,153,118,174,229,30,151,88,108,128,141,159,35,216,236,168,196,4,249,38,200,264,90,211,238,73,225,140,113,147,39,275,57,132,184,59,213,48,257,64,276,261,182,219,230,115,188,237,95,180,231,248,52,116,266,209,105,82,235,244,62,134,119,177,210,224,245') 0.0085840225219727
(920) DESCRIBE `ships` 0.0040979385375977
(921) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1324', '1555', '1272', '517', '1794', '780', '986', '974', '1032', '258', '1292', '22', '461', '21', '797', '393', '330', '28', '977', '207', '1599', '1205', '480', '349', '11', '10', '439', '1291', '737', '333', '1010', '9', '404', '739', '1199', '1588', '1135', '1417', '265', '726', '817', '1677', '14', '855', '24', '882', '25', '770', '454', '711', '1607', '3', '113', '731', '1067', '1481', '859', '1359', '1372', '34', '38', '31', '37', '657', '837', '378', '585', '1461', '1744', '985', '1237', '1768', '1239', '542', '1163', '66', '1526', '1413', '748', '390', '1320', '1411', '1579', '1323', '1402', '1424', '332', '526', '970', '1410', '1419', '1420', '1422', '1423', '1594', '43', '573', '327', '854', '1418', '1421', '582', '1773', '39', '407', '1012', '1454', '30', '36', '590', '958', '27', '1013', '1586', '674', '791', '792', '1284', '1415', '1308', '580', '1303', '1326', '1327', '84', '114', '1552', '441', '1183', '335', '455', '1184', '1587', '1682', '35', '1245', '1193', '1236', '1742', '386', '162', '1348', '160', '325', '722', '1412', '385', '639', '434', '521', '601', '1408', '1678', '81', '1168', '452', '683', '852', '857', '1172', '1215', '1382', '1501', '858', '1021', '1176', '775', '1019', '1289', '1376', '119', '1574', '78', '201', '338', '658', '1008', '1160', '1405', '1716', '285', '673', '766', '1159', '1217', '1229', '1604', '1373', '1426', '1782', '610', '776', '1095', '1226', '1743', '111', '462', '850', '1137', '1141', '1711', '69', '211', '644', '678', '1136', '1319', '1325', '1448', '163', '286', '1383', '1384', '1628', '45', '253', '520', '851', '1358', '403', '818', '266', '314', '651', '749', '1068', '1259', '1266', '1455', '151', '968', '1458', '1569', '1630', '451', '508', '1108', '1632', '348', '467', '626', '1516', '1572', '4', '150', '1302', '1330', '1360', '1361', '1362', '63', '324', '375', '405', '869', '966', '1260', '1368', '1459', '1627', '70', '148', '389', '421', '485', '616', '663', '768', '944', '1639', '1751', '1760', '116', '262', '291', '553', '885', '1064', '1148', '1517', '1562', '1672', '1708', '108', '1301', '1322', '123', '340', '1139', '1195', '1614', '1721', '124', '287', '1343', '1452', '1521', '1580', '1581', '98', '703', '784', '954', '1088', '1717', '198', '883', '1020', '152', '290', '1212', '1321', '1575', '1724', '635', '652', '1208', '1486', '1492', '1611', '1722', '1750', '1781', '516', '1344', '1601', '147', '483', '1615', '394', '401', '796', '1150', '1398', '1714', '1738', '341', '1143', '1231', '1269', '1437', '1445', '1522', '223', '406', '559', '1230', '1496', '1539', '1771', '1040', '1075', '1268', '149', '886', '1262', '1444', '1571', '1679', '1681', '547', '717', '1151', '1270', '1557', '1593', '1673', '1684', '545', '656', '704', '716', '1367', '982', '1254', '1318', '1676', '74', '105', '761', '1740', '1766', '494', '1043', '1073', '1514', '1518', '1645', '75', '205', '574', '1144', '1157', '1218', '1566', '1704', '1767', '751', '790', '1223', '1561', '1728', '715', '1027', '1029', '1063', '1213', '1389', '82', '351', '627', '795', '808', '1082', '1453', '1471', '1540', '93', '212', '687', '868', '1025', '1090', '1146', '1158', '1283', '1612', '1613', '1706', '1709', '1729', '1772', '479', '503', '823', '1055', '1713', '1715', '665', '905', '996', '1026', '1214', '1233', '1282', '1316', '1342', '1515', '1791', '493', '767', '1145', '1188', '1297', '1409', '1783', '884', '888', '973', '1034', '1089', '1149', '1156', '1341', '1351', '1366', '1404', '1609', '695', '707', '979', '988', '1024', '1049', '1155', '1196', '1216', '1222', '1345', '1647', '1710', '1730', '417', '666', '685', '920', '921', '927', '931', '1047', '1113', '1296', '1311', '1340', '1354', '1788')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1324,1555,1272,517,1794,780,986,974,1032,258,1292,22,461,21,797,393,330,28,977,207,1599,1205,480,349,11,10,439,1291,737,333,1010,9,404,739,1199,1588,1135,1417,265,726,817,1677,14,855,24,882,25,770,454,711,1607,3,113,731,1067,1481,859,1359,1372,34,38,31,37,657,837,378,585,1461,1744,985,1237,1768,1239,542,1163,66,1526,1413,748,390,1320,1411,1579,1323,1402,1424,332,526,970,1410,1419,1420,1422,1423,1594,43,573,327,854,1418,1421,582,1773,39,407,1012,1454,30,36,590,958,27,1013,1586,674,791,792,1284,1415,1308,580,1303,1326,1327,84,114,1552,441,1183,335,455,1184,1587,1682,35,1245,1193,1236,1742,386,162,1348,160,325,722,1412,385,639,434,521,601,1408,1678,81,1168,452,683,852,857,1172,1215,1382,1501,858,1021,1176,775,1019,1289,1376,119,1574,78,201,338,658,1008,1160,1405,1716,285,673,766,1159,1217,1229,1604,1373,1426,1782,610,776,1095,1226,1743,111,462,850,1137,1141,1711,69,211,644,678,1136,1319,1325,1448,163,286,1383,1384,1628,45,253,520,851,1358,403,818,266,314,651,749,1068,1259,1266,1455,151,968,1458,1569,1630,451,508,1108,1632,348,467,626,1516,1572,4,150,1302,1330,1360,1361,1362,63,324,375,405,869,966,1260,1368,1459,1627,70,148,389,421,485,616,663,768,944,1639,1751,1760,116,262,291,553,885,1064,1148,1517,1562,1672,1708,108,1301,1322,123,340,1139,1195,1614,1721,124,287,1343,1452,1521,1580,1581,98,703,784,954,1088,1717,198,883,1020,152,290,1212,1321,1575,1724,635,652,1208,1486,1492,1611,1722,1750,1781,516,1344,1601,147,483,1615,394,401,796,1150,1398,1714,1738,341,1143,1231,1269,1437,1445,1522,223,406,559,1230,1496,1539,1771,1040,1075,1268,149,886,1262,1444,1571,1679,1681,547,717,1151,1270,1557,1593,1673,1684,545,656,704,716,1367,982,1254,1318,1676,74,105,761,1740,1766,494,1043,1073,1514,1518,1645,75,205,574,1144,1157,1218,1566,1704,1767,751,790,1223,1561,1728,715,1027,1029,1063,1213,1389,82,351,627,795,808,1082,1453,1471,1540,93,212,687,868,1025,1090,1146,1158,1283,1612,1613,1706,1709,1729,1772,479,503,823,1055,1713,1715,665,905,996,1026,1214,1233,1282,1316,1342,1515,1791,493,767,1145,1188,1297,1409,1783,884,888,973,1034,1089,1149,1156,1341,1351,1366,1404,1609,695,707,979,988,1024,1049,1155,1196,1216,1222,1345,1647,1710,1730,417,666,685,920,921,927,931,1047,1113,1296,1311,1340,1354,1788') 0.078574895858765
(922) DESCRIBE `cruisetypes` 0.0019080638885498
(923) DESCRIBE `destinations` 0.0024192333221436
(924) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '9', '37', '43', '2', '8', '39', '44', '53', '55', '26', '28', '38', '49', '11', '21', '40', '7', '48', '56', '46', '30', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,9,37,43,2,8,39,44,53,55,26,28,38,49,11,21,40,7,48,56,46,30,29,45,34,10,52,32') 0.0026488304138184