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