Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Configuration

Query Metrics

INSERT INTO api_audit
                 (source, usuario_id, apikey_id, auth_method, ip, method, path, status_code, duration_ms, user_agent)
                 VALUES (?, ?, NULL, ?, ?, ?, ?, ?, ?, ?)

[
  "manager"
  null
  "none"
  "192.168.128.1"
  "GET"
  "/usuario/login"
  200
  14
  "Uptime-Kuma/1.23.16"
]

INSERT INTO api_audit (
  source, usuario_id, apikey_id, auth_method,
  ip, method, path, status_code, duration_ms,
  user_agent
)
VALUES
  (?, ?, NULL, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO api_audit
                 (source, usuario_id, apikey_id, auth_method, ip, method, path, status_code, duration_ms, user_agent)
                 VALUES ('manager', NULL, NULL, 'none', '192.168.128.1', 'GET', '/usuario/login', 200, 14, 'Uptime-Kuma/1.23.16');

SELECT 1 FROM api_ip_ban WHERE ip = ? AND banned_until > NOW()

[
  "192.168.128.1"
]

SELECT
  1
FROM
  api_ip_ban
WHERE
  ip = ?
  AND banned_until > NOW()

SELECT 1 FROM api_ip_ban WHERE ip = '192.168.128.1' AND banned_until > NOW();