GET https://vandactive.demo.gibraltaz.fr/inscription

Query Metrics

50 Database Queries
3 Different statements
14.77 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.43 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.43 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.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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
4 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 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.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:
[
  "Carte jeune expirée"
]
7 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:
[
  "Archive"
]
8 0.32 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.42 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.46 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.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 en cours"
]
12 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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
13 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:
[
  "Demande validée"
]
14 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"
]
15 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:
[
  "Carte jeune expirée"
]
16 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:
[
  "Archive"
]
17 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:
[
  "Inscription ouverte"
]
18 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:
[
  "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.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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
21 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:
[
  "Demande validée"
]
22 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 refusée"
]
23 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:
[
  "Carte jeune expirée"
]
24 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:
[
  "Archive"
]
25 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:
[
  "Inscription ouverte"
]
26 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:
[
  "Contrat terminé"
]
27 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:
[
  "Contrat en cours"
]
28 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:
[
  "Exporté"
]
29 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:
[
  "A vérifier"
]
30 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"
]
31 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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
32 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 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.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:
[
  "Carte jeune expirée"
]
35 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"
]
36 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"
]
37 0.35 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.24 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.29 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.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:
[
  "A vérifier"
]
41 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"
]
42 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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
43 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 validée"
]
44 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 refusée"
]
45 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:
[
  "Carte jeune expirée"
]
46 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"
]
47 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:
[
  "Contrat en cours"
]
48 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 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.81 ms
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3, t0_.color AS color_4 FROM thematique t0_ ORDER BY t0_.nom ASC
Parameters:
[]

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\Thematique No errors.
RelationalEntity\RelProjetThematique No errors.
RelationalEntity\RelAssociationThematique No errors.
RelationalEntity\RelCCEThematique No errors.
RelationalEntity\RelLoisirThematique No errors.
RelationalEntity\RelCompteThematique No errors.