Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3 FROM realisateur t0 WHERE t0.id = ?

[
  104
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3
FROM
  realisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3 FROM realisateur t0 WHERE t0.id = 104;

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM film f0_ INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id WHERE r1_.id = ?

[
  104
]

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  film f0_
  INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id
  INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id
  LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id
WHERE
  r1_.id = ?

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM film f0_ INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id WHERE r1_.id = 104;

SELECT DISTINCT f0_.id AS id_0, a1_.annee AS annee_1 FROM film f0_ INNER JOIN film_realisateur f3_ ON f0_.id = f3_.film_id INNER JOIN realisateur r2_ ON r2_.id = f3_.realisateur_id LEFT JOIN annee a1_ ON f0_.film_annee = a1_.id WHERE r2_.id = ? ORDER BY a1_.annee DESC LIMIT 24

[
  104
]

SELECT
  DISTINCT f0_.id AS id_0,
  a1_.annee AS annee_1
FROM
  film f0_
  INNER JOIN film_realisateur f3_ ON f0_.id = f3_.film_id
  INNER JOIN realisateur r2_ ON r2_.id = f3_.realisateur_id
  LEFT JOIN annee a1_ ON f0_.film_annee = a1_.id
WHERE
  r2_.id = ?
ORDER BY
  a1_.annee DESC
LIMIT
  24

SELECT DISTINCT f0_.id AS id_0, a1_.annee AS annee_1 FROM film f0_ INNER JOIN film_realisateur f3_ ON f0_.id = f3_.film_id INNER JOIN realisateur r2_ ON r2_.id = f3_.realisateur_id LEFT JOIN annee a1_ ON f0_.film_annee = a1_.id WHERE r2_.id = 104 ORDER BY a1_.annee DESC LIMIT 24;

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.syno AS syno_2, f0_.octets AS octets_3, f0_.size_value AS size_value_4, f0_.size_unit AS size_unit_5, f0_.pochette AS pochette_6, f0_.ftp AS ftp_7, f0_.link AS link_8, f0_.film_disque AS film_disque_9, f0_.film_annee AS film_annee_10, f0_.film_langue AS film_langue_11 FROM film f0_ INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id WHERE r1_.id = ? AND f0_.id IN (?, ?, ?, ?, ?) ORDER BY a3_.annee DESC

[
  104
  960
  17
  10
  90
  458
]

SELECT
  f0_.id AS id_0,
  f0_.titre AS titre_1,
  f0_.syno AS syno_2,
  f0_.octets AS octets_3,
  f0_.size_value AS size_value_4,
  f0_.size_unit AS size_unit_5,
  f0_.pochette AS pochette_6,
  f0_.ftp AS ftp_7,
  f0_.link AS link_8,
  f0_.film_disque AS film_disque_9,
  f0_.film_annee AS film_annee_10,
  f0_.film_langue AS film_langue_11
FROM
  film f0_
  INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id
  INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id
  LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id
WHERE
  r1_.id = ?
  AND f0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  a3_.annee DESC

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.syno AS syno_2, f0_.octets AS octets_3, f0_.size_value AS size_value_4, f0_.size_unit AS size_unit_5, f0_.pochette AS pochette_6, f0_.ftp AS ftp_7, f0_.link AS link_8, f0_.film_disque AS film_disque_9, f0_.film_annee AS film_annee_10, f0_.film_langue AS film_langue_11 FROM film f0_ INNER JOIN film_realisateur f2_ ON f0_.id = f2_.film_id INNER JOIN realisateur r1_ ON r1_.id = f2_.realisateur_id LEFT JOIN annee a3_ ON f0_.film_annee = a3_.id WHERE r1_.id = 104 AND f0_.id IN (960, 17, 10, 90, 458) ORDER BY a3_.annee DESC;