Query Metrics
13
Database Queries
8
Different statements
19.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.87 ms (35.99%) |
2 |
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:
[ 1773614284 [ "\x00tags\x00translation_data_2e364d315ad5ad984609e7f4beedf0f7" "translation_data_2e364d315ad5ad984609e7f4beedf0f7" ] ] |
|
2.78 ms (14.54%) |
1 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
2.28 ms (11.92%) |
1 |
SHOW TABLES LIKE "bundle_number_sequence_generator_register"
Parameters:
[] |
|
2.26 ms (11.82%) |
5 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "BUNDLE_INSTALLED__CustomerManagementFrameworkBundle\PimcoreCustomerManagementFrameworkBundle" "scope" => "pimcore" ] |
|
1.78 ms (9.31%) |
1 |
SHOW TABLES LIKE "bundle_number_sequence_generator_randomregister"
Parameters:
[] |
|
1.76 ms (9.22%) |
1 |
SELECT `id` FROM bundle_outputdataconfigtoolkit_outputdefinition LIMIT 1;
Parameters:
[] |
|
0.95 ms (5.00%) |
1 |
SELECT `key` FROM users_permission_definitions WHERE `key` = :key
Parameters:
[ "key" => "bundle_ecommerce_pricing_rules" ] |
|
0.42 ms (2.20%) |
1 |
SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1
Parameters:
[
"plugin_bb_pim"
]
|
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.