| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `LakeReportGalleryMedia`.`id`, `LakeReportGalleryMedia`.`hash`, `LakeReportGalleryMedia`.`created`, `LakeReportGalleryMedia`.`updated`, `LakeReportGalleryMedia`.`title`, `LakeReportGalleryMedia`.`status`, `LakeReportGalleryMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) AS `LakeReportGalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `LakeReportGalleryMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'lake_report_gallery' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `DownloadTeaserFileMedia`.`id`, `DownloadTeaserFileMedia`.`hash`, `DownloadTeaserFileMedia`.`created`, `DownloadTeaserFileMedia`.`updated`, `DownloadTeaserFileMedia`.`title`, `DownloadTeaserFileMedia`.`status`, `DownloadTeaserFileMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) AS `DownloadTeaserFileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `DownloadTeaserFileMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'download_teaser_file' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 374 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `POI`.`id`, `POI`.`hash`, `POI`.`created`, `POI`.`updated`, `POI`.`internal_title`, `POI`.`ordering_number`, `POI`.`address_zip`, `POI`.`address_city`, `POI`.`address_street`, `POI`.`address_country`, `POI`.`address_lat`, `POI`.`address_long`, `POI`.`phone`, `POI`.`email`, `POI`.`fax`, `POI`.`starting_point_zip`, `POI`.`starting_point_city`, `POI`.`starting_point_street`, `POI`.`starting_point_country`, `POI`.`starting_point_lat`, `POI`.`starting_point_long`, `POI`.`accessibility`, `POI`.`webcam`, `POI`.`height`, `POI`.`overnight_stay`, `POI`.`alpine_club`, `POI`.`family_friendly`, `POI`.`tip_for_bad_weather`, `POI`.`tickets`, `POI`.`seasons`, `POI`.`categories`, `POI`.`external_id`, `POI`.`customer_fax`, `POI`.`customer_mobile`, `POI`.`customer_phone`, `POI`.`customer_web`, `POI`.`customer_email`, `POI`.`customer_company`, `POI`.`customer_salutation`, `POI`.`customer_name`, `POI`.`customer_first_name`, `POI`.`customer_street`, `POI`.`customer_zip`, `POI`.`customer_city`, `POI`.`customer_country`, `POI`.`show_customer_communication_address`, `POI`.`municipality`, `POI`.`status`, `POI`.`gallery1_position`, `POI`.`gallery2_position`, `POI`.`gallery3_position`, `POI`.`gallery4_position`, `POI`.`gallery5_position`, `POI`.`gallery6_position`, `POI`.`gallery7_position`, `POI`.`gallery8_position`, `POI`.`gallery9_position`, `POI`.`gallery10_position`, `POI`.`webcam_layout`, `POI`.`advertising_banner_id`, `POI`.`widget_code`, (CONCAT_WS (',',`POI`.`address_lat`,`POI`.`address_long`)) AS `POI__address`, (CONCAT_WS (',',`POI`.`starting_point_lat`,`POI`.`starting_point_long`)) AS `POI__starting_point`, `ContentsPoi`.`id`, `ContentsPoi`.`content_id`, `ContentsPoi`.`poi_id`, `ContentsPoi`.`position` FROM `wfg`.`poi` AS `POI` JOIN `wfg`.`contents_poi` AS `ContentsPoi` ON (`ContentsPoi`.`content_id` = 374 AND `ContentsPoi`.`poi_id` = `POI`.`id`) ORDER BY `ContentsPoi`.`position` ASC | 0 | 0 | 0 | |
| SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social-media' AND `Language`.`langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 1042 AND `Menu`.`rght` < 1047 ORDER BY `Menu`.`lft` asc | 2 | 2 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1105 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 819 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (2523, 1818) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
| SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-partner' AND `Language`.`langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 1122 AND `Menu`.`rght` < 1137 ORDER BY `Menu`.`lft` asc | 7 | 7 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 194 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 507 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8749) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 509 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8750) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1040 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9071) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1039 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8752) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1038 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8751) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 935 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8693) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (173, 2422, 2424, 2504, 2503, 2502, 2486) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
| SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`languages` AS `Language` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1 | 2 | 2 | 0 | |
| SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `wfg`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC | 4 | 4 | 0 | |
| SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 2979 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2872) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`id` = 2979 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 157 AND `Menu`.`rght` >= 202 AND `Menu`.`id` NOT IN (106, 15, 172, 173, 2, 34, 58, 967, 16, 17, 117, 118, 1263, 1264, 1265, 1266) ORDER BY `Menu`.`lft` asc | 2 | 2 | 1 | maybe slow |
| SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`languages` AS `Language` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `wfg`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
| SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'de' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'en' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc | 0 | 0 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'home' AND `MountPoint`.`language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view` FROM `wfg`.`menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 1 | 1 | 0 | |
| SELECT `Parent`.`id` FROM `wfg`.`menus` AS `Menu` JOIN `wfg`.`menus` AS `Parent` ON (`Parent`.`lft` <= `Menu`.`lft` AND `Parent`.`rght` >= `Menu`.`rght`) JOIN `wfg`.`uploads` AS `Upload` ON (`Upload`.`foreign_key` = `Parent`.`id` AND `Upload`.`model` = 'Menu' AND `Upload`.`field` = 'icon') WHERE `Menu`.`id` = 2979 ORDER BY `Parent`.`lft` DESC LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar_nav' AND `Language`.`langid` = 'de' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc | 0 | 0 | 0 | |
| SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 1048 AND `Menu`.`rght` < 1121 ORDER BY `Menu`.`lft` asc | 36 | 36 | 0 | |
| SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'news' AND `Language`.`langid` = 'de' LIMIT 1 | 0 | 0 | 0 | |
| SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1225 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1225) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'nav-banner' AND `Language`.`langid` = 'de' LIMIT 1 | 0 | 0 | 0 | |
| SELECT *, Language.id FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'free-consultation' AND `Language`.`langid` = 'de' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `wfg`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `wfg`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'toolbar_nav' AND `Language`.`langid` = 'de' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/titel-bild' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1025 AND `Route`.`rght` >= 1026 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1828 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2916) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2916 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9870 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9870) 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 `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9870 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 4 | 4 | 1 | maybe slow |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9870 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 1 | maybe slow |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/unternehmensnetzwerk-verantwortungsvoll-wirtschaften' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 905 AND `Route`.`rght` >= 906 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1797 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2879) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 1 | maybe slow |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2879 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 `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/leerer-platzhalter' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1029 AND `Route`.`rght` >= 1030 ORDER BY `Route`.`lft` asc | 5 | 5 | 1 | maybe slow |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1830 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2918) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2918 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 `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/nachhaltigkeitspunkte-verantwortungsvoll-w' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1027 AND `Route`.`rght` >= 1028 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1829 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2917) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2917 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 `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/asp-dr-thomas-birner' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 907 AND `Route`.`rght` >= 908 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1798 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2880) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2880 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `Employee`.`id`, `Employee`.`hash`, `Employee`.`created`, `Employee`.`updated`, `Employee`.`title`, `Employee`.`first_name`, `Employee`.`role`, `Employee`.`last_name`, `Employee`.`telephone`, `Employee`.`mobile`, `Employee`.`fax`, `Employee`.`email`, `Employee`.`company`, `Employee`.`street`, `Employee`.`zip_code`, `Employee`.`city`, `Employee`.`description`, `Employee`.`professional_title`, `Employee`.`level_of_employment`, `Employee`.`personal_information`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`employees` AS `Employee` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Employee`.`id` AND `Route`.`model` = 'Employee') WHERE `Employee`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Task`.`id`, `Task`.`hash`, `Task`.`created`, `Task`.`updated`, `Task`.`title`, `EmployeesTask`.`id`, `EmployeesTask`.`hash`, `EmployeesTask`.`created`, `EmployeesTask`.`updated`, `EmployeesTask`.`employee_id`, `EmployeesTask`.`task_id` FROM `wfg`.`tasks` AS `Task` JOIN `wfg`.`employees_tasks` AS `EmployeesTask` ON (`EmployeesTask`.`employee_id` = 5 AND `EmployeesTask`.`task_id` = `Task`.`id`) | 6 | 6 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Employee' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (8614) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
| SELECT `ImageBusinessCardMedia`.`id`, `ImageBusinessCardMedia`.`hash`, `ImageBusinessCardMedia`.`created`, `ImageBusinessCardMedia`.`updated`, `ImageBusinessCardMedia`.`title`, `ImageBusinessCardMedia`.`status`, `ImageBusinessCardMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageBusinessCardMedia`.`id`) AS `ImageBusinessCardMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageBusinessCardMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `ImageBusinessCardMedia`.`id`) WHERE `MediaEntity`.`model` = 'Employee' AND `MediaEntity`.`field` = 'image_business_card' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 1 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8614 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8614 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 6 | 6 | 1 | maybe slow |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8614 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 1 | maybe slow |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/preis-projekt-nachhaltigkeit' LIMIT 1 | 1 | 1 | 6 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1157 AND `Route`.`rght` >= 1158 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 2305 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3500 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 `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3192 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 1 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10082) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 3080 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3456) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3456 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (3149) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3149 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10081) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 1 | maybe slow |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (3080) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 10082 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 10082 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 `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 10082 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/vorteile-mitglied-netzwerk' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 931 AND `Route`.`rght` >= 932 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1800 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2883 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 `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2580 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9660) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 12 | 12 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2980 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2882) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2882 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2579) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2579 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2980) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9660 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9660 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 `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9660 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/die-teilnahme-am-unternehmensnetzwerk' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1007 AND `Route`.`rght` >= 1008 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1803 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2888 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2585 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9694) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2981 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2886) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2886 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2583) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2583 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2981) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9694 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9694 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 3 | 3 | 1 | maybe slow |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9694 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 1 | 1 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/teilnehmende-betriebe-am-unternehmennetzwerk' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1021 AND `Route`.`rght` >= 1022 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1804 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2890 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 `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2587 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 1 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9679) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2983 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2889) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2889 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2586) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2586 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2983) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9679 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9679 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 `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9679 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 1 | 1 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/aktuelle-themen' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1023 AND `Route`.`rght` >= 1024 ORDER BY `Route`.`lft` asc | 5 | 5 | 1 | maybe slow |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1805 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2588 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 1 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9851) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9851 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9851 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 `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9851 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/verantwortungsvoll-wirtschaften/pressestimmen-fuer-das-netzwerk' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Route`.`model`, `Route`.`foreign_key` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`lft` <= 1031 AND `Route`.`rght` >= 1032 ORDER BY `Route`.`lft` asc | 5 | 5 | 0 | |
| SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`employee_id`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`placeholder_text`, `Content`.`countdown_datetime`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (1=1) AS `Content__published`, (1=1) AS `Content__isActive`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`contents` AS `Content` LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 1860 AND (1=1) = '1' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2953 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2650 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 1 | 1 | 0 | |
| SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `wfg`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9904) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 11 | 11 | 1 | maybe slow |
| SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`canonical_url`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`button_color` FROM `wfg`.`menus` AS `Menu` LEFT JOIN `wfg`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `wfg`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `wfg`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `wfg`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2982 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2887) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2887 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 `wfg`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (2584) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `wfg`.`media` AS `ImageMedia` JOIN `wfg`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2584 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
| SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `wfg`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (2982) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9904 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9904 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 5 | 5 | 1 | maybe slow |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9904 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'search' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `wfg`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `Route`.`id` = 28575 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 4225 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 4225 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 4225 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8749 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8749 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8749 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8750 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8750 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8750 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 9071 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9071 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 6 | 6 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 9071 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8752 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8752 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8752 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8751 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8751 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8751 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `wfg`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `wfg`.`media` AS `Media` WHERE `Media`.`id` = 8693 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `TagsTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8693 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags' | 2 | 2 | 0 | |
| SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `wfg`.`tags` AS `CopyrightTag` JOIN `wfg`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 8693 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright' | 0 | 0 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `wfg`.`mount_points` AS `MountPoint` LEFT JOIN `wfg`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `wfg`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1 | 1 | 1 | 0 | |
