Query Metrics
3
Database Queries
3
Different statements
139.73 ms
Query time
0
Invalid entities
50
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
138.95 ms (99.44%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 41150
Parameters:
[] |
|
0.58 ms (0.42%) |
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:
[ 432529 432528 432527 432526 432525 432524 432523 432522 432521 432520 432519 432518 432517 432516 432515 432514 432513 432512 432511 432510 432509 432508 432507 432506 432505 432504 432503 432502 432501 432500 432499 432498 432497 432496 432495 432494 432493 432492 432491 432490 432489 432488 432487 432486 432485 432484 432483 432482 432481 432480 ] |
|
0.20 ms (0.15%) |
1 |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM ban b0_
Parameters:
[] |
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. |