SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 2.85ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.42ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.72ms | INSERT INTO "regulation"("text_bytes","filehash_dupe","page_count","accessed_date","source_url","source_year","source_subtopic","source_local_title","file_languages","source_topic","notes","source_id","source_country","private","review_state","normalised_filename","filehash_count","file_pages","translation_status","file_uid","zero_length_pdf","normalise_check","pdf","source_title","filehash") VALUES (NULL,'F',NULL,'2026-08-03','https://pdf.datalegis.net/files/cri93i182a5m6lg72nlrsh17pv_1785716481.pdf','2026',43,'PORTARIA Nº 344, DE 12 DE MAIO DE 1998: Aprova o Regulamento Técnico sobre substâncias e medicamentos sujeitos a controle especial.','||',3,NULL,'GMSDS-May 26-16',12,'F',NULL,NULL,NULL,NULL,NULL,NULL,'F',NULL,'regulation.pdf.93599d6dbbf18e50.R01TRFMtTWF5IDI2LTE2LnBkZg==.pdf','Ordinance No 344/1998: Technical Regulation On Substaances And Drugs Subject To Special Control (Consolidated 2026-05-13)(Portuguese)',NULL)RETURNING "id"; | 4.17ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.98ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.27ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.41ms | INSERT INTO "regulation"("text_bytes","filehash_dupe","page_count","accessed_date","source_url","source_year","source_subtopic","source_local_title","file_languages","source_topic","notes","source_id","source_country","private","review_state","normalised_filename","filehash_count","file_pages","translation_status","file_uid","zero_length_pdf","normalise_check","pdf","source_title","filehash") VALUES (NULL,'F',NULL,'2026-08-03','https://www.legislation.gov.uk/uksi/2026/484/made/data.pdf','2026',40,'Regulation No 2026/484: Chemicals (Health And Safety) (Amendment, Consequential And Transitional Provision) (English)','||',1,NULL,'GMSDS-May 26-29',120,'F',NULL,NULL,NULL,NULL,NULL,NULL,'F',NULL,'regulation.pdf.9195243db5fdd2fb.R01TRFMtTWF5IDI2LTI5LnBkZg==.pdf','Regulation No 2026/484: Chemicals (Health And Safety) (Amendment, Consequential And Transitional Provision) (English)',NULL)RETURNING "id"; | 1.17ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 5.32ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.49ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.76ms | INSERT INTO "regulation"("text_bytes","filehash_dupe","page_count","accessed_date","source_url","source_year","source_subtopic","source_local_title","file_languages","source_topic","notes","source_id","source_country","private","review_state","normalised_filename","filehash_count","file_pages","translation_status","file_uid","zero_length_pdf","normalise_check","pdf","source_title","filehash") VALUES (NULL,'F',NULL,'2026-08-03','https://www.riksdagen.se/sv/dokument-och-lagar/dokument/svensk-forfattningssamling/miljobalk-1998808_sfs-1998-808/','2026',15,'Miljöbalk (1998:808)','||',2,NULL,'GMSDS-May 26-34',107,'F',NULL,NULL,NULL,NULL,NULL,NULL,'F',NULL,'regulation.pdf.a9b091c6a96e9016.R01TRFMtTWF5IDI2LTM0LnBkZg==.pdf','Act No 1998:808: Environmental Code (Consolidated 2026-04-29)(Swedish)',NULL)RETURNING "id"; | 2.88ms | SELECT "account"."account", "account"."id" FROM "account" WHERE ("account"."id" IS NOT NULL) ORDER BY "account"."account", "account"."id"; | 17.23ms | SELECT "auth_user"."id", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."registration_key", "auth_user"."reset_password_key", "auth_user"."registration_id", "auth_user"."account_id" FROM "auth_user" WHERE (("auth_user"."email" = 'p.odob.o.c.af.id88.3@gmail.com') AND ("auth_user"."id" <> 0)) ORDER BY "auth_user"."id" LIMIT 1 OFFSET 0; | 10.82ms | INSERT INTO "auth_user"("password","registration_id","last_name","email","first_name","reset_password_key","registration_key","account_id") VALUES ('pbkdf2(1000,20,sha512)$b50b0a7ed80c1f3e$3d149dbf8ddc02945034373c9f4ef66a28466443','','CvXfVpbKGPjyudjtLJMHYcAE','p.odob.o.c.af.id88.3@gmail.com','uXzmfQSVhBDAyDCQxRH','','1cfa2143-abac-4938-a154-51fddb7fd99f',1)RETURNING "id"; | 5.97ms | INSERT INTO "auth_group"("role","description") VALUES ('user_27','Group uniquely assigned to user 27')RETURNING "id"; | 2.85ms | INSERT INTO "auth_event"("origin","user_id","description","time_stamp","client_ip") VALUES ('auth',NULL,'Group 31 created','2026-08-03 04:12:52','203.55.81.1')RETURNING "id"; | 5.23ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 27) AND ("auth_membership"."group_id" = 31)); | 1.30ms | INSERT INTO "auth_membership"("user_id","group_id") VALUES (27,31)RETURNING "id"; | 2.81ms | UPDATE "auth_user" SET "registration_key"='' WHERE ("auth_user"."id" = 27); | 2.08ms | SELECT "auth_user"."id", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."registration_key", "auth_user"."reset_password_key", "auth_user"."registration_id", "auth_user"."account_id" FROM "auth_user" WHERE ("auth_user"."email" = 'p.odob.o.c.af.id88.3@gmail.com') LIMIT 1 OFFSET 0; | 0.20ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE ("auth_membership"."user_id" = 27); | 0.15ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."id" = 31) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "auth_user"."id", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."registration_key", "auth_user"."reset_password_key", "auth_user"."registration_id", "auth_user"."account_id" FROM "auth_user" WHERE ("auth_user"."id" = 27) LIMIT 1 OFFSET 0; | 0.33ms | INSERT INTO "auth_event"("origin","user_id","description","time_stamp","client_ip") VALUES ('auth',27,'User 27 Registered','2026-08-03 04:12:52','203.55.81.1')RETURNING "id"; | 0.27ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36',NULL,NULL,'2026-08-03 11:05:53')RETURNING "id"; | 0.60ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.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','2026-08-03 11:05:53')RETURNING "id"; | 0.36ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','https://chemreg.net/regulations/gmsds-feb20-703.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-08-03 11:06:20')RETURNING "id"; | 0.43ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.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','2026-08-03 11:06:21')RETURNING "id"; | 0.48ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','https://chemreg.net/regulations/gmsds-feb21-184.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=40','2026-08-03 11:06:34')RETURNING "id"; | 4.95ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','https://chemreg.net/regulations/gmsds-feb21-257.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=40','2026-08-03 11:06:35')RETURNING "id"; | 0.85ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)',NULL,NULL,'2026-08-03 13:08:39')RETURNING "id"; | 0.52ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','https://chemreg.net/regulations/30-87_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-08-03 13:08:40')RETURNING "id"; | 0.40ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','https://chemreg.net/regulations/17-65_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-08-03 13:08:41')RETURNING "id"; | 0.39ms |
|
