Query Metrics
3
Database Queries
3
Different statements
151.36 ms
Query time
0
Invalid entities
50
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
150.05 ms (99.14%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 43500
Parameters:
[] |
|
0.70 ms (0.46%) |
1 |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM ban b0_
Parameters:
[] |
|
0.61 ms (0.40%) |
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:
[ 430032 430031 430030 430029 430028 430027 430026 430025 430024 430023 430022 430021 430020 430019 430018 430017 430016 430015 430014 430013 430012 430011 430010 430009 430008 430007 430006 430005 430004 430003 430002 430001 430000 429999 429998 429997 429996 429995 429994 429993 429992 429991 429990 429989 429988 429987 429986 429985 429984 429983 ] |
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. |