Query Metrics
4
Database Queries
3
Different statements
69.55 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.61 ms |
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"
]
|
| 2 | 10.58 ms |
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"
]
|
| 3 | 23.71 ms |
SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE a0_.mode_profil = ?
Parameters:
[
"publique"
]
|
| 4 | 24.65 ms |
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"
]
|
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. |