GET https://osm-labo.cipherbliss.com/admin/stats/76254/followup-graph/power_pole

Response
200 OK
IP
185.191.171.19
Profiled on
Token
8aab2a

Query Metrics

22 Database Queries
20 Different statements
262.85 ms Query time
0 Invalid entities
4034 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
81.29 ms
(30.93%) 		1 
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: 
[
  "76254"
]
View formatted query    View runnable query    Explain query    View query backtrace
36.06 ms
(13.72%) 		1 
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 = ? AND c0_.name IN (?, ?) ORDER BY c0_.date ASC, c0_.id ASC
Parameters: 
[
  27386
  "power_pole_count"
  "power_pole_completion"
]
View formatted query    View runnable query    Explain query    View query backtrace
12.38 ms
(4.71%) 		1 
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: 
[
  27386
]
View formatted query    View runnable query    Explain query    View query backtrace
3.30 ms
(1.25%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(0.27%) 		1 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"power_pole","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-07-15 08:05:10"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.18%) 		1 
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.stats_id = ?
Parameters: 
[
  27386
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.16%) 		1 
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 = ? ORDER BY z0_.id ASC LIMIT 1
Parameters: 
[
  27386
  "power_pole"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.15%) 		1 
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 WHERE t0.zone = ? LIMIT 1
Parameters: 
[
  "76254"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.08%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
91.84 ms
(34.94%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "76254"
]
View formatted query    View runnable query    Explain query    View query backtrace
23.46 ms
(8.93%) 		1 
SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))
            AND ((tags->'power') = 'pole')
Parameters: 
[
  "MULTIPOLYGON(((0.224815 49.710657,0.224458 49.710563,0.223866 49.710467,0.223043 49.710306,0.22226 49.710095,0.220972 49.709672,0.220243 49.709521,0.219499 49.709419,0.218464 49.709301,0.218743 49.708442,0.217694 49.708177,0.217957 49.707555,0.218809 49.707567,0.21874 49.707219,0.218369 49.705052,0.21766 49.700896,0.217523 49.700768,0.215906 49.700076,0.215103 49.699763,0.214428 49.699549,0.214697 49.699343,0.213604 49.698451,0.202745 49.69414,0.202218 49.69433,0.201393 49.693623,0.200427 49.694072,0.200143 49.693692,0.199368 49.693237,0.19753 49.691749,0.194014 49.693547,0.193806 49.6934,0.193372 49.693017,0.193237 49.692871,0.191064 49.693762,0.189148 49.694747,0.185526 49.696929,0.184886 49.697347,0.184455 49.697587,0.18239 49.69894,0.182587 49.699173,0.182321 49.699347,0.182073 49.699365,0.181824 49.699479,0.181666 49.699638,0.181742 49.699843,0.182012 49.699982,0.182135 49.699997,0.1823 49.699922,0.182586 49.699861,0.18279 49.699696,0.183062 49.699536,0.183014 49.699399,0.183192 49.699194,0.183433 49.699067,0.183741 49.699041,0.184105 49.699137,0.184592 49.699355,0.184984 49.699612,0.185171 49.699757,0.185693 49.700261,0.185889 49.700482,0.186445 49.701029,0.186706 49.701324,0.186962 49.701457,0.187106 49.701661,0.18713 49.701778,0.187075 49.701903,0.187522 49.702124,0.18744 49.702199,0.187749 49.702279,0.18789 49.702227,0.188049 49.702368,0.188311 49.702398,0.18839 49.702472,0.188715 49.702615,0.189193 49.703239,0.189357 49.703394,0.189392 49.703584,0.189356 49.703816,0.189276 49.704003,0.189191 49.704091,0.188948 49.704177,0.188783 49.70414,0.188293 49.704215,0.188357 49.704327,0.188614 49.704456,0.189231 49.704581,0.189495 49.704561,0.189508 49.704332,0.18974 49.704194,0.190129 49.70412,0.190293 49.704164,0.190579 49.704141,0.190923 49.704055,0.191286 49.704268,0.191831 49.704686,0.192307 49.7051,0.192554 49.705428,0.192723 49.705513,0.193335 49.706085,0.193741 49.706521,0.193886 49.706627,0.193831 49.706743,0.193581 49.70698,0.193708 49.707163,0.193498 49.707248,0.193611 49.707362,0.193917 49.707194,0.19427 49.707167,0.194541 49.707096,0.19471 49.707006,0.194765 49.706797,0.195418 49.706555,0.195687 49.706423,0.195845 49.706394,0.196331 49.70656,0.196341 49.706738,0.196579 49.706707,0.196746 49.706576,0.197276 49.706514,0.197424 49.706605,0.19763 49.706588,0.197795 49.706661,0.197908 49.706627,0.198192 49.70676,0.198435 49.706822,0.199481 49.707264,0.199982 49.707484,0.20008 49.707436,0.200497 49.707625,0.201122 49.707981,0.201664 49.708398,0.201799 49.708464,0.202155 49.708751,0.202571 49.70912,0.203235 49.709792,0.203387 49.709966,0.204364 49.711229,0.204913 49.711916,0.205476 49.712693,0.205575 49.712866,0.20578 49.713356,0.20609 49.713777,0.206308 49.713985,0.206228 49.714186,0.205971 49.714404,0.205775 49.714534,0.205904 49.714609,0.206315 49.714377,0.206521 49.71421,0.20655 49.714124,0.206734 49.714058,0.206916 49.713886,0.207079 49.713835,0.207287 49.713838,0.207409 49.713996,0.20757 49.71399,0.20751 49.71372,0.207602 49.713647,0.207905 49.713688,0.208045 49.713663,0.208345 49.713761,0.208532 49.713885,0.208728 49.713852,0.208854 49.71376,0.209147 49.713676,0.209389 49.713693,0.209859 49.713864,0.21001 49.713997,0.210253 49.714115,0.210217 49.714186,0.210787 49.714229,0.211223 49.714378,0.211512 49.714413,0.211767 49.714581,0.212199 49.714795,0.212404 49.714849,0.212432 49.714947,0.212779 49.715088,0.213133 49.714961,0.213455 49.714926,0.213742 49.714981,0.21406 49.714967,0.214228 49.715011,0.214369 49.715169,0.214792 49.715217,0.214861 49.715304,0.215127 49.715252,0.215428 49.71533,0.215903 49.715593,0.216123 49.715571,0.216373 49.715795,0.216643 49.715826,0.216895 49.715895,0.217142 49.715999,0.217353 49.716143,0.217623 49.716267,0.218156 49.716643,0.218191 49.716823,0.218446 49.716947,0.218557 49.716953,0.21887 49.717061,0.219026 49.717003,0.219427 49.717019,0.219627 49.716913,0.219808 49.716888,0.220262 49.716953,0.220342 49.717021,0.220552 49.71703,0.221325 49.717302,0.221404 49.717377,0.22162 49.71736,0.221922 49.717421,0.222407 49.717553,0.22333 49.717659,0.224093 49.717655,0.224784 49.717699,0.225127 49.717769,0.225413 49.717752,0.225491 49.717146,0.225534 49.71693,0.225869 49.715618,0.22588 49.715343,0.225846 49.714711,0.224671 49.712262,0.224632 49.712168,0.224519 49.711303,0.224815 49.710657)))"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.57 ms
(2.12%) 		1 
SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref:INSEE') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1
Parameters: 
[
  "76254"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.76 ms
(0.67%) 		3 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters: 
[
  "public"
  "osm_object_meta"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.76 ms
(0.67%) 		1 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.39 ms
(0.53%) 		1 
SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.70 ms
(0.27%) 		1 
INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.13%) 		1 
CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.11%) 		1 
SELECT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.11%) 		1 
SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref:INSEE') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1
Parameters: 
[
  "76254"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.07%) 		1 
CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                )
Parameters: 
[]
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 4032
App\Entity\Stats 1
App\Entity\ActionLog 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\SireneEntreprise No errors.
App\Entity\ActionLog No errors.