Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

4.46 ms Query time

0 Invalid entities

303 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.22 ms
(27.36%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.numero AS numero_3, t0.active AS active_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.active = ? ORDER BY t0.numero ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.numero AS numero_3,
  t0.active AS active_4,
  t0.region_id AS region_id_5
FROM
  departement t0
WHERE
  t0.active = ?
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.numero AS numero_3, t0.active AS active_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.active = 1 ORDER BY t0.numero ASC;

#	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\AdherentController->inscriptionSimple (line 559)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.01 ms
(22.69%)

SELECT t0.id AS id_1, t0.nom_pays AS nom_pays_2, t0.code_pays AS code_pays_3, t0.prefix_telephone AS prefix_telephone_4, t0.mettre_en_avant AS mettre_en_avant_5, t0.frontalier AS frontalier_6 FROM pays t0 ORDER BY t0.mettre_en_avant DESC, t0.frontalier DESC, t0.nom_pays ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_pays AS nom_pays_2,
  t0.code_pays AS code_pays_3,
  t0.prefix_telephone AS prefix_telephone_4,
  t0.mettre_en_avant AS mettre_en_avant_5,
  t0.frontalier AS frontalier_6
FROM
  pays t0
ORDER BY
  t0.mettre_en_avant DESC,
  t0.frontalier DESC,
  t0.nom_pays ASC

SELECT t0.id AS id_1, t0.nom_pays AS nom_pays_2, t0.code_pays AS code_pays_3, t0.prefix_telephone AS prefix_telephone_4, t0.mettre_en_avant AS mettre_en_avant_5, t0.frontalier AS frontalier_6 FROM pays t0 ORDER BY t0.mettre_en_avant DESC, t0.frontalier DESC, t0.nom_pays ASC;

#	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\AdherentController->inscriptionSimple (line 560)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.52 ms
(11.76%)

SELECT t0.id AS id_1, t0.email_expedition AS email_expedition_2, t0.email_destination AS email_destination_3, t0.raison_sociale AS raison_sociale_4, t0.adresse AS adresse_5, t0.siret AS siret_6, t0.nom_president AS nom_president_7, t0.recu_fiscal_texte_entete AS recu_fiscal_texte_entete_8, t0.recu_fiscal_texte_pieds_page AS recu_fiscal_texte_pieds_page_9, t0.signature_file AS signature_file_10, t0.url_site_principal AS url_site_principal_11, t0.telephone_principal AS telephone_principal_12, t0.numero_rue AS numero_rue_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.texte_mention_legale AS texte_mention_legale_16, t0.nom_mediakit AS nom_mediakit_17, t0.url_mediakit AS url_mediakit_18, t0.nom_catalogue_formation AS nom_catalogue_formation_19, t0.url_catalogue_formation AS url_catalogue_formation_20 FROM parametre t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email_expedition AS email_expedition_2,
  t0.email_destination AS email_destination_3,
  t0.raison_sociale AS raison_sociale_4,
  t0.adresse AS adresse_5,
  t0.siret AS siret_6,
  t0.nom_president AS nom_president_7,
  t0.recu_fiscal_texte_entete AS recu_fiscal_texte_entete_8,
  t0.recu_fiscal_texte_pieds_page AS recu_fiscal_texte_pieds_page_9,
  t0.signature_file AS signature_file_10,
  t0.url_site_principal AS url_site_principal_11,
  t0.telephone_principal AS telephone_principal_12,
  t0.numero_rue AS numero_rue_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.texte_mention_legale AS texte_mention_legale_16,
  t0.nom_mediakit AS nom_mediakit_17,
  t0.url_mediakit AS url_mediakit_18,
  t0.nom_catalogue_formation AS nom_catalogue_formation_19,
  t0.url_catalogue_formation AS url_catalogue_formation_20
FROM
  parametre t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email_expedition AS email_expedition_2, t0.email_destination AS email_destination_3, t0.raison_sociale AS raison_sociale_4, t0.adresse AS adresse_5, t0.siret AS siret_6, t0.nom_president AS nom_president_7, t0.recu_fiscal_texte_entete AS recu_fiscal_texte_entete_8, t0.recu_fiscal_texte_pieds_page AS recu_fiscal_texte_pieds_page_9, t0.signature_file AS signature_file_10, t0.url_site_principal AS url_site_principal_11, t0.telephone_principal AS telephone_principal_12, t0.numero_rue AS numero_rue_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.texte_mention_legale AS texte_mention_legale_16, t0.nom_mediakit AS nom_mediakit_17, t0.url_mediakit AS url_mediakit_18, t0.nom_catalogue_formation AS nom_catalogue_formation_19, t0.url_catalogue_formation AS url_catalogue_formation_20 FROM parametre t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\AdherentController->inscriptionSimple (line 567)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.48 ms
(10.69%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3 FROM situation_professionnelle t0 WHERE t0.active = ? ORDER BY t0.libelle ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.active AS active_3
FROM
  situation_professionnelle t0
WHERE
  t0.active = ?
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3 FROM situation_professionnelle t0 WHERE t0.active = 1 ORDER BY t0.libelle ASC;

#	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\AdherentController->inscriptionSimple (line 561)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.44 ms
(9.86%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.affiche_filiere_procede AS affiche_filiere_procede_3 FROM type_societe t0 ORDER BY t0.libelle ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.affiche_filiere_procede AS affiche_filiere_procede_3
FROM
  type_societe t0
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.affiche_filiere_procede AS affiche_filiere_procede_3 FROM type_societe t0 ORDER BY t0.libelle ASC;

#	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\AdherentController->inscriptionSimple (line 562)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.41 ms
(9.14%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.necessite_precision AS necessite_precision_3 FROM filiere t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.necessite_precision AS necessite_precision_3
FROM
  filiere t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.necessite_precision AS necessite_precision_3 FROM filiere 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\AdherentController->inscriptionSimple (line 563)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.38 ms
(8.51%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.necessite_precision AS necessite_precision_3 FROM procede t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.necessite_precision AS necessite_precision_3
FROM
  procede t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.necessite_precision AS necessite_precision_3 FROM procede 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\AdherentController->inscriptionSimple (line 564)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\Pays	151
App\Entity\Departement	101
App\Entity\SituationProfessionnelle	19
App\Entity\Region	18
App\Entity\Filiere	5
App\Entity\Procede	5
App\Entity\TypeSociete	3
App\Entity\Parametre	1

Entities Mapping

Class	Mapping errors
App\Entity\Departement	No errors.
App\Entity\Region	No errors.
App\Entity\Pays	No errors.
App\Entity\SituationProfessionnelle	No errors.
App\Entity\TypeSociete	No errors.
App\Entity\Filiere	No errors.
App\Entity\Procede	No errors.
App\Entity\Parametre	No errors.

Symfony Profiler

GET https://monespace-dev.atf.asso.fr/inscription

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping