Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.61 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.52 ms

SELECT d0_.id AS id_0, d0_.name AS name_1 FROM department d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1
FROM
  department d0_

SELECT d0_.id AS id_0, d0_.name AS name_1 FROM department d0_;

#	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.09 ms

SELECT c0_.id AS id_0, c0_.duration_in_minutes AS duration_in_minutes_1, c0_.length AS length_2, c0_.tmp_count AS tmp_count_3, c0_.start_time AS start_time_4, c0_.end_time AS end_time_5, c0_.group_ids AS group_ids_6, c0_.sub_group_ids AS sub_group_ids_7, c0_.phase_group_ids AS phase_group_ids_8, c0_.ref_id AS ref_id_9, c0_.phase_part AS phase_part_10, c0_.group_id AS group_id_11, c0_.sub_group_id AS sub_group_id_12, c0_.lesson_id AS lesson_id_13, c0_.department_id AS department_id_14, c0_.teacher_id AS teacher_id_15, c0_.phase_group_id AS phase_group_id_16, c0_.room_id AS room_id_17, c0_.selecting_class_time_id AS selecting_class_time_id_18 FROM class_time c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.duration_in_minutes AS duration_in_minutes_1,
  c0_.length AS length_2,
  c0_.tmp_count AS tmp_count_3,
  c0_.start_time AS start_time_4,
  c0_.end_time AS end_time_5,
  c0_.group_ids AS group_ids_6,
  c0_.sub_group_ids AS sub_group_ids_7,
  c0_.phase_group_ids AS phase_group_ids_8,
  c0_.ref_id AS ref_id_9,
  c0_.phase_part AS phase_part_10,
  c0_.group_id AS group_id_11,
  c0_.sub_group_id AS sub_group_id_12,
  c0_.lesson_id AS lesson_id_13,
  c0_.department_id AS department_id_14,
  c0_.teacher_id AS teacher_id_15,
  c0_.phase_group_id AS phase_group_id_16,
  c0_.room_id AS room_id_17,
  c0_.selecting_class_time_id AS selecting_class_time_id_18
FROM
  class_time c0_

SELECT c0_.id AS id_0, c0_.duration_in_minutes AS duration_in_minutes_1, c0_.length AS length_2, c0_.tmp_count AS tmp_count_3, c0_.start_time AS start_time_4, c0_.end_time AS end_time_5, c0_.group_ids AS group_ids_6, c0_.sub_group_ids AS sub_group_ids_7, c0_.phase_group_ids AS phase_group_ids_8, c0_.ref_id AS ref_id_9, c0_.phase_part AS phase_part_10, c0_.group_id AS group_id_11, c0_.sub_group_id AS sub_group_id_12, c0_.lesson_id AS lesson_id_13, c0_.department_id AS department_id_14, c0_.teacher_id AS teacher_id_15, c0_.phase_group_id AS phase_group_id_16, c0_.room_id AS room_id_17, c0_.selecting_class_time_id AS selecting_class_time_id_18 FROM class_time c0_;

#	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)

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\Teacher	No errors.
App\Entity\Department	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\PhaseGroup	No errors.
App\Entity\Room	No errors.
App\Entity\SelectingClassTime	No errors.

Symfony Profiler

GET https://edelar.tech/admin?crudAction=new&crudControllerFqcn=App%5CController%5CAdmin%5CTeacherCrudController

Configuration Settings

Theme