Arabella Brauneck Hotel Lenggries

Arabella Brauneck Drohne Hotel Aussen Web

Enjoy an unforgettable holiday at Arabella Brauneck Hotel in Lenggries, located at the foot of Mount Brauneck in the heart of the Isarwinkel region. The hotel has 108 rooms and mini-apartments, a beer garden, cocktail bar, the Leonhardi Stuben restaurant, which specialises in regional cuisine, and the Kamin-Stub'n bar, which can also be hired for private events. The sauna and gym are the perfect place to relax after a tour on the German Alpine Road.

Enjoy an unforgettable holiday in the most beautiful part of Upper Bavaria. Whether you opt for a walk or cycle tour through unspoilt river plains, a rafting tour on the Isar river, a ride on the Mount Brauneck cable car up to the traditional mountain huts or a round of golf surrounded by picturesque nature, the amazing scenery and the majestic mountains provide all the ingredients for the perfect active holiday in the Isarwinkel region.

Gastronomie

Restaurant
Bar
Regionale Produkte
Biergarten

Wellness

Sauna
Fitnessraum

Parken

Hauseigener Parkplatz
Eigene Garage

Mobilität & Elektromobilität

Entfernung zum nächsten Bahnhof 0,70 km
Transfer/Abholung vom/zum nächsten Bahnhof: Gegen Gebühr

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' => '747',
			'hash' => '564ab62ad5bb25eb5cf97c37409e240a',
			'created' => '2020-03-24 21:01:51',
			'updated' => '2020-07-15 09:39:08',
			'model' => 'PointI18n',
			'foreign_key' => '243',
			'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' => '243',
			'hash' => 'a7718833da9bf0c22f1f556529e51207',
			'created' => '2020-03-24 21:01:51',
			'updated' => '2020-07-15 09:39:08',
			'language_id' => '4',
			'point_id' => '140',
			'country' => '',
			'introduction_text' => '',
			'detail_text' => '<p>Enjoy an unforgettable holiday at Arabella Brauneck Hotel in Lenggries, located at the foot of Mount Brauneck in the heart of the Isarwinkel region. The hotel has 108 rooms and mini-apartments, a beer garden, cocktail bar, the Leonhardi Stuben restaurant, which specialises in regional cuisine, and the Kamin-Stub&#39;n bar, which can also be hired for private events. The sauna and gym are the perfect place to relax after a tour on the German Alpine Road.</p>

<p>Enjoy an unforgettable holiday in the most beautiful part of Upper Bavaria. Whether you opt for a walk or cycle tour through unspoilt river plains, a rafting tour on the Isar river, a ride on the Mount Brauneck cable car up to the traditional mountain huts or a round of golf surrounded by picturesque nature, the amazing scenery and the majestic mountains provide all the ingredients for the perfect active holiday in the Isarwinkel region.</p>
',
			'teaser_text' => '<p>Araballa Brauneck Hotel</p>

<p>Tel. +49(0)8042 5020</p>

<p>www.arabella-brauneckhotel.com</p>
',
			'image_title_1' => 'Arabella Brauneck Hotel',
			'image_title_2' => 'Arabella Brauneck Hotel',
			'image_title_3' => 'Arabella Brauneck Hotel',
			'image_title_4' => 'Arabella Brauneck Hotel',
			'image_title_5' => 'Arabella Brauneck Hotel',
			'image_title_6' => 'Arabella Brauneck Hotel',
			'image_title_7' => '',
			'title' => 'Arabella Brauneck Hotel Lenggries',
			'teaser_button' => 'weiterlesen',
			'previous_url' => null
		),
		'Point' => array(
			'id' => '140',
			'hash' => 'efc16e27c9c5fb075ca8002004790eee',
			'created' => '2020-03-21 17:33:40',
			'updated' => '2021-06-21 11:49:52',
			'status' => 'active',
			'title' => 'Arabella Brauneck Hotel',
			'content_type' => 'hotel',
			'category' => null,
			'teaser_title' => 'Arabella Brauneck Hotel',
			'top_tip' => false,
			'map_lat' => '47.686405',
			'map_long' => '11.572733',
			'street' => 'Münchner Straße 25',
			'zip_code' => '83661',
			'city' => 'Lenggries',
			'phone' => '+49 (0) 8042 5020',
			'website_url' => 'http://www.arabella-brauneckhotel.com',
			'email' => '',
			'region1' => 'Oberbayern',
			'region2' => 'Tölzer Land',
			'region3' => '',
			'booking_link' => 'https://reservations.travelclick.com/76237?Languageid=7&DateOut=&DateIn=&Locale=de&Rooms=1&adults=2&_ga=&Hotelid=76237#/datesofstay',
			'gmap_url' => 'https://g.page/Arabella-Brauneck-Hotel?share',
			'external_id' => null,
			'gmap_zoom' => '7',
			'fax' => '',
			'weather_widget_code' => '',
			'hotels_gastronomy' => '29',
			'hotels_wellness' => '272',
			'hotels_parking' => '3',
			'hotels_car_rental' => '0',
			'hotels_oldtimer' => '0',
			'hotels_transfer' => 'paid',
			'hotels_car_charging_possibility' => true,
			'hotels_distance_to_nearest_train_station' => '0.700000',
			'hotels_bike_rental' => '0',
			'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.686405;11.572733',
			'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' => '784',
			'hash' => '2f0dae6c07b858b99b7cc6a61d141304',
			'created' => '2020-03-24 21:01:51',
			'updated' => '2020-07-15 09:39:08',
			'model' => 'PointI18n',
			'foreign_key' => '243',
			'base' => '/en/',
			'alias' => 'arabella-brauneck-hotel-lenggries',
			'controller' => 'FrontendPoints.FrontendPoints',
			'action' => 'point',
			'parent_id' => '4',
			'lft' => '2024',
			'rght' => '2025',
			'route' => '/en/arabella-brauneck-hotel-lenggries'
		),
		'Seo' => array(
			'id' => '747',
			'hash' => '564ab62ad5bb25eb5cf97c37409e240a',
			'created' => '2020-03-24 21:01:51',
			'updated' => '2020-07-15 09:39:08',
			'model' => 'PointI18n',
			'foreign_key' => '243',
			'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' => '747',
		'hash' => '564ab62ad5bb25eb5cf97c37409e240a',
		'created' => '2020-03-24 21:01:51',
		'updated' => '2020-07-15 09:39:08',
		'model' => 'PointI18n',
		'foreign_key' => '243',
		'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/arabella-brauneck-hotel-lenggries',
			'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' => '243',
		'hash' => 'a7718833da9bf0c22f1f556529e51207',
		'created' => '2020-03-24 21:01:51',
		'updated' => '2020-07-15 09:39:08',
		'language_id' => '4',
		'point_id' => '140',
		'country' => '',
		'introduction_text' => '',
		'detail_text' => '<p>Enjoy an unforgettable holiday at Arabella Brauneck Hotel in Lenggries, located at the foot of Mount Brauneck in the heart of the Isarwinkel region. The hotel has 108 rooms and mini-apartments, a beer garden, cocktail bar, the Leonhardi Stuben restaurant, which specialises in regional cuisine, and the Kamin-Stub&#39;n bar, which can also be hired for private events. The sauna and gym are the perfect place to relax after a tour on the German Alpine Road.</p>

<p>Enjoy an unforgettable holiday in the most beautiful part of Upper Bavaria. Whether you opt for a walk or cycle tour through unspoilt river plains, a rafting tour on the Isar river, a ride on the Mount Brauneck cable car up to the traditional mountain huts or a round of golf surrounded by picturesque nature, the amazing scenery and the majestic mountains provide all the ingredients for the perfect active holiday in the Isarwinkel region.</p>
',
		'teaser_text' => '<p>Araballa Brauneck Hotel</p>

<p>Tel. +49(0)8042 5020</p>

<p>www.arabella-brauneckhotel.com</p>
',
		'image_title_1' => 'Arabella Brauneck Hotel',
		'image_title_2' => 'Arabella Brauneck Hotel',
		'image_title_3' => 'Arabella Brauneck Hotel',
		'image_title_4' => 'Arabella Brauneck Hotel',
		'image_title_5' => 'Arabella Brauneck Hotel',
		'image_title_6' => 'Arabella Brauneck Hotel',
		'image_title_7' => '',
		'title' => 'Arabella Brauneck Hotel Lenggries',
		'teaser_button' => 'weiterlesen',
		'previous_url' => null
	),
	'Point' => array(
		'id' => '140',
		'hash' => 'efc16e27c9c5fb075ca8002004790eee',
		'created' => '2020-03-21 17:33:40',
		'updated' => '2021-06-21 11:49:52',
		'status' => 'active',
		'title' => 'Arabella Brauneck Hotel',
		'content_type' => 'hotel',
		'category' => null,
		'teaser_title' => 'Arabella Brauneck Hotel',
		'top_tip' => false,
		'map_lat' => '47.686405',
		'map_long' => '11.572733',
		'street' => 'Münchner Straße 25',
		'zip_code' => '83661',
		'city' => 'Lenggries',
		'phone' => '+49 (0) 8042 5020',
		'website_url' => 'http://www.arabella-brauneckhotel.com',
		'email' => '',
		'region1' => 'Oberbayern',
		'region2' => 'Tölzer Land',
		'region3' => '',
		'booking_link' => 'https://reservations.travelclick.com/76237?Languageid=7&DateOut=&DateIn=&Locale=de&Rooms=1&adults=2&_ga=&Hotelid=76237#/datesofstay',
		'gmap_url' => 'https://g.page/Arabella-Brauneck-Hotel?share',
		'external_id' => null,
		'gmap_zoom' => '7',
		'fax' => '',
		'weather_widget_code' => '',
		'hotels_gastronomy' => '29',
		'hotels_wellness' => '272',
		'hotels_parking' => '3',
		'hotels_car_rental' => '0',
		'hotels_oldtimer' => '0',
		'hotels_transfer' => 'paid',
		'hotels_car_charging_possibility' => true,
		'hotels_distance_to_nearest_train_station' => '0.700000',
		'hotels_bike_rental' => '0',
		'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.686405;11.572733',
		'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(),
		'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' => '784',
		'hash' => '2f0dae6c07b858b99b7cc6a61d141304',
		'created' => '2020-03-24 21:01:51',
		'updated' => '2020-07-15 09:39:08',
		'model' => 'PointI18n',
		'foreign_key' => '243',
		'base' => '/en/',
		'alias' => 'arabella-brauneck-hotel-lenggries',
		'controller' => 'FrontendPoints.FrontendPoints',
		'action' => 'point',
		'parent_id' => '4',
		'lft' => '2024',
		'rght' => '2025',
		'route' => '/en/arabella-brauneck-hotel-lenggries'
	),
	'Seo' => array(
		'id' => '747',
		'hash' => '564ab62ad5bb25eb5cf97c37409e240a',
		'created' => '2020-03-24 21:01:51',
		'updated' => '2020-07-15 09:39:08',
		'model' => 'PointI18n',
		'foreign_key' => '243',
		'title' => '',
		'description' => '',
		'author' => '',
		'tw_creator' => '',
		'fb_author' => '',
		'robots' => '3',
		'internal_keywords' => ''
	)
)
$isGerman = false
$page = ''
$introduction = ''
$content = '<p>Enjoy an unforgettable holiday at Arabella Brauneck Hotel in Lenggries, located at the foot of Mount Brauneck in the heart of the Isarwinkel region. The hotel has 108 rooms and mini-apartments, a beer garden, cocktail bar, the Leonhardi Stuben restaurant, which specialises in regional cuisine, and the Kamin-Stub'n bar, which can also be hired for private events. The sauna and gym are the perfect place to relax after a tour on the German Alpine Road.</p>

<p>Enjoy an unforgettable holiday in the most beautiful part of Upper Bavaria. Whether you opt for a walk or cycle tour through unspoilt river plains, a rafting tour on the Isar river, a ride on the Mount Brauneck cable car up to the traditional mountain huts or a round of golf surrounded by picturesque nature, the amazing scenery and the majestic mountains provide all the ingredients for the perfect active holiday in the Isarwinkel region.</p>
'
$type = 'Hotel'
$cityHotels = array()
$cityPois = array()
$galleryId = 'gallery-628a6379c4fad'
$count = (int) 6
$i = (int) 8
$orig = null
$thumbnail = null
$image = '<img src="https://www.deutsche-alpenstrasse.de/cdn/uploads/arabella-brauneck-grasleitn-klein-thpointgalleryresponsive.jpg" alt="Arabella Brauneck Grasleitn Klein">'
$hotelFeatures = array(
	'gastronomy' => 'Gastronomie',
	'wellness' => 'Wellness',
	'parking' => 'Parken',
	'oldtimer' => 'Oldtimer'
)
$hotelFeature = 'Oldtimer'
$key = 'oldtimer'
$items = array(
	(int) 0 => 'Hauseigener Parkplatz',
	(int) 1 => 'Eigene Garage'
)
$item = 'Eigene Garage'
$distance = '0.700000'
$transfer = 'paid'
$carRental = '0'
$bikeRental = '0'
$chargingPossibility = true
$lat = '47.686405'
$lng = '11.572733'
$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

Arabella Brauneck Hotel Lenggries

Münchner Straße 25
83661 Lenggries

Tel: +49 (0) 8042 5020
www.arabella-brauneckhotel.com

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/arabella-brauneck-hotel-lenggries' LIMIT 1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`lft` <= 2024 AND `Route`.`rght` >= 2025 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` = 243 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` = (140) 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` = (140) 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` = (140) 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` = (140) 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` = (140) 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` = (140) 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` = (140) ORDER BY FIELD(COALESCE(`Image7Upload`.`thumbnail`, -1), -1) DESC	0	0
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` = 140 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` = 140 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` = 243 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` = 747 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.68 MB
Controller action start	10.91 MB
Controller render start	12.86 MB
View render complete	18.64 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	107.72
Event: Controller.initialize	11.40
Event: Controller.startup	2.22
Controller action	45.27
Event: Controller.beforeRender	114.67
» Processing toolbar data	32.08
Rendering View	57.60
» Event: View.beforeRender	0.44
» Rendering APP/Plugin/FrontendPoints/View/FrontendPoints/point.php	30.32
» Rendering APP/Plugin/FrontendPoints/View/FrontendPoints/base.php	0.49
» Event: View.afterRender	0.13
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/index.php	22.87
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	2.43
» » Rendering APP/View/Elements/subpages-heading.php	1.53
» » Rendering APP/View/Elements/footer-links.php	2.14
» » 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/