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

Total elapsed time: 0.61668610572815

# Query Time
(1) connect 0.00073885917663574
(2) DESCRIBE `cruises` 0.0030767917633057
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80653, 82013, 82014, 80654, 82015, 80650, 82415, 80652, 80655, 80656)) ORDER BY FIND_IN_SET(id, '80653,82013,82014,80654,82015,80650,82415,80652,80655,80656') 0.0012819766998291
(4) DESCRIBE `specials` 0.0038270950317383
(5) DESCRIBE `specials` 0.0053009986877441
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554973') 0.00046014785766602
(7) DESCRIBE `ships` 0.0026540756225586
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00034213066101074
(9) DESCRIBE `ships` 0.0024929046630859
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00029420852661133
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003199577331543
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00025415420532227
(13) DESCRIBE `itineraries` 0.0012269020080566
(14) DESCRIBE `ports` 0.0013959407806396
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036191940307617
(16) DESCRIBE `ports` 0.0012941360473633
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(18) DESCRIBE `ports` 0.0012891292572021
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028181076049805
(20) DESCRIBE `specialsailingdates` 0.0011279582977295
(21) DESCRIBE `sailingdates` 0.0011930465698242
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500073))) 0.00039005279541016
(23) DESCRIBE `sailingdates` 0.0011110305786133
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500083))) 0.00026988983154297
(25) DESCRIBE `sailingdates` 0.0013551712036133
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500084))) 0.00027108192443848
(27) DESCRIBE `sailingdates` 0.0010941028594971
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500085))) 0.00026702880859375
(29) DESCRIBE `sailingdates` 0.0011410713195801
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500087))) 0.00026702880859375
(31) DESCRIBE `ports` 0.0012807846069336
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(33) DESCRIBE `ports` 0.0013210773468018
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028109550476074
(35) DESCRIBE `ports` 0.0012309551239014
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00033092498779297
(37) DESCRIBE `ports` 0.0012350082397461
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00026893615722656
(39) DESCRIBE `ports` 0.001227855682373
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00035405158996582
(41) DESCRIBE `ports` 0.0012311935424805
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00027799606323242
(43) DESCRIBE `ports` 0.0013248920440674
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00031208992004395
(45) DESCRIBE `ports` 0.0012340545654297
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00027894973754883
(47) DESCRIBE `ports` 0.0012779235839844
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029087066650391
(49) DESCRIBE `ports` 0.0012569427490234
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002748966217041
(51) DESCRIBE `ports` 0.0012600421905518
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029206275939941
(53) DESCRIBE `ports` 0.0012369155883789
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(55) DESCRIBE `cruises` 0.0025830268859863
(56) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80653))) 0.00037097930908203
(57) DESCRIBE `avid_specials` 0.0011498928070068
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554973 and class = 'Special') OR (item_id = 80653 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098991394042969
(59) DESCRIBE `cruiselines` 0.0019509792327881
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00040698051452637
(61) DESCRIBE `orchid_image` 0.0014450550079346
(62) DESCRIBE `cruiselines` 0.0017409324645996
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00029706954956055
(64) DESCRIBE `specials` 0.0034871101379395
(65) DESCRIBE `specials` 0.0037100315093994
(66) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534219') 0.00038003921508789
(67) DESCRIBE `ships` 0.0024988651275635
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00033307075500488
(69) DESCRIBE `ships` 0.0026659965515137
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0001368522644043
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00027799606323242
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026297569274902
(73) DESCRIBE `itineraries` 0.0012900829315186
(74) DESCRIBE `ports` 0.0013680458068848
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041604042053223
(76) DESCRIBE `ports` 0.0012760162353516
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030612945556641
(78) DESCRIBE `ports` 0.0012960433959961
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00032305717468262
(80) DESCRIBE `specialsailingdates` 0.0010769367218018
(81) DESCRIBE `sailingdates` 0.0012531280517578
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515117))) 0.00031304359436035
(83) DESCRIBE `sailingdates` 0.0011348724365234
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515118))) 0.00027203559875488
(85) DESCRIBE `ports` 0.0012509822845459
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0003659725189209
(87) DESCRIBE `ports` 0.0018050670623779
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002892017364502
(89) DESCRIBE `ports` 0.0013439655303955
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029706954956055
(91) DESCRIBE `ports` 0.001262903213501
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002751350402832
(93) DESCRIBE `ports` 0.0013070106506348
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00029492378234863
(95) DESCRIBE `ports` 0.0015058517456055
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00032711029052734
(97) DESCRIBE `ports` 0.001615047454834
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00036191940307617
(99) DESCRIBE `ports` 0.0014700889587402
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00029516220092773
(101) DESCRIBE `ports` 0.0012822151184082
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00030684471130371
(103) DESCRIBE `ports` 0.0015490055084229
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00034904479980469
(105) DESCRIBE `ports` 0.0016179084777832
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031805038452148
(107) DESCRIBE `ports` 0.0013771057128906
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00032305717468262
(109) DESCRIBE `cruises` 0.0031309127807617
(110) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82013))) 0.00043010711669922
(111) DESCRIBE `avid_specials` 0.0011210441589355
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534219 and class = 'Special') OR (item_id = 82013 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010218620300293
(113) DESCRIBE `cruiselines` 0.0018069744110107
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00032687187194824
(115) DESCRIBE `orchid_image` 0.0014588832855225
(116) DESCRIBE `cruiselines` 0.0018241405487061
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0003361701965332
(118) DESCRIBE `specials` 0.0036280155181885
(119) DESCRIBE `specials` 0.0034518241882324
(120) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534220') 0.00034403800964355
(121) DESCRIBE `ships` 0.0027999877929688
(122) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00033998489379883
(123) DESCRIBE `ships` 0.0031149387359619
(124) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00028300285339355
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00031805038452148
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00028514862060547
(127) DESCRIBE `itineraries` 0.0015771389007568
(128) DESCRIBE `ports` 0.0015900135040283
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036787986755371
(130) DESCRIBE `ports` 0.0016510486602783
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032997131347656
(132) DESCRIBE `ports` 0.0014290809631348
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027799606323242
(134) DESCRIBE `specialsailingdates` 0.0010781288146973
(135) DESCRIBE `sailingdates` 0.0010991096496582
(136) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515119))) 0.00030398368835449
(137) DESCRIBE `ports` 0.0013000965118408
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002899169921875
(139) DESCRIBE `ports` 0.001262903213501
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027608871459961
(141) DESCRIBE `ports` 0.0012338161468506
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030779838562012
(143) DESCRIBE `ports` 0.0012609958648682
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033307075500488
(145) DESCRIBE `ports` 0.001270055770874
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00029397010803223
(147) DESCRIBE `ports` 0.0014438629150391
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00027704238891602
(149) DESCRIBE `ports` 0.0012409687042236
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00030398368835449
(151) DESCRIBE `ports` 0.0013000965118408
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00028181076049805
(153) DESCRIBE `ports` 0.0013201236724854
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030803680419922
(155) DESCRIBE `ports` 0.001317024230957
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028491020202637
(157) DESCRIBE `cruises` 0.0024199485778809
(158) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82014))) 0.00037598609924316
(159) DESCRIBE `avid_specials` 0.0011210441589355
(160) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534220 and class = 'Special') OR (item_id = 82014 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012311935424805
(161) DESCRIBE `cruiselines` 0.0020108222961426
(162) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00033187866210938
(163) DESCRIBE `orchid_image` 0.0013740062713623
(164) DESCRIBE `cruiselines` 0.0017900466918945
(165) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00029110908508301
(166) DESCRIBE `specials` 0.0035221576690674
(167) DESCRIBE `specials` 0.0039129257202148
(168) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554996') 0.00032377243041992
(169) DESCRIBE `ships` 0.0024809837341309
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00043177604675293
(171) DESCRIBE `ships` 0.0024418830871582
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00032591819763184
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00028514862060547
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00025796890258789
(175) DESCRIBE `itineraries` 0.001291036605835
(176) DESCRIBE `ports` 0.0012650489807129
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041413307189941
(178) DESCRIBE `ports` 0.0014491081237793
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030207633972168
(180) DESCRIBE `ports` 0.0013160705566406
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002901554107666
(182) DESCRIBE `specialsailingdates` 0.0011191368103027
(183) DESCRIBE `sailingdates` 0.0011539459228516
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500074))) 0.00043606758117676
(185) DESCRIBE `ports` 0.0013120174407959
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(187) DESCRIBE `ports` 0.0013020038604736
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(189) DESCRIBE `ports` 0.0013730525970459
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00033187866210938
(191) DESCRIBE `ports` 0.0014019012451172
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00027799606323242
(193) DESCRIBE `ports` 0.0013368129730225
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00031900405883789
(195) DESCRIBE `ports` 0.0012509822845459
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00030708312988281
(197) DESCRIBE `ports` 0.0013108253479004
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030183792114258
(199) DESCRIBE `ports` 0.0012619495391846
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028204917907715
(201) DESCRIBE `ports` 0.0013079643249512
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00032401084899902
(203) DESCRIBE `ports` 0.001288890838623
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00028204917907715
(205) DESCRIBE `ports` 0.0013160705566406
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(207) DESCRIBE `ports` 0.001255989074707
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027108192443848
(209) DESCRIBE `cruises` 0.002518892288208
(210) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80654))) 0.00036907196044922
(211) DESCRIBE `avid_specials` 0.0011589527130127
(212) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554996 and class = 'Special') OR (item_id = 80654 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099897384643555
(213) DESCRIBE `cruiselines` 0.0019190311431885
(214) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00032997131347656
(215) DESCRIBE `orchid_image` 0.0013771057128906
(216) DESCRIBE `cruiselines` 0.001971960067749
(217) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00031304359436035
(218) DESCRIBE `specials` 0.0035479068756104
(219) DESCRIBE `specials` 0.0034399032592773
(220) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534221') 0.00032401084899902
(221) DESCRIBE `ships` 0.0027740001678467
(222) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00040507316589355
(223) DESCRIBE `ships` 0.0027918815612793
(224) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00032901763916016
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029277801513672
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003199577331543
(227) DESCRIBE `itineraries` 0.0013711452484131
(228) DESCRIBE `ports` 0.0012781620025635
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00033092498779297
(230) DESCRIBE `ports` 0.0013370513916016
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031089782714844
(232) DESCRIBE `ports` 0.0012459754943848
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029110908508301
(234) DESCRIBE `specialsailingdates` 0.0011351108551025
(235) DESCRIBE `sailingdates` 0.0011210441589355
(236) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515120))) 0.00033783912658691
(237) DESCRIBE `ports` 0.0014500617980957
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031709671020508
(239) DESCRIBE `ports` 0.0014019012451172
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00030803680419922
(241) DESCRIBE `ports` 0.0013389587402344
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00034284591674805
(243) DESCRIBE `ports` 0.0013248920440674
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00030303001403809
(245) DESCRIBE `ports` 0.0012750625610352
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(247) DESCRIBE `ports` 0.001305103302002
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028395652770996
(249) DESCRIBE `ports` 0.0012989044189453
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00030207633972168
(251) DESCRIBE `ports` 0.0012688636779785
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00027179718017578
(253) DESCRIBE `ports` 0.0012400150299072
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00033402442932129
(255) DESCRIBE `ports` 0.0012538433074951
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00028085708618164
(257) DESCRIBE `ports` 0.0012738704681396
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00032186508178711
(259) DESCRIBE `ports` 0.0012569427490234
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00029492378234863
(261) DESCRIBE `ports` 0.0013759136199951
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030708312988281
(263) DESCRIBE `ports` 0.0012528896331787
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027179718017578
(265) DESCRIBE `cruises` 0.0025029182434082
(266) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82015))) 0.0004570484161377
(267) DESCRIBE `avid_specials` 0.0011382102966309
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534221 and class = 'Special') OR (item_id = 82015 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011100769042969
(269) DESCRIBE `cruiselines` 0.0018830299377441
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00032901763916016
(271) DESCRIBE `orchid_image` 0.001823902130127
(272) DESCRIBE `cruiselines` 0.0019769668579102
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00030279159545898
(274) DESCRIBE `specials` 0.0040268898010254
(275) DESCRIBE `specials` 0.0038051605224609
(276) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554999') 0.0003669261932373
(277) DESCRIBE `ships` 0.0029449462890625
(278) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00046300888061523
(279) DESCRIBE `ships` 0.0035200119018555
(280) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00035595893859863
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032305717468262
(282) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00073790550231934
(283) DESCRIBE `itineraries` 0.0012080669403076
(284) DESCRIBE `ports` 0.0015690326690674
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038409233093262
(286) DESCRIBE `ports` 0.0020499229431152
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(288) DESCRIBE `ports` 0.0013139247894287
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027918815612793
(290) DESCRIBE `specialsailingdates` 0.0012638568878174
(291) DESCRIBE `sailingdates` 0.0011608600616455
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500067))) 0.00031208992004395
(293) DESCRIBE `ports` 0.0012719631195068
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030684471130371
(295) DESCRIBE `ports` 0.0012941360473633
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00074100494384766
(297) DESCRIBE `ports` 0.0010089874267578
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00030303001403809
(299) DESCRIBE `ports` 0.0013241767883301
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0
(301) DESCRIBE `ports` 0.0012919902801514
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00029706954956055
(303) DESCRIBE `ports` 0.0015480518341064
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0002899169921875
(305) DESCRIBE `ports` 0.0013961791992188
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00033903121948242
(307) DESCRIBE `ports` 0.0012810230255127
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00033187866210938
(309) DESCRIBE `ports` 0.0012638568878174
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030112266540527
(311) DESCRIBE `ports` 0.0008389949798584
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028204917907715
(313) DESCRIBE `ports` 0.0012431144714355
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00033283233642578
(315) DESCRIBE `ports` 0.0012450218200684
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00027203559875488
(317) DESCRIBE `ports` 0.0013790130615234
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00018882751464844
(319) DESCRIBE `ports` 0.0013251304626465
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029301643371582
(321) DESCRIBE `cruises` 0.0025498867034912
(322) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80650))) 0.00037288665771484
(323) DESCRIBE `avid_specials` 0.0012798309326172
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554999 and class = 'Special') OR (item_id = 80650 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010311603546143
(325) DESCRIBE `cruiselines` 0.0018570423126221
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0003352165222168
(327) DESCRIBE `orchid_image` 0.001384973526001
(328) DESCRIBE `cruiselines` 0.0018310546875
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00032401084899902
(330) DESCRIBE `specials` 0.0038070678710938
(331) DESCRIBE `specials` 0.003385066986084
(332) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554971') 0.0003058910369873
(333) DESCRIBE `ships` 0.0024969577789307
(334) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00039505958557129
(335) DESCRIBE `ships` 0.0027329921722412
(336) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00034713745117188
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 1.5020370483398E-5
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00031399726867676
(339) DESCRIBE `itineraries` 0.0013191699981689
(340) DESCRIBE `ports` 0.0013530254364014
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030899047851562
(342) DESCRIBE `ports` 0.0015289783477783
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00039196014404297
(344) DESCRIBE `ports` 0.001255989074707
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028800964355469
(346) DESCRIBE `specialsailingdates` 0.0010509490966797
(347) DESCRIBE `sailingdates` 0.001115083694458
(348) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518396))) 0.00032997131347656
(349) DESCRIBE `ports` 0.0012609958648682
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00031304359436035
(351) DESCRIBE `ports` 0.0013740062713623
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028610229492188
(353) DESCRIBE `ports` 0.0013818740844727
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00030207633972168
(355) DESCRIBE `ports` 0.0014638900756836
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00010800361633301
(357) DESCRIBE `ports` 0.0013389587402344
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030684471130371
(359) DESCRIBE `ports` 0.0012719631195068
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028014183044434
(361) DESCRIBE `ports` 0.0012738704681396
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00030803680419922
(363) DESCRIBE `ports` 0.0010149478912354
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028204917907715
(365) DESCRIBE `ports` 0.001276969909668
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00053310394287109
(367) DESCRIBE `ports` 0.0016400814056396
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00034809112548828
(369) DESCRIBE `ports` 0.0017890930175781
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00036406517028809
(371) DESCRIBE `ports` 0.001295804977417
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0003049373626709
(373) DESCRIBE `ports` 0.0012781620025635
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030207633972168
(375) DESCRIBE `ports` 0.0012860298156738
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0002739429473877
(377) DESCRIBE `ports` 0.001439094543457
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00031399726867676
(379) DESCRIBE `ports` 0.0013298988342285
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00029683113098145
(381) DESCRIBE `cruises` 0.0050280094146729
(382) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82415))) 0.00054216384887695
(383) DESCRIBE `avid_specials` 0.001270055770874
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554971 and class = 'Special') OR (item_id = 82415 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010290145874023
(385) DESCRIBE `cruiselines` 0.0019021034240723
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00037217140197754
(387) DESCRIBE `orchid_image` 0.0015120506286621
(388) DESCRIBE `cruiselines` 0.002593994140625
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00042200088500977
(390) DESCRIBE `specials` 0.0039050579071045
(391) DESCRIBE `specials` 0.0038700103759766
(392) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554714') 0.00036191940307617
(393) DESCRIBE `ships` 0.0036959648132324
(394) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00037598609924316
(395) DESCRIBE `ships` 0.0026969909667969
(396) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00027108192443848
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026679039001465
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029397010803223
(399) DESCRIBE `itineraries` 0.001446008682251
(400) DESCRIBE `ports` 0.0013198852539062
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036811828613281
(402) DESCRIBE `ports` 0.0013120174407959
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030612945556641
(404) DESCRIBE `ports` 0.0012669563293457
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027799606323242
(406) DESCRIBE `specialsailingdates` 0.0010809898376465
(407) DESCRIBE `sailingdates` 0.0016448497772217
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500069))) 0.00035500526428223
(409) DESCRIBE `sailingdates` 0.0013110637664795
(410) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500088))) 0.00029492378234863
(411) DESCRIBE `sailingdates` 0.0010979175567627
(412) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500071))) 0.00027894973754883
(413) DESCRIBE `sailingdates` 0.0011019706726074
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500089))) 0.00030803680419922
(415) DESCRIBE `ports` 0.0012729167938232
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033211708068848
(417) DESCRIBE `ports` 0.0015459060668945
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030398368835449
(419) DESCRIBE `ports` 0.0012729167938232
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00031709671020508
(421) DESCRIBE `ports` 0.00130295753479
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028491020202637
(423) DESCRIBE `ports` 0.0012850761413574
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00037288665771484
(425) DESCRIBE `ports` 0.001262903213501
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00028014183044434
(427) DESCRIBE `ports` 0.0012500286102295
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00029897689819336
(429) DESCRIBE `ports` 0.0012428760528564
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00028300285339355
(431) DESCRIBE `ports` 0.0013101100921631
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00031208992004395
(433) DESCRIBE `ports` 0.0012609958648682
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0002739429473877
(435) DESCRIBE `ports` 0.001338005065918
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030207633972168
(437) DESCRIBE `ports` 0.0012950897216797
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00027298927307129
(439) DESCRIBE `ports` 0.0013010501861572
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00028681755065918
(441) DESCRIBE `ports` 0.0012800693511963
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00028300285339355
(443) DESCRIBE `ports` 0.0013241767883301
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031709671020508
(445) DESCRIBE `ports` 0.0012369155883789
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00032997131347656
(447) DESCRIBE `cruises` 0.0027828216552734
(448) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80652))) 0.0004119873046875
(449) DESCRIBE `avid_specials` 0.0013220310211182
(450) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554714 and class = 'Special') OR (item_id = 80652 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014750957489014
(451) DESCRIBE `cruiselines` 0.0022339820861816
(452) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00045180320739746
(453) DESCRIBE `orchid_image` 0.0016279220581055
(454) DESCRIBE `cruiselines` 0.0018160343170166
(455) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00031900405883789
(456) DESCRIBE `specials` 0.0036020278930664
(457) DESCRIBE `specials` 0.0035889148712158
(458) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554718') 0.00035715103149414
(459) DESCRIBE `ships` 0.0025820732116699
(460) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0003969669342041
(461) DESCRIBE `ships` 0.0024759769439697
(462) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00027012825012207
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00028014183044434
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026917457580566
(465) DESCRIBE `itineraries` 0.0012249946594238
(466) DESCRIBE `ports` 0.0012781620025635
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00057101249694824
(468) DESCRIBE `ports` 0.0013399124145508
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028800964355469
(470) DESCRIBE `ports` 0.0016570091247559
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028395652770996
(472) DESCRIBE `specialsailingdates` 0.0012600421905518
(473) DESCRIBE `sailingdates` 0.0013418197631836
(474) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500075))) 0.00035691261291504
(475) DESCRIBE `ports` 0.0012669563293457
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0007171630859375
(477) DESCRIBE `ports` 0.001072883605957
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029897689819336
(479) DESCRIBE `ports` 0.0014138221740723
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00020194053649902
(481) DESCRIBE `ports` 0.0013139247894287
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00029706954956055
(483) DESCRIBE `ports` 0.00136399269104
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00039792060852051
(485) DESCRIBE `ports` 0.0015120506286621
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00067687034606934
(487) DESCRIBE `ports` 0.001086950302124
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00035214424133301
(489) DESCRIBE `ports` 0.001413106918335
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00028395652770996
(491) DESCRIBE `ports` 0.0012679100036621
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0003049373626709
(493) DESCRIBE `ports` 0.0013358592987061
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00028514862060547
(495) DESCRIBE `ports` 0.001291036605835
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00037693977355957
(497) DESCRIBE `ports` 0.0012547969818115
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00027203559875488
(499) DESCRIBE `ports` 0.0012581348419189
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00027894973754883
(501) DESCRIBE `ports` 0.00086116790771484
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026106834411621
(503) DESCRIBE `ports` 0.0013430118560791
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031518936157227
(505) DESCRIBE `ports` 0.0012631416320801
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029492378234863
(507) DESCRIBE `cruises` 0.002439022064209
(508) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80655))) 0.0004119873046875
(509) DESCRIBE `avid_specials` 0.001288890838623
(510) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554718 and class = 'Special') OR (item_id = 80655 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010309219360352
(511) DESCRIBE `cruiselines` 0.0017859935760498
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00034308433532715
(513) DESCRIBE `orchid_image` 0.0014669895172119
(514) DESCRIBE `cruiselines` 0.0019519329071045
(515) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00031685829162598
(516) DESCRIBE `specials` 0.0035262107849121
(517) DESCRIBE `specials` 0.00347900390625
(518) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554969') 0.00033688545227051
(519) DESCRIBE `ships` 0.0027320384979248
(520) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00053501129150391
(521) DESCRIBE `ships` 0.0031979084014893
(522) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0003809928894043
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034713745117188
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034499168395996
(525) DESCRIBE `itineraries` 0.0017421245574951
(526) DESCRIBE `ports` 0.0017209053039551
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004420280456543
(528) DESCRIBE `ports` 0.0012869834899902
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030112266540527
(530) DESCRIBE `ports` 0.0012989044189453
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029492378234863
(532) DESCRIBE `specialsailingdates` 0.0014679431915283
(533) DESCRIBE `sailingdates` 0.0015320777893066
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500076))) 0.0003669261932373
(535) DESCRIBE `ports` 0.0014839172363281
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036501884460449
(537) DESCRIBE `ports` 0.0017499923706055
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029206275939941
(539) DESCRIBE `ports` 0.0012650489807129
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00033402442932129
(541) DESCRIBE `ports` 0.0013308525085449
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028800964355469
(543) DESCRIBE `ports` 0.0015120506286621
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00036096572875977
(545) DESCRIBE `ports` 0.0012838840484619
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00028681755065918
(547) DESCRIBE `ports` 0.0012600421905518
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00031614303588867
(549) DESCRIBE `ports` 0.0013201236724854
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0002748966217041
(551) DESCRIBE `ports` 0.0013120174407959
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029993057250977
(553) DESCRIBE `ports` 0.001255989074707
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00027203559875488
(555) DESCRIBE `ports` 0.0012800693511963
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00030112266540527
(557) DESCRIBE `ports` 0.0012640953063965
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026893615722656
(559) DESCRIBE `ports` 0.0012609958648682
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00030183792114258
(561) DESCRIBE `ports` 0.0012729167938232
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00041389465332031
(563) DESCRIBE `ports` 0.0038609504699707
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003509521484375
(565) DESCRIBE `ports` 0.0013620853424072
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030708312988281
(567) DESCRIBE `cruises` 0.0026698112487793
(568) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80656))) 0.00039482116699219
(569) DESCRIBE `avid_specials` 0.0011529922485352
(570) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554969 and class = 'Special') OR (item_id = 80656 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023050308227539
(571) DESCRIBE `cruiselines` 0.002129077911377
(572) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00038003921508789
(573) DESCRIBE `orchid_image` 0.0014491081237793
(574) DESCRIBE `cruiselines` 0.0020520687103271
(575) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00032591819763184
(576) DESCRIBE `cruisetypes` 0.0012450218200684
(577) DESCRIBE `destinations` 0.0017480850219727
(578) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43')) ORDER BY FIND_IN_SET(id, '8,43') 0.00066399574279785
(579) DESCRIBE `cruiselines` 0.0019838809967041
(580) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00038695335388184
(581) DESCRIBE `ships` 0.0028331279754639
(582) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0003509521484375
(583) DESCRIBE `cruiselines` 0.0020089149475098
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00037193298339844
(585) DESCRIBE `ships` 0.0025758743286133
(586) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00032496452331543