Lately we are seeing some queries in mysql(master) logs but no idea why they are shown there:
Queries are `select/update table where id = <some integer>`.

---

1. There is index on id
2. table size is below 100 000
3. Rows scanned are in hundreds (sometimes < 100)
4. Server is running on extremely good hardware
5. there are no joins involved
6. We do not see any heavy activity running on database at that time
7. tables are innodb
8. the same queries generally don’t even take 50ms, but sometimes all the execution of these queries take about 4-8 seconds

One observation was all the similar "non-slow-but-weirdly-taking-high-time" queries take almost the same amount of time for some duration . I.e. queries like stated in the top will all take about 4.35 seconds with variation of 0.05 seconds.

Does the network latency/packets-drop affect mysql query timing?