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.57181930541992

# Query Time
(1) connect 0.0010099411010742
(2) DESCRIBE `cruises` 0.0036110877990723
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70917, 70934, 70919, 55703, 41776, 41778, 41780, 50864, 50857, 70935)) ORDER BY FIND_IN_SET(id, '70917,70934,70919,55703,41776,41778,41780,50864,50857,70935') 0.0024240016937256
(4) DESCRIBE `cruises` 0.0038051605224609
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70917') 0.00060606002807617
(6) DESCRIBE `ships` 0.0043239593505859
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0006098747253418
(8) DESCRIBE `ships` 0.0039558410644531
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00036001205444336
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030207633972168
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031685829162598
(12) DESCRIBE `itineraries` 0.0018730163574219
(13) DESCRIBE `ports` 0.0015349388122559
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039196014404297
(15) DESCRIBE `ports` 0.0018060207366943
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040602684020996
(17) DESCRIBE `ports` 0.0018458366394043
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053095817565918
(19) DESCRIBE `sailingdates` 0.0017287731170654
(20) DESCRIBE `ports` 0.0017921924591064
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036907196044922
(22) DESCRIBE `ports` 0.0014040470123291
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028395652770996
(24) DESCRIBE `ports` 0.0016491413116455
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00040793418884277
(26) DESCRIBE `ports` 0.0018241405487061
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035905838012695
(28) DESCRIBE `ports` 0.0016570091247559
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00040507316589355
(30) DESCRIBE `ports` 0.0018270015716553
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00042200088500977
(32) DESCRIBE `ports` 0.0021779537200928
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042605400085449
(34) DESCRIBE `ports` 0.0023510456085205
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038504600524902
(36) DESCRIBE `ports` 0.0018351078033447
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042605400085449
(38) DESCRIBE `ports` 0.0017480850219727
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039219856262207
(40) DESCRIBE `avid_specials` 0.001863956451416
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70917 and class = 'Cruise') OR (item_id = 288 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.0018150806427002
(42) DESCRIBE `cruiselines` 0.00276780128479
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00062799453735352
(44) DESCRIBE `orchid_image` 0.0019159317016602
(45) DESCRIBE `cruiselines` 0.0020530223846436
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0012528896331787
(47) DESCRIBE `cruises` 0.0032880306243896
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70934') 0.00037002563476562
(49) DESCRIBE `ships` 0.0035650730133057
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00064301490783691
(51) DESCRIBE `ships` 0.0038769245147705
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00044894218444824
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(55) DESCRIBE `itineraries` 0.0017950534820557
(56) DESCRIBE `ports` 0.0019419193267822
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050878524780273
(58) DESCRIBE `ports` 0.001863956451416
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046205520629883
(60) DESCRIBE `ports` 0.0016710758209229
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034809112548828
(62) DESCRIBE `sailingdates` 0.0015568733215332
(63) DESCRIBE `ports` 0.0017330646514893
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042104721069336
(65) DESCRIBE `ports` 0.0016679763793945
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003960132598877
(67) DESCRIBE `ports` 0.0017728805541992
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00048685073852539
(69) DESCRIBE `ports` 0.0017759799957275
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00038504600524902
(71) DESCRIBE `ports` 0.0018079280853271
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00043702125549316
(73) DESCRIBE `ports` 0.001835823059082
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00039505958557129
(75) DESCRIBE `ports` 0.0018799304962158
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1901))) 0.00043106079101562
(77) DESCRIBE `ports` 0.0017149448394775
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1901') 0.00038790702819824
(79) DESCRIBE `ports` 0.0018479824066162
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00041317939758301
(81) DESCRIBE `ports` 0.0017809867858887
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00038290023803711
(83) DESCRIBE `ports` 0.0017831325531006
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00041508674621582
(85) DESCRIBE `ports` 0.0018680095672607
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00039005279541016
(87) DESCRIBE `ports` 0.0017988681793213
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041985511779785
(89) DESCRIBE `ports` 0.0017759799957275
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044894218444824
(91) DESCRIBE `avid_specials` 0.0015871524810791
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70934 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.0019071102142334
(93) DESCRIBE `cruiselines` 0.002734899520874
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00048184394836426
(95) DESCRIBE `orchid_image` 0.0020689964294434
(96) DESCRIBE `cruiselines` 0.0025660991668701
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00042390823364258
(98) DESCRIBE `cruises` 0.0035300254821777
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70919') 0.00056600570678711
(100) DESCRIBE `ships` 0.0035359859466553
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00050783157348633
(102) DESCRIBE `ships` 0.0036520957946777
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00048685073852539
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(106) DESCRIBE `itineraries` 0.0016908645629883
(107) DESCRIBE `ports` 0.0017399787902832
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046801567077637
(109) DESCRIBE `ports` 0.0016460418701172
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(111) DESCRIBE `ports` 0.0016207695007324
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037503242492676
(113) DESCRIBE `sailingdates` 0.0016469955444336
(114) DESCRIBE `ports` 0.0018908977508545
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044918060302734
(116) DESCRIBE `ports` 0.0018908977508545
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041413307189941
(118) DESCRIBE `ports` 0.0018680095672607
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00053310394287109
(120) DESCRIBE `ports` 0.0018088817596436
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040602684020996
(122) DESCRIBE `ports` 0.0017058849334717
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00038909912109375
(124) DESCRIBE `ports` 0.0017490386962891
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041079521179199
(126) DESCRIBE `ports` 0.0018060207366943
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00039505958557129
(128) DESCRIBE `ports` 0.0018000602722168
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00033211708068848
(130) DESCRIBE `ports` 0.001582145690918
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0004270076751709
(132) DESCRIBE `ports` 0.0014138221740723
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0002899169921875
(134) DESCRIBE `ports` 0.0013179779052734
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00030183792114258
(136) DESCRIBE `ports` 0.0012431144714355
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00028800964355469
(138) DESCRIBE `ports` 0.0013189315795898
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00031208992004395
(140) DESCRIBE `ports` 0.0012409687042236
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00027990341186523
(142) DESCRIBE `ports` 0.001568078994751
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00040602684020996
(144) DESCRIBE `ports` 0.0014879703521729
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00033783912658691
(146) DESCRIBE `avid_specials` 0.0011858940124512
(147) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70919 and class = 'Cruise') OR (item_id = 288 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.0011959075927734
(148) DESCRIBE `cruiselines` 0.0018889904022217
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035405158996582
(150) DESCRIBE `orchid_image` 0.0015389919281006
(151) DESCRIBE `cruiselines` 0.0020380020141602
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036501884460449
(153) DESCRIBE `cruises` 0.0026178359985352
(154) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.0003509521484375
(155) DESCRIBE `ships` 0.0026679039001465
(156) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00044012069702148
(157) DESCRIBE `ships` 0.0032780170440674
(158) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00048494338989258
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043702125549316
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033020973205566
(161) DESCRIBE `itineraries` 0.0017940998077393
(162) DESCRIBE `ports` 0.0018479824066162
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049710273742676
(164) DESCRIBE `ports` 0.0017111301422119
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038790702819824
(166) DESCRIBE `ports` 0.002018928527832
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037789344787598
(168) DESCRIBE `sailingdates` 0.0015850067138672
(169) DESCRIBE `ports` 0.0018069744110107
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045394897460938
(171) DESCRIBE `ports` 0.001708984375
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003662109375
(173) DESCRIBE `ports` 0.0017411708831787
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.0003349781036377
(175) DESCRIBE `ports` 0.0013248920440674
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00029706954956055
(177) DESCRIBE `ports` 0.0014100074768066
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032997131347656
(179) DESCRIBE `ports` 0.0012609958648682
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027990341186523
(181) DESCRIBE `avid_specials` 0.0014359951019287
(182) 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.0016942024230957
(183) DESCRIBE `cruiselines` 0.0024809837341309
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037479400634766
(185) DESCRIBE `orchid_image` 0.0015690326690674
(186) DESCRIBE `cruiselines` 0.0024490356445312
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003509521484375
(188) DESCRIBE `cruises` 0.0033149719238281
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00053596496582031
(190) DESCRIBE `ships` 0.003777027130127
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00054788589477539
(192) DESCRIBE `ships` 0.003899097442627
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00054693222045898
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(196) DESCRIBE `itineraries` 0.0019989013671875
(197) DESCRIBE `ports` 0.0023479461669922
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053787231445312
(199) DESCRIBE `ports` 0.0020301342010498
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046682357788086
(201) DESCRIBE `ports` 0.001964807510376
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044894218444824
(203) DESCRIBE `sailingdates` 0.0019581317901611
(204) DESCRIBE `ports` 0.0021259784698486
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042295455932617
(206) DESCRIBE `ports` 0.0023810863494873
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004580020904541
(208) DESCRIBE `ports` 0.0019211769104004
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00042891502380371
(210) DESCRIBE `ports` 0.0017759799957275
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035285949707031
(212) DESCRIBE `ports` 0.0020768642425537
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00029397010803223
(214) DESCRIBE `ports` 0.0014190673828125
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0003511905670166
(216) DESCRIBE `ports` 0.0017271041870117
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00040507316589355
(218) DESCRIBE `ports` 0.0016469955444336
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029778480529785
(220) DESCRIBE `ports` 0.0013082027435303
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030612945556641
(222) DESCRIBE `ports` 0.0013201236724854
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029611587524414
(224) DESCRIBE `avid_specials` 0.0012600421905518
(225) 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.0011351108551025
(226) DESCRIBE `cruiselines` 0.0019519329071045
(227) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003669261932373
(228) DESCRIBE `orchid_image` 0.0016441345214844
(229) DESCRIBE `cruiselines` 0.0023798942565918
(230) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00033402442932129
(231) DESCRIBE `cruises` 0.0030460357666016
(232) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00038003921508789
(233) DESCRIBE `ships` 0.0036520957946777
(234) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00049114227294922
(235) DESCRIBE `ships` 0.003303050994873
(236) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00031900405883789
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031495094299316
(239) DESCRIBE `itineraries` 0.0021359920501709
(240) DESCRIBE `ports` 0.0015840530395508
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040411949157715
(242) DESCRIBE `ports` 0.0014359951019287
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003058910369873
(244) DESCRIBE `ports` 0.0016229152679443
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003049373626709
(246) DESCRIBE `sailingdates` 0.0014159679412842
(247) DESCRIBE `ports` 0.0018692016601562
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046086311340332
(249) DESCRIBE `ports` 0.0017039775848389
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044608116149902
(251) DESCRIBE `ports` 0.0017249584197998
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003211498260498
(253) DESCRIBE `ports` 0.0017969608306885
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029087066650391
(255) DESCRIBE `avid_specials` 0.0013618469238281
(256) 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.0010981559753418
(257) DESCRIBE `cruiselines` 0.0024340152740479
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033092498779297
(259) DESCRIBE `orchid_image` 0.0017650127410889
(260) DESCRIBE `cruiselines` 0.0019168853759766
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031805038452148
(262) DESCRIBE `cruises` 0.0027759075164795
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41780') 0.00036716461181641
(264) DESCRIBE `ships` 0.003615140914917
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00056314468383789
(266) DESCRIBE `ships` 0.0035901069641113
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003809928894043
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032782554626465
(270) DESCRIBE `itineraries` 0.0017430782318115
(271) DESCRIBE `ports` 0.0017910003662109
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042200088500977
(273) DESCRIBE `ports` 0.0017077922821045
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038504600524902
(275) DESCRIBE `ports` 0.0017709732055664
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043177604675293
(277) DESCRIBE `sailingdates` 0.0014841556549072
(278) DESCRIBE `ports` 0.00199294090271
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047993659973145
(280) DESCRIBE `ports` 0.001561164855957
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034594535827637
(282) DESCRIBE `ports` 0.0015459060668945
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00044512748718262
(284) DESCRIBE `ports` 0.0015711784362793
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00034284591674805
(286) DESCRIBE `ports` 0.0019030570983887
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00040888786315918
(288) DESCRIBE `ports` 0.0017709732055664
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027894973754883
(290) DESCRIBE `ports` 0.0013110637664795
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0004119873046875
(292) DESCRIBE `ports` 0.0018830299377441
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00039505958557129
(294) DESCRIBE `ports` 0.0014481544494629
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037384033203125
(296) DESCRIBE `ports` 0.0018458366394043
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037598609924316
(298) DESCRIBE `avid_specials` 0.0016839504241943
(299) 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.0018808841705322
(300) DESCRIBE `cruiselines` 0.0026469230651855
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046896934509277
(302) DESCRIBE `orchid_image` 0.0020809173583984
(303) DESCRIBE `cruiselines` 0.0019359588623047
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035190582275391
(305) DESCRIBE `cruises` 0.0027809143066406
(306) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50864') 0.00043082237243652
(307) DESCRIBE `ships` 0.003187894821167
(308) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0004889965057373
(309) DESCRIBE `ships` 0.0029458999633789
(310) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0004279613494873
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027108192443848
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002589225769043
(313) DESCRIBE `itineraries` 0.0013940334320068
(314) DESCRIBE `ports` 0.0015771389007568
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(316) DESCRIBE `ports` 0.0020899772644043
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057101249694824
(318) DESCRIBE `ports` 0.0020909309387207
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004119873046875
(320) DESCRIBE `sailingdates` 0.0019068717956543
(321) DESCRIBE `ports` 0.0016729831695557
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035691261291504
(323) DESCRIBE `ports` 0.0013940334320068
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032496452331543
(325) DESCRIBE `ports` 0.001317024230957
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00032997131347656
(327) DESCRIBE `ports` 0.001823902130127
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035309791564941
(329) DESCRIBE `ports` 0.0019211769104004
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00031805038452148
(331) DESCRIBE `ports` 0.0013730525970459
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028109550476074
(333) DESCRIBE `ports` 0.0014920234680176
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032901763916016
(335) DESCRIBE `ports` 0.0013329982757568
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029492378234863
(337) DESCRIBE `ports` 0.0012950897216797
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0003960132598877
(339) DESCRIBE `ports` 0.0018680095672607
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038695335388184
(341) DESCRIBE `ports` 0.0014920234680176
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033092498779297
(343) DESCRIBE `ports` 0.0017919540405273
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035500526428223
(345) DESCRIBE `avid_specials` 0.0011470317840576
(346) 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.0014598369598389
(347) DESCRIBE `cruiselines` 0.0031168460845947
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00058388710021973
(349) DESCRIBE `orchid_image` 0.0025200843811035
(350) DESCRIBE `cruiselines` 0.003108024597168
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035905838012695
(352) DESCRIBE `cruises` 0.0036020278930664
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.0004270076751709
(354) DESCRIBE `ships` 0.0031988620758057
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00051593780517578
(356) DESCRIBE `ships` 0.0042078495025635
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046515464782715
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(360) DESCRIBE `itineraries` 0.0019631385803223
(361) DESCRIBE `ports` 0.0018818378448486
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043821334838867
(363) DESCRIBE `ports` 0.0016839504241943
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040102005004883
(365) DESCRIBE `ports` 0.0017240047454834
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043392181396484
(367) DESCRIBE `sailingdates` 0.0015809535980225
(368) DESCRIBE `ports` 0.00180983543396
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035619735717773
(370) DESCRIBE `ports` 0.0016489028930664
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031399726867676
(372) DESCRIBE `ports` 0.0013189315795898
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00038313865661621
(374) DESCRIBE `ports` 0.0013298988342285
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027799606323242
(376) DESCRIBE `ports` 0.0013480186462402
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030016899108887
(378) DESCRIBE `ports` 0.0012600421905518
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00029802322387695
(380) DESCRIBE `ports` 0.0017890930175781
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00040912628173828
(382) DESCRIBE `ports` 0.0018630027770996
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00036120414733887
(384) DESCRIBE `ports` 0.0017478466033936
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00041890144348145
(386) DESCRIBE `ports` 0.0017490386962891
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027894973754883
(388) DESCRIBE `ports` 0.0013220310211182
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(390) DESCRIBE `ports` 0.0012531280517578
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030207633972168
(392) DESCRIBE `avid_specials` 0.0011329650878906
(393) 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.0015368461608887
(394) DESCRIBE `cruiselines` 0.0021951198577881
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039410591125488
(396) DESCRIBE `orchid_image` 0.0016508102416992
(397) DESCRIBE `cruiselines` 0.0022039413452148
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040602684020996
(399) DESCRIBE `cruises` 0.0028400421142578
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00043606758117676
(401) DESCRIBE `ships` 0.0054061412811279
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00060915946960449
(403) DESCRIBE `ships` 0.004356861114502
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00049185752868652
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028014183044434
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(407) DESCRIBE `itineraries` 0.0015490055084229
(408) DESCRIBE `ports` 0.0015549659729004
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045013427734375
(410) DESCRIBE `ports` 0.00177001953125
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049400329589844
(412) DESCRIBE `ports` 0.0018308162689209
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040292739868164
(414) DESCRIBE `sailingdates` 0.0018877983093262
(415) DESCRIBE `ports` 0.0018689632415771
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039911270141602
(417) DESCRIBE `ports` 0.0018618106842041
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042605400085449
(419) DESCRIBE `ports` 0.0017459392547607
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00040698051452637
(421) DESCRIBE `ports` 0.0013668537139893
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00039887428283691
(423) DESCRIBE `ports` 0.0014028549194336
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032687187194824
(425) DESCRIBE `ports` 0.0016448497772217
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00030803680419922
(427) DESCRIBE `ports` 0.0013189315795898
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00032997131347656
(429) DESCRIBE `ports` 0.0014221668243408
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00035715103149414
(431) DESCRIBE `ports` 0.0014979839324951
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00038981437683105
(433) DESCRIBE `ports` 0.0016820430755615
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00031900405883789
(435) DESCRIBE `ports` 0.0013358592987061
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00031709671020508
(437) DESCRIBE `ports` 0.0039181709289551
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00033402442932129
(439) DESCRIBE `ports` 0.0013580322265625
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(441) DESCRIBE `ports` 0.0017621517181396
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033283233642578
(443) DESCRIBE `avid_specials` 0.0012149810791016
(444) 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.0016388893127441
(445) DESCRIBE `cruiselines` 0.0026271343231201
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046300888061523
(447) DESCRIBE `orchid_image` 0.0017158985137939
(448) DESCRIBE `cruiselines` 0.0018260478973389
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031805038452148
(450) DESCRIBE `ships` 0.0027768611907959
(451) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722', '288')) ORDER BY FIND_IN_SET(id, '4,1722,288') 0.00071382522583008
(452) DESCRIBE `cruisetypes` 0.0010919570922852
(453) DESCRIBE `destinations` 0.0018210411071777
(454) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00052618980407715
(455) DESCRIBE `cruiselines` 0.0019068717956543
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003349781036377
(457) DESCRIBE `cruiselines` 0.0023109912872314
(458) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00050687789916992