5* Chalets bei Salzburg

in Ainring im Berchtesgadener Land, 5km vor Salzburg
Chalets mit eigenem Whirlpool, Sauna und allem Komfort, Frühstück ins Chalet serviert.
Jedes der Chalets steht in einem eigenen, eingezäunten und blickgeschützten Garten!

Ein herzliches Grüß Gott in Bayerns schönstem Chaletdorf

Den Alltag hinter sich zu lassen - genau dafür sind die Bayern-Chalets in einer bestechenden Ruhelage gemacht.

Urlaub in Privatsphäre, keine Etikette, keine Zwänge, keine fixen Essenszeiten, einfach in den Tag hineinleben - das ist die Devise der Bayern-Chalets.

Ungestört igeln sich unsere Gäste in ihrem gemütlichen Urlaubszuhause ein oder nutzen die zahlreichen Freizeitmöglichkeiten in der Umgebung der Chalets.
Wer am liebsten sein Chalet gar nicht verlassen möchte, heizt sich im Haus seine ganz private Zirbenholzsauna ein und "sprudelt" im ganzjährig mit 36° beheizten Außenwhirlpool des Chalets.

Die 3.000qm große Wellnessoase Wellness und Spa "Bergerbad" inmitten des Chaletdorfes mit Saunen, Außensaunen, Ruheräumen, Tauchbecken, Kneipp-Weg und zwei ganzjährig beheizten Außenpools nutzen Sie nach Herzenslust kostenfrei.
Massagen, Anwendungen und Kosmetikbehandlungen laden zur Wellnessauszeit ein.

Ainring im Rupertiwinkl liegt nur 5km von der Landesgrenze zu Salzburg und dem Salzburger Land entfernt zwischen Bad Reichenhall und Freilassing im bayerischen Voralpenland.
Die Chalets stehen frei im Grünen mit Blick nach Salzburg und in die freie Natur.

Die Bayern-Chalets sind das ideale Urlaubsdomizil für einen romantischen Chaleturlaub zu zweit, für einen Kurzurlaub für Verliebte, als Verwöhnwochenende, für einen Familien-Chaleturlaub, Chalets mit Wellness, Chalets mit Whirlpool oder für Wellness für Verliebte im schönen Oberbayern.

Jedes der Chalets verfügt über eine geschützte Privatsphäre im eigenen eingezäunten und nicht einsehbaren privaten Garten. Ideal auch für einen Urlaub mit Hund. Ihr Haustier kann sich im Garten mit mind. 300qm frei bewegen. In der Nähe Ihres Chalets finden Sie wunderbare Wanderwege und unzählige Freizeitmöglichkeiten.

Ihr Verwöhn-Frühstück servieren wir Ihnen morgens zur gewünschten Uhrzeit in Ihr Chalet, freuen Sie sich über einen reichlich gedeckten Frühstückstisch.

Täglich am Nachmittag verwöhnen wir Sie kostenlos mit einer bayerischen Brotzeit und hausgemachtem Kuchen im Chalet. Das tägliche Verwöhn-Frühstück, die Brotzeit und der Kuchen am Nachmittag sind in den Preisen inklusive!

Im Preis enthalten ist auch die tägliche Reinigung des Chalets.

Hier finden Sie eine Übersicht der einzelnen Chalet-Typen als pdf-Datei:
Übersicht Chalet-Typen577 KB

Das Besondere an den Bayern-Chalets
ist die idyllische Lage frei im Grünen und die einzigartige Privatsphäre. Jedes Chalet steht in einem privaten und nicht einsehbaren Garten.

Verbringen Sie einen erholsamen Urlaub in unvergleichbarer Privatspähre in Ihrem eigenen Luxus - Ferienhaus

Familie Berger mit Team

Wellness-Pauschale

Wellness-Pauschale
3 Übern. inkl. Massage, Wellnessanwendungen und Abendessen im Chalet

565,- EUR

pro Person für 3 Nächte

Romantik-Pauschale

Romantik-Pauschale

2 Übern. mit Abendessen im Chalet, Candle-Light-Dinner, Lagerfeuerabend

448,- EUR

pro Person für 2 Nächte

Kuscheltage

Kuscheltage im romantischen Chalet

2 Nächte ab € 375,- p.P.
inkl. Lagerfeuerabend am Chalet, Massage....

€ 375,-

für 2 Nächte

Top-Angebot

3 Nächte inkl. Frühstück und Nachmittagsbrotzeit ins Chalet serviert
ab € 398,- p.P.

€ 398,-

p. Pers. für 3 Nächte

100% Weiterempfehlung bei Holidaycheck!

Herzlichen Dank!
...für die tolle Bewertung unserer Gäste.

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  01
- ids(array)
  Menu1
  Content(null)
  Language1
- route(array)
  id2
  hash42e36a7387ce3817e8fea463ca4beb7e
  created2016-11-16 13:53:12
  updated2018-06-28 09:29:51
  modelMenu
  foreign_key1
  base/
  aliaschaletdorf-berchtesgadener-land
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id1
  lft2
  rght9
  route/chaletdorf-berchtesgadener-land
- 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: 16 ms
Total Queries: 109 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`))) = '/chaletdorf-berchtesgadener-land' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 2 AND `Route`.`rght` >= 9 ORDER BY `Route`.`lft` asc	2	2	0
SELECT `Language`.`langid` FROM `bayern_chalets`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	1
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`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` = 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 `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` = (1) ORDER BY `Content`.`position` asc	3	3	1	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 34 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` = 35 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` = 222 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` = '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, 399, 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` = 1 LIMIT 1	1	1	0
SELECT `Menu`.`phone` FROM `bayern_chalets`.`menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1	1	1	4	maybe slow
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` = 1	5	5	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` = 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`, `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` <= 1 AND `Menu`.`rght` >= 2 ORDER BY `Menu`.`lft` 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`.`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`))) = '/chaletdorf-berchtesgadener-land/text' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 3 AND `Route`.`rght` >= 4 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` = 34 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` = 58 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` = 400 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` = (400) 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` = 400 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	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` = 39 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` = (39) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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` = 39 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	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` = 404 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` = (404) 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` = 404 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	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` = 405 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` = (405) 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` = 405 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	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` = 16 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` = (16) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	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` = 16 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	3	3	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` = 4 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` = (4) 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` = 4 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	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`))) = '/chaletdorf-berchtesgadener-land/galerie' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 5 AND `Route`.`rght` >= 6 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` = 35 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` = 59 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` = 35 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	42	42	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 (406, 5, 330, 411, 329, 7, 331, 233, 230, 9, 229, 10, 12, 13, 231, 16, 18, 228, 21, 22, 203, 24, 27, 32, 202, 232, 227, 35, 46, 47, 55, 59, 64, 65, 207, 67, 80, 157, 204, 205, 206) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	383	383	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`))) = '/chaletdorf-berchtesgadener-land/pauschalen' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `bayern_chalets`.`routes` AS `Route` WHERE `Route`.`lft` <= 7 AND `Route`.`rght` >= 8 ORDER BY `Route`.`lft` asc	3	3	0
SELECT `Offer`.`id`, `Offer`.`hash`, `Offer`.`created`, `Offer`.`updated`, `Offer`.`title`, `Offer`.`lft`, `Offer`.`rght`, `Offer`.`parent_id`, `Offer`.`status`, `Offer`.`title_sub`, `Offer`.`start_price`, `Offer`.`add_text`, `Offer`.`overlay_special`, `Offer`.`request_date`, `Offer`.`release`, `Offer`.`hide`, `Offer`.`detail_content`, `Offer`.`contact_email`, `Offer`.`contact_success`, `Offer`.`contact_error`, `Offer`.`valid_dates`, (NOW() BETWEEN COALESCE(`Offer`.`release`, NOW()) AND COALESCE(`Offer`.`hide`, NOW())) AS `Offer__published`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `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`.`offers` AS `Offer` LEFT JOIN `bayern_chalets`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Offer`.`id` AND `Route`.`model` = 'Offer') LEFT JOIN `bayern_chalets`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Offer`.`id` AND `Teaser`.`model` = 'Offer') WHERE `Offer`.`status` = 'active'	4	4	1	maybe slow
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` = 135 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` = (96) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 142 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` = (164) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `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` = 326 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` = (244) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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` = 334 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` = (5) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	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` IN (2, 3, 4, 5) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Offer' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	29	29	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 (163, 164, 329, 330, 231, 165, 72, 89, 166, 21, 303, 17, 331, 13, 345, 228, 343, 341, 234, 340, 270, 203, 285, 230, 32, 211) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	255	255	1
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	1	maybe slow
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	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` = 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	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` = 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 25.45 MB

Message	Memory use
Component initialization	6.81 MB
Controller action start	7.36 MB
Controller render start	10.03 MB
Component initialization #2	13.55 MB
Controller action start #2	13.67 MB
Controller render start #2	13.82 MB
Component initialization #3	14.49 MB
Controller action start #3	14.52 MB
Controller render start #3	16.20 MB
Component initialization #4	16.43 MB
Controller action start #4	16.46 MB
Controller render start #4	18.15 MB
Component initialization #5	19.11 MB
Controller action start #5	19.13 MB
Controller render start #5	19.27 MB
Component initialization #6	19.48 MB
Controller action start #6	19.51 MB
Controller render start #6	19.64 MB
View render complete	19.62 MB

Timers

Total Request Time: 753 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	129.98
Event: Controller.initialize	11.53
Event: Controller.startup	0.86
Controller action	39.05
Event: Controller.beforeRender	74.45
» Processing toolbar data	22.45
Rendering View	358.42
» Event: View.beforeRender	0.08
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	218.89
» » Event: Controller.initialize #2	0.82
» » Event: Controller.startup #2	0.37
» » Controller action #2	3.59
» » Event: Controller.beforeRender #2	10.55
» » » Processing toolbar data #2	10.32
Rendering View #2	0.00
» » » Event: View.beforeRender #2	0.07
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	21.09
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.59
» » » Event: View.afterRender	0.07
» » » Event: Controller.shutdown	0.05
» » » Event: Controller.initialize #3	0.72
» » » Event: Controller.startup #3	0.37
» » » Controller action #3	15.10
» » » Event: Controller.beforeRender #3	20.59
» » » » Processing toolbar data #3	20.32
Rendering View #3	0.00
» » » » Event: View.beforeRender #3	0.08
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/gallery.php	46.06
» » » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php #2	45.13
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.55
» » » » Event: View.afterRender #2	0.14
» » » » Event: Controller.shutdown #2	0.05
» » » » Event: Controller.initialize #4	0.66
» » » » Event: Controller.startup #4	0.36
» » » » Controller action #4	36.43
» » » » Event: Controller.beforeRender #4	35.89
» » » » » Processing toolbar data #4	35.61
Rendering View #4	0.00
» » » » » Event: View.beforeRender #4	0.08
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/offer_index.php	3.97
» » » » » Event: View.afterRender #3	0.06
» » » » » Event: Controller.shutdown #3	0.04
» » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #3	0.42
» » » » Event: View.afterRender #4	1.97
» » » » Event: View.beforeLayout	0.06
» » » » Rendering APP/View/Layouts/index.php	134.11
» » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	9.28
» » » » » Rendering APP/View/Elements/360modal.php	0.31
» » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/headerImage.php	2.13
» » » » » Rendering APP/View/Elements/newsindex.php	1.12
» » » » » Rendering APP/View/Elements/social-sharing.php	0.50
» » » » » Rendering APP/View/Elements/footer-links.php	104.87
» » » » » » Event: Controller.initialize #5	0.78
» » » » » » Event: Controller.startup #5	0.38
» » » » » » Controller action #5	5.14
» » » » » » Event: Controller.beforeRender #5	40.47
» » » » » » » Processing toolbar data #5	40.26
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.09
» » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php #2	49.41
» » » » » » » » Event: Controller.initialize #6	0.83
» » » » » » » » Event: Controller.startup #6	0.43
» » » » » » » » Controller action #6	3.88
» » » » » » » » Event: Controller.beforeRender #6	36.24
» » » » » » » » » Processing toolbar data #6	35.95
Rendering View #6	0.00
» » » » » » » » » Event: View.beforeRender #6	0.08
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.03
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.46
» » » » » » » » » Event: View.afterRender #5	0.07
» » » » » » » » » Event: Controller.shutdown #4	0.05
» » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #5	0.34
» » » » » » » » Event: View.afterRender #6	0.05
» » » » » » » » Event: Controller.shutdown #5	0.03
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
 Menu(array)
 id1
 hash62fc57b333508ba26402ec531e9759d4
 created2016-11-16 13:53:12
 updated2018-06-28 09:29:51
 parent_id(null)
 lft1
 rght2
 language_id1
 typecontent
 titleStartseite
 previous_urlhttp://www.bayern-chalets.de/de/chalet-dorf/
 url(null)
 target_blank(false)
 phone
 Seo(array)
 id1
 hash8451096414592aac5f4ac79796f92625
 created2016-11-16 13:53:12
 updated2018-06-28 09:29:53
 modelMenu
 foreign_key1
 titleLuxus Chalet im Berchtesgadener Land bei Salzburg
 descriptionIn Ainring im Berchtesgadener Land, nur 5 km zur Landesgrenze von Salzburg entfernt, steht das neue Chaletdorf „Bayern-Chalets“.
 author
 tw_creator
 fb_author
 robots3
 ImageMedia(empty)
 Content(array)
 0(array)
 id34
 hash96a5d93cdb8f53283a3cf71f688238cd
 created2016-11-25 11:35:00
 updated2018-06-28 09:37:37
 menu_id1
 position1
 typearticle
 statusactive
 titleText
 layoutcol12
 language_id1
 article_content<h1>5* Chalets bei Salzburg</h1> in Ainring im Berchtesgadener Land, 5km vor Salzburg Chalets mit eigenem Whirlpool, Sauna und allem Komfort, Frühstück ins Chalet serviert. Jedes der Chalets steht in einem eigenen, eingezäunten und blickgeschützten Garten! <h3>Ein herzliches Grüß Gott in Bayerns schönstem Chaletdorf</h3> <figure class="figure-responsive pull-right"> <div class="img-responsive" data-media-id="39" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> Den Alltag hinter sich zu lassen - genau dafür sind die Bayern-Chalets in einer bestechenden Ruhelage gemacht. Urlaub in Privatsphäre, keine Etikette, keine Zwänge, keine fixen Essenszeiten, einfach in den Tag hineinleben - das ist die Devise der Bayern-Chalets. Ungestört igeln sich unsere Gäste in ihrem gemütlichen Urlaubszuhause ein oder nutzen die zahlreichen Freizeitmöglichkeiten in der Umgebung der Chalets. Wer am liebsten sein Chalet gar nicht verlassen möchte, heizt sich im Haus seine ganz private Zirbenholzsauna ein und "sprudelt" im ganzjährig mit 36° beheizten Außenwhirlpool des Chalets. <figure class="figure-responsive pull-right"> <div class="img-responsive" data-media-id="404" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> Die 3.000qm große Wellnessoase Wellness und Spa "Bergerbad" inmitten des Chaletdorfes mit Saunen, Außensaunen, Ruheräumen, Tauchbecken, Kneipp-Weg und zwei ganzjährig beheizten Außenpools nutzen Sie nach Herzenslust kostenfrei. Massagen, Anwendungen und Kosmetikbehandlungen laden zur Wellnessauszeit ein. Ainring im Rupertiwinkl liegt nur 5km von der Landesgrenze zu Salzburg und dem Salzburger Land entfernt zwischen Bad Reichenhall und Freilassing im bayerischen Voralpenland. Die Chalets stehen frei im Grünen mit Blick nach Salzburg und in die freie Natur. Die Bayern-Chalets sind das ideale Urlaubsdomizil für einen romantischen Chaleturlaub zu zweit, für einen Kurzurlaub für Verliebte, als Verwöhnwochenende, für einen Familien-Chaleturlaub, Chalets mit Wellness, Chalets mit Whirlpool oder für Wellness für Verliebte im schönen Oberbayern. <figure class="figure-responsive pull-right"> <div class="img-responsive" data-media-id="405" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> Jedes der Chalets verfügt über eine geschützte Privatsphäre im eigenen eingezäunten und nicht einsehbaren privaten Garten. Ideal auch für einen Urlaub mit Hund. Ihr Haustier kann sich im Garten mit mind. 300qm frei bewegen. In der Nähe Ihres Chalets finden Sie wunderbare Wanderwege und unzählige Freizeitmöglichkeiten. Ihr Verwöhn-Frühstück servieren wir Ihnen morgens zur gewünschten Uhrzeit in Ihr Chalet, freuen Sie sich über einen reichlich gedeckten Frühstückstisch. Täglich am Nachmittag verwöhnen wir Sie kostenlos mit einer bayerischen Brotzeit und hausgemachtem Kuchen im Chalet. Das tägliche Verwöhn-Frühstück, die Brotzeit und der Kuchen am Nachmittag sind in den Preisen inklusive! Im Preis enthalten ist auch die tägliche Reinigung des Chalets. Hier finden Sie eine Übersicht der einzelnen Chalet-Typen als pdf-Datei: <figure class="figure-responsive pull-right"> <div class="img-responsive" data-media-id="16" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> <h3>Das Besondere an den Bayern-Chalets ist die idyllische Lage frei im Grünen und die einzigartige Privatsphäre. Jedes Chalet steht in einem privaten und nicht einsehbaren Garten.</h3> <figure class="figure-responsive pull-right"> <div class="img-responsive" data-media-id="4" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> Verbringen Sie einen erholsamen Urlaub in unvergleichbarer Privatspähre in Ihrem eigenen Luxus - Ferienhaus <h4>Familie Berger mit Team</h4>
 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)
 id67
 hashaff69e919bd030bf4d7667e89dff94b5
 created2016-11-25 11:35:00
 updated2018-06-28 09:37:37
 modelContent
 foreign_key34
 base/chaletdorf-berchtesgadener-land/
 aliastext
 controllerFrontendContents.FrontendContents
 actionarticle
 parent_id2
 lft3
 rght4
 route/chaletdorf-berchtesgadener-land/text
 1(array)
 id35
 hashae156e1519807f87ad1c249ca58cd458
 created2016-11-25 11:37:13
 updated2018-07-03 18:07:02
 menu_id1
 position2
 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)
 id68
 hash15000024f4971d97123c1a66630fc829
 created2016-11-25 11:37:13
 updated2018-07-03 18:07:02
 modelContent
 foreign_key35
 base/chaletdorf-berchtesgadener-land/
 aliasgalerie
 controllerFrontendContents.FrontendContents
 actiongallery
 parent_id2
 lft5
 rght6
 route/chaletdorf-berchtesgadener-land/galerie
 2(array)
 id222
 hashfa97fd87fd1ed76de9dd611dd06df893
 created2017-06-01 15:20:33
 updated2017-06-01 15:20:33
 menu_id1
 position3
 typeoffer_index
 statusactive
 titlePauschalen
 layoutcol12
 language_id1
 article_content(null)
 contact_content(null)
 contact_email(null)
 contact_success(null)
 contact_error(null)
 iframe_url(null)
 iframe_width(null)
 iframe_height(null)
 release(null)
 hide(null)
 gmap_lat(null)
 gmap_long(null)
 gmap_zoom(null)
 gmap_type(null)
 gmap_marker(null)
 video_type(null)
 video_url(null)
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 teaser_menu_id(null)
 teaser_external_url(null)
 teaser_external_target(null)
 member_group_id0
 checkbox_text(null)
 gmap
 published1
 Route(array)
 id351
 hash2be382900c11e3bdc0fa34fa98fa43cf
 created2017-06-01 15:20:33
 updated2017-06-01 15:20:33
 modelContent
 foreign_key222
 base/chaletdorf-berchtesgadener-land/
 aliaspauschalen
 controllerFrontendContents.FrontendContents
 actionoffer_index
 parent_id2
 lft7
 rght8
 route/chaletdorf-berchtesgadener-land/pauschalen
- $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	W1TDco9lxXGsaBRa6KoutgAAAAY
Redirect Redirect Script Url	/chaletdorf-berchtesgadener-land
Redirect Redirect Script Uri	https://www.bayern-chalets.de/chaletdorf-berchtesgadener-land
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	W1TDco9lxXGsaBRa6KoutgAAAAY
Redirect Script Url	/chaletdorf-berchtesgadener-land
Redirect Script Uri	https://www.bayern-chalets.de/chaletdorf-berchtesgadener-land
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	W1TDco9lxXGsaBRa6KoutgAAAAY
Script Url	/chaletdorf-berchtesgadener-land
Script Uri	https://www.bayern-chalets.de/chaletdorf-berchtesgadener-land
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.92.163.188
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http Accept Encoding	x-gzip, gzip, deflate
Http User Agent	CCBot/2.0 (http://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.bayern-chalets.de
Server Addr	85.236.63.140
Server Port	443
Remote Addr	54.92.163.188
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	35994
Redirect Url	/webroot/chaletdorf-berchtesgadener-land
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/chaletdorf-berchtesgadener-land
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1532281714.7092
Request Time	1532281714

====

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

5* Chalets bei Salzburg

Ein herzliches Grüß Gott in Bayerns schönstem Chaletdorf

Das Besondere an den Bayern-Chalets ist die idyllische Lage frei im Grünen und die einzigartige Privatsphäre. Jedes Chalet steht in einem privaten und nicht einsehbaren Garten.

Familie Berger mit Team

Wellness-Pauschale

Romantik-Pauschale

Kuscheltage

Top-Angebot

100% Weiterempfehlung bei Holidaycheck!

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 16 ms Total Queries: 109 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Das Besondere an den Bayern-Chalets
ist die idyllische Lage frei im Grünen und die einzigartige Privatsphäre. Jedes Chalet steht in einem privaten und nicht einsehbaren Garten.

Total Time: 16 ms
Total Queries: 109 queries