IP: - 188.163.35.113 - 147.161.136.109; TIME:2024-08-30 13:35:07; query   SELECT `DeviceLoginName`,`speed`,DATE(ADDTIME(`time`,'0 3:0:0')), TIME(ADDTIME(`time`,'0 3:0:0')),`latitude`,`longitude` FROM `tms_gpsdata_fixed` WHERE `time`>='2024-07-31 21:00:00' AND `time`<='2024-08-30 20:59:59' AND `speed` > 110 AND DeviceLoginName IN ('5080') ORDER BY `time` ASC