GET https://osm-commerces.cipherbliss.com/admin/stats/38421/followup-graph/fire_hydrant

Response
200 OK
IP
216.73.216.164
Profiled on
Token
3041da

Query Metrics

24 Database Queries
20 Different statements
153.07 ms Query time
0 Invalid entities
4397 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
67.81 ms
(44.30%) 		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: 
[
  "38421"
]
View formatted query    View runnable query    Explain query    View query backtrace
22.01 ms
(14.38%) 		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: 
[
  25363
  "fire_hydrant_count"
  "fire_hydrant_completion"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.43 ms
(4.85%) 		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: 
[
  25363
]
View formatted query    View runnable query    Explain query    View query backtrace
5.13 ms
(3.35%) 		1 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"fire_hydrant","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-07-15 09:09:13"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
4.61 ms
(3.01%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(0.90%) 		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: 
[
  25363
  "fire_hydrant"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.25%) 		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: 
[
  "38421"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.23%) 		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: 
[
  25363
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.13%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
24.48 ms
(15.99%) 		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->'emergency') = 'fire_hydrant'
    OR (tags->'amenity') = 'fire_hydrant'
  )
Parameters: 
[
  "MULTIPOLYGON(((5.763019 45.195842,5.763557 45.195909,5.764336 45.196069,5.765073 45.196247,5.765388 45.196304,5.765671 45.196395,5.766357 45.196685,5.767327 45.197128,5.768007 45.196187,5.769454 45.194218,5.77075 45.192463,5.77205 45.190716,5.773097 45.190831,5.773497 45.19086,5.774146 45.190248,5.774568 45.189757,5.775318 45.188763,5.775922 45.188053,5.776357 45.187633,5.776525 45.187441,5.776779 45.187224,5.777122 45.186874,5.778126 45.185823,5.7788 45.185144,5.77887 45.185026,5.779689 45.184217,5.779992 45.183811,5.780466 45.183326,5.77946 45.182886,5.779617 45.182748,5.779453 45.182524,5.779409 45.182384,5.779446 45.182243,5.779708 45.182052,5.779918 45.181618,5.779995 45.181282,5.780034 45.180903,5.779905 45.180446,5.779496 45.180173,5.779468 45.180197,5.778812 45.179716,5.778483 45.179417,5.778532 45.179325,5.77883 45.179386,5.779594 45.178459,5.779452 45.1784,5.780693 45.177205,5.781594 45.176379,5.782638 45.175374,5.781334 45.173713,5.781664 45.17346,5.781927 45.172948,5.782062 45.172769,5.782447 45.172394,5.782618 45.171983,5.782876 45.171545,5.782988 45.171146,5.783232 45.170199,5.783892 45.168312,5.786235 45.159134,5.784825 45.15914,5.780276 45.15912,5.77551 45.159107,5.772352 45.159431,5.76943 45.159741,5.769274 45.159634,5.768711 45.159707,5.767513 45.159942,5.766254 45.16008,5.76411 45.160465,5.762195 45.160833,5.762625 45.161216,5.762085 45.161403,5.760088 45.162319,5.759883 45.162598,5.759643 45.162456,5.758652 45.161687,5.758461 45.161526,5.757897 45.161096,5.757732 45.160999,5.757529 45.160811,5.757173 45.160523,5.756691 45.160171,5.756338 45.160399,5.756198 45.160466,5.755939 45.160647,5.754693 45.161451,5.753886 45.161955,5.753679 45.161977,5.749043 45.162561,5.746267 45.162918,5.746338 45.162991,5.744086 45.165285,5.743022 45.166374,5.743949 45.16812,5.744153 45.168338,5.744785 45.169309,5.745118 45.170196,5.745422 45.171593,5.745621 45.171498,5.745751 45.171285,5.745983 45.171052,5.747153 45.169821,5.749185 45.169068,5.749725 45.168897,5.749812 45.16923,5.749985 45.169358,5.750037 45.16951,5.750282 45.169659,5.750458 45.169906,5.750592 45.170175,5.751027 45.170831,5.751187 45.171107,5.751267 45.17133,5.751375 45.171531,5.751495 45.171637,5.751925 45.17272,5.752375 45.173991,5.752709 45.175126,5.752851 45.175395,5.753078 45.175627,5.752898 45.175805,5.752626 45.176211,5.752598 45.17649,5.752325 45.17657,5.752033 45.177021,5.751831 45.17739,5.751684 45.177835,5.751455 45.178402,5.751098 45.178983,5.750858 45.179279,5.750672 45.179933,5.750453 45.180616,5.750357 45.180779,5.75026 45.180847,5.748997 45.181586,5.748238 45.182015,5.747987 45.182183,5.74786 45.182425,5.7474 45.184304,5.747349 45.184658,5.747438 45.185116,5.747383 45.185274,5.747193 45.18549,5.74681 45.185816,5.746754 45.185891,5.746593 45.185934,5.746544 45.186104,5.74641 45.186294,5.7464 45.186455,5.746501 45.186602,5.747089 45.187139,5.747798 45.18788,5.748028 45.188017,5.748386 45.188336,5.749281 45.189088,5.749889 45.189321,5.750191 45.189493,5.750619 45.189812,5.75095 45.190183,5.751189 45.190549,5.75155 45.191045,5.751875 45.191651,5.752184 45.192376,5.752477 45.193115,5.75278 45.194307,5.752939 45.194756,5.75309 45.195102,5.753318 45.195509,5.753576 45.195858,5.753807 45.196245,5.754005 45.196479,5.754421 45.196823,5.754725 45.197029,5.755019 45.197187,5.755313 45.197279,5.755614 45.197334,5.755993 45.197344,5.756563 45.197299,5.75673 45.197198,5.757027 45.197121,5.757701 45.196796,5.758257 45.196541,5.758862 45.196319,5.759316 45.196178,5.760207 45.195989,5.760937 45.195867,5.761551 45.1958,5.762489 45.195816,5.763019 45.195842)))"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.83 ms
(3.81%) 		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: 
[
  "38421"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.70 ms
(3.07%) 		2 
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
3.23 ms
(2.11%) 		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
1.71 ms
(1.12%) 		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.14 ms
(0.75%) 		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.76 ms
(0.50%) 		2 
SELECT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(0.48%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "38421"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(0.38%) 		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.35 ms
(0.23%) 		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: 
[
  "38421"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.17%) 		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 4394
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\SireneEntreprise No errors.
App\Entity\ActionLog No errors.