Query Metrics

4 Database Queries
4 Different statements
67.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
23.47 ms
(34.77%)
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 = 'publique') ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC LIMIT 10
Parameters:
[]
23.37 ms
(34.62%)
1
SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique')
Parameters:
[]
10.45 ms
(15.49%)
1
SELECT a0_.id_repreneur AS id_repreneur_0, a0_.titre_societe_recherchee AS titre_societe_recherchee_1, a0_.titre_profil AS titre_profil_2, a0_.id_localisations_recherchees AS id_localisations_recherchees_3, a0_.annee_naissance AS annee_naissance_4, a0_.montant_apport AS montant_apport_5, a0_.ville AS ville_6 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND a0_.id_repreneur IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.date_parution_initiale DESC, a0_.id_repreneur DESC
Parameters:
[
  310351
  310350
  309595
  308384
  310042
  308676
  307554
  310011
  297501
  309696
]
10.21 ms
(15.12%)
1
SELECT p0_.valeur_parametre AS valeur_parametre_0 FROM partage_dbo.parametres_divers p0_ WHERE p0_.id_type_parametre_divers = 1 AND p0_.nom_parametre = 'list_nombres_acueil_fusacq'
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.

Entities Mapping

Class Mapping errors
App\Entity\AnnoncesAcheteur No errors.
App\Entity\ParametresDivers No errors.
App\Entity\AnnuaireRepreneurs No errors.
App\Entity\Translation No errors.