Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.88 ms Query time

0 Invalid entities

12 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.20 ms

SELECT u0_.id AS id_0, u0_.nom AS nom_1, u0_.actif AS actif_2 FROM universite u0_ WHERE u0_.actif = 1 ORDER BY u0_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.nom AS nom_1,
  u0_.actif AS actif_2
FROM
  universite u0_
WHERE
  u0_.actif = 1
ORDER BY
  u0_.nom ASC

SELECT u0_.id AS id_0, u0_.nom AS nom_1, u0_.actif AS actif_2 FROM universite u0_ WHERE u0_.actif = 1 ORDER BY u0_.nom 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\UniversiteRepository->findActives (line 28)
7	App\Controller\Front\ClassementPublicController->index (line 56)
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.67 ms

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.ordre AS ordre_2, n1_.id AS id_3, n1_.code AS code_4, n1_.ordre AS ordre_5, f0_.niveau_id AS niveau_id_6 FROM filiere f0_ INNER JOIN niveau n1_ ON f0_.niveau_id = n1_.id ORDER BY n1_.ordre ASC, f0_.ordre ASC

Parameters:

[]

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,
  n1_.id AS id_3,
  n1_.code AS code_4,
  n1_.ordre AS ordre_5,
  f0_.niveau_id AS niveau_id_6
FROM
  filiere f0_
  INNER JOIN niveau n1_ ON f0_.niveau_id = n1_.id
ORDER BY
  n1_.ordre ASC,
  f0_.ordre ASC

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.ordre AS ordre_2, n1_.id AS id_3, n1_.code AS code_4, n1_.ordre AS ordre_5, f0_.niveau_id AS niveau_id_6 FROM filiere f0_ INNER JOIN niveau n1_ ON f0_.niveau_id = n1_.id ORDER BY n1_.ordre ASC, 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->findAllOrdered (line 60)
7	App\Controller\Front\ClassementPublicController->index (line 58)
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)

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\Universite	10
App\Entity\Filiere	1
App\Entity\Niveau	1

Entities Mapping

Class	Mapping errors
App\Entity\Universite	No errors.
App\Entity\Filiere	No errors.
App\Entity\Niveau	No errors.

Symfony Profiler

GET https://www.droit.kesfood.com/classement

Configuration Settings

Theme

Page Width