Symfony Profiler

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

Query Metrics

SELECT * FROM system_session WHERE identifier = ?

[
  "22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

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

SELECT * FROM system_users

[]

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

SELECT * FROM system_session WHERE identifier = ?

[
  "22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

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

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 r.id, r.user_id, su.user_name, su.department, r.type, r.status, r.note, r.created_at, 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
                WHERE r.status = "pending"
                ORDER BY r.created_at DESC, r.id DESC

[]

SELECT
  r.id,
  r.user_id,
  su.user_name,
  su.department,
  r.type,
  r.status,
  r.note,
  r.created_at,
  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
WHERE
  r.status = "pending"
ORDER BY
  r.created_at DESC,
  r.id DESC

SELECT r.id, r.user_id, su.user_name, su.department, r.type, r.status, r.note, r.created_at, 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
                WHERE r.status = "pending"
                ORDER BY r.created_at DESC, r.id DESC;

SELECT * FROM system_session WHERE identifier = ?

[
  "22016099c537e61d16bd5e2c6870b36589094cff52929034faa9089295b94f25"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

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