IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:57; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2025-01-20 00:00:00') AND `date` <= DATE('2025-02-16 23:59:59') AND `client_id`=53;
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:57; 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 >= '2025-01-19 22:00:00' AND gp.time < '2025-02-16 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.201.129; TIME:2025-02-27 13:15:58; imei : 352353084149035 - 352353084149035 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; in_array 2: 352353084149035 - 352353084149035 - 2025-02-01 10:37:03 - 18.04 | 2025-02-01 00:00:00 - 2025-02-01 23:59:59
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; in_array 2: 352353084149035 - 352353084149035 - 2025-02-01 10:37:03 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; imei : 352353084149035 - 352353084149035 - 1
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; in_array 2: 352353084149035 - 352353084149035 - 2025-02-02 10:55:08 - 30.03 | 2025-02-02 00:00:00 - 2025-02-02 23:59:59
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; in_array 2: 352353084149035 - 352353084149035 - 2025-02-02 10:55:08 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; imei : 352353084149035 - 352353084149035 - 2
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:58; imei : 352353084149035 - 352353084149035 - 3
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; imei : 352353084149035 - 352353084149035 - 4
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; imei : 352353084149035 - 352353084149035 - 5
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; imei : 352353084149035 - 352353084149035 - 6
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; imei : 352353084149035 - 352353084149035 - 7
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; in_array 2: 352353084149035 - 352353084149035 - 2025-02-08 08:38:00 - 20.22 | 2025-02-08 00:00:00 - 2025-02-08 23:59:59
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; in_array 2: 352353084149035 - 352353084149035 - 2025-02-08 08:38:00 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; imei : 352353084149035 - 352353084149035 - 8
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; in_array 2: 352353084149035 - 352353084149035 - 2025-02-09 16:11:37 - 41.04 | 2025-02-09 00:00:00 - 2025-02-09 23:59:59
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; in_array 2: 352353084149035 - 352353084149035 - 2025-02-09 16:11:37 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:15:59; imei : 352353084149035 - 352353084149035 - 9
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:00; imei : 352353084149035 - 352353084149035 - 10
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:00; imei : 352353084149035 - 352353084149035 - 11
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:00; imei : 352353084149035 - 352353084149035 - 12
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:00; imei : 352353084149035 - 352353084149035 - 13
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 14
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; in_array 2: 352353084149035 - 352353084149035 - 2025-02-15 10:01:12 - 59.59 | 2025-02-15 00:00:00 - 2025-02-15 23:59:59
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; in_array 2: 352353084149035 - 352353084149035 - 2025-02-15 10:01:12 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 15
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; in_array 2: 352353084149035 - 352353084149035 - 2025-02-16 15:21:13 - 47.54 | 2025-02-16 00:00:00 - 2025-02-16 23:59:59
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; in_array 2: 352353084149035 - 352353084149035 - 2025-02-16 15:21:13 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 16
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 17
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 18
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 19
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:01; imei : 352353084149035 - 352353084149035 - 20
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:02; imei : 352353084149035 - 352353084149035 - 21
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:02; 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.201.129; TIME:2025-02-27 13:16:02; in_array 2: 352353084149035 - 352353084149035 - 2025-01-25 08:52:41 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:02; imei : 352353084149035 - 352353084149035 - 22
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:02; 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.201.129; TIME:2025-02-27 13:16:02; in_array 2: 352353084149035 - 352353084149035 - 2025-01-26 11:57:54 - 0
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:02; imei : 352353084149035 - 352353084149035 - 23
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:03; imei : 352353084149035 - 352353084149035 - 24
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:03; imei : 352353084149035 - 352353084149035 - 25
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:03; imei : 352353084149035 - 352353084149035 - 26
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:03; imei : 352353084149035 - 352353084149035 - 27
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:03; AFTER mainQuery: 
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:04; in_array after: 352353084149035 - 2025-01-31 08:05:49 - 687.35
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:04; while 352353084149035: MileageFromTo=2618.78 Mileage=2615.98 MileageR=687.35
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:04; while 352353084149035: MileageWork=1928.63 MileageNotWork=2.8000000000006
IP: - 77.52.176.202 - 165.225.201.129; TIME:2025-02-27 13:16:04; while 352353084149035: Total=2618.78