Symfony Profiler

Query Metrics

125 Database Queries
10 Different statements
48.66 ms Query time
0 Invalid entities
0 Managed entities
Queries


"START TRANSACTION"
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
"COMMIT"
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
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
"START TRANSACTION"
INSERT INTO stats (zone, completion_percent, places_count, avec_horaires, avec_adresse, avec_site, avec_accessibilite, avec_note, name, population, siren, code_epci, codes_postaux, date_created, date_modified, avec_siret, avec_name, osm_data_date_min, osm_data_date_avg, osm_data_date_max, budget_annuel, lat, lon, date_labourage_requested, date_labourage_done, kind) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
UPDATE stats SET completion_percent = ?, name = ?, population = ?, budget_annuel = ?, lat = ?, lon = ?, date_labourage_requested = ? WHERE id = ?
"COMMIT"
"START TRANSACTION"
UPDATE stats SET date_labourage_done = ? WHERE id = ?
"COMMIT"
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
"START TRANSACTION"
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
"COMMIT"
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
Entities Mapping

Class	Mapping errors
App\Entity\ActionLog	No 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.
Symfony Profiler

GET https://osm-labo.cipherbliss.com/admin/labourer/01169?deleteMissing=1&disableFollowUpCleanup=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
