Symfony Profiler

[
  "route" => "acteurs"
  "route_parameters" => [
    "_route" => "acteurs"
    "_controller" => "App\Controller\FrontendController::acteurs"
  ]
  "request_uri" => "https://circulaire.developpe.net/acteurs?page=31"
  "method" => "GET"
]

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

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

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

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "develorcircular.mysql.db"
    "port" => 3306
    "user" => "develorcircular"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "develorcircular"
    "serverVersion" => "10.04.32-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT count(a0_.id) AS sclr_0 FROM acteur a0_ LEFT JOIN departement d1_ ON a0_.departement_id = d1_.id LEFT JOIN region r2_ ON d1_.region_id = r2_.id"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.logo AS logo_1, a0_.code AS code_2, a0_.date_collecte AS date_collecte_3, a0_.denomination AS denomination_4, a0_.sigle AS sigle_5, a0_.latitude AS latitude_6, a0_.longitude AS longitude_7, a0_.commune AS commune_8, a0_.annee_creation AS annee_creation_9, a0_.numero_rccm AS numero_rccm_10, a0_.numero_ncc AS numero_ncc_11, a0_.telephone AS telephone_12, a0_.email AS email_13, a0_.site_web AS site_web_14, a0_.description AS description_15, a0_.maillon AS maillon_16, a0_.status AS status_17, a0_.qualification AS qualification_18, a0_.score AS score_19, a0_.sous_prefecture_id AS sous_prefecture_id_20, a0_.departement_id AS departement_id_21, a0_.statut_juridique_id AS statut_juridique_id_22, a0_.type_acteur_id AS type_acteur_id_23 FROM acteur a0_ LEFT JOIN departement d1_ ON a0_.departement_id = d1_.id LEFT JOIN region r2_ ON d1_.region_id = r2_.id LIMIT 12 OFFSET 360"
]

[
  "sql" => "SELECT DISTINCT dist.id, dist.nom FROM district dist ORDER BY dist.nom"
]

[
  "sql" => "SELECT DISTINCT r.id, r.nom, r.district_id FROM region r ORDER BY r.nom"
]

[
  "sql" => "SELECT DISTINCT dp.id, dp.nom, dp.region_id, r.district_id FROM departement dp JOIN region r ON dp.region_id = r.id ORDER BY dp.nom"
]

[
  "sql" => "SELECT DISTINCT sp.id, sp.nom, sp.departement_id, dp.region_id, r.district_id FROM sous_prefecture sp JOIN departement dp ON sp.departement_id = dp.id JOIN region r ON dp.region_id = r.id ORDER BY sp.nom"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_juridique t0"
]

[
  "sql" => "SELECT a.id, a.denomination, a.commune, a.code, a.sigle FROM acteur a WHERE a.status = "Actif""
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 361
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 362
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 363
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 364
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 365
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 366
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 367
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 368
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 369
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 370
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 371
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = ?"
  "params" => [
    1 => 372
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

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