GET https://osm-labo.cipherbliss.com/admin/city-other-objects/16015

Response
200 OK
IP
216.73.216.164
Profiled on
Token
36ead4

Query Metrics

14 Database Queries
12 Different statements
271.77 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.37 ms
(0.13%) 		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: 
[
  "16015"
]
View formatted query    View runnable query    Explain query    View query backtrace

osm connection

Time▼ Count Info
224.99 ms
(82.79%) 		1 
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters: 
[
  "16015"
]
View formatted query    View runnable query    Explain query    View query backtrace
29.17 ms
(10.73%) 		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 akeys(tags) && ARRAY['amenity','shop','office','craft','leisure','healthcare','emergency','man_made','power','highway','railway','public_transport','landuse','historic','barrier','tourism','sport','place','waterway','natural','geological','route','military','traffic_sign','traffic_calming','seamark','route_master','water','airway','aerialway','building']::text[]
Parameters: 
[
  "MULTIPOLYGON(((0.18614 45.630518,0.186081 45.630484,0.185176 45.629738,0.185034 45.629636,0.184964 45.629417,0.184947 45.628726,0.184985 45.628404,0.185432 45.627588,0.185417 45.627538,0.184897 45.627123,0.184504 45.627272,0.18421 45.627333,0.183283 45.627706,0.18244 45.628063,0.18232 45.628049,0.182004 45.62818,0.18119 45.628595,0.180646 45.628811,0.180044 45.629075,0.179612 45.628134,0.179283 45.627523,0.179105 45.627525,0.177557 45.627786,0.177763 45.627529,0.177757 45.627477,0.178196 45.627049,0.178438 45.626614,0.178579 45.626313,0.178668 45.626003,0.178669 45.625873,0.178897 45.625386,0.178843 45.625055,0.178232 45.625274,0.177644 45.625643,0.177386 45.62588,0.176635 45.626208,0.175877 45.62658,0.175244 45.627073,0.174703 45.627457,0.174242 45.627822,0.173945 45.62781,0.173087 45.627912,0.172938 45.627915,0.171627 45.627823,0.171537 45.627801,0.171473 45.627674,0.171262 45.627634,0.170827 45.627609,0.170558 45.627613,0.169812 45.627689,0.1698 45.627643,0.16857 45.627674,0.168172 45.627666,0.168146 45.627947,0.168054 45.628542,0.167907 45.629205,0.167879 45.629499,0.167879 45.629896,0.167777 45.629883,0.16719 45.629963,0.166053 45.630067,0.165963 45.630006,0.165103 45.630134,0.16468 45.63018,0.164542 45.629728,0.163952 45.629771,0.163567 45.629781,0.163207 45.629819,0.162746 45.629828,0.162445 45.629858,0.162267 45.630114,0.161481 45.629358,0.160429 45.62957,0.159713 45.629553,0.15946 45.629516,0.158719 45.629537,0.157412 45.62942,0.157643 45.628575,0.157247 45.628537,0.156661 45.628417,0.155137 45.628083,0.154615 45.627974,0.154155 45.627947,0.153581 45.627829,0.153542 45.627101,0.153541 45.626669,0.153568 45.626261,0.153558 45.625682,0.153459 45.625232,0.153215 45.62483,0.152806 45.624484,0.152468 45.624293,0.152005 45.624116,0.150975 45.623864,0.149575 45.623571,0.14906 45.623441,0.148781 45.623355,0.148369 45.62319,0.147934 45.622972,0.14737 45.622565,0.147122 45.622294,0.146867 45.62197,0.145802 45.620408,0.14554 45.620005,0.144888 45.62034,0.144441 45.620475,0.144052 45.620672,0.143703 45.620824,0.14351 45.620979,0.143172 45.621062,0.14269 45.621283,0.142489 45.621423,0.142286 45.62146,0.141609 45.621726,0.14102 45.621987,0.140673 45.622121,0.140337 45.622324,0.140121 45.62239,0.140112 45.622446,0.140556 45.622903,0.140731 45.623223,0.141175 45.623615,0.14159 45.624068,0.141423 45.624113,0.14129 45.624228,0.140692 45.624563,0.140592 45.624646,0.14008 45.624983,0.139876 45.625183,0.139659 45.625538,0.139514 45.625703,0.13922 45.626124,0.139111 45.626363,0.139008 45.626448,0.139018 45.626552,0.138852 45.62663,0.138623 45.626948,0.138477 45.627077,0.138359 45.627244,0.138225 45.627326,0.137338 45.62764,0.136575 45.627886,0.136184 45.627976,0.135738 45.628189,0.135274 45.628339,0.134803 45.628567,0.134589 45.628704,0.133961 45.629012,0.133576 45.629243,0.133389 45.62933,0.132622 45.629836,0.132353 45.629991,0.132133 45.630169,0.131815 45.630253,0.131445 45.630415,0.131055 45.630623,0.130136 45.631199,0.129605 45.631637,0.129517 45.631767,0.12921 45.632709,0.12908 45.633027,0.128885 45.633644,0.128783 45.633754,0.128489 45.633934,0.127848 45.634284,0.126984 45.63481,0.126484 45.635046,0.126011 45.635454,0.125147 45.636144,0.124406 45.636553,0.124053 45.636794,0.123764 45.636953,0.123601 45.637,0.123458 45.637136,0.122917 45.637425,0.122537 45.637688,0.122104 45.637944,0.121852 45.638042,0.121547 45.638337,0.121072 45.638556,0.12069 45.638865,0.120404 45.638658,0.120263 45.638751,0.119574 45.639067,0.11929 45.639158,0.118997 45.639296,0.118861 45.639446,0.118553 45.63944,0.118564 45.639819,0.118241 45.639859,0.118078 45.640001,0.117998 45.64035,0.117648 45.640541,0.117179 45.640689,0.116691 45.6408,0.116581 45.640965,0.116336 45.641107,0.116014 45.641254,0.115852 45.64128,0.115285 45.641319,0.114953 45.641376,0.114683 45.641459,0.113972 45.641763,0.113358 45.641913,0.112949 45.642214,0.11271 45.64232,0.112533 45.642434,0.112285 45.642502,0.112149 45.642619,0.111698 45.642751,0.111194 45.642982,0.110917 45.643089,0.110705 45.643215,0.110298 45.643306,0.110202 45.64337,0.109907 45.643733,0.109335 45.643901,0.110024 45.644171,0.110391 45.644282,0.11119 45.64446,0.111612 45.644526,0.111731 45.64465,0.111573 45.64502,0.111344 45.645231,0.111241 45.645412,0.111245 45.645532,0.111351 45.645741,0.111619 45.646156,0.111004 45.646918,0.110915 45.647291,0.110954 45.647409,0.11152 45.648014,0.111826 45.648302,0.111916 45.648549,0.112641 45.649958,0.11266 45.650902,0.110438 45.65081,0.109055 45.650763,0.107853 45.6507,0.107597 45.650678,0.107259 45.650512,0.107044 45.650287,0.107048 45.649918,0.106946 45.649682,0.106843 45.649595,0.106925 45.650318,0.106932 45.650551,0.106837 45.650666,0.106141 45.650633,0.106076 45.651119,0.10586 45.651981,0.105529 45.652338,0.1052 45.65264,0.104829 45.653013,0.104599 45.65347,0.104368 45.65389,0.104048 45.654337,0.103661 45.654819,0.103366 45.655301,0.102965 45.655845,0.102732 45.656366,0.102526 45.656867,0.102331 45.65745,0.102136 45.65797,0.102015 45.658203,0.101645 45.658982,0.101135 45.65984,0.100718 45.660457,0.100365 45.661147,0.100129 45.661765,0.099903 45.662564,0.099729 45.663283,0.099627 45.664192,0.099676 45.66476,0.099777 45.665275,0.100194 45.666462,0.100485 45.667087,0.100696 45.667857,0.101078 45.668953,0.101331 45.66955,0.101742 45.67007,0.102258 45.670473,0.102851 45.67086,0.103638 45.67124,0.104328 45.671421,0.105054 45.671583,0.105851 45.671612,0.10648 45.671621,0.107023 45.671601,0.107589 45.671501,0.108147 45.671363,0.108897 45.67123,0.109651 45.670888,0.110069 45.670686,0.110522 45.670521,0.110939 45.670292,0.11128 45.670081,0.111675 45.669743,0.111962 45.669549,0.112201 45.669309,0.112409 45.669212,0.112543 45.669005,0.113036 45.668606,0.113518 45.668127,0.114039 45.667882,0.114549 45.667591,0.114994 45.667264,0.11605 45.666756,0.116443 45.666463,0.116872 45.66627,0.117473 45.666071,0.119059 45.665308,0.119664 45.665026,0.120362 45.664727,0.121338 45.664347,0.122094 45.664116,0.122774 45.663838,0.123033 45.663698,0.123373 45.663467,0.12362 45.663262,0.123865 45.662927,0.124126 45.662524,0.124643 45.662119,0.125108 45.661854,0.125795 45.661597,0.126316 45.661457,0.127214 45.66132,0.127891 45.661118,0.128476 45.66092,0.129686 45.660378,0.130469 45.660091,0.131261 45.659911,0.131897 45.659727,0.132624 45.659556,0.133286 45.659373,0.133855 45.659251,0.13445 45.659157,0.135138 45.659002,0.135709 45.658844,0.136113 45.658699,0.13654 45.65862,0.136766 45.658918,0.136936 45.659232,0.137325 45.659803,0.137947 45.660596,0.137892 45.660625,0.138372 45.661183,0.138428 45.661317,0.138179 45.661937,0.137937 45.662328,0.13754 45.662758,0.137168 45.6632,0.136506 45.663797,0.136036 45.664309,0.136327 45.664576,0.137124 45.665361,0.137947 45.666095,0.138373 45.665738,0.139101 45.665087,0.139211 45.665047,0.14016 45.664843,0.140633 45.664655,0.141089 45.664434,0.141673 45.664037,0.140897 45.663502,0.139643 45.662676,0.140416 45.66212,0.139652 45.661567,0.139898 45.661407,0.140237 45.66166,0.140669 45.661469,0.1406 45.66139,0.140712 45.661265,0.141124 45.661096,0.140772 45.660629,0.141159 45.660515,0.141396 45.660815,0.141663 45.661267,0.142024 45.66183,0.142204 45.662137,0.1427 45.662765,0.142513 45.663242,0.142595 45.663273,0.143159 45.663909,0.144001 45.664824,0.144286 45.665186,0.14453 45.665564,0.14762 45.664996,0.148995 45.664468,0.149336 45.664458,0.149905 45.664394,0.150593 45.664299,0.151493 45.664148,0.151919 45.664045,0.156037 45.662667,0.157523 45.662167,0.157531 45.662569,0.157662 45.662752,0.157945 45.663028,0.158001 45.663191,0.158111 45.663319,0.158352 45.663379,0.158545 45.663105,0.158782 45.662957,0.15916 45.663127,0.15935 45.663177,0.159405 45.663026,0.159677 45.662731,0.159784 45.66266,0.159988 45.662368,0.160126 45.662101,0.160121 45.662016,0.160416 45.662017,0.161302 45.66193,0.161667 45.661839,0.161725 45.661749,0.162403 45.661416,0.162231 45.661194,0.162305 45.661113,0.162673 45.660972,0.162698 45.66093,0.163608 45.660576,0.163428 45.660385,0.16495 45.660093,0.165177 45.660028,0.165366 45.660226,0.165644 45.660161,0.167452 45.659561,0.167605 45.659708,0.167768 45.659745,0.168444 45.659664,0.168868 45.659792,0.169003 45.659697,0.169158 45.659341,0.170744 45.659266,0.170894 45.659225,0.170922 45.658973,0.171022 45.658785,0.171206 45.658747,0.171694 45.659113,0.172055 45.659443,0.172315 45.659853,0.172619 45.660396,0.173093 45.66108,0.173566 45.661684,0.173598 45.661706,0.17461 45.662935,0.175501 45.663822,0.175847 45.664195,0.176014 45.664115,0.17672 45.663708,0.176911 45.663546,0.177459 45.663144,0.177665 45.662934,0.177976 45.662742,0.178252 45.662493,0.177914 45.662252,0.178292 45.661892,0.178644 45.661456,0.178829 45.661328,0.179206 45.661132,0.179745 45.660961,0.179952 45.660862,0.180606 45.660475,0.180633 45.660399,0.181481 45.6606,0.181599 45.660545,0.181697 45.660275,0.181959 45.659884,0.182353 45.659402,0.182458 45.659207,0.18279 45.658996,0.183202 45.658927,0.183701 45.658803,0.183962 45.658553,0.184204 45.658443,0.184899 45.658254,0.184926 45.658186,0.18515 45.658211,0.185756 45.656956,0.186346 45.656595,0.186776 45.656229,0.187043 45.656101,0.187249 45.655862,0.187748 45.655543,0.187758 45.6555,0.188394 45.655581,0.18877 45.655238,0.189006 45.654791,0.189059 45.654602,0.188988 45.654393,0.189821 45.654144,0.190355 45.653155,0.190427 45.652837,0.190382 45.652645,0.190306 45.652523,0.190073 45.6523,0.189849 45.652132,0.18944 45.651913,0.18848 45.651532,0.187889 45.65133,0.18738 45.65118,0.186914 45.651059,0.186338 45.65095,0.185942 45.650894,0.185299 45.65085,0.185315 45.650762,0.18437 45.650616,0.183361 45.650506,0.182873 45.650372,0.182081 45.650212,0.181804 45.650104,0.18122 45.649993,0.180821 45.650032,0.181166 45.649642,0.180863 45.649602,0.180861 45.649389,0.181018 45.648959,0.18108 45.648677,0.18127 45.648673,0.181364 45.648068,0.181531 45.647261,0.181632 45.646268,0.181579 45.645858,0.181475 45.645402,0.181368 45.645193,0.181091 45.644849,0.181197 45.644438,0.180309 45.644654,0.179996 45.644081,0.179637 45.643355,0.179225 45.642481,0.179534 45.642412,0.179044 45.641534,0.17834 45.641605,0.177989 45.641712,0.177055 45.640707,0.176857 45.640813,0.176165 45.640333,0.176239 45.640285,0.176528 45.639963,0.176208 45.63976,0.175943 45.639489,0.175843 45.639426,0.175366 45.638832,0.175742 45.638682,0.175259 45.638405,0.174637 45.638013,0.174692 45.637781,0.174627 45.637571,0.17452 45.637476,0.174581 45.637286,0.174695 45.637101,0.174934 45.636567,0.175235 45.636226,0.175405 45.636075,0.176011 45.635748,0.176566 45.635561,0.176917 45.635241,0.1774 45.634888,0.17766 45.634716,0.177899 45.634596,0.178232 45.634467,0.178753 45.633867,0.178987 45.633681,0.179056 45.633564,0.179384 45.633254,0.179574 45.633001,0.17982 45.632781,0.179978 45.632599,0.180244 45.632231,0.180495 45.632105,0.181157 45.632034,0.181507 45.632022,0.182332 45.63195,0.183002 45.631957,0.183325 45.631999,0.183805 45.63203,0.184091 45.631983,0.184387 45.631809,0.184988 45.631522,0.185209 45.631378,0.185595 45.631164,0.185758 45.631014,0.185922 45.630729,0.18614 45.630518)))"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.73 ms
(2.85%) 		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: 
[
  "16015"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.04 ms
(1.12%) 		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
2.12 ms
(0.78%) 		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
2.06 ms
(0.76%) 		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
0.91 ms
(0.34%) 		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.41 ms
(0.15%) 		1 
SELECT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.13%) 		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: 
[
  "16015"
]
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.25 ms
(0.09%) 		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\Stats 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.