Query Metrics

14 Database Queries
4 Different statements
34.52 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.11 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.id = ?
Parameters:
[
  2
]
2 1.57 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.id = ?
Parameters:
[
  1
]
3 1.80 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
Parameters:
[]
4 2.66 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 = ?
Parameters:
[
  1
]
5 1.83 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 = ?
Parameters:
[
  15
]
6 1.64 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 = ?
Parameters:
[
  21
]
7 3.84 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 = ?
Parameters:
[
  27
]
8 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.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:
[
  38
]
9 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.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:
[
  44
]
10 1.33 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 = ?
Parameters:
[
  53
]
11 1.56 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 = ?
Parameters:
[
  2
]
12 5.23 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 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:
[
  2
]
13 1.68 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 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
]
14 1.78 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
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.