Symfony Profiler

[
  "route" => "admin_dashboard"
  "route_parameters" => [
    "_route" => "admin_dashboard"
    "_controller" => "App\Controller\AdminController::dashboard"
  ]
  "request_uri" => "https://amai-group.com/admin/dashboard"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "amaig2576279"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "amaig2576279"
    "serverVersion" => "10.11.11-MariaDB-deb12"
    "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.is_verified AS is_verified_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.date_ajout AS date_ajout_8, t0.date_modif AS date_modif_9, t0.photo_code_fichier AS photo_code_fichier_10, t0.tel AS tel_11 FROM `user` t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "admin@gmail.com"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Symfony\Component\Security\Core\Authentication\Token\RememberMeToken {#674
    -user: App\Entity\User {#609 …}
    -roleNames: [
      "ROLE_ADMIN"
    ]
    -attributes: []
    -secret: "9be00e3f80c8eaf3344fb7babd2aa9c0"
    -firewallName: "main"
  }
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

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

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\SessionStrategyListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckRememberMeConditionsListener::onSuccessfulLogin"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\RememberMeListener::onSuccessfulLogin"
]

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "ContainerNqfbUyD\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT COUNT(*) FROM participant t0"
]

[
  "sql" => "SELECT COUNT(*) FROM actualite_evenement t0 WHERE t0.type_principal = ?"
  "params" => [
    1 => "evenement"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM actualite_evenement t0 WHERE t0.type_principal = ?"
  "params" => [
    1 => "actualite"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM newsletter t0"
]

[
  "sql" => "SELECT COUNT(*) FROM contact t0"
]

[
  "sql" => "SELECT COUNT(*) FROM temoignage t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.tel AS tel_5, t0.email AS email_6, t0.pays_origine AS pays_origine_7, t0.code_fichier AS code_fichier_8, t0.preference_langue AS preference_langue_9, t0.nom_entreprise AS nom_entreprise_10, t0.ville AS ville_11, t0.intitule_poste AS intitule_poste_12, t0.adresse AS adresse_13, t0.site_web_entreprise AS site_web_entreprise_14, t0.lien_facebook AS lien_facebook_15, t0.lien_linkedin AS lien_linkedin_16, t0.lien_twitter AS lien_twitter_17, t0.lien_youtube AS lien_youtube_18, t0.lien_instagram AS lien_instagram_19, t0.categorie_visiteur AS categorie_visiteur_20, t0.position AS position_21, t0.tel_portable_entreprise AS tel_portable_entreprise_22, t0.tel_fixe_entreprise AS tel_fixe_entreprise_23, t0.email_entreprise AS email_entreprise_24, t0.activite_commerciale AS activite_commerciale_25, t0.categorie_produit_vendu AS categorie_produit_vendu_26, t0.annee_creation_entreprise AS annee_creation_entreprise_27, t0.nombre_employe AS nombre_employe_28, t0.valeur_vente_annuelle_usd AS valeur_vente_annuelle_usd_29, t0.nombre_magasin AS nombre_magasin_30, t0.decideur_pour_achat AS decideur_pour_achat_31, t0.participation_salon AS participation_salon_32, t0.valeur_achat_annuelle_usd AS valeur_achat_annuelle_usd_33, t0.nombre_client_reseau_distribution AS nombre_client_reseau_distribution_34, t0.importer_vous AS importer_vous_35, t0.valeur_annuelle_importation_usd AS valeur_annuelle_importation_usd_36, t0.pays_importation AS pays_importation_37, t0.marque_importe AS marque_importe_38, t0.produit_importe AS produit_importe_39, t0.presentation_entreprise AS presentation_entreprise_40, t0.document_societe AS document_societe_41 FROM participant t0 ORDER BY t0.id DESC LIMIT 5"
]

[
  "sql" => "SELECT SUBSTRING(a0_.date_ajout FROM 1 FOR 7) AS sclr_0, a0_.type_principal AS type_principal_1, COUNT(a0_.id) AS sclr_2 FROM actualite_evenement a0_ WHERE a0_.date_ajout >= ? AND a0_.type_principal IN (?, ?) GROUP BY sclr_0, a0_.type_principal ORDER BY sclr_0 ASC"
  "params" => [
    1 => "2025-04-01 00:00:00"
    2 => "actualite"
    3 => "evenement"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT p0_.pays_origine AS pays_origine_0, COUNT(p0_.id) AS sclr_1 FROM participant p0_ WHERE p0_.pays_origine IS NOT NULL AND p0_.pays_origine <> '' GROUP BY p0_.pays_origine ORDER BY sclr_1 DESC LIMIT 4"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1"
  "params" => [
    1 => "lW9uq31uSNRzuzo3"
  ]
  "types" => [
    1 => 2
  ]
]

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