Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

12652.96 ms Query time

0 Invalid entities

77376 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

11254.19 ms
(88.95%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.name IN (?, ?) ORDER BY s1_.id ASC, c0_.date ASC

Parameters:

[
  5081
  5551
  10863
  10876
  11070
  23214
  23315
  23579
  23687
  23857
  24006
  24011
  24091
  24110
  24181
  24216
  24434
  24441
  24495
  24536
  24549
  24551
  24596
  24606
  24618
  24644
  24651
  24658
  24679
  24687
  24701
  24702
  24741
  24753
  24760
  24768
  24775
  24782
  24790
  24823
  24870
  24913
  24914
  24925
  24929
  24945
  24965
  24977
  25007
  25051
  25053
  25065
  25068
  25070
  25093
  25130
  25131
  25132
  25137
  25142
  25155
  25189
  25194
  25222
  25247
  25256
  25281
  25337
  25359
  25363
  25375
  25383
  25417
  25428
  25492
  25498
  25502
  25511
  25515
  25531
  25533
  25535
  25542
  25547
  25581
  25582
  25589
  25597
  25643
  25645
  25646
  25654
  25688
  25690
  25692
  25704
  25711
  25712
  25714
  25717
  25729
  25732
  25736
  25737
  25738
  25740
  25743
  25762
  25770
  25777
  25785
  25823
  25832
  25839
  25840
  25863
  25867
  25868
  25875
  25877
  25880
  25881
  25909
  25950
  25964
  25968
  25972
  25978
  25979
  25987
  26006
  26011
  26022
  26024
  26025
  26033
  26035
  26036
  26037
  26039
  26040
  26055
  26059
  26065
  26067
  26072
  26098
  26108
  26110
  26111
  26115
  26118
  26122
  26129
  26132
  26139
  26141
  26148
  26180
  26181
  26184
  26185
  26186
  26187
  26189
  26190
  26192
  26193
  26195
  26196
  26198
  26201
  26204
  26205
  26206
  26207
  26222
  26224
  26229
  26230
  26233
  26248
  26256
  26257
  26258
  26262
  26263
  26275
  26298
  26299
  26300
  26302
  26303
  26322
  26332
  26354
  26361
  26362
  26371
  26379
  26387
  26394
  26395
  26397
  26400
  26401
  26402
  26403
  26404
  26405
  26407
  26409
  26411
  26412
  26417
  26420
  26421
  26422
  26423
  26424
  26425
  26426
  26427
  26428
  26429
  26430
  26431
  26438
  26439
  26440
  26441
  26442
  26443
  26446
  26447
  26448
  26452
  26453
  26454
  26455
  26457
  26458
  26459
  26460
  26462
  26463
  26467
  26468
  26471
  26472
  26473
  26475
  26476
  26477
  26479
  26480
  26483
  26484
  26486
  26489
  26490
  26491
  26492
  26494
  26495
  26497
  26500
  26501
  26503
  26504
  26505
  26507
  26508
  26509
  26510
  26511
  26512
  26514
  26515
  26516
  26517
  26518
  26519
  26520
  26522
  26523
  26524
  26525
  26526
  26527
  26528
  26529
  26530
  26531
  26532
  26534
  26536
  26537
  26538
  26540
  26541
  26543
  26544
  26545
  26547
  26548
  26549
  26550
  26552
  26554
  26555
  26557
  26558
  26559
  26560
  26562
  26563
  26564
  26565
  26566
  26569
  26570
  26572
  26573
  26574
  26577
  26578
  26579
  26580
  26581
  26583
  26585
  26587
  26588
  26589
  26590
  26591
  26592
  26593
  26594
  26596
  26597
  26598
  26600
  26601
  26602
  26604
  26606
  26608
  26609
  26610
  26612
  26614
  26617
  26619
  26620
  26621
  26623
  26624
  26625
  26626
  26627
  26628
  26631
  26632
  26633
  26634
  26635
  26637
  26638
  26640
  26641
  26642
  26643
  26644
  26645
  26646
  26647
  26649
  26650
  26651
  26652
  26653
  26654
  26655
  26659
  26660
  26661
  26662
  26663
  26664
  26667
  26669
  26670
  26671
  26673
  26674
  26675
  26676
  26677
  "places_completion"
  "places_freshness_days"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.measure AS measure_2,
  c0_.date AS date_3,
  c0_.stats_id AS stats_id_4
FROM
  city_follow_up c0_
  INNER JOIN stats s1_ ON c0_.stats_id = s1_.id
WHERE
  s1_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND c0_.name IN (?, ?)
ORDER BY
  s1_.id ASC,
  c0_.date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (5081, 5551, 10863, 10876, 11070, 23214, 23315, 23579, 23687, 23857, 24006, 24011, 24091, 24110, 24181, 24216, 24434, 24441, 24495, 24536, 24549, 24551, 24596, 24606, 24618, 24644, 24651, 24658, 24679, 24687, 24701, 24702, 24741, 24753, 24760, 24768, 24775, 24782, 24790, 24823, 24870, 24913, 24914, 24925, 24929, 24945, 24965, 24977, 25007, 25051, 25053, 25065, 25068, 25070, 25093, 25130, 25131, 25132, 25137, 25142, 25155, 25189, 25194, 25222, 25247, 25256, 25281, 25337, 25359, 25363, 25375, 25383, 25417, 25428, 25492, 25498, 25502, 25511, 25515, 25531, 25533, 25535, 25542, 25547, 25581, 25582, 25589, 25597, 25643, 25645, 25646, 25654, 25688, 25690, 25692, 25704, 25711, 25712, 25714, 25717, 25729, 25732, 25736, 25737, 25738, 25740, 25743, 25762, 25770, 25777, 25785, 25823, 25832, 25839, 25840, 25863, 25867, 25868, 25875, 25877, 25880, 25881, 25909, 25950, 25964, 25968, 25972, 25978, 25979, 25987, 26006, 26011, 26022, 26024, 26025, 26033, 26035, 26036, 26037, 26039, 26040, 26055, 26059, 26065, 26067, 26072, 26098, 26108, 26110, 26111, 26115, 26118, 26122, 26129, 26132, 26139, 26141, 26148, 26180, 26181, 26184, 26185, 26186, 26187, 26189, 26190, 26192, 26193, 26195, 26196, 26198, 26201, 26204, 26205, 26206, 26207, 26222, 26224, 26229, 26230, 26233, 26248, 26256, 26257, 26258, 26262, 26263, 26275, 26298, 26299, 26300, 26302, 26303, 26322, 26332, 26354, 26361, 26362, 26371, 26379, 26387, 26394, 26395, 26397, 26400, 26401, 26402, 26403, 26404, 26405, 26407, 26409, 26411, 26412, 26417, 26420, 26421, 26422, 26423, 26424, 26425, 26426, 26427, 26428, 26429, 26430, 26431, 26438, 26439, 26440, 26441, 26442, 26443, 26446, 26447, 26448, 26452, 26453, 26454, 26455, 26457, 26458, 26459, 26460, 26462, 26463, 26467, 26468, 26471, 26472, 26473, 26475, 26476, 26477, 26479, 26480, 26483, 26484, 26486, 26489, 26490, 26491, 26492, 26494, 26495, 26497, 26500, 26501, 26503, 26504, 26505, 26507, 26508, 26509, 26510, 26511, 26512, 26514, 26515, 26516, 26517, 26518, 26519, 26520, 26522, 26523, 26524, 26525, 26526, 26527, 26528, 26529, 26530, 26531, 26532, 26534, 26536, 26537, 26538, 26540, 26541, 26543, 26544, 26545, 26547, 26548, 26549, 26550, 26552, 26554, 26555, 26557, 26558, 26559, 26560, 26562, 26563, 26564, 26565, 26566, 26569, 26570, 26572, 26573, 26574, 26577, 26578, 26579, 26580, 26581, 26583, 26585, 26587, 26588, 26589, 26590, 26591, 26592, 26593, 26594, 26596, 26597, 26598, 26600, 26601, 26602, 26604, 26606, 26608, 26609, 26610, 26612, 26614, 26617, 26619, 26620, 26621, 26623, 26624, 26625, 26626, 26627, 26628, 26631, 26632, 26633, 26634, 26635, 26637, 26638, 26640, 26641, 26642, 26643, 26644, 26645, 26646, 26647, 26649, 26650, 26651, 26652, 26653, 26654, 26655, 26659, 26660, 26661, 26662, 26663, 26664, 26667, 26669, 26670, 26671, 26673, 26674, 26675, 26676, 26677) AND c0_.name IN ('places_completion', 'places_freshness_days') ORDER BY s1_.id ASC, c0_.date ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\PublicController->dashboard (line 710)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1255.29 ms
(9.92%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 432)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\ActionLogger->log (line 33)
4	App\Controller\PublicController->dashboard (line 671)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

117.39 ms
(0.93%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c0_.name IN (?, ?) ORDER BY s1_.id ASC, c0_.date ASC

Parameters:

[
  27658
  27659
  27660
  27661
  27662
  27664
  27665
  27666
  27667
  27668
  27669
  27670
  27671
  27672
  27673
  27675
  27676
  27677
  27678
  27679
  27680
  27682
  27683
  27684
  27686
  27687
  27688
  27689
  27690
  27691
  27692
  27693
  27694
  27695
  "places_completion"
  "places_freshness_days"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.measure AS measure_2,
  c0_.date AS date_3,
  c0_.stats_id AS stats_id_4
FROM
  city_follow_up c0_
  INNER JOIN stats s1_ ON c0_.stats_id = s1_.id
WHERE
  s1_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )
  AND c0_.name IN (?, ?)
ORDER BY
  s1_.id ASC,
  c0_.date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id IN (27658, 27659, 27660, 27661, 27662, 27664, 27665, 27666, 27667, 27668, 27669, 27670, 27671, 27672, 27673, 27675, 27676, 27677, 27678, 27679, 27680, 27682, 27683, 27684, 27686, 27687, 27688, 27689, 27690, 27691, 27692, 27693, 27694, 27695) AND c0_.name IN ('places_completion', 'places_freshness_days') ORDER BY s1_.id ASC, c0_.date ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\PublicController->dashboard (line 710)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

20.47 ms
(0.16%)

SELECT COUNT(*) FROM place t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  place t0

SELECT COUNT(*) FROM place t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Controller\PublicController->dashboard (line 756)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

4.75 ms
(0.04%)

SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zone AS zone_2,
  t0.completion_percent AS completion_percent_3,
  t0.places_count AS places_count_4,
  t0.avec_horaires AS avec_horaires_5,
  t0.avec_adresse AS avec_adresse_6,
  t0.avec_site AS avec_site_7,
  t0.avec_accessibilite AS avec_accessibilite_8,
  t0.avec_note AS avec_note_9,
  t0.name AS name_10,
  t0.population AS population_11,
  t0.siren AS siren_12,
  t0.code_epci AS code_epci_13,
  t0.codes_postaux AS codes_postaux_14,
  t0.date_created AS date_created_15,
  t0.date_modified AS date_modified_16,
  t0.avec_siret AS avec_siret_17,
  t0.avec_name AS avec_name_18,
  t0.avec_email AS avec_email_19,
  t0.osm_data_date_min AS osm_data_date_min_20,
  t0.osm_data_date_avg AS osm_data_date_avg_21,
  t0.osm_data_date_max AS osm_data_date_max_22,
  t0.budget_annuel AS budget_annuel_23,
  t0.lat AS lat_24,
  t0.lon AS lon_25,
  t0.date_labourage_requested AS date_labourage_requested_26,
  t0.date_labourage_done AS date_labourage_done_27,
  t0.kind AS kind_28
FROM
  stats t0

SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\PublicController->dashboard (line 675)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.73 ms
(0.01%)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "dashboard"
  "[]"
  "2026-07-12 20:09:06"
  "https://osm-commerces.cipherbliss.com/admin/delete/1958341"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO action_log (
  type, data, created_at, from_url, who
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('dashboard', '[]', '2026-07-12 20:09:06', 'https://osm-commerces.cipherbliss.com/admin/delete/1958341', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\ActionLogger->log (line 33)
7	App\Controller\PublicController->dashboard (line 671)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.15 ms
(0.00%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\ActionLogger->log (line 33)
4	App\Controller\PublicController->dashboard (line 671)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
osm	doctrine.dbal.osm_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\CityFollowUp	76116
App\Entity\Stats	1259
App\Entity\ActionLog	1

Entities Mapping

Class	Mapping errors
App\Entity\ActionLog	No errors.
App\Entity\Stats	No errors.
App\Entity\Place	No errors.
App\Entity\StatsHistory	No errors.
App\Entity\CityFollowUp	No errors.
App\Entity\ZonePlaces	No errors.
App\Entity\SireneEntreprise	No errors.

Symfony Profiler

GET https://osm-commerces.cipherbliss.com/dashboard

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping