Query Metrics

7 Database Queries
7 Different statements
13.74 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.image_name AS image_name_4, t0.introduction AS introduction_5, t0.insert_html AS insert_html_6, t0.description AS description_7, t0.date_create AS date_create_8, t0.date_update AS date_update_9, t0.commentaire_accepte AS commentaire_accepte_10, t0.reserve_adherent AS reserve_adherent_11, t0.signature AS signature_12, t0.date_publication AS date_publication_13, t0.filename AS filename_14, t0.filename2 AS filename2_15, t0.filename3 AS filename3_16, t0.type_id AS type_id_17, t0.auteur_id AS auteur_id_18, t0.statut_id AS statut_id_19 FROM article t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "10-novembre-2017.-journee-de-sensibilisation-la-fiabilite-de-linformation--nouveaux-enjeux-nouveaux-outils"
]
2 3.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.pays AS pays_6, t0.adresse1 AS adresse1_7, t0.adresse2 AS adresse2_8, t0.code_postal AS code_postal_9, t0.ville AS ville_10, t0.alias AS alias_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.date_create AS date_create_14, t0.date_update AS date_update_15, t0.introduction AS introduction_16, t0.insert_html AS insert_html_17, t0.image_name AS image_name_18, t0.commentaire_accepte AS commentaire_accepte_19, t0.horaires AS horaires_20, t0.reserve_adherent AS reserve_adherent_21, t0.signature AS signature_22, t0.filename AS filename_23, t0.date_publication AS date_publication_24, t0.filename2 AS filename2_25, t0.filename3 AS filename3_26, t0.rubrique_id AS rubrique_id_27, t0.user_create_id AS user_create_id_28, t0.user_update_id AS user_update_id_29, t0.statut_id AS statut_id_30, t0.auteur_id AS auteur_id_31 FROM evenement t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "10-novembre-2017.-journee-de-sensibilisation-la-fiabilite-de-linformation--nouveaux-enjeux-nouveaux-outils"
]
3 1.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "region-auvergne-rhone-alpes"
]
4 0.96 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 2.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN evenement_groupe ON t0.id = evenement_groupe.groupe_id WHERE evenement_groupe.evenement_id = ?
Parameters:
[
  292424
]
6 1.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lien AS lien_3 FROM evenement_lien t0 INNER JOIN evenement_evenement_lien ON t0.id = evenement_evenement_lien.evenement_lien_id WHERE evenement_evenement_lien.evenement_id = ?
Parameters:
[
  292424
]
7 1.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.alias AS alias_6 FROM evenement_type t0 INNER JOIN evenement_evenement_type ON t0.id = evenement_evenement_type.evenement_type_id WHERE evenement_evenement_type.evenement_id = ?
Parameters:
[
  292424
]

Database Connections

Name Service
default doctrine.dbal.default_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
App\Entity\Article No errors.
App\Entity\ArticleType No errors.
App\Entity\User No errors.
App\Entity\Statut No errors.
App\Entity\Evenement No errors.
App\Entity\EvenementRubrique No errors.
App\Entity\EvenementType No errors.
App\Entity\Metier
  • The association App\Entity\Metier#formations refers to the owning side field App\Entity\Formation#metiers which does not exist.
App\Entity\Thematique No errors.
App\Entity\Groupe No errors.
App\Entity\EvenementCommentaire No errors.
App\Entity\EvenementLien No errors.
App\Entity\GroupeType No errors.
App\Entity\Segment No errors.
App\Entity\UserGroupeException No errors.
App\Entity\Partenaire No errors.
App\Entity\CompteRenduReunion No errors.