--------------------------------------------------------------- [ 2023-02-09T02:03:56+08:00 ] 39.144.11.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003014s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012113s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001413s ] --------------------------------------------------------------- [ 2023-02-09T02:03:56+08:00 ] 39.144.2.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2023-02-09T02:04:04+08:00 ] 39.144.11.16 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230209&time=020301&v1=-00.310&v2=+00.001&v3=-00.002&v4=-00.016&v5=05.7&t=+00.8&h=64.8&rssi=+225&ccid=4600485905031430000099m9990000000036000000g3650,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001546s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010002s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230209',`time`='020301',`v1`=-0.31,`v2`=0.001,`v3`=-0.002,`v4`=-0.016,`v5`=5.7,`t`=0.8,`h`=64.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000036000000g3650,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675879444 WHERE `imei` = '868922055644013' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010963s ] [ 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' , '230209' , '020301' , -0.31 , 0.001 , -0.002 , -0.016 , 5.7 , 0.8 , 64.8 , 225 , '4600485905031430000099m9990000000036000000g3650,N,00E000=-00.000' , 0 , 0 , 1675879444 , 1675879444) [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-02-09T02:04:04+08:00 ] 39.144.2.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230209&time=020301&v1=-01.240&v2=+00.036&v3=-00.934&v4=-00.030&v5=05.7&t=+00.2&h=61.8&rssi=+230&ccid=4600485905031420000099m9990000000280000001g2540,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003115s ] 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 * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230209',`time`='020301',`v1`=-1.24,`v2`=0.036,`v3`=-0.934,`v4`=-0.03,`v5`=5.7,`t`=0.2,`h`=61.8,`rssi`=230,`ccid`='4600485905031420000099m9990000000280000001g2540,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675879444 WHERE `imei` = '868922055643643' [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010783s ] [ 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' , '230209' , '020301' , -1.24 , 0.036 , -0.934 , -0.03 , 5.7 , 0.2 , 61.8 , 230 , '4600485905031420000099m9990000000280000001g2540,N,00E000=-00.000' , 0 , 0 , 1675879444 , 1675879444) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-02-09T06:12:51+08:00 ] 39.144.16.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002350s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010752s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-02-09T06:12:59+08:00 ] 39.144.16.202 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230209&time=061201&v1=-01.261&v2=+00.022&v3=-01.046&v4=-00.625&v5=05.7&t=+01.7&h=80.5&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.241&a2=01.275&a3=00.000&end=$ [ 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.012097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000830s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230209',`time`='061201',`v1`=-1.261,`v2`=0.022,`v3`=-1.046,`v4`=-0.625,`v5`=5.7,`t`=1.7,`h`=80.5,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.241,`a2`=1.275,`update_time`=1675894379 WHERE `imei` = '868922055684076' [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012026s ] [ 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' , '230209' , '061201' , -1.261 , 0.022 , -1.046 , -0.625 , 5.7 , 1.7 , 80.5 , 227 , '460044618415249' , -0 , 0.241 , 1.275 , 1675894379 , 1675894379) [ RunTime:0.001253s ] --------------------------------------------------------------- [ 2023-02-09T10:24:44+08:00 ] 39.77.143.230 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013511s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2023-02-09T10:24:48+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010428s ] [ 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.000799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-02-09T10:25:09+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=2 [ 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.011326s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000540s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000765s ] --------------------------------------------------------------- [ 2023-02-09T10:25:18+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001688s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010228s ] [ 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.000721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-02-09T10:25:28+08:00 ] 39.77.143.230 GET /admin/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011323s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.003897s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.018997s ] --------------------------------------------------------------- [ 2023-02-09T10:25:33+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010911s ] [ 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.000790s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-02-09T10:25:38+08:00 ] 39.77.143.230 GET /admin/show/read/id/35/imei/868922056976208.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.009712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012205s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000836s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002896s ] --------------------------------------------------------------- [ 2023-02-09T10:26:45+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002320s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010653s ] [ 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.000814s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000876s ] --------------------------------------------------------------- [ 2023-02-09T10:26:48+08:00 ] 39.77.143.230 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001619s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000930s ] --------------------------------------------------------------- [ 2023-02-09T10:32:16+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012175s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000480s ] [ 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.000728s ] --------------------------------------------------------------- [ 2023-02-09T10:47:31+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002202s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010438s ] [ 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.000836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000842s ] --------------------------------------------------------------- [ 2023-02-09T10:47:32+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011011s ] [ 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.000776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-02-09T10:47:34+08:00 ] 39.77.143.230 GET /admin/show/edit/id/35.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001875s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010220s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012091s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001267s ] --------------------------------------------------------------- [ 2023-02-09T10:49:38+08:00 ] 39.77.143.230 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.010079s ] [ 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.000802s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-02-09T10:52:17+08:00 ] 39.77.143.230 GET /admin/show/index.html [ 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.011816s ] [ 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.000766s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-02-09T10:52:29+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=2 [ 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.010851s ] [ 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 10,10 [ RunTime:0.000745s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2023-02-09T10:52:31+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=1 [ 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.011004s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000822s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-02-09T10:53:11+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009482s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000889s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000752s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-02-09T10:53:14+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=1 [ 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.010149s ] [ 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.000818s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2023-02-09T10:53:17+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=2 [ 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.013148s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001131s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001068s ] --------------------------------------------------------------- [ 2023-02-09T10:53:20+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.002108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009834s ] [ 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.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2023-02-09T10:54:46+08:00 ] 39.77.143.230 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.009717s ] [ 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.000756s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2023-02-09T10:54:50+08:00 ] 39.77.143.230 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002144s ] 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` ORDER BY `id` DESC [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2023-02-09T13:41:49+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012159s ] [ 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.000843s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2023-02-09T13:41:52+08:00 ] 39.77.143.230 GET /admin/show/edit/id/35.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009677s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000757s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011202s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000485s ] --------------------------------------------------------------- [ 2023-02-09T13:41:56+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002030s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010043s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-02-09T13:42:00+08:00 ] 39.77.143.230 GET /admin/show/edit/id/34.html [ 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.010490s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011191s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2023-02-09T13:42:04+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001693s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008649s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001117s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-02-09T13:42:07+08:00 ] 39.77.143.230 GET /admin/show/edit/id/31.html [ 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.011024s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010527s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2023-02-09T13:42:13+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011090s ] [ 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.000823s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-02-09T13:42:36+08:00 ] 39.77.143.230 GET /admin/show/edit/id/24.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.010065s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011188s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2023-02-09T13:42:44+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001823s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009706s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000385s ] [ 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.000677s ] --------------------------------------------------------------- [ 2023-02-09T13:52:55+08:00 ] 39.77.143.230 GET /admin/show/read/id/33/imei/868922055644013.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.010002s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012209s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000857s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003870s ] --------------------------------------------------------------- [ 2023-02-09T13:54:13+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010061s ] [ 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.000783s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-02-09T13:54:16+08:00 ] 39.77.143.230 GET /admin/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001269s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002821s ] --------------------------------------------------------------- [ 2023-02-09T14:03:54+08:00 ] 111.55.138.170 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010074s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000793s ] --------------------------------------------------------------- [ 2023-02-09T14:03:55+08:00 ] 39.144.10.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010957s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-02-09T14:04:03+08:00 ] 111.55.138.170 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230209&time=140301&v1=-00.296&v2=+00.001&v3=+00.019&v4=-00.016&v5=05.7&t=+05.7&h=64.4&rssi=+225&ccid=4600485905031430000099m9990000000037000000g3510,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230209',`time`='140301',`v1`=-0.296,`v2`=0.001,`v3`=0.019,`v4`=-0.016,`v5`=5.7,`t`=5.7,`h`=64.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g3510,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675922643 WHERE `imei` = '868922055644013' [ RunTime:0.000804s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011634s ] [ 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' , '230209' , '140301' , -0.296 , 0.001 , 0.019 , -0.016 , 5.7 , 5.7 , 64.4 , 225 , '4600485905031430000099m9990000000037000000g3510,N,00E000=-00.000' , 0 , 0 , 1675922643 , 1675922643) [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-02-09T14:04:03+08:00 ] 39.144.10.236 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230209&time=140301&v1=-01.241&v2=+00.082&v3=-00.923&v4=-00.029&v5=05.7&t=+05.7&h=61.5&rssi=+229&ccid=4600485905031420000099m9990000000289000001g2550,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010887s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230209',`time`='140301',`v1`=-1.241,`v2`=0.082,`v3`=-0.923,`v4`=-0.029,`v5`=5.7,`t`=5.7,`h`=61.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000289000001g2550,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675922643 WHERE `imei` = '868922055643643' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009388s ] [ 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' , '230209' , '140301' , -1.241 , 0.082 , -0.923 , -0.029 , 5.7 , 5.7 , 61.5 , 229 , '4600485905031420000099m9990000000289000001g2550,N,00E000=-00.000' , 0 , 0 , 1675922643 , 1675922643) [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2023-02-09T14:36:31+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012333s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000931s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000793s ] --------------------------------------------------------------- [ 2023-02-09T14:36:37+08:00 ] 39.77.143.230 GET /admin/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009188s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004036s ] --------------------------------------------------------------- [ 2023-02-09T14:43:00+08:00 ] 111.55.138.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016213s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001116s ] --------------------------------------------------------------- [ 2023-02-09T14:43:02+08:00 ] 111.55.138.13 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1675924980&v1=0.018813&v2=0.084594&v3=0.015712&v4=-0.004425&v5=5.760000&t=16.406626&h=45.017761&rssi=17&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002299s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011947s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1675924980,`v1`=0.018813,`v2`=0.084594,`v3`=0.015712,`v4`=-0.004425,`v5`=5.76,`t`=16.406626,`h`=45.017761,`rssi`=17,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1675924982 WHERE `imei` = '868922055683920' [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011356s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1675924980 , 0.018813 , 0.084594 , 0.015712 , -0.004425 , 5.76 , 16.406626 , 45.017761 , 17 , '89860426102071188500' , '460044618415250' , -0 , 1675924982) [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2023-02-09T15:03:40+08:00 ] 223.104.255.220 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009917s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-02-09T15:03:42+08:00 ] 223.104.255.220 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1675926220&v1=0.015321&v2=4.631907&v3=0.015532&v4=0.015562&v5=5.580000&t=17.725813&h=43.949646&rssi=16&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011001s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1675926220,`v1`=0.015321,`v2`=4.631907,`v3`=0.015532,`v4`=0.015562,`v5`=5.58,`t`=17.725813,`h`=43.949646,`rssi`=16,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1675926222 WHERE `imei` = '868922055683920' [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010757s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1675926220 , 0.015321 , 4.631907 , 0.015532 , 0.015562 , 5.58 , 17.725813 , 43.949646 , 16 , '89860426102071188500' , '460044618415250' , -0 , 1675926222) [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-02-09T15:03:43+08:00 ] 223.104.255.220 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=4294938496&v1=0.009301&v2=0.030875&v3=0.015622&v4=0.015201&v5=6.660000&t=18.058290&h=42.240662&rssi=16&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011003s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=4294938496,`v1`=0.009301,`v2`=0.030875,`v3`=0.015622,`v4`=0.015201,`v5`=6.66,`t`=18.05829,`h`=42.240662,`rssi`=16,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1675926223 WHERE `imei` = '868922055683920' [ RunTime:0.000492s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010090s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 4294938496 , 0.009301 , 0.030875 , 0.015622 , 0.015201 , 6.66 , 18.05829 , 42.240662 , 16 , '89860426102071188500' , '460044618415250' , -0 , 1675926223) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2023-02-09T15:04:11+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001555s ] 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 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.000895s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000853s ] --------------------------------------------------------------- [ 2023-02-09T15:04:20+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001973s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011196s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001014s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001265s ] --------------------------------------------------------------- [ 2023-02-09T15:04:23+08:00 ] 39.77.143.230 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001952s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010611s ] [ 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.000852s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-02-09T15:04:31+08:00 ] 39.77.143.230 GET /admin/show/read/id/30/imei/868922055683920.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020589s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000809s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010745s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002896s ] --------------------------------------------------------------- [ 2023-02-09T15:04:48+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010388s ] [ 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.000816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2023-02-09T15:04:53+08:00 ] 39.77.143.230 GET /admin/show/edit/id/30.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011751s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012803s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-02-09T15:05:45+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011252s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000811s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-02-09T15:28:22+08:00 ] 117.132.195.206 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002270s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011250s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2023-02-09T15:28:23+08:00 ] 117.132.195.206 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1675927702&v1=0.024351&v2=16.864746&v3=0.023388&v4=0.024893&v5=5.580000&t=14.165081&h=48.039001&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001867s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010516s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1675927702,`v1`=0.024351,`v2`=16.864746,`v3`=0.023388,`v4`=0.024893,`v5`=5.58,`t`=14.165081,`h`=48.039001,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1675927703 WHERE `imei` = '868922056976208' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011317s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1675927702 , 0.024351 , 16.864746 , 0.023388 , 0.024893 , 5.58 , 14.165081 , 48.039001 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1675927703) [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-02-09T15:28:42+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011175s ] [ 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.000821s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-02-09T17:52:26+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012177s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000449s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001181s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000820s ] --------------------------------------------------------------- [ 2023-02-09T17:52:27+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011654s ] [ 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.000796s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-02-09T17:52:31+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002812s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011882s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001123s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001315s ] --------------------------------------------------------------- [ 2023-02-09T17:52:41+08:00 ] 117.132.195.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002072s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1675936361 , 1675936361) [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2023-02-09T17:52:44+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013693s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001028s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000898s ] --------------------------------------------------------------- [ 2023-02-09T17:52:46+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002056s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010679s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001055s ] --------------------------------------------------------------- [ 2023-02-09T17:52:47+08:00 ] 117.132.195.150 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.001712s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009660s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.001049s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1675936367 WHERE `imei` = ' GSN' [ RunTime:0.000496s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011492s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1675936367 , 1675936367) [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-02-09T17:52:49+08:00 ] 39.77.143.230 GET /admin/show/index.html [ 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.010487s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000415s ] [ 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.000746s ] --------------------------------------------------------------- [ 2023-02-09T17:52:50+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012026s ] [ 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.000823s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000786s ] --------------------------------------------------------------- [ 2023-02-09T17:52:56+08:00 ] 39.77.143.230 GET /admin/show/read/id/36/imei/+GSN.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002034s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012086s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014403s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '+GSN' LIMIT 1 [ RunTime:0.002641s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '+GSN' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2023-02-09T17:52:58+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009159s ] [ 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.000783s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2023-02-09T17:54:56+08:00 ] 39.144.1.235 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ 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.011938s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000949s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055683912' , 1675936496 , 1675936496) [ RunTime:0.000442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-02-09T17:54:57+08:00 ] 39.144.1.235 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1675936496&v1=0.028084&v2=9.125292&v3=0.027542&v4=0.027662&v5=6.120000&t=16.878531&h=36.503357&rssi=27&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ 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.011859s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001139s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1675936496,`v1`=0.028084,`v2`=9.125292,`v3`=0.027542,`v4`=0.027662,`v5`=6.12,`t`=16.878531,`h`=36.503357,`rssi`=27,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1675936497 WHERE `imei` = '868922055683912' [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009512s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1675936496 , 0.028084 , 9.125292 , 0.027542 , 0.027662 , 6.12 , 16.878531 , 36.503357 , 27 , '898604650119C1053138' , '460048590503138' , -0 , 1675936497) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-02-09T17:55:03+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011929s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000830s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2023-02-09T17:55:09+08:00 ] 39.77.143.230 GET /admin/show/delete/id/36.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.010531s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 36 [ RunTime:0.000685s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 36 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2023-02-09T17:55:10+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012372s ] [ 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 0,10 [ RunTime:0.000832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-02-09T18:06:51+08:00 ] 117.132.192.183 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.003194s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1675937211 , 1675937211) [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-02-09T18:06:55+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010426s ] [ 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.000873s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001352s ] --------------------------------------------------------------- [ 2023-02-09T18:06:56+08:00 ] 117.132.192.183 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011095s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1675937216 WHERE `imei` = ' GSN' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010310s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1675937216 , 1675937216) [ RunTime:0.000516s ] --------------------------------------------------------------- [ 2023-02-09T18:06:58+08:00 ] 39.77.143.230 GET /admin/show/index.html [ 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.010098s ] [ 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.000838s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000792s ] --------------------------------------------------------------- [ 2023-02-09T18:06:59+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010603s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000399s ] [ 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.000699s ] --------------------------------------------------------------- [ 2023-02-09T18:07:00+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001933s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015322s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000555s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001182s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2023-02-09T18:07:01+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010208s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000940s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000749s ] --------------------------------------------------------------- [ 2023-02-09T18:09:06+08:00 ] 39.144.7.187 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002720s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055684548' , 1675937346 , 1675937346) [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-02-09T18:09:07+08:00 ] 39.144.7.187 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1675937346&v1=0.012913&v2=1.909465&v3=0.013094&v4=0.013395&v5=5.940000&t=17.511311&h=35.763306&rssi=25&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ 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.010874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000797s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1675937346,`v1`=0.012913,`v2`=1.909465,`v3`=0.013094,`v4`=0.013395,`v5`=5.94,`t`=17.511311,`h`=35.763306,`rssi`=25,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1675937347 WHERE `imei` = '868922055684548' [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010500s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1675937346 , 0.012913 , 1.909465 , 0.013094 , 0.013395 , 5.94 , 17.511311 , 35.763306 , 25 , '898604650119C1053137' , '460048590503137' , -0 , 1675937347) [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-02-09T18:09:25+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009641s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000460s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000788s ] --------------------------------------------------------------- [ 2023-02-09T18:13:06+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001696s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011406s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000760s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-02-09T18:13:08+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002360s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009097s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-02-09T18:13:09+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002253s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009814s ] [ 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.000787s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-02-09T18:13:11+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012622s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000448s ] [ 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.000989s ] --------------------------------------------------------------- [ 2023-02-09T18:13:14+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011306s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000340s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000971s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-02-09T18:13:15+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002008s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011799s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000409s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000819s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2023-02-09T18:13:15+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010710s ] [ 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.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000780s ] --------------------------------------------------------------- [ 2023-02-09T18:13:17+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009677s ] [ 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.000783s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-02-09T18:14:39+08:00 ] 223.104.255.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055683771' , 1675937679 , 1675937679) [ RunTime:0.000518s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2023-02-09T18:14:41+08:00 ] 223.104.255.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1675937679&v1=0.015140&v2=9.304911&v3=0.015020&v4=0.015261&v5=6.120000&t=16.052698&h=38.601440&rssi=10&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010192s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1675937679,`v1`=0.01514,`v2`=9.304911,`v3`=0.01502,`v4`=0.015261,`v5`=6.12,`t`=16.052698,`h`=38.60144,`rssi`=10,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1675937681 WHERE `imei` = '868922055683771' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009903s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1675937679 , 0.01514 , 9.304911 , 0.01502 , 0.015261 , 6.12 , 16.052698 , 38.60144 , 10 , '898604650119C1053136' , '460048590503136' , -0 , 1675937681) [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2023-02-09T18:14:47+08:00 ] 39.77.143.230 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002291s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009651s ] [ 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.000791s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000686s ]