http://shopware.masterffl.com/api/search/user-config Return to referer URL

Query Metrics

12 Database Queries
Different statements
7.22 ms Query time
Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.39 ms
(0.00%)
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
0.39 ms
(0.00%)
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
0.44 ms
(0.00%)
SELECT custom_entity.name, custom_entity.fields
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
0.59 ms
(0.00%)
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
0.14 ms
(0.00%)
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1640000000_IS_ACTIVE = TRUE
0.56 ms
(0.00%)
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
0.26 ms
(0.00%)
SELECT last_updated_password_at FROM user WHERE id = :userId
3.50 ms
(0.00%)
SELECT item_rounding FROM currency WHERE id = :id
0.29 ms
(0.00%)
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = :userId
0.19 ms
(0.00%)
SELECT admin FROM `user` WHERE id = :id
0.26 ms
(0.00%)
SELECT `user_config`.`id` FROM `user_config` WHERE (`user_config`.`key` = :param_c1ac3c2599c2422c9800841aa1ed8536 AND `user_config`.`user_id` = :param_b1552cfd1cd443f2992814af2ea6707a) LIMIT 25
0.22 ms
(0.00%)
SELECT COUNT(*) FROM (SELECT `user_config`.`id` FROM `user_config` WHERE (`user_config`.`key` = :param_c1ac3c2599c2422c9800841aa1ed8536 AND `user_config`.`user_id` = :param_b1552cfd1cd443f2992814af2ea6707a)) total

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping