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

Total elapsed time: 0.98480558395386

# Query Time
(1) connect 0.00095582008361816
(2) DESCRIBE `cruises` 0.0044560432434082
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72677, 74686, 48384, 72282, 82419, 78009, 72283, 48376, 50599, 74687)) ORDER BY FIND_IN_SET(id, '72677,74686,48384,72282,82419,78009,72283,48376,50599,74687') 0.0024850368499756
(4) DESCRIBE `cruises` 0.0042119026184082
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72677') 0.00056099891662598
(6) DESCRIBE `ships` 0.030463933944702
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1259))) 0.00075316429138184
(8) DESCRIBE `ships` 0.0037801265716553
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1259') 0.00061202049255371
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003669261932373
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034999847412109
(12) DESCRIBE `itineraries` 0.0019669532775879
(13) DESCRIBE `ports` 0.0020349025726318
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00041294097900391
(15) DESCRIBE `ports` 0.0017521381378174
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00043678283691406
(17) DESCRIBE `ports` 0.0018010139465332
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00048494338989258
(19) DESCRIBE `sailingdates` 0.0015699863433838
(20) DESCRIBE `ports` 0.0018908977508545
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045609474182129
(22) DESCRIBE `ports` 0.0017731189727783
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00041604042053223
(24) DESCRIBE `ports` 0.001701831817627
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00041389465332031
(26) DESCRIBE `ports` 0.0017688274383545
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00036811828613281
(28) DESCRIBE `ports` 0.0017509460449219
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00040388107299805
(30) DESCRIBE `ports` 0.00180983543396
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00039291381835938
(32) DESCRIBE `ports` 0.0017030239105225
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0004270076751709
(34) DESCRIBE `ports` 0.0017571449279785
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00038290023803711
(36) DESCRIBE `ports` 0.0020778179168701
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2079))) 0.00049304962158203
(38) DESCRIBE `ports` 0.0019681453704834
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2079') 0.00048112869262695
(40) DESCRIBE `ports` 0.0019769668579102
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00050997734069824
(42) DESCRIBE `ports` 0.0019359588623047
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0004270076751709
(44) DESCRIBE `ports` 0.0017900466918945
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0004429817199707
(46) DESCRIBE `ports` 0.0018219947814941
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00039887428283691
(48) DESCRIBE `ports` 0.0019400119781494
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00060510635375977
(50) DESCRIBE `ports` 0.0018489360809326
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00036716461181641
(52) DESCRIBE `ports` 0.001751184463501
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00043797492980957
(54) DESCRIBE `ports` 0.0018188953399658
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00041413307189941
(56) DESCRIBE `ports` 0.0017831325531006
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00045609474182129
(58) DESCRIBE `ports` 0.0018150806427002
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003969669342041
(60) DESCRIBE `ports` 0.0018370151519775
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00043988227844238
(62) DESCRIBE `ports` 0.0015521049499512
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00037097930908203
(64) DESCRIBE `ports` 0.0018301010131836
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0004119873046875
(66) DESCRIBE `ports` 0.0017929077148438
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00037193298339844
(68) DESCRIBE `ports` 0.0017178058624268
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00038719177246094
(70) DESCRIBE `ports` 0.0020239353179932
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003809928894043
(72) DESCRIBE `ports` 0.0015969276428223
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00041604042053223
(74) DESCRIBE `ports` 0.0017690658569336
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00040698051452637
(76) DESCRIBE `avid_specials` 0.0016930103302002
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72677 and class = 'Cruise') OR (item_id = 1259 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016689300537109
(78) DESCRIBE `cruiselines` 0.0023880004882812
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00041890144348145
(80) DESCRIBE `orchid_image` 0.0018911361694336
(81) DESCRIBE `cruiselines` 0.0024588108062744
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00052309036254883
(83) DESCRIBE `cruises` 0.0036602020263672
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74686') 0.00044798851013184
(85) DESCRIBE `ships` 0.0036289691925049
(86) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1704))) 0.00072598457336426
(87) DESCRIBE `ships` 0.0040647983551025
(88) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1704') 0.00052499771118164
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00042295455932617
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034403800964355
(91) DESCRIBE `itineraries` 0.0019381046295166
(92) DESCRIBE `ports` 0.0018329620361328
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00051498413085938
(94) DESCRIBE `ports` 0.0018990039825439
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048589706420898
(96) DESCRIBE `ports` 0.0017299652099609
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00053000450134277
(98) DESCRIBE `sailingdates` 0.0020010471343994
(99) DESCRIBE `ports` 0.0022041797637939
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00074911117553711
(101) DESCRIBE `ports` 0.0020051002502441
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00052714347839355
(103) DESCRIBE `ports` 0.0020298957824707
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031280517578125
(105) DESCRIBE `ports` 0.0016670227050781
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00038504600524902
(107) DESCRIBE `ports` 0.0014781951904297
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00037789344787598
(109) DESCRIBE `ports` 0.0015349388122559
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00033307075500488
(111) DESCRIBE `ports` 0.0015299320220947
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00035691261291504
(113) DESCRIBE `ports` 0.0014650821685791
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0003209114074707
(115) DESCRIBE `ports` 0.0014162063598633
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00033783912658691
(117) DESCRIBE `ports` 0.0014641284942627
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00043296813964844
(119) DESCRIBE `ports` 0.0013978481292725
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2117))) 0.00033807754516602
(121) DESCRIBE `ports` 0.001507043838501
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2117') 0.00035285949707031
(123) DESCRIBE `ports` 0.0015428066253662
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2336))) 0.00044798851013184
(125) DESCRIBE `ports` 0.0014960765838623
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2336') 0.00040888786315918
(127) DESCRIBE `ports` 0.0015120506286621
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.0003809928894043
(129) DESCRIBE `ports` 0.0016140937805176
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0003199577331543
(131) DESCRIBE `ports` 0.0014040470123291
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00060510635375977
(133) DESCRIBE `ports` 0.0014588832855225
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.0003058910369873
(135) DESCRIBE `ports` 0.0015079975128174
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00035810470581055
(137) DESCRIBE `ports` 0.0014629364013672
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00050210952758789
(139) DESCRIBE `ports` 0.0014169216156006
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00034499168395996
(141) DESCRIBE `ports` 0.0015020370483398
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.00032496452331543
(143) DESCRIBE `ports` 0.0014221668243408
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00038290023803711
(145) DESCRIBE `ports` 0.0014400482177734
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00032901763916016
(147) DESCRIBE `ports` 0.0015008449554443
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003659725189209
(149) DESCRIBE `ports` 0.0014660358428955
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0003359317779541
(151) DESCRIBE `avid_specials` 0.0012609958648682
(152) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74686 and class = 'Cruise') OR (item_id = 1704 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 28 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.0015020370483398
(153) DESCRIBE `cruiselines` 0.0020999908447266
(154) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00039982795715332
(155) DESCRIBE `orchid_image` 0.0016260147094727
(156) DESCRIBE `cruiselines` 0.0020790100097656
(157) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00038385391235352
(158) DESCRIBE `cruises` 0.0030200481414795
(159) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48384') 0.00065398216247559
(160) DESCRIBE `ships` 0.0041980743408203
(161) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00059604644775391
(162) DESCRIBE `ships` 0.0037441253662109
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00045394897460938
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00032901763916016
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00031900405883789
(166) DESCRIBE `itineraries` 0.0017900466918945
(167) DESCRIBE `ports` 0.0018749237060547
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004570484161377
(169) DESCRIBE `ports` 0.0017979145050049
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040388107299805
(171) DESCRIBE `ports` 0.0018241405487061
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003669261932373
(173) DESCRIBE `sailingdates` 0.0014729499816895
(174) DESCRIBE `ports` 0.0018661022186279
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004279613494873
(176) DESCRIBE `ports` 0.0016539096832275
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037384033203125
(178) DESCRIBE `ports` 0.0016729831695557
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003972053527832
(180) DESCRIBE `ports` 0.0017189979553223
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030612945556641
(182) DESCRIBE `ports` 0.002065896987915
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00044989585876465
(184) DESCRIBE `ports` 0.0015230178833008
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00035285949707031
(186) DESCRIBE `ports` 0.0013220310211182
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0003211498260498
(188) DESCRIBE `ports` 0.0014958381652832
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00029397010803223
(190) DESCRIBE `ports` 0.0012969970703125
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003352165222168
(192) DESCRIBE `ports` 0.0012991428375244
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00033712387084961
(194) DESCRIBE `ports` 0.0013618469238281
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003349781036377
(196) DESCRIBE `ports` 0.0012660026550293
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028800964355469
(198) DESCRIBE `ports` 0.0013101100921631
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030612945556641
(200) DESCRIBE `ports` 0.001255989074707
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00034809112548828
(202) DESCRIBE `ports` 0.0012960433959961
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0003211498260498
(204) DESCRIBE `ports` 0.0013079643249512
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00038480758666992
(206) DESCRIBE `ports` 0.0018069744110107
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00046396255493164
(208) DESCRIBE `ports` 0.0016589164733887
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00035381317138672
(210) DESCRIBE `ports` 0.001694917678833
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00038599967956543
(212) DESCRIBE `ports` 0.0017409324645996
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00036406517028809
(214) DESCRIBE `ports` 0.0016429424285889
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043392181396484
(216) DESCRIBE `ports` 0.0016369819641113
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00033998489379883
(218) DESCRIBE `ports` 0.0017368793487549
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037693977355957
(220) DESCRIBE `ports` 0.0018460750579834
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041580200195312
(222) DESCRIBE `avid_specials` 0.0016269683837891
(223) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48384 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 22 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.0012669563293457
(224) DESCRIBE `cruiselines` 0.0020179748535156
(225) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00038409233093262
(226) DESCRIBE `orchid_image` 0.0015220642089844
(227) DESCRIBE `cruiselines` 0.001939058303833
(228) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00034689903259277
(229) DESCRIBE `cruises` 0.0026991367340088
(230) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72282') 0.0005340576171875
(231) DESCRIBE `ships` 0.0039801597595215
(232) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00051403045654297
(233) DESCRIBE `ships` 0.0030460357666016
(234) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00038504600524902
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027012825012207
(236) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025701522827148
(237) DESCRIBE `itineraries` 0.0014150142669678
(238) DESCRIBE `ports` 0.0015959739685059
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00056982040405273
(240) DESCRIBE `ports` 0.0018990039825439
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00055503845214844
(242) DESCRIBE `ports` 0.0015881061553955
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00032806396484375
(244) DESCRIBE `sailingdates` 0.0013370513916016
(245) DESCRIBE `ports` 0.0013492107391357
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00040698051452637
(247) DESCRIBE `ports` 0.0012569427490234
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00030088424682617
(249) DESCRIBE `ports` 0.00148606300354
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0004880428314209
(251) DESCRIBE `ports` 0.0015490055084229
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043201446533203
(253) DESCRIBE `ports` 0.001533031463623
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.00035309791564941
(255) DESCRIBE `ports` 0.0014300346374512
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00035214424133301
(257) DESCRIBE `ports` 0.0015988349914551
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00048303604125977
(259) DESCRIBE `ports` 0.0017130374908447
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00054597854614258
(261) DESCRIBE `ports` 0.0016369819641113
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00047397613525391
(263) DESCRIBE `ports` 0.0014300346374512
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00032496452331543
(265) DESCRIBE `ports` 0.0013711452484131
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00040698051452637
(267) DESCRIBE `ports` 0.0016369819641113
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00032997131347656
(269) DESCRIBE `ports` 0.0016469955444336
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00037097930908203
(271) DESCRIBE `ports` 0.001572847366333
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00036191940307617
(273) DESCRIBE `ports` 0.0016469955444336
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00037503242492676
(275) DESCRIBE `ports` 0.0016078948974609
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00043392181396484
(277) DESCRIBE `ports` 0.0019040107727051
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00045394897460938
(279) DESCRIBE `ports` 0.0020182132720947
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00052595138549805
(281) DESCRIBE `ports` 0.0019679069519043
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00049090385437012
(283) DESCRIBE `ports` 0.0019941329956055
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00041699409484863
(285) DESCRIBE `avid_specials` 0.0017609596252441
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72282 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015439987182617
(287) DESCRIBE `cruiselines` 0.0025031566619873
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00054502487182617
(289) DESCRIBE `orchid_image` 0.0020151138305664
(290) DESCRIBE `cruiselines` 0.0025911331176758
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00052595138549805
(292) DESCRIBE `cruises` 0.0040290355682373
(293) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82419') 0.00047016143798828
(294) DESCRIBE `ships` 0.0039198398590088
(295) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492))) 0.0006110668182373
(296) DESCRIBE `ships` 0.0040550231933594
(297) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1492') 0.00047612190246582
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029802322387695
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00032997131347656
(300) DESCRIBE `itineraries` 0.0014870166778564
(301) DESCRIBE `ports` 0.0016000270843506
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00038981437683105
(303) DESCRIBE `ports` 0.0015590190887451
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00043106079101562
(305) DESCRIBE `ports` 0.0014970302581787
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00035405158996582
(307) DESCRIBE `sailingdates` 0.0013980865478516
(308) DESCRIBE `ports` 0.0014441013336182
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00040102005004883
(310) DESCRIBE `ports` 0.0014419555664062
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00037503242492676
(312) DESCRIBE `ports` 0.0018091201782227
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.0003509521484375
(314) DESCRIBE `ports` 0.0014681816101074
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00039577484130859
(316) DESCRIBE `ports` 0.0017030239105225
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 538))) 0.00047087669372559
(318) DESCRIBE `ports` 0.001554012298584
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '538') 0.00033211708068848
(320) DESCRIBE `ports` 0.0015051364898682
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 538))) 0.00021100044250488
(322) DESCRIBE `ports` 0.0016391277313232
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '538') 0.00039505958557129
(324) DESCRIBE `ports` 0.0015490055084229
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2509))) 0.0004420280456543
(326) DESCRIBE `ports` 0.0018630027770996
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2509') 0.00038886070251465
(328) DESCRIBE `ports` 0.001957893371582
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1280))) 0.0004730224609375
(330) DESCRIBE `ports` 0.0020599365234375
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1280') 0.00047993659973145
(332) DESCRIBE `ports` 0.0017020702362061
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00040388107299805
(334) DESCRIBE `ports` 0.0014259815216064
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00032305717468262
(336) DESCRIBE `ports` 0.0014219284057617
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1289))) 0.00033807754516602
(338) DESCRIBE `ports` 0.0014591217041016
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1289') 0.00029921531677246
(340) DESCRIBE `ports` 0.0012898445129395
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.0005040168762207
(342) DESCRIBE `ports` 0.0018560886383057
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00037097930908203
(344) DESCRIBE `ports` 0.0015671253204346
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00032711029052734
(346) DESCRIBE `ports` 0.0015690326690674
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00034713745117188
(348) DESCRIBE `ports` 0.0014998912811279
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 294))) 0.00044512748718262
(350) DESCRIBE `ports` 0.0014312267303467
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '294') 0.00038003921508789
(352) DESCRIBE `ports` 0.001751184463501
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3802))) 0.00034785270690918
(354) DESCRIBE `ports` 0.0015630722045898
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3802') 0.00029206275939941
(356) DESCRIBE `ports` 0.0016839504241943
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00053596496582031
(358) DESCRIBE `ports` 0.0019321441650391
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00042510032653809
(360) DESCRIBE `ports` 0.0017549991607666
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0004279613494873
(362) DESCRIBE `ports` 0.0016441345214844
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00041699409484863
(364) DESCRIBE `ports` 0.0018229484558105
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00048112869262695
(366) DESCRIBE `ports` 0.0020279884338379
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00042104721069336
(368) DESCRIBE `ports` 0.0017070770263672
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00050997734069824
(370) DESCRIBE `ports` 0.0016279220581055
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00042009353637695
(372) DESCRIBE `ports` 0.0017070770263672
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00046920776367188
(374) DESCRIBE `ports` 0.0017158985137939
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0004889965057373
(376) DESCRIBE `avid_specials` 0.0015389919281006
(377) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82419 and class = 'Cruise') OR (item_id = 1492 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 2 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.0015850067138672
(378) DESCRIBE `cruiselines` 0.0026118755340576
(379) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00062417984008789
(380) DESCRIBE `orchid_image` 0.0022571086883545
(381) DESCRIBE `cruiselines` 0.0025420188903809
(382) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00050616264343262
(383) DESCRIBE `cruises` 0.0031759738922119
(384) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78009') 0.00049281120300293
(385) DESCRIBE `ships` 0.0029439926147461
(386) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00078797340393066
(387) DESCRIBE `ships` 0.0034029483795166
(388) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00048208236694336
(389) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00030088424682617
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00028705596923828
(391) DESCRIBE `itineraries` 0.0015890598297119
(392) DESCRIBE `ports` 0.0018360614776611
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00040793418884277
(394) DESCRIBE `ports` 0.0015089511871338
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00036287307739258
(396) DESCRIBE `ports` 0.0015230178833008
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00035285949707031
(398) DESCRIBE `sailingdates` 0.0013718605041504
(399) DESCRIBE `ports` 0.0018270015716553
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00042104721069336
(401) DESCRIBE `ports` 0.00152587890625
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00054788589477539
(403) DESCRIBE `ports` 0.0020339488983154
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00049591064453125
(405) DESCRIBE `ports` 0.0019431114196777
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00043082237243652
(407) DESCRIBE `ports` 0.0018770694732666
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00051403045654297
(409) DESCRIBE `ports` 0.0019309520721436
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00052809715270996
(411) DESCRIBE `ports` 0.0019431114196777
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00053310394287109
(413) DESCRIBE `ports` 0.0018911361694336
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0004270076751709
(415) DESCRIBE `ports` 0.0014159679412842
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00036096572875977
(417) DESCRIBE `ports` 0.001492977142334
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003209114074707
(419) DESCRIBE `ports` 0.0014278888702393
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00034308433532715
(421) DESCRIBE `ports` 0.0014650821685791
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00036716461181641
(423) DESCRIBE `ports` 0.0017051696777344
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00046801567077637
(425) DESCRIBE `ports` 0.0017011165618896
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.0003809928894043
(427) DESCRIBE `ports` 0.0016319751739502
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.0004279613494873
(429) DESCRIBE `ports` 0.0020570755004883
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00047898292541504
(431) DESCRIBE `ports` 0.0021560192108154
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00051593780517578
(433) DESCRIBE `ports` 0.0019638538360596
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00046896934509277
(435) DESCRIBE `ports` 0.0020618438720703
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00052094459533691
(437) DESCRIBE `ports` 0.0019600391387939
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00047206878662109
(439) DESCRIBE `ports` 0.002032995223999
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00054597854614258
(441) DESCRIBE `ports` 0.0020310878753662
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00044584274291992
(443) DESCRIBE `ports` 0.0019629001617432
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00047993659973145
(445) DESCRIBE `ports` 0.0028860569000244
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00049090385437012
(447) DESCRIBE `ports` 0.0017831325531006
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2079))) 0.00041604042053223
(449) DESCRIBE `ports` 0.001643180847168
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2079') 0.0003509521484375
(451) DESCRIBE `ports` 0.0023329257965088
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.00054383277893066
(453) DESCRIBE `ports` 0.0016961097717285
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00038504600524902
(455) DESCRIBE `ports` 0.0016548633575439
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00050616264343262
(457) DESCRIBE `ports` 0.0017819404602051
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00036382675170898
(459) DESCRIBE `ports` 0.0019071102142334
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00047516822814941
(461) DESCRIBE `ports` 0.0019779205322266
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00040483474731445
(463) DESCRIBE `ports` 0.0021469593048096
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00046992301940918
(465) DESCRIBE `ports` 0.0019199848175049
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00040698051452637
(467) DESCRIBE `ports` 0.0018589496612549
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00043511390686035
(469) DESCRIBE `ports` 0.0021381378173828
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0006110668182373
(471) DESCRIBE `ports` 0.002068042755127
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00052213668823242
(473) DESCRIBE `ports` 0.0021100044250488
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00045514106750488
(475) DESCRIBE `ports` 0.0020039081573486
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00048995018005371
(477) DESCRIBE `ports` 0.0019938945770264
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00043201446533203
(479) DESCRIBE `ports` 0.0019440650939941
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00046586990356445
(481) DESCRIBE `ports` 0.0019330978393555
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0004420280456543
(483) DESCRIBE `avid_specials` 0.001755952835083
(484) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78009 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018348693847656
(485) DESCRIBE `cruiselines` 0.0031249523162842
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00045084953308105
(487) DESCRIBE `orchid_image` 0.0021789073944092
(488) DESCRIBE `cruiselines` 0.002720832824707
(489) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00048708915710449
(490) DESCRIBE `cruises` 0.0040287971496582
(491) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72283') 0.00055789947509766
(492) DESCRIBE `ships` 0.0046060085296631
(493) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00078392028808594
(494) DESCRIBE `ships` 0.0043931007385254
(495) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00067901611328125
(496) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036382675170898
(497) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034999847412109
(498) DESCRIBE `itineraries` 0.0020959377288818
(499) DESCRIBE `ports` 0.0021038055419922
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00051307678222656
(501) DESCRIBE `ports` 0.0019969940185547
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00049901008605957
(503) DESCRIBE `ports` 0.0016429424285889
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00052905082702637
(505) DESCRIBE `sailingdates` 0.0016369819641113
(506) DESCRIBE `ports` 0.0018110275268555
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00054311752319336
(508) DESCRIBE `ports` 0.0019299983978271
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00041103363037109
(510) DESCRIBE `ports` 0.0019071102142334
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00045990943908691
(512) DESCRIBE `ports` 0.0019631385803223
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00041913986206055
(514) DESCRIBE `ports` 0.0019280910491943
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00046110153198242
(516) DESCRIBE `ports` 0.0019950866699219
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0004429817199707
(518) DESCRIBE `ports` 0.0018930435180664
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00044798851013184
(520) DESCRIBE `ports` 0.0022430419921875
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00041103363037109
(522) DESCRIBE `ports` 0.0019228458404541
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00046300888061523
(524) DESCRIBE `ports` 0.0020899772644043
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00043988227844238
(526) DESCRIBE `ports` 0.0018601417541504
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0003969669342041
(528) DESCRIBE `ports` 0.001924991607666
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00043916702270508
(530) DESCRIBE `ports` 0.0017220973968506
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00061202049255371
(532) DESCRIBE `ports` 0.001917839050293
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00043892860412598
(534) DESCRIBE `ports` 0.0018811225891113
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.00044798851013184
(536) DESCRIBE `ports` 0.0020320415496826
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00049209594726562
(538) DESCRIBE `ports` 0.0018360614776611
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00047707557678223
(540) DESCRIBE `ports` 0.0019299983978271
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00046491622924805
(542) DESCRIBE `ports` 0.0020101070404053
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048995018005371
(544) DESCRIBE `ports` 0.0019769668579102
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00046300888061523
(546) DESCRIBE `avid_specials` 0.0017647743225098
(547) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72283 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017321109771729
(548) DESCRIBE `cruiselines` 0.0028789043426514
(549) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00063896179199219
(550) DESCRIBE `orchid_image` 0.0021910667419434
(551) DESCRIBE `cruiselines` 0.0028889179229736
(552) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00047898292541504
(553) DESCRIBE `cruises` 0.0039870738983154
(554) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48376') 0.0005338191986084
(555) DESCRIBE `ships` 0.0039989948272705
(556) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00062298774719238
(557) DESCRIBE `ships` 0.0039050579071045
(558) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00051999092102051
(559) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034403800964355
(560) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00032997131347656
(561) DESCRIBE `itineraries` 0.0018329620361328
(562) DESCRIBE `ports` 0.0017678737640381
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045108795166016
(564) DESCRIBE `ports` 0.0014088153839111
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036382675170898
(566) DESCRIBE `ports` 0.0015690326690674
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029516220092773
(568) DESCRIBE `sailingdates` 0.001317024230957
(569) DESCRIBE `ports` 0.0015039443969727
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040602684020996
(571) DESCRIBE `ports` 0.001600980758667
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00036191940307617
(573) DESCRIBE `ports` 0.0015580654144287
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00039982795715332
(575) DESCRIBE `ports` 0.0015828609466553
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00032997131347656
(577) DESCRIBE `ports` 0.0014650821685791
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00033116340637207
(579) DESCRIBE `ports` 0.0015721321105957
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00030899047851562
(581) DESCRIBE `ports` 0.001478910446167
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00036001205444336
(583) DESCRIBE `ports` 0.0016469955444336
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0003669261932373
(585) DESCRIBE `ports` 0.0019931793212891
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00048708915710449
(587) DESCRIBE `ports` 0.0020318031311035
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00036001205444336
(589) DESCRIBE `ports` 0.0016560554504395
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00034189224243164
(591) DESCRIBE `ports` 0.0017879009246826
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00041484832763672
(593) DESCRIBE `ports` 0.0018901824951172
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00049400329589844
(595) DESCRIBE `ports` 0.0018410682678223
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0003969669342041
(597) DESCRIBE `ports` 0.0018119812011719
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00042104721069336
(599) DESCRIBE `ports` 0.0017828941345215
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00037693977355957
(601) DESCRIBE `ports` 0.0017349720001221
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040197372436523
(603) DESCRIBE `ports` 0.0018088817596436
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039982795715332
(605) DESCRIBE `ports` 0.0018730163574219
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00058102607727051
(607) DESCRIBE `ports` 0.0020642280578613
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042915344238281
(609) DESCRIBE `avid_specials` 0.0015501976013184
(610) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48376 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 22 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.0016660690307617
(611) DESCRIBE `cruiselines` 0.0023748874664307
(612) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.0003969669342041
(613) DESCRIBE `orchid_image` 0.0017280578613281
(614) DESCRIBE `cruiselines` 0.0023791790008545
(615) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00047492980957031
(616) DESCRIBE `cruises` 0.0049221515655518
(617) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50599') 0.00061488151550293
(618) DESCRIBE `ships` 0.0040781497955322
(619) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1259))) 0.00069999694824219
(620) DESCRIBE `ships` 0.0036871433258057
(621) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1259') 0.00057601928710938
(622) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003659725189209
(623) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00031685829162598
(624) DESCRIBE `itineraries` 0.0017020702362061
(625) DESCRIBE `ports` 0.0020759105682373
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00042200088500977
(627) DESCRIBE `ports` 0.0016357898712158
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00039410591125488
(629) DESCRIBE `ports` 0.0014660358428955
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00040602684020996
(631) DESCRIBE `sailingdates` 0.0015869140625
(632) DESCRIBE `ports` 0.0021140575408936
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00049304962158203
(634) DESCRIBE `ports` 0.0015630722045898
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00031113624572754
(636) DESCRIBE `ports` 0.0015919208526611
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00035905838012695
(638) DESCRIBE `ports` 0.0014300346374512
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00034499168395996
(640) DESCRIBE `ports` 0.0015971660614014
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00050592422485352
(642) DESCRIBE `ports` 0.0019681453704834
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00049805641174316
(644) DESCRIBE `ports` 0.0022139549255371
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00051593780517578
(646) DESCRIBE `ports` 0.0019230842590332
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00044393539428711
(648) DESCRIBE `ports` 0.001957893371582
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00052785873413086
(650) DESCRIBE `ports` 0.0019171237945557
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00042605400085449
(652) DESCRIBE `ports` 0.0018479824066162
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00058507919311523
(654) DESCRIBE `ports` 0.0020978450775146
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00043988227844238
(656) DESCRIBE `ports` 0.0016140937805176
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00044083595275879
(658) DESCRIBE `ports` 0.0017721652984619
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00043582916259766
(660) DESCRIBE `ports` 0.0019018650054932
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00049304962158203
(662) DESCRIBE `ports` 0.0020411014556885
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00071287155151367
(664) DESCRIBE `ports` 0.0017070770263672
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00050687789916992
(666) DESCRIBE `ports` 0.0018908977508545
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043797492980957
(668) DESCRIBE `ports` 0.0016372203826904
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2079))) 0.00044894218444824
(670) DESCRIBE `ports` 0.0019259452819824
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2079') 0.00043988227844238
(672) DESCRIBE `ports` 0.0019528865814209
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0005040168762207
(674) DESCRIBE `ports` 0.0020551681518555
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0004420280456543
(676) DESCRIBE `ports` 0.00211501121521
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00047802925109863
(678) DESCRIBE `ports` 0.001945972442627
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00057005882263184
(680) DESCRIBE `ports` 0.0021710395812988
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045609474182129
(682) DESCRIBE `ports` 0.0018560886383057
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00042986869812012
(684) DESCRIBE `ports` 0.0018870830535889
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045394897460938
(686) DESCRIBE `ports` 0.00180983543396
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00058484077453613
(688) DESCRIBE `avid_specials` 0.001331090927124
(689) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50599 and class = 'Cruise') OR (item_id = 1259 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010709762573242
(690) DESCRIBE `cruiselines` 0.001910924911499
(691) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.0003669261932373
(692) DESCRIBE `orchid_image` 0.0016129016876221
(693) DESCRIBE `cruiselines` 0.0019059181213379
(694) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00038599967956543
(695) DESCRIBE `cruises` 0.0040838718414307
(696) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74687') 0.00050997734069824
(697) DESCRIBE `ships` 0.0041561126708984
(698) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1704))) 0.0006721019744873
(699) DESCRIBE `ships` 0.0042908191680908
(700) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1704') 0.00066995620727539
(701) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0002601146697998
(702) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035595893859863
(703) DESCRIBE `itineraries` 0.0019638538360596
(704) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74687') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0015850067138672
(705) DESCRIBE `ports` 0.00177001953125
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00039100646972656
(707) DESCRIBE `ports` 0.0014240741729736
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00035405158996582
(709) DESCRIBE `ports` 0.012442827224731
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00039505958557129
(711) DESCRIBE `sailingdates` 0.012145042419434
(712) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74687') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010077953338623
(713) DESCRIBE `ports` 0.00164794921875
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00042080879211426
(715) DESCRIBE `ports` 0.0074269771575928
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00040316581726074
(717) DESCRIBE `ports` 0.0013298988342285
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00033783912658691
(719) DESCRIBE `ports` 0.0013110637664795
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00030016899108887
(721) DESCRIBE `ports` 0.001227855682373
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.00029993057250977
(723) DESCRIBE `ports` 0.0012810230255127
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00026416778564453
(725) DESCRIBE `ports` 0.0013577938079834
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00038313865661621
(727) DESCRIBE `ports` 0.0013489723205566
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00028610229492188
(729) DESCRIBE `ports` 0.0012671947479248
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00029110908508301
(731) DESCRIBE `ports` 0.0013720989227295
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00043106079101562
(733) DESCRIBE `ports` 0.0014281272888184
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031399726867676
(735) DESCRIBE `ports` 0.0014410018920898
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00034999847412109
(737) DESCRIBE `ports` 0.0019309520721436
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00029897689819336
(739) DESCRIBE `ports` 0.0017979145050049
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00030803680419922
(741) DESCRIBE `ports` 0.0014140605926514
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031685829162598
(743) DESCRIBE `ports` 0.0012388229370117
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0002748966217041
(745) DESCRIBE `ports` 0.0012319087982178
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00029993057250977
(747) DESCRIBE `ports` 0.0012350082397461
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00026917457580566
(749) DESCRIBE `ports` 0.0012588500976562
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00028300285339355
(751) DESCRIBE `ports` 0.0012619495391846
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00044488906860352
(753) DESCRIBE `avid_specials` 0.001594066619873
(754) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74687 and class = 'Cruise') OR (item_id = 1704 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015239715576172
(755) DESCRIBE `cruiselines` 0.0022859573364258
(756) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00033116340637207
(757) DESCRIBE `orchid_image` 0.0014679431915283
(758) DESCRIBE `cruiselines` 0.0018420219421387
(759) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00030112266540527
(760) DESCRIBE `ships` 0.003554105758667
(761) SELECT `ships`.* FROM `ships` WHERE (id IN ('1259', '1260', '1208', '1492', '1704', '1474')) ORDER BY FIND_IN_SET(id, '1259,1260,1208,1492,1704,1474') 0.00097393989562988
(762) DESCRIBE `cruisetypes` 0.0015170574188232
(763) DESCRIBE `destinations` 0.0022909641265869
(764) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '25', '2', '12', '35', '21', '49', '40', '37', '38', '28', '43', '8', '11', '48')) ORDER BY FIND_IN_SET(id, '22,26,25,2,12,35,21,49,40,37,38,28,43,8,11,48') 0.0017690658569336
(765) DESCRIBE `cruiselines` 0.0030059814453125
(766) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00055408477783203
(767) DESCRIBE `cruiselines` 0.0028040409088135
(768) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00049901008605957