Query Metrics

15 Database Queries
8 Different statements
41.37 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.96 ms
(33.74%)
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.grid_position AS grid_position_8, t0.grid_name AS grid_name_9, t0.grid_name_en AS grid_name_en_10, t0.name AS name_11, t0.abstract AS abstract_12, t0.description AS description_13, t0.hero_image AS hero_image_14, t0.hero_video AS hero_video_15, t0.catch_phrase AS catch_phrase_16, t0.catch_phrase_en AS catch_phrase_en_17, t0.template AS template_18, t0.meta_title AS meta_title_19, t0.meta_title_en AS meta_title_en_20, t0.meta_description AS meta_description_21, t0.meta_description_en AS meta_description_en_22, t0.keywords AS keywords_23, t0.keywords_en AS keywords_en_24, t0.faq AS faq_25, t0.faq_en AS faq_en_26, t0.parent_category_id AS parent_category_id_27 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
  44
]
4.98 ms
(12.04%)
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
]
4.97 ms
(12.00%)
2
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.grid_position AS grid_position_8, t0.grid_name AS grid_name_9, t0.grid_name_en AS grid_name_en_10, t0.name AS name_11, t0.abstract AS abstract_12, t0.description AS description_13, t0.hero_image AS hero_image_14, t0.hero_video AS hero_video_15, t0.catch_phrase AS catch_phrase_16, t0.catch_phrase_en AS catch_phrase_en_17, t0.template AS template_18, t0.meta_title AS meta_title_19, t0.meta_title_en AS meta_title_en_20, t0.meta_description AS meta_description_21, t0.meta_description_en AS meta_description_en_22, t0.keywords AS keywords_23, t0.keywords_en AS keywords_en_24, t0.faq AS faq_25, t0.faq_en AS faq_en_26, t0.parent_category_id AS parent_category_id_27 FROM product_category t0 WHERE t0.parent_category_id IS NULL
Parameters:
[]
4.71 ms
(11.38%)
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"
  "2026-04-16 14:28:43"
  1
  2
]
4.31 ms
(10.42%)
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"
  "2026-04-16 14:28:43"
]
3.74 ms
(9.03%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.active AS active_7, t0.has_default_password AS has_default_password_8, t0.personal_number AS personal_number_9, t0.given_name AS given_name_10, t0.family_name AS family_name_11, t0.hero_image AS hero_image_12, t0.headshot AS headshot_13, t0.title AS title_14, t0.title_en AS title_en_15, t0.gender AS gender_16, t0.meal_location AS meal_location_17, t0.department_id AS department_id_18, t0.meal_billing_company_id AS meal_billing_company_id_19, t0.type FROM "user" t0 WHERE t0.id = ? AND t0.type IN ('employee')
Parameters:
[
  "01987e93-cc67-7d96-9627-bd2a654dbe4e"
]
2.74 ms
(6.63%)
1
UPDATE blog_post SET view_count = view_count + 1 WHERE id = ?
Parameters:
[
  1
]
1.97 ms
(4.75%)
1
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 = ?
Parameters:
[
  2
]

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\Department No errors.
App\Entity\Company No errors.
App\Entity\ProductCategory No errors.
App\Entity\StretchfilmCalculator\Calculation No errors.
App\Entity\Meal\MealOrder No errors.
App\Entity\Contact No errors.
App\Entity\Item No errors.
App\Entity\StretchfilmCalculator\Stretchfilm No errors.
App\Entity\StretchfilmCalculator\CuttingMachine No errors.
App\Entity\Meal\MealItem No errors.
App\Entity\Meal\MealDeliveryDate No errors.
App\Entity\Meal\MealSettlement No errors.
App\Entity\StretchfilmCalculator\Inputfilm
  • The association App\Entity\StretchfilmCalculator\Inputfilm#calculations refers to the owning side field App\Entity\StretchfilmCalculator\Calculation#inputfilm which does not exist.
App\Entity\StretchfilmCalculator\Core
  • The association App\Entity\StretchfilmCalculator\Core#calculations refers to the owning side field App\Entity\StretchfilmCalculator\Calculation#core which does not exist.
App\Entity\Meal\MealSupplierConfig No errors.