Query Metrics
57
Database Queries
8
Different statements
19.19 ms
Query time
10
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
12.35 ms (64.34%) |
45 |
SELECT t0.id AS id_1, t0.libelle_statut AS libelle_statut_2, t0.slug AS slug_3 FROM statut t0 WHERE t0.libelle_statut = ? LIMIT 1
Parameters:
[
"A vérifier"
]
|
|
2.21 ms (11.50%) |
4 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4 FROM role t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
"Détenteur d'une carte jeune"
]
|
|
1.19 ms (6.20%) |
3 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5 FROM thematique t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
0.77 ms (4.00%) |
1 |
SELECT t0.id AS id_1, t0.association_id AS association_id_2, t0.thematique_id AS thematique_id_3 FROM associations_thematiques t0 WHERE t0.association_id = ?
Parameters:
[
17
]
|
|
0.74 ms (3.87%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.code_postal AS code_postal_6, t0.coordonnees_maps AS coordonnees_maps_7, t0.description AS description_8, t0.numero_batiment AS numero_batiment_9, t0.nom_batiment AS nom_batiment_10, t11.id AS id_12, t11.solde AS solde_13, t11.date_renouvellement AS date_renouvellement_14, t11.numero_carte AS numero_carte_15, t11.prenom_representant AS prenom_representant_16, t11.nom_representant AS nom_representant_17, t11.prenom_enfant AS prenom_enfant_18, t11.nom_enfant AS nom_enfant_19, t11.email_contact AS email_contact_20, t11.telephone AS telephone_21, t11.date_naissance AS date_naissance_22, t11.sexe AS sexe_23, t11.motif AS motif_24, t11.is_pour_demandeur AS is_pour_demandeur_25, t11.lieu_id AS lieu_id_26, t11.photo_id AS photo_id_27, t11.statut_id AS statut_id_28 FROM lieu t0 LEFT JOIN carte_jeune t11 ON t11.lieu_id = t0.id WHERE t0.id = ?
Parameters:
[
43
]
|
|
0.71 ms (3.67%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.siret AS siret_3, t0.nom AS nom_4, t0.objet AS objet_5, t0.description AS description_6, t0.nom_president AS nom_president_7, t0.prenom_president AS prenom_president_8, t0.telephone AS telephone_9, t0.email AS email_10, t0.url_site AS url_site_11, t0.image AS image_12, t0.motif AS motif_13, t0.is_eligible AS is_eligible_14, t0.statut_id AS statut_id_15, t0.adhesionCJ_id AS adhesionCJ_id_16 FROM association t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"test-678"
]
|
|
0.66 ms (3.42%) |
1 |
SELECT t0.id AS id_1, t0.association_id AS association_id_2, t0.loisir_id AS loisir_id_3 FROM associations_loisirs t0 WHERE t0.association_id = ?
Parameters:
[
17
]
|
|
0.58 ms (3.01%) |
1 |
SELECT t0.id AS id_1, t0.association_id AS association_id_2, t0.lieu_id AS lieu_id_3 FROM associations_lieux t0 WHERE t0.association_id IN (?)
Parameters:
[
17
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| secondary | doctrine.dbal.secondary_connection |
| third | doctrine.dbal.third_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 |
|---|---|
| Entity\Statut | No errors. |
| Entity\Role |
|
| RelationalEntity\RelCompteRole | No errors. |
| RelationalEntity\RelPermissionRole | No errors. |
| RelationalEntity\RelRoleRelAssociationCompte | No errors. |
| RelationalEntity\RelCompteCarteJeune |
|
| Entity\CompteEnAttente |
|
| Entity\Association |
|
| Entity\AdhesionCJ |
|
| Entity\Projet |
|
| RelationalEntity\RelAssociationLoisir | No errors. |
| RelationalEntity\RelAssociationLieu | No errors. |
| RelationalEntity\RelAssociationThematique | No errors. |
| RelationalEntity\RelAssociationCompte | No errors. |
| RelationalEntity\RelAssociationContact | No errors. |
| RelationalEntity\RelAssociationJustificatif | No errors. |
| RelationalEntity\RelAssociationCCE | No errors. |
| RelationalEntity\RelAssociationInfoPdf |
|
| Entity\Lieu |
|
| Entity\Thematique | No errors. |
| RelationalEntity\RelProjetThematique | No errors. |
| RelationalEntity\RelCCEThematique | No errors. |
| RelationalEntity\RelLoisirThematique | No errors. |
| RelationalEntity\RelCompteThematique | No errors. |
| Entity\Loisir |
|
| Entity\CarteJeune | No errors. |
| Entity\Photo | No errors. |
| Entity\Evenement |
|