Schönau a. Königssee - Hier wird Sport groß geschrieben

Einer der Haupt-Tourismusorte im Berchtesgadener Land, in dem es sich hervorragend wohnen lässt. Unmittelbar am Königssee mit seiner weltberühmten Rodelbahn gelegen, bietet der Ort Lebensqualität pur und alle Freizeitmöglichkeiten der Berchtesgadener Alpen. Schönau am Königssee ist Sitz der Galileo Test- und Enwicklungsumgebung (GATE) und der Jennerbahn AG. Die Jennerbahn wird im März 2018 neu eröffnet und gehört damit zu den modernsten Seilbahnanlagen Deutschlands.

Hier gehts direkt zur Gemeinde:

www.schoenau-koenigssee.com

Firmen in Schönau am Königssee:

Heinz Quittenbaum GmbH
Hotel Zechmeisterlehen
Hotel Alpenhof
Jennerbahn AG

Hier finden Sie weitere Firmen in Schönau a. Königssee

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  02317
- ids(array)
  Menu2317
  Content(null)
  Language1
- route(array)
  id26648
  hashdf0aa8d2c172d24831bf627d513173ca
  created2017-08-01 11:14:56
  updated2017-11-03 14:31:51
  modelMenu
  foreign_key2317
  base/staedte-und-gemeinden/
  aliasschoenau-a-koenigssee
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id26635
  lft4557
  rght4562
  route/staedte-und-gemeinden/schoenau-a-koenigssee
- 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: 35 ms
Total Queries: 132 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 `wfg`.`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`))) = '/staedte-und-gemeinden/schoenau-a-koenigssee' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 4557 AND `Route`.`rght` >= 4562 ORDER BY `Route`.`lft` asc	5	5	3	maybe slow
SELECT `Language`.`langid` FROM `wfg`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `wfg`.`settings` AS `Setting` LEFT JOIN `wfg`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	45	45	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 `wfg`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 3, 4, 5, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 54, 55, 56) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	3	3	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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 2317 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 365 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive` FROM `wfg`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (2317) ORDER BY `Content`.`position` asc	2	2	2
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 `wfg`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 275 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 `wfg`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 276 AND `Route`.`model` = 'Content'	1	1	0
SELECT `Host`.`id`, `Host`.`hash`, `Host`.`created`, `Host`.`updated`, `Host`.`title`, `Host`.`host_group_id`, `Host`.`external_id`, `Host`.`output_channel`, `Host`.`category`, `Host`.`stars_sorting`, `Host`.`stars_count`, `Host`.`stars_text`, `Host`.`price_minimum`, `Host`.`price_maximum`, `Host`.`price_1a`, `Host`.`price_1b`, `Host`.`price_1c`, `Host`.`price_2a`, `Host`.`price_2b`, `Host`.`price_2c`, `Host`.`price_3a`, `Host`.`price_3b`, `Host`.`price_4a`, `Host`.`price_4b`, `Host`.`price_camping_1_1`, `Host`.`price_camping_1_2`, `Host`.`price_camping_2_1`, `Host`.`price_camping_2_2`, `Host`.`price_camping_3_1`, `Host`.`price_camping_3_2`, `Host`.`price_camping_4_1`, `Host`.`price_camping_4_2`, `Host`.`price_camping_5_1`, `Host`.`price_camping_5_2`, `Host`.`format_sorting`, `Host`.`booking_url`, `Host`.`owner`, `Host`.`street`, `Host`.`place`, `Host`.`email`, `Host`.`website_url`, `Host`.`phone`, `Host`.`mobile`, `Host`.`fax`, `Host`.`youtube_url1`, `Host`.`youtube_url2`, `Host`.`trustyou_id`, `Host`.`shorttext`, `Host`.`next_busstop`, `Host`.`busstop_minutes_by_foot`, `Host`.`house_prospect_url`, `Host`.`webtext`, `Host`.`map_lat`, `Host`.`map_long`, `Host`.`status`, `Host`.`tomas_id`, `Host`.`previous_url`, `Host`.`2bedroom`, `Host`.`3bedroom`, `Host`.`4bedroom`, `Host`.`mbedroom`, `Host`.`webcam_image`, `Host`.`webcam_link`, `Host`.`opening_hours`, `Host`.`parking_lots`, `Host`.`altitude`, `Host`.`image_order`, `Host`.`digiggv`, (CONCAT_WS (',',`Host`.`map_lat`,`Host`.`map_long`)) AS `Host__map`, `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 `wfg`.`hosts` AS `Host` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Host`.`id` AND `Route`.`model` = 'Host') WHERE `Host`.`output_channel` = 'ggv' AND `Host`.`format_sorting` IN (1, 2, 3) ORDER BY `Host`.`format_sorting`=1 DESC, RAND() ASC LIMIT 4	0	0	1	maybe slow
SELECT `Host`.`id`, `Host`.`hash`, `Host`.`created`, `Host`.`updated`, `Host`.`title`, `Host`.`host_group_id`, `Host`.`external_id`, `Host`.`output_channel`, `Host`.`category`, `Host`.`stars_sorting`, `Host`.`stars_count`, `Host`.`stars_text`, `Host`.`price_minimum`, `Host`.`price_maximum`, `Host`.`price_1a`, `Host`.`price_1b`, `Host`.`price_1c`, `Host`.`price_2a`, `Host`.`price_2b`, `Host`.`price_2c`, `Host`.`price_3a`, `Host`.`price_3b`, `Host`.`price_4a`, `Host`.`price_4b`, `Host`.`price_camping_1_1`, `Host`.`price_camping_1_2`, `Host`.`price_camping_2_1`, `Host`.`price_camping_2_2`, `Host`.`price_camping_3_1`, `Host`.`price_camping_3_2`, `Host`.`price_camping_4_1`, `Host`.`price_camping_4_2`, `Host`.`price_camping_5_1`, `Host`.`price_camping_5_2`, `Host`.`format_sorting`, `Host`.`booking_url`, `Host`.`owner`, `Host`.`street`, `Host`.`place`, `Host`.`email`, `Host`.`website_url`, `Host`.`phone`, `Host`.`mobile`, `Host`.`fax`, `Host`.`youtube_url1`, `Host`.`youtube_url2`, `Host`.`trustyou_id`, `Host`.`shorttext`, `Host`.`next_busstop`, `Host`.`busstop_minutes_by_foot`, `Host`.`house_prospect_url`, `Host`.`webtext`, `Host`.`map_lat`, `Host`.`map_long`, `Host`.`status`, `Host`.`tomas_id`, `Host`.`previous_url`, `Host`.`2bedroom`, `Host`.`3bedroom`, `Host`.`4bedroom`, `Host`.`mbedroom`, `Host`.`webcam_image`, `Host`.`webcam_link`, `Host`.`opening_hours`, `Host`.`parking_lots`, `Host`.`altitude`, `Host`.`image_order`, `Host`.`digiggv`, (CONCAT_WS (',',`Host`.`map_lat`,`Host`.`map_long`)) AS `Host__map`, `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 `wfg`.`hosts` AS `Host` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Host`.`id` AND `Route`.`model` = 'Host') WHERE `Host`.`output_channel` = 'wellness' ORDER BY (`Host`.`format_sorting` IS NULL), `Host`.`format_sorting` ASC, RAND("084dbae8913f82061ca117d5244882ce") LIMIT 4	0	0	1	maybe slow
SELECT `HostGroup`.`id`, `HostGroup`.`title` FROM `wfg`.`host_groups` AS `HostGroup` JOIN `wfg`.`hosts` AS `Host` ON (`Host`.`host_group_id` = `HostGroup`.`id`) WHERE 1 = 1 GROUP BY `HostGroup`.`id`	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'show-all-hosts' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'quick-search' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'offers-flatrates' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'hosts' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'health' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' 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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 1044 ORDER BY `Menu`.`lft` asc	520	520	2
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-service' 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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `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`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2448 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (863) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 863 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (617) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 617 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2448) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `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`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 2448 AND `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1'	1	1	10	maybe slow
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (864) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 864 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (618) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 618 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WeatherMapUpload`.`id`, `WeatherMapUpload`.`hash`, `WeatherMapUpload`.`created`, `WeatherMapUpload`.`updated`, `WeatherMapUpload`.`model`, `WeatherMapUpload`.`field`, `WeatherMapUpload`.`foreign_key`, `WeatherMapUpload`.`alias`, `WeatherMapUpload`.`thumbnail`, `WeatherMapUpload`.`parent_id`, `WeatherMapUpload`.`file`, `WeatherMapUpload`.`size`, `WeatherMapUpload`.`ext`, `WeatherMapUpload`.`mime`, `WeatherMapUpload`.`width`, `WeatherMapUpload`.`height` FROM `wfg`.`uploads` AS `WeatherMapUpload` WHERE `WeatherMapUpload`.`model` = 'Content' AND `WeatherMapUpload`.`field` = 'weather_map' AND `WeatherMapUpload`.`foreign_key` = (374) ORDER BY FIELD(COALESCE(`WeatherMapUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, `ArticleContentMedia`.`status`, `ArticleContentMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ArticleContentMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4225) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, `GalleryMedia`.`status`, `GalleryMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `GalleryMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WebradioHeaderImageMedia`.`id`, `WebradioHeaderImageMedia`.`hash`, `WebradioHeaderImageMedia`.`created`, `WebradioHeaderImageMedia`.`updated`, `WebradioHeaderImageMedia`.`title`, `WebradioHeaderImageMedia`.`status`, `WebradioHeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `WebradioHeaderImageMedia`.`id`) AS `WebradioHeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `WebradioHeaderImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `WebradioHeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'webradio_header_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `SnowReportImageMedia`.`id`, `SnowReportImageMedia`.`hash`, `SnowReportImageMedia`.`created`, `SnowReportImageMedia`.`updated`, `SnowReportImageMedia`.`title`, `SnowReportImageMedia`.`status`, `SnowReportImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `SnowReportImageMedia`.`id`) AS `SnowReportImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `SnowReportImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `SnowReportImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'snow_report_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LakeReportGalleryMedia`.`id`, `LakeReportGalleryMedia`.`hash`, `LakeReportGalleryMedia`.`created`, `LakeReportGalleryMedia`.`updated`, `LakeReportGalleryMedia`.`title`, `LakeReportGalleryMedia`.`status`, `LakeReportGalleryMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) AS `LakeReportGalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `LakeReportGalleryMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'lake_report_gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `DownloadTeaserFileMedia`.`id`, `DownloadTeaserFileMedia`.`hash`, `DownloadTeaserFileMedia`.`created`, `DownloadTeaserFileMedia`.`updated`, `DownloadTeaserFileMedia`.`title`, `DownloadTeaserFileMedia`.`status`, `DownloadTeaserFileMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) AS `DownloadTeaserFileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `DownloadTeaserFileMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'download_teaser_file' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `POI`.`id`, `POI`.`hash`, `POI`.`created`, `POI`.`updated`, `POI`.`internal_title`, `POI`.`ordering_number`, `POI`.`address_zip`, `POI`.`address_city`, `POI`.`address_street`, `POI`.`address_country`, `POI`.`address_lat`, `POI`.`address_long`, `POI`.`phone`, `POI`.`email`, `POI`.`fax`, `POI`.`starting_point_zip`, `POI`.`starting_point_city`, `POI`.`starting_point_street`, `POI`.`starting_point_country`, `POI`.`starting_point_lat`, `POI`.`starting_point_long`, `POI`.`accessibility`, `POI`.`webcam`, `POI`.`height`, `POI`.`overnight_stay`, `POI`.`alpine_club`, `POI`.`family_friendly`, `POI`.`tip_for_bad_weather`, `POI`.`tickets`, `POI`.`seasons`, `POI`.`categories`, `POI`.`external_id`, `POI`.`customer_fax`, `POI`.`customer_mobile`, `POI`.`customer_phone`, `POI`.`customer_web`, `POI`.`customer_email`, `POI`.`customer_company`, `POI`.`customer_salutation`, `POI`.`customer_name`, `POI`.`customer_first_name`, `POI`.`customer_street`, `POI`.`customer_zip`, `POI`.`customer_city`, `POI`.`customer_country`, `POI`.`show_customer_communication_address`, `POI`.`municipality`, `POI`.`status`, `POI`.`gallery1_position`, `POI`.`gallery2_position`, `POI`.`gallery3_position`, `POI`.`gallery4_position`, `POI`.`gallery5_position`, `POI`.`gallery6_position`, `POI`.`gallery7_position`, `POI`.`gallery8_position`, `POI`.`gallery9_position`, `POI`.`gallery10_position`, `POI`.`webcam_layout`, `POI`.`advertising_banner_id`, `POI`.`widget_code`, (CONCAT_WS (',',`POI`.`address_lat`,`POI`.`address_long`)) AS `POI__address`, (CONCAT_WS (',',`POI`.`starting_point_lat`,`POI`.`starting_point_long`)) AS `POI__starting_point`, `ContentsPoi`.`id`, `ContentsPoi`.`content_id`, `ContentsPoi`.`poi_id`, `ContentsPoi`.`position` FROM `wfg`.`poi` AS `POI` JOIN `wfg`.`contents_poi` AS `ContentsPoi` ON (`ContentsPoi`.`content_id` = 374 AND `ContentsPoi`.`poi_id` = `POI`.`id`) ORDER BY `ContentsPoi`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social-media' 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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 1046 AND `Menu`.`rght` < 1051 ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1105 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 819 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' 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 `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (2523, 1818) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 1118 AND `Menu`.`rght` < 1133 ORDER BY `Menu`.`lft` asc	7	7	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 194 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 507 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8749) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 509 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8750) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1040 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9071) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1039 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8752) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1038 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8751) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 935 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 `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8693) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	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 `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (173, 2422, 2424, 2504, 2503, 2502, 2486) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	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 `wfg`.`languages` AS `Language` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	2	2	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 `wfg`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 2317 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (365) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`id` = 2317 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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 1080 AND `Menu`.`rght` >= 1081 AND `Menu`.`id` NOT IN (106, 15, 172, 173, 2, 34, 58, 967, 16, 17, 117, 118, 1263, 1264, 1265, 1266) ORDER BY `Menu`.`lft` asc	2	2	1	maybe slow
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 `wfg`.`languages` AS `Language` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `langid` = 'de' LIMIT 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 `wfg`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'en' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'home' AND `MountPoint`.`language_id` = 1 LIMIT 1	1	1	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view` FROM `wfg`.`menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1	1	1	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 `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Parent`.`id` FROM `wfg`.`menus` AS `Menu` JOIN `wfg`.`menus` AS `Parent` ON (`Parent`.`lft` <= `Menu`.`lft` AND `Parent`.`rght` >= `Menu`.`rght`) JOIN `wfg`.`uploads` AS `Upload` ON (`Upload`.`foreign_key` = `Parent`.`id` AND `Upload`.`model` = 'Menu' AND `Upload`.`field` = 'icon') WHERE `Menu`.`id` = 2317 ORDER BY `Parent`.`lft` DESC LIMIT 1	0	0	1	maybe slow
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar_nav' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 1052 AND `Menu`.`rght` < 1117 ORDER BY `Menu`.`lft` asc	32	32	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'news' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' 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`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `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`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1225 LIMIT 1	1	1	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 `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1225) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'nav-banner' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'free-consultation' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'toolbar_nav' AND `Language`.`langid` = 'de' LIMIT 1	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 `wfg`.`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`))) = '/staedte-und-gemeinden/schoenau-a-koenigssee/ortsbeschreibung-schoenau-a-koenigssee' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 4558 AND `Route`.`rght` >= 4559 ORDER BY `Route`.`lft` asc	6	6	3	maybe slow
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 275 AND (1=1) = '1' LIMIT 1	1	1	1
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (729) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	1	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 729 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8513 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8513) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8513 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	10	10	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8513 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	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 `wfg`.`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`))) = '/staedte-und-gemeinden/schoenau-a-koenigssee/weitere-links-schoenau-am-koenigssee' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 4560 AND `Route`.`rght` >= 4561 ORDER BY `Route`.`lft` asc	6	6	2	maybe slow
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 276 AND (1=1) = '1' LIMIT 1	1	1	1
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (730) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 730 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 `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 27475 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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' 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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`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` = 'search' 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 `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 28575 LIMIT 1	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 4225 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 4225 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 4225 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8749 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8749 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8749 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8750 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8750 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8750 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9071 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9071 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	6	6	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9071 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8752 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8752 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8752 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8751 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8751 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8751 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8693 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8693 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8693 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.64 MB

Message	Memory use
Component initialization	1.82 MB
Controller action start	3.36 MB
Controller render start	3.57 MB
Component initialization #2	7.93 MB
Controller action start #2	8.04 MB
Controller render start #2	8.15 MB
Component initialization #3	8.51 MB
Controller action start #3	8.52 MB
Controller render start #3	8.63 MB
View render complete	8.98 MB

Timers

Total Request Time: 453 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	107.68
Event: Controller.initialize	48.97
Event: Controller.startup	0.71
Controller action	12.53
Event: Controller.beforeRender	111.70
» Processing toolbar data	18.67
Rendering View	93.46
» Event: View.beforeRender	0.32
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	61.12
» » Event: Controller.initialize #2	0.11
» » Event: Controller.startup #2	0.14
» » Controller action #2	4.75
» » Event: Controller.beforeRender #2	10.37
» » » Processing toolbar data #2	10.21
Rendering View #2	0.00
» » » Event: View.beforeRender #2	0.04
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	10.89
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.46
» » » Event: View.afterRender	0.06
» » » Event: Controller.shutdown	0.03
» » » Event: Controller.initialize #3	0.10
» » » Event: Controller.startup #3	0.13
» » » Controller action #3	2.77
» » » Event: Controller.beforeRender #3	7.60
» » » » Processing toolbar data #3	7.50
Rendering View #3	0.00
» » » » Event: View.beforeRender #3	0.04
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.65
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.29
» » » » Event: View.afterRender #2	0.03
» » » » Event: Controller.shutdown #2	0.02
» » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #3	0.25
» » » Event: View.afterRender #3	0.12
» » » Event: View.beforeLayout	0.02
» » » Rendering APP/View/Layouts/index.php	29.41
» » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.33
» » » » Rendering APP/View/Elements/navigation.php	5.25
» » » » Rendering APP/View/Elements/footer_collapse.php	0.34
» » » » Rendering APP/View/Elements/footer_subtree.php	0.75
» » » » Rendering APP/View/Elements/footer_collapse.php #2	0.24
» » » » Rendering APP/View/Elements/footer_subtree.php #2	0.55
» » » » Rendering APP/View/Elements/footer_collapse.php #3	0.21
» » » » Rendering APP/View/Elements/footer_subtree.php #3	0.45
» » » » Rendering APP/View/Elements/footer_collapse.php #4	0.21
» » » » Rendering APP/View/Elements/footer_partner.php	8.71
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
 Menu(array)
 id2317
 hash87ac7fb4c38c13e09330b9b553748bf7
 created2017-08-01 11:14:56
 updated2017-11-03 14:31:51
 parent_id2304
 lft1080
 rght1081
 language_id1
 typecontent
 titleSchönau a. Königssee
 previous_url(null)
 url(null)
 target_blank(false)
 calendar_label_type(null)
 ad_types0
 breadcrumb_no_link(false)
 teaser_search_result_view(null)
 Seo(array)
 id365
 hashb830763784f5d673f9ecde9b30399e9a
 created2017-08-01 11:14:56
 updated2017-11-03 14:31:51
 modelMenu
 foreign_key2317
 title
 description
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 canonical_url
 ImageMedia(empty)
 Content(array)
 0(array)
 id275
 snow_report_poi_id(null)
 snow_report_ski_area_id(null)
 hash7f1bc503bc5fb3db4538f1d8bd67eb03
 created2017-09-04 15:26:25
 updated2018-12-07 08:07:47
 menu_id2317
 position1
 typearticle
 statusactive
 titleOrtsbeschreibung Schönau a. Königssee
 language_id1
 article_content<h1>Schönau a. Königssee - Hier wird Sport groß geschrieben</h1> <figure class="figure-responsive"> <div class="img-responsive" data-media-id="8513"> </div> <figcaption class="hidden"></figcaption> </figure> Einer der Haupt-Tourismusorte im Berchtesgadener Land, in dem es sich hervorragend wohnen lässt. Unmittelbar am Königssee mit seiner weltberühmten Rodelbahn gelegen, bietet der Ort Lebensqualität pur und alle Freizeitmöglichkeiten der Berchtesgadener Alpen. Schönau am Königssee ist Sitz der <a href="http://www.gate-testbed.com" target="_blank">Galileo Test- und Enwicklungsumgebung (GATE)</a> und der Jennerbahn AG. Die Jennerbahn wird im März 2018 neu eröffnet und gehört damit zu den modernsten Seilbahnanlagen Deutschlands. 
 layoutcol8
 links_content(null)
 contact_content(null)
 contact_email(null)
 contact_email_cc(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 flatrate_id(null)
 gmap_zoom(null)
 video_type(null)
 menu_teaser_menu_id(null)
 video_url(null)
 gmap_long(null)
 flatrate_index_tag_id(null)
 gmap_marker(null)
 gmap_type(null)
 gmap_lat(null)
 url_teaser_url(null)
 url_teaser_target(null)
 flex_view_id(null)
 rit_agb(null)
 webcam_image(null)
 webcam_url(null)
 webcam_type(null)
 webcam_height(null)
 host_search_output_channel(null)
 webradio_url(null)
 flatrate_request_lang(null)
 snow_report_weather_url(null)
 snow_report_weather_url_target(null)
 snow_report_price_url(null)
 snow_report_price_url_target(null)
 snow_report_phone(null)
 snow_report_webcam_title(null)
 snow_report_webcam_image(null)
 snow_report_webcam_title_2(null)
 snow_report_webcam_image_2(null)
 lake_report_bergfex_lake_id(null)
 lake_report_custom_title(null)
 lake_report_title(null)
 lake_report_article(null)
 lake_report_weather_location(null)
 lake_webcam_image(null)
 lake_webcam_title(null)
 lake_webcam_title_2(null)
 lake_webcam_image_2(null)
 teaser_banner(false)
 developer_template_code(null)
 float_left(false)
 developer_template_js(null)
 developer_template_css(null)
 childhood_memories_category(null)
 conference_request_category(null)
 poi_teaser_poi_id(null)
 flatrate_id_backup(null)
 poi_index_criteria_municipalities(null)
 poi_index_criteria_properties(null)
 poi_index_criteria_categories(null)
 webcam_id(null)
 teaser_search_result_view(null)
 employee_id(null)
 anex_id
 anex_region1
 anex_type1
 anex_selection1
 advertising_banner_id(null)
 placeholder_text(null)
 countdown_datetime(null)
 gmap
 published1
 isActive1
 Route(array)
 id27079
 hashd304d491571812689de396f8360cc871
 created2017-09-04 15:26:25
 updated2018-12-07 08:07:47
 modelContent
 foreign_key275
 base/staedte-und-gemeinden/schoenau-a-koenigssee/
 aliasortsbeschreibung-schoenau-a-koenigssee
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id26648
 lft4558
 rght4559
 route/staedte-und-gemeinden/schoenau-a-koenigssee/ortsbeschreibung-schoenau-a-koenigssee
 1(array)
 id276
 snow_report_poi_id(null)
 snow_report_ski_area_id(null)
 hash96d39fb5b3164cb1b026ee566fb7fffd
 created2017-09-04 15:27:12
 updated2018-03-19 13:05:18
 menu_id2317
 position2
 typearticle
 statusactive
 titleWeitere Links Schönau am Königssee
 language_id1
 article_contentHier gehts direkt zur Gemeinde: <a href="http://www.schoenau-koenigssee.com/" target="_blank">www.schoenau-koenigssee.com</a> Firmen in Schönau am Königssee: Heinz Quittenbaum GmbH Hotel Zechmeisterlehen Hotel Alpenhof Jennerbahn AG Hier finden Sie weitere Firmen in Schönau a. Königssee 
 layoutcol4
 links_content(null)
 contact_content(null)
 contact_email(null)
 contact_email_cc(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 flatrate_id(null)
 gmap_zoom(null)
 video_type(null)
 menu_teaser_menu_id(null)
 video_url(null)
 gmap_long(null)
 flatrate_index_tag_id(null)
 gmap_marker(null)
 gmap_type(null)
 gmap_lat(null)
 url_teaser_url(null)
 url_teaser_target(null)
 flex_view_id(null)
 rit_agb(null)
 webcam_image(null)
 webcam_url(null)
 webcam_type(null)
 webcam_height(null)
 host_search_output_channel(null)
 webradio_url(null)
 flatrate_request_lang(null)
 snow_report_weather_url(null)
 snow_report_weather_url_target(null)
 snow_report_price_url(null)
 snow_report_price_url_target(null)
 snow_report_phone(null)
 snow_report_webcam_title(null)
 snow_report_webcam_image(null)
 snow_report_webcam_title_2(null)
 snow_report_webcam_image_2(null)
 lake_report_bergfex_lake_id(null)
 lake_report_custom_title(null)
 lake_report_title(null)
 lake_report_article(null)
 lake_report_weather_location(null)
 lake_webcam_image(null)
 lake_webcam_title(null)
 lake_webcam_title_2(null)
 lake_webcam_image_2(null)
 teaser_banner(false)
 developer_template_code(null)
 float_left(false)
 developer_template_js(null)
 developer_template_css(null)
 childhood_memories_category(null)
 conference_request_category(null)
 poi_teaser_poi_id(null)
 flatrate_id_backup(null)
 poi_index_criteria_municipalities(null)
 poi_index_criteria_properties(null)
 poi_index_criteria_categories(null)
 webcam_id(null)
 teaser_search_result_view(null)
 employee_id(null)
 anex_id
 anex_region1
 anex_type1
 anex_selection1
 advertising_banner_id(null)
 placeholder_text(null)
 countdown_datetime(null)
 gmap
 published1
 isActive1
 Route(array)
 id27080
 hash548f74774d7a683f5888e1142963cc5a
 created2017-09-04 15:27:12
 updated2018-03-19 13:05:18
 modelContent
 foreign_key276
 base/staedte-und-gemeinden/schoenau-a-koenigssee/
 aliasweitere-links-schoenau-am-koenigssee
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id26648
 lft4560
 rght4561
 route/staedte-und-gemeinden/schoenau-a-koenigssee/weitere-links-schoenau-am-koenigssee
- $request->data(empty)
- $this->validationErrors(array)
 Route(empty)
 MountPoint(empty)
 Redirect(empty)
 Language(empty)
 Menu(empty)
 Parent(empty)
 Seo(empty)
 ImageMedia(empty)
 MediaEntity(empty)
 Teaser(empty)
 Content(empty)
 ArticleContentMedia(empty)
 GalleryMedia(empty)
 WebradioHeaderImageMedia(empty)
 SnowReportImageMedia(empty)
 LakeReportGalleryMedia(empty)
 DownloadTeaserFileMedia(empty)
 POI(empty)
 Webcam(empty)
 Setting(empty)
 ValueUpload(empty)
 FileUpload(empty)
 Host(empty)
 HostPictogram(empty)
 HostQualitySeal(empty)
 Image1Upload(empty)
 HostGroup(empty)
 IconUpload(empty)
 ImageUpload(empty)
 WeatherMapUpload(empty)
 ContentsPoi(empty)
 FlagUpload(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7Enum
 8SocialMedia
 9Maps
 10Embed
 11Layout
 12OAJs
 13OA
 14BitMask
 15ThirdPartyCookies
 16Number
 17SimpleGraph
 18DebugTimer
 19Toolbar
 20Session
 21Js
 22HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.0.33
User	u5438905893045
Home	/var/www/vhosts/berchtesgadener-land.de
Script Name	/webroot/index.php
Request Uri	/staedte-und-gemeinden/schoenau-a-koenigssee
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/staedte-und-gemeinden/schoenau-a-koenigssee
Remote Port	33184
Script Filename	/var/www/vhosts/berchtesgadener-land.de/httpdocs/webroot/index.php
Server Admin	plesk-admin@internetx.com
Context Document Root	/var/www/vhosts/berchtesgadener-land.de/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/berchtesgadener-land.de/httpdocs
Remote Addr	3.236.59.63
Server Port	443
Server Addr	62.116.174.142
Server Name	www.berchtesgadener-land.de
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
Http If Modified Since	Tue, 31 Mar 2020 19:02:38 UTC
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	3.236.59.63
Http Host	www.berchtesgadener-land.de
Proxy-nokeepalive	1
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Script Uri	https://www.berchtesgadener-land.de/staedte-und-gemeinden/schoenau-a-koenigssee
Script Url	/staedte-und-gemeinden/schoenau-a-koenigssee
Unique Id	Xw@qwPvoyhkvAgJhIQ5QfQAAAkE
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Script Uri	https://www.berchtesgadener-land.de/staedte-und-gemeinden/schoenau-a-koenigssee
Redirect Script Url	/staedte-und-gemeinden/schoenau-a-koenigssee
Redirect Unique Id	Xw@qwPvoyhkvAgJhIQ5QfQAAAkE
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Script Uri	https://www.berchtesgadener-land.de/staedte-und-gemeinden/schoenau-a-koenigssee
Redirect Redirect Script Url	/staedte-und-gemeinden/schoenau-a-koenigssee
Redirect Redirect Unique Id	Xw@qwPvoyhkvAgJhIQ5QfQAAAkE
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1594862272.0699
Request Time	1594862272

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.0/share/pear
- 2-> /var/www/vhosts/berchtesgadener-land.de/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.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/CakeNumber.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  6APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  ApiClient(array)
  Config(array)
  0ApiClient/Config/bootstrap.php
  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/HabtmBehavior.php
  11BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Component(array)
  0Contents/Controller/Component/FacebookApiComponent.php
  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
  Flatrates(array)
  Config(array)
  0Flatrates/Config/bootstrap.php
  FrontendFlatrates(array)
  Config(array)
  0FrontendFlatrates/Config/routes.php
  FrontendHosts(array)
  Config(array)
  0FrontendHosts/Config/bootstrap.php
  1FrontendHosts/Config/routes.php
  FrontendMenus(array)
  Controller(array)
  0FrontendMenus/Controller/FrontendMenusController.php
  1FrontendMenus/Controller/FrontendMenusAppController.php
  FrontendPOI(array)
  Config(array)
  0FrontendPOI/Config/bootstrap.php
  FrontendPressArchive(array)
  Config(array)
  0FrontendPressArchive/Config/routes.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
  Hosts(array)
  Config(array)
  0Hosts/Config/bootstrap.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  POI(array)
  Model(array)
  0POI/Model/POI.php
  1POI/Model/POIAppModel.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
  Webcams(array)
  Model(array)
  0Webcams/Model/Webcam.php
  1Webcams/Model/WebcamsAppModel.php
====

Schönau a. Königssee - Hier wird Sport groß geschrieben

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 35 ms Total Queries: 132 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 35 ms
Total Queries: 132 queries