Bug: Slow response when getting Resource details

[Bill2015]

Is there an existing issue for this?

• have searched the existing issues

Description

Getting Resource Details may have long response times.
Because currently qurery command like below

SELECT 
  *,
  (SELECT 
      *,
      (->belong->subject.id)[0] AS belong_subject,
      (->belong->subject.name)[0] AS subject_name
      FROM tag 
      WHERE ->tagging->resource.id CONTAINS $parent.id
) AS tags
FROM resource
WHERE id == $id"

We use subquery to get subject data.
There may be have better way, but currently, I can't figure out

Also, I don't have enough data can confirm this query is slow when large data.

Possible Solution

None