IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:48; Query_1: SELECT DATE(ADDTIME(MIN(gd.Time),'0 2: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 >= '2025-02-09 22:00:00' AND gd.time < '2025-02-13 21:59:59' AND gd.DeviceLoginName IN ('862531041072357','356078116299468','352353086184048','3044') AND gd.speed > 0 GROUP BY `month`, `day`, DeviceLoginName IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:48; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:03:54' AND DeviceLoginName ='3044' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:51; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 07:50:39' AND DeviceLoginName ='352353086184048' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:52; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:16:02' AND DeviceLoginName ='356078116299468' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:52; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:22:49' AND DeviceLoginName ='862531041072357' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:52; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 09:00:31' AND DeviceLoginName ='3044' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:52; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:10:02' AND DeviceLoginName ='352353086184048' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:52; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:48:13' AND DeviceLoginName ='356078116299468' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:52; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:39:35' AND DeviceLoginName ='862531041072357' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:53; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:56:38' AND DeviceLoginName ='3044' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:53; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:31:14' AND DeviceLoginName ='862531041072357' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:53; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-13 01:49:45' AND DeviceLoginName ='3044' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:53; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-13 05:25:52' AND DeviceLoginName ='356078116299468' IP: - 77.52.176.202 - 165.225.200.95; TIME:2025-02-13 09:09:53; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-13 05:21:00' AND DeviceLoginName ='862531041072357' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:26; Query_1: SELECT DATE(ADDTIME(MIN(gd.Time),'0 2: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 >= '2025-02-09 22:00:00' AND gd.time < '2025-02-10 21:59:59' AND gd.DeviceLoginName IN ('5046','3166','2501','2658','3184','2516','2556','3090','3133','3079','2679','2837','3039','3059','3161','5117','4825','2461','2550','3023','3056','3075','3089','3210','2736','9380','2473','355234055232645','355234055221853','355234055232561','355234055581363','354836080167561','354836080120826','358021081803706','352353083458635','352353083476850','352353083473493','352353083499175','352353083291549','352353084175477','352353084314407','352353086131601','352353085630363','352353086184659','352353086185144','352353086186647','356078111301566','356078111279986','356078111472854','356078116278207','356078118140413') AND gd.speed > 0 GROUP BY `month`, `day`, DeviceLoginName IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-09 22:15:33' AND DeviceLoginName ='2550' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-09 22:52:47' AND DeviceLoginName ='2736' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-09 23:55:31' AND DeviceLoginName ='3089' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-09 23:19:20' AND DeviceLoginName ='3161' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:16:39' AND DeviceLoginName ='2473' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:39:26' AND DeviceLoginName ='2501' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 09:41:28' AND DeviceLoginName ='2516' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 00:00:14' AND DeviceLoginName ='2550' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:07:44' AND DeviceLoginName ='2556' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:44:59' AND DeviceLoginName ='2736' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 02:52:14' AND DeviceLoginName ='3023' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:28; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 03:26:16' AND DeviceLoginName ='3039' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:53:10' AND DeviceLoginName ='3056' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:13:23' AND DeviceLoginName ='3059' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:32:19' AND DeviceLoginName ='3079' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:02:45' AND DeviceLoginName ='3089' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:14:08' AND DeviceLoginName ='3133' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:14:18' AND DeviceLoginName ='3161' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:57:14' AND DeviceLoginName ='3210' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 04:32:11' AND DeviceLoginName ='352353083458635' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:29; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:56:33' AND DeviceLoginName ='352353083473493' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:30; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:51:29' AND DeviceLoginName ='352353083499175' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:30; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 07:05:33' AND DeviceLoginName ='352353084175477' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:30; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 10:05:52' AND DeviceLoginName ='352353084314407' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:30; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:45:33' AND DeviceLoginName ='352353085630363' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:30; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 10:02:46' AND DeviceLoginName ='352353086131601' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:30; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:58:51' AND DeviceLoginName ='352353086185144' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 07:16:42' AND DeviceLoginName ='352353086186647' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:38:12' AND DeviceLoginName ='354836080120826' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 09:50:04' AND DeviceLoginName ='355234055221853' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:08:27' AND DeviceLoginName ='355234055232561' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:43:48' AND DeviceLoginName ='355234055232645' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:30:48' AND DeviceLoginName ='355234055581363' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:51:18' AND DeviceLoginName ='356078111301566' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 09:14:39' AND DeviceLoginName ='356078111472854' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 06:23:17' AND DeviceLoginName ='356078116278207' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:31; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:49:05' AND DeviceLoginName ='356078118140413' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:32; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 15:11:10' AND DeviceLoginName ='358021081803706' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:32; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:54:07' AND DeviceLoginName ='4825' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 09:10:32; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 05:41:17' AND DeviceLoginName ='5046' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:21; Query_1: SELECT DATE(ADDTIME(MIN(gd.Time),'0 2: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 >= '2025-02-10 22:00:00' AND gd.time < '2025-02-11 21:59:59' AND gd.DeviceLoginName IN ('5046','3166','2501','2658','3184','2516','2556','3090','3133','3079','2679','2837','3039','3059','3161','5117','4825','2461','2550','3023','3056','3075','3089','3210','2736','9380','2473','355234055232645','355234055221853','355234055232561','355234055581363','354836080167561','354836080120826','358021081803706','352353083458635','352353083476850','352353083473493','352353083499175','352353083291549','352353084175477','352353084314407','352353086131601','352353085630363','352353086184659','352353086185144','352353086186647','356078111301566','356078111279986','356078111472854','356078116278207','356078118140413') AND gd.speed > 0 GROUP BY `month`, `day`, DeviceLoginName IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:22; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-10 22:17:35' AND DeviceLoginName ='2556' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:22; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:15:37' AND DeviceLoginName ='2473' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:22; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:17:48' AND DeviceLoginName ='2501' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:22; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:28:51' AND DeviceLoginName ='2516' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:41:16' AND DeviceLoginName ='2550' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:15:50' AND DeviceLoginName ='2556' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 02:20:43' AND DeviceLoginName ='2736' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:27:59' AND DeviceLoginName ='3023' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:27:25' AND DeviceLoginName ='3039' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:54:45' AND DeviceLoginName ='3056' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:45:28' AND DeviceLoginName ='3059' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:22:16' AND DeviceLoginName ='3079' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:44:58' AND DeviceLoginName ='3089' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:23; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:47:52' AND DeviceLoginName ='3161' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 20:38:24' AND DeviceLoginName ='3166' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:51:07' AND DeviceLoginName ='3210' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 04:19:42' AND DeviceLoginName ='352353083458635' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:19:58' AND DeviceLoginName ='352353083473493' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:16:15' AND DeviceLoginName ='352353083499175' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 07:38:32' AND DeviceLoginName ='352353084175477' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 09:58:36' AND DeviceLoginName ='352353084314407' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:24; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:30:13' AND DeviceLoginName ='352353085630363' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:11:34' AND DeviceLoginName ='352353086131601' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:34:25' AND DeviceLoginName ='352353086184659' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:47:13' AND DeviceLoginName ='352353086185144' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:28:05' AND DeviceLoginName ='352353086186647' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 15:25:55' AND DeviceLoginName ='354836080120826' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 07:56:01' AND DeviceLoginName ='355234055221853' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:41:46' AND DeviceLoginName ='355234055232645' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:29:33' AND DeviceLoginName ='355234055581363' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:25; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:45:34' AND DeviceLoginName ='356078111301566' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:26; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:05:47' AND DeviceLoginName ='356078111472854' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:26; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 06:32:42' AND DeviceLoginName ='356078116278207' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:26; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:44:31' AND DeviceLoginName ='356078118140413' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:28:01' AND DeviceLoginName ='358021081803706' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 10:05:50' AND DeviceLoginName ='4825' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 05:43:53' AND DeviceLoginName ='5046' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:08:27; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 02:55:34' AND DeviceLoginName ='9380' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:11; Query_1: SELECT DATE(ADDTIME(MIN(gd.Time),'0 2: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 >= '2025-02-11 22:00:00' AND gd.time < '2025-02-12 21:59:59' AND gd.DeviceLoginName IN ('5046','3166','2501','2658','3184','2516','2556','3090','3133','3079','2679','2837','3039','3059','3161','5117','4825','2461','2550','3023','3056','3075','3089','3210','2736','9380','2473','355234055232645','355234055221853','355234055232561','355234055581363','354836080167561','354836080120826','358021081803706','352353083458635','352353083476850','352353083473493','352353083499175','352353083291549','352353084175477','352353084314407','352353086131601','352353085630363','352353086184659','352353086185144','352353086186647','356078111301566','356078111279986','356078111472854','356078116278207','356078118140413') AND gd.speed > 0 GROUP BY `month`, `day`, DeviceLoginName IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:11; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 22:13:18' AND DeviceLoginName ='3039' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 23:36:29' AND DeviceLoginName ='3210' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-11 22:00:10' AND DeviceLoginName ='9380' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:11:05' AND DeviceLoginName ='2473' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:24:46' AND DeviceLoginName ='2501' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:31:36' AND DeviceLoginName ='2516' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 00:56:33' AND DeviceLoginName ='2550' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 02:52:11' AND DeviceLoginName ='2556' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:12; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 15:20:17' AND DeviceLoginName ='2736' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:00:47' AND DeviceLoginName ='2837' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:23:28' AND DeviceLoginName ='3023' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:08:26' AND DeviceLoginName ='3039' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:49:55' AND DeviceLoginName ='3056' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:38:09' AND DeviceLoginName ='3059' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 08:19:30' AND DeviceLoginName ='3079' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:29:55' AND DeviceLoginName ='3089' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:36:37' AND DeviceLoginName ='3161' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:13; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 01:19:50' AND DeviceLoginName ='3166' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:52:57' AND DeviceLoginName ='3210' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 04:25:19' AND DeviceLoginName ='352353083458635' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:13:35' AND DeviceLoginName ='352353083473493' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:38:15' AND DeviceLoginName ='352353083499175' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 09:07:11' AND DeviceLoginName ='352353084175477' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:39:34' AND DeviceLoginName ='352353085630363' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:08:31' AND DeviceLoginName ='352353086131601' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:14; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 07:45:22' AND DeviceLoginName ='352353086184659' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:54:21' AND DeviceLoginName ='352353086185144' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:08:32' AND DeviceLoginName ='352353086186647' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 09:28:24' AND DeviceLoginName ='354836080120826' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 09:54:04' AND DeviceLoginName ='355234055221853' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 12:26:44' AND DeviceLoginName ='355234055232561' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:47:26' AND DeviceLoginName ='355234055232645' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:15; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:38:36' AND DeviceLoginName ='355234055581363' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:53:38' AND DeviceLoginName ='356078111301566' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:31:50' AND DeviceLoginName ='356078111472854' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 06:41:19' AND DeviceLoginName ='356078116278207' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:24:53' AND DeviceLoginName ='356078118140413' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:25:32' AND DeviceLoginName ='358021081803706' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 07:35:16' AND DeviceLoginName ='4825' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 05:46:18' AND DeviceLoginName ='5046' IP: - 31.128.68.206 - 147.161.248.97; TIME:2025-02-13 10:40:16; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2025-02-12 02:37:01' AND DeviceLoginName ='9380'