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

Total elapsed time: 0.86808300018311

# Query Time
(1) connect 0.0011529922485352
(2) DESCRIBE `cruises` 0.0043408870697021
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (78175, 80913, 73732, 75088, 74560, 76903, 69516, 64701, 78176, 64657)) ORDER BY FIND_IN_SET(id, '78175,80913,73732,75088,74560,76903,69516,64701,78176,64657') 0.0027999877929688
(4) DESCRIBE `cruises` 0.0040340423583984
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78175') 0.00056195259094238
(6) DESCRIBE `ships` 0.0041720867156982
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00070500373840332
(8) DESCRIBE `ships` 0.0040369033813477
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00064396858215332
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031113624572754
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029206275939941
(12) DESCRIBE `itineraries` 0.0015840530395508
(13) DESCRIBE `ports` 0.0020589828491211
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0005180835723877
(15) DESCRIBE `ports` 0.0017797946929932
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00046396255493164
(17) DESCRIBE `ports` 0.0018250942230225
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00037407875061035
(19) DESCRIBE `sailingdates` 0.001701831817627
(20) DESCRIBE `ports` 0.0016219615936279
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0002899169921875
(22) DESCRIBE `ports` 0.001323938369751
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0003669261932373
(24) DESCRIBE `ports` 0.0017099380493164
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) 0.00040197372436523
(26) DESCRIBE `ports` 0.0016689300537109
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') 0.00035500526428223
(28) DESCRIBE `ports` 0.0015788078308105
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.0003669261932373
(30) DESCRIBE `ports` 0.0015349388122559
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00039386749267578
(32) DESCRIBE `ports` 0.0016911029815674
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) 0.00040507316589355
(34) DESCRIBE `ports` 0.0017640590667725
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') 0.00035691261291504
(36) DESCRIBE `ports` 0.0014181137084961
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00034999847412109
(38) DESCRIBE `ports` 0.0013198852539062
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00032615661621094
(40) DESCRIBE `ports` 0.0017378330230713
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00037288665771484
(42) DESCRIBE `ports` 0.0017271041870117
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00034904479980469
(44) DESCRIBE `ports` 0.001331090927124
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.0003361701965332
(46) DESCRIBE `ports` 0.0020089149475098
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00038790702819824
(48) DESCRIBE `ports` 0.0018520355224609
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) 0.00037789344787598
(50) DESCRIBE `ports` 0.0014920234680176
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') 0.00029802322387695
(52) DESCRIBE `ports` 0.001561164855957
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00038504600524902
(54) DESCRIBE `ports` 0.0015208721160889
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.0003819465637207
(56) DESCRIBE `ports` 0.0015640258789062
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00039815902709961
(58) DESCRIBE `ports` 0.0017828941345215
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00038790702819824
(60) DESCRIBE `ports` 0.0018360614776611
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 189))) 0.00046205520629883
(62) DESCRIBE `ports` 0.0018501281738281
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '189') 0.00038981437683105
(64) DESCRIBE `ports` 0.0018010139465332
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00045204162597656
(66) DESCRIBE `ports` 0.0018808841705322
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00044107437133789
(68) DESCRIBE `ports` 0.0020840167999268
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2354))) 0.00066018104553223
(70) DESCRIBE `ports` 0.0019690990447998
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2354') 0.00046801567077637
(72) DESCRIBE `ports` 0.0019679069519043
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00047898292541504
(74) DESCRIBE `ports` 0.0018560886383057
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.0003349781036377
(76) DESCRIBE `ports` 0.0015130043029785
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1289))) 0.00057196617126465
(78) DESCRIBE `ports` 0.0019819736480713
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1289') 0.00040912628173828
(80) DESCRIBE `ports` 0.001863956451416
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00043201446533203
(82) DESCRIBE `ports` 0.0019240379333496
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00041508674621582
(84) DESCRIBE `ports` 0.0019521713256836
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1904))) 0.00048184394836426
(86) DESCRIBE `ports` 0.0018918514251709
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1904') 0.00042819976806641
(88) DESCRIBE `ports` 0.0018858909606934
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00052094459533691
(90) DESCRIBE `ports` 0.0018370151519775
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00043511390686035
(92) DESCRIBE `avid_specials` 0.0017669200897217
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78175 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 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.0020520687103271
(94) DESCRIBE `cruiselines` 0.0027740001678467
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00049495697021484
(96) DESCRIBE `orchid_image` 0.0020921230316162
(97) DESCRIBE `cruiselines` 0.0025620460510254
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00044703483581543
(99) DESCRIBE `cruises` 0.0037329196929932
(100) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80913') 0.00044703483581543
(101) DESCRIBE `ships` 0.0039830207824707
(102) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00061988830566406
(103) DESCRIBE `ships` 0.0041210651397705
(104) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.00061392784118652
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035285949707031
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00033402442932129
(107) DESCRIBE `itineraries` 0.0019190311431885
(108) DESCRIBE `ports` 0.0019900798797607
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00046086311340332
(110) DESCRIBE `ports` 0.0017659664154053
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00040507316589355
(112) DESCRIBE `ports` 0.0017659664154053
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00042414665222168
(114) DESCRIBE `sailingdates` 0.0016121864318848
(115) DESCRIBE `ports` 0.0020811557769775
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00047087669372559
(117) DESCRIBE `ports` 0.0018110275268555
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00039315223693848
(119) DESCRIBE `ports` 0.0018670558929443
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00041699409484863
(121) DESCRIBE `ports` 0.0018680095672607
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00038886070251465
(123) DESCRIBE `ports` 0.0018000602722168
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00044989585876465
(125) DESCRIBE `ports` 0.0018160343170166
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00045108795166016
(127) DESCRIBE `ports` 0.0018110275268555
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00042510032653809
(129) DESCRIBE `ports` 0.0018181800842285
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00041413307189941
(131) DESCRIBE `ports` 0.0018668174743652
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00043106079101562
(133) DESCRIBE `ports` 0.0019030570983887
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00042891502380371
(135) DESCRIBE `ports` 0.0018367767333984
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.0004580020904541
(137) DESCRIBE `ports` 0.0017900466918945
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00040984153747559
(139) DESCRIBE `ports` 0.0018110275268555
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 600))) 0.00044798851013184
(141) DESCRIBE `ports` 0.0017919540405273
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '600') 0.00037598609924316
(143) DESCRIBE `ports` 0.0019888877868652
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00040793418884277
(145) DESCRIBE `ports` 0.0018510818481445
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00045895576477051
(147) DESCRIBE `ports` 0.0019600391387939
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00045895576477051
(149) DESCRIBE `ports` 0.0018398761749268
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00040411949157715
(151) DESCRIBE `ports` 0.0018570423126221
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00049304962158203
(153) DESCRIBE `ports` 0.0017638206481934
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00037789344787598
(155) DESCRIBE `ports` 0.0018069744110107
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2987))) 0.00044703483581543
(157) DESCRIBE `ports` 0.0018308162689209
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2987') 0.00034785270690918
(159) DESCRIBE `ports` 0.0014941692352295
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00036501884460449
(161) DESCRIBE `ports` 0.0017759799957275
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00038313865661621
(163) DESCRIBE `ports` 0.0016031265258789
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1063))) 0.00042986869812012
(165) DESCRIBE `ports` 0.0014657974243164
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1063') 0.00038909912109375
(167) DESCRIBE `ports` 0.0016629695892334
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2119))) 0.00036406517028809
(169) DESCRIBE `ports` 0.0016820430755615
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2119') 0.00029897689819336
(171) DESCRIBE `ports` 0.0014901161193848
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2077))) 0.00036787986755371
(173) DESCRIBE `ports` 0.0014021396636963
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2077') 0.0003669261932373
(175) DESCRIBE `ports` 0.0013301372528076
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00070714950561523
(177) DESCRIBE `ports` 0.0017631053924561
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00044393539428711
(179) DESCRIBE `avid_specials` 0.0012869834899902
(180) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80913 and class = 'Cruise') OR (item_id = 1282 AND class = 'Ship') OR (item_id = 33 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.0017609596252441
(181) DESCRIBE `cruiselines` 0.0030269622802734
(182) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0005040168762207
(183) DESCRIBE `orchid_image` 0.0023388862609863
(184) DESCRIBE `cruiselines` 0.0028800964355469
(185) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00041604042053223
(186) DESCRIBE `cruises` 0.0027551651000977
(187) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73732') 0.00040292739868164
(188) DESCRIBE `ships` 0.0033280849456787
(189) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00057601928710938
(190) DESCRIBE `ships` 0.0030930042266846
(191) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.00039505958557129
(192) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034403800964355
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026106834411621
(194) DESCRIBE `itineraries` 0.001884937286377
(195) DESCRIBE `ports` 0.0020549297332764
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00036311149597168
(197) DESCRIBE `ports` 0.0014760494232178
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00034093856811523
(199) DESCRIBE `ports` 0.0021908283233643
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00044393539428711
(201) DESCRIBE `sailingdates` 0.0016880035400391
(202) DESCRIBE `ports` 0.0018980503082275
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00037002563476562
(204) DESCRIBE `ports` 0.0014932155609131
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00030088424682617
(206) DESCRIBE `ports` 0.001413106918335
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00034499168395996
(208) DESCRIBE `ports` 0.0022521018981934
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00049018859863281
(210) DESCRIBE `ports` 0.00217604637146
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00053000450134277
(212) DESCRIBE `ports` 0.0017719268798828
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00031018257141113
(214) DESCRIBE `ports` 0.0013089179992676
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00031590461730957
(216) DESCRIBE `ports` 0.0013561248779297
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00030398368835449
(218) DESCRIBE `ports` 0.001500129699707
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00034999847412109
(220) DESCRIBE `ports` 0.0013551712036133
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00030612945556641
(222) DESCRIBE `ports` 0.0012750625610352
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.00033402442932129
(224) DESCRIBE `ports` 0.0019638538360596
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00045108795166016
(226) DESCRIBE `ports` 0.0019130706787109
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 600))) 0.00046014785766602
(228) DESCRIBE `ports` 0.0019400119781494
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '600') 0.00035190582275391
(230) DESCRIBE `ports` 0.0018429756164551
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00046706199645996
(232) DESCRIBE `ports` 0.0017800331115723
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00037813186645508
(234) DESCRIBE `ports` 0.0016951560974121
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00043797492980957
(236) DESCRIBE `ports` 0.0017020702362061
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00037908554077148
(238) DESCRIBE `avid_specials` 0.0012021064758301
(239) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73732 and class = 'Cruise') OR (item_id = 1282 AND class = 'Ship') OR (item_id = 33 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.0010321140289307
(240) DESCRIBE `cruiselines` 0.0020120143890381
(241) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00034189224243164
(242) DESCRIBE `orchid_image` 0.0017130374908447
(243) DESCRIBE `cruiselines` 0.0022079944610596
(244) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00036191940307617
(245) DESCRIBE `cruises` 0.0029990673065186
(246) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75088') 0.00044703483581543
(247) DESCRIBE `ships` 0.0034530162811279
(248) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00049996376037598
(249) DESCRIBE `ships` 0.0033011436462402
(250) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00038909912109375
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032281875610352
(252) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(253) DESCRIBE `itineraries` 0.0018689632415771
(254) DESCRIBE `ports` 0.0017919540405273
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00046706199645996
(256) DESCRIBE `ports` 0.0016400814056396
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00040411949157715
(258) DESCRIBE `ports` 0.0013749599456787
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00037503242492676
(260) DESCRIBE `sailingdates` 0.0011920928955078
(261) DESCRIBE `ports` 0.0014688968658447
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00036120414733887
(263) DESCRIBE `ports` 0.0012938976287842
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00037193298339844
(265) DESCRIBE `ports` 0.0015079975128174
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) 0.00036382675170898
(267) DESCRIBE `ports` 0.0013179779052734
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') 0.00030779838562012
(269) DESCRIBE `ports` 0.0014209747314453
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00042009353637695
(271) DESCRIBE `ports` 0.0015771389007568
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00033998489379883
(273) DESCRIBE `ports` 0.0013740062713623
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) 0.00040316581726074
(275) DESCRIBE `ports` 0.0013589859008789
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') 0.00040197372436523
(277) DESCRIBE `ports` 0.0018079280853271
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00044393539428711
(279) DESCRIBE `ports` 0.0015649795532227
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.0003049373626709
(281) DESCRIBE `ports` 0.0014159679412842
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00031399726867676
(283) DESCRIBE `ports` 0.0013589859008789
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00035810470581055
(285) DESCRIBE `ports` 0.0014491081237793
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00040102005004883
(287) DESCRIBE `ports` 0.0016548633575439
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00036907196044922
(289) DESCRIBE `ports` 0.0013968944549561
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) 0.00040388107299805
(291) DESCRIBE `ports` 0.001906156539917
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') 0.00053000450134277
(293) DESCRIBE `ports` 0.0018870830535889
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00045990943908691
(295) DESCRIBE `ports` 0.0016369819641113
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00033402442932129
(297) DESCRIBE `ports` 0.0015909671783447
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00044012069702148
(299) DESCRIBE `ports` 0.0015759468078613
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00031495094299316
(301) DESCRIBE `avid_specials` 0.0014610290527344
(302) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75088 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 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.0010888576507568
(303) DESCRIBE `cruiselines` 0.0025439262390137
(304) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00056099891662598
(305) DESCRIBE `orchid_image` 0.0020709037780762
(306) DESCRIBE `cruiselines` 0.0024521350860596
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00041580200195312
(308) DESCRIBE `cruises` 0.0037000179290771
(309) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74560') 0.00044608116149902
(310) DESCRIBE `ships` 0.0034570693969727
(311) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00064182281494141
(312) DESCRIBE `ships` 0.0036211013793945
(313) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.00051689147949219
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035190582275391
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033688545227051
(316) DESCRIBE `itineraries` 0.0020899772644043
(317) DESCRIBE `ports` 0.0023159980773926
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0004889965057373
(319) DESCRIBE `ports` 0.0018310546875
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00050210952758789
(321) DESCRIBE `ports` 0.0021018981933594
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00053191184997559
(323) DESCRIBE `sailingdates` 0.0018751621246338
(324) DESCRIBE `ports` 0.001967191696167
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00048208236694336
(326) DESCRIBE `ports` 0.0019810199737549
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045204162597656
(328) DESCRIBE `ports` 0.0019989013671875
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 922))) 0.0004580020904541
(330) DESCRIBE `ports` 0.0017540454864502
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '922') 0.00038290023803711
(332) DESCRIBE `ports` 0.0017120838165283
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00038003921508789
(334) DESCRIBE `ports` 0.0014309883117676
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00033712387084961
(336) DESCRIBE `ports` 0.0015490055084229
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00042891502380371
(338) DESCRIBE `ports` 0.0022320747375488
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00055408477783203
(340) DESCRIBE `ports` 0.0021181106567383
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.00059795379638672
(342) DESCRIBE `ports` 0.002133846282959
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.00051712989807129
(344) DESCRIBE `ports` 0.0022759437561035
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00046086311340332
(346) DESCRIBE `ports` 0.0019190311431885
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00039196014404297
(348) DESCRIBE `ports` 0.0017459392547607
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040507316589355
(350) DESCRIBE `ports` 0.0017828941345215
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042104721069336
(352) DESCRIBE `avid_specials` 0.0012340545654297
(353) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74560 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.0015740394592285
(354) DESCRIBE `cruiselines` 0.0026030540466309
(355) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00044488906860352
(356) DESCRIBE `orchid_image` 0.0022938251495361
(357) DESCRIBE `cruiselines` 0.0027639865875244
(358) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00045895576477051
(359) DESCRIBE `cruises` 0.0038478374481201
(360) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76903') 0.00051689147949219
(361) DESCRIBE `ships` 0.0039939880371094
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00058197975158691
(363) DESCRIBE `ships` 0.0041260719299316
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00050806999206543
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034499168395996
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003349781036377
(367) DESCRIBE `itineraries` 0.0019168853759766
(368) DESCRIBE `ports` 0.001896858215332
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048923492431641
(370) DESCRIBE `ports` 0.001798152923584
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041794776916504
(372) DESCRIBE `ports` 0.0018541812896729
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040102005004883
(374) DESCRIBE `sailingdates` 0.0015931129455566
(375) DESCRIBE `ports` 0.0018789768218994
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048589706420898
(377) DESCRIBE `ports` 0.0018420219421387
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004270076751709
(379) DESCRIBE `ports` 0.0018081665039062
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.00047111511230469
(381) DESCRIBE `ports` 0.0018889904022217
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00045394897460938
(383) DESCRIBE `ports` 0.0019121170043945
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) 0.00042510032653809
(385) DESCRIBE `ports` 0.0019540786743164
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') 0.00073003768920898
(387) DESCRIBE `ports` 0.0019290447235107
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00045919418334961
(389) DESCRIBE `ports` 0.0019559860229492
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00038290023803711
(391) DESCRIBE `ports` 0.00177001953125
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0004119873046875
(393) DESCRIBE `ports` 0.0017588138580322
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00037813186645508
(395) DESCRIBE `ports` 0.0017421245574951
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00040817260742188
(397) DESCRIBE `ports` 0.0017669200897217
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00038695335388184
(399) DESCRIBE `ports` 0.0017819404602051
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00041079521179199
(401) DESCRIBE `ports` 0.0017681121826172
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00037217140197754
(403) DESCRIBE `ports` 0.0017869472503662
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00044798851013184
(405) DESCRIBE `ports` 0.0017879009246826
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003809928894043
(407) DESCRIBE `ports` 0.0017468929290771
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00041007995605469
(409) DESCRIBE `ports` 0.0018370151519775
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00039887428283691
(411) DESCRIBE `ports` 0.001802921295166
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00043296813964844
(413) DESCRIBE `ports` 0.00187087059021
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00039792060852051
(415) DESCRIBE `ports` 0.0018088817596436
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041794776916504
(417) DESCRIBE `ports` 0.0017528533935547
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00038290023803711
(419) DESCRIBE `ports` 0.0018818378448486
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00051307678222656
(421) DESCRIBE `ports` 0.0017921924591064
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00038313865661621
(423) DESCRIBE `ports` 0.0017960071563721
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0004122257232666
(425) DESCRIBE `ports` 0.0017240047454834
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0003669261932373
(427) DESCRIBE `ports` 0.00177001953125
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2394))) 0.00047397613525391
(429) DESCRIBE `ports` 0.0017120838165283
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2394') 0.00039100646972656
(431) DESCRIBE `ports` 0.0017869472503662
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045299530029297
(433) DESCRIBE `ports` 0.0018680095672607
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003819465637207
(435) DESCRIBE `avid_specials` 0.001615047454834
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76903 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0016419887542725
(437) DESCRIBE `cruiselines` 0.0025908946990967
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00048398971557617
(439) DESCRIBE `orchid_image` 0.002007007598877
(440) DESCRIBE `cruiselines` 0.0027608871459961
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00044488906860352
(442) DESCRIBE `cruises` 0.0037641525268555
(443) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69516') 0.00045299530029297
(444) DESCRIBE `ships` 0.003931999206543
(445) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00055694580078125
(446) DESCRIBE `ships` 0.0038399696350098
(447) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00052094459533691
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036478042602539
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033807754516602
(450) DESCRIBE `itineraries` 0.0017781257629395
(451) DESCRIBE `ports` 0.0018119812011719
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004270076751709
(453) DESCRIBE `ports` 0.0017521381378174
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004119873046875
(455) DESCRIBE `ports` 0.0017440319061279
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037002563476562
(457) DESCRIBE `sailingdates` 0.0016019344329834
(458) DESCRIBE `ports` 0.0018348693847656
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043582916259766
(460) DESCRIBE `ports` 0.001802921295166
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036883354187012
(462) DESCRIBE `ports` 0.0017340183258057
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.00040507316589355
(464) DESCRIBE `ports` 0.0017569065093994
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00036907196044922
(466) DESCRIBE `ports` 0.0017549991607666
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) 0.00039196014404297
(468) DESCRIBE `ports` 0.0018289089202881
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') 0.00037312507629395
(470) DESCRIBE `ports` 0.0019619464874268
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00042390823364258
(472) DESCRIBE `ports` 0.0017750263214111
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00040411949157715
(474) DESCRIBE `ports` 0.0017619132995605
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00050592422485352
(476) DESCRIBE `ports` 0.0017931461334229
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00039100646972656
(478) DESCRIBE `ports` 0.0018148422241211
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.0004119873046875
(480) DESCRIBE `ports` 0.0018439292907715
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00038599967956543
(482) DESCRIBE `ports` 0.001802921295166
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00042295455932617
(484) DESCRIBE `ports` 0.0017921924591064
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00038719177246094
(486) DESCRIBE `ports` 0.0017349720001221
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045609474182129
(488) DESCRIBE `ports` 0.0017809867858887
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037503242492676
(490) DESCRIBE `avid_specials` 0.0016160011291504
(491) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69516 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0017480850219727
(492) DESCRIBE `cruiselines` 0.0024809837341309
(493) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00053691864013672
(494) DESCRIBE `orchid_image` 0.0021588802337646
(495) DESCRIBE `cruiselines` 0.0026280879974365
(496) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00053811073303223
(497) DESCRIBE `cruises` 0.0038349628448486
(498) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64701') 0.0004889965057373
(499) DESCRIBE `ships` 0.0039570331573486
(500) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00054597854614258
(501) DESCRIBE `ships` 0.00382399559021
(502) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00036716461181641
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028300285339355
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026321411132812
(505) DESCRIBE `itineraries` 0.0014898777008057
(506) DESCRIBE `ports` 0.0015900135040283
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00042605400085449
(508) DESCRIBE `ports` 0.001384973526001
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00035190582275391
(510) DESCRIBE `ports` 0.0015609264373779
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00031495094299316
(512) DESCRIBE `sailingdates` 0.0012359619140625
(513) DESCRIBE `ports` 0.0014569759368896
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00036406517028809
(515) DESCRIBE `ports` 0.0013918876647949
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00036811828613281
(517) DESCRIBE `ports` 0.0016098022460938
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) 0.00033688545227051
(519) DESCRIBE `ports` 0.0016460418701172
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') 0.00031208992004395
(521) DESCRIBE `ports` 0.0014288425445557
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1789))) 0.00045514106750488
(523) DESCRIBE `ports` 0.0013282299041748
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1789') 0.00028586387634277
(525) DESCRIBE `ports` 0.0013229846954346
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00037503242492676
(527) DESCRIBE `ports` 0.0013160705566406
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00027990341186523
(529) DESCRIBE `ports` 0.0013659000396729
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00036907196044922
(531) DESCRIBE `ports` 0.0018060207366943
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00056695938110352
(533) DESCRIBE `ports` 0.0017499923706055
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00047397613525391
(535) DESCRIBE `ports` 0.0013809204101562
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00030303001403809
(537) DESCRIBE `ports` 0.0017299652099609
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00044608116149902
(539) DESCRIBE `ports` 0.0018830299377441
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00040698051452637
(541) DESCRIBE `ports` 0.0018088817596436
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00041389465332031
(543) DESCRIBE `ports` 0.0016980171203613
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00043177604675293
(545) DESCRIBE `ports` 0.0017869472503662
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00069785118103027
(547) DESCRIBE `ports` 0.0017461776733398
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00040197372436523
(549) DESCRIBE `ports` 0.0015790462493896
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00042891502380371
(551) DESCRIBE `ports` 0.0018410682678223
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00039315223693848
(553) DESCRIBE `ports` 0.0017549991607666
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00046396255493164
(555) DESCRIBE `ports` 0.0016310214996338
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00034785270690918
(557) DESCRIBE `ports` 0.0013160705566406
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00032281875610352
(559) DESCRIBE `ports` 0.0013411045074463
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0002748966217041
(561) DESCRIBE `avid_specials` 0.00124192237854
(562) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64701 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 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.0014090538024902
(563) DESCRIBE `cruiselines` 0.0021119117736816
(564) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00045108795166016
(565) DESCRIBE `orchid_image` 0.0015199184417725
(566) DESCRIBE `cruiselines` 0.0019891262054443
(567) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.0003199577331543
(568) DESCRIBE `cruises` 0.0028541088104248
(569) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78176') 0.00034308433532715
(570) DESCRIBE `ships` 0.0027961730957031
(571) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00046992301940918
(572) DESCRIBE `ships` 0.0027968883514404
(573) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.0003509521484375
(574) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027179718017578
(575) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(576) DESCRIBE `itineraries` 0.001417875289917
(577) DESCRIBE `ports` 0.0015130043029785
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00039982795715332
(579) DESCRIBE `ports` 0.0012810230255127
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030279159545898
(581) DESCRIBE `ports` 0.001471996307373
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00050902366638184
(583) DESCRIBE `sailingdates` 0.0013308525085449
(584) DESCRIBE `ports` 0.0016689300537109
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040411949157715
(586) DESCRIBE `ports` 0.0013189315795898
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0002901554107666
(588) DESCRIBE `ports` 0.0013489723205566
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.0003359317779541
(590) DESCRIBE `ports` 0.0015408992767334
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00043487548828125
(592) DESCRIBE `ports` 0.0018949508666992
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00045895576477051
(594) DESCRIBE `ports` 0.001723051071167
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0003211498260498
(596) DESCRIBE `ports` 0.0015180110931396
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00032186508178711
(598) DESCRIBE `ports` 0.0016109943389893
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00029110908508301
(600) DESCRIBE `ports` 0.0013730525970459
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00033998489379883
(602) DESCRIBE `ports` 0.0012950897216797
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00028204917907715
(604) DESCRIBE `ports` 0.001305103302002
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045418739318848
(606) DESCRIBE `ports` 0.0020239353179932
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00033903121948242
(608) DESCRIBE `ports` 0.0013439655303955
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00032806396484375
(610) DESCRIBE `ports` 0.0016469955444336
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00037813186645508
(612) DESCRIBE `ports` 0.0012431144714355
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00036406517028809
(614) DESCRIBE `ports` 0.001474142074585
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00035500526428223
(616) DESCRIBE `ports` 0.0014581680297852
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00054502487182617
(618) DESCRIBE `ports` 0.0016539096832275
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00037693977355957
(620) DESCRIBE `ports` 0.0016000270843506
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2931))) 0.00032305717468262
(622) DESCRIBE `ports` 0.001392126083374
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2931') 0.00038409233093262
(624) DESCRIBE `ports` 0.0013821125030518
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 693))) 0.00039196014404297
(626) DESCRIBE `ports` 0.0014560222625732
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '693') 0.00035810470581055
(628) DESCRIBE `ports` 0.0015320777893066
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 374))) 0.00032210350036621
(630) DESCRIBE `ports` 0.0016729831695557
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '374') 0.00036907196044922
(632) DESCRIBE `ports` 0.0016579627990723
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2502))) 0.00031709671020508
(634) DESCRIBE `ports` 0.0015227794647217
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2502') 0.00033712387084961
(636) DESCRIBE `ports` 0.0018000602722168
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00049304962158203
(638) DESCRIBE `ports` 0.0018448829650879
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00040507316589355
(640) DESCRIBE `ports` 0.0018539428710938
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00043511390686035
(642) DESCRIBE `ports` 0.0018649101257324
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00041294097900391
(644) DESCRIBE `ports` 0.0018658638000488
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0004429817199707
(646) DESCRIBE `ports` 0.0015380382537842
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0003669261932373
(648) DESCRIBE `ports` 0.0016410350799561
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 922))) 0.00046706199645996
(650) DESCRIBE `ports` 0.0017991065979004
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '922') 0.00030994415283203
(652) DESCRIBE `ports` 0.0015418529510498
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003819465637207
(654) DESCRIBE `ports` 0.0015120506286621
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003201961517334
(656) DESCRIBE `avid_specials` 0.0011818408966064
(657) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78176 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.0012459754943848
(658) DESCRIBE `cruiselines` 0.0022580623626709
(659) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00052499771118164
(660) DESCRIBE `orchid_image` 0.0019869804382324
(661) DESCRIBE `cruiselines` 0.0019400119781494
(662) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00033187866210938
(663) DESCRIBE `cruises` 0.0031659603118896
(664) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64657') 0.00035595893859863
(665) DESCRIBE `ships` 0.0031929016113281
(666) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00039291381835938
(667) DESCRIBE `ships` 0.0028390884399414
(668) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00033783912658691
(669) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026679039001465
(670) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036716461181641
(671) DESCRIBE `itineraries` 0.0013899803161621
(672) DESCRIBE `ports` 0.0020201206207275
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00059604644775391
(674) DESCRIBE `ports` 0.0020101070404053
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00048398971557617
(676) DESCRIBE `ports` 0.0018210411071777
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042414665222168
(678) DESCRIBE `sailingdates` 0.0018479824066162
(679) DESCRIBE `ports` 0.001957893371582
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040006637573242
(681) DESCRIBE `ports` 0.0015659332275391
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037598609924316
(683) DESCRIBE `ports` 0.0013811588287354
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.00041413307189941
(685) DESCRIBE `ports` 0.0014920234680176
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00034594535827637
(687) DESCRIBE `ports` 0.0014240741729736
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00037598609924316
(689) DESCRIBE `ports` 0.0013418197631836
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00033903121948242
(691) DESCRIBE `ports` 0.0014188289642334
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00033807754516602
(693) DESCRIBE `ports` 0.0014169216156006
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00028204917907715
(695) DESCRIBE `ports` 0.0014359951019287
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00039196014404297
(697) DESCRIBE `ports` 0.0015358924865723
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00030398368835449
(699) DESCRIBE `ports` 0.001816987991333
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045609474182129
(701) DESCRIBE `ports` 0.0016210079193115
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00031900405883789
(703) DESCRIBE `ports` 0.0015568733215332
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00042319297790527
(705) DESCRIBE `ports` 0.0020270347595215
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00038504600524902
(707) DESCRIBE `ports` 0.0018789768218994
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004279613494873
(709) DESCRIBE `ports` 0.0016307830810547
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0004279613494873
(711) DESCRIBE `avid_specials` 0.0015480518341064
(712) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64657 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.0013818740844727
(713) DESCRIBE `cruiselines` 0.0021610260009766
(714) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00041484832763672
(715) DESCRIBE `orchid_image` 0.0016641616821289
(716) DESCRIBE `cruiselines` 0.0029799938201904
(717) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.0005500316619873
(718) DESCRIBE `ships` 0.0043790340423584
(719) SELECT `ships`.* FROM `ships` WHERE (id IN ('162', '160', '163', '1266', '1159', '1282')) ORDER BY FIND_IN_SET(id, '162,160,163,1266,1159,1282') 0.001511812210083
(720) DESCRIBE `cruisetypes` 0.0018861293792725
(721) DESCRIBE `destinations` 0.0020990371704102
(722) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '12', '48', '49', '2', '28', '26', '38', '35', '21', '11', '25', '53', '8', '34', '40')) ORDER BY FIND_IN_SET(id, '22,43,12,48,49,2,28,26,38,35,21,11,25,53,8,34,40') 0.0015439987182617
(723) DESCRIBE `cruiselines` 0.0022921562194824
(724) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00043606758117676
(725) DESCRIBE `cruiselines` 0.0030138492584229
(726) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00051498413085938