Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.39 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.76 ms
(32.62%)

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.description AS description_2, f0_.niveau AS niveau_3, f0_.duree AS duree_4, f0_.prix AS prix_5, f0_.lien_inscription AS lien_inscription_6, f0_.statut AS statut_7, f0_.date_ajout AS date_ajout_8, f0_.ajoute_par AS ajoute_par_9, f0_.fournisseur_id AS fournisseur_id_10, f0_.categorie_id AS categorie_id_11, f0_.user_id AS user_id_12 FROM formation f0_ INNER JOIN categories c1_ ON f0_.categorie_id = c1_.id WHERE c1_.nom IN (NULL) LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.titre AS titre_1,
  f0_.description AS description_2,
  f0_.niveau AS niveau_3,
  f0_.duree AS duree_4,
  f0_.prix AS prix_5,
  f0_.lien_inscription AS lien_inscription_6,
  f0_.statut AS statut_7,
  f0_.date_ajout AS date_ajout_8,
  f0_.ajoute_par AS ajoute_par_9,
  f0_.fournisseur_id AS fournisseur_id_10,
  f0_.categorie_id AS categorie_id_11,
  f0_.user_id AS user_id_12
FROM
  formation f0_
  INNER JOIN categories c1_ ON f0_.categorie_id = c1_.id
WHERE
  c1_.nom IN (NULL)
LIMIT
  3

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.description AS description_2, f0_.niveau AS niveau_3, f0_.duree AS duree_4, f0_.prix AS prix_5, f0_.lien_inscription AS lien_inscription_6, f0_.statut AS statut_7, f0_.date_ajout AS date_ajout_8, f0_.ajoute_par AS ajoute_par_9, f0_.fournisseur_id AS fournisseur_id_10, f0_.categorie_id AS categorie_id_11, f0_.user_id AS user_id_12 FROM formation f0_ INNER JOIN categories c1_ ON f0_.categorie_id = c1_.id WHERE c1_.nom IN (NULL) LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 37)
7	App\Repository\FormationRepository->findCategoriesPhare (line 33)
8	App\Controller\Public\PublicFormationController->formations (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.74 ms
(32.21%)

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.description AS description_2, f0_.niveau AS niveau_3, f0_.duree AS duree_4, f0_.prix AS prix_5, f0_.lien_inscription AS lien_inscription_6, f0_.statut AS statut_7, f0_.date_ajout AS date_ajout_8, f0_.ajoute_par AS ajoute_par_9, f0_.fournisseur_id AS fournisseur_id_10, f0_.categorie_id AS categorie_id_11, f0_.user_id AS user_id_12 FROM formation f0_ ORDER BY f0_.date_ajout DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.titre AS titre_1,
  f0_.description AS description_2,
  f0_.niveau AS niveau_3,
  f0_.duree AS duree_4,
  f0_.prix AS prix_5,
  f0_.lien_inscription AS lien_inscription_6,
  f0_.statut AS statut_7,
  f0_.date_ajout AS date_ajout_8,
  f0_.ajoute_par AS ajoute_par_9,
  f0_.fournisseur_id AS fournisseur_id_10,
  f0_.categorie_id AS categorie_id_11,
  f0_.user_id AS user_id_12
FROM
  formation f0_
ORDER BY
  f0_.date_ajout DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.description AS description_2, f0_.niveau AS niveau_3, f0_.duree AS duree_4, f0_.prix AS prix_5, f0_.lien_inscription AS lien_inscription_6, f0_.statut AS statut_7, f0_.date_ajout AS date_ajout_8, f0_.ajoute_par AS ajoute_par_9, f0_.fournisseur_id AS fournisseur_id_10, f0_.categorie_id AS categorie_id_11, f0_.user_id AS user_id_12 FROM formation f0_ ORDER BY f0_.date_ajout DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 26)
7	App\Repository\FormationRepository->findLastFormation (line 31)
8	App\Controller\Public\PublicFormationController->formations (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.46 ms
(27.09%)

SELECT t0.id AS id_1, t0.categories_phares AS categories_phares_2 FROM parametre_generaux t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.categories_phares AS categories_phares_2
FROM
  parametre_generaux t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.categories_phares AS categories_phares_2 FROM parametre_generaux t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 27)
7	App\Controller\Public\PublicFormationController->formations (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.44 ms
(8.09%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.duree AS duree_5, t0.prix AS prix_6, t0.lien_inscription AS lien_inscription_7, t0.statut AS statut_8, t0.date_ajout AS date_ajout_9, t0.ajoute_par AS ajoute_par_10, t0.fournisseur_id AS fournisseur_id_11, t0.categorie_id AS categorie_id_12, t0.user_id AS user_id_13 FROM formation t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.niveau AS niveau_4,
  t0.duree AS duree_5,
  t0.prix AS prix_6,
  t0.lien_inscription AS lien_inscription_7,
  t0.statut AS statut_8,
  t0.date_ajout AS date_ajout_9,
  t0.ajoute_par AS ajoute_par_10,
  t0.fournisseur_id AS fournisseur_id_11,
  t0.categorie_id AS categorie_id_12,
  t0.user_id AS user_id_13
FROM
  formation t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.duree AS duree_5, t0.prix AS prix_6, t0.lien_inscription AS lien_inscription_7, t0.statut AS statut_8, t0.date_ajout AS date_ajout_9, t0.ajoute_par AS ajoute_par_10, t0.fournisseur_id AS fournisseur_id_11, t0.categorie_id AS categorie_id_12, t0.user_id AS user_id_13 FROM formation t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 45)
6	App\Controller\Public\PublicFormationController->formations (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\ParametreGeneraux	No errors.
App\Entity\Formation	No errors.
App\Entity\Fournisseur	No errors.
App\Entity\Categories	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET http://www.or4.fr/formation

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping