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

Total elapsed time: 0.70953035354614

# Query Time
(1) connect 0.00092196464538574
(2) DESCRIBE `cruises` 0.0034849643707275
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82242, 75704, 75710, 75711, 75716, 75705, 75714, 75717, 75706, 75715)) ORDER BY FIND_IN_SET(id, '82242,75704,75710,75711,75716,75705,75714,75717,75706,75715') 0.0017549991607666
(4) DESCRIBE `cruises` 0.0028910636901855
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82242') 0.00025796890258789
(6) DESCRIBE `ships` 0.0025110244750977
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00033307075500488
(8) DESCRIBE `ships` 0.002744197845459
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00037002563476562
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003209114074707
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(12) DESCRIBE `itineraries` 0.0011980533599854
(13) DESCRIBE `ports` 0.0012919902801514
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00065779685974121
(15) DESCRIBE `ports` 0.0010988712310791
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027298927307129
(17) DESCRIBE `ports` 0.00130295753479
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0
(19) DESCRIBE `sailingdates` 0.0036180019378662
(20) DESCRIBE `ports` 0.0015799999237061
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031614303588867
(22) DESCRIBE `ports` 0.0013470649719238
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028705596923828
(24) DESCRIBE `ports` 0.0013949871063232
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00029301643371582
(26) DESCRIBE `ports` 0.001223087310791
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00026798248291016
(28) DESCRIBE `ports` 0.0013070106506348
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00069904327392578
(30) DESCRIBE `ports` 0.0012340545654297
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0002748966217041
(32) DESCRIBE `ports` 0.0011539459228516
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00038695335388184
(34) DESCRIBE `ports` 0.001492977142334
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00037002563476562
(36) DESCRIBE `ports` 0.0017659664154053
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00041413307189941
(38) DESCRIBE `ports` 0.0035631656646729
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00053501129150391
(40) DESCRIBE `ports` 0.0013110637664795
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00036501884460449
(42) DESCRIBE `ports` 0.0014870166778564
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00032687187194824
(44) DESCRIBE `ports` 0.0012979507446289
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029802322387695
(46) DESCRIBE `ports` 0.0014050006866455
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0014898777008057
(48) DESCRIBE `ports` 0.0012991428375244
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00043106079101562
(50) DESCRIBE `ports` 0.0015480518341064
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028085708618164
(52) DESCRIBE `ports` 0.0012528896331787
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00032711029052734
(54) DESCRIBE `ports` 0.0015811920166016
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00026988983154297
(56) DESCRIBE `ports` 0.001230001449585
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028705596923828
(58) DESCRIBE `ports` 0.0013577938079834
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033187866210938
(60) DESCRIBE `ports` 0.0017011165618896
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040602684020996
(62) DESCRIBE `ports` 0.0016670227050781
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026679039001465
(64) DESCRIBE `avid_specials` 0.0013539791107178
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82242 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010240077972412
(66) DESCRIBE `cruiselines` 0.0024120807647705
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00036406517028809
(68) DESCRIBE `orchid_image` 0.0016918182373047
(69) DESCRIBE `cruiselines` 0.0019030570983887
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00030207633972168
(71) DESCRIBE `cruises` 0.0026891231536865
(72) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75704') 0.00039005279541016
(73) DESCRIBE `ships` 0.0035390853881836
(74) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00053691864013672
(75) DESCRIBE `ships` 0.0028059482574463
(76) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.0003669261932373
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029277801513672
(78) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020599365234375
(79) DESCRIBE `itineraries` 0.0014619827270508
(80) DESCRIBE `ports` 0.0012891292572021
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030183792114258
(82) DESCRIBE `ports` 0.0012907981872559
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029110908508301
(84) DESCRIBE `ports` 0.0014069080352783
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00020098686218262
(86) DESCRIBE `sailingdates` 0.0013079643249512
(87) DESCRIBE `ports` 0.0014550685882568
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031709671020508
(89) DESCRIBE `ports` 0.0015029907226562
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027012825012207
(91) DESCRIBE `ports` 0.0013430118560791
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.0003058910369873
(93) DESCRIBE `ports` 0.0012400150299072
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00027179718017578
(95) DESCRIBE `ports` 0.00124192237854
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.0003359317779541
(97) DESCRIBE `ports` 0.0012350082397461
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00027012825012207
(99) DESCRIBE `ports` 0.0012619495391846
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00030207633972168
(101) DESCRIBE `ports` 0.0012340545654297
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0002899169921875
(103) DESCRIBE `ports` 0.0012331008911133
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00029492378234863
(105) DESCRIBE `ports` 0.001255989074707
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00027918815612793
(107) DESCRIBE `ports` 0.00130295753479
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031089782714844
(109) DESCRIBE `ports` 0.0012369155883789
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028109550476074
(111) DESCRIBE `ports` 0.0012848377227783
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029206275939941
(113) DESCRIBE `ports` 0.0016069412231445
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00030088424682617
(115) DESCRIBE `ports` 0.0013659000396729
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00032305717468262
(117) DESCRIBE `ports` 0.0014710426330566
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027298927307129
(119) DESCRIBE `ports` 0.0012409687042236
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00038313865661621
(121) DESCRIBE `ports` 0.0013110637664795
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002748966217041
(123) DESCRIBE `ports` 0.0013320446014404
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00029492378234863
(125) DESCRIBE `ports` 0.0013918876647949
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029921531677246
(127) DESCRIBE `ports` 0.001399040222168
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00034499168395996
(129) DESCRIBE `ports` 0.0012390613555908
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027298927307129
(131) DESCRIBE `ports` 0.0012829303741455
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029897689819336
(133) DESCRIBE `ports` 0.0013120174407959
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026106834411621
(135) DESCRIBE `avid_specials` 0.0013041496276855
(136) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75704 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010299682617188
(137) DESCRIBE `cruiselines` 0.0018959045410156
(138) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00031399726867676
(139) DESCRIBE `orchid_image` 0.0014169216156006
(140) DESCRIBE `cruiselines` 0.0018091201782227
(141) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00027799606323242
(142) DESCRIBE `cruises` 0.0028769969940186
(143) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75710') 0.00038313865661621
(144) DESCRIBE `ships` 0.0025410652160645
(145) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00036001205444336
(146) DESCRIBE `ships` 0.0028009414672852
(147) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00039291381835938
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031805038452148
(149) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026392936706543
(150) DESCRIBE `itineraries` 0.0013430118560791
(151) DESCRIBE `ports` 0.0012979507446289
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00032997131347656
(153) DESCRIBE `ports` 0.001338005065918
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00035905838012695
(155) DESCRIBE `ports` 0.0014958381652832
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00028419494628906
(157) DESCRIBE `sailingdates` 0.0011270046234131
(158) DESCRIBE `ports` 0.002126932144165
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.0004580020904541
(160) DESCRIBE `ports` 0.0018188953399658
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00039196014404297
(162) DESCRIBE `ports` 0.001349925994873
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.00023388862609863
(164) DESCRIBE `ports` 0.0013809204101562
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00028610229492188
(166) DESCRIBE `ports` 0.0018000602722168
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3134))) 0.00043392181396484
(168) DESCRIBE `ports` 0.0022709369659424
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3134') 0.00029397010803223
(170) DESCRIBE `ports` 0.0014030933380127
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1032))) 0.00041007995605469
(172) DESCRIBE `ports` 0.001694917678833
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1032') 0.00034213066101074
(174) DESCRIBE `ports` 0.0013439655303955
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00034499168395996
(176) DESCRIBE `ports` 0.0013191699981689
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00031900405883789
(178) DESCRIBE `ports` 0.0012748241424561
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00034189224243164
(180) DESCRIBE `ports` 0.001244068145752
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00034809112548828
(182) DESCRIBE `ports` 0.0013728141784668
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00038909912109375
(184) DESCRIBE `ports` 0.0017349720001221
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028610229492188
(186) DESCRIBE `ports` 0.0012750625610352
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1483))) 0.00031590461730957
(188) DESCRIBE `ports` 0.0013220310211182
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1483') 0.00031089782714844
(190) DESCRIBE `ports` 0.0014429092407227
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1483))) 0.00034785270690918
(192) DESCRIBE `ports` 0.001410961151123
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1483') 0.00035500526428223
(194) DESCRIBE `ports` 0.0014111995697021
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034093856811523
(196) DESCRIBE `ports` 0.0014429092407227
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00031590461730957
(198) DESCRIBE `ports` 0.0014419555664062
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00033307075500488
(200) DESCRIBE `ports` 0.0014150142669678
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00030708312988281
(202) DESCRIBE `ports` 0.0015230178833008
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034499168395996
(204) DESCRIBE `ports` 0.0014429092407227
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0003359317779541
(206) DESCRIBE `ports` 0.0012650489807129
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003049373626709
(208) DESCRIBE `ports` 0.0012497901916504
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027298927307129
(210) DESCRIBE `ports` 0.001309871673584
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00029587745666504
(212) DESCRIBE `ports` 0.0013220310211182
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028896331787109
(214) DESCRIBE `ports` 0.0013139247894287
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028896331787109
(216) DESCRIBE `ports` 0.0013530254364014
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026082992553711
(218) DESCRIBE `avid_specials` 0.0012249946594238
(219) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75710 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010988712310791
(220) DESCRIBE `cruiselines` 0.0018367767333984
(221) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00031113624572754
(222) DESCRIBE `orchid_image` 0.0014300346374512
(223) DESCRIBE `cruiselines` 0.0017988681793213
(224) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.0002751350402832
(225) DESCRIBE `cruises` 0.0025041103363037
(226) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75711') 0.00029110908508301
(227) DESCRIBE `ships` 0.0025811195373535
(228) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00044608116149902
(229) DESCRIBE `ships` 0.0033161640167236
(230) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00033211708068848
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029683113098145
(232) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025606155395508
(233) DESCRIBE `itineraries` 0.0013449192047119
(234) DESCRIBE `ports` 0.0015261173248291
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034904479980469
(236) DESCRIBE `ports` 0.0012640953063965
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00037884712219238
(238) DESCRIBE `ports` 0.0012550354003906
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0002751350402832
(240) DESCRIBE `sailingdates` 0.0021641254425049
(241) DESCRIBE `ports` 0.0013527870178223
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034689903259277
(243) DESCRIBE `ports` 0.001478910446167
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0003349781036377
(245) DESCRIBE `ports` 0.0014150142669678
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003509521484375
(247) DESCRIBE `ports` 0.0014059543609619
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028800964355469
(249) DESCRIBE `ports` 0.0012459754943848
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030088424682617
(251) DESCRIBE `ports` 0.0013010501861572
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029587745666504
(253) DESCRIBE `ports` 0.0013070106506348
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034499168395996
(255) DESCRIBE `ports` 0.0013508796691895
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002899169921875
(257) DESCRIBE `ports` 0.0015511512756348
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031805038452148
(259) DESCRIBE `ports` 0.0015299320220947
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00033807754516602
(261) DESCRIBE `ports` 0.001533031463623
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030803680419922
(263) DESCRIBE `ports` 0.0012800693511963
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028610229492188
(265) DESCRIBE `ports` 0.0013980865478516
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00038504600524902
(267) DESCRIBE `ports` 0.0013740062713623
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002748966217041
(269) DESCRIBE `ports` 0.0013420581817627
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030112266540527
(271) DESCRIBE `ports` 0.0013329982757568
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028896331787109
(273) DESCRIBE `ports` 0.0013091564178467
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00029301643371582
(275) DESCRIBE `ports` 0.0014321804046631
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033807754516602
(277) DESCRIBE `ports` 0.0012130737304688
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033402442932129
(279) DESCRIBE `ports` 0.0012409687042236
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028395652770996
(281) DESCRIBE `ports` 0.0012800693511963
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032210350036621
(283) DESCRIBE `ports` 0.001317024230957
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027203559875488
(285) DESCRIBE `avid_specials` 0.0012109279632568
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75711 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010299682617188
(287) DESCRIBE `cruiselines` 0.0021679401397705
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00031399726867676
(289) DESCRIBE `orchid_image` 0.001511812210083
(290) DESCRIBE `cruiselines` 0.0017819404602051
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00030303001403809
(292) DESCRIBE `cruises` 0.0024840831756592
(293) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75716') 0.00030684471130371
(294) DESCRIBE `ships` 0.0025310516357422
(295) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00034713745117188
(296) DESCRIBE `ships` 0.0025310516357422
(297) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00029802322387695
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025606155395508
(300) DESCRIBE `itineraries` 0.0012400150299072
(301) DESCRIBE `ports` 0.0017471313476562
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00036716461181641
(303) DESCRIBE `ports` 0.0015299320220947
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030684471130371
(305) DESCRIBE `ports` 0.0014340877532959
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028514862060547
(307) DESCRIBE `sailingdates` 0.001107931137085
(308) DESCRIBE `ports` 0.0013289451599121
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030398368835449
(310) DESCRIBE `ports` 0.0013229846954346
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026893615722656
(312) DESCRIBE `ports` 0.0012681484222412
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030517578125
(314) DESCRIBE `ports` 0.001276969909668
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028109550476074
(316) DESCRIBE `ports` 0.0017261505126953
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004270076751709
(318) DESCRIBE `ports` 0.0014829635620117
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028300285339355
(320) DESCRIBE `ports` 0.0012941360473633
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030803680419922
(322) DESCRIBE `ports` 0.0017340183258057
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0003209114074707
(324) DESCRIBE `ports` 0.0014300346374512
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031900405883789
(326) DESCRIBE `ports` 0.0012941360473633
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027799606323242
(328) DESCRIBE `ports` 0.0012679100036621
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031709671020508
(330) DESCRIBE `ports` 0.0013809204101562
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029110908508301
(332) DESCRIBE `ports` 0.0017158985137939
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00037980079650879
(334) DESCRIBE `ports` 0.0017499923706055
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00044393539428711
(336) DESCRIBE `ports` 0.0017960071563721
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00042510032653809
(338) DESCRIBE `ports` 0.0018839836120605
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00039291381835938
(340) DESCRIBE `ports` 0.0019369125366211
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043702125549316
(342) DESCRIBE `ports` 0.0018739700317383
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00058913230895996
(344) DESCRIBE `ports` 0.00199294090271
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00044393539428711
(346) DESCRIBE `ports` 0.0017831325531006
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003669261932373
(348) DESCRIBE `ports` 0.0013890266418457
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032496452331543
(350) DESCRIBE `ports` 0.0012660026550293
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029897689819336
(352) DESCRIBE `avid_specials` 0.0014090538024902
(353) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75716 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017311573028564
(354) DESCRIBE `cruiselines` 0.0026018619537354
(355) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0004570484161377
(356) DESCRIBE `orchid_image` 0.0014069080352783
(357) DESCRIBE `cruiselines` 0.0018820762634277
(358) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00029993057250977
(359) DESCRIBE `cruises` 0.0025990009307861
(360) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75705') 0.00031805038452148
(361) DESCRIBE `ships` 0.0031039714813232
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00041413307189941
(363) DESCRIBE `ships` 0.0025169849395752
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.0003359317779541
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026679039001465
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(367) DESCRIBE `itineraries` 0.0012922286987305
(368) DESCRIBE `ports` 0.0014491081237793
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030684471130371
(370) DESCRIBE `ports` 0.0012941360473633
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028800964355469
(372) DESCRIBE `ports` 0.0013668537139893
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026583671569824
(374) DESCRIBE `sailingdates` 0.0011641979217529
(375) DESCRIBE `ports` 0.0013220310211182
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030088424682617
(377) DESCRIBE `ports` 0.0012648105621338
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031399726867676
(379) DESCRIBE `ports` 0.0015289783477783
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00037193298339844
(381) DESCRIBE `ports` 0.0017168521881104
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028800964355469
(383) DESCRIBE `ports` 0.001708984375
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00032997131347656
(385) DESCRIBE `ports` 0.0017600059509277
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00037598609924316
(387) DESCRIBE `ports` 0.001507043838501
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00033903121948242
(389) DESCRIBE `ports` 0.0013048648834229
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029993057250977
(391) DESCRIBE `ports` 0.0012779235839844
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031900405883789
(393) DESCRIBE `ports` 0.0013151168823242
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00053811073303223
(395) DESCRIBE `ports` 0.0019969940185547
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0004420280456543
(397) DESCRIBE `ports` 0.001802921295166
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0003659725189209
(399) DESCRIBE `ports` 0.0018022060394287
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00039482116699219
(401) DESCRIBE `ports` 0.0020370483398438
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00037598609924316
(403) DESCRIBE `ports` 0.0015389919281006
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00039196014404297
(405) DESCRIBE `ports` 0.0016698837280273
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00040292739868164
(407) DESCRIBE `ports` 0.0017409324645996
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00039815902709961
(409) DESCRIBE `ports` 0.0018250942230225
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00036001205444336
(411) DESCRIBE `ports` 0.0017549991607666
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040388107299805
(413) DESCRIBE `ports` 0.0012068748474121
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028586387634277
(415) DESCRIBE `ports` 0.0012860298156738
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031304359436035
(417) DESCRIBE `ports` 0.0013320446014404
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028800964355469
(419) DESCRIBE `avid_specials` 0.001413106918335
(420) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75705 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015931129455566
(421) DESCRIBE `cruiselines` 0.0022919178009033
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00042200088500977
(423) DESCRIBE `orchid_image` 0.0019679069519043
(424) DESCRIBE `cruiselines` 0.0021848678588867
(425) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00030994415283203
(426) DESCRIBE `cruises` 0.0028910636901855
(427) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75714') 0.00033402442932129
(428) DESCRIBE `ships` 0.0027601718902588
(429) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00037789344787598
(430) DESCRIBE `ships` 0.0027439594268799
(431) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00034499168395996
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031495094299316
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032401084899902
(434) DESCRIBE `itineraries` 0.0013079643249512
(435) DESCRIBE `ports` 0.0012829303741455
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029802322387695
(437) DESCRIBE `ports` 0.0013840198516846
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031900405883789
(439) DESCRIBE `ports` 0.0013391971588135
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026297569274902
(441) DESCRIBE `sailingdates` 0.0011739730834961
(442) DESCRIBE `ports` 0.0017681121826172
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0003509521484375
(444) DESCRIBE `ports` 0.0013060569763184
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029706954956055
(446) DESCRIBE `ports` 0.0013189315795898
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.0003058910369873
(448) DESCRIBE `ports` 0.0013060569763184
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00029897689819336
(450) DESCRIBE `ports` 0.0012810230255127
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00032591819763184
(452) DESCRIBE `ports` 0.0013301372528076
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028586387634277
(454) DESCRIBE `ports` 0.0012748241424561
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00032210350036621
(456) DESCRIBE `ports` 0.0013339519500732
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028419494628906
(458) DESCRIBE `ports` 0.0012860298156738
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031018257141113
(460) DESCRIBE `ports` 0.001392126083374
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00016093254089355
(462) DESCRIBE `ports` 0.0012598037719727
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030207633972168
(464) DESCRIBE `ports` 0.0012640953063965
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027203559875488
(466) DESCRIBE `ports` 0.0012879371643066
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031900405883789
(468) DESCRIBE `ports` 0.0012600421905518
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028014183044434
(470) DESCRIBE `ports` 0.0012791156768799
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00056791305541992
(472) DESCRIBE `ports` 0.0013401508331299
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027203559875488
(474) DESCRIBE `ports` 0.0013151168823242
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00015687942504883
(476) DESCRIBE `ports` 0.0012590885162354
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027203559875488
(478) DESCRIBE `ports` 0.0014939308166504
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031805038452148
(480) DESCRIBE `ports` 0.001317024230957
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028395652770996
(482) DESCRIBE `ports` 0.001248836517334
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028705596923828
(484) DESCRIBE `ports` 0.0015840530395508
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00054597854614258
(486) DESCRIBE `avid_specials` 0.0012030601501465
(487) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75714 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010290145874023
(488) DESCRIBE `cruiselines` 0.0019431114196777
(489) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00037622451782227
(490) DESCRIBE `orchid_image` 0.0014779567718506
(491) DESCRIBE `cruiselines` 0.0018558502197266
(492) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00029802322387695
(493) DESCRIBE `cruises` 0.0026130676269531
(494) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75717') 0.00031614303588867
(495) DESCRIBE `ships` 0.0026240348815918
(496) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00036883354187012
(497) DESCRIBE `ships` 0.0025289058685303
(498) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00031590461730957
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031113624572754
(500) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027012825012207
(501) DESCRIBE `itineraries` 0.0016109943389893
(502) DESCRIBE `ports` 0.0013589859008789
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031113624572754
(504) DESCRIBE `ports` 0.0015051364898682
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030303001403809
(506) DESCRIBE `ports` 0.0012788772583008
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028204917907715
(508) DESCRIBE `sailingdates` 0.0012149810791016
(509) DESCRIBE `ports` 0.001410961151123
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0003819465637207
(511) DESCRIBE `ports` 0.0016868114471436
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00034499168395996
(513) DESCRIBE `ports` 0.001708984375
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00032186508178711
(515) DESCRIBE `ports` 0.001471996307373
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00028800964355469
(517) DESCRIBE `ports` 0.0012800693511963
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00032711029052734
(519) DESCRIBE `ports` 0.0012879371643066
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029397010803223
(521) DESCRIBE `ports` 0.0012600421905518
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00039410591125488
(523) DESCRIBE `ports` 0.0018160343170166
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00030684471130371
(525) DESCRIBE `ports` 0.0013492107391357
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00033807754516602
(527) DESCRIBE `ports` 0.0013399124145508
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028300285339355
(529) DESCRIBE `ports` 0.001331090927124
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034785270690918
(531) DESCRIBE `ports` 0.0012772083282471
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029087066650391
(533) DESCRIBE `ports` 0.0012810230255127
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034022331237793
(535) DESCRIBE `ports` 0.0012719631195068
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00042009353637695
(537) DESCRIBE `ports` 0.001507043838501
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003669261932373
(539) DESCRIBE `ports` 0.0016350746154785
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00040602684020996
(541) DESCRIBE `ports` 0.0017838478088379
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00042319297790527
(543) DESCRIBE `ports` 0.0015180110931396
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00032401084899902
(545) DESCRIBE `ports` 0.0016670227050781
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033092498779297
(547) DESCRIBE `ports` 0.0013191699981689
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0
(549) DESCRIBE `ports` 0.0015249252319336
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030612945556641
(551) DESCRIBE `ports` 0.001378059387207
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00034117698669434
(553) DESCRIBE `ports` 0.0016789436340332
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031018257141113
(555) DESCRIBE `ports` 0.0012929439544678
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027799606323242
(557) DESCRIBE `avid_specials` 0.0014119148254395
(558) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75717 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016589164733887
(559) DESCRIBE `cruiselines` 0.0020830631256104
(560) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00037980079650879
(561) DESCRIBE `orchid_image` 0.0015189647674561
(562) DESCRIBE `cruiselines` 0.0022571086883545
(563) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00041794776916504
(564) DESCRIBE `cruises` 0.0025029182434082
(565) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75706') 0.00038981437683105
(566) DESCRIBE `ships` 0.0031528472900391
(567) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00043511390686035
(568) DESCRIBE `ships` 0.0027182102203369
(569) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.00030899047851562
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029921531677246
(571) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(572) DESCRIBE `itineraries` 0.0017118453979492
(573) DESCRIBE `ports` 0.0015349388122559
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0003819465637207
(575) DESCRIBE `ports` 0.0015249252319336
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030994415283203
(577) DESCRIBE `ports` 0.001276969909668
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028586387634277
(579) DESCRIBE `sailingdates` 0.001133918762207
(580) DESCRIBE `ports` 0.0017268657684326
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033807754516602
(582) DESCRIBE `ports` 0.0013790130615234
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031590461730957
(584) DESCRIBE `ports` 0.0013229846954346
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00037789344787598
(586) DESCRIBE `ports` 0.001323938369751
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00035786628723145
(588) DESCRIBE `ports` 0.0016400814056396
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00037717819213867
(590) DESCRIBE `ports` 0.0013902187347412
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00039505958557129
(592) DESCRIBE `ports` 0.0014522075653076
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0003819465637207
(594) DESCRIBE `ports` 0.001338005065918
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00034189224243164
(596) DESCRIBE `ports` 0.0018260478973389
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00034499168395996
(598) DESCRIBE `ports` 0.0013680458068848
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029611587524414
(600) DESCRIBE `ports` 0.001378059387207
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00036907196044922
(602) DESCRIBE `ports` 0.0015771389007568
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027990341186523
(604) DESCRIBE `ports` 0.0016469955444336
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00040507316589355
(606) DESCRIBE `ports` 0.0018208026885986
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027108192443848
(608) DESCRIBE `ports` 0.0020489692687988
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029802322387695
(610) DESCRIBE `ports` 0.0023138523101807
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00040888786315918
(612) DESCRIBE `ports` 0.0017280578613281
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0005791187286377
(614) DESCRIBE `ports` 0.0016939640045166
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00035691261291504
(616) DESCRIBE `ports` 0.0014710426330566
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004279613494873
(618) DESCRIBE `ports` 0.0017499923706055
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00039911270141602
(620) DESCRIBE `ports` 0.0017890930175781
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00037407875061035
(622) DESCRIBE `ports` 0.0016100406646729
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00038290023803711
(624) DESCRIBE `ports` 0.0016059875488281
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00038409233093262
(626) DESCRIBE `ports` 0.0013980865478516
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027012825012207
(628) DESCRIBE `avid_specials` 0.0011489391326904
(629) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75706 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001115083694458
(630) DESCRIBE `cruiselines` 0.0025529861450195
(631) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00045084953308105
(632) DESCRIBE `orchid_image` 0.0014538764953613
(633) DESCRIBE `cruiselines` 0.0018630027770996
(634) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00030803680419922
(635) DESCRIBE `cruises` 0.0027339458465576
(636) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75715') 0.00033688545227051
(637) DESCRIBE `ships` 0.0027899742126465
(638) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00048303604125977
(639) DESCRIBE `ships` 0.0028431415557861
(640) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00029993057250977
(641) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027012825012207
(642) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(643) DESCRIBE `itineraries` 0.0012509822845459
(644) DESCRIBE `ports` 0.0018138885498047
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00045299530029297
(646) DESCRIBE `ports` 0.0020079612731934
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032186508178711
(648) DESCRIBE `ports` 0.001356840133667
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028491020202637
(650) DESCRIBE `sailingdates` 0.0011579990386963
(651) DESCRIBE `ports` 0.0012600421905518
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031304359436035
(653) DESCRIBE `ports` 0.0014579296112061
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027203559875488
(655) DESCRIBE `ports` 0.0013070106506348
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003058910369873
(657) DESCRIBE `ports` 0.0014400482177734
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027704238891602
(659) DESCRIBE `ports` 0.0013248920440674
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031089782714844
(661) DESCRIBE `ports` 0.0012679100036621
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030708312988281
(663) DESCRIBE `ports` 0.0015830993652344
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00032401084899902
(665) DESCRIBE `ports` 0.0013802051544189
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0001220703125
(667) DESCRIBE `ports` 0.0014441013336182
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030183792114258
(669) DESCRIBE `ports` 0.0012600421905518
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028300285339355
(671) DESCRIBE `ports` 0.0017530918121338
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003361701965332
(673) DESCRIBE `ports` 0.0015830993652344
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00037503242492676
(675) DESCRIBE `ports` 0.0013110637664795
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003209114074707
(677) DESCRIBE `ports` 0.0013260841369629
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027704238891602
(679) DESCRIBE `ports` 0.0012660026550293
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003199577331543
(681) DESCRIBE `ports` 0.0013251304626465
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00035405158996582
(683) DESCRIBE `ports` 0.0017271041870117
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00037598609924316
(685) DESCRIBE `ports` 0.001317024230957
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030398368835449
(687) DESCRIBE `ports` 0.0015110969543457
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00035691261291504
(689) DESCRIBE `ports` 0.0016520023345947
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030207633972168
(691) DESCRIBE `ports` 0.0014519691467285
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029706954956055
(693) DESCRIBE `ports` 0.0012829303741455
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026583671569824
(695) DESCRIBE `avid_specials` 0.0011179447174072
(696) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75715 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011410713195801
(697) DESCRIBE `cruiselines` 0.0017590522766113
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00032401084899902
(699) DESCRIBE `orchid_image` 0.0014209747314453
(700) DESCRIBE `cruiselines` 0.0025122165679932
(701) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00037598609924316
(702) DESCRIBE `ships` 0.0031120777130127
(703) SELECT `ships`.* FROM `ships` WHERE (id IN ('1073', '795', '796', '1262')) ORDER BY FIND_IN_SET(id, '1073,795,796,1262') 0.00063085556030273
(704) DESCRIBE `cruisetypes` 0.0011429786682129
(705) DESCRIBE `cruiselines` 0.0019960403442383
(706) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00034499168395996
(707) DESCRIBE `destinations` 0.0018389225006104
(708) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00034093856811523
(709) DESCRIBE `destinations` 0.0020811557769775
(710) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00055313110351562
(711) DESCRIBE `cruiselines` 0.001945972442627
(712) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00042390823364258