IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:26; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2024-05-20 00:00:00') AND `date` <= DATE('2024-06-30 23:59:59') AND `client_id`=53;
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:26; 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 >= '2024-05-19 21:00:00' AND gp.time < '2024-06-30 20:59:59')
AND TIME(gp.time) >= '03:00:00' AND TIME(gp.time) <= '17:59:59'
AND gp.DeviceLoginName IN ('864866053465679')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:26; imei : 864866053465679 - 864866053465679 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:26; in_array 2: 864866053465679 - 864866053465679 - 2024-06-01 14:49:40 - 24.54 | 2024-06-01 00:00:00 - 2024-06-01 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:26; in_array 2: 864866053465679 - 864866053465679 - 2024-06-01 14:49:40 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:26; imei : 864866053465679 - 864866053465679 - 1
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:27; in_array 2: 864866053465679 - 864866053465679 - 2024-06-02 10:54:33 - 29.26 | 2024-06-02 00:00:00 - 2024-06-02 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:27; in_array 2: 864866053465679 - 864866053465679 - 2024-06-02 10:54:33 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:27; imei : 864866053465679 - 864866053465679 - 2
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:28; imei : 864866053465679 - 864866053465679 - 3
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:29; imei : 864866053465679 - 864866053465679 - 4
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:30; imei : 864866053465679 - 864866053465679 - 5
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:32; imei : 864866053465679 - 864866053465679 - 6
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:33; imei : 864866053465679 - 864866053465679 - 7
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:33; in_array 2: 864866053465679 - 864866053465679 - 2024-06-08 07:16:10 - 21.46 | 2024-06-08 00:00:00 - 2024-06-08 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:33; in_array 2: 864866053465679 - 864866053465679 - 2024-06-08 07:16:10 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:33; imei : 864866053465679 - 864866053465679 - 8
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:34; in_array 2: 864866053465679 - 864866053465679 - 2024-06-09 18:21:59 - 16.12 | 2024-06-09 00:00:00 - 2024-06-09 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:34; in_array 2: 864866053465679 - 864866053465679 - 2024-06-09 18:21:59 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:34; imei : 864866053465679 - 864866053465679 - 9
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:35; imei : 864866053465679 - 864866053465679 - 10
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:35; imei : 864866053465679 - 864866053465679 - 11
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:37; imei : 864866053465679 - 864866053465679 - 12
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:37; imei : 864866053465679 - 864866053465679 - 13
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:37; imei : 864866053465679 - 864866053465679 - 14
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:37; imei : 864866053465679 - 864866053465679 - 15
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:37; imei : 864866053465679 - 864866053465679 - 16
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:38; imei : 864866053465679 - 864866053465679 - 17
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:39; imei : 864866053465679 - 864866053465679 - 18
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:40; imei : 864866053465679 - 864866053465679 - 19
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:41; imei : 864866053465679 - 864866053465679 - 20
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:42; imei : 864866053465679 - 864866053465679 - 21
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:43; in_array 2: 864866053465679 - 864866053465679 - 2024-05-25 14:59:39 - 20.32 | 2024-05-25 00:00:00 - 2024-05-25 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:43; in_array 2: 864866053465679 - 864866053465679 - 2024-05-25 14:59:39 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:43; imei : 864866053465679 - 864866053465679 - 22
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:44; imei : 864866053465679 - 864866053465679 - 23
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:45; imei : 864866053465679 - 864866053465679 - 24
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:46; imei : 864866053465679 - 864866053465679 - 25
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:48; imei : 864866053465679 - 864866053465679 - 26
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:49; AFTER mainQuery: 
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:50; in_array after: 864866053465679 - 2024-05-31 08:22:55 - 112.45
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:50; while 864866053465679: MileageFromTo=4056.34 Mileage=4044.75 MileageR=112.45
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:50; while 864866053465679: MileageWork=3932.3 MileageNotWork=11.590000000001
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-09 13:09:50; while 864866053465679: Total=4056.34