| 1 |
4.08 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_.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"
]
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 = 'was-macht-gute-verpackungsfolie-aus' AND b0_.status = 'published' AND b0_.published_at IS NOT NULL AND b0_.published_at <= '2025-12-20 05:40:33';
|
| 2 |
3.39 ms |
UPDATE blog_post SET view_count = view_count + 1 WHERE id = ?
UPDATE blog_post SET view_count = view_count + 1 WHERE id = 1;
|
| 3 |
2.38 ms |
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 = ?
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 = 1;
|
| 4 |
3.75 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, 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
]
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 <> 1 AND b0_.status = 'published' AND b0_.published_at IS NOT NULL AND b0_.published_at <= '2025-12-20 05:40:33' AND b1_.id IN (1) GROUP BY b0_.id ORDER BY sclr_22 DESC, CASE WHEN b0_.category_id = 2 THEN 0 ELSE 1 END ASC, b0_.published_at DESC LIMIT 3;
|
| 5 |
4.06 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
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;
|
| 6 |
3.69 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 = ?
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 = 1;
|
| 7 |
1.51 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 = ?
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 = 15;
|
| 8 |
1.26 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 = ?
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 = 21;
|
| 9 |
1.82 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 = ?
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 = 27;
|
| 10 |
1.28 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 = ?
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 = 38;
|
| 11 |
1.60 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 = ?
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 = 44;
|
| 12 |
1.08 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 = ?
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 = 53;
|
| 13 |
1.57 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.given_name AS given_name_7, t0.family_name AS family_name_8, t0.hero_image AS hero_image_9, t0.headshot AS headshot_10, t0.title AS title_11, t0.title_en AS title_en_12, t0.gender AS gender_13, t0.department_id AS department_id_14, t0.type FROM "user" t0 WHERE t0.id = ? AND t0.type IN ('employee')
Parameters: [
"01987e93-cc67-7d96-9627-bd2a654dbe4e"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.given_name AS given_name_7, t0.family_name AS family_name_8, t0.hero_image AS hero_image_9, t0.headshot AS headshot_10, t0.title AS title_11, t0.title_en AS title_en_12, t0.gender AS gender_13, t0.department_id AS department_id_14, t0.type FROM "user" t0 WHERE t0.id = '01987e93-cc67-7d96-9627-bd2a654dbe4e' AND t0.type IN ('employee');
|
| 14 |
1.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.slug AS slug_4, t0.description AS description_5, t0.description_en AS description_en_6, t0.meta_title AS meta_title_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description AS meta_description_9, t0.meta_description_en AS meta_description_en_10, t0.keywords AS keywords_11, t0.keywords_en AS keywords_en_12 FROM blog_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.slug AS slug_4, t0.description AS description_5, t0.description_en AS description_en_6, t0.meta_title AS meta_title_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description AS meta_description_9, t0.meta_description_en AS meta_description_en_10, t0.keywords AS keywords_11, t0.keywords_en AS keywords_en_12 FROM blog_category t0 WHERE t0.id = 2;
|