--------------------------------------------------------------- [ 2022-09-23T05:20:18+08:00 ] 117.132.195.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009942s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2022-09-23T05:20:19+08:00 ] 117.132.195.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663881618&v1=0.018632&v2=0.013873&v3=0.015953&v4=-0.004666&v5=12.240000&t=20.535789&h=64.686340&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009117s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1663881618,`v1`=0.018632,`v2`=0.013873,`v3`=0.015953,`v4`=-0.004666,`v5`=12.24,`t`=20.535789,`h`=64.68634,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663881619 WHERE `imei` = '868922055683920' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010872s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663881618 , 0.018632 , 0.013873 , 0.015953 , -0.004666 , 12.24 , 20.535789 , 64.68634 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1663881619) [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2022-09-23T10:31:06+08:00 ] 39.144.14.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.010975s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2022-09-23T10:31:08+08:00 ] 39.144.14.5 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663900266&v1=0.007555&v2=0.116512&v3=0.007645&v4=0.007916&v5=12.240000&t=22.348217&h=70.980644&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001346s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009918s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663900266,`v1`=0.007555,`v2`=0.116512,`v3`=0.007645,`v4`=0.007916,`v5`=12.24,`t`=22.348217,`h`=70.980644,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663900268 WHERE `imei` = '868922055677740' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009507s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663900266 , 0.007555 , 0.116512 , 0.007645 , 0.007916 , 12.24 , 22.348217 , 70.980644 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663900268) [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2022-09-23T14:55:36+08:00 ] 27.223.14.252 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011101s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'af17a6d2be6676b4cf53b3ae81796fa6' LIMIT 1 [ RunTime:0.001229s ] --------------------------------------------------------------- [ 2022-09-23T17:20:18+08:00 ] 39.144.7.135 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002301s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011635s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2022-09-23T17:20:19+08:00 ] 39.144.7.135 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663924818&v1=0.018873&v2=0.014395&v3=0.016043&v4=-0.004545&v5=12.240000&t=23.131262&h=64.838928&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011269s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1663924818,`v1`=0.018873,`v2`=0.014395,`v3`=0.016043,`v4`=-0.004545,`v5`=12.24,`t`=23.131262,`h`=64.838928,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663924819 WHERE `imei` = '868922055683920' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011704s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663924818 , 0.018873 , 0.014395 , 0.016043 , -0.004545 , 12.24 , 23.131262 , 64.838928 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1663924819) [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2022-09-23T18:12:50+08:00 ] 39.144.1.119 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.008594s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2022-09-23T18:12:58+08:00 ] 39.144.1.119 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220923&time=181201&v1=+00.888&v2=+00.023&v3=+00.931&v4=+01.547&v5=05.7&t=+18.1&h=80.5&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.156&a2=00.633&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010133s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220923',`time`='181201',`v1`=0.888,`v2`=0.023,`v3`=0.931,`v4`=1.547,`v5`=5.7,`t`=18.1,`h`=80.5,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=0.633,`update_time`=1663927978 WHERE `imei` = '868922055684076' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009685s ] [ 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' , '220923' , '181201' , 0.888 , 0.023 , 0.931 , 1.547 , 5.7 , 18.1 , 80.5 , 227 , '460044618415249' , -0 , 0.156 , 0.633 , 1663927978 , 1663927978) [ RunTime:0.001268s ] --------------------------------------------------------------- [ 2022-09-23T18:20:39+08:00 ] 112.224.156.41 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010133s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000749s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2022-09-23T19:44:13+08:00 ] 117.132.197.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2022-09-23T19:44:15+08:00 ] 117.132.197.34 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1663933453&v1=0.026157&v2=0.038803&v3=0.022545&v4=-0.002679&v5=6.660000&t=12.738643&h=65.952820&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010337s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1663933453,`v1`=0.026157,`v2`=0.038803,`v3`=0.022545,`v4`=-0.002679,`v5`=6.66,`t`=12.738643,`h`=65.95282,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1663933455 WHERE `imei` = '868922055644211' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010850s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1663933453 , 0.026157 , 0.038803 , 0.022545 , -0.002679 , 6.66 , 12.738643 , 65.95282 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1663933455) [ RunTime:0.001167s ] --------------------------------------------------------------- [ 2022-09-23T21:55:25+08:00 ] 39.77.159.246 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012635s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000688s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2022-09-23T22:31:27+08:00 ] 39.144.12.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002187s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2022-09-23T22:31:29+08:00 ] 39.144.12.13 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663943487&v1=0.007495&v2=0.088662&v3=0.007645&v4=0.007796&v5=12.060000&t=21.511660&h=70.850945&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663943487,`v1`=0.007495,`v2`=0.088662,`v3`=0.007645,`v4`=0.007796,`v5`=12.06,`t`=21.51166,`h`=70.850945,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663943489 WHERE `imei` = '868922055677740' [ RunTime:0.000581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008372s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663943487 , 0.007495 , 0.088662 , 0.007645 , 0.007796 , 12.06 , 21.51166 , 70.850945 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663943489) [ RunTime:0.000584s ]