Beste Unterhaltung in stilvollem Ambiente

Die Aufgaben und Rollen der Kur-GmbH sind vielfältig, so agiert das Unternehmen als Serviceanbieter, Dienstleister, Betreiber, Eigentümer und Veranstalter. Die Kur-GmbH versteht sich deshalb als ziel- und kundenorientierter Dienstleister - ein Impulsgeber für Tourismus, Veranstaltungen und Angebote im Bayerischen Staatsbad Bad Reichenhall mit Bayerisch Gmain.

Veranstalter in der Alpenstadt

Kulturelles Leben hat Tradition in Bad Reichenhall. Aus der Entwicklung Bad Reichenhalls zum mondänen Kurort heraus entstanden bereits die ersten Unterhaltungsprogramme und die Kurmusik, um das erlauchte Publikum zu erfreuen.

Die Kur-GmbH ist Veranstalter in den Liegenschaften und Gebäuden des Freistaates Bayern, der Gemeinde Bayerisch Gmain, sowie in der RupertusTherme. Gemeinsam mit Partnern veranstaltet die Kur-GmbH das ganze Jahr über Festivals, Kurkonzerte, Märkte, Kurgartenbeleuchtungen, Führungen, Thermenevents, Präsentationen, Philharmonische Klangwolke sowie Brauchtumsabende.

Aktuelle Veranstaltungen rund um Bad Reichenhall und Bayerisch Gmain...

Kontakt
Bildergalerie
360° Rundgang

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
  time1607059703
  countdown10
  languagede
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  02338
- ids(array)
  Menu2338
  Content(null)
  Language1
- route(array)
  id29355
  hash4050af977ff188f67e1ab40152ab94c5
  created2017-11-22 14:24:03
  updated2017-11-22 14:24:03
  modelMenu
  foreign_key2338
  base/
  aliasveranstalter
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id29344
  lft96
  rght103
  route/veranstalter
- 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: 43 ms
Total Queries: 143 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 `staatsbad_bad_reichenhall`.`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`))) = '/veranstalter' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 96 AND `Route`.`rght` >= 103 ORDER BY `Route`.`lft` asc	4	4	1	maybe slow
SELECT `Language`.`langid` FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`settings` AS `Setting` LEFT JOIN `staatsbad_bad_reichenhall`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	35	35	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 `staatsbad_bad_reichenhall`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 3, 4, 5, 7, 8, 12, 15, 16, 17, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 34, 35, 36, 37, 43, 45, 46, 47, 48, 49, 50, 51, 52, 53) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	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`, `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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 2338 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1362 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`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`teaser_search_result_view`, `Content`.`webcam_id`, `Content`.`flatrate_id_backup`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`event_link_appendix`, (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 `staatsbad_bad_reichenhall`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (2338) ORDER BY `Content`.`position` asc	3	3	1	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 `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 529 AND `Route`.`model` = 'Content'	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 `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 530 AND `Route`.`model` = 'Content'	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 `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 533 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`.`digiggv`, `Host`.`image_order`, (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 `staatsbad_bad_reichenhall`.`hosts` AS `Host` LEFT JOIN `staatsbad_bad_reichenhall`.`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	1	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`.`digiggv`, `Host`.`image_order`, (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 `staatsbad_bad_reichenhall`.`hosts` AS `Host` LEFT JOIN `staatsbad_bad_reichenhall`.`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("0a148ee8dc6d4cffec7046153eb6b167") LIMIT 4	0	0	1	maybe slow
SELECT `HostGroup`.`id`, `HostGroup`.`title` FROM `staatsbad_bad_reichenhall`.`host_groups` AS `HostGroup` JOIN `staatsbad_bad_reichenhall`.`hosts` AS `Host` ON (`Host`.`host_group_id` = `HostGroup`.`id`) WHERE 1 = 1 GROUP BY `HostGroup`.`id`	0	0	0
SELECT *, Language.id FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 56 ORDER BY `Menu`.`lft` asc	26	26	0
SELECT *, Language.id FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 107 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 `staatsbad_bad_reichenhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (107) 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`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`teaser_search_result_view`, `Content`.`webcam_id`, `Content`.`flatrate_id_backup`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`event_link_appendix`, (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 `staatsbad_bad_reichenhall`.`contents` AS `Content` LEFT JOIN `staatsbad_bad_reichenhall`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `staatsbad_bad_reichenhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 107 AND `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '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 `staatsbad_bad_reichenhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (59) 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 59 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 `staatsbad_bad_reichenhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (59) 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 59 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 `staatsbad_bad_reichenhall`.`uploads` AS `WeatherMapUpload` WHERE `WeatherMapUpload`.`model` = 'Content' AND `WeatherMapUpload`.`field` = 'weather_map' AND `WeatherMapUpload`.`foreign_key` = (6) 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ArticleContentMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, `GalleryMedia`.`status`, `GalleryMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `GalleryMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `WebradioHeaderImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `SnowReportImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `LakeReportGalleryMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `DownloadTeaserFileMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6 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 `staatsbad_bad_reichenhall`.`poi` AS `POI` JOIN `staatsbad_bad_reichenhall`.`contents_poi` AS `ContentsPoi` ON (`ContentsPoi`.`content_id` = 6 AND `ContentsPoi`.`poi_id` = `POI`.`id`) ORDER BY `ContentsPoi`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 66 AND `Menu`.`rght` < 67 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 92 AND `Menu`.`rght` < 117 ORDER BY `Menu`.`lft` asc	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 499 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 501 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 502 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 504 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 536 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 539 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 542 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 543 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 537 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 47 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 538 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 `staatsbad_bad_reichenhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (172, 127, 1164, 1166, 1835, 2312, 2314, 2315, 2316, 173, 174, 2313) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	8	8	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 `staatsbad_bad_reichenhall`.`languages` AS `Language` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 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 `staatsbad_bad_reichenhall`.`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	0	0	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 `staatsbad_bad_reichenhall`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 2338 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 `staatsbad_bad_reichenhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (1362) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	1	maybe slow
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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`id` = 2338 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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 13 AND `Menu`.`rght` >= 14 AND `Menu`.`id` NOT IN (106, 1088, 15, 172, 173, 2, 34, 58, 967, 16, 17, 117, 118, 1263, 1264, 1265, 1266) ORDER BY `Menu`.`lft` asc	2	2	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 `staatsbad_bad_reichenhall`.`languages` AS `Language` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `langid` = 'de' LIMIT 1	1	1	0
SELECT *, Language.id FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` JOIN `staatsbad_bad_reichenhall`.`menus` AS `Parent` ON (`Parent`.`lft` <= `Menu`.`lft` AND `Parent`.`rght` >= `Menu`.`rght`) JOIN `staatsbad_bad_reichenhall`.`uploads` AS `Upload` ON (`Upload`.`foreign_key` = `Parent`.`id` AND `Upload`.`model` = 'Menu' AND `Upload`.`field` = 'icon') WHERE `Menu`.`id` = 2338 ORDER BY `Parent`.`lft` DESC LIMIT 1	0	0	1	maybe slow
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar_nav' 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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 57 AND `Menu`.`rght` < 64 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 67 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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (65) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 69 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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (66) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 243 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (67) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 68 AND `Menu`.`rght` < 85 ORDER BY `Menu`.`lft` asc	8	8	0
SELECT *, Language.id FROM `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `staatsbad_bad_reichenhall`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'toolbar_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 `staatsbad_bad_reichenhall`.`menus` AS `Menu` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `staatsbad_bad_reichenhall`.`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 `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 `staatsbad_bad_reichenhall`.`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`))) = '/veranstalter/die-kur-gmbh-als-veranstalter' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 97 AND `Route`.`rght` >= 98 ORDER BY `Route`.`lft` asc	5	5	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`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`teaser_search_result_view`, `Content`.`webcam_id`, `Content`.`flatrate_id_backup`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`event_link_appendix`, (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 `staatsbad_bad_reichenhall`.`contents` AS `Content` LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 529 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 `staatsbad_bad_reichenhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (1452) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	1	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1452 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 `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 `staatsbad_bad_reichenhall`.`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`))) = '/veranstalter/alpenstadt-veranstalter' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 99 AND `Route`.`rght` >= 100 ORDER BY `Route`.`lft` asc	5	5	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`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`teaser_search_result_view`, `Content`.`webcam_id`, `Content`.`flatrate_id_backup`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`event_link_appendix`, (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 `staatsbad_bad_reichenhall`.`contents` AS `Content` LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 530 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 `staatsbad_bad_reichenhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (1453) 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 `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1453 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	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 `staatsbad_bad_reichenhall`.`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`))) = '/veranstalter/bilder' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 101 AND `Route`.`rght` >= 102 ORDER BY `Route`.`lft` asc	5	5	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`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`teaser_search_result_view`, `Content`.`webcam_id`, `Content`.`flatrate_id_backup`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`event_link_appendix`, (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 `staatsbad_bad_reichenhall`.`contents` AS `Content` LEFT JOIN `staatsbad_bad_reichenhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 533 AND (1=1) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `ImageMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1456 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 `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, `GalleryMedia`.`status`, `GalleryMedia`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`media` AS `GalleryMedia` JOIN `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 533 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	6	6	1	maybe slow
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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (135, 109, 40, 60, 129, 79) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	36	36	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` IN (135, 109, 40, 60, 129, 79) AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `scope` = 'copyright'	0	0	1	maybe slow
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 135 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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (135) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	5	5	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 135 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	6	6	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 135 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	1	maybe slow
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 109 LIMIT 1	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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (109) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 109 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	5	5	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 109 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	1	maybe slow
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 40 LIMIT 1	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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (40) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 40 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	4	4	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 40 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 `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 60 LIMIT 1	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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (60) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 60 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	5	5	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 60 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 `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 129 LIMIT 1	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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (129) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	5	5	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 129 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	4	4	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 129 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 `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 79 LIMIT 1	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 `staatsbad_bad_reichenhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (79) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	5	5	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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 79 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	5	5	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 79 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	1	maybe slow
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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`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 `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 65 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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 65 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	0	0	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 65 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 `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 66 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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 66 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	0	0	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 66 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 `staatsbad_bad_reichenhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `staatsbad_bad_reichenhall`.`media` AS `Media` WHERE `Media`.`id` = 67 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 `staatsbad_bad_reichenhall`.`tags` AS `TagsTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 67 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	0	0	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 `staatsbad_bad_reichenhall`.`tags` AS `CopyrightTag` JOIN `staatsbad_bad_reichenhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 67 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 `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 28010 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 `staatsbad_bad_reichenhall`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 29238 LIMIT 1	1	1	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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`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 `staatsbad_bad_reichenhall`.`mount_points` AS `MountPoint` LEFT JOIN `staatsbad_bad_reichenhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `staatsbad_bad_reichenhall`.`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 10.81 MB

Message	Memory use
Component initialization	1.79 MB
Controller action start	3.14 MB
Controller render start	3.37 MB
Component initialization #2	5.00 MB
Controller action start #2	5.10 MB
Controller render start #2	5.21 MB
Component initialization #3	5.43 MB
Controller action start #3	5.45 MB
Controller render start #3	5.55 MB
Component initialization #4	5.73 MB
Controller action start #4	5.75 MB
Controller render start #4	5.99 MB
View render complete	6.45 MB

Timers

Total Request Time: 439 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	102.99
Event: Controller.initialize	51.75
Event: Controller.startup	0.74
Controller action	10.81
Event: Controller.beforeRender	83.09
» Processing toolbar data	18.59
Rendering View	118.48
» Event: View.beforeRender	0.04
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	95.98
» » Event: Controller.initialize #2	0.13
» » Event: Controller.startup #2	0.15
» » Controller action #2	4.96
» » Event: Controller.beforeRender #2	8.30
» » » Processing toolbar data #2	8.15
Rendering View #2	0.00
» » » Event: View.beforeRender #2	0.04
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	2.00
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.37
» » » 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	3.09
» » » Event: Controller.beforeRender #3	5.87
» » » » Processing toolbar data #3	5.77
Rendering View #3	0.00
» » » » Event: View.beforeRender #3	0.04
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.03
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.29
» » » » Event: View.afterRender #2	0.04
» » » » Event: Controller.shutdown #2	0.02
» » » » Event: Controller.initialize #4	0.11
» » » » Event: Controller.startup #4	0.14
» » » » Controller action #4	14.38
» » » » Event: Controller.beforeRender #4	6.65
» » » » » Processing toolbar data #4	6.48
Rendering View #4	0.00
» » » » » Event: View.beforeRender #4	0.04
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/gallery.php	28.68
» » » » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php #2	27.91
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.37
» » » » » Event: View.afterRender #3	0.05
» » » » » Event: Controller.shutdown #3	0.03
» » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #4	0.25
» » » » Event: View.afterRender #4	0.43
» » » » Event: View.beforeLayout	0.02
» » » » Rendering APP/View/Layouts/index.php	19.67
» » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.29
» » » » » Rendering APP/View/Elements/navigation.php	1.59
» » » » » Rendering APP/View/Elements/footer_collapse.php	0.30
» » » » » Rendering APP/View/Elements/footer_subtree.php	0.58
» » » » » Rendering APP/View/Elements/footer_collapse.php #2	0.21
» » » » » Rendering APP/View/Elements/footer_partner.php	2.54
» » » » » Rendering APP/View/Elements/footer_subtree.php #2	0.32
» » » » » Rendering APP/View/Elements/footer_collapse.php #3	0.21
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id2338
  hash3350ea2e22e08a62add4770a42015fec
  created2017-11-22 14:24:03
  updated2017-11-22 14:24:03
  parent_id2331
  lft13
  rght14
  language_id1
  typecontent
  titleVeranstalter
  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)
  id1362
  hash395e667e2b8f964e789a893da69d5988
  created2017-11-22 14:24:03
  updated2017-11-22 14:24:03
  modelMenu
  foreign_key2338
  title
  description
  internal_keywords
  author
  tw_creator
  fb_author
  robots3
  canonical_url
  ImageMedia(empty)
  Content(array)
  0(array)
  id529
  snow_report_poi_id(null)
  snow_report_ski_area_id(null)
  hashf875901544d4329e8a08deb4fff00ba2
  created2017-12-15 10:58:44
  updated2017-12-15 13:23:07
  menu_id2338
  position1
  typearticle
  statusactive
  titleDie Kur-GmbH als Veranstalter
  language_id1
  article_content<h1>Beste Unterhaltung in stilvollem Ambiente</h1> <p>Die Aufgaben und Rollen der Kur-GmbH sind vielfältig, so agiert das Unternehmen als Serviceanbieter, Dienstleister, Betreiber, Eigentümer und Veranstalter. Die Kur-GmbH versteht sich deshalb als ziel- und kundenorientierter Dienstleister - ein Impulsgeber für Tourismus, Veranstaltungen und Angebote im Bayerischen Staatsbad Bad Reichenhall mit Bayerisch Gmain.</p>
  layoutcol8
  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)
  poi_index_criteria_municipalities(null)
  poi_index_criteria_properties(null)
  poi_index_criteria_categories(null)
  teaser_search_result_view(null)
  webcam_id(null)
  flatrate_id_backup(null)
  anex_id
  anex_region1
  anex_type1
  anex_selection1
  advertising_banner_id(null)
  employee_id(null)
  placeholder_text(null)
  countdown_datetime(null)
  event_link_appendix
  gmap
  published1
  isActive1
  Route(array)
  id29452
  hash8e088244c1154ac3e9cb5b7146ab66df
  created2017-12-15 10:58:44
  updated2017-12-15 13:23:07
  modelContent
  foreign_key529
  base/veranstalter/
  aliasdie-kur-gmbh-als-veranstalter
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id29355
  lft97
  rght98
  route/veranstalter/die-kur-gmbh-als-veranstalter
  1(array)
  id530
  snow_report_poi_id(null)
  snow_report_ski_area_id(null)
  hash24102445747331409f326720405929ac
  created2017-12-15 11:24:18
  updated2018-01-02 09:56:59
  menu_id2338
  position2
  typearticle
  statusactive
  titleAlpenstadt-Veranstalter
  language_id1
  article_content<h2>Veranstalter in der Alpenstadt</h2> <p>Kulturelles Leben hat Tradition in Bad Reichenhall. Aus der Entwicklung Bad Reichenhalls zum mondänen Kurort heraus entstanden bereits die ersten Unterhaltungsprogramme und die Kurmusik, um das erlauchte Publikum zu erfreuen.</p> <p> </p> <p>Die Kur-GmbH ist Veranstalter in den Liegenschaften und Gebäuden des Freistaates Bayern, der Gemeinde Bayerisch Gmain, sowie in der <a href="http://www.rupertustherme.de/de/veranstaltungen-1/" target="_blank">RupertusTherme</a>. Gemeinsam mit Partnern veranstaltet die Kur-GmbH das ganze Jahr über Festivals, Kurkonzerte, Märkte, Kurgartenbeleuchtungen, Führungen, Thermenevents, Präsentationen, Philharmonische Klangwolke sowie Brauchtumsabende. </p> <p><a href="https://veranstaltungen.bad-reichenhall.de/region/" target="_blank">Aktuelle Veranstaltungen rund um Bad Reichenhall und Bayerisch Gmain...</a></p>
  layoutcol8
  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)
  poi_index_criteria_municipalities(null)
  poi_index_criteria_properties(null)
  poi_index_criteria_categories(null)
  teaser_search_result_view(null)
  webcam_id(null)
  flatrate_id_backup(null)
  anex_id
  anex_region1
  anex_type1
  anex_selection1
  advertising_banner_id(null)
  employee_id(null)
  placeholder_text(null)
  countdown_datetime(null)
  event_link_appendix
  gmap
  published1
  isActive1
  Route(array)
  id29453
  hash85b3c5468a9b094a57f7cd6f98e9f4be
  created2017-12-15 11:24:18
  updated2018-01-02 09:56:59
  modelContent
  foreign_key530
  base/veranstalter/
  aliasalpenstadt-veranstalter
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id29355
  lft99
  rght100
  route/veranstalter/alpenstadt-veranstalter
  2(array)
  id533
  snow_report_poi_id(null)
  snow_report_ski_area_id(null)
  hash6d842f809342322bbe7fc5baaa8d4dae
  created2017-12-15 11:50:43
  updated2017-12-15 13:22:58
  menu_id2338
  position3
  typegallery
  statusactive
  titleBilder
  language_id1
  article_content(null)
  layoutcol8
  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)
  poi_index_criteria_municipalities(null)
  poi_index_criteria_properties(null)
  poi_index_criteria_categories(null)
  teaser_search_result_view(null)
  webcam_id(null)
  flatrate_id_backup(null)
  anex_id
  anex_region1
  anex_type1
  anex_selection1
  advertising_banner_id(null)
  employee_id(null)
  placeholder_text(null)
  countdown_datetime(null)
  event_link_appendix
  gmap
  published1
  isActive1
  Route(array)
  id29456
  hash33923d607fe5874ca235eda7b8acfd94
  created2017-12-15 11:50:43
  updated2017-12-15 13:22:58
  modelContent
  foreign_key533
  base/veranstalter/
  aliasbilder
  controllerFrontendContents.FrontendContents
  actiongallery
  parent_id29355
  lft101
  rght102
  route/veranstalter/bilder
- $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
  9LeafletJs
  10GMap
  11Embed
  12Layout
  13OAJs
  14OA
  15BitMask
  16ThirdPartyCookies
  17Number
  18SimpleGraph
  19DebugTimer
  20Toolbar
  21Session
  22Js
  23HtmlToolbar
====

Environment

App Constants

Constant	Value
MH
MH_IP
BACKEND_APP_DIR	contrance
UPLOADS_APP	/var/www/vhosts/staatsbad-bad-reichenhall.de/httpdocs/contrance/
UPLOAD_TMP_DIR	tmp/uploads/

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.0.33
User	u409409569596
Home	/var/www/vhosts/staatsbad-bad-reichenhall.de
Script Name	/webroot/index.php
Request Uri	/veranstalter
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/veranstalter
Remote Port	41064
Script Filename	/var/www/vhosts/staatsbad-bad-reichenhall.de/httpdocs/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/staatsbad-bad-reichenhall.de/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/staatsbad-bad-reichenhall.de/httpdocs
Remote Addr	3.216.79.60
Server Port	443
Server Addr	62.116.174.142
Server Name	www.staatsbad-bad-reichenhall.de
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
Http If Modified Since	Wed, 23 Sep 2020 08:54:44 GMT
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	3.216.79.60
Http Host	www.staatsbad-bad-reichenhall.de
Proxy-nokeepalive	1
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	X8mQt1QJUFPNWLHxaqOWygAAABc
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	X8mQt1QJUFPNWLHxaqOWygAAABc
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Unique Id	X8mQt1QJUFPNWLHxaqOWygAAABc
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1607045303.7703
Request Time	1607045303

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.0/share/pear
- 2-> /var/www/vhosts/staatsbad-bad-reichenhall.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
====

Beste Unterhaltung in stilvollem Ambiente

Veranstalter in der Alpenstadt

Bayerisches Staatsbad

Kur-GmbH Bad Reichenhall / Bayerisch Gmain

default

Total Time: 43 ms
Total Queries: 143 queries

Query Explain:

Memory

Timers

Beste Unterhaltung in stilvollem Ambiente

Veranstalter in der Alpenstadt

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 43 ms Total Queries: 143 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 43 ms
Total Queries: 143 queries