Redirect 301 redirect from GET @app_portail_cce (8be7c5)

GET https://vandactive.demo.gibraltaz.fr/cce/annuaire/

Query Metrics

50 Database Queries
3 Different statements
15.75 ms Query time
4 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.67 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.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"
]
3 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...)"
]
4 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"
]
5 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"
]
6 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"
]
7 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"
]
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.39 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.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:
[
  "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.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...)"
]
13 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"
]
14 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"
]
15 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"
]
16 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"
]
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.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:
[
  "A vérifier"
]
19 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"
]
20 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...)"
]
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.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"
]
23 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"
]
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.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"
]
26 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é"
]
27 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 en cours"
]
28 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:
[
  "Exporté"
]
29 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:
[
  "A vérifier"
]
30 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 en cours"
]
31 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...)"
]
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.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"
]
34 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"
]
35 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"
]
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.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:
[
  "Détenteur d'une carte jeune"
]
38 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:
[
  "Droit de consultation"
]
39 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:
[
  "Administrateur d'Association"
]
40 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:
[
  "A vérifier"
]
41 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"
]
42 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...)"
]
43 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 validée"
]
44 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"
]
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.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"
]
47 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:
[
  "Contrat en cours"
]
48 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:
[
  "Contrat terminé"
]
49 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"
]
50 2.34 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.nom AS nom_2, c0_.nom_representant AS nom_representant_3, c0_.prenom_representant AS prenom_representant_4, c0_.description AS description_5, c0_.profil_recherche AS profil_recherche_6, c0_.date_debut AS date_debut_7, c0_.date_fin AS date_fin_8, c0_.nb_heures AS nb_heures_9, c0_.adresse AS adresse_10, c0_.telephone AS telephone_11, c0_.horaires AS horaires_12, c0_.motif AS motif_13, c0_.type AS type_14, c0_.lieu_id AS lieu_id_15, c0_.statut_id AS statut_id_16 FROM cce c0_ WHERE c0_.type IN ('cce_association', 'cce_ville') ORDER BY c0_.date_debut 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\CCE No errors.
Entity\CCEAssociation No errors.
Entity\CCEVille No errors.
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.