Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.13 ms Query time

0 Invalid entities

17 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.79 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.complement AS complement_3, c0_.zipcode AS zipcode_4, c0_.city AS city_5, c0_.college_email AS college_email_6, c0_.group_email AS group_email_7, c0_.college_phone AS college_phone_8, c0_.group_phone AS group_phone_9, c0_.animateur AS animateur_10, c0_.group_description AS group_description_11, c0_.logo_name AS logo_name_12, c0_.logo_size AS logo_size_13, c0_.header_name AS header_name_14, c0_.header_size AS header_size_15, c0_.work_meeting AS work_meeting_16, c0_.is_active AS is_active_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.user_id AS user_id_20 FROM college c0_ LEFT JOIN `user` u1_ ON c0_.user_id = u1_.id WHERE u1_.id = ? ORDER BY c0_.id ASC

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.complement AS complement_3,
  c0_.zipcode AS zipcode_4,
  c0_.city AS city_5,
  c0_.college_email AS college_email_6,
  c0_.group_email AS group_email_7,
  c0_.college_phone AS college_phone_8,
  c0_.group_phone AS group_phone_9,
  c0_.animateur AS animateur_10,
  c0_.group_description AS group_description_11,
  c0_.logo_name AS logo_name_12,
  c0_.logo_size AS logo_size_13,
  c0_.header_name AS header_name_14,
  c0_.header_size AS header_size_15,
  c0_.work_meeting AS work_meeting_16,
  c0_.is_active AS is_active_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.user_id AS user_id_20
FROM
  college c0_
  LEFT JOIN `user` u1_ ON c0_.user_id = u1_.id
WHERE
  u1_.id = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.complement AS complement_3, c0_.zipcode AS zipcode_4, c0_.city AS city_5, c0_.college_email AS college_email_6, c0_.group_email AS group_email_7, c0_.college_phone AS college_phone_8, c0_.group_phone AS group_phone_9, c0_.animateur AS animateur_10, c0_.group_description AS group_description_11, c0_.logo_name AS logo_name_12, c0_.logo_size AS logo_size_13, c0_.header_name AS header_name_14, c0_.header_size AS header_size_15, c0_.work_meeting AS work_meeting_16, c0_.is_active AS is_active_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.user_id AS user_id_20 FROM college c0_ LEFT JOIN `user` u1_ ON c0_.user_id = u1_.id WHERE u1_.id = NULL ORDER BY c0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Repository\Admin\CollegeRepository->CollegeByUser (line 40)
7	App\Controller\Webapp\ArticleController->newAdmin (line 111)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.52 ms

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 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\Webapp\ArticleController->newAdmin (line 132)
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)

0.46 ms

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 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\Webapp\ArticleController->newAdmin (line 132)
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)

0.36 ms

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 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\Webapp\ArticleController->newAdmin (line 132)
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\Webapp\Category	7
App\Entity\Gestapp\Theme	6
App\Entity\Gestapp\Support	4

Entities Mapping

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

Symfony Profiler

GET http://51.210.178.174/webapp/articles/newadmin

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping