IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:49; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2024-06-01 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-12 09:12:49; 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-31 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 ('9380')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; imei : 9380 - 9380 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; in_array 2: 9380 - 9380 - 2024-06-01 14:50:47 - 27.64 | 2024-06-01 00:00:00 - 2024-06-01 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; in_array 2: 9380 - 9380 - 2024-06-01 14:50:47 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; imei : 9380 - 9380 - 1
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; in_array 2: 9380 - 9380 - 2024-06-02 17:28:46 - 62 | 2024-06-02 00:00:00 - 2024-06-02 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; in_array 2: 9380 - 9380 - 2024-06-02 17:28:46 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:50; imei : 9380 - 9380 - 2
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:53; imei : 9380 - 9380 - 3
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:55; imei : 9380 - 9380 - 4
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:58; imei : 9380 - 9380 - 5
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:12:59; imei : 9380 - 9380 - 6
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:01; imei : 9380 - 9380 - 7
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:02; in_array 2: 9380 - 9380 - 2024-06-08 12:41:39 - 16.57 | 2024-06-08 00:00:00 - 2024-06-08 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:02; in_array 2: 9380 - 9380 - 2024-06-08 12:41:39 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:02; imei : 9380 - 9380 - 8
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:02; in_array 2: 9380 - 9380 - 2024-06-09 15:06:28 - 44.09 | 2024-06-09 00:00:00 - 2024-06-09 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:02; in_array 2: 9380 - 9380 - 2024-06-09 15:06:28 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:02; imei : 9380 - 9380 - 9
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:05; imei : 9380 - 9380 - 10
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:06; imei : 9380 - 9380 - 11
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:08; imei : 9380 - 9380 - 12
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:09; imei : 9380 - 9380 - 13
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:11; imei : 9380 - 9380 - 14
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:12; in_array 2: 9380 - 9380 - 2024-06-15 17:23:58 - 63.95 | 2024-06-15 00:00:00 - 2024-06-15 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:12; in_array 2: 9380 - 9380 - 2024-06-15 17:23:58 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:12; imei : 9380 - 9380 - 15
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:14; imei : 9380 - 9380 - 16
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:17; imei : 9380 - 9380 - 17
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:20; imei : 9380 - 9380 - 18
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:21; imei : 9380 - 9380 - 19
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:24; imei : 9380 - 9380 - 20
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:24; in_array 2: 9380 - 9380 - 2024-06-22 07:13:51 - 37.31 | 2024-06-22 00:00:00 - 2024-06-22 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:24; in_array 2: 9380 - 9380 - 2024-06-22 07:13:51 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:24; imei : 9380 - 9380 - 21
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:25; imei : 9380 - 9380 - 22
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:27; imei : 9380 - 9380 - 23
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:29; imei : 9380 - 9380 - 24
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:30; imei : 9380 - 9380 - 25
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:31; imei : 9380 - 9380 - 26
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:32; in_array 2: 9380 - 9380 - 2024-06-30 17:00:38 - 36.16 | 2024-06-30 00:00:00 - 2024-06-30 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:32; in_array 2: 9380 - 9380 - 2024-06-30 17:00:38 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:32; AFTER mainQuery: 
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:33; in_array after: 9380 - 2024-06-30 17:00:38 - 287.74
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:33; while 9380: MileageFromTo=3397.99 Mileage=3389.17 MileageR=287.74
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:33; while 9380: MileageWork=3101.43 MileageNotWork=8.8199999999997
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-12 09:13:33; while 9380: Total=3397.99