Query Metrics

12 Database Queries
5 Different statements
16.10 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.69 ms
(47.78%)
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
]
2.66 ms
(16.52%)
1
SELECT p0_.id AS id_0, p0_.thumbnail AS thumbnail_1, p0_.description_en AS description_en_2, p0_.abstract_en AS abstract_en_3, p0_.name_en AS name_en_4, p0_.slug AS slug_5, p0_.grid_view AS grid_view_6, p0_.grid_position AS grid_position_7, p0_.grid_name AS grid_name_8, p0_.grid_name_en AS grid_name_en_9, p0_.name AS name_10, p0_.abstract AS abstract_11, p0_.description AS description_12, p0_.hero_image AS hero_image_13, p0_.hero_video AS hero_video_14, p0_.catch_phrase AS catch_phrase_15, p0_.catch_phrase_en AS catch_phrase_en_16, p0_.template AS template_17, p0_.meta_title AS meta_title_18, p0_.meta_title_en AS meta_title_en_19, p0_.meta_description AS meta_description_20, p0_.meta_description_en AS meta_description_en_21, p0_.keywords AS keywords_22, p0_.keywords_en AS keywords_en_23, p0_.faq AS faq_24, p0_.faq_en AS faq_en_25, p0_.parent_category_id AS parent_category_id_26 FROM product_category p0_ WHERE p0_.grid_position IS NOT NULL ORDER BY p0_.grid_position ASC
Parameters:
[]
2.55 ms
(15.86%)
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:
[]
1.79 ms
(11.11%)
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_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[
  "published"
  "2026-04-16 15:48:13"
]
1.41 ms
(8.73%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.is_verified AS is_verified_5, u0_.active AS active_6, u0_.has_default_password AS has_default_password_7, u0_.personal_number AS personal_number_8, u0_.given_name AS given_name_9, u0_.family_name AS family_name_10, u0_.hero_image AS hero_image_11, u0_.headshot AS headshot_12, u0_.title AS title_13, u0_.title_en AS title_en_14, u0_.gender AS gender_15, u0_.meal_location AS meal_location_16, u0_.type AS type_17, u0_.department_id AS department_id_18, u0_.meal_billing_company_id AS meal_billing_company_id_19 FROM "user" u0_ WHERE (u0_.hero_image IS NOT NULL AND u0_.active = true) AND u0_.type IN ('employee')
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

Class Mapping errors
App\Entity\ProductCategory No errors.
App\Entity\User No errors.
App\Entity\Employee No errors.
App\Entity\Contact No errors.
App\Entity\Blog\BlogPost 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\StretchfilmCalculator\Calculation No errors.
App\Entity\Meal\MealOrder 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.