[Enhancement]: API response time optimization

[Bidaya0]

Preflight Checklist

• I agree to follow the Code of Conduct that this project adheres to.
• I have searched the issue tracker for an issue that matches the one I want to file, without success.

Problem Description

Mainly caused by the following aspects:

1. Inappropriate SQL query
2. Improper index settings
3. Improper API design

Proposed Solution

• Optimize the query part

Alternatives Considered

No response

Additional Information

No response