Query Metrics
11
Database Queries
5
Different statements
59.73 ms
Query time
3
Invalid entities
Queries
| #▲ | 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 |
|
| App\Entity\Tiers | No errors. |
| App\Entity\ActionAf | No errors. |
| App\Entity\RedispacheTo | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Terrain |
|
| App\Entity\Listlot | No errors. |
| App\Entity\OffreReservation | No errors. |
| App\Entity\Promesse |
|
| App\Entity\Partiel | No errors. |
| App\Entity\Encaissement | No errors. |
| App\Entity\Mutation | No errors. |
| App\Entity\BudgetTechnique | No errors. |