--------------------------------------------------------------- [ 2023-01-08T02:02:51+08:00 ] 218.204.253.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002359s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011247s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-01-08T02:03:00+08:00 ] 218.204.253.190 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230108&time=020201&v1=-01.262&v2=+00.022&v3=-01.101&v4=-00.681&v5=05.7&t=+04.2&h=80.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.190&a2=01.277&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001804s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230108',`time`='020201',`v1`=-1.262,`v2`=0.022,`v3`=-1.101,`v4`=-0.681,`v5`=5.7,`t`=4.2,`h`=80.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.19,`a2`=1.277,`update_time`=1673114580 WHERE `imei` = '868922055684076' [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011263s ] [ 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' , '230108' , '020201' , -1.262 , 0.022 , -1.101 , -0.681 , 5.7 , 4.2 , 80.9 , 228 , '460044618415249' , -0 , 0.19 , 1.277 , 1673114580 , 1673114580) [ RunTime:0.001347s ] --------------------------------------------------------------- [ 2023-01-08T02:03:55+08:00 ] 221.178.124.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002013s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010227s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-01-08T02:03:55+08:00 ] 117.132.198.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-01-08T02:04:03+08:00 ] 221.178.124.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230108&time=020301&v1=-00.240&v2=+00.001&v3=+00.012&v4=-00.016&v5=05.7&t=+04.0&h=64.6&rssi=+223&ccid=4600485905031430000099m9990000000035000000g2920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010350s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230108',`time`='020301',`v1`=-0.24,`v2`=0.001,`v3`=0.012,`v4`=-0.016,`v5`=5.7,`t`=4,`h`=64.6,`rssi`=223,`ccid`='4600485905031430000099m9990000000035000000g2920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673114643 WHERE `imei` = '868922055644013' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009774s ] [ 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' , '230108' , '020301' , -0.24 , 0.001 , 0.012 , -0.016 , 5.7 , 4 , 64.6 , 223 , '4600485905031430000099m9990000000035000000g2920,N,00E000=-00.000' , 0 , 0 , 1673114643 , 1673114643) [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2023-01-08T02:04:04+08:00 ] 117.132.198.11 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230108&time=020301&v1=-00.150&v2=+00.005&v3=-00.012&v4=+00.167&v5=05.6&t=+02.5&h=61.3&rssi=+231&ccid=4600485905031420000099m9990000010029000001g0390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010501s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230108',`time`='020301',`v1`=-0.15,`v2`=0.005,`v3`=-0.012,`v4`=0.167,`v5`=5.6,`t`=2.5,`h`=61.3,`rssi`=231,`ccid`='4600485905031420000099m9990000010029000001g0390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673114644 WHERE `imei` = '868922055643643' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009382s ] [ 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' , '230108' , '020301' , -0.15 , 0.005 , -0.012 , 0.167 , 5.6 , 2.5 , 61.3 , 231 , '4600485905031420000099m9990000010029000001g0390,N,00E000=-00.000' , 0 , 0 , 1673114644 , 1673114644) [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2023-01-08T14:03:55+08:00 ] 39.144.14.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000776s ] --------------------------------------------------------------- [ 2023-01-08T14:03:55+08:00 ] 39.144.14.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002052s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-01-08T14:04:03+08:00 ] 39.144.14.134 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230108&time=140301&v1=-00.231&v2=+00.001&v3=+00.019&v4=-00.016&v5=05.9&t=+14.4&h=64.4&rssi=+226&ccid=4600485905031430000099m9990000000038000000g2800,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.012797s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013575s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000938s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230108',`time`='140301',`v1`=-0.231,`v2`=0.001,`v3`=0.019,`v4`=-0.016,`v5`=5.9,`t`=14.4,`h`=64.4,`rssi`=226,`ccid`='4600485905031430000099m9990000000038000000g2800,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673157843 WHERE `imei` = '868922055644013' [ RunTime:0.000869s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014849s ] [ 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' , '230108' , '140301' , -0.231 , 0.001 , 0.019 , -0.016 , 5.9 , 14.4 , 64.4 , 226 , '4600485905031430000099m9990000000038000000g2800,N,00E000=-00.000' , 0 , 0 , 1673157843 , 1673157843) [ RunTime:0.000927s ] --------------------------------------------------------------- [ 2023-01-08T14:04:04+08:00 ] 39.144.14.217 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230108&time=140301&v1=-00.142&v2=+00.007&v3=-00.011&v4=+00.173&v5=05.9&t=+11.5&h=59.8&rssi=+228&ccid=4600485905031420000099m9990000010026000001g0360,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002283s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013001s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000949s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230108',`time`='140301',`v1`=-0.142,`v2`=0.007,`v3`=-0.011,`v4`=0.173,`v5`=5.9,`t`=11.5,`h`=59.8,`rssi`=228,`ccid`='4600485905031420000099m9990000010026000001g0360,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673157844 WHERE `imei` = '868922055643643' [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014154s ] [ 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' , '230108' , '140301' , -0.142 , 0.007 , -0.011 , 0.173 , 5.9 , 11.5 , 59.8 , 228 , '4600485905031420000099m9990000010026000001g0360,N,00E000=-00.000' , 0 , 0 , 1673157844 , 1673157844) [ RunTime:0.000831s ]