• UPDATE:

    We removed a Count(*) function in the query, and the performance improved significantly.

    Thanks to everyone's suggestion.