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

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.active AS active_3
FROM
  pdevise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.active AS active_3 FROM pdevise t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.abreviation AS abreviation_3,
  t0.active AS active_4
FROM
  ppaiement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3, t0.active AS active_4 FROM ppaiement 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 = '032025' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.facture AS facture_4,
  t0.paiement AS paiement_5,
  t0.fournisseur AS fournisseur_6,
  t0.id_article AS id_article_7,
  t0.honoraire AS honoraire_8,
  t0.indeminite AS indeminite_9,
  t0.prets AS prets_10,
  t0.sens AS sens_11,
  t0.absence AS absence_12,
  t0.fixe AS fixe_13,
  t0.journal AS journal_14,
  t0.flag_input AS flag_input_15,
  t0.site_id AS site_id_16,
  t0.partenaire_id AS partenaire_id_17,
  t0.regul_article_ugouv_id AS regul_article_ugouv_id_18,
  t0.imposable AS imposable_19,
  t0.active AS active_20,
  t0.echeance AS echeance_21,
  t0.famille AS famille_22,
  t0.type AS type_23,
  t0.ord AS ord_24,
  t0.rubthm0 AS rubthm0_25,
  t0.old_designation AS old_designation_26
FROM
  prubrique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id = 5;

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

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

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.active AS active_4,
  t0.abreviation AS abreviation_5,
  t0.partenaire_id AS partenaire_id_6,
  t0.taux_ir AS taux_ir_7,
  t0.abattement AS abattement_8,
  t0.type_id AS type_id_9
FROM
  pnature_contract t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.active AS active_4, t0.abreviation AS abreviation_5, t0.partenaire_id AS partenaire_id_6, t0.taux_ir AS taux_ir_7, t0.abattement AS abattement_8, t0.type_id AS type_id_9 FROM pnature_contract t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.icon AS icon_3,
  t0.type AS type_4
FROM
  pstatut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.icon AS icon_3, t0.type AS type_4 FROM pstatut 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.employe_id AS employe_id_26,
  t0.pnature_contract_id AS pnature_contract_id_27,
  t0.dossier_id AS dossier_id_28,
  t0.bareme_id AS bareme_id_29,
  t0.fonction_id AS fonction_id_30,
  t0.piece_id AS piece_id_31,
  t0.user_desactiver_id AS user_desactiver_id_32,
  t0.duree_contract_id AS duree_contract_id_33,
  t0.user_updated_id AS user_updated_id_34,
  t0.user_created_id AS user_created_id_35
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.employe_id AS employe_id_26, t0.pnature_contract_id AS pnature_contract_id_27, t0.dossier_id AS dossier_id_28, t0.bareme_id AS bareme_id_29, t0.fonction_id AS fonction_id_30, t0.piece_id AS piece_id_31, t0.user_desactiver_id AS user_desactiver_id_32, t0.duree_contract_id AS duree_contract_id_33, t0.user_updated_id AS user_updated_id_34, t0.user_created_id AS user_created_id_35 FROM lcontract t0 WHERE t0.id = 2122;

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

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.facture AS facture_4,
  t0.paiement AS paiement_5,
  t0.fournisseur AS fournisseur_6,
  t0.id_article AS id_article_7,
  t0.honoraire AS honoraire_8,
  t0.indeminite AS indeminite_9,
  t0.prets AS prets_10,
  t0.sens AS sens_11,
  t0.absence AS absence_12,
  t0.fixe AS fixe_13,
  t0.journal AS journal_14,
  t0.flag_input AS flag_input_15,
  t0.site_id AS site_id_16,
  t0.partenaire_id AS partenaire_id_17,
  t0.regul_article_ugouv_id AS regul_article_ugouv_id_18,
  t0.imposable AS imposable_19,
  t0.active AS active_20,
  t0.echeance AS echeance_21,
  t0.famille AS famille_22,
  t0.type AS type_23,
  t0.ord AS ord_24,
  t0.rubthm0 AS rubthm0_25,
  t0.old_designation AS old_designation_26
FROM
  prubrique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id = 64;

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

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO pbordereau (
  created, type, code, nature, observation,
  active, date_integration, unique_id,
  motif_annulation, periode_id, user_created_id,
  dossier_id, paiement_id, piece_id,
  nature_contract_id, statut_id, devise_id,
  user_integration_id, user_annulation_id,
  rubrique_indiminite_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO pbordereau (created, type, code, nature, observation, active, date_integration, unique_id, motif_annulation, periode_id, user_created_id, dossier_id, paiement_id, piece_id, nature_contract_id, statut_id, devise_id, user_integration_id, user_annulation_id, rubrique_indiminite_id) VALUES ('2025-03-19 09:17:28', 'stc', NULL, NULL, 'SOLD DE TOUT COMPTE', 1, NULL, NULL, NULL, 46, 3, 63, 1, 14, 1, 1, 1, NULL, NULL, NULL);

INSERT INTO tbulletin (
  annee, code, observation, active, motif_annulation,
  taux_cotis_cimr, categorie_cimr,
  periode_id, contract_id, dossier_id,
  devise_id, paiement_id, bordereau_id,
  piece_id, user_annulation_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO tbulletin (annee, code, observation, active, motif_annulation, taux_cotis_cimr, categorie_cimr, periode_id, contract_id, dossier_id, devise_id, paiement_id, bordereau_id, piece_id, user_annulation_id) VALUES (NULL, NULL, 'SOLD DE TOUT COMPTE', 1, NULL, NULL, NULL, 46, 2122, 63, 1, 1, 7317, 13, NULL);

INSERT INTO tbulletin_lg (
  montant, sens, active, montant_devise,
  bulletin_id, rubrique_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO tbulletin_lg (montant, sens, active, montant_devise, bulletin_id, rubrique_id) VALUES (876.24, 1, 1, NULL, 108093, 5);

INSERT INTO tbulletin_lg (
  montant, sens, active, montant_devise,
  bulletin_id, rubrique_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO tbulletin_lg (montant, sens, active, montant_devise, bulletin_id, rubrique_id) VALUES (876.24, 1, 1, NULL, 108093, 64);

UPDATE
  pemploye
SET
  stc = ?
WHERE
  id = ?

UPDATE pemploye SET stc = 1 WHERE id = 1137;

"COMMIT"

"COMMIT";

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

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.employe_id AS employe_id_26,
  t0.pnature_contract_id AS pnature_contract_id_27,
  t0.dossier_id AS dossier_id_28,
  t0.bareme_id AS bareme_id_29,
  t0.fonction_id AS fonction_id_30,
  t0.piece_id AS piece_id_31,
  t0.user_desactiver_id AS user_desactiver_id_32,
  t0.duree_contract_id AS duree_contract_id_33,
  t0.user_updated_id AS user_updated_id_34,
  t0.user_created_id AS user_created_id_35
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.employe_id AS employe_id_26, t0.pnature_contract_id AS pnature_contract_id_27, t0.dossier_id AS dossier_id_28, t0.bareme_id AS bareme_id_29, t0.fonction_id AS fonction_id_30, t0.piece_id AS piece_id_31, t0.user_desactiver_id AS user_desactiver_id_32, t0.duree_contract_id AS duree_contract_id_33, t0.user_updated_id AS user_updated_id_34, t0.user_created_id AS user_created_id_35 FROM lcontract t0 WHERE t0.id = 492;

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