Query Metrics

13 Database Queries
4 Different statements
50.02 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.42 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.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.id = ?
Parameters:
[
  11
]
2 0.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.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.id = ?
Parameters:
[
  1
]
3 3.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.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 1.97 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.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
]
5 3.46 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.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:
[
  1
]
6 3.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.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:
[
  15
]
7 4.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.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:
[
  21
]
8 1.30 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.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:
[
  27
]
9 12.03 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.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:
[
  38
]
10 3.21 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.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:
[
  53
]
11 2.23 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.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:
[
  11
]
12 4.28 ms
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 INNER JOIN employee_product_category ON t0.id = employee_product_category.employee_id WHERE employee_product_category.product_category_id = ? AND t0.type IN ('employee')
Parameters:
[
  11
]
13 3.28 ms
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 INNER JOIN employee_product_category ON t0.id = employee_product_category.employee_id WHERE employee_product_category.product_category_id = ? AND t0.type IN ('employee')
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