GET https://blacklistip.com/banlist?page=8287

Response
200 OK
IP
216.73.216.11
Profiled on
Token
ca9091

Query Metrics

3 Database Queries
3 Different statements
173.91 ms Query time
0 Invalid entities
50 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
120.10 ms
(69.06%) 		1 
SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 414300
Parameters: 
[]
View formatted query    View runnable query    Explain query
53.22 ms
(30.60%) 		1 
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM ban b0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.60 ms
(0.34%) 		1 
SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.port AS port_2, b0_.action AS action_3, b0_.type AS type_4, b0_.fai AS fai_5, b0_.city AS city_6, b0_.country AS country_7, b0_.continent AS continent_8, b0_.date AS date_9, b0_.lastdate AS lastdate_10 FROM ban b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.date DESC
Parameters: 
[
  79
  78
  77
  76
  75
  74
  73
  72
  71
  70
  69
  68
  67
  66
  65
  64
  63
  62
  61
  60
  59
  58
  57
  56
  55
  54
  53
  52
  51
  50
  49
  48
  47
  46
  45
  44
  43
  42
  41
  40
  39
  38
  37
  36
  35
  34
  33
  32
  31
  30
]
View formatted query    View runnable query    Explain query

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
App\Entity\Ban 50

Entities Mapping

Class Mapping errors
App\Entity\Ban No errors.