IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:24; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2024-12-23 00:00:00') AND `date` <= DATE('2025-01-20 23:59:59') AND `client_id`=53;
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:24; SELECT mainQuery: SELECT
gp.`DeviceLoginName`,ADDTIME(MIN(gp.time),'0 2:0:0') AS day_start_time, ADDTIME(MAX(gp.time),'0 2:0:0') AS day_finish_time, DAYOFMONTH(ADDTIME(gp.time,'0 2:0:0')) AS `day`, MONTHNAME(ADDTIME(gp.time,'0 2:0:0')) AS `month` FROM `tms_gpsdata_fixed` gp
WHERE (gp.time >= '2024-12-22 22:00:00' AND gp.time < '2025-01-20 21:59:59')
AND TIME(gp.time) >= '04:00:00' AND TIME(gp.time) <= '18:59:59'
AND gp.DeviceLoginName IN ('356078111320111','352353084149035')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 1
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 2
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 3
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 4
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 5
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2024-12-28 08:54:15 - 3.73 | 2024-12-28 00:00:00 - 2024-12-28 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2024-12-28 08:54:15 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 6
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2024-12-29 13:25:54 - 47.47 | 2024-12-29 00:00:00 - 2024-12-29 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2024-12-29 13:25:54 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 7
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 8
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 9
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 10
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 11
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 12
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-04 10:25:23 - 100.59 | 2025-01-04 00:00:00 - 2025-01-04 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-04 10:25:23 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 13
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-05 06:00:01 - 49.89 | 2025-01-05 00:00:00 - 2025-01-05 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-05 06:00:01 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 14
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 15
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 16
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 17
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 18
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-11 10:25:35 - 3.3 | 2025-01-11 00:00:00 - 2025-01-11 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-11 10:25:35 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 20
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-12 13:52:23 - 11.05 | 2025-01-12 00:00:00 - 2025-01-12 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-12 13:52:23 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 21
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 22
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 23
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 24
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 25
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 26
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-18 09:12:48 - 202.14 | 2025-01-18 00:00:00 - 2025-01-18 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-18 09:12:48 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 27
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-19 12:51:27 - 17.83 | 2025-01-19 00:00:00 - 2025-01-19 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; in_array 2: 352353084149035 - 352353084149035 - 2025-01-19 12:51:27 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 352353084149035 - 28
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:25; imei : 352353084149035 - 356078111320111 - 29
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; in_array else: 352353084149035 - 2024-12-23 09:44:59 - 445.19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; imei : 356078111320111 - 356078111320111 - 30
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; imei : 356078111320111 - 356078111320111 - 31
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; imei : 356078111320111 - 356078111320111 - 32
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; imei : 356078111320111 - 356078111320111 - 33
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; imei : 356078111320111 - 356078111320111 - 34
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; in_array 2: 356078111320111 - 356078111320111 - 2024-12-28 08:42:45 - 91.67 | 2024-12-28 00:00:00 - 2024-12-28 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; in_array 2: 356078111320111 - 356078111320111 - 2024-12-28 08:42:45 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:26; imei : 356078111320111 - 356078111320111 - 35
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2024-12-29 11:33:22 - 78.09 | 2024-12-29 00:00:00 - 2024-12-29 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2024-12-29 11:33:22 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 36
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 37
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 38
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 39
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 40
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 41
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-04 08:58:40 - 181.91 | 2025-01-04 00:00:00 - 2025-01-04 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-04 08:58:40 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 42
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-05 12:35:46 - 175.27 | 2025-01-05 00:00:00 - 2025-01-05 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-05 12:35:46 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 43
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 44
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 45
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 46
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 47
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 48
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-11 08:37:07 - 568.03 | 2025-01-11 00:00:00 - 2025-01-11 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-11 08:37:07 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 49
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-12 16:21:20 - 4.5 | 2025-01-12 00:00:00 - 2025-01-12 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; in_array 2: 356078111320111 - 356078111320111 - 2025-01-12 16:21:20 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 50
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 51
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 52
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:27; imei : 356078111320111 - 356078111320111 - 53
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; imei : 356078111320111 - 356078111320111 - 54
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; imei : 356078111320111 - 356078111320111 - 55
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; in_array 2: 356078111320111 - 356078111320111 - 2025-01-18 10:17:29 - 67.87 | 2025-01-18 00:00:00 - 2025-01-18 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; in_array 2: 356078111320111 - 356078111320111 - 2025-01-18 10:17:29 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; imei : 356078111320111 - 356078111320111 - 56
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; in_array 2: 356078111320111 - 356078111320111 - 2025-01-19 06:51:19 - 658.21 | 2025-01-19 00:00:00 - 2025-01-19 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; in_array 2: 356078111320111 - 356078111320111 - 2025-01-19 06:51:19 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; imei : 356078111320111 - 356078111320111 - 57
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; AFTER mainQuery: 
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; in_array after: 356078111320111 - 2025-01-20 06:14:21 - 1825.55
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; while 352353084149035: MileageFromTo=1758.99 Mileage=1714.31 MileageR=445.19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; while 352353084149035: MileageWork=1269.12 MileageNotWork=44.68
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; while 352353084149035: Total=1758.99
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; while 356078111320111: MileageFromTo=3960.76 Mileage=3876.13 MileageR=1825.55
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; while 356078111320111: MileageWork=2050.58 MileageNotWork=84.630000000001
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:43:28; while 356078111320111: Total=3960.76
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2025-01-01 00:00:00') AND `date` <= DATE('2025-01-31 23:59:59') AND `client_id`=53;
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; SELECT mainQuery: SELECT
gp.`DeviceLoginName`,ADDTIME(MIN(gp.time),'0 2:0:0') AS day_start_time, ADDTIME(MAX(gp.time),'0 2:0:0') AS day_finish_time, DAYOFMONTH(ADDTIME(gp.time,'0 2:0:0')) AS `day`, MONTHNAME(ADDTIME(gp.time,'0 2:0:0')) AS `month` FROM `tms_gpsdata_fixed` gp
WHERE (gp.time >= '2024-12-31 22:00:00' AND gp.time < '2025-01-31 21:59:59')
AND TIME(gp.time) >= '04:00:00' AND TIME(gp.time) <= '18:59:59'
AND gp.DeviceLoginName IN ('352353084149035')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 1
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 2
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 3
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-04 10:25:23 - 100.59 | 2025-01-04 00:00:00 - 2025-01-04 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-04 10:25:23 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 4
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-05 06:00:01 - 49.89 | 2025-01-05 00:00:00 - 2025-01-05 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-05 06:00:01 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 5
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 6
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 7
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 8
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 9
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 10
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-11 10:25:35 - 3.3 | 2025-01-11 00:00:00 - 2025-01-11 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-11 10:25:35 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 11
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-12 13:52:23 - 11.05 | 2025-01-12 00:00:00 - 2025-01-12 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-12 13:52:23 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 12
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 13
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 14
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 15
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 16
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 17
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-18 09:12:48 - 202.14 | 2025-01-18 00:00:00 - 2025-01-18 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-18 09:12:48 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 18
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-19 12:51:27 - 17.83 | 2025-01-19 00:00:00 - 2025-01-19 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-19 12:51:27 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 20
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 21
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 22
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 23
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; imei : 352353084149035 - 352353084149035 - 24
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:11; in_array 2: 352353084149035 - 352353084149035 - 2025-01-25 08:52:41 - 224.73 | 2025-01-25 00:00:00 - 2025-01-25 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; in_array 2: 352353084149035 - 352353084149035 - 2025-01-25 08:52:41 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; imei : 352353084149035 - 352353084149035 - 25
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; in_array 2: 352353084149035 - 352353084149035 - 2025-01-26 11:57:54 - 243.37 | 2025-01-26 00:00:00 - 2025-01-26 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; in_array 2: 352353084149035 - 352353084149035 - 2025-01-26 11:57:54 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; imei : 352353084149035 - 352353084149035 - 26
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; imei : 352353084149035 - 352353084149035 - 27
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; imei : 352353084149035 - 352353084149035 - 28
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; imei : 352353084149035 - 352353084149035 - 29
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; imei : 352353084149035 - 352353084149035 - 30
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; AFTER mainQuery: 
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; in_array after: 352353084149035 - 2025-01-31 08:05:49 - 862.1
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; while 352353084149035: MileageFromTo=1969.62 Mileage=1925.13 MileageR=862.1
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; while 352353084149035: MileageWork=1063.03 MileageNotWork=44.49
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:49:12; while 352353084149035: Total=1969.62
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2024-12-23 00:00:00') AND `date` <= DATE('2025-01-19 23:59:59') AND `client_id`=53;
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; SELECT mainQuery: SELECT
gp.`DeviceLoginName`,ADDTIME(MIN(gp.time),'0 2:0:0') AS day_start_time, ADDTIME(MAX(gp.time),'0 2:0:0') AS day_finish_time, DAYOFMONTH(ADDTIME(gp.time,'0 2:0:0')) AS `day`, MONTHNAME(ADDTIME(gp.time,'0 2:0:0')) AS `month` FROM `tms_gpsdata_fixed` gp
WHERE (gp.time >= '2024-12-22 22:00:00' AND gp.time < '2025-01-19 21:59:59')
AND TIME(gp.time) >= '04:00:00' AND TIME(gp.time) <= '18:59:59'
AND gp.DeviceLoginName IN ('352353084149035')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 1
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 2
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 3
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 4
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 5
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2024-12-28 08:54:15 - 3.73 | 2024-12-28 00:00:00 - 2024-12-28 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2024-12-28 08:54:15 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 6
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2024-12-29 13:25:54 - 47.47 | 2024-12-29 00:00:00 - 2024-12-29 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2024-12-29 13:25:54 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 7
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 8
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 9
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 10
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 11
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 12
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-04 10:25:23 - 100.59 | 2025-01-04 00:00:00 - 2025-01-04 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-04 10:25:23 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 13
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-05 06:00:01 - 49.89 | 2025-01-05 00:00:00 - 2025-01-05 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-05 06:00:01 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 14
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 15
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 16
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 17
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 18
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-11 10:25:35 - 3.3 | 2025-01-11 00:00:00 - 2025-01-11 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-11 10:25:35 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 20
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-12 13:52:23 - 11.05 | 2025-01-12 00:00:00 - 2025-01-12 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-12 13:52:23 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 21
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 22
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 23
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 24
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 25
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 26
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-18 09:12:48 - 202.14 | 2025-01-18 00:00:00 - 2025-01-18 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-18 09:12:48 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; imei : 352353084149035 - 352353084149035 - 27
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-19 12:51:27 - 17.83 | 2025-01-19 00:00:00 - 2025-01-19 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array 2: 352353084149035 - 352353084149035 - 2025-01-19 12:51:27 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; AFTER mainQuery: 
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; in_array after: 352353084149035 - 2025-01-19 12:51:27 - 445.19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; while 352353084149035: MileageFromTo=1716.29 Mileage=1671.61 MileageR=445.19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; while 352353084149035: MileageWork=1226.42 MileageNotWork=44.68
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:52:46; while 352353084149035: Total=1716.29
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2024-12-23 00:00:00') AND `date` <= DATE('2025-01-19 23:59:59') AND `client_id`=53;
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; SELECT mainQuery: SELECT
gp.`DeviceLoginName`,ADDTIME(MIN(gp.time),'0 2:0:0') AS day_start_time, ADDTIME(MAX(gp.time),'0 2:0:0') AS day_finish_time, DAYOFMONTH(ADDTIME(gp.time,'0 2:0:0')) AS `day`, MONTHNAME(ADDTIME(gp.time,'0 2:0:0')) AS `month` FROM `tms_gpsdata_fixed` gp
WHERE (gp.time >= '2024-12-22 22:00:00' AND gp.time < '2025-01-19 21:59:59')
AND TIME(gp.time) >= '04:00:00' AND TIME(gp.time) <= '18:59:59'
AND gp.DeviceLoginName IN ('356078111320111')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 1
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 2
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 3
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 4
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 5
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; in_array 2: 356078111320111 - 356078111320111 - 2024-12-28 08:42:45 - 91.67 | 2024-12-28 00:00:00 - 2024-12-28 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; in_array 2: 356078111320111 - 356078111320111 - 2024-12-28 08:42:45 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 6
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; in_array 2: 356078111320111 - 356078111320111 - 2024-12-29 11:33:22 - 78.09 | 2024-12-29 00:00:00 - 2024-12-29 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; in_array 2: 356078111320111 - 356078111320111 - 2024-12-29 11:33:22 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 7
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 8
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 9
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 10
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 11
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:17; imei : 356078111320111 - 356078111320111 - 12
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-04 08:58:40 - 181.91 | 2025-01-04 00:00:00 - 2025-01-04 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-04 08:58:40 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 13
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-05 12:35:46 - 175.27 | 2025-01-05 00:00:00 - 2025-01-05 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-05 12:35:46 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 14
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 15
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 16
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 17
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 18
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 19
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-11 08:37:07 - 568.03 | 2025-01-11 00:00:00 - 2025-01-11 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-11 08:37:07 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 20
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-12 16:21:20 - 4.5 | 2025-01-12 00:00:00 - 2025-01-12 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-12 16:21:20 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 21
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 22
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 23
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 24
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 25
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 26
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-18 10:17:29 - 67.87 | 2025-01-18 00:00:00 - 2025-01-18 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-18 10:17:29 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; imei : 356078111320111 - 356078111320111 - 27
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-19 06:51:19 - 658.21 | 2025-01-19 00:00:00 - 2025-01-19 23:59:59
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array 2: 356078111320111 - 356078111320111 - 2025-01-19 06:51:19 - 0
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; AFTER mainQuery: 
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; in_array after: 356078111320111 - 2025-01-19 06:51:19 - 1825.55
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; while 356078111320111: MileageFromTo=3952.03 Mileage=3867.39 MileageR=1825.55
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; while 356078111320111: MileageWork=2041.84 MileageNotWork=84.64
IP: - 77.52.176.202 - 165.225.200.107; TIME:2025-02-11 12:58:18; while 356078111320111: Total=3952.03