Symfony Profiler

Query Metrics

38 Database Queries

13 Different statements

34.05 ms Query time

3 Invalid entities

31 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.31 ms
(33.21%)

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ INNER JOIN schedule_event_student s2_ ON s0_.id = s2_.schedule_event_id INNER JOIN student s1_ ON s1_.id = s2_.student_id LEFT JOIN person p3_ ON s1_.id = p3_.id WHERE p3_.id IN (?, ?, ?, ?, ?) AND s0_.start_at < ? AND s0_.end_at > ?

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#1462
    __toString(): "019b9fdf-7841-770e-9c2a-0eb88e392eb8"
  }
  Symfony\Component\Uid\UuidV7 {#1503
    __toString(): "019b9fdf-7842-7c1e-b553-f8da5e0e88af"
  }
  Symfony\Component\Uid\UuidV7 {#1492
    __toString(): "019b9fdf-784a-7ac7-87ba-d032c2f0afa0"
  }
  Symfony\Component\Uid\UuidV7 {#1518
    __toString(): "019b9fdf-7854-7e96-93ff-90967f7ecba8"
  }
  Symfony\Component\Uid\UuidV7 {#1528
    __toString(): "019b9fdf-7857-7579-9d41-c6658edc42ad"
  }
  "2478-03-14 23:59:00"
  "2478-03-14 00:00:00"
]

View formatted query View runnable query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  s0_.lesson_id AS lesson_id_3,
  s0_.trainer_id AS trainer_id_4,
  s0_.plan_id AS plan_id_5,
  s0_.location_id AS location_id_6
FROM
  schedule_event s0_
  INNER JOIN schedule_event_student s2_ ON s0_.id = s2_.schedule_event_id
  INNER JOIN student s1_ ON s1_.id = s2_.student_id
  LEFT JOIN person p3_ ON s1_.id = p3_.id
WHERE
  p3_.id IN (?, ?, ?, ?, ?)
  AND s0_.start_at < ?
  AND s0_.end_at > ?

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ INNER JOIN schedule_event_student s2_ ON s0_.id = s2_.schedule_event_id INNER JOIN student s1_ ON s1_.id = s2_.student_id LEFT JOIN person p3_ ON s1_.id = p3_.id WHERE p3_.id IN ('019b9fdf-7841-770e-9c2a-0eb88e392eb8', '019b9fdf-7842-7c1e-b553-f8da5e0e88af', '019b9fdf-784a-7ac7-87ba-d032c2f0afa0', '019b9fdf-7854-7e96-93ff-90967f7ecba8', '019b9fdf-7857-7579-9d41-c6658edc42ad') AND s0_.start_at < '2478-03-14 23:59:00' AND s0_.end_at > '2478-03-14 00:00:00';

#	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->getResult (line 689)
6	App\Repository\ScheduleEventRepository->findOverlappingEventsForStudents (line 56)
7	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 40)
8	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
9	App\Controller\Schedule\ScheduleController->schedule (line 23)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

7.32 ms
(21.50%)

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ INNER JOIN trainer t1_ ON s0_.trainer_id = t1_.id LEFT JOIN person p2_ ON t1_.id = p2_.id WHERE p2_.id IN (?, ?, ?, ?, ?, ?) AND s0_.start_at < ? AND s0_.end_at > ?

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#1335
    __toString(): "019b9fdf-7858-7b5e-b37a-c536df05126c"
  }
  Symfony\Component\Uid\UuidV7 {#1346
    __toString(): "019b9fdf-7858-7d72-b37a-c536dfeb3fcc"
  }
  Symfony\Component\Uid\UuidV7 {#1352
    __toString(): "019b9fdf-7859-7719-86b8-bba96e37f992"
  }
  Symfony\Component\Uid\UuidV7 {#1358
    __toString(): "019b9fdf-785a-77bb-8d9b-39e6c67c9ee7"
  }
  Symfony\Component\Uid\UuidV7 {#1364
    __toString(): "019b9fdf-785a-79cb-8d9b-39e6c7703d11"
  }
  Symfony\Component\Uid\UuidV7 {#1370
    __toString(): "019b9fdf-785b-72be-8e32-5e8d7e677b5e"
  }
  "2478-03-14 23:59:00"
  "2478-03-14 00:00:00"
]

View formatted query View runnable query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  s0_.lesson_id AS lesson_id_3,
  s0_.trainer_id AS trainer_id_4,
  s0_.plan_id AS plan_id_5,
  s0_.location_id AS location_id_6
FROM
  schedule_event s0_
  INNER JOIN trainer t1_ ON s0_.trainer_id = t1_.id
  LEFT JOIN person p2_ ON t1_.id = p2_.id
WHERE
  p2_.id IN (?, ?, ?, ?, ?, ?)
  AND s0_.start_at < ?
  AND s0_.end_at > ?

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ INNER JOIN trainer t1_ ON s0_.trainer_id = t1_.id LEFT JOIN person p2_ ON t1_.id = p2_.id WHERE p2_.id IN ('019b9fdf-7858-7b5e-b37a-c536df05126c', '019b9fdf-7858-7d72-b37a-c536dfeb3fcc', '019b9fdf-7859-7719-86b8-bba96e37f992', '019b9fdf-785a-77bb-8d9b-39e6c67c9ee7', '019b9fdf-785a-79cb-8d9b-39e6c7703d11', '019b9fdf-785b-72be-8e32-5e8d7e677b5e') AND s0_.start_at < '2478-03-14 23:59:00' AND s0_.end_at > '2478-03-14 00:00:00';

#	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->getResult (line 689)
6	App\Repository\ScheduleEventRepository->findOverlappingEventsForTrainers (line 41)
7	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 39)
8	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
9	App\Controller\Schedule\ScheduleController->schedule (line 23)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

3.60 ms
(10.57%)

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ WHERE s0_.start_at < ? AND s0_.end_at > ?

Parameters:

[
  "2478-03-14 23:59:00"
  "2478-03-14 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  s0_.lesson_id AS lesson_id_3,
  s0_.trainer_id AS trainer_id_4,
  s0_.plan_id AS plan_id_5,
  s0_.location_id AS location_id_6
FROM
  schedule_event s0_
WHERE
  s0_.start_at < ?
  AND s0_.end_at > ?

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ WHERE s0_.start_at < '2478-03-14 23:59:00' AND s0_.end_at > '2478-03-14 00:00:00';

#	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->getResult (line 689)
6	App\Repository\ScheduleEventRepository->findOverlappingEventsForLocations (line 67)
7	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 41)
8	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
9	App\Controller\Schedule\ScheduleController->schedule (line 23)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

3.26 ms
(9.59%)

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ WHERE s0_.plan_id = ? AND s0_.start_at < ? AND s0_.end_at > ?

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#711
    __toString(): "019ba2ba-731c-75b6-a381-4c2b53a14733"
  }
  "2478-03-14 23:59:00"
  "2478-03-14 00:00:00"
]

View formatted query View runnable query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  s0_.lesson_id AS lesson_id_3,
  s0_.trainer_id AS trainer_id_4,
  s0_.plan_id AS plan_id_5,
  s0_.location_id AS location_id_6
FROM
  schedule_event s0_
WHERE
  s0_.plan_id = ?
  AND s0_.start_at < ?
  AND s0_.end_at > ?

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.lesson_id AS lesson_id_3, s0_.trainer_id AS trainer_id_4, s0_.plan_id AS plan_id_5, s0_.location_id AS location_id_6 FROM schedule_event s0_ WHERE s0_.plan_id = '019ba2ba-731c-75b6-a381-4c2b53a14733' AND s0_.start_at < '2478-03-14 23:59:00' AND s0_.end_at > '2478-03-14 00:00:00';

#	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->getResult (line 689)
6	App\Repository\ScheduleEventRepository->findPlanEvents (line 148)
7	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 44)
8	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
9	App\Controller\Schedule\ScheduleController->schedule (line 23)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

1.68 ms
(4.94%)

SELECT t1.id AS id_2, t1.name AS name_3, t1.surname AS surname_4, t1.email AS email_5, t1.phone_number AS phone_number_6, t1.type FROM trainer t0 INNER JOIN person t1 ON t0.id = t1.id INNER JOIN course_trainer ON t0.id = course_trainer.trainer_id WHERE course_trainer.course_id = ?

Parameters:

[
  "019b9fdf-788f-707e-b2c1-6c82723dcbc8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.surname AS surname_4,
  t1.email AS email_5,
  t1.phone_number AS phone_number_6,
  t1.type
FROM
  trainer t0
  INNER JOIN person t1 ON t0.id = t1.id
  INNER JOIN course_trainer ON t0.id = course_trainer.trainer_id
WHERE
  course_trainer.course_id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.surname AS surname_4, t1.email AS email_5, t1.phone_number AS phone_number_6, t1.type FROM trainer t0 INNER JOIN person t1 ON t0.id = t1.id INNER JOIN course_trainer ON t0.id = course_trainer.trainer_id WHERE course_trainer.course_id = '019b9fdf-788f-707e-b2c1-6c82723dcbc8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 157)
7	App\Repository\ScheduleEventRepository->findOverlappingEventsForTrainers (line 38)
8	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 39)
9	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
10	App\Controller\Schedule\ScheduleController->schedule (line 23)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.61 ms
(4.73%)

SELECT t1.id AS id_2, t1.name AS name_3, t1.surname AS surname_4, t1.email AS email_5, t1.phone_number AS phone_number_6, t1.type FROM student t0 INNER JOIN person t1 ON t0.id = t1.id INNER JOIN plan_student ON t0.id = plan_student.student_id WHERE plan_student.plan_id = ?

Parameters:

[
  "019ba2ba-731c-75b6-a381-4c2b53a14733"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.surname AS surname_4,
  t1.email AS email_5,
  t1.phone_number AS phone_number_6,
  t1.type
FROM
  student t0
  INNER JOIN person t1 ON t0.id = t1.id
  INNER JOIN plan_student ON t0.id = plan_student.student_id
WHERE
  plan_student.plan_id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.surname AS surname_4, t1.email AS email_5, t1.phone_number AS phone_number_6, t1.type FROM student t0 INNER JOIN person t1 ON t0.id = t1.id INNER JOIN plan_student ON t0.id = plan_student.student_id WHERE plan_student.plan_id = '019ba2ba-731c-75b6-a381-4c2b53a14733';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 157)
7	App\Repository\ScheduleEventRepository->findOverlappingEventsForStudents (line 52)
8	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 40)
9	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
10	App\Controller\Schedule\ScheduleController->schedule (line 23)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

1.07 ms
(3.15%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.name AS name_3 FROM plan t0 WHERE t0.id = ?

Parameters:

[
  "019ba2ba-731c-75b6-a381-4c2b53a14733"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.name AS name_3
FROM
  plan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.name AS name_3 FROM plan t0 WHERE t0.id = '019ba2ba-731c-75b6-a381-4c2b53a14733';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.92 ms
(2.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.duration AS duration_4, t0.course_id AS course_id_5 FROM lesson t0 WHERE t0.id = ?

Parameters:

[
  "019b9fdf-788e-7f3f-833d-5b3c698eb19b"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.note AS note_3,
  t0.duration AS duration_4,
  t0.course_id AS course_id_5
FROM
  lesson t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.duration AS duration_4, t0.course_id AS course_id_5 FROM lesson t0 WHERE t0.id = '019b9fdf-788e-7f3f-833d-5b3c698eb19b';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.80 ms
(2.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.course_type AS course_type_4, t0.validity_duration AS validity_duration_5, t0.min_capacity AS min_capacity_6, t0.max_capacity AS max_capacity_7 FROM course t0 WHERE t0.id = ?

Parameters:

[
  "019b9fdf-788f-707e-b2c1-6c82723dcbc8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.note AS note_3,
  t0.course_type AS course_type_4,
  t0.validity_duration AS validity_duration_5,
  t0.min_capacity AS min_capacity_6,
  t0.max_capacity AS max_capacity_7
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.course_type AS course_type_4, t0.validity_duration AS validity_duration_5, t0.min_capacity AS min_capacity_6, t0.max_capacity AS max_capacity_7 FROM course t0 WHERE t0.id = '019b9fdf-788f-707e-b2c1-6c82723dcbc8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\Course::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Course->__get (line 153)
7	App\Entity\Course->getTrainers (line 224)
8	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 27)
9	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
10	App\Controller\Schedule\ScheduleController->schedule (line 23)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.72 ms
(2.10%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.max_capacity AS max_capacity_3 FROM location t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.max_capacity AS max_capacity_3
FROM
  location t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.max_capacity AS max_capacity_3 FROM location t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\Schedule\ScheduleChecker->checkDaysForAll (line 29)
6	App\Service\Schedule\CalendarHydrator->hydrateWeekDetail (line 28)
7	App\Controller\Schedule\ScheduleController->schedule (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.70 ms
(2.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.course_type AS course_type_4, t0.validity_duration AS validity_duration_5, t0.min_capacity AS min_capacity_6, t0.max_capacity AS max_capacity_7 FROM course t0 INNER JOIN plan_course ON t0.id = plan_course.course_id WHERE plan_course.plan_id = ?

Parameters:

[
  "019ba2ba-731c-75b6-a381-4c2b53a14733"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.note AS note_3,
  t0.course_type AS course_type_4,
  t0.validity_duration AS validity_duration_5,
  t0.min_capacity AS min_capacity_6,
  t0.max_capacity AS max_capacity_7
FROM
  course t0
  INNER JOIN plan_course ON t0.id = plan_course.course_id
WHERE
  plan_course.plan_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.course_type AS course_type_4, t0.validity_duration AS validity_duration_5, t0.min_capacity AS min_capacity_6, t0.max_capacity AS max_capacity_7 FROM course t0 INNER JOIN plan_course ON t0.id = plan_course.course_id WHERE plan_course.plan_id = '019ba2ba-731c-75b6-a381-4c2b53a14733';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Plan->getIsPlanValid (line 173)
8	App\Controller\Schedule\ScheduleController->schedule (line 33)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.68 ms
(2.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.duration AS duration_4, t0.course_id AS course_id_5 FROM lesson t0 WHERE t0.course_id = ?

Parameters:

[
  "019b9fdf-788f-707e-b2c1-6c82723dcbc8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.note AS note_3,
  t0.duration AS duration_4,
  t0.course_id AS course_id_5
FROM
  lesson t0
WHERE
  t0.course_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.duration AS duration_4, t0.course_id AS course_id_5 FROM lesson t0 WHERE t0.course_id = '019b9fdf-788f-707e-b2c1-6c82723dcbc8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Plan->getIsPlanValid (line 174)
8	App\Controller\Schedule\ScheduleController->schedule (line 33)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.37 ms
(1.07%)

SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.lesson_id AS lesson_id_4, t0.trainer_id AS trainer_id_5, t0.plan_id AS plan_id_6, t0.location_id AS location_id_7 FROM schedule_event t0 WHERE t0.plan_id = ?

Parameters:

[
  "019ba2ba-731c-75b6-a381-4c2b53a14733"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_at AS start_at_2,
  t0.end_at AS end_at_3,
  t0.lesson_id AS lesson_id_4,
  t0.trainer_id AS trainer_id_5,
  t0.plan_id AS plan_id_6,
  t0.location_id AS location_id_7
FROM
  schedule_event t0
WHERE
  t0.plan_id = ?

SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.lesson_id AS lesson_id_4, t0.trainer_id AS trainer_id_5, t0.plan_id AS plan_id_6, t0.location_id AS location_id_7 FROM schedule_event t0 WHERE t0.plan_id = '019ba2ba-731c-75b6-a381-4c2b53a14733';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Plan->getIsPlanValid (line 179)
8	App\Controller\Schedule\ScheduleController->schedule (line 33)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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\Person	11
App\Entity\Lesson	9
App\Entity\Location	8
App\Entity\Course	2
App\Entity\Plan	1

Entities Mapping

Class	Mapping errors
App\Entity\Plan	No errors.
App\Entity\Person	No errors.
App\Entity\Student	No errors.
App\Entity\Course	The field App\Entity\Course#plannedCourses is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Course#plannedCourses does not contain the required 'mappedBy: "plannedCourses"' attribute. The field App\Entity\Course#completedCourses is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Course#completedCourses does not contain the required 'mappedBy: "completedCourses"' attribute. The field App\Entity\Course#validCourses is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Course#validCourses does not contain the required 'mappedBy: "validCourses"' attribute.
App\Entity\ScheduleEvent	The mappings App\Entity\ScheduleEvent#location and App\Entity\Location#scheduleEvents are inconsistent with each other.
App\Entity\Lesson	No errors.
App\Entity\CourseGroup	No errors.
App\Entity\Trainer	No errors.
App\Entity\Item	No errors.
App\Entity\CompletedCourse	No errors.
App\Entity\Location	The association App\Entity\Location#scheduleEvents refers to the owning side field App\Entity\ScheduleEvent#Location which does not exist.
App\Entity\StudentGroup	No errors.

Symfony Profiler

GET https://planner.intevia.cloud/plan/019ba2ba-731c-75b6-a381-4c2b53a14733/schedule/lesson/019b9fdf-788e-7f3f-833d-5b3c698eb19b/11/2478

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping