SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.37ms | 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.27ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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"; | 0.60ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/30-73_gmsds.pdf','2025-11-20 01:46:38')RETURNING "id"; | 8.73ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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',NULL,NULL,'2025-11-20 06:46:27')RETURNING "id"; | 1.82ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/gmsds-feb20-703.pdf','2025-11-20 06:46:28')RETURNING "id"; | 0.57ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/2-11_gmsds.pdf','2025-11-20 06:46:30')RETURNING "id"; | 0.74ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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',NULL,NULL,'2025-11-20 06:47:44')RETURNING "id"; | 0.72ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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',NULL,NULL,'2025-11-20 06:47:45')RETURNING "id"; | 0.39ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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',NULL,NULL,'2025-11-20 06:47:45')RETURNING "id"; | 0.42ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/30-73_gmsds.pdf','2025-11-20 06:47:46')RETURNING "id"; | 0.37ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/17-11_gmsds.pdf','2025-11-20 06:47:46')RETURNING "id"; | 0.30ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/14-22_gmsds.pdf','2025-11-20 06:50:02')RETURNING "id"; | 4.93ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_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/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','https://chemreg.net/regulations/2-123_gmsds.pdf','2025-11-20 06:50:02')RETURNING "id"; | 0.97ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 4.15ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.27ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 2.32ms | INSERT INTO "regulation"("private","filehash_count","translation_status","source_title","normalised_filename","source_local_title","source_year","source_country","review_state","source_subtopic","source_url","file_uid","notes","normalise_check","zero_length_pdf","source_id","accessed_date","file_pages","filehash","page_count","file_languages","filehash_dupe","source_topic","pdf","text_bytes") VALUES ('F',NULL,NULL,'Management Regulations For Hydrochlorofluorocarbons (Consolidated 2025-10-13)(Chinese)',NULL,'氟氯烴管理辦法','2025',109,NULL,1,'https://www.ljer.com.tw/news_detail/635.htm',NULL,NULL,NULL,'F','GMSDS-Oct 25-28','2025-11-20',NULL,NULL,NULL,'||','F',6,'regulation.pdf.83570a51d66bc101.R01TRFMtT2N0IDI1LTI4LnBkZg==.pdf',NULL)RETURNING "id"; | 5.14ms |
|