--------------------------------------------------------------- [ 2022-10-08T05:20:18+08:00 ] 39.144.11.93 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002192s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2022-10-08T05:20:20+08:00 ] 39.144.11.93 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665177618&v1=0.018271&v2=0.013977&v3=0.015411&v4=-0.004485&v5=12.420000&t=15.773846&h=63.877625&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008213s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665177618,`v1`=0.018271,`v2`=0.013977,`v3`=0.015411,`v4`=-0.004485,`v5`=12.42,`t`=15.773846,`h`=63.877625,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665177620 WHERE `imei` = '868922055683920' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010696s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665177618 , 0.018271 , 0.013977 , 0.015411 , -0.004485 , 12.42 , 15.773846 , 63.877625 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665177620) [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2022-10-08T10:41:08+08:00 ] 39.144.3.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002280s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012274s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2022-10-08T10:41:09+08:00 ] 39.144.3.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665196868&v1=0.007495&v2=0.073850&v3=0.007585&v4=0.007856&v5=12.060000&t=20.675104&h=70.286369&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665196868,`v1`=0.007495,`v2`=0.07385,`v3`=0.007585,`v4`=0.007856,`v5`=12.06,`t`=20.675104,`h`=70.286369,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665196869 WHERE `imei` = '868922055677740' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010951s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665196868 , 0.007495 , 0.07385 , 0.007585 , 0.007856 , 12.06 , 20.675104 , 70.286369 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665196869) [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2022-10-08T17:20:16+08:00 ] 39.144.6.69 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002359s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011136s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000601s ] --------------------------------------------------------------- [ 2022-10-08T17:20:17+08:00 ] 39.144.6.69 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665220816&v1=0.018512&v2=0.015020&v3=0.015773&v4=-0.004545&v5=12.240000&t=19.677780&h=64.701599&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009648s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665220816,`v1`=0.018512,`v2`=0.01502,`v3`=0.015773,`v4`=-0.004545,`v5`=12.24,`t`=19.67778,`h`=64.701599,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665220817 WHERE `imei` = '868922055683920' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010699s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665220816 , 0.018512 , 0.01502 , 0.015773 , -0.004545 , 12.24 , 19.67778 , 64.701599 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665220817) [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2022-10-08T18:01:50+08:00 ] 117.132.193.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002415s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2022-10-08T18:01:59+08:00 ] 117.132.193.152 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221008&time=180101&v1=-01.197&v2=+00.021&v3=-01.077&v4=-00.657&v5=06.0&t=+16.0&h=81.1&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.148&a2=01.225&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009547s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221008',`time`='180101',`v1`=-1.197,`v2`=0.021,`v3`=-1.077,`v4`=-0.657,`v5`=6,`t`=16,`h`=81.1,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.148,`a2`=1.225,`update_time`=1665223319 WHERE `imei` = '868922055684076' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010171s ] [ 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' , '221008' , '180101' , -1.197 , 0.021 , -1.077 , -0.657 , 6 , 16 , 81.1 , 227 , '460044618415249' , -0 , 0.148 , 1.225 , 1665223319 , 1665223319) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2022-10-08T19:44:13+08:00 ] 39.144.11.155 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002479s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010198s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2022-10-08T19:44:14+08:00 ] 39.144.11.155 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665229453&v1=0.025977&v2=0.089288&v3=0.022545&v4=-0.001656&v5=6.840000&t=13.757526&h=64.343018&rssi=22&ccid=89860426102071188505&imsi=460044618415255&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.010116s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665229453,`v1`=0.025977,`v2`=0.089288,`v3`=0.022545,`v4`=-0.001656,`v5`=6.84,`t`=13.757526,`h`=64.343018,`rssi`=22,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665229454 WHERE `imei` = '868922055644211' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010680s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1665229453 , 0.025977 , 0.089288 , 0.022545 , -0.001656 , 6.84 , 13.757526 , 64.343018 , 22 , '89860426102071188505' , '460044618415255' , -0 , 1665229454) [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2022-10-08T22:41:28+08:00 ] 117.132.192.88 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002230s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010671s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2022-10-08T22:41:29+08:00 ] 117.132.192.88 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665240088&v1=0.007254&v2=0.045478&v3=0.007344&v4=0.007615&v5=12.060000&t=18.712414&h=69.813347&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665240088,`v1`=0.007254,`v2`=0.045478,`v3`=0.007344,`v4`=0.007615,`v5`=12.06,`t`=18.712414,`h`=69.813347,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665240089 WHERE `imei` = '868922055677740' [ RunTime:0.000515s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011374s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665240088 , 0.007254 , 0.045478 , 0.007344 , 0.007615 , 12.06 , 18.712414 , 69.813347 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665240089) [ RunTime:0.000585s ]