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

Total elapsed time: 0.49896669387817

# Query Time
(1) connect 0.00068497657775879
(2) DESCRIBE `cruises` 0.0035519599914551
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41780, 50864, 55703, 50857, 70935, 41778, 70936, 70945, 41776, 55702)) ORDER BY FIND_IN_SET(id, '41780,50864,55703,50857,70935,41778,70936,70945,41776,55702') 0.002251148223877
(4) DESCRIBE `cruises` 0.0038189888000488
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41780') 0.00050592422485352
(6) DESCRIBE `ships` 0.00325608253479
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00088191032409668
(8) DESCRIBE `ships` 0.0038011074066162
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003969669342041
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028419494628906
(12) DESCRIBE `itineraries` 0.0015809535980225
(13) DESCRIBE `ports` 0.001600980758667
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(15) DESCRIBE `ports` 0.0014450550079346
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034499168395996
(17) DESCRIBE `ports` 0.0014779567718506
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030398368835449
(19) DESCRIBE `sailingdates` 0.0012798309326172
(20) DESCRIBE `ports` 0.0015549659729004
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039505958557129
(22) DESCRIBE `ports` 0.0015017986297607
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033879280090332
(24) DESCRIBE `ports` 0.001439094543457
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00035810470581055
(26) DESCRIBE `ports` 0.0014331340789795
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028491020202637
(28) DESCRIBE `ports` 0.0015180110931396
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00034904479980469
(30) DESCRIBE `ports` 0.0014388561248779
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00031399726867676
(32) DESCRIBE `ports` 0.0014669895172119
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00036501884460449
(34) DESCRIBE `ports` 0.0015139579772949
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00033903121948242
(36) DESCRIBE `ports` 0.0014550685882568
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042986869812012
(38) DESCRIBE `ports` 0.0014731884002686
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034403800964355
(40) DESCRIBE `avid_specials` 0.0013270378112793
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41780 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001450777053833
(42) DESCRIBE `cruiselines` 0.0021049976348877
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039792060852051
(44) DESCRIBE `orchid_image` 0.00166916847229
(45) DESCRIBE `cruiselines` 0.0020608901977539
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034713745117188
(47) DESCRIBE `cruises` 0.0030279159545898
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50864') 0.00038886070251465
(49) DESCRIBE `ships` 0.0033040046691895
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0004730224609375
(51) DESCRIBE `ships` 0.0031399726867676
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00036215782165527
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028896331787109
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(55) DESCRIBE `itineraries` 0.0014870166778564
(56) DESCRIBE `ports` 0.0016090869903564
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037908554077148
(58) DESCRIBE `ports` 0.0014650821685791
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034093856811523
(60) DESCRIBE `ports` 0.001410961151123
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032615661621094
(62) DESCRIBE `sailingdates` 0.0012879371643066
(63) DESCRIBE `ports` 0.0015091896057129
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035810470581055
(65) DESCRIBE `ports` 0.0014209747314453
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(67) DESCRIBE `ports` 0.00152587890625
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00036001205444336
(69) DESCRIBE `ports` 0.0014801025390625
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00031495094299316
(71) DESCRIBE `ports` 0.001446008682251
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00036311149597168
(73) DESCRIBE `ports` 0.0014472007751465
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00032401084899902
(75) DESCRIBE `ports` 0.0015389919281006
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00038790702819824
(77) DESCRIBE `ports` 0.0017538070678711
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00035595893859863
(79) DESCRIBE `ports` 0.0014219284057617
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00034189224243164
(81) DESCRIBE `ports` 0.0014519691467285
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0002748966217041
(83) DESCRIBE `ports` 0.0013270378112793
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033402442932129
(85) DESCRIBE `ports` 0.0014679431915283
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026988983154297
(87) DESCRIBE `avid_specials` 0.0012619495391846
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50864 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012960433959961
(89) DESCRIBE `cruiselines` 0.0019130706787109
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0006101131439209
(91) DESCRIBE `orchid_image` 0.0018291473388672
(92) DESCRIBE `cruiselines` 0.001816987991333
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00030303001403809
(94) DESCRIBE `cruises` 0.0028629302978516
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00046300888061523
(96) DESCRIBE `ships` 0.0035078525543213
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00051593780517578
(98) DESCRIBE `ships` 0.0031170845031738
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00034308433532715
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002601146697998
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(102) DESCRIBE `itineraries` 0.0014641284942627
(103) DESCRIBE `ports` 0.0013718605041504
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034379959106445
(105) DESCRIBE `ports` 0.0012509822845459
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028491020202637
(107) DESCRIBE `ports` 0.0014359951019287
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032877922058105
(109) DESCRIBE `sailingdates` 0.0016050338745117
(110) DESCRIBE `ports` 0.0016958713531494
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051403045654297
(112) DESCRIBE `ports` 0.0019190311431885
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054502487182617
(114) DESCRIBE `ports` 0.0016860961914062
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00033307075500488
(116) DESCRIBE `ports` 0.0013139247894287
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00035214424133301
(118) DESCRIBE `ports` 0.0013999938964844
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040006637573242
(120) DESCRIBE `ports` 0.001619815826416
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033998489379883
(122) DESCRIBE `avid_specials` 0.0014867782592773
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0011181831359863
(124) DESCRIBE `cruiselines` 0.0023350715637207
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0006558895111084
(126) DESCRIBE `orchid_image` 0.0021328926086426
(127) DESCRIBE `cruiselines` 0.0027449131011963
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036501884460449
(129) DESCRIBE `cruises` 0.0037088394165039
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00042510032653809
(131) DESCRIBE `ships` 0.0036981105804443
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00057816505432129
(133) DESCRIBE `ships` 0.0039589405059814
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00047707557678223
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(137) DESCRIBE `itineraries` 0.0018379688262939
(138) DESCRIBE `ports` 0.0015158653259277
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039005279541016
(140) DESCRIBE `ports` 0.0017480850219727
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(142) DESCRIBE `ports` 0.0013008117675781
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029420852661133
(144) DESCRIBE `sailingdates` 0.0012228488922119
(145) DESCRIBE `ports` 0.0017240047454834
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040507316589355
(147) DESCRIBE `ports` 0.001446008682251
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030899047851562
(149) DESCRIBE `ports` 0.0014579296112061
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00032401084899902
(151) DESCRIBE `ports` 0.0014429092407227
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027990341186523
(153) DESCRIBE `ports` 0.0013329982757568
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030994415283203
(155) DESCRIBE `ports` 0.0013911724090576
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00032806396484375
(157) DESCRIBE `ports` 0.0014429092407227
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00036406517028809
(159) DESCRIBE `ports` 0.0015618801116943
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00029516220092773
(161) DESCRIBE `ports` 0.0014920234680176
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00041294097900391
(163) DESCRIBE `ports` 0.0014200210571289
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00039911270141602
(165) DESCRIBE `ports` 0.0013449192047119
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(167) DESCRIBE `ports` 0.0015180110931396
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043702125549316
(169) DESCRIBE `avid_specials` 0.0012471675872803
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013160705566406
(171) DESCRIBE `cruiselines` 0.0018930435180664
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043988227844238
(173) DESCRIBE `orchid_image` 0.0017099380493164
(174) DESCRIBE `cruiselines` 0.0019478797912598
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032782554626465
(176) DESCRIBE `cruises` 0.0027000904083252
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00035405158996582
(178) DESCRIBE `ships` 0.0032069683074951
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00050997734069824
(180) DESCRIBE `ships` 0.0025842189788818
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003211498260498
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002739429473877
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(184) DESCRIBE `itineraries` 0.0013210773468018
(185) DESCRIBE `ports` 0.001762866973877
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041794776916504
(187) DESCRIBE `ports` 0.0013329982757568
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035715103149414
(189) DESCRIBE `ports` 0.0017359256744385
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042915344238281
(191) DESCRIBE `sailingdates` 0.0016720294952393
(192) DESCRIBE `ports` 0.0020449161529541
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049209594726562
(194) DESCRIBE `ports` 0.0018880367279053
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043821334838867
(196) DESCRIBE `ports` 0.0017549991607666
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003349781036377
(198) DESCRIBE `ports` 0.0019760131835938
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00049400329589844
(200) DESCRIBE `ports` 0.0017859935760498
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00056219100952148
(202) DESCRIBE `ports` 0.0013689994812012
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029110908508301
(204) DESCRIBE `ports` 0.001317024230957
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00037193298339844
(206) DESCRIBE `ports` 0.0014829635620117
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00030708312988281
(208) DESCRIBE `ports` 0.001643180847168
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00038409233093262
(210) DESCRIBE `ports` 0.0014421939849854
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00030303001403809
(212) DESCRIBE `ports` 0.0014920234680176
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00035595893859863
(214) DESCRIBE `ports` 0.0014362335205078
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00036907196044922
(216) DESCRIBE `ports` 0.001723051071167
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045394897460938
(218) DESCRIBE `ports` 0.0017938613891602
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038003921508789
(220) DESCRIBE `avid_specials` 0.0016069412231445
(221) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70935 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017650127410889
(222) DESCRIBE `cruiselines` 0.0028131008148193
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047683715820312
(224) DESCRIBE `orchid_image` 0.0018792152404785
(225) DESCRIBE `cruiselines` 0.001878023147583
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032305717468262
(227) DESCRIBE `cruises` 0.0027880668640137
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00034403800964355
(229) DESCRIBE `ships` 0.00319504737854
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00044488906860352
(231) DESCRIBE `ships` 0.0030570030212402
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046205520629883
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003361701965332
(235) DESCRIBE `itineraries` 0.0017819404602051
(236) DESCRIBE `ports` 0.0017719268798828
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(238) DESCRIBE `ports` 0.0017971992492676
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052213668823242
(240) DESCRIBE `ports` 0.0018839836120605
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045204162597656
(242) DESCRIBE `sailingdates` 0.001323938369751
(243) DESCRIBE `ports` 0.0016438961029053
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036215782165527
(245) DESCRIBE `ports` 0.00142502784729
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032401084899902
(247) DESCRIBE `ports` 0.001345157623291
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065302848815918
(249) DESCRIBE `ports` 0.0018870830535889
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048398971557617
(251) DESCRIBE `avid_specials` 0.0015819072723389
(252) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0012919902801514
(253) DESCRIBE `cruiselines` 0.0019800662994385
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00055789947509766
(255) DESCRIBE `orchid_image` 0.0016059875488281
(256) DESCRIBE `cruiselines` 0.0018858909606934
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032305717468262
(258) DESCRIBE `cruises` 0.0033888816833496
(259) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70936') 0.00046491622924805
(260) DESCRIBE `ships` 0.0030510425567627
(261) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042200088500977
(262) DESCRIBE `ships` 0.003154993057251
(263) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00037598609924316
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025582313537598
(266) DESCRIBE `itineraries` 0.001568078994751
(267) DESCRIBE `ports` 0.0018670558929443
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046896934509277
(269) DESCRIBE `ports` 0.0018560886383057
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044488906860352
(271) DESCRIBE `ports` 0.0018558502197266
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039911270141602
(273) DESCRIBE `sailingdates` 0.0016231536865234
(274) DESCRIBE `ports` 0.0014510154724121
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047612190246582
(276) DESCRIBE `ports` 0.0016140937805176
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029802322387695
(278) DESCRIBE `ports` 0.0015568733215332
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00042104721069336
(280) DESCRIBE `ports` 0.0013859272003174
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00032687187194824
(282) DESCRIBE `ports` 0.001349925994873
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00035500526428223
(284) DESCRIBE `ports` 0.0014090538024902
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00039005279541016
(286) DESCRIBE `ports` 0.0016970634460449
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00042200088500977
(288) DESCRIBE `ports` 0.0017068386077881
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00049996376037598
(290) DESCRIBE `ports` 0.0016570091247559
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00034189224243164
(292) DESCRIBE `ports` 0.0014238357543945
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00029516220092773
(294) DESCRIBE `ports` 0.001288890838623
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003659725189209
(296) DESCRIBE `ports` 0.0012869834899902
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035309791564941
(298) DESCRIBE `avid_specials` 0.0011990070343018
(299) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70936 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010120868682861
(300) DESCRIBE `cruiselines` 0.0020239353179932
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003349781036377
(302) DESCRIBE `orchid_image` 0.0015311241149902
(303) DESCRIBE `cruiselines` 0.0020132064819336
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031900405883789
(305) DESCRIBE `cruises` 0.0027410984039307
(306) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70945') 0.00053286552429199
(307) DESCRIBE `ships` 0.0029489994049072
(308) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00045013427734375
(309) DESCRIBE `ships` 0.0027940273284912
(310) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032496452331543
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028491020202637
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(313) DESCRIBE `itineraries` 0.0013461112976074
(314) DESCRIBE `ports` 0.0013179779052734
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033307075500488
(316) DESCRIBE `ports` 0.0012531280517578
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036215782165527
(318) DESCRIBE `ports` 0.0014688968658447
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034904479980469
(320) DESCRIBE `sailingdates` 0.0011680126190186
(321) DESCRIBE `ports` 0.0013160705566406
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003361701965332
(323) DESCRIBE `ports` 0.0013139247894287
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034594535827637
(325) DESCRIBE `ports` 0.0013699531555176
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00034809112548828
(327) DESCRIBE `ports` 0.001431941986084
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00028395652770996
(329) DESCRIBE `ports` 0.0013079643249512
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00033116340637207
(331) DESCRIBE `ports` 0.0014669895172119
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00037503242492676
(333) DESCRIBE `ports` 0.0013141632080078
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00035500526428223
(335) DESCRIBE `ports` 0.0015780925750732
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00031089782714844
(337) DESCRIBE `ports` 0.0013501644134521
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00033402442932129
(339) DESCRIBE `ports` 0.0012619495391846
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00028109550476074
(341) DESCRIBE `ports` 0.0012838840484619
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(343) DESCRIBE `ports` 0.0015008449554443
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033402442932129
(345) DESCRIBE `avid_specials` 0.0012040138244629
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70945 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0011000633239746
(347) DESCRIBE `cruiselines` 0.0020151138305664
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034999847412109
(349) DESCRIBE `orchid_image` 0.0015079975128174
(350) DESCRIBE `cruiselines` 0.0021510124206543
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031185150146484
(352) DESCRIBE `cruises` 0.0028009414672852
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00033783912658691
(354) DESCRIBE `ships` 0.0028729438781738
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00053596496582031
(356) DESCRIBE `ships` 0.004080057144165
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00053906440734863
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035881996154785
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026321411132812
(360) DESCRIBE `itineraries` 0.001410961151123
(361) DESCRIBE `ports` 0.0015280246734619
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036501884460449
(363) DESCRIBE `ports` 0.001539945602417
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039887428283691
(365) DESCRIBE `ports` 0.0013530254364014
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003972053527832
(367) DESCRIBE `sailingdates` 0.0015199184417725
(368) DESCRIBE `ports` 0.0018570423126221
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042486190795898
(370) DESCRIBE `ports` 0.0014870166778564
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029301643371582
(372) DESCRIBE `ports` 0.0014030933380127
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031089782714844
(374) DESCRIBE `ports` 0.0012738704681396
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027894973754883
(376) DESCRIBE `ports` 0.0013649463653564
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00044417381286621
(378) DESCRIBE `ports` 0.0015511512756348
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00029516220092773
(380) DESCRIBE `ports` 0.0013628005981445
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042581558227539
(382) DESCRIBE `ports` 0.0016689300537109
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028800964355469
(384) DESCRIBE `ports` 0.0014450550079346
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034785270690918
(386) DESCRIBE `ports` 0.001284122467041
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029110908508301
(388) DESCRIBE `avid_specials` 0.0011799335479736
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013298988342285
(390) DESCRIBE `cruiselines` 0.002446174621582
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003659725189209
(392) DESCRIBE `orchid_image` 0.0016629695892334
(393) DESCRIBE `cruiselines` 0.0018601417541504
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00045895576477051
(395) DESCRIBE `cruises` 0.0025670528411865
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00036311149597168
(397) DESCRIBE `ships` 0.0030560493469238
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00053286552429199
(399) DESCRIBE `ships` 0.0035309791564941
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00040984153747559
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031685829162598
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(403) DESCRIBE `itineraries` 0.0015740394592285
(404) DESCRIBE `ports` 0.001723051071167
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036001205444336
(406) DESCRIBE `ports` 0.001295804977417
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036096572875977
(408) DESCRIBE `ports` 0.0014820098876953
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030207633972168
(410) DESCRIBE `sailingdates` 0.0012228488922119
(411) DESCRIBE `ports` 0.0017950534820557
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057196617126465
(413) DESCRIBE `ports` 0.0015780925750732
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034904479980469
(415) DESCRIBE `ports` 0.0018880367279053
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00043606758117676
(417) DESCRIBE `ports` 0.0014400482177734
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0002899169921875
(419) DESCRIBE `ports` 0.0013060569763184
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(421) DESCRIBE `ports` 0.0014431476593018
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030303001403809
(423) DESCRIBE `avid_specials` 0.0014019012451172
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55702 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.001366138458252
(425) DESCRIBE `cruiselines` 0.0019631385803223
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041890144348145
(427) DESCRIBE `orchid_image` 0.001878023147583
(428) DESCRIBE `cruiselines` 0.0021200180053711
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034213066101074
(430) DESCRIBE `ships` 0.0030429363250732
(431) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722')) ORDER BY FIND_IN_SET(id, '4,1722') 0.00095009803771973
(432) DESCRIBE `cruisetypes` 0.0014760494232178
(433) DESCRIBE `destinations` 0.001971960067749
(434) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00054287910461426
(435) DESCRIBE `cruiselines` 0.0018789768218994
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035381317138672
(437) DESCRIBE `cruiselines` 0.0022308826446533
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035405158996582