Symfony Profiler

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';

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-788f-71a2-b2c1-6c8274834de0';

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-71c6-b2c1-6c82752cfeac';

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;

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-71c6-b2c1-6c82752cfeac';

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-06-13 23:59:00' AND s0_.end_at > '2478-06-13 00:00:00';

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';

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-06-13 23:59:00' AND s0_.end_at > '2478-06-13 00:00:00';

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-06-13 23:59:00' AND s0_.end_at > '2478-06-13 00:00:00';

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-06-13 23:59:00' AND s0_.end_at > '2478-06-13 00:00:00';

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-06-14 23:59:00' AND s0_.end_at > '2478-06-14 00:00:00';

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-06-14 23:59:00' AND s0_.end_at > '2478-06-14 00:00:00';

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-06-14 23:59:00' AND s0_.end_at > '2478-06-14 00:00:00';

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-06-14 23:59:00' AND s0_.end_at > '2478-06-14 00:00:00';

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-06-15 23:59:00' AND s0_.end_at > '2478-06-15 00:00:00';

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-06-15 23:59:00' AND s0_.end_at > '2478-06-15 00:00:00';

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-06-15 23:59:00' AND s0_.end_at > '2478-06-15 00:00:00';

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-06-15 23:59:00' AND s0_.end_at > '2478-06-15 00:00:00';

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-06-16 23:59:00' AND s0_.end_at > '2478-06-16 00:00:00';

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-06-16 23:59:00' AND s0_.end_at > '2478-06-16 00:00:00';

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-06-16 23:59:00' AND s0_.end_at > '2478-06-16 00:00:00';

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-06-16 23:59:00' AND s0_.end_at > '2478-06-16 00:00:00';