GET https://app.master-immo.net/client/client/1793

Query Metrics

10 Database Queries
10 Different statements
29.86 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.40 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:
[
  31
]
2 0.74 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:
[
  "1793"
]
3 1.08 ms
SELECT t0.id AS id_1, t0.idClient AS idClient_2, t0.idCom AS idCom_3, t0.Dateres AS Dateres_4, t0.DateEx AS DateEx_5, t0.idghost AS idghost_6, t0.PrixRes AS PrixRes_7, t0.locat AS locat_8, t0.statrz AS statrz_9, t0.stat AS stat_10, t0.enabled AS enabled_11, t0.montconv AS montconv_12, t0.verbale AS verbale_13, t0.terrain_id AS terrain_id_14 FROM reservation t0 WHERE t0.idClient = ? AND t0.enabled = ?
Parameters:
[
  1793
  1
]
4 1.29 ms
SELECT t0.id AS id_1, t0.idClient AS idClient_2, t0.idghost AS idghost_3, t0.prixpdv AS prixpdv_4, t0.DatePDV AS DatePDV_5, t0.locat AS locat_6, t0.idCom AS idCom_7, t0.enabled AS enabled_8, t0.validate AS validate_9, t0.mut AS mut_10, t0.statPDV AS statPDV_11, t0.recstatus AS recstatus_12, t0.recrestetot AS recrestetot_13, t0.postponed AS postponed_14, t0.ravenant AS ravenant_15, t0.rannulation AS rannulation_16, t0.postponed_date AS postponed_date_17, t0.nextcloud_path AS nextcloud_path_18, t0.nextcloud_share_url AS nextcloud_share_url_19, t0.terrain_id AS terrain_id_20 FROM promesse t0 WHERE t0.idClient = ?
Parameters:
[
  1793
]
5 1.41 ms
SELECT t0.id AS id_1, t0.idAction AS idAction_2, t0.type AS type_3, t0.idTerrain AS idTerrain_4, t0.enabled AS enabled_5, t0.mut AS mut_6, t0.pdv_id AS pdv_id_7, t0.rz_id AS rz_id_8, t0.parcelle_id AS parcelle_id_9 FROM listlot t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
6 1.81 ms
SELECT t0.id AS id_1, t0.idTerrain AS idTerrain_2, t0.NomenVente AS NomenVente_3, t0.ContenanceP AS ContenanceP_4, t0.Pvmin AS Pvmin_5, t0.PVoff AS PVoff_6, t0.Echeanmax AS Echeanmax_7, t0.prixm AS prixm_8, t0.StatutP AS StatutP_9, t0.idClient AS idClient_10, t0.enable AS enable_11, t0.pjt AS pjt_12, t0.mutation_id AS mutation_id_13 FROM partiel t0 WHERE t0.enable = ?
Parameters:
[
  1
]
7 21.16 ms
SELECT t0.id AS id_1, t0.idPdv AS idPdv_2, t0.rcou AS rcou_3, t0.DatedP AS DatedP_4, t0.Montant AS Montant_5, t0.restap AS restap_6, t0.statpdP AS statpdP_7, t0.enabled AS enabled_8, t0.slc AS slc_9, t0.id_terrain AS id_terrain_10, t0.avenant AS avenant_11, t0.edited_at AS edited_at_12, t0.date_t AS date_t_13, t0.first AS first_14, t0.tendance AS tendance_15, t0.pdv_id AS pdv_id_16 FROM plande_p t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
8 0.64 ms
SELECT t0.id AS id_1, t0.idclient AS idclient_2, t0.idpdv AS idpdv_3, t0.datec AS datec_4, t0.montant AS montant_5, t0.stat AS stat_6 FROM avenant t0 WHERE t0.idclient = ?
Parameters:
[
  1793
]
9 0.70 ms
SELECT t0.id AS id_1, t0.id_client AS id_client_2, t0.parcelle AS parcelle_3, t0.created_at AS created_at_4, t0.terminer AS terminer_5, t0.ref AS ref_6, t0.perc AS perc_7, t0.end_at AS end_at_8, t0.nomdep AS nomdep_9, t0.nomaque AS nomaque_10, t0.lastedited AS lastedited_11, t0.done AS done_12, t0.end_date AS end_date_13, t0.compromis_id AS compromis_id_14 FROM dossier_client t0
Parameters:
[]
10 0.62 ms
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.client_id AS client_id_4 FROM observation_client t0 WHERE t0.client_id = ?
Parameters:
[
  1793
]

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\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\Reservation 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\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\Listlot No errors.
App\Entity\Partiel No errors.
App\Entity\Mutation No errors.
App\Entity\BudgetTechnique No errors.
App\Entity\PlandeP No errors.
App\Entity\Rstep No errors.
App\Entity\Avenant No errors.
App\Entity\DossierClient No errors.
App\Entity\DossierClientGroupeListe No errors.