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

Total elapsed time: 0.92618632316589

# Query Time
(1) connect 0.00098705291748047
(2) DESCRIBE `cruises` 0.0042760372161865
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76244, 76256, 76242, 86499, 69292, 69292, 76235, 76235, 76259, 76259)) ORDER BY FIND_IN_SET(id, '76244,76256,76242,86499,69292,69292,76235,76235,76259,76259') 0.0017130374908447
(4) DESCRIBE `cruises` 0.0037381649017334
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76244') 0.00043606758117676
(6) DESCRIBE `ships` 0.0047500133514404
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00064706802368164
(8) DESCRIBE `ships` 0.0040528774261475
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00053906440734863
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054097175598145
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041604042053223
(12) DESCRIBE `itineraries` 0.0027639865875244
(13) DESCRIBE `ports` 0.0030901432037354
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066900253295898
(15) DESCRIBE `ports` 0.0026998519897461
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005800724029541
(17) DESCRIBE `ports` 0.0026309490203857
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056982040405273
(19) DESCRIBE `sailingdates` 0.0024588108062744
(20) DESCRIBE `ports` 0.0028660297393799
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006110668182373
(22) DESCRIBE `ports` 0.0027048587799072
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055694580078125
(24) DESCRIBE `ports` 0.0027267932891846
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0007021427154541
(26) DESCRIBE `ports` 0.0029342174530029
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00059890747070312
(28) DESCRIBE `ports` 0.0020749568939209
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00041818618774414
(30) DESCRIBE `ports` 0.0017640590667725
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00037503242492676
(32) DESCRIBE `ports` 0.0017900466918945
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0004730224609375
(34) DESCRIBE `ports` 0.0019409656524658
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00042295455932617
(36) DESCRIBE `ports` 0.0020990371704102
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00042295455932617
(38) DESCRIBE `ports` 0.0019099712371826
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00038003921508789
(40) DESCRIBE `ports` 0.0017788410186768
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00048518180847168
(42) DESCRIBE `ports` 0.002129077911377
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00040698051452637
(44) DESCRIBE `ports` 0.0028791427612305
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0007469654083252
(46) DESCRIBE `ports` 0.0019948482513428
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046300888061523
(48) DESCRIBE `ports` 0.00187087059021
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00047111511230469
(50) DESCRIBE `ports` 0.0018651485443115
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00042605400085449
(52) DESCRIBE `ports` 0.0019791126251221
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049710273742676
(54) DESCRIBE `ports` 0.0019087791442871
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056695938110352
(56) DESCRIBE `avid_specials` 0.0026240348815918
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76244 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.0021910667419434
(58) DESCRIBE `cruiselines` 0.0039219856262207
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00066184997558594
(60) DESCRIBE `orchid_image` 0.0023918151855469
(61) DESCRIBE `cruiselines` 0.002514123916626
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00042104721069336
(63) DESCRIBE `cruises` 0.0036590099334717
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76256') 0.00039410591125488
(65) DESCRIBE `ships` 0.0037100315093994
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00059604644775391
(67) DESCRIBE `ships` 0.0035989284515381
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00050210952758789
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(71) DESCRIBE `itineraries` 0.0018270015716553
(72) DESCRIBE `ports` 0.0027868747711182
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066399574279785
(74) DESCRIBE `ports` 0.0022330284118652
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049710273742676
(76) DESCRIBE `ports` 0.0017728805541992
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040483474731445
(78) DESCRIBE `sailingdates` 0.0016379356384277
(79) DESCRIBE `ports` 0.0018539428710938
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060701370239258
(81) DESCRIBE `ports` 0.0019898414611816
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039410591125488
(83) DESCRIBE `ports` 0.0018880367279053
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00048422813415527
(85) DESCRIBE `ports` 0.0018579959869385
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00038814544677734
(87) DESCRIBE `ports` 0.0018899440765381
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00053286552429199
(89) DESCRIBE `ports` 0.0019979476928711
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00037598609924316
(91) DESCRIBE `ports` 0.0021660327911377
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00060796737670898
(93) DESCRIBE `ports` 0.0020418167114258
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00038695335388184
(95) DESCRIBE `ports` 0.0019948482513428
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00056982040405273
(97) DESCRIBE `ports` 0.0020029544830322
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00057482719421387
(99) DESCRIBE `ports` 0.0017940998077393
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00043201446533203
(101) DESCRIBE `ports` 0.0018200874328613
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00043392181396484
(103) DESCRIBE `ports` 0.0020439624786377
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00062704086303711
(105) DESCRIBE `ports` 0.0026378631591797
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00047492980957031
(107) DESCRIBE `ports` 0.0025060176849365
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00065183639526367
(109) DESCRIBE `ports` 0.0020298957824707
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00042009353637695
(111) DESCRIBE `ports` 0.0019259452819824
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041103363037109
(113) DESCRIBE `ports` 0.0017390251159668
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003659725189209
(115) DESCRIBE `avid_specials` 0.0015649795532227
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76256 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.0024230480194092
(117) DESCRIBE `cruiselines` 0.0041759014129639
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00063490867614746
(119) DESCRIBE `orchid_image` 0.003026008605957
(120) DESCRIBE `cruiselines` 0.0042150020599365
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00080299377441406
(122) DESCRIBE `cruises` 0.0053260326385498
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76242') 0.00061702728271484
(124) DESCRIBE `ships` 0.0053789615631104
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.0007169246673584
(126) DESCRIBE `ships` 0.0056328773498535
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00056195259094238
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043606758117676
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049495697021484
(130) DESCRIBE `itineraries` 0.0025579929351807
(131) DESCRIBE `ports` 0.0025789737701416
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00068402290344238
(133) DESCRIBE `ports` 0.0025618076324463
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061202049255371
(135) DESCRIBE `ports` 0.0027720928192139
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00063896179199219
(137) DESCRIBE `sailingdates` 0.0022921562194824
(138) DESCRIBE `ports` 0.0026469230651855
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067520141601562
(140) DESCRIBE `ports` 0.0030109882354736
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00065898895263672
(142) DESCRIBE `ports` 0.0020589828491211
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043606758117676
(144) DESCRIBE `ports` 0.0018460750579834
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0003809928894043
(146) DESCRIBE `ports` 0.0019679069519043
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00070691108703613
(148) DESCRIBE `ports` 0.0022151470184326
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00043797492980957
(150) DESCRIBE `ports` 0.0020971298217773
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00057601928710938
(152) DESCRIBE `ports` 0.002554178237915
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00068998336791992
(154) DESCRIBE `ports` 0.0025417804718018
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00063991546630859
(156) DESCRIBE `ports` 0.0022580623626709
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00041699409484863
(158) DESCRIBE `ports` 0.0019609928131104
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00048589706420898
(160) DESCRIBE `ports` 0.0018608570098877
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00039196014404297
(162) DESCRIBE `ports` 0.0020151138305664
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045394897460938
(164) DESCRIBE `ports` 0.0018329620361328
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040507316589355
(166) DESCRIBE `avid_specials` 0.002100944519043
(167) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76242 and class = 'Cruise') OR (item_id = 1409 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016849040985107
(168) DESCRIBE `cruiselines` 0.0026280879974365
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00057888031005859
(170) DESCRIBE `orchid_image` 0.002694845199585
(171) DESCRIBE `cruiselines` 0.0039889812469482
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00063180923461914
(173) DESCRIBE `cruises` 0.0046169757843018
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '86499') 0.00053596496582031
(175) DESCRIBE `ships` 0.0035519599914551
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00055789947509766
(177) DESCRIBE `ships` 0.0038309097290039
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.0004889965057373
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035810470581055
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(181) DESCRIBE `itineraries` 0.0019040107727051
(182) DESCRIBE `ports` 0.0027520656585693
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059103965759277
(184) DESCRIBE `ports` 0.0020298957824707
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054502487182617
(186) DESCRIBE `ports` 0.0019378662109375
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041317939758301
(188) DESCRIBE `sailingdates` 0.0017039775848389
(189) DESCRIBE `ports` 0.0020499229431152
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059103965759277
(191) DESCRIBE `ports` 0.0022940635681152
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043392181396484
(193) DESCRIBE `ports` 0.001884937286377
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046396255493164
(195) DESCRIBE `ports` 0.0019030570983887
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040411949157715
(197) DESCRIBE `ports` 0.0018689632415771
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1683))) 0.00065517425537109
(199) DESCRIBE `ports` 0.0023109912872314
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1683') 0.00045895576477051
(201) DESCRIBE `ports` 0.0017518997192383
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00049209594726562
(203) DESCRIBE `ports` 0.0023159980773926
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00038695335388184
(205) DESCRIBE `ports` 0.0018520355224609
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00043606758117676
(207) DESCRIBE `ports` 0.0019361972808838
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.0005030632019043
(209) DESCRIBE `ports` 0.0018301010131836
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043916702270508
(211) DESCRIBE `ports` 0.001945972442627
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041294097900391
(213) DESCRIBE `avid_specials` 0.0015759468078613
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 86499 and class = 'Cruise') OR (item_id = 1409 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011460781097412
(215) DESCRIBE `cruiselines` 0.0029919147491455
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00047111511230469
(217) DESCRIBE `orchid_image` 0.0026860237121582
(218) DESCRIBE `cruiselines` 0.0028460025787354
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00039196014404297
(220) DESCRIBE `specials` 0.0067808628082275
(221) DESCRIBE `specials` 0.010030031204224
(222) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1621997') 0.00071597099304199
(223) DESCRIBE `ships` 0.0054440498352051
(224) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00082015991210938
(225) DESCRIBE `ships` 0.006162166595459
(226) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00051093101501465
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(229) DESCRIBE `itineraries` 0.0018949508666992
(230) DESCRIBE `ports` 0.0021719932556152
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005488395690918
(232) DESCRIBE `ports` 0.0019240379333496
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044488906860352
(234) DESCRIBE `ports` 0.0020179748535156
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043010711669922
(236) DESCRIBE `specialsailingdates` 0.0017800331115723
(237) DESCRIBE `sailingdates` 0.0015900135040283
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 478513))) 0.00053811073303223
(239) DESCRIBE `ports` 0.0017790794372559
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054216384887695
(241) DESCRIBE `ports` 0.0019629001617432
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004570484161377
(243) DESCRIBE `ports` 0.0020220279693604
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00057101249694824
(245) DESCRIBE `ports` 0.0024449825286865
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00063300132751465
(247) DESCRIBE `ports` 0.0028600692749023
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00065016746520996
(249) DESCRIBE `ports` 0.0022878646850586
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00059914588928223
(251) DESCRIBE `ports` 0.0021529197692871
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00073003768920898
(253) DESCRIBE `ports` 0.0021870136260986
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00063204765319824
(255) DESCRIBE `ports` 0.0023980140686035
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00059890747070312
(257) DESCRIBE `ports` 0.0021040439605713
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00063204765319824
(259) DESCRIBE `ports` 0.0019900798797607
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00045895576477051
(261) DESCRIBE `ports` 0.0023078918457031
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00049281120300293
(263) DESCRIBE `ports` 0.0024750232696533
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00063586235046387
(265) DESCRIBE `ports` 0.0026388168334961
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00055885314941406
(267) DESCRIBE `ports` 0.0021889209747314
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004880428314209
(269) DESCRIBE `ports` 0.0021178722381592
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041985511779785
(271) DESCRIBE `cruises` 0.0051391124725342
(272) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69292))) 0.00078010559082031
(273) DESCRIBE `avid_specials` 0.0024747848510742
(274) 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.0019838809967041
(275) DESCRIBE `cruiselines` 0.0033400058746338
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00057482719421387
(277) DESCRIBE `orchid_image` 0.0029561519622803
(278) DESCRIBE `cruiselines` 0.0036981105804443
(279) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00057387351989746
(280) DESCRIBE `cruises` 0.0049118995666504
(281) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69292') 0.00056099891662598
(282) DESCRIBE `ships` 0.0037069320678711
(283) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00057601928710938
(284) DESCRIBE `ships` 0.0035779476165771
(285) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00049805641174316
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037693977355957
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036215782165527
(288) DESCRIBE `itineraries` 0.0018799304962158
(289) DESCRIBE `ports` 0.0019268989562988
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047397613525391
(291) DESCRIBE `ports` 0.0018990039825439
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(293) DESCRIBE `ports` 0.0019049644470215
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040316581726074
(295) DESCRIBE `sailingdates` 0.0018928050994873
(296) DESCRIBE `ports` 0.0018758773803711
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052690505981445
(298) DESCRIBE `ports` 0.0021040439605713
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042414665222168
(300) DESCRIBE `ports` 0.0020608901977539
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046110153198242
(302) DESCRIBE `ports` 0.0021140575408936
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00053906440734863
(304) DESCRIBE `ports` 0.0021359920501709
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00048208236694336
(306) DESCRIBE `ports` 0.0019409656524658
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00047516822814941
(308) DESCRIBE `ports` 0.002100944519043
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00052094459533691
(310) DESCRIBE `ports` 0.0020110607147217
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00041007995605469
(312) DESCRIBE `ports` 0.002371072769165
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00048398971557617
(314) DESCRIBE `ports` 0.0020840167999268
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00048279762268066
(316) DESCRIBE `ports` 0.0023598670959473
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00052595138549805
(318) DESCRIBE `ports` 0.0022509098052979
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00043892860412598
(320) DESCRIBE `ports` 0.0024290084838867
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0004730224609375
(322) DESCRIBE `ports` 0.0023939609527588
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00052809715270996
(324) DESCRIBE `ports` 0.0020461082458496
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00058603286743164
(326) DESCRIBE `ports` 0.0019888877868652
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040292739868164
(328) DESCRIBE `avid_specials` 0.0019130706787109
(329) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0012819766998291
(330) DESCRIBE `cruiselines` 0.0029709339141846
(331) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0004889965057373
(332) DESCRIBE `orchid_image` 0.0021510124206543
(333) DESCRIBE `cruiselines` 0.002504825592041
(334) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00048494338989258
(335) DESCRIBE `specials` 0.0049788951873779
(336) DESCRIBE `specials` 0.005742073059082
(337) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1616831') 0.00047397613525391
(338) DESCRIBE `ships` 0.0046398639678955
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00073719024658203
(340) DESCRIBE `ships` 0.0054128170013428
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.0006868839263916
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053501129150391
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005340576171875
(344) DESCRIBE `itineraries` 0.0028231143951416
(345) DESCRIBE `ports` 0.002357006072998
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00059700012207031
(347) DESCRIBE `ports` 0.0027320384979248
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054311752319336
(349) DESCRIBE `ports` 0.0025200843811035
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00054097175598145
(351) DESCRIBE `specialsailingdates` 0.0022268295288086
(352) DESCRIBE `sailingdates` 0.0025298595428467
(353) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 478486))) 0.0007011890411377
(354) DESCRIBE `ports` 0.0028049945831299
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00074195861816406
(356) DESCRIBE `ports` 0.0028150081634521
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00057411193847656
(358) DESCRIBE `ports` 0.002830982208252
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00066685676574707
(360) DESCRIBE `ports` 0.0027451515197754
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0006108283996582
(362) DESCRIBE `ports` 0.0028810501098633
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00063109397888184
(364) DESCRIBE `ports` 0.0027110576629639
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00058102607727051
(366) DESCRIBE `ports` 0.0027861595153809
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00064301490783691
(368) DESCRIBE `ports` 0.0027840137481689
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00055503845214844
(370) DESCRIBE `ports` 0.0026919841766357
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00060796737670898
(372) DESCRIBE `ports` 0.0027499198913574
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00055480003356934
(374) DESCRIBE `ports` 0.0027849674224854
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00069689750671387
(376) DESCRIBE `ports` 0.0022759437561035
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00056195259094238
(378) DESCRIBE `ports` 0.0022439956665039
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00069499015808105
(380) DESCRIBE `ports` 0.0022377967834473
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00060701370239258
(382) DESCRIBE `ports` 0.0022838115692139
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066089630126953
(384) DESCRIBE `ports` 0.0027458667755127
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00069785118103027
(386) DESCRIBE `cruises` 0.0051989555358887
(387) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 76235))) 0.00076389312744141
(388) DESCRIBE `avid_specials` 0.0031001567840576
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1616831 and class = 'Special') OR (item_id = 76235 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.0023219585418701
(390) DESCRIBE `cruiselines` 0.0040850639343262
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00069093704223633
(392) DESCRIBE `orchid_image` 0.003040075302124
(393) DESCRIBE `cruiselines` 0.003917932510376
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00061607360839844
(395) DESCRIBE `cruises` 0.0050280094146729
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76235') 0.00072884559631348
(397) DESCRIBE `ships` 0.0053560733795166
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00094008445739746
(399) DESCRIBE `ships` 0.0044898986816406
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00073695182800293
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055694580078125
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048494338989258
(403) DESCRIBE `itineraries` 0.00205397605896
(404) DESCRIBE `ports` 0.0019471645355225
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00048589706420898
(406) DESCRIBE `ports` 0.0019831657409668
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042319297790527
(408) DESCRIBE `ports` 0.0018501281738281
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0004580020904541
(410) DESCRIBE `sailingdates` 0.0015709400177002
(411) DESCRIBE `ports` 0.0019590854644775
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047802925109863
(413) DESCRIBE `ports` 0.001943826675415
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046586990356445
(415) DESCRIBE `ports` 0.0023608207702637
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00042605400085449
(417) DESCRIBE `ports` 0.002032995223999
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00038504600524902
(419) DESCRIBE `ports` 0.0018398761749268
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00041604042053223
(421) DESCRIBE `ports` 0.001755952835083
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037908554077148
(423) DESCRIBE `ports` 0.0021440982818604
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00066995620727539
(425) DESCRIBE `ports` 0.0023188591003418
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00053000450134277
(427) DESCRIBE `ports` 0.002000093460083
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00043988227844238
(429) DESCRIBE `ports` 0.0018999576568604
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00047612190246582
(431) DESCRIBE `ports` 0.0018880367279053
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00045299530029297
(433) DESCRIBE `ports` 0.0020010471343994
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0003960132598877
(435) DESCRIBE `ports` 0.0024228096008301
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051999092102051
(437) DESCRIBE `ports` 0.0025990009307861
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00063180923461914
(439) DESCRIBE `ports` 0.0022339820861816
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00068998336791992
(441) DESCRIBE `ports` 0.0025949478149414
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00067901611328125
(443) DESCRIBE `avid_specials` 0.0025320053100586
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76235 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.0011930465698242
(445) DESCRIBE `cruiselines` 0.0026938915252686
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00049901008605957
(447) DESCRIBE `orchid_image` 0.0021898746490479
(448) DESCRIBE `cruiselines` 0.0028889179229736
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00048303604125977
(450) DESCRIBE `specials` 0.0050649642944336
(451) DESCRIBE `specials` 0.0049350261688232
(452) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1616836') 0.00048303604125977
(453) DESCRIBE `ships` 0.0039849281311035
(454) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00060105323791504
(455) DESCRIBE `ships` 0.0038409233093262
(456) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00057101249694824
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040578842163086
(459) DESCRIBE `itineraries` 0.001878023147583
(460) DESCRIBE `ports` 0.0021939277648926
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046515464782715
(462) DESCRIBE `ports` 0.0019099712371826
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043916702270508
(464) DESCRIBE `ports` 0.0019280910491943
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040698051452637
(466) DESCRIBE `specialsailingdates` 0.0016410350799561
(467) DESCRIBE `sailingdates` 0.0028450489044189
(468) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 478516))) 0.00048398971557617
(469) DESCRIBE `ports` 0.0018351078033447
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048708915710449
(471) DESCRIBE `ports` 0.0022768974304199
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055098533630371
(473) DESCRIBE `ports` 0.0024209022521973
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00049710273742676
(475) DESCRIBE `ports` 0.002039909362793
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00047492980957031
(477) DESCRIBE `ports` 0.0018351078033447
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00044703483581543
(479) DESCRIBE `ports` 0.0019071102142334
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00040602684020996
(481) DESCRIBE `ports` 0.0018489360809326
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00046515464782715
(483) DESCRIBE `ports` 0.0019290447235107
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00040102005004883
(485) DESCRIBE `ports` 0.001957893371582
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00060105323791504
(487) DESCRIBE `ports` 0.00180983543396
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00040888786315918
(489) DESCRIBE `ports` 0.0018539428710938
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00041604042053223
(491) DESCRIBE `ports` 0.0019798278808594
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00037193298339844
(493) DESCRIBE `ports` 0.0018630027770996
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00049400329589844
(495) DESCRIBE `ports` 0.0017721652984619
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00038814544677734
(497) DESCRIBE `ports` 0.0019271373748779
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00041294097900391
(499) DESCRIBE `ports` 0.0017950534820557
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00037407875061035
(501) DESCRIBE `ports` 0.0017659664154053
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051593780517578
(503) DESCRIBE `ports` 0.0017549991607666
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003809928894043
(505) DESCRIBE `cruises` 0.003371000289917
(506) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 76259))) 0.0005030632019043
(507) DESCRIBE `avid_specials` 0.0015711784362793
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1616836 and class = 'Special') OR (item_id = 76259 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.0014419555664062
(509) DESCRIBE `cruiselines` 0.0024619102478027
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00043797492980957
(511) DESCRIBE `orchid_image` 0.0019700527191162
(512) DESCRIBE `cruiselines` 0.0024149417877197
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00045514106750488
(514) DESCRIBE `cruises` 0.0032868385314941
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76259') 0.00042510032653809
(516) DESCRIBE `ships` 0.0035881996154785
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00051307678222656
(518) DESCRIBE `ships` 0.0033819675445557
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.0005190372467041
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(522) DESCRIBE `itineraries` 0.0020351409912109
(523) DESCRIBE `ports` 0.0023539066314697
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051498413085938
(525) DESCRIBE `ports` 0.0024878978729248
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046706199645996
(527) DESCRIBE `ports` 0.0019090175628662
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038695335388184
(529) DESCRIBE `sailingdates` 0.0016000270843506
(530) DESCRIBE `ports` 0.0018420219421387
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051498413085938
(532) DESCRIBE `ports` 0.0022799968719482
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005030632019043
(534) DESCRIBE `ports` 0.0019450187683105
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00048208236694336
(536) DESCRIBE `ports` 0.0020461082458496
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00045299530029297
(538) DESCRIBE `ports` 0.0019090175628662
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00045084953308105
(540) DESCRIBE `ports` 0.0020811557769775
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00041007995605469
(542) DESCRIBE `ports` 0.0018329620361328
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00052404403686523
(544) DESCRIBE `ports` 0.0019099712371826
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00039291381835938
(546) DESCRIBE `ports` 0.0018630027770996
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00048494338989258
(548) DESCRIBE `ports` 0.0018589496612549
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00043797492980957
(550) DESCRIBE `ports` 0.0019130706787109
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00042510032653809
(552) DESCRIBE `ports` 0.0022690296173096
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00055408477783203
(554) DESCRIBE `ports` 0.0019991397857666
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00061893463134766
(556) DESCRIBE `ports` 0.0018610954284668
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00045490264892578
(558) DESCRIBE `ports` 0.0018370151519775
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.0004279613494873
(560) DESCRIBE `ports` 0.0021851062774658
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00040912628173828
(562) DESCRIBE `ports` 0.0018379688262939
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048303604125977
(564) DESCRIBE `ports` 0.0018959045410156
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048995018005371
(566) DESCRIBE `avid_specials` 0.0016798973083496
(567) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76259 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.0011999607086182
(568) DESCRIBE `cruiselines` 0.0030229091644287
(569) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00054597854614258
(570) DESCRIBE `orchid_image` 0.0024690628051758
(571) DESCRIBE `cruiselines` 0.0028891563415527
(572) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0004270076751709
(573) DESCRIBE `cruisetypes` 0.0017359256744385
(574) DESCRIBE `destinations` 0.0025210380554199
(575) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.0009009838104248
(576) DESCRIBE `cruiselines` 0.0027360916137695
(577) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00047183036804199
(578) DESCRIBE `ships` 0.0039141178131104
(579) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00060200691223145
(580) DESCRIBE `cruiselines` 0.0031609535217285
(581) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00060892105102539
(582) DESCRIBE `ships` 0.0040240287780762
(583) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00056099891662598