Symfony Profiler

SELECT
  s.id,
  s.name,
  s.slug,
  s.status,
  s.default_locale,
  s.logo_path,
  s.meta_title_suffix,
  s.gtm_container_id,
  s.google_analytics_id,
  d.id AS domain_id,
  d.host,
  d.primary_domain
FROM
  school_domain d
  INNER JOIN school s ON s.id = d.school_id
WHERE
  d.host = ?
  AND d.active = 1
  AND s.status = 'active'
LIMIT
  1

SELECT
    s.id,
    s.name,
    s.slug,
    s.status,
    s.default_locale,
    s.logo_path,
    s.meta_title_suffix,
    s.gtm_container_id,
    s.google_analytics_id,
    d.id AS domain_id,
    d.host,
    d.primary_domain
FROM school_domain d
INNER JOIN school s ON s.id = d.school_id
WHERE d.host = 'demo.skillpilot.dfirma.pl'
  AND d.active = 1
  AND s.status = 'active'
LIMIT 1;

SELECT
  roles
FROM
  school_membership
WHERE
  school_id = ?
  AND user_id = ?
  AND active = 1
LIMIT
  1

SELECT roles FROM school_membership WHERE school_id = 5 AND user_id = 40 AND active = 1 LIMIT 1;

SELECT
  id
FROM
  app_user
WHERE
  email = ?
  AND active = 1
LIMIT
  1

SELECT id FROM app_user WHERE email = 'teacher1.demo@skillpilot.pl' AND active = 1 LIMIT 1;

SELECT
  l.*,
  a.status AS attendance_status,
  a.paid AS attendance_paid,
  a.notes AS attendance_notes
FROM
  group_enrollment e
  INNER JOIN learner l ON l.id = e.learner_id
  LEFT JOIN attendance a ON a.lesson_id = ?
  AND a.learner_id = l.id
WHERE
  e.class_group_id = ?
  AND e.status = 'approved'
ORDER BY
  l.last_name,
  l.first_name

SELECT l.*, a.status AS attendance_status, a.paid AS attendance_paid, a.notes AS attendance_notes
FROM group_enrollment e
INNER JOIN learner l ON l.id = e.learner_id
LEFT JOIN attendance a ON a.lesson_id = 60 AND a.learner_id = l.id
WHERE e.class_group_id = 6 AND e.status = 'approved'
ORDER BY l.last_name, l.first_name;

SELECT
  qa.*,
  l.first_name,
  l.last_name
FROM
  quiz_attempt qa
  INNER JOIN quiz q ON q.id = qa.quiz_id
  INNER JOIN learner l ON l.id = qa.learner_id
WHERE
  q.lesson_id = ?
ORDER BY
  q.id,
  qa.submitted_at DESC,
  l.last_name,
  l.first_name

SELECT qa.*, l.first_name, l.last_name
FROM quiz_attempt qa
INNER JOIN quiz q ON q.id = qa.quiz_id
INNER JOIN learner l ON l.id = qa.learner_id
WHERE q.lesson_id = 60
ORDER BY q.id, qa.submitted_at DESC, l.last_name, l.first_name;

SELECT
  qq.*
FROM
  quiz_question qq
  INNER JOIN quiz q ON q.id = qq.quiz_id
WHERE
  q.lesson_id = ?
ORDER BY
  qq.quiz_id,
  qq.position

SELECT qq.*
FROM quiz_question qq
INNER JOIN quiz q ON q.id = qq.quiz_id
WHERE q.lesson_id = 60
ORDER BY qq.quiz_id, qq.position;

SELECT
  DISTINCT gl.guardian_id AS user_id,
  gu.first_name,
  gu.last_name,
  gu.email,
  l.first_name AS learner_first_name,
  l.last_name AS learner_last_name
FROM
  group_enrollment e
  INNER JOIN learner l ON l.id = e.learner_id
  INNER JOIN guardian_link gl ON gl.learner_id = l.id
  INNER JOIN app_user gu ON gu.id = gl.guardian_id
WHERE
  e.class_group_id = ?
  AND e.status = 'approved'
ORDER BY
  gu.last_name,
  gu.first_name,
  l.last_name,
  l.first_name

SELECT DISTINCT gl.guardian_id AS user_id, gu.first_name, gu.last_name, gu.email, l.first_name AS learner_first_name, l.last_name AS learner_last_name
FROM group_enrollment e
INNER JOIN learner l ON l.id = e.learner_id
INNER JOIN guardian_link gl ON gl.learner_id = l.id
INNER JOIN app_user gu ON gu.id = gl.guardian_id
WHERE e.class_group_id = 6 AND e.status = 'approved'
ORDER BY gu.last_name, gu.first_name, l.last_name, l.first_name;

SELECT
  lesson.*,
  g.name AS group_name
FROM
  lesson
  INNER JOIN class_group g ON g.id = lesson.class_group_id
WHERE
  lesson.id = ?
  AND lesson.school_id = ?
LIMIT
  1

SELECT lesson.*, g.name AS group_name
FROM lesson
INNER JOIN class_group g ON g.id = lesson.class_group_id
WHERE lesson.id = 60 AND lesson.school_id = 5
LIMIT 1;

SELECT
  q.*,
  COUNT(DISTINCT qq.id) AS question_count,
  COUNT(DISTINCT qa.id) AS attempt_count
FROM
  quiz q
  LEFT JOIN quiz_question qq ON qq.quiz_id = q.id
  LEFT JOIN quiz_attempt qa ON qa.quiz_id = q.id
WHERE
  q.lesson_id = ?
GROUP BY
  q.id
ORDER BY
  q.created_at DESC

SELECT q.*, COUNT(DISTINCT qq.id) AS question_count, COUNT(DISTINCT qa.id) AS attempt_count
    FROM quiz q
    LEFT JOIN quiz_question qq ON qq.quiz_id = q.id
    LEFT JOIN quiz_attempt qa ON qa.quiz_id = q.id
    WHERE q.lesson_id = 60
    GROUP BY q.id
    ORDER BY q.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM app_user t0 WHERE t0.id = 40;

SELECT
  DISTINCT l.id AS learner_id,
  l.user_id,
  l.first_name,
  l.last_name,
  u.email
FROM
  group_enrollment e
  INNER JOIN learner l ON l.id = e.learner_id
  LEFT JOIN app_user u ON u.id = l.user_id
WHERE
  e.class_group_id = ?
  AND e.status = 'approved'
  AND l.user_id IS NOT NULL
ORDER BY
  l.last_name,
  l.first_name

SELECT DISTINCT l.id AS learner_id, l.user_id, l.first_name, l.last_name, u.email
FROM group_enrollment e
INNER JOIN learner l ON l.id = e.learner_id
LEFT JOIN app_user u ON u.id = l.user_id
WHERE e.class_group_id = 6 AND e.status = 'approved' AND l.user_id IS NOT NULL
ORDER BY l.last_name, l.first_name;

SELECT
  password_hash
FROM
  school_membership
WHERE
  school_id = ?
  AND user_id = ?
  AND active = 1
LIMIT
  1

SELECT password_hash
FROM school_membership
WHERE school_id = 5
    AND user_id = 40
    AND active = 1
LIMIT 1;

SELECT
  *
FROM
  learning_material
WHERE
  lesson_id = ?
  AND active = 1
ORDER BY
  created_at DESC

SELECT * FROM learning_material WHERE lesson_id = 60 AND active = 1 ORDER BY created_at DESC;

SELECT
  *
FROM
  conversation
WHERE
  lesson_id = ?
ORDER BY
  created_at DESC

SELECT * FROM conversation WHERE lesson_id = 60 ORDER BY created_at DESC;

SELECT
  id
FROM
  school_membership
WHERE
  school_id = ?
  AND user_id = ?
  AND active = 1
LIMIT
  1

SELECT id FROM school_membership WHERE school_id = 5 AND user_id = 40 AND active = 1 LIMIT 1;