--------------------------------------------------------------- [ 2023-06-11T00:13:23+08:00 ] 39.144.14.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.021267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.018770s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.001159s ] --------------------------------------------------------------- [ 2023-06-11T00:13:25+08:00 ] 39.144.14.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686413603&v1=0.021582&v2=0.013977&v3=0.018722&v4=-0.006171&v5=12.240000&t=25.340631&h=79.037231&rssi=27&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185118,35.985660&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] 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` = '868922055680850' LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686413603,`v1`=0.021582,`v2`=0.013977,`v3`=0.018722,`v4`=-0.006171,`v5`=12.24,`t`=25.340631,`h`=79.037231,`rssi`=27,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185118,35.985660',`update_time`=1686413605 WHERE `imei` = '868922055680850' [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012904s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1686413603 , 0.021582 , 0.013977 , 0.018722 , -0.006171 , 12.24 , 25.340631 , 79.037231 , 27 , '898604650119C1078510' , '460048590708510' , -0 , '120.185118,35.985660' , 1686413605) [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-06-11T02:03:54+08:00 ] 223.104.255.193 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.004168s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001091s ] --------------------------------------------------------------- [ 2023-06-11T02:03:55+08:00 ] 39.144.12.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002007s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012179s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-06-11T02:04:03+08:00 ] 223.104.255.193 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230611&time=020301&v1=-01.388&v2=+00.012&v3=-01.033&v4=-00.043&v5=06.2&t=+17.8&h=60.6&rssi=+229&ccid=4600485905031420000099m9990000000357000001g3960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230611',`time`='020301',`v1`=-1.388,`v2`=0.012,`v3`=-1.033,`v4`=-0.043,`v5`=6.2,`t`=17.8,`h`=60.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000357000001g3960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686420243 WHERE `imei` = '868922055643643' [ RunTime:0.000721s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012518s ] [ 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' , '230611' , '020301' , -1.388 , 0.012 , -1.033 , -0.043 , 6.2 , 17.8 , 60.6 , 229 , '4600485905031420000099m9990000000357000001g3960,N,00E000=-00.000' , 0 , 0 , 1686420243 , 1686420243) [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-06-11T02:04:04+08:00 ] 39.144.12.182 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230611&time=020301&v1=-00.467&v2=+00.001&v3=-00.182&v4=-00.001&v5=06.0&t=+18.1&h=63.5&rssi=+222&ccid=4600485905031430000099m9990000000047000000g4790,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002346s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011905s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230611',`time`='020301',`v1`=-0.467,`v2`=0.001,`v3`=-0.182,`v4`=-0.001,`v5`=6,`t`=18.1,`h`=63.5,`rssi`=222,`ccid`='4600485905031430000099m9990000000047000000g4790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686420244 WHERE `imei` = '868922055644013' [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009616s ] [ 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' , '230611' , '020301' , -0.467 , 0.001 , -0.182 , -0.001 , 6 , 18.1 , 63.5 , 222 , '4600485905031430000099m9990000000047000000g4790,N,00E000=-00.000' , 0 , 0 , 1686420244 , 1686420244) [ RunTime:0.000510s ] --------------------------------------------------------------- [ 2023-06-11T11:31:28+08:00 ] 39.144.7.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011940s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001313s ] --------------------------------------------------------------- [ 2023-06-11T11:31:30+08:00 ] 39.144.7.34 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686454288&v1=0.030492&v2=0.014186&v3=0.026518&v4=0.001234&v5=12.420000&t=25.801811&h=79.090637&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010696s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686454288,`v1`=0.030492,`v2`=0.014186,`v3`=0.026518,`v4`=0.001234,`v5`=12.42,`t`=25.801811,`h`=79.090637,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686454290 WHERE `imei` = '868922055678110' [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014135s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686454288 , 0.030492 , 0.014186 , 0.026518 , 0.001234 , 12.42 , 25.801811 , 79.090637 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1686454290) [ RunTime:0.004157s ] --------------------------------------------------------------- [ 2023-06-11T14:03:54+08:00 ] 39.144.9.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011603s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001303s ] --------------------------------------------------------------- [ 2023-06-11T14:03:55+08:00 ] 117.132.194.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011943s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000970s ] --------------------------------------------------------------- [ 2023-06-11T14:04:02+08:00 ] 39.144.9.109 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230611&time=140301&v1=-01.387&v2=+00.014&v3=-00.999&v4=-00.043&v5=06.4&t=+38.2&h=54.3&rssi=+230&ccid=4600485905031420000099m9990000000389000001g3940,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001875s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009988s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230611',`time`='140301',`v1`=-1.387,`v2`=0.014,`v3`=-0.999,`v4`=-0.043,`v5`=6.4,`t`=38.2,`h`=54.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000389000001g3940,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686463442 WHERE `imei` = '868922055643643' [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012611s ] [ 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' , '230611' , '140301' , -1.387 , 0.014 , -0.999 , -0.043 , 6.4 , 38.2 , 54.3 , 230 , '4600485905031420000099m9990000000389000001g3940,N,00E000=-00.000' , 0 , 0 , 1686463442 , 1686463442) [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2023-06-11T14:04:03+08:00 ] 117.132.194.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230611&time=140301&v1=-00.471&v2=+00.001&v3=+00.019&v4=+00.000&v5=06.2&t=+35.0&h=59.9&rssi=+223&ccid=4600485905031430000099m9990000000046000000g4850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230611',`time`='140301',`v1`=-0.471,`v2`=0.001,`v3`=0.019,`v4`=0,`v5`=6.2,`t`=35,`h`=59.9,`rssi`=223,`ccid`='4600485905031430000099m9990000000046000000g4850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686463443 WHERE `imei` = '868922055644013' [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011421s ] [ 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' , '230611' , '140301' , -0.471 , 0.001 , 0.019 , 0 , 6.2 , 35 , 59.9 , 223 , '4600485905031430000099m9990000000046000000g4850,N,00E000=-00.000' , 0 , 0 , 1686463443 , 1686463443) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-06-11T14:58:22+08:00 ] 39.144.4.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010782s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-06-11T14:58:24+08:00 ] 39.144.4.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686466702&v1=0.016766&v2=0.015020&v3=0.014508&v4=-0.011709&v5=12.420000&t=26.069939&h=77.816528&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002042s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010731s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686466702,`v1`=0.016766,`v2`=0.01502,`v3`=0.014508,`v4`=-0.011709,`v5`=12.42,`t`=26.069939,`h`=77.816528,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686466704 WHERE `imei` = '868922055684548' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012205s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686466702 , 0.016766 , 0.01502 , 0.014508 , -0.011709 , 12.42 , 26.069939 , 77.816528 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1686466704) [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-06-11T17:10:25+08:00 ] 39.144.6.242 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002529s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012530s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-06-11T17:10:26+08:00 ] 39.144.6.242 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686474625&v1=0.018512&v2=0.015125&v3=0.015171&v4=-0.000030&v5=12.240000&t=26.177191&h=79.319519&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185083,35.985480&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001948s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010644s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686474625,`v1`=0.018512,`v2`=0.015125,`v3`=0.015171,`v4`=-3.0E-5,`v5`=12.24,`t`=26.177191,`h`=79.319519,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185083,35.985480',`update_time`=1686474626 WHERE `imei` = '868922055647586' [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011488s ] [ 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' , 1686474625 , 0.018512 , 0.015125 , 0.015171 , -3.0E-5 , 12.24 , 26.177191 , 79.319519 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.185083,35.985480' , 1686474626) [ RunTime:0.000944s ] --------------------------------------------------------------- [ 2023-06-11T17:50:59+08:00 ] 111.55.141.212 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-06-11T17:51:00+08:00 ] 111.55.141.212 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686477059&v1=0.027421&v2=0.014812&v3=0.027361&v4=0.015742&v5=12.240000&t=26.005589&h=77.358765&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185129,35.987412&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010761s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686477059,`v1`=0.027421,`v2`=0.014812,`v3`=0.027361,`v4`=0.015742,`v5`=12.24,`t`=26.005589,`h`=77.358765,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185129,35.987412',`update_time`=1686477060 WHERE `imei` = '868922056976208' [ RunTime:0.000818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011259s ] [ 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' , 1686477059 , 0.027421 , 0.014812 , 0.027361 , 0.015742 , 12.24 , 26.005589 , 77.358765 , 26 , '898604650119C1053139' , '460048590503139' , -0 , '120.185129,35.987412' , 1686477060) [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-06-11T17:58:21+08:00 ] 223.104.255.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011616s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-06-11T17:58:22+08:00 ] 223.104.255.107 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686477501&v1=0.020980&v2=0.013456&v3=0.016946&v4=-0.006833&v5=12.420000&t=26.048489&h=79.456848&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014359s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686477501,`v1`=0.02098,`v2`=0.013456,`v3`=0.016946,`v4`=-0.006833,`v5`=12.42,`t`=26.048489,`h`=79.456848,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686477502 WHERE `imei` = '868922055684209' [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022330s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686477501 , 0.02098 , 0.013456 , 0.016946 , -0.006833 , 12.42 , 26.048489 , 79.456848 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1686477502) [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2023-06-11T18:23:21+08:00 ] 39.144.10.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010997s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000758s ] --------------------------------------------------------------- [ 2023-06-11T18:23:22+08:00 ] 39.144.10.97 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686479001&v1=0.019054&v2=0.013873&v3=0.016344&v4=-0.004425&v5=12.420000&t=25.887611&h=83.233398&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011811s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686479001,`v1`=0.019054,`v2`=0.013873,`v3`=0.016344,`v4`=-0.004425,`v5`=12.42,`t`=25.887611,`h`=83.233398,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686479002 WHERE `imei` = '868922055683920' [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012364s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686479001 , 0.019054 , 0.013873 , 0.016344 , -0.004425 , 12.42 , 25.887611 , 83.233398 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686479002) [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-06-11T21:08:23+08:00 ] 117.132.192.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012453s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2023-06-11T21:08:24+08:00 ] 117.132.192.224 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686488903&v1=0.031876&v2=0.014290&v3=0.028957&v4=0.008157&v5=12.420000&t=25.555134&h=81.837219&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001861s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686488903,`v1`=0.031876,`v2`=0.01429,`v3`=0.028957,`v4`=0.008157,`v5`=12.42,`t`=25.555134,`h`=81.837219,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1686488904 WHERE `imei` = '868922055683912' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012101s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1686488903 , 0.031876 , 0.01429 , 0.028957 , 0.008157 , 12.42 , 25.555134 , 81.837219 , 18 , '898604650119C1053138' , '460048590503138' , -0 , 1686488904) [ RunTime:0.000608s ] --------------------------------------------------------------- [ 2023-06-11T21:15:24+08:00 ] 111.55.141.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012623s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000771s ] --------------------------------------------------------------- [ 2023-06-11T21:15:25+08:00 ] 111.55.141.226 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686489324&v1=0.019535&v2=0.015229&v3=0.016043&v4=-0.017368&v5=12.420000&t=25.565859&h=82.699341&rssi=26&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185104,35.985687&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002032s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011067s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686489324,`v1`=0.019535,`v2`=0.015229,`v3`=0.016043,`v4`=-0.017368,`v5`=12.42,`t`=25.565859,`h`=82.699341,`rssi`=26,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185104,35.985687',`update_time`=1686489325 WHERE `imei` = '868922055683771' [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011084s ] [ 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' , 1686489324 , 0.019535 , 0.015229 , 0.016043 , -0.017368 , 12.42 , 25.565859 , 82.699341 , 26 , '898604650119C1053136' , '460048590503136' , -0 , '120.185104,35.985687' , 1686489325) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-06-11T22:12:50+08:00 ] 39.144.6.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2023-06-11T22:12:58+08:00 ] 39.144.6.249 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230611&time=221201&v1=-01.148&v2=+00.014&v3=-01.022&v4=-00.216&v5=06.0&t=+20.7&h=79.3&rssi=+221&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.218&a3=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.011480s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230611',`time`='221201',`v1`=-1.148,`v2`=0.014,`v3`=-1.022,`v4`=-0.216,`v5`=6,`t`=20.7,`h`=79.3,`rssi`=221,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.218,`update_time`=1686492778 WHERE `imei` = '868922055684076' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010630s ] [ 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' , '230611' , '221201' , -1.148 , 0.014 , -1.022 , -0.216 , 6 , 20.7 , 79.3 , 221 , '460044618415249' , -0 , 0.157 , 1.218 , 1686492778 , 1686492778) [ RunTime:0.000610s ] --------------------------------------------------------------- [ 2023-06-11T23:53:23+08:00 ] 218.204.252.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002691s ] 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.000686s ] --------------------------------------------------------------- [ 2023-06-11T23:53:25+08:00 ] 218.204.252.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686498803&v1=0.007676&v2=0.015333&v3=0.004997&v4=-0.016043&v5=12.420000&t=25.340631&h=80.845398&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001847s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012207s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686498803,`v1`=0.007676,`v2`=0.015333,`v3`=0.004997,`v4`=-0.016043,`v5`=12.42,`t`=25.340631,`h`=80.845398,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686498805 WHERE `imei` = '868922055644021' [ RunTime:0.000732s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012085s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686498803 , 0.007676 , 0.015333 , 0.004997 , -0.016043 , 12.42 , 25.340631 , 80.845398 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1686498805) [ RunTime:0.000638s ]