Query Metrics
12
Database Queries
6
Different statements
29.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.24 ms (40.94%) |
7 |
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
]
|
||||||||||||||||||||||||||||||
|
4.08 ms (13.66%) |
1 |
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_.slug = ? AND b0_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ?
Parameters:
[ "was-macht-gute-verpackungsfolie-aus" "published" "2025-12-20 05:40:33" ]
|
||||||||||||||||||||||||||||||
|
4.06 ms (13.57%) |
1 |
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:
[] |
||||||||||||||||||||||||||||||
|
3.75 ms (12.53%) |
1 |
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, COUNT(b1_.id) AS sclr_22, b0_.author_id AS author_id_23, b0_.category_id AS category_id_24 FROM blog_post b0_ LEFT JOIN blog_post_tag b2_ ON b0_.id = b2_.blog_post_id LEFT JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b0_.id <> ? AND b0_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? AND b1_.id IN (?) GROUP BY b0_.id ORDER BY sclr_22 DESC, CASE WHEN b0_.category_id = ? THEN 0 ELSE 1 END ASC, b0_.published_at DESC LIMIT 3
Parameters:
[ 1 "published" "2025-12-20 05:40:33" 1 2 ]
|
||||||||||||||||||||||||||||||
|
3.39 ms (11.35%) |
1 |
UPDATE blog_post SET view_count = view_count + 1 WHERE id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (7.94%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = ?
Parameters:
[
1
]
|
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\BlogPost | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\Blog\BlogCategory | No errors. |
| App\Entity\Blog\BlogTag | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\Contact | No errors. |