GET https://staging.pgdis.com/produit/01523-stylos-feutres-et-rollers-vert-paper-mate-095157

Query Metrics

50 Database Queries
13 Different statements
1482.32 ms Query time
0 Invalid entities
2835 Managed entities

Queries

Group similar statements

# Time Info
1 240.85 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:
[
  "01523-stylos-feutres-et-rollers-vert-paper-mate-095157"
]
2 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:
[
  240
]
3 0.42 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:
[
  "01523-stylos-feutres-et-rollers-vert-paper-mate-095157"
]
4 0.33 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:
[
  "01523-stylos-feutres-et-rollers-vert-paper-mate-095157"
]
5 0.90 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:
[
  240
  1
]
6 0.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_ 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
  292
  240
]
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:
[
  111
]
8 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  114
]
9 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  115
]
10 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:
[
  116
]
11 0.13 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  117
]
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:
[
  135
]
13 0.16 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  136
]
14 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:
[
  137
]
15 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:
[
  138
]
16 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:
[
  147
]
17 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ourClientsAlsoBoughtMonths"
]
18 630.41 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:
[
  240
  "2025-04-11 17:22:54"
]
19 600.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_ 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:
[
  6366706
  6367037
  6384285
  6384358
  6384375
  6382777
  6384673
  6384763
  6384840
  6385042
  6385146
  6385190
  6385353
  6385356
  6384707
  6378335
  6385507
  6385520
  6385732
  6386180
  6386184
  6386186
  6386270
  6386913
  6387078
  6387125
  6387898
  6385649
  6388193
  6388526
  6388596
  6388756
  6385811
  6389164
  6389170
  6389228
  6365711
  6367817
  6375307
  6376370
  6389533
  6389581
  6389657
  6389680
  6390028
  6390282
  6390512
  6390943
  6384014
  6391150
  6391582
  6391714
  6391933
  6392199
  6392306
  6392207
  6392732
  6393260
  6393513
  6393585
  6394150
  6394272
  6391443
  6390671
  6392420
  6394602
  6395030
  6395033
  6395036
  6395128
  6395259
  6395282
  6395466
  6395631
  6395799
  6395915
  6395986
  6396138
  6396259
  6396584
  6396621
  6396636
  6396651
  6396829
  6396991
  6396993
  6397009
  6397029
  6397039
  6397118
  6397151
  6397162
  6397221
  6397253
  6397412
  6397495
  6397651
  6397666
  6397691
  6397743
  6398028
  6398489
  6398538
  6399278
  6399283
  6399536
  6399611
  6399644
  6399833
  6400146
  6400152
  6400236
  6400364
  6400514
  6400560
  6401371
  6402073
  6402268
  6402806
  6402985
  6403126
  6403259
  6403542
  6403865
  1000002801
  6404266
  6404387
  6404538
  6404930
  6404965
  6405304
  6405958
  6406376
  6406540
  6406646
  6406748
  6406845
  6407117
  6407121
  6408654
  6408765
  6408912
  6409016
  6409082
  6409494
  6409691
  6409994
  6410030
  6410056
  6410393
  6410439
  6410776
  6410885
  6410928
  6411045
  6411099
  6411314
  6411317
  6411353
  6411721
  6412052
  6412212
  6412635
  6412676
  6412966
  6414470
  6414974
  6415004
  6415083
  6415215
  6415629
  6415632
  6415641
  6415671
  6415811
  6416070
  6416217
  6416252
  6416428
  6416635
  6417086
  6417189
  6417193
  6417239
  6417314
  6417368
  6417412
  6417416
  6417418
  6417429
  6417565
  6417651
  6417779
  6417824
  6417881
  6417979
  6418115
  6418231
  6418272
  6418345
  6418412
  6418718
  6418818
  6418824
  6418893
  6418917
  6418929
  6419685
  6419869
  6419870
  6420135
  6420529
  6420594
  6421137
  6421404
  6421524
  6421947
  6422129
  6422166
  6422220
  6422548
  6422659
  6422677
  6422717
  6423365
  6423701
  6423783
  6424006
  6424215
  6424263
  6424351
  6424774
  6424983
  6425088
  6425240
  6425905
  6426377
  6426401
  6426451
  6427007
  6427069
  6427259
  6427318
  6427374
  6427701
  6427746
  6428298
  6428451
  1000010823
  6428959
  6429659
  6429719
  6430435
  6430483
  6430575
  6430627
  6430854
  6430922
  6431232
  6431244
  6431949
  6432120
  6433539
  6433815
  6434017
  6434801
  6434816
  6435010
  6435393
  6435588
  6435705
  6435777
  6436792
  6437944
  6438870
  6438913
  6438931
  6439616
  6439649
  6440915
  6441119
  6441270
  6441632
  6442892
  6443680
  6445244
  6445373
  6445510
  6445820
  6446048
  6447268
  6447332
  6447689
  6448220
  6448657
  6449383
  6449653
  6449654
  6450185
  6450195
  6450196
  6450225
  6450274
  6450460
  6450487
  6451214
  6451631
  6451759
  6451801
  6451808
  6451843
  6452122
  6452274
  6452307
  6452483
  6452484
  6452562
  6452583
  6452743
  6452754
  6452880
  6453375
  6453378
  6453431
  6453589
  6453621
  6453665
  6453772
  6453865
  6453939
  6454185
  6454187
  6454189
  6454190
  6454369
  6454587
  6454737
  6454761
  6454913
  6455142
  6455571
  6455598
  6455708
  6455801
  6455842
  6456118
  6456160
  6456429
  6456456
  6456513
  6456516
  6456521
  6456645
  6456675
  6456801
  6456821
  6456825
  6456838
  6456869
  6457009
  6457041
  6457345
  6457423
  6457457
  6457646
  6457671
  6458877
  6459180
  6459499
  6460156
  6460244
  6460545
  6461304
  6461615
  6461915
  6462504
  6465859
  6465933
  6465935
  6466732
  6466779
  6466914
  6467080
  6468747
  6468951
  6469580
  6469856
  6470773
  6471303
  6471400
  6471562
  6472018
  6472033
  6472234
  6472777
  6472998
  6473558
  6474860
  6475565
  6475632
  6476238
  6477063
  6477088
  6477157
  6477893
  6478190
  6480634
  6480718
  6480865
  6480866
  6481039
  6481725
  6481902
  6482033
  6482438
  6482607
  6482941
  6483027
  6483263
  6483617
  6483725
  6484093
  6484113
  6484645
  6485197
  6485581
  6486545
  6486634
  6486791
  6488371
  6488372
  6488379
  6488961
  6489090
  6489726
  6490066
  6491058
  6491073
  6493886
  6494510
  6494889
  6495053
  6495326
  6495416
  6495429
  6496595
  6496721
  6496730
  6496749
  6496812
  6496889
  6496908
  6497201
  6497264
  6497280
  6497309
  6497388
  6497469
  6497805
  6497806
  6498262
  6498523
  6498579
  6498748
  6498984
  6499050
  6499102
  6499506
  6499565
  6499787
  6499798
  6499812
  6499880
  6500002
  6500075
  6500077
  6500215
  6500262
  6500816
  6500850
  6501190
  6501625
  6501847
  6502433
  6502565
  6502642
  6502718
  6502857
  6503295
  6503340
  6503341
  6503394
  6503655
  6503798
  6503922
  6504013
  6504249
  6504252
  6504480
  6505403
  6506004
  6506052
  6506081
  6506311
  6506380
  6506911
  6507706
  6508993
  6510528
  6511010
  6512677
  6512709
  6512837
  6512929
  6512945
  6513123
  6517371
  6520005
  6520193
  6521912
  6522979
  6523395
  6523641
  6523923
  6524343
  6524972
  6525124
  6525355
  6525440
  6525791
  6525847
  6525891
  6525923
  6526139
  6526250
  6526347
  6526488
  6526610
  6526703
  6526777
  6526948
  6527195
  6527263
  6527269
  6527287
  6527334
  6527601
  6528130
  6528206
  6528913
  6529354
  6530052
  6530395
  6530525
  6530536
  6531157
  6531252
  6532714
  6532868
  6532874
  6532920
  6533494
  6533522
  6533586
  6534368
  6534503
  6535024
  6535114
  6409340
  6535778
  6535800
  6535913
  6536390
  6536950
  6537345
  6537793
  6537971
  6538277
  6538375
  6538378
  6538748
  6538750
  6538948
  6539428
  6539456
  6539513
  6539947
  6539966
  6540069
  6540070
  6540075
  6540205
  6541040
  6541187
  6541413
  6541657
  6541722
  6541729
  6541841
  6541929
  6542200
  6542538
  1000001216
  1000001218
  1000001563
  1000001867
  1000001874
  1000001877
  1000001886
  1000001934
  1000002189
  1000002375
  1000002870
  6384994
  1000001806
  1000003916
  1000003922
  1000003929
  1000003959
  1000004876
  1000001265
  1000004892
  1000006019
  1000006461
  1000006462
  1000006712
  1000006804
  1000007561
  1000007677
  1000007706
  1000007922
  1000008279
  1000007195
  1000008705
  1000008931
  1000007993
  1000004270
  1000006610
  1000010214
  1000010672
  1000011863
  1000011920
  1000012061
  1000012125
  1000010960
  1000012161
  1000012559
  1000012603
  1000012853
  1000012660
  1000013132
  1000010070
  1000012077
  1000013345
  1000012298
  1000004777
  1000013691
  1000013875
  1000013877
  1000013893
  1000008349
  1000013907
  1000004488
  1000014215
  1000014471
  1000014932
  1000012604
  1000014652
  1000015157
  1000009463
  1000015412
  1000015424
  1000015709
  1000015739
  1000009475
  1000016298
  1000016299
  1000016322
  1000016323
  1000016324
  1000016325
  1000016327
  1000016328
  1000016329
  1000016330
  1000016338
  1000016339
  1000016341
  1000016342
  1000016345
  1000016347
  1000016348
  1000016349
  1000016350
  1000016351
  1000016352
  1000013050
  1000015289
  1000017683
  1000017684
  1000017698
  1000018091
  1000015689
  1000018728
  1000018901
  1000018902
  1000018903
  1000018904
  1000018681
  1000012402
  1000020572
  1000020769
  1000020845
  1000020851
  1000020997
  1000014167
  1000021241
  1000022082
  1000016362
  1000014079
  1000022479
  1000022691
  1000023331
  1000023332
  1000023926
  1000012700
  1000022765
  1000022505
  1000010252
  1000021242
  1000027578
  1000027581
  1000027605
  1000007576
  1000028604
  1000029113
  1000021849
  1000014410
  1000030693
  1000030696
  1000030697
  1000030698
  1000030740
  1000030741
  1000030742
  1000030745
  1000030746
  1000030749
  1000030750
  1000030753
  1000030756
  1000030758
  1000030759
  1000030779
  1000032032
  1000032206
  1000033468
  1000033607
  1000033730
  1000034500
  1000034501
  1000034502
  1000034641
  1000034811
  1000035512
  1000035527
  1000035529
  1000035535
  1000035538
  1000035539
  1000035545
  1000035547
  1000035829
  1000036464
  1000036466
  1000037031
  1000037032
  1000037033
  1000037034
  1000037035
  1000037036
  1000037037
  1000037038
  1000037039
  1000037040
  1000037041
  1000037042
  1000037043
  1000037044
  1000037045
  1000037046
  1000037568
  1000037730
  1000037731
  1000037733
  1000040114
  1000040130
  1000039991
  1000036471
  1000030700
  1000039089
  1000041788
  1000041820
  1000041822
  1000041824
  1000041985
  1000041988
  1000041989
  1000041994
  1000042017
  1000042018
  1000042021
  1000042035
  1000042038
  1000042039
  1000042040
  1000042046
  1000042052
  1000042053
  1000042217
  1000042253
  1000042236
  1000042447
  1000042461
  1000043032
  1000043060
  1000043061
  1000043062
  1000043066
  1000043070
  1000043600
  1000043601
  1000043602
  1000043603
  1000034763
  1000044175
  1000044192
  1000044205
  1000044215
  1000044296
  1000044308
  1000044532
  1000032266
  1000044616
  1000044637
  1000044655
  1000045039
  1000045041
  1000045525
  1000045532
  1000045907
  1000045911
  1000045961
  1000046881
  1000047438
  1000047653
  1000047844
  1000048374
  1000048738
  1000049186
  1000049238
  1000049858
  1000049861
  1000049877
  1000039448
  1000048559
  1000048000
  1000050921
  1000051039
  1000051228
  1000048839
  1000014080
  1000052158
  1000052224
  1000052258
  1000052231
  1000052737
  1000052797
  1000048997
  1000052996
  1000053209
  1000053295
  1000053299
  1000053416
  1000053528
  1000053539
  1000047654
  1000053573
  1000053614
  1000053615
  1000050270
  1000052104
  1000052758
  1000050981
  1000053966
  1000054390
  1000054685
  1000053414
  1000054705
  1000055020
  1000055034
  1000015437
  1000055525
  1000055540
  1000056076
  1000051524
  1000056310
  1000056419
  1000056526
  1000056619
  1000053912
  1000057397
  1000057399
  1000057400
  1000057402
  1000057403
  1000057433
  1000057458
  1000057526
  1000057766
  1000057861
  1000057867
  1000057922
  1000057979
  1000057989
  1000058229
  1000056712
  1000059090
  1000059199
  1000059579
  1000060054
  1000060070
  1000058551
  1000060297
  1000060311
  1000059470
  1000060614
  1000060640
  1000060648
  1000060649
  1000061216
  1000061941
  1000060256
  1000062231
  1000062375
  1000062510
  1000062711
  1000062712
  1000062763
  1000062797
  1000062194
  1000063095
  1000063123
  1000063523
  1000063634
  1000053876
  1000063912
  1000063957
  1000063962
  1000064250
  1000064335
  1000064441
  1000064526
  1000063864
  1000064439
  1000064938
  1000064940
  1000063583
  1000064993
  1000064234
  1000065046
  1000065048
  1000065057
  1000048784
  1000061821
  1000054417
  1000057545
  1000065772
  1000065836
  1000065059
  1000065948
  1000065950
  1000065951
  1000065789
  1000066290
  1000060261
  240
]
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:
[
  239
]
21 0.22 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:
[
  238
]
22 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:
[
  237
]
23 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:
[
  21052
]
24 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:
[
  11358
]
25 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:
[
  65561
]
26 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:
[
  56130
]
27 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:
[
  5496
]
28 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:
[
  9651
]
29 0.17 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  5240
]
30 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
31 0.28 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.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  16
]
33 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  17
]
34 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  18
]
35 0.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:
[
  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.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  22
]
39 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  23
]
40 0.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.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  25
]
42 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  26
]
43 0.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:
[
  27
]
44 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:
[
  28
]
45 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  29
]
46 0.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:
[
  30
]
47 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
]
48 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:
[
  32
]
49 0.32 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
  240
]
50 0.95 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:
[
  "01520"
  "01521"
  "01522"
  "70366"
]

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 986
App\Entity\Catalog\ProductCatalog 331
App\Entity\Catalog\CustomerCatalog 331
App\Entity\Customer\Customer 289
App\Entity\Delivery\Delivery 275
App\Entity\User\User 219
App\Entity\Product\Market 136
App\Entity\Internal\Commercial 68
App\Entity\Pricing\Price 53
App\Entity\Product\ProductPrice 49
App\Entity\Product\Product 22
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 21
App\Entity\Product\CharacteristicLabel 21
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 4
App\Entity\Pricing\Promotion 1
App\Entity\Internal\Parameter 1
App\Infrastructure\Doctrine\Entity\ProductRule 1