GET https://staging.pgdis.com/produit/15011-marqueurs-effacables-noir-bic-1791-09

Query Metrics

29 Database Queries
12 Different statements
1038.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
574.18 ms
(55.27%)
1
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:
[
  6343227
  6345822
  6348054
  6348170
  6348432
  6349524
  6351241
  6353381
  6358495
  6359834
  6351707
  6360574
  6362968
  6363961
  6364455
  6364495
  6365213
  6366242
  6366320
  6369281
  6370217
  6370777
  6370789
  6372153
  6372355
  6372774
  6377625
  6378069
  6379067
  6385269
  6385276
  6387330
  6391432
  6391683
  6389573
  6393982
  6395972
  6396651
  6399274
  6399287
  6401752
  6404535
  6404703
  6405988
  6406565
  6408843
  6408908
  6410036
  6410379
  6410702
  6410993
  6411729
  6412710
  6412973
  6413735
  6414258
  6414974
  6415154
  6416093
  6416110
  6416184
  6416814
  6416832
  6416860
  6417091
  6418171
  6418844
  6418942
  6419357
  6420267
  6420594
  6420748
  6421604
  6422230
  6422380
  6422618
  6422848
  6423188
  6423684
  6424050
  6424147
  6424306
  6424387
  6424661
  6425068
  6425305
  6425694
  6426195
  6426199
  6426349
  6426745
  6426824
  6426962
  6427012
  6427274
  6427649
  6427894
  6428124
  6428183
  6428581
  6429088
  6429343
  6429697
  6429797
  6430112
  6430286
  6430491
  6430860
  6430882
  6431774
  6431856
  6431864
  6432152
  6434330
  6434449
  6436710
  6437815
  6438089
  6438091
  6438798
  6439623
  6441486
  6443241
  6443487
  6443790
  6443886
  6444084
  6444333
  6444335
  6444577
  6444758
  6444967
  6445318
  6445327
  6445776
  6446133
  6446959
  6447279
  6447306
  6447321
  6447340
  6449398
  6449500
  6449843
  6449879
  6450174
  6450186
  6450222
  6450272
  6450281
  6450635
  6450864
  6451023
  6451085
  6451129
  6451214
  6451221
  6451236
  6451240
  6451252
  6451389
  6451393
  6451394
  6451398
  6451421
  6451438
  6451439
  6451545
  6451616
  6451707
  6451765
  6451792
  6451803
  6451915
  6452019
  6452179
  6452425
  6452832
  6452965
  6453206
  6454542
  6454560
  6454562
  6454582
  6454935
  6455142
  6455220
  6455267
  6455305
  6455317
  6455318
  6455343
  6455390
  6455487
  6455625
  6455723
  6456072
  6456256
  6456525
  6457209
  6457720
  6457825
  6458461
  6458497
  6459180
  6459205
  6459423
  6460944
  6460959
  6461527
  6461649
  6461670
  6461848
  6464266
  6465378
  6466886
  6468576
  6468752
  6468895
  1000000983
  1000002090
  1000002591
  1000002614
  1000002707
  1000002731
  1000002848
  1000002465
  1000004915
  6389079
  1000006484
  1000006595
  1000002476
  1000006200
  1000005937
  1000007849
  1000008056
  1000004320
  1000008848
  1000002230
  1000009420
  1000009540
  1000009858
  1000010509
  1000010214
  1000010400
  1000009837
  1000013004
  1000013074
  1000012806
  1000011083
  1000011869
  1000013135
  1000012432
  1000012104
  1000011994
  1000011911
  1000007983
  1000008505
  1000009125
  1000005361
  1000014481
  1000012655
  1000014882
  1000014102
  1000014934
  1000014971
  1000012718
  1000012236
  1000011076
  1000001135
  1000013264
  1000015476
  1000015555
  1000017047
  1000018370
  1000016084
  1000019467
  1000013106
  1000016076
  1000004922
  6378747
  1000012396
  1000014324
  1000019469
  1000016421
  1000021786
  1000021789
  1000021793
  1000021794
  1000021795
  1000021800
  1000021801
  1000021169
  1000021805
  1000013935
  1000012612
  1000022676
  1000016551
  1000022829
  1000024511
  1000024512
  1000024522
  1000024624
  1000024626
  1000012892
  1000026011
  1000026012
  1000026013
  1000026018
  1000026020
  1000026024
  1000026054
  1000026475
  1000026485
  1000026487
  1000026488
  1000026489
  1000026491
  1000026492
  1000026493
  1000026496
  1000026608
  1000026659
  1000026685
  1000026895
  1000026899
  1000026695
  1000027421
  1000028834
  1000028839
  1000015090
  1000028939
  1000024630
  1000029866
  1000029903
  1000029915
  1000029939
  1000030138
  1000030139
  1000032356
  1000032399
  1000032403
  1000032410
  1000032413
  1000032420
  1000032432
  1000032437
  1000024965
  1000016670
  1000033344
  1000029293
  1000034583
  1000034827
  1000034828
  1000034829
  1000034984
  1000034990
  1000035000
  1000035743
  1000035007
  1000036155
  1000036191
  1000036478
  1000036483
  1000036484
  1000035153
  1000036758
  1000037549
  1000037551
  1000037557
  1000037778
  1000038935
  1000039124
  1000039150
  1000039189
  1000039212
  1000040795
  1000040796
  1000041026
  1000041562
  1000041566
  1000041567
  1000041576
  1000041577
  1000041858
  1000041859
  1000041860
  1000041861
  1000041862
  1000041863
  1000041865
  1000041866
  1000041869
  1000041876
  1000041877
  1000041878
  1000041880
  1000041881
  1000041882
  1000041883
  1000041885
  1000041894
  1000041895
  1000041896
  1000042016
  1000042022
  1000042025
  1000042188
  1000042189
  1000042364
  1000041721
  1000043026
  1000043091
  1000041523
  1000043970
  1000044192
  1000044205
  1000044215
  1000044296
  1000044308
  1000044609
  1000045023
  1000045106
  1000045314
  1000045341
  1000045391
  1000045396
  1000045614
  1000045713
  1000021815
  1000046114
  1000046115
  1000046148
  1000046194
  1000046197
  1000046201
  1000046208
  1000046219
  1000046258
  1000047251
  1000047264
  1000047528
  1000047660
  1000047730
  1000047736
  1000047737
  1000047746
  1000047738
  1000047819
  1000047169
  1000047742
  1000046419
  1000026055
  1000042922
  1000047941
  1000048023
  1000047265
  1000048152
  1000048545
  1000048553
  1000048556
  1000048558
  1000048970
  1000049110
  1000049755
  1000049979
  1000044463
  1000027416
  1000050130
  1000050311
  1000050313
  1000050314
  1000050315
  1000050317
  1000050487
  1000050489
  1000050683
  1000050997
  1000050685
  1000051529
  1000052093
  1000051861
  1000052248
  1000036683
  1000051886
  1000052774
  1000052796
  1000052044
  1000049484
  1000053260
  1000053146
  1000052756
  1000050346
  1000017165
  1000053180
  2001
]
301.95 ms
(29.07%)
1
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:
[
  2001
  "2025-02-12 10:00:29"
]
156.02 ms
(15.02%)
1
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:
[
  "15011-marqueurs-effacables-noir-bic-1791-09"
]
2.98 ms
(0.29%)
18
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
]
0.69 ms
(0.07%)
1
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 FROM product t0 WHERE t0.reference IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "01270"
  "01271"
  "01272"
  "01273"
  "01280"
  "01281"
  "01282"
  "01283"
  "15029"
  "15030"
  "15031"
  "15021"
  "15022"
  "15023"
  "15024"
  "15004"
  "15010"
  "15012"
  "15013"
  "15019"
  "15020"
  "15021"
  "15022"
  "15023"
  "15024"
  "15029"
  "15030"
  "15031"
]
0.64 ms
(0.06%)
1
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[
  58
  275
  276
  277
  278
  275
  2001
]
0.56 ms
(0.05%)
1
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 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "15011-marqueurs-effacables-noir-bic-1791-09"
]
0.44 ms
(0.04%)
1
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
]
0.40 ms
(0.04%)
1
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:
[
  2001
  1
]
0.38 ms
(0.04%)
1
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:
[
  "15011-marqueurs-effacables-noir-bic-1791-09"
]
0.30 ms
(0.03%)
1
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:
[
  2001
]
0.27 ms
(0.03%)
1
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"
]

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.