Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

45 Database Queries

3 Different statements

22.69 ms Query time

0 Invalid entities

Time▼	Count	Info
12.51 ms (55.14%)	43	SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = ? Parameters: [`15344`] 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 = 15344;
8.84 ms (38.95%)	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.34 ms (5.91%)	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;

Time▼

Count

Info

12.51 ms
(55.14%)

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

Parameters:

[
  15344
]

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 = 15344;

8.84 ms
(38.95%)

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.34 ms
(5.91%)

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;

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.