Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.35 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.35 ms

SELECT t0.id AS id_1, t0.type AS type_2, t3.id AS id_4, t3.time AS time_5, t3.student_id AS student_id_6, t3.lesson_id AS lesson_id_7, t3.type_class_id AS type_class_id_8, t3.group_id AS group_id_9, t10.id AS id_11, t10.time AS time_12, t10.seat_time AS seat_time_13, t10.type_class_id AS type_class_id_14 FROM type_class t0 LEFT JOIN choosed_lesson t3 ON t3.type_class_id = t0.id LEFT JOIN lesson_map t10 ON t10.type_class_id = t0.id WHERE t0.id = ?

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t3.id AS id_4,
  t3.time AS time_5,
  t3.student_id AS student_id_6,
  t3.lesson_id AS lesson_id_7,
  t3.type_class_id AS type_class_id_8,
  t3.group_id AS group_id_9,
  t10.id AS id_11,
  t10.time AS time_12,
  t10.seat_time AS seat_time_13,
  t10.type_class_id AS type_class_id_14
FROM
  type_class t0
  LEFT JOIN choosed_lesson t3 ON t3.type_class_id = t0.id
  LEFT JOIN lesson_map t10 ON t10.type_class_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t3.id AS id_4, t3.time AS time_5, t3.student_id AS student_id_6, t3.lesson_id AS lesson_id_7, t3.type_class_id AS type_class_id_8, t3.group_id AS group_id_9, t10.id AS id_11, t10.time AS time_12, t10.seat_time AS seat_time_13, t10.type_class_id AS type_class_id_14 FROM type_class t0 LEFT JOIN choosed_lesson t3 ON t3.type_class_id = t0.id LEFT JOIN lesson_map t10 ON t10.type_class_id = t0.id WHERE t0.id = '6';

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

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\TypeClass	The mappings App\Entity\TypeClass#choosedLesson and App\Entity\ChoosedLesson#typeClass are inconsistent with each other.
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\Student	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\Group	No errors.
App\Entity\LessonMap	No errors.
App\Entity\PhaseGroup	No errors.
App\Entity\SubGroup	The mappings App\Entity\SubGroup#directionLesson and App\Entity\Lesson#subGroups are inconsistent with each other.

Symfony Profiler

GET https://edelar.tech/admin?crudAction=detail&crudControllerFqcn=App%5CController%5CAdmin%5CTypeClassCrudController&entityId=6

Configuration Settings

Theme