POST https://app.master-immo.net/_components/DecaissementForm

Response
200 OK
Browse referrer URL
IP
129.222.109.40
Profiled on
Token
1361e7

Query Metrics

27 Database Queries
17 Different statements
24.60 ms Query time
5 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.46 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: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.52 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: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.22 ms 
SELECT t0.id AS id_1, t0.idcaisse AS idcaisse_2, t0.Solde AS Solde_3, t0.dateMod AS dateMod_4, t0.TypeCaisse AS TypeCaisse_5, t0.modeCaisse AS modeCaisse_6, t0.nomc AS nomc_7, t0.enabled AS enabled_8 FROM caisse_type t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
4 5.93 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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.74 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.51 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.54 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.40 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.35 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.43 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.25 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.38 ms 
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.31 ms 
SELECT t0.id AS id_1, t0.typerf AS typerf_2, t0.nomrf AS nomrf_3, t0.enabled AS enabled_4 FROM rcfac t0 WHERE t0.typerf = ? AND t0.enabled = ? LIMIT 1
Parameters: 
[
  "DC"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.46 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.enable = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.55 ms 
SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 WHERE t0.Enabled = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.46 ms 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ref AS ref_2, c0_.rib AS rib_3 FROM caisse_compte c0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.30 ms 
SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 WHERE t0.Nom = ? AND t0.Enabled = ? LIMIT 1
Parameters: 
[
  "LOGISTIQUE"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.30 ms 
SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 INNER JOIN analitique_analitique ON t0.id = analitique_analitique.analitique_target WHERE analitique_analitique.analitique_source = ?
Parameters: 
[
  96
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.46 ms 
SELECT a0_.id AS id_0, a0_.Type AS Type_1, a0_.Nom AS Nom_2, a0_.Enabled AS Enabled_3 FROM analitique a0_ WHERE a0_.Type = ? AND a0_.Enabled = ? AND (SELECT COUNT(*) FROM analitique_analitique a1_ WHERE a1_.analitique_target = a0_.id) = 0
Parameters: 
[
  "A2"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
20 8.94 ms 
SELECT t0_.id AS id_0, t0_.Denprojet AS Denprojet_1, t0_.restap AS restap_2, t0_.idanal AS idanal_3, t0_.codeprojet AS codeprojet_4, t0_.sitjuridique AS sitjuridique_5, t0_.Numtitrs AS Numtitrs_6, t0_.Numregistre AS Numregistre_7, t0_.Numfolio AS Numfolio_8, t0_.sisea AS sisea_9, t0_.fokotany AS fokotany_10, t0_.Commune AS Commune_11, t0_.District AS District_12, t0_.Region AS Region_13, t0_.Nompropriete AS Nompropriete_14, t0_.contenance AS contenance_15, t0_.proprietaire AS proprietaire_16, t0_.Signataire AS Signataire_17, t0_.PersonaPPV AS PersonaPPV_18, t0_.PAterrain AS PAterrain_19, t0_.contrat AS contrat_20, t0_.categorie AS categorie_21, t0_.refarch AS refarch_22, t0_.coordong AS coordong_23, t0_.aventage AS aventage_24, t0_.inconv AS inconv_25, t0_.contenance_av AS contenance_av_26, t0_.piecejoint AS piecejoint_27, t0_.suivie AS suivie_28, t0_.description AS description_29, t0_.coordinates AS coordinates_30, t0_.date AS date_31, t0_.axe AS axe_32, t0_.type AS type_33, t0_.min AS min_34, t0_.max AS max_35, t0_.supmin AS supmin_36, t0_.supmax AS supmax_37, t0_.noted AS noted_38, t0_.budget AS budget_39, t0_.budgets AS budgets_40, t0_.public_visibility AS public_visibility_41, t0_.nextcloud_path AS nextcloud_path_42, t0_.nextcloud_share_url AS nextcloud_share_url_43, t0_.fournisseur_id AS fournisseur_id_44, t0_.logo_id AS logo_id_45, t0_.image_principal_id AS image_principal_id_46 FROM terrain t0_ ORDER BY t0_.Denprojet ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.52 ms 
SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 WHERE t0.Nom = ? AND t0.Enabled = ? LIMIT 1
Parameters: 
[
  "FRAIS DE TRANSFERT/RETRAIT MOBILE MONEY"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.22 ms 
SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 INNER JOIN analitique_analitique ON t0.id = analitique_analitique.analitique_target WHERE analitique_analitique.analitique_source = ?
Parameters: 
[
  201
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.49 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.enabled = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.19 ms 
SELECT t0.id AS id_1, t0.idcaisse AS idcaisse_2, t0.Solde AS Solde_3, t0.dateMod AS dateMod_4, t0.TypeCaisse AS TypeCaisse_5, t0.modeCaisse AS modeCaisse_6, t0.nomc AS nomc_7, t0.enabled AS enabled_8 FROM caisse_type t0 WHERE t0.enabled = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.18 ms 
SELECT t0.id AS id_1, t0.idcaisse AS idcaisse_2, t0.Solde AS Solde_3, t0.dateMod AS dateMod_4, t0.TypeCaisse AS TypeCaisse_5, t0.modeCaisse AS modeCaisse_6, t0.nomc AS nomc_7, t0.enabled AS enabled_8 FROM caisse_type t0 WHERE t0.enabled = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.23 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.email = ? LIMIT 1
Parameters: 
[
  "tanjonarandrianarivao@gmail.com"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.25 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: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace

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\CaisseType 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.
App\Entity\ActionAf No errors.
App\Entity\RedispacheTo No errors.
App\Entity\Rcfac 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\Analitique 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\Fournisseur No errors.
App\Entity\Image No errors.
App\Entity\Decaissement No errors.
App\Entity\ImageTerrain No errors.
App\Entity\TerrainTag No errors.
App\Entity\PropositionOffre No errors.
App\Entity\SourceTerrain No errors.
App\Entity\Contract
  • The field 'App\Entity\Contract#amount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Promesse
  • The field App\Entity\Promesse#negociations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Negociation#compromis does not contain the required 'inversedBy="negociations"' attribute.
App\Entity\Reservation No errors.
App\Entity\Terrassement No errors.
App\Entity\Mutation No errors.