---------------------------------------------------------------
[ 2023-06-08T00:10:23+08:00 ] 117.132.198.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002783s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010049s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000722s ]
---------------------------------------------------------------
[ 2023-06-08T00:10:24+08:00 ] 117.132.198.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686154223&v1=0.021401&v2=0.012621&v3=0.018753&v4=-0.005990&v5=12.240000&t=25.544409&h=79.021973&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002003s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010753s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000733s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055680850',`create_time`=1686154223,`v1`=0.021401,`v2`=0.012621,`v3`=0.018753,`v4`=-0.00599,`v5`=12.24,`t`=25.544409,`h`=79.021973,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1686154224  WHERE  `imei` = '868922055680850' [ RunTime:0.000689s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011173s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1686154223 , 0.021401 , 0.012621 , 0.018753 , -0.00599 , 12.24 , 25.544409 , 79.021973 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1686154224) [ RunTime:0.001278s ]
---------------------------------------------------------------
[ 2023-06-08T02:03:54+08:00 ] 111.55.140.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013092s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000672s ]
---------------------------------------------------------------
[ 2023-06-08T02:03:55+08:00 ] 117.132.196.206 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012338s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2023-06-08T02:04:03+08:00 ] 111.55.140.213 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230608&time=020301&v1=-01.386&v2=+00.012&v3=-01.022&v4=-00.043&v5=06.2&t=+24.9&h=59.7&rssi=+228&ccid=4600485905031420000099m9990000000367000001g3940,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001559s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009637s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000650s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230608',`time`='020301',`v1`=-1.386,`v2`=0.012,`v3`=-1.022,`v4`=-0.043,`v5`=6.2,`t`=24.9,`h`=59.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000367000001g3940,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686161043  WHERE  `imei` = '868922055643643' [ RunTime:0.000588s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011395s ]
[ 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' , '230608' , '020301' , -1.386 , 0.012 , -1.022 , -0.043 , 6.2 , 24.9 , 59.7 , 228 , '4600485905031420000099m9990000000367000001g3940,N,00E000=-00.000' , 0 , 0 , 1686161043 , 1686161043) [ RunTime:0.001611s ]
---------------------------------------------------------------
[ 2023-06-08T02:04:03+08:00 ] 117.132.196.206 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230608&time=020301&v1=-00.379&v2=+00.001&v3=+00.015&v4=-00.003&v5=06.0&t=+25.0&h=62.8&rssi=+223&ccid=4600485905031430000099m9990000000040000000g3990,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010338s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230608',`time`='020301',`v1`=-0.379,`v2`=0.001,`v3`=0.015,`v4`=-0.003,`v5`=6,`t`=25,`h`=62.8,`rssi`=223,`ccid`='4600485905031430000099m9990000000040000000g3990,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686161043  WHERE  `imei` = '868922055644013' [ RunTime:0.000536s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010849s ]
[ 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' , '230608' , '020301' , -0.379 , 0.001 , 0.015 , -0.003 , 6 , 25 , 62.8 , 223 , '4600485905031430000099m9990000000040000000g3990,N,00E000=-00.000' , 0 , 0 , 1686161043 , 1686161043) [ RunTime:0.000524s ]
---------------------------------------------------------------
[ 2023-06-08T08:29:10+08:00 ] 124.129.68.88 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012333s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'user'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001002s ]
---------------------------------------------------------------
[ 2023-06-08T08:29:30+08:00 ] 124.129.68.88 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010323s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'user'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000550s ]
---------------------------------------------------------------
[ 2023-06-08T08:30:31+08:00 ] 124.129.68.88 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001755s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011584s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000582s ]
---------------------------------------------------------------
[ 2023-06-08T08:30:46+08:00 ] 124.129.68.88 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001370s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012673s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000380s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001402s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001045s ]
---------------------------------------------------------------
[ 2023-06-08T08:31:59+08:00 ] 124.129.68.88 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010790s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000427s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001076s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001039s ]
---------------------------------------------------------------
[ 2023-06-08T08:32:25+08:00 ] 124.129.68.88 GET /admin/show/index.html?page=3
[ 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.010873s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000376s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001031s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-06-08T10:10:09+08:00 ] 183.162.198.19 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014039s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'user'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001321s ]
---------------------------------------------------------------
[ 2023-06-08T10:10:10+08:00 ] 183.162.198.19 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.014987s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.001115s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000615s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000572s ]
---------------------------------------------------------------
[ 2023-06-08T10:10:15+08:00 ] 183.162.198.49 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001917s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010586s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000519s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000599s ]
---------------------------------------------------------------
[ 2023-06-08T10:10:50+08:00 ] 183.162.198.48 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009354s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000472s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000557s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000594s ]
---------------------------------------------------------------
[ 2023-06-08T10:12:32+08:00 ] 183.162.198.36 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009620s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000514s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000630s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2023-06-08T10:12:34+08:00 ] 183.162.198.36 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001557s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010539s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 8 LIMIT 1 [ RunTime:0.000549s ]
---------------------------------------------------------------
[ 2023-06-08T10:12:41+08:00 ] 183.162.198.16 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009642s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' [ RunTime:0.000577s ]
---------------------------------------------------------------
[ 2023-06-08T11:28:28+08:00 ] 39.144.5.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012063s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000699s ]
---------------------------------------------------------------
[ 2023-06-08T11:28:29+08:00 ] 39.144.5.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686194908&v1=0.030672&v2=0.014186&v3=0.035819&v4=0.001415&v5=12.420000&t=26.863596&h=78.930420&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010694s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000733s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055678110',`create_time`=1686194908,`v1`=0.030672,`v2`=0.014186,`v3`=0.035819,`v4`=0.001415,`v5`=12.42,`t`=26.863596,`h`=78.93042,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686194909  WHERE  `imei` = '868922055678110' [ RunTime:0.000757s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011967s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686194908 , 0.030672 , 0.014186 , 0.035819 , 0.001415 , 12.42 , 26.863596 , 78.93042 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1686194909) [ RunTime:0.001452s ]
---------------------------------------------------------------
[ 2023-06-08T14:03:54+08:00 ] 117.132.192.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011126s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000704s ]
---------------------------------------------------------------
[ 2023-06-08T14:03:54+08:00 ] 39.144.14.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009866s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-06-08T14:04:03+08:00 ] 117.132.192.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230608&time=140301&v1=-00.430&v2=+00.001&v3=+00.020&v4=-00.001&v5=06.2&t=+34.1&h=60.5&rssi=+224&ccid=4600485905031430000099m9990000000045000000g4480,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010941s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000674s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230608',`time`='140301',`v1`=-0.43,`v2`=0.001,`v3`=0.02,`v4`=-0.001,`v5`=6.2,`t`=34.1,`h`=60.5,`rssi`=224,`ccid`='4600485905031430000099m9990000000045000000g4480,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686204243  WHERE  `imei` = '868922055644013' [ RunTime:0.000620s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012267s ]
[ 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' , '230608' , '140301' , -0.43 , 0.001 , 0.02 , -0.001 , 6.2 , 34.1 , 60.5 , 224 , '4600485905031430000099m9990000000045000000g4480,N,00E000=-00.000' , 0 , 0 , 1686204243 , 1686204243) [ RunTime:0.000635s ]
---------------------------------------------------------------
[ 2023-06-08T14:04:03+08:00 ] 39.144.14.222 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230608&time=140301&v1=-01.384&v2=+00.026&v3=-01.013&v4=-00.043&v5=06.4&t=+34.6&h=56.5&rssi=+230&ccid=4600485905031420000099m9990000000374000001g3920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010843s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000648s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230608',`time`='140301',`v1`=-1.384,`v2`=0.026,`v3`=-1.013,`v4`=-0.043,`v5`=6.4,`t`=34.6,`h`=56.5,`rssi`=230,`ccid`='4600485905031420000099m9990000000374000001g3920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686204243  WHERE  `imei` = '868922055643643' [ RunTime:0.000525s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010831s ]
[ 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' , '230608' , '140301' , -1.384 , 0.026 , -1.013 , -0.043 , 6.4 , 34.6 , 56.5 , 230 , '4600485905031420000099m9990000000374000001g3920,N,00E000=-00.000' , 0 , 0 , 1686204243 , 1686204243) [ RunTime:0.000517s ]
---------------------------------------------------------------
[ 2023-06-08T14:55:23+08:00 ] 218.204.253.173 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002637s ] 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` = '868922055684548' LIMIT 1 [ RunTime:0.000707s ]
---------------------------------------------------------------
[ 2023-06-08T14:55:25+08:00 ] 218.204.253.173 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686207323&v1=0.016826&v2=0.015125&v3=0.014719&v4=-0.011589&v5=12.420000&t=28.064808&h=77.290100&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001966s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010992s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000703s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1686207323,`v1`=0.016826,`v2`=0.015125,`v3`=0.014719,`v4`=-0.011589,`v5`=12.42,`t`=28.064808,`h`=77.2901,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686207325  WHERE  `imei` = '868922055684548' [ RunTime:0.000649s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011567s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686207323 , 0.016826 , 0.015125 , 0.014719 , -0.011589 , 12.42 , 28.064808 , 77.2901 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1686207325) [ RunTime:0.000752s ]
---------------------------------------------------------------
[ 2023-06-08T17:06:58+08:00 ] 221.178.125.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015345s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000774s ]
---------------------------------------------------------------
[ 2023-06-08T17:07:00+08:00 ] 221.178.125.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686215218&v1=0.018572&v2=0.014186&v3=0.015983&v4=-0.000271&v5=12.240000&t=29.534145&h=78.686279&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184653,35.984703&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015846s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000747s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055647586',`create_time`=1686215218,`v1`=0.018572,`v2`=0.014186,`v3`=0.015983,`v4`=-0.000271,`v5`=12.24,`t`=29.534145,`h`=78.686279,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184653,35.984703',`update_time`=1686215220  WHERE  `imei` = '868922055647586' [ RunTime:0.000625s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011937s ]
[ 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' , 1686215218 , 0.018572 , 0.014186 , 0.015983 , -0.000271 , 12.24 , 29.534145 , 78.686279 , 28 , '898604650119C1078512' , '460048590708512' , -0 , '120.184653,35.984703' , 1686215220) [ RunTime:0.000737s ]
---------------------------------------------------------------
[ 2023-06-08T17:49:23+08:00 ] 111.55.141.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ 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.012490s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000724s ]
---------------------------------------------------------------
[ 2023-06-08T17:49:24+08:00 ] 111.55.141.114 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686217763&v1=0.027301&v2=0.013143&v3=0.027512&v4=0.015441&v5=12.240000&t=29.148043&h=76.633972&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185072,35.986869&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002072s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012104s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000701s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1686217763,`v1`=0.027301,`v2`=0.013143,`v3`=0.027512,`v4`=0.015441,`v5`=12.24,`t`=29.148043,`h`=76.633972,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185072,35.986869',`update_time`=1686217764  WHERE  `imei` = '868922056976208' [ RunTime:0.000686s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011973s ]
[ 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' , 1686217763 , 0.027301 , 0.013143 , 0.027512 , 0.015441 , 12.24 , 29.148043 , 76.633972 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.185072,35.986869' , 1686217764) [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2023-06-08T17:55:21+08:00 ] 39.144.15.126 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002065s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011107s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000681s ]
---------------------------------------------------------------
[ 2023-06-08T17:55:22+08:00 ] 39.144.15.126 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686218121&v1=0.019896&v2=0.012830&v3=0.017368&v4=-0.006773&v5=12.420000&t=29.190943&h=78.785461&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009602s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000660s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1686218121,`v1`=0.019896,`v2`=0.01283,`v3`=0.017368,`v4`=-0.006773,`v5`=12.42,`t`=29.190943,`h`=78.785461,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686218122  WHERE  `imei` = '868922055684209' [ RunTime:0.000573s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010714s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686218121 , 0.019896 , 0.01283 , 0.017368 , -0.006773 , 12.42 , 29.190943 , 78.785461 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1686218122) [ RunTime:0.000504s ]
---------------------------------------------------------------
[ 2023-06-08T18:20:21+08:00 ] 39.144.5.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012347s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000825s ]
---------------------------------------------------------------
[ 2023-06-08T18:20:22+08:00 ] 39.144.5.32 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686219621&v1=0.019294&v2=0.015542&v3=0.016405&v4=-0.004666&v5=12.420000&t=28.643963&h=82.623047&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011201s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000746s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1686219621,`v1`=0.019294,`v2`=0.015542,`v3`=0.016405,`v4`=-0.004666,`v5`=12.42,`t`=28.643963,`h`=82.623047,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686219622  WHERE  `imei` = '868922055683920' [ RunTime:0.000626s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014227s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686219621 , 0.019294 , 0.015542 , 0.016405 , -0.004666 , 12.42 , 28.643963 , 82.623047 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686219622) [ RunTime:0.001007s ]
---------------------------------------------------------------
[ 2023-06-08T20:28:06+08:00 ] 183.162.198.33 GET /
[ 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.012092s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000653s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000663s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2023-06-08T20:28:07+08:00 ] 183.162.198.33 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.005899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011219s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000550s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000671s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000683s ]
---------------------------------------------------------------
[ 2023-06-08T20:30:27+08:00 ] 183.162.198.35 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001562s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011135s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000512s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000563s ]
---------------------------------------------------------------
[ 2023-06-08T20:31:21+08:00 ] 183.162.198.36 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.002103s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010793s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000582s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000701s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000559s ]
---------------------------------------------------------------
[ 2023-06-08T20:31:24+08:00 ] 183.162.198.36 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.022987s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000928s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000579s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000602s ]
---------------------------------------------------------------
[ 2023-06-08T20:31:30+08:00 ] 183.162.198.26 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010725s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000496s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000556s ]
---------------------------------------------------------------
[ 2023-06-08T20:38:57+08:00 ] 183.162.198.22 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011110s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000581s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2023-06-08T20:39:22+08:00 ] 183.162.198.23 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012083s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000832s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000624s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000601s ]
---------------------------------------------------------------
[ 2023-06-08T20:39:25+08:00 ] 183.162.198.23 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012090s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000566s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000554s ]
---------------------------------------------------------------
[ 2023-06-08T20:39:28+08:00 ] 183.162.198.23 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010480s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000477s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000529s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2023-06-08T20:39:31+08:00 ] 183.162.198.23 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010740s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' [ RunTime:0.000661s ]
---------------------------------------------------------------
[ 2023-06-08T20:40:20+08:00 ] 183.162.198.15 GET /home/device/index.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.009731s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000660s ]
---------------------------------------------------------------
[ 2023-06-08T21:05:24+08:00 ] 117.132.194.138 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002570s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012726s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000728s ]
---------------------------------------------------------------
[ 2023-06-08T21:05:25+08:00 ] 117.132.194.138 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686229524&v1=0.031876&v2=0.014812&v3=0.029017&v4=0.007977&v5=12.420000&t=27.453476&h=81.333679&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001376s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000640s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1686229524,`v1`=0.031876,`v2`=0.014812,`v3`=0.029017,`v4`=0.007977,`v5`=12.42,`t`=27.453476,`h`=81.333679,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1686229525  WHERE  `imei` = '868922055683912' [ RunTime:0.000597s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011489s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1686229524 , 0.031876 , 0.014812 , 0.029017 , 0.007977 , 12.42 , 27.453476 , 81.333679 , 18 , '898604650119C1053138' , '460048590503138' , -0 , 1686229525) [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-06-08T21:09:06+08:00 ] 183.162.198.44 GET /home/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.012763s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000568s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000566s ]
---------------------------------------------------------------
[ 2023-06-08T21:09:09+08:00 ] 183.162.198.44 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012420s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 7 LIMIT 1 [ RunTime:0.000558s ]
---------------------------------------------------------------
[ 2023-06-08T21:09:10+08:00 ] 183.162.198.44 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010717s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' [ RunTime:0.000544s ]
---------------------------------------------------------------
[ 2023-06-08T21:09:11+08:00 ] 183.162.198.44 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001909s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011102s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000454s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000539s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000554s ]
---------------------------------------------------------------
[ 2023-06-08T21:09:14+08:00 ] 183.162.198.44 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011141s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000612s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000634s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000634s ]
---------------------------------------------------------------
[ 2023-06-08T21:10:53+08:00 ] 183.162.198.13 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010056s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000503s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000566s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000573s ]
---------------------------------------------------------------
[ 2023-06-08T21:12:24+08:00 ] 117.132.192.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.002272s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011167s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000644s ]
---------------------------------------------------------------
[ 2023-06-08T21:12:26+08:00 ] 117.132.192.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686229944&v1=0.019595&v2=0.014603&v3=0.016134&v4=-0.017187&v5=12.420000&t=27.421301&h=82.249207&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001865s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011155s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.001524s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1686229944,`v1`=0.019595,`v2`=0.014603,`v3`=0.016134,`v4`=-0.017187,`v5`=12.42,`t`=27.421301,`h`=82.249207,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1686229946  WHERE  `imei` = '868922055683771' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010960s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1686229944 , 0.019595 , 0.014603 , 0.016134 , -0.017187 , 12.42 , 27.421301 , 82.249207 , 28 , '898604650119C1053136' , '460048590503136' , -0 , 1686229946) [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2023-06-08T21:13:50+08:00 ] 183.162.198.24 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000510s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000617s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000650s ]
---------------------------------------------------------------
[ 2023-06-08T21:13:52+08:00 ] 183.162.198.24 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001498s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010109s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000456s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000534s ]
---------------------------------------------------------------
[ 2023-06-08T21:13:53+08:00 ] 183.162.198.24 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002415s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012578s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000658s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2023-06-08T21:13:54+08:00 ] 183.162.198.24 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009653s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000759s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000563s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000590s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:12+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001632s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011687s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000531s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000612s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000620s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:14+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012560s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000602s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000567s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:14+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001964s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011996s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000608s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000639s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000607s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:15+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011505s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000560s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:16+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010199s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000462s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000598s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000682s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:17+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002247s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010963s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000497s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000552s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000627s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:17+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013909s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000502s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000553s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000564s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:18+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010312s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000515s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000541s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000570s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:20+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011070s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000624s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000557s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:21+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010414s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000515s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000574s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000597s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:22+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010350s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000552s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000543s ]
---------------------------------------------------------------
[ 2023-06-08T21:14:23+08:00 ] 183.162.198.39 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011730s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000493s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000578s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:15+08:00 ] 183.162.198.38 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012427s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000533s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000597s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000657s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:16+08:00 ] 183.162.198.38 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011716s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000565s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:17+08:00 ] 183.162.198.38 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010979s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000477s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000545s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000549s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:19+08:00 ] 183.162.198.38 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010600s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000525s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000612s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:42+08:00 ] 183.162.198.17 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010739s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000554s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000848s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:43+08:00 ] 183.162.198.17 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012212s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000561s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000549s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:44+08:00 ] 183.162.198.17 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013620s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000528s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000627s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:45+08:00 ] 183.162.198.17 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001811s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011503s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.001285s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000583s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000580s ]
---------------------------------------------------------------
[ 2023-06-08T21:16:46+08:00 ] 183.162.198.17 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002125s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012764s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000581s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000568s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000670s ]
---------------------------------------------------------------
[ 2023-06-08T21:17:47+08:00 ] 183.162.198.9 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011581s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000528s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000600s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000759s ]
---------------------------------------------------------------
[ 2023-06-08T21:18:00+08:00 ] 183.162.198.9 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011779s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' [ RunTime:0.000610s ]
---------------------------------------------------------------
[ 2023-06-08T21:18:02+08:00 ] 183.162.198.9 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001846s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010020s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.000497s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000606s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000858s ]
---------------------------------------------------------------
[ 2023-06-08T21:18:04+08:00 ] 183.162.198.9 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001967s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012054s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' [ RunTime:0.000553s ]
---------------------------------------------------------------
[ 2023-06-08T21:19:02+08:00 ] 183.162.198.24 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' [ RunTime:0.000572s ]
---------------------------------------------------------------
[ 2023-06-08T22:14:48+08:00 ] 117.132.195.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012812s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000730s ]
---------------------------------------------------------------
[ 2023-06-08T22:14:57+08:00 ] 117.132.195.100 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230608&time=221401&v1=-00.944&v2=+00.009&v3=-00.842&v4=-00.093&v5=06.0&t=+20.8&h=79.9&rssi=+224&imsi=460044618415249&v6=-00.000&a1=00.140&a2=01.091&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002125s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010844s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000711s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230608',`time`='221401',`v1`=-0.944,`v2`=0.009,`v3`=-0.842,`v4`=-0.093,`v5`=6,`t`=20.8,`h`=79.9,`rssi`=224,`imsi`='460044618415249',`v6`=-0,`a1`=0.14,`a2`=1.091,`update_time`=1686233697  WHERE  `imei` = '868922055684076' [ RunTime:0.000737s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011474s ]
[ 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' , '230608' , '221401' , -0.944 , 0.009 , -0.842 , -0.093 , 6 , 20.8 , 79.9 , 224 , '460044618415249' , -0 , 0.14 , 1.091 , 1686233697 , 1686233697) [ RunTime:0.000708s ]
---------------------------------------------------------------
[ 2023-06-08T23:50:23+08:00 ] 39.144.3.50 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002401s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013869s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000729s ]
---------------------------------------------------------------
[ 2023-06-08T23:50:24+08:00 ] 39.144.3.50 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686239423&v1=0.007796&v2=0.016063&v3=0.005177&v4=-0.015923&v5=12.420000&t=26.960121&h=80.463928&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001811s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011076s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000766s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1686239423,`v1`=0.007796,`v2`=0.016063,`v3`=0.005177,`v4`=-0.015923,`v5`=12.42,`t`=26.960121,`h`=80.463928,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686239424  WHERE  `imei` = '868922055644021' [ RunTime:0.000659s ]
[ 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` , `update_time`) VALUES ('868922055644021' , 1686239423 , 0.007796 , 0.016063 , 0.005177 , -0.015923 , 12.42 , 26.960121 , 80.463928 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686239424) [ RunTime:0.000737s ]