Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

17.85 ms Query time

0 Invalid entities

Time▼	Count	Info
15.99 ms (89.59%)	1	SELECT a0_.id AS id_0, a0_.nom AS nom_1 FROM auteur a0_ ORDER BY a0_.nom ASC Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.nom AS nom_1 FROM auteur a0_ ORDER BY a0_.nom ASC SELECT a0_.id AS id_0, a0_.nom AS nom_1 FROM auteur a0_ ORDER BY a0_.nom ASC;
1.41 ms (7.88%)	1	SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0;
0.45 ms (2.53%)	1	SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = ? Parameters: [`14889`] View formatted query View runnable query Explain query SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = ? SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = 14889;

Time▼

Count

Info

15.99 ms
(89.59%)

SELECT a0_.id AS id_0, a0_.nom AS nom_1 FROM auteur a0_ ORDER BY a0_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1
FROM
  auteur a0_
ORDER BY
  a0_.nom ASC

SELECT a0_.id AS id_0, a0_.nom AS nom_1 FROM auteur a0_ ORDER BY a0_.nom ASC;

1.41 ms
(7.88%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  auteur t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0;

0.45 ms
(2.53%)

SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = ?

Parameters:

[
  14889
]

View formatted query View runnable query Explain query

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  lien_auteur_livre l0_
WHERE
  l0_.auteur_id = ?

SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = 14889;

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\Auteur	No errors.
App\Entity\LienAuteurLivre	No errors.