As a result, this query may be slow if there are a very many records in the changesets_issues table.

When the number of records in the changesets_issues table was about 1 million, it took 2 or 3 seconds to execute this query.Adding INDEX to issue_id improved the performance of this query to a few milliseconds.