Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

14.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.23 ms
(22.54%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM niveau t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  niveau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM niveau t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\Niveau::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Niveau->__get (line 36)
8	App\Entity\Niveau->getLibelle (line 1635)
9	twig_get_attribute (line 207)
10	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->block_body (line 171)
11	Twig\Template->displayBlock (line 211)
12	__TwigTemplate_35abe972ba5fdc6d96a9a2ed8534f04b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 53)
15	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 145)
24	App\Controller\ConstatationController->show (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

3.20 ms
(22.32%)

SELECT t0.id AS id_1, t0.decision_initiale AS decision_initiale_2, t0.date_decision_initiale AS date_decision_initiale_3, t0.decision_finale AS decision_finale_4, t0.date_decision_finale AS date_decision_finale_5, t0.commentaire_initial AS commentaire_initial_6, t0.commentaire_final AS commentaire_final_7, t0.date_soumission AS date_soumission_8, t0.statut AS statut_9, t0.created_at AS created_at_10, t0.constatation_id AS constatation_id_11 FROM plan_action t0 WHERE t0.constatation_id = ?

Parameters:

[
  68
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.decision_initiale AS decision_initiale_2,
  t0.date_decision_initiale AS date_decision_initiale_3,
  t0.decision_finale AS decision_finale_4,
  t0.date_decision_finale AS date_decision_finale_5,
  t0.commentaire_initial AS commentaire_initial_6,
  t0.commentaire_final AS commentaire_final_7,
  t0.date_soumission AS date_soumission_8,
  t0.statut AS statut_9,
  t0.created_at AS created_at_10,
  t0.constatation_id AS constatation_id_11
FROM
  plan_action t0
WHERE
  t0.constatation_id = ?

SELECT t0.id AS id_1, t0.decision_initiale AS decision_initiale_2, t0.date_decision_initiale AS date_decision_initiale_3, t0.decision_finale AS decision_finale_4, t0.date_decision_finale AS date_decision_finale_5, t0.commentaire_initial AS commentaire_initial_6, t0.commentaire_final AS commentaire_final_7, t0.date_soumission AS date_soumission_8, t0.statut AS statut_9, t0.created_at AS created_at_10, t0.constatation_id AS constatation_id_11 FROM plan_action t0 WHERE t0.constatation_id = 68;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2696)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 143)
8	App\Controller\ConstatationController->show (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.72 ms
(18.94%)

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.intitule AS intitule_3, t0.regle AS regle_4, t0.preuve AS preuve_5, t0.daterevise AS daterevise_6, t0.date AS date_7, t0.remarque AS remarque_8, t0.niveau_id AS niveau_id_9, t0.statut_id AS statut_id_10, t0.acte_id AS acte_id_11, t0.risque_id AS risque_id_12, t0.type_constatation_id AS type_constatation_id_13 FROM constatation t0 WHERE t0.id = ?

Parameters:

[
  "68"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.intitule AS intitule_3,
  t0.regle AS regle_4,
  t0.preuve AS preuve_5,
  t0.daterevise AS daterevise_6,
  t0.date AS date_7,
  t0.remarque AS remarque_8,
  t0.niveau_id AS niveau_id_9,
  t0.statut_id AS statut_id_10,
  t0.acte_id AS acte_id_11,
  t0.risque_id AS risque_id_12,
  t0.type_constatation_id AS type_constatation_id_13
FROM
  constatation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.intitule AS intitule_3, t0.regle AS regle_4, t0.preuve AS preuve_5, t0.daterevise AS daterevise_6, t0.date AS date_7, t0.remarque AS remarque_8, t0.niveau_id AS niveau_id_9, t0.statut_id AS statut_id_10, t0.acte_id AS acte_id_11, t0.risque_id AS risque_id_12, t0.type_constatation_id AS type_constatation_id_13 FROM constatation t0 WHERE t0.id = '68';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

2.43 ms
(16.94%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM statut 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
FROM
  statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM statut t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\Statut::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Statut->__get (line 36)
8	App\Entity\Statut->getNom (line 1635)
9	twig_get_attribute (line 211)
10	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->block_body (line 171)
11	Twig\Template->displayBlock (line 211)
12	__TwigTemplate_35abe972ba5fdc6d96a9a2ed8534f04b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 53)
15	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 145)
24	App\Controller\ConstatationController->show (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.07 ms
(14.44%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.numero_inspecteur AS numero_inspecteur_8, t0.created_at AS created_at_9, t0.is_verified AS is_verified_10, t0.domaine_id AS domaine_id_11, t0.chef_service_id AS chef_service_id_12, t0.directeur_technique_id AS directeur_technique_id_13, t0.organisme_id AS organisme_id_14 FROM user t0 WHERE t0.id = ?

Parameters:

[
  65
]

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.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.numero_inspecteur AS numero_inspecteur_8,
  t0.created_at AS created_at_9,
  t0.is_verified AS is_verified_10,
  t0.domaine_id AS domaine_id_11,
  t0.chef_service_id AS chef_service_id_12,
  t0.directeur_technique_id AS directeur_technique_id_13,
  t0.organisme_id AS organisme_id_14
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.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.numero_inspecteur AS numero_inspecteur_8, t0.created_at AS created_at_9, t0.is_verified AS is_verified_10, t0.domaine_id AS domaine_id_11, t0.chef_service_id AS chef_service_id_12, t0.directeur_technique_id AS directeur_technique_id_13, t0.organisme_id AS organisme_id_14 FROM user t0 WHERE t0.id = 65;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.42 ms
(2.93%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.responsable AS responsable_5, t0.observation AS observation_6, t0.decision_anac AS decision_anac_7, t0.commentaire_anac AS commentaire_anac_8, t0.statut AS statut_9, t0.plan_action_id AS plan_action_id_10 FROM action_correctrice t0 WHERE t0.plan_action_id = ?

Parameters:

[
  38
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.responsable AS responsable_5,
  t0.observation AS observation_6,
  t0.decision_anac AS decision_anac_7,
  t0.commentaire_anac AS commentaire_anac_8,
  t0.statut AS statut_9,
  t0.plan_action_id AS plan_action_id_10
FROM
  action_correctrice t0
WHERE
  t0.plan_action_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.responsable AS responsable_5, t0.observation AS observation_6, t0.decision_anac AS decision_anac_7, t0.commentaire_anac AS commentaire_anac_8, t0.statut AS statut_9, t0.plan_action_id AS plan_action_id_10 FROM action_correctrice t0 WHERE t0.plan_action_id = 38;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2696)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 425)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1476)
10	twig_get_attribute (line 278)
11	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->block_body (line 171)
12	Twig\Template->displayBlock (line 211)
13	__TwigTemplate_35abe972ba5fdc6d96a9a2ed8534f04b->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 53)
16	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 145)
25	App\Controller\ConstatationController->show (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.27 ms
(1.88%)

SELECT t0.id AS id_1, t0.decision AS decision_2, t0.commentaire AS commentaire_3, t0.created_at AS created_at_4, t0.plan_id AS plan_id_5 FROM decision_plan t0 WHERE t0.plan_id = ?

Parameters:

[
  38
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.decision AS decision_2,
  t0.commentaire AS commentaire_3,
  t0.created_at AS created_at_4,
  t0.plan_id AS plan_id_5
FROM
  decision_plan t0
WHERE
  t0.plan_id = ?

SELECT t0.id AS id_1, t0.decision AS decision_2, t0.commentaire AS commentaire_3, t0.created_at AS created_at_4, t0.plan_id AS plan_id_5 FROM decision_plan t0 WHERE t0.plan_id = 38;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2696)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1270)
9	twig_test_empty (line 305)
10	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->block_body (line 171)
11	Twig\Template->displayBlock (line 211)
12	__TwigTemplate_35abe972ba5fdc6d96a9a2ed8534f04b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 53)
15	__TwigTemplate_ab1ec728955e78ca998653618b13e2d2->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 145)
24	App\Controller\ConstatationController->show (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\User	No errors.
App\Entity\Domaine	No errors.
App\Entity\Organisme	No errors.
App\Entity\Acte	No errors.
App\Entity\Constatation	No errors.
App\Entity\Niveau	No errors.
App\Entity\Statut	No errors.
App\Entity\Risque	No errors.
App\Entity\TypeConstatation	No errors.
App\Entity\PlanAction	No errors.
App\Entity\ActionCorrectrice	No errors.
App\Entity\DecisionPlan	No errors.

Symfony Profiler

GET http://surveillance.anac.bj/constatation/68

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping