Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.34 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.28 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.room_id AS room_id_3 FROM room_type t0 WHERE t0.id = ?

Parameters:

[
  "25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.room_id AS room_id_3
FROM
  room_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.room_id AS room_id_3 FROM room_type t0 WHERE t0.id = '25';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 254)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 65)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 120)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.79 ms

SELECT r0_.id AS id_0, r0_.number AS number_1, r0_.capacity AS capacity_2, r0_.floor AS floor_3, r0_.name AS name_4, r0_.building_id AS building_id_5 FROM room r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.number AS number_1,
  r0_.capacity AS capacity_2,
  r0_.floor AS floor_3,
  r0_.name AS name_4,
  r0_.building_id AS building_id_5
FROM
  room r0_

SELECT r0_.id AS id_0, r0_.number AS number_1, r0_.capacity AS capacity_2, r0_.floor AS floor_3, r0_.name AS name_4, r0_.building_id AS building_id_5 FROM room r0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
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 44)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.26 ms

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19 FROM class_time t0 WHERE t0.room_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.duration_in_minutes AS duration_in_minutes_2,
  t0.length AS length_3,
  t0.tmp_count AS tmp_count_4,
  t0.start_time AS start_time_5,
  t0.end_time AS end_time_6,
  t0.group_ids AS group_ids_7,
  t0.sub_group_ids AS sub_group_ids_8,
  t0.phase_group_ids AS phase_group_ids_9,
  t0.ref_id AS ref_id_10,
  t0.phase_part AS phase_part_11,
  t0.group_id AS group_id_12,
  t0.sub_group_id AS sub_group_id_13,
  t0.lesson_id AS lesson_id_14,
  t0.department_id AS department_id_15,
  t0.teacher_id AS teacher_id_16,
  t0.phase_group_id AS phase_group_id_17,
  t0.room_id AS room_id_18,
  t0.selecting_class_time_id AS selecting_class_time_id_19
FROM
  class_time t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19 FROM class_time t0 WHERE t0.room_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 833)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 35)
11	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
12	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
15	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
16	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
17	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
18	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
19	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
20	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
21	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
22	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
23	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
24	Symfony\Component\Form\Form->createView (line 891)
25	Symfony\Component\Form\Form->createView (line 44)
26	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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\RoomType	No errors.
App\Entity\Room	No errors.
App\Entity\Building	No errors.
App\Entity\ClassTime	No errors.
App\Entity\Group	No errors.
App\Entity\SubGroup	The mappings App\Entity\SubGroup#directionLesson and App\Entity\Lesson#subGroups are inconsistent with each other.
App\Entity\Lesson	The association App\Entity\Lesson#subGroups refers to the owning side field App\Entity\SubGroup#lesson which does not exist.
App\Entity\Department	No errors.
App\Entity\Teacher	No errors.
App\Entity\PhaseGroup	No errors.
App\Entity\SelectingClassTime	No errors.

Symfony Profiler

GET https://edelar.tech/admin?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CRoomTypeCrudController&entityId=25

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping