Query Metrics
6
Database Queries
4
Different statements
165.28 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 28.34 ms |
SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = ? AND a0_.id_pays = ?
Parameters:
[ "publique" 33 ] |
| 2 | 30.19 ms |
SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = ? AND a0_.id_pays = ? AND a0_.ca_n < ?
Parameters:
[ "publique" 33 300 ] |
| 3 | 27.30 ms |
SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = ? AND a0_.id_pays = ? AND a0_.ca_n >= ? AND a0_.ca_n < ?
Parameters:
[ "publique" 33 300 1000 ] |
| 4 | 29.01 ms |
SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = ? AND a0_.id_pays = ? AND a0_.ca_n >= ? AND a0_.ca_n < ?
Parameters:
[ "publique" 33 1000 3000 ] |
| 5 | 25.31 ms |
SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = ? AND a0_.id_pays = ? AND a0_.ca_n >= ? AND a0_.ca_n < ?
Parameters:
[ "publique" 33 3000 10000 ] |
| 6 | 25.13 ms |
SELECT COUNT(a0_.id_annonce_vendeur) AS sclr_0 FROM fusacq_dbo.annonces_vendeur a0_ WHERE a0_.mode_annonce = ? AND a0_.id_pays = ? AND a0_.ca_n >= ?
Parameters:
[ "publique" 33 10000 ] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AnnoncesVendeur | No errors. |
| App\Entity\Translation | No errors. |