Query Metrics
10
Database Queries
10
Different statements
29.86 ms
Query time
3
Invalid entities
Queries
| #▲ | 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 |
|
| 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 |
|
| App\Entity\Promesse |
|
| 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. |