Symfony Profiler

[
  "route" => "api_audit_stats"
  "route_parameters" => [
    "_route" => "api_audit_stats"
    "_controller" => "App\Controller\AuditController::getAuditStats"
  ]
  "request_uri" => "https://mercure-qualite-web-test.autobilan-systems.com/admin/api/audit/stats?year=2026"
  "method" => "GET"
]

[
  "key" => "_security_mainadmin"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "94.23.28.171"
    "port" => 3306
    "user" => "qualite_2_web"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "mercure_qualite_test"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#549
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "a.mandet@autobilan-systems.com"
]

[
  "firewall_name" => "mainadmin"
  "authenticators" => 1
]

[
  "firewall_name" => "mainadmin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "mainadmin"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

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

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

[
  "sql" => """
    SELECT a.lib_type_audit AS label, COUNT(*) AS count\n
                 FROM aut_audit a\n
                 WHERE 1=1 AND YEAR(a.date_audit) = ? AND a.lib_type_audit IS NOT NULL AND a.lib_type_audit != ''\n
                 GROUP BY a.lib_type_audit\n
                 ORDER BY count DESC
    """
  "params" => [
    1 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1119
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT a.type_centre AS label, COUNT(*) AS count\n
                 FROM aut_audit a\n
                 WHERE 1=1 AND YEAR(a.date_audit) = ? AND a.type_centre IS NOT NULL AND a.type_centre != ''\n
                 GROUP BY a.type_centre\n
                 ORDER BY count DESC
    """
  "params" => [
    1 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1119
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM aut_audit WHERE date_cloture IS NULL"
]

[
  "sql" => """
    SELECT a.auditeur_id, CONCAT(p.nom, ' ', p.prenom) AS auditeur, COUNT(a.id) AS count\n
                 FROM aut_audit a\n
                 LEFT JOIN bo_personnel_abs p ON p.id = a.auditeur_id\n
                 WHERE 1=1 AND YEAR(a.date_audit) = ? AND a.auditeur_id IS NOT NULL\n
                 GROUP BY a.auditeur_id, p.nom, p.prenom\n
                 ORDER BY count DESC\n
                 LIMIT 10
    """
  "params" => [
    1 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1119
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT\n
                    COALESCE(SUM(nb_nc_regl), 0)     AS total_nc_regl,\n
                    COALESCE(SUM(nb_nc_non_regl), 0) AS total_nc_non_regl,\n
                    COALESCE(SUM(nb_rem_regl), 0)    AS total_rem_regl,\n
                    COALESCE(SUM(nb_ncc_regl), 0)        AS total_ncc_regl,\n
                    COALESCE(SUM(nb_ncc_non_regl), 0)    AS total_ncc_non_regl,\n
                    COUNT(CASE WHEN date_cloture IS NOT NULL THEN 1 END) AS audits_clotures,\n
                    COUNT(CASE WHEN resultat = 'Favorable' AND date_cloture IS NOT NULL THEN 1 END) AS audits_favorables\n
                 FROM aut_audit a\n
                 WHERE 1=1 AND YEAR(a.date_audit) = ?
    """
  "params" => [
    1 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1119
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT DATE_FORMAT(a.date_audit, '%Y-%m') AS label, COUNT(*) AS count\n
                 FROM aut_audit a\n
                 WHERE 1=1 AND YEAR(a.date_audit) = ?\n
                 GROUP BY DATE_FORMAT(a.date_audit, '%Y-%m')\n
                 ORDER BY label ASC\n
                 LIMIT 60
    """
  "params" => [
    1 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1119
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT COALESCE(p.Libelle, ca.libelle) AS label, SUM(ca.nc + ca.ncc) AS count\n
                 FROM aut_contenu_audit ca\n
                 INNER JOIN aut_audit a ON a.id = ca.aut_audit_id\n
                 LEFT JOIN aut_point_audit p ON p.id = ca.aut_point_audit_id\n
                 WHERE 1=1 AND YEAR(a.date_audit) = ? AND (ca.nc > 0 OR ca.ncc > 0)\n
                 GROUP BY ca.aut_point_audit_id, COALESCE(p.Libelle, ca.libelle)\n
                 ORDER BY count DESC\n
                 LIMIT 10
    """
  "params" => [
    1 => 2026
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1119
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_mainadmin"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

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