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 * FROM system_session WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

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

SELECT user_id, permission FROM user_permissions

[]

SELECT
  user_id,
  permission
FROM
  user_permissions

SELECT user_id, permission FROM user_permissions;

SELECT COUNT(*) FROM vacation_requests WHERE user_id = ? AND status = 'pending'

[
  46
]

SELECT
  COUNT(*)
FROM
  vacation_requests
WHERE
  user_id = ?
  AND status = 'pending'

SELECT COUNT(*) FROM vacation_requests WHERE user_id = 46 AND status = 'pending';

SELECT COUNT(*) FROM attendance_activity_requests WHERE user_id = ? AND status = 'pending'

[
  46
]

SELECT
  COUNT(*)
FROM
  attendance_activity_requests
WHERE
  user_id = ?
  AND status = 'pending'

SELECT COUNT(*) FROM attendance_activity_requests WHERE user_id = 46 AND status = 'pending';

SELECT MAX(updated_at) FROM vacation_requests WHERE user_id = ? AND status IN ('approved','rejected')

[
  46
]

SELECT
  MAX(updated_at)
FROM
  vacation_requests
WHERE
  user_id = ?
  AND status IN ('approved', 'rejected')

SELECT MAX(updated_at) FROM vacation_requests WHERE user_id = 46 AND status IN ('approved','rejected');

SELECT MAX(updated_at) FROM attendance_activity_requests WHERE user_id = ? AND status IN ('approved','rejected')

[
  46
]

SELECT
  MAX(updated_at)
FROM
  attendance_activity_requests
WHERE
  user_id = ?
  AND status IN ('approved', 'rejected')

SELECT MAX(updated_at) FROM attendance_activity_requests WHERE user_id = 46 AND status IN ('approved','rejected');

SELECT * FROM system_session WHERE identifier = ?

[
  "576eb0c703a889cde1f8ae4555f2ba14a4264ff2d87fafe3f684b7cb23ad5446"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

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