[SCR-6] Merge upstream PR #829: Optimize SMART attributes query

[Starosdev]

Summary

Merge the query optimization PR that uses limit() instead of tail() for better InfluxDB performance.

Why

Improves database query performance, especially for installations with many drives or long history.

Upstream PR

AnalogJ#829

Acceptance Criteria

• PR merged cleanly
• Query performance verified
• No regression in data accuracy

---

Linear: SCR-6
Sprint: Sprint 2: Merge Upstream PRs