--------------------------------------------------------------- [ 2023-04-24T00:34:27+08:00 ] 112.224.69.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011593s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-04-24T00:34:29+08:00 ] 112.224.69.25 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682267667&v1=0.031094&v2=0.013560&v3=0.026338&v4=0.001355&v5=12.060000&t=15.430642&h=55.233521&rssi=24&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682267667,`v1`=0.031094,`v2`=0.01356,`v3`=0.026338,`v4`=0.001355,`v5`=12.06,`t`=15.430642,`h`=55.233521,`rssi`=24,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1682267669 WHERE `imei` = '868922055678110' [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011074s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682267667 , 0.031094 , 0.01356 , 0.026338 , 0.001355 , 12.06 , 15.430642 , 55.233521 , 24 , '89860118803392574452' , '460015788115318' , -0 , 1682267669) [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-04-24T02:03:55+08:00 ] 218.204.253.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012233s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001531s ] --------------------------------------------------------------- [ 2023-04-24T02:03:55+08:00 ] 117.132.194.74 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001948s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010249s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001429s ] --------------------------------------------------------------- [ 2023-04-24T02:04:04+08:00 ] 218.204.253.30 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230424&time=020301&v1=-00.222&v2=+00.001&v3=-00.005&v4=-00.012&v5=05.9&t=+10.8&h=63.4&rssi=+225&ccid=4600485905031430000099m9990000000029000000g2360,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.009665s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230424',`time`='020301',`v1`=-0.222,`v2`=0.001,`v3`=-0.005,`v4`=-0.012,`v5`=5.9,`t`=10.8,`h`=63.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000029000000g2360,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682273044 WHERE `imei` = '868922055644013' [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010105s ] [ 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' , '230424' , '020301' , -0.222 , 0.001 , -0.005 , -0.012 , 5.9 , 10.8 , 63.4 , 225 , '4600485905031430000099m9990000000029000000g2360,N,00E000=-00.000' , 0 , 0 , 1682273044 , 1682273044) [ RunTime:0.001293s ] --------------------------------------------------------------- [ 2023-04-24T02:04:04+08:00 ] 117.132.194.74 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230424&time=020301&v1=-01.331&v2=+00.015&v3=-00.973&v4=-00.030&v5=05.9&t=+10.6&h=60.6&rssi=+229&ccid=4600485905031420000099m9990000000362000001g3410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009761s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230424',`time`='020301',`v1`=-1.331,`v2`=0.015,`v3`=-0.973,`v4`=-0.03,`v5`=5.9,`t`=10.6,`h`=60.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000362000001g3410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682273044 WHERE `imei` = '868922055643643' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009528s ] [ 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' , '230424' , '020301' , -1.331 , 0.015 , -0.973 , -0.03 , 5.9 , 10.6 , 60.6 , 229 , '4600485905031420000099m9990000000362000001g3410,N,00E000=-00.000' , 0 , 0 , 1682273044 , 1682273044) [ RunTime:0.001420s ] --------------------------------------------------------------- [ 2023-04-24T04:35:28+08:00 ] 112.224.70.164 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011423s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-04-24T04:35:30+08:00 ] 112.224.70.164 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682282128&v1=0.031033&v2=0.013977&v3=0.026398&v4=0.001234&v5=12.240000&t=15.130340&h=50.770325&rssi=24&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ 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.009440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682282128,`v1`=0.031033,`v2`=0.013977,`v3`=0.026398,`v4`=0.001234,`v5`=12.24,`t`=15.13034,`h`=50.770325,`rssi`=24,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1682282130 WHERE `imei` = '868922055678110' [ RunTime:0.001256s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009798s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682282128 , 0.031033 , 0.013977 , 0.026398 , 0.001234 , 12.24 , 15.13034 , 50.770325 , 24 , '89860118803392574452' , '460015788115318' , -0 , 1682282130) [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-04-24T08:14:50+08:00 ] 124.129.96.215 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002113s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014044s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000889s ] --------------------------------------------------------------- [ 2023-04-24T08:14:55+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012894s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000426s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000884s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001052s ] --------------------------------------------------------------- [ 2023-04-24T08:15:48+08:00 ] 124.129.96.215 GET /admin/show/read/id/58/imei/868922055678110.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.009587s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011247s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002148s ] --------------------------------------------------------------- [ 2023-04-24T08:36:23+08:00 ] 112.224.70.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010153s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001006s ] --------------------------------------------------------------- [ 2023-04-24T08:36:24+08:00 ] 112.224.70.14 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682296583&v1=0.031094&v2=0.014082&v3=0.026278&v4=0.001234&v5=12.420000&t=15.677320&h=46.749634&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.185654,35.984025&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002053s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682296583,`v1`=0.031094,`v2`=0.014082,`v3`=0.026278,`v4`=0.001234,`v5`=12.42,`t`=15.67732,`h`=46.749634,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.185654,35.984025',`update_time`=1682296584 WHERE `imei` = '868922055678110' [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010404s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682296583 , 0.031094 , 0.014082 , 0.026278 , 0.001234 , 12.42 , 15.67732 , 46.749634 , 26 , '89860118803392574452' , '460015788115318' , -0 , '120.185654,35.984025' , 1682296584) [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2023-04-24T08:39:53+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010955s ] [ 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.000905s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001016s ] --------------------------------------------------------------- [ 2023-04-24T10:00:50+08:00 ] 39.144.17.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010927s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-04-24T10:00:59+08:00 ] 39.144.17.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230424&time=100001&v1=-01.159&v2=+00.046&v3=-01.050&v4=-00.406&v5=05.9&t=+16.1&h=79.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.135&a2=01.218&a3=00.000&end=$ [ 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.011076s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230424',`time`='100001',`v1`=-1.159,`v2`=0.046,`v3`=-1.05,`v4`=-0.406,`v5`=5.9,`t`=16.1,`h`=79.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.135,`a2`=1.218,`update_time`=1682301659 WHERE `imei` = '868922055684076' [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010687s ] [ 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' , '230424' , '100001' , -1.159 , 0.046 , -1.05 , -0.406 , 5.9 , 16.1 , 79.2 , 228 , '460044618415249' , -0 , 0.135 , 1.218 , 1682301659 , 1682301659) [ RunTime:0.001369s ] --------------------------------------------------------------- [ 2023-04-24T12:37:16+08:00 ] 112.224.67.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011954s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-04-24T12:37:18+08:00 ] 112.224.67.101 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682311036&v1=0.031154&v2=0.015229&v3=0.026458&v4=0.001234&v5=12.420000&t=17.672188&h=51.388306&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184830,35.985566&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010370s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682311036,`v1`=0.031154,`v2`=0.015229,`v3`=0.026458,`v4`=0.001234,`v5`=12.42,`t`=17.672188,`h`=51.388306,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184830,35.985566',`update_time`=1682311038 WHERE `imei` = '868922055678110' [ RunTime:0.000721s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010949s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682311036 , 0.031154 , 0.015229 , 0.026458 , 0.001234 , 12.42 , 17.672188 , 51.388306 , 26 , '89860118803392574452' , '460015788115318' , -0 , '120.184830,35.985566' , 1682311038) [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-04-24T14:03:55+08:00 ] 117.132.192.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.011353s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2023-04-24T14:03:55+08:00 ] 111.55.140.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-04-24T14:04:03+08:00 ] 117.132.192.19 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230424&time=140301&v1=-00.247&v2=+00.002&v3=+00.020&v4=-00.011&v5=06.0&t=+20.9&h=61.9&rssi=+226&ccid=4600485905031430000099m9990000000040000000g2670,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230424',`time`='140301',`v1`=-0.247,`v2`=0.002,`v3`=0.02,`v4`=-0.011,`v5`=6,`t`=20.9,`h`=61.9,`rssi`=226,`ccid`='4600485905031430000099m9990000000040000000g2670,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682316243 WHERE `imei` = '868922055644013' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012093s ] [ 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' , '230424' , '140301' , -0.247 , 0.002 , 0.02 , -0.011 , 6 , 20.9 , 61.9 , 226 , '4600485905031430000099m9990000000040000000g2670,N,00E000=-00.000' , 0 , 0 , 1682316243 , 1682316243) [ RunTime:0.001193s ] --------------------------------------------------------------- [ 2023-04-24T14:04:04+08:00 ] 111.55.140.213 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230424&time=140301&v1=-01.331&v2=+00.039&v3=-00.969&v4=-00.030&v5=05.7&t=+20.1&h=58.5&rssi=+228&ccid=4600485905031420000099m9990000000363000001g3400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230424',`time`='140301',`v1`=-1.331,`v2`=0.039,`v3`=-0.969,`v4`=-0.03,`v5`=5.7,`t`=20.1,`h`=58.5,`rssi`=228,`ccid`='4600485905031420000099m9990000000363000001g3400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682316244 WHERE `imei` = '868922055643643' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010771s ] [ 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' , '230424' , '140301' , -1.331 , 0.039 , -0.969 , -0.03 , 5.7 , 20.1 , 58.5 , 228 , '4600485905031420000099m9990000000363000001g3400,N,00E000=-00.000' , 0 , 0 , 1682316244 , 1682316244) [ RunTime:0.001088s ] --------------------------------------------------------------- [ 2023-04-24T14:15:57+08:00 ] 221.178.127.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002262s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011039s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2023-04-24T14:16:05+08:00 ] 221.178.127.29 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230424&time=141501&v1=-01.198&v2=+00.029&v3=-01.057&v4=-00.364&v5=06.0&t=+22.4&h=78.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.134&a2=01.204&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010167s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230424',`time`='141501',`v1`=-1.198,`v2`=0.029,`v3`=-1.057,`v4`=-0.364,`v5`=6,`t`=22.4,`h`=78.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.134,`a2`=1.204,`update_time`=1682316965 WHERE `imei` = '868922055684076' [ RunTime:0.001029s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010067s ] [ 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' , '230424' , '141501' , -1.198 , 0.029 , -1.057 , -0.364 , 6 , 22.4 , 78.4 , 228 , '460044618415249' , -0 , 0.134 , 1.204 , 1682316965 , 1682316965) [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2023-04-24T16:37:57+08:00 ] 112.224.69.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002240s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011497s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001374s ] --------------------------------------------------------------- [ 2023-04-24T16:37:59+08:00 ] 112.224.69.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682325477&v1=0.031214&v2=0.013769&v3=0.026488&v4=0.001294&v5=12.420000&t=17.264633&h=43.728394&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184336,35.984881&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.010673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682325477,`v1`=0.031214,`v2`=0.013769,`v3`=0.026488,`v4`=0.001294,`v5`=12.42,`t`=17.264633,`h`=43.728394,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184336,35.984881',`update_time`=1682325479 WHERE `imei` = '868922055678110' [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011144s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682325477 , 0.031214 , 0.013769 , 0.026488 , 0.001294 , 12.42 , 17.264633 , 43.728394 , 26 , '89860118803392574452' , '460015788115318' , -0 , '120.184336,35.984881' , 1682325479) [ RunTime:0.001338s ] --------------------------------------------------------------- [ 2023-04-24T19:02:04+08:00 ] 112.224.67.62 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013248s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-04-24T19:02:07+08:00 ] 112.224.67.62 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010729s ] [ sql ] [ SQL ] SELECT 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.000796s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000963s ] --------------------------------------------------------------- [ 2023-04-24T20:38:28+08:00 ] 112.224.67.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011312s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2023-04-24T20:38:29+08:00 ] 112.224.67.94 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682339908&v1=0.031094&v2=0.013039&v3=0.026398&v4=0.001294&v5=12.420000&t=16.170673&h=47.398132&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010143s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682339908,`v1`=0.031094,`v2`=0.013039,`v3`=0.026398,`v4`=0.001294,`v5`=12.42,`t`=16.170673,`h`=47.398132,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1682339909 WHERE `imei` = '868922055678110' [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011822s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682339908 , 0.031094 , 0.013039 , 0.026398 , 0.001294 , 12.42 , 16.170673 , 47.398132 , 25 , '89860118803392574452' , '460015788115318' , -0 , 1682339909) [ RunTime:0.000665s ]