SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 2.14ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.41ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.73ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 19.01ms | 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; | 14.55ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.45ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.50ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 5) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 4) LIMIT 1 OFFSET 0; | 0.34ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 18) LIMIT 1 OFFSET 0; | 8.21ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.31ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 45) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0; | 0.41ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 128) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 82) LIMIT 1 OFFSET 0; | 0.65ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 89) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 108) LIMIT 1 OFFSET 0; | 0.41ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0; | 0.41ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0; | 0.26ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.14ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.46ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.51ms | INSERT INTO "regulation"("source_topic","review_state","file_pages","accessed_date","source_year","normalise_check","source_subtopic","text_bytes","normalised_filename","source_title","filehash_dupe","page_count","source_id","source_country","zero_length_pdf","translation_status","private","filehash","pdf","source_local_title","source_url","notes","file_uid","filehash_count","file_languages") VALUES (1,NULL,NULL,'2026-07-30','2026',NULL,54,NULL,NULL,'MCEE Notice No 5/2026: Designation Notice Of Hazardous Substances, Chronic Human Hazardous Substances, And Ecological Hazardous Substances (Korean)','F',NULL,'GMSDS-April 26-78',63,'F',NULL,'F',NULL,'regulation.pdf.b4b831e1175d616b.R01TRFMtQXByaWwgMjYtNzgucGRm.pdf','인체급성유해성물질, 인체만성유해성물질 및 생태유해성물질의 지정','https://www.law.go.kr/admRulLsInfoP.do?chrClsCd=&admRulSeq=2100000276378#AJAX',NULL,NULL,NULL,'||')RETURNING "id"; | 2.02ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.90ms | 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.64ms | INSERT INTO "regulation"("source_topic","review_state","file_pages","accessed_date","source_year","normalise_check","source_subtopic","text_bytes","normalised_filename","source_title","filehash_dupe","page_count","source_id","source_country","zero_length_pdf","translation_status","private","filehash","pdf","source_local_title","source_url","notes","file_uid","filehash_count","file_languages") VALUES (3,NULL,NULL,'2026-07-30','2026',NULL,9,NULL,NULL,'Customs (Prohibited Imports) Regulations 1956 (Consolidated 2026-03-26)(English)','F',NULL,'GMSDS-April 26-82',5,'F',NULL,'F',NULL,'regulation.pdf.82b7f72cc7df54db.R01TRFMtQXByaWwgMjYtODIucGRm.pdf','Customs (Prohibited Imports) Regulations 1956 (Consolidated 2026-03-26)(English)','https://www.legislation.gov.au/F1996B03651/2026-03-26/2026-03-26/text/original/pdf',NULL,NULL,NULL,'||')RETURNING "id"; | 0.59ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.30ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.62ms | INSERT INTO "regulation"("source_topic","review_state","file_pages","accessed_date","source_year","normalise_check","source_subtopic","text_bytes","normalised_filename","source_title","filehash_dupe","page_count","source_id","source_country","zero_length_pdf","translation_status","private","filehash","pdf","source_local_title","source_url","notes","file_uid","filehash_count","file_languages") VALUES (1,NULL,NULL,'2026-07-30','2026',NULL,14,NULL,NULL,'Resolution No 200/2026: Import, Registration, And Renewal Of PPP Based On The Active Ingredient Carbosulfan Are Prohibited (Spanish)','F',NULL,'GMSDS-April 26-83',123,'F',NULL,'F',NULL,'regulation.pdf.b266a8ac03b098f3.R01TRFMtQXByaWwgMjYtODMucGRm.pdf','Resolución No 200/2026: Se prohíbe la importación, el registro y la renovación de PPP basados en el ingrediente activo Carbosulfán','https://www.impo.com.uy/diariooficial/2026/03/26/4',NULL,NULL,NULL,'||')RETURNING "id"; | 0.84ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.76ms | 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.38ms | INSERT INTO "regulation"("source_topic","review_state","file_pages","accessed_date","source_year","normalise_check","source_subtopic","text_bytes","normalised_filename","source_title","filehash_dupe","page_count","source_id","source_country","zero_length_pdf","translation_status","private","filehash","pdf","source_local_title","source_url","notes","file_uid","filehash_count","file_languages") VALUES (1,NULL,NULL,'2026-07-30','2026',NULL,14,NULL,NULL,'Resolution No 201/2026: The Use Of Chlorpyrifos Is Prohibited For All Purposes, With The Exceptions Indicated (Spanish)','F',NULL,'GMSDS-April 26-84',123,'F',NULL,'F',NULL,'regulation.pdf.a7078db5da11041b.R01TRFMtQXByaWwgMjYtODQucGRm.pdf','Resolution No 201/2026: The Use Of Chlorpyrifos Is Prohibited For All Purposes, With The Exceptions Indicated (Spanish)','https://www.impo.com.uy/diariooficial/2026/03/26/4',NULL,NULL,NULL,'||')RETURNING "id"; | 0.66ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 04:24:36','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 1.44ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 04:24:37','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 0.55ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 04:24:38','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 0.38ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 04:37:59','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5.2 Safari/605.1.15','https://chemreg.net/regulations/17-11_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.61ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 12:49:22','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 Edg/150.0.0.0',NULL,NULL)RETURNING "id"; | 0.36ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 12:49:34','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 Edg/150.0.0.0','https://chemreg.net/regulations/gmsds-july19-28.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.50ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 12:49:34','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 Edg/150.0.0.0','https://chemreg.net/regulations/2-112_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.38ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 15:07:11','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','https://chemreg.net/regulations/14-55_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.44ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 16:27:47','Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5 Mobile/15E148 Safari/604.1 Ddg/26.5',NULL,NULL)RETURNING "id"; | 0.38ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 16:27:48','Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5 Mobile/15E148 Safari/604.1 Ddg/26.5','https://chemreg.net/regulations/30-73_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.30ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 16:27:49','Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5 Mobile/15E148 Safari/604.1 Ddg/26.5','https://chemreg.net/regulations/30-87_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.37ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 20:26:20','Mozilla/5.0 (X11; Linux aarch64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','https://chemreg.net/regulations/gmsds-feb20-993.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 7.53ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","hit_uri","search_uri") VALUES ('2026-07-30 20:26:21','Mozilla/5.0 (X11; Linux aarch64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','https://chemreg.net/regulations/2-11_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.59ms |
|
