GET https://staging.pgdis.com/produit/activites-artistiques-dessiner-colorier

Query Metrics

62 Database Queries
22 Different statements
119.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
72.07 ms
(60.21%)
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:
[
  924
  925
  1266
  1267
  1270
  1271
  1279
  1395
  1420
  1532
  1736
  1737
  2147
  2148
  2149
  2151
  2152
  2153
  2154
  2155
  2156
  2157
  2158
  2159
  2171
  2210
  2321
  2322
  2323
  2324
  2325
  2326
  2327
  2328
  2329
  2330
  2331
  2332
  2333
  2334
  2344
  2345
  2346
  2348
  2351
  2352
  2361
  2362
  2365
  2419
  2421
  2422
  2423
  2424
  2516
  2547
  2548
  2585
  2586
  2587
  2588
  2589
  2590
  2591
  2592
  2600
  2602
  2604
  2690
  2691
  2692
  2693
  2694
  2695
  2696
  2697
  2698
  2699
  2700
  2701
  2702
  2703
  2704
  2705
  2706
  2707
  2708
  2712
  2721
  2725
  2726
  2727
  3918
  3921
  3922
  4028
  4093
  4230
  4231
  4234
  4235
  4236
  4239
  4241
  4347
  4410
  5010
  5018
  5035
  5045
  5083
  5312
  5400
  5401
  5402
  5477
  5485
  5516
  5526
  5527
  5528
  6167
  6168
  6169
  6170
  6171
  6458
  6459
  6461
  6462
  6469
  6524
  6525
  6607
  6609
  6848
  7044
  7137
  7352
  7501
  7523
  7525
  7526
  7528
  7530
  7532
  7533
  7535
  7536
  7538
  7545
  7597
  7598
  7599
  7600
  7601
  7602
  7603
  7604
  7605
  7606
  7607
  7608
  7609
  7610
  7611
  7686
  7746
  7747
  7755
  7848
  7849
  7939
  7940
  7941
  8055
  8056
  8352
  8353
  8354
  8355
  8356
  8357
  9135
  9587
  9588
  9589
  9615
  9616
  9772
  9793
  9824
  9839
  9840
  9841
  9842
  9849
  9850
  9851
  11029
  11124
  11153
  25489
  26036
  26053
  26091
  26092
  26093
  26094
  26215
  26216
  26308
  26313
  26314
  28853
  28854
  28855
  28862
  28958
  28966
  29021
  29023
  29024
  29025
  29127
  29608
  29609
  29612
  29613
  29614
  30557
  30880
  32143
  32144
  32145
  32146
  32147
  32148
  32149
  32150
  32151
  32153
  32154
  32155
  32158
  32159
  32160
  32161
  32162
  32163
  32436
  32485
  32486
  32487
  32491
  32492
  32493
  32494
  32495
  32496
  32497
  32498
  32499
  32504
  32505
  32539
  32573
  32578
  32580
  32582
  32645
  32730
  32731
  55661
  55662
  55791
  55792
  55794
  55901
  55902
  56081
  56137
  56167
  56169
  56170
  56336
  56406
  56511
  56693
  56839
  56987
  60405
  60409
  60417
  60418
  60420
  60425
  60797
  61050
  61190
  61195
  61409
  65667
  65668
  65675
  65907
  65908
  65909
  65910
  65911
  65912
  65913
  65914
  65915
  65916
  65919
  65921
  65940
  66035
  66047
  67146
  67181
  69733
  72563
  72569
  72601
  72602
  72607
  72609
  74320
  74326
  74327
  74329
  74330
  74331
  74332
  74333
  74334
  74335
  74337
  74338
  74339
  74340
  74341
  74343
  74344
  74346
  74718
  74719
  74720
  74721
  74722
  74723
  74724
  74725
  75151
  75152
  75153
  75154
  75157
  75159
  75163
  75267
  75268
  75269
  75270
  75275
  75276
  75280
  75290
  75291
  75293
  75294
  75312
  75910
  75911
  75914
  75915
  75917
  75918
  76042
  76043
  76044
  76070
  78177
  78252
  78258
  78272
  78273
  78274
  78275
  78276
  78277
  78278
  78279
  78280
  78281
  78341
  78344
  78345
  78346
  78347
  78348
  78349
  78364
  78365
  78366
  78367
  78368
  78821
  80462
  80463
  80464
  80743
  80748
  80749
  80993
  80996
  80998
  80999
  81000
  81002
  81005
  81098
  81375
  81382
  81384
  81428
  81429
  81431
  81499
  87893
  87895
  87896
  87897
  87898
  87899
  87900
  87901
  87902
  87904
  87905
  88030
  88031
  88032
  88033
  88034
  88035
  88042
  88043
  88044
  88045
  88046
  88047
  88048
  88049
  88050
  88051
  88052
  88057
  88075
  88090
  88109
  88204
  88510
  88513
  89298
  89518
  89519
  89520
  89522
  91238
  91239
  91240
  91766
  92037
  92293
  96542
  96670
  97104
  97119
  97132
  97133
  97134
  97135
  97136
  97148
  97154
  97155
  97156
  97230
  97422
  97423
  97515
  97523
  97526
  97529
  97530
  97531
  97532
  97533
  97534
  97535
  97536
  97575
  97578
  97579
  97588
  99527
  99703
  101898
  103983
  106714
  109217
  109689
  109700
  109912
  109913
  109915
  109916
  109917
  109966
  109967
  109971
  110250
  110253
  110280
  110281
  110285
  115661
  129252
  129471
  129472
  129473
  129764
  129771
  129773
  129791
  129793
  129817
  129828
  129829
  129830
  129831
  129832
  129833
  129835
  129836
  129848
  129849
  129888
  130869
  130870
  131227
  131235
  131236
  131255
  131256
  131257
  131258
  131259
  131260
  131261
  131285
  131645
  131646
  131647
  131654
  131657
  131997
  131998
  132000
  132009
  134962
  141922
  141923
  141926
  142903
  144921
  144922
  147597
  148563
  148564
  149232
  149239
  149356
  149357
  149358
  149359
  149360
  149361
  149362
  149367
  149607
  149608
  149931
  149932
  149933
  150330
  150331
  150332
  150333
  150334
  150342
  150672
  150678
  150679
  150680
  150681
  150682
  150684
  151335
  151606
  151607
  151608
  160184
  160982
  161029
  161049
  162686
  166742
  166743
  166760
  166761
  166762
  166763
  166764
  166765
  166766
  166767
  166768
  166769
  166770
  166922
  167561
  167587
  167588
  167589
  167592
  167597
  167598
  167599
  167600
  167602
  167603
  167604
  167605
  167607
  167608
  167609
  167610
  167617
  167653
  167654
  167682
  167683
  167902
  167904
  167910
  167911
  167916
  167917
  168501
  168503
  168504
  168505
  168506
  168507
  169383
  177636
  179098
  182433
  182467
  182949
  182950
  182951
  182952
  182953
  182954
  182955
  182956
  182957
  182958
  182959
  182960
  182961
  182962
  182963
  182964
  182965
  182966
  182967
  182968
  182969
  182970
  182971
  182972
  182973
  182974
  182975
  182976
  182977
  182978
  182979
  182980
  182982
  182983
  183533
  183566
  183608
  183645
  183646
  183654
  183689
  184105
  184106
  184107
  184108
  184863
  184864
  184865
  184866
  184867
  184868
  184869
  184870
  184872
  185401
  185666
  185668
  185669
  185670
  185724
  185998
  185999
  186690
  186936
  193832
  193833
  194769
  194770
  194771
  194772
  194773
  194774
  199291
  199293
  199320
  201048
  203441
  203442
  203535
  203537
  203538
  203540
  203541
  203542
  203582
  204148
  204680
  204681
  204682
  204683
  204730
  204731
  205548
  205749
  205750
  205756
  208449
  208450
  208476
  208935
  208948
  209396
  209397
  209417
  209424
  209425
  209729
  209730
  215232
  215233
  215234
  215235
  215236
  215237
  215244
  215245
  216050
  216051
  216052
  216372
  216422
  216446
  216495
  217228
  217229
  217230
  217260
  217301
  217302
  217638
  219109
  220700
  220755
  221562
  221565
  221566
  221567
  221636
  221637
  221638
  221639
  221659
  222806
  222807
  222881
  222882
  222888
  223209
  223215
  223216
  224600
  224601
  224602
  224603
  224604
  224605
  224606
  224607
  224608
  224609
  224610
  224926
  224928
  224929
  224930
  224932
  224933
  224934
  224939
  224940
  224941
  225165
  225892
  225893
  225894
  225895
  225897
  225899
  225900
  225901
  225907
  225908
  225911
  225912
  225913
  225916
  225917
  225918
  225919
  225920
  225921
  225923
  230010
  235685
  237337
  237338
  237344
  237345
  237346
  237347
  237348
  237383
  237385
  237386
  237387
  237388
  237389
  237390
  237391
  237735
  237856
  237861
  237862
  237863
  239263
  240406
  240407
  240408
  240409
  240410
  241198
  242611
  242613
  242616
  242618
  242619
  242620
  242621
  242622
  242623
  242627
  242628
  242893
  242894
  242895
  242896
  242897
  242898
  242899
  242900
  242901
  242902
  242903
  242904
  243016
  243017
  243583
  243584
  243598
  244505
  245443
  245454
  245492
  245493
  245494
  245495
  245496
  245497
  245498
  245499
  245500
  245501
  245508
  245981
  246010
  246030
  246033
  246056
  246077
  246282
  246283
  246284
  246285
  246286
  246287
  246288
  246290
  246291
  246293
  246294
  246301
  246302
  246303
  246304
  246603
  246604
  246605
  246606
  246607
  246608
  246609
  246610
  246860
  246861
  246862
  246863
  247265
  248419
  248608
  248609
  251235
  258840
  262547
  262633
  262634
  262693
  263107
  263109
  263122
  263127
  263128
  263129
  263130
  263132
  263488
  263533
  264233
  264234
  264258
  264263
  264276
  265350
  265351
  265352
  265439
  265440
  265441
  265444
  265445
  266003
  266272
  267096
  267342
  267343
  267345
  267371
  267372
  267373
  268892
  268893
  282752
  282753
  283313
  283926
  287077
  287078
  287079
  287080
  287081
  287082
  287083
  287084
  287085
  287086
  287088
  287886
  287887
  287888
  287928
  287977
  288128
  288195
  288399
  288401
  288982
  288983
  288984
  288989
  288999
  289000
  289001
  289002
  289063
  289743
  289749
  289776
  290190
  290370
  290373
  290639
  290642
  290643
  290647
  291459
  291620
  291754
  292015
  292016
  292061
  292062
  292376
  292693
  292929
  292930
  292931
  292980
  293250
  293252
  293254
  293267
  293306
  293895
  293896
  294333
  294334
  294335
  294336
  294337
  294338
  294339
  294340
  294341
  294342
  294343
  294344
  294620
  299536
  299537
  299559
  299734
  300314
  300315
  300316
  300317
  300318
  300319
  300320
  300321
  300336
  300337
  300342
  301711
  303861
  303862
  303863
  303864
  303865
  303866
  303867
  303868
  303869
  303870
  303873
  303874
  303876
  306573
  306575
  306576
  308842
  311710
  311711
  311712
  311713
  311714
  311715
  311716
  311717
  311720
  311721
  314104
  314105
  314106
  314107
  314108
  314109
  314158
  314165
  314208
  314209
  314879
  314880
  315218
  315219
  315523
  315524
  315525
  316407
  316408
  316409
  316410
  316414
  316415
  316416
  316417
  316418
  316419
  316420
  316421
  316422
  316423
  316424
  316427
  316428
  316432
  316433
  316434
  316435
  316436
  316437
  316442
  316443
  316444
  316445
  316446
  316447
  316448
  316449
  316450
  316451
  316452
  316453
  316454
  316455
  316456
  316457
  316458
  316459
  316460
  316461
  316462
  316464
  316465
  316466
  316468
  316472
  316473
  316474
  316475
  316476
  316481
  316482
  316483
  316484
  316485
  316486
  316487
  316488
  316489
  316490
  316491
  316496
  316497
  316498
  316499
  316500
  316501
  316502
  316503
  316504
  316505
  316507
  316508
  316509
  316510
  316511
  316512
  316513
  316514
  316515
  316516
  316517
  316518
  316519
  316520
  316521
  316522
  316523
  316524
  316534
  316535
  316536
  316537
  316539
  316540
  316542
  316543
  316546
  316547
  316549
  316550
  316551
  316552
  316553
  316555
  316556
  316557
  316558
  316559
  316560
  316561
  316562
  316565
  316566
  316567
  316568
  316569
  316570
  316572
  316573
  316574
  316575
  316576
  316577
  316578
  316579
  316580
  316582
  316583
  316584
  316585
  316586
  316588
  316589
  316590
  316591
  316592
  316593
  316594
  316595
  316598
  316599
  316600
  316601
  316602
  316603
  316604
  316605
  316606
  316607
  316608
  316609
  316610
  316611
  316612
  316613
  316614
  316615
  316616
  316617
  316618
  316619
  316620
  316621
  316622
  316623
  316624
  316625
  316626
  316627
  316629
  316630
  316631
  316632
  316633
  316634
  316635
  316636
  316637
  316638
  316639
  316640
  316641
  316642
  316643
  316644
  316645
  316646
  316647
  316648
  316650
  316651
  316652
  316653
  316654
  316655
  316656
  316657
  316658
  316659
  316660
  316661
  316662
  316663
  316664
  316665
  316666
  316667
  316668
  316669
  316670
  316671
  316672
  316673
  316675
  316677
  316678
  316679
  316680
  316681
  316682
  316683
  316684
  316685
  316686
  316687
  316688
  316689
  316690
  316691
  316692
  316693
  316694
  316695
  316696
  316697
  316698
  316699
  316700
  316701
  316702
  316703
  316705
  316706
  316707
  316715
  316730
  316741
  316752
  316757
  316800
  316801
  316805
  317159
  320288
  320289
  320294
  320386
  320424
  320425
  320681
  320728
  320729
  321043
  321044
  321045
  321088
  321089
  321090
  321110
  321124
  321168
  321169
  321170
  321185
  321186
  321480
  321965
  321968
  321969
  321974
  323228
  323748
  324823
  325252
  325320
  325329
  325331
  326055
  331659
  331672
  337445
  337482
  338119
  338169
  338237
  339382
  339383
  339384
  339385
  339389
  339391
  339393
  339395
  339397
  339567
  339568
  339629
  339847
  339848
  339849
  341083
  341084
  341085
  341088
  341089
  341090
  341091
  342559
  342652
  342673
  343185
  344757
  344758
  344759
  344763
  344764
  344765
  344766
  344767
  344768
  344771
  344772
  344853
  346366
  346982
  346983
  346984
  346985
  346986
  346987
  346988
  346989
  346990
  346991
  346992
  346993
  346994
  346995
  346996
  346998
  346999
  348232
  348235
  348238
  348239
  348241
  348242
  348243
  348244
  348245
  348247
  348248
  348249
  348250
  348253
  348272
  348274
  348547
  348548
  348550
  348551
  348552
  348556
  348575
  348576
  348577
  348578
  348579
  348582
  348586
  348619
  348651
  348652
  348653
  348654
  348655
  348656
  348657
  348658
  348659
  348660
  348661
  348662
  348663
  348664
  348665
  348666
  348667
  348668
  348669
  348672
  348673
  348674
  348675
  348678
  348860
  379018
  379019
  391301
  391302
  391303
  391304
  391305
  391306
  391307
  391308
  391309
  403929
  403930
  403931
  403932
  403936
  404429
  404430
  404431
  404437
  404555
  404650
  404651
  404676
  404817
  404965
  413362
  416736
  416738
  416739
  416740
  417925
  418397
  418398
  418399
  418400
  418401
  418402
  418406
  418407
  418408
  424117
  424118
  424119
  425327
  425328
  425329
  425330
  425331
  425332
  425333
  425334
  425336
  425493
  425510
  425511
  425512
  425515
  425516
  425517
  425518
  425519
  425520
  425521
  425522
  425523
  425524
  425525
  425526
  425527
  425528
  425529
  425530
  425531
  425532
  426324
  427841
  431521
  432231
  433087
  433088
  433089
  433090
  433157
  433158
  435163
  435179
  435180
  435181
  435190
  436620
  436644
  443126
  443127
  453901
  458408
  458409
  458410
  458411
  458412
  458413
  458414
  458415
  458428
  458450
  459561
  459562
  461499
  464266
  471512
  471513
  472077
  472079
  472953
  473094
  473417
  473418
  473419
  473421
  473424
  473425
  473426
  473444
  473447
  473449
  476848
  481783
  481785
  481791
  481792
  481793
  481794
  481861
  484510
  485302
  485937
  485964
  485965
  485966
  485967
  485968
  485969
  485991
  485992
  486510
  486513
  486514
  486515
  486516
  486517
  486548
  486549
  488654
  488664
  488665
  489762
  499857
  499995
  499997
  511560
  511561
  511889
  511890
  511891
  511892
  511896
  511897
  520794
  521085
  521086
  522314
  522420
  522421
  522422
  522952
  522953
  522954
  523274
  527009
  527200
  527201
  527202
  527644
  527645
  527652
  527654
  527912
  527930
  529283
  529313
  529316
  529321
  529322
  529327
  529328
  529374
  529375
  529376
  529378
  529379
  529380
  529381
  529382
  529383
  529384
  529392
  529393
  529394
  529395
  529397
  531279
  531280
  532095
  535123
  558427
  558428
  558785
  563879
  563880
  567218
  567220
  567221
  567224
  567225
  568849
  568850
  568851
  568852
  568854
  569643
  569646
  569653
  569655
  569656
  1
]
19.75 ms
(16.50%)
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:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
]
11.40 ms
(9.52%)
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:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
]
2.85 ms
(2.38%)
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
]
1.76 ms
(1.47%)
4
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"
]
1.64 ms
(1.37%)
7
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"
]
1.47 ms
(1.22%)
2
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:
[
  1266
  7
]
1.25 ms
(1.04%)
4
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"
  1266
]
1.04 ms
(0.87%)
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:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
  924
  925
  1266
  1267
  1270
  1271
  1279
  1395
  1420
  1532
  1736
  1737
  2147
  2148
  2149
  2151
  2152
  2153
  2154
  2155
  2156
  2157
  2158
  2159
  2171
  2210
  2321
  2322
  2323
  2324
]
0.78 ms
(0.65%)
5
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
0.72 ms
(0.60%)
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:
[
  "activites-artistiques-dessiner-colorier"
]
0.61 ms
(0.51%)
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:
[
  1266
]
0.61 ms
(0.51%)
2
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:
[
  1266
  0
]
0.58 ms
(0.49%)
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.52 ms
(0.43%)
2
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:
[
  1266
  "C"
]
0.50 ms
(0.42%)
2
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-12 05:51:07"
  "%2%"
  1266
]
0.50 ms
(0.42%)
2
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:
[
  1266
]
0.48 ms
(0.40%)
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
Parameters:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
]
0.35 ms
(0.29%)
2
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:
[
  1266
]
0.33 ms
(0.28%)
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:
[
  "activites-artistiques-dessiner-colorier"
]
0.26 ms
(0.22%)
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:
[
  "activites-artistiques-dessiner-colorier"
]
0.22 ms
(0.19%)
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 = ?
Parameters:
[
  9
]

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.