Symfony Profiler

SELECT
  DISTINCT ua.user_id,
  mct.module_id,
  mct.chapter_id,
  uma.is_granted
FROM
  ia_user_access ua
  JOIN instance i on ua.instance_id = i.id
  JOIN materials_course_tree mct on i.course_id = mct.course_id
  JOIN materials_course_module mcm on mct.module_id = mcm.id
  JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
  JOIN ia_user_module_access uma on ua.id = uma.user_access_id
  and uma.module_nr = mcm.number
WHERE
  ua.user_id = :uid
  AND ua.instance_id = :iid
  AND mcc.type NOT IN (:exam, :exam_project)
UNION
SELECT
  DISTINCT ua.user_id,
  mct.module_id,
  mct.chapter_id,
  uea.is_granted
FROM
  ia_user_access ua
  JOIN instance i on ua.instance_id = i.id
  JOIN materials_course_tree mct on i.course_id = mct.course_id
  JOIN materials_course_module mcm on mct.module_id = mcm.id
  JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
  JOIN ia_user_exam_access uea on ua.id = uea.user_access_id
  and uea.module_nr = mcm.number
  and uea.chapter_nr = mcc.number
WHERE
  ua.user_id = :uid
  AND ua.instance_id = :iid
  AND mcc.type IN (:exam, :exam_project)

SELECT DISTINCT ua.user_id, 
        mct.module_id,
       mct.chapter_id,
       uma.is_granted
FROM ia_user_access ua
JOIN instance i on ua.instance_id = i.id
JOIN materials_course_tree mct on i.course_id = mct.course_id
JOIN materials_course_module mcm on mct.module_id = mcm.id
JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
JOIN ia_user_module_access uma on ua.id = uma.user_access_id and uma.module_nr = mcm.number
WHERE ua.user_id = '15' AND ua.instance_id = '1787' AND mcc.type NOT IN ('exam', 'exam_project')UNION
SELECT DISTINCT ua.user_id,
                mct.module_id,
                mct.chapter_id,
                uea.is_granted
FROM ia_user_access ua
         JOIN instance i on ua.instance_id = i.id
         JOIN materials_course_tree mct on i.course_id = mct.course_id
         JOIN materials_course_module mcm on mct.module_id = mcm.id
         JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
         JOIN ia_user_exam_access uea on ua.id = uea.user_access_id and uea.module_nr = mcm.number and uea.chapter_nr = mcc.number
WHERE ua.user_id = '15' AND ua.instance_id = '1787' AND mcc.type IN ('exam', 'exam_project');

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)
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
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 = '1787' 
  AND iua.user_id = '15'
  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') 
  
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 = '1787' 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 = '1787' 
  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 = '15'
  
GROUP BY iua.user_id, mct.material_id, mct.module_id, mct.chapter_id;

SELECT
  mc.id course_id,
  mc.version,
  mc.technology_id product_id,
  mc.name product_name,
  mc.repositories,
  mct.module_id,
  mct.module_nr,
  mcm.name module_name,
  mcm.description module_description,
  mct.chapter_id,
  mct.chapter_nr,
  mct.pill_nr,
  mct.material_number,
  mcc.name chapter_name,
  mcc.description chapter_description,
  mcc.type chapter_type,
  mc.pass_percentage,
  mpm.id material_id,
  mpm.type material_type,
  mpm.access material_access,
  mpm.name material_name,
  COALESCE(
    mccp.alias,
    SUBSTRING_INDEX(mp.path, '/', -1)
  ) pill_name
FROM
  materials_course mc
  JOIN instance i on mc.id = i.course_id
  JOIN materials_course_tree mct on i.course_id = mct.course_id
  JOIN materials_course_module mcm on mct.module_id = mcm.id
  JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
  JOIN materials_course_chapter_pill_version mccp on mct.chapter_id = mccp.chapter_id
  AND mct.pill_version_id = mccp.pill_version_id
  JOIN materials_pill_material mpm on mct.material_id = mpm.id
  JOIN materials_pill mp on mct.pill_id = mp.id
WHERE
  i.id = :id
  AND mpm.access IN (:access)
ORDER BY
  mct.module_nr,
  mct.chapter_nr,
  mct.pill_nr,
  ISNULL(mct.material_student_sequence),
  mct.material_number

SELECT mc.id course_id,
       mc.version,
       mc.technology_id product_id,
       mc.name product_name,
       mc.repositories,
       mct.module_id,
       mct.module_nr,
       mcm.name module_name,
       mcm.description module_description,
       mct.chapter_id,
       mct.chapter_nr,
       mct.pill_nr,
       mct.material_number,
       mcc.name chapter_name,
       mcc.description chapter_description,
       mcc.type chapter_type,
       mc.pass_percentage,
       mpm.id material_id,
       mpm.type material_type,
       mpm.access material_access,
       mpm.name material_name,
       COALESCE(mccp.alias, SUBSTRING_INDEX(mp.path, '/', -1)) pill_name
FROM materials_course mc 
JOIN instance i on mc.id = i.course_id
JOIN materials_course_tree mct on i.course_id = mct.course_id
JOIN materials_course_module mcm on mct.module_id = mcm.id
JOIN materials_course_chapter mcc on mct.chapter_id = mcc.id
JOIN materials_course_chapter_pill_version mccp on mct.chapter_id = mccp.chapter_id AND mct.pill_version_id = mccp.pill_version_id
JOIN materials_pill_material mpm on mct.material_id = mpm.id
JOIN materials_pill mp on mct.pill_id = mp.id
WHERE i.id = '1787' AND mpm.access IN ('student', 'all', 'lecturer')
ORDER BY mct.module_nr, mct.chapter_nr, mct.pill_nr, ISNULL(mct.material_student_sequence), mct.material_number;

UPDATE
  fos_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE fos_user SET last_login = '2025-07-15 14:00:46' WHERE id = 15;

"COMMIT"

"COMMIT";

SELECT
  iaua.role
FROM
  ia_user_access iaua
  JOIN instance i ON i.id = iaua.instance_id
WHERE
  iaua.user_id = :uid
  AND iaua.instance_id = :iid

SELECT iaua.role FROM ia_user_access iaua
            JOIN instance i ON i.id = iaua.instance_id
            WHERE iaua.user_id = 15 AND iaua.instance_id = '1787'
        ;

SELECT
  roles
FROM
  fos_user
WHERE
  id = :uid

SELECT roles FROM fos_user WHERE id = 15;

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

INSERT INTO revisions (timestamp, username) VALUES ('2025-07-15 14:00:46', 'jacek.tchorzewski@coderslab.pl');

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 = 'jacek.tchorzewski@coderslab.pl' LIMIT 1;

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 ('500500', 'UPD', 'jacek.tchorzewski@coderslab.pl', 'jacek.tchorzewski@coderslab.pl', 'jacek.tchorzewski@coderslab.pl', 'jacek.tchorzewski@coderslab.pl', 1, 'FXlNk9hZlDvqURQHSXwK/Zr9yi8k/TcnShMHkSJ0am8', '$2y$13$ILpIbxVg0skdVcP4rMrqruWyzWc/KVrZLAWVdPNTlkKgCIgMj2RSW', '2025-07-15 14:00:46', NULL, NULL, 'a:3:{i:0;s:16:\"ROLE_SUPER_ADMIN\";i:1;s:11:\"ROLE_MENTOR\";i:2;s:13:\"ROLE_LECTURER\";}', 15, 'Jacek', 'Tchórzewski', 'JacekTchorzewski-CL', '152855', '604978251', '', NULL, NULL, NULL, NULL, 'pl', 0, '2021-11-16 10:04:54', NULL);

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

UPDATE fos_user_audit SET last_login = '2025-07-15 14:00:46' WHERE rev = '500500'  AND id = 15;

"START TRANSACTION"

"START TRANSACTION";