--------------------------------------------------------------- [ 2023-06-13T00:15:23+08:00 ] 221.178.126.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012756s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000818s ] --------------------------------------------------------------- [ 2023-06-13T00:15:25+08:00 ] 221.178.126.1 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686586523&v1=0.021221&v2=0.013039&v3=0.018482&v4=-0.006171&v5=12.240000&t=25.437159&h=79.021973&rssi=27&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010409s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000814s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686586523,`v1`=0.021221,`v2`=0.013039,`v3`=0.018482,`v4`=-0.006171,`v5`=12.24,`t`=25.437159,`h`=79.021973,`rssi`=27,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1686586525 WHERE `imei` = '868922055680850' [ RunTime:0.000816s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010749s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1686586523 , 0.021221 , 0.013039 , 0.018482 , -0.006171 , 12.24 , 25.437159 , 79.021973 , 27 , '898604650119C1078510' , '460048590708510' , -0 , 1686586525) [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-06-13T02:03:54+08:00 ] 111.55.138.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-06-13T02:03:55+08:00 ] 218.204.252.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010136s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-06-13T02:04:03+08:00 ] 111.55.138.22 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230613&time=020301&v1=-01.393&v2=+00.013&v3=-01.018&v4=-00.043&v5=06.2&t=+20.4&h=59.5&rssi=+227&ccid=4600485905031420000099m9990000000379000001g4010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011035s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230613',`time`='020301',`v1`=-1.393,`v2`=0.013,`v3`=-1.018,`v4`=-0.043,`v5`=6.2,`t`=20.4,`h`=59.5,`rssi`=227,`ccid`='4600485905031420000099m9990000000379000001g4010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686593043 WHERE `imei` = '868922055643643' [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011215s ] [ 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' , '230613' , '020301' , -1.393 , 0.013 , -1.018 , -0.043 , 6.2 , 20.4 , 59.5 , 227 , '4600485905031420000099m9990000000379000001g4010,N,00E000=-00.000' , 0 , 0 , 1686593043 , 1686593043) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-06-13T02:04:04+08:00 ] 218.204.252.221 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230613&time=020301&v1=-00.424&v2=+00.001&v3=-00.001&v4=-00.001&v5=06.0&t=+20.8&h=62.8&rssi=+225&ccid=4600485905031430000099m9990000000038000000g4440,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009949s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230613',`time`='020301',`v1`=-0.424,`v2`=0.001,`v3`=-0.001,`v4`=-0.001,`v5`=6,`t`=20.8,`h`=62.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000038000000g4440,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686593044 WHERE `imei` = '868922055644013' [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010578s ] [ 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' , '230613' , '020301' , -0.424 , 0.001 , -0.001 , -0.001 , 6 , 20.8 , 62.8 , 225 , '4600485905031430000099m9990000000038000000g4440,N,00E000=-00.000' , 0 , 0 , 1686593044 , 1686593044) [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-06-13T11:33:30+08:00 ] 39.144.3.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003268s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001318s ] --------------------------------------------------------------- [ 2023-06-13T11:33:35+08:00 ] 39.144.3.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686627210&v1=0.030492&v2=0.011474&v3=0.029739&v4=0.001355&v5=12.240000&t=25.801811&h=79.121155&rssi=10&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010781s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686627210,`v1`=0.030492,`v2`=0.011474,`v3`=0.029739,`v4`=0.001355,`v5`=12.24,`t`=25.801811,`h`=79.121155,`rssi`=10,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686627215 WHERE `imei` = '868922055678110' [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013771s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686627210 , 0.030492 , 0.011474 , 0.029739 , 0.001355 , 12.24 , 25.801811 , 79.121155 , 10 , '898604650119C1078513' , '460048590708513' , -0 , 1686627215) [ RunTime:0.001390s ] --------------------------------------------------------------- [ 2023-06-13T14:03:54+08:00 ] 111.55.140.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011025s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.002531s ] --------------------------------------------------------------- [ 2023-06-13T14:03:55+08:00 ] 111.55.141.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-06-13T14:04:03+08:00 ] 111.55.140.106 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230613&time=140301&v1=-01.393&v2=+00.026&v3=-01.031&v4=-00.043&v5=06.4&t=+33.1&h=56.3&rssi=+225&ccid=4600485905031420000099m9990000000363000001g4000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011039s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230613',`time`='140301',`v1`=-1.393,`v2`=0.026,`v3`=-1.031,`v4`=-0.043,`v5`=6.4,`t`=33.1,`h`=56.3,`rssi`=225,`ccid`='4600485905031420000099m9990000000363000001g4000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686636243 WHERE `imei` = '868922055643643' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011998s ] [ 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' , '230613' , '140301' , -1.393 , 0.026 , -1.031 , -0.043 , 6.4 , 33.1 , 56.3 , 225 , '4600485905031420000099m9990000000363000001g4000,N,00E000=-00.000' , 0 , 0 , 1686636243 , 1686636243) [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-06-13T14:04:03+08:00 ] 111.55.141.159 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230613&time=140301&v1=-00.365&v2=+00.002&v3=+00.020&v4=+00.000&v5=06.2&t=+32.9&h=60.1&rssi=+223&ccid=4600485905031430000099m9990000000043000000g3860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012947s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230613',`time`='140301',`v1`=-0.365,`v2`=0.002,`v3`=0.02,`v4`=0,`v5`=6.2,`t`=32.9,`h`=60.1,`rssi`=223,`ccid`='4600485905031430000099m9990000000043000000g3860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686636243 WHERE `imei` = '868922055644013' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011149s ] [ 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' , '230613' , '140301' , -0.365 , 0.002 , 0.02 , 0 , 6.2 , 32.9 , 60.1 , 223 , '4600485905031430000099m9990000000043000000g3860,N,00E000=-00.000' , 0 , 0 , 1686636243 , 1686636243) [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2023-06-13T15:00:25+08:00 ] 111.55.141.203 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002696s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011745s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2023-06-13T15:00:26+08:00 ] 111.55.141.203 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686639625&v1=0.016946&v2=0.014707&v3=0.014388&v4=-0.011890&v5=12.420000&t=25.297731&h=78.075928&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010351s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686639625,`v1`=0.016946,`v2`=0.014707,`v3`=0.014388,`v4`=-0.01189,`v5`=12.42,`t`=25.297731,`h`=78.075928,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686639626 WHERE `imei` = '868922055684548' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012395s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686639625 , 0.016946 , 0.014707 , 0.014388 , -0.01189 , 12.42 , 25.297731 , 78.075928 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1686639626) [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-06-13T17:12:02+08:00 ] 39.144.15.96 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012559s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-06-13T17:12:04+08:00 ] 39.144.15.96 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686647522&v1=0.018090&v2=0.014603&v3=0.015110&v4=-0.000030&v5=12.420000&t=25.984138&h=79.250854&rssi=-152&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185574,35.986399&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011565s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686647522,`v1`=0.01809,`v2`=0.014603,`v3`=0.01511,`v4`=-3.0E-5,`v5`=12.42,`t`=25.984138,`h`=79.250854,`rssi`=-152,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185574,35.986399',`update_time`=1686647524 WHERE `imei` = '868922055647586' [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011456s ] [ 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' , 1686647522 , 0.01809 , 0.014603 , 0.01511 , -3.0E-5 , 12.42 , 25.984138 , 79.250854 , -152 , '898604650119C1078512' , '460048590708512' , -0 , '120.185574,35.986399' , 1686647524) [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-06-13T17:53:24+08:00 ] 111.55.139.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.003176s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012880s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000898s ] --------------------------------------------------------------- [ 2023-06-13T17:53:25+08:00 ] 111.55.139.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686650004&v1=0.027060&v2=0.012621&v3=0.027241&v4=0.015682&v5=12.240000&t=25.919788&h=77.343506&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184992,35.986141&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010882s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686650004,`v1`=0.02706,`v2`=0.012621,`v3`=0.027241,`v4`=0.015682,`v5`=12.24,`t`=25.919788,`h`=77.343506,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184992,35.986141',`update_time`=1686650005 WHERE `imei` = '868922056976208' [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012362s ] [ 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' , 1686650004 , 0.02706 , 0.012621 , 0.027241 , 0.015682 , 12.24 , 25.919788 , 77.343506 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184992,35.986141' , 1686650005) [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-06-13T18:00:21+08:00 ] 39.144.14.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011933s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-06-13T18:00:23+08:00 ] 39.144.14.5 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686650421&v1=0.020799&v2=0.014603&v3=0.016886&v4=-0.006953&v5=12.420000&t=26.005589&h=79.426331&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003082s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001125s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686650421,`v1`=0.020799,`v2`=0.014603,`v3`=0.016886,`v4`=-0.006953,`v5`=12.42,`t`=26.005589,`h`=79.426331,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686650423 WHERE `imei` = '868922055684209' [ RunTime:0.000852s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014464s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686650421 , 0.020799 , 0.014603 , 0.016886 , -0.006953 , 12.42 , 26.005589 , 79.426331 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1686650423) [ RunTime:0.000870s ] --------------------------------------------------------------- [ 2023-06-13T18:25:20+08:00 ] 117.132.193.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2023-06-13T18:25:21+08:00 ] 117.132.193.149 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686651920&v1=0.019114&v2=0.014707&v3=0.016284&v4=-0.004726&v5=12.420000&t=25.898338&h=83.340210&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012576s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686651920,`v1`=0.019114,`v2`=0.014707,`v3`=0.016284,`v4`=-0.004726,`v5`=12.42,`t`=25.898338,`h`=83.34021,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686651921 WHERE `imei` = '868922055683920' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011714s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686651920 , 0.019114 , 0.014707 , 0.016284 , -0.004726 , 12.42 , 25.898338 , 83.34021 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686651921) [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-06-13T21:10:24+08:00 ] 111.55.139.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012249s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-06-13T21:10:25+08:00 ] 111.55.139.122 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686661824&v1=0.031274&v2=0.012517&v3=0.028926&v4=0.008217&v5=12.420000&t=25.673111&h=81.890625&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000781s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686661824,`v1`=0.031274,`v2`=0.012517,`v3`=0.028926,`v4`=0.008217,`v5`=12.42,`t`=25.673111,`h`=81.890625,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1686661825 WHERE `imei` = '868922055683912' [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013379s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1686661824 , 0.031274 , 0.012517 , 0.028926 , 0.008217 , 12.42 , 25.673111 , 81.890625 , 18 , '898604650119C1053138' , '460048590503138' , -0 , 1686661825) [ RunTime:0.001296s ] --------------------------------------------------------------- [ 2023-06-13T21:17:03+08:00 ] 117.132.197.113 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010587s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000939s ] --------------------------------------------------------------- [ 2023-06-13T21:17:04+08:00 ] 117.132.197.113 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686662223&v1=0.019656&v2=0.014499&v3=0.016074&v4=-0.017067&v5=12.420000&t=25.651661&h=82.829041&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184737,35.985465&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011106s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000815s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686662223,`v1`=0.019656,`v2`=0.014499,`v3`=0.016074,`v4`=-0.017067,`v5`=12.42,`t`=25.651661,`h`=82.829041,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184737,35.985465',`update_time`=1686662224 WHERE `imei` = '868922055683771' [ RunTime:0.000961s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011390s ] [ 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' , 1686662223 , 0.019656 , 0.014499 , 0.016074 , -0.017067 , 12.42 , 25.651661 , 82.829041 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.184737,35.985465' , 1686662224) [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-06-13T22:10:51+08:00 ] 39.144.15.218 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012578s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-06-13T22:10:59+08:00 ] 39.144.15.218 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230613&time=221001&v1=-01.177&v2=+00.015&v3=-01.050&v4=-00.232&v5=06.0&t=+21.4&h=78.8&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.239&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011155s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230613',`time`='221001',`v1`=-1.177,`v2`=0.015,`v3`=-1.05,`v4`=-0.232,`v5`=6,`t`=21.4,`h`=78.8,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.239,`update_time`=1686665459 WHERE `imei` = '868922055684076' [ RunTime:0.000581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011710s ] [ 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' , '230613' , '221001' , -1.177 , 0.015 , -1.05 , -0.232 , 6 , 21.4 , 78.8 , 227 , '460044618415249' , -0 , 0.156 , 1.239 , 1686665459 , 1686665459) [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-06-13T23:55:23+08:00 ] 39.144.10.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003027s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012276s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2023-06-13T23:55:25+08:00 ] 39.144.10.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686671723&v1=0.007555&v2=0.014499&v3=0.005057&v4=-0.015863&v5=12.420000&t=25.490784&h=80.914063&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010331s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686671723,`v1`=0.007555,`v2`=0.014499,`v3`=0.005057,`v4`=-0.015863,`v5`=12.42,`t`=25.490784,`h`=80.914063,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686671725 WHERE `imei` = '868922055644021' [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009881s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686671723 , 0.007555 , 0.014499 , 0.005057 , -0.015863 , 12.42 , 25.490784 , 80.914063 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686671725) [ RunTime:0.000617s ]