IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:06; Query_1: SELECT DATE(ADDTIME(MIN(gd.Time),'0 3:0:0')), MIN(gd.time) AS day_start_time, MAX(gd.time) AS day_finish_time, DeviceLoginName,DAYOFMONTH(gd.time) AS `day`, MONTHNAME(gd.time) AS `month` FROM `tms_gpsdata_fixed` gd WHERE gd.time >= '2024-05-26 21:00:00' AND gd.time < '2024-06-03 20:59:59' AND gd.DeviceLoginName IN ('9376') AND gd.speed > 0 GROUP BY `month`, `day`, DeviceLoginName
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:07; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-06-01 11:13:46' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:08; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-06-02 20:00:09' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-06-03 06:21:54' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-05-26 21:11:12' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-05-27 02:26:11' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-05-28 00:03:15' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-05-29 02:21:57' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-05-30 04:51:29' AND DeviceLoginName ='9376'
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-06-03 09:22:09; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-05-31 00:01:19' AND DeviceLoginName ='9376'