GET https://app.master-immo.net/cms/utilisateur/19/impersonate

Query Metrics

3 Database Queries
3 Different statements
1.54 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.43 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:
[
  "antsalaetichiarasoanoro@gmail.com"
]
2 0.83 ms
SELECT c0_.id AS id_0, c0_.email AS email_1, c0_.password AS password_2, c0_.roles AS roles_3, c0_.created_at AS created_at_4, c0_.actif AS actif_5, c0_.impersonator AS impersonator_6, c0_.label AS label_7, f1_.id AS id_8, f1_.reftier AS reftier_9, f1_.gender AS gender_10, f1_.dep AS dep_11, f1_.firstname AS firstname_12, f1_.lastname AS lastname_13, f1_.address AS address_14, f1_.zip_code AS zip_code_15, f1_.city AS city_16, f1_.country AS country_17, f1_.phone AS phone_18, f1_.cin AS cin_19, f1_.datenaiss AS datenaiss_20, f1_.lieunaiss AS lieunaiss_21, f1_.phone2 AS phone2_22, f1_.facebook AS facebook_23, f1_.etatcivil AS etatcivil_24, f1_.besoin AS besoin_25, f1_.profession AS profession_26, f1_.hierarchie AS hierarchie_27, f1_.decideurs AS decideurs_28, f1_.etat_mat AS etat_mat_29, f1_.email AS email_30, f1_.nationalite AS nationalite_31, f1_.email_pro AS email_pro_32, t2_.id AS id_33, t2_.idUtilisateur AS idUtilisateur_34, t2_.idtiers AS idtiers_35, t2_.statut AS statut_36, t2_.idCommercial AS idCommercial_37, t2_.NomAlt AS NomAlt_38, t2_.Sweb AS Sweb_39, t2_.Fax AS Fax_40, t2_.STAT AS STAT_41, t2_.RCS AS RCS_42, t2_.NIF AS NIF_43, t2_.AssTva AS AssTva_44, t2_.NumTva AS NumTva_45, t2_.FormeJur AS FormeJur_46, t2_.Effectif AS Effectif_47, t2_.typetiers AS typetiers_48, t2_.source AS source_49, t2_.gender AS gender_50, t2_.nompr AS nompr_51, t2_.prenompr AS prenompr_52, t2_.phonepr AS phonepr_53, t2_.interes AS interes_54, t2_.degr AS degr_55, t2_.datec AS datec_56, t2_.datetra AS datetra_57, t2_.tra AS tra_58, t2_.majnote AS majnote_59, t2_.datemaj AS datemaj_60, t2_.superficie AS superficie_61, t2_.action AS action_62, t2_.phonepr2 AS phonepr2_63, t2_.budget AS budget_64, t2_.status AS status_65, t2_.urgence AS urgence_66, t2_.provinces AS provinces_67, t2_.axe AS axe_68, t2_.projet AS projet_69, t2_.created_at AS created_at_70, t2_.emailpr AS emailpr_71, c0_.client_id AS client_id_72, t2_.client_user_id AS client_user_id_73 FROM client_user c0_ LEFT JOIN fos_user f1_ ON c0_.client_id = f1_.id LEFT JOIN tiers t2_ ON c0_.id = t2_.client_user_id WHERE c0_.id = ?
Parameters:
[
  19
]
3 0.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.created_at AS created_at_5, t0.actif AS actif_6, t0.impersonator AS impersonator_7, t0.label AS label_8, t0.client_id AS client_id_9, t10.id AS id_11, t10.idUtilisateur AS idUtilisateur_12, t10.idtiers AS idtiers_13, t10.statut AS statut_14, t10.idCommercial AS idCommercial_15, t10.NomAlt AS NomAlt_16, t10.Sweb AS Sweb_17, t10.Fax AS Fax_18, t10.STAT AS STAT_19, t10.RCS AS RCS_20, t10.NIF AS NIF_21, t10.AssTva AS AssTva_22, t10.NumTva AS NumTva_23, t10.FormeJur AS FormeJur_24, t10.Effectif AS Effectif_25, t10.typetiers AS typetiers_26, t10.source AS source_27, t10.gender AS gender_28, t10.nompr AS nompr_29, t10.prenompr AS prenompr_30, t10.phonepr AS phonepr_31, t10.interes AS interes_32, t10.degr AS degr_33, t10.datec AS datec_34, t10.datetra AS datetra_35, t10.tra AS tra_36, t10.majnote AS majnote_37, t10.datemaj AS datemaj_38, t10.superficie AS superficie_39, t10.action AS action_40, t10.phonepr2 AS phonepr2_41, t10.budget AS budget_42, t10.status AS status_43, t10.urgence AS urgence_44, t10.provinces AS provinces_45, t10.axe AS axe_46, t10.projet AS projet_47, t10.created_at AS created_at_48, t10.emailpr AS emailpr_49, t10.client_user_id AS client_user_id_50 FROM client_user t0 LEFT JOIN tiers t10 ON t10.client_user_id = t0.id WHERE t0.client_id = ?
Parameters:
[
  1768
]

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\ClientUser 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\Tiers No errors.
App\Entity\ObservationClient No errors.
App\Entity\ActionAf No errors.
App\Entity\RedispacheTo No errors.
App\Entity\Parrainage No errors.