GET https://app.master-immo.net/decaissement/Decaissementdemade/3/38115

Query Metrics

8 Database Queries
8 Different statements
13.96 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.44 ms
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
]
2 0.47 ms
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"
]
3 0.52 ms
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"
]
4 0.62 ms
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
]
5 0.39 ms
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
]
6 0.13 ms
"START TRANSACTION"
Parameters:
[]
7 0.41 ms
UPDATE decaissement SET datede = ?, etatde = ?, caissier = ? WHERE id = ?
Parameters:
[
  "2026-10-08"
  1
  1736
  38115
]
8 10.98 ms
"COMMIT"
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
  • The association App\Entity\ListeCaissier#UserId refers to the inverse side field App\Entity\User#listeCaissiers which does not exist.
App\Entity\CaisseCompte No errors.
App\Entity\Decaissement No errors.
App\Entity\Terrain
  • The association App\Entity\Terrain#fournisseur refers to the inverse side field App\Entity\Fournisseur#terrains which does not exist.
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
  • The field App\Entity\FosUser#clientUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ClientUser#client does not contain the required 'inversedBy="clientUser"' attribute.
  • The association App\Entity\FosUser#tiers refers to the owning side field App\Entity\Tiers#commercial which does not exist.
App\Entity\ClientUser No errors.
App\Entity\ObservationClient No errors.
App\Entity\Parrainage No errors.
App\Entity\Tiers No errors.