Query Metrics

3 Database Queries
3 Different statements
5.36 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.95 ms
SELECT t0.id AS id_1, t0.titre_url AS titre_url_2, t0.titre AS titre_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.langue AS langue_7, t0.largeur_grand AS largeur_grand_8, t0.largeur_petit AS largeur_petit_9 FROM actualites_cat t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.71 ms
SELECT a0_.id AS id_0, a0_.titre_url AS titre_url_1, a0_.titre AS titre_2, a0_.texte_court AS texte_court_3, a0_.texte AS texte_4, a0_.mots_cles AS mots_cles_5, a0_.auteur AS auteur_6, a0_.auteur_lien AS auteur_lien_7, a0_.date AS date_8, a0_.date_debut AS date_debut_9, a0_.date_fin AS date_fin_10, a0_.ordre AS ordre_11, a0_.actif AS actif_12, a0_.lectures AS lectures_13, a0_.langue AS langue_14, a0_.une AS une_15, a0_.photo AS photo_16, a0_.actualites_associees AS actualites_associees_17, a0_.id_cat1 AS id_cat1_18, a0_.id_cat2 AS id_cat2_19, a0_.ecole_id AS ecole_id_20 FROM actualites a0_ WHERE a0_.actif = '1' AND a0_.id_cat1 = '1' AND a0_.ecole_id = 'haguenau' AND a0_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 8
Parameters:
[]
3 0.70 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre_select AS titre_select_4, t0.titre_page AS titre_page_5, t0.mots_cles AS mots_cles_6, t0.description AS description_7, t0.texte_court AS texte_court_8, t0.texte AS texte_9, t0.langue AS langue_10, t0.ordre AS ordre_11, t0.type AS type_12, t0.deroulant AS deroulant_13, t0.lien_page AS lien_page_14, t0.page AS page_15, t0.filtre AS filtre_16, t0.actif AS actif_17, t0.cle AS cle_18, t0.parent_page_id AS parent_page_id_19, t0.ecole_id AS ecole_id_20 FROM www_contenu t0 WHERE t0.filtre = ? AND t0.ecole_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  "menu"
  "haguenau"
]

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\Actualites\ActualitesCat No errors.
App\Entity\Actualites\Actualites
  • The mappings App\Entity\Actualites\Actualites#idCat2 and App\Entity\Actualites\ActualitesCat#actualites are inconsistent with each other.
App\Entity\Ecoles\Ecoles No errors.
App\Entity\Www\Contenu No errors.