Symfony Profiler

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

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.abreviation AS abreviation_3,
  t0.date AS date_4,
  t0.is_valider AS is_valider_5,
  t0.is_integrer AS is_integrer_6
FROM
  periode t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.code = '102024' LIMIT 1;

SELECT
  t0_.code AS code_0,
  t0_.id AS id_1,
  l1_.id AS id_2,
  l1_.code AS code_3,
  p2_.nom AS nom_4,
  p2_.matricule AS matricule_5,
  p2_.prenom AS prenom_6
FROM
  lcontract l1_
  INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id
  INNER JOIN tbulletin t0_ ON l1_.id = t0_.contract_id
  INNER JOIN ppiece p3_ ON t0_.piece_id = p3_.id
WHERE
  t0_.dossier_id = ?
  AND t0_.dossier_id = ?
  AND t0_.periode_id = ?
  AND p3_.id = 1
  AND t0_.active = 1

SELECT t0_.code AS code_0, t0_.id AS id_1, l1_.id AS id_2, l1_.code AS code_3, p2_.nom AS nom_4, p2_.matricule AS matricule_5, p2_.prenom AS prenom_6 FROM lcontract l1_ INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id INNER JOIN tbulletin t0_ ON l1_.id = t0_.contract_id INNER JOIN ppiece p3_ ON t0_.piece_id = p3_.id WHERE t0_.dossier_id = 20 AND t0_.dossier_id = 20 AND t0_.periode_id = 27 AND p3_.id = 1 AND t0_.active = 1;

SELECT
  t0_.code AS code_0,
  t0_.id AS id_1,
  l1_.id AS id_2,
  l1_.code AS code_3,
  p2_.nom AS nom_4,
  p2_.matricule AS matricule_5,
  p2_.prenom AS prenom_6
FROM
  lcontract l1_
  INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id
  INNER JOIN tbulletin t0_ ON l1_.id = t0_.contract_id
  INNER JOIN ppiece p3_ ON t0_.piece_id = p3_.id
WHERE
  t0_.dossier_id = ?
  AND t0_.dossier_id = ?
  AND t0_.periode_id = ?
  AND p3_.id = 1
  AND t0_.active = 1
LIMIT
  10

SELECT t0_.code AS code_0, t0_.id AS id_1, l1_.id AS id_2, l1_.code AS code_3, p2_.nom AS nom_4, p2_.matricule AS matricule_5, p2_.prenom AS prenom_6 FROM lcontract l1_ INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id INNER JOIN tbulletin t0_ ON l1_.id = t0_.contract_id INNER JOIN ppiece p3_ ON t0_.piece_id = p3_.id WHERE t0_.dossier_id = 20 AND t0_.dossier_id = 20 AND t0_.periode_id = 27 AND p3_.id = 1 AND t0_.active = 1 LIMIT 10;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 164 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 164 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74596 AND t0_.active = 1;

SELECT
  p0_.id AS id_0,
  p0_.resoudre AS resoudre_1,
  p0_.motif AS motif_2,
  p0_.periode_id AS periode_id_3,
  p0_.contract_id AS contract_id_4,
  p0_.element_echeance_id AS element_echeance_id_5,
  p0_.element_fixe_id AS element_fixe_id_6,
  p0_.prelevement_lg_id AS prelevement_lg_id_7
FROM
  probleme p0_
  INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id
WHERE
  p0_.periode_id = ?
  AND l1_.id = ?
  AND p0_.resoudre = 0

SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = 27 AND l1_.id = 164 AND p0_.resoudre = 0;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 190 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 190 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74597 AND t0_.active = 1;

SELECT
  p0_.id AS id_0,
  p0_.resoudre AS resoudre_1,
  p0_.motif AS motif_2,
  p0_.periode_id AS periode_id_3,
  p0_.contract_id AS contract_id_4,
  p0_.element_echeance_id AS element_echeance_id_5,
  p0_.element_fixe_id AS element_fixe_id_6,
  p0_.prelevement_lg_id AS prelevement_lg_id_7
FROM
  probleme p0_
  INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id
WHERE
  p0_.periode_id = ?
  AND l1_.id = ?
  AND p0_.resoudre = 0

SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = 27 AND l1_.id = 190 AND p0_.resoudre = 0;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 558 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 558 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74598 AND t0_.active = 1;

SELECT
  p0_.id AS id_0,
  p0_.resoudre AS resoudre_1,
  p0_.motif AS motif_2,
  p0_.periode_id AS periode_id_3,
  p0_.contract_id AS contract_id_4,
  p0_.element_echeance_id AS element_echeance_id_5,
  p0_.element_fixe_id AS element_fixe_id_6,
  p0_.prelevement_lg_id AS prelevement_lg_id_7
FROM
  probleme p0_
  INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id
WHERE
  p0_.periode_id = ?
  AND l1_.id = ?
  AND p0_.resoudre = 0

SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = 27 AND l1_.id = 558 AND p0_.resoudre = 0;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 976 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 976 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74599 AND t0_.active = 1;

SELECT
  p0_.id AS id_0,
  p0_.resoudre AS resoudre_1,
  p0_.motif AS motif_2,
  p0_.periode_id AS periode_id_3,
  p0_.contract_id AS contract_id_4,
  p0_.element_echeance_id AS element_echeance_id_5,
  p0_.element_fixe_id AS element_fixe_id_6,
  p0_.prelevement_lg_id AS prelevement_lg_id_7
FROM
  probleme p0_
  INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id
WHERE
  p0_.periode_id = ?
  AND l1_.id = ?
  AND p0_.resoudre = 0

SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = 27 AND l1_.id = 976 AND p0_.resoudre = 0;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 1783 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 1783 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74600 AND t0_.active = 1;

SELECT
  p0_.id AS id_0,
  p0_.resoudre AS resoudre_1,
  p0_.motif AS motif_2,
  p0_.periode_id AS periode_id_3,
  p0_.contract_id AS contract_id_4,
  p0_.element_echeance_id AS element_echeance_id_5,
  p0_.element_fixe_id AS element_fixe_id_6,
  p0_.prelevement_lg_id AS prelevement_lg_id_7
FROM
  probleme p0_
  INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id
WHERE
  p0_.periode_id = ?
  AND l1_.id = ?
  AND p0_.resoudre = 0

SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = 27 AND l1_.id = 1783 AND p0_.resoudre = 0;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 1798 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 1798 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74601 AND t0_.active = 1;

SELECT
  p0_.id AS id_0,
  p0_.resoudre AS resoudre_1,
  p0_.motif AS motif_2,
  p0_.periode_id AS periode_id_3,
  p0_.contract_id AS contract_id_4,
  p0_.element_echeance_id AS element_echeance_id_5,
  p0_.element_fixe_id AS element_fixe_id_6,
  p0_.prelevement_lg_id AS prelevement_lg_id_7
FROM
  probleme p0_
  INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id
WHERE
  p0_.periode_id = ?
  AND l1_.id = ?
  AND p0_.resoudre = 0

SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = 27 AND l1_.id = 1798 AND p0_.resoudre = 0;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(l2_.nombre_jours) AS sclr_2
FROM
  lelement_echeance l2_
  INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id
  INNER JOIN periode p1_ ON l2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND l2_.periode_id = ?
  AND l2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = 1810 AND l2_.periode_id = 27 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;

SELECT
  l0_.id AS id_0,
  p1_.id AS id_1,
  sum(p2_.nombre_jour) AS sclr_2
FROM
  parret_travail_lg p2_
  INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id
  INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id
  INNER JOIN periode p1_ ON p2_.periode_id = p1_.id
WHERE
  l0_.id = ?
  AND p2_.periode_id = ?
  AND p3_.active = 1
  AND p2_.active = 1
GROUP BY
  l0_.id,
  p1_.id

SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = 1810 AND p2_.periode_id = 27 AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id;

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 = 74602 AND t0_.active = 1;