---------------------------------------------------------------
[ 2023-07-14T00:25:23+08:00 ] 111.55.136.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014205s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000759s ]
---------------------------------------------------------------
[ 2023-07-14T00:25:25+08:00 ] 111.55.136.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1689265523&v1=0.008157&v2=0.013456&v3=0.007615&v4=-0.015803&v5=12.240000&t=30.252728&h=81.722778&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011030s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1689265523,`v1`=0.008157,`v2`=0.013456,`v3`=0.007615,`v4`=-0.015803,`v5`=12.24,`t`=30.252728,`h`=81.722778,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1689265525  WHERE  `imei` = '868922055644021' [ RunTime:0.000644s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012381s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1689265523 , 0.008157 , 0.013456 , 0.007615 , -0.015803 , 12.24 , 30.252728 , 81.722778 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1689265525) [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2023-07-14T00:45:23+08:00 ] 39.144.1.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014330s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000904s ]
---------------------------------------------------------------
[ 2023-07-14T00:45:24+08:00 ] 39.144.1.87 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1689266723&v1=0.021763&v2=0.013560&v3=0.019926&v4=-0.006231&v5=12.240000&t=30.220552&h=78.815979&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010169s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.001871s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055680850',`create_time`=1689266723,`v1`=0.021763,`v2`=0.01356,`v3`=0.019926,`v4`=-0.006231,`v5`=12.24,`t`=30.220552,`h`=78.815979,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1689266724  WHERE  `imei` = '868922055680850' [ RunTime:0.000778s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011961s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1689266723 , 0.021763 , 0.01356 , 0.019926 , -0.006231 , 12.24 , 30.220552 , 78.815979 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1689266724) [ RunTime:0.001662s ]
---------------------------------------------------------------
[ 2023-07-14T02:03:54+08:00 ] 117.132.197.235 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ 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.011508s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000729s ]
---------------------------------------------------------------
[ 2023-07-14T02:03:55+08:00 ] 39.144.16.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010236s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-07-14T02:04:03+08:00 ] 117.132.197.235 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230714&time=020301&v1=-01.318&v2=+00.025&v3=-01.023&v4=-00.026&v5=06.2&t=+26.7&h=60.8&rssi=+227&ccid=4600485905031420000099m9990000000303000001g3240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.015003s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010175s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000650s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230714',`time`='020301',`v1`=-1.318,`v2`=0.025,`v3`=-1.023,`v4`=-0.026,`v5`=6.2,`t`=26.7,`h`=60.8,`rssi`=227,`ccid`='4600485905031420000099m9990000000303000001g3240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689271443  WHERE  `imei` = '868922055643643' [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010965s ]
[ 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' , '230714' , '020301' , -1.318 , 0.025 , -1.023 , -0.026 , 6.2 , 26.7 , 60.8 , 227 , '4600485905031420000099m9990000000303000001g3240,N,00E000=-00.000' , 0 , 0 , 1689271443 , 1689271443) [ RunTime:0.000636s ]
---------------------------------------------------------------
[ 2023-07-14T02:04:04+08:00 ] 39.144.16.125 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230714&time=020301&v1=-00.148&v2=+00.001&v3=-00.089&v4=+00.085&v5=06.0&t=+26.9&h=64.4&rssi=+224&ccid=4600485905031430000099m9990000000119000000g2190,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001557s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009993s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000650s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230714',`time`='020301',`v1`=-0.148,`v2`=0.001,`v3`=-0.089,`v4`=0.085,`v5`=6,`t`=26.9,`h`=64.4,`rssi`=224,`ccid`='4600485905031430000099m9990000000119000000g2190,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689271444  WHERE  `imei` = '868922055644013' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010216s ]
[ 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' , '230714' , '020301' , -0.148 , 0.001 , -0.089 , 0.085 , 6 , 26.9 , 64.4 , 224 , '4600485905031430000099m9990000000119000000g2190,N,00E000=-00.000' , 0 , 0 , 1689271444 , 1689271444) [ RunTime:0.000544s ]
---------------------------------------------------------------
[ 2023-07-14T02:05:50+08:00 ] 221.178.126.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010819s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2023-07-14T02:05:59+08:00 ] 221.178.126.38 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230714&time=020501&v1=-01.200&v2=+00.020&v3=-01.096&v4=-00.612&v5=06.0&t=+27.2&h=77.2&rssi=+231&imsi=460044618415249&v6=-00.000&a1=00.123&a2=01.242&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002185s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010794s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230714',`time`='020501',`v1`=-1.2,`v2`=0.02,`v3`=-1.096,`v4`=-0.612,`v5`=6,`t`=27.2,`h`=77.2,`rssi`=231,`imsi`='460044618415249',`v6`=-0,`a1`=0.123,`a2`=1.242,`update_time`=1689271558  WHERE  `imei` = '868922055684076' [ RunTime:0.000551s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012191s ]
[ 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' , '230714' , '020501' , -1.2 , 0.02 , -1.096 , -0.612 , 6 , 27.2 , 77.2 , 231 , '460044618415249' , -0 , 0.123 , 1.242 , 1689271559 , 1689271559) [ RunTime:0.000563s ]
---------------------------------------------------------------
[ 2023-07-14T08:42:08+08:00 ] 124.129.68.88 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000680s ]
---------------------------------------------------------------
[ 2023-07-14T08:42:12+08:00 ] 124.129.68.88 GET /admin/thermocouple/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.012262s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000399s ]
[ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000417s ]
[ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000429s ]
---------------------------------------------------------------
[ 2023-07-14T08:42:21+08:00 ] 124.129.68.88 GET /admin/shelves/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_shelves` [ RunTime:0.014076s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_shelves` LIMIT 1 [ RunTime:0.000421s ]
[ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000635s ]
[ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC [ RunTime:0.000562s ]
---------------------------------------------------------------
[ 2023-07-14T08:42:26+08:00 ] 124.129.68.88 GET /admin/thermocouple/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001854s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.011227s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000434s ]
[ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000362s ]
[ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000422s ]
---------------------------------------------------------------
[ 2023-07-14T12:04:27+08:00 ] 117.132.198.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002888s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014712s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001369s ]
---------------------------------------------------------------
[ 2023-07-14T12:04:29+08:00 ] 117.132.198.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1689307467&v1=0.030793&v2=0.015542&v3=0.040214&v4=0.001294&v5=12.240000&t=30.853333&h=79.426331&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010624s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000871s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055678110',`create_time`=1689307467,`v1`=0.030793,`v2`=0.015542,`v3`=0.040214,`v4`=0.001294,`v5`=12.24,`t`=30.853333,`h`=79.426331,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1689307469  WHERE  `imei` = '868922055678110' [ RunTime:0.001818s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015040s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1689307467 , 0.030793 , 0.015542 , 0.040214 , 0.001294 , 12.24 , 30.853333 , 79.426331 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1689307469) [ RunTime:0.001380s ]
---------------------------------------------------------------
[ 2023-07-14T14:03:54+08:00 ] 39.144.16.82 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002280s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012025s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001298s ]
---------------------------------------------------------------
[ 2023-07-14T14:03:55+08:00 ] 39.144.11.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009895s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000702s ]
---------------------------------------------------------------
[ 2023-07-14T14:04:03+08:00 ] 39.144.16.82 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230714&time=140301&v1=-01.317&v2=+00.048&v3=-01.018&v4=-00.026&v5=06.4&t=+40.3&h=56.3&rssi=+230&ccid=4600485905031420000099m9990000000303000001g3220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009987s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000680s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230714',`time`='140301',`v1`=-1.317,`v2`=0.048,`v3`=-1.018,`v4`=-0.026,`v5`=6.4,`t`=40.3,`h`=56.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000303000001g3220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689314643  WHERE  `imei` = '868922055643643' [ RunTime:0.000610s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013059s ]
[ 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' , '230714' , '140301' , -1.317 , 0.048 , -1.018 , -0.026 , 6.4 , 40.3 , 56.3 , 230 , '4600485905031420000099m9990000000303000001g3220,N,00E000=-00.000' , 0 , 0 , 1689314643 , 1689314643) [ RunTime:0.000643s ]
---------------------------------------------------------------
[ 2023-07-14T14:04:04+08:00 ] 39.144.11.90 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230714&time=140301&v1=+00.164&v2=+00.001&v3=+00.189&v4=+00.162&v5=06.2&t=+39.5&h=60.7&rssi=+225&ccid=4600485905031430000099m9990000000021000000g1140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010995s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000908s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230714',`time`='140301',`v1`=0.164,`v2`=0.001,`v3`=0.189,`v4`=0.162,`v5`=6.2,`t`=39.5,`h`=60.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000021000000g1140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689314644  WHERE  `imei` = '868922055644013' [ RunTime:0.000669s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011644s ]
[ 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' , '230714' , '140301' , 0.164 , 0.001 , 0.189 , 0.162 , 6.2 , 39.5 , 60.7 , 225 , '4600485905031430000099m9990000000021000000g1140,N,00E000=-00.000' , 0 , 0 , 1689314644 , 1689314644) [ RunTime:0.000560s ]
---------------------------------------------------------------
[ 2023-07-14T14:55:13+08:00 ] 124.129.68.88 GET /admin/thermocouple/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.011953s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000409s ]
[ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000473s ]
[ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000439s ]
---------------------------------------------------------------
[ 2023-07-14T15:31:23+08:00 ] 218.204.253.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ 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.010983s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000794s ]
---------------------------------------------------------------
[ 2023-07-14T15:31:25+08:00 ] 218.204.253.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1689319883&v1=0.017187&v2=0.013873&v3=0.017127&v4=-0.011589&v5=12.420000&t=30.553030&h=79.006714&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&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.010089s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000758s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1689319883,`v1`=0.017187,`v2`=0.013873,`v3`=0.017127,`v4`=-0.011589,`v5`=12.42,`t`=30.55303,`h`=79.006714,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1689319885  WHERE  `imei` = '868922055684548' [ RunTime:0.000981s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010879s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1689319883 , 0.017187 , 0.013873 , 0.017127 , -0.011589 , 12.42 , 30.55303 , 79.006714 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1689319885) [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2023-07-14T17:42:23+08:00 ] 39.144.15.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012731s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000859s ]
---------------------------------------------------------------
[ 2023-07-14T17:42:25+08:00 ] 39.144.15.190 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1689327743&v1=0.018512&v2=0.013664&v3=0.018391&v4=-0.000151&v5=12.420000&t=31.217985&h=78.815979&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185003,35.985739&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011580s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000737s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055647586',`create_time`=1689327743,`v1`=0.018512,`v2`=0.013664,`v3`=0.018391,`v4`=-0.000151,`v5`=12.42,`t`=31.217985,`h`=78.815979,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185003,35.985739',`update_time`=1689327745  WHERE  `imei` = '868922055647586' [ RunTime:0.000675s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011713s ]
[ 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' , 1689327743 , 0.018512 , 0.013664 , 0.018391 , -0.000151 , 12.42 , 31.217985 , 78.815979 , 28 , '898604650119C1078512' , '460048590708512' , -0 , '120.185003,35.985739' , 1689327745) [ RunTime:0.000722s ]
---------------------------------------------------------------
[ 2023-07-14T18:23:23+08:00 ] 117.132.192.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010583s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000754s ]
---------------------------------------------------------------
[ 2023-07-14T18:23:24+08:00 ] 117.132.192.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1689330203&v1=0.027301&v2=0.014082&v3=0.036421&v4=0.015441&v5=12.240000&t=31.014210&h=76.847595&rssi=29&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011283s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000738s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1689330203,`v1`=0.027301,`v2`=0.014082,`v3`=0.036421,`v4`=0.015441,`v5`=12.24,`t`=31.01421,`h`=76.847595,`rssi`=29,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1689330204  WHERE  `imei` = '868922056976208' [ RunTime:0.000772s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013494s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1689330203 , 0.027301 , 0.014082 , 0.036421 , 0.015441 , 12.24 , 31.01421 , 76.847595 , 29 , '898604650119C1053139' , '460048590503139' , -0 , 1689330204) [ RunTime:0.000694s ]
---------------------------------------------------------------
[ 2023-07-14T18:31:23+08:00 ] 117.132.195.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009618s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000718s ]
---------------------------------------------------------------
[ 2023-07-14T18:31:24+08:00 ] 117.132.195.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1689330683&v1=0.021462&v2=0.013977&v3=0.018843&v4=-0.006712&v5=12.420000&t=31.132185&h=78.945679&rssi=25&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010439s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000735s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1689330683,`v1`=0.021462,`v2`=0.013977,`v3`=0.018843,`v4`=-0.006712,`v5`=12.42,`t`=31.132185,`h`=78.945679,`rssi`=25,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1689330684  WHERE  `imei` = '868922055684209' [ RunTime:0.000650s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009018s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1689330683 , 0.021462 , 0.013977 , 0.018843 , -0.006712 , 12.42 , 31.132185 , 78.945679 , 25 , '898604650119C1078511' , '460048590708511' , -0 , 1689330684) [ RunTime:0.000518s ]
---------------------------------------------------------------
[ 2023-07-14T18:56:21+08:00 ] 39.144.15.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013471s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000785s ]
---------------------------------------------------------------
[ 2023-07-14T18:56:23+08:00 ] 39.144.15.150 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1689332181&v1=0.019234&v2=0.015020&v3=0.018331&v4=-0.004605&v5=12.420000&t=30.874783&h=84.759277&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009789s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000704s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1689332181,`v1`=0.019234,`v2`=0.01502,`v3`=0.018331,`v4`=-0.004605,`v5`=12.42,`t`=30.874783,`h`=84.759277,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1689332183  WHERE  `imei` = '868922055683920' [ RunTime:0.000653s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011270s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1689332181 , 0.019234 , 0.01502 , 0.018331 , -0.004605 , 12.42 , 30.874783 , 84.759277 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1689332183) [ RunTime:0.001312s ]
---------------------------------------------------------------
[ 2023-07-14T21:34:56+08:00 ] 39.144.7.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002271s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013366s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000707s ]
---------------------------------------------------------------
[ 2023-07-14T21:34:57+08:00 ] 39.144.7.252 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1689341696&v1=0.032358&v2=0.013873&v3=0.034826&v4=0.007736&v5=12.420000&t=30.917683&h=83.149475&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185207,35.985551&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009973s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000642s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1689341696,`v1`=0.032358,`v2`=0.013873,`v3`=0.034826,`v4`=0.007736,`v5`=12.42,`t`=30.917683,`h`=83.149475,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185207,35.985551',`update_time`=1689341697  WHERE  `imei` = '868922055683912' [ RunTime:0.000619s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010536s ]
[ 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' , 1689341696 , 0.032358 , 0.013873 , 0.034826 , 0.007736 , 12.42 , 30.917683 , 83.149475 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185207,35.985551' , 1689341697) [ RunTime:0.000644s ]
---------------------------------------------------------------
[ 2023-07-14T21:45:56+08:00 ] 39.144.8.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013581s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000735s ]
---------------------------------------------------------------
[ 2023-07-14T21:45:57+08:00 ] 39.144.8.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1689342356&v1=0.019716&v2=0.013977&v3=0.017639&v4=-0.017247&v5=12.420000&t=30.949858&h=84.148926&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185133,35.985800&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001680s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010903s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000656s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1689342356,`v1`=0.019716,`v2`=0.013977,`v3`=0.017639,`v4`=-0.017247,`v5`=12.42,`t`=30.949858,`h`=84.148926,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185133,35.985800',`update_time`=1689342357  WHERE  `imei` = '868922055683771' [ RunTime:0.000593s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011114s ]
[ 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' , 1689342356 , 0.019716 , 0.013977 , 0.017639 , -0.017247 , 12.42 , 30.949858 , 84.148926 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.185133,35.985800' , 1689342357) [ RunTime:0.001169s ]