GET https://staging.pgdis.com/produit/72199-cahiers-polypro-orange-n-c-72199-majucul

Query Metrics

122 Database Queries
23 Different statements
3792.54 ms Query time
0 Invalid entities
4828 Managed entities

Queries

Group similar statements

# Time Info
1 201.38 ms
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, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, c3_.id AS id_30, c3_.name AS name_31, c3_.displayed_order AS displayed_order_32, c3_.is_in_footer AS is_in_footer_33, c3_.slug AS slug_34, p4_.id AS id_35, p4_.price_ht AS price_ht_36, p4_.price_ttc AS price_ttc_37, p4_.discount AS discount_38, p5_.id AS id_39, p5_.min AS min_40, p5_.max AS max_41, p5_.codelot AS codelot_42, c6_.id AS id_43, c6_.name AS name_44, c6_.name_display AS name_display_45, c6_.is_visible_btob AS is_visible_btob_46, c6_.is_referencement AS is_referencement_47, p1_.price_id AS price_id_48, p1_.product_id AS product_id_49, c3_.category_parent_id AS category_parent_id_50, p4_.product_id AS product_id_51, p5_.customer_catalog_id AS customer_catalog_id_52, p5_.product_id AS product_id_53 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id LEFT JOIN category c3_ ON c3_.id = p7_.category_id LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id WHERE p0_.slug = ? AND p0_.is_active = 1
Parameters:
[
  "72199-cahiers-polypro-orange-n-c-72199-majucul"
]
2 0.43 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  87249
]
3 0.60 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, 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 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "72199-cahiers-polypro-orange-n-c-72199-majucul"
]
4 4.23 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = ?
Parameters:
[
  "72199-cahiers-polypro-orange-n-c-72199-majucul"
]
5 0.84 ms
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 = ? AND c1_.is_display_site = ?
Parameters:
[
  87249
  1
]
6 0.69 ms
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_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[
  41
  189
  190
  191
  192
  193
  194
  195
  191
  87249
]
7 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  581
]
8 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  582
]
9 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  583
]
10 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  594
]
11 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  597
]
12 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  607
]
13 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  692
]
14 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  693
]
15 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  694
]
16 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  695
]
17 0.20 ms
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
Parameters:
[
  "ourClientsAlsoBoughtMonths"
]
18 1627.74 ms
SELECT c0_.id AS id_0, c0_.temporary_cart_number AS temporary_cart_number_1, c0_.type AS type_2, c0_.number AS number_3, c0_.slip AS slip_4, c0_.status AS status_5, c0_.order_picker AS order_picker_6, c0_.created_at AS created_at_7, c0_.delivery_date AS delivery_date_8, c0_.login AS login_9, c0_.user_reference AS user_reference_10, c0_.tracking_number AS tracking_number_11, c0_.deposit AS deposit_12, c0_.sector AS sector_13, c0_.sub_sector AS sub_sector_14, c0_.customer_name AS customer_name_15, c0_.address1 AS address1_16, c0_.address2 AS address2_17, c0_.address3 AS address3_18, c0_.zip_code AS zip_code_19, c0_.city AS city_20, c0_.country AS country_21, c0_.phone AS phone_22, c0_.fax AS fax_23, c0_.email AS email_24, c0_.customer_name_delivery AS customer_name_delivery_25, c0_.address1_delivery AS address1_delivery_26, c0_.address2_delivery AS address2_delivery_27, c0_.address3_delivery AS address3_delivery_28, c0_.zip_code_delivery AS zip_code_delivery_29, c0_.delivery_city AS delivery_city_30, c0_.country_delivery AS country_delivery_31, c0_.delivery_phone AS delivery_phone_32, c0_.fax_delivery AS fax_delivery_33, c0_.email_delivery AS email_delivery_34, c0_.reglement AS reglement_35, c0_.updated_at AS updated_at_36, c0_.price_ht AS price_ht_37, c0_.price_tva AS price_tva_38, c0_.price_ttc AS price_ttc_39, c0_.price_cost_ht AS price_cost_ht_40, c0_.display_ttc AS display_ttc_41, c0_.package_number AS package_number_42, c0_.weight AS weight_43, c0_.volume AS volume_44, c0_.discount AS discount_45, c0_.feedback AS feedback_46, c0_.global_discount AS global_discount_47, c0_.commitment_number AS commitment_number_48, c0_.promotional_code AS promotional_code_49, c0_.multiplier_coefficient AS multiplier_coefficient_50, c0_.is_out_of_budget AS is_out_of_budget_51, c0_.lead_word AS lead_word_52, c0_.facturation AS facturation_53, c0_.complete_delivery AS complete_delivery_54, c0_.urgent_delivery AS urgent_delivery_55, c0_.complete_facturation AS complete_facturation_56, c0_.paypal AS paypal_57, c0_.regroupement AS regroupement_58, c0_.transaction AS transaction_59, c0_.plate_number AS plate_number_60, c0_.is_hidden AS is_hidden_61, c0_.budget_id AS budget_id_62, c0_.customer_id AS customer_id_63, c0_.billing_customer_id AS billing_customer_id_64, c0_.user_id AS user_id_65, c0_.delivery_id AS delivery_id_66, c0_.market_id AS market_id_67, c0_.price_id AS price_id_68, c0_.society_id AS society_id_69, c0_.commercial_id AS commercial_id_70, c0_.delivery_cost_id AS delivery_cost_id_71 FROM customer_order c0_ INNER JOIN customer_order_lines c1_ ON c0_.id = c1_.customer_order_id INNER JOIN product p2_ ON c1_.product_id = p2_.id WHERE p2_.id = ? AND c0_.created_at >= ?
Parameters:
[
  87249
  "2025-04-12 17:21:05"
]
19 1923.89 ms
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 customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[
  6383988
  6384264
  6384352
  6384660
  6384936
  6385402
  6383776
  6386385
  6386693
  6386726
  6387261
  6386706
  6388017
  6388454
  6388480
  6388916
  6388913
  6388962
  6389025
  6389049
  6389073
  6388023
  6389461
  6390107
  6389070
  6390562
  6374331
  6387472
  6385519
  6389056
  6387788
  6387987
  6391292
  6391293
  6391474
  6387962
  6391879
  6391885
  6391353
  6392012
  6392099
  6392116
  6392227
  6392248
  6392310
  6389404
  6392416
  6392443
  6390656
  6392534
  6392314
  6384846
  6392929
  6393490
  6393655
  6393657
  6393695
  6393741
  6393773
  6393348
  6393804
  6378047
  6394106
  6394109
  6394184
  6394258
  6394311
  6394317
  6394532
  6394554
  6395236
  6395730
  6396226
  6396325
  6396362
  6396413
  6397417
  6397439
  6398143
  6398177
  6398332
  6398434
  6398621
  6398761
  6398847
  6400117
  6400145
  6400472
  6400791
  6401650
  6402498
  6402954
  6403402
  6404008
  6404305
  6404344
  6404348
  6404586
  6405400
  6405674
  6405700
  6407146
  6407421
  6408247
  6408448
  6408623
  6408692
  6408769
  6408801
  6408827
  6408830
  6408841
  6408915
  6409003
  6409304
  6409608
  6410711
  6410866
  6410914
  6411672
  6411702
  6411745
  6411868
  6412163
  6412214
  6412328
  6412665
  6412710
  6412724
  6413273
  6413281
  6413300
  6413505
  6413562
  6413656
  6413661
  6413697
  6413796
  6413801
  6413816
  6413851
  6414240
  6414269
  6414280
  6414293
  6414295
  6414544
  6414685
  6414761
  6414780
  6414934
  6415009
  6415037
  6415061
  6415087
  6415202
  6415338
  6415389
  6415460
  6416027
  6416040
  6416071
  6416072
  6416120
  6416123
  6416134
  6416146
  6416185
  6416270
  6416312
  6416776
  6416836
  6416979
  6417021
  6417024
  6417045
  6417061
  6417286
  6417442
  6417576
  6417655
  6418007
  6418171
  6418268
  6418390
  6418843
  6418935
  6419144
  6419150
  6419184
  6419188
  6419203
  6419273
  6419319
  6419344
  6419353
  6419393
  6419403
  6419414
  6419474
  6419505
  6419522
  6419549
  6419570
  6419571
  6419583
  6419880
  6419882
  6419883
  6419885
  6419886
  6420603
  6420606
  6420608
  6420637
  6420657
  6420658
  6420666
  6420668
  6420675
  6420714
  6420749
  6420856
  6420857
  6420934
  6420936
  6421292
  6421660
  6421691
  6421741
  6421746
  6421760
  6421824
  6421938
  6421974
  6422027
  6422161
  6422711
  6422878
  6423154
  6423164
  6423648
  6423712
  6423717
  6423770
  6424146
  6424362
  6424790
  6425083
  6425256
  6425291
  6425353
  6425393
  6425565
  6425598
  6425605
  6425702
  6425756
  6426279
  6426324
  6426373
  6426425
  6426452
  6426502
  6426611
  6426685
  6426704
  6426947
  6427269
  6427291
  6427295
  6427385
  6428024
  6428258
  6428382
  6428430
  6428494
  6428581
  6428745
  6428875
  6428914
  6429041
  6429171
  6429577
  6429687
  6429789
  6429866
  6429946
  6430050
  6430128
  6430290
  6430363
  6430538
  6430573
  6430798
  6430873
  6430882
  6430904
  6430965
  6430976
  6431281
  6431444
  6431494
  6431529
  6431536
  6431537
  6431714
  6431802
  6431890
  6431895
  6431926
  6431959
  6431973
  6432007
  6432048
  6432089
  6432125
  6432136
  6432177
  6432263
  6432280
  6432304
  6433544
  6433597
  6433720
  6433735
  6434000
  6434039
  6434204
  6434215
  6434288
  6434299
  6434384
  6434406
  6434484
  6434497
  6434757
  6434765
  6434789
  6434891
  6434932
  6435101
  6435179
  6435287
  6435298
  6435401
  6435496
  6435626
  6435696
  6435709
  6435897
  6435917
  6435955
  6435986
  6436074
  6436078
  6436243
  6436344
  6436356
  6437041
  6437218
  6437884
  6437991
  6438044
  6438087
  6438152
  6438517
  6438767
  6438854
  6438870
  6438899
  6438939
  6439012
  6439108
  6439218
  6439222
  6439263
  6439269
  6439471
  6439503
  6439593
  6439613
  6439623
  6439676
  6439940
  6439939
  6439937
  6440121
  6440134
  6440278
  6440367
  6440538
  6440831
  6440835
  6441052
  6441111
  6441605
  6441949
  6434772
  6442769
  6442800
  6442799
  6442892
  6443132
  6443569
  6443572
  6443920
  6444031
  6444036
  6444079
  6444092
  6444231
  6444276
  6444304
  6444427
  6444641
  6444872
  6444899
  6445449
  6445513
  6445639
  6445649
  6445652
  6445771
  6445781
  6445790
  6445793
  6446031
  6446038
  6446060
  6446061
  6446091
  6446095
  6446107
  6446109
  6446112
  6446137
  6446156
  6446167
  6446175
  6446228
  6446240
  6446248
  6446255
  6446260
  6446348
  6446368
  6446397
  6446413
  6446431
  6446443
  6446548
  6446739
  6446805
  6446861
  6446896
  6446908
  6446910
  6446939
  6447017
  6447056
  6447057
  6447123
  6447568
  6447577
  6447642
  6447645
  6447659
  6447697
  6448617
  6448697
  6448735
  6448801
  6448918
  6449013
  6449321
  6449361
  6449380
  6449811
  6449882
  6449883
  6449897
  6450040
  6450099
  6450154
  6450168
  6450172
  6450173
  6450174
  6450186
  6450195
  6450199
  6450253
  6450270
  6450409
  6450447
  6450611
  6450613
  6450644
  6450669
  6450750
  6450758
  6450766
  6450772
  6450814
  6450889
  6450931
  6450932
  6450973
  6451002
  6451025
  6451059
  6451113
  6451129
  6451213
  6451247
  6451251
  6451294
  6451318
  6451338
  6451345
  6451346
  6451355
  6451415
  6451420
  6451431
  6451436
  6451439
  6451572
  6451581
  6451594
  6451665
  6451667
  6451707
  6451793
  6451794
  6451912
  6451930
  6452000
  6452019
  6452020
  6452023
  6452040
  6452042
  6452053
  6452099
  6452101
  6452214
  6452218
  6452222
  6452245
  6452246
  6452256
  6452319
  6452320
  6452322
  6452367
  6452404
  6452486
  6452503
  6452610
  6452614
  6453263
  6453281
  6453309
  6453405
  6453476
  6453551
  6453732
  6453746
  6453874
  6453932
  6454022
  6454126
  6454181
  6454188
  6454190
  6454203
  6454535
  6454536
  6454543
  6454563
  6454582
  6454608
  6454622
  6454626
  6454667
  6454687
  6454690
  6454758
  6454761
  6454777
  6454855
  6454897
  6454926
  6454930
  6454976
  6454984
  6455034
  6455038
  6455061
  6455066
  6455146
  6455149
  6455154
  6455171
  6455198
  6455236
  6455237
  6455241
  6455340
  6455345
  6455347
  6455354
  6455416
  6455447
  6455451
  6455465
  6455469
  6455487
  6455490
  6455598
  6455613
  6455620
  6455638
  6455676
  6455687
  6455690
  6455695
  6455700
  6455707
  6455708
  6455747
  6455748
  6455764
  6455837
  6455885
  6456091
  6456103
  6456278
  6456536
  6456750
  6456976
  6456979
  6456995
  6457209
  6457421
  6457426
  6457427
  6457440
  6457443
  6457526
  6457645
  6457710
  6457735
  6457825
  6458511
  6458518
  6458559
  6459162
  6459522
  6459574
  6460171
  6460188
  6460191
  6460315
  6460429
  6460542
  6460610
  6460915
  6460922
  6461019
  6461154
  6461249
  6461336
  6461450
  6461613
  6461621
  6461829
  6461846
  6461914
  6462273
  6462770
  6462968
  6464484
  6465138
  6465243
  6465448
  6465665
  6466672
  6466852
  6467234
  6467462
  6468593
  6468772
  6468871
  6468895
  6469146
  6469187
  6469206
  6469598
  6469876
  6469958
  6470074
  6470167
  6470293
  6470307
  6470554
  6471002
  6471362
  6471623
  6471932
  6472230
  6472235
  6472281
  6472575
  6472615
  6472760
  6472775
  6472778
  6472924
  6473092
  6473250
  6474508
  6474636
  6474855
  6475335
  6475832
  6476138
  6476165
  6476242
  6476533
  6476591
  6476872
  6476876
  6476979
  6477006
  6477103
  6477162
  6477639
  6477649
  6477830
  6477863
  6477881
  6477893
  6478050
  6478051
  6480073
  6480466
  6480481
  6480521
  6480522
  6480540
  6480791
  6480863
  6481039
  6481445
  6481849
  6482029
  6482405
  6482443
  6482889
  6482941
  6482984
  6483034
  6483436
  6483478
  6483605
  6483622
  6483630
  6483696
  6483732
  6483773
  6483993
  6484035
  6484126
  6484365
  6484367
  6484368
  6484369
  6484370
  6484372
  6484373
  6484374
  6484375
  6484388
  6484389
  6484390
  6484391
  6484392
  6484393
  6484394
  6484395
  6484396
  6484397
  6484398
  6484399
  6484400
  6484405
  6484406
  6484407
  6484408
  6484409
  6484410
  6484411
  6484412
  6484413
  6484414
  6484494
  6484545
  6484557
  6484571
  6484594
  6484779
  6485010
  6485127
  6485192
  6485306
  6485435
  6485503
  6485504
  6485525
  6485527
  6485610
  6485650
  6485751
  6485833
  6485899
  6485937
  6486118
  6486140
  6486185
  6486632
  6486753
  6486755
  6486782
  6486783
  6486789
  6487275
  6488370
  6488451
  6488509
  6488658
  6488680
  6488867
  6489119
  6489998
  6490015
  6490020
  6490073
  6490093
  6490117
  6490226
  6490729
  6490781
  6490879
  6490972
  6491111
  6491488
  6491496
  6491559
  6491575
  6491837
  6491899
  6491973
  6491988
  6492024
  6492043
  6492104
  6492253
  6492346
  6492306
  6492410
  6493186
  6494298
  6494761
  6494898
  6495440
  6495959
  6496740
  6496755
  6496906
  6496921
  6497016
  6497134
  6497141
  6497193
  6497295
  6497326
  6497350
  6497433
  6497518
  6497545
  6497614
  6498018
  6498125
  6498128
  6498130
  6498162
  6498253
  6498261
  6498324
  6498327
  6498480
  6498485
  6498523
  6498611
  6498641
  6498764
  6498835
  6498838
  6498915
  6498916
  6498919
  6498923
  6498951
  6498957
  6498977
  6499143
  6499145
  6499233
  6499299
  6499317
  6499319
  6499323
  6499535
  6500285
  6500312
  6500370
  6500581
  6500897
  6500899
  6500903
  6500917
  6500929
  6501443
  6501639
  6501694
  6501707
  6501717
  6501731
  6501813
  6501861
  6501876
  6501883
  6501891
  6501941
  6501948
  6501949
  6501972
  6501975
  6501978
  6501982
  6501985
  6501990
  6502006
  6502037
  6502113
  6502184
  6502193
  6502201
  6502233
  6502235
  6502236
  6502340
  6502389
  6502490
  6502522
  6502526
  6502539
  6502592
  6502619
  6502675
  6502687
  6502690
  6502722
  6502748
  6502809
  6503096
  6503223
  6503327
  6503372
  6503526
  6503558
  6503568
  6503572
  6503823
  6504006
  6504059
  6504209
  6504248
  6504249
  6504251
  6504252
  6504386
  6504388
  6505421
  6506004
  6506019
  6506437
  6506453
  6507186
  6507898
  6507945
  6507949
  6507978
  6508390
  6508423
  6508587
  6508593
  6508998
  6509010
  6509035
  6509310
  6509311
  6509324
  6509667
  1000057212
  6510479
  6510523
  6510526
  6462181
  6510647
  6510903
  6510991
  6510992
  6510997
  6510999
  6511020
  6511120
  6511171
  6511172
  6511210
  6511212
  6511222
  6511238
  6511239
  6512339
  6512340
  6512820
  6512975
  6513087
  6513435
  6515189
  6515190
  6515194
  6515195
  6515208
  6515207
  6515210
  6515214
  6515215
  6515220
  6515221
  6515240
  6515242
  6515252
  6515256
  6515264
  6515265
  6515270
  6515273
  6515276
  6515757
  6516055
  6516074
  6516280
  6516295
  6516559
  6517661
  6517662
  6517663
  6517664
  6517665
  6517666
  6517667
  6517668
  6517669
  6517670
  6517671
  6517672
  6517673
  6517674
  6517675
  6517676
  6517677
  6517678
  6517679
  6517680
  6517681
  6517682
  6517683
  6517684
  6517687
  6517688
  6517689
  6517690
  6517691
  6517692
  6517693
  6517694
  6517695
  6517696
  6517697
  6517900
  6518821
  6518823
  6519103
  6519104
  6520231
  6520284
  6521302
  6521303
  6521339
  6522202
  6522863
  6522988
  6523897
  6524006
  6524031
  6524088
  6524089
  6524226
  6524231
  6524235
  6524256
  6524266
  6524268
  6524275
  6524282
  6524286
  6524298
  6524301
  6524312
  6524319
  6524367
  6524386
  6524404
  6524405
  6524406
  6524410
  6524449
  6524594
  6524775
  6524858
  6524862
  6524956
  6525153
  6525187
  6525191
  6525225
  6525228
  6525231
  6525262
  6525354
  6525380
  6525396
  6525514
  6525529
  6525537
  6525728
  6525777
  6526016
  6526066
  6526182
  6526223
  6526234
  6526287
  6526488
  6526900
  6526905
  6526906
  6526907
  6526912
  6527006
  6527077
  6527198
  6527199
  6527315
  6527369
  6527370
  6527416
  6528044
  6528048
  6528132
  6528143
  6528147
  6528276
  6528682
  6528683
  6528741
  6528778
  6528782
  6528859
  6528928
  6528940
  6528945
  6528952
  6529063
  6529119
  6529178
  6529223
  6529306
  6529311
  6529319
  6529326
  6529407
  6529753
  6529882
  6529894
  6529897
  6529908
  6530051
  6530056
  6530102
  6530143
  6530169
  6530226
  6530294
  6530305
  6530312
  6530313
  6530337
  6530340
  6530352
  6530369
  6530379
  6530466
  6530491
  6530525
  6530858
  6530998
  6531075
  6531128
  6531190
  6531212
  6531245
  6531247
  6531346
  6531350
  6531356
  6532732
  6532785
  6532793
  6532797
  6532805
  6533129
  6533195
  6533271
  6533399
  6533467
  6533676
  6533702
  6533826
  6534036
  6534037
  6534225
  6534562
  6534867
  6534877
  6535610
  6535637
  6535840
  6535844
  6535880
  6535894
  6535900
  6535909
  6535953
  6535962
  6536216
  6536698
  6537048
  6537049
  6537771
  6538494
  6538778
  6538779
  6538787
  6539676
  6539774
  6539947
  6539972
  6540152
  6540156
  6540232
  6540305
  6540390
  6540443
  6541213
  6542024
  6542429
  6542669
  6394088
  1000001124
  6358752
  6385464
  1000002126
  1000002184
  1000002718
  1000002744
  1000002740
  1000001987
  1000001869
  1000001347
  6390301
  1000004708
  6389085
  6390715
  6390633
  1000004874
  1000002186
  1000005183
  1000005295
  1000005326
  1000002756
  1000004999
  1000005601
  1000005770
  1000005848
  1000005985
  1000006054
  1000006095
  1000006175
  1000006176
  6392776
  6382649
  6378512
  6385755
  1000002610
  1000006355
  1000006499
  1000006995
  1000007031
  1000007260
  6389526
  1000007606
  1000007755
  6394186
  1000008074
  1000003838
  1000008211
  1000008264
  1000008316
  1000008317
  1000008318
  1000008332
  1000008513
  1000008704
  1000008827
  1000001350
  1000001354
  1000005584
  1000002647
  1000009009
  1000001743
  1000009237
  1000004337
  6356299
  1000009304
  1000007852
  1000002230
  1000009243
  1000009663
  1000009621
  1000009165
  1000006630
  1000010045
  1000009436
  1000002735
  1000009826
  1000008107
  1000008985
  1000007460
  1000002032
  1000009972
  1000010591
  1000010764
  1000010798
  1000010551
  1000010761
  1000010932
  1000010607
  1000009943
  1000007860
  1000009799
  1000008252
  1000010148
  1000010733
  1000010996
  1000012004
  1000007988
  1000012100
  1000012154
  1000004803
  1000012180
  1000012219
  1000005986
  1000012321
  1000012409
  1000012410
  1000012401
  1000012455
  1000012262
  1000012701
  1000012708
  1000012709
  1000012779
  1000012782
  1000012861
  1000012781
  1000012991
  1000013131
  1000009970
  1000005931
  1000010147
  1000013416
  1000013558
  1000013521
  1000012800
  1000006085
  1000013714
  1000013788
  1000005460
  1000013980
  1000014026
  1000014051
  1000014153
  1000012721
  1000014534
  1000014700
  1000014702
  1000014802
  1000014828
  1000013459
  1000015028
  1000012222
  1000015092
  1000005279
  1000014283
  1000009611
  1000010474
  1000015412
  1000015424
  1000015480
  1000015511
  1000015619
  1000015628
  1000015775
  1000015776
  1000015745
  1000015791
  1000015382
  1000015575
  1000015877
  1000015921
  1000014003
  1000015797
  1000016082
  1000016158
  1000016178
  1000016180
  1000016193
  1000014058
  1000016374
  1000016375
  1000014387
  1000012482
  1000016562
  1000016973
  1000016995
  1000016265
  1000017145
  1000006277
  1000013221
  1000017444
  1000016175
  1000007402
  1000012942
  1000011837
  1000017612
  1000017901
  1000017902
  1000017903
  1000017934
  1000017935
  1000017938
  1000017948
  1000017950
  1000017953
  1000017954
  1000017955
  1000017956
  1000018514
  1000018515
  1000018518
  1000018521
  1000018522
  1000018523
  1000018524
  1000018525
  1000018600
  1000018621
  1000018631
  1000017002
  1000018627
  1000018798
  1000018833
  1000018836
  1000018838
  1000011989
  1000018804
  1000018965
  1000018976
  1000019019
  1000019020
  1000019021
  1000019023
  1000019024
  1000019025
  1000019066
  1000019127
  1000019131
  1000019135
  1000019137
  1000019139
  1000019171
  1000019174
  1000019178
  1000019208
  1000019226
  1000019289
  1000019290
  1000019291
  1000019292
  1000019293
  1000019294
  1000019301
  1000019392
  1000019405
  1000019406
  1000019408
  1000019484
  1000019490
  1000019491
  1000019540
  1000019547
  1000019625
  1000019665
  1000019680
  1000019725
  1000019758
  1000019759
  1000019822
  1000019823
  1000019826
  1000019829
  1000019840
  1000019841
  1000019843
  1000019845
  1000019850
  1000019865
  1000019866
  1000019883
  1000019889
  1000019890
  1000012635
  1000019983
  1000019993
  1000020121
  1000020127
  1000012837
  1000010548
  1000009207
  1000016134
  1000020244
  1000017170
  1000017167
  1000017115
  1000013163
  1000020416
  1000020417
  1000020418
  1000012373
  1000020454
  1000016574
  1000014829
  1000020592
  1000020596
  1000020595
  1000019228
  1000013768
  1000018731
  1000020872
  1000021010
  1000021016
  1000021018
  1000021033
  1000021039
  1000021040
  1000021043
  1000004535
  1000021134
  1000020188
  1000010671
  1000020084
  1000016407
  1000012314
  1000021290
  1000019574
  1000017494
  1000021329
  1000021407
  1000021522
  1000013129
  1000021531
  1000021653
  1000021658
  1000021659
  1000021660
  1000021686
  1000021818
  1000021825
  1000021828
  1000021838
  1000021839
  1000021847
  1000021864
  1000021886
  1000021891
  1000021904
  1000002102
  1000001487
  1000003873
  1000001497
  1000019454
  1000012427
  1000014715
  1000022193
  1000022205
  1000017952
  1000006074
  1000013342
  1000022440
  1000022446
  1000022453
  1000022454
  1000022455
  1000022483
  1000022484
  1000022513
  1000022279
  1000014686
  1000012612
  1000021928
  1000022732
  1000022747
  1000022750
  1000022753
  1000022755
  1000022757
  1000022761
  1000022763
  1000022789
  1000014961
  1000016453
  1000009774
  1000015127
  1000012932
  1000022997
  1000023008
  1000015535
  1000023219
  1000023453
  1000023460
  1000023508
  1000023512
  1000023520
  1000018111
  1000024515
  1000024516
  1000018645
  1000024658
  1000024659
  1000024660
  1000024720
  1000024721
  1000024722
  1000024723
  1000024745
  1000024752
  1000024755
  1000024756
  1000024762
  1000024791
  1000017073
  1000024812
  1000024992
  1000025027
  1000025050
  1000025053
  1000025057
  1000025061
  1000025079
  1000025082
  1000025089
  1000025098
  1000025100
  1000025109
  1000025115
  1000025116
  1000025119
  1000025125
  1000025132
  1000025497
  1000025500
  1000025507
  1000025508
  1000016387
  1000025559
  1000025647
  1000025649
  1000019629
  1000017957
  1000017951
  1000017645
  1000025836
  1000025841
  1000025843
  1000025846
  1000025856
  1000022794
  1000025947
  1000025971
  1000025985
  1000017199
  1000026178
  1000026323
  1000026326
  1000026327
  1000026325
  1000026432
  1000016755
  1000026504
  1000022522
  1000023752
  1000014705
  1000026146
  1000026798
  1000026974
  1000026975
  1000026976
  1000026978
  1000026998
  1000027000
  1000027001
  1000014386
  1000027002
  1000018916
  1000027536
  1000027591
  1000021663
  1000013771
  1000027142
  1000027995
  1000028060
  1000012560
  1000028613
  1000028614
  1000028626
  1000028704
  1000028705
  1000028621
  1000014297
  1000014104
  1000016744
  1000028982
  1000028984
  1000015969
  1000029210
  1000029303
  1000029304
  1000029098
  1000029350
  1000029430
  1000029443
  1000029444
  1000029532
  1000029536
  1000029558
  1000029559
  1000029566
  1000029567
  1000029589
  1000029771
  1000029871
  1000029881
  1000013721
  1000015067
  1000015982
  1000030149
  1000030150
  1000030151
  1000030152
  1000030191
  1000030279
  1000030765
  1000030786
  1000030794
  1000030808
  1000030821
  1000030926
  1000031239
  1000031265
  1000031266
  1000031277
  1000031282
  1000012010
  1000015990
  1000031647
  1000028298
  1000021135
  1000011940
  1000013699
  1000021691
  1000010615
  1000032244
  1000032251
  1000032254
  1000032260
  1000032264
  1000032296
  1000032298
  1000032343
  1000019541
  1000029896
  1000024757
  1000029638
  1000032633
  1000032801
  1000033092
  1000033093
  1000033099
  1000033106
  1000033163
  1000033164
  1000033165
  1000033167
  1000033168
  1000033169
  1000033170
  1000033171
  1000033172
  1000033191
  1000033193
  1000033198
  1000033308
  1000021689
  1000031963
  1000033174
  1000033998
  1000033999
  1000034067
  1000034070
  1000034072
  1000034074
  1000027541
  1000034156
  1000034157
  1000034166
  1000034167
  1000034207
  1000034168
  1000028629
  1000025885
  1000034309
  1000023551
  1000034396
  1000034399
  1000034404
  1000034406
  1000034408
  1000034419
  1000034424
  1000034425
  1000034426
  1000034428
  1000034429
  1000034431
  1000034432
  1000034433
  1000034464
  1000034466
  1000034472
  1000014806
  1000034478
  1000034480
  1000034496
  1000034497
  1000034498
  1000017056
  1000034583
  1000019901
  1000034592
  1000032242
  1000030280
  1000016464
  1000026433
  1000034636
  1000026949
  1000034696
  1000034901
  1000032483
  1000035014
  1000035272
  1000035356
  1000035374
  1000035375
  1000035379
  1000035512
  1000035529
  1000035535
  1000035538
  1000035539
  1000035545
  1000035547
  1000035582
  1000035585
  1000035590
  1000035591
  1000035592
  1000035626
  1000035627
  1000035629
  1000035762
  1000035763
  1000035764
  1000035765
  1000035770
  1000035775
  1000035777
  1000035779
  1000035784
  1000035788
  1000035789
  1000035790
  1000035793
  1000035828
  1000035830
  1000035835
  1000035836
  1000035837
  1000035839
  1000035873
  1000035875
  1000035880
  1000035905
  1000035917
  1000035922
  1000035934
  1000035963
  1000036034
  1000036141
  1000036142
  1000036143
  1000036144
  1000036145
  1000025365
  1000036187
  1000036202
  1000036207
  1000025990
  1000036292
  1000036309
  1000036310
  1000036317
  1000034088
  1000036342
  1000019046
  1000036476
  1000036622
  1000036700
  1000036735
  1000036434
  1000037655
  1000037677
  1000037678
  1000037679
  1000037680
  1000037681
  1000037682
  1000037683
  1000037684
  1000037685
  1000037686
  1000037687
  1000037688
  1000037689
  1000037714
  1000037722
  1000037772
  1000037893
  1000037894
  1000037895
  1000037915
  1000038191
  1000038317
  1000038318
  1000038319
  1000038320
  1000038321
  1000038972
  1000038973
  1000038999
  1000039014
  1000039015
  1000039016
  1000039017
  1000039019
  1000039020
  1000039042
  1000039150
  1000039212
  1000039367
  1000039368
  1000039389
  1000039437
  1000039666
  1000039717
  1000040130
  1000039991
  1000038324
  1000040428
  1000040829
  1000040830
  1000040832
  6317567
  1000039474
  1000041119
  1000041246
  1000015789
  1000041564
  1000041565
  1000041613
  1000041614
  1000041615
  1000041773
  1000041841
  1000041842
  1000041864
  1000042079
  1000042081
  1000042082
  1000042083
  1000042085
  1000042092
  1000042093
  1000042094
  1000042095
  1000042096
  1000042097
  1000042098
  1000042099
  1000042100
  1000042101
  1000042102
  1000042103
  1000042104
  1000042105
  1000042106
  1000042109
  1000042110
  1000042111
  1000042112
  1000042113
  1000042114
  1000042115
  1000042116
  1000042117
  1000042118
  1000042119
  1000042121
  1000042122
  1000042123
  1000042124
  1000042125
  1000042126
  1000042127
  1000042128
  1000042174
  1000042176
  1000041341
  1000042398
  1000037837
  1000042408
  1000042865
  1000036737
  1000043229
  1000043231
  1000043233
  1000043234
  1000043235
  1000043236
  1000022679
  1000043399
  1000043405
  6384066
  1000037777
  1000043823
  1000043864
  1000022214
  1000044037
  1000044057
  1000044070
  1000044075
  1000044082
  1000044292
  1000044318
  1000044344
  1000044361
  1000041637
  1000044517
  1000044541
  1000044561
  1000044562
  1000044668
  1000044677
  1000044683
  1000044703
  1000044809
  1000044817
  1000044914
  1000039476
  1000025416
  1000046053
  1000029306
  1000046129
  1000046148
  1000046194
  1000046197
  1000046201
  1000046208
  1000046210
  1000046216
  1000046219
  1000046352
  1000046354
  1000046387
  1000046575
  1000046577
  1000046578
  1000046579
  1000046580
  1000046581
  1000046583
  1000046584
  1000046586
  1000046587
  1000046588
  1000046589
  1000046590
  1000046591
  1000046592
  1000046593
  1000046594
  1000046595
  1000046596
  1000046597
  1000046598
  1000046599
  1000046600
  1000046664
  1000046665
  1000046666
  1000046667
  1000046668
  1000046669
  1000046671
  1000046672
  1000046673
  1000046675
  1000046677
  1000046678
  1000046679
  1000046680
  1000046681
  1000046682
  1000046683
  1000046684
  1000046685
  1000046686
  1000046687
  1000046688
  1000046689
  1000046691
  1000046692
  1000046693
  1000046694
  1000046695
  1000046696
  1000046697
  1000046699
  1000046700
  1000046702
  1000046703
  1000046704
  1000046705
  1000046706
  1000046708
  1000046709
  1000046710
  1000046711
  1000046712
  1000046713
  1000046715
  1000046716
  1000046717
  1000032059
  1000046880
  1000046900
  1000047160
  1000047168
  1000047171
  1000047172
  1000047174
  1000047175
  1000047176
  1000047191
  1000047194
  1000047550
  1000047551
  1000047609
  1000047610
  1000016703
  1000047760
  1000047771
  1000046911
  1000047840
  1000047872
  1000047914
  1000047994
  1000030568
  1000019240
  1000045054
  1000048078
  1000048155
  1000048159
  1000046091
  1000048242
  1000047211
  1000047196
  1000022457
  1000048071
  1000048401
  1000028254
  1000048553
  1000048565
  1000048581
  1000048614
  1000048625
  1000048123
  1000048652
  1000048507
  1000048699
  1000048629
  1000042965
  1000048787
  1000048788
  1000048829
  1000048919
  1000048947
  1000048965
  1000047821
  1000017981
  1000040215
  1000049263
  1000049270
  1000049485
  1000049488
  1000026983
  1000049540
  1000049542
  1000049187
  1000020246
  1000049071
  1000049602
  1000049603
  1000049703
  1000048966
  1000049830
  1000048487
  1000049910
  1000023855
  1000048554
  1000049979
  1000050024
  1000050028
  1000049902
  1000050151
  1000025298
  1000047848
  1000050349
  1000043301
  1000050596
  1000048340
  1000050683
  1000050660
  1000051118
  1000048477
  1000050835
  1000051320
  1000044085
  1000050685
  1000051402
  1000048694
  1000051491
  1000051494
  1000051041
  1000051588
  1000051463
  1000051739
  1000051741
  1000021544
  1000051824
  1000051918
  1000051928
  1000051841
  1000052050
  1000014080
  1000048804
  1000024035
  1000052102
  1000052120
  1000021164
  1000051845
  1000050350
  1000052355
  1000052447
  1000052475
  1000052554
  1000052556
  1000052611
  1000052766
  1000052833
  1000052030
  1000052900
  1000043594
  1000052959
  1000053037
  1000053038
  1000053117
  1000048351
  1000048244
  1000051850
  1000045623
  1000048075
  1000053297
  1000053380
  1000053384
  1000053454
  1000051725
  1000053506
  1000053507
  1000053516
  1000053539
  1000053106
  1000050997
  1000051752
  1000051749
  1000053764
  1000053765
  1000053818
  1000053885
  1000053819
  1000053607
  1000053771
  1000054030
  1000054074
  1000054144
  1000053775
  1000054306
  1000054317
  1000039234
  1000054343
  1000052759
  1000054368
  1000052003
  1000054319
  1000054435
  1000042214
  1000050208
  1000053488
  1000054634
  1000053357
  1000054881
  1000054912
  1000054918
  1000053455
  1000048597
  1000055134
  1000055205
  1000055212
  1000055216
  1000055227
  1000054596
  1000055335
  1000055357
  1000035218
  1000053874
  1000052838
  1000055575
  1000055581
  1000054774
  1000049486
  1000049984
  1000055041
  1000055782
  1000055419
  1000055957
  1000050688
  1000056020
  1000056111
  1000055804
  1000043919
  1000051939
  1000055425
  1000056278
  1000056338
  1000056477
  1000056476
  1000056528
  1000056610
  1000056611
  1000053211
  1000056648
  1000056703
  1000056709
  1000056723
  1000056733
  1000056851
  1000056429
  1000055863
  1000054560
  1000056793
  1000056794
  1000049647
  1000049047
  1000057140
  1000055991
  1000054095
  1000053346
  1000057182
  1000057384
  1000056790
  1000057469
  1000057576
  1000025159
  1000057976
  1000058459
  1000058748
  1000056712
  1000058871
  1000058872
  1000058873
  1000058959
  1000058960
  1000058961
  1000059203
  1000059361
  1000059473
  1000059582
  1000059685
  1000059705
  1000059730
  1000059851
  1000059854
  1000059979
  1000059981
  1000051504
  1000059804
  1000060889
  1000054071
  1000061055
  1000061230
  1000061430
  1000061468
  1000061442
  1000061787
  1000062024
  1000062139
  1000062225
  1000060960
  1000062572
  1000062753
  1000062818
  1000062872
  1000062491
  1000063007
  1000060312
  1000063062
  1000015844
  1000061786
  1000063291
  1000063052
  1000063168
  1000057868
  1000064385
  1000064541
  1000063249
  1000065344
  1000065302
  1000065628
  1000065839
  1000042075
  1000066454
  87249
]
20 0.39 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  96803
]
21 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  26728
]
22 0.16 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  80442
]
23 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  87248
]
24 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  80445
]
25 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  80443
]
26 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  80444
]
27 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  5483
]
28 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  96005
]
29 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  56130
]
30 0.51 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
]
31 0.34 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
]
32 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:
[
  16
]
33 0.18 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
]
34 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:
[
  18
]
35 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:
[
  19
]
36 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
]
37 0.19 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
]
38 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:
[
  22
]
39 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:
[
  23
]
40 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:
[
  24
]
41 0.23 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
]
42 0.23 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
]
43 0.26 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
]
44 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.category_parent_id = ?
Parameters:
[
  28
]
45 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:
[
  29
]
46 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:
[
  30
]
47 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:
[
  31
]
48 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
]
49 0.26 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
50 0.24 ms
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
Parameters:
[
  "MOZ"
]
51 0.16 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
52 0.19 ms
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
Parameters:
[
  "TarifDefaut"
]
53 0.27 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
]
54 0.45 ms
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
Parameters:
[
  "CAISSE2011"
  87249
]
55 1.42 ms
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
Parameters:
[
  87249
  0
]
56 0.59 ms
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
Parameters:
[
  "C"
  87249
]
57 0.23 ms
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 = ?
Parameters:
[
  201124
]
58 0.20 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
59 0.33 ms
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
Parameters:
[
  87249
  "C"
]
60 0.34 ms
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
Parameters:
[
  87249
  9963597
]
61 0.35 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
62 0.21 ms
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
Parameters:
[
  "MOZ"
]
63 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
64 0.22 ms
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 = ?
Parameters:
[
  201124
]
65 0.19 ms
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
Parameters:
[
  201124
]
66 1.16 ms
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
Parameters:
[
  87249
]
67 0.31 ms
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 = ?
Parameters:
[
  "2025-09-12 17:21:09"
  "%2%"
  87249
]
68 0.26 ms
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 = ?
Parameters:
[
  87249
]
69 0.25 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
70 0.23 ms
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
Parameters:
[
  "MOZ"
]
71 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
72 0.32 ms
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
Parameters:
[
  "CAISSE2011"
  80442
]
73 1.16 ms
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
Parameters:
[
  80442
  0
]
74 0.36 ms
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
Parameters:
[
  "C"
  80442
]
75 0.22 ms
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 = ?
Parameters:
[
  80442
]
76 0.20 ms
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 = ?
Parameters:
[
  201120
]
77 0.22 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
78 0.36 ms
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
Parameters:
[
  80442
  "C"
]
79 0.34 ms
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
Parameters:
[
  80442
  9963405
]
80 0.18 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
81 0.20 ms
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
Parameters:
[
  "MOZ"
]
82 0.14 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
83 0.17 ms
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 = ?
Parameters:
[
  201120
]
84 0.18 ms
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
Parameters:
[
  201120
]
85 1.10 ms
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
Parameters:
[
  80442
]
86 0.24 ms
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 = ?
Parameters:
[
  "2025-09-12 17:21:09"
  "%2%"
  80442
]
87 0.21 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
88 0.20 ms
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
Parameters:
[
  "MOZ"
]
89 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
90 0.28 ms
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
Parameters:
[
  "CAISSE2011"
  80443
]
91 1.14 ms
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
Parameters:
[
  80443
  0
]
92 0.35 ms
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
Parameters:
[
  "C"
  80443
]
93 0.19 ms
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 = ?
Parameters:
[
  80443
]
94 0.18 ms
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 = ?
Parameters:
[
  201125
]
95 0.17 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
96 0.32 ms
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
Parameters:
[
  80443
  "C"
]
97 0.30 ms
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
Parameters:
[
  80443
  9963406
]
98 0.18 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
99 0.21 ms
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
Parameters:
[
  "MOZ"
]
100 0.14 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
101 0.17 ms
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 = ?
Parameters:
[
  201125
]
102 0.17 ms
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
Parameters:
[
  201125
]
103 1.09 ms
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
Parameters:
[
  80443
]
104 0.23 ms
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 = ?
Parameters:
[
  "2025-09-12 17:21:09"
  "%2%"
  80443
]
105 0.18 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
106 0.22 ms
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
Parameters:
[
  "MOZ"
]
107 0.14 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
108 0.27 ms
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
Parameters:
[
  "CAISSE2011"
  80444
]
109 1.15 ms
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
Parameters:
[
  80444
  0
]
110 0.33 ms
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
Parameters:
[
  "C"
  80444
]
111 0.18 ms
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 = ?
Parameters:
[
  80444
]
112 0.18 ms
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 = ?
Parameters:
[
  201128
]
113 0.17 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
114 0.31 ms
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
Parameters:
[
  80444
  "C"
]
115 0.29 ms
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
Parameters:
[
  80444
  9963407
]
116 0.18 ms
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
Parameters:
[
  "TarifDefautBtoB"
]
117 0.21 ms
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
Parameters:
[
  "MOZ"
]
118 0.14 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
119 0.21 ms
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 = ?
Parameters:
[
  201128
]
120 0.22 ms
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
Parameters:
[
  201128
]
121 1.19 ms
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
Parameters:
[
  80444
]
122 0.29 ms
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 = ?
Parameters:
[
  "2025-09-12 17:21:09"
  "%2%"
  80444
]

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\Order\CustomerOrder 2516
App\Entity\User\User 578
App\Entity\Customer\Customer 566
App\Entity\Delivery\Delivery 405
App\Entity\Catalog\ProductCatalog 196
App\Entity\Catalog\CustomerCatalog 196
App\Entity\Product\Market 81
App\Entity\Product\ProductPrice 55
App\Entity\Pricing\Price 52
App\Entity\Pricing\SocietyPromotion 44
App\Entity\Internal\Commercial 34
App\Entity\Product\Product 22
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 18
App\Entity\Product\CharacteristicLabel 17
App\Entity\Internal\Society 15
App\Entity\Delivery\DeliveryCost 5
App\Entity\Pricing\Promotion 4
App\Entity\Internal\Parameter 3