Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.price_id AS price_id_4,
  t0.product_id AS product_id_5
FROM
  product_price t0
WHERE
  t0.price_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 413392 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value1 AS value1_3,
  t0.value2 AS value2_4,
  t0.value3 AS value3_5
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = 'TarifDefautBtoB' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.characteristic_label_id AS characteristic_label_id_4
FROM
  characteristic t0
WHERE
  t0.product_id = ?
  AND t0.characteristic_label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 413396 AND t0.characteristic_label_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.affiliated_society AS affiliated_society_3,
  t0.address1 AS address1_4,
  t0.address2 AS address2_5,
  t0.address3 AS address3_6,
  t0.zip_code AS zip_code_7,
  t0.city AS city_8,
  t0.email AS email_9,
  t0.phone_number AS phone_number_10,
  t0.fax AS fax_11,
  t0.id_deposit AS id_deposit_12,
  t0.gen_code AS gen_code_13,
  t0.newspaper AS newspaper_14,
  t0.siren AS siren_15,
  t0.ape AS ape_16,
  t0.trading_registry AS trading_registry_17,
  t0.internal_tva AS internal_tva_18,
  t0.rib AS rib_19,
  t0.general_account AS general_account_20,
  t0.capital AS capital_21
FROM
  society t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = 'MOZ' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.manufacturer AS manufacturer_2,
  p0_.short_label AS short_label_3,
  p0_.long_label AS long_label_4,
  p0_.weight AS weight_5,
  p0_.sold_by AS sold_by_6,
  p0_.ppht AS ppht_7,
  p0_.ppttc AS ppttc_8,
  p0_.paht AS paht_9,
  p0_.pattc AS pattc_10,
  p0_.legal_discount_library AS legal_discount_library_11,
  p0_.fidelity_bonus AS fidelity_bonus_12,
  p0_.brand AS brand_13,
  p0_.time_limit AS time_limit_14,
  p0_.coef AS coef_15,
  p0_.is_discountable AS is_discountable_16,
  p0_.is_btob AS is_btob_17,
  p0_.is_btoc AS is_btoc_18,
  p0_.is_customizable AS is_customizable_19,
  p0_.is_library AS is_library_20,
  p0_.is_nathan AS is_nathan_21,
  p0_.is_green AS is_green_22,
  p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23,
  p0_.is_active AS is_active_24,
  p0_.slug AS slug_25
FROM
  product p0_
  INNER JOIN operation_product o2_ ON p0_.id = o2_.product_id
  INNER JOIN operation o1_ ON o1_.id = o2_.operation_id
WHERE
  o1_.id = ?
  AND p0_.is_active = 1
  AND p0_.is_btoc = 1
  AND p0_.is_orapi_grand_frais <> 1
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN operation_product o2_ ON p0_.id = o2_.product_id INNER JOIN operation o1_ ON o1_.id = o2_.operation_id WHERE o1_.id = 91 AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND p0_.id IN (413392, 413396, 413397, 413407, 413408, 413409, 413410, 413411, 481814, 511187, 512644, 519629, 519630);

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,
  t27.id AS id_28,
  t27.min_qty AS min_qty_29,
  t27.max_qty AS max_qty_30,
  t27.step_qty AS step_qty_31,
  t27.product_id AS product_id_32
FROM
  product t0
  LEFT JOIN product_rule t27 ON t27.product_id = t0.id
  INNER JOIN operation_product ON t0.id = operation_product.product_id
WHERE
  operation_product.operation_id = ?

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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id INNER JOIN operation_product ON t0.id = operation_product.product_id WHERE operation_product.operation_id = 91;

SELECT
  t0.id AS id_1
FROM
  price t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = 'C' LIMIT 1;

SELECT
  d0_.quantity AS quantity_0,
  MIN(d0_.price_ht) AS sclr_1,
  MIN(d0_.price_ttc) AS sclr_2
FROM
  decreasing_price d0_
  LEFT JOIN product p1_ ON d0_.product_id = p1_.id
  LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id
WHERE
  p1_.id = ?
  AND p2_.id = ?
GROUP BY
  d0_.quantity
ORDER BY
  d0_.quantity ASC

SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = 413392 AND p2_.id = 9956229 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;

SELECT
  d0_.id AS id_0,
  d0_.quantity AS quantity_1,
  d0_.price_ht AS price_ht_2,
  d0_.price_ttc AS price_ttc_3,
  d0_.product_id AS product_id_4,
  d0_.product_price_id AS product_price_id_5,
  d0_.promotion_id AS promotion_id_6,
  d0_.market_id AS market_id_7
FROM
  decreasing_price d0_
WHERE
  d0_.product_id = ?
  AND d0_.quantity <= ?
  AND d0_.market_id IS NULL
  AND d0_.product_price_id IS NULL
  AND d0_.promotion_id IS NULL
ORDER BY
  d0_.quantity DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 413392 AND d0_.quantity <= 0 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.price_id AS price_id_4,
  t0.product_id AS product_id_5
FROM
  product_price t0
WHERE
  t0.product_id = ?
  AND t0.price_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = 413392 AND t0.price_id = 'C' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.promotion_id AS promotion_id_2,
  t0.society_id AS society_id_3
FROM
  society_promotion t0
WHERE
  t0.promotion_id = ?

SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = 196191;

SELECT
  p0_.id AS id_0,
  p0_.label_reduction AS label_reduction_1,
  p0_.description_reduction AS description_reduction_2,
  p0_.product_id AS product_id_3,
  p0_.operation_id AS operation_id_4
FROM
  product_reduction_label p0_
  INNER JOIN operation o1_ ON p0_.operation_id = o1_.id
WHERE
  o1_.is_active = 1
  AND o1_.end_date >= ?
  AND o1_.is_active = 1
  AND o1_.view_by LIKE ?
  AND p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= '2025-09-13 06:55:43' AND o1_.is_active = 1 AND o1_.view_by LIKE '%2%' AND p0_.product_id = 413392;

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 = ?

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 = 1;

SELECT
  d0_.quantity AS quantity_0,
  d0_.price_ht AS price_ht_1,
  d0_.price_ttc AS price_ttc_2
FROM
  decreasing_price d0_
WHERE
  d0_.product_id = ?
  AND d0_.market_id IS NULL
  AND d0_.product_price_id IS NULL
  AND d0_.promotion_id IS NULL
ORDER BY
  d0_.quantity DESC

SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = 413392 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC;

SELECT
  t0.id AS id_1,
  t0.price_ht AS price_ht_2,
  t0.price_ttc AS price_ttc_3,
  t0.discount AS discount_4,
  t0.product_id AS product_id_5
FROM
  promotion t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 413392;

SELECT
  c0_.id AS id_0,
  c0_.value AS value_1,
  c1_.id AS id_2,
  c1_.list_order AS list_order_3,
  c1_.is_display_site AS is_display_site_4,
  c1_.is_search_site AS is_search_site_5,
  c1_.label AS label_6,
  c0_.product_id AS product_id_7,
  c0_.characteristic_label_id AS characteristic_label_id_8
FROM
  characteristic c0_
  INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id
WHERE
  c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND c1_.is_display_site = ?

SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id IN (413392, 413396, 413397, 413407, 413408, 413409, 413410, 413411, 481814, 511187, 512644, 519629, 519630) AND c1_.is_display_site = 1;

SELECT
  d0_.quantity AS quantity_0,
  d0_.price_ht AS price_ht_1,
  d0_.price_ttc AS price_ttc_2
FROM
  decreasing_price d0_
WHERE
  d0_.promotion_id = ?
ORDER BY
  d0_.quantity DESC

SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.promotion_id = 196191 ORDER BY d0_.quantity DESC;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN operation_product o2_ ON p0_.id = o2_.product_id
  INNER JOIN operation o1_ ON o1_.id = o2_.operation_id
WHERE
  o1_.id = ?
  AND p0_.is_active = 1
  AND p0_.is_btoc = 1
  AND p0_.is_orapi_grand_frais <> 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN operation_product o2_ ON p0_.id = o2_.product_id INNER JOIN operation o1_ ON o1_.id = o2_.operation_id WHERE o1_.id = 91 AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 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

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 = 'bien-etre-visioconference' LIMIT 1;

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  INNER JOIN operation_product o2_ ON p0_.id = o2_.product_id
  INNER JOIN operation o1_ ON o1_.id = o2_.operation_id
WHERE
  o1_.id = ?
  AND p0_.is_active = 1
  AND p0_.is_btoc = 1
  AND p0_.is_orapi_grand_frais <> 1
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN operation_product o2_ ON p0_.id = o2_.product_id INNER JOIN operation o1_ ON o1_.id = o2_.operation_id WHERE o1_.id = 91 AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 30;

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

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 = 1 LIMIT 1;