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 count(DISTINCT r0_.id) AS sclr_0 FROM realisateur r0_ WHERE r0_.nom LIKE ?

[
  "O%"
]

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  realisateur r0_
WHERE
  r0_.nom LIKE ?

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM realisateur r0_ WHERE r0_.nom LIKE 'O%';

SELECT DISTINCT r0_.id AS id_0, r0_.nom AS nom_1, r0_.prenom AS prenom_2 FROM realisateur r0_ WHERE r0_.nom LIKE ? ORDER BY r0_.nom ASC, r0_.prenom ASC LIMIT 48

[
  "O%"
]

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.prenom AS prenom_2
FROM
  realisateur r0_
WHERE
  r0_.nom LIKE ?
ORDER BY
  r0_.nom ASC,
  r0_.prenom ASC
LIMIT
  48

SELECT DISTINCT r0_.id AS id_0, r0_.nom AS nom_1, r0_.prenom AS prenom_2 FROM realisateur r0_ WHERE r0_.nom LIKE 'O%' ORDER BY r0_.nom ASC, r0_.prenom ASC LIMIT 48;

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.prenom AS prenom_2 FROM realisateur r0_ WHERE r0_.nom LIKE ? AND r0_.id IN (?, ?, ?, ?, ?) ORDER BY r0_.nom ASC, r0_.prenom ASC

[
  "O%"
  293
  99
  273
  240
  138
]

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.prenom AS prenom_2
FROM
  realisateur r0_
WHERE
  r0_.nom LIKE ?
  AND r0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  r0_.nom ASC,
  r0_.prenom ASC

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.prenom AS prenom_2 FROM realisateur r0_ WHERE r0_.nom LIKE 'O%' AND r0_.id IN (293, 99, 273, 240, 138) ORDER BY r0_.nom ASC, r0_.prenom ASC;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = ?

[
  293
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.syno AS syno_3,
  t0.octets AS octets_4,
  t0.size_value AS size_value_5,
  t0.size_unit AS size_unit_6,
  t0.pochette AS pochette_7,
  t0.ftp AS ftp_8,
  t0.link AS link_9,
  t0.film_disque AS film_disque_10,
  t0.film_annee AS film_annee_11,
  t0.film_langue AS film_langue_12
FROM
  film t0
  INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id
WHERE
  film_realisateur.realisateur_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = 293;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = ?

[
  99
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.syno AS syno_3,
  t0.octets AS octets_4,
  t0.size_value AS size_value_5,
  t0.size_unit AS size_unit_6,
  t0.pochette AS pochette_7,
  t0.ftp AS ftp_8,
  t0.link AS link_9,
  t0.film_disque AS film_disque_10,
  t0.film_annee AS film_annee_11,
  t0.film_langue AS film_langue_12
FROM
  film t0
  INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id
WHERE
  film_realisateur.realisateur_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = 99;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = ?

[
  273
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.syno AS syno_3,
  t0.octets AS octets_4,
  t0.size_value AS size_value_5,
  t0.size_unit AS size_unit_6,
  t0.pochette AS pochette_7,
  t0.ftp AS ftp_8,
  t0.link AS link_9,
  t0.film_disque AS film_disque_10,
  t0.film_annee AS film_annee_11,
  t0.film_langue AS film_langue_12
FROM
  film t0
  INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id
WHERE
  film_realisateur.realisateur_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = 273;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = ?

[
  240
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.syno AS syno_3,
  t0.octets AS octets_4,
  t0.size_value AS size_value_5,
  t0.size_unit AS size_unit_6,
  t0.pochette AS pochette_7,
  t0.ftp AS ftp_8,
  t0.link AS link_9,
  t0.film_disque AS film_disque_10,
  t0.film_annee AS film_annee_11,
  t0.film_langue AS film_langue_12
FROM
  film t0
  INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id
WHERE
  film_realisateur.realisateur_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = 240;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = ?

[
  138
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.syno AS syno_3,
  t0.octets AS octets_4,
  t0.size_value AS size_value_5,
  t0.size_unit AS size_unit_6,
  t0.pochette AS pochette_7,
  t0.ftp AS ftp_8,
  t0.link AS link_9,
  t0.film_disque AS film_disque_10,
  t0.film_annee AS film_annee_11,
  t0.film_langue AS film_langue_12
FROM
  film t0
  INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id
WHERE
  film_realisateur.realisateur_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.syno AS syno_3, t0.octets AS octets_4, t0.size_value AS size_value_5, t0.size_unit AS size_unit_6, t0.pochette AS pochette_7, t0.ftp AS ftp_8, t0.link AS link_9, t0.film_disque AS film_disque_10, t0.film_annee AS film_annee_11, t0.film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0.id = film_realisateur.film_id WHERE film_realisateur.realisateur_id = 138;