--------------------------------------------------------------- [ 2022-09-30T05:20:16+08:00 ] 117.132.195.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002337s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2022-09-30T05:20:18+08:00 ] 117.132.195.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664486416&v1=0.018873&v2=0.013873&v3=0.016134&v4=-0.004666&v5=12.240000&t=23.313589&h=64.159912&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010860s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664486416,`v1`=0.018873,`v2`=0.013873,`v3`=0.016134,`v4`=-0.004666,`v5`=12.24,`t`=23.313589,`h`=64.159912,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664486417 WHERE `imei` = '868922055683920' [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022813s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664486416 , 0.018873 , 0.013873 , 0.016134 , -0.004666 , 12.24 , 23.313589 , 64.159912 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664486418) [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2022-09-30T10:35:48+08:00 ] 117.132.191.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011973s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2022-09-30T10:35:49+08:00 ] 117.132.191.156 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664505348&v1=0.008458&v2=0.140190&v3=0.008067&v4=0.009120&v5=12.060000&t=27.968159&h=70.728874&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664505348,`v1`=0.008458,`v2`=0.14019,`v3`=0.008067,`v4`=0.00912,`v5`=12.06,`t`=27.968159,`h`=70.728874,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664505349 WHERE `imei` = '868922055677740' [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010731s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664505348 , 0.008458 , 0.14019 , 0.008067 , 0.00912 , 12.06 , 27.968159 , 70.728874 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1664505349) [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2022-09-30T17:20:16+08:00 ] 39.144.2.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010273s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2022-09-30T17:20:18+08:00 ] 39.144.2.79 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664529616&v1=0.019114&v2=0.014603&v3=0.016465&v4=-0.004605&v5=12.240000&t=25.973413&h=64.747375&rssi=31&ccid=89860426102071188500&imsi=460044618415250&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.009714s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664529616,`v1`=0.019114,`v2`=0.014603,`v3`=0.016465,`v4`=-0.004605,`v5`=12.24,`t`=25.973413,`h`=64.747375,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664529618 WHERE `imei` = '868922055683920' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010974s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664529616 , 0.019114 , 0.014603 , 0.016465 , -0.004605 , 12.24 , 25.973413 , 64.747375 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664529618) [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-09-30T18:07:50+08:00 ] 221.178.125.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002103s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013113s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2022-09-30T18:07:58+08:00 ] 221.178.125.107 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220930&time=180701&v1=-01.153&v2=+00.021&v3=-01.012&v4=-00.559&v5=06.0&t=+21.6&h=81.3&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.173&a2=01.177&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001421s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009661s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220930',`time`='180701',`v1`=-1.153,`v2`=0.021,`v3`=-1.012,`v4`=-0.559,`v5`=6,`t`=21.6,`h`=81.3,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.173,`a2`=1.177,`update_time`=1664532478 WHERE `imei` = '868922055684076' [ RunTime:0.000564s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010267s ] [ 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' , '220930' , '180701' , -1.153 , 0.021 , -1.012 , -0.559 , 6 , 21.6 , 81.3 , 228 , '460044618415249' , -0 , 0.173 , 1.177 , 1664532478 , 1664532478) [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2022-09-30T19:44:13+08:00 ] 39.144.11.223 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000903s ] --------------------------------------------------------------- [ 2022-09-30T19:44:14+08:00 ] 39.144.11.223 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1664538253&v1=0.026338&v2=0.046521&v3=0.022425&v4=-0.003040&v5=6.660000&t=19.184425&h=64.945740&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1664538253,`v1`=0.026338,`v2`=0.046521,`v3`=0.022425,`v4`=-0.00304,`v5`=6.66,`t`=19.184425,`h`=64.94574,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1664538254 WHERE `imei` = '868922055644211' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009762s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1664538253 , 0.026338 , 0.046521 , 0.022425 , -0.00304 , 6.66 , 19.184425 , 64.94574 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1664538254) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2022-09-30T20:00:28+08:00 ] 39.77.159.246 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002104s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012192s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2022-09-30T20:00:32+08:00 ] 39.77.159.246 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010612s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2022-09-30T22:36:08+08:00 ] 39.144.13.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002221s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011869s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2022-09-30T22:36:10+08:00 ] 39.144.13.134 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664548568&v1=0.008037&v2=0.039324&v3=0.007916&v4=0.008518&v5=12.060000&t=24.729183&h=70.416069&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001509s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664548568,`v1`=0.008037,`v2`=0.039324,`v3`=0.007916,`v4`=0.008518,`v5`=12.06,`t`=24.729183,`h`=70.416069,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664548570 WHERE `imei` = '868922055677740' [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009929s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664548568 , 0.008037 , 0.039324 , 0.007916 , 0.008518 , 12.06 , 24.729183 , 70.416069 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1664548570) [ RunTime:0.000602s ]