SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.47ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.20ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.27ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 12.36ms | 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; | 15.94ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.56ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 143) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.14ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 85) LIMIT 1 OFFSET 0; | 0.15ms | 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" = 122) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 120) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) 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.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 5) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 20) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.27ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 49) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 82) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 4) LIMIT 1 OFFSET 0; | 0.19ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-04-22 07:33:07','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36',NULL)RETURNING "id"; | 34.40ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-04-22 07:33:07','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36',NULL)RETURNING "id"; | 0.30ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/14-1_gmsds.pdf','2026-04-22 07:33:07','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 1.27ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/17-11_gmsds.pdf','2026-04-22 07:33:08','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 7.17ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/19-56_gmsds.pdf','2026-04-22 07:33:48','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c8=Turkey')RETURNING "id"; | 0.35ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/gmsds_mar19-592.pdf','2026-04-22 07:34:32','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c8=Turkey')RETURNING "id"; | 0.63ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/17-385_gmsds.pdf','2026-04-22 07:34:33','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c8=Turkey')RETURNING "id"; | 0.32ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/39-1_gmsds.pdf','2026-04-22 07:35:23','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id"; | 0.42ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/14-11_gmsds.pdf','2026-04-22 07:35:55','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c6=Dangerous+-+Toxic+Substances&c6=Environment&c6=Environmental')RETURNING "id"; | 0.82ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/22-221_gmsds.pdf','2026-04-22 07:35:56','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c6=Environment&c6=Environmental')RETURNING "id"; | 0.44ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/gmsds-feb21-141.pdf','2026-04-22 07:35:57','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c6=Environment&c6=Environmental')RETURNING "id"; | 0.43ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/triage/merge1/GMSDS-Jan_24-106.pdf','2026-04-22 07:36:59','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c6=Environmental&c8=Afghanistan')RETURNING "id"; | 0.33ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/gmsds-mar21-166.pdf','2026-04-22 07:37:14','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c8=Afghanistan&c8=Sri+Lanka')RETURNING "id"; | 1.29ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/gmsds-nov25-148.pdf','2026-04-22 07:37:15','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c8=Afghanistan&c8=Sri+Lanka')RETURNING "id"; | 0.25ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.32ms | 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.27ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.50ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.19ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.29ms | INSERT INTO "regulation"("pdf","notes","text_bytes","accessed_date","private","translation_status","file_uid","filehash_dupe","normalised_filename","filehash_count","page_count","source_local_title","zero_length_pdf","source_topic","review_state","source_subtopic","normalise_check","source_title","file_languages","source_country","file_pages","filehash","source_year","source_url","source_id") VALUES ('regulation.pdf.925fb159ae487147.R01TRFMtRmViIDI2LTUyLnBkZg==.pdf',NULL,NULL,'2026-04-22','F',NULL,NULL,'F',NULL,NULL,NULL,'ABNT NBR 20250:2026 General Sustainability Guidelines For Products And Services (English)(Copyright)','F',2,NULL,15,NULL,'ABNT NBR 20250:2026 General Sustainability Guidelines For Products And Services (English)(Copyright)','||',12,NULL,NULL,'2026','https://www.abnt.org.br/','GMSDS-Feb 26-52')RETURNING "id"; | 0.82ms | INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-04-22 10:40:18','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36 OPR/130.0.0.0',NULL)RETURNING "id"; | 15.35ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'Site Managers'); | 0.28ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 18) AND ("auth_membership"."group_id" = 3)); | 0.17ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'Superuser'); | 0.15ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 18) AND ("auth_membership"."group_id" = 5)); | 0.16ms | SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'DBAs'); | 0.14ms | SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE (("auth_membership"."user_id" = 18) AND ("auth_membership"."group_id" = 4)); | 0.14ms |
|