Symfony Profiler

Query Metrics

25 Database Queries

9 Different statements

30.96 ms Query time

0 Invalid entities

Queries

default connection


SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT * FROM users WHERE `id` = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT * FROM users WHERE `id` = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT id FROM settings_store WHERE scope = ?
SELECT id FROM settings_store WHERE scope = ?
SELECT count(*) FROM bundle_advancedobjectsearch_update_queue WHERE in_queue = 1

#▲	Time	Info
1	1.09 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
2	0.90 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';
3	1.24 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 520`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 520;
4	0.97 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`520`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 520;
5	1.15 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`520`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 520;
6	1.12 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`520`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 520;
7	1.21 ms	SELECT * FROM users WHERE `id` = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `id` = ? SELECT * FROM users WHERE `id` = 199;
8	1.03 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 199;
9	1.13 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 199;
10	1.07 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 199;
11	1.06 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" 199`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = 199;
12	1.01 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 199;
13	1.11 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 199;
14	1.04 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`199`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 199;
15	1.02 ms	SELECT * FROM users WHERE `id` = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `id` = ? SELECT * FROM users WHERE `id` = 395;
16	0.96 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 395;
17	1.09 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 395;
18	1.10 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 395;
19	1.13 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" 395`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = 395;
20	1.04 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 395;
21	1.11 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 395;
22	1.18 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 395;
23	0.99 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';
24	0.95 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_custom_views"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_custom_views';
25	5.26 ms	SELECT count() FROM bundle_advancedobjectsearch_update_queue WHERE in_queue = 1 Parameters: [] View formatted query View runnable query Explain query SELECT count() FROM bundle_advancedobjectsearch_update_queue WHERE in_queue = 1 SELECT count(*) FROM bundle_advancedobjectsearch_update_queue WHERE in_queue = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
migration	doctrine.dbal.migration_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
migrations	doctrine.orm.migrations_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

migrations entity manager

No loaded entities.

Symfony Profiler

GET http://pimcore.eks.uat.diva-e.com/admin/bundle/advanced-object-search/admin/check-index-status?_dc=1774520942871

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

migrations entity manager