--------------------------------------------------------------- [ 2024-03-30T01:44:52+08:00 ] 39.144.5.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2024-03-30T01:45:01+08:00 ] 39.144.5.190 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=240330&time=014401&v1=-01.269&v2=+00.040&v3=-00.769&v4=-00.039&v5=05.7&t=+11.2&h=67.5&rssi=+228&ccid=4600485905031420000099m9990000000497000001g2790,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002413s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012079s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000797s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='240330',`time`='014401',`v1`=-1.269,`v2`=0.04,`v3`=-0.769,`v4`=-0.039,`v5`=5.7,`t`=11.2,`h`=67.5,`rssi`=228,`ccid`='4600485905031420000099m9990000000497000001g2790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711734301 WHERE `imei` = '868922055643643' [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012959s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '240330' , '014401' , -1.269 , 0.04 , -0.769 , -0.039 , 5.7 , 11.2 , 67.5 , 228 , '4600485905031420000099m9990000000497000001g2790,N,00E000=-00.000' , 0 , 0 , 1711734301 , 1711734301) [ RunTime:0.001467s ] --------------------------------------------------------------- [ 2024-03-30T01:57:52+08:00 ] 39.144.112.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014885s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2024-03-30T01:58:00+08:00 ] 39.144.112.30 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240330&time=015701&v1=-00.072&v2=+00.001&v3=+00.015&v4=-00.004&v5=05.7&t=+12.2&h=71.1&rssi=+222&ccid=4600485905031430000099m9990000000035000000g0690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001739s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011294s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240330',`time`='015701',`v1`=-0.072,`v2`=0.001,`v3`=0.015,`v4`=-0.004,`v5`=5.7,`t`=12.2,`h`=71.1,`rssi`=222,`ccid`='4600485905031430000099m9990000000035000000g0690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711735080 WHERE `imei` = '868922055644013' [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010519s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '240330' , '015701' , -0.072 , 0.001 , 0.015 , -0.004 , 5.7 , 12.2 , 71.1 , 222 , '4600485905031430000099m9990000000035000000g0690,N,00E000=-00.000' , 0 , 0 , 1711735080 , 1711735080) [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2024-03-30T08:39:30+08:00 ] 117.132.194.246 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012153s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2024-03-30T08:39:31+08:00 ] 117.132.194.246 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711759170&v1=-1.249255&v2=0.652806&v3=-1.105766&v4=-0.608057&v5=6.120000&t=16.975056&h=77.084106&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427124,36.323322&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711759170,`v1`=-1.249255,`v2`=0.652806,`v3`=-1.105766,`v4`=-0.608057,`v5`=6.12,`t`=16.975056,`h`=77.084106,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427124,36.323322',`update_time`=1711759171 WHERE `imei` = '868922055684209' [ RunTime:0.000807s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012620s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1711759170 , -1.249255 , 0.652806 , -1.105766 , -0.608057 , 6.12 , 16.975056 , 77.084106 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.427124,36.323322' , 1711759171) [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2024-03-30T09:04:08+08:00 ] 111.55.139.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003054s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016017s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2024-03-30T09:04:09+08:00 ] 111.55.139.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711760648&v1=-1.176472&v2=0.072643&v3=-1.046288&v4=-0.510713&v5=6.480000&t=15.387742&h=76.389832&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711760648,`v1`=-1.176472,`v2`=0.072643,`v3`=-1.046288,`v4`=-0.510713,`v5`=6.48,`t`=15.387742,`h`=76.389832,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711760649 WHERE `imei` = '868922055644021' [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012253s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711760648 , -1.176472 , 0.072643 , -1.046288 , -0.510713 , 6.48 , 15.387742 , 76.389832 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1711760649) [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2024-03-30T20:40:30+08:00 ] 39.144.12.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.004589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001395s ] --------------------------------------------------------------- [ 2024-03-30T20:40:32+08:00 ] 39.144.12.172 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711802430&v1=-1.087074&v2=0.454842&v3=-0.985546&v4=-0.371468&v5=6.120000&t=11.344379&h=79.678101&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427738,36.322899&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010054s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711802430,`v1`=-1.087074,`v2`=0.454842,`v3`=-0.985546,`v4`=-0.371468,`v5`=6.12,`t`=11.344379,`h`=79.678101,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427738,36.322899',`update_time`=1711802432 WHERE `imei` = '868922055684209' [ RunTime:0.000839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019888s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1711802430 , -1.087074 , 0.454842 , -0.985546 , -0.371468 , 6.12 , 11.344379 , 79.678101 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.427738,36.322899' , 1711802432) [ RunTime:0.006486s ] --------------------------------------------------------------- [ 2024-03-30T21:06:09+08:00 ] 117.132.195.171 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002288s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012708s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001458s ] --------------------------------------------------------------- [ 2024-03-30T21:06:11+08:00 ] 117.132.195.171 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711803969&v1=-1.180506&v2=0.053242&v3=-1.051375&v4=-0.515167&v5=6.300000&t=9.767791&h=79.861206&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711803969,`v1`=-1.180506,`v2`=0.053242,`v3`=-1.051375,`v4`=-0.515167,`v5`=6.3,`t`=9.767791,`h`=79.861206,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711803971 WHERE `imei` = '868922055644021' [ RunTime:0.000833s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012545s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711803969 , -1.180506 , 0.053242 , -1.051375 , -0.515167 , 6.3 , 9.767791 , 79.861206 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1711803971) [ RunTime:0.000630s ]