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

# Query Time
(1) connect 0.00079107284545898
(2) DESCRIBE `cruises` 0.0027999877929688
(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.0011839866638184
(4) DESCRIBE `cruises` 0.0030579566955566
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00041389465332031
(6) DESCRIBE `ships` 0.0025420188903809
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00049495697021484
(8) DESCRIBE `ships` 0.002871036529541
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00029587745666504
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026178359985352
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(12) DESCRIBE `itineraries` 0.0012881755828857
(13) DESCRIBE `ports` 0.0015120506286621
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032305717468262
(15) DESCRIBE `ports` 0.0015039443969727
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039482116699219
(17) DESCRIBE `ports` 0.0015678405761719
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034785270690918
(19) DESCRIBE `sailingdates` 0.0012390613555908
(20) DESCRIBE `ports` 0.0018630027770996
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048398971557617
(22) DESCRIBE `ports` 0.0015389919281006
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029301643371582
(24) DESCRIBE `ports` 0.0014660358428955
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003349781036377
(26) DESCRIBE `ports` 0.0014328956604004
(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.00029587745666504
(30) DESCRIBE `ports` 0.0012907981872559
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00035214424133301
(32) DESCRIBE `ports` 0.0012691020965576
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00028800964355469
(34) DESCRIBE `ports` 0.0012669563293457
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00026798248291016
(36) DESCRIBE `ports` 0.00154709815979
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00037908554077148
(38) DESCRIBE `ports` 0.0014150142669678
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00027203559875488
(40) DESCRIBE `ports` 0.001284122467041
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 9.8943710327148E-5
(42) DESCRIBE `ports` 0.001262903213501
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00027108192443848
(44) DESCRIBE `ports` 0.0012388229370117
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031018257141113
(46) DESCRIBE `ports` 0.0016250610351562
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057387351989746
(48) DESCRIBE `avid_specials` 0.0012590885162354
(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.0011389255523682
(50) DESCRIBE `cruiselines` 0.0020308494567871
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034189224243164
(52) DESCRIBE `orchid_image` 0.0016059875488281
(53) DESCRIBE `cruiselines` 0.0017650127410889
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00030803680419922
(55) DESCRIBE `cruises` 0.0024189949035645
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.0004279613494873
(57) DESCRIBE `ships` 0.0036959648132324
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00038599967956543
(59) DESCRIBE `ships` 0.0029537677764893
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00035619735717773
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025415420532227
(63) DESCRIBE `itineraries` 0.0014290809631348
(64) DESCRIBE `ports` 0.00130295753479
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035786628723145
(66) DESCRIBE `ports` 0.0012471675872803
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002892017364502
(68) DESCRIBE `ports` 0.0012400150299072
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028085708618164
(70) DESCRIBE `sailingdates` 0.0011091232299805
(71) DESCRIBE `ports` 0.0012998580932617
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033998489379883
(73) DESCRIBE `ports` 0.0012409687042236
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046610832214355
(75) DESCRIBE `ports` 0.0014510154724121
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031018257141113
(77) DESCRIBE `ports` 0.001276969909668
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002748966217041
(79) DESCRIBE `avid_specials` 0.0011560916900635
(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.0011069774627686
(81) DESCRIBE `cruiselines` 0.0018751621246338
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030183792114258
(83) DESCRIBE `orchid_image` 0.001716136932373
(84) DESCRIBE `cruiselines` 0.0023219585418701
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032687187194824
(86) DESCRIBE `cruises` 0.0025699138641357
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70936') 0.00034999847412109
(88) DESCRIBE `ships` 0.0025489330291748
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00035500526428223
(90) DESCRIBE `ships` 0.002830982208252
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00034594535827637
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(94) DESCRIBE `itineraries` 0.0012168884277344
(95) DESCRIBE `ports` 0.0013508796691895
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(97) DESCRIBE `ports` 0.0012359619140625
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028705596923828
(99) DESCRIBE `ports` 0.0012919902801514
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002739429473877
(101) DESCRIBE `sailingdates` 0.001105785369873
(102) DESCRIBE `ports` 0.0014338493347168
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(104) DESCRIBE `ports` 0.0012810230255127
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(106) DESCRIBE `ports` 0.0012731552124023
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00027799606323242
(108) DESCRIBE `ports` 0.0013329982757568
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028181076049805
(110) DESCRIBE `ports` 0.0014469623565674
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030994415283203
(112) DESCRIBE `ports` 0.0012669563293457
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00027108192443848
(114) DESCRIBE `ports` 0.0012319087982178
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031185150146484
(116) DESCRIBE `ports` 0.0013141632080078
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027084350585938
(118) DESCRIBE `ports` 0.0012390613555908
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00030112266540527
(120) DESCRIBE `ports` 0.0012638568878174
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028705596923828
(122) DESCRIBE `ports` 0.0014660358428955
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(124) DESCRIBE `ports` 0.0013868808746338
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033187866210938
(126) DESCRIBE `avid_specials` 0.0011348724365234
(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.0010530948638916
(128) DESCRIBE `cruiselines` 0.0023839473724365
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037002563476562
(130) DESCRIBE `orchid_image` 0.0014150142669678
(131) DESCRIBE `cruiselines` 0.0022211074829102
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031685829162598
(133) DESCRIBE `cruises` 0.0024471282958984
(134) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70945') 0.00030303001403809
(135) DESCRIBE `ships` 0.0024769306182861
(136) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00036287307739258
(137) DESCRIBE `ships` 0.0027191638946533
(138) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032496452331543
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031208992004395
(141) DESCRIBE `itineraries` 0.0014989376068115
(142) DESCRIBE `ports` 0.001298189163208
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032210350036621
(144) DESCRIBE `ports` 0.0013329982757568
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(146) DESCRIBE `ports` 0.0012450218200684
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002739429473877
(148) DESCRIBE `sailingdates` 0.0011980533599854
(149) DESCRIBE `ports` 0.0012609958648682
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030112266540527
(151) DESCRIBE `ports` 0.0013799667358398
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028419494628906
(153) DESCRIBE `ports` 0.0012531280517578
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00046801567077637
(155) DESCRIBE `ports` 0.0013391971588135
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00027298927307129
(157) DESCRIBE `ports` 0.0012459754943848
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00030994415283203
(159) DESCRIBE `ports` 0.0013210773468018
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00028204917907715
(161) DESCRIBE `ports` 0.0013561248779297
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00030088424682617
(163) DESCRIBE `ports` 0.0013289451599121
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00034809112548828
(165) DESCRIBE `ports` 0.0014331340789795
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00030517578125
(167) DESCRIBE `ports` 0.0013461112976074
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00028300285339355
(169) DESCRIBE `ports` 0.0014650821685791
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(171) DESCRIBE `ports` 0.0012831687927246
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002751350402832
(173) DESCRIBE `avid_specials` 0.0011270046234131
(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.0010299682617188
(175) DESCRIBE `cruiselines` 0.0018248558044434
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032401084899902
(177) DESCRIBE `orchid_image` 0.0014300346374512
(178) DESCRIBE `cruiselines` 0.0017697811126709
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028491020202637
(180) DESCRIBE `cruises` 0.0024940967559814
(181) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50864') 0.00029587745666504
(182) DESCRIBE `ships` 0.0026159286499023
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037384033203125
(184) DESCRIBE `ships` 0.0025100708007812
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002892017364502
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002892017364502
(188) DESCRIBE `itineraries` 0.0012979507446289
(189) DESCRIBE `ports` 0.0013418197631836
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032711029052734
(191) DESCRIBE `ports` 0.0013761520385742
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(193) DESCRIBE `ports` 0.0013010501861572
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033307075500488
(195) DESCRIBE `sailingdates` 0.0011241436004639
(196) DESCRIBE `ports` 0.0012738704681396
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031709671020508
(198) DESCRIBE `ports` 0.0014479160308838
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(200) DESCRIBE `ports` 0.0013449192047119
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031590461730957
(202) DESCRIBE `ports` 0.0014519691467285
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00029110908508301
(204) DESCRIBE `ports` 0.0016379356384277
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030112266540527
(206) DESCRIBE `ports` 0.0013589859008789
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028395652770996
(208) DESCRIBE `ports` 0.0012648105621338
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032210350036621
(210) DESCRIBE `ports` 0.0013530254364014
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00028204917907715
(212) DESCRIBE `ports` 0.0012798309326172
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00030899047851562
(214) DESCRIBE `ports` 0.0014150142669678
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029993057250977
(216) DESCRIBE `ports` 0.0012979507446289
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003509521484375
(218) DESCRIBE `ports` 0.0013630390167236
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028491020202637
(220) DESCRIBE `avid_specials` 0.0012660026550293
(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.001107931137085
(222) DESCRIBE `cruiselines` 0.0018720626831055
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031900405883789
(224) DESCRIBE `orchid_image` 0.0015130043029785
(225) DESCRIBE `cruiselines` 0.0017721652984619
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027990341186523
(227) DESCRIBE `cruises` 0.0029110908508301
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00032806396484375
(229) DESCRIBE `ships` 0.0025179386138916
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00044798851013184
(231) DESCRIBE `ships` 0.0034940242767334
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033402442932129
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026988983154297
(235) DESCRIBE `itineraries` 0.0012969970703125
(236) DESCRIBE `ports` 0.0012779235839844
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034904479980469
(238) DESCRIBE `ports` 0.0018010139465332
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032997131347656
(240) DESCRIBE `ports` 0.001309871673584
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(242) DESCRIBE `sailingdates` 0.0012509822845459
(243) DESCRIBE `ports` 0.0016281604766846
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035786628723145
(245) DESCRIBE `ports` 0.0013818740844727
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003058910369873
(247) DESCRIBE `ports` 0.0013110637664795
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00036787986755371
(249) DESCRIBE `ports` 0.0014200210571289
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027799606323242
(251) DESCRIBE `ports` 0.0014240741729736
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030708312988281
(253) DESCRIBE `ports` 0.0014750957489014
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028491020202637
(255) DESCRIBE `ports` 0.0014100074768066
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031590461730957
(257) DESCRIBE `ports` 0.001410961151123
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028705596923828
(259) DESCRIBE `ports` 0.0013020038604736
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032305717468262
(261) DESCRIBE `ports` 0.0013279914855957
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031089782714844
(263) DESCRIBE `avid_specials` 0.0013759136199951
(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.0020749568939209
(265) DESCRIBE `cruiselines` 0.0020289421081543
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035405158996582
(267) DESCRIBE `orchid_image` 0.0015890598297119
(268) DESCRIBE `cruiselines` 0.0018818378448486
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032305717468262
(270) DESCRIBE `cruises` 0.0027861595153809
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00036406517028809
(272) DESCRIBE `ships` 0.0028088092803955
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00043702125549316
(274) DESCRIBE `ships` 0.00288987159729
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033807754516602
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(278) DESCRIBE `itineraries` 0.0013320446014404
(279) DESCRIBE `ports` 0.0016629695892334
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033378601074219
(281) DESCRIBE `ports` 0.001352071762085
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(283) DESCRIBE `ports` 0.0017800331115723
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(285) DESCRIBE `sailingdates` 0.0012087821960449
(286) DESCRIBE `ports` 0.0013988018035889
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003359317779541
(288) DESCRIBE `ports` 0.001370906829834
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031900405883789
(290) DESCRIBE `ports` 0.0017590522766113
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00042009353637695
(292) DESCRIBE `ports` 0.0015630722045898
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00031781196594238
(294) DESCRIBE `ports` 0.0013058185577393
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00034308433532715
(296) DESCRIBE `ports` 0.0014078617095947
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00032401084899902
(298) DESCRIBE `ports` 0.0013408660888672
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00034499168395996
(300) DESCRIBE `ports` 0.0015418529510498
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00030803680419922
(302) DESCRIBE `ports` 0.0014760494232178
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00036001205444336
(304) DESCRIBE `ports` 0.0017340183258057
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00030899047851562
(306) DESCRIBE `ports` 0.0017690658569336
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044512748718262
(308) DESCRIBE `ports` 0.0020418167114258
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003821849822998
(310) DESCRIBE `avid_specials` 0.0015950202941895
(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.0011708736419678
(312) DESCRIBE `cruiselines` 0.0020809173583984
(313) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034189224243164
(314) DESCRIBE `orchid_image` 0.0022158622741699
(315) DESCRIBE `cruiselines` 0.0024399757385254
(316) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00030994415283203
(317) DESCRIBE `cruises` 0.0024149417877197
(318) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00071001052856445
(319) DESCRIBE `ships` 0.0028009414672852
(320) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00014710426330566
(321) DESCRIBE `ships` 0.0044779777526855
(322) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046491622924805
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(325) DESCRIBE `itineraries` 0.0015699863433838
(326) DESCRIBE `ports` 0.001514196395874
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004420280456543
(328) DESCRIBE `ports` 0.0015358924865723
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033998489379883
(330) DESCRIBE `ports` 0.0015809535980225
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035500526428223
(332) DESCRIBE `sailingdates` 0.0013449192047119
(333) DESCRIBE `ports` 0.0015869140625
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034594535827637
(335) DESCRIBE `ports` 0.0022530555725098
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042104721069336
(337) DESCRIBE `ports` 0.0019428730010986
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00042295455932617
(339) DESCRIBE `ports` 0.0024428367614746
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00036096572875977
(341) DESCRIBE `ports` 0.0020251274108887
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003809928894043
(343) DESCRIBE `ports` 0.0018379688262939
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028514862060547
(345) DESCRIBE `avid_specials` 0.0011751651763916
(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.0010838508605957
(347) DESCRIBE `cruiselines` 0.0021400451660156
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034284591674805
(349) DESCRIBE `orchid_image` 0.0016059875488281
(350) DESCRIBE `cruiselines` 0.0020589828491211
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027704238891602
(352) DESCRIBE `cruises` 0.0030808448791504
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.00045585632324219
(354) DESCRIBE `ships` 0.0031359195709229
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00069284439086914
(356) DESCRIBE `ships` 0.002985954284668
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00017404556274414
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(360) DESCRIBE `itineraries` 0.0013830661773682
(361) DESCRIBE `ports` 0.001439094543457
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(363) DESCRIBE `ports` 0.0014958381652832
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021910667419434
(365) DESCRIBE `ports` 0.0013041496276855
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039100646972656
(367) DESCRIBE `sailingdates` 0.0012550354003906
(368) DESCRIBE `ports` 0.0013670921325684
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041484832763672
(370) DESCRIBE `ports` 0.0012879371643066
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028896331787109
(372) DESCRIBE `ports` 0.0013740062713623
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00029492378234863
(374) DESCRIBE `ports` 0.0017080307006836
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00030612945556641
(376) DESCRIBE `ports` 0.001227855682373
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00033187866210938
(378) DESCRIBE `ports` 0.0015580654144287
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00023293495178223
(380) DESCRIBE `ports` 0.0014650821685791
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00022292137145996
(382) DESCRIBE `ports` 0.0013091564178467
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028204917907715
(384) DESCRIBE `ports` 0.0013468265533447
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026798248291016
(386) DESCRIBE `ports` 0.0011630058288574
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00031518936157227
(388) DESCRIBE `ports` 0.001431941986084
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003509521484375
(390) DESCRIBE `ports` 0.0016720294952393
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028896331787109
(392) DESCRIBE `avid_specials` 0.0013210773468018
(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.0011320114135742
(394) DESCRIBE `cruiselines` 0.0022220611572266
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032281875610352
(396) DESCRIBE `orchid_image` 0.0014998912811279
(397) DESCRIBE `cruiselines` 0.0022149085998535
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00023484230041504
(399) DESCRIBE `cruises` 0.0027999877929688
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70948') 0.00029993057250977
(401) DESCRIBE `ships` 0.0027549266815186
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00031805038452148
(403) DESCRIBE `ships` 0.0028910636901855
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003349781036377
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(407) DESCRIBE `itineraries` 0.0013730525970459
(408) DESCRIBE `ports` 0.0013840198516846
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025105476379395
(410) DESCRIBE `ports` 0.0012788772583008
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037121772766113
(412) DESCRIBE `ports` 0.0013260841369629
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(414) DESCRIBE `sailingdates` 0.0015430450439453
(415) DESCRIBE `ports` 0.0016508102416992
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025701522827148
(417) DESCRIBE `ports` 0.0017080307006836
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027108192443848
(419) DESCRIBE `ports` 0.0014190673828125
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00032901763916016
(421) DESCRIBE `ports` 0.0013880729675293
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00022101402282715
(423) DESCRIBE `ports` 0.0014290809631348
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00029110908508301
(425) DESCRIBE `ports` 0.0015878677368164
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.0002748966217041
(427) DESCRIBE `ports` 0.0013859272003174
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00028204917907715
(429) DESCRIBE `ports` 0.0013248920440674
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00028491020202637
(431) DESCRIBE `ports` 0.00136399269104
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00033211708068848
(433) DESCRIBE `ports` 0.0013210773468018
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00028800964355469
(435) DESCRIBE `ports` 0.0014309883117676
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00037789344787598
(437) DESCRIBE `ports` 0.0017480850219727
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00026798248291016
(439) DESCRIBE `ports` 0.0015959739685059
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025200843811035
(441) DESCRIBE `ports` 0.0016970634460449
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025200843811035
(443) DESCRIBE `avid_specials` 0.0014309883117676
(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.0010778903961182
(445) DESCRIBE `cruiselines` 0.0020761489868164
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0002901554107666
(447) DESCRIBE `orchid_image` 0.0015769004821777
(448) DESCRIBE `cruiselines` 0.0019299983978271
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002748966217041
(450) DESCRIBE `ships` 0.0026881694793701
(451) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722')) ORDER BY FIND_IN_SET(id, '4,1722') 0.00060081481933594
(452) DESCRIBE `cruisetypes` 0.0012588500976562
(453) DESCRIBE `destinations` 0.0019400119781494
(454) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00053501129150391
(455) DESCRIBE `cruiselines` 0.0019280910491943
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00040507316589355
(457) DESCRIBE `cruiselines` 0.0026350021362305
(458) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030899047851562