Bergsteigerschule Watzmann

Highlights am Watzmann mit der Bergsteigerschule Watzmann und den Watzmann Bergführern!

Dein Vorteil & Deine Sicherheit

Zahlungsziel 3 Tage vor Reisebeginn bei gesicherter Durchführung! Gültig seit 15.03.2020
Kostenfreier Reiserücktritt bei Einreiseverbot und/oder behördlicher Quarantäne bei Reisebeginn auf allen Reisen im Alpenraum
Corona Zusatzversicherung auch mit Absicherung für Länder mit Reisewarnung | Im Anschluss nach Reisebestätigung abschließbar

Wochenend Skitourenkurs für Einsteiger in Berchtesgaden

Zwei spannende Tage auf dem grenznahen Carl-von-Stahl-Haus. Der ideale Wochenendkurs unweit des Watzmann-Massivs.

Tiefschneekurs und Skitouren im Nationalpark Berchtesgaden

Skitouren und Tiefschneefahren in Berchtesgaden. Begleitet von einem Bergführer auf den ersten Skitouren im Nationalpark Berchtesgaden. Lawinenkunde und LVS-Suche in den Berchtesgadener Alpen.

Lawinen- und Skitourenkurs in den Berchtesgadener Alpen

Lawinengrundlagen und Skitourentechnik kompakt in einem Wochenende. Mit Bergführer die Grundlagen des Skitourengehens in der traumhaften Kulisse der Berchtesgadener Alpen erlernen.

Tiefschneekurs und Skitouren in Berchtesgaden

Praxisreiche Skitouren- und Tiefschneetage unweit des Watzmanns. Der perfekte Kombikurs im malerischen Berchtesgaden.

Tages-Skitour Kleine Reibn

Die mittelschwere Rundtour im Berchtesgadener Hagengebirge hinterlässt grandiose landschaftliche Eindrücke. Dich erwartet eine abwechslungsreiche Skitour mit einfachen Aufstiegen und steileren Abfahrten.

Skitour auf den Großvenediger

Skitouren-Wochenende am Großvenediger. Großvenediger-Besteigung von der Kürsinger Hütte aus.

Schneeschuh-Wochenende in Berchtesgaden

Am Fuße des Hohen Brett und Schneibstein lernst Du die Grundtechnik für Schneeschuhwanderungen. Die Berchtesgadener Alpen bieten nicht nur das geeignete Gelände, sondern zeichnen sich durch die eindrucksvolle Landschaft aus.

Kletterkurs Basiswoche Berchtesgaden

Alpin Klettern lernen rund um die Felswände der Blaueishütte. Klettern im Nachstieg, im Vorstieg und in Mehrseillängen

Watzmann Ostwand

Führung durch die mit 1.800 Metern höchste Wand der Ostalpen auf den Watzmann. Konditionell anspruchsvolle Klettertour mit traumhaftem Tiefblick.

Kletterkurs Sportklettern am Gardasee

Kletterkurs für Sportkletterer von der Halle an den Fels. Intensivkurs Felsklettern an den Felsen rund um Arco am Gardasee.

Klettersteigkurs in Berchtesgaden

Klettersteigkurs in Berchtesgaden. In 2 1/2 Tagen lernst Du alles rund ums Thema Klettersteig. Komfortables Hotel inklusive.

Watzmann Überschreitung

Die Watzmann Überschreitung. Begeisternde und konditionell anspruchsvolle Bergtour in Berchtesgaden.

Grünstein Klettersteig

Tages-Klettersteig für sportliche Bergsteiger am Grünstein "Isidor Klettersteig" in Berchtesgaden.

Schützensteig Jenner | Mit Laxersteig

Der neue Klettersteig in Berchtesgaden! Mit Bergführer klettern am Schützensteig mit Kombination aus Laxersteig (C) am Kleinen Jenner. Traumhafte Aussicht und ein Gipfelerlebnis über den Dächern von Berchtesgadens sind garantiert.

Die Untersbergrunde | Berchtesgaden

Wandern auf der aussichtsreichen Unterbergrunde. Geführte Bergwanderung auf dem mystischen Grenzberg zwischen Österreich und Deutschland. Herrliche Aussichten über den Berchtesgadener Talkessel und in die Salzburger Bergwelt erleben und genießen.

ready to go - Deine erste Bergwanderung

Im Einsteigerprogramm der „ready to go“ Wanderakademie begleiten wir Dich auf Deinen ersten Schritten beim Bergwandern.

Alpenüberquerung vom Watzmann zu den Drei Zinnen

Von Hütte zu Hütte in traumhafter Landschaft - die Alternative zur E5 Alpenüberquerung!

Wandern rund um den Königssee zum Watzmann

Wandern im Nationalpark Berchtesgaden. Von Hütte zu Hütte rund um den Königssee und auf den Watzmann Gipfel.

Wandern im Nationalpark Berchtesgaden

Wandern für alpine Einsteiger am Königssee und Watzmann. Traumhafte Wanderung von Hütte zu Hütte in den Berchtesgadener Alpen.

Die Watzmanntour

Wandern im Herzen des Nationalparks Berchtesgaden am Königssee und dem Watzmann.

Vom Königssee zum Gipfel des Watzmann | Mittelspitze

Kombination aus schwieriger Bergwanderung und einfachem Klettersteig zum Hauptgipfel des Watzmann | Mittelspitze.

Genusswandern in den Berchtesgadener Alpen

Ausgewählte Wanderungen im Nationalpark Berchtesgaden. Auf dieser Wanderung bringen wir Dich auf die schönsten Touren rund um Berchtesgaden. Vom Hotel aus bietet diese Tourenwoche die perfekte Möglichkeit Bergwandern mit all seinen Facetten zu erleben. Die Touren führen uns ein mal rund um den Berchtesgadener Talkessel

Watzmann Ostwand | Wandern in Berchtesgaden | Zu Fuß über die Alpen | Watzmann Überschreitung

Alpine Kompetenz in Berchtesgaden & am Watzmann

Die Berchtesgadener Bergführer führen Dich auf Bergwanderungen und anspruchsvollen Wegen rund um den Watzmann und den Königssee inmitten des Nationalpark Berchtesgaden. Im Mittelpunkt der Bergtouren im Berchtesgadener Land steht natürlich der Watzmann mit all seinen Spielarten, ob E-Bike and Climb, der beliebte Grünstein Klettersteig, oder die klassischen Wege durch die berühmte Watzmann Ostwand. In der Wanderakademie finden Einsteiger mit einem "Ready to Go" Kurs der Wanderakademie den passenden Einstieg in die Bergwelt. Mit einem unserer örtlichen Bergführer bist Du am Watzmann gut aufgehoben. BERGFÜHREN ist in Berchtesgaden Tradition und Leidenschaft. Der Watzmann ist unser Hausberg!

Last Minute am Watzmann

Schnapp Dir noch schnell einen Platz mit den Watzmannführern!

28.01. - 30.01.2022

Lawinen- und Skitourenkurs in den Berchtesgadener Alpen

Nahezu ausgebucht

29.01. - 11.02.2022

Mount Meru und Kilimanjaro | Machame Route

Nahezu ausgebucht

04.02. - 06.02.2022

Tiefschneekurs auf dem Stubaier Gletscher

Nahezu ausgebucht

04.02. - 06.02.2022

Lawinen- und Skitourenkurs in den Berchtesgadener Alpen

Noch 1 Platz frei

05.02. - 05.02.2022

Eisklettern Tageskurs

Noch 1 Platz frei

05.02. - 06.02.2022

Wochenend Skitourenkurs für Einsteiger in Berchtesgaden

Durchführungsgarantie ab 4 TN

06.02. - 12.02.2022

Tiefschneekurs und Skitourenwoche Heidelberger Hütte

Nahezu ausgebucht

10.02. - 13.02.2022

Schneeschuhtouren im Lechtal

Erste Buchungen vorhanden

10.02. - 13.02.2022

Tiefschneekurs und Skitouren im Nationalpark Berchtesgaden

Erste Buchungen vorhanden

11.02. - 13.02.2022

Lawinen- und Skitourenkurs in den Berchtesgadener Alpen

Erste Buchungen vorhanden

12.02. - 13.02.2022

Schneeschuh-Wochenende am Spitzingsee

Erste Buchungen vorhanden

12.02. - 13.02.2022

Wochenend Skitourenkurs für Einsteiger in Berchtesgaden

Erste Buchungen vorhanden

19.02. - 20.02.2022

Schneeschuh-Wochenende am Spitzingsee

Noch 1 Platz frei

26.02. - 27.02.2022

Wochenend Skitourenkurs für Einsteiger in Berchtesgaden

Nahezu ausgebucht

Berggeschehen | Neues | Hintergrund

Kurznachrichten aus den Bergen

Norwegen | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Norwegen

Schweiz | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung in die Schweiz . Besonderheiten, die bei einer Hüttenübernachtung in der Schweiz zu beachten sind.

Deutschland | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Deutschland. Besonderheiten, die bei einer Hüttenübernachtung in Deutschland zu beachten sind.

Österreich | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Österreich. Besonderheiten, die bei einer Hüttenübernachtung in Österreich zu beachten sind.

Italien | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Italien.Besonderheiten die bei einer Hüttenübernachtung in Italien zu beachten sind.

Frankreich | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Frankreich

Slowenien | Bergsport & Corona

Allgemeine Covid-19 Hinweise zur Reiseplanung für Slowenien.

Hallo Welt - Ich bin LARA die Lawinen App

LARA ist eine Lawinen App für Skitourengeher. LARA hilft Dir vor Ort bei Deiner Beurteilung der Schneedecke und zeigt Dir Handlungsmuster auf. LARA kann noch mehr

Bewahre die Alpen - Ein Leben als Bergführer

ZDF - planet e hat zwei Bergführer begleitet während ihrer dreijährigen Ausbidlung

Reisereportage im HR | Unterwegs mit Hansi Stöckl

Am 17.07. um 20.15 Uhr wird ein kleiner Beitrag im hr-fernsehen mit unserem Bergführer Hansi Stöckl aus Berchtesgaden gesendet.

Gutschein verschenken

Passend zu allen Anlässen. Verschenke Erlebnisse mit Bergführer!

#magazin

Reiseberichte, Inspirationen, Abenteuer, Berge und vieles mehr,...

Corona Sicherheit & Hygienekonzept

#4 | Seitwärts Abschneiden mit Kompass

Anpeilen eines bekannten Geländepunktes und Schneiden mit einer Höhenlinie, einem Bach, einer Straße oder einem Grat. So kann der eigene Standpunkt einfach bestimmt werden.

#3 | Rückwärts Einschneiden mit Kompass

Mit dieser Technik können zwei oder mehrere bekannte Ziele angepeilt werden und so der eigene Standort bestimmt werden.

#2 | Vorwärts Einschneiden mit Kompass

Vorwärts Einschneiden mit dem Kompass, um ein unbekanntes Geländemerkmal, wie z. B. einen Gipfel, zu bestimmen. Diese Technik funktioniert nur, wenn der eigene Standort bekannt ist.

#KENNSTDUSCHON ... die Alpenüberquerung von Salzburg nach Triest

#socialwall

#deinabenteuerbeginnt #alpineweltenfamilie #watzmannführer

am 15.11.2021

❗𝐑𝐮̈𝐜𝐤𝐫𝐮𝐟 𝐝𝐞𝐫 𝐕𝐞𝐫𝐛𝐢𝐧𝐝𝐮𝐧𝐠𝐬𝐦𝐢𝐭𝐭𝐞𝐥 𝐟𝐮̈𝐫 𝐊𝐥𝐞𝐭𝐭𝐞𝐫𝐬𝐭𝐞𝐢𝐠𝐞 𝐒𝐂𝐎𝐑𝐏𝐈𝐎 𝐄𝐀𝐒𝐇𝐎𝐎𝐊❗ "Betroffen sind ausschließlich Verbindungsmittel, die ab dem 1. Januar 2021 hergestellt und geliefert wurden und deren Seriennummer zwischen 21A 0000000 000 und 21I 9999999 999 liegt." #deinabenteuerbeginnt #alpineweltenfamilie #safetyfirst Petzl

am 27.09.2021

Vielen Dank DAV Sektion Berchtesgaden für einen reibungslosen Sommer 2021!! Danke an alle Hüttenwirte samt dem gesamten Hüttenteam für den unermüdlichen Einsatz. !!

am 14.09.2021

🥾 𝗪𝗮𝘁𝘇𝗺𝗮𝗻𝗻 𝗨̈𝗯𝗲𝗿𝘀𝗰𝗵𝗿𝗲𝗶𝘁𝘂𝗻𝗴 𝗯𝗲𝗶 𝗛𝗲𝗿𝗯𝘀𝘁𝘀𝘁𝗶𝗺𝗺𝘂𝗻𝗴 ⛰ Andreas Strasser startete bei perfektem Herbstwetter mit unserer Gruppe bei Sonnenaufgang die sehr lange, aber imposante Alpintour. Noch auf einfachen Wegen und Pfaden erreichten die vier den ersten Gipfel, das #Hocheck, bevor es über den abwechslungsreichen Grat zum höchsten Punkt des Watzmanns, die #Mittelspitze mit 2.713 m Höhe ging. Die Gruppe setzte den Weg Richtung #Südspitze (2.712 m) fort. Atemberaubende Tiefblicke Richtung Königssee und Wimbachgries, immer wieder mit Blick in die berüchtigte Watzmann-Ostwand, machten die Tour unglaublich eindrucksvoll. #deinabenteuerbeginnt #alpineweltenfamilie adidas TERREX Scarpa Deutschland Komperdell Exped Petzl #watzmannüberschreitung Watzmannhaus 1930 M Bergerlebnis Berchtesgaden movelo e-biking

am 18.08.2021

🧗 Kʟᴇᴛᴛᴇʀsᴛᴇɪɢ Tᴀɢᴇsᴛᴏᴜʀ: Sᴄʜᴜ̈ᴛᴢᴇɴsᴛᴇɪɢ Jᴇɴɴᴇʀ | Mɪᴛ Lᴀxᴇʀsᴛᴇɪɢ 🥾 Der neue #Klettersteig in Bergerlebnis Berchtesgaden. Andreas Wiedenmann kletterte mit einer motivierten Gruppe unseren den eindrucksvollen #Laxersteig im Angesicht des Watzmanns mit grandiosen Ausblicken auf das Berchtesgadener Land. Die Ambitionierten Klettersteig-Einsteiger wurden im Einstieg am Laxersteig mit einigen anspruchsvollen Passagen gefordert, bevor sie den abwechslungsreichen zweiten Teil im Familienklettersteig so richtig genießen könnten. Am Ende des Klettersteigs wartete der Kleine Jenner mit einem wunderschönen Gipfelkreuz und Gipfelerlebnis. #deinabenteuerbeginnt #alpineweltenfamilie adidas TERREX Scarpa Deutschland Komperdell Petzl Exped movelo e-biking

am 06.08.2021

🥾Dᴇʀ Kʟᴀssɪᴋᴇʀ: Dɪᴇ Wᴀᴛᴢᴍᴀɴɴ-Üʙᴇʀsᴄʜʀᴇɪᴛᴜɴɢ⛰ Unsere beiden Gruppen mit den Bergführer Christians hatten zwar kein ☀, jedoch hatten sie trockenes Wetter und ein spektakuläres Wolkenspiel zwischen dem #Watzmannhocheck #Watzmannsüdspitze und #Watzmannmittelspitze. Absolut fertig aber überaus stolz erreichte die Gruppe gesund und sehr zufrieden die Wimbachgriesbrücke. #deinabnetuerbeginnt #alpineweltenfamilie adidas TERREX Scarpa Deutschland Exped Petzl Komperdell #Watzmannhaus #Watzmann Bergerlebnis Berchtesgaden movelo e-biking

am 04.08.2021

⛰ Wᴀᴛᴢᴍᴀɴɴᴜ̈ʙᴇʀsᴄʜʀᴇɪᴛᴜɴɢ ᴜ̈ʙᴇʀ ᴅɪᴇ ᴅʀᴇɪ Gɪᴘғᴇʟ🥾 Wieder konnten wir eine Gruppe mit unserem Bergführer Pascal erfolgreich die abwechslungsreiche Gratüberschreitung vom Hocheck über die Mittel- bis zur Südspitze des Watzmanns meistern. Der Aufbruch zum ersten Watzmann-Gipfel, dem Hocheck, begann mit dem ersten Sonnenlicht früh am Morgen. Am Hocheck ist für die meisten Bergsteiger der Umkehrpunkt. Für unsere Gruppe begann hier die Herausforderung über den zum Teil mit Drahtseilen versicherten, luftigen Steig bis zum Hauptgipfel des Watzmanns, der Mittelspitze mit 2.713 m Höhe. Weiter geht es mit atemberaubenden Tiefblicken entlang des Grates und direkt über der Watzmann Ostwand bis zur Südspitze (2.712 m). #deinabenteuerbeginnt #alpineweltenfamilie adidas TERREX Scarpa Deutschland Petzl Komperdell Exped Bergerlebnis Berchtesgaden movelo e-biking #watzmannhaus

am 02.08.2021

🥾 E-Bɪᴋᴇ&Cʟɪᴍʙ | Dɪᴇ "Kʟᴇɪɴᴇ" Wᴀᴛᴢᴍᴀɴɴ Osᴛᴡᴀɴᴅ ⛰ Die "#Wiederroute" wird allgemein als "Kleine Watzmann Ostwand" bezeichnet. Landschaftlich übertrifft die Wiederroute den großen Bruder sogar! Der frühe Zustieg mit dem E-Bike, der Aufstieg ins wilde #Watzmannkar, vorbei an Trümmern eines Flugzeugwracks aus dem zweiten Weltkrieg und dann der eindrucksvolle Anstieg über das #Wiederband machte diese Klettertour auf den #Watzmann zu einer einzigartigen und eigenständigen Tour auf den Hauptgipfel des Watzmanns. Die Einblicke in die Watzmann Ostwand und der ständige, exponierte Blick auf den Königssee und die "Watzmann Kinder" waren für unseren Gast mit unserem Bergführer Pascal grandios! #deinabenteuerbeginnt #alpineweltenfamilie adidas TERREX Scarpa Deutschland Exped Petzl Komperdell Bergerlebnis Berchtesgaden movelo e-biking

🥾Wᴀᴛᴢᴍᴀɴɴᴜ̈ʙᴇʀsᴄʜʀᴇɪᴛᴜɴɢ ᴜ̈ʙᴇʀ ᴅɪᴇ ᴅʀᴇɪ Gɪᴘғᴇʟ☀️ Die #Watzmannüberschreitung ist eine sehr lange und abwechslungsreiche Gratüberschreitung vom #Hocheck über die #Mittel- bis zur #Südspitze des Watzmanns. Unser Bergführer Hansi konnte bei herrlichstem Wetter mit unseren drei fränkischen Gästen eine der großartigsten Gratüberschreitungen der Ostalpen mit wunderbaren Ausblicken auf den #Königssee und die umliegende Bergwelt im Nationalpark Berchtesgaden erleben. #deinabenteuerbeginnt #alpineweltenfamilie adidas TERREX Petzl Scarpa Deutschland Komperdell Exped Bergerlebnis Berchtesgaden #Watzmannhaus Watzmannhaus

Wandern im Berchtesgadener Land

Bergsteigen am Watzmann | Bergurlaub am Königssee

Die Bergführer & Bergwanderführer der Bergsteigerschule Watzmann kennen jeden Stock und Stein im Nationalpark Berchtesgaden. Auf geführten Wanderungen begleiten wir Dich beim Wandern rund um Berchtesgaden und zeigen Dir die schönsten Plätze zwischen Steinernem Meer - Königssee und unserem Wahrzeichen, dem Watzmann. Krönung unseres Wanderprogramms ist sicher die Alpenüberquerung vom Watzmann zu den Drei Zinnen. Von Nord nach Süd überqueren wir dabei die Alpen zu Fuß. Unsere Alpenüberquerung von Salzburg nach Triest ist ein Geheimtipp.

Ob es nun eine komfortable Wanderung mit Hotelstützpunkt oder eine Hüttenwanderung rund um den Königssees sein soll, entscheidest Du mit Deiner Wahl.

Höhere und anspruchsvollere Ziele für Bergsteiger wie z.B. die Watzmannüberschreitung oder die Watzmann Ostwand sind unser tägliches Brot. Als lokale Bergschule am Königssee kennen wir die Verhältnisse tagaktuell und können flexibel auf alle Eventualitäten reagieren.

Im Kursbereich erfreuen sich unsere Kletterkurse und Klettersteigkurse großer Beliebtheit. Die komfortable Unterbringung im klimaneutralen Explorer Hotel rundet jeden Ausbildungstag am Klettersteig angenehm ab. Hoch oben im Gebirge dient unsere Blaueishütte als Hüttenstützpunkt für Kletterkurse am Fels. Das Blaueis bietet einen idealen Stützpunkt für Einsteiger und Fortgeschrittene, die ihre ersten Schritte in der Vertikalen unternehmen, oder in alpinen Mehrseillängen sattelfester werden möchten.

Der Winter hat auch rund um den Königssee viel zu bieten. Schneeschuhwanderungen und Skitourenkurse laden zum Verweilen im Berchtesgadener Land ein. Selbst bei schlechtem Wetter bietet unsere Region dann eine Fülle von Alternativen. Mit dem Besuch im Salzbergwerk sogar unter Tage.

Cookie Einstellungen

Wir setzen automatisiert nur technisch notwendige Cookies, deren Daten von uns nicht weitergegeben werden und ausschließlich zur Bereitstellung der Funktionalität dieser Seite dienen.

Außerdem verwenden wir Cookies, die Dein Verhalten beim Besuch der Webseiten messen, um das Interesse unserer Besucher besser kennen zu lernen. Wir erheben dabei nur pseudonyme Daten, eine Identifikation Deiner Person erfolgt nicht.

Weitere Informationen findest Du in unserer Datenschutzerklärung.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent702e6d7fd00a6f14bcc094a4c956d69f
  time1643274873
  countdown10
- _Token(array)
  key60b4e869c3dcc41a13c2b8f1f5bfd4e7b1fec193e962545de0c2c9bc5d5bcc0da2affe155fe3c4985623b0b3e865e6ceb194badd5de56bff971452d0bcc21e1e
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  60b4e869c3dcc41a13c2b8f1f5bfd4e7b1fec193e962545de0c2c9bc5d5bcc0da2affe155fe3c4985623b0b3e865e6ceb194badd5de56bff971452d0bcc21e1e1643262273
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  0184
- ids(array)
  Menu184
  Content(null)
  Language3
- route(array)
  id983
  hash143a6410f54dd1f9c9658128a652130b
  created2017-01-30 13:03:30
  updated2020-10-28 14:13:42
  modelMenu
  foreign_key184
  base/wf/
  aliasberchtesgaden
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id982
  lft3331
  rght3388
  route/wf/berchtesgaden
- isAjax(false)
- _Token(array)
  key60b4e869c3dcc41a13c2b8f1f5bfd4e7b1fec193e962545de0c2c9bc5d5bcc0da2affe155fe3c4985623b0b3e865e6ceb194badd5de56bff971452d0bcc21e1e
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(null)
  actionindex
- template/*
====

Sql Log

Sql Logs

default

Total Time: 359 ms
Total Queries: 380 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 276 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	4	4	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 276 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4636) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 146	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 146 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 146 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	2	2	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 146 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1526) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 140	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 140 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 140 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	2	2	0
SELECT `TourMainType`.`id`, `TourMainType`.`hash`, `TourMainType`.`created`, `TourMainType`.`updated`, `TourMainType`.`title`, `TourMainType`.`position`, `TourMainType`.`packing_list_text_start`, `TourMainType`.`packing_list_text_end` FROM `alpinewelten`.`tour_main_types` AS `TourMainType` WHERE `TourMainType`.`id` = 2	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'TourMainType' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 140 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4657) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 144	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 144 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 144 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	3	3	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 144 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1440) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	16	16	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 122	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 122 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 122 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	2	2	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 122 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2049) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 153	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 153 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 153 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	3	3	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 153 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1433) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	16	16	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 293	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 293 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 293 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 293 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5549) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 373	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 373 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 373 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 373 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (7584) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 151	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 151 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 151 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 151 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1707) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 141	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 141 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 141 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	2	2	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 141 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2063) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	16	16	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 235	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 235 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 235 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	3	3	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 235 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3573) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	15	15	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 117	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 117 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 117 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 117 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2187) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 305	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 305 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 305 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	3	3	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 305 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4627) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	20	20	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'highlights' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/text-zweispaltig' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3354 AND `Route`.`rght` >= 3355 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2688 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	4	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4880 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 153 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 153 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 3389 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 3389 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 1003 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 1003 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 152 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 152 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 951 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 951 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 2302 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 2302 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/last-minute-slider' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3356 AND `Route`.`rght` >= 3357 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive` FROM `alpinewelten`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND `Content`.`id` = 2689 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `BackgroundImageMedia`.`id`, `BackgroundImageMedia`.`hash`, `BackgroundImageMedia`.`created`, `BackgroundImageMedia`.`updated`, `BackgroundImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) AS `BackgroundImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `BackgroundImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2689 AND `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'background_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2594) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	0
SELECT `TourDate`.`id`, `TourDate`.`hash`, `TourDate`.`created`, `TourDate`.`updated`, `TourDate`.`status`, `TourDate`.`tour_id`, `TourDate`.`tour_date_number`, `TourDate`.`title`, `TourDate`.`subtitle`, `TourDate`.`participants_min`, `TourDate`.`participants_max`, `TourDate`.`duration_days`, `TourDate`.`tour_price`, `TourDate`.`down_payment`, `TourDate`.`country_of_service`, `TourDate`.`saison`, `TourDate`.`travel_insurance_certificate`, `TourDate`.`rating_condition`, `TourDate`.`rating_technique`, `TourDate`.`rating_experience`, `TourDate`.`rating_difficulty_category`, `TourDate`.`start_zip`, `TourDate`.`start_city`, `TourDate`.`start_street`, `TourDate`.`start_country`, `TourDate`.`start_meeting_point`, `TourDate`.`start_time`, `TourDate`.`end_alternate_address`, `TourDate`.`end_time`, `TourDate`.`flight`, `TourDate`.`flight_details`, `TourDate`.`region_id`, `TourDate`.`date_start`, `TourDate`.`mountain_guide_status`, `TourDate`.`manual_booking_status`, `TourDate`.`participant_list_visible`, `TourDate`.`speciality`, `TourDate`.`special_features`, `TourDate`.`mountain_guide_tour_info`, `TourDate`.`customer_tour_info`, `TourDate`.`ws_text_requirements`, `TourDate`.`ws_text_travel_program`, `TourDate`.`ws_text_accomodation`, `TourDate`.`ws_text_services`, `TourDate`.`rating_seriousness`, `TourDate`.`rating_overall_score`, `TourDate`.`infotext_booking`, `TourDate`.`last_minute`, `TourDate`.`travel_information`, `TourDate`.`meeting_point_map_lat`, `TourDate`.`meeting_point_map_marker`, `TourDate`.`meeting_point_map_type`, `TourDate`.`meeting_point_map_zoom`, `TourDate`.`meeting_point_map_long`, `TourDate`.`participant_list_visible2`, `TourDate`.`cancelled`, `TourDate`.`days_before_start_for_last_notice`, `TourDate`.`execution_feasibility`, `TourDate`.`days_before_start_for_cancellation`, `TourDate`.`ws_text_overview`, `TourDate`.`mountain_guide_tour_search_information`, `TourDate`.`allow_double_assignment`, `TourDate`.`customer_tour_material_info`, `TourDate`.`material_list_link`, `TourDate`.`minimum_reached_notification`, `TourDate`.`c19_cancellation`, `TourDate`.`ws_text_course_content`, `TourDate`.`ws_text_information`, `TourDate`.`gmap_marker`, `TourDate`.`ws_text_short_description`, `TourDate`.`gmap_type`, `TourDate`.`gmap_zoom`, `TourDate`.`ws_text_location_description`, `TourDate`.`ws_text_detail_description`, `TourDate`.`gmap_lat`, `TourDate`.`gmap_long`, `TourDate`.`callout_icon_multiple`, `TourDate`.`ws_text_advantages`, `TourDate`.`ws_text_detail_description_new`, `TourDate`.`ws_text_information_new`, `TourDate`.`ws_text_accomodation_new`, (CONCAT_WS (',',`TourDate`.`gmap_lat`,`TourDate`.`gmap_long`)) AS `TourDate__gmap`, (CONCAT_WS (',',`TourDate`.`meeting_point_map_lat`,`TourDate`.`meeting_point_map_long`)) AS `TourDate__meeting_point_map`, (COALESCE(`TourDate`.`end_zip`, `TourDate`.`start_zip`)) AS `TourDate__end_zip`, (COALESCE(`TourDate`.`end_city`, `TourDate`.`start_city`)) AS `TourDate__end_city`, (COALESCE(`TourDate`.`end_street`, `TourDate`.`start_street`)) AS `TourDate__end_street`, (COALESCE(`TourDate`.`end_country`, `TourDate`.`start_country`)) AS `TourDate__end_country`, (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) AS `TourDate__date_end`, (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')) AS `TourDate__count_participants`, (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`) AS `TourDate__count_mountain_guides`, (`TourDate`.`date_start` <= "2022-09-30" AND (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) >= "2022-06-01") AS `TourDate__peak_season`, (CONCAT((SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')), " + " , (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`))) AS `TourDate__participants_booked`, (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "bookings_present" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= 1 ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = 0 ) THEN 0 END)))WHEN 0 THEN "places_free" WHEN 1 THEN "bookings_present" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" END) AS `TourDate__booking_status`, ( IF( `TourDate`.`cancelled`, 'canceled', IF((SELECT SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) > 0 AND SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) = SUM(IF(`Booking`.`status` NOT IN ('new_from_website', 'waiting_list', 'called_off', 'canceled'), 1, 0)) FROM bookings AS Booking WHERE `Booking`.`tour_date_id` = `TourDate`.`id`), 'completed', 'in_process') )) AS `TourDate__processing_status`, (`TourDate`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tour_dates AS TourTravelOptionXTourDates inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTourDates`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTourDates`.`tour_date_id` = `TourDate`.`id`), 0)) AS `TourDate__price_excl_flight`, `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight` FROM `alpinewelten`.`tour_dates` AS `TourDate` LEFT JOIN `alpinewelten`.`tours` AS `Tour` ON (`TourDate`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`firms_tours` AS `FirmsTour` ON (`FirmsTour`.`tour_id` = `Tour`.`id` AND `FirmsTour`.`firm_id` = '3') WHERE (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "bookings_present" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= 1 ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = 0 ) THEN 0 END)))WHEN 0 THEN "places_free" WHEN 1 THEN "bookings_present" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" END) != 'booked_up' AND `TourDate`.`last_minute` = '1' AND `TourDate`.`status` = 'active' AND `TourDate`.`date_start` > CURDATE() ORDER BY `TourDate`.`date_start` ASC LIMIT 40	14	14	274	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 73 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 44 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 197 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 34 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 196 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 52 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'last_minute_tour_index' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/news-einleitung' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3358 AND `Route`.`rght` >= 3359 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2690 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4882 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/news-slider' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3360 AND `Route`.`rght` >= 3361 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2691 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4883 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `News`.`id`, `News`.`title`, `News`.`type`, `News`.`publishing_date`, `News`.`external_url`, `News`.`target`, `News`.`safety`, `News`.`travel_warning`, `News`.`is_updated`, `User`.*, `Teaser`.`id`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Menu`.`id`, `User`.`id` FROM `alpinewelten`.`news` AS `News` LEFT JOIN `alpinewelten`.`menus` AS `Menu` ON (`News`.`menu_id` = `Menu`.`id`) LEFT JOIN `alpinewelten`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `News`.`id` AND `Teaser`.`model` = 'News') LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `News`.`id` AND `Route`.`model` = 'News') JOIN `alpinewelten`.`firms_news` AS `FirmsNews` ON (`FirmsNews`.`news_id` = `News`.`id` AND `FirmsNews`.`firm_id` = '3') WHERE `News`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`News`.`release`, NOW()) AND COALESCE(`News`.`hide`, NOW())) = '1' AND `News`.`visibility_website` = '1' GROUP BY `News`.`id` ORDER BY `publishing_date` DESC LIMIT 10	10	10	2	maybe slow
SELECT `AvatarWebsiteUpload`.`id`, `AvatarWebsiteUpload`.`hash`, `AvatarWebsiteUpload`.`created`, `AvatarWebsiteUpload`.`updated`, `AvatarWebsiteUpload`.`model`, `AvatarWebsiteUpload`.`field`, `AvatarWebsiteUpload`.`foreign_key`, `AvatarWebsiteUpload`.`alias`, `AvatarWebsiteUpload`.`thumbnail`, `AvatarWebsiteUpload`.`parent_id`, `AvatarWebsiteUpload`.`file`, `AvatarWebsiteUpload`.`size`, `AvatarWebsiteUpload`.`ext`, `AvatarWebsiteUpload`.`mime`, `AvatarWebsiteUpload`.`width`, `AvatarWebsiteUpload`.`height` FROM `alpinewelten`.`uploads` AS `AvatarWebsiteUpload` WHERE `AvatarWebsiteUpload`.`model` = 'User' AND `AvatarWebsiteUpload`.`field` = 'avatar_website' AND `AvatarWebsiteUpload`.`foreign_key` = (25) ORDER BY FIELD(COALESCE(`AvatarWebsiteUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `AvatarWebsiteUpload`.`id`, `AvatarWebsiteUpload`.`hash`, `AvatarWebsiteUpload`.`created`, `AvatarWebsiteUpload`.`updated`, `AvatarWebsiteUpload`.`model`, `AvatarWebsiteUpload`.`field`, `AvatarWebsiteUpload`.`foreign_key`, `AvatarWebsiteUpload`.`alias`, `AvatarWebsiteUpload`.`thumbnail`, `AvatarWebsiteUpload`.`parent_id`, `AvatarWebsiteUpload`.`file`, `AvatarWebsiteUpload`.`size`, `AvatarWebsiteUpload`.`ext`, `AvatarWebsiteUpload`.`mime`, `AvatarWebsiteUpload`.`width`, `AvatarWebsiteUpload`.`height` FROM `alpinewelten`.`uploads` AS `AvatarWebsiteUpload` WHERE `AvatarWebsiteUpload`.`model` = 'User' AND `AvatarWebsiteUpload`.`field` = 'avatar_website' AND `AvatarWebsiteUpload`.`foreign_key` = (27) ORDER BY FIELD(COALESCE(`AvatarWebsiteUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3519 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (60) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3322 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (972) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	15	15	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3321 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2448) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3313 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (345) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3323 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5600) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3324 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (167) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3569 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2617) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4039 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10355) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3193 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6580) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3875 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1136) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 66 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 62 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 61 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 60 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 63 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 64 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 76 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 102 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 55 AND `Route`.`model` = 'News'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 78 AND `Route`.`model` = 'News'	1	1	0
SELECT `Audit`.`id`, `Audit`.`event`, `Audit`.`model`, `Audit`.`alias`, `Audit`.`entity_id`, `Audit`.`json_object`, `Audit`.`description`, `Audit`.`source_id`, `Audit`.`created` FROM `alpinewelten`.`audits` AS `Audit` WHERE `model` = 'News.News' AND `Audit`.`event` = 'CREATE' AND `Audit`.`entity_id` IN (66, 62, 61, 60, 63, 64, 76, 102, 55, 78)	10	10	0
SELECT `User`.`id`, `User`.`hash`, `User`.`created`, `User`.`updated`, `User`.`activity`, `User`.`group_id`, `User`.`status`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`lastname`, `User`.`email`, `User`.`limit`, `User`.`language`, `User`.`email_signature`, `User`.`telephone`, `User`.`dept_for_trigger_mail`, `User`.`expert_text` FROM `alpinewelten`.`users` AS `User` WHERE `User`.`id` = 25	1	1	0
SELECT `User`.`id`, `User`.`hash`, `User`.`created`, `User`.`updated`, `User`.`activity`, `User`.`group_id`, `User`.`status`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`lastname`, `User`.`email`, `User`.`limit`, `User`.`language`, `User`.`email_signature`, `User`.`telephone`, `User`.`dept_for_trigger_mail`, `User`.`expert_text` FROM `alpinewelten`.`users` AS `User` WHERE `User`.`id` = 23	1	1	0
SELECT `AvatarWebsiteUpload`.`id`, `AvatarWebsiteUpload`.`hash`, `AvatarWebsiteUpload`.`created`, `AvatarWebsiteUpload`.`updated`, `AvatarWebsiteUpload`.`model`, `AvatarWebsiteUpload`.`field`, `AvatarWebsiteUpload`.`foreign_key`, `AvatarWebsiteUpload`.`alias`, `AvatarWebsiteUpload`.`thumbnail`, `AvatarWebsiteUpload`.`parent_id`, `AvatarWebsiteUpload`.`file`, `AvatarWebsiteUpload`.`size`, `AvatarWebsiteUpload`.`ext`, `AvatarWebsiteUpload`.`mime`, `AvatarWebsiteUpload`.`width`, `AvatarWebsiteUpload`.`height` FROM `alpinewelten`.`uploads` AS `AvatarWebsiteUpload` WHERE `AvatarWebsiteUpload`.`model` = 'User' AND `AvatarWebsiteUpload`.`field` = 'avatar_website' AND `AvatarWebsiteUpload`.`foreign_key` = (23) ORDER BY FIELD(COALESCE(`AvatarWebsiteUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `FileMedia`.`id`, `FileMedia`.`hash`, `FileMedia`.`created`, `FileMedia`.`updated`, `FileMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `FileMedia`.`id`) AS `FileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `FileMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (66, 62, 61, 60, 63, 64, 76, 102, 55, 78) AND `MediaEntity`.`media_id` = `FileMedia`.`id`) WHERE `MediaEntity`.`model` = 'News' AND `MediaEntity`.`field` = 'file' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` IN (66, 62, 61, 60, 63, 64, 76, 102, 55, 78) AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'News' AND `TagEntity`.`field` = 'tags'	10	10	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'news' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/gutscheine-einleitung' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3362 AND `Route`.`rght` >= 3363 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2692 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4884 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/gutschein-teaser' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3364 AND `Route`.`rght` >= 3365 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive` FROM `alpinewelten`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND `Content`.`id` = 2693 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `BackgroundImageMedia`.`id`, `BackgroundImageMedia`.`hash`, `BackgroundImageMedia`.`created`, `BackgroundImageMedia`.`updated`, `BackgroundImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) AS `BackgroundImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `BackgroundImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2693 AND `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'background_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4661) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'coupons' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/magazin-slider' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3366 AND `Route`.`rght` >= 3367 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive` FROM `alpinewelten`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND `Content`.`id` = 2694 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `BackgroundImageMedia`.`id`, `BackgroundImageMedia`.`hash`, `BackgroundImageMedia`.`created`, `BackgroundImageMedia`.`updated`, `BackgroundImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) AS `BackgroundImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `BackgroundImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2694 AND `MediaEntity`.`media_id` = `BackgroundImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'background_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `TravelReport`.`id`, `TravelReport`.`hash`, `TravelReport`.`created`, `TravelReport`.`updated`, `TravelReport`.`title`, `TravelReport`.`status`, `TravelReport`.`release`, `TravelReport`.`hide`, `TravelReport`.`alias`, `TravelReport`.`country_id`, `TravelReport`.`tour_id`, `TravelReport`.`user_id`, `TravelReport`.`publishing_date`, `TravelReport`.`menu_id`, (NOW() BETWEEN COALESCE(`TravelReport`.`release`, NOW()) AND COALESCE(`TravelReport`.`hide`, NOW())) AS `TravelReport__published`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `alpinewelten`.`travel_reports` AS `TravelReport` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `TravelReport`.`id` AND `Route`.`model` = 'TravelReport') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `TravelReport`.`id` AND `Teaser`.`model` = 'TravelReport') JOIN `alpinewelten`.`firms_travel_reports` AS `FirmsTravelReport` ON (`FirmsTravelReport`.`travel_report_id` = `TravelReport`.`id` AND `FirmsTravelReport`.`firm_id` = '3') WHERE `TravelReport`.`status` = 'active' ORDER BY `TravelReport`.`publishing_date` DESC LIMIT 5	5	5	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2856 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9129) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4052 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10401) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4051 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10400) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4050 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10399) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4110 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6774) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	16	16	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'travel_reports_index' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/ueberschrift-social-wall' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3368 AND `Route`.`rght` >= 3369 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2698 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4890 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/social-wall-slider' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3370 AND `Route`.`rght` >= 3371 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2695 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4887 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'social-wall' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/ueberschrift-wandern-bgd' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3372 AND `Route`.`rght` >= 3373 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2697 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	4	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4889 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 9326 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9326) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9326 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/wf/berchtesgaden/text-wandern-in-bgd' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 3374 AND `Route`.`rght` >= 3375 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`teaser_external_url`, `Content`.`teaser_menu_id`, `Content`.`developer_template_js`, `Content`.`mosaic_gallery_type`, `Content`.`teaser_tour_id`, `Content`.`mountain_guide_tour_search_show_until_days`, `Content`.`facebook_page_id`, `Content`.`facebook_access_token`, `Content`.`instagram_access_token`, `Content`.`facebook_posts_limit`, `Content`.`instagram_posts_limit`, `Content`.`country_id`, `Content`.`box`, `Content`.`gallery_grid_gutter`, `Content`.`box_with_bar`, `Content`.`background_color`, `Content`.`customer_news`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`contents` AS `Content` LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2696 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4888 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 158 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 158 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 2623 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 2623 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`id` = 2241 LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 2241 LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 984 LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'myclimate' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 25.02 MB

Message	Memory use
Component initialization	2.34 MB
Controller action start	6.27 MB
Controller render start	6.62 MB
Component initialization #2	8.89 MB
Controller action start #2	9.33 MB
Controller render start #2	9.48 MB
Component initialization #3	9.69 MB
Controller action start #3	9.73 MB
Controller render start #3	9.84 MB
Component initialization #4	10.14 MB
Controller action start #4	10.18 MB
Controller render start #4	12.36 MB
Component initialization #5	12.79 MB
Controller action start #5	12.83 MB
Controller render start #5	12.94 MB
Component initialization #6	13.20 MB
Controller action start #6	13.24 MB
Controller render start #6	12.50 MB
Component initialization #7	12.77 MB
Controller action start #7	12.81 MB
Controller render start #7	12.93 MB
Component initialization #8	13.13 MB
Controller action start #8	13.17 MB
Controller render start #8	13.84 MB
Component initialization #9	14.13 MB
Controller action start #9	14.18 MB
Controller render start #9	14.29 MB
Component initialization #10	14.50 MB
Controller action start #10	14.54 MB
Controller render start #10	14.68 MB
Component initialization #11	14.93 MB
Controller action start #11	14.98 MB
Controller render start #11	15.28 MB
Component initialization #12	15.52 MB
Controller action start #12	15.56 MB
Controller render start #12	15.68 MB
Component initialization #13	15.88 MB
Controller action start #13	15.93 MB
Controller render start #13	16.10 MB
Component initialization #14	16.44 MB
Controller action start #14	16.48 MB
Controller render start #14	16.59 MB
Component initialization #15	16.81 MB
Controller action start #15	16.85 MB
Controller render start #15	16.97 MB
View render complete	17.90 MB

Timers

Total Request Time: 3047 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	92.05
Event: Controller.initialize	142.42
Event: Controller.startup	3.86
Controller action	14.43
Event: Controller.beforeRender	121.81
» Processing toolbar data	28.61
Rendering View	2555.86
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	2401.49
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	2400.39
» » » Event: Controller.initialize #2	2.62
» » » Event: Controller.startup #2	0.18
» » » Controller action #2	4.40
» » » Event: Controller.beforeRender #2	74.43
» » » » Processing toolbar data #2	72.30
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.03
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	1.84
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.40
» » » » Event: View.afterRender	0.04
» » » » Event: Controller.shutdown	0.02
» » » » Event: Controller.initialize #3	2.53
» » » » Event: Controller.startup #3	0.18
» » » » Controller action #3	4.70
» » » » Event: Controller.beforeRender #3	16.59
» » » » » Processing toolbar data #3	14.73
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.03
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	6.37
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.34
» » » » » Event: View.afterRender #2	0.03
» » » » » Event: Controller.shutdown #2	0.02
» » » » » Event: Controller.initialize #4	2.41
» » » » » Event: Controller.startup #4	0.17
» » » » » Controller action #4	48.51
» » » » » Event: Controller.beforeRender #4	18.64
» » » » » » Processing toolbar data #4	16.78
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.03
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/highlights_slider.php	81.68
» » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser_slider.php	81.02
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php	1.63
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.49
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #2	2.08
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #2	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php	0.55
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #3	2.06
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #3	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #2	0.51
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #4	2.05
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #4	0.44
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #3	0.55
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #5	1.84
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #5	0.42
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #4	0.40
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #6	2.06
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #6	0.39
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #5	0.40
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #7	1.77
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #7	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #6	0.39
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #8	2.06
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #8	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #7	0.61
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #9	2.13
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #9	0.44
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #8	0.61
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #10	1.95
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #10	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #9	0.50
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #11	2.06
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #11	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #10	0.61
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #12	2.15
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #12	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #11	0.68
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #13	1.26
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #13	0.40
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #14	1.97
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #14	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #12	0.50
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #15	1.85
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #15	0.39
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #13	0.40
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #16	2.15
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #16	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #14	0.68
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #17	2.24
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #17	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #15	0.78
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #18	2.12
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #18	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #16	0.60
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #19	2.16
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #19	0.40
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #17	0.69
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #20	1.17
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #20	0.40
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #21	1.22
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #21	0.45
» » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php #22	1.18
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php #22	0.41
» » » » » » » » Rendering APP/View/Elements/icon.php	9.36
» » » » » » » » Rendering APP/View/Elements/icon.php #2	0.55
» » » » » » » » Rendering APP/View/Elements/icon.php #3	0.49
» » » » » » » » Rendering APP/View/Elements/icon.php #4	0.49
» » » » » » » » Rendering APP/View/Elements/icon.php #5	0.48
» » » » » » » » Rendering APP/View/Elements/icon.php #6	0.49
» » » » » » » » Rendering APP/View/Elements/icon.php #7	0.54
» » » » » » » » Rendering APP/View/Elements/icon.php #8	8.98
» » » » » » » » Rendering APP/View/Elements/icon.php #9	9.15
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.33
» » » » » » Event: View.afterRender #3	0.03
» » » » » » Event: Controller.shutdown #3	0.02
» » » » » » Event: Controller.initialize #5	2.43
» » » » » » Event: Controller.startup #5	0.18
» » » » » » Controller action #5	4.59
» » » » » » Event: Controller.beforeRender #5	17.83
» » » » » » » Processing toolbar data #5	15.97
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.03
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	5.85
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.49
» » » » » » » Event: View.afterRender #4	0.05
» » » » » » » Event: Controller.shutdown #4	0.03
» » » » » » » Event: Controller.initialize #6	2.83
» » » » » » » Event: Controller.startup #6	0.19
» » » » » » » Controller action #6	282.85
» » » » » » » Event: Controller.beforeRender #6	28.50
» » » » » » » » Processing toolbar data #6	26.25
Rendering View #6	0.00
» » » » » » » » Event: View.beforeRender #6	0.04
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/last_minute_tour_slider.php	49.30
» » » » » » » » » Rendering APP/View/Elements/icon.php #10	9.48
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php	0.49
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #2	0.39
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #3	0.34
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #4	0.38
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #5	0.35
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #6	0.35
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #7	0.33
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #8	0.34
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #9	0.38
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #10	0.35
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #11	0.37
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #12	0.33
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #13	0.96
» » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_date.php #14	0.35
» » » » » » » » » Rendering APP/View/Elements/icon.php #11	9.11
» » » » » » » » » Rendering APP/View/Elements/icon.php #12	9.10
» » » » » » » » » Rendering APP/View/Elements/icon.php #13	9.34
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.34
» » » » » » » » Event: View.afterRender #5	0.04
» » » » » » » » Event: Controller.shutdown #5	0.02
» » » » » » » » Event: Controller.initialize #7	2.58
» » » » » » » » Event: Controller.startup #7	0.19
» » » » » » » » Controller action #7	4.48
» » » » » » » » Event: Controller.beforeRender #7	30.31
» » » » » » » » » Processing toolbar data #7	28.42
Rendering View #7	0.00
» » » » » » » » » Event: View.beforeRender #7	0.03
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #4	0.75
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #6	0.31
» » » » » » » » » Event: View.afterRender #6	0.03
» » » » » » » » » Event: Controller.shutdown #6	0.02
» » » » » » » » » Event: Controller.initialize #8	2.56
» » » » » » » » » Event: Controller.startup #8	0.19
» » » » » » » » » Controller action #8	24.43
» » » » » » » » » Event: Controller.beforeRender #8	34.65
» » » » » » » » » » Processing toolbar data #8	32.54
Rendering View #8	0.00
» » » » » » » » » » Event: View.beforeRender #8	0.04
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/news_slider.php	49.96
» » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser_slider.php #2	49.27
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #23	2.08
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php	0.47
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #18	0.52
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #24	1.89
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #2	0.39
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #19	0.51
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #25	1.78
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #3	0.39
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #20	0.40
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #26	1.98
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #4	0.39
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #21	0.60
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #27	1.89
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #5	0.40
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #22	0.50
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #28	1.89
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #6	0.39
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #23	0.51
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #29	1.78
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #7	0.39
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #24	0.40
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #30	1.89
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #8	0.49
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php #25	0.41
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #31	1.23
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #9	0.40
» » » » » » » » » » » » Rendering APP/Plugin/FrontendNews/View/Elements/teaser.php #32	1.21
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/author.php #10	0.40
» » » » » » » » » » » » Rendering APP/View/Elements/icon.php #14	9.30
» » » » » » » » » » » » Rendering APP/View/Elements/icon.php #15	9.03
» » » » » » » » » » » » Rendering APP/View/Elements/icon.php #16	9.03
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7	0.32
» » » » » » » » » » Event: View.afterRender #7	0.04
» » » » » » » » » » Event: Controller.shutdown #7	0.04
» » » » » » » » » » Event: Controller.initialize #9	2.44
» » » » » » » » » » Event: Controller.startup #9	0.18
» » » » » » » » » » Controller action #9	4.74
» » » » » » » » » » Event: Controller.beforeRender #9	28.09
» » » » » » » » » » » Processing toolbar data #9	25.96
Rendering View #9	0.00
» » » » » » » » » » » Event: View.beforeRender #9	0.04
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #5	0.86
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #8	0.32
» » » » » » » » » » » Event: View.afterRender #8	0.03
» » » » » » » » » » » Event: Controller.shutdown #8	0.02
» » » » » » » » » » » Event: Controller.initialize #10	2.44
» » » » » » » » » » » Event: Controller.startup #10	0.18
» » » » » » » » » » » Controller action #10	1.78
» » » » » » » » » » » Event: Controller.beforeRender #10	14.20
» » » » » » » » » » » » Processing toolbar data #10	12.36
Rendering View #10	0.00
» » » » » » » » » » » » Event: View.beforeRender #10	0.03
» » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/coupon_teaser.php	10.76
» » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #17	9.13
» » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #9	0.33
» » » » » » » » » » » » Event: View.afterRender #9	0.03
» » » » » » » » » » » » Event: Controller.shutdown #9	0.02
» » » » » » » » » » » » Event: Controller.initialize #11	2.50
» » » » » » » » » » » » Event: Controller.startup #11	0.19
» » » » » » » » » » » » Controller action #11	7.89
» » » » » » » » » » » » Event: Controller.beforeRender #11	14.42
» » » » » » » » » » » » » Processing toolbar data #11	12.48
Rendering View #11	0.00
» » » » » » » » » » » » » Event: View.beforeRender #11	0.04
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/travel_reports_slider.php	39.95
» » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #18	9.20
» » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #19	9.12
» » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #20	9.02
» » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #21	9.18
» » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #10	0.32
» » » » » » » » » » » » » Event: View.afterRender #10	0.04
» » » » » » » » » » » » » Event: Controller.shutdown #10	0.02
» » » » » » » » » » » » » Event: Controller.initialize #12	2.46
» » » » » » » » » » » » » Event: Controller.startup #12	0.19
» » » » » » » » » » » » » Controller action #12	4.49
» » » » » » » » » » » » » Event: Controller.beforeRender #12	11.06
» » » » » » » » » » » » » » Processing toolbar data #12	9.18
Rendering View #12	0.00
» » » » » » » » » » » » » » Event: View.beforeRender #12	0.03
» » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #6	0.77
» » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #11	0.31
» » » » » » » » » » » » » » Event: View.afterRender #11	0.03
» » » » » » » » » » » » » » Event: Controller.shutdown #11	0.02
» » » » » » » » » » » » » » Event: Controller.initialize #13	2.38
» » » » » » » » » » » » » » Event: Controller.startup #13	0.18
» » » » » » » » » » » » » » Controller action #13	1109.89
» » » » » » » » » » » » » » Event: Controller.beforeRender #13	11.69
» » » » » » » » » » » » » » » Processing toolbar data #13	9.50
Rendering View #13	0.00
» » » » » » » » » » » » » » » Event: View.beforeRender #13	0.04
» » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/social_media_slider.php	216.19
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #22	9.16
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #23	9.00
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #24	8.81
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #25	8.99
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #26	8.91
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #27	8.90
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #28	8.90
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #29	8.87
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #30	8.88
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #31	9.02
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #32	8.85
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #33	8.88
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #34	8.88
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #35	8.92
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #36	8.91
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #37	8.82
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #38	8.92
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #39	8.99
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #40	8.87
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #41	8.77
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #42	8.93
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #43	9.20
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #44	9.83
» » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #12	0.38
» » » » » » » » » » » » » » » Event: View.afterRender #12	0.05
» » » » » » » » » » » » » » » Event: Controller.shutdown #12	0.03
» » » » » » » » » » » » » » » Event: Controller.initialize #14	2.84
» » » » » » » » » » » » » » » Event: Controller.startup #14	0.20
» » » » » » » » » » » » » » » Controller action #14	4.71
» » » » » » » » » » » » » » » Event: Controller.beforeRender #14	9.98
» » » » » » » » » » » » » » » » Processing toolbar data #14	8.00
Rendering View #14	0.00
» » » » » » » » » » » » » » » » Event: View.beforeRender #14	0.04
» » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #7	2.11
» » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #13	0.39
» » » » » » » » » » » » » » » » Event: View.afterRender #13	0.04
» » » » » » » » » » » » » » » » Event: Controller.shutdown #13	0.02
» » » » » » » » » » » » » » » » Event: Controller.initialize #15	2.65
» » » » » » » » » » » » » » » » Event: Controller.startup #15	0.21
» » » » » » » » » » » » » » » » Controller action #15	4.74
» » » » » » » » » » » » » » » » Event: Controller.beforeRender #15	10.02
» » » » » » » » » » » » » » » » » Processing toolbar data #15	8.06
Rendering View #15	0.00
» » » » » » » » » » » » » » » » » Event: View.beforeRender #15	0.04
» » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #8	3.50
» » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #14	0.35
» » » » » » » » » » » » » » » » » Event: View.afterRender #14	0.04
» » » » » » » » » » » » » » » » » Event: Controller.shutdown #14	0.02
» » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #15	0.34
» » » » » » » » » » » » » » » Event: View.afterRender #15	0.34
» » » » » » » » » » » » » » » Event: View.beforeLayout	0.02
» » » » » » » » » » » » » » » Rendering APP/View/Layouts/3.php	151.18
» » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.82
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/header/header_home.php	61.35
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header/header_navbar.php	47.10
» » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.24
» » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/navigation_secondary.php	23.84
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #45	9.86
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #46	0.71
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #47	0.53
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #48	9.79
» » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/navigation.php	20.94
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #49	0.53
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #50	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #51	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #52	0.51
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #53	0.60
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #54	0.55
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #55	0.52
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #56	0.72
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #57	0.71
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #58	0.61
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #59	0.53
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #60	0.33
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #61	0.51
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #62	0.58
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #63	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #64	0.56
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #65	0.55
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #66	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #67	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #68	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #69	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #70	0.50
» » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #71	0.34
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header/header_highlights_slider.php	0.84
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/tour_finder.php	11.35
» » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #72	9.44
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header/header_highlights_slider_background.php	0.56
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer/footer.php	33.03
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #73	0.43
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #74	9.30
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/icon.php #75	9.37
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-instagram.php	0.30
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-youtube.php	0.24
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-facebook.php	0.28
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.23
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.25
» » » » » » » » » » » » » » » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzm

Bergsteigerschule Watzmann

Highlights am Watzmann mit der Bergsteigerschule Watzmann und den Watzmann Bergführern!

Dein Vorteil & Deine Sicherheit

Watzmann Ostwand | Wandern in Berchtesgaden | Zu Fuß über die Alpen | Watzmann Überschreitung

Alpine Kompetenz in Berchtesgaden & am Watzmann

Last Minute am Watzmann

Schnapp Dir noch schnell einen Platz mit den Watzmannführern!

Berggeschehen | Neues | Hintergrund

Kurznachrichten aus den Bergen

Gutschein verschenken

Passend zu allen Anlässen. Verschenke Erlebnisse mit Bergführer!

#magazin

#socialwall

#deinabenteuerbeginnt #alpineweltenfamilie #watzmannführer

Wandern im Berchtesgadener Land

Bergsteigen am Watzmann | Bergurlaub am Königssee

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 359 ms Total Queries: 380 queries

Query Explain:

Memory

Timers

Total Time: 359 ms
Total Queries: 380 queries