SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.05ms | 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.71ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.88ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.22ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.46ms | INSERT INTO "regulation"("source_country","file_pages","source_local_title","filehash_count","accessed_date","filehash","file_uid","notes","filehash_dupe","review_state","private","source_topic","source_year","source_subtopic","pdf","normalised_filename","source_url","source_id","normalise_check","source_title","zero_length_pdf","text_bytes","translation_status","file_languages","page_count") VALUES (38,NULL,'Directive (EU) No 2024/825: Amending Directives 2005/29/EC And 2011/83/EU As Regards Empowering Consumers For The Green Transition Through Better Protection Against Unfair Practices And Through Better Information (English)',NULL,'2026-08-13',NULL,NULL,NULL,'F',NULL,'F',2,'2024',15,'regulation.pdf.a1d32a24be63556c.R01TRFMtSnVuIDI2LTExMy5wZGY=.pdf',NULL,'https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=OJ:L_202400825','GMSDS-Jun 26-113',NULL,'Directive (EU) No 2024/825: Amending Directives 2005/29/EC And 2011/83/EU As Regards Empowering Consumers For The Green Transition Through Better Protection Against Unfair Practices And Through Better Information (English)','F',NULL,NULL,'||',NULL)RETURNING "id"; | 8.23ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.97ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.28ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.39ms | INSERT INTO "regulation"("source_country","file_pages","source_local_title","filehash_count","accessed_date","filehash","file_uid","notes","filehash_dupe","review_state","private","source_topic","source_year","source_subtopic","pdf","normalised_filename","source_url","source_id","normalise_check","source_title","zero_length_pdf","text_bytes","translation_status","file_languages","page_count") VALUES (82,NULL,'ACVM Requirements: Registration Information Requirements For Agricultural Chemicals (Consolidated 2024-02-29)(English)',NULL,'2026-08-13',NULL,NULL,NULL,'F',NULL,'F',1,'2024',15,'regulation.pdf.886574d90afd63b6.R01TRFMtSnVuIDI2LTExNS5wZGY=.pdf',NULL,'https://www.mpi.govt.nz/dmsdocument/1423-ACVM-registration-information-requirements-for-agricultural-chemicals-in-New-Zealand','GMSDS-Jun 26-115',NULL,'ACVM Requirements: Registration Information Requirements For Agricultural Chemicals (Consolidated 2024-02-29)(English)','F',NULL,NULL,'||',NULL)RETURNING "id"; | 1.32ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 9.38ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.96ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 2.25ms | INSERT INTO "regulation"("source_country","file_pages","source_local_title","filehash_count","accessed_date","filehash","file_uid","notes","filehash_dupe","review_state","private","source_topic","source_year","source_subtopic","pdf","normalised_filename","source_url","source_id","normalise_check","source_title","zero_length_pdf","text_bytes","translation_status","file_languages","page_count") VALUES (120,NULL,'Regulation No 2018/1265 (EU Exit): Wharves, Examination Stations And Temporary Storage Facilities (Approval Conditions) (Consolidated 2022-07-01)(English)',NULL,'2026-08-13',NULL,NULL,NULL,'F',NULL,'F',3,'2022',9,'regulation.pdf.9c2a3e2e0534e911.R01TRFMtSnVuIDI2LTExNy5wZGY=.pdf',NULL,'https://www.legislation.gov.uk/uksi/2018/1265/2022-07-01/data.pdf','GMSDS-Jun 26-117',NULL,'Regulation No 2018/1265 (EU Exit): Wharves, Examination Stations And Temporary Storage Facilities (Approval Conditions) (Consolidated 2022-07-01)(English)','F',NULL,NULL,'||',NULL)RETURNING "id"; | 5.18ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-08-13 07:00:53','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 17.35ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-08-13 07:00:54','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 0.35ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-08-13 07:00:55','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.55ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-08-13 07:00:56','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-127_gmsds.pdf')RETURNING "id"; | 0.55ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'Site Managers'); | 0.47ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 28) AND ("auth_membership"."group_id" = 3)); | 0.21ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'Superuser'); | 0.45ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 28) AND ("auth_membership"."group_id" = 5)); | 0.37ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'DBAs'); | 0.20ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 28) AND ("auth_membership"."group_id" = 4)); | 0.36ms | INSERT INTO "search_hit"("hit_timestamp","user_agent","search_uri","hit_uri") VALUES ('2026-08-13 14:58:45','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL)RETURNING "id"; | 0.35ms |
|
