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

Total elapsed time: 1.6609377861023

# Query Time
(1) connect 0.014464855194092
(2) DESCRIBE `cruises` 0.0053689479827881
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75760, 6056, 4425, 4424, 51215, 45258, 45259, 85799, 69292, 79285)) ORDER BY FIND_IN_SET(id, '75760,6056,4425,4424,51215,45258,45259,85799,69292,79285') 0.020856857299805
(4) DESCRIBE `specials` 0.0071330070495605
(5) DESCRIBE `specials` 0.0095818042755127
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1614189') 0.0014481544494629
(7) DESCRIBE `ships` 0.0060229301452637
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1723))) 0.021767854690552
(9) DESCRIBE `ships` 0.0055999755859375
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1723') 0.0041940212249756
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0038290023803711
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048613548278809
(13) DESCRIBE `itineraries` 0.0029311180114746
(14) DESCRIBE `ports` 0.014396905899048
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0012860298156738
(16) DESCRIBE `ports` 0.010679006576538
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.019028186798096
(18) DESCRIBE `ports` 0.0024311542510986
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00862717628479
(20) DESCRIBE `specialsailingdates` 0.0022039413452148
(21) DESCRIBE `sailingdates` 0.014055013656616
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 477415))) 0.0058999061584473
(23) DESCRIBE `ports` 0.0020229816436768
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0012750625610352
(25) DESCRIBE `ports` 0.0018711090087891
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0012710094451904
(27) DESCRIBE `ports` 0.010860919952393
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00051283836364746
(29) DESCRIBE `ports` 0.0020201206207275
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00046300888061523
(31) DESCRIBE `ports` 0.016869068145752
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.0005640983581543
(33) DESCRIBE `ports` 0.0020442008972168
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.0056939125061035
(35) DESCRIBE `ports` 0.0019960403442383
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00047492980957031
(37) DESCRIBE `ports` 0.0021798610687256
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00049400329589844
(39) DESCRIBE `ports` 0.0018320083618164
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00046586990356445
(41) DESCRIBE `ports` 0.0021600723266602
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00038909912109375
(43) DESCRIBE `ports` 0.0021328926086426
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0004880428314209
(45) DESCRIBE `ports` 0.0019090175628662
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00053596496582031
(47) DESCRIBE `ports` 0.0019121170043945
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00041413307189941
(49) DESCRIBE `ports` 0.0021381378173828
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00049996376037598
(51) DESCRIBE `ports` 0.002255916595459
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1022))) 0.0004270076751709
(53) DESCRIBE `ports` 0.0026228427886963
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1022') 0.00069594383239746
(55) DESCRIBE `ports` 0.0024518966674805
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00043010711669922
(57) DESCRIBE `ports` 0.0020341873168945
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00062298774719238
(59) DESCRIBE `ports` 0.0033941268920898
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00061297416687012
(61) DESCRIBE `ports` 0.0029661655426025
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00076889991760254
(63) DESCRIBE `ports` 0.002310037612915
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00054502487182617
(65) DESCRIBE `ports` 0.0021519660949707
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00054097175598145
(67) DESCRIBE `ports` 0.0022091865539551
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00059700012207031
(69) DESCRIBE `ports` 0.0031390190124512
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00091695785522461
(71) DESCRIBE `ports` 0.0036699771881104
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00096487998962402
(73) DESCRIBE `ports` 0.0032870769500732
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00065708160400391
(75) DESCRIBE `ports` 0.002608060836792
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00057077407836914
(77) DESCRIBE `ports` 0.0033152103424072
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00069189071655273
(79) DESCRIBE `ports` 0.0031239986419678
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00065398216247559
(81) DESCRIBE `ports` 0.0040271282196045
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00097894668579102
(83) DESCRIBE `cruises` 0.005950927734375
(84) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75760))) 0.0008089542388916
(85) DESCRIBE `avid_specials` 0.0024199485778809
(86) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1614189 and class = 'Special') OR (item_id = 75760 and class = 'Cruise') OR (item_id = 1723 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 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.0021839141845703
(87) DESCRIBE `cruiselines` 0.0033061504364014
(88) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.0068230628967285
(89) DESCRIBE `orchid_image` 0.0028290748596191
(90) DESCRIBE `cruiselines` 0.0071909427642822
(91) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00070619583129883
(92) DESCRIBE `specials` 0.0070960521697998
(93) DESCRIBE `specials` 0.0071160793304443
(94) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607893') 0.00068497657775879
(95) DESCRIBE `ships` 0.0047738552093506
(96) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00069999694824219
(97) DESCRIBE `ships` 0.0052180290222168
(98) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00068902969360352
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00050806999206543
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00051784515380859
(101) DESCRIBE `itineraries` 0.0033471584320068
(102) DESCRIBE `ports` 0.002324104309082
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00052404403686523
(104) DESCRIBE `ports` 0.0025238990783691
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00060701370239258
(106) DESCRIBE `ports` 0.0027091503143311
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0016770362854004
(108) DESCRIBE `specialsailingdates` 0.0024139881134033
(109) DESCRIBE `sailingdates` 0.0031628608703613
(110) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490541))) 0.00064301490783691
(111) DESCRIBE `sailingdates` 0.0021641254425049
(112) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490542))) 0.00048112869262695
(113) DESCRIBE `sailingdates` 0.0020380020141602
(114) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490543))) 0.00046896934509277
(115) DESCRIBE `sailingdates` 0.0019609928131104
(116) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490544))) 0.00045514106750488
(117) DESCRIBE `sailingdates` 0.002047061920166
(118) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490545))) 0.00058817863464355
(119) DESCRIBE `sailingdates` 0.0020439624786377
(120) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490546))) 0.00056695938110352
(121) DESCRIBE `sailingdates` 0.0023519992828369
(122) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490547))) 0.00050711631774902
(123) DESCRIBE `sailingdates` 0.0023009777069092
(124) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490548))) 0.00051021575927734
(125) DESCRIBE `sailingdates` 0.0023989677429199
(126) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490549))) 0.00044798851013184
(127) DESCRIBE `sailingdates` 0.0019600391387939
(128) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490550))) 0.00040388107299805
(129) DESCRIBE `sailingdates` 0.0017359256744385
(130) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490551))) 0.00053906440734863
(131) DESCRIBE `sailingdates` 0.00248122215271
(132) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490552))) 0.00059294700622559
(133) DESCRIBE `ports` 0.002896785736084
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0006411075592041
(135) DESCRIBE `ports` 0.0027651786804199
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00060606002807617
(137) DESCRIBE `ports` 0.0027539730072021
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00062203407287598
(139) DESCRIBE `ports` 0.0026969909667969
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00063395500183105
(141) DESCRIBE `ports` 0.0027401447296143
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00063896179199219
(143) DESCRIBE `ports` 0.0026872158050537
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00059199333190918
(145) DESCRIBE `ports` 0.0027809143066406
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00068092346191406
(147) DESCRIBE `ports` 0.0027830600738525
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00058507919311523
(149) DESCRIBE `ports` 0.0026829242706299
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00078296661376953
(151) DESCRIBE `ports` 0.0028340816497803
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00055599212646484
(153) DESCRIBE `ports` 0.0026850700378418
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0006709098815918
(155) DESCRIBE `ports` 0.0026021003723145
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00065088272094727
(157) DESCRIBE `ports` 0.0027289390563965
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00043201446533203
(159) DESCRIBE `ports` 0.0019540786743164
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00059103965759277
(161) DESCRIBE `ports` 0.0022609233856201
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00068306922912598
(163) DESCRIBE `ports` 0.0021510124206543
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040221214294434
(165) DESCRIBE `cruises` 0.0039868354797363
(166) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 6056))) 0.00069904327392578
(167) DESCRIBE `avid_specials` 0.0024960041046143
(168) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607893 and class = 'Special') OR (item_id = 6056 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 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.0022680759429932
(169) DESCRIBE `cruiselines` 0.0040938854217529
(170) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00088691711425781
(171) DESCRIBE `orchid_image` 0.00295090675354
(172) DESCRIBE `cruiselines` 0.0034680366516113
(173) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00054192543029785
(174) DESCRIBE `specials` 0.0067360401153564
(175) DESCRIBE `specials` 0.0074789524078369
(176) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607903') 0.00074505805969238
(177) DESCRIBE `ships` 0.010854959487915
(178) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.0007469654083252
(179) DESCRIBE `ships` 0.0053730010986328
(180) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00058603286743164
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00044894218444824
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00059700012207031
(183) DESCRIBE `itineraries` 0.0029060840606689
(184) DESCRIBE `ports` 0.0031721591949463
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00074601173400879
(186) DESCRIBE `ports` 0.0030050277709961
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00082588195800781
(188) DESCRIBE `ports` 0.0072929859161377
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00064706802368164
(190) DESCRIBE `specialsailingdates` 0.004194974899292
(191) DESCRIBE `sailingdates` 0.0027480125427246
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490508))) 0.00067901611328125
(193) DESCRIBE `sailingdates` 0.0026779174804688
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490509))) 0.0006248950958252
(195) DESCRIBE `sailingdates` 0.0028300285339355
(196) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490510))) 0.0006098747253418
(197) DESCRIBE `sailingdates` 0.0023250579833984
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490511))) 0.001082181930542
(199) DESCRIBE `sailingdates` 0.0021729469299316
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490512))) 0.00050902366638184
(201) DESCRIBE `sailingdates` 0.0024948120117188
(202) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490513))) 0.00056099891662598
(203) DESCRIBE `sailingdates` 0.0027360916137695
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490514))) 0.00072789192199707
(205) DESCRIBE `sailingdates` 0.0025420188903809
(206) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490515))) 0.0006871223449707
(207) DESCRIBE `sailingdates` 0.0026538372039795
(208) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490516))) 0.0006718635559082
(209) DESCRIBE `sailingdates` 0.0036568641662598
(210) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490517))) 0.00085902214050293
(211) DESCRIBE `sailingdates` 0.0028131008148193
(212) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490518))) 0.00058102607727051
(213) DESCRIBE `sailingdates` 0.0028159618377686
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490519))) 0.00076103210449219
(215) DESCRIBE `ports` 0.0034620761871338
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00072789192199707
(217) DESCRIBE `ports` 0.0030450820922852
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00093603134155273
(219) DESCRIBE `ports` 0.0036449432373047
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00083208084106445
(221) DESCRIBE `ports` 0.0028231143951416
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00056314468383789
(223) DESCRIBE `ports` 0.0028939247131348
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00075578689575195
(225) DESCRIBE `ports` 0.0028939247131348
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00081515312194824
(227) DESCRIBE `ports` 0.0029339790344238
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00054121017456055
(229) DESCRIBE `ports` 0.0020489692687988
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00047898292541504
(231) DESCRIBE `ports` 0.0026710033416748
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00067901611328125
(233) DESCRIBE `ports` 0.002500057220459
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00060296058654785
(235) DESCRIBE `cruises` 0.0054690837860107
(236) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 4425))) 0.00088191032409668
(237) DESCRIBE `avid_specials` 0.0022680759429932
(238) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607903 and class = 'Special') OR (item_id = 4425 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 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.0027298927307129
(239) DESCRIBE `cruiselines` 0.0044090747833252
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.001924991607666
(241) DESCRIBE `orchid_image` 0.0037791728973389
(242) DESCRIBE `cruiselines` 0.0044319629669189
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00098180770874023
(244) DESCRIBE `specials` 0.013280868530273
(245) DESCRIBE `specials` 0.0078108310699463
(246) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607913') 0.0010170936584473
(247) DESCRIBE `ships` 0.0051250457763672
(248) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00070381164550781
(249) DESCRIBE `ships` 0.0056331157684326
(250) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.001162052154541
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00049400329589844
(252) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00047111511230469
(253) DESCRIBE `itineraries` 0.0024330615997314
(254) DESCRIBE `ports` 0.0030040740966797
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00066590309143066
(256) DESCRIBE `ports` 0.0028529167175293
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0006561279296875
(258) DESCRIBE `ports` 0.0028200149536133
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00060296058654785
(260) DESCRIBE `specialsailingdates` 0.0021469593048096
(261) DESCRIBE `sailingdates` 0.0026259422302246
(262) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490475))) 0.00070786476135254
(263) DESCRIBE `sailingdates` 0.0024011135101318
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490472))) 0.00058698654174805
(265) DESCRIBE `sailingdates` 0.0036721229553223
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490476))) 0.00090718269348145
(267) DESCRIBE `sailingdates` 0.0028960704803467
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490475))) 0.00068807601928711
(269) DESCRIBE `sailingdates` 0.0025019645690918
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490472))) 0.00067806243896484
(271) DESCRIBE `sailingdates` 0.002655029296875
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490473))) 0.00058913230895996
(273) DESCRIBE `sailingdates` 0.0026710033416748
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490474))) 0.00063514709472656
(275) DESCRIBE `sailingdates` 0.0022151470184326
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490477))) 0.00064396858215332
(277) DESCRIBE `sailingdates` 0.0021650791168213
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490478))) 0.0005650520324707
(279) DESCRIBE `sailingdates` 0.0021669864654541
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490479))) 0.00058984756469727
(281) DESCRIBE `sailingdates` 0.0024449825286865
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490480))) 0.0010101795196533
(283) DESCRIBE `sailingdates` 0.0025901794433594
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490481))) 0.0006709098815918
(285) DESCRIBE `sailingdates` 0.0027239322662354
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490482))) 0.00097298622131348
(287) DESCRIBE `sailingdates` 0.0027680397033691
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490483))) 0.00065398216247559
(289) DESCRIBE `sailingdates` 0.0022881031036377
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490484))) 0.000579833984375
(291) DESCRIBE `sailingdates` 0.0022189617156982
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490485))) 0.00052595138549805
(293) DESCRIBE `sailingdates` 0.00201416015625
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490486))) 0.00062894821166992
(295) DESCRIBE `ports` 0.0024890899658203
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00064611434936523
(297) DESCRIBE `ports` 0.0023849010467529
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00057291984558105
(299) DESCRIBE `ports` 0.0024540424346924
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00066304206848145
(301) DESCRIBE `ports` 0.0027918815612793
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00070810317993164
(303) DESCRIBE `ports` 0.0029308795928955
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00073099136352539
(305) DESCRIBE `ports` 0.0026190280914307
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0010759830474854
(307) DESCRIBE `ports` 0.0032958984375
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0007321834564209
(309) DESCRIBE `ports` 0.002852201461792
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00055694580078125
(311) DESCRIBE `cruises` 0.004525899887085
(312) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 4424))) 0.00076508522033691
(313) DESCRIBE `avid_specials` 0.0021800994873047
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607913 and class = 'Special') OR (item_id = 4424 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 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.0021200180053711
(315) DESCRIBE `cruiselines` 0.0034580230712891
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.0006718635559082
(317) DESCRIBE `orchid_image` 0.0027840137481689
(318) DESCRIBE `cruiselines` 0.003950834274292
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00066590309143066
(320) DESCRIBE `specials` 0.0072078704833984
(321) DESCRIBE `specials` 0.0081291198730469
(322) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607863') 0.00069117546081543
(323) DESCRIBE `ships` 0.0048010349273682
(324) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00081396102905273
(325) DESCRIBE `ships` 0.0053009986877441
(326) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00073003768920898
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00050902366638184
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00050997734069824
(329) DESCRIBE `itineraries` 0.0024399757385254
(330) DESCRIBE `ports` 0.0025339126586914
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00062394142150879
(332) DESCRIBE `ports` 0.0037729740142822
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00080990791320801
(334) DESCRIBE `ports` 0.0027709007263184
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00063800811767578
(336) DESCRIBE `specialsailingdates` 0.0023519992828369
(337) DESCRIBE `sailingdates` 0.0023579597473145
(338) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490447))) 0.00061702728271484
(339) DESCRIBE `sailingdates` 0.0022928714752197
(340) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490448))) 0.00066399574279785
(341) DESCRIBE `ports` 0.0028388500213623
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0006721019744873
(343) DESCRIBE `ports` 0.0027480125427246
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00090789794921875
(345) DESCRIBE `ports` 0.0031650066375732
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 835))) 0.00070309638977051
(347) DESCRIBE `ports` 0.0032250881195068
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '835') 0.00077390670776367
(349) DESCRIBE `ports` 0.003018856048584
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5085))) 0.00071907043457031
(351) DESCRIBE `ports` 0.0031089782714844
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5085') 0.0015909671783447
(353) DESCRIBE `ports` 0.0029098987579346
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2954))) 0.00069499015808105
(355) DESCRIBE `ports` 0.0028870105743408
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2954') 0.00068902969360352
(357) DESCRIBE `ports` 0.0029239654541016
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2955))) 0.00075411796569824
(359) DESCRIBE `ports` 0.0028409957885742
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2955') 0.00071501731872559
(361) DESCRIBE `ports` 0.0029759407043457
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5086))) 0.00066804885864258
(363) DESCRIBE `ports` 0.0028750896453857
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5086') 0.0005950927734375
(365) DESCRIBE `ports` 0.0029098987579346
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5087))) 0.00083494186401367
(367) DESCRIBE `ports` 0.0033330917358398
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5087') 0.0006251335144043
(369) DESCRIBE `ports` 0.0032057762145996
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1337))) 0.00069808959960938
(371) DESCRIBE `ports` 0.0031580924987793
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1337') 0.0006721019744873
(373) DESCRIBE `ports` 0.0026781558990479
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5088))) 0.0006871223449707
(375) DESCRIBE `ports` 0.002716064453125
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5088') 0.00060200691223145
(377) DESCRIBE `ports` 0.0026609897613525
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3331))) 0.00065708160400391
(379) DESCRIBE `ports` 0.0028760433197021
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3331') 0.00071597099304199
(381) DESCRIBE `ports` 0.0026240348815918
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5089))) 0.00063419342041016
(383) DESCRIBE `ports` 0.0020608901977539
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5089') 0.00059986114501953
(385) DESCRIBE `ports` 0.002687931060791
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2467))) 0.00072908401489258
(387) DESCRIBE `ports` 0.0028989315032959
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2467') 0.00064706802368164
(389) DESCRIBE `ports` 0.0028760433197021
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00072288513183594
(391) DESCRIBE `ports` 0.0027430057525635
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00058698654174805
(393) DESCRIBE `cruises` 0.0049118995666504
(394) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 51215))) 0.00094318389892578
(395) DESCRIBE `avid_specials` 0.0025730133056641
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607863 and class = 'Special') OR (item_id = 51215 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 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.0023059844970703
(397) DESCRIBE `cruiselines` 0.0039079189300537
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00072598457336426
(399) DESCRIBE `orchid_image` 0.0029900074005127
(400) DESCRIBE `cruiselines` 0.003993034362793
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.0006709098815918
(402) DESCRIBE `specials` 0.0078592300415039
(403) DESCRIBE `specials` 0.0070130825042725
(404) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1623268') 0.00062894821166992
(405) DESCRIBE `ships` 0.0049700736999512
(406) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00096487998962402
(407) DESCRIBE `ships` 0.0056319236755371
(408) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00072789192199707
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0005040168762207
(410) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00047183036804199
(411) DESCRIBE `itineraries` 0.0028281211853027
(412) DESCRIBE `ports` 0.0029518604278564
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00082707405090332
(414) DESCRIBE `ports` 0.0027310848236084
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00069117546081543
(416) DESCRIBE `ports` 0.0028610229492188
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00071191787719727
(418) DESCRIBE `specialsailingdates` 0.0022821426391602
(419) DESCRIBE `sailingdates` 0.0025370121002197
(420) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504427))) 0.00077509880065918
(421) DESCRIBE `sailingdates` 0.0023038387298584
(422) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504428))) 0.00066304206848145
(423) DESCRIBE `sailingdates` 0.0023171901702881
(424) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504429))) 0.0006101131439209
(425) DESCRIBE `sailingdates` 0.0022180080413818
(426) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504430))) 0.00052905082702637
(427) DESCRIBE `sailingdates` 0.0023698806762695
(428) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504431))) 0.00053715705871582
(429) DESCRIBE `sailingdates` 0.0022900104522705
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504432))) 0.00054788589477539
(431) DESCRIBE `sailingdates` 0.0024600028991699
(432) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504433))) 0.00056600570678711
(433) DESCRIBE `sailingdates` 0.00217604637146
(434) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504434))) 0.00084495544433594
(435) DESCRIBE `sailingdates` 0.0027859210968018
(436) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504435))) 0.00085282325744629
(437) DESCRIBE `sailingdates` 0.002763032913208
(438) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504436))) 0.00070381164550781
(439) DESCRIBE `sailingdates` 0.0026929378509521
(440) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504437))) 0.0006561279296875
(441) DESCRIBE `sailingdates` 0.0026578903198242
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504438))) 0.00068998336791992
(443) DESCRIBE `sailingdates` 0.0027267932891846
(444) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504441))) 0.0006721019744873
(445) DESCRIBE `sailingdates` 0.0027041435241699
(446) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504442))) 0.00065016746520996
(447) DESCRIBE `sailingdates` 0.0027561187744141
(448) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504443))) 0.00065708160400391
(449) DESCRIBE `sailingdates` 0.0026049613952637
(450) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504444))) 0.00060200691223145
(451) DESCRIBE `ports` 0.002903938293457
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00062894821166992
(453) DESCRIBE `ports` 0.0027298927307129
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00066614151000977
(455) DESCRIBE `ports` 0.0027270317077637
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.0007169246673584
(457) DESCRIBE `ports` 0.0027720928192139
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.000518798828125
(459) DESCRIBE `ports` 0.0027740001678467
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00060796737670898
(461) DESCRIBE `ports` 0.0027589797973633
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00059700012207031
(463) DESCRIBE `ports` 0.0028438568115234
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00072097778320312
(465) DESCRIBE `ports` 0.0027539730072021
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00059795379638672
(467) DESCRIBE `ports` 0.0028071403503418
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00063014030456543
(469) DESCRIBE `ports` 0.0027890205383301
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00067901611328125
(471) DESCRIBE `ports` 0.0027439594268799
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00063896179199219
(473) DESCRIBE `ports` 0.0027551651000977
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0006248950958252
(475) DESCRIBE `ports` 0.00295090675354
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00063300132751465
(477) DESCRIBE `ports` 0.0029070377349854
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00055599212646484
(479) DESCRIBE `ports` 0.0027501583099365
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00064206123352051
(481) DESCRIBE `ports` 0.0027740001678467
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00055694580078125
(483) DESCRIBE `ports` 0.0027580261230469
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00066304206848145
(485) DESCRIBE `ports` 0.0026569366455078
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00054788589477539
(487) DESCRIBE `cruises` 0.005079984664917
(488) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45258))) 0.0007789134979248
(489) DESCRIBE `avid_specials` 0.0024960041046143
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1623268 and class = 'Special') OR (item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0018548965454102
(491) DESCRIBE `cruiselines` 0.0038750171661377
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00067400932312012
(493) DESCRIBE `orchid_image` 0.0030510425567627
(494) DESCRIBE `cruiselines` 0.0040891170501709
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00063705444335938
(496) DESCRIBE `specials` 0.0077319145202637
(497) DESCRIBE `specials` 0.0075640678405762
(498) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1623275') 0.00058603286743164
(499) DESCRIBE `ships` 0.0042629241943359
(500) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00065398216247559
(501) DESCRIBE `ships` 0.0041520595550537
(502) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00062203407287598
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042009353637695
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003349781036377
(505) DESCRIBE `itineraries` 0.0021040439605713
(506) DESCRIBE `ports` 0.0018589496612549
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00059604644775391
(508) DESCRIBE `ports` 0.0022969245910645
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00058913230895996
(510) DESCRIBE `ports` 0.0022587776184082
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00047802925109863
(512) DESCRIBE `specialsailingdates` 0.0016369819641113
(513) DESCRIBE `sailingdates` 0.0018310546875
(514) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504343))) 0.00041484832763672
(515) DESCRIBE `sailingdates` 0.0018100738525391
(516) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504344))) 0.00042104721069336
(517) DESCRIBE `sailingdates` 0.0016970634460449
(518) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504345))) 0.00038695335388184
(519) DESCRIBE `sailingdates` 0.0018010139465332
(520) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504346))) 0.00038981437683105
(521) DESCRIBE `sailingdates` 0.002047061920166
(522) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504347))) 0.0003960132598877
(523) DESCRIBE `sailingdates` 0.0015530586242676
(524) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504348))) 0.00048589706420898
(525) DESCRIBE `sailingdates` 0.0015480518341064
(526) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504349))) 0.00042510032653809
(527) DESCRIBE `sailingdates` 0.0022068023681641
(528) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504350))) 0.00049400329589844
(529) DESCRIBE `sailingdates` 0.002216100692749
(530) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504351))) 0.00047397613525391
(531) DESCRIBE `sailingdates` 0.002122163772583
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504352))) 0.00043582916259766
(533) DESCRIBE `sailingdates` 0.0019738674163818
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504353))) 0.00042510032653809
(535) DESCRIBE `sailingdates` 0.0016858577728271
(536) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504356))) 0.00036001205444336
(537) DESCRIBE `sailingdates` 0.002439022064209
(538) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504357))) 0.00049901008605957
(539) DESCRIBE `sailingdates` 0.0022709369659424
(540) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504358))) 0.00050592422485352
(541) DESCRIBE `sailingdates` 0.0024518966674805
(542) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504359))) 0.00050091743469238
(543) DESCRIBE `sailingdates` 0.0024240016937256
(544) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504360))) 0.00048494338989258
(545) DESCRIBE `ports` 0.002601146697998
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00058913230895996
(547) DESCRIBE `ports` 0.0025370121002197
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00051689147949219
(549) DESCRIBE `ports` 0.0027098655700684
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00067710876464844
(551) DESCRIBE `ports` 0.0020821094512939
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00059103965759277
(553) DESCRIBE `ports` 0.0025730133056641
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00053620338439941
(555) DESCRIBE `ports` 0.0024042129516602
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00040221214294434
(557) DESCRIBE `ports` 0.0023481845855713
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00062084197998047
(559) DESCRIBE `ports` 0.0020442008972168
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00053310394287109
(561) DESCRIBE `ports` 0.0023159980773926
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00050091743469238
(563) DESCRIBE `ports` 0.0017929077148438
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00049185752868652
(565) DESCRIBE `ports` 0.0020129680633545
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00041604042053223
(567) DESCRIBE `ports` 0.002018928527832
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00043678283691406
(569) DESCRIBE `cruises` 0.0034759044647217
(570) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00049591064453125
(571) DESCRIBE `avid_specials` 0.0016031265258789
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1623275 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.001251220703125
(573) DESCRIBE `cruiselines` 0.0029051303863525
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00046706199645996
(575) DESCRIBE `orchid_image` 0.0020339488983154
(576) DESCRIBE `cruiselines` 0.0027718544006348
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00039315223693848
(578) DESCRIBE `specials` 0.0050618648529053
(579) DESCRIBE `specials` 0.0076160430908203
(580) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1625169') 0.00071287155151367
(581) DESCRIBE `ships` 0.0055618286132812
(582) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 108))) 0.00090408325195312
(583) DESCRIBE `ships` 0.0058250427246094
(584) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '108') 0.0005340576171875
(585) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00061392784118652
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00041699409484863
(587) DESCRIBE `itineraries` 0.0023510456085205
(588) DESCRIBE `ports` 0.002377986907959
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00052189826965332
(590) DESCRIBE `ports` 0.0029568672180176
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0004889965057373
(592) DESCRIBE `ports` 0.0021488666534424
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00046896934509277
(594) DESCRIBE `specialsailingdates` 0.0018589496612549
(595) DESCRIBE `sailingdates` 0.0017781257629395
(596) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 539675))) 0.00058794021606445
(597) DESCRIBE `ports` 0.0023820400238037
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00047588348388672
(599) DESCRIBE `ports` 0.0020601749420166
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00051784515380859
(601) DESCRIBE `ports` 0.0023448467254639
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.0005500316619873
(603) DESCRIBE `ports` 0.0024259090423584
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00040888786315918
(605) DESCRIBE `ports` 0.0019919872283936
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 870))) 0.00044894218444824
(607) DESCRIBE `ports` 0.0022749900817871
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '870') 0.00047993659973145
(609) DESCRIBE `ports` 0.0028290748596191
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) 0.00092101097106934
(611) DESCRIBE `ports` 0.0029029846191406
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') 0.00063419342041016
(613) DESCRIBE `ports` 0.0027508735656738
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00063800811767578
(615) DESCRIBE `ports` 0.0027811527252197
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00071215629577637
(617) DESCRIBE `ports` 0.0029780864715576
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.0007479190826416
(619) DESCRIBE `ports` 0.0027029514312744
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00058221817016602
(621) DESCRIBE `ports` 0.0027730464935303
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0006248950958252
(623) DESCRIBE `ports` 0.0027132034301758
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00061607360839844
(625) DESCRIBE `ports` 0.0029799938201904
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00072908401489258
(627) DESCRIBE `ports` 0.0027210712432861
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00062179565429688
(629) DESCRIBE `cruises` 0.0051209926605225
(630) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 85799))) 0.00082707405090332
(631) DESCRIBE `avid_specials` 0.0025579929351807
(632) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1625169 and class = 'Special') OR (item_id = 85799 and class = 'Cruise') OR (item_id = 108 AND class = 'Ship') OR (item_id = 24 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.0025358200073242
(633) DESCRIBE `cruiselines` 0.0037710666656494
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00070691108703613
(635) DESCRIBE `orchid_image` 0.0026440620422363
(636) DESCRIBE `cruiselines` 0.0030691623687744
(637) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00041699409484863
(638) DESCRIBE `specials` 0.005479097366333
(639) DESCRIBE `specials` 0.0050699710845947
(640) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1621997') 0.00071597099304199
(641) DESCRIBE `ships` 0.0056338310241699
(642) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00090909004211426
(643) DESCRIBE `ships` 0.0053801536560059
(644) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.0006861686706543
(645) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005180835723877
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045084953308105
(647) DESCRIBE `itineraries` 0.0025901794433594
(648) DESCRIBE `ports` 0.0028128623962402
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071501731872559
(650) DESCRIBE `ports` 0.0020778179168701
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067901611328125
(652) DESCRIBE `ports` 0.0023338794708252
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050497055053711
(654) DESCRIBE `specialsailingdates` 0.0019509792327881
(655) DESCRIBE `sailingdates` 0.002187967300415
(656) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 478513))) 0.00060796737670898
(657) DESCRIBE `ports` 0.0028481483459473
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063085556030273
(659) DESCRIBE `ports` 0.0029370784759521
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059103965759277
(661) DESCRIBE `ports` 0.0027511119842529
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00071001052856445
(663) DESCRIBE `ports` 0.0028910636901855
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00069499015808105
(665) DESCRIBE `ports` 0.0026788711547852
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00048208236694336
(667) DESCRIBE `ports` 0.0019431114196777
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00041913986206055
(669) DESCRIBE `ports` 0.0021481513977051
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00060296058654785
(671) DESCRIBE `ports` 0.0025990009307861
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00062704086303711
(673) DESCRIBE `ports` 0.0027918815612793
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00058603286743164
(675) DESCRIBE `ports` 0.0020542144775391
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00052189826965332
(677) DESCRIBE `ports` 0.0045371055603027
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00051999092102051
(679) DESCRIBE `ports` 0.0022568702697754
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0004429817199707
(681) DESCRIBE `ports` 0.002126932144165
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00069904327392578
(683) DESCRIBE `ports` 0.0028078556060791
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00063109397888184
(685) DESCRIBE `ports` 0.002892017364502
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00068092346191406
(687) DESCRIBE `ports` 0.0046970844268799
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045394897460938
(689) DESCRIBE `cruises` 0.004666805267334
(690) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69292))) 0.00081801414489746
(691) DESCRIBE `avid_specials` 0.002051830291748
(692) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1621997 and class = 'Special') OR (item_id = 69292 and class = 'Cruise') OR (item_id = 1409 AND class = 'Ship') OR (item_id = 23 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.0015461444854736
(693) DESCRIBE `cruiselines` 0.0026988983154297
(694) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00066995620727539
(695) DESCRIBE `orchid_image` 0.002194881439209
(696) DESCRIBE `cruiselines` 0.0027158260345459
(697) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00044989585876465
(698) DESCRIBE `specials` 0.0078840255737305
(699) DESCRIBE `specials` 0.0078639984130859
(700) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1626238') 0.00082182884216309
(701) DESCRIBE `ships` 0.0057380199432373
(702) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00083112716674805
(703) DESCRIBE `ships` 0.0055849552154541
(704) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00066184997558594
(705) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00057387351989746
(706) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(707) DESCRIBE `itineraries` 0.0024349689483643
(708) DESCRIBE `ports` 0.0022091865539551
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049185752868652
(710) DESCRIBE `ports` 0.0018320083618164
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054407119750977
(712) DESCRIBE `ports` 0.0025250911712646
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046610832214355
(714) DESCRIBE `specialsailingdates` 0.0016210079193115
(715) DESCRIBE `sailingdates` 0.0017311573028564
(716) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 492461))) 0.00044083595275879
(717) DESCRIBE `ports` 0.0021719932556152
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046491622924805
(719) DESCRIBE `ports` 0.0028829574584961
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00060009956359863
(721) DESCRIBE `ports` 0.0026519298553467
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00085687637329102
(723) DESCRIBE `ports` 0.0026988983154297
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0005950927734375
(725) DESCRIBE `ports` 0.002734899520874
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00060796737670898
(727) DESCRIBE `ports` 0.0027279853820801
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00053215026855469
(729) DESCRIBE `ports` 0.0026769638061523
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00063490867614746
(731) DESCRIBE `ports` 0.0026421546936035
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0005490779876709
(733) DESCRIBE `ports` 0.0024340152740479
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0005338191986084
(735) DESCRIBE `ports` 0.0023829936981201
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00055408477783203
(737) DESCRIBE `ports` 0.0026249885559082
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00066590309143066
(739) DESCRIBE `ports` 0.0023729801177979
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00055885314941406
(741) DESCRIBE `ports` 0.002277135848999
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00057315826416016
(743) DESCRIBE `ports` 0.0022799968719482
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00052809715270996
(745) DESCRIBE `ports` 0.0023858547210693
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00056886672973633
(747) DESCRIBE `ports` 0.0022149085998535
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00050497055053711
(749) DESCRIBE `ports` 0.0022799968719482
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00052905082702637
(751) DESCRIBE `ports` 0.0022468566894531
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00049495697021484
(753) DESCRIBE `ports` 0.0022239685058594
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.0005338191986084
(755) DESCRIBE `ports` 0.0022008419036865
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00048303604125977
(757) DESCRIBE `ports` 0.0023059844970703
(758) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056695938110352
(759) DESCRIBE `ports` 0.00217604637146
(760) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006260871887207
(761) DESCRIBE `cruises` 0.0037860870361328
(762) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79285))) 0.00060105323791504
(763) DESCRIBE `avid_specials` 0.0021190643310547
(764) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1626238 and class = 'Special') OR (item_id = 79285 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 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.0015590190887451
(765) DESCRIBE `cruiselines` 0.0027120113372803
(766) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0004880428314209
(767) DESCRIBE `orchid_image` 0.0026178359985352
(768) DESCRIBE `cruiselines` 0.0026960372924805
(769) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00054407119750977
(770) DESCRIBE `cruiselines` 0.0031728744506836
(771) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('216', '23', '47', '33', '14', '20', '26', '151', '19', '15', '91', '8', '29', '101', '96', '114', '24', '18', '180')) ORDER BY FIND_IN_SET(id, '216,23,47,33,14,20,26,151,19,15,91,8,29,101,96,114,24,18,180') 0.002284049987793
(772) DESCRIBE `ships` 0.0040981769561768
(773) SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '66', '1282', '780', '148', '652', '1409', '1766', '124', '290', '332', '349', '448', '542', '585', '616', '966', '1021', '1159', '1672', '160', '163', '286', '291', '404', '434', '580', '766', '776', '1088', '1193', '1319', '1321', '1330', '1359', '1569', '1746', '45', '98', '105', '108', '149', '253', '262', '285', '287', '338', '341', '389', '394', '406', '422', '508', '547', '553', '674', '678', '683', '726', '738', '748', '768', '769', '770', '907', '968', '1028', '1029', '1073', '1108', '1135', '1157', '1283', '1318', '1415', '1587', '1721', '1723')) ORDER BY FIND_IN_SET(id, '855,517,66,1282,780,148,652,1409,1766,124,290,332,349,448,542,585,616,966,1021,1159,1672,160,163,286,291,404,434,580,766,776,1088,1193,1319,1321,1330,1359,1569,1746,45,98,105,108,149,253,262,285,287,338,341,389,394,406,422,508,547,553,674,678,683,726,738,748,768,769,770,907,968,1028,1029,1073,1108,1135,1157,1283,1318,1415,1587,1721,1723') 0.014824151992798
(774) DESCRIBE `cruisetypes` 0.0017528533935547
(775) DESCRIBE `destinations` 0.0025811195373535
(776) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '50', '12', '26', '25', '8', '48', '49', '29', '40', '53', '11', '28', '34', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,50,12,26,25,8,48,49,29,40,53,11,28,34,37') 0.0020520687103271