select * from data where sn='1' and pq='ip' order by id desc limit 4
idsntspqvaluesystemts
27168272 1 ip 192.168.2.148 1571485046 Sat 19 10 2019 13:37:26
27168260 1 ip 192.168.2.148 1571485026 Sat 19 10 2019 13:37:06
27168255 1 ip 192.168.2.148 1571485025 Sat 19 10 2019 13:37:05
27168248 1 ip 192.168.2.148 1571485006 Sat 19 10 2019 13:36:46

Mon Oct 21 04:05:37 2019 by walley