Query Metrics
22
Database Queries
11
Different statements
179.46 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
148.42 ms (82.70%) |
1 |
SELECT * FROM translations_admin WHERE language = ?
Parameters:
[
"en"
]
|
|
6.61 ms (3.68%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle" "pimcore" ] |
|
5.56 ms (3.10%) |
1 |
CREATE TABLE IF NOT EXISTS prodanet_pdf_properties ( product_group_id int, property nvarchar(50) ) DEFAULT CHARSET=utf8mb4;
Parameters:
[] |
|
5.10 ms (2.84%) |
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.63 ms (2.58%) |
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:
[] |
|
3.99 ms (2.22%) |
4 |
SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1
Parameters:
[
"plugin_bb_pim"
]
|
|
2.08 ms (1.16%) |
2 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
0.83 ms (0.46%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.83 ms (0.46%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_definitions_excel_export');
Parameters:
[] |
|
0.73 ms (0.40%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_maintenance_notification');
Parameters:
[] |
|
0.69 ms (0.38%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_pdf_properties_manager');
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.