Query Metrics
50
Database Queries
13
Different statements
3572.44 ms
Query time
0
Invalid entities
3455
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 130.02 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:
[
"15168-marqueurs-permanents-noir-uniball-pm-122-n"
]
|
2 | 0.44 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:
[
2030
]
|
3 | 0.71 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"15168-marqueurs-permanents-noir-uniball-pm-122-n"
]
|
4 | 0.66 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:
[
"15168-marqueurs-permanents-noir-uniball-pm-122-n"
]
|
5 | 2.34 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:
[ 2030 1 ] |
6 | 1.10 ms |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 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:
[ 58 275 276 277 278 276 2030 ] |
7 | 0.34 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
139
]
|
8 | 0.26 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:
[
140
]
|
9 | 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:
[
141
]
|
10 | 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:
[
142
]
|
11 | 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:
[
170
]
|
12 | 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:
[
171
]
|
13 | 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:
[
172
]
|
14 | 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:
[
174
]
|
15 | 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:
[
175
]
|
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:
[
176
]
|
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 | 2107.50 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:
[ 2030 "2025-04-11 14:11:32" ] |
19 | 1319.69 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:
[ 6384215 6379959 6384677 6386003 6386654 6387369 6382839 6386196 6388858 6389065 6389133 6390060 6390309 6390531 6390767 6384100 6390967 6391060 6391372 6391836 6390748 6391992 6392609 6392642 6384715 6393029 6393148 6393226 6393264 6393294 6393364 6393345 6343287 6393661 6394074 6394509 6394529 6394698 6394822 6392982 6395075 6395153 6395286 6395378 6395399 6395401 6395764 6395813 6395856 6395871 6395906 6396336 6396383 6396419 6396425 6396610 6397042 6397090 6397098 6397103 6397267 6397955 6397956 6398222 6398240 6398318 6398393 6398397 6398401 6398672 6398914 6399133 6399316 6399995 6400146 6400229 6400232 6400250 6400751 6401032 6401406 6401533 6402541 6403158 6403160 6403699 6403747 6403816 6403918 6404367 6404530 6404618 6405130 6405338 6405518 6405674 6406614 6406877 6406937 6407115 6407123 6408026 6408378 6408390 6408547 6408905 6409029 6409213 6409274 6409317 6409340 6409192 6409499 6409508 6409671 6409694 6410239 6410560 6411046 6411163 6411233 6411241 6411344 6411423 6411440 6411701 6411704 6411817 6411980 6412087 6412106 6412232 6412366 6412615 6413273 6413830 6414261 6414444 6414598 6414685 6414992 6415001 6415067 6415167 6415171 6415177 6415362 6415604 6415669 6415671 6415765 6415817 6416138 6416174 6416257 6416306 6416312 6416439 6416440 6416604 6416622 6416827 6416902 6416921 6416960 6416989 6417089 6417103 6417170 6417280 6417297 6417325 6417450 6417817 6417870 6417886 6417920 6417993 6418081 6418098 6418100 6418113 6418119 6418266 6418268 6418351 6418382 6418435 6418704 6418715 6418829 6418863 6418888 6418956 6418984 6419065 6419072 6419074 6419133 6419249 6419361 6419362 6419503 6419561 6419583 6419704 6419840 6419859 6420006 6420309 6420645 6420650 6420666 6420715 6420718 6420835 6422499 6422696 6422700 6422872 6422968 6423171 6423274 6423372 6423687 6423740 6423965 6424052 6424121 6424341 6424663 6424737 6424777 6425118 6425318 6425476 6425721 6426196 6426408 6426430 6426524 6426608 6426732 6426808 6426849 6427115 6427238 6427665 6427777 6428026 6428411 6428443 6428638 6428654 6428736 6428824 6428836 6428917 6429328 6429329 6429582 6429630 6429813 6429828 6430128 6430284 6430873 6430922 6431080 6431516 6431579 6431753 6431785 6431860 6432152 6432192 6432280 6432322 6433532 6433585 6434067 6434182 6434204 6434209 6434803 6434807 6434849 6434909 6435321 6435644 6435654 6435759 6435879 6436064 6436090 6436460 6437138 6438035 6438155 6438500 6438906 6439005 6439560 6439612 6439646 6439663 6439676 6439980 6440232 6440846 6441144 6441208 6441212 6441237 6441367 6441612 6441921 6442798 6442848 6442862 6443135 6443195 6443294 6443320 6443364 6443373 6443537 6443826 6443923 6444179 6444426 6445175 6445262 6445273 6445295 6445436 6445679 6446134 6446612 6447049 6447057 6447242 6447331 6447383 6447402 6447457 6447687 6449518 6449525 6449588 6449617 6449643 6449676 6449677 6449678 6449807 6449814 6449891 6449915 6450002 6450170 6450180 6450181 6450195 6450228 6450375 6450405 6450413 6450424 6450442 6450497 6450554 6450565 6450597 6450654 6450744 6450754 6450761 6450769 6450856 6451045 6451060 6451088 6451125 6451200 6451240 6451252 6451324 6451435 6451439 6451454 6451461 6451463 6451561 6451594 6451631 6451703 6451922 6451977 6452350 6452356 6452383 6452410 6452496 6452521 6452537 6452577 6452743 6452855 6453263 6453342 6453465 6453498 6453502 6453552 6453571 6453861 6453988 6454177 6454530 6454543 6454663 6454722 6454744 6454766 6454855 6454873 6454875 6454982 6454985 6454989 6455053 6455137 6455231 6455233 6455332 6455365 6455390 6455417 6455660 6455716 6455735 6455802 6455963 6456026 6456109 6456158 6456161 6456167 6456201 6456379 6456424 6456533 6456626 6456628 6456629 6456706 6456750 6456792 6457025 6457227 6457280 6457296 6457423 6457443 6457539 6457561 6457759 6457803 6458178 6458489 6459162 6459228 6459571 6460036 6460039 6460061 6460133 6460312 6460453 6461104 6461281 6461346 6461354 6461357 6461600 6461645 6461751 6461910 6462629 6462653 6462767 6463176 6463512 6463527 6463604 6463659 6463937 6464010 6464485 6465871 6465933 6465935 6466719 6466944 6468042 6469829 6469876 6469881 6470299 6470501 6470533 6470547 6471027 6471204 6471370 6471369 6471454 6471491 6471526 6471801 6472139 6472178 6472706 6472733 6472766 6472906 6474476 6474521 6474688 6475335 6475567 6475842 6476486 6476573 6476977 6477006 6477124 6477210 6477645 6477666 6477845 6477855 6480421 6480471 6480487 6480488 6480517 6480817 6480877 6481010 6481159 6481196 6481658 6481731 6481937 6482776 6482987 6483369 6483533 6483540 6483961 6483967 6483993 6483994 6483997 6484000 6484233 6484872 6485022 6485258 6485431 6485593 6485968 6485996 6486002 6486055 6486295 6486734 6486753 6486870 6487914 6488384 6488533 6489007 6489009 6490084 6491037 6491045 6491486 6491608 6491863 6492245 6493065 6493131 6493193 6493408 6493896 6493931 6494352 6494388 6494743 6494881 6495127 6495253 6495577 6495662 6495827 6496239 6496290 6496519 6497054 6497169 6497189 6497239 6497254 6497256 6497261 6497314 6497424 6497454 6497477 6497481 6497592 6497616 6497708 6497770 6497903 6497915 6497932 6498083 6498150 6498275 6498359 6498463 6498513 6498616 6498632 6498856 6499153 6499236 6499378 6499440 6499452 6499459 6499517 6499535 6499778 6499817 6499989 6500258 6500260 6500318 6500323 6500324 6500325 6500555 6500830 6500835 6500881 6500890 6500926 6501067 6501224 6501383 6501391 6501403 6501443 6501459 6501533 6501612 6501633 6501727 6501762 6501837 6501860 6501990 6502006 6502008 6502019 6502063 6502111 6502114 6502149 6502547 6502587 6502606 6502836 6502837 6502934 6502963 6503088 6503446 6503529 6503566 6503767 6503778 6503973 6503999 6504037 6504208 6504255 6504259 6504268 6504880 6505775 6506345 6506375 6506487 6506666 6506669 6507223 6507283 6507508 6507688 6507817 6507818 6507831 6507868 6507931 6507942 6508573 6508587 6508744 6509081 6509250 6509371 6509392 6509642 6509646 6509717 6510165 6510310 6510409 6511056 6511095 6512456 6512579 6512924 6512929 6512933 6515783 6515822 6517036 6517418 6518042 6518355 6518475 6518520 6518536 6518537 6518689 6519517 6519520 6520056 6520704 6521524 6521697 6521703 6521750 6522006 6522234 6522246 6522253 6522427 6522470 6522471 6522963 6523976 6524009 6524062 6524227 6524285 6524290 6524291 6524294 6524324 6524331 6524402 6524410 6524445 6524460 6524630 6524644 6524673 6525019 6525213 6525282 6525319 6525351 6525445 6525509 6525637 6526063 6526067 6526182 6526296 6526488 6526561 6527196 6527488 6528078 6528111 6528123 6528392 6528394 6528462 6528465 6528598 6528734 6528753 6528782 6528791 6528901 6528912 6528913 6528942 6529073 6529242 6529277 6529319 6529336 6529360 6529882 6530038 6530099 6530101 6530114 6530128 6530220 6530222 6530257 6530277 6530278 6530313 6530332 6530337 6530340 6530413 6530475 6530558 6530641 6530686 6530703 6530931 6530990 6532764 6532782 6532789 6532828 6532874 6532929 6532949 6533171 6533178 6533199 6533204 6533207 6533221 6533487 6534618 6534902 6535107 6535062 6535675 6535728 6535740 6535866 6535870 6536173 6536566 6536867 6537092 6537142 6537559 6537572 6537617 6537624 6537972 6538196 6538230 6538637 6539618 6539947 6539972 6540171 6540225 6540936 6541441 6541722 6542111 6542142 1000000818 1000001089 6361152 1000001998 1000002360 1000002363 1000002440 6387964 1000002047 1000002930 1000003892 1000003992 1000001006 6390301 1000004313 1000004806 1000004156 1000005026 1000004568 1000005169 6384060 1000004565 1000001803 1000005776 1000005936 1000006372 1000006802 1000007084 1000007401 6334674 1000007912 1000002561 1000005264 1000005074 1000008052 1000004819 1000004521 1000007773 1000008640 1000006833 1000008825 1000001404 1000004137 1000008866 1000002514 1000009237 6359372 1000009381 1000009821 1000009940 1000009915 1000002708 1000004245 1000007460 1000005028 1000010294 1000010003 1000009248 1000009717 1000010893 1000010669 1000002066 1000011009 1000011814 1000011830 1000009375 1000010148 1000009602 1000010874 1000012132 1000010960 1000012160 1000011864 1000010193 1000010835 1000012621 1000013016 1000006028 1000013215 1000013427 1000012780 1000013208 1000013339 1000010763 1000012989 1000014014 1000014418 1000009844 1000013779 1000014304 1000014709 1000014738 1000014739 1000014741 1000011050 1000014915 1000013363 1000012248 1000010092 1000012704 1000013953 1000014223 1000015397 1000014419 1000015408 1000015599 1000015619 1000006062 1000015818 1000016234 1000013469 1000016195 1000016472 1000016480 1000014747 1000017112 1000017208 1000017209 1000017210 1000017302 1000015296 1000017328 1000017411 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017746 1000017953 1000017954 1000017955 1000017956 1000018314 1000016035 1000018539 1000018540 1000018541 1000014377 1000018650 1000018751 1000006098 1000016969 1000018962 1000019083 1000019100 1000019104 1000019115 1000019136 1000019268 1000019376 1000017225 1000019505 1000019507 1000019508 1000019509 1000019510 1000012927 1000019903 1000020308 1000020309 1000020310 1000020313 1000020314 1000020346 1000020348 1000020349 1000020350 1000020352 1000020353 1000016320 1000020900 1000020904 1000020905 1000020907 1000020908 1000020909 1000020912 1000020914 1000020915 1000020918 1000020919 1000020972 1000020973 1000020974 1000020975 1000020976 1000014167 1000021073 1000021076 1000021080 1000021084 1000021085 1000021102 1000020188 1000010671 1000015249 1000021148 1000016113 1000021354 1000021498 1000021818 1000021825 1000021828 1000021856 1000021858 1000021864 1000021886 1000021891 1000021904 1000013935 1000021928 1000022728 1000014891 1000023555 1000023568 1000024568 1000024569 1000024570 1000024571 1000024572 1000024573 1000024574 1000024575 1000016439 1000024679 1000024680 1000024681 1000024682 1000024683 1000024684 1000024685 1000024686 1000024687 1000024688 1000024689 1000024690 1000024691 1000024692 1000024693 1000024694 1000024695 1000024696 1000024697 1000024698 1000024739 1000024742 1000024743 1000024744 1000024746 1000024747 1000024763 1000017957 1000025759 1000026476 1000017401 1000026573 1000023639 1000026649 1000026146 1000027363 1000027364 1000027365 1000027366 1000023910 1000027431 1000028089 1000018257 1000028286 1000028492 1000028592 1000028597 1000028671 1000028673 1000015502 1000028820 1000016528 1000026108 1000029307 1000015131 1000019169 1000030092 1000022840 1000028675 1000030836 1000030837 1000030840 1000030845 1000030846 1000030848 1000030865 1000030906 1000028244 1000017748 1000028676 1000026923 1000012435 1000016473 1000016787 1000029896 1000026586 1000032720 1000020152 1000033868 1000018536 1000019123 1000034238 1000034239 1000034240 1000034241 1000034242 1000034489 1000034494 1000027529 1000034663 1000012658 1000035271 1000035281 1000010721 1000035912 1000035971 1000035974 1000035980 1000035984 1000035988 1000035990 1000006589 1000036252 1000036277 1000036286 1000022809 1000036423 1000036741 1000036742 1000037725 1000037738 1000022807 1000036216 1000039311 1000039324 1000039325 1000039326 1000039327 1000039328 1000027876 1000039314 1000015922 1000033971 1000040554 1000035640 1000041580 1000041581 1000041583 1000024087 1000030908 1000042168 1000029441 1000042850 1000043009 1000043021 1000042165 1000022803 1000043408 1000043445 1000043446 1000043447 1000043448 1000043449 1000043648 1000043669 1000043672 1000043679 1000043681 1000043705 1000043927 1000043085 1000026590 1000044568 1000044590 1000044798 1000044811 1000044823 1000044866 1000044913 1000044945 1000039739 1000045048 1000045051 1000045053 1000045055 1000045057 1000045062 1000045065 1000045066 1000045068 1000045074 1000045082 1000045100 1000045103 1000045903 1000045906 1000045912 1000046056 1000046210 1000046216 1000046347 1000046348 1000046349 1000046418 1000009336 1000046819 1000046838 1000046875 1000044508 1000046901 1000047145 1000009928 1000043272 1000047583 1000047135 1000028619 1000047954 1000048085 1000048086 1000025959 1000048133 1000048260 1000048328 1000048331 1000032846 1000048401 1000036007 1000048490 1000048773 1000048774 1000032787 1000048162 1000049296 1000049321 1000048900 1000049607 1000049706 1000049747 1000049754 1000045108 1000049584 1000049757 1000049811 1000049912 1000050149 1000025298 1000033089 1000008587 1000050399 1000050479 1000050214 1000049008 1000050637 1000050419 1000047804 1000051046 1000051056 1000051079 1000051213 1000051371 1000051377 1000050496 1000049689 1000050195 1000049448 1000051057 1000051588 1000051012 1000052073 1000052479 1000052555 1000052558 1000052609 1000052806 1000052807 1000052802 1000052949 1000050372 1000052913 1000053273 1000010043 1000053297 1000045244 1000048580 1000053333 1000032428 1000052810 1000052814 1000050919 1000051700 1000051749 1000052131 1000008158 1000053477 1000053490 1000050765 1000054031 1000054032 1000054033 1000053842 1000053301 1000006965 1000019932 1000053931 1000054214 1000054239 1000054246 1000054248 1000054252 1000054330 1000054343 1000054411 1000054488 1000053871 1000017165 1000054037 1000054699 1000054860 1000052681 1000054897 1000049942 1000055074 1000055111 1000055154 1000055201 1000055225 1000053874 1000055508 1000055679 1000052670 1000055686 1000055888 1000056435 1000056720 1000056721 1000056997 1000051339 1000057163 1000053011 1000054483 1000057081 1000057344 1000057575 1000057578 1000055873 1000057830 1000057917 1000057213 1000058860 1000058911 1000058914 1000059061 1000057517 1000059063 1000059940 1000060017 1000060188 1000060213 1000060214 1000060318 1000059470 1000060386 1000060015 1000061043 1000061232 1000061315 1000061465 1000061471 1000061389 1000061552 1000061531 1000061616 1000061745 1000054088 1000062288 1000062378 1000059246 1000062479 1000055717 1000061392 1000053402 1000062863 1000062994 1000063546 1000063747 1000063754 1000063755 1000063773 1000063811 1000063920 1000064134 1000055929 1000064233 1000064245 1000064799 1000064885 1000064569 1000064886 1000063552 1000064298 1000064978 1000063704 1000065116 1000065320 1000065328 1000057545 1000066145 1000066195 1000066241 1000066343 2030 ] |
20 | 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:
[
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:
[
9651
]
|
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:
[
10481
]
|
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:
[
2029
]
|
24 | 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:
[
56130
]
|
25 | 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:
[
96784
]
|
26 | 0.23 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
65981
]
|
27 | 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:
[
65676
]
|
28 | 0.33 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
11358
]
|
29 | 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:
[
2886
]
|
30 | 0.46 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.44 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.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
16
]
|
33 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
17
]
|
34 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
18
]
|
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:
[
19
]
|
36 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
20
]
|
37 | 0.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.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
22
]
|
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:
[
23
]
|
40 | 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:
[
24
]
|
41 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
25
]
|
42 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
26
]
|
43 | 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:
[
27
]
|
44 | 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:
[
28
]
|
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:
[
29
]
|
46 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
30
]
|
47 | 0.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:
[
31
]
|
48 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
32
]
|
49 | 0.55 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:
[
2030
]
|
50 | 0.72 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.reference IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "15167" "15169" "15179" "15180" "15181" "15171" "15172" ] |
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 | 1508 |
App\Entity\Customer\Customer | 478 |
App\Entity\Delivery\Delivery | 396 |
App\Entity\User\User | 377 |
App\Entity\Catalog\ProductCatalog | 168 |
App\Entity\Catalog\CustomerCatalog | 168 |
App\Entity\Product\Market | 109 |
App\Entity\Internal\Commercial | 53 |
App\Entity\Pricing\Price | 50 |
App\Entity\Product\ProductPrice | 49 |
App\Entity\Product\Product | 27 |
App\Entity\Product\Category | 21 |
App\Entity\Product\Characteristic | 20 |
App\Entity\Product\CharacteristicLabel | 19 |
App\Entity\Delivery\DeliveryCost | 6 |
App\Entity\Internal\Society | 4 |
App\Entity\Internal\Parameter | 1 |
App\Infrastructure\Doctrine\Entity\ProductRule | 1 |