Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.23 ms Query time

0 Invalid entities

Time▼	Count	Info
1.41 ms (63.41%)	1	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 4;
0.81 ms (36.59%)	1	SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.age AS age_2 FROM coiffeur c0_ WHERE c0_.compte_id = ? ORDER BY c0_.nom DESC Parameters: [`47`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.age AS age_2 FROM coiffeur c0_ WHERE c0_.compte_id = ? ORDER BY c0_.nom DESC SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.age AS age_2 FROM coiffeur c0_ WHERE c0_.compte_id = 47 ORDER BY c0_.nom DESC;

Time▼

Count

Info

1.41 ms
(63.41%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 4;

0.81 ms
(36.59%)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.age AS age_2 FROM coiffeur c0_ WHERE c0_.compte_id = ? ORDER BY c0_.nom DESC

Parameters:

[
  47
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.age AS age_2
FROM
  coiffeur c0_
WHERE
  c0_.compte_id = ?
ORDER BY
  c0_.nom DESC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.age AS age_2 FROM coiffeur c0_ WHERE c0_.compte_id = 47 ORDER BY c0_.nom DESC;

Name	Service
default	doctrine.dbal.default_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\Coiffeur	No errors.