GET https://staging.pgdis.com/produit/84822-stylos-billes-bleu-bic-278233

Query Metrics

49 Database Queries
12 Different statements
1847.26 ms Query time
0 Invalid entities
3240 Managed entities

Queries

Group similar statements

# Time Info
1 154.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:
[
  "84822-stylos-billes-bleu-bic-278233"
]
2 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:
[
  144820
]
3 0.36 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:
[
  "84822-stylos-billes-bleu-bic-278233"
]
4 0.30 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:
[
  "84822-stylos-billes-bleu-bic-278233"
]
5 0.38 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:
[
  144820
  1
]
6 0.65 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:
[
  60
  287
  288
  289
  290
  291
  292
  293
  294
  290
  144820
]
7 0.37 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  111
]
8 0.37 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  114
]
9 0.35 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:
[
  115
]
10 0.35 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:
[
  116
]
11 0.36 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  117
]
12 0.61 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:
[
  135
]
13 0.35 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:
[
  136
]
14 0.62 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:
[
  137
]
15 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:
[
  138
]
16 0.63 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:
[
  147
]
17 2.45 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 944.87 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:
[
  144820
  "2025-04-11 17:11:44"
]
19 733.58 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:
[
  6384216
  6384937
  6385123
  6385166
  6385190
  6385593
  6385650
  6380834
  6386059
  6386127
  6380874
  6386368
  6359197
  6386490
  6386705
  6386872
  6387126
  6386812
  6387199
  6387201
  6376595
  6387476
  6387480
  6387535
  6387823
  6387827
  6385649
  6388238
  6383000
  6388678
  6387809
  6389100
  6389170
  6385867
  6389228
  6389624
  6389661
  6389907
  6390647
  6390742
  6390747
  6390974
  6360849
  6391150
  6390988
  6391399
  6391476
  6391518
  6391582
  6391676
  6391904
  6391928
  6392338
  6392283
  6392317
  6389543
  6393283
  6393429
  6393654
  6393757
  6393912
  6393267
  6394484
  6394729
  6394935
  6394971
  6395028
  6395085
  6395119
  6395128
  6395624
  6395844
  6395916
  6396047
  6396218
  6396613
  6396621
  6396649
  6396654
  6396678
  6396693
  6396702
  6396710
  6396796
  6396946
  6397032
  6397118
  6397258
  6397295
  6397425
  6397453
  6397992
  6398037
  6398041
  6398081
  6398166
  6398286
  6398519
  6398538
  6399059
  6399161
  6399341
  6399570
  6399770
  6400027
  6400030
  6400160
  6400161
  6400234
  6400592
  6401313
  6401548
  6401617
  6401693
  6401903
  6402149
  6402661
  6402686
  6404014
  6404549
  6405327
  6405661
  6406282
  6406653
  6406907
  6407482
  6407497
  6407732
  6407958
  6407971
  6408008
  6408409
  6409304
  6409599
  6409615
  6409678
  6409691
  6410054
  6411105
  6412054
  6412171
  6412172
  6412194
  6413024
  6413319
  6413340
  6413371
  6413619
  6413626
  6413717
  6414294
  6415176
  6415629
  6415772
  6415823
  6415941
  6416018
  6416099
  6416115
  6416152
  6416204
  6416238
  6416276
  6416377
  6416599
  6416622
  6416713
  6417012
  6417020
  6417118
  6417165
  6417287
  6417396
  6417444
  6417607
  6417651
  6418204
  6418265
  6418380
  6418736
  6418750
  6418751
  6418805
  6418935
  6419087
  6419089
  6419236
  6419362
  6419371
  6419519
  6419584
  6419790
  6420539
  6420646
  6420705
  6420770
  6422492
  6422967
  6423072
  6423182
  6423739
  6423758
  6424138
  6424225
  6424391
  6424733
  6424795
  6424817
  6424909
  6425664
  6426409
  6426535
  6426888
  6426985
  6427052
  6427158
  6427192
  6427934
  6428023
  6428825
  6429653
  6430486
  6431537
  6431902
  6431909
  6433576
  6433904
  6433938
  6433960
  6434489
  6434669
  6434948
  6434956
  6435158
  6435294
  6435362
  6435839
  6435956
  6435999
  6436021
  6436026
  6436289
  6436336
  6436382
  6436472
  6437106
  6437997
  6438641
  6438688
  6438765
  6439813
  6439980
  6440718
  6441190
  6441817
  6441964
  6442047
  6442055
  6442120
  6442704
  6442876
  6443113
  6443119
  6443284
  6443601
  6443700
  6443952
  6444012
  6444179
  6444339
  6444365
  6444641
  6444643
  6444657
  6444765
  6444772
  6444903
  6445055
  6445282
  6445765
  6446036
  6446139
  6446348
  6446773
  6446814
  6446896
  6446931
  6447399
  6447497
  6447622
  6447645
  6448653
  6448657
  6448772
  6448883
  6449439
  6449673
  6450151
  6450186
  6450195
  6450460
  6450744
  6450991
  6451063
  6451081
  6451094
  6451095
  6451109
  6451299
  6451565
  6451659
  6451771
  6451783
  6451807
  6451834
  6452084
  6452142
  6452427
  6452570
  6452595
  6452811
  6453202
  6453204
  6453456
  6453571
  6453576
  6453779
  6454000
  6454194
  6454343
  6454348
  6454446
  6454455
  6454462
  6454467
  6454485
  6454582
  6454599
  6454847
  6454848
  6454852
  6454885
  6454889
  6454903
  6454945
  6454951
  6454976
  6455117
  6455196
  6455256
  6455297
  6455307
  6455321
  6455409
  6455465
  6455498
  6455546
  6455636
  6455642
  6455662
  6455694
  6455698
  6455714
  6455884
  6455994
  6456028
  6456075
  6456138
  6456211
  6456232
  6456520
  6456561
  6456682
  6456718
  6457246
  6457251
  6457268
  6457505
  6459108
  6459955
  6460130
  6460216
  6460387
  6461476
  6461668
  6461726
  6462209
  6462540
  6462561
  6462625
  6464477
  6465023
  6465619
  6465706
  6465859
  6466354
  6466654
  6466731
  6467009
  6467105
  6467111
  6467134
  6468201
  6468747
  6468792
  6469059
  6469255
  6469327
  6469394
  6469580
  6469600
  6469732
  6469835
  6469847
  6470104
  6470163
  6470343
  6470527
  6470792
  6470886
  6471258
  6471562
  6472331
  6472836
  6473241
  6473558
  6474518
  6474667
  6474668
  6475438
  6475600
  6475659
  6476529
  6476585
  6476784
  6476957
  6477078
  6477836
  6477881
  6480466
  6480569
  6480568
  6480577
  6480602
  6480635
  6480738
  6481299
  6481311
  6481660
  6482510
  6482516
  6482914
  6482962
  6483391
  6483645
  6483690
  6483976
  6484001
  6484568
  6484644
  6484808
  6484810
  6484843
  6484850
  6485541
  6485633
  6485702
  6486147
  6486476
  6486491
  6486509
  6486584
  6486709
  6488345
  6488568
  6488637
  6488892
  6488908
  6488952
  6489081
  6489125
  6489981
  6490085
  6490158
  6491015
  6491058
  6491551
  6491594
  6491887
  6492245
  6493902
  6494310
  6494359
  6494553
  6494706
  6494750
  6494844
  6495398
  6495417
  6495599
  6495714
  6496254
  6496672
  6497141
  6497142
  6497173
  6497266
  6497525
  6497733
  6497747
  6497756
  6497761
  6497795
  6498132
  6498197
  6498259
  6498523
  6498777
  6499031
  6499060
  6499111
  6499207
  6499220
  6499383
  6499442
  6499473
  6499507
  6499537
  6499557
  6499684
  6499715
  6499785
  6499819
  6499878
  6499938
  6500069
  6500077
  6500095
  6500141
  6500208
  6500219
  6500420
  6500691
  6500728
  6500816
  6500890
  6500977
  6500986
  6501272
  6501278
  6501280
  6501292
  6501301
  6501439
  6501446
  6501568
  6501630
  6501695
  6501883
  6501982
  6502006
  6502055
  6502142
  6502195
  6502275
  6502282
  6502339
  6502403
  6502464
  6502522
  6502622
  6502725
  6503049
  6503126
  6503147
  6503330
  6503333
  6503340
  6503539
  6503798
  6503925
  6504066
  6504115
  6504119
  6504203
  6504254
  6504255
  6504335
  6504503
  6504716
  6506242
  6506786
  6507139
  6507461
  6507472
  6507566
  6508221
  6508461
  6509098
  6509105
  6509198
  6509603
  6509607
  6510436
  6510760
  6511195
  6511226
  6512483
  6512945
  6512946
  6512964
  6513087
  6515276
  6515739
  6516183
  6516212
  6516552
  6517248
  6517556
  6518174
  6518500
  6518649
  6518689
  6518931
  6519393
  6520164
  6520205
  6520231
  6520248
  6521134
  6521166
  6521746
  6522051
  6522121
  6522308
  6522718
  6522752
  6522768
  6523352
  6523974
  6524140
  6524273
  6524342
  6524456
  6524508
  6524717
  6524862
  6525073
  6525222
  6525279
  6525428
  6525710
  6525775
  6525918
  6526095
  6526175
  6526257
  6526465
  6526692
  6526714
  6526721
  6526806
  6527005
  6527128
  6527225
  6527246
  6527305
  6527430
  6528054
  6528163
  6528166
  6528345
  6528739
  6528753
  6528768
  6528770
  6528782
  6528798
  6528804
  6528806
  6528817
  6528833
  6528859
  6529092
  6529143
  6529273
  6529368
  6529373
  6529852
  6529879
  6529987
  6530047
  6530056
  6530093
  6530245
  6530294
  6530315
  6530383
  6530431
  6530454
  6530455
  6530487
  6530525
  6530559
  6530905
  6530921
  6530990
  6531001
  6531086
  6531153
  6531303
  6532683
  6532747
  6532756
  6532760
  6532868
  6532913
  6533067
  6533205
  6533562
  6533581
  6533592
  6534222
  6534460
  6534591
  6534680
  6534765
  6535657
  6536142
  6536950
  6537008
  6537817
  6538223
  6538358
  6538778
  6538796
  6539010
  6539309
  6539682
  6539947
  6539995
  6540541
  6541245
  6541257
  6541753
  6541979
  6542101
  1000000751
  1000000768
  1000001549
  6390584
  1000001770
  1000002184
  1000002395
  1000002669
  1000002570
  1000003920
  6390419
  6391971
  1000002120
  1000004681
  1000004683
  1000004888
  1000005014
  1000005064
  1000005182
  6340647
  6391616
  1000002856
  1000006718
  1000006804
  1000006968
  6366500
  1000006055
  1000007561
  1000007535
  1000003520
  6379629
  1000009689
  1000004570
  1000009192
  1000009910
  1000010023
  1000010917
  1000010772
  1000011861
  1000011920
  1000012049
  1000012050
  1000011035
  1000012334
  1000012429
  1000012856
  1000006028
  1000013407
  1000003879
  1000013481
  1000013504
  1000013725
  1000009931
  1000004090
  1000011051
  1000014018
  1000014197
  1000014203
  1000011074
  1000014691
  1000013205
  1000015277
  1000015291
  1000015968
  1000013128
  1000016862
  1000016878
  1000013568
  1000016217
  1000016514
  1000017531
  1000017532
  1000017612
  1000017613
  1000017637
  1000017639
  1000017640
  1000017686
  1000017687
  1000017688
  1000017719
  1000017752
  1000014518
  1000017754
  1000010690
  1000016264
  1000019098
  1000012053
  1000019725
  1000020763
  1000021010
  1000021039
  1000021040
  1000021043
  1000020998
  1000021480
  1000021510
  1000021553
  1000021728
  1000021850
  1000021852
  1000021853
  1000021788
  1000001497
  1000022440
  1000022595
  1000022602
  1000022728
  1000024515
  1000024518
  1000024519
  1000025061
  1000025079
  1000025082
  1000025089
  1000025100
  1000017645
  1000009562
  1000021539
  1000026497
  1000026499
  1000026503
  1000026557
  1000025564
  1000006969
  1000026666
  1000016216
  1000013802
  1000027363
  1000027364
  1000027251
  1000026452
  1000028365
  1000028527
  1000028529
  1000028740
  1000028741
  1000028742
  1000028743
  1000028744
  1000028746
  1000027888
  1000028996
  1000022906
  1000029499
  1000030642
  1000030654
  1000030662
  1000031104
  1000031105
  1000031106
  1000010418
  1000031251
  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
  1000031527
  1000031531
  1000031532
  1000031533
  1000031546
  1000031553
  1000031558
  1000031566
  1000031567
  1000031583
  1000031585
  1000031591
  1000031650
  1000031723
  1000031725
  1000031726
  1000031727
  1000031867
  1000031880
  1000016954
  1000032245
  1000032273
  1000032488
  1000032489
  1000032490
  1000032660
  1000032924
  1000033213
  1000033356
  1000033357
  1000033365
  1000033372
  1000033448
  1000021860
  1000033637
  1000033827
  1000014649
  1000029560
  1000034491
  1000034640
  1000034671
  1000034673
  1000015855
  1000015293
  1000032483
  1000034963
  1000033444
  1000028622
  1000024806
  1000036234
  1000036427
  1000036428
  1000036432
  1000036497
  1000036444
  1000036903
  1000037028
  1000037368
  1000037744
  1000037745
  1000037785
  1000037793
  1000037803
  1000037804
  1000038873
  1000038875
  1000039267
  1000039738
  1000039740
  1000040188
  1000040330
  1000040333
  1000040335
  1000040131
  1000040833
  1000040834
  1000040836
  1000040863
  1000040886
  1000040889
  1000041066
  1000041505
  1000041563
  1000041569
  1000041571
  1000041572
  1000025165
  1000034487
  1000042312
  1000042443
  1000042444
  1000042464
  1000042466
  1000042473
  1000042475
  1000042476
  1000042478
  1000042479
  1000042552
  1000042553
  1000042554
  1000042708
  1000040497
  1000041568
  1000042812
  1000042964
  1000042966
  1000042969
  1000042970
  1000042971
  1000043467
  1000043468
  1000043565
  1000043566
  1000043829
  1000034646
  1000043990
  1000024125
  1000041637
  1000044437
  1000044439
  1000044435
  1000044817
  1000044914
  1000045611
  1000045613
  1000045614
  1000045624
  1000045625
  1000045626
  1000045628
  1000045632
  1000045635
  1000045816
  1000045817
  1000045831
  1000045844
  1000045867
  1000046068
  1000046132
  1000046177
  1000046182
  1000046183
  1000046184
  1000046185
  1000046187
  1000046188
  1000046189
  1000046190
  1000046196
  1000046198
  1000046207
  1000036227
  1000046292
  1000046297
  1000046298
  1000046300
  1000046460
  1000046465
  1000046490
  1000046491
  1000046498
  1000046500
  1000046824
  1000046862
  1000047341
  1000047357
  1000047361
  1000047441
  1000047443
  1000047444
  1000047674
  1000047833
  1000047825
  1000047842
  1000047844
  1000047863
  1000047864
  1000047886
  1000047980
  1000048070
  1000010530
  1000048688
  1000048723
  1000049009
  1000049015
  1000049032
  1000049037
  1000034281
  1000049158
  1000049129
  1000049401
  1000049402
  1000048445
  1000049762
  1000045271
  1000049889
  1000049953
  1000049954
  1000048235
  1000050218
  1000050253
  1000050255
  1000050256
  1000050277
  1000048927
  1000050388
  1000050249
  1000050425
  1000050545
  1000050552
  1000050582
  1000050606
  1000050704
  1000050705
  1000050781
  1000050783
  1000050799
  1000050884
  1000050938
  1000050281
  1000050706
  1000049131
  1000048714
  1000051287
  1000038883
  1000049599
  1000051469
  1000051471
  1000051041
  1000051518
  1000051526
  1000051530
  1000050950
  1000051614
  1000051686
  1000051696
  1000051728
  1000051734
  1000051737
  1000051747
  1000051750
  1000051751
  1000051842
  1000051843
  1000048779
  1000051896
  1000052277
  1000051742
  1000052383
  1000052459
  1000052576
  1000052577
  1000052579
  1000052588
  1000052513
  1000052639
  1000052581
  1000052965
  1000052966
  1000052979
  1000053013
  1000053016
  1000052628
  1000053140
  1000050387
  1000053334
  6379979
  1000053454
  1000053559
  1000052248
  1000053604
  1000052142
  1000050278
  1000053641
  1000053645
  1000053771
  1000053994
  1000054072
  1000053966
  1000052409
  1000054278
  1000054348
  1000054608
  1000054634
  1000054641
  1000050241
  1000054996
  1000053455
  1000053996
  1000053422
  1000055120
  1000054335
  1000055183
  1000055220
  1000055729
  1000055869
  1000053685
  1000055577
  1000056013
  1000046363
  1000039722
  1000056472
  1000056878
  1000057028
  1000057048
  1000057068
  1000057104
  1000057110
  1000057111
  1000057112
  1000057188
  1000057081
  1000057212
  1000055445
  1000057541
  1000057548
  1000057567
  1000057708
  1000057766
  1000057787
  1000058140
  1000058298
  1000058512
  1000058655
  1000054336
  1000059088
  1000059089
  1000059250
  1000059256
  1000059258
  1000059270
  1000059309
  1000059500
  1000059508
  1000059570
  1000059575
  1000059578
  1000059915
  1000060005
  1000021122
  1000060311
  1000060346
  1000060481
  1000060853
  1000060983
  1000060984
  1000061049
  1000061119
  1000061118
  1000061552
  1000061597
  1000061790
  1000061842
  1000061870
  1000061933
  1000061993
  1000061048
  1000062106
  1000050117
  1000062463
  1000062486
  1000022317
  1000062702
  1000062742
  1000056260
  1000062800
  1000062744
  1000063003
  1000063040
  1000063141
  1000063230
  1000058518
  1000063580
  1000063594
  1000046203
  1000050675
  1000063912
  1000052866
  1000064247
  1000064521
  1000064522
  1000064523
  1000064524
  1000064525
  1000064537
  1000064919
  1000064862
  1000065145
  1000065191
  1000065199
  1000065531
  1000065533
  1000065576
  1000065577
  1000065635
  1000065736
  1000065710
  1000064818
  1000065966
  1000066160
  1000066161
  1000066205
  1000064675
  144820
]
20 0.37 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1232
]
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:
[
  1231
]
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:
[
  144821
]
23 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:
[
  204150
]
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:
[
  96803
]
25 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:
[
  26728
]
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:
[
  246268
]
27 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  56130
]
28 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  9651
]
29 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  5496
]
30 0.36 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.32 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.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  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.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:
[
  18
]
35 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  19
]
36 0.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:
[
  20
]
37 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:
[
  21
]
38 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:
[
  22
]
39 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:
[
  23
]
40 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  24
]
41 0.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:
[
  25
]
42 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:
[
  26
]
43 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:
[
  27
]
44 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:
[
  28
]
45 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  29
]
46 0.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:
[
  30
]
47 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:
[
  31
]
48 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:
[
  32
]
49 0.33 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:
[
  144820
]

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 1330
App\Entity\Customer\Customer 463
App\Entity\Delivery\Delivery 362
App\Entity\User\User 347
App\Entity\Catalog\ProductCatalog 177
App\Entity\Catalog\CustomerCatalog 177
App\Entity\Product\Market 133
App\Entity\Internal\Commercial 64
App\Entity\Pricing\Price 51
App\Entity\Product\ProductPrice 49
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 17
App\Entity\Product\CharacteristicLabel 16
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 5
App\Entity\Internal\Parameter 1