Hotel Bayerischer Hof – Reutemann – Seegarten Lindau

Bayerischer Hof Reutemannterrasse Web 1 1

Een eersteklas plek aan het meer: Hotel Bayerischer Hof en de partnerhotels, Hotel Reutemann en Hotel Seegarten, bevinden zich op een prachtige plek aan de promenade van het meer en bieden een schitterend uitzicht op het meer en de bergen.

Na een schilderachtige rit op de Duitse Alpenroute kunt u heerlijk bijkomen in onze mooie kamers en exclusieve suites, die alle moderne comfort bieden. Verken het eilandstadje Lindau met zijn mooie kleine straatjes of geniet van heerlijke ontspanning op ons terras in de tuin. Dineer in een van onze restaurants, geniet van een duik in de binnen- of buitenbaden of laat u verwennen in onze spa.

Ontdek de speciale ambiance van ons familiehotel, dat al ruim 160 jaar uitstekende gastvrijheid biedt.

Gastronomie

Restaurant
Cafe
Bar
Regionale Produkte

Wellness

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

Parken

Eigene Garage

Mobilität & Elektromobilität

Entfernung zum nächsten Bahnhof 0,05 km

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' => '534',
			'hash' => 'c4765be7b942e5feddba50eafbe8dd62',
			'created' => '2019-05-29 16:52:27',
			'updated' => '2020-07-21 12:00:13',
			'model' => 'PointI18n',
			'foreign_key' => '196',
			'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' => '196',
			'hash' => '468637df25c3f3c1cb28a31b96c893bc',
			'created' => '2019-05-29 16:52:27',
			'updated' => '2020-07-21 12:00:11',
			'language_id' => '3',
			'point_id' => '121',
			'country' => '',
			'introduction_text' => '',
			'detail_text' => '<p>Een eersteklas plek aan het meer: Hotel Bayerischer Hof en de partnerhotels, Hotel Reutemann en Hotel Seegarten, bevinden zich op een prachtige plek aan de promenade van het meer en bieden een schitterend uitzicht op het meer en de bergen.</p>

<p>Na een schilderachtige rit op de Duitse Alpenroute kunt u heerlijk bijkomen in onze mooie kamers en exclusieve suites, die alle moderne comfort bieden. Verken het eilandstadje Lindau met zijn mooie kleine straatjes of geniet van heerlijke ontspanning op ons terras in de tuin. Dineer in een van onze restaurants, geniet van een duik in de binnen- of buitenbaden of laat u verwennen in onze spa.</p>

<p>Ontdek de speciale ambiance van ons familiehotel, dat al ruim 160 jaar uitstekende gastvrijheid biedt.</p>
',
			'teaser_text' => '<p>Lindau</p>

<p>Tel: +49 (0) 8382 / 9150</p>

<p>www.bayerischerhof-lindau.de</p>
',
			'image_title_1' => 'Hotel Bayerischer Hof Lindau',
			'image_title_2' => 'Hotel Bayerischer Hof Lindau',
			'image_title_3' => 'Hotel Bayerischer Hof Lindau',
			'image_title_4' => 'Hotel Bayerischer Hof Lindau',
			'image_title_5' => '',
			'image_title_6' => '',
			'image_title_7' => '',
			'title' => 'Hotel Bayerischer Hof – Reutemann – Seegarten Lindau',
			'teaser_button' => 'meer',
			'previous_url' => null
		),
		'Point' => array(
			'id' => '121',
			'hash' => '4f1ca9b0db47294f4a1414d57ecae357',
			'created' => '2018-11-02 12:36:16',
			'updated' => '2021-07-12 15:50:26',
			'status' => 'active',
			'title' => 'Hotel Bayerischer Hof – Hotel Reutemann – Hotel Seegarten',
			'content_type' => 'hotel',
			'category' => 'Hotel',
			'teaser_title' => 'Hotel Bayerischer Hof – Hotel Reutemann – Hotel Seegarten',
			'top_tip' => true,
			'map_lat' => '47.544353',
			'map_long' => '9.682249',
			'street' => 'Bahnhofplatz 2',
			'zip_code' => '88131',
			'city' => 'Lindau',
			'phone' => '+49 (0) 8382 / 9150',
			'website_url' => 'http://www.bayerischerhof-lindau.de/',
			'email' => 'hotel@bayerischerhof-lindau.de',
			'region1' => 'Allgäu',
			'region2' => 'Allgäu Bodensee',
			'region3' => '',
			'booking_link' => 'https://booking.bayerischerhof-lindau.de/IBE/Inquiry.aspx?culture=de-DE',
			'gmap_url' => 'http://maps.google.com/maps?z=12&t=m&q=47.543839,9.681530',
			'external_id' => '25660',
			'gmap_zoom' => '7',
			'fax' => '',
			'weather_widget_code' => '',
			'hotels_gastronomy' => '15',
			'hotels_wellness' => '501',
			'hotels_parking' => '2',
			'hotels_car_rental' => '0',
			'hotels_oldtimer' => '0',
			'hotels_transfer' => 'none',
			'hotels_car_charging_possibility' => true,
			'hotels_distance_to_nearest_train_station' => '0.050000',
			'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' => false,
			'map' => '47.544353;9.682249',
			'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' => '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' => '565',
			'hash' => 'ca22947bfa49a8e72bc2e83af9ce5163',
			'created' => '2019-05-29 16:52:27',
			'updated' => '2020-07-21 12:00:13',
			'model' => 'PointI18n',
			'foreign_key' => '196',
			'base' => '/nl/',
			'alias' => 'hotel-bayerischer-hof-reutemann-seegarten-lindau',
			'controller' => 'FrontendPoints.FrontendPoints',
			'action' => 'point',
			'parent_id' => '3',
			'lft' => '1708',
			'rght' => '1709',
			'route' => '/nl/hotel-bayerischer-hof-reutemann-seegarten-lindau'
		),
		'Seo' => array(
			'id' => '534',
			'hash' => 'c4765be7b942e5feddba50eafbe8dd62',
			'created' => '2019-05-29 16:52:27',
			'updated' => '2020-07-21 12:00:13',
			'model' => 'PointI18n',
			'foreign_key' => '196',
			'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' => '742',
			'rght' => '743',
			'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' => '744',
			'rght' => '745',
			'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' => '732',
			'rght' => '733',
			'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' => '734',
			'rght' => '735',
			'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' => '736',
			'rght' => '737',
			'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' => '117',
			'hash' => 'ef1a997b1eabda98bb6d948d167c9ca6',
			'created' => '2016-10-26 15:50:08',
			'updated' => '2016-10-26 15:50:08',
			'parent_id' => '115',
			'lft' => '442',
			'rght' => '451',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'De Duitse Alpenroute',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '272',
			'hash' => '650faa895018e90942caf3182e05272a',
			'created' => '2016-10-26 15:50:08',
			'updated' => '2016-10-26 15:50:08',
			'model' => 'Menu',
			'foreign_key' => '117',
			'base' => '/nl/',
			'alias' => 'de-duitse-alpenroute',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1481',
			'rght' => '1516',
			'route' => '/nl/de-duitse-alpenroute'
		),
		'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' => '121',
			'hash' => 'b08ef2ec3a352ebc101a34a7081fc1c2',
			'created' => '2016-10-26 15:52:49',
			'updated' => '2016-11-16 10:01:46',
			'parent_id' => '115',
			'lft' => '452',
			'rght' => '471',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Etappes',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '276',
			'hash' => '54f02699ed43a4e0bc9664fc47b39e4b',
			'created' => '2016-10-26 15:52:49',
			'updated' => '2016-11-16 10:01:47',
			'model' => 'Menu',
			'foreign_key' => '121',
			'base' => '/nl/',
			'alias' => 'etappes',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1517',
			'rght' => '1560',
			'route' => '/nl/etappes'
		),
		'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' => '131',
			'hash' => '21f701a5a3f2fb533057e0c8de98ffd9',
			'created' => '2016-10-26 15:59:31',
			'updated' => '2016-11-16 10:22:10',
			'parent_id' => '115',
			'lft' => '472',
			'rght' => '501',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Hoogtepunten',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '286',
			'hash' => '5a6adbf77142710279969e4a9aa694aa',
			'created' => '2016-10-26 15:59:31',
			'updated' => '2016-11-16 10:22:11',
			'model' => 'Menu',
			'foreign_key' => '131',
			'base' => '/nl/',
			'alias' => 'hoogtepunten',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1561',
			'rght' => '1618',
			'route' => '/nl/hoogtepunten'
		),
		'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' => '214',
			'hash' => 'a988fcc4bb11a0e59d0f360766fb463d',
			'created' => '2019-08-02 12:04:03',
			'updated' => '2019-08-02 12:04:03',
			'parent_id' => '115',
			'lft' => '502',
			'rght' => '549',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Hotels',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '716',
			'hash' => '50df165fe4870b06fd07d7e201a40a17',
			'created' => '2019-08-02 12:04:03',
			'updated' => '2019-08-02 12:04:03',
			'model' => 'Menu',
			'foreign_key' => '214',
			'base' => '/nl/',
			'alias' => 'hotels',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1625',
			'rght' => '1676',
			'route' => '/nl/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' => '146',
			'hash' => '64e984e1eb0ee02de5ae2bf2d391e5fe',
			'created' => '2016-12-12 09:43:18',
			'updated' => '2016-12-12 09:43:18',
			'parent_id' => '115',
			'lft' => '550',
			'rght' => '551',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Service',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '367',
			'hash' => '4f94fc25b1d6fff71dc078a21d1cf574',
			'created' => '2016-12-12 09:43:18',
			'updated' => '2016-12-12 09:43:18',
			'model' => 'Menu',
			'foreign_key' => '146',
			'base' => '/nl/',
			'alias' => 'service',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1619',
			'rght' => '1624',
			'route' => '/nl/service'
		),
		'children' => array()
	)
)
$pathForLayout = array()
$seoForLayout = array(
	'Seo' => array(
		'id' => '534',
		'hash' => 'c4765be7b942e5feddba50eafbe8dd62',
		'created' => '2019-05-29 16:52:27',
		'updated' => '2020-07-21 12:00:13',
		'model' => 'PointI18n',
		'foreign_key' => '196',
		'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' => '1160',
			'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' => '1161',
			'rght' => '1464',
			'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' => '1465',
			'rght' => '1764',
			'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' => '1765',
			'rght' => '2068',
			'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' => '150',
			'hash' => '212449a3d64a28a83b4f67a2e659651b',
			'created' => '2016-12-12 09:45:36',
			'updated' => '2016-12-12 11:09:34',
			'parent_id' => '149',
			'lft' => '557',
			'rght' => '558',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Imprint',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '371',
			'hash' => '9dffe2f1fb5bd456ac6ff25b80fc79cc',
			'created' => '2016-12-12 09:45:36',
			'updated' => '2016-12-12 11:09:34',
			'model' => 'Menu',
			'foreign_key' => '150',
			'base' => '/nl/footer/links/',
			'alias' => 'imprint',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '370',
			'lft' => '1680',
			'rght' => '1683',
			'route' => '/nl/footer/links/imprint'
		),
		'children' => array()
	),
	(int) 1 => array(
		'Menu' => array(
			'id' => '151',
			'hash' => '367005d4764542685fc8882620df6ad2',
			'created' => '2016-12-12 09:45:49',
			'updated' => '2016-12-12 11:09:51',
			'parent_id' => '149',
			'lft' => '559',
			'rght' => '560',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Privacy Policy',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '372',
			'hash' => '8e5aa62aa4ae939897a73e1a148ff5ee',
			'created' => '2016-12-12 09:45:49',
			'updated' => '2016-12-12 11:09:51',
			'model' => 'Menu',
			'foreign_key' => '151',
			'base' => '/nl/footer/links/',
			'alias' => 'privacy-policy',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '370',
			'lft' => '1684',
			'rght' => '1687',
			'route' => '/nl/footer/links/privacy-policy'
		),
		'children' => array()
	)
)
$isHomeForLayout = false
$metaaNavigationForLayout = array(
	(int) 0 => array(
		'Menu' => array(
			'id' => '117',
			'hash' => 'ef1a997b1eabda98bb6d948d167c9ca6',
			'created' => '2016-10-26 15:50:08',
			'updated' => '2016-10-26 15:50:08',
			'parent_id' => '115',
			'lft' => '442',
			'rght' => '451',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'De Duitse Alpenroute',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '272',
			'hash' => '650faa895018e90942caf3182e05272a',
			'created' => '2016-10-26 15:50:08',
			'updated' => '2016-10-26 15:50:08',
			'model' => 'Menu',
			'foreign_key' => '117',
			'base' => '/nl/',
			'alias' => 'de-duitse-alpenroute',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1481',
			'rght' => '1516',
			'route' => '/nl/de-duitse-alpenroute'
		),
		'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' => '121',
			'hash' => 'b08ef2ec3a352ebc101a34a7081fc1c2',
			'created' => '2016-10-26 15:52:49',
			'updated' => '2016-11-16 10:01:46',
			'parent_id' => '115',
			'lft' => '452',
			'rght' => '471',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Etappes',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '276',
			'hash' => '54f02699ed43a4e0bc9664fc47b39e4b',
			'created' => '2016-10-26 15:52:49',
			'updated' => '2016-11-16 10:01:47',
			'model' => 'Menu',
			'foreign_key' => '121',
			'base' => '/nl/',
			'alias' => 'etappes',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1517',
			'rght' => '1560',
			'route' => '/nl/etappes'
		),
		'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' => '131',
			'hash' => '21f701a5a3f2fb533057e0c8de98ffd9',
			'created' => '2016-10-26 15:59:31',
			'updated' => '2016-11-16 10:22:10',
			'parent_id' => '115',
			'lft' => '472',
			'rght' => '501',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Hoogtepunten',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '286',
			'hash' => '5a6adbf77142710279969e4a9aa694aa',
			'created' => '2016-10-26 15:59:31',
			'updated' => '2016-11-16 10:22:11',
			'model' => 'Menu',
			'foreign_key' => '131',
			'base' => '/nl/',
			'alias' => 'hoogtepunten',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1561',
			'rght' => '1618',
			'route' => '/nl/hoogtepunten'
		),
		'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' => '214',
			'hash' => 'a988fcc4bb11a0e59d0f360766fb463d',
			'created' => '2019-08-02 12:04:03',
			'updated' => '2019-08-02 12:04:03',
			'parent_id' => '115',
			'lft' => '502',
			'rght' => '549',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Hotels',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '716',
			'hash' => '50df165fe4870b06fd07d7e201a40a17',
			'created' => '2019-08-02 12:04:03',
			'updated' => '2019-08-02 12:04:03',
			'model' => 'Menu',
			'foreign_key' => '214',
			'base' => '/nl/',
			'alias' => 'hotels',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1625',
			'rght' => '1676',
			'route' => '/nl/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' => '146',
			'hash' => '64e984e1eb0ee02de5ae2bf2d391e5fe',
			'created' => '2016-12-12 09:43:18',
			'updated' => '2016-12-12 09:43:18',
			'parent_id' => '115',
			'lft' => '550',
			'rght' => '551',
			'language_id' => '3',
			'type' => 'content',
			'title' => 'Service',
			'previous_url' => null,
			'url' => null,
			'target_blank' => false
		),
		'Route' => array(
			'id' => '367',
			'hash' => '4f94fc25b1d6fff71dc078a21d1cf574',
			'created' => '2016-12-12 09:43:18',
			'updated' => '2016-12-12 09:43:18',
			'model' => 'Menu',
			'foreign_key' => '146',
			'base' => '/nl/',
			'alias' => 'service',
			'controller' => 'FrontendMenus.FrontendMenus',
			'action' => 'content',
			'parent_id' => '270',
			'lft' => '1619',
			'rght' => '1624',
			'route' => '/nl/service'
		),
		'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' => 'nl/hotel-bayerischer-hof-reutemann-seegarten-lindau',
			'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' => '196',
		'hash' => '468637df25c3f3c1cb28a31b96c893bc',
		'created' => '2019-05-29 16:52:27',
		'updated' => '2020-07-21 12:00:11',
		'language_id' => '3',
		'point_id' => '121',
		'country' => '',
		'introduction_text' => '',
		'detail_text' => '<p>Een eersteklas plek aan het meer: Hotel Bayerischer Hof en de partnerhotels, Hotel Reutemann en Hotel Seegarten, bevinden zich op een prachtige plek aan de promenade van het meer en bieden een schitterend uitzicht op het meer en de bergen.</p>

<p>Na een schilderachtige rit op de Duitse Alpenroute kunt u heerlijk bijkomen in onze mooie kamers en exclusieve suites, die alle moderne comfort bieden. Verken het eilandstadje Lindau met zijn mooie kleine straatjes of geniet van heerlijke ontspanning op ons terras in de tuin. Dineer in een van onze restaurants, geniet van een duik in de binnen- of buitenbaden of laat u verwennen in onze spa.</p>

<p>Ontdek de speciale ambiance van ons familiehotel, dat al ruim 160 jaar uitstekende gastvrijheid biedt.</p>
',
		'teaser_text' => '<p>Lindau</p>

<p>Tel: +49 (0) 8382 / 9150</p>

<p>www.bayerischerhof-lindau.de</p>
',
		'image_title_1' => 'Hotel Bayerischer Hof Lindau',
		'image_title_2' => 'Hotel Bayerischer Hof Lindau',
		'image_title_3' => 'Hotel Bayerischer Hof Lindau',
		'image_title_4' => 'Hotel Bayerischer Hof Lindau',
		'image_title_5' => '',
		'image_title_6' => '',
		'image_title_7' => '',
		'title' => 'Hotel Bayerischer Hof – Reutemann – Seegarten Lindau',
		'teaser_button' => 'meer',
		'previous_url' => null
	),
	'Point' => array(
		'id' => '121',
		'hash' => '4f1ca9b0db47294f4a1414d57ecae357',
		'created' => '2018-11-02 12:36:16',
		'updated' => '2021-07-12 15:50:26',
		'status' => 'active',
		'title' => 'Hotel Bayerischer Hof – Hotel Reutemann – Hotel Seegarten',
		'content_type' => 'hotel',
		'category' => 'Hotel',
		'teaser_title' => 'Hotel Bayerischer Hof – Hotel Reutemann – Hotel Seegarten',
		'top_tip' => true,
		'map_lat' => '47.544353',
		'map_long' => '9.682249',
		'street' => 'Bahnhofplatz 2',
		'zip_code' => '88131',
		'city' => 'Lindau',
		'phone' => '+49 (0) 8382 / 9150',
		'website_url' => 'http://www.bayerischerhof-lindau.de/',
		'email' => 'hotel@bayerischerhof-lindau.de',
		'region1' => 'Allgäu',
		'region2' => 'Allgäu Bodensee',
		'region3' => '',
		'booking_link' => 'https://booking.bayerischerhof-lindau.de/IBE/Inquiry.aspx?culture=de-DE',
		'gmap_url' => 'http://maps.google.com/maps?z=12&t=m&q=47.543839,9.681530',
		'external_id' => '25660',
		'gmap_zoom' => '7',
		'fax' => '',
		'weather_widget_code' => '',
		'hotels_gastronomy' => '15',
		'hotels_wellness' => '501',
		'hotels_parking' => '2',
		'hotels_car_rental' => '0',
		'hotels_oldtimer' => '0',
		'hotels_transfer' => 'none',
		'hotels_car_charging_possibility' => true,
		'hotels_distance_to_nearest_train_station' => '0.050000',
		'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' => false,
		'map' => '47.544353;9.682249',
		'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(),
		'Image7Upload' => array(),
		'CityHotels' => array(),
		'CityPois' => 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' => '565',
		'hash' => 'ca22947bfa49a8e72bc2e83af9ce5163',
		'created' => '2019-05-29 16:52:27',
		'updated' => '2020-07-21 12:00:13',
		'model' => 'PointI18n',
		'foreign_key' => '196',
		'base' => '/nl/',
		'alias' => 'hotel-bayerischer-hof-reutemann-seegarten-lindau',
		'controller' => 'FrontendPoints.FrontendPoints',
		'action' => 'point',
		'parent_id' => '3',
		'lft' => '1708',
		'rght' => '1709',
		'route' => '/nl/hotel-bayerischer-hof-reutemann-seegarten-lindau'
	),
	'Seo' => array(
		'id' => '534',
		'hash' => 'c4765be7b942e5feddba50eafbe8dd62',
		'created' => '2019-05-29 16:52:27',
		'updated' => '2020-07-21 12:00:13',
		'model' => 'PointI18n',
		'foreign_key' => '196',
		'title' => '',
		'description' => '',
		'author' => '',
		'tw_creator' => '',
		'fb_author' => '',
		'robots' => '3',
		'internal_keywords' => ''
	)
)
$isGerman = false
$page = ''
$introduction = ''
$content = '<p>Een eersteklas plek aan het meer: Hotel Bayerischer Hof en de partnerhotels, Hotel Reutemann en Hotel Seegarten, bevinden zich op een prachtige plek aan de promenade van het meer en bieden een schitterend uitzicht op het meer en de bergen.</p>

<p>Na een schilderachtige rit op de Duitse Alpenroute kunt u heerlijk bijkomen in onze mooie kamers en exclusieve suites, die alle moderne comfort bieden. Verken het eilandstadje Lindau met zijn mooie kleine straatjes of geniet van heerlijke ontspanning op ons terras in de tuin. Dineer in een van onze restaurants, geniet van een duik in de binnen- of buitenbaden of laat u verwennen in onze spa.</p>

<p>Ontdek de speciale ambiance van ons familiehotel, dat al ruim 160 jaar uitstekende gastvrijheid biedt.</p>
'
$type = 'Hotel'
$cityHotels = array()
$cityPois = array()
$galleryId = 'gallery-62b7ef84df032'
$count = (int) 5
$i = (int) 8
$orig = null
$thumbnail = null
$image = '<img src="https://www.deutsche-alpenstrasse.de/cdn/uploads/bayerischer-hof-aussenansicht-thpointgalleryresponsive.jpg" alt="Bayerischer Hof Aussenansicht">'
$hotelFeatures = array(
	'gastronomy' => 'Gastronomie',
	'wellness' => 'Wellness',
	'parking' => 'Parken',
	'oldtimer' => 'Oldtimer'
)
$hotelFeature = 'Oldtimer'
$key = 'oldtimer'
$items = array(
	(int) 0 => 'Eigene Garage'
)
$item = 'Eigene Garage'
$distance = '0.050000'
$transfer = 'none'
$carRental = '0'
$bikeRental = '0'
$chargingPossibility = true
$lat = '47.544353'
$lng = '9.682249'
$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

Kaart weergeven

Hotel Bayerischer Hof – Reutemann – Seegarten Lindau

Bahnhofplatz 2
88131 Lindau

Tel: +49 (0) 8382 / 9150
hotel@bayerischerhof-lindau.de
www.bayerischerhof-lindau.de

Cookie Einstellungen

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

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

Weitere Informationen finden Sie in unserer Datenschutzerklärung.

Query	Affected	Num. rows
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/nl/hotel-bayerischer-hof-reutemann-seegarten-lindau' LIMIT 1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`lft` <= 1708 AND `Route`.`rght` >= 1709 ORDER BY `Route`.`lft` asc	2	2
SELECT `Language`.`langid` FROM `deutsche_alpenstr2019`.`languages` AS `Language` WHERE `Language`.`id` = 3 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` = 196 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` = (121) 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` = (121) 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` = (121) 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` = (121) 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` = (121) 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` = (121) ORDER BY FIELD(COALESCE(`Image6Upload`.`thumbnail`, -1), -1) DESC	0	0
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` = (121) 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` = 121 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` = 121 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` = 'nl' 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` > 441 AND `Menu`.`rght` < 552 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` = 'nl' 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` = 114 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` = 243 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` = 243 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` = 114 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` = 114 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` = 'nl' 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` > 556 AND `Menu`.`rght` < 561 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` = 'nl' LIMIT 1	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`, `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 1 != 1 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` = 196 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` = 534 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` = 'nl' 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` = 115 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` = 244 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` = 244 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` = 115 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` = 115 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` = 115 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` = 'nl' 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` = 'nl' 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` = 'nl' 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` = 'nl' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = '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` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'nl' 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

Bericht	Memory use
Component initialization	9.95 MB
Controller action start	11.18 MB
Controller render start	13.00 MB
View render complete	18.72 MB

Bericht	Tijd in ms	Diagram
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	107.54
Event: Controller.initialize	12.06
Event: Controller.startup	2.18
Controller action	35.14
Event: Controller.beforeRender	107.63
» Processing toolbar data	27.63
Rendering View	52.21
» Event: View.beforeRender	0.43
» Rendering APP/Plugin/FrontendPoints/View/FrontendPoints/point.php	27.38
» Rendering APP/Plugin/FrontendPoints/View/FrontendPoints/base.php	0.45
» Event: View.afterRender	0.12
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/index.php	20.65
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	2.18
» » Rendering APP/View/Elements/subpages-heading.php	1.36
» » Rendering APP/View/Elements/footer-links.php	1.84
» » Rendering APP/View/Elements/contact-partners.php	0.39
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/