Symfony Profiler

[
  "route" => "personne_update_list_doc"
  "route_parameters" => [
    "_route" => "personne_update_list_doc"
    "_controller" => "App\Controller\Notice\NoticePersonneController::updateNoticePersonne"
    "id" => "2359"
  ]
  "request_uri" => "http://localhost/personne/2359/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 => 2359
    2 => 2359
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1157
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1157}
  ]
]

[
  "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[2775], 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 (2775)\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 (2775)\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" => "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"
]