Query Metrics
8
Database Queries
8
Different statements
13.96 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
10.98 ms (78.65%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.62 ms (4.47%) |
1 |
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.userid AS userid_3, t0.registerkey AS registerkey_4, t0.codetr AS codetr_5, t0.Fonction AS Fonction_6, t0.ClassPro AS ClassPro_7, t0.DateEmbauche AS DateEmbauche_8, t0.DateDebauche AS DateDebauche_9, t0.SalaireB AS SalaireB_10, t0.Nbenfant AS Nbenfant_11, t0.nb_enfant_fille AS nb_enfant_fille_12, t0.nb_enfant_garcon AS nb_enfant_garcon_13, t0.mere_en_vie AS mere_en_vie_14, t0.pere_en_vie AS pere_en_vie_15, t0.nb_proche AS nb_proche_16, t0.nb_proche_en_vie AS nb_proche_en_vie_17, t0.marital_status AS marital_status_18, t0.marriage_date AS marriage_date_19, t0.work_time_ratio AS work_time_ratio_20, t0.NbjourC AS NbjourC_21, t0.UpdateNbj AS UpdateNbj_22, t0.enable AS enable_23, t0.addDate AS addDate_24, t0.photo AS photo_25, t0.com AS com_26, t0.repartition AS repartition_27, t0.cicle AS cicle_28, t0.lastadd AS lastadd_29, t0.rang AS rang_30, t0.matricule AS matricule_31, t0.type_contrat AS type_contrat_32, t0.nextcloud_path AS nextcloud_path_33, t0.nextcloud_share_url AS nextcloud_share_url_34, t0.poste_id AS poste_id_35, t0.categorie_professionnelle_id AS categorie_professionnelle_id_36, t0.departement_id AS departement_id_37, t0.manager_id AS manager_id_38 FROM travailleur t0 WHERE t0.userid = ? LIMIT 1
Parameters:
[
39
]
|
||||||||||||||||||||||||||
|
0.52 ms (3.73%) |
1 |
SELECT t0.id AS id_1, t0.datede AS datede_2, t0.timede AS timede_3, t0.timevd AS timevd_4, t0.timedd AS timedd_5, t0.libelle AS libelle_6, t0.motif AS motif_7, t0.decaissement AS decaissement_8, t0.modep AS modep_9, t0.idUtilisateur AS idUtilisateur_10, t0.typeUt AS typeUt_11, t0.idUt AS idUt_12, t0.idapt AS idapt_13, t0.modeen AS modeen_14, t0.refba AS refba_15, t0.validat AS validat_16, t0.idvalidateur AS idvalidateur_17, t0.fac AS fac_18, t0.can1 AS can1_19, t0.idcaisse AS idcaisse_20, t0.can2 AS can2_21, t0.daf AS daf_22, t0.aptype AS aptype_23, t0.etatde AS etatde_24, t0.idrcfac AS idrcfac_25, t0.enabled AS enabled_26, t0.parcelle AS parcelle_27, t0.edited AS edited_28, t0.prevalidate_at AS prevalidate_at_29, t0.datetode AS datetode_30, t0.imprevu AS imprevu_31, t0.caissier AS caissier_32, t0.prevalidate AS prevalidate_33, t0.can3 AS can3_34, t0.compte AS compte_35, t0.terrain_id AS terrain_id_36, t0.terrassement_budget_id AS terrassement_budget_id_37, t0.terrassement_id AS terrassement_id_38 FROM decaissement t0 WHERE t0.id = ?
Parameters:
[
"38115"
]
|
||||||||||||||||||||||||||
|
0.47 ms (3.34%) |
1 |
SELECT t0.id AS id_1, t0.idcaissier AS idcaissier_2, t0.idcaisse AS idcaisse_3, t0.type AS type_4, t0.enabled AS enabled_5 FROM caisse t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
||||||||||||||||||||||||||
|
0.44 ms (3.17%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
39
]
|
||||||||||||||||||||||||||
|
0.41 ms (2.95%) |
1 |
UPDATE decaissement SET datede = ?, etatde = ?, caissier = ? WHERE id = ?
Parameters:
[ "2026-10-08" 1 1736 38115 ]
|
||||||||||||||||||||||||||
|
0.39 ms (2.77%) |
1 |
SELECT t0.id AS id_1, t0.reftier AS reftier_2, t0.gender AS gender_3, t0.dep AS dep_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.phone AS phone_11, t0.cin AS cin_12, t0.datenaiss AS datenaiss_13, t0.lieunaiss AS lieunaiss_14, t0.phone2 AS phone2_15, t0.facebook AS facebook_16, t0.etatcivil AS etatcivil_17, t0.besoin AS besoin_18, t0.profession AS profession_19, t0.hierarchie AS hierarchie_20, t0.decideurs AS decideurs_21, t0.etat_mat AS etat_mat_22, t0.email AS email_23, t0.nationalite AS nationalite_24, t0.email_pro AS email_pro_25, t26.id AS id_27, t26.email AS email_28, t26.password AS password_29, t26.roles AS roles_30, t26.created_at AS created_at_31, t26.actif AS actif_32, t26.impersonator AS impersonator_33, t26.label AS label_34, t26.client_id AS client_id_35 FROM fos_user t0 LEFT JOIN client_user t26 ON t26.client_id = t0.id WHERE t0.id = ?
Parameters:
[
1736
]
|
||||||||||||||||||||||||||
|
0.13 ms (0.92%) |
1 |
"START TRANSACTION"
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\User | No errors. |
| App\Entity\ContractGroup | No errors. |
| App\Entity\Documentation | No errors. |
| App\Entity\Offre | No errors. |
| App\Entity\Caisse | No errors. |
| App\Entity\ListeCaissier |
|
| App\Entity\CaisseCompte | No errors. |
| App\Entity\Decaissement | No errors. |
| App\Entity\Terrain |
|
| App\Entity\TerrassementBudget | No errors. |
| App\Entity\Terrassement | No errors. |
| App\Entity\BudgetTechnique | No errors. |
| App\Entity\Travailleur | No errors. |
| App\Entity\Poste | No errors. |
| App\Entity\CategorieProfessionnelle | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\TravailleurDocument | No errors. |
| App\Entity\FosUser |
|
| App\Entity\ClientUser | No errors. |
| App\Entity\ObservationClient | No errors. |
| App\Entity\Parrainage | No errors. |
| App\Entity\Tiers | No errors. |