Query Metrics

8 Database Queries
4 Different statements
2.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.13 ms
(46.16%)
5
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM blog_article_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  44
]
0.52 ms
(21.15%)
1
SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE ?) WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC
Parameters:
[
  "es"
]
0.42 ms
(17.15%)
1
SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE ?) WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC LIMIT 8 OFFSET 24
Parameters:
[
  "es"
]
0.38 ms
(15.55%)
1
SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale = ? AND b1_.slug IS NOT NULL) ORDER BY b0_.date_publication DESC LIMIT 5
Parameters:
[
  "es"
]

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\BlogArticle No errors.
App\Entity\BlogArticleTranslation No errors.
App\Entity\User No errors.
App\Entity\BlogCategorie No errors.