--------------------------------------------------------------- [ 2023-01-15T02:01:52+08:00 ] 39.144.7.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011376s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-01-15T02:02:00+08:00 ] 39.144.7.125 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230115&time=020101&v1=-01.261&v2=+00.020&v3=-01.097&v4=-00.682&v5=05.6&t=-05.0&h=80.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.194&a2=01.276&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001727s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230115',`time`='020101',`v1`=-1.261,`v2`=0.02,`v3`=-1.097,`v4`=-0.682,`v5`=5.6,`t`=-5,`h`=80.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.194,`a2`=1.276,`update_time`=1673719320 WHERE `imei` = '868922055684076' [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012147s ] [ 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' , '230115' , '020101' , -1.261 , 0.02 , -1.097 , -0.682 , 5.6 , -5 , 80.2 , 227 , '460044618415249' , -0 , 0.194 , 1.276 , 1673719320 , 1673719320) [ RunTime:0.001349s ] --------------------------------------------------------------- [ 2023-01-15T02:03:55+08:00 ] 39.144.9.157 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001975s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-01-15T02:03:56+08:00 ] 39.144.18.162 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001062s ] --------------------------------------------------------------- [ 2023-01-15T02:04:03+08:00 ] 39.144.9.157 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230115&time=020301&v1=-00.241&v2=+00.001&v3=+00.017&v4=-00.018&v5=05.6&t=-04.4&h=64.4&rssi=+226&ccid=4600485905031430000099m9990000000035000000g2900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011502s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230115',`time`='020301',`v1`=-0.241,`v2`=0.001,`v3`=0.017,`v4`=-0.018,`v5`=5.6,`t`=-4.4,`h`=64.4,`rssi`=226,`ccid`='4600485905031430000099m9990000000035000000g2900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673719443 WHERE `imei` = '868922055644013' [ RunTime:0.000567s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010030s ] [ 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' , '230115' , '020301' , -0.241 , 0.001 , 0.017 , -0.018 , 5.6 , -4.4 , 64.4 , 226 , '4600485905031430000099m9990000000035000000g2900,N,00E000=-00.000' , 0 , 0 , 1673719443 , 1673719443) [ RunTime:0.000539s ] --------------------------------------------------------------- [ 2023-01-15T02:04:05+08:00 ] 39.144.18.162 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230115&time=020301&v1=-01.271&v2=+00.031&v3=-00.944&v4=-00.047&v5=05.6&t=-04.7&h=61.7&rssi=+228&ccid=4600485905031420000099m9990000000308000001g2870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010737s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230115',`time`='020301',`v1`=-1.271,`v2`=0.031,`v3`=-0.944,`v4`=-0.047,`v5`=5.6,`t`=-4.7,`h`=61.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000308000001g2870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673719445 WHERE `imei` = '868922055643643' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010835s ] [ 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' , '230115' , '020301' , -1.271 , 0.031 , -0.944 , -0.047 , 5.6 , -4.7 , 61.7 , 228 , '4600485905031420000099m9990000000308000001g2870,N,00E000=-00.000' , 0 , 0 , 1673719445 , 1673719445) [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-01-15T14:03:55+08:00 ] 39.144.6.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002420s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010734s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-01-15T14:03:56+08:00 ] 221.178.126.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010872s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2023-01-15T14:04:04+08:00 ] 39.144.6.224 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230115&time=140301&v1=-00.235&v2=+00.001&v3=+00.019&v4=-00.017&v5=05.6&t=-01.8&h=64.5&rssi=+225&ccid=4600485905031430000099m9990000000036000000g2830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001957s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230115',`time`='140301',`v1`=-0.235,`v2`=0.001,`v3`=0.019,`v4`=-0.017,`v5`=5.6,`t`=-1.8,`h`=64.5,`rssi`=225,`ccid`='4600485905031430000099m9990000000036000000g2830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673762644 WHERE `imei` = '868922055644013' [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010842s ] [ 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' , '230115' , '140301' , -0.235 , 0.001 , 0.019 , -0.017 , 5.6 , -1.8 , 64.5 , 225 , '4600485905031430000099m9990000000036000000g2830,N,00E000=-00.000' , 0 , 0 , 1673762644 , 1673762644) [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-01-15T14:04:04+08:00 ] 221.178.126.141 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230115&time=140301&v1=-01.272&v2=+00.061&v3=-00.940&v4=-00.046&v5=05.6&t=-02.4&h=61.6&rssi=+231&ccid=4600485905031420000099m9990000000312000001g2880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001957s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009222s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230115',`time`='140301',`v1`=-1.272,`v2`=0.061,`v3`=-0.94,`v4`=-0.046,`v5`=5.6,`t`=-2.4,`h`=61.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000312000001g2880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673762644 WHERE `imei` = '868922055643643' [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010479s ] [ 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' , '230115' , '140301' , -1.272 , 0.061 , -0.94 , -0.046 , 5.6 , -2.4 , 61.6 , 231 , '4600485905031420000099m9990000000312000001g2880,N,00E000=-00.000' , 0 , 0 , 1673762644 , 1673762644) [ RunTime:0.000532s ]