Symfony Profiler

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

Query Metrics

SELECT b.ip, COALESCE(NULLIF(b.port,''), s.portAgg)      AS port, COALESCE(NULLIF(b.country,''), s.countryAgg) AS country, s.countryAgg                                 AS countryCode, COALESCE(NULLIF(b.fai,''),  s.faiAgg)        AS fai, COALESCE(NULLIF(b.type,''), s.typeAgg)       AS type, COALESCE(s.attackCount, 0)                   AS attackCount, s.lastSeen                                   AS date FROM ban b LEFT JOIN (SELECT a.src_ip_txt, COUNT(*) AS attackCount, MAX(a.ts) AS lastSeen, MAX(a.country_code) AS countryAgg, MAX(a.as_org) AS faiAgg, MAX(a.sign_label) AS typeAgg, MAX(a.dport) AS portAgg FROM attempt a GROUP BY a.src_ip_txt) s ON s.src_ip_txt = b.ip ORDER BY  (s.lastSeen IS NULL) ASC, s.lastSeen DESC  LIMIT 50 OFFSET 40550

[]

SELECT
  b.ip,
  COALESCE(
    NULLIF(b.port, ''),
    s.portAgg
  ) AS port,
  COALESCE(
    NULLIF(b.country, ''),
    s.countryAgg
  ) AS country,
  s.countryAgg AS countryCode,
  COALESCE(
    NULLIF(b.fai, ''),
    s.faiAgg
  ) AS fai,
  COALESCE(
    NULLIF(b.type, ''),
    s.typeAgg
  ) AS type,
  COALESCE(s.attackCount, 0) AS attackCount,
  s.lastSeen AS date
FROM
  ban b
  LEFT JOIN (
    SELECT
      a.src_ip_txt,
      COUNT(*) AS attackCount,
      MAX(a.ts) AS lastSeen,
      MAX(a.country_code) AS countryAgg,
      MAX(a.as_org) AS faiAgg,
      MAX(a.sign_label) AS typeAgg,
      MAX(a.dport) AS portAgg
    FROM
      attempt a
    GROUP BY
      a.src_ip_txt
  ) s ON s.src_ip_txt = b.ip
ORDER BY
  (s.lastSeen IS NULL) ASC,
  s.lastSeen DESC
LIMIT
  50
OFFSET
  40550

SELECT b.ip, COALESCE(NULLIF(b.port,''), s.portAgg)      AS port, COALESCE(NULLIF(b.country,''), s.countryAgg) AS country, s.countryAgg                                 AS countryCode, COALESCE(NULLIF(b.fai,''),  s.faiAgg)        AS fai, COALESCE(NULLIF(b.type,''), s.typeAgg)       AS type, COALESCE(s.attackCount, 0)                   AS attackCount, s.lastSeen                                   AS date FROM ban b LEFT JOIN (SELECT a.src_ip_txt, COUNT(*) AS attackCount, MAX(a.ts) AS lastSeen, MAX(a.country_code) AS countryAgg, MAX(a.as_org) AS faiAgg, MAX(a.sign_label) AS typeAgg, MAX(a.dport) AS portAgg FROM attempt a GROUP BY a.src_ip_txt) s ON s.src_ip_txt = b.ip ORDER BY  (s.lastSeen IS NULL) ASC, s.lastSeen DESC  LIMIT 50 OFFSET 40550;

SELECT COUNT(*) FROM (SELECT b.ip, COALESCE(NULLIF(b.port,''), s.portAgg)      AS port, COALESCE(NULLIF(b.country,''), s.countryAgg) AS country, s.countryAgg                                 AS countryCode, COALESCE(NULLIF(b.fai,''),  s.faiAgg)        AS fai, COALESCE(NULLIF(b.type,''), s.typeAgg)       AS type, COALESCE(s.attackCount, 0)                   AS attackCount, s.lastSeen                                   AS date FROM ban b LEFT JOIN (SELECT a.src_ip_txt, COUNT(*) AS attackCount, MAX(a.ts) AS lastSeen, MAX(a.country_code) AS countryAgg, MAX(a.as_org) AS faiAgg, MAX(a.sign_label) AS typeAgg, MAX(a.dport) AS portAgg FROM attempt a GROUP BY a.src_ip_txt) s ON s.src_ip_txt = b.ip) tmp

[]

SELECT
  COUNT(*)
FROM
  (
    SELECT
      b.ip,
      COALESCE(
        NULLIF(b.port, ''),
        s.portAgg
      ) AS port,
      COALESCE(
        NULLIF(b.country, ''),
        s.countryAgg
      ) AS country,
      s.countryAgg AS countryCode,
      COALESCE(
        NULLIF(b.fai, ''),
        s.faiAgg
      ) AS fai,
      COALESCE(
        NULLIF(b.type, ''),
        s.typeAgg
      ) AS type,
      COALESCE(s.attackCount, 0) AS attackCount,
      s.lastSeen AS date
    FROM
      ban b
      LEFT JOIN (
        SELECT
          a.src_ip_txt,
          COUNT(*) AS attackCount,
          MAX(a.ts) AS lastSeen,
          MAX(a.country_code) AS countryAgg,
          MAX(a.as_org) AS faiAgg,
          MAX(a.sign_label) AS typeAgg,
          MAX(a.dport) AS portAgg
        FROM
          attempt a
        GROUP BY
          a.src_ip_txt
      ) s ON s.src_ip_txt = b.ip
  ) tmp

SELECT COUNT(*) FROM (SELECT b.ip, COALESCE(NULLIF(b.port,''), s.portAgg)      AS port, COALESCE(NULLIF(b.country,''), s.countryAgg) AS country, s.countryAgg                                 AS countryCode, COALESCE(NULLIF(b.fai,''),  s.faiAgg)        AS fai, COALESCE(NULLIF(b.type,''), s.typeAgg)       AS type, COALESCE(s.attackCount, 0)                   AS attackCount, s.lastSeen                                   AS date FROM ban b LEFT JOIN (SELECT a.src_ip_txt, COUNT(*) AS attackCount, MAX(a.ts) AS lastSeen, MAX(a.country_code) AS countryAgg, MAX(a.as_org) AS faiAgg, MAX(a.sign_label) AS typeAgg, MAX(a.dport) AS portAgg FROM attempt a GROUP BY a.src_ip_txt) s ON s.src_ip_txt = b.ip) tmp;