--------------------------------------------------------------- [ 2022-10-01T05:20:17+08:00 ] 39.144.17.204 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2022-10-01T05:20:18+08:00 ] 39.144.17.204 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664572817&v1=0.018873&v2=0.012934&v3=0.016284&v4=-0.004846&v5=12.240000&t=24.075071&h=63.915771&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009024s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664572817,`v1`=0.018873,`v2`=0.012934,`v3`=0.016284,`v4`=-0.004846,`v5`=12.24,`t`=24.075071,`h`=63.915771,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664572818 WHERE `imei` = '868922055683920' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010809s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664572817 , 0.018873 , 0.012934 , 0.016284 , -0.004846 , 12.24 , 24.075071 , 63.915771 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664572818) [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2022-10-01T10:36:29+08:00 ] 117.132.194.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011191s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2022-10-01T10:36:31+08:00 ] 117.132.194.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664591789&v1=0.008579&v2=0.098571&v3=0.008097&v4=0.009060&v5=12.060000&t=27.914534&h=70.499992&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009925s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664591789,`v1`=0.008579,`v2`=0.098571,`v3`=0.008097,`v4`=0.00906,`v5`=12.06,`t`=27.914534,`h`=70.499992,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664591791 WHERE `imei` = '868922055677740' [ RunTime:0.000558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010881s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664591789 , 0.008579 , 0.098571 , 0.008097 , 0.00906 , 12.06 , 27.914534 , 70.499992 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1664591791) [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2022-10-01T17:20:16+08:00 ] 39.144.4.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2022-10-01T17:20:18+08:00 ] 39.144.4.178 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664616016&v1=0.018993&v2=0.014395&v3=0.016375&v4=-0.004786&v5=12.240000&t=25.791086&h=64.594788&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] 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` = '868922055683920' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664616016,`v1`=0.018993,`v2`=0.014395,`v3`=0.016375,`v4`=-0.004786,`v5`=12.24,`t`=25.791086,`h`=64.594788,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664616017 WHERE `imei` = '868922055683920' [ RunTime:0.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011277s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664616016 , 0.018993 , 0.014395 , 0.016375 , -0.004786 , 12.24 , 25.791086 , 64.594788 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664616018) [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2022-10-01T17:32:34+08:00 ] 27.223.154.40 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002164s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.009914s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2022-10-01T17:32:40+08:00 ] 27.223.154.40 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009422s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000308s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000576s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2022-10-01T17:32:58+08:00 ] 27.223.154.40 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010996s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2022-10-01T18:00:44+08:00 ] 27.223.154.40 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002124s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010207s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2022-10-01T18:06:50+08:00 ] 218.204.253.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011116s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2022-10-01T18:06:59+08:00 ] 218.204.253.30 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221001&time=180601&v1=-01.106&v2=+00.015&v3=-00.968&v4=-00.525&v5=06.0&t=+22.4&h=80.5&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.177&a2=01.139&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001657s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010954s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221001',`time`='180601',`v1`=-1.106,`v2`=0.015,`v3`=-0.968,`v4`=-0.525,`v5`=6,`t`=22.4,`h`=80.5,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.177,`a2`=1.139,`update_time`=1664618819 WHERE `imei` = '868922055684076' [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011590s ] [ 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' , '221001' , '180601' , -1.106 , 0.015 , -0.968 , -0.525 , 6 , 22.4 , 80.5 , 227 , '460044618415249' , -0 , 0.177 , 1.139 , 1664618819 , 1664618819) [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2022-10-01T19:44:15+08:00 ] 117.132.191.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002176s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011105s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2022-10-01T19:44:16+08:00 ] 117.132.191.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1664624655&v1=0.026639&v2=0.062063&v3=0.023147&v4=-0.001475&v5=6.660000&t=21.640474&h=64.228577&rssi=19&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001449s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008894s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000585s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1664624655,`v1`=0.026639,`v2`=0.062063,`v3`=0.023147,`v4`=-0.001475,`v5`=6.66,`t`=21.640474,`h`=64.228577,`rssi`=19,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1664624656 WHERE `imei` = '868922055644211' [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010380s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1664624655 , 0.026639 , 0.062063 , 0.023147 , -0.001475 , 6.66 , 21.640474 , 64.228577 , 19 , '89860426102071188505' , '460044618415255' , -0 , 1664624656) [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2022-10-01T22:36:49+08:00 ] 39.144.10.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2022-10-01T22:36:50+08:00 ] 39.144.10.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664635009&v1=0.008097&v2=0.043288&v3=0.007856&v4=0.008699&v5=12.060000&t=24.922235&h=70.240593&rssi=31&ccid=89860426102071188504&imsi=460044618415254&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.010857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664635009,`v1`=0.008097,`v2`=0.043288,`v3`=0.007856,`v4`=0.008699,`v5`=12.06,`t`=24.922235,`h`=70.240593,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664635010 WHERE `imei` = '868922055677740' [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010370s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664635009 , 0.008097 , 0.043288 , 0.007856 , 0.008699 , 12.06 , 24.922235 , 70.240593 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1664635010) [ RunTime:0.000581s ]