Query Metrics
29
Database Queries
5
Different statements
10.10 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.24 ms (42.01%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 INNER JOIN operation_product ON t0.id = operation_product.product_id WHERE operation_product.operation_id = ?
Parameters:
[
47
]
|
3.18 ms (31.45%) |
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
]
|
1.94 ms (19.25%) |
8 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.display_menu AS display_menu_5, t0.display_home AS display_home_6, t0.display_product_menu AS display_product_menu_7, t0.view_by AS view_by_8, t0.home_emplacement AS home_emplacement_9, t0.allowed_category AS allowed_category_10, t0.excluded_category AS excluded_category_11, t0.allowed_group AS allowed_group_12, t0.excluded_group AS excluded_group_13, t0.allowed_market AS allowed_market_14, t0.excluded_market AS excluded_market_15, t0.external_link AS external_link_16, t0.home_order AS home_order_17, t0.is_active AS is_active_18, t0.image_path AS image_path_19, t0.secondary_image_path AS secondary_image_path_20, t0.slug AS slug_21, t0.operation_parent_id AS operation_parent_id_22, t0.operation_type_id AS operation_type_id_23 FROM operation t0 WHERE t0.operation_parent_id = ?
Parameters:
[
47
]
|
0.50 ms (4.95%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.display_menu AS display_menu_5, t0.display_home AS display_home_6, t0.display_product_menu AS display_product_menu_7, t0.view_by AS view_by_8, t0.home_emplacement AS home_emplacement_9, t0.allowed_category AS allowed_category_10, t0.excluded_category AS excluded_category_11, t0.allowed_group AS allowed_group_12, t0.excluded_group AS excluded_group_13, t0.allowed_market AS allowed_market_14, t0.excluded_market AS excluded_market_15, t0.external_link AS external_link_16, t0.home_order AS home_order_17, t0.is_active AS is_active_18, t0.image_path AS image_path_19, t0.secondary_image_path AS secondary_image_path_20, t0.slug AS slug_21, t0.operation_parent_id AS operation_parent_id_22, t0.operation_type_id AS operation_type_id_23 FROM operation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"agendas-calendriers-2025"
]
|
0.24 ms (2.35%) |
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.
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. |