Symfony Profiler

Query Metrics

17 Database Queries

11 Different statements

543.55 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

144.03 ms
(26.50%)

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ?

Parameters:

[
  3
  "2026-04-13 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-04-13 00:00:00';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 84)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

112.85 ms
(20.76%)

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.is_etat = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.is_etat = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.is_etat = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 206)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

108.82 ms
(20.02%)

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.sexe = ?

Parameters:

[
  3
  "F"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.sexe = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.sexe = 'F';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 194)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

103.64 ms
(19.07%)

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ? AND e0_.created_at < ?

Parameters:

[
  3
  "2026-04-19 00:00:00"
  "2026-04-20 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?
  AND e0_.created_at < ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-04-19 00:00:00' AND e0_.created_at < '2026-04-20 00:00:00';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

51.98 ms
(9.56%)

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.is_demande = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.is_demande = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.is_demande = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 154)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

11.35 ms
(2.09%)

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = ? AND a0_.action_type = ? AND e1_.client_id = ? AND a0_.action_date >= ?

Parameters:

[
  "Extrait"
  "impression"
  3
  "2026-04-13 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT a0_.entity_id) AS sclr_0
FROM
  audit_log a0_
  INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id)
WHERE
  a0_.entity = ?
  AND a0_.action_type = ?
  AND e1_.client_id = ?
  AND a0_.action_date >= ?

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = 'Extrait' AND a0_.action_type = 'impression' AND e1_.client_id = 3 AND a0_.action_date >= '2026-04-13 00:00:00';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 130)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

5.34 ms
(0.98%)

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 64)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

3.65 ms
(0.67%)

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = ? AND a0_.action_type = ? AND e1_.client_id = ? AND a0_.action_date >= ? AND a0_.action_date < ?

Parameters:

[
  "Extrait"
  "impression"
  3
  "2026-04-19 00:00:00"
  "2026-04-20 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT a0_.entity_id) AS sclr_0
FROM
  audit_log a0_
  INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id)
WHERE
  a0_.entity = ?
  AND a0_.action_type = ?
  AND e1_.client_id = ?
  AND a0_.action_date >= ?
  AND a0_.action_date < ?

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = 'Extrait' AND a0_.action_type = 'impression' AND e1_.client_id = 3 AND a0_.action_date >= '2026-04-19 00:00:00' AND a0_.action_date < '2026-04-20 00:00:00';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 114)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.66 ms
(0.12%)

SELECT COUNT(r0_.id) AS sclr_0 FROM registre_naissance r0_ WHERE r0_.client_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  registre_naissance r0_
WHERE
  r0_.client_id = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM registre_naissance r0_ WHERE r0_.client_id = 3;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\Api\StatisticsController->getStatistics (line 187)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.63 ms
(0.12%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.contact AS contact_4, t0.type AS type_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.code AS code_11, t0.le_responsable AS le_responsable_12, t0.date_debut_at AS date_debut_at_13, t0.date_fin_at AS date_fin_at_14, t0.district_id AS district_id_15, t0.region_id AS region_id_16, t0.departement_id AS departement_id_17, t0.commune_id AS commune_id_18, t0.ville_id AS ville_id_19 FROM client t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.telephone AS telephone_3,
  t0.contact AS contact_4,
  t0.type AS type_5,
  t0.image AS image_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.code AS code_11,
  t0.le_responsable AS le_responsable_12,
  t0.date_debut_at AS date_debut_at_13,
  t0.date_fin_at AS date_fin_at_14,
  t0.district_id AS district_id_15,
  t0.region_id AS region_id_16,
  t0.departement_id AS departement_id_17,
  t0.commune_id AS commune_id_18,
  t0.ville_id AS ville_id_19
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.contact AS contact_4, t0.type AS type_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.code AS code_11, t0.le_responsable AS le_responsable_12, t0.date_debut_at AS date_debut_at_13, t0.date_fin_at AS date_fin_at_14, t0.district_id AS district_id_15, t0.region_id AS region_id_16, t0.departement_id AS departement_id_17, t0.commune_id AS commune_id_18, t0.ville_id AS ville_id_19 FROM client t0 WHERE t0.id = 3;

#	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\Client::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Client->__get (line 184)
7	App\Entity\Client->getDateFinAt (line 552)
8	App\EventSubscriber\CheckExpiredClientsSubscriber->onKernelRequest (line 47)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

0.60 ms
(0.11%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.email AS email_8, t0.last_name AS last_name_9, t0.first_name AS first_name_10, t0.phone_number AS phone_number_11, t0.address AS address_12, t0.location AS location_13, t0.client_id AS client_id_14 FROM user t0 WHERE t0.id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_password_changed AS is_password_changed_6,
  t0.last_login_at AS last_login_at_7,
  t0.email AS email_8,
  t0.last_name AS last_name_9,
  t0.first_name AS first_name_10,
  t0.phone_number AS phone_number_11,
  t0.address AS address_12,
  t0.location AS location_13,
  t0.client_id AS client_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.email AS email_8, t0.last_name AS last_name_9, t0.first_name AS first_name_10, t0.phone_number AS phone_number_11, t0.address AS address_12, t0.location AS location_13, t0.client_id AS client_id_14 FROM user t0 WHERE t0.id = 17;

#	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 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Client	1
App\Entity\District	1
App\Entity\Region	1
App\Entity\Departement	1
App\Entity\Commune	1
App\Entity\Ville	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Client	No errors.
App\Entity\District	No errors.
App\Entity\Region	No errors.
App\Entity\Departement	No errors.
App\Entity\Commune	No errors.
App\Entity\Ville	No errors.
App\Entity\RegistreNaissance	No errors.
App\Entity\Extrait	No errors.
App\Entity\Mention	No errors.
App\Entity\Centre	No errors.
App\Entity\Personnes	No errors.
App\Entity\TypeRegistre	No errors.
App\Entity\RegistreMariage	No errors.
App\Entity\RegistreDeces	No errors.
App\Entity\ActeMariage	No errors.
App\Entity\ActeDeces	No errors.
App\Entity\CodeUtilise	No errors.
App\Entity\CertificatVie	No errors.
App\Entity\RechercheInfructueuse	No errors.
App\Entity\AttestationNonNaissance	No errors.
App\Entity\AttestationNonDeces	No errors.

Symfony Profiler

GET https://getaci.dianoch.com/statistics

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping