Symfony Profiler

SELECT
  t0_.code AS code_0,
  t0_.id AS id_1,
  p1_.code AS code_2,
  p2_.abreviation AS abreviation_3,
  l3_.id AS id_4,
  l3_.code AS code_5,
  p4_.nom AS nom_6,
  l3_.id AS id_7,
  p4_.prenom AS prenom_8
FROM
  lcontract l3_
  INNER JOIN pemploye p4_ ON l3_.employe_id = p4_.id
  INNER JOIN tbulletin t0_ ON l3_.id = t0_.contract_id
  INNER JOIN ppiece p5_ ON t0_.piece_id = p5_.id
  INNER JOIN pdossier p2_ ON l3_.dossier_id = p2_.id
  INNER JOIN periode p1_ ON t0_.periode_id = p1_.id
WHERE
  p5_.id = 13
  AND t0_.active = 1
  AND (
    (
      p2_.abreviation LIKE ?
      OR p1_.code LIKE ?
      OR l3_.code LIKE ?
      OR t0_.code LIKE ?
      OR p4_.matricule LIKE ?
      OR p4_.nom LIKE ?
      OR p4_.prenom LIKE ?
    )
  )
ORDER BY
  t0_.id DESC
LIMIT
  10

SELECT t0_.code AS code_0, t0_.id AS id_1, p1_.code AS code_2, p2_.abreviation AS abreviation_3, l3_.id AS id_4, l3_.code AS code_5, p4_.nom AS nom_6, l3_.id AS id_7, p4_.prenom AS prenom_8 FROM lcontract l3_ INNER JOIN pemploye p4_ ON l3_.employe_id = p4_.id INNER JOIN tbulletin t0_ ON l3_.id = t0_.contract_id INNER JOIN ppiece p5_ ON t0_.piece_id = p5_.id INNER JOIN pdossier p2_ ON l3_.dossier_id = p2_.id INNER JOIN periode p1_ ON t0_.periode_id = p1_.id WHERE p5_.id = 13 AND t0_.active = 1 AND ((p2_.abreviation LIKE '%EL ALA%' OR p1_.code LIKE '%EL ALA%' OR l3_.code LIKE '%EL ALA%' OR t0_.code LIKE '%EL ALA%' OR p4_.matricule LIKE '%EL ALA%' OR p4_.nom LIKE '%EL ALA%' OR p4_.prenom LIKE '%EL ALA%')) ORDER BY t0_.id DESC LIMIT 10;

SELECT
  t0_.code AS code_0,
  t0_.id AS id_1,
  p1_.code AS code_2,
  p2_.abreviation AS abreviation_3,
  l3_.id AS id_4,
  l3_.code AS code_5,
  p4_.nom AS nom_6,
  l3_.id AS id_7,
  p4_.prenom AS prenom_8
FROM
  lcontract l3_
  INNER JOIN pemploye p4_ ON l3_.employe_id = p4_.id
  INNER JOIN tbulletin t0_ ON l3_.id = t0_.contract_id
  INNER JOIN ppiece p5_ ON t0_.piece_id = p5_.id
  INNER JOIN pdossier p2_ ON l3_.dossier_id = p2_.id
  INNER JOIN periode p1_ ON t0_.periode_id = p1_.id
WHERE
  p5_.id = 13
  AND t0_.active = 1
  AND (
    (
      p2_.abreviation LIKE ?
      OR p1_.code LIKE ?
      OR l3_.code LIKE ?
      OR t0_.code LIKE ?
      OR p4_.matricule LIKE ?
      OR p4_.nom LIKE ?
      OR p4_.prenom LIKE ?
    )
  )

SELECT t0_.code AS code_0, t0_.id AS id_1, p1_.code AS code_2, p2_.abreviation AS abreviation_3, l3_.id AS id_4, l3_.code AS code_5, p4_.nom AS nom_6, l3_.id AS id_7, p4_.prenom AS prenom_8 FROM lcontract l3_ INNER JOIN pemploye p4_ ON l3_.employe_id = p4_.id INNER JOIN tbulletin t0_ ON l3_.id = t0_.contract_id INNER JOIN ppiece p5_ ON t0_.piece_id = p5_.id INNER JOIN pdossier p2_ ON l3_.dossier_id = p2_.id INNER JOIN periode p1_ ON t0_.periode_id = p1_.id WHERE p5_.id = 13 AND t0_.active = 1 AND ((p2_.abreviation LIKE '%EL ALA%' OR p1_.code LIKE '%EL ALA%' OR l3_.code LIKE '%EL ALA%' OR t0_.code LIKE '%EL ALA%' OR p4_.matricule LIKE '%EL ALA%' OR p4_.nom LIKE '%EL ALA%' OR p4_.prenom LIKE '%EL ALA%'));

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  lcontract l0_
  INNER JOIN tbulletin t1_ ON l0_.id = t1_.contract_id
  INNER JOIN ppiece p2_ ON t1_.piece_id = p2_.id
WHERE
  l0_.active = 1
  AND p2_.id = 13

SELECT COUNT(l0_.id) AS sclr_0 FROM lcontract l0_ INNER JOIN tbulletin t1_ ON l0_.id = t1_.contract_id INNER JOIN ppiece p2_ ON t1_.piece_id = p2_.id WHERE l0_.active = 1 AND p2_.id = 13;

SELECT
  t0_.montant AS montant_0
FROM
  tbulletin t1_
  INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id
  INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id
WHERE
  (
    p2_.id = 5
    OR p2_.id = 68
  )
  AND t1_.id = ?
  AND t0_.active = 1

SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = 84800 AND t0_.active = 1;

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;