Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.70 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.56 ms
(32.82%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.category_name AS category_name_2, c0_.category_size AS category_size_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5 FROM category c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.category_name AS category_name_2,
  c0_.category_size AS category_size_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.category_name AS category_name_2, c0_.category_size AS category_size_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5 FROM category c0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\Webapp\ArticleController->newAdmin (line 427)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
25	require_once (line 32)
26	require_once (line 5)

0.51 ms
(29.94%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.address AS address_2, e0_.complement AS complement_3, e0_.zipcode AS zipcode_4, e0_.city AS city_5, e0_.etablissement_email AS etablissement_email_6, e0_.group_email AS group_email_7, e0_.etablissement_phone AS etablissement_phone_8, e0_.group_phone AS group_phone_9, e0_.animateur AS animateur_10, e0_.group_description AS group_description_11, e0_.logo_name AS logo_name_12, e0_.logo_size AS logo_size_13, e0_.header_name AS header_name_14, e0_.header_size AS header_size_15, e0_.work_meeting AS work_meeting_16, e0_.is_active AS is_active_17, e0_.created_at AS created_at_18, e0_.updated_at AS updated_at_19, e0_.type_etablissement_id AS type_etablissement_id_20 FROM etablissement e0_ LEFT JOIN `user` u1_ ON e0_.id = u1_.etablissement_id WHERE u1_.id = ? ORDER BY e0_.id ASC

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.address AS address_2,
  e0_.complement AS complement_3,
  e0_.zipcode AS zipcode_4,
  e0_.city AS city_5,
  e0_.etablissement_email AS etablissement_email_6,
  e0_.group_email AS group_email_7,
  e0_.etablissement_phone AS etablissement_phone_8,
  e0_.group_phone AS group_phone_9,
  e0_.animateur AS animateur_10,
  e0_.group_description AS group_description_11,
  e0_.logo_name AS logo_name_12,
  e0_.logo_size AS logo_size_13,
  e0_.header_name AS header_name_14,
  e0_.header_size AS header_size_15,
  e0_.work_meeting AS work_meeting_16,
  e0_.is_active AS is_active_17,
  e0_.created_at AS created_at_18,
  e0_.updated_at AS updated_at_19,
  e0_.type_etablissement_id AS type_etablissement_id_20
FROM
  etablissement e0_
  LEFT JOIN `user` u1_ ON e0_.id = u1_.etablissement_id
WHERE
  u1_.id = ?
ORDER BY
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.address AS address_2, e0_.complement AS complement_3, e0_.zipcode AS zipcode_4, e0_.city AS city_5, e0_.etablissement_email AS etablissement_email_6, e0_.group_email AS group_email_7, e0_.etablissement_phone AS etablissement_phone_8, e0_.group_phone AS group_phone_9, e0_.animateur AS animateur_10, e0_.group_description AS group_description_11, e0_.logo_name AS logo_name_12, e0_.logo_size AS logo_size_13, e0_.header_name AS header_name_14, e0_.header_size AS header_size_15, e0_.work_meeting AS work_meeting_16, e0_.is_active AS is_active_17, e0_.created_at AS created_at_18, e0_.updated_at AS updated_at_19, e0_.type_etablissement_id AS type_etablissement_id_20 FROM etablissement e0_ LEFT JOIN `user` u1_ ON e0_.id = u1_.etablissement_id WHERE u1_.id = NULL ORDER BY e0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Admin\EtablissementRepository->EtablissementByUser (line 57)
7	App\Controller\Webapp\ArticleController->newAdmin (line 359)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.33 ms
(19.71%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.image_name AS image_name_2, t0_.image_size AS image_size_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5 FROM theme t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.image_name AS image_name_2,
  t0_.image_size AS image_size_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5
FROM
  theme t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.image_name AS image_name_2, t0_.image_size AS image_size_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5 FROM theme t0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\Webapp\ArticleController->newAdmin (line 427)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
25	require_once (line 32)
26	require_once (line 5)

0.30 ms
(17.53%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image_name AS image_name_2, s0_.image_size AS image_size_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM support s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.image_name AS image_name_2,
  s0_.image_size AS image_size_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5
FROM
  support s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image_name AS image_name_2, s0_.image_size AS image_size_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM support s0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\Webapp\ArticleController->newAdmin (line 427)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
25	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Webapp\Category	7
App\Entity\Gestapp\Theme	6
App\Entity\Gestapp\Support	4

Entities Mapping

Class	Mapping errors
App\Entity\Admin\Etablissement	No errors.
App\Entity\Admin\User	No errors.
App\Entity\Admin\TypeEtablissement	No errors.
App\Entity\Webapp\Article	No errors.
App\Entity\Webapp\Category	No errors.
App\Entity\Gestapp\Theme	No errors.
App\Entity\Gestapp\Support	No errors.
App\Entity\Webapp\Section	No errors.
App\Entity\Gestapp\Ressources	No errors.

Symfony Profiler

GET https://www.collegiens-citoyens.francas40.fr/webapp/articles/newadmin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping