[Improvement][API&DAO] Unnecessary Large Text Fields Returned in WorkflowInstanceMapper Queries

[njnu-seafish]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

In WorkflowInstanceMapper.xml , all queries use which returns the complete set of fields, including multiple text/longtext type large fields :

Returning these unnecessary large fields leads to the following performance issues. This problem is particularly pronounced in the workflow instance table, as its data volume continuously expands over time.

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct