https://dev.artecon.426.agency/api/_action/frosh-tools/health/status

Query Metrics

12 Database Queries
Different statements
4.95 ms Query time
Invalid entities

Queries

Group similar statements

# Time Info
1 0.70 ms
# 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`;
2 0.42 ms
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
3 0.40 ms
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
4 0.11 ms
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_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1720536114_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_1604898081_IS_ACTIVE = TRUE;SET @MIGRATION_165657926_IS_ACTIVE = TRUE;SET @MIGRATION_1590657517_IS_ACTIVE = TRUE;SET @MIGRATION_1651494367_IS_ACTIVE = TRUE;SET @MIGRATION_1615371170_IS_ACTIVE = TRUE;SET @MIGRATION_1617881178_IS_ACTIVE = TRUE;SET @MIGRATION_1697795798_IS_ACTIVE = TRUE;SET @MIGRATION_1686812041_IS_ACTIVE = TRUE;SET @MIGRATION_1690469830_IS_ACTIVE = TRUE;SET @MIGRATION_1707984263_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE
5 1.02 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
6 1.14 ms
SELECT last_updated_password_at FROM user WHERE id = :userId
7 0.18 ms
SELECT item_rounding FROM currency WHERE id = :id
8 0.27 ms
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
9 0.16 ms
SELECT admin FROM `user` WHERE id = :id
10 0.10 ms
SELECT VERSION()
11 0.25 ms
SELECT IFNULL(MIN(published_at), 0) FROM enqueue
12 0.21 ms
SELECT s.scheduled_task_class, s.next_execution_time FROM scheduled_task s WHERE s.status NOT IN(:status)

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