--------------------------------------------------------------- [ 2022-09-26T05:20:18+08:00 ] 117.132.198.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002080s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2022-09-26T05:20:19+08:00 ] 117.132.198.42 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664140818&v1=0.018813&v2=0.012830&v3=0.015923&v4=-0.004666&v5=12.420000&t=21.286545&h=64.068359&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664140818,`v1`=0.018813,`v2`=0.01283,`v3`=0.015923,`v4`=-0.004666,`v5`=12.42,`t`=21.286545,`h`=64.068359,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664140819 WHERE `imei` = '868922055683920' [ RunTime:0.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009649s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664140818 , 0.018813 , 0.01283 , 0.015923 , -0.004666 , 12.42 , 21.286545 , 64.068359 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664140819) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2022-09-26T10:33:08+08:00 ] 117.132.193.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2022-09-26T10:33:09+08:00 ] 117.132.193.134 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664159588&v1=0.008037&v2=0.095859&v3=0.007946&v4=0.008579&v5=12.060000&t=26.187796&h=71.117973&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009375s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664159588,`v1`=0.008037,`v2`=0.095859,`v3`=0.007946,`v4`=0.008579,`v5`=12.06,`t`=26.187796,`h`=71.117973,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664159589 WHERE `imei` = '868922055677740' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011024s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664159588 , 0.008037 , 0.095859 , 0.007946 , 0.008579 , 12.06 , 26.187796 , 71.117973 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1664159589) [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2022-09-26T17:20:18+08:00 ] 39.144.4.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2022-09-26T17:20:19+08:00 ] 39.144.4.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664184018&v1=0.018993&v2=0.013560&v3=0.016375&v4=-0.004726&v5=12.420000&t=25.544409&h=64.472717&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010031s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664184018,`v1`=0.018993,`v2`=0.01356,`v3`=0.016375,`v4`=-0.004726,`v5`=12.42,`t`=25.544409,`h`=64.472717,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664184019 WHERE `imei` = '868922055683920' [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010347s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664184018 , 0.018993 , 0.01356 , 0.016375 , -0.004726 , 12.42 , 25.544409 , 64.472717 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664184019) [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2022-09-26T18:09:51+08:00 ] 39.144.7.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002231s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011183s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2022-09-26T18:09:59+08:00 ] 39.144.7.64 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220926&time=180901&v1=-00.630&v2=+00.028&v3=-00.514&v4=+00.000&v5=06.0&t=+20.9&h=81.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.167&a2=00.699&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001964s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000960s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220926',`time`='180901',`v1`=-0.63,`v2`=0.028,`v3`=-0.514,`v4`=0,`v5`=6,`t`=20.9,`h`=81.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.167,`a2`=0.699,`update_time`=1664186999 WHERE `imei` = '868922055684076' [ RunTime:0.000819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013647s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '220926' , '180901' , -0.63 , 0.028 , -0.514 , 0 , 6 , 20.9 , 81.1 , 228 , '460044618415249' , -0 , 0.167 , 0.699 , 1664186999 , 1664186999) [ RunTime:0.000923s ] --------------------------------------------------------------- [ 2022-09-26T19:44:15+08:00 ] 117.132.191.251 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002104s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010431s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2022-09-26T19:44:16+08:00 ] 117.132.191.251 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1664192655&v1=0.026278&v2=0.040576&v3=0.023207&v4=-0.003341&v5=6.840000&t=17.672188&h=65.388245&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1664192655,`v1`=0.026278,`v2`=0.040576,`v3`=0.023207,`v4`=-0.003341,`v5`=6.84,`t`=17.672188,`h`=65.388245,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1664192656 WHERE `imei` = '868922055644211' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010432s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1664192655 , 0.026278 , 0.040576 , 0.023207 , -0.003341 , 6.84 , 17.672188 , 65.388245 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1664192656) [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2022-09-26T22:33:27+08:00 ] 39.144.17.241 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002314s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010511s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2022-09-26T22:33:29+08:00 ] 39.144.17.241 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664202807&v1=0.007736&v2=0.045270&v3=0.007706&v4=0.008217&v5=12.060000&t=22.948820&h=70.721245&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001938s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010350s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664202807,`v1`=0.007736,`v2`=0.04527,`v3`=0.007706,`v4`=0.008217,`v5`=12.06,`t`=22.94882,`h`=70.721245,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664202809 WHERE `imei` = '868922055677740' [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011224s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664202807 , 0.007736 , 0.04527 , 0.007706 , 0.008217 , 12.06 , 22.94882 , 70.721245 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1664202809) [ RunTime:0.000628s ]