Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.88 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.04 ms
(52.57%)

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.code_postal AS code_postal_3, t0.ville AS ville_4, t0.ville_mere AS ville_mere_5, t0.rib AS rib_6, t0.idsalesforce AS idsalesforce_7 FROM `campus` t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.code_postal AS code_postal_3,
  t0.ville AS ville_4,
  t0.ville_mere AS ville_mere_5,
  t0.rib AS rib_6,
  t0.idsalesforce AS idsalesforce_7
FROM
  `campus` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.code_postal AS code_postal_3, t0.ville AS ville_4, t0.ville_mere AS ville_mere_5, t0.rib AS rib_6, t0.idsalesforce AS idsalesforce_7 FROM `campus` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Campus::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Campus->__get (line 127)
8	App\Entity\Campus->getVilleMere (line 75)
9	App\Form\RegistrationFormType->App\Form\{closure} (line 158)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 233)
11	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 123)
12	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
13	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
14	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
15	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
16	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
19	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
20	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
21	Symfony\Component\Form\Form->createView (line 891)
22	Symfony\Component\Form\Form->createView (line 423)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
26	App\Controller\RegistrationController->register (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.84 ms
(47.43%)

SELECT f0_.id AS id_0, f0_.duration AS duration_1, f0_.languages AS languages_2, f0_.pace AS pace_3, f0_.application_deadline AS application_deadline_4, f0_.tuition_fees AS tuition_fees_5, f0_.study_format AS study_format_6, f0_.id_salesforce AS id_salesforce_7, f0_.name AS name_8, f0_.category AS category_9, f0_.picto AS picto_10, f0_.type AS type_11, f0_.campus_id AS campus_id_12 FROM `formation` f0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.duration AS duration_1,
  f0_.languages AS languages_2,
  f0_.pace AS pace_3,
  f0_.application_deadline AS application_deadline_4,
  f0_.tuition_fees AS tuition_fees_5,
  f0_.study_format AS study_format_6,
  f0_.id_salesforce AS id_salesforce_7,
  f0_.name AS name_8,
  f0_.category AS category_9,
  f0_.picto AS picto_10,
  f0_.type AS type_11,
  f0_.campus_id AS campus_id_12
FROM
  `formation` f0_

SELECT f0_.id AS id_0, f0_.duration AS duration_1, f0_.languages AS languages_2, f0_.pace AS pace_3, f0_.application_deadline AS application_deadline_4, f0_.tuition_fees AS tuition_fees_5, f0_.study_format AS study_format_6, f0_.id_salesforce AS id_salesforce_7, f0_.name AS name_8, f0_.category AS category_9, f0_.picto AS picto_10, f0_.type AS type_11, f0_.campus_id AS campus_id_12 FROM `formation` f0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
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 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
24	App\Controller\RegistrationController->register (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\Formation	No errors.
App\Entity\Campus	No errors.
App\Entity\Price	No errors.
App\Entity\Candidature	No errors.

Symfony Profiler

GET https://international.3is.fr/public/register

Configuration Settings

Theme