INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-09-10 07:16:42','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 0.24ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-09-10 07:16:42','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/14-11_gmsds.pdf')RETURNING "id"; | 0.31ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-09-10 07:16:43','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/17-65_gmsds.pdf')RETURNING "id"; | 0.25ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.87ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.21ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.33ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.60ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.21ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.31ms | INSERT INTO "regulation"("private","source_id","source_country","file_uid","source_topic","source_subtopic","filehash_dupe","file_pages","pdf","text_bytes","normalised_filename","filehash","source_url","source_local_title","accessed_date","file_languages","normalise_check","review_state","translation_status","source_year","page_count","zero_length_pdf","filehash_count","notes","source_title") VALUES ('F','GMSDS-Aug 26-46',107,NULL,2,15,'F',NULL,'regulation.pdf.852e2585580d9aa1.R01TRFMtQXVnIDI2LTQ2LnBkZg==.pdf',NULL,NULL,NULL,'https://www.riksdagen.se/sv/dokument-och-lagar/dokument/svensk-forfattningssamling/miljotillsynsforordning-201113_sfs-2011-13/','Förordning nr 2011:13: Miljötillsyn (sammanställd 2026-07-28)','2026-09-10','||',NULL,NULL,NULL,'2026',NULL,'F',NULL,NULL,'Ordinance No 2011:13: Environmental Supervision (Consolidated 2026-07-28)(Swedish)')RETURNING "id"; | 0.46ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-09-10 08:49:57','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 0.24ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-09-10 08:49:58','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/39-1_gmsds.pdf')RETURNING "id"; | 0.32ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-09-10 08:49:59','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/2-122_gmsds.pdf')RETURNING "id"; | 0.28ms |
|