Symfony Profiler

Query Metrics

29 Database Queries

13 Different statements

28.00 ms Query time

0 Invalid entities

Queries

default connection


SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
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 * FROM users WHERE `id` = ?
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 = ?
SELECT * FROM users WHERE `id` = ?
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 = ?
SELECT id FROM settings_store WHERE scope = ?
SELECT id FROM settings_store WHERE scope = ?
"START TRANSACTION"
SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ?
SELECT id FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ?  ORDER BY `creationDate` DESC LIMIT 1
"COMMIT"
SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0

#▲	Time	Info
1	1.29 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
2	0.97 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
3	1.21 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 520`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 520;
4	0.86 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`520`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 520;
5	0.91 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`520`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 520;
6	1.02 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`520`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 520;
7	1.16 ms	SELECT * FROM users WHERE `id` = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `id` = ? SELECT * FROM users WHERE `id` = 199;
8	0.91 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 199;
9	0.95 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 199;
10	0.90 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 199;
11	1.02 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" 199`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = 199;
12	0.92 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 199;
13	0.91 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 199;
14	0.90 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 199;
15	1.07 ms	SELECT * FROM users WHERE `id` = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `id` = ? SELECT * FROM users WHERE `id` = 395;
16	0.89 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 395;
17	0.95 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 395;
18	0.91 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 395;
19	0.96 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" 395`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = 395;
20	0.89 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 395;
21	0.98 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 395;
22	1.10 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 395;
23	1.03 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.92 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_custom_views"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_custom_views';
25	0.91 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
26	0.96 ms	SELECT COUNT() AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ? Parameters: [`520 "2026-03-26 08:57:43"`] View formatted query View runnable query Explain query SELECT COUNT() AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ? SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = 520 AND `read` = 0 AND `isStudio` = 0 AND creationDate >= '2026-03-26 08:57:43' ;
27	0.86 ms	SELECT id FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ? ORDER BY `creationDate` DESC LIMIT 1 Parameters: [`520 "2026-03-26 08:57:43"`] View formatted query View runnable query Explain query SELECT id FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ? ORDER BY `creationDate` DESC LIMIT 1 SELECT id FROM `notifications` WHERE recipient = 520 AND `read` = 0 AND `isStudio` = 0 AND creationDate >= '2026-03-26 08:57:43' ORDER BY `creationDate` DESC LIMIT 1;
28	0.76 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
29	0.91 ms	SELECT COUNT() AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 Parameters: [`520`] View formatted query View runnable query Explain query SELECT COUNT() AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = 520 AND `read` = 0 AND `isStudio` = 0 ;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
migration	doctrine.dbal.migration_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
migrations	doctrine.orm.migrations_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

migrations entity manager

No loaded entities.

Symfony Profiler

GET http://pimcore.eks.uat.diva-e.com/admin/notification/find-last-unread?_dc=1774515493894&lastUpdate=1774515463

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

migrations entity manager