Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.22 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.55 ms
(24.94%)

SELECT n0_.id AS id_0, n0_.code AS code_1, n0_.ordre AS ordre_2 FROM niveau n0_ INNER JOIN semestre s1_ ON (s1_.niveau_id = n0_.id) INNER JOIN module m2_ ON (m2_.semestre_id = s1_.id) INNER JOIN cours c3_ ON (c3_.module_id = m2_.id AND c3_.statut = ?) AND (c3_.supprime_le IS NULL) GROUP BY n0_.id ORDER BY n0_.ordre ASC

Parameters:

[
  "publie"
]

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_
  INNER JOIN semestre s1_ ON (s1_.niveau_id = n0_.id)
  INNER JOIN module m2_ ON (m2_.semestre_id = s1_.id)
  INNER JOIN cours c3_ ON (
    c3_.module_id = m2_.id
    AND c3_.statut = ?
  )
  AND (c3_.supprime_le IS NULL)
GROUP BY
  n0_.id
ORDER BY
  n0_.ordre ASC

SELECT n0_.id AS id_0, n0_.code AS code_1, n0_.ordre AS ordre_2 FROM niveau n0_ INNER JOIN semestre s1_ ON (s1_.niveau_id = n0_.id) INNER JOIN module m2_ ON (m2_.semestre_id = s1_.id) INNER JOIN cours c3_ ON (c3_.module_id = m2_.id AND c3_.statut = 'publie') AND (c3_.supprime_le IS NULL) GROUP BY n0_.id 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->findAvecCoursPublies (line 49)
7	App\Controller\Front\CataloguePublicController->index (line 64)
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.48 ms
(23.82%)

SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.slug AS slug_2, c0_.resume AS resume_3, c0_.ordre AS ordre_4, c0_.statut AS statut_5, c0_.nombre_lectures AS nombre_lectures_6, c0_.contenu_recherche AS contenu_recherche_7, c0_.date_creation AS date_creation_8, c0_.date_maj AS date_maj_9, c0_.supprime_le AS supprime_le_10, m1_.id AS id_11, m1_.nom AS nom_12, m1_.langue AS langue_13, m1_.ordre AS ordre_14, s2_.id AS id_15, s2_.nom AS nom_16, s2_.ordre AS ordre_17, n3_.id AS id_18, n3_.code AS code_19, n3_.ordre AS ordre_20, f4_.id AS id_21, f4_.nom AS nom_22, f4_.ordre AS ordre_23, c0_.module_id AS module_id_24, m1_.semestre_id AS semestre_id_25, s2_.niveau_id AS niveau_id_26, s2_.filiere_id AS filiere_id_27, f4_.niveau_id AS niveau_id_28 FROM cours c0_ INNER JOIN module m1_ ON c0_.module_id = m1_.id INNER JOIN semestre s2_ ON m1_.semestre_id = s2_.id INNER JOIN niveau n3_ ON s2_.niveau_id = n3_.id LEFT JOIN filiere f4_ ON s2_.filiere_id = f4_.id WHERE (c0_.statut = ? AND n3_.id = ?) AND (c0_.supprime_le IS NULL) ORDER BY n3_.ordre ASC, s2_.ordre ASC, m1_.ordre ASC, c0_.ordre ASC, c0_.titre ASC

Parameters:

[
  "publie"
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.titre AS titre_1,
  c0_.slug AS slug_2,
  c0_.resume AS resume_3,
  c0_.ordre AS ordre_4,
  c0_.statut AS statut_5,
  c0_.nombre_lectures AS nombre_lectures_6,
  c0_.contenu_recherche AS contenu_recherche_7,
  c0_.date_creation AS date_creation_8,
  c0_.date_maj AS date_maj_9,
  c0_.supprime_le AS supprime_le_10,
  m1_.id AS id_11,
  m1_.nom AS nom_12,
  m1_.langue AS langue_13,
  m1_.ordre AS ordre_14,
  s2_.id AS id_15,
  s2_.nom AS nom_16,
  s2_.ordre AS ordre_17,
  n3_.id AS id_18,
  n3_.code AS code_19,
  n3_.ordre AS ordre_20,
  f4_.id AS id_21,
  f4_.nom AS nom_22,
  f4_.ordre AS ordre_23,
  c0_.module_id AS module_id_24,
  m1_.semestre_id AS semestre_id_25,
  s2_.niveau_id AS niveau_id_26,
  s2_.filiere_id AS filiere_id_27,
  f4_.niveau_id AS niveau_id_28
FROM
  cours c0_
  INNER JOIN module m1_ ON c0_.module_id = m1_.id
  INNER JOIN semestre s2_ ON m1_.semestre_id = s2_.id
  INNER JOIN niveau n3_ ON s2_.niveau_id = n3_.id
  LEFT JOIN filiere f4_ ON s2_.filiere_id = f4_.id
WHERE
  (
    c0_.statut = ?
    AND n3_.id = ?
  )
  AND (c0_.supprime_le IS NULL)
ORDER BY
  n3_.ordre ASC,
  s2_.ordre ASC,
  m1_.ordre ASC,
  c0_.ordre ASC,
  c0_.titre ASC

SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.slug AS slug_2, c0_.resume AS resume_3, c0_.ordre AS ordre_4, c0_.statut AS statut_5, c0_.nombre_lectures AS nombre_lectures_6, c0_.contenu_recherche AS contenu_recherche_7, c0_.date_creation AS date_creation_8, c0_.date_maj AS date_maj_9, c0_.supprime_le AS supprime_le_10, m1_.id AS id_11, m1_.nom AS nom_12, m1_.langue AS langue_13, m1_.ordre AS ordre_14, s2_.id AS id_15, s2_.nom AS nom_16, s2_.ordre AS ordre_17, n3_.id AS id_18, n3_.code AS code_19, n3_.ordre AS ordre_20, f4_.id AS id_21, f4_.nom AS nom_22, f4_.ordre AS ordre_23, c0_.module_id AS module_id_24, m1_.semestre_id AS semestre_id_25, s2_.niveau_id AS niveau_id_26, s2_.filiere_id AS filiere_id_27, f4_.niveau_id AS niveau_id_28 FROM cours c0_ INNER JOIN module m1_ ON c0_.module_id = m1_.id INNER JOIN semestre s2_ ON m1_.semestre_id = s2_.id INNER JOIN niveau n3_ ON s2_.niveau_id = n3_.id LEFT JOIN filiere f4_ ON s2_.filiere_id = f4_.id WHERE (c0_.statut = 'publie' AND n3_.id = 4) AND (c0_.supprime_le IS NULL) ORDER BY n3_.ordre ASC, s2_.ordre ASC, m1_.ordre ASC, c0_.ordre ASC, c0_.titre 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\CoursRepository->findPubliesPourCatalogue (line 180)
7	App\Controller\Front\CataloguePublicController->index (line 55)
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.09 ms
(17.60%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.ordre AS ordre_3 FROM niveau t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.ordre AS ordre_3
FROM
  niveau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.ordre AS ordre_3 FROM niveau t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\Front\CataloguePublicController->entiteFiltree (line 80)
7	App\Controller\Front\CataloguePublicController->index (line 44)
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.06 ms
(17.09%)

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.ordre AS ordre_2, f0_.niveau_id AS niveau_id_3 FROM filiere f0_ WHERE f0_.niveau_id = ? ORDER BY f0_.ordre ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.ordre AS ordre_2,
  f0_.niveau_id AS niveau_id_3
FROM
  filiere f0_
WHERE
  f0_.niveau_id = ?
ORDER BY
  f0_.ordre ASC

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.ordre AS ordre_2, f0_.niveau_id AS niveau_id_3 FROM filiere f0_ WHERE f0_.niveau_id = 4 ORDER BY f0_.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\FiliereRepository->findByNiveauOrdered (line 30)
7	App\Service\CascadeCatalogueService->resoudre (line 39)
8	App\Controller\Front\CataloguePublicController->index (line 43)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.03 ms
(16.55%)

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.ordre AS ordre_2, s0_.niveau_id AS niveau_id_3, s0_.filiere_id AS filiere_id_4 FROM semestre s0_ WHERE s0_.niveau_id = ? AND s0_.filiere_id IS NULL ORDER BY s0_.ordre ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.ordre AS ordre_2,
  s0_.niveau_id AS niveau_id_3,
  s0_.filiere_id AS filiere_id_4
FROM
  semestre s0_
WHERE
  s0_.niveau_id = ?
  AND s0_.filiere_id IS NULL
ORDER BY
  s0_.ordre ASC

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.ordre AS ordre_2, s0_.niveau_id AS niveau_id_3, s0_.filiere_id AS filiere_id_4 FROM semestre s0_ WHERE s0_.niveau_id = 4 AND s0_.filiere_id IS NULL ORDER BY s0_.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\SemestreRepository->findByNiveauSansFiliere (line 35)
7	App\Service\CascadeCatalogueService->resoudre (line 49)
8	App\Controller\Front\CataloguePublicController->index (line 43)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	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	3

Entities Mapping

Class	Mapping errors
App\Entity\Niveau	No errors.
App\Entity\Filiere	No errors.
App\Entity\Semestre	No errors.
App\Entity\Cours	No errors.
App\Entity\Module	No errors.

Symfony Profiler

GET https://www.droit.kesfood.com/catalogue?niveau=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping