Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

22.51 ms Query time

0 Invalid entities

436 Managed entities

Queries

Group similar statements

#▲

Time

Info

17.72 ms

SELECT t0.id AS id_1, t0.raisonsocialeentreprise AS raisonsocialeentreprise_2, t0.telephoneentreprise AS telephoneentreprise_3, t0.emailentreprise AS emailentreprise_4, t0.boiteposteentreprise AS boiteposteentreprise_5, t0.faxentreprise AS faxentreprise_6, t0.agrement AS agrement_7, t0.delivrance AS delivrance_8, t0.renouvellement AS renouvellement_9, t0.valide AS valide_10, t0.publie AS publie_11, t0.vue AS vue_12, t0.gerant AS gerant_13, t0.accredite AS accredite_14, t0.creele AS creele_15, t0.modifiele AS modifiele_16, t0.area_id AS area_id_17, t0.depart_id AS depart_id_18, t0.arrondissement_id AS arrondissement_id_19, t0.metier_id AS metier_id_20 FROM agent_promoteuret_syndic t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raisonsocialeentreprise AS raisonsocialeentreprise_2,
  t0.telephoneentreprise AS telephoneentreprise_3,
  t0.emailentreprise AS emailentreprise_4,
  t0.boiteposteentreprise AS boiteposteentreprise_5,
  t0.faxentreprise AS faxentreprise_6,
  t0.agrement AS agrement_7,
  t0.delivrance AS delivrance_8,
  t0.renouvellement AS renouvellement_9,
  t0.valide AS valide_10,
  t0.publie AS publie_11,
  t0.vue AS vue_12,
  t0.gerant AS gerant_13,
  t0.accredite AS accredite_14,
  t0.creele AS creele_15,
  t0.modifiele AS modifiele_16,
  t0.area_id AS area_id_17,
  t0.depart_id AS depart_id_18,
  t0.arrondissement_id AS arrondissement_id_19,
  t0.metier_id AS metier_id_20
FROM
  agent_promoteuret_syndic t0

SELECT t0.id AS id_1, t0.raisonsocialeentreprise AS raisonsocialeentreprise_2, t0.telephoneentreprise AS telephoneentreprise_3, t0.emailentreprise AS emailentreprise_4, t0.boiteposteentreprise AS boiteposteentreprise_5, t0.faxentreprise AS faxentreprise_6, t0.agrement AS agrement_7, t0.delivrance AS delivrance_8, t0.renouvellement AS renouvellement_9, t0.valide AS valide_10, t0.publie AS publie_11, t0.vue AS vue_12, t0.gerant AS gerant_13, t0.accredite AS accredite_14, t0.creele AS creele_15, t0.modifiele AS modifiele_16, t0.area_id AS area_id_17, t0.depart_id AS depart_id_18, t0.arrondissement_id AS arrondissement_id_19, t0.metier_id AS metier_id_20 FROM agent_promoteuret_syndic t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 242)
6	App\Services\EditService->checkAuthorisationDateValidity (line 295)
7	App\Controller\FrontController->professionRegionGenerateFile (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

3.11 ms

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.creele AS creele_5,
  t0.modifiele AS modifiele_6
FROM
  profession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Profession::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Profession->__get (line 71)
8	App\Entity\Profession->getIdentifiant (line 246)
9	App\Services\EditService->checkAuthorisationDateValidity (line 295)
10	App\Controller\FrontController->professionRegionGenerateFile (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.92 ms

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.creele AS creele_5,
  t0.modifiele AS modifiele_6
FROM
  profession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Profession::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Profession->__get (line 71)
8	App\Entity\Profession->getIdentifiant (line 246)
9	App\Services\EditService->checkAuthorisationDateValidity (line 295)
10	App\Controller\FrontController->professionRegionGenerateFile (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.77 ms

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.creele AS creele_5,
  t0.modifiele AS modifiele_6
FROM
  profession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Profession::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Profession->__get (line 71)
8	App\Entity\Profession->getIdentifiant (line 246)
9	App\Services\EditService->checkAuthorisationDateValidity (line 295)
10	App\Controller\FrontController->professionRegionGenerateFile (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\AgentPromoteuretSyndic	394
App\Entity\Arrondissement	16
App\Entity\Departement	14
App\Entity\Region	9
App\Entity\Profession	3

Entities Mapping

Class	Mapping errors
App\Entity\AgentPromoteuretSyndic	No errors.
App\Entity\Region	No errors.
App\Entity\Departement	No errors.
App\Entity\Arrondissement	No errors.
App\Entity\Profession	No errors.

Symfony Profiler

GET https://www.minhdu.gov.cm/promotion-immobiliere/home/activity_agent/region_littoral/generate_file

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping