GET https://blacklistip.com/ip/200.76.232.238

Query Metrics

8 Database Queries
8 Different statements
1.81 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.43 ms
(23.44%)
1
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
Parameters:
[
  "200.76.232.238"
]
0.31 ms
(16.99%)
1
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attempt a0_ WHERE a0_.src_ip_txt = ?
Parameters:
[
  "200.76.232.238"
]
0.22 ms
(11.98%)
1
SELECT dport, COUNT(*) c FROM attempt WHERE src_ip_txt=? GROUP BY dport ORDER BY c DESC LIMIT 10
Parameters:
[
  "200.76.232.238"
]
0.21 ms
(11.43%)
1
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
Parameters:
[
  "200.76.232.238"
]
0.20 ms
(11.03%)
1
SELECT proto, COUNT(*) c FROM attempt WHERE src_ip_txt=? GROUP BY proto ORDER BY c DESC
Parameters:
[
  "200.76.232.238"
]
0.17 ms
(9.53%)
1
SELECT COUNT(*) FROM attempt WHERE src_ip_txt = ?
Parameters:
[
  "200.76.232.238"
]
0.15 ms
(8.27%)
1
SELECT MIN(ts) FROM attempt WHERE src_ip_txt = ?
Parameters:
[
  "200.76.232.238"
]
0.13 ms
(7.34%)
1
SELECT MAX(ts) FROM attempt WHERE src_ip_txt = ?
Parameters:
[
  "200.76.232.238"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
App\Entity\Attempt No errors.