/* Apple */ ?> /* Android */ ?> /* Windows */ ?>
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.
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| 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`, `Menu`.`introduction`, `Menu`.`searchbar`, `Menu`.`fullscreen_header`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`menus` AS `Menu` LEFT JOIN `brhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2808 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3833) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3833 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3147) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3147 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3147 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' ORDER BY `MediaEntity`.`pos` ASC | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3147 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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 `brhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2808) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `brhall`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (2808) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, `HeaderImageMedia`.`status`, `HeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `HeaderImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2808 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9865) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 13 | 13 | 1 | maybe slow |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 10716 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 10716 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 10716 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 `brhall`.`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`))) = '/home/ausflugsticker' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 19 AND `Route`.`rght` >= 20 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2540 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3843 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3157 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9955) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 11 | 11 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3157 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (11180) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3157 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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`, `Menu`.`introduction`, `Menu`.`searchbar`, `Menu`.`fullscreen_header`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`menus` AS `Menu` LEFT JOIN `brhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2809 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3840) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3840 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 `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3154) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3154 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9807) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 14 | 14 | 0 | |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3154 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9439) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3154 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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 `brhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2809) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `brhall`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (2809) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, `HeaderImageMedia`.`status`, `HeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `HeaderImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2809 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9609) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 12 | 12 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 11180 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11180 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11180 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 `brhall`.`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`))) = '/home/teaser-slider-image-film' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 27 AND `Route`.`rght` >= 28 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive` FROM `brhall`.`contents` AS `Content` WHERE (1=1) = '1' AND `Content`.`id` = 2739 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2739 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ContentMenus`.`id`, `ContentMenus`.`hash`, `ContentMenus`.`created`, `ContentMenus`.`updated`, `ContentMenus`.`parent_id`, `ContentMenus`.`lft`, `ContentMenus`.`rght`, `ContentMenus`.`language_id`, `ContentMenus`.`type`, `ContentMenus`.`title`, `ContentMenus`.`previous_url`, `ContentMenus`.`url`, `ContentMenus`.`target_blank`, `ContentMenus`.`calendar_label_type`, `ContentMenus`.`ad_types`, `ContentMenus`.`breadcrumb_no_link`, `ContentMenus`.`teaser_search_result_view`, `ContentMenus`.`introduction`, `ContentMenus`.`searchbar`, `ContentMenus`.`fullscreen_header`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `brhall`.`menus` AS `ContentMenus` JOIN `brhall`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 2739 AND `ContentsMenu`.`menu_id` = `ContentMenus`.`id`) ORDER BY `ContentsMenu`.`position` ASC | 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 `brhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 2793 AND `Route`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 2793 AND `Teaser`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3056 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9297) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 11 | 11 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3056 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (11017) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3056 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 11017 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11017 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 5 | 5 | 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11017 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 `brhall`.`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`))) = '/home/philo' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 3 AND `Route`.`rght` >= 4 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 656 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1255 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 854 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (6808) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 13 | 13 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 854 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9437) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 9 | 9 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 854 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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`, `Menu`.`introduction`, `Menu`.`searchbar`, `Menu`.`fullscreen_header`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`menus` AS `Menu` LEFT JOIN `brhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2245 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (25) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (25) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9908) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 13 | 13 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' ORDER BY `MediaEntity`.`pos` ASC | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 25 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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 `brhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2245) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `brhall`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (2245) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, `HeaderImageMedia`.`status`, `HeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `HeaderImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2245 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9914) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 7 | 7 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9437 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9437 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9437 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 `brhall`.`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`))) = '/home/175-jahre-badekur-teaser' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 29 AND `Route`.`rght` >= 30 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2740 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3520 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9389) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 11 | 11 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3520 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9655) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3520 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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`, `Menu`.`introduction`, `Menu`.`searchbar`, `Menu`.`fullscreen_header`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`menus` AS `Menu` LEFT JOIN `brhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2789 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3725) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3725 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9334) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 14 | 14 | 1 | 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 `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3039) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3039 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9656) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 12 | 12 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3039 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' ORDER BY `MediaEntity`.`pos` ASC | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3039 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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 `brhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2789) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 1 | 1 | 0 | |
| SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `brhall`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (2789) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, `HeaderImageMedia`.`status`, `HeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `HeaderImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2789 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9655 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9655 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 4 | 4 | 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9655 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 `brhall`.`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`))) = '/home/concierges' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 9 AND `Route`.`rght` >= 10 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1992 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3194 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2530 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9107) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 16 | 16 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2530 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9438) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 2530 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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`, `Menu`.`introduction`, `Menu`.`searchbar`, `Menu`.`fullscreen_header`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`menus` AS `Menu` LEFT JOIN `brhall`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2715 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3133) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3133 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2469) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2469 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2469 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' ORDER BY `MediaEntity`.`pos` ASC | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 2469 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 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 `brhall`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2715) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `brhall`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (2715) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, `HeaderImageMedia`.`status`, `HeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `HeaderImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2715 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9963) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9438 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9438 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9438 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 `brhall`.`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`))) = '/home/teaser-folie-kunst-kultur-und-aktiv-gesund' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 21 AND `Route`.`rght` >= 22 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive` FROM `brhall`.`contents` AS `Content` WHERE (1=1) = '1' AND `Content`.`id` = 2649 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2649 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9100) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 15 | 15 | 1 | maybe slow |
| SELECT `ContentMenus`.`id`, `ContentMenus`.`hash`, `ContentMenus`.`created`, `ContentMenus`.`updated`, `ContentMenus`.`parent_id`, `ContentMenus`.`lft`, `ContentMenus`.`rght`, `ContentMenus`.`language_id`, `ContentMenus`.`type`, `ContentMenus`.`title`, `ContentMenus`.`previous_url`, `ContentMenus`.`url`, `ContentMenus`.`target_blank`, `ContentMenus`.`calendar_label_type`, `ContentMenus`.`ad_types`, `ContentMenus`.`breadcrumb_no_link`, `ContentMenus`.`teaser_search_result_view`, `ContentMenus`.`introduction`, `ContentMenus`.`searchbar`, `ContentMenus`.`fullscreen_header`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `brhall`.`menus` AS `ContentMenus` JOIN `brhall`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 2649 AND `ContentsMenu`.`menu_id` = `ContentMenus`.`id`) ORDER BY `ContentsMenu`.`position` ASC | 2 | 2 | 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 `brhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 2709 AND `Route`.`model` = 'Menu' | 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 `brhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 2794 AND `Route`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 2709 AND `Teaser`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2440 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8932) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 10 | 10 | 0 | |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2440 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' ORDER BY `MediaEntity`.`pos` ASC | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 2440 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 0 | 0 | 0 | |
| SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 2794 AND `Teaser`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3061 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3061 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9458) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3061 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9458 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9458 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 6 | 6 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9458 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 `brhall`.`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`))) = '/home/online-shop' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 15 AND `Route`.`rght` >= 16 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `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`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `brhall`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2523 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3137 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10807) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 9 | 9 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3137 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9449) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 3137 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9449 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9449 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9449 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 `brhall`.`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`))) = '/home/teaser-slider-bayerisch-gmain' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 25 AND `Route`.`rght` >= 26 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive` FROM `brhall`.`contents` AS `Content` WHERE (1=1) = '1' AND `Content`.`id` = 2733 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2733 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ContentMenus`.`id`, `ContentMenus`.`hash`, `ContentMenus`.`created`, `ContentMenus`.`updated`, `ContentMenus`.`parent_id`, `ContentMenus`.`lft`, `ContentMenus`.`rght`, `ContentMenus`.`language_id`, `ContentMenus`.`type`, `ContentMenus`.`title`, `ContentMenus`.`previous_url`, `ContentMenus`.`url`, `ContentMenus`.`target_blank`, `ContentMenus`.`calendar_label_type`, `ContentMenus`.`ad_types`, `ContentMenus`.`breadcrumb_no_link`, `ContentMenus`.`teaser_search_result_view`, `ContentMenus`.`introduction`, `ContentMenus`.`searchbar`, `ContentMenus`.`fullscreen_header`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `brhall`.`menus` AS `ContentMenus` JOIN `brhall`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 2733 AND `ContentsMenu`.`menu_id` = `ContentMenus`.`id`) ORDER BY `ContentsMenu`.`position` ASC | 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 `brhall`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 2320 AND `Route`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`title`, `Teaser`.`subline`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color`, `Teaser`.`type`, `Teaser`.`highlight`, `Teaser`.`title_font` FROM `brhall`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 2320 AND `Teaser`.`model` = 'Menu' | 1 | 1 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 112 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9647) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 14 | 14 | 1 | maybe slow |
| SELECT `IconMedia`.`id`, `IconMedia`.`hash`, `IconMedia`.`created`, `IconMedia`.`updated`, `IconMedia`.`title`, `IconMedia`.`status`, `IconMedia`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `IconMedia`.`id`) AS `IconMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `brhall`.`media` AS `IconMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 112 AND `MediaEntity`.`media_id` = `IconMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'icon' 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 `brhall`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9591) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 7 | 7 | 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 112 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Teaser' AND `TagEntity`.`field` = 'tags' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9591 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9591 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9591 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 `brhall`.`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`))) = '/home/social-wall-titel' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 59 AND `Route`.`rght` >= 60 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (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 `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 3315 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (5104) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5104 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 `brhall`.`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`))) = '/home/socialwall' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `brhall`.`routes` AS `Route` WHERE `Route`.`lft` <= 13 AND `Route`.`rght` >= 14 ORDER BY `Route`.`lft` asc | 3 | 3 | 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_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`show_title`, `Content`.`show_details`, `Content`.`employee_id`, `Content`.`widget_code_field`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, `Content`.`offer_request_topics`, `Content`.`hide_title`, `Content`.`teaser_foil_type`, (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 `brhall`.`contents` AS `Content` LEFT JOIN `brhall`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2475 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `brhall`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3763) 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 `brhall`.`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 `brhall`.`media` AS `ImageMedia` JOIN `brhall`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3763 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `brhall`.`mount_points` AS `MountPoint` LEFT JOIN `brhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brhall`.`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 `brhall`.`mount_points` AS `MountPoint` LEFT JOIN `brhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brhall`.`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` = 'content_tags_results' 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 `brhall`.`mount_points` AS `MountPoint` LEFT JOIN `brhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brhall`.`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 `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 `brhall`.`mount_points` AS `MountPoint` LEFT JOIN `brhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brhall`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 9085 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9085 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 3 | 3 | 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9085 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 `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 10793 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 10793 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 3 | 3 | 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 `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 10793 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 `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 11768 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11768 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11768 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 `brhall`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `brhall`.`media` AS `Media` WHERE `Media`.`id` = 11769 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 `brhall`.`tags` AS `TagsTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11769 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `brhall`.`tags` AS `CopyrightTag` JOIN `brhall`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 11769 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `brhall`.`mount_points` AS `MountPoint` LEFT JOIN `brhall`.`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 `brhall`.`mount_points` AS `MountPoint` LEFT JOIN `brhall`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `brhall`.`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 |
Peak Memory Use 24.11 MB
| Message | Memory use |
|---|---|
| Component initialization | 2.47 MB |
| Controller action start | 4.07 MB |
| Controller render start | 4.71 MB |
| Component initialization #2 | 8.64 MB |
| Controller action start #2 | 8.74 MB |
| Controller render start #2 | 8.97 MB |
| Component initialization #3 | 9.25 MB |
| Controller action start #3 | 9.27 MB |
| Controller render start #3 | 9.52 MB |
| Component initialization #4 | 9.73 MB |
| Controller action start #4 | 9.74 MB |
| Controller render start #4 | 9.98 MB |
| Component initialization #5 | 10.18 MB |
| Controller action start #5 | 10.20 MB |
| Controller render start #5 | 10.31 MB |
| Component initialization #6 | 10.49 MB |
| Controller action start #6 | 10.51 MB |
| Controller render start #6 | 10.65 MB |
| Component initialization #7 | 10.87 MB |
| Controller action start #7 | 10.88 MB |
| Controller render start #7 | 11.03 MB |
| Component initialization #8 | 11.23 MB |
| Controller action start #8 | 11.24 MB |
| Controller render start #8 | 11.38 MB |
| Component initialization #9 | 11.57 MB |
| Controller action start #9 | 11.59 MB |
| Controller render start #9 | 11.77 MB |
| Component initialization #10 | 11.98 MB |
| Controller action start #10 | 11.99 MB |
| Controller render start #10 | 12.20 MB |
| Component initialization #11 | 12.41 MB |
| Controller action start #11 | 12.43 MB |
| Controller render start #11 | 12.63 MB |
| Component initialization #12 | 12.82 MB |
| Controller action start #12 | 12.84 MB |
| Controller render start #12 | 10.28 MB |
| Component initialization #13 | 10.49 MB |
| Controller action start #13 | 10.51 MB |
| Controller render start #13 | 10.76 MB |
| Component initialization #14 | 10.96 MB |
| Controller action start #14 | 10.98 MB |
| Controller render start #14 | 11.21 MB |
| Component initialization #15 | 11.41 MB |
| Controller action start #15 | 11.43 MB |
| Controller render start #15 | 11.67 MB |
| Component initialization #16 | 11.89 MB |
| Controller action start #16 | 11.90 MB |
| Controller render start #16 | 12.08 MB |
| Component initialization #17 | 12.28 MB |
| Controller action start #17 | 12.30 MB |
| Controller render start #17 | 12.54 MB |
| Component initialization #18 | 12.74 MB |
| Controller action start #18 | 12.76 MB |
| Controller render start #18 | 13.00 MB |
| Component initialization #19 | 13.21 MB |
| Controller action start #19 | 13.22 MB |
| Controller render start #19 | 13.43 MB |
| Component initialization #20 | 13.63 MB |
| Controller action start #20 | 13.65 MB |
| Controller render start #20 | 13.86 MB |
| Component initialization #21 | 14.07 MB |
| Controller action start #21 | 14.09 MB |
| Controller render start #21 | 14.24 MB |
| Component initialization #22 | 14.43 MB |
| Controller action start #22 | 14.45 MB |
| Controller render start #22 | 14.62 MB |
| Component initialization #23 | 14.83 MB |
| Controller action start #23 | 14.84 MB |
| Controller render start #23 | 14.95 MB |
| Component initialization #24 | 15.14 MB |
| Controller action start #24 | 15.15 MB |
| Controller render start #24 | 15.26 MB |
| View render complete | 15.67 MB |
Total Request Time: 991 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 53.17 | |
| Event: Controller.initialize | 45.92 | |
| Event: Controller.startup | 0.41 | |
| Controller action | 23.12 | |
| Event: Controller.beforeRender | 226.29 | |
| » Processing toolbar data | 53.27 | |
| Rendering View | 530.19 | |
| » Event: View.beforeRender | 0.04 | |
| » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php | 495.22 | |
| » » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php | 494.62 | |
| » » » Event: Controller.initialize #2 | 0.61 | |
| » » » Event: Controller.startup #2 | 0.13 | |
| » » » Controller action #2 | 9.69 | |
| » » » Event: Controller.beforeRender #2 | 4.13 | |
| » » » » Processing toolbar data #2 | 4.02 | |
| Rendering View #2 | 0.00 | |
| » » » » Event: View.beforeRender #2 | 0.04 | |
| » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php | 3.78 | |
| » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php | 3.20 | |
| » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php | 2.76 | |
| » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php | 0.29 | |
| » » » » Event: View.afterRender | 0.04 | |
| » » » » Event: Controller.shutdown | 0.02 | |
| » » » » Event: Controller.initialize #3 | 0.58 | |
| » » » » Event: Controller.startup #3 | 0.12 | |
| » » » » Controller action #3 | 14.46 | |
| » » » » Event: Controller.beforeRender #3 | 6.39 | |
| » » » » » Processing toolbar data #3 | 6.18 | |
| Rendering View #3 | 0.00 | |
| » » » » » Event: View.beforeRender #3 | 0.05 | |
| » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #2 | 4.03 | |
| » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #2 | 2.85 | |
| » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #2 | 2.30 | |
| » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2 | 0.32 | |
| » » » » » Event: View.afterRender #2 | 0.04 | |
| » » » » » Event: Controller.shutdown #2 | 0.03 | |
| » » » » » Event: Controller.initialize #4 | 0.60 | |
| » » » » » Event: Controller.startup #4 | 0.13 | |
| » » » » » Controller action #4 | 10.96 | |
| » » » » » Event: Controller.beforeRender #4 | 5.53 | |
| » » » » » » Processing toolbar data #4 | 5.40 | |
| Rendering View #4 | 0.00 | |
| » » » » » » Event: View.beforeRender #4 | 0.04 | |
| » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #3 | 2.92 | |
| » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #3 | 2.26 | |
| » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #3 | 1.83 | |
| » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3 | 0.32 | |
| » » » » » » Event: View.afterRender #3 | 0.03 | |
| » » » » » » Event: Controller.shutdown #3 | 0.02 | |
| » » » » » » Event: Controller.initialize #5 | 0.58 | |
| » » » » » » Event: Controller.startup #5 | 0.13 | |
| » » » » » » Controller action #5 | 1.63 | |
| » » » » » » Event: Controller.beforeRender #5 | 5.54 | |
| » » » » » » » Processing toolbar data #5 | 5.45 | |
| Rendering View #5 | 0.00 | |
| » » » » » » » Event: View.beforeRender #5 | 0.03 | |
| » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php | 0.70 | |
| » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4 | 0.28 | |
| » » » » » » » Event: View.afterRender #4 | 0.04 | |
| » » » » » » » Event: Controller.shutdown #4 | 0.02 | |
| » » » » » » » Event: Controller.initialize #6 | 0.54 | |
| » » » » » » » Event: Controller.startup #6 | 0.12 | |
| » » » » » » » Controller action #6 | 4.43 | |
| » » » » » » » Event: Controller.beforeRender #6 | 6.76 | |
| » » » » » » » » Processing toolbar data #6 | 6.62 | |
| Rendering View #6 | 0.00 | |
| » » » » » » » » Event: View.beforeRender #6 | 0.04 | |
| » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/url_teaser.php | 2.83 | |
| » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #4 | 2.20 | |
| » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #4 | 1.73 | |
| » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5 | 0.30 | |
| » » » » » » » » Event: View.afterRender #5 | 0.04 | |
| » » » » » » » » Event: Controller.shutdown #5 | 0.02 | |
| » » » » » » » » Event: Controller.initialize #7 | 0.59 | |
| » » » » » » » » Event: Controller.startup #7 | 0.13 | |
| » » » » » » » » Controller action #7 | 3.89 | |
| » » » » » » » » Event: Controller.beforeRender #7 | 7.70 | |
| » » » » » » » » » Processing toolbar data #7 | 7.56 | |
| Rendering View #7 | 0.00 | |
| » » » » » » » » » Event: View.beforeRender #7 | 0.04 | |
| » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/url_teaser.php #2 | 3.33 | |
| » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #5 | 2.45 | |
| » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #5 | 1.94 | |
| » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #6 | 0.33 | |
| » » » » » » » » » Event: View.afterRender #6 | 0.05 | |
| » » » » » » » » » Event: Controller.shutdown #6 | 0.03 | |
| » » » » » » » » » Event: Controller.initialize #8 | 0.55 | |
| » » » » » » » » » Event: Controller.startup #8 | 0.14 | |
| » » » » » » » » » Controller action #8 | 3.25 | |
| » » » » » » » » » Event: Controller.beforeRender #8 | 8.58 | |
| » » » » » » » » » » Processing toolbar data #8 | 8.39 | |
| Rendering View #8 | 0.00 | |
| » » » » » » » » » » Event: View.beforeRender #8 | 0.06 | |
| » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/url_teaser.php #3 | 2.41 | |
| » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #6 | 1.74 | |
| » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #6 | 1.29 | |
| » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7 | 0.35 | |
| » » » » » » » » » » Event: View.afterRender #7 | 0.06 | |
| » » » » » » » » » » Event: Controller.shutdown #7 | 0.03 | |
| » » » » » » » » » » Event: Controller.initialize #9 | 0.57 | |
| » » » » » » » » » » Event: Controller.startup #9 | 0.15 | |
| » » » » » » » » » » Controller action #9 | 8.29 | |
| » » » » » » » » » » Event: Controller.beforeRender #9 | 7.69 | |
| » » » » » » » » » » » Processing toolbar data #9 | 7.51 | |
| Rendering View #9 | 0.00 | |
| » » » » » » » » » » » Event: View.beforeRender #9 | 0.07 | |
| » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #4 | 3.86 | |
| » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #7 | 2.89 | |
| » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #7 | 2.21 | |
| » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #8 | 0.36 | |
| » » » » » » » » » » » Event: View.afterRender #8 | 0.04 | |
| » » » » » » » » » » » Event: Controller.shutdown #8 | 0.03 | |
| » » » » » » » » » » » Event: Controller.initialize #10 | 0.60 | |
| » » » » » » » » » » » Event: Controller.startup #10 | 0.13 | |
| » » » » » » » » » » » Controller action #10 | 8.36 | |
| » » » » » » » » » » » Event: Controller.beforeRender #10 | 6.73 | |
| » » » » » » » » » » » » Processing toolbar data #10 | 6.58 | |
| Rendering View #10 | 0.00 | |
| » » » » » » » » » » » » Event: View.beforeRender #10 | 0.04 | |
| » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #5 | 2.71 | |
| » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #8 | 2.08 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #8 | 1.67 | |
| » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #9 | 0.30 | |
| » » » » » » » » » » » » Event: View.afterRender #9 | 0.04 | |
| » » » » » » » » » » » » Event: Controller.shutdown #9 | 0.03 | |
| » » » » » » » » » » » » Event: Controller.initialize #11 | 0.53 | |
| » » » » » » » » » » » » Event: Controller.startup #11 | 0.12 | |
| » » » » » » » » » » » » Controller action #11 | 7.70 | |
| » » » » » » » » » » » » Event: Controller.beforeRender #11 | 6.75 | |
| » » » » » » » » » » » » » Processing toolbar data #11 | 6.60 | |
| Rendering View #11 | 0.00 | |
| » » » » » » » » » » » » » Event: View.beforeRender #11 | 0.04 | |
| » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #6 | 2.70 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #9 | 2.10 | |
| » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #9 | 1.69 | |
| » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #10 | 0.29 | |
| » » » » » » » » » » » » » Event: View.afterRender #10 | 0.04 | |
| » » » » » » » » » » » » » Event: Controller.shutdown #10 | 0.03 | |
| » » » » » » » » » » » » » Event: Controller.initialize #12 | 0.56 | |
| » » » » » » » » » » » » » Event: Controller.startup #12 | 0.13 | |
| » » » » » » » » » » » » » Controller action #12 | 7.96 | |
| » » » » » » » » » » » » » Event: Controller.beforeRender #12 | 13.60 | |
| » » » » » » » » » » » » » » Processing toolbar data #12 | 13.44 | |
| Rendering View #12 | 0.00 | |
| » » » » » » » » » » » » » » Event: View.beforeRender #12 | 0.06 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_foil.php | 2.17 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #2 | 3.04 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #3 | 2.43 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #4 | 0.93 | |
| » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #11 | 0.29 | |
| » » » » » » » » » » » » » » Event: View.afterRender #11 | 0.04 | |
| » » » » » » » » » » » » » » Event: Controller.shutdown #11 | 0.03 | |
| » » » » » » » » » » » » » » Event: Controller.initialize #13 | 0.53 | |
| » » » » » » » » » » » » » » Event: Controller.startup #13 | 0.13 | |
| » » » » » » » » » » » » » » Controller action #13 | 8.59 | |
| » » » » » » » » » » » » » » Event: Controller.beforeRender #13 | 7.12 | |
| » » » » » » » » » » » » » » » Processing toolbar data #13 | 6.99 | |
| Rendering View #13 | 0.00 | |
| » » » » » » » » » » » » » » » Event: View.beforeRender #13 | 0.04 | |
| » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #7 | 2.61 | |
| » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #10 | 2.01 | |
| » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #10 | 1.59 | |
| » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #12 | 0.30 | |
| » » » » » » » » » » » » » » » Event: View.afterRender #12 | 0.04 | |
| » » » » » » » » » » » » » » » Event: Controller.shutdown #12 | 0.02 | |
| » » » » » » » » » » » » » » » Event: Controller.initialize #14 | 0.52 | |
| » » » » » » » » » » » » » » » Event: Controller.startup #14 | 0.13 | |
| » » » » » » » » » » » » » » » Controller action #14 | 15.27 | |
| » » » » » » » » » » » » » » » Event: Controller.beforeRender #14 | 7.18 | |
| » » » » » » » » » » » » » » » » Processing toolbar data #14 | 7.02 | |
| Rendering View #14 | 0.00 | |
| » » » » » » » » » » » » » » » » Event: View.beforeRender #14 | 0.04 | |
| » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #8 | 3.02 | |
| » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #11 | 2.38 | |
| » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #11 | 1.91 | |
| » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #13 | 0.31 | |
| » » » » » » » » » » » » » » » » Event: View.afterRender #13 | 0.04 | |
| » » » » » » » » » » » » » » » » Event: Controller.shutdown #13 | 0.03 | |
| » » » » » » » » » » » » » » » » Event: Controller.initialize #15 | 0.53 | |
| » » » » » » » » » » » » » » » » Event: Controller.startup #15 | 0.13 | |
| » » » » » » » » » » » » » » » » Controller action #15 | 9.87 | |
| » » » » » » » » » » » » » » » » Event: Controller.beforeRender #15 | 7.08 | |
| » » » » » » » » » » » » » » » » » Processing toolbar data #15 | 6.94 | |
| Rendering View #15 | 0.00 | |
| » » » » » » » » » » » » » » » » » Event: View.beforeRender #15 | 0.04 | |
| » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #9 | 2.75 | |
| » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #12 | 2.13 | |
| » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #12 | 1.71 | |
| » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #14 | 0.30 | |
| » » » » » » » » » » » » » » » » » Event: View.afterRender #14 | 0.04 | |
| » » » » » » » » » » » » » » » » » Event: Controller.shutdown #14 | 0.03 | |
| » » » » » » » » » » » » » » » » » Event: Controller.initialize #16 | 0.53 | |
| » » » » » » » » » » » » » » » » » Event: Controller.startup #16 | 0.13 | |
| » » » » » » » » » » » » » » » » » Controller action #16 | 5.10 | |
| » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #16 | 7.84 | |
| » » » » » » » » » » » » » » » » » » Processing toolbar data #16 | 7.68 | |
| Rendering View #16 | 0.00 | |
| » » » » » » » » » » » » » » » » » » Event: View.beforeRender #16 | 0.04 | |
| » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_foil.php #5 | 2.48 | |
| » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #6 | 1.80 | |
| » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #15 | 0.33 | |
| » » » » » » » » » » » » » » » » » » Event: View.afterRender #15 | 0.04 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #15 | 0.03 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.initialize #17 | 0.58 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.startup #17 | 0.14 | |
| » » » » » » » » » » » » » » » » » » Controller action #17 | 9.54 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #17 | 7.51 | |
| » » » » » » » » » » » » » » » » » » » Processing toolbar data #17 | 7.35 | |
| Rendering View #17 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #17 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #10 | 2.66 | |
| » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #13 | 2.04 | |
| » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #13 | 1.61 | |
| » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #16 | 0.29 | |
| » » » » » » » » » » » » » » » » » » » Event: View.afterRender #16 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #16 | 0.03 | |
| » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #18 | 0.57 | |
| » » » » » » » » » » » » » » » » » » » Event: Controller.startup #18 | 0.20 | |
| » » » » » » » » » » » » » » » » » » » Controller action #18 | 14.40 | |
| » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #18 | 10.12 | |
| » » » » » » » » » » » » » » » » » » » » Processing toolbar data #18 | 9.83 | |
| Rendering View #18 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #18 | 0.07 | |
| » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #11 | 3.69 | |
| » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #14 | 2.81 | |
| » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #14 | 2.16 | |
| » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #17 | 0.30 | |
| » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #17 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #17 | 0.03 | |
| » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #19 | 0.53 | |
| » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #19 | 0.13 | |
| » » » » » » » » » » » » » » » » » » » » Controller action #19 | 10.64 | |
| » » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #19 | 7.08 | |
| » » » » » » » » » » » » » » » » » » » » » Processing toolbar data #19 | 6.93 | |
| Rendering View #19 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #19 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/menu_teaser.php #12 | 2.83 | |
| » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #15 | 2.20 | |
| » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #15 | 1.74 | |
| » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #18 | 0.30 | |
| » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #18 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #18 | 0.02 | |
| » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #20 | 0.54 | |
| » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #20 | 0.13 | |
| » » » » » » » » » » » » » » » » » » » » » Controller action #20 | 6.24 | |
| » » » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #20 | 6.89 | |
| » » » » » » » » » » » » » » » » » » » » » » Processing toolbar data #20 | 6.76 | |
| Rendering View #20 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #20 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_foil.php #7 | 1.76 | |
| » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #8 | 2.85 | |
| » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #9 | 1.65 | |
| » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #19 | 0.29 | |
| » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #19 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #19 | 0.03 | |
| » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #21 | 0.53 | |
| » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #21 | 0.14 | |
| » » » » » » » » » » » » » » » » » » » » » » Controller action #21 | 3.86 | |
| » » » » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #21 | 7.07 | |
| » » » » » » » » » » » » » » » » » » » » » » » Processing toolbar data #21 | 6.88 | |
| Rendering View #21 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #21 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/url_teaser.php #4 | 2.91 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser.php #16 | 2.23 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_detail.php #16 | 1.79 | |
| » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #20 | 0.32 | |
| » » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #20 | 0.05 | |
| » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #20 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #22 | 0.62 | |
| » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #22 | 0.15 | |
| » » » » » » » » » » » » » » » » » » » » » » » Controller action #22 | 4.99 | |
| » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #22 | 7.91 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Processing toolbar data #22 | 7.74 | |
| Rendering View #22 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #22 | 0.05 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/teaser_foil.php #10 | 2.61 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendTeaser/View/Elements/teaser_foil.php #11 | 1.89 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #21 | 0.35 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #21 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #21 | 0.03 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #23 | 0.59 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #23 | 0.15 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Controller action #23 | 1.93 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #23 | 7.47 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Processing toolbar data #23 | 7.30 | |
| Rendering View #23 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #23 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2 | 0.73 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #22 | 0.31 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #22 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #22 | 0.03 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #24 | 0.65 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #24 | 0.18 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Controller action #24 | 1.67 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.beforeRender #24 | 7.13 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Processing toolbar data #24 | 6.96 | |
| Rendering View #24 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeRender #24 | 0.05 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/developer_template_cookie_consent.php | 0.46 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #23 | 0.28 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #23 | 0.04 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #23 | 0.03 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #24 | 0.24 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender #24 | 0.26 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeLayout | 0.02 | |
| » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Layouts/index.php | 32.52 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php | 1.18 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header.php | 15.81 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header_navbar.php | 12.68 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/navigation.php | 4.69 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/toolbar_navigation.php | 0.65 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/toolbar_navigation.php #2 | 0.49 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header_searchbar.php | 0.91 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/header_searchbar.php #2 | 0.78 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/sidebar.php | 0.84 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/similar-content.php | 0.18 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer.php | 10.55 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_subtree.php | 0.37 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_collapse.php | 0.19 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_subtree.php #2 | 0.30 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_collapse.php #2 | 0.18 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_subtree.php #3 | 0.40 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_collapse.php #3 | 0.18 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_subtree.php #4 | 0.43 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_collapse.php #4 | 0.19 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer_partner.php | 5.56 | |
| » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Elements/popup.php | 0.52 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| MH | |
| MH_IP | |
| BACKEND_APP_DIR | contrance |
| UPLOADS_APP | /var/www/vhosts/bad-reichenhall.de/httpdocs/contrance/ |
| UPLOAD_TMP_DIR | tmp/uploads/ |
| Constant | Value |
|---|---|
| APP | /var/www/vhosts/bad-reichenhall.de/httpdocs/ |
| APP_DIR | httpdocs |
| APPLIBS | /var/www/vhosts/bad-reichenhall.de/httpdocs/Lib/ |
| CACHE | /var/www/vhosts/bad-reichenhall.de/httpdocs/tmp/cache/ |
| CAKE | /var/www/vhosts/bad-reichenhall.de/httpdocs/contrance/Vendor/Cake/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /var/www/vhosts/bad-reichenhall.de/httpdocs/contrance/Vendor/Cake/lib |
| CORE_PATH | /var/www/vhosts/bad-reichenhall.de/httpdocs/contrance/Vendor/Cake/lib/ |
| CAKE_VERSION | 2.9.0 |
| CSS | /var/www/vhosts/bad-reichenhall.de/httpdocs/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | https://www.bad-reichenhall.de |
| IMAGES | /var/www/vhosts/bad-reichenhall.de/httpdocs/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /var/www/vhosts/bad-reichenhall.de/httpdocs/webroot/js/ |
| JS_URL | js/ |
| LOGS | /var/www/vhosts/bad-reichenhall.de/httpdocs/tmp/logs/ |
| ROOT | /var/www/vhosts/bad-reichenhall.de |
| TESTS | /var/www/vhosts/bad-reichenhall.de/httpdocs/Test/ |
| TMP | /var/www/vhosts/bad-reichenhall.de/httpdocs/tmp/ |
| VENDORS | /var/www/vhosts/bad-reichenhall.de/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /var/www/vhosts/bad-reichenhall.de/httpdocs/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 7.2.34 |
| User | u498543895345 |
| Home | /var/www/vhosts/bad-reichenhall.de |
| Script Name | /webroot/index.php |
| Request Uri | /home |
| Query String | |
| Request Method | GET |
| Server Protocol | HTTP/1.0 |
| Gateway Interface | CGI/1.1 |
| Redirect Url | /webroot/home |
| Remote Port | 59116 |
| Script Filename | /var/www/vhosts/bad-reichenhall.de/httpdocs/webroot/index.php |
| Server Admin | root@localhost |
| Context Document Root | /var/www/vhosts/bad-reichenhall.de/httpdocs |
| Context Prefix | |
| Request Scheme | https |
| Document Root | /var/www/vhosts/bad-reichenhall.de/httpdocs |
| Remote Addr | 152.53.39.37 |
| Server Port | 443 |
| Server Addr | 62.116.174.142 |
| Server Name | www.bad-reichenhall.de |
| Server Software | Apache |
| Server Signature | |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
| Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
| Http User Agent | Mozilla/5.0 (Windows NT 6.1; rv:60.0) Gecko/20100101 Firefox/60.0 |
| Http Connection | close |
| Http X Accel Internal | /internal-nginx-static-location |
| Http X Real Ip | 152.53.39.37 |
| Http Host | www.bad-reichenhall.de |
| Proxy-nokeepalive | 1 |
| Https | on |
| Passenger Download Native Support Binary | 0 |
| Passenger Compile Native Support Binary | 0 |
| Perl5lib | /usr/share/awstats/lib:/usr/share/awstats/plugins |
| Unique Id | Z2Adu@d3E6kcpqNfajxrSQAAAYk |
| Redirect Status | 200 |
| Redirect Https | on |
| Redirect Passenger Download Native Support Binary | 0 |
| Redirect Passenger Compile Native Support Binary | 0 |
| Redirect Perl5lib | /usr/share/awstats/lib:/usr/share/awstats/plugins |
| Redirect Unique Id | Z2Adu@d3E6kcpqNfajxrSQAAAYk |
| Redirect Redirect Status | 200 |
| Redirect Redirect Https | on |
| Redirect Redirect Passenger Download Native Support Binary | 0 |
| Redirect Redirect Passenger Compile Native Support Binary | 0 |
| Redirect Redirect Perl5lib | /usr/share/awstats/lib:/usr/share/awstats/plugins |
| Redirect Redirect Unique Id | Z2Adu@d3E6kcpqNfajxrSQAAAYk |
| Fcgi Role | RESPONDER |
| Php Self | /webroot/index.php |
| Request Time Float | 1734352315.713 |
| Request Time | 1734352315 |