Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attempt a0_ WHERE a0_.src_ip_txt = ?

[
  "117.200.55.123"
]

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  attempt a0_
WHERE
  a0_.src_ip_txt = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attempt a0_ WHERE a0_.src_ip_txt = '117.200.55.123';

SELECT DISTINCT a0_.id AS id_0, a0_.ts AS ts_1 FROM attempt a0_ WHERE a0_.src_ip_txt = ? ORDER BY a0_.ts DESC LIMIT 50

[
  "117.200.55.123"
]

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.ts AS ts_1
FROM
  attempt a0_
WHERE
  a0_.src_ip_txt = ?
ORDER BY
  a0_.ts DESC
LIMIT
  50

SELECT DISTINCT a0_.id AS id_0, a0_.ts AS ts_1 FROM attempt a0_ WHERE a0_.src_ip_txt = '117.200.55.123' ORDER BY a0_.ts DESC LIMIT 50;

SELECT COUNT(*) FROM attempt WHERE src_ip_txt = ?

[
  "117.200.55.123"
]

SELECT
  COUNT(*)
FROM
  attempt
WHERE
  src_ip_txt = ?

SELECT COUNT(*) FROM attempt WHERE src_ip_txt = '117.200.55.123';

SELECT MIN(ts) FROM attempt WHERE src_ip_txt = ?

[
  "117.200.55.123"
]

SELECT
  MIN(ts)
FROM
  attempt
WHERE
  src_ip_txt = ?

SELECT MIN(ts) FROM attempt WHERE src_ip_txt = '117.200.55.123';

SELECT MAX(ts) FROM attempt WHERE src_ip_txt = ?

[
  "117.200.55.123"
]

SELECT
  MAX(ts)
FROM
  attempt
WHERE
  src_ip_txt = ?

SELECT MAX(ts) FROM attempt WHERE src_ip_txt = '117.200.55.123';

SELECT proto, COUNT(*) c FROM attempt WHERE src_ip_txt=? GROUP BY proto ORDER BY c DESC

[
  "117.200.55.123"
]

SELECT
  proto,
  COUNT(*) c
FROM
  attempt
WHERE
  src_ip_txt = ?
GROUP BY
  proto
ORDER BY
  c DESC

SELECT proto, COUNT(*) c FROM attempt WHERE src_ip_txt='117.200.55.123' GROUP BY proto ORDER BY c DESC;

SELECT dport, COUNT(*) c FROM attempt WHERE src_ip_txt=? GROUP BY dport ORDER BY c DESC LIMIT 10

[
  "117.200.55.123"
]

SELECT
  dport,
  COUNT(*) c
FROM
  attempt
WHERE
  src_ip_txt = ?
GROUP BY
  dport
ORDER BY
  c DESC
LIMIT
  10

SELECT dport, COUNT(*) c FROM attempt WHERE src_ip_txt='117.200.55.123' GROUP BY dport ORDER BY c DESC LIMIT 10;

SELECT path p, COUNT(*) c FROM attempt WHERE src_ip_txt=? AND path IS NOT NULL AND path<>'' GROUP BY p ORDER BY c DESC LIMIT 12

[
  "117.200.55.123"
]

SELECT
  path p,
  COUNT(*) c
FROM
  attempt
WHERE
  src_ip_txt = ?
  AND path IS NOT NULL
  AND path <> ''
GROUP BY
  p
ORDER BY
  c DESC
LIMIT
  12

SELECT path p, COUNT(*) c FROM attempt WHERE src_ip_txt='117.200.55.123' AND path IS NOT NULL AND path<>'' GROUP BY p ORDER BY c DESC LIMIT 12;