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

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 = '072025' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.code AS code_3,
  t0.observation AS observation_4,
  t0.active AS active_5,
  t0.motif_annulation AS motif_annulation_6,
  t0.taux_cotis_cimr AS taux_cotis_cimr_7,
  t0.categorie_cimr AS categorie_cimr_8,
  t0.rib AS rib_9,
  t0.periode_id AS periode_id_10,
  t0.contract_id AS contract_id_11,
  t0.dossier_id AS dossier_id_12,
  t0.devise_id AS devise_id_13,
  t0.paiement_id AS paiement_id_14,
  t0.bordereau_id AS bordereau_id_15,
  t0.piece_id AS piece_id_16,
  t0.user_annulation_id AS user_annulation_id_17
FROM
  tbulletin t0
WHERE
  t0.active = ?
  AND t0.periode_id = ?
  AND t0.dossier_id = ?

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.rib AS rib_9, t0.periode_id AS periode_id_10, t0.contract_id AS contract_id_11, t0.dossier_id AS dossier_id_12, t0.devise_id AS devise_id_13, t0.paiement_id AS paiement_id_14, t0.bordereau_id AS bordereau_id_15, t0.piece_id AS piece_id_16, t0.user_annulation_id AS user_annulation_id_17 FROM tbulletin t0 WHERE t0.active = 1 AND t0.periode_id = 50 AND t0.dossier_id = 42;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.active AS active_5,
  t0.date_sortie AS date_sortie_6,
  t0.motif_sortie AS motif_sortie_7,
  t0.date_anciennete AS date_anciennete_8,
  t0.prise_en_charge AS prise_en_charge_9,
  t0.salairegrille AS salairegrille_10,
  t0.salaireaffecte AS salaireaffecte_11,
  t0.ppc AS ppc_12,
  t0.rpc AS rpc_13,
  t0.matricule_ancien AS matricule_ancien_14,
  t0.date_desactiver AS date_desactiver_15,
  t0.cnss AS cnss_16,
  t0.date_cnss AS date_cnss_17,
  t0.cimr AS cimr_18,
  t0.date_cimr AS date_cimr_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22,
  t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23,
  t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24,
  t0.stagiaire AS stagiaire_25,
  t0.duree_essai AS duree_essai_26,
  t0.employe_id AS employe_id_27,
  t0.pnature_contract_id AS pnature_contract_id_28,
  t0.dossier_id AS dossier_id_29,
  t0.bareme_id AS bareme_id_30,
  t0.fonction_id AS fonction_id_31,
  t0.piece_id AS piece_id_32,
  t0.user_desactiver_id AS user_desactiver_id_33,
  t0.duree_contract_id AS duree_contract_id_34,
  t0.user_updated_id AS user_updated_id_35,
  t0.user_created_id AS user_created_id_36
FROM
  lcontract t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.active AS active_5, t0.date_sortie AS date_sortie_6, t0.motif_sortie AS motif_sortie_7, t0.date_anciennete AS date_anciennete_8, t0.prise_en_charge AS prise_en_charge_9, t0.salairegrille AS salairegrille_10, t0.salaireaffecte AS salaireaffecte_11, t0.ppc AS ppc_12, t0.rpc AS rpc_13, t0.matricule_ancien AS matricule_ancien_14, t0.date_desactiver AS date_desactiver_15, t0.cnss AS cnss_16, t0.date_cnss AS date_cnss_17, t0.cimr AS cimr_18, t0.date_cimr AS date_cimr_19, t0.created AS created_20, t0.updated AS updated_21, t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22, t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23, t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24, t0.stagiaire AS stagiaire_25, t0.duree_essai AS duree_essai_26, t0.employe_id AS employe_id_27, t0.pnature_contract_id AS pnature_contract_id_28, t0.dossier_id AS dossier_id_29, t0.bareme_id AS bareme_id_30, t0.fonction_id AS fonction_id_31, t0.piece_id AS piece_id_32, t0.user_desactiver_id AS user_desactiver_id_33, t0.duree_contract_id AS duree_contract_id_34, t0.user_updated_id AS user_updated_id_35, t0.user_created_id AS user_created_id_36 FROM lcontract t0 WHERE t0.id = 1192;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.abreviation AS abreviation_3,
  t0.code AS code_4,
  t0.groupement AS groupement_5,
  t0.dossier_ugouv_id AS dossier_ugouv_id_6,
  t0.abreviation2 AS abreviation2_7,
  t0.abreviation_ugouv AS abreviation_ugouv_8,
  t0.fcy0 AS fcy0_9,
  t0.cpy0 AS cpy0_10,
  t0.partenaire_id AS partenaire_id_11,
  t0.affiliation AS affiliation_12,
  t0.statut_cimr AS statut_cimr_13,
  t0.image AS image_14,
  t0.adresse AS adresse_15,
  t0.ice AS ice_16,
  t0.num_if AS num_if_17,
  t0.fax AS fax_18,
  t0.telephone AS telephone_19,
  t0.active AS active_20,
  t0.das AS das_21,
  t0.fcy_id AS fcy_id_22
FROM
  pdossier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3, t0.code AS code_4, t0.groupement AS groupement_5, t0.dossier_ugouv_id AS dossier_ugouv_id_6, t0.abreviation2 AS abreviation2_7, t0.abreviation_ugouv AS abreviation_ugouv_8, t0.fcy0 AS fcy0_9, t0.cpy0 AS cpy0_10, t0.partenaire_id AS partenaire_id_11, t0.affiliation AS affiliation_12, t0.statut_cimr AS statut_cimr_13, t0.image AS image_14, t0.adresse AS adresse_15, t0.ice AS ice_16, t0.num_if AS num_if_17, t0.fax AS fax_18, t0.telephone AS telephone_19, t0.active AS active_20, t0.das AS das_21, t0.fcy_id AS fcy_id_22 FROM pdossier t0 WHERE t0.id = 42;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.matricule AS matricule_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.lieu_naissance AS lieu_naissance_7,
  t0.sexe AS sexe_8,
  t0.nombre_enfants AS nombre_enfants_9,
  t0.nbr_pris_en_charge AS nbr_pris_en_charge_10,
  t0.cin AS cin_11,
  t0.adresse1 AS adresse1_12,
  t0.adresse2 AS adresse2_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.pays AS pays_16,
  t0.nationalite AS nationalite_17,
  t0.tel1 AS tel1_18,
  t0.tel2 AS tel2_19,
  t0.email AS email_20,
  t0.active AS active_21,
  t0.created AS created_22,
  t0.contacturgent AS contacturgent_23,
  t0.prenomurgence AS prenomurgence_24,
  t0.nomurgence AS nomurgence_25,
  t0.degredeparente AS degredeparente_26,
  t0.adresseurgence AS adresseurgence_27,
  t0.teleurgence AS teleurgence_28,
  t0.villeurgence AS villeurgence_29,
  t0.prenomconjoint AS prenomconjoint_30,
  t0.nomconjoint AS nomconjoint_31,
  t0.datenaiconjoint AS datenaiconjoint_32,
  t0.nomprenompere AS nomprenompere_33,
  t0.nomprenommere AS nomprenommere_34,
  t0.stc AS stc_35,
  t0.updated AS updated_36,
  t0.roles AS roles_37,
  t0.password AS password_38,
  t0.nombre_jour_conge AS nombre_jour_conge_39,
  t0.is_first_login AS is_first_login_40,
  t0.situation_familiale_id_id AS situation_familiale_id_id_41,
  t0.user_updated_id AS user_updated_id_42,
  t43.id AS id_44,
  t43.cin AS cin_45,
  t43.cin_path AS cin_path_46,
  t43.acte_naissance AS acte_naissance_47,
  t43.acte_naissance_path AS acte_naissance_path_48,
  t43.formulaire AS formulaire_49,
  t43.formulaire_path AS formulaire_path_50,
  t43.contrat AS contrat_51,
  t43.contrat_path AS contrat_path_52,
  t43.dossier_medical AS dossier_medical_53,
  t43.dossier_medical_path AS dossier_medical_path_54,
  t43.bac AS bac_55,
  t43.bac_path AS bac_path_56,
  t43.diplome AS diplome_57,
  t43.diplome_path AS diplome_path_58,
  t43.cv AS cv_59,
  t43.cv_path AS cv_path_60,
  t43.rib AS rib_61,
  t43.rib_path AS rib_path_62,
  t43.fiche_anthropometrique AS fiche_anthropometrique_63,
  t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64,
  t43.photo AS photo_65,
  t43.photo_path AS photo_path_66,
  t43.emprunte AS emprunte_67,
  t43.emprunte_path AS emprunte_path_68,
  t43.acte_mariage AS acte_mariage_69,
  t43.acte_mariage_path AS acte_mariage_path_70,
  t43.cin_conjoint AS cin_conjoint_71,
  t43.cin_conjoint_path AS cin_conjoint_path_72,
  t43.acte_naissance_enfants AS acte_naissance_enfants_73,
  t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74,
  t43.cin_enfants AS cin_enfants_75,
  t43.cin_enfants_path AS cin_enfants_path_76,
  t43.cin_parents AS cin_parents_77,
  t43.cin_parents_path AS cin_parents_path_78,
  t43.employe_id AS employe_id_79
FROM
  pemploye t0
  LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.matricule AS matricule_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.sexe AS sexe_8, t0.nombre_enfants AS nombre_enfants_9, t0.nbr_pris_en_charge AS nbr_pris_en_charge_10, t0.cin AS cin_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.nationalite AS nationalite_17, t0.tel1 AS tel1_18, t0.tel2 AS tel2_19, t0.email AS email_20, t0.active AS active_21, t0.created AS created_22, t0.contacturgent AS contacturgent_23, t0.prenomurgence AS prenomurgence_24, t0.nomurgence AS nomurgence_25, t0.degredeparente AS degredeparente_26, t0.adresseurgence AS adresseurgence_27, t0.teleurgence AS teleurgence_28, t0.villeurgence AS villeurgence_29, t0.prenomconjoint AS prenomconjoint_30, t0.nomconjoint AS nomconjoint_31, t0.datenaiconjoint AS datenaiconjoint_32, t0.nomprenompere AS nomprenompere_33, t0.nomprenommere AS nomprenommere_34, t0.stc AS stc_35, t0.updated AS updated_36, t0.roles AS roles_37, t0.password AS password_38, t0.nombre_jour_conge AS nombre_jour_conge_39, t0.is_first_login AS is_first_login_40, t0.situation_familiale_id_id AS situation_familiale_id_id_41, t0.user_updated_id AS user_updated_id_42, t43.id AS id_44, t43.cin AS cin_45, t43.cin_path AS cin_path_46, t43.acte_naissance AS acte_naissance_47, t43.acte_naissance_path AS acte_naissance_path_48, t43.formulaire AS formulaire_49, t43.formulaire_path AS formulaire_path_50, t43.contrat AS contrat_51, t43.contrat_path AS contrat_path_52, t43.dossier_medical AS dossier_medical_53, t43.dossier_medical_path AS dossier_medical_path_54, t43.bac AS bac_55, t43.bac_path AS bac_path_56, t43.diplome AS diplome_57, t43.diplome_path AS diplome_path_58, t43.cv AS cv_59, t43.cv_path AS cv_path_60, t43.rib AS rib_61, t43.rib_path AS rib_path_62, t43.fiche_anthropometrique AS fiche_anthropometrique_63, t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64, t43.photo AS photo_65, t43.photo_path AS photo_path_66, t43.emprunte AS emprunte_67, t43.emprunte_path AS emprunte_path_68, t43.acte_mariage AS acte_mariage_69, t43.acte_mariage_path AS acte_mariage_path_70, t43.cin_conjoint AS cin_conjoint_71, t43.cin_conjoint_path AS cin_conjoint_path_72, t43.acte_naissance_enfants AS acte_naissance_enfants_73, t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74, t43.cin_enfants AS cin_enfants_75, t43.cin_enfants_path AS cin_enfants_path_76, t43.cin_parents AS cin_parents_77, t43.cin_parents_path AS cin_parents_path_78, t43.employe_id AS employe_id_79 FROM pemploye t0 LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id WHERE t0.id = 322;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.created AS created_5,
  t0.code AS code_6,
  t0.active AS active_7,
  t0.swift AS swift_8,
  t0.banque AS banque_9,
  t0.contact_id_id AS contact_id_id_10
FROM
  lrib t0
WHERE
  t0.contact_id_id = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.created AS created_5, t0.code AS code_6, t0.active AS active_7, t0.swift AS swift_8, t0.banque AS banque_9, t0.contact_id_id AS contact_id_id_10 FROM lrib t0 WHERE t0.contact_id_id = 1192 AND t0.active = 1 LIMIT 1;

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 = 1192 AND l2_.periode_id = 50 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 = 1192 AND p2_.periode_id = 50 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 = 129618 AND t0_.active = 1;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.abreviation AS abreviation_3
FROM
  ppiece t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3 FROM ppiece t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.niveau_id AS niveau_id_2,
  t0.bareme AS bareme_3,
  t0.designation AS designation_4,
  t0.netapayer AS netapayer_5,
  t0.profil AS profil_6,
  t0.poste AS poste_7,
  t0.experience AS experience_8,
  t0.groupe AS groupe_9,
  t0.salaire_brute AS salaire_brute_10,
  t0.anc_profil1 AS anc_profil1_11,
  t0.anc_profil2 AS anc_profil2_12,
  t0.reference AS reference_13,
  t0.classe AS classe_14,
  t0.code_ref AS code_ref_15,
  t0.st_nst AS st_nst_16,
  t0.cmpt AS cmpt_17,
  t0.conditions_de_passage AS conditions_de_passage_18,
  t0.nature AS nature_19,
  t0.grade AS grade_20,
  t0.active AS active_21,
  t0.nature_sal_id_id AS nature_sal_id_id_22,
  t0.bareme_type_id AS bareme_type_id_23
FROM
  pbareme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.niveau_id AS niveau_id_2, t0.bareme AS bareme_3, t0.designation AS designation_4, t0.netapayer AS netapayer_5, t0.profil AS profil_6, t0.poste AS poste_7, t0.experience AS experience_8, t0.groupe AS groupe_9, t0.salaire_brute AS salaire_brute_10, t0.anc_profil1 AS anc_profil1_11, t0.anc_profil2 AS anc_profil2_12, t0.reference AS reference_13, t0.classe AS classe_14, t0.code_ref AS code_ref_15, t0.st_nst AS st_nst_16, t0.cmpt AS cmpt_17, t0.conditions_de_passage AS conditions_de_passage_18, t0.nature AS nature_19, t0.grade AS grade_20, t0.active AS active_21, t0.nature_sal_id_id AS nature_sal_id_id_22, t0.bareme_type_id AS bareme_type_id_23 FROM pbareme t0 WHERE t0.id = 144;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2
FROM
  pbareme_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM pbareme_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.active AS active_5,
  t0.date_sortie AS date_sortie_6,
  t0.motif_sortie AS motif_sortie_7,
  t0.date_anciennete AS date_anciennete_8,
  t0.prise_en_charge AS prise_en_charge_9,
  t0.salairegrille AS salairegrille_10,
  t0.salaireaffecte AS salaireaffecte_11,
  t0.ppc AS ppc_12,
  t0.rpc AS rpc_13,
  t0.matricule_ancien AS matricule_ancien_14,
  t0.date_desactiver AS date_desactiver_15,
  t0.cnss AS cnss_16,
  t0.date_cnss AS date_cnss_17,
  t0.cimr AS cimr_18,
  t0.date_cimr AS date_cimr_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22,
  t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23,
  t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24,
  t0.stagiaire AS stagiaire_25,
  t0.duree_essai AS duree_essai_26,
  t0.employe_id AS employe_id_27,
  t0.pnature_contract_id AS pnature_contract_id_28,
  t0.dossier_id AS dossier_id_29,
  t0.bareme_id AS bareme_id_30,
  t0.fonction_id AS fonction_id_31,
  t0.piece_id AS piece_id_32,
  t0.user_desactiver_id AS user_desactiver_id_33,
  t0.duree_contract_id AS duree_contract_id_34,
  t0.user_updated_id AS user_updated_id_35,
  t0.user_created_id AS user_created_id_36
FROM
  lcontract t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.active AS active_5, t0.date_sortie AS date_sortie_6, t0.motif_sortie AS motif_sortie_7, t0.date_anciennete AS date_anciennete_8, t0.prise_en_charge AS prise_en_charge_9, t0.salairegrille AS salairegrille_10, t0.salaireaffecte AS salaireaffecte_11, t0.ppc AS ppc_12, t0.rpc AS rpc_13, t0.matricule_ancien AS matricule_ancien_14, t0.date_desactiver AS date_desactiver_15, t0.cnss AS cnss_16, t0.date_cnss AS date_cnss_17, t0.cimr AS cimr_18, t0.date_cimr AS date_cimr_19, t0.created AS created_20, t0.updated AS updated_21, t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22, t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23, t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24, t0.stagiaire AS stagiaire_25, t0.duree_essai AS duree_essai_26, t0.employe_id AS employe_id_27, t0.pnature_contract_id AS pnature_contract_id_28, t0.dossier_id AS dossier_id_29, t0.bareme_id AS bareme_id_30, t0.fonction_id AS fonction_id_31, t0.piece_id AS piece_id_32, t0.user_desactiver_id AS user_desactiver_id_33, t0.duree_contract_id AS duree_contract_id_34, t0.user_updated_id AS user_updated_id_35, t0.user_created_id AS user_created_id_36 FROM lcontract t0 WHERE t0.id = 1762;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.matricule AS matricule_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.lieu_naissance AS lieu_naissance_7,
  t0.sexe AS sexe_8,
  t0.nombre_enfants AS nombre_enfants_9,
  t0.nbr_pris_en_charge AS nbr_pris_en_charge_10,
  t0.cin AS cin_11,
  t0.adresse1 AS adresse1_12,
  t0.adresse2 AS adresse2_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.pays AS pays_16,
  t0.nationalite AS nationalite_17,
  t0.tel1 AS tel1_18,
  t0.tel2 AS tel2_19,
  t0.email AS email_20,
  t0.active AS active_21,
  t0.created AS created_22,
  t0.contacturgent AS contacturgent_23,
  t0.prenomurgence AS prenomurgence_24,
  t0.nomurgence AS nomurgence_25,
  t0.degredeparente AS degredeparente_26,
  t0.adresseurgence AS adresseurgence_27,
  t0.teleurgence AS teleurgence_28,
  t0.villeurgence AS villeurgence_29,
  t0.prenomconjoint AS prenomconjoint_30,
  t0.nomconjoint AS nomconjoint_31,
  t0.datenaiconjoint AS datenaiconjoint_32,
  t0.nomprenompere AS nomprenompere_33,
  t0.nomprenommere AS nomprenommere_34,
  t0.stc AS stc_35,
  t0.updated AS updated_36,
  t0.roles AS roles_37,
  t0.password AS password_38,
  t0.nombre_jour_conge AS nombre_jour_conge_39,
  t0.is_first_login AS is_first_login_40,
  t0.situation_familiale_id_id AS situation_familiale_id_id_41,
  t0.user_updated_id AS user_updated_id_42,
  t43.id AS id_44,
  t43.cin AS cin_45,
  t43.cin_path AS cin_path_46,
  t43.acte_naissance AS acte_naissance_47,
  t43.acte_naissance_path AS acte_naissance_path_48,
  t43.formulaire AS formulaire_49,
  t43.formulaire_path AS formulaire_path_50,
  t43.contrat AS contrat_51,
  t43.contrat_path AS contrat_path_52,
  t43.dossier_medical AS dossier_medical_53,
  t43.dossier_medical_path AS dossier_medical_path_54,
  t43.bac AS bac_55,
  t43.bac_path AS bac_path_56,
  t43.diplome AS diplome_57,
  t43.diplome_path AS diplome_path_58,
  t43.cv AS cv_59,
  t43.cv_path AS cv_path_60,
  t43.rib AS rib_61,
  t43.rib_path AS rib_path_62,
  t43.fiche_anthropometrique AS fiche_anthropometrique_63,
  t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64,
  t43.photo AS photo_65,
  t43.photo_path AS photo_path_66,
  t43.emprunte AS emprunte_67,
  t43.emprunte_path AS emprunte_path_68,
  t43.acte_mariage AS acte_mariage_69,
  t43.acte_mariage_path AS acte_mariage_path_70,
  t43.cin_conjoint AS cin_conjoint_71,
  t43.cin_conjoint_path AS cin_conjoint_path_72,
  t43.acte_naissance_enfants AS acte_naissance_enfants_73,
  t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74,
  t43.cin_enfants AS cin_enfants_75,
  t43.cin_enfants_path AS cin_enfants_path_76,
  t43.cin_parents AS cin_parents_77,
  t43.cin_parents_path AS cin_parents_path_78,
  t43.employe_id AS employe_id_79
FROM
  pemploye t0
  LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.matricule AS matricule_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.sexe AS sexe_8, t0.nombre_enfants AS nombre_enfants_9, t0.nbr_pris_en_charge AS nbr_pris_en_charge_10, t0.cin AS cin_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.nationalite AS nationalite_17, t0.tel1 AS tel1_18, t0.tel2 AS tel2_19, t0.email AS email_20, t0.active AS active_21, t0.created AS created_22, t0.contacturgent AS contacturgent_23, t0.prenomurgence AS prenomurgence_24, t0.nomurgence AS nomurgence_25, t0.degredeparente AS degredeparente_26, t0.adresseurgence AS adresseurgence_27, t0.teleurgence AS teleurgence_28, t0.villeurgence AS villeurgence_29, t0.prenomconjoint AS prenomconjoint_30, t0.nomconjoint AS nomconjoint_31, t0.datenaiconjoint AS datenaiconjoint_32, t0.nomprenompere AS nomprenompere_33, t0.nomprenommere AS nomprenommere_34, t0.stc AS stc_35, t0.updated AS updated_36, t0.roles AS roles_37, t0.password AS password_38, t0.nombre_jour_conge AS nombre_jour_conge_39, t0.is_first_login AS is_first_login_40, t0.situation_familiale_id_id AS situation_familiale_id_id_41, t0.user_updated_id AS user_updated_id_42, t43.id AS id_44, t43.cin AS cin_45, t43.cin_path AS cin_path_46, t43.acte_naissance AS acte_naissance_47, t43.acte_naissance_path AS acte_naissance_path_48, t43.formulaire AS formulaire_49, t43.formulaire_path AS formulaire_path_50, t43.contrat AS contrat_51, t43.contrat_path AS contrat_path_52, t43.dossier_medical AS dossier_medical_53, t43.dossier_medical_path AS dossier_medical_path_54, t43.bac AS bac_55, t43.bac_path AS bac_path_56, t43.diplome AS diplome_57, t43.diplome_path AS diplome_path_58, t43.cv AS cv_59, t43.cv_path AS cv_path_60, t43.rib AS rib_61, t43.rib_path AS rib_path_62, t43.fiche_anthropometrique AS fiche_anthropometrique_63, t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64, t43.photo AS photo_65, t43.photo_path AS photo_path_66, t43.emprunte AS emprunte_67, t43.emprunte_path AS emprunte_path_68, t43.acte_mariage AS acte_mariage_69, t43.acte_mariage_path AS acte_mariage_path_70, t43.cin_conjoint AS cin_conjoint_71, t43.cin_conjoint_path AS cin_conjoint_path_72, t43.acte_naissance_enfants AS acte_naissance_enfants_73, t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74, t43.cin_enfants AS cin_enfants_75, t43.cin_enfants_path AS cin_enfants_path_76, t43.cin_parents AS cin_parents_77, t43.cin_parents_path AS cin_parents_path_78, t43.employe_id AS employe_id_79 FROM pemploye t0 LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id WHERE t0.id = 1667;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.created AS created_5,
  t0.code AS code_6,
  t0.active AS active_7,
  t0.swift AS swift_8,
  t0.banque AS banque_9,
  t0.contact_id_id AS contact_id_id_10
FROM
  lrib t0
WHERE
  t0.contact_id_id = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.created AS created_5, t0.code AS code_6, t0.active AS active_7, t0.swift AS swift_8, t0.banque AS banque_9, t0.contact_id_id AS contact_id_id_10 FROM lrib t0 WHERE t0.contact_id_id = 1762 AND t0.active = 1 LIMIT 1;

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 = 1762 AND l2_.periode_id = 50 AND l2_.active = 1 GROUP BY l0_.id, p1_.id;