Lifte, Pisten & Wetter

Aktuelle Meldungen

2023-03-13 16:35:00

Sonntag 05.03. letzter Betriebstag der Wintersaison!

Alle Anlagen bis 01. Mai 2023 wegen Revision geschlossen.

Bei sonniger Witterung an den Osterfeiertagen Sesselbahn in Betrieb.

Täglicher Fahrbetrieb

09:00- 16:00

Lifte / Anlagen in Betrieb

Lifte

0/3 geöffnet

Hirscheckblitz Rodelbahn

Ort	Status	Pistenbedingungen	Schneebedingungen
Hirscheckblitz Rodelbahn	geschlossen

Lifte & Bedingungen

Ort	Status	Pistenbedingungen	Schneebedingungen
Hirscheckbahn	geschlossen
Schmuckenlift	geschlossen
Fronwieslift	geschlossen
Kinderlift	geschlossen

Wetterbedingungen

Sicht	schlecht
Temperatur	+1 °C
Wind	0 km/h

Schneehöhen

Schneehöhe Bergstation	cm
Schneehöhe Mittelstation	cm
Schneehöhe Talstation	cm
Neuschnee	0 cm
Letzter Schneefall	2023-02-27

Preise Winter

Webcam & 360° Panorama

Pistenplan

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  024
- ids(array)
  Menu24
  Content(null)
  Language1
- route(array)
  id25
  hash4592088e3f6939cba10d90525057ff1b
  created2017-08-17 17:05:28
  updated2017-12-20 10:17:11
  modelMenu
  foreign_key24
  base/de/skigebiet/
  aliaspistenbedingungen
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id13
  lft196
  rght207
  route/de/skigebiet/pistenbedingungen
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(null)
  actionindex
- template/*
====

Sql Log

Sql Logs

default

Total Time: 13 ms
Total Queries: 120 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/pistenbedingungen' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 196 AND `Route`.`rght` >= 207 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` = 24 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` = 24 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` = 24 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` = 24 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` = 24 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` = 24 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` = (24)	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 (241, 242, 243, 244, 245, 246) 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` = (24) 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` = 24 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` = 24 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` = 24 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` = (24) ORDER BY `Content`.`position` asc	5	5	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` = 12 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` = 11 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` = 15 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` = 16 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` = 17 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	1
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	1
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	1	maybe slow
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	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` = '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` = 24	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` = 24 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` = 24 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` <= 27 AND `Menu`.`rght` >= 28 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/pistenbedingungen/lifte' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 199 AND `Route`.`rght` >= 200 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` = 12 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` = 53 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/pistenbedingungen/wetterbericht' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 197 AND `Route`.`rght` >= 198 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` = 11 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` = 52 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WeatherReport`.`id`, `WeatherReport`.`hash`, `WeatherReport`.`created`, `WeatherReport`.`updated`, `WeatherReport`.`date`, `WeatherReport`.`status`, `WeatherReport`.`announcement`, `WeatherReport`.`daily_driving`, `WeatherReport`.`lifts_operation`, `WeatherReport`.`hirscheckbahn_status`, `WeatherReport`.`schmuckenlift_status`, `WeatherReport`.`fronwieslift_status`, `WeatherReport`.`hirscheckbahn_piste_condition`, `WeatherReport`.`schmuckenlift_piste_condition`, `WeatherReport`.`fronwieslift_piste_condition`, `WeatherReport`.`hirscheckbahn_snow_condition`, `WeatherReport`.`schmuckenlift_snow_condition`, `WeatherReport`.`fronwieslift_snow_condition`, `WeatherReport`.`hirscheckblitz_status`, `WeatherReport`.`hirscheckblitz_piste_condition`, `WeatherReport`.`hirscheckblitz_snow_condition`, `WeatherReport`.`view`, `WeatherReport`.`temperature`, `WeatherReport`.`wind`, `WeatherReport`.`last_snowfall`, `WeatherReport`.`snowdepth_mountainstation`, `WeatherReport`.`snowdepth_middlestation`, `WeatherReport`.`snowdepth_bottomstation`, `WeatherReport`.`newsnow`, `WeatherReport`.`bergfex_snow_condition`, `WeatherReport`.`kinderlift_status`, `WeatherReport`.`kinderlift_piste_condition`, `WeatherReport`.`kinderlift_snow_condition` FROM `hochschwarzeck`.`weather_reports` AS `WeatherReport` WHERE `WeatherReport`.`status` = 'active' ORDER BY `date` DESC 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/skigebiet/pistenbedingungen/teaser-box-preise' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 201 AND `Route`.`rght` >= 202 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`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `hochschwarzeck`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 15 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` = 56 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 56 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (30) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `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 LIMIT 1	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 `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 `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/pistenbedingungen/teaser-box-webcam' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 203 AND `Route`.`rght` >= 204 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`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `hochschwarzeck`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 16 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` = 57 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 57 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (38) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`icon_image`, `Menu`.`landingpage_img`, `Menu`.`fullscreen`, `Menu`.`icon_text`, `Menu`.`landingpage_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `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` = 3 LIMIT 1	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` = 3 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 3 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` = (3)	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 (457, 458, 459, 460, 461, 462) 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` = (3) 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` = 3 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` = 3 AND `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'landingpage_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/pistenbedingungen/teaser-box-pistenplan' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `hochschwarzeck`.`routes` AS `Route` WHERE `Route`.`lft` <= 205 AND `Route`.`rght` >= 206 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`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `hochschwarzeck`.`contents` AS `Content` LEFT JOIN `hochschwarzeck`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `hochschwarzeck`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `hochschwarzeck`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 17 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` = 58 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 58 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `hochschwarzeck`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `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` = 44 LIMIT 1	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` = 66 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 66 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` = (44)	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 (271, 272, 273, 274, 275, 276) 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` = (12) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	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` = (44) 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` = 44 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` = 44 AND `MediaEntity`.`media_id` = `LandingpageImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'landingpage_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 23.23 MB

Message	Memory use
Component initialization	6.84 MB
Controller action start	9.60 MB
Controller render start	10.45 MB
Component initialization #2	14.74 MB
Controller action start #2	14.91 MB
Controller render start #2	15.07 MB
Component initialization #3	15.33 MB
Controller action start #3	15.36 MB
Controller render start #3	15.53 MB
Component initialization #4	15.72 MB
Controller action start #4	15.75 MB
Controller render start #4	15.99 MB
Component initialization #5	16.19 MB
Controller action start #5	16.21 MB
Controller render start #5	16.45 MB
Component initialization #6	16.64 MB
Controller action start #6	16.67 MB
Controller render start #6	16.94 MB
Component initialization #7	17.81 MB
Controller action start #7	17.90 MB
Controller render start #7	18.03 MB
View render complete	18.13 MB

Timers

Total Request Time: 726 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	97.95
Event: Controller.initialize	46.03
Event: Controller.startup	1.66
Controller action	21.40
Event: Controller.beforeRender	102.93
» Processing toolbar data	31.88
Rendering View	291.21
» Event: View.beforeRender	0.06
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	207.73
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	206.92
» » » Event: Controller.initialize #2	5.54
» » » Event: Controller.startup #2	0.44
» » » Controller action #2	3.80
» » » Event: Controller.beforeRender #2	15.94
» » » » Processing toolbar data #2	15.74
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.07
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	2.62
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.54
» » » » Event: View.afterRender	0.05
» » » » Event: Controller.shutdown	0.04
» » » » Event: Controller.initialize #3	5.66
» » » » Event: Controller.startup #3	0.48
» » » » Controller action #3	5.22
» » » » Event: Controller.beforeRender #3	12.25
» » » » » Processing toolbar data #3	11.98
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.07
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/weather_report.php	3.06
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.55
» » » » » Event: View.afterRender #2	0.05
» » » » » Event: Controller.shutdown #2	0.04
» » » » » Event: Controller.initialize #4	6.62
» » » » » Event: Controller.startup #4	0.62
» » » » » Controller action #4	15.46
» » » » » Event: Controller.beforeRender #4	11.94
» » » » » » Processing toolbar data #4	11.68
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.07
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_menu.php	2.61
» » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php	1.77
» » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_box.php	1.04
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.45
» » » » » » Event: View.afterRender #3	0.05
» » » » » » Event: Controller.shutdown #3	0.05
» » » » » » Event: Controller.initialize #5	5.80
» » » » » » Event: Controller.startup #5	0.58
» » » » » » Controller action #5	15.98
» » » » » » Event: Controller.beforeRender #5	11.65
» » » » » » » Processing toolbar data #5	11.36
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.07
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_menu.php #2	2.65
» » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #2	1.72
» » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_box.php #2	0.99
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.47
» » » » » » » Event: View.afterRender #4	0.05
» » » » » » » Event: Controller.shutdown #4	0.05
» » » » » » » Event: Controller.initialize #6	6.93
» » » » » » » Event: Controller.startup #6	0.62
» » » » » » » Controller action #6	18.34
» » » » » » » Event: Controller.beforeRender #6	11.04
» » » » » » » » Processing toolbar data #6	10.82
Rendering View #6	0.00
» » » » » » » » Event: View.beforeRender #6	0.07
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_menu.php #3	2.94
» » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #3	2.06
» » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_box.php #3	1.29
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.59
» » » » » » » » Event: View.afterRender #5	0.06
» » » » » » » » Event: Controller.shutdown #5	0.05
» » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #6	0.39
» » » » » » Event: View.afterRender #6	0.55
» » » » » » Event: View.beforeLayout	0.10
» » » » » » Rendering APP/View/Layouts/index.php	79.28
» » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	12.35
» » » » » » » Rendering APP/View/Elements/notifications.php	0.73
» » » » » » » Rendering APP/View/Elements/infobar_info.php	4.59
» » » » » » » Rendering APP/View/Elements/infobar_socialmedia.php	1.66
» » » » » » » Rendering APP/View/Elements/navigation.php	9.41
» » » » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/header-slider.php	2.20
» » » » » » » Rendering APP/View/Elements/footer.php	38.49
» » » » » » » » Event: Controller.initialize #7	8.73
» » » » » » » » Event: Controller.startup #7	0.58
» » » » » » » » Controller action #7	3.66
» » » » » » » » Event: Controller.beforeRender #7	11.30
» » » » » » » » » Processing toolbar data #7	11.11
Rendering View #7	0.00
» » » » » » » » » Event: View.beforeRender #7	0.07
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.09
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7	0.50
» » » » » » » » » Event: View.afterRender #7	0.05
» » » » » » » » » Event: Controller.shutdown #6	0.04
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id24
  hash8b6a503f5b9126aa5c1673f50b8a80b5
  created2017-08-17 17:05:28
  updated2017-12-20 10:17:11
  parent_id12
  lft27
  rght28
  language_id1
  typecontent
  titlePistenbedingungen
  previous_urlhttp://www.hochschwarzeck.info/de/wetter-aktuell/
  url(null)
  target_blank(false)
  icon_image(true)
  landingpage_img(false)
  fullscreen(false)
  icon_textPistenbe- dingungen
  landingpage_text
  Seo(array)
  id24
  hash132cf1b2af230f007b0988091a197399
  created2017-08-17 17:05:28
  updated2017-12-20 10:17:11
  modelMenu
  foreign_key24
  titlePistenbedingungen - Lifte, Pisten, Wetter
  descriptionPistenbedingungen für Skipisten und Naturrodelbahn sowie Pisteninfos - geöffnete Anlagen, Schneeverhältnisse, Wetterinformationen für das Familienskigebiet Hochschwarzeck in den Berchtesgadener Alpen
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id12
  hashe37bf6cab1ee85f3c9a1cb3d3ecca21b
  created2017-09-05 13:47:55
  updated2017-09-05 13:47:55
  menu_id24
  position1
  typearticle
  statusactive
  titleLifte,
  layoutcol12
  language_id1
  article_content<h2 style="text-align: center;">Lifte, Pisten & Wetter</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_typeiframe
  webcam_height(null)
  360_panorama_url(null)
  disable_winter_information(null)
  placeholder_text(null)
  gmap
  published1
  Route(array)
  id59
  hash552d2c19ef297aa57657759b5e1de173
  created2017-09-05 13:47:55
  updated2017-09-05 13:47:55
  modelContent
  foreign_key12
  base/de/skigebiet/pistenbedingungen/
  aliaslifte
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id25
  lft199
  rght200
  route/de/skigebiet/pistenbedingungen/lifte
  1(array)
  id11
  hashac00fd76fa7971f6f8b5c9802bf73282
  created2017-09-05 12:09:58
  updated2022-12-19 11:25:34
  menu_id24
  position2
  typeweather_report
  statusactive
  titleWetterbericht
  layoutcol12
  language_id1
  article_content(null)
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  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(false)
  placeholder_text(null)
  gmap
  published1
  Route(array)
  id58
  hashd042f161f2c2fa055e4a02574cfe3b0f
  created2017-09-05 12:09:58
  updated2022-12-19 11:25:35
  modelContent
  foreign_key11
  base/de/skigebiet/pistenbedingungen/
  aliaswetterbericht
  controllerFrontendContents.FrontendContents
  actionweather_report
  parent_id25
  lft197
  rght198
  route/de/skigebiet/pistenbedingungen/wetterbericht
  2(array)
  id15
  hashb6e18303f31940b05c633feaa8f38fd7
  created2017-09-07 12:06:08
  updated2017-12-17 16:47:23
  menu_id24
  position3
  typeteaser_menu
  statusactive
  titleTeaser Box Preise
  layoutcol4
  language_id1
  article_content(null)
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id22
  teaser_external_url(null)
  teaser_external_target(null)
  content_teaser_image_right(null)
  teaser_typebox
  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)
  id62
  hash4716f97d58721174da6a92c2f6052b7e
  created2017-09-07 12:06:08
  updated2017-12-17 16:47:23
  modelContent
  foreign_key15
  base/de/skigebiet/pistenbedingungen/
  aliasteaser-box-preise
  controllerFrontendContents.FrontendContents
  actionteaser_menu
  parent_id25
  lft201
  rght202
  route/de/skigebiet/pistenbedingungen/teaser-box-preise
  3(array)
  id16
  hashc8fb286dbc090ceb82facdbe94cbbaae
  created2017-09-07 12:13:48
  updated2017-12-17 16:48:07
  menu_id24
  position4
  typeteaser_menu
  statusactive
  titleTeaser Box Webcam
  layoutcol4
  language_id1
  article_content(null)
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id3
  teaser_external_url(null)
  teaser_external_target(null)
  content_teaser_image_right(null)
  teaser_typebox
  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)
  id63
  hashe205b337853ab2dc1433c0efeac5c476
  created2017-09-07 12:13:48
  updated2017-12-17 16:48:07
  modelContent
  foreign_key16
  base/de/skigebiet/pistenbedingungen/
  aliasteaser-box-webcam
  controllerFrontendContents.FrontendContents
  actionteaser_menu
  parent_id25
  lft203
  rght204
  route/de/skigebiet/pistenbedingungen/teaser-box-webcam
  4(array)
  id17
  hash823b113a415bde3b9fd575c8b0e56bee
  created2017-09-07 12:14:40
  updated2017-12-17 16:46:59
  menu_id24
  position5
  typeteaser_menu
  statusactive
  titleTeaser Box Pistenplan
  layoutcol4
  language_id1
  article_content(null)
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id44
  teaser_external_url(null)
  teaser_external_target(null)
  content_teaser_image_right(null)
  teaser_typebox
  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)
  id64
  hashbfa7dd2cf4bc246f1956ed152018a027
  created2017-09-07 12:14:40
  updated2017-12-17 16:46:59
  modelContent
  foreign_key17
  base/de/skigebiet/pistenbedingungen/
  aliasteaser-box-pistenplan
  controllerFrontendContents.FrontendContents
  actionteaser_menu
  parent_id25
  lft205
  rght206
  route/de/skigebiet/pistenbedingungen/teaser-box-pistenplan
- $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	ZB1EnB9ehDAZweH7DFuYcAAAAAs
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	ZB1EnB9ehDAZweH7DFuYcAAAAAs
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	ZB1EnB9ehDAZweH7DFuYcAAAAAs
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 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	40432
Redirect Url	/webroot/de/skigebiet/pistenbedingungen
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/de/skigebiet/pistenbedingungen
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1679639708.9135
Request Time	1679639708

====

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

Lifte, Pisten & Wetter

Aktuelle Meldungen

Täglicher Fahrbetrieb

Lifte / Anlagen in Betrieb

Hirscheckblitz Rodelbahn

Lifte & Bedingungen

Wetterbedingungen

Schneehöhen

Preise Winter

Webcam & 360° Panorama

Pistenplan

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 13 ms Total Queries: 120 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 13 ms
Total Queries: 120 queries