Symfony Profiler

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

Query Metrics

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';