Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

46.43 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.60 ms
(44.38%)

SELECT DISTINCT titre,
    regexp_replace(regexp_replace(LOWER(unaccent(titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate
FROM document
ORDER BY titre_formate ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT titre,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(titre)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS titre_formate
FROM
  document
ORDER BY
  titre_formate ASC

SELECT DISTINCT titre,
    regexp_replace(regexp_replace(LOWER(unaccent(titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate
FROM document
ORDER BY titre_formate ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 39)
2	App\Repository\DocumentRepository->getAllForOptionTri (line 242)
3	App\Service\CacheManagement::getCacheDataTitre (line 171)
4	App\Service\CacheManagement::getCacheDateSearchBar (line 40)
5	App\Controller\Autre\AccueilController->showHomePage (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

9.50 ms
(20.47%)

SELECT
id,
CONCAT(prenom,' ',nom) AS identite,
regexp_replace(regexp_replace(LOWER(unaccent(CONCAT(prenom,' ',nom))), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS identite_formate
FROM personne
ORDER BY nom ASC, prenom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  CONCAT(prenom, ' ', nom) AS identite,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(
          CONCAT(prenom, ' ', nom)
        )
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS identite_formate
FROM
  personne
ORDER BY
  nom ASC,
  prenom ASC

SELECT
id,
CONCAT(prenom,' ',nom) AS identite,
regexp_replace(regexp_replace(LOWER(unaccent(CONCAT(prenom,' ',nom))), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS identite_formate
FROM personne
ORDER BY nom ASC, prenom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 40)
2	App\Repository\PersonneRepository->getAllForOptionTri (line 278)
3	App\Service\CacheManagement::getCacheDataPersonne (line 172)
4	App\Service\CacheManagement::getCacheDateSearchBar (line 40)
5	App\Controller\Autre\AccueilController->showHomePage (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

7.05 ms
(15.18%)

SELECT 
id,
libelle_fr,
libelle_en,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_fr)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_fr_formate,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_en)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_en_formate
FROM mot_cle
ORDER BY libelle_fr_formate

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  libelle_fr,
  libelle_en,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(libelle_fr)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS libelle_fr_formate,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(libelle_en)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS libelle_en_formate
FROM
  mot_cle
ORDER BY
  libelle_fr_formate

SELECT 
id,
libelle_fr,
libelle_en,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_fr)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_fr_formate,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_en)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_en_formate
FROM mot_cle
ORDER BY libelle_fr_formate;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 42)
2	App\Repository\MotCleRepository->getAllForOptionTri (line 429)
3	App\Service\CacheManagement::getCacheDataMotCle (line 41)
4	App\Controller\Autre\AccueilController->showHomePage (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

5.82 ms
(12.53%)

SELECT mc.id, mc.libelle_fr, mc.libelle_en, (
    SELECT COUNT(dmc.motcle_id)
    FROM document_mot_cle dmc
    WHERE dmc.motcle_id = mc.id) AS count
FROM mot_cle mc
ORDER BY count DESC
LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  mc.id,
  mc.libelle_fr,
  mc.libelle_en,
  (
    SELECT
      COUNT(dmc.motcle_id)
    FROM
      document_mot_cle dmc
    WHERE
      dmc.motcle_id = mc.id
  ) AS count
FROM
  mot_cle mc
ORDER BY
  count DESC
LIMIT
  50

SELECT mc.id, mc.libelle_fr, mc.libelle_en, (
    SELECT COUNT(dmc.motcle_id)
    FROM document_mot_cle dmc
    WHERE dmc.motcle_id = mc.id) AS count
FROM mot_cle mc
ORDER BY count DESC
LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 62)
2	App\Repository\MotCleRepository->findTop50MotCle (line 462)
3	App\Service\CacheManagement::getCacheDataMotTop50 (line 112)
4	App\Service\AbecedaireFonctions::getListMotCle (line 77)
5	App\Service\AbecedaireFonctions::getDynamicPageElements (line 83)
6	App\Controller\Abecedaire\AbecedaireController->rechercheUpdate (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 36)
9	App\Controller\Autre\AccueilController->showHomePage (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.91 ms
(4.12%)

SELECT
id,
nom,
regexp_replace(regexp_replace(LOWER(unaccent(nom)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS nom_formate,
editeur_id,
-1 AS count, false AS checked
FROM collections
ORDER BY nom

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  nom,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(nom)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS nom_formate,
  editeur_id,
  -1 AS count,
  false AS checked
FROM
  collections
ORDER BY
  nom

SELECT
id,
nom,
regexp_replace(regexp_replace(LOWER(unaccent(nom)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS nom_formate,
editeur_id,
-1 AS count, false AS checked
FROM collections
ORDER BY nom;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 45)
2	App\Repository\CollectionsRepository->getAllForOptionTri (line 350)
3	App\Service\CacheManagement::getCacheDataCollection (line 174)
4	App\Service\CacheManagement::getCacheDateSearchBar (line 40)
5	App\Controller\Autre\AccueilController->showHomePage (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.54 ms
(3.33%)

SELECT
id,
nom,
regexp_replace(regexp_replace(LOWER(unaccent(nom)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS nom_formate,
-1 AS count, false AS checked
FROM editeur
ORDER BY nom

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  nom,
  regexp_replace(
    regexp_replace(
      LOWER(
        unaccent(nom)
      ),
      '[[:punct:]]',
      '',
      'g'
    ),
    '^\s+',
    '',
    'g'
  ) AS nom_formate,
  -1 AS count,
  false AS checked
FROM
  editeur
ORDER BY
  nom

SELECT
id,
nom,
regexp_replace(regexp_replace(LOWER(unaccent(nom)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS nom_formate,
-1 AS count, false AS checked
FROM editeur
ORDER BY nom;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 43)
2	App\Repository\EditeurRepository->getAllForOptionTri (line 314)
3	App\Service\CacheManagement::getCacheDataEditeur (line 173)
4	App\Service\CacheManagement::getCacheDateSearchBar (line 40)
5	App\Controller\Autre\AccueilController->showHomePage (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\MotCle	No errors.
App\Entity\Document	No errors.
App\Entity\Personne	No errors.
App\Entity\Editeur	No errors.
App\Entity\Collections	No errors.

Symfony Profiler

GET http://sips.univ-fcomte.fr/index.php/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping