GET https://staging.pgdis.com/operation/agendas-calendriers-2025

Query Metrics

29 Database Queries
5 Different statements
10.10 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.