Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

2.99 ms Query time

0 Invalid entities

126 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.63 ms
(21.17%)

SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.date_pointage AS date_pointage_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.groupe_id AS groupe_id_5,
  s0_.concours_id AS concours_id_6,
  s0_.agent_saisie_id AS agent_saisie_id_7
FROM
  session_pointage s0_
  LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id
  LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id
  LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id
  LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id
WHERE
  s0_.deleted_at IS NULL
GROUP BY
  s0_.id
ORDER BY
  s0_.date_pointage DESC,
  g1_.nom ASC

SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.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\SessionPointageRepository->findByCriteria (line 75)
7	App\Controller\DashboardController->index (line 32)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.57 ms
(19.19%)

SELECT t0.id AS id_1, t0.statut AS statut_2, t0.observation AS observation_3, t0.ancienne_valeur AS ancienne_valeur_4, t0.date_correction AS date_correction_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.session_pointage_id AS session_pointage_id_8, t0.eleve_id AS eleve_id_9, t0.agent_correcteur_id AS agent_correcteur_id_10 FROM ligne_presence t0 WHERE t0.session_pointage_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.statut AS statut_2,
  t0.observation AS observation_3,
  t0.ancienne_valeur AS ancienne_valeur_4,
  t0.date_correction AS date_correction_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.session_pointage_id AS session_pointage_id_8,
  t0.eleve_id AS eleve_id_9,
  t0.agent_correcteur_id AS agent_correcteur_id_10
FROM
  ligne_presence t0
WHERE
  t0.session_pointage_id = ?

SELECT t0.id AS id_1, t0.statut AS statut_2, t0.observation AS observation_3, t0.ancienne_valeur AS ancienne_valeur_4, t0.date_correction AS date_correction_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.session_pointage_id AS session_pointage_id_8, t0.eleve_id AS eleve_id_9, t0.agent_correcteur_id AS agent_correcteur_id_10 FROM ligne_presence t0 WHERE t0.session_pointage_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\SessionPointage->getNombrePresents (line 135)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b5a806d9da6af6716383e06408547dba::block_body (line 597)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_497b98872777cf35b270634f67f90942->doDisplay (line 703)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b5a806d9da6af6716383e06408547dba->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\DashboardController->index (line 48)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.53 ms
(17.68%)

SELECT COUNT(*) FROM observation_suivi t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL

Parameters:

[
  "ouvert"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  observation_suivi t0
WHERE
  t0.statut = ?
  AND t0.deleted_at IS NULL

SELECT COUNT(*) FROM observation_suivi t0 WHERE t0.statut = 'ouvert' AND t0.deleted_at IS NULL;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Controller\DashboardController->index (line 36)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.48 ms
(16.08%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.code AS code_4, t0.effectif_max AS effectif_max_5, t0.active AS active_6, t0.salle AS salle_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.referent_id AS referent_id_11, t0.classe_id AS classe_id_12 FROM groupe 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.code AS code_4,
  t0.effectif_max AS effectif_max_5,
  t0.active AS active_6,
  t0.salle AS salle_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.referent_id AS referent_id_11,
  t0.classe_id AS classe_id_12
FROM
  groupe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.code AS code_4, t0.effectif_max AS effectif_max_5, t0.active AS active_6, t0.salle AS salle_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.referent_id AS referent_id_11, t0.classe_id AS classe_id_12 FROM groupe 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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Groupe::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Groupe->__get (line 153)
7	App\Entity\Groupe->getNom (line 70)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b5a806d9da6af6716383e06408547dba::block_body (line 591)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_497b98872777cf35b270634f67f90942->doDisplay (line 703)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b5a806d9da6af6716383e06408547dba->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\DashboardController->index (line 48)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.44 ms
(14.71%)

SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL AND s0_.date_pointage >= ? AND s0_.date_pointage <= ? GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.nom ASC

Parameters:

[
  "2026-05-01"
  "2026-05-31"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.date_pointage AS date_pointage_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.groupe_id AS groupe_id_5,
  s0_.concours_id AS concours_id_6,
  s0_.agent_saisie_id AS agent_saisie_id_7
FROM
  session_pointage s0_
  LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id
  LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id
  LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id
  LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id
WHERE
  s0_.deleted_at IS NULL
  AND s0_.date_pointage >= ?
  AND s0_.date_pointage <= ?
GROUP BY
  s0_.id
ORDER BY
  s0_.date_pointage DESC,
  g1_.nom ASC

SELECT s0_.id AS id_0, s0_.date_pointage AS date_pointage_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.groupe_id AS groupe_id_5, s0_.concours_id AS concours_id_6, s0_.agent_saisie_id AS agent_saisie_id_7 FROM session_pointage s0_ LEFT JOIN groupe g1_ ON s0_.groupe_id = g1_.id LEFT JOIN concours c2_ ON s0_.concours_id = c2_.id LEFT JOIN `user` u3_ ON s0_.agent_saisie_id = u3_.id LEFT JOIN ligne_presence l4_ ON s0_.id = l4_.session_pointage_id WHERE s0_.deleted_at IS NULL AND s0_.date_pointage >= '2026-05-01' AND s0_.date_pointage <= '2026-05-31' GROUP BY s0_.id ORDER BY s0_.date_pointage DESC, g1_.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\SessionPointageRepository->findByCriteria (line 75)
7	App\Controller\DashboardController->index (line 46)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.33 ms
(11.16%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone AS phone_8,
  t0.last_login_at AS last_login_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM `user` t0 WHERE t0.id = 6;

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	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\LignePresence	58
App\Entity\Eleve	58
App\Entity\User	2
App\Entity\SessionPointage	2
App\Entity\Groupe	2
App\Entity\Concours	2
App\Entity\Classe	2

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\SessionPointage	No errors.
App\Entity\Groupe	No errors.
App\Entity\Concours	No errors.
App\Entity\LignePresence	No errors.
App\Entity\ObservationSuivi	No errors.
App\Entity\Classe	No errors.
App\Entity\Eleve	No errors.
App\Entity\Inscription	No errors.

Symfony Profiler

GET https://admin.dieng-consulting.com/dashboard

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping