https://sw6.fms-mainz.de/api/_action/message-queue/consume Return to referer URL

Method
POST
HTTP Status
200
IP
10.8.29.225
Profiled on
Token
e06869

Query Metrics

14 Database Queries
Different statements
3.06 ms Query time
Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.20 ms 
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
View formatted query    View runnable query    View query stack
2 0.20 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`;
View formatted query    View runnable query    View query stack
3 0.20 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
View formatted query    View runnable query    View query stack
4 0.28 ms 
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
View formatted query    View runnable query    View query stack
5 0.08 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',''))
View formatted query    View runnable query    View query stack
6 0.31 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
View formatted query    View runnable query    View query stack
7 0.18 ms 
SELECT last_updated_password_at FROM user WHERE id = :userId
View formatted query    View runnable query    View query stack
8 0.15 ms 
SELECT item_rounding FROM currency WHERE id = :id
View formatted query    View runnable query    View query stack
9 0.18 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
View formatted query    View runnable query    View query stack
10 0.13 ms 
SELECT admin FROM `user` WHERE id = :id
View formatted query    View runnable query    View query stack
11 0.54 ms 
DELETE FROM enqueue WHERE ((time_to_live IS NOT NULL) AND (time_to_live < :now)) AND (delivery_id IS NULL) AND (redelivered = :redelivered)
View formatted query    View runnable query    View query stack
12 0.17 ms 
UPDATE enqueue SET delivery_id = :deliveryId, redelivered = :redelivered WHERE (redeliver_after < :now) AND (delivery_id IS NOT NULL)
View formatted query    View runnable query    View query stack
13 0.22 ms 
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
View formatted query    View runnable query    View query stack
14 0.23 ms 
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
View formatted query    View runnable query    View query stack

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