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

Total elapsed time: 0.6444296836853

# Query Time
(1) connect 0.0013689994812012
(2) DESCRIBE `cruises` 0.0041689872741699
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75549, 75550, 75551, 75552, 75484, 75553, 75554, 75555, 75556, 75557)) ORDER BY FIND_IN_SET(id, '75549,75550,75551,75552,75484,75553,75554,75555,75556,75557') 0.0012960433959961
(4) DESCRIBE `cruises` 0.0028619766235352
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75549') 0.00047707557678223
(6) DESCRIBE `ships` 0.0038490295410156
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00053596496582031
(8) DESCRIBE `ships` 0.0036861896514893
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00038504600524902
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032901763916016
(12) DESCRIBE `itineraries` 0.0017790794372559
(13) DESCRIBE `ports` 0.0019321441650391
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0004730224609375
(15) DESCRIBE `ports` 0.0018088817596436
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039792060852051
(17) DESCRIBE `ports` 0.0019288063049316
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037407875061035
(19) DESCRIBE `sailingdates` 0.0015559196472168
(20) DESCRIBE `ports` 0.0020530223846436
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046181678771973
(22) DESCRIBE `ports` 0.0019011497497559
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045299530029297
(24) DESCRIBE `ports` 0.0017750263214111
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00039005279541016
(26) DESCRIBE `ports` 0.0018370151519775
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00039505958557129
(28) DESCRIBE `ports` 0.0017910003662109
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00037789344787598
(30) DESCRIBE `ports` 0.0017750263214111
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00037193298339844
(32) DESCRIBE `ports` 0.0017530918121338
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00043010711669922
(34) DESCRIBE `ports` 0.0017769336700439
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00036120414733887
(36) DESCRIBE `ports` 0.0018157958984375
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 694))) 0.00036406517028809
(38) DESCRIBE `ports` 0.001784086227417
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '694') 0.00034499168395996
(40) DESCRIBE `ports` 0.0017409324645996
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00013279914855957
(42) DESCRIBE `ports` 0.0014488697052002
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00028204917907715
(44) DESCRIBE `ports` 0.001345157623291
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030803680419922
(46) DESCRIBE `ports` 0.0012350082397461
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00031518936157227
(48) DESCRIBE `ports` 0.0013470649719238
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00030803680419922
(50) DESCRIBE `ports` 0.0013468265533447
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00027680397033691
(52) DESCRIBE `ports` 0.0015089511871338
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032496452331543
(54) DESCRIBE `ports` 0.0014588832855225
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031208992004395
(56) DESCRIBE `ports` 0.0012969970703125
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028705596923828
(58) DESCRIBE `ports` 0.0012779235839844
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026798248291016
(60) DESCRIBE `avid_specials` 0.0011301040649414
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75549 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0011630058288574
(62) DESCRIBE `cruiselines` 0.0018761157989502
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00036787986755371
(64) DESCRIBE `orchid_image` 0.0014679431915283
(65) DESCRIBE `cruiselines` 0.0018100738525391
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00027298927307129
(67) DESCRIBE `cruises` 0.0028209686279297
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75550') 0.00035405158996582
(69) DESCRIBE `ships` 0.002575159072876
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00036096572875977
(71) DESCRIBE `ships` 0.002863883972168
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00043487548828125
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029897689819336
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(75) DESCRIBE `itineraries` 0.0012900829315186
(76) DESCRIBE `ports` 0.0013861656188965
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033712387084961
(78) DESCRIBE `ports` 0.0013210773468018
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033307075500488
(80) DESCRIBE `ports` 0.0012569427490234
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028681755065918
(82) DESCRIBE `sailingdates` 0.001223087310791
(83) DESCRIBE `ports` 0.0013859272003174
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035405158996582
(85) DESCRIBE `ports` 0.0017290115356445
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037002563476562
(87) DESCRIBE `ports` 0.0017139911651611
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3268))) 0.00043988227844238
(89) DESCRIBE `ports` 0.002251148223877
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3268') 0.00043010711669922
(91) DESCRIBE `ports` 0.0017859935760498
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00017309188842773
(93) DESCRIBE `ports` 0.0015220642089844
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00032210350036621
(95) DESCRIBE `ports` 0.0012838840484619
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037407875061035
(97) DESCRIBE `ports` 0.0018069744110107
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029206275939941
(99) DESCRIBE `avid_specials` 0.0015239715576172
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75550 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0016920566558838
(101) DESCRIBE `cruiselines` 0.0022721290588379
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00032401084899902
(103) DESCRIBE `orchid_image` 0.00142502784729
(104) DESCRIBE `cruiselines` 0.0017280578613281
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00035405158996582
(106) DESCRIBE `cruises` 0.0035030841827393
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75551') 0.00039291381835938
(108) DESCRIBE `ships` 0.0036370754241943
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00046205520629883
(110) DESCRIBE `ships` 0.0037410259246826
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00031614303588867
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026512145996094
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025510787963867
(114) DESCRIBE `itineraries` 0.0017509460449219
(115) DESCRIBE `ports` 0.0013489723205566
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003659725189209
(117) DESCRIBE `ports` 0.0013880729675293
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028896331787109
(119) DESCRIBE `ports` 0.0013198852539062
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027704238891602
(121) DESCRIBE `sailingdates` 0.0011041164398193
(122) DESCRIBE `ports` 0.0015020370483398
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034594535827637
(124) DESCRIBE `ports` 0.0012500286102295
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027680397033691
(126) DESCRIBE `ports` 0.0012741088867188
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029611587524414
(128) DESCRIBE `ports` 0.0013251304626465
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027108192443848
(130) DESCRIBE `ports` 0.0012600421905518
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1775))) 0.00031089782714844
(132) DESCRIBE `ports` 0.0013208389282227
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1775') 0.00027084350585938
(134) DESCRIBE `ports` 0.0012600421905518
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00029802322387695
(136) DESCRIBE `ports` 0.0012941360473633
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00030708312988281
(138) DESCRIBE `ports` 0.0018470287322998
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00048112869262695
(140) DESCRIBE `ports` 0.0012829303741455
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002739429473877
(142) DESCRIBE `ports` 0.0014710426330566
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00030398368835449
(144) DESCRIBE `ports` 0.0012609958648682
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00030303001403809
(146) DESCRIBE `ports` 0.0016021728515625
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043797492980957
(148) DESCRIBE `ports` 0.0018179416656494
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00030183792114258
(150) DESCRIBE `ports` 0.001500129699707
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00042986869812012
(152) DESCRIBE `ports` 0.0017960071563721
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00049018859863281
(154) DESCRIBE `ports` 0.0017890930175781
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040292739868164
(156) DESCRIBE `ports` 0.0013809204101562
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028800964355469
(158) DESCRIBE `avid_specials` 0.0012619495391846
(159) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75551 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0010440349578857
(160) DESCRIBE `cruiselines` 0.0019659996032715
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00046801567077637
(162) DESCRIBE `orchid_image` 0.001953125
(163) DESCRIBE `cruiselines` 0.0017831325531006
(164) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028586387634277
(165) DESCRIBE `cruises` 0.0023860931396484
(166) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75552') 0.00029897689819336
(167) DESCRIBE `ships` 0.0024929046630859
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00051307678222656
(169) DESCRIBE `ships` 0.0022540092468262
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00034403800964355
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026917457580566
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027704238891602
(173) DESCRIBE `itineraries` 0.0012249946594238
(174) DESCRIBE `ports` 0.0012869834899902
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032901763916016
(176) DESCRIBE `ports` 0.001291036605835
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030303001403809
(178) DESCRIBE `ports` 0.00088906288146973
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0002748966217041
(180) DESCRIBE `sailingdates` 0.0011739730834961
(181) DESCRIBE `ports` 0.0012907981872559
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038290023803711
(183) DESCRIBE `ports` 0.0013608932495117
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00030899047851562
(185) DESCRIBE `ports` 0.0013458728790283
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3179))) 0.00034594535827637
(187) DESCRIBE `ports` 0.0014650821685791
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3179') 0.00032210350036621
(189) DESCRIBE `ports` 0.0014729499816895
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00034999847412109
(191) DESCRIBE `ports` 0.0013010501861572
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00039100646972656
(193) DESCRIBE `ports` 0.0012569427490234
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00033688545227051
(195) DESCRIBE `ports` 0.0013389587402344
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00054788589477539
(197) DESCRIBE `ports` 0.0011920928955078
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 727))) 0.00036478042602539
(199) DESCRIBE `ports` 0.0015897750854492
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '727') 0.00027894973754883
(201) DESCRIBE `ports` 0.0012600421905518
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00032901763916016
(203) DESCRIBE `ports` 0.001305103302002
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00028610229492188
(205) DESCRIBE `ports` 0.0012581348419189
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 720))) 0.00032496452331543
(207) DESCRIBE `ports` 0.0013120174407959
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '720') 0.00034999847412109
(209) DESCRIBE `ports` 0.0014128684997559
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00022506713867188
(211) DESCRIBE `ports` 0.0014419555664062
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0002751350402832
(213) DESCRIBE `ports` 0.0014100074768066
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00030398368835449
(215) DESCRIBE `ports` 0.0012681484222412
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00029897689819336
(217) DESCRIBE `ports` 0.0013427734375
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031495094299316
(219) DESCRIBE `ports` 0.0013251304626465
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00049591064453125
(221) DESCRIBE `avid_specials` 0.0013349056243896
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75552 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0020010471343994
(223) DESCRIBE `cruiselines` 0.0027360916137695
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00045585632324219
(225) DESCRIBE `orchid_image` 0.0020461082458496
(226) DESCRIBE `cruiselines` 0.0025839805603027
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00037693977355957
(228) DESCRIBE `cruises` 0.0034282207489014
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75484') 0.0003819465637207
(230) DESCRIBE `ships` 0.003544807434082
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00046896934509277
(232) DESCRIBE `ships` 0.0035741329193115
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00037217140197754
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034093856811523
(236) DESCRIBE `itineraries` 0.0017669200897217
(237) DESCRIBE `ports` 0.0018191337585449
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042986869812012
(239) DESCRIBE `ports` 0.0018219947814941
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00038504600524902
(241) DESCRIBE `ports` 0.0017478466033936
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040388107299805
(243) DESCRIBE `sailingdates` 0.0015389919281006
(244) DESCRIBE `ports` 0.0018711090087891
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043582916259766
(246) DESCRIBE `ports` 0.0018060207366943
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039100646972656
(248) DESCRIBE `ports` 0.0018270015716553
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3268))) 0.00041604042053223
(250) DESCRIBE `ports` 0.0017540454864502
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3268') 0.00036096572875977
(252) DESCRIBE `ports` 0.001762866973877
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00040411949157715
(254) DESCRIBE `ports` 0.0018398761749268
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00035905838012695
(256) DESCRIBE `ports` 0.0017759799957275
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00040411949157715
(258) DESCRIBE `ports` 0.0018148422241211
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00037097930908203
(260) DESCRIBE `ports` 0.0017731189727783
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00046896934509277
(262) DESCRIBE `ports` 0.001802921295166
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00011992454528809
(264) DESCRIBE `ports` 0.0013549327850342
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 5.1975250244141E-5
(266) DESCRIBE `ports` 0.0015058517456055
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0003349781036377
(268) DESCRIBE `ports` 0.0014798641204834
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00036096572875977
(270) DESCRIBE `ports` 0.0015349388122559
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00054192543029785
(272) DESCRIBE `ports` 0.0013070106506348
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034499168395996
(274) DESCRIBE `ports` 0.0013048648834229
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028610229492188
(276) DESCRIBE `ports` 0.001288890838623
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033903121948242
(278) DESCRIBE `ports` 0.0016860961914062
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00033283233642578
(280) DESCRIBE `avid_specials` 0.0012438297271729
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75484 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0013160705566406
(282) DESCRIBE `cruiselines` 0.0020308494567871
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00033998489379883
(284) DESCRIBE `orchid_image` 0.0015349388122559
(285) DESCRIBE `cruiselines` 0.0017859935760498
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00031900405883789
(287) DESCRIBE `cruises` 0.0025300979614258
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75553') 0.00030899047851562
(289) DESCRIBE `ships` 0.0028059482574463
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00037789344787598
(291) DESCRIBE `ships` 0.0025181770324707
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00029897689819336
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026583671569824
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025510787963867
(295) DESCRIBE `itineraries` 0.0013339519500732
(296) DESCRIBE `ports` 0.0013308525085449
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032210350036621
(298) DESCRIBE `ports` 0.0013501644134521
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030183792114258
(300) DESCRIBE `ports` 0.0012998580932617
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028300285339355
(302) DESCRIBE `sailingdates` 0.0011508464813232
(303) DESCRIBE `ports` 0.0013120174407959
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003211498260498
(305) DESCRIBE `ports` 0.0013160705566406
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028896331787109
(307) DESCRIBE `ports` 0.0013689994812012
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032496452331543
(309) DESCRIBE `ports` 0.001431941986084
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00033998489379883
(311) DESCRIBE `ports` 0.0013611316680908
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.0003960132598877
(313) DESCRIBE `ports` 0.0012731552124023
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00029492378234863
(315) DESCRIBE `ports` 0.0012838840484619
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00030398368835449
(317) DESCRIBE `ports` 0.0013389587402344
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.0002748966217041
(319) DESCRIBE `ports` 0.0013339519500732
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0005180835723877
(321) DESCRIBE `ports` 0.0014479160308838
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00037598609924316
(323) DESCRIBE `ports` 0.0017991065979004
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041103363037109
(325) DESCRIBE `ports` 0.001338005065918
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035810470581055
(327) DESCRIBE `ports` 0.0013008117675781
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00038695335388184
(329) DESCRIBE `ports` 0.001460075378418
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00038504600524902
(331) DESCRIBE `ports` 0.0017108917236328
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.00032806396484375
(333) DESCRIBE `ports` 0.0014190673828125
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.00032901763916016
(335) DESCRIBE `ports` 0.0013539791107178
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00032591819763184
(337) DESCRIBE `ports` 0.0014448165893555
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00029206275939941
(339) DESCRIBE `ports` 0.0013449192047119
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00030803680419922
(341) DESCRIBE `ports` 0.00099611282348633
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00039100646972656
(343) DESCRIBE `ports` 0.0013830661773682
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037193298339844
(345) DESCRIBE `ports` 0.0014259815216064
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00070905685424805
(347) DESCRIBE `avid_specials` 0.0011708736419678
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75553 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0011420249938965
(349) DESCRIBE `cruiselines` 0.0026090145111084
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00037598609924316
(351) DESCRIBE `orchid_image` 0.0014879703521729
(352) DESCRIBE `cruiselines` 0.0018401145935059
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00031113624572754
(354) DESCRIBE `cruises` 0.0028657913208008
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75554') 0.00034689903259277
(356) DESCRIBE `ships` 0.0025720596313477
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0004420280456543
(358) DESCRIBE `ships` 0.0034630298614502
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00037407875061035
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029611587524414
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(362) DESCRIBE `itineraries` 0.0012838840484619
(363) DESCRIBE `ports` 0.0012891292572021
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033783912658691
(365) DESCRIBE `ports` 0.0014040470123291
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049901008605957
(367) DESCRIBE `ports` 0.0015130043029785
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029301643371582
(369) DESCRIBE `sailingdates` 0.0012271404266357
(370) DESCRIBE `ports` 0.0015079975128174
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003659725189209
(372) DESCRIBE `ports` 0.0012810230255127
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030708312988281
(374) DESCRIBE `ports` 0.0013048648834229
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00035595893859863
(376) DESCRIBE `ports` 0.0014901161193848
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00034213066101074
(378) DESCRIBE `ports` 0.0012691020965576
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.0003969669342041
(380) DESCRIBE `ports` 0.0013248920440674
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00033903121948242
(382) DESCRIBE `ports` 0.0014820098876953
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00033688545227051
(384) DESCRIBE `ports` 0.0013251304626465
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00034999847412109
(386) DESCRIBE `ports` 0.0015537738800049
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00043797492980957
(388) DESCRIBE `ports` 0.001323938369751
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028896331787109
(390) DESCRIBE `ports` 0.0014469623565674
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2930))) 0.00036501884460449
(392) DESCRIBE `ports` 0.0013940334320068
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2930') 0.00039005279541016
(394) DESCRIBE `ports` 0.0013978481292725
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 865))) 0.00040388107299805
(396) DESCRIBE `ports` 0.0017950534820557
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '865') 0.00039482116699219
(398) DESCRIBE `ports` 0.0019450187683105
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 691))) 0.00041389465332031
(400) DESCRIBE `ports` 0.0015408992767334
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '691') 0.00036120414733887
(402) DESCRIBE `ports` 0.0013871192932129
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00031208992004395
(404) DESCRIBE `ports` 0.0013868808746338
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00028181076049805
(406) DESCRIBE `ports` 0.001317024230957
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00036096572875977
(408) DESCRIBE `ports` 0.0013020038604736
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00041389465332031
(410) DESCRIBE `ports` 0.0013720989227295
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00038886070251465
(412) DESCRIBE `ports` 0.0013000965118408
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028610229492188
(414) DESCRIBE `avid_specials` 0.0013389587402344
(415) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75554 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0017580986022949
(416) DESCRIBE `cruiselines` 0.0025019645690918
(417) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00039482116699219
(418) DESCRIBE `orchid_image` 0.0016639232635498
(419) DESCRIBE `cruiselines` 0.0022032260894775
(420) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00033402442932129
(421) DESCRIBE `cruises` 0.0037181377410889
(422) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75555') 0.00043416023254395
(423) DESCRIBE `ships` 0.0037829875946045
(424) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00056314468383789
(425) DESCRIBE `ships` 0.0039298534393311
(426) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00045394897460938
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036406517028809
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054097175598145
(429) DESCRIBE `itineraries` 0.001939058303833
(430) DESCRIBE `ports` 0.0020759105682373
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046706199645996
(432) DESCRIBE `ports` 0.0022320747375488
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040602684020996
(434) DESCRIBE `ports` 0.0018429756164551
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023484230041504
(436) DESCRIBE `sailingdates` 0.0016109943389893
(437) DESCRIBE `ports` 0.0019850730895996
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00082302093505859
(439) DESCRIBE `ports` 0.0019049644470215
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00048303604125977
(441) DESCRIBE `ports` 0.0018470287322998
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.00044393539428711
(443) DESCRIBE `ports` 0.0018320083618164
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00039386749267578
(445) DESCRIBE `ports` 0.0019409656524658
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 908))) 0.00031113624572754
(447) DESCRIBE `ports` 0.001270055770874
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '908') 0.00028491020202637
(449) DESCRIBE `ports` 0.001276969909668
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00036287307739258
(451) DESCRIBE `ports` 0.001305103302002
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00041007995605469
(453) DESCRIBE `ports` 0.0012528896331787
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029921531677246
(455) DESCRIBE `ports` 0.0013020038604736
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00014209747314453
(457) DESCRIBE `ports` 0.001244068145752
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00030112266540527
(459) DESCRIBE `ports` 0.0013868808746338
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00027298927307129
(461) DESCRIBE `ports` 0.0012450218200684
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002899169921875
(463) DESCRIBE `ports` 0.001270055770874
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027799606323242
(465) DESCRIBE `ports` 0.0013399124145508
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00030207633972168
(467) DESCRIBE `ports` 0.0018231868743896
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00037312507629395
(469) DESCRIBE `ports` 0.0019261837005615
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046491622924805
(471) DESCRIBE `ports` 0.0013539791107178
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029897689819336
(473) DESCRIBE `avid_specials` 0.0011110305786133
(474) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75555 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0010471343994141
(475) DESCRIBE `cruiselines` 0.0018439292907715
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0003199577331543
(477) DESCRIBE `orchid_image` 0.0014820098876953
(478) DESCRIBE `cruiselines` 0.0020902156829834
(479) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0003960132598877
(480) DESCRIBE `cruises` 0.0024838447570801
(481) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75556') 0.00030899047851562
(482) DESCRIBE `ships` 0.0025689601898193
(483) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00035595893859863
(484) DESCRIBE `ships` 0.0026991367340088
(485) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00029802322387695
(486) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028300285339355
(487) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029110908508301
(488) DESCRIBE `itineraries` 0.0012290477752686
(489) DESCRIBE `ports` 0.0013730525970459
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024700164794922
(491) DESCRIBE `ports` 0.0015819072723389
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034809112548828
(493) DESCRIBE `ports` 0.001323938369751
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003058910369873
(495) DESCRIBE `sailingdates` 0.0011320114135742
(496) DESCRIBE `ports` 0.0012729167938232
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032496452331543
(498) DESCRIBE `ports` 0.0013020038604736
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00012707710266113
(500) DESCRIBE `ports` 0.0013129711151123
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00029492378234863
(502) DESCRIBE `ports` 0.0017330646514893
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00034689903259277
(504) DESCRIBE `ports` 0.0017979145050049
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00032711029052734
(506) DESCRIBE `ports` 0.0014629364013672
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00031495094299316
(508) DESCRIBE `ports` 0.0014040470123291
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00030922889709473
(510) DESCRIBE `ports` 0.0015251636505127
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00031185150146484
(512) DESCRIBE `ports` 0.0013442039489746
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00031208992004395
(514) DESCRIBE `ports` 0.0013020038604736
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00029206275939941
(516) DESCRIBE `ports` 0.0013020038604736
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030303001403809
(518) DESCRIBE `ports` 0.0013120174407959
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002741813659668
(520) DESCRIBE `ports` 0.0012590885162354
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00028896331787109
(522) DESCRIBE `ports` 0.0013689994812012
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.0002739429473877
(524) DESCRIBE `ports` 0.0013158321380615
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00034785270690918
(526) DESCRIBE `ports` 0.0012879371643066
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00026392936706543
(528) DESCRIBE `ports` 0.0013101100921631
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030684471130371
(530) DESCRIBE `ports` 0.0013549327850342
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027179718017578
(532) DESCRIBE `ports` 0.0013060569763184
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031089782714844
(534) DESCRIBE `ports` 0.0012500286102295
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00036406517028809
(536) DESCRIBE `avid_specials` 0.0011551380157471
(537) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75556 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0010280609130859
(538) DESCRIBE `cruiselines` 0.0019598007202148
(539) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0003201961517334
(540) DESCRIBE `orchid_image` 0.0014867782592773
(541) DESCRIBE `cruiselines` 0.001802921295166
(542) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0003809928894043
(543) DESCRIBE `cruises` 0.002514123916626
(544) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75557') 0.00031900405883789
(545) DESCRIBE `ships` 0.0033340454101562
(546) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00052785873413086
(547) DESCRIBE `ships` 0.0026891231536865
(548) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00029516220092773
(549) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(551) DESCRIBE `itineraries` 0.0013489723205566
(552) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75557') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.002640962600708
(553) DESCRIBE `ports` 0.0019338130950928
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044918060302734
(555) DESCRIBE `ports` 0.0016069412231445
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031208992004395
(557) DESCRIBE `ports` 0.0013089179992676
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028610229492188
(559) DESCRIBE `sailingdates` 0.0011239051818848
(560) DESCRIBE `ports` 0.0013270378112793
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033187866210938
(562) DESCRIBE `ports` 0.0012598037719727
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031399726867676
(564) DESCRIBE `ports` 0.0012919902801514
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00033688545227051
(566) DESCRIBE `ports` 0.0013689994812012
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00029492378234863
(568) DESCRIBE `ports` 0.0013318061828613
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00031685829162598
(570) DESCRIBE `ports` 0.0013358592987061
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00029706954956055
(572) DESCRIBE `ports` 0.0013270378112793
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 720))) 0.00037407875061035
(574) DESCRIBE `ports` 0.0012729167938232
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '720') 0.00028800964355469
(576) DESCRIBE `ports` 0.0012619495391846
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.00038695335388184
(578) DESCRIBE `ports` 0.0013289451599121
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.00029706954956055
(580) DESCRIBE `ports` 0.0013580322265625
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00031208992004395
(582) DESCRIBE `ports` 0.0013048648834229
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00032305717468262
(584) DESCRIBE `ports` 0.001507043838501
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00037193298339844
(586) DESCRIBE `ports` 0.0012679100036621
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00028800964355469
(588) DESCRIBE `ports` 0.0012598037719727
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00032591819763184
(590) DESCRIBE `ports` 0.0013091564178467
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00027680397033691
(592) DESCRIBE `ports` 0.0012819766998291
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00030803680419922
(594) DESCRIBE `ports` 0.001349925994873
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00028014183044434
(596) DESCRIBE `ports` 0.0012989044189453
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00030708312988281
(598) DESCRIBE `ports` 0.0012660026550293
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027298927307129
(600) DESCRIBE `ports` 0.0013830661773682
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032496452331543
(602) DESCRIBE `ports` 0.0012550354003906
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027298927307129
(604) DESCRIBE `avid_specials` 0.001147985458374
(605) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75557 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0010261535644531
(606) DESCRIBE `cruiselines` 0.0018110275268555
(607) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00033187866210938
(608) DESCRIBE `orchid_image` 0.0015048980712891
(609) DESCRIBE `cruiselines` 0.0017998218536377
(610) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00031781196594238
(611) DESCRIBE `ships` 0.0028190612792969
(612) SELECT `ships`.* FROM `ships` WHERE (id IN ('616', '1672', '652')) ORDER BY FIND_IN_SET(id, '616,1672,652') 0.00059294700622559
(613) DESCRIBE `cruisetypes` 0.0010561943054199
(614) DESCRIBE `cruiselines` 0.0018889904022217
(615) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00036716461181641
(616) DESCRIBE `destinations` 0.0016679763793945
(617) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00032520294189453
(618) DESCRIBE `destinations` 0.0018000602722168
(619) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00035810470581055
(620) DESCRIBE `cruiselines` 0.0020380020141602
(621) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00040602684020996