GET https://staging.pgdis.com/produit/16685-pinceaux-et-brosses-couleur-n-c-24139-p

Query Metrics

97 Database Queries
23 Different statements
1220.45 ms Query time
0 Invalid entities
1141 Managed entities

Queries

Group similar statements

# Time Info
1 3.92 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:
[
  "16685-pinceaux-et-brosses-couleur-n-c-24139-p"
]
2 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:
[
  2693
]
3 0.50 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:
[
  "16685-pinceaux-et-brosses-couleur-n-c-24139-p"
]
4 0.37 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:
[
  "16685-pinceaux-et-brosses-couleur-n-c-24139-p"
]
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:
[
  2693
  1
]
6 0.76 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:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
  394
  2693
]
7 0.21 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:
[
  924
]
8 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  925
]
9 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:
[
  1266
]
10 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1267
]
11 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:
[
  1270
]
12 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:
[
  1271
]
13 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1279
]
14 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:
[
  1395
]
15 0.21 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:
[
  1420
]
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:
[
  1532
]
17 0.26 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 266.02 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:
[
  2693
  "2025-04-12 15:00:32"
]
19 924.09 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[
  6377093
  6377112
  6394536
  6407711
  6408612
  6408955
  6408956
  6409969
  6409970
  6409971
  6409972
  6409973
  6409974
  6409975
  6409976
  6409981
  6409982
  6409983
  6409984
  6409985
  6409986
  6409987
  6409988
  6420869
  6423546
  6423547
  6423548
  6423549
  6423550
  6423551
  6423552
  6423553
  6423555
  6423558
  6423559
  6423561
  6423562
  6423563
  6423564
  6423565
  6423566
  6423567
  6428234
  6428238
  6428244
  6428246
  6429488
  6434837
  6434847
  6434858
  6434865
  6445268
  6445291
  6445316
  6452192
  6452193
  6468224
  6468227
  6469414
  6469419
  6469591
  6470882
  6470883
  6470920
  6470922
  6472388
  6472390
  6473274
  6473280
  6478094
  6478140
  6478156
  6478169
  6478183
  6478191
  6478317
  6478976
  6479466
  6479887
  6480347
  6480359
  6480372
  6480459
  6480472
  6480485
  6480503
  6480520
  6480550
  6480573
  6480596
  6480665
  6480680
  6481220
  6481241
  6481252
  6481274
  6481297
  6481323
  6481341
  6481347
  6481348
  6481372
  6481392
  6481413
  6481437
  6481471
  6481505
  6481547
  6481588
  6481794
  6481796
  6482781
  6483010
  6483026
  6483046
  6483080
  6483107
  6483123
  6483132
  6485018
  6485021
  6485574
  6485599
  6485616
  6485628
  6486921
  6487108
  6487637
  6487907
  6488162
  6488268
  6488282
  6488302
  6488309
  6488392
  6488401
  6488415
  6488429
  6488439
  6488473
  6488506
  6488526
  6488566
  6491333
  6491335
  6491364
  6491365
  6491471
  6491577
  6491599
  6491606
  6491614
  6491666
  6491794
  6494428
  6494431
  6494708
  6494779
  6494781
  6495863
  6496067
  6496198
  6501313
  6501314
  6501315
  6501316
  6501317
  6501318
  6501319
  6501320
  6501321
  6501322
  6501323
  6501324
  6501325
  6501326
  6501327
  6501328
  6501331
  6501333
  6501335
  6501336
  6501337
  6501338
  6501339
  6501340
  6501341
  6501342
  6501344
  6501346
  6501347
  6501349
  6501351
  6501352
  6501353
  6501354
  6501355
  6501356
  6501357
  6501358
  6501359
  6501360
  6501361
  6501362
  6501363
  6501364
  6507161
  6507672
  6507674
  6507799
  6507819
  6507853
  6507856
  6508709
  6508741
  6510279
  6510298
  6510303
  6510309
  6510312
  6510313
  6510315
  6510318
  6510320
  6510323
  6510331
  6510340
  6510693
  6510436
  6515119
  6515179
  6515181
  6515231
  6515606
  6515608
  6515638
  6515640
  6515654
  6515658
  6515671
  6515672
  6515712
  6515713
  6515718
  6515719
  6515722
  6515724
  6515734
  6515736
  6515754
  6515755
  6515766
  6515767
  6515793
  6515795
  6515892
  6515893
  6515996
  6515997
  6516052
  6516972
  6516984
  6516994
  6517007
  6517030
  6517041
  6517054
  6517247
  6517268
  6517275
  6517279
  6517363
  6517373
  6517396
  6517412
  6517430
  6517451
  6517463
  6517473
  6517482
  6517854
  6517856
  6518174
  6518244
  6518248
  6518344
  6518347
  6518480
  6518481
  6518622
  6518623
  6519274
  6519275
  6519283
  6519286
  6519297
  6519298
  6519312
  6519314
  6519476
  6519477
  6519525
  6519527
  6519545
  6519548
  6520057
  6520059
  6520106
  6520139
  6520140
  6520824
  6523293
  6523321
  6525123
  6525219
  6525767
  6525918
  6527922
  6527951
  6527952
  6527953
  6527954
  6527955
  6527956
  6527959
  6527960
  6527961
  6527962
  6527963
  6527964
  6527965
  6527966
  6527967
  6527968
  6527970
  6527971
  6527972
  6527973
  6527974
  6527975
  6527976
  6527977
  6527978
  6527979
  6527980
  6527982
  6527983
  6527984
  6527985
  6527987
  6527988
  6527989
  6527990
  6527993
  6527994
  6527995
  6527997
  6527998
  6527999
  6528000
  6528001
  6528269
  6530159
  6539760
  1000045731
  1000045732
  1000045733
  1000045734
  1000045735
  1000045736
  1000045737
  1000045738
  1000045739
  1000045740
  1000045741
  1000045742
  1000045743
  1000045744
  1000045745
  1000045746
  1000045748
  1000045749
  1000045750
  1000045751
  1000045752
  1000045753
  1000045754
  1000048022
  1000048358
  1000050501
  1000051591
  1000051637
  1000051638
  1000051641
  1000051644
  1000051649
  1000051651
  1000051668
  1000051672
  1000051673
  1000051674
  1000051675
  1000051679
  1000051680
  1000051783
  1000051793
  1000051794
  1000051814
  1000051860
  1000051863
  1000051865
  1000051866
  1000051916
  1000051982
  1000052052
  1000052055
  1000052056
  1000052057
  1000052070
  1000052071
  1000052114
  1000052123
  1000052128
  1000052132
  1000052135
  1000052148
  1000052150
  1000052185
  1000052188
  1000052210
  1000052271
  1000052272
  1000052273
  1000052276
  1000052278
  1000052389
  1000052406
  1000052411
  1000052412
  1000052421
  1000052422
  1000052464
  1000052644
  1000052646
  1000052648
  1000052658
  1000052661
  1000052691
  1000052693
  1000052709
  1000052730
  1000052828
  1000052846
  1000052848
  1000052850
  1000052851
  1000052853
  1000052855
  1000052856
  1000052857
  1000052899
  1000052904
  1000052910
  1000052956
  1000053039
  1000053080
  1000053102
  1000053103
  1000053432
  1000053441
  1000051727
  1000053462
  1000038378
  1000053601
  1000053602
  1000053681
  1000053691
  1000053692
  1000053744
  1000053755
  1000053756
  1000053805
  1000053808
  1000053809
  1000053810
  1000053866
  1000053868
  1000053870
  1000053872
  1000053875
  1000053995
  1000053999
  1000054041
  1000054042
  1000054044
  1000054055
  1000054056
  1000054057
  1000054133
  1000054139
  1000054132
  1000054159
  1000054200
  1000054403
  1000054512
  1000054553
  1000054557
  1000054559
  1000054561
  1000054567
  1000054569
  1000054587
  1000054855
  1000054944
  1000054946
  1000054947
  1000054968
  1000054975
  1000054986
  1000054990
  1000055086
  1000055177
  1000055217
  1000055252
  1000055255
  1000055259
  1000055276
  1000055303
  1000055308
  1000055359
  1000055369
  1000055392
  1000055393
  1000055545
  1000055550
  1000055552
  1000055683
  1000055762
  1000055788
  1000055789
  1000055790
  1000055791
  1000055792
  1000055822
  1000055823
  1000055824
  1000055826
  1000055895
  1000055900
  1000055902
  1000055913
  1000055958
  1000055984
  1000055997
  1000056080
  1000056081
  1000056128
  1000056129
  1000056137
  1000056160
  1000056163
  1000056245
  1000056248
  1000056264
  1000056328
  1000056329
  1000056330
  1000056333
  1000056331
  1000056340
  1000056342
  1000056350
  1000056396
  1000056397
  1000056405
  1000056433
  1000056434
  1000056436
  1000056437
  1000056439
  1000056478
  1000056479
  1000056502
  1000056518
  1000056595
  1000056663
  1000056681
  1000056696
  1000056700
  1000056750
  1000056752
  1000056753
  1000056769
  1000056770
  1000056795
  1000056799
  1000056800
  1000056801
  1000056808
  1000056829
  1000056967
  1000056968
  1000054129
  1000057057
  1000057070
  1000057071
  1000057072
  1000057171
  1000057277
  1000057346
  1000057347
  1000057401
  1000057410
  1000057412
  1000057554
  1000057555
  1000057570
  1000057580
  1000057588
  1000057589
  1000057590
  1000057591
  1000057593
  1000057752
  1000057798
  1000056748
  1000058066
  1000058069
  1000058090
  1000058113
  1000058125
  1000058128
  1000058129
  1000058130
  1000058131
  1000058132
  1000058133
  1000058162
  1000058163
  1000058170
  1000058178
  1000058179
  1000058180
  1000058181
  1000058175
  1000058182
  1000058282
  1000058595
  1000058602
  1000058822
  1000058897
  1000058901
  1000058917
  1000058919
  1000058920
  1000058927
  1000059005
  1000059074
  1000059087
  1000059118
  1000059122
  1000059180
  1000059183
  1000059182
  1000059242
  1000059341
  1000059342
  1000059343
  1000059346
  1000059349
  1000059350
  1000059354
  1000059370
  1000059449
  1000059451
  1000059452
  1000059461
  1000059462
  1000059463
  1000059489
  1000059665
  1000059692
  1000059693
  1000059694
  1000059695
  1000059696
  1000059711
  1000059712
  1000059713
  1000059719
  1000059720
  1000059721
  1000059737
  1000059738
  1000059739
  1000059753
  1000059810
  1000059816
  1000059835
  1000059846
  1000059856
  1000059860
  1000059862
  1000059877
  1000059889
  1000059890
  1000059925
  1000059929
  1000059930
  1000059974
  1000060037
  1000060038
  1000060134
  1000060216
  1000060283
  1000060320
  1000060322
  1000060342
  1000060407
  1000060455
  1000060475
  1000060476
  1000060477
  1000060488
  1000060518
  1000060617
  1000060619
  1000060621
  1000060622
  1000060623
  1000060624
  1000060637
  1000060638
  1000060670
  1000060671
  1000060672
  1000060673
  1000060674
  1000060675
  1000060676
  1000060758
  1000060906
  1000060907
  1000061004
  1000061005
  1000061012
  1000061017
  1000061018
  1000061019
  1000061031
  1000061032
  1000061033
  1000061040
  1000061077
  1000061079
  1000061149
  1000061151
  1000061152
  1000061153
  1000061177
  1000061226
  1000061233
  1000061234
  1000061245
  1000061246
  1000061269
  1000061384
  1000061422
  1000061526
  1000061636
  1000061637
  1000061638
  1000061719
  1000061884
  1000061885
  2693
]
20 0.43 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  152709
]
21 0.20 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  9840
]
22 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:
[
  9527
]
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:
[
  2548
]
24 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  166928
]
25 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  348747
]
26 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  991
]
27 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:
[
  166931
]
28 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  9529
]
29 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:
[
  9616
]
30 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.id = ? LIMIT 1
Parameters:
[
  1
]
31 0.29 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.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:
[
  16
]
33 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:
[
  17
]
34 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:
[
  18
]
35 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  19
]
36 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  20
]
37 0.34 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.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:
[
  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.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:
[
  24
]
41 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:
[
  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.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.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  30
]
47 0.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.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:
[
  32
]
49 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
50 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "MOZ"
]
51 0.17 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
52 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefaut"
]
53 0.16 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
]
54 0.70 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
  2693
]
55 0.34 ms
SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[
  2693
  0
]
56 0.27 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  "C"
  2693
]
57 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
58 0.24 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[
  2693
  "C"
]
59 0.36 ms
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
  2693
]
60 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
61 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "MOZ"
]
62 0.16 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
63 0.31 ms
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
  2693
]
64 0.31 ms
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[
  "2025-09-12 15:00:33"
  "%2%"
  2693
]
65 0.68 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[
  2693
  7
]
66 0.27 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:
[
  2693
]
67 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
68 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "MOZ"
]
69 0.25 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
70 0.89 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
  9529
]
71 1.00 ms
SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[
  9529
  0
]
72 0.28 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  "C"
  9529
]
73 0.29 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  9529
]
74 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
75 0.23 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[
  9529
  "C"
]
76 0.45 ms
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
  9529
]
77 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
78 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "MOZ"
]
79 0.21 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
80 0.33 ms
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
  9529
]
81 0.49 ms
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[
  "2025-09-12 15:00:33"
  "%2%"
  9529
]
82 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
83 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "MOZ"
]
84 0.17 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
85 0.94 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
  9616
]
86 0.31 ms
SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[
  9616
  0
]
87 0.33 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  "C"
  9616
]
88 0.24 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  9616
]
89 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
90 0.26 ms
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[
  9616
  "C"
]
91 0.32 ms
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
  9616
  9960313
]
92 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TarifDefautBtoB"
]
93 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "MOZ"
]
94 0.18 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
95 0.25 ms
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
  9616
]
96 0.25 ms
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[
  "2025-09-12 15:00:33"
  "%2%"
  9616
]
97 0.63 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[
  9616
  7
]

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 775
App\Entity\User\User 170
App\Entity\Delivery\Delivery 63
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Customer\Customer 19
App\Entity\Internal\Commercial 11
App\Entity\Product\Market 11
App\Entity\Pricing\Price 9
App\Entity\Product\Characteristic 9
App\Entity\Product\CharacteristicLabel 9
App\Entity\Product\ProductPrice 7
App\Entity\Internal\Society 5
App\Entity\Delivery\DeliveryCost 4
App\Entity\Internal\Parameter 3
App\Entity\Catalog\ProductCatalog 2
App\Entity\Catalog\CustomerCatalog 2