GET https://staging.pgdis.com/produit/20330-feutres-de-coloriage-couleur-n-c-dep-102707

Query Metrics

134 Database Queries
25 Different statements
1793.15 ms Query time
0 Invalid entities
3208 Managed entities

Queries

Group similar statements

# Time Info
1 104.10 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:
[
  "20330-feutres-de-coloriage-couleur-n-c-dep-102707"
]
2 0.58 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:
[
  151608
]
3 0.61 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:
[
  "20330-feutres-de-coloriage-couleur-n-c-dep-102707"
]
4 0.46 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:
[
  "20330-feutres-de-coloriage-couleur-n-c-dep-102707"
]
5 0.39 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:
[
  151608
  1
]
6 0.76 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:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
  390
  151608
]
7 0.23 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:
[
  924
]
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:
[
  925
]
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:
[
  1266
]
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:
[
  1267
]
11 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:
[
  1270
]
12 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:
[
  1271
]
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:
[
  1279
]
14 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:
[
  1395
]
15 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:
[
  1420
]
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:
[
  1532
]
17 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:
[
  "ourClientsAlsoBoughtMonths"
]
18 555.70 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:
[
  151608
  "2025-04-12 11:31:59"
]
19 1084.26 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:
[
  6385394
  6385503
  6388512
  6387809
  6389661
  6394405
  6394680
  6395483
  6395805
  6396095
  6396710
  6399570
  6402239
  6403156
  6403194
  6403199
  6403202
  6403372
  6405912
  6405935
  6406482
  6406511
  6406526
  6406555
  6407151
  6408676
  6410434
  6410918
  6415093
  6417780
  6417897
  6422764
  6423770
  6426424
  6426828
  6429947
  6431507
  6434087
  6434090
  6434092
  6434097
  6434105
  6434107
  6434114
  6434115
  6434131
  6434134
  6434136
  6434139
  6434141
  6434144
  6434151
  6434153
  6434155
  6434158
  6434173
  6434179
  6434190
  6434193
  6434863
  6434866
  6434870
  6434872
  6434883
  6434885
  6434889
  6434890
  6434905
  6434908
  6434915
  6434916
  6435673
  6435674
  6435690
  6435693
  6435708
  6435714
  6435724
  6435727
  6436714
  6436829
  6436903
  6436988
  6436994
  6436995
  6437000
  6437001
  6437013
  6437014
  6437021
  6437022
  6437026
  6437027
  6437034
  6437036
  6437046
  6437047
  6437063
  6437072
  6437085
  6437089
  6437112
  6437114
  6438640
  6439007
  6439011
  6439053
  6439057
  6439070
  6439072
  6439089
  6439102
  6439129
  6439132
  6439152
  6439154
  6439175
  6439176
  6439199
  6439202
  6439213
  6439214
  6440121
  6440183
  6440203
  6441472
  6441475
  6441942
  6441943
  6441970
  6441972
  6441989
  6441991
  6442019
  6442024
  6442036
  6442038
  6442262
  6442295
  6442892
  6443370
  6443371
  6443447
  6443450
  6443516
  6443524
  6443549
  6443554
  6443582
  6443583
  6445159
  6446201
  6446234
  6446648
  6446653
  6446655
  6446656
  6446657
  6446959
  6447374
  6448866
  6448906
  6449062
  6448565
  6449126
  6448993
  6450999
  6451010
  6451318
  6451431
  6452182
  6452353
  6452781
  6453711
  6454190
  6454985
  6456387
  6459201
  6459265
  6463107
  6467784
  6468124
  6468134
  6468137
  6472549
  6472551
  6472572
  6472573
  6473016
  6473017
  6473130
  6473131
  6473207
  6473209
  6473218
  6473247
  6473253
  6473261
  6473271
  6473277
  6473295
  6473310
  6473318
  6473324
  6474636
  6474840
  6474841
  6474861
  6474863
  6475231
  6475233
  6476857
  6476884
  6477190
  6477851
  6477910
  6481428
  6483453
  6483480
  6483481
  6483486
  6483487
  6483497
  6483500
  6483504
  6483506
  6483544
  6483545
  6483585
  6483586
  6484473
  6484474
  6484608
  6484613
  6484667
  6484668
  6484873
  6484874
  6484899
  6484900
  6487271
  6487272
  6487889
  6487891
  6488165
  6488166
  6488167
  6488168
  6488169
  6488170
  6488171
  6488172
  6488173
  6488174
  6488175
  6488176
  6488177
  6488178
  6488179
  6488180
  6488181
  6488183
  6488184
  6488185
  6488186
  6488187
  6488188
  6488189
  6488190
  6488191
  6488192
  6488193
  6488194
  6488195
  6488196
  6488197
  6488198
  6488199
  6488200
  6488201
  6488202
  6488203
  6488204
  6488205
  6488206
  6488207
  6488208
  6488209
  6488210
  6488211
  6488212
  6488213
  6488214
  6488215
  6488216
  6488217
  6488218
  6488219
  6488220
  6488221
  6488222
  6488223
  6488224
  6488225
  6488226
  6488227
  6488228
  6488229
  6488230
  6488231
  6488232
  6488233
  6488234
  6488235
  6488237
  6488238
  6488239
  6488240
  6488241
  6488242
  6488243
  6488244
  6488245
  6488246
  6488247
  6489197
  6489198
  6489199
  6489200
  6489201
  6489202
  6489203
  6489204
  6489205
  6489206
  6489207
  6489208
  6489209
  6489210
  6489211
  6489212
  6489213
  6489214
  6489215
  6489216
  6489217
  6489218
  6489219
  6489220
  6489221
  6489222
  6489223
  6489224
  6489225
  6489226
  6489227
  6489228
  6489229
  6489230
  6489231
  6489233
  6489234
  6489235
  6489236
  6489237
  6489238
  6489239
  6489240
  6489241
  6489242
  6489243
  6489244
  6489245
  6489246
  6489247
  6489248
  6489249
  6489250
  6489251
  6489252
  6489253
  6489254
  6489255
  6489256
  6489257
  6489258
  6489259
  6489260
  6489261
  6489262
  6489263
  6489264
  6489265
  6489266
  6489267
  6489268
  6489269
  6489270
  6489271
  6492338
  6492340
  6492418
  6492421
  6492889
  6492891
  6493204
  6493205
  6495589
  6498980
  6498981
  6501621
  6501768
  6501805
  6501806
  6501807
  6501808
  6501809
  6501891
  6502861
  6504246
  6506016
  6506032
  6506053
  6506065
  6506071
  6506086
  6506095
  6506117
  6506134
  6506314
  6506326
  6506336
  6506364
  6506365
  6506366
  6506376
  6506377
  6506378
  6506388
  6506389
  6506390
  6506899
  6506900
  6507995
  6507996
  6507997
  6507998
  6507999
  6508000
  6508001
  6508002
  6508003
  6508004
  6508005
  6508006
  6508007
  6508008
  6508009
  6508010
  6508011
  6508012
  6508013
  6508014
  6508015
  6508016
  6508017
  6508018
  6508019
  6508020
  6508021
  6508022
  6508023
  6508024
  6508025
  6508026
  6508027
  6508028
  6508029
  6508030
  6508031
  6508032
  6508033
  6508034
  6508035
  6508036
  6508037
  6508038
  6508039
  6508040
  6508041
  6508042
  6508043
  6508044
  6508045
  6508046
  6508047
  6508048
  6508049
  6508050
  6508051
  6508052
  6508053
  6508054
  6508055
  6508056
  6508057
  6508058
  6508059
  6508060
  6508062
  6508063
  6508064
  6508065
  6508066
  6508067
  6508068
  6508069
  6508070
  6508071
  6508072
  6508073
  6508074
  6508075
  6508076
  6508077
  6508708
  6508710
  6510468
  6510469
  6515344
  6515345
  6516226
  6516567
  6516568
  6516569
  6516570
  6516572
  6516573
  6516574
  6516575
  6516576
  6516577
  6516578
  6516579
  6516580
  6516581
  6516582
  6516583
  6516584
  6516585
  6516586
  6516587
  6516588
  6516589
  6516590
  6516591
  6516592
  6516593
  6516594
  6516595
  6516596
  6516597
  6516598
  6516599
  6516600
  6516601
  6516602
  6516603
  6516604
  6516605
  6516606
  6516607
  6516612
  6516613
  6516614
  6516615
  6516616
  6516617
  6516618
  6516619
  6516620
  6516621
  6516622
  6516623
  6516624
  6516625
  6516626
  6516628
  6516629
  6516630
  6516631
  6516632
  6516633
  6516634
  6516635
  6516636
  6516637
  6516638
  6516639
  6516640
  6516641
  6516642
  6516643
  6516644
  6516645
  6516646
  6516647
  6516648
  6517122
  6520988
  6521302
  6521303
  6521460
  6521461
  6521531
  6521533
  6526146
  6527576
  6528846
  6528940
  6529128
  6529619
  6529620
  6529621
  6529622
  6529623
  6529624
  6529625
  6529626
  6529627
  6529628
  6529629
  6529630
  6529631
  6529632
  6529633
  6529634
  6529635
  6529636
  6529637
  6529638
  6529639
  6529640
  6529641
  6529642
  6529643
  6529644
  6529645
  6529646
  6529647
  6529648
  6529649
  6529650
  6529651
  6529652
  6529653
  6529654
  6529655
  6529656
  6529657
  6529658
  6529659
  6529660
  6529661
  6529662
  6529663
  6529664
  6529665
  6529666
  6529667
  6529668
  6529669
  6529670
  6529671
  6529672
  6529673
  6529674
  6529675
  6529676
  6529677
  6529678
  6529679
  6529680
  6529681
  6529682
  6529683
  6529684
  6529685
  6529686
  6529687
  6529688
  6529689
  6529690
  6529691
  6529692
  6529693
  6529694
  6529695
  6529696
  6529697
  6529698
  6529699
  6529700
  6529725
  6529726
  6531048
  6531049
  6531050
  6531051
  6531052
  6531053
  6531054
  6531056
  6531057
  6531058
  6531059
  6531060
  6531061
  6531062
  6531063
  6531064
  6531065
  6531066
  6531067
  6531068
  6531069
  6533592
  6537603
  6538108
  6540663
  1000013788
  1000006614
  1000017773
  1000017774
  1000017775
  1000017777
  1000017779
  1000017780
  1000017781
  1000017782
  1000017783
  1000017784
  1000017785
  1000017786
  1000017787
  1000017788
  1000017789
  1000017790
  1000017791
  1000017792
  1000017793
  1000017794
  1000017795
  1000017796
  1000017797
  1000017997
  1000017998
  1000017999
  1000018000
  1000018001
  1000018002
  1000018003
  1000018005
  1000018006
  1000018007
  1000018008
  1000018009
  1000018010
  1000018011
  1000018012
  1000018013
  1000018014
  1000018015
  1000018016
  1000018017
  1000018018
  1000018019
  1000018020
  1000018225
  1000018226
  1000018227
  1000018229
  1000018230
  1000018231
  1000018232
  1000018233
  1000018234
  1000023106
  1000023107
  1000023108
  1000023109
  1000023110
  1000023111
  1000023112
  1000023113
  1000023114
  1000023115
  1000023116
  1000023117
  1000023118
  1000023119
  1000023120
  1000023121
  1000023122
  1000023123
  1000023124
  1000023125
  1000023126
  1000023127
  1000023128
  1000023129
  1000023130
  1000023131
  1000023132
  1000023133
  1000023134
  1000023135
  1000023136
  1000023137
  1000023138
  1000023139
  1000023140
  1000023141
  1000023142
  1000023143
  1000023144
  1000023145
  1000023156
  1000023521
  1000023522
  1000023523
  1000023524
  1000023525
  1000023526
  1000023527
  1000023528
  1000023529
  1000023530
  1000023531
  1000023532
  1000023533
  1000023534
  1000023535
  1000023536
  1000023790
  1000023791
  1000023792
  1000023793
  1000023794
  1000023795
  1000023796
  1000023797
  1000023798
  1000023799
  1000023800
  1000023804
  1000023820
  1000023822
  1000023824
  1000023826
  1000023827
  1000023828
  1000023829
  1000023830
  1000023831
  1000023832
  1000023833
  1000023834
  1000023835
  1000023836
  1000023837
  1000023839
  1000023840
  1000023856
  1000023857
  1000023880
  1000023886
  1000023887
  1000023888
  1000023889
  1000023890
  1000023891
  1000023892
  1000023893
  1000023894
  1000023895
  1000023957
  1000023958
  1000023959
  1000023960
  1000023961
  1000023962
  1000023965
  1000023966
  1000023969
  1000023973
  1000023975
  1000023978
  1000023983
  1000023984
  1000023985
  1000023986
  1000023989
  1000024050
  1000024052
  1000024056
  1000024057
  1000024060
  1000024061
  1000024063
  1000024064
  1000024065
  1000024066
  1000024067
  1000024069
  1000024072
  1000024079
  1000024081
  1000024140
  1000024141
  1000024142
  1000024536
  1000024550
  1000024551
  1000024552
  1000024553
  1000024554
  1000024555
  1000024556
  1000024557
  1000024558
  1000024559
  1000024560
  1000024561
  1000024562
  1000024564
  1000024608
  1000024609
  1000024610
  1000024612
  1000024641
  1000024716
  1000024717
  1000024718
  1000024719
  1000024768
  1000024769
  1000024770
  1000024772
  1000024773
  1000025088
  1000025090
  1000025096
  1000025097
  1000025104
  1000025105
  1000025106
  1000025107
  1000025110
  1000025111
  1000025112
  1000025142
  1000025143
  1000025144
  1000025145
  1000025146
  1000025147
  1000025148
  1000025149
  1000025150
  1000025178
  1000025179
  1000025183
  1000025184
  1000025186
  1000025187
  1000025188
  1000025189
  1000025190
  1000025191
  1000025192
  1000025193
  1000025194
  1000025195
  1000025196
  1000025197
  1000025198
  1000025199
  1000025200
  1000025202
  1000025239
  1000025240
  1000025241
  1000025242
  1000025245
  1000025254
  1000025256
  1000025257
  1000025258
  1000025260
  1000025261
  1000025262
  1000025263
  1000025264
  1000025267
  1000025290
  1000025291
  1000025294
  1000025300
  1000025301
  1000025306
  1000025383
  1000025384
  1000025498
  1000025499
  1000025502
  1000025503
  1000025504
  1000025505
  1000025506
  1000025716
  1000025717
  1000025724
  1000025726
  1000025727
  1000025731
  1000025735
  1000025737
  1000025740
  1000025742
  1000025744
  1000025748
  1000025749
  1000025751
  1000025754
  1000025755
  1000026023
  1000026025
  1000026026
  1000026027
  1000026028
  1000026029
  1000026030
  1000026031
  1000026032
  1000026033
  1000026034
  1000026035
  1000026036
  1000026037
  1000026038
  1000026039
  1000026040
  1000026041
  1000026044
  1000026053
  1000026068
  1000026074
  1000026075
  1000026076
  1000026077
  1000026078
  1000026085
  1000026086
  1000026087
  1000026088
  1000026089
  1000026090
  1000026091
  1000026092
  1000026093
  1000026094
  1000026095
  1000026115
  1000026116
  1000026117
  1000026118
  1000026119
  1000026120
  1000026156
  1000026159
  1000026161
  1000026164
  1000026165
  1000026166
  1000026167
  1000026169
  1000026209
  1000026219
  1000026442
  1000026443
  1000026444
  1000026454
  1000026479
  1000026480
  1000026481
  1000026487
  1000026488
  1000026489
  1000026491
  1000026492
  1000026493
  1000026608
  1000013934
  1000026706
  1000026707
  1000026708
  1000026709
  1000026710
  1000026711
  1000026712
  1000026713
  1000026715
  1000026716
  1000026717
  1000026718
  1000026719
  1000026720
  1000026721
  1000026723
  1000026724
  1000026725
  1000026727
  1000026729
  1000026730
  1000026731
  1000026733
  1000026734
  1000026736
  1000026738
  1000026740
  1000026742
  1000026744
  1000026749
  1000026753
  1000026754
  1000026755
  1000016227
  1000026769
  1000026779
  1000026780
  1000026781
  1000026826
  1000026887
  1000026965
  1000026996
  1000027200
  1000027204
  1000027218
  1000027219
  1000027220
  1000027221
  1000027233
  1000027234
  1000027235
  1000027236
  1000027237
  1000027238
  1000027239
  1000027241
  1000027243
  1000027244
  1000027245
  1000027246
  1000027247
  1000027248
  1000027249
  1000027421
  1000027464
  1000027465
  1000027466
  1000027467
  1000027469
  1000027471
  1000027472
  1000027473
  1000027474
  1000027475
  1000027476
  1000027477
  1000027478
  1000027479
  1000027480
  1000027481
  1000027482
  1000027484
  1000027486
  1000027488
  1000027489
  1000027491
  1000027492
  1000027494
  1000027495
  1000027497
  1000027498
  1000027499
  1000027500
  1000027502
  1000027504
  1000027505
  1000027511
  1000027514
  1000027575
  1000027638
  1000027664
  1000027668
  1000027671
  1000027673
  1000027688
  1000027689
  1000027691
  1000027693
  1000027694
  1000027696
  1000027700
  1000027704
  1000027705
  1000027710
  1000027711
  1000027713
  1000027716
  1000027717
  1000027718
  1000027720
  1000027723
  1000027725
  1000027728
  1000027729
  1000027730
  1000027733
  1000027739
  1000027742
  1000027745
  1000027747
  1000027750
  1000027751
  1000027753
  1000027758
  1000027788
  1000027823
  1000027824
  1000027826
  1000027828
  1000027829
  1000027831
  1000027838
  1000027839
  1000027841
  1000027844
  1000027846
  1000027847
  1000027854
  1000027863
  1000027875
  1000027908
  1000027910
  1000027914
  1000027915
  1000027924
  1000027928
  1000027930
  1000027932
  1000027933
  1000027934
  1000027935
  1000027937
  1000027938
  1000027939
  1000027940
  1000027941
  1000027942
  1000027943
  1000027944
  1000027945
  1000027946
  1000027947
  1000027948
  1000027950
  1000028319
  1000028321
  1000028322
  1000028323
  1000028324
  1000028325
  1000028326
  1000028327
  1000028328
  1000028335
  1000028336
  1000028339
  1000028340
  1000028434
  1000028449
  1000028779
  1000028781
  1000028782
  1000028787
  1000028792
  1000028795
  1000028861
  1000028863
  1000028867
  1000028868
  1000029091
  1000029140
  1000029141
  1000029142
  1000029144
  1000029146
  1000029155
  1000029379
  1000029488
  1000029501
  1000029545
  1000029548
  1000029549
  1000029550
  1000029631
  1000029666
  1000029667
  1000029674
  1000029677
  1000029678
  1000029679
  1000029680
  1000029682
  1000029704
  1000029723
  1000029734
  1000029747
  1000029751
  1000029755
  1000029774
  1000029775
  1000029776
  1000029790
  1000029791
  1000029799
  1000029812
  1000030250
  1000030251
  1000030252
  1000030253
  1000030254
  1000030255
  1000030256
  1000030257
  1000030258
  1000030259
  1000030260
  1000030261
  1000030262
  1000030263
  1000030264
  1000030265
  1000030266
  1000030267
  1000030268
  1000030269
  1000030270
  1000030271
  1000030272
  1000030273
  1000030274
  1000030275
  1000030276
  1000030281
  1000030282
  1000030283
  1000030284
  1000030285
  1000030286
  1000030360
  1000030361
  1000030362
  1000030363
  1000030366
  1000030377
  1000030435
  1000030436
  1000030469
  1000030470
  1000030471
  1000030472
  1000030473
  1000030474
  1000030475
  1000030476
  1000030477
  1000030478
  1000030479
  1000030480
  1000030482
  1000030483
  1000030576
  1000030577
  1000030578
  1000030579
  1000030580
  1000030581
  1000030582
  1000030587
  1000030589
  1000030591
  1000030592
  1000030594
  1000030595
  1000030596
  1000030597
  1000030598
  1000030599
  1000030604
  1000030606
  1000030607
  1000030627
  1000030628
  1000030629
  1000030630
  1000030631
  1000030751
  1000030754
  1000030755
  1000030764
  1000030768
  1000030769
  1000030770
  1000030771
  1000030772
  1000030773
  1000030775
  1000030792
  1000030797
  1000030809
  1000030810
  1000030811
  1000030812
  1000030813
  1000030814
  1000030816
  1000030817
  1000030818
  1000030820
  1000030822
  1000030823
  1000030833
  1000030843
  1000030864
  1000031034
  1000031334
  1000031335
  1000031336
  1000031337
  1000031338
  1000031339
  1000031340
  1000031341
  1000031342
  1000031343
  1000031344
  1000031345
  1000031347
  1000031348
  1000031349
  1000031350
  1000031351
  1000031352
  1000031353
  1000031354
  1000031355
  1000031370
  1000031371
  1000031689
  1000031691
  1000031692
  1000031695
  1000031701
  1000031702
  1000031704
  1000031717
  1000031890
  1000031891
  1000031892
  1000031893
  1000031894
  1000031895
  1000031896
  1000031897
  1000031898
  1000031899
  1000031900
  1000031901
  1000031903
  1000031904
  1000031995
  1000031996
  1000031998
  1000031999
  1000032000
  1000032001
  1000032002
  1000032005
  1000032006
  1000032015
  1000021229
  1000032382
  1000032398
  1000032401
  1000032402
  1000032404
  1000032405
  1000032406
  1000032407
  1000032411
  1000032592
  1000032594
  1000032636
  1000032652
  1000032777
  1000032791
  1000032804
  1000032805
  1000032806
  1000032807
  1000032808
  1000032809
  1000032810
  1000032811
  1000032812
  1000032813
  1000032814
  1000032815
  1000032816
  1000032925
  1000032930
  1000032932
  1000032940
  1000032942
  1000032950
  1000032952
  1000032953
  1000032954
  1000032956
  1000032957
  1000032959
  1000032960
  1000032961
  1000032963
  1000032964
  1000032965
  1000032966
  1000032967
  1000032968
  1000032970
  1000032972
  1000032975
  1000032976
  1000032977
  1000032978
  1000032979
  1000032980
  1000032981
  1000032982
  1000032983
  1000032984
  1000032985
  1000032986
  1000032987
  1000032988
  1000032989
  1000032990
  1000032991
  1000032992
  1000032993
  1000032994
  1000033005
  1000033008
  1000033010
  1000033137
  1000033139
  1000033140
  1000033141
  1000033143
  1000033145
  1000033146
  1000033150
  1000033152
  1000033284
  1000033289
  1000033290
  1000033291
  1000033292
  1000033293
  1000033294
  1000033300
  1000033301
  1000033309
  1000033313
  1000033744
  1000033842
  1000033843
  1000033844
  1000033845
  1000033846
  1000033847
  1000033848
  1000033849
  1000033850
  1000033900
  1000033901
  1000033902
  1000033903
  1000033904
  1000033906
  1000033907
  1000033908
  1000033909
  1000033910
  1000033911
  1000033912
  1000033913
  1000033914
  1000033915
  1000033916
  1000033917
  1000033918
  1000033919
  1000033920
  1000033921
  1000033922
  1000033925
  1000033926
  1000033928
  1000033931
  1000033932
  1000033933
  1000033934
  1000033935
  1000033936
  1000033937
  1000033938
  1000033939
  1000033940
  1000033941
  1000033942
  1000034156
  1000034157
  1000034166
  1000034167
  1000034211
  1000034168
  1000034460
  1000034461
  1000034837
  1000034838
  1000034839
  1000034841
  1000034843
  1000034844
  1000034892
  1000034893
  1000034894
  1000034895
  1000034896
  1000034897
  1000034898
  1000034899
  1000034902
  1000034903
  1000034904
  1000034905
  1000034911
  1000034912
  1000034913
  1000034914
  1000034916
  1000034918
  1000034964
  1000034965
  1000034966
  1000034973
  1000034977
  1000034978
  1000034980
  1000034981
  1000035020
  1000035157
  1000035158
  1000035159
  1000035160
  1000035161
  1000035162
  1000035163
  1000035164
  1000035165
  1000035166
  1000035167
  1000035168
  1000035169
  1000035170
  1000035171
  1000035172
  1000035173
  1000035174
  1000035175
  1000035176
  1000035177
  1000035178
  1000035179
  1000035180
  1000035181
  1000035182
  1000035183
  1000035184
  1000035185
  1000035186
  1000035187
  1000035188
  1000035189
  1000035190
  1000035191
  1000035192
  1000035193
  1000035209
  1000035210
  1000035211
  1000035212
  1000035213
  1000035214
  1000035215
  1000035217
  1000035219
  1000035220
  1000035221
  1000035222
  1000035223
  1000035224
  1000035225
  1000035226
  1000035227
  1000035229
  1000035230
  1000035231
  1000035232
  1000035233
  1000035235
  1000035382
  1000035523
  1000035517
  1000035530
  1000035531
  1000035532
  1000035537
  1000035548
  1000035549
  1000035550
  1000035551
  1000035552
  1000035553
  1000035555
  1000035556
  1000035557
  1000035558
  1000035559
  1000035560
  1000035561
  1000035562
  1000035563
  1000035564
  1000035587
  1000035588
  1000035593
  1000035594
  1000035595
  1000035596
  1000035597
  1000035598
  1000035599
  1000035600
  1000035601
  1000035602
  1000035603
  1000035604
  1000035605
  1000035606
  1000035607
  1000035673
  1000035674
  1000035675
  1000035676
  1000035677
  1000035678
  1000035679
  1000035807
  1000035824
  1000035831
  1000035832
  1000035838
  1000035840
  1000035841
  1000035846
  1000035848
  1000035849
  1000035850
  1000035865
  1000036839
  1000036840
  1000036980
  1000036981
  1000036983
  1000036984
  1000036992
  1000037130
  1000037133
  1000037134
  1000037135
  1000037136
  1000037137
  1000037139
  1000037140
  1000037141
  1000037142
  1000037143
  1000037144
  1000037145
  1000037146
  1000037147
  1000037149
  1000037150
  1000037151
  1000037152
  1000037153
  1000037154
  1000037155
  1000037156
  1000037157
  1000037158
  1000037159
  1000037160
  1000037161
  1000037162
  1000037163
  1000037312
  1000037313
  1000037314
  1000037315
  1000037316
  1000037317
  1000037318
  1000037321
  1000037324
  1000037325
  1000037327
  1000037390
  1000037392
  1000037393
  1000037394
  1000037395
  1000037396
  1000037397
  1000037398
  1000037399
  1000037401
  1000037404
  1000037405
  1000037406
  1000037415
  1000037416
  1000037417
  1000037418
  1000037427
  1000037430
  1000037437
  1000037438
  1000037439
  1000037440
  1000037441
  1000037442
  1000037443
  1000037444
  1000037445
  1000037446
  1000037447
  1000037449
  1000037451
  1000037454
  1000037455
  1000037456
  1000037457
  1000037458
  1000037459
  1000037460
  1000037462
  1000037463
  1000037464
  1000037465
  1000037466
  1000037468
  1000037498
  1000037503
  1000037504
  1000037505
  1000037506
  1000037508
  1000037530
  1000037532
  1000037536
  1000037537
  1000037538
  1000037539
  1000037540
  1000037541
  1000037542
  1000037543
  1000037544
  1000037545
  1000037546
  1000037548
  1000038164
  1000038165
  1000038166
  1000038171
  1000038172
  1000038173
  1000038174
  1000038176
  1000038177
  1000038234
  1000038235
  1000038236
  1000038237
  1000038238
  1000038239
  1000038240
  1000038241
  1000038242
  1000038243
  1000038244
  1000038245
  1000038246
  1000038247
  1000038248
  1000038249
  1000038267
  1000038268
  1000038269
  1000038272
  1000038274
  1000038275
  1000038276
  1000038277
  1000038278
  1000038279
  1000038416
  1000038417
  1000038435
  1000038436
  1000038447
  1000038448
  1000038449
  1000038450
  1000038452
  1000038453
  1000038454
  1000038455
  1000038456
  1000038457
  1000038458
  1000038459
  1000038460
  1000038461
  1000038462
  1000038463
  1000038464
  1000038484
  1000038485
  1000038486
  1000038487
  1000038488
  1000038489
  1000038490
  1000038491
  1000038492
  1000038493
  1000038494
  1000038495
  1000038496
  1000038497
  1000038498
  1000038499
  1000038500
  1000038501
  1000038502
  1000038503
  1000038504
  1000038505
  1000038506
  1000038507
  1000038509
  1000038510
  1000038511
  1000038512
  1000038513
  1000038514
  1000038515
  1000038516
  1000038517
  1000038518
  1000038519
  1000038520
  1000038521
  1000038522
  1000038526
  1000038527
  1000038529
  1000038540
  1000038541
  1000038542
  1000038543
  1000038544
  1000038545
  1000038546
  1000038547
  1000038549
  1000038550
  1000038555
  1000038596
  1000038597
  1000038601
  1000038611
  1000038617
  1000038662
  1000038667
  1000038669
  1000038670
  1000038675
  1000038676
  1000038677
  1000038681
  1000038682
  1000038701
  1000038741
  1000038743
  1000038744
  1000038747
  1000038758
  1000038808
  1000038809
  1000038810
  1000038811
  1000038812
  1000038813
  1000038814
  1000038815
  1000038816
  1000038817
  1000038818
  1000038819
  1000038820
  1000038821
  1000038822
  1000038823
  1000038824
  1000038825
  1000038826
  1000038827
  1000038828
  1000038829
  1000038840
  1000038841
  1000038842
  1000038843
  1000038844
  1000038944
  1000038946
  1000038947
  1000038960
  1000039000
  1000039001
  1000039004
  1000039005
  1000039007
  1000039054
  1000039055
  1000039062
  1000039063
  1000039073
  1000039074
  1000039077
  1000039079
  1000039084
  1000039085
  1000039086
  1000039099
  1000039100
  1000039101
  1000039103
  1000039166
  1000039168
  1000039169
  1000039170
  1000039171
  1000039172
  1000039319
  1000039702
  1000039703
  1000039704
  1000039705
  1000039706
  1000040035
  1000040036
  1000040040
  1000040041
  1000040042
  1000040043
  1000040046
  1000040051
  1000040053
  1000040054
  1000040055
  1000040056
  1000040057
  1000040059
  1000040060
  1000040061
  1000040062
  1000040063
  1000040064
  1000039991
  1000040533
  1000040537
  1000040539
  1000040541
  1000040561
  1000040562
  1000040563
  1000040564
  1000040566
  1000040567
  1000040568
  1000040569
  1000040570
  1000040571
  1000040572
  1000040573
  1000040574
  1000040575
  1000040576
  1000040577
  1000040578
  1000040579
  1000040580
  1000040581
  1000040582
  1000040583
  1000040584
  1000040585
  1000040586
  1000040587
  1000040588
  1000040590
  1000040591
  1000040592
  1000040593
  1000040594
  1000040595
  1000040596
  1000040597
  1000040598
  1000040599
  1000040600
  1000040601
  1000040602
  1000040603
  1000040604
  1000040605
  1000040606
  1000040607
  1000040608
  1000040609
  1000040610
  1000040611
  1000040612
  1000040613
  1000040614
  1000040615
  1000040616
  1000040617
  1000040618
  1000040619
  1000040620
  1000040621
  1000040622
  1000040623
  1000040624
  1000040625
  1000040626
  1000040627
  1000040628
  1000040629
  1000040630
  1000040631
  1000040632
  1000040633
  1000040634
  1000040635
  1000040636
  1000040637
  1000040638
  1000040639
  1000040640
  1000040641
  1000040642
  1000040643
  1000040644
  1000040645
  1000040646
  1000040647
  1000040648
  1000040649
  1000040650
  1000040651
  1000040652
  1000040653
  1000040654
  1000040655
  1000040656
  1000040657
  1000040658
  1000040659
  1000040660
  1000040661
  1000040662
  1000040663
  1000040664
  1000040665
  1000040666
  1000040667
  1000040668
  1000040669
  1000040671
  1000040672
  1000040673
  1000040674
  1000040675
  1000040676
  1000040677
  1000040678
  1000040679
  1000040681
  1000040682
  1000040683
  1000040684
  1000040685
  1000040686
  1000040687
  1000040688
  1000040689
  1000040690
  1000040691
  1000040692
  1000040693
  1000040720
  1000040726
  1000040729
  1000040731
  1000040733
  1000040814
  1000040815
  1000040816
  1000040817
  1000040818
  1000040841
  1000040842
  1000040844
  1000040846
  1000040847
  1000040854
  1000040855
  1000040856
  1000040857
  1000040858
  1000040862
  1000038300
  1000043321
  1000043322
  1000043327
  1000043331
  1000043335
  1000043340
  1000043343
  1000044684
  1000044685
  1000044688
  1000044690
  1000044691
  1000044693
  1000044694
  1000044696
  1000044698
  1000044699
  1000044700
  1000044701
  1000044702
  1000044705
  1000044706
  1000044707
  1000044708
  1000044709
  1000044710
  1000044711
  1000044712
  1000044714
  1000044716
  1000044738
  1000044742
  1000046641
  1000046642
  1000046643
  1000046645
  1000046646
  1000046648
  1000046649
  1000046650
  1000046651
  1000046652
  1000046653
  1000046657
  1000046659
  1000046661
  1000046663
  1000046670
  1000046676
  1000046690
  1000046701
  1000046707
  1000046722
  1000046728
  1000047072
  1000047073
  1000047074
  1000047075
  1000047076
  1000047077
  1000047078
  1000047079
  1000047080
  1000047081
  1000047082
  1000047083
  1000047084
  1000047085
  1000047086
  1000047087
  1000047088
  1000047089
  1000047090
  1000047091
  1000047092
  1000047093
  1000047094
  1000047095
  1000047096
  1000047097
  1000047098
  1000047099
  1000047100
  1000047101
  1000047102
  1000047103
  1000047104
  1000047105
  1000047106
  1000047107
  1000047108
  1000047109
  1000047302
  1000047303
  1000047304
  1000047305
  1000047306
  1000047307
  1000047308
  1000047309
  1000047310
  1000047311
  1000047312
  1000047313
  1000047314
  1000047315
  1000047316
  1000047317
  1000012920
  1000047760
  1000047771
  1000047840
  1000047872
  1000048214
  1000048246
  1000048868
  1000049489
  1000049491
  1000049492
  1000049798
  1000049874
  1000050632
  1000050954
  1000051618
  1000051621
  1000051852
  1000051950
  1000051952
  1000049920
  1000054548
  1000054852
  1000049136
  1000055277
  1000055278
  1000055354
  1000055963
  1000055960
  1000036655
  1000056786
  1000056865
  1000057663
  1000057666
  1000057865
  1000059705
  1000061183
  1000062702
  1000062800
  1000065607
  151608
]
20 0.34 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:
[
  5496
]
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:
[
  341032
]
22 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
]
23 0.17 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:
[
  87344
]
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:
[
  341031
]
25 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:
[
  80451
]
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:
[
  5477
]
27 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:
[
  2548
]
28 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:
[
  244457
]
29 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:
[
  9864
]
30 2.81 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.31 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.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:
[
  17
]
34 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:
[
  18
]
35 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:
[
  19
]
36 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:
[
  20
]
37 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:
[
  21
]
38 0.21 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.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:
[
  24
]
41 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  25
]
42 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  26
]
43 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:
[
  27
]
44 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:
[
  28
]
45 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:
[
  29
]
46 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:
[
  30
]
47 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:
[
  31
]
48 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:
[
  32
]
49 0.30 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.28 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.18 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
52 0.23 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.18 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
]
54 0.39 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"
  151608
]
55 0.33 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:
[
  151608
  0
]
56 0.41 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"
  151608
]
57 0.23 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"
]
58 0.37 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:
[
  151608
  "C"
]
59 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:
[
  151608
  9957924
]
60 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"
]
61 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"
]
62 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
63 0.29 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:
[
  151608
]
64 0.34 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 11:32:01"
  "%2%"
  151608
]
65 0.68 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[
  151608
  7
]
66 0.32 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:
[
  151608
]
67 1.36 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"
]
68 2.39 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"
]
69 3.21 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
70 0.56 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"
  87344
]
71 0.41 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:
[
  87344
  0
]
72 0.44 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"
  87344
]
73 0.21 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:
[
  87344
]
74 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"
]
75 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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[
  87344
  "C"
]
76 0.32 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:
[
  87344
  9963517
]
77 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:
[
  "TarifDefautBtoB"
]
78 0.28 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"
]
79 0.17 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
80 0.28 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:
[
  87344
]
81 0.26 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 11:32:01"
  "%2%"
  87344
]
82 1.56 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[
  87344
  7
]
83 0.47 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"
]
84 0.31 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"
]
85 0.20 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
86 0.46 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"
  80451
]
87 1.45 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:
[
  80451
  0
]
88 0.43 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"
  80451
]
89 0.30 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:
[
  80451
]
90 0.26 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:
[
  201191
]
91 0.24 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"
]
92 0.39 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:
[
  80451
  "C"
]
93 0.37 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:
[
  80451
  9963414
]
94 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"
]
95 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"
]
96 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
97 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:
[
  201191
]
98 0.24 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:
[
  201191
]
99 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:
[
  80451
]
100 0.26 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 11:32:01"
  "%2%"
  80451
]
101 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"
]
102 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"
]
103 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
104 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"
  2548
]
105 0.27 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:
[
  2548
  0
]
106 0.29 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"
  2548
]
107 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:
[
  2548
]
108 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"
]
109 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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[
  2548
  "C"
]
110 0.32 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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
  2548
]
111 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"
]
112 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"
]
113 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
114 0.25 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:
[
  2548
]
115 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 11:32:01"
  "%2%"
  2548
]
116 0.63 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[
  2548
  7
]
117 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"
]
118 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"
]
119 0.15 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
120 0.37 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"
  9864
]
121 1.73 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:
[
  9864
  0
]
122 0.42 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"
  9864
]
123 0.23 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:
[
  9864
]
124 0.24 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:
[
  204176
]
125 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"
]
126 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:
[
  9864
  "C"
]
127 0.37 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:
[
  9864
  9960343
]
128 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:
[
  "TarifDefautBtoB"
]
129 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"
]
130 0.16 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
131 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:
[
  204176
]
132 1.48 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:
[
  9864
]
133 0.26 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 11:32:01"
  "%2%"
  9864
]
134 0.62 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[
  9864
  7
]

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 2431
App\Entity\Catalog\ProductCatalog 154
App\Entity\Catalog\CustomerCatalog 154
App\Entity\User\User 141
App\Entity\Product\ProductPrice 55
App\Entity\Pricing\Price 48
App\Entity\Customer\Customer 44
App\Entity\Delivery\Delivery 36
App\Entity\Product\Market 23
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Internal\Commercial 20
App\Entity\Internal\Society 15
App\Entity\Product\Characteristic 12
App\Entity\Product\CharacteristicLabel 12
App\Entity\Pricing\SocietyPromotion 12
App\Entity\Delivery\DeliveryCost 4
App\Entity\Internal\Parameter 3
App\Entity\Pricing\Promotion 2