| 1 |
3.27 ms |
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
Parameters: [
"demo.skillpilot.dfirma.pl"
]
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;
|
| 2 |
0.86 ms |
SELECT id FROM app_user WHERE email = ? AND active = 1 LIMIT 1
Parameters: [
"teacher1.demo@skillpilot.pl"
]
SELECT id FROM app_user WHERE email = 'teacher1.demo@skillpilot.pl' AND active = 1 LIMIT 1;
|
| 3 |
0.37 ms |
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;
|
| 4 |
0.33 ms |
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;
|
| 5 |
0.35 ms |
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;
|
| 6 |
0.41 ms |
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;
|
| 7 |
0.24 ms |
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;
|
| 8 |
0.21 ms |
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;
|
| 9 |
0.67 ms |
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;
|
| 10 |
0.31 ms |
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;
|
| 11 |
0.45 ms |
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;
|
| 12 |
0.34 ms |
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;
|
| 13 |
0.38 ms |
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;
|
| 14 |
0.48 ms |
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;
|
| 15 |
0.64 ms |
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;
|
| 16 |
0.28 ms |
SELECT * FROM conversation WHERE lesson_id = ? ORDER BY created_at DESC
SELECT * FROM conversation WHERE lesson_id = 60 ORDER BY created_at DESC;
|
| 17 |
0.28 ms |
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;
|
| 18 |
0.23 ms |
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;
|
| 19 |
0.21 ms |
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;
|
| 20 |
0.19 ms |
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;
|
| 21 |
0.19 ms |
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;
|
| 22 |
0.25 ms |
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;
|