--------------------------------------------------------------- [ 2023-06-22T00:03:24+08:00 ] 117.132.196.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002350s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011715s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-06-22T00:03:25+08:00 ] 117.132.196.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1687363404&v1=0.008217&v2=0.013664&v3=0.005388&v4=-0.015742&v5=12.060000&t=27.528553&h=81.028503&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011524s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1687363404,`v1`=0.008217,`v2`=0.013664,`v3`=0.005388,`v4`=-0.015742,`v5`=12.06,`t`=27.528553,`h`=81.028503,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1687363405 WHERE `imei` = '868922055644021' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011817s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1687363404 , 0.008217 , 0.013664 , 0.005388 , -0.015742 , 12.06 , 27.528553 , 81.028503 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1687363405) [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2023-06-22T00:23:24+08:00 ] 111.55.138.95 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000748s ] --------------------------------------------------------------- [ 2023-06-22T00:23:25+08:00 ] 111.55.138.95 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1687364604&v1=0.021522&v2=0.014707&v3=0.018632&v4=-0.006231&v5=12.240000&t=27.389126&h=78.754944&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1687364604,`v1`=0.021522,`v2`=0.014707,`v3`=0.018632,`v4`=-0.006231,`v5`=12.24,`t`=27.389126,`h`=78.754944,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1687364605 WHERE `imei` = '868922055680850' [ RunTime:0.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010663s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1687364604 , 0.021522 , 0.014707 , 0.018632 , -0.006231 , 12.24 , 27.389126 , 78.754944 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1687364605) [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2023-06-22T02:03:55+08:00 ] 111.55.136.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012271s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2023-06-22T02:03:55+08:00 ] 223.104.255.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-06-22T02:04:03+08:00 ] 111.55.136.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230622&time=020301&v1=-01.379&v2=+00.013&v3=-00.909&v4=-00.045&v5=06.2&t=+20.6&h=60.3&rssi=+227&ccid=4600485905031420000099m9990000000475000001g3870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011057s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230622',`time`='020301',`v1`=-1.379,`v2`=0.013,`v3`=-0.909,`v4`=-0.045,`v5`=6.2,`t`=20.6,`h`=60.3,`rssi`=227,`ccid`='4600485905031420000099m9990000000475000001g3870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687370643 WHERE `imei` = '868922055643643' [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012212s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230622' , '020301' , -1.379 , 0.013 , -0.909 , -0.045 , 6.2 , 20.6 , 60.3 , 227 , '4600485905031420000099m9990000000475000001g3870,N,00E000=-00.000' , 0 , 0 , 1687370643 , 1687370643) [ RunTime:0.001313s ] --------------------------------------------------------------- [ 2023-06-22T02:04:04+08:00 ] 223.104.255.133 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230622&time=020301&v1=-00.337&v2=+00.001&v3=+00.012&v4=+00.000&v5=06.0&t=+20.7&h=63.9&rssi=+222&ccid=4600485905031430000099m9990000000039000000g3570,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230622',`time`='020301',`v1`=-0.337,`v2`=0.001,`v3`=0.012,`v4`=0,`v5`=6,`t`=20.7,`h`=63.9,`rssi`=222,`ccid`='4600485905031430000099m9990000000039000000g3570,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687370644 WHERE `imei` = '868922055644013' [ RunTime:0.000517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009761s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '230622' , '020301' , -0.337 , 0.001 , 0.012 , 0 , 6 , 20.7 , 63.9 , 222 , '4600485905031430000099m9990000000039000000g3570,N,00E000=-00.000' , 0 , 0 , 1687370644 , 1687370644) [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2023-06-22T11:42:30+08:00 ] 39.144.6.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013814s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001379s ] --------------------------------------------------------------- [ 2023-06-22T11:42:31+08:00 ] 39.144.6.192 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1687405350&v1=0.030612&v2=0.013351&v3=0.032569&v4=0.001294&v5=12.240000&t=28.300758&h=78.960938&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010342s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1687405350,`v1`=0.030612,`v2`=0.013351,`v3`=0.032569,`v4`=0.001294,`v5`=12.24,`t`=28.300758,`h`=78.960938,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1687405351 WHERE `imei` = '868922055678110' [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012862s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1687405350 , 0.030612 , 0.013351 , 0.032569 , 0.001294 , 12.24 , 28.300758 , 78.960938 , 28 , '898604650119C1078513' , '460048590708513' , -0 , 1687405351) [ RunTime:0.001163s ] --------------------------------------------------------------- [ 2023-06-22T14:03:54+08:00 ] 117.132.197.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002580s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015009s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001382s ] --------------------------------------------------------------- [ 2023-06-22T14:03:55+08:00 ] 39.144.17.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011076s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-06-22T14:04:02+08:00 ] 117.132.197.144 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230622&time=140301&v1=-01.377&v2=+00.010&v3=-00.896&v4=-00.044&v5=06.4&t=+42.6&h=53.7&rssi=+228&ccid=4600485905031420000099m9990000000487000001g3830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001874s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000865s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230622',`time`='140301',`v1`=-1.377,`v2`=0.01,`v3`=-0.896,`v4`=-0.044,`v5`=6.4,`t`=42.6,`h`=53.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000487000001g3830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687413842 WHERE `imei` = '868922055643643' [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013021s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230622' , '140301' , -1.377 , 0.01 , -0.896 , -0.044 , 6.4 , 42.6 , 53.7 , 228 , '4600485905031420000099m9990000000487000001g3830,N,00E000=-00.000' , 0 , 0 , 1687413842 , 1687413842) [ RunTime:0.000872s ] --------------------------------------------------------------- [ 2023-06-22T14:04:03+08:00 ] 39.144.17.19 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230622&time=140301&v1=-00.378&v2=+00.001&v3=+00.020&v4=+00.002&v5=06.2&t=+42.0&h=58.1&rssi=+223&ccid=4600485905031430000099m9990000000050000000g4020,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001163s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230622',`time`='140301',`v1`=-0.378,`v2`=0.001,`v3`=0.02,`v4`=0.002,`v5`=6.2,`t`=42,`h`=58.1,`rssi`=223,`ccid`='4600485905031430000099m9990000000050000000g4020,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687413843 WHERE `imei` = '868922055644013' [ RunTime:0.000867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014046s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '230622' , '140301' , -0.378 , 0.001 , 0.02 , 0.002 , 6.2 , 42 , 58.1 , 223 , '4600485905031430000099m9990000000050000000g4020,N,00E000=-00.000' , 0 , 0 , 1687413843 , 1687413843) [ RunTime:0.000974s ] --------------------------------------------------------------- [ 2023-06-22T15:09:23+08:00 ] 39.144.5.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011867s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-06-22T15:09:24+08:00 ] 39.144.5.18 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1687417763&v1=0.017127&v2=0.014499&v3=0.015080&v4=-0.011769&v5=12.420000&t=28.858465&h=77.854675&rssi=27&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001886s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010118s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1687417763,`v1`=0.017127,`v2`=0.014499,`v3`=0.01508,`v4`=-0.011769,`v5`=12.42,`t`=28.858465,`h`=77.854675,`rssi`=27,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1687417764 WHERE `imei` = '868922055684548' [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011365s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1687417763 , 0.017127 , 0.014499 , 0.01508 , -0.011769 , 12.42 , 28.858465 , 77.854675 , 27 , '898604650119C1053137' , '460048590503137' , -0 , 1687417764) [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-06-22T17:20:56+08:00 ] 39.144.16.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013334s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-06-22T17:20:58+08:00 ] 39.144.16.60 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1687425656&v1=0.018391&v2=0.016063&v3=0.016405&v4=-0.000211&v5=12.240000&t=29.308918&h=78.648132&rssi=26&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185014,35.986556&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010741s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1687425656,`v1`=0.018391,`v2`=0.016063,`v3`=0.016405,`v4`=-0.000211,`v5`=12.24,`t`=29.308918,`h`=78.648132,`rssi`=26,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185014,35.986556',`update_time`=1687425658 WHERE `imei` = '868922055647586' [ RunTime:0.000835s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011743s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1687425656 , 0.018391 , 0.016063 , 0.016405 , -0.000211 , 12.24 , 29.308918 , 78.648132 , 26 , '898604650119C1078512' , '460048590708512' , -0 , '120.185014,35.986556' , 1687425658) [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-06-22T18:01:21+08:00 ] 117.132.194.105 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013191s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2023-06-22T18:01:22+08:00 ] 117.132.194.105 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1687428081&v1=0.027903&v2=0.014186&v3=0.029860&v4=0.015562&v5=12.240000&t=29.051516&h=76.771301&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184827,35.985833&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011602s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1687428081,`v1`=0.027903,`v2`=0.014186,`v3`=0.02986,`v4`=0.015562,`v5`=12.24,`t`=29.051516,`h`=76.771301,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184827,35.985833',`update_time`=1687428082 WHERE `imei` = '868922056976208' [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010911s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1687428081 , 0.027903 , 0.014186 , 0.02986 , 0.015562 , 12.24 , 29.051516 , 76.771301 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184827,35.985833' , 1687428082) [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-06-22T18:09:21+08:00 ] 117.132.195.131 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012288s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-06-22T18:09:22+08:00 ] 117.132.195.131 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1687428561&v1=0.021161&v2=0.013039&v3=0.017458&v4=-0.006833&v5=12.420000&t=29.169493&h=78.922791&rssi=25&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011552s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1687428561,`v1`=0.021161,`v2`=0.013039,`v3`=0.017458,`v4`=-0.006833,`v5`=12.42,`t`=29.169493,`h`=78.922791,`rssi`=25,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1687428562 WHERE `imei` = '868922055684209' [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011776s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1687428561 , 0.021161 , 0.013039 , 0.017458 , -0.006833 , 12.42 , 29.169493 , 78.922791 , 25 , '898604650119C1078511' , '460048590708511' , -0 , 1687428562) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-06-22T18:34:20+08:00 ] 117.132.195.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002290s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011939s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-06-22T18:34:21+08:00 ] 117.132.195.11 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1687430060&v1=0.019294&v2=0.014395&v3=0.016766&v4=-0.004726&v5=12.420000&t=28.954990&h=83.553833&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1687430060,`v1`=0.019294,`v2`=0.014395,`v3`=0.016766,`v4`=-0.004726,`v5`=12.42,`t`=28.95499,`h`=83.553833,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1687430061 WHERE `imei` = '868922055683920' [ RunTime:0.000591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011200s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1687430060 , 0.019294 , 0.014395 , 0.016766 , -0.004726 , 12.42 , 28.95499 , 83.553833 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1687430061) [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2023-06-22T21:18:59+08:00 ] 111.55.140.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.003204s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2023-06-22T21:19:00+08:00 ] 111.55.140.120 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1687439939&v1=0.032057&v2=0.016376&v3=0.029318&v4=0.007977&v5=12.420000&t=28.622513&h=82.050842&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184611,35.986574&end=$ [ 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.013095s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000929s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1687439939,`v1`=0.032057,`v2`=0.016376,`v3`=0.029318,`v4`=0.007977,`v5`=12.42,`t`=28.622513,`h`=82.050842,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184611,35.986574',`update_time`=1687439940 WHERE `imei` = '868922055683912' [ RunTime:0.001046s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012827s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1687439939 , 0.032057 , 0.016376 , 0.029318 , 0.007977 , 12.42 , 28.622513 , 82.050842 , 20 , '898604650119C1053138' , '460048590503138' , -0 , '120.184611,35.986574' , 1687439940) [ RunTime:0.001422s ] --------------------------------------------------------------- [ 2023-06-22T21:25:05+08:00 ] 39.144.6.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002283s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011024s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-06-22T21:25:06+08:00 ] 39.144.6.232 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687440305&v1=0.019776&v2=0.015125&v3=0.016164&v4=-0.017247&v5=12.420000&t=28.622513&h=82.989258&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184908,35.985076&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011260s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687440305,`v1`=0.019776,`v2`=0.015125,`v3`=0.016164,`v4`=-0.017247,`v5`=12.42,`t`=28.622513,`h`=82.989258,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184908,35.985076',`update_time`=1687440306 WHERE `imei` = '868922055683771' [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010612s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1687440305 , 0.019776 , 0.015125 , 0.016164 , -0.017247 , 12.42 , 28.622513 , 82.989258 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184908,35.985076' , 1687440306) [ RunTime:0.000490s ] --------------------------------------------------------------- [ 2023-06-22T22:04:50+08:00 ] 221.178.127.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011559s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2023-06-22T22:04:59+08:00 ] 221.178.127.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230622&time=220401&v1=-00.966&v2=+00.016&v3=-00.843&v4=-00.100&v5=06.0&t=+26.4&h=80.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.097&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010861s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230622',`time`='220401',`v1`=-0.966,`v2`=0.016,`v3`=-0.843,`v4`=-0.1,`v5`=6,`t`=26.4,`h`=80,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.097,`update_time`=1687442699 WHERE `imei` = '868922055684076' [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012228s ] [ 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' , '230622' , '220401' , -0.966 , 0.016 , -0.843 , -0.1 , 6 , 26.4 , 80 , 228 , '460044618415249' , -0 , 0.161 , 1.097 , 1687442699 , 1687442699) [ RunTime:0.000623s ]