Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

4.04 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.01 ms
(25.12%)

SELECT t0.id AS id_1, t0.numero_reservation AS numero_reservation_2, t0.date_debut_custom AS date_debut_custom_3, t0.date_fin_custom AS date_fin_custom_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.formation_id AS formation_id_7, t0.user_id AS user_id_8, t0.plage_formation_id AS plage_formation_id_9 FROM reserve_formation t0 WHERE t0.plage_formation_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_reservation AS numero_reservation_2,
  t0.date_debut_custom AS date_debut_custom_3,
  t0.date_fin_custom AS date_fin_custom_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.formation_id AS formation_id_7,
  t0.user_id AS user_id_8,
  t0.plage_formation_id AS plage_formation_id_9
FROM
  reserve_formation t0
WHERE
  t0.plage_formation_id = ?

SELECT t0.id AS id_1, t0.numero_reservation AS numero_reservation_2, t0.date_debut_custom AS date_debut_custom_3, t0.date_fin_custom AS date_fin_custom_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.formation_id AS formation_id_7, t0.user_id AS user_id_8, t0.plage_formation_id AS plage_formation_id_9 FROM reserve_formation t0 WHERE t0.plage_formation_id = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1230)
9	Twig\Extension\CoreExtension::length (line 806)
10	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->block_body (line 431)
11	Twig\Template->yieldBlock (line 135)
12	__TwigTemplate_caead8920c2e556b991ba69b5abe52cb->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
23	App\Controller\HomeController->detail_formation (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.88 ms
(21.80%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.formation_id AS formation_id_3
FROM
  topic t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.formation_id AS formation_id_3 FROM topic t0 WHERE t0.formation_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1230)
9	Twig\Extension\CoreExtension::length (line 498)
10	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->block_body (line 431)
11	Twig\Template->yieldBlock (line 135)
12	__TwigTemplate_caead8920c2e556b991ba69b5abe52cb->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
23	App\Controller\HomeController->detail_formation (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.83 ms
(20.62%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Apprendre-l-anglais-facilement"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.content AS content_3,
  t0.image AS image_4,
  t0.price AS price_5,
  t0.duree AS duree_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.slug AS slug_9,
  t0.user_id AS user_id_10
FROM
  formation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.content AS content_3, t0.image AS image_4, t0.price AS price_5, t0.duree AS duree_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.user_id AS user_id_10 FROM formation t0 WHERE t0.slug = 'Apprendre-l-anglais-facilement' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 110)
5	App\Controller\HomeController->detail_formation (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.67 ms
(16.70%)

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.bio AS bio_10, t0.avatar AS avatar_11, t0.is_agree AS is_agree_12, t0.expertise AS expertise_13, t0.profession AS profession_14, t0.last_diplome AS last_diplome_15, t0.other_formation AS other_formation_16, t0.date_naissance AS date_naissance_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.email AS email_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.bio AS bio_10,
  t0.avatar AS avatar_11,
  t0.is_agree AS is_agree_12,
  t0.expertise AS expertise_13,
  t0.profession AS profession_14,
  t0.last_diplome AS last_diplome_15,
  t0.other_formation AS other_formation_16,
  t0.date_naissance AS date_naissance_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.bio AS bio_10, t0.avatar AS avatar_11, t0.is_agree AS is_agree_12, t0.expertise AS expertise_13, t0.profession AS profession_14, t0.last_diplome AS last_diplome_15, t0.other_formation AS other_formation_16, t0.date_naissance AS date_naissance_17 FROM user t0 WHERE t0.id = 5;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\User->__get (line 180)
8	App\Entity\User->getNom (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 527)
10	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->block_body (line 431)
11	Twig\Template->yieldBlock (line 135)
12	__TwigTemplate_caead8920c2e556b991ba69b5abe52cb->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
23	App\Controller\HomeController->detail_formation (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.64 ms
(15.75%)

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.place AS place_4, t0.formation_id AS formation_id_5 FROM plage_formation t0 WHERE t0.formation_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.place AS place_4,
  t0.formation_id AS formation_id_5
FROM
  plage_formation t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.place AS place_4, t0.formation_id AS formation_id_5 FROM plage_formation t0 WHERE t0.formation_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 787)
8	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->block_body (line 431)
9	Twig\Template->yieldBlock (line 135)
10	__TwigTemplate_caead8920c2e556b991ba69b5abe52cb->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_009ac8d4e3647b94e716046e27d68fcb->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
21	App\Controller\HomeController->detail_formation (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Formation	No errors.
App\Entity\User	No errors.
App\Entity\Category	No errors.
App\Entity\Topic	No errors.
App\Entity\Review	No errors.
App\Entity\PlageFormation	No errors.
App\Entity\ReserveFormation	No errors.

Symfony Profiler

GET https://training.prixkdo.com/formations/Apprendre-l-anglais-facilement

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping