GET https://app.master-immo.net/api/client/space/myreservation

Query Metrics

11 Database Queries
5 Different statements
59.73 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.62 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.email = ? LIMIT 1
Parameters:
[
  "ramarosandratana.joannie@gmail.com"
]
2 1.12 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 = ? ORDER BY t0.id DESC
Parameters:
[
  1168
]
3 1.53 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.idAction = ?
Parameters:
[
  "RP48/MIS2026"
]
4 17.02 ms
SELECT t0.id AS id_1, t0.dateEn AS dateEn_2, t0.dateval AS dateval_3, t0.timeEn AS timeEn_4, t0.timeDEn AS timeDEn_5, t0.timeValDEn AS timeValDEn_6, t0.libelle AS libelle_7, t0.Encaissement AS Encaissement_8, t0.idrcfac AS idrcfac_9, t0.modeP AS modeP_10, t0.idUtilisateur AS idUtilisateur_11, t0.typeTier AS typeTier_12, t0.idTier AS idTier_13, t0.aptype AS aptype_14, t0.idcaisse AS idcaisse_15, t0.idpdv AS idpdv_16, t0.ca2 AS ca2_17, t0.modeen AS modeen_18, t0.refba AS refba_19, t0.idval AS idval_20, t0.motif AS motif_21, t0.staten AS staten_22, t0.idrc AS idrc_23, t0.enabled AS enabled_24, t0.compte AS compte_25, t0.firstpayment AS firstpayment_26 FROM encaissement t0 WHERE t0.idpdv = ? AND t0.enabled = ? AND t0.aptype = ? ORDER BY t0.id DESC
Parameters:
[
  "RP48/MIS2026"
  1
  "rz"
]
5 0.46 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.id = ?
Parameters:
[
  1370
]
6 1.09 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.idAction = ?
Parameters:
[
  "RES_120815-2023-02-13"
]
7 18.76 ms
SELECT t0.id AS id_1, t0.dateEn AS dateEn_2, t0.dateval AS dateval_3, t0.timeEn AS timeEn_4, t0.timeDEn AS timeDEn_5, t0.timeValDEn AS timeValDEn_6, t0.libelle AS libelle_7, t0.Encaissement AS Encaissement_8, t0.idrcfac AS idrcfac_9, t0.modeP AS modeP_10, t0.idUtilisateur AS idUtilisateur_11, t0.typeTier AS typeTier_12, t0.idTier AS idTier_13, t0.aptype AS aptype_14, t0.idcaisse AS idcaisse_15, t0.idpdv AS idpdv_16, t0.ca2 AS ca2_17, t0.modeen AS modeen_18, t0.refba AS refba_19, t0.idval AS idval_20, t0.motif AS motif_21, t0.staten AS staten_22, t0.idrc AS idrc_23, t0.enabled AS enabled_24, t0.compte AS compte_25, t0.firstpayment AS firstpayment_26 FROM encaissement t0 WHERE t0.idpdv = ? AND t0.enabled = ? AND t0.aptype = ? ORDER BY t0.id DESC
Parameters:
[
  "RES_120815-2023-02-13"
  1
  "rz"
]
8 0.53 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.id = ?
Parameters:
[
  1064
]
9 0.95 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.idAction = ?
Parameters:
[
  "IR 05/MIS 2023"
]
10 17.21 ms
SELECT t0.id AS id_1, t0.dateEn AS dateEn_2, t0.dateval AS dateval_3, t0.timeEn AS timeEn_4, t0.timeDEn AS timeDEn_5, t0.timeValDEn AS timeValDEn_6, t0.libelle AS libelle_7, t0.Encaissement AS Encaissement_8, t0.idrcfac AS idrcfac_9, t0.modeP AS modeP_10, t0.idUtilisateur AS idUtilisateur_11, t0.typeTier AS typeTier_12, t0.idTier AS idTier_13, t0.aptype AS aptype_14, t0.idcaisse AS idcaisse_15, t0.idpdv AS idpdv_16, t0.ca2 AS ca2_17, t0.modeen AS modeen_18, t0.refba AS refba_19, t0.idval AS idval_20, t0.motif AS motif_21, t0.staten AS staten_22, t0.idrc AS idrc_23, t0.enabled AS enabled_24, t0.compte AS compte_25, t0.firstpayment AS firstpayment_26 FROM encaissement t0 WHERE t0.idpdv = ? AND t0.enabled = ? AND t0.aptype = ? ORDER BY t0.id DESC
Parameters:
[
  "IR 05/MIS 2023"
  1
  "rz"
]
11 0.45 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.id = ?
Parameters:
[
  1061
]

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\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\ActionAf No errors.
App\Entity\RedispacheTo 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\Listlot No errors.
App\Entity\OffreReservation No errors.
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\Partiel No errors.
App\Entity\Encaissement No errors.
App\Entity\Mutation No errors.
App\Entity\BudgetTechnique No errors.