Redirect 302 redirect from GET @app_public_edit (642519)

GET https://osm-commerces.cipherbliss.com/city/34126/zone-places-history

Query Metrics

52 Database Queries
7 Different statements
49.76 ms Query time
0 Invalid entities
307 Managed entities

Queries

Group similar statements

# Time Info
1 0.33 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.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
  "34126"
]
2 16.27 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 = ?
Parameters:
[
  8200
  "fire_hydrant"
]
3 0.45 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 = ?
Parameters:
[
  8200
  "charging_station"
]
4 0.34 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 = ?
Parameters:
[
  8200
  "toilets"
]
5 0.26 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 = ?
Parameters:
[
  8200
  "bus_stop"
]
6 0.28 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 = ?
Parameters:
[
  8200
  "defibrillator"
]
7 0.27 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 = ?
Parameters:
[
  8200
  "camera"
]
8 0.28 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 = ?
Parameters:
[
  8200
  "recycling"
]
9 0.34 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 = ?
Parameters:
[
  8200
  "substation"
]
10 0.33 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 = ?
Parameters:
[
  8200
  "laboratory"
]
11 0.33 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 = ?
Parameters:
[
  8200
  "school"
]
12 0.32 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 = ?
Parameters:
[
  8200
  "police"
]
13 0.35 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 = ?
Parameters:
[
  8200
  "healthcare"
]
14 0.32 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 = ?
Parameters:
[
  8200
  "bicycle_parking"
]
15 0.30 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 = ?
Parameters:
[
  8200
  "advertising_board"
]
16 4.85 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 = ?
Parameters:
[
  8200
  "building"
]
17 0.51 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 = ?
Parameters:
[
  8200
  "rnb"
]
18 0.33 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 = ?
Parameters:
[
  8200
  "email"
]
19 0.36 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 = ?
Parameters:
[
  8200
  "bench"
]
20 0.27 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 = ?
Parameters:
[
  8200
  "waste_basket"
]
21 0.30 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 = ?
Parameters:
[
  8200
  "street_lamp"
]
22 0.30 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 = ?
Parameters:
[
  8200
  "drinking_water"
]
23 0.56 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 = ?
Parameters:
[
  8200
  "tree"
]
24 0.28 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 = ?
Parameters:
[
  8200
  "power_pole"
]
25 0.28 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 = ?
Parameters:
[
  8200
  "manhole"
]
26 0.26 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 = ?
Parameters:
[
  8200
  "little_free_library"
]
27 0.25 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 = ?
Parameters:
[
  8200
  "playground"
]
28 0.35 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 = ?
Parameters:
[
  8200
  "restaurant"
]
29 0.15 ms
"START TRANSACTION"
Parameters:
[]
30 0.30 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191360
]
31 0.17 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191361
]
32 0.19 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  190483
]
33 0.21 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  189727
]
34 0.25 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191362
]
35 0.15 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  189210
]
36 0.14 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191364
]
37 0.13 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191365
]
38 0.12 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191366
]
39 0.17 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191368
]
40 0.12 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191369
]
41 2.21 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191371
]
42 0.19 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191373
]
43 0.55 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  189045
]
44 0.21 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191374
]
45 0.17 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191376
]
46 0.31 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191377
]
47 0.17 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  190156
]
48 0.20 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191380
]
49 0.17 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[]"
  191381
]
50 8.98 ms
"COMMIT"
Parameters:
[]
51 2.80 ms
SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = ?
Parameters:
[
  8200
]
52 2.02 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:
[
  8200
]

Database Connections

Name Service
default doctrine.dbal.default_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 279
App\Entity\ZonePlaces 27
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.