Symfony Profiler

[
  "route" => "add_dossiers"
  "route_parameters" => [
    "_route" => "add_dossiers"
    "_controller" => "App\Controller\DossiersController::add"
  ]
  "request_uri" => "https://formatracker.com/erp/dossiers/ajouter?p=erp%2Fdossiers%2Fajouter"
  "method" => "POST"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\RememberMeToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "forma"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "forma"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.tel AS tel_7, t0.societe_id AS societe_id_8 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "cedric@aready.io"
]

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::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" => "ContainerGIJ3kq2\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.prenom AS prenom_2, c0_.mail AS mail_3, c0_.adresse AS adresse_4, c0_.ville AS ville_5, c0_.tel AS tel_6, c0_.num_edof AS num_edof_7, c0_.date_creation AS date_creation_8, c0_.vendeur AS vendeur_9, c0_.cp AS cp_10, c0_.date_naissance AS date_naissance_11, c0_.lieu_naissance AS lieu_naissance_12, c0_.statut_id AS statut_id_13, c0_.statut_prospect_id AS statut_prospect_id_14, c0_.provenance_id AS provenance_id_15, c0_.categorie_id AS categorie_id_16, c0_.civilite_id AS civilite_id_17, c0_.societe_id AS societe_id_18 FROM clients c0_ WHERE c0_.societe_id = ? AND c0_.id IN (?)"
  "params" => [
    1 => 1
    2 => "8086"
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.date_entree AS date_entree_2, s0_.date_sortie AS date_sortie_3, s0_.lieu AS lieu_4, s0_.formation_id AS formation_id_5, s0_.format_id AS format_id_6, s0_.mode_id AS mode_id_7, s0_.provenance_id AS provenance_id_8, s0_.referant_id AS referant_id_9, s0_.societe_id AS societe_id_10 FROM sessions s0_ WHERE s0_.societe_id = ? AND s0_.id IN (?)"
  "params" => [
    1 => 1
    2 => "5127"
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "INSERT INTO session_client (date, num_edof, client_id, session_id, societe_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "2025-01-08 14:43:30"
    2 => "401092068830"
    3 => 8086
    4 => 5127
    5 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "UPDATE clients SET num_edof = ? WHERE id = ?"
  "params" => [
    1 => 401092068830
    2 => 8086
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.signature AS signature_4, t0.auto_send AS auto_send_5, t0.societe_id AS societe_id_6 FROM model_document t0 WHERE t0.auto_send = ? AND t0.societe_id = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "$logoSociete$"
    2 => "$raisonSociale$"
    3 => "$raisonSociale$"
    4 => "$raisonSociale$"
    5 => "$prefectureSociete$"
    6 => "$numNDAsociete$"
    7 => "$siretSociete$"
    8 => "$adresseSociete$"
    9 => "$codePostalSociete$"
    10 => "$villeSociete$"
    11 => "$telSociete$"
    12 => "$emailSociete$"
    13 => "$telSociete$"
    14 => "$emailSociete$"
    15 => "$tamponSociete$"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.tel AS tel_7, t0.mail AS mail_8, t0.logo AS logo_9, t0.siret AS siret_10, t0.num_tva AS num_tva_11, t0.nda AS nda_12, t0.representant AS representant_13, t0.site_internet AS site_internet_14, t0.tampon AS tampon_15, t0.prefecture AS prefecture_16, t0.signature_restante AS signature_restante_17, t0.type AS type_18 FROM societe t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "$logoSociete$"
    2 => "$titreFormation$"
    3 => "$objectifFormation$"
    4 => "$preRequisFormation$"
    5 => "$resultatAttenduFormation$"
    6 => "$certificationFormation$"
    7 => "$dureeHeuresFormation$"
    8 => "$publicFormation$"
    9 => "$contenuFormation$"
    10 => "$moyenFormation$"
    11 => "$tamponSociete$"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre AS titre_2, t0.tarif_ht AS tarif_ht_3, t0.tarif_ttc AS tarif_ttc_4, t0.duree_jours AS duree_jours_5, t0.duree_heures AS duree_heures_6, t0.objectif AS objectif_7, t0.ressource AS ressource_8, t0.suivi AS suivi_9, t0.contenu AS contenu_10, t0.participant_min AS participant_min_11, t0.participant_max AS participant_max_12, t0.public AS public_13, t0.pre_requis AS pre_requis_14, t0.resultat_attendu AS resultat_attendu_15, t0.modalite_admission AS modalite_admission_16, t0.date_creation AS date_creation_17, t0.certification AS certification_18, t0.moyen AS moyen_19, t0.format_id AS format_id_20, t0.tva_id AS tva_id_21, t0.admission_id AS admission_id_22, t0.referent_id AS referent_id_23, t0.societe_id AS societe_id_24 FROM formations t0 WHERE t0.id = ?"
  "params" => [
    1 => 33
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "$logoSociete$"
    2 => "$raisonSociale$"
    3 => "$numNDAsociete$"
    4 => "$siretSociete$"
    5 => "$adresseSociete$"
    6 => "$codePostalSociete$"
    7 => "$villeSociete$"
    8 => "$telSociete$"
    9 => "$emailSociete$"
    10 => "$telSociete$"
    11 => "$emailSociete$"
    12 => "$villeSociete$"
    13 => "$dateDocument$"
    14 => "$raisonSociale$"
    15 => "$tamponSociete$"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "$logoSociete$"
    2 => "$nomClient$"
    3 => "$prenomClient$"
    4 => "$adresseClient$"
    5 => "$codePostalClient$"
    6 => "$villeClient$"
    7 => "$titreFormation$"
    8 => "$titreFormation$"
    9 => "$dateEntreeSession$"
    10 => "$dateSortieSession$"
    11 => "$tarifTTCFormation$"
    12 => "$villeSociete$"
    13 => "$dateDocument$"
    14 => "$tamponSociete$"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "$logoSociete$"
    2 => "$raisonSociale$"
    3 => "$raisonSociale$"
    4 => "$raisonSociale$"
    5 => "$raisonSociale$"
    6 => "$raisonSociale$"
    7 => "$raisonSociale$"
    8 => "$raisonSociale$"
    9 => "$raisonSociale$"
    10 => "$raisonSociale$"
    11 => "$raisonSociale$"
    12 => "$raisonSociale$"
    13 => "$raisonSociale$"
    14 => "$raisonSociale$"
    15 => "$raisonSociale$"
    16 => "$villeSociete$"
    17 => "$dateDocument$"
    18 => "$raisonSociale$"
    19 => "$tamponSociete$"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
  ]
]

[
  "sql" => "INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Mentions légales-session-5127-677e8f133f5ff.pdf"
    2 => "NOIRE-Celine-5127/Mentions légales-session-5127-677e8f133f5ff.pdf"
    3 => "2025-01-08 14:43:31"
    4 => 0
    5 => null
    6 => null
    7 => "2025-01-08 14:43:31"
    8 => null
    9 => null
    10 => null
    11 => null
    12 => 1
    13 => 1
    14 => 10010
    15 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 5
    13 => 5
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Programme de formation-session-5127-677e8f135bcd5.pdf"
    2 => "NOIRE-Celine-5127/Programme de formation-session-5127-677e8f135bcd5.pdf"
    3 => "2025-01-08 14:43:31"
    4 => 0
    5 => null
    6 => null
    7 => "2025-01-08 14:43:31"
    8 => null
    9 => null
    10 => null
    11 => null
    12 => 1
    13 => 1
    14 => 10010
    15 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 5
    13 => 5
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "CGV-session-5127-677e8f137e2af.pdf"
    2 => "NOIRE-Celine-5127/CGV-session-5127-677e8f137e2af.pdf"
    3 => "2025-01-08 14:43:31"
    4 => 0
    5 => null
    6 => null
    7 => "2025-01-08 14:43:31"
    8 => null
    9 => null
    10 => null
    11 => null
    12 => 1
    13 => 1
    14 => 10010
    15 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 5
    13 => 5
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Contrat de formation-session-5127-677e8f13a0124.pdf"
    2 => "NOIRE-Celine-5127/Contrat de formation-session-5127-677e8f13a0124.pdf"
    3 => "2025-01-08 14:43:31"
    4 => 1
    5 => null
    6 => null
    7 => "2025-01-08 14:43:31"
    8 => null
    9 => null
    10 => null
    11 => "209ebae7fddf871cd451efe773c0115d12dc9c03ee3cdcfb295f370b836be797"
    12 => 1
    13 => 1
    14 => 10010
    15 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 5
    13 => 5
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Règlement intérieur-session-5127-677e8f13d8906.pdf"
    2 => "NOIRE-Celine-5127/Règlement intérieur-session-5127-677e8f13d8906.pdf"
    3 => "2025-01-08 14:43:31"
    4 => 0
    5 => null
    6 => null
    7 => "2025-01-08 14:43:31"
    8 => null
    9 => null
    10 => null
    11 => null
    12 => 1
    13 => 1
    14 => 10010
    15 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 5
    13 => 5
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO hitorique_mail (user_mail, commentaire, date, user_id, societe_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "Celinechristmann78@gmail.com"
    2 => "document n°1 : Mentions légales-session-5127-677e8f133f5ff.pdf, document n°2 : Programme de formation-session-5127-677e8f135bcd5.pdf, document n°3 : CGV-session-5127-677e8f137e2af.pdf, document n°4 : Règlement intérieur-session-5127-677e8f13d8906.pdf"
    3 => "2025-01-08 14:43:32"
    4 => 8086
    5 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::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" => "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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]