SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.37ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.29ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.23ms |
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.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 34) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) 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" = 36) LIMIT 1 OFFSET 0; | 0.14ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 109) LIMIT 1 OFFSET 0; | 0.15ms |
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.14ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 193) LIMIT 1 OFFSET 0; | 0.16ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 54) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 126) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 200) LIMIT 1 OFFSET 0; | 0.17ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 44) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 44) LIMIT 1 OFFSET 0; | 0.16ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 10) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.33ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0; | 0.16ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 66) 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" = 100) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.56ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.27ms |
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.33ms |
SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 8.40ms |
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; | 11.45ms |
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.34ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0; | 0.28ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0; | 0.22ms |
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.31ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.21ms |
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.19ms |
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" = 60) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 34) 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.21ms |
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.20ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 109) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 193) LIMIT 1 OFFSET 0; | 0.19ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 54) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 126) LIMIT 1 OFFSET 0; | 0.17ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 200) LIMIT 1 OFFSET 0; | 0.40ms |
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.16ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 10) LIMIT 1 OFFSET 0; | 0.34ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.14ms |
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.79ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.48ms |
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.64ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.26ms |
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.52ms |
SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 15.40ms |
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.72ms |
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.23ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.42ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) 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.18ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0; | 0.21ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0; | 0.38ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 121) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.37ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.20ms |
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.21ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 34) LIMIT 1 OFFSET 0; | 0.36ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) 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.15ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0; | 0.35ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 109) LIMIT 1 OFFSET 0; | 0.17ms |
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" = 193) LIMIT 1 OFFSET 0; | 0.18ms |
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" = 126) 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"; | 6.76ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.85ms |
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 2.18ms |
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.68ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.44ms |
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.30ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','2026-07-28 07:42:41','https://chemreg.net/regulations/2-122_gmsds.pdf')RETURNING "id"; | 1.11ms |
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.57ms |
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.58ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES (NULL,'Mozilla/5.0 (Linux; Android 11; V2055A) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Mobile Safari/537.36','2026-07-28 10:49:51',NULL)RETURNING "id"; | 8.43ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES (NULL,'Mozilla/5.0 (Linux; Android 11; V2055A) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Mobile Safari/537.36','2026-07-28 10:49:52',NULL)RETURNING "id"; | 0.49ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (Linux; Android 11; V2055A) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Mobile Safari/537.36','2026-07-28 10:49:52','https://chemreg.net/regulations/gmsds-feb20-703.pdf')RETURNING "id"; | 6.99ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (Linux; Android 11; V2055A) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Mobile Safari/537.36','2026-07-28 10:49:54','https://chemreg.net/regulations/2-122_gmsds.pdf')RETURNING "id"; | 0.43ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES (NULL,'Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','2026-07-28 15:52:41',NULL)RETURNING "id"; | 0.25ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES (NULL,'Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','2026-07-28 15:52:42',NULL)RETURNING "id"; | 0.64ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','2026-07-28 15:52:43','https://chemreg.net/regulations/gmsds-july19-28.pdf')RETURNING "id"; | 0.51ms |
INSERT INTO "search_hit"("search_uri","user_agent","hit_timestamp","hit_uri") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)','2026-07-28 18:52:20','https://chemreg.net/regulations/2-123_gmsds.pdf')RETURNING "id"; | 0.59ms |