Query Metrics

4 Database Queries
3 Different statements
69.55 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.