Query Metrics

6 Database Queries
6 Different statements
23.63 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 10.74 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.cle = ? AND t0.langue = ? LIMIT 1
Parameters:
[
  "home"
  "fr"
]
2 5.05 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_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 4
Parameters:
[]
3 2.64 ms
SELECT DISTINCT e0_.id AS id_0, e0_.date_debut AS date_debut_1, e0_.date_fin AS date_fin_2, e0_.id_actualite AS id_actualite_3, e0_.titre AS titre_4, e0_.texte AS texte_5, e0_.image AS image_6, e0_.lien AS lien_7, e0_.ordre AS ordre_8, e0_.actif AS actif_9, e0_.langue AS langue_10, e0_.ecole_id AS ecole_id_11 FROM encarts e0_ WHERE e0_.actif = '1' AND e0_.ecole_id = 'haguenau' ORDER BY e0_.ordre ASC LIMIT 4
Parameters:
[]
4 1.98 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_url AS nom_url_3, t0.nom_de AS nom_de_4, t0.nom_de_url AS nom_de_url_5, t0.texte AS texte_6, t0.texte_de AS texte_de_7, t0.photo AS photo_8, t0.ordre AS ordre_9, t0.actif AS actif_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.couleur AS couleur_13, t0.adresse AS adresse_14, t0.code_postal AS code_postal_15, t0.ville AS ville_16, t0.pays AS pays_17, t0.email AS email_18, t0.tel1 AS tel1_19, t0.tel2 AS tel2_20, t0.facebook AS facebook_21, t0.asso_nom AS asso_nom_22, t0.asso_adresse AS asso_adresse_23, t0.asso_code_postal AS asso_code_postal_24, t0.asso_ville AS asso_ville_25, t0.asso_email AS asso_email_26, t0.asso_tel1 AS asso_tel1_27, t0.asso_tel2 AS asso_tel2_28, t0.site_url AS site_url_29, t0.site_titre AS site_titre_30, t0.texte_asso AS texte_asso_31 FROM ecoles t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC, t0.nom ASC
Parameters:
[
  1
]
5 2.09 ms
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.nom_url AS nom_url_3, t0.tva_intracomm AS tva_intracomm_4, t0.siret AS siret_5, t0.num_compta AS num_compta_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.civilite AS civilite_9, t0.fonction AS fonction_10, t0.adresse AS adresse_11, t0.adresse2 AS adresse2_12, t0.code_postal AS code_postal_13, t0.ville AS ville_14, t0.pays AS pays_15, t0.telephone AS telephone_16, t0.mobile AS mobile_17, t0.fax AS fax_18, t0.email AS email_19, t0.pass AS pass_20, t0.newsletter AS newsletter_21, t0.groupe_newsletter AS groupe_newsletter_22, t0.date AS date_23, t0.connecte AS connecte_24, t0.hors_taxes AS hors_taxes_25, t0.site_web AS site_web_26, t0.actif AS actif_27, t0.note AS note_28, t0.cle AS cle_29, t0.paiement AS paiement_30, t0.old_id AS old_id_31 FROM fournisseurs t0 WHERE t0.actif = ?
Parameters:
[
  1
]
6 1.13 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\Www\Contenu No errors.
App\Entity\Ecoles\Ecoles 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\Actualites\ActualitesCat No errors.
App\Entity\Actualites\ActualitesCom No errors.
App\Entity\Encarts\Encarts No errors.
App\Entity\Www\Login No errors.
App\Entity\ContactForm No errors.
App\Entity\Fournisseurs\Fournisseurs No errors.
App\Entity\Fournisseurs\FournisseursContacts No errors.
App\Entity\Fournisseurs\FournisseursMedias No errors.