---------------------------------------------------------------
[ 2023-07-19T00:30:24+08:00 ] 117.132.194.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011814s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000685s ]
---------------------------------------------------------------
[ 2023-07-19T00:30:26+08:00 ] 117.132.194.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1689697824&v1=0.008037&v2=0.014499&v3=0.006291&v4=-0.015923&v5=12.420000&t=29.544870&h=82.172913&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010820s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000717s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1689697824,`v1`=0.008037,`v2`=0.014499,`v3`=0.006291,`v4`=-0.015923,`v5`=12.42,`t`=29.54487,`h`=82.172913,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1689697826  WHERE  `imei` = '868922055644021' [ RunTime:0.000673s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012155s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1689697824 , 0.008037 , 0.014499 , 0.006291 , -0.015923 , 12.42 , 29.54487 , 82.172913 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1689697826) [ RunTime:0.000652s ]
---------------------------------------------------------------
[ 2023-07-19T00:50:23+08:00 ] 39.144.3.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002517s ] 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` = '868922055680850' LIMIT 1 [ RunTime:0.000720s ]
---------------------------------------------------------------
[ 2023-07-19T00:50:24+08:00 ] 39.144.3.57 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1689699023&v1=0.021582&v2=0.013664&v3=0.019114&v4=-0.006171&v5=12.240000&t=29.609221&h=78.854126&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011110s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000713s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055680850',`create_time`=1689699023,`v1`=0.021582,`v2`=0.013664,`v3`=0.019114,`v4`=-0.006171,`v5`=12.24,`t`=29.609221,`h`=78.854126,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1689699024  WHERE  `imei` = '868922055680850' [ RunTime:0.000712s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012327s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1689699023 , 0.021582 , 0.013664 , 0.019114 , -0.006171 , 12.24 , 29.609221 , 78.854126 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1689699024) [ RunTime:0.000742s ]
---------------------------------------------------------------
[ 2023-07-19T02:02:50+08:00 ] 117.132.198.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011628s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000724s ]
---------------------------------------------------------------
[ 2023-07-19T02:02:58+08:00 ] 117.132.198.39 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230719&time=020201&v1=-01.095&v2=+00.017&v3=-00.985&v4=-00.504&v5=06.0&t=+22.1&h=78.7&rssi=+226&imsi=460044618415249&v6=-00.000&a1=00.137&a2=01.164&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010418s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000666s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230719',`time`='020201',`v1`=-1.095,`v2`=0.017,`v3`=-0.985,`v4`=-0.504,`v5`=6,`t`=22.1,`h`=78.7,`rssi`=226,`imsi`='460044618415249',`v6`=-0,`a1`=0.137,`a2`=1.164,`update_time`=1689703378  WHERE  `imei` = '868922055684076' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.039559s ]
[ 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' , '230719' , '020201' , -1.095 , 0.017 , -0.985 , -0.504 , 6 , 22.1 , 78.7 , 226 , '460044618415249' , -0 , 0.137 , 1.164 , 1689703378 , 1689703378) [ RunTime:0.000720s ]
---------------------------------------------------------------
[ 2023-07-19T02:03:55+08:00 ] 117.132.192.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001782s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010951s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ]
---------------------------------------------------------------
[ 2023-07-19T02:03:55+08:00 ] 117.132.193.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000659s ]
---------------------------------------------------------------
[ 2023-07-19T02:04:03+08:00 ] 117.132.192.192 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230719&time=020301&v1=-01.319&v2=+00.021&v3=-01.029&v4=-00.027&v5=06.2&t=+24.3&h=62.2&rssi=+227&ccid=4600485905031420000099m9990000000298000001g3250,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.009898s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000641s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230719',`time`='020301',`v1`=-1.319,`v2`=0.021,`v3`=-1.029,`v4`=-0.027,`v5`=6.2,`t`=24.3,`h`=62.2,`rssi`=227,`ccid`='4600485905031420000099m9990000000298000001g3250,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689703443  WHERE  `imei` = '868922055643643' [ RunTime:0.000530s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011487s ]
[ 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' , '230719' , '020301' , -1.319 , 0.021 , -1.029 , -0.027 , 6.2 , 24.3 , 62.2 , 227 , '4600485905031420000099m9990000000298000001g3250,N,00E000=-00.000' , 0 , 0 , 1689703443 , 1689703443) [ RunTime:0.000583s ]
---------------------------------------------------------------
[ 2023-07-19T02:04:03+08:00 ] 117.132.193.91 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230719&time=020301&v1=-00.429&v2=+00.001&v3=-00.203&v4=-00.007&v5=06.0&t=+24.6&h=66.3&rssi=+223&ccid=4600485905031430000099m9990000000080000000g4300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009684s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000646s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230719',`time`='020301',`v1`=-0.429,`v2`=0.001,`v3`=-0.203,`v4`=-0.007,`v5`=6,`t`=24.6,`h`=66.3,`rssi`=223,`ccid`='4600485905031430000099m9990000000080000000g4300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689703443  WHERE  `imei` = '868922055644013' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010163s ]
[ 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' , '230719' , '020301' , -0.429 , 0.001 , -0.203 , -0.007 , 6 , 24.6 , 66.3 , 223 , '4600485905031430000099m9990000000080000000g4300,N,00E000=-00.000' , 0 , 0 , 1689703443 , 1689703443) [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2023-07-19T13:25:17+08:00 ] 124.129.68.144 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011070s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000605s ]
---------------------------------------------------------------
[ 2023-07-19T13:25:23+08:00 ] 124.129.68.144 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012130s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000408s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000621s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000653s ]
---------------------------------------------------------------
[ 2023-07-19T13:25:37+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009583s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000554s ]
---------------------------------------------------------------
[ 2023-07-19T13:42:55+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002274s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010357s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000581s ]
---------------------------------------------------------------
[ 2023-07-19T14:03:54+08:00 ] 39.144.11.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001510s ]
---------------------------------------------------------------
[ 2023-07-19T14:03:55+08:00 ] 111.55.138.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002546s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012149s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000806s ]
---------------------------------------------------------------
[ 2023-07-19T14:04:02+08:00 ] 39.144.11.227 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230719&time=140301&v1=-01.318&v2=+00.044&v3=-01.021&v4=-00.027&v5=06.4&t=+41.7&h=56.2&rssi=+228&ccid=4600485905031420000099m9990000000304000001g3230,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000791s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230719',`time`='140301',`v1`=-1.318,`v2`=0.044,`v3`=-1.021,`v4`=-0.027,`v5`=6.4,`t`=41.7,`h`=56.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000304000001g3230,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689746642  WHERE  `imei` = '868922055643643' [ RunTime:0.000821s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016330s ]
[ 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' , '230719' , '140301' , -1.318 , 0.044 , -1.021 , -0.027 , 6.4 , 41.7 , 56.2 , 228 , '4600485905031420000099m9990000000304000001g3230,N,00E000=-00.000' , 0 , 0 , 1689746642 , 1689746642) [ RunTime:0.001356s ]
---------------------------------------------------------------
[ 2023-07-19T14:04:03+08:00 ] 111.55.138.76 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230719&time=140301&v1=-00.454&v2=+00.001&v3=-00.044&v4=-00.006&v5=06.2&t=+39.8&h=61.8&rssi=+224&ccid=4600485905031430000099m9990000000186000000g4610,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002556s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010675s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000735s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230719',`time`='140301',`v1`=-0.454,`v2`=0.001,`v3`=-0.044,`v4`=-0.006,`v5`=6.2,`t`=39.8,`h`=61.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000186000000g4610,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689746643  WHERE  `imei` = '868922055644013' [ RunTime:0.001534s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010378s ]
[ 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' , '230719' , '140301' , -0.454 , 0.001 , -0.044 , -0.006 , 6.2 , 39.8 , 61.8 , 224 , '4600485905031430000099m9990000000186000000g4610,N,00E000=-00.000' , 0 , 0 , 1689746643 , 1689746643) [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2023-07-19T14:04:49+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010640s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000627s ]
---------------------------------------------------------------
[ 2023-07-19T14:21:00+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013078s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000679s ]
---------------------------------------------------------------
[ 2023-07-19T16:43:26+08:00 ] 124.129.68.144 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011934s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000538s ]
---------------------------------------------------------------
[ 2023-07-19T16:57:19+08:00 ] 124.129.68.144 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011456s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000429s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001148s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001007s ]
---------------------------------------------------------------
[ 2023-07-19T16:57:21+08:00 ] 124.129.68.144 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009367s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000336s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000635s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000638s ]
---------------------------------------------------------------
[ 2023-07-19T16:58:38+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001437s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009840s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000622s ]
---------------------------------------------------------------
[ 2023-07-19T17:47:23+08:00 ] 39.144.7.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.003448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011852s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000968s ]
---------------------------------------------------------------
[ 2023-07-19T17:47:24+08:00 ] 39.144.7.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1689760043&v1=0.018452&v2=0.016168&v3=0.016676&v4=-0.000151&v5=12.240000&t=30.778257&h=78.693909&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009572s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000662s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055647586',`create_time`=1689760043,`v1`=0.018452,`v2`=0.016168,`v3`=0.016676,`v4`=-0.000151,`v5`=12.24,`t`=30.778257,`h`=78.693909,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1689760044  WHERE  `imei` = '868922055647586' [ RunTime:0.000611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012751s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1689760043 , 0.018452 , 0.016168 , 0.016676 , -0.000151 , 12.24 , 30.778257 , 78.693909 , 27 , '898604650119C1078512' , '460048590708512' , -0 , 1689760044) [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2023-07-19T18:28:23+08:00 ] 39.144.14.51 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012525s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2023-07-19T18:28:24+08:00 ] 39.144.14.51 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1689762503&v1=0.027241&v2=0.013247&v3=0.031906&v4=0.015381&v5=12.240000&t=30.520855&h=76.954407&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185101,35.990416&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001581s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009710s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000706s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1689762503,`v1`=0.027241,`v2`=0.013247,`v3`=0.031906,`v4`=0.015381,`v5`=12.24,`t`=30.520855,`h`=76.954407,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185101,35.990416',`update_time`=1689762504  WHERE  `imei` = '868922056976208' [ RunTime:0.000715s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011673s ]
[ 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' , 1689762503 , 0.027241 , 0.013247 , 0.031906 , 0.015381 , 12.24 , 30.520855 , 76.954407 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.185101,35.990416' , 1689762504) [ RunTime:0.000909s ]
---------------------------------------------------------------
[ 2023-07-19T18:36:21+08:00 ] 39.144.8.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011566s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000830s ]
---------------------------------------------------------------
[ 2023-07-19T18:36:22+08:00 ] 39.144.8.240 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1689762981&v1=0.021341&v2=0.014290&v3=0.018391&v4=-0.006712&v5=12.420000&t=30.563755&h=79.052490&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011762s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000780s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1689762981,`v1`=0.021341,`v2`=0.01429,`v3`=0.018391,`v4`=-0.006712,`v5`=12.42,`t`=30.563755,`h`=79.05249,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1689762982  WHERE  `imei` = '868922055684209' [ RunTime:0.000589s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010982s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1689762981 , 0.021341 , 0.01429 , 0.018391 , -0.006712 , 12.42 , 30.563755 , 79.05249 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1689762982) [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2023-07-19T19:01:21+08:00 ] 39.144.9.228 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013155s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-07-19T19:01:22+08:00 ] 39.144.9.228 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1689764481&v1=0.019234&v2=0.013873&v3=0.017097&v4=-0.004846&v5=12.420000&t=30.402878&h=85.117859&rssi=25&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009650s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1689764481,`v1`=0.019234,`v2`=0.013873,`v3`=0.017097,`v4`=-0.004846,`v5`=12.42,`t`=30.402878,`h`=85.117859,`rssi`=25,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1689764482  WHERE  `imei` = '868922055683920' [ RunTime:0.000595s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010767s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1689764481 , 0.019234 , 0.013873 , 0.017097 , -0.004846 , 12.42 , 30.402878 , 85.117859 , 25 , '89860426102071188500' , '460044618415250' , -0 , 1689764482) [ RunTime:0.000660s ]
---------------------------------------------------------------
[ 2023-07-19T21:22:28+08:00 ] 111.55.138.242 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ 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.013309s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000741s ]
---------------------------------------------------------------
[ 2023-07-19T21:22:29+08:00 ] 111.55.138.242 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1689772948&v1=0.030732&v2=0.014395&v3=0.029619&v4=0.001355&v5=12.240000&t=29.737923&h=79.639954&rssi=25&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012713s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055678110',`create_time`=1689772948,`v1`=0.030732,`v2`=0.014395,`v3`=0.029619,`v4`=0.001355,`v5`=12.24,`t`=29.737923,`h`=79.639954,`rssi`=25,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1689772949  WHERE  `imei` = '868922055678110' [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012067s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1689772948 , 0.030732 , 0.014395 , 0.029619 , 0.001355 , 12.24 , 29.737923 , 79.639954 , 25 , '898604650119C1078513' , '460048590708513' , -0 , 1689772949) [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2023-07-19T21:23:22+08:00 ] 218.204.252.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.001712s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011017s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000685s ]
---------------------------------------------------------------
[ 2023-07-19T21:23:23+08:00 ] 218.204.252.37 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1689773002&v1=0.017187&v2=0.013769&v3=0.016465&v4=-0.011589&v5=12.240000&t=29.941700&h=79.205078&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&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.011556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1689773002,`v1`=0.017187,`v2`=0.013769,`v3`=0.016465,`v4`=-0.011589,`v5`=12.24,`t`=29.9417,`h`=79.205078,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1689773003  WHERE  `imei` = '868922055684548' [ RunTime:0.000532s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011513s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1689773002 , 0.017187 , 0.013769 , 0.016465 , -0.011589 , 12.24 , 29.9417 , 79.205078 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1689773003) [ RunTime:0.000529s ]
---------------------------------------------------------------
[ 2023-07-19T21:39:03+08:00 ] 221.178.126.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.003215s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012791s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2023-07-19T21:39:05+08:00 ] 221.178.126.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1689773943&v1=0.032177&v2=0.013664&v3=0.030853&v4=0.007977&v5=12.420000&t=29.855898&h=83.668274&rssi=19&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.186030,35.986034&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001836s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011115s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000806s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1689773943,`v1`=0.032177,`v2`=0.013664,`v3`=0.030853,`v4`=0.007977,`v5`=12.42,`t`=29.855898,`h`=83.668274,`rssi`=19,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.186030,35.986034',`update_time`=1689773945  WHERE  `imei` = '868922055683912' [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012914s ]
[ 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' , 1689773943 , 0.032177 , 0.013664 , 0.030853 , 0.007977 , 12.42 , 29.855898 , 83.668274 , 19 , '898604650119C1053138' , '460048590503138' , -0 , '120.186030,35.986034' , 1689773945) [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2023-07-19T21:50:03+08:00 ] 223.104.255.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.003315s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013415s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000742s ]
---------------------------------------------------------------
[ 2023-07-19T21:50:05+08:00 ] 223.104.255.72 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1689774603&v1=0.019475&v2=0.015646&v3=0.016585&v4=-0.017308&v5=12.420000&t=29.791548&h=84.652466&rssi=29&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184840,35.985604&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001781s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010203s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000672s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1689774603,`v1`=0.019475,`v2`=0.015646,`v3`=0.016585,`v4`=-0.017308,`v5`=12.42,`t`=29.791548,`h`=84.652466,`rssi`=29,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184840,35.985604',`update_time`=1689774605  WHERE  `imei` = '868922055683771' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011798s ]
[ 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' , 1689774603 , 0.019475 , 0.015646 , 0.016585 , -0.017308 , 12.42 , 29.791548 , 84.652466 , 29 , '898604650119C1053136' , '460048590503136' , -0 , '120.184840,35.985604' , 1689774605) [ RunTime:0.000661s ]