Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

82 Database Queries

3 Different statements

31.30 ms Query time

0 Invalid entities

Time▼	Count	Info
22.98 ms (73.42%)	80	SELECT COUNT(l0_.id) AS sclr_0 FROM lien_auteur_livre l0_ WHERE l0_.auteur_id = ? Parameters: [`17025`] 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 = 17025;
7.02 ms (22.44%)	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.30 ms (4.14%)	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

22.98 ms
(73.42%)

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

Parameters:

[
  17025
]

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

7.02 ms
(22.44%)

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.30 ms
(4.14%)

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.