Query Metrics
22
Database Queries
20
Different statements
383.31 ms
Query time
0
Invalid entities
4537
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
245.05 ms (63.93%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
80.89 ms (21.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.zip_code = ?
Parameters:
[
"14341"
]
|
||||||||||||||||||||||||||||||
|
12.03 ms (3.14%) |
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:
[ 27284 "email_count" "email_completion" ]
|
||||||||||||||||||||||||||||||
|
8.67 ms (2.26%) |
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:
[
27284
]
|
||||||||||||||||||||||||||||||
|
0.56 ms (0.15%) |
1 |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "[DEBUG][followupThemeGraph]" "{"theme":"email","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}" "2026-07-14 04:11:50" null null ]
|
||||||||||||||||||||||||||||||
|
0.45 ms (0.12%) |
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:
[
27284
]
|
||||||||||||||||||||||||||||||
|
0.41 ms (0.11%) |
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:
[ 27284 "email" ]
|
||||||||||||||||||||||||||||||
|
0.37 ms (0.10%) |
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:
[
"14341"
]
|
||||||||||||||||||||||||||||||
|
0.20 ms (0.05%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
osm connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
22.60 ms (5.90%) |
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 (exist(tags, 'email') OR exist(tags, 'contact:email'))
Parameters:
[
"MULTIPOLYGON(((-0.328104 49.126678,-0.334094 49.125694,-0.334303 49.12636,-0.334701 49.127017,-0.334945 49.127039,-0.335497 49.127146,-0.3364 49.127305,-0.337303 49.127484,-0.339304 49.127867,-0.341164 49.128205,-0.343482 49.128647,-0.345197 49.128964,-0.346197 49.129155,-0.347738 49.125997,-0.349776 49.126378,-0.353772 49.127135,-0.357121 49.127744,-0.357534 49.129062,-0.357848 49.13004,-0.35795 49.130535,-0.357922 49.130726,-0.358202 49.130735,-0.359682 49.130663,-0.360989 49.130592,-0.361188 49.130592,-0.361245 49.130752,-0.362352 49.13083,-0.364387 49.13096,-0.365339 49.130954,-0.366193 49.130926,-0.365778 49.132902,-0.365538 49.133894,-0.365526 49.134003,-0.364233 49.139923,-0.364 49.141001,-0.364367 49.141065,-0.365269 49.141281,-0.363126 49.143469,-0.361099 49.146715,-0.360545 49.146633,-0.359455 49.148957,-0.359396 49.149061,-0.358043 49.152103,-0.357411 49.153472,-0.357741 49.153511,-0.358132 49.153514,-0.357569 49.15571,-0.357619 49.156237,-0.359157 49.158561,-0.358484 49.15881,-0.358832 49.15942,-0.357276 49.159673,-0.35592 49.159931,-0.355862 49.160012,-0.355388 49.160075,-0.354771 49.160204,-0.354227 49.160278,-0.353842 49.160371,-0.351978 49.161109,-0.351638 49.161252,-0.352075 49.162259,-0.351183 49.162382,-0.351206 49.162423,-0.349032 49.163011,-0.34893 49.163043,-0.347301 49.160279,-0.344692 49.155692,-0.344181 49.154826,-0.344011 49.154516,-0.343146 49.153021,-0.342788 49.15242,-0.342475 49.151872,-0.342172 49.15129,-0.341556 49.150218,-0.340933 49.149166,-0.340435 49.148303,-0.339844 49.148319,-0.33892 49.148359,-0.337035 49.14827,-0.336092 49.148252,-0.335214 49.148183,-0.33487 49.148266,-0.334072 49.148185,-0.332674 49.14807,-0.32979 49.14776,-0.329656 49.147871,-0.328946 49.147521,-0.328849 49.147553,-0.328586 49.147424,-0.328007 49.147196,-0.327766 49.147178,-0.326165 49.146746,-0.325846 49.146652,-0.322231 49.145638,-0.321734 49.145503,-0.321596 49.145645,-0.319946 49.144956,-0.320146 49.144805,-0.318534 49.144294,-0.318131 49.144139,-0.31719 49.145129,-0.316013 49.144717,-0.315684 49.144512,-0.314731 49.144042,-0.313173 49.143202,-0.314944 49.141004,-0.310777 49.140042,-0.311208 49.138802,-0.312301 49.135465,-0.314272 49.135541,-0.31901 49.135729,-0.319202 49.135745,-0.319765 49.135291,-0.320279 49.134951,-0.320594 49.134768,-0.320722 49.13439,-0.321078 49.133798,-0.321715 49.132449,-0.322028 49.131848,-0.322277 49.131308,-0.322339 49.131231,-0.320816 49.129846,-0.320467 49.129466,-0.320258 49.12919,-0.323518 49.128074,-0.323824 49.12844,-0.325669 49.127714,-0.328104 49.126678)))"
]
|
||||||||||||||||||||||||||||||||
|
5.23 ms (1.37%) |
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:
[
"14341"
]
|
||||||||||||||||||||||||||||||||
|
1.72 ms (0.45%) |
1 |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
1.63 ms (0.43%) |
3 |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters:
[ "public" "osm_object_meta" ]
|
||||||||||||||||||||||||||||||||
|
1.34 ms (0.35%) |
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:
[]
|
||||||||||||||||||||||||||||||||
|
0.71 ms (0.18%) |
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:
[]
|
||||||||||||||||||||||||||||||||
|
0.44 ms (0.12%) |
1 |
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters:
[
"14341"
]
|
||||||||||||||||||||||||||||||||
|
0.29 ms (0.07%) |
1 |
SELECT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.28 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:
[
"14341"
]
|
||||||||||||||||||||||||||||||||
|
0.25 ms (0.07%) |
1 |
CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.20 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:
[]
|
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 | 4535 |
| 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. |