Symfony Profiler

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

Query Metrics

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

[
  "22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25"
]

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

UPDATE system_session SET last_activity = NOW() WHERE identifier = '22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25';

SELECT * FROM system_session WHERE identifier = ?

[
  "22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25';

SELECT user_id, permission FROM user_permissions

[]

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

SELECT * FROM system_users

[]

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

SELECT 
                    COALESCE(su.user_name, m.user_name) AS user_name,
                    su.user_id,
                    su.department,
                    d.date
                FROM vacation_plan_manual m
                JOIN vacation_plan_manual_days d ON d.manual_id = m.id
                LEFT JOIN system_users su ON su.user_id = m.user_id
                WHERE d.date BETWEEN ? AND ?
                ORDER BY d.date ASC, m.user_name ASC

[
  "2026-04-01"
  "2026-04-30"
]

SELECT
  COALESCE(su.user_name, m.user_name) AS user_name,
  su.user_id,
  su.department,
  d.date
FROM
  vacation_plan_manual m
  JOIN vacation_plan_manual_days d ON d.manual_id = m.id
  LEFT JOIN system_users su ON su.user_id = m.user_id
WHERE
  d.date BETWEEN ?
  AND ?
ORDER BY
  d.date ASC,
  m.user_name ASC

SELECT 
                    COALESCE(su.user_name, m.user_name) AS user_name,
                    su.user_id,
                    su.department,
                    d.date
                FROM vacation_plan_manual m
                JOIN vacation_plan_manual_days d ON d.manual_id = m.id
                LEFT JOIN system_users su ON su.user_id = m.user_id
                WHERE d.date BETWEEN '2026-04-01' AND '2026-04-30'
                ORDER BY d.date ASC, m.user_name ASC;

SELECT 
                    su.user_name,
                    su.user_id,
                    su.department,
                    dr.date,
                    dr.day_type,
                    dr.start_time,
                    dr.end_time,
                    r.id AS request_id,
                    r.status
                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 IN (?,?)
                  AND r.manager_note LIKE '%[plan-only]%'
                  AND dr.date BETWEEN ? AND ?
                  
                ORDER BY dr.date ASC, su.user_name ASC

[
  "pending"
  "approved"
  "2026-04-01"
  "2026-04-30"
]

SELECT
  su.user_name,
  su.user_id,
  su.department,
  dr.date,
  dr.day_type,
  dr.start_time,
  dr.end_time,
  r.id AS request_id,
  r.status
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 IN (?, ?)
  AND r.manager_note 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,
                    dr.date,
                    dr.day_type,
                    dr.start_time,
                    dr.end_time,
                    r.id AS request_id,
                    r.status
                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 IN ('pending','approved')
                  AND r.manager_note LIKE '%[plan-only]%'
                  AND dr.date BETWEEN '2026-04-01' AND '2026-04-30'
                  
                ORDER BY dr.date ASC, su.user_name ASC;