Fix SQL performance issues caused by repeated subquery fetches #12494

Job	Run time
Import Global Environment / init-environment	6s
Build E2E Image	8m 9s
E2E - Agent with MySQL (proxy, tracing, jaeger)	6m 50s
E2E - Agent with MySQL (proxy, tracing, zipkin)	7m 5s
E2E - Agent with MySQL (proxy, metrics, prometheus)	7m 7s
E2E - Agent with MySQL (proxy, logging, file)	6m 53s
E2E - Agent with MySQL (jdbc, logging, file)	6m 31s
E2E - Agent with MySQL (jdbc, metrics, prometheus)	6m 48s
E2E - Agent with MySQL (jdbc, tracing, jaeger)	6m 59s
E2E - Agent with MySQL (jdbc, tracing, zipkin)	6m 59s
	1h 3m 27s

Provide feedback