Query Metrics
22
Database Queries
11
Different statements
129.16 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
96.16 ms (74.45%) |
1 |
SELECT * FROM translations_admin WHERE language = ?
Parameters:
[
"en"
]
|
|
7.16 ms (5.54%) |
1 |
CREATE TABLE IF NOT EXISTS prodanet_pdf_properties ( product_group_id int, property nvarchar(50) ) DEFAULT CHARSET=utf8mb4;
Parameters:
[] |
|
6.28 ms (4.86%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle" "pimcore" ] |
|
5.75 ms (4.45%) |
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.94 ms (3.82%) |
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:
[] |
|
3.79 ms (2.94%) |
4 |
SELECT * FROM users_permission_definitions WHERE `key`=? LIMIT 1
Parameters:
[
"plugin_bb_pim"
]
|
|
1.75 ms (1.35%) |
2 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
0.97 ms (0.75%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_definitions_excel_export');
Parameters:
[] |
|
0.82 ms (0.64%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.80 ms (0.62%) |
1 |
INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_pdf_properties_manager');
Parameters:
[] |
|
0.74 ms (0.57%) |
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.