Query Metrics

11 Database Queries
5 Different statements
26.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 6.75 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.grid_view = ?
Parameters:
[
  1
]
2 5.11 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_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[
  "published"
  "2025-12-20 01:13:47"
]
3 2.62 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.active AS active_5, u0_.given_name AS given_name_6, u0_.family_name AS family_name_7, u0_.hero_image AS hero_image_8, u0_.headshot AS headshot_9, u0_.title AS title_10, u0_.title_en AS title_en_11, u0_.gender AS gender_12, u0_.type AS type_13, u0_.department_id AS department_id_14 FROM "user" u0_ WHERE (u0_.hero_image IS NOT NULL AND u0_.active = true) AND u0_.type IN ('employee')
Parameters:
[]
4 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 IS NULL
Parameters:
[]
5 2.05 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
]
6 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 = ?
Parameters:
[
  15
]
7 1.40 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
]
8 2.05 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
]
9 1.43 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
]
10 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 = ?
Parameters:
[
  44
]
11 0.87 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
]

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.