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

Total elapsed time: 0.7215096950531

# Query Time
(1) connect 0.00093388557434082
(2) DESCRIBE `cruises` 0.0033459663391113
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71398, 71399, 71399, 71400, 71400, 71401, 71401, 71402, 71403, 71403)) ORDER BY FIND_IN_SET(id, '71398,71399,71399,71400,71400,71401,71401,71402,71403,71403') 0.0018250942230225
(4) DESCRIBE `cruises` 0.0029280185699463
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71398') 0.0003359317779541
(6) DESCRIBE `ships` 0.0024619102478027
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00034689903259277
(8) DESCRIBE `ships` 0.0024838447570801
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00037407875061035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00026583671569824
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025105476379395
(12) DESCRIBE `itineraries` 0.0012660026550293
(13) DESCRIBE `ports` 0.0012960433959961
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031089782714844
(15) DESCRIBE `ports` 0.0016140937805176
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00032997131347656
(17) DESCRIBE `ports` 0.0013871192932129
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00030994415283203
(19) DESCRIBE `sailingdates` 0.0011119842529297
(20) DESCRIBE `ports` 0.0013430118560791
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00033998489379883
(22) DESCRIBE `ports` 0.0012459754943848
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00027585029602051
(24) DESCRIBE `ports` 0.0012660026550293
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00030207633972168
(26) DESCRIBE `ports` 0.0013270378112793
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00034213066101074
(28) DESCRIBE `ports` 0.0015120506286621
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00036406517028809
(30) DESCRIBE `ports` 0.0016541481018066
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00032520294189453
(32) DESCRIBE `ports` 0.0014910697937012
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00034594535827637
(34) DESCRIBE `ports` 0.0013339519500732
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00028800964355469
(36) DESCRIBE `ports` 0.0012421607971191
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00031495094299316
(38) DESCRIBE `ports` 0.0012719631195068
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00032186508178711
(40) DESCRIBE `ports` 0.0013129711151123
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00030899047851562
(42) DESCRIBE `ports` 0.001244068145752
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00027084350585938
(44) DESCRIBE `ports` 0.0014050006866455
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00035881996154785
(46) DESCRIBE `ports` 0.0012879371643066
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00028300285339355
(48) DESCRIBE `ports` 0.0013771057128906
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030112266540527
(50) DESCRIBE `ports` 0.0012660026550293
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00030398368835449
(52) DESCRIBE `ports` 0.0012879371643066
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00029802322387695
(54) DESCRIBE `ports` 0.0012400150299072
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027012825012207
(56) DESCRIBE `ports` 0.0012650489807129
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00029397010803223
(58) DESCRIBE `ports` 0.0015318393707275
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00036001205444336
(60) DESCRIBE `ports` 0.001572847366333
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0003809928894043
(62) DESCRIBE `ports` 0.001655101776123
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003659725189209
(64) DESCRIBE `ports` 0.0017409324645996
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00043106079101562
(66) DESCRIBE `ports` 0.0017681121826172
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029110908508301
(68) DESCRIBE `avid_specials` 0.0011298656463623
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71398 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010371208190918
(70) DESCRIBE `cruiselines` 0.0018179416656494
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00032401084899902
(72) DESCRIBE `orchid_image` 0.0014519691467285
(73) DESCRIBE `cruiselines` 0.0017549991607666
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00028800964355469
(75) DESCRIBE `specials` 0.0042929649353027
(76) DESCRIBE `specials` 0.0034201145172119
(77) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541086') 0.00039410591125488
(78) DESCRIBE `ships` 0.0025019645690918
(79) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00043296813964844
(80) DESCRIBE `ships` 0.0025210380554199
(81) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00026988983154297
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00026082992553711
(83) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00024914741516113
(84) DESCRIBE `itineraries` 0.0012748241424561
(85) DESCRIBE `ports` 0.0013968944549561
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0003819465637207
(87) DESCRIBE `ports` 0.0013408660888672
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00030207633972168
(89) DESCRIBE `ports` 0.0013158321380615
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00031805038452148
(91) DESCRIBE `specialsailingdates` 0.0010750293731689
(92) DESCRIBE `sailingdates` 0.0016748905181885
(93) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453273))) 0.00041913986206055
(94) DESCRIBE `ports` 0.0017158985137939
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00033998489379883
(96) DESCRIBE `ports` 0.0015158653259277
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037813186645508
(98) DESCRIBE `ports` 0.0017309188842773
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00039100646972656
(100) DESCRIBE `ports` 0.0016930103302002
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00039386749267578
(102) DESCRIBE `ports` 0.0018260478973389
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003960132598877
(104) DESCRIBE `ports` 0.0017430782318115
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035500526428223
(106) DESCRIBE `ports` 0.0016598701477051
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003969669342041
(108) DESCRIBE `ports` 0.0017008781433105
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00036311149597168
(110) DESCRIBE `ports` 0.0017220973968506
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00042986869812012
(112) DESCRIBE `ports` 0.0018670558929443
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00041079521179199
(114) DESCRIBE `ports` 0.0017352104187012
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00040817260742188
(116) DESCRIBE `ports` 0.0016589164733887
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00036501884460449
(118) DESCRIBE `ports` 0.0017590522766113
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048089027404785
(120) DESCRIBE `ports` 0.0018260478973389
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00040197372436523
(122) DESCRIBE `cruises` 0.0040171146392822
(123) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71399))) 0.00062918663024902
(124) DESCRIBE `avid_specials` 0.0018579959869385
(125) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541086 and class = 'Special') OR (item_id = 71399 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017740726470947
(126) DESCRIBE `cruiselines` 0.002669095993042
(127) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00046992301940918
(128) DESCRIBE `orchid_image` 0.0020170211791992
(129) DESCRIBE `cruiselines` 0.0025320053100586
(130) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00040197372436523
(131) DESCRIBE `cruises` 0.0027790069580078
(132) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71399') 0.00036120414733887
(133) DESCRIBE `ships` 0.0025119781494141
(134) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00034093856811523
(135) DESCRIBE `ships` 0.0024819374084473
(136) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00031518936157227
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027012825012207
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025796890258789
(139) DESCRIBE `itineraries` 0.0013048648834229
(140) DESCRIBE `ports` 0.001446008682251
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00041699409484863
(142) DESCRIBE `ports` 0.001255989074707
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00032591819763184
(144) DESCRIBE `ports` 0.00136399269104
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029087066650391
(146) DESCRIBE `sailingdates` 0.0011301040649414
(147) DESCRIBE `ports` 0.0013449192047119
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00036883354187012
(149) DESCRIBE `ports` 0.0012941360473633
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003049373626709
(151) DESCRIBE `ports` 0.0013561248779297
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00033783912658691
(153) DESCRIBE `ports` 0.0013580322265625
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00030803680419922
(155) DESCRIBE `ports` 0.0014710426330566
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003349781036377
(157) DESCRIBE `ports` 0.0012860298156738
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028109550476074
(159) DESCRIBE `ports` 0.0013339519500732
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031614303588867
(161) DESCRIBE `ports` 0.0012459754943848
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0002748966217041
(163) DESCRIBE `ports` 0.0012941360473633
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00031495094299316
(165) DESCRIBE `ports` 0.0012838840484619
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00030303001403809
(167) DESCRIBE `ports` 0.0013968944549561
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0003509521484375
(169) DESCRIBE `ports` 0.0012650489807129
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0002899169921875
(171) DESCRIBE `ports` 0.0012638568878174
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00037598609924316
(173) DESCRIBE `ports` 0.0013930797576904
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00030088424682617
(175) DESCRIBE `avid_specials` 0.001121997833252
(176) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71399 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001072883605957
(177) DESCRIBE `cruiselines` 0.0019199848175049
(178) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00038290023803711
(179) DESCRIBE `orchid_image` 0.0020210742950439
(180) DESCRIBE `cruiselines` 0.0029060840606689
(181) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00040698051452637
(182) DESCRIBE `specials` 0.0047938823699951
(183) DESCRIBE `specials` 0.0049290657043457
(184) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541088') 0.0005638599395752
(185) DESCRIBE `ships` 0.0027940273284912
(186) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00040507316589355
(187) DESCRIBE `ships` 0.0031509399414062
(188) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00052118301391602
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035285949707031
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036478042602539
(191) DESCRIBE `itineraries` 0.0018410682678223
(192) DESCRIBE `ports` 0.0018188953399658
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0004730224609375
(194) DESCRIBE `ports` 0.0017120838165283
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00043702125549316
(196) DESCRIBE `ports` 0.0017769336700439
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00037217140197754
(198) DESCRIBE `specialsailingdates` 0.0013620853424072
(199) DESCRIBE `sailingdates` 0.0015881061553955
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453274))) 0.00038886070251465
(201) DESCRIBE `ports` 0.0017390251159668
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00045609474182129
(203) DESCRIBE `ports` 0.0015649795532227
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00037693977355957
(205) DESCRIBE `ports` 0.0016999244689941
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00041890144348145
(207) DESCRIBE `ports` 0.0017130374908447
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00035285949707031
(209) DESCRIBE `ports` 0.0016829967498779
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00042414665222168
(211) DESCRIBE `ports` 0.0015969276428223
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00044417381286621
(213) DESCRIBE `ports` 0.0018460750579834
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00042414665222168
(215) DESCRIBE `ports` 0.0019090175628662
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00035595893859863
(217) DESCRIBE `ports` 0.0017738342285156
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00045108795166016
(219) DESCRIBE `ports` 0.0017740726470947
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00044107437133789
(221) DESCRIBE `ports` 0.001784086227417
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00060892105102539
(223) DESCRIBE `ports` 0.0014631748199463
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00031399726867676
(225) DESCRIBE `ports` 0.0013129711151123
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032615661621094
(227) DESCRIBE `ports` 0.0013141632080078
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029706954956055
(229) DESCRIBE `ports` 0.001276969909668
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032186508178711
(231) DESCRIBE `ports` 0.0013329982757568
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00031805038452148
(233) DESCRIBE `ports` 0.0013868808746338
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00030803680419922
(235) DESCRIBE `ports` 0.0013418197631836
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.0002751350402832
(237) DESCRIBE `ports` 0.0013201236724854
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00033998489379883
(239) DESCRIBE `ports` 0.0015628337860107
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029301643371582
(241) DESCRIBE `cruises` 0.0025360584259033
(242) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71400))) 0.0004119873046875
(243) DESCRIBE `avid_specials` 0.0013968944549561
(244) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541088 and class = 'Special') OR (item_id = 71400 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015699863433838
(245) DESCRIBE `cruiselines` 0.0025970935821533
(246) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00048494338989258
(247) DESCRIBE `orchid_image` 0.0020098686218262
(248) DESCRIBE `cruiselines` 0.0025591850280762
(249) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00048017501831055
(250) DESCRIBE `cruises` 0.0028879642486572
(251) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71400') 0.00040006637573242
(252) DESCRIBE `ships` 0.0029881000518799
(253) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0004420280456543
(254) DESCRIBE `ships` 0.0034468173980713
(255) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00049686431884766
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036287307739258
(257) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034093856811523
(258) DESCRIBE `itineraries` 0.0019650459289551
(259) DESCRIBE `ports` 0.0015430450439453
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00057792663574219
(261) DESCRIBE `ports` 0.0014610290527344
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003349781036377
(263) DESCRIBE `ports` 0.0013689994812012
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00030708312988281
(265) DESCRIBE `sailingdates` 0.0011789798736572
(266) DESCRIBE `ports` 0.0014879703521729
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00038814544677734
(268) DESCRIBE `ports` 0.0018260478973389
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00044417381286621
(270) DESCRIBE `ports` 0.0017809867858887
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00043892860412598
(272) DESCRIBE `ports` 0.0017259120941162
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00040292739868164
(274) DESCRIBE `ports` 0.0016891956329346
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00048518180847168
(276) DESCRIBE `ports` 0.0015790462493896
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00035500526428223
(278) DESCRIBE `ports` 0.0014040470123291
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00035905838012695
(280) DESCRIBE `ports` 0.0019230842590332
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00049304962158203
(282) DESCRIBE `ports` 0.0020461082458496
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00050497055053711
(284) DESCRIBE `ports` 0.0018489360809326
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00043892860412598
(286) DESCRIBE `ports` 0.0018711090087891
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0004279613494873
(288) DESCRIBE `ports` 0.0019340515136719
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00038385391235352
(290) DESCRIBE `ports` 0.0018308162689209
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00042986869812012
(292) DESCRIBE `ports` 0.0019569396972656
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00040292739868164
(294) DESCRIBE `ports` 0.0018918514251709
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0004270076751709
(296) DESCRIBE `ports` 0.0018351078033447
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00038480758666992
(298) DESCRIBE `ports` 0.0018599033355713
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00043892860412598
(300) DESCRIBE `ports` 0.0018310546875
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00037407875061035
(302) DESCRIBE `ports` 0.0018861293792725
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0004119873046875
(304) DESCRIBE `ports` 0.0018548965454102
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00038003921508789
(306) DESCRIBE `avid_specials` 0.0016970634460449
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71400 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019268989562988
(308) DESCRIBE `cruiselines` 0.0028560161590576
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00052285194396973
(310) DESCRIBE `orchid_image` 0.0020899772644043
(311) DESCRIBE `cruiselines` 0.0025949478149414
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.0004279613494873
(313) DESCRIBE `specials` 0.0052859783172607
(314) DESCRIBE `specials` 0.0054070949554443
(315) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541089') 0.00047111511230469
(316) DESCRIBE `ships` 0.0038609504699707
(317) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00052785873413086
(318) DESCRIBE `ships` 0.0037839412689209
(319) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00040984153747559
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003509521484375
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034689903259277
(322) DESCRIBE `itineraries` 0.0018250942230225
(323) DESCRIBE `ports` 0.0018742084503174
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0004279613494873
(325) DESCRIBE `ports` 0.0018179416656494
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00045990943908691
(327) DESCRIBE `ports` 0.0018119812011719
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00038886070251465
(329) DESCRIBE `specialsailingdates` 0.0015649795532227
(330) DESCRIBE `sailingdates` 0.001392126083374
(331) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453275))) 0.00041890144348145
(332) DESCRIBE `ports` 0.0014889240264893
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00036716461181641
(334) DESCRIBE `ports` 0.0014870166778564
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037813186645508
(336) DESCRIBE `ports` 0.0018060207366943
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00041508674621582
(338) DESCRIBE `ports` 0.001701831817627
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00034713745117188
(340) DESCRIBE `ports` 0.0016520023345947
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00038409233093262
(342) DESCRIBE `ports` 0.0016598701477051
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035810470581055
(344) DESCRIBE `ports` 0.0016829967498779
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00036883354187012
(346) DESCRIBE `ports` 0.0016469955444336
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00034523010253906
(348) DESCRIBE `ports` 0.001655101776123
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00048112869262695
(350) DESCRIBE `ports` 0.0016689300537109
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00034379959106445
(352) DESCRIBE `ports` 0.0016269683837891
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00038599967956543
(354) DESCRIBE `ports` 0.001694917678833
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00033402442932129
(356) DESCRIBE `ports` 0.0016980171203613
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00044798851013184
(358) DESCRIBE `ports` 0.0016868114471436
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00032782554626465
(360) DESCRIBE `ports` 0.0016469955444336
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00038290023803711
(362) DESCRIBE `ports` 0.0016460418701172
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00036501884460449
(364) DESCRIBE `ports` 0.0016460418701172
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00053882598876953
(366) DESCRIBE `ports` 0.0015919208526611
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00035405158996582
(368) DESCRIBE `ports` 0.0015599727630615
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00033807754516602
(370) DESCRIBE `ports` 0.001309871673584
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00036716461181641
(372) DESCRIBE `cruises` 0.0027759075164795
(373) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71401))) 0.00047492980957031
(374) DESCRIBE `avid_specials` 0.0011579990386963
(375) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541089 and class = 'Special') OR (item_id = 71401 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013179779052734
(376) DESCRIBE `cruiselines` 0.0021278858184814
(377) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00056099891662598
(378) DESCRIBE `orchid_image` 0.0020241737365723
(379) DESCRIBE `cruiselines` 0.0023930072784424
(380) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00031113624572754
(381) DESCRIBE `cruises` 0.0025849342346191
(382) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71401') 0.00041794776916504
(383) DESCRIBE `ships` 0.0034909248352051
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00049901008605957
(385) DESCRIBE `ships` 0.0034489631652832
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00028491020202637
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0002741813659668
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0002598762512207
(389) DESCRIBE `itineraries` 0.001276969909668
(390) DESCRIBE `ports` 0.0014309883117676
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00033903121948242
(392) DESCRIBE `ports` 0.0014801025390625
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00047588348388672
(394) DESCRIBE `ports` 0.0017249584197998
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00033879280090332
(396) DESCRIBE `sailingdates` 0.0012860298156738
(397) DESCRIBE `ports` 0.0013968944549561
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00041294097900391
(399) DESCRIBE `ports` 0.0016419887542725
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037813186645508
(401) DESCRIBE `ports` 0.0017011165618896
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00034594535827637
(403) DESCRIBE `ports` 0.0013461112976074
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.0002899169921875
(405) DESCRIBE `ports` 0.0016970634460449
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032186508178711
(407) DESCRIBE `ports` 0.0015108585357666
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00039005279541016
(409) DESCRIBE `ports` 0.0017070770263672
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00042915344238281
(411) DESCRIBE `ports` 0.0018308162689209
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00037598609924316
(413) DESCRIBE `ports` 0.0015950202941895
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00034499168395996
(415) DESCRIBE `ports` 0.0013859272003174
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00030684471130371
(417) DESCRIBE `ports` 0.0013589859008789
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00031304359436035
(419) DESCRIBE `ports` 0.0013201236724854
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00028586387634277
(421) DESCRIBE `ports` 0.0013628005981445
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00030088424682617
(423) DESCRIBE `ports` 0.0013649463653564
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00028204917907715
(425) DESCRIBE `ports` 0.0013630390167236
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00033211708068848
(427) DESCRIBE `ports` 0.0017509460449219
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00036001205444336
(429) DESCRIBE `ports` 0.0017569065093994
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00039196014404297
(431) DESCRIBE `ports` 0.0016629695892334
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0002899169921875
(433) DESCRIBE `ports` 0.0013251304626465
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00040888786315918
(435) DESCRIBE `ports` 0.0016000270843506
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0003669261932373
(437) DESCRIBE `avid_specials` 0.0011541843414307
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71401 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012729167938232
(439) DESCRIBE `cruiselines` 0.0019018650054932
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.0004119873046875
(441) DESCRIBE `orchid_image` 0.0015208721160889
(442) DESCRIBE `cruiselines` 0.0019528865814209
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00033211708068848
(444) DESCRIBE `cruises` 0.002593994140625
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71402') 0.00031590461730957
(446) DESCRIBE `ships` 0.0027668476104736
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00039386749267578
(448) DESCRIBE `ships` 0.0027508735656738
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00032496452331543
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00040388107299805
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029492378234863
(452) DESCRIBE `itineraries` 0.0013740062713623
(453) DESCRIBE `ports` 0.0013840198516846
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00040292739868164
(455) DESCRIBE `ports` 0.0015890598297119
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00042295455932617
(457) DESCRIBE `ports` 0.0018510818481445
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00038599967956543
(459) DESCRIBE `sailingdates` 0.0014290809631348
(460) DESCRIBE `ports` 0.0014550685882568
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048494338989258
(462) DESCRIBE `ports` 0.001384973526001
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00032615661621094
(464) DESCRIBE `ports` 0.001352071762085
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00033402442932129
(466) DESCRIBE `ports` 0.0014500617980957
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00032305717468262
(468) DESCRIBE `ports` 0.0013270378112793
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00036287307739258
(470) DESCRIBE `ports` 0.001270055770874
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00028300285339355
(472) DESCRIBE `ports` 0.0014419555664062
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00035595893859863
(474) DESCRIBE `ports` 0.0012919902801514
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028395652770996
(476) DESCRIBE `ports` 0.0013549327850342
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030612945556641
(478) DESCRIBE `ports` 0.0012569427490234
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035619735717773
(480) DESCRIBE `ports` 0.001356840133667
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00030207633972168
(482) DESCRIBE `ports` 0.0012960433959961
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00028204917907715
(484) DESCRIBE `ports` 0.0012989044189453
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00032615661621094
(486) DESCRIBE `ports` 0.0013320446014404
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00027108192443848
(488) DESCRIBE `avid_specials` 0.0011241436004639
(489) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71402 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011730194091797
(490) DESCRIBE `cruiselines` 0.0018129348754883
(491) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00032806396484375
(492) DESCRIBE `orchid_image` 0.0014870166778564
(493) DESCRIBE `cruiselines` 0.0019230842590332
(494) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00029993057250977
(495) DESCRIBE `specials` 0.0035660266876221
(496) DESCRIBE `specials` 0.0034780502319336
(497) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541090') 0.0003361701965332
(498) DESCRIBE `ships` 0.0025179386138916
(499) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00036811828613281
(500) DESCRIBE `ships` 0.002892017364502
(501) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00036120414733887
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034308433532715
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033020973205566
(504) DESCRIBE `itineraries` 0.0013928413391113
(505) DESCRIBE `ports` 0.0017578601837158
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00038695335388184
(507) DESCRIBE `ports` 0.0016920566558838
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00038909912109375
(509) DESCRIBE `ports` 0.0016541481018066
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00036501884460449
(511) DESCRIBE `specialsailingdates` 0.0013608932495117
(512) DESCRIBE `sailingdates` 0.0014631748199463
(513) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453277))) 0.00039792060852051
(514) DESCRIBE `ports` 0.0017809867858887
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00039196014404297
(516) DESCRIBE `ports` 0.0017280578613281
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037693977355957
(518) DESCRIBE `ports` 0.0018341541290283
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00039100646972656
(520) DESCRIBE `ports` 0.0016889572143555
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00037097930908203
(522) DESCRIBE `ports` 0.0017020702362061
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00039982795715332
(524) DESCRIBE `ports` 0.0017571449279785
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035691261291504
(526) DESCRIBE `ports` 0.0016520023345947
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00038695335388184
(528) DESCRIBE `ports` 0.0016870498657227
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00034904479980469
(530) DESCRIBE `ports` 0.0016591548919678
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00039100646972656
(532) DESCRIBE `ports` 0.0017378330230713
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035309791564941
(534) DESCRIBE `ports` 0.0016350746154785
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00040102005004883
(536) DESCRIBE `ports` 0.0016658306121826
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00048613548278809
(538) DESCRIBE `ports` 0.0016658306121826
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.0003969669342041
(540) DESCRIBE `ports` 0.0016870498657227
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00035715103149414
(542) DESCRIBE `ports` 0.001723051071167
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.0003972053527832
(544) DESCRIBE `ports` 0.0016570091247559
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00035810470581055
(546) DESCRIBE `ports` 0.0016591548919678
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00039887428283691
(548) DESCRIBE `ports` 0.0017309188842773
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00033712387084961
(550) DESCRIBE `ports` 0.0017039775848389
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048494338989258
(552) DESCRIBE `ports` 0.0016880035400391
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00038599967956543
(554) DESCRIBE `cruises` 0.0033190250396729
(555) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71403))) 0.00049495697021484
(556) DESCRIBE `avid_specials` 0.0015769004821777
(557) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541090 and class = 'Special') OR (item_id = 71403 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018529891967773
(558) DESCRIBE `cruiselines` 0.0025858879089355
(559) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00049495697021484
(560) DESCRIBE `orchid_image` 0.0020029544830322
(561) DESCRIBE `cruiselines` 0.0024209022521973
(562) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00039482116699219
(563) DESCRIBE `cruises` 0.0033891201019287
(564) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71403') 0.00041103363037109
(565) DESCRIBE `ships` 0.0034821033477783
(566) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00057411193847656
(567) DESCRIBE `ships` 0.0037310123443604
(568) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00040817260742188
(569) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034713745117188
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00038790702819824
(571) DESCRIBE `itineraries` 0.00187087059021
(572) DESCRIBE `ports` 0.0018599033355713
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00056791305541992
(574) DESCRIBE `ports` 0.0018608570098877
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00040102005004883
(576) DESCRIBE `ports` 0.0017120838165283
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003669261932373
(578) DESCRIBE `sailingdates` 0.0017058849334717
(579) DESCRIBE `ports` 0.0017609596252441
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00043082237243652
(581) DESCRIBE `ports` 0.0016720294952393
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003669261932373
(583) DESCRIBE `ports` 0.001694917678833
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00041890144348145
(585) DESCRIBE `ports` 0.0017299652099609
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00037598609924316
(587) DESCRIBE `ports` 0.0017311573028564
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00039911270141602
(589) DESCRIBE `ports` 0.0016689300537109
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00035285949707031
(591) DESCRIBE `ports` 0.0016148090362549
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003058910369873
(593) DESCRIBE `ports` 0.0014431476593018
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028586387634277
(595) DESCRIBE `ports` 0.0012860298156738
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00033116340637207
(597) DESCRIBE `ports` 0.0013039112091064
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00028204917907715
(599) DESCRIBE `ports` 0.0013260841369629
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00037813186645508
(601) DESCRIBE `ports` 0.0015029907226562
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00038909912109375
(603) DESCRIBE `ports` 0.0017960071563721
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00037384033203125
(605) DESCRIBE `ports` 0.0015180110931396
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00027704238891602
(607) DESCRIBE `ports` 0.0013461112976074
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00038814544677734
(609) DESCRIBE `ports` 0.001471996307373
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00028181076049805
(611) DESCRIBE `ports` 0.0015308856964111
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00037002563476562
(613) DESCRIBE `ports` 0.0014889240264893
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0003359317779541
(615) DESCRIBE `ports` 0.0015389919281006
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00037908554077148
(617) DESCRIBE `ports` 0.0015311241149902
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00038695335388184
(619) DESCRIBE `avid_specials` 0.0012190341949463
(620) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71403 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013201236724854
(621) DESCRIBE `cruiselines` 0.0018899440765381
(622) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00045394897460938
(623) DESCRIBE `orchid_image` 0.0014441013336182
(624) DESCRIBE `cruiselines` 0.0020530223846436
(625) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00030899047851562
(626) DESCRIBE `cruisetypes` 0.0011000633239746
(627) DESCRIBE `cruiselines` 0.0022048950195312
(628) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00039505958557129
(629) DESCRIBE `ships` 0.0027611255645752
(630) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00033712387084961
(631) DESCRIBE `destinations` 0.0018041133880615
(632) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 26))) 0.00033783912658691
(633) DESCRIBE `destinations` 0.0019209384918213
(634) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 26))) 0.00034213066101074
(635) DESCRIBE `cruiselines` 0.0019130706787109
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00032520294189453
(637) DESCRIBE `ships` 0.002795934677124
(638) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00034308433532715