Query Metrics
3
Database Queries
3
Different statements
244.52 ms
Query time
0
Invalid entities
50
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
241.85 ms (98.91%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 46800
Parameters:
[] |
|
2.49 ms (1.02%) |
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:
[ 426880 426879 426878 426877 426876 426875 426874 426873 426872 426871 426870 426869 426868 426867 426866 426865 426864 426863 426862 426861 426860 426859 426858 426857 426856 426855 426854 426853 426852 426851 426850 426849 426848 426847 426846 426845 426844 426843 426842 426841 426840 426839 426838 426837 426836 426835 426834 426833 426832 426831 ] |
|
0.17 ms (0.07%) |
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. |