Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs 1
• Events
• Routing
• Cache
• Twig
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT * FROM system_session WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

SELECT * FROM system_users

[]

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

SELECT * FROM system_session WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

UPDATE system_session SET last_activity = NOW() WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

UPDATE
  system_session
SET
  last_activity = NOW()
WHERE
  identifier = ?

UPDATE system_session SET last_activity = NOW() WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';

SELECT 
                    su.user_name,
                    su.user_id,
                    su.department,
                    su.vacation_days_total,
                    su.vacation_days_used,
                    dr.date,
                    dr.day_type,
                    dr.start_time,
                    dr.end_time,
                    r.manager_note,
                    r.id AS request_id,
                    dr.minutes
                FROM vacation_requests r
                JOIN vacation_request_days dr ON dr.request_id = r.id
                JOIN system_users su ON su.user_id = r.user_id
                WHERE r.status = "approved" 
                  AND (r.manager_note IS NULL OR r.manager_note NOT LIKE "%[plan-only]%")
                  AND dr.date BETWEEN ? AND ?
                ORDER BY dr.date ASC, su.user_name ASC

[
  "2026-04-23"
  "2026-05-01"
]

SELECT
  su.user_name,
  su.user_id,
  su.department,
  su.vacation_days_total,
  su.vacation_days_used,
  dr.date,
  dr.day_type,
  dr.start_time,
  dr.end_time,
  r.manager_note,
  r.id AS request_id,
  dr.minutes
FROM
  vacation_requests r
  JOIN vacation_request_days dr ON dr.request_id = r.id
  JOIN system_users su ON su.user_id = r.user_id
WHERE
  r.status = "approved"
  AND (
    r.manager_note IS NULL
    OR r.manager_note NOT LIKE "%[plan-only]%"
  )
  AND dr.date BETWEEN ?
  AND ?
ORDER BY
  dr.date ASC,
  su.user_name ASC

SELECT 
                    su.user_name,
                    su.user_id,
                    su.department,
                    su.vacation_days_total,
                    su.vacation_days_used,
                    dr.date,
                    dr.day_type,
                    dr.start_time,
                    dr.end_time,
                    r.manager_note,
                    r.id AS request_id,
                    dr.minutes
                FROM vacation_requests r
                JOIN vacation_request_days dr ON dr.request_id = r.id
                JOIN system_users su ON su.user_id = r.user_id
                WHERE r.status = "approved" 
                  AND (r.manager_note IS NULL OR r.manager_note NOT LIKE "%[plan-only]%")
                  AND dr.date BETWEEN '2026-04-23' AND '2026-05-01'
                ORDER BY dr.date ASC, su.user_name ASC;

SELECT su.user_name, su.department, r.type, r.manager_note, r.approved_by, r.created_at,
                       approver.user_name AS approved_by_name,
                       d.date, d.start_time, d.end_time, d.minutes
                FROM attendance_activity_requests r
                JOIN attendance_activity_request_days d ON d.request_id = r.id
                JOIN system_users su ON su.user_id = r.user_id
                LEFT JOIN system_users approver ON approver.user_id = r.approved_by
                WHERE r.status = "approved" 
                  AND r.type IN ("doctor","sick","ocr","home_office","paid_leave","unpaid_leave","paternity")
                  AND d.date BETWEEN ? AND ?
                ORDER BY r.created_at ASC, d.date ASC, su.user_name ASC

[
  "2026-04-23"
  "2026-05-01"
]

SELECT
  su.user_name,
  su.department,
  r.type,
  r.manager_note,
  r.approved_by,
  r.created_at,
  approver.user_name AS approved_by_name,
  d.date,
  d.start_time,
  d.end_time,
  d.minutes
FROM
  attendance_activity_requests r
  JOIN attendance_activity_request_days d ON d.request_id = r.id
  JOIN system_users su ON su.user_id = r.user_id
  LEFT JOIN system_users approver ON approver.user_id = r.approved_by
WHERE
  r.status = "approved"
  AND r.type IN (
    "doctor", "sick", "ocr", "home_office",
    "paid_leave", "unpaid_leave", "paternity"
  )
  AND d.date BETWEEN ?
  AND ?
ORDER BY
  r.created_at ASC,
  d.date ASC,
  su.user_name ASC

SELECT su.user_name, su.department, r.type, r.manager_note, r.approved_by, r.created_at,
                       approver.user_name AS approved_by_name,
                       d.date, d.start_time, d.end_time, d.minutes
                FROM attendance_activity_requests r
                JOIN attendance_activity_request_days d ON d.request_id = r.id
                JOIN system_users su ON su.user_id = r.user_id
                LEFT JOIN system_users approver ON approver.user_id = r.approved_by
                WHERE r.status = "approved" 
                  AND r.type IN ("doctor","sick","ocr","home_office","paid_leave","unpaid_leave","paternity")
                  AND d.date BETWEEN '2026-04-23' AND '2026-05-01'
                ORDER BY r.created_at ASC, d.date ASC, su.user_name ASC;

SELECT * FROM system_session WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446';