Query Metrics

13 Database Queries
7 Different statements
48.23 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.60 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM blog_tag b0_ WHERE b0_.slug = ?
Parameters:
[
  "fachbeitrag"
]
2 7.83 ms
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.title AS title_2, b0_.title_en AS title_en_3, b0_.excerpt AS excerpt_4, b0_.excerpt_en AS excerpt_en_5, b0_.content AS content_6, b0_.content_en AS content_en_7, b0_.catch_phrase AS catch_phrase_8, b0_.catch_phrase_en AS catch_phrase_en_9, b0_.featured_image AS featured_image_10, b0_.status AS status_11, b0_.created_at AS created_at_12, b0_.updated_at AS updated_at_13, b0_.published_at AS published_at_14, b0_.view_count AS view_count_15, b0_.meta_title AS meta_title_16, b0_.meta_title_en AS meta_title_en_17, b0_.meta_description AS meta_description_18, b0_.meta_description_en AS meta_description_en_19, b0_.keywords AS keywords_20, b0_.keywords_en AS keywords_en_21, b0_.author_id AS author_id_22, b0_.category_id AS category_id_23 FROM blog_post b0_ INNER JOIN blog_post_tag b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.id = ? AND b0_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 12
Parameters:
[
  1
  "published"
  "2025-12-20 05:37:05"
]
3 1.97 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.name_en AS name_en_2, b0_.slug AS slug_3, b0_.description AS description_4, b0_.description_en AS description_en_5, b0_.meta_title AS meta_title_6, b0_.meta_title_en AS meta_title_en_7, b0_.meta_description AS meta_description_8, b0_.meta_description_en AS meta_description_en_9, b0_.keywords AS keywords_10, b0_.keywords_en AS keywords_en_11, COUNT(b1_.id) AS sclr_12 FROM blog_category b0_ LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id WHERE b1_.status = ? AND b1_.published_at IS NOT NULL AND b1_.published_at <= ? GROUP BY b0_.id HAVING COUNT(b1_.id) > 0 ORDER BY b0_.name ASC
Parameters:
[
  "published"
  "2025-12-20 05:37:05"
]
4 1.66 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(b1_.id) AS sclr_3 FROM blog_tag b0_ LEFT JOIN blog_post_tag b2_ ON b0_.id = b2_.blog_tag_id LEFT JOIN blog_post b1_ ON b1_.id = b2_.blog_post_id WHERE b1_.status = ? AND b1_.published_at IS NOT NULL AND b1_.published_at <= ? GROUP BY b0_.id HAVING COUNT(b1_.id) > 0 ORDER BY sclr_3 DESC LIMIT 10
Parameters:
[
  "published"
  "2025-12-20 05:37:05"
]
5 3.62 ms
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.title AS title_2, b0_.title_en AS title_en_3, b0_.excerpt AS excerpt_4, b0_.excerpt_en AS excerpt_en_5, b0_.content AS content_6, b0_.content_en AS content_en_7, b0_.catch_phrase AS catch_phrase_8, b0_.catch_phrase_en AS catch_phrase_en_9, b0_.featured_image AS featured_image_10, b0_.status AS status_11, b0_.created_at AS created_at_12, b0_.updated_at AS updated_at_13, b0_.published_at AS published_at_14, b0_.view_count AS view_count_15, b0_.meta_title AS meta_title_16, b0_.meta_title_en AS meta_title_en_17, b0_.meta_description AS meta_description_18, b0_.meta_description_en AS meta_description_en_19, b0_.keywords AS keywords_20, b0_.keywords_en AS keywords_en_21, b0_.author_id AS author_id_22, b0_.category_id AS category_id_23 FROM blog_post b0_ WHERE b0_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 5
Parameters:
[
  "published"
  "2025-12-20 05:37:05"
]
6 2.62 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id IS NULL
Parameters:
[]
7 4.89 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  1
]
8 3.55 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  15
]
9 6.76 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  21
]
10 1.74 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  27
]
11 5.56 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  38
]
12 3.90 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  44
]
13 1.52 ms
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.name AS name_8, t0.abstract AS abstract_9, t0.description AS description_10, t0.hero_image AS hero_image_11, t0.hero_video AS hero_video_12, t0.catch_phrase AS catch_phrase_13, t0.catch_phrase_en AS catch_phrase_en_14, t0.template AS template_15, t0.meta_title AS meta_title_16, t0.meta_title_en AS meta_title_en_17, t0.meta_description AS meta_description_18, t0.meta_description_en AS meta_description_en_19, t0.keywords AS keywords_20, t0.keywords_en AS keywords_en_21, t0.parent_category_id AS parent_category_id_22 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  53
]

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\Blog\BlogTag No errors.
App\Entity\Blog\BlogPost No errors.
App\Entity\User No errors.
App\Entity\Employee No errors.
App\Entity\Blog\BlogCategory No errors.
App\Entity\ProductCategory No errors.
App\Entity\Contact No errors.