Symfony Profiler

Query Metrics

18 Database Queries

6 Different statements

7.72 ms Query time

0 Invalid entities

354 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.56 ms
(46.11%)

SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference_inscription AS reference_inscription_2,
  t0.observations AS observations_3,
  t0.statut AS statut_4,
  t0.date_inscription AS date_inscription_5,
  t0.date_validation AS date_validation_6,
  t0.frais_inscription AS frais_inscription_7,
  t0.exonere AS exonere_8,
  t0.motif_exoneration AS motif_exoneration_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.eleve_id AS eleve_id_13,
  t0.concours_id AS concours_id_14,
  t0.cycle_id AS cycle_id_15,
  t0.section_id AS section_id_16,
  t0.classe_id AS classe_id_17,
  t0.groupe_id AS groupe_id_18,
  t0.agent_id AS agent_id_19
FROM
  inscription t0
WHERE
  t0.groupe_id = ?

SELECT t0.id AS id_1, t0.reference_inscription AS reference_inscription_2, t0.observations AS observations_3, t0.statut AS statut_4, t0.date_inscription AS date_inscription_5, t0.date_validation AS date_validation_6, t0.frais_inscription AS frais_inscription_7, t0.exonere AS exonere_8, t0.motif_exoneration AS motif_exoneration_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.eleve_id AS eleve_id_13, t0.concours_id AS concours_id_14, t0.cycle_id AS cycle_id_15, t0.section_id AS section_id_16, t0.classe_id AS classe_id_17, t0.groupe_id AS groupe_id_18, t0.agent_id AS agent_id_19 FROM inscription t0 WHERE t0.groupe_id = 9;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d14e635c24a425410dc9f0671f52a921::block_body (line 110)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_497b98872777cf35b270634f67f90942->doDisplay (line 703)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d14e635c24a425410dc9f0671f52a921->doDisplay (line 53)
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\GroupeController->index (line 36)
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)

1.78 ms
(23.08%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe 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.ordre AS ordre_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.concours_id AS concours_id_9
FROM
  classe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.concours_id AS concours_id_9 FROM classe 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\Classe::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Classe->__get (line 153)
7	App\Entity\Classe->getNom (line 60)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_d14e635c24a425410dc9f0671f52a921::block_body (line 104)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_497b98872777cf35b270634f67f90942->doDisplay (line 703)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d14e635c24a425410dc9f0671f52a921->doDisplay (line 53)
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\GroupeController->index (line 36)
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.74 ms
(9.65%)

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:

[
  5
]

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 = 5;

#	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)

0.69 ms
(8.92%)

SELECT count(DISTINCT g0_.id) AS sclr_0 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT g0_.id) AS sclr_0
FROM
  groupe g0_
  LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id
WHERE
  g0_.deleted_at IS NULL

SELECT count(DISTINCT g0_.id) AS sclr_0 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container6pBxGvU\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\GroupeController->index (line 34)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.47 ms
(6.14%)

SELECT DISTINCT g0_.id AS id_0, g0_.created_at AS created_at_1 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL ORDER BY g0_.created_at DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.created_at AS created_at_1
FROM
  groupe g0_
  LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id
WHERE
  g0_.deleted_at IS NULL
ORDER BY
  g0_.created_at DESC
LIMIT
  20

SELECT DISTINCT g0_.id AS id_0, g0_.created_at AS created_at_1 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL ORDER BY g0_.created_at DESC LIMIT 20;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container6pBxGvU\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\GroupeController->index (line 34)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.47 ms
(6.10%)

SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.code AS code_3, g0_.effectif_max AS effectif_max_4, g0_.active AS active_5, g0_.salle AS salle_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.deleted_at AS deleted_at_9, g0_.referent_id AS referent_id_10, g0_.classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY g0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.nom AS nom_1,
  g0_.description AS description_2,
  g0_.code AS code_3,
  g0_.effectif_max AS effectif_max_4,
  g0_.active AS active_5,
  g0_.salle AS salle_6,
  g0_.created_at AS created_at_7,
  g0_.updated_at AS updated_at_8,
  g0_.deleted_at AS deleted_at_9,
  g0_.referent_id AS referent_id_10,
  g0_.classe_id AS classe_id_11
FROM
  groupe g0_
  LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id
WHERE
  g0_.deleted_at IS NULL
  AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  g0_.created_at DESC

SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.code AS code_3, g0_.effectif_max AS effectif_max_4, g0_.active AS active_5, g0_.salle AS salle_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.deleted_at AS deleted_at_9, g0_.referent_id AS referent_id_10, g0_.classe_id AS classe_id_11 FROM groupe g0_ LEFT JOIN classe c1_ ON g0_.classe_id = c1_.id WHERE g0_.deleted_at IS NULL AND g0_.id IN (9, 8, 7, 6, 5, 4, 3, 2, 1) ORDER BY g0_.created_at DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container6pBxGvU\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\GroupeController->index (line 34)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	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\Inscription	164
App\Entity\Eleve	163
App\Entity\Groupe	9
App\Entity\Cycle	6
App\Entity\Classe	5
App\Entity\Concours	3
App\Entity\User	2
App\Entity\Section	2

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Groupe	No errors.
App\Entity\Classe	No errors.
App\Entity\Eleve	No errors.
App\Entity\Inscription	No errors.
App\Entity\Concours	No errors.
App\Entity\Cycle	No errors.
App\Entity\Section	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping