Symfony Profiler

Query Metrics

11 Database Queries

7 Different statements

52.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

30.66 ms
(58.75%)

INSERT INTO action_correctrice (libelle, date_debut, date_fin, responsable, observation, decision_anac, commentaire_anac, statut, plan_action_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "1- Actualiser le comité PPA par une nouvelle décision "
  "2025-05-05"
  "2025-05-16"
  "Directeur des Opérations et de l'eXpérience Passagers"
  ""
  null
  null
  "en_cours"
  37
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO action_correctrice (
  libelle, date_debut, date_fin, responsable,
  observation, decision_anac, commentaire_anac,
  statut, plan_action_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO action_correctrice (libelle, date_debut, date_fin, responsable, observation, decision_anac, commentaire_anac, statut, plan_action_id) VALUES ('1- Actualiser le comité PPA par une nouvelle décision ', '2025-05-05', '2025-05-16', 'Directeur des Opérations et de l\'eXpérience Passagers', '', NULL, NULL, 'en_cours', 37);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 229)
7	App\Controller\ActionCorrectriceController->new (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

11.12 ms
(21.31%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 229)
5	App\Controller\ActionCorrectriceController->new (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

3.81 ms
(7.31%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 229)
4	App\Controller\ActionCorrectriceController->new (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.24 ms
(6.21%)

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 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

2.37 ms
(4.55%)

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.id = ?

Parameters:

[
  "37"
]

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.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.id = '37';

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

0.49 ms
(0.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:

[
  77
]

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

#	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\Constatation::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Constatation->__get (line 190)
8	App\Entity\Constatation->getActe (line 231)
9	App\Controller\ActionCorrectriceController->new (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)

0.48 ms
(0.93%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.datedebut AS datedebut_3, t0.datefin AS datefin_4, t0.audite AS audite_5, t0.items AS items_6, t0.nbre AS nbre_7, t0.inspecteur_secondaire AS inspecteur_secondaire_8, t0.created_at AS created_at_9, t0.preuve AS preuve_10, t0.titre AS titre_11, t0.organisme_id AS organisme_id_12, t0.inspecteur_id AS inspecteur_id_13, t0.domaine_id AS domaine_id_14, t0.nature_id AS nature_id_15 FROM acte t0 WHERE t0.id = ?

Parameters:

[
  62
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.datedebut AS datedebut_3,
  t0.datefin AS datefin_4,
  t0.audite AS audite_5,
  t0.items AS items_6,
  t0.nbre AS nbre_7,
  t0.inspecteur_secondaire AS inspecteur_secondaire_8,
  t0.created_at AS created_at_9,
  t0.preuve AS preuve_10,
  t0.titre AS titre_11,
  t0.organisme_id AS organisme_id_12,
  t0.inspecteur_id AS inspecteur_id_13,
  t0.domaine_id AS domaine_id_14,
  t0.nature_id AS nature_id_15
FROM
  acte t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.datedebut AS datedebut_3, t0.datefin AS datefin_4, t0.audite AS audite_5, t0.items AS items_6, t0.nbre AS nbre_7, t0.inspecteur_secondaire AS inspecteur_secondaire_8, t0.created_at AS created_at_9, t0.preuve AS preuve_10, t0.titre AS titre_11, t0.organisme_id AS organisme_id_12, t0.inspecteur_id AS inspecteur_id_13, t0.domaine_id AS domaine_id_14, t0.nature_id AS nature_id_15 FROM acte t0 WHERE t0.id = 62;

#	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\Acte::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Acte->__get (line 189)
8	App\Entity\Acte->getInspecteur (line 231)
9	App\Controller\ActionCorrectriceController->new (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)

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\PlanAction	No errors.
App\Entity\Constatation	No errors.
App\Entity\ActionCorrectrice	No errors.
App\Entity\DecisionPlan	No errors.
App\Entity\PreuveAction	No errors.
App\Entity\Niveau	No errors.
App\Entity\Statut	No errors.
App\Entity\Risque	No errors.
App\Entity\TypeConstatation	No errors.
App\Entity\NatureActe	No errors.
App\Entity\PreuveActe	No errors.

Symfony Profiler

POST http://surveillance.anac.bj/action-correctrice/new/37

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping