Query Metrics
3
Database Queries
3
Different statements
227.98 ms
Query time
0
Invalid entities
50
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
166.47 ms (73.02%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 35400
Parameters:
[] |
|
60.98 ms (26.75%) |
1 |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM ban b0_
Parameters:
[] |
|
0.52 ms (0.23%) |
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:
[ 438280 438279 438278 438277 438276 438275 438274 438273 438272 438271 438270 438269 438268 438267 438266 438265 438264 438263 438262 438261 438260 438259 438258 438257 438256 438255 438254 438253 438252 438251 438250 438249 438248 438247 438246 438245 438244 438243 438242 438241 438240 438239 438238 438237 438236 438235 438234 438233 438232 438231 ] |
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. |