Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://datapetroleum.ht2techinfo.cd/home"
  "method" => "GET"
]

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

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

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

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sonata\AdminBundle\EventListener\ConfigureCRUDControllerListener::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" => "ContainerEXDJIOQ\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "ht2_emine"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ht2_datapetroleum"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM operateur o0_ WHERE o0_.annee_fermeture > ?"
  "params" => [
    1 => "2018-01-01"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT t0_.id) AS sclr_0, t0_.type_permis AS type_permis_1 FROM titre_minier t0_ GROUP BY t0_.type_permis"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_gisement AS nom_gisement_2, t0.nom_mine AS nom_mine_3, t0.ressource AS ressource_4, t0.teneur AS teneur_5, t0.metal_contenu AS metal_contenu_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.annotation AS annotation_9, t0.date_debut AS date_debut_10, t0.code AS code_11, t0.details AS details_12, t0.superficie_on AS superficie_on_13, t0.superficie_off AS superficie_off_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.operateur_id AS operateur_id_18, t0.user_id AS user_id_19 FROM gisement t0"
]

[
  "sql" => "SELECT COUNT(DISTINCT g0_.id) AS sclr_0, p1_.nom AS nom_1 FROM gisement g0_ INNER JOIN gisement_province g2_ ON g0_.id = g2_.gisement_id INNER JOIN province p1_ ON p1_.id = g2_.province_id GROUP BY p1_.nom ORDER BY sclr_0 ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.unite AS unite_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.filiere_id AS filiere_id_10, t0.localisation_id AS localisation_id_11, t0.user_id AS user_id_12 FROM commodite t0"
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_"
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_"
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.created_at BETWEEN ? AND ?"
  "params" => [
    1 => "2025-01-01 00:00:00"
    2 => "2025-12-12 23:59:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.created_at BETWEEN ? AND ?"
  "params" => [
    1 => "2025-12-01 00:00:00"
    2 => "2025-12-31 23:59:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.created_at BETWEEN ? AND ?"
  "params" => [
    1 => "2025-11-01 00:00:00"
    2 => "2025-11-30 23:59:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT o0_.id) AS sclr_0, c1_.id AS id_1, c1_.nom AS nom_2 FROM operateur o0_ INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id INNER JOIN secteur s2_ ON o0_.secteur_id = s2_.id WHERE s2_.id = ? GROUP BY c1_.id, c1_.nom"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT o0_.id) AS sclr_0, c1_.id AS id_1, c1_.nom AS nom_2 FROM operateur o0_ INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id INNER JOIN secteur s2_ ON o0_.secteur_id = s2_.id WHERE s2_.id = ? GROUP BY c1_.id, c1_.nom"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT SUM(d0_.montant) AS sclr_0, t1_.nom AS nom_1 FROM decaissement d0_ INNER JOIN type_decaissement t1_ ON d0_.type_decaissement_id = t1_.id GROUP BY t1_.nom"
]

[
  "sql" => "SELECT SUM(d0_.montant) AS sclr_0, t1_.nom AS nom_1 FROM depense_caisse d0_ INNER JOIN type_decaissement t1_ ON d0_.type_depense_id = t1_.id GROUP BY t1_.nom"
]

[
  "sql" => "SELECT SUM(t0_.montant) AS sclr_0, t1_.nom AS nom_1 FROM taxe t0_ INNER JOIN type_taxe t1_ ON t0_.type_taxe_id = t1_.id GROUP BY t1_.nom"
]

[
  "sql" => "SELECT SUM(p0_.montant) AS sclr_0, p0_.type_paiement AS type_paiement_1 FROM paiement p0_ GROUP BY p0_.type_paiement"
]

[
  "sql" => "SELECT SUM(r0_.montant) AS sclr_0 FROM redevance r0_"
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0, t1_.nom AS nom_1 FROM contrat_principal c0_ INNER JOIN contrat_principal_type_contrat c2_ ON c0_.id = c2_.contrat_principal_id INNER JOIN type_contrat t1_ ON t1_.id = c2_.type_contrat_id GROUP BY t1_.nom"
]

[
  "sql" => "SELECT SUM(v0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(v0_.date_vente FROM 6 FOR 2) AS sclr_3 FROM vente_local v0_ INNER JOIN commodite c1_ ON v0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE (v0_.date_vente BETWEEN ? AND ?) AND v0_.commodite_id = ? GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC"
  "params" => [
    1 => "2018-01-01 00:00:00"
    2 => "2018-12-31 23:59:00"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT SUM(p0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(p0_.date_production FROM 6 FOR 2) AS sclr_3 FROM production p0_ INNER JOIN commodite c1_ ON p0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE (p0_.date_production BETWEEN ? AND ?) AND p0_.commodite_id = ? GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC"
  "params" => [
    1 => "2018-01-01 00:00:00"
    2 => "2018-12-31 23:59:00"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT SUM(e0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(e0_.date_exportation FROM 6 FOR 2) AS sclr_3 FROM exportation e0_ INNER JOIN commodite c1_ ON e0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE (e0_.date_exportation BETWEEN ? AND ?) AND e0_.commodite_id = ? GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC"
  "params" => [
    1 => "2018-01-01 00:00:00"
    2 => "2018-12-31 23:59:00"
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT SUM(e0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(e0_.date_exportation FROM 1 FOR 4) AS sclr_3 FROM exportation e0_ INNER JOIN commodite c1_ ON e0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE e0_.commodite_id = ? GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT SUM(p0_.quantite) AS sclr_0, SUM(p0_.cout) AS sclr_1, SUBSTRING(p0_.date_production FROM 1 FOR 4) AS sclr_2 FROM production p0_ WHERE p0_.commodite_id = ? GROUP BY sclr_2 ORDER BY sclr_2 DESC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT SUM(i0_.nbre_feminin_local) AS sclr_0, SUM(i0_.nbre_masculin_local) AS sclr_1, SUM(i0_.nbre_cadre) AS sclr_2, SUM(i0_.nbre_ouvrier) AS sclr_3, SUM(i0_.nbre_feminin_etranger) AS sclr_4, SUM(i0_.nbre_masculin_etranger) AS sclr_5, SUBSTRING(i0_.date_info FROM 1 FOR 4) AS sclr_6 FROM information_emploi i0_ GROUP BY sclr_6 ORDER BY sclr_6 ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.unite AS unite_3, t0.commodite_id AS commodite_id_4, t0.user_id AS user_id_5 FROM type_commodite t0"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = ? ORDER BY c0_.date_cours DESC LIMIT 1"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sonata\AdminBundle\EventListener\ConfigureCRUDControllerListener::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" => "ContainerEXDJIOQ\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_gisement AS nom_gisement_2, t0.nom_mine AS nom_mine_3, t0.ressource AS ressource_4, t0.teneur AS teneur_5, t0.metal_contenu AS metal_contenu_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.annotation AS annotation_9, t0.date_debut AS date_debut_10, t0.code AS code_11, t0.details AS details_12, t0.superficie_on AS superficie_on_13, t0.superficie_off AS superficie_off_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.operateur_id AS operateur_id_18, t0.user_id AS user_id_19 FROM gisement t0"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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" => "ApiPlatform\Hydra\EventListener\AddLinkHeaderListener::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" => "ApiPlatform\HttpCache\EventListener\AddHeadersListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type_mine AS type_mine_3, t0.localisation AS localisation_4, t0.categorie AS categorie_5, t0.date_decouverte AS date_decouverte_6, t0.superficie AS superficie_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_appel AS is_appel_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.projet_id AS projet_id_14, t0.gisement_id AS gisement_id_15, t0.permis_id AS permis_id_16, t0.operateur_id AS operateur_id_17, t0.user_id AS user_id_18 FROM mine t0 WHERE t0.gisement_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type_mine AS type_mine_3, t0.localisation AS localisation_4, t0.categorie AS categorie_5, t0.date_decouverte AS date_decouverte_6, t0.superficie AS superficie_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_appel AS is_appel_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.projet_id AS projet_id_14, t0.gisement_id AS gisement_id_15, t0.permis_id AS permis_id_16, t0.operateur_id AS operateur_id_17, t0.user_id AS user_id_18 FROM mine t0 WHERE t0.gisement_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type_mine AS type_mine_3, t0.localisation AS localisation_4, t0.categorie AS categorie_5, t0.date_decouverte AS date_decouverte_6, t0.superficie AS superficie_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_appel AS is_appel_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.projet_id AS projet_id_14, t0.gisement_id AS gisement_id_15, t0.permis_id AS permis_id_16, t0.operateur_id AS operateur_id_17, t0.user_id AS user_id_18 FROM mine t0 WHERE t0.gisement_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type_mine AS type_mine_3, t0.localisation AS localisation_4, t0.categorie AS categorie_5, t0.date_decouverte AS date_decouverte_6, t0.superficie AS superficie_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_appel AS is_appel_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.projet_id AS projet_id_14, t0.gisement_id AS gisement_id_15, t0.permis_id AS permis_id_16, t0.operateur_id AS operateur_id_17, t0.user_id AS user_id_18 FROM mine t0 WHERE t0.gisement_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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" => "ApiPlatform\Hydra\EventListener\AddLinkHeaderListener::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" => "ApiPlatform\HttpCache\EventListener\AddHeadersListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]