Query Metrics
6
Database Queries
5
Different statements
6.48 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.61 ms (24.79%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.paysorigine AS paysorigine_5, t0.allergie AS allergie_6, t0.nomintervenant AS nomintervenant_7, t0.emailparent AS emailparent_8, t0.telparent AS telparent_9, t0.adresseparent AS adresseparent_10, t0.nbrfrsr AS nbrfrsr_11, t0.type AS type_12, t0.courriel AS courriel_13, t0.telephone AS telephone_14, t0.adresse AS adresse_15, t0.monoparental AS monoparental_16, t0.statutoccupation AS statutoccupation_17, t0.nbrjeunes AS nbrjeunes_18, t0.nomparent AS nomparent_19, t0.tokenreinscription AS tokenreinscription_20, t0.tokenreinscriptionlifetime AS tokenreinscriptionlifetime_21, t0.emploi AS emploi_22, t0.datenaissance AS datenaissance_23, t0.refererpar AS refererpar_24, t0.idfamille AS idfamille_25, t0.passwordparent AS passwordparent_26, t0.tokeninscription AS tokeninscription_27, t0.tokeninscriptionlifetime AS tokeninscriptionlifetime_28, t0.telephone2 AS telephone2_29, t0.email2 AS email2_30, t0.langue_id AS langue_id_31, t0.habitation_id AS habitation_id_32, t0.reference_id AS reference_id_33, t0.statut_id AS statut_id_34, t0.parent_id AS parent_id_35, t0.revenue_familiale_id AS revenue_familiale_id_36 FROM membre t0 WHERE t0.courriel = ? LIMIT 1
Parameters:
[
"mariem.guerdelli@gmail.com"
]
|
1.43 ms (22.01%) |
1 |
SELECT t0.id AS id_1, t0.typeactivite AS typeactivite_2, t0.themeactivite AS themeactivite_3, t0.objectifactivite AS objectifactivite_4, t0.impactactivite AS impactactivite_5, t0.programmeid AS programmeid_6, t0.inscription AS inscription_7, t0.trancheage AS trancheage_8, t0.dateactivite AS dateactivite_9, t0.nomactivite_id AS nomactivite_id_10 FROM activite t0 INNER JOIN membre_activite ON t0.id = membre_activite.activite_id WHERE membre_activite.membre_id = ?
Parameters:
[
120
]
|
1.17 ms (18.14%) |
1 |
SELECT a0_.id AS id_0, a0_.typeactivite AS typeactivite_1, a0_.themeactivite AS themeactivite_2, a0_.objectifactivite AS objectifactivite_3, a0_.impactactivite AS impactactivite_4, a0_.programmeid AS programmeid_5, a0_.inscription AS inscription_6, a0_.trancheage AS trancheage_7, a0_.dateactivite AS dateactivite_8, a0_.nomactivite_id AS nomactivite_id_9 FROM activite a0_ WHERE a0_.inscription = ? AND a0_.trancheage IN (?, ?)
Parameters:
[ "Ouverte" "Adulte" "0-5 ans" ] |
1.17 ms (18.12%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.role AS role_5, t0.nom AS nom_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
26
]
|
1.10 ms (16.93%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM nom_activite 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 | No errors. |
App\Entity\Suivi | No errors. |
App\Entity\Membre | No errors. |
App\Entity\Langue | No errors. |
App\Entity\Habitation | No errors. |
App\Entity\Organisme | No errors. |
App\Entity\statut | No errors. |
App\Entity\RevenueFamiliale | No errors. |
App\Entity\Anneescolaire | No errors. |
App\Entity\Freresoeur | No errors. |
App\Entity\MembreSeanceSuiviEns | No errors. |
App\Entity\Activite | No errors. |
App\Entity\Projet | No errors. |
App\Entity\NomActivite | No errors. |