or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

Sign up to our newsletter and become the first to know about our latest deals and promotions

Cruise Ships

Search for Cruise Ships

 
 
 
  • Quark Expeditions
    50 Years of Victory

    50 Years of Victory

    Twenty years in the making, 50 Years of Victory is the first Arktika-class icebreaker to have a spoon-shaped bow. Boosting the efficiency is the all-new...

    Star Rating Specialty
  • A-Rosa Cruises
    A-Rosa Aqua

    A-Rosa Aqua

    The modern cruise ships of A-ROSA offer a lot of open space. At 125 to 135 metres, the ships spend space for various activities and...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Bella

    A-Rosa Bella

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Brava

    A-Rosa Brava

    Cruising on a river is certainly not the fastest mode of transportation. And the countless meanders of the Rhine, Danube and Rhône are not the...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Donna

    A-Rosa Donna

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Those seeking privacy &...

    Star Rating River
  • A-Rosa Cruises

    A-Rosa Douro

    What do you have in mind when it comes to Portugal? Spectacular cliffs, the taste of port wine or melancholic fado? Everything's right. From 2019...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Flora

    A-Rosa Flora

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Luna

    A-Rosa Luna

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Rhone/Saone. Whether you are seeking for...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Mia

    A-Rosa Mia

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Riva

    A-Rosa Riva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Silva

    A-Rosa Silva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Stella

    A-Rosa Stella

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhône/Saône. Seeking for privacy or cozy...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Viva

    A-Rosa Viva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • Assam Bengal Navigation
    ABN Charaidew

    ABN Charaidew

    The "ABN Charaidew" is a 38m long twin-engine steel hulled passenger boat. She was completely stripped down and rebuilt by ABN in 2003 to provide...

    Star Rating River
  • Assam Bengal Navigation
    ABN Rajmahal

    ABN Rajmahal

    Our new ship "ABN Rajmahal", nearing completion in Kolkata, enters service on the Hugli and the Ganges in February 2014. She is 50m long, is...

    Star Rating River
  • Assam Bengal Navigation
    ABN Sukapha

    ABN Sukapha

    Our second ship "ABN Sukapha" joined "ABN Charaidew" in Assam in October 2006. We have respected the fragile environment of the River Brahmaputra and resisted...

    Star Rating River
  • Alaskan Dream Cruises
    Admiralty Dream

    Admiralty Dream

    The Admiralty Dream is perfect for adventure in the wilderness waterways. With its shallow draft and stately pace of cruising, nothing will be missed in...

    Star Rating Specialty
  • Royal Caribbean International
    Adventure of the Seas

    Adventure of the Seas

    This is a Royal Caribbean® favourite upgraded with all-new thrills. Challenge a friend on the twisting, turning waterslides, Cyclone and Typhoon. Catch a perfect wave...

    Star Rating 4 Star
  • Voyages to Antiquity
    Aegean Odyssey

    Aegean Odyssey

    There is a particular pleasure that comes with cruising aboard a smaller ship. Hosting an average of just 350 passengers, Aegean Odyssey is no ‘floating...

    Star Rating 3 Star
  • Affinity Cruises
    Affinity

    Affinity

    Discover the wonders of these areas aboard our comfy vessel where we offer you a personalised nautical experience in a relaxed atmosphere that you only...

    Star Rating Specialty
  • CroisiEurope
    African Dream

    African Dream

    The African Dream sails on the Chobe river.

    Facilities: panoramic lounge bar restaurant and a large observation deck for an hitherto unseen immersion in nature a...

    Star Rating River
  • One Ocean Expeditions
    Akademik Ioffe

    Akademik Ioffe

    The Akademik Ioffe is modern, comfortable, safe and ice strengthened. From small group sessions to briefings for all passengers, we have public spaces onboard the...

    Star Rating Specialty
  • One Ocean Expeditions
    Akademik Sergey Vavilov

    Akademik Sergey Vavilov

    The Akademik Sergey Vavilov is modern, comfortable, safe and ice strengthened. From small group sessions to briefings for all passengers, we have public spaces onboard...

    Star Rating Specialty
  • Heritage Expeditions
    Akademik Shokalskiy

    Akademik Shokalskiy

    The Shokalskiy is the sister ship to the Spirit of Enderby, they were both built in 1984 for polar and oceanographic research and being fully...

    Star Rating Specialty
  • Alaskan Dream Cruises
    Alaskan Dream

    Alaskan Dream

    At 104 feet in length, the Alaskan Dream is an innovative, streamlined catamaran design allows the vessel to easily navigate narrow channels and passages like...

    Star Rating Specialty
  • Travelmarvel
    Alexander Borodin

    Alexander Borodin

    Glide by Russia's picturesque scenery on a journey aboard the MS Alexander Borodin. This stylish and comfortable vessel offers an intimate and personalised experience with...

    Star Rating River
  • Royal Caribbean International
    Allure of the Seas

    Allure of the Seas

    Allure of the Seas has just been named Best Cruise Ship by Travel Weekly readers for the second year in a row. But this isn't...

    Star Rating 4 Star
  • European Waterways
    Alouette

    Alouette

    Alouette accommodates four passengers in well-appointed cabins located above the water line. Her sun-deck provides the perfect place to relax and enjoy the passing scenery...

    Star Rating River
  • MHS Cruises
    Alyssa

    Alyssa

    M/Y Alyssa was built in 2005 and was launched beginning 2006 according to International specifications and classifications required by the Germanisher Lloyd.The building, structure and...

    Star Rating River
  • AMA Waterways
    AmaBella

    AmaBella

    The MS AmaBella offers the ultimate in custom-designed luxury. This 161-passenger vessel features a combination of amenities and design details never before seen on the...

    Star Rating River
  • APT
    AmaBella

    AmaBella

    Leading the way in luxury and comfort, our Concerto River Ships represent a revolution in ship design. They are the grandest ships on Europe’s rivers...

    Star Rating River
  • AMA Waterways
    AmaCello

    AmaCello

    Decorated in a vibrant palette of gold and orange, the AmaCello debuted in 2008. Most staterooms feature French balconies and range in size from 170-255...

    Star Rating River
  • APT
    AmaCello

    AmaCello

    MS AmaCello is an Aria Class River Ship.

    Aria River Ships are among the finest river ships you’ll find not just in Europe, but anywhere in...

    Star Rating River
  • AMA Waterways
    AmaCerto

    AmaCerto

    Inspired by classic ocean yachts, the AmaCerto provides the most distinctive river cruise experience. A magnificent glass elevator is one of the unique design elements...

    Star Rating River
  • APT
    AmaCerto

    AmaCerto

    Leading the way in luxury and comfort, our Concerto River Ships represent a revolution in ship design. They are the grandest ships on Europe’s rivers...

    Star Rating River
  • AMA Waterways
    AmaDante

    AmaDante

    The custom-designed AmaDante was introduced in 2008 and features spacious staterooms ranging in size from 170-255 sq. ft. most with French balconies. All staterooms include...

    Star Rating River
  • APT
    AmaDante

    AmaDante

    MS AmaDante is an Aria Class River Ship.

    Aria River Ships are among the finest river ships you’ll find not just in Europe, but anywhere in...

    Star Rating River
  • AMA Waterways
    AmaDara

    AmaDara

    The brand-new 124-passenger AmaDara (2015) features Luxury Suites (452 sq. ft.), Suites (334 sq. ft.) and spacious standard staterooms (226 sq. ft.), all of which...

    Star Rating River
  • APT
    AmaDara

    AmaDara

    The 124-passenger AmaDara (2015) features Luxury Suites (452 sq. ft.), Suites (334 sq. ft.) and spacious standard staterooms (226 sq. ft.), all of which have...

    Star Rating River
  • Luftner Cruises
    Amadeus

    Amadeus

    The MS AMADEUS is still quite new, but this early member of the AMADEUS fleet already exudes faint wafts of nostalgia and romance. Not...

    Star Rating River
  • Luftner Cruises
    Amadeus Brilliant

    Amadeus Brilliant

    The new flagship for the innovative AMADEUS fleet, namely the MS AMADEUS Brilliant, has been launched in April 2011.

    The AMADEUS Brilliant certainly lives up to...

    Star Rating River
  • Luftner Cruises
    Amadeus Classic

    Amadeus Classic

    The AMADEUS CLASSIC presents the new premium-class as first vessel. Here you find additional comfort-facilities like walking-track, Vital-club and the AMADEUS-Club. Calm down in the...

    Star Rating River
  • Luftner Cruises
    Amadeus Diamond

    Amadeus Diamond

    Since its debut in 2009 the AMADEUS Diamond has set new standards in European river cruising. This river cruiser is a nothing other than a...

    Star Rating River
  • Luftner Cruises
    Amadeus Elegant

    Amadeus Elegant

    The AMADEUS Elegant certainly lives up to its name: with the famous pointed bow, and measuring 110 m in length and 11.4 m in breadth...

    Star Rating River
  • Luftner Cruises
    Amadeus Princess

    Amadeus Princess

    With its remarkable sense of style, elegance and grace, the AMADEUS Princess beckon you to travel on a sophisticated and luxurious journey: There is the...

    Star Rating River
  • Luftner Cruises

    Amadeus Provence

    In April 2017 the AMADEUS Provence, the newest premium vessel of the AMADEUS fleet, will start sailing on the French rivers Rhône and Saône.

    The AMADEUS...

    Star Rating River
  • Luftner Cruises

    Amadeus Queen

    The AMADEUS Queen, the 15th river cruise ship of the Austrian ship operator, will tour the Danube, Rhine and Main rivers as well as Dutch...

    Star Rating River
  • Luftner Cruises
    Amadeus Rhapsody

    Amadeus Rhapsody

    Tastefully furnished cabins offer all the comforts you would expect in passenger vessels of this category. Warm colours and harmonious design give each cabin...

    Star Rating River
  • Luftner Cruises
    Amadeus Royal

    Amadeus Royal

    The AMADEUS Royal was launched in 2005 and is a premium passenger vessel fitted out with all imaginable refinements. The cabins on the Mozart-Deck, for...

    Star Rating River
  • Luftner Cruises
    Amadeus Silver

    Amadeus Silver

    The new flagship for the innovative AMADEUS fleet, namely the MS AMADEUS SILVER, will be launched in 2013. Extending the traditional 110-m length of the...

    Star Rating River
 

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

Total elapsed time: 0.72685050964355

# Query Time
(1) connect 0.0004420280456543
(2) DESCRIBE `ships` 0.0038509368896484
(3) DESCRIBE `cruiselines` 0.0030348300933838
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 73))) 0.00069308280944824
(5) DESCRIBE `orchid_image` 0.0022430419921875
(6) DESCRIBE `cruiselines` 0.0026860237121582
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '73') 0.00042390823364258
(8) DESCRIBE `ships` 0.0033609867095947
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '758') 0.00054693222045898
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035309791564941
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046992301940918
(12) DESCRIBE `avid_specials` 0.0014801025390625
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 758 AND class = 'Ship') OR (item_id = 73 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017099380493164
(14) DESCRIBE `cruiselines` 0.0024068355560303
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00051307678222656
(16) DESCRIBE `orchid_image` 0.0018050670623779
(17) DESCRIBE `cruiselines` 0.0023128986358643
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00045204162597656
(19) DESCRIBE `ships` 0.0033621788024902
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1218') 0.00042295455932617
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001521110534668
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029993057250977
(23) DESCRIBE `avid_specials` 0.0014901161193848
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1218 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001662015914917
(25) DESCRIBE `cruiselines` 0.0027408599853516
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00055289268493652
(27) DESCRIBE `orchid_image` 0.0015311241149902
(28) DESCRIBE `cruiselines` 0.0018970966339111
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00037002563476562
(30) DESCRIBE `ships` 0.0027720928192139
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1562') 0.00041294097900391
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025010108947754
(34) DESCRIBE `avid_specials` 0.001384973526001
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1562 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010378360748291
(36) DESCRIBE `cruiselines` 0.0018460750579834
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00037407875061035
(38) DESCRIBE `orchid_image` 0.001474142074585
(39) DESCRIBE `cruiselines` 0.0017600059509277
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00035500526428223
(41) DESCRIBE `ships` 0.0026290416717529
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1566') 0.00029993057250977
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035810470581055
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033092498779297
(45) DESCRIBE `avid_specials` 0.0013291835784912
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1566 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010459423065186
(47) DESCRIBE `cruiselines` 0.0018830299377441
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00050187110900879
(49) DESCRIBE `orchid_image` 0.0014278888702393
(50) DESCRIBE `cruiselines` 0.0019538402557373
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00034308433532715
(52) DESCRIBE `ships` 0.0025911331176758
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1268') 0.00035786628723145
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026416778564453
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024914741516113
(56) DESCRIBE `avid_specials` 0.001176118850708
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1268 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098299980163574
(58) DESCRIBE `cruiselines` 0.002129077911377
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00045299530029297
(60) DESCRIBE `orchid_image` 0.0014500617980957
(61) DESCRIBE `cruiselines` 0.0017929077148438
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00033378601074219
(63) DESCRIBE `ships` 0.0025959014892578
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1753') 0.00033783912658691
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029301643371582
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029706954956055
(67) DESCRIBE `avid_specials` 0.0012118816375732
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1753 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098896026611328
(69) DESCRIBE `cruiselines` 0.0023751258850098
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00040602684020996
(71) DESCRIBE `orchid_image` 0.001471996307373
(72) DESCRIBE `cruiselines` 0.0018310546875
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00044012069702148
(74) DESCRIBE `ships` 0.0025081634521484
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1269') 0.00032997131347656
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040793418884277
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026392936706543
(78) DESCRIBE `avid_specials` 0.0012831687927246
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1269 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010900497436523
(80) DESCRIBE `cruiselines` 0.0019388198852539
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00040006637573242
(82) DESCRIBE `orchid_image` 0.0014400482177734
(83) DESCRIBE `cruiselines` 0.0027229785919189
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.0005028247833252
(85) DESCRIBE `ships` 0.0026941299438477
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1567') 0.00029397010803223
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026321411132812
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(89) DESCRIBE `avid_specials` 0.0011491775512695
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1567 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096702575683594
(91) DESCRIBE `cruiselines` 0.0017678737640381
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00038409233093262
(93) DESCRIBE `orchid_image` 0.0013868808746338
(94) DESCRIBE `cruiselines` 0.0018429756164551
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00030398368835449
(96) DESCRIBE `ships` 0.0024840831756592
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1561') 0.00029397010803223
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(100) DESCRIBE `avid_specials` 0.0011820793151855
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1561 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00097203254699707
(102) DESCRIBE `cruiselines` 0.0017590522766113
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00035285949707031
(104) DESCRIBE `orchid_image` 0.0013930797576904
(105) DESCRIBE `cruiselines` 0.0018198490142822
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00031089782714844
(107) DESCRIBE `ships` 0.0025429725646973
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1557') 0.00029301643371582
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(111) DESCRIBE `avid_specials` 0.001093864440918
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1557 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00093603134155273
(113) DESCRIBE `cruiselines` 0.001755952835083
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00036811828613281
(115) DESCRIBE `orchid_image` 0.0013749599456787
(116) DESCRIBE `cruiselines` 0.0019960403442383
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00032687187194824
(118) DESCRIBE `ships` 0.0025200843811035
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1216') 0.00029802322387695
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002601146697998
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024914741516113
(122) DESCRIBE `avid_specials` 0.001431941986084
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1216 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015759468078613
(124) DESCRIBE `cruiselines` 0.0020859241485596
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00043916702270508
(126) DESCRIBE `orchid_image` 0.00164794921875
(127) DESCRIBE `cruiselines` 0.002065896987915
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00038409233093262
(129) DESCRIBE `ships` 0.0026769638061523
(130) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1222') 0.00037002563476562
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025081634521484
(133) DESCRIBE `avid_specials` 0.0012450218200684
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010299682617188
(135) DESCRIBE `cruiselines` 0.0020129680633545
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00047516822814941
(137) DESCRIBE `orchid_image` 0.0011000633239746
(138) DESCRIBE `cruiselines` 0.0019388198852539
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00034713745117188
(140) DESCRIBE `ships` 0.0028259754180908
(141) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1270') 0.00036001205444336
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025010108947754
(144) DESCRIBE `avid_specials` 0.0014290809631348
(145) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1270 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009770393371582
(146) DESCRIBE `cruiselines` 0.0019700527191162
(147) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00048685073852539
(148) DESCRIBE `orchid_image` 0.0015120506286621
(149) DESCRIBE `cruiselines` 0.0019199848175049
(150) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00032997131347656
(151) DESCRIBE `ships` 0.0025758743286133
(152) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1211') 0.00031900405883789
(153) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026416778564453
(154) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(155) DESCRIBE `avid_specials` 0.001291036605835
(156) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1211 AND class = 'Ship') OR (item_id = 236 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010859966278076
(157) DESCRIBE `cruiselines` 0.0021228790283203
(158) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00041604042053223
(159) DESCRIBE `orchid_image` 0.0015139579772949
(160) DESCRIBE `cruiselines` 0.0018329620361328
(161) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00031185150146484
(162) DESCRIBE `ships` 0.0026748180389404
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1213') 0.00034284591674805
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025391578674316
(166) DESCRIBE `avid_specials` 0.0011098384857178
(167) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1213 AND class = 'Ship') OR (item_id = 236 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00097107887268066
(168) DESCRIBE `cruiselines` 0.0019180774688721
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00035905838012695
(170) DESCRIBE `orchid_image` 0.0014040470123291
(171) DESCRIBE `cruiselines` 0.0018301010131836
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00029492378234863
(173) DESCRIBE `ships` 0.0025451183319092
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1212') 0.00029993057250977
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026297569274902
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(177) DESCRIBE `avid_specials` 0.0011749267578125
(178) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1212 AND class = 'Ship') OR (item_id = 236 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094795227050781
(179) DESCRIBE `cruiselines` 0.0018582344055176
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213))) 0.00034308433532715
(181) DESCRIBE `orchid_image` 0.0014519691467285
(182) DESCRIBE `cruiselines` 0.0021431446075439
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213') 0.00072693824768066
(184) DESCRIBE `ships` 0.0033421516418457
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1022') 0.00040102005004883
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027203559875488
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025391578674316
(188) DESCRIBE `avid_specials` 0.0012381076812744
(189) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1022 AND class = 'Ship') OR (item_id = 213 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016059875488281
(190) DESCRIBE `cruiselines` 0.0019237995147705
(191) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034785270690918
(192) DESCRIBE `orchid_image` 0.0014200210571289
(193) DESCRIBE `cruiselines` 0.0022261142730713
(194) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00034117698669434
(195) DESCRIBE `ships` 0.0031139850616455
(196) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0.00039815902709961
(197) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002748966217041
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002589225769043
(199) DESCRIBE `avid_specials` 0.0013139247894287
(200) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011041164398193
(201) DESCRIBE `cruiselines` 0.0019600391387939
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0003819465637207
(203) DESCRIBE `orchid_image` 0.0019760131835938
(204) DESCRIBE `cruiselines` 0.0016331672668457
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00037002563476562
(206) DESCRIBE `ships` 0.0030810832977295
(207) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00049901008605957
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00027608871459961
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025796890258789
(210) DESCRIBE `avid_specials` 0.0013599395751953
(211) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099396705627441
(212) DESCRIBE `cruiselines` 0.0019850730895996
(213) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 134))) 0.00050592422485352
(214) DESCRIBE `orchid_image` 0.0015649795532227
(215) DESCRIBE `cruiselines` 0.0023798942565918
(216) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134') 0.0004420280456543
(217) DESCRIBE `ships` 0.0032570362091064
(218) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568') 0.00046777725219727
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034999847412109
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00029110908508301
(221) DESCRIBE `avid_specials` 0.001554012298584
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 568 AND class = 'Ship') OR (item_id = 134 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012860298156738
(223) DESCRIBE `cruiselines` 0.0020630359649658
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00042605400085449
(225) DESCRIBE `orchid_image` 0.0017588138580322
(226) DESCRIBE `cruiselines` 0.0020508766174316
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00033307075500488
(228) DESCRIBE `ships` 0.0035960674285889
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1581') 0.00045204162597656
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027322769165039
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025677680969238
(232) DESCRIBE `avid_specials` 0.0012748241424561
(233) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1581 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099015235900879
(234) DESCRIBE `cruiselines` 0.0022079944610596
(235) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 184))) 0.00051784515380859
(236) DESCRIBE `orchid_image` 0.0017340183258057
(237) DESCRIBE `cruiselines` 0.002100944519043
(238) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '184') 0.00036787986755371
(239) DESCRIBE `ships` 0.0029699802398682
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1092') 0.00042390823364258
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032591819763184
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025701522827148
(243) DESCRIBE `avid_specials` 0.0013530254364014
(244) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1092 AND class = 'Ship') OR (item_id = 184 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012898445129395
(245) DESCRIBE `cruiselines` 0.0025429725646973
(246) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 184))) 0.00043010711669922
(247) DESCRIBE `orchid_image` 0.0022039413452148
(248) DESCRIBE `cruiselines` 0.002126932144165
(249) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '184') 0.00034403800964355
(250) DESCRIBE `ships` 0.0027251243591309
(251) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1091') 0.00039100646972656
(252) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027012825012207
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025606155395508
(254) DESCRIBE `avid_specials` 0.0013110637664795
(255) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1091 AND class = 'Ship') OR (item_id = 184 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010020732879639
(256) DESCRIBE `cruiselines` 0.002284049987793
(257) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105))) 0.00043320655822754
(258) DESCRIBE `orchid_image` 0.0015180110931396
(259) DESCRIBE `cruiselines` 0.002161979675293
(260) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '105') 0.00035905838012695
(261) DESCRIBE `ships` 0.002687931060791
(262) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1392') 0.00038814544677734
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027298927307129
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003969669342041
(265) DESCRIBE `avid_specials` 0.001366138458252
(266) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1392 AND class = 'Ship') OR (item_id = 105 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0040769577026367
(267) DESCRIBE `cruiselines` 0.0021378993988037
(268) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213))) 0.00036406517028809
(269) DESCRIBE `orchid_image` 0.0015730857849121
(270) DESCRIBE `cruiselines` 0.0018370151519775
(271) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213') 0.00031685829162598
(272) DESCRIBE `ships` 0.0027570724487305
(273) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1023') 0.00029301643371582
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026917457580566
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025415420532227
(276) DESCRIBE `avid_specials` 0.0012362003326416
(277) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1023 AND class = 'Ship') OR (item_id = 213 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011680126190186
(278) DESCRIBE `cruiselines` 0.0019199848175049
(279) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00033307075500488
(280) DESCRIBE `orchid_image` 0.0016219615936279
(281) DESCRIBE `cruiselines` 0.0018630027770996
(282) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00030303001403809
(283) DESCRIBE `ships` 0.0025839805603027
(284) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1578') 0.00041294097900391
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026917457580566
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(287) DESCRIBE `avid_specials` 0.0012011528015137
(288) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1578 AND class = 'Ship') OR (item_id = 249 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010747909545898
(289) DESCRIBE `cruiselines` 0.0018949508666992
(290) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042104721069336
(291) DESCRIBE `orchid_image` 0.0015149116516113
(292) DESCRIBE `cruiselines` 0.0018517971038818
(293) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029087066650391
(294) DESCRIBE `ships` 0.0026371479034424
(295) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '791') 0.00028896331787109
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(297) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(298) DESCRIBE `avid_specials` 0.0012691020965576
(299) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 791 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096893310546875
(300) DESCRIBE `cruiselines` 0.0021030902862549
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) 0.00037002563476562
(302) DESCRIBE `orchid_image` 0.0014140605926514
(303) DESCRIBE `cruiselines` 0.0017781257629395
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '206') 0.00033092498779297
(305) DESCRIBE `ships` 0.0029659271240234
(306) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '922') 0.00029206275939941
(307) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026679039001465
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(309) DESCRIBE `avid_specials` 0.0011529922485352
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 922 AND class = 'Ship') OR (item_id = 206 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010161399841309
(311) DESCRIBE `cruiselines` 0.0018761157989502
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 168))) 0.0003969669342041
(313) DESCRIBE `orchid_image` 0.0017528533935547
(314) DESCRIBE `cruiselines` 0.0019071102142334
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '168') 0.00033688545227051
(316) DESCRIBE `ships` 0.0026559829711914
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '731') 0.00030708312988281
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025415420532227
(320) DESCRIBE `avid_specials` 0.0015251636505127
(321) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 731 AND class = 'Ship') OR (item_id = 168 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099396705627441
(322) DESCRIBE `cruiselines` 0.0023670196533203
(323) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00037407875061035
(324) DESCRIBE `orchid_image` 0.001427173614502
(325) DESCRIBE `cruiselines` 0.0017998218536377
(326) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00055909156799316
(327) DESCRIBE `ships` 0.0030350685119629
(328) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '960') 0.00030994415283203
(329) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027179718017578
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(331) DESCRIBE `avid_specials` 0.0013370513916016
(332) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 960 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010638236999512
(333) DESCRIBE `cruiselines` 0.0018401145935059
(334) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00034499168395996
(335) DESCRIBE `orchid_image` 0.0014030933380127
(336) DESCRIBE `cruiselines` 0.0018079280853271
(337) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00029301643371582
(338) DESCRIBE `ships` 0.0028970241546631
(339) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '808') 0.00028610229492188
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028181076049805
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(342) DESCRIBE `avid_specials` 0.0014958381652832
(343) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 808 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010240077972412
(344) DESCRIBE `cruiselines` 0.0019590854644775
(345) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00035691261291504
(346) DESCRIBE `orchid_image` 0.0016100406646729
(347) DESCRIBE `cruiselines` 0.002227783203125
(348) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00035595893859863
(349) DESCRIBE `ships` 0.0030300617218018
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '656') 0.00027990341186523
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025510787963867
(353) DESCRIBE `avid_specials` 0.0012030601501465
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 656 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009760856628418
(355) DESCRIBE `cruiselines` 0.0018539428710938
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00037384033203125
(357) DESCRIBE `orchid_image` 0.0015020370483398
(358) DESCRIBE `cruiselines` 0.0018260478973389
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.0003049373626709
(360) DESCRIBE `ships` 0.0026309490203857
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '798') 0.00050187110900879
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025510787963867
(364) DESCRIBE `avid_specials` 0.0013868808746338
(365) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 798 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010499954223633
(366) DESCRIBE `cruiselines` 0.0023250579833984
(367) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00061202049255371
(368) DESCRIBE `orchid_image` 0.0019290447235107
(369) DESCRIBE `cruiselines` 0.0024998188018799
(370) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00038003921508789
(371) DESCRIBE `ships` 0.0036959648132324
(372) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '958') 0.00045394897460938
(373) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(375) DESCRIBE `avid_specials` 0.0013430118560791
(376) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 958 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011379718780518
(377) DESCRIBE `cruiselines` 0.0020360946655273
(378) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00046086311340332
(379) DESCRIBE `orchid_image` 0.0018508434295654
(380) DESCRIBE `cruiselines` 0.0023949146270752
(381) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 5.1021575927734E-5
(382) DESCRIBE `ships` 0.0031929016113281
(383) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '978') 0.00040102005004883
(384) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027298927307129
(385) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002899169921875
(386) DESCRIBE `avid_specials` 0.001446008682251
(387) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 978 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012569427490234
(388) DESCRIBE `cruiselines` 0.0025019645690918
(389) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00039291381835938
(390) DESCRIBE `orchid_image` 0.0015389919281006
(391) DESCRIBE `cruiselines` 0.0018758773803711
(392) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00031709671020508
(393) DESCRIBE `ships` 0.002838134765625
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '663') 0.00030899047851562
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(397) DESCRIBE `avid_specials` 0.0015518665313721
(398) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 663 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001060962677002
(399) DESCRIBE `cruiselines` 0.0025379657745361
(400) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00037288665771484
(401) DESCRIBE `orchid_image` 0.0016038417816162
(402) DESCRIBE `cruiselines` 0.0020830631256104
(403) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.0003359317779541
(404) DESCRIBE `ships` 0.0026490688323975
(405) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '800') 0.00031614303588867
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027608871459961
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(408) DESCRIBE `avid_specials` 0.0013458728790283
(409) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 800 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011579990386963
(410) DESCRIBE `cruiselines` 0.0020589828491211
(411) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00034904479980469
(412) DESCRIBE `orchid_image` 0.0014159679412842
(413) DESCRIBE `cruiselines` 0.001884937286377
(414) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00032210350036621
(415) DESCRIBE `ships` 0.0027070045471191
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1289') 0.00039100646972656
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026988983154297
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025510787963867
(419) DESCRIBE `avid_specials` 0.0012919902801514
(420) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1289 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012960433959961
(421) DESCRIBE `cruiselines` 0.0020778179168701
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00037693977355957
(423) DESCRIBE `orchid_image` 0.0015730857849121
(424) DESCRIBE `cruiselines` 0.0021190643310547
(425) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00033688545227051
(426) DESCRIBE `ships` 0.0026588439941406
(427) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1369') 0.00042200088500977
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028300285339355
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(430) DESCRIBE `avid_specials` 0.0023951530456543
(431) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1369 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018050670623779
(432) DESCRIBE `cruiselines` 0.0025570392608643
(433) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00047802925109863
(434) DESCRIBE `orchid_image` 0.0019938945770264
(435) DESCRIBE `cruiselines` 0.0026280879974365
(436) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00065088272094727
(437) DESCRIBE `ships` 0.0036020278930664
(438) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '620') 0.0004730224609375
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032401084899902
(441) DESCRIBE `avid_specials` 0.0017848014831543
(442) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 620 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015931129455566
(443) DESCRIBE `cruiselines` 0.0026600360870361
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00049901008605957
(445) DESCRIBE `orchid_image` 0.001945972442627
(446) DESCRIBE `cruiselines` 0.0025410652160645
(447) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00042414665222168
(448) DESCRIBE `ships` 0.0032749176025391
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '933') 0.00036501884460449
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032615661621094
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031304359436035
(452) DESCRIBE `avid_specials` 0.0016140937805176
(453) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 933 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016870498657227
(454) DESCRIBE `cruiselines` 0.0027132034301758
(455) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00049185752868652
(456) DESCRIBE `orchid_image` 0.0019478797912598
(457) DESCRIBE `cruiselines` 0.0026929378509521
(458) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00045680999755859
(459) DESCRIBE `ships` 0.0034260749816895
(460) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '622') 0.00040793418884277
(461) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033187866210938
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031399726867676
(463) DESCRIBE `avid_specials` 0.0015871524810791
(464) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 622 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016438961029053
(465) DESCRIBE `cruiselines` 0.0024089813232422
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00046110153198242
(467) DESCRIBE `orchid_image` 0.0018429756164551
(468) DESCRIBE `cruiselines` 0.0025479793548584
(469) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00041604042053223
(470) DESCRIBE `ships` 0.0033690929412842
(471) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '741') 0.00043606758117676
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035309791564941
(473) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035381317138672
(474) DESCRIBE `avid_specials` 0.001694917678833
(475) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 741 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016980171203613
(476) DESCRIBE `cruiselines` 0.0025570392608643
(477) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00050592422485352
(478) DESCRIBE `orchid_image` 0.0019290447235107
(479) DESCRIBE `cruiselines` 0.002453088760376
(480) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00041604042053223
(481) DESCRIBE `ships` 0.0034298896789551
(482) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '835') 0.00042605400085449
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033187866210938
(484) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031495094299316
(485) DESCRIBE `avid_specials` 0.0015959739685059
(486) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 835 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017471313476562
(487) DESCRIBE `cruiselines` 0.0024309158325195
(488) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.0004880428314209
(489) DESCRIBE `orchid_image` 0.001708984375
(490) DESCRIBE `cruiselines` 0.0027320384979248
(491) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00043702125549316
(492) DESCRIBE `ships` 0.0032620429992676
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '625') 0.00042414665222168
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033211708068848
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 5.5074691772461E-5
(496) DESCRIBE `avid_specials` 0.0016689300537109
(497) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 625 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016510486602783
(498) DESCRIBE `cruiselines` 0.0019791126251221
(499) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00058507919311523
(500) DESCRIBE `orchid_image` 0.0014309883117676
(501) DESCRIBE `cruiselines` 0.0018351078033447
(502) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00031280517578125
(503) DESCRIBE `ships` 0.0025589466094971
(504) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1491') 0.00031113624572754
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(506) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(507) DESCRIBE `avid_specials` 0.001147985458374
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1491 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010371208190918
(509) DESCRIBE `cruiselines` 0.0019149780273438
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00036811828613281
(511) DESCRIBE `orchid_image` 0.0014810562133789
(512) DESCRIBE `cruiselines` 0.0021951198577881
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00035810470581055
(514) DESCRIBE `ships` 0.0031027793884277
(515) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1631') 0.00037002563476562
(516) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(517) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(518) DESCRIBE `avid_specials` 0.0014090538024902
(519) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1631 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010979175567627
(520) DESCRIBE `cruiselines` 0.0018990039825439
(521) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00034785270690918
(522) DESCRIBE `orchid_image` 0.0014650821685791
(523) DESCRIBE `cruiselines` 0.0020301342010498
(524) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00035309791564941
(525) DESCRIBE `ships` 0.0027740001678467
(526) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '621') 0.00028896331787109
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027680397033691
(528) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002751350402832
(529) DESCRIBE `avid_specials` 0.0012600421905518
(530) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 621 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098299980163574
(531) DESCRIBE `cruiselines` 0.0019180774688721
(532) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00035881996154785
(533) DESCRIBE `orchid_image` 0.0014619827270508
(534) DESCRIBE `cruiselines` 0.0018720626831055
(535) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00034189224243164
(536) DESCRIBE `ships` 0.0026378631591797
(537) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '624') 0.00030779838562012
(538) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027799606323242
(539) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(540) DESCRIBE `avid_specials` 0.0013360977172852
(541) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 624 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010311603546143
(542) DESCRIBE `cruiselines` 0.0025429725646973
(543) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00052094459533691
(544) DESCRIBE `orchid_image` 0.0019261837005615
(545) DESCRIBE `cruiselines` 0.0018291473388672
(546) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00032305717468262
(547) DESCRIBE `ships` 0.002608060836792
(548) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1078') 0.00029397010803223
(549) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025391578674316
(551) DESCRIBE `avid_specials` 0.0011260509490967
(552) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1078 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096917152404785
(553) DESCRIBE `cruises` 0.0034830570220947
(554) SELECT `cruises`.* FROM `cruises` WHERE (id IN (23656, 34152, 34162, 34183, 34711, 38950, 44275, 44276, 49176, 49177)) ORDER BY FIND_IN_SET(id, '23656,34152,34162,34183,34711,38950,44275,44276,49176,49177') 0.0015749931335449
(555) DESCRIBE `cruiselines` 0.002349853515625
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '7', '23', '12', '20', '171', '18', '144', '8', '31', '101', '131', '50', '96', '239', '29', '103', '15', '191', '91', '120', '206', '37', '16', '262', '24', '33', '114', '28', '14', '174', '268', '221', '110', '156', '208', '141', '187', '153', '118', '151', '49', '211', '30', '258', '216', '181', '88', '4', '212', '36', '225', '238', '264', '232', '184', '140', '249', '159', '90', '113', '230', '182', '47', '213', '136', '261', '276', '237', '57', '188', '64', '180', '35', '73', '248', '95', '52', '209', '195', '231', '146', '256', '219', '59', '116', '82', '115', '168', '196', '119', '134', '244', '105', '170', '229', '204', '240', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,7,23,12,20,171,18,144,8,31,101,131,50,96,239,29,103,15,191,91,120,206,37,16,262,24,33,114,28,14,174,268,221,110,156,208,141,187,153,118,151,49,211,30,258,216,181,88,4,212,36,225,238,264,232,184,140,249,159,90,113,230,182,47,213,136,261,276,237,57,188,64,180,35,73,248,95,52,209,195,231,146,256,219,59,116,82,115,168,196,119,134,244,105,170,229,204,240,48,224') 0.0048239231109619
(557) DESCRIBE `ships` 0.0036530494689941
(558) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '1291', '977', '258', '1199', '1359', '1599', '454', '1272', '404', '780', '855', '1135', '986', '1677', '1067', '1237', '1594', '265', '837', '34', '37', '38', '1607', '21', '22', '27', '378', '461', '1376', '407', '1588', '28', '31', '770', '393', '817', '542', '30', '36', '1012', '39', '1245', '349', '573', '1424', '1552', '35', '1402', '726', '792', '585', '1415', '330', '462', '1284', '1422', '66', '113', '882', '332', '1176', '1744', '1760', '1419', '1423', '1420', '1574', '24', '11', '711', '1405', '1418', '1421', '9', '439', '1215', '455', '10', '434', '766', '1141', '1193', '78', '452', '739', '81', '69', '1572', '1454', '635', '1247', '1372', '3', '1008', '1095', '1682', '674', '124', '1373', '338', '1168', '5', '340', '580', '1319', '43', '116', '335', '553', '850', '1021', '1569', '70', '1302', '1678', '285', '148', '1172', '25', '111', '451', '658', '874', '4', '160', '716', '944', '1260', '253', '390', '1259', '386', '405', '748', '966', '385', '626', '1562', '616', '651', '791', '1108', '1320', '314', '784', '1088', '1323', '1330', '389', '406', '768', '1325', '63', '286', '683', '1645', '508', '582', '590', '749', '970', '1455', '1672', '207', '287', '327', '375', '483', '678', '1587', '119', '526', '1195', '84', '520', '1460', '1575', '108', '348', '559', '722', '854', '1068', '1208', '163', '401', '1398', '394', '657', '1492', '1571', '1586', '1742', '150', '485', '652', '775', '1236', '1266', '1268', '403', '704', '776', '147', '421', '1269', '114', '151', '152', '547', '993', '1064', '1289', '1308', '105', '123', '149', '223', '517', '1321', '325', '262', '715', '883', '954', '958', '1270', '1437', '351', '1471', '1711', '45', '1243', '1282', '1389', '1724', '75', '790', '1139', '1143', '1486', '1557', '1601', '1722', '545', '717', '1561', '1717', '441', '1013', '1159', '1526', '1579', '162', '290', '885', '1075', '1151', '1214', '1738', '291', '324', '333', '673', '823', '1326', '1327', '1367', '1539', '93', '796', '968', '1301', '1303', '98', '205', '516', '1040', '1216', '1318', '1348', '1704', '82', '818', '1540', '1602', '212', '701', '743', '1063', '1218', '1344', '732', '769', '852', '988', '1043', '1137', '1144', '1217', '1343', '1566', '201', '341', '751', '884', '1160', '1409', '1676', '1740', '574', '1163', '1452', '1453', '1604', '14', '266', '795', '1025', '1090', '1136', '1283', '448', '639', '669', '738', '811', '1157', '1241', '1253', '1426', '1449', '1721', '1019', '1223', '1226', '1632', '1766', '467', '601', '905', '1027', '1029', '1152', '1229', '1358', '1411', '1413', '1474', '1716', '997', '1073', '1448', '494', '1150', '1188', '1233', '1345', '1619', '74', '1055', '1322', '1351', '1408', '1647', '1663', '1673', '1713', '1715', '417', '709', '836', '996', '1026', '1047', '1145', '1410', '1458', '1496', '1714', '610', '618', '643', '1580', '1743', '208', '423', '453', '521', '888', '973', '1034', '1149', '1231', '1366', '1404', '1489', '1505', '1609', '666', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1516', '352', '920', '921', '927', '931', '1004', '1017', '1042', '1140', '1154', '1230', '1354', '1444', '1508', '1606', '1627', '1649', '493', '499', '663', '914', '923', '1106', '1517', '1518', '1567', '703', '915', '916', '926', '930', '1003', '1072', '1138', '1262', '1708', '1751', '479', '665', '781', '924', '972', '1001', '1020', '1052', '1175', '1352', '1412', '1463', '1521', '1522', '1593', '1596', '1723', '422', '671', '938', '1005', '1045', '1053', '1054', '1091', '1092', '1254', '1285', '1729', '937', '1051', '1445', '1650', '1681', '1684', '672', '1514', '1679', '1697', '504')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,1291,977,258,1199,1359,1599,454,1272,404,780,855,1135,986,1677,1067,1237,1594,265,837,34,37,38,1607,21,22,27,378,461,1376,407,1588,28,31,770,393,817,542,30,36,1012,39,1245,349,573,1424,1552,35,1402,726,792,585,1415,330,462,1284,1422,66,113,882,332,1176,1744,1760,1419,1423,1420,1574,24,11,711,1405,1418,1421,9,439,1215,455,10,434,766,1141,1193,78,452,739,81,69,1572,1454,635,1247,1372,3,1008,1095,1682,674,124,1373,338,1168,5,340,580,1319,43,116,335,553,850,1021,1569,70,1302,1678,285,148,1172,25,111,451,658,874,4,160,716,944,1260,253,390,1259,386,405,748,966,385,626,1562,616,651,791,1108,1320,314,784,1088,1323,1330,389,406,768,1325,63,286,683,1645,508,582,590,749,970,1455,1672,207,287,327,375,483,678,1587,119,526,1195,84,520,1460,1575,108,348,559,722,854,1068,1208,163,401,1398,394,657,1492,1571,1586,1742,150,485,652,775,1236,1266,1268,403,704,776,147,421,1269,114,151,152,547,993,1064,1289,1308,105,123,149,223,517,1321,325,262,715,883,954,958,1270,1437,351,1471,1711,45,1243,1282,1389,1724,75,790,1139,1143,1486,1557,1601,1722,545,717,1561,1717,441,1013,1159,1526,1579,162,290,885,1075,1151,1214,1738,291,324,333,673,823,1326,1327,1367,1539,93,796,968,1301,1303,98,205,516,1040,1216,1318,1348,1704,82,818,1540,1602,212,701,743,1063,1218,1344,732,769,852,988,1043,1137,1144,1217,1343,1566,201,341,751,884,1160,1409,1676,1740,574,1163,1452,1453,1604,14,266,795,1025,1090,1136,1283,448,639,669,738,811,1157,1241,1253,1426,1449,1721,1019,1223,1226,1632,1766,467,601,905,1027,1029,1152,1229,1358,1411,1413,1474,1716,997,1073,1448,494,1150,1188,1233,1345,1619,74,1055,1322,1351,1408,1647,1663,1673,1713,1715,417,709,836,996,1026,1047,1145,1410,1458,1496,1714,610,618,643,1580,1743,208,423,453,521,888,973,1034,1149,1231,1366,1404,1489,1505,1609,666,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1516,352,920,921,927,931,1004,1017,1042,1140,1154,1230,1354,1444,1508,1606,1627,1649,493,499,663,914,923,1106,1517,1518,1567,703,915,916,926,930,1003,1072,1138,1262,1708,1751,479,665,781,924,972,1001,1020,1052,1175,1352,1412,1463,1521,1522,1593,1596,1723,422,671,938,1005,1045,1053,1054,1091,1092,1254,1285,1729,937,1051,1445,1650,1681,1684,672,1514,1679,1697,504') 0.044950008392334
(559) DESCRIBE `cruisetypes` 0.0018789768218994
(560) DESCRIBE `destinations` 0.0025398731231689
(561) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '26', '38', '40', '7', '30', '48', '21', '11', '49', '29', '45', '44', '56', '10', '34', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,53,39,55,28,26,38,40,7,30,48,21,11,49,29,45,44,56,10,34,52,32,46') 0.0024678707122803