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

Total elapsed time: 0.54286289215088

# Query Time
(1) connect 0.00087714195251465
(2) DESCRIBE `cruises` 0.0037469863891602
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70935, 41778, 70936, 70945, 50864, 41776, 50857, 55702, 70947, 70948)) ORDER BY FIND_IN_SET(id, '70935,41778,70936,70945,50864,41776,50857,55702,70947,70948') 0.0019299983978271
(4) DESCRIBE `cruises` 0.0025279521942139
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00029492378234863
(6) DESCRIBE `ships` 0.0028231143951416
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00040006637573242
(8) DESCRIBE `ships` 0.0034329891204834
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00029110908508301
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(12) DESCRIBE `itineraries` 0.0012781620025635
(13) DESCRIBE `ports` 0.0013120174407959
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(15) DESCRIBE `ports` 0.0014710426330566
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035500526428223
(17) DESCRIBE `ports` 0.001849889755249
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028085708618164
(19) DESCRIBE `sailingdates` 0.0013470649719238
(20) DESCRIBE `ports` 0.0013949871063232
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029921531677246
(22) DESCRIBE `ports` 0.0017280578613281
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029492378234863
(24) DESCRIBE `ports` 0.0016670227050781
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00036001205444336
(26) DESCRIBE `ports` 0.0016219615936279
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027298927307129
(28) DESCRIBE `ports` 0.0013570785522461
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029110908508301
(30) DESCRIBE `ports` 0.0013232231140137
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027108192443848
(32) DESCRIBE `ports` 0.0013158321380615
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00030112266540527
(34) DESCRIBE `ports` 0.0016310214996338
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00027298927307129
(36) DESCRIBE `ports` 0.0016729831695557
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00043201446533203
(38) DESCRIBE `ports` 0.0019130706787109
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00036501884460449
(40) DESCRIBE `ports` 0.0017509460449219
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00034403800964355
(42) DESCRIBE `ports` 0.0012948513031006
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00027799606323242
(44) DESCRIBE `ports` 0.001594066619873
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029301643371582
(46) DESCRIBE `ports` 0.0017189979553223
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027585029602051
(48) DESCRIBE `avid_specials` 0.0015239715576172
(49) 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.0011031627655029
(50) DESCRIBE `cruiselines` 0.0019440650939941
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031495094299316
(52) DESCRIBE `orchid_image` 0.0013890266418457
(53) DESCRIBE `cruiselines` 0.0022201538085938
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026702880859375
(55) DESCRIBE `cruises` 0.0027320384979248
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00029182434082031
(57) DESCRIBE `ships` 0.0024490356445312
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042486190795898
(59) DESCRIBE `ships` 0.0024030208587646
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00034379959106445
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(63) DESCRIBE `itineraries` 0.012204885482788
(64) DESCRIBE `ports` 0.0014200210571289
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035190582275391
(66) DESCRIBE `ports` 0.0012409687042236
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030112266540527
(68) DESCRIBE `ports` 0.0012760162353516
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030303001403809
(70) DESCRIBE `sailingdates` 0.0011160373687744
(71) DESCRIBE `ports` 0.0051181316375732
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040793418884277
(73) DESCRIBE `ports` 0.0014300346374512
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036001205444336
(75) DESCRIBE `ports` 0.001305103302002
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(77) DESCRIBE `ports` 0.0013079643249512
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031805038452148
(79) DESCRIBE `avid_specials` 0.0011940002441406
(80) 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.0010409355163574
(81) DESCRIBE `cruiselines` 0.0018010139465332
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043106079101562
(83) DESCRIBE `orchid_image` 0.0015320777893066
(84) DESCRIBE `cruiselines` 0.0018270015716553
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028204917907715
(86) DESCRIBE `cruises` 0.0024650096893311
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70936') 0.00030803680419922
(88) DESCRIBE `ships` 0.0026001930236816
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00035691261291504
(90) DESCRIBE `ships` 0.0063638687133789
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00038003921508789
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028586387634277
(94) DESCRIBE `itineraries` 0.0013189315795898
(95) DESCRIBE `ports` 0.0012941360473633
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031280517578125
(97) DESCRIBE `ports` 0.0012640953063965
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028800964355469
(99) DESCRIBE `ports` 0.0012729167938232
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002748966217041
(101) DESCRIBE `sailingdates` 0.0010969638824463
(102) DESCRIBE `ports` 0.0012698173522949
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030684471130371
(104) DESCRIBE `ports` 0.0012359619140625
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(106) DESCRIBE `ports` 0.0095062255859375
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0001380443572998
(108) DESCRIBE `ports` 0.0013830661773682
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00037193298339844
(110) DESCRIBE `ports` 0.0017368793487549
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00050210952758789
(112) DESCRIBE `ports` 0.0057499408721924
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00034284591674805
(114) DESCRIBE `ports` 0.0012578964233398
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031495094299316
(116) DESCRIBE `ports` 0.0012691020965576
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0002741813659668
(118) DESCRIBE `ports` 0.0015029907226562
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029897689819336
(120) DESCRIBE `ports` 0.0014851093292236
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028419494628906
(122) DESCRIBE `ports` 0.0013091564178467
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031590461730957
(124) DESCRIBE `ports` 0.0012900829315186
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027298927307129
(126) DESCRIBE `avid_specials` 0.0011031627655029
(127) 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.0011041164398193
(128) DESCRIBE `cruiselines` 0.0019240379333496
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030899047851562
(130) DESCRIBE `orchid_image` 0.0015280246734619
(131) DESCRIBE `cruiselines` 0.0018918514251709
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029802322387695
(133) DESCRIBE `cruises` 0.0025250911712646
(134) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70945') 0.00062298774719238
(135) DESCRIBE `ships` 0.0046191215515137
(136) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0020139217376709
(137) DESCRIBE `ships` 0.0036740303039551
(138) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00037384033203125
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(141) DESCRIBE `itineraries` 0.0017919540405273
(142) DESCRIBE `ports` 0.0018019676208496
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050210952758789
(144) DESCRIBE `ports` 0.0017678737640381
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040102005004883
(146) DESCRIBE `ports` 0.0019080638885498
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038313865661621
(148) DESCRIBE `sailingdates` 0.0018789768218994
(149) DESCRIBE `ports` 0.0018060207366943
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036311149597168
(151) DESCRIBE `ports` 0.00164794921875
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042200088500977
(153) DESCRIBE `ports` 0.0017940998077393
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00031900405883789
(155) DESCRIBE `ports` 0.0019040107727051
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00035190582275391
(157) DESCRIBE `ports` 0.0018360614776611
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00031900405883789
(159) DESCRIBE `ports` 0.0018739700317383
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.0002899169921875
(161) DESCRIBE `ports` 0.0015990734100342
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00060009956359863
(163) DESCRIBE `ports` 0.0017352104187012
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00032901763916016
(165) DESCRIBE `ports` 0.0017330646514893
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00039815902709961
(167) DESCRIBE `ports` 0.0023000240325928
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00037193298339844
(169) DESCRIBE `ports` 0.0017640590667725
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071501731872559
(171) DESCRIBE `ports` 0.0017859935760498
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037717819213867
(173) DESCRIBE `avid_specials` 0.001054048538208
(174) 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.0016989707946777
(175) DESCRIBE `cruiselines` 0.0023088455200195
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00042605400085449
(177) DESCRIBE `orchid_image` 0.0019638538360596
(178) DESCRIBE `cruiselines` 0.0027310848236084
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00038504600524902
(180) DESCRIBE `cruises` 0.0035479068756104
(181) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50864') 0.00039196014404297
(182) DESCRIBE `ships` 0.0036759376525879
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00047588348388672
(184) DESCRIBE `ships` 0.00360107421875
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00037908554077148
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(188) DESCRIBE `itineraries` 0.0013539791107178
(189) DESCRIBE `ports` 0.001305103302002
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(191) DESCRIBE `ports` 0.0012829303741455
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(193) DESCRIBE `ports` 0.0012772083282471
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(195) DESCRIBE `sailingdates` 0.0011718273162842
(196) DESCRIBE `ports` 0.0012719631195068
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032711029052734
(198) DESCRIBE `ports` 0.0012431144714355
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031304359436035
(200) DESCRIBE `ports` 0.0029489994049072
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00034499168395996
(202) DESCRIBE `ports` 0.0012838840484619
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00033807754516602
(204) DESCRIBE `ports` 0.0013620853424072
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00029492378234863
(206) DESCRIBE `ports` 0.0013411045074463
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0002739429473877
(208) DESCRIBE `ports` 0.0012960433959961
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030207633972168
(210) DESCRIBE `ports` 0.0013809204101562
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00033712387084961
(212) DESCRIBE `ports` 0.0017120838165283
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0003049373626709
(214) DESCRIBE `ports` 0.0013558864593506
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00031805038452148
(216) DESCRIBE `ports` 0.0013101100921631
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(218) DESCRIBE `ports` 0.0017850399017334
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(220) DESCRIBE `avid_specials` 0.0011501312255859
(221) 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.0010151863098145
(222) DESCRIBE `cruiselines` 0.0019690990447998
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00029802322387695
(224) DESCRIBE `orchid_image` 0.0014419555664062
(225) DESCRIBE `cruiselines` 0.0023040771484375
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00033712387084961
(227) DESCRIBE `cruises` 0.0031828880310059
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.0003659725189209
(229) DESCRIBE `ships` 0.0032761096954346
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00027990341186523
(231) DESCRIBE `ships` 0.0033650398254395
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00035500526428223
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003211498260498
(235) DESCRIBE `itineraries` 0.0012900829315186
(236) DESCRIBE `ports` 0.0016670227050781
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041103363037109
(238) DESCRIBE `ports` 0.001751184463501
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041890144348145
(240) DESCRIBE `ports` 0.0022339820861816
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(242) DESCRIBE `sailingdates` 0.0017170906066895
(243) DESCRIBE `ports` 0.0017518997192383
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055289268493652
(245) DESCRIBE `ports` 0.001317024230957
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038599967956543
(247) DESCRIBE `ports` 0.0016579627990723
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0006260871887207
(249) DESCRIBE `ports` 0.0017080307006836
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035309791564941
(251) DESCRIBE `ports` 0.0017080307006836
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00029420852661133
(253) DESCRIBE `ports` 0.0017240047454834
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00085997581481934
(255) DESCRIBE `ports` 0.0012860298156738
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00040197372436523
(257) DESCRIBE `ports` 0.0016510486602783
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00035309791564941
(259) DESCRIBE `ports` 0.0018289089202881
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041604042053223
(261) DESCRIBE `ports` 0.0017337799072266
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036191940307617
(263) DESCRIBE `avid_specials` 0.0012538433074951
(264) 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.0015790462493896
(265) DESCRIBE `cruiselines` 0.0023050308227539
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043296813964844
(267) DESCRIBE `orchid_image` 0.0019168853759766
(268) DESCRIBE `cruiselines` 0.0024480819702148
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00039100646972656
(270) DESCRIBE `cruises` 0.003864049911499
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.0004420280456543
(272) DESCRIBE `ships` 0.0036330223083496
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00055098533630371
(274) DESCRIBE `ships` 0.0038681030273438
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00048089027404785
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00064301490783691
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 6.9141387939453E-5
(278) DESCRIBE `itineraries` 0.002129077911377
(279) DESCRIBE `ports` 0.0024991035461426
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038886070251465
(281) DESCRIBE `ports` 0.0013589859008789
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043487548828125
(283) DESCRIBE `ports` 0.0014479160308838
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030183792114258
(285) DESCRIBE `sailingdates` 0.001230001449585
(286) DESCRIBE `ports` 0.0015130043029785
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.000518798828125
(288) DESCRIBE `ports` 0.0018310546875
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032591819763184
(290) DESCRIBE `ports` 0.0014429092407227
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00033283233642578
(292) DESCRIBE `ports` 0.0017950534820557
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00033998489379883
(294) DESCRIBE `ports` 0.0019052028656006
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00032305717468262
(296) DESCRIBE `ports` 0.0014622211456299
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00031495094299316
(298) DESCRIBE `ports` 0.00142502784729
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030207633972168
(300) DESCRIBE `ports` 0.0030848979949951
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028896331787109
(302) DESCRIBE `ports` 0.001378059387207
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031805038452148
(304) DESCRIBE `ports` 0.0016429424285889
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00033783912658691
(306) DESCRIBE `ports` 0.0013790130615234
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033116340637207
(308) DESCRIBE `ports` 0.0013151168823242
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031089782714844
(310) DESCRIBE `avid_specials` 0.001162052154541
(311) 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.0010600090026855
(312) DESCRIBE `cruiselines` 0.0021750926971436
(313) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00053501129150391
(314) DESCRIBE `orchid_image` 0.0018870830535889
(315) DESCRIBE `cruiselines` 0.0021650791168213
(316) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035405158996582
(317) DESCRIBE `cruises` 0.002856969833374
(318) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00041913986206055
(319) DESCRIBE `ships` 0.0027351379394531
(320) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00038599967956543
(321) DESCRIBE `ships` 0.0026769638061523
(322) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032901763916016
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029397010803223
(325) DESCRIBE `itineraries` 0.0014297962188721
(326) DESCRIBE `ports` 0.00136399269104
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035190582275391
(328) DESCRIBE `ports` 0.001276969909668
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(330) DESCRIBE `ports` 0.001417875289917
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036787986755371
(332) DESCRIBE `sailingdates` 0.0011329650878906
(333) DESCRIBE `ports` 0.0013301372528076
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035405158996582
(335) DESCRIBE `ports` 0.0014350414276123
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028014183044434
(337) DESCRIBE `ports` 0.0013358592987061
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.0003199577331543
(339) DESCRIBE `ports` 0.0013611316680908
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0003049373626709
(341) DESCRIBE `ports` 0.0018870830535889
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003211498260498
(343) DESCRIBE `ports` 0.0015349388122559
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003819465637207
(345) DESCRIBE `avid_specials` 0.0013158321380615
(346) 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.0012509822845459
(347) DESCRIBE `cruiselines` 0.002079963684082
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032210350036621
(349) DESCRIBE `orchid_image` 0.0017600059509277
(350) DESCRIBE `cruiselines` 0.0019409656524658
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00056695938110352
(352) DESCRIBE `cruises` 0.0028588771820068
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.0003349781036377
(354) DESCRIBE `ships` 0.0029590129852295
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0005180835723877
(356) DESCRIBE `ships` 0.0026450157165527
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00027298927307129
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027108192443848
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028109550476074
(360) DESCRIBE `itineraries` 0.001633882522583
(361) DESCRIBE `ports` 0.0018670558929443
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 9.0599060058594E-6
(363) DESCRIBE `ports` 0.001323938369751
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030183792114258
(365) DESCRIBE `ports` 0.0014729499816895
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029206275939941
(367) DESCRIBE `sailingdates` 0.001133918762207
(368) DESCRIBE `ports` 0.0012731552124023
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035190582275391
(370) DESCRIBE `ports` 0.0018379688262939
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042891502380371
(372) DESCRIBE `ports` 0.0015189647674561
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00045919418334961
(374) DESCRIBE `ports` 0.0021271705627441
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00044083595275879
(376) DESCRIBE `ports` 0.0013701915740967
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032806396484375
(378) DESCRIBE `ports` 0.0013611316680908
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029277801513672
(380) DESCRIBE `ports` 0.001471996307373
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00032615661621094
(382) DESCRIBE `ports` 0.0012691020965576
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029087066650391
(384) DESCRIBE `ports` 0.001284122467041
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00050497055053711
(386) DESCRIBE `ports` 0.0018248558044434
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00038313865661621
(388) DESCRIBE `ports` 0.0018348693847656
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041913986206055
(390) DESCRIBE `ports` 0.0017271041870117
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035500526428223
(392) DESCRIBE `avid_specials` 0.0015010833740234
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70947 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.0015628337860107
(394) DESCRIBE `cruiselines` 0.0025069713592529
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0004417896270752
(396) DESCRIBE `orchid_image` 0.0019979476928711
(397) DESCRIBE `cruiselines` 0.002626895904541
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041389465332031
(399) DESCRIBE `cruises` 0.0030820369720459
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70948') 0.00035405158996582
(401) DESCRIBE `ships` 0.0026249885559082
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0003819465637207
(403) DESCRIBE `ships` 0.0025169849395752
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00028300285339355
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(407) DESCRIBE `itineraries` 0.0013549327850342
(408) DESCRIBE `ports` 0.0012660026550293
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034999847412109
(410) DESCRIBE `ports` 0.0012490749359131
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(412) DESCRIBE `ports` 0.001317024230957
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029897689819336
(414) DESCRIBE `sailingdates` 0.0011169910430908
(415) DESCRIBE `ports` 0.0013852119445801
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(417) DESCRIBE `ports` 0.0012578964233398
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028204917907715
(419) DESCRIBE `ports` 0.0012619495391846
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00042486190795898
(421) DESCRIBE `ports` 0.0016469955444336
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00042200088500977
(423) DESCRIBE `ports` 0.0013320446014404
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00031399726867676
(425) DESCRIBE `ports` 0.0014219284057617
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00028491020202637
(427) DESCRIBE `ports` 0.0013201236724854
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00037217140197754
(429) DESCRIBE `ports` 0.0013699531555176
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00028705596923828
(431) DESCRIBE `ports` 0.0014998912811279
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00033092498779297
(433) DESCRIBE `ports` 0.0016610622406006
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00036001205444336
(435) DESCRIBE `ports` 0.0014281272888184
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00034093856811523
(437) DESCRIBE `ports` 0.0016958713531494
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00029802322387695
(439) DESCRIBE `ports` 0.0017330646514893
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046205520629883
(441) DESCRIBE `ports` 0.0014479160308838
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029301643371582
(443) DESCRIBE `avid_specials` 0.0014998912811279
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70948 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.0010969638824463
(445) DESCRIBE `cruiselines` 0.002269983291626
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031590461730957
(447) DESCRIBE `orchid_image` 0.0015358924865723
(448) DESCRIBE `cruiselines` 0.0022621154785156
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003211498260498
(450) DESCRIBE `ships` 0.0027189254760742
(451) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722')) ORDER BY FIND_IN_SET(id, '4,1722') 0.00078797340393066
(452) DESCRIBE `cruisetypes` 0.0011019706726074
(453) DESCRIBE `destinations` 0.0016629695892334
(454) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00050806999206543
(455) DESCRIBE `cruiselines` 0.0018420219421387
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033903121948242
(457) DESCRIBE `cruiselines` 0.0019638538360596
(458) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031495094299316