GET https://osm-labo.cipherbliss.com/admin/aggregate/department/12

Response
200 OK
IP
216.73.217.21
Profiled on
Token
63374b

Query Metrics

15 Database Queries
5 Different statements
2880.83 ms Query time
0 Invalid entities
43473 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 266.96 ms 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "admin/aggregate_department"
  "{"code":"12"}"
  "2026-07-14 02:58:29"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1207.96 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 3.81 ms 
SELECT s0_.id AS id_0, s0_.zone AS zone_1, s0_.completion_percent AS completion_percent_2, s0_.places_count AS places_count_3, s0_.avec_horaires AS avec_horaires_4, s0_.avec_adresse AS avec_adresse_5, s0_.avec_site AS avec_site_6, s0_.avec_accessibilite AS avec_accessibilite_7, s0_.avec_note AS avec_note_8, s0_.name AS name_9, s0_.population AS population_10, s0_.siren AS siren_11, s0_.code_epci AS code_epci_12, s0_.codes_postaux AS codes_postaux_13, s0_.date_created AS date_created_14, s0_.date_modified AS date_modified_15, s0_.avec_siret AS avec_siret_16, s0_.avec_name AS avec_name_17, s0_.avec_email AS avec_email_18, s0_.osm_data_date_min AS osm_data_date_min_19, s0_.osm_data_date_avg AS osm_data_date_avg_20, s0_.osm_data_date_max AS osm_data_date_max_21, s0_.budget_annuel AS budget_annuel_22, s0_.lat AS lat_23, s0_.lon AS lon_24, s0_.date_labourage_requested AS date_labourage_requested_25, s0_.date_labourage_done AS date_labourage_done_26, s0_.kind AS kind_27 FROM stats s0_ WHERE s0_.zone IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.population DESC
Parameters: 
[
  "12001"
  "12002"
  "12003"
  "12004"
  "12006"
  "12007"
  "12008"
  "12009"
  "12010"
  "12011"
  "12012"
  "12013"
  "12015"
  "12016"
  "12017"
  "12018"
  "12019"
  "12021"
  "12022"
  "12023"
  "12024"
  "12025"
  "12026"
  "12027"
  "12028"
  "12029"
  "12030"
  "12031"
  "12032"
  "12033"
  "12034"
  "12035"
  "12036"
  "12037"
  "12038"
  "12039"
  "12041"
  "12042"
  "12043"
  "12044"
  "12045"
  "12046"
  "12047"
  "12048"
  "12049"
  "12050"
  "12051"
  "12052"
  "12053"
  "12054"
  "12055"
  "12056"
  "12057"
  "12058"
  "12059"
  "12060"
  "12061"
  "12062"
  "12063"
  "12064"
  "12065"
  "12066"
  "12067"
  "12068"
  "12069"
  "12070"
  "12071"
  "12072"
  "12073"
  "12074"
  "12075"
  "12077"
  "12078"
  "12079"
  "12080"
  "12082"
  "12083"
  "12084"
  "12085"
  "12086"
  "12088"
  "12089"
  "12090"
  "12091"
  "12092"
  "12093"
  "12094"
  "12095"
  "12096"
  "12097"
  "12098"
  "12099"
  "12100"
  "12101"
  "12102"
  "12103"
  "12104"
  "12105"
  "12106"
  "12107"
  "12108"
  "12109"
  "12110"
  "12111"
  "12113"
  "12115"
  "12116"
  "12118"
  "12119"
  "12120"
  "12121"
  "12122"
  "12124"
  "12125"
  "12127"
  "12128"
  "12129"
  "12130"
  "12131"
  "12133"
  "12134"
  "12135"
  "12136"
  "12137"
  "12138"
  "12139"
  "12140"
  "12141"
  "12142"
  "12143"
  "12144"
  "12145"
  "12146"
  "12147"
  "12148"
  "12149"
  "12150"
  "12151"
  "12152"
  "12153"
  "12154"
  "12155"
  "12156"
  "12157"
  "12158"
  "12159"
  "12160"
  "12161"
  "12162"
  "12163"
  "12164"
  "12165"
  "12166"
  "12167"
  "12168"
  "12169"
  "12170"
  "12171"
  "12172"
  "12174"
  "12175"
  "12176"
  "12177"
  "12178"
  "12179"
  "12180"
  "12181"
  "12182"
  "12183"
  "12184"
  "12185"
  "12186"
  "12187"
  "12188"
  "12189"
  "12190"
  "12191"
  "12192"
  "12193"
  "12194"
  "12195"
  "12197"
  "12198"
  "12199"
  "12200"
  "12201"
  "12202"
  "12203"
  "12204"
  "12205"
  "12206"
  "12207"
  "12208"
  "12209"
  "12210"
  "12211"
  "12212"
  "12213"
  "12214"
  "12215"
  "12216"
  "12217"
  "12218"
  "12219"
  "12220"
  "12221"
  "12222"
  "12223"
  "12224"
  "12225"
  "12226"
  "12227"
  "12228"
  "12229"
  "12230"
  "12231"
  "12232"
  "12233"
  "12234"
  "12235"
  "12236"
  "12237"
  "12238"
  "12239"
  "12240"
  "12241"
  "12242"
  "12243"
  "12244"
  "12246"
  "12247"
  "12248"
  "12249"
  "12250"
  "12251"
  "12252"
  "12253"
  "12254"
  "12255"
  "12256"
  "12257"
  "12258"
  "12259"
  "12260"
  "12261"
  "12262"
  "12263"
  "12264"
  "12265"
  "12266"
  "12267"
  "12268"
  "12269"
  "12270"
  "12272"
  "12273"
  "12274"
  "12275"
  "12276"
  "12277"
  "12278"
  "12280"
  "12281"
  "12282"
  "12283"
  "12284"
  "12286"
  "12287"
  "12288"
  "12289"
  "12290"
  "12291"
  "12292"
  "12293"
  "12294"
  "12295"
  "12296"
  "12297"
  "12298"
  "12299"
  "12300"
  "12301"
  "12303"
  "12305"
  "12307"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 267.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26898
]
View formatted query    View runnable query    Explain query    View query backtrace
6 25.03 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  27073
]
View formatted query    View runnable query    Explain query    View query backtrace
7 32.25 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26516
]
View formatted query    View runnable query    Explain query    View query backtrace
8 69.49 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26072
]
View formatted query    View runnable query    Explain query    View query backtrace
9 34.11 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26600
]
View formatted query    View runnable query    Explain query    View query backtrace
10 1.76 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  27693
]
View formatted query    View runnable query    Explain query    View query backtrace
11 8.51 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  27660
]
View formatted query    View runnable query    Explain query    View query backtrace
12 896.49 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26632
]
View formatted query    View runnable query    Explain query    View query backtrace
13 9.70 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26904
]
View formatted query    View runnable query    Explain query    View query backtrace
14 30.57 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  27166
]
View formatted query    View runnable query    Explain query    View query backtrace
15 27.01 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters: 
[
  26707
]
View formatted query    View runnable query    Explain query    View query backtrace

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 43461
App\Entity\Stats 11
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.