Query Metrics
66
Database Queries
21
Different statements
1796.88 ms
Query time
0
Invalid entities
3069
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 268.57 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:
[
"63042-chemises-carte-et-polypro-violet-hamelin-400-114-349"
]
|
2 | 0.40 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:
[
73073
]
|
3 | 0.56 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:
[
"63042-chemises-carte-et-polypro-violet-hamelin-400-114-349"
]
|
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:
[
"63042-chemises-carte-et-polypro-violet-hamelin-400-114-349"
]
|
5 | 0.43 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:
[ 73073 1 ] |
6 | 0.77 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:
[ 48 230 231 232 233 234 230 231 73073 ] |
7 | 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:
[
300
]
|
8 | 0.18 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
526
]
|
9 | 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:
[
954
]
|
10 | 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:
[
955
]
|
11 | 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:
[
956
]
|
12 | 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:
[
957
]
|
13 | 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:
[
963
]
|
14 | 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:
[
972
]
|
15 | 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:
[
973
]
|
16 | 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:
[
974
]
|
17 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ourClientsAlsoBoughtMonths"
]
|
18 | 607.44 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:
[ 73073 "2025-04-11 18:01:50" ] |
19 | 904.09 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:
[ 6384785 6365270 6385235 6385318 6385055 6386450 6378695 6385013 6387532 6387609 6388145 6389057 6391908 6392207 6394247 6396377 6396378 6396379 6397328 6397709 6398161 6399568 6400116 6400120 6400236 6402073 6403414 6403661 6404296 6405008 6405328 6405331 6405526 6406132 6406604 6408478 6408480 6408699 6410013 6410379 6410895 6410934 6411224 6411490 6411719 6412054 6412171 6412172 6412194 6412215 6413512 6413560 6413585 6413777 6414109 6414292 6415218 6415429 6415482 6415937 6416051 6416152 6416204 6416238 6416241 6416414 6417072 6417091 6417225 6417282 6417539 6420074 6420277 6420480 6420532 6420659 6421437 6421576 6421577 6421597 6421603 6421626 6421667 6421824 6421840 6422007 6414516 6422285 6422664 6422700 6423142 6423244 6425095 6425118 6425436 6425485 6425718 6425793 6426174 6426242 6426388 6426499 6426611 6427162 6427269 6428037 6428246 6428593 6428901 6430302 6430550 6430627 6430784 6431116 6431570 6429488 6432230 6432237 6434797 6434811 6435149 6436641 6437104 6437674 6437701 6438069 6438688 6438737 6439201 6439652 6440367 6440558 6440944 6441127 6441995 6442738 6442800 6442806 6443015 6443123 6443266 6443771 6444593 6445378 6445741 6446091 6446107 6446119 6446128 6446134 6446136 6446167 6446452 6446797 6447280 6447329 6447401 6449769 6449890 6449894 6449905 6450014 6450066 6450225 6450470 6450772 6450819 6451067 6451125 6451129 6451150 6451239 6451243 6451365 6451397 6451439 6451593 6451595 6451597 6451631 6451738 6451863 6451925 6452086 6452099 6452214 6452588 6453132 6453308 6453612 6453964 6454117 6454537 6454625 6455201 6455203 6455238 6455307 6455308 6455375 6455475 6455479 6455520 6455685 6455696 6455721 6455813 6455884 6456629 6457112 6457126 6457243 6457416 6457445 6457803 6458359 6458488 6459388 6460133 6460469 6460470 6461281 6461508 6461738 6462571 6462970 6463095 6463096 6463126 6463129 6463153 6463156 6463419 6463604 6464223 6464379 6465182 6465283 6465286 6465809 6465933 6465935 6466349 6466609 6466672 6466746 6466960 6466964 6467065 6467075 6466331 6467182 6468021 6468024 6468030 6468033 6468038 6468040 6468047 6468049 6468646 6468647 6468680 6468684 6468789 6469170 6469191 6469374 6469376 6469414 6469419 6469557 6469602 6469603 6469654 6469657 6469708 6469714 6469738 6469740 6469746 6469750 6469854 6469855 6469865 6469868 6469889 6469891 6469926 6469932 6470101 6470331 6470791 6470793 6470965 6471242 6471349 6471865 6471869 6472760 6472778 6472862 6473274 6473280 6473529 6474023 6474024 6474025 6474026 6474027 6474028 6474029 6474030 6474031 6474032 6474033 6474034 6474035 6474036 6474037 6474038 6474039 6474040 6474041 6474043 6474044 6474045 6474046 6474047 6474048 6474049 6474050 6474051 6474052 6474053 6474054 6474055 6474057 6474058 6474059 6474060 6474061 6474062 6474063 6474064 6474065 6474066 6474067 6474068 6474069 6474070 6474071 6474072 6474073 6474074 6474075 6474076 6474077 6474078 6474079 6474080 6474081 6474082 6474083 6474084 6474085 6474086 6474088 6474089 6474090 6474091 6474092 6474093 6474094 6474095 6474096 6474097 6474098 6474100 6474101 6474102 6474103 6474104 6474105 6474106 6474107 6474108 6474109 6474110 6474111 6474112 6474113 6474114 6474115 6474116 6474117 6474118 6474119 6474120 6474121 6474122 6474123 6474124 6474125 6474126 6474127 6474128 6474129 6474130 6474131 6474132 6474133 6474134 6474135 6474136 6474137 6474138 6474139 6474140 6474141 6474142 6474143 6474144 6474145 6474146 6474147 6474148 6474149 6474150 6474151 6474152 6474153 6474154 6474155 6474156 6474157 6474158 6474159 6474160 6474161 6474162 6474163 6474164 6474165 6474166 6474167 6474168 6474169 6474170 6474171 6474172 6474173 6474174 6474175 6474176 6474177 6474178 6474179 6474180 6474181 6474182 6474183 6474184 6474185 6474186 6474187 6474188 6474189 6474190 6474191 6474192 6474193 6474194 6474195 6474196 6474197 6474198 6474199 6474201 6474202 6474203 6474204 6474205 6474206 6474207 6474208 6474209 6474210 6474211 6474212 6474213 6474214 6474434 6474521 6475876 6475877 6475878 6475879 6475880 6475881 6475882 6475894 6476138 6476242 6476515 6476516 6476794 6476957 6477654 6479696 6480593 6481204 6482777 6482802 6483613 6483614 6483636 6483637 6483639 6483700 6483863 6483901 6484132 6484134 6484453 6484455 6484543 6484750 6484975 6485266 6485373 6485650 6485694 6485697 6486888 6486890 6486929 6486930 6487116 6487117 6487118 6487119 6487120 6487121 6487122 6487123 6487124 6487125 6487126 6487127 6487128 6487129 6487130 6487131 6487132 6487133 6487134 6487135 6487136 6487137 6487138 6487139 6487885 6488763 6491333 6491335 6491364 6491365 6491877 6491878 6491890 6491891 6492175 6492203 6492306 6493590 6494202 6494480 6494482 6494760 6495085 6495113 6497481 6497516 6497582 6497761 6497905 6497915 6498059 6498150 6498164 6498347 6498501 6498563 6498578 6498624 6498758 6499276 6499283 6499284 6499291 6499323 6499432 6499532 6499738 6500186 6500344 6500615 6501400 6501883 6501969 6501975 6501978 6501985 6501987 6501990 6502122 6502226 6502594 6503158 6503837 6504079 6504112 6504190 6504207 6504216 6504233 6504665 6504848 6504849 6505016 6505407 6505664 6505665 6505667 6505668 6505669 6505670 6505671 6505672 6506788 6506789 6506790 6506791 6506793 6506794 6506795 6506796 6506797 6506798 6506799 6506800 6506801 6506802 6506803 6506804 6506805 6506806 6506807 6506808 6506809 6506811 6506812 6506813 6506814 6507462 6507672 6507674 6507747 6507751 6509387 6509725 6509726 6510495 6510572 6511452 6511453 6511454 6511455 6511456 6511457 6511458 6511459 6511460 6511461 6511462 6511463 6511464 6511465 6511466 6511467 6511468 6511469 6511470 6511471 6511472 6511473 6511474 6511475 6511477 6511478 6511479 6511480 6511481 6511482 6511483 6511484 6511485 6511486 6511487 6511488 6511489 6511490 6511491 6511492 6511493 6511494 6511495 6511496 6511497 6511498 6511499 6511500 6511501 6511502 6511503 6511504 6511505 6511506 6511507 6511508 6511509 6511510 6511511 6511512 6511513 6511514 6511515 6511516 6511517 6511518 6511519 6511520 6511521 6511522 6511523 6511525 6511526 6511527 6511528 6511529 6511531 6511532 6511533 6511534 6511535 6511536 6511537 6511538 6511539 6511540 6511541 6511542 6511543 6511544 6511545 6511546 6511547 6511548 6511549 6511550 6511551 6511552 6511553 6511554 6511555 6511556 6511557 6511558 6511559 6511560 6511561 6511562 6511563 6511564 6511565 6511566 6511567 6511568 6511569 6511570 6511571 6511572 6511573 6511574 6511575 6511576 6511577 6511578 6511579 6511580 6511581 6511582 6511583 6511584 6511585 6511586 6511587 6511588 6511589 6511590 6511591 6511592 6511593 6511594 6511595 6511596 6511597 6511598 6511599 6511600 6511601 6511602 6511603 6511604 6511605 6511606 6511607 6511608 6511609 6511610 6511611 6511612 6511613 6511614 6511615 6511616 6511617 6511618 6511619 6511620 6511621 6511622 6511623 6511624 6511625 6511626 6511627 6511628 6511629 6511630 6511631 6511632 6511633 6511634 6511635 6511636 6511637 6511638 6511639 6511640 6511641 6511642 6512236 6512238 6512956 6512957 6513030 6513033 6513035 6513040 6513041 6515555 6515606 6515608 6515727 6515754 6515755 6515793 6515795 6515821 6515892 6515893 6516030 6516031 6516898 6516924 6516925 6518179 6518183 6518186 6518187 6519256 6519258 6519525 6519527 6522119 6522307 6522599 6523032 6524025 6524038 6524041 6524249 6524251 6525225 6525236 6525308 6526144 6526182 6526324 6526343 6527241 6527301 6527302 6527797 6528456 6528671 6528686 6529859 6530389 6530410 6530530 6530794 6530861 6530998 6532262 6532263 6532264 6532265 6532266 6532267 6532268 6532269 6532270 6532271 6532272 6532273 6532274 6532275 6532276 6532277 6532278 6532279 6532280 6532281 6532282 6532283 6532284 6532285 6532286 6532287 6532288 6532289 6532290 6532291 6532292 6532293 6532294 6532295 6532296 6532297 6532298 6532299 6532300 6532301 6532302 6532303 6532304 6532305 6532306 6532307 6532308 6532309 6532310 6532311 6532312 6532313 6532314 6532315 6532316 6532317 6532318 6532319 6532320 6532321 6532322 6532323 6532324 6532325 6532326 6532327 6532328 6532329 6532330 6532331 6532332 6532333 6532334 6532335 6532336 6532337 6532338 6532339 6532340 6532341 6532342 6532343 6532344 6532345 6532346 6532347 6532348 6532349 6532350 6532351 6532352 6532353 6532354 6532355 6532356 6532357 6532358 6532359 6532360 6532361 6532362 6532363 6532364 6532365 6532366 6532367 6532368 6532369 6532370 6532371 6532372 6532373 6532374 6532375 6532376 6532377 6532378 6532379 6532380 6532381 6532382 6532383 6532384 6532385 6532386 6532387 6532388 6532389 6532390 6532391 6532392 6532393 6532394 6532395 6532396 6532397 6532398 6532399 6532400 6532401 6532402 6532403 6532404 6532405 6532406 6532407 6532408 6532409 6532410 6532411 6532412 6532413 6532414 6532415 6532416 6532417 6532418 6532419 6532420 6532421 6532422 6532423 6532424 6532425 6532426 6532427 6532428 6532429 6532430 6532431 6532432 6532433 6532434 6532435 6532436 6532437 6532438 6532439 6532440 6532441 6532442 6532443 6532444 6532445 6532446 6532447 6532448 6532449 6532942 6534270 6534271 6535724 6536531 6537219 6537867 6538166 6538834 6539825 6539853 6541541 6541660 1000001759 1000002292 1000000883 1000004041 1000004163 1000004653 1000004165 1000005030 1000005936 1000006160 1000006175 1000006176 1000006231 1000002476 1000007032 1000006065 1000007401 1000008035 1000002916 1000002654 1000007773 1000008316 1000008317 1000008318 1000008513 1000008330 1000007297 1000002507 1000002616 1000004219 1000009045 1000007034 6379629 1000009752 1000009853 1000009854 1000009138 1000010422 1000010700 1000010701 1000011841 1000011931 1000010703 1000010209 1000012221 1000012779 1000012782 1000012824 1000012781 1000012505 1000013454 1000009260 1000014347 1000012179 1000013648 1000012704 1000013904 1000015253 1000009209 1000015389 1000010013 1000015619 1000015327 1000002600 1000016053 1000016507 1000014161 1000012570 1000016711 1000017318 1000012942 1000010949 1000018066 1000018089 1000018090 1000012871 1000019019 1000019020 1000019021 1000019023 1000019024 1000019025 1000012578 1000011980 1000019762 1000019763 1000019764 1000019765 1000019766 1000019767 1000019769 1000019770 1000019771 1000019772 1000019773 1000019774 1000019775 1000019776 1000019777 1000019778 1000019780 1000019781 1000019815 1000019817 1000019818 1000019819 1000019820 1000020121 1000020127 1000013163 1000019664 1000018094 1000016685 1000016529 1000015830 1000019596 1000002046 1000000909 1000022479 1000016161 1000023234 1000025288 1000026399 1000026400 1000026441 6385936 1000026401 1000026577 1000026578 1000022523 1000013439 1000026842 1000027905 1000012775 1000028030 1000016054 1000027977 1000031332 1000031361 1000031365 1000031366 1000031377 1000031378 1000031379 1000031381 1000031382 1000031383 1000031385 1000031392 1000031428 1000031467 1000031468 1000031472 1000031475 1000031476 1000031477 1000031478 1000031480 1000031502 1000031504 1000031506 1000031509 1000031526 1000031531 1000031532 1000031533 1000031546 1000031553 1000031558 1000031566 1000031567 1000031583 1000031585 1000031591 1000032111 1000032492 1000032505 1000032509 1000032516 1000028620 1000023235 1000033191 1000033193 1000033198 1000030059 1000021444 1000034135 1000034293 1000018119 1000034693 1000034694 1000034697 1000034826 1000035652 1000035653 1000035654 1000035655 1000035656 1000035657 1000035658 1000036396 1000019046 1000038408 1000038434 1000038442 1000038446 1000037713 1000039179 1000039210 1000039421 1000039423 1000039469 1000039482 1000039492 1000039494 1000039495 1000015361 1000040368 1000041426 1000041456 1000041427 1000042078 1000042088 1000042090 1000042091 1000042557 1000043245 1000043246 1000043259 1000043262 1000043264 1000043265 1000043334 1000043336 1000043349 1000043350 1000043351 1000043352 1000043355 1000043356 1000043358 1000043359 1000043363 1000043365 1000043366 1000043367 1000043373 1000043374 1000043375 1000043376 1000043390 1000043394 1000043395 1000043396 1000043400 1000043408 1000043416 1000043417 1000043418 1000043419 1000043420 1000043424 1000043426 1000043427 1000043428 1000043429 1000043432 1000043434 1000043436 1000043437 1000043438 1000043440 1000043441 1000043443 1000043444 1000043474 1000043475 1000043476 1000043477 1000043478 1000043479 1000043480 1000043481 1000043482 1000043483 1000043484 1000043485 1000043486 1000043487 1000043488 1000043489 1000043490 1000043492 1000043493 1000043494 1000043495 1000043496 1000043497 1000043498 1000043499 1000043500 1000043501 1000043502 1000043503 1000043504 1000043505 1000043506 1000043507 1000043508 1000043509 1000043510 1000043511 1000043512 1000043513 1000043514 1000043515 1000043516 1000043517 1000043518 1000043519 1000043520 1000043521 1000043522 1000043529 1000043530 1000043531 1000043532 1000043533 1000043534 1000026590 1000045731 1000045732 1000045733 1000045734 1000045735 1000045736 1000045737 1000045738 1000045739 1000045740 1000045741 1000045742 1000045743 1000045744 1000045745 1000045746 1000045748 1000045749 1000045750 1000045751 1000045752 1000045753 1000045754 1000045755 1000045756 1000045757 1000045758 1000045759 1000045760 1000045761 1000045762 1000045763 1000046049 1000046304 1000046331 1000046356 1000046367 1000046368 1000046384 1000040964 1000046660 1000046674 1000042387 1000028015 1000047856 1000047785 1000048006 1000048022 1000048038 1000048047 1000048050 1000048051 1000048052 1000048343 1000048358 1000048512 1000034711 1000043637 1000048829 1000043346 1000049023 1000029437 6332748 1000049399 1000026844 1000049794 1000049584 1000048299 1000050182 1000050242 1000050390 1000050391 1000050203 1000050589 1000029598 1000015302 1000050866 1000050869 1000050308 1000051038 1000051040 1000051042 1000035896 1000050807 1000050609 1000051661 1000051799 1000051873 1000016856 1000052085 1000052736 1000039993 1000053010 1000052564 1000053250 1000053497 1000053502 1000052248 1000049501 1000052844 1000050240 1000054253 1000054254 1000051617 1000054588 1000054592 1000054863 1000054932 1000055060 1000055061 1000055062 1000055063 1000055064 1000055067 1000055069 1000055666 1000055710 1000055834 1000054703 1000014210 1000056028 1000056080 1000056081 1000055804 1000056460 1000056554 1000056553 1000056595 1000056647 1000056799 1000056800 1000056801 1000056819 1000056820 1000056821 1000057170 1000057203 1000057206 1000057355 1000057356 1000057840 1000048035 1000057956 1000057709 1000056125 1000056702 1000058763 1000059012 1000059058 1000059385 1000059737 1000059738 1000059739 1000059742 1000059746 1000059747 1000059748 1000059856 1000059862 1000058762 1000060043 1000060048 1000060275 1000060356 1000060991 1000061008 1000061009 1000061010 1000061103 1000061138 1000061140 1000061141 1000061142 1000061191 1000061222 1000061328 1000061636 1000061637 1000061638 1000061922 1000062691 1000013158 1000062704 1000063073 1000064149 6378941 1000052062 1000065270 1000064122 1000065443 73073 ] |
20 | 0.39 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
152709
]
|
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:
[
9864
]
|
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:
[
991
]
|
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:
[
4906
]
|
24 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
348746
]
|
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:
[
28307
]
|
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:
[
1905
]
|
27 | 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:
[
9450
]
|
28 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
81114
]
|
29 | 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:
[
81113
]
|
30 | 0.40 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.27 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.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
17
]
|
34 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
18
]
|
35 | 0.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:
[
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.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:
[
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.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:
[
27
]
|
44 | 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:
[
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.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:
[
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.30 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
73073
]
|
50 | 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"
]
|
51 | 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"
]
|
52 | 0.16 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
53 | 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"
]
|
54 | 0.14 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
55 | 1.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:
[ "CAISSE2011" 81114 ] |
56 | 1.63 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:
[ 81114 0 ] |
57 | 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:
[ "C" 81114 ] |
58 | 0.22 ms |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
81114
]
|
59 | 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"
]
|
60 | 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:
[ 81114 "C" ] |
61 | 0.36 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:
[ 81114 9963429 ] |
62 | 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"
]
|
63 | 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"
]
|
64 | 0.15 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
65 | 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:
[
81114
]
|
66 | 0.28 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-11 18:01:52" "%2%" 81114 ] |
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 | 1647 |
App\Entity\Catalog\ProductCatalog | 273 |
App\Entity\Catalog\CustomerCatalog | 273 |
App\Entity\Customer\Customer | 213 |
App\Entity\User\User | 198 |
App\Entity\Delivery\Delivery | 166 |
App\Entity\Product\Market | 67 |
App\Entity\Pricing\Price | 52 |
App\Entity\Product\ProductPrice | 51 |
App\Entity\Internal\Commercial | 42 |
App\Entity\Product\Product | 22 |
App\Entity\Product\Category | 22 |
App\Entity\Product\Characteristic | 15 |
App\Entity\Product\CharacteristicLabel | 14 |
App\Entity\Delivery\DeliveryCost | 6 |
App\Entity\Internal\Society | 5 |
App\Entity\Internal\Parameter | 3 |