SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.48ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 254.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; | 15.02ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.92ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 66) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 18) LIMIT 1 OFFSET 0; | 0.19ms | 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.37ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 42) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0; | 0.19ms | 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.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 51) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 42) LIMIT 1 OFFSET 0; | 0.20ms | 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" = 26) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 188) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 130) LIMIT 1 OFFSET 0; | 0.44ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0; | 0.38ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.39ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 10) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.67ms | 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.46ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 18.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; | 18.71ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.33ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 66) LIMIT 1 OFFSET 0; | 0.26ms | 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" = 52) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 100) LIMIT 1 OFFSET 0; | 0.26ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.48ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 18) 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.25ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0; | 0.26ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 42) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 51) LIMIT 1 OFFSET 0; | 0.27ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 42) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 26) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 188) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 130) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 7.77ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.04ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 1.53ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 4.12ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.89ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 1.53ms | INSERT INTO "regulation"("filehash_count","filehash_dupe","translation_status","file_pages","source_title","source_url","pdf","private","source_topic","zero_length_pdf","source_local_title","review_state","source_subtopic","accessed_date","source_country","text_bytes","source_id","file_languages","notes","page_count","filehash","normalise_check","source_year","file_uid","normalised_filename") VALUES (NULL,'F',NULL,NULL,'Resolution 501/2025: Technical Regulations On The Degree Of Soil Contamination (Georgian)','https://matsne.gov.ge/ka/document/view/6666330?publication=0https://matsne.gov.ge/ka/document/download/6666330/0/1','regulation.pdf.808e95c661143372.R01TRFMtTWFyY2ggMjYtODIucGRm.pdf','F',6,'F','საქართველოს მთავრობის დადგენილება №501 2025 წლის 10 ნოემბერი',NULL,44,'2026-07-23',44,NULL,'GMSDS-March 26-82','||',NULL,NULL,NULL,NULL,'2025',NULL,NULL)RETURNING "id"; | 8.27ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 8.88ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.54ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 1.88ms | 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.23ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.73ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 20.52ms | 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; | 14.99ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.90ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.37ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 126) LIMIT 1 OFFSET 0; | 0.23ms | 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" = 54) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.18ms | 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.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 200) LIMIT 1 OFFSET 0; | 0.38ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 44) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 44) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 10) LIMIT 1 OFFSET 0; | 0.37ms | 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" = 14) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 66) LIMIT 1 OFFSET 0; | 0.41ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 100) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0; | 0.25ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 18) 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.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 42) 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.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 51) LIMIT 1 OFFSET 0; | 0.21ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES (NULL,NULL,'2026-07-23 08:05:51','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36')RETURNING "id"; | 0.47ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES (NULL,NULL,'2026-07-23 08:05:51','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36')RETURNING "id"; | 0.43ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES ('https://chemreg.net/regulations/14-22_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-07-23 08:05:52','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36')RETURNING "id"; | 0.44ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES ('https://chemreg.net/regulations/39-1_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-07-23 08:05:53','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36')RETURNING "id"; | 0.58ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES (NULL,NULL,'2026-07-23 19:54:59','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)')RETURNING "id"; | 8.05ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES (NULL,NULL,'2026-07-23 19:54:59','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)')RETURNING "id"; | 0.65ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES ('https://chemreg.net/regulations/17-11_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-07-23 19:55:01','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)')RETURNING "id"; | 0.59ms |
|
