Improve issue search performance for recent items
What does this MR do and why?
Improves the query for searching issues in the recent items list. The query is logically the same and we just remove an extra condition that is not needed in this case.
Old query: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/12908/commands/45339
New query: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/12938/commands/45442
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #381141 (closed)
Edited by Heinrich Lee Yu