GET https://staging.pgdis.com/produit/27135-compas-couleur-maped-192600

Query Metrics

81 Database Queries
23 Different statements
2325.78 ms Query time
0 Invalid entities
3090 Managed entities

Queries

Group similar statements

# Time Info
1 73.92 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:
[
  "27135-compas-couleur-maped-192600"
]
2 0.50 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:
[
  203532
]
3 0.71 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:
[
  "27135-compas-couleur-maped-192600"
]
4 0.61 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:
[
  "27135-compas-couleur-maped-192600"
]
5 0.54 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:
[
  203532
  1
]
6 1.84 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:
[
  59
  279
  280
  281
  282
  283
  284
  285
  286
  280
  203532
]
7 0.35 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:
[
  1168
]
8 0.25 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:
[
  2066
]
9 0.22 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:
[
  2067
]
10 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:
[
  2068
]
11 0.22 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:
[
  2069
]
12 0.25 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:
[
  3138
]
13 0.24 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:
[
  3192
]
14 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:
[
  3193
]
15 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:
[
  3204
]
16 0.22 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:
[
  3205
]
17 0.37 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 1189.66 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:
[
  203532
  "2025-04-12 22:56:32"
]
19 1033.66 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:
[
  6380193
  6384047
  6387267
  6387361
  6388575
  6385519
  6392248
  6394260
  6400237
  6406625
  6407416
  6411094
  6411213
  6411403
  6412166
  6412858
  6413505
  6414269
  6415509
  6415819
  6416221
  6416959
  6417580
  6418545
  6418843
  6419024
  6419215
  6419327
  6421874
  6421930
  6422243
  6424765
  6424925
  6424926
  6424951
  6424952
  6425806
  6426173
  6426257
  6426350
  6426388
  6427053
  6427627
  6427678
  6427707
  6428031
  6428177
  6428183
  6428213
  6428494
  6428896
  6428923
  6429049
  6429619
  6429970
  6430047
  6430136
  6430137
  6430138
  6430139
  6430140
  6430141
  6430142
  6430143
  6430144
  6430145
  6430146
  6430147
  6430148
  6430149
  6430150
  6430151
  6430152
  6430153
  6430154
  6430155
  6430156
  6430157
  6430158
  6430159
  6430160
  6430161
  6430162
  6430163
  6430164
  6430165
  6430166
  6430167
  6430168
  6430169
  6430170
  6430171
  6430172
  6430173
  6430174
  6430175
  6430176
  6430177
  6430178
  6430179
  6430180
  6430181
  6430182
  6430183
  6430184
  6430320
  6430486
  6430845
  6431170
  6431416
  6431527
  6432355
  6433762
  6434380
  6434753
  6435149
  6435318
  6435320
  6435328
  6435329
  6435336
  6435337
  6435353
  6435355
  6435404
  6435470
  6435596
  6435648
  6435680
  6436021
  6436274
  6436289
  6437626
  6437629
  6437978
  6438601
  6438719
  6440278
  6440303
  6440304
  6440305
  6440306
  6440307
  6440308
  6440309
  6440310
  6440311
  6440312
  6440313
  6440314
  6440315
  6440316
  6440317
  6440318
  6440319
  6440320
  6440321
  6440322
  6440323
  6440324
  6440325
  6440326
  6440327
  6440328
  6440329
  6440330
  6440331
  6440332
  6440333
  6440334
  6440335
  6440337
  6440338
  6440339
  6440340
  6440341
  6440342
  6440343
  6440344
  6440345
  6440346
  6440347
  6440348
  6440349
  6440350
  6440351
  6440352
  6440353
  6440370
  6440558
  6441071
  6441251
  6441579
  6441581
  6443308
  6444349
  6444501
  6444633
  6444747
  6445005
  6445476
  6446263
  6446451
  6446562
  6446630
  6447017
  6447258
  6447331
  6447550
  6447570
  6449113
  6449728
  6450252
  6450631
  6450632
  6450757
  6450819
  6451002
  6451041
  6451129
  6451225
  6451336
  6451391
  6451398
  6451558
  6451565
  6452313
  6452349
  6452415
  6452587
  6454176
  6454360
  6454365
  6454532
  6454625
  6454741
  6454788
  6454799
  6454826
  6454828
  6454861
  6454889
  6454903
  6454930
  6454935
  6454970
  6455040
  6455081
  6455212
  6455420
  6455468
  6455507
  6455602
  6455610
  6455694
  6455728
  6455732
  6457243
  6457420
  6457645
  6457646
  6457803
  6458430
  6458461
  6458475
  6459486
  6459578
  6459937
  6459946
  6461233
  6461654
  6462717
  6463034
  6464492
  6464732
  6465167
  6465253
  6465627
  6466740
  6468968
  6469289
  6470556
  6472035
  6472353
  6472365
  6472463
  6473273
  6473317
  6474791
  6475606
  6477006
  6477040
  6477043
  6477047
  6477566
  6477835
  6477907
  6478388
  6478391
  6478392
  6478393
  6478394
  6478395
  6478396
  6478397
  6478398
  6478399
  6478400
  6478401
  6478402
  6478403
  6478404
  6478405
  6478406
  6478407
  6478408
  6478409
  6478410
  6478411
  6478412
  6478413
  6478414
  6478415
  6478417
  6478418
  6478419
  6478420
  6478421
  6478422
  6478423
  6478424
  6478425
  6478426
  6478427
  6478428
  6478429
  6478430
  6478518
  6478528
  6478529
  6478530
  6478531
  6478532
  6478533
  6478534
  6478535
  6478536
  6478537
  6478538
  6478539
  6478540
  6478541
  6478542
  6478543
  6478544
  6478545
  6478546
  6478547
  6478548
  6478549
  6478550
  6478551
  6478552
  6478553
  6478554
  6478555
  6478556
  6478557
  6478558
  6478559
  6478560
  6478561
  6478562
  6478563
  6478564
  6478565
  6478566
  6478567
  6478568
  6478569
  6478570
  6478571
  6478572
  6478573
  6478574
  6478575
  6478576
  6478577
  6478578
  6478579
  6478588
  6478591
  6478592
  6478593
  6478594
  6478595
  6478596
  6478597
  6478598
  6478599
  6478600
  6478601
  6478602
  6478603
  6478604
  6478605
  6478606
  6478607
  6478608
  6478609
  6478610
  6478611
  6478612
  6478613
  6478614
  6478615
  6478616
  6478617
  6478618
  6478619
  6478620
  6478621
  6478622
  6478623
  6478624
  6478625
  6478626
  6478627
  6478628
  6478629
  6478630
  6478631
  6478632
  6478633
  6478634
  6478635
  6478636
  6478637
  6478638
  6478639
  6478640
  6478641
  6478642
  6478643
  6478644
  6478645
  6478646
  6478647
  6478648
  6478649
  6478650
  6478651
  6478653
  6478654
  6478656
  6478658
  6478880
  6478888
  6478890
  6478891
  6478892
  6478893
  6478894
  6478895
  6478896
  6478897
  6478898
  6478899
  6478900
  6478901
  6478902
  6478903
  6478904
  6478905
  6478906
  6478907
  6478908
  6478909
  6478910
  6478911
  6478912
  6478913
  6478914
  6478915
  6478916
  6478917
  6478918
  6478919
  6478920
  6478921
  6478922
  6478923
  6478924
  6478925
  6478926
  6478928
  6478929
  6478930
  6478931
  6478932
  6478933
  6478934
  6478935
  6478936
  6478937
  6478938
  6478939
  6478940
  6478941
  6478942
  6478943
  6478944
  6478945
  6478946
  6478947
  6478948
  6478949
  6478950
  6478951
  6478952
  6478953
  6478954
  6478955
  6478956
  6478957
  6478958
  6478959
  6478960
  6478961
  6479094
  6479096
  6479097
  6479098
  6479099
  6479100
  6479101
  6479102
  6479103
  6479104
  6479105
  6479106
  6479107
  6479108
  6479109
  6479110
  6479111
  6479112
  6479113
  6479114
  6479115
  6479116
  6479117
  6479118
  6479119
  6479120
  6479121
  6479122
  6479123
  6479124
  6479125
  6479126
  6479127
  6479128
  6479129
  6479130
  6479131
  6479132
  6479133
  6479134
  6479135
  6479136
  6479137
  6479138
  6479139
  6479140
  6479141
  6479142
  6479143
  6479144
  6479145
  6479146
  6479147
  6479148
  6479149
  6479150
  6479151
  6479153
  6479154
  6479155
  6479156
  6479157
  6479158
  6479159
  6479160
  6479161
  6479162
  6479163
  6479164
  6479165
  6479166
  6479167
  6479168
  6479169
  6479170
  6479171
  6479172
  6479173
  6479174
  6479175
  6479176
  6479177
  6479178
  6479179
  6479180
  6479181
  6479182
  6479183
  6479184
  6479185
  6479186
  6479187
  6479188
  6479189
  6479190
  6479191
  6479192
  6479193
  6479194
  6479195
  6479196
  6479197
  6479198
  6479199
  6479200
  6479201
  6479202
  6479203
  6479204
  6479205
  6479343
  6479344
  6479345
  6479346
  6479347
  6479348
  6479349
  6479350
  6479351
  6479352
  6479353
  6479354
  6479355
  6479356
  6479357
  6479358
  6479359
  6479360
  6479361
  6479362
  6479364
  6479365
  6479366
  6479367
  6479368
  6479369
  6479370
  6479371
  6479372
  6479373
  6479374
  6479375
  6479376
  6479377
  6479378
  6479379
  6479380
  6479381
  6479382
  6479383
  6479384
  6479385
  6479386
  6479387
  6479388
  6479390
  6479391
  6479392
  6479393
  6479394
  6479395
  6479396
  6479397
  6479398
  6479399
  6479400
  6479401
  6479403
  6479404
  6479405
  6479406
  6479407
  6479408
  6479410
  6479507
  6479508
  6479509
  6479510
  6479511
  6479512
  6479513
  6479514
  6479515
  6479516
  6479517
  6479518
  6479519
  6479520
  6479521
  6479522
  6479523
  6479524
  6479525
  6479526
  6479527
  6479528
  6479529
  6479530
  6479531
  6479532
  6479533
  6479534
  6479535
  6479536
  6479537
  6479538
  6479539
  6479540
  6479541
  6479542
  6479543
  6479545
  6479546
  6479547
  6479548
  6479549
  6479550
  6479551
  6479552
  6479553
  6479554
  6479555
  6479556
  6479557
  6479558
  6479559
  6479560
  6479561
  6479562
  6479564
  6479565
  6479567
  6479568
  6479569
  6479570
  6479571
  6479572
  6479573
  6479574
  6479575
  6479576
  6479577
  6479578
  6479579
  6479580
  6479669
  6479670
  6479671
  6479672
  6479673
  6479674
  6479675
  6479676
  6479677
  6479678
  6479679
  6479680
  6479681
  6479682
  6479683
  6479684
  6479685
  6479686
  6479687
  6479688
  6479689
  6479690
  6479691
  6479692
  6479693
  6479694
  6479695
  6479697
  6479698
  6479699
  6479700
  6479701
  6479702
  6479703
  6479704
  6479705
  6479706
  6479707
  6479708
  6479709
  6479710
  6479712
  6479797
  6479798
  6479799
  6479800
  6479801
  6479802
  6479803
  6479804
  6479805
  6479806
  6479807
  6479808
  6479809
  6479810
  6479811
  6479812
  6479813
  6479814
  6479815
  6479816
  6479817
  6479818
  6479819
  6479820
  6479821
  6479822
  6479823
  6479824
  6479825
  6479826
  6479827
  6479828
  6479829
  6479830
  6479831
  6479832
  6479833
  6479834
  6479835
  6479836
  6479837
  6479838
  6479839
  6479840
  6479841
  6479842
  6479843
  6479844
  6479845
  6479848
  6479849
  6479850
  6479851
  6479852
  6479853
  6479854
  6479855
  6479856
  6479857
  6479858
  6479859
  6479860
  6479861
  6479862
  6479863
  6479864
  6479865
  6479866
  6479867
  6479868
  6479869
  6479870
  6479871
  6479872
  6479873
  6479874
  6479875
  6479876
  6479877
  6479878
  6479879
  6479880
  6479881
  6479882
  6479883
  6479995
  6479997
  6479998
  6479999
  6480000
  6480001
  6480002
  6480003
  6480004
  6480005
  6480006
  6480008
  6480009
  6480010
  6480011
  6480013
  6480014
  6480015
  6480016
  6480017
  6480018
  6480019
  6480020
  6480021
  6480022
  6480023
  6480024
  6480025
  6480026
  6480027
  6480028
  6480029
  6480030
  6480031
  6480032
  6480033
  6480034
  6480035
  6480036
  6480037
  6480038
  6480039
  6480040
  6480041
  6480042
  6480043
  6480044
  6480045
  6480046
  6480047
  6480048
  6480049
  6480050
  6480051
  6480151
  6480152
  6480153
  6480154
  6480155
  6480156
  6480157
  6480158
  6480159
  6480160
  6480161
  6480162
  6480163
  6480164
  6480165
  6480166
  6480167
  6480168
  6480169
  6480170
  6480171
  6480172
  6480173
  6480174
  6480175
  6480176
  6480177
  6480178
  6480179
  6480180
  6480181
  6480182
  6480183
  6480184
  6480185
  6480186
  6480187
  6480188
  6480189
  6480190
  6480191
  6480192
  6480193
  6480194
  6480195
  6480196
  6480197
  6480198
  6480199
  6480200
  6480201
  6480202
  6480203
  6480204
  6480205
  6480206
  6480207
  6480208
  6480209
  6480210
  6480211
  6480212
  6480213
  6480214
  6480215
  6480216
  6480217
  6480218
  6480219
  6480220
  6480221
  6480222
  6480223
  6480224
  6480225
  6480226
  6480227
  6480228
  6480229
  6480230
  6480231
  6480232
  6480233
  6480234
  6480235
  6480236
  6480237
  6480238
  6480239
  6480240
  6480241
  6480242
  6480243
  6480244
  6480881
  6481243
  6481435
  6482253
  6482485
  6483361
  6483672
  6484850
  6486005
  6486110
  6488629
  6488630
  6488724
  6490052
  6490065
  6494466
  6494548
  6494793
  6494953
  6497102
  6497177
  6497256
  6497296
  6497580
  6497693
  6497710
  6497735
  6498150
  6498153
  6498156
  6498280
  6498308
  6498409
  6498623
  6498624
  6498907
  6499157
  6499230
  6499501
  6499531
  6499558
  6499600
  6500207
  6500465
  6501234
  6501395
  6501398
  6501867
  6502006
  6502041
  6502263
  6502504
  6502533
  6502841
  6503395
  6504716
  6507061
  6507472
  6507979
  6508593
  6509505
  6509506
  6509507
  6509508
  6509509
  6509510
  6509511
  6509512
  6509513
  6509514
  6509515
  6509516
  6509517
  6509518
  6509519
  6509520
  6509521
  6509522
  6509523
  6509524
  6509525
  6509526
  6509527
  6509528
  6509529
  6509530
  6509531
  6509532
  6509533
  6509534
  6509535
  6509536
  6509537
  6509538
  6509539
  6509540
  6509541
  6509542
  6509543
  6509544
  6509545
  6509546
  6509547
  6509548
  6509549
  6509550
  6509551
  6509552
  6509553
  6509554
  6509555
  6509556
  6509557
  6509558
  6509559
  6509560
  6509561
  6509562
  6509563
  6509564
  6509565
  6509566
  6509567
  6509568
  6509569
  6509570
  6509571
  6509572
  6509573
  6509574
  6509575
  6509576
  6509577
  6509578
  6509579
  6509580
  6509581
  6509582
  6509583
  6509584
  6509585
  6509586
  6509587
  6509588
  6509589
  6509590
  6509627
  6510653
  6510923
  6510924
  6510925
  6510926
  6510927
  6510928
  6510929
  6510930
  6510931
  6510932
  6510933
  6510934
  6510935
  6510936
  6510937
  6510938
  6510939
  6510940
  6510941
  6510942
  6510943
  6510944
  6510945
  6510946
  6510947
  6510948
  6510949
  6510950
  6510951
  6510952
  6510953
  6510954
  6510955
  6510956
  6510957
  6510958
  6510959
  6510960
  6510961
  6510962
  6510963
  6510964
  6510965
  6510966
  6510967
  6510968
  6510969
  6510970
  6513347
  6513348
  6513349
  6513350
  6513351
  6513352
  6513353
  6513354
  6513355
  6513356
  6513357
  6513358
  6513359
  6513360
  6513361
  6513362
  6513363
  6513364
  6513365
  6513366
  6513367
  6513368
  6513369
  6513370
  6513371
  6513655
  6513656
  6513657
  6513658
  6513659
  6513660
  6513661
  6513662
  6513663
  6513664
  6513665
  6513666
  6513667
  6513668
  6513669
  6513670
  6513671
  6513672
  6513673
  6513674
  6513675
  6513676
  6513677
  6513678
  6513679
  6513680
  6513681
  6513682
  6513683
  6513684
  6513685
  6513686
  6513687
  6513688
  6513689
  6513690
  6513691
  6513692
  6513693
  6513694
  6513695
  6513696
  6513697
  6513698
  6513699
  6513700
  6513701
  6513702
  6513703
  6513704
  6513705
  6513706
  6513707
  6513708
  6513709
  6513710
  6513711
  6513712
  6513713
  6513714
  6513715
  6513716
  6513717
  6513718
  6513719
  6513720
  6513721
  6513722
  6513723
  6513724
  6513725
  6513726
  6513727
  6513728
  6513729
  6513730
  6513731
  6513732
  6513733
  6513734
  6513735
  6513736
  6513737
  6513738
  6513739
  6513740
  6513741
  6513742
  6513743
  6513879
  6513880
  6513881
  6513882
  6513883
  6513884
  6513885
  6513886
  6513887
  6513888
  6513889
  6513890
  6513891
  6513892
  6513893
  6513894
  6513895
  6513896
  6513897
  6513898
  6513899
  6513900
  6513901
  6513902
  6513903
  6513904
  6513905
  6513906
  6513907
  6513908
  6513909
  6513910
  6513911
  6513912
  6513913
  6513914
  6513915
  6513916
  6513917
  6513918
  6513919
  6513920
  6513921
  6513922
  6513923
  6513924
  6513925
  6513926
  6513927
  6513928
  6513929
  6513930
  6513931
  6513932
  6513933
  6513934
  6513935
  6513936
  6513937
  6513938
  6513939
  6513940
  6513941
  6513942
  6513943
  6513944
  6513945
  6513946
  6513947
  6513948
  6513949
  6513950
  6513951
  6513952
  6513953
  6513954
  6513955
  6513956
  6513957
  6513958
  6513959
  6513960
  6513961
  6513962
  6513963
  6513964
  6513965
  6513966
  6513967
  6513968
  6513969
  6513970
  6513971
  6513972
  6513973
  6514143
  6514144
  6514145
  6514146
  6514147
  6514148
  6514149
  6514150
  6514151
  6514152
  6514153
  6514154
  6514155
  6514156
  6514157
  6514158
  6514159
  6514160
  6514161
  6514162
  6514163
  6514164
  6514165
  6514166
  6514167
  6514168
  6514169
  6514170
  6514171
  6514172
  6514173
  6514174
  6514175
  6514176
  6514177
  6514178
  6514180
  6514181
  6514182
  6514183
  6514184
  6514185
  6514186
  6514187
  6514188
  6514189
  6514190
  6514191
  6514192
  6514193
  6514194
  6514195
  6514196
  6514197
  6514198
  6514199
  6514200
  6514201
  6514202
  6514203
  6514204
  6514205
  6514206
  6514207
  6514208
  6514209
  6514210
  6514211
  6514212
  6514213
  6514214
  6514215
  6514216
  6514217
  6514218
  6514219
  6514220
  6514221
  6514222
  6514223
  6514224
  6514225
  6514226
  6514227
  6514228
  6514229
  6514230
  6514231
  6514232
  6514233
  6514234
  6514235
  6514236
  6514237
  6514238
  6514239
  6514240
  6514241
  6514242
  6514243
  6514244
  6514245
  6514452
  6514453
  6514454
  6514455
  6514456
  6514457
  6514458
  6514459
  6514460
  6514461
  6514462
  6514463
  6514464
  6514465
  6514466
  6514469
  6514470
  6514471
  6514472
  6514473
  6514474
  6514475
  6514476
  6514477
  6514478
  6514479
  6514480
  6514481
  6514482
  6514483
  6514484
  6514575
  6514576
  6514577
  6514578
  6514579
  6514580
  6514581
  6514582
  6514583
  6514584
  6514585
  6514586
  6514587
  6514588
  6514589
  6514590
  6514591
  6514592
  6514593
  6514594
  6514595
  6514596
  6514597
  6514598
  6514599
  6514601
  6514602
  6514603
  6514604
  6514605
  6514606
  6514607
  6514608
  6514609
  6514610
  6514611
  6514612
  6514613
  6514614
  6514615
  6514616
  6514617
  6514618
  6514619
  6514620
  6514621
  6514622
  6514623
  6514624
  6514625
  6514626
  6514629
  6514630
  6514631
  6514632
  6514633
  6514634
  6514635
  6514636
  6514637
  6514638
  6514639
  6514640
  6514641
  6514642
  6514643
  6514644
  6514645
  6514646
  6514647
  6514648
  6514649
  6514650
  6514651
  6514652
  6514653
  6514654
  6514655
  6514656
  6514657
  6514658
  6514659
  6514660
  6514661
  6514662
  6514663
  6514664
  6514665
  6514735
  6514736
  6514737
  6514738
  6514739
  6514740
  6514741
  6514742
  6514743
  6514744
  6514745
  6514746
  6514747
  6514748
  6514749
  6514750
  6514751
  6514752
  6514753
  6514754
  6514755
  6514756
  6514757
  6514758
  6514759
  6514760
  6514761
  6514762
  6514763
  6514764
  6514765
  6514766
  6514767
  6514768
  6514769
  6514770
  6514771
  6514772
  6514773
  6514774
  6514775
  6514776
  6514777
  6514778
  6514779
  6514780
  6514781
  6514782
  6514783
  6514784
  6514785
  6514786
  6514787
  6514841
  6514842
  6514843
  6514844
  6514845
  6514846
  6514847
  6514848
  6514849
  6514850
  6514851
  6514852
  6514853
  6514854
  6514855
  6514856
  6514857
  6514858
  6514859
  6514860
  6514861
  6514862
  6514863
  6514866
  6514867
  6514868
  6514869
  6514870
  6514871
  6514872
  6514873
  6514874
  6514875
  6514876
  6514877
  6514878
  6514879
  6514880
  6514881
  6514882
  6514883
  6514884
  6514885
  6514886
  6514887
  6514888
  6514889
  6514890
  6514891
  6514892
  6514893
  6514894
  6514895
  6514896
  6514897
  6514898
  6514899
  6514900
  6514901
  6514902
  6514903
  6514905
  6514906
  6514907
  6514908
  6514909
  6514911
  6514912
  6514913
  6514914
  6514915
  6514916
  6514917
  6514918
  6514919
  6514920
  6514921
  6514922
  6514923
  6514924
  6514925
  6514926
  6514927
  6514928
  6514929
  6514930
  6514931
  6514932
  6514933
  6514934
  6514935
  6514936
  6514937
  6514938
  6514939
  6514940
  6514941
  6514942
  6514943
  6514944
  6514945
  6514946
  6514947
  6514948
  6514949
  6514950
  6514951
  6514952
  6514953
  6514954
  6514955
  6514956
  6514957
  6514958
  6514959
  6515131
  6515132
  6515677
  6515876
  6515974
  6515975
  6517833
  6517834
  6517835
  6517836
  6517837
  6517838
  6517839
  6517840
  6517841
  6517842
  6517843
  6517844
  6517845
  6517846
  6517848
  6517849
  6517850
  6517851
  6517852
  6517853
  6518611
  6519219
  6519220
  6519296
  6519859
  6520120
  6520248
  6520567
  6523195
  6524115
  6524406
  6524780
  6525047
  6525224
  6525308
  6525359
  6525428
  6526280
  6526977
  6526999
  6527420
  6527779
  6527894
  6528603
  6528768
  6528770
  6528805
  6529047
  6529149
  6529941
  6530266
  6530295
  6530340
  6530350
  6530487
  6532861
  6532968
  6532969
  6532972
  6532973
  6532975
  6532976
  6532979
  6532980
  6532983
  6532984
  6532986
  6532987
  6532990
  6532991
  6532994
  6532995
  6532998
  6532999
  6533001
  6533003
  6533004
  6533194
  6533195
  6533205
  6537753
  6541798
  1000001349
  1000002291
  1000003845
  1000004350
  1000008019
  1000005271
  1000008409
  1000007976
  1000009243
  1000009684
  1000010066
  1000011034
  1000011942
  1000008546
  1000012487
  1000012750
  1000009930
  1000012958
  1000012931
  1000012368
  1000014481
  1000014733
  1000015360
  1000010013
  1000009692
  1000016031
  1000016116
  1000016117
  1000016164
  1000016198
  1000016366
  1000017030
  1000017031
  1000017032
  1000016711
  1000013568
  1000017444
  1000015413
  1000017531
  1000017532
  1000018408
  1000018410
  1000019211
  1000019098
  1000019389
  1000019391
  1000019396
  1000010744
  1000019922
  1000019925
  1000020763
  1000013051
  1000012146
  1000016376
  1000003579
  1000015563
  1000018750
  1000008190
  1000009690
  1000024606
  6378169
  1000019629
  1000018411
  1000016926
  1000016842
  1000026471
  1000012967
  1000026503
  1000026613
  1000026615
  1000026625
  1000026679
  1000014705
  1000026786
  1000026850
  1000026851
  1000026852
  1000026853
  1000026854
  1000026855
  1000026856
  1000026857
  1000026858
  1000026859
  1000026860
  1000026861
  1000026862
  1000026863
  1000026881
  1000026884
  1000026984
  1000027169
  1000027170
  1000027172
  1000027173
  1000015589
  1000027979
  1000027984
  1000027988
  1000012775
  1000028089
  1000028138
  1000028568
  1000028574
  1000028575
  1000028577
  1000028578
  1000028590
  1000028591
  1000028594
  1000015436
  1000027888
  1000015077
  1000030395
  1000030396
  1000030403
  1000030404
  1000030406
  1000030408
  1000030411
  1000030412
  1000030447
  1000030789
  1000030790
  1000030791
  1000030793
  1000028244
  1000031260
  1000031261
  1000018733
  1000002285
  1000013398
  1000030468
  1000032657
  1000032659
  1000032661
  1000032663
  1000032664
  1000032670
  1000032680
  1000032691
  1000032701
  1000032702
  1000032703
  1000032704
  1000032705
  1000032706
  1000032708
  1000032752
  1000016318
  1000035014
  1000035707
  1000030451
  1000026993
  1000027611
  1000036862
  1000036863
  1000036864
  1000036865
  1000036866
  1000036867
  1000036868
  1000036869
  1000036870
  1000038339
  1000016664
  1000039113
  1000039114
  1000039196
  1000039197
  1000039219
  1000039258
  1000039266
  1000039273
  1000039274
  1000039280
  1000039284
  1000039287
  1000039309
  1000039470
  1000039471
  1000039472
  1000039473
  1000039477
  1000039478
  1000039479
  1000039480
  1000039486
  1000039491
  1000039496
  1000016436
  1000041389
  1000038861
  1000042188
  1000042189
  1000043408
  1000043865
  1000043866
  1000043970
  1000044352
  1000026490
  1000046051
  1000008548
  1000047754
  1000047755
  1000047757
  1000047758
  1000048199
  1000048217
  1000048218
  1000048219
  1000048240
  1000048632
  1000048637
  1000048539
  1000048347
  1000048869
  1000048077
  1000049441
  1000048969
  1000027416
  1000050092
  1000047731
  1000049951
  1000050396
  1000050584
  1000050586
  1000050694
  1000050770
  1000049466
  1000049965
  1000050695
  1000048088
  1000051316
  1000051369
  1000051527
  1000051588
  1000051697
  1000051698
  1000051842
  1000051971
  1000051972
  1000052183
  1000051861
  1000050971
  1000052072
  1000052232
  1000052680
  1000052685
  1000052689
  1000052187
  1000048334
  1000051365
  1000053400
  1000053758
  1000054608
  1000054296
  1000047929
  1000035218
  1000055682
  1000055727
  1000055766
  1000055725
  1000053685
  1000039722
  1000057393
  1000057446
  1000057447
  1000058154
  1000059525
  1000059699
  1000060133
  1000060135
  1000060163
  1000060796
  1000060797
  1000061034
  1000061565
  1000061577
  1000061587
  1000061594
  1000061596
  1000062921
  1000062895
  1000064232
  1000065336
  1000065664
  1000064377
  1000066433
  203532
]
20 0.61 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:
[
  1232
]
21 0.27 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:
[
  1231
]
22 0.24 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:
[
  11358
]
23 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:
[
  9527
]
24 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:
[
  169147
]
25 0.18 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:
[
  9616
]
26 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:
[
  70842
]
27 0.20 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
]
28 0.25 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:
[
  240664
]
29 0.20 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:
[
  88138
]
30 0.52 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.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:
[
  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.30 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.25 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.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:
[
  20
]
37 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  21
]
38 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:
[
  22
]
39 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:
[
  23
]
40 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:
[
  24
]
41 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:
[
  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.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:
[
  27
]
44 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:
[
  28
]
45 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:
[
  29
]
46 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:
[
  30
]
47 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:
[
  31
]
48 0.32 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.29 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.29 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.25 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
52 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:
[
  "TarifDefaut"
]
53 0.20 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
]
54 0.38 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"
  203532
]
55 0.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:
[
  203532
  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"
  203532
]
57 0.28 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.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:
[
  203532
  "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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
  203532
]
60 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"
]
61 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"
]
62 0.24 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:
[
  203532
]
64 0.30 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 22:56:35"
  "%2%"
  203532
]
65 0.67 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:
[
  203532
  7
]
66 0.30 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:
[
  203532
]
67 0.45 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 0.27 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 0.19 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
70 1.93 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"
  240664
]
71 2.04 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:
[
  240664
  0
]
72 0.58 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"
  240664
]
73 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:
[
  240664
]
74 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"
]
75 0.67 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:
[
  240664
  "C"
]
76 0.42 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:
[
  240664
  9959371
]
77 0.27 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.33 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.24 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
80 0.41 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:
[
  240664
]
81 0.38 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 22:56:35"
  "%2%"
  240664
]

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 2220
App\Entity\Customer\Customer 194
App\Entity\User\User 149
App\Entity\Delivery\Delivery 142
App\Entity\Catalog\ProductCatalog 90
App\Entity\Catalog\CustomerCatalog 90
App\Entity\Product\Market 51
App\Entity\Pricing\Price 27
App\Entity\Product\ProductPrice 26
App\Entity\Internal\Commercial 24
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 10
App\Entity\Product\CharacteristicLabel 10
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 5
App\Entity\Internal\Parameter 3
App\Infrastructure\Doctrine\Entity\ProductRule 1