IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:39; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2025-02-01 00:00:00') AND `date` <= DATE('2025-02-28 23:59:59') AND `client_id`=53;
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:39; SELECT mainQuery: SELECT
gp.`DeviceLoginName`,ADDTIME(MIN(gp.time),'0 3:0:0') AS day_start_time, ADDTIME(MAX(gp.time),'0 3:0:0') AS day_finish_time, DAYOFMONTH(ADDTIME(gp.time,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(gp.time,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` gp
WHERE (gp.time >= '2025-01-31 21:00:00' AND gp.time < '2025-02-28 20:59:59')
AND TIME(gp.time) >= '03:00:00' AND TIME(gp.time) <= '17:59:59'
AND gp.DeviceLoginName IN ('352353085654322')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:39; imei : 352353085654322 - 352353085654322 - 0
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:39; in_array 2: 352353085654322 - 352353085654322 - 2025-02-02 13:54:15 - 15.63 | 2025-02-02 00:00:00 - 2025-02-02 23:59:59
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:39; in_array 2: 352353085654322 - 352353085654322 - 2025-02-02 13:54:15 - 0
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:39; imei : 352353085654322 - 352353085654322 - 1
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:40; imei : 352353085654322 - 352353085654322 - 2
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:40; imei : 352353085654322 - 352353085654322 - 3
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:40; imei : 352353085654322 - 352353085654322 - 4
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; imei : 352353085654322 - 352353085654322 - 5
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; imei : 352353085654322 - 352353085654322 - 6
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; in_array 2: 352353085654322 - 352353085654322 - 2025-02-08 12:06:41 - 31.89 | 2025-02-08 00:00:00 - 2025-02-08 23:59:59
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; in_array 2: 352353085654322 - 352353085654322 - 2025-02-08 12:06:41 - 0
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; imei : 352353085654322 - 352353085654322 - 7
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; imei : 352353085654322 - 352353085654322 - 8
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; imei : 352353085654322 - 352353085654322 - 9
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:41; imei : 352353085654322 - 352353085654322 - 10
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; imei : 352353085654322 - 352353085654322 - 11
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; imei : 352353085654322 - 352353085654322 - 12
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; in_array 2: 352353085654322 - 352353085654322 - 2025-02-15 10:34:51 - 42.42 | 2025-02-15 00:00:00 - 2025-02-15 23:59:59
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; in_array 2: 352353085654322 - 352353085654322 - 2025-02-15 10:34:51 - 0
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; imei : 352353085654322 - 352353085654322 - 13
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; in_array 2: 352353085654322 - 352353085654322 - 2025-02-16 13:31:27 - 26.26 | 2025-02-16 00:00:00 - 2025-02-16 23:59:59
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; in_array 2: 352353085654322 - 352353085654322 - 2025-02-16 13:31:27 - 0
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:42; imei : 352353085654322 - 352353085654322 - 14
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 15
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 16
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 17
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 18
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 19
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; in_array 2: 352353085654322 - 352353085654322 - 2025-02-22 11:44:07 - 12.06 | 2025-02-22 00:00:00 - 2025-02-22 23:59:59
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; in_array 2: 352353085654322 - 352353085654322 - 2025-02-22 11:44:07 - 0
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 20
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 21
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:43; imei : 352353085654322 - 352353085654322 - 22
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; imei : 352353085654322 - 352353085654322 - 23
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; imei : 352353085654322 - 352353085654322 - 24
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; AFTER mainQuery: 
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; in_array after: 352353085654322 - 2025-02-28 09:00:59 - 132.77
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; while 352353085654322: MileageFromTo=1806.44 Mileage=1594.98 MileageR=132.77
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; while 352353085654322: MileageWork=1462.21 MileageNotWork=211.46
IP: - 77.52.176.202 - 165.225.206.82; TIME:2025-03-31 12:55:44; while 352353085654322: Total=1806.44