Symfony Profiler

[
  "route" => "app_my_dashboard"
  "route_parameters" => [
    "_route" => "app_my_dashboard"
    "_controller" => "App\Controller\ProfilController::index"
  ]
  "request_uri" => "https://synergui.apipguinee.com/dashboard"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerYZvyBsx\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "apip_root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "apip_db"
    "serverVersion" => "8.0.30"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 196
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "office.mesacko@gmail.com"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.isactif AS isactif_5 FROM role t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.description AS description_4, t0.structure_id AS structure_id_5 FROM services t0 WHERE t0.id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.code AS code_6, t0.quartier_id AS quartier_id_7, t0.type_structure_id AS type_structure_id_8, t0.banque_id AS banque_id_9 FROM structure t0 WHERE t0.id = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.actif AS actif_4, t0.sous_prefecture_id AS sous_prefecture_id_5 FROM quartier t0 WHERE t0.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.isactif AS isactif_4, t0.prefecture_id AS prefecture_id_5 FROM sous_prefecture t0 WHERE t0.id = ?"
  "params" => [
    1 => 919
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.isactif AS isactif_4, t0.region_id AS region_id_5 FROM prefecture t0 WHERE t0.id = ?"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 196
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 224
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 224
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 224
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 220
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 220
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 220
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 126
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 126
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 126
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    SELECT d.numero_dossier AS numeroDossier ,f.libelle AS formeJuridique,d.denomination_sociale AS denominationSociale,\n
                            d.date_creation AS dateCreation,d.date_delivrance AS dateDelivrance,p.`status`,p.amount AS montant,d.id AS dossier_id\n
                        FROM dossier_demande d \n
                        INNER JOIN form_juridique f ON f.id = d.forme_juridique_id\n
                        left  JOIN paiement p ON p.dossier_demande_id = d.id\n
                        INNER JOIN utilisateur u ON d.utilisateur_id = u.id        \n
                        WHERE  d.stat_suivie_saisie = TRUE  AND d.is_modification IS NULL \n
                          AND u.id = :user ORDER BY d.date_creation DESC
    """
  "params" => [
    "user" => 196
  ]
  "types" => []
]

[
  "sql" => "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.utilisateur_id = ?"
  "params" => [
    1 => 196
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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_.is_modification = 1 AND u1_.id = ? ORDER BY d0_.date_creation DESC"
  "params" => [
    1 => 196
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]