GET https://ed-bestellung.de/api/_action/frosh-tools/health/status

Query Metrics

14 Database Queries
14 Different statements
4.87 ms Query time

Grouped Statements

Show all queries

Time Count Info
1.10 ms
(22.59%)
1
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
0.96 ms
(19.76%)
1
SELECT s.scheduled_task_class, s.next_execution_time FROM scheduled_task s WHERE s.status NOT IN(?, ?)
Parameters:
[
  "inactive"
  "skipped"
]
0.63 ms
(12.94%)
1
# 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`;
Parameters:
[]
0.42 ms
(8.60%)
1
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
0.35 ms
(7.19%)
1
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
0.30 ms
(6.20%)
1
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters:
[
  b"\v¡\x12–`âMR†\x02\x19ù;%}C"
]
0.23 ms
(4.64%)
1
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters:
[]
0.21 ms
(4.25%)
1
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = ?
Parameters:
[
  b"\v¡\x12–`âMR†\x02\x19ù;%}C"
]
0.15 ms
(3.02%)
1
SELECT COUNT(*) FROM plugin WHERE updated_at < DATE_SUB(NOW(), INTERVAL 1 DAY)
Parameters:
[]
0.14 ms
(2.85%)
1
SELECT available_at FROM messenger_messages WHERE available_at < UTC_TIMESTAMP() ORDER BY available_at ASC LIMIT 1
Parameters:
[]
0.13 ms
(2.57%)
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.10 ms
(2.08%)
1
SELECT admin FROM `user` WHERE id = ?
Parameters:
[
  b"\v¡\x12–`âMR†\x02\x19ù;%}C"
]
0.09 ms
(1.83%)
1
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',''))
Parameters:
[]
0.07 ms
(1.48%)
1
SELECT VERSION()
Parameters:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.