Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.name AS name_13,
  t0.surname AS surname_14,
  t0.github AS github_15,
  t0.github_id AS github_id_16,
  t0.phone AS phone_17,
  t0.avatar AS avatar_18,
  t0.google_id AS google_id_19,
  t0.google_access_token AS google_access_token_20,
  t0.google_refresh_token AS google_refresh_token_21,
  t0.github_access_token AS github_access_token_22,
  t0.language AS language_23,
  t0.show_welcome_page AS show_welcome_page_24,
  t0.terms AS terms_25,
  t0.created AS created_26
FROM
  fos_user t0
WHERE
  t0.email_canonical = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.name AS name_13, t0.surname AS surname_14, t0.github AS github_15, t0.github_id AS github_id_16, t0.phone AS phone_17, t0.avatar AS avatar_18, t0.google_id AS google_id_19, t0.google_access_token AS google_access_token_20, t0.google_refresh_token AS google_refresh_token_21, t0.github_access_token AS github_access_token_22, t0.language AS language_23, t0.show_welcome_page AS show_welcome_page_24, t0.terms AS terms_25, t0.created AS created_26 FROM fos_user t0 WHERE t0.email_canonical = 'vojtech.kosnar@email.cz' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  fos_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE fos_user SET last_login = '2025-08-25 11:32:41' WHERE id = 680;

INSERT INTO revisions (timestamp, username)
VALUES
  (?, ?)

INSERT INTO revisions (timestamp, username) VALUES ('2025-08-25 11:32:41', 'vojtech.kosnar@email.cz');

INSERT INTO fos_user_audit (
  rev, revtype, username, username_canonical,
  email, email_canonical, enabled,
  salt, password, last_login, confirmation_token,
  password_requested_at, roles, id,
  name, surname, github, github_id,
  phone, avatar, google_id, google_access_token,
  google_refresh_token, github_access_token,
  language, show_welcome_page, terms,
  created
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO fos_user_audit (rev, revtype, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, id, name, surname, github, github_id, phone, avatar, google_id, google_access_token, google_refresh_token, github_access_token, language, show_welcome_page, terms, created) VALUES ('501074', 'UPD', 'vojtech.kosnar@email.cz', 'vojtech.kosnar@email.cz', 'vojtech.kosnar@email.cz', 'vojtech.kosnar@email.cz', 1, NULL, '$argon2id$v=19$m=65536,t=4,p=1$rKIh8EuFzC3knDHiY5Jx4A$9wnIOw+7pmoVDRQtB1I+lyA4uGk7DoVO0llcvsG/6/Q', '2025-08-25 11:32:41', NULL, NULL, 'a:0:{}', 680, 'vojtech', 'kosnar', NULL, NULL, '000000000', '', NULL, NULL, NULL, NULL, 'en', 1, NULL, NULL);

"COMMIT"

"COMMIT";

UPDATE
  fos_user_audit
SET
  last_login = ?
WHERE
  rev = ?
  AND id = ?

UPDATE fos_user_audit SET last_login = '2025-08-25 11:32:41' WHERE rev = '501074'  AND id = 680;

SELECT
  roles
FROM
  fos_user
WHERE
  id = :uid

SELECT roles FROM fos_user WHERE id = 680;

SELECT
  distinct cm.number,
  c.id
FROM
  materials_pill_material pm
  JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
  JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
  JOIN materials_course_module cm ON cm.id = cc.module_id
  JOIN materials_course c ON c.id = cm.course_id
  JOIN instance i on i.course_id = c.id
  JOIN ia_user_access ua on i.id = ua.instance_id
  AND ua.user_id = :uid
  JOIN ia_user_module_access uma on ua.id = uma.user_access_id
  and cm.number = uma.module_nr
WHERE
  pm.id = :mid
  and pm.access in (:access)
  AND cc.type not in (:exam, :examProject)
  and uma.is_granted = 1
UNION ALL
SELECT
  distinct cm.number,
  c.id
FROM
  materials_pill_material pm
  JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
  JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
  JOIN materials_course_module cm ON cm.id = cc.module_id
  JOIN materials_course c ON c.id = cm.course_id
  JOIN instance i on i.course_id = c.id
  JOIN ia_user_access ua on i.id = ua.instance_id
  AND ua.user_id = :uid
  JOIN ia_user_exam_access uea on ua.id = uea.user_access_id
  and cm.number = uea.module_nr
  and cc.number = uea.chapter_nr
WHERE
  pm.id = :mid
  and pm.access in (:access)
  AND cc.type in (:exam, :examProject)
  and uea.is_granted = 1

SELECT distinct cm.number, c.id
FROM materials_pill_material pm
         JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
         JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
         JOIN materials_course_module cm ON cm.id = cc.module_id
         JOIN materials_course c ON c.id = cm.course_id
         JOIN instance i on i.course_id = c.id
         JOIN ia_user_access ua on i.id = ua.instance_id AND ua.user_id = 680
         JOIN ia_user_module_access uma on ua.id = uma.user_access_id and cm.number = uma.module_nr
WHERE pm.id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
  and pm.access in ('student', 'all')
  AND cc.type not in ('exam', 'exam_project')
  and uma.is_granted = 1
UNION ALL
SELECT distinct cm.number, c.id
FROM materials_pill_material pm
         JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
         JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
         JOIN materials_course_module cm ON cm.id = cc.module_id
         JOIN materials_course c ON c.id = cm.course_id
         JOIN instance i on i.course_id = c.id
         JOIN ia_user_access ua on i.id = ua.instance_id AND ua.user_id = 680
         JOIN ia_user_exam_access uea on ua.id = uea.user_access_id and cm.number = uea.module_nr and cc.number = uea.chapter_nr
WHERE pm.id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
  and pm.access in ('student', 'all')
  AND cc.type in ('exam', 'exam_project')
  and uea.is_granted = 1;

SELECT
  distinct count(1) as has_access
FROM
  materials_pill_material pm
  JOIN materials_course_tree mct ON pm.id = mct.material_id
  JOIN materials_course mc ON mc.id = mct.course_id
  JOIN user_language ul ON ul.language_id = mc.technology_id
WHERE
  pm.id = :mid
  AND ul.user_id = :uid;

SELECT distinct count(1) as has_access FROM materials_pill_material pm
            JOIN materials_course_tree mct ON pm.id = mct.material_id
            JOIN materials_course mc ON mc.id = mct.course_id
            JOIN user_language ul ON ul.language_id = mc.technology_id
            WHERE pm.id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7' AND ul.user_id = 680;
        ;

SELECT
  mct.module_id,
  mct.chapter_id
FROM
  materials_course_tree mct
  JOIN instance i on mct.course_id = i.course_id
WHERE
  i.id = :instanceId
  AND mct.module_nr = :module
  AND mct.chapter_nr = :chapter
  AND mct.material_id = :material

SELECT mct.module_id, mct.chapter_id
FROM materials_course_tree mct
JOIN instance i on mct.course_id = i.course_id
WHERE i.id = '1788' AND mct.module_nr = 0 AND mct.chapter_nr = 2 AND mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7';

SELECT
  pm.type,
  pm.name source_name,
  pm.access,
  mpmt.tags
FROM
  materials_pill_material pm
  LEFT JOIN (
    SELECT
      material_id,
      GROUP_CONCAT(
        mpmt.name
        ORDER BY
          mpmt.name
      ) tags
    FROM
      materials_pill_materials_tags t
      JOIN materials_pill_material_tag mpmt on t.tag_id = mpmt.id
    WHERE
      t.material_id = :id
    GROUP BY
      t.material_id
  ) mpmt on pm.id = mpmt.material_id
WHERE
  pm.id = :id

SELECT pm.type, 
                   pm.name source_name,
                   pm.access,
                   mpmt.tags
            FROM materials_pill_material pm
            LEFT JOIN (
                SELECT material_id, GROUP_CONCAT(mpmt.name ORDER BY mpmt.name) tags
                FROM materials_pill_materials_tags t
                JOIN materials_pill_material_tag mpmt on t.tag_id = mpmt.id
                WHERE t.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
                GROUP BY t.material_id
            ) mpmt on pm.id = mpmt.material_id
            WHERE pm.id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
        ;

SELECT
  mc.technology_id,
  mc.version,
  mc.mode,
  mcm.number module_nr,
  mcs.number chapter_nr,
  mpv.pill_id pill_id,
  mpm.name name,
  mpm.access access,
  mpm.type type,
  mc.language
FROM
  materials_course mc
  JOIN materials_course_module mcm on mc.id = mcm.course_id
  JOIN materials_course_chapter mcs on mcm.id = mcs.module_id
  JOIN materials_course_chapter_pill_version mccpv on mcs.id = mccpv.chapter_id
  JOIN materials_pill_version mpv on mccpv.pill_version_id = mpv.id
  JOIN materials_pill_material mpm on mpv.id = mpm.version_id
WHERE
  mcs.id = :chapter_id
  AND mpm.id = :material_id;

SELECT mc.technology_id,
       mc.version,
       mc.mode,
       mcm.number module_nr,
       mcs.number chapter_nr,
       mpv.pill_id pill_id,
       mpm.name name,
       mpm.access access,
       mpm.type type,
       mc.language
FROM materials_course mc
JOIN materials_course_module mcm on mc.id = mcm.course_id
JOIN materials_course_chapter mcs on mcm.id = mcs.module_id
JOIN materials_course_chapter_pill_version mccpv on mcs.id = mccpv.chapter_id
JOIN materials_pill_version mpv on mccpv.pill_version_id = mpv.id    
JOIN materials_pill_material mpm on mpv.id = mpm.version_id 
WHERE mcs.id = 'af62d912-8edd-4ec1-8cac-a9303f46e6da' AND mpm.id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7';;

SELECT
  q.*
FROM
  materials_quiz q
  JOIN materials_pill_material mpm on q.id = mpm.quiz_id
WHERE
  mpm.id = :id

SELECT q.* FROM materials_quiz q
JOIN materials_pill_material mpm on q.id = mpm.quiz_id
WHERE mpm.id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7';

SELECT
  c.id
FROM
  materials_course c
  INNER JOIN instance i ON c.id = i.course_id
WHERE
  i.id = :instance_id

SELECT c.id FROM materials_course c INNER JOIN instance i ON c.id = i.course_id WHERE i.id = '1788';

SELECT
  c.language
FROM
  materials_course c
  INNER JOIN instance i ON c.id = i.course_id
WHERE
  i.id = :instance_id

SELECT c.language FROM materials_course c INNER JOIN instance i ON c.id = i.course_id WHERE i.id = '1788';

SELECT
  mr.grade,
  mr.justification
FROM
  materials_pill_material_review mr
WHERE
  (mr.material_id = :materialId)
  AND (mr.author_id = :authorId)

SELECT mr.grade, mr.justification FROM materials_pill_material_review mr WHERE (mr.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7') AND (mr.author_id = 680);

SELECT
  mc.material_id,
  lsr.max_score,
  lsr.score,
  lsr.criterion
FROM
  learning_student_results lsrs
  JOIN learning_student_criteria_group_result lcg on lcg.student_results_id = lsrs.id
  JOIN learning_student_result lsr on lsr.criteria_group_result_id = lcg.id
  JOIN materials_pill_material_criteria mc on lsr.material_criterion_id = mc.id
WHERE
  lsrs.course_instance_id = :instance
  AND lsrs.student_id = :user
  AND mc.material_id = :material
  AND lsr.is_binding = 1
UNION ALL
SELECT
  mpmc.material_id,
  COALESCE(mpmc.max_score, 0),
  0,
  100
FROM
  materials_pill_material_criteria mpmc
WHERE
  mpmc.material_id = :material

SELECT mc.material_id,
       lsr.max_score,
       lsr.score,
       lsr.criterion
FROM learning_student_results lsrs
JOIN learning_student_criteria_group_result lcg on lcg.student_results_id = lsrs.id
JOIN learning_student_result lsr on lsr.criteria_group_result_id = lcg.id
JOIN materials_pill_material_criteria mc on lsr.material_criterion_id = mc.id
WHERE lsrs.course_instance_id = '1788' AND lsrs.student_id = '680' 
  AND mc.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7' AND lsr.is_binding = 1
UNION ALL
SELECT mpmc.material_id,
       COALESCE(mpmc.max_score, 0),
       0,
       100
FROM materials_pill_material_criteria mpmc
WHERE mpmc.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7';

SELECT
  iaua.role
FROM
  ia_user_access iaua
  JOIN instance i ON i.id = iaua.instance_id
  JOIN materials_course mc on i.course_id = mc.id
  JOIN materials_course_module mcm on mc.id = mcm.course_id
  JOIN materials_course_chapter mcc on mcm.id = mcc.module_id
WHERE
  iaua.user_id = :uid
  AND mcc.id = :cid

SELECT iaua.role FROM ia_user_access iaua
            JOIN instance i ON i.id = iaua.instance_id
            JOIN materials_course mc on i.course_id = mc.id
            JOIN materials_course_module mcm on mc.id = mcm.course_id
            JOIN materials_course_chapter mcc on mcm.id = mcc.module_id
            WHERE iaua.user_id = 680 AND mcc.id = 'af62d912-8edd-4ec1-8cac-a9303f46e6da'
        ;

SELECT
  mct_prev.material_id,
  mct_prev.chapter_id,
  mct_prev.chapter_nr,
  mct_prev.module_nr
FROM
  materials_course_tree mct
  LEFT JOIN materials_course_tree mct_prev on (
    mct.material_student_sequence - 1
  ) = mct_prev.material_student_sequence
  AND mct_prev.course_id = mct.course_id
WHERE
  mct.material_id = :mat_id
  AND mct.chapter_id = :chap_id
UNION ALL
SELECT
  mct_next.material_id,
  mct_next.chapter_id,
  mct_next.chapter_nr,
  mct_next.module_nr
FROM
  materials_course_tree mct
  LEFT JOIN materials_course_tree mct_next on (
    mct.material_student_sequence + 1
  ) = mct_next.material_student_sequence
  AND mct_next.course_id = mct.course_id
WHERE
  mct.material_id = :mat_id
  AND mct.chapter_id = :chap_id

SELECT mct_prev.material_id, mct_prev.chapter_id, mct_prev.chapter_nr, mct_prev.module_nr
FROM materials_course_tree mct
LEFT JOIN materials_course_tree mct_prev on (mct.material_student_sequence - 1) = mct_prev.material_student_sequence 
                                                AND mct_prev.course_id = mct.course_id
WHERE mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7' AND mct.chapter_id = 'af62d912-8edd-4ec1-8cac-a9303f46e6da'
UNION ALL
SELECT mct_next.material_id, mct_next.chapter_id, mct_next.chapter_nr, mct_next.module_nr
FROM materials_course_tree mct
LEFT JOIN materials_course_tree mct_next on (mct.material_student_sequence + 1) = mct_next.material_student_sequence 
                                                AND mct_next.course_id = mct.course_id
WHERE mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7' AND mct.chapter_id = 'af62d912-8edd-4ec1-8cac-a9303f46e6da';

SELECT
  distinct cm.number,
  c.id
FROM
  materials_pill_material pm
  JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
  JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
  JOIN materials_course_module cm ON cm.id = cc.module_id
  JOIN materials_course c ON c.id = cm.course_id
  JOIN instance i on i.course_id = c.id
  JOIN ia_user_access ua on i.id = ua.instance_id
  AND ua.user_id = :uid
  JOIN ia_user_module_access uma on ua.id = uma.user_access_id
  and cm.number = uma.module_nr
WHERE
  pm.id = :mid
  and pm.access in (:access)
  AND cc.type not in (:exam, :examProject)
  and uma.is_granted = 1
UNION ALL
SELECT
  distinct cm.number,
  c.id
FROM
  materials_pill_material pm
  JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
  JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
  JOIN materials_course_module cm ON cm.id = cc.module_id
  JOIN materials_course c ON c.id = cm.course_id
  JOIN instance i on i.course_id = c.id
  JOIN ia_user_access ua on i.id = ua.instance_id
  AND ua.user_id = :uid
  JOIN ia_user_exam_access uea on ua.id = uea.user_access_id
  and cm.number = uea.module_nr
  and cc.number = uea.chapter_nr
WHERE
  pm.id = :mid
  and pm.access in (:access)
  AND cc.type in (:exam, :examProject)
  and uea.is_granted = 1

SELECT distinct cm.number, c.id
FROM materials_pill_material pm
         JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
         JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
         JOIN materials_course_module cm ON cm.id = cc.module_id
         JOIN materials_course c ON c.id = cm.course_id
         JOIN instance i on i.course_id = c.id
         JOIN ia_user_access ua on i.id = ua.instance_id AND ua.user_id = 680
         JOIN ia_user_module_access uma on ua.id = uma.user_access_id and cm.number = uma.module_nr
WHERE pm.id = 'eae47981-0776-4278-b5f5-1d4926b2a90f'
  and pm.access in ('student', 'all')
  AND cc.type not in ('exam', 'exam_project')
  and uma.is_granted = 1
UNION ALL
SELECT distinct cm.number, c.id
FROM materials_pill_material pm
         JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
         JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
         JOIN materials_course_module cm ON cm.id = cc.module_id
         JOIN materials_course c ON c.id = cm.course_id
         JOIN instance i on i.course_id = c.id
         JOIN ia_user_access ua on i.id = ua.instance_id AND ua.user_id = 680
         JOIN ia_user_exam_access uea on ua.id = uea.user_access_id and cm.number = uea.module_nr and cc.number = uea.chapter_nr
WHERE pm.id = 'eae47981-0776-4278-b5f5-1d4926b2a90f'
  and pm.access in ('student', 'all')
  AND cc.type in ('exam', 'exam_project')
  and uea.is_granted = 1;

SELECT
  distinct cm.number,
  c.id
FROM
  materials_pill_material pm
  JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
  JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
  JOIN materials_course_module cm ON cm.id = cc.module_id
  JOIN materials_course c ON c.id = cm.course_id
  JOIN instance i on i.course_id = c.id
  JOIN ia_user_access ua on i.id = ua.instance_id
  AND ua.user_id = :uid
  JOIN ia_user_module_access uma on ua.id = uma.user_access_id
  and cm.number = uma.module_nr
WHERE
  pm.id = :mid
  and pm.access in (:access)
  AND cc.type not in (:exam, :examProject)
  and uma.is_granted = 1
UNION ALL
SELECT
  distinct cm.number,
  c.id
FROM
  materials_pill_material pm
  JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
  JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
  JOIN materials_course_module cm ON cm.id = cc.module_id
  JOIN materials_course c ON c.id = cm.course_id
  JOIN instance i on i.course_id = c.id
  JOIN ia_user_access ua on i.id = ua.instance_id
  AND ua.user_id = :uid
  JOIN ia_user_exam_access uea on ua.id = uea.user_access_id
  and cm.number = uea.module_nr
  and cc.number = uea.chapter_nr
WHERE
  pm.id = :mid
  and pm.access in (:access)
  AND cc.type in (:exam, :examProject)
  and uea.is_granted = 1

SELECT distinct cm.number, c.id
FROM materials_pill_material pm
         JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
         JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
         JOIN materials_course_module cm ON cm.id = cc.module_id
         JOIN materials_course c ON c.id = cm.course_id
         JOIN instance i on i.course_id = c.id
         JOIN ia_user_access ua on i.id = ua.instance_id AND ua.user_id = 680
         JOIN ia_user_module_access uma on ua.id = uma.user_access_id and cm.number = uma.module_nr
WHERE pm.id = '97874a09-7742-4194-baef-997c86d10d26'
  and pm.access in ('student', 'all')
  AND cc.type not in ('exam', 'exam_project')
  and uma.is_granted = 1
UNION ALL
SELECT distinct cm.number, c.id
FROM materials_pill_material pm
         JOIN materials_course_chapter_pill_version mccpv on pm.version_id = mccpv.pill_version_id
         JOIN materials_course_chapter cc ON cc.id = mccpv.chapter_id
         JOIN materials_course_module cm ON cm.id = cc.module_id
         JOIN materials_course c ON c.id = cm.course_id
         JOIN instance i on i.course_id = c.id
         JOIN ia_user_access ua on i.id = ua.instance_id AND ua.user_id = 680
         JOIN ia_user_exam_access uea on ua.id = uea.user_access_id and cm.number = uea.module_nr and cc.number = uea.chapter_nr
WHERE pm.id = '97874a09-7742-4194-baef-997c86d10d26'
  and pm.access in ('student', 'all')
  AND cc.type in ('exam', 'exam_project')
  and uea.is_granted = 1;

SELECT
  DISTINCT iua.user_id,
  mct.module_id,
  mct.chapter_id,
  mct.material_id,
  COALESCE(iump.status, 0) status,
  COALESCE(v.visited, 0) visited
FROM
  ia_user_access iua
  JOIN instance i on iua.instance_id = i.id
  JOIN materials_course_tree mct on mct.course_id = i.course_id
  JOIN materials_pill_material mpm on mpm.id = mct.material_id
  JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
  LEFT JOIN ia_user_material_visited v on v.user_access_id = iua.id
  and v.material_id = mpm.id
  LEFT JOIN ia_user_material_progress iump on iua.id = iump.user_access_id
  and mct.material_id = iump.material_id
WHERE
  iua.instance_id = :instance
  AND iua.user_id = :user
  AND iua.active = 1
  and (
    mpm.access = :access_all
    OR
    /* student and lecturer */
    mpm.access = :access_student
    OR
    /* student and lecturer X_X */
    IF(
      iua.role = :member_lecturer, mpm.access = :access_lecturer,
      mpm.access = :access_all
    )
    /* lecturer */
    )
  and mpm.type != :quiz
  and mcc.type not in (:exam, :exam_project)
  AND mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
UNION ALL
SELECT
  DISTINCT iua.user_id,
  mct.module_id,
  mct.chapter_id,
  mct.material_id,
  MAX(
    IF(
      lsr.id is not null,
      IF(lsr.status = :passed, 1, 0),
      0
    )
  ) status,
  MAX(
    COALESCE(v.visited, 0)
  ) visited
FROM
  materials_pill_material_criteria mpmc
  JOIN materials_pill_material mpm on mpmc.material_id = mpm.id
  JOIN materials_course_tree mct on mpm.id = mct.material_id
  JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
  JOIN instance i on i.course_id = mct.course_id
  JOIN ia_user_access iua on iua.instance_id = i.id
  AND iua.active = 1
  LEFT JOIN ia_user_material_visited v ON v.user_access_id = iua.id
  and v.material_id = mpm.id
  LEFT JOIN learning_student_results lsrs ON lsrs.course_instance_id = i.id
  AND lsrs.course_instance_id = :instance
  and lsrs.student_id = iua.user_id
  LEFT JOIN learning_student_criteria_group_result lsg ON lsg.student_results_id = lsrs.id
  LEFT JOIN learning_student_result lsr ON lsr.criteria_group_result_id = lsg.id
  AND lsr.is_binding = 1
  AND mpmc.id = lsr.material_criterion_id
WHERE
  mpm.type = :quiz
  and i.id = :instance
  and mcc.type not in (:exam, :exam_project)
  and (
    mpm.access = :access_all
    OR
    /* student and lecturer */
    mpm.access = :access_student
    OR
    /* student and lecturer X_X */
    IF(
      iua.role = :member_lecturer, mpm.access = :access_lecturer,
      mpm.access = :access_all
    )
    /* lecturer */
    )
  AND iua.active = 1
  AND iua.user_id = :user
  AND mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
GROUP BY
  iua.user_id,
  mct.material_id,
  mct.module_id,
  mct.chapter_id

SELECT DISTINCT iua.user_id,
       mct.module_id,
       mct.chapter_id,
       mct.material_id,
       COALESCE(iump.status, 0) status,
       COALESCE(v.visited, 0) visited
FROM ia_user_access iua
JOIN instance i on iua.instance_id = i.id
JOIN materials_course_tree mct on mct.course_id = i.course_id
JOIN materials_pill_material mpm on mpm.id = mct.material_id
JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
LEFT JOIN ia_user_material_visited v on v.user_access_id = iua.id and v.material_id = mpm.id
LEFT JOIN ia_user_material_progress iump on iua.id = iump.user_access_id and mct.material_id = iump.material_id
WHERE iua.instance_id = '1788' 
  AND iua.user_id = '680'
  AND iua.active = 1
  and (
    mpm.access = 'all' OR /* student and lecturer */
    mpm.access = 'student' OR /* student and lecturer X_X */
    IF(iua.role = 'ROLE_LECTURER', mpm.access = 'lecturer', mpm.access = 'all') /* lecturer */
  )
  and mpm.type != 'quiz' 
  and mcc.type not in ('exam', 'exam_project') 
  AND mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
UNION ALL
SELECT DISTINCT iua.user_id, 
       mct.module_id,
       mct.chapter_id,
       mct.material_id,
       MAX(IF(lsr.id is not null, IF(lsr.status = 'passed', 1, 0), 0)) status,
       MAX(COALESCE(v.visited, 0)) visited
FROM materials_pill_material_criteria mpmc
JOIN materials_pill_material mpm on mpmc.material_id = mpm.id
JOIN materials_course_tree mct on mpm.id = mct.material_id
JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
JOIN instance i on i.course_id = mct.course_id
JOIN ia_user_access iua on iua.instance_id = i.id AND iua.active = 1
LEFT JOIN ia_user_material_visited v ON v.user_access_id = iua.id and v.material_id = mpm.id
LEFT JOIN learning_student_results lsrs ON lsrs.course_instance_id = i.id AND lsrs.course_instance_id = '1788' and lsrs.student_id = iua.user_id
LEFT JOIN learning_student_criteria_group_result lsg ON lsg.student_results_id = lsrs.id
LEFT JOIN learning_student_result lsr ON 
    lsr.criteria_group_result_id = lsg.id AND lsr.is_binding = 1 AND mpmc.id = lsr.material_criterion_id
WHERE mpm.type = 'quiz' 
  and i.id = '1788' 
  and mcc.type not in ('exam', 'exam_project')
  and (
    mpm.access = 'all' OR /* student and lecturer */
    mpm.access = 'student' OR /* student and lecturer X_X */
    IF(iua.role = 'ROLE_LECTURER', mpm.access = 'lecturer', mpm.access = 'all') /* lecturer */
  )
  AND iua.active = 1
  AND iua.user_id = '680'
  AND mct.material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7'
GROUP BY iua.user_id, mct.material_id, mct.module_id, mct.chapter_id;

INSERT INTO message_store (
  id, occurred_on, message_type, message_class,
  message_name, body, user_id, correlation_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO message_store (id, occurred_on, message_type, message_class, message_name, body, user_id, correlation_id) VALUES ('d4de4368-6ebd-4a41-9ad6-6b404995fd61', '2025-08-25 11:32:41', 'event', 'CodersLab\\Lms\\Modules\\IdentityAccess\\Application\\Command\\UpdateLastSeenMaterial', 'CodersLab\\Lms\\Modules\\IdentityAccess\\Application\\Command\\UpdateLastSeenMaterial', '{\"materialId\":{\"id\":\"17ec0667-8cae-4ae5-9b57-eaf3461e1ad7\"},\"instanceId\":\"1788\",\"userId\":\"680\"}', '680', '8352ebc2-abc6-476b-98f7-3f33e7d961f9');

UPDATE
  ia_user_access
SET
  last_seen_material_id = :material,
  last_seen_material_date = :date
WHERE
  user_id = :user
  AND instance_id = :instance

UPDATE ia_user_access SET last_seen_material_id = '17ec0667-8cae-4ae5-9b57-eaf3461e1ad7', last_seen_material_date = '2025-08-25 11:32:41'
WHERE user_id = '680' AND instance_id = '1788';