Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  fos_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE fos_user SET last_login = '2025-07-09 20:03:10' WHERE id = 15;

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

INSERT INTO revisions (timestamp, username) VALUES ('2025-07-09 20:03:10', '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 ('499679', '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-09 20:03:10', 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-07-09 20:03:10' WHERE rev = '499679'  AND id = 15;

SELECT
  roles
FROM
  fos_user
WHERE
  id = :uid

SELECT roles FROM fos_user WHERE id = 15;

SELECT
  i.id,
  i.course_id,
  i.signature,
  i.chat_url,
  i.classroom_url,
  i.records_url,
  i.trello_url,
  i.schedule_url,
  i.jira_url,
  i.testlink_url,
  i.self_register,
  l.id as product_id,
  l.icon as icon_path,
  mc.name as product_name,
  mc.description,
  mct.chapter_id last_chapter_id,
  mpm.id as last_material_id,
  mpm.name as last_material_name,
  mentor.name mentor,
  cs.name cs
FROM
  instance i
  INNER JOIN language l ON i.language_id = l.id
  INNER JOIN materials_course mc ON mc.id = i.course_id
  LEFT JOIN ia_user_access ua_member ON i.id = ua_member.instance_id
  LEFT JOIN (
    SELECT
      SUBSTRING_INDEX(
        GROUP_CONCAT(
          CONCAT_WS(' ', fu.name, fu.surname)
          ORDER BY
            ia_ua.active ASC,
            ia_ua.activation_date ASC
        ),
        ',',
        1
      ) name,
      ia_ua.instance_id
    FROM
      ia_user_access ia_ua
      JOIN fos_user fu on ia_ua.user_id = fu.id
    WHERE
      ia_ua.role = 'ROLE_MENTOR'
      AND ia_ua.active = 1
    GROUP BY
      ia_ua.instance_id
  ) mentor ON mentor.instance_id = i.id
  LEFT JOIN (
    SELECT
      SUBSTRING_INDEX(
        GROUP_CONCAT(
          CONCAT_WS(' ', fu.name, fu.surname)
          ORDER BY
            ia_ua.active ASC,
            ia_ua.activation_date ASC
        ),
        ',',
        1
      ) name,
      ia_ua.instance_id
    FROM
      ia_user_access ia_ua
      JOIN fos_user fu on ia_ua.user_id = fu.id
    WHERE
      ia_ua.role = 'ROLE_CS'
      AND ia_ua.active = 1
    GROUP BY
      ia_ua.instance_id
  ) cs ON cs.instance_id = i.id
  LEFT JOIN materials_course_tree mct ON mct.course_id = i.course_id
  AND mct.material_id = ua_member.last_seen_material_id
  and ua_member.user_id = :member
  LEFT JOIN materials_pill_material mpm ON mct.material_id = mpm.id
WHERE
  i.id = :id

SELECT i.id, i.course_id, i.signature, i.chat_url, i.classroom_url, i.records_url, i.trello_url, i.schedule_url, i.jira_url, i.testlink_url, i.self_register, l.id as product_id, l.icon as icon_path, mc.name as product_name, mc.description, mct.chapter_id last_chapter_id, mpm.id as last_material_id, mpm.name as last_material_name, mentor.name mentor, cs.name cs FROM instance i INNER JOIN language l ON i.language_id = l.id INNER JOIN materials_course mc ON mc.id = i.course_id LEFT JOIN ia_user_access ua_member ON i.id = ua_member.instance_id LEFT JOIN (
SELECT SUBSTRING_INDEX(GROUP_CONCAT(CONCAT_WS(' ', fu.name, fu.surname) ORDER BY ia_ua.active ASC, ia_ua.activation_date ASC), ',', 1) name,
   ia_ua.instance_id
FROM ia_user_access ia_ua
JOIN fos_user fu on ia_ua.user_id = fu.id
WHERE ia_ua.role = 'ROLE_MENTOR' AND ia_ua.active = 1
GROUP BY ia_ua.instance_id
) mentor ON mentor.instance_id = i.id LEFT JOIN (
SELECT SUBSTRING_INDEX(GROUP_CONCAT(CONCAT_WS(' ', fu.name, fu.surname) ORDER BY ia_ua.active ASC, ia_ua.activation_date ASC), ',', 1) name,
   ia_ua.instance_id
FROM ia_user_access ia_ua
JOIN fos_user fu on ia_ua.user_id = fu.id
WHERE ia_ua.role = 'ROLE_CS' AND ia_ua.active = 1
GROUP BY ia_ua.instance_id
) cs ON cs.instance_id = i.id LEFT JOIN materials_course_tree mct ON mct.course_id = i.course_id AND mct.material_id = ua_member.last_seen_material_id and ua_member.user_id = '15' LEFT JOIN materials_pill_material mpm ON mct.material_id = mpm.id WHERE i.id = 1787;

SELECT
  role,
  GROUP_CONCAT(module_nr) modules
FROM
  ia_user_access iua
  INNER JOIN ia_user_module_access iuma ON iuma.user_access_id = iua.id
WHERE
  iua.instance_id = :iid
  AND iua.user_id = :uid
  AND iuma.is_granted = 1
GROUP BY
  role
LIMIT
  1

SELECT role, GROUP_CONCAT(module_nr) modules FROM ia_user_access iua INNER JOIN ia_user_module_access iuma ON iuma.user_access_id = iua.id WHERE iua.instance_id = '1787' AND iua.user_id = 15 AND iuma.is_granted = 1 GROUP BY role LIMIT 1;

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'
        ;