Symfony Profiler

Query Metrics

21 Database Queries

10 Different statements

2.38 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 * 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 = ?
UPDATE users SET lastLogin = ? WHERE id = ?
SELECT cpath, list FROM users_workspaces_object WHERE userId = ?
SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL)
SELECT cpath, list FROM users_workspaces_object WHERE userId = ?
SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL)
SELECT id FROM tmp_store WHERE tag = ?

#▲	Time	Info
1	0.24 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.15 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "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\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
3	0.19 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 21`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 21;
4	0.17 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 21;
5	0.12 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 21;
6	0.11 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 21;
7	0.15 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';
8	0.11 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"Catalog" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'Catalog' AND scope = 'pimcore_perspectives';
9	0.08 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"CDP" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'CDP' AND scope = 'pimcore_perspectives';
10	0.06 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"CMS" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'CMS' AND scope = 'pimcore_perspectives';
11	0.06 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"Commerce" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'Commerce' AND scope = 'pimcore_perspectives';
12	0.05 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"DAM" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'DAM' AND scope = 'pimcore_perspectives';
13	0.05 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"default" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'default' AND scope = 'pimcore_perspectives';
14	0.05 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"DkerProdukt" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'DkerProdukt' AND scope = 'pimcore_perspectives';
15	0.05 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"PIM" "pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'PIM' AND scope = 'pimcore_perspectives';
16	0.28 ms	UPDATE users SET lastLogin = ? WHERE id = ? Parameters: [`1776272859 21`] View formatted query View runnable query Explain query UPDATE users SET lastLogin = ? WHERE id = ? UPDATE users SET lastLogin = 1776272859 WHERE id = 21;
17	0.10 ms	SELECT cpath, list FROM users_workspaces_object WHERE userId = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT cpath, list FROM users_workspaces_object WHERE userId = ? SELECT cpath, list FROM users_workspaces_object WHERE userId = 21;
18	0.06 ms	SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL) Parameters: [] View formatted query View runnable query Explain query SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL) SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL);
19	0.08 ms	SELECT cpath, list FROM users_workspaces_object WHERE userId = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT cpath, list FROM users_workspaces_object WHERE userId = ? SELECT cpath, list FROM users_workspaces_object WHERE userId = 21;
20	0.05 ms	SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL) Parameters: [] View formatted query View runnable query Explain query SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL) SELECT cpath, list FROM users_workspaces_object WHERE userId IN(NULL);
21	0.15 ms	SELECT id FROM tmp_store WHERE tag = ? Parameters: [`"1ee8ea3a_843a_6a10_b965_c5dc3c5dac9b"`] View formatted query View runnable query Explain query SELECT id FROM tmp_store WHERE tag = ? SELECT id FROM tmp_store WHERE tag = '1ee8ea3a_843a_6a10_b965_c5dc3c5dac9b';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://dueker.four.pimcore.fun/admin/bundle/backend-power-tools/alternative-element-tree/tree/status?_dc=1776272857660&configurationId=1ee8ea3a_843a_6a10_b965_…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping