GET https://osm-labo.cipherbliss.com/admin/stats/17197/followup-graph/bicycle_parking

Response
200 OK
IP
216.73.216.10
Profiled on
Token
f78821

Query Metrics

13 Database Queries
8 Different statements
842.64 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.37 ms 
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.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters: 
[
  "17197"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.47 ms 
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.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters: 
[
  "17197"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.37 ms 
INSERT INTO stats (zone, completion_percent, places_count, avec_horaires, avec_adresse, avec_site, avec_accessibilite, avec_note, name, population, siren, code_epci, codes_postaux, date_created, date_modified, avec_siret, avec_name, osm_data_date_min, osm_data_date_avg, osm_data_date_max, budget_annuel, lat, lon, date_labourage_requested, date_labourage_done, kind) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "17197"
  null
  null
  null
  null
  null
  null
  null
  "Jonzac"
  3602
  211701974
  200041523
  "17500"
  "2026-02-04 10:29:58"
  "2026-02-04 10:29:58"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "request"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 4.12 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 120.46 ms 
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.zip_code = ?
Parameters: 
[
  "17197"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.30 ms 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"bicycle_parking","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-02-04 10:29:58"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
9 3.38 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.31 ms 
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters: 
[
  9396
  "bicycle_parking"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.24 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.59 ms 
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "[]"
  "[{"type":"node","id":5859032895,"user":"Alexvalallan","timestamp":"2022-04-25T15:02:48Z","changeset":120170712},{"type":"node","id":5859032896,"user":"Alexvalallan","timestamp":"2022-04-25T15:02:58Z","changeset":120170712},{"type":"node","id":5859032897,"user":"GilB","timestamp":"2018-08-26T13:42:01Z","changeset":62007204},{"type":"node","id":5859032898,"user":"GilB","timestamp":"2018-08-26T13:42:01Z","changeset":62007204},{"type":"node","id":9145877418,"user":"lmagreault","timestamp":"2025-11-15T10:41:22Z","changeset":174681213},{"type":"node","id":9160467617,"user":"lmagreault","timestamp":"2021-10-09T13:18:36Z","changeset":112300934},{"type":"node","id":9161025719,"user":"lmagreault","timestamp":"2023-09-26T20:24:13Z","changeset":141790823},{"type":"node","id":9210348732,"user":"lmagreault","timestamp":"2021-10-29T15:56:49Z","changeset":113130801},{"type":"node","id":9480656417,"user":"lmagreault","timestamp":"2025-02-20T12:04:11Z","changeset":162737882},{"type":"node","id":9644303664,"user":"lmagreault","timestamp":"2025-07-31T17:03:15Z","changeset":169781219},{"type":"node","id":9806383917,"user":"lmagreault","timestamp":"2023-03-08T11:03:25Z","changeset":133436116},{"type":"node","id":10033322817,"user":"lmagreault","timestamp":"2023-01-08T17:07:43Z","changeset":131023417},{"type":"node","id":10087381318,"user":"lmagreault","timestamp":"2022-10-09T17:05:57Z","changeset":127259282},{"type":"node","id":10093517517,"user":"lmagreault","timestamp":"2025-01-30T10:22:03Z","changeset":161931250},{"type":"node","id":10093517617,"user":"lmagreault","timestamp":"2025-01-31T16:21:31Z","changeset":161983374},{"type":"node","id":10095033718,"user":"lmagreault","timestamp":"2022-10-12T10:49:50Z","changeset":127407200},{"type":"node","id":10188242817,"user":"lmagreault","timestamp":"2022-11-16T10:45:07Z","changeset":128983510},{"type":"node","id":10235884910,"user":"lmagreault","timestamp":"2022-12-03T16:36:04Z","changeset":129682573},{"type":"node","id":10312960109,"user":"lmagreault","timestamp":"2024-11-29T09:33:19Z","changeset":159733674},{"type":"node","id":10313023611,"user":"lmagreault","timestamp":"2025-03-02T10:57:24Z","changeset":163116406},{"type":"node","id":10313082509,"user":"lmagreault","timestamp":"2023-09-26T20:40:38Z","changeset":141791316},{"type":"node","id":10313092926,"user":"lmagreault","timestamp":"2023-01-07T15:18:21Z","changeset":130984923},{"type":"node","id":10550781911,"user":"lmagreault","timestamp":"2023-01-13T17:50:44Z","changeset":131239750},{"type":"node","id":10587447105,"user":"lmagreault","timestamp":"2023-01-27T19:04:30Z","changeset":131785167},{"type":"node","id":10719903838,"user":"lmagreault","timestamp":"2023-03-08T11:03:25Z","changeset":133436116},{"type":"node","id":11220980216,"user":"lmagreault","timestamp":"2023-09-26T19:23:21Z","changeset":141789000},{"type":"node","id":11220980217,"user":"lmagreault","timestamp":"2023-09-26T19:23:21Z","changeset":141789000},{"type":"node","id":11221173358,"user":"lmagreault","timestamp":"2023-10-05T16:38:28Z","changeset":142198107},{"type":"node","id":11229252899,"user":"lmagreault","timestamp":"2023-09-30T16:08:07Z","changeset":141957860},{"type":"node","id":11581701838,"user":"lmagreault","timestamp":"2024-02-03T12:51:20Z","changeset":147018230},{"type":"node","id":11737296594,"user":"lmagreault","timestamp":"2024-03-16T17:57:17Z","changeset":148744060},{"type":"node","id":11773388339,"user":"lmagreault","timestamp":"2024-03-30T10:58:58Z","changeset":149346020},{"type":"node","id":11773879735,"user":"lmagreault","timestamp":"2024-03-30T17:26:00Z","changeset":149361791},{"type":"node","id":11773907245,"user":"lmagreault","timestamp":"2024-03-30T17:26:00Z","changeset":149361791},{"type":"node","id":12157446545,"user":"lmagreault","timestamp":"2024-09-05T10:21:57Z","changeset":156223636},{"type":"node","id":12364473953,"user":"lmagreault","timestamp":"2024-11-22T08:57:04Z","changeset":159448804},{"type":"node","id":12400044535,"user":"lmagreault","timestamp":"2024-12-06T11:42:21Z","changeset":159990721},{"type":"node","id":12400625085,"user":"lmagreault","timestamp":"2024-12-06T16:49:52Z","changeset":160002186},{"type":"node","id":12520141995,"user":"lmagreault","timestamp":"2025-01-21T08:14:32Z","changeset":161589930},{"type":"node","id":12520143715,"user":"lmagreault","timestamp":"2025-01-21T08:14:31Z","changeset":161589930},{"type":"node","id":12528747761,"user":"lmagreault","timestamp":"2025-01-24T07:26:01Z","changeset":161700475},{"type":"node","id":12546192980,"user":"lmagreault","timestamp":"2025-01-31T11:16:42Z","changeset":161973192},{"type":"node","id":12620923751,"user":"lmagreault","timestamp":"2025-02-26T17:18:06Z","changeset":162981090},{"type":"node","id":13039747046,"user":"lmagreault","timestamp":"2025-07-31T17:03:28Z","changeset":169781225},{"type":"node","id":13114938400,"user":"lmagreault","timestamp":"2025-09-02T16:46:47Z","changeset":171370732},{"type":"node","id":13306119208,"user":"lmagreault","timestamp":"2025-11-15T10:41:22Z","changeset":174681213}]"
  "bicycle_parking"
  9396
]
View formatted query    View runnable query    Explain query    View query backtrace
13 711.70 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Stats 1
App\Entity\ActionLog 1
App\Entity\ZonePlaces 1

Entities Mapping

Class Mapping 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\ActionLog No errors.