GET https://staging.pgdis.com/

Query Metrics

20 Database Queries
3 Different statements
5.29 ms Query time
0 Invalid entities
26 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.79 ms
(71.74%)
18
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  1
]
0.82 ms
(15.44%)
1
SELECT o0_.id AS id_0, o0_.label AS label_1, o0_.start_date AS start_date_2, o0_.end_date AS end_date_3, o0_.display_menu AS display_menu_4, o0_.display_home AS display_home_5, o0_.display_product_menu AS display_product_menu_6, o0_.view_by AS view_by_7, o0_.home_emplacement AS home_emplacement_8, o0_.allowed_category AS allowed_category_9, o0_.excluded_category AS excluded_category_10, o0_.allowed_group AS allowed_group_11, o0_.excluded_group AS excluded_group_12, o0_.allowed_market AS allowed_market_13, o0_.excluded_market AS excluded_market_14, o0_.external_link AS external_link_15, o0_.home_order AS home_order_16, o0_.is_active AS is_active_17, o0_.image_path AS image_path_18, o0_.secondary_image_path AS secondary_image_path_19, o0_.slug AS slug_20, o0_.operation_parent_id AS operation_parent_id_21, o0_.operation_type_id AS operation_type_id_22 FROM operation o0_ WHERE o0_.start_date <= ? AND o0_.end_date >= ? AND o0_.is_active = 1 AND o0_.view_by LIKE ? AND o0_.operation_parent_id IS NULL ORDER BY o0_.home_order ASC, o0_.home_emplacement ASC, o0_.start_date ASC, o0_.end_date DESC
Parameters:
[
  "2025-09-18 07:10:37"
  "2025-09-18 07:10:37"
  "%2%"
]
0.68 ms
(12.83%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product\Category 18
App\Entity\PromotionalOperations\Operation 6
App\Entity\PromotionalOperations\OperationType 2