Query Metrics
48
Database Queries
12
Different statements
3035.67 ms
Query time
0
Invalid entities
4380
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 75.82 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:
[
"60175-gommes-couleur-maped-011300"
]
|
2 | 0.47 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:
[
67044
]
|
3 | 0.62 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:
[
"60175-gommes-couleur-maped-011300"
]
|
4 | 0.47 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:
[
"60175-gommes-couleur-maped-011300"
]
|
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:
[ 67044 1 ] |
6 | 0.72 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:
[ 57 270 271 272 273 274 273 67044 ] |
7 | 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:
[
256
]
|
8 | 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:
[
623
]
|
9 | 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:
[
840
]
|
10 | 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:
[
5496
]
|
11 | 0.14 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
5511
]
|
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:
[
5512
]
|
13 | 0.13 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
6668
]
|
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:
[
9613
]
|
15 | 0.13 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
10481
]
|
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:
[
26552
]
|
17 | 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:
[
"ourClientsAlsoBoughtMonths"
]
|
18 | 1288.73 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:
[ 67044 "2025-04-12 15:07:37" ] |
19 | 1661.66 ms |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[ 6383988 6385402 6385461 6385586 6383017 6387194 6387676 6388071 6388581 6388843 6390447 6390511 6387057 6390101 6368973 6391813 6391353 6365356 6392015 6392033 6391112 6392298 6392341 6389066 6392489 6387947 6390807 6392929 6386793 6393100 6387606 6393455 6393511 6393669 6393909 6393944 6393149 6392714 6394067 6394106 6394118 6394161 6394029 6394334 6365392 6392965 6395379 6395439 6395893 6396337 6396403 6397427 6398143 6398611 6398665 6398672 6398692 6399792 6400425 6400726 6400802 6402015 6402039 6402585 6402664 6402680 6403303 6403337 6404344 6405292 6405437 6405988 6406012 6407157 6407377 6407529 6408350 6408369 6408793 6408812 6408861 6409166 6409304 6409666 6410416 6410673 6410744 6410950 6410954 6411858 6411859 6412010 6412087 6412385 6412554 6412635 6412823 6412907 6413024 6413319 6413342 6413574 6413624 6413840 6413876 6413892 6414247 6414256 6414277 6414307 6414999 6415072 6415508 6416038 6416114 6416117 6416122 6416216 6416257 6416292 6416400 6416476 6416778 6416781 6416805 6416832 6416836 6416850 6416958 6417023 6417514 6417534 6417585 6418204 6418243 6418395 6418458 6418935 6418942 6419098 6419281 6419301 6419306 6419317 6419362 6419367 6419391 6419392 6419393 6419547 6419553 6419559 6419565 6419572 6420858 6420991 6421109 6421469 6421650 6421693 6421707 6422045 6422233 6422386 6422650 6422664 6422850 6423110 6423164 6423687 6423967 6423983 6424028 6424033 6424350 6424362 6424668 6424679 6424714 6424773 6424924 6424964 6425083 6425122 6425270 6425443 6426221 6426304 6426373 6426430 6426492 6426515 6426535 6426980 6427159 6427164 6427228 6427290 6427329 6427485 6428019 6428263 6428315 6428427 6428590 6428638 6428778 6428986 6429358 6429646 6430017 6430298 6430579 6430808 6430845 6430906 6431289 6431514 6431543 6431572 6431753 6431864 6431906 6431926 6431976 6432090 6432195 6432220 6432279 6432280 6432301 6432339 6433779 6433904 6433934 6434001 6434288 6434372 6434484 6434548 6434662 6434694 6434703 6434757 6434792 6434973 6435149 6435301 6435323 6435405 6435429 6435567 6435596 6435692 6435776 6435777 6435833 6435897 6435917 6435936 6436236 6436344 6436532 6436802 6437198 6437581 6437986 6438026 6438539 6438583 6438667 6438688 6438831 6438835 6438854 6438931 6438974 6439018 6439171 6439262 6439471 6439628 6439754 6439768 6439939 6439979 6440121 6440363 6440877 6440934 6441142 6441180 6441207 6441709 6442111 6442862 6443245 6443310 6443380 6443402 6443421 6443537 6443566 6443624 6443912 6444255 6444274 6444345 6444490 6444641 6444758 6444783 6445042 6445255 6445427 6445604 6445745 6445891 6446186 6446451 6446612 6446739 6446922 6446944 6447011 6447256 6447320 6447369 6447401 6447438 6447460 6447474 6447497 6447517 6447552 6447645 6447674 6447787 6448246 6448682 6448776 6448829 6448889 6448956 6449010 6449059 6449332 6449414 6449525 6449641 6449642 6449643 6449673 6449704 6449726 6449729 6449886 6450103 6450186 6450192 6450193 6450195 6450199 6450283 6450429 6450497 6450505 6450547 6450556 6450592 6450625 6450632 6450654 6450745 6450758 6450769 6450791 6450876 6450881 6450932 6450959 6451015 6451074 6451100 6451101 6451134 6451204 6451210 6451252 6451318 6451340 6451342 6451346 6451361 6451367 6451371 6451374 6451418 6451439 6451496 6451512 6451563 6451564 6451590 6451619 6451649 6451701 6451707 6451803 6452529 6452534 6452543 6452554 6453132 6453146 6453319 6453471 6453517 6453573 6453659 6453732 6454015 6454040 6454127 6454189 6454206 6454543 6454553 6454625 6454657 6454758 6454852 6454855 6454865 6454891 6454949 6454982 6454985 6454989 6455020 6455073 6455119 6455192 6455320 6455371 6455490 6455507 6455513 6455528 6455532 6455561 6455566 6455616 6455620 6455694 6455695 6455696 6455698 6455714 6455754 6455806 6455825 6455838 6455871 6455884 6455914 6456021 6456099 6456106 6456108 6456117 6456118 6456256 6456269 6456480 6456976 6456983 6456984 6456995 6457209 6457241 6457245 6457257 6457262 6457263 6457266 6457645 6457646 6457648 6457649 6457684 6457710 6457720 6458246 6458876 6459486 6459642 6460216 6460429 6460612 6460922 6461143 6461305 6461319 6461466 6461645 6461738 6461828 6461852 6462489 6462654 6462893 6462917 6462954 6462968 6462973 6463173 6463181 6463444 6463529 6464223 6464294 6464295 6464302 6464498 6464501 6464512 6464604 6464687 6464955 6465294 6465906 6466622 6466739 6467003 6467021 6467161 6467176 6468593 6468748 6468927 6469059 6469210 6469225 6469262 6469371 6469420 6469717 6470001 6470228 6470329 6470405 6470507 6470518 6470535 6470792 6470999 6471037 6471272 6471305 6471507 6471985 6472234 6472312 6472463 6472801 6472943 6472960 6473046 6473106 6473208 6473241 6473249 6474437 6474634 6474791 6474845 6474879 6475551 6475554 6475559 6475562 6475567 6475657 6476400 6476511 6476598 6476615 6476957 6477078 6477187 6477544 6477667 6477814 6477854 6477898 6478114 6478138 6478158 6478878 6480416 6480468 6480522 6480538 6480626 6480738 6480799 6480881 6481029 6481168 6481196 6481288 6481404 6481411 6481700 6481731 6481826 6481848 6482253 6482443 6482510 6482941 6482962 6483156 6483862 6483989 6484138 6484779 6484995 6485009 6485134 6485212 6485276 6485296 6485431 6485438 6485441 6485455 6485505 6485520 6485650 6485702 6485888 6485996 6486147 6486457 6486531 6486720 6486722 6486783 6486793 6488370 6488451 6488658 6488952 6489090 6489099 6490013 6490015 6490020 6490042 6490072 6490075 6490144 6490202 6490729 6490766 6491015 6491061 6491152 6491488 6491496 6491791 6491837 6491961 6491973 6492073 6492122 6492144 6492174 6492192 6492256 6492263 6493093 6493149 6493847 6494208 6494245 6494295 6494325 6494327 6494548 6494706 6494750 6494762 6494793 6494797 6494881 6494891 6494995 6495682 6496180 6496244 6496269 6496404 6496413 6496425 6496477 6496519 6496602 6496630 6496736 6496740 6497099 6497117 6497202 6497208 6497227 6497350 6497357 6497427 6497487 6497608 6497629 6497699 6497705 6497761 6497774 6497786 6497839 6497906 6498059 6498083 6498116 6498128 6498129 6498132 6498140 6498156 6498177 6498197 6498236 6498257 6498280 6498309 6498494 6498841 6499163 6499237 6499266 6499268 6499284 6499328 6499333 6499383 6499387 6499457 6499464 6499479 6499504 6499518 6499570 6499571 6499590 6499622 6499632 6500085 6500214 6500351 6500553 6500682 6500866 6501408 6501409 6501411 6501445 6501446 6501517 6501530 6501552 6501569 6501592 6501606 6501769 6501846 6501852 6501861 6501865 6501880 6501888 6501905 6501907 6501927 6501990 6502006 6502008 6502175 6502187 6502201 6502230 6502231 6502234 6502235 6502236 6502237 6502262 6502264 6502282 6502332 6502339 6502378 6502451 6502470 6502490 6502503 6502522 6502526 6502539 6502576 6502594 6502611 6502635 6502722 6502784 6502838 6502841 6502842 6502853 6503183 6503323 6503365 6503447 6503766 6503770 6503999 6504249 6504252 6504268 6504331 6504716 6505403 6505421 6505431 6505471 6505550 6506257 6506409 6506582 6506746 6507137 6507139 6507204 6507314 6507679 6507923 6508581 6508615 6508807 6508892 6508968 6509366 6509397 6509465 6509618 6510310 6510501 6510520 6510667 6510783 6510818 6510894 6512075 6512172 6512360 6512468 6512586 6512615 6512945 6513055 6513123 6515783 6516086 6516184 6516552 6517517 6519509 6519744 6520218 6520878 6521708 6521762 6521875 6521934 6522121 6522234 6523252 6523974 6523979 6524098 6524146 6524149 6524191 6524268 6524317 6524337 6524364 6524370 6524381 6524407 6524468 6524481 6524533 6524589 6524621 6524862 6524944 6525047 6525124 6525225 6525253 6525308 6525311 6525355 6525369 6525441 6525446 6525454 6525456 6525458 6525462 6525505 6525507 6525619 6525639 6525686 6525712 6525723 6525728 6525775 6525788 6526213 6526295 6526297 6526318 6526347 6526353 6526438 6526488 6526489 6526521 6526563 6526924 6527116 6527118 6527128 6527131 6527394 6527633 6527714 6527782 6527895 6528078 6528132 6528144 6528304 6528333 6528359 6528364 6528410 6528449 6528476 6528489 6528573 6528575 6528577 6528579 6528590 6528595 6528642 6528713 6528730 6528739 6528754 6528768 6528770 6528774 6528782 6528798 6528801 6528853 6528945 6528952 6528999 6529047 6529056 6529373 6529388 6529415 6529753 6529842 6529847 6529852 6529856 6529868 6529908 6529941 6529943 6529980 6529987 6529989 6529993 6530005 6530028 6530029 6530030 6530038 6530047 6530056 6530067 6530080 6530102 6530109 6530114 6530143 6530169 6530184 6530221 6530228 6530263 6530269 6530279 6530288 6530322 6530342 6530348 6530359 6530429 6530450 6530454 6530455 6530456 6530459 6530536 6530611 6530757 6531367 6532650 6532654 6532782 6532863 6532868 6532920 6533136 6533149 6533195 6533199 6533205 6533223 6533469 6533581 6533835 6538100 6538778 6538787 6539488 6539855 6539860 6539893 6539895 6539947 6539975 6540152 6540158 1000000765 6392423 1000000907 1000000952 1000000900 1000000947 1000001723 1000001761 1000002184 1000002376 1000002589 1000002639 1000002731 6390683 1000003065 6390075 6360112 1000000876 1000004617 1000004681 1000004683 6392733 1000004770 1000005277 1000005564 6387515 1000005942 1000006030 1000006053 1000006067 1000006298 1000006615 1000005549 1000006718 1000006837 1000006839 1000001302 1000005688 1000007244 1000007261 1000007262 1000006116 1000001639 1000008383 1000008397 1000008277 1000008786 1000006838 1000008866 1000004815 1000008922 1000001939 1000004822 1000006984 1000008398 1000006610 1000009627 1000009689 1000009758 1000009878 1000009893 1000009630 1000009968 1000008114 1000010361 1000003424 1000009904 1000010947 1000010524 1000011090 1000011091 1000009265 1000010148 1000012238 1000012425 1000012450 1000008559 1000012585 1000005290 1000012693 1000012701 1000012823 1000012824 1000012861 1000012915 1000012958 1000012985 1000013094 1000013100 1000013102 1000008008 1000012172 1000013216 1000006579 1000013427 1000013558 1000012502 1000010622 1000008519 1000013714 1000013860 1000012796 1000012456 1000012382 1000012989 1000013142 1000007405 1000014691 1000014700 1000014702 1000014710 1000014685 1000014928 1000005221 1000014007 1000012807 1000012174 1000012222 1000011070 1000012983 1000015448 1000015506 1000015654 1000005038 1000015745 1000015968 1000012987 1000016437 1000016510 1000016586 1000016097 1000013128 1000017030 1000017031 1000017032 1000017123 1000016711 1000016791 1000012596 1000015508 1000017579 1000017587 1000017659 1000017660 1000017680 1000017682 1000017685 1000017689 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017776 1000017778 1000017806 1000017847 1000018345 1000015871 1000018503 1000018506 1000018661 1000018803 1000018835 1000018882 1000018883 1000018906 1000018911 1000018920 1000018926 1000018927 1000018937 1000018997 1000019000 1000019083 1000019100 1000019104 1000019109 1000019110 1000019111 1000019164 1000019168 1000019136 1000019211 1000019259 1000019300 1000019326 1000019332 1000019576 1000019580 1000019591 1000013461 1000019762 1000019763 1000019764 1000019765 1000019766 1000019767 1000019769 1000019770 1000019771 1000019772 1000019773 1000019774 1000019775 1000019776 1000019777 1000019778 1000019780 1000019781 1000019782 1000019966 1000019974 1000019995 1000020130 1000020131 1000020132 1000020191 1000020202 1000020205 1000020206 1000020207 1000020214 1000020215 1000020244 1000020252 1000017170 1000020262 1000020277 1000020280 1000020344 1000020333 1000020002 1000020472 1000011924 6378747 1000020852 1000020861 1000020873 1000020892 1000007024 1000020960 1000020964 1000020967 1000020968 1000020969 1000020980 1000020981 1000014712 1000011023 1000020984 1000013051 1000021091 1000021093 1000021094 1000021095 1000021097 1000021098 1000021120 1000021130 1000020188 1000015249 1000021295 1000021566 1000021772 1000021774 1000021775 1000021777 1000021779 1000021781 1000021782 1000021783 1000021790 1000021791 1000021792 1000021796 1000021797 1000021798 1000021799 1000021802 1000021820 1000021822 1000021823 1000021842 1000022123 1000022162 1000022191 1000012938 1000022578 1000022580 1000021699 1000022270 1000015033 1000018674 1000019651 1000014891 1000022995 1000022997 1000023008 1000015535 1000023568 1000023667 1000023682 1000023683 1000023687 1000024100 1000024123 1000024143 1000024534 1000021132 1000024606 1000024724 1000024725 1000024726 1000024885 1000025038 1000016767 1000025836 1000025841 1000025843 1000025846 1000025856 1000026084 1000026107 1000026312 1000026316 1000026399 1000026400 1000026408 1000026409 1000026410 1000026411 1000026412 1000026413 1000026414 1000026415 1000026416 1000009869 1000012507 1000014791 1000026487 1000026488 1000026489 1000012967 1000026491 1000026492 1000026493 1000026401 1000026575 1000026608 1000023752 1000012916 1000010252 1000012504 1000010233 1000026902 1000022192 1000026995 1000023363 1000021294 1000027436 1000012560 1000028306 1000028310 1000028311 1000028313 1000028314 1000028316 1000028320 1000028331 1000028332 1000028333 1000028334 1000028337 1000028338 1000028342 1000028344 1000028345 1000028350 1000028351 1000028354 1000028361 1000028363 1000028364 1000028369 1000028613 1000028614 1000028626 1000024766 1000028706 1000028707 1000028709 1000028757 1000028758 1000028759 1000028760 1000028761 1000028763 1000028764 1000028766 1000028767 1000028770 1000028771 1000028772 1000028774 1000028621 1000028869 1000028870 1000024727 1000014032 1000028871 1000027051 1000029322 1000008590 1000029634 1000025623 1000026083 1000017889 1000029898 1000030044 1000030201 1000030217 1000024088 1000030467 1000030485 1000030486 1000030487 1000030701 1000030740 1000030741 1000030742 1000030745 1000030746 1000030749 1000030750 1000030752 1000030753 1000030756 1000030758 1000030759 1000005981 1000031332 1000031361 1000031365 1000031366 1000012010 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 1000031658 1000030047 1000031698 1000031700 1000031729 1000031730 1000031731 1000031732 1000031734 1000031737 1000031738 1000031740 1000031741 1000031742 1000031743 1000031849 1000031902 1000031918 1000031919 1000031924 1000031952 1000031955 1000031966 1000031967 1000019337 1000013699 1000032035 1000032052 1000032085 1000032206 1000032279 1000032284 1000032356 1000032344 1000032399 1000032403 1000032410 1000032413 1000032420 1000032432 1000032437 1000027896 1000032687 1000032693 1000032695 1000032719 1000032758 1000024965 1000032799 1000032803 1000026624 1000033016 1000033018 1000033028 1000033029 1000033052 1000033065 1000033066 1000033067 1000033082 1000033083 1000033084 1000033085 1000033087 1000033088 1000033445 1000033450 1000033451 1000033452 1000033479 1000033480 1000033481 1000033484 1000033487 1000021860 1000033490 1000033502 1000033607 1000032055 1000013644 1000033984 1000034040 1000034042 1000029885 1000034135 1000028703 1000034150 1000034156 1000034157 1000034166 1000034167 1000019123 1000027406 1000034168 1000025885 1000034052 1000034152 1000032524 1000026794 1000016300 1000017966 1000017147 1000032483 1000035234 1000035236 1000035238 1000035240 1000035242 1000035244 1000035275 1000035276 1000035277 1000033522 1000030602 1000002590 1000035542 1000035543 1000035544 1000035546 1000035583 1000035584 1000035707 1000036197 1000036198 1000010372 1000034234 1000036390 1000036482 1000036515 1000036518 1000036525 1000036526 1000036528 1000036533 1000036534 1000036535 1000036539 1000036541 1000028710 1000031784 1000036690 1000036902 1000036907 1000036908 1000036909 1000036925 1000036930 1000036964 1000037319 1000037320 1000037322 1000037333 1000037403 1000037407 1000037436 1000037502 1000037560 1000037561 1000037562 1000037563 1000037564 1000037565 1000037566 1000037568 1000037575 1000037594 1000037595 1000037596 1000037597 1000037598 1000037599 1000037600 1000037601 1000037725 1000037738 1000037744 1000037745 1000037785 1000037793 1000037803 1000037804 1000038153 1000016968 1000038625 1000038633 1000038634 1000038635 1000038636 1000038637 1000038638 1000022807 1000038768 1000038771 1000038772 1000038774 1000038775 1000038778 1000038779 1000038780 1000038856 1000038874 1000038876 1000038877 1000038880 1000038882 1000038885 1000038886 1000038887 1000038889 1000038891 1000038892 1000038903 1000038909 1000037358 1000038932 1000038933 1000038939 1000038940 1000038941 1000038945 1000038957 1000038958 1000038963 1000038996 1000039003 1000039018 1000039028 1000039066 1000039067 1000039098 1000039286 1000039451 1000039452 1000039558 1000039573 1000039579 1000039621 1000039659 1000039660 1000039845 1000039847 1000039849 1000040091 1000040092 1000040232 1000040243 1000040188 1000040354 1000040365 1000040366 1000040383 1000040384 1000040928 1000040932 1000041002 1000041005 1000041513 1000041514 1000017964 1000035245 1000037933 1000032858 1000041733 1000041767 1000041769 1000041770 1000041771 1000041772 1000041793 1000041841 1000041842 1000042246 1000042421 1000042674 1000042686 1000042896 1000022803 1000043200 1000043201 1000043222 1000043225 1000043227 1000016271 1000014960 1000043292 1000043445 1000043446 1000043447 1000043448 1000043449 1000043648 1000043669 1000043671 1000043672 1000043679 1000043681 1000043705 1000043758 1000039610 1000043853 1000022214 1000043906 1000043908 1000043922 1000042936 1000044090 1000044091 1000044098 1000044105 1000044154 1000044162 1000044165 1000044337 1000044346 1000044347 1000044363 1000044365 1000044367 1000044387 1000044388 1000044395 1000044467 1000044470 1000044471 1000044473 1000044474 1000044484 1000044488 1000044528 1000044537 1000044576 1000044578 1000044585 1000044598 1000044608 1000044610 1000044682 1000044718 1000044736 1000028844 1000044769 1000044770 1000044771 1000044827 1000044833 1000044845 1000044914 1000044973 1000044981 1000044989 1000045028 1000045150 1000045196 1000045274 1000045275 1000045315 1000031927 1000045414 1000045503 1000045504 1000045505 1000045506 1000045508 1000045512 1000045513 1000045515 1000045516 1000045517 1000045518 1000045519 1000045318 1000045655 1000045665 1000045666 1000045668 1000045683 1000045684 1000045711 1000045840 1000046059 1000032721 1000036227 1000046291 1000046340 1000046391 1000046411 1000046521 1000046522 1000046817 1000046822 1000046826 1000046828 1000046831 1000046833 1000046845 1000046846 1000046848 1000046852 1000043907 1000047025 1000047217 1000047218 1000047219 1000047220 1000047221 1000047225 1000047237 1000047243 1000047248 1000047291 1000047298 1000047341 1000047357 1000047361 1000047569 1000047572 1000047332 1000016703 1000047798 1000047828 1000047863 1000047864 1000047886 1000047941 1000048001 1000030568 1000019240 1000048038 1000048050 1000048051 1000048052 1000044630 1000048100 1000048186 1000048152 1000044284 1000045288 1000048272 1000047211 1000048361 1000048363 1000048383 1000048384 1000019114 1000047933 1000048471 1000042944 1000048722 1000048727 1000048738 1000048508 1000048849 1000041804 1000048357 1000015244 1000040093 1000049015 1000049032 1000048362 1000049217 1000001548 1000049276 1000049129 1000048208 1000009578 1000049470 1000049474 1000049478 1000031997 1000049587 1000049588 1000049634 1000049680 1000049681 1000049682 1000049683 1000049497 1000045108 1000049811 1000049875 1000049901 1000049916 1000048076 1000045197 1000050024 1000050040 1000050137 1000050158 1000050175 1000049951 1000042943 1000027404 1000048927 1000050336 1000050339 1000050380 1000050410 1000050488 1000050544 1000049679 1000050654 1000049211 1000049465 1000050814 1000050695 1000050938 1000050945 1000048190 1000050990 1000050993 1000048960 1000051015 1000051018 1000051039 1000051043 1000051046 1000051049 1000051059 1000051064 1000049106 1000051105 1000051168 1000051257 1000049131 1000050515 1000051338 1000050964 1000051383 1000049599 1000051369 1000051527 1000051607 1000051630 1000051631 1000051659 1000051663 1000050959 1000051697 1000051698 1000051734 1000051737 1000051781 1000051801 1000051847 1000013023 1000051853 1000051065 1000012694 1000051912 1000051942 1000051911 1000052050 1000014080 1000052304 1000052461 1000052467 1000022359 1000051353 1000052547 1000052576 1000052577 1000052579 1000052072 1000052632 1000052232 1000050975 1000052652 1000052737 1000052044 1000052820 1000052821 1000052822 1000010492 1000052887 1000052030 1000052486 1000052581 1000052959 1000052965 1000052966 1000051753 1000053037 1000052628 1000053117 1000053119 1000053187 1000051850 1000053286 1000050207 1000053380 1000053450 1000053514 1000053515 1000053527 1000053561 1000053580 1000053583 1000052248 1000053597 1000051263 1000053621 1000053630 1000053642 1000053397 1000052263 1000050364 1000050346 1000053814 1000053818 1000053645 1000053824 1000049026 1000052334 1000053819 1000053976 1000053981 1000054031 1000054034 1000036747 1000054046 1000054048 1000054087 1000054090 1000054188 1000054286 1000054321 1000054339 1000053463 1000054341 1000054601 1000054037 1000054626 1000054865 1000049641 1000055101 1000054335 1000033571 1000055319 1000015437 1000055324 1000055325 1000055357 1000055407 1000055408 1000047364 1000055508 1000054506 1000055620 1000054631 1000055679 1000055785 1000015107 1000055869 1000055877 1000054070 1000055905 1000053685 1000055804 1000010727 1000056415 1000056446 1000056610 1000056653 1000030125 1000056792 1000056867 1000056429 1000057142 1000057165 1000057167 1000056699 1000053763 1000057212 1000057375 1000057384 1000056790 1000032828 1000057732 1000057770 1000057907 1000056598 1000048035 1000057974 1000057808 1000058093 1000054354 1000058611 1000033242 1000058748 1000058860 1000058912 1000059404 1000059405 1000059479 1000059768 1000058384 1000055516 1000059859 1000058116 1000060070 1000060180 1000014504 1000060227 1000060311 1000060328 1000060423 1000060425 1000059020 1000060853 1000061049 1000061368 1000061511 1000061569 1000061745 1000061945 1000061933 1000061037 1000061925 1000061048 1000062234 1000063068 1000063304 1000063305 1000063426 1000063992 1000064731 1000065349 1000065352 1000065381 1000065531 1000065533 1000065695 1000065858 1000066193 1000065701 67044 ] |
20 | 0.24 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
26728
]
|
21 | 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:
[
96784
]
|
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:
[
96803
]
|
23 | 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:
[
204150
]
|
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:
[
56130
]
|
25 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
1232
]
|
26 | 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:
[
9651
]
|
27 | 0.27 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
1268
]
|
28 | 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:
[
1231
]
|
29 | 0.38 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
]
|
30 | 0.26 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
]
|
31 | 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
]
|
32 | 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:
[
17
]
|
33 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
18
]
|
34 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
19
]
|
35 | 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
]
|
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:
[
21
]
|
37 | 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:
[
22
]
|
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:
[
23
]
|
39 | 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
]
|
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:
[
25
]
|
41 | 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:
[
26
]
|
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:
[
27
]
|
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:
[
28
]
|
44 | 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
]
|
45 | 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:
[
30
]
|
46 | 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:
[
31
]
|
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:
[
32
]
|
48 | 0.26 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:
[
67044
]
|
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 | 2288 |
App\Entity\Customer\Customer | 628 |
App\Entity\User\User | 565 |
App\Entity\Delivery\Delivery | 450 |
App\Entity\Catalog\ProductCatalog | 109 |
App\Entity\Catalog\CustomerCatalog | 109 |
App\Entity\Product\Market | 76 |
App\Entity\Pricing\Price | 29 |
App\Entity\Internal\Commercial | 28 |
App\Entity\Product\ProductPrice | 25 |
App\Entity\Product\Product | 21 |
App\Entity\Product\Category | 21 |
App\Entity\Product\Characteristic | 10 |
App\Entity\Product\CharacteristicLabel | 10 |
App\Entity\Delivery\DeliveryCost | 6 |
App\Entity\Internal\Society | 4 |
App\Entity\Internal\Parameter | 1 |