Query Metrics
52
Database Queries
8
Different statements
588.28 ms
Query time
0
Invalid entities
22
Managed entities
Queries
| #▲ | 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 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
"13101"
]
|
||||||||||||||||||||||||||
| 2 | 0.18 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 3 | 0.29 ms |
INSERT INTO stats (zone, completion_percent, places_count, avec_horaires, avec_adresse, avec_site, avec_accessibilite, avec_note, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "13101" 0 0 0 0 0 0 0 null ]
|
||||||||||||||||||||||||||
| 4 | 0.95 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||
| 5 | 43.16 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
655381320
]
|
||||||||||||||||||||||||||
| 6 | 26.08 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
655381321
]
|
||||||||||||||||||||||||||
| 7 | 26.24 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
6841368073
]
|
||||||||||||||||||||||||||
| 8 | 26.25 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
8852512683
]
|
||||||||||||||||||||||||||
| 9 | 26.98 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12716805735
]
|
||||||||||||||||||||||||||
| 10 | 26.08 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069669
]
|
||||||||||||||||||||||||||
| 11 | 25.95 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069678
]
|
||||||||||||||||||||||||||
| 12 | 27.00 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069679
]
|
||||||||||||||||||||||||||
| 13 | 26.07 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069683
]
|
||||||||||||||||||||||||||
| 14 | 26.01 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069684
]
|
||||||||||||||||||||||||||
| 15 | 27.08 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069685
]
|
||||||||||||||||||||||||||
| 16 | 26.21 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069686
]
|
||||||||||||||||||||||||||
| 17 | 26.04 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069687
]
|
||||||||||||||||||||||||||
| 18 | 26.58 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069688
]
|
||||||||||||||||||||||||||
| 19 | 26.29 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069689
]
|
||||||||||||||||||||||||||
| 20 | 31.67 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
12717069690
]
|
||||||||||||||||||||||||||
| 21 | 26.06 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
158283553
]
|
||||||||||||||||||||||||||
| 22 | 26.07 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
158283641
]
|
||||||||||||||||||||||||||
| 23 | 26.08 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
158287752
]
|
||||||||||||||||||||||||||
| 24 | 31.15 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
158287766
]
|
||||||||||||||||||||||||||
| 25 | 26.20 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.osm_id = ? LIMIT 1
Parameters:
[
158287938
]
|
||||||||||||||||||||||||||
| 26 | 0.19 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 27 | 0.43 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "9b6370e9-8199-4058-8f36-2cb386ea865a" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "655381320" "Clé en main - Immo" 1 0 1 0 0 "office=estate_agent" null null 43 5 "Grand'Route" "" "" 659 ]
|
||||||||||||||||||||||||||
| 28 | 0.33 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1d946cff-1027-4156-aa8c-d3375d34880d" "node" "PDV05317@MOUSQUETAIRES.COM" 0 0 "" "2025-06-09 08:54:47" 0 0 null "655381321" "Netto" 1 0 1 0 0 "shop=supermarket" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 29 | 0.28 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "26423f0b-aaef-474b-b486-b99a996191d7" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "6841368073" "Mairie de Saint-Savournin" 1 0 0 1 0 "amenity=townhall" null null 43 5 "Grand Rue" "" "21130101500015" 659 ]
|
||||||||||||||||||||||||||
| 30 | 0.28 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "47046c96-0d1b-4680-97d6-9aa239b04145" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "8852512683" "Relais Poste" 1 0 0 1 0 "amenity=post_office" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 31 | 0.35 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "41edccb3-373a-43b3-a16d-0a8359dc1428" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12716805735" "Coiffeur" 0 0 0 0 0 "shop=hairdresser" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 32 | 0.30 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "c625ca5d-01fb-4d34-b250-9defe132d4bc" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069669" "Azad" 0 0 0 0 0 "amenity=restaurant" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 33 | 0.28 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1afdc585-bfa3-41df-a50c-1b0709cc31e4" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069678" "Bar Tabac du Château" 0 0 0 0 0 "shop=newsagent" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 34 | 0.23 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "dde804a6-3469-49fd-8988-d95f2fc23c1a" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069679" "Pizza Fonta" 0 0 0 0 0 "amenity=fast_food" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 35 | 0.22 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "816b8316-c9f8-4d7a-a263-ee9936a5844b" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069683" "Clic Valley Informatique" 0 0 0 0 0 "shop=computer" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 36 | 0.27 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "116ebafa-8b09-4efb-ba8a-ae7f55772bd3" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069684" "Saint Sa Optique" 1 0 0 0 0 "shop=optician" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 37 | 0.23 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "f8f74e15-3d73-445a-bc7d-282c5ee3979b" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069685" "Banque Populaire" 0 0 0 0 0 "amenity=bank" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 38 | 0.22 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "7da1bee6-5287-4613-8dfb-40af8ddbc1cc" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069686" "Le Marché de Saint Savournin" 0 0 0 0 0 "shop=greengrocer" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 39 | 0.21 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "fc8fcd80-b402-4298-93f7-2b4c7accc2fa" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069687" "Le Fournil de Pomponette" 0 0 0 0 0 "shop=bakery" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 40 | 0.21 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "46e03744-990d-4693-a79b-6456f4b48518" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069688" "Boucherie Saint-Savournin" 1 0 0 0 0 "shop=butcher" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 41 | 0.21 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "e9c1c691-f3ef-431e-8c87-92a2dcf940c0" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069689" "Street Hair" 1 0 0 0 0 "shop=hairdresser" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 42 | 0.21 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "714a7bf9-1822-42aa-bf15-54efa35a362e" "node" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "12717069690" "Pharmacie du Grand Jardin" 1 0 0 0 0 "healthcare=pharmacy" null null 43 5 "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 43 | 0.20 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "f2fdbadb-0b77-496f-a263-d7540b524297" "way" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "158283553" "Salle Marie-Ange Luciani" 0 0 0 0 0 "amenity=community_centre" null null null null "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 44 | 0.20 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "3c61f904-6040-4057-b792-f53e5d027b07" "way" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "158283641" "" 0 0 0 0 0 "shop=mall" null null null null "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 45 | 0.20 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "126263f8-9b2b-4a23-b8cc-fd69412954b1" "way" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "158287752" "Bibliothèque Municipale" 0 0 0 0 0 "amenity=library" null null null null "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 46 | 0.20 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "19d4d416-acbd-4c8d-b386-22d3f319c894" "way" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "158287766" "" 0 1 0 1 0 "amenity=post_office" null null null null "Place Couton Marceau" "1" "" 659 ]
|
||||||||||||||||||||||||||
| 47 | 0.22 ms |
INSERT INTO place (uuid_for_url, osm_kind, email, opted_out, dead, note, modified_date, zip_code, asked_humains_support, last_contact_attempt_date, osm_id, name, has_opening_hours, has_address, has_website, has_wheelchair, has_note, main_tag, note_content, displayed_date, lat, lon, street, housenumber, siret, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "a6e26915-4ad4-45eb-8248-0270820eac56" "way" "" 0 0 "" "2025-06-09 08:54:47" 0 0 null "158287938" "Salle de l'Ancien Lavoir" 0 0 0 0 0 "amenity=community_centre" null null null null "" "" "" 659 ]
|
||||||||||||||||||||||||||
| 48 | 0.21 ms |
UPDATE stats SET name = ? WHERE id = ?
Parameters:
[ "Saint-Savournin" 659 ]
|
||||||||||||||||||||||||||
| 49 | 0.65 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||
| 50 | 0.15 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 51 | 0.23 ms |
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters:
[ 13 21 8 1 2 3 659 ]
|
||||||||||||||||||||||||||
| 52 | 0.50 ms |
"COMMIT"
Parameters:
[]
|
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\Place | 21 |
| App\Entity\Stats | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Stats | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\History | No errors. |