Sie befinden sich hier: » Startseite

Gourmet und Genuss

7 Tage
6 Übernachtungen
329 km
Reiseidee als PDF

Kulinarischer Hochgenuss im stilvollen Ambiente auf der Route der bayerischen Originale. Mitten im Herzen des Naturparks Nagelfluhkette in Oberstaufen startet diese Tour im Oberallgäu. Weiter geht es, vorbei an den Königsschlössern bei Füssen, durch die imposante Bergwelt der Zugspitz Region und des Tölzer Lands nach Rottach-Egern am Tegernsee. Hier trifft echte Tradition auf sportliche Vielfalt und eine große Dichte an Sterneküche. Ziel dieser Reise ist Aschau i.Chiemgau, einer der 100 Genussorte Bayerns, bietet Aschau besondere Köstlichkeiten – von der Schlosspraline zur Kampenwandsalami.

Tag 1 - 3 Oberstaufen

1 Oberstaufen

Wanderung durch den erlebnissreichen Naturpark Nagelfluhkette www.nagelfluhkette.info; der Hochgrat ist mit 1.834 Metern der höchste Gipfel in Oberstaufen – die Hochgratbahn bringt Sie zur Bergstation www.hochgrat.de; natürliche Küche genießen Sie im Landgasthof Rössle – beim Kräuterwirt dreht sich alles um eine der wichtigsten Zutat in der Küche www.roessle.net; Käsekunst seit 1906 bietet die Bergkäserei Steibis www.berg-kaese.de

Oberstaufen Tourismus

Oberstaufen

Hugo-von-Königsegg-Straße 8, 87534 Oberstaufen

Hotel Allgäu Sonne

Allgäu Sonne

Stießberg 1, 87534 Oberstaufen

Tag 3 - 5 Rottach-Egern

1 Rottach-Egern

Ein Traum Panorama auf den Tegernsee und die Alpen bietet der Wallberg, bequem erreichbar mit der Wallbergbahn www.wallbergbahn.de; in den Tegernsee Arkaden finden Sie eine einmalige Vielfalt der feinsten Produkte aus der Region www.tegernseearkaden.de; Stechen Sie in See: Idyllisch eingebettet liegt der Tegernsee inmitten der bayerischen Alpen www.seenschifffahrt.de

Tourist-Information Rottach-Egern

Rottach-Egern

Nördliche Hauptstraße 9, 83700 Rottach-Egern

Parkhotel Egerner Höfe

Aribostraße 19–26, 83700 Rottach-Egern

Tag 5 - 7 Aschau i. Chiemgau

1 Aschau i.Chiemgau

Neben 300 km Wanderwege lädt das Bankerldorf® mit seinen über 200 Themenbänken zum Verweilen und Genießen ein; Schloss Hohenaschau thront majestätisch über der Aschau i.Chiemgau und kann mit Führung besichtigt werden www.aschau.de; Exzellente Kreationen des mehrfach ausgezeichneten Sterne Kochs Heinz Winkler bietet genussvolle Facetten www.residenz-heinz-winkler.de in der Sie übernachten

Aschau im Chiemgau

Bankerldorf ® Aschau i.Chiemgau

Kampenwandstraße 38, 83229 Aschau i. Chiemgau

Residenz Heinz Winkler

Kirchplatz 1, 83229 Aschau i. Chiemgau

1

2

3

Weitere Reiseerlebnisse entlang der Strecke:

Kloster Ettal

Kaiser-Ludwig-Platz 1, 82488 Ettal

Bad Heilbrunn

Wörnerweg 4, 83670 Bad Heilbrunn

Lantenhammer Destillerie

Josef-Lantenhammer-Platz 1, 83734 Hausham

Cookie Einstellungen

Wir setzen automatisiert nur technisch notwendige Cookies, deren Daten von uns nicht weitergegeben werden und ausschließlich zur Bereitstellung der Funktionalität dieser Seite dienen.

Außerdem verwenden wir Cookies, die Ihr Verhalten beim Besuch der Webseiten messen, um das Interesse unserer Besucher besser kennen zu lernen. Wir erheben dabei nur pseudonyme Daten, eine Identifikation Ihrer Person erfolgt nicht.

Weitere Informationen finden Sie in unserer Datenschutzerklärung.

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

Cake Params
- pluginFrontendTravelIdeas
- controllerFrontendTravelIdeas
- actiontravel_idea
- named(empty)
- pass(array)
  07
- ids(array)
  Menu(null)
  Content(null)
  Language1
  TravelIdeaI18n7
- route(array)
  id1257
  hash4b22f438b47a0945806bd710e88048c1
  created2022-06-23 12:09:27
  updated2022-06-23 12:09:28
  modelTravelIdeaI18n
  foreign_key7
  base/de/
  aliasgourmet-und-genuss
  controllerFrontendTravelIdeas.FrontendTravelIdeas
  actiontravel_idea
  parent_id1
  lft1152
  rght1153
  route/de/gourmet-und-genuss
- 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: 0 ms
Total Queries: 100 queries

Query	Affected	Num. rows
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 `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/de/gourmet-und-genuss' LIMIT 1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`lft` <= 1152 AND `Route`.`rght` >= 1153 ORDER BY `Route`.`lft` asc	2	2
SELECT `Language`.`langid` FROM `deutsche_alpenstr2019`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `deutsche_alpenstr2019`.`settings` AS `Setting` LEFT JOIN `deutsche_alpenstr2019`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	24	24
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 `deutsche_alpenstr2019`.`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) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	0	0
SELECT `TravelIdeaI18n`.`id`, `TravelIdeaI18n`.`hash`, `TravelIdeaI18n`.`created`, `TravelIdeaI18n`.`updated`, `TravelIdeaI18n`.`language_id`, `TravelIdeaI18n`.`travel_idea_id`, `TravelIdeaI18n`.`title`, `TravelIdeaI18n`.`article_content`, `TravelIdea`.`id`, `TravelIdea`.`hash`, `TravelIdea`.`created`, `TravelIdea`.`updated`, `TravelIdea`.`status`, `TravelIdea`.`title`, `TravelIdea`.`duration`, `TravelIdea`.`overnight_stays`, `TravelIdea`.`distance`, `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`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`travel_idea_i18n` AS `TravelIdeaI18n` LEFT JOIN `deutsche_alpenstr2019`.`travel_ideas` AS `TravelIdea` ON (`TravelIdeaI18n`.`travel_idea_id` = `TravelIdea`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`TravelIdeaI18n`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `TravelIdeaI18n`.`id` AND `Route`.`model` = 'TravelIdeaI18n') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `TravelIdeaI18n`.`id` AND `Seo`.`model` = 'TravelIdeaI18n') WHERE `TravelIdeaI18n`.`id` = 7 LIMIT 1	1	1
SELECT `TravelExperience`.`id`, `TravelExperience`.`hash`, `TravelExperience`.`created`, `TravelExperience`.`updated`, `TravelExperience`.`status`, `TravelExperience`.`title`, `TravelExperience`.`point_id`, `TravelExperience`.`travel_idea_id` FROM `deutsche_alpenstr2019`.`travel_experiences` AS `TravelExperience` WHERE `TravelExperience`.`travel_idea_id` = (7)	3	3
SELECT `TravelExperienceI18n`.`id`, `TravelExperienceI18n`.`hash`, `TravelExperienceI18n`.`created`, `TravelExperienceI18n`.`updated`, `TravelExperienceI18n`.`language_id`, `TravelExperienceI18n`.`travel_experience_id`, `TravelExperienceI18n`.`title`, `TravelExperienceI18n`.`article_content` FROM `deutsche_alpenstr2019`.`travel_experience_i18n` AS `TravelExperienceI18n` WHERE `language_id` = '1' AND `TravelExperienceI18n`.`travel_experience_id` IN (15, 16, 17)	0	0
SELECT `TravelBooking`.`id`, `TravelBooking`.`hash`, `TravelBooking`.`created`, `TravelBooking`.`updated`, `TravelBooking`.`status`, `TravelBooking`.`travel_idea_id`, `TravelBooking`.`day_from`, `TravelBooking`.`day_to`, `TravelBooking`.`point_id_city`, `TravelBooking`.`point_id_hotel`, `TravelBooking`.`article`, `TravelBooking`.`title`, `TravelBooking`.`point` FROM `deutsche_alpenstr2019`.`travel_bookings` AS `TravelBooking` WHERE `TravelBooking`.`travel_idea_id` = (7)	3	3
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `GalleryMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'TravelIdea' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	4	4
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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (584, 588, 586, 589) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	28	28
SELECT `CardMedia`.`id`, `CardMedia`.`hash`, `CardMedia`.`created`, `CardMedia`.`updated`, `CardMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `CardMedia`.`id`) AS `CardMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `CardMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `CardMedia`.`id`) WHERE `MediaEntity`.`model` = 'TravelIdea' AND `MediaEntity`.`field` = 'card' ORDER BY `MediaEntity`.`pos` ASC	1	1
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (590) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7
SELECT `PointsTravelIdeas`.`id`, `PointsTravelIdeas`.`hash`, `PointsTravelIdeas`.`created`, `PointsTravelIdeas`.`updated`, `PointsTravelIdeas`.`status`, `PointsTravelIdeas`.`title`, `PointsTravelIdeas`.`content_type`, `PointsTravelIdeas`.`category`, `PointsTravelIdeas`.`teaser_title`, `PointsTravelIdeas`.`top_tip`, `PointsTravelIdeas`.`map_lat`, `PointsTravelIdeas`.`map_long`, `PointsTravelIdeas`.`street`, `PointsTravelIdeas`.`zip_code`, `PointsTravelIdeas`.`city`, `PointsTravelIdeas`.`phone`, `PointsTravelIdeas`.`website_url`, `PointsTravelIdeas`.`email`, `PointsTravelIdeas`.`region1`, `PointsTravelIdeas`.`region2`, `PointsTravelIdeas`.`region3`, `PointsTravelIdeas`.`booking_link`, `PointsTravelIdeas`.`gmap_url`, `PointsTravelIdeas`.`external_id`, `PointsTravelIdeas`.`gmap_zoom`, `PointsTravelIdeas`.`fax`, `PointsTravelIdeas`.`weather_widget_code`, `PointsTravelIdeas`.`hotels_gastronomy`, `PointsTravelIdeas`.`hotels_wellness`, `PointsTravelIdeas`.`hotels_parking`, `PointsTravelIdeas`.`hotels_car_rental`, `PointsTravelIdeas`.`hotels_oldtimer`, `PointsTravelIdeas`.`hotels_transfer`, `PointsTravelIdeas`.`hotels_car_charging_possibility`, `PointsTravelIdeas`.`hotels_distance_to_nearest_train_station`, `PointsTravelIdeas`.`hotels_bike_rental`, `PointsTravelIdeas`.`hotels_car_rental_other_de`, `PointsTravelIdeas`.`hotels_car_rental_other_it`, `PointsTravelIdeas`.`hotels_car_rental_other_nl`, `PointsTravelIdeas`.`hotels_car_rental_other_en`, `PointsTravelIdeas`.`hotels_emobil`, (CONCAT_WS (';',`PointsTravelIdeas`.`map_lat`,`PointsTravelIdeas`.`map_long`)) AS `PointsTravelIdeas__map`, `PointsTravelIdea`.`id`, `PointsTravelIdea`.`travel_idea_id`, `PointsTravelIdea`.`point_id`, `PointsTravelIdea`.`position` FROM `deutsche_alpenstr2019`.`points` AS `PointsTravelIdeas` JOIN `deutsche_alpenstr2019`.`points_travel_ideas` AS `PointsTravelIdea` ON (`PointsTravelIdea`.`travel_idea_id` = 7 AND `PointsTravelIdea`.`point_id` = `PointsTravelIdeas`.`id`) ORDER BY `PointsTravelIdea`.`position` ASC	3	3
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` WHERE `language_id` = '1' AND `PointI18n`.`point_id` IN (17, 60, 25)	3	3
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 17 AND `Route`.`model` = 'PointI18n'	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 `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 25 AND `Route`.`model` = 'PointI18n'	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 `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 60 AND `Route`.`model` = 'PointI18n'	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` IN (17, 60, 25) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	6	6
SELECT `PdfUpload`.`id`, `PdfUpload`.`hash`, `PdfUpload`.`created`, `PdfUpload`.`updated`, `PdfUpload`.`model`, `PdfUpload`.`field`, `PdfUpload`.`foreign_key`, `PdfUpload`.`alias`, `PdfUpload`.`thumbnail`, `PdfUpload`.`parent_id`, `PdfUpload`.`file`, `PdfUpload`.`size`, `PdfUpload`.`ext`, `PdfUpload`.`mime`, `PdfUpload`.`width`, `PdfUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `PdfUpload` WHERE `PdfUpload`.`model` = 'TravelIdeaI18n' AND `PdfUpload`.`field` = 'pdf' AND `PdfUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`PdfUpload`.`thumbnail`, -1), -1) DESC	1	1
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 115 AND `language_id` = 1 LIMIT 1	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (115) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 150 AND `language_id` = 1 LIMIT 1	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 88 AND `language_id` = 1 LIMIT 1	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (88) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 123 AND `language_id` = 1 LIMIT 1	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (123) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 90 AND `language_id` = 1 LIMIT 1	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (90) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 143 AND `language_id` = 1 LIMIT 1	1	1
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (143) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'de' LIMIT 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 156 ORDER BY `Menu`.`lft` asc	76	76
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`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	1	1
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (408) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`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
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`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
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'links' AND `Language`.`langid` = 'de' LIMIT 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 158 AND `Menu`.`rght` < 177 ORDER BY `Menu`.`lft` asc	9	9
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'de' LIMIT 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 124 AND `Menu`.`rght` < 155 ORDER BY `Menu`.`lft` asc	15	15
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 `deutsche_alpenstr2019`.`languages` AS `Language` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	4	4
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 `deutsche_alpenstr2019`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2, 3, 4) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	8	8
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`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`seo` AS `Seo` WHERE `Seo`.`model` = 'TravelIdeaI18n' AND `Seo`.`foreign_key` = 7 LIMIT 1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1199 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` IS NULL LIMIT 1	0	0
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'de' LIMIT 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2 LIMIT 1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` < NULL AND `Menu`.`rght` > NULL AND `Menu`.`parent_id` = 2 ORDER BY `Menu`.`lft` asc LIMIT 1	0	0
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social_share_links' AND `Language`.`langid` = 'de' LIMIT 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 179 LIMIT 1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 441 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 441 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 179 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 179 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 179	3	3
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 443 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 445 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 446 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 443 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 445 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 446 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 183, 184) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 183, 184) AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	3	3
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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (285, 287, 288) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social_site_links' AND `Language`.`langid` = 'de' LIMIT 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 180 LIMIT 1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 442 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 442 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 180 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 180 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 180	0	0
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_social_links' AND `Language`.`langid` = 'de' LIMIT 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 319 LIMIT 1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 916 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 686 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 319	2	2
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 917 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 918 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 687 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 688 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (320, 321) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (320, 321) AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC	2	2
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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (351, 352) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	2	2
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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`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
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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'it' 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
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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'nl' 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
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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`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
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1
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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1

Query Explain:

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

====

Timer

Memory

Peak Memory Use 24.68 MB

Message	Memory use
Component initialization	9.68 MB
Controller action start	10.65 MB
Controller render start	14.06 MB
View render complete	19.31 MB

Timers

Total Request Time: 467 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	109.97
Event: Controller.initialize	12.44
Event: Controller.startup	1.67
Controller action	86.51
Event: Controller.beforeRender	104.37
» Processing toolbar data	23.22
Rendering View	36.66
» Event: View.beforeRender	0.48
» Rendering APP/Plugin/FrontendTravelIdeas/View/FrontendTravelIdeas/travel_idea.php	7.83
» Rendering APP/Plugin/FrontendTravelIdeas/View/FrontendTravelIdeas/base.php	0.84
» Event: View.afterRender	0.18
» Event: View.beforeLayout	0.09
» Rendering APP/View/Layouts/index.php	23.73
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	3.64
» » Rendering APP/View/Elements/subpages-heading.php	1.31
» » Rendering APP/View/Elements/footer-links.php	2.04
» » Rendering APP/View/Elements/contact-partners.php	0.37
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  TravelIdeaI18n(array)
  id7
  hasha6d60b730fa9df30754e572968983621
  created2022-06-23 12:09:27
  updated2022-06-23 12:09:27
  language_id1
  travel_idea_id7
  titleGourmet und Genuss
  article_content<p>Kulinarischer Hochgenuss im stilvollen Ambiente auf der Route der bayerischen Originale. Mitten im Herzen des Naturparks Nagelfluhkette in <strong>Oberstaufen</strong> startet diese Tour im Oberallgäu. Weiter geht es, vorbei an den Königsschlössern bei Füssen, durch die imposante Bergwelt der Zugspitz Region und des Tölzer Lands nach <strong>Rottach-Egern</strong> am Tegernsee. Hier trifft echte Tradition auf sportliche Vielfalt und eine große Dichte an Sterneküche. Ziel dieser Reise ist <strong>Aschau i.Chiemgau</strong>, einer der 100 Genussorte Bayerns, bietet Aschau besondere Köstlichkeiten – von der Schlosspraline zur Kampenwandsalami.</p>
  TravelIdea(array)
  id7
  hash575bd28e15e1accaa49a3b479f4d3e8c
  created2022-06-23 12:01:51
  updated2022-06-24 11:05:02
  statusinactive
  titleGourmet und Genuss
  duration7
  overnight_stays6
  distance329
  TravelExperience(array)
  0(array)
  id15
  hash6c3d8b6dcd25e76d213a5069cc5eedaa
  created2022-06-23 12:10:00
  updated2022-06-23 12:10:00
  statusinactive
  titleOberstaufen
  point_id115
  travel_idea_id7
  TravelExperienceI18n(empty)
  1(array)
  id16
  hash33976f041f4333c1e0973cac2f6ceed9
  created2022-06-23 12:10:10
  updated2022-06-23 12:10:10
  statusinactive
  titleRottach-Egern
  point_id88
  travel_idea_id7
  TravelExperienceI18n(empty)
  2(array)
  id17
  hashaef65dd5875d6231b6c00068871638f5
  created2022-06-23 12:10:28
  updated2022-06-23 12:10:28
  statusinactive
  titleAschau i.Chiemgau
  point_id90
  travel_idea_id7
  TravelExperienceI18n(empty)
  TravelBooking(array)
  0(array)
  id15
  hash286f59176a377ae4e455aed11bd7d8c3
  created2022-06-23 12:11:37
  updated2022-06-23 12:11:37
  statusinactive
  travel_idea_id7
  day_from1
  day_to3
  point_id_city115
  point_id_hotel150
  article<p>Wanderung durch den erlebnissreichen Naturpark Nagelfluhkette www.nagelfluhkette.info; der Hochgrat ist mit 1.834 Metern der höchste Gipfel in Oberstaufen – die Hochgratbahn bringt Sie zur Bergstation www.hochgrat.de; natürliche Küche genießen Sie im Landgasthof Rössle – beim Kräuterwirt dreht sich alles um eine der wichtigsten Zutat in der Küche www.roessle.net; Käsekunst seit 1906 bietet die Bergkäserei Steibis www.berg-kaese.de</p>
  titleOberstaufen
  point1
  City(array)
  PointI18n(array)
  id115
  hash2a2ecaa08ef27a1f0732df8d688e7b61
  created2018-11-02 12:35:17
  updated2022-05-02 12:52:16
  language_id1
  point_id115
  countryDeutschland
  introduction_text
  detail_text<p><span>Das Wohlfühl- und Wanderparadies zeichnet sich durch seine herausragende landschaftliche Lage aus. So ist Oberstaufen bekannt für sein vielseitiges Wandergebiet – bei 300 Kilometer Wegenetz wird man allen Ansprüchen gerecht.</span></p> <p><span>Oberstaufen ist aber auch bekannt als moderne Einkaufsstadt sowie seine Spitzenhotellerie und Gastronomie. Falls Sie die Deutsche Alpenstraße in Lindau begonnen haben, wäre der Ort doch gerade richtig für den ersten Kaffeestopp!</span></p>
  teaser_text<p><span>Oberstaufen im Allgäu steht für die Kombination aus Natur-Erleben, Gesundheitsangeboten, Genuss und Lifestyle.</span></p>
  image_title_1Oberstaufen © TI Oberstaufen
  image_title_2
  image_title_3
  image_title_4
  image_title_5
  image_title_6
  image_title_7
  titleOberstaufen
  teaser_buttonweiterlesen
  previous_url(null)
  Point(array)
  id115
  hash4b62b8a1112a791dcf2aa077f62f7fb9
  created2018-11-02 12:35:17
  updated2022-06-21 12:17:22
  statusactive
  titleOberstaufen
  content_typecity
  categoryTourist-Informationen
  teaser_titleOberstaufen Tourismus
  top_tip(false)
  map_lat47.554352
  map_long10.020797
  streetHugo-von-Königsegg-Straße 8
  zip_code87534
  cityOberstaufen
  phone+49(0)8386 93000
  website_urlhttp://www.oberstaufen.de
  email
  region1Allgäu
  region2Allgäu Gipfelwelten
  region3
  booking_link
  gmap_urlhttps://goo.gl/maps/P5d8a84UjLBy93v9A
  external_id100006017
  gmap_zoom7
  fax
  weather_widget_code
  hotels_gastronomy0
  hotels_wellness0
  hotels_parking0
  hotels_car_rental0
  hotels_oldtimer0
  hotels_transfernone
  hotels_car_charging_possibility(false)
  hotels_distance_to_nearest_train_station(null)
  hotels_bike_rental0
  hotels_car_rental_other_de
  hotels_car_rental_other_it
  hotels_car_rental_other_nl
  hotels_car_rental_other_en
  hotels_emobil(false)
  map47.554352;10.020797
  TeaserImageUpload(array)
  0(array)
  id13904
  hashf9f9ccf6a9a3f28c413911c2c072fffb
  created2019-09-12 14:55:11
  updated2019-09-12 14:56:04
  modelPoint
  fieldteaser_image
  foreign_key115
  aliasoberstaufen-fgz-bahnhofstrasse-oberstaufen-tourismus.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5d7a40641cbf6.jpg
  size389742
  ext.jpg
  mimeimage/jpeg
  width1560
  height1040
  1(array)
  id13907
  hash069c4a2752ac8da25c8f7c2825f1d130
  created2019-09-12 14:56:04
  updated2019-09-12 14:56:04
  modelPoint
  fieldteaser_image
  foreign_key115
  aliasoberstaufen-fgz-bahnhofstrasse-oberstaufen-tourismus-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id13904
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d7a40641f362.jpg
  size96542
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Route(array)
  id674
  hashbc108f4d6997c5c45fd94e4a68edc82d
  created2019-07-09 10:35:39
  updated2022-05-02 12:52:16
  modelPointI18n
  foreign_key115
  base/de/
  aliasoberstaufen
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft1018
  rght1019
  route/de/oberstaufen
  Hotel(array)
  PointI18n(array)
  id267
  hashd8dd7aeb2d01979ba1ae397f7f373dc0
  created2020-03-30 21:37:06
  updated2022-04-25 12:24:23
  language_id1
  point_id150
  country
  introduction_text
  detail_text<p>An einem sonnigen Südhang oberhalb von Oberstaufen gelegen, bietet das 5* Sport- & Wellnesshotel Allgäu Sonne einen traumhaften Blick auf die Allgäuer Berge. Diesen genießen Sie auch von der wohl schönsten Hotelfitnesswelt Deutschlands. Täglich (Mo-Sa) werden bis zu 8 Sportkurse und eine geführte Wanderung geboten. Entspannung finden Sie in der Wellnesswelt mit zwei Innen- & einem Außenpool, Whirlpool, Dampfbad und Panoramasauna.</p> <p>Das kreative Küchenteam verwöhnt mit regionalen Gourmet-Menüs und jeden Abend gibt es Live-Musik & Tanz. Mit 65 Einzelzimmern von insgesamt 149 Zimmern & Suiten, ist die Allgäu Sonne auch ideal für Alleinreisende oder Freundesgruppen.</p>
  teaser_text<p>Oberstaufen</p> <p>Tel. +49 (0)8386 702 0</p> <p>www.allgaeu-sonne.de</p>
  image_title_1Hotel Allgäu Sonne Fitnesswelt
  image_title_2Hotel Allgäu Sonne Aussenansicht
  image_title_3Hotel Allgäu Sonne Superior Doppelzimmer
  image_title_4Hotel Allgäu Sonne Restaurant
  image_title_5Hotel Allgäu Sonne Innenpool
  image_title_6Hotel Allgäu Sonne Yoga
  image_title_7Hotel Allgäu Sonne Aussicht
  titleHotel Allgäu Sonne Oberstaufen
  teaser_buttonweiterlesen
  previous_url(null)
  Point(array)
  id150
  hash12a171aa3cd67f947cf76d2f92e82758
  created2020-03-30 21:28:08
  updated2021-08-02 16:15:07
  statusactive
  titleAllgäu Sonne
  content_typehotel
  category(null)
  teaser_titleHotel Allgäu Sonne
  top_tip(true)
  map_lat47.550827
  map_long10.013640
  streetStießberg 1
  zip_code87534
  cityOberstaufen
  phone+49 (0)8386 702 0
  website_urlhttp://www.allgaeu-sonne.de
  emailinfo@allgaeu-sonne.de
  region1Allgäu
  region2Allgäu Gipfelwelten
  region3
  booking_linkhttps://secure.hotelwebservice.com/reservation/fb/?arrival=2020-10-13&departure=2020-10-14&rooms=1&adults=1&children=0&lang=de&token=allgaeusonne&project=&utm_source=liverate_compare&utm_medium=referral
  gmap_urlhttps://goo.gl/maps/twShi5XJR5QEchy7A
  external_id(null)
  gmap_zoom7
  fax+49 (0)8386 702 7826
  weather_widget_code
  hotels_gastronomy15
  hotels_wellness501
  hotels_parking3
  hotels_car_rental0
  hotels_oldtimer4
  hotels_transferfree
  hotels_car_charging_possibility(true)
  hotels_distance_to_nearest_train_station1.500000
  hotels_bike_rental12
  hotels_car_rental_other_de
  hotels_car_rental_other_it
  hotels_car_rental_other_nl
  hotels_car_rental_other_en
  hotels_emobil(true)
  map47.550827;10.013640
  TeaserImageUpload(array)
  0(array)
  id14444
  hashc67843523de1c85854af1b33a31288b0
  created2020-03-30 21:31:54
  updated2020-03-30 21:33:04
  modelPoint
  fieldteaser_image
  foreign_key150
  aliashotel-allgaeu-sonne-fitnesswelt-daemmerung-1.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5e824970cd94c.jpg
  size924787
  ext.jpg
  mimeimage/jpeg
  width1620
  height1080
  1(array)
  id14445
  hashfe2800b62f893021cb1719550af2d208
  created2020-03-30 21:33:04
  updated2020-03-30 21:33:04
  modelPoint
  fieldteaser_image
  foreign_key150
  aliashotel-allgaeu-sonne-fitnesswelt-daemmerung-1-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id14444
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5e824970cfc68.jpg
  size64612
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Route(array)
  id809
  hash7510339d42e9336df802d343f8c6abda
  created2020-03-30 21:37:06
  updated2022-04-25 12:24:23
  modelPointI18n
  foreign_key267
  base/de/
  aliashotel-allgaeu-sonne-oberstaufen
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft1054
  rght1055
  route/de/hotel-allgaeu-sonne-oberstaufen
  1(array)
  id16
  hash1deb0295a4b4c915bd5b49006f25363b
  created2022-06-23 12:12:22
  updated2022-06-23 12:12:22
  statusinactive
  travel_idea_id7
  day_from3
  day_to5
  point_id_city88
  point_id_hotel123
  article<p>Ein Traum Panorama auf den Tegernsee und die Alpen bietet der Wallberg, bequem erreichbar mit der Wallbergbahn www.wallbergbahn.de; in den Tegernsee Arkaden finden Sie eine einmalige Vielfalt der feinsten Produkte aus der Region www.tegernseearkaden.de; Stechen Sie in See: Idyllisch eingebettet liegt der Tegernsee inmitten der bayerischen Alpen www.seenschifffahrt.de</p>
  titleRottach-Egern
  point1
  City(array)
  PointI18n(array)
  id88
  hash8db072654f78c8de02851bb0ac9b48eb
  created2018-11-02 12:34:44
  updated2022-04-25 15:49:58
  language_id1
  point_id88
  countryDeutschland
  introduction_text<h2>See- und Bergluft schnuppern am Tegernsee</h2> <p>Am Südufer des Tegernsees liegt die Gemeinde Rottach-Egern. Seeluft schnuppert man im Malerwinkel und der Egerner Bucht, Bergluft am Wallberg.</p>
  detail_text<p>Am Südufer des Tegernsees liegt die Gemeinde Rottach-Egern. Nirgendwo sonst gehen echte Tradition, sportliche Vielfalt und eine weltoffene Stimmung eine solch genussvolle Verbindung ein wie hier. Ob Sterneküche oder altbayrische Gasthäuser, Luxus-Hotels oder heimelige Gästehäuser, pulsierendes Leben oder Stille am See: In Rottach-Egern gibt es unzählige Möglichkeiten, in das unbeschwerte Urlaubsglück einzutauchen. In der Seestraße, Rottachs Flaniermeile, reihen sich erstklassige Hotels, Restaurants und Boutiquen aneinander. Exklusive Wellness- und Beauty-Angebote, darunter die erste Schönheitsfarm Europas, runden das Angebot ab.</p> <p>Die beiden Wahrzeichen des Ortes, der Malerwinkel in der Egerner Bucht, der schon Maler, Dichter und Komponisten inspirierte und der Tegernseer Hausberg, der 1.722 Meter hohe Wallberg, laden zum Spazieren und Wandern ein. Außerdem ist der Hausberg Startpunkt von Paraglidern, die die günstigen Winde am Tegernsee nutzen. Schlittenfahrer gelangen auf Deutschlands längster Naturrodelbahn, die mit einer Gondel erreichbar ist, ins Tal. Neben exklusiven, innovativen Angeboten ist die Kultur und Tradition im ehemaligen Fischer- und Bauerndorf noch tief verankert. Im Spätherbst findet alljährlich der Almabtrieb statt. Mehrmals im Jahr stehen Pferde im Mittelpunkt des Interesses. Am letzten Sonntag im August wird der Rosstag gefeiert, bei dem festlich geschmückte Kutschen, Rösser und Reiter durch den Ort ziehen, während alle zwei Jahre im Winter das traditionelle Pferdeschlittenrennen stattfindet.</p> <p>Die Region rings um den Tegernsee besticht im besonderen Maße durch eine kulinarische Vielfalt, die ihres Gleichen sucht: von traditionell und handgemacht bis hin zur erlesenen Spitzengastronomie. So schlägt seit über einer Dekade der ausgezeichnete 3-Sterne Koch Christian Jürgens als Küchenchef in der „Überfahrt“ kulinarisch Wellen. Weit über die Landesgrenzen kennt und schätzt man auch das Tegernseer Bier oder den Saibling direkt aus dem Tegernsee. Regionale, mehrfach ausgezeichnete Spezialitäten wie Käse, Fleisch und heimische Destillate kommen von den vielen Höfen, Produzenten und Almen rings um den See.</p>
  teaser_text<p>Vor der imposanten Kulisse des Wallbergs am Südufer des Tegernsees liegt Rottach-Egern – luxuriös und gemütlich, exklusiv und traditionell.</p>
  image_title_1Rottach-Egern © Der Tegernsee, Dietmar Denger
  image_title_2Wandern am Wallberg © Der Tegernsee, Hansi Heckmair
  image_title_3Wander Brotzeit © Der Tegernsee, Hansi Heckmair
  image_title_4Chillen am See © Alpenregion Tegernsee Schliersee Dietmar Denger
  image_title_5Malerwinkel © Alpenregion Tegernsee Schliersee
  image_title_6Überfahrer Rottach-Egern © Der Tegernsee, Dietmar Denger
  image_title_7Erfrischung im See © Alpenregion Tegernsee Schliersee Dietmar Denger
  titleRottach-Egern
  teaser_buttonweiterlesen
  previous_url(null)
  Point(array)
  id88
  hash8cd959f689ee5e84c9fa2007945df1b3
  created2018-11-02 12:34:44
  updated2022-06-21 12:34:42
  statusactive
  titleRottach-Egern
  content_typecity
  categoryTourist-Informationen
  teaser_titleTourist-Information Rottach-Egern
  top_tip(false)
  map_lat47.690235
  map_long11.770528
  streetNördliche Hauptstraße 9
  zip_code83700
  cityRottach-Egern
  phone+49 (0)8022 67 310 - 0
  website_urlhttps://www.tegernsee-schliersee.de/rottach-egern
  email
  region1Oberbayern
  region2Alpenregion Tegernsee Schliersee
  region3Tegernseer Tal Tourismus
  booking_link
  gmap_urlhttp://maps.google.com/maps?z=12&t=m&q=47.691269,11.770625
  external_id100021623
  gmap_zoom7
  fax
  weather_widget_code<div id="wcom-1d58ce4864796f52105933cdb4325f52" class="wcom-default w300x250" style="border: 1px solid #CCC; background-color: #FCFCFC; border-radius: 5px"><link rel="stylesheet" href="//cs3.wettercomassets.com/woys/5/css/w.css" media="all"><div class="wcom-city"><a style="color: #000" href="https://www.wetter.com/deutschland/rottach-egern/DE0009070.html" target="_blank" rel="nofollow" aria-label="Wetter Berlin" title="Wetter Rottach-Egern">Wetter Rottach-Egern</a></div><div id="wcom-1d58ce4864796f52105933cdb4325f52-weather"></div><script type="text/javascript" src="//cs3.wettercomassets.com/woys/5/js/w.js"></script><script type="text/javascript">_wcomWidget({id: 'wcom-1d58ce4864796f52105933cdb4325f52',location: 'DE0009070',format: '300x250',type: 'summary'});</script></div>
  hotels_gastronomy0
  hotels_wellness0
  hotels_parking0
  hotels_car_rental0
  hotels_oldtimer0
  hotels_transfernone
  hotels_car_charging_possibility(false)
  hotels_distance_to_nearest_train_station(null)
  hotels_bike_rental0
  hotels_car_rental_other_de
  hotels_car_rental_other_it
  hotels_car_rental_other_nl
  hotels_car_rental_other_en
  hotels_emobil(false)
  map47.690235;11.770528
  TeaserImageUpload(array)
  0(array)
  id14190
  hash15e9b350d8554c083213f8ec85eaf6d9
  created2020-03-22 22:02:41
  updated2020-03-22 22:02:45
  modelPoint
  fieldteaser_image
  foreign_key88
  aliasrottach-egern-sonnenuntergang-am-steg-alpenregiontegernseeschliersee-kopie.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5e77d27533ac9.jpg
  size229909
  ext.jpg
  mimeimage/jpeg
  width1400
  height931
  1(array)
  id14196
  hash3db3ecbde36a9c8dcd4c6796c92b836e
  created2020-03-22 22:02:45
  updated2020-03-22 22:02:45
  modelPoint
  fieldteaser_image
  foreign_key88
  aliasrottach-egern-sonnenuntergang-am-steg-alpenregiontegernseeschliersee-kopie-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id14190
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5e77d275362be.jpg
  size46342
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Route(array)
  id513
  hash3797abcd174b3c91821ae03716b4fb60
  created2019-04-29 12:34:38
  updated2022-04-25 15:49:58
  modelPointI18n
  foreign_key88
  base/de/
  aliasrottach-egern
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft816
  rght817
  route/de/rottach-egern
  Hotel(array)
  PointI18n(array)
  id123
  hash8811a504cfaa4f2826b53d3562147b36
  created2018-11-02 12:36:22
  updated2022-04-25 12:03:37
  language_id1
  point_id123
  countryDeutschland
  introduction_text
  detail_text<p>Das Fünf-Sterne-Superior Haus in Rottach-Egern erstrahlt in neuem Glanz – Heimatverbundenheit und echter Genuss werden hier großgeschrieben und als leiser Luxus gelebt. Das neue Gourmetrestaurant Dichter unter der Leitung von Sternekoch Thomas Kellermann verspricht exzellente Gaumenfreuden mit regionalem Fokus. Große Fensterfronten, die sich zum hoteleigenen Park hin öffnen und den Blick auf den Wallberg freigeben, sowie kleine, bepflanzte Höfe lassen den Innen- und Außenbereich miteinander verschmelzen und machen so die kulinarische Vision von Thomas Kellermann mit allen Sinnen erlebbar. Auch im neuen, 1500m² großen Mangfall Spa sorgen große Glasfronten sowie raumhohe, bepflanzte Glaskuben für eine enge Verbindung zur Natur. Der großzügige 20 Meter Pool mit Möglichkeit nach draußen zu schwimmen, vier Saunen, ein Dampfbad sowie eine Eis Lounge zur anschließenden Abkühlung laden zu Erholung und Entspannung ein</p>
  teaser_text<p>Rottach-Egern</p> <p>Tel: +49 (0) 8022 / 666 - 0</p> <p>www.egerner-hoefe.de</p>
  image_title_1Parkhotel Egerner Höfe
  image_title_2Parkhotel Egerner Höfe
  image_title_3Parkhotel Egerner Höfe
  image_title_4Parkhotel Egerner Höfe
  image_title_5Parkhotel Egerner Höfe
  image_title_6Parkhotel Egerner Höfe
  image_title_7
  titleParkhotel Egerner Höfe Rottach-Egern
  teaser_buttonweiterlesen
  previous_url(null)
  Point(array)
  id123
  hash098b77b10854912c8ee4fbe612393e52
  created2018-11-02 12:36:22
  updated2022-02-21 16:38:51
  statusactive
  titleParkhotel Egerner Höfe
  content_typehotel
  categoryHotel
  teaser_titleParkhotel Egerner Höfe
  top_tip(true)
  map_lat47.694313
  map_long11.753752
  streetAribostraße 19–26
  zip_code83700
  cityRottach-Egern
  phone+49 (0) 8022 / 666 - 0
  website_urlhttp://www.egerner-hoefe.de/
  emailinfo@egerner-hoefe.de
  region1Oberbayern
  region2Alpenregion Tegernsee Schliersee
  region3
  booking_linkhttps://www.egerner-hoefe.de/de/online-buchung/vsc.php?calendar_date_from=&calendar_date_to=&persons_adults=&submitbook=&step=roomtypes&vri_id=5985&c%5Bid_hotel%5D=3609
  gmap_urlhttps://g.page/egernerhoefe?share
  external_id25795
  gmap_zoom7
  fax
  weather_widget_code
  hotels_gastronomy15
  hotels_wellness499
  hotels_parking7
  hotels_car_rental0
  hotels_oldtimer6
  hotels_transferpaid
  hotels_car_charging_possibility(true)
  hotels_distance_to_nearest_train_station4.500000
  hotels_bike_rental0
  hotels_car_rental_other_de
  hotels_car_rental_other_it
  hotels_car_rental_other_nl
  hotels_car_rental_other_en
  hotels_emobil(false)
  map47.694313;11.753752
  TeaserImageUpload(array)
  0(array)
  id18565
  hash3a6e1211934108f7637bc1e3329e0a34
  created2022-02-21 16:38:49
  updated2022-02-21 16:38:51
  modelPoint
  fieldteaser_image
  foreign_key123
  alias1-2-aussenansicht-copy-1.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/6213b20bab8ca.jpg
  size618180
  ext.jpg
  mimeimage/jpeg
  width1920
  height1280
  1(array)
  id18566
  hashb190e694d19c36d159ef1a3d970a62ea
  created2022-02-21 16:38:52
  updated2022-02-21 16:38:52
  modelPoint
  fieldteaser_image
  foreign_key123
  alias1-2-aussenansicht-copy-1-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id18565
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/6213b20bae5fb.jpg
  size94329
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Route(array)
  id599
  hashb15b809f134be66b97bdc68bab981f93
  created2019-06-12 12:15:28
  updated2022-04-25 12:03:38
  modelPointI18n
  foreign_key123
  base/de/
  aliasparkhotel-egerner-hoefe-rottach-egern
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft890
  rght891
  route/de/parkhotel-egerner-hoefe-rottach-egern
  2(array)
  id17
  hash15e80281f731aebb2938c82c8b378cf2
  created2022-06-23 12:13:02
  updated2022-06-23 12:13:02
  statusinactive
  travel_idea_id7
  day_from5
  day_to7
  point_id_city90
  point_id_hotel143
  article<p>Neben 300 km Wanderwege lädt das Bankerldorf® mit seinen über 200 Themenbänken zum Verweilen und Genießen ein; Schloss Hohenaschau thront majestätisch über der Aschau i.Chiemgau und kann mit Führung besichtigt werden www.aschau.de; Exzellente Kreationen des mehrfach ausgezeichneten Sterne Kochs Heinz Winkler bietet genussvolle Facetten www.residenz-heinz-winkler.de in der Sie übernachten</p>
  titleAschau i.Chiemgau
  point1
  City(array)
  PointI18n(array)
  id90
  hashb993f7d446754be8d0087dd88a9cfe14
  created2018-11-02 12:34:47
  updated2022-04-25 15:52:07
  language_id1
  point_id90
  countryDeutschland
  introduction_text<h2>Bankerldorf ® am Fuße der Kampenwand</h2> <p>Zu Füßen des dreigezackten Gipfels der Kampenwand, dem Wahrzeichen der Region, liegt der traditionsreiche Luftkurort und Bankerldorf® Aschau i.Chiemgau.</p>
  detail_text<p>Wunderbar plätschernd schlängelt sich der Wildbach "Prien" durch das hügelige Land des gleichnamigen Tals - malerisch umrahmt vom Hausberg des Chiemgaus, der Kampenwand, deren dreigezackter Gipfel das Wahrzeichen der Region ist. Ihm zu Füßen liegt der traditionsreiche Luftkurort Aschau i.Chiemgau. Rund 300 Kilometer Wanderwege führen beschaulich durchs Tal oder hinauf zu den Gipfeln der Kampenwand, die auch mit der Seilbahn zu erklimmen sind. Für Familien mit Kindern empfiehlt sich besonders der westliche Höhenweg: Der „Boarische Entschleunigungsweg“ führt zu neun Stationen, an denen außergewöhnlich designte Themen-Bankerl zu kleinen Entspannungsübungen sowie zum Verweilen mit wunderbarem Blick auf das Tal, das Schloss Hohenaschau sowie die Kampenwand einladen. 200 weitere pfiffige, spezielle und ausgefallene Bankerl die von der Gemeinde sowie von Bürgern, Vereinen und Geschäften gestaltet wurden, finden sich zudem im Ortskern von Aschau i.Chiemgau und Sachrang. Das thronende Schloss Hohenaschau aus dem 11. Jahrhundert ist in den Sommermonaten für die Öffentlichkeit zu besichtigen.</p> <p>Entlang des Bachs "Prien" lässt es sich das ganze Jahr über zauberhaft wandern. Entlang der Ufer finden sich alte Holztüren, die den Blick auf Sehenswertes lenken, sowie Informationstafeln, die mit lustigen Illustrationen Wissenswertes zum Wildbach und seiner Entstehungsgeschichte berichten. Daneben bietet Aschau i.Chiemgau ganzjährig eine Vielfalt an sportlichen Möglichkeiten - vom Paragliding, Nordic Walking oder Scheibenschießen über den Hochseilgarten sowie das Natur-Frei- und Natur-Moorschwimmbad.</p> <p>Mit dem zur Gemeinde gehörenden Ort Sachrang begegnet dem Gast dazu ein Bilderbuch-Dorf, wie es schöner nicht sein könnte. Es wurde 2017 vom Deutschen Alpenverein zum „Bergsteigerdorf“ gekürt. Ein Pfeiler dieser Auszeichnung ist das Naturschutzgebiet Geigelstein, dieser wird auch der „Blumenberg des Chiemgaus“ genannt. Im Ort lebte einst der Müllner-Peter, der schon zu Lebzeiten eine Legende war. Das ihm errichtete Museum lädt zu einer Reise in längst vergangene Zeiten ein. Die Auswahl an Sehenswertem ist also ungemein groß: Das Priental erleben ist damit - einfach „A’Schau“.</p>
  teaser_text<p>Zu Füßen des dreigezackten Gipfels der Kampenwand, dem Wahrzeichen der Region, liegt der traditionsreiche Luftkurort und Bankerldorf® Aschau i.Chiemgau.</p>
  image_title_1Aschau mit Kampenwand_(c) TI Aschau i.Chiemgau
  image_title_2Aschauer Hausberg Kampenwand_(c) TI Aschau i.Chiemgau
  image_title_3Aschauer Pfarrkirche „Darstellung des Herrn“ (c) TI Aschau i.Chiemgau
  image_title_4Aschauer Pfarrkirche und Schloss Hohenaschau (c) TI Aschau i.Chiemgau
  image_title_5Bankerlweg (c) TI Aschau i.Chiemgau
  image_title_6Prientaler Flusslandschaft mit Schloss Hohenaschau (c) TI Aschau i.Chiemgau
  image_title_7Schloss Hohenaschau mit dem Fluss Prien (c) TI Aschau i.Chiemgau
  titleAschau i.Chiemgau
  teaser_buttonweiterlesen
  previous_url(null)
  Point(array)
  id90
  hash85184652606315bffcb8d3a57f94b4b9
  created2018-11-02 12:34:47
  updated2020-10-01 08:59:42
  statusactive
  titleBankerldorf ® Aschau i.Chiemgau
  content_typecity
  categoryTourist-Informationen
  teaser_titleAschau im Chiemgau
  top_tip(true)
  map_lat47.772877
  map_long12.324515
  streetKampenwandstraße 38
  zip_code83229
  cityAschau i. Chiemgau
  phone+49 8052 / 9049 - 37
  website_urlhttp://www.aschau.de
  emailinfo@aschau.de
  region1Oberbayern
  region2Chiemsee-Alpenland
  region3
  booking_link
  gmap_urlhttps://goo.gl/maps/4yWTksRUiaaqDypr6
  external_id100028859
  gmap_zoom7
  fax
  weather_widget_code<div id="wcom-5bc6f2457f1d32845d135589c94062e3" class="wcom-default w300x250" style="border: 1px solid #CCC; background-color: #FCFCFC; border-radius: 5px"><link rel="stylesheet" href="//cs3.wettercomassets.com/woys/5/css/w.css" media="all"><div class="wcom-city"><a style="color: #000" href="https://www.wetter.com/deutschland/aschau-i-chiemgau/aschau-im-chiemgau/DE0000386002.html" target="_blank" rel="nofollow" aria-label="Wetter Berlin" title="Wetter Aschau im Chiemgau">Wetter Aschau im Chiemgau</a></div><div id="wcom-5bc6f2457f1d32845d135589c94062e3-weather"></div><script type="text/javascript" src="//cs3.wettercomassets.com/woys/5/js/w.js"></script><script type="text/javascript">_wcomWidget({id: 'wcom-5bc6f2457f1d32845d135589c94062e3',location: 'DE0000386002',format: '300x250',type: 'summary'});</script></div>
  hotels_gastronomy(null)
  hotels_wellness(null)
  hotels_parking(null)
  hotels_car_rental(null)
  hotels_oldtimer(null)
  hotels_transfer(null)
  hotels_car_charging_possibility(null)
  hotels_distance_to_nearest_train_station(null)
  hotels_bike_rental(null)
  hotels_car_rental_other_de(null)
  hotels_car_rental_other_it(null)
  hotels_car_rental_other_nl(null)
  hotels_car_rental_other_en(null)
  hotels_emobil(null)
  map47.772877;12.324515
  TeaserImageUpload(array)
  0(array)
  id14247
  hash324b5f0b3099bdf600b4dc93fccaa856
  created2020-03-23 15:24:00
  updated2020-03-23 15:24:09
  modelPoint
  fieldteaser_image
  foreign_key90
  alias07-aschau-wenn-zu-kirchweih-der-himmel-brennt-foto-h-reiter-3.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5e78c68908f6b.jpg
  size471502
  ext.jpg
  mimeimage/jpeg
  width1440
  height1080
  1(array)
  id14248
  hashc51a50ad66972cf8b7c206a7c86dc4df
  created2020-03-23 15:24:09
  updated2020-03-23 15:24:09
  modelPoint
  fieldteaser_image
  foreign_key90
  alias07-aschau-wenn-zu-kirchweih-der-himmel-brennt-foto-h-reiter-3-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id14247
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5e78c6890a7ab.jpg
  size67074
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Route(array)
  id526
  hashbad687b304fbe737f7e662180e0fbc42
  created2019-04-29 16:24:33
  updated2022-04-25 15:52:07
  modelPointI18n
  foreign_key90
  base/de/
  aliasaschau-i-chiemgau
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft854
  rght855
  route/de/aschau-i-chiemgau
  Hotel(array)
  PointI18n(array)
  id252
  hash7bb871cc5585e657e0fb2d68585b9651
  created2020-03-24 21:05:49
  updated2022-04-25 12:20:18
  language_id1
  point_id143
  country
  introduction_text
  detail_text<p>Das traditionelle fünf Sterne Hotel Residenz Heinz Winkler liegt im Herzen des Chiemgau im kleinen Örtchen Aschau im Chiemgau. Nicht weit weg vom Chiemsee und direkt am Fuße der Kampenwand ist das Hotel, mit einer Entfernung von 2km, verkehrsgünstig an der A8 München-Salzburg gelegen.</p> <p>Das Haus verfügt über 29 Zimmer und Suiten, einige von Ihnen mit Balkon oder Gartenzugang, mit einer Größe von 25m² - 75m². Jedes unserer Zimmer ist mit Dusche/Bad, WC, TV und Telefon ausgestattet.</p> <p>Unser Laconium mit Sauna, Dampfbad und Pool mit Gegenstromanlage lässt Sie die Zeit vergessen und in unserem Beauty Vital Resort können Sie sich mit Massagen verwöhnen lassen.</p> <p>Das mit zwei Michelin-Sternen ausgezeichnete Restaurant ist das Herz des Hauses. Hier erleben unsere Gäste einzigartige Gastronomie auf höchstem Niveau.</p> <p>„Aschau is a Schau“ und auf jeden Fall einen Stopp wert. Und wenn Sie schon in der Gegend sind, dann schauen Sie doch bei uns rein.</p> <p>Die familiäre und freundliche Umgebung in unserem Haus hat bis jetzt noch jeden zum Bleiben verleitet.</p>
  teaser_text<p>Aschau i.Chiemgau</p> <p>Tel. +49(0)8052 17990</p> <p>www.residenz-heinz-winkler.de</p>
  image_title_1Residenz Heinz Winkler
  image_title_2Residenz Heinz Winkler
  image_title_3Residenz Heinz Winkler
  image_title_4Residenz Heinz Winkler
  image_title_5Residenz Heinz Winkler
  image_title_6Residenz Heinz Winkler
  image_title_7Residenz Heinz Winkler
  titleResidenz Heinz Winkler Aschau i.Chiemgau
  teaser_buttonweiterlesen
  previous_url(null)
  Point(array)
  id143
  hash07830dfc0215c2ca1cd89d7b2a063749
  created2020-03-23 14:44:53
  updated2021-06-21 11:50:57
  statusactive
  titleResidenz Heinz Winkler
  content_typehotel
  category(null)
  teaser_titleResidenz Heinz Winkler
  top_tip(false)
  map_lat47.779118
  map_long12.321541
  streetKirchplatz 1
  zip_code83229
  cityAschau i. Chiemgau
  phone+49(0)8052 17990
  website_urlhttp://www.residenz-heinz-winkler.de
  emailinfo@residenz-heinz-winkler.de
  region1Oberbayern
  region2Chiemsee-Alpenland
  region3
  booking_linkhttps://www.residenz-heinz-winkler.de/websLINE-ABM/Homepage/Booking/Index/de
  gmap_urlhttps://goo.gl/maps/w21sduKAhQBipZfG6
  external_id(null)
  gmap_zoom7
  fax
  weather_widget_code
  hotels_gastronomy13
  hotels_wellness241
  hotels_parking3
  hotels_car_rental0
  hotels_oldtimer0
  hotels_transferfree
  hotels_car_charging_possibility(true)
  hotels_distance_to_nearest_train_station0.500000
  hotels_bike_rental0
  hotels_car_rental_other_de
  hotels_car_rental_other_it
  hotels_car_rental_other_nl
  hotels_car_rental_other_en
  hotels_emobil(true)
  map47.779118;12.321541
  TeaserImageUpload(array)
  0(array)
  id14723
  hasha44f1f890364ddca4f68c9f816543c67
  created2020-04-23 13:14:48
  updated2020-04-23 13:14:55
  modelPoint
  fieldteaser_image
  foreign_key143
  aliasresidenz-heinz-winkler-gesamtansicht-1.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5ea178afb897d.jpg
  size463670
  ext.jpg
  mimeimage/jpeg
  width1537
  height1080
  1(array)
  id14724
  hasha6c9ecac3d484642f069793947f66fa1
  created2020-04-23 13:14:56
  updated2020-04-23 13:14:56
  modelPoint
  fieldteaser_image
  foreign_key143
  aliasresidenz-heinz-winkler-gesamtansicht-1-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id14723
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5ea178afbe353.jpg
  size104213
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Route(array)
  id793
  hash947e6d636ead20e8a72de8796c17814b
  created2020-03-24 21:05:49
  updated2022-04-25 12:20:18
  modelPointI18n
  foreign_key252
  base/de/
  aliasresidenz-heinz-winkler-aschau-i-chiemgau
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft1042
  rght1043
  route/de/residenz-heinz-winkler-aschau-i-chiemgau
  GalleryMedia(array)
  0(array)
  id584
  hash3de9743e10a7b5b5d6eb7a73bcb0d894
  created2022-06-23 11:56:25
  updated2022-06-23 11:56:25
  titleGourmet und Genuss
  cross_reference_count1
  MediaEntity(array)
  id12115
  pos1
  media_id584
  modelTravelIdea
  fieldgallery
  foreign_key7
  FileUpload(array)
  0(array)
  id19987
  hash4fc22947bebddb074154b1c20c7b6f5d
  created2022-06-23 11:56:00
  updated2022-06-23 11:56:25
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Media/File/62b438c9dee00.jpg
  size240164
  ext.jpg
  mimeimage/jpeg
  width1920
  height1277
  1(array)
  id19988
  hash25a014a8e6e027f4336ddc90283cb39c
  created2022-06-23 11:56:26
  updated2022-06-23 11:56:26
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy-thmediafileindex.jpg
  thumbnailth-media-file-index
  parent_id19987
  filewebroot/files/Media/File/ThMediaFileIndex/62b438c9e0e75.jpg
  size12688
  ext.jpg
  mimeimage/jpeg
  width150
  height99
  2(array)
  id19989
  hash3e6cc0e048e6cc23f53d1560c55705c2
  created2022-06-23 11:56:26
  updated2022-06-23 11:56:26
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy-ckeditorxs.jpg
  thumbnailckeditor_xs
  parent_id19987
  filewebroot/files/Media/File/CkeditorXs/62b438ca2bed4.jpg
  size4328
  ext.jpg
  mimeimage/jpeg
  width80
  height53
  3(array)
  id19990
  hashf663c0a663c0f15ee10f8edee3bafea7
  created2022-06-23 11:56:26
  updated2022-06-23 11:56:26
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy-ckeditorsm.jpg
  thumbnailckeditor_sm
  parent_id19987
  filewebroot/files/Media/File/CkeditorSm/62b438ca91754.jpg
  size12688
  ext.jpg
  mimeimage/jpeg
  width150
  height99
  4(array)
  id19991
  hash540c43d201db61c74d00bfc7499ad53b
  created2022-06-23 11:56:27
  updated2022-06-23 11:56:27
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy-ckeditormd.jpg
  thumbnailckeditor_md
  parent_id19987
  filewebroot/files/Media/File/CkeditorMd/62b438cad319b.jpg
  size20481
  ext.jpg
  mimeimage/jpeg
  width200
  height133
  5(array)
  id19992
  hash9236e383229c77376ce99cf2c0e6eda1
  created2022-06-23 11:56:27
  updated2022-06-23 11:56:27
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy-ckeditorlg.jpg
  thumbnailckeditor_lg
  parent_id19987
  filewebroot/files/Media/File/CkeditorLg/62b438cb2434c.jpg
  size41264
  ext.jpg
  mimeimage/jpeg
  width300
  height199
  6(array)
  id20102
  hashfee951fb22e9a091c7b7473aa6d20ae5
  created2022-06-24 11:05:02
  updated2022-06-24 11:05:02
  modelMedia
  fieldfile
  foreign_key584
  aliasalpenregiontegernseeschliersee-li-rottach-egern-steg-sonnenuntergang-paar-copy-thtravelideasgalleryresponsive.jpg
  thumbnailth-travel-ideas-gallery-responsive
  parent_id19987
  filewebroot/files/Media/File/ThTravelIdeasGalleryResponsive/62b57e3e50cf4.jpg
  size43603
  ext.jpg
  mimeimage/jpeg
  width720
  height444
  1(array)
  id588
  hash247930047fc44fbc106cc2092b041993
  created2022-06-23 11:58:58
  updated2022-06-23 11:58:58
  titleRössle Kräutergarten
  cross_reference_count1
  MediaEntity(array)
  id12116
  pos2
  media_id588
  modelTravelIdea
  fieldgallery
  foreign_key7
  FileUpload(array)
  0(array)
  id20011
  hash01e3d8583f312851e5f0e61728bbe8d0
  created2022-06-23 11:58:49
  updated2022-06-23 11:58:58
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Media/File/62b439628f150.jpg
  size242693
  ext.jpg
  mimeimage/jpeg
  width658
  height658
  1(array)
  id20012
  hash2bc973a4345e307735df525f99fa36bf
  created2022-06-23 11:58:58
  updated2022-06-23 11:58:58
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2-thmediafileindex.jpg
  thumbnailth-media-file-index
  parent_id20011
  filewebroot/files/Media/File/ThMediaFileIndex/62b4396290b5b.jpg
  size46278
  ext.jpg
  mimeimage/jpeg
  width150
  height150
  2(array)
  id20013
  hash1d53b63dce4752d79b417ae13f6cf006
  created2022-06-23 11:58:58
  updated2022-06-23 11:58:58
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2-ckeditorxs.jpg
  thumbnailckeditor_xs
  parent_id20011
  filewebroot/files/Media/File/CkeditorXs/62b439629f98c.jpg
  size13241
  ext.jpg
  mimeimage/jpeg
  width80
  height80
  3(array)
  id20014
  hashffe49c73557cde18830a2c9e20f53562
  created2022-06-23 11:58:58
  updated2022-06-23 11:58:58
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2-ckeditorsm.jpg
  thumbnailckeditor_sm
  parent_id20011
  filewebroot/files/Media/File/CkeditorSm/62b43962b0a1a.jpg
  size46278
  ext.jpg
  mimeimage/jpeg
  width150
  height150
  4(array)
  id20015
  hash25c822ce340483f4095697ab66d6a84f
  created2022-06-23 11:58:58
  updated2022-06-23 11:58:58
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2-ckeditormd.jpg
  thumbnailckeditor_md
  parent_id20011
  filewebroot/files/Media/File/CkeditorMd/62b43962bdf55.jpg
  size79346
  ext.jpg
  mimeimage/jpeg
  width200
  height200
  5(array)
  id20016
  hasha2b144d9499aafa6e7a6b2756b5f9d6d
  created2022-06-23 11:58:58
  updated2022-06-23 11:58:58
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2-ckeditorlg.jpg
  thumbnailckeditor_lg
  parent_id20011
  filewebroot/files/Media/File/CkeditorLg/62b43962cc76e.jpg
  size178038
  ext.jpg
  mimeimage/jpeg
  width300
  height300
  6(array)
  id20103
  hash6160c6ef2cdabf70e02d38338a3b78fc
  created2022-06-24 11:05:02
  updated2022-06-24 11:05:02
  modelMedia
  fieldfile
  foreign_key588
  aliasroessle-kraeutergarten-2-thtravelideasgalleryresponsive.jpg
  thumbnailth-travel-ideas-gallery-responsive
  parent_id20011
  filewebroot/files/Media/File/ThTravelIdeasGalleryResponsive/62b57e3e80828.jpg
  size143499
  ext.jpg
  mimeimage/jpeg
  width720
  height444
  2(array)
  id586
  hashb6e1572c6677eca184305d22a9fcc602
  created2022-06-23 11:58:01
  updated2022-06-23 11:58:01
  titleWerteproduzenten ATS
  cross_reference_count1
  MediaEntity(array)
  id12117
  pos3
  media_id586
  modelTravelIdea
  fieldgallery
  foreign_key7
  FileUpload(array)
  0(array)
  id19999
  hash527bfeb3ad6c04905dc9e1ecdd6e6084
  created2022-06-23 11:57:44
  updated2022-06-23 11:58:01
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Media/File/62b4392927d0d.jpg
  size178204
  ext.jpg
  mimeimage/jpeg
  width1915
  height1277
  1(array)
  id20000
  hash7e8bc9bee8614090f97cdaa1e5cbaf1b
  created2022-06-23 11:58:01
  updated2022-06-23 11:58:01
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy-thmediafileindex.jpg
  thumbnailth-media-file-index
  parent_id19999
  filewebroot/files/Media/File/ThMediaFileIndex/62b43929295be.jpg
  size14995
  ext.jpg
  mimeimage/jpeg
  width150
  height100
  2(array)
  id20001
  hash5b2d24287b272ed8a0f5ce11cacc6ff3
  created2022-06-23 11:58:01
  updated2022-06-23 11:58:01
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy-ckeditorxs.jpg
  thumbnailckeditor_xs
  parent_id19999
  filewebroot/files/Media/File/CkeditorXs/62b439296586c.jpg
  size5015
  ext.jpg
  mimeimage/jpeg
  width80
  height53
  3(array)
  id20002
  hashd317f4ea95dfe83390a62e6bab3407f0
  created2022-06-23 11:58:02
  updated2022-06-23 11:58:02
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy-ckeditorsm.jpg
  thumbnailckeditor_sm
  parent_id19999
  filewebroot/files/Media/File/CkeditorSm/62b43929bc34c.jpg
  size14995
  ext.jpg
  mimeimage/jpeg
  width150
  height100
  4(array)
  id20003
  hash4ce09740da91470de5f75babca5a6d21
  created2022-06-23 11:58:02
  updated2022-06-23 11:58:02
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy-ckeditormd.jpg
  thumbnailckeditor_md
  parent_id19999
  filewebroot/files/Media/File/CkeditorMd/62b4392a04672.jpg
  size24212
  ext.jpg
  mimeimage/jpeg
  width200
  height133
  5(array)
  id20004
  hashb6eb60032956936d08a4a6237e52dc87
  created2022-06-23 11:58:02
  updated2022-06-23 11:58:02
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy-ckeditorlg.jpg
  thumbnailckeditor_lg
  parent_id19999
  filewebroot/files/Media/File/CkeditorLg/62b4392a36de7.jpg
  size47610
  ext.jpg
  mimeimage/jpeg
  width300
  height200
  6(array)
  id20104
  hashde9483a581688acd48ed3b3f25756a5f
  created2022-06-24 11:05:02
  updated2022-06-24 11:05:02
  modelMedia
  fieldfile
  foreign_key586
  aliasti-alpenregiontegernseeschliersee-werteproduzenten-25-copy-thtravelideasgalleryresponsive.jpg
  thumbnailth-travel-ideas-gallery-responsive
  parent_id19999
  filewebroot/files/Media/File/ThTravelIdeasGalleryResponsive/62b57e3e9b96c.jpg
  size43628
  ext.jpg
  mimeimage/jpeg
  width720
  height444
  3(array)
  id589
  hash6b259db54e188a6a4101de62a10568b7
  created2022-06-23 11:59:35
  updated2022-06-23 11:59:35
  titleAschau Kampenwand
  cross_reference_count1
  MediaEntity(array)
  id12118
  pos4
  media_id589
  modelTravelIdea
  fieldgallery
  foreign_key7
  FileUpload(array)
  0(array)
  id20017
  hash2a6ee599ad417f04b652a52c60b98967
  created2022-06-23 11:59:20
  updated2022-06-23 11:59:35
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Media/File/62b4398750456.jpg
  size397529
  ext.jpg
  mimeimage/jpeg
  width1916
  height1277
  1(array)
  id20018
  hashc7be6a24cd7f8d58a65c76ece9679a28
  created2022-06-23 11:59:35
  updated2022-06-23 11:59:35
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy-thmediafileindex.jpg
  thumbnailth-media-file-index
  parent_id20017
  filewebroot/files/Media/File/ThMediaFileIndex/62b43987518ca.jpg
  size16828
  ext.jpg
  mimeimage/jpeg
  width150
  height99
  2(array)
  id20019
  hashdc9f436441b84b28384c2d1b4cd6fddb
  created2022-06-23 11:59:35
  updated2022-06-23 11:59:35
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy-ckeditorxs.jpg
  thumbnailckeditor_xs
  parent_id20017
  filewebroot/files/Media/File/CkeditorXs/62b4398781f86.jpg
  size5245
  ext.jpg
  mimeimage/jpeg
  width80
  height53
  3(array)
  id20020
  hash30e9943e3d1831f60a5e2916356e6907
  created2022-06-23 11:59:36
  updated2022-06-23 11:59:36
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy-ckeditorsm.jpg
  thumbnailckeditor_sm
  parent_id20017
  filewebroot/files/Media/File/CkeditorSm/62b43987cb72f.jpg
  size16828
  ext.jpg
  mimeimage/jpeg
  width150
  height99
  4(array)
  id20021
  hash887dad28f9c1607a46aa1cb92cb3acc3
  created2022-06-23 11:59:36
  updated2022-06-23 11:59:36
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy-ckeditormd.jpg
  thumbnailckeditor_md
  parent_id20017
  filewebroot/files/Media/File/CkeditorMd/62b439880729d.jpg
  size27991
  ext.jpg
  mimeimage/jpeg
  width200
  height133
  5(array)
  id20022
  hash1e0c746c1f69b81474d91996f2d91fc9
  created2022-06-23 11:59:36
  updated2022-06-23 11:59:36
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy-ckeditorlg.jpg
  thumbnailckeditor_lg
  parent_id20017
  filewebroot/files/Media/File/CkeditorLg/62b439882ce46.jpg
  size59086
  ext.jpg
  mimeimage/jpeg
  width300
  height199
  6(array)
  id20105
  hasha76fccf61a4dd0daa0416c73890f9171
  created2022-06-24 11:05:02
  updated2022-06-24 11:05:02
  modelMedia
  fieldfile
  foreign_key589
  aliasaschau-mit-kampenwand-ti-aschau-i-chiemgau-copy-thtravelideasgalleryresponsive.jpg
  thumbnailth-travel-ideas-gallery-responsive
  parent_id20017
  filewebroot/files/Media/File/ThTravelIdeasGalleryResponsive/62b57e3ec6580.jpg
  size72946
  ext.jpg
  mimeimage/jpeg
  width720
  height444
  CardMedia(array)
  0(array)
  id590
  hash6b6cef36f8b3020f61fc94f007d461a7
  created2022-06-23 12:01:14
  updated2022-06-23 12:01:14
  titleKarte 5
  cross_reference_count1
  MediaEntity(array)
  id12119
  pos1
  media_id590
  modelTravelIdea
  fieldcard
  foreign_key7
  FileUpload(array)
  0(array)
  id20023
  hash620bac3240916e7093633826166ade4e
  created2022-06-23 12:00:57
  updated2022-06-23 12:01:14
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Media/File/62b439eab8be0.jpg
  size36912
  ext.jpg
  mimeimage/jpeg
  width1154
  height199
  1(array)
  id20024
  hash50cbfbb5185cfffee88b29f9dd8f96ac
  created2022-06-23 12:01:14
  updated2022-06-23 12:01:14
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss-thmediafileindex.jpg
  thumbnailth-media-file-index
  parent_id20023
  filewebroot/files/Media/File/ThMediaFileIndex/62b439eabb1cd.jpg
  size3735
  ext.jpg
  mimeimage/jpeg
  width150
  height25
  2(array)
  id20025
  hashd7afb491d204461ebc2c5f33645991b0
  created2022-06-23 12:01:14
  updated2022-06-23 12:01:14
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss-ckeditorxs.jpg
  thumbnailckeditor_xs
  parent_id20023
  filewebroot/files/Media/File/CkeditorXs/62b439eac3f40.jpg
  size1435
  ext.jpg
  mimeimage/jpeg
  width80
  height13
  3(array)
  id20026
  hash8e67ee8c0adf5e6c82101607fb59c1c7
  created2022-06-23 12:01:14
  updated2022-06-23 12:01:14
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss-ckeditorsm.jpg
  thumbnailckeditor_sm
  parent_id20023
  filewebroot/files/Media/File/CkeditorSm/62b439eacf28e.jpg
  size3735
  ext.jpg
  mimeimage/jpeg
  width150
  height25
  4(array)
  id20027
  hash46d5c004da8453020c0e4b086115d29f
  created2022-06-23 12:01:14
  updated2022-06-23 12:01:14
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss-ckeditormd.jpg
  thumbnailckeditor_md
  parent_id20023
  filewebroot/files/Media/File/CkeditorMd/62b439ead786a.jpg
  size5959
  ext.jpg
  mimeimage/jpeg
  width200
  height34
  5(array)
  id20028
  hash0ad4caaa79be8018ebd574cf98611a43
  created2022-06-23 12:01:14
  updated2022-06-23 12:01:14
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss-ckeditorlg.jpg
  thumbnailckeditor_lg
  parent_id20023
  filewebroot/files/Media/File/CkeditorLg/62b439eae053a.jpg
  size11320
  ext.jpg
  mimeimage/jpeg
  width300
  height51
  6(array)
  id20106
  hashbf7df188b6fd23d00d5eaacafc338105
  created2022-06-24 11:05:03
  updated2022-06-24 11:05:03
  modelMedia
  fieldfile
  foreign_key590
  aliaskarte-gourmet-und-genuss-thtravelideascardresponsive.jpg
  thumbnailth-travel-ideas-card-responsive
  parent_id20023
  filewebroot/files/Media/File/ThTravelIdeasCardResponsive/62b57e3ef0ed1.jpg
  size26347
  ext.jpg
  mimeimage/jpeg
  width1140
  height196
  PointsTravelIdeas(array)
  0(array)
  id17
  hashaa4e0804860d86fe34d994a6f796da98
  created2018-11-02 12:33:47
  updated2021-03-18 11:34:53
  statusactive
  titleKloster Ettal
  content_typepoi
  categoryKlöster
  teaser_titleKloster Ettal
  top_tip(true)
  map_lat47.569572
  map_long11.094575
  streetKaiser-Ludwig-Platz 1
  zip_code82488
  cityEttal
  phone+49 8822 740
  website_urlhttp://www.kloster-ettal.de/
  email
  region1Oberbayern
  region2Zugspitz-Region
  region3Ammergauer Alpen
  booking_link
  gmap_urlhttps://goo.gl/maps/LyTYRWfi3GHZHu6L6
  external_id100028857
  gmap_zoom7
  fax
  weather_widget_code
  hotels_gastronomy(null)
  hotels_wellness(null)
  hotels_parking(null)
  hotels_car_rental(null)
  hotels_oldtimer(null)
  hotels_transfer(null)
  hotels_car_charging_possibility(null)
  hotels_distance_to_nearest_train_station(null)
  hotels_bike_rental(null)
  hotels_car_rental_other_de(null)
  hotels_car_rental_other_it(null)
  hotels_car_rental_other_nl(null)
  hotels_car_rental_other_en(null)
  hotels_emobil(null)
  map47.569572;11.094575
  PointsTravelIdea(array)
  id159
  travel_idea_id7
  point_id17
  position1
  PointI18n(array)
  0(array)
  id17
  hash4890691c854b0eee0a5126680bee6073
  created2018-11-02 12:33:47
  updated2022-04-28 17:08:10
  language_id1
  point_id17
  countryDeutschland
  introduction_text
  detail_text<p>Das Kloster Ettal mit seiner barocken Basilika ist eines der beliebtesten Ausflugsziele im Naturpark Ammergauer Alpen. Die Klosteranlage, in der 30 Benediktinermönche leben, besteht aber nicht nur aus der bekannten Klosterkirche. Neben einer Schule gehören das Klosterhotel „Ludwig der Bayer“, die Klosterbrauerei, die Liquermanufaktur sowie die Land- und Forstwirtschaft zu den Tätigkeitsfeldern der Ettaler Ordensgemeinschaft. Führungen durch Basilika, Liqueurmanufaktur oder Brauerei ermöglichen ganz besondere Einblicke in den klösterlichen Alltag und können mit einem Essen im Restaurant des Klosterhotels abgerundet werden.</p> <p>Die Führungen finden ganzjährig zu festen Terminen auch für Individualreisende statt. Die Teilnehmer erhalten hier einen Eindruck, was mit regionalen Produkten und liebevoller Handarbeit eigentlich alles möglich ist. Die Ettaler Kräuterliköre und die Ettaler Biere sind damals wie heute absolute Verkaufsschlager.</p>
  teaser_text
  image_title_1Kloster Ettal © Zugspitzregion Wolfgang Ehn
  image_title_2
  image_title_3
  image_title_4
  image_title_5
  image_title_6
  image_title_7
  titleKloster Ettal
  teaser_buttonweiterlesen
  previous_url(null)
  Route(array)
  id626
  hash84a7f75a7c1d55a89114e26b118cbee3
  created2019-07-09 09:38:59
  updated2022-04-28 17:08:10
  modelPointI18n
  foreign_key17
  base/de/
  aliaskloster-ettal
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft928
  rght929
  route/de/kloster-ettal
  TeaserImageUpload(array)
  0(array)
  id12127
  hash26884964ebb383d77b6dd9f5b30ce473
  created2018-11-02 12:33:47
  updated2018-11-02 12:33:47
  modelPoint
  fieldteaser_image
  foreign_key17
  aliaskloster-ettal.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5bdc361b97f3e.jpg
  size325264
  ext.jpg
  mimeimage/jpeg
  width1920
  height1080
  1(array)
  id13333
  hash256b307e9238ecb70340adf41bbac695
  created2019-07-02 17:22:00
  updated2019-07-02 17:22:00
  modelPoint
  fieldteaser_image
  foreign_key17
  aliaskloster-ettal-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id12127
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d1b7698aacba.jpg
  size68350
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  1(array)
  id60
  hasha72eeee03ea9e60add68edc5523c63dc
  created2018-11-02 12:34:26
  updated2020-03-22 17:00:53
  statusactive
  titleBad Heilbrunn
  content_typecity
  categoryTourist-Informationen
  teaser_titleBad Heilbrunn
  top_tip(false)
  map_lat47.748402
  map_long11.457710
  streetWörnerweg 4
  zip_code83670
  cityBad Heilbrunn
  phone+49 (0) 8046 323
  website_urlhttp://www.bad-heilbrunn.de
  email
  region1Oberbayern
  region2Tölzer Land
  region3
  booking_link
  gmap_urlhttps://goo.gl/maps/K8BJRiw1PKEn5SFz7
  external_id100028876
  gmap_zoom7
  fax
  weather_widget_code(null)
  hotels_gastronomy(null)
  hotels_wellness(null)
  hotels_parking(null)
  hotels_car_rental(null)
  hotels_oldtimer(null)
  hotels_transfer(null)
  hotels_car_charging_possibility(null)
  hotels_distance_to_nearest_train_station(null)
  hotels_bike_rental(null)
  hotels_car_rental_other_de(null)
  hotels_car_rental_other_it(null)
  hotels_car_rental_other_nl(null)
  hotels_car_rental_other_en(null)
  hotels_emobil(null)
  map47.748402;11.457710
  PointsTravelIdea(array)
  id160
  travel_idea_id7
  point_id60
  position2
  PointI18n(array)
  0(array)
  id60
  hasheb7f3a434b9b43c3f6ede505b598ed1e
  created2018-11-02 12:34:26
  updated2022-05-02 12:47:46
  language_id1
  point_id60
  countryDeutschland
  introduction_text
  detail_text<p>Eingeschmiegt in die idyllische Voralpenlandschaft hat sich der Heilklimatische Kurort Bad Heilbrunn seinen ursprünglichen Charakter bewahrt. Neben den schönen Wandermöglichkeiten im Heilklimapark Tölzer Land steht Bad Heilbrunn ganz im Zeichen der Kräuter.</p> <p>Der große Kräuter Erlebnis Park mit seinen etwa 400 verschiedenen Kräutern, Blühstauden und Gehölzen wird zu einem besonderen Erlebnis für alle Sinne. Verschieden Themenbeete laden ein, Wissenswertes zu erfahren, zu riechen, zu schmecken und zu fühlen. Im Kräuter-Bistro-Café kann man frische Kräuterküche gleich probieren und im angeschlossenen Laden Kräuterprodukte einkaufen. Die Gästeinformation bietet von Mai bis Oktober regelmäßige Führungen unter fachkundiger Leitung einer Kräuterpädagogin durch den Kräuterpark an.</p>
  teaser_text<p>Neben den schönen Wandermöglichkeiten im Heilklimapark Tölzer Land steht Bad Heilbrunn ganz im Zeichen der Kräuter.</p>
  image_title_1Heilklimawandern in Bad Heilbrunn (c) Bildverlag Bahnmüller
  image_title_2
  image_title_3
  image_title_4
  image_title_5
  image_title_6
  image_title_7
  titleBad Heilbrunn
  teaser_buttonweiterlesen
  previous_url(null)
  Route(array)
  id509
  hash6bca0b7172c58abce0bf8ad5e72188a9
  created2019-04-28 21:05:52
  updated2022-05-02 12:47:46
  modelPointI18n
  foreign_key60
  base/de/
  aliasbad-heilbrunn
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft808
  rght809
  route/de/bad-heilbrunn
  TeaserImageUpload(array)
  0(array)
  id14129
  hashf05a864702c2891e4504fbe893d91f5f
  created2020-03-21 17:17:38
  updated2020-03-21 17:17:43
  modelPoint
  fieldteaser_image
  foreign_key60
  aliasheilklimawandern-in-bad-heilbrunn-bildverlag-bahnmueller-bearbeitet-kopie-1.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5e763e27d1214.jpg
  size535435
  ext.jpg
  mimeimage/jpeg
  width1315
  height1040
  1(array)
  id14131
  hash696759426a4178a8a98837355277b7c0
  created2020-03-21 17:17:43
  updated2020-03-21 17:17:43
  modelPoint
  fieldteaser_image
  foreign_key60
  aliasheilklimawandern-in-bad-heilbrunn-bildverlag-bahnmueller-bearbeitet-kopie-1-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id14129
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5e763e27d314c.jpg
  size99774
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  2(array)
  id25
  hashbb3acd2ffaec09e70b9a2b3adbc86bb8
  created2018-11-02 12:33:54
  updated2021-04-14 13:30:51
  statusactive
  titleLantenhammer Destillerie
  content_typepoi
  categorySouvenirs
  teaser_titleLantenhammer Destillerie
  top_tip(true)
  map_lat47.761799
  map_long11.830226
  streetJosef-Lantenhammer-Platz 1
  zip_code83734
  cityHausham
  phone+49 8026 / 92480 - 0
  website_urlhttp://www.lantenhammer.de/
  emailinfo@lantenhammer.de
  region1Oberbayern
  region2Alpenregion Tegernsee-Schliersee
  region3
  booking_link
  gmap_urlhttp://maps.google.com/maps?z=12&t=m&q=47.761223,11.830516
  external_id100021934
  gmap_zoom7
  fax
  weather_widget_code
  hotels_gastronomy(null)
  hotels_wellness(null)
  hotels_parking(null)
  hotels_car_rental(null)
  hotels_oldtimer(null)
  hotels_transfer(null)
  hotels_car_charging_possibility(null)
  hotels_distance_to_nearest_train_station(null)
  hotels_bike_rental(null)
  hotels_car_rental_other_de(null)
  hotels_car_rental_other_it(null)
  hotels_car_rental_other_nl(null)
  hotels_car_rental_other_en(null)
  hotels_emobil(null)
  map47.761799;11.830226
  PointsTravelIdea(array)
  id161
  travel_idea_id7
  point_id25
  position3
  PointI18n(array)
  0(array)
  id25
  hash607fb5a65b55fc3e4a33f4b70e2c2e38
  created2018-11-02 12:33:54
  updated2022-04-28 17:14:40
  language_id1
  point_id25
  countryDeutschland
  introduction_text
  detail_text<p>LANTENHAMMER Destillerie – Erleben, Staunen, Genießen</p> <p>Wie entsteht traditioneller Obstbrand, feiner Gin oder echt bayrischer Rum? Im interaktiven und multimedialen Erlebnisrundgang erfährt man alles über die Welt feiner Destillate.</p> <p>Ob bei einer „selfguided Tour“ oder einer Führung durch die Brennerei, erhält man einen Einblick in die Geheimnisse der LANTENHAMMER Destillerie – mit Sicherheit. </p>
  teaser_text
  image_title_1Destillerie Lantenhammer in Hausham/Schliersee © www.lantenhammer.de
  image_title_2Erlebnistour Lantenhammer
  image_title_3Erlebnistour Lantenhammer
  image_title_4
  image_title_5
  image_title_6
  image_title_7
  titleLantenhammer Destillerie
  teaser_buttonweiterlesen
  previous_url(null)
  Route(array)
  id633
  hash9f0b50281b7c4a5d6c6ca1077928fbfa
  created2019-07-09 09:45:21
  updated2022-04-28 17:14:40
  modelPointI18n
  foreign_key25
  base/de/
  aliaslantenhammer-destillerie
  controllerFrontendPoints.FrontendPoints
  actionpoint
  parent_id1
  lft940
  rght941
  route/de/lantenhammer-destillerie
  TeaserImageUpload(array)
  0(array)
  id12145
  hashd63f74f3ced10ec8c056c6046a62fbe4
  created2018-11-02 12:33:53
  updated2018-11-02 12:33:54
  modelPoint
  fieldteaser_image
  foreign_key25
  aliasdestillerie-lantenhammer-in-hausham-schliersee.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Point/TeaserImage/5bdc362267097.jpg
  size627538
  ext.jpg
  mimeimage/jpeg
  width1920
  height1081
  1(array)
  id13340
  hashc88df7e9f45603ecbf319923df8a3628
  created2019-07-02 17:22:05
  updated2019-07-02 17:22:05
  modelPoint
  fieldteaser_image
  foreign_key25
  aliasdestillerie-lantenhammer-in-hausham-schliersee-thpointteaserresponsive.jpg
  thumbnailth-point-teaser-responsive
  parent_id12145
  filewebroot/files/Point/TeaserImage/ThPointTeaserResponsive/5d1b769cbc511.jpg
  size83567
  ext.jpg
  mimeimage/jpeg
  width750
  height462
  Language(array)
  id1
  hashf106f1d0ff26be20a99c7104166fa029
  created2016-07-11 13:44:53
  updated2016-07-11 14:10:50
  titleDeutsch
  langidde
  default(true)
  Route(array)
  id1257
  hash4b22f438b47a0945806bd710e88048c1
  created2022-06-23 12:09:27
  updated2022-06-23 12:09:28
  modelTravelIdeaI18n
  foreign_key7
  base/de/
  aliasgourmet-und-genuss
  controllerFrontendTravelIdeas.FrontendTravelIdeas
  actiontravel_idea
  parent_id1
  lft1152
  rght1153
  route/de/gourmet-und-genuss
  Seo(array)
  id1199
  hash7faea46b159066a94035fc2203d36a06
  created2022-06-23 12:09:28
  updated2022-06-23 12:09:28
  modelTravelIdeaI18n
  foreign_key7
  title
  description
  author
  tw_creator
  fb_author
  robots3
  internal_keywords
  PdfUpload(array)
  0(array)
  id20040
  hash55f4953f5213febfd5108561352ad383
  created2022-06-23 12:09:25
  updated2022-06-23 12:09:28
  modelTravelIdeaI18n
  fieldpdf
  foreign_key7
  aliasda-reisetipp5-oberstaufen-rottach-egern-aschau.pdf
  thumbnail(null)
  parent_id(null)
  filewebroot/files/TravelIdeaI18n/Pdf/62b43bd80a1fa.pdf
  size1043457
  ext.pdf
  mimeapplication/pdf
  width(null)
  height(null)
- $request->data(empty)
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Setting(empty)
  ValueUpload(empty)
  TravelIdeaI18n(empty)
  ArticleContentMedia(empty)
  MediaEntity(empty)
  Seo(empty)
  ImageMedia(empty)
  Teaser(empty)
  TravelIdea(empty)
  GalleryMedia(empty)
  CardMedia(empty)
  Point(empty)
  CityHotels(empty)
  CityPois(empty)
  PointsTravelIdeas(empty)
  FileUpload(empty)
  TravelExperience(empty)
  TravelExperienceI18n(empty)
  TravelBooking(empty)
  TeaserImageUpload(empty)
  PointI18n(empty)
  PdfUpload(empty)
  PointsTravelIdea(empty)
  Menu(empty)
  MemberGroup(empty)
  Member(empty)
  Parent(empty)
  HeaderImagesMedia(empty)
  LogoIconImageMedia(empty)
  FlagUpload(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7SocialMedia
  8Embed
  9Layout
  10ThirdPartyCookies
  11Maps
  12Number
  13SimpleGraph
  14DebugTimer
  15Toolbar
  16Session
  17Js
  18HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.6.40
User	u884587394958
Home	/var/www/vhosts/deutsche-alpenstrasse.de
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	YrfnE-YV2aszih1hve8ThwAAAAE
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	YrfnE-YV2aszih1hve8ThwAAAAE
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Https	on
Redirect Status	200
Unique Id	YrfnE-YV2aszih1hve8ThwAAAAE
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Https	on
Proxy-nokeepalive	1
Http Host	www.deutsche-alpenstrasse.de
Http X Real Ip	44.200.40.195
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http Accept Encoding	br,gzip
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.deutsche-alpenstrasse.de
Server Addr	85.236.63.140
Server Port	443
Remote Addr	44.200.40.195
Document Root	/var/www/vhosts/deutsche-alpenstrasse.de/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/deutsche-alpenstrasse.de/httpdocs
Server Admin	root@localhost
Script Filename	/var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/webroot/index.php
Remote Port	52866
Redirect Url	/webroot/de/gourmet-und-genuss
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/de/gourmet-und-genuss
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1656219411.5268
Request Time	1656219411

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.6/share/pear
- 2-> /var/www/vhosts/deutsche-alpenstrasse.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
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/AuthComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeNumber.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  6APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/HabtmBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.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
  FrontendContents(array)
  Config(array)
  0FrontendContents/Config/routes.php
  FrontendMembers(array)
  Config(array)
  0FrontendMembers/Config/routes.php
  FrontendTravelIdeas(array)
  Controller(array)
  0FrontendTravelIdeas/Controller/FrontendTravelIdeasController.php
  1FrontendTravelIdeas/Controller/FrontendTravelIdeasAppController.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Maps(array)
  Behavior(array)
  0Maps/Model/Behavior/GeoPositionBehavior.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.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
  Points(array)
  Model(array)
  0Points/Model/Point.php
  1Points/Model/PointAppModel.php
  2Points/Model/PointI18n.php
  Regions(array)
  Config(array)
  0Regions/Config/bootstrap.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  TravelIdeas(array)
  Model(array)
  0TravelIdeas/Model/TravelIdeaI18n.php
  1TravelIdeas/Model/TravelIdeaAppModel.php
  2TravelIdeas/Model/TravelIdea.php
  3TravelIdeas/Model/TravelExperience.php
  4TravelIdeas/Model/TravelExperienceI18n.php
  5TravelIdeas/Model/TravelBooking.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
====

Gourmet und Genuss

Tag 1 - 3 Oberstaufen

1 Oberstaufen

Oberstaufen Tourismus

Oberstaufen

Hotel Allgäu Sonne

Allgäu Sonne

Tag 3 - 5 Rottach-Egern