Dem Schönramer Bier auf der SpurBrauereiführungen & Bierverkostungen

Buche dein exklusives Schönramer Erlebnis

Immer aktuell bleiben Aktuelles

Top-News

10.09.24

Schankschulung der Schönramer Brauerei-Guides

Um dir das perfekte Brauereierlebnis zu bieten, bilden sich unsere Guides ständig weiter. Diesmal standen Schanktechnik im neuen Verkostungsraum am Plan.

Top-News

06.09.24

Jetzt anmelden zum 1. Schönramer Bierpongturnier

Macht euch bereit für das Sportereignis des Jahres: Am 26. Oktober 2024 steigt das 1. Schönramer Bierpong Turnier für 2er-Teams.

Top-News

11.07.24

Dicht und Ergreifend spielen Konzert in Schönram

Dicht & Ergreifend spielen ihr Abschlusskonzert der erfolgreichen "Es werde Dichter"-Tour am 15. November 2024 in der Brauerei Schönram.

Alle Anzeigen

Erlebe die Welt von Schönramer alsFanclub Mitglied

Jetzt mehr über den Fanclub erfahren

Vierteljährlich bekommst du per E-Mail das Wichtigste aus Schönram mitgeteilt.

hier Newsletter abonnieren

Instagram

Ein Bier reist um die Welt! Was dabei erlebt wird teilen wir mit dir auf Instagram.

hier geht's zu Instagram

Facebook

Bleibe immer auf dem Laufenden, erlebe Schönramer Inhalte und nimm an Gewinnspielen teil.

hier geht's zu Facebook

Schönramer Zwickl

Naturtrüb, unfiltriert und unverfälscht im Geschmack. Ein nicht pasteurisiertes Original-Zwickl aus Schönram. Gebraut nach dem bayerischen Reinheitsgebot. Zum Wohl.

zum Detail zum Shop

Informationen

Stammwürze
12,4°P
Bittereinheit
18 IBU
Alkohol
5,1%
Farbe
10 EBC

Schönramer Lager Hell

Das "Schönramer Lager Hell" gibt es seit März in der praktischen 0,5-Liter-Dose. Probiere unsere neueste Bierspezialität im neuen und leichteren Gewand. Perfekt für Outdoor-Aktivitäten und unübertroffen als spritziges Gipfelbier.

zum Detail zum Shop

Schoenram Produkte Vorlage 2 Wiederhergestellt

Informationen

Stammwürze
11,8°P
Alkohol
5,0%
Farbe
5,0 EBC
Bittereinheit
19 IBU
Gebinde
24 x 0,5l

Schönramer Hell

Das Schönramer Hell ist unsere Hauptsorte und eines der beliebtesten Biere im südöstlichen Voralpenland. Dieses süffige, vollmundige Bier ist vom Typ her ein Münchner Hell, aber eine für unsere Region typische kräftigere und hopfenbetontere Variante.

zum Detail zum Shop

Auszeichnungen

European Beer Star
2020 - Gold Award German Style Hell
European Beer Star
2019 - Bronze Award German Style Helles / Austrian Märzen Style
European Beer Star
2017 - Gold Award German-Style Helles / Lager
Mixology Taste Forum 2017
1. Platz
European Beer Star
2011 - Gold Award German-Style Helles / Lager

Informationen

Stammwürze
11,8°P
Alkohol
5,0%

Schönramer Weißbier

Das Schönramer Weißbier besticht dank klassischen altbayrischen Brauverfahren. Sowohl im Aroma, als auch im Geschmack findet man Andeutungen von Gewürznelke, Muskatblüte, Orangenmarmelade und Banane.

zum Detail zum Shop

Auszeichnungen

European Beer Star
2008 - Bronze Award South German-Style Bernsteinfarbenes Hefeweizen

Informationen

Stammwürze
12,7°P
Alkohol
5,6%

Schönramer Pils

Das Schönramer Pils ist stärker gehopft als die Fernsehbiere unserer nördlichen Nachbarn. Edelste und teuerste bayrische Aromahopfen lassen die Bittere angenehmer und harmonischer empfinden.

zum Detail zum Shop

Auszeichnungen

European Beer Star
2023 - Bronze Award German Style Pilsner
European Beer Star
2020 - Silber Award German Style Pilsner
World Beer Cup
2014 - Gold Award German-Style Pilsner
World Beer Cup
2012 - Silber Award German-Style Pilsner
European Beer Star
2011 - Bronze Award German-Style Pilsner

Informationen

Stammwürze
11,8°P
Alkohol
5,0%

Schönramer Gold

Das Schönramer Gold ist ein kräftiges Bier und hat eine satte goldgelbe Farbe mit einer deutlichen Note von Kastanienhonig im Aroma. Das Gold lässt einen nach dem Genuss einer Halben nicht mehr so schnell los.

zum Detail zum Shop

Auszeichnungen

European Beer Star
2023 - Bronze Award German Style Festbier
European Beer Star
2017 - Gold Award European-Style Export
European Beer Star
2015 - Bronze Award European-Style Export
European Beer Star
2014 - Bronze Award European-Style Export
World Beer Cup
2014 - Bronze Award German-Style Oktoberfest

Informationen

Stammwürze
13,5°P
Alkohol
5,7%

Magnum GOLD unfiltriert

Für deine besondere Momente haben wir ein exklusives Bier: Ab sofort gibt’s in unserem Brauerei-Shop das „Gold unfiltriert“ in der 3l-Magnumflasche. In der edlen Verpackung steckt unser Festmärzen, das Gold allerdings direkt vom Lagertank abgefüllt und somit in seiner ursprünglichen unfiltrierten Form.

zum Detail

Informationen

Stammwürze
13,5°P
Alkohol
5,7%
Farbe
6,0 EBC
Gebinde (Flaschen)
3l Magnumflasche

Schönramer Surtaler

Das Surtaler Schankbier ist ein robustes Bier mit 3,5% Alkohol und damit eine wohlschmeckende Alternative zu allen Biermischgetränken. Das malzige Aroma erinnnert an eine frisch gemähte Wiese.

zum Detail zum Shop

Auszeichnungen

European Beer Star
2022 - Gold Award German Style Leichtbier
European Beer Star
2021 - Bronze Award German-Style Leichtbier
European Beer Star
2018 - Gold Award German-Style Leichtbier
European Beer Star
2017 - Bronze Award German-Style Leichtbier
European Beer Star
2014 - Silber Award German-Style Leichtbier
European Beer Star
2013 - Gold Award German-Style Leichtbier

Informationen

Stammwürze
8,8°P
Alkohol
3,5%

Schönramer Dunkel

Das Schönramer Dunkel ist ein echtes Dunkel, das ausschließlich mit dunklen und gerösteten Malzsorten, ohne Einsatz von Dunkelbiersirup und hellem Malz, gebraut wird.

zum Detail zum Shop

Auszeichnungen

European Beer Star
2021 - Gold Award European-Style Dunkel
European Beer Star
2017 - Gold Award European-Style Dunkel
European Beer Star
2012 - Gold Award German Style Kellerbier Dunkel (Schönramer Zwickel-Dunkel)

Informationen

Stammwürze
12,5°P
Alkohol
5,0%

Summa Hoibe

Die unfiltrierte Schönramer Summa Hoibe haben wir für heiße Sommertage gebraut, an denen es auch mal weniger Alkohol sein darf. Die besonderen Hopfensorten bringen sommerliche Aromen ins Spiel. Der leichte Malzkörper wird durch die verbliebene Hefe unterstützt und macht auch an heißen Tagen Lust zum Weitertrinken.

zum Detail zum Shop

Informationen

Stammwürze
9°P
Alkohol
4,2%
Farbe
5 EBC
Bittereinheit
20 IBU
Gebinde
20 x 0,5l

Bayrisch Pale Ale

Das Bayrisch Pale Ale ist unsere Interpretation des englischen Klassikers, ausschließlich mit deutschen Hopfensorten gebraut. Erwähnenswert ist zweifelsohne der verwendete Hopfen "Mandarina Bavaria".

zum Detail zum Shop

Informationen

Stammwürze
12,3°P
Alkohol
5,5%
Farbe
12,0 EBC
Bittereinheiten
45,0 IBU

Imperial Stout

Das Imperial Stout wird aus erlesensten Rohstoffen gebraut und entfaltet nach den Einschenken zarte Nuancen von Zwetschgenkompott, Cappuccino und Kakao.

zum Detail zum Shop

Informationen

Stammwürze
22,3°P
Alkohol
9,5%
Farbe
150,0 EBC
Bittereinheiten
50,0 IBU

Grünhopfen Pils

Das Schönramer Grünhopfenpils ist ein saisonales Spezialbier. Der erntefrische Hopfen wird direkt vom Bauern in die Brauerei gebracht und sofort ungetrocknet verarbeitet. Dadurch entsteht der typische Geschmack der Hopfenernte, der auch im Bier erhalten bleibt.

zum Detail zum Shop

Informationen

Stammwürze
11,9°P
Alkohol
5,0%
Farbe
7 EBC
Bittereinheiten
45 IBU

Weihnachtsfestbier

Das Schönramer Festbier ist ein kräftiges, jedoch ausgewogenes Märzen bayerischer Art. Das Festbier wird im September eingebraut und nach 9-wöchiger Lagerzeit pünktlich zum ersten Advent abgefüllt.

zum Detail zum Shop

Auszeichnungen

World Beer Cup
2004 - Gold Award German-Style Märzen/Oktoberfest

Informationen

Stammwürze
13°P
Alkohol
6,1%
Farbe
12 EBC
Bittereinheiten
26 IBU

Weißbierbock

Diese obergärige Bierspezialität wurde als neuer saisonaler Genuss für unsere treuen Schönramer Händler, Gastronomen & Kunden konzipiert und gebraut. Die Besonderheit dieses Weißbierbockes ist die Hopfung mit dem äußerst seltenen Hopfen „Tardif d´Bourgogne“.

zum Detail zum Shop

Informationen

Alkohol
6,9%
Stammwürze
16°P
Farbe
22 EBC
Bittereinheiten
16 IBU

Heller Bock

zum Detail zum Shop

Informationen

Stammwürze
17°P
Alkohol
7,8% Vol.
Farbe
9 EBC
Bittereinheiten
28 IBU
Gebinde
20 x 0,5l

Schoarama Herbst

zum Detail zum Shop

Informationen

Stammwürze
11°P
Alkoholgehalt
4,9 % VOL.
Farbe
28 EBC
Bittereinheiten
21 IBU

Schönramer Naturradler

Fruchtig, spritzig und frisch! So beschreiben wir das Schönramer Naturradler. Der Mix aus Schönramer Hell und natürlichem Zitronen Saft macht zudem weniger süß. Das ideale Biermischgetränk für den Sommer.

zum Detail

Informationen

Stammwürze
11,5°P
Alkohol
2,2%
Farbe
4,0 EBC
Bittereinheiten
8,0 IBU
Gebinde (Flaschen)
20 x 0,33l oder 20 x 0,5l

X-Mix (Cola-Mix)

zum Detail

Informationen

Gebinde (Flaschen)
20 x 0,5l

Cola Mix

Das Schönramer Cola-Mix (in Bayern meist als Spezi bezeichnet) ist der Verkaufsschlager unter den antialkoholischen Schönramer Getränken. Spritzig, erfrischend und viel Orangengeschmack machen diese Limonadensorte so beliebt bei Jung und Alt.

zum Detail

Iso-Doni

Der Iso-Doni ist unser neuestes & innovativstes Erfrischungsgetränk und die ideale Alternative zu den bestehenden alkolfreien Getränken in unserem Sortiment. Das isotonische Sportgetränk mit Limettengeschmack ist fruchtig- spritzig und hat einen Fruchtgehalt von 6%. Am besten gut gekühlt während & nach dem Sport oder an heißen Sommertagen genießen.

zum Detail

Informationen

Gebinde (Flaschen)
20 x 0,5 l

Schönramer Limo

Zitronen- und Orangenlimonade gehören als altbewährte Klassiker ganz einfach ins Sortiment. Dabei schmecken unsere Limo's nicht nur den Kindern, sondern auch der ein oder andere Erwachsene ist dem Geschmack verfallen. Übrigens werden auch alle antialkoholischen Getränke bei uns in Schönram abgefüllt.

zum Detail

Schönramer Wasser

Hinter unserem Tafelwasser steckt das gleiche Wasser, das wir auch zum Bierbrauen verwenden. Egal ob bei der Arbeit, zu Hause oder am Badesee, das Wasser ist und bleibt der Durstlöscher Nummer eins. Das Schönramer Wasser gibt es sanft oder spritzig.

zum Detail

Greimel Apfe-Schosch

Unser Apfe-Schorsch ist ein echtes Regionalprodukt. Von der Kelterei Greimel aus Laufen kommen 55% naturtrüber Direktapfelsaft, in der Brauerei kommt der Saft zusammen mit Wasser und Kohlensäure in die Flasche. Wir verzichten beim Apfe-Schorsch auf Konzentrate und zusätzlichen Zucker. Da es sich um ein Naturprodukt handelt kann es zu leichten geschmacklichen und farblichen Veränderungen kommen.

zum Detail

Greimel Früchte-Korbi

Im Rupertigauer Früchtekorb steckt ein Saftanteil von über 50% aus klarem Direktapfelsaft, schwarzen Johannisbeer-, Kirsch- und Holundernektar von der Kelterei Greimel aus Laufen. Gemischt und abgefüllt wird die erfrischend furchtige Schorle natürlich in Schönram. Der Früchtekorb ist eine wertvolle Vielfruchtschorle aus reinen Naturprodukten.

zum Detail

Endlich wieder BierzeltAlle Schönramer Veranstaltungen

Jetzt zu den Veranstaltungen

Händlersuche

zu unseren Händlern

Wirtshaussuche

zu unseren Gastronomiebetrieben

Dafür stehen wir...Philosophie

zur Philosophie

Willkommen in der

Privaten Landbrauerei Schönram

Als bayrische Biermarke trägt die Brauerei Schönram Verantwortung und setzt sich im Rahmen der gesetzlichen Bestimmungen für den verantwortungsbewussten Umgang mit alkoholhaltigen Getränken ein.

Die folgenden Seiten enthalten Werbeinformationen zu alkoholischen Getränken.
Wir bitten Sie daher zu bestätigen, dass Sie über 16 Jahre alt sind.

Über 16 Jahre Unter 16 Jahre

Cookie Einstellungen

Wir nutzen folgende Cookies:
- technisch notwendige Cookies (werden automatisch gesetzt), deren Daten von uns nicht weitergegeben werden und ausschließlich zur Bereitstellung der Funktionalität dieser Seite dienen.
- Cookies, die Ihr Verhalten beim Besuch der Webseiten messen, um das Interesse unserer Besucher besser kennen zu lernen. Wir erheben dabei nur pseudonyme Daten, eine Identifikation Ihrer Person erfolgt nicht.
- Facebook Pixel (Analysetool) zur persönlichen/individuellen Anpassung unserer Werbetätigkeit (Details siehe Datenschutzerklärung)
Weitere Informationen finden Sie in unserer Datenschutzerklärung.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentca40b5f22cf3d88f707fb259b2686ed4
  time1726049079
  countdown10
  languagede
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  01
- ids(array)
  Menu1
  Content(null)
  Language1
- route(array)
  id2
  hash8734be56cbb0bba48e2e3dd1767f9e2a
  created2017-10-13 12:06:46
  updated2024-04-17 09:46:52
  modelMenu
  foreign_key1
  base/de/
  aliasbrauerei-bayern
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id1
  lft2
  rght41
  route/de/brauerei-bayern
- isAjax(false)
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: 13 ms
Total Queries: 156 queries

Query	Affected	Num. rows	Took (ms)	Actions
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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 2 AND `Route`.`rght` >= 41 ORDER BY `Route`.`lft` asc	2	2	0
SELECT `Language`.`langid` FROM `brauerei_schoenram`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `brauerei_schoenram`.`settings` AS `Setting` LEFT JOIN `brauerei_schoenram`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	15	15	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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` FROM `brauerei_schoenram`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (1) ORDER BY `Content`.`position` asc	8	8	1	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 703 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 261 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 605 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 3 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 98 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 536 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 8 AND `Route`.`model` = 'Content'	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 `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 46 AND `Route`.`model` = 'Content'	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type` FROM `brauerei_schoenram`.`menus` AS `Menu` WHERE 1 = 1 LIMIT 1	1	1	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	4	4	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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (1732, 1746, 1172, 1722) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	28	28	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `brauerei_schoenram`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'meta-a' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 112 ORDER BY `Menu`.`lft` asc	54	54	1
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `brauerei_schoenram`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'meta-b' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 113 AND `Menu`.`rght` < 120 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `brauerei_schoenram`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 121 AND `Menu`.`rght` < 146 ORDER BY `Menu`.`lft` asc	12	12	0
SELECT *, Language.id FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `brauerei_schoenram`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 21 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 22 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 22 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (21) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 21 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 21 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 30 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 30 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ArticleContentMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `GalleryMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ContentTeaserImage1Media`.`id`, `ContentTeaserImage1Media`.`hash`, `ContentTeaserImage1Media`.`created`, `ContentTeaserImage1Media`.`updated`, `ContentTeaserImage1Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage1Media`.`id`) AS `ContentTeaserImage1Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage1Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ContentTeaserImage1Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_1' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ContentTeaserImage2Media`.`id`, `ContentTeaserImage2Media`.`hash`, `ContentTeaserImage2Media`.`created`, `ContentTeaserImage2Media`.`updated`, `ContentTeaserImage2Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage2Media`.`id`) AS `ContentTeaserImage2Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage2Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ContentTeaserImage2Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_2' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ContentTeaserImage3Media`.`id`, `ContentTeaserImage3Media`.`hash`, `ContentTeaserImage3Media`.`created`, `ContentTeaserImage3Media`.`updated`, `ContentTeaserImage3Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage3Media`.`id`) AS `ContentTeaserImage3Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage3Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ContentTeaserImage3Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_3' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `PlaceholderImageMedia`.`id`, `PlaceholderImageMedia`.`hash`, `PlaceholderImageMedia`.`created`, `PlaceholderImageMedia`.`updated`, `PlaceholderImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) AS `PlaceholderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `PlaceholderImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'placeholder_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `brauerei_schoenram`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'partner' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 29 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 31 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 31 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (29) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 29 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 29	9	9	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` IN (30, 31, 32, 33, 34, 35, 57, 70, 73) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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 `brauerei_schoenram`.`languages` AS `Language` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `brauerei_schoenram`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 1 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type` FROM `brauerei_schoenram`.`menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 1 AND `Menu`.`rght` >= 2 ORDER BY `Menu`.`lft` asc	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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/brauereifuehrung-verkostung' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 37 AND `Route`.`rght` >= 38 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 703 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 703 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1628) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 7 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (688) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/news' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 13 AND `Route`.`rght` >= 14 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 261 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 358 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`.`hash`, `News`.`created`, `News`.`updated`, `News`.`category`, `News`.`title`, `News`.`detail`, `News`.`menu_id`, `News`.`route`, `News`.`top_news`, `News`.`release`, `News`.`hide`, (NOW() BETWEEN COALESCE(`News`.`release`, NOW()) AND COALESCE(`News`.`hide`, NOW())) AS `News__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 `brauerei_schoenram`.`news` AS `News` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `News`.`id` AND `Route`.`model` = 'News') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `News`.`id` AND `Teaser`.`model` = 'News') WHERE (NOW() BETWEEN COALESCE(`News`.`release`, NOW()) AND COALESCE(`News`.`hide`, NOW())) = '1' ORDER BY `News`.`top_news` DESC, `News`.`release` DESC LIMIT 3	3	3	1	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1442 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1910) 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 `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1430 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1886) 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 `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1387 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1833) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	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` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' 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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/fanclub' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 35 AND `Route`.`rght` >= 36 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 605 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 605 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1538) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 161 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 892 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1299) 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 `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 992 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (161) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 161 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (686) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/social-media-teaser' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 5 AND `Route`.`rght` >= 6 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 3 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 38 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 38 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ArticleContentMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `GalleryMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ContentTeaserImage1Media`.`id`, `ContentTeaserImage1Media`.`hash`, `ContentTeaserImage1Media`.`created`, `ContentTeaserImage1Media`.`updated`, `ContentTeaserImage1Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage1Media`.`id`) AS `ContentTeaserImage1Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage1Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ContentTeaserImage1Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_1' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (691) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `ContentTeaserImage2Media`.`id`, `ContentTeaserImage2Media`.`hash`, `ContentTeaserImage2Media`.`created`, `ContentTeaserImage2Media`.`updated`, `ContentTeaserImage2Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage2Media`.`id`) AS `ContentTeaserImage2Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage2Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ContentTeaserImage2Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_2' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (257) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `ContentTeaserImage3Media`.`id`, `ContentTeaserImage3Media`.`hash`, `ContentTeaserImage3Media`.`created`, `ContentTeaserImage3Media`.`updated`, `ContentTeaserImage3Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage3Media`.`id`) AS `ContentTeaserImage3Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage3Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ContentTeaserImage3Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_3' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (258) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `PlaceholderImageMedia`.`id`, `PlaceholderImageMedia`.`hash`, `PlaceholderImageMedia`.`created`, `PlaceholderImageMedia`.`updated`, `PlaceholderImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) AS `PlaceholderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `PlaceholderImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'placeholder_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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/produkteslider' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 11 AND `Route`.`rght` >= 12 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 98 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 149 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Product`.`id`, `Product`.`hash`, `Product`.`created`, `Product`.`updated`, `Product`.`category`, `Product`.`title`, `Product`.`subtitle`, `Product`.`introduction`, `Product`.`description`, `Product`.`shop_url`, `Product`.`menu_id`, `Product`.`route`, `Product`.`position`, `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`, `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 `brauerei_schoenram`.`products` AS `Product` LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Product`.`id` AND `Teaser`.`model` = 'Product') LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Product`.`id` AND `Route`.`model` = 'Product') WHERE 1 = 1 ORDER BY `Product`.`position` ASC	25	25	0
SELECT `ProductInformation`.`id`, `ProductInformation`.`hash`, `ProductInformation`.`created`, `ProductInformation`.`updated`, `ProductInformation`.`attribute`, `ProductInformation`.`value`, `ProductInformation`.`in_slider`, `ProductInformation`.`position`, `ProductInformation`.`product_id` FROM `brauerei_schoenram`.`product_informations` AS `ProductInformation` WHERE `in_slider` = 1 AND `ProductInformation`.`product_id` IN (9, 24, 29, 31, 10, 18, 30, 2, 12, 22, 7, 14, 17, 3, 15, 16, 4, 19, 21, 20, 25, 32, 5, 28, 6)	66	66	0
SELECT `ProductAward`.`id`, `ProductAward`.`hash`, `ProductAward`.`created`, `ProductAward`.`updated`, `ProductAward`.`title`, `ProductAward`.`rank`, `ProductAward`.`date`, `ProductAward`.`in_slider`, `ProductAward`.`product_id` FROM `brauerei_schoenram`.`product_awards` AS `ProductAward` WHERE `in_slider` = 1 AND `ProductAward`.`product_id` IN (9, 24, 29, 31, 10, 18, 30, 2, 12, 22, 7, 14, 17, 3, 15, 16, 4, 19, 21, 20, 25, 32, 5, 28, 6) ORDER BY `date` desc	26	26	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (34, 35, 33, 21, 32, 30, 28, 27, 26, 31, 2, 24, 12, 1, 13, 14, 25, 3, 4, 6, 7, 17, 18, 19, 22, 23) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'ProductAward' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	26	26	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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (77, 75, 76, 80, 78, 81) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	42	42	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (9, 24, 29, 31, 10, 18, 30, 2, 12, 22, 7, 14, 17, 3, 15, 16, 4, 19, 21, 20, 25, 32, 5, 28, 6) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Product' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	25	25	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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (517, 527, 722, 519, 682, 518, 1507, 1508, 965, 1195, 1509, 1505, 1502, 776, 1187, 1771, 1193, 1192, 1191, 1190, 1859, 1366, 1745, 1188, 1748) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	178	178	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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/veranstaltungen' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 29 AND `Route`.`rght` >= 30 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 536 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 536 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1129) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 140 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 799 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 804 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (140) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 140 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (468) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/inhaltsteaser-boxen' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 7 AND `Route`.`rght` >= 8 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 8 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 43 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 43 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ArticleContentMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `GalleryMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ContentTeaserImage1Media`.`id`, `ContentTeaserImage1Media`.`hash`, `ContentTeaserImage1Media`.`created`, `ContentTeaserImage1Media`.`updated`, `ContentTeaserImage1Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage1Media`.`id`) AS `ContentTeaserImage1Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage1Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `ContentTeaserImage1Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_1' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (93) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ContentTeaserImage2Media`.`id`, `ContentTeaserImage2Media`.`hash`, `ContentTeaserImage2Media`.`created`, `ContentTeaserImage2Media`.`updated`, `ContentTeaserImage2Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage2Media`.`id`) AS `ContentTeaserImage2Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage2Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `ContentTeaserImage2Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_2' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ContentTeaserImage3Media`.`id`, `ContentTeaserImage3Media`.`hash`, `ContentTeaserImage3Media`.`created`, `ContentTeaserImage3Media`.`updated`, `ContentTeaserImage3Media`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ContentTeaserImage3Media`.`id`) AS `ContentTeaserImage3Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `ContentTeaserImage3Media` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `ContentTeaserImage3Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'content_teaser_image_3' 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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (92) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `PlaceholderImageMedia`.`id`, `PlaceholderImageMedia`.`hash`, `PlaceholderImageMedia`.`created`, `PlaceholderImageMedia`.`updated`, `PlaceholderImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) AS `PlaceholderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `PlaceholderImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 AND `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'placeholder_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 `brauerei_schoenram`.`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`))) = '/de/brauerei-bayern/philosophie' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brauerei_schoenram`.`routes` AS `Route` WHERE `Route`.`lft` <= 9 AND `Route`.`rght` >= 10 ORDER BY `Route`.`lft` asc	3	3	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`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`interlayer_subline`, `Content`.`interlayer_headline`, `Content`.`interlayer_btn_text`, `Content`.`content_teaser_title_1`, `Content`.`content_teaser_title_2`, `Content`.`content_teaser_title_3`, `Content`.`content_teaser_text_1`, `Content`.`content_teaser_text_2`, `Content`.`content_teaser_text_3`, `Content`.`content_teaser_btn_txt_1`, `Content`.`content_teaser_btn_txt_2`, `Content`.`content_teaser_btn_txt_3`, `Content`.`content_teaser_btn_url_1`, `Content`.`content_teaser_btn_url_2`, `Content`.`content_teaser_btn_url_3`, `Content`.`teaser_box`, `Content`.`employee_id`, `Content`.`product_index_start`, `Content`.`subtitle`, `Content`.`hide_details`, `Content`.`placeholder_text`, (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`, `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 `brauerei_schoenram`.`contents` AS `Content` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 46 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `InterlayerImageMedia`.`id`, `InterlayerImageMedia`.`hash`, `InterlayerImageMedia`.`created`, `InterlayerImageMedia`.`updated`, `InterlayerImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) AS `InterlayerImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `InterlayerImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 46 AND `MediaEntity`.`media_id` = `InterlayerImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'interlayer_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 `brauerei_schoenram`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `brauerei_schoenram`.`menus` AS `Menu` LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brauerei_schoenram`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 4 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`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 `brauerei_schoenram`.`media` AS `ImageMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MenuImageUpload`.`id`, `MenuImageUpload`.`hash`, `MenuImageUpload`.`created`, `MenuImageUpload`.`updated`, `MenuImageUpload`.`model`, `MenuImageUpload`.`field`, `MenuImageUpload`.`foreign_key`, `MenuImageUpload`.`alias`, `MenuImageUpload`.`thumbnail`, `MenuImageUpload`.`parent_id`, `MenuImageUpload`.`file`, `MenuImageUpload`.`size`, `MenuImageUpload`.`ext`, `MenuImageUpload`.`mime`, `MenuImageUpload`.`width`, `MenuImageUpload`.`height` FROM `brauerei_schoenram`.`uploads` AS `MenuImageUpload` WHERE `MenuImageUpload`.`model` = 'Menu' AND `MenuImageUpload`.`field` = 'menu_image' AND `MenuImageUpload`.`foreign_key` = (4) ORDER BY FIELD(COALESCE(`MenuImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `brauerei_schoenram`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brauerei_schoenram`.`media` AS `HeaderImagesMedia` JOIN `brauerei_schoenram`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	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` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' 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 `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` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`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` FROM `brauerei_schoenram`.`mount_points` AS `MountPoint` LEFT JOIN `brauerei_schoenram`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brauerei_schoenram`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' 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.44 MB

Message	Memory use
Component initialization	6.86 MB
Controller action start	8.06 MB
Controller render start	10.54 MB
Component initialization #2	14.50 MB
Controller action start #2	14.64 MB
Controller render start #2	14.88 MB
Component initialization #3	15.14 MB
Controller action start #3	15.17 MB
Controller render start #3	15.73 MB
Component initialization #4	16.20 MB
Controller action start #4	16.23 MB
Controller render start #4	16.52 MB
Component initialization #5	16.70 MB
Controller action start #5	16.73 MB
Controller render start #5	17.00 MB
Component initialization #6	17.19 MB
Controller action start #6	17.22 MB
Controller render start #6	19.52 MB
Component initialization #7	20.04 MB
Controller action start #7	20.07 MB
Controller render start #7	18.30 MB
Component initialization #8	18.50 MB
Controller action start #8	18.53 MB
Controller render start #8	18.79 MB
Component initialization #9	18.98 MB
Controller action start #9	19.01 MB
Controller render start #9	19.21 MB
View render complete	19.76 MB

Timers

Total Request Time: 879 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	92.01
Event: Controller.initialize	13.43
Event: Controller.startup	0.96
Controller action	36.42
Event: Controller.beforeRender	68.23
» Processing toolbar data	21.20
Rendering View	516.76
» Event: View.beforeRender	0.08
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	490.75
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	489.85
» » » Event: Controller.initialize #2	0.94
» » » Event: Controller.startup #2	0.33
» » » Controller action #2	8.98
» » » Event: Controller.beforeRender #2	8.69
» » » » Processing toolbar data #2	8.47
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.08
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/interlayer_menu.php	2.55
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.52
» » » » Event: View.afterRender	0.05
» » » » Event: Controller.shutdown	0.04
» » » » Event: Controller.initialize #3	0.99
» » » » Event: Controller.startup #3	0.35
» » » » Controller action #3	17.25
» » » » Event: Controller.beforeRender #3	7.02
» » » » » Processing toolbar data #3	6.81
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.06
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/news_index_home.php	7.44
» » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/card_teaser.php	3.07
» » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/card_teaser.php #2	0.79
» » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/card_teaser.php #3	0.77
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.55
» » » » » Event: View.afterRender #2	0.05
» » » » » Event: Controller.shutdown #2	0.04
» » » » » Event: Controller.initialize #4	0.83
» » » » » Event: Controller.startup #4	0.33
» » » » » Controller action #4	8.27
» » » » » Event: Controller.beforeRender #4	8.88
» » » » » » Processing toolbar data #4	8.72
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.07
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/interlayer_menu.php #2	1.11
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.42
» » » » » » Event: View.afterRender #3	0.04
» » » » » » Event: Controller.shutdown #3	0.04
» » » » » » Event: Controller.initialize #5	0.90
» » » » » » Event: Controller.startup #5	0.39
» » » » » » Controller action #5	11.18
» » » » » » Event: Controller.beforeRender #5	11.26
» » » » » » » Processing toolbar data #5	11.00
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.07
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/content_teaser.php	2.07
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.54
» » » » » » » Event: View.afterRender #4	0.05
» » » » » » » Event: Controller.shutdown #4	0.05
» » » » » » » Event: Controller.initialize #6	1.59
» » » » » » » Event: Controller.startup #6	0.69
» » » » » » » Controller action #6	127.13
» » » » » » » Event: Controller.beforeRender #6	24.85
» » » » » » » » Processing toolbar data #6	24.56
Rendering View #6	0.00
» » » » » » » » Event: View.beforeRender #6	0.08
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/product_slider.php	27.97
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.66
» » » » » » » » Event: View.afterRender #5	0.05
» » » » » » » » Event: Controller.shutdown #5	0.04
» » » » » » » » Event: Controller.initialize #7	0.92
» » » » » » » » Event: Controller.startup #7	0.33
» » » » » » » » Controller action #7	11.20
» » » » » » » » Event: Controller.beforeRender #7	41.78
» » » » » » » » » Processing toolbar data #7	41.55
Rendering View #7	0.00
» » » » » » » » » Event: View.beforeRender #7	0.07
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/interlayer_menu.php #3	1.09
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #6	0.42
» » » » » » » » » Event: View.afterRender #6	0.04
» » » » » » » » » Event: Controller.shutdown #6	0.04
» » » » » » » » » Event: Controller.initialize #8	0.90
» » » » » » » » » Event: Controller.startup #8	0.35
» » » » » » » » » Controller action #8	15.16
» » » » » » » » » Event: Controller.beforeRender #8	36.71
» » » » » » » » » » Processing toolbar data #8	36.46
Rendering View #8	0.00
» » » » » » » » » » Event: View.beforeRender #8	0.07
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/content_teaser.php #2	1.71
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7	0.47
» » » » » » » » » » Event: View.afterRender #7	0.05
» » » » » » » » » » Event: Controller.shutdown #7	0.04
» » » » » » » » » » Event: Controller.initialize #9	1.17
» » » » » » » » » » Event: Controller.startup #9	0.47
» » » » » » » » » » Controller action #9	9.00
» » » » » » » » » » Event: Controller.beforeRender #9	33.39
» » » » » » » » » » » Processing toolbar data #9	33.15
Rendering View #9	0.00
» » » » » » » » » » » Event: View.beforeRender #9	0.08
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/interlayer_menu.php #4	1.30
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #8	0.47
» » » » » » » » » » » Event: View.afterRender #8	0.07
» » » » » » » » » » » Event: Controller.shutdown #8	0.05
» » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #9	0.43
» » » » » » » » » Event: View.afterRender #9	0.51
» » » » » » » » » Event: View.beforeLayout	0.05
» » » » » » » » » Rendering APP/View/Layouts/index.php	22.16
» » » » » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.55
» » » » » » » » » » Rendering APP/View/Elements/wappen-svg.php	0.48
» » » » » » » » » » Rendering APP/View/Elements/layer.php	1.84
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
 Menu(array)
 id1
 hasha3cbb1be7b814aa60b9eee6f7144eac8
 created2017-10-13 12:06:46
 updated2024-04-17 09:46:50
 parent_id(null)
 lft1
 rght2
 language_id1
 typecontent
 titleStartseite
 previous_urlhttp://brauerei-schoenram.de/
 url(null)
 target_blank(false)
 calendar_label_type(null)
 Seo(array)
 id1
 hash357203a3a99aab0a5da10592bd9f1438
 created2017-10-13 12:06:46
 updated2024-04-17 09:46:53
 modelMenu
 foreign_key1
 titleSchönramer - Biergenuss seit 1780
 descriptionIm schönen Rupertiwinkel in Bayern gelegen, brauen wir unser Bier nach bewährter Tradition und mit modernster Technik. Erfahren Sie alles über unsere Brauerei.
 author
 tw_creator
 fb_author
 robots3
 ImageMedia(empty)
 Content(array)
 0(array)
 id703
 hashadec3214634a3adb053d0f61eafd8e43
 created2024-01-25 10:25:01
 updated2024-03-19 09:28:38
 menu_id1
 position3
 typeinterlayer_menu
 statusactive
 titleBrauereiführung & Verkostung
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id7
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_sublineDem Schönramer Bier auf der Spur
 interlayer_headlineBrauereiführungen & Bierverkostungen
 interlayer_btn_textBuche dein exklusives Schönramer Erlebnis
 content_teaser_title_1(null)
 content_teaser_title_2(null)
 content_teaser_title_3(null)
 content_teaser_text_1(null)
 content_teaser_text_2(null)
 content_teaser_text_3(null)
 content_teaser_btn_txt_1(null)
 content_teaser_btn_txt_2(null)
 content_teaser_btn_txt_3(null)
 content_teaser_btn_url_1(null)
 content_teaser_btn_url_2(null)
 content_teaser_btn_url_3(null)
 teaser_box(null)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id1432
 hash81fba6e07c7d8831cdbc529a50de9b48
 created2024-01-25 10:25:01
 updated2024-03-19 09:28:39
 modelContent
 foreign_key703
 base/de/brauerei-bayern/
 aliasbrauereifuehrung-verkostung
 controllerFrontendContents.FrontendContents
 actioninterlayer_menu
 parent_id2
 lft37
 rght38
 route/de/brauerei-bayern/brauereifuehrung-verkostung
 1(array)
 id261
 hashac280d72beb13186ed6b41ba5eee685e
 created2018-08-29 08:54:49
 updated2018-11-20 15:28:45
 menu_id1
 position4
 typenews_index_home
 statusactive
 titlenews
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_subline(null)
 interlayer_headline(null)
 interlayer_btn_text(null)
 content_teaser_title_1(null)
 content_teaser_title_2(null)
 content_teaser_title_3(null)
 content_teaser_text_1(null)
 content_teaser_text_2(null)
 content_teaser_text_3(null)
 content_teaser_btn_txt_1(null)
 content_teaser_btn_txt_2(null)
 content_teaser_btn_txt_3(null)
 content_teaser_btn_url_1(null)
 content_teaser_btn_url_2(null)
 content_teaser_btn_url_3(null)
 teaser_box(null)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id393
 hash0ca8068e960e201c6e4d922f498ddd98
 created2018-08-29 08:54:49
 updated2018-11-20 15:28:45
 modelContent
 foreign_key261
 base/de/brauerei-bayern/
 aliasnews
 controllerFrontendContents.FrontendContents
 actionnews_index_home
 parent_id2
 lft13
 rght14
 route/de/brauerei-bayern/news
 2(array)
 id605
 hash4a861c6ec8acbe62ebe2d7963f89254e
 created2023-01-03 13:13:33
 updated2024-01-25 10:22:24
 menu_id1
 position5
 typeinterlayer_menu
 statusactive
 titleFanclub
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release2023-01-03 13:12:00
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id161
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_sublineErlebe die Welt von Schönramer als
 interlayer_headlineFanclub Mitglied
 interlayer_btn_textJetzt mehr über den Fanclub erfahren
 content_teaser_title_1(null)
 content_teaser_title_2(null)
 content_teaser_title_3(null)
 content_teaser_text_1(null)
 content_teaser_text_2(null)
 content_teaser_text_3(null)
 content_teaser_btn_txt_1(null)
 content_teaser_btn_txt_2(null)
 content_teaser_btn_txt_3(null)
 content_teaser_btn_url_1(null)
 content_teaser_btn_url_2(null)
 content_teaser_btn_url_3(null)
 teaser_box(null)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id1098
 hash6fe45d3abd4aba949e56293928af4406
 created2023-01-03 13:13:33
 updated2024-01-25 10:22:24
 modelContent
 foreign_key605
 base/de/brauerei-bayern/
 aliasfanclub
 controllerFrontendContents.FrontendContents
 actioninterlayer_menu
 parent_id2
 lft35
 rght36
 route/de/brauerei-bayern/fanclub
 3(array)
 id3
 hash514c03337b97a1268f83ea9b70df40f8
 created2017-10-18 14:15:39
 updated2022-01-25 15:57:57
 menu_id1
 position7
 typecontent_teaser
 statusactive
 titlesocial media teaser
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_subline(null)
 interlayer_headline(null)
 interlayer_btn_text(null)
 content_teaser_title_1Newsletter
 content_teaser_title_2Instagram
 content_teaser_title_3Facebook
 content_teaser_text_1Vierteljährlich bekommst du per E-Mail das Wichtigste aus Schönram mitgeteilt. 
 content_teaser_text_2Ein Bier reist um die Welt! Was dabei erlebt wird teilen wir mit dir auf Instagram.
 content_teaser_text_3Bleibe immer auf dem Laufenden, erlebe Schönramer Inhalte und nimm an Gewinnspielen teil.
 content_teaser_btn_txt_1hier Newsletter abonnieren
 content_teaser_btn_txt_2hier geht's zu Instagram
 content_teaser_btn_txt_3hier geht's zu Facebook
 content_teaser_btn_url_1https://www.schoenramer.de/de/neuigkeiten/newsletter
 content_teaser_btn_url_2https://www.instagram.com/schoenramer/
 content_teaser_btn_url_3http://facebook.com/schoenramer
 teaser_box(false)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id39
 hash122045d663910a5fe6927c591b59c0eb
 created2017-10-18 14:15:39
 updated2022-01-25 15:57:57
 modelContent
 foreign_key3
 base/de/brauerei-bayern/
 aliassocial-media-teaser
 controllerFrontendContents.FrontendContents
 actioncontent_teaser
 parent_id2
 lft5
 rght6
 route/de/brauerei-bayern/social-media-teaser
 4(array)
 id98
 hashb87f1de687737f2dbe84b9af86861d2e
 created2017-12-01 14:47:06
 updated2020-10-28 19:02:05
 menu_id1
 position9
 typeproduct_slider
 statusactive
 titleProdukteslider
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_subline(null)
 interlayer_headline(null)
 interlayer_btn_text(null)
 content_teaser_title_1(null)
 content_teaser_title_2(null)
 content_teaser_title_3(null)
 content_teaser_text_1(null)
 content_teaser_text_2(null)
 content_teaser_text_3(null)
 content_teaser_btn_txt_1(null)
 content_teaser_btn_txt_2(null)
 content_teaser_btn_txt_3(null)
 content_teaser_btn_url_1(null)
 content_teaser_btn_url_2(null)
 content_teaser_btn_url_3(null)
 teaser_box(null)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id190
 hashd464e1452c194fba2881ac503db0bbee
 created2017-12-01 14:47:06
 updated2020-10-28 19:02:05
 modelContent
 foreign_key98
 base/de/brauerei-bayern/
 aliasprodukteslider
 controllerFrontendContents.FrontendContents
 actionproduct_slider
 parent_id2
 lft11
 rght12
 route/de/brauerei-bayern/produkteslider
 5(array)
 id536
 hash71bf8e11d81c71c3f65e1b52bbed8ecc
 created2022-05-08 21:44:24
 updated2024-01-25 10:27:00
 menu_id1
 position10
 typeinterlayer_menu
 statusactive
 titleVeranstaltungen
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release2022-07-22 00:23:00
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id140
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_sublineEndlich wieder Bierzelt
 interlayer_headlineAlle Schönramer Veranstaltungen
 interlayer_btn_textJetzt zu den Veranstaltungen
 content_teaser_title_1(null)
 content_teaser_title_2(null)
 content_teaser_title_3(null)
 content_teaser_text_1(null)
 content_teaser_text_2(null)
 content_teaser_text_3(null)
 content_teaser_btn_txt_1(null)
 content_teaser_btn_txt_2(null)
 content_teaser_btn_txt_3(null)
 content_teaser_btn_url_1(null)
 content_teaser_btn_url_2(null)
 content_teaser_btn_url_3(null)
 teaser_box(null)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id914
 hash3eb89b97842a125e037a8aa0445f5857
 created2022-05-08 21:44:24
 updated2024-01-25 10:27:01
 modelContent
 foreign_key536
 base/de/brauerei-bayern/
 aliasveranstaltungen
 controllerFrontendContents.FrontendContents
 actioninterlayer_menu
 parent_id2
 lft29
 rght30
 route/de/brauerei-bayern/veranstaltungen
 6(array)
 id8
 hash0df64b922bb4a9eebe8159448c291e68
 created2017-10-18 16:03:23
 updated2018-02-15 11:41:56
 menu_id1
 position11
 typecontent_teaser
 statusactive
 titleinhaltsteaser boxen
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_subline(null)
 interlayer_headline(null)
 interlayer_btn_text(null)
 content_teaser_title_1Händlersuche
 content_teaser_title_2
 content_teaser_title_3Wirtshaussuche
 content_teaser_text_1
 content_teaser_text_2
 content_teaser_text_3
 content_teaser_btn_txt_1zu unseren Händlern
 content_teaser_btn_txt_2
 content_teaser_btn_txt_3zu unseren Gastronomiebetrieben
 content_teaser_btn_url_1http://www.schoenramer.de/de/da-gibt-s-unser-bier/haendler
 content_teaser_btn_url_2
 content_teaser_btn_url_3http://www.schoenramer.de/de/da-gibt-s-unser-bier/gastronomie
 teaser_box(true)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id44
 hash348655aaffde088b824d3663f3410e33
 created2017-10-18 16:03:23
 updated2018-02-15 11:41:56
 modelContent
 foreign_key8
 base/de/brauerei-bayern/
 aliasinhaltsteaser-boxen
 controllerFrontendContents.FrontendContents
 actioncontent_teaser
 parent_id2
 lft7
 rght8
 route/de/brauerei-bayern/inhaltsteaser-boxen
 7(array)
 id46
 hash5de1f30b07fc9bcc252c41690aca5964
 created2017-11-13 20:46:41
 updated2019-03-28 10:02:36
 menu_id1
 position12
 typeinterlayer_menu
 statusactive
 titlePhilosophie
 layoutfull-col12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id4
 teaser_external_url(null)
 teaser_external_target(null)
 interlayer_sublineDafür stehen wir...
 interlayer_headlinePhilosophie
 interlayer_btn_textzur Philosophie
 content_teaser_title_1(null)
 content_teaser_title_2(null)
 content_teaser_title_3(null)
 content_teaser_text_1(null)
 content_teaser_text_2(null)
 content_teaser_text_3(null)
 content_teaser_btn_txt_1(null)
 content_teaser_btn_txt_2(null)
 content_teaser_btn_txt_3(null)
 content_teaser_btn_url_1(null)
 content_teaser_btn_url_2(null)
 content_teaser_btn_url_3(null)
 teaser_box(null)
 employee_id(null)
 product_index_start(null)
 subtitle(null)
 hide_details(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id99
 hash5a1936e5c0062dc360db35f74d1e614f
 created2017-11-13 20:46:41
 updated2019-03-28 10:02:36
 modelContent
 foreign_key46
 base/de/brauerei-bayern/
 aliasphilosophie
 controllerFrontendContents.FrontendContents
 actioninterlayer_menu
 parent_id2
 lft9
 rght10
 route/de/brauerei-bayern/philosophie
- $request->data(empty)
- $this->validationErrors(array)
 Route(empty)
 MountPoint(empty)
 Redirect(empty)
 Language(empty)
 Setting(empty)
 ValueUpload(empty)
 Menu(empty)
 Parent(empty)
 HeaderImagesMedia(empty)
 MediaEntity(empty)
 Seo(empty)
 ImageMedia(empty)
 Teaser(empty)
 Content(empty)
 ArticleContentMedia(empty)
 GalleryMedia(empty)
 InterlayerImageMedia(empty)
 ContentTeaserImage1Media(empty)
 ContentTeaserImage2Media(empty)
 ContentTeaserImage3Media(empty)
 PlaceholderImageMedia(empty)
 FileUpload(empty)
 MenuImageUpload(empty)
 FlagUpload(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8Embed
 9Layout
 10ThirdPartyCookies
 11Maps
 12Number
 13SimpleGraph
 14DebugTimer
 15Toolbar
 16Js
 17HtmlToolbar
====

Environment

App Constants

Constant	Value
MH
MH_IP
BACKEND_APP_DIR	contrance
UPLOADS_APP	/var/www/vhosts/schoenramer.de/httpdocs/contrance/
UPLOAD_TMP_DIR	tmp/uploads/

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/schoenramer.de/httpdocs/
APP_DIR	httpdocs
APPLIBS	/var/www/vhosts/schoenramer.de/httpdocs/Lib/
CACHE	/var/www/vhosts/schoenramer.de/httpdocs/tmp/cache/
CAKE	/var/www/vhosts/schoenramer.de/httpdocs/contrance/Vendor/Cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/schoenramer.de/httpdocs/contrance/Vendor/Cake/lib
CORE_PATH	/var/www/vhosts/schoenramer.de/httpdocs/contrance/Vendor/Cake/lib/
CAKE_VERSION	2.9.0
CSS	/var/www/vhosts/schoenramer.de/httpdocs/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.schoenramer.de
IMAGES	/var/www/vhosts/schoenramer.de/httpdocs/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/schoenramer.de/httpdocs/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/schoenramer.de/httpdocs/tmp/logs/
ROOT	/var/www/vhosts/schoenramer.de
TESTS	/var/www/vhosts/schoenramer.de/httpdocs/Test/
TMP	/var/www/vhosts/schoenramer.de/httpdocs/tmp/
VENDORS	/var/www/vhosts/schoenramer.de/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/schoenramer.de/httpdocs/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.5.38
User	u99445456456
Home	/var/www/vhosts/schoenramer.de
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	ZuEy95eaN8XzetPFZBlccAAAAAc
Redirect Redirect Script Url	/de/brauerei-bayern
Redirect Redirect Script Uri	https://www.schoenramer.de/de/brauerei-bayern
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Passenger Compile Native Support Binary	0
Redirect Redirect Passenger Download Native Support Binary	0
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	ZuEy95eaN8XzetPFZBlccAAAAAc
Redirect Script Url	/de/brauerei-bayern
Redirect Script Uri	https://www.schoenramer.de/de/brauerei-bayern
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Passenger Compile Native Support Binary	0
Redirect Passenger Download Native Support Binary	0
Redirect Https	on
Redirect Status	200
Unique Id	ZuEy95eaN8XzetPFZBlccAAAAAc
Script Url	/de/brauerei-bayern
Script Uri	https://www.schoenramer.de/de/brauerei-bayern
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Passenger Compile Native Support Binary	0
Passenger Download Native Support Binary	0
Https	on
Proxy-nokeepalive	1
Http Host	www.schoenramer.de
Http X Real Ip	44.222.131.239
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http Accept Encoding	br,gzip
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.schoenramer.de
Server Addr	85.236.63.140
Server Port	443
Remote Addr	44.222.131.239
Document Root	/var/www/vhosts/schoenramer.de/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/schoenramer.de/httpdocs
Server Admin	root@localhost
Script Filename	/var/www/vhosts/schoenramer.de/httpdocs/webroot/index.php
Remote Port	34852
Redirect Url	/webroot/de/brauerei-bayern
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/de/brauerei-bayern
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1726034679.1383
Request Time	1726034679

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.5/share/pear
- 2-> /var/www/vhosts/schoenramer.de/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  FrontendMenus(array)
  Controller(array)
  0FrontendMenus/Controller/FrontendMenusController.php
  1FrontendMenus/Controller/FrontendMenusAppController.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
====

Dem Schönramer Bier auf der SpurBrauereiführungen & Bierverkostungen

Immer aktuell bleiben Aktuelles

Schankschulung der Schönramer Brauerei-Guides

Jetzt anmelden zum 1. Schönramer Bierpongturnier

Dicht und Ergreifend spielen Konzert in Schönram

Erlebe die Welt von Schönramer alsFanclub Mitglied

Newsletter

Instagram

Facebook

Traditionelle Biere

Bierige Spezialitäten

Biermischgetränke

Alkoholfreie Getränke

Schönramer Zwickl

Informationen

Schönramer Lager Hell

Informationen

Schönramer Hell

Auszeichnungen

Informationen

Schönramer Weißbier

Auszeichnungen

Informationen

Schönramer Pils

Auszeichnungen

Informationen

Schönramer Gold

Auszeichnungen

Informationen

Magnum GOLD unfiltriert

Informationen

Schönramer Surtaler

Auszeichnungen

Informationen

Schönramer Dunkel

Auszeichnungen

Informationen

Summa Hoibe

Informationen

Bayrisch Pale Ale

Informationen

Imperial Stout

Informationen

Grünhopfen Pils

Informationen

Weihnachtsfestbier

Auszeichnungen

Informationen

Weißbierbock

Informationen

Heller Bock

Informationen

Schoarama Herbst

Informationen

Schönramer Naturradler

Informationen

X-Mix (Cola-Mix)

Informationen

Cola Mix

Iso-Doni

Informationen

Schönramer Limo

Schönramer Wasser

Greimel Apfe-Schosch

Greimel Früchte-Korbi

Endlich wieder BierzeltAlle Schönramer Veranstaltungen

Händlersuche

Wirtshaussuche

Dafür stehen wir...Philosophie

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 13 ms
Total Queries: 156 queries