Symfony Profiler

Query Metrics

20 Database Queries

7 Different statements

16.07 ms Query time

1 Invalid entities

106 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.80 ms
(42.29%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_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.slug AS slug_3,
  t0.cheflieu AS cheflieu_4,
  t0.superficie AS superficie_5,
  t0.population AS population_6,
  t0.nbredepartement AS nbredepartement_7,
  t0.presentation AS presentation_8,
  t0.message AS message_9,
  t0.dateadd AS dateadd_10,
  t0.district_id AS district_id_11,
  t0.user_id AS user_id_12
FROM
  region t0
WHERE
  t0.district_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\FrontendController->home (line 58)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

2.82 ms
(17.57%)

SELECT a.*, 
                   ta.libelle as type_acteur_libelle,
                   dp.region_id as region_id,
                   r.district_id as district_id
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id 
            LEFT JOIN departement dp ON a.departement_id = dp.id
            LEFT JOIN region r ON dp.region_id = r.id
         WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.*,
  ta.libelle as type_acteur_libelle,
  dp.region_id as region_id,
  r.district_id as district_id
FROM
  acteur a
  LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id
  LEFT JOIN departement dp ON a.departement_id = dp.id
  LEFT JOIN region r ON dp.region_id = r.id
WHERE
  a.latitude IS NOT NULL
  AND a.longitude IS NOT NULL

SELECT a.*, 
                   ta.libelle as type_acteur_libelle,
                   dp.region_id as region_id,
                   r.district_id as district_id
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id 
            LEFT JOIN departement dp ON a.departement_id = dp.id
            LEFT JOIN region r ON dp.region_id = r.id
         WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Repository\ActeurRepository->findForMap (line 110)
3	App\Controller\FrontendController->home (line 60)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

2.04 ms
(12.70%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\FrontendController->home (line 62)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

2.03 ms
(12.64%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.capital AS capital_3, t0.code_iso AS code_iso_4 FROM district t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.capital AS capital_3,
  t0.code_iso AS code_iso_4
FROM
  district t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.capital AS capital_3, t0.code_iso AS code_iso_4 FROM district t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\FrontendController->home (line 55)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

1.61 ms
(10.00%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  role_principal t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\FrontendController->home (line 64)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.50 ms
(3.10%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_juridique t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  statut_juridique t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_juridique t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\FrontendController->home (line 65)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.27 ms
(1.70%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3
FROM
  type_acteur t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\FrontendController->home (line 63)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Region	33
App\Entity\Filieres	16
App\Entity\StatutJuridique	16
App\Entity\RolePrincipal	15
App\Entity\District	14
App\Entity\TypeActeur	12

Entities Mapping

Class	Mapping errors
App\Entity\District	No errors.
App\Entity\Region	The association App\Entity\Region#district refers to the inverse side field App\Entity\District#district which does not exist.
App\Entity\User	No errors.
App\Entity\Departement	No errors.
App\Entity\Acteur	No errors.
App\Entity\Filieres	No errors.
App\Entity\TypeActeur	No errors.
App\Entity\RolePrincipal	No errors.
App\Entity\StatutJuridique	No errors.

Symfony Profiler

GET https://circulaire.developpe.net/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping