| 3 |
138.75 ms |
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.zip_code = ?
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.zip_code = '49328';
|
| 5 |
0.62 ms |
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: [
"[DEBUG][followupThemeGraph]"
"{"theme":"substation","tagKey":null,"tagValue":null,"main_tags":["healthcare=pharmacy","healthcare=pharmacy","amenity=restaurant","shop=bakery","office=yes","amenity=restaurant","amenity=bar","shop=bakery","shop=furniture","shop=clothes","office=association","shop=clothes","shop=bakery","shop=bakery","shop=tobacco","amenity=bar","shop=e-cigarette","amenity=restaurant","amenity=car_wash","shop=florist","shop=hairdresser","shop=bakery","shop=alcohol","amenity=veterinary","amenity=bank","healthcare=yes","tourism=guest_house","tourism=guest_house","tourism=hotel","amenity=restaurant","amenity=townhall","office=company","shop=cosmetics","amenity=bar","shop=alcohol","tourism=guest_house","amenity=townhall","amenity=townhall","amenity=restaurant","shop=convenience","amenity=car_wash","healthcare=hospital","shop=car","shop=deli","amenity=workshop","shop=convenience","amenity=bank","amenity=bank","healthcare=pharmacy","shop=electronics","shop=doityourself","amenity=restaurant","shop=laundry","shop=convenience","amenity=restaurant","amenity=doctors","tourism=hotel","office=association","shop=general","amenity=restaurant","tourism=guest_house","amenity=bar","amenity=restaurant","tourism=guest_house","healthcare=centre","amenity=restaurant","shop=bakery","shop=clothes","amenity=restaurant","shop=pastry","shop=car","shop=car","healthcare=yes","shop=travel_agency","shop=car","amenity=pub","healthcare=pharmacy","amenity=restaurant","amenity=townhall","office=moving_company","office=association","healthcare=laboratory","office=lawyer","office=accountant","amenity=kindergarten","shop=alcohol","amenity=veterinary","amenity=bar","shop=newsagent","amenity=driving_school","tourism=museum","amenity=restaurant","shop=optician","amenity=cafe","office=company","shop=hairdresser","office=ngo","amenity=fast_food","shop=hairdresser","amenity=restaurant","shop=interior_decoration","shop=hairdresser","amenity=car_wash","amenity=car_wash","office=estate_agent","shop=pastry","amenity=bar","shop=cosmetics","shop=pastry","healthcare=pharmacy","amenity=restaurant","office=employment_agency","shop=beauty","shop=butcher","shop=optician","shop=hairdresser","shop=cosmetics","shop=dry_cleaning","shop=mobile_phone","shop=jewelry","shop=cosmetics","shop=optician","healthcare=pharmacy","office=personal_service","shop=shoes","shop=mobile_phone","shop=video_games","shop=clothes","shop=video","shop=clothes","shop=clothes","shop=clothes","shop=florist","shop=furniture","shop=clothes","shop=cosmetics","shop=clothes","shop=electronics","shop=jewelry","shop=frozen_food","office=travel_agent","shop=bag","shop=shoes","shop=clothes","amenity=bar","amenity=restaurant","shop=clothes","shop=mobile_phone","shop=clothes","shop=clothes","amenity=cafe","office=association","shop=wine","tourism=information","shop=fireplace","shop=bakery","office=insurance","amenity=car_rental","shop=car_repair","amenity=fast_food","shop=bakery","shop=kitchen","shop=chocolate","shop=pet","office=association","amenity=pub","shop=mosaic","amenity=restaurant","office=accountant","office=employment_agency","shop=car_repair","healthcare=hospital","shop=convenience;gas","shop=garden_centre","shop=supermarket","shop=doityourself","tourism=hotel","shop=variety_store","amenity=restaurant","shop=sports","shop=interior_decoration","shop=shoes","tourism=hotel","shop=car_repair","amenity=townhall","amenity=bank","healthcare=centre","shop=butcher","shop=cheese","amenity=fast_food","amenity=veterinary","amenity=car_wash","amenity=car_wash","amenity=bar","amenity=restaurant","amenity=car_wash","office=research","shop=florist","amenity=restaurant","shop=mall","shop=books","shop=craft","amenity=restaurant","shop=supermarket","amenity=theatre","shop=books","shop=wine","amenity=restaurant","shop=supermarket","amenity=restaurant","shop=gas","shop=car_repair","amenity=restaurant","amenity=vehicle_inspection","tourism=hotel","shop=supermarket","shop=laundry","shop=outpost","shop=laundry","shop=books","shop=car_repair","shop=clothes","tourism=museum","shop=bakery","shop=pet","healthcare=pharmacy","shop=garden_centre","amenity=theatre","tourism=chalet","shop=books","amenity=restaurant","shop=supermarket","shop=bakery","shop=gift","tourism=museum"],"places_count":235,"filtered_count":0,"filtered_main_tags":[]}"
"2025-11-05 13:31:17"
null
null
]
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('[DEBUG][followupThemeGraph]', '{\"theme\":\"substation\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[\"healthcare=pharmacy\",\"healthcare=pharmacy\",\"amenity=restaurant\",\"shop=bakery\",\"office=yes\",\"amenity=restaurant\",\"amenity=bar\",\"shop=bakery\",\"shop=furniture\",\"shop=clothes\",\"office=association\",\"shop=clothes\",\"shop=bakery\",\"shop=bakery\",\"shop=tobacco\",\"amenity=bar\",\"shop=e-cigarette\",\"amenity=restaurant\",\"amenity=car_wash\",\"shop=florist\",\"shop=hairdresser\",\"shop=bakery\",\"shop=alcohol\",\"amenity=veterinary\",\"amenity=bank\",\"healthcare=yes\",\"tourism=guest_house\",\"tourism=guest_house\",\"tourism=hotel\",\"amenity=restaurant\",\"amenity=townhall\",\"office=company\",\"shop=cosmetics\",\"amenity=bar\",\"shop=alcohol\",\"tourism=guest_house\",\"amenity=townhall\",\"amenity=townhall\",\"amenity=restaurant\",\"shop=convenience\",\"amenity=car_wash\",\"healthcare=hospital\",\"shop=car\",\"shop=deli\",\"amenity=workshop\",\"shop=convenience\",\"amenity=bank\",\"amenity=bank\",\"healthcare=pharmacy\",\"shop=electronics\",\"shop=doityourself\",\"amenity=restaurant\",\"shop=laundry\",\"shop=convenience\",\"amenity=restaurant\",\"amenity=doctors\",\"tourism=hotel\",\"office=association\",\"shop=general\",\"amenity=restaurant\",\"tourism=guest_house\",\"amenity=bar\",\"amenity=restaurant\",\"tourism=guest_house\",\"healthcare=centre\",\"amenity=restaurant\",\"shop=bakery\",\"shop=clothes\",\"amenity=restaurant\",\"shop=pastry\",\"shop=car\",\"shop=car\",\"healthcare=yes\",\"shop=travel_agency\",\"shop=car\",\"amenity=pub\",\"healthcare=pharmacy\",\"amenity=restaurant\",\"amenity=townhall\",\"office=moving_company\",\"office=association\",\"healthcare=laboratory\",\"office=lawyer\",\"office=accountant\",\"amenity=kindergarten\",\"shop=alcohol\",\"amenity=veterinary\",\"amenity=bar\",\"shop=newsagent\",\"amenity=driving_school\",\"tourism=museum\",\"amenity=restaurant\",\"shop=optician\",\"amenity=cafe\",\"office=company\",\"shop=hairdresser\",\"office=ngo\",\"amenity=fast_food\",\"shop=hairdresser\",\"amenity=restaurant\",\"shop=interior_decoration\",\"shop=hairdresser\",\"amenity=car_wash\",\"amenity=car_wash\",\"office=estate_agent\",\"shop=pastry\",\"amenity=bar\",\"shop=cosmetics\",\"shop=pastry\",\"healthcare=pharmacy\",\"amenity=restaurant\",\"office=employment_agency\",\"shop=beauty\",\"shop=butcher\",\"shop=optician\",\"shop=hairdresser\",\"shop=cosmetics\",\"shop=dry_cleaning\",\"shop=mobile_phone\",\"shop=jewelry\",\"shop=cosmetics\",\"shop=optician\",\"healthcare=pharmacy\",\"office=personal_service\",\"shop=shoes\",\"shop=mobile_phone\",\"shop=video_games\",\"shop=clothes\",\"shop=video\",\"shop=clothes\",\"shop=clothes\",\"shop=clothes\",\"shop=florist\",\"shop=furniture\",\"shop=clothes\",\"shop=cosmetics\",\"shop=clothes\",\"shop=electronics\",\"shop=jewelry\",\"shop=frozen_food\",\"office=travel_agent\",\"shop=bag\",\"shop=shoes\",\"shop=clothes\",\"amenity=bar\",\"amenity=restaurant\",\"shop=clothes\",\"shop=mobile_phone\",\"shop=clothes\",\"shop=clothes\",\"amenity=cafe\",\"office=association\",\"shop=wine\",\"tourism=information\",\"shop=fireplace\",\"shop=bakery\",\"office=insurance\",\"amenity=car_rental\",\"shop=car_repair\",\"amenity=fast_food\",\"shop=bakery\",\"shop=kitchen\",\"shop=chocolate\",\"shop=pet\",\"office=association\",\"amenity=pub\",\"shop=mosaic\",\"amenity=restaurant\",\"office=accountant\",\"office=employment_agency\",\"shop=car_repair\",\"healthcare=hospital\",\"shop=convenience;gas\",\"shop=garden_centre\",\"shop=supermarket\",\"shop=doityourself\",\"tourism=hotel\",\"shop=variety_store\",\"amenity=restaurant\",\"shop=sports\",\"shop=interior_decoration\",\"shop=shoes\",\"tourism=hotel\",\"shop=car_repair\",\"amenity=townhall\",\"amenity=bank\",\"healthcare=centre\",\"shop=butcher\",\"shop=cheese\",\"amenity=fast_food\",\"amenity=veterinary\",\"amenity=car_wash\",\"amenity=car_wash\",\"amenity=bar\",\"amenity=restaurant\",\"amenity=car_wash\",\"office=research\",\"shop=florist\",\"amenity=restaurant\",\"shop=mall\",\"shop=books\",\"shop=craft\",\"amenity=restaurant\",\"shop=supermarket\",\"amenity=theatre\",\"shop=books\",\"shop=wine\",\"amenity=restaurant\",\"shop=supermarket\",\"amenity=restaurant\",\"shop=gas\",\"shop=car_repair\",\"amenity=restaurant\",\"amenity=vehicle_inspection\",\"tourism=hotel\",\"shop=supermarket\",\"shop=laundry\",\"shop=outpost\",\"shop=laundry\",\"shop=books\",\"shop=car_repair\",\"shop=clothes\",\"tourism=museum\",\"shop=bakery\",\"shop=pet\",\"healthcare=pharmacy\",\"shop=garden_centre\",\"amenity=theatre\",\"tourism=chalet\",\"shop=books\",\"amenity=restaurant\",\"shop=supermarket\",\"shop=bakery\",\"shop=gift\",\"tourism=museum\"],\"places_count\":235,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2025-11-05 13:31:17', NULL, NULL);
|
| 242 |
2.17 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 = ?
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 = 1988;
|