---------------------------------------------------------------
[ 2023-03-08T02:03:54+08:00 ] 39.144.4.251 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014138s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000720s ]
---------------------------------------------------------------
[ 2023-03-08T02:03:55+08:00 ] 223.104.254.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002167s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000713s ]
---------------------------------------------------------------
[ 2023-03-08T02:04:02+08:00 ] 39.144.4.251 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230308&time=020301&v1=-01.276&v2=+00.025&v3=-00.963&v4=-00.023&v5=05.7&t=+07.2&h=63.3&rssi=+227&ccid=4600485905031420000099m9990000000306000001g2870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001921s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011332s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230308',`time`='020301',`v1`=-1.276,`v2`=0.025,`v3`=-0.963,`v4`=-0.023,`v5`=5.7,`t`=7.2,`h`=63.3,`rssi`=227,`ccid`='4600485905031420000099m9990000000306000001g2870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678212242  WHERE  `imei` = '868922055643643' [ RunTime:0.000746s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010328s ]
[ 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' , '230308' , '020301' , -1.276 , 0.025 , -0.963 , -0.023 , 5.7 , 7.2 , 63.3 , 227 , '4600485905031420000099m9990000000306000001g2870,N,00E000=-00.000' , 0 , 0 , 1678212242 , 1678212242) [ RunTime:0.000684s ]
---------------------------------------------------------------
[ 2023-03-08T02:04:04+08:00 ] 223.104.254.6 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230308&time=020301&v1=-00.270&v2=+00.001&v3=-00.096&v4=-00.016&v5=05.9&t=+08.6&h=65.8&rssi=+226&ccid=4600485905031430000099m9990000000001000000g3060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002035s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011963s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000710s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230308',`time`='020301',`v1`=-0.27,`v2`=0.001,`v3`=-0.096,`v4`=-0.016,`v5`=5.9,`t`=8.6,`h`=65.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000001000000g3060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678212244  WHERE  `imei` = '868922055644013' [ RunTime:0.000561s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011999s ]
[ 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' , '230308' , '020301' , -0.27 , 0.001 , -0.096 , -0.016 , 5.9 , 8.6 , 65.8 , 226 , '4600485905031430000099m9990000000001000000g3060,N,00E000=-00.000' , 0 , 0 , 1678212244 , 1678212244) [ RunTime:0.000574s ]
---------------------------------------------------------------
[ 2023-03-08T06:08:51+08:00 ] 39.144.16.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011923s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000723s ]
---------------------------------------------------------------
[ 2023-03-08T06:08:59+08:00 ] 39.144.16.49 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230308&time=060801&v1=-01.267&v2=+00.021&v3=-01.066&v4=-00.637&v5=05.9&t=+11.1&h=82.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.229&a2=01.283&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002306s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013928s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000995s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230308',`time`='060801',`v1`=-1.267,`v2`=0.021,`v3`=-1.066,`v4`=-0.637,`v5`=5.9,`t`=11.1,`h`=82,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.229,`a2`=1.283,`update_time`=1678226939  WHERE  `imei` = '868922055684076' [ RunTime:0.000920s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015292s ]
[ 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' , '230308' , '060801' , -1.267 , 0.021 , -1.066 , -0.637 , 5.9 , 11.1 , 82 , 228 , '460044618415249' , -0 , 0.229 , 1.283 , 1678226939 , 1678226939) [ RunTime:0.000652s ]
---------------------------------------------------------------
[ 2023-03-08T11:00:47+08:00 ] 39.88.23.149 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002949s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013726s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000813s ]
---------------------------------------------------------------
[ 2023-03-08T11:00:51+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011436s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000941s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000754s ]
---------------------------------------------------------------
[ 2023-03-08T13:11:37+08:00 ] 112.224.69.238 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011716s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2023-03-08T13:11:51+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001903s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013095s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000446s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000931s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000888s ]
---------------------------------------------------------------
[ 2023-03-08T13:14:21+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002468s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011066s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000412s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000804s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000713s ]
---------------------------------------------------------------
[ 2023-03-08T13:14:26+08:00 ] 223.104.255.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009487s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000661s ]
---------------------------------------------------------------
[ 2023-03-08T13:14:27+08:00 ] 223.104.255.114 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678252466&v1=0.004244&v2=0.839368&v3=0.004244&v4=0.008217&v5=12.240000&t=20.106785&h=44.636292&rssi=31&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008922s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000691s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678252466,`v1`=0.004244,`v2`=0.839368,`v3`=0.004244,`v4`=0.008217,`v5`=12.24,`t`=20.106785,`h`=44.636292,`rssi`=31,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678252467  WHERE  `imei` = '868922055644021' [ RunTime:0.000612s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009678s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678252466 , 0.004244 , 0.839368 , 0.004244 , 0.008217 , 12.24 , 20.106785 , 44.636292 , 31 , '898604650119C1053141' , '460048590503141' , -0 , 1678252467) [ RunTime:0.000634s ]
---------------------------------------------------------------
[ 2023-03-08T13:14:30+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002002s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010927s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000743s ]
---------------------------------------------------------------
[ 2023-03-08T13:15:27+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010167s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000789s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000778s ]
---------------------------------------------------------------
[ 2023-03-08T13:16:27+08:00 ] 39.144.8.0 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011179s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-03-08T13:16:29+08:00 ] 39.144.8.0 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678252587&v1=0.985877&v2=1.035154&v3=0.992258&v4=0.004726&v5=12.420000&t=20.407087&h=43.201965&rssi=31&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009760s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000714s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678252587,`v1`=0.985877,`v2`=1.035154,`v3`=0.992258,`v4`=0.004726,`v5`=12.42,`t`=20.407087,`h`=43.201965,`rssi`=31,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678252589  WHERE  `imei` = '868922055644021' [ RunTime:0.000636s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011580s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678252587 , 0.985877 , 1.035154 , 0.992258 , 0.004726 , 12.42 , 20.407087 , 43.201965 , 31 , '898604650119C1053141' , '460048590503141' , -0 , 1678252589) [ RunTime:0.000566s ]
---------------------------------------------------------------
[ 2023-03-08T13:16:59+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011113s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000806s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000794s ]
---------------------------------------------------------------
[ 2023-03-08T13:18:27+08:00 ] 39.144.1.131 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009223s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2023-03-08T13:18:29+08:00 ] 39.144.1.131 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678252707&v1=0.985335&v2=0.975385&v3=0.004605&v4=0.004304&v5=12.240000&t=20.396362&h=42.782349&rssi=31&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009445s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000649s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678252707,`v1`=0.985335,`v2`=0.975385,`v3`=0.004605,`v4`=0.004304,`v5`=12.24,`t`=20.396362,`h`=42.782349,`rssi`=31,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678252709  WHERE  `imei` = '868922055644021' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009100s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678252707 , 0.985335 , 0.975385 , 0.004605 , 0.004304 , 12.24 , 20.396362 , 42.782349 , 31 , '898604650119C1053141' , '460048590503141' , -0 , 1678252709) [ RunTime:0.000773s ]
---------------------------------------------------------------
[ 2023-03-08T13:18:32+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001952s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010290s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000395s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000801s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000757s ]
---------------------------------------------------------------
[ 2023-03-08T13:20:27+08:00 ] 39.144.10.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001720s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010356s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000704s ]
---------------------------------------------------------------
[ 2023-03-08T13:20:29+08:00 ] 39.144.10.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678252827&v1=0.004124&v2=9.710357&v3=0.004184&v4=0.991475&v5=12.240000&t=20.589415&h=42.080444&rssi=31&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014711s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001070s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678252827,`v1`=0.004124,`v2`=9.710357,`v3`=0.004184,`v4`=0.991475,`v5`=12.24,`t`=20.589415,`h`=42.080444,`rssi`=31,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678252829  WHERE  `imei` = '868922055644021' [ RunTime:0.000801s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013201s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678252827 , 0.004124 , 9.710357 , 0.004184 , 0.991475 , 12.24 , 20.589415 , 42.080444 , 31 , '898604650119C1053141' , '460048590503141' , -0 , 1678252829) [ RunTime:0.000930s ]
---------------------------------------------------------------
[ 2023-03-08T13:20:31+08:00 ] 112.224.69.238 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002564s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012674s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000872s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000755s ]
---------------------------------------------------------------
[ 2023-03-08T13:23:19+08:00 ] 112.224.69.238 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010026s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000660s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010550s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001177s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002101s ]
---------------------------------------------------------------
[ 2023-03-08T13:40:46+08:00 ] 218.204.253.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010301s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000725s ]
---------------------------------------------------------------
[ 2023-03-08T13:40:47+08:00 ] 218.204.253.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678254046&v1=0.004064&v2=0.383228&v3=0.004184&v4=0.004666&v5=13.320000&t=21.425972&h=45.773071&rssi=16&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011383s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678254046,`v1`=0.004064,`v2`=0.383228,`v3`=0.004184,`v4`=0.004666,`v5`=13.32,`t`=21.425972,`h`=45.773071,`rssi`=16,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678254047  WHERE  `imei` = '868922055644021' [ RunTime:0.000595s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011192s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678254046 , 0.004064 , 0.383228 , 0.004184 , 0.004666 , 13.32 , 21.425972 , 45.773071 , 16 , '898604650119C1053141' , '460048590503141' , -0 , 1678254047) [ RunTime:0.000588s ]
---------------------------------------------------------------
[ 2023-03-08T13:40:50+08:00 ] 218.204.253.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1575515471&v1=0.003161&v2=0.693023&v3=0.004154&v4=0.004545&v5=13.320000&t=20.492887&h=48.603577&rssi=16&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011135s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000725s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1575515471,`v1`=0.003161,`v2`=0.693023,`v3`=0.004154,`v4`=0.004545,`v5`=13.32,`t`=20.492887,`h`=48.603577,`rssi`=16,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678254050  WHERE  `imei` = '868922055644021' [ RunTime:0.000542s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009530s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1575515471 , 0.003161 , 0.693023 , 0.004154 , 0.004545 , 13.32 , 20.492887 , 48.603577 , 16 , '898604650119C1053141' , '460048590503141' , -0 , 1678254050) [ RunTime:0.000522s ]
---------------------------------------------------------------
[ 2023-03-08T13:40:52+08:00 ] 218.204.253.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1575515581&v1=0.004064&v2=0.382915&v3=0.004124&v4=0.004545&v5=13.320000&t=21.050592&h=46.574158&rssi=16&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&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.010360s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000664s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1575515581,`v1`=0.004064,`v2`=0.382915,`v3`=0.004124,`v4`=0.004545,`v5`=13.32,`t`=21.050592,`h`=46.574158,`rssi`=16,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678254052  WHERE  `imei` = '868922055644021' [ RunTime:0.000547s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010917s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1575515581 , 0.004064 , 0.382915 , 0.004124 , 0.004545 , 13.32 , 21.050592 , 46.574158 , 16 , '898604650119C1053141' , '460048590503141' , -0 , 1678254052) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-03-08T13:41:00+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001728s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010952s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000395s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000799s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000723s ]
---------------------------------------------------------------
[ 2023-03-08T13:41:01+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009938s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000696s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012095s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000585s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000933s ]
---------------------------------------------------------------
[ 2023-03-08T14:03:55+08:00 ] 39.144.12.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013352s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2023-03-08T14:03:55+08:00 ] 39.144.17.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001882s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009655s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000790s ]
---------------------------------------------------------------
[ 2023-03-08T14:04:03+08:00 ] 39.144.12.26 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230308&time=140301&v1=-00.284&v2=+00.001&v3=+00.019&v4=-00.017&v5=06.0&t=+21.4&h=65.3&rssi=+223&ccid=4600485905031430000099m9990000000040000000g3290,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002226s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010205s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230308',`time`='140301',`v1`=-0.284,`v2`=0.001,`v3`=0.019,`v4`=-0.017,`v5`=6,`t`=21.4,`h`=65.3,`rssi`=223,`ccid`='4600485905031430000099m9990000000040000000g3290,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678255443  WHERE  `imei` = '868922055644013' [ RunTime:0.000607s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012341s ]
[ 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' , '230308' , '140301' , -0.284 , 0.001 , 0.019 , -0.017 , 6 , 21.4 , 65.3 , 223 , '4600485905031430000099m9990000000040000000g3290,N,00E000=-00.000' , 0 , 0 , 1678255443 , 1678255443) [ RunTime:0.000654s ]
---------------------------------------------------------------
[ 2023-03-08T14:04:03+08:00 ] 39.144.17.132 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230308&time=140301&v1=-01.309&v2=+00.050&v3=-00.958&v4=-00.018&v5=05.9&t=+20.1&h=61.7&rssi=+229&ccid=4600485905031420000099m9990000000346000001g3200,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.011339s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000701s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230308',`time`='140301',`v1`=-1.309,`v2`=0.05,`v3`=-0.958,`v4`=-0.018,`v5`=5.9,`t`=20.1,`h`=61.7,`rssi`=229,`ccid`='4600485905031420000099m9990000000346000001g3200,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678255443  WHERE  `imei` = '868922055643643' [ RunTime:0.000567s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012695s ]
[ 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' , '230308' , '140301' , -1.309 , 0.05 , -0.958 , -0.018 , 5.9 , 20.1 , 61.7 , 229 , '4600485905031420000099m9990000000346000001g3200,N,00E000=-00.000' , 0 , 0 , 1678255443 , 1678255443) [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2023-03-08T14:05:02+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002555s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009691s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000782s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000745s ]
---------------------------------------------------------------
[ 2023-03-08T14:05:07+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009914s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000640s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009269s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000528s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000735s ]
---------------------------------------------------------------
[ 2023-03-08T14:06:31+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017672s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000718s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009739s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000512s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000718s ]
---------------------------------------------------------------
[ 2023-03-08T14:17:52+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010239s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000814s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000761s ]
---------------------------------------------------------------
[ 2023-03-08T14:17:56+08:00 ] 39.88.23.149 GET /admin/show/edit/id/37.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001829s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010574s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000787s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011962s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001247s ]
---------------------------------------------------------------
[ 2023-03-08T14:17:59+08:00 ] 39.88.23.149 POST /admin/show/update.html
[ 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.011742s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='',`interval`=2,`gps`='',`username`='admin',`introduce`='                        ',`update_time`=1678256279  WHERE  `id` = 37 [ RunTime:0.000728s ]
---------------------------------------------------------------
[ 2023-03-08T14:18:00+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002019s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010455s ]
[ 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.000759s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000699s ]
---------------------------------------------------------------
[ 2023-03-08T14:20:58+08:00 ] 39.144.16.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.001789s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010865s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000696s ]
---------------------------------------------------------------
[ 2023-03-08T14:21:00+08:00 ] 39.144.16.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678256458&v1=0.027843&v2=0.729531&v3=0.028114&v4=0.028324&v5=13.320000&t=22.680809&h=45.704407&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011116s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000686s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678256458,`v1`=0.027843,`v2`=0.729531,`v3`=0.028114,`v4`=0.028324,`v5`=13.32,`t`=22.680809,`h`=45.704407,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678256460  WHERE  `imei` = '868922055683912' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011611s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678256458 , 0.027843 , 0.729531 , 0.028114 , 0.028324 , 13.32 , 22.680809 , 45.704407 , 30 , '898604650119C1053138' , '460048590503138' , -0 , 1678256460) [ RunTime:0.000700s ]
---------------------------------------------------------------
[ 2023-03-08T14:21:03+08:00 ] 39.144.16.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=4294938496&v1=0.027783&v2=1.749977&v3=0.028054&v4=0.028264&v5=13.500000&t=21.157845&h=47.085327&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010565s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=4294938496,`v1`=0.027783,`v2`=1.749977,`v3`=0.028054,`v4`=0.028264,`v5`=13.5,`t`=21.157845,`h`=47.085327,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678256463  WHERE  `imei` = '868922055683912' [ RunTime:0.001122s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009879s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 4294938496 , 0.027783 , 1.749977 , 0.028054 , 0.028264 , 13.5 , 21.157845 , 47.085327 , 30 , '898604650119C1053138' , '460048590503138' , -0 , 1678256463) [ RunTime:0.000491s ]
---------------------------------------------------------------
[ 2023-03-08T14:21:05+08:00 ] 39.144.16.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=4294938496&v1=0.027843&v2=1.705959&v3=0.028084&v4=0.028324&v5=13.500000&t=21.833525&h=48.893494&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001755s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010974s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=4294938496,`v1`=0.027843,`v2`=1.705959,`v3`=0.028084,`v4`=0.028324,`v5`=13.5,`t`=21.833525,`h`=48.893494,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678256465  WHERE  `imei` = '868922055683912' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010332s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 4294938496 , 0.027843 , 1.705959 , 0.028084 , 0.028324 , 13.5 , 21.833525 , 48.893494 , 30 , '898604650119C1053138' , '460048590503138' , -0 , 1678256465) [ RunTime:0.000623s ]
---------------------------------------------------------------
[ 2023-03-08T14:21:07+08:00 ] 39.144.16.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=4294938496&v1=0.027903&v2=0.722542&v3=0.028114&v4=0.028264&v5=13.500000&t=22.187454&h=45.300049&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000649s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=4294938496,`v1`=0.027903,`v2`=0.722542,`v3`=0.028114,`v4`=0.028264,`v5`=13.5,`t`=22.187454,`h`=45.300049,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678256467  WHERE  `imei` = '868922055683912' [ RunTime:0.000522s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010924s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 4294938496 , 0.027903 , 0.722542 , 0.028114 , 0.028264 , 13.5 , 22.187454 , 45.300049 , 30 , '898604650119C1053138' , '460048590503138' , -0 , 1678256467) [ RunTime:0.000516s ]
---------------------------------------------------------------
[ 2023-03-08T14:30:11+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002371s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009433s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010270s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000496s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000783s ]
---------------------------------------------------------------
[ 2023-03-08T14:30:16+08:00 ] 39.144.14.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.008885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2023-03-08T14:30:17+08:00 ] 39.144.14.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678257016&v1=0.027722&v2=6.595090&v3=0.028084&v4=0.028204&v5=13.320000&t=25.394258&h=45.963806&rssi=31&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010332s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678257016,`v1`=0.027722,`v2`=6.59509,`v3`=0.028084,`v4`=0.028204,`v5`=13.32,`t`=25.394258,`h`=45.963806,`rssi`=31,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678257017  WHERE  `imei` = '868922055683912' [ RunTime:0.000545s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011102s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678257016 , 0.027722 , 6.59509 , 0.028084 , 0.028204 , 13.32 , 25.394258 , 45.963806 , 31 , '898604650119C1053138' , '460048590503138' , -0 , 1678257017) [ RunTime:0.001026s ]
---------------------------------------------------------------
[ 2023-03-08T14:30:24+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002110s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010177s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000745s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012701s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000474s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000712s ]
---------------------------------------------------------------
[ 2023-03-08T14:30:28+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009998s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000761s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011239s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000477s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000720s ]
---------------------------------------------------------------
[ 2023-03-08T14:32:27+08:00 ] 117.132.198.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.001973s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010222s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000654s ]
---------------------------------------------------------------
[ 2023-03-08T14:32:29+08:00 ] 117.132.198.101 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678257147&v1=0.027963&v2=1.990512&v3=0.028234&v4=0.028385&v5=13.320000&t=24.589876&h=40.974182&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009639s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678257147,`v1`=0.027963,`v2`=1.990512,`v3`=0.028234,`v4`=0.028385,`v5`=13.32,`t`=24.589876,`h`=40.974182,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678257149  WHERE  `imei` = '868922055683912' [ RunTime:0.000795s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009601s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678257147 , 0.027963 , 1.990512 , 0.028234 , 0.028385 , 13.32 , 24.589876 , 40.974182 , 30 , '898604650119C1053138' , '460048590503138' , -0 , 1678257149) [ RunTime:0.000538s ]
---------------------------------------------------------------
[ 2023-03-08T14:32:35+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010744s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011455s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000489s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000748s ]
---------------------------------------------------------------
[ 2023-03-08T14:33:55+08:00 ] 39.144.2.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010621s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000649s ]
---------------------------------------------------------------
[ 2023-03-08T14:33:56+08:00 ] 39.144.2.124 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678257235&v1=0.027963&v2=0.882551&v3=0.028234&v4=0.028445&v5=13.320000&t=24.364649&h=39.860291&rssi=31&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009529s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000862s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678257235,`v1`=0.027963,`v2`=0.882551,`v3`=0.028234,`v4`=0.028445,`v5`=13.32,`t`=24.364649,`h`=39.860291,`rssi`=31,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678257236  WHERE  `imei` = '868922055683912' [ RunTime:0.000542s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010583s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678257235 , 0.027963 , 0.882551 , 0.028234 , 0.028445 , 13.32 , 24.364649 , 39.860291 , 31 , '898604650119C1053138' , '460048590503138' , -0 , 1678257236) [ RunTime:0.000529s ]
---------------------------------------------------------------
[ 2023-03-08T14:35:28+08:00 ] 39.144.15.206 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.001916s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010967s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2023-03-08T14:35:29+08:00 ] 39.144.15.206 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678257328&v1=0.028084&v2=0.752270&v3=0.028234&v4=0.028264&v5=13.320000&t=24.075071&h=40.340942&rssi=31&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011395s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000664s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678257328,`v1`=0.028084,`v2`=0.75227,`v3`=0.028234,`v4`=0.028264,`v5`=13.32,`t`=24.075071,`h`=40.340942,`rssi`=31,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678257329  WHERE  `imei` = '868922055683912' [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010929s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678257328 , 0.028084 , 0.75227 , 0.028234 , 0.028264 , 13.32 , 24.075071 , 40.340942 , 31 , '898604650119C1053138' , '460048590503138' , -0 , 1678257329) [ RunTime:0.000579s ]
---------------------------------------------------------------
[ 2023-03-08T14:39:27+08:00 ] 39.144.6.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010870s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000690s ]
---------------------------------------------------------------
[ 2023-03-08T14:39:29+08:00 ] 39.144.6.64 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678257567&v1=0.027903&v2=0.531137&v3=0.028204&v4=0.028385&v5=13.320000&t=23.377939&h=40.554565&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010268s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000653s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678257567,`v1`=0.027903,`v2`=0.531137,`v3`=0.028204,`v4`=0.028385,`v5`=13.32,`t`=23.377939,`h`=40.554565,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678257569  WHERE  `imei` = '868922055683912' [ RunTime:0.000542s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010214s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678257567 , 0.027903 , 0.531137 , 0.028204 , 0.028385 , 13.32 , 23.377939 , 40.554565 , 20 , '898604650119C1053138' , '460048590503138' , -0 , 1678257569) [ RunTime:0.000540s ]
---------------------------------------------------------------
[ 2023-03-08T14:39:30+08:00 ] 39.144.6.64 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678257421&v1=0.028144&v2=0.769690&v3=0.028174&v4=0.028385&v5=13.500000&t=23.796219&h=40.157837&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001892s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010729s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000714s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1678257421,`v1`=0.028144,`v2`=0.76969,`v3`=0.028174,`v4`=0.028385,`v5`=13.5,`t`=23.796219,`h`=40.157837,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678257570  WHERE  `imei` = '868922055683912' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011364s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678257421 , 0.028144 , 0.76969 , 0.028174 , 0.028385 , 13.5 , 23.796219 , 40.157837 , 20 , '898604650119C1053138' , '460048590503138' , -0 , 1678257570) [ RunTime:0.000533s ]
---------------------------------------------------------------
[ 2023-03-08T14:39:34+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010942s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010733s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000481s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000736s ]
---------------------------------------------------------------
[ 2023-03-08T14:45:06+08:00 ] 218.204.252.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.001793s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.018023s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000697s ]
---------------------------------------------------------------
[ 2023-03-08T14:45:07+08:00 ] 218.204.252.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678257906&v1=0.015080&v2=3.506944&v3=0.015321&v4=0.015562&v5=13.320000&t=19.559805&h=59.132141&rssi=17&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001931s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010606s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678257906,`v1`=0.01508,`v2`=3.506944,`v3`=0.015321,`v4`=0.015562,`v5`=13.32,`t`=19.559805,`h`=59.132141,`rssi`=17,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678257907  WHERE  `imei` = '868922055683920' [ RunTime:0.000565s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011294s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678257906 , 0.01508 , 3.506944 , 0.015321 , 0.015562 , 13.32 , 19.559805 , 59.132141 , 17 , '89860426102071188500' , '460044618415250' , -0 , 1678257907) [ RunTime:0.002671s ]
---------------------------------------------------------------
[ 2023-03-08T14:45:42+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012472s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000853s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000687s ]
---------------------------------------------------------------
[ 2023-03-08T14:45:44+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ 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.011159s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000346s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000724s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000683s ]
---------------------------------------------------------------
[ 2023-03-08T14:45:47+08:00 ] 39.88.23.149 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000696s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009638s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000784s ]
---------------------------------------------------------------
[ 2023-03-08T14:48:35+08:00 ] 221.178.126.254 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.001774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009066s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000719s ]
---------------------------------------------------------------
[ 2023-03-08T14:48:37+08:00 ] 221.178.126.254 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678258115&v1=0.007254&v2=0.384480&v3=0.007405&v4=0.007736&v5=12.060000&t=20.310452&h=60.711475&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009940s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000665s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1678258115,`v1`=0.007254,`v2`=0.38448,`v3`=0.007405,`v4`=0.007736,`v5`=12.06,`t`=20.310452,`h`=60.711475,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678258117  WHERE  `imei` = '868922055677740' [ RunTime:0.000526s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009779s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678258115 , 0.007254 , 0.38448 , 0.007405 , 0.007736 , 12.06 , 20.310452 , 60.711475 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1678258117) [ RunTime:0.001156s ]
---------------------------------------------------------------
[ 2023-03-08T14:51:30+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002602s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009436s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000383s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000779s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000717s ]
---------------------------------------------------------------
[ 2023-03-08T14:51:37+08:00 ] 39.88.23.149 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009552s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000444s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000763s ]
---------------------------------------------------------------
[ 2023-03-08T14:51:39+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010118s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000743s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010517s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000607s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000968s ]
---------------------------------------------------------------
[ 2023-03-08T15:04:14+08:00 ] 39.144.6.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002359s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011663s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000678s ]
---------------------------------------------------------------
[ 2023-03-08T15:04:16+08:00 ] 39.144.6.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678259054&v1=0.003883&v2=3.121838&v3=0.004274&v4=0.004605&v5=12.240000&t=21.887152&h=56.904358&rssi=18&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000646s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678259054,`v1`=0.003883,`v2`=3.121838,`v3`=0.004274,`v4`=0.004605,`v5`=12.24,`t`=21.887152,`h`=56.904358,`rssi`=18,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678259056  WHERE  `imei` = '868922055644021' [ RunTime:0.000523s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009781s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678259054 , 0.003883 , 3.121838 , 0.004274 , 0.004605 , 12.24 , 21.887152 , 56.904358 , 18 , '898604650119C1053141' , '460048590503141' , -0 , 1678259056) [ RunTime:0.000549s ]
---------------------------------------------------------------
[ 2023-03-08T15:06:05+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.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_show` [ RunTime:0.009827s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000654s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009719s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000553s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000860s ]
---------------------------------------------------------------
[ 2023-03-08T15:06:53+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011087s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010705s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000577s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000935s ]
---------------------------------------------------------------
[ 2023-03-08T15:07:14+08:00 ] 39.144.11.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002219s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011481s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001064s ]
---------------------------------------------------------------
[ 2023-03-08T15:07:15+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ 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.009580s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010197s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001540s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001078s ]
---------------------------------------------------------------
[ 2023-03-08T15:07:16+08:00 ] 39.144.11.209 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678259234&v1=0.004365&v2=1.295090&v3=0.003281&v4=0.001836&v5=6.120000&t=22.283979&h=55.988831&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010387s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000661s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678259234,`v1`=0.004365,`v2`=1.29509,`v3`=0.003281,`v4`=0.001836,`v5`=6.12,`t`=22.283979,`h`=55.988831,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678259236  WHERE  `imei` = '868922055644021' [ RunTime:0.000600s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011946s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678259234 , 0.004365 , 1.29509 , 0.003281 , 0.001836 , 6.12 , 22.283979 , 55.988831 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678259236) [ RunTime:0.000654s ]
---------------------------------------------------------------
[ 2023-03-08T15:07:31+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009453s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000625s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009323s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000547s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000905s ]
---------------------------------------------------------------
[ 2023-03-08T15:10:05+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002902s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000761s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010596s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000928s ]
---------------------------------------------------------------
[ 2023-03-08T15:10:07+08:00 ] 111.55.136.95 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002183s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012480s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001046s ]
---------------------------------------------------------------
[ 2023-03-08T15:10:09+08:00 ] 111.55.136.95 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678259407&v1=-1.005924&v2=0.047043&v3=-0.011318&v4=0.004365&v5=6.120000&t=22.144554&h=56.385559&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.002955s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011289s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000881s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678259407,`v1`=-1.005924,`v2`=0.047043,`v3`=-0.011318,`v4`=0.004365,`v5`=6.12,`t`=22.144554,`h`=56.385559,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678259409  WHERE  `imei` = '868922055644021' [ RunTime:0.000805s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010140s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678259407 , -1.005924 , 0.047043 , -0.011318 , 0.004365 , 6.12 , 22.144554 , 56.385559 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678259409) [ RunTime:0.000774s ]
---------------------------------------------------------------
[ 2023-03-08T15:12:27+08:00 ] 218.204.253.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.003570s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013619s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000718s ]
---------------------------------------------------------------
[ 2023-03-08T15:12:29+08:00 ] 218.204.253.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678259547&v1=-1.005683&v2=0.039950&v3=-0.012431&v4=0.004485&v5=6.120000&t=22.080202&h=56.271118&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012100s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000746s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678259547,`v1`=-1.005683,`v2`=0.03995,`v3`=-0.012431,`v4`=0.004485,`v5`=6.12,`t`=22.080202,`h`=56.271118,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678259549  WHERE  `imei` = '868922055644021' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010760s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678259547 , -1.005683 , 0.03995 , -0.012431 , 0.004485 , 6.12 , 22.080202 , 56.271118 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678259549) [ RunTime:0.000697s ]
---------------------------------------------------------------
[ 2023-03-08T15:12:49+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012333s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000793s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000774s ]
---------------------------------------------------------------
[ 2023-03-08T15:12:57+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.005131s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013617s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009882s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000710s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007354s ]
---------------------------------------------------------------
[ 2023-03-08T15:14:28+08:00 ] 117.132.191.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010674s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2023-03-08T15:14:30+08:00 ] 117.132.191.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678259668&v1=-1.005683&v2=0.040263&v3=-0.010926&v4=0.004425&v5=6.120000&t=22.037302&h=56.271118&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.001588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010751s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000646s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678259668,`v1`=-1.005683,`v2`=0.040263,`v3`=-0.010926,`v4`=0.004425,`v5`=6.12,`t`=22.037302,`h`=56.271118,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678259669  WHERE  `imei` = '868922055644021' [ RunTime:0.000515s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009767s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678259668 , -1.005683 , 0.040263 , -0.010926 , 0.004425 , 6.12 , 22.037302 , 56.271118 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678259670) [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2023-03-08T15:15:09+08:00 ] 39.88.23.149 GET /admin/show/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_show` [ RunTime:0.010703s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000868s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000792s ]
---------------------------------------------------------------
[ 2023-03-08T15:15:12+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002254s ] 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  `id` = 41 LIMIT 1 [ RunTime:0.000772s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011302s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001156s ]
---------------------------------------------------------------
[ 2023-03-08T15:17:13+08:00 ] 39.144.6.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010233s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2023-03-08T15:17:14+08:00 ] 39.144.6.210 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678259833&v1=-1.006345&v2=0.100657&v3=-1.012756&v4=0.004425&v5=6.120000&t=21.801350&h=56.561035&rssi=14&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.002415s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000650s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678259833,`v1`=-1.006345,`v2`=0.100657,`v3`=-1.012756,`v4`=0.004425,`v5`=6.12,`t`=21.80135,`h`=56.561035,`rssi`=14,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678259834  WHERE  `imei` = '868922055644021' [ RunTime:0.000515s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009239s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678259833 , -1.006345 , 0.100657 , -1.012756 , 0.004425 , 6.12 , 21.80135 , 56.561035 , 14 , '898604650119C1053141' , '460048590503141' , -0 , 1678259834) [ RunTime:0.000522s ]
---------------------------------------------------------------
[ 2023-03-08T15:18:31+08:00 ] 39.88.23.149 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.009644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010951s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000598s ]
---------------------------------------------------------------
[ 2023-03-08T15:18:44+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010075s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000369s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000814s ]
---------------------------------------------------------------
[ 2023-03-08T15:18:55+08:00 ] 39.88.23.149 GET /admin/show/index.html?keyword=4021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011499s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%4021%' LIMIT 1 [ RunTime:0.000462s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%4021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000919s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000750s ]
---------------------------------------------------------------
[ 2023-03-08T15:19:52+08:00 ] 39.88.23.149 GET /admin/show/index.html?keyword=4021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011348s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%4021%' LIMIT 1 [ RunTime:0.000513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%4021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000704s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000812s ]
---------------------------------------------------------------
[ 2023-03-08T15:20:17+08:00 ] 39.144.13.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002394s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010521s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000715s ]
---------------------------------------------------------------
[ 2023-03-08T15:20:18+08:00 ] 39.144.13.14 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678260017&v1=0.004726&v2=5.340889&v3=0.004064&v4=-1.009235&v5=5.580000&t=21.651199&h=56.591553&rssi=16&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011072s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678260017,`v1`=0.004726,`v2`=5.340889,`v3`=0.004064,`v4`=-1.009235,`v5`=5.58,`t`=21.651199,`h`=56.591553,`rssi`=16,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678260018  WHERE  `imei` = '868922055644021' [ RunTime:0.000530s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010532s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678260017 , 0.004726 , 5.340889 , 0.004064 , -1.009235 , 5.58 , 21.651199 , 56.591553 , 16 , '898604650119C1053141' , '460048590503141' , -0 , 1678260018) [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2023-03-08T15:20:23+08:00 ] 39.88.23.149 GET /admin/show/index.html?keyword=4021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011029s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%4021%' LIMIT 1 [ RunTime:0.000518s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%4021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000732s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000788s ]
---------------------------------------------------------------
[ 2023-03-08T15:22:27+08:00 ] 39.144.4.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.003661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014325s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000916s ]
---------------------------------------------------------------
[ 2023-03-08T15:22:29+08:00 ] 39.144.4.79 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678260147&v1=0.004184&v2=1.738608&v3=0.004214&v4=0.002378&v5=6.120000&t=21.619024&h=56.530518&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001903s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009937s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678260147,`v1`=0.004184,`v2`=1.738608,`v3`=0.004214,`v4`=0.002378,`v5`=6.12,`t`=21.619024,`h`=56.530518,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678260149  WHERE  `imei` = '868922055644021' [ RunTime:0.000524s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011189s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678260147 , 0.004184 , 1.738608 , 0.004214 , 0.002378 , 6.12 , 21.619024 , 56.530518 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678260149) [ RunTime:0.000603s ]
---------------------------------------------------------------
[ 2023-03-08T15:24:27+08:00 ] 39.144.4.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001556s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008915s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-03-08T15:24:29+08:00 ] 39.144.4.152 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678260267&v1=0.004244&v2=1.635343&v3=0.004214&v4=0.004124&v5=6.120000&t=21.586847&h=56.500000&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.004900s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012345s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000914s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678260267,`v1`=0.004244,`v2`=1.635343,`v3`=0.004214,`v4`=0.004124,`v5`=6.12,`t`=21.586847,`h`=56.5,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678260269  WHERE  `imei` = '868922055644021' [ RunTime:0.000858s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010821s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678260267 , 0.004244 , 1.635343 , 0.004214 , 0.004124 , 6.12 , 21.586847 , 56.5 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678260269) [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2023-03-08T15:26:01+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009222s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000704s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010121s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000597s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000900s ]
---------------------------------------------------------------
[ 2023-03-08T15:26:10+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012201s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000409s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001001s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000936s ]
---------------------------------------------------------------
[ 2023-03-08T15:26:12+08:00 ] 39.88.23.149 GET /admin/show/edit/id/41.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010628s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000653s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011317s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000459s ]
---------------------------------------------------------------
[ 2023-03-08T15:26:27+08:00 ] 221.178.126.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001730s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010929s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000675s ]
---------------------------------------------------------------
[ 2023-03-08T15:26:29+08:00 ] 221.178.126.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678260387&v1=0.004244&v2=0.021800&v3=0.004274&v4=0.005207&v5=5.940000&t=21.533222&h=56.446594&rssi=17&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001806s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010756s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000698s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678260387,`v1`=0.004244,`v2`=0.0218,`v3`=0.004274,`v4`=0.005207,`v5`=5.94,`t`=21.533222,`h`=56.446594,`rssi`=17,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678260389  WHERE  `imei` = '868922055644021' [ RunTime:0.000540s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011428s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678260387 , 0.004244 , 0.0218 , 0.004274 , 0.005207 , 5.94 , 21.533222 , 56.446594 , 17 , '898604650119C1053141' , '460048590503141' , -0 , 1678260389) [ RunTime:0.000512s ]
---------------------------------------------------------------
[ 2023-03-08T15:27:55+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002730s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010330s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000371s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000762s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000825s ]
---------------------------------------------------------------
[ 2023-03-08T15:27:57+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009936s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000392s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000822s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000716s ]
---------------------------------------------------------------
[ 2023-03-08T15:28:08+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.002257s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010614s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000502s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000831s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000754s ]
---------------------------------------------------------------
[ 2023-03-08T15:28:28+08:00 ] 218.204.252.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010673s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000788s ]
---------------------------------------------------------------
[ 2023-03-08T15:28:29+08:00 ] 218.204.252.190 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678260508&v1=0.004244&v2=0.015333&v3=0.004274&v4=0.004666&v5=6.480000&t=21.511772&h=56.355042&rssi=16&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002172s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011914s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000856s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678260508,`v1`=0.004244,`v2`=0.015333,`v3`=0.004274,`v4`=0.004666,`v5`=6.48,`t`=21.511772,`h`=56.355042,`rssi`=16,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678260509  WHERE  `imei` = '868922055644021' [ RunTime:0.001061s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011747s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678260508 , 0.004244 , 0.015333 , 0.004274 , 0.004666 , 6.48 , 21.511772 , 56.355042 , 16 , '898604650119C1053141' , '460048590503141' , -0 , 1678260509) [ RunTime:0.000990s ]
---------------------------------------------------------------
[ 2023-03-08T15:30:30+08:00 ] 221.178.125.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010758s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000833s ]
---------------------------------------------------------------
[ 2023-03-08T15:30:31+08:00 ] 221.178.125.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1678260630&v1=0.004365&v2=0.017837&v3=0.004274&v4=0.004726&v5=6.480000&t=21.565397&h=56.156677&rssi=15&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012164s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000704s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1678260630,`v1`=0.004365,`v2`=0.017837,`v3`=0.004274,`v4`=0.004726,`v5`=6.48,`t`=21.565397,`h`=56.156677,`rssi`=15,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1678260631  WHERE  `imei` = '868922055644021' [ RunTime:0.000535s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010769s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1678260630 , 0.004365 , 0.017837 , 0.004274 , 0.004726 , 6.48 , 21.565397 , 56.156677 , 15 , '898604650119C1053141' , '460048590503141' , -0 , 1678260631) [ RunTime:0.000514s ]
---------------------------------------------------------------
[ 2023-03-08T15:30:42+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010797s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000400s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000815s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000740s ]
---------------------------------------------------------------
[ 2023-03-08T15:39:23+08:00 ] 112.224.69.65 GET /admin/show/create.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002312s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011485s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000591s ]
---------------------------------------------------------------
[ 2023-03-08T15:39:41+08:00 ] 112.224.69.65 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013639s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001189s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000602s ]
---------------------------------------------------------------
[ 2023-03-08T15:39:54+08:00 ] 112.224.69.65 GET /admin/device/index.html?keyword=4201
[ sql ] [ DB ] CONNECT:[ UseTime:0.001894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009738s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `unique_identification_number` LIKE '%4201%' LIMIT 1 [ RunTime:0.001362s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `unique_identification_number` LIKE '%4201%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000514s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000638s ]
---------------------------------------------------------------
[ 2023-03-08T15:40:44+08:00 ] 112.224.69.65 GET /admin/device/index.html?keyword=4201
[ sql ] [ DB ] CONNECT:[ UseTime:0.001439s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012462s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `unique_identification_number` LIKE '%4201%' LIMIT 1 [ RunTime:0.000511s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `unique_identification_number` LIKE '%4201%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000629s ]
---------------------------------------------------------------
[ 2023-03-08T16:13:59+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.003356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014060s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000773s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:00+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678263239&v1=0.015441&v2=1.553878&v3=0.015532&v4=0.015562&v5=13.320000&t=20.921892&h=50.282043&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011074s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000719s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678263239,`v1`=0.015441,`v2`=1.553878,`v3`=0.015532,`v4`=0.015562,`v5`=13.32,`t`=20.921892,`h`=50.282043,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263240  WHERE  `imei` = '868922055683920' [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010560s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678263239 , 0.015441 , 1.553878 , 0.015532 , 0.015562 , 13.32 , 20.921892 , 50.282043 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263240) [ RunTime:0.000824s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:01+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=4294938496&v1=0.015321&v2=2.653390&v3=0.015532&v4=0.015622&v5=13.320000&t=21.576122&h=51.739258&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016784s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000840s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=4294938496,`v1`=0.015321,`v2`=2.65339,`v3`=0.015532,`v4`=0.015622,`v5`=13.32,`t`=21.576122,`h`=51.739258,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263241  WHERE  `imei` = '868922055683920' [ RunTime:0.000581s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012961s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 4294938496 , 0.015321 , 2.65339 , 0.015532 , 0.015622 , 13.32 , 21.576122 , 51.739258 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263241) [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:03+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=4294938496&v1=0.015381&v2=2.314180&v3=0.015622&v4=0.015682&v5=13.320000&t=22.155279&h=48.504395&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012232s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001132s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=4294938496,`v1`=0.015381,`v2`=2.31418,`v3`=0.015622,`v4`=0.015682,`v5`=13.32,`t`=22.155279,`h`=48.504395,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263243  WHERE  `imei` = '868922055683920' [ RunTime:0.000588s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011535s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 4294938496 , 0.015381 , 2.31418 , 0.015622 , 0.015682 , 13.32 , 22.155279 , 48.504395 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263243) [ RunTime:0.000566s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:04+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1575515471&v1=0.015261&v2=0.451550&v3=0.015592&v4=0.015742&v5=13.320000&t=21.522497&h=48.954529&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011082s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1575515471,`v1`=0.015261,`v2`=0.45155,`v3`=0.015592,`v4`=0.015742,`v5`=13.32,`t`=21.522497,`h`=48.954529,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263244  WHERE  `imei` = '868922055683920' [ RunTime:0.000550s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011132s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1575515471 , 0.015261 , 0.45155 , 0.015592 , 0.015742 , 13.32 , 21.522497 , 48.954529 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263244) [ RunTime:0.000915s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:06+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1575515581&v1=0.015562&v2=1.401693&v3=0.015622&v4=0.015742&v5=13.320000&t=21.994402&h=47.359985&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1575515581,`v1`=0.015562,`v2`=1.401693,`v3`=0.015622,`v4`=0.015742,`v5`=13.32,`t`=21.994402,`h`=47.359985,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263246  WHERE  `imei` = '868922055683920' [ RunTime:0.000789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009794s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1575515581 , 0.015562 , 1.401693 , 0.015622 , 0.015742 , 13.32 , 21.994402 , 47.359985 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263246) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:07+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1575515701&v1=0.015562&v2=1.154378&v3=0.015652&v4=0.015742&v5=13.320000&t=22.241079&h=45.376343&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011561s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000633s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1575515701,`v1`=0.015562,`v2`=1.154378,`v3`=0.015652,`v4`=0.015742,`v5`=13.32,`t`=22.241079,`h`=45.376343,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263247  WHERE  `imei` = '868922055683920' [ RunTime:0.000495s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010503s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1575515701 , 0.015562 , 1.154378 , 0.015652 , 0.015742 , 13.32 , 22.241079 , 45.376343 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263247) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:08+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1575515821&v1=0.015381&v2=1.380518&v3=0.015622&v4=0.015742&v5=13.320000&t=22.262529&h=45.963806&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009707s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000713s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1575515821,`v1`=0.015381,`v2`=1.380518,`v3`=0.015622,`v4`=0.015742,`v5`=13.32,`t`=22.262529,`h`=45.963806,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263248  WHERE  `imei` = '868922055683920' [ RunTime:0.000519s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009243s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1575515821 , 0.015381 , 1.380518 , 0.015622 , 0.015742 , 13.32 , 22.262529 , 45.963806 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263248) [ RunTime:0.000542s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:10+08:00 ] 117.132.197.197 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=4294938496&v1=0.015502&v2=2.199337&v3=0.015532&v4=0.015742&v5=13.320000&t=21.254370&h=49.389404&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001849s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010209s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000782s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=4294938496,`v1`=0.015502,`v2`=2.199337,`v3`=0.015532,`v4`=0.015742,`v5`=13.32,`t`=21.25437,`h`=49.389404,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263250  WHERE  `imei` = '868922055683920' [ RunTime:0.000589s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010187s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 4294938496 , 0.015502 , 2.199337 , 0.015532 , 0.015742 , 13.32 , 21.25437 , 49.389404 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263250) [ RunTime:0.000579s ]
---------------------------------------------------------------
[ 2023-03-08T16:14:38+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010300s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000629s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010684s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000589s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003023s ]
---------------------------------------------------------------
[ 2023-03-08T16:17:47+08:00 ] 117.132.196.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012219s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000772s ]
---------------------------------------------------------------
[ 2023-03-08T16:17:48+08:00 ] 117.132.196.179 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678263467&v1=0.015441&v2=1.659751&v3=0.015562&v4=0.015562&v5=13.140000&t=21.082769&h=49.885315&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010308s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678263467,`v1`=0.015441,`v2`=1.659751,`v3`=0.015562,`v4`=0.015562,`v5`=13.14,`t`=21.082769,`h`=49.885315,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263468  WHERE  `imei` = '868922055683920' [ RunTime:0.000584s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012111s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678263467 , 0.015441 , 1.659751 , 0.015562 , 0.015562 , 13.14 , 21.082769 , 49.885315 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678263468) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-03-08T16:17:57+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011012s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010837s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000724s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003180s ]
---------------------------------------------------------------
[ 2023-03-08T16:17:58+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002193s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011113s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000825s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010674s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000730s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003226s ]
---------------------------------------------------------------
[ 2023-03-08T16:17:59+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012079s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009834s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000686s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003314s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:00+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002572s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011487s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000734s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011600s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000719s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003156s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:01+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015576s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.001441s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013779s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003354s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:02+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010270s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000771s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010446s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000824s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003858s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:03+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011649s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000762s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010321s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000671s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003663s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:04+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009831s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000686s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010248s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003333s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:05+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001889s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011467s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000763s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013265s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000712s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003712s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:06+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002057s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009911s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000685s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010513s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000943s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003015s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:06+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011077s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000705s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010579s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003205s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:07+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012519s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000830s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010134s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000625s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003162s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:10+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012069s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000776s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010451s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003244s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:11+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.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_show` [ RunTime:0.012406s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010237s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000789s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003094s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:17+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.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_show` [ RunTime:0.010811s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000777s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010243s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000729s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003333s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:24+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009453s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008748s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000988s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003455s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:25+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011695s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000709s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011095s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000695s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003171s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:26+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ 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.010309s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000664s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011510s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000685s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003145s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:26+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] 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  `id` = 30 LIMIT 1 [ RunTime:0.000658s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010075s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000626s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003026s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:27+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011004s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.001191s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010407s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003904s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:27+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.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_show` [ RunTime:0.012348s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.001015s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010995s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000785s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004080s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:28+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011741s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000848s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010129s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003948s ]
---------------------------------------------------------------
[ 2023-03-08T16:18:28+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012158s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010942s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000802s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004443s ]
---------------------------------------------------------------
[ 2023-03-08T16:21:01+08:00 ] 39.144.16.154 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011636s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2023-03-08T16:21:03+08:00 ] 39.144.16.154 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678263661&v1=0.015441&v2=1.195371&v3=0.015622&v4=0.015562&v5=13.140000&t=21.136395&h=50.999207&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001861s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011963s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000760s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678263661,`v1`=0.015441,`v2`=1.195371,`v3`=0.015622,`v4`=0.015562,`v5`=13.14,`t`=21.136395,`h`=50.999207,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678263663  WHERE  `imei` = '868922055683920' [ RunTime:0.000573s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009676s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678263661 , 0.015441 , 1.195371 , 0.015622 , 0.015562 , 13.14 , 21.136395 , 50.999207 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1678263663) [ RunTime:0.000574s ]
---------------------------------------------------------------
[ 2023-03-08T16:30:49+08:00 ] 39.144.15.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011186s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000679s ]
---------------------------------------------------------------
[ 2023-03-08T16:30:51+08:00 ] 39.144.15.111 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678264249&v1=0.015080&v2=2.725780&v3=0.015381&v4=0.015562&v5=13.140000&t=20.342737&h=51.670593&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008707s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000636s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678264249,`v1`=0.01508,`v2`=2.72578,`v3`=0.015381,`v4`=0.015562,`v5`=13.14,`t`=20.342737,`h`=51.670593,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678264251  WHERE  `imei` = '868922055683920' [ RunTime:0.000497s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011738s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678264249 , 0.01508 , 2.72578 , 0.015381 , 0.015562 , 13.14 , 20.342737 , 51.670593 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1678264251) [ RunTime:0.000539s ]
---------------------------------------------------------------
[ 2023-03-08T16:30:59+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009196s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000750s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011163s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000853s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003343s ]
---------------------------------------------------------------
[ 2023-03-08T16:31:08+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ 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.010155s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000416s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000762s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000779s ]
---------------------------------------------------------------
[ 2023-03-08T16:31:13+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002335s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010918s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000734s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011504s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000646s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003545s ]
---------------------------------------------------------------
[ 2023-03-08T16:32:24+08:00 ] 117.132.197.31 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002032s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011641s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000758s ]
---------------------------------------------------------------
[ 2023-03-08T16:32:25+08:00 ] 117.132.197.31 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678264344&v1=0.015261&v2=0.965685&v3=0.015562&v4=0.015742&v5=13.140000&t=21.222195&h=48.893494&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002606s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012235s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000847s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678264344,`v1`=0.015261,`v2`=0.965685,`v3`=0.015562,`v4`=0.015742,`v5`=13.14,`t`=21.222195,`h`=48.893494,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678264345  WHERE  `imei` = '868922055683920' [ RunTime:0.000612s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012170s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678264344 , 0.015261 , 0.965685 , 0.015562 , 0.015742 , 13.14 , 21.222195 , 48.893494 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1678264345) [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2023-03-08T16:32:50+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002314s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010618s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011186s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000595s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003087s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:22+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010301s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000802s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000765s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:26+08:00 ] 39.88.23.149 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010403s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 41 LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009595s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001308s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001062s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:29+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009287s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000428s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000782s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000754s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:36+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009719s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000808s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000768s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:40+08:00 ] 39.88.23.149 GET /admin/show/read/id/8/imei/86703205226912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009307s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 8 LIMIT 1 [ RunTime:0.000633s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009683s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '86703205226912' LIMIT 1 [ RunTime:0.002160s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '86703205226912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000739s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:42+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010623s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000733s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000743s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:45+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011093s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000909s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000882s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:47+08:00 ] 39.88.23.149 GET /admin/show/read/id/20/imei/868922056976075.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011867s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 20 LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010691s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922056976075' LIMIT 1 [ RunTime:0.000517s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922056976075' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001313s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:52+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009628s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000690s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000784s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000763s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:53+08:00 ] 39.88.23.149 GET /admin/show/read/id/21/imei/867032052269912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009419s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 21 LIMIT 1 [ RunTime:0.000638s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010720s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '867032052269912' LIMIT 1 [ RunTime:0.000588s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '867032052269912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004332s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:57+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010621s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000388s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000744s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000759s ]
---------------------------------------------------------------
[ 2023-03-08T16:35:59+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010865s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000378s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000806s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000793s ]
---------------------------------------------------------------
[ 2023-03-08T16:36:02+08:00 ] 39.88.23.149 GET /admin/show/read/id/24/imei/868922055681221.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009910s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 24 LIMIT 1 [ RunTime:0.000631s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010020s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055681221' LIMIT 1 [ RunTime:0.002381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007342s ]
---------------------------------------------------------------
[ 2023-03-08T16:36:17+08:00 ] 39.88.23.149 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001607s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009344s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001040s ]
---------------------------------------------------------------
[ 2023-03-08T16:37:47+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002134s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011106s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000792s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000721s ]
---------------------------------------------------------------
[ 2023-03-08T16:37:51+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.003258s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016059s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000529s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000904s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000865s ]
---------------------------------------------------------------
[ 2023-03-08T16:37:56+08:00 ] 39.88.23.149 GET /admin/show/read/id/24/imei/868922055681221.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014629s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 24 LIMIT 1 [ RunTime:0.000712s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010716s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000899s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055681221' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005735s ]
---------------------------------------------------------------
[ 2023-03-08T16:38:23+08:00 ] 221.178.125.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.001831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000669s ]
---------------------------------------------------------------
[ 2023-03-08T16:38:25+08:00 ] 221.178.125.143 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678264703&v1=0.015502&v2=1.413688&v3=0.015592&v4=0.015682&v5=13.140000&t=21.297270&h=49.221558&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002063s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012790s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000945s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678264703,`v1`=0.015502,`v2`=1.413688,`v3`=0.015592,`v4`=0.015682,`v5`=13.14,`t`=21.29727,`h`=49.221558,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678264705  WHERE  `imei` = '868922055683920' [ RunTime:0.000979s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010945s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678264703 , 0.015502 , 1.413688 , 0.015592 , 0.015682 , 13.14 , 21.29727 , 49.221558 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678264705) [ RunTime:0.000843s ]
---------------------------------------------------------------
[ 2023-03-08T16:38:27+08:00 ] 221.178.125.143 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678264441&v1=0.015441&v2=1.044020&v3=0.015562&v4=0.015441&v5=13.320000&t=21.436697&h=48.237366&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010037s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000691s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678264441,`v1`=0.015441,`v2`=1.04402,`v3`=0.015562,`v4`=0.015441,`v5`=13.32,`t`=21.436697,`h`=48.237366,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678264707  WHERE  `imei` = '868922055683920' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009708s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678264441 , 0.015441 , 1.04402 , 0.015562 , 0.015441 , 13.32 , 21.436697 , 48.237366 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678264707) [ RunTime:0.000628s ]
---------------------------------------------------------------
[ 2023-03-08T16:38:29+08:00 ] 221.178.125.143 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678264561&v1=0.015381&v2=1.251489&v3=0.015532&v4=0.015562&v5=13.320000&t=21.361622&h=48.862976&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001678s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010432s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000656s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678264561,`v1`=0.015381,`v2`=1.251489,`v3`=0.015532,`v4`=0.015562,`v5`=13.32,`t`=21.361622,`h`=48.862976,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678264709  WHERE  `imei` = '868922055683920' [ RunTime:0.000520s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011274s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678264561 , 0.015381 , 1.251489 , 0.015532 , 0.015562 , 13.32 , 21.361622 , 48.862976 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678264709) [ RunTime:0.000507s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:16+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008741s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001007s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:19+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010421s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011030s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000631s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003010s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:22+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010266s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012225s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000664s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003256s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:26+08:00 ] 39.144.14.248 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009615s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000722s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:27+08:00 ] 39.144.14.248 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678264826&v1=0.015441&v2=1.160011&v3=0.015502&v4=0.015562&v5=13.140000&t=21.672649&h=49.702209&rssi=30&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000765s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1678264826,`v1`=0.015441,`v2`=1.160011,`v3`=0.015502,`v4`=0.015562,`v5`=13.14,`t`=21.672649,`h`=49.702209,`rssi`=30,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678264827  WHERE  `imei` = '868922055683920' [ RunTime:0.000610s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010616s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678264826 , 0.015441 , 1.160011 , 0.015502 , 0.015562 , 13.14 , 21.672649 , 49.702209 , 30 , '89860426102071188500' , '460044618415250' , -0 , 1678264827) [ RunTime:0.000620s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:45+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001484s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000737s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011290s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000618s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003091s ]
---------------------------------------------------------------
[ 2023-03-08T16:40:46+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009959s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011124s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000584s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003047s ]
---------------------------------------------------------------
[ 2023-03-08T16:43:27+08:00 ] 39.88.23.149 GET /admin/show/index.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_show` [ RunTime:0.010613s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000452s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000767s ]
---------------------------------------------------------------
[ 2023-03-08T16:43:29+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010069s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000354s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000757s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000755s ]
---------------------------------------------------------------
[ 2023-03-08T16:43:31+08:00 ] 39.88.23.149 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002291s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012329s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000928s ]
---------------------------------------------------------------
[ 2023-03-08T16:44:10+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009983s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001093s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000804s ]
---------------------------------------------------------------
[ 2023-03-08T16:44:13+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009403s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000819s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000792s ]
---------------------------------------------------------------
[ 2023-03-08T16:44:16+08:00 ] 39.88.23.149 GET /admin/show/index.html?page=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010207s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000412s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000813s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000713s ]
---------------------------------------------------------------
[ 2023-03-08T16:45:12+08:00 ] 39.88.23.149 GET /admin/show/read/id/30/imei/868922055683920.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009581s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 30 LIMIT 1 [ RunTime:0.000629s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011545s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000587s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003152s ]
---------------------------------------------------------------
[ 2023-03-08T16:45:22+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001841s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009518s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000840s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000776s ]
---------------------------------------------------------------
[ 2023-03-08T16:45:25+08:00 ] 39.88.23.149 GET /admin/show/edit/id/30.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002277s ] 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  `id` = 30 LIMIT 1 [ RunTime:0.000672s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009797s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000482s ]
---------------------------------------------------------------
[ 2023-03-08T16:45:41+08:00 ] 39.88.23.149 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011701s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='',`interval`=2,`gps`='120.072436,36.059645',`username`='admin',`introduce`='<p>atsaml21e17b芯片改进版本，结合stm32程序逻辑。</p><p>2022.10.21安装到变电站，1号避雷针旁边</p><p>自然接蓝色</p><p>通电接红色</p><p><br/></p>',`update_time`=1678265141  WHERE  `id` = 30 [ RunTime:0.000743s ]
---------------------------------------------------------------
[ 2023-03-08T16:45:43+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001886s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012162s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000403s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000844s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000851s ]
---------------------------------------------------------------
[ 2023-03-08T16:45:46+08:00 ] 39.88.23.149 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001940s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010497s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000887s ]
---------------------------------------------------------------
[ 2023-03-08T16:55:54+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002335s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009594s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000796s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000752s ]
---------------------------------------------------------------
[ 2023-03-08T17:52:47+08:00 ] 117.132.198.177 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012344s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000707s ]
---------------------------------------------------------------
[ 2023-03-08T17:52:48+08:00 ] 117.132.198.177 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678269167&v1=0.012552&v2=2.412334&v3=0.012973&v4=0.013274&v5=13.140000&t=17.715088&h=53.005737&rssi=18&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011103s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678269167,`v1`=0.012552,`v2`=2.412334,`v3`=0.012973,`v4`=0.013274,`v5`=13.14,`t`=17.715088,`h`=53.005737,`rssi`=18,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678269168  WHERE  `imei` = '868922055684548' [ RunTime:0.000563s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012445s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678269167 , 0.012552 , 2.412334 , 0.012973 , 0.013274 , 13.14 , 17.715088 , 53.005737 , 18 , '898604650119C1053137' , '460048590503137' , -0 , 1678269168) [ RunTime:0.000702s ]
---------------------------------------------------------------
[ 2023-03-08T17:53:28+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009696s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011175s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000542s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000812s ]
---------------------------------------------------------------
[ 2023-03-08T18:00:49+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ 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.012730s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009092s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000810s ]
---------------------------------------------------------------
[ 2023-03-08T18:01:20+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010018s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000347s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000735s ]
---------------------------------------------------------------
[ 2023-03-08T18:02:00+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009686s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000366s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000780s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000757s ]
---------------------------------------------------------------
[ 2023-03-08T18:02:03+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010403s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000378s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000760s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000742s ]
---------------------------------------------------------------
[ 2023-03-08T18:02:07+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002013s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009581s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000804s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000766s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000691s ]
---------------------------------------------------------------
[ 2023-03-08T18:02:09+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017999s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.001112s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014110s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000851s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001335s ]
---------------------------------------------------------------
[ 2023-03-08T18:02:13+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001879s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010727s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000644s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011545s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000576s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000745s ]
---------------------------------------------------------------
[ 2023-03-08T18:05:49+08:00 ] 39.144.3.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012248s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2023-03-08T18:05:50+08:00 ] 39.144.3.89 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678269949&v1=0.012732&v2=1.811936&v3=0.012943&v4=0.013334&v5=13.320000&t=18.026115&h=52.372498&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010605s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000647s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678269949,`v1`=0.012732,`v2`=1.811936,`v3`=0.012943,`v4`=0.013334,`v5`=13.32,`t`=18.026115,`h`=52.372498,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678269950  WHERE  `imei` = '868922055684548' [ RunTime:0.000530s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010620s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678269949 , 0.012732 , 1.811936 , 0.012943 , 0.013334 , 13.32 , 18.026115 , 52.372498 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678269950) [ RunTime:0.000556s ]
---------------------------------------------------------------
[ 2023-03-08T18:05:52+08:00 ] 39.144.3.89 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=4294938496&v1=0.012612&v2=1.361638&v3=0.012642&v4=0.013274&v5=13.320000&t=17.736538&h=53.204102&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010780s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000662s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=4294938496,`v1`=0.012612,`v2`=1.361638,`v3`=0.012642,`v4`=0.013274,`v5`=13.32,`t`=17.736538,`h`=53.204102,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678269952  WHERE  `imei` = '868922055684548' [ RunTime:0.000528s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009375s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 4294938496 , 0.012612 , 1.361638 , 0.012642 , 0.013274 , 13.32 , 17.736538 , 53.204102 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678269952) [ RunTime:0.000522s ]
---------------------------------------------------------------
[ 2023-03-08T18:05:55+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011881s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011298s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000843s ]
---------------------------------------------------------------
[ 2023-03-08T18:05:58+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002306s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010394s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000518s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000840s ]
---------------------------------------------------------------
[ 2023-03-08T18:08:43+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002317s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010567s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000717s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011611s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000594s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000879s ]
---------------------------------------------------------------
[ 2023-03-08T18:09:01+08:00 ] 39.88.23.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002316s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010062s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000773s ]
---------------------------------------------------------------
[ 2023-03-08T18:09:09+08:00 ] 39.88.23.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.001979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010996s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000737s ]
---------------------------------------------------------------
[ 2023-03-08T18:09:10+08:00 ] 39.88.23.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010990s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000707s ]
---------------------------------------------------------------
[ 2023-03-08T18:10:03+08:00 ] 221.178.124.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002074s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010177s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000725s ]
---------------------------------------------------------------
[ 2023-03-08T18:10:05+08:00 ] 221.178.124.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678270203&v1=0.012732&v2=1.421094&v3=0.013064&v4=0.013395&v5=13.140000&t=18.959200&h=55.935425&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000851s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678270203,`v1`=0.012732,`v2`=1.421094,`v3`=0.013064,`v4`=0.013395,`v5`=13.14,`t`=18.9592,`h`=55.935425,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678270204  WHERE  `imei` = '868922055684548' [ RunTime:0.001081s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011478s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678270203 , 0.012732 , 1.421094 , 0.013064 , 0.013395 , 13.14 , 18.9592 , 55.935425 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678270205) [ RunTime:0.000566s ]
---------------------------------------------------------------
[ 2023-03-08T18:10:34+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000730s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009806s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000879s ]
---------------------------------------------------------------
[ 2023-03-08T18:12:43+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013131s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.001129s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021562s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000889s ]
---------------------------------------------------------------
[ 2023-03-08T18:12:47+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009825s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011768s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000815s ]
---------------------------------------------------------------
[ 2023-03-08T18:15:43+08:00 ] 39.144.12.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012433s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000702s ]
---------------------------------------------------------------
[ 2023-03-08T18:15:45+08:00 ] 39.144.12.227 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678270543&v1=0.012492&v2=1.299366&v3=0.012943&v4=0.013334&v5=13.320000&t=18.691072&h=49.938721&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678270543,`v1`=0.012492,`v2`=1.299366,`v3`=0.012943,`v4`=0.013334,`v5`=13.32,`t`=18.691072,`h`=49.938721,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678270545  WHERE  `imei` = '868922055684548' [ RunTime:0.000591s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011077s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678270543 , 0.012492 , 1.299366 , 0.012943 , 0.013334 , 13.32 , 18.691072 , 49.938721 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678270545) [ RunTime:0.000626s ]
---------------------------------------------------------------
[ 2023-03-08T18:16:10+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009016s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000658s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009818s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000522s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000818s ]
---------------------------------------------------------------
[ 2023-03-08T18:17:27+08:00 ] 39.144.6.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010409s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2023-03-08T18:17:29+08:00 ] 39.144.6.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678270647&v1=0.012732&v2=1.051426&v3=0.013154&v4=0.013395&v5=13.320000&t=19.302402&h=47.382874&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010310s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000719s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678270647,`v1`=0.012732,`v2`=1.051426,`v3`=0.013154,`v4`=0.013395,`v5`=13.32,`t`=19.302402,`h`=47.382874,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678270649  WHERE  `imei` = '868922055684548' [ RunTime:0.000498s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011992s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678270647 , 0.012732 , 1.051426 , 0.013154 , 0.013395 , 13.32 , 19.302402 , 47.382874 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678270649) [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2023-03-08T18:17:32+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009251s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011716s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001011s ]
---------------------------------------------------------------
[ 2023-03-08T18:19:24+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011823s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000658s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011277s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000534s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000837s ]
---------------------------------------------------------------
[ 2023-03-08T18:19:27+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.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_show` [ RunTime:0.010581s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000639s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009144s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000496s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000756s ]
---------------------------------------------------------------
[ 2023-03-08T18:19:28+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010657s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000642s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011060s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000497s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000751s ]
---------------------------------------------------------------
[ 2023-03-08T18:19:38+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.009760s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010267s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000674s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009874s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000510s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000851s ]
---------------------------------------------------------------
[ 2023-03-08T18:21:27+08:00 ] 39.144.6.188 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010269s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2023-03-08T18:21:28+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011117s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011084s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000584s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000990s ]
---------------------------------------------------------------
[ 2023-03-08T18:21:29+08:00 ] 39.144.6.188 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678270887&v1=0.012853&v2=1.032025&v3=0.013154&v4=0.013515&v5=13.140000&t=19.559805&h=46.230835&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012162s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000751s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678270887,`v1`=0.012853,`v2`=1.032025,`v3`=0.013154,`v4`=0.013515,`v5`=13.14,`t`=19.559805,`h`=46.230835,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678270889  WHERE  `imei` = '868922055684548' [ RunTime:0.000524s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009457s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678270887 , 0.012853 , 1.032025 , 0.013154 , 0.013515 , 13.14 , 19.559805 , 46.230835 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678270889) [ RunTime:0.000547s ]
---------------------------------------------------------------
[ 2023-03-08T18:21:30+08:00 ] 39.144.6.188 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678270741&v1=0.012853&v2=1.038283&v3=0.013094&v4=0.013455&v5=13.320000&t=19.613430&h=48.054260&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.011670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012123s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000780s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1678270741,`v1`=0.012853,`v2`=1.038283,`v3`=0.013094,`v4`=0.013455,`v5`=13.32,`t`=19.61343,`h`=48.05426,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678270890  WHERE  `imei` = '868922055684548' [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011038s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678270741 , 0.012853 , 1.038283 , 0.013094 , 0.013455 , 13.32 , 19.61343 , 48.05426 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678270890) [ RunTime:0.000990s ]
---------------------------------------------------------------
[ 2023-03-08T18:21:32+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002302s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011310s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010774s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000544s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000871s ]
---------------------------------------------------------------
[ 2023-03-08T18:21:33+08:00 ] 39.88.23.149 GET /admin/show/read/id/39/imei/868922055684548.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001683s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010198s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 39 LIMIT 1 [ RunTime:0.000670s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013906s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000953s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001507s ]
---------------------------------------------------------------
[ 2023-03-08T18:24:21+08:00 ] 39.88.23.149 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011025s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000777s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000781s ]
---------------------------------------------------------------
[ 2023-03-08T18:24:24+08:00 ] 39.88.23.149 GET /admin/show/read/id/40/imei/868922055683771.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010547s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 40 LIMIT 1 [ RunTime:0.000719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010385s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000697s ]
---------------------------------------------------------------
[ 2023-03-08T18:24:37+08:00 ] 117.132.197.147 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.002145s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009931s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000650s ]
---------------------------------------------------------------
[ 2023-03-08T18:24:38+08:00 ] 117.132.197.147 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678271077&v1=0.014538&v2=2.375826&v3=0.014719&v4=0.015261&v5=13.320000&t=17.328985&h=54.127258&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.008921s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010829s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000689s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1678271077,`v1`=0.014538,`v2`=2.375826,`v3`=0.014719,`v4`=0.015261,`v5`=13.32,`t`=17.328985,`h`=54.127258,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678271078  WHERE  `imei` = '868922055683771' [ RunTime:0.000522s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011081s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678271077 , 0.014538 , 2.375826 , 0.014719 , 0.015261 , 13.32 , 17.328985 , 54.127258 , 17 , '898604650119C1053136' , '460048590503136' , -0 , 1678271078) [ RunTime:0.000525s ]
---------------------------------------------------------------
[ 2023-03-08T18:24:44+08:00 ] 39.88.23.149 GET /admin/show/read/id/40/imei/868922055683771.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010449s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 40 LIMIT 1 [ RunTime:0.000662s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010527s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000535s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2023-03-08T18:26:53+08:00 ] 39.88.23.149 GET /admin/show/read/id/40/imei/868922055683771.html
[ 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.023269s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 40 LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010104s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000477s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000712s ]
---------------------------------------------------------------
[ 2023-03-08T18:28:28+08:00 ] 111.55.137.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ 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.012113s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2023-03-08T18:28:29+08:00 ] 111.55.137.2 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678271308&v1=0.014960&v2=1.173466&v3=0.015080&v4=0.015381&v5=13.320000&t=18.315693&h=49.252075&rssi=15&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011392s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1678271308,`v1`=0.01496,`v2`=1.173466,`v3`=0.01508,`v4`=0.015381,`v5`=13.32,`t`=18.315693,`h`=49.252075,`rssi`=15,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678271309  WHERE  `imei` = '868922055683771' [ RunTime:0.000520s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010310s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678271308 , 0.01496 , 1.173466 , 0.01508 , 0.015381 , 13.32 , 18.315693 , 49.252075 , 15 , '898604650119C1053136' , '460048590503136' , -0 , 1678271309) [ RunTime:0.000501s ]
---------------------------------------------------------------
[ 2023-03-08T18:28:31+08:00 ] 111.55.137.2 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678271161&v1=0.015020&v2=1.147494&v3=0.015080&v4=0.015502&v5=13.500000&t=18.251343&h=49.557251&rssi=15&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009830s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1678271161,`v1`=0.01502,`v2`=1.147494,`v3`=0.01508,`v4`=0.015502,`v5`=13.5,`t`=18.251343,`h`=49.557251,`rssi`=15,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678271311  WHERE  `imei` = '868922055683771' [ RunTime:0.000780s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010700s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678271161 , 0.01502 , 1.147494 , 0.01508 , 0.015502 , 13.5 , 18.251343 , 49.557251 , 15 , '898604650119C1053136' , '460048590503136' , -0 , 1678271311) [ RunTime:0.000602s ]
---------------------------------------------------------------
[ 2023-03-08T18:28:54+08:00 ] 39.88.23.149 GET /admin/show/read/id/40/imei/868922055683771.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009112s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 40 LIMIT 1 [ RunTime:0.000918s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009902s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000714s ]
---------------------------------------------------------------
[ 2023-03-08T21:49:51+08:00 ] 39.88.175.12 GET /admin/show/read/id/37/imei/868922055683912.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002102s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010136s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 37 LIMIT 1 [ RunTime:0.000944s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012017s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000580s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000810s ]