在更改查询的比较值时，高度绝望的执行时间

I have a problem with execution times on a query that is baffling me. I know a few ways to solve the problem and get better and acceptable execution times but still don't have a clue on WHY the problem occurs.I have a problem with execution times on a quer