Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\DefaultController::index"
  ]
  "request_uri" => "https://www.ujrecherche.progresstn.com/"
  "method" => "GET"
]

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

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "sqlprive-mm124126-002.eu.clouddb.ovh.net"
    "port" => 35233
    "user" => "ujrechercheU"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ujrecherche"
    "serverVersion" => "5.7"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.objectif AS objectif_2, p0_.date_debut AS date_debut_3, p0_.date_fin AS date_fin_4, p0_.description AS description_5, p0_.etat AS etat_6, p0_.statut AS statut_7, p0_.domaine_recherche AS domaine_recherche_8, p0_.image AS image_9, p0_.user_id AS user_id_10, p0_.directeur_id AS directeur_id_11, p0_.theme_id AS theme_id_12, p0_.structure_id AS structure_id_13 FROM projet p0_ WHERE p0_.etat = 2 AND p0_.date_fin >= ? ORDER BY p0_.id DESC LIMIT 4"
  "params" => [
    1 => "2025-10-15 17:57:47"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.image_nom AS image_nom_1, a0_.description AS description_2, a0_.ordre AS ordre_3, a0_.date_fin AS date_fin_4, a0_.date_debut AS date_debut_5 FROM actualite a0_ WHERE a0_.date_fin >= ? ORDER BY a0_.ordre ASC"
  "params" => [
    1 => "2025-10-15 17:57:47"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => " SELECT  count(*) as nbr  FROM projet "
]

[
  "sql" => "SELECT t0.id AS id_1, t0.cin AS cin_2, t0.date_naissance AS date_naissance_3, t0.grade AS grade_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.photo AS photo_8, t0.specialite AS specialite_9, t0.biography AS biography_10, t0.linkedin AS linkedin_11, t0.orcid AS orcid_12, t0.p_google AS p_google_13, t0.p_scopus AS p_scopus_14, t0.fonction AS fonction_15, t0.p_web_science AS p_web_science_16, t0.resarchgate AS resarchgate_17, t0.masteres_recherches AS masteres_recherches_18, t0.theses_doctorat AS theses_doctorat_19, t0.date_debut AS date_debut_20, t0.date_fin AS date_fin_21, t0.projet_nationaux_iternationaux AS projet_nationaux_iternationaux_22, t0.brevet_nationaux_internationaux AS brevet_nationaux_internationaux_23, t0.autre_activites AS autre_activites_24, t0.etablissement_enseignement AS etablissement_enseignement_25, t0.etat_cin AS etat_cin_26, t0.etat_naissance AS etat_naissance_27, t0.etat_phone AS etat_phone_28, t0.etablissement_id AS etablissement_id_29, t0.user_id AS user_id_30, t0.structure_id AS structure_id_31 FROM chercheur t0"
]

[
  "sql" => " SELECT  count(*) as nbr  FROM publication "
]

[
  "sql" => " SELECT  count(*) as nbr  FROM structure_recherche "
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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"
]