GET https://kleyrgrasso.com/news?p=news

Query Metrics

11 Database Queries
9 Different statements
15.02 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.43 ms
(69.45%)
1
SELECT a0_.id AS id_0, a0_.titre_en AS titre_en_1, a0_.date AS date_2, a0_.nb_vues AS nb_vues_3, a0_.image AS image_4, a0_.introduction_en AS introduction_en_5, a0_.affichage AS affichage_6, a0_.titre_fr AS titre_fr_7, a0_.introduction_fr AS introduction_fr_8, a0_.titre_de AS titre_de_9, a0_.introduction_de AS introduction_de_10, a0_.outside_publications AS outside_publications_11, a0_.seo_description_en AS seo_description_en_12, a0_.seo_description_fr AS seo_description_fr_13, a0_.seo_description_de AS seo_description_de_14, a0_.categories_id AS categories_id_15 FROM actualites a0_ INNER JOIN actu_expertises a1_ ON a0_.id = a1_.actualite_id INNER JOIN categories_actualites c2_ ON a0_.categories_id = c2_.id WHERE a0_.date >= ? ORDER BY a0_.date DESC
Parameters:
[
  "2020-01-01"
]
1.01 ms
(6.70%)
2
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC
Parameters:
[]
0.73 ms
(4.85%)
1
SELECT t0.id AS id_1, t0.titre_en AS titre_en_2, t0.titre_fr AS titre_fr_3, t0.titre_de AS titre_de_4, t0.intro_fr AS intro_fr_5, t0.intro_en AS intro_en_6, t0.intro_de AS intro_de_7, t0.page_id AS page_id_8, t0.expertise_id AS expertise_id_9, t0.event_id AS event_id_10, t0.award_id AS award_id_11 FROM qand_a t0 WHERE t0.page_id = ?
Parameters:
[
  5
]
0.63 ms
(4.17%)
1
SELECT t0.id AS id_1, t0.texte_fr AS texte_fr_2, t0.texte_en AS texte_en_3, t0.texte_de AS texte_de_4, t0.image AS image_5, t0.pages_id AS pages_id_6, t0.expertises_id AS expertises_id_7 FROM sliders t0 WHERE t0.pages_id = ?
Parameters:
[
  5
]
0.57 ms
(3.82%)
2
SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0
Parameters:
[]
0.52 ms
(3.44%)
1
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 WHERE t0.affichage = ? ORDER BY t0.nom_en ASC
Parameters:
[
  "Oui"
]
0.39 ms
(2.60%)
1
SELECT t0.id AS id_1, t0.route AS route_2, t0.image_slider AS image_slider_3, t0.titre_fr_seo AS titre_fr_seo_4, t0.titre_en_seo AS titre_en_seo_5, t0.titre_de_seo AS titre_de_seo_6, t0.description_fr_seo AS description_fr_seo_7, t0.description_en_seo AS description_en_seo_8, t0.description_de_seo AS description_de_seo_9, t0.titre_fr AS titre_fr_10, t0.titre_en AS titre_en_11, t0.titre_de AS titre_de_12 FROM pages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
0.38 ms
(2.54%)
1
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_de AS libelle_de_4 FROM categories_actualites t0 ORDER BY t0.libelle_en ASC
Parameters:
[]
0.37 ms
(2.44%)
1
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_de AS libelle_de_4 FROM categories_actualites t0 WHERE t0.id IN (?, ?, ?, ?, ?) ORDER BY t0.libelle_en ASC
Parameters:
[
  10
  8
  11
  9
  6
]

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.