[Improvement][project] projects-management page query interface timeout

[cooldwind]

Search before asking

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

Description

add index:
ALTER TABLE t_ds_process_definition ADD INDEX idx_project_code(project_code),
ADD INDEX idx_version (version);
ALTER TABLE t_ds_process_definition_log ADD INDEX idx_code(code),
ADD INDEX idx_version(version),
ADD INDEX idx_project_code(project_code);
ALTER TABLE t_ds_process_instance ADD INDEX idx_process_definition_version(process_definition_version),
ADD INDEX idx_state(state);

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

[cooldwind]

Hope to adopt.

[freeradius-xx]

Thank you, index of t_ds_process_instance helps me!
ALTER TABLE t_ds_process_instance ADD INDEX idx_process_definition_version(process_definition_version),
ADD INDEX idx_state(state);

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.