Symfony Profiler

Query Metrics

110 Database Queries

5 Different statements

56.06 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

46.96 ms
(83.76%)

103

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:

[
  57
]

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

#	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 175)
8	App\Controller\AcceuilController->filteredConstatations (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)

3.88 ms
(6.92%)

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 99)
10	__TwigTemplate_b2a8baba3be73809eaa8cca8a26dffb6->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 1347)
15	twig_include (line 157)
16	__TwigTemplate_b9ae60fd86fa8dc054a87a29d54595ad->block_body (line 171)
17	Twig\Template->displayBlock (line 211)
18	__TwigTemplate_35abe972ba5fdc6d96a9a2ed8534f04b->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 50)
21	__TwigTemplate_b9ae60fd86fa8dc054a87a29d54595ad->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 193)
30	App\Controller\AcceuilController->filteredConstatations (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

2.39 ms
(4.25%)

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 184)
9	App\Controller\AcceuilController->filteredConstatations (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.89 ms
(3.37%)

SELECT c0_.id AS id_0, c0_.numero AS numero_1, c0_.intitule AS intitule_2, c0_.regle AS regle_3, c0_.preuve AS preuve_4, c0_.daterevise AS daterevise_5, c0_.date AS date_6, c0_.remarque AS remarque_7, c0_.niveau_id AS niveau_id_8, c0_.statut_id AS statut_id_9, c0_.acte_id AS acte_id_10, c0_.risque_id AS risque_id_11, c0_.type_constatation_id AS type_constatation_id_12 FROM constatation c0_ INNER JOIN acte a1_ ON c0_.acte_id = a1_.id WHERE a1_.organisme_id = ? ORDER BY c0_.numero ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.numero AS numero_1,
  c0_.intitule AS intitule_2,
  c0_.regle AS regle_3,
  c0_.preuve AS preuve_4,
  c0_.daterevise AS daterevise_5,
  c0_.date AS date_6,
  c0_.remarque AS remarque_7,
  c0_.niveau_id AS niveau_id_8,
  c0_.statut_id AS statut_id_9,
  c0_.acte_id AS acte_id_10,
  c0_.risque_id AS risque_id_11,
  c0_.type_constatation_id AS type_constatation_id_12
FROM
  constatation c0_
  INNER JOIN acte a1_ ON c0_.acte_id = a1_.id
WHERE
  a1_.organisme_id = ?
ORDER BY
  c0_.numero ASC

SELECT c0_.id AS id_0, c0_.numero AS numero_1, c0_.intitule AS intitule_2, c0_.regle AS regle_3, c0_.preuve AS preuve_4, c0_.daterevise AS daterevise_5, c0_.date AS date_6, c0_.remarque AS remarque_7, c0_.niveau_id AS niveau_id_8, c0_.statut_id AS statut_id_9, c0_.acte_id AS acte_id_10, c0_.risque_id AS risque_id_11, c0_.type_constatation_id AS type_constatation_id_12 FROM constatation c0_ INNER JOIN acte a1_ ON c0_.acte_id = a1_.id WHERE a1_.organisme_id = 3 ORDER BY c0_.numero ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 231)
7	App\Repository\ConstatationRepository->findByOrganisme (line 168)
8	App\Controller\AcceuilController->filteredConstatations (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)

0.95 ms
(1.69%)

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)

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/organisme/constatations-filtrees

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping