--------------------------------------------------------------- [ 2022-10-10T05:20:18+08:00 ] 223.104.254.59 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010965s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2022-10-10T05:20:19+08:00 ] 223.104.254.59 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665350418&v1=0.018030&v2=0.014290&v3=0.015291&v4=-0.004545&v5=12.240000&t=14.561909&h=63.961548&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001705s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665350418,`v1`=0.01803,`v2`=0.01429,`v3`=0.015291,`v4`=-0.004545,`v5`=12.24,`t`=14.561909,`h`=63.961548,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665350419 WHERE `imei` = '868922055683920' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009113s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665350418 , 0.01803 , 0.01429 , 0.015291 , -0.004545 , 12.24 , 14.561909 , 63.961548 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665350419) [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2022-10-10T10:42:28+08:00 ] 39.144.1.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2022-10-10T10:42:29+08:00 ] 39.144.1.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665369748&v1=0.006953&v2=0.113800&v3=0.007344&v4=0.007796&v5=12.060000&t=17.371778&h=69.943047&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012670s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000861s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665369748,`v1`=0.006953,`v2`=0.1138,`v3`=0.007344,`v4`=0.007796,`v5`=12.06,`t`=17.371778,`h`=69.943047,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665369749 WHERE `imei` = '868922055677740' [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011314s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665369748 , 0.006953 , 0.1138 , 0.007344 , 0.007796 , 12.06 , 17.371778 , 69.943047 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1665369749) [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2022-10-10T17:20:16+08:00 ] 39.144.10.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002278s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012217s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2022-10-10T17:20:17+08:00 ] 39.144.10.42 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665393616&v1=0.018512&v2=0.016063&v3=0.015532&v4=-0.004485&v5=12.060000&t=16.685478&h=64.060730&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001519s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011121s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000624s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665393616,`v1`=0.018512,`v2`=0.016063,`v3`=0.015532,`v4`=-0.004485,`v5`=12.06,`t`=16.685478,`h`=64.06073,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665393617 WHERE `imei` = '868922055683920' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010644s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665393616 , 0.018512 , 0.016063 , 0.015532 , -0.004485 , 12.06 , 16.685478 , 64.06073 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665393617) [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2022-10-10T18:00:50+08:00 ] 39.144.18.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2022-10-10T18:00:59+08:00 ] 39.144.18.66 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221010&time=180001&v1=-01.255&v2=+00.026&v3=-01.116&v4=-00.716&v5=05.9&t=+11.5&h=81.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.273&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001929s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012110s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000869s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221010',`time`='180001',`v1`=-1.255,`v2`=0.026,`v3`=-1.116,`v4`=-0.716,`v5`=5.9,`t`=11.5,`h`=81,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.273,`update_time`=1665396059 WHERE `imei` = '868922055684076' [ RunTime:0.000766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013286s ] [ 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' , '221010' , '180001' , -1.255 , 0.026 , -1.116 , -0.716 , 5.9 , 11.5 , 81 , 228 , '460044618415249' , -0 , 0.162 , 1.273 , 1665396059 , 1665396059) [ RunTime:0.000819s ] --------------------------------------------------------------- [ 2022-10-10T19:44:17+08:00 ] 39.144.4.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027997s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2022-10-10T19:44:18+08:00 ] 39.144.4.150 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665402257&v1=0.025736&v2=0.069469&v3=0.021642&v4=-0.002980&v5=6.660000&t=5.713704&h=65.388245&rssi=23&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001914s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665402257,`v1`=0.025736,`v2`=0.069469,`v3`=0.021642,`v4`=-0.00298,`v5`=6.66,`t`=5.713704,`h`=65.388245,`rssi`=23,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665402258 WHERE `imei` = '868922055644211' [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010522s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1665402257 , 0.025736 , 0.069469 , 0.021642 , -0.00298 , 6.66 , 5.713704 , 65.388245 , 23 , '89860426102071188505' , '460044618415255' , -0 , 1665402258) [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2022-10-10T21:35:35+08:00 ] 112.226.103.28 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012874s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2022-10-10T21:35:40+08:00 ] 112.226.103.28 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001649s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012300s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000352s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000773s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2022-10-10T22:15:57+08:00 ] 39.144.1.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002268s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000835s ] --------------------------------------------------------------- [ 2022-10-10T22:16:06+08:00 ] 39.144.1.202 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221010&time=221501&v1=-01.265&v2=+00.033&v3=-01.125&v4=-00.726&v5=05.9&t=+06.3&h=81.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.166&a2=01.285&a3=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.010829s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221010',`time`='221501',`v1`=-1.265,`v2`=0.033,`v3`=-1.125,`v4`=-0.726,`v5`=5.9,`t`=6.3,`h`=81.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.166,`a2`=1.285,`update_time`=1665411366 WHERE `imei` = '868922055684076' [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010739s ] [ 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' , '221010' , '221501' , -1.265 , 0.033 , -1.125 , -0.726 , 5.9 , 6.3 , 81.1 , 228 , '460044618415249' , -0 , 0.166 , 1.285 , 1665411366 , 1665411366) [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2022-10-10T22:42:47+08:00 ] 39.144.14.233 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2022-10-10T22:42:49+08:00 ] 39.144.14.233 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665412967&v1=0.006773&v2=0.105456&v3=0.007194&v4=0.007555&v5=12.060000&t=15.516340&h=70.126152&rssi=31&ccid=89860426102071188504&imsi=460044618415254&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.009807s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665412967,`v1`=0.006773,`v2`=0.105456,`v3`=0.007194,`v4`=0.007555,`v5`=12.06,`t`=15.51634,`h`=70.126152,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665412969 WHERE `imei` = '868922055677740' [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010394s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665412967 , 0.006773 , 0.105456 , 0.007194 , 0.007555 , 12.06 , 15.51634 , 70.126152 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665412969) [ RunTime:0.000582s ]