Symfony Profiler

Query Metrics

18 Database Queries

10 Different statements

97.75 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
INSERT IGNORE  INTO users_permission_definitions (`key`) VALUES ('prodanet_definitions_excel_export');
INSERT IGNORE  INTO users_permission_definitions (`key`) VALUES ('prodanet_maintenance_notification');
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;
INSERT IGNORE  INTO users_permission_definitions (`key`) VALUES ('prodanet_pdf_properties_manager');
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;
CREATE TABLE IF NOT EXISTS prodanet_pdf_properties (
            product_group_id int,
            property nvarchar(50)
        ) DEFAULT CHARSET=utf8mb4;
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin WHERE language = ?

#▲	Time	Info
1	0.84 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
2	3.04 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\AdminBundle\PimcoreAdminBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\AdminBundle\\PimcoreAdminBundle' AND scope = 'pimcore';
3	0.86 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\DataHubBundle\\PimcoreDataHubBundle' AND scope = 'pimcore';
4	0.77 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\DataHubBundle\\PimcoreDataHubBundle' AND scope = 'pimcore';
5	0.80 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\WebToPrintBundle\PimcoreWebToPrintBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\WebToPrintBundle\\PimcoreWebToPrintBundle' AND scope = 'pimcore';
6	0.70 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\FileExplorerBundle\PimcoreFileExplorerBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\FileExplorerBundle\\PimcoreFileExplorerBundle' AND scope = 'pimcore';
7	1.74 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SimpleBackendSearchBundle\PimcoreSimpleBackendSearchBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SimpleBackendSearchBundle\\PimcoreSimpleBackendSearchBundle' AND scope = 'pimcore';
8	1.57 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\PerspectiveEditorBundle\PimcorePerspectiveEditorBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\PerspectiveEditorBundle\\PimcorePerspectiveEditorBundle' AND scope = 'pimcore';
9	0.95 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Elements\Bundle\ProcessManagerBundle\ElementsProcessManagerBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Elements\\Bundle\\ProcessManagerBundle\\ElementsProcessManagerBundle' AND scope = 'pimcore';
10	0.76 ms	INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_definitions_excel_export'); Parameters: [] View formatted query View runnable query Explain query INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ( 'prodanet_definitions_excel_export' ); INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_definitions_excel_export');;
11	0.78 ms	INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_maintenance_notification'); Parameters: [] View formatted query View runnable query Explain query INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ( 'prodanet_maintenance_notification' ); INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_maintenance_notification');;
12	5.16 ms	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: [] View formatted query View runnable query Explain query 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; 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;;
13	0.90 ms	INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_pdf_properties_manager'); Parameters: [] View formatted query View runnable query Explain query INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ( 'prodanet_pdf_properties_manager' ); INSERT IGNORE INTO users_permission_definitions (`key`) VALUES ('prodanet_pdf_properties_manager');;
14	5.32 ms	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: [] View formatted query View runnable query Explain query 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; 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;;
15	5.70 ms	CREATE TABLE IF NOT EXISTS prodanet_pdf_properties ( product_group_id int, property nvarchar(50) ) DEFAULT CHARSET=utf8mb4; Parameters: [] View formatted query View runnable query Explain query CREATE TABLE IF NOT EXISTS prodanet_pdf_properties ( product_group_id int, property nvarchar(50) ) DEFAULT CHARSET = utf8mb4; CREATE TABLE IF NOT EXISTS prodanet_pdf_properties ( product_group_id int, property nvarchar(50) ) DEFAULT CHARSET=utf8mb4;;
16	0.74 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
17	0.83 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
18	66.30 ms	SELECT * FROM translations_admin WHERE language = ? Parameters: [`"en"`] View formatted query View runnable query Explain query SELECT * FROM translations_admin WHERE language = ? SELECT * FROM translations_admin WHERE language = 'en';

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.

Symfony Profiler

GET https://app-test.opengrpd.org/admin/login

Configuration Settings

Theme

Page Width