Query Metrics
29
Database Queries
13
Different statements
28.00 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
4.83 ms (17.24%) |
5 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
520
]
|
|
4.69 ms (16.75%) |
5 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
520
]
|
|
4.46 ms (15.94%) |
5 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
520
]
|
|
3.19 ms (11.40%) |
3 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 520 ] |
|
2.23 ms (7.97%) |
2 |
SELECT * FROM users WHERE `id` = ?
Parameters:
[
199
]
|
|
1.95 ms (6.97%) |
2 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_perspectives"
]
|
|
1.29 ms (4.60%) |
1 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
0.97 ms (3.45%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.96 ms (3.42%) |
1 |
SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0 AND creationDate >= ?
Parameters:
[ 520 "2026-03-26 08:57:43" ] |
|
0.91 ms (3.26%) |
1 |
SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = ? AND `read` = 0 AND `isStudio` = 0
Parameters:
[
520
]
|
|
0.91 ms (3.25%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.86 ms (3.06%) |
1 |
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" ] |
|
0.76 ms (2.70%) |
1 |
"COMMIT"
Parameters:
[] |
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.