Neue Ausbildung an Berufsschule stärkt Betriebe aus der Reisebranche

Von nun an müssen angehende Tourismuskaufleute für ihren Unterricht nicht mehr nach München

Betriebe aus der Reisebranche können ihre Lehrlinge ab sofort in der staatlichen Berufsschule Berchtesgadener Land zu Tourismuskaufleuten für Privat- und Geschäftsreisen ausbilden lassen. Die Ausbildung wird ab September als Ergänzung zu dem Kaufmann für Tourismus und Freizeit angeboten.

Bisher mussten die Betriebe aus der Region ihre Auszubildenden für den Berufsschulunterreicht nach München schicken. Gerade für die Jüngeren der angehenden Tourismuskaufleute ist die Distanz problematisch. Deshalb war es wichtig, den Unterricht vor Ort zu ermöglichen.

„Der Trend zeigt, dass die Leute wieder in die Reisebüros gehen. Mit dem Angebot dieser Ausbildung stärken wir die heimischen Unternehmen aus der Reisebranche“, erklärt Berufsschuldirektor Hermann Kunkel.

Die Unterrichtsfächer in der dualen Ausbildung umfassen betriebliche und gesamtwirtschaftliche Prozesse, Tourismusprozesse, kaufmännische Steuerung und Kontrolle sowie die Fremdsprachen Englisch und Spanisch. „Wir an der Berufsschule Berchtesgadener Land sind in Kombination mit unserer Berufsfachschule für Hotel und Tourismusmanagement ‚YouTou‘ Kompetenzzentrum Tourismus“, betont Kunkel. Die Tourismuskaufleute erfahren an der Berufsschule demnach eine exzellente Ausbildung.

Einzugsgebiet für die Auszubildenden ist vor allem das Berchtesgadener Land, Traunstein und Mühldorf. Schüler, die einen längeren Anreiseweg haben, werden im Kolpinghaus in Teisendorf untergebracht.

Ansprechpartner an der Staatlichen Berufsschule Berchtesgadener Land ist Thomas Öllinger.

Cookie Einstellungen

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

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

Weitere Informationen finden Sie in unserer Datenschutzerklärung.

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent_sidebar
- named(empty)
- pass(array)
  02838
- ids(array)
  Menu2838
  Content(null)
  Language1
- route(array)
  id28758
  hash3e12492e1c24204108247efac1ea31e8
  created2019-05-22 17:40:37
  updated2020-07-28 15:31:15
  modelMenu
  foreign_key2838
  base/beruf-karriere/fuer-familien/
  aliasberufsschule
  controllerFrontendMenus.FrontendMenus
  actioncontent_sidebar
  parent_id27388
  lft1688
  rght1693
  route/beruf-karriere/fuer-familien/berufsschule
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(null)
  actionindex
- template/*
====

Sql Log

Sql Logs

default

Total Time: 50 ms
Total Queries: 139 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`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`))) = '/beruf-karriere/fuer-familien/berufsschule' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1688 AND `Route`.`rght` >= 1693 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Language`.`langid` FROM `wfg`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `wfg`.`settings` AS `Setting` LEFT JOIN `wfg`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	45	45	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `wfg`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 3, 4, 5, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 54, 55, 56) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	3	3	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 2838 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2306 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive` FROM `wfg`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (2838) ORDER BY `Content`.`position` asc	2	2	6	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 1391 AND `Route`.`model` = 'Content'	1	1	1
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 1392 AND `Route`.`model` = 'Content'	1	1	0
SELECT `Host`.`id`, `Host`.`hash`, `Host`.`created`, `Host`.`updated`, `Host`.`title`, `Host`.`host_group_id`, `Host`.`external_id`, `Host`.`output_channel`, `Host`.`category`, `Host`.`stars_sorting`, `Host`.`stars_count`, `Host`.`stars_text`, `Host`.`price_minimum`, `Host`.`price_maximum`, `Host`.`price_1a`, `Host`.`price_1b`, `Host`.`price_1c`, `Host`.`price_2a`, `Host`.`price_2b`, `Host`.`price_2c`, `Host`.`price_3a`, `Host`.`price_3b`, `Host`.`price_4a`, `Host`.`price_4b`, `Host`.`price_camping_1_1`, `Host`.`price_camping_1_2`, `Host`.`price_camping_2_1`, `Host`.`price_camping_2_2`, `Host`.`price_camping_3_1`, `Host`.`price_camping_3_2`, `Host`.`price_camping_4_1`, `Host`.`price_camping_4_2`, `Host`.`price_camping_5_1`, `Host`.`price_camping_5_2`, `Host`.`format_sorting`, `Host`.`booking_url`, `Host`.`owner`, `Host`.`street`, `Host`.`place`, `Host`.`email`, `Host`.`website_url`, `Host`.`phone`, `Host`.`mobile`, `Host`.`fax`, `Host`.`youtube_url1`, `Host`.`youtube_url2`, `Host`.`trustyou_id`, `Host`.`shorttext`, `Host`.`next_busstop`, `Host`.`busstop_minutes_by_foot`, `Host`.`house_prospect_url`, `Host`.`webtext`, `Host`.`map_lat`, `Host`.`map_long`, `Host`.`status`, `Host`.`tomas_id`, `Host`.`previous_url`, `Host`.`2bedroom`, `Host`.`3bedroom`, `Host`.`4bedroom`, `Host`.`mbedroom`, `Host`.`webcam_image`, `Host`.`webcam_link`, `Host`.`opening_hours`, `Host`.`parking_lots`, `Host`.`altitude`, `Host`.`image_order`, `Host`.`digiggv`, (CONCAT_WS (',',`Host`.`map_lat`,`Host`.`map_long`)) AS `Host__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`hosts` AS `Host` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Host`.`id` AND `Route`.`model` = 'Host') WHERE `Host`.`output_channel` = 'ggv' AND `Host`.`format_sorting` IN (1, 2, 3) ORDER BY `Host`.`format_sorting`=1 DESC, RAND() ASC LIMIT 4	0	0	2	maybe slow
SELECT `Host`.`id`, `Host`.`hash`, `Host`.`created`, `Host`.`updated`, `Host`.`title`, `Host`.`host_group_id`, `Host`.`external_id`, `Host`.`output_channel`, `Host`.`category`, `Host`.`stars_sorting`, `Host`.`stars_count`, `Host`.`stars_text`, `Host`.`price_minimum`, `Host`.`price_maximum`, `Host`.`price_1a`, `Host`.`price_1b`, `Host`.`price_1c`, `Host`.`price_2a`, `Host`.`price_2b`, `Host`.`price_2c`, `Host`.`price_3a`, `Host`.`price_3b`, `Host`.`price_4a`, `Host`.`price_4b`, `Host`.`price_camping_1_1`, `Host`.`price_camping_1_2`, `Host`.`price_camping_2_1`, `Host`.`price_camping_2_2`, `Host`.`price_camping_3_1`, `Host`.`price_camping_3_2`, `Host`.`price_camping_4_1`, `Host`.`price_camping_4_2`, `Host`.`price_camping_5_1`, `Host`.`price_camping_5_2`, `Host`.`format_sorting`, `Host`.`booking_url`, `Host`.`owner`, `Host`.`street`, `Host`.`place`, `Host`.`email`, `Host`.`website_url`, `Host`.`phone`, `Host`.`mobile`, `Host`.`fax`, `Host`.`youtube_url1`, `Host`.`youtube_url2`, `Host`.`trustyou_id`, `Host`.`shorttext`, `Host`.`next_busstop`, `Host`.`busstop_minutes_by_foot`, `Host`.`house_prospect_url`, `Host`.`webtext`, `Host`.`map_lat`, `Host`.`map_long`, `Host`.`status`, `Host`.`tomas_id`, `Host`.`previous_url`, `Host`.`2bedroom`, `Host`.`3bedroom`, `Host`.`4bedroom`, `Host`.`mbedroom`, `Host`.`webcam_image`, `Host`.`webcam_link`, `Host`.`opening_hours`, `Host`.`parking_lots`, `Host`.`altitude`, `Host`.`image_order`, `Host`.`digiggv`, (CONCAT_WS (',',`Host`.`map_lat`,`Host`.`map_long`)) AS `Host__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`hosts` AS `Host` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Host`.`id` AND `Route`.`model` = 'Host') WHERE `Host`.`output_channel` = 'wellness' ORDER BY (`Host`.`format_sorting` IS NULL), `Host`.`format_sorting` ASC, RAND("c617f88b9f6875d4d816b365563934f2") LIMIT 4	0	0	1	maybe slow
SELECT `HostGroup`.`id`, `HostGroup`.`title` FROM `wfg`.`host_groups` AS `HostGroup` JOIN `wfg`.`hosts` AS `Host` ON (`Host`.`host_group_id` = `HostGroup`.`id`) WHERE 1 = 1 GROUP BY `HostGroup`.`id`	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'show-all-hosts' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'quick-search' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'offers-flatrates' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'hosts' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'health' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 1040 ORDER BY `Menu`.`lft` asc	518	518	1
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-service' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `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`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2448 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (863) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 863 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (617) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 617 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2448) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `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`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 2448 AND `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1'	1	1	11	maybe slow
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (864) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 864 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (618) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 618 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WeatherMapUpload`.`id`, `WeatherMapUpload`.`hash`, `WeatherMapUpload`.`created`, `WeatherMapUpload`.`updated`, `WeatherMapUpload`.`model`, `WeatherMapUpload`.`field`, `WeatherMapUpload`.`foreign_key`, `WeatherMapUpload`.`alias`, `WeatherMapUpload`.`thumbnail`, `WeatherMapUpload`.`parent_id`, `WeatherMapUpload`.`file`, `WeatherMapUpload`.`size`, `WeatherMapUpload`.`ext`, `WeatherMapUpload`.`mime`, `WeatherMapUpload`.`width`, `WeatherMapUpload`.`height` FROM `wfg`.`uploads` AS `WeatherMapUpload` WHERE `WeatherMapUpload`.`model` = 'Content' AND `WeatherMapUpload`.`field` = 'weather_map' AND `WeatherMapUpload`.`foreign_key` = (374) ORDER BY FIELD(COALESCE(`WeatherMapUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, `ArticleContentMedia`.`status`, `ArticleContentMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ArticleContentMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4225) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, `GalleryMedia`.`status`, `GalleryMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `GalleryMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WebradioHeaderImageMedia`.`id`, `WebradioHeaderImageMedia`.`hash`, `WebradioHeaderImageMedia`.`created`, `WebradioHeaderImageMedia`.`updated`, `WebradioHeaderImageMedia`.`title`, `WebradioHeaderImageMedia`.`status`, `WebradioHeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `WebradioHeaderImageMedia`.`id`) AS `WebradioHeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `WebradioHeaderImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `WebradioHeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'webradio_header_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `SnowReportImageMedia`.`id`, `SnowReportImageMedia`.`hash`, `SnowReportImageMedia`.`created`, `SnowReportImageMedia`.`updated`, `SnowReportImageMedia`.`title`, `SnowReportImageMedia`.`status`, `SnowReportImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `SnowReportImageMedia`.`id`) AS `SnowReportImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `SnowReportImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `SnowReportImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'snow_report_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LakeReportGalleryMedia`.`id`, `LakeReportGalleryMedia`.`hash`, `LakeReportGalleryMedia`.`created`, `LakeReportGalleryMedia`.`updated`, `LakeReportGalleryMedia`.`title`, `LakeReportGalleryMedia`.`status`, `LakeReportGalleryMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) AS `LakeReportGalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `LakeReportGalleryMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'lake_report_gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `DownloadTeaserFileMedia`.`id`, `DownloadTeaserFileMedia`.`hash`, `DownloadTeaserFileMedia`.`created`, `DownloadTeaserFileMedia`.`updated`, `DownloadTeaserFileMedia`.`title`, `DownloadTeaserFileMedia`.`status`, `DownloadTeaserFileMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) AS `DownloadTeaserFileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `DownloadTeaserFileMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'download_teaser_file' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `POI`.`id`, `POI`.`hash`, `POI`.`created`, `POI`.`updated`, `POI`.`internal_title`, `POI`.`ordering_number`, `POI`.`address_zip`, `POI`.`address_city`, `POI`.`address_street`, `POI`.`address_country`, `POI`.`address_lat`, `POI`.`address_long`, `POI`.`phone`, `POI`.`email`, `POI`.`fax`, `POI`.`starting_point_zip`, `POI`.`starting_point_city`, `POI`.`starting_point_street`, `POI`.`starting_point_country`, `POI`.`starting_point_lat`, `POI`.`starting_point_long`, `POI`.`accessibility`, `POI`.`webcam`, `POI`.`height`, `POI`.`overnight_stay`, `POI`.`alpine_club`, `POI`.`family_friendly`, `POI`.`tip_for_bad_weather`, `POI`.`tickets`, `POI`.`seasons`, `POI`.`categories`, `POI`.`external_id`, `POI`.`customer_fax`, `POI`.`customer_mobile`, `POI`.`customer_phone`, `POI`.`customer_web`, `POI`.`customer_email`, `POI`.`customer_company`, `POI`.`customer_salutation`, `POI`.`customer_name`, `POI`.`customer_first_name`, `POI`.`customer_street`, `POI`.`customer_zip`, `POI`.`customer_city`, `POI`.`customer_country`, `POI`.`show_customer_communication_address`, `POI`.`municipality`, `POI`.`status`, `POI`.`gallery1_position`, `POI`.`gallery2_position`, `POI`.`gallery3_position`, `POI`.`gallery4_position`, `POI`.`gallery5_position`, `POI`.`gallery6_position`, `POI`.`gallery7_position`, `POI`.`gallery8_position`, `POI`.`gallery9_position`, `POI`.`gallery10_position`, `POI`.`webcam_layout`, `POI`.`advertising_banner_id`, `POI`.`widget_code`, (CONCAT_WS (',',`POI`.`address_lat`,`POI`.`address_long`)) AS `POI__address`, (CONCAT_WS (',',`POI`.`starting_point_lat`,`POI`.`starting_point_long`)) AS `POI__starting_point`, `ContentsPoi`.`id`, `ContentsPoi`.`content_id`, `ContentsPoi`.`poi_id`, `ContentsPoi`.`position` FROM `wfg`.`poi` AS `POI` JOIN `wfg`.`contents_poi` AS `ContentsPoi` ON (`ContentsPoi`.`content_id` = 374 AND `ContentsPoi`.`poi_id` = `POI`.`id`) ORDER BY `ContentsPoi`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social-media' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 1042 AND `Menu`.`rght` < 1047 ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1105 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 819 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (2523, 1818) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-partner' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 1122 AND `Menu`.`rght` < 1137 ORDER BY `Menu`.`lft` asc	7	7	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 194 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 507 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8749) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 509 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8750) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1040 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9071) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1039 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8752) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1038 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8751) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 935 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8693) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (173, 2422, 2424, 2504, 2503, 2502, 2486) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	6	6	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 `wfg`.`languages` AS `Language` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	2	2	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `wfg`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 2838 LIMIT 1	1	1	1
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2306) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`id` = 2838 LIMIT 1	1	1	1
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 239 AND `Menu`.`rght` >= 240 AND `Menu`.`id` NOT IN (106, 15, 172, 173, 2, 34, 58, 967, 16, 17, 117, 118, 1263, 1264, 1265, 1266) ORDER BY `Menu`.`lft` asc	4	4	1	maybe slow
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 `wfg`.`languages` AS `Language` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `langid` = 'de' LIMIT 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `wfg`.`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	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'en' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	0
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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'home' AND `MountPoint`.`language_id` = 1 LIMIT 1	1	1	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view` FROM `wfg`.`menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Parent`.`id` FROM `wfg`.`menus` AS `Menu` JOIN `wfg`.`menus` AS `Parent` ON (`Parent`.`lft` <= `Menu`.`lft` AND `Parent`.`rght` >= `Menu`.`rght`) JOIN `wfg`.`uploads` AS `Upload` ON (`Upload`.`foreign_key` = `Parent`.`id` AND `Upload`.`model` = 'Menu' AND `Upload`.`field` = 'icon') WHERE `Menu`.`id` = 2838 ORDER BY `Parent`.`lft` DESC LIMIT 1	0	0	1	maybe slow
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar_nav' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 1048 AND `Menu`.`rght` < 1121 ORDER BY `Menu`.`lft` asc	36	36	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'news' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `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`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1225 LIMIT 1	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1225) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'nav-banner' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'free-consultation' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'toolbar_nav' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`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`))) = '/beruf-karriere/fuer-familien/berufsschule/neue-ausbildung-an-berufsschule' LIMIT 1	1	1	3	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1689 AND `Route`.`rght` >= 1690 ORDER BY `Route`.`lft` asc	7	7	1	maybe slow
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1391 AND (1=1) = '1' LIMIT 1	1	1	2	maybe slow
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2308) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2308 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9501 LIMIT 1	1	1	1
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9501) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	1	maybe slow
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9501 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	8	8	1	maybe slow
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9501 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`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`))) = '/beruf-karriere/fuer-familien/berufsschule/visitenkarte-fachkraeftelotsin' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1691 AND `Route`.`rght` >= 1692 ORDER BY `Route`.`lft` asc	7	7	0
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1392 AND (1=1) = '1' LIMIT 1	1	1	1
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2309) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2309 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Employee`.`id`, `Employee`.`hash`, `Employee`.`created`, `Employee`.`updated`, `Employee`.`title`, `Employee`.`first_name`, `Employee`.`role`, `Employee`.`last_name`, `Employee`.`telephone`, `Employee`.`mobile`, `Employee`.`fax`, `Employee`.`email`, `Employee`.`company`, `Employee`.`street`, `Employee`.`zip_code`, `Employee`.`city`, `Employee`.`description`, `Employee`.`professional_title`, `Employee`.`level_of_employment`, `Employee`.`personal_information`, `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 `wfg`.`employees` AS `Employee` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Employee`.`id` AND `Route`.`model` = 'Employee') WHERE `Employee`.`id` = 19 LIMIT 1	1	1	0
SELECT `Task`.`id`, `Task`.`hash`, `Task`.`created`, `Task`.`updated`, `Task`.`title`, `EmployeesTask`.`id`, `EmployeesTask`.`hash`, `EmployeesTask`.`created`, `EmployeesTask`.`updated`, `EmployeesTask`.`employee_id`, `EmployeesTask`.`task_id` FROM `wfg`.`tasks` AS `Task` JOIN `wfg`.`employees_tasks` AS `EmployeesTask` ON (`EmployeesTask`.`employee_id` = 19 AND `EmployeesTask`.`task_id` = `Task`.`id`)	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`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 `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Employee' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8980) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	1	maybe slow
SELECT `ImageBusinessCardMedia`.`id`, `ImageBusinessCardMedia`.`hash`, `ImageBusinessCardMedia`.`created`, `ImageBusinessCardMedia`.`updated`, `ImageBusinessCardMedia`.`title`, `ImageBusinessCardMedia`.`status`, `ImageBusinessCardMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageBusinessCardMedia`.`id`) AS `ImageBusinessCardMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageBusinessCardMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 AND `MediaEntity`.`media_id` = `ImageBusinessCardMedia`.`id`) WHERE `MediaEntity`.`model` = 'Employee' AND `MediaEntity`.`field` = 'image_business_card' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8980 LIMIT 1	1	1	1
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8980 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	4	4	5	maybe slow
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8980 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`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` = 'search' LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 28575 LIMIT 1	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 4225 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 4225 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 4225 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8749 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8749 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8749 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8750 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8750 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8750 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9071 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9071 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	6	6	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9071 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8752 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8752 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8752 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8751 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8751 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8751 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8693 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8693 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	2	2	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8693 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
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 `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 12.48 MB

Message	Memory use
Component initialization	1.81 MB
Controller action start	3.19 MB
Controller render start	3.47 MB
Component initialization #2	7.22 MB
Controller action start #2	7.32 MB
Controller render start #2	7.47 MB
Component initialization #3	7.94 MB
Controller action start #3	7.96 MB
Controller render start #3	8.28 MB
View render complete	8.70 MB

Timers

Total Request Time: 490 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	109.07
Event: Controller.initialize	52.39
Event: Controller.startup	1.13
Controller action	17.57
Event: Controller.beforeRender	118.70
» Processing toolbar data	21.36
Rendering View	116.44
» Event: View.beforeRender	0.35
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content_sidebar.php	82.95
» » Event: Controller.initialize #2	0.14
» » Event: Controller.startup #2	0.16
» » Controller action #2	4.73
» » Event: Controller.beforeRender #2	8.55
» » » Processing toolbar data #2	8.45
Rendering View #2	0.00
» » » Event: View.beforeRender #2	0.04
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	17.75
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.46
» » » Event: View.afterRender	0.06
» » » Event: Controller.shutdown	0.03
» » » Event: Controller.initialize #3	0.11
» » » Event: Controller.startup #3	0.14
» » » Controller action #3	16.25
» » » Event: Controller.beforeRender #3	8.04
» » » » Processing toolbar data #3	7.93
Rendering View #3	0.00
» » » » Event: View.beforeRender #3	0.05
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/contact_person_teaser.php	8.31
» » » » Event: View.afterRender #2	0.05
» » » » Event: Controller.shutdown #2	0.03
» » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #2	0.36
» » » Event: View.afterRender #3	0.13
» » » Event: View.beforeLayout	0.02
» » » Rendering APP/View/Layouts/index.php	30.24
» » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.31
» » » » Rendering APP/View/Elements/navigation.php	4.54
» » » » Rendering APP/View/Elements/footer_collapse.php	0.29
» » » » Rendering APP/View/Elements/footer_subtree.php	0.77
» » » » Rendering APP/View/Elements/footer_collapse.php #2	0.23
» » » » Rendering APP/View/Elements/footer_subtree.php #2	0.60
» » » » Rendering APP/View/Elements/footer_collapse.php #3	0.21
» » » » Rendering APP/View/Elements/footer_subtree.php #3	0.59
» » » » Rendering APP/View/Elements/footer_collapse.php #4	0.21
» » » » Rendering APP/View/Elements/footer_partner.php	10.11
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id2838
  hashd080c1167bb51454aa5ea7c5db1c8e07
  created2019-05-22 17:40:37
  updated2019-08-06 07:48:37
  parent_id2462
  lft239
  rght240
  language_id1
  typecontent_sidebar
  titleBerufsschule
  previous_url(null)
  url(null)
  target_blank(false)
  calendar_label_type(null)
  ad_types0
  breadcrumb_no_link(false)
  teaser_search_result_view(null)
  Seo(array)
  id2306
  hashee76c8051825297d72edaa821f0f00dc
  created2019-05-22 17:40:38
  updated2019-08-06 07:48:37
  modelMenu
  foreign_key2838
  title
  description
  internal_keywords
  author
  tw_creator
  fb_author
  robots3
  canonical_url
  ImageMedia(empty)
  Content(array)
  0(array)
  id1391
  snow_report_poi_id(null)
  snow_report_ski_area_id(null)
  hash24152ce92237ed7b41b7757de441bf57
  created2019-05-22 17:47:14
  updated2019-09-12 10:29:17
  menu_id2838
  position1
  typearticle
  statusactive
  titleNeue Ausbildung an Berufsschule
  language_id1
  article_content<h1>Neue Ausbildung an Berufsschule stärkt Betriebe aus der Reisebranche</h1> <h2><strong>Von nun an müssen angehende Tourismuskaufleute für ihren Unterricht nicht mehr nach München</strong></h2> <p> </p> <p><span>Betriebe aus der Reisebranche können ihre Lehrlinge ab sofort in der staatlichen Berufsschule Berchtesgadener Land zu Tourismuskaufleuten für Privat- und Geschäftsreisen ausbilden lassen. Die Ausbildung wird ab September als Ergänzung zu dem Kaufmann für Tourismus und Freizeit angeboten. </span></p> <p><span>Bisher mussten die Betriebe aus der Region ihre Auszubildenden für den Berufsschulunterreicht nach München schicken. Gerade für die Jüngeren der angehenden Tourismuskaufleute ist die Distanz problematisch. Deshalb war es wichtig, den Unterricht vor Ort zu ermöglichen. </span></p> <p><span>„Der Trend zeigt, dass die Leute wieder in die Reisebüros gehen. Mit dem Angebot dieser Ausbildung stärken wir die heimischen Unternehmen aus der Reisebranche“, erklärt Berufsschuldirektor Hermann Kunkel. </span></p> <p><span>Die Unterrichtsfächer in der dualen Ausbildung umfassen betriebliche und gesamtwirtschaftliche Prozesse, Tourismusprozesse, kaufmännische Steuerung und Kontrolle sowie die Fremdsprachen Englisch und Spanisch. „Wir an der Berufsschule Berchtesgadener Land sind in Kombination mit unserer Berufsfachschule für Hotel und Tourismusmanagement ‚YouTou‘ Kompetenzzentrum Tourismus“, betont Kunkel. Die Tourismuskaufleute erfahren an der Berufsschule demnach eine exzellente Ausbildung. </span></p> <p><span>Einzugsgebiet für die Auszubildenden ist vor allem das Berchtesgadener Land, Traunstein und Mühldorf. Schüler, die einen längeren Anreiseweg haben, werden im Kolpinghaus in Teisendorf untergebracht.</span></p> <p>Ansprechpartner an der <a href="https://www.bsbgl.de/">Staatlichen Berufsschule Berchtesgadener Land</a> ist <a href="mailto:oellinger@bsbgl.de">Thomas Öllinger</a>.</p> <p> </p> <figure class="figure-responsive"> <div class="img-responsive" data-media-id="9501"> </div> <figcaption class="hidden"></figcaption> </figure>  <p> </p>
  layoutcontent_sidebar_left
  links_content(null)
  contact_content(null)
  contact_email(null)
  contact_email_cc(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  flatrate_id(null)
  gmap_zoom(null)
  video_type(null)
  menu_teaser_menu_id(null)
  video_url(null)
  gmap_long(null)
  flatrate_index_tag_id(null)
  gmap_marker(null)
  gmap_type(null)
  gmap_lat(null)
  url_teaser_url(null)
  url_teaser_target(null)
  flex_view_id(null)
  rit_agb(null)
  webcam_image(null)
  webcam_url(null)
  webcam_type(null)
  webcam_height(null)
  host_search_output_channel(null)
  webradio_url(null)
  flatrate_request_lang(null)
  snow_report_weather_url(null)
  snow_report_weather_url_target(null)
  snow_report_price_url(null)
  snow_report_price_url_target(null)
  snow_report_phone(null)
  snow_report_webcam_title(null)
  snow_report_webcam_image(null)
  snow_report_webcam_title_2(null)
  snow_report_webcam_image_2(null)
  lake_report_bergfex_lake_id(null)
  lake_report_custom_title(null)
  lake_report_title(null)
  lake_report_article(null)
  lake_report_weather_location(null)
  lake_webcam_image(null)
  lake_webcam_title(null)
  lake_webcam_title_2(null)
  lake_webcam_image_2(null)
  teaser_banner(false)
  developer_template_code(null)
  float_left(false)
  developer_template_js(null)
  developer_template_css(null)
  childhood_memories_category(null)
  conference_request_category(null)
  poi_teaser_poi_id(null)
  flatrate_id_backup(null)
  poi_index_criteria_municipalities(null)
  poi_index_criteria_properties(null)
  poi_index_criteria_categories(null)
  webcam_id(null)
  teaser_search_result_view(null)
  employee_id(null)
  anex_id(null)
  anex_region(null)
  anex_type(null)
  anex_selection(null)
  advertising_banner_id(null)
  placeholder_text(null)
  countdown_datetime(null)
  gmap
  published1
  isActive1
  Route(array)
  id28760
  hash38a469b7921b9155c96bab7335586b87
  created2019-05-22 17:47:14
  updated2019-09-12 10:29:18
  modelContent
  foreign_key1391
  base/beruf-karriere/fuer-familien/berufsschule/
  aliasneue-ausbildung-an-berufsschule
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id28758
  lft1689
  rght1690
  route/beruf-karriere/fuer-familien/berufsschule/neue-ausbildung-an-berufsschule
  1(array)
  id1392
  snow_report_poi_id(null)
  snow_report_ski_area_id(null)
  hash43b5c2945135e25783d470e7155697e0
  created2019-05-22 17:48:08
  updated2019-05-22 17:48:08
  menu_id2838
  position2
  typecontact_person_teaser
  statusactive
  titleVisitenkarte Fachkräftelotsin
  language_id1
  article_content(null)
  layoutcontent_sidebar_right
  links_content(null)
  contact_content(null)
  contact_email(null)
  contact_email_cc(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  flatrate_id(null)
  gmap_zoom(null)
  video_type(null)
  menu_teaser_menu_id(null)
  video_url(null)
  gmap_long(null)
  flatrate_index_tag_id(null)
  gmap_marker(null)
  gmap_type(null)
  gmap_lat(null)
  url_teaser_url(null)
  url_teaser_target(null)
  flex_view_id(null)
  rit_agb(null)
  webcam_image(null)
  webcam_url(null)
  webcam_type(null)
  webcam_height(null)
  host_search_output_channel(null)
  webradio_url(null)
  flatrate_request_lang(null)
  snow_report_weather_url(null)
  snow_report_weather_url_target(null)
  snow_report_price_url(null)
  snow_report_price_url_target(null)
  snow_report_phone(null)
  snow_report_webcam_title(null)
  snow_report_webcam_image(null)
  snow_report_webcam_title_2(null)
  snow_report_webcam_image_2(null)
  lake_report_bergfex_lake_id(null)
  lake_report_custom_title(null)
  lake_report_title(null)
  lake_report_article(null)
  lake_report_weather_location(null)
  lake_webcam_image(null)
  lake_webcam_title(null)
  lake_webcam_title_2(null)
  lake_webcam_image_2(null)
  teaser_banner(false)
  developer_template_code(null)
  float_left(false)
  developer_template_js(null)
  developer_template_css(null)
  childhood_memories_category(null)
  conference_request_category(null)
  poi_teaser_poi_id(null)
  flatrate_id_backup(null)
  poi_index_criteria_municipalities(null)
  poi_index_criteria_properties(null)
  poi_index_criteria_categories(null)
  webcam_id(null)
  teaser_search_result_view(null)
  employee_id19
  anex_id(null)
  anex_region(null)
  anex_type(null)
  anex_selection(null)
  advertising_banner_id(null)
  placeholder_text(null)
  countdown_datetime(null)
  gmap
  published1
  isActive1
  Route(array)
  id28761
  hash33180a25850e955074dd65f46e388456
  created2019-05-22 17:48:08
  updated2019-05-22 17:48:08
  modelContent
  foreign_key1392
  base/beruf-karriere/fuer-familien/berufsschule/
  aliasvisitenkarte-fachkraeftelotsin
  controllerFrontendContents.FrontendContents
  actioncontact_person_teaser
  parent_id28758
  lft1691
  rght1692
  route/beruf-karriere/fuer-familien/berufsschule/visitenkarte-fachkraeftelotsin
- $request->data(empty)
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Menu(empty)
  Parent(empty)
  Seo(empty)
  ImageMedia(empty)
  MediaEntity(empty)
  Teaser(empty)
  Content(empty)
  ArticleContentMedia(empty)
  GalleryMedia(empty)
  WebradioHeaderImageMedia(empty)
  SnowReportImageMedia(empty)
  LakeReportGalleryMedia(empty)
  DownloadTeaserFileMedia(empty)
  POI(empty)
  Webcam(empty)
  Setting(empty)
  ValueUpload(empty)
  FileUpload(empty)
  Host(empty)
  HostPictogram(empty)
  HostQualitySeal(empty)
  Image1Upload(empty)
  HostGroup(empty)
  IconUpload(empty)
  ImageUpload(empty)
  WeatherMapUpload(empty)
  ContentsPoi(empty)
  FlagUpload(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7Enum
  8SocialMedia
  9Maps
  10Embed
  11Layout
  12OAJs
  13OA
  14BitMask
  15ThirdPartyCookies
  16Number
  17SimpleGraph
  18DebugTimer
  19Toolbar
  20Session
  21Js
  22HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.0.33
User	u5438905893045
Home	/var/www/vhosts/berchtesgadener-land.de
Script Name	/webroot/index.php
Request Uri	/beruf-karriere/fuer-familien/berufsschule
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/beruf-karriere/fuer-familien/berufsschule
Remote Port	38172
Script Filename	/var/www/vhosts/berchtesgadener-land.de/httpdocs/webroot/index.php
Server Admin	plesk-admin@internetx.com
Context Document Root	/var/www/vhosts/berchtesgadener-land.de/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/berchtesgadener-land.de/httpdocs
Remote Addr	18.233.111.242
Server Port	443
Server Addr	62.116.174.142
Server Name	www.berchtesgadener-land.de
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	18.233.111.242
Http Host	www.berchtesgadener-land.de
Proxy-nokeepalive	1
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Script Uri	https://www.berchtesgadener-land.de/beruf-karriere/fuer-familien/berufsschule
Script Url	/beruf-karriere/fuer-familien/berufsschule
Unique Id	XzXZmEVYlDEKdg8iiUT-FQAAAFU
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Script Uri	https://www.berchtesgadener-land.de/beruf-karriere/fuer-familien/berufsschule
Redirect Script Url	/beruf-karriere/fuer-familien/berufsschule
Redirect Unique Id	XzXZmEVYlDEKdg8iiUT-FQAAAFU
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Script Uri	https://www.berchtesgadener-land.de/beruf-karriere/fuer-familien/berufsschule
Redirect Redirect Script Url	/beruf-karriere/fuer-familien/berufsschule
Redirect Redirect Unique Id	XzXZmEVYlDEKdg8iiUT-FQAAAFU
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1597364632.373
Request Time	1597364632

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.0/share/pear
- 2-> /var/www/vhosts/berchtesgadener-land.de/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeNumber.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  6APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  ApiClient(array)
  Config(array)
  0ApiClient/Config/bootstrap.php
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/HabtmBehavior.php
  11BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Component(array)
  0Contents/Controller/Component/FacebookApiComponent.php
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Flatrates(array)
  Config(array)
  0Flatrates/Config/bootstrap.php
  FrontendFlatrates(array)
  Config(array)
  0FrontendFlatrates/Config/routes.php
  FrontendHosts(array)
  Config(array)
  0FrontendHosts/Config/bootstrap.php
  1FrontendHosts/Config/routes.php
  FrontendMenus(array)
  Controller(array)
  0FrontendMenus/Controller/FrontendMenusController.php
  1FrontendMenus/Controller/FrontendMenusAppController.php
  FrontendPOI(array)
  Config(array)
  0FrontendPOI/Config/bootstrap.php
  FrontendPressArchive(array)
  Config(array)
  0FrontendPressArchive/Config/routes.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Hosts(array)
  Config(array)
  0Hosts/Config/bootstrap.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  POI(array)
  Model(array)
  0POI/Model/POI.php
  1POI/Model/POIAppModel.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
  Webcams(array)
  Model(array)
  0Webcams/Model/Webcam.php
  1Webcams/Model/WebcamsAppModel.php
====

Neue Ausbildung an Berufsschule stärkt Betriebe aus der Reisebranche

Von nun an müssen angehende Tourismuskaufleute für ihren Unterricht nicht mehr nach München

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 50 ms Total Queries: 139 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 50 ms
Total Queries: 139 queries