Query Metrics
24
Database Queries
20
Different statements
8715.89 ms
Query time
0
Invalid entities
4160
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.43 ms |
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:
[
"64256"
]
|
||||||||||||||||||||||||||||||
| 2 | 24.80 ms |
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:
[ 27449 "places_count" "places_completion" ]
|
||||||||||||||||||||||||||||||
| 3 | 69.54 ms |
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:
[
"64256"
]
|
||||||||||||||||||||||||||||||
| 4 | 0.23 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 24.81 ms |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "[DEBUG][followupThemeGraph]" "{"theme":"places","tagKey":null,"tagValue":null,"main_tags":[],"places_count":0,"filtered_count":0,"filtered_main_tags":[]}" "2026-07-17 21:20:18" null null ]
|
||||||||||||||||||||||||||||||
| 6 | 374.11 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 7 | 0.53 ms |
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:
[
27449
]
|
||||||||||||||||||||||||||||||
| 8 | 9.78 ms |
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:
[
27449
]
|
||||||||||||||||||||||||||||||
| 9 | 0.47 ms |
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:
[ 27449 "places" ]
|
osm connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.41 ms |
SELECT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 2 | 2.60 ms |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.22 ms |
SELECT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.55 ms |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.44 ms |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters:
[ "public" "osm_object_meta" ] |
||||||||||||||||||||||||||||||||||
| 6 | 0.40 ms |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters:
[ "public" "osm_object_history" ] |
||||||||||||||||||||||||||||||||||
| 7 | 3244.97 ms |
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:
[]
|
||||||||||||||||||||||||||||||||||
| 8 | 794.03 ms |
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:
[]
|
||||||||||||||||||||||||||||||||||
| 9 | 1691.13 ms |
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:
[
"64256"
]
|
||||||||||||||||||||||||||||||||||
| 10 | 1.00 ms |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?
Parameters:
[ "public" "osm_object_history" ] |
||||||||||||||||||||||||||||||||||
| 11 | 0.39 ms |
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:
[
"64256"
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.25 ms |
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:
[] |
||||||||||||||||||||||||||||||||||
| 13 | 373.21 ms |
CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 14 | 582.11 ms |
SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?
Parameters:
[
"64256"
]
|
||||||||||||||||||||||||||||||||||
| 15 | 1519.46 ms |
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->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[]) OR (exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> '') OR (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[]) OR (exist(tags, 'healthcare') AND COALESCE(tags->'healthcare','') <> '') OR (tags->'information') = 'office' OR (exist(tags, 'office') AND COALESCE(tags->'office','') <> '') )
Parameters:
[
"MULTIPOLYGON(((-1.351574 43.343893,-1.351676 43.344053,-1.351917 43.344311,-1.352095 43.344412,-1.352375 43.34443,-1.353006 43.34464,-1.353215 43.344833,-1.353257 43.345142,-1.353391 43.345366,-1.353653 43.345642,-1.353745 43.345836,-1.353808 43.346285,-1.353908 43.346458,-1.354237 43.346818,-1.354464 43.346984,-1.354548 43.34709,-1.354721 43.347657,-1.354718 43.347958,-1.354826 43.349551,-1.355468 43.352749,-1.355643 43.352759,-1.356213 43.354453,-1.357417 43.354951,-1.357675 43.355131,-1.357702 43.355535,-1.35841 43.356006,-1.358679 43.356356,-1.359129 43.357601,-1.359136 43.35886,-1.359305 43.359699,-1.359204 43.359766,-1.359061 43.360073,-1.358916 43.360253,-1.358932 43.362564,-1.359876 43.363836,-1.360254 43.364912,-1.360234 43.365814,-1.360322 43.365886,-1.360377 43.366046,-1.360474 43.366099,-1.360973 43.366088,-1.36139 43.366062,-1.361704 43.365995,-1.361791 43.36622,-1.362178 43.366223,-1.362953 43.366441,-1.363408 43.366521,-1.363746 43.366659,-1.363711 43.366736,-1.363534 43.366883,-1.363237 43.367226,-1.363025 43.367366,-1.362868 43.367508,-1.362788 43.367679,-1.362744 43.368074,-1.362691 43.368252,-1.362709 43.368401,-1.362589 43.368837,-1.362528 43.368984,-1.361958 43.369471,-1.362031 43.369653,-1.362309 43.369847,-1.362447 43.370018,-1.362797 43.370189,-1.362983 43.37033,-1.363332 43.37068,-1.363425 43.371043,-1.363607 43.371248,-1.363722 43.371459,-1.363461 43.371786,-1.36336 43.372033,-1.363135 43.372266,-1.363047 43.372557,-1.362866 43.372908,-1.362575 43.373214,-1.362403 43.373438,-1.362303 43.373665,-1.362071 43.37396,-1.362334 43.374418,-1.362545 43.374506,-1.363013 43.374834,-1.363247 43.375145,-1.363359 43.375373,-1.363773 43.375898,-1.36401 43.375841,-1.364187 43.375835,-1.364609 43.375974,-1.364858 43.376142,-1.36507 43.376382,-1.365583 43.376825,-1.365797 43.377066,-1.366109 43.37728,-1.366444 43.377577,-1.366586 43.377649,-1.367243 43.377742,-1.367571 43.377737,-1.367866 43.377809,-1.368608 43.378052,-1.368992 43.378131,-1.369314 43.378319,-1.369667 43.37833,-1.369856 43.378364,-1.370053 43.378483,-1.370225 43.378654,-1.370489 43.37867,-1.370905 43.378857,-1.371174 43.378909,-1.371322 43.379017,-1.371687 43.379448,-1.371861 43.379605,-1.372107 43.379767,-1.372139 43.379863,-1.372471 43.380111,-1.372577 43.380499,-1.372495 43.380677,-1.372352 43.380851,-1.372406 43.380978,-1.372328 43.381083,-1.372505 43.381199,-1.372509 43.381385,-1.372657 43.381565,-1.372661 43.381667,-1.372532 43.3817,-1.372485 43.381788,-1.37276 43.382081,-1.373092 43.382064,-1.373154 43.382089,-1.373512 43.382084,-1.373636 43.382153,-1.373631 43.3824,-1.373581 43.382591,-1.373793 43.382699,-1.374048 43.382735,-1.374195 43.382832,-1.374225 43.382967,-1.374429 43.383115,-1.374429 43.383281,-1.374573 43.383425,-1.374765 43.383395,-1.374981 43.383781,-1.375408 43.383722,-1.375672 43.383794,-1.375719 43.38408,-1.376029 43.384232,-1.37626 43.38441,-1.376454 43.384495,-1.376565 43.384622,-1.376646 43.384911,-1.376859 43.385236,-1.377063 43.385488,-1.377226 43.385567,-1.377773 43.385662,-1.377773 43.385955,-1.377836 43.386118,-1.377854 43.3863,-1.377822 43.386602,-1.377877 43.386741,-1.378106 43.386768,-1.378105 43.386923,-1.378177 43.386958,-1.378397 43.386884,-1.378932 43.38699,-1.378782 43.38721,-1.378882 43.387323,-1.379158 43.387265,-1.379184 43.387334,-1.379062 43.387483,-1.37905 43.387717,-1.379116 43.387784,-1.379274 43.387738,-1.37941 43.38782,-1.379445 43.387989,-1.3796 43.38806,-1.379851 43.388065,-1.379981 43.388148,-1.379929 43.388341,-1.380043 43.388362,-1.380233 43.388261,-1.380364 43.388266,-1.380588 43.388347,-1.380649 43.388407,-1.380709 43.388682,-1.380857 43.388736,-1.381001 43.388643,-1.381183 43.388702,-1.381007 43.389125,-1.380859 43.389201,-1.380517 43.389202,-1.380456 43.389279,-1.380555 43.389364,-1.381131 43.389585,-1.38123 43.389732,-1.381649 43.39001,-1.381556 43.390099,-1.381618 43.390292,-1.38147 43.39042,-1.381514 43.39048,-1.382001 43.390635,-1.382148 43.390713,-1.382118 43.391005,-1.382318 43.391052,-1.382438 43.391131,-1.382225 43.391236,-1.382183 43.391459,-1.382017 43.391488,-1.381877 43.391452,-1.381678 43.391781,-1.381596 43.392067,-1.381816 43.392091,-1.381933 43.392151,-1.382275 43.392167,-1.382481 43.392248,-1.382691 43.392531,-1.382885 43.392622,-1.383101 43.392668,-1.383206 43.392683,-1.383323 43.392799,-1.383336 43.392961,-1.383285 43.39313,-1.383357 43.393272,-1.383617 43.393295,-1.383794 43.393493,-1.384066 43.393522,-1.384424 43.393677,-1.38464 43.393689,-1.384971 43.393826,-1.385042 43.393979,-1.384919 43.394232,-1.384921 43.394343,-1.385024 43.394762,-1.384816 43.394644,-1.384628 43.394657,-1.384509 43.39483,-1.384462 43.395027,-1.384251 43.395304,-1.384289 43.395389,-1.384127 43.39569,-1.383951 43.395793,-1.383684 43.395795,-1.383704 43.395904,-1.38404 43.396066,-1.384265 43.396331,-1.38431 43.396576,-1.384277 43.396649,-1.383903 43.396925,-1.383945 43.397031,-1.384276 43.397138,-1.38435 43.397203,-1.384302 43.397376,-1.384476 43.397493,-1.384554 43.397596,-1.384435 43.397689,-1.384755 43.397753,-1.384878 43.397824,-1.385234 43.397964,-1.38555 43.398049,-1.385741 43.397945,-1.385764 43.397865,-1.385433 43.397709,-1.385469 43.39763,-1.385863 43.397531,-1.386227 43.397588,-1.386504 43.397595,-1.386691 43.397653,-1.38692 43.397825,-1.387048 43.398165,-1.387315 43.398244,-1.387304 43.398582,-1.387326 43.398636,-1.387523 43.398716,-1.388145 43.398732,-1.388237 43.398771,-1.38836 43.39895,-1.388429 43.399302,-1.388547 43.399448,-1.388782 43.399448,-1.388936 43.39921,-1.389096 43.399261,-1.38928 43.399482,-1.389486 43.399732,-1.389581 43.399907,-1.389829 43.399999,-1.39047 43.400287,-1.390717 43.400466,-1.390441 43.400853,-1.390234 43.400972,-1.389983 43.401379,-1.390071 43.401446,-1.390443 43.401502,-1.390733 43.401766,-1.390885 43.402004,-1.391138 43.402109,-1.391427 43.402098,-1.391661 43.402171,-1.391711 43.402258,-1.391652 43.402446,-1.391515 43.402605,-1.391266 43.402773,-1.391107 43.403014,-1.391311 43.403266,-1.391264 43.403353,-1.391035 43.403494,-1.390896 43.403665,-1.390887 43.403873,-1.390985 43.404064,-1.391131 43.404559,-1.39124 43.404867,-1.391205 43.405288,-1.391172 43.405375,-1.390795 43.405579,-1.390333 43.405904,-1.390277 43.406159,-1.390313 43.406379,-1.390465 43.406923,-1.390532 43.406965,-1.390557 43.407148,-1.390367 43.407294,-1.390118 43.407339,-1.38995 43.407298,-1.389849 43.40733,-1.389804 43.407527,-1.389412 43.40756,-1.389346 43.407622,-1.389335 43.40784,-1.389497 43.408018,-1.389652 43.408132,-1.389433 43.408612,-1.389366 43.408649,-1.3892 43.408569,-1.388861 43.408504,-1.388575 43.408573,-1.388263 43.408837,-1.38794 43.408745,-1.387721 43.408594,-1.387448 43.408564,-1.387067 43.408671,-1.386637 43.408854,-1.386339 43.408862,-1.386063 43.408976,-1.385909 43.408974,-1.385676 43.408869,-1.385372 43.408931,-1.385009 43.409153,-1.384743 43.409281,-1.384484 43.409348,-1.384174 43.409255,-1.383873 43.409219,-1.383423 43.409119,-1.383394 43.409161,-1.383605 43.40941,-1.383611 43.409485,-1.383438 43.40973,-1.383183 43.409811,-1.382951 43.409825,-1.382789 43.409968,-1.382515 43.410126,-1.382466 43.410217,-1.382556 43.410376,-1.382746 43.410506,-1.382811 43.410655,-1.382671 43.410767,-1.382329 43.410828,-1.381881 43.41084,-1.381531 43.411096,-1.381189 43.411577,-1.381143 43.411686,-1.381037 43.412157,-1.380858 43.412272,-1.380828 43.412635,-1.380967 43.412871,-1.380883 43.412944,-1.380667 43.413026,-1.380282 43.413115,-1.380063 43.413256,-1.379887 43.413465,-1.379776 43.41352,-1.379605 43.413701,-1.379457 43.413935,-1.379209 43.41413,-1.378803 43.414239,-1.378278 43.414506,-1.378074 43.414765,-1.377987 43.414818,-1.377658 43.414881,-1.377148 43.415036,-1.376757 43.415306,-1.376701 43.415389,-1.376755 43.415524,-1.377071 43.41581,-1.37748 43.416036,-1.377863 43.41618,-1.378218 43.416246,-1.378723 43.416213,-1.379376 43.416253,-1.379664 43.416083,-1.379892 43.415749,-1.380129 43.415619,-1.380287 43.41562,-1.381421 43.415942,-1.38181 43.416113,-1.382078 43.416386,-1.382291 43.416653,-1.38261 43.417111,-1.382684 43.417276,-1.382893 43.417891,-1.383084 43.418115,-1.383357 43.418638,-1.383605 43.418997,-1.38388 43.419303,-1.384128 43.419411,-1.384723 43.419518,-1.384989 43.419762,-1.385253 43.420039,-1.385254 43.420244,-1.385073 43.420346,-1.385101 43.420487,-1.384924 43.420449,-1.38467 43.420329,-1.384481 43.420282,-1.384259 43.420279,-1.384103 43.420347,-1.383989 43.420521,-1.384012 43.420701,-1.384085 43.420906,-1.384214 43.42102,-1.384417 43.421113,-1.384484 43.421201,-1.384275 43.421323,-1.384083 43.421302,-1.383963 43.421075,-1.383712 43.421024,-1.383536 43.421261,-1.383428 43.421507,-1.383421 43.421611,-1.383492 43.421813,-1.38349 43.42203,-1.383542 43.422128,-1.383546 43.422303,-1.383348 43.422464,-1.383286 43.422641,-1.383495 43.422807,-1.384263 43.423132,-1.385141 43.423359,-1.385699 43.423374,-1.386099 43.423311,-1.386635 43.423161,-1.386801 43.423167,-1.386843 43.423365,-1.387143 43.423593,-1.387298 43.423618,-1.387638 43.4236,-1.38783 43.423797,-1.387853 43.424012,-1.387949 43.424162,-1.388053 43.424237,-1.388438 43.424159,-1.388593 43.424209,-1.388724 43.424319,-1.388937 43.424635,-1.388952 43.424783,-1.388784 43.424915,-1.38875 43.425072,-1.388843 43.425155,-1.38903 43.425179,-1.38906 43.425305,-1.388946 43.425403,-1.388976 43.425482,-1.388863 43.42561,-1.388757 43.425815,-1.388565 43.426048,-1.388351 43.426155,-1.38556 43.426488,-1.384588 43.427177,-1.384206 43.427281,-1.383472 43.427574,-1.382982 43.427739,-1.381937 43.428117,-1.38134 43.428302,-1.381028 43.428419,-1.37999 43.429352,-1.379548 43.429718,-1.379512 43.429817,-1.379635 43.430006,-1.379855 43.430247,-1.379971 43.430425,-1.380068 43.430735,-1.380103 43.431005,-1.380095 43.431492,-1.380116 43.431851,-1.380069 43.432417,-1.379963 43.432746,-1.379735 43.432999,-1.379514 43.433141,-1.379171 43.433326,-1.378835 43.433474,-1.37849 43.433744,-1.378039 43.433928,-1.377792 43.434054,-1.377221 43.434185,-1.376897 43.43421,-1.376766 43.434168,-1.376549 43.434179,-1.376277 43.434308,-1.37597 43.434363,-1.375684 43.434657,-1.375404 43.434788,-1.37507 43.434834,-1.374622 43.434994,-1.374292 43.435176,-1.374072 43.435209,-1.373688 43.435355,-1.37333 43.43538,-1.37277 43.435369,-1.372551 43.435404,-1.372015 43.435634,-1.37199 43.435699,-1.371697 43.435878,-1.371638 43.436048,-1.371647 43.436281,-1.371404 43.436328,-1.371048 43.436477,-1.370937 43.436617,-1.370788 43.436717,-1.370525 43.436819,-1.370382 43.437025,-1.370076 43.437098,-1.369946 43.43724,-1.369919 43.437432,-1.369812 43.437702,-1.370026 43.437648,-1.37019 43.437697,-1.370152 43.437823,-1.370059 43.437868,-1.369838 43.437883,-1.369746 43.437991,-1.369919 43.438087,-1.369738 43.438142,-1.369475 43.438346,-1.369516 43.438509,-1.369431 43.438692,-1.369399 43.439054,-1.369494 43.439216,-1.369446 43.439474,-1.36955 43.439677,-1.369454 43.439811,-1.369036 43.439826,-1.36889 43.439913,-1.368759 43.44019,-1.368766 43.440271,-1.368907 43.440377,-1.3688 43.440475,-1.368599 43.440556,-1.363533 43.43972,-1.362533 43.439323,-1.360906 43.438548,-1.360697 43.438463,-1.358871 43.43764,-1.358891 43.437478,-1.35772 43.437347,-1.35762 43.437263,-1.357456 43.437314,-1.356662 43.437235,-1.345307 43.436118,-1.342504 43.43584,-1.342196 43.435774,-1.341362 43.435637,-1.34052 43.435483,-1.339781 43.435359,-1.339152 43.435237,-1.33605 43.434715,-1.335899 43.434382,-1.335852 43.434346,-1.335763 43.434079,-1.3357 43.434016,-1.335496 43.434066,-1.335167 43.434001,-1.334939 43.434081,-1.334758 43.434282,-1.334659 43.434561,-1.334479 43.434702,-1.334351 43.43472,-1.334176 43.434811,-1.333972 43.434782,-1.333665 43.43467,-1.333448 43.434699,-1.333333 43.434864,-1.333225 43.434858,-1.333093 43.435229,-1.332936 43.435387,-1.332458 43.435361,-1.332405 43.435021,-1.332137 43.434864,-1.331754 43.435081,-1.331476 43.435085,-1.330924 43.434955,-1.330469 43.434764,-1.330076 43.434734,-1.329786 43.43475,-1.329601 43.434819,-1.329304 43.434828,-1.328987 43.434729,-1.328855 43.434724,-1.328626 43.434801,-1.328391 43.434777,-1.328123 43.4346,-1.32791 43.434616,-1.327824 43.434749,-1.327635 43.434935,-1.327447 43.435229,-1.32734 43.435501,-1.327011 43.435612,-1.326558 43.435571,-1.325651 43.435687,-1.325531 43.435686,-1.32518 43.435558,-1.324927 43.435537,-1.324641 43.43559,-1.324337 43.43555,-1.324034 43.435395,-1.323936 43.435374,-1.323849 43.435497,-1.323678 43.435573,-1.323648 43.435426,-1.32354 43.435179,-1.323523 43.435008,-1.323367 43.435017,-1.322806 43.435104,-1.322565 43.435053,-1.322101 43.434823,-1.32167 43.434816,-1.321635 43.434606,-1.321578 43.434502,-1.321358 43.434346,-1.321228 43.434317,-1.320974 43.434357,-1.320728 43.434461,-1.320395 43.434559,-1.319648 43.434707,-1.319358 43.434257,-1.319173 43.43385,-1.318879 43.433469,-1.318759 43.433357,-1.318237 43.433697,-1.317695 43.434002,-1.317311 43.434028,-1.316221 43.434413,-1.315248 43.434488,-1.314338 43.434786,-1.314131 43.434828,-1.31365 43.435023,-1.312875 43.43528,-1.312026 43.435544,-1.311458 43.435707,-1.311184 43.43574,-1.310626 43.435741,-1.309861 43.435716,-1.309389 43.435777,-1.308545 43.436058,-1.307726 43.436299,-1.307285 43.436372,-1.306532 43.436418,-1.305965 43.436437,-1.304522 43.436505,-1.304299 43.436538,-1.303365 43.436806,-1.302364 43.436971,-1.301813 43.437039,-1.301389 43.43712,-1.300941 43.43723,-1.299904 43.437531,-1.299669 43.437583,-1.298344 43.43771,-1.295816 43.43796,-1.295475 43.437964,-1.295127 43.437924,-1.2947 43.437839,-1.294355 43.43772,-1.293851 43.437409,-1.291935 43.436808,-1.291006 43.436757,-1.290201 43.437378,-1.286335 43.440561,-1.285521 43.441124,-1.283485 43.44261,-1.282305 43.443596,-1.282161 43.443677,-1.281152 43.443967,-1.280274 43.444272,-1.279952 43.444371,-1.279688 43.444397,-1.278913 43.444391,-1.278693 43.444414,-1.277977 43.444593,-1.27723 43.444756,-1.276522 43.444883,-1.276278 43.444955,-1.275929 43.445149,-1.275589 43.44543,-1.275409 43.445623,-1.274946 43.446228,-1.273986 43.44578,-1.273735 43.445448,-1.273626 43.445195,-1.273441 43.444974,-1.27309 43.444641,-1.272953 43.444308,-1.272864 43.444189,-1.272645 43.444064,-1.271646 43.443675,-1.271415 43.443635,-1.270882 43.443613,-1.270625 43.443547,-1.270284 43.443522,-1.270038 43.443568,-1.269791 43.443571,-1.268868 43.443447,-1.268755 43.443217,-1.268362 43.443482,-1.267935 43.443691,-1.267848 43.443831,-1.267613 43.443717,-1.2673 43.443667,-1.267042 43.443421,-1.266795 43.443275,-1.267012 43.442742,-1.266873 43.442582,-1.266827 43.442456,-1.266949 43.442137,-1.266881 43.441818,-1.266761 43.441722,-1.266465 43.441617,-1.26631 43.441531,-1.266141 43.441047,-1.266109 43.440833,-1.261866 43.440759,-1.26174 43.440795,-1.261601 43.440723,-1.261295 43.440707,-1.260856 43.440227,-1.260575 43.43995,-1.260267 43.439721,-1.260013 43.439563,-1.259783 43.439467,-1.259351 43.439342,-1.258757 43.439098,-1.258463 43.438912,-1.257252 43.438856,-1.256999 43.438786,-1.256575 43.438732,-1.256114 43.438719,-1.255594 43.438884,-1.255209 43.43897,-1.25497 43.439061,-1.254714 43.439263,-1.254344 43.439631,-1.254076 43.439868,-1.253882 43.440005,-1.253706 43.440046,-1.253455 43.440161,-1.253294 43.440194,-1.252961 43.440203,-1.252508 43.440168,-1.251942 43.44017,-1.251524 43.44027,-1.2515 43.440342,-1.251324 43.440408,-1.250883 43.440065,-1.250786 43.440037,-1.250448 43.440119,-1.249954 43.440104,-1.249579 43.440119,-1.249157 43.439973,-1.249044 43.439868,-1.249033 43.439721,-1.249071 43.43943,-1.249054 43.439138,-1.248799 43.438971,-1.248541 43.438878,-1.248048 43.438825,-1.247884 43.438685,-1.247897 43.438386,-1.247846 43.438334,-1.247416 43.438035,-1.247409 43.437911,-1.247571 43.437726,-1.247713 43.437655,-1.247966 43.437614,-1.248373 43.437596,-1.248588 43.437523,-1.248872 43.437295,-1.249199 43.436985,-1.249363 43.436805,-1.249377 43.436613,-1.249261 43.436529,-1.248892 43.436544,-1.248704 43.436513,-1.248496 43.436389,-1.248437 43.436276,-1.248559 43.436185,-1.248895 43.436197,-1.249117 43.436131,-1.249218 43.436022,-1.249188 43.435869,-1.24909 43.435811,-1.24883 43.435768,-1.248805 43.435669,-1.248926 43.435489,-1.248927 43.435398,-1.249052 43.435177,-1.249303 43.434979,-1.249782 43.434856,-1.249952 43.434792,-1.250231 43.43493,-1.250562 43.434754,-1.250862 43.434741,-1.250922 43.434904,-1.251172 43.43518,-1.251379 43.435316,-1.251241 43.435529,-1.251587 43.435791,-1.251888 43.435917,-1.252107 43.436071,-1.25251 43.436261,-1.252987 43.436509,-1.253344 43.436607,-1.253866 43.43669,-1.254015 43.436745,-1.254184 43.436754,-1.254666 43.436717,-1.254904 43.436738,-1.255505 43.436501,-1.255844 43.436392,-1.256633 43.436218,-1.256847 43.436133,-1.257374 43.4361,-1.258169 43.435937,-1.258653 43.435646,-1.258797 43.435587,-1.258825 43.435511,-1.259403 43.435101,-1.260728 43.434201,-1.260768 43.433984,-1.261205 43.433547,-1.261571 43.433205,-1.262118 43.432914,-1.262589 43.432714,-1.263211 43.432287,-1.263535 43.432034,-1.263707 43.431872,-1.26429 43.431174,-1.264679 43.430809,-1.264866 43.430573,-1.265115 43.429847,-1.265213 43.429674,-1.265391 43.429484,-1.266068 43.429235,-1.266265 43.429107,-1.266569 43.428791,-1.267034 43.428457,-1.267431 43.428027,-1.267868 43.427787,-1.26844 43.427616,-1.269051 43.427483,-1.269259 43.427408,-1.269574 43.427183,-1.270063 43.427028,-1.270258 43.426994,-1.271026 43.426904,-1.271429 43.426745,-1.271775 43.4265,-1.272063 43.426178,-1.272439 43.425688,-1.272733 43.425248,-1.27281 43.424827,-1.272933 43.424615,-1.273433 43.424119,-1.273732 43.423721,-1.273823 43.423561,-1.273939 43.423252,-1.274516 43.422748,-1.274716 43.422514,-1.274847 43.422262,-1.274998 43.421729,-1.275023 43.421533,-1.274969 43.421271,-1.274794 43.421037,-1.274712 43.420875,-1.274691 43.420628,-1.274714 43.419968,-1.274746 43.419466,-1.274831 43.419179,-1.274927 43.419051,-1.275233 43.418352,-1.275469 43.418042,-1.275576 43.417745,-1.27561 43.417562,-1.275593 43.4174,-1.275458 43.417046,-1.275269 43.416333,-1.275042 43.415817,-1.275045 43.415582,-1.275406 43.415008,-1.275688 43.414436,-1.275785 43.414306,-1.276162 43.413969,-1.276622 43.413705,-1.277205 43.413182,-1.277391 43.412909,-1.277551 43.412415,-1.277581 43.412094,-1.277512 43.411245,-1.277511 43.410929,-1.277583 43.410615,-1.277669 43.410441,-1.278474 43.409126,-1.27894 43.40839,-1.279124 43.408198,-1.279758 43.407807,-1.280146 43.407594,-1.28084 43.407329,-1.281069 43.407192,-1.281758 43.406546,-1.28209 43.406192,-1.282374 43.405853,-1.282576 43.405575,-1.282825 43.405281,-1.283097 43.405026,-1.283255 43.404817,-1.283542 43.404504,-1.283607 43.40432,-1.2836 43.403991,-1.283727 43.403654,-1.283902 43.403399,-1.284054 43.403124,-1.284301 43.402738,-1.284557 43.402512,-1.284715 43.402339,-1.284911 43.40205,-1.285557 43.401204,-1.285893 43.400834,-1.286536 43.400251,-1.286856 43.4,-1.286929 43.399917,-1.287318 43.399365,-1.288069 43.397321,-1.28822 43.396019,-1.288738 43.39523,-1.288382 43.395153,-1.288068 43.395024,-1.287956 43.39488,-1.28795 43.394707,-1.288027 43.394573,-1.288069 43.39439,-1.287963 43.39423,-1.287504 43.393953,-1.287169 43.393906,-1.286806 43.393784,-1.286043 43.393669,-1.28559 43.39372,-1.285495 43.393694,-1.28504 43.393467,-1.284167 43.393561,-1.283679 43.393602,-1.283313 43.393615,-1.2829 43.393584,-1.282417 43.393579,-1.281937 43.393626,-1.281603 43.393683,-1.281115 43.393704,-1.280721 43.393788,-1.280462 43.393872,-1.279886 43.393952,-1.279253 43.394081,-1.278582 43.394195,-1.277915 43.394286,-1.277398 43.394304,-1.276804 43.394077,-1.276263 43.39391,-1.275697 43.393717,-1.275443 43.393502,-1.274847 43.393426,-1.274196 43.392947,-1.273988 43.392432,-1.27437 43.391372,-1.2744 43.391232,-1.274339 43.391065,-1.274034 43.390639,-1.273799 43.390214,-1.273991 43.390128,-1.274137 43.39002,-1.274189 43.389833,-1.274109 43.389729,-1.273845 43.389585,-1.273699 43.38945,-1.273696 43.389245,-1.273782 43.388994,-1.27374 43.388828,-1.273562 43.388617,-1.273326 43.388402,-1.272953 43.388172,-1.272652 43.388014,-1.272443 43.387842,-1.272421 43.387769,-1.272515 43.387551,-1.272853 43.387212,-1.273036 43.386832,-1.273437 43.386541,-1.273956 43.38624,-1.274087 43.386145,-1.274092 43.385978,-1.274011 43.385833,-1.273776 43.385709,-1.273284 43.385633,-1.272788 43.385634,-1.272626 43.385583,-1.272459 43.385343,-1.272346 43.384891,-1.27228 43.384777,-1.272032 43.38451,-1.271945 43.38431,-1.271838 43.38417,-1.271384 43.383785,-1.271024 43.383567,-1.270766 43.383386,-1.270661 43.383227,-1.270667 43.382985,-1.270777 43.382774,-1.271006 43.38277,-1.271295 43.38293,-1.271472 43.38309,-1.271679 43.383167,-1.271855 43.383103,-1.272238 43.382898,-1.272491 43.382798,-1.27279 43.382714,-1.27314 43.382522,-1.273329 43.382297,-1.27349 43.382033,-1.273734 43.381688,-1.273779 43.381551,-1.273731 43.381112,-1.273684 43.380881,-1.273665 43.380508,-1.273584 43.380107,-1.273653 43.379766,-1.274076 43.379161,-1.274316 43.378884,-1.274608 43.378412,-1.274673 43.378268,-1.274698 43.378063,-1.274631 43.377843,-1.274429 43.377613,-1.273764 43.377272,-1.273523 43.377214,-1.273209 43.377278,-1.272739 43.37758,-1.272132 43.378086,-1.271935 43.378209,-1.271618 43.378519,-1.271526 43.378821,-1.271394 43.379003,-1.271115 43.379101,-1.271012 43.379195,-1.270781 43.379316,-1.270546 43.379281,-1.270312 43.378962,-1.270192 43.378831,-1.269807 43.378581,-1.269469 43.378392,-1.269288 43.378261,-1.269201 43.378144,-1.269149 43.377949,-1.269184 43.37746,-1.269097 43.377264,-1.268906 43.377119,-1.268156 43.376884,-1.267771 43.376793,-1.267567 43.376678,-1.267332 43.376334,-1.266788 43.375905,-1.266597 43.375623,-1.266363 43.375374,-1.266129 43.375213,-1.265662 43.374992,-1.265281 43.374734,-1.264995 43.374632,-1.264639 43.37461,-1.264466 43.374507,-1.264462 43.374317,-1.264597 43.374053,-1.265118 43.373284,-1.265464 43.37292,-1.266686 43.372853,-1.266849 43.373477,-1.267157 43.373467,-1.267664 43.373674,-1.268284 43.373744,-1.268505 43.373331,-1.269064 43.373402,-1.26947 43.372984,-1.26972 43.372841,-1.270038 43.37202,-1.270988 43.370459,-1.271981 43.36963,-1.272308 43.369704,-1.27282 43.369766,-1.273224 43.369221,-1.273889 43.369487,-1.274087 43.369849,-1.274165 43.370055,-1.274296 43.370145,-1.274561 43.370124,-1.274689 43.370042,-1.274859 43.369866,-1.27517 43.369653,-1.275553 43.369511,-1.27577 43.369346,-1.27586 43.369224,-1.276023 43.368882,-1.275947 43.368741,-1.27567 43.368463,-1.275675 43.368297,-1.275746 43.368095,-1.275963 43.36786,-1.276351 43.367595,-1.276512 43.367421,-1.277115 43.367383,-1.277546 43.367404,-1.278071 43.367521,-1.27851 43.367493,-1.279046 43.367519,-1.279393 43.367581,-1.279986 43.367755,-1.280549 43.367878,-1.281167 43.368055,-1.282054 43.368262,-1.282434 43.368298,-1.282774 43.368223,-1.283242 43.368185,-1.28378 43.368202,-1.283891 43.368185,-1.284399 43.36803,-1.284968 43.367893,-1.285409 43.367745,-1.28621 43.367552,-1.286815 43.36738,-1.287097 43.367323,-1.287394 43.367166,-1.287557 43.366966,-1.287792 43.366729,-1.287941 43.366672,-1.288128 43.366687,-1.288267 43.366796,-1.288485 43.366863,-1.28862 43.366967,-1.288735 43.367195,-1.288886 43.36727,-1.289177 43.367262,-1.289452 43.367187,-1.290016 43.367068,-1.290443 43.366924,-1.29121 43.366626,-1.291484 43.366465,-1.291638 43.366342,-1.291749 43.366126,-1.291842 43.365785,-1.291857 43.365174,-1.291985 43.364621,-1.29227 43.363769,-1.292342 43.363668,-1.292531 43.363533,-1.292602 43.363356,-1.292617 43.363122,-1.292581 43.36296,-1.292482 43.362769,-1.292287 43.362547,-1.292106 43.36246,-1.291736 43.362346,-1.291591 43.362258,-1.291418 43.361957,-1.291397 43.36171,-1.291444 43.361518,-1.291513 43.361424,-1.291657 43.36135,-1.292029 43.361374,-1.292227 43.361197,-1.292526 43.361075,-1.292936 43.360938,-1.293315 43.360686,-1.293554 43.360619,-1.293729 43.360638,-1.293795 43.360747,-1.29402 43.360705,-1.294112 43.3605,-1.294123 43.360246,-1.294242 43.36005,-1.294184 43.359922,-1.294184 43.359727,-1.294226 43.359575,-1.294337 43.359393,-1.29458 43.359088,-1.294664 43.358903,-1.294756 43.358804,-1.295169 43.358567,-1.295182 43.358419,-1.294965 43.358192,-1.294728 43.358,-1.294323 43.357753,-1.295442 43.357061,-1.297686 43.35649,-1.297971 43.356121,-1.298502 43.355743,-1.299588 43.355167,-1.300485 43.354793,-1.300586 43.354895,-1.300814 43.35494,-1.301806 43.354668,-1.302169 43.354594,-1.302934 43.354515,-1.304877 43.353827,-1.30615 43.353121,-1.310281 43.352349,-1.31077 43.352023,-1.310743 43.351997,-1.311392 43.351848,-1.311399 43.351675,-1.311486 43.351511,-1.311622 43.351421,-1.311609 43.351117,-1.31206 43.351092,-1.314205 43.351281,-1.314384 43.351148,-1.317813 43.351382,-1.319325 43.351606,-1.32219 43.351228,-1.322624 43.351246,-1.323845 43.350904,-1.325984 43.34864,-1.327655 43.346829,-1.328209 43.346811,-1.329743 43.346533,-1.330664 43.346456,-1.331359 43.346478,-1.331518 43.346658,-1.331794 43.346839,-1.33221 43.347014,-1.332763 43.347161,-1.332884 43.347226,-1.333115 43.347547,-1.336997 43.346265,-1.339478 43.346152,-1.344442 43.346123,-1.347171 43.346058,-1.351574 43.343893)))"
]
|
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 | 4158 |
| 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. |