Query Metrics
4
Database Queries
4
Different statements
8.27 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.71 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.personne_id AS personne_id_5, t6.id AS id_7, t6.adhesion AS adhesion_8, t6.photo AS photo_9, t6.cadre AS cadre_10, t6.carte AS carte_11, t6.federation_id AS federation_id_12, t6.user_id AS user_id_13, t14.id AS id_15, t14.nom AS nom_16, t14.president AS president_17, t14.user_id AS user_id_18, t19.id AS id_20, t19.nom AS nom_21, t19.adresse AS adresse_22, t19.telephone AS telephone_23, t19.president AS president_24, t19.province_id AS province_id_25, t19.user_id AS user_id_26, t27.id AS id_28, t27.adhesion AS adhesion_29, t27.cadre AS cadre_30, t27.etat AS etat_31, t27.federation_id AS federation_id_32, t27.user_id AS user_id_33 FROM user t0 LEFT JOIN membre t6 ON t6.user_id = t0.id LEFT JOIN province t14 ON t14.user_id = t0.id LEFT JOIN federation t19 ON t19.user_id = t0.id LEFT JOIN demande t27 ON t27.user_id = t0.id WHERE t0.id = ?
Parameters:
[
49406
]
|
2 | 2.73 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.postnom AS postnom_4, t0.date_naissance AS date_naissance_5, t0.lieu_naissance AS lieu_naissance_6, t0.sexe AS sexe_7, t0.etat_civil AS etat_civil_8, t0.fonction AS fonction_9, t0.niveau_etude AS niveau_etude_10, t0.adresse AS adresse_11, t0.telephone AS telephone_12, t0.province AS province_13, t0.district AS district_14, t0.territoire AS territoire_15, t0.secteur AS secteur_16, t0.telephone2 AS telephone2_17, t0.commune AS commune_18, t0.quartier AS quartier_19, t20.id AS id_21, t20.email AS email_22, t20.roles AS roles_23, t20.password AS password_24, t20.personne_id AS personne_id_25 FROM personne t0 LEFT JOIN user t20 ON t20.personne_id = t0.id WHERE t0.id = ?
Parameters:
[
49299
]
|
3 | 1.50 ms |
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date AS date_3, t0.test AS test_4, t0.reference AS reference_5, t0.ordernumber AS ordernumber_6, t0.provider_number AS provider_number_7, t0.membre_id AS membre_id_8 FROM cotisation t0 WHERE t0.membre_id = ?
Parameters:
[
49092
]
|
4 | 0.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.president AS president_5, t0.province_id AS province_id_6, t0.user_id AS user_id_7 FROM federation t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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 |
|
App\Entity\Personne | No errors. |
App\Entity\Membre | No errors. |
App\Entity\Federation | No errors. |
App\Entity\Province | No errors. |
App\Entity\Demande | No errors. |
App\Entity\Cotisation | No errors. |
App\Entity\Transaction | No errors. |