Symfony Profiler

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 'M%';

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 'M%' 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

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.prenom AS prenom_2 FROM realisateur r0_ WHERE r0_.nom LIKE 'M%' AND r0_.id IN (331, 158, 263, 451, 423, 107, 43, 191, 312, 63, 269, 358, 117, 476, 360, 472, 248, 448, 7, 469, 325, 156, 192, 499, 24, 152, 213, 200, 134, 150, 151, 153, 101, 165, 106, 159, 98, 342, 111, 233, 157, 456, 444, 489, 87) 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 = ?

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

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

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

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

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

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

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

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

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

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

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

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

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

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