or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 0.88730931282043

# Query Time
(1) connect 0.0014410018920898
(2) DESCRIBE `cruises` 0.0029981136322021
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82063, 68831, 82064, 82123, 45864, 66763, 82065, 67492, 82068, 66651)) ORDER BY FIND_IN_SET(id, '82063,68831,82064,82123,45864,66763,82065,67492,82068,66651') 0.0016272068023682
(4) DESCRIBE `specials` 0.0042991638183594
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1534175') AND (specials.orchid_available = 1) LIMIT 1 0.00071310997009277
(6) DESCRIBE `specials` 0.0051600933074951
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534175') 0.00042319297790527
(8) DESCRIBE `ships` 0.0021140575408936
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00040388107299805
(10) DESCRIBE `ships` 0.0025730133056641
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00038504600524902
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034785270690918
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033307075500488
(14) DESCRIBE `itineraries` 0.0024259090423584
(15) DESCRIBE `ports` 0.0017199516296387
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041699409484863
(17) DESCRIBE `ports` 0.0017821788787842
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00043392181396484
(19) DESCRIBE `ports` 0.0017859935760498
(20) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00034785270690918
(21) DESCRIBE `specialsailingdates` 0.0014960765838623
(22) DESCRIBE `sailingdates` 0.0015799999237061
(23) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515290))) 0.00040698051452637
(24) DESCRIBE `sailingdates` 0.0014910697937012
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515291))) 0.00032687187194824
(26) DESCRIBE `sailingdates` 0.0012450218200684
(27) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515292))) 0.00031590461730957
(28) DESCRIBE `sailingdates` 0.0011839866638184
(29) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515296))) 0.00031709671020508
(30) DESCRIBE `sailingdates` 0.0012481212615967
(31) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515304))) 0.00032687187194824
(32) DESCRIBE `sailingdates` 0.0011279582977295
(33) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515305))) 0.00027084350585938
(34) DESCRIBE `sailingdates` 0.0011420249938965
(35) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515308))) 0.00026893615722656
(36) DESCRIBE `sailingdates` 0.0010898113250732
(37) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515325))) 0.00026893615722656
(38) DESCRIBE `sailingdates` 0.001237154006958
(39) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515330))) 0.00026988983154297
(40) DESCRIBE `sailingdates` 0.0010941028594971
(41) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515331))) 0.00026893615722656
(42) DESCRIBE `sailingdates` 0.0012741088867188
(43) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515332))) 0.00034403800964355
(44) DESCRIBE `sailingdates` 0.0015778541564941
(45) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515333))) 0.00034213066101074
(46) DESCRIBE `ports` 0.0013930797576904
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0
(48) DESCRIBE `ports` 0.0014548301696777
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0
(50) DESCRIBE `ports` 0.0009610652923584
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00059795379638672
(52) DESCRIBE `ports` 0.0016570091247559
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00043892860412598
(54) DESCRIBE `ports` 0.0024240016937256
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00039911270141602
(56) DESCRIBE `ports` 0.0016880035400391
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00034904479980469
(58) DESCRIBE `ports` 0.0013477802276611
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00030684471130371
(60) DESCRIBE `ports` 0.0012519359588623
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027704238891602
(62) DESCRIBE `ports` 0.0013229846954346
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00031423568725586
(64) DESCRIBE `ports` 0.0012860298156738
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029397010803223
(66) DESCRIBE `ports` 0.0012829303741455
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00030303001403809
(68) DESCRIBE `ports` 0.0013630390167236
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00040388107299805
(70) DESCRIBE `ports` 0.0020039081573486
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00077199935913086
(72) DESCRIBE `ports` 0.0013139247894287
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00030708312988281
(74) DESCRIBE `ports` 0.0014371871948242
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00033807754516602
(76) DESCRIBE `ports` 0.0012660026550293
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00028610229492188
(78) DESCRIBE `ports` 0.0013279914855957
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032901763916016
(80) DESCRIBE `ports` 0.0015490055084229
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039815902709961
(82) DESCRIBE `cruises` 0.0028300285339355
(83) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82063))) 0.00050592422485352
(84) DESCRIBE `avid_specials` 0.0012190341949463
(85) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534175 and class = 'Special') OR (item_id = 82063 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011241436004639
(86) DESCRIBE `cruiselines` 0.0018460750579834
(87) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00036311149597168
(88) DESCRIBE `orchid_image` 0.0014848709106445
(89) DESCRIBE `cruiselines` 0.0024540424346924
(90) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00040984153747559
(91) DESCRIBE `specials` 0.0041589736938477
(92) SELECT `specials`.* FROM `specials` WHERE (id = '1534180') AND (specials.orchid_available = 1) LIMIT 1 0.0005028247833252
(93) DESCRIBE `specials` 0.0041069984436035
(94) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534180') 0.00035810470581055
(95) DESCRIBE `ships` 0.0026519298553467
(96) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00035715103149414
(97) DESCRIBE `ships` 0.0024449825286865
(98) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00028610229492188
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002748966217041
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(101) DESCRIBE `itineraries` 0.0012609958648682
(102) DESCRIBE `ports` 0.0012569427490234
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003049373626709
(104) DESCRIBE `ports` 0.0013179779052734
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029301643371582
(106) DESCRIBE `ports` 0.001244068145752
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0002739429473877
(108) DESCRIBE `specialsailingdates` 0.0017201900482178
(109) DESCRIBE `sailingdates` 0.0012400150299072
(110) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515685))) 0
(111) DESCRIBE `sailingdates` 0.001338005065918
(112) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515686))) 0.00028109550476074
(113) DESCRIBE `sailingdates` 0.001288890838623
(114) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515690))) 0.00034785270690918
(115) DESCRIBE `sailingdates` 0.0011370182037354
(116) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515691))) 0.00031208992004395
(117) DESCRIBE `sailingdates` 0.0013589859008789
(118) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515696))) 0.00028204917907715
(119) DESCRIBE `sailingdates` 0.0013329982757568
(120) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515697))) 0.00034880638122559
(121) DESCRIBE `sailingdates` 0.0014519691467285
(122) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515698))) 0.00035715103149414
(123) DESCRIBE `sailingdates` 0.0014598369598389
(124) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515699))) 0.00036716461181641
(125) DESCRIBE `sailingdates` 0.0014588832855225
(126) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515288))) 0.00033402442932129
(127) DESCRIBE `sailingdates` 0.0012669563293457
(128) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515704))) 0.00028896331787109
(129) DESCRIBE `sailingdates` 0.001176118850708
(130) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515711))) 0.00030303001403809
(131) DESCRIBE `sailingdates` 0.0011930465698242
(132) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515712))) 0.00029587745666504
(133) DESCRIBE `sailingdates` 0.0014379024505615
(134) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515713))) 0.00040006637573242
(135) DESCRIBE `sailingdates` 0.0012199878692627
(136) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515718))) 0.00029397010803223
(137) DESCRIBE `sailingdates` 0.0012710094451904
(138) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515719))) 0.00028109550476074
(139) DESCRIBE `sailingdates` 0.0011038780212402
(140) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515720))) 0.00027585029602051
(141) DESCRIBE `sailingdates` 0.0011329650878906
(142) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515721))) 0.00032806396484375
(143) DESCRIBE `sailingdates` 0.0012400150299072
(144) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515725))) 0.00031304359436035
(145) DESCRIBE `ports` 0.0014450550079346
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032687187194824
(147) DESCRIBE `ports` 0.0012879371643066
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028395652770996
(149) DESCRIBE `ports` 0.001255989074707
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029206275939941
(151) DESCRIBE `ports` 0.0013110637664795
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0002741813659668
(153) DESCRIBE `ports` 0.0012631416320801
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00029397010803223
(155) DESCRIBE `ports` 0.0013329982757568
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00028586387634277
(157) DESCRIBE `ports` 0.0012819766998291
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00030207633972168
(159) DESCRIBE `ports` 0.0013580322265625
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027704238891602
(161) DESCRIBE `ports` 0.0013248920440674
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00033807754516602
(163) DESCRIBE `ports` 0.0013079643249512
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029802322387695
(165) DESCRIBE `ports` 0.0013091564178467
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00031900405883789
(167) DESCRIBE `ports` 0.0012469291687012
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00034904479980469
(169) DESCRIBE `ports` 0.0012750625610352
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00034213066101074
(171) DESCRIBE `ports` 0.0013289451599121
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00033092498779297
(173) DESCRIBE `ports` 0.00091695785522461
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00037908554077148
(175) DESCRIBE `ports` 0.0013301372528076
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029206275939941
(177) DESCRIBE `ports` 0.0012500286102295
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030708312988281
(179) DESCRIBE `ports` 0.0012660026550293
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00028586387634277
(181) DESCRIBE `cruises` 0.0024499893188477
(182) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68831))) 0.00046992301940918
(183) DESCRIBE `avid_specials` 0.0016040802001953
(184) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534180 and class = 'Special') OR (item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010859966278076
(185) DESCRIBE `cruiselines` 0.0019521713256836
(186) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032615661621094
(187) DESCRIBE `orchid_image` 0.0018720626831055
(188) DESCRIBE `cruiselines` 0.0018291473388672
(189) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0005800724029541
(190) DESCRIBE `specials` 0.0056462287902832
(191) SELECT `specials`.* FROM `specials` WHERE (id = '1534121') AND (specials.orchid_available = 1) LIMIT 1 0.00065398216247559
(192) DESCRIBE `specials` 0.0042738914489746
(193) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534121') 0.00032591819763184
(194) DESCRIBE `ships` 0.0035860538482666
(195) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00048089027404785
(196) DESCRIBE `ships` 0.0027689933776855
(197) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00046515464782715
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035595893859863
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(200) DESCRIBE `itineraries` 0.0017800331115723
(201) DESCRIBE `ports` 0.0013279914855957
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039911270141602
(203) DESCRIBE `ports` 0.0016460418701172
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039982795715332
(205) DESCRIBE `ports` 0.0017800331115723
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029397010803223
(207) DESCRIBE `specialsailingdates` 0.0010418891906738
(208) DESCRIBE `sailingdates` 0.0011680126190186
(209) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515297))) 0.0003960132598877
(210) DESCRIBE `ports` 0.0013470649719238
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033211708068848
(212) DESCRIBE `ports` 0.0012528896331787
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00033092498779297
(214) DESCRIBE `ports` 0.001317024230957
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033688545227051
(216) DESCRIBE `ports` 0.0012979507446289
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0002748966217041
(218) DESCRIBE `ports` 0.0012929439544678
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028896331787109
(220) DESCRIBE `ports` 0.0012290477752686
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028777122497559
(222) DESCRIBE `ports` 0.0014579296112061
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00029587745666504
(224) DESCRIBE `ports` 0.0012400150299072
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0002739429473877
(226) DESCRIBE `ports` 0.0012400150299072
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00030016899108887
(228) DESCRIBE `ports` 0.0012950897216797
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00027918815612793
(230) DESCRIBE `ports` 0.0013289451599121
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00029182434082031
(232) DESCRIBE `ports` 0.0013139247894287
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00034189224243164
(234) DESCRIBE `ports` 0.0013020038604736
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00030994415283203
(236) DESCRIBE `ports` 0.0013339519500732
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.0002751350402832
(238) DESCRIBE `ports` 0.001230001449585
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00031614303588867
(240) DESCRIBE `ports` 0.0013210773468018
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00027298927307129
(242) DESCRIBE `ports` 0.0012478828430176
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032901763916016
(244) DESCRIBE `ports` 0.0012450218200684
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00027179718017578
(246) DESCRIBE `cruises` 0.0024478435516357
(247) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82064))) 0.00044918060302734
(248) DESCRIBE `avid_specials` 0.0011239051818848
(249) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534121 and class = 'Special') OR (item_id = 82064 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011289119720459
(250) DESCRIBE `cruiselines` 0.0019309520721436
(251) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034618377685547
(252) DESCRIBE `orchid_image` 0.0014221668243408
(253) DESCRIBE `cruiselines` 0.0018589496612549
(254) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00031590461730957
(255) DESCRIBE `specials` 0.0034739971160889
(256) SELECT `specials`.* FROM `specials` WHERE (id = '1534177') AND (specials.orchid_available = 1) LIMIT 1 0.00066018104553223
(257) DESCRIBE `specials` 0.0045340061187744
(258) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534177') 0.0010499954223633
(259) DESCRIBE `ships` 0.0032079219818115
(260) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00040292739868164
(261) DESCRIBE `ships` 0.0028760433197021
(262) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00033783912658691
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026893615722656
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(265) DESCRIBE `itineraries` 0.0013229846954346
(266) DESCRIBE `ports` 0.0018289089202881
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00050616264343262
(268) DESCRIBE `ports` 0.0019478797912598
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0003199577331543
(270) DESCRIBE `ports` 0.0012609958648682
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00030112266540527
(272) DESCRIBE `specialsailingdates` 0.0012879371643066
(273) DESCRIBE `sailingdates` 0.0012149810791016
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515641))) 0.00034618377685547
(275) DESCRIBE `sailingdates` 0.0011138916015625
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515642))) 0.00028395652770996
(277) DESCRIBE `sailingdates` 0.0011999607086182
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515646))) 1.0013580322266E-5
(279) DESCRIBE `sailingdates` 0.0010228157043457
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515647))) 0.00028395652770996
(281) DESCRIBE `sailingdates` 0.0012099742889404
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515648))) 0.00027608871459961
(283) DESCRIBE `sailingdates` 0.0011470317840576
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515649))) 0.0003049373626709
(285) DESCRIBE `sailingdates` 0.0010931491851807
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515655))) 0.00028300285339355
(287) DESCRIBE `sailingdates` 0.0012009143829346
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515656))) 0.00034213066101074
(289) DESCRIBE `sailingdates` 0.00098919868469238
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515657))) 0.00027894973754883
(291) DESCRIBE `sailingdates` 0.0018160343170166
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515658))) 0.00039386749267578
(293) DESCRIBE `sailingdates` 0.0014288425445557
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515661))) 0.0008399486541748
(295) DESCRIBE `sailingdates` 0.0011699199676514
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515662))) 0.0003972053527832
(297) DESCRIBE `sailingdates` 0.0015270709991455
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515663))) 0.00033187866210938
(299) DESCRIBE `sailingdates` 0.0013680458068848
(300) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515668))) 0.00035500526428223
(301) DESCRIBE `sailingdates` 0.0015699863433838
(302) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515669))) 0.00041604042053223
(303) DESCRIBE `sailingdates` 0.0012149810791016
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515670))) 0.0002899169921875
(305) DESCRIBE `sailingdates` 0.0012779235839844
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515671))) 0.00033712387084961
(307) DESCRIBE `sailingdates` 0.0013351440429688
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515676))) 0.00029993057250977
(309) DESCRIBE `ports` 0.0017020702362061
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00039291381835938
(311) DESCRIBE `ports` 0.0015130043029785
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00040698051452637
(313) DESCRIBE `ports` 0.0012710094451904
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00043606758117676
(315) DESCRIBE `ports` 0.0019369125366211
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00046801567077637
(317) DESCRIBE `ports` 0.0017731189727783
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00043606758117676
(319) DESCRIBE `ports` 0.0017540454864502
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00038909912109375
(321) DESCRIBE `ports` 0.0013887882232666
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00032997131347656
(323) DESCRIBE `ports` 0.0012950897216797
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00034713745117188
(325) DESCRIBE `ports` 0.0013999938964844
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00043106079101562
(327) DESCRIBE `ports` 0.0012760162353516
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00029492378234863
(329) DESCRIBE `ports` 0.0024130344390869
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003819465637207
(331) DESCRIBE `ports` 0.0016450881958008
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028491020202637
(333) DESCRIBE `ports` 0.0013909339904785
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00030708312988281
(335) DESCRIBE `ports` 0.0015661716461182
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.00034213066101074
(337) DESCRIBE `ports` 0.0013828277587891
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.001262903213501
(339) DESCRIBE `ports` 0.002000093460083
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00042200088500977
(341) DESCRIBE `ports` 0.0014269351959229
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00032997131347656
(343) DESCRIBE `ports` 0.0014288425445557
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00033807754516602
(345) DESCRIBE `cruises` 0.0026569366455078
(346) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82123))) 0.00051283836364746
(347) DESCRIBE `avid_specials` 0.00071001052856445
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534177 and class = 'Special') OR (item_id = 82123 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.001162052154541
(349) DESCRIBE `cruiselines` 0.0019571781158447
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00041913986206055
(351) DESCRIBE `orchid_image` 0.0016679763793945
(352) DESCRIBE `cruiselines` 0.0019609928131104
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0
(354) DESCRIBE `specials` 0.0040740966796875
(355) SELECT `specials`.* FROM `specials` WHERE (id = '1534178') AND (specials.orchid_available = 1) LIMIT 1 0.00053119659423828
(356) DESCRIBE `specials` 0.0041749477386475
(357) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534178') 0.0003669261932373
(358) DESCRIBE `ships` 0.0028190612792969
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00038599967956543
(360) DESCRIBE `ships` 0.0025880336761475
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00033807754516602
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047206878662109
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030207633972168
(364) DESCRIBE `itineraries` 0.0014500617980957
(365) DESCRIBE `ports` 0.0013790130615234
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00034880638122559
(367) DESCRIBE `ports` 0.002216100692749
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0
(369) DESCRIBE `ports` 0.0014400482177734
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00029897689819336
(371) DESCRIBE `specialsailingdates` 0.00027704238891602
(372) DESCRIBE `sailingdates` 0.0013670921325684
(373) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515643))) 0.00046491622924805
(374) DESCRIBE `sailingdates` 0.0011281967163086
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515644))) 0.00029516220092773
(376) DESCRIBE `sailingdates` 0.0011420249938965
(377) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515645))) 0.00028610229492188
(378) DESCRIBE `sailingdates` 0.0014889240264893
(379) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515650))) 0.00037789344787598
(380) DESCRIBE `sailingdates` 0.0015370845794678
(381) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515651))) 0.00030517578125
(382) DESCRIBE `sailingdates` 0.0014011859893799
(383) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515652))) 0.00038003921508789
(384) DESCRIBE `sailingdates` 0.0013999938964844
(385) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515653))) 0.00028705596923828
(386) DESCRIBE `sailingdates` 0.00052905082702637
(387) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515654))) 0.00030016899108887
(388) DESCRIBE `sailingdates` 0.0016570091247559
(389) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515659))) 0.00031876564025879
(390) DESCRIBE `sailingdates` 0.0012969970703125
(391) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515660))) 0.00032997131347656
(392) DESCRIBE `sailingdates` 0.001349925994873
(393) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515664))) 0.00031709671020508
(394) DESCRIBE `sailingdates` 0.001349925994873
(395) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515665))) 0.00030398368835449
(396) DESCRIBE `sailingdates` 0.0011401176452637
(397) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515666))) 0
(398) DESCRIBE `sailingdates` 0.0012500286102295
(399) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515667))) 0
(400) DESCRIBE `sailingdates` 0.0014691352844238
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515672))) 0.00040197372436523
(402) DESCRIBE `sailingdates` 0.0012412071228027
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515673))) 0.00030398368835449
(404) DESCRIBE `sailingdates` 0.0012569427490234
(405) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515674))) 0.00029897689819336
(406) DESCRIBE `sailingdates` 0.001176118850708
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515675))) 0.0002739429473877
(408) DESCRIBE `ports` 0.0013890266418457
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00033903121948242
(410) DESCRIBE `ports` 0.0015430450439453
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00029706954956055
(412) DESCRIBE `ports` 0.0013630390167236
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00030899047851562
(414) DESCRIBE `ports` 0.0010011196136475
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00027990341186523
(416) DESCRIBE `ports` 0.0012669563293457
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00030398368835449
(418) DESCRIBE `ports` 0.0014019012451172
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00027799606323242
(420) DESCRIBE `ports` 0.0013759136199951
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00032615661621094
(422) DESCRIBE `ports` 0.0014369487762451
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0
(424) DESCRIBE `ports` 0.0014891624450684
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00035691261291504
(426) DESCRIBE `ports` 0.001356840133667
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003049373626709
(428) DESCRIBE `ports` 0.0014150142669678
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00078916549682617
(430) DESCRIBE `ports` 0.0012757778167725
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00030398368835449
(432) DESCRIBE `ports` 0.0019810199737549
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.0001828670501709
(434) DESCRIBE `ports` 0.0013601779937744
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00027704238891602
(436) DESCRIBE `ports` 0.001460075378418
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00038504600524902
(438) DESCRIBE `ports` 0.0013420581817627
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00034403800964355
(440) DESCRIBE `ports` 0.0013670921325684
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00037980079650879
(442) DESCRIBE `ports` 0.0013880729675293
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.0003049373626709
(444) DESCRIBE `cruises` 0.0025041103363037
(445) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45864))) 0.0005340576171875
(446) DESCRIBE `avid_specials` 0.0012238025665283
(447) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534178 and class = 'Special') OR (item_id = 45864 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010581016540527
(448) DESCRIBE `cruiselines` 0.0018680095672607
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034308433532715
(450) DESCRIBE `orchid_image` 0.0023751258850098
(451) DESCRIBE `cruiselines` 0.0018720626831055
(452) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032496452331543
(453) DESCRIBE `specials` 0.0040631294250488
(454) SELECT `specials`.* FROM `specials` WHERE (id = '1534172') AND (specials.orchid_available = 1) LIMIT 1 0.00068116188049316
(455) DESCRIBE `specials` 0.0063509941101074
(456) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534172') 0.00045299530029297
(457) DESCRIBE `ships` 0.0030281543731689
(458) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00045204162597656
(459) DESCRIBE `ships` 0.0026040077209473
(460) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00034904479980469
(461) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027704238891602
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029611587524414
(463) DESCRIBE `itineraries` 0.0016269683837891
(464) DESCRIBE `ports` 0.0016069412231445
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00033903121948242
(466) DESCRIBE `ports` 0.0012691020965576
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00028896331787109
(468) DESCRIBE `ports` 0.0013439655303955
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00030207633972168
(470) DESCRIBE `specialsailingdates` 0.0011439323425293
(471) DESCRIBE `sailingdates` 0.0011560916900635
(472) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515298))) 0.00037598609924316
(473) DESCRIBE `ports` 0.00087881088256836
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00029587745666504
(475) DESCRIBE `ports` 0.0012581348419189
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00043606758117676
(477) DESCRIBE `ports` 0.0015668869018555
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00033688545227051
(479) DESCRIBE `ports` 0.001288890838623
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00027298927307129
(481) DESCRIBE `ports` 0.001291036605835
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029611587524414
(483) DESCRIBE `ports` 0.0012469291687012
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00027298927307129
(485) DESCRIBE `ports` 0.0011520385742188
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3413))) 0.00030994415283203
(487) DESCRIBE `ports` 0.0012619495391846
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3413') 0.00012993812561035
(489) DESCRIBE `ports` 0.0013830661773682
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00031208992004395
(491) DESCRIBE `ports` 0.0013530254364014
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.00029611587524414
(493) DESCRIBE `ports` 0.0012919902801514
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00030899047851562
(495) DESCRIBE `ports` 0.0012998580932617
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.00027894973754883
(497) DESCRIBE `ports` 0.0013830661773682
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1377))) 0.00041890144348145
(499) DESCRIBE `ports` 0.0013110637664795
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1377') 0.00028491020202637
(501) DESCRIBE `ports` 0.0012550354003906
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0
(503) DESCRIBE `ports` 0.0013039112091064
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.00030899047851562
(505) DESCRIBE `ports` 0.0012550354003906
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00032520294189453
(507) DESCRIBE `ports` 0.0013031959533691
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.001162052154541
(509) DESCRIBE `cruises` 0.0019080638885498
(510) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66763))) 0.0010449886322021
(511) DESCRIBE `avid_specials` 0.0011801719665527
(512) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534172 and class = 'Special') OR (item_id = 66763 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011520385742188
(513) DESCRIBE `cruiselines` 0.0018758773803711
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034499168395996
(515) DESCRIBE `orchid_image` 0.0015189647674561
(516) DESCRIBE `cruiselines` 0.0019831657409668
(517) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00030899047851562
(518) DESCRIBE `specials` 0.004558801651001
(519) SELECT `specials`.* FROM `specials` WHERE (id = '1534091') AND (specials.orchid_available = 1) LIMIT 1 0.00077295303344727
(520) DESCRIBE `specials` 0.0052628517150879
(521) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534091') 0.00046896934509277
(522) DESCRIBE `ships` 0.002655029296875
(523) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00039792060852051
(524) DESCRIBE `ships` 0.0025830268859863
(525) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00052809715270996
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031018257141113
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031208992004395
(528) DESCRIBE `itineraries` 0.001507043838501
(529) DESCRIBE `ports` 0.0013179779052734
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00034189224243164
(531) DESCRIBE `ports` 0.0013082027435303
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00029611587524414
(533) DESCRIBE `ports` 0.0014278888702393
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.0003058910369873
(535) DESCRIBE `specialsailingdates` 0.0010981559753418
(536) DESCRIBE `sailingdates` 0.001262903213501
(537) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515299))) 0.00035619735717773
(538) DESCRIBE `ports` 0.001323938369751
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00034904479980469
(540) DESCRIBE `ports` 0.0013611316680908
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.00028705596923828
(542) DESCRIBE `ports` 0.0012569427490234
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3416))) 0.00029993057250977
(544) DESCRIBE `ports` 0.0012509822845459
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3416') 0.00027108192443848
(546) DESCRIBE `ports` 0.0012450218200684
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3416))) 0.00039291381835938
(548) DESCRIBE `ports` 0.0012798309326172
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3416') 0.00028204917907715
(550) DESCRIBE `ports` 0.0012540817260742
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1377))) 0.00034499168395996
(552) DESCRIBE `ports` 0.0012660026550293
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1377') 0.00027298927307129
(554) DESCRIBE `ports` 0.0013411045074463
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00031590461730957
(556) DESCRIBE `ports` 0.001284122467041
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.00027179718017578
(558) DESCRIBE `ports` 0.0013599395751953
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1360))) 0.00029683113098145
(560) DESCRIBE `ports` 0.0013949871063232
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1360') 0.00033402442932129
(562) DESCRIBE `ports` 0.0012860298156738
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1369))) 0.00031805038452148
(564) DESCRIBE `ports` 0.0014228820800781
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1369') 0.00029397010803223
(566) DESCRIBE `ports` 0.00136399269104
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3411))) 0.00031590461730957
(568) DESCRIBE `ports` 0.0013349056243896
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3411') 0.0002739429473877
(570) DESCRIBE `ports` 0.00084209442138672
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 148))) 0.00032997131347656
(572) DESCRIBE `ports` 0.0014579296112061
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '148') 0.00027990341186523
(574) DESCRIBE `cruises` 0.0029470920562744
(575) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82065))) 0.00043892860412598
(576) DESCRIBE `avid_specials` 0.0011839866638184
(577) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534091 and class = 'Special') OR (item_id = 82065 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011618137359619
(578) DESCRIBE `cruiselines` 0.0021049976348877
(579) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00039911270141602
(580) DESCRIBE `orchid_image` 0.001511812210083
(581) DESCRIBE `cruiselines` 0.0015900135040283
(582) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032806396484375
(583) DESCRIBE `specials` 0.0044870376586914
(584) SELECT `specials`.* FROM `specials` WHERE (id = '1534168') AND (specials.orchid_available = 1) LIMIT 1 0.00064301490783691
(585) DESCRIBE `specials` 0.0042638778686523
(586) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534168') 0.00059390068054199
(587) DESCRIBE `ships` 0.0027680397033691
(588) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00034785270690918
(589) DESCRIBE `ships` 0.0030219554901123
(590) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00017189979553223
(591) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(592) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.001194953918457
(593) DESCRIBE `itineraries` 0.00085306167602539
(594) DESCRIBE `ports` 0.0017879009246826
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 148))) 0.00060105323791504
(596) DESCRIBE `ports` 0.0012710094451904
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 148))) 0.00037693977355957
(598) DESCRIBE `ports` 0.0018589496612549
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '148') 0.00039291381835938
(600) DESCRIBE `specialsailingdates` 0.0016281604766846
(601) DESCRIBE `sailingdates` 0.0016281604766846
(602) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515300))) 0.00042104721069336
(603) DESCRIBE `ports` 0.0016348361968994
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 148))) 0.00041413307189941
(605) DESCRIBE `ports` 0.0015110969543457
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '148') 0.0003821849822998
(607) DESCRIBE `ports` 0.0015358924865723
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 148))) 0.00042200088500977
(609) DESCRIBE `ports` 0.0014557838439941
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '148') 0.0003201961517334
(611) DESCRIBE `ports` 0.0015578269958496
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1360))) 0.00037598609924316
(613) DESCRIBE `ports` 0.0014998912811279
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1360') 0.00046491622924805
(615) DESCRIBE `ports` 0.0015668869018555
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00037193298339844
(617) DESCRIBE `ports` 0.0013449192047119
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.00033092498779297
(619) DESCRIBE `ports` 0.0015561580657959
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030899047851562
(621) DESCRIBE `ports` 0.0013830661773682
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00033712387084961
(623) DESCRIBE `ports` 0.0014820098876953
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4332))) 0.00041890144348145
(625) DESCRIBE `ports` 0.00099897384643555
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4332') 0.00031709671020508
(627) DESCRIBE `ports` 0.0014228820800781
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1368))) 0.00035810470581055
(629) DESCRIBE `ports` 0.0012960433959961
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1368') 0.00028300285339355
(631) DESCRIBE `ports` 0.0012931823730469
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1356))) 0.00029492378234863
(633) DESCRIBE `ports` 0.0012991428375244
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1356') 0.00028204917907715
(635) DESCRIBE `ports` 0.0012831687927246
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1353))) 0.00033092498779297
(637) DESCRIBE `ports` 0.0012390613555908
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1353') 0.00033092498779297
(639) DESCRIBE `cruises` 0.0025599002838135
(640) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67492))) 0.00049495697021484
(641) DESCRIBE `avid_specials` 0.0011599063873291
(642) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534168 and class = 'Special') OR (item_id = 67492 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0013689994812012
(643) DESCRIBE `cruiselines` 0.0022590160369873
(644) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0003659725189209
(645) DESCRIBE `orchid_image` 0.0015120506286621
(646) DESCRIBE `cruiselines` 0.0019540786743164
(647) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032496452331543
(648) DESCRIBE `specials` 0.0041370391845703
(649) SELECT `specials`.* FROM `specials` WHERE (id = '1534075') AND (specials.orchid_available = 1) LIMIT 1 0.00053596496582031
(650) DESCRIBE `specials` 0.0044338703155518
(651) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534075') 0.00040507316589355
(652) DESCRIBE `ships` 0.0026791095733643
(653) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00042891502380371
(654) DESCRIBE `ships` 0.0026140213012695
(655) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00047802925109863
(656) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016689300537109
(657) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0011789798736572
(658) DESCRIBE `itineraries` 0.0017480850219727
(659) DESCRIBE `ports` 0.0013980865478516
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00048303604125977
(661) DESCRIBE `ports` 0.0016539096832275
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00031018257141113
(663) DESCRIBE `ports` 0.00164794921875
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 2.598762512207E-5
(665) DESCRIBE `specialsailingdates` 0.00084900856018066
(666) DESCRIBE `sailingdates` 0.0017659664154053
(667) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515303))) 0.00042510032653809
(668) DESCRIBE `sailingdates` 0.0014188289642334
(669) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515321))) 0
(670) DESCRIBE `ports` 0.0015130043029785
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00031709671020508
(672) DESCRIBE `ports` 0.0012948513031006
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.00028800964355469
(674) DESCRIBE `ports` 0.0012750625610352
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3416))) 0.0011069774627686
(676) DESCRIBE `ports` 0.00074195861816406
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3416') 0.00029516220092773
(678) DESCRIBE `ports` 0.0012919902801514
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3416))) 0
(680) DESCRIBE `ports` 0.0013201236724854
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3416') 0.00028109550476074
(682) DESCRIBE `ports` 0.001521110534668
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1377))) 0.00033402442932129
(684) DESCRIBE `ports` 0.0014309883117676
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1377') 0.0002751350402832
(686) DESCRIBE `ports` 0.0021100044250488
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00044107437133789
(688) DESCRIBE `ports` 0.0018470287322998
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.00038313865661621
(690) DESCRIBE `ports` 0.001816987991333
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1360))) 0.0003960132598877
(692) DESCRIBE `ports` 0.0018138885498047
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1360') 0.00036096572875977
(694) DESCRIBE `ports` 0.00037503242492676
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3413))) 0.00039291381835938
(696) DESCRIBE `ports` 0.0016829967498779
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3413') 0.00031113624572754
(698) DESCRIBE `ports` 0.0013370513916016
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028514862060547
(700) DESCRIBE `ports` 0.0016088485717773
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00031781196594238
(702) DESCRIBE `ports` 0.0012819766998291
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030398368835449
(704) DESCRIBE `ports` 0.001244068145752
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00027203559875488
(706) DESCRIBE `cruises` 0.002626895904541
(707) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82068))) 0.00051498413085938
(708) DESCRIBE `avid_specials` 0.0012059211730957
(709) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534075 and class = 'Special') OR (item_id = 82068 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010101795196533
(710) DESCRIBE `cruiselines` 0.0018980503082275
(711) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00033211708068848
(712) DESCRIBE `orchid_image` 0.0013821125030518
(713) DESCRIBE `cruiselines` 0.0018041133880615
(714) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032901763916016
(715) DESCRIBE `specials` 0.0043160915374756
(716) SELECT `specials`.* FROM `specials` WHERE (id = '1534062') AND (specials.orchid_available = 1) LIMIT 1 0.00060009956359863
(717) DESCRIBE `specials` 0.0042920112609863
(718) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534062') 0.00041818618774414
(719) DESCRIBE `ships` 0.0031180381774902
(720) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00042104721069336
(721) DESCRIBE `ships` 0.0025918483734131
(722) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00030112266540527
(723) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026392936706543
(724) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025510787963867
(725) DESCRIBE `itineraries` 0.0012481212615967
(726) DESCRIBE `ports` 0.0014171600341797
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00036883354187012
(728) DESCRIBE `ports` 0.0012459754943848
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002901554107666
(730) DESCRIBE `ports` 0.001331090927124
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028014183044434
(732) DESCRIBE `specialsailingdates` 0.0010368824005127
(733) DESCRIBE `sailingdates` 0.001133918762207
(734) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515311))) 0.00032401084899902
(735) DESCRIBE `ports` 0.0012729167938232
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029993057250977
(737) DESCRIBE `ports` 0.0012350082397461
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028491020202637
(739) DESCRIBE `ports` 0.0012378692626953
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002892017364502
(741) DESCRIBE `ports` 0.0015630722045898
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028491020202637
(743) DESCRIBE `ports` 0.0014171600341797
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00032615661621094
(745) DESCRIBE `ports` 0.0012731552124023
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00034499168395996
(747) DESCRIBE `ports` 0.0014200210571289
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00033688545227051
(749) DESCRIBE `ports` 0.0015039443969727
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027704238891602
(751) DESCRIBE `ports` 0.0012369155883789
(752) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00029778480529785
(753) DESCRIBE `ports` 0.0013360977172852
(754) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00027799606323242
(755) DESCRIBE `ports` 0.0012331008911133
(756) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00030112266540527
(757) DESCRIBE `ports` 0.0021390914916992
(758) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027990341186523
(759) DESCRIBE `ports` 0.0012481212615967
(760) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028681755065918
(761) DESCRIBE `ports` 0.0013289451599121
(762) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0002739429473877
(763) DESCRIBE `ports` 0.001331090927124
(764) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028705596923828
(765) DESCRIBE `ports` 0.001317024230957
(766) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00026702880859375
(767) DESCRIBE `ports` 0.0012400150299072
(768) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00029087066650391
(769) DESCRIBE `ports` 0.0012421607971191
(770) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00027108192443848
(771) DESCRIBE `ports` 0.0012388229370117
(772) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028109550476074
(773) DESCRIBE `ports` 0.0013799667358398
(774) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00026702880859375
(775) DESCRIBE `ports` 0.0012309551239014
(776) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3413))) 0.00033402442932129
(777) DESCRIBE `ports` 0.0013971328735352
(778) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3413') 0.00033903121948242
(779) DESCRIBE `ports` 0.0012459754943848
(780) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00032401084899902
(781) DESCRIBE `ports` 0.0013020038604736
(782) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.0002751350402832
(783) DESCRIBE `ports` 0.001244068145752
(784) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1360))) 0.0003349781036377
(785) DESCRIBE `ports` 0.0013148784637451
(786) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1360') 0.0002748966217041
(787) DESCRIBE `ports` 0.0015010833740234
(788) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1369))) 0.00028181076049805
(789) DESCRIBE `ports` 0.0012362003326416
(790) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1369') 0.00026798248291016
(791) DESCRIBE `ports` 0.0013411045074463
(792) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 148))) 0.00035905838012695
(793) DESCRIBE `ports` 0.00124192237854
(794) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '148') 0.00027585029602051
(795) DESCRIBE `ports` 0.0012750625610352
(796) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3411))) 0.00034785270690918
(797) DESCRIBE `ports` 0.0013439655303955
(798) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3411') 0.00029587745666504
(799) DESCRIBE `ports` 0.0012550354003906
(800) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 149))) 0.00032305717468262
(801) DESCRIBE `ports` 0.0013070106506348
(802) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '149') 0.00027799606323242
(803) DESCRIBE `ports` 0.001460075378418
(804) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00037503242492676
(805) DESCRIBE `ports` 0.0012638568878174
(806) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00027585029602051
(807) DESCRIBE `ports` 0.0014569759368896
(808) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5305))) 0.00032401084899902
(809) DESCRIBE `ports` 0.0012590885162354
(810) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5305') 0.00036096572875977
(811) DESCRIBE `ports` 0.0013139247894287
(812) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 151))) 0.00030088424682617
(813) DESCRIBE `ports` 0.0012791156768799
(814) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '151') 0.00027799606323242
(815) DESCRIBE `ports` 0.0012719631195068
(816) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4329))) 0.00028491020202637
(817) DESCRIBE `ports` 0.0012481212615967
(818) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4329') 0.00027012825012207
(819) DESCRIBE `ports` 0.0012450218200684
(820) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1352))) 0.00029802322387695
(821) DESCRIBE `ports` 0.0012400150299072
(822) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1352') 0.00027894973754883
(823) DESCRIBE `ports` 0.0013370513916016
(824) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1352))) 0.00029802322387695
(825) DESCRIBE `ports` 0.0013120174407959
(826) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1352') 0.00028610229492188
(827) DESCRIBE `cruises` 0.0025501251220703
(828) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66651))) 0.00062012672424316
(829) DESCRIBE `avid_specials` 0.0012531280517578
(830) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534062 and class = 'Special') OR (item_id = 66651 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.001007080078125
(831) DESCRIBE `cruiselines` 0.0018589496612549
(832) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.000579833984375
(833) DESCRIBE `orchid_image` 0.001755952835083
(834) DESCRIBE `cruiselines` 0.0018141269683838
(835) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032711029052734
(836) DESCRIBE `ships` 0.0029120445251465
(837) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013')) ORDER BY FIND_IN_SET(id, '1163,1526,1013') 0.00071001052856445
(838) DESCRIBE `cruisetypes` 0.001154899597168
(839) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '212') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.028698921203613
(840) DESCRIBE `destinations` 0.0019559860229492
(841) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.0005340576171875
(842) DESCRIBE `cruiselines` 0.0018379688262939
(843) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00033688545227051
(844) DESCRIBE `cruiselines` 0.0018529891967773
(845) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034093856811523