Your Dev env cr=1,244 and prod env cr=313,908.
Since your data volume is different how do you expect them to behave in same way.

Now you need to think how to tune the SQL in prod.