Hotel Allgäu Sonne Oberstaufen

Hotel Allgaeu Sonne Fitnesswelt Daemmerung 2

Hotel Allgaeu Sonne Doppelzimmer Dz Sup Hp Copy

Hotel Allgaeu Sonne Innenansicht Restaurant2

Hotel Allgaeu Sonne Innenpool Tageslicht300dpi Copy

Situated on a sunny, south-facing slope above Oberstaufen, the 5-star Hotel Allgäu Sonne has spectacular views of the Allgäu mountains. And you too can enjoy them in what is probably German's most beautiful hotel gym. On offer every day from Monday to Saturday are up to 8 exercise classes and a guided walk, while relaxation awaits in the spa area featuring two indoor and one outdoor pool, a jacuzzi, a steamroom and a panoramic sauna.

The kitchen team specialises in creative regional dishes, and every evening there is live music and dancing. Among our 149 rooms and suites there are 65 single rooms, making Allgäu Sonne the ideal destination for solo travellers and groups of friends.

Gastronomie

Restaurant
Cafe
Bar
Regionale Produkte

Wellness

Hallenbad
Außenschwimmbad in der Sommersaison
Sauna
Dampfbad
Massage
Beautyfarm/Kosmetikabteilung
Fitnessraum

Parken

Hauseigener Parkplatz
Eigene Garage

Oldtimer

Versperrter oder videoüberwachter Abstellplatz

Mobilität & Elektromobilität

Entfernung zum nächsten Bahnhof 1,50 km
Transfer/Abholung vom/zum nächsten Bahnhof: Kostenfrei

Radverleih

E-Bike
E-Mountainbike

Lademöglichkeit für Elektrofahrzeuge

Sind vorhanden

Notice (8): Undefined variable: mapOptions [APP/Plugin/FrontendPoints/View/FrontendPoints/point.php, line 392]Code Context                                                12,
                                                $mapOptions
                                            );
$viewFile = '/var/www/vhosts/deutsche-alpenstrasse.de/httpdocs/Plugin/FrontendPoints/View/FrontendPoints/point.php'
$dataForView = array(
	'socialLinksFooterForLayout' => array(
		(int) 0 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'Seo' => array(
				[maximum depth reached]
			),
			'Teaser' => array(
				[maximum depth reached]
			),
			'HeaderImagesMedia' => array([maximum depth reached]),
			'LogoIconImageMedia' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'Seo' => array(
				[maximum depth reached]
			),
			'Teaser' => array(
				[maximum depth reached]
			),
			'HeaderImagesMedia' => array([maximum depth reached]),
			'LogoIconImageMedia' => array(
				[maximum depth reached]
			)
		)
	),
	'socialSitesNavigationForLayout' => array(),
	'socialShareNavigationForLayout' => array(
		(int) 0 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'Seo' => array(
				[maximum depth reached]
			),
			'Teaser' => array(
				[maximum depth reached]
			),
			'HeaderImagesMedia' => array([maximum depth reached]),
			'LogoIconImageMedia' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'Seo' => array(
				[maximum depth reached]
			),
			'Teaser' => array(
				[maximum depth reached]
			),
			'HeaderImagesMedia' => array([maximum depth reached]),
			'LogoIconImageMedia' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'Seo' => array(
				[maximum depth reached]
			),
			'Teaser' => array(
				[maximum depth reached]
			),
			'HeaderImagesMedia' => array([maximum depth reached]),
			'LogoIconImageMedia' => array(
				[maximum depth reached]
			)
		)
	),
	'titleForLayout' => array(),
	'mainNavLinksForLayout' => array(
		(int) 0 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		)
	),
	'pathForLayout' => array(),
	'seoForLayout' => array(
		'Seo' => array(
			'id' => '773',
			'hash' => '12cf90fcb53c1f51588fb4b8bb792e12',
			'created' => '2020-03-30 21:37:33',
			'updated' => '2021-06-25 12:26:18',
			'model' => 'PointI18n',
			'foreign_key' => '268',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => ''
		),
		'ImageMedia' => array()
	),
	'languagesForLayout' => array(
		(int) 0 => array(
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'FlagUpload' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'FlagUpload' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'FlagUpload' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Language' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'FlagUpload' => array(
				[maximum depth reached]
			)
		)
	),
	'serviceNavigationForLayout' => array(),
	'footerLinksForLayout' => array(
		(int) 0 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		)
	),
	'isHomeForLayout' => false,
	'metaaNavigationForLayout' => array(
		(int) 0 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'Route' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		)
	),
	'defaultModel' => object(Point) {
		hasMany => array(
			[maximum depth reached]
		)
		actsAs => array(
			[maximum depth reached]
		)
		validate => array([maximum depth reached])
		recursive => (int) -1
		containments => array(
			[maximum depth reached]
		)
		validationDomain => 'app'
		cacheQueries => true
		useDbConfig => 'default'
		useTable => 'points'
		id => false
		data => array([maximum depth reached])
		schemaName => 'deutsche_alpenstr2019'
		table => 'points'
		primaryKey => 'id'
		validationErrors => array([maximum depth reached])
		tablePrefix => ''
		plugin => 'Points'
		name => 'Point'
		alias => 'Point'
		tableToModel => array(
			[maximum depth reached]
		)
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasAndBelongsToMany => array(
			[maximum depth reached]
		)
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		order => null
		virtualFields => array(
			[maximum depth reached]
		)
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		CityHotels => object(Point) {}
		CityPois => object(Point) {}
		ArticleContentMedia => object(Media) {}
		Image1Upload => object(Upload) {}
		Image2Upload => object(Upload) {}
		Image3Upload => object(Upload) {}
		Image4Upload => object(Upload) {}
		Image5Upload => object(Upload) {}
		Image6Upload => object(Upload) {}
		Image7Upload => object(Upload) {}
		HotelsForPoint => object(AppModel) {}
		PoisForPoint => object(AppModel) {}
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => null
		[protected] _validator => null
	},
	'debugToolbarPanels' => array(
		'history' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'history_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'session' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'session_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'request' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'request_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'sql_log' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'sql_log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'timer' => array(
			'content' => null,
			'elementName' => 'timer_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'log' => array(
			'content' => object(DebugKitLog) {},
			'elementName' => 'log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'variables' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'variables_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'environment' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'environment_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'include' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'include_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		)
	),
	'debugToolbarJavascript' => array(
		'libs' => 'DebugKit./js/js_debug_toolbar'
	),
	'debugToolbarCss' => array(
		(int) 0 => 'DebugKit./css/debug_toolbar.css'
	),
	'row' => array(
		'PointI18n' => array(
			'id' => '268',
			'hash' => '61da83c86f45bd9d424f5dc506a97b1b',
			'created' => '2020-03-30 21:37:33',
			'updated' => '2021-06-25 12:26:18',
			'language_id' => '4',
			'point_id' => '150',
			'country' => '',
			'introduction_text' => '',
			'detail_text' => '<p>Situated on a sunny, south-facing slope above Oberstaufen, the 5-star Hotel Allg&auml;u Sonne has spectacular views of the Allg&auml;u mountains. And you too can enjoy them in what is probably German&#39;s most beautiful hotel gym. On offer every day from Monday to Saturday are up to 8 exercise classes and a guided walk, while relaxation awaits in the spa area featuring two indoor and one outdoor pool, a jacuzzi, a steamroom and a panoramic sauna.</p>

<p>The kitchen team specialises in creative regional dishes, and every evening there is live music and dancing. Among our 149 rooms and suites there are 65 single rooms, making Allg&auml;u Sonne the ideal destination for solo travellers and groups of friends.</p>
',
			'teaser_text' => '<p>Oberstaufen</p>

<p>Tel. +49 (0)8386 702 0</p>

<p>www.allgaeu-sonne.de</p>
',
			'image_title_1' => '',
			'image_title_2' => '',
			'image_title_3' => '',
			'image_title_4' => '',
			'image_title_5' => '',
			'image_title_6' => '',
			'image_title_7' => '',
			'title' => 'Hotel Allgäu Sonne Oberstaufen',
			'teaser_button' => 'read more',
			'previous_url' => null
		),
		'Point' => array(
			'id' => '150',
			'hash' => '12a171aa3cd67f947cf76d2f92e82758',
			'created' => '2020-03-30 21:28:08',
			'updated' => '2021-08-02 16:15:07',
			'status' => 'active',
			'title' => 'Allgäu Sonne',
			'content_type' => 'hotel',
			'category' => null,
			'teaser_title' => 'Hotel Allgäu Sonne',
			'top_tip' => true,
			'map_lat' => '47.550827',
			'map_long' => '10.013640',
			'street' => 'Stießberg 1',
			'zip_code' => '87534',
			'city' => 'Oberstaufen',
			'phone' => '+49 (0)8386 702 0',
			'website_url' => 'http://www.allgaeu-sonne.de',
			'email' => 'info@allgaeu-sonne.de',
			'region1' => 'Allgäu',
			'region2' => 'Allgäu Gipfelwelten',
			'region3' => '',
			'booking_link' => 'https://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_url' => 'https://goo.gl/maps/twShi5XJR5QEchy7A',
			'external_id' => null,
			'gmap_zoom' => '7',
			'fax' => '+49 (0)8386 702 7826',
			'weather_widget_code' => '',
			'hotels_gastronomy' => '15',
			'hotels_wellness' => '501',
			'hotels_parking' => '3',
			'hotels_car_rental' => '0',
			'hotels_oldtimer' => '4',
			'hotels_transfer' => 'free',
			'hotels_car_charging_possibility' => true,
			'hotels_distance_to_nearest_train_station' => '1.500000',
			'hotels_bike_rental' => '12',
			'hotels_car_rental_other_de' => '',
			'hotels_car_rental_other_it' => '',
			'hotels_car_rental_other_nl' => '',
			'hotels_car_rental_other_en' => '',
			'hotels_emobil' => true,
			'map' => '47.550827;10.013640',
			'Image1Upload' => array(
				[maximum depth reached]
			),
			'Image2Upload' => array(
				[maximum depth reached]
			),
			'Image3Upload' => array(
				[maximum depth reached]
			),
			'Image4Upload' => array(
				[maximum depth reached]
			),
			'Image5Upload' => array(
				[maximum depth reached]
			),
			'Image6Upload' => array(
				[maximum depth reached]
			),
			'Image7Upload' => array(
				[maximum depth reached]
			),
			'CityHotels' => array([maximum depth reached]),
			'CityPois' => array([maximum depth reached])
		),
		'Language' => array(
			'id' => '4',
			'hash' => '5fdcab58cbf42c343cfcd5bf2d59aa4a',
			'created' => '2016-07-11 13:49:59',
			'updated' => '2016-07-11 13:49:59',
			'title' => 'English',
			'langid' => 'en',
			'default' => false
		),
		'Route' => array(
			'id' => '810',
			'hash' => '3d45deb737cad6acae5b26a826b81b81',
			'created' => '2020-03-30 21:37:33',
			'updated' => '2021-06-25 12:26:18',
			'model' => 'PointI18n',
			'foreign_key' => '268',
			'base' => '/en/',
			'alias' => 'hotel-allgaeu-sonne-oberstaufen',
			'controller' => 'FrontendPoints.FrontendPoints',
			'action' => 'point',
			'parent_id' => '4',
			'lft' => '2036',
			'rght' => '2037',
			'route' => '/en/hotel-allgaeu-sonne-oberstaufen'
		),
		'Seo' => array(
			'id' => '773',
			'hash' => '12cf90fcb53c1f51588fb4b8bb792e12',
			'created' => '2020-03-30 21:37:33',
			'updated' => '2021-06-25 12:26:18',
			'model' => 'PointI18n',
			'foreign_key' => '268',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => ''
		)
	),
	'isGerman' => false
)
$socialLinksFooterForLayout = array(
	(int) 0 => array(
		'Menu' => array(
			'id' => '320',
			'hash' => '989b74bee8af08a02f79f2bd9b802c4d',
			'created' => '2020-10-23 11:36:20',
			'updated' => '2020-10-26 13:51:47',
			'parent_id' => '319',
			'lft' => '189',
			'rght' => '190',
			'language_id' => '1',
			'type' => 'url',
			'title' => 'Facebook Link',
			'previous_url' => null,
			'url' => 'https://www.facebook.com/deutschealpenstrasse',
			'target_blank' => true
		),
		'Language' => array(
			'id' => '1',
			'hash' => 'f106f1d0ff26be20a99c7104166fa029',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'title' => 'Deutsch',
			'langid' => 'de',
			'default' => true
		),
		'Route' => array(
			'id' => '958',
			'hash' => '3477791f91d7025e8b93ee0f435bf06c',
			'created' => '2020-10-23 11:36:21',
			'updated' => '2020-10-26 13:51:47',
			'model' => 'Menu',
			'foreign_key' => '320',
			'base' => '/de/',
			'alias' => 'facebook-link',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'url',
			'parent_id' => '957',
			'lft' => '734',
			'rght' => '735',
			'route' => '/de/facebook-link'
		),
		'Seo' => array(
			'id' => '917',
			'hash' => '497098bd3aca8a7a08a02dff81b4d3c1',
			'created' => '2020-10-23 11:36:21',
			'updated' => '2020-10-26 13:51:47',
			'model' => 'Menu',
			'foreign_key' => '320',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => '',
			'ImageMedia' => array([maximum depth reached])
		),
		'Teaser' => array(
			'id' => '687',
			'hash' => 'b5cbd5bc877b62e1dd9fd4adc64efc66',
			'created' => '2020-10-23 11:36:21',
			'updated' => '2020-10-26 13:51:47',
			'model' => 'Menu',
			'foreign_key' => '320',
			'type' => 'default',
			'title' => '',
			'content' => '',
			'button' => 'weiterlesen',
			'teaser_id' => null,
			'layout' => 'col12',
			'ImageMedia' => array([maximum depth reached])
		),
		'HeaderImagesMedia' => array(),
		'LogoIconImageMedia' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 1 => array(
		'Menu' => array(
			'id' => '321',
			'hash' => 'c0770d9956d12309950050eb9b1153bb',
			'created' => '2020-10-23 11:40:04',
			'updated' => '2020-10-26 13:51:58',
			'parent_id' => '319',
			'lft' => '191',
			'rght' => '192',
			'language_id' => '1',
			'type' => 'url',
			'title' => 'Instagram Link',
			'previous_url' => null,
			'url' => 'https://www.instagram.com/deutschealpenstrasse',
			'target_blank' => true
		),
		'Language' => array(
			'id' => '1',
			'hash' => 'f106f1d0ff26be20a99c7104166fa029',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'title' => 'Deutsch',
			'langid' => 'de',
			'default' => true
		),
		'Route' => array(
			'id' => '959',
			'hash' => '3aab23bbb7cfd4b96bfa46dc72e7dac5',
			'created' => '2020-10-23 11:40:04',
			'updated' => '2020-10-26 13:51:58',
			'model' => 'Menu',
			'foreign_key' => '321',
			'base' => '/de/',
			'alias' => 'instagram-link',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'url',
			'parent_id' => '957',
			'lft' => '736',
			'rght' => '737',
			'route' => '/de/instagram-link'
		),
		'Seo' => array(
			'id' => '918',
			'hash' => '1455e5f95bb4e19584da0f5a7b8a4554',
			'created' => '2020-10-23 11:40:05',
			'updated' => '2020-10-26 13:51:58',
			'model' => 'Menu',
			'foreign_key' => '321',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => '',
			'ImageMedia' => array([maximum depth reached])
		),
		'Teaser' => array(
			'id' => '688',
			'hash' => '386920748579bac6066d60cf4e04ce5a',
			'created' => '2020-10-23 11:40:05',
			'updated' => '2020-10-26 13:51:58',
			'model' => 'Menu',
			'foreign_key' => '321',
			'type' => 'default',
			'title' => '',
			'content' => '',
			'button' => 'weiterlesen',
			'teaser_id' => null,
			'layout' => 'col12',
			'ImageMedia' => array([maximum depth reached])
		),
		'HeaderImagesMedia' => array(),
		'LogoIconImageMedia' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	)
)
$socialSitesNavigationForLayout = array()
$socialShareNavigationForLayout = array(
	(int) 0 => array(
		'Menu' => array(
			'id' => '181',
			'hash' => 'cebba143dd7413f41c64047e9fa88903',
			'created' => '2018-11-15 10:39:03',
			'updated' => '2018-11-15 10:39:03',
			'parent_id' => '179',
			'lft' => '179',
			'rght' => '180',
			'language_id' => '1',
			'type' => 'url',
			'title' => 'Facebook',
			'previous_url' => null,
			'url' => 'https://www.facebook.com/sharer/sharer.php?u=',
			'target_blank' => false
		),
		'Language' => array(
			'id' => '1',
			'hash' => 'f106f1d0ff26be20a99c7104166fa029',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'title' => 'Deutsch',
			'langid' => 'de',
			'default' => true
		),
		'Route' => array(
			'id' => '474',
			'hash' => '432df686315676e8af19e3340c0315cc',
			'created' => '2018-11-15 10:39:03',
			'updated' => '2018-11-15 10:39:03',
			'model' => 'Menu',
			'foreign_key' => '181',
			'base' => '/de/',
			'alias' => 'facebook',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'url',
			'parent_id' => '472',
			'lft' => '724',
			'rght' => '725',
			'route' => '/de/facebook'
		),
		'Seo' => array(
			'id' => '443',
			'hash' => '96cad95cf20a1961f932667bd8e9934d',
			'created' => '2018-11-15 10:39:03',
			'updated' => '2018-11-15 10:39:03',
			'model' => 'Menu',
			'foreign_key' => '181',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => '',
			'ImageMedia' => array([maximum depth reached])
		),
		'Teaser' => array(
			'id' => '443',
			'hash' => 'cdbb329ea103eb91ee65ac607d585f2c',
			'created' => '2018-11-15 10:39:03',
			'updated' => '2018-11-15 10:39:03',
			'model' => 'Menu',
			'foreign_key' => '181',
			'type' => 'default',
			'title' => '',
			'content' => '',
			'button' => 'weiterlesen',
			'teaser_id' => null,
			'layout' => 'col12',
			'ImageMedia' => array([maximum depth reached])
		),
		'HeaderImagesMedia' => array(),
		'LogoIconImageMedia' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 1 => array(
		'Menu' => array(
			'id' => '183',
			'hash' => 'fd3a9907140a3ad09dcca78f311e7c2c',
			'created' => '2018-11-15 10:40:46',
			'updated' => '2018-11-15 10:40:46',
			'parent_id' => '179',
			'lft' => '181',
			'rght' => '182',
			'language_id' => '1',
			'type' => 'url',
			'title' => 'Twitter',
			'previous_url' => null,
			'url' => 'https://twitter.com/home?status=',
			'target_blank' => false
		),
		'Language' => array(
			'id' => '1',
			'hash' => 'f106f1d0ff26be20a99c7104166fa029',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'title' => 'Deutsch',
			'langid' => 'de',
			'default' => true
		),
		'Route' => array(
			'id' => '476',
			'hash' => 'be54882ed8d5f28d3cc782f161bc686a',
			'created' => '2018-11-15 10:40:46',
			'updated' => '2018-11-15 10:40:46',
			'model' => 'Menu',
			'foreign_key' => '183',
			'base' => '/de/',
			'alias' => 'twitter',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'url',
			'parent_id' => '472',
			'lft' => '726',
			'rght' => '727',
			'route' => '/de/twitter'
		),
		'Seo' => array(
			'id' => '445',
			'hash' => '70f748f608531870970f6dee1e613c25',
			'created' => '2018-11-15 10:40:46',
			'updated' => '2018-11-15 10:40:46',
			'model' => 'Menu',
			'foreign_key' => '183',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => '',
			'ImageMedia' => array([maximum depth reached])
		),
		'Teaser' => array(
			'id' => '445',
			'hash' => '87133186b0f1d2f124de6b6a477ea358',
			'created' => '2018-11-15 10:40:46',
			'updated' => '2018-11-15 10:40:46',
			'model' => 'Menu',
			'foreign_key' => '183',
			'type' => 'default',
			'title' => '',
			'content' => '',
			'button' => 'weiterlesen',
			'teaser_id' => null,
			'layout' => 'col12',
			'ImageMedia' => array([maximum depth reached])
		),
		'HeaderImagesMedia' => array(),
		'LogoIconImageMedia' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 2 => array(
		'Menu' => array(
			'id' => '184',
			'hash' => '33f9a21450fe1dbf95cd54add256d9cc',
			'created' => '2018-11-15 10:42:39',
			'updated' => '2018-11-15 10:42:39',
			'parent_id' => '179',
			'lft' => '183',
			'rght' => '184',
			'language_id' => '1',
			'type' => 'url',
			'title' => 'Printerest',
			'previous_url' => null,
			'url' => 'https://pinterest.com/pin/create/button/?url=',
			'target_blank' => false
		),
		'Language' => array(
			'id' => '1',
			'hash' => 'f106f1d0ff26be20a99c7104166fa029',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'title' => 'Deutsch',
			'langid' => 'de',
			'default' => true
		),
		'Route' => array(
			'id' => '477',
			'hash' => '6089e2d12d0d77ebfe27b361cb3e28fb',
			'created' => '2018-11-15 10:42:39',
			'updated' => '2018-11-15 10:42:39',
			'model' => 'Menu',
			'foreign_key' => '184',
			'base' => '/de/',
			'alias' => 'printerest',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'url',
			'parent_id' => '472',
			'lft' => '728',
			'rght' => '729',
			'route' => '/de/printerest'
		),
		'Seo' => array(
			'id' => '446',
			'hash' => '5c76093a5251fb7d36f7c25b00a98087',
			'created' => '2018-11-15 10:42:39',
			'updated' => '2018-11-15 10:42:39',
			'model' => 'Menu',
			'foreign_key' => '184',
			'title' => '',
			'description' => '',
			'author' => '',
			'tw_creator' => '',
			'fb_author' => '',
			'robots' => '3',
			'internal_keywords' => '',
			'ImageMedia' => array([maximum depth reached])
		),
		'Teaser' => array(
			'id' => '446',
			'hash' => 'f3a101cb3fafbf4d2ab7fb1df6dcc6b0',
			'created' => '2018-11-15 10:42:39',
			'updated' => '2018-11-15 10:42:39',
			'model' => 'Menu',
			'foreign_key' => '184',
			'type' => 'default',
			'title' => '',
			'content' => '',
			'button' => 'weiterlesen',
			'teaser_id' => null,
			'layout' => 'col12',
			'ImageMedia' => array([maximum depth reached])
		),
		'HeaderImagesMedia' => array(),
		'LogoIconImageMedia' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	)
)
$titleForLayout = array()
$mainNavLinksForLayout = array(
	(int) 0 => array(
		'Menu' => array(
			'id' => '62',
			'hash' => 'c43615e1eac1a70d7acbde04a8619cf9',
			'created' => '2016-10-26 11:12:13',
			'updated' => '2016-10-26 11:12:13',
			'parent_id' => '61',
			'lft' => '326',
			'rght' => '335',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Alpine Road',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '170',
			'hash' => '344b56317eb6bbfebdb4665509059b0f',
			'created' => '2016-10-26 11:12:13',
			'updated' => '2016-10-26 11:12:13',
			'model' => 'Menu',
			'foreign_key' => '62',
			'base' => '/en/',
			'alias' => 'alpine-road',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1765',
			'rght' => '1798',
			'route' => '/en/alpine-road'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 1 => array(
		'Menu' => array(
			'id' => '66',
			'hash' => 'dcb7f23c1eba27e405dcc9f013332f07',
			'created' => '2016-10-26 11:15:04',
			'updated' => '2016-11-10 08:53:14',
			'parent_id' => '61',
			'lft' => '336',
			'rght' => '357',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Route',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '174',
			'hash' => 'f76326f480fcbe2caaed5d675af62f5d',
			'created' => '2016-10-26 11:15:04',
			'updated' => '2016-11-10 08:53:15',
			'model' => 'Menu',
			'foreign_key' => '66',
			'base' => '/en/',
			'alias' => 'route',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1799',
			'rght' => '1846',
			'route' => '/en/route'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 2 => array(
		'Menu' => array(
			'id' => '81',
			'hash' => '9eb52aca9f2d756a337937063c7b9349',
			'created' => '2016-10-26 11:34:41',
			'updated' => '2016-10-26 11:34:41',
			'parent_id' => '61',
			'lft' => '358',
			'rght' => '387',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Highlights',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '189',
			'hash' => '10d7b99bd0654c377a30814998751861',
			'created' => '2016-10-26 11:34:41',
			'updated' => '2016-10-26 11:34:41',
			'model' => 'Menu',
			'foreign_key' => '81',
			'base' => '/en/',
			'alias' => 'highlights',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1847',
			'rght' => '1906',
			'route' => '/en/highlights'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 3 => array(
		'Menu' => array(
			'id' => '200',
			'hash' => '53b74096c1689c8764bafd573af4168e',
			'created' => '2019-07-22 11:58:39',
			'updated' => '2019-07-22 11:58:39',
			'parent_id' => '61',
			'lft' => '388',
			'rght' => '435',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Hotels',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '693',
			'hash' => 'a4a8aa3999e3f6b05ff0d01ada61417a',
			'created' => '2019-07-22 11:58:39',
			'updated' => '2019-07-22 11:58:39',
			'model' => 'Menu',
			'foreign_key' => '200',
			'base' => '/en/',
			'alias' => 'hotels',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1913',
			'rght' => '1962',
			'route' => '/en/hotels'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 4 => array(
		'Menu' => array(
			'id' => '92',
			'hash' => '87d1c8b10b327eaee63ef76655b07e52',
			'created' => '2016-10-26 11:50:42',
			'updated' => '2018-02-19 12:07:44',
			'parent_id' => '61',
			'lft' => '436',
			'rght' => '437',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Services',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '200',
			'hash' => '6c3a9a059dffb2c735d313a74e8a4de4',
			'created' => '2016-10-26 11:50:42',
			'updated' => '2018-02-19 12:07:44',
			'model' => 'Menu',
			'foreign_key' => '92',
			'base' => '/en/',
			'alias' => 'services',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1907',
			'rght' => '1912',
			'route' => '/en/services'
		),
		'children' => array()
	)
)
$pathForLayout = array()
$seoForLayout = array(
	'Seo' => array(
		'id' => '773',
		'hash' => '12cf90fcb53c1f51588fb4b8bb792e12',
		'created' => '2020-03-30 21:37:33',
		'updated' => '2021-06-25 12:26:18',
		'model' => 'PointI18n',
		'foreign_key' => '268',
		'title' => '',
		'description' => '',
		'author' => '',
		'tw_creator' => '',
		'fb_author' => '',
		'robots' => '3',
		'internal_keywords' => ''
	),
	'ImageMedia' => array()
)
$languagesForLayout = array(
	(int) 0 => array(
		'Language' => array(
			'id' => '1',
			'hash' => 'f106f1d0ff26be20a99c7104166fa029',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'title' => 'Deutsch',
			'langid' => 'de',
			'default' => true
		),
		'Route' => array(
			'id' => '1',
			'hash' => '8ff3e615ac91173379d93d624dcf7d71',
			'created' => '2016-07-11 13:44:53',
			'updated' => '2016-07-11 14:10:50',
			'model' => 'Language',
			'foreign_key' => '1',
			'base' => '/',
			'alias' => 'de',
			'controller' => null,
			'action' => null,
			'parent_id' => null,
			'lft' => '1',
			'rght' => '1142',
			'route' => '/de'
		),
		'FlagUpload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 1 => array(
		'Language' => array(
			'id' => '2',
			'hash' => '6052cc3fff4f3a9542a3004b1cada1b8',
			'created' => '2016-07-11 13:48:57',
			'updated' => '2016-07-11 13:48:57',
			'title' => 'Italiano',
			'langid' => 'it',
			'default' => false
		),
		'Route' => array(
			'id' => '2',
			'hash' => '4b881e9e7049a8bf0e626670c91ac3ab',
			'created' => '2016-07-11 13:48:57',
			'updated' => '2016-07-11 13:48:57',
			'model' => 'Language',
			'foreign_key' => '2',
			'base' => '/',
			'alias' => 'it',
			'controller' => null,
			'action' => null,
			'parent_id' => null,
			'lft' => '1143',
			'rght' => '1446',
			'route' => '/it'
		),
		'FlagUpload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 2 => array(
		'Language' => array(
			'id' => '3',
			'hash' => '87c913a0ad509ab7fa767c42f1159643',
			'created' => '2016-07-11 13:49:35',
			'updated' => '2016-07-11 13:49:35',
			'title' => 'Nederlands',
			'langid' => 'nl',
			'default' => false
		),
		'Route' => array(
			'id' => '3',
			'hash' => 'c8355b89a6e01e77db40e0792878285b',
			'created' => '2016-07-11 13:49:35',
			'updated' => '2016-07-11 13:49:36',
			'model' => 'Language',
			'foreign_key' => '3',
			'base' => '/',
			'alias' => 'nl',
			'controller' => null,
			'action' => null,
			'parent_id' => null,
			'lft' => '1447',
			'rght' => '1746',
			'route' => '/nl'
		),
		'FlagUpload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 3 => array(
		'Language' => array(
			'id' => '4',
			'hash' => '5fdcab58cbf42c343cfcd5bf2d59aa4a',
			'created' => '2016-07-11 13:49:59',
			'updated' => '2016-07-11 13:49:59',
			'title' => 'English',
			'langid' => 'en',
			'default' => false
		),
		'Route' => array(
			'id' => '4',
			'hash' => '4855a61f1e6f018ea939eaf7e7d801d3',
			'created' => '2016-07-11 13:49:59',
			'updated' => '2016-07-11 13:49:59',
			'model' => 'Language',
			'foreign_key' => '4',
			'base' => '/',
			'alias' => 'en',
			'controller' => null,
			'action' => null,
			'parent_id' => null,
			'lft' => '1747',
			'rght' => '2050',
			'route' => '/en'
		),
		'FlagUpload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	)
)
$serviceNavigationForLayout = array()
$footerLinksForLayout = array(
	(int) 0 => array(
		'Menu' => array(
			'id' => '154',
			'hash' => '9c56ecb35e6923a052c88a4a40def5f1',
			'created' => '2016-12-12 09:50:06',
			'updated' => '2016-12-12 09:50:06',
			'parent_id' => '153',
			'lft' => '565',
			'rght' => '566',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Imprint',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '375',
			'hash' => '03523cf50c6fc567df0f532a8c380371',
			'created' => '2016-12-12 09:50:06',
			'updated' => '2016-12-12 09:50:06',
			'model' => 'Menu',
			'foreign_key' => '154',
			'base' => '/en/footer/links/',
			'alias' => 'imprint',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '374',
			'lft' => '1966',
			'rght' => '1969',
			'route' => '/en/footer/links/imprint'
		),
		'children' => array()
	),
	(int) 1 => array(
		'Menu' => array(
			'id' => '155',
			'hash' => 'aaf31c391e5cbcbb7df6130588f6f9d8',
			'created' => '2016-12-12 09:51:00',
			'updated' => '2016-12-12 09:51:00',
			'parent_id' => '153',
			'lft' => '567',
			'rght' => '568',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Privacy Policy',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '376',
			'hash' => 'b4fab34922c07a2b910b37abe2164fba',
			'created' => '2016-12-12 09:51:00',
			'updated' => '2016-12-12 09:51:00',
			'model' => 'Menu',
			'foreign_key' => '155',
			'base' => '/en/footer/links/',
			'alias' => 'privacy-policy',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '374',
			'lft' => '1970',
			'rght' => '1973',
			'route' => '/en/footer/links/privacy-policy'
		),
		'children' => array()
	)
)
$isHomeForLayout = false
$metaaNavigationForLayout = array(
	(int) 0 => array(
		'Menu' => array(
			'id' => '62',
			'hash' => 'c43615e1eac1a70d7acbde04a8619cf9',
			'created' => '2016-10-26 11:12:13',
			'updated' => '2016-10-26 11:12:13',
			'parent_id' => '61',
			'lft' => '326',
			'rght' => '335',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Alpine Road',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '170',
			'hash' => '344b56317eb6bbfebdb4665509059b0f',
			'created' => '2016-10-26 11:12:13',
			'updated' => '2016-10-26 11:12:13',
			'model' => 'Menu',
			'foreign_key' => '62',
			'base' => '/en/',
			'alias' => 'alpine-road',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1765',
			'rght' => '1798',
			'route' => '/en/alpine-road'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 1 => array(
		'Menu' => array(
			'id' => '66',
			'hash' => 'dcb7f23c1eba27e405dcc9f013332f07',
			'created' => '2016-10-26 11:15:04',
			'updated' => '2016-11-10 08:53:14',
			'parent_id' => '61',
			'lft' => '336',
			'rght' => '357',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Route',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '174',
			'hash' => 'f76326f480fcbe2caaed5d675af62f5d',
			'created' => '2016-10-26 11:15:04',
			'updated' => '2016-11-10 08:53:15',
			'model' => 'Menu',
			'foreign_key' => '66',
			'base' => '/en/',
			'alias' => 'route',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1799',
			'rght' => '1846',
			'route' => '/en/route'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 2 => array(
		'Menu' => array(
			'id' => '81',
			'hash' => '9eb52aca9f2d756a337937063c7b9349',
			'created' => '2016-10-26 11:34:41',
			'updated' => '2016-10-26 11:34:41',
			'parent_id' => '61',
			'lft' => '358',
			'rght' => '387',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Highlights',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '189',
			'hash' => '10d7b99bd0654c377a30814998751861',
			'created' => '2016-10-26 11:34:41',
			'updated' => '2016-10-26 11:34:41',
			'model' => 'Menu',
			'foreign_key' => '81',
			'base' => '/en/',
			'alias' => 'highlights',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1847',
			'rght' => '1906',
			'route' => '/en/highlights'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 3 => array(
		'Menu' => array(
			'id' => '200',
			'hash' => '53b74096c1689c8764bafd573af4168e',
			'created' => '2019-07-22 11:58:39',
			'updated' => '2019-07-22 11:58:39',
			'parent_id' => '61',
			'lft' => '388',
			'rght' => '435',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Hotels',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '693',
			'hash' => 'a4a8aa3999e3f6b05ff0d01ada61417a',
			'created' => '2019-07-22 11:58:39',
			'updated' => '2019-07-22 11:58:39',
			'model' => 'Menu',
			'foreign_key' => '200',
			'base' => '/en/',
			'alias' => 'hotels',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1913',
			'rght' => '1962',
			'route' => '/en/hotels'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 4 => array(
		'Menu' => array(
			'id' => '92',
			'hash' => '87d1c8b10b327eaee63ef76655b07e52',
			'created' => '2016-10-26 11:50:42',
			'updated' => '2018-02-19 12:07:44',
			'parent_id' => '61',
			'lft' => '436',
			'rght' => '437',
			'language_id' => '4',
			'type' => 'content',
			'title' => 'Services',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '200',
			'hash' => '6c3a9a059dffb2c735d313a74e8a4de4',
			'created' => '2016-10-26 11:50:42',
			'updated' => '2018-02-19 12:07:44',
			'model' => 'Menu',
			'foreign_key' => '92',
			'base' => '/en/',
			'alias' => 'services',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '169',
			'lft' => '1907',
			'rght' => '1912',
			'route' => '/en/services'
		),
		'children' => array()
	)
)
$defaultModel = object(Point) {
	hasMany => array(
		'PointI18n' => array(
			[maximum depth reached]
		),
		'Image1Upload' => array(
			[maximum depth reached]
		),
		'Image2Upload' => array(
			[maximum depth reached]
		),
		'Image3Upload' => array(
			[maximum depth reached]
		),
		'Image4Upload' => array(
			[maximum depth reached]
		),
		'Image5Upload' => array(
			[maximum depth reached]
		),
		'Image6Upload' => array(
			[maximum depth reached]
		),
		'Image7Upload' => array(
			[maximum depth reached]
		),
		'TeaserImageUpload' => array(
			[maximum depth reached]
		)
	)
	actsAs => array(
		'BaseData.AdvancedContainable' => null,
		'BaseData.Essential' => null,
		'BaseData.Search' => null,
		'Audit.Auditable' => null,
		'BaseData.Hash' => null,
		'BaseData.DateTime' => null,
		'BaseData.Enum' => array(
			[maximum depth reached]
		),
		'BaseData.BitMask' => array(
			[maximum depth reached]
		),
		'BaseData.Habtm' => array(
			[maximum depth reached]
		),
		'Media.Media' => array(
			[maximum depth reached]
		),
		'Uploads.Upload' => array(
			[maximum depth reached]
		),
		'Maps.GeoPosition' => array(
			[maximum depth reached]
		)
	)
	validate => array()
	recursive => (int) -1
	containments => array(
		(int) 0 => 'CityHotels',
		(int) 1 => 'CityPois',
		'ArticleContentMedia' => array(
			[maximum depth reached]
		),
		(int) 2 => 'Image1Upload',
		(int) 3 => 'Image2Upload',
		(int) 4 => 'Image3Upload',
		(int) 5 => 'Image4Upload',
		(int) 6 => 'Image5Upload',
		(int) 7 => 'Image6Upload',
		(int) 8 => 'Image7Upload',
		(int) 9 => 'TeaserImageUpload'
	)
	validationDomain => 'app'
	cacheQueries => true
	useDbConfig => 'default'
	useTable => 'points'
	id => false
	data => array()
	schemaName => 'deutsche_alpenstr2019'
	table => 'points'
	primaryKey => 'id'
	validationErrors => array()
	tablePrefix => ''
	plugin => 'Points'
	name => 'Point'
	alias => 'Point'
	tableToModel => array(
		'points' => 'CityPois',
		'media' => 'ArticleContentMedia',
		'uploads' => 'Image7Upload'
	)
	belongsTo => array()
	hasOne => array()
	hasAndBelongsToMany => array(
		'CityHotels' => array(
			[maximum depth reached]
		),
		'CityPois' => array(
			[maximum depth reached]
		),
		'ArticleContentMedia' => array(
			[maximum depth reached]
		)
	)
	Behaviors => object(BehaviorCollection) {}
	whitelist => array()
	cacheSources => true
	findQueryType => null
	order => null
	virtualFields => array(
		'map' => 'CONCAT_WS (';',Point.map_lat,Point.map_long)'
	)
	__backAssociation => array()
	__backInnerAssociation => array()
	__backOriginalAssociation => array()
	__backContainableAssociation => array()
	__safeUpdateMode => false
	useConsistentAfterFind => true
	findMethods => array(
		'all' => true,
		'first' => true,
		'count' => true,
		'neighbors' => true,
		'list' => true,
		'threaded' => true
	)
	CityHotels => object(Point) {}
	CityPois => object(Point) {}
	ArticleContentMedia => object(Media) {}
	Image1Upload => object(Upload) {}
	Image2Upload => object(Upload) {}
	Image3Upload => object(Upload) {}
	Image4Upload => object(Upload) {}
	Image5Upload => object(Upload) {}
	Image6Upload => object(Upload) {}
	Image7Upload => object(Upload) {}
	HotelsForPoint => object(AppModel) {}
	PoisForPoint => object(AppModel) {}
	[protected] _schema => array(
		'id' => array(
			[maximum depth reached]
		),
		'hash' => array(
			[maximum depth reached]
		),
		'created' => array(
			[maximum depth reached]
		),
		'updated' => array(
			[maximum depth reached]
		),
		'status' => array(
			[maximum depth reached]
		),
		'title' => array(
			[maximum depth reached]
		),
		'content_type' => array(
			[maximum depth reached]
		),
		'category' => array(
			[maximum depth reached]
		),
		'teaser_title' => array(
			[maximum depth reached]
		),
		'top_tip' => array(
			[maximum depth reached]
		),
		'map_lat' => array(
			[maximum depth reached]
		),
		'map_long' => array(
			[maximum depth reached]
		),
		'street' => array(
			[maximum depth reached]
		),
		'zip_code' => array(
			[maximum depth reached]
		),
		'city' => array(
			[maximum depth reached]
		),
		'phone' => array(
			[maximum depth reached]
		),
		'website_url' => array(
			[maximum depth reached]
		),
		'email' => array(
			[maximum depth reached]
		),
		'region1' => array(
			[maximum depth reached]
		),
		'region2' => array(
			[maximum depth reached]
		),
		'region3' => array(
			[maximum depth reached]
		),
		'booking_link' => array(
			[maximum depth reached]
		),
		'gmap_url' => array(
			[maximum depth reached]
		),
		'external_id' => array(
			[maximum depth reached]
		),
		'gmap_zoom' => array(
			[maximum depth reached]
		),
		'fax' => array(
			[maximum depth reached]
		),
		'weather_widget_code' => array(
			[maximum depth reached]
		),
		'hotels_gastronomy' => array(
			[maximum depth reached]
		),
		'hotels_wellness' => array(
			[maximum depth reached]
		),
		'hotels_parking' => array(
			[maximum depth reached]
		),
		'hotels_car_rental' => array(
			[maximum depth reached]
		),
		'hotels_oldtimer' => array(
			[maximum depth reached]
		),
		'hotels_transfer' => array(
			[maximum depth reached]
		),
		'hotels_car_charging_possibility' => array(
			[maximum depth reached]
		),
		'hotels_distance_to_nearest_train_station' => array(
			[maximum depth reached]
		),
		'hotels_bike_rental' => array(
			[maximum depth reached]
		),
		'hotels_car_rental_other_de' => array(
			[maximum depth reached]
		),
		'hotels_car_rental_other_it' => array(
			[maximum depth reached]
		),
		'hotels_car_rental_other_nl' => array(
			[maximum depth reached]
		),
		'hotels_car_rental_other_en' => array(
			[maximum depth reached]
		),
		'hotels_emobil' => array(
			[maximum depth reached]
		)
	)
	[protected] _associationKeys => array(
		'belongsTo' => array(
			[maximum depth reached]
		),
		'hasOne' => array(
			[maximum depth reached]
		),
		'hasMany' => array(
			[maximum depth reached]
		),
		'hasAndBelongsToMany' => array(
			[maximum depth reached]
		)
	)
	[protected] _associations => array(
		(int) 0 => 'belongsTo',
		(int) 1 => 'hasOne',
		(int) 2 => 'hasMany',
		(int) 3 => 'hasAndBelongsToMany'
	)
	[protected] _insertID => null
	[protected] _sourceConfigured => true
	[protected] _eventManager => null
	[protected] _validator => null
}
$debugToolbarPanels = array(
	'history' => array(
		'content' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'history_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'session' => array(
		'content' => array(
			'Config' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'session_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'request' => array(
		'content' => array(
			'params' => array(
				[maximum depth reached]
			),
			'url' => 'en/hotel-allgaeu-sonne-oberstaufen',
			'query' => array([maximum depth reached]),
			'data' => array([maximum depth reached]),
			'get' => array([maximum depth reached]),
			'currentRoute' => object(AliasRoute) {}
		),
		'elementName' => 'request_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'sql_log' => array(
		'content' => array(
			'connections' => array(
				[maximum depth reached]
			),
			'threshold' => (int) 20
		),
		'elementName' => 'sql_log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'timer' => array(
		'content' => null,
		'elementName' => 'timer_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'log' => array(
		'content' => object(DebugKitLog) {},
		'elementName' => 'log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'variables' => array(
		'content' => array(
			'row' => array(
				[maximum depth reached]
			),
			'isGerman' => false,
			'$request->data' => array([maximum depth reached])
		),
		'elementName' => 'variables_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'environment' => array(
		'content' => array(
			'php' => array(
				[maximum depth reached]
			),
			'cake' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'environment_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'include' => array(
		'content' => array(
			'core' => array([maximum depth reached]),
			'app' => array(
				[maximum depth reached]
			),
			'plugins' => array(
				[maximum depth reached]
			),
			'paths' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'include_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	)
)
$debugToolbarJavascript = array(
	'libs' => 'DebugKit./js/js_debug_toolbar'
)
$debugToolbarCss = array(
	(int) 0 => 'DebugKit./css/debug_toolbar.css'
)
$row = array(
	'PointI18n' => array(
		'id' => '268',
		'hash' => '61da83c86f45bd9d424f5dc506a97b1b',
		'created' => '2020-03-30 21:37:33',
		'updated' => '2021-06-25 12:26:18',
		'language_id' => '4',
		'point_id' => '150',
		'country' => '',
		'introduction_text' => '',
		'detail_text' => '<p>Situated on a sunny, south-facing slope above Oberstaufen, the 5-star Hotel Allg&auml;u Sonne has spectacular views of the Allg&auml;u mountains. And you too can enjoy them in what is probably German&#39;s most beautiful hotel gym. On offer every day from Monday to Saturday are up to 8 exercise classes and a guided walk, while relaxation awaits in the spa area featuring two indoor and one outdoor pool, a jacuzzi, a steamroom and a panoramic sauna.</p>

<p>The kitchen team specialises in creative regional dishes, and every evening there is live music and dancing. Among our 149 rooms and suites there are 65 single rooms, making Allg&auml;u Sonne the ideal destination for solo travellers and groups of friends.</p>
',
		'teaser_text' => '<p>Oberstaufen</p>

<p>Tel. +49 (0)8386 702 0</p>

<p>www.allgaeu-sonne.de</p>
',
		'image_title_1' => '',
		'image_title_2' => '',
		'image_title_3' => '',
		'image_title_4' => '',
		'image_title_5' => '',
		'image_title_6' => '',
		'image_title_7' => '',
		'title' => 'Hotel Allgäu Sonne Oberstaufen',
		'teaser_button' => 'read more',
		'previous_url' => null
	),
	'Point' => array(
		'id' => '150',
		'hash' => '12a171aa3cd67f947cf76d2f92e82758',
		'created' => '2020-03-30 21:28:08',
		'updated' => '2021-08-02 16:15:07',
		'status' => 'active',
		'title' => 'Allgäu Sonne',
		'content_type' => 'hotel',
		'category' => null,
		'teaser_title' => 'Hotel Allgäu Sonne',
		'top_tip' => true,
		'map_lat' => '47.550827',
		'map_long' => '10.013640',
		'street' => 'Stießberg 1',
		'zip_code' => '87534',
		'city' => 'Oberstaufen',
		'phone' => '+49 (0)8386 702 0',
		'website_url' => 'http://www.allgaeu-sonne.de',
		'email' => 'info@allgaeu-sonne.de',
		'region1' => 'Allgäu',
		'region2' => 'Allgäu Gipfelwelten',
		'region3' => '',
		'booking_link' => 'https://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_url' => 'https://goo.gl/maps/twShi5XJR5QEchy7A',
		'external_id' => null,
		'gmap_zoom' => '7',
		'fax' => '+49 (0)8386 702 7826',
		'weather_widget_code' => '',
		'hotels_gastronomy' => '15',
		'hotels_wellness' => '501',
		'hotels_parking' => '3',
		'hotels_car_rental' => '0',
		'hotels_oldtimer' => '4',
		'hotels_transfer' => 'free',
		'hotels_car_charging_possibility' => true,
		'hotels_distance_to_nearest_train_station' => '1.500000',
		'hotels_bike_rental' => '12',
		'hotels_car_rental_other_de' => '',
		'hotels_car_rental_other_it' => '',
		'hotels_car_rental_other_nl' => '',
		'hotels_car_rental_other_en' => '',
		'hotels_emobil' => true,
		'map' => '47.550827;10.013640',
		'Image1Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'Image2Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'Image3Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'Image4Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'Image5Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'Image6Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'Image7Upload' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'CityHotels' => array(),
		'CityPois' => array()
	),
	'Language' => array(
		'id' => '4',
		'hash' => '5fdcab58cbf42c343cfcd5bf2d59aa4a',
		'created' => '2016-07-11 13:49:59',
		'updated' => '2016-07-11 13:49:59',
		'title' => 'English',
		'langid' => 'en',
		'default' => false
	),
	'Route' => array(
		'id' => '810',
		'hash' => '3d45deb737cad6acae5b26a826b81b81',
		'created' => '2020-03-30 21:37:33',
		'updated' => '2021-06-25 12:26:18',
		'model' => 'PointI18n',
		'foreign_key' => '268',
		'base' => '/en/',
		'alias' => 'hotel-allgaeu-sonne-oberstaufen',
		'controller' => 'FrontendPoints.FrontendPoints',
		'action' => 'point',
		'parent_id' => '4',
		'lft' => '2036',
		'rght' => '2037',
		'route' => '/en/hotel-allgaeu-sonne-oberstaufen'
	),
	'Seo' => array(
		'id' => '773',
		'hash' => '12cf90fcb53c1f51588fb4b8bb792e12',
		'created' => '2020-03-30 21:37:33',
		'updated' => '2021-06-25 12:26:18',
		'model' => 'PointI18n',
		'foreign_key' => '268',
		'title' => '',
		'description' => '',
		'author' => '',
		'tw_creator' => '',
		'fb_author' => '',
		'robots' => '3',
		'internal_keywords' => ''
	)
)
$isGerman = false
$page = ''
$introduction = ''
$content = '<p>Situated on a sunny, south-facing slope above Oberstaufen, the 5-star Hotel Allg&auml;u Sonne has spectacular views of the Allg&auml;u mountains. And you too can enjoy them in what is probably German's most beautiful hotel gym. On offer every day from Monday to Saturday are up to 8 exercise classes and a guided walk, while relaxation awaits in the spa area featuring two indoor and one outdoor pool, a jacuzzi, a steamroom and a panoramic sauna.</p>

<p>The kitchen team specialises in creative regional dishes, and every evening there is live music and dancing. Among our 149 rooms and suites there are 65 single rooms, making Allg&auml;u Sonne the ideal destination for solo travellers and groups of friends.</p>
'
$type = 'Hotel'
$cityHotels = array()
$cityPois = array()
$galleryId = 'gallery-628a67b52c8d4'
$count = (int) 7
$i = (int) 8
$orig = array(
	'id' => '14442',
	'hash' => 'aeed4a75e3b0f6b96789e5a0466b14cf',
	'created' => '2020-03-30 21:30:57',
	'updated' => '2020-03-30 21:30:57',
	'model' => 'Point',
	'field' => 'image_7',
	'foreign_key' => '150',
	'alias' => 'hotel-allgaeu-sonne-aussicht-thpointgalleryresponsive.jpg',
	'thumbnail' => 'th-point-gallery-responsive',
	'parent_id' => '14434',
	'file' => 'webroot/files/Point/Image7/ThPointGalleryResponsive/5e8248f0f07cc.jpg',
	'size' => '53409',
	'ext' => '.jpg',
	'mime' => 'image/jpeg',
	'width' => '750',
	'height' => '462'
)
$thumbnail = array(
	'id' => '14442',
	'hash' => 'aeed4a75e3b0f6b96789e5a0466b14cf',
	'created' => '2020-03-30 21:30:57',
	'updated' => '2020-03-30 21:30:57',
	'model' => 'Point',
	'field' => 'image_7',
	'foreign_key' => '150',
	'alias' => 'hotel-allgaeu-sonne-aussicht-thpointgalleryresponsive.jpg',
	'thumbnail' => 'th-point-gallery-responsive',
	'parent_id' => '14434',
	'file' => 'webroot/files/Point/Image7/ThPointGalleryResponsive/5e8248f0f07cc.jpg',
	'size' => '53409',
	'ext' => '.jpg',
	'mime' => 'image/jpeg',
	'width' => '750',
	'height' => '462'
)
$image = '<img src="https://www.deutsche-alpenstrasse.de/cdn/uploads/hotel-allgaeu-sonne-aussicht-thpointgalleryresponsive.jpg" alt="Hotel Allgaeu Sonne Aussicht">'
$hotelFeatures = array(
	'gastronomy' => 'Gastronomie',
	'wellness' => 'Wellness',
	'parking' => 'Parken',
	'oldtimer' => 'Oldtimer'
)
$hotelFeature = 'Oldtimer'
$key = 'oldtimer'
$items = array(
	(int) 0 => 'E-Bike',
	(int) 1 => 'E-Mountainbike'
)
$item = 'E-Mountainbike'
$distance = '1.500000'
$transfer = 'free'
$carRental = '0'
$bikeRental = '12'
$chargingPossibility = true
$lat = '47.550827'
$lng = '10.013640'
$path = 'color:0x004e91|weight:5|47.550357,9.692343|47.552939895428,9.6926879882813|47.552679,9.701183|47.552873,9.703797|47.55549,9.705211|47.557617,9.70402|47.562858,9.702432|47.570406,9.705754|47.575267,9.709997|47.575395,9.712883|47.575496,9.727706|47.579781,9.738607|47.585918,9.750065|47.593848,9.76088|47.591916,9.768122|47.595895,9.777204|47.59787,9.804171|47.595539,9.811926|47.593275,9.814021|47.594712,9.815137|47.592734,9.815755|47.594069,9.816195|47.593147,9.816404|47.593552,9.818215|47.59438,9.819335|47.593104,9.822378|47.592279,9.827785|47.594432,9.836933|47.593314,9.83912|47.592174,9.845693|47.589669,9.85382|47.586725,9.856853|47.591484,9.858672|47.593509,9.863727|47.586777,9.869004|47.588354,9.877593|47.590282,9.883829|47.597687,9.893562|47.603779,9.909025|47.60577,9.920139|47.60319,9.93619|47.594293,9.943413|47.58505,9.936926|47.571451,9.928876|47.569126,9.938764|47.565534,9.952939|47.56199,9.96673|47.554736,9.979312|47.555916,9.991878|47.547802,9.989009|47.542341,9.988879|47.546728,9.997818|47.54898,10.010627|47.552416,10.023245|47.549211,10.028447|47.549621,10.037733|47.551134,10.046046|47.554472,10.055751|47.554239,10.074047|47.55721,10.093416|47.557394,10.111924|47.559636,10.129765|47.564237,10.152149|47.567826,10.171629|47.569095,10.184587|47.567459,10.192606|47.562993,10.201903|47.560372,10.209096|47.559386,10.214829|47.558398,10.221083|47.554476,10.231485|47.554473,10.244622|47.556687,10.24985|47.538483,10.267281|47.519409,10.2685|47.520402,10.274273|47.517412,10.287198|47.510337,10.295348|47.506667,10.311177|47.504059,10.325229|47.503322,10.340924|47.504384,10.364555|47.507279,10.3812|47.506641,10.383638|47.505824,10.386743|47.50683,10.390655|47.506345,10.387863|47.508131,10.387035|47.509239,10.385574|47.510359,10.383041|47.509839,10.387719|47.510953,10.38554|47.512491,10.383794|47.511433,10.38625|47.511584,10.386926|47.511852,10.387464|47.510085,10.390605|47.510668,10.393714|47.51107,10.393083|47.510916,10.390745|47.512054,10.393977|47.514628,10.401542|47.51932,10.410045|47.52522,10.413558|47.53074,10.415074|47.535623,10.412692|47.543373,10.420167|47.54988,10.424667|47.55881,10.432217|47.5671,10.432957|47.571982,10.430742|47.575863,10.428625|47.582035,10.419726|47.583298,10.41211|47.58635,10.4102|47.594247,10.415886|47.601662,10.422119|47.602906,10.430102|47.609197,10.446452|47.611875,10.45701|47.616372,10.469111|47.617876,10.482071|47.619901,10.487908|47.623157,10.493851|47.624526,10.499618|47.623376,10.497513|47.621026,10.503289|47.618534,10.511868|47.616694,10.514859|47.608567,10.531117|47.604181,10.536872|47.600283,10.5471|47.595858,10.552898|47.595433,10.557439|47.597186,10.561253|47.59506,10.566563|47.592296,10.573938|47.585814,10.586785|47.578263,10.60974|47.57445,10.623629|47.577649,10.627596|47.573925,10.637773|47.572663,10.646926|47.576202,10.668828|47.582049,10.696391|47.583275,10.707308|47.569753,10.700575|47.567575,10.706481|47.569915,10.722917|47.574708,10.733946|47.585707,10.762257|47.592647,10.777585|47.597752,10.786312|47.603611,10.794761|47.617446,10.807952|47.632418,10.821223|47.648994,10.830887|47.658418,10.841273|47.66904,10.85255|47.682288,10.858353|47.695551,10.860998|47.704092,10.865432|47.702089,10.873529|47.702658,10.883922|47.701912,10.903082|47.70397,10.922379|47.704209,10.938327|47.706838,10.946899|47.709608,10.956767|47.709072,10.968379|47.708556,10.979961|47.697089,10.983213|47.684395,11.01024|47.67362,11.024951|47.664314,11.025036|47.648051,11.024851|47.627884,11.03245|47.612782,11.031022|47.604552,11.03722|47.59648,11.052111|47.589742,11.065685|47.582288,11.074209|47.575438,11.078548|47.568829,11.089083|47.564236,11.100589|47.560896,11.102339|47.562536,11.103661|47.560394,11.115197|47.562202,11.122698|47.565469,11.13023|47.564376,11.129682|47.559885,11.131099|47.555814,11.136955|47.540313,11.118252|47.52519,11.123045|47.513883,11.107694|47.510432,11.10725|47.498412,11.101026|47.490281,11.111914|47.484045,11.120993|47.485785,11.131187|47.485384,11.135843|47.486934,11.153139|47.489053,11.173842|47.488048,11.189832|47.489875,11.204252|47.487816,11.225366|47.482819,11.240763|47.489061,11.251805|47.499443,11.263217|47.497464,11.273801|47.497745,11.27278|47.499784,11.27791|47.512787,11.280266|47.52136,11.281473|47.525877,11.285273|47.535235,11.285409|47.545697,11.290855|47.556229,11.292678|47.563997,11.295375|47.569445,11.299223|47.571318,11.301289|47.57511,11.303217|47.58091,11.304274|47.584093,11.307769|47.587546,11.310178|47.591322,11.317338|47.596918,11.317882|47.599582,11.32658|47.60573,11.334924|47.613635,11.338855|47.617889,11.345829|47.618815,11.347141|47.619983,11.34939|47.621551,11.349082|47.625653,11.355153|47.626076,11.354351|47.627842,11.355322|47.630466,11.354013|47.63263,11.355963|47.632664,11.353107|47.631393,11.352391|47.633818,11.354074|47.634311,11.351595|47.636309,11.356525|47.636401,11.355708|47.63647,11.354602|47.638387,11.351631|47.641784,11.359104|47.64732,11.364206|47.649865,11.362428|47.655843,11.363364|47.660093,11.369889|47.664937,11.381449|47.670926,11.391987|47.683588,11.401363|47.691753,11.406309|47.700508,11.405639|47.714183,11.413602|47.721336,11.399687|47.726648,11.406983|47.725669,11.420565|47.730436,11.432329|47.737909,11.449117|47.745962,11.462808|47.746759,11.478166|47.748366,11.504668|47.751583,11.527946|47.755743,11.543758|47.75451,11.556921|47.749474,11.564276|47.739833,11.565849|47.724521,11.565819|47.706904,11.562473|47.690514,11.566996|47.680036,11.572436|47.669031,11.576869|47.660561,11.58492|47.652825,11.588458|47.642517,11.592549|47.628426,11.59406|47.613492,11.587844|47.603076,11.577693|47.597286,11.563088|47.590475,11.547118|47.586433,11.547865|47.585448,11.552136|47.585283,11.576312|47.58268,11.59639|47.581648,11.610174|47.584254,11.625354|47.582587,11.633698|47.588154,11.632356|47.593837,11.634849|47.598578,11.636616|47.604997,11.636265|47.609317,11.643728|47.613127,11.653834|47.611267,11.665494|47.616485,11.683257|47.619656,11.702106|47.623101,11.722434|47.622771,11.732698|47.627099,11.746763|47.639163,11.744591|47.653181,11.747828|47.668917,11.758679|47.680096,11.758891|47.687231,11.760285|47.692937,11.770414|47.699406,11.769069|47.70554,11.759442|47.709971,11.752415|47.716129,11.753545|47.725761,11.744016|47.734615,11.73818|47.744074,11.74201|47.746331,11.75747|47.747388,11.770999|47.750873,11.790004|47.754085,11.813195|47.752345,11.829132|47.752097,11.8367|47.747601,11.842153|47.738989,11.85229|47.736164,11.861043|47.732662,11.866693|47.725291,11.869519|47.720183,11.869065|47.714545,11.87067|47.708258,11.873771|47.703008,11.882036|47.70466,11.909773|47.700604,11.934344|47.690377,11.9726|47.679455,12.001692|47.671258,12.019184|47.678904,12.017322|47.681699,12.013474|47.680178,12.015244|47.681619,12.022316|47.679076,12.031444|47.680863,12.034006|47.684483,12.037829|47.684071,12.044494|47.681572,12.054338|47.686556,12.056025|47.678084,12.063724|47.674812,12.067478|47.672551,12.070725|47.671756,12.074288|47.67226,12.077779|47.670211,12.073863|47.671724,12.080699|47.675439,12.083452|47.673559,12.084142|47.671733,12.088079|47.669096,12.092792|47.668623,12.10084|47.666138,12.108754|47.665101,12.115509|47.659887,12.119575|47.658011,12.122603|47.657623,12.130127|47.660847,12.136709|47.661871,12.141529|47.661294,12.149008|47.6604,12.155427|47.660497,12.161846|47.661779,12.170711|47.669764,12.167787|47.678769,12.157296|47.685416,12.15415|47.689944,12.155383|47.694828,12.155388|47.701703,12.153963|47.712059,12.144253|47.719702,12.129759|47.726269,12.119779|47.732878,12.108142|47.735318,12.114654|47.738392,12.129565|47.743002,12.148154|47.743236,12.156714|47.746425,12.151644|47.753745,12.14451|47.758749,12.139359|47.767194,12.141156|47.772309,12.139689|47.774741,12.142356|47.78074,12.147003|47.787524,12.152133|47.791176,12.162044|47.792811,12.171681|47.793188,12.187495|47.791459,12.193341|47.793157,12.20008|47.795106,12.20401|47.795484,12.221512|47.795295,12.226378|47.796678,12.232274|47.796804,12.239294|47.797842,12.247298|47.797541,12.254952|47.799037,12.262929|47.800923,12.271446|47.802935,12.283614|47.802872,12.29129|47.796121,12.29803|47.79255,12.306932|47.781989,12.319812|47.78052,12.324278|47.783059,12.328096|47.784364,12.331703|47.791484,12.341872|47.797263,12.348311|47.802545,12.353728|47.807111,12.360908|47.810062,12.369438|47.810531,12.376501|47.803459,12.381502|47.800806,12.392021|47.795661,12.405704|47.790734,12.418207|47.78674,12.424279|47.780796,12.43726|47.778248,12.447106|47.778557,12.451608|47.778366,12.45739|47.778657,12.469754|47.77769,12.475575|47.769772,12.4667|47.762384,12.463396|47.756517,12.462999|47.752266,12.463624|47.745879,12.467362|47.740319,12.462639|47.736975,12.4567|47.732694,12.460526|47.729173,12.466014|47.724705,12.468337|47.722839,12.469332|47.719991,12.476433|47.715095,12.475778|47.709579,12.480791|47.70516,12.482066|47.700508,12.478805|47.698175,12.483467|47.69317,12.482386|47.688718,12.488794|47.690325,12.500574|47.681041,12.500959|47.675741,12.487037|47.676073,12.472504|47.67742,12.469745|47.67603,12.471657|47.672456,12.473047|47.671088,12.482214|47.668526,12.494976|47.66456,12.505724|47.660159,12.524742|47.657851,12.532946|47.662968,12.542985|47.672654,12.54703|47.681771,12.5495|47.688431,12.572735|47.689656,12.591037|47.692694,12.601445|47.703035,12.616664|47.711747,12.625507|47.715183,12.642614|47.727819,12.66054|47.735445,12.66062|47.741241,12.667407|47.748112,12.674469|47.75431,12.695118|47.751211,12.720577|47.747303,12.731002|47.752004,12.733068|47.749552,12.748045|47.739734,12.754746|47.731178,12.753921|47.719044,12.772653|47.711904,12.788709|47.706314,12.798444|47.703838,12.802259|47.697963,12.801387|47.690304,12.802386|47.687096,12.809698|47.683626,12.817703|47.676866,12.82253|47.673019,12.827117|47.668218,12.834794|47.659803,12.847195|47.649437,12.850004|47.636317,12.856449|47.627452,12.877542|47.61988,12.878645|47.613757,12.89634|47.612938,12.902227|47.609554,12.910409|47.609689,12.901282|47.604904,12.913338|47.602867,12.926825|47.604892,12.93468|47.610219,12.942631|47.614141,12.951498|47.61749,12.965976|47.61969,12.975758|47.625933,12.986512|47.62563,12.996725|47.62267,13.001073|47.614665,13.000442|47.605207,12.992722|47.597341,12.989265|47.592088,12.987181'
$counter = (int) 2582
$stagePoint = array(
	'lat' => (float) 47.590402,
	'lng' => (float) 12.988404
)
$modalMapId = 'point_map'
include - APP/Plugin/FrontendPoints/View/FrontendPoints/point.php, line 392
View::_evaluate() - APP/contrance/Vendor/Cake/lib/Cake/View/View.php, line 971
View::_render() - APP/contrance/Vendor/Cake/lib/Cake/View/View.php, line 933
View::render() - APP/contrance/Vendor/Cake/lib/Cake/View/View.php, line 473
Controller::render() - APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 143

Show Map

Hotel Allgäu Sonne Oberstaufen

Stießberg 1
87534 Oberstaufen

Tel: +49 (0)8386 702 0
info@allgaeu-sonne.de
www.allgaeu-sonne.de

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.

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`))) = '/en/hotel-allgaeu-sonne-oberstaufen' LIMIT 1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`lft` <= 2036 AND `Route`.`rght` >= 2037 ORDER BY `Route`.`lft` asc	2	2
SELECT `Language`.`langid` FROM `deutsche_alpenstr2019`.`languages` AS `Language` WHERE `Language`.`id` = 4 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 `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 `Language`.`langid` = 'de' LIMIT 1	1	1
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` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`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`, `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`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`PointI18n`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `PointI18n`.`id` AND `Seo`.`model` = 'PointI18n') WHERE `PointI18n`.`id` = 268 AND `Point`.`status` = 'active' LIMIT 1	1	1
SELECT `Image1Upload`.`id`, `Image1Upload`.`hash`, `Image1Upload`.`created`, `Image1Upload`.`updated`, `Image1Upload`.`model`, `Image1Upload`.`field`, `Image1Upload`.`foreign_key`, `Image1Upload`.`alias`, `Image1Upload`.`thumbnail`, `Image1Upload`.`parent_id`, `Image1Upload`.`file`, `Image1Upload`.`size`, `Image1Upload`.`ext`, `Image1Upload`.`mime`, `Image1Upload`.`width`, `Image1Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image1Upload` WHERE `Image1Upload`.`model` = 'Point' AND `Image1Upload`.`field` = 'image_1' AND `Image1Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image1Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Image2Upload`.`id`, `Image2Upload`.`hash`, `Image2Upload`.`created`, `Image2Upload`.`updated`, `Image2Upload`.`model`, `Image2Upload`.`field`, `Image2Upload`.`foreign_key`, `Image2Upload`.`alias`, `Image2Upload`.`thumbnail`, `Image2Upload`.`parent_id`, `Image2Upload`.`file`, `Image2Upload`.`size`, `Image2Upload`.`ext`, `Image2Upload`.`mime`, `Image2Upload`.`width`, `Image2Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image2Upload` WHERE `Image2Upload`.`model` = 'Point' AND `Image2Upload`.`field` = 'image_2' AND `Image2Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image2Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Image3Upload`.`id`, `Image3Upload`.`hash`, `Image3Upload`.`created`, `Image3Upload`.`updated`, `Image3Upload`.`model`, `Image3Upload`.`field`, `Image3Upload`.`foreign_key`, `Image3Upload`.`alias`, `Image3Upload`.`thumbnail`, `Image3Upload`.`parent_id`, `Image3Upload`.`file`, `Image3Upload`.`size`, `Image3Upload`.`ext`, `Image3Upload`.`mime`, `Image3Upload`.`width`, `Image3Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image3Upload` WHERE `Image3Upload`.`model` = 'Point' AND `Image3Upload`.`field` = 'image_3' AND `Image3Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image3Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Image4Upload`.`id`, `Image4Upload`.`hash`, `Image4Upload`.`created`, `Image4Upload`.`updated`, `Image4Upload`.`model`, `Image4Upload`.`field`, `Image4Upload`.`foreign_key`, `Image4Upload`.`alias`, `Image4Upload`.`thumbnail`, `Image4Upload`.`parent_id`, `Image4Upload`.`file`, `Image4Upload`.`size`, `Image4Upload`.`ext`, `Image4Upload`.`mime`, `Image4Upload`.`width`, `Image4Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image4Upload` WHERE `Image4Upload`.`model` = 'Point' AND `Image4Upload`.`field` = 'image_4' AND `Image4Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image4Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Image5Upload`.`id`, `Image5Upload`.`hash`, `Image5Upload`.`created`, `Image5Upload`.`updated`, `Image5Upload`.`model`, `Image5Upload`.`field`, `Image5Upload`.`foreign_key`, `Image5Upload`.`alias`, `Image5Upload`.`thumbnail`, `Image5Upload`.`parent_id`, `Image5Upload`.`file`, `Image5Upload`.`size`, `Image5Upload`.`ext`, `Image5Upload`.`mime`, `Image5Upload`.`width`, `Image5Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image5Upload` WHERE `Image5Upload`.`model` = 'Point' AND `Image5Upload`.`field` = 'image_5' AND `Image5Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image5Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Image6Upload`.`id`, `Image6Upload`.`hash`, `Image6Upload`.`created`, `Image6Upload`.`updated`, `Image6Upload`.`model`, `Image6Upload`.`field`, `Image6Upload`.`foreign_key`, `Image6Upload`.`alias`, `Image6Upload`.`thumbnail`, `Image6Upload`.`parent_id`, `Image6Upload`.`file`, `Image6Upload`.`size`, `Image6Upload`.`ext`, `Image6Upload`.`mime`, `Image6Upload`.`width`, `Image6Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image6Upload` WHERE `Image6Upload`.`model` = 'Point' AND `Image6Upload`.`field` = 'image_6' AND `Image6Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image6Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `Image7Upload`.`id`, `Image7Upload`.`hash`, `Image7Upload`.`created`, `Image7Upload`.`updated`, `Image7Upload`.`model`, `Image7Upload`.`field`, `Image7Upload`.`foreign_key`, `Image7Upload`.`alias`, `Image7Upload`.`thumbnail`, `Image7Upload`.`parent_id`, `Image7Upload`.`file`, `Image7Upload`.`size`, `Image7Upload`.`ext`, `Image7Upload`.`mime`, `Image7Upload`.`width`, `Image7Upload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `Image7Upload` WHERE `Image7Upload`.`model` = 'Point' AND `Image7Upload`.`field` = 'image_7' AND `Image7Upload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`Image7Upload`.`thumbnail`, -1), -1) DESC	2	2
SELECT `CityHotels`.`id`, `CityHotels`.`hash`, `CityHotels`.`created`, `CityHotels`.`updated`, `CityHotels`.`status`, `CityHotels`.`title`, `CityHotels`.`content_type`, `CityHotels`.`category`, `CityHotels`.`teaser_title`, `CityHotels`.`top_tip`, `CityHotels`.`map_lat`, `CityHotels`.`map_long`, `CityHotels`.`street`, `CityHotels`.`zip_code`, `CityHotels`.`city`, `CityHotels`.`phone`, `CityHotels`.`website_url`, `CityHotels`.`email`, `CityHotels`.`region1`, `CityHotels`.`region2`, `CityHotels`.`region3`, `CityHotels`.`booking_link`, `CityHotels`.`gmap_url`, `CityHotels`.`external_id`, `CityHotels`.`gmap_zoom`, `CityHotels`.`fax`, `CityHotels`.`weather_widget_code`, `CityHotels`.`hotels_gastronomy`, `CityHotels`.`hotels_wellness`, `CityHotels`.`hotels_parking`, `CityHotels`.`hotels_car_rental`, `CityHotels`.`hotels_oldtimer`, `CityHotels`.`hotels_transfer`, `CityHotels`.`hotels_car_charging_possibility`, `CityHotels`.`hotels_distance_to_nearest_train_station`, `CityHotels`.`hotels_bike_rental`, `CityHotels`.`hotels_car_rental_other_de`, `CityHotels`.`hotels_car_rental_other_it`, `CityHotels`.`hotels_car_rental_other_nl`, `CityHotels`.`hotels_car_rental_other_en`, `CityHotels`.`hotels_emobil`, (CONCAT_WS (';',`CityHotels`.`map_lat`,`CityHotels`.`map_long`)) AS `CityHotels__map`, `HotelsForPoint`.`id`, `HotelsForPoint`.`hotel_id`, `HotelsForPoint`.`point_id`, `HotelsForPoint`.`position` FROM `deutsche_alpenstr2019`.`points` AS `CityHotels` JOIN `deutsche_alpenstr2019`.`hotels_for_point` AS `HotelsForPoint` ON (`HotelsForPoint`.`hotel_id` = 150 AND `HotelsForPoint`.`point_id` = `CityHotels`.`id`) ORDER BY `HotelsForPoint`.`position` ASC	0	0
SELECT `CityPois`.`id`, `CityPois`.`hash`, `CityPois`.`created`, `CityPois`.`updated`, `CityPois`.`status`, `CityPois`.`title`, `CityPois`.`content_type`, `CityPois`.`category`, `CityPois`.`teaser_title`, `CityPois`.`top_tip`, `CityPois`.`map_lat`, `CityPois`.`map_long`, `CityPois`.`street`, `CityPois`.`zip_code`, `CityPois`.`city`, `CityPois`.`phone`, `CityPois`.`website_url`, `CityPois`.`email`, `CityPois`.`region1`, `CityPois`.`region2`, `CityPois`.`region3`, `CityPois`.`booking_link`, `CityPois`.`gmap_url`, `CityPois`.`external_id`, `CityPois`.`gmap_zoom`, `CityPois`.`fax`, `CityPois`.`weather_widget_code`, `CityPois`.`hotels_gastronomy`, `CityPois`.`hotels_wellness`, `CityPois`.`hotels_parking`, `CityPois`.`hotels_car_rental`, `CityPois`.`hotels_oldtimer`, `CityPois`.`hotels_transfer`, `CityPois`.`hotels_car_charging_possibility`, `CityPois`.`hotels_distance_to_nearest_train_station`, `CityPois`.`hotels_bike_rental`, `CityPois`.`hotels_car_rental_other_de`, `CityPois`.`hotels_car_rental_other_it`, `CityPois`.`hotels_car_rental_other_nl`, `CityPois`.`hotels_car_rental_other_en`, `CityPois`.`hotels_emobil`, (CONCAT_WS (';',`CityPois`.`map_lat`,`CityPois`.`map_long`)) AS `CityPois__map`, `PoisForPoint`.`id`, `PoisForPoint`.`poi_id`, `PoisForPoint`.`point_id`, `PoisForPoint`.`position` FROM `deutsche_alpenstr2019`.`points` AS `CityPois` JOIN `deutsche_alpenstr2019`.`pois_for_point` AS `PoisForPoint` ON (`PoisForPoint`.`poi_id` = 150 AND `PoisForPoint`.`point_id` = `CityPois`.`id`) ORDER BY `PoisForPoint`.`position` 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` = 'metaa' AND `Language`.`langid` = 'en' 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` > 325 AND `Menu`.`rght` < 438 ORDER BY `Menu`.`lft` asc	55	55
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` = 'en' 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` = 60 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` = 142 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` = (170) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11
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` = 142 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` = 60 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` = 60 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` = 'en' 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` > 564 AND `Menu`.`rght` < 569 ORDER BY `Menu`.`lft` asc	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` = 'service' AND `Language`.`langid` = 'en' 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` > 436 AND `Menu`.`rght` < 437 ORDER BY `Menu`.`lft` asc	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `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` = 'PointI18n' AND `Seo`.`foreign_key` = 268 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` = 773 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` = 'en' 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` = 61 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` = 143 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` = 143 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` = 61 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` = 61 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` = 61 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` = 'en' 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` = 'en' 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` = 'en' 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` = '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`, `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`, `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` = 'en' 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	0	0

Message	Memory use
Component initialization	9.81 MB
Controller action start	11.04 MB
Controller render start	12.88 MB
View render complete	18.66 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	104.63
Event: Controller.initialize	12.04
Event: Controller.startup	2.19
Controller action	41.40
Event: Controller.beforeRender	120.01
» Processing toolbar data	32.39
Rendering View	57.67
» Event: View.beforeRender	0.42
» Rendering APP/Plugin/FrontendPoints/View/FrontendPoints/point.php	31.01
» Rendering APP/Plugin/FrontendPoints/View/FrontendPoints/base.php	0.44
» Event: View.afterRender	0.12
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/index.php	22.44
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	2.39
» » Rendering APP/View/Elements/subpages-heading.php	1.45
» » Rendering APP/View/Elements/footer-links.php	2.05
» » Rendering APP/View/Elements/contact-partners.php	0.38
Event: View.afterLayout	0.00

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

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/