Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

26 Database Queries

10 Different statements

47.41 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT * FROM users WHERE `type` = ? AND `name` = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
DELETE FROM cache_items WHERE item_id IN (?)
DELETE FROM cache_items WHERE item_id IN (?)
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope

#▲	Time	Info
1	1.30 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 8`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 8;
2	0.73 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 8;
3	0.70 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 8;
4	0.24 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 8;
5	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1758010751 [ "\x00tags\x00appf013f2deb2ca99615479ad95384d76537e155214" "appf013f2deb2ca99615479ad95384d76537e155214" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1758010751 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appf013f2deb2ca99615479ad95384d76537e155214', 'appf013f2deb2ca99615479ad95384d76537e155214');
6	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1758010751 [ "\x00tags\x00appf013f2deb2ca99615479ad95384d76537e155214" "appf013f2deb2ca99615479ad95384d76537e155214" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1758010751 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appf013f2deb2ca99615479ad95384d76537e155214', 'appf013f2deb2ca99615479ad95384d76537e155214');
7	7.75 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`3 => 300 4 => 1758010751 1 => "appf013f2deb2ca99615479ad95384d76537e155214" 2 => "O:43:"Symfony\Component\RateLimiter\Policy\Window":2:{s:39:"_login_global_pimcore_admin-172.24.0.47";d:1758010751.480691;s:8:"\x00\x00\x00\x01\x00\x00\x01,";i:15;}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('appf013f2deb2ca99615479ad95384d76537e155214', 'O:43:\"Symfony\\Component\\RateLimiter\\Policy\\Window\":2:{s:39:\"_login_global_pimcore_admin-172.24.0.47\";d:1758010751.480691;s:8:\"\0\0\0\0\0,\";i:15;}', 300, 1758010751) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
8	6.21 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`3 => 300 4 => 1758010751 1 => "\x00tags\x00appf013f2deb2ca99615479ad95384d76537e155214" 2 => "a:0:{}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('\0tags\0appf013f2deb2ca99615479ad95384d76537e155214', 'a:0:{}', 300, 1758010751) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
9	0.50 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1758010751 [ "\x00tags\x00appc19cd9b41b06839f65e181d4c350866d5ae7feb6" "appc19cd9b41b06839f65e181d4c350866d5ae7feb6" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1758010751 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appc19cd9b41b06839f65e181d4c350866d5ae7feb6', 'appc19cd9b41b06839f65e181d4c350866d5ae7feb6');
10	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1758010751 [ "\x00tags\x00appc19cd9b41b06839f65e181d4c350866d5ae7feb6" "appc19cd9b41b06839f65e181d4c350866d5ae7feb6" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1758010751 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appc19cd9b41b06839f65e181d4c350866d5ae7feb6', 'appc19cd9b41b06839f65e181d4c350866d5ae7feb6');
11	6.09 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`3 => 300 4 => 1758010751 1 => "appc19cd9b41b06839f65e181d4c350866d5ae7feb6" 2 => "O:43:"Symfony\Component\RateLimiter\Policy\Window":2:{s:62:"_login_local_pimcore_admin-m.baetta@amdlcircle.com-172.24.0.47";d:1758010751.495871;s:8:"\x00\x00\x00\x01\x00\x00\x01,";i:3;}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('appc19cd9b41b06839f65e181d4c350866d5ae7feb6', 'O:43:\"Symfony\\Component\\RateLimiter\\Policy\\Window\":2:{s:62:\"_login_local_pimcore_admin-m.baetta@amdlcircle.com-172.24.0.47\";d:1758010751.495871;s:8:\"\0\0\0\0\0,\";i:3;}', 300, 1758010751) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
12	8.18 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`3 => 300 4 => 1758010751 1 => "\x00tags\x00appc19cd9b41b06839f65e181d4c350866d5ae7feb6" 2 => "a:0:{}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('\0tags\0appc19cd9b41b06839f65e181d4c350866d5ae7feb6', 'a:0:{}', 300, 1758010751) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
13	0.46 ms	SELECT * FROM users WHERE `type` = ? AND `name` = ? Parameters: [`"user" "m.baetta@amdlcircle.com"`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND `name` = ? SELECT * FROM users WHERE `type` = 'user' AND `name` = 'm.baetta@amdlcircle.com';
14	0.25 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 8;
15	0.25 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 8;
16	0.18 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 8;
17	0.25 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" "3"`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = '3';
18	0.24 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 3;
19	0.21 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 3;
20	0.20 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 3;
21	6.10 ms	DELETE FROM cache_items WHERE item_id IN (?) Parameters: [`[ "appf013f2deb2ca99615479ad95384d76537e155214" "\x00tags\x00appf013f2deb2ca99615479ad95384d76537e155214" ]`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?) DELETE FROM cache_items WHERE item_id IN ('appf013f2deb2ca99615479ad95384d76537e155214', '\0tags\0appf013f2deb2ca99615479ad95384d76537e155214');
22	5.76 ms	DELETE FROM cache_items WHERE item_id IN (?) Parameters: [`[ "appc19cd9b41b06839f65e181d4c350866d5ae7feb6" "\x00tags\x00appc19cd9b41b06839f65e181d4c350866d5ae7feb6" ]`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?) DELETE FROM cache_items WHERE item_id IN ('appc19cd9b41b06839f65e181d4c350866d5ae7feb6', '\0tags\0appc19cd9b41b06839f65e181d4c350866d5ae7feb6');
23	0.29 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';
24	0.31 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "default" "scope" => "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'default' AND scope = 'pimcore_perspectives';
25	0.23 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "Alternative view" "scope" => "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'Alternative view' AND scope = 'pimcore_perspectives';
26	0.20 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "Assets only" "scope" => "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'Assets only' AND scope = 'pimcore_perspectives';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

http://amdl.caveaudigitale.com/admin/misc/ping?_dc=1758010751343

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache