stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679289235 WHERE `id` = 22 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-03-20T13:13:56+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011478s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000850s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000955s ] --------------------------------------------------------------- [ 2023-03-20T13:13:57+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010737s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001216s ] --------------------------------------------------------------- [ 2023-03-20T13:15:53+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010297s ] [ 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.000779s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001151s ] --------------------------------------------------------------- [ 2023-03-20T13:15:59+08:00 ] 123.234.204.185 GET /admin/show/index.html?keyword=868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001767s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011272s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055677740%' LIMIT 1 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055677740%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000669s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000927s ] --------------------------------------------------------------- [ 2023-03-20T13:16:01+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.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.010528s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011062s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000470s ] --------------------------------------------------------------- [ 2023-03-20T13:16:19+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010107s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.104093,36.016212',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679289379 WHERE `id` = 22 [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2023-03-20T13:16:20+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001841s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010851s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000408s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000939s ] --------------------------------------------------------------- [ 2023-03-20T13:16:22+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000998s ] --------------------------------------------------------------- [ 2023-03-20T13:17:58+08:00 ] 123.234.204.185 GET /admin/show/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.011394s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000807s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001159s ] --------------------------------------------------------------- [ 2023-03-20T13:18:06+08:00 ] 123.234.204.185 GET /admin/show/index.html?keyword=868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011272s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055677740%' LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055677740%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001186s ] --------------------------------------------------------------- [ 2023-03-20T13:18:08+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011864s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010413s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000469s ] --------------------------------------------------------------- [ 2023-03-20T13:18:23+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009955s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.097625,36.010069',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679289503 WHERE `id` = 22 [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-03-20T13:18:24+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001841s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012421s ] [ 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 0,10 [ RunTime:0.000834s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2023-03-20T13:18:26+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001057s ] --------------------------------------------------------------- [ 2023-03-20T13:45:14+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010343s ] [ 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.000778s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000946s ] --------------------------------------------------------------- [ 2023-03-20T13:45:15+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008777s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011677s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2023-03-20T14:03:55+08:00 ] 39.144.5.193 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002578s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012040s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-03-20T14:03:55+08:00 ] 111.55.139.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001969s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-03-20T14:04:03+08:00 ] 39.144.5.193 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230320&time=140301&v1=-01.287&v2=+00.058&v3=-00.918&v4=-00.023&v5=05.9&t=+17.5&h=60.3&rssi=+230&ccid=4600485905031420000099m9990000000362000001g2970,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011234s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000816s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230320',`time`='140301',`v1`=-1.287,`v2`=0.058,`v3`=-0.918,`v4`=-0.023,`v5`=5.9,`t`=17.5,`h`=60.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000362000001g2970,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679292243 WHERE `imei` = '868922055643643' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010702s ] [ 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' , '230320' , '140301' , -1.287 , 0.058 , -0.918 , -0.023 , 5.9 , 17.5 , 60.3 , 230 , '4600485905031420000099m9990000000362000001g2970,N,00E000=-00.000' , 0 , 0 , 1679292243 , 1679292243) [ RunTime:0.001364s ] --------------------------------------------------------------- [ 2023-03-20T14:04:04+08:00 ] 111.55.139.21 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230320&time=140301&v1=-00.211&v2=+00.002&v3=+00.020&v4=-00.018&v5=05.9&t=+17.0&h=64.2&rssi=+225&ccid=4600485905031430000099m9990000000038000000g2450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008648s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230320',`time`='140301',`v1`=-0.211,`v2`=0.002,`v3`=0.02,`v4`=-0.018,`v5`=5.9,`t`=17,`h`=64.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000038000000g2450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679292243 WHERE `imei` = '868922055644013' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009474s ] [ 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' , '230320' , '140301' , -0.211 , 0.002 , 0.02 , -0.018 , 5.9 , 17 , 64.2 , 225 , '4600485905031430000099m9990000000038000000g2450,N,00E000=-00.000' , 0 , 0 , 1679292244 , 1679292244) [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2023-03-20T14:08:23+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011398s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169113,36.023104',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679292503 WHERE `id` = 22 [ RunTime:0.000608s ] --------------------------------------------------------------- [ 2023-03-20T14:08:24+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010239s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000326s ] [ 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.000904s ] --------------------------------------------------------------- [ 2023-03-20T14:08:25+08:00 ] 123.234.204.185 GET /admin/map/index.html [ 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.009975s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001073s ] --------------------------------------------------------------- [ 2023-03-20T14:09:52+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012146s ] [ 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.000784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000890s ] --------------------------------------------------------------- [ 2023-03-20T14:09:55+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011146s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010357s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000470s ] --------------------------------------------------------------- [ 2023-03-20T14:09:58+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008419s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='36.023104,120.169113',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679292598 WHERE `id` = 22 [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-03-20T14:09:59+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002362s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010810s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001124s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001195s ] --------------------------------------------------------------- [ 2023-03-20T14:10:00+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009336s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001529s ] --------------------------------------------------------------- [ 2023-03-20T14:19:06+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003063s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009336s ] [ 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.000786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000915s ] --------------------------------------------------------------- [ 2023-03-20T14:19:07+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002015s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012841s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012066s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000513s ] --------------------------------------------------------------- [ 2023-03-20T14:19:20+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001870s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010970s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169113,36.023104',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679293160 WHERE `id` = 22 [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2023-03-20T14:19:21+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009498s ] [ 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.000780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000935s ] --------------------------------------------------------------- [ 2023-03-20T14:19:22+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009806s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000412s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000741s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000898s ] --------------------------------------------------------------- [ 2023-03-20T14:19:24+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002063s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009488s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001020s ] --------------------------------------------------------------- [ 2023-03-20T14:32:24+08:00 ] 117.132.193.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009925s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2023-03-20T14:32:25+08:00 ] 117.132.193.142 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679293944&v1=0.028144&v2=1.069367&v3=0.028926&v4=0.028084&v5=12.420000&t=17.972490&h=41.325134&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ 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.009337s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679293944,`v1`=0.028144,`v2`=1.069367,`v3`=0.028926,`v4`=0.028084,`v5`=12.42,`t`=17.97249,`h`=41.325134,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679293945 WHERE `imei` = '868922056976109' [ RunTime:0.000507s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011804s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679293944 , 0.028144 , 1.069367 , 0.028926 , 0.028084 , 12.42 , 17.97249 , 41.325134 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679293945) [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-03-20T15:24:15+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010350s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000847s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2023-03-20T15:24:17+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002081s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011869s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000572s ] --------------------------------------------------------------- [ 2023-03-20T15:24:35+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010515s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169115,36.023097',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679297075 WHERE `id` = 22 [ RunTime:0.000893s ] --------------------------------------------------------------- [ 2023-03-20T15:24:37+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001819s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011650s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000421s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000872s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000974s ] --------------------------------------------------------------- [ 2023-03-20T15:24:38+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.019772s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000345s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000787s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001014s ] --------------------------------------------------------------- [ 2023-03-20T15:24:40+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010379s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010199s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001043s ] --------------------------------------------------------------- [ 2023-03-20T16:42:31+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002120s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011245s ] [ 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.000796s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000927s ] --------------------------------------------------------------- [ 2023-03-20T16:42:32+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010235s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011381s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000463s ] --------------------------------------------------------------- [ 2023-03-20T16:42:51+08:00 ] 123.234.204.185 POST /admin/show/update.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.009955s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.1687923883,36.0230567760',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679301771 WHERE `id` = 22 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2023-03-20T16:42:52+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010626s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000370s ] [ 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.000908s ] --------------------------------------------------------------- [ 2023-03-20T16:42:54+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002237s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001127s ] --------------------------------------------------------------- [ 2023-03-20T16:43:46+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001944s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010016s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000377s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000956s ] --------------------------------------------------------------- [ 2023-03-20T16:43:50+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009397s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000373s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000907s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000873s ] --------------------------------------------------------------- [ 2023-03-20T16:43:52+08:00 ] 123.234.204.185 GET /admin/show/read/id/22/imei/868922055677740.html [ 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.010730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011432s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.005177s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.018678s ] --------------------------------------------------------------- [ 2023-03-20T16:43:57+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ 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.011411s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000384s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000921s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2023-03-20T16:44:00+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003406s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001075s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014822s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-03-20T16:44:24+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010398s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.168700,36.023000',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679301864 WHERE `id` = 22 [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-03-20T16:44:25+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002322s ] 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.000453s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001020s ] --------------------------------------------------------------- [ 2023-03-20T16:44:26+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011198s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000873s ] --------------------------------------------------------------- [ 2023-03-20T16:44:27+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010169s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001612s ] --------------------------------------------------------------- [ 2023-03-20T16:44:46+08:00 ] 123.234.204.185 GET /admin/show/index.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.011021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000901s ] --------------------------------------------------------------- [ 2023-03-20T16:44:47+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011146s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2023-03-20T16:44:48+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002283s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011027s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000913s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001018s ] --------------------------------------------------------------- [ 2023-03-20T16:44:51+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008773s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010235s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000447s ] --------------------------------------------------------------- [ 2023-03-20T16:45:17+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010498s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.168000,36.023000',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679301917 WHERE `id` = 22 [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-03-20T16:45:18+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010086s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000397s ] [ 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.000986s ] --------------------------------------------------------------- [ 2023-03-20T16:45:19+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010342s ] [ 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 0,10 [ RunTime:0.000966s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001079s ] --------------------------------------------------------------- [ 2023-03-20T16:45:22+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010590s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001025s ] --------------------------------------------------------------- [ 2023-03-20T16:47:59+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010593s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000444s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000902s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000998s ] --------------------------------------------------------------- [ 2023-03-20T16:48:00+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010767s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000408s ] --------------------------------------------------------------- [ 2023-03-20T16:48:26+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001368s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010360s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169115,36.023097',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679302106 WHERE `id` = 22 [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-03-20T16:48:27+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009751s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000370s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2023-03-20T16:49:17+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001606s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010640s ] [ 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 20,10 [ RunTime:0.000903s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000869s ] --------------------------------------------------------------- [ 2023-03-20T16:49:21+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ 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.009592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011418s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000440s ] --------------------------------------------------------------- [ 2023-03-20T16:49:46+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001967s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010520s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169115,36.023097',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679302186 WHERE `id` = 22 [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-03-20T16:49:47+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010530s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000770s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000929s ] --------------------------------------------------------------- [ 2023-03-20T16:49:48+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001861s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009452s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001004s ] --------------------------------------------------------------- [ 2023-03-20T16:50:23+08:00 ] 123.234.204.185 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.013005s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ] [ 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.001106s ] --------------------------------------------------------------- [ 2023-03-20T16:50:26+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.002492s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010758s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000462s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001670s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001196s ] --------------------------------------------------------------- [ 2023-03-20T16:50:28+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] 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 `id` = 22 LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009759s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000457s ] --------------------------------------------------------------- [ 2023-03-20T16:50:43+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010250s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169100,36.023000',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679302243 WHERE `id` = 22 [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-03-20T16:50:45+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001818s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012146s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000831s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000911s ] --------------------------------------------------------------- [ 2023-03-20T16:50:46+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010324s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001002s ] --------------------------------------------------------------- [ 2023-03-20T16:51:14+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009417s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000769s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001216s ] --------------------------------------------------------------- [ 2023-03-20T16:51:16+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011097s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000936s ] --------------------------------------------------------------- [ 2023-03-20T16:51:19+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009023s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000440s ] --------------------------------------------------------------- [ 2023-03-20T16:51:27+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001762s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009442s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169199,36.023099',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679302287 WHERE `id` = 22 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-03-20T16:51:28+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011425s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000397s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000825s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000967s ] --------------------------------------------------------------- [ 2023-03-20T16:51:29+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010731s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001056s ] --------------------------------------------------------------- [ 2023-03-20T17:25:14+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002321s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010800s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000433s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000882s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000985s ] --------------------------------------------------------------- [ 2023-03-20T17:25:16+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011728s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000432s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000938s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000880s ] --------------------------------------------------------------- [ 2023-03-20T17:25:19+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011040s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000397s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000928s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2023-03-20T17:25:21+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.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.009307s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009722s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000480s ] --------------------------------------------------------------- [ 2023-03-20T17:26:10+08:00 ] 123.234.204.185 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009394s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.169115,36.023097',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679304370 WHERE `id` = 22 [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-03-20T17:26:11+08:00 ] 123.234.204.185 GET /admin/show/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.011727s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000897s ] --------------------------------------------------------------- [ 2023-03-20T17:26:13+08:00 ] 123.234.204.185 GET /admin/map/index.html [ 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.011027s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001044s ] --------------------------------------------------------------- [ 2023-03-20T17:31:16+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001556s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009954s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000548s ] [ 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.000912s ] --------------------------------------------------------------- [ 2023-03-20T17:31:18+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010495s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008617s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2023-03-20T17:31:23+08:00 ] 123.234.204.185 POST /admin/show/update.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.009763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.174897,36.023097',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679304683 WHERE `id` = 22 [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2023-03-20T17:31:25+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011227s ] [ 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.000967s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001347s ] --------------------------------------------------------------- [ 2023-03-20T17:31:26+08:00 ] 123.234.204.185 GET /admin/map/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.009280s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000988s ] --------------------------------------------------------------- [ 2023-03-20T18:09:23+08:00 ] 123.234.204.185 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011241s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001124s ] --------------------------------------------------------------- [ 2023-03-20T18:09:26+08:00 ] 123.234.204.185 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010168s ] [ 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.000812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001559s ] --------------------------------------------------------------- [ 2023-03-20T18:09:28+08:00 ] 123.234.204.185 GET /admin/show/index.html?page=3 [ 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.012093s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000418s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000936s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000845s ] --------------------------------------------------------------- [ 2023-03-20T18:09:31+08:00 ] 123.234.204.185 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008900s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012294s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000520s ]