SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 8.31ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.82ms |
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 2.19ms |
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.65ms |
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.31ms |
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.51ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.45ms |
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.32ms |
SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 25.33ms |
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; | 19.37ms |
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 1.57ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.19ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 140) 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.17ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0; | 0.19ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) 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.15ms |
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" = 14) 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.16ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 100) 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.15ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 37) LIMIT 1 OFFSET 0; | 0.33ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 81) 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.36ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 203) 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.17ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) 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.20ms |
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0; | 0.18ms |
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 123) LIMIT 1 OFFSET 0; | 0.18ms |