Symfony Profiler

[
  "route" => "collection"
  "route_parameters" => [
    "_route" => "collection"
    "_controller" => "App\Controller\Notice\NoticeCollectionController::showNoticeCollection"
    "id" => "182"
  ]
  "request_uri" => "http://sips.univ-fcomte.fr/index.php/collection/182"
  "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.issn AS issn_3, t0.e_issn AS e_issn_4, t0.editeur_id AS editeur_id_5, t0.url_id AS url_id_6 FROM collections t0 WHERE t0.id = ?"
  "params" => [
    1 => 182
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#825
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.id_isbn AS id_isbn_4, t0.email AS email_5, t0.url_id AS url_id_6 FROM editeur t0 WHERE t0.id = ?"
  "params" => [
    1 => 81
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#825
      +name: "INTEGER"
    }
  ]
]

[
  "route" => "collection_update_list_doc"
  "route_parameters" => [
    "_route" => "collection_update_list_doc"
    "_controller" => "App\Controller\Notice\NoticeCollectionController::updateNoticeCollection"
    "id" => "182"
  ]
  "request_uri" => "http://localhost/collection/182/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
    \t'' AS roles, '' AS paratextes,\n
    \tregexp_replace(regexp_replace(LOWER(unaccent(d.titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate\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
    WHERE d.validation = 1 AND d.collection_id = ?\n
    GROUP BY d.id, date, type, editeur, collection, titre_formate\n
    ORDER BY titre_formate ASC, date DESC
    """
  "params" => [
    1 => 182
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1161
      +name: "STRING"
    }
  ]
]

[
  "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[3094,3083,2921,353,2388,3089,3078,535,351,2859], 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 (3094,3083,2921,353,2388,3089,3078,535,351,2859)\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 (3094,3083,2921,353,2388,3089,3078,535,351,2859)\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" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

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

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