Query Metrics
82
Database Queries
22
Different statements
3016.31 ms
Query time
0
Invalid entities
4354
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 53.39 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:
[
"72201-cahiers-polypro-orange-n-c-72201-maju"
]
|
2 | 0.37 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:
[
87251
]
|
3 | 0.63 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:
[
"72201-cahiers-polypro-orange-n-c-72201-maju"
]
|
4 | 0.44 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:
[
"72201-cahiers-polypro-orange-n-c-72201-maju"
]
|
5 | 0.40 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:
[ 87251 1 ] |
6 | 0.67 ms |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[ 41 189 190 191 192 193 194 195 191 87251 ] |
7 | 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:
[
581
]
|
8 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
582
]
|
9 | 0.16 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
583
]
|
10 | 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:
[
594
]
|
11 | 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:
[
597
]
|
12 | 0.14 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
607
]
|
13 | 0.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:
[
692
]
|
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:
[
693
]
|
15 | 0.13 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
694
]
|
16 | 0.16 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
695
]
|
17 | 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:
[
"ourClientsAlsoBoughtMonths"
]
|
18 | 1315.33 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:
[ 87251 "2025-04-13 04:26:44" ] |
19 | 1629.43 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:
[ 6383995 6384229 6384729 6385604 6385650 6384047 6386572 6386823 6387267 6387287 6388293 6388303 6388330 6388366 6388490 6388916 6388697 6389019 6389120 6389121 6389130 6387016 6388950 6386995 6390325 6390562 6391213 6391341 6391376 6391475 6391500 6391830 6391983 6385359 6392151 6392189 6389039 6392440 6389573 6393405 6381461 6393790 6378047 6393690 6394184 6387546 6394447 6394781 6396097 6396227 6396240 6396242 6396243 6398166 6398167 6398665 6398693 6398762 6400162 6400403 6400727 6400791 6400838 6401545 6401570 6401652 6401955 6402683 6403303 6403608 6404549 6404665 6404807 6405041 6405154 6405403 6405911 6406073 6406565 6406832 6407746 6408396 6409107 6409166 6409437 6409462 6409567 6409575 6409624 6410036 6410250 6410673 6410840 6410866 6411059 6411122 6411365 6411729 6411810 6411903 6411901 6412007 6412016 6412027 6412049 6412054 6412087 6412091 6412171 6412172 6412194 6412385 6412587 6412682 6413024 6413172 6413300 6413479 6413508 6413521 6413551 6413569 6413648 6413712 6413887 6414159 6414239 6414256 6414258 6414260 6414265 6414267 6414286 6414616 6414897 6414984 6415012 6415023 6415030 6415070 6415072 6415088 6415107 6415152 6415176 6415360 6415409 6415445 6415657 6415845 6415959 6416036 6416120 6416121 6416149 6416153 6416205 6416214 6416239 6416257 6416269 6416270 6416301 6416312 6416390 6416778 6416814 6416840 6416846 6416850 6416958 6416979 6417118 6417234 6417315 6417316 6417326 6417444 6417521 6417550 6417750 6417972 6418844 6418974 6418981 6418998 6419151 6419188 6419215 6419236 6419300 6419307 6419319 6419343 6419374 6419379 6419414 6419537 6420430 6420435 6420610 6420622 6420630 6420647 6420659 6420677 6420795 6420883 6421097 6421900 6422161 6422649 6422651 6422696 6422713 6422748 6422807 6422814 6422894 6423128 6423135 6423164 6423568 6423712 6423954 6424013 6424232 6424641 6424661 6425388 6425436 6425565 6425702 6426154 6426196 6426324 6426338 6426557 6426601 6426938 6426947 6426978 6427106 6427165 6427285 6427506 6427581 6427591 6427659 6427951 6428239 6428491 6428494 6428590 6428677 6428695 6428751 6428775 6428834 6428871 6429017 6429486 6429615 6429645 6429693 6429841 6429856 6429913 6430036 6430320 6430362 6430564 6430579 6430930 6431258 6431497 6431541 6431570 6431589 6431672 6431714 6431774 6431826 6431959 6432090 6432177 6432189 6432192 6432213 6432244 6432247 6432254 6433420 6433569 6433626 6433682 6433735 6433859 6434147 6434215 6434232 6434626 6434694 6434703 6434792 6434805 6434852 6434859 6434911 6434967 6435048 6435101 6435149 6435181 6435283 6435559 6435574 6435634 6435704 6435776 6435860 6435897 6436236 6437019 6437037 6437148 6437309 6437583 6437641 6437726 6437825 6438038 6438061 6438068 6438087 6438089 6438102 6438517 6438554 6438631 6438655 6438737 6438815 6438870 6438957 6439076 6439108 6439274 6439560 6439667 6439744 6439768 6439887 6439927 6439949 6440491 6440544 6440634 6440673 6440876 6440941 6441023 6441145 6441272 6441410 6441949 6442087 6442129 6442246 6442459 6442943 6443308 6443354 6443402 6443439 6443929 6443957 6443971 6444255 6444275 6444290 6444356 6444427 6444671 6444857 6445303 6445378 6445471 6445521 6445601 6445744 6446055 6446128 6446136 6446200 6446224 6446342 6446483 6446797 6446814 6446938 6447060 6447076 6447332 6447399 6447466 6447692 6447788 6448563 6448568 6448617 6448697 6449088 6449113 6449338 6449391 6449576 6449615 6449673 6449686 6449728 6449885 6449917 6449940 6449994 6450030 6450172 6450174 6450183 6450185 6450186 6450195 6450229 6450253 6450270 6450405 6450505 6450547 6450613 6450623 6450625 6450657 6450879 6450881 6450961 6450971 6450977 6450993 6450996 6451000 6451049 6451071 6451103 6451111 6451120 6451129 6451228 6451243 6451247 6451251 6451280 6451287 6451299 6451316 6451336 6451350 6451365 6451367 6451413 6451418 6451420 6451439 6451563 6451569 6451616 6451649 6451650 6451651 6451665 6451666 6451707 6451709 6451793 6451875 6452000 6452004 6452026 6452031 6452037 6452039 6452041 6452042 6452050 6452256 6452364 6452369 6452372 6452383 6452394 6452434 6452494 6452539 6452555 6452564 6452614 6453146 6453471 6453482 6453517 6453745 6453840 6454019 6454025 6454130 6454188 6454197 6454200 6454531 6454561 6454588 6454591 6454610 6454622 6454625 6454631 6454634 6454645 6454647 6454648 6454698 6454709 6454726 6454773 6454787 6454812 6454830 6454842 6454848 6454862 6454863 6454920 6454926 6454930 6454982 6454997 6454999 6455001 6455003 6455004 6455082 6455136 6455138 6455152 6455153 6455194 6455213 6455276 6455282 6455318 6455345 6455417 6455451 6455453 6455475 6455513 6455530 6455535 6455595 6455598 6455602 6455614 6455620 6455636 6455638 6455642 6455660 6455692 6455712 6455721 6455764 6455807 6455835 6455850 6455864 6455867 6455888 6455913 6455953 6455958 6455971 6456065 6456094 6456264 6456268 6456560 6456584 6456586 6457061 6457248 6457255 6457259 6457262 6457267 6457448 6457645 6457711 6458559 6459126 6459224 6459265 6459277 6459287 6459610 6460043 6460141 6460232 6460262 6460466 6460915 6460950 6461042 6461080 6461307 6461401 6461439 6461450 6461662 6461675 6461761 6461853 6461854 6462452 6462492 6462578 6462917 6462941 6464021 6464198 6464382 6464767 6465378 6465665 6466709 6466719 6466755 6466806 6467161 6467462 6468066 6468071 6468112 6468115 6468135 6468201 6468787 6468796 6469138 6469214 6469341 6469826 6469853 6470107 6470277 6470278 6470286 6470293 6470413 6470518 6470529 6470554 6470567 6470766 6471027 6471323 6471350 6471801 6471898 6472035 6472230 6472254 6472383 6472542 6472557 6472616 6472717 6472791 6473078 6473173 6473278 6474432 6474706 6475359 6475434 6475484 6475539 6475606 6475657 6475660 6475697 6475767 6476467 6476509 6476598 6476884 6476896 6476932 6476933 6477609 6477632 6477801 6477851 6477865 6477914 6479438 6480073 6480471 6480504 6480730 6480761 6480886 6481019 6481205 6481336 6481693 6481826 6482648 6482927 6482984 6483248 6483436 6483438 6483540 6483548 6483605 6483622 6483668 6483920 6484005 6484100 6484113 6484126 6484665 6485150 6485238 6485276 6485438 6485473 6485633 6485649 6485776 6485811 6486005 6486055 6486441 6486476 6486509 6486529 6486720 6486725 6486753 6486813 6486854 6486907 6488402 6488472 6488481 6488638 6488651 6488882 6488884 6489036 6489042 6489119 6489169 6489732 6490036 6490289 6490753 6490762 6490777 6490878 6490918 6491244 6491314 6491455 6491462 6491488 6491791 6491899 6491935 6491996 6492038 6492085 6492139 6492253 6492837 6494304 6494348 6494991 6495239 6495318 6495383 6495784 6495959 6496196 6496397 6496642 6496833 6497015 6497075 6497160 6497174 6497175 6497181 6497186 6497192 6497205 6497234 6497255 6497281 6497283 6497357 6497390 6497491 6497512 6497527 6497545 6497603 6497710 6497720 6497768 6497795 6497911 6497950 6498084 6498124 6498282 6498563 6498573 6498644 6498762 6498774 6498841 6498881 6498908 6498912 6498917 6498923 6498924 6498981 6499007 6499175 6499291 6499315 6499459 6499566 6499581 6499669 6499671 6499674 6500361 6500450 6500522 6500563 6500899 6500903 6500929 6501032 6501423 6501439 6501454 6501517 6501569 6501620 6501622 6501707 6501813 6501822 6501837 6501867 6501913 6501948 6501978 6502016 6502031 6502033 6502039 6502042 6502043 6502045 6502264 6502275 6502276 6502352 6502356 6502462 6502523 6502548 6502572 6502680 6502682 6502684 6502741 6502768 6503081 6503096 6503178 6503180 6503778 6503827 6503942 6504006 6504028 6504246 6504251 6505449 6505967 6506061 6506452 6506459 6506964 6507013 6507298 6507472 6507628 6507828 6507835 6507859 6507975 6507979 6508488 6508656 6508763 6508998 6509013 6509105 6509321 6509427 6509593 6509624 6510009 6510145 6510161 6510706 6510716 6510722 6510894 6512074 6512170 6512176 6512517 6512614 6512963 6515151 6515182 6515458 6515649 6515727 6516055 6516113 6516184 6516302 6518286 6519977 6520188 6521208 6521835 6522145 6522863 6523032 6523411 6523971 6524062 6524079 6524127 6524167 6524216 6524234 6524262 6524273 6524298 6524300 6524370 6524382 6524392 6524401 6524402 6524403 6524404 6524408 6524414 6524416 6524517 6524521 6524527 6524589 6524780 6524846 6524958 6524959 6525047 6525222 6525223 6525236 6525247 6525248 6525262 6525397 6525412 6525428 6525454 6525463 6525498 6525504 6525508 6525514 6525623 6525678 6525789 6525808 6525810 6525820 6525985 6526022 6526066 6526171 6526182 6526191 6526210 6526314 6526318 6526336 6526361 6526465 6526488 6526561 6526912 6527116 6527522 6527619 6527701 6528054 6528064 6528103 6528130 6528144 6528162 6528263 6528273 6528282 6528333 6528382 6528492 6528540 6528617 6528622 6528636 6528645 6528651 6528681 6528749 6528774 6528782 6528805 6528859 6528934 6528945 6528952 6528984 6529013 6529054 6529123 6529126 6529197 6529220 6529268 6529288 6529297 6529307 6529309 6529312 6529313 6529318 6529320 6529326 6529360 6529829 6529847 6529856 6529908 6529932 6529969 6529980 6529986 6529993 6530087 6530097 6530102 6530108 6530143 6530149 6530188 6530218 6530266 6530267 6530270 6530271 6530279 6530288 6530313 6530333 6530340 6530351 6530378 6530466 6530467 6530555 6530571 6530860 6530862 6530998 6531381 6532762 6533195 6533240 6533523 6533726 6533962 6534830 6535483 6535563 6535696 6535880 6535897 6536142 6536925 6537048 6537049 6537080 6537104 6537290 6538734 6538736 6538737 6538748 6538750 6538778 6538796 6539030 6539235 6539947 6539969 6542167 6542204 6542713 1000000890 1000000922 1000000978 1000000947 1000001524 1000002093 1000002204 1000002090 1000002549 1000002550 1000002395 1000002589 1000002548 1000002627 6390683 1000003186 1000003913 1000002536 1000001010 1000001713 1000004086 1000001847 1000004292 1000004308 1000004310 1000004384 1000004597 6394579 1000005108 1000003876 1000005292 1000005294 1000005564 1000005852 1000006096 1000006167 1000006595 1000006956 1000006200 1000005688 1000002932 1000003850 1000005695 6393268 1000007604 1000007606 1000007641 1000007030 1000008074 1000001675 1000002077 1000008081 6393281 1000008203 1000008319 1000008322 1000008734 1000008277 1000008866 1000008951 1000008535 1000009061 1000008494 1000005215 1000008586 1000009304 6379629 6386802 6389071 1000009451 1000009452 1000002559 1000002038 1000004324 6389029 1000009636 1000009637 6394501 1000009689 1000009721 1000009923 1000009924 1000009968 1000009593 1000006630 1000007819 1000002150 1000007025 1000006056 6391408 1000009371 1000010285 1000010295 6388978 1000010423 1000010559 1000009615 1000010700 1000010701 1000010705 1000010553 1000010736 1000010753 1000010754 1000005970 1000010760 1000010743 1000010839 1000006071 1000010882 1000010884 1000010973 1000010772 1000008368 1000011004 1000011034 1000009252 1000010703 1000010840 1000008663 1000009062 1000010381 1000010561 1000010520 1000012089 1000012108 1000012180 1000008817 1000012463 6392545 1000012771 1000012772 1000011864 1000009232 1000012164 1000008209 1000013275 1000010313 1000013558 1000012800 1000012768 1000013376 1000011875 1000012796 1000012923 1000014006 1000014113 1000009260 1000014162 1000014165 1000014201 1000013338 6381423 1000014557 1000014849 1000014102 1000010100 1000015109 1000014283 1000014039 1000013953 1000014676 1000012734 1000013511 1000015389 1000010542 1000015412 1000015424 1000012648 1000014368 1000015539 1000015800 1000015575 1000012235 1000015899 1000013526 1000016020 1000015802 1000016164 1000016193 1000016198 1000016251 6378310 1000016448 1000016452 1000016507 1000016545 1000014161 1000017123 1000016711 1000008336 1000009771 1000009779 1000017444 1000007605 1000015730 1000017659 1000017660 1000017674 1000017676 1000017680 1000017689 1000018066 1000018089 1000018090 1000017561 1000018275 1000018454 1000018611 1000018798 1000018886 1000010528 1000019269 1000019365 1000015456 1000019429 1000019439 1000019495 1000019496 1000019497 1000019522 1000019525 1000019572 1000019575 1000019579 1000019826 1000019829 1000019840 1000019841 1000019843 1000019845 1000019865 1000019866 1000012635 1000019983 1000019993 1000020016 1000020022 1000020046 1000020048 1000020057 1000020069 1000020096 1000020097 1000020099 1000020100 1000020110 1000020111 1000020225 1000020226 1000020243 1000020258 1000020292 1000020293 1000020301 1000020303 1000020306 1000020326 1000020327 1000020414 1000020421 1000017139 1000020489 1000011924 1000018889 1000020605 1000020607 1000020608 1000018133 1000020972 1000020973 1000020974 1000020975 1000020976 1000021024 1000021034 1000020422 1000021134 1000021187 1000021193 1000018094 1000016685 1000016529 1000018772 1000013129 1000021631 1000021652 1000021654 1000021723 1000021725 1000021741 1000021742 1000021743 1000019095 1000021869 1000021892 1000021893 1000021909 1000021910 1000021911 1000021912 1000021925 1000021949 1000021962 1000021977 1000021987 1000021988 1000021989 1000022034 1000014111 1000022036 1000002206 1000002102 1000000909 1000022116 1000009633 1000022377 1000022379 1000022438 1000022439 1000022459 1000016428 1000019091 1000022577 1000014686 1000022632 1000022665 1000022666 1000022667 1000022668 1000022677 1000020925 1000008190 1000016551 1000021537 1000019493 1000022940 1000022941 1000022942 1000023453 1000023460 1000023508 1000023512 1000023520 1000023591 1000023593 1000023594 1000023595 1000023605 1000023661 1000023671 1000024100 1000024123 1000024134 1000024143 1000024500 1000024534 1000024544 1000024547 1000024549 1000024624 1000024626 1000024877 1000024878 1000024879 1000024880 1000024881 1000024882 1000024883 1000024884 1000024886 1000024887 1000024889 1000024892 1000024893 1000024894 1000024895 1000024896 1000024999 1000025002 1000025021 1000025022 1000025037 1000025041 1000025042 1000025046 1000025083 1000025108 1000025113 1000025894 1000026016 1000026017 1000026019 1000026021 1000026042 1000026043 1000026080 1000026129 1000026144 1000026150 1000026152 1000016926 1000014791 1000025122 1000009675 1000023405 1000012798 1000014151 1000010233 1000027071 1000027348 1000027523 1000011055 1000013384 1000028030 1000028725 1000024890 1000016632 1000012149 1000017713 1000028960 1000025832 1000028962 1000012763 1000021551 1000022056 1000027051 1000029143 1000029161 1000029162 1000029415 1000029420 1000013224 1000024630 1000029163 1000030055 1000030066 1000024088 1000030624 1000012404 1000012010 1000031508 1000031729 1000031730 1000031731 1000031732 1000031734 1000031737 1000031738 1000031740 1000031741 1000031742 1000031743 1000031744 1000031745 1000031747 1000031749 1000031751 1000031752 1000031757 1000031758 1000031760 1000031766 1000031767 1000031768 1000031770 1000031772 1000031773 1000031775 1000031777 1000031778 1000031779 1000028298 1000021135 1000031811 1000031812 1000031814 1000031815 1000031816 1000031818 1000031819 1000031821 1000031822 1000031823 1000031824 1000031825 1000031826 1000031827 1000031828 1000031829 1000031832 1000031833 1000031834 1000031835 1000031837 1000031838 1000031839 1000031871 1000031872 1000031881 1000031888 1000031932 1000031934 1000011940 1000032053 1000032061 1000032064 1000032067 1000019526 1000032100 1000023685 1000032207 1000019477 1000032252 1000032281 1000032308 1000032309 1000032310 1000032322 1000032323 1000017001 1000032336 1000032370 1000032375 1000032378 1000032443 1000032445 1000032501 1000032512 1000020468 1000032521 1000032546 1000032552 1000032553 1000032555 1000032556 1000032557 1000032558 1000032559 1000025696 1000032646 1000032691 1000032701 1000032752 1000032999 1000033002 1000033004 1000033043 1000033044 1000033048 1000033050 1000033054 1000033071 1000033072 1000033081 1000033092 1000033093 1000033189 1000033212 1000033223 1000033320 1000033342 1000033343 1000033346 1000021035 1000028379 1000030417 1000034043 1000034177 1000034179 1000034181 1000034182 1000034183 1000034184 1000034192 1000034194 1000034195 1000020297 1000023551 1000015196 1000016975 1000023045 1000034521 1000034640 1000012658 1000034814 1000033478 1000035216 1000035499 1000035500 1000016415 1000035844 1000035536 1000036299 1000036378 1000036379 1000036752 1000036754 1000036940 1000036941 1000037217 1000037218 1000037228 1000037230 1000037236 1000037237 1000037329 1000037513 1000037758 1000037759 1000037760 1000037761 1000037764 1000037769 1000037772 1000037781 1000037782 1000037783 1000037784 1000037801 1000037819 1000037820 1000037831 1000037899 1000037904 1000037916 1000037954 1000037996 1000038001 1000038044 1000038191 1000015351 1000038344 1000038760 1000038766 1000038848 1000037358 1000038937 1000038955 1000038956 1000038999 1000039014 1000039016 1000039042 1000039076 1000039214 1000039216 1000039217 1000039218 1000039221 1000039331 1000039367 1000039368 1000039389 1000039437 1000039498 1000039517 1000039518 1000039519 1000039570 1000039582 1000039583 1000039637 1000039645 1000040079 1000040080 1000040081 1000040082 1000040084 1000040088 1000040097 1000040098 1000040100 1000040108 1000040109 1000040129 1000040166 1000040207 1000040229 1000040230 1000040231 1000040233 1000040329 1000040355 1000040356 1000040358 1000040368 1000040408 1000034509 1000040708 1000040880 1000040974 1000039474 1000041112 1000041296 1000041312 1000041328 1000041329 1000041331 1000041476 1000041496 1000041535 1000025165 1000041907 1000042072 1000042073 1000016581 1000042144 1000042145 1000042152 1000042154 1000042157 1000042158 1000042159 1000042342 1000042443 1000042444 1000042464 1000042466 1000042473 1000042475 1000042476 1000042478 1000042479 1000042552 1000042553 1000042554 1000042708 1000019610 1000027525 1000042964 1000042966 1000042969 1000042970 1000042971 1000043392 1000043399 1000043405 1000043565 1000043566 1000037777 1000034646 1000043950 1000043951 1000044037 1000044057 1000044070 1000044075 1000044082 1000024125 1000044361 1000044517 1000032266 1000044675 1000044678 1000044722 1000044766 1000044768 1000044795 1000044803 1000044805 1000042193 1000044829 1000044604 1000044850 1000044851 1000044855 1000044860 1000044862 1000044867 1000044868 1000044873 1000045127 1000045150 1000045191 1000045192 1000045196 1000025687 1000045235 1000045274 1000045275 1000045279 1000045315 1000045415 1000045524 1000045318 1000045681 1000045716 1000045717 1000045798 1000045836 1000045837 1000045900 1000046050 1000046055 1000046056 1000046154 1000046177 1000046182 1000046183 1000046184 1000046185 1000046187 1000046188 1000046189 1000046190 1000046196 1000046198 1000046207 1000046217 1000046327 1000046347 1000046348 1000046349 1000046350 1000046426 1000046427 1000046429 1000046431 1000046432 1000046433 1000046434 1000046435 1000046436 1000046445 1000046446 1000046447 1000046448 1000046450 1000046451 1000046452 1000046453 1000046454 1000046455 1000046456 1000046457 1000046458 1000046459 1000046462 1000046463 1000047168 1000047171 1000047172 1000047174 1000047175 1000047176 1000047191 1000047194 1000047559 1000047561 1000012920 1000033743 1000046954 1000047931 1000023316 1000033049 1000048014 1000048048 1000048032 1000048073 1000048074 1000048080 1000044704 1000048111 1000048112 1000048156 1000047949 1000047196 1000048383 1000048384 1000048346 1000048534 1000047414 1000048514 1000048635 1000048507 1000045353 1000048849 1000048867 1000048339 1000019184 1000048965 1000048970 1000048985 1000048988 1000041536 1000049083 1000049097 1000049147 1000048282 1000049304 1000049308 1000049373 1000049429 1000049434 1000049439 1000049441 1000049445 1000049453 1000049525 1000049533 1000049631 1000049636 1000048445 1000049711 1000049713 1000049748 1000049538 1000049773 1000048966 1000049594 1000049757 1000049819 1000049780 1000049904 1000045197 1000023855 1000048082 1000050056 1000050090 1000050093 1000049656 1000048058 1000047731 1000044906 1000050410 1000050422 1000049763 1000050479 1000050497 1000050245 1000029598 1000050069 1000050771 1000047804 1000050114 1000050897 1000050926 1000050934 1000050962 1000043256 1000050996 1000050157 1000051044 1000051053 1000048517 1000051139 1000048477 1000051217 1000047852 1000051293 1000051294 1000050891 1000051310 1000051311 1000049632 1000044085 1000051422 1000051426 1000051411 1000051440 1000051470 1000051483 1000051496 1000051497 1000051606 1000039254 1000051647 1000049736 1000051678 1000051701 1000051710 1000051739 1000051741 1000048241 1000051761 1000051762 1000009664 1000048886 1000049385 1000051912 1000051942 1000051974 1000049911 1000052042 1000052045 1000049906 1000052102 1000052110 1000052183 1000052208 1000052304 1000051868 1000048167 1000048104 1000052492 1000052511 1000052512 1000052544 1000052513 1000052647 1000052373 1000052797 1000052865 1000049484 1000052187 1000052957 1000052973 1000048244 1000049668 1000053278 1000050387 1000053296 1000053380 1000053423 1000045312 1000053513 1000053670 1000053758 1000050556 1000053885 1000052651 1000053994 1000054027 1000054066 1000054078 1000054090 1000054232 1000054246 1000054248 1000054312 1000039234 1000049192 1000054343 1000054351 1000054404 1000054352 1000051058 1000052637 1000054446 1000054597 1000054677 1000054687 1000054296 1000053020 1000054899 1000053963 1000054931 1000054933 1000054936 1000055004 1000051303 1000053138 1000055216 1000055225 1000054596 1000045295 1000055348 1000050910 1000050171 1000054362 1000050381 1000055620 1000055656 1000054303 1000049984 1000055720 1000054743 1000051939 1000055425 1000055152 1000053448 1000049376 1000056407 1000039722 1000056446 1000056157 1000056720 1000056721 1000056744 1000056845 1000051693 1000052514 1000056955 1000057083 1000023450 1000057151 1000056211 1000053763 1000057177 1000052817 1000025159 1000057732 1000056831 1000058117 1000058118 1000058119 1000058120 1000057689 1000058540 1000050362 1000057127 1000058951 1000059223 1000059407 1000059927 1000054467 1000054849 1000060346 1000060419 1000060456 1000060458 1000060459 1000060511 1000060665 1000060862 1000060863 1000060889 1000060983 1000060984 1000061082 1000061083 1000060963 1000061728 1000060960 1000062448 1000062263 1000062884 1000063159 1000063210 1000063250 1000046203 1000062813 1000063910 1000063915 1000063992 1000064187 1000063333 1000064279 1000014593 87251 ] |
20 | 0.36 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
96803
]
|
21 | 0.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:
[
26728
]
|
22 | 0.16 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
87250
]
|
23 | 0.16 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
65676
]
|
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:
[
80434
]
|
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:
[
167652
]
|
26 | 0.16 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
4906
]
|
27 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
1232
]
|
28 | 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:
[
5483
]
|
29 | 0.14 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
56130
]
|
30 | 0.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.id = ? LIMIT 1
Parameters:
[
1
]
|
31 | 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:
[
1
]
|
32 | 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:
[
16
]
|
33 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
17
]
|
34 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
18
]
|
35 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
19
]
|
36 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
20
]
|
37 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
21
]
|
38 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
22
]
|
39 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
23
]
|
40 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
24
]
|
41 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
25
]
|
42 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
26
]
|
43 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
27
]
|
44 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
28
]
|
45 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
29
]
|
46 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
30
]
|
47 | 0.13 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.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
32
]
|
49 | 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"
]
|
50 | 0.26 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.15 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
52 | 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:
[
"TarifDefaut"
]
|
53 | 0.21 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
54 | 0.33 ms |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 87251 ] |
55 | 0.29 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:
[ 87251 0 ] |
56 | 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:
[ "C" 87251 ] |
57 | 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"
]
|
58 | 0.25 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:
[ 87251 "C" ] |
59 | 0.31 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:
[
87251
]
|
60 | 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"
]
|
61 | 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"
]
|
62 | 0.14 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
63 | 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_.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:
[
87251
]
|
64 | 0.25 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-13 04:26:48" "%2%" 87251 ] |
65 | 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:
[ 87251 7 ] |
66 | 0.27 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:
[
87251
]
|
67 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"TarifDefautBtoB"
]
|
68 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
69 | 0.15 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
70 | 0.31 ms |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 80434 ] |
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:
[ 80434 0 ] |
72 | 0.32 ms |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "C" 80434 ] |
73 | 0.43 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:
[
80434
]
|
74 | 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"
]
|
75 | 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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 80434 "C" ] |
76 | 0.29 ms |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
80434
]
|
77 | 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"
]
|
78 | 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"
]
|
79 | 0.14 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
80 | 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:
[
80434
]
|
81 | 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-13 04:26:48" "%2%" 80434 ] |
82 | 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:
[ 80434 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 | 2295 |
App\Entity\Customer\Customer | 576 |
App\Entity\User\User | 534 |
App\Entity\Delivery\Delivery | 407 |
App\Entity\Catalog\ProductCatalog | 150 |
App\Entity\Catalog\CustomerCatalog | 150 |
App\Entity\Product\Market | 73 |
App\Entity\Pricing\Price | 27 |
App\Entity\Product\ProductPrice | 26 |
App\Entity\Internal\Commercial | 26 |
App\Entity\Product\Product | 21 |
App\Entity\Product\Category | 21 |
App\Entity\Product\Characteristic | 18 |
App\Entity\Product\CharacteristicLabel | 17 |
App\Entity\Internal\Society | 5 |
App\Entity\Delivery\DeliveryCost | 5 |
App\Entity\Internal\Parameter | 3 |