Wellness & Spa "Bergerbad"

Auf dem Areal der Bayern-Chalets befindet sich auch das Wellness und Spa "Bergerbad" - vom Chalet aus im Bademantel nur wenige Schritte entfernt. Hier können Sie in der 3.000qm großen Wellnessoase nach Herzenslust entspannen.

Sauna, Dampfbad und moderne Infrarotkabinen, Ruheräume mit Panoramasicht, Massagen, Bäder und Anwendungen laden Genießer zur Wellnessauszeit ein.

Im Außenbereich sind die Außensaunen, Tauchbecken und Whirlpools, sowie die ganzjährig beheizten Pools entspannende Orte. Im Bistro werden gesunde Gerichte, frische Salate, hasugemachte Smoothies, sowie erfrischende Getränke serviert.
Der Kneipp - Weg, die gemütlichen, überdachten Liegebereiche und zahlreiche Plätze für Sonnenanbeter in der Natur sind genau richtig, um den Alltag hinter sich zu lassen.

Wellnesshaus

gemütliches Bistro
Sauna, Dampfbad, Infrarotkabinen
Ruheräume mit Panoramasicht
Massagen, Anwendungen, Bäder, Kosmetikanwendungen

Außenbereich

Pool mit 30Grad (kein Nacktbereich) ganzjährig, beheizt
Kneipp - Weg
Whirlpools (ganzjährig, beheizt)
Tauchbecken zur Abkühlung nach dem Saunagang
zwei Saunen
Saunapool 30 Grad (Nacktbereich)
Liegebereiche

Hier finden Sie unsere Massageanwendungen und Bäder:
Massagen, Anwendungen, Bäder699 KB

Hier finden Sie unser Kosmetikprogramm:
Kosmetikbehandlungen722 KB

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentca40b5f22cf3d88f707fb259b2686ed4
  time1539832903
  countdown10
  languagede
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  022
- ids(array)
  Menu22
  Content(null)
  Language1
- route(array)
  id91
  hash6cf644cbfb563f2c658273fa87ae7924
  created2016-12-09 09:27:47
  updated2018-04-10 12:15:50
  modelMenu
  foreign_key22
  base/
  aliaswellness-spa
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id3
  lft59
  rght70
  route/wellness-spa
- 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: 20 ms
Total Queries: 104 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 `bayern_chalets`.`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`))) = '/wellness-spa' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 59 AND `Route`.`rght` >= 70 ORDER BY `Route`.`lft` asc	3	3	0
SELECT `Language`.`langid` FROM `bayern_chalets`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 22 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 82 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	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`.`checkbox_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 `bayern_chalets`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (22) ORDER BY `Content`.`position` asc	5	5	1	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 77 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 `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 78 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 `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 84 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 `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 81 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 `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 83 AND `Route`.`model` = 'Content'	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `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 `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 64 ORDER BY `Menu`.`lft` asc	30	30	0
SELECT *, Language.id FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `bayern_chalets`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 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` FROM `bayern_chalets`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (1)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1, 2, 3, 4, 5) 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 `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (402, 417, 325, 326, 332) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	35	35	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `HeaderImagesMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'news' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `bayern_chalets`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 13 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 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` FROM `bayern_chalets`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (13)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (17, 18, 19, 20, 21) 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `HeaderImagesMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 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`, `Menu`.`phone` FROM `bayern_chalets`.`menus` AS `Menu` WHERE `Menu`.`id` = 13	1	1	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`checkbox_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 `bayern_chalets`.`contents` AS `Content` WHERE `status` = 'active' AND `Content`.`menu_id` = (13) ORDER BY `Content`.`position` desc LIMIT 3	1	1	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 `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 6 AND `Route`.`model` = 'Content'	1	1	0
SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `bayern_chalets`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 6 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 27 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 `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (224) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	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`.`checkbox_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 `bayern_chalets`.`contents` AS `Content` WHERE `status` = 'active' AND `Content`.`menu_id` = (13) ORDER BY `Content`.`position` desc	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'offers' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `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 `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 75 AND `Menu`.`rght` < 76 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `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 `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 65 AND `Menu`.`rght` < 72 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT *, Language.id FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = '360tour' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `bayern_chalets`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 19 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 36 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 36 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` FROM `bayern_chalets`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (19)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (32, 33, 34, 35, 36) 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `HeaderImagesMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	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 `bayern_chalets`.`languages` AS `Language` LEFT JOIN `bayern_chalets`.`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 `bayern_chalets`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 22 LIMIT 1	1	1	0
SELECT `Menu`.`phone` FROM `bayern_chalets`.`menus` AS `Menu` WHERE `Menu`.`id` = 22 LIMIT 1	1	1	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `bayern_chalets`.`header_images` AS `HeaderImage` WHERE `model` = 'Menu' AND `foreign_key` = 22	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (77, 78, 79, 80, 81) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	5	5	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 `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (146, 147, 148, 149, 398) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	35	35	1
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone` FROM `bayern_chalets`.`menus` AS `Menu` WHERE `Menu`.`id` = 22 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `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 `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 22 AND `Menu`.`rght` >= 23 ORDER BY `Menu`.`lft` asc	2	2	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 `bayern_chalets`.`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`))) = '/wellness-spa/header' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 60 AND `Route`.`rght` >= 61 ORDER BY `Route`.`lft` asc	4	4	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`.`checkbox_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`contents` AS `Content` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 77 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 107 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 `bayern_chalets`.`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`))) = '/wellness-spa/artikel-1' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 62 AND `Route`.`rght` >= 63 ORDER BY `Route`.`lft` asc	4	4	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`.`checkbox_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`contents` AS `Content` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 78 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 108 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `bayern_chalets`.`media` AS `Media` WHERE `Media`.`id` = 76 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (76) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	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 `bayern_chalets`.`tags` AS `TagsTag` JOIN `bayern_chalets`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 76 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	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 `bayern_chalets`.`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`))) = '/wellness-spa/galerie' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 68 AND `Route`.`rght` >= 69 ORDER BY `Route`.`lft` asc	4	4	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`.`checkbox_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`contents` AS `Content` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 84 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 114 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `GalleryMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 84 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	29	29	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 `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (211, 80, 81, 212, 210, 99, 231, 77, 230, 233, 232, 79, 82, 83, 84, 209, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 208) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	238	238	3
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 `bayern_chalets`.`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`))) = '/wellness-spa/artikel-3' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 64 AND `Route`.`rght` >= 65 ORDER BY `Route`.`lft` asc	4	4	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`.`checkbox_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`contents` AS `Content` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 81 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 111 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 `bayern_chalets`.`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`))) = '/wellness-spa/artikel-5' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 66 AND `Route`.`rght` >= 67 ORDER BY `Route`.`lft` asc	4	4	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`.`checkbox_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`contents` AS `Content` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 83 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 113 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `bayern_chalets`.`media` AS `Media` WHERE `Media`.`id` = 394 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (394) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `bayern_chalets`.`tags` AS `TagsTag` JOIN `bayern_chalets`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 394 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	1
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `bayern_chalets`.`media` AS `Media` WHERE `Media`.`id` = 397 LIMIT 1	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `bayern_chalets`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (397) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `bayern_chalets`.`tags` AS `TagsTag` JOIN `bayern_chalets`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 397 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT *, Language.id FROM `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `bayern_chalets`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'data-protection' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `bayern_chalets`.`settings` AS `Setting` LEFT JOIN `bayern_chalets`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	25	25	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 `bayern_chalets`.`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) 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 `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `bayern_chalets`.`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 `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `bayern_chalets`.`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` = 'inquiry' 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 `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `bayern_chalets`.`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 `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `bayern_chalets`.`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` = 'offers' 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 `bayern_chalets`.`mount_points` AS `MountPoint` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `bayern_chalets`.`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` = 'contact' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `bayern_chalets`.`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`))) = '/kontaktblock' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 184 AND `Route`.`rght` >= 187 ORDER BY `Route`.`lft` asc	2	2	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`phone`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`menus` AS `Menu` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 17 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`member_group_id`, `Content`.`checkbox_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 `bayern_chalets`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (17) ORDER BY `Content`.`position` asc	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 `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 2 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 `bayern_chalets`.`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`))) = '/kontaktblock/kontakt-info' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 185 AND `Route`.`rght` >= 186 ORDER BY `Route`.`lft` asc	3	3	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`.`checkbox_text`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `bayern_chalets`.`contents` AS `Content` LEFT JOIN `bayern_chalets`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 2 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 `bayern_chalets`.`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 `bayern_chalets`.`media` AS `ImageMedia` JOIN `bayern_chalets`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 23 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 22.45 MB

Message	Memory use
Component initialization	6.79 MB
Controller action start	7.34 MB
Controller render start	10.04 MB
Component initialization #2	13.71 MB
Controller action start #2	13.83 MB
Controller render start #2	13.98 MB
Component initialization #3	14.22 MB
Controller action start #3	14.24 MB
Controller render start #3	14.36 MB
Component initialization #4	14.76 MB
Controller action start #4	14.79 MB
Controller render start #4	15.90 MB
Component initialization #5	16.12 MB
Controller action start #5	16.15 MB
Controller render start #5	16.27 MB
Component initialization #6	16.43 MB
Controller action start #6	16.46 MB
Controller render start #6	16.58 MB
Component initialization #7	17.50 MB
Controller action start #7	17.52 MB
Controller render start #7	17.66 MB
Component initialization #8	17.87 MB
Controller action start #8	17.90 MB
Controller render start #8	18.03 MB
View render complete	18.04 MB

Timers

Total Request Time: 593 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	89.62
Event: Controller.initialize	4.93
Event: Controller.startup	0.87
Controller action	37.90
Event: Controller.beforeRender	70.97
» Processing toolbar data	21.58
Rendering View	269.29
» Event: View.beforeRender	0.05
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	181.92
» » Event: Controller.initialize #2	0.63
» » Event: Controller.startup #2	0.34
» » Controller action #2	3.22
» » Event: Controller.beforeRender #2	14.52
» » » Processing toolbar data #2	14.36
Rendering View #2	0.00
» » » Event: View.beforeRender #2	0.06
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	2.06
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.41
» » » Event: View.afterRender	0.05
» » » Event: Controller.shutdown	0.03
» » » Event: Controller.initialize #3	0.60
» » » Event: Controller.startup #3	0.34
» » » Controller action #3	3.22
» » » Event: Controller.beforeRender #3	11.71
» » » » Processing toolbar data #3	11.55
Rendering View #3	0.00
» » » » Event: View.beforeRender #3	0.05
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	6.89
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.39
» » » » Event: View.afterRender #2	0.05
» » » » Event: Controller.shutdown #2	0.03
» » » » Event: Controller.initialize #4	0.58
» » » » Event: Controller.startup #4	0.33
» » » » Controller action #4	11.50
» » » » Event: Controller.beforeRender #4	16.93
» » » » » Processing toolbar data #4	16.76
Rendering View #4	0.00
» » » » » Event: View.beforeRender #4	0.06
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/gallery.php	30.47
» » » » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php #2	29.61
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.44
» » » » » Event: View.afterRender #3	0.05
» » » » » Event: Controller.shutdown #3	0.03
» » » » » Event: Controller.initialize #5	0.60
» » » » » Event: Controller.startup #5	0.34
» » » » » Controller action #5	3.21
» » » » » Event: Controller.beforeRender #5	16.03
» » » » » » Processing toolbar data #5	15.87
Rendering View #5	0.00
» » » » » » Event: View.beforeRender #5	0.06
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	0.89
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.39
» » » » » » Event: View.afterRender #4	0.05
» » » » » » Event: Controller.shutdown #4	0.03
» » » » » » Event: Controller.initialize #6	0.58
» » » » » » Event: Controller.startup #6	0.34
» » » » » » Controller action #6	3.19
» » » » » » Event: Controller.beforeRender #6	15.23
» » » » » » » Processing toolbar data #6	15.07
Rendering View #6	0.00
» » » » » » » Event: View.beforeRender #6	0.05
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #4	8.65
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.39
» » » » » » » Event: View.afterRender #5	0.05
» » » » » » » Event: Controller.shutdown #5	0.03
» » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #6	0.35
» » » » » » Event: View.afterRender #6	1.64
» » » » » » Event: View.beforeLayout	0.06
» » » » » » Rendering APP/View/Layouts/index.php	82.82
» » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	9.76
» » » » » » » Rendering APP/View/Elements/360modal.php	0.32
» » » » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/headerImage.php	1.88
» » » » » » » Rendering APP/View/Elements/social-sharing.php	0.54
» » » » » » » Rendering APP/View/Elements/footer-links.php	55.63
» » » » » » » » Event: Controller.initialize #7	0.70
» » » » » » » » Event: Controller.startup #7	0.39
» » » » » » » » Controller action #7	4.06
» » » » » » » » Event: Controller.beforeRender #7	16.90
» » » » » » » » » Processing toolbar data #7	16.74
Rendering View #7	0.00
» » » » » » » » » Event: View.beforeRender #7	0.06
» » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php #2	26.40
» » » » » » » » » » Event: Controller.initialize #8	0.74
» » » » » » » » » » Event: Controller.startup #8	0.44
» » » » » » » » » » Controller action #8	3.28
» » » » » » » » » » Event: Controller.beforeRender #8	16.14
» » » » » » » » » » » Processing toolbar data #8	15.96
Rendering View #8	0.00
» » » » » » » » » » » Event: View.beforeRender #8	0.06
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #5	0.83
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7	0.40
» » » » » » » » » » » Event: View.afterRender #7	0.05
» » » » » » » » » » » Event: Controller.shutdown #6	0.03
» » » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #8	0.32
» » » » » » » » » » Event: View.afterRender #8	0.05
» » » » » » » » » » Event: Controller.shutdown #7	0.02
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
 Menu(array)
 id22
 hash766a8e3c0b28f3a8187816f371394fb4
 created2016-12-09 09:27:47
 updated2018-04-10 12:15:50
 parent_id2
 lft22
 rght23
 language_id1
 typecontent
 titleWellness & Spa
 previous_urlhttp://www.bayern-chalets.de/de/wellness-und-spa/
 url(null)
 target_blank(false)
 phone
 Seo(array)
 id82
 hashe73d5619e7151b88bef88614d3585a07
 created2016-12-09 09:27:47
 updated2018-04-10 12:15:52
 modelMenu
 foreign_key22
 titleWellness und Spa im ''Bergerbad'' Ainring
 descriptionEntspannen Sie in der 3.000m² großen Wellnessoase nach Herzenslust! Dabei stehen Ihnen eine Sauna, ein Dampfbad, Massagen und vieles mehr zur Verfügung.
 author
 tw_creator
 fb_author
 robots3
 ImageMedia(empty)
 Content(array)
 0(array)
 id77
 hashcd86abfb1230ab78c26a56affed40d42
 created2016-12-09 12:50:50
 updated2016-12-09 12:54:17
 menu_id22
 position1
 typearticle
 statusactive
 titleHeader
 layoutcol12
 language_id1
 article_content<h1>Wellness & Spa "Bergerbad"</h1> 
 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
 checkbox_text(null)
 gmap
 published1
 Route(array)
 id116
 hashd5b60529a7ed33b212e83966f1fbeac7
 created2016-12-09 12:50:50
 updated2016-12-09 12:54:17
 modelContent
 foreign_key77
 base/wellness-spa/
 aliasheader
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id91
 lft60
 rght61
 route/wellness-spa/header
 1(array)
 id78
 hash8e35461bbc7ec49648d6fa717b9ac2e4
 created2016-12-09 12:51:40
 updated2018-01-25 11:38:51
 menu_id22
 position2
 typearticle
 statusactive
 titleArtikel 1
 layoutcol12
 language_id1
 article_contentAuf dem Areal der Bayern-Chalets befindet sich auch das Wellness und Spa "Bergerbad" - vom Chalet aus im Bademantel nur wenige Schritte entfernt. Hier können Sie in der 3.000qm großen Wellnessoase nach Herzenslust entspannen. <figure class="figure-responsive pull-right"> <div class="img-responsive" data-media-id="76" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> Sauna, Dampfbad und moderne Infrarotkabinen, Ruheräume mit Panoramasicht, Massagen, Bäder und Anwendungen laden Genießer zur Wellnessauszeit ein. Im Außenbereich sind die Außensaunen, Tauchbecken und Whirlpools, sowie die ganzjährig beheizten Pools entspannende Orte. Im Bistro werden gesunde Gerichte, frische Salate, hasugemachte Smoothies, sowie erfrischende Getränke serviert. Der Kneipp - Weg, die gemütlichen, überdachten Liegebereiche und zahlreiche Plätze für Sonnenanbeter in der Natur sind genau richtig, um den Alltag hinter sich zu lassen. 
 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
 checkbox_text(null)
 gmap
 published1
 Route(array)
 id117
 hash8135cc306f0a3888f47ebfa1649b53bb
 created2016-12-09 12:51:40
 updated2018-01-25 11:38:51
 modelContent
 foreign_key78
 base/wellness-spa/
 aliasartikel-1
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id91
 lft62
 rght63
 route/wellness-spa/artikel-1
 2(array)
 id84
 hash0aa76d5481200732d6d4ce028e830da8
 created2016-12-09 12:58:31
 updated2017-11-28 17:43:05
 menu_id22
 position3
 typegallery
 statusactive
 titleGalerie
 layoutcol6
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 member_group_id0
 checkbox_text(null)
 gmap
 published1
 Route(array)
 id123
 hash82d9449989d75cea566bd47c00046bbf
 created2016-12-09 12:58:31
 updated2017-11-28 17:43:05
 modelContent
 foreign_key84
 base/wellness-spa/
 aliasgalerie
 controllerFrontendContents.FrontendContents
 actiongallery
 parent_id91
 lft68
 rght69
 route/wellness-spa/galerie
 3(array)
 id81
 hash83ddd2a064dd4105908597fe2342c448
 created2016-12-09 12:55:31
 updated2017-01-23 12:30:02
 menu_id22
 position4
 typearticle
 statusactive
 titleArtikel 3
 layoutcol6
 language_id1
 article_content Wellnesshaus <ul> <li>gemütliches Bistro</li> <li>Sauna, Dampfbad, Infrarotkabinen</li> <li>Ruheräume mit Panoramasicht</li> <li>Massagen, Anwendungen, Bäder, Kosmetikanwendungen</li> </ul> Außenbereich <ul> <li>Pool mit 30Grad (kein Nacktbereich) ganzjährig, beheizt</li> <li>Kneipp - Weg</li> <li>Whirlpools (ganzjährig, beheizt)</li> <li>Tauchbecken zur Abkühlung nach dem Saunagang</li> <li>zwei Saunen</li> <li>Saunapool 30 Grad (Nacktbereich)</li> <li>Liegebereiche</li> </ul>
 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
 checkbox_text(null)
 gmap
 published1
 Route(array)
 id120
 hash141ce0fff4f988a0aece5bd6143141b1
 created2016-12-09 12:55:31
 updated2017-01-23 12:30:02
 modelContent
 foreign_key81
 base/wellness-spa/
 aliasartikel-3
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id91
 lft64
 rght65
 route/wellness-spa/artikel-3
 4(array)
 id83
 hashd2cedfb7d7f1a51f9b1cd28d0fbae03f
 created2016-12-09 12:57:24
 updated2018-03-07 09:35:54
 menu_id22
 position5
 typearticle
 statusactive
 titleArtikel 5
 layoutcol6
 language_id1
 article_contentHier finden Sie unsere Massageanwendungen und Bäder: Hier finden Sie unser Kosmetikprogramm: 
 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
 checkbox_text(null)
 gmap
 published1
 Route(array)
 id122
 hashe516ef53de4662695f758992ed57db4d
 created2016-12-09 12:57:24
 updated2018-03-07 09:35:54
 modelContent
 foreign_key83
 base/wellness-spa/
 aliasartikel-5
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id91
 lft66
 rght67
 route/wellness-spa/artikel-5
- $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)
 HousingType(empty)
 FileUpload(empty)
 FlagUpload(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8GMap
 9Embed
 10Layout
 11CookieBar
 12Number
 13SimpleGraph
 14DebugTimer
 15Toolbar
 16form
 17Js
 18HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.5.38
User	u309393929030
Home	/var/www/vhosts/bayern-chalets.de
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	W8fEB@Rr3-MqxV28pUta5QAAAAw
Redirect Redirect Script Url	/wellness-spa
Redirect Redirect Script Uri	https://www.bayern-chalets.de/wellness-spa
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	W8fEB@Rr3-MqxV28pUta5QAAAAw
Redirect Script Url	/wellness-spa
Redirect Script Uri	https://www.bayern-chalets.de/wellness-spa
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	W8fEB@Rr3-MqxV28pUta5QAAAAw
Script Url	/wellness-spa
Script Uri	https://www.bayern-chalets.de/wellness-spa
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Https	on
Proxy-nokeepalive	1
Http Host	www.bayern-chalets.de
Http X Real Ip	54.224.89.34
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http If Modified Since	Tue, 14 Aug 2018 06:47:21 UTC
Http Accept Encoding	gzip
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.bayern-chalets.de
Server Addr	85.236.63.140
Server Port	443
Remote Addr	54.224.89.34
Document Root	/var/www/vhosts/bayern-chalets.de/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/bayern-chalets.de/httpdocs
Server Admin	b.plappert@makrohaus.de
Script Filename	/var/www/vhosts/bayern-chalets.de/httpdocs/webroot/index.php
Remote Port	39576
Redirect Url	/webroot/wellness-spa
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/wellness-spa
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1539818503.8241
Request Time	1539818503

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.5/share/pear
- 2-> /var/www/vhosts/bayern-chalets.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
  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
  11BaseData/Model/Behavior/HabtmBehavior.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
  HeaderImages(array)
  Behavior(array)
  0HeaderImages/Model/Behavior/HeaderImageBehavior.php
  Model(array)
  0HeaderImages/Model/HeaderImage.php
  1HeaderImages/Model/HeaderImagesAppModel.php
  HousingTypes(array)
  Model(array)
  0HousingTypes/Model/HousingType.php
  1HousingTypes/Model/HousingTypesAppModel.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
====

Wellness & Spa "Bergerbad"

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 20 ms Total Queries: 104 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 20 ms
Total Queries: 104 queries