[perf] Skip expensive PIPELINE_EXPLORER_ROOT_QUERY query if viewing an asset job and prefer asset rendering is enabled

[perf] Skip expensive PIPELINE_EXPLORER_ROOT_QUERY query if viewing an asset job and prefer asset rendering is enabled #8966