Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.50 ms Query time

0 Invalid entities

42 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.04 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.complement AS complement_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.college_email AS college_email_7, t0.group_email AS group_email_8, t0.college_phone AS college_phone_9, t0.group_phone AS group_phone_10, t0.animateur AS animateur_11, t0.group_description AS group_description_12, t0.logo_name AS logo_name_13, t0.logo_size AS logo_size_14, t0.header_name AS header_name_15, t0.header_size AS header_size_16, t0.work_meeting AS work_meeting_17, t0.is_active AS is_active_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.user_id AS user_id_21 FROM college t0 WHERE t0.id = ?

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.complement AS complement_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.college_email AS college_email_7,
  t0.group_email AS group_email_8,
  t0.college_phone AS college_phone_9,
  t0.group_phone AS group_phone_10,
  t0.animateur AS animateur_11,
  t0.group_description AS group_description_12,
  t0.logo_name AS logo_name_13,
  t0.logo_size AS logo_size_14,
  t0.header_name AS header_name_15,
  t0.header_size AS header_size_16,
  t0.work_meeting AS work_meeting_17,
  t0.is_active AS is_active_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.user_id AS user_id_21
FROM
  college t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.complement AS complement_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.college_email AS college_email_7, t0.group_email AS group_email_8, t0.college_phone AS college_phone_9, t0.group_phone AS group_phone_10, t0.animateur AS animateur_11, t0.group_description AS group_description_12, t0.logo_name AS logo_name_13, t0.logo_size AS logo_size_14, t0.header_name AS header_name_15, t0.header_size AS header_size_16, t0.work_meeting AS work_meeting_17, t0.is_active AS is_active_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.user_id AS user_id_21 FROM college t0 WHERE t0.id = '6';

#	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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.78 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  22
]

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.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_activ AS is_activ_7,
  t0.is_verified AS is_verified_8,
  t0.login_name AS login_name_9,
  t0.avatar_name AS avatar_name_10,
  t0.avatar_size AS avatar_size_11,
  t0.typeuser AS typeuser_12,
  t0.adress1 AS adress1_13,
  t0.adress2 AS adress2_14,
  t0.zipcode AS zipcode_15,
  t0.city AS city_16,
  t0.phone_desk AS phone_desk_17,
  t0.phone_gsm AS phone_gsm_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM `user` t0 WHERE t0.id = 22;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\Admin\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Admin\User->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\Admin\User->__load (line 20)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 3045)
9	Doctrine\ORM\EntityManager->initializeObject (line 566)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 89)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->{closure:Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader::loadValuesForChoices():49} (line 49)
12	array_map (line 49)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader::loadValuesForChoices (line 49)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 81)
15	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 32)
16	Symfony\Component\Form\Form->normToView (line 980)
17	Symfony\Component\Form\Form->setData (line 295)
18	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 50)
19	Symfony\Component\Form\Form->setData (line 317)
20	Symfony\Component\Form\Form->initialize (line 406)
21	Symfony\Component\Form\FormBuilder->getForm (line 171)
22	Symfony\Component\Form\FormFactory->create (line 26)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 351)
24	App\Controller\Admin\CollegeController->editCollegeAdmin (line 351)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.68 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 FROM `user` u0_

Parameters:

[]

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
FROM
  `user` u0_

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 FROM `user` u0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
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 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\Admin\CollegeController->editCollegeAdmin (line 441)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Admin\User	41
App\Entity\Admin\College	1

Entities Mapping

Class	Mapping errors
App\Entity\Admin\College	No errors.
App\Entity\Admin\User	No errors.
App\Entity\Webapp\Article	No errors.
App\Entity\Webapp\Section	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 http://51.210.178.174/admin/college/6/editcollege

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping