SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.55ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.31ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.40ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.81ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.36ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.47ms | INSERT INTO "regulation"("normalised_filename","translation_status","source_year","notes","source_title","source_local_title","normalise_check","file_uid","text_bytes","source_country","filehash_count","pdf","accessed_date","zero_length_pdf","filehash","source_id","source_url","source_topic","file_pages","file_languages","filehash_dupe","page_count","private","review_state","source_subtopic") VALUES (NULL,NULL,'2025',NULL,'Resolution No 5783/2025: Procedural Guidelines For The Declaration Of The Import And Export Authorization Of Recovered Non-Hazardous Waste Of Decree No 1/2025 And Resolution No 393/2025 (Spanish)','Resolución N.º 5783/2025: Directrices Procesales Para la Declaración de la Autorización de Importación y Exportación de Residuos No Peligrosos Recuperados del Decreto N.º 1/2025 y la Resolución N.º 393/2025',NULL,NULL,NULL,4,NULL,'regulation.pdf.8935978ec7539c1e.R01TRFMtT2N0IDI1LTgucGRm.pdf','2025-11-19','F',NULL,'GMSDS-Oct 25-8','https://www.boletinoficial.gob.ar/detalleAviso/primera/333665/20251030',2,NULL,'||','F',NULL,'F',NULL,15)RETURNING "id"; | 5.54ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.73ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.23ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.35ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.6478.114 Safari/537.36',NULL,NULL,'2025-11-20 01:46:37')RETURNING "id"; | 2.58ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.6478.114 Safari/537.36','https://chemreg.net/regulations/14-22_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-11-20 01:46:38')RETURNING "id"; | 16.85ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36','https://chemreg.net/regulations/14-11_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-11-20 06:46:29')RETURNING "id"; | 0.59ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36','https://chemreg.net/regulations/2-122_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-11-20 06:50:02')RETURNING "id"; | 5.27ms | 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" = 14599) LIMIT 1 OFFSET 0; | 4.06ms | 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.29ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.79ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.61ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.25ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.95ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 16.58ms | 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; | 9.67ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 4) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 112) LIMIT 1 OFFSET 0; | 0.15ms | 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" = 29) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 92) LIMIT 1 OFFSET 0; | 0.21ms | 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" = 1) LIMIT 1 OFFSET 0; | 0.36ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 20) LIMIT 1 OFFSET 0; | 0.51ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) 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.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 109) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 101) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.26ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 7) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 105) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) 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.24ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 5) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 30) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.95ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.25ms | 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 "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36',NULL,NULL,'2025-11-20 10:01:42')RETURNING "id"; | 15.52ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36',NULL,NULL,'2025-11-20 10:01:42')RETURNING "id"; | 2.32ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36','https://chemreg.net/regulations/14-22_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-11-20 10:01:44')RETURNING "id"; | 0.89ms | INSERT INTO "search_hit"("user_agent","hit_uri","search_uri","hit_timestamp") VALUES ('Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 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','2025-11-20 10:01:45')RETURNING "id"; | 0.29ms |
|
