GET https://staging.pgdis.com/produit/classement-archivage?page=13

Query Metrics

526 Database Queries
23 Different statements
272.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
77.43 ms
(28.46%)
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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c1_.is_display_site = ?
Parameters:
[
  519
  835
  6164
  29209
  70691
  70692
  70693
  72061
  72062
  72063
  72064
  72065
  72066
  72067
  72068
  72069
  72070
  72071
  72072
  72073
  78763
  78764
  78765
  78766
  87502
  87503
  87504
  87505
  87506
  87507
  87508
  94104
  95665
  125878
  129244
  129245
  129247
  145254
  145257
  157415
  179783
  209416
  222149
  222150
  222151
  222152
  222157
  222158
  222159
  222160
  222601
  239241
  243646
  245455
  245456
  245457
  245458
  245459
  249031
  249610
  249613
  250903
  257018
  257025
  257026
  289767
  404703
  404768
  404769
  404770
  404771
  404845
  535
  536
  537
  539
  977
  978
  979
  981
  982
  983
  9317
  9338
  9339
  9341
  9510
  10198
  10199
  10200
  10201
  10202
  10203
  29371
  29372
  29373
  29374
  29387
  29388
  29389
  29390
  29391
  29392
  29393
  29394
  29395
  29426
  29427
  29428
  31256
  33389
  55075
  55077
  55078
  60187
  60275
  60276
  60278
  60280
  67909
  77076
  77080
  77085
  78757
  93743
  94432
  95844
  96533
  96534
  96742
  96743
  96745
  96746
  96747
  96752
  96754
  96756
  99595
  99596
  99603
  179060
  179061
  179062
  179063
  179064
  179065
  179066
  179067
  179068
  179069
  179070
  179071
  179072
  179073
  179074
  179075
  182252
  182270
  183057
  183058
  183059
  183060
  183061
  183062
  183063
  183064
  183065
  183066
  183067
  183068
  196510
  196511
  196512
  196513
  198443
  198444
  216707
  241182
  248478
  251130
  251136
  251140
  256044
  285463
  285464
  287150
  291076
  291083
  291086
  291121
  303565
  303568
  303569
  303570
  303571
  303572
  303573
  303574
  315564
  319146
  319151
  319153
  319463
  329078
  330388
  335327
  349001
  349002
  349027
  404267
  404369
  404401
  404426
  404547
  404576
  404577
  404578
  404579
  404580
  404581
  404582
  404583
  404584
  404585
  404586
  404593
  404760
  404956
  404966
  404975
  413345
  413382
  417690
  417694
  417713
  468607
  519619
  526
  954
  955
  956
  957
  963
  972
  973
  974
  975
  976
  1109
  5163
  5280
  5895
  5896
  5897
  5898
  5899
  5906
  5907
  5908
  5909
  5910
  5911
  5912
  5914
  5915
  5942
  5943
  5944
  5945
  5946
  5947
  5948
  5950
  5951
  6220
  6226
  6583
  7363
  7364
  7365
  8818
  8951
  8952
  8953
  9049
  9126
  9127
  9128
  9129
  9626
  9682
  9684
  9685
  9686
  9748
  10448
  11035
  11036
  11037
  11038
  11039
  11040
  26178
  26180
  26181
  26182
  26183
  26534
  26535
  27556
  28627
  28628
  28629
  29123
  29289
  29503
  31220
  33403
  53430
  54894
  54895
  59401
  63537
  63538
  64456
  67907
  70581
  70582
  70584
  70585
  70586
  70587
  70589
  70853
  70854
  70855
  70856
  70857
  70858
  70859
  70860
  71050
  71055
  72152
  72154
  72155
  72157
  72158
  72160
  72161
  72162
  72163
  72164
  72166
  72167
  72168
  72169
  72170
  72172
  72173
  72174
  72175
  72184
  72186
  72187
  72188
  72189
  72191
  72192
  72193
  72194
  72195
  73067
  73068
  73069
  73070
  73071
  73073
  73074
  73075
  73077
  78755
  79553
  79554
  79555
  79556
  79557
  79681
  80575
  80747
  84522
  84682
  85274
  85278
  85280
  85282
  85283
  85340
  92281
  92282
  92283
  92284
  93617
  93618
  93619
  93620
  93622
  93623
  93626
  93658
  93668
  93673
  93674
  93675
  93677
  93679
  93680
  93681
  93682
  93683
  93684
  93696
  93704
  93705
  93706
  93707
  93708
  93709
  93710
  93711
  93712
  93713
  93714
  94102
  94103
  94428
  94431
  96738
  96741
  96750
  97014
  101433
  101434
  101435
  101438
  101439
  101440
  101441
  101465
  101467
  123506
  123966
  123967
  131616
  136007
  143465
  145562
  146071
  163220
  163221
  164075
  164076
  164077
  164511
  168051
  170330
  170332
  170333
  170530
  170531
  170532
  170533
  172607
  177512
  183139
  184871
  185183
  185185
  185186
  196496
  196497
  196498
  196499
  196500
  198572
  203678
  205751
  205752
  205753
  205754
  205755
  215157
  215158
  215159
  215160
  215161
  215162
  215163
  215164
  215165
  215166
  215167
  215168
  215169
  215170
  215171
  215174
  215175
  215177
  215179
  216697
  216698
  216699
  216700
  216705
  216706
  219102
  219103
  219104
  219105
  219106
  219107
  219108
  239279
  240668
  240669
  240757
  240764
  240766
  240767
  240768
  240769
  240770
  240772
  240773
  240774
  240837
  240838
  242889
  242890
  242891
  242892
  243616
  243617
  246871
  248439
  248497
  259691
  259692
  259696
  259697
  259699
  259720
  260039
  260085
  260086
  261301
  282869
  285244
  285465
  285466
  285686
  296390
  303535
  314072
  315547
  315549
  315550
  315551
  315554
  315558
  330387
  338104
  339579
  339622
  339623
  339624
  339625
  339626
  346963
  403576
  403577
  403578
  403851
  404256
  404276
  404308
  404374
  404411
  404569
  404572
  404573
  404574
  404591
  404641
  404702
  404906
  404927
  413360
  417715
  417717
  417718
  417719
  417720
  417906
  417907
  418443
  418444
  420086
  469450
  469477
  469484
  513883
  519617
  519621
  519622
  519633
  519634
  664
  667
  668
  1868
  1869
  1871
  1872
  1877
  1878
  1879
  1880
  1881
  1904
  1905
  1906
  1907
  1909
  1910
  4592
  30810
  53469
  63544
  63751
  70911
  76058
  76280
  76281
  76282
  94714
  113550
  157290
  194822
  194823
  194845
  247263
  340932
  403749
  403754
  403785
  403786
  403787
  403864
  404362
  404383
  990
  991
  1003
  1032
  1036
  1037
  1038
  1039
  1040
  1041
  1042
  1052
  1053
  1058
  1059
  1073
  1074
  1075
  1076
  1172
  1173
  1174
  1179
  1187
  1189
  1190
  1746
  1747
  1748
  1818
  1819
  1820
  1821
  1823
  1824
  1825
  1826
  1827
  1828
  1833
  1834
  1838
  1839
  1995
  3223
  3977
  4418
  4906
  4907
  5482
  5483
  5997
  5998
  6199
  6200
  6208
  6564
  7459
  8958
  8959
  8983
  8984
  9450
  9501
  9502
  9857
  9858
  9859
  9860
  9861
  9862
  9863
  9864
  9865
  28307
  28308
  28309
  29008
  29009
  29010
  29011
  29189
  30739
  31240
  31255
  33387
  33388
  53401
  53428
  56596
  56597
  56598
  56599
  56997
  56998
  58840
  59365
  63398
  63552
  63553
  63554
  63555
  63664
  63665
  63666
  63667
  63668
  63669
  63670
  63671
  63672
  63673
  63674
  63675
  63676
  63677
  63678
  63679
  63680
  63681
  63682
  63683
  63684
  63685
  63686
  63687
  63688
  63689
  63690
  63691
  63692
  63693
  63694
  63695
  63696
  64139
  64599
  65480
  65484
  70317
  70578
  70579
  70849
  70850
  70874
  70875
  70876
  70877
  70878
  73107
  73111
  78370
  78371
  78738
  78744
  78745
  78746
  78747
  78927
  79560
  79565
  79567
  79568
  80744
  80745
  81113
  81114
  81115
  81116
  81117
  85306
  85307
  85346
  88521
  93703
  93733
  93734
  93735
  93736
  93737
  93738
  93739
  93740
  93741
  93742
  96775
  96776
  96779
  96780
  96781
  96782
  96783
  101064
  101444
  101453
  101454
  101472
  101473
  101474
  101482
  101483
  110251
  110252
  122480
  123505
  123991
  123992
  123993
  123994
  124012
  129233
  129234
  129235
  129236
  129237
  130863
  136833
  136834
  136835
  145563
  147954
  147958
  147959
  147974
  162603
  162604
  162605
  162606
  162607
  162608
  162609
  162610
  162611
  162612
  162699
  162700
  163219
  163600
  163602
  163603
  164095
  164096
  164097
  164098
  164099
  170328
  170329
  170347
  170348
  170349
  170534
  170535
  170536
  170537
  170538
  170539
  170540
  170541
  170542
  170543
  170544
  170545
  171834
  175034
  182676
  185663
  185664
  187459
  191782
  196508
  196509
  196540
  196541
  204734
  204735
  205549
  215181
  215182
  215183
  216703
  216704
  221583
  224144
  224570
  240610
  240615
  240833
  241258
  241259
  241260
  241261
  241262
  241263
  241264
  243643
  248483
  248498
  256825
  256847
  256959
  257386
  259683
  259689
  259690
  259700
  259701
  260072
  260073
  268440
  268906
  285467
  285468
  291443
  291444
  291445
  291446
  291449
  293850
  303551
  303582
  305412
  305413
  305414
  314070
  314071
  315502
  315548
  315553
  330389
  330396
  334525
  334598
  338103
  339612
  339613
  339614
  339615
  339616
  339617
  339618
  339619
  339620
  339621
  341031
  341032
  348524
  348526
  403774
  403788
  403961
  403962
  404396
  404410
  404467
  404535
  404542
  404716
  404717
  404757
  404758
  404759
  404815
  404880
  404882
  404897
  404947
  410979
  410980
  416697
  416698
  416700
  416702
  417916
  425381
  425382
  425383
  425384
  425561
  425562
  425563
  425564
  432150
  432160
  432161
  435185
  469220
  469486
  476858
  476859
  519609
  519610
  519611
  519618
  519635
  519636
  523739
  523740
  523741
  555281
  558459
  558461
  558466
  2860
  2861
  2862
  2863
  2864
  2865
  2866
  4216
  5535
  5539
  5540
  5541
  5542
  5543
  5544
  5545
  5546
  5547
  5548
  5549
  5550
  9610
  9611
  9612
  29300
  31628
  53429
  65422
  65424
  66003
  69897
  69898
  72118
  72119
  72120
  72121
  72122
  72123
  72128
  72131
  72132
  72133
  72134
  72135
  78302
  91271
  96151
  96154
  96157
  96158
  125314
  125315
  125316
  125317
  125318
  142526
  142527
  240771
  248427
  248430
  248506
  256885
  289073
  289074
  403727
  403940
  404381
  404974
  417693
  519648
  2786
  2788
  3023
  3032
  3033
  3037
  3038
  3042
  3043
  3047
  3048
  3050
  3053
  3744
  3745
  3746
  3747
  3748
  3749
  3750
  3751
  3752
  3753
  3754
  3755
  3756
  3757
  4376
  5707
  5712
  5713
  5714
  5715
  5821
  5829
  5831
  5832
  5834
  5992
  6482
  6483
  6827
  6828
  6829
  8235
  8237
  8240
  8242
  9030
  9032
  9033
  9034
  9035
  9201
  9203
  9239
  9651
  9835
  10401
  10404
  25637
  25851
  25852
  25854
  25855
  25856
  25857
  25860
  25861
  25863
  25968
  25969
  25971
  25972
  25973
  25975
  25976
  25977
  28622
  28624
  28689
  28691
  28692
  28693
  28694
  28695
  28696
  28697
  28698
  28699
  28700
  28701
  28702
  29215
  29278
  29279
  29280
  29434
  29435
  29436
  29437
  29438
  29439
  29930
  29931
  30789
  30790
  30791
  30792
  30793
  30794
  30799
  31669
  33390
  33404
  53364
  54544
  55013
  55023
  55238
  56040
  59346
  59347
  59348
  59349
  59351
  59352
  59353
  60002
  61651
  61652
  63545
  64157
  64159
  64160
  64161
  69391
  69392
  69393
  69394
  69395
  69396
  69679
  69680
  69681
  70012
  70015
  70018
  70019
  70020
  70021
  70022
  70706
  70707
  70879
  70881
  70887
  70888
  70889
  70891
  70893
  70894
  70895
  70899
  70900
  70901
  72393
  72562
  78749
  78751
  78753
  79401
  80391
  80392
  80393
  80394
  80395
  80396
  80399
  80400
  80406
  80407
  80408
  80409
  80410
  80424
  85316
  85317
  85318
  85319
  85320
  85321
  85322
  85323
  85324
  85325
  85342
  85343
  85344
  87514
  87515
  93631
  93643
  93726
  96760
  96761
  96762
  96763
  96764
  96765
  96766
  96771
  97221
  101460
  101463
  106148
  106364
  106365
  122421
  122422
  122960
  128553
  130905
  132033
  133882
  143988
  143990
  148554
  148556
  148557
  149250
  163610
  163611
  163615
  163617
  163930
  163931
  163932
  163933
  163934
  163961
  165467
  165468
  165469
  165470
  165471
  165472
  182994
  183762
  193377
  195406
  195815
  198618
  199217
  199218
  199219
  199322
  199323
  201528
  203437
  216709
  216710
  221517
  221518
  221519
  221520
  221521
  221522
  221523
  221524
  221525
  221526
  239639
  239640
  240309
  240312
  241238
  241239
  241240
  241241
  241242
  241243
  241244
  241245
  241246
  241247
  241248
  241249
  241250
  241251
  241252
  241253
  241254
  241255
  241256
  241257
  241774
  241775
  242397
  242398
  243585
  243586
  243588
  244244
  244245
  244246
  244247
  244248
  244249
  249032
  256772
  256838
  256839
  256886
  256917
  256988
  256989
  257003
  257004
  257005
  257006
  257007
  257008
  257009
  257014
  257015
  257016
  257017
  257019
  257020
  257021
  257022
  257023
  257024
  257032
  257033
  257034
  257037
  257069
  257071
  259681
  260103
  260104
  260105
  261751
  261774
  267739
  267740
  267741
  267743
  267744
  267752
  267753
  267754
  267755
  267756
  267757
  267758
  267759
  285245
  285246
  285458
  285459
  285460
  289049
  289050
  289051
  289052
  302401
  308990
  312052
  314069
  317662
  317663
  325314
  325315
  328132
  335297
  335298
  336077
  339571
  339583
  339597
  339598
  339599
  339600
  339601
  339602
  339603
  339604
  339605
  339606
  339607
  339608
  339609
  339610
  339611
  341490
  341494
  345099
  346297
  353988
  403605
  403606
  403608
  403609
  403610
  403611
  403652
  403653
  403654
  403655
  403656
  403657
  403658
  403665
  403675
  403702
  403710
  403745
  403765
  403770
  403772
  403807
  403808
  403812
  403866
  404304
  404305
  404306
  404417
  404423
  404604
  404605
  404606
  404607
  404640
  404783
  404785
  404786
  404819
  404828
  404829
  404834
  404873
  404874
  404881
  404883
  404904
  404907
  404911
  404912
  404998
  404999
  405000
  405429
  405430
  405431
  406560
  411994
  411996
  411997
  411998
  411999
  412000
  413346
  413354
  413355
  413356
  413357
  413358
  413359
  413696
  465893
  465894
  469476
  469488
  469489
  469491
  469492
  504312
  508236
  519637
  519638
  519639
  2451
  3619
  3632
  3633
  28363
  28367
  28369
  28371
  28375
  28672
  28673
  28674
  54574
  55184
  55185
  55186
  55187
  70006
  70007
  70008
  70591
  77382
  78404
  78733
  78736
  79533
  84916
  85284
  85336
  85338
  85672
  86478
  92279
  92280
  93642
  106717
  106718
  106719
  106721
  142519
  200149
  200150
  225539
  243608
  243609
  243612
  243613
  248434
  248435
  248496
  256773
  256780
  256781
  256782
  259682
  259717
  259718
  264341
  282061
  282064
  285471
  285472
  287096
  293486
  314060
  314061
  314172
  314173
  330397
  330399
  402472
  403569
  403570
  403758
  403863
  404321
  404521
  404648
  404751
  411849
  417915
  417917
  418442
  469497
  469498
  503727
  519620
  558462
  558465
  1
]
23.81 ms
(8.75%)
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 product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1
Parameters:
[
  4
  46
  222
  223
  224
  225
  47
  226
  227
  228
  229
  48
  230
  231
  232
  233
  234
  49
  235
  236
  237
  50
  238
  239
  240
  241
  51
  242
  243
  244
  52
  245
  246
  247
  248
  53
  249
  250
  251
  252
]
21.46 ms
(7.89%)
60
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"
  72174
]
19.52 ms
(7.17%)
91
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"
]
18.36 ms
(6.75%)
30
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:
[
  72174
  0
]
17.36 ms
(6.38%)
30
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:
[
  72174
]
13.98 ms
(5.14%)
14
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:
[
  72174
  7
]
13.54 ms
(4.98%)
60
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"
]
11.77 ms
(4.33%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1
Parameters:
[
  4
  46
  222
  223
  224
  225
  47
  226
  227
  228
  229
  48
  230
  231
  232
  233
  234
  49
  235
  236
  237
  50
  238
  239
  240
  241
  51
  242
  243
  244
  52
  245
  246
  247
  248
  53
  249
  250
  251
  252
]
9.59 ms
(3.53%)
61
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
9.42 ms
(3.46%)
30
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:
[
  72174
  "C"
]
8.57 ms
(3.15%)
28
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:
[
  72174
  9963039
]
7.77 ms
(2.86%)
49
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:
[
  222
]
7.71 ms
(2.83%)
30
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-07-18 12:32:15"
  "%2%"
  72174
]
5.69 ms
(2.09%)
30
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:
[
  72174
]
1.76 ms
(0.65%)
1
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 30 OFFSET 360
Parameters:
[
  4
  46
  222
  223
  224
  225
  47
  226
  227
  228
  229
  48
  230
  231
  232
  233
  234
  49
  235
  236
  237
  50
  238
  239
  240
  241
  51
  242
  243
  244
  52
  245
  246
  247
  248
  53
  249
  250
  251
  252
]
1.26 ms
(0.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 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  4
  46
  222
  223
  224
  225
  47
  226
  227
  228
  229
  48
  230
  231
  232
  233
  234
  49
  235
  236
  237
  50
  238
  239
  240
  241
  51
  242
  243
  244
  52
  245
  246
  247
  248
  53
  249
  250
  251
  252
  72174
  72175
  72184
  72186
  72187
  72188
  72189
  72191
  72192
  72193
  72194
  72195
  73067
  73068
  73069
  73070
  73071
  73073
  73074
  73075
  73077
  78755
  79553
  79554
  79555
  79556
  79557
  79681
  80575
  80747
]
0.79 ms
(0.29%)
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:
[
  "classement-archivage"
]
0.73 ms
(0.27%)
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.54 ms
(0.20%)
2
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:
[
  80575
]
0.37 ms
(0.14%)
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:
[
  "classement-archivage"
]
0.36 ms
(0.13%)
2
SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ?
Parameters:
[
  199448
]
0.29 ms
(0.11%)
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:
[
  "classement-archivage"
]

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.