IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:06; SELECT wm_holiday: SELECT `date` FROM `wm_holiday` WHERE `date` >= DATE('2024-05-31 00:00:00') AND `date` <= DATE('2024-07-11 23:59:59') AND `client_id`=53;
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:06; 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-30 21:00:00' AND gp.time < '2024-07-11 20:59:59')
AND TIME(gp.time) >= '03:00:00' AND TIME(gp.time) <= '17:59:59'
AND gp.DeviceLoginName IN ('862531041054447')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:06; imei : 862531041054447 - 862531041054447 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 1
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 2
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 3
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 4
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 5
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; in_array 2: 862531041054447 - 862531041054447 - 2024-07-07 13:51:04 - 35.04 | 2024-07-07 00:00:00 - 2024-07-07 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; in_array 2: 862531041054447 - 862531041054447 - 2024-07-07 13:51:04 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 6
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 7
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 8
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 9
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 10
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; in_array 2: 862531041054447 - 862531041054447 - 2024-06-01 14:50:25 - 0 | 2024-06-01 00:00:00 - 2024-06-01 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; in_array 2: 862531041054447 - 862531041054447 - 2024-06-01 14:50:25 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 11
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; in_array 2: 862531041054447 - 862531041054447 - 2024-06-02 13:46:28 - 21.49 | 2024-06-02 00:00:00 - 2024-06-02 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; in_array 2: 862531041054447 - 862531041054447 - 2024-06-02 13:46:28 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:07; imei : 862531041054447 - 862531041054447 - 12
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:08; imei : 862531041054447 - 862531041054447 - 13
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:08; imei : 862531041054447 - 862531041054447 - 14
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:09; imei : 862531041054447 - 862531041054447 - 15
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:10; imei : 862531041054447 - 862531041054447 - 16
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:11; imei : 862531041054447 - 862531041054447 - 17
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:12; in_array 2: 862531041054447 - 862531041054447 - 2024-06-09 12:14:20 - 19.94 | 2024-06-09 00:00:00 - 2024-06-09 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:12; in_array 2: 862531041054447 - 862531041054447 - 2024-06-09 12:14:20 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:12; imei : 862531041054447 - 862531041054447 - 18
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:13; imei : 862531041054447 - 862531041054447 - 19
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:14; imei : 862531041054447 - 862531041054447 - 20
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:15; imei : 862531041054447 - 862531041054447 - 21
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:16; imei : 862531041054447 - 862531041054447 - 22
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:17; imei : 862531041054447 - 862531041054447 - 23
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:18; in_array 2: 862531041054447 - 862531041054447 - 2024-06-16 16:15:16 - 35.53 | 2024-06-16 00:00:00 - 2024-06-16 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:18; in_array 2: 862531041054447 - 862531041054447 - 2024-06-16 16:15:16 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:18; imei : 862531041054447 - 862531041054447 - 24
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:19; imei : 862531041054447 - 862531041054447 - 25
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:20; imei : 862531041054447 - 862531041054447 - 26
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:21; imei : 862531041054447 - 862531041054447 - 27
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:22; imei : 862531041054447 - 862531041054447 - 28
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; imei : 862531041054447 - 862531041054447 - 29
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; in_array 2: 862531041054447 - 862531041054447 - 2024-06-22 14:51:05 - 18.26 | 2024-06-22 00:00:00 - 2024-06-22 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; in_array 2: 862531041054447 - 862531041054447 - 2024-06-22 14:51:05 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; imei : 862531041054447 - 862531041054447 - 30
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; in_array 2: 862531041054447 - 862531041054447 - 2024-06-23 18:05:07 - 1.63 | 2024-06-23 00:00:00 - 2024-06-23 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; in_array 2: 862531041054447 - 862531041054447 - 2024-06-23 18:05:07 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:23; imei : 862531041054447 - 862531041054447 - 31
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:24; imei : 862531041054447 - 862531041054447 - 32
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:24; imei : 862531041054447 - 862531041054447 - 33
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:25; imei : 862531041054447 - 862531041054447 - 34
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:25; imei : 862531041054447 - 862531041054447 - 35
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:26; imei : 862531041054447 - 862531041054447 - 36
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:26; in_array 2: 862531041054447 - 862531041054447 - 2024-06-29 12:20:59 - 1.35 | 2024-06-29 00:00:00 - 2024-06-29 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:26; in_array 2: 862531041054447 - 862531041054447 - 2024-06-29 12:20:59 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:26; imei : 862531041054447 - 862531041054447 - 37
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:27; in_array 2: 862531041054447 - 862531041054447 - 2024-06-30 12:48:50 - 10.09 | 2024-06-30 00:00:00 - 2024-06-30 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:27; in_array 2: 862531041054447 - 862531041054447 - 2024-06-30 12:48:50 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:27; imei : 862531041054447 - 862531041054447 - 38
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:28; AFTER mainQuery: 
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:29; in_array after: 862531041054447 - 2024-05-31 07:52:43 - 153.32
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:29; while 862531041054447: MileageFromTo=5648.57 Mileage=5638.59 MileageR=153.32
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:29; while 862531041054447: MileageWork=5485.27 MileageNotWork=9.9799999999996
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:00:29; while 862531041054447: Total=5648.57
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:40; 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-11 15:52:40; 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 ('356078118085345')
GROUP BY gp.DeviceLoginName ASC, MONTH, DAY
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:40; imei : 356078118085345 - 356078118085345 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:40; in_array 2: 356078118085345 - 356078118085345 - 2024-06-01 14:50:22 - 0 | 2024-06-01 00:00:00 - 2024-06-01 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:40; in_array 2: 356078118085345 - 356078118085345 - 2024-06-01 14:50:22 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:40; imei : 356078118085345 - 356078118085345 - 1
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:42; in_array 2: 356078118085345 - 356078118085345 - 2024-06-02 11:27:59 - 143.13 | 2024-06-02 00:00:00 - 2024-06-02 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:42; in_array 2: 356078118085345 - 356078118085345 - 2024-06-02 11:27:59 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:42; imei : 356078118085345 - 356078118085345 - 2
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:42; imei : 356078118085345 - 356078118085345 - 3
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:43; imei : 356078118085345 - 356078118085345 - 4
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:44; imei : 356078118085345 - 356078118085345 - 5
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:45; imei : 356078118085345 - 356078118085345 - 6
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:46; imei : 356078118085345 - 356078118085345 - 7
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:47; in_array 2: 356078118085345 - 356078118085345 - 2024-06-08 10:53:36 - 85.08 | 2024-06-08 00:00:00 - 2024-06-08 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:47; in_array 2: 356078118085345 - 356078118085345 - 2024-06-08 10:53:36 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:47; imei : 356078118085345 - 356078118085345 - 8
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:47; in_array 2: 356078118085345 - 356078118085345 - 2024-06-09 09:01:18 - 53.63 | 2024-06-09 00:00:00 - 2024-06-09 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:47; in_array 2: 356078118085345 - 356078118085345 - 2024-06-09 09:01:18 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:47; imei : 356078118085345 - 356078118085345 - 9
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:48; imei : 356078118085345 - 356078118085345 - 10
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:48; imei : 356078118085345 - 356078118085345 - 11
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:49; imei : 356078118085345 - 356078118085345 - 12
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:50; imei : 356078118085345 - 356078118085345 - 13
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:51; imei : 356078118085345 - 356078118085345 - 14
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:52; in_array 2: 356078118085345 - 356078118085345 - 2024-06-16 11:39:00 - 118.7 | 2024-06-16 00:00:00 - 2024-06-16 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:52; in_array 2: 356078118085345 - 356078118085345 - 2024-06-16 11:39:00 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:52; imei : 356078118085345 - 356078118085345 - 15
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:52; imei : 356078118085345 - 356078118085345 - 16
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:53; imei : 356078118085345 - 356078118085345 - 17
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:53; imei : 356078118085345 - 356078118085345 - 18
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:54; imei : 356078118085345 - 356078118085345 - 19
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:54; imei : 356078118085345 - 356078118085345 - 20
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:55; in_array 2: 356078118085345 - 356078118085345 - 2024-06-23 11:56:54 - 73.73 | 2024-06-23 00:00:00 - 2024-06-23 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:55; in_array 2: 356078118085345 - 356078118085345 - 2024-06-23 11:56:54 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:55; imei : 356078118085345 - 356078118085345 - 21
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:55; imei : 356078118085345 - 356078118085345 - 22
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:56; imei : 356078118085345 - 356078118085345 - 23
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:56; imei : 356078118085345 - 356078118085345 - 24
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:58; imei : 356078118085345 - 356078118085345 - 25
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:58; imei : 356078118085345 - 356078118085345 - 26
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:58; in_array 2: 356078118085345 - 356078118085345 - 2024-06-30 11:16:39 - 79.83 | 2024-06-30 00:00:00 - 2024-06-30 23:59:59
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:58; in_array 2: 356078118085345 - 356078118085345 - 2024-06-30 11:16:39 - 0
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:58; AFTER mainQuery: 
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:59; in_array after: 356078118085345 - 2024-06-30 11:16:39 - 554.1
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:59; while 356078118085345: MileageFromTo=1961.67 Mileage=1960.82 MileageR=554.1
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:59; while 356078118085345: MileageWork=1406.72 MileageNotWork=0.84999999999991
IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-07-11 15:52:59; while 356078118085345: Total=1961.67