SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.08ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.33ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.44ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.08ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.32ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.38ms | INSERT INTO "regulation"("translation_status","normalise_check","source_subtopic","page_count","file_uid","review_state","file_languages","source_year","pdf","source_url","source_title","filehash","source_country","text_bytes","accessed_date","source_topic","filehash_dupe","notes","private","source_local_title","normalised_filename","filehash_count","file_pages","source_id","zero_length_pdf") VALUES (NULL,NULL,15,NULL,NULL,NULL,'||','2025','regulation.pdf.aa5ed5883e99a9f7.R01TRFMtRmViXzI2LTkxLnBkZg==.pdf','https://parliament.gov.fj/wp-content/uploads/2026/03/Act-27-Environment-Management-Amendment.pdf','Environment Management (Amendment) Act 2025 (Consolidated 2025-12-03)(English)',NULL,41,NULL,'2026-05-11',6,'F',NULL,'F','Environment Management (Amendment) Act 2025 (Consolidated 2025-12-03)(English)',NULL,NULL,NULL,'GMSDS-Feb 26-91','F')RETURNING "id"; | 2.04ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.78ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.25ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.34ms | INSERT INTO "regulation"("translation_status","normalise_check","source_subtopic","page_count","file_uid","review_state","file_languages","source_year","pdf","source_url","source_title","filehash","source_country","text_bytes","accessed_date","source_topic","filehash_dupe","notes","private","source_local_title","normalised_filename","filehash_count","file_pages","source_id","zero_length_pdf") VALUES (NULL,NULL,40,NULL,NULL,NULL,'||','2025','regulation.pdf.b256a66f09eeb99c.R01TRFMtRmViXzI2LTkzLnBkZg==.pdf','https://www.riigiteataja.ee/akt/103122025007.pdf','RT I, 10.11.2015, 2: Chemicals Act (Consolidated 2025-12-03)(Estonian)',NULL,36,NULL,'2026-05-11',1,'F',NULL,'F','RT I, 10.11.2015, 2: Kemikaaliseadus',NULL,NULL,NULL,'GMSDS-Feb 26-93','F')RETURNING "id"; | 1.18ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.40ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.44ms | 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 "search_hit"("hit_timestamp","hit_uri","search_uri","user_agent") VALUES ('2026-05-11 06:14:49','https://chemreg.net/regulations/2-124_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)')RETURNING "id"; | 0.40ms | INSERT INTO "search_hit"("hit_timestamp","hit_uri","search_uri","user_agent") VALUES ('2026-05-11 09:18:58','https://chemreg.net/regulations/3-1916_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20&c8=Spain&c7=Classification%2C+Labelling+and+Packaging','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0')RETURNING "id"; | 5.69ms |
|