--------------------------------------------------------------- [ 2022-10-15T05:20:18+08:00 ] 39.144.12.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2022-10-15T05:20:20+08:00 ] 39.144.12.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665782418&v1=0.018391&v2=0.014186&v3=0.015532&v4=-0.004726&v5=12.240000&t=17.918865&h=63.458008&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001631s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010002s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665782418,`v1`=0.018391,`v2`=0.014186,`v3`=0.015532,`v4`=-0.004726,`v5`=12.24,`t`=17.918865,`h`=63.458008,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665782420 WHERE `imei` = '868922055683920' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010936s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665782418 , 0.018391 , 0.014186 , 0.015532 , -0.004726 , 12.24 , 17.918865 , 63.458008 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1665782420) [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2022-10-15T10:45:48+08:00 ] 218.204.253.234 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011895s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2022-10-15T10:45:50+08:00 ] 218.204.253.234 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665801948&v1=0.007676&v2=0.103056&v3=0.007766&v4=0.008217&v5=12.060000&t=23.978428&h=70.751762&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011170s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665801948,`v1`=0.007676,`v2`=0.103056,`v3`=0.007766,`v4`=0.008217,`v5`=12.06,`t`=23.978428,`h`=70.751762,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665801949 WHERE `imei` = '868922055677740' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010725s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665801948 , 0.007676 , 0.103056 , 0.007766 , 0.008217 , 12.06 , 23.978428 , 70.751762 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665801950) [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-10-15T17:20:18+08:00 ] 39.144.2.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2022-10-15T17:20:20+08:00 ] 39.144.2.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665825618&v1=0.018452&v2=0.015751&v3=0.015773&v4=-0.004605&v5=12.240000&t=20.782465&h=64.571899&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009262s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665825618,`v1`=0.018452,`v2`=0.015751,`v3`=0.015773,`v4`=-0.004605,`v5`=12.24,`t`=20.782465,`h`=64.571899,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665825620 WHERE `imei` = '868922055683920' [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010523s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665825618 , 0.018452 , 0.015751 , 0.015773 , -0.004605 , 12.24 , 20.782465 , 64.571899 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665825620) [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2022-10-15T19:44:17+08:00 ] 117.132.195.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010910s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2022-10-15T19:44:18+08:00 ] 117.132.195.60 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665834257&v1=0.026157&v2=0.062376&v3=0.020950&v4=-0.002017&v5=6.660000&t=14.004204&h=65.372986&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010500s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665834257,`v1`=0.026157,`v2`=0.062376,`v3`=0.02095,`v4`=-0.002017,`v5`=6.66,`t`=14.004204,`h`=65.372986,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665834258 WHERE `imei` = '868922055644211' [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011110s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1665834257 , 0.026157 , 0.062376 , 0.02095 , -0.002017 , 6.66 , 14.004204 , 65.372986 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1665834258) [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2022-10-15T22:13:50+08:00 ] 39.144.16.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2022-10-15T22:13:59+08:00 ] 39.144.16.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221015&time=221301&v1=-01.277&v2=+00.025&v3=-01.135&v4=-00.751&v5=05.9&t=+14.0&h=81.1&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.167&a2=01.294&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009834s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221015',`time`='221301',`v1`=-1.277,`v2`=0.025,`v3`=-1.135,`v4`=-0.751,`v5`=5.9,`t`=14,`h`=81.1,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.167,`a2`=1.294,`update_time`=1665843239 WHERE `imei` = '868922055684076' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011146s ] [ 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' , '221015' , '221301' , -1.277 , 0.025 , -1.135 , -0.751 , 5.9 , 14 , 81.1 , 227 , '460044618415249' , -0 , 0.167 , 1.294 , 1665843239 , 1665843239) [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2022-10-15T22:46:09+08:00 ] 39.144.4.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002234s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2022-10-15T22:46:10+08:00 ] 39.144.4.172 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665845169&v1=0.007194&v2=0.050902&v3=0.007465&v4=0.008217&v5=12.060000&t=19.270119&h=69.782829&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001778s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011608s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665845169,`v1`=0.007194,`v2`=0.050902,`v3`=0.007465,`v4`=0.008217,`v5`=12.06,`t`=19.270119,`h`=69.782829,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665845170 WHERE `imei` = '868922055677740' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009902s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665845169 , 0.007194 , 0.050902 , 0.007465 , 0.008217 , 12.06 , 19.270119 , 69.782829 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665845170) [ RunTime:0.000641s ]