Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

9.26 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.33 ms
(25.14%)

SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.societe_id AS societe_id_2 FROM format f0_ WHERE f0_.societe_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.libelle AS libelle_1,
  f0_.societe_id AS societe_id_2
FROM
  format f0_
WHERE
  f0_.societe_id = ?

SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.societe_id AS societe_id_2 FROM format f0_ WHERE f0_.societe_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 61)
21	App\Controller\SessionsController->add (line 182)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.99 ms
(21.50%)

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.tarif_ht AS tarif_ht_2, f0_.tarif_ttc AS tarif_ttc_3, f0_.duree_jours AS duree_jours_4, f0_.duree_heures AS duree_heures_5, f0_.objectif AS objectif_6, f0_.ressource AS ressource_7, f0_.suivi AS suivi_8, f0_.contenu AS contenu_9, f0_.participant_min AS participant_min_10, f0_.participant_max AS participant_max_11, f0_.public AS public_12, f0_.pre_requis AS pre_requis_13, f0_.resultat_attendu AS resultat_attendu_14, f0_.modalite_admission AS modalite_admission_15, f0_.date_creation AS date_creation_16, f0_.certification AS certification_17, f0_.moyen AS moyen_18, f0_.format_id AS format_id_19, f0_.tva_id AS tva_id_20, f0_.admission_id AS admission_id_21, f0_.referent_id AS referent_id_22, f0_.societe_id AS societe_id_23 FROM formations f0_ WHERE f0_.societe_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.titre AS titre_1,
  f0_.tarif_ht AS tarif_ht_2,
  f0_.tarif_ttc AS tarif_ttc_3,
  f0_.duree_jours AS duree_jours_4,
  f0_.duree_heures AS duree_heures_5,
  f0_.objectif AS objectif_6,
  f0_.ressource AS ressource_7,
  f0_.suivi AS suivi_8,
  f0_.contenu AS contenu_9,
  f0_.participant_min AS participant_min_10,
  f0_.participant_max AS participant_max_11,
  f0_.public AS public_12,
  f0_.pre_requis AS pre_requis_13,
  f0_.resultat_attendu AS resultat_attendu_14,
  f0_.modalite_admission AS modalite_admission_15,
  f0_.date_creation AS date_creation_16,
  f0_.certification AS certification_17,
  f0_.moyen AS moyen_18,
  f0_.format_id AS format_id_19,
  f0_.tva_id AS tva_id_20,
  f0_.admission_id AS admission_id_21,
  f0_.referent_id AS referent_id_22,
  f0_.societe_id AS societe_id_23
FROM
  formations f0_
WHERE
  f0_.societe_id = ?

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.tarif_ht AS tarif_ht_2, f0_.tarif_ttc AS tarif_ttc_3, f0_.duree_jours AS duree_jours_4, f0_.duree_heures AS duree_heures_5, f0_.objectif AS objectif_6, f0_.ressource AS ressource_7, f0_.suivi AS suivi_8, f0_.contenu AS contenu_9, f0_.participant_min AS participant_min_10, f0_.participant_max AS participant_max_11, f0_.public AS public_12, f0_.pre_requis AS pre_requis_13, f0_.resultat_attendu AS resultat_attendu_14, f0_.modalite_admission AS modalite_admission_15, f0_.date_creation AS date_creation_16, f0_.certification AS certification_17, f0_.moyen AS moyen_18, f0_.format_id AS format_id_19, f0_.tva_id AS tva_id_20, f0_.admission_id AS admission_id_21, f0_.referent_id AS referent_id_22, f0_.societe_id AS societe_id_23 FROM formations f0_ WHERE f0_.societe_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 61)
21	App\Controller\SessionsController->add (line 182)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.79 ms
(19.35%)

SELECT m0_.id AS id_0, m0_.libelle AS libelle_1, m0_.societe_id AS societe_id_2 FROM mode m0_ WHERE m0_.societe_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.libelle AS libelle_1,
  m0_.societe_id AS societe_id_2
FROM
  mode m0_
WHERE
  m0_.societe_id = ?

SELECT m0_.id AS id_0, m0_.libelle AS libelle_1, m0_.societe_id AS societe_id_2 FROM mode m0_ WHERE m0_.societe_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 61)
21	App\Controller\SessionsController->add (line 182)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.77 ms
(19.10%)

SELECT r0_.id AS id_0, r0_.libelle AS libelle_1, r0_.societe_id AS societe_id_2 FROM referent r0_ WHERE r0_.societe_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.libelle AS libelle_1,
  r0_.societe_id AS societe_id_2
FROM
  referent r0_
WHERE
  r0_.societe_id = ?

SELECT r0_.id AS id_0, r0_.libelle AS libelle_1, r0_.societe_id AS societe_id_2 FROM referent r0_ WHERE r0_.societe_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 61)
21	App\Controller\SessionsController->add (line 182)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.13 ms
(12.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.tel AS tel_7, t0.societe_id AS societe_id_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  6
]

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.tel AS tel_7,
  t0.societe_id AS societe_id_8
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.tel AS tel_7, t0.societe_id AS societe_id_8 FROM user t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 73)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 158)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.25 ms
(2.71%)

SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.societe_id AS societe_id_2 FROM provenance p0_ WHERE p0_.societe_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.libelle AS libelle_1,
  p0_.societe_id AS societe_id_2
FROM
  provenance p0_
WHERE
  p0_.societe_id = ?

SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.societe_id AS societe_id_2 FROM provenance p0_ WHERE p0_.societe_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 61)
21	App\Controller\SessionsController->add (line 182)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Societe	No errors.
App\Entity\Formations	No errors.
App\Entity\Format	No errors.
App\Entity\Tva	No errors.
App\Entity\Admission	No errors.
App\Entity\Referent	No errors.
App\Entity\Mode	No errors.
App\Entity\Provenance	No errors.
App\Entity\Sessions	No errors.
App\Entity\DocumentsFormation	No errors.
App\Entity\Clients	No errors.

Symfony Profiler

GET https://formatracker.com/erp/sessions/ajouter?p=erp%2Fsessions%2Fajouter

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping