https://card.dev.smartegy.ca/inscrire-parent-activite-espace-membre

Query Metrics

6 Database Queries
5 Different statements
6.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.17 ms
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
]
2 1.19 ms
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"
]
3 0.42 ms
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"
]
4 1.17 ms
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"
]
5 1.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM nom_activite t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 1.43 ms
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
]

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.