Wandertouren Bergsteigerdorf Ramsau

Ein Traumpanorama bietet sich an der Bergstation nach Fahrt mit Hirscheck Sesselbahn. An der Bergstation der Hochschwarzeck Bergbahn startet der Wanderweg zum Toten Mann. Weitere Touren von oder über das Familiengebiet Hochschwarzeck - vom gemütlichem Spaziergang bis zur sportlichen Bergtour für die ganze Familie - haben wir hier zusammengefasst.

Tour 1: Vom Hochschwarzeck über den Toten Mann zum Zipfhäusl

Die Tour beginnt an der Talstation der Hirscheck Sesselbahn am Hochschwarzeck. Hier fahren wir in knapp 15 Minuten mit der Hirschecksesselbahn zum Hirscheck. Von der Bergstation geht es links in rund 15 Minuten zum "Toten Mann" mit einem herrlichen Ausblick auf die umliegende Bergwelt und in den Berchtesgadener Talkessel. Der Abstieg zum Gasthof "Söldenköpfl" dauert rund 1 Std. und in weiteren 30 Minuten erreichen Sie über den Soleleitungsweg die Berggaststätte "Gerstreit". Weiter über die Soleleitung bis zum Gasthof "Zipfhäusl"

Dauer: (bis zur Haltestelle Zipfhäusl): Ca. 2 1/2 - 3 1/2 Stunden.
Einkehrmöglichkeiten: Berggaststätte Hirschkaser, Berggaststätte Söldenköpfl, Berggaststätte Gerstreit, Berggasthof Zipfhäusl
Sonstiges: Festes Schuhwerk wird empfohlen!

Tour 2: Vom Zipfhäusl über den Taubensee zum Hintersee

Vom Zipfhäusl am Hochschwarzeck wandern wir auf dem Soleleitungsweg Richtung Westen bis zum „Taubensee". Genussvoll ist die herrliche Aussicht auf der „Soleleitung", himmlisch die Ruhe um den "Taubensee". Mit Blick auf den „Hohen Göll und den „Watzmann" geht es in wenigen Minuten vom Taubensee Richtung Ramsau bis zum „König-Max-Weg", der rechts abbiegend den Weg zum Hintersee weist. Wer noch gut in Form ist, der nimmt kurz vor dem Hintersee zur Linken noch den „Wartstein" mit, was einen Aufstieg im ruhigen Wald von rund 30 Minuten bedeutet. Der Lohn dafür ist wieder ein herrlicher Panoramablick. Am Hintersee angekommen haben Sie wieder einen Busanschluss oder Sie gehen durch den geheimnisvollen „Zauberwald" Richtung Ramsau.

Dauer: Für die ganze Wanderung (bis Hintersee) sollten Sie rund 2 - 2 1/2 Stunden einplanen. Vom Hintersee bis nach Ramsau sind ca. weitere 60 Minuten anzusetzen.
Einkehrmöglichkeiten: Berggaststätte Zipflhäusl, Gasthof Alpenhof, Cafe Gelfahrt, Gasthaus Seeklause, Gasthof Wörndlhof, Gasthof Auzinger
Sonstiges: Die Wanderung weist so gut wie keine Steigungen auf

Tour 5: Schmuckenstein - Mordau - Taubensee

Wir beginnen unsere Tour an der Haltestelle „Hochschwarzeck". Vorbei am höchstgelegenen Bauernhof in Ramsau, dem „Schmuckenlehen", haben wir nun 2 Möglichkeiten, die Mordaualm zu erreichen: Entweder wir nehmen den Weg auf der Nordseite des Schmuckensteins, entgegen dem Uhrzeigersinn oder den Weg auf der Südseite im Uhrzeigersinn. Beide Wege sind lohnend mit schönen Ausblicken und bringen uns zur herrlich auf dem Sattel zwischen Lattenberg und Schmuckenstein gelegenen Mordaualm. Nach einer wohlverdienten Brotzeit nehmen wir den Abstieg zum Taubensee, Haltestelle Taubensee, Abzw. Mordaualm.

Dauer: ca. 2 1/2 - 3 Stunden.

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  016
- ids(array)
  Menu16
  Content(null)
  Language1
- route(array)
  id17
  hasheab37860fce2b88088cd6cc0473c349e
  created2017-08-16 17:24:45
  updated2018-04-24 14:47:27
  modelMenu
  foreign_key16
  base/de/sommererlebnis/
  aliaswandertouren-ramsau
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id12
  lft104
  rght117
  route/de/sommererlebnis/wandertouren-ramsau
- 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: 7 ms
Total Queries: 84 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/sommererlebnis/wandertouren-ramsau' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 104 AND `Route`.`rght` >= 117 ORDER BY `Route`.`lft` asc	4	4	0
SELECT `Menu`.`id`, `Language`.`id` FROM `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `hochschwarzeck`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 16 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `hochschwarzeck`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 16 AND `Route`.`model` = 'Menu'	1	1	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`seo` AS `Seo` WHERE `Seo`.`foreign_key` = 16 AND `Seo`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 16 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `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 `hochschwarzeck`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 16 AND `Teaser`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 16 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`subline`, `HeaderImage`.`hirscheckblitz_logo`, `HeaderImage`.`disable` FROM `hochschwarzeck`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (16)	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (379, 380, 381, 382, 383, 384, 523, 524, 525, 526) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `HeaderImagesMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 16 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LandingpageImageMedia`.`id`, `LandingpageImageMedia`.`hash`, `LandingpageImageMedia`.`created`, `LandingpageImageMedia`.`updated`, `LandingpageImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) AS `LandingpageImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `hochschwarzeck`.`media` AS `LandingpageImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 16 AND `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'landingpage_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Language`.`langid` FROM `hochschwarzeck`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 16 LIMIT 1	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`.`content_teaser_image_right`, `Content`.`teaser_type`, `Content`.`member_group_id`, `Content`.`lift_status`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`360_panorama_url`, `Content`.`disable_winter_information`, `Content`.`placeholder_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published` FROM `hochschwarzeck`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (16) ORDER BY `Content`.`position` asc	4	4	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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 38 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 39 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 40 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 43 AND `Route`.`model` = 'Content'	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `hochschwarzeck`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'infobar' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `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 `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 65 AND `Menu`.`rght` < 70 ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (3, 4) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `hochschwarzeck`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'socialmedia' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `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 `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 71 AND `Menu`.`rght` < 76 ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (6, 7) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	2	2	1	maybe slow
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `hochschwarzeck`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'meta-a' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `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 `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 64 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `hochschwarzeck`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	30	30	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (10, 11, 15, 61, 17, 18, 60, 71, 77, 16, 12, 22, 24, 44, 47, 80, 59, 70, 74, 13, 48, 50, 51, 57, 58, 14, 20, 21, 53, 56) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `LandingpageImageMedia`.`id`, `LandingpageImageMedia`.`hash`, `LandingpageImageMedia`.`created`, `LandingpageImageMedia`.`updated`, `LandingpageImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) AS `LandingpageImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `hochschwarzeck`.`media` AS `LandingpageImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (10, 11, 15, 61, 17, 18, 60, 71, 77, 16, 12, 22, 24, 44, 47, 80, 59, 70, 74, 13, 48, 50, 51, 57, 58, 14, 20, 21, 53, 56) AND `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'landingpage_image' ORDER BY `MediaEntity`.`pos` ASC	4	4	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (29, 2, 12, 16) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	43	43	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `hochschwarzeck`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `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 `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 77 AND `Menu`.`rght` < 114 ORDER BY `Menu`.`lft` asc	18	18	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (26, 30, 31, 27, 64, 65, 66, 78, 28, 67, 68, 69, 29, 41, 42, 62, 63, 73) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `hochschwarzeck`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_partner' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `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 `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 117 AND `Menu`.`rght` < 128 ORDER BY `Menu`.`lft` asc	5	5	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (35, 36, 37, 39, 76) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	5	5	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`subline`, `HeaderImage`.`hirscheckblitz_logo`, `HeaderImage`.`disable` FROM `hochschwarzeck`.`header_images` AS `HeaderImage` WHERE `model` = 'Menu' AND `foreign_key` = 16	10	10	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 `hochschwarzeck`.`languages` AS `Language` LEFT JOIN `hochschwarzeck`.`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 `hochschwarzeck`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 16 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text` FROM `hochschwarzeck`.`menus` AS `Menu` WHERE `Menu`.`id` = 16 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `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 `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 21 AND `Menu`.`rght` >= 22 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT `WeatherReport`.`hirscheckbahn_status`, `WeatherReport`.`schmuckenlift_status`, `WeatherReport`.`fronwieslift_status`, `WeatherReport`.`kinderlift_status`, `WeatherReport`.`hirscheckblitz_piste_condition`, `WeatherReport`.`hirscheckblitz_status`, `WeatherReport`.`announcement` FROM `hochschwarzeck`.`weather_reports` AS `WeatherReport` WHERE `WeatherReport`.`status` = 'active' ORDER BY `date` DESC LIMIT 1	1	1	0
SELECT `Notification`.`id`, `Notification`.`hash`, `Notification`.`created`, `Notification`.`updated`, `Notification`.`status`, `Notification`.`title`, `Notification`.`notification_content`, `Notification`.`url`, `Notification`.`target` FROM `hochschwarzeck`.`notifications` AS `Notification` WHERE `Notification`.`status` = 'active' ORDER BY `created` DESC	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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/sommererlebnis/wandertouren-ramsau/ues-wandertouren' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 105 AND `Route`.`rght` >= 106 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`.`content_teaser_image_right`, `Content`.`teaser_type`, `Content`.`member_group_id`, `Content`.`lift_status`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`360_panorama_url`, `Content`.`disable_winter_information`, `Content`.`placeholder_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 38 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 98 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/sommererlebnis/wandertouren-ramsau/tour-1-hochschwarzeck-ueber-den-toten-mann-zum-zipfhaeusl' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 107 AND `Route`.`rght` >= 108 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`.`content_teaser_image_right`, `Content`.`teaser_type`, `Content`.`member_group_id`, `Content`.`lift_status`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`360_panorama_url`, `Content`.`disable_winter_information`, `Content`.`placeholder_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 39 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 99 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/sommererlebnis/wandertouren-ramsau/tour-2-zipfhaeusl-zum-hintersee' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 109 AND `Route`.`rght` >= 110 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`.`content_teaser_image_right`, `Content`.`teaser_type`, `Content`.`member_group_id`, `Content`.`lift_status`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`360_panorama_url`, `Content`.`disable_winter_information`, `Content`.`placeholder_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 40 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 100 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/sommererlebnis/wandertouren-ramsau/tour-5-schmuckenstein-mordau-taubensee' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 115 AND `Route`.`rght` >= 116 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`.`content_teaser_image_right`, `Content`.`teaser_type`, `Content`.`member_group_id`, `Content`.`lift_status`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`360_panorama_url`, `Content`.`disable_winter_information`, `Content`.`placeholder_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 43 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 103 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `hochschwarzeck`.`settings` AS `Setting` LEFT JOIN `hochschwarzeck`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	29	29	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 `hochschwarzeck`.`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, 16, 17, 18, 20, 21, 22, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	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 `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `hochschwarzeck`.`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` = 'weather_report' 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 `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `hochschwarzeck`.`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`, `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 `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `hochschwarzeck`.`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` = 'emblem' 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 `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `hochschwarzeck`.`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` = 'footer_contact' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/footeranschrift/anschrift' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 437 AND `Route`.`rght` >= 438 ORDER BY `Route`.`lft` asc	3	3	0
SELECT `Menu`.`id`, `Language`.`id` FROM `hochschwarzeck`.`menus` AS `Menu` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `hochschwarzeck`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 33 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `hochschwarzeck`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 33 AND `Route`.`model` = 'Menu'	1	1	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`seo` AS `Seo` WHERE `Seo`.`foreign_key` = 33 AND `Seo`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 40 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `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 `hochschwarzeck`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 33 AND `Teaser`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 40 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`subline`, `HeaderImage`.`hirscheckblitz_logo`, `HeaderImage`.`disable` FROM `hochschwarzeck`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (33)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 182, 183, 184, 185, 186) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (33) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `HeaderImagesMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 33 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LandingpageImageMedia`.`id`, `LandingpageImageMedia`.`hash`, `LandingpageImageMedia`.`created`, `LandingpageImageMedia`.`updated`, `LandingpageImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) AS `LandingpageImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `hochschwarzeck`.`media` AS `LandingpageImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 33 AND `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'landingpage_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`.`content_teaser_image_right`, `Content`.`teaser_type`, `Content`.`member_group_id`, `Content`.`lift_status`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`360_panorama_url`, `Content`.`disable_winter_information`, `Content`.`placeholder_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 8 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `hochschwarzeck`.`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 `hochschwarzeck`.`media` AS `ImageMedia` JOIN `hochschwarzeck`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 41 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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `hochschwarzeck`.`mount_points` AS `MountPoint` LEFT JOIN `hochschwarzeck`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 22.09 MB

Message	Memory use
Component initialization	6.79 MB
Controller action start	9.67 MB
Controller render start	10.51 MB
Component initialization #2	14.80 MB
Controller action start #2	14.97 MB
Controller render start #2	15.13 MB
Component initialization #3	15.39 MB
Controller action start #3	15.42 MB
Controller render start #3	15.54 MB
Component initialization #4	15.73 MB
Controller action start #4	15.76 MB
Controller render start #4	15.89 MB
Component initialization #5	16.08 MB
Controller action start #5	16.10 MB
Controller render start #5	16.23 MB
Component initialization #6	17.08 MB
Controller action start #6	17.17 MB
Controller render start #6	17.29 MB
View render complete	17.41 MB

Timers

Total Request Time: 686 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	126.50
Event: Controller.initialize	73.85
Event: Controller.startup	6.37
Controller action	20.41
Event: Controller.beforeRender	107.34
» Processing toolbar data	30.48
Rendering View	231.61
» Event: View.beforeRender	0.06
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	140.24
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	139.37
» » » Event: Controller.initialize #2	9.83
» » » Event: Controller.startup #2	0.53
» » » Controller action #2	4.03
» » » Event: Controller.beforeRender #2	11.27
» » » » Processing toolbar data #2	11.04
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.07
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	2.22
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.58
» » » » Event: View.afterRender	0.06
» » » » Event: Controller.shutdown	0.04
» » » » Event: Controller.initialize #3	9.65
» » » » Event: Controller.startup #3	0.50
» » » » Controller action #3	3.53
» » » » Event: Controller.beforeRender #3	10.50
» » » » » Processing toolbar data #3	10.30
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.07
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.16
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.51
» » » » » Event: View.afterRender #2	0.09
» » » » » Event: Controller.shutdown #2	0.04
» » » » » Event: Controller.initialize #4	11.76
» » » » » Event: Controller.startup #4	0.50
» » » » » Controller action #4	3.89
» » » » » Event: Controller.beforeRender #4	11.28
» » » » » » Processing toolbar data #4	10.86
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.07
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	1.36
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.50
» » » » » » Event: View.afterRender #3	0.18
» » » » » » Event: Controller.shutdown #3	0.04
» » » » » » Event: Controller.initialize #5	9.09
» » » » » » Event: Controller.startup #5	0.51
» » » » » » Controller action #5	4.67
» » » » » » Event: Controller.beforeRender #5	10.17
» » » » » » » Processing toolbar data #5	9.98
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.07
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #4	1.16
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.51
» » » » » » » Event: View.afterRender #4	0.05
» » » » » » » Event: Controller.shutdown #4	0.05
» » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #5	0.36
» » » » » Event: View.afterRender #5	0.59
» » » » » Event: View.beforeLayout	0.05
» » » » » Rendering APP/View/Layouts/index.php	87.15
» » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	12.62
» » » » » » Rendering APP/View/Elements/notifications.php	1.01
» » » » » » Rendering APP/View/Elements/infobar_info.php	6.16
» » » » » » Rendering APP/View/Elements/infobar_socialmedia.php	2.23
» » » » » » Rendering APP/View/Elements/navigation.php	10.14
» » » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/header-slider.php	2.98
» » » » » » Rendering APP/View/Elements/footer.php	41.13
» » » » » » » Event: Controller.initialize #6	8.94
» » » » » » » Event: Controller.startup #6	0.68
» » » » » » » Controller action #6	3.98
» » » » » » » Event: Controller.beforeRender #6	11.95
» » » » » » » » Processing toolbar data #6	11.65
Rendering View #6	0.00
» » » » » » » » Event: View.beforeRender #6	0.08
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #5	1.15
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #6	0.53
» » » » » » » » Event: View.afterRender #6	0.06
» » » » » » » » Event: Controller.shutdown #5	0.05
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
 Menu(array)
 id16
 hashdeb405626e5e7f39c22b7a659d9c166c
 created2017-08-16 17:24:45
 updated2018-04-24 14:47:27
 parent_id11
 lft21
 rght22
 language_id1
 typecontent
 titleWandertouren Ramsau
 previous_url(null)
 url(null)
 target_blank(false)
 icon_image(false)
 landingpage_img(false)
 fullscreen(false)
 icon_textWander- touren
 landingpage_text
 Seo(array)
 id16
 hash28ce80cbc3c6b568d80e9f2d279ef5dc
 created2017-08-16 17:24:45
 updated2018-04-24 14:47:28
 modelMenu
 foreign_key16
 titleWandertouren im Traumpanorama
 descriptionDas Familiengebiet Hochschwarzeck liegt im Herzen der Berchtesgadener Alpen im Bergsteigerdorf Ramsau. Nach der Fahrt mit der Hirscheck Sesselbahn bieten sich Wandertouren in traumhafter Berkulisse.
 author
 tw_creator
 fb_author
 robots3
 ImageMedia(empty)
 Content(array)
 0(array)
 id38
 hash516a0432469385547b1795ecc0287be7
 created2017-12-12 22:31:46
 updated2018-04-24 14:48:28
 menu_id16
 position1
 typearticle
 statusactive
 titleÜS Wandertouren
 layoutcol12
 language_id1
 article_content<h2>Wandertouren Bergsteigerdorf Ramsau</h2> Ein Traumpanorama bietet sich an der Bergstation nach Fahrt mit Hirscheck Sesselbahn. An der Bergstation der Hochschwarzeck Bergbahn startet der Wanderweg zum Toten Mann. Weitere Touren von oder über das Familiengebiet Hochschwarzeck - vom gemütlichem Spaziergang bis zur sportlichen Bergtour für die ganze Familie - haben wir hier zusammengefasst.
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 content_teaser_image_right(null)
 teaser_type(null)
 member_group_id(null)
 lift_status(null)
 webcam_img(null)
 webcam_url(null)
 webcam_type(null)
 webcam_height(null)
 360_panorama_url(null)
 disable_winter_information(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id105
 hash7ff97be80c784307ab7af9258159a86d
 created2017-12-12 22:31:46
 updated2018-04-24 14:48:28
 modelContent
 foreign_key38
 base/de/sommererlebnis/wandertouren-ramsau/
 aliasues-wandertouren
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id17
 lft105
 rght106
 route/de/sommererlebnis/wandertouren-ramsau/ues-wandertouren
 1(array)
 id39
 hash47d35eb89fd6b31a2c4df3000b30ff19
 created2017-12-12 22:37:04
 updated2017-12-12 22:37:04
 menu_id16
 position2
 typearticle
 statusactive
 titleTour 1: HOCHSCHWARZECK ÜBER DEN TOTEN MANN ZUM ZIPFHÄUSL
 layoutcol6
 language_id1
 article_content<h3>Tour 1: Vom Hochschwarzeck über den Toten Mann zum Zipfhäusl</h3> Die Tour beginnt an der Talstation der Hirscheck Sesselbahn am Hochschwarzeck. Hier fahren wir in knapp 15 Minuten mit der Hirschecksesselbahn zum Hirscheck. Von der Bergstation geht es links in rund 15 Minuten zum "Toten Mann" mit einem herrlichen Ausblick auf die umliegende Bergwelt und in den Berchtesgadener Talkessel. Der Abstieg zum Gasthof "Söldenköpfl" dauert rund 1 Std. und in weiteren 30 Minuten erreichen Sie über den Soleleitungsweg die Berggaststätte "Gerstreit". Weiter über die Soleleitung bis zum Gasthof "Zipfhäusl" Dauer: (bis zur Haltestelle Zipfhäusl): Ca. 2 1/2 - 3 1/2 Stunden. Einkehrmöglichkeiten: Berggaststätte Hirschkaser, Berggaststätte Söldenköpfl, Berggaststätte Gerstreit, Berggasthof Zipfhäusl Sonstiges: Festes Schuhwerk wird empfohlen!
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 content_teaser_image_right(null)
 teaser_type(null)
 member_group_id(null)
 lift_status(null)
 webcam_img(null)
 webcam_url(null)
 webcam_type(null)
 webcam_height(null)
 360_panorama_url(null)
 disable_winter_information(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id106
 hash8ddc238fc551093b6e6fbcd025d107e2
 created2017-12-12 22:37:04
 updated2017-12-12 22:37:04
 modelContent
 foreign_key39
 base/de/sommererlebnis/wandertouren-ramsau/
 aliastour-1-hochschwarzeck-ueber-den-toten-mann-zum-zipfhaeusl
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id17
 lft107
 rght108
 route/de/sommererlebnis/wandertouren-ramsau/tour-1-hochschwarzeck-ueber-den-toten-mann-zum-zipfhaeusl
 2(array)
 id40
 hash1051b20959fad079bde25832011682e5
 created2017-12-12 22:41:38
 updated2017-12-12 22:41:42
 menu_id16
 position3
 typearticle
 statusactive
 titleTour 2: Zipfhäusl zum Hintersee
 layoutcol6
 language_id1
 article_content<h3>Tour 2: Vom Zipfhäusl über den Taubensee zum Hintersee</h3> Vom Zipfhäusl am Hochschwarzeck wandern wir auf dem Soleleitungsweg Richtung Westen bis zum „Taubensee". Genussvoll ist die herrliche Aussicht auf der „Soleleitung", himmlisch die Ruhe um den "Taubensee". Mit Blick auf den „Hohen Göll und den „Watzmann" geht es in wenigen Minuten vom Taubensee Richtung Ramsau bis zum „König-Max-Weg", der rechts abbiegend den Weg zum Hintersee weist. Wer noch gut in Form ist, der nimmt kurz vor dem Hintersee zur Linken noch den „Wartstein" mit, was einen Aufstieg im ruhigen Wald von rund 30 Minuten bedeutet. Der Lohn dafür ist wieder ein herrlicher Panoramablick. Am Hintersee angekommen haben Sie wieder einen Busanschluss oder Sie gehen durch den geheimnisvollen „Zauberwald" Richtung Ramsau. Dauer: Für die ganze Wanderung (bis Hintersee) sollten Sie rund 2 - 2 1/2 Stunden einplanen. Vom Hintersee bis nach Ramsau sind ca. weitere 60 Minuten anzusetzen. Einkehrmöglichkeiten: Berggaststätte Zipflhäusl, Gasthof Alpenhof, Cafe Gelfahrt, Gasthaus Seeklause, Gasthof Wörndlhof, <a href="http://www.auzinger.de/" target="_blank" title="Gasthof Auzinger">Gasthof Auzinger</a> Sonstiges: Die Wanderung weist so gut wie keine Steigungen auf
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 content_teaser_image_right(null)
 teaser_type(null)
 member_group_id(null)
 lift_status(null)
 webcam_img(null)
 webcam_url(null)
 webcam_type(null)
 webcam_height(null)
 360_panorama_url(null)
 disable_winter_information(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id107
 hash92e9477c53b29ba89927498a8aebf12d
 created2017-12-12 22:41:38
 updated2017-12-12 22:41:42
 modelContent
 foreign_key40
 base/de/sommererlebnis/wandertouren-ramsau/
 aliastour-2-zipfhaeusl-zum-hintersee
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id17
 lft109
 rght110
 route/de/sommererlebnis/wandertouren-ramsau/tour-2-zipfhaeusl-zum-hintersee
 3(array)
 id43
 hasheac6a0e9325d26affdf8da73549fb06c
 created2017-12-12 22:57:49
 updated2017-12-12 22:57:49
 menu_id16
 position6
 typearticle
 statusactive
 titleTour 5: Schmuckenstein - Mordau - Taubensee
 layoutcol12
 language_id1
 article_content<h3>Tour 5: Schmuckenstein - Mordau - Taubensee</h3> Wir beginnen unsere Tour an der Haltestelle „Hochschwarzeck". Vorbei am höchstgelegenen Bauernhof in Ramsau, dem „Schmuckenlehen", haben wir nun 2 Möglichkeiten, die Mordaualm zu erreichen: Entweder wir nehmen den Weg auf der Nordseite des Schmuckensteins, entgegen dem Uhrzeigersinn oder den Weg auf der Südseite im Uhrzeigersinn. Beide Wege sind lohnend mit schönen Ausblicken und bringen uns zur herrlich auf dem Sattel zwischen Lattenberg und Schmuckenstein gelegenen Mordaualm. Nach einer wohlverdienten Brotzeit nehmen wir den Abstieg zum Taubensee, Haltestelle Taubensee, Abzw. Mordaualm. Dauer: ca. 2 1/2 - 3 Stunden.
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 content_teaser_image_right(null)
 teaser_type(null)
 member_group_id(null)
 lift_status(null)
 webcam_img(null)
 webcam_url(null)
 webcam_type(null)
 webcam_height(null)
 360_panorama_url(null)
 disable_winter_information(null)
 placeholder_text(null)
 gmap
 published1
 Route(array)
 id110
 hash058d1b3b70ecb9540ad3ce693f1243b3
 created2017-12-12 22:57:49
 updated2017-12-12 22:57:49
 modelContent
 foreign_key43
 base/de/sommererlebnis/wandertouren-ramsau/
 aliastour-5-schmuckenstein-mordau-taubensee
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id17
 lft115
 rght116
 route/de/sommererlebnis/wandertouren-ramsau/tour-5-schmuckenstein-mordau-taubensee
- $request->data(empty)
- $this->validationErrors(array)
 Route(empty)
 MountPoint(empty)
 Redirect(empty)
 Menu(empty)
 MemberGroup(empty)
 Member(empty)
 Parent(empty)
 Language(empty)
 HeaderImagesMedia(empty)
 MediaEntity(empty)
 LandingpageImageMedia(empty)
 Seo(empty)
 ImageMedia(empty)
 Teaser(empty)
 HeaderImage(empty)
 FileUpload(empty)
 IconUpload(empty)
 Content(empty)
 ArticleContentMedia(empty)
 GalleryMedia(empty)
 WeatherReport(empty)
 Notification(empty)
 FlagUpload(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8GMap
 9Embed
 10Layout
 11Enum
 12ThirdPartyCookies
 13Number
 14SimpleGraph
 15DebugTimer
 16Toolbar
 17Js
 18HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.5.38
User	u399438598394
Home	/var/www/vhosts/hochschwarzeck.info
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	ZB1Ov8fFgzU-gpVwz5HfiwAAAAQ
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	ZB1Ov8fFgzU-gpVwz5HfiwAAAAQ
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	ZB1Ov8fFgzU-gpVwz5HfiwAAAAQ
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Https	on
Proxy-nokeepalive	1
Http Host	www.hochschwarzeck.info
Http X Real Ip	3.239.6.58
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http If Modified Since	Sat, 26 Nov 2022 10:10:28 GMT
Http Accept Encoding	br,gzip
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.hochschwarzeck.info
Server Addr	85.236.63.140
Server Port	443
Remote Addr	3.239.6.58
Document Root	/var/www/vhosts/hochschwarzeck.info/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/hochschwarzeck.info/httpdocs
Server Admin	root@localhost
Script Filename	/var/www/vhosts/hochschwarzeck.info/httpdocs/webroot/index.php
Remote Port	40782
Redirect Url	/webroot/de/sommererlebnis/wandertouren-ramsau
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/de/sommererlebnis/wandertouren-ramsau
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1679642303.1244
Request Time	1679642303

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.5/share/pear
- 2-> /var/www/vhosts/hochschwarzeck.info/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
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/AuthComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  FrontendMembers(array)
  Config(array)
  0FrontendMembers/Config/routes.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
  HeaderImages(array)
  Behavior(array)
  0HeaderImages/Model/Behavior/HeaderImageBehavior.php
  Model(array)
  0HeaderImages/Model/HeaderImage.php
  1HeaderImages/Model/HeaderImagesAppModel.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
  Members(array)
  Model(array)
  0Members/Model/MemberGroup.php
  1Members/Model/MembersAppModel.php
  2Members/Model/Member.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
  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
====

Wandertouren Bergsteigerdorf Ramsau

Tour 1: Vom Hochschwarzeck über den Toten Mann zum Zipfhäusl

Tour 2: Vom Zipfhäusl über den Taubensee zum Hintersee

Tour 5: Schmuckenstein - Mordau - Taubensee

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 7 ms Total Queries: 84 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 7 ms
Total Queries: 84 queries