Symfony Profiler

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  pemploye p0_
WHERE
  p0_.id NOT IN (
    SELECT
      p1_.id
    FROM
      lcontract l2_
      INNER JOIN pemploye p1_ ON l2_.employe_id = p1_.id
    WHERE
      l2_.active = 1
  )

SELECT COUNT(p0_.id) AS sclr_0 FROM pemploye p0_ WHERE p0_.id NOT IN (SELECT p1_.id FROM lcontract l2_ INNER JOIN pemploye p1_ ON l2_.employe_id = p1_.id WHERE l2_.active = 1);

SELECT
  p0_.id AS id_0,
  p0_.email AS email_1,
  p0_.sexe AS sexe_2,
  p0_.cin AS cin_3,
  p0_.nom AS nom_4,
  p0_.matricule AS matricule_5,
  p0_.prenom AS prenom_6
FROM
  pemploye p0_
WHERE
  p0_.id NOT IN (
    SELECT
      p1_.id
    FROM
      lcontract l2_
      INNER JOIN pemploye p1_ ON l2_.employe_id = p1_.id
    WHERE
      l2_.active = 1
  )
  AND (
    (
      p0_.cin LIKE ?
      OR p0_.matricule LIKE ?
      OR p0_.nom LIKE ?
      OR p0_.prenom LIKE ?
    )
  )
ORDER BY
  p0_.id DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.email AS email_1, p0_.sexe AS sexe_2, p0_.cin AS cin_3, p0_.nom AS nom_4, p0_.matricule AS matricule_5, p0_.prenom AS prenom_6 FROM pemploye p0_ WHERE p0_.id NOT IN (SELECT p1_.id FROM lcontract l2_ INNER JOIN pemploye p1_ ON l2_.employe_id = p1_.id WHERE l2_.active = 1) AND ((p0_.cin LIKE '%OUH%' OR p0_.matricule LIKE '%OUH%' OR p0_.nom LIKE '%OUH%' OR p0_.prenom LIKE '%OUH%')) ORDER BY p0_.id DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.enable AS enable_7,
  t0.created AS created_8,
  t0.email AS email_9,
  t0.updated AS updated_10,
  t0.user_updated_id AS user_updated_id_11,
  t0.dossier_responsable_id AS dossier_responsable_id_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = 3;