The query that gets sub-requirements of a requirement is too slow

Loading sub-requirements from requirements can be slow under certain conditions. Some examples where Xray needs to load sub-requirements are:

• Gadget requirement list
• Reindex