* Required field

Today

Clear18°C

Tomorrow

16°C

Sa 23.06

17°C

Water temperature

24°C

go to Webcam

go to map

Tel. +49 (0) 86 81/3 13
info@waginger-see.de Contact form

Leitgeringer See

in the midst of nature

It is almost impossible to get any closer to nature than this: Leitgeringer See is part of the Astener Moos wetland area, its shores enclosed by dense forests. Here, even on the hottest days of summer, you will find pleasant peace & quiet and relaxation. Your walk down to the swimming beach will take you through virgin nature, to a bathing experience very much like back in “the olden days”. So, treat yourself to this timeout and a small adventure next to this tranquil body of water.

Bader Am Leitgeringersee 7598scheuerecker

Facts about Leitgeringer See

Geological Region: Bavarian Alpine Foothills

Tributaries: rivulets and groundwater

Outflow: Spöttlbach

Length: 220 m

Width: 650 m

Maximum Depth: 7 m

Area: 0.1 km²

Perimeter: 2.1 km

Nature Sanctuary: yes

Handicapped Access: yes

LAKESHORE BEACHES & WATER SPORTS

Leitgeringer See Swimming Beach and Seebauer Campgrounds with a private beach give bathers ready access to the lake. Motorboats are not permitted on Leitgeringer See, though a boat rental business does have stand-up paddle boards, pedal boats and rowing boats available.

CAMPGROUNDS & OTHER FACILITIES

Next to Leitgeringer See are the Seebauer Campgrounds as well as a swimming beach with playground, WCs & showers as well as parking.

FLORA & FAUNA

Leitgeringer See features irregular contours and numerous bays. On the western side of the lake, it is abutted by the Astener Moos which, in combination with the lake itself, creates a wetland area. The lakeshore is flanked by woodlands.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent00aaa8a19e13948cb4af2471db6cdd79
  time1529556305
  countdown10
  languageen
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  0243
- ids(array)
  Menu243
  Content(null)
  Language8
- route(array)
  id1041
  hashcd6c58e6331990db535aa472f4ebf78b
  created2017-10-25 14:50:28
  updated2018-06-01 09:03:49
  modelMenu
  foreign_key243
  base/en/region/lakes/
  aliasleiteringer-see
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id1027
  lft1967
  rght1976
  route/en/region/lakes/leiteringer-see
- 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: 53 ms
Total Queries: 115 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 `waging`.`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`))) = '/en/region/lakes/leiteringer-see' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `waging`.`routes` AS `Route` WHERE `Route`.`lft` <= 1967 AND `Route`.`rght` >= 1976 ORDER BY `Route`.`lft` asc	5	5	1	maybe slow
SELECT `Language`.`langid` FROM `waging`.`languages` AS `Language` WHERE `Language`.`id` = 8 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`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 243 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 988 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`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published` FROM `waging`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (243) ORDER BY `Content`.`position` asc	4	4	1	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `waging`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 860 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 `waging`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 861 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 `waging`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 862 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 `waging`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 863 AND `Route`.`model` = 'Content'	1	1	0
SELECT *, Language.id FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 225 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 970 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 970 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (225)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1123, 1124, 1125, 1126, 1127, 1128) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	5	5	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 `waging`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (23, 24, 25, 26, 431) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	52	52	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `waging`.`media` AS `HeaderImagesMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 225 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'meta-a' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 423 AND `Menu`.`rght` < 714 ORDER BY `Menu`.`lft` asc	145	145	1
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `model` = 'Menu' AND `foreign_key` = 243	6	6	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1231, 1232, 1233, 1234, 1235, 1236) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
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 `waging`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (99) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	1	maybe slow
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_navigation' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 722 AND `Menu`.`rght` < 729 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT *, Language.id FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_contact' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 297 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1084 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1084 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (297)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1555, 1556, 1557, 1558, 1559, 1560) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `waging`.`media` AS `HeaderImagesMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 297 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `waging`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 297 LIMIT 1	1	1	7	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1085 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1085 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Content' AND `HeaderImage`.`foreign_key` = (809)	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ArticleContentMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 809 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `GalleryMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 809 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	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 `waging`.`tags` AS `TagsTag` JOIN `waging`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 809 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Content' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT *, Language.id FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_openingHours' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 294 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1081 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1081 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (294)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1537, 1538, 1539, 1540, 1541, 1542) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `waging`.`media` AS `HeaderImagesMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 294 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `waging`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 294 LIMIT 1	1	1	6	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1086 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1086 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Content' AND `HeaderImage`.`foreign_key` = (810)	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ArticleContentMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 810 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `GalleryMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 810 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	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 `waging`.`tags` AS `TagsTag` JOIN `waging`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 810 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Content' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT *, Language.id FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_partner' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 295 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1082 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1082 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (295)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1543, 1544, 1545, 1546, 1547, 1548) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `waging`.`media` AS `HeaderImagesMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 295 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 295	4	4	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1083 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 `waging`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1885 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1886 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 `waging`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1887 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 `waging`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (163) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `waging`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 243 LIMIT 1	1	1	2	maybe slow
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` FROM `waging`.`menus` AS `Menu` WHERE `Menu`.`id` = 243 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 448 AND `Menu`.`rght` >= 449 ORDER BY `Menu`.`lft` asc	4	4	1	maybe slow
SELECT *, Language.id FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'region' AND `Language`.`langid` = 'en' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`menus` AS `Menu` LEFT JOIN `waging`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 228 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 973 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 973 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (228)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1141, 1142, 1143, 1144, 1145, 1146) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `waging`.`media` AS `HeaderImagesMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 228 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `waging`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `waging`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`type` = 'weather' LIMIT 1	1	1	5	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`text`, `HeaderImage`.`link_title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `waging`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Content' AND `HeaderImage`.`foreign_key` = (111)	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ArticleContentMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 111 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `GalleryMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 111 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	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 `waging`.`tags` AS `TagsTag` JOIN `waging`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 111 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Content' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `waging`.`languages` AS `Language` LEFT JOIN `waging`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`id` = 8 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 `waging`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (8) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `waging`.`languages` AS `Language` LEFT JOIN `waging`.`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 `waging`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (7, 8) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	4	4	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 `waging`.`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`))) = '/en/region/lakes/leiteringer-see/lead-in' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `waging`.`routes` AS `Route` WHERE `Route`.`lft` <= 1968 AND `Route`.`rght` >= 1969 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 860 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1136 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 `waging`.`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`))) = '/en/region/lakes/leiteringer-see/bildergalerie' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `waging`.`routes` AS `Route` WHERE `Route`.`lft` <= 1970 AND `Route`.`rght` >= 1971 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 861 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1137 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 `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `GalleryMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 861 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	3	3	1	maybe slow
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 `waging`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (102, 123, 180) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	34	34	1
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 `waging`.`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`))) = '/en/region/lakes/leiteringer-see/text-1' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `waging`.`routes` AS `Route` WHERE `Route`.`lft` <= 1972 AND `Route`.`rght` >= 1973 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 862 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1138 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 `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 `waging`.`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`))) = '/en/region/lakes/leiteringer-see/text-2' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `waging`.`routes` AS `Route` WHERE `Route`.`lft` <= 1974 AND `Route`.`rght` >= 1975 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`webcam_img`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`little_adventure`, `Content`.`weather_lake_temp`, `Content`.`photographer`, `Content`.`employee`, `Content`.`url_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `waging`.`contents` AS `Content` LEFT JOIN `waging`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 863 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `waging`.`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 `waging`.`media` AS `ImageMedia` JOIN `waging`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1139 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `waging`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `waging`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'data-protection' AND `Language`.`langid` = 'en' LIMIT 1	0	0	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `waging`.`settings` AS `Setting` LEFT JOIN `waging`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	27	27	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 `waging`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 26, 27, 28, 29, 30, 31, 32) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `waging`.`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 `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `waging`.`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 `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `waging`.`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` = 'housing_search_results' 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 `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `waging`.`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` = 'search' 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 `waging`.`mount_points` AS `MountPoint` LEFT JOIN `waging`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `waging`.`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` = 'contact_form' LIMIT 1	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 25.43 MB

Message	Memory use
Component initialization	7.39 MB
Controller action start	7.89 MB
Controller render start	10.60 MB
Component initialization #2	15.54 MB
Controller action start #2	15.72 MB
Controller render start #2	15.85 MB
Component initialization #3	16.09 MB
Controller action start #3	16.12 MB
Controller render start #3	16.39 MB
Component initialization #4	16.56 MB
Controller action start #4	16.59 MB
Controller render start #4	16.72 MB
Component initialization #5	16.88 MB
Controller action start #5	16.91 MB
Controller render start #5	17.03 MB
View render complete	18.09 MB

Timers

Total Request Time: 637 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	113.07
Event: Controller.initialize	3.54
Event: Controller.startup	1.44
Controller action	52.45
Event: Controller.beforeRender	158.71
» Processing toolbar data	33.65
Rendering View	156.19
» Event: View.beforeRender	0.06
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	106.52
» » Event: Controller.initialize #2	0.71
» » Event: Controller.startup #2	0.36
» » Controller action #2	4.25
» » Event: Controller.beforeRender #2	10.54
» » » Processing toolbar data #2	10.39
Rendering View #2	0.00
» » » Event: View.beforeRender #2	0.06
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	1.86
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.40
» » » Event: View.afterRender	0.05
» » » Event: Controller.shutdown	0.03
» » » Event: Controller.initialize #3	0.69
» » » Event: Controller.startup #3	0.37
» » » Controller action #3	7.16
» » » Event: Controller.beforeRender #3	9.79
» » » » Processing toolbar data #3	9.64
Rendering View #3	0.00
» » » » Event: View.beforeRender #3	0.05
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/gallery.php	3.63
» » » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php #2	2.71
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.37
» » » » Event: View.afterRender #2	0.05
» » » » Event: Controller.shutdown #2	0.03
» » » » Event: Controller.initialize #4	0.60
» » » » Event: Controller.startup #4	0.34
» » » » Controller action #4	4.35
» » » » Event: Controller.beforeRender #4	10.02
» » » » » Processing toolbar data #4	9.87
Rendering View #4	0.00
» » » » » Event: View.beforeRender #4	0.06
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.02
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.40
» » » » » Event: View.afterRender #3	0.06
» » » » » Event: Controller.shutdown #3	0.05
» » » » » Event: Controller.initialize #5	0.59
» » » » » Event: Controller.startup #5	0.34
» » » » » Controller action #5	4.19
» » » » » Event: Controller.beforeRender #5	10.85
» » » » » » Processing toolbar data #5	10.70
Rendering View #5	0.00
» » » » » » Event: View.beforeRender #5	0.05
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	0.81
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.38
» » » » » » Event: View.afterRender #4	0.05
» » » » » » Event: Controller.shutdown #4	0.03
» » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #5	0.34
» » » » » Event: View.afterRender #5	1.83
» » » » » Event: View.beforeLayout	0.05
» » » » » Rendering APP/View/Layouts/index.php	44.89
» » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	10.63
» » » » » » Rendering APP/View/Elements/navigation.php	13.89
» » » » » » » Rendering APP/View/Elements/regionmap.php	0.41
» » » » » » » Rendering APP/View/Elements/housing_search.php	5.32
» » » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/header-slider.php	1.84
» » » » » » Rendering APP/View/Elements/sidebar.php	10.36
» » » » » » » Rendering APP/View/Elements/housing_search.php #2	4.78
» » » » » » » Rendering APP/View/Elements/sidebar_weather.php	1.13
» » » » » » Rendering APP/View/Elements/footer.php	3.35
» » » » » » Rendering APP/View/Elements/modal.php	0.25
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id243
  hash0a18589bba6cb9b9a15063e3bd484ce4
  created2017-10-25 14:50:28
  updated2018-06-01 09:03:49
  parent_id229
  lft448
  rght449
  language_id8
  typecontent
  titleLeiteringer See
  previous_url(null)
  url(null)
  target_blank(false)
  Seo(array)
  id988
  hash3fe7953f171c85c9c8e4f4bd7ff0c4eb
  created2017-10-25 14:50:28
  updated2018-06-01 09:03:49
  modelMenu
  foreign_key243
  title
  description
  internal_keywords
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id860
  hash33de1a5e16674a9a3f549f13b1f9f828
  created2018-01-08 11:55:21
  updated2018-05-24 11:25:45
  menu_id243
  position1
  typearticle
  statusactive
  titleLead in
  layoutcol12
  language_id8
  article_content<h1 style="text-align: center;">Leitgeringer See</h1> <p style="text-align: center;"><small>in the midst of nature</small></p> <div> <hr /></div> <p style="text-align: center;">It is almost impossible to get any closer to nature than this: Leitgeringer See is part of the Astener Moos wetland area, its shores enclosed by dense forests. Here, even on the hottest days of summer, you will find pleasant peace & quiet and relaxation. Your walk down to the swimming beach will take you through virgin nature, to a bathing experience very much like back in “the olden days”. So, treat yourself to this timeout and a small adventure next to this tranquil body of water. </p>
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  member_group_id0
  webcam_img(null)
  webcam_url(null)
  webcam_type(null)
  webcam_height(null)
  little_adventure(null)
  weather_lake_temp(null)
  photographer(null)
  employee(null)
  url_text(null)
  gmap
  published1
  Route(array)
  id1192
  hash230665f82f9dfbb4a94ce21463b86de3
  created2018-01-08 11:55:21
  updated2018-05-24 11:25:45
  modelContent
  foreign_key860
  base/en/region/lakes/leiteringer-see/
  aliaslead-in
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id1041
  lft1968
  rght1969
  route/en/region/lakes/leiteringer-see/lead-in
  1(array)
  id861
  hash88a64c0ddf2e5ac0e547a668785977ec
  created2018-01-08 11:55:56
  updated2018-01-08 11:55:56
  menu_id243
  position2
  typegallery
  statusactive
  titleBildergalerie
  layoutcol12
  language_id8
  article_content(null)
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  member_group_id0
  webcam_img(null)
  webcam_url(null)
  webcam_type(null)
  webcam_height(null)
  little_adventure(null)
  weather_lake_temp(null)
  photographer(null)
  employee(null)
  url_text(null)
  gmap
  published1
  Route(array)
  id1193
  hasha244abdf1cbb4f628c2be7a9688b1a60
  created2018-01-08 11:55:56
  updated2018-01-08 11:55:56
  modelContent
  foreign_key861
  base/en/region/lakes/leiteringer-see/
  aliasbildergalerie
  controllerFrontendContents.FrontendContents
  actiongallery
  parent_id1041
  lft1970
  rght1971
  route/en/region/lakes/leiteringer-see/bildergalerie
  2(array)
  id862
  hashebdd661476360726766701937d94ad05
  created2018-01-08 11:56:08
  updated2018-05-24 11:26:02
  menu_id243
  position3
  typearticle
  statusactive
  titleText 1
  layoutcol6
  language_id8
  article_content<h3>Facts about Leitgeringer See</h3> <p><strong>Geological Region:</strong> Bavarian Alpine Foothills</p> <p><strong>Tributaries: </strong>rivulets and groundwater</p> <p><strong>Outflow:</strong> Spöttlbach</p> <p><strong>Length: </strong>220 m</p> <p><strong>Width: </strong>650 m</p> <p><strong>Maximum Depth:</strong> 7 m</p> <p><strong>Area:</strong> 0.1 km²</p> <p><strong>Perimeter: </strong>2.1 km</p> <p><strong>Nature Sanctuary: </strong>yes</p> <p><strong>Handicapped Access:</strong> yes</p>
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  member_group_id0
  webcam_img(null)
  webcam_url(null)
  webcam_type(null)
  webcam_height(null)
  little_adventure(null)
  weather_lake_temp(null)
  photographer(null)
  employee(null)
  url_text(null)
  gmap
  published1
  Route(array)
  id1194
  hashb07e1112b5ec7433de48a520b13e72f6
  created2018-01-08 11:56:08
  updated2018-05-24 11:26:02
  modelContent
  foreign_key862
  base/en/region/lakes/leiteringer-see/
  aliastext-1
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id1041
  lft1972
  rght1973
  route/en/region/lakes/leiteringer-see/text-1
  3(array)
  id863
  hash1af14bcd8bb8478a6e9102bfd38abf55
  created2018-01-08 11:56:18
  updated2018-05-24 11:26:31
  menu_id243
  position4
  typearticle
  statusactive
  titleText 2
  layoutcol6
  language_id8
  article_content<h3>LAKESHORE BEACHES & WATER SPORTS</h3> <p>Leitgeringer See Swimming Beach and Seebauer Campgrounds with a private beach give bathers ready access to the lake. Motorboats are not permitted on Leitgeringer See, though a boat rental business does have stand-up paddle boards, pedal boats and rowing boats available.</p> <h3>CAMPGROUNDS & OTHER FACILITIES</h3> <p>Next to Leitgeringer See are the Seebauer Campgrounds as well as a swimming beach with playground, WCs & showers as well as parking.</p> <h3>FLORA & FAUNA</h3> <p>Leitgeringer See features irregular contours and numerous bays. On the western side of the lake, it is abutted by the Astener Moos which, in combination with the lake itself, creates a wetland area. The lakeshore is flanked by woodlands.</p>
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  member_group_id0
  webcam_img(null)
  webcam_url(null)
  webcam_type(null)
  webcam_height(null)
  little_adventure(null)
  weather_lake_temp(null)
  photographer(null)
  employee(null)
  url_text(null)
  gmap
  published1
  Route(array)
  id1195
  hash420af5072106952baa93c1b92a645f47
  created2018-01-08 11:56:18
  updated2018-05-24 11:26:31
  modelContent
  foreign_key863
  base/en/region/lakes/leiteringer-see/
  aliastext-2
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id1041
  lft1974
  rght1975
  route/en/region/lakes/leiteringer-see/text-2
- $request->data(empty)
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Menu(empty)
  Parent(empty)
  HeaderImagesMedia(empty)
  MediaEntity(empty)
  Seo(empty)
  ImageMedia(empty)
  HeaderImage(empty)
  Teaser(empty)
  Content(empty)
  ArticleContentMedia(empty)
  GalleryMedia(empty)
  FileUpload(empty)
  TagsTag(empty)
  TagEntity(empty)
  FlagUpload(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7SocialMedia
  8GMap
  9Embed
  10Layout
  11CookieBar
  12Number
  13SimpleGraph
  14DebugTimer
  15Toolbar
  16Session
  17Js
  18HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.5.38
User	u3493938585
Home	/var/www/vhosts/waginger-see.de
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	Wyr1ETHlz6jXT-sR9fFGYwAAAAE
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	Wyr1ETHlz6jXT-sR9fFGYwAAAAE
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	Wyr1ETHlz6jXT-sR9fFGYwAAAAE
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Https	on
Proxy-nokeepalive	1
Http Host	www.waginger-see.de
Http X Real Ip	54.196.42.146
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http Accept Encoding	x-gzip, gzip, deflate
Http User Agent	CCBot/2.0 (http://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.waginger-see.de
Server Addr	85.236.63.140
Server Port	443
Remote Addr	54.196.42.146
Document Root	/var/www/vhosts/waginger-see.de/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/waginger-see.de/httpdocs
Server Admin	b.plappert@makrohaus.de
Script Filename	/var/www/vhosts/waginger-see.de/httpdocs/webroot/index.php
Remote Port	40240
Redirect Url	/webroot/en/region/lakes/leiteringer-see
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/en/region/lakes/leiteringer-see
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1529541905.342
Request Time	1529541905

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.5/share/pear
- 2-> /var/www/vhosts/waginger-see.de/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  2APP/contrance/Vendor/Cake/lib/Cake/Network/Http/HttpSocket.php
  3APP/contrance/Vendor/Cake/lib/Cake/Network/CakeSocket.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  FrontendMenus(array)
  Controller(array)
  0FrontendMenus/Controller/FrontendMenusController.php
  1FrontendMenus/Controller/FrontendMenusAppController.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  FrontendWorldWeatherOnline(array)
  Component(array)
  0FrontendWorldWeatherOnline/Controller/Component/WorldWeatherOnlineComponent.php
  HeaderImages(array)
  Behavior(array)
  0HeaderImages/Model/Behavior/HeaderImageBehavior.php
  Model(array)
  0HeaderImages/Model/HeaderImage.php
  1HeaderImages/Model/HeaderImagesAppModel.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
====

Leitgeringer See

Facts about Leitgeringer See

LAKESHORE BEACHES & WATER SPORTS

CAMPGROUNDS & OTHER FACILITIES

FLORA & FAUNA

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 53 ms Total Queries: 115 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 53 ms
Total Queries: 115 queries