GET https://vandactive.demo.gibraltaz.fr/associations/kjmlkdjflkmsdjf

Query Metrics

55 Database Queries
8 Different statements
18.21 ms Query time
10 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.29 ms
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 0.48 ms
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:
[
  "Demande en cours"
]
3 0.30 ms
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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
4 0.35 ms
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:
[
  "Demande validée"
]
5 0.25 ms
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:
[
  "Demande refusée"
]
6 0.21 ms
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:
[
  "Carte jeune expirée"
]
7 0.23 ms
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:
[
  "Archive"
]
8 0.23 ms
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:
[
  "Inscription ouverte"
]
9 0.51 ms
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"
]
10 0.51 ms
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"
]
11 0.33 ms
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:
[
  "Demande en cours"
]
12 0.30 ms
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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
13 0.26 ms
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:
[
  "Demande validée"
]
14 0.33 ms
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:
[
  "Demande refusée"
]
15 0.24 ms
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:
[
  "Carte jeune expirée"
]
16 0.22 ms
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:
[
  "Archive"
]
17 0.29 ms
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:
[
  "Inscription ouverte"
]
18 0.31 ms
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"
]
19 0.25 ms
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:
[
  "Demande en cours"
]
20 0.22 ms
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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
21 0.19 ms
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:
[
  "Demande validée"
]
22 0.21 ms
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:
[
  "Demande refusée"
]
23 0.19 ms
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:
[
  "Carte jeune expirée"
]
24 0.27 ms
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:
[
  "Archive"
]
25 0.21 ms
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:
[
  "Inscription ouverte"
]
26 0.18 ms
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:
[
  "Contrat terminé"
]
27 0.26 ms
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:
[
  "Contrat en cours"
]
28 0.21 ms
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:
[
  "Exporté"
]
29 0.27 ms
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"
]
30 0.22 ms
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:
[
  "Demande en cours"
]
31 0.29 ms
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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
32 0.31 ms
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:
[
  "Demande validée"
]
33 0.23 ms
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:
[
  "Demande refusée"
]
34 0.29 ms
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:
[
  "Carte jeune expirée"
]
35 0.26 ms
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:
[
  "Archive"
]
36 0.23 ms
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:
[
  "Inscription ouverte"
]
37 0.41 ms
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"
]
38 0.25 ms
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:
[
  "Droit de consultation"
]
39 0.28 ms
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:
[
  "Administrateur d'Association"
]
40 0.27 ms
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"
]
41 0.33 ms
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:
[
  "Demande en cours"
]
42 0.39 ms
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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
43 0.25 ms
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:
[
  "Demande validée"
]
44 0.28 ms
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:
[
  "Demande refusée"
]
45 0.24 ms
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:
[
  "Carte jeune expirée"
]
46 0.27 ms
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:
[
  "Archive"
]
47 0.25 ms
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:
[
  "Contrat en cours"
]
48 0.24 ms
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:
[
  "Contrat terminé"
]
49 0.22 ms
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:
[
  "Inscription ouverte"
]
50 0.58 ms
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:
[
  "kjmlkdjflkmsdjf"
]
51 0.61 ms
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:
[
  6
]
52 0.66 ms
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:
[
  6
]
53 0.46 ms
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:
[
  3
]
54 0.57 ms
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:
[
  6
]
55 0.74 ms
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:
[
  1
]

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
  • The mappings Entity\Role#compteEnAttente and Entity\CompteEnAttente#role are inconsistent with each other.
RelationalEntity\RelCompteRole No errors.
RelationalEntity\RelPermissionRole No errors.
RelationalEntity\RelRoleRelAssociationCompte No errors.
RelationalEntity\RelCompteCarteJeune
  • The association RelationalEntity\RelCompteCarteJeune#statut refers to the inverse side field Entity\Statut#relCompteCarteJeune which does not exist.
Entity\CompteEnAttente
  • The association Entity\CompteEnAttente#association refers to the inverse side field Entity\Association#id which is not defined as association.
  • The association Entity\CompteEnAttente#association refers to the inverse side field Entity\Association#id which does not exist.
  • The association Entity\CompteEnAttente#role refers to the inverse side field Entity\Role#id which is not defined as association.
  • The association Entity\CompteEnAttente#role refers to the inverse side field Entity\Role#id which does not exist.
Entity\Association
  • The field Entity\Association#adhesionCJ is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Entity\AdhesionCJ#association does not contain the required 'inversedBy="adhesionCJ"' attribute.
  • The mappings Entity\Association#compteEnAttente and Entity\CompteEnAttente#association are inconsistent with each other.
Entity\AdhesionCJ
  • The field Entity\AdhesionCJ#association is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Entity\Association#adhesionCJ does not contain the required 'inversedBy="association"' attribute.
Entity\Projet
  • The field 'Entity\Projet#statut' has the property type 'Entity\Statut' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
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
  • The association RelationalEntity\RelAssociationInfoPdf#infoPdf refers to the inverse side field Entity\InfoPdf#relAssociationInfoPdf which does not exist.
Entity\Lieu
  • The field Entity\Lieu#evenements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Entity\Evenement#lieu does not contain the required 'inversedBy="evenements"' attribute.
Entity\Thematique No errors.
RelationalEntity\RelProjetThematique No errors.
RelationalEntity\RelCCEThematique No errors.
RelationalEntity\RelLoisirThematique No errors.
RelationalEntity\RelCompteThematique No errors.
Entity\Loisir
  • The association Entity\Loisir#frequence refers to the inverse side field Entity\Frequence#loisir which does not exist.
  • The field Entity\Loisir#prixTrancheAge is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Entity\PrixTrancheAge#loisir does not contain the required 'inversedBy="prixTrancheAge"' attribute.
Entity\CarteJeune No errors.
Entity\Photo No errors.
Entity\Evenement
  • The association Entity\Evenement#frequence refers to the inverse side field Entity\Frequence#loisir which does not exist.
  • The field Entity\Evenement#prixTrancheAge is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Entity\PrixTrancheAge#loisir does not contain the required 'inversedBy="prixTrancheAge"' attribute.