Symfony Profiler

Query Metrics

25 Database Queries

5 Different statements

10.72 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.23 ms
(48.78%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.surname AS surname_5 FROM teacher t0 INNER JOIN teacher_department ON t0.id = teacher_department.teacher_id WHERE teacher_department.department_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.surname AS surname_5
FROM
  teacher t0
  INNER JOIN teacher_department ON t0.id = teacher_department.teacher_id
WHERE
  teacher_department.department_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.surname AS surname_5 FROM teacher t0 INNER JOIN teacher_department ON t0.id = teacher_department.teacher_id WHERE teacher_department.department_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

3.53 ms
(32.94%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.deep_value AS deep_value_3, t0.switch AS switch_4, t0.department_id AS department_id_5 FROM lesson t0 WHERE t0.department_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.deep_value AS deep_value_3,
  t0.switch AS switch_4,
  t0.department_id AS department_id_5
FROM
  lesson t0
WHERE
  t0.department_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.deep_value AS deep_value_3, t0.switch AS switch_4, t0.department_id AS department_id_5 FROM lesson t0 WHERE t0.department_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.12 ms
(10.49%)

SELECT DISTINCT d0_.id AS id_0 FROM department d0_ LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT d0_.id AS id_0
FROM
  department d0_
LIMIT
  20

SELECT DISTINCT d0_.id AS id_0 FROM department d0_ LIMIT 20;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.44 ms
(4.13%)

SELECT d0_.id AS id_0, d0_.name AS name_1 FROM department d0_ WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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_
WHERE
  d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT d0_.id AS id_0, d0_.name AS name_1 FROM department d0_ WHERE d0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11);

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.39 ms
(3.66%)

SELECT count(d0_.id) AS sclr_0 FROM department d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(d0_.id) AS sclr_0
FROM
  department d0_

SELECT count(d0_.id) AS sclr_0 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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Department	No errors.
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\Teacher	No errors.
App\Entity\ClassTime	No errors.
App\Entity\SubGroup	The mappings App\Entity\SubGroup#directionLesson and App\Entity\Lesson#subGroups are inconsistent with each other.
App\Entity\PhaseGroup	No errors.
App\Entity\ChoosedLesson	The association App\Entity\ChoosedLesson#typeClass refers to the inverse side field App\Entity\TypeClass#choosedLessons which does not exist.
App\Entity\LessonType	No errors.
App\Entity\PhaseItem	No errors.
App\Entity\Phase	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping