GET https://harmattan.feelandclic.dev/catalogue/zone-geographique/afrique-du-nord/20

Response
200 OK
IP
216.73.216.29
Profiled on
Token
f41892

Query Metrics

342 Database Queries
47 Different statements
296.35 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
64.40 ms
(21.73%) 		1 
SELECT h0_.nom AS nom_0, h0_.prenom AS prenom_1, h0_.slug AS slug_2, h0_.photo_url_externe AS photo_url_externe_3, h0_.structure_professionnelle AS structure_professionnelle_4, h0_.site_web AS site_web_5, h0_.facebook AS facebook_6, h0_.twitter AS twitter_7, h0_.linkedin AS linkedin_8, h0_.instagram AS instagram_9, h0_.titres_diplomes AS titres_diplomes_10, h0_.fonctions_actuelles AS fonctions_actuelles_11, h0_.biographie AS biographie_12, h0_.autres_parutions AS autres_parutions_13, h0_.artiste_id AS artiste_id_14, h0_.externe_id AS externe_id_15, h0_.date_creation AS date_creation_16, h0_.date_modification AS date_modification_17, h0_.image_changed AS image_changed_18, h0_.id AS id_19, h0_.created AS created_20, h0_.changed AS changed_21, h0_.compte_id AS compte_id_22, h0_.photo_id AS photo_id_23, h0_.parent_id AS parent_id_24 FROM har_intervenant h0_ INNER JOIN har_ouvrage_intervenant h1_ ON h0_.id = h1_.intervenant_id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.prenom ASC, h0_.nom ASC
Parameters: 
[
  1395
  25455
  1976
  3092
  16485
  46413
  91
  700
  2011
  26120
  2646
  3717
  41342
  3795
  26564
  49519
  511
  2441
  2458
  3088
  3523
  4965
  6587
  8362
  12128
  16554
  16842
  24207
  25712
  38678
  43981
  1228
  2963
  3527
  4146
  6262
  7171
  7396
  9802
  20258
  24552
  26268
  26633
  28122
  42003
  44213
  49486
  49858
  763
  1029
  1220
  1461
  1602
  2822
  3182
  3495
  4400
  4995
  5105
  5333
  5988
  6163
  6183
  6406
  9179
  10463
  10718
  16597
  17175
  18675
  19007
  21156
  22040
  24364
  24617
  25548
  26758
  35707
  37378
  40869
  41580
  43141
  47580
  47608
  1
  398
  590
  747
  880
  1297
  1463
  1494
  1528
  1551
  1958
  2032
  2915
  3076
  3346
  3531
  3643
  3705
  3854
  5352
  6426
  6461
  7309
  8569
  9703
  10753
  10958
  11562
  11592
  11712
  14462
  15808
  16654
  18633
  19143
  19584
  21132
  21521
  22057
  23574
  23663
  23707
  24547
  24668
  24840
  24927
  25289
  25817
  25999
  26065
  26123
  26849
  27766
  27769
  29228
  31434
  31666
  35622
  37693
  38240
  39803
  39939
  40322
  40375
  41022
  42139
  42181
  48299
  48716
  49514
  507
  527
  541
  593
  774
  818
  824
  854
  1063
  1481
  1604
  1665
  1682
  1725
  1819
  2010
  2128
  2237
  2440
  2596
  2659
  2759
  2840
  2853
  2925
  2953
  2961
  3060
  3133
  3205
  3255
  3315
  3563
  3686
  3706
  3709
  3801
  3832
  3836
  3856
  4260
  4370
  4418
  4453
  4518
  4532
  4546
  4686
  4758
  5204
  5412
  5479
  5681
  5780
  5940
  5973
  6127
  6474
  6504
  6698
  6810
  7020
  7029
  7253
  7651
  7657
  7666
  7687
  8136
  8351
  8496
  8791
  9194
  9223
  9289
  9299
  9335
  9406
  9562
  9745
  10313
  10481
  10671
  11094
  11205
  11251
  11425
  11637
  11650
  11679
  12038
  12050
  12066
  12292
  12352
  12390
  13018
  13054
  13058
  13107
  13183
  13224
  13362
  14139
  14213
  14302
  14506
  14960
  14995
  15057
  15642
  15862
  16435
  16538
  16679
  17040
  17194
  17247
  17646
  17720
  17812
  17836
  18011
  18120
  18196
  18222
  18600
  18609
  18930
  19347
  19438
  19460
  19465
  19845
  20051
  20354
  20551
  20718
  20741
  20779
  20799
  20811
  21282
  21322
  21472
  21524
  21735
  21737
  21842
  22010
  22047
  22048
  22087
  22106
  22165
  22281
  22330
  22984
  23085
  23215
  23493
  23636
  23657
  23671
  24043
  24356
  24557
  24604
  25051
  25055
  25165
  25535
  25677
  25756
  25835
  26118
  26144
  26201
  26518
  26561
  26596
  26604
  26666
  26680
  26828
  26980
  27506
  27513
  27580
  27775
  28009
  28111
  28192
  28838
  30358
  30677
  31100
  32492
  32761
  33271
  33600
  34157
  34164
  34546
  34715
  35046
  35595
  36170
  36454
  36613
  36815
  37022
  37390
  38023
  40239
  40455
  40490
  40631
  40888
  40932
  40934
  40948
  41287
  41289
  41300
  41399
  41794
  42199
  42268
  42281
  42292
  42652
  43904
  44031
  44498
  44755
  44944
  45325
  45694
  45776
  45843
  45883
  45933
  46146
  46478
  48650
  49082
  49384
  50189
  50482
  84
  94
  134
  149
  165
  276
  290
  313
  327
  341
  354
  386
  410
  481
  692
  720
  732
  762
  804
  815
  823
  847
  861
  902
  941
  958
  990
  1000
  1005
  1028
  1030
  1086
  1118
  1119
  1120
  1133
  1169
  1189
  1193
  1194
  1224
  1265
  1280
  1322
  1328
  1344
  1387
  1409
  1441
  1458
  1492
  1533
  1536
  1621
  1624
  1639
  1650
  1654
  1691
  1718
  1722
  1727
  1766
  1794
  1818
  1833
  1875
  1937
  2018
  2051
  2063
  2072
  2162
  2166
  2177
  2193
  2209
  2228
  2230
  2276
  2299
  2308
  2319
  2368
  2369
  2397
  2428
  2432
  2443
  2457
  2531
  2614
  2617
  2655
  2662
  2703
  2761
  2797
  2811
  2831
  2868
  2874
  2879
  2885
  2937
  3008
  3014
  3030
  3059
  3117
  3169
  3179
  3190
  3197
  3235
  3243
  3252
  3297
  3305
  3397
  3403
  3425
  3466
  3484
  3498
  3533
  3564
  3602
  3652
  3668
  3708
  3750
  3758
  3788
  3869
  3930
  3958
  3984
  4014
  4024
  4108
  4142
  4156
  4165
  4167
  4222
  4225
  4298
  4332
  4356
  4358
  4362
  4409
  4411
  4463
  4470
  4507
  4514
  4521
  4567
  4615
  4628
  4663
  4666
  4703
  4704
  4714
  4718
  4729
  4734
  4751
  4782
  4790
  4792
  4794
  4804
  4814
  4825
  4842
  4875
  4890
  4894
  4897
  4898
  5008
  5016
  5026
  5095
  5117
  5124
  5212
  5216
  5267
  5350
  5374
  5390
  5394
  5406
  5442
  5510
  5520
  5563
  5581
  5643
  5647
  5661
  5666
  5718
  5719
  5748
  5788
  5795
  5828
  5910
  5922
  5991
  6066
  6069
  6076
  6114
  6153
  6190
  6197
  6224
  6285
  6357
  6383
  6429
  6448
  6532
  6646
  6679
  6685
  6699
  6702
  6704
  6730
  6752
  6767
  6795
  6813
  6825
  6836
  6839
  6888
  6955
  6997
  7025
  7123
  7127
  7135
  7177
  7209
  7241
  7247
  7278
  7369
  7370
  7417
  7418
  7430
  7439
  7458
  7459
  7464
  7473
  7478
  7500
  7502
  7520
  7533
  7539
  7571
  7574
  7576
  7641
  7647
  7650
  7652
  7654
  7655
  7658
  7659
  7665
  7672
  7728
  7730
  7753
  7830
  7959
  7980
  7995
  7998
  8077
  8115
  8125
  8131
  8135
  8138
  8149
  8161
  8194
  8213
  8272
  8285
  8314
  8350
  8360
  8369
  8399
  8423
  8430
  8433
  8491
  8504
  8538
  8548
  8551
  8555
  8557
  8589
  8601
  8635
  8695
  8696
  8854
  8904
  8907
  8908
  9027
  9059
  9118
  9183
  9193
  9235
  9252
  9255
  9279
  9295
  9300
  9357
  9371
  9534
  9559
  9561
  9569
  9573
  9586
  9613
  9623
  9658
  9720
  9783
  9913
  9923
  9968
  10075
  10159
  10179
  10290
  10298
  10310
  10342
  10346
  10400
  10512
  10553
  10587
  10591
  10667
  10744
  10767
  10878
  10897
  11000
  11114
  11164
  11177
  11199
  11201
  11215
  11266
  11278
  11289
  11292
  11311
  11321
  11333
  11413
  11422
  11550
  11579
  11608
  11610
  11737
  11767
  11823
  11851
  11898
  11907
  11911
  11975
  11978
  12037
  12063
  12123
  12169
  12213
  12254
  12289
  12298
  12304
  12333
  12398
  12434
  12442
  12496
  12497
  12538
  12562
  12563
  12565
  12602
  12614
  12625
  12628
  12695
  12728
  12733
  12740
  12752
  12762
  12778
  12781
  12791
  12823
  12870
  12916
  12929
  12951
  12952
  12959
  12972
  12974
  12978
  12982
  13079
  13121
  13136
  13196
  13201
  13226
  13232
  13247
  13248
  13305
  13310
  13311
  13323
  13324
  13328
  13366
  13373
  13379
  13472
  13473
  13486
  13511
  13514
  13534
  13570
  13588
  13623
  13648
  13650
  13663
  13666
  13686
  13713
  13818
  13900
  13970
  14001
  14121
  14154
  14209
  14217
  14275
  14287
  14303
  14308
  14318
  14319
  14356
  14376
  14378
  14395
  14425
  14428
  14465
  14510
  14540
  14556
  14572
  14599
  14615
  14626
  14635
  14677
  14697
  14700
  14781
  14782
  14795
  14853
  14872
  14878
  14899
  15007
  15017
  15058
  15076
  15118
  15119
  15204
  15223
  15245
  15248
  15268
  15286
  15293
  15310
  15320
  15338
  15368
  15432
  15451
  15464
  15510
  15522
  15530
  15555
  15561
  15605
  15606
  15607
  15617
  15666
  15671
  15683
  15708
  15710
  15729
  15749
  15801
  15910
  15944
  15945
  15991
  15997
  15998
  16002
  16039
  16064
  16100
  16113
  16131
  16145
  16179
  16187
  16221
  16277
  16283
  16288
  16321
  16334
  16336
  16342
  16362
  16379
  16447
  16455
  16517
  16561
  16595
  16608
  16636
  16664
  16682
  16713
  16727
  16761
  16766
  16780
  16783
  16804
  16828
  16833
  16835
  16847
  16888
  16903
  16934
  16941
  16951
  16999
  17005
  17033
  17041
  17048
  17075
  17079
  17095
  17100
  17134
  17137
  17157
  17174
  17176
  17236
  17251
  17279
  17305
  17390
  17401
  17411
  17431
  17447
  17455
  17461
  17487
  17498
  17499
  17569
  17573
  17575
  17590
  17602
  17654
  17679
  17685
  17737
  17746
  17764
  17802
  17807
  17882
  17908
  17916
  17943
  17990
  18006
  18009
  18025
  18123
  18172
  18193
  18199
  18237
  18247
  18263
  18314
  18380
  18381
  18426
  18442
  18497
  18523
  18525
  18526
  18534
  18573
  18585
  18586
  18616
  18698
  18723
  18770
  18772
  18785
  18824
  18833
  18834
  18836
  18868
  18925
  18934
  18966
  19034
  19067
  19082
  19106
  19122
  19153
  19157
  19198
  19215
  19243
  19244
  19247
  19276
  19293
  19327
  19350
  19392
  19424
  19425
  19441
  19454
  19500
  19504
  19532
  19563
  19632
  19672
  19690
  19721
  19733
  19782
  19792
  19815
  19817
  19826
  19850
  19874
  19878
  19898
  19946
  19947
  19961
  19977
  19979
  19982
  19987
  20003
  20013
  20027
  20028
  20029
  20030
  20087
  20123
  20143
  20171
  20182
  20184
  20212
  20213
  20263
  20264
  20265
  20266
  20292
  20297
  20320
  20364
  20384
  20393
  20426
  20442
  20528
  20591
  20614
  20638
  20654
  20665
  20691
  20711
  20712
  20750
  20786
  20833
  20838
  20852
  20906
  20926
  20971
  20974
  20998
  21031
  21134
  21165
  21191
  21247
  21275
  21316
  21344
  21369
  21379
  21380
  21387
  21388
  21397
  21400
  21417
  21425
  21427
  21435
  21442
  21448
  21583
  21589
  21593
  21595
  21596
  21616
  21657
  21660
  21691
  21695
  21790
  21813
  21843
  21856
  21896
  21917
  21932
  21946
  21966
  21970
  21981
  22032
  22038
  22044
  22079
  22089
  22093
  22128
  22137
  22169
  22216
  22256
  22283
  22322
  22351
  22365
  22427
  22479
  22543
  22556
  22584
  22642
  22667
  22698
  22718
  22733
  22735
  22810
  22849
  22852
  22857
  22897
  22900
  22921
  22973
  23002
  23016
  23022
  23208
  23229
  23235
  23248
  23288
  23329
  23335
  23370
  23376
  23402
  23452
  23488
  23500
  23501
  23514
  23527
  23535
  23537
  23575
  23576
  23639
  23667
  23689
  23706
  23719
  23743
  23747
  23799
  23847
  23854
  23880
  23881
  23954
  23975
  24065
  24081
  24123
  24130
  24195
  24214
  24215
  24244
  24247
  24289
  24298
  24311
  24336
  24339
  24383
  24408
  24411
  24438
  24471
  24505
  24593
  24621
  24630
  24637
  24646
  24671
  24679
  24698
  24733
  24761
  24762
  24811
  24836
  24889
  24900
  24905
  24934
  24945
  25032
  25043
  25160
  25172
  25205
  25220
  25221
  25226
  25238
  25240
  25351
  25371
  25417
  25421
  25441
  25459
  25481
  25496
  25506
  25545
  25560
  25564
  25608
  25650
  25655
  25689
  25693
  25705
  25718
  25754
  25794
  25804
  25868
  25889
  25916
  25946
  25952
  25976
  25995
  26014
  26016
  26018
  26059
  26067
  26068
  26099
  26100
  26133
  26176
  26177
  26193
  26210
  26234
  26236
  26280
  26281
  26295
  26310
  26329
  26336
  26379
  26444
  26501
  26522
  26533
  26547
  26548
  26551
  26584
  26608
  26618
  26634
  26693
  26719
  26720
  26752
  26759
  26762
  26803
  26812
  26823
  26963
  26989
  26998
  27061
  27062
  27078
  27080
  27251
  27265
  27314
  27502
  27571
  27600
  27671
  27690
  27694
  27719
  27746
  27773
  27795
  27813
  27859
  27889
  27990
  28011
  28021
  28038
  28052
  28070
  28086
  28156
  28178
  28226
  28262
  28267
  28314
  28331
  28427
  28438
  28465
  28505
  28515
  28536
  28568
  28700
  28721
  28850
  28853
  28882
  28886
  28898
  28920
  28934
  28937
  28943
  28950
  29059
  29206
  29209
  29238
  29255
  29465
  29552
  29599
  29609
  29709
  29728
  29730
  29738
  29835
  29854
  29960
  30174
  30202
  30209
  30214
  30215
  30216
  30217
  30218
  30340
  30341
  30391
  30394
  30399
  30403
  30421
  30535
  30536
  30538
  30559
  30580
  30582
  30612
  30634
  30679
  30785
  30787
  30827
  31075
  31077
  31112
  31330
  31399
  31585
  31640
  31642
  31643
  31644
  31645
  31646
  31702
  31721
  31725
  31755
  31888
  31921
  31922
  31923
  31924
  31955
  32211
  32249
  32310
  32341
  32414
  32417
  32419
  32503
  32527
  32878
  32929
  32932
  32937
  32941
  32951
  32953
  33203
  33351
  33353
  33446
  33448
  33481
  33631
  33643
  33645
  33663
  33714
  33725
  33774
  33785
  33832
  33844
  33871
  33872
  33908
  33960
  33992
  34075
  34134
  34137
  34140
  34228
  34229
  34283
  34298
  34332
  34373
  34394
  34503
  34514
  34543
  34584
  34586
  34587
  34634
  34647
  34667
  34719
  34805
  34987
  35072
  35079
  35270
  35407
  35466
  35482
  35499
  35533
  35534
  35538
  35541
  35543
  35545
  35547
  35549
  35551
  35553
  35606
  35659
  35759
  35771
  35836
  35871
  35875
  35897
  35937
  35951
  35962
  36009
  36073
  36088
  36101
  36111
  36122
  36130
  36143
  36147
  36152
  36168
  36198
  36409
  36451
  36453
  36504
  36514
  36518
  36599
  36610
  36628
  36647
  36659
  36667
  36748
  36763
  36806
  36916
  36927
  36955
  37025
  37034
  37035
  37036
  37037
  37090
  37103
  37121
  37171
  37334
  37374
  37391
  37406
  37422
  37519
  37533
  37617
  37640
  37805
  37959
  37960
  38001
  38010
  38019
  38048
  38049
  38053
  38093
  38095
  38097
  38129
  38134
  38143
  38170
  38172
  38192
  38224
  38236
  38282
  38300
  38309
  38314
  38356
  38369
  38385
  38414
  38457
  38467
  38496
  38586
  38602
  38630
  38645
  38670
  38675
  38691
  38711
  38716
  38738
  38794
  38799
  38851
  38959
  39176
  39295
  39394
  39602
  39638
  39651
  39690
  39739
  39783
  39854
  39875
  39935
  39995
  39998
  40095
  40156
  40188
  40288
  40297
  40347
  40395
  40420
  40449
  40457
  40461
  40468
  40483
  40529
  40571
  40582
  40586
  40670
  40709
  40726
  40731
  40732
  40800
  40804
  40823
  40825
  40827
  40867
  40873
  40979
  40985
  41040
  41107
  41117
  41150
  41188
  41208
  41234
  41275
  41277
  41279
  41288
  41290
  41291
  41293
  41315
  41316
  41321
  41325
  41331
  41367
  41422
  41440
  41445
  41446
  41461
  41472
  41475
  41477
  41487
  41520
  41531
  41538
  41541
  41583
  41587
  41591
  41598
  41607
  41699
  41762
  41790
  41820
  41823
  41847
  41858
  41887
  41891
  41910
  41931
  41936
  41952
  41953
  41992
  42086
  42175
  42204
  42206
  42210
  42217
  42230
  42235
  42264
  42267
  42271
  42272
  42273
  42282
  42315
  42329
  42345
  42378
  42381
  42549
  42565
  42582
  42592
  42604
  42620
  42625
  42638
  42641
  42646
  42648
  42650
  42657
  42659
  42662
  42686
  42740
  42756
  42759
  42812
  42820
  42836
  42875
  42879
  42890
  42896
  42910
  42993
  43024
  43074
  43109
  43173
  43178
  43179
  43249
  43251
  43325
  43338
  43421
  43481
  43482
  43503
  43541
  43552
  43575
  43689
  43691
  43704
  43720
  43801
  43819
  43845
  43865
  43931
  43946
  43972
  43973
  43975
  43976
  43977
  43982
  44049
  44050
  44056
  44067
  44070
  44125
  44155
  44185
  44208
  44227
  44278
  44305
  44354
  44389
  44394
  44435
  44488
  44503
  44515
  44562
  44571
  44576
  44599
  44610
  44624
  44628
  44707
  44787
  44790
  44800
  44835
  44861
  44916
  44927
  44931
  44946
  44947
  44948
  44949
  44953
  44954
  44957
  44985
  44997
  45016
  45056
  45068
  45094
  45131
  45142
  45148
  45216
  45250
  45261
  45317
  45385
  45450
  45468
  45487
  45515
  45559
  45653
  45665
  45693
  45720
  45750
  45751
  45812
  45888
  45971
  45973
  45977
  46045
  46153
  46156
  46217
  46247
  46302
  46408
  46452
  46481
  46523
  46529
  46730
  46738
  46742
  46745
  46782
  46803
  46822
  46869
  46963
  46990
  47012
  47028
  47085
  47167
  47169
  47171
  47174
  47178
  47193
  47211
  47213
  47276
  47340
  47347
  47442
  47517
  47612
  47619
  47627
  47641
  47643
  48128
  48315
  48321
  48374
  48429
  48492
  48545
  48677
  48717
  48737
  48769
  48827
  48878
  48972
  49098
  49194
  49286
  49300
  49311
  49316
  49333
  49355
  49390
  49435
  49487
  49542
  49598
  49613
  49641
  49817
  49830
  49835
  49860
  50218
  50237
  50355
  50358
  50373
  50413
  50437
  50570
  50607
  50648
  50715
  50868
  50876
  50911
  50954
  51061
  51088
  51090
  51096
  51105
  51129
  51148
  51178
  51180
  51300
  51312
  51320
  51360
  51496
  51549
  51551
  51594
  51608
  51662
  51789
  51845
  52000
  52006
  52032
  52073
  52128
  52130
  52142
  52176
  52180
  52186
  52271
  52563
  52643
  52658
  52797
  52834
  52904
  53039
  53182
  53267
  53303
  53318
  53361
  53466
  53509
  53656
  53667
  53741
  53827
  53828
  53924
  54023
  54186
  54294
  54516
  54622
  54722
  54827
  54852
  55147
  55255
  55291
  55294
  55423
  55425
  55427
  55583
  55614
  55790
  55820
  55902
  56248
  56375
  56774
  57315
  57490
  57599
  57790
  57939
  57988
  58057
  58401
  58773
  58982
]
View formatted query    View runnable query    Explain query
42.40 ms
(14.31%) 		1 
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_commande_detail h1_ ON h0_.id = h1_.ouvrage_id INNER JOIN har_disponibilite_ouvrage h2_ ON h0_.disponibilite_papier_id = h2_.id INNER JOIN har_ouvrage_zone_geographique h3_ ON h0_.id = h3_.ouvrage_id INNER JOIN har_zone_geographique h4_ ON h3_.zone_geographique_id = h4_.id WHERE h2_.externe_id NOT IN (?, ?) AND h4_.id = ? GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4
Parameters: 
[
  5
  6
  20
]
View formatted query    View runnable query    Explain query
32.96 ms
(11.12%) 		76 
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, s11_.from_api AS from_api_73, s11_.from_csv AS from_csv_74, s11_.token_google AS token_google_75, s11_.token_facebook AS token_facebook_76, s11_.front_access_token AS front_access_token_77, s11_.front_access_token_expires_at AS front_access_token_expires_at_78, c12_.firstName AS firstName_79, c12_.middleName AS middleName_80, c12_.lastName AS lastName_81, c12_.birthday AS birthday_82, c12_.salutation AS salutation_83, c12_.formOfAddress AS formOfAddress_84, c12_.newsletter AS newsletter_85, c12_.gender AS gender_86, c12_.note AS note_87, c12_.mainEmail AS mainEmail_88, c12_.mainPhone AS mainPhone_89, c12_.mainFax AS mainFax_90, c12_.mainUrl AS mainUrl_91, c12_.id AS id_92, c12_.created AS created_93, c12_.changed AS changed_94, s13_.username AS username_95, s13_.password AS password_96, s13_.locale AS locale_97, s13_.salt AS salt_98, s13_.locked AS locked_99, s13_.enabled AS enabled_100, s13_.lastLogin AS lastLogin_101, s13_.confirmationKey AS confirmationKey_102, s13_.passwordResetToken AS passwordResetToken_103, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_104, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_105, s13_.privateKey AS privateKey_106, s13_.apiKey AS apiKey_107, s13_.email AS email_108, s13_.id AS id_109, s13_.created AS created_110, s13_.changed AS changed_111, s13_.from_api AS from_api_112, s13_.from_csv AS from_csv_113, s13_.token_google AS token_google_114, s13_.token_facebook AS token_facebook_115, s13_.front_access_token AS front_access_token_116, s13_.front_access_token_expires_at AS front_access_token_expires_at_117, c14_.firstName AS firstName_118, c14_.middleName AS middleName_119, c14_.lastName AS lastName_120, c14_.birthday AS birthday_121, c14_.salutation AS salutation_122, c14_.formOfAddress AS formOfAddress_123, c14_.newsletter AS newsletter_124, c14_.gender AS gender_125, c14_.note AS note_126, c14_.mainEmail AS mainEmail_127, c14_.mainPhone AS mainPhone_128, c14_.mainFax AS mainFax_129, c14_.mainUrl AS mainUrl_130, c14_.id AS id_131, c14_.created AS created_132, c14_.changed AS changed_133, m15_.id AS id_134, m15_.created AS created_135, m15_.changed AS changed_136, m0_.idMediaTypes AS idMediaTypes_137, m0_.idPreviewImage AS idPreviewImage_138, m0_.idCollections AS idCollections_139, m0_.idUsersCreator AS idUsersCreator_140, m0_.idUsersChanger AS idUsersChanger_141, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_142, m2_.idCollectionTypes AS idCollectionTypes_143, m2_.idCollectionsParent AS idCollectionsParent_144, m2_.idUsersCreator AS idUsersCreator_145, m2_.idUsersChanger AS idUsersChanger_146, m3_.idMedia AS idMedia_147, m3_.idUsersCreator AS idUsersCreator_148, m3_.idUsersChanger AS idUsersChanger_149, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_150, m4_.idFiles AS idFiles_151, m4_.idUsersCreator AS idUsersCreator_152, m4_.idUsersChanger AS idUsersChanger_153, t5_.idUsersCreator AS idUsersCreator_154, t5_.idUsersChanger AS idUsersChanger_155, m6_.fileVersion AS fileVersion_156, m7_.idFileVersions AS idFileVersions_157, m8_.idFileVersions AS idFileVersions_158, m9_.idFileVersions AS idFileVersions_159, m10_.idFileVersions AS idFileVersions_160, s11_.idUsersCreator AS idUsersCreator_161, s11_.idUsersChanger AS idUsersChanger_162, s11_.idContacts AS idContacts_163, c12_.idTitles AS idTitles_164, c12_.avatar AS avatar_165, c12_.idUsersCreator AS idUsersCreator_166, c12_.idUsersChanger AS idUsersChanger_167, s13_.idUsersCreator AS idUsersCreator_168, s13_.idUsersChanger AS idUsersChanger_169, s13_.idContacts AS idContacts_170, c14_.idTitles AS idTitles_171, c14_.avatar AS avatar_172, c14_.idUsersCreator AS idUsersCreator_173, c14_.idUsersChanger AS idUsersChanger_174, m15_.idMediaTypes AS idMediaTypes_175, m15_.idPreviewImage AS idPreviewImage_176, m15_.idCollections AS idCollections_177, m15_.idUsersCreator AS idUsersCreator_178, m15_.idUsersChanger AS idUsersChanger_179 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?
Parameters: 
[
  232567
]
View formatted query    View runnable query    Explain query
28.99 ms
(9.78%) 		1 
SELECT h0_.nom AS nom_0, h0_.prenom AS prenom_1, h0_.slug AS slug_2, h0_.photo_url_externe AS photo_url_externe_3, h0_.structure_professionnelle AS structure_professionnelle_4, h0_.site_web AS site_web_5, h0_.facebook AS facebook_6, h0_.twitter AS twitter_7, h0_.linkedin AS linkedin_8, h0_.instagram AS instagram_9, h0_.titres_diplomes AS titres_diplomes_10, h0_.fonctions_actuelles AS fonctions_actuelles_11, h0_.biographie AS biographie_12, h0_.autres_parutions AS autres_parutions_13, h0_.artiste_id AS artiste_id_14, h0_.externe_id AS externe_id_15, h0_.date_creation AS date_creation_16, h0_.date_modification AS date_modification_17, h0_.image_changed AS image_changed_18, h0_.id AS id_19, h0_.created AS created_20, h0_.changed AS changed_21, h0_.compte_id AS compte_id_22, h0_.photo_id AS photo_id_23, h0_.parent_id AS parent_id_24 FROM har_intervenant h0_ INNER JOIN har_ouvrage_intervenant h1_ ON h0_.id = h1_.intervenant_id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.prenom ASC, h0_.nom ASC
Parameters: 
[
  5267
  6183
  4897
  6587
  30174
  42199
  1
  42204
  10463
  24547
  22322
  18770
  42210
  36659
  42217
  7473
  6163
  31642
  30214
  24336
  7417
  13183
  3856
  19438
  40322
  26065
  7500
  25712
  20263
  42267
  42268
  19350
  23975
  42271
  31640
  36198
  42272
  7502
  42273
  26123
  29209
  24761
  31643
  42292
  33832
  16999
  14782
  3092
  49311
  40347
  1228
  38023
  39854
  42329
  17033
  11177
  22283
  26533
  7539
  21132
  1118
  2937
  24679
  5988
  13588
  16342
  15945
  16113
  42381
  22087
  35595
  24668
  14425
  1328
  7571
  11289
  30394
  17764
  5780
  10290
  861
  37035
  2853
  16842
  3252
  2443
  30391
  13311
  42592
  23574
  6955
  42604
  5991
  12614
  42620
  18616
  42625
  10753
  5664
  36628
  36610
  48321
  38093
  22057
  38851
  21369
  42638
  19845
  5383
  29228
  49514
  40455
  7651
  5333
  42650
  3182
  11712
  42652
  1976
  49613
  590
  40457
  27062
  42662
  4751
  16334
  34715
  17812
  10481
  3255
  23667
  13514
  26551
  7665
  18523
  14465
  3014
  26245
  24123
  7171
  11737
  34805
  17569
  12390
  31434
  3750
  6813
  40490
  15642
  42740
  35533
  42759
  35707
  29035
  2018
  3668
  34140
  42820
  26564
  40529
  32941
  23500
  28882
  24411
  20320
  42879
  3869
  4965
  15654
  38134
  12916
  42910
  23881
  24215
  49641
  12538
  23501
  48374
  15607
  958
  26268
  11321
  34177
  40586
  6679
  31644
  22048
  43024
  35534
  43074
  33992
  11650
  40631
  38172
  36454
  15057
  43141
  3602
  29255
  18172
  17487
  43173
  43178
  37519
  43179
  14139
  91
  37103
  1604
  3832
  16828
  23215
  9745
  22089
  13648
  31721
  2717
  35168
  25459
  3190
  14506
  49519
  21856
  3758
  43249
  1481
  43251
  33631
  5828
  15432
  26280
  26281
  94
  38192
  16435
  12038
  1682
  43325
  43338
  29599
  18009
  17685
  20779
  26596
  25794
  40731
  27251
  1794
  35538
  2299
  26604
  27265
  30215
  22365
  6448
  9703
  43541
  26608
  32953
  43552
  37022
  36955
  36111
  354
  4628
  32878
  46413
  7959
  2596
  40800
  40804
  43946
  38240
  26067
  11114
  6285
  2646
  40827
  3836
  43704
  25655
  4167
  10744
  35622
  17498
  27314
  15808
  1766
  40867
  6997
  37037
  527
  17390
  9720
  32414
  24130
  43845
  40888
  17499
  24552
  24593
  43904
  3686
  43931
  20741
  8115
  32492
  40932
  19500
  21970
  43972
  22106
  37334
  5795
  8138
  1461
  23537
  11199
  25999
  30202
  15522
  43981
  30580
  15944
  25051
  43982
  16131
  36815
  49316
  40948
  55294
  24339
  31645
  3523
  26310
  25804
  37959
  44056
  11201
  6685
  5412
  26633
  26634
  23402
  19563
  17575
  40979
  10342
  4814
  8194
  40985
  3527
  29609
  7278
  37617
  58057
  44125
  134
  44155
  4463
  37960
  44049
  8213
  21595
  19878
  44213
  34332
  34283
  44278
  990
  19792
  34634
  37171
  26059
  16727
  35541
  22093
  38314
  18534
  44354
  37640
  16761
  1819
  11292
  31100
  36409
  12123
  35937
  17279
  22698
  17737
  41107
  19067
  35771
  17916
  35962
  44498
  28943
  3531
  44515
  13224
  18772
  16336
  3533
  31330
  149
  7025
  27502
  41150
  26336
  39939
  51789
  8362
  13121
  44610
  31955
  12752
  33871
  44628
  4370
  30559
  8369
  7029
  21842
  14462
  847
  3030
  36599
  48650
  41188
  5940
  44707
  41208
  17075
  44755
  38385
  26177
  26018
  22857
  18586
  2915
  35875
  31725
  48677
  398
  19632
  25548
  3705
  15666
  3788
  44790
  16934
  36667
  17040
  17041
  19961
  26068
  19979
  36763
  35543
  10671
  37025
  14572
  29465
  26693
  52834
  4546
  4995
  18025
  25289
  39875
  12333
  24630
  44944
  34584
  38414
  37693
  3076
  13666
  19007
  13472
  1387
  48716
  763
  10179
  41288
  49858
  8504
  41290
  41291
  2193
  24207
  44957
  22897
  41300
  13226
  48737
  16362
  28331
  8538
  41315
  45056
  19987
  35545
  20691
  41325
  32929
  16679
  8569
  45094
  41342
  8548
  45131
  45148
  36518
  19243
  4400
  8589
  26719
  26100
  36613
  2531
  30216
  26720
  3709
  11610
  24557
  14599
  23707
  45250
  41399
  11425
  4842
  8551
  28314
  8635
  18723
  3315
  27694
  41445
  49390
  45385
  17720
  25889
  12625
  3717
  10767
  41461
  45665
  1718
  14878
  14510
  3795
  8696
  24840
  23799
  26963
  45468
  20838
  21442
  41475
  11413
  3133
  16538
  50373
  23854
  22733
  34586
  18785
  1005
  4663
  14872
  19465
  41531
  26120
  41541
  30677
  35659
  34719
  49486
  37090
  20638
  37406
  1958
  27766
  1133
  26752
  12050
  45750
  45751
  20998
  32417
  18237
  22216
  27773
  27775
  17802
  12169
  41580
  49487
  26758
  12781
  24244
  41583
  41587
  35547
  23376
  41598
  45843
  2209
  27795
  11579
  13366
  3801
  53924
  38959
  6262
  45883
  16039
  45933
  32761
  18934
  33960
  17194
  2822
  20718
  14376
  22038
  1344
  48972
  46045
  21031
  41699
  2963
  20971
  26144
  17176
  15310
  17247
  30582
  37805
  27859
  18609
  32951
  16903
  22718
  13136
  20799
  2010
  15368
  46217
  23235
  36927
  27889
  3563
  33872
  3564
  16321
  38602
  6646
  25693
  36806
  25240
  3484
  25835
  11251
  41790
  41794
  39995
  32419
  19327
  2011
  17305
  24364
  46478
  46481
  35549
  41820
  1494
  1722
  26444
  46523
  1395
  21524
  46529
  26812
  15464
  9179
  38645
  13305
  41847
  24356
  21589
  854
  24811
  41858
  21400
  5581
  17137
  41887
  41891
  2759
  32937
  11278
  22137
  20906
  18925
  26828
  9223
  5973
  25506
  12352
  13058
  16654
  30399
  20654
  9235
  1833
  34394
  26980
  9252
  30679
  2032
  2761
  37034
  41936
  38678
  23248
  9279
  41953
  20750
  28009
  22351
  11266
  19347
  25441
  14700
  30217
  38691
  32249
  35551
  9300
  15910
  35553
  30218
  25455
  14795
  28021
  2840
  10958
  47012
  747
  25055
  34587
  15007
  42003
  28038
  26849
  14428
  18006
  28465
  23329
  28052
  47167
  47174
  22330
  13900
  1224
  6153
  9406
  47211
  37422
  3958
  29960
  4409
  2230
  47276
  22079
  47340
  28086
  42086
  276
  19293
  33785
  23022
  22256
  28111
  26176
  11592
  42139
  28122
  13623
  1028
  14356
  47517
  20711
  4411
  9534
  15204
  47580
  410
  49286
  48299
  1029
  3346
  17401
  9561
  39803
  9562
  4146
  39739
  13970
  22040
  14615
  47612
  42181
  38794
  47615
  47619
  341
  9559
  38799
  43482
  48545
  8791
  5520
  46302
]
View formatted query    View runnable query    Explain query
24.72 ms
(8.34%) 		1 
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_disponibilite_ouvrage h1_ ON h0_.disponibilite_papier_id = h1_.id WHERE h1_.externe_id NOT IN (?, ?) AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC
Parameters: 
[
  5
  6
  57535
  80526
  80763
  80836
  80857
  80750
  80706
  80627
  80581
  80484
  80386
  80576
  80279
  80427
  80506
  80351
  80454
  80095
  80144
  80226
  79988
  79919
  79866
  79870
  79923
  79823
  79859
  79753
  79769
  79798
  79721
  79682
  79507
  79590
  79519
  79416
  79419
  79424
  79440
  79477
  79316
  79335
  79221
  79373
  79185
  79279
  79178
  79293
  79205
  78985
  79003
  79080
  79091
  79108
  79112
  79135
  79139
  78863
  78794
  78613
  78808
  78869
  78692
  78849
  78809
  78507
  78645
  78652
  78653
  78654
  78513
  78424
  78457
  78342
  78371
  78186
  78165
  78208
  78253
  78332
  78054
  78004
  78029
  78142
  77898
  77962
  78007
  78043
  78094
  77902
  77940
  77749
  77862
  77760
  77677
  77704
  77707
  77720
  77502
  77306
  77486
  77489
  77406
  77410
  77323
  77326
  77121
  76649
  77382
  77140
  77279
  77232
  77189
  77259
  77180
  77173
  77191
  76513
  76553
  76551
  76680
  76488
  76636
  76466
  76432
  76288
  76246
  76294
  76334
  76262
  76175
  75979
  76267
  76072
  73963
  75875
  75959
  75886
  74016
  74045
  74144
  74306
  73917
  73918
  74479
  74483
  74505
  73950
  73951
  74499
  74546
  74542
  74570
  16109
  16181
  16157
  16160
  74602
  16196
  16216
  16235
  16236
  16296
  16334
  16337
  16419
  16423
  15849
  6047
  6071
  6093
  6135
  5882
  5973
  6185
  5984
  5931
  5927
  5941
  6239
  63
  54
  44
  6247
  154
  243
  247
  258
  218
  326
  292
  296
  358
  387
  471
  505
  517
  522
  6341
  540
  582
  599
  620
  641
  718
  6422
  6423
  6426
  770
  793
  807
  886
  909
  910
  904
  913
  918
  969
  979
  989
  992
  999
  6500
  1039
  1036
  1078
  1083
  1091
  1141
  1211
  1226
  1247
  1289
  1350
  1380
  1413
  1452
  1455
  1481
  1491
  1537
  1528
  1591
  1607
  1629
  1661
  1660
  1662
  1684
  1673
  1677
  1682
  1701
  1711
  1747
  1749
  1762
  1780
  1789
  1792
  1810
  1805
  1817
  1832
  6735
  1875
  1909
  1897
  1950
  1951
  1953
  6777
  1996
  2012
  2044
  2058
  2099
  2102
  2109
  2200
  2220
  2221
  6818
  2255
  2305
  2303
  2328
  2361
  6832
  2487
  2488
  2494
  2549
  2576
  2615
  2612
  2631
  2645
  2676
  2681
  2725
  2720
  2805
  2819
  2826
  2865
  2869
  2871
  2875
  2886
  2911
  2975
  3005
  2994
  3037
  3044
  6934
  6939
  6971
  6973
  16052
  3204
  3205
  3199
  3200
  3210
  3230
  3246
  3299
  6978
  3322
  6992
  3414
  3478
  3501
  3592
  3619
  3674
  3737
  7102
  3808
  3813
  7129
  3851
  3872
  3911
  3940
  3951
  3991
  4013
  4016
  4032
  4214
  4228
  4280
  4292
  4296
  4339
  4350
  4357
  7265
  4408
  4424
  4445
  4469
  4470
  7309
  4535
  7325
  7331
  7337
  4585
  7367
  7368
  4721
  7378
  7380
  7403
  7408
  7447
  5008
  5048
  5056
  5079
  5087
  5170
  5174
  5175
  5196
  5202
  7542
  7573
  5291
  5294
  5310
  7635
  7680
  7720
  7726
  7839
  7843
  7854
  7887
  7896
  7901
  7929
  7979
  7990
  8006
  8016
  8022
  8038
  8126
  8150
  8162
  8190
  8229
  8260
  8262
  78238
  8279
  8287
  8365
  8401
  8403
  8441
  8449
  8461
  8472
  8516
  8556
  8586
  8582
  8680
  8701
  8714
  8722
  8744
  8783
  8804
  8847
  8860
  8865
  8916
  8928
  8932
  8970
  9021
  9013
  9025
  9029
  9103
  9155
  9160
  9174
  9194
  9259
  9278
  9281
  9291
  9307
  9316
  9325
  9339
  9355
  5399
  9489
  9509
  9590
  9647
  9657
  9695
  9687
  9710
  9734
  9737
  9740
  9744
  9751
  9759
  9776
  9819
  9849
  5426
  9903
  9927
  10064
  10084
  10106
  10111
  5449
  10193
  10255
  10310
  10354
  10355
  10485
  10521
  10555
  10569
  10624
  10639
  10753
  10763
  10803
  10817
  10841
  10913
  10963
  10982
  10983
  11035
  11033
  11068
  11072
  11094
  11175
  11228
  5492
  11249
  11256
  11353
  11279
  11298
  11365
  11374
  11390
  11422
  11530
  11566
  11567
  11589
  11617
  11626
  5513
  11666
  11689
  11707
  11724
  11795
  11826
  5525
  11837
  11856
  11896
  11912
  11954
  11975
  11976
  11967
  11992
  11993
  12021
  12131
  12222
  12248
  12264
  12282
  12343
  12336
  12393
  5558
  12468
  12572
  12587
  12613
  12664
  12728
  12747
  12783
  12799
  12857
  12859
  12860
  12846
  12875
  12873
  12885
  12919
  5588
  12968
  12978
  12981
  13028
  13123
  13156
  13184
  13187
  13197
  13222
  13277
  13284
  13285
  13300
  13334
  13403
  13432
  13453
  13458
  13487
  13488
  13572
  13578
  13643
  5628
  13682
  13714
  13733
  13768
  13771
  13776
  13815
  13873
  13886
  13944
  13920
  13950
  13959
  13955
  14073
  14042
  14017
  14083
  14099
  14100
  14133
  14130
  14190
  14291
  14305
  14344
  14371
  14381
  14424
  14413
  14432
  14490
  14509
  14585
  14617
  14654
  14729
  14732
  14733
  14737
  14763
  14805
  14866
  14873
  14888
  14915
  5687
  14969
  15010
  15018
  15031
  15075
  15090
  15099
  15144
  15149
  15195
  15200
  15213
  15229
  15243
  15258
  15298
  15287
  15326
  5716
  15408
  15430
  15464
  15478
  15485
  15493
  15600
  15647
  15732
  16485
  5738
  5739
  16565
  16593
  16681
  16722
  16791
  16844
  16845
  16883
  16887
  16926
  16979
  17002
  17005
  17015
  17022
  17035
  17036
  17170
  5779
  17215
  17228
  17231
  17234
  17253
  17292
  17305
  17330
  17344
  17351
  17385
  17391
  17394
  17395
  17399
  17400
  17468
  17513
  17529
  17544
  17584
  17600
  17622
  17684
  17713
  17741
  17751
  17777
  17824
  17865
  17873
  17874
  17889
  17890
  17898
  17936
  17941
  17963
  18124
  18126
  18127
  18128
  18166
  18335
  18314
  18364
  18402
  18425
  18441
  18460
  18526
  18568
  18633
  18674
  18677
  18683
  18701
  18719
  18743
  18746
  18750
  18757
  18767
  18771
  18813
  18820
  18850
  18854
  18879
  18915
  18936
  18924
  18963
  19022
  19028
  19042
  19051
  19194
  19244
  19225
  19229
  19277
  19309
  19318
  19319
  19375
  19376
  19377
  19473
  19478
  19484
  19486
  19398
  19386
  19459
  19483
  19545
  19564
  19682
  19694
  19662
  19638
  19646
  19825
  19838
  19785
  19800
  19871
  19868
  19903
  19918
  19927
  19929
  19965
  20034
  20101
  20098
  20146
  20169
  20171
  20189
  20190
  20191
  20219
  20231
  20356
  20312
  20289
  20257
  20388
  20411
  20424
  20401
  20514
  20517
  20520
  20527
  20490
  20498
  20505
  20507
  20462
  20463
  20444
  20455
  20456
  20464
  20476
  20592
  20669
  20623
  20720
  20782
  20769
  20802
  20809
  20811
  20882
  20875
  20996
  20931
  20938
  20948
  20899
  21065
  21245
  21253
  21263
  21257
  21291
  21342
  21349
  21303
  21432
  21391
  21492
  21518
  21622
  21624
  21564
  21687
  21715
  21746
  21762
  21771
  21873
  21836
  21853
  21999
  21907
  22029
  22033
  22034
  22020
  22170
  22178
  22154
  22221
  22234
  22248
  22215
  22277
  22370
  22382
  22396
  22397
  22353
  22337
  22490
  22461
  22464
  22437
  22527
  22539
  22541
  22506
  22585
  22589
  22595
  22699
  22691
  22694
  22667
  22604
  22771
  22814
  22802
  22827
  22854
  22872
  22978
  22967
  22971
  22976
  22988
  23036
  23072
  23088
  23126
  23127
  23141
  23158
  23159
  23206
  23225
  23257
  23264
  23317
  23318
  23319
  23343
  23346
  23365
  23433
  23375
  23385
  23453
  23480
  23493
  23503
  23544
  23620
  23638
  23648
  23675
  23678
  23711
  23810
  23774
  23787
  23827
  23832
  23884
  23930
  23951
  23961
  23967
  23990
  24000
  24001
  24033
  24056
  24171
  24244
  24369
  24438
  24443
  24456
  24599
  24643
  24697
  24740
  24765
  24768
  24784
  24786
  24819
  24828
]
View formatted query    View runnable query    Explain query
15.68 ms
(5.29%) 		5 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/default/contents"
  "default_live"
]
View formatted query    View runnable query    Explain query
15.56 ms
(5.25%) 		1 
SELECT z.id, z.libelle, z.slug, count(*) as nbOuvrage FROM har_zone_geographique z INNER JOIN har_ouvrage_zone_geographique oz ON z.id = oz.zone_geographique_id INNER JOIN har_ouvrage o ON oz.ouvrage_id = o.id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE z.parent_id = :zoneGeographique AND dp.externe_id NOT IN (:disponibilitePapierIds) GROUP BY 1 ORDER BY 2 ASC
Parameters: 
[
  "zoneGeographique" => 20
  "disponibilitePapierIds" => "5,6"
]
View formatted query    View runnable query    Explain query
15.33 ms
(5.17%) 		1 
SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage_zone_geographique c, har_zone_geographique d WHERE d.id = :zoneGeographique AND b.type_intervenant_id = :type AND c.zone_geographique_id = d.id AND b.ouvrage_id = c.ouvrage_id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom
Parameters: 
[
  "zoneGeographique" => 20
  "type" => 1
]
View formatted query    View runnable query    Explain query
7.21 ms
(2.43%) 		52 
SELECT t0.thematique_principale AS thematique_principale_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.ouvrage_id AS ouvrage_id_5, t0.thematique_id AS thematique_id_6 FROM har_ouvrage_thematique t0 WHERE t0.ouvrage_id = ?
Parameters: 
[
  57535
]
View formatted query    View runnable query    Explain query
6.76 ms
(2.28%) 		48 
SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = ?
Parameters: 
[
  120
]
View formatted query    View runnable query    Explain query
3.97 ms
(1.34%) 		11 
SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_zone_geographique t0 WHERE t0.id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
3.46 ms
(1.17%) 		20 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/default/contents"
  "default_live"
]
View formatted query    View runnable query    Explain query
3.33 ms
(1.12%) 		1 
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/main_menu' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
3.20 ms
(1.08%) 		15 
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters: 
[
  "dd991113-3aa4-4e99-b3f3-684362ec7aa8"
  "default_live"
]
View formatted query    View runnable query    Explain query
3.18 ms
(1.07%) 		1 
SELECT h0_.libelle AS libelle_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.level AS level_3, h0_.externe_id AS externe_id_4, h0_.id AS id_5, h0_.created AS created_6, h0_.changed AS changed_7, h1_.libelle AS libelle_8, h1_.slug AS slug_9, h1_.description AS description_10, h1_.level AS level_11, h1_.externe_id AS externe_id_12, h1_.id AS id_13, h1_.created AS created_14, h1_.changed AS changed_15, h0_.parent_id AS parent_id_16, h1_.parent_id AS parent_id_17 FROM har_thematique h0_ LEFT JOIN har_thematique h1_ ON h0_.parent_id = h1_.id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h1_.libelle ASC, h0_.libelle ASC
Parameters: 
[
  241
  173
  186
  166
  348
  230
  170
  153
  120
  141
  165
  328
  159
  107
  344
  349
  323
  244
  89
  108
  171
  176
  307
  185
  78
  167
  345
  291
  373
  39
  370
  175
  334
  79
  157
  140
  285
  160
  327
  267
  314
  293
  300
  236
  408
  182
  325
  23
  35
  193
  3
  116
  358
  363
  188
  113
  394
  2
  13
  238
  254
  362
  295
  246
  30
  110
  172
  189
  342
  350
  400
  403
  152
  174
  190
  192
  233
  245
  248
  316
  336
  347
  22
  121
  122
  139
  155
  259
  286
  312
  322
  338
  360
  361
  387
  6
  50
  70
  75
  76
  81
  91
  93
  96
  97
  99
  112
  115
  117
  142
  147
  168
  187
  209
  223
  239
  240
  249
  255
  332
  333
  354
  377
  7
  12
  36
  72
  74
  77
  80
  84
  94
  98
  100
  101
  102
  104
  109
  111
  114
  137
  158
  177
  180
  184
  194
  198
  201
  214
  225
  228
  232
  237
  242
  247
  260
  261
  269
  278
  281
  282
  313
  330
  341
  359
  367
  369
  372
  375
  379
  383
  385
  388
  393
  395
  404
  410
]
View formatted query    View runnable query    Explain query
3.00 ms
(1.01%) 		1 
WITH RECURSIVE zones AS (
                    SELECT id, parent_id
                    FROM har_zone_geographique
                    WHERE parent_id = :parent_id
                    UNION ALL
                    SELECT zg.id, zg.parent_id
                    FROM har_zone_geographique zg
                    JOIN zones z ON zg.parent_id = z.id
                )
                SELECT DISTINCT z.id
                FROM zones z
                JOIN har_ouvrage_zone_geographique ozg ON ozg.zone_geographique_id = z.id;
Parameters: 
[
  "parent_id" => 20
]
View formatted query    View runnable query    Explain query
2.90 ms
(0.98%) 		1 
SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.hors_collection AS hors_collection_3, h0_.issn AS issn_4, h0_.erp_id AS erp_id_5, h0_.externe_id AS externe_id_6, h0_.id AS id_7, h0_.created AS created_8, h0_.changed AS changed_9, h0_.editeur_id AS editeur_id_10 FROM har_collection h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC
Parameters: 
[
  717
  748
  58
  253
  64
  90
  55
  60
  352
  68
  89
  772
  427
  57
  218
  226
  650
  241
  631
  198
  440
  213
  918
  222
  269
  350
  880
  976
  224
  971
  50
  200
  191
  642
  214
  65
  73
  230
  62
  1222
  1268
  256
  284
  662
  704
  843
  70
  93
  112
  412
  697
  826
  1075
  1133
  1174
  315
  827
  160
  207
  242
  702
  755
  788
  807
  814
  1093
  49
  61
  255
  282
  355
  532
  632
  654
  739
  752
  785
  968
  1209
  1211
  1255
  1300
  66
  67
  99
  103
  127
  170
  173
  196
  202
  209
  239
  276
  323
  336
  363
  452
  496
  698
  699
  723
  750
  773
  794
  818
  822
  825
  1069
  1160
  1166
  47
  51
  88
  180
  192
  251
  259
  267
  306
  385
  445
  549
  643
  663
  665
  677
  685
  691
  696
  707
  719
  731
  741
  770
  804
  837
  841
  876
  879
  883
  993
  995
  1099
  1119
  1137
  1144
  1195
  1348
  5
  97
  114
  125
  138
  142
  152
  174
  183
  210
  212
  217
  225
  250
  265
  272
  277
  297
  312
  314
  317
  321
  322
  335
  339
  356
  362
  367
  380
  416
  417
  419
  443
  444
  449
  523
  526
  537
  556
  581
  596
  619
  620
  622
  626
  630
  641
  661
  664
  672
  678
  683
  701
  728
  733
  751
  760
  764
  776
  782
  790
  793
  802
  811
  816
  833
  858
  866
  871
  874
  884
  892
  909
  912
  989
  1009
  1022
  1025
  1065
  1068
  1073
  1089
  1122
  1164
  1190
  1200
  1201
  1207
  1214
  1249
  1265
  1311
  1314
  1317
  1320
  1324
  1351
  1355
]
View formatted query    View runnable query    Explain query
2.69 ms
(0.91%) 		4 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.68 ms
(0.90%) 		14 
SELECT t0.libelle AS libelle_1, t0.description AS description_2, t0.date AS date_3, t0.id AS id_4, t0.created AS created_5, t0.changed AS changed_6, t0.ouvrage_id AS ouvrage_id_7 FROM har_prix t0 WHERE t0.ouvrage_id = ?
Parameters: 
[
  57535
]
View formatted query    View runnable query    Explain query
2.48 ms
(0.84%) 		33 
SELECT t0.zone_principale AS zone_principale_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.ouvrage_id AS ouvrage_id_5, t0.zone_geographique_id AS zone_geographique_id_6 FROM har_ouvrage_zone_geographique t0 WHERE t0.ouvrage_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.88 ms
(0.64%) 		12 
SELECT t0.nom AS nom_1, t0.slug AS slug_2, t0.description AS description_3, t0.hors_collection AS hors_collection_4, t0.issn AS issn_5, t0.erp_id AS erp_id_6, t0.externe_id AS externe_id_7, t0.id AS id_8, t0.created AS created_9, t0.changed AS changed_10, t0.editeur_id AS editeur_id_11 FROM har_collection t0 WHERE t0.id = ?
Parameters: 
[
  253
]
View formatted query    View runnable query    Explain query
1.02 ms
(0.34%) 		1 
SELECT h0_.libelle AS libelle_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.level AS level_3, h0_.externe_id AS externe_id_4, h0_.id AS id_5, h0_.created AS created_6, h0_.changed AS changed_7, h1_.libelle AS libelle_8, h1_.slug AS slug_9, h1_.description AS description_10, h1_.level AS level_11, h1_.externe_id AS externe_id_12, h1_.id AS id_13, h1_.created AS created_14, h1_.changed AS changed_15, h0_.parent_id AS parent_id_16, h1_.parent_id AS parent_id_17 FROM har_zone_geographique h0_ LEFT JOIN har_zone_geographique h1_ ON h0_.parent_id = h1_.id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.libelle ASC
Parameters: 
[
  20
  57
  60
  62
  58
  61
  59
]
View formatted query    View runnable query    Explain query
0.98 ms
(0.33%) 		1 
SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.externe_id AS externe_id_2, h0_.sous_titre AS sous_titre_3, h0_.description AS description_4, h0_.date_revue AS date_revue_5, h0_.abonnement AS abonnement_6, h0_.issn AS issn_7, h0_.periodicite AS periodicite_8, h0_.adresse AS adresse_9, h0_.code_postal AS code_postal_10, h0_.ville AS ville_11, h0_.email AS email_12, h0_.id AS id_13, h0_.created AS created_14, h0_.changed AS changed_15, h0_.editeur_id AS editeur_id_16, h0_.code_pays_id AS code_pays_id_17 FROM har_revue h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC
Parameters: 
[
  9
  93
  54
  194
  107
  133
  131
  152
  27
  184
  215
  228
  12
  30
  49
  79
  190
  16
  17
  56
  109
  209
]
View formatted query    View runnable query    Explain query
0.97 ms
(0.33%) 		1 
SELECT h0_.nom AS nom_0, h0_.nom_abrege AS nom_abrege_1, h0_.slug AS slug_2, h0_.description AS description_3, h0_.gln AS gln_4, h0_.groupehmt AS groupehmt_5, h0_.type AS type_6, h0_.adresse AS adresse_7, h0_.code_postal AS code_postal_8, h0_.ville AS ville_9, h0_.telephone AS telephone_10, h0_.telephone2 AS telephone2_11, h0_.email AS email_12, h0_.url AS url_13, h0_.externe_id AS externe_id_14, h0_.date_creation AS date_creation_15, h0_.date_modification AS date_modification_16, h0_.id AS id_17, h0_.created AS created_18, h0_.changed AS changed_19, h0_.logo_id AS logo_id_20, h0_.code_pays_id AS code_pays_id_21 FROM har_editeur h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC
Parameters: 
[
  8
  73
  45
  16
  82
  24
  34
  11
  14
  32
  15
  21
  80
  7
  9
  40
  46
  99
]
View formatted query    View runnable query    Explain query
0.96 ms
(0.32%) 		1 
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/footer' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.60 ms
(0.20%) 		5 
SELECT t0.type_intervenant_position AS type_intervenant_position_1, t0.intervenant_position AS intervenant_position_2, t0.id AS id_3, t0.created AS created_4, t0.changed AS changed_5, t0.ouvrage_id AS ouvrage_id_6, t0.type_intervenant_id AS type_intervenant_id_7, t0.intervenant_id AS intervenant_id_8 FROM har_ouvrage_intervenant t0 WHERE t0.ouvrage_id = ?
Parameters: 
[
  80664
]
View formatted query    View runnable query    Explain query
0.59 ms
(0.20%) 		5 
SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.slug AS slug_3, t0.photo_url_externe AS photo_url_externe_4, t0.structure_professionnelle AS structure_professionnelle_5, t0.site_web AS site_web_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.linkedin AS linkedin_9, t0.instagram AS instagram_10, t0.titres_diplomes AS titres_diplomes_11, t0.fonctions_actuelles AS fonctions_actuelles_12, t0.biographie AS biographie_13, t0.autres_parutions AS autres_parutions_14, t0.artiste_id AS artiste_id_15, t0.externe_id AS externe_id_16, t0.date_creation AS date_creation_17, t0.date_modification AS date_modification_18, t0.image_changed AS image_changed_19, t0.id AS id_20, t0.created AS created_21, t0.changed AS changed_22, t0.compte_id AS compte_id_23, t0.photo_id AS photo_id_24, t0.parent_id AS parent_id_25 FROM har_intervenant t0 WHERE t0.id = ?
Parameters: 
[
  55847
]
View formatted query    View runnable query    Explain query
0.42 ms
(0.14%) 		3 
SELECT t0.email AS email_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.telephone AS telephone_4, t0.telephone2 AS telephone2_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.adresse_intitule AS adresse_intitule_8, t0.adresse AS adresse_9, t0.complement_adresse AS complement_adresse_10, t0.code_postal AS code_postal_11, t0.ville AS ville_12, t0.code_auteur AS code_auteur_13, t0.isni AS isni_14, t0.securite_sociale AS securite_sociale_15, t0.securite_social_numero AS securite_social_numero_16, t0.rib_iban AS rib_iban_17, t0.rib_bic AS rib_bic_18, t0.droits_num AS droits_num_19, t0.externe_id AS externe_id_20, t0.image_auteur_url_externe AS image_auteur_url_externe_21, t0.date_creation AS date_creation_22, t0.date_modification AS date_modification_23, t0.reference AS reference_24, t0.civilite AS civilite_25, t0.indicateur_telephonique AS indicateur_telephonique_26, t0.indicateur_telephonique2 AS indicateur_telephonique2_27, t0.societe AS societe_28, t0.numero_tva AS numero_tva_29, t0.siret AS siret_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.ref_banque_intitule_compte AS ref_banque_intitule_compte_33, t0.ref_banque_iban AS ref_banque_iban_34, t0.ref_banque_code_swift AS ref_banque_code_swift_35, t0.image_changed AS image_changed_36, t0.client_auteur AS client_auteur_37, t0.id AS id_38, t0.created AS created_39, t0.changed AS changed_40, t0.idUser AS idUser_41, t0.image_auteur_id AS image_auteur_id_42, t0.code_pays_id AS code_pays_id_43 FROM har_compte t0 WHERE t0.idUser = ?
Parameters: 
[
  35411
]
View formatted query    View runnable query    Explain query
0.39 ms
(0.13%) 		1 
SELECT h0_.titre AS titre_0, h0_.source AS source_1, h0_.media AS media_2, h0_.media_url AS media_url_3, h0_.lien AS lien_4, h0_.lien_url AS lien_url_5, h0_.mois AS mois_6, h0_.annee AS annee_7, h0_.externe_id AS externe_id_8, h0_.en_ligne AS en_ligne_9, h0_.date_modification AS date_modification_10, h0_.id AS id_11, h0_.created AS created_12, h0_.changed AS changed_13, h0_.categorie_id AS categorie_id_14, h0_.media_image_id AS media_image_id_15, h0_.lien_fichier_id AS lien_fichier_id_16, h0_.idUsersCreator AS idUsersCreator_17, h0_.idUsersChanger AS idUsersChanger_18 FROM har_actualite_media h0_ WHERE h0_.en_ligne = ? ORDER BY h0_.created DESC LIMIT 3
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.34 ms
(0.12%) 		1 
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC, w1_.id ASC
Parameters: 
[
  "harmattan.feelandclic.dev"
  "dev"
  "default"
]
View formatted query    View runnable query    Explain query
0.32 ms
(0.11%) 		3 
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters: 
[
  35411
]
View formatted query    View runnable query    Explain query
0.29 ms
(0.10%) 		2 
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.26 ms
(0.09%) 		2 
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')))
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.24 ms
(0.08%) 		1 
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  78324
  19666
  77717
  76148
  74008
  75862
  2895
  1461
  537
  13
  1830
  1
  8
  9
  10
  1046
  11
  12
  14
  6434
  16092
  74511
  6402
  16137
  17636
  23898
  74344
  4710
  74399
  74481
  73971
  57535
  16
]
View formatted query    View runnable query    Explain query
0.22 ms
(0.07%) 		1 
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
Parameters: 
[
  128995
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.07%) 		1 
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_disponibilite_ouvrage h1_ ON h0_.disponibilite_papier_id = h1_.id WHERE h1_.externe_id NOT IN (?, ?) AND h0_.id IN (?, ?, ?, ?, ?) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC
Parameters: 
[
  5
  6
  80777
  80664
  80735
  80678
  80519
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.07%) 		2 
SELECT t0.nom AS nom_1, t0.disponible AS disponible_2, t0.externe_id AS externe_id_3, t0.id AS id_4, t0.created AS created_5, t0.changed AS changed_6 FROM har_disponibilite_ouvrage t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.20 ms
(0.07%) 		2 
SELECT t0.nom AS nom_1, t0.nom_abrege AS nom_abrege_2, t0.slug AS slug_3, t0.description AS description_4, t0.gln AS gln_5, t0.groupehmt AS groupehmt_6, t0.type AS type_7, t0.adresse AS adresse_8, t0.code_postal AS code_postal_9, t0.ville AS ville_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.email AS email_13, t0.url AS url_14, t0.externe_id AS externe_id_15, t0.date_creation AS date_creation_16, t0.date_modification AS date_modification_17, t0.id AS id_18, t0.created AS created_19, t0.changed AS changed_20, t0.logo_id AS logo_id_21, t0.code_pays_id AS code_pays_id_22 FROM har_editeur t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.07%) 		1 
SELECT h0_.titre AS titre_0, h0_.slug AS slug_1, h0_.format AS format_2, h0_.date_debut AS date_debut_3, h0_.date_fin AS date_fin_4, h0_.horaire AS horaire_5, h0_.resume AS resume_6, h0_.description AS description_7, h0_.savoir_plus AS savoir_plus_8, h0_.externe_id AS externe_id_9, h0_.en_ligne AS en_ligne_10, h0_.location AS location_11, h0_.nom_lieu AS nom_lieu_12, h0_.email AS email_13, h0_.informations AS informations_14, h0_.date_modification AS date_modification_15, h0_.id AS id_16, h0_.created AS created_17, h0_.changed AS changed_18, h0_.categorie_id AS categorie_id_19, h0_.image_id AS image_id_20 FROM har_evenement h0_ WHERE (h0_.date_debut >= ? OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= ?)) AND h0_.en_ligne = ? ORDER BY h0_.date_debut ASC LIMIT 4
Parameters: 
[
  "2025-12-13"
  "2025-12-13"
  1
]
View formatted query    View runnable query    Explain query
0.17 ms
(0.06%) 		1 
SELECT h0_.nom AS nom_0, h0_.periode_validite_du AS periode_validite_du_1, h0_.periode_validite_au AS periode_validite_au_2, h0_.formats AS formats_3, h0_.cibles AS cibles_4, h0_.montant AS montant_5, h0_.enabled AS enabled_6, h0_.affichage_bandeau AS affichage_bandeau_7, h0_.filtre_par AS filtre_par_8, h0_.id AS id_9, h0_.created AS created_10, h0_.changed AS changed_11, h0_.thematique_id AS thematique_id_12, h0_.zone_geographique_id AS zone_geographique_id_13, h0_.collection_id AS collection_id_14, h0_.idUsersCreator AS idUsersCreator_15, h0_.idUsersChanger AS idUsersChanger_16 FROM har_code_avantage h0_ WHERE h0_.periode_validite_du <= ? AND h0_.periode_validite_au >= ? AND JSON_CONTAINS(h0_.cibles, ?) = 1 AND ((h0_.filtre_par IS NULL OR h0_.filtre_par = '')) AND h0_.enabled = 1 AND h0_.affichage_bandeau = 1 ORDER BY h0_.montant DESC LIMIT 1
Parameters: 
[
  "2025-12-13 00:00:00"
  "2025-12-13 00:00:00"
  "["client"]"
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.05%) 		1 
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
Parameters: 
[
  128995
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.05%) 		1 
SELECT t0.type AS type_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.sous_titre AS sous_titre_4, t0.tome AS tome_5, t0.revue_numero AS revue_numero_6, t0.resume AS resume_7, t0.date_publication AS date_publication_8, t0.biographie AS biographie_9, t0.extrait_pdf AS extrait_pdf_10, t0.extrait_audio AS extrait_audio_11, t0.sommaire AS sommaire_12, t0.date_modification AS date_modification_13, t0.prix_papier AS prix_papier_14, t0.prix_numerique AS prix_numerique_15, t0.prix_audio AS prix_audio_16, t0.disponibilite_epub AS disponibilite_epub_17, t0.largeur AS largeur_18, t0.hauteur AS hauteur_19, t0.nb_pages AS nb_pages_20, t0.poids AS poids_21, t0.isbn AS isbn_22, t0.ean13 AS ean13_23, t0.ean_epub AS ean_epub_24, t0.ean_pdf AS ean_pdf_25, t0.multilingue AS multilingue_26, t0.avis_expert AS avis_expert_27, t0.externe_id AS externe_id_28, t0.image_recto_url_externe AS image_recto_url_externe_29, t0.image_verso_url_externe AS image_verso_url_externe_30, t0.updated AS updated_31, t0.added AS added_32, t0.image_changed AS image_changed_33, t0.a_la_une AS a_la_une_34, t0.lien_aplat AS lien_aplat_35, t0.id AS id_36, t0.created AS created_37, t0.changed AS changed_38, t0.revue_id AS revue_id_39, t0.image_recto_id AS image_recto_id_40, t0.image_verso_id AS image_verso_id_41, t0.disponibilite_papier_id AS disponibilite_papier_id_42, t0.disponibilite_numerique_id AS disponibilite_numerique_id_43, t0.disponibilite_audio_id AS disponibilite_audio_id_44, t0.editeur_id AS editeur_id_45, t0.collection_id AS collection_id_46, t0.sous_collection_id AS sous_collection_id_47, t0.nature_id AS nature_id_48, t0.type_couverture_id AS type_couverture_id_49 FROM har_ouvrage t0 WHERE t0.id IN (NULL)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.05%) 		1 
SELECT DISTINCT h0_.indicateur_telephonique AS indicateur_telephonique_0 FROM har_code_pays h0_ WHERE h0_.indicateur_telephonique IS NOT NULL AND h0_.indisponible = ? ORDER BY CAST(h0_.indicateur_telephonique AS signed) ASC
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.05%) 		1 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.04%) 		1 
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM har_evenement h0_ WHERE (h0_.date_debut >= ? OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= ?)) AND h0_.en_ligne = ? ORDER BY h0_.date_debut ASC
Parameters: 
[
  "2025-12-13"
  "2025-12-13"
  1
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.04%) 		1 
SELECT prefix, uri FROM phpcr_namespaces
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.12 ms
(0.04%) 		1 
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
Parameters: 
[
  128995
]
View formatted query    View runnable query    Explain query

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.

Entities Mapping

Class Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
App\Entity\ZoneGeographique No errors.
App\Entity\OuvrageZoneGeographique No errors.
App\Entity\CodeAvantage No errors.
App\Entity\Ouvrage No errors.
App\Entity\DisponibiliteOuvrage No errors.
App\Entity\Revue No errors.
Sulu\Bundle\MediaBundle\Entity\Media No errors.
App\Entity\Editeur No errors.
App\Entity\CollectionHar No errors.
App\Entity\SousCollection No errors.
App\Entity\Nature No errors.
App\Entity\TypeCouverture No errors.
App\Entity\OuvrageIntervenant No errors.
App\Entity\OuvrageThematique No errors.
App\Entity\OuvrageLangue No errors.
App\Entity\Alerte No errors.
App\Entity\PrixRecompense No errors.
App\Entity\CommandeDetail No errors.
App\Entity\Thematique No errors.
App\Entity\CodePays No errors.
App\Entity\IntervenantCollectionHar No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
App\Entity\User No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType No errors.
Sulu\Bundle\MediaBundle\Entity\File No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType No errors.
App\Entity\Compte No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact No errors.
Sulu\Bundle\ContactBundle\Entity\Url No errors.
Sulu\Bundle\ContactBundle\Entity\Note No errors.
Sulu\Bundle\ContactBundle\Entity\Email No errors.
Sulu\Bundle\ContactBundle\Entity\Phone No errors.
Sulu\Bundle\ContactBundle\Entity\Fax No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount No errors.
App\Entity\Intervenant No errors.
App\Entity\CompteLivraison No errors.
App\Entity\CompteFacturation No errors.
App\Entity\Commande No errors.
App\Entity\TypeIntervenant No errors.
App\Entity\IntervenantRevue No errors.
App\Entity\Evenement No errors.
App\Entity\AgendaCategorie No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation No errors.
Sulu\Bundle\SecurityBundle\Entity\Role No errors.
App\Entity\Langue No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryMeta No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation No errors.
Sulu\Bundle\ContactBundle\Entity\Address No errors.
Sulu\Bundle\ContactBundle\Entity\Position No errors.
Sulu\Bundle\ContactBundle\Entity\Account No errors.
Sulu\Bundle\ContactBundle\Entity\UrlType No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType No errors.
Sulu\Bundle\ContactBundle\Entity\PhoneType No errors.
Sulu\Bundle\ContactBundle\Entity\FaxType No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfileType No errors.
App\Entity\Cart No errors.
App\Entity\Paiement No errors.
App\Entity\CommandeSuivi No errors.
App\Entity\ActualiteMedia No errors.
App\Entity\ActualiteMediaCategorie No errors.
Sulu\Bundle\SecurityBundle\Entity\Permission No errors.
Sulu\Bundle\SecurityBundle\Entity\RoleSetting No errors.
Sulu\Bundle\SecurityBundle\Entity\SecurityType No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslationMedia No errors.
Sulu\Bundle\CategoryBundle\Entity\Keyword No errors.
Sulu\Bundle\ContactBundle\Entity\AccountAddress No errors.
Sulu\Bundle\ContactBundle\Entity\AddressType No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.