---------------------------------------------------------------
[ 2023-03-18T02:03:54+08:00 ] 39.144.6.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002422s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013491s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000758s ]
---------------------------------------------------------------
[ 2023-03-18T02:03:55+08:00 ] 117.132.195.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ 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.010732s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000703s ]
---------------------------------------------------------------
[ 2023-03-18T02:04:03+08:00 ] 39.144.6.10 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230318&time=020301&v1=-01.290&v2=+00.022&v3=-00.951&v4=-00.023&v5=05.7&t=+01.8&h=62.2&rssi=+230&ccid=4600485905031420000099m9990000000332000001g3020,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009416s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000640s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230318',`time`='020301',`v1`=-1.29,`v2`=0.022,`v3`=-0.951,`v4`=-0.023,`v5`=5.7,`t`=1.8,`h`=62.2,`rssi`=230,`ccid`='4600485905031420000099m9990000000332000001g3020,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679076243  WHERE  `imei` = '868922055643643' [ RunTime:0.000577s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009426s ]
[ 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' , '230318' , '020301' , -1.29 , 0.022 , -0.951 , -0.023 , 5.7 , 1.8 , 62.2 , 230 , '4600485905031420000099m9990000000332000001g3020,N,00E000=-00.000' , 0 , 0 , 1679076243 , 1679076243) [ RunTime:0.003549s ]
---------------------------------------------------------------
[ 2023-03-18T02:04:04+08:00 ] 117.132.195.58 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230318&time=020301&v1=-00.240&v2=+00.001&v3=-00.064&v4=-00.017&v5=05.7&t=+02.6&h=64.9&rssi=+225&ccid=4600485905031430000099m9990000000003000000g2750,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001530s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000656s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230318',`time`='020301',`v1`=-0.24,`v2`=0.001,`v3`=-0.064,`v4`=-0.017,`v5`=5.7,`t`=2.6,`h`=64.9,`rssi`=225,`ccid`='4600485905031430000099m9990000000003000000g2750,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679076244  WHERE  `imei` = '868922055644013' [ RunTime:0.000525s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010014s ]
[ 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' , '230318' , '020301' , -0.24 , 0.001 , -0.064 , -0.017 , 5.7 , 2.6 , 64.9 , 225 , '4600485905031430000099m9990000000003000000g2750,N,00E000=-00.000' , 0 , 0 , 1679076244 , 1679076244) [ RunTime:0.001094s ]
---------------------------------------------------------------
[ 2023-03-18T02:32:25+08:00 ] 117.132.195.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002529s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000694s ]
---------------------------------------------------------------
[ 2023-03-18T02:32:26+08:00 ] 117.132.195.192 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679077945&v1=0.028023&v2=0.979245&v3=0.028505&v4=0.027963&v5=12.420000&t=10.926101&h=40.470642&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011009s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976109',`create_time`=1679077945,`v1`=0.028023,`v2`=0.979245,`v3`=0.028505,`v4`=0.027963,`v5`=12.42,`t`=10.926101,`h`=40.470642,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679077946  WHERE  `imei` = '868922056976109' [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011982s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679077945 , 0.028023 , 0.979245 , 0.028505 , 0.027963 , 12.42 , 10.926101 , 40.470642 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679077946) [ RunTime:0.000685s ]
---------------------------------------------------------------
[ 2023-03-18T06:04:51+08:00 ] 39.144.16.211 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ 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.012496s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000708s ]
---------------------------------------------------------------
[ 2023-03-18T06:04:59+08:00 ] 39.144.16.211 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230318&time=060401&v1=-01.240&v2=+00.016&v3=-01.039&v4=-00.600&v5=05.7&t=+01.8&h=80.7&rssi=+226&imsi=460044618415249&v6=-00.000&a1=00.232&a2=01.270&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001936s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010119s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230318',`time`='060401',`v1`=-1.24,`v2`=0.016,`v3`=-1.039,`v4`=-0.6,`v5`=5.7,`t`=1.8,`h`=80.7,`rssi`=226,`imsi`='460044618415249',`v6`=-0,`a1`=0.232,`a2`=1.27,`update_time`=1679090699  WHERE  `imei` = '868922055684076' [ RunTime:0.000679s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010890s ]
[ 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' , '230318' , '060401' , -1.24 , 0.016 , -1.039 , -0.6 , 5.7 , 1.8 , 80.7 , 226 , '460044618415249' , -0 , 0.232 , 1.27 , 1679090699 , 1679090699) [ RunTime:0.001019s ]
---------------------------------------------------------------
[ 2023-03-18T14:03:55+08:00 ] 117.132.195.147 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011933s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2023-03-18T14:03:55+08:00 ] 39.144.6.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009657s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000653s ]
---------------------------------------------------------------
[ 2023-03-18T14:04:04+08:00 ] 39.144.6.1 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230318&time=140301&v1=-01.290&v2=+00.051&v3=-00.928&v4=-00.023&v5=05.9&t=+14.1&h=60.2&rssi=+230&ccid=4600485905031420000099m9990000000354000001g3000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002052s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009544s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000686s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230318',`time`='140301',`v1`=-1.29,`v2`=0.051,`v3`=-0.928,`v4`=-0.023,`v5`=5.9,`t`=14.1,`h`=60.2,`rssi`=230,`ccid`='4600485905031420000099m9990000000354000001g3000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679119444  WHERE  `imei` = '868922055643643' [ RunTime:0.000861s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010550s ]
[ 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' , '230318' , '140301' , -1.29 , 0.051 , -0.928 , -0.023 , 5.9 , 14.1 , 60.2 , 230 , '4600485905031420000099m9990000000354000001g3000,N,00E000=-00.000' , 0 , 0 , 1679119444 , 1679119444) [ RunTime:0.000610s ]
---------------------------------------------------------------
[ 2023-03-18T14:04:04+08:00 ] 117.132.195.147 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230318&time=140301&v1=-00.231&v2=+00.002&v3=+00.020&v4=-00.017&v5=05.9&t=+15.6&h=63.1&rssi=+225&ccid=4600485905031430000099m9990000000038000000g2680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011943s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001140s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230318',`time`='140301',`v1`=-0.231,`v2`=0.002,`v3`=0.02,`v4`=-0.017,`v5`=5.9,`t`=15.6,`h`=63.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000038000000g2680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679119444  WHERE  `imei` = '868922055644013' [ RunTime:0.000687s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012881s ]
[ 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' , '230318' , '140301' , -0.231 , 0.002 , 0.02 , -0.017 , 5.9 , 15.6 , 63.1 , 225 , '4600485905031430000099m9990000000038000000g2680,N,00E000=-00.000' , 0 , 0 , 1679119444 , 1679119444) [ RunTime:0.001237s ]
---------------------------------------------------------------
[ 2023-03-18T14:21:25+08:00 ] 39.88.23.252 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002765s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014984s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000688s ]
---------------------------------------------------------------
[ 2023-03-18T14:21:29+08:00 ] 39.88.23.252 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013586s ]
[ 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.000788s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001539s ]
---------------------------------------------------------------
[ 2023-03-18T14:21:37+08:00 ] 39.88.23.252 GET /admin/show/index.html?keyword=5391
[ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008955s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%5391%' LIMIT 1 [ RunTime:0.000471s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%5391%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000605s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000897s ]
---------------------------------------------------------------
[ 2023-03-18T14:32:25+08:00 ] 39.144.16.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009398s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000659s ]
---------------------------------------------------------------
[ 2023-03-18T14:32:26+08:00 ] 39.144.16.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679121145&v1=0.028144&v2=0.668198&v3=0.028896&v4=0.028144&v5=12.420000&t=16.535328&h=40.333313&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011539s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000789s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976109',`create_time`=1679121145,`v1`=0.028144,`v2`=0.668198,`v3`=0.028896,`v4`=0.028144,`v5`=12.42,`t`=16.535328,`h`=40.333313,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679121146  WHERE  `imei` = '868922056976109' [ RunTime:0.000748s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013155s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679121145 , 0.028144 , 0.668198 , 0.028896 , 0.028144 , 12.42 , 16.535328 , 40.333313 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679121146) [ RunTime:0.000608s ]
---------------------------------------------------------------
[ 2023-03-18T14:36:57+08:00 ] 39.88.23.252 GET /admin/show/index.html?keyword=5391
[ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009520s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%5391%' LIMIT 1 [ RunTime:0.000547s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%5391%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000717s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001043s ]
---------------------------------------------------------------
[ 2023-03-18T14:37:01+08:00 ] 39.88.23.252 GET /admin/show/index.html?keyword=5391
[ sql ] [ DB ] CONNECT:[ UseTime:0.001579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010992s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `imei` LIKE '%5391%' LIMIT 1 [ RunTime:0.000523s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` LIKE '%5391%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000720s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000971s ]
---------------------------------------------------------------
[ 2023-03-18T14:37:04+08:00 ] 39.88.23.252 GET /admin/show/index.html?keyword=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002169s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009847s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000438s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000833s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000817s ]
---------------------------------------------------------------
[ 2023-03-18T14:44:57+08:00 ] 112.224.71.60 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=0.000000&v2=0.
[ 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.011733s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000890s ]
[ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 0 , 0 , 1679121897) [ RunTime:0.000679s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010704s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 0 , 0 , 1679121897) [ RunTime:0.001317s ]
---------------------------------------------------------------
[ 2023-03-18T14:45:35+08:00 ] 27.210.89.117 GET /admin/show/index.html?keyword=
[ 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.009471s ]
[ 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.000738s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000754s ]
---------------------------------------------------------------
[ 2023-03-18T15:11:47+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002128s ] 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` = 48 LIMIT 1 [ RunTime:0.000696s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013008s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000580s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000697s ]
---------------------------------------------------------------
[ 2023-03-18T15:35:45+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002855s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010609s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000419s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000809s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000871s ]
---------------------------------------------------------------
[ 2023-03-18T15:42:57+08:00 ] 112.224.67.183 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=0.000000&v2=0.
[ 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.012446s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=0,`v2`=0,`update_time`=1679125377  WHERE  `imei` = '123' [ RunTime:0.000560s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011835s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 0 , 0 , 1679125377) [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2023-03-18T15:43:02+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011762s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009366s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000459s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000929s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000915s ]
---------------------------------------------------------------
[ 2023-03-18T15:43:05+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002502s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010895s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000773s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011468s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000534s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2023-03-18T15:46:44+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=0.000000&v2=0.
[ sql ] [ DB ] CONNECT:[ UseTime:0.010645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012307s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=0,`v2`=0,`update_time`=1679125604  WHERE  `imei` = '123' [ RunTime:0.000948s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012488s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 0 , 0 , 1679125604) [ RunTime:0.000541s ]
---------------------------------------------------------------
[ 2023-03-18T15:46:49+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002175s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012288s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000779s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013053s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000529s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000694s ]
---------------------------------------------------------------
[ 2023-03-18T15:46:54+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009584s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000368s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000791s ]
---------------------------------------------------------------
[ 2023-03-18T15:51:06+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=3601.006836&v2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010076s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000658s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=3601.006836,`v2`=0,`update_time`=1679125866  WHERE  `imei` = '123' [ RunTime:0.000531s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010601s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 3601.006836 , 0 , 1679125866) [ RunTime:0.000468s ]
---------------------------------------------------------------
[ 2023-03-18T15:51:11+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ 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.009574s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000414s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000819s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000958s ]
---------------------------------------------------------------
[ 2023-03-18T15:51:22+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012380s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.001183s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012355s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2023-03-18T15:52:26+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=3601.006836&v2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001957s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000724s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=3601.006836,`v2`=0,`update_time`=1679125946  WHERE  `imei` = '123' [ RunTime:0.000560s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011784s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 3601.006836 , 0 , 1679125946) [ RunTime:0.000502s ]
---------------------------------------------------------------
[ 2023-03-18T15:52:33+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002487s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009237s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010772s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000550s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000837s ]
---------------------------------------------------------------
[ 2023-03-18T15:53:56+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=1.000000&v2=2.
[ sql ] [ DB ] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011736s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000644s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=1,`v2`=2,`update_time`=1679126036  WHERE  `imei` = '123' [ RunTime:0.000482s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010420s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 1 , 2 , 1679126036) [ RunTime:0.000466s ]
---------------------------------------------------------------
[ 2023-03-18T15:54:00+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010191s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009930s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000492s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000724s ]
---------------------------------------------------------------
[ 2023-03-18T15:55:00+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=11111111.00000
[ sql ] [ DB ] CONNECT:[ UseTime:0.001974s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010059s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000781s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=11111111,`update_time`=1679126100  WHERE  `imei` = '123' [ RunTime:0.000537s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011789s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `update_time`) VALUES ('123' , 0 , 11111111 , 1679126100) [ RunTime:0.000506s ]
---------------------------------------------------------------
[ 2023-03-18T15:55:03+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002028s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011688s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010238s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000488s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000771s ]
---------------------------------------------------------------
[ 2023-03-18T15:58:21+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=0&v1=11.000000&v2=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.002752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010226s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=0,`v1`=11,`v2`=1,`update_time`=1679126301  WHERE  `imei` = '123' [ RunTime:0.000495s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010437s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('123' , 0 , 11 , 1 , 1679126301) [ RunTime:0.000494s ]
---------------------------------------------------------------
[ 2023-03-18T15:58:25+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.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.009282s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000711s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011776s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000806s ]
---------------------------------------------------------------
[ 2023-03-18T16:02:06+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010021s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000797s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000755s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000829s ]
---------------------------------------------------------------
[ 2023-03-18T16:02:18+08:00 ] 27.210.89.117 GET /admin/show/read/id/47/imei/868922055684209.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.011290s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 47 LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010236s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000485s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001376s ]
---------------------------------------------------------------
[ 2023-03-18T16:03:12+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680000
[ 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.010699s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680000' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055680000' , 1679126592 , 1679126592) [ RunTime:0.000451s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010367s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES ('868922055680000' , 1679126592 , 1679126592) [ RunTime:0.000471s ]
---------------------------------------------------------------
[ 2023-03-18T16:03:16+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009644s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000783s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000854s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000963s ]
---------------------------------------------------------------
[ 2023-03-18T16:03:55+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680000&create_time=0&v1=11
[ sql ] [ DB ] CONNECT:[ UseTime:0.002215s ] 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  `imei` = '868922055680000' LIMIT 1 [ RunTime:0.000701s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055680000',`create_time`=0,`v1`=11,`update_time`=1679126634  WHERE  `imei` = '868922055680000' [ RunTime:0.000473s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009941s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `update_time`) VALUES ('868922055680000' , 0 , 11 , 1679126635) [ RunTime:0.000477s ]
---------------------------------------------------------------
[ 2023-03-18T16:03:58+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010121s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000367s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000706s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000846s ]
---------------------------------------------------------------
[ 2023-03-18T16:04:03+08:00 ] 27.210.89.117 GET /admin/show/read/id/49/imei/868922055680000.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.010203s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 49 LIMIT 1 [ RunTime:0.000723s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009335s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055680000' LIMIT 1 [ RunTime:0.000508s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055680000' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000731s ]
---------------------------------------------------------------
[ 2023-03-18T16:04:36+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=86892205568&create_time=0&v1=11.000
[ sql ] [ DB ] CONNECT:[ UseTime:0.002224s ] 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` = '86892205568' LIMIT 1 [ RunTime:0.000588s ]
[ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `v1` , `update_time`) VALUES ('86892205568' , 0 , 11 , 1679126676) [ RunTime:0.000432s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009521s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `update_time`) VALUES ('86892205568' , 0 , 11 , 1679126676) [ RunTime:0.000448s ]
---------------------------------------------------------------
[ 2023-03-18T16:04:40+08:00 ] 27.210.89.117 GET /admin/show/read/id/49/imei/868922055680000.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010641s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 49 LIMIT 1 [ RunTime:0.000886s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009026s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055680000' LIMIT 1 [ RunTime:0.000503s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055680000' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000707s ]
---------------------------------------------------------------
[ 2023-03-18T16:04:41+08:00 ] 27.210.89.117 GET /admin/show/read/id/49/imei/868922055680000.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001871s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013806s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 49 LIMIT 1 [ RunTime:0.000773s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011116s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055680000' LIMIT 1 [ RunTime:0.000552s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055680000' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2023-03-18T16:04:42+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002419s ] 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 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.000817s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001225s ]
---------------------------------------------------------------
[ 2023-03-18T16:04:48+08:00 ] 27.210.89.117 GET /admin/show/index.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.009441s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000451s ]
[ 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.000913s ]
---------------------------------------------------------------
[ 2023-03-18T16:05:32+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055&create_time=0&v1=11.00000
[ sql ] [ DB ] CONNECT:[ UseTime:0.002011s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011205s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055' LIMIT 1 [ RunTime:0.000597s ]
[ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `v1` , `update_time`) VALUES ('868922055' , 0 , 11 , 1679126732) [ RunTime:0.000420s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010347s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `update_time`) VALUES ('868922055' , 0 , 11 , 1679126732) [ RunTime:0.000491s ]
---------------------------------------------------------------
[ 2023-03-18T16:05:35+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009459s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000430s ]
[ 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.000850s ]
---------------------------------------------------------------
[ 2023-03-18T16:06:09+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=11.000000&v2=
[ 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.011344s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000597s ]
[ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('8689' , 0 , 11 , 0 , 1679126769) [ RunTime:0.000504s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010113s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('8689' , 0 , 11 , 0 , 1679126769) [ RunTime:0.000529s ]
---------------------------------------------------------------
[ 2023-03-18T16:06:12+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011131s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000436s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000754s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000931s ]
---------------------------------------------------------------
[ 2023-03-18T16:06:57+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002258s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000521s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001298s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000849s ]
---------------------------------------------------------------
[ 2023-03-18T16:08:41+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=11.000000&v2=1.100000&v
[ sql ] [ DB ] CONNECT:[ UseTime:0.001900s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011155s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000898s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='8689',`create_time`=0,`v1`=11,`v2`=1.1,`update_time`=1679126921  WHERE  `imei` = '8689' [ RunTime:0.001056s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010629s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `update_time`) VALUES ('8689' , 0 , 11 , 1.1 , 1679126921) [ RunTime:0.000516s ]
---------------------------------------------------------------
[ 2023-03-18T16:08:45+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009985s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000434s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000827s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001240s ]
---------------------------------------------------------------
[ 2023-03-18T16:11:17+08:00 ] 27.210.89.117 GET /admin/show/read/id/52/imei/8689.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010201s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000724s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011493s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000589s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '8689' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000836s ]
---------------------------------------------------------------
[ 2023-03-18T16:12:21+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=0.000000&v2=0.000000&v3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001888s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011428s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='8689',`create_time`=0,`v1`=0,`v2`=0,`v3`=0,`update_time`=1679127141  WHERE  `imei` = '8689' [ RunTime:0.000860s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012108s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `update_time`) VALUES ('8689' , 0 , 0 , 0 , 0 , 1679127141) [ RunTime:0.000630s ]
---------------------------------------------------------------
[ 2023-03-18T16:12:25+08:00 ] 27.210.89.117 GET /admin/show/read/id/52/imei/8689.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010518s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010282s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000514s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '8689' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000804s ]
---------------------------------------------------------------
[ 2023-03-18T16:13:36+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=0.000000&v2=0.000000&v3
[ 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.011614s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='8689',`create_time`=0,`v1`=0,`v2`=0,`v3`=0,`update_time`=1679127216  WHERE  `imei` = '8689' [ RunTime:0.000508s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011512s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `update_time`) VALUES ('8689' , 0 , 0 , 0 , 0 , 1679127216) [ RunTime:0.000513s ]
---------------------------------------------------------------
[ 2023-03-18T16:13:46+08:00 ] 27.210.89.117 GET /admin/show/read/id/52/imei/8689.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.010384s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000662s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010636s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000508s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '8689' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000787s ]
---------------------------------------------------------------
[ 2023-03-18T16:15:24+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=0.000000&v2=0.000000&v3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] 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  `imei` = '8689' LIMIT 1 [ RunTime:0.000638s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='8689',`create_time`=0,`v1`=0,`v2`=0,`v3`=0,`update_time`=1679127324  WHERE  `imei` = '8689' [ RunTime:0.000478s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010366s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `update_time`) VALUES ('8689' , 0 , 0 , 0 , 0 , 1679127324) [ RunTime:0.000489s ]
---------------------------------------------------------------
[ 2023-03-18T16:15:28+08:00 ] 27.210.89.117 GET /admin/show/read/id/52/imei/8689.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010960s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000749s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010318s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000507s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '8689' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000768s ]
---------------------------------------------------------------
[ 2023-03-18T16:16:09+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=0.000000&v2=0.000000&v3=0.000000&v4=0.000000&v5=0.000000&t=0.000000&h=0.000000&rssi=0&ccid=&imsi=&v6=-00.
[ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011097s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000627s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='8689',`create_time`=0,`v1`=0,`v2`=0,`v3`=0,`v4`=0,`v5`=0,`t`=0,`h`=0,`rssi`=0,`ccid`='',`imsi`='',`v6`=-0,`update_time`=1679127369  WHERE  `imei` = '8689' [ RunTime:0.000505s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011231s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('8689' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , '' , '' , -0 , 1679127369) [ RunTime:0.000537s ]
---------------------------------------------------------------
[ 2023-03-18T16:16:13+08:00 ] 27.210.89.117 GET /admin/show/read/id/52/imei/8689.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011279s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000771s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010976s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000511s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '8689' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001328s ]
---------------------------------------------------------------
[ 2023-03-18T16:23:48+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=8689&create_time=0&v1=0.000000&v2=0.000000&v3=0.000000&v4=0.000000&v5=0.000000&t=0.000000&h=0.000000&rssi=0&ccid=&imsi=&v6=-00.
[ sql ] [ DB ] CONNECT:[ UseTime:0.002396s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010364s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000702s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='8689',`create_time`=0,`v1`=0,`v2`=0,`v3`=0,`v4`=0,`v5`=0,`t`=0,`h`=0,`rssi`=0,`ccid`='',`imsi`='',`v6`=-0,`update_time`=1679127828  WHERE  `imei` = '8689' [ RunTime:0.000518s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011386s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('8689' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , '' , '' , -0 , 1679127828) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-03-18T16:23:51+08:00 ] 27.210.89.117 GET /admin/show/read/id/52/imei/8689.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009979s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.001020s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010162s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '8689' LIMIT 1 [ RunTime:0.000550s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '8689' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000832s ]
---------------------------------------------------------------
[ 2023-03-18T16:26:34+08:00 ] 27.210.89.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&create_time=1420041686&v1=0.007495&v2=9.652361&v3=0.007555&v4=0.007615&v5=13.140000&t=22.423292&h=34.641815&rssi=29&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000$gps=0&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010938s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000688s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`create_time`=1420041686,`v1`=0.007495,`v2`=9.652361,`v3`=0.007555,`v4`=0.007615,`v5`=13.14,`t`=22.423292,`h`=34.641815,`rssi`=29,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679127994  WHERE  `imei` = '123' [ RunTime:0.000651s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012143s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('123' , 1420041686 , 0.007495 , 9.652361 , 0.007555 , 0.007615 , 13.14 , 22.423292 , 34.641815 , 29 , '89860426102071188504' , '460044618415254' , -0 , 1679127994) [ RunTime:0.000547s ]
---------------------------------------------------------------
[ 2023-03-18T16:26:42+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010328s ]
[ 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.000743s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000908s ]
---------------------------------------------------------------
[ 2023-03-18T16:26:44+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010059s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000705s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009823s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000455s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000670s ]
---------------------------------------------------------------
[ 2023-03-18T16:28:59+08:00 ] 27.210.89.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123$gps=0&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002003s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010677s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123$gps=0' LIMIT 1 [ RunTime:0.000638s ]
[ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('123$gps=0' , 1679128139 , 1679128139) [ RunTime:0.000453s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011528s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES ('123$gps=0' , 1679128139 , 1679128139) [ RunTime:0.000454s ]
---------------------------------------------------------------
[ 2023-03-18T16:29:09+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011400s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000886s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001033s ]
---------------------------------------------------------------
[ 2023-03-18T16:30:00+08:00 ] 27.210.89.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=0&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002328s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010582s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000875s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='0',`update_time`=1679128200  WHERE  `imei` = '123' [ RunTime:0.000698s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012568s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '0' , 1679128200 , 1679128200) [ RunTime:0.000491s ]
---------------------------------------------------------------
[ 2023-03-18T16:30:03+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002095s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010825s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000751s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011646s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000500s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000719s ]
---------------------------------------------------------------
[ 2023-03-18T16:30:21+08:00 ] 27.210.89.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=123,234&end=$
[ 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.010013s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='123,234',`update_time`=1679128221  WHERE  `imei` = '123' [ RunTime:0.000521s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011251s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '123,234' , 1679128221 , 1679128221) [ RunTime:0.000428s ]
---------------------------------------------------------------
[ 2023-03-18T16:30:24+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011261s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000734s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010201s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000490s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000807s ]
---------------------------------------------------------------
[ 2023-03-18T16:35:12+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=12.000000,
[ sql ] [ DB ] CONNECT:[ UseTime:0.001703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011377s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='12.000000,',`update_time`=1679128512  WHERE  `imei` = '123' [ RunTime:0.000512s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010821s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '12.000000,' , 1679128512 , 1679128512) [ RunTime:0.000454s ]
---------------------------------------------------------------
[ 2023-03-18T16:35:17+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012197s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000656s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020416s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000518s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000838s ]
---------------------------------------------------------------
[ 2023-03-18T16:36:44+08:00 ] 27.210.89.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=123,234&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001924s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010243s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='123,234',`update_time`=1679128604  WHERE  `imei` = '123' [ RunTime:0.000578s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011217s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '123,234' , 1679128604 , 1679128604) [ RunTime:0.000819s ]
---------------------------------------------------------------
[ 2023-03-18T16:36:48+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001917s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009333s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000660s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010937s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000447s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000765s ]
---------------------------------------------------------------
[ 2023-03-18T16:39:12+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=12,12&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002965s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000701s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='12,12',`update_time`=1679128752  WHERE  `imei` = '123' [ RunTime:0.000504s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010069s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '12,12' , 1679128752 , 1679128752) [ RunTime:0.000449s ]
---------------------------------------------------------------
[ 2023-03-18T16:39:18+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011304s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011152s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000477s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000743s ]
---------------------------------------------------------------
[ 2023-03-18T16:40:07+08:00 ] 112.224.67.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=12,21&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.010237s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010662s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='12,21',`update_time`=1679128807  WHERE  `imei` = '123' [ RunTime:0.000534s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011774s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '12,21' , 1679128807 , 1679128807) [ RunTime:0.000553s ]
---------------------------------------------------------------
[ 2023-03-18T16:40:11+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001457s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014847s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000729s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010831s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000777s ]
---------------------------------------------------------------
[ 2023-03-18T17:25:37+08:00 ] 112.224.75.205 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=3601.00693
[ sql ] [ DB ] CONNECT:[ UseTime:0.002713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012061s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000680s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='3601.00693',`update_time`=1679131537  WHERE  `imei` = '123' [ RunTime:0.000589s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011061s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '3601.00693' , 1679131537 , 1679131537) [ RunTime:0.000557s ]
---------------------------------------------------------------
[ 2023-03-18T17:25:43+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009521s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010749s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000841s ]
---------------------------------------------------------------
[ 2023-03-18T17:27:42+08:00 ] 112.224.75.119 GET /kaiwu/public/index.php?s=/index/index/update/&imei=123&gps=3601.006938,12009.762502&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010520s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000776s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='123',`gps`='3601.006938,12009.762502',`update_time`=1679131662  WHERE  `imei` = '123' [ RunTime:0.000682s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011741s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `gps` , `create_time` , `update_time`) VALUES ('123' , '3601.006938,12009.762502' , 1679131662 , 1679131662) [ RunTime:0.000480s ]
---------------------------------------------------------------
[ 2023-03-18T17:27:47+08:00 ] 27.210.89.117 GET /admin/show/read/id/48/imei/123.html
[ 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.009225s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000714s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010694s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '123' LIMIT 1 [ RunTime:0.000481s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '123' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000757s ]
---------------------------------------------------------------
[ 2023-03-18T18:19:15+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002103s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010946s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001031s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:03+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002806s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010060s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001098s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:08+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001061s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:11+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010304s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000350s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000751s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000934s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:12+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009324s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001124s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:14+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002184s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011321s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001045s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:41+08:00 ] 27.210.89.117 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012639s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'user'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001318s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:43+08:00 ] 27.210.89.117 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001632s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.021648s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.001138s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000594s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000613s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:56+08:00 ] 27.210.89.117 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001783s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008805s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'user1'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000599s ]
---------------------------------------------------------------
[ 2023-03-18T18:26:58+08:00 ] 27.210.89.117 GET /home/map/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.011218s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000808s ]
---------------------------------------------------------------
[ 2023-03-18T18:27:20+08:00 ] 27.210.89.117 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013102s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2023-03-18T18:27:24+08:00 ] 27.210.89.117 GET /admin/map/index.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.010452s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001104s ]
---------------------------------------------------------------
[ 2023-03-18T18:27:27+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009787s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000343s ]
[ 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.001113s ]
---------------------------------------------------------------
[ 2023-03-18T18:27:28+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001859s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010843s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001012s ]
---------------------------------------------------------------
[ 2023-03-18T18:30:53+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002047s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001028s ]
---------------------------------------------------------------
[ 2023-03-18T18:30:55+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012571s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000994s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:13+08:00 ] 27.210.89.117 GET /admin/show/index.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.009502s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000365s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000752s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000895s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:20+08:00 ] 27.210.89.117 GET /admin/show/delete/id/53.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009746s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 53 [ RunTime:0.000668s ]
[ sql ] [ SQL ] DELETE FROM `collect_show`    WHERE  `id` = 53 [ RunTime:0.000613s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:21+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009591s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000368s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000754s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000905s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:26+08:00 ] 27.210.89.117 GET /admin/show/index.html?page=2
[ 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.009978s ]
[ 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 10,10 [ RunTime:0.000932s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000879s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:31+08:00 ] 27.210.89.117 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010655s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001002s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001004s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:33+08:00 ] 27.210.89.117 GET /admin/show/read/id/22/imei/868922055677740.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.009744s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011799s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.004610s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.026998s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:38+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011157s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000348s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000730s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000919s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:39+08:00 ] 27.210.89.117 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009789s ]
[ sql ] [ SQL ] SELECT 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.000860s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001486s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:41+08:00 ] 27.210.89.117 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009928s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000443s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000898s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000928s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:44+08:00 ] 27.210.89.117 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001905s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009783s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000466s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:47+08:00 ] 27.210.89.117 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009805s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='STM32',`interval`=1440,`gps`='',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在变电站高压线旁</p>',`update_time`=1679135507  WHERE  `id` = 22 [ RunTime:0.000574s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:48+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ 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.010919s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000367s ]
[ 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.000827s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:50+08:00 ] 27.210.89.117 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001605s ] 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.000392s ]
[ 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.000872s ]
---------------------------------------------------------------
[ 2023-03-18T18:31:52+08:00 ] 27.210.89.117 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002269s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009756s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001019s ]
---------------------------------------------------------------
[ 2023-03-18T20:45:10+08:00 ] 39.88.175.12 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003031s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013064s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2023-03-18T20:45:17+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002829s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012631s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001128s ]
---------------------------------------------------------------
[ 2023-03-18T20:47:51+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002222s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012362s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000402s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000748s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000905s ]
---------------------------------------------------------------
[ 2023-03-18T20:47:53+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=2
[ 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.009199s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000391s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000847s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000833s ]
---------------------------------------------------------------
[ 2023-03-18T20:47:55+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009207s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000324s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000846s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001002s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:00+08:00 ] 39.88.175.12 GET /admin/show/read/id/26/imei/868922055684076.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010390s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 26 LIMIT 1 [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011349s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.005930s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010826s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:05+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] 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 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.000775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000905s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:07+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010329s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000372s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001001s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001000s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:09+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001617s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010000s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000389s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000917s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000831s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:13+08:00 ] 39.88.175.12 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010701s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000464s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:31+08:00 ] 39.88.175.12 POST /admin/show/update.html
[ 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.010342s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='STM32',`interval`=1440,`gps`='36.0100736,120.09762362',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在变电站高压线旁</p>',`update_time`=1679143711  WHERE  `id` = 22 [ RunTime:0.000714s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:32+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001960s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009856s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000387s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000925s ]
---------------------------------------------------------------
[ 2023-03-18T20:48:34+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001900s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010087s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001035s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:28+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ 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.008749s ]
[ 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.000727s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000870s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:30+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010206s ]
[ 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 10,10 [ RunTime:0.000952s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000923s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:32+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009357s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000363s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000927s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000869s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:34+08:00 ] 39.88.175.12 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001647s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009885s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000516s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:44+08:00 ] 39.88.175.12 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011414s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='STM32',`interval`=1440,`gps`='120.09762362,36.0100736',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在变电站高压线旁</p>',`update_time`=1679143784  WHERE  `id` = 22 [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:45+08:00 ] 39.88.175.12 GET /admin/show/index.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.011466s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000439s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000884s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000999s ]
---------------------------------------------------------------
[ 2023-03-18T20:49:47+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010011s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000389s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001064s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000997s ]
---------------------------------------------------------------
[ 2023-03-18T20:50:04+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002402s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000336s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000740s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000899s ]
---------------------------------------------------------------
[ 2023-03-18T20:50:06+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008665s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000956s ]
---------------------------------------------------------------
[ 2023-03-18T20:54:19+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011808s ]
[ 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.000858s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000962s ]
---------------------------------------------------------------
[ 2023-03-18T20:54:23+08:00 ] 39.88.175.12 GET /admin/show/edit/id/52.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001675s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009723s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011363s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000480s ]
---------------------------------------------------------------
[ 2023-03-18T20:54:50+08:00 ] 39.88.175.12 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001955s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016530s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='',`interval`=2,`gps`='120.09762373,36.01007356',`username`='admin',`introduce`='                        ',`update_time`=1679144090  WHERE  `id` = 52 [ RunTime:0.000739s ]
---------------------------------------------------------------
[ 2023-03-18T20:54:52+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009793s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000372s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000751s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000922s ]
---------------------------------------------------------------
[ 2023-03-18T20:54:52+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001792s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010951s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000401s ]
[ 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.000907s ]
---------------------------------------------------------------
[ 2023-03-18T20:54:53+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011133s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001157s ]
---------------------------------------------------------------
[ 2023-03-18T20:55:28+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010481s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000341s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001584s ]
---------------------------------------------------------------
[ 2023-03-18T20:55:30+08:00 ] 39.88.175.12 GET /admin/show/edit/id/52.html
[ 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.010943s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 52 LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010911s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000621s ]
---------------------------------------------------------------
[ 2023-03-18T20:55:47+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016132s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000429s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000968s ]
---------------------------------------------------------------
[ 2023-03-18T20:55:48+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002028s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010314s ]
[ 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 10,10 [ RunTime:0.000873s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000829s ]
---------------------------------------------------------------
[ 2023-03-18T20:55:52+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001675s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009700s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000329s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000906s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000884s ]
---------------------------------------------------------------
[ 2023-03-18T20:55:54+08:00 ] 39.88.175.12 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011186s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000644s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011024s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000468s ]
---------------------------------------------------------------
[ 2023-03-18T20:56:01+08:00 ] 39.88.175.12 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010128s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='STM32',`interval`=1440,`gps`='120.09762373,36.01007356',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在变电站高压线旁</p>',`update_time`=1679144161  WHERE  `id` = 22 [ RunTime:0.000615s ]
---------------------------------------------------------------
[ 2023-03-18T20:56:03+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010454s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000420s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000769s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000950s ]
---------------------------------------------------------------
[ 2023-03-18T20:56:05+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009354s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001005s ]
---------------------------------------------------------------
[ 2023-03-18T20:57:19+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010512s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000803s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000818s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000942s ]
---------------------------------------------------------------
[ 2023-03-18T20:57:55+08:00 ] 39.88.175.12 GET /admin/show/edit/id/48.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010411s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000829s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000533s ]
---------------------------------------------------------------
[ 2023-03-18T21:17:33+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011592s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000457s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000835s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000935s ]
---------------------------------------------------------------
[ 2023-03-18T21:17:38+08:00 ] 39.88.175.12 GET /admin/show/edit/id/48.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009710s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 48 LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011867s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000479s ]
---------------------------------------------------------------
[ 2023-03-18T21:19:40+08:00 ] 39.88.175.12 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009590s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='',`interval`=2,`gps`='36.016789333,120.0001627',`username`='admin',`introduce`='                        ',`update_time`=1679145580  WHERE  `id` = 48 [ RunTime:0.000970s ]
---------------------------------------------------------------
[ 2023-03-18T21:19:41+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009736s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000389s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000771s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000915s ]
---------------------------------------------------------------
[ 2023-03-18T21:19:42+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010143s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000374s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000866s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001247s ]
---------------------------------------------------------------
[ 2023-03-18T21:19:45+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009604s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001004s ]
---------------------------------------------------------------
[ 2023-03-18T21:19:56+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011328s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000475s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000875s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000982s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:00+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002205s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012409s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000595s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001088s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000913s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:03+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014880s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000411s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000956s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000869s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:05+08:00 ] 39.88.175.12 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011871s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012019s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000500s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:20+08:00 ] 39.88.175.12 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001949s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010636s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `device_name`='STM32',`interval`=1440,`gps`='120.0001627,36.016789333,',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在变电站高压线旁</p>',`update_time`=1679145620  WHERE  `id` = 22 [ RunTime:0.000617s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:22+08:00 ] 39.88.175.12 GET /admin/show/index.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.010160s ]
[ 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.000812s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001049s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:22+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002098s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011502s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000467s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001067s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001237s ]
---------------------------------------------------------------
[ 2023-03-18T21:20:24+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001888s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009829s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001076s ]
---------------------------------------------------------------
[ 2023-03-18T21:23:54+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ 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.012738s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000472s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000843s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001088s ]
---------------------------------------------------------------
[ 2023-03-18T21:24:00+08:00 ] 39.88.175.12 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001744s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010219s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000398s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000969s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000960s ]
---------------------------------------------------------------
[ 2023-03-18T21:24:02+08:00 ] 39.88.175.12 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009894s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000697s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011187s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000482s ]
---------------------------------------------------------------
[ 2023-03-18T21:49:10+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012353s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000472s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000932s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001035s ]
---------------------------------------------------------------
[ 2023-03-18T21:49:11+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001743s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009920s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000996s ]