Symfony Profiler

[
  "route" => "personne"
  "route_parameters" => [
    "_route" => "personne"
    "_controller" => "App\Controller\Notice\NoticePersonneController::showNoticePersonne"
    "id" => "1536"
  ]
  "request_uri" => "http://sips.univ-fcomte.fr/index.php/personne/1536"
  "method" => "GET"
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::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" => "MobileDetectBundle\EventListener\RequestResponseListener::handleRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container32C6Aq8\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_pgsql"
    "use_savepoints" => true
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "admin"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "philosciences"
    "serverVersion" => "13"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.annee_naissance AS annee_naissance_4, t0.annee_mort AS annee_mort_5, t0.fonction AS fonction_6, t0.commentaire AS commentaire_7, t0.url_id AS url_id_8 FROM personne t0 WHERE t0.id = ?"
  "params" => [
    1 => 1536
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#808
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.collection_id AS collection_id_1, t0.directeur_id AS directeur_id_2 FROM collection_directeur t0 WHERE t0.directeur_id = ?"
  "params" => [
    1 => 1536
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#808
      +name: "INTEGER"
    }
  ]
]

[
  "route" => "personne_update_list_doc"
  "route_parameters" => [
    "_route" => "personne_update_list_doc"
    "_controller" => "App\Controller\Notice\NoticePersonneController::updateNoticePersonne"
    "id" => "1536"
  ]
  "request_uri" => "http://localhost/personne/1536/update"
  "method" => "POST"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::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" => "MobileDetectBundle\EventListener\RequestResponseListener::handleRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container32C6Aq8\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => """
    SELECT DISTINCT\n
    \td.id,\n
    \tCASE WHEN d.annee IS NOT NULL AND d.annee <> 0 THEN d.annee ELSE d2.annee END AS date,\t\n
    \td.type_id AS type,\n
    \tSTRING_AGG(CAST(dl.langue_id AS VARCHAR),' ' ORDER BY dl.langue_id ASC) AS langues,\n
    \td.editeur_id AS editeur,\n
    \td.collection_id AS collection,\n
    \tregexp_replace(regexp_replace(LOWER(unaccent(d.titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate,\n
    \troles, paratextes\n
    FROM document d\n
    LEFT JOIN document_langue dl ON d.id = dl.document_id\n
    LEFT JOIN infos_element el ON d.infos_element_id = el.id\n
    LEFT JOIN document d2 ON el.doc_hote_id = d2.id\n
    LEFT JOIN (SELECT aut.document_id, STRING_AGG(CAST(aut.role_id AS VARCHAR), ' ' ORDER BY aut.role_id ASC) AS roles\n
        FROM document_autorite aut\n
        WHERE aut.personne_id = ?\n
        GROUP BY aut.document_id\n
    ) aut_roles ON d.id = aut_roles.document_id\n
    LEFT JOIN (SELECT para.document_id, STRING_AGG(CAST(para.paratexte_id AS VARCHAR), ' ' ORDER BY para.paratexte_id ASC) AS paratextes\n
        FROM document_paratexte para\n
        WHERE para.personne_id = ?\n
        GROUP BY para.document_id\n
    ) para_paratextes ON d.id = para_paratextes.document_id\n
    WHERE d.validation = 1 AND aut_roles.document_id IS NOT NULL OR para_paratextes.document_id IS NOT NULL\n
    GROUP BY d.id, date, type, editeur, collection, titre_formate, roles, paratextes\n
    ORDER BY titre_formate ASC, date DESC
    """
  "params" => [
    1 => 1536
    2 => 1536
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1157
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1157}
  ]
]

[
  "sql" => """
    SELECT id, libelle_fr, libelle_en, -1 AS count, false as checked\n
    FROM langue\n
    ORDER BY id
    """
]

[
  "sql" => """
    SELECT id, libelle_fr, libelle_en, -1 AS count, false as checked\n
    FROM type\n
    ORDER BY id
    """
]

[
  "sql" => """
    SELECT id, libelle_fr, libelle_en, -1 AS count, false as checked\n
    FROM role\n
    ORDER BY id
    """
]

[
  "sql" => """
    SELECT id, libelle_fr, libelle_en, -1 AS count, false as checked\n
    FROM paratexte\n
    ORDER BY id
    """
]

[
  "sql" => """
    SELECT DISTINCT id, titre, comp_titre, type, fascicule, cahier, volume, tome,\n
    \ttitre_formate, date, editeur, collection,\n
    \tid_hote, titre_hote, volume_hote, tome_hote, fascicule_hote, cahier_hote,\n
    \tdiscipline_fr, discipline_en, type_these, directeur, codirecteur,\n
    \tSTRING_AGG(CAST(langue AS VARCHAR), ' ') as langue_id, pos\n
    FROM (\n
    \tSELECT d.id, d.titre, d.comp_titre, d.type_id AS type, d.fascicule, d.cahier, d.volume, d.tome, \n
    \tregexp_replace(regexp_replace(LOWER(unaccent(d.titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate,\n
    \tCASE WHEN d.annee IS NOT NULL AND d.annee <> 0 THEN d.annee ELSE d2.annee END AS date,\n
    \t-- EDITEUR ET COLLECTION --\n
    \te.nom AS editeur, c.nom AS collection, \n
    \t-- INFOS ELEMENT --\n
    \td2.id AS id_hote, \n
    \tCASE WHEN d2.id is not NULL THEN d2.titre ELSE NULL END AS titre_hote,\n
    \tCASE WHEN d2.id is not NULL THEN d2.volume ELSE NULL END AS volume_hote,\n
    \tCASE WHEN d2.id is not NULL THEN d2.tome ELSE NULL END AS tome_hote,\n
    \tCASE WHEN d2.id is not NULL THEN d2.fascicule ELSE NULL END AS fascicule_hote,\n
    \tCASE WHEN d2.id is not NULL THEN d2.cahier ELSE NULL END AS cahier_hote,\n
    \t-- INFOS THESE --\n
    \tth.discipline_fr, th.discipline_en, th.type_these, CONCAT(p1.prenom,' ',p1.nom) AS directeur, STRING_AGG(CONCAT(p2.prenom,' ',p2.nom), ', ') AS codirecteur,\n
    \tSTRING_AGG(CAST(dl.langue_id AS VARCHAR), ' ') as langue,\n
    \tARRAY_POSITION(ARRAY[2390,1971,2169], d.id) AS pos\n
    \tFROM document d\n
    \tLEFT JOIN editeur e ON d.editeur_id = e.id\n
    \tLEFT JOIN collections c ON d.collection_id = c.id\n
    \tLEFT JOIN infos_element el ON d.infos_element_id = el.id\n
    \tLEFT JOIN document d2 ON el.doc_hote_id = d2.id\n
    \tLEFT JOIN infos_these th ON d.infos_these_id = th.id\n
    \tLEFT JOIN personne p1 ON th.directeur_id = p1.id\n
    \tLEFT JOIN codirection_these cdt ON th.id = cdt.these_id\n
    \tLEFT JOIN personne p2 ON cdt.codirecteur_id = p2.id\n
    \tLEFT JOIN document_langue dl on d.id = dl.document_id \n
    \tWHERE d.validation = 1\n
    \tAND d.id IN (2390,1971,2169)\n
    \tGROUP BY d.id, d.titre, d.comp_titre, d.type_id, d.fascicule, d.cahier, d.volume, d.tome, titre_formate,\n
    \t\tdate, editeur, collection, id_hote, titre_hote, volume_hote, tome_hote, fascicule_hote, cahier_hote,\n
    \t\tth.discipline_fr, th.discipline_en, th.type_these, directeur, pos, langue_id\n
    ) AS req\n
    group by id, titre, comp_titre, type, fascicule, cahier, volume, tome,\n
    \ttitre_formate, date, editeur, collection, id_hote, titre_hote, volume_hote,\n
    \ttome_hote, fascicule_hote, cahier_hote, discipline_fr, discipline_en,\n
    \ttype_these, directeur, codirecteur, pos\n
    ORDER BY pos
    """
]

[
  "sql" => """
    SELECT document_id, STRING_AGG(CONCAT(p.prenom,' ',p.nom), ', ' ORDER BY aut.rang) as identite\n
    FROM document_autorite aut\n
    INNER JOIN personne p ON aut.personne_id = p.id\n
    INNER JOIN document d ON aut.document_id = d.id\n
    WHERE aut.document_id IN (2390,1971,2169)\n
    AND ( (d.type_id IN (1,2,4,6,8) AND aut.role_id = 1)\n
    \tOR (d.type_id IN (3,7) AND aut.role_id = 2))\n
    GROUP BY document_id
    """
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "MobileDetectBundle\EventListener\RequestResponseListener::handleResponse"
]

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

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "MobileDetectBundle\EventListener\RequestResponseListener::handleResponse"
]

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