Symfony Profiler

SELECT
  p0_.id AS id_0,
  p1_.designation AS designation_1,
  l2_.code AS code_2,
  p0_.cin AS cin_3,
  p0_.nom AS nom_4,
  l2_.id AS id_5,
  p0_.prenom AS prenom_6
FROM
  pemploye p0_
  INNER JOIN lcontract l2_ ON p0_.id = l2_.employe_id
  INNER JOIN ldossier_contract l3_ ON l2_.id = l3_.contract_id_id
  INNER JOIN pnature_contract p1_ ON l2_.pnature_contract_id = p1_.id
WHERE
  l2_.active = 1
  AND l3_.active = 1
  AND l3_.dossier_id_id = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p1_.designation AS designation_1, l2_.code AS code_2, p0_.cin AS cin_3, p0_.nom AS nom_4, l2_.id AS id_5, p0_.prenom AS prenom_6 FROM pemploye p0_ INNER JOIN lcontract l2_ ON p0_.id = l2_.employe_id INNER JOIN ldossier_contract l3_ ON l2_.id = l3_.contract_id_id INNER JOIN pnature_contract p1_ ON l2_.pnature_contract_id = p1_.id WHERE l2_.active = 1 AND l3_.active = 1 AND l3_.dossier_id_id = 90 ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p1_.designation AS designation_1,
  l2_.code AS code_2,
  p0_.cin AS cin_3,
  p0_.nom AS nom_4,
  l2_.id AS id_5,
  p0_.prenom AS prenom_6
FROM
  pemploye p0_
  INNER JOIN lcontract l2_ ON p0_.id = l2_.employe_id
  INNER JOIN ldossier_contract l3_ ON l2_.id = l3_.contract_id_id
  INNER JOIN pnature_contract p1_ ON l2_.pnature_contract_id = p1_.id
WHERE
  l2_.active = 1
  AND l3_.active = 1
  AND l3_.dossier_id_id = ?
ORDER BY
  p0_.id DESC
LIMIT
  10

SELECT p0_.id AS id_0, p1_.designation AS designation_1, l2_.code AS code_2, p0_.cin AS cin_3, p0_.nom AS nom_4, l2_.id AS id_5, p0_.prenom AS prenom_6 FROM pemploye p0_ INNER JOIN lcontract l2_ ON p0_.id = l2_.employe_id INNER JOIN ldossier_contract l3_ ON l2_.id = l3_.contract_id_id INNER JOIN pnature_contract p1_ ON l2_.pnature_contract_id = p1_.id WHERE l2_.active = 1 AND l3_.active = 1 AND l3_.dossier_id_id = 90 ORDER BY p0_.id DESC LIMIT 10;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  pemploye p0_
  INNER JOIN lcontract l1_ ON p0_.id = l1_.employe_id
  INNER JOIN ldossier_contract l2_ ON l1_.id = l2_.contract_id_id
  INNER JOIN pnature_contract p3_ ON l1_.pnature_contract_id = p3_.id
WHERE
  l1_.active = 1
  AND l2_.active = 1
  AND l2_.dossier_id_id = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM pemploye p0_ INNER JOIN lcontract l1_ ON p0_.id = l1_.employe_id INNER JOIN ldossier_contract l2_ ON l1_.id = l2_.contract_id_id INNER JOIN pnature_contract p3_ ON l1_.pnature_contract_id = p3_.id WHERE l1_.active = 1 AND l2_.active = 1 AND l2_.dossier_id_id = 90;

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