Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• 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"
  "144.172.117.61"
  "POST"
  "/wallet/getnodeinfo"
  404
  0
  ""
]

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', '144.172.117.61', 'POST', '/wallet/getnodeinfo', 404, 0, '');

INSERT INTO api_rate_limit (identifier, window_key, hits)
                 VALUES (?, ?, 1)
                 ON DUPLICATE KEY UPDATE hits = hits + 1

[
  "scan:144.172.117.61"
  "202608092020"
]

INSERT INTO api_rate_limit (identifier, window_key, hits)
VALUES
  (?, ?, 1) ON DUPLICATE KEY
UPDATE
  hits = hits + 1

INSERT INTO api_rate_limit (identifier, window_key, hits)
                 VALUES ('scan:144.172.117.61', '202608092020', 1)
                 ON DUPLICATE KEY UPDATE hits = hits + 1;

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

[
  "144.172.117.61"
]

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

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

SELECT hits FROM api_rate_limit WHERE identifier = ? AND window_key = ?

[
  "scan:144.172.117.61"
  "202608092020"
]

SELECT
  hits
FROM
  api_rate_limit
WHERE
  identifier = ?
  AND window_key = ?

SELECT hits FROM api_rate_limit WHERE identifier = 'scan:144.172.117.61' AND window_key = '202608092020';