GET https://vandactive.demo.gibraltaz.fr/cartes-jeune/demandes

Query Metrics

49 Database Queries
2 Different statements
14.51 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.49 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.42 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.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...)"
]
4 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"
]
5 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"
]
6 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"
]
7 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:
[
  "Archive"
]
8 0.37 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.59 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.57 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.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"
]
12 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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
13 0.34 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.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 refusée"
]
15 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"
]
16 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:
[
  "Archive"
]
17 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"
]
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.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:
[
  "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.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"
]
22 0.20 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.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:
[
  "Carte jeune expirée"
]
24 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"
]
25 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:
[
  "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.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"
]
28 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:
[
  "Exporté"
]
29 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:
[
  "A vérifier"
]
30 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 en cours"
]
31 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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
32 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"
]
33 0.20 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.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"
]
35 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:
[
  "Archive"
]
36 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:
[
  "Inscription ouverte"
]
37 0.45 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.27 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.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:
[
  "A vérifier"
]
41 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:
[
  "Demande en cours"
]
42 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:
[
  "Informations complémentaires à fournir (infos ou pièces...)"
]
43 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"
]
44 0.45 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.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"
]
46 0.20 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.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:
[
  "Contrat en cours"
]
48 0.20 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.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:
[
  "Inscription ouverte"
]

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.