Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.libelle AS libelle_2,
  p0_.isactif AS isactif_3,
  p0_.nationalite AS nationalite_4,
  p0_.code_iso3 AS code_iso3_5
FROM
  pays p0_
WHERE
  p0_.isactif = 1
  AND p0_.id IN (?)
ORDER BY
  p0_.libelle ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2, p0_.isactif AS isactif_3, p0_.nationalite AS nationalite_4, p0_.code_iso3 AS code_iso3_5 FROM pays p0_ WHERE p0_.isactif = 1 AND p0_.id IN ('240') ORDER BY p0_.libelle ASC;

SELECT
  t0.id AS id_1,
  t0.isactif AS isactif_2,
  t0.status_retrait AS status_retrait_3,
  t0.stat_suivie_depot AS stat_suivie_depot_4,
  t0.stat_suivie_quittance AS stat_suivie_quittance_5,
  t0.stat_suivie_saisie AS stat_suivie_saisie_6,
  t0.date_saisie AS date_saisie_7,
  t0.stat_suivie_rccm AS stat_suivie_rccm_8,
  t0.stat_suivie_dni AS stat_suivie_dni_9,
  t0.date_retrait AS date_retrait_10,
  t0.est_retire AS est_retire_11,
  t0.is_handicape AS is_handicape_12,
  t0.denomination_sociale AS denomination_sociale_13,
  t0.nom_commercial AS nom_commercial_14,
  t0.activite_sociale AS activite_sociale_15,
  t0.activite_complementaire AS activite_complementaire_16,
  t0.sigle AS sigle_17,
  t0.enseigne AS enseigne_18,
  t0.adresse_siege AS adresse_siege_19,
  t0.adresse_etablissement AS adresse_etablissement_20,
  t0.boite_postale AS boite_postale_21,
  t0.telephone AS telephone_22,
  t0.telephone2 AS telephone2_23,
  t0.email AS email_24,
  t0.en_activite AS en_activite_25,
  t0.nombre_action AS nombre_action_26,
  t0.date_debut AS date_debut_27,
  t0.nombre_salarie_prevu AS nombre_salarie_prevu_28,
  t0.valeur_nominale AS valeur_nominale_29,
  t0.capital_social AS capital_social_30,
  t0.apport_numeraire AS apport_numeraire_31,
  t0.apport_nature AS apport_nature_32,
  t0.document_collectes AS document_collectes_33,
  t0.statut AS statut_34,
  t0.statut_validation AS statut_validation_35,
  t0.date_creation AS date_creation_36,
  t0.date_validation AS date_validation_37,
  t0.date_delivrance AS date_delivrance_38,
  t0.numero_dossier AS numero_dossier_39,
  t0.rccm_siege AS rccm_siege_40,
  t0.code_fiscal AS code_fiscal_41,
  t0.ville AS ville_42,
  t0.motif AS motif_43,
  t0.soussigne AS soussigne_44,
  t0.fonction_soussigne AS fonction_soussigne_45,
  t0.telephone_promoteur AS telephone_promoteur_46,
  t0.email_promoteur AS email_promoteur_47,
  t0.statut_validation_chef_greffe AS statut_validation_chef_greffe_48,
  t0.date_validation_chef_greffe AS date_validation_chef_greffe_49,
  t0.duree AS duree_50,
  t0.is_modification AS is_modification_51,
  t0.is_aguipe AS is_aguipe_52,
  t0.is_sensibilisation AS is_sensibilisation_53,
  t0.date_quittance AS date_quittance_54,
  t0.is_submitted AS is_submitted_55,
  t0.stat_suivie_aguipe AS stat_suivie_aguipe_56,
  t0.is_radier AS is_radier_57,
  t0.is_create_banque AS is_create_banque_58,
  t0.is_compte_entreprise AS is_compte_entreprise_59,
  t0.is_signature_greffe AS is_signature_greffe_60,
  t0.apport_industrie AS apport_industrie_61,
  t0.is_paiement_en_ligne AS is_paiement_en_ligne_62,
  t0.coordonees_longitude AS coordonees_longitude_63,
  t0.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_64,
  t0.coordonees_latitude AS coordonees_latitude_65,
  t0.type_secteur_activite_id AS type_secteur_activite_id_66,
  t0.secteur_activite_id AS secteur_activite_id_67,
  t0.forme_juridique_id AS forme_juridique_id_68,
  t0.pays_id AS pays_id_69,
  t0.region_id AS region_id_70,
  t0.prefecture_id AS prefecture_id_71,
  t0.sous_prefecture_id AS sous_prefecture_id_72,
  t0.quartier_id AS quartier_id_73,
  t0.utilisateur_id AS utilisateur_id_74,
  t0.type_dossier_id AS type_dossier_id_75,
  t0.type_operation_id AS type_operation_id_76,
  t0.service_juridique_id AS service_juridique_id_77,
  t0.user_depot_id AS user_depot_id_78,
  t0.user_retrait_id AS user_retrait_id_79,
  t0.user_caisse_id AS user_caisse_id_80,
  t0.utilisateur_rccm_delivre_id AS utilisateur_rccm_delivre_id_81,
  t0.user_validation_id AS user_validation_id_82,
  t0.moyen_de_sensibilisation_id AS moyen_de_sensibilisation_id_83,
  t84.id AS id_85,
  t84.doc AS doc_86,
  t84.date_radiation AS date_radiation_87,
  t84.modif AS modif_88,
  t84.created_at AS created_at_89,
  t84.updated_at AS updated_at_90,
  t84.dossier_demande_id AS dossier_demande_id_91,
  t84.user_id AS user_id_92,
  t84.type_formalite_id AS type_formalite_id_93,
  t84.motif_id AS motif_id_94,
  t0.banque_id AS banque_id_95,
  t96.id AS id_97,
  t96.code_banque AS code_banque_98,
  t96.code_agence AS code_agence_99,
  t96.rib_mandateur AS rib_mandateur_100,
  t96.bordereau AS bordereau_101,
  t96.created_at AS created_at_102,
  t96.updated_at AS updated_at_103,
  t96.dossier_demande_id AS dossier_demande_id_104,
  t96.banque_id AS banque_id_105,
  t96.user_banque_id AS user_banque_id_106,
  t0.type_creation_id AS type_creation_id_107,
  t108.id AS id_109,
  t108.objet AS objet_110,
  t108.caracteristique AS caracteristique_111,
  t108.activites AS activites_112,
  t108.associes AS associes_113,
  t108.dirigeant AS dirigeant_114,
  t108.transfert AS transfert_115,
  t108.fermeture AS fermeture_116,
  t108.dissolution AS dissolution_117,
  t108.nullite AS nullite_118,
  t108.autres AS autres_119,
  t108.sigle AS sigle_120,
  t108.enseigne AS enseigne_121,
  t108.capital AS capital_122,
  t108.activtes_exercees AS activtes_exercees_123,
  t108.activites_ajoutes AS activites_ajoutes_124,
  t108.activites_supprimees AS activites_supprimees_125,
  t108.activites_actualisees AS activites_actualisees_126,
  t108.siege AS siege_127,
  t108.dossier_id AS dossier_id_128,
  t108.forme_juridique_id AS forme_juridique_id_129,
  t108.author_id AS author_id_130
FROM
  dossier_demande t0
  LEFT JOIN radiation t84 ON t84.dossier_demande_id = t0.id
  LEFT JOIN compte_entreprise t96 ON t96.dossier_demande_id = t0.id
  LEFT JOIN modification_rccm t108 ON t108.dossier_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.isactif AS isactif_2, t0.status_retrait AS status_retrait_3, t0.stat_suivie_depot AS stat_suivie_depot_4, t0.stat_suivie_quittance AS stat_suivie_quittance_5, t0.stat_suivie_saisie AS stat_suivie_saisie_6, t0.date_saisie AS date_saisie_7, t0.stat_suivie_rccm AS stat_suivie_rccm_8, t0.stat_suivie_dni AS stat_suivie_dni_9, t0.date_retrait AS date_retrait_10, t0.est_retire AS est_retire_11, t0.is_handicape AS is_handicape_12, t0.denomination_sociale AS denomination_sociale_13, t0.nom_commercial AS nom_commercial_14, t0.activite_sociale AS activite_sociale_15, t0.activite_complementaire AS activite_complementaire_16, t0.sigle AS sigle_17, t0.enseigne AS enseigne_18, t0.adresse_siege AS adresse_siege_19, t0.adresse_etablissement AS adresse_etablissement_20, t0.boite_postale AS boite_postale_21, t0.telephone AS telephone_22, t0.telephone2 AS telephone2_23, t0.email AS email_24, t0.en_activite AS en_activite_25, t0.nombre_action AS nombre_action_26, t0.date_debut AS date_debut_27, t0.nombre_salarie_prevu AS nombre_salarie_prevu_28, t0.valeur_nominale AS valeur_nominale_29, t0.capital_social AS capital_social_30, t0.apport_numeraire AS apport_numeraire_31, t0.apport_nature AS apport_nature_32, t0.document_collectes AS document_collectes_33, t0.statut AS statut_34, t0.statut_validation AS statut_validation_35, t0.date_creation AS date_creation_36, t0.date_validation AS date_validation_37, t0.date_delivrance AS date_delivrance_38, t0.numero_dossier AS numero_dossier_39, t0.rccm_siege AS rccm_siege_40, t0.code_fiscal AS code_fiscal_41, t0.ville AS ville_42, t0.motif AS motif_43, t0.soussigne AS soussigne_44, t0.fonction_soussigne AS fonction_soussigne_45, t0.telephone_promoteur AS telephone_promoteur_46, t0.email_promoteur AS email_promoteur_47, t0.statut_validation_chef_greffe AS statut_validation_chef_greffe_48, t0.date_validation_chef_greffe AS date_validation_chef_greffe_49, t0.duree AS duree_50, t0.is_modification AS is_modification_51, t0.is_aguipe AS is_aguipe_52, t0.is_sensibilisation AS is_sensibilisation_53, t0.date_quittance AS date_quittance_54, t0.is_submitted AS is_submitted_55, t0.stat_suivie_aguipe AS stat_suivie_aguipe_56, t0.is_radier AS is_radier_57, t0.is_create_banque AS is_create_banque_58, t0.is_compte_entreprise AS is_compte_entreprise_59, t0.is_signature_greffe AS is_signature_greffe_60, t0.apport_industrie AS apport_industrie_61, t0.is_paiement_en_ligne AS is_paiement_en_ligne_62, t0.coordonees_longitude AS coordonees_longitude_63, t0.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_64, t0.coordonees_latitude AS coordonees_latitude_65, t0.type_secteur_activite_id AS type_secteur_activite_id_66, t0.secteur_activite_id AS secteur_activite_id_67, t0.forme_juridique_id AS forme_juridique_id_68, t0.pays_id AS pays_id_69, t0.region_id AS region_id_70, t0.prefecture_id AS prefecture_id_71, t0.sous_prefecture_id AS sous_prefecture_id_72, t0.quartier_id AS quartier_id_73, t0.utilisateur_id AS utilisateur_id_74, t0.type_dossier_id AS type_dossier_id_75, t0.type_operation_id AS type_operation_id_76, t0.service_juridique_id AS service_juridique_id_77, t0.user_depot_id AS user_depot_id_78, t0.user_retrait_id AS user_retrait_id_79, t0.user_caisse_id AS user_caisse_id_80, t0.utilisateur_rccm_delivre_id AS utilisateur_rccm_delivre_id_81, t0.user_validation_id AS user_validation_id_82, t0.moyen_de_sensibilisation_id AS moyen_de_sensibilisation_id_83, t84.id AS id_85, t84.doc AS doc_86, t84.date_radiation AS date_radiation_87, t84.modif AS modif_88, t84.created_at AS created_at_89, t84.updated_at AS updated_at_90, t84.dossier_demande_id AS dossier_demande_id_91, t84.user_id AS user_id_92, t84.type_formalite_id AS type_formalite_id_93, t84.motif_id AS motif_id_94, t0.banque_id AS banque_id_95, t96.id AS id_97, t96.code_banque AS code_banque_98, t96.code_agence AS code_agence_99, t96.rib_mandateur AS rib_mandateur_100, t96.bordereau AS bordereau_101, t96.created_at AS created_at_102, t96.updated_at AS updated_at_103, t96.dossier_demande_id AS dossier_demande_id_104, t96.banque_id AS banque_id_105, t96.user_banque_id AS user_banque_id_106, t0.type_creation_id AS type_creation_id_107, t108.id AS id_109, t108.objet AS objet_110, t108.caracteristique AS caracteristique_111, t108.activites AS activites_112, t108.associes AS associes_113, t108.dirigeant AS dirigeant_114, t108.transfert AS transfert_115, t108.fermeture AS fermeture_116, t108.dissolution AS dissolution_117, t108.nullite AS nullite_118, t108.autres AS autres_119, t108.sigle AS sigle_120, t108.enseigne AS enseigne_121, t108.capital AS capital_122, t108.activtes_exercees AS activtes_exercees_123, t108.activites_ajoutes AS activites_ajoutes_124, t108.activites_supprimees AS activites_supprimees_125, t108.activites_actualisees AS activites_actualisees_126, t108.siege AS siege_127, t108.dossier_id AS dossier_id_128, t108.forme_juridique_id AS forme_juridique_id_129, t108.author_id AS author_id_130 FROM dossier_demande t0 LEFT JOIN radiation t84 ON t84.dossier_demande_id = t0.id LEFT JOIN compte_entreprise t96 ON t96.dossier_demande_id = t0.id LEFT JOIN modification_rccm t108 ON t108.dossier_id = t0.id WHERE t0.id = '316' LIMIT 1;

INSERT INTO gerant (
  nom, prenom, date_naisse_at, lieu_naiss,
  adresse, profession, num_piece_identite,
  telephone1, telephone2, email, piece_id_path,
  deux_photo_path, date_delivrance_piece,
  datexpiration_piece, ville_delivrance_piece,
  duree_mandat, ville, apport_capital,
  certificat_residence, apport_numeraire,
  apport_nature, apport_industrie,
  nom_pere, prenom_pere, nom_mere,
  prenom_mere, pourcentage_participation,
  date_debut_relation, quarti, nationalite_id,
  situation_matrimoniale_id, pieceidentite_id,
  region_id, prefecture_id, sous_prefecture_id,
  quartier_id, genre_id, demande_dossier_id,
  fonction_id, type_associe_id, civility_id,
  pays_naissance_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO gerant (nom, prenom, date_naisse_at, lieu_naiss, adresse, profession, num_piece_identite, telephone1, telephone2, email, piece_id_path, deux_photo_path, date_delivrance_piece, datexpiration_piece, ville_delivrance_piece, duree_mandat, ville, apport_capital, certificat_residence, apport_numeraire, apport_nature, apport_industrie, nom_pere, prenom_pere, nom_mere, prenom_mere, pourcentage_participation, date_debut_relation, quarti, nationalite_id, situation_matrimoniale_id, pieceidentite_id, region_id, prefecture_id, sous_prefecture_id, quartier_id, genre_id, demande_dossier_id, fonction_id, type_associe_id, civility_id, pays_naissance_id) VALUES ('DIOUBATE', 'MAMADY I', '1986-10-06 00:00:00', 'KEROUANE', 'M\'BALIA II C/KEROUANE', NULL, '4106102210170018', '(+224) 627-46-25-67', NULL, 'holdingmultiserviceshms@gmail.com', NULL, NULL, '2022-10-21 00:00:00', '2027-10-21 00:00:00', 'CONAKRY/M.S.P.C', NULL, 'KEROUANE', 0, NULL, 0, 0, 0, 'DIOUBATE', 'KABA', 'CONDE', 'MARIAME', NULL, NULL, 'M\'BALIA II C/KEROUANE', 240, 2, 1, NULL, NULL, NULL, NULL, 1, 316, 1, NULL, NULL, 240);

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.isactif AS isactif_3,
  t0.sigle AS sigle_4
FROM
  form_juridique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.isactif AS isactif_3, t0.sigle AS sigle_4 FROM form_juridique t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.actif AS actif_5
FROM
  fonction t0
WHERE
  t0.code IN (?, ?)
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.actif AS actif_5 FROM fonction t0 WHERE t0.code IN ('GR', 'CG') ORDER BY t0.libelle ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.date_naissance AS date_naissance_4,
  t0.lieu_naissance AS lieu_naissance_5,
  t0.adresse AS adresse_6,
  t0.telephone AS telephone_7,
  t0.account_must_be_verified_before AS account_must_be_verified_before_8,
  t0.registration_token AS registration_token_9,
  t0.is_verified AS is_verified_10,
  t0.account_verified_at AS account_verified_at_11,
  t0.forgot_password_token AS forgot_password_token_12,
  t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13,
  t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14,
  t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15,
  t0.password AS password_16,
  t0.nom AS nom_17,
  t0.prenom AS prenom_18,
  t0.numero_piece_identite AS numero_piece_identite_19,
  t0.ville AS ville_20,
  t0.last_login AS last_login_21,
  t0.last_logout AS last_logout_22,
  t0.is_first_login AS is_first_login_23,
  t0.username AS username_24,
  t0.signature_file_name AS signature_file_name_25,
  t0.code_pin AS code_pin_26,
  t0.signataire_id AS signataire_id_27,
  t0.appelant_id AS appelant_id_28,
  t0.kyc_piece1 AS kyc_piece1_29,
  t0.kyc_piece2 AS kyc_piece2_30,
  t0.kyc_photo AS kyc_photo_31,
  t0.photo_profil AS photo_profil_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.civilite_id AS civilite_id_35,
  t0.piece_itendite_id AS piece_itendite_id_36,
  t0.pays_id AS pays_id_37,
  t0.service_id AS service_id_38,
  t0.role_id AS role_id_39,
  t0.banque_id AS banque_id_40
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.date_naissance AS date_naissance_4, t0.lieu_naissance AS lieu_naissance_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.account_must_be_verified_before AS account_must_be_verified_before_8, t0.registration_token AS registration_token_9, t0.is_verified AS is_verified_10, t0.account_verified_at AS account_verified_at_11, t0.forgot_password_token AS forgot_password_token_12, t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13, t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14, t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15, t0.password AS password_16, t0.nom AS nom_17, t0.prenom AS prenom_18, t0.numero_piece_identite AS numero_piece_identite_19, t0.ville AS ville_20, t0.last_login AS last_login_21, t0.last_logout AS last_logout_22, t0.is_first_login AS is_first_login_23, t0.username AS username_24, t0.signature_file_name AS signature_file_name_25, t0.code_pin AS code_pin_26, t0.signataire_id AS signataire_id_27, t0.appelant_id AS appelant_id_28, t0.kyc_piece1 AS kyc_piece1_29, t0.kyc_piece2 AS kyc_piece2_30, t0.kyc_photo AS kyc_photo_31, t0.photo_profil AS photo_profil_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.civilite_id AS civilite_id_35, t0.piece_itendite_id AS piece_itendite_id_36, t0.pays_id AS pays_id_37, t0.service_id AS service_id_38, t0.role_id AS role_id_39, t0.banque_id AS banque_id_40 FROM utilisateur t0 WHERE t0.id = 36;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.date_naisse_at AS date_naisse_at_4,
  t0.lieu_naiss AS lieu_naiss_5,
  t0.adresse AS adresse_6,
  t0.profession AS profession_7,
  t0.num_piece_identite AS num_piece_identite_8,
  t0.telephone1 AS telephone1_9,
  t0.telephone2 AS telephone2_10,
  t0.email AS email_11,
  t0.piece_id_path AS piece_id_path_12,
  t0.deux_photo_path AS deux_photo_path_13,
  t0.date_delivrance_piece AS date_delivrance_piece_14,
  t0.datexpiration_piece AS datexpiration_piece_15,
  t0.ville_delivrance_piece AS ville_delivrance_piece_16,
  t0.duree_mandat AS duree_mandat_17,
  t0.ville AS ville_18,
  t0.apport_capital AS apport_capital_19,
  t0.certificat_residence AS certificat_residence_20,
  t0.apport_numeraire AS apport_numeraire_21,
  t0.apport_nature AS apport_nature_22,
  t0.apport_industrie AS apport_industrie_23,
  t0.nom_pere AS nom_pere_24,
  t0.prenom_pere AS prenom_pere_25,
  t0.nom_mere AS nom_mere_26,
  t0.prenom_mere AS prenom_mere_27,
  t0.pourcentage_participation AS pourcentage_participation_28,
  t0.date_debut_relation AS date_debut_relation_29,
  t0.quarti AS quarti_30,
  t0.nationalite_id AS nationalite_id_31,
  t0.situation_matrimoniale_id AS situation_matrimoniale_id_32,
  t0.pieceidentite_id AS pieceidentite_id_33,
  t0.region_id AS region_id_34,
  t0.prefecture_id AS prefecture_id_35,
  t0.sous_prefecture_id AS sous_prefecture_id_36,
  t0.quartier_id AS quartier_id_37,
  t0.genre_id AS genre_id_38,
  t0.demande_dossier_id AS demande_dossier_id_39,
  t0.fonction_id AS fonction_id_40,
  t0.type_associe_id AS type_associe_id_41,
  t42.id AS id_43,
  t42.statut AS statut_44,
  t42.fonction_id AS fonction_id_45,
  t42.gerant_id AS gerant_id_46,
  t0.civility_id AS civility_id_47,
  t0.pays_naissance_id AS pays_naissance_id_48
FROM
  gerant t0
  LEFT JOIN gerant_modification_rccm t42 ON t42.gerant_id = t0.id
WHERE
  t0.demande_dossier_id = ?
  AND t0.fonction_id IN (?, ?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naisse_at AS date_naisse_at_4, t0.lieu_naiss AS lieu_naiss_5, t0.adresse AS adresse_6, t0.profession AS profession_7, t0.num_piece_identite AS num_piece_identite_8, t0.telephone1 AS telephone1_9, t0.telephone2 AS telephone2_10, t0.email AS email_11, t0.piece_id_path AS piece_id_path_12, t0.deux_photo_path AS deux_photo_path_13, t0.date_delivrance_piece AS date_delivrance_piece_14, t0.datexpiration_piece AS datexpiration_piece_15, t0.ville_delivrance_piece AS ville_delivrance_piece_16, t0.duree_mandat AS duree_mandat_17, t0.ville AS ville_18, t0.apport_capital AS apport_capital_19, t0.certificat_residence AS certificat_residence_20, t0.apport_numeraire AS apport_numeraire_21, t0.apport_nature AS apport_nature_22, t0.apport_industrie AS apport_industrie_23, t0.nom_pere AS nom_pere_24, t0.prenom_pere AS prenom_pere_25, t0.nom_mere AS nom_mere_26, t0.prenom_mere AS prenom_mere_27, t0.pourcentage_participation AS pourcentage_participation_28, t0.date_debut_relation AS date_debut_relation_29, t0.quarti AS quarti_30, t0.nationalite_id AS nationalite_id_31, t0.situation_matrimoniale_id AS situation_matrimoniale_id_32, t0.pieceidentite_id AS pieceidentite_id_33, t0.region_id AS region_id_34, t0.prefecture_id AS prefecture_id_35, t0.sous_prefecture_id AS sous_prefecture_id_36, t0.quartier_id AS quartier_id_37, t0.genre_id AS genre_id_38, t0.demande_dossier_id AS demande_dossier_id_39, t0.fonction_id AS fonction_id_40, t0.type_associe_id AS type_associe_id_41, t42.id AS id_43, t42.statut AS statut_44, t42.fonction_id AS fonction_id_45, t42.gerant_id AS gerant_id_46, t0.civility_id AS civility_id_47, t0.pays_naissance_id AS pays_naissance_id_48 FROM gerant t0 LEFT JOIN gerant_modification_rccm t42 ON t42.gerant_id = t0.id WHERE t0.demande_dossier_id = 316 AND t0.fonction_id IN (8, 1);

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.code AS code_2
FROM
  genre g0_
WHERE
  g0_.id IN (?)

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2 FROM genre g0_ WHERE g0_.id IN ('1');

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.libelle AS libelle_2,
  s0_.isactif AS isactif_3
FROM
  situation_matrimoniale s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.libelle AS libelle_2, s0_.isactif AS isactif_3 FROM situation_matrimoniale s0_ WHERE s0_.id IN ('2');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  p0_.id AS id_0,
  p0_.libelle AS libelle_1,
  p0_.code AS code_2
FROM
  piece_identite p0_
WHERE
  p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.code AS code_2 FROM piece_identite p0_ WHERE p0_.id IN ('1');

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.date_naisse_at AS date_naisse_at_4,
  t0.lieu_naiss AS lieu_naiss_5,
  t0.adresse AS adresse_6,
  t0.profession AS profession_7,
  t0.num_piece_identite AS num_piece_identite_8,
  t0.telephone1 AS telephone1_9,
  t0.telephone2 AS telephone2_10,
  t0.email AS email_11,
  t0.piece_id_path AS piece_id_path_12,
  t0.deux_photo_path AS deux_photo_path_13,
  t0.date_delivrance_piece AS date_delivrance_piece_14,
  t0.datexpiration_piece AS datexpiration_piece_15,
  t0.ville_delivrance_piece AS ville_delivrance_piece_16,
  t0.duree_mandat AS duree_mandat_17,
  t0.ville AS ville_18,
  t0.apport_capital AS apport_capital_19,
  t0.certificat_residence AS certificat_residence_20,
  t0.apport_numeraire AS apport_numeraire_21,
  t0.apport_nature AS apport_nature_22,
  t0.apport_industrie AS apport_industrie_23,
  t0.nom_pere AS nom_pere_24,
  t0.prenom_pere AS prenom_pere_25,
  t0.nom_mere AS nom_mere_26,
  t0.prenom_mere AS prenom_mere_27,
  t0.pourcentage_participation AS pourcentage_participation_28,
  t0.date_debut_relation AS date_debut_relation_29,
  t0.quarti AS quarti_30,
  t0.nationalite_id AS nationalite_id_31,
  t0.situation_matrimoniale_id AS situation_matrimoniale_id_32,
  t0.pieceidentite_id AS pieceidentite_id_33,
  t0.region_id AS region_id_34,
  t0.prefecture_id AS prefecture_id_35,
  t0.sous_prefecture_id AS sous_prefecture_id_36,
  t0.quartier_id AS quartier_id_37,
  t0.genre_id AS genre_id_38,
  t0.demande_dossier_id AS demande_dossier_id_39,
  t0.fonction_id AS fonction_id_40,
  t0.type_associe_id AS type_associe_id_41,
  t42.id AS id_43,
  t42.statut AS statut_44,
  t42.fonction_id AS fonction_id_45,
  t42.gerant_id AS gerant_id_46,
  t0.civility_id AS civility_id_47,
  t0.pays_naissance_id AS pays_naissance_id_48
FROM
  gerant t0
  LEFT JOIN gerant_modification_rccm t42 ON t42.gerant_id = t0.id
WHERE
  t0.demande_dossier_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naisse_at AS date_naisse_at_4, t0.lieu_naiss AS lieu_naiss_5, t0.adresse AS adresse_6, t0.profession AS profession_7, t0.num_piece_identite AS num_piece_identite_8, t0.telephone1 AS telephone1_9, t0.telephone2 AS telephone2_10, t0.email AS email_11, t0.piece_id_path AS piece_id_path_12, t0.deux_photo_path AS deux_photo_path_13, t0.date_delivrance_piece AS date_delivrance_piece_14, t0.datexpiration_piece AS datexpiration_piece_15, t0.ville_delivrance_piece AS ville_delivrance_piece_16, t0.duree_mandat AS duree_mandat_17, t0.ville AS ville_18, t0.apport_capital AS apport_capital_19, t0.certificat_residence AS certificat_residence_20, t0.apport_numeraire AS apport_numeraire_21, t0.apport_nature AS apport_nature_22, t0.apport_industrie AS apport_industrie_23, t0.nom_pere AS nom_pere_24, t0.prenom_pere AS prenom_pere_25, t0.nom_mere AS nom_mere_26, t0.prenom_mere AS prenom_mere_27, t0.pourcentage_participation AS pourcentage_participation_28, t0.date_debut_relation AS date_debut_relation_29, t0.quarti AS quarti_30, t0.nationalite_id AS nationalite_id_31, t0.situation_matrimoniale_id AS situation_matrimoniale_id_32, t0.pieceidentite_id AS pieceidentite_id_33, t0.region_id AS region_id_34, t0.prefecture_id AS prefecture_id_35, t0.sous_prefecture_id AS sous_prefecture_id_36, t0.quartier_id AS quartier_id_37, t0.genre_id AS genre_id_38, t0.demande_dossier_id AS demande_dossier_id_39, t0.fonction_id AS fonction_id_40, t0.type_associe_id AS type_associe_id_41, t42.id AS id_43, t42.statut AS statut_44, t42.fonction_id AS fonction_id_45, t42.gerant_id AS gerant_id_46, t0.civility_id AS civility_id_47, t0.pays_naissance_id AS pays_naissance_id_48 FROM gerant t0 LEFT JOIN gerant_modification_rccm t42 ON t42.gerant_id = t0.id WHERE t0.demande_dossier_id = 316;