Query Metrics
4
Database Queries
3
Different statements
69.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.65 ms (35.44%) |
1 |
SELECT DISTINCT a0_.id_repreneur AS id_repreneur_0, a0_.date_parution_initiale AS date_parution_initiale_1, a0_.id_repreneur AS id_repreneur_2 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ? ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC LIMIT 10 OFFSET 330
Parameters:
[
"publique"
]
|
|
23.71 ms (34.09%) |
1 |
SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ?
Parameters:
[
"publique"
]
|
|
21.19 ms (30.47%) |
2 |
SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> ? OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC
Parameters:
[
"oui"
]
|
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\SecteursActivite | No errors. |
| App\Entity\AnnuaireRepreneurs | No errors. |
| App\Entity\Translation | No errors. |