Query Metrics
4
Database Queries
4
Different statements
45.28 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |