Query Metrics
3
Database Queries
3
Different statements
1.54 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.43 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.email = ? LIMIT 1
Parameters:
[
"antsalaetichiarasoanoro@gmail.com"
]
|
||||||||||||||||||||||||||||
| 2 | 0.83 ms |
SELECT c0_.id AS id_0, c0_.email AS email_1, c0_.password AS password_2, c0_.roles AS roles_3, c0_.created_at AS created_at_4, c0_.actif AS actif_5, c0_.impersonator AS impersonator_6, c0_.label AS label_7, f1_.id AS id_8, f1_.reftier AS reftier_9, f1_.gender AS gender_10, f1_.dep AS dep_11, f1_.firstname AS firstname_12, f1_.lastname AS lastname_13, f1_.address AS address_14, f1_.zip_code AS zip_code_15, f1_.city AS city_16, f1_.country AS country_17, f1_.phone AS phone_18, f1_.cin AS cin_19, f1_.datenaiss AS datenaiss_20, f1_.lieunaiss AS lieunaiss_21, f1_.phone2 AS phone2_22, f1_.facebook AS facebook_23, f1_.etatcivil AS etatcivil_24, f1_.besoin AS besoin_25, f1_.profession AS profession_26, f1_.hierarchie AS hierarchie_27, f1_.decideurs AS decideurs_28, f1_.etat_mat AS etat_mat_29, f1_.email AS email_30, f1_.nationalite AS nationalite_31, f1_.email_pro AS email_pro_32, t2_.id AS id_33, t2_.idUtilisateur AS idUtilisateur_34, t2_.idtiers AS idtiers_35, t2_.statut AS statut_36, t2_.idCommercial AS idCommercial_37, t2_.NomAlt AS NomAlt_38, t2_.Sweb AS Sweb_39, t2_.Fax AS Fax_40, t2_.STAT AS STAT_41, t2_.RCS AS RCS_42, t2_.NIF AS NIF_43, t2_.AssTva AS AssTva_44, t2_.NumTva AS NumTva_45, t2_.FormeJur AS FormeJur_46, t2_.Effectif AS Effectif_47, t2_.typetiers AS typetiers_48, t2_.source AS source_49, t2_.gender AS gender_50, t2_.nompr AS nompr_51, t2_.prenompr AS prenompr_52, t2_.phonepr AS phonepr_53, t2_.interes AS interes_54, t2_.degr AS degr_55, t2_.datec AS datec_56, t2_.datetra AS datetra_57, t2_.tra AS tra_58, t2_.majnote AS majnote_59, t2_.datemaj AS datemaj_60, t2_.superficie AS superficie_61, t2_.action AS action_62, t2_.phonepr2 AS phonepr2_63, t2_.budget AS budget_64, t2_.status AS status_65, t2_.urgence AS urgence_66, t2_.provinces AS provinces_67, t2_.axe AS axe_68, t2_.projet AS projet_69, t2_.created_at AS created_at_70, t2_.emailpr AS emailpr_71, c0_.client_id AS client_id_72, t2_.client_user_id AS client_user_id_73 FROM client_user c0_ LEFT JOIN fos_user f1_ ON c0_.client_id = f1_.id LEFT JOIN tiers t2_ ON c0_.id = t2_.client_user_id WHERE c0_.id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||
| 3 | 0.28 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.client_id = ?
Parameters:
[
1768
]
|
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\ClientUser | No errors. |
| App\Entity\FosUser |
|
| App\Entity\Tiers | No errors. |
| App\Entity\ObservationClient | No errors. |
| App\Entity\ActionAf | No errors. |
| App\Entity\RedispacheTo | No errors. |
| App\Entity\Parrainage | No errors. |