Why Your JPA Counter Column Keeps Resetting to Zero

Our denormalized click counters silently reset under load. The culprit was a one-line interaction between @Modifying @Query and @Version. Here's the fix.