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

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 'F%' 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 'F%' AND r0_.id IN (81, 35, 66, 491, 471, 261, 182, 388, 96, 356, 414, 28, 29, 298, 436, 271, 113, 402, 235, 406) 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 = 81;

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = ?