Symfony Profiler

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

Query Metrics

SELECT * FROM system_session WHERE identifier = ?

[
  "4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600';

SELECT * FROM system_users

[]

SELECT
  *
FROM
  system_users

SELECT * FROM system_users;

SELECT * FROM system_session WHERE identifier = ?

[
  "4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600';

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

[
  "4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600"
]

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

UPDATE system_session SET last_activity = NOW() WHERE identifier = '4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600';

SELECT * FROM system_session WHERE identifier = ?

[
  "4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600';

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'

[
  42
]

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

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

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

[
  42
]

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

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

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

[
  42
]

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 = 42 AND status IN ('approved','rejected');

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

[
  42
]

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 = 42 AND status IN ('approved','rejected');

SELECT * FROM system_session WHERE identifier = ?

[
  "4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600"
]

SELECT
  *
FROM
  system_session
WHERE
  identifier = ?

SELECT * FROM system_session WHERE identifier = '4820bcfaaa3bfef0a73380cc46966e60603a25f92e25c500e0fd7f3fa9ef0600';