Query Metrics
3
Database Queries
3
Different statements
144.01 ms
Query time
0
Invalid entities
50
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
142.08 ms (98.66%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 41100
Parameters:
[] |
|
1.76 ms (1.22%) |
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:
[ 432579 432578 432577 432576 432575 432574 432573 432572 432571 432570 432569 432568 432567 432566 432565 432564 432563 432562 432561 432560 432559 432558 432557 432556 432555 432554 432553 432552 432551 432550 432549 432548 432547 432546 432545 432544 432543 432542 432541 432540 432539 432538 432537 432536 432535 432534 432533 432532 432531 432530 ] |
|
0.17 ms (0.12%) |
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. |