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

Queries

Group similar statements

# Time Info
1 0.50 ms
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"
]
2 4.24 ms
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 0.24 ms
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
]
4 0.22 ms
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
]
5 0.20 ms
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:
[
  16
]
6 0.16 ms
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:
[
  17
]
7 0.15 ms
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:
[
  18
]
8 0.17 ms
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:
[
  19
]
9 0.15 ms
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:
[
  20
]
10 0.15 ms
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:
[
  21
]
11 0.15 ms
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:
[
  22
]
12 0.14 ms
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:
[
  23
]
13 0.14 ms
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:
[
  24
]
14 0.17 ms
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:
[
  25
]
15 0.16 ms
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:
[
  26
]
16 0.15 ms
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:
[
  27
]
17 0.14 ms
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:
[
  28
]
18 0.16 ms
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:
[
  29
]
19 0.16 ms
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:
[
  30
]
20 0.14 ms
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:
[
  31
]
21 0.47 ms
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:
[
  32
]
22 0.27 ms
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
]
23 0.30 ms
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:
[
  48
]
24 0.26 ms
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:
[
  79
]
25 0.22 ms
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:
[
  83
]
26 0.30 ms
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:
[
  84
]
27 0.20 ms
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:
[
  85
]
28 0.19 ms
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:
[
  86
]
29 0.20 ms
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:
[
  87
]

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.