Remove unnecessary joins for list node and task execution entities in flyteadmin db queries #5281

Job	Run time
unpack-envvars	1s
flyteadmin integration tests image / build_docker	4m 54s
Build Images / Build & Push Image (flyteadmin) / Push to Github Registry	5m 29s
Build Images / Build & Push Image (datacatalog) / Push to Github Registry	4m 9s
Build Images / Build & Push Image (flytecopilot) / Push to Github Registry	4m 7s
Build Images / Build & Push Image (flytepropeller) / Push to Github Registry	5m 38s
Build Images / Build & Push Image (flytescheduler) / Push to Github Registry	5m 44s
Dry Run Goreleaser	7m 17s
Test Getting started	5m 40s
Lint (datacatalog) / Run Lint	2m 20s
Lint (flyteadmin) / Run Lint	3m 0s
Lint (flytectl) / Run Lint	2m 31s
Lint (flyteidl) / Run Lint	1m 49s
Lint (flyteplugins) / Run Lint	2m 55s
Lint (flytestdlib) / Run Lint	2m 28s
Lint (flytepropeller) / Run Lint	2m 59s
Check Go Generate (flyteadmin) / Go Generate	2m 7s
Check Go Generate (datacatalog) / Go Generate	1m 31s
Check Go Generate (flytecopilot) / Go Generate	1m 21s
Check Go Generate (flytectl) / Go Generate	1m 56s
Check Go Generate (flytepropeller) / Go Generate	2m 7s
Unit Tests (datacatalog) / Run Unit Test	2m 55s
Unit Tests (flyteadmin) / Run Unit Test	4m 26s
Unit Tests (flytecopilot) / Run Unit Test	2m 39s
Unit Tests (flytectl) / Run Unit Test	3m 26s
Unit Tests (flyteplugins) / Run Unit Test	3m 58s
Unit Tests (flytepropeller) / Run Unit Test	4m 15s
Unit Tests (flytestdlib) / Run Unit Test	3m 36s
Integration Test (flyteadmin) / Integration tests	5m 55s
	1h 41m 13s

Provide feedback