Query Metrics
27
Database Queries
7
Different statements
3.19 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.26 ms (39.47%) |
9 |
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:
[ 1784736054 "data_director_installed" ] |
|
0.81 ms (25.23%) |
1 |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1784736054 "data_director_installed" ] |
|
0.56 ms (17.65%) |
10 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle" "pimcore" ] |
|
0.27 ms (8.46%) |
4 |
SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1
Parameters:
[
"plugin_bb_pim"
]
|
|
0.17 ms (5.20%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.07 ms (2.20%) |
1 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
0.06 ms (1.79%) |
1 |
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:
[ 1784736055 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] |
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.
Managed Entities
No managed entities.
Entities Mapping
No mapped entities.