Query Metrics
22
Database Queries
11
Different statements
138.58 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
108.31 ms (78.15%) |
1 |
SELECT * FROM translations_admin WHERE language = ?
Parameters:
[
"en"
]
|
|
7.10 ms (5.12%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle" "pimcore" ] |
|
4.92 ms (3.55%) |
1 |
CREATE TABLE IF NOT EXISTS prodanet_maintenancenotification ( notification_date datetime, notification_message nvarchar(50), notification_countdown_message nvarchar(50), notification_enabled boolean ) DEFAULT CHARSET=utf8mb4;
Parameters:
[] |
|
4.49 ms (3.24%) |
1 |
CREATE TABLE IF NOT EXISTS prodanet_pdf_groups ( id int NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8mb4;
Parameters:
[] |
|
4.42 ms (3.19%) |
1 |
CREATE TABLE IF NOT EXISTS prodanet_pdf_properties ( product_group_id int, property nvarchar(50) ) DEFAULT CHARSET=utf8mb4;
Parameters:
[] |
|
4.01 ms (2.89%) |
4 |
SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1
Parameters:
[
"plugin_bb_pim"
]
|
|
1.73 ms (1.25%) |
2 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
1.02 ms (0.74%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_definitions_excel_export');
Parameters:
[] |
|
0.90 ms (0.65%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.87 ms (0.63%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_pdf_properties_manager');
Parameters:
[] |
|
0.82 ms (0.59%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_maintenance_notification');
Parameters:
[] |
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.