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-20 11:54:55' WHERE id = 680;

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

INSERT INTO revisions (timestamp, username) VALUES ('2025-08-20 11:54:55', '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 ('500657', '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-20 11:54:55', 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-20 11:54:55' WHERE rev = '500657'  AND id = 680;

SELECT
  roles
FROM
  fos_user
WHERE
  id = :uid

SELECT roles FROM fos_user WHERE id = 680;

SELECT
  DISTINCT i.id,
  i.signature,
  i.course_id,
  i.classroom_url,
  i.chat_url,
  i.records_url,
  i.trello_url,
  i.jira_url,
  i.testlink_url,
  l.id as product_id,
  i.start_date,
  i.schedule_url,
  i.self_register,
  mc.name as product_name,
  mc.description,
  last_material.chapter_id last_chapter_id,
  last_material.last_material_id,
  last_material.last_material_name,
  mentor.name mentor,
  cs.name cs,
  l.icon icon_path
FROM
  instance i
  INNER JOIN language l ON i.language_id = l.id
  INNER JOIN materials_course mc ON i.course_id = mc.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_CS'
      AND ia_ua.active = 1
    GROUP BY
      ia_ua.instance_id
  ) cs ON i.id = cs.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 i.id = mentor.instance_id
  LEFT JOIN ia_user_module_access module_access ON ua_member.id = module_access.user_access_id
  LEFT JOIN (
    SELECT
      substring_index(
        GROUP_CONCAT(
          mct.chapter_id
          ORDER BY
            mct.material_student_sequence ASC
        ),
        ',',
        1
      ) chapter_id,
      i.id as instance_id,
      mpm.id as last_material_id,
      mpm.name as last_material_name
    FROM
      ia_user_access ua_member
      JOIN materials_pill_material mpm on ua_member.last_seen_material_id = mpm.id
      JOIN instance i on ua_member.instance_id = i.id
      JOIN materials_course_tree mct on mpm.id = mct.material_id
      and mct.course_id = i.course_id
    WHERE
      ua_member.user_id = :member
    GROUP BY
      i.id,
      mpm.id,
      mpm.name
  ) last_material ON i.id = last_material.instance_id
WHERE
  (ua_member.user_id = :member)
  AND (module_access.is_granted = 1)
ORDER BY
  i.start_date DESC,
  i.id ASC
LIMIT
  5

SELECT DISTINCT i.id, i.signature, i.course_id, i.classroom_url, i.chat_url, i.records_url, i.trello_url, i.jira_url, i.testlink_url, l.id as product_id, i.start_date, i.schedule_url, i.self_register, mc.name as product_name, mc.description, last_material.chapter_id last_chapter_id, last_material.last_material_id, last_material.last_material_name, mentor.name mentor, cs.name cs, l.icon icon_path FROM instance i INNER JOIN language l ON i.language_id = l.id INNER JOIN materials_course mc ON i.course_id = mc.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_CS' AND ia_ua.active = 1
GROUP BY ia_ua.instance_id
) cs ON i.id = cs.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 i.id = mentor.instance_id LEFT JOIN ia_user_module_access module_access ON ua_member.id = module_access.user_access_id LEFT JOIN (SELECT substring_index(GROUP_CONCAT(mct.chapter_id ORDER BY mct.material_student_sequence ASC), ',', 1) chapter_id,
       i.id     as        instance_id,
       mpm.id   as        last_material_id,
       mpm.name as        last_material_name
FROM ia_user_access ua_member
    JOIN materials_pill_material mpm on ua_member.last_seen_material_id = mpm.id
    JOIN instance i on ua_member.instance_id = i.id
    JOIN materials_course_tree mct on mpm.id = mct.material_id and mct.course_id = i.course_id
WHERE ua_member.user_id = 680
GROUP BY i.id, mpm.id, mpm.name) last_material ON i.id = last_material.instance_id WHERE (ua_member.user_id = 680) AND (module_access.is_granted = 1) ORDER BY i.start_date DESC, i.id ASC LIMIT 5;

SELECT
  DISTINCT COUNT(DISTINCT i.id)
FROM
  instance i
  INNER JOIN language l ON i.language_id = l.id
  INNER JOIN materials_course mc ON i.course_id = mc.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_CS'
      AND ia_ua.active = 1
    GROUP BY
      ia_ua.instance_id
  ) cs ON i.id = cs.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 i.id = mentor.instance_id
  LEFT JOIN ia_user_module_access module_access ON ua_member.id = module_access.user_access_id
  LEFT JOIN (
    SELECT
      substring_index(
        GROUP_CONCAT(
          mct.chapter_id
          ORDER BY
            mct.material_student_sequence ASC
        ),
        ',',
        1
      ) chapter_id,
      i.id as instance_id,
      mpm.id as last_material_id,
      mpm.name as last_material_name
    FROM
      ia_user_access ua_member
      JOIN materials_pill_material mpm on ua_member.last_seen_material_id = mpm.id
      JOIN instance i on ua_member.instance_id = i.id
      JOIN materials_course_tree mct on mpm.id = mct.material_id
      and mct.course_id = i.course_id
    WHERE
      ua_member.user_id = :member
    GROUP BY
      i.id,
      mpm.id,
      mpm.name
  ) last_material ON i.id = last_material.instance_id
WHERE
  (ua_member.user_id = :member)
  AND (module_access.is_granted = 1)
ORDER BY
  i.start_date DESC,
  i.id ASC

SELECT DISTINCT COUNT(DISTINCT i.id) FROM instance i INNER JOIN language l ON i.language_id = l.id INNER JOIN materials_course mc ON i.course_id = mc.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_CS' AND ia_ua.active = 1
GROUP BY ia_ua.instance_id
) cs ON i.id = cs.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 i.id = mentor.instance_id LEFT JOIN ia_user_module_access module_access ON ua_member.id = module_access.user_access_id LEFT JOIN (SELECT substring_index(GROUP_CONCAT(mct.chapter_id ORDER BY mct.material_student_sequence ASC), ',', 1) chapter_id,
       i.id     as        instance_id,
       mpm.id   as        last_material_id,
       mpm.name as        last_material_name
FROM ia_user_access ua_member
    JOIN materials_pill_material mpm on ua_member.last_seen_material_id = mpm.id
    JOIN instance i on ua_member.instance_id = i.id
    JOIN materials_course_tree mct on mpm.id = mct.material_id and mct.course_id = i.course_id
WHERE ua_member.user_id = 680
GROUP BY i.id, mpm.id, mpm.name) last_material ON i.id = last_material.instance_id WHERE (ua_member.user_id = 680) AND (module_access.is_granted = 1) ORDER BY i.start_date DESC, i.id ASC;

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 = 680 AND iaua.instance_id = '1788'
        ;