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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  fos_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE fos_user SET last_login = '2025-09-11 08:05:00' WHERE id = 15;

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

INSERT INTO revisions (timestamp, username) VALUES ('2025-09-11 08:05:00', 'jacek.tchorzewski@coderslab.pl');

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 ('501633', '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-09-11 08:05:00', 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);

"COMMIT"

"COMMIT";

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

UPDATE fos_user_audit SET last_login = '2025-09-11 08:05:00' WHERE rev = '501633'  AND id = 15;

SELECT
  roles
FROM
  fos_user
WHERE
  id = :uid

SELECT roles FROM fos_user WHERE id = 15;

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 = 'd365ceb5-e044-453f-b34c-265d15984014' AND ul.user_id = 15;
        ;

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 = 'd365ceb5-e044-453f-b34c-265d15984014'
                GROUP BY t.material_id
            ) mpmt on pm.id = mpmt.material_id
            WHERE pm.id = 'd365ceb5-e044-453f-b34c-265d15984014'
        ;

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 = '5ef8826f-0b3c-4d1e-bb8d-c5eb3f3bcb96' AND mpm.id = 'd365ceb5-e044-453f-b34c-265d15984014';;

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 = 'd365ceb5-e044-453f-b34c-265d15984014' AND mct.chapter_id = '5ef8826f-0b3c-4d1e-bb8d-c5eb3f3bcb96'
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 = 'd365ceb5-e044-453f-b34c-265d15984014' AND mct.chapter_id = '5ef8826f-0b3c-4d1e-bb8d-c5eb3f3bcb96';