Query Metrics
4
Database Queries
4
Different statements
6.24 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.54 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.poste AS poste_7, t0.is_active AS is_active_8, t0.roles AS roles_9, t0.deleted AS deleted_10, t0.reset AS reset_11, t0.color AS color_12, t0.taux_horaire AS taux_horaire_13, t0.telephone_fixe AS telephone_fixe_14, t0.telephone_portable AS telephone_portable_15, t0.type_contrat AS type_contrat_16, t0.tache AS tache_17, t0.productivite_m2 AS productivite_m2_18, t0.total_interventions_jours AS total_interventions_jours_19, t0.total_interventions_reel AS total_interventions_reel_20, t0.site_ratachement_id AS site_ratachement_id_21, t0.client_id AS client_id_22, t0.current_intervention_filter_id AS current_intervention_filter_id_23, t0.current_project_filter_id AS current_project_filter_id_24, t0.current_intervention_vue_id AS current_intervention_vue_id_25, t0.current_project_vue_id AS current_project_vue_id_26, t0.entreprise_id AS entreprise_id_27, t0.current_year_vue_id AS current_year_vue_id_28 FROM user t0
Parameters:
[] |
| 2 | 0.19 ms |
SELECT t0.id AS id_1, t0.productivite AS productivite_2, t0.libelle AS libelle_3, t0.deleted AS deleted_4 FROM equipes t0
Parameters:
[] |
| 3 | 2.14 ms |
SELECT i0_.date AS date_0 FROM interventions i0_
Parameters:
[] |
| 4 | 0.36 ms |
SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.code_tva AS code_tva_5, t0.numero_registre_commerce AS numero_registre_commerce_6, t0.siret AS siret_7, t0.ape AS ape_8, t0.ville AS ville_9, t0.horaires AS horaires_10, t0.is_journal_projet AS is_journal_projet_11, t0.planning_heure_debut AS planning_heure_debut_12, t0.planning_heure_fin AS planning_heure_fin_13, t0.dash_stat_interventions AS dash_stat_interventions_14, t0.dash_stat_ca AS dash_stat_ca_15, t0.projet_main_oeuvre AS projet_main_oeuvre_16, t0.projet_fournisseur AS projet_fournisseur_17, t0.projet_lot AS projet_lot_18, t0.dash_conges AS dash_conges_19, t0.compte_interne_id AS compte_interne_id_20, t0.default_jointeur_id AS default_jointeur_id_21 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Interventions | No errors. |
| App\Entity\Projects | No errors. |
| App\Entity\Client |
|
| App\Entity\User | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\UserFilters | No errors. |
| App\Entity\Entreprise | No errors. |
| App\Entity\Equipes | No errors. |