perf: query search results directly

[st3iny]

For #10668 Ref https://github.com/nextcloud/mail/issues/10723#issuecomment-2684836564

Get rid of one SQL query for every call to MessagesController::index() (and other consumers of IMailSearch::findMessages()).

Query the search results (messages) directly instead of querying their ids first by the search filter and then doing another query for the actual messages by their ids.

[github-actions[bot]]

Hello there, Thank you so much for taking the time and effort to create a pull request to our Nextcloud project.

We hope that the review process is going smooth and is helpful for you. We want to ensure your pull request is reviewed to your satisfaction. If you have a moment, our community management team would very much appreciate your feedback on your experience with this PR review process.

Your feedback is valuable to us as we continuously strive to improve our community developer experience. Please take a moment to complete our short survey by clicking on the following link: https://cloud.nextcloud.com/apps/forms/s/i9Ago4EQRZ7TWxjfmeEpPkf6

Thank you for contributing to Nextcloud and we hope to hear from you soon!

(If you believe you should not receive this message, you can add yourself to the blocklist.)