Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

10.41 ms Query time

0 Invalid entities

Time▼	Count	Info
7.39 ms (70.95%)	1	SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0 WHERE t0.id = 1;
3.02 ms (29.05%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.users_id AS users_id_3 FROM t_role t0 WHERE t0.users_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.users_id AS users_id_3 FROM t_role t0 WHERE t0.users_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.users_id AS users_id_3 FROM t_role t0 WHERE t0.users_id = 1;

Time▼

Count

Info

7.39 ms
(70.95%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.username AS username_3,
  t0.password AS password_4
FROM
  t_admin_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0 WHERE t0.id = 1;

3.02 ms
(29.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.users_id AS users_id_3 FROM t_role t0 WHERE t0.users_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.users_id AS users_id_3
FROM
  t_role t0
WHERE
  t0.users_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.users_id AS users_id_3 FROM t_role t0 WHERE t0.users_id = 1;

Name	Service
default	doctrine.dbal.default_connection
clickhouse	doctrine.dbal.clickhouse_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Role	No errors.