INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds_aug18-29.pdf','2026-03-02 02:23:51','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c8=European+Union&c10=entry+72','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 OPR/127.0.0.0')RETURNING "id"; | 1.38ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 17.08ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.55ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 3.10ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 26.07ms | SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0; | 37.63ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 2.12ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.33ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 197) LIMIT 1 OFFSET 0; | 0.63ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.30ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.55ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 85) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 72) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 49) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 7) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 140) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 5) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 100) LIMIT 1 OFFSET 0; | 0.38ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 37) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 81) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 18.84ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.37ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 4.43ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.93ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.76ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.53ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.71ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.23ms | 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"("normalised_filename","source_country","pdf","translation_status","source_local_title","source_subtopic","page_count","private","source_title","filehash","normalise_check","zero_length_pdf","review_state","file_uid","source_year","filehash_dupe","file_pages","filehash_count","notes","source_topic","file_languages","source_url","text_bytes","accessed_date","source_id") VALUES (NULL,38,'regulation.pdf.a1d088f696f89bf6.R01TRFMtRGVjIDI1LTEzMy5wZGY=.pdf',NULL,'Directive No 2013/34/EU: Annual Financial Statements, Consolidated Financial Statements And Related Reports Of Certain Types Of Undertakings (Consolidated 2024-05-28)(English)',15,NULL,'F','Directive No 2013/34/EU: Annual Financial Statements, Consolidated Financial Statements And Related Reports Of Certain Types Of Undertakings (Consolidated 2024-05-28)(English)',NULL,NULL,'F',NULL,NULL,'2024','F',NULL,NULL,NULL,2,'||','https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:02013L0034-20240528',NULL,'2026-03-02','GMSDS-Dec 25-133')RETURNING "id"; | 1.33ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.55ms | 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.38ms | INSERT INTO "regulation"("normalised_filename","source_country","pdf","translation_status","source_local_title","source_subtopic","page_count","private","source_title","filehash","normalise_check","zero_length_pdf","review_state","file_uid","source_year","filehash_dupe","file_pages","filehash_count","notes","source_topic","file_languages","source_url","text_bytes","accessed_date","source_id") VALUES (NULL,60,'regulation.pdf.abaf06781843a037.R01TRFMtRGVjIDI1LTEzNS5wZGY=.pdf',NULL,'農薬取締法施行規則',14,NULL,'F','Regulations For Enforcement Of The Agricultural Chemicals Regulation Act (Consolidated 2023-12-28)(Japanese)',NULL,NULL,'F',NULL,NULL,'2023','F',NULL,NULL,NULL,1,'||','https://www.maff.go.jp/j/nouyaku/n_kaisei/attach/pdf/index-22.pdf',NULL,'2026-03-02','GMSDS-Dec 25-135')RETURNING "id"; | 1.13ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.67ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.23ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.31ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 14.98ms | SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0; | 12.49ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.47ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0; | 0.35ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 197) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 81) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 85) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 72) LIMIT 1 OFFSET 0; | 0.27ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 49) LIMIT 1 OFFSET 0; | 0.56ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 7) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 140) LIMIT 1 OFFSET 0; | 0.18ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES (NULL,'2026-03-02 10:16:41',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 24.00ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds_oct18-1198.pdf','2026-03-02 10:17:44','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=40&c7=Water','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 17.73ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds_oct18-1206.pdf','2026-03-02 10:17:44','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=40&c7=Water','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 0.30ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds_oct18-1222.pdf','2026-03-02 10:25:47','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=60&c7=Water','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 1.05ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds_oct18-1231.pdf','2026-03-02 10:25:48','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=60&c7=Water','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 0.52ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/23-248_gmsds.pdf','2026-03-02 10:25:50','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c7=Water&c8=Spain','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 0.43ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds-feb21-71.pdf','2026-03-02 10:26:06','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c7=Water','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 1.10ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/gmsds_feb19-367.pdf','2026-03-02 10:26:07','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c7=Water','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0')RETURNING "id"; | 0.42ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES (NULL,'2026-03-02 10:58:06',NULL,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 0.54ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES (NULL,'2026-03-02 10:58:06',NULL,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 0.32ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/14-11_gmsds.pdf','2026-03-02 10:58:07','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 0.28ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","search_uri","user_agent") VALUES ('https://chemreg.net/regulations/14-55_gmsds.pdf','2026-03-02 10:58:08','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 1.05ms |
|
