Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.83 ms Query time

0 Invalid entities

75 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.37 ms

SELECT t0_.id AS id_0, t0_.libelle AS libelle_1 FROM type_etablissement t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.libelle AS libelle_1
FROM
  type_etablissement t0_

SELECT t0_.id AS id_0, t0_.libelle AS libelle_1 FROM type_etablissement 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 187)
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\Admin\EtablissementController->newEtablissement (line 84)
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.47 ms

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.is_activ AS is_activ_6, u0_.is_verified AS is_verified_7, u0_.login_name AS login_name_8, u0_.avatar_name AS avatar_name_9, u0_.avatar_size AS avatar_size_10, u0_.typeuser AS typeuser_11, u0_.adress1 AS adress1_12, u0_.adress2 AS adress2_13, u0_.zipcode AS zipcode_14, u0_.city AS city_15, u0_.phone_desk AS phone_desk_16, u0_.phone_gsm AS phone_gsm_17, u0_.created_at AS created_at_18, u0_.updated_at AS updated_at_19, u0_.etablissement_id AS etablissement_id_20 FROM `user` u0_ WHERE u0_.is_activ = ? AND u0_.roles LIKE ? ORDER BY u0_.id ASC

Parameters:

[
  1
  "%"ROLE_ETABLISSEMENT"%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.is_activ AS is_activ_6,
  u0_.is_verified AS is_verified_7,
  u0_.login_name AS login_name_8,
  u0_.avatar_name AS avatar_name_9,
  u0_.avatar_size AS avatar_size_10,
  u0_.typeuser AS typeuser_11,
  u0_.adress1 AS adress1_12,
  u0_.adress2 AS adress2_13,
  u0_.zipcode AS zipcode_14,
  u0_.city AS city_15,
  u0_.phone_desk AS phone_desk_16,
  u0_.phone_gsm AS phone_gsm_17,
  u0_.created_at AS created_at_18,
  u0_.updated_at AS updated_at_19,
  u0_.etablissement_id AS etablissement_id_20
FROM
  `user` u0_
WHERE
  u0_.is_activ = ?
  AND u0_.roles LIKE ?
ORDER BY
  u0_.id ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.is_activ AS is_activ_6, u0_.is_verified AS is_verified_7, u0_.login_name AS login_name_8, u0_.avatar_name AS avatar_name_9, u0_.avatar_size AS avatar_size_10, u0_.typeuser AS typeuser_11, u0_.adress1 AS adress1_12, u0_.adress2 AS adress2_13, u0_.zipcode AS zipcode_14, u0_.city AS city_15, u0_.phone_desk AS phone_desk_16, u0_.phone_gsm AS phone_gsm_17, u0_.created_at AS created_at_18, u0_.updated_at AS updated_at_19, u0_.etablissement_id AS etablissement_id_20 FROM `user` u0_ WHERE u0_.is_activ = 1 AND u0_.roles LIKE '%\"ROLE_ETABLISSEMENT\"%' ORDER BY u0_.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	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\Admin\EtablissementController->newEtablissement (line 84)
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\Admin\User	37
App\Entity\Admin\Etablissement	34
App\Entity\Admin\TypeEtablissement	4

Entities Mapping

Class	Mapping errors
App\Entity\Admin\Etablissement	No errors.
App\Entity\Admin\TypeEtablissement	No errors.
App\Entity\Admin\User	No errors.
App\Entity\Webapp\Article	No errors.
App\Entity\Gestapp\Ressources	No errors.
App\Entity\Admin\Message	No errors.
App\Entity\Webapp\Comment	No errors.
App\Entity\Webapp\Page	No errors.

Symfony Profiler

GET https://www.collegiens-citoyens.francas40.fr/webapp/etablissement/newetablissement

Configuration Settings

Theme

Page Width