Preise für Wintersportkarten (ab Nov 2022)

Tageskarten

Erwachsene 29,00 EUR
Jugendliche (7 - 17 Jahre) 17,00 EUR
Kinder (unter 7 Jahre) frei
Sondertarife¹ 22,00 EUR

4-Stunden Karte

Erwachsene 21,50 EUR
Jugendliche (7 - 17 Jahre) 14,50 EUR
Kinder (unter 7 Jahre) frei
Sondertarife¹ 18,50 EUR

3-Stunden Karte

Erwachsene 19,00 EUR
Jugendliche (7 - 17 Jahre) 12,50 EUR
Kinder (unter 7 Jahre) frei
Sondertarife¹ 17,50 EUR

2-Stunden Karte

Erwachsene 17,00 EUR
Jugendliche (7 - 17 Jahre) 10,00 EUR
Kinder (unter 7 Jahre) frei
Sondertarife¹ 13,50 EUR

1-Stunden Karte

Erwachsene 12,00 EUR
Jugendliche (7 - 17 Jahre) 07,50 EUR
Kinder (unter 7 Jahre) frei
Sondertarife¹ 09,00 EUR

21-Punkte Karte²

Erwachsene 30,00 EUR
Jugendliche (7 - 17 Jahre) 19,50 EUR
Kinder (unter 7 Jahre) frei

42-Punkte Karte²

Erwachsene 55,00 EUR
Jugendliche (7 - 17 Jahre) 32,50 EUR
Kinder (unter 7 Jahre) frei

Tageskarte Familien (Kinder / Jugendl. 7-17 J.)

1 Erwachsener + 1 Kind 38,00 EUR
1 Erwachsener + 2 Kinder 50,50 EUR
2 Erwachsener + 1 Kind 60,50 EUR
2 Erwachsene + 2 Kinder 68,50 EUR
Kinder (unter 7 Jahre) frei
Alle weiteren leiblichen Kinder frei

3-Stunden Familien (Kinder / Jugendl. 7-17 J.)

1 Erwachsener + 1 Kind 28,50 EUR
1 Erwachsener + 2 Kinder 37,00 EUR
2 Erwachsener + 1 Kind 43,50 EUR
2 Erwachsene + 2 Kinder 52,50 EUR
Kinder (unter 7 Jahre) frei
Alle weiteren leiblichen Kinder frei

Rodelverleih

Rodelverleih pro Tag 09,00 EUR
Rodelverleih ab 14:00 Uhr 05,00 EUR
Rodel-Verleih nur mit gültigem Personalausweis als Pfand

Kombiticket WatzmannTherme (KINDER / JUGENDL. 7-17 J.)

2 Erwachsene + 2 Kinder 75,00 EUR
Familienkombikarte beinhaltet 4 Stunden Ski und Rodel sowie 4 Stunden Wasser und Solelandschaft ohne Sauna.

Tarifinformationen:
1) Sondertarife: Diese Preise gelten für Studenten, Behinderte sowie Senioren ab 60 Jahren und Angehörige der Bundeswehr mit Dienstausweis.
2) Punkte Karten: 3 Punkte an der Sesselbahn - 1 Punkt an den Schleppliften. Die Punkte-Karte ist übertragbar und an 2 aufeinanderfolgenden Wintern gültig

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  022
- ids(array)
  Menu22
  Content(null)
  Language1
- route(array)
  id23
  hash1a4ebc62661725df9aad709ddb65f9f2
  created2017-08-17 16:01:05
  updated2017-12-20 09:59:36
  modelMenu
  foreign_key22
  base/de/skigebiet/
  aliaspreise
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id13
  lft186
  rght195
  route/de/skigebiet/preise
- 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: 78 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/skigebiet/preise' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 186 AND `Route`.`rght` >= 195 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` = 22 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` = 22 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` = 22 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` = 22 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` = 22 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` = 22 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` = (22)	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 (427, 428, 429, 430, 431, 432) 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` = (22) 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` = 22 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` = 22 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` = 22 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` = (22) 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 `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 26 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` = 23 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` = 24 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	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` = '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` = 22	6	6	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` = 22 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` = 22 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` <= 25 AND `Menu`.`rght` >= 26 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/skigebiet/preise/ues-wintersportkarten' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 191 AND `Route`.`rght` >= 192 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` = 26 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` = 82 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/skigebiet/preise/zeitkarten' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 187 AND `Route`.`rght` >= 188 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` = 23 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` = 79 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/skigebiet/preise/familienkarten-und-sondertarife' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 189 AND `Route`.`rght` >= 190 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` = 24 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` = 80 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	2	maybe slow
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 20.32 MB

Message	Memory use
Component initialization	6.79 MB
Controller action start	9.60 MB
Controller render start	10.43 MB
Component initialization #2	14.71 MB
Controller action start #2	14.88 MB
Controller render start #2	15.04 MB
Component initialization #3	15.30 MB
Controller action start #3	15.33 MB
Controller render start #3	15.46 MB
Component initialization #4	15.65 MB
Controller action start #4	15.68 MB
Controller render start #4	15.80 MB
Component initialization #5	16.66 MB
Controller action start #5	16.75 MB
Controller render start #5	16.88 MB
View render complete	16.99 MB

Timers

Total Request Time: 564 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	123.48
Event: Controller.initialize	66.29
Event: Controller.startup	3.55
Controller action	18.18
Event: Controller.beforeRender	83.24
» Processing toolbar data	18.06
Rendering View	168.57
» Event: View.beforeRender	0.06
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	88.47
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	87.64
» » » Event: Controller.initialize #2	5.09
» » » Event: Controller.startup #2	0.40
» » » Controller action #2	3.51
» » » Event: Controller.beforeRender #2	11.43
» » » » Processing toolbar data #2	11.25
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.06
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	2.12
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.51
» » » » Event: View.afterRender	0.04
» » » » Event: Controller.shutdown	0.03
» » » » Event: Controller.initialize #3	5.57
» » » » Event: Controller.startup #3	0.45
» » » » Controller action #3	3.49
» » » » Event: Controller.beforeRender #3	9.87
» » » » » Processing toolbar data #3	9.69
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.06
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.51
» » » » » 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	5.38
» » » » » Event: Controller.startup #4	0.52
» » » » » Controller action #4	3.81
» » » » » Event: Controller.beforeRender #4	10.67
» » » » » » Processing toolbar data #4	10.40
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.07
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	1.34
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.54
» » » » » » Event: View.afterRender #3	0.05
» » » » » » Event: Controller.shutdown #3	0.04
» » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #4	0.41
» » » » Event: View.afterRender #4	0.56
» » » » Event: View.beforeLayout	0.05
» » » » Rendering APP/View/Layouts/index.php	76.17
» » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	11.87
» » » » » Rendering APP/View/Elements/notifications.php	0.66
» » » » » Rendering APP/View/Elements/infobar_info.php	4.28
» » » » » Rendering APP/View/Elements/infobar_socialmedia.php	1.60
» » » » » Rendering APP/View/Elements/navigation.php	8.22
» » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/header-slider.php	1.80
» » » » » Rendering APP/View/Elements/footer.php	38.77
» » » » » » Event: Controller.initialize #5	10.63
» » » » » » Event: Controller.startup #5	0.60
» » » » » » Controller action #5	3.61
» » » » » » Event: Controller.beforeRender #5	10.44
» » » » » » » Processing toolbar data #5	10.23
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.08
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #4	1.10
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.58
» » » » » » » Event: View.afterRender #5	0.05
» » » » » » » Event: Controller.shutdown #4	0.04
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id22
  hash4cae4864e4d9ade81bd3effb6cbc4c5d
  created2017-08-17 16:01:05
  updated2017-12-20 09:59:36
  parent_id12
  lft25
  rght26
  language_id1
  typecontent
  titlePreise
  previous_url(null)
  url(null)
  target_blank(false)
  icon_image(true)
  landingpage_img(false)
  fullscreen(false)
  icon_text
  landingpage_text
  Seo(array)
  id22
  hash490b8bd0c9f30d1241bd91d0daa0c2a7
  created2017-08-17 16:01:05
  updated2017-12-20 09:59:36
  modelMenu
  foreign_key22
  titlePreise Winter
  descriptionPreise Winter & Öffnungszeiten Familienskigebiet Hochschwarzeck im Bergsteigerdorf Ramsau Berchtesgadener Land
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id26
  hash80c547d40eb50dc1cb9ef8561550ddca
  created2017-12-08 11:48:51
  updated2022-10-17 09:18:40
  menu_id22
  position1
  typearticle
  statusactive
  titleÜS Wintersportkarten
  layoutcol12
  language_id1
  article_content<h2>Preise für Wintersportkarten (ab Nov 2022)</h2>
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  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)
  id89
  hashbab28e564109385440992a8ecd3a0747
  created2017-12-08 11:48:51
  updated2022-10-17 09:18:40
  modelContent
  foreign_key26
  base/de/skigebiet/preise/
  aliasues-wintersportkarten
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id23
  lft191
  rght192
  route/de/skigebiet/preise/ues-wintersportkarten
  1(array)
  id23
  hashb5183089a7c8edc52727e71e19315cad
  created2017-12-08 11:07:25
  updated2022-10-17 09:16:12
  menu_id22
  position2
  typearticle
  statusactive
  titleZeitkarten
  layoutcol6
  language_id1
  article_content<h3>Tageskarten</h3> <p>Erwachsene 29,00 EUR<br /> Jugendliche (7 - 17 Jahre) 17,00 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Sondertarife¹ 22,00 EUR</p> <h3>4-Stunden Karte</h3> <p>Erwachsene 21,50 EUR<br /> Jugendliche (7 - 17 Jahre) 14,50 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Sondertarife¹ 18,50 EUR</p> <h3>3-Stunden Karte</h3> <p>Erwachsene 19,00 EUR<br /> Jugendliche (7 - 17 Jahre) 12,50 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Sondertarife¹ 17,50 EUR</p> <h3>2-Stunden Karte</h3> <p>Erwachsene 17,00 EUR<br /> Jugendliche (7 - 17 Jahre) 10,00 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Sondertarife¹ 13,50 EUR</p> <h3>1-Stunden Karte</h3> <p>Erwachsene 12,00 EUR<br /> Jugendliche (7 - 17 Jahre) 07,50 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Sondertarife¹ 09,00 EUR</p> <h3>21-Punkte Karte²</h3> <p>Erwachsene 30,00 EUR<br /> Jugendliche (7 - 17 Jahre) 19,50 EUR<br /> Kinder (unter 7 Jahre) frei</p> <h3>42-Punkte Karte²</h3> <p>Erwachsene 55,00 EUR<br /> Jugendliche (7 - 17 Jahre) 32,50 EUR<br /> Kinder (unter 7 Jahre) frei</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_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)
  id86
  hash609fee80d7338a7bed14c6a784c26efa
  created2017-12-08 11:07:25
  updated2022-10-17 09:16:12
  modelContent
  foreign_key23
  base/de/skigebiet/preise/
  aliaszeitkarten
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id23
  lft187
  rght188
  route/de/skigebiet/preise/zeitkarten
  2(array)
  id24
  hash0bb32502be5f08e3e64d5801e4d82ff5
  created2017-12-08 11:29:10
  updated2022-10-17 09:18:02
  menu_id22
  position3
  typearticle
  statusactive
  titleFamilienkarten und Sondertarife
  layoutcol6
  language_id1
  article_content<h3>Tageskarte Familien (Kinder / Jugendl. 7-17 J.)</h3> <p>1 Erwachsener + 1 Kind 38,00 EUR<br /> 1 Erwachsener + 2 Kinder 50,50 EUR<br /> 2 Erwachsener + 1 Kind 60,50 EUR<br /> 2 Erwachsene + 2 Kinder 68,50 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Alle weiteren leiblichen Kinder frei</p> <h3>3-Stunden Familien (Kinder / Jugendl. 7-17 J.)</h3> <p>1 Erwachsener + 1 Kind 28,50 EUR<br /> 1 Erwachsener + 2 Kinder 37,00 EUR<br /> 2 Erwachsener + 1 Kind 43,50 EUR<br /> 2 Erwachsene + 2 Kinder 52,50 EUR<br /> Kinder (unter 7 Jahre) frei<br /> Alle weiteren leiblichen Kinder frei</p> <h3>Rodelverleih</h3> <p>Rodelverleih pro Tag 09,00 EUR<br /> Rodelverleih ab 14:00 Uhr 05,00 EUR<br /> Rodel-Verleih nur mit gültigem Personalausweis als Pfand</p> <h3>Kombiticket WatzmannTherme (KINDER / JUGENDL. 7-17 J.)</h3> <p>2 Erwachsene + 2 Kinder 75,00 EUR<br /> Familienkombikarte beinhaltet 4 Stunden Ski und Rodel sowie 4 Stunden Wasser und Solelandschaft ohne Sauna.</p> <p> </p> <p><strong>Tarifinformationen:</strong><br /> 1) Sondertarife: Diese Preise gelten für Studenten, Behinderte sowie Senioren ab 60 Jahren und Angehörige der Bundeswehr mit Dienstausweis.<br /> 2) Punkte Karten: 3 Punkte an der Sesselbahn - 1 Punkt an den Schleppliften. Die Punkte-Karte ist übertragbar und an 2 aufeinanderfolgenden Wintern gültig</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_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)
  id87
  hashd2503cfa4da1cd2867d36499e86a9ca2
  created2017-12-08 11:29:10
  updated2022-10-17 09:18:02
  modelContent
  foreign_key24
  base/de/skigebiet/preise/
  aliasfamilienkarten-und-sondertarife
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id23
  lft189
  rght190
  route/de/skigebiet/preise/familienkarten-und-sondertarife
- $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	ZB03Nk3G5hWILlRu-89m5wAAAAQ
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	ZB03Nk3G5hWILlRu-89m5wAAAAQ
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	ZB03Nk3G5hWILlRu-89m5wAAAAQ
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 09:05:59 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	35946
Redirect Url	/webroot/de/skigebiet/preise
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/de/skigebiet/preise
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1679636278.4621
Request Time	1679636278

====

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
====

Preise für Wintersportkarten (ab Nov 2022)

Tageskarten

4-Stunden Karte

3-Stunden Karte

2-Stunden Karte

1-Stunden Karte

21-Punkte Karte²

42-Punkte Karte²

Tageskarte Familien (Kinder / Jugendl. 7-17 J.)

3-Stunden Familien (Kinder / Jugendl. 7-17 J.)

Rodelverleih

Kombiticket WatzmannTherme (KINDER / JUGENDL. 7-17 J.)

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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