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

3D.natour.NAH.raum

Erleben Sie spannende 3D-Shows in unserem Kleinkino

Film 1: 3D-Show „Der Süntel mit den Augen des Uhus“

Erleben Sie die außergewöhnlichen Schönheiten der Natur im Weserbergland aus den ungewöhnlichsten Perspektiven. In rund 15 Minuten erfahren Sie auf einer Reise durch das Waldgebirge Süntel mehr über die Entstehung von Höhlensystemen, die Nutzung des Gesteins, die Naturveränderungen im Wandel der Jahreszeiten sowie die Besonderheiten der heimischen Flora und Fauna. Spezielle Makro-Aufnahmen faszinieren durch ungeahnte Details und machen die kleine Welt ganz groß.

Film 2: 3D-Show „Die Riesenberghöhle“

Eines der Top-Highlights jeder regulären Führung in der Schillat-Höhle, die 15-minütige 3D-Show „Die Riesenberghöhle“. Gewinnen Sie verborgene Einblicke in die größte Tropfsteinhöhle Niedersachsens, die Riesenberghöhle im Süntel. Sie zählt mit rund 800m Länge zu den großen Höhlen Deutschlands und Europas. Im Juli 1969 wurde die Höhle nach einer Sprengung im Steinbruch entdeckt. Dieses Meisterwerk der Natur steht unter Naturschutz. Die Riesenberghöhle ist reich an Tropfsteingebilden: Zahlreiche Stalaktiten und Makkaronis hängen von der Höhlenwand. Stalagmiten mit unterschiedlichen Höhen und Durchmessern säumen den Höhlenboden.

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
  time1652836805
  countdown10
  languagede
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  0110
- ids(array)
  Menu110
  Content(null)
  Language1
- route(array)
  id349
  hash250d203abc2bc6b0f3d9c075447adfc6
  created2022-04-06 14:20:24
  updated2022-04-12 11:08:00
  modelMenu
  foreign_key110
  base/
  alias3d-natour-nah-raum
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id38
  lft150
  rght157
  route/3d-natour-nah-raum
- 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: 135 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`))) = '/3d-natour-nah-raum' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 150 AND `Route`.`rght` >= 157 ORDER BY `Route`.`lft` asc	4	4	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` = 110 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` = 334 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` = (110) ORDER BY `Content`.`position` asc	3	3	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` = 229 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` = 227 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` = 228 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` = 110 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` = (53) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` = 110 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` = 334 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` = (110) 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` = (110) ORDER BY FIELD(COALESCE(`BackgroundVideoUpload`.`thumbnail`, -1), -1) DESC	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` = 'home' 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` = 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 `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 `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 `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` = 110 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`))) = '/3d-natour-nah-raum/ueberschrift-einleitung' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 155 AND `Route`.`rght` >= 156 ORDER BY `Route`.`lft` asc	5	5	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` = 229 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` = 337 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`))) = '/3d-natour-nah-raum/augen-des-uhus' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 151 AND `Route`.`rght` >= 152 ORDER BY `Route`.`lft` asc	5	5	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` = 227 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` = 335 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `schillathoehle`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `schillathoehle`.`media` AS `Media` WHERE `Media`.`id` = 47 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `schillathoehle`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (47) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `schillathoehle`.`tags` AS `TagsTag` JOIN `schillathoehle`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 47 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	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`))) = '/3d-natour-nah-raum/riesenberghoehle' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `schillathoehle`.`routes` AS `Route` WHERE `Route`.`lft` <= 153 AND `Route`.`rght` >= 154 ORDER BY `Route`.`lft` asc	5	5	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` = 228 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` = 336 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 7.80 MB

Message	Memory use
Component initialization	1.74 MB
Controller action start	2.74 MB
Controller render start	2.95 MB
Component initialization #2	4.20 MB
Controller action start #2	4.29 MB
Controller render start #2	4.37 MB
Component initialization #3	4.56 MB
Controller action start #3	4.57 MB
Controller render start #3	4.65 MB
Component initialization #4	4.90 MB
Controller action start #4	4.91 MB
Controller render start #4	5.00 MB
View render complete	5.11 MB

Timers

Total Request Time: 345 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	97.71
Event: Controller.initialize	37.89
Event: Controller.startup	3.68
Controller action	11.32
Event: Controller.beforeRender	76.68
» Processing toolbar data	11.37
Rendering View	56.17
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	43.75
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	43.03
» » » Event: Controller.initialize #2	0.38
» » » Event: Controller.startup #2	0.13
» » » Controller action #2	1.44
» » » Event: Controller.beforeRender #2	5.36
» » » » Processing toolbar data #2	5.28
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.03
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	1.94
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.43
» » » » Event: View.afterRender	0.02
» » » » Event: Controller.shutdown	0.02
» » » » Event: Controller.initialize #3	0.30
» » » » Event: Controller.startup #3	0.12
» » » » Controller action #3	1.11
» » » » Event: Controller.beforeRender #3	4.70
» » » » » Processing toolbar data #3	4.63
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.03
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	8.82
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.33
» » » » » Event: View.afterRender #2	0.02
» » » » » Event: Controller.shutdown #2	0.01
» » » » » Event: Controller.initialize #4	0.30
» » » » » Event: Controller.startup #4	0.12
» » » » » Controller action #4	1.12
» » » » » Event: Controller.beforeRender #4	5.10
» » » » » » Processing toolbar data #4	5.02
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.03
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	0.77
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.32
» » » » » » Event: View.afterRender #3	0.02
» » » » » » Event: Controller.shutdown #3	0.01
» » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #4	0.28
» » » » Event: View.afterRender #4	0.44
» » » » Event: View.beforeLayout	0.02
» » » » Rendering APP/View/Layouts/index.php	9.69
» » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.31
» » » » » Rendering APP/View/Elements/navi.php	1.50
» » » » » Rendering APP/View/Elements/header.php	0.39
» » » » » Rendering APP/View/Elements/contactBox.php	0.79
» » » » » Rendering APP/View/Elements/sideNav.php	0.57
» » » » » Rendering APP/View/Elements/footer.php	0.69
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id110
  hashde128ed1957eff573e0442ad0ec1f376
  created2022-04-06 14:20:24
  updated2022-04-12 11:08:00
  parent_id7
  lft31
  rght32
  language_id1
  typecontent
  title3D natour.NAH.raum
  previous_urlhttps://www.schillathoehle.de/de/3d-natournahraum/
  url(null)
  target_blank(false)
  Seo(array)
  id334
  hash84df42b451dc0eb9d4a069b792322fe3
  created2022-04-06 14:20:24
  updated2022-04-12 11:08:00
  modelMenu
  foreign_key110
  title3D natour.NAH.raum im natour.NAH.Zentrum Schillat-Höhle
  descriptionErleben Sie die außergewöhnlichen Schönheiten der Natur im Weserbergland aus den ungewöhnlichsten Perspektiven.
  internal_keywords
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id229
  hashf5d4ccdd6d92205ab118c66c6ba90f83
  created2022-04-06 14:24:41
  updated2022-04-14 09:49:25
  menu_id110
  position1
  typearticle
  statusactive
  titleÜberschrift Einleitung
  layoutcol12
  language_id1
  article_content<h1>3D.natour.NAH.raum</h1> <h2>Erleben Sie spannende 3D-Shows in unserem Kleinkino</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)
  id352
  hashe7358fda07e6224bcf293adf23a82d5c
  created2022-04-06 14:24:41
  updated2022-04-14 09:49:25
  modelContent
  foreign_key229
  base/3d-natour-nah-raum/
  aliasueberschrift-einleitung
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id349
  lft155
  rght156
  route/3d-natour-nah-raum/ueberschrift-einleitung
  1(array)
  id227
  hash45936561c5ad37d9ffde299ea78ba46d
  created2022-04-06 14:22:08
  updated2022-04-14 09:48:45
  menu_id110
  position2
  typearticle
  statusactive
  titleAugen des Uhus
  layoutcol12
  language_id1
  article_content<h3>Film 1: 3D-Show „Der Süntel mit den Augen des Uhus“</h3> <figure class="figure-responsive"> <div class="img-responsive" data-media-id="47" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> <p> </p> <p>Erleben Sie die außergewöhnlichen Schönheiten der Natur im Weserbergland aus den ungewöhnlichsten Perspektiven. In rund 15 Minuten erfahren Sie auf einer Reise durch das Waldgebirge Süntel mehr über die Entstehung von Höhlensystemen, die Nutzung des Gesteins, die Naturveränderungen im Wandel der Jahreszeiten sowie die Besonderheiten der heimischen Flora und Fauna. Spezielle Makro-Aufnahmen faszinieren durch ungeahnte Details und machen die kleine Welt ganz groß.</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)
  id350
  hashce8c477dd4cc8309595e5fabfb734810
  created2022-04-06 14:22:08
  updated2022-04-14 09:48:45
  modelContent
  foreign_key227
  base/3d-natour-nah-raum/
  aliasaugen-des-uhus
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id349
  lft151
  rght152
  route/3d-natour-nah-raum/augen-des-uhus
  2(array)
  id228
  hash15a2d803f89c0c511cd711abd6d600f0
  created2022-04-06 14:23:10
  updated2022-04-14 09:49:19
  menu_id110
  position3
  typearticle
  statusactive
  titleRiesenberghöhle
  layoutcol12
  language_id1
  article_content<h3>Film 2: 3D-Show „Die Riesenberghöhle“ </h3> <p>Eines der Top-Highlights jeder regulären Führung in der Schillat-Höhle, die 15-minütige 3D-Show „Die Riesenberghöhle“. Gewinnen Sie verborgene Einblicke in die größte Tropfsteinhöhle Niedersachsens, die Riesenberghöhle im Süntel. Sie zählt mit rund 800m Länge zu den großen Höhlen Deutschlands und Europas. Im Juli 1969 wurde die Höhle nach einer Sprengung im Steinbruch entdeckt. Dieses Meisterwerk der Natur steht unter Naturschutz. Die Riesenberghöhle ist reich an Tropfsteingebilden: Zahlreiche Stalaktiten und Makkaronis hängen von der Höhlenwand. Stalagmiten mit unterschiedlichen Höhen und Durchmessern säumen den Höhlenboden.</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)
  id351
  hash3fd4b3cc537b024bc0b39bf7ff7a20ae
  created2022-04-06 14:23:10
  updated2022-04-14 09:49:19
  modelContent
  foreign_key228
  base/3d-natour-nah-raum/
  aliasriesenberghoehle
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id349
  lft153
  rght154
  route/3d-natour-nah-raum/riesenberghoehle
  HeaderImagesMedia(array)
  0(array)
  id53
  hash99d7b27d8a3185a531c07f3069c20c6f
  created2022-04-06 16:10:21
  updated2022-04-06 16:10:21
  titleBiene Header
  cross_reference_count1
  MediaEntity(array)
  id497
  pos1
  media_id53
  modelMenu
  fieldheader_images
  foreign_key110
  FileUpload(array)
  0(array)
  id1106
  hashb1184c0165f5a24549ebb057a8f7cbbf
  created2022-04-06 16:10:18
  updated2022-04-06 16:10:21
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Media/File/624d9f4df162e.jpg
  size1030044
  ext.jpg
  mimeimage/jpeg
  width1920
  height558
  1(array)
  id1317
  hash68af4aafe5145bb836591d906de17b4d
  created2022-04-12 11:08:00
  updated2022-04-12 11:08:00
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-thmenuheaderimagessmooth.jpg
  thumbnailth-menu-header-images-smooth
  parent_id1106
  filewebroot/files/Media/File/ThMenuHeaderImagesSmooth/625541706734e.jpg
  size286442
  ext.jpg
  mimeimage/jpeg
  width1920
  height713
  2(array)
  id1318
  hash554066a63ea0da8f1ff2193d8ab81999
  created2022-04-12 11:08:00
  updated2022-04-12 11:08:00
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-thteaser.jpg
  thumbnailth-teaser
  parent_id1106
  filewebroot/files/Media/File/ThTeaser/625541709a939.jpg
  size43038
  ext.jpg
  mimeimage/jpeg
  width540
  height360
  3(array)
  id1319
  hash443b70ab5d88af1a12cfd9f7dee36be3
  created2022-04-12 11:08:00
  updated2022-04-12 11:08:00
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-thgallery.jpg
  thumbnailth-gallery
  parent_id1106
  filewebroot/files/Media/File/ThGallery/62554170b0007.jpg
  size72790
  ext.jpg
  mimeimage/jpeg
  width555
  height430
  4(array)
  id1107
  hash7c01d4a456205e4fcccb5912e489d0bd
  created2022-04-06 16:10:22
  updated2022-04-06 16:10:22
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-thmediafileindex.jpg
  thumbnailth-media-file-index
  parent_id1106
  filewebroot/files/Media/File/ThMediaFileIndex/624d9f4df286d.jpg
  size13031
  ext.jpg
  mimeimage/jpeg
  width150
  height43
  5(array)
  id1108
  hash5e31443c5ce312f1a435d9ae46b08421
  created2022-04-06 16:10:22
  updated2022-04-06 16:10:22
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-ckeditorxs.jpg
  thumbnailckeditor_xs
  parent_id1106
  filewebroot/files/Media/File/CkeditorXs/624d9f4e1aadf.jpg
  size4107
  ext.jpg
  mimeimage/jpeg
  width80
  height23
  6(array)
  id1109
  hash36f95cf6a739be114857683f5963b548
  created2022-04-06 16:10:22
  updated2022-04-06 16:10:22
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-ckeditorsm.jpg
  thumbnailckeditor_sm
  parent_id1106
  filewebroot/files/Media/File/CkeditorSm/624d9f4e3fce3.jpg
  size13031
  ext.jpg
  mimeimage/jpeg
  width150
  height43
  7(array)
  id1110
  hash76c2366d6036e40c0bc99bf89e410040
  created2022-04-06 16:10:22
  updated2022-04-06 16:10:22
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-ckeditormd.jpg
  thumbnailckeditor_md
  parent_id1106
  filewebroot/files/Media/File/CkeditorMd/624d9f4e579aa.jpg
  size21565
  ext.jpg
  mimeimage/jpeg
  width200
  height58
  8(array)
  id1111
  hash95abf85814aa3635e5cfe8e0cab9b558
  created2022-04-06 16:10:22
  updated2022-04-06 16:10:22
  modelMedia
  fieldfile
  foreign_key53
  aliasbiene-blume-ckeditorlg.jpg
  thumbnailckeditor_lg
  parent_id1106
  filewebroot/files/Media/File/CkeditorLg/624d9f4e6d3ad.jpg
  size43050
  ext.jpg
  mimeimage/jpeg
  width300
  height87
- $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	/3d-natour-nah-raum
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/3d-natour-nah-raum
Remote Port	57800
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	YoQRhUH1iBpqGMjfOq26UQAAAAQ
Redirect Status	200
Redirect Https	on
Redirect Unique Id	YoQRhUH1iBpqGMjfOq26UQAAAAQ
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Unique Id	YoQRhUH1iBpqGMjfOq26UQAAAAQ
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1652822405.205
Request Time	1652822405

====

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?

3D.natour.NAH.raum

Erleben Sie spannende 3D-Shows in unserem Kleinkino

Film 1: 3D-Show „Der Süntel mit den Augen des Uhus“

Film 2: 3D-Show „Die Riesenberghöhle“

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 4 ms Total Queries: 135 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: 135 queries