[Subtask] Improvment:  Optimize method `getParentEntityIdByNamespace` to reduce the number of accesses to the database

### Describe the subtask

Method `getParentEntityIdByNamespace` wil access database 3 times at most if the name space is a schema, in fact, we can use JOIN to reduce the access times, or it's rather very times-consuming, for detail

<img width="1544" alt="Image" src="https://github.com/user-attachments/assets/401658c6-7b09-4a17-acc8-6cdcd29cf81a" />


### Parent issue

#6560 