https://dr.espai-web.com/de/blog/die-schmerzen-schmerzen-sind-eine-individuelle-erfahrung

Query Metrics

19 Database Queries
13 Different statements
4.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 ms
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.slug = ? LIMIT 1
Parameters:
[
  "die-schmerzen-schmerzen-sind-eine-individuelle-erfahrung"
]
2 0.22 ms
SELECT t0.id AS id_1, t0.meta_titre AS meta_titre_2, t0.meta_desc AS meta_desc_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.date_publication AS date_publication_6, t0.auteur_id AS auteur_id_7 FROM blog_article t0 WHERE t0.id = ?
Parameters:
[
  38
]
3 0.26 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id WHERE blog_article_blog_categorie.blog_article_id = ?
Parameters:
[
  38
]
4 0.38 ms
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 ?) LEFT JOIN blog_article_blog_categorie b3_ ON b0_.id = b3_.blog_article_id LEFT JOIN blog_categorie b2_ ON b2_.id = b3_.blog_categorie_id WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL AND b0_.id <> ? ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[
  "de"
  38
]
5 0.30 ms
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:
[
  38
]
6 0.23 ms
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:
[
  18
]
7 0.24 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id WHERE blog_article_blog_categorie.blog_article_id = ?
Parameters:
[
  18
]
8 0.18 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM blog_categorie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  29
]
9 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM blog_categorie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  31
]
10 0.31 ms
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:
[
  "de"
]
11 0.15 ms
SELECT DATABASE()
Parameters:
[]
12 0.35 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "c1dr"
]
13 0.12 ms
SELECT DATABASE()
Parameters:
[]
14 0.25 ms
SELECT b0_.id AS id_0, b0_.nom AS nom_1, b0_.slug AS slug_2, b0_.locale AS locale_3, b0_.translatable_id AS translatable_id_4 FROM blog_categorie_translation b0_ LEFT JOIN blog_categorie b1_ ON b0_.translatable_id = b1_.id WHERE b0_.locale LIKE ? AND b1_.category_parent_id IS NULL ORDER BY b0_.nom ASC
Parameters:
[
  "de"
]
15 0.20 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.category_parent_id = ?
Parameters:
[
  29
]
16 0.18 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.id = ?
Parameters:
[
  10
]
17 0.19 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.category_parent_id = ?
Parameters:
[
  10
]
18 0.16 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.category_parent_id = ?
Parameters:
[
  31
]
19 0.20 ms
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_ ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[]

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