Query Metrics
61
Database Queries
12
Different statements
622.71 ms
Query time
0
Invalid entities
108
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.35 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:
[
"26353"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.32 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:
[
7046
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.30 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:
[
7046
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.46 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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 3480904420 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.31 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:
[
7046
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 4805435922 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 7731426885 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 8 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 11370179271 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 11370179272 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 10 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 11370179273 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.23 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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12549987570 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12552188518 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 13 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12552284865 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 14 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12552436968 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 15 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12674241212 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 16 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12674269598 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 17 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12674269599 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 18 | 0.22 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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 12674269600 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 19 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 13027100200 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 20 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 13027104103 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 21 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 13027104105 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 22 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 13094516137 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 23 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 13094553432 "node" 7046 ]
|
||||||||||||||||||||||||||||||||
| 24 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 139294394 "way" 7046 ]
|
||||||||||||||||||||||||||||||||
| 25 | 0.23 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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 139295140 "way" 7046 ]
|
||||||||||||||||||||||||||||||||
| 26 | 0.22 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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 893567833 "way" 7046 ]
|
||||||||||||||||||||||||||||||||
| 27 | 0.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.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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 1226077646 "way" 7046 ]
|
||||||||||||||||||||||||||||||||
| 28 | 0.26 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.osm_id = ? AND t0.osm_kind = ? AND t0.stats_id = ? LIMIT 1
Parameters:
[ 1226082667 "way" 7046 ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.13 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "f1f8fe87-d29f-4ff3-85da-1938b0a8e560" "node" null 0 0 "" "2026-02-02 10:04:10" 26353 0 null "3480904420" "B&B Hôtel" 0 1 1 0 0 "tourism=hotel" null null 44.6672175 4.7951542 "Rue de Bérianne" "650" null null "2025-12-23 13:04:59" 11 "Decoy-BZH" 9460539 176307423 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.26 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "50ce4f3c-8656-4a88-b94b-8e1262ff40b1" "node" null 0 0 "" "2026-02-02 10:04:10" 26353 0 null "4805435922" "TotalEnergies" 1 0 0 0 0 "shop=convenience;gas" null null 44.6651119 4.7913889 null null null null "2025-08-01 21:45:43" 5 "johanbont" 12992964 169839023 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.25 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "85da6c98-228b-4e91-91da-c966ed224938" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "7731426885" "Gan Patrimoine : Denis Dignac" 1 1 1 0 0 "office=insurance" null null 44.6665286 4.7949812 "Rue de Bérianne" "565" "48010607900050" null "2025-10-14 13:40:03" 11 "votre_solution_de_visibilite_digitale_locale" 2179792 173276156 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.25 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1ea8abfb-62a1-47e8-8516-c5039f3f44d1" "node" "mariaguiboud@gmail.com" 0 0 "" "2026-02-02 10:04:10" 26353 0 null "11370179271" "La Tourrettoise" 1 1 1 0 0 "amenity=bar" null null 44.6631796 4.7908761 "Avenue Saint-Didier" "46" null null "2025-08-24 14:14:11" 3 "johanbont" 12992964 170927384 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 34 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "32a10139-20d6-45da-ab73-d312e8873914" "node" "mariaguiboud@gmail.com" 0 0 "" "2026-02-02 10:04:10" 26740 0 null "11370179272" "La Tourrettoise Épicerie - Bar - Tabac" 1 1 1 0 0 "shop=convenience" null null 44.6630624 4.7908184 "Avenue Saint-Didier" "46" null null "2025-08-24 14:14:11" 4 "johanbont" 12992964 170927384 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 35 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "7bbce986-acc3-460c-b2c0-1960bc1ddb5c" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "11370179273" "Pizza Fred l'Original" 0 1 0 0 0 "amenity=restaurant" null null 44.6627945 4.7907056 "Avenue Saint-Didier" "92" "93442146200011" null "2025-08-24 14:03:20" 3 "johanbont" 12992964 170926848 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.26 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "42869e12-418c-4e2c-b34d-c628c4e3f705" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12549987570" "Ma Campagne" 0 1 1 0 0 "amenity=restaurant" null null 44.6553526 4.7867912 "Route Nationale 7" "2255" "82468784200016" null "2025-07-26 17:29:56" 2 "johanbont" 12992964 169519642 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.24 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "769affdb-580a-4c9c-b82d-5d89f17e5370" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12552188518" "Demo'Cat 26 Subaru" 0 1 0 0 0 "shop=car" null null 44.6577833 4.7872742 "Route Nationale 7" "1980" "42025777600013" null "2025-07-26 17:29:56" 2 "johanbont" 12992964 169519642 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.25 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "e280353a-912e-4f0b-8fcb-81ca43e003b9" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12552284865" "Mon Controle Technique - les Tourrettes" 1 1 0 0 0 "amenity=vehicle_inspection" null null 44.6641015 4.7905579 "Chemin de Belfond" "15" null null "2025-03-17 20:48:52" 2 "johanbont" 12992964 163750048 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 39 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "de875e72-3870-4086-8d00-51c2052c0bab" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12552436968" "Artes Immobilier" 1 1 1 0 0 "office=estate_agent" null null 44.661931 4.7912013 "Avenue du Blomard" "1" "84162292100010" null "2025-07-26 17:47:27" 2 "johanbont" 12992964 169520384 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 40 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "6c8d5f2b-9a64-42c8-8179-fd2bee308bde" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12674241212" "Soc Coop Agricole Vallee Rhone Valgrain" 0 1 1 0 0 "office=company" null null 44.6719305 4.7923895 "Route de l'Écluse" "990" "32420409800036" null "2025-07-26 19:37:19" 3 "johanbont" 12992964 169524767 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 41 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "fb855608-5615-40a5-8937-38988c9b162e" "node" null 0 0 "" "2026-02-02 10:04:10" 26353 0 null "12674269598" "Tattoo ce que je veux" 0 0 0 0 0 "shop=tattoo" null null 44.6627395 4.7898943 null null null null "2025-03-17 21:19:27" 1 "johanbont" 12992964 163750902 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 42 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "969bd1ba-5336-428a-99ba-4041c54fcf28" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12674269599" "N4D Montélimar - Dératisation" 1 1 1 0 0 "office=yes" null null 44.6631091 4.7894377 "Rue Marc Seguin" "1" null null "2025-03-17 21:19:27" 1 "johanbont" 12992964 163750902 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 43 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "00fc9f1f-0c73-49bf-9889-3397fafb476c" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "12674269600" "Action Ménager" 1 1 0 0 0 "shop=repair" null null 44.6629597 4.7893201 "Rue Marc Seguin" "2" "51478480000021" null "2025-07-26 17:47:27" 3 "johanbont" 12992964 169520384 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 44 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "6f462baa-e977-480c-806d-78a65c4b7627" "node" "sibd@laposte.net" 0 0 "" "2026-02-02 10:04:10" 26353 0 null "13027100200" "Sol Industriel et Décoratif Béton" 0 0 1 0 0 "office=company" null null 44.6631479 4.8026331 null null "83760351300016" null "2025-07-26 19:17:53" 1 "johanbont" 12992964 169524089 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 45 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "40aca707-788c-4b85-88c4-62070a67e790" "node" null 0 0 "" "2026-02-02 10:04:10" 26353 0 null "13027104103" "My Angels" 1 0 0 0 0 "shop=hairdresser" null null 44.6628369 4.790723 null null "48830918800024" null "2025-07-26 19:14:16" 1 "johanbont" 12992964 169523882 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 46 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "71633fc6-a0e3-41f3-9f7c-6875749afb3a" "node" "contact@archelec.fr" 0 0 "" "2026-02-02 10:04:10" 26353 0 null "13027104105" "Arch'Elec" 0 0 1 0 0 "office=company" null null 44.6630363 4.8048012 null null "91884928200010" null "2025-07-26 19:14:16" 1 "johanbont" 12992964 169523882 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 47 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "ca4961e0-788c-47cf-9d5b-84011054738b" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "13094516137" "Le Mas de Berianne Restaurant" 0 1 1 0 0 "amenity=restaurant" null null 44.6666999 4.7962038 "Rue de Bérianne" "435" "48472765600023" null "2025-08-29 15:07:18" 2 "b-jazz-bot" 9451067 171189720 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 48 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "0a2e23a7-195e-4a2f-abaf-1e49f7ad817e" "node" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "13094553432" "Hôtel Première Classe Montelimar Les Tourrettes" 0 1 1 0 0 "tourism=hotel" null null 44.6669706 4.7941338 "Rue de Bérianne" "675" null null "2025-08-24 14:11:55" 1 "johanbont" 12992964 170927231 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.29 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "24ca087d-28c8-415d-9dd4-ecb0d93e4609" "way" null 0 0 "" "2026-02-02 10:04:10" 26353 0 null "139294394" "Les Lavandes" 0 0 0 0 0 "amenity=restaurant" null null 0.0 0.0 null null "85303871900011" null "2025-08-24 14:03:20" 6 "johanbont" 12992964 170926848 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.25 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "d63424c8-3a64-4fbd-8b7d-8099c0e58a26" "way" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "139295140" "Hôtel Restaurant Campanile Montélimar - Les Tourrettes" 0 1 1 0 0 "tourism=hotel" null null 0.0 0.0 "Rue de Bérianne" "695" "79939257600036" null "2025-10-20 07:02:33" 7 "bagage" 2797881 173520308 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.29 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "b3034423-f6b5-4604-a1db-c49860413b60" "way" "mairie@lestourrettes.fr" 0 0 "" "2026-02-02 10:04:10" 26740 0 null "893567833" "Mairie des Tourrettes" 1 0 1 1 0 "amenity=townhall" null null 0.0 0.0 null "1" "21260353400018" null "2025-08-23 12:48:16" 3 "johanbont" 12992964 170879132 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 52 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "f1281348-b209-4311-a3bb-7895563a3c51" "way" null 0 0 "" "2026-02-02 10:04:10" 26740 0 null "1226077646" "Pôle santé" 0 1 0 0 0 "healthcare=doctor" null null 0.0 0.0 "Avenue Saint-Didier" "116" null null "2025-02-02 21:56:54" 3 "johanbont" 12992964 162064506 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 53 | 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, habitants, osm_data_date, osm_version, osm_user, osm_uid, osm_changeset, email_content, place_count, stats_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "0c42fcef-bd74-43b8-947b-62d7e1340c80" "way" null 0 0 "" "2026-02-02 10:04:10" 26353 0 null "1226082667" null 0 0 0 0 0 "shop=convenience" null null 0.0 0.0 null null null null "2025-07-26 17:47:27" 2 "johanbont" 12992964 169520384 null 0 7046 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.24 ms |
UPDATE stats SET places_count = ? WHERE id = ?
Parameters:
[ 24 7046 ]
|
||||||||||||||||||||||||||||||||
| 55 | 303.18 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 56 | 0.16 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 57 | 0.27 ms |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "stats_de_ville" "{"insee_code":"26353","nom":"26353"}" "2026-02-02 10:04:11" "https://osm-labo.cipherbliss.com/admin/labourer/26353?deleteMissing=1" null ]
|
||||||||||||||||||||||||||||||||
| 58 | 302.88 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 59 | 0.40 ms |
SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = ? ORDER BY s0_.id DESC LIMIT 100
Parameters:
[
7046
]
|
||||||||||||||||||||||||||||||||
| 60 | 0.59 ms |
SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = ? GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100
Parameters:
[
7046
]
|
||||||||||||||||||||||||||||||||
| 61 | 1.36 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:
[
7046
]
|
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 | 55 |
| App\Entity\ZonePlaces | 27 |
| App\Entity\Place | 24 |
| 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\History | No errors. |
| App\Entity\ActionLog | No errors. |