Query Metrics
2
Database Queries
2
Different statements
5.54 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.07 ms |
SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.name_en AS name_en_3, t0.numero AS numero_4, t0.definition_fr AS definition_fr_5, t0.definition_en AS definition_en_6, t0.score_niveau1 AS score_niveau1_7, t0.score_niveau2 AS score_niveau2_8, t0.score_niveau3 AS score_niveau3_9, t0.score_niveau4 AS score_niveau4_10, t0.score_niveau5 AS score_niveau5_11, t0.observations_fr AS observations_fr_12, t0.observations_en AS observations_en_13, t0.fonctions_fr AS fonctions_fr_14, t0.fonctions_en AS fonctions_en_15, t0.elements_objectivation_fr AS elements_objectivation_fr_16, t0.elements_objectivation_en AS elements_objectivation_en_17, t0.adherent AS adherent_18, t0.date_update AS date_update_19, t0.intro_niv1 AS intro_niv1_20, t0.intro_niv2 AS intro_niv2_21, t0.intro_niv3 AS intro_niv3_22, t0.intro_niv4 AS intro_niv4_23, t0.intro_niv5 AS intro_niv5_24, t0.active AS active_25, t0.version AS version_26, t0.alias AS alias_27, t0.intro_niv1_en AS intro_niv1_en_28, t0.intro_niv2_en AS intro_niv2_en_29, t0.intro_niv3_en AS intro_niv3_en_30, t0.intro_niv4_en AS intro_niv4_en_31, t0.module_id AS module_id_32, t0.last_user_id AS last_user_id_33, t0.statut_id AS statut_id_34 FROM critere t0 WHERE t0.id = ?
Parameters:
[
"97"
]
|
| 2 | 3.48 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.critere_id AS critere_id_3, t0.user_id AS user_id_4, t0.supplychain_id AS supplychain_id_5 FROM kpi_user_critere t0 WHERE t0.user_id IS NULL AND t0.critere_id = ? LIMIT 1
Parameters:
[
97
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Critere | 1 |
| App\Entity\Module | 1 |
| App\Entity\User | 1 |
| App\Entity\Statut | 1 |
| App\Entity\KpiUserCritere | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Critere | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Statut | No errors. |
| App\Entity\BonnePratique | No errors. |
| App\Entity\OffreurFile | No errors. |
| App\Entity\CritereEpingle | No errors. |
| App\Entity\KpiUserCritere | No errors. |
| App\Entity\Outil | No errors. |
| App\Entity\SecteurActivite | No errors. |
| App\Entity\Marche | No errors. |
| App\Entity\SupplychainRepartition | No errors. |
| App\Entity\EntrepriseType | No errors. |
| App\Entity\Effectif | No errors. |
| App\Entity\Supplychain | No errors. |
| App\Entity\Evaluation | No errors. |
| App\Entity\CritereMesureFavori | No errors. |
| App\Entity\CritereCertifFavori | No errors. |
| App\Entity\EvaluationGlobal | No errors. |
| App\Entity\EvaluationCommentaires | No errors. |
| App\Entity\SupplychainRepartitionCertification | No errors. |
| App\Entity\CritereCertificationFavori | No errors. |
| App\Entity\Certification | No errors. |
| App\Entity\CertificationCommentaires | No errors. |
| App\Entity\CertificationGlobal | No errors. |