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