select * from data where sn='222222' and pq='watt' order by id desc limit 4
id
sn
ts
pq
value
systemts
84031903
222222
watt
0
1785931469
Wed 05 08 2026 14:04:29
84031900
222222
watt
0
1785931453
Wed 05 08 2026 14:04:13
84031899
222222
watt
296
1785931264
Wed 05 08 2026 14:01:04
Sat Aug 15 21:47:07 2026 by walley