Symfony Profiler

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

SELECT
  d0_.id AS id_0,
  d0_.isactif AS isactif_1,
  d0_.status_retrait AS status_retrait_2,
  d0_.stat_suivie_depot AS stat_suivie_depot_3,
  d0_.stat_suivie_quittance AS stat_suivie_quittance_4,
  d0_.stat_suivie_saisie AS stat_suivie_saisie_5,
  d0_.date_saisie AS date_saisie_6,
  d0_.stat_suivie_rccm AS stat_suivie_rccm_7,
  d0_.stat_suivie_dni AS stat_suivie_dni_8,
  d0_.date_retrait AS date_retrait_9,
  d0_.est_retire AS est_retire_10,
  d0_.is_handicape AS is_handicape_11,
  d0_.denomination_sociale AS denomination_sociale_12,
  d0_.nom_commercial AS nom_commercial_13,
  d0_.activite_sociale AS activite_sociale_14,
  d0_.activite_complementaire AS activite_complementaire_15,
  d0_.sigle AS sigle_16,
  d0_.enseigne AS enseigne_17,
  d0_.adresse_siege AS adresse_siege_18,
  d0_.adresse_etablissement AS adresse_etablissement_19,
  d0_.boite_postale AS boite_postale_20,
  d0_.telephone AS telephone_21,
  d0_.telephone2 AS telephone2_22,
  d0_.email AS email_23,
  d0_.en_activite AS en_activite_24,
  d0_.nombre_action AS nombre_action_25,
  d0_.date_debut AS date_debut_26,
  d0_.nombre_salarie_prevu AS nombre_salarie_prevu_27,
  d0_.valeur_nominale AS valeur_nominale_28,
  d0_.capital_social AS capital_social_29,
  d0_.apport_numeraire AS apport_numeraire_30,
  d0_.apport_nature AS apport_nature_31,
  d0_.document_collectes AS document_collectes_32,
  d0_.statut AS statut_33,
  d0_.statut_validation AS statut_validation_34,
  d0_.date_creation AS date_creation_35,
  d0_.date_validation AS date_validation_36,
  d0_.date_delivrance AS date_delivrance_37,
  d0_.numero_dossier AS numero_dossier_38,
  d0_.rccm_siege AS rccm_siege_39,
  d0_.code_fiscal AS code_fiscal_40,
  d0_.ville AS ville_41,
  d0_.motif AS motif_42,
  d0_.soussigne AS soussigne_43,
  d0_.fonction_soussigne AS fonction_soussigne_44,
  d0_.telephone_promoteur AS telephone_promoteur_45,
  d0_.email_promoteur AS email_promoteur_46,
  d0_.statut_validation_chef_greffe AS statut_validation_chef_greffe_47,
  d0_.date_validation_chef_greffe AS date_validation_chef_greffe_48,
  d0_.duree AS duree_49,
  d0_.is_modification AS is_modification_50,
  d0_.is_aguipe AS is_aguipe_51,
  d0_.is_sensibilisation AS is_sensibilisation_52,
  d0_.date_quittance AS date_quittance_53,
  d0_.is_submitted AS is_submitted_54,
  d0_.stat_suivie_aguipe AS stat_suivie_aguipe_55,
  d0_.is_radier AS is_radier_56,
  d0_.is_create_banque AS is_create_banque_57,
  d0_.is_compte_entreprise AS is_compte_entreprise_58,
  d0_.is_signature_greffe AS is_signature_greffe_59,
  d0_.apport_industrie AS apport_industrie_60,
  d0_.is_paiement_en_ligne AS is_paiement_en_ligne_61,
  d0_.coordonees_longitude AS coordonees_longitude_62,
  d0_.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_63,
  d0_.coordonees_latitude AS coordonees_latitude_64,
  d0_.type_secteur_activite_id AS type_secteur_activite_id_65,
  d0_.secteur_activite_id AS secteur_activite_id_66,
  d0_.forme_juridique_id AS forme_juridique_id_67,
  d0_.pays_id AS pays_id_68,
  d0_.region_id AS region_id_69,
  d0_.prefecture_id AS prefecture_id_70,
  d0_.sous_prefecture_id AS sous_prefecture_id_71,
  d0_.quartier_id AS quartier_id_72,
  d0_.utilisateur_id AS utilisateur_id_73,
  d0_.type_dossier_id AS type_dossier_id_74,
  d0_.type_operation_id AS type_operation_id_75,
  d0_.service_juridique_id AS service_juridique_id_76,
  d0_.user_depot_id AS user_depot_id_77,
  d0_.user_retrait_id AS user_retrait_id_78,
  d0_.user_caisse_id AS user_caisse_id_79,
  d0_.utilisateur_rccm_delivre_id AS utilisateur_rccm_delivre_id_80,
  d0_.user_validation_id AS user_validation_id_81,
  d0_.moyen_de_sensibilisation_id AS moyen_de_sensibilisation_id_82,
  d0_.banque_id AS banque_id_83,
  d0_.type_creation_id AS type_creation_id_84
FROM
  dossier_demande d0_
  INNER JOIN utilisateur u1_ ON d0_.utilisateur_id = u1_.id
WHERE
  d0_.stat_suivie_saisie IS NULL
  AND d0_.is_modification IS NULL
  AND u1_.id = ?
ORDER BY
  d0_.date_creation DESC

SELECT d0_.id AS id_0, d0_.isactif AS isactif_1, d0_.status_retrait AS status_retrait_2, d0_.stat_suivie_depot AS stat_suivie_depot_3, d0_.stat_suivie_quittance AS stat_suivie_quittance_4, d0_.stat_suivie_saisie AS stat_suivie_saisie_5, d0_.date_saisie AS date_saisie_6, d0_.stat_suivie_rccm AS stat_suivie_rccm_7, d0_.stat_suivie_dni AS stat_suivie_dni_8, d0_.date_retrait AS date_retrait_9, d0_.est_retire AS est_retire_10, d0_.is_handicape AS is_handicape_11, d0_.denomination_sociale AS denomination_sociale_12, d0_.nom_commercial AS nom_commercial_13, d0_.activite_sociale AS activite_sociale_14, d0_.activite_complementaire AS activite_complementaire_15, d0_.sigle AS sigle_16, d0_.enseigne AS enseigne_17, d0_.adresse_siege AS adresse_siege_18, d0_.adresse_etablissement AS adresse_etablissement_19, d0_.boite_postale AS boite_postale_20, d0_.telephone AS telephone_21, d0_.telephone2 AS telephone2_22, d0_.email AS email_23, d0_.en_activite AS en_activite_24, d0_.nombre_action AS nombre_action_25, d0_.date_debut AS date_debut_26, d0_.nombre_salarie_prevu AS nombre_salarie_prevu_27, d0_.valeur_nominale AS valeur_nominale_28, d0_.capital_social AS capital_social_29, d0_.apport_numeraire AS apport_numeraire_30, d0_.apport_nature AS apport_nature_31, d0_.document_collectes AS document_collectes_32, d0_.statut AS statut_33, d0_.statut_validation AS statut_validation_34, d0_.date_creation AS date_creation_35, d0_.date_validation AS date_validation_36, d0_.date_delivrance AS date_delivrance_37, d0_.numero_dossier AS numero_dossier_38, d0_.rccm_siege AS rccm_siege_39, d0_.code_fiscal AS code_fiscal_40, d0_.ville AS ville_41, d0_.motif AS motif_42, d0_.soussigne AS soussigne_43, d0_.fonction_soussigne AS fonction_soussigne_44, d0_.telephone_promoteur AS telephone_promoteur_45, d0_.email_promoteur AS email_promoteur_46, d0_.statut_validation_chef_greffe AS statut_validation_chef_greffe_47, d0_.date_validation_chef_greffe AS date_validation_chef_greffe_48, d0_.duree AS duree_49, d0_.is_modification AS is_modification_50, d0_.is_aguipe AS is_aguipe_51, d0_.is_sensibilisation AS is_sensibilisation_52, d0_.date_quittance AS date_quittance_53, d0_.is_submitted AS is_submitted_54, d0_.stat_suivie_aguipe AS stat_suivie_aguipe_55, d0_.is_radier AS is_radier_56, d0_.is_create_banque AS is_create_banque_57, d0_.is_compte_entreprise AS is_compte_entreprise_58, d0_.is_signature_greffe AS is_signature_greffe_59, d0_.apport_industrie AS apport_industrie_60, d0_.is_paiement_en_ligne AS is_paiement_en_ligne_61, d0_.coordonees_longitude AS coordonees_longitude_62, d0_.chiffre_affaire_previsionnel AS chiffre_affaire_previsionnel_63, d0_.coordonees_latitude AS coordonees_latitude_64, d0_.type_secteur_activite_id AS type_secteur_activite_id_65, d0_.secteur_activite_id AS secteur_activite_id_66, d0_.forme_juridique_id AS forme_juridique_id_67, d0_.pays_id AS pays_id_68, d0_.region_id AS region_id_69, d0_.prefecture_id AS prefecture_id_70, d0_.sous_prefecture_id AS sous_prefecture_id_71, d0_.quartier_id AS quartier_id_72, d0_.utilisateur_id AS utilisateur_id_73, d0_.type_dossier_id AS type_dossier_id_74, d0_.type_operation_id AS type_operation_id_75, d0_.service_juridique_id AS service_juridique_id_76, d0_.user_depot_id AS user_depot_id_77, d0_.user_retrait_id AS user_retrait_id_78, d0_.user_caisse_id AS user_caisse_id_79, d0_.utilisateur_rccm_delivre_id AS utilisateur_rccm_delivre_id_80, d0_.user_validation_id AS user_validation_id_81, d0_.moyen_de_sensibilisation_id AS moyen_de_sensibilisation_id_82, d0_.banque_id AS banque_id_83, d0_.type_creation_id AS type_creation_id_84 FROM dossier_demande d0_ INNER JOIN utilisateur u1_ ON d0_.utilisateur_id = u1_.id WHERE d0_.stat_suivie_saisie IS NULL AND d0_.is_modification IS NULL AND u1_.id = 185 ORDER BY d0_.date_creation DESC;

SELECT
  t0.id AS id_1,
  t0.doc AS doc_2,
  t0.date_radiation AS date_radiation_3,
  t0.modif AS modif_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.dossier_demande_id AS dossier_demande_id_7,
  t0.user_id AS user_id_8,
  t0.type_formalite_id AS type_formalite_id_9,
  t0.motif_id AS motif_id_10,
  t11.id AS id_12,
  t11.date_action AS date_action_13,
  t11.statut AS statut_14,
  t11.beneficiaire AS beneficiaire_15,
  t11.adresse_siege AS adresse_siege_16,
  t11.num_rccm AS num_rccm_17,
  t11.radiation_id AS radiation_id_18,
  t19.id AS id_20,
  t19.date_scission AS date_scission_21,
  t19.nom AS nom_22,
  t19.adresse_siege AS adresse_siege_23,
  t19.num_rccm AS num_rccm_24,
  t19.statut AS statut_25,
  t19.radiation_id AS radiation_id_26
FROM
  radiation t0
  LEFT JOIN cessation_activite t11 ON t11.radiation_id = t0.id
  LEFT JOIN scission t19 ON t19.radiation_id = t0.id
WHERE
  t0.dossier_demande_id = ?

SELECT t0.id AS id_1, t0.doc AS doc_2, t0.date_radiation AS date_radiation_3, t0.modif AS modif_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_demande_id AS dossier_demande_id_7, t0.user_id AS user_id_8, t0.type_formalite_id AS type_formalite_id_9, t0.motif_id AS motif_id_10, t11.id AS id_12, t11.date_action AS date_action_13, t11.statut AS statut_14, t11.beneficiaire AS beneficiaire_15, t11.adresse_siege AS adresse_siege_16, t11.num_rccm AS num_rccm_17, t11.radiation_id AS radiation_id_18, t19.id AS id_20, t19.date_scission AS date_scission_21, t19.nom AS nom_22, t19.adresse_siege AS adresse_siege_23, t19.num_rccm AS num_rccm_24, t19.statut AS statut_25, t19.radiation_id AS radiation_id_26 FROM radiation t0 LEFT JOIN cessation_activite t11 ON t11.radiation_id = t0.id LEFT JOIN scission t19 ON t19.radiation_id = t0.id WHERE t0.dossier_demande_id = 329;

SELECT
  t0.id AS id_1,
  t0.code_banque AS code_banque_2,
  t0.code_agence AS code_agence_3,
  t0.rib_mandateur AS rib_mandateur_4,
  t0.bordereau AS bordereau_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.dossier_demande_id AS dossier_demande_id_8,
  t0.banque_id AS banque_id_9,
  t0.user_banque_id AS user_banque_id_10
FROM
  compte_entreprise t0
WHERE
  t0.dossier_demande_id = ?

SELECT t0.id AS id_1, t0.code_banque AS code_banque_2, t0.code_agence AS code_agence_3, t0.rib_mandateur AS rib_mandateur_4, t0.bordereau AS bordereau_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dossier_demande_id AS dossier_demande_id_8, t0.banque_id AS banque_id_9, t0.user_banque_id AS user_banque_id_10 FROM compte_entreprise t0 WHERE t0.dossier_demande_id = 329;

SELECT
  t0.id AS id_1,
  t0.objet AS objet_2,
  t0.caracteristique AS caracteristique_3,
  t0.activites AS activites_4,
  t0.associes AS associes_5,
  t0.dirigeant AS dirigeant_6,
  t0.transfert AS transfert_7,
  t0.fermeture AS fermeture_8,
  t0.dissolution AS dissolution_9,
  t0.nullite AS nullite_10,
  t0.autres AS autres_11,
  t0.sigle AS sigle_12,
  t0.enseigne AS enseigne_13,
  t0.capital AS capital_14,
  t0.activtes_exercees AS activtes_exercees_15,
  t0.activites_ajoutes AS activites_ajoutes_16,
  t0.activites_supprimees AS activites_supprimees_17,
  t0.activites_actualisees AS activites_actualisees_18,
  t0.siege AS siege_19,
  t0.dossier_id AS dossier_id_20,
  t21.id AS id_22,
  t21.objet AS objet_23,
  t21.adresse AS adresse_24,
  t21.identite AS identite_25,
  t21.adresse_acquereur AS adresse_acquereur_26,
  t21.num_rccm AS num_rccm_27,
  t21.date_fermeture AS date_fermeture_28,
  t21.autres_infos AS autres_infos_29,
  t21.modification_id AS modification_id_30,
  t0.forme_juridique_id AS forme_juridique_id_31,
  t0.author_id AS author_id_32
FROM
  modification_rccm t0
  LEFT JOIN modification_info_etablissement_rccm t21 ON t21.modification_id = t0.id
WHERE
  t0.dossier_id = ?

SELECT t0.id AS id_1, t0.objet AS objet_2, t0.caracteristique AS caracteristique_3, t0.activites AS activites_4, t0.associes AS associes_5, t0.dirigeant AS dirigeant_6, t0.transfert AS transfert_7, t0.fermeture AS fermeture_8, t0.dissolution AS dissolution_9, t0.nullite AS nullite_10, t0.autres AS autres_11, t0.sigle AS sigle_12, t0.enseigne AS enseigne_13, t0.capital AS capital_14, t0.activtes_exercees AS activtes_exercees_15, t0.activites_ajoutes AS activites_ajoutes_16, t0.activites_supprimees AS activites_supprimees_17, t0.activites_actualisees AS activites_actualisees_18, t0.siege AS siege_19, t0.dossier_id AS dossier_id_20, t21.id AS id_22, t21.objet AS objet_23, t21.adresse AS adresse_24, t21.identite AS identite_25, t21.adresse_acquereur AS adresse_acquereur_26, t21.num_rccm AS num_rccm_27, t21.date_fermeture AS date_fermeture_28, t21.autres_infos AS autres_infos_29, t21.modification_id AS modification_id_30, t0.forme_juridique_id AS forme_juridique_id_31, t0.author_id AS author_id_32 FROM modification_rccm t0 LEFT JOIN modification_info_etablissement_rccm t21 ON t21.modification_id = t0.id WHERE t0.dossier_id = 329;

SELECT
  f0_.id AS id_0,
  f0_.libelle AS libelle_1,
  f0_.isactif AS isactif_2,
  f0_.sigle AS sigle_3
FROM
  form_juridique f0_
WHERE
  f0_.isactif = 1
ORDER BY
  f0_.libelle ASC

SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.isactif AS isactif_2, f0_.sigle AS sigle_3 FROM form_juridique f0_ WHERE f0_.isactif = 1 ORDER BY f0_.libelle ASC;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;