GET https://osm-commerces.cipherbliss.com/admin/stats/01317/followup-graph/travaux

Response
200 OK
Browse referrer URL
IP
74.7.227.28
Profiled on
Token
a2fe05

Query Metrics

24 Database Queries
20 Different statements
500.97 ms Query time
0 Invalid entities
4033 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
285.91 ms
(57.07%) 		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: 
[
  27221
  "travaux_count"
  "travaux_completion"
]
View formatted query    View runnable query    Explain query    View query backtrace
137.23 ms
(27.39%) 		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: 
[
  "01317"
]
View formatted query    View runnable query    Explain query    View query backtrace
18.86 ms
(3.76%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9.16 ms
(1.83%) 		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: 
[
  27221
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.10%) 		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: 
[
  27221
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.09%) 		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: 
[
  27221
  "travaux"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.08%) 		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: 
[
  "01317"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.06%) 		1 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"travaux","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-07-15 14:47:11"
  "https://osm-commerces.cipherbliss.com/admin/followup/01317/graph"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.04%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
29.70 ms
(5.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,
       ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson,
       CASE WHEN GeometryType(geom) IN ('POLYGON', 'MULTIPOLYGON')
            THEN ST_Area(geom::geography)
            ELSE NULL END AS area_m2
FROM osm_object_meta m
WHERE geom IS NOT NULL
  AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))
  AND osm_type IN ('way', 'relation')
  AND (tags->'landuse') = 'construction'
Parameters: 
[
  "MULTIPOLYGON(((5.344806 46.1713,5.344364 46.172714,5.343329 46.172741,5.343077 46.173627,5.34276 46.173753,5.341825 46.174236,5.34124 46.174457,5.34093 46.174479,5.340755 46.175421,5.339816 46.177201,5.3392 46.178616,5.339061 46.179601,5.338791 46.18089,5.338472 46.183404,5.338034 46.183774,5.33799 46.183933,5.337973 46.184233,5.338086 46.184569,5.337929 46.184703,5.337384 46.18562,5.336986 46.186727,5.336649 46.187111,5.336481 46.187462,5.336302 46.187964,5.336089 46.188306,5.336129 46.188403,5.336066 46.188633,5.335941 46.188849,5.335832 46.189123,5.335819 46.189241,5.336011 46.189307,5.336179 46.189241,5.336629 46.190161,5.336844 46.190767,5.336979 46.19102,5.337264 46.191354,5.33738 46.191747,5.337991 46.19201,5.338158 46.192609,5.338212 46.192995,5.338309 46.193277,5.338594 46.194409,5.338413 46.194436,5.33847 46.194788,5.338803 46.195608,5.339615 46.195672,5.33984 46.196262,5.339992 46.196718,5.340175 46.197148,5.340487 46.19767,5.341674 46.19911,5.342329 46.200092,5.34241 46.200255,5.342699 46.201039,5.342726 46.201588,5.342649 46.201853,5.342485 46.20207,5.342419 46.202207,5.342348 46.203011,5.342368 46.203295,5.342456 46.203615,5.342733 46.204484,5.342808 46.204771,5.342982 46.20559,5.343088 46.206556,5.343245 46.208293,5.343061 46.208289,5.342853 46.208813,5.343069 46.209213,5.343274 46.209387,5.343878 46.209076,5.34487 46.20894,5.345448 46.208834,5.34616 46.208816,5.346359 46.2089,5.349196 46.2086,5.351698 46.208127,5.352142 46.207935,5.352184 46.207529,5.352241 46.207393,5.352506 46.207476,5.352844 46.207737,5.353431 46.207811,5.354206 46.207746,5.355418 46.207398,5.35847 46.207452,5.360548 46.207531,5.360932 46.207431,5.360925 46.207297,5.361694 46.207141,5.36258 46.206757,5.363455 46.206148,5.364149 46.205814,5.365118 46.205744,5.366656 46.205914,5.366938 46.205896,5.367384 46.205797,5.368086 46.205744,5.369326 46.205631,5.369317 46.205451,5.370944 46.205587,5.371396 46.20553,5.371503 46.205122,5.374869 46.205032,5.376016 46.204686,5.376841 46.204349,5.378048 46.203911,5.37747 46.202846,5.376489 46.201522,5.376146 46.201171,5.375785 46.200505,5.375475 46.199613,5.375268 46.199394,5.375044 46.198859,5.374862 46.197919,5.374897 46.197378,5.374159 46.195777,5.373977 46.194837,5.37331 46.193324,5.371878 46.190887,5.371546 46.18959,5.370976 46.18866,5.37073 46.187721,5.370677 46.186777,5.370136 46.186386,5.368912 46.183609,5.368781 46.182995,5.369332 46.182426,5.369341 46.182142,5.369119 46.181641,5.368783 46.18113,5.368689 46.180818,5.368629 46.180715,5.368608 46.180406,5.368704 46.180368,5.368806 46.180218,5.368775 46.180107,5.368522 46.179497,5.368052 46.179195,5.367636 46.177539,5.367335 46.176783,5.366484 46.176626,5.366146 46.176364,5.366053 46.175871,5.365714 46.175042,5.36567 46.174902,5.365589 46.17433,5.36558 46.174164,5.365462 46.173805,5.365417 46.173236,5.365547 46.173067,5.365063 46.172769,5.365182 46.172474,5.364696 46.172182,5.364377 46.171934,5.364104 46.171684,5.363851 46.171408,5.363623 46.171089,5.363474 46.170726,5.363448 46.170507,5.363507 46.169861,5.363651 46.169441,5.363052 46.169293,5.362699 46.16936,5.362587 46.169198,5.362489 46.169199,5.361924 46.169455,5.361786 46.169499,5.361506 46.169494,5.361048 46.169642,5.360468 46.169772,5.358288 46.170227,5.355593 46.170704,5.354113 46.170878,5.353283 46.171126,5.3519 46.171883,5.350588 46.172774,5.350355 46.17323,5.349684 46.175262,5.349158 46.17559,5.348601 46.176235,5.347755 46.175093,5.347575 46.174961,5.347303 46.174686,5.347112 46.174549,5.346971 46.174493,5.346792 46.174272,5.346439 46.173946,5.346242 46.173825,5.345847 46.173431,5.3458 46.173336,5.345529 46.173158,5.345507 46.172988,5.345308 46.172776,5.345326 46.172597,5.3452 46.172342,5.344796 46.171778,5.344784 46.171511,5.344806 46.1713)))"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.31 ms
(1.66%) 		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: 
[
  "01317"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.82 ms
(0.56%) 		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
1.96 ms
(0.39%) 		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.91 ms
(0.38%) 		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.22 ms
(0.24%) 		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.60 ms
(0.12%) 		2 
SELECT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.10%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "01317"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.07%) 		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: 
[
  "01317"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.07%) 		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.23 ms
(0.05%) 		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 4031
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.