Symfony Profiler

[
  "route" => "admin"
  "route_parameters" => [
    "_route" => "admin"
    "_controller" => "App\Controller\Admin\DashboardController::index"
    "routeCreatedByEasyAdmin" => true
    "dashboardControllerFqcn" => "App\Controller\Admin\DashboardController"
    "crudControllerFqcn" => null
    "crudAction" => null
  ]
  "request_uri" => "https://trouvascan.swack.fr/admin?routeName=app_home"
  "method" => "GET"
]

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

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

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "trouvascan"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "trouvascan"
    "serverVersion" => "9.7.0"
    "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.prenom AS prenom_5, t0.nom AS nom_6, t0.actif AS actif_7, t0.created_at AS created_at_8, t0.site_id AS site_id_9 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01žºx~±t&¡ð…n\x05½ûy"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

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

[
  "sql" => "SELECT COUNT(a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.statut = ? AND a0_.site_id = ?"
  "params" => [
    1 => "en_stock"
    2 => b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#869}
  ]
]

[
  "sql" => "SELECT a0_.filiere AS filiere_0, COUNT(a0_.id) AS sclr_1, SUM(a0_.poids_calcule_kg) AS sclr_2 FROM article a0_ WHERE a0_.trimestre_reception = ? AND a0_.annee_reception = ? AND a0_.site_id = ? GROUP BY a0_.filiere"
  "params" => [
    1 => 2
    2 => 2026
    3 => b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#856
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#856}
    3 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.type_sortie AS type_sortie_0, COUNT(s0_.id) AS sclr_1 FROM sortie_article s0_ INNER JOIN article a1_ ON s0_.article_id = a1_.id WHERE s0_.trimestre_sortie = ? AND s0_.annee_sortie = ? AND a1_.site_id = ? GROUP BY s0_.type_sortie"
  "params" => [
    1 => 2
    2 => 2026
    3 => b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#856
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#856}
    3 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.filiere AS filiere_3, t0.type_apport AS type_apport_4, t0.methode_saisie AS methode_saisie_5, t0.poids_kg AS poids_kg_6, t0.quantite AS quantite_7, t0.poids_calcule_kg AS poids_calcule_kg_8, t0.description AS description_9, t0.prix_estime AS prix_estime_10, t0.chemin_photo AS chemin_photo_11, t0.statut AS statut_12, t0.etiquette_imprimee AS etiquette_imprimee_13, t0.date_reception AS date_reception_14, t0.trimestre_reception AS trimestre_reception_15, t0.annee_reception AS annee_reception_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.site_id AS site_id_19, t0.cree_par_id AS cree_par_id_20, t0.categorie_id AS categorie_id_21, t0.sous_categorie_id AS sous_categorie_id_22, t0.partenaire_id AS partenaire_id_23, t24.id AS id_25, t24.type_sortie AS type_sortie_26, t24.date_sortie AS date_sortie_27, t24.trimestre_sortie AS trimestre_sortie_28, t24.annee_sortie AS annee_sortie_29, t24.type_dea AS type_dea_30, t24.created_at AS created_at_31, t24.article_id AS article_id_32, t24.enregistre_par_id AS enregistre_par_id_33 FROM article t0 LEFT JOIN sortie_article t24 ON t24.article_id = t0.id WHERE t0.site_id = ? ORDER BY t0.created_at DESC LIMIT 8"
  "params" => [
    1 => b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.actif AS actif_7, t0.imprimante_ip AS imprimante_ip_8, t0.imprimante_port AS imprimante_port_9, t0.created_at AS created_at_10, t0.organisation_id AS organisation_id_11 FROM site t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filiere AS filiere_2, t0.code AS code_3, t0.libelle AS libelle_4, t0.ordre AS ordre_5, t0.actif AS actif_6 FROM categorie_article t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01žº†ùütغÛ3K5ù3²"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_main"
]