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.18ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.45ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.38ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.37ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.26ms | INSERT INTO "regulation"("source_topic","source_country","source_subtopic","file_languages","file_pages","notes","private","text_bytes","source_id","filehash_dupe","source_url","source_title","source_year","source_local_title","filehash_count","page_count","filehash","translation_status","review_state","normalised_filename","pdf","zero_length_pdf","file_uid","accessed_date","normalise_check") VALUES (4,5,15,'||',NULL,NULL,'F',NULL,'GMSDS-Feb 26-60','F','https://www.industrialchemicals.gov.au/news-and-notices/variation-inventory-listing-after-evaluation-cas-numbers-70693-64-0-12222-80-9-15141-18-1-68516-81-4-69766-79-6-and-72987-42-9','Published Data: Australian Inventory Of Industrial Chemicals (AIIC) (Amendment 2026-01-19)(English)','2026','Published Data: Australian Inventory Of Industrial Chemicals (AIIC) (Amendment 2026-01-19)(English)',NULL,NULL,NULL,NULL,NULL,NULL,'regulation.pdf.85865475c0ddde05.R01TRFMtRmViIDI2LTYwLnBkZg==.pdf','F',NULL,'2026-04-23',NULL)RETURNING "id"; | 0.61ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.69ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.18ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.25ms | INSERT INTO "regulation"("source_topic","source_country","source_subtopic","file_languages","file_pages","notes","private","text_bytes","source_id","filehash_dupe","source_url","source_title","source_year","source_local_title","filehash_count","page_count","filehash","translation_status","review_state","normalised_filename","pdf","zero_length_pdf","file_uid","accessed_date","normalise_check") VALUES (1,63,40,'||',NULL,NULL,'F',NULL,'GMSDS-Feb 26-63','F','https://www.law.go.kr/admRulLsInfoP.do?chrClsCd=&admRulSeq=2100000272950#AJAX','NIER Regulation No 1/2026: Designation Of Restricted Chemicals And Prohibited Chemicals (Korean)','2026','NIER Regulation No 1/2026: Designation Of Restricted Chemicals And Prohibited Chemicals (Korean)',NULL,NULL,NULL,NULL,NULL,NULL,'regulation.pdf.ab8152fc2d803a20.R01TRFMtRmViIDI2LTYzLnBkZg==.pdf','F',NULL,'2026-04-23',NULL)RETURNING "id"; | 0.31ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.35ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.26ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.25ms | INSERT INTO "regulation"("source_topic","source_country","source_subtopic","file_languages","file_pages","notes","private","text_bytes","source_id","filehash_dupe","source_url","source_title","source_year","source_local_title","filehash_count","page_count","filehash","translation_status","review_state","normalised_filename","pdf","zero_length_pdf","file_uid","accessed_date","normalise_check") VALUES (3,71,9,'||',NULL,NULL,'F',NULL,'GMSDS-Feb 26-64','F','https://lom.agc.gov.my/act-view.php?type=pua&language=BI&no=P.U.%20(A)%208/2026','Customs (Prohibition Of Exports) Order 2026 (Amendment 2026-01-12)(English)','2026','Customs (Prohibition Of Exports) Order 2026 (Amendment 2026-01-12)(English)',NULL,NULL,NULL,NULL,NULL,NULL,'regulation.pdf.be7854f4b4ce241b.R01TRFMtRmViIDI2LTY0LnBkZg==.pdf','F',NULL,'2026-04-23',NULL)RETURNING "id"; | 0.39ms | SELECT "regulation"."id", "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_local_title", "regulation"."source_year", "regulation"."source_url", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."notes", "regulation"."status", "regulation"."file_uid", "regulation"."file_pages", "regulation"."text_bytes", "regulation"."file_languages", "regulation"."review_state", "regulation"."normalised_filename", "regulation"."normalise_check", "regulation"."filehash_dupe", "regulation"."filehash_count", "regulation"."translation_status", "regulation"."zero_length_pdf", "regulation"."page_count", "regulation"."filehash" FROM "regulation" WHERE ("regulation"."id" = 15189) LIMIT 1 OFFSET 0; | 2.73ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.46ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.24ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.48ms | UPDATE "regulation" SET "source_topic"=1,"source_country"=63,"source_subtopic"=40,"file_languages"='||',"file_pages"=NULL,"status"=NULL,"notes"=NULL,"private"='F',"text_bytes"=NULL,"source_id"='GMSDS-Feb 26-63',"filehash_dupe"='F',"source_url"='https://www.law.go.kr/admRulLsInfoP.do?chrClsCd=&admRulSeq=2100000272950#AJAX',"source_title"='NIER Regulation No 1/2026: Designation Of Restricted Chemicals And Prohibited Chemicals (Korean)',"source_year"='2026',"source_local_title"='화학물질안전원고시 제2026-1호, 2026. 1. 15., 일부개정: 승인유예대상 기존살생물물질의 지정',"filehash_count"=NULL,"page_count"=NULL,"filehash"=NULL,"translation_status"=NULL,"review_state"=NULL,"normalised_filename"=NULL,"pdf"='regulation.pdf.ba7d7be8430ecf4d.R01TRFMtRmViIDI2LTYzLnBkZg==.pdf',"zero_length_pdf"='F',"file_uid"=NULL,"accessed_date"='2026-04-23',"normalise_check"=NULL WHERE ("regulation"."id" = 15189); | 8.25ms |
|
