Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

9 Database Queries

5 Different statements

11.90 ms Query time

0 Invalid entities

Queries

Group similar statements


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 `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, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)

#▲	Time	Info
1	3.58 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 7`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 7;
2	0.38 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 7;
3	0.06 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 7;
4	0.04 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 7;
5	0.09 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" "5"`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = '5';
6	0.78 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 5;
7	0.66 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 5;
8	0.05 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 5;
9	6.27 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775568504 [ "asset_6473" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775568504 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('asset_6473');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

https://brand.develey.blackbit.io/admin/asset/get-image-thumbnail?alt=&height=undefined&id=6473&pimcore_editmode=1&thumbnail=mainStageBackgroundBbqueBundle

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://brand.develey.blackbit.io/admin/asset/get-image-thumbnail?alt=&height=undefined&id=6473&pimcore_editmode=1&thumbnail=mainStageBackgroundBbqueBundle

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping