GET https://staging.pgdis.com/produit/78768-produits-d%27entretien-couleur-n-c-dc00

Query Metrics

99 Database Queries
16 Different statements
2080.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1195.90 ms
(57.48%)
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:
[
  106050
  "2024-11-04 22:21:33"
]
751.93 ms
(36.14%)
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 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:
[
  6257399
  6257609
  6257680
  6243252
  6257774
  6258235
  6246143
  6243655
  6238857
  6258644
  6258763
  6258767
  6258868
  6258997
  6247950
  6259129
  6259324
  6259357
  6259467
  6259650
  6260008
  6260162
  6260245
  6260357
  6260607
  6260781
  6260912
  6260948
  6260981
  6261676
  6262510
  6266171
  6266787
  6266977
  6267063
  6267938
  6268306
  6261286
  6190593
  6269359
  6267369
  6269584
  6269607
  6269661
  6269667
  6270094
  6270396
  6270657
  6270735
  6270068
  6271321
  6271621
  6271710
  6272201
  6272304
  6273080
  6275136
  6265701
  6275743
  6276011
  6273913
  6271646
  6276262
  6276694
  6276770
  6276851
  6276323
  6277260
  6277289
  6275498
  6277513
  6277076
  6277401
  6278193
  6274512
  6278385
  6278569
  6278636
  6278823
  6280369
  6281153
  6281171
  6281515
  6281529
  6282181
  6282415
  6282601
  6282903
  6283024
  6283062
  6283511
  6283680
  6284721
  6284919
  6286436
  6286935
  6287385
  6287393
  6287434
  6287436
  6287443
  6289097
  6289798
  6290080
  6290232
  6288405
  6290641
  6290875
  6289846
  6289481
  6289030
  6291537
  6292121
  6292234
  6268394
  6292252
  6292452
  6292559
  6292472
  6292549
  6292421
  6293125
  6293135
  6293159
  6293762
  6294042
  6294223
  6294394
  6294776
  6293036
  6291044
  6271384
  6295469
  6295760
  6296067
  6295393
  6290950
  6296636
  6296924
  6296931
  6297102
  6297589
  6297611
  6297654
  6297671
  6246582
  6298746
  6298674
  6299446
  6298635
  6299627
  6299533
  6300122
  6300120
  6300141
  6300138
  6300139
  6300168
  6300206
  6300682
  6300687
  6300701
  6300792
  6301092
  6301251
  6301343
  6299522
  6301246
  6301649
  6301801
  6301867
  6302493
  6302037
  6300869
  6302811
  6302821
  6303202
  6303215
  6303222
  6303506
  6303677
  6301858
  6303985
  6304032
  6304040
  6304103
  6303730
  6304159
  6304190
  6304218
  6304287
  6304359
  6305752
  6305769
  6305871
  6306517
  6307185
  6307420
  6307673
  6308286
  6308476
  6308563
  6308564
  6308659
  6308818
  6308832
  6308840
  6309103
  6309108
  6309236
  6303889
  6309531
  6309725
  6309800
  6310310
  6310317
  6310446
  6310666
  6310583
  6310805
  6310851
  6311113
  6311132
  6311174
  6311298
  6311375
  6311378
  6311398
  6311419
  6311626
  6311667
  6311669
  6311662
  6311690
  6311737
  6311749
  6311808
  6311819
  6311821
  6311904
  6309347
  6309235
  6312041
  6312059
  6312135
  6312142
  6312178
  6312232
  6312245
  6312246
  6312247
  6312321
  6312330
  6312373
  6312553
  6312558
  6312698
  6312782
  6312625
  6312794
  6312876
  6313115
  6313141
  6313175
  6313269
  6313466
  6313470
  6313506
  6313516
  6313549
  6297910
  6314055
  6314281
  6314330
  6314746
  6314809
  6314360
  6315972
  6316048
  6314534
  6316213
  6316724
  6316778
  6316850
  6316933
  6317060
  6317475
  6317514
  6318265
  6318284
  6318529
  6318565
  6318591
  6318718
  6319004
  6319123
  6319231
  6319244
  6319322
  6319329
  6319348
  6319395
  6319407
  6319414
  6319497
  6319561
  6319481
  6319767
  6319826
  6319878
  6320005
  6320411
  6320802
  6320834
  6320846
  6321069
  6321242
  6321477
  6321650
  6321949
  6323424
  6323604
  6323655
  6324102
  6324416
  6324998
  6325314
  6325286
  6325442
  6325524
  6325578
  6325609
  6325659
  6325620
  6325807
  6325939
  6326913
  6327272
  6327371
  6327504
  6327523
  6327756
  6328061
  6328127
  6328255
  6328514
  6328569
  6328851
  6328858
  6329229
  6329249
  6329547
  6329756
  6329867
  6329981
  6330131
  6330222
  6330248
  6330260
  6330268
  6330271
  6326129
  6330598
  6330755
  6330894
  6331087
  6331512
  6324053
  6331616
  6331977
  6332095
  6332299
  6334095
  6326136
  6335591
  6335760
  6335779
  6335928
  6335944
  6336313
  6336382
  6335464
  6336718
  6336937
  6336972
  6337559
  6337831
  6337837
  6336610
  6338012
  6337453
  6338553
  6338693
  6338894
  6339155
  6339380
  6339625
  6338947
  6338960
  6340199
  6340438
  6340459
  6340708
  6340806
  6340742
  6341020
  6341068
  6341187
  6341207
  6341268
  6333309
  6341442
  6341594
  6341660
  6341707
  6341742
  6341453
  6342384
  6343363
  6343642
  6344957
  6345059
  6345776
  6346367
  6346451
  6346588
  6347485
  6347551
  6347684
  6347702
  6348504
  6348811
  6348846
  6348968
  6349181
  6349538
  6349956
  6350112
  6350465
  6350473
  6350503
  6350699
  6350748
  6351103
  6351598
  6351794
  6351798
  6351635
  6352388
  6334938
  6336529
  6352974
  6352987
  6353307
  6353816
  6354009
  6354538
  6354812
  6354997
  6344228
  6355080
  6356263
  6356532
  6356286
  6353292
  6357307
  6357381
  6357491
  6358442
  6357730
  6359164
  6359592
  6359728
  6359735
  6360095
  6359931
  6360257
  6358676
  6359524
  6360401
  6360457
  6360597
  6360788
  6360753
  6358452
  6361061
  6352940
  6360940
  6361233
  6361276
  6361513
  6361544
  6361565
  6361621
  6361729
  6361760
  6361877
  6324835
  6362078
  6362120
  6362601
  6356713
  6362721
  6362905
  6363048
  6363193
  6363626
  6363756
  6363793
  6364188
  6364501
  6364155
  6364714
  6364771
  6365066
  6365219
  6365502
  6365655
  6365190
  6366389
  6366544
  6367815
  6367851
  6368067
  6366829
  6368684
  6368847
  6369772
  6370099
  6370126
  6370292
  6370399
  6370815
  6371156
  6371380
  6371498
  6372186
  6372750
  6372880
  6372978
  6373578
  6373581
  6373586
  6373589
  6373855
  6374038
  6374165
  6375045
  6375475
  6376006
  6376789
  106050
]
71.95 ms
(3.46%)
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:
[
  "78768-produits-d'entretien-couleur-n-c-dc00"
]
22.46 ms
(1.08%)
21
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"
  106050
]
13.37 ms
(0.64%)
20
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:
[
  1933
  7
]
9.16 ms
(0.44%)
21
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 <= ? ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[
  106050
  0
]
4.95 ms
(0.24%)
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:
[
  106050
  1
]
3.61 ms
(0.17%)
20
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:
[
  1933
]
2.40 ms
(0.12%)
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 LIMIT 10
Parameters:
[
  66
  314
  315
  316
  317
  316
  106050
]
1.20 ms
(0.06%)
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_.category_parent_id IS NULL
Parameters:
[]
1.10 ms
(0.05%)
5
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:
[
  66
]
0.74 ms
(0.04%)
1
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 WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
  106050
]
0.70 ms
(0.03%)
2
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"
]
0.44 ms
(0.02%)
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.37 ms
(0.02%)
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.is_in_footer = ?
Parameters:
[
  1
]
0.20 ms
(0.01%)
1
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
]

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.