Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

42.27 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.84 ms

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)

19.81 ms

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.53 ms

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.09 ms

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)

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping