Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  fos_user
SET
  last_login = ?
WHERE
  id = ?

UPDATE fos_user SET last_login = '2025-09-09 06:50:58' WHERE id = 15;

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

INSERT INTO revisions (timestamp, username) VALUES ('2025-09-09 06:50:58', '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 ('501613', '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-09 06:50:58', 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-09 06:50:58' WHERE rev = '501613'  AND id = 15;

SELECT
  roles
FROM
  fos_user
WHERE
  id = :uid

SELECT roles FROM fos_user WHERE id = 15;

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 materials_course_tree mct on mc.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
  mc.id = :id
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 materials_course_tree mct on mc.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 mc.id = '2978d777-b3a1-418c-bb37-5fdad635c76c'
ORDER BY mct.module_nr, mct.chapter_nr, mct.pill_nr, ISNULL(mct.material_student_sequence), mct.material_number;

SELECT
  COUNT(1)
FROM
  user_language
WHERE
  user_id = :uid
  AND language_id = :lid

SELECT COUNT(1) FROM user_language WHERE user_id = 15 AND language_id = 'JEE';