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

Total elapsed time: 0.65071654319763

# Query Time
(1) connect 0.00089502334594727
(2) DESCRIBE `cruises` 0.003242015838623
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71398, 71399, 71399, 71400, 71400, 71401, 71401, 71402, 71403, 71403)) ORDER BY FIND_IN_SET(id, '71398,71399,71399,71400,71400,71401,71401,71402,71403,71403') 0.00092315673828125
(4) DESCRIBE `cruises` 0.0029540061950684
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71398') 0.00037884712219238
(6) DESCRIBE `ships` 0.0029728412628174
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00039291381835938
(8) DESCRIBE `ships` 0.0026650428771973
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00029206275939941
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027608871459961
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00028705596923828
(12) DESCRIBE `itineraries` 0.0013010501861572
(13) DESCRIBE `ports` 0.0013289451599121
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00033402442932129
(15) DESCRIBE `ports` 0.0012421607971191
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00030708312988281
(17) DESCRIBE `ports` 0.0015521049499512
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00031495094299316
(19) DESCRIBE `sailingdates` 0.0016779899597168
(20) DESCRIBE `ports` 0.0015311241149902
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00035405158996582
(22) DESCRIBE `ports` 0.001251220703125
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00029110908508301
(24) DESCRIBE `ports` 0.0015718936920166
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00030779838562012
(26) DESCRIBE `ports` 0.0012798309326172
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00017404556274414
(28) DESCRIBE `ports` 0.0012569427490234
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00028705596923828
(30) DESCRIBE `ports` 0.0014550685882568
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00026798248291016
(32) DESCRIBE `ports` 0.00124192237854
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003049373626709
(34) DESCRIBE `ports` 0.0013339519500732
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00034189224243164
(36) DESCRIBE `ports` 0.001741886138916
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00043892860412598
(38) DESCRIBE `ports` 0.0014328956604004
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00028896331787109
(40) DESCRIBE `ports` 0.0013198852539062
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00030183792114258
(42) DESCRIBE `ports` 0.0013079643249512
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00035691261291504
(44) DESCRIBE `ports` 0.0012660026550293
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0003361701965332
(46) DESCRIBE `ports` 0.0012578964233398
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00028204917907715
(48) DESCRIBE `ports` 0.0013570785522461
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003809928894043
(50) DESCRIBE `ports` 0.0013260841369629
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00015091896057129
(52) DESCRIBE `ports` 0.0016970634460449
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00035309791564941
(54) DESCRIBE `ports` 0.0014967918395996
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00033807754516602
(56) DESCRIBE `ports` 0.0015799999237061
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00044608116149902
(58) DESCRIBE `ports` 0.001331090927124
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00033688545227051
(60) DESCRIBE `ports` 0.0012857913970947
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0003359317779541
(62) DESCRIBE `ports` 0.0012609958648682
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00028681755065918
(64) DESCRIBE `ports` 0.0012948513031006
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00030803680419922
(66) DESCRIBE `ports` 0.0014750957489014
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00019097328186035
(68) DESCRIBE `avid_specials` 0.0011529922485352
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71398 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001676082611084
(70) DESCRIBE `cruiselines` 0.0022149085998535
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00058412551879883
(72) DESCRIBE `orchid_image` 0.0020089149475098
(73) DESCRIBE `cruiselines` 0.0018260478973389
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00033283233642578
(75) DESCRIBE `specials` 0.0038549900054932
(76) DESCRIBE `specials` 0.0039629936218262
(77) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541086') 0.00044703483581543
(78) DESCRIBE `ships` 0.0027840137481689
(79) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00037121772766113
(80) DESCRIBE `ships` 0.0025279521942139
(81) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.0002739429473877
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027203559875488
(83) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027203559875488
(84) DESCRIBE `itineraries` 0.001230001449585
(85) DESCRIBE `ports` 0.001317024230957
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00044798851013184
(87) DESCRIBE `ports` 0.0012550354003906
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00029397010803223
(89) DESCRIBE `ports` 0.001305103302002
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029110908508301
(91) DESCRIBE `specialsailingdates` 0.0011031627655029
(92) DESCRIBE `sailingdates` 0.0011191368103027
(93) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453273))) 0.00042319297790527
(94) DESCRIBE `ports` 0.0012490749359131
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00031495094299316
(96) DESCRIBE `ports` 0.0012519359588623
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00028204917907715
(98) DESCRIBE `ports` 0.0012719631195068
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00030994415283203
(100) DESCRIBE `ports` 0.0012359619140625
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00012516975402832
(102) DESCRIBE `ports` 0.0013527870178223
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00054812431335449
(104) DESCRIBE `ports` 0.0015780925750732
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00031304359436035
(106) DESCRIBE `ports` 0.0013267993927002
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032305717468262
(108) DESCRIBE `ports` 0.0013320446014404
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00030088424682617
(110) DESCRIBE `ports` 0.0013620853424072
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00030899047851562
(112) DESCRIBE `ports` 0.0013370513916016
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00028014183044434
(114) DESCRIBE `ports` 0.0015110969543457
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00036215782165527
(116) DESCRIBE `ports` 0.0015480518341064
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00028204917907715
(118) DESCRIBE `ports` 0.0014438629150391
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00032901763916016
(120) DESCRIBE `ports` 0.0013341903686523
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00032782554626465
(122) DESCRIBE `cruises` 0.0028460025787354
(123) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71399))) 0.00043392181396484
(124) DESCRIBE `avid_specials` 0.0012128353118896
(125) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541086 and class = 'Special') OR (item_id = 71399 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0010550022125244
(126) DESCRIBE `cruiselines` 0.0018959045410156
(127) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.0003669261932373
(128) DESCRIBE `orchid_image` 0.0014829635620117
(129) DESCRIBE `cruiselines` 0.0027461051940918
(130) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00040912628173828
(131) DESCRIBE `cruises` 0.0027999877929688
(132) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71399') 0.00032210350036621
(133) DESCRIBE `ships` 0.0029168128967285
(134) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00042390823364258
(135) DESCRIBE `ships` 0.0029938220977783
(136) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00043201446533203
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003209114074707
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029993057250977
(139) DESCRIBE `itineraries` 0.0014269351959229
(140) DESCRIBE `ports` 0.0013802051544189
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00081801414489746
(142) DESCRIBE `ports` 0.0013470649719238
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00030112266540527
(144) DESCRIBE `ports` 0.0015158653259277
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00031304359436035
(146) DESCRIBE `sailingdates` 0.0011110305786133
(147) DESCRIBE `ports` 0.0018558502197266
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0005030632019043
(149) DESCRIBE `ports` 0.0015840530395508
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00034093856811523
(151) DESCRIBE `ports` 0.0017170906066895
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00041389465332031
(153) DESCRIBE `ports` 0.0016641616821289
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00037908554077148
(155) DESCRIBE `ports` 0.0015659332275391
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00041794776916504
(157) DESCRIBE `ports` 0.0016059875488281
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00033998489379883
(159) DESCRIBE `ports` 0.0015718936920166
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00039219856262207
(161) DESCRIBE `ports` 0.0016391277313232
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00034880638122559
(163) DESCRIBE `ports` 0.0015389919281006
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00036883354187012
(165) DESCRIBE `ports` 0.0014200210571289
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00030303001403809
(167) DESCRIBE `ports` 0.001270055770874
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00031709671020508
(169) DESCRIBE `ports` 0.0013129711151123
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00027298927307129
(171) DESCRIBE `ports` 0.0012791156768799
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00038290023803711
(173) DESCRIBE `ports` 0.0014548301696777
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00033783912658691
(175) DESCRIBE `avid_specials` 0.001399040222168
(176) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71399 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0011520385742188
(177) DESCRIBE `cruiselines` 0.00189208984375
(178) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00034618377685547
(179) DESCRIBE `orchid_image` 0.0015420913696289
(180) DESCRIBE `cruiselines` 0.0018470287322998
(181) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00034594535827637
(182) DESCRIBE `specials` 0.0040481090545654
(183) DESCRIBE `specials` 0.0035629272460938
(184) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541088') 0.00037312507629395
(185) DESCRIBE `ships` 0.0025420188903809
(186) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0003659725189209
(187) DESCRIBE `ships` 0.0028629302978516
(188) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00026202201843262
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00026893615722656
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025606155395508
(191) DESCRIBE `itineraries` 0.0013871192932129
(192) DESCRIBE `ports` 0.0013899803161621
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00039887428283691
(194) DESCRIBE `ports` 0.0012679100036621
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00040411949157715
(196) DESCRIBE `ports` 0.0015389919281006
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00036716461181641
(198) DESCRIBE `specialsailingdates` 0.0010778903961182
(199) DESCRIBE `sailingdates` 0.0017280578613281
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453274))) 0.00045394897460938
(201) DESCRIBE `ports` 0.0017819404602051
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003960132598877
(203) DESCRIBE `ports` 0.0012869834899902
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00031399726867676
(205) DESCRIBE `ports` 0.00091385841369629
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00034213066101074
(207) DESCRIBE `ports` 0.0013060569763184
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 6.8187713623047E-5
(209) DESCRIBE `ports` 0.0012838840484619
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00032997131347656
(211) DESCRIBE `ports` 0.00148606300354
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00028705596923828
(213) DESCRIBE `ports` 0.0013999938964844
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00033712387084961
(215) DESCRIBE `ports` 0.0017149448394775
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00036716461181641
(217) DESCRIBE `ports` 0.0014359951019287
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00016403198242188
(219) DESCRIBE `ports` 0.001331090927124
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00031900405883789
(221) DESCRIBE `ports` 0.001323938369751
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031495094299316
(223) DESCRIBE `ports` 0.0012681484222412
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00033879280090332
(225) DESCRIBE `ports` 0.0014040470123291
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030994415283203
(227) DESCRIBE `ports` 0.0012989044189453
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 7.8678131103516E-6
(229) DESCRIBE `ports` 0.001288890838623
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0
(231) DESCRIBE `ports` 0.0015139579772949
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029587745666504
(233) DESCRIBE `ports` 0.0012691020965576
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00041699409484863
(235) DESCRIBE `ports` 0.0014369487762451
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00028491020202637
(237) DESCRIBE `ports` 0.0013418197631836
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00031805038452148
(239) DESCRIBE `ports` 0.0016570091247559
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00031304359436035
(241) DESCRIBE `cruises` 0.0028090476989746
(242) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71400))) 0.00047588348388672
(243) DESCRIBE `avid_specials` 0.0013020038604736
(244) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541088 and class = 'Special') OR (item_id = 71400 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0014550685882568
(245) DESCRIBE `cruiselines` 0.0024569034576416
(246) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00047492980957031
(247) DESCRIBE `orchid_image` 0.0019540786743164
(248) DESCRIBE `cruiselines` 0.0023188591003418
(249) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00037002563476562
(250) DESCRIBE `cruises` 0.0027508735656738
(251) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71400') 0.00031399726867676
(252) DESCRIBE `ships` 0.0026149749755859
(253) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0003659725189209
(254) DESCRIBE `ships` 0.0027740001678467
(255) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00032591819763184
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0002899169921875
(257) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025606155395508
(258) DESCRIBE `itineraries` 0.0014100074768066
(259) DESCRIBE `ports` 0.0014910697937012
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00041294097900391
(261) DESCRIBE `ports` 0.0013120174407959
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003819465637207
(263) DESCRIBE `ports` 0.0015990734100342
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00035595893859863
(265) DESCRIBE `sailingdates` 0.0011351108551025
(266) DESCRIBE `ports` 0.0017318725585938
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0007321834564209
(268) DESCRIBE `ports` 0.001680850982666
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043296813964844
(270) DESCRIBE `ports` 0.0015380382537842
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00036287307739258
(272) DESCRIBE `ports` 0.0017020702362061
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00029587745666504
(274) DESCRIBE `ports` 0.0012879371643066
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00030803680419922
(276) DESCRIBE `ports` 0.0014848709106445
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00029087066650391
(278) DESCRIBE `ports` 0.0016598701477051
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 1.3828277587891E-5
(280) DESCRIBE `ports` 0.0014421939849854
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00027990341186523
(282) DESCRIBE `ports` 0.0015909671783447
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00039196014404297
(284) DESCRIBE `ports` 0.0016210079193115
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00018095970153809
(286) DESCRIBE `ports` 0.0015389919281006
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032401084899902
(288) DESCRIBE `ports` 0.0012550354003906
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0002751350402832
(290) DESCRIBE `ports` 0.0012669563293457
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030207633972168
(292) DESCRIBE `ports` 0.0020790100097656
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00046896934509277
(294) DESCRIBE `ports` 0.001615047454834
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032806396484375
(296) DESCRIBE `ports` 0.0013871192932129
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035405158996582
(298) DESCRIBE `ports` 0.0012869834899902
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00034689903259277
(300) DESCRIBE `ports` 0.0013740062713623
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00029921531677246
(302) DESCRIBE `ports` 0.0014219284057617
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00042891502380371
(304) DESCRIBE `ports` 0.0013420581817627
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00031399726867676
(306) DESCRIBE `avid_specials` 0.0011720657348633
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71400 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0012409687042236
(308) DESCRIBE `cruiselines` 0.0020151138305664
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00041604042053223
(310) DESCRIBE `orchid_image` 0.0015869140625
(311) DESCRIBE `cruiselines` 0.0022070407867432
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.0003359317779541
(313) DESCRIBE `specials` 0.0043861865997314
(314) DESCRIBE `specials` 0.0043718814849854
(315) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541089') 0.00022482872009277
(316) DESCRIBE `ships` 0.0028939247131348
(317) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0004432201385498
(318) DESCRIBE `ships` 0.0027570724487305
(319) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00035810470581055
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027799606323242
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029087066650391
(322) DESCRIBE `itineraries` 0.0013902187347412
(323) DESCRIBE `ports` 0.0016140937805176
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00046110153198242
(325) DESCRIBE `ports` 0.0013718605041504
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00034403800964355
(327) DESCRIBE `ports` 0.0013289451599121
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00032806396484375
(329) DESCRIBE `specialsailingdates` 0.0010640621185303
(330) DESCRIBE `sailingdates` 0.001288890838623
(331) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453275))) 0.00037002563476562
(332) DESCRIBE `ports` 0.0013198852539062
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00033998489379883
(334) DESCRIBE `ports` 0.0013148784637451
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00030207633972168
(336) DESCRIBE `ports` 0.0013649463653564
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00034499168395996
(338) DESCRIBE `ports` 0.0013489723205566
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00030612945556641
(340) DESCRIBE `ports` 0.0013439655303955
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031805038452148
(342) DESCRIBE `ports` 0.0012907981872559
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00034093856811523
(344) DESCRIBE `ports` 0.0012691020965576
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00040292739868164
(346) DESCRIBE `ports` 0.0014240741729736
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029802322387695
(348) DESCRIBE `ports` 0.0013759136199951
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032210350036621
(350) DESCRIBE `ports` 0.0013868808746338
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028705596923828
(352) DESCRIBE `ports` 0.001244068145752
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00034308433532715
(354) DESCRIBE `ports` 0.0012569427490234
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00027298927307129
(356) DESCRIBE `ports` 0.0013740062713623
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00031113624572754
(358) DESCRIBE `ports` 0.0012519359588623
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00027585029602051
(360) DESCRIBE `ports` 0.0013089179992676
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00040984153747559
(362) DESCRIBE `ports` 0.0012810230255127
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00029802322387695
(364) DESCRIBE `ports` 0.0013279914855957
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00036287307739258
(366) DESCRIBE `ports` 0.0012528896331787
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0003049373626709
(368) DESCRIBE `ports` 0.0012621879577637
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00034689903259277
(370) DESCRIBE `ports` 0.0013260841369629
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0003058910369873
(372) DESCRIBE `cruises` 0.0024600028991699
(373) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71401))) 0.00040984153747559
(374) DESCRIBE `avid_specials` 0.001223087310791
(375) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541089 and class = 'Special') OR (item_id = 71401 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0010979175567627
(376) DESCRIBE `cruiselines` 0.0019030570983887
(377) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00047087669372559
(378) DESCRIBE `orchid_image` 0.0020170211791992
(379) DESCRIBE `cruiselines` 0.0025529861450195
(380) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00034689903259277
(381) DESCRIBE `cruises` 0.0024659633636475
(382) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71401') 0.00030517578125
(383) DESCRIBE `ships` 0.0024979114532471
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00035691261291504
(385) DESCRIBE `ships` 0.0027849674224854
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00027585029602051
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033402442932129
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025486946105957
(389) DESCRIBE `itineraries` 0.0013070106506348
(390) DESCRIBE `ports` 0.0012750625610352
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00033688545227051
(392) DESCRIBE `ports` 0.0013160705566406
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00037503242492676
(394) DESCRIBE `ports` 0.0015060901641846
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00034499168395996
(396) DESCRIBE `sailingdates` 0.0011589527130127
(397) DESCRIBE `ports` 0.0014679431915283
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0003209114074707
(399) DESCRIBE `ports` 0.0013160705566406
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029492378234863
(401) DESCRIBE `ports` 0.0013940334320068
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00036501884460449
(403) DESCRIBE `ports` 0.0013289451599121
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00033903121948242
(405) DESCRIBE `ports` 0.0012640953063965
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030112266540527
(407) DESCRIBE `ports` 0.0013678073883057
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027298927307129
(409) DESCRIBE `ports` 0.0012481212615967
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00029802322387695
(411) DESCRIBE `ports` 0.0013291835784912
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027894973754883
(413) DESCRIBE `ports` 0.0012438297271729
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032210350036621
(415) DESCRIBE `ports` 0.0012719631195068
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027108192443848
(417) DESCRIBE `ports` 0.001244068145752
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00031590461730957
(419) DESCRIBE `ports` 0.0018899440765381
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00037097930908203
(421) DESCRIBE `ports` 0.0014369487762451
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00042891502380371
(423) DESCRIBE `ports` 0.0014970302581787
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00044584274291992
(425) DESCRIBE `ports` 0.0013201236724854
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00042295455932617
(427) DESCRIBE `ports` 0.0014770030975342
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00033116340637207
(429) DESCRIBE `ports` 0.0015068054199219
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00046801567077637
(431) DESCRIBE `ports` 0.0018579959869385
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00016999244689941
(433) DESCRIBE `ports` 0.0014028549194336
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00047492980957031
(435) DESCRIBE `ports` 0.0016770362854004
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00030207633972168
(437) DESCRIBE `avid_specials` 0.0011680126190186
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71401 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.00064301490783691
(439) DESCRIBE `cruiselines` 0.0023889541625977
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00030994415283203
(441) DESCRIBE `orchid_image` 0.0014088153839111
(442) DESCRIBE `cruiselines` 0.0018129348754883
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00033092498779297
(444) DESCRIBE `cruises` 0.0025398731231689
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71402') 0.00036382675170898
(446) DESCRIBE `ships` 0.003201961517334
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00039196014404297
(448) DESCRIBE `ships` 0.0025169849395752
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00029492378234863
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00030899047851562
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029277801513672
(452) DESCRIBE `itineraries` 0.0013749599456787
(453) DESCRIBE `ports` 0.0013079643249512
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0004420280456543
(455) DESCRIBE `ports` 0.0013408660888672
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0004429817199707
(457) DESCRIBE `ports` 0.0015370845794678
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00021696090698242
(459) DESCRIBE `sailingdates` 0.00136399269104
(460) DESCRIBE `ports` 0.0014619827270508
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00045299530029297
(462) DESCRIBE `ports` 0.00142502784729
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00031805038452148
(464) DESCRIBE `ports` 0.0014679431915283
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 3.6954879760742E-5
(466) DESCRIBE `ports` 0.001323938369751
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00028896331787109
(468) DESCRIBE `ports` 0.0014770030975342
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00031304359436035
(470) DESCRIBE `ports` 0.0013799667358398
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00034403800964355
(472) DESCRIBE `ports` 0.0012750625610352
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031495094299316
(474) DESCRIBE `ports` 0.0013341903686523
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027298927307129
(476) DESCRIBE `ports` 0.0016098022460938
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00038599967956543
(478) DESCRIBE `ports` 0.0013208389282227
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029110908508301
(480) DESCRIBE `ports` 0.0012528896331787
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00031113624572754
(482) DESCRIBE `ports` 0.0012838840484619
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00027298927307129
(484) DESCRIBE `ports` 0.0012598037719727
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00031018257141113
(486) DESCRIBE `ports` 0.0013110637664795
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00028109550476074
(488) DESCRIBE `avid_specials` 0.0011029243469238
(489) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71402 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0010859966278076
(490) DESCRIBE `cruiselines` 0.0018079280853271
(491) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00032806396484375
(492) DESCRIBE `orchid_image` 0.0013749599456787
(493) DESCRIBE `cruiselines` 0.0019040107727051
(494) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00027203559875488
(495) DESCRIBE `specials` 0.0039088726043701
(496) DESCRIBE `specials` 0.0038259029388428
(497) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541090') 0.00037908554077148
(498) DESCRIBE `ships` 0.0025339126586914
(499) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00036001205444336
(500) DESCRIBE `ships` 0.0024831295013428
(501) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00027608871459961
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00026607513427734
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025320053100586
(504) DESCRIBE `itineraries` 0.0013599395751953
(505) DESCRIBE `ports` 0.0013308525085449
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00081491470336914
(507) DESCRIBE `ports` 0.0010049343109131
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00029587745666504
(509) DESCRIBE `ports` 0.0013148784637451
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00055813789367676
(511) DESCRIBE `specialsailingdates` 0.0016469955444336
(512) DESCRIBE `sailingdates` 0.0015790462493896
(513) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453277))) 0.00010204315185547
(514) DESCRIBE `ports` 0.0012819766998291
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00033712387084961
(516) DESCRIBE `ports` 0.0012590885162354
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029301643371582
(518) DESCRIBE `ports` 0.001338005065918
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00032615661621094
(520) DESCRIBE `ports` 0.0014729499816895
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00029587745666504
(522) DESCRIBE `ports` 0.0013539791107178
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 5.0067901611328E-6
(524) DESCRIBE `ports` 0.0013489723205566
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028014183044434
(526) DESCRIBE `ports` 0.0014970302581787
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003209114074707
(528) DESCRIBE `ports` 0.0013120174407959
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029993057250977
(530) DESCRIBE `ports` 0.0019948482513428
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00040507316589355
(532) DESCRIBE `ports` 0.0014569759368896
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00030183792114258
(534) DESCRIBE `ports` 0.0013799667358398
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00031614303588867
(536) DESCRIBE `ports` 0.0014548301696777
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00030016899108887
(538) DESCRIBE `ports` 0.0013020038604736
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00033020973205566
(540) DESCRIBE `ports` 0.0015819072723389
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00032997131347656
(542) DESCRIBE `ports` 0.0012860298156738
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00031304359436035
(544) DESCRIBE `ports` 0.0013391971588135
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00029706954956055
(546) DESCRIBE `ports` 0.0013618469238281
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0003349781036377
(548) DESCRIBE `ports` 0.0013201236724854
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00029802322387695
(550) DESCRIBE `ports` 0.0014858245849609
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003659725189209
(552) DESCRIBE `ports` 0.0013208389282227
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00029492378234863
(554) DESCRIBE `cruises` 0.0025160312652588
(555) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71403))) 0.00053691864013672
(556) DESCRIBE `avid_specials` 0.0012030601501465
(557) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541090 and class = 'Special') OR (item_id = 71403 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0011401176452637
(558) DESCRIBE `cruiselines` 0.0019361972808838
(559) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00040102005004883
(560) DESCRIBE `orchid_image` 0.001701831817627
(561) DESCRIBE `cruiselines` 0.002112865447998
(562) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.0003049373626709
(563) DESCRIBE `cruises` 0.0026359558105469
(564) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71403') 0.00032305717468262
(565) DESCRIBE `ships` 0.0027081966400146
(566) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00047898292541504
(567) DESCRIBE `ships` 0.0027458667755127
(568) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00030994415283203
(569) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00028300285339355
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025391578674316
(571) DESCRIBE `itineraries` 0.0013329982757568
(572) DESCRIBE `ports` 0.001378059387207
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00037813186645508
(574) DESCRIBE `ports` 0.0012891292572021
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00030112266540527
(576) DESCRIBE `ports` 0.0013430118560791
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003349781036377
(578) DESCRIBE `sailingdates` 0.001115083694458
(579) DESCRIBE `ports` 0.0013630390167236
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00031018257141113
(581) DESCRIBE `ports` 0.0016829967498779
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00034713745117188
(583) DESCRIBE `ports` 0.0009160041809082
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00040006637573242
(585) DESCRIBE `ports` 0.0013020038604736
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00028896331787109
(587) DESCRIBE `ports` 0.0013210773468018
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003211498260498
(589) DESCRIBE `ports` 0.0012781620025635
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003049373626709
(591) DESCRIBE `ports` 0.0013809204101562
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031900405883789
(593) DESCRIBE `ports` 0.0014710426330566
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028491020202637
(595) DESCRIBE `ports` 0.0012850761413574
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031685829162598
(597) DESCRIBE `ports` 0.0012810230255127
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00032997131347656
(599) DESCRIBE `ports` 0.0013539791107178
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0004580020904541
(601) DESCRIBE `ports` 0.0014588832855225
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00031399726867676
(603) DESCRIBE `ports` 0.001471996307373
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00035381317138672
(605) DESCRIBE `ports` 0.0013070106506348
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00032496452331543
(607) DESCRIBE `ports` 0.0010929107666016
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00032305717468262
(609) DESCRIBE `ports` 0.0017800331115723
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00024700164794922
(611) DESCRIBE `ports` 0.0013039112091064
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00031685829162598
(613) DESCRIBE `ports` 0.0012450218200684
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00028800964355469
(615) DESCRIBE `ports` 0.0013918876647949
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003359317779541
(617) DESCRIBE `ports` 0.001276969909668
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0002899169921875
(619) DESCRIBE `avid_specials` 0.0011200904846191
(620) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71403 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0011248588562012
(621) DESCRIBE `cruiselines` 0.0019121170043945
(622) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00084710121154785
(623) DESCRIBE `orchid_image` 0.001410961151123
(624) DESCRIBE `cruiselines` 0.001884937286377
(625) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00036406517028809
(626) DESCRIBE `cruisetypes` 0.0012669563293457
(627) DESCRIBE `cruiselines` 0.0022611618041992
(628) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00052595138549805
(629) DESCRIBE `ships` 0.0027980804443359
(630) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00044584274291992
(631) DESCRIBE `destinations` 0.0023748874664307
(632) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 26))) 0.0004580020904541
(633) DESCRIBE `destinations` 0.0019078254699707
(634) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 26))) 0.00040888786315918
(635) DESCRIBE `cruiselines` 0.0019030570983887
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.0004429817199707
(637) DESCRIBE `ships` 0.0028769969940186
(638) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0004570484161377