GET https://planner.intevia.cloud/plan/019ba2ba-731c-75b6-a381-4c2b53a14733/schedule/lesson/019b9fdf-788f-717e-b2c1-6c8273d0777d/17/2479

Response
200 OK
IP
172.69.71.149
Profiled on
Token
bfc88a

Query Metrics

38 Database Queries
13 Different statements
36.48 ms Query time
3 Invalid entities
31 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.70 ms 
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
2 1.02 ms 
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-788f-717e-b2c1-6c8273d0777d"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.95 ms 
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-71c6-b2c1-6c82752cfeac"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.70 ms 
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
5 2.28 ms 
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-71c6-b2c1-6c82752cfeac"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 2.40 ms 
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"
  }
  "2479-04-24 23:59:00"
  "2479-04-24 00:00:00"
]
View formatted query    View runnable query    View query backtrace
7 1.89 ms 
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
8 2.67 ms 
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"
  }
  "2479-04-24 23:59:00"
  "2479-04-24 00:00:00"
]
View formatted query    View runnable query    View query backtrace
9 0.68 ms 
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: 
[
  "2479-04-24 23:59:00"
  "2479-04-24 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.72 ms 
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"
  }
  "2479-04-24 23:59:00"
  "2479-04-24 00:00:00"
]
View formatted query    View runnable query    View query backtrace
11 1.29 ms 
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"
  }
  "2479-04-25 23:59:00"
  "2479-04-25 00:00:00"
]
View formatted query    View runnable query    View query backtrace
12 2.08 ms 
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"
  }
  "2479-04-25 23:59:00"
  "2479-04-25 00:00:00"
]
View formatted query    View runnable query    View query backtrace
13 0.65 ms 
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: 
[
  "2479-04-25 23:59:00"
  "2479-04-25 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.60 ms 
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"
  }
  "2479-04-25 23:59:00"
  "2479-04-25 00:00:00"
]
View formatted query    View runnable query    View query backtrace
15 1.22 ms 
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"
  }
  "2479-04-26 23:59:00"
  "2479-04-26 00:00:00"
]
View formatted query    View runnable query    View query backtrace
16 2.02 ms 
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"
  }
  "2479-04-26 23:59:00"
  "2479-04-26 00:00:00"
]
View formatted query    View runnable query    View query backtrace
17 0.41 ms 
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: 
[
  "2479-04-26 23:59:00"
  "2479-04-26 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.38 ms 
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"
  }
  "2479-04-26 23:59:00"
  "2479-04-26 00:00:00"
]
View formatted query    View runnable query    View query backtrace
19 0.74 ms 
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"
  }
  "2479-04-27 23:59:00"
  "2479-04-27 00:00:00"
]
View formatted query    View runnable query    View query backtrace
20 1.02 ms 
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"
  }
  "2479-04-27 23:59:00"
  "2479-04-27 00:00:00"
]
View formatted query    View runnable query    View query backtrace
21 0.40 ms 
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: 
[
  "2479-04-27 23:59:00"
  "2479-04-27 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.35 ms 
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"
  }
  "2479-04-27 23:59:00"
  "2479-04-27 00:00:00"
]
View formatted query    View runnable query    View query backtrace
23 0.63 ms 
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"
  }
  "2479-04-28 23:59:00"
  "2479-04-28 00:00:00"
]
View formatted query    View runnable query    View query backtrace
24 1.00 ms 
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"
  }
  "2479-04-28 23:59:00"
  "2479-04-28 00:00:00"
]
View formatted query    View runnable query    View query backtrace
25 0.35 ms 
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: 
[
  "2479-04-28 23:59:00"
  "2479-04-28 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.37 ms 
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"
  }
  "2479-04-28 23:59:00"
  "2479-04-28 00:00:00"
]
View formatted query    View runnable query    View query backtrace
27 0.64 ms 
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"
  }
  "2479-04-29 23:59:00"
  "2479-04-29 00:00:00"
]
View formatted query    View runnable query    View query backtrace
28 1.35 ms 
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"
  }
  "2479-04-29 23:59:00"
  "2479-04-29 00:00:00"
]
View formatted query    View runnable query    View query backtrace
29 0.48 ms 
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: 
[
  "2479-04-29 23:59:00"
  "2479-04-29 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.47 ms 
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"
  }
  "2479-04-29 23:59:00"
  "2479-04-29 00:00:00"
]
View formatted query    View runnable query    View query backtrace
31 0.67 ms 
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"
  }
  "2479-04-30 23:59:00"
  "2479-04-30 00:00:00"
]
View formatted query    View runnable query    View query backtrace
32 1.06 ms 
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"
  }
  "2479-04-30 23:59:00"
  "2479-04-30 00:00:00"
]
View formatted query    View runnable query    View query backtrace
33 0.37 ms 
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: 
[
  "2479-04-30 23:59:00"
  "2479-04-30 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.38 ms 
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"
  }
  "2479-04-30 23:59:00"
  "2479-04-30 00:00:00"
]
View formatted query    View runnable query    View query backtrace
35 1.49 ms 
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
36 0.35 ms 
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
37 0.31 ms 
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-71c6-b2c1-6c82752cfeac"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.37 ms 
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

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.