POST https://sw65.test.firebearstudio.com/api/_action/message-queue/consume?q=%2Fapi%2F_action%2Fmessage-queue%2Fconsume

Query Metrics

13 Database Queries
13 Different statements
17.34 ms Query time

Grouped Statements

Show all queries

Time Count Info
2.16 ms
(12.48%)
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"£–Óã‘ØF_«¥ˆêbî†r"
]
1.80 ms
(10.40%)
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
1.73 ms
(9.99%)
1
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
1.66 ms
(9.58%)
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
Parameters:
[]
1.54 ms
(8.89%)
1
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters:
[
  b"£–Óã‘ØF_«¥ˆêbî†r"
]
1.48 ms
(8.56%)
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:
[]
1.42 ms
(8.17%)
1
DELETE FROM messenger_messages WHERE delivered_at = ?
Parameters:
[
  "9999-12-31 23:59:59"
]
1.34 ms
(7.73%)
1
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = ?
Parameters:
[
  "cache-id"
]
1.18 ms
(6.82%)
1
SELECT admin FROM `user` WHERE id = ?
Parameters:
[
  b"£–Óã‘ØF_«¥ˆêbî†r"
]
0.96 ms
(5.54%)
1
SELECT m.* FROM messenger_messages m WHERE (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) AND (m.queue_name = ?) ORDER BY available_at ASC LIMIT 1 FOR UPDATE
Parameters:
[
  "2024-11-27 10:45:46"
  "2024-11-27 11:45:46"
  "default"
]
0.81 ms
(4.69%)
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.68 ms
(3.94%)
1
"START TRANSACTION"
Parameters:
[]
0.56 ms
(3.21%)
1
"COMMIT"
Parameters:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.