Wie können wir helfen?

Haben Sie Fragen zu unseren Angeboten oder zur Buchung?

Wir helfen gerne weiter!

+49 5751 403 980

Geltende Hygiene & Abstandsregeln

natour.NAHes Gesamterlebnis

Willkommen im natour.NAH.zentrum Schillat-Höhle

Neuigkeiten & Infos

Das Schillats Café & Biergarten bleibt am 08.05. geschlossen

03.05.2022

Aufgrund einer anderweitigen Verpflichtung kann das Schillats Café und Biergarten ausnahmsweise am 08.05.2022 leider nicht öffnen.

Bitte beachten Sie dies für Ihren Besuch im natour.NAH.zentrum.

Wir danken für das Verständnis!

Erfolgreicher Start im natour.NAH.zentrum

30.04.2022

Die Eröffnung im natour.NAH.zentrum Schillat-Höhle am 30.04.2022 ist geglückt. Fast alle Termine für eine Führung waren ausgebucht und wir konnten viele Besucher begeistern.

Wir bedanken uns für euren Besuch und freuen uns auf zahlreiche weitere Gäste!

Begrüßung der neuen Pächterin des „Schillats Café & Biergarten“

14.04.2022

Nun ist es offiziell: Das "Schillats Café & Biergarten" eröffnet unter der Leitung von Sandra Becker.

Gestern fand die Begrüßung durch den Bürgermeister der Stadt Hessisch Oldendorf, den Geschäftsführer des Touristikzentrums Westliches Weserbergland und den stellvertretenden Geschäftsführer statt.

Ab dem 16.04.2022 gibt es wieder die Möglichkeit, leckere Kuchen und warme Gerichte im natour.NAH.zentrum Schillat-Höhle zu genießen.

Alle zeigen

Deutschlands nördlichste Tropfsteinhöhle im Naturpark Weserbergland

Entdecken Sie die faszinierende Welt Deutschlands nördlichster Tropfsteinhöhle. Wandern Sie vorbei an Jahrmillionen Erdgeschichte hinein in einen aus Stein gewordenen Märchenwald. Unglaublich sind die Eindrücke, die die Schillat-Höhle mit ihren Felsmalereien, funkelnden Kristallen und leuchtenden Steinen bei Ihnen hinterlassen wird!
Wer wissen möchte, wie die Erde entstand, wieso es die Eiszeit gab, wo einst Meere waren und warum die Dinosaurier verschwanden, ist in der Schillat-Höhle bestens aufgehoben.

Ausgangspunkt für Ihre Wanderung

Das natour.NAH.zentrum Schillat-Höhle ist der ideale Ausgangspunkt für Strecken- und Rundwandertouren.
Der Qualitätswanderweg Weserbergland-Weg (XW) führt direkt am natour.NAH.zentrum Schillat- Höhle vorbei.
Traumhafte Aussichtspunkte, weitläufige Wälder, ein gepflegtes und gut ausgearbeitetes Wanderwegenetz: all das finden Sie im Wandergebiet im Westlichen Weserbergland.
Die sagenhaften Klippen vom Hohenstein, mitten im Naturschutzgebiet gelegen, sind nur eines von vielen Zielen, die Sie über das gute Wegenetz erreichen können.
Also einfach mal die Schuhe schnüren, den Rucksack auf und los geht's!

Die Schillat-Höhle auf Facebook

Powered by Juicer.io

Ticket buchen

Anfahrt Öffnungszeiten

natour.NAH.zentrum:
heute geschlossen

Schillats Café & Biergarten:
heute geschlossen

Kontakt COVID Maßnahmen

Cookie Einstellungen

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

Außerdem verwenden wir Cookies, die 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.

Weitere Informationen finden Sie in unserer Datenschutzerklärung.

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  01
- ids(array)
  Menu1
  Content(null)
  Language1
- route(array)
  id2
  hash98f356f7d3aa5b89aa5ba4d1c2876e81
  created2018-12-20 14:46:55
  updated2022-04-13 12:47:30
  modelMenu
  foreign_key1
  base/
  aliasnaturnahzentrum
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id1
  lft2
  rght27
  route/naturnahzentrum
- 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: 4 ms
Total Queries: 180 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 `schillathoehle`.`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`))) = '/naturnahzentrum' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 2 AND `Route`.`rght` >= 27 ORDER BY `Route`.`lft` asc	2	2	0
SELECT `Language`.`langid` FROM `schillathoehle`.`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 `schillathoehle`.`settings` AS `Setting` LEFT JOIN `schillathoehle`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	35	35	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 `schillathoehle`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 26, 27, 28, 29, 30, 31, 32, 37, 38, 39, 40, 41, 42, 45, 46) 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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (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`, (`Content`.`status` = "active") AS `Content__isActive` FROM `schillathoehle`.`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	9	9	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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 235 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 212 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 48 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 132 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 37 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 218 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 236 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 122 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 `schillathoehle`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 123 AND `Route`.`model` = 'Content'	1	1	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`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	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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`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 `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'navi' 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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 46 ORDER BY `Menu`.`lft` asc	21	21	0
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'contact_box' 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 79 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 203 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 203 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (79) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (79) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 79 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (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`, (`Content`.`status` = "active") AS `Content__isActive`, `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`, `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`.`internal_keywords`, `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 `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 79 AND `Content`.`status` = 'active' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ArticleContentMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 127 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `GalleryMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 127 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 127 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 127 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menus`.`id`, `Menus`.`hash`, `Menus`.`created`, `Menus`.`updated`, `Menus`.`parent_id`, `Menus`.`lft`, `Menus`.`rght`, `Menus`.`language_id`, `Menus`.`type`, `Menus`.`title`, `Menus`.`previous_url`, `Menus`.`url`, `Menus`.`target_blank`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `schillathoehle`.`menus` AS `Menus` JOIN `schillathoehle`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 127 AND `ContentsMenu`.`menu_id` = `Menus`.`id`) ORDER BY `ContentsMenu`.`position` 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 79	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 205 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 206 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 205 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 206 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` IN (80, 81) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` IN (80, 81) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (80, 81) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'de' LIMIT 1	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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	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 `schillathoehle`.`languages` AS `Language` LEFT JOIN `schillathoehle`.`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 `schillathoehle`.`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 `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 `schillathoehle`.`languages` AS `Language` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 1 LIMIT 1	1	1	0
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_legal' 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 27 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 58 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 58 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (27) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (27) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 27 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 27	3	3	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 59 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 60 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 61 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 59 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 60 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 61 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` IN (28, 29, 30) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` IN (28, 29, 30) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (28, 29, 30) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_organizer' 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 35 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 66 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 66 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (35) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (35) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 35 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (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`, (`Content`.`status` = "active") AS `Content__isActive`, `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`, `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`.`internal_keywords`, `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 `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 35 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ArticleContentMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 33 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `GalleryMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 33 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 33 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 33 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menus`.`id`, `Menus`.`hash`, `Menus`.`created`, `Menus`.`updated`, `Menus`.`parent_id`, `Menus`.`lft`, `Menus`.`rght`, `Menus`.`language_id`, `Menus`.`type`, `Menus`.`title`, `Menus`.`previous_url`, `Menus`.`url`, `Menus`.`target_blank`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `schillathoehle`.`menus` AS `Menus` JOIN `schillathoehle`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 33 AND `ContentsMenu`.`menu_id` = `Menus`.`id`) ORDER BY `ContentsMenu`.`position` 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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 35	1	1	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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (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`, (`Content`.`status` = "active") AS `Content__isActive` FROM `schillathoehle`.`contents` AS `Content` WHERE `Content`.`menu_id` = (36)	2	2	1	maybe slow
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_partner' AND `Language`.`langid` = 'de' LIMIT 1	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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`parent_id` IS NULL ORDER BY `Menu`.`lft` asc	8	8	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` IN (1, 5, 26, 65, 66, 67, 71, 79) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_icons' 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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 58 AND `Menu`.`rght` < 65 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` IN (101, 111, 112) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'registration' 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 67 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 120 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 120 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (67) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (67) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 67 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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 67	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'side_navigation' 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`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 74 AND `Menu`.`rght` < 83 ORDER BY `Menu`.`lft` asc	4	4	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` IN (72, 73, 74, 75) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT *, Language.id FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `schillathoehle`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'times' 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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 73 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 196 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 196 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (73) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (73) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 73 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Time`.`id`, `Time`.`hash`, `Time`.`created`, `Time`.`updated`, `Time`.`position`, `Time`.`type`, `Time`.`weekday`, `Time`.`time_from`, `Time`.`time_to`, `Time`.`closed` FROM `schillathoehle`.`times` AS `Time` WHERE `weekday` = 'tuesday' AND `type` = 'main' LIMIT 1	1	1	0
SELECT `TimeException`.`id`, `TimeException`.`hash`, `TimeException`.`created`, `TimeException`.`updated`, `TimeException`.`position`, `TimeException`.`type`, `TimeException`.`weekday`, `TimeException`.`time_id`, `TimeException`.`date_from`, `TimeException`.`date_to`, `TimeException`.`new_time_from`, `TimeException`.`new_time_to`, `TimeException`.`new_closed` FROM `schillathoehle`.`time_exceptions` AS `TimeException` WHERE `TimeException`.`time_id` = (3)	0	0	0
SELECT `Time`.`id`, `Time`.`hash`, `Time`.`created`, `Time`.`updated`, `Time`.`position`, `Time`.`type`, `Time`.`weekday`, `Time`.`time_from`, `Time`.`time_to`, `Time`.`closed` FROM `schillathoehle`.`times` AS `Time` WHERE `weekday` = 'tuesday' AND `type` = 'gastronomy' LIMIT 1	1	1	0
SELECT `TimeException`.`id`, `TimeException`.`hash`, `TimeException`.`created`, `TimeException`.`updated`, `TimeException`.`position`, `TimeException`.`type`, `TimeException`.`weekday`, `TimeException`.`time_id`, `TimeException`.`date_from`, `TimeException`.`date_to`, `TimeException`.`new_time_from`, `TimeException`.`new_time_to`, `TimeException`.`new_closed` FROM `schillathoehle`.`time_exceptions` AS `TimeException` WHERE `TimeException`.`time_id` = (11)	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 `schillathoehle`.`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`))) = '/naturnahzentrum/einstieg' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 23 AND `Route`.`rght` >= 24 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 235 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 343 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `schillathoehle`.`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`))) = '/naturnahzentrum/animation-hartmut' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 19 AND `Route`.`rght` >= 20 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 212 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 315 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `schillathoehle`.`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`))) = '/naturnahzentrum/neuigkeiten-infos' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `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`, `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`.`internal_keywords`, `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 `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 48 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 110 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 110 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ArticleContentMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 48 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `GalleryMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 48 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 48 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 48 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menus`.`id`, `Menus`.`hash`, `Menus`.`created`, `Menus`.`updated`, `Menus`.`parent_id`, `Menus`.`lft`, `Menus`.`rght`, `Menus`.`language_id`, `Menus`.`type`, `Menus`.`title`, `Menus`.`previous_url`, `Menus`.`url`, `Menus`.`target_blank`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `schillathoehle`.`menus` AS `Menus` JOIN `schillathoehle`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 48 AND `ContentsMenu`.`menu_id` = `Menus`.`id`) ORDER BY `ContentsMenu`.`position` ASC	0	0	0
SELECT `News`.`id`, `News`.`hash`, `News`.`created`, `News`.`updated`, `News`.`title`, `News`.`pubdate`, `News`.`status`, `News`.`teaser_type`, `News`.`news_target`, `News`.`teaser_external_url`, `News`.`teaser_menu_id`, `News`.`content`, `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 `schillathoehle`.`news` AS `News` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `News`.`id` AND `Route`.`model` = 'News') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `News`.`id` AND `Teaser`.`model` = 'News') WHERE 1 = 1 ORDER BY `News`.`pubdate` DESC LIMIT 3	3	3	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 362 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 `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (40) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 361 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 `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (75) 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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 356 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 `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (71) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	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`, `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`.`internal_keywords`, `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 `schillathoehle`.`menus` AS `Menu` LEFT JOIN `schillathoehle`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `schillathoehle`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 13 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`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 `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`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 `IconsUpload`.`id`, `IconsUpload`.`hash`, `IconsUpload`.`created`, `IconsUpload`.`updated`, `IconsUpload`.`model`, `IconsUpload`.`field`, `IconsUpload`.`foreign_key`, `IconsUpload`.`alias`, `IconsUpload`.`thumbnail`, `IconsUpload`.`parent_id`, `IconsUpload`.`file`, `IconsUpload`.`size`, `IconsUpload`.`ext`, `IconsUpload`.`mime`, `IconsUpload`.`width`, `IconsUpload`.`height` FROM `schillathoehle`.`uploads` AS `IconsUpload` WHERE `IconsUpload`.`model` = 'Menu' AND `IconsUpload`.`field` = 'icons' AND `IconsUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`IconsUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `BackgroundVideoUpload`.`id`, `BackgroundVideoUpload`.`hash`, `BackgroundVideoUpload`.`created`, `BackgroundVideoUpload`.`updated`, `BackgroundVideoUpload`.`model`, `BackgroundVideoUpload`.`field`, `BackgroundVideoUpload`.`foreign_key`, `BackgroundVideoUpload`.`alias`, `BackgroundVideoUpload`.`thumbnail`, `BackgroundVideoUpload`.`parent_id`, `BackgroundVideoUpload`.`file`, `BackgroundVideoUpload`.`size`, `BackgroundVideoUpload`.`ext`, `BackgroundVideoUpload`.`mime`, `BackgroundVideoUpload`.`width`, `BackgroundVideoUpload`.`height` FROM `schillathoehle`.`uploads` AS `BackgroundVideoUpload` WHERE `BackgroundVideoUpload`.`model` = 'Menu' AND `BackgroundVideoUpload`.`field` = 'background_video' AND `BackgroundVideoUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `HeaderImagesMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 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 `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (35) 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 `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `schillathoehle`.`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_index' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `schillathoehle`.`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`))) = '/naturnahzentrum/willkommen' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 15 AND `Route`.`rght` >= 16 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 132 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 214 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `schillathoehle`.`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`))) = '/naturnahzentrum/galerie' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 37 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 94 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `GalleryMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 37 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	5	5	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 `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (18, 13, 22, 23, 24) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	46	46	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 `schillathoehle`.`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`))) = '/naturnahzentrum/ausgangspunkt-wanderung' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 21 AND `Route`.`rght` >= 22 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 218 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 321 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `schillathoehle`.`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`))) = '/naturnahzentrum/wanderung' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 25 AND `Route`.`rght` >= 26 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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 236 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 344 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `GalleryMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 236 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' 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 `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (48) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	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 `schillathoehle`.`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`))) = '/naturnahzentrum/die-schillat-hoehle-auf-facebook' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 122 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 190 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `schillathoehle`.`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`))) = '/naturnahzentrum/juicer' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`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`.`question`, `Content`.`answer`, `Content`.`faq_index_1`, `Content`.`faq_index_2`, `Content`.`faq_index_3`, `Content`.`gutter`, `Content`.`arrangement_subject`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `schillathoehle`.`contents` AS `Content` LEFT JOIN `schillathoehle`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 123 AND (1=1) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`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 `schillathoehle`.`media` AS `ImageMedia` JOIN `schillathoehle`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 191 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `schillathoehle`.`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 `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`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 `schillathoehle`.`mount_points` AS `MountPoint` LEFT JOIN `schillathoehle`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `schillathoehle`.`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 11.35 MB

Message	Memory use
Component initialization	1.74 MB
Controller action start	2.75 MB
Controller render start	3.00 MB
Component initialization #2	4.22 MB
Controller action start #2	4.31 MB
Controller render start #2	4.39 MB
Component initialization #3	4.57 MB
Controller action start #3	4.59 MB
Controller render start #3	4.67 MB
Component initialization #4	4.81 MB
Controller action start #4	4.83 MB
Controller render start #4	5.17 MB
Component initialization #5	5.33 MB
Controller action start #5	5.35 MB
Controller render start #5	5.43 MB
Component initialization #6	5.58 MB
Controller action start #6	5.59 MB
Controller render start #6	5.77 MB
Component initialization #7	5.93 MB
Controller action start #7	5.94 MB
Controller render start #7	6.03 MB
Component initialization #8	6.17 MB
Controller action start #8	6.18 MB
Controller render start #8	6.30 MB
Component initialization #9	6.44 MB
Controller action start #9	6.45 MB
Controller render start #9	6.54 MB
Component initialization #10	6.68 MB
Controller action start #10	6.70 MB
Controller render start #10	6.78 MB
View render complete	6.91 MB

Timers

Total Request Time: 433 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	94.53
Event: Controller.initialize	37.92
Event: Controller.startup	3.88
Controller action	12.71
Event: Controller.beforeRender	79.69
» Processing toolbar data	14.88
Rendering View	125.05
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	112.71
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	112.01
» » » Event: Controller.initialize #2	0.38
» » » Event: Controller.startup #2	0.13
» » » Controller action #2	1.48
» » » Event: Controller.beforeRender #2	5.68
» » » » Processing toolbar data #2	5.60
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.03
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	1.80
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.42
» » » » Event: View.afterRender	0.02
» » » » Event: Controller.shutdown	0.02
» » » » Event: Controller.initialize #3	0.29
» » » » Event: Controller.startup #3	0.12
» » » » Controller action #3	1.13
» » » » Event: Controller.beforeRender #3	4.94
» » » » » Processing toolbar data #3	4.87
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.03
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/developer_template.php	0.46
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.30
» » » » » Event: View.afterRender #2	0.02
» » » » » Event: Controller.shutdown #2	0.01
» » » » » Event: Controller.initialize #4	0.38
» » » » » Event: Controller.startup #4	0.12
» » » » » Controller action #4	13.75
» » » » » Event: Controller.beforeRender #4	5.37
» » » » » » Processing toolbar data #4	5.30
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.03
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/news_preview.php	3.31
» » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser-news.php	0.52
» » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser-news.php #2	0.42
» » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser-news.php #3	0.57
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.32
» » » » » » Event: View.afterRender #3	0.02
» » » » » » Event: Controller.shutdown #3	0.01
» » » » » » Event: Controller.initialize #5	0.29
» » » » » » Event: Controller.startup #5	0.12
» » » » » » Controller action #5	1.10
» » » » » » Event: Controller.beforeRender #5	4.97
» » » » » » » Processing toolbar data #5	4.89
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.03
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	0.79
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.31
» » » » » » » Event: View.afterRender #4	0.02
» » » » » » » Event: Controller.shutdown #4	0.01
» » » » » » » Event: Controller.initialize #6	0.37
» » » » » » » Event: Controller.startup #6	0.13
» » » » » » » Controller action #6	2.14
» » » » » » » Event: Controller.beforeRender #6	5.16
» » » » » » » » Processing toolbar data #6	5.08
Rendering View #6	0.00
» » » » » » » » Event: View.beforeRender #6	0.03
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/gallery_mosaic.php	0.82
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.31
» » » » » » » » Event: View.afterRender #5	0.02
» » » » » » » » Event: Controller.shutdown #5	0.01
» » » » » » » » Event: Controller.initialize #7	0.32
» » » » » » » » Event: Controller.startup #7	0.12
» » » » » » » » Controller action #7	1.14
» » » » » » » » Event: Controller.beforeRender #7	5.13
» » » » » » » » » Processing toolbar data #7	5.05
Rendering View #7	0.00
» » » » » » » » » Event: View.beforeRender #7	0.03
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	0.86
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #6	0.32
» » » » » » » » » Event: View.afterRender #6	0.02
» » » » » » » » » Event: Controller.shutdown #6	0.01
» » » » » » » » » Event: Controller.initialize #8	0.35
» » » » » » » » » Event: Controller.startup #8	0.14
» » » » » » » » » Controller action #8	1.86
» » » » » » » » » Event: Controller.beforeRender #8	5.29
» » » » » » » » » » Processing toolbar data #8	5.21
Rendering View #8	0.00
» » » » » » » » » » Event: View.beforeRender #8	0.07
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/gallery.php	1.18
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php #2	0.51
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7	0.32
» » » » » » » » » » Event: View.afterRender #7	0.02
» » » » » » » » » » Event: Controller.shutdown #7	0.01
» » » » » » » » » » Event: Controller.initialize #9	0.36
» » » » » » » » » » Event: Controller.startup #9	0.13
» » » » » » » » » » Controller action #9	1.17
» » » » » » » » » » Event: Controller.beforeRender #9	5.32
» » » » » » » » » » » Processing toolbar data #9	5.24
Rendering View #9	0.00
» » » » » » » » » » » Event: View.beforeRender #9	0.03
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #4	0.67
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #8	0.31
» » » » » » » » » » » Event: View.afterRender #8	0.02
» » » » » » » » » » » Event: Controller.shutdown #8	0.01
» » » » » » » » » » » Event: Controller.initialize #10	0.29
» » » » » » » » » » » Event: Controller.startup #10	0.14
» » » » » » » » » » » Controller action #10	1.16
» » » » » » » » » » » Event: Controller.beforeRender #10	5.12
» » » » » » » » » » » » Processing toolbar data #10	5.04
Rendering View #10	0.00
» » » » » » » » » » » » Event: View.beforeRender #10	0.03
» » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/developer_template.php #2	0.44
» » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #9	0.30
» » » » » » » » » » » » Event: View.afterRender #9	0.02
» » » » » » » » » » » » Event: Controller.shutdown #9	0.01
» » » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #10	0.28
» » » » » » » » » » Event: View.afterRender #10	0.45
» » » » » » » » » » Event: View.beforeLayout	0.02
» » » » » » » » » » Rendering APP/View/Layouts/index.php	9.50
» » » » » » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.32
» » » » » » » » » » » Rendering APP/View/Elements/navi.php	1.30
» » » » » » » » » » » Rendering APP/View/Elements/header.php	0.77
» » » » » » » » » » » Rendering APP/View/Elements/contactBox.php	0.75
» » » » » » » » » » » Rendering APP/View/Elements/sideNav.php	0.57
» » » » » » » » » » » Rendering APP/View/Elements/footer.php	0.62
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id1
  hash330f306678e7c1af20bb9e3533f96d1c
  created2018-12-20 14:46:55
  updated2022-04-13 12:47:29
  parent_id(null)
  lft1
  rght2
  language_id1
  typecontent
  titleStartseite
  previous_urlhttps://www.schillathoehle.de/de/home/
  url(null)
  target_blank(false)
  Seo(array)
  id1
  hash8e0a00b7c46235facc458af77024bfd3
  created2018-12-20 14:46:55
  updated2022-04-13 12:47:30
  modelMenu
  foreign_key1
  titlenatour.NAH.zentrum Schillat-Höhle | Westliches Weserbergland
  descriptionDas natour.NAH.zentrum lädt alle Besucher herzlich zu einem einzigartigen Erlebnis ein. Eine spannende 3D Show, Höhlenführungen & weitere tolle Angebote erwarten Sie.
  internal_keywords
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id235
  hash71191f50d32552cd6b83271871735f58
  created2022-04-08 15:44:00
  updated2022-04-08 15:45:15
  menu_id1
  position1
  typearticle
  statusactive
  titleEinstieg
  layoutcol12
  language_id1
  article_content<h1>natour.NAHes Gesamterlebnis</h1> <h2>Willkommen im natour.NAH.zentrum Schillat-Höhle</h2>
  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_typeroadmap
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id361
  hash95c126020979e91bce028d782d81a64e
  created2022-04-08 15:44:00
  updated2022-04-08 15:45:15
  modelContent
  foreign_key235
  base/naturnahzentrum/
  aliaseinstieg
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id2
  lft23
  rght24
  route/naturnahzentrum/einstieg
  1(array)
  id212
  hashefb3b40686c1cac7c42f6c20857fe960
  created2022-04-06 10:34:03
  updated2022-04-13 12:53:30
  menu_id1
  position2
  typedeveloper_template
  statusactive
  titleAnimation Hartmut
  layoutcol12
  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_typeroadmap
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code<div style="padding:66.54% 0 0 0;position:relative;"><iframe src="https://player.vimeo.com/video/696445247?h=3121255c1e&autoplay=1&loop=1&title=0&byline=0&portrait=0?background=1" style="position:absolute;top:0;left:0;width:100%;height:100%;" frameborder="0" allow="autoplay; fullscreen; picture-in-picture" allowfullscreen></iframe></div><script src="https://player.vimeo.com/api/player.js"></script>
  developer_template_css
  developer_template_js
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id326
  hashc7e6946b60c23f92b5e2f5117d68d021
  created2022-04-06 10:34:03
  updated2022-04-13 12:53:30
  modelContent
  foreign_key212
  base/naturnahzentrum/
  aliasanimation-hartmut
  controllerFrontendContents.FrontendContents
  actiondeveloper_template
  parent_id2
  lft19
  rght20
  route/naturnahzentrum/animation-hartmut
  2(array)
  id48
  hash0573d6a1b32ec667845af6da78b7df18
  created2020-01-17 09:03:47
  updated2022-04-11 13:50:41
  menu_id1
  position3
  typenews_preview
  statusactive
  titleNeuigkeiten & Infos
  layoutcol12
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id111
  hash125abc0d95d0d5877ce91e5fa47acfda
  created2020-01-17 09:03:47
  updated2022-04-11 13:50:41
  modelContent
  foreign_key48
  base/naturnahzentrum/
  aliasneuigkeiten-infos
  controllerFrontendContents.FrontendContents
  actionnews_preview
  parent_id2
  lft7
  rght8
  route/naturnahzentrum/neuigkeiten-infos
  3(array)
  id132
  hash375b95d133d60282669ca87803cb28d1
  created2022-03-21 12:19:19
  updated2022-04-08 15:45:04
  menu_id1
  position4
  typearticle
  statusactive
  titleWillkommen
  layoutcol12
  language_id1
  article_content<h3>Deutschlands nördlichste Tropfsteinhöhle im Naturpark Weserbergland</h3> <p>Entdecken Sie die faszinierende Welt Deutschlands nördlichster Tropfsteinhöhle. Wandern Sie vorbei an Jahrmillionen Erdgeschichte hinein in einen aus Stein gewordenen Märchenwald. Unglaublich sind die Eindrücke, die die Schillat-Höhle mit ihren Felsmalereien, funkelnden Kristallen und leuchtenden Steinen bei Ihnen hinterlassen wird!<br /> Wer wissen möchte, wie die Erde entstand, wieso es die Eiszeit gab, wo einst Meere waren und warum die Dinosaurier verschwanden, ist in der Schillat-Höhle bestens aufgehoben.</p>
  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_typeroadmap
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id217
  hashc3704e585cd6e3f3544c168361f338c6
  created2022-03-21 12:19:19
  updated2022-04-08 15:45:04
  modelContent
  foreign_key132
  base/naturnahzentrum/
  aliaswillkommen
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id2
  lft15
  rght16
  route/naturnahzentrum/willkommen
  4(array)
  id37
  hash462fb67760858932f83d76bba6e183af
  created2020-01-15 13:07:50
  updated2022-03-23 11:22:01
  menu_id1
  position5
  typegallery_mosaic
  statusactive
  titleGalerie
  layoutcol12
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id95
  hash6c3f66c058620590b8b4f52e37dbca2d
  created2020-01-15 13:07:50
  updated2022-03-23 11:22:01
  modelContent
  foreign_key37
  base/naturnahzentrum/
  aliasgalerie
  controllerFrontendContents.FrontendContents
  actiongallery_mosaic
  parent_id2
  lft5
  rght6
  route/naturnahzentrum/galerie
  5(array)
  id218
  hash5331ce232c498cd1493703489c8d4b58
  created2022-04-06 12:42:40
  updated2022-04-06 12:51:40
  menu_id1
  position6
  typearticle
  statusactive
  titleAusgangspunkt Wanderung
  layoutcol12
  language_id1
  article_content<h3>Ausgangspunkt für Ihre Wanderung</h3> <p>Das natour.NAH.zentrum Schillat-Höhle ist der ideale Ausgangspunkt für Strecken- und Rundwandertouren. <br /> Der Qualitätswanderweg Weserbergland-Weg (XW) führt direkt am natour.NAH.zentrum Schillat- Höhle vorbei. <br /> Traumhafte Aussichtspunkte, weitläufige Wälder, ein gepflegtes und gut ausgearbeitetes Wanderwegenetz: all das finden Sie im Wandergebiet im Westlichen Weserbergland. <br /> Die sagenhaften Klippen vom Hohenstein, mitten im Naturschutzgebiet gelegen, sind nur eines von vielen Zielen, die Sie über das gute Wegenetz erreichen können. <br /> Also einfach mal die Schuhe schnüren, den Rucksack auf und los geht's! </p>
  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_typeroadmap
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id333
  hashf0b99f8df76611bbec9d00b6852a14e2
  created2022-04-06 12:42:40
  updated2022-04-06 12:51:40
  modelContent
  foreign_key218
  base/naturnahzentrum/
  aliasausgangspunkt-wanderung
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id2
  lft21
  rght22
  route/naturnahzentrum/ausgangspunkt-wanderung
  6(array)
  id236
  hash7e13ffa341587aa9cf3717aea65ec104
  created2022-04-11 10:33:35
  updated2022-04-11 10:33:48
  menu_id1
  position7
  typegallery
  statusactive
  titleWanderung
  layoutcol12
  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_typeroadmap
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id362
  hashb8e61a751b09c99410f8abef07912bd1
  created2022-04-11 10:33:35
  updated2022-04-11 10:33:48
  modelContent
  foreign_key236
  base/naturnahzentrum/
  aliaswanderung
  controllerFrontendContents.FrontendContents
  actiongallery
  parent_id2
  lft25
  rght26
  route/naturnahzentrum/wanderung
  7(array)
  id122
  hash575bbdd8005a93aded410969023f11f5
  created2020-01-28 09:04:50
  updated2022-03-23 09:53:15
  menu_id1
  position11
  typearticle
  statusactive
  titleDie Schillat-Höhle auf Facebook
  layoutcol12
  language_id1
  article_content<h2>Die Schillat-Höhle auf Facebook</h2>
  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)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id193
  hash16f209449e1c8f0ed1679829a8fdf639
  created2020-01-28 09:04:50
  updated2022-03-23 09:53:15
  modelContent
  foreign_key122
  base/naturnahzentrum/
  aliasdie-schillat-hoehle-auf-facebook
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id2
  lft9
  rght10
  route/naturnahzentrum/die-schillat-hoehle-auf-facebook
  8(array)
  id123
  hash4a6a51f71ad3f6711156bd540d65358d
  created2020-01-28 09:05:50
  updated2022-03-23 12:42:31
  menu_id1
  position12
  typedeveloper_template
  statusactive
  titleJuicer
  layoutcol12
  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<script src="https://assets.juicer.io/embed.js" type="text/javascript"></script> <link href="https://assets.juicer.io/embed.css" media="all" rel="stylesheet" type="text/css" /> <ul class="juicer-feed" data-feed-id="westlichesweserbergland"data-per=6><h1 class="referral"><a href="https://www.juicer.io">Powered by Juicer.io</a></h1></ul>
  developer_template_css
  developer_template_js
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  question(null)
  answer(null)
  faq_index_1(null)
  faq_index_2(null)
  faq_index_3(null)
  gutter(null)
  arrangement_subject(null)
  gmap
  published1
  isActive1
  Route(array)
  id194
  hashcc5a9814b1cddf5797e42010624fca26
  created2020-01-28 09:05:50
  updated2022-03-23 12:42:31
  modelContent
  foreign_key123
  base/naturnahzentrum/
  aliasjuicer
  controllerFrontendContents.FrontendContents
  actiondeveloper_template
  parent_id2
  lft11
  rght12
  route/naturnahzentrum/juicer
  HeaderImagesMedia(empty)
- $request->data(empty)
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Menu(empty)
  Parent(empty)
  HeaderImagesMedia(empty)
  MediaEntity(empty)
  Seo(empty)
  ImageMedia(empty)
  Teaser(empty)
  Content(empty)
  ArticleContentMedia(empty)
  GalleryMedia(empty)
  Menus(empty)
  Setting(empty)
  ValueUpload(empty)
  FileUpload(empty)
  Time(empty)
  IconsUpload(empty)
  BackgroundVideoUpload(empty)
  ContentsMenu(empty)
  FlagUpload(empty)
  TimeException(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7SocialMedia
  8GMap
  9Embed
  10Layout
  11Enum
  12ThirdPartyCookies
  13Number
  14SimpleGraph
  15DebugTimer
  16Toolbar
  17Session
  18Js
  19HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.2.34
User	u4389573945789345
Home	/var/www/vhosts/schillathoehle.de
Script Name	/webroot/index.php
Request Uri	/naturnahzentrum
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/naturnahzentrum
Remote Port	41622
Script Filename	/var/www/vhosts/schillathoehle.de/httpdocs/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/schillathoehle.de/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/schillathoehle.de/httpdocs
Remote Addr	3.236.234.223
Server Port	443
Server Addr	62.116.174.157
Server Name	www.schillathoehle.de
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	3.236.234.223
Http Host	www.schillathoehle.de
Proxy-nokeepalive	1
Https	on
Unique Id	YoQIphaZdGEvWixCotcx9AAAAAc
Redirect Status	200
Redirect Https	on
Redirect Unique Id	YoQIphaZdGEvWixCotcx9AAAAAc
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Unique Id	YoQIphaZdGEvWixCotcx9AAAAAc
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1652820134.2895
Request Time	1652820134

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.2/share/pear
- 2-> /var/www/vhosts/schillathoehle.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
  11BaseData/Model/Behavior/HabtmBehavior.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
====

Wie können wir helfen?

natour.NAHes Gesamterlebnis

Willkommen im natour.NAH.zentrum Schillat-Höhle

Neuigkeiten & Infos

Das Schillats Café & Biergarten bleibt am 08.05. geschlossen

Erfolgreicher Start im natour.NAH.zentrum

Begrüßung der neuen Pächterin des „Schillats Café & Biergarten“

Deutschlands nördlichste Tropfsteinhöhle im Naturpark Weserbergland

Ausgangspunkt für Ihre Wanderung

Die Schillat-Höhle auf Facebook

Powered by Juicer.io

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 4 ms Total Queries: 180 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 4 ms
Total Queries: 180 queries