Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

1.73 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.39 ms
(22.74%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.firstName AS firstName_5, t0.lastName AS lastName_6, t0.numeroId AS numeroId_7, t0.statut AS statut_8, t0.identifiantRfid AS identifiantRfid_9, t0.tempsPresenceTotal AS tempsPresenceTotal_10, t0.isVerified AS isVerified_11, t0.createdAt AS createdAt_12, t0.derniereConnexion AS derniereConnexion_13, t0.notificationEmail AS notificationEmail_14, t0.notificationPush AS notificationPush_15, t0.rappelReservation AS rappelReservation_16, t0.theme AS theme_17, t0.langue AS langue_18 FROM UTILISATEUR t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.firstName AS firstName_5,
  t0.lastName AS lastName_6,
  t0.numeroId AS numeroId_7,
  t0.statut AS statut_8,
  t0.identifiantRfid AS identifiantRfid_9,
  t0.tempsPresenceTotal AS tempsPresenceTotal_10,
  t0.isVerified AS isVerified_11,
  t0.createdAt AS createdAt_12,
  t0.derniereConnexion AS derniereConnexion_13,
  t0.notificationEmail AS notificationEmail_14,
  t0.notificationPush AS notificationPush_15,
  t0.rappelReservation AS rappelReservation_16,
  t0.theme AS theme_17,
  t0.langue AS langue_18
FROM
  UTILISATEUR t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.firstName AS firstName_5, t0.lastName AS lastName_6, t0.numeroId AS numeroId_7, t0.statut AS statut_8, t0.identifiantRfid AS identifiantRfid_9, t0.tempsPresenceTotal AS tempsPresenceTotal_10, t0.isVerified AS isVerified_11, t0.createdAt AS createdAt_12, t0.derniereConnexion AS derniereConnexion_13, t0.notificationEmail AS notificationEmail_14, t0.notificationPush AS notificationPush_15, t0.rappelReservation AS rappelReservation_16, t0.theme AS theme_17, t0.langue AS langue_18 FROM UTILISATEUR t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_9a145e1a6583b52e3a639aaa28cace13::doDisplay (line 1034)
6	Twig\Template->yield (line 411)
7	Twig\Template->display (line 366)
8	Twig\Template->render (line 381)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
14	App\Controller\SiteController->formationFollow (line 356)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
17	Symfony\Component\HttpKernel\Kernel->handle (line 143)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

0.34 ms
(19.85%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image AS image_4, t0.categorie AS categorie_5, t0.niveau AS niveau_6, t0.duree AS duree_7, t0.formateur AS formateur_8, t0.placesTotales AS placesTotales_9, t0.objectifs AS objectifs_10, t0.prerequis AS prerequis_11, t0.materielFourni AS materielFourni_12, t0.badgeId AS badgeId_13 FROM FORMATION t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.image AS image_4,
  t0.categorie AS categorie_5,
  t0.niveau AS niveau_6,
  t0.duree AS duree_7,
  t0.formateur AS formateur_8,
  t0.placesTotales AS placesTotales_9,
  t0.objectifs AS objectifs_10,
  t0.prerequis AS prerequis_11,
  t0.materielFourni AS materielFourni_12,
  t0.badgeId AS badgeId_13
FROM
  FORMATION t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image AS image_4, t0.categorie AS categorie_5, t0.niveau AS niveau_6, t0.duree AS duree_7, t0.formateur AS formateur_8, t0.placesTotales AS placesTotales_9, t0.objectifs AS objectifs_10, t0.prerequis AS prerequis_11, t0.materielFourni AS materielFourni_12, t0.badgeId AS badgeId_13 FROM FORMATION t0 WHERE t0.id = 1;

#	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\ServiceEntityRepository->find (line 66)
6	App\Controller\SiteController->formationFollow (line 339)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.31 ms
(18.06%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.icone AS icone_4, t0.createdAt AS createdAt_5 FROM BADGE t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.icone AS icone_4,
  t0.createdAt AS createdAt_5
FROM
  BADGE t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.icone AS icone_4, t0.createdAt AS createdAt_5 FROM BADGE t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_9a145e1a6583b52e3a639aaa28cace13::doDisplay (line 982)
6	Twig\Template->yield (line 411)
7	Twig\Template->display (line 366)
8	Twig\Template->render (line 381)
9	Twig\TemplateWrapper->render (line 51)
10	Twig\Environment->render (line 333)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
14	App\Controller\SiteController->formationFollow (line 356)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
17	Symfony\Component\HttpKernel\Kernel->handle (line 143)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

0.30 ms
(17.25%)

SELECT t0.id AS id_1, t0.score AS score_2, t0.completed AS completed_3, t0.dateDebut AS dateDebut_4, t0.dateEnd AS dateEnd_5, t0.userId AS userId_6, t0.formationId AS formationId_7 FROM PROGRESSION t0 WHERE t0.formationId = ? ORDER BY t0.dateDebut DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.score AS score_2,
  t0.completed AS completed_3,
  t0.dateDebut AS dateDebut_4,
  t0.dateEnd AS dateEnd_5,
  t0.userId AS userId_6,
  t0.formationId AS formationId_7
FROM
  PROGRESSION t0
WHERE
  t0.formationId = ?
ORDER BY
  t0.dateDebut DESC

SELECT t0.id AS id_1, t0.score AS score_2, t0.completed AS completed_3, t0.dateDebut AS dateDebut_4, t0.dateEnd AS dateEnd_5, t0.userId AS userId_6, t0.formationId AS formationId_7 FROM PROGRESSION t0 WHERE t0.formationId = 1 ORDER BY t0.dateDebut DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\SiteController->formationFollow (line 359)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.21 ms
(12.05%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.videoUrl AS videoUrl_4, t0.ordre AS ordre_5, t0.createdAt AS createdAt_6, t0.formationId AS formationId_7 FROM SECTION t0 WHERE t0.formationId = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.videoUrl AS videoUrl_4,
  t0.ordre AS ordre_5,
  t0.createdAt AS createdAt_6,
  t0.formationId AS formationId_7
FROM
  SECTION t0
WHERE
  t0.formationId = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.videoUrl AS videoUrl_4, t0.ordre AS ordre_5, t0.createdAt AS createdAt_6, t0.formationId AS formationId_7 FROM SECTION t0 WHERE t0.formationId = 1 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\SiteController->formationFollow (line 344)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.17 ms
(10.04%)

SELECT t0.id AS id_1, t0.noteMinimale AS noteMinimale_2, t0.formationId AS formationId_3, t0.sectionId AS sectionId_4 FROM QUIZ t0 WHERE t0.formationId = ? ORDER BY t0.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.noteMinimale AS noteMinimale_2,
  t0.formationId AS formationId_3,
  t0.sectionId AS sectionId_4
FROM
  QUIZ t0
WHERE
  t0.formationId = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.noteMinimale AS noteMinimale_2, t0.formationId AS formationId_3, t0.sectionId AS sectionId_4 FROM QUIZ t0 WHERE t0.formationId = 1 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\SiteController->formationFollow (line 345)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	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\Progression	2
App\Entity\Utilisateur	2
App\Entity\Formation	1
App\Entity\Badge	1

Entities Mapping

Class	Mapping errors
App\Entity\Formation	No errors.
App\Entity\Badge	No errors.
App\Entity\Section	No errors.
App\Entity\Quiz	No errors.
App\Entity\Progression	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\MachineBadge	No errors.
App\Entity\UtilisateurRole	No errors.

GET http://fabos.dstei.fr/formations/1/suivi

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping