https://sieber-gaindorf.server13.zwei.gmbh/api/_action/message-queue/consume

Query Metrics

14 Database Queries
Different statements
3.06 ms Query time
Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.19 ms
(0.00%)
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
0.09 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.18 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.10 ms
(0.00%)
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
0.15 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',''))
0.15 ms
(0.00%)
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
0.38 ms
(0.00%)
SELECT last_updated_password_at FROM user WHERE id = :userId
0.11 ms
(0.00%)
SELECT item_rounding FROM currency WHERE id = :id
0.12 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.10 ms
(0.00%)
SELECT admin FROM `user` WHERE id = :id
0.77 ms
(0.00%)
DELETE FROM enqueue WHERE ((time_to_live IS NOT NULL) AND (time_to_live < :now)) AND (delivery_id IS NULL) AND (redelivered = :redelivered)
0.25 ms
(0.00%)
UPDATE enqueue SET delivery_id = :deliveryId, redelivered = :redelivered WHERE (redeliver_after < :now) AND (delivery_id IS NOT NULL)
0.12 ms
(0.00%)
SELECT id FROM enqueue WHERE (queue IN (:queues)) AND (delayed_until IS NULL OR delayed_until <= :delayedUntil) AND (delivery_id IS NULL) ORDER BY priority asc, published_at asc LIMIT 1
0.35 ms
(0.00%)
SELECT id FROM enqueue WHERE (queue IN (:queues)) AND (delayed_until IS NULL OR delayed_until <= :delayedUntil) AND (delivery_id IS NULL) ORDER BY priority asc, published_at asc LIMIT 1

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