Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

9.50 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.04 ms
(32.06%)

WITH classement AS (
    SELECT u.id, CASE WHEN u.classement_public = 1 THEN u.pseudo_public END AS pseudoPublic, u.score_total AS scoreTotal,
           RANK() OVER (ORDER BY u.score_total DESC) AS rang
    FROM `user` u
    WHERE EXISTS (
        SELECT 1 FROM passage_qcm pq
        WHERE pq.user_id = u.id AND pq.statut = 'soumis'
    )
     AND u.supprime_le IS NULL
)
SELECT rang, pseudoPublic, scoreTotal
FROM classement
ORDER BY rang ASC
LIMIT ?

Parameters:

[
  50
]

View formatted query View runnable query Explain query View query backtrace

WITH
  classement AS (
    SELECT
      u.id,
      CASE WHEN u.classement_public = 1 THEN
        u.pseudo_public
      END AS pseudoPublic,
      u.score_total AS scoreTotal,
      RANK() OVER (
        ORDER BY
          u.score_total DESC
      ) AS rang
    FROM
      `user` u
    WHERE
      EXISTS (
        SELECT
          1
        FROM
          passage_qcm pq
        WHERE
          pq.user_id = u.id
          AND pq.statut = 'soumis'
      )
      AND u.supprime_le IS NULL
  )
SELECT
  rang,
  pseudoPublic,
  scoreTotal
FROM
  classement
ORDER BY
  rang ASC
LIMIT
  ?

WITH classement AS (
    SELECT u.id, CASE WHEN u.classement_public = 1 THEN u.pseudo_public END AS pseudoPublic, u.score_total AS scoreTotal,
           RANK() OVER (ORDER BY u.score_total DESC) AS rang
    FROM `user` u
    WHERE EXISTS (
        SELECT 1 FROM passage_qcm pq
        WHERE pq.user_id = u.id AND pq.statut = 'soumis'
    )
     AND u.supprime_le IS NULL
)
SELECT rang, pseudoPublic, scoreTotal
FROM classement
ORDER BY rang ASC
LIMIT 50;

#	File/Call
1	App\Repository\UserRepository->topClassement (line 228)
2	App\Service\ClassementService->pourFiltre (line 45)
3	App\Service\ClassementService->App\Service\{closure} (line 77)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
5	Symfony\Component\Cache\LockRegistry::compute (line 113)
6	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
11	App\Service\ClassementService->pourFiltrePublic (line 75)
12	App\Controller\Front\HomeController->index (line 20)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

2.02 ms
(21.23%)

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.date_maj AS date_maj_4 FROM parametre_systeme t0 WHERE t0.cle = ? LIMIT 1

Parameters:

[
  "prix_module"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cle AS cle_2,
  t0.valeur AS valeur_3,
  t0.date_maj AS date_maj_4
FROM
  parametre_systeme t0
WHERE
  t0.cle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.date_maj AS date_maj_4 FROM parametre_systeme t0 WHERE t0.cle = 'prix_module' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\ParametreSystemeRepository->getValeur (line 21)
5	App\Service\PricingService->getEntier (line 110)
6	App\Service\PricingService->getPrixModule (line 27)
7	App\Controller\Front\HomeController->index (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.51 ms
(15.89%)

SELECT n0_.id AS id_0, n0_.code AS code_1, n0_.ordre AS ordre_2 FROM niveau n0_ ORDER BY n0_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.code AS code_1,
  n0_.ordre AS ordre_2
FROM
  niveau n0_
ORDER BY
  n0_.ordre ASC

SELECT n0_.id AS id_0, n0_.code AS code_1, n0_.ordre AS ordre_2 FROM niveau n0_ ORDER BY n0_.ordre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\NiveauRepository->findAllOrdered (line 29)
7	App\Controller\Front\HomeController->index (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.10 ms
(11.57%)

SELECT COUNT(DISTINCT u.universite_id)
FROM `user` u
WHERE u.universite_id IS NOT NULL
  AND u.supprime_le IS NULL
  AND EXISTS (
    SELECT 1 FROM passage_qcm pq
    WHERE pq.user_id = u.id AND pq.statut = 'soumis'
  )

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT u.universite_id)
FROM
  `user` u
WHERE
  u.universite_id IS NOT NULL
  AND u.supprime_le IS NULL
  AND EXISTS (
    SELECT
      1
    FROM
      passage_qcm pq
    WHERE
      pq.user_id = u.id
      AND pq.statut = 'soumis'
  )

SELECT COUNT(DISTINCT u.universite_id)
FROM `user` u
WHERE u.universite_id IS NOT NULL
  AND u.supprime_le IS NULL
  AND EXISTS (
    SELECT 1 FROM passage_qcm pq
    WHERE pq.user_id = u.id AND pq.statut = 'soumis'
  );

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 330)
2	App\Repository\UserRepository->compterUniversitesRepresentees (line 320)
3	App\Service\ClassementService->App\Service\{closure} (line 95)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
5	Symfony\Component\Cache\LockRegistry::compute (line 113)
6	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
11	App\Service\ClassementService->statistiquesPubliques (line 90)
12	App\Controller\Front\HomeController->index (line 26)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.99 ms
(10.40%)

SELECT COUNT(p0_.id) AS sclr_0 FROM passage_qcm p0_ WHERE p0_.statut = ?

Parameters:

[
  "soumis"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  passage_qcm p0_
WHERE
  p0_.statut = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM passage_qcm p0_ WHERE p0_.statut = 'soumis';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\PassageQcmRepository->compterPassagesSoumis (line 166)
8	App\Service\ClassementService->App\Service\{closure} (line 94)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
10	Symfony\Component\Cache\LockRegistry::compute (line 113)
11	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
16	App\Service\ClassementService->statistiquesPubliques (line 90)
17	App\Controller\Front\HomeController->index (line 26)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

0.84 ms
(8.85%)

SELECT COUNT(*)
FROM `user` u
WHERE u.supprime_le IS NULL
  AND EXISTS (
    SELECT 1 FROM passage_qcm pq
    WHERE pq.user_id = u.id AND pq.statut = 'soumis'
)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  `user` u
WHERE
  u.supprime_le IS NULL
  AND EXISTS (
    SELECT
      1
    FROM
      passage_qcm pq
    WHERE
      pq.user_id = u.id
      AND pq.statut = 'soumis'
  )

SELECT COUNT(*)
FROM `user` u
WHERE u.supprime_le IS NULL
  AND EXISTS (
    SELECT 1 FROM passage_qcm pq
    WHERE pq.user_id = u.id AND pq.statut = 'soumis'
);

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 330)
2	App\Repository\UserRepository->compterEtudiantsClasses (line 301)
3	App\Service\ClassementService->App\Service\{closure} (line 93)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
5	Symfony\Component\Cache\LockRegistry::compute (line 113)
6	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
11	App\Service\ClassementService->statistiquesPubliques (line 90)
12	App\Controller\Front\HomeController->index (line 26)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Niveau	5
App\Entity\ParametreSysteme	2

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ParametreSysteme	No errors.
App\Entity\PassageQcm	No errors.
App\Entity\Niveau	No errors.

Symfony Profiler

GET https://droit.kesfood.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping