INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/2-11_gmsds.pdf','2026-05-14 07:08:10','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')RETURNING "id"; | 0.34ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 21.68ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.06ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 1.75ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.71ms | 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.31ms | INSERT INTO "regulation"("source_title","text_bytes","source_id","zero_length_pdf","review_state","normalise_check","filehash_dupe","filehash_count","filehash","file_pages","page_count","source_year","normalised_filename","pdf","file_uid","source_subtopic","private","source_topic","source_local_title","source_country","file_languages","translation_status","source_url","notes","accessed_date") VALUES ('Decree 643/2025: Technical Regulation On The Restriction Of The Use Of Certain Hazardous Substances In Electrical And Electronic Equipment (Romanian)',NULL,'GMSDS-Feb 26-109','F',NULL,NULL,'F',NULL,NULL,NULL,NULL,'2025',NULL,'regulation.pdf.a1ce03e282466631.R01TRFMtRmViXzI2LTEwOS5wZGY=.pdf',NULL,11,'F',1,'HOTĂRÂRE Nr. HG643/2025 din 01.10.2025 pentru aprobarea Reglementării tehnice privind restricționarea utilizării anumitor substanțe periculoase în echipamentele electrice și electronice',158,'||',NULL,'https://www.legis.md/cautare/getResults?doc_id=151148&lang=rohttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_1_643%20ro.docxhttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_2_643%20ro.docxhttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_3_643%20ro.docxhttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_4_643%20ro.docxhttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_5_643%20ro.docxhttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_6_643%20ro.docxhttps://www.legis.md/UserFiles/Image/RO/2025/mo%20526-528%20ro/an_7_643%20ro.docx',NULL,'2026-05-14')RETURNING "id"; | 10.29ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.33ms | 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.47ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 7.55ms | 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.97ms | 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" = 51) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 101) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 158) LIMIT 1 OFFSET 0; | 0.16ms | 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.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.17ms | 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.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 42) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 85) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) 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.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 28) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 117) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 29) LIMIT 1 OFFSET 0; | 0.16ms | 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" = 36) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 41) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.87ms | 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.38ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.42ms | 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.29ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 4.81ms | 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; | 10.05ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 76) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 31) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 54) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 117) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) 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.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 41) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 101) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 158) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 4) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 120) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0; | 0.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 42) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 85) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) 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.15ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 28) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 29) LIMIT 1 OFFSET 0; | 0.16ms |
|
