--------------------------------------------------------------- [ 2022-09-25T05:20:17+08:00 ] 39.144.13.52 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2022-09-25T05:20:18+08:00 ] 39.144.13.52 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664054417&v1=0.018692&v2=0.013143&v3=0.015863&v4=-0.004605&v5=12.240000&t=21.200745&h=63.923401&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664054417,`v1`=0.018692,`v2`=0.013143,`v3`=0.015863,`v4`=-0.004605,`v5`=12.24,`t`=21.200745,`h`=63.923401,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664054418 WHERE `imei` = '868922055683920' [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009635s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664054417 , 0.018692 , 0.013143 , 0.015863 , -0.004605 , 12.24 , 21.200745 , 63.923401 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664054418) [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2022-09-25T10:32:27+08:00 ] 39.144.15.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009247s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2022-09-25T10:32:28+08:00 ] 39.144.15.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664073147&v1=0.007856&v2=0.069469&v3=0.007946&v4=0.008398&v5=12.060000&t=25.211813&h=70.896721&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664073147,`v1`=0.007856,`v2`=0.069469,`v3`=0.007946,`v4`=0.008398,`v5`=12.06,`t`=25.211813,`h`=70.896721,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664073148 WHERE `imei` = '868922055677740' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011285s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664073147 , 0.007856 , 0.069469 , 0.007946 , 0.008398 , 12.06 , 25.211813 , 70.896721 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1664073148) [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2022-09-25T17:20:18+08:00 ] 39.144.4.203 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012275s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000974s ] --------------------------------------------------------------- [ 2022-09-25T17:20:19+08:00 ] 39.144.4.203 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664097618&v1=0.019054&v2=0.013456&v3=0.016314&v4=-0.004726&v5=12.420000&t=24.890179&h=65.182251&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013637s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664097618,`v1`=0.019054,`v2`=0.013456,`v3`=0.016314,`v4`=-0.004726,`v5`=12.42,`t`=24.890179,`h`=65.182251,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664097619 WHERE `imei` = '868922055683920' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011040s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664097618 , 0.019054 , 0.013456 , 0.016314 , -0.004726 , 12.42 , 24.890179 , 65.182251 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664097619) [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2022-09-25T18:10:50+08:00 ] 117.132.191.189 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002203s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010160s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2022-09-25T18:10:59+08:00 ] 117.132.191.189 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220925&time=181001&v1=-00.416&v2=+00.026&v3=-00.315&v4=+00.217&v5=06.0&t=+20.3&h=80.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.164&a2=00.519&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009429s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000584s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220925',`time`='181001',`v1`=-0.416,`v2`=0.026,`v3`=-0.315,`v4`=0.217,`v5`=6,`t`=20.3,`h`=80.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=0.519,`update_time`=1664100659 WHERE `imei` = '868922055684076' [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010075s ] [ 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' , '220925' , '181001' , -0.416 , 0.026 , -0.315 , 0.217 , 6 , 20.3 , 80.9 , 227 , '460044618415249' , -0 , 0.164 , 0.519 , 1664100659 , 1664100659) [ RunTime:0.001226s ] --------------------------------------------------------------- [ 2022-09-25T19:21:23+08:00 ] 112.224.154.203 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011610s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000679s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2022-09-25T19:44:13+08:00 ] 39.144.4.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011171s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2022-09-25T19:44:14+08:00 ] 39.144.4.18 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1664106253&v1=0.026338&v2=0.036299&v3=0.022997&v4=-0.002017&v5=6.660000&t=17.779438&h=64.266724&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1664106253,`v1`=0.026338,`v2`=0.036299,`v3`=0.022997,`v4`=-0.002017,`v5`=6.66,`t`=17.779438,`h`=64.266724,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1664106254 WHERE `imei` = '868922055644211' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013371s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1664106253 , 0.026338 , 0.036299 , 0.022997 , -0.002017 , 6.66 , 17.779438 , 64.266724 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1664106254) [ RunTime:0.001264s ] --------------------------------------------------------------- [ 2022-09-25T22:32:48+08:00 ] 39.144.10.171 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010349s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2022-09-25T22:32:49+08:00 ] 39.144.10.171 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664116368&v1=0.007615&v2=0.041202&v3=0.007766&v4=0.008037&v5=12.060000&t=22.766495&h=70.622063&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009377s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000576s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664116368,`v1`=0.007615,`v2`=0.041202,`v3`=0.007766,`v4`=0.008037,`v5`=12.06,`t`=22.766495,`h`=70.622063,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664116369 WHERE `imei` = '868922055677740' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009480s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664116368 , 0.007615 , 0.041202 , 0.007766 , 0.008037 , 12.06 , 22.766495 , 70.622063 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1664116369) [ RunTime:0.000606s ]