Query Metrics
8
Database Queries
8
Different statements
20.49 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
10.70 ms (52.20%) |
1 |
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.idPdv = ? ORDER BY t0.DatedP ASC
Parameters:
[
"HVT58/MIS2026"
]
|
||||||||||||||||||||||||||
|
4.95 ms (24.13%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.note AS note_3, t0.montant AS montant_4, t0.datec AS datec_5, t0.idrc AS idrc_6, t0.idCli AS idCli_7, t0.enabled AS enabled_8, t0.idPdv AS idPdv_9, t0.idghost AS idghost_10, t0.anticipate AS anticipate_11 FROM recouvrement t0 WHERE t0.idPdv = ? AND t0.enabled = ? ORDER BY t0.datec ASC
Parameters:
[ 1381 1 ]
|
||||||||||||||||||||||||||
|
1.54 ms (7.52%) |
1 |
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 = ? ORDER BY t0.id DESC
Parameters:
[
"1768"
]
|
||||||||||||||||||||||||||
|
1.27 ms (6.20%) |
1 |
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 = ? AND t0.enabled = ?
Parameters:
[ "HVT58/MIS2026" 1 ]
|
||||||||||||||||||||||||||
|
0.84 ms (4.11%) |
1 |
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.idghost = ?
Parameters:
[
"HVT58/MIS2026"
]
|
||||||||||||||||||||||||||
|
0.58 ms (2.85%) |
1 |
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:
[
"hasinandriamah@gmail.com"
]
|
||||||||||||||||||||||||||
|
0.34 ms (1.67%) |
1 |
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:
[
1628
]
|
||||||||||||||||||||||||||
|
0.27 ms (1.33%) |
1 |
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date AS date_3, t0.promesse_id AS promesse_id_4, t0.ndc_id AS ndc_id_5 FROM ndcu t0 WHERE t0.promesse_id = ?
Parameters:
[
1381
]
|
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\Promesse |
|
| App\Entity\Terrain |
|
| App\Entity\NoteDeCredit |
|
| App\Entity\NDCU | No errors. |
| App\Entity\PlandeP | No errors. |
| App\Entity\Listlot | No errors. |
| App\Entity\OffrePromesse | No errors. |
| App\Entity\Mutation | No errors. |
| App\Entity\Negociation | No errors. |
| App\Entity\DossierClient | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Partiel | No errors. |
| App\Entity\Rstep | No errors. |
| App\Entity\OffreReservation | No errors. |
| App\Entity\Recouvrement | No errors. |
| App\Entity\BudgetTechnique | No errors. |