Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.cin AS cin_1,
  l1_.code AS code_2,
  l2_.id AS id_3,
  p0_.nom AS nom_4,
  p0_.prenom AS prenom_5,
  p3_.id AS id_6,
  p4_.id AS id_7
FROM
  pemploye p0_
  INNER JOIN lcontract l2_ ON (
    p0_.id = l2_.employe_id
    AND l2_.id = (
      SELECT
        MAX(l5_.id) AS sclr_8
      FROM
        lcontract l5_
        INNER JOIN pnature_contract p6_ ON l5_.pnature_contract_id = p6_.id
      WHERE
        l5_.employe_id = p0_.id
        AND p6_.id IN (1, 18)
    )
  )
  INNER JOIN pnature_contract p4_ ON l2_.pnature_contract_id = p4_.id
  INNER JOIN pdossier p3_ ON l2_.dossier_id = p3_.id
  LEFT JOIN lrib l1_ ON l2_.id = l1_.contact_id_id
WHERE
  p0_.active = ?
  AND p0_.stc = ?
  AND p4_.id IN (1, 18)
  AND (
    p0_.nom LIKE ?
    OR p0_.prenom LIKE ?
    OR p0_.cin LIKE ?
  )
LIMIT
  10

SELECT p0_.id AS id_0, p0_.cin AS cin_1, l1_.code AS code_2, l2_.id AS id_3, p0_.nom AS nom_4, p0_.prenom AS prenom_5, p3_.id AS id_6, p4_.id AS id_7 FROM pemploye p0_ INNER JOIN lcontract l2_ ON (p0_.id = l2_.employe_id AND l2_.id = (SELECT MAX(l5_.id) AS sclr_8 FROM lcontract l5_ INNER JOIN pnature_contract p6_ ON l5_.pnature_contract_id = p6_.id WHERE l5_.employe_id = p0_.id AND p6_.id IN (1, 18))) INNER JOIN pnature_contract p4_ ON l2_.pnature_contract_id = p4_.id INNER JOIN pdossier p3_ ON l2_.dossier_id = p3_.id LEFT JOIN lrib l1_ ON l2_.id = l1_.contact_id_id WHERE p0_.active = 0 AND p0_.stc = 0 AND p4_.id IN (1, 18) AND (p0_.nom LIKE '%Q297318%' OR p0_.prenom LIKE '%Q297318%' OR p0_.cin LIKE '%Q297318%') 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;