Query Metrics
20
Database Queries
3
Different statements
5.29 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
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 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\PromotionalOperations\Operation | No errors. |
App\Entity\PromotionalOperations\OperationType | No errors. |
App\Entity\Store\StoreHouse | No errors. |
App\Entity\Product\Product | No errors. |
App\Entity\Product\Category | No errors. |