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

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 'R%' 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 'R%' AND r0_.id IN (559, 374, 286, 462, 501, 552, 49, 461, 196, 163, 482, 41, 198, 8, 345, 297, 202, 568, 183, 393, 428, 3, 88, 460, 450, 124, 148, 37, 464, 112, 442, 204, 215, 184, 221, 139, 348, 602, 72) 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 = 559;

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

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

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

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

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

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

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

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

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

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

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

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

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