--------------------------------------------------------------- [ 2022-10-12T05:20:18+08:00 ] 117.132.194.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011130s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2022-10-12T05:20:20+08:00 ] 117.132.194.89 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665523218&v1=0.018151&v2=0.014812&v3=0.015291&v4=-0.004425&v5=12.240000&t=14.754961&h=63.778442&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001930s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010395s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665523218,`v1`=0.018151,`v2`=0.014812,`v3`=0.015291,`v4`=-0.004425,`v5`=12.24,`t`=14.754961,`h`=63.778442,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665523220 WHERE `imei` = '868922055683920' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009891s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665523218 , 0.018151 , 0.014812 , 0.015291 , -0.004425 , 12.24 , 14.754961 , 63.778442 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665523220) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2022-10-12T10:43:48+08:00 ] 39.144.15.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012053s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2022-10-12T10:43:49+08:00 ] 39.144.15.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665542628&v1=0.007074&v2=0.092104&v3=0.007585&v4=0.008278&v5=11.880000&t=19.795647&h=70.202446&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.014659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665542628,`v1`=0.007074,`v2`=0.092104,`v3`=0.007585,`v4`=0.008278,`v5`=11.88,`t`=19.795647,`h`=70.202446,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665542629 WHERE `imei` = '868922055677740' [ RunTime:0.000518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009675s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665542628 , 0.007074 , 0.092104 , 0.007585 , 0.008278 , 11.88 , 19.795647 , 70.202446 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665542629) [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2022-10-12T17:20:19+08:00 ] 221.178.124.88 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010566s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2022-10-12T17:20:20+08:00 ] 221.178.124.88 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665566419&v1=0.018572&v2=0.013560&v3=0.015773&v4=-0.004485&v5=12.060000&t=18.701797&h=64.144653&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010904s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665566419,`v1`=0.018572,`v2`=0.01356,`v3`=0.015773,`v4`=-0.004485,`v5`=12.06,`t`=18.701797,`h`=64.144653,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665566420 WHERE `imei` = '868922055683920' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009818s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665566419 , 0.018572 , 0.01356 , 0.015773 , -0.004485 , 12.06 , 18.701797 , 64.144653 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665566420) [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2022-10-12T19:44:14+08:00 ] 39.144.13.208 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011495s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2022-10-12T19:44:15+08:00 ] 39.144.13.208 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665575054&v1=0.026037&v2=0.076666&v3=0.022094&v4=-0.002920&v5=6.660000&t=11.966435&h=65.350098&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.004088s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009231s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665575054,`v1`=0.026037,`v2`=0.076666,`v3`=0.022094,`v4`=-0.00292,`v5`=6.66,`t`=11.966435,`h`=65.350098,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665575055 WHERE `imei` = '868922055644211' [ RunTime:0.000563s ] [ 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 ('868922055644211' , 1665575054 , 0.026037 , 0.076666 , 0.022094 , -0.00292 , 6.66 , 11.966435 , 65.350098 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1665575055) [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2022-10-12T22:15:50+08:00 ] 39.144.10.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2022-10-12T22:15:59+08:00 ] 39.144.10.132 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221012&time=221501&v1=-01.281&v2=+00.023&v3=-01.141&v4=-00.748&v5=05.9&t=+10.8&h=81.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.165&a2=01.299&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000932s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221012',`time`='221501',`v1`=-1.281,`v2`=0.023,`v3`=-1.141,`v4`=-0.748,`v5`=5.9,`t`=10.8,`h`=81.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.165,`a2`=1.299,`update_time`=1665584159 WHERE `imei` = '868922055684076' [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012356s ] [ 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' , '221012' , '221501' , -1.281 , 0.023 , -1.141 , -0.748 , 5.9 , 10.8 , 81.2 , 227 , '460044618415249' , -0 , 0.165 , 1.299 , 1665584159 , 1665584159) [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2022-10-12T22:44:09+08:00 ] 39.144.6.188 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.019659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2022-10-12T22:44:10+08:00 ] 39.144.6.188 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665585849&v1=0.007013&v2=0.049755&v3=0.007284&v4=0.007676&v5=11.880000&t=17.178728&h=69.912529&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010969s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665585849,`v1`=0.007013,`v2`=0.049755,`v3`=0.007284,`v4`=0.007676,`v5`=11.88,`t`=17.178728,`h`=69.912529,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665585850 WHERE `imei` = '868922055677740' [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011544s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665585849 , 0.007013 , 0.049755 , 0.007284 , 0.007676 , 11.88 , 17.178728 , 69.912529 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665585850) [ RunTime:0.000664s ]