Query Metrics

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

Queries

Group similar statements

# Time Info
1 10.46 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.87 ms
SELECT COUNT(DISTINCT v0_.id_valorisation) AS sclr_0 FROM valorisations v0_ WHERE v0_.mode = 'publique'
Parameters:
[]
3 13.04 ms
SELECT DISTINCT v0_.id_valorisation AS id_valorisation_0, v0_.date_mois_operation AS date_mois_operation_1 FROM valorisations v0_ WHERE v0_.mode = 'publique' ORDER BY v0_.date_mois_operation DESC LIMIT 10
Parameters:
[]
4 10.92 ms
SELECT v0_.id_valorisation AS id_valorisation_0, v0_.titre_valorisation AS titre_valorisation_1, v0_.description_activite AS description_activite_2, v0_.ca_n AS ca_n_3, v0_.type_cedant AS type_cedant_4, v0_.description_publique AS description_publique_5, v0_.date_mois_operation AS date_mois_operation_6, v0_.societe_difficulte AS societe_difficulte_7, v0_.type_rachat AS type_rachat_8, v0_.type_acquereur AS type_acquereur_9 FROM valorisations v0_ WHERE v0_.mode = 'publique' AND v0_.id_valorisation IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.date_mois_operation DESC
Parameters:
[
  630
  617
  614
  613
  609
  626
  598
  607
  601
  599
]

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\Translation No errors.
App\Entity\Valorisations No errors.