--------------------------------------------------------------- [ 2023-01-13T02:02:50+08:00 ] 218.204.253.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.009345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012880s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001299s ] --------------------------------------------------------------- [ 2023-01-13T02:02:59+08:00 ] 218.204.253.114 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230113&time=020201&v1=-01.257&v2=+00.016&v3=-01.096&v4=-00.679&v5=05.9&t=+08.7&h=81.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.192&a2=01.272&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010114s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230113',`time`='020201',`v1`=-1.257,`v2`=0.016,`v3`=-1.096,`v4`=-0.679,`v5`=5.9,`t`=8.7,`h`=81,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.192,`a2`=1.272,`update_time`=1673546579 WHERE `imei` = '868922055684076' [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012509s ] [ 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' , '230113' , '020201' , -1.257 , 0.016 , -1.096 , -0.679 , 5.9 , 8.7 , 81 , 228 , '460044618415249' , -0 , 0.192 , 1.272 , 1673546579 , 1673546579) [ RunTime:0.001324s ] --------------------------------------------------------------- [ 2023-01-13T02:03:55+08:00 ] 221.178.126.242 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011244s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-01-13T02:03:56+08:00 ] 39.144.16.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.009608s ] 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` = '868922055643643' LIMIT 1 [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2023-01-13T02:04:04+08:00 ] 221.178.126.242 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230113&time=020301&v1=-00.209&v2=+00.001&v3=-00.128&v4=-00.014&v5=05.9&t=+08.8&h=64.6&rssi=+224&ccid=4600485905031430000099m9990000000022000000g2220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010288s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230113',`time`='020301',`v1`=-0.209,`v2`=0.001,`v3`=-0.128,`v4`=-0.014,`v5`=5.9,`t`=8.8,`h`=64.6,`rssi`=224,`ccid`='4600485905031430000099m9990000000022000000g2220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673546644 WHERE `imei` = '868922055644013' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010032s ] [ 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' , '230113' , '020301' , -0.209 , 0.001 , -0.128 , -0.014 , 5.9 , 8.8 , 64.6 , 224 , '4600485905031430000099m9990000000022000000g2220,N,00E000=-00.000' , 0 , 0 , 1673546644 , 1673546644) [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-01-13T02:04:04+08:00 ] 39.144.16.244 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230113&time=020301&v1=-01.257&v2=+00.031&v3=-00.982&v4=-00.044&v5=05.6&t=+08.6&h=61.8&rssi=+229&ccid=4600485905031420000099m9990000000258000001g2720,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010165s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230113',`time`='020301',`v1`=-1.257,`v2`=0.031,`v3`=-0.982,`v4`=-0.044,`v5`=5.6,`t`=8.6,`h`=61.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000258000001g2720,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673546644 WHERE `imei` = '868922055643643' [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011898s ] [ 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' , '230113' , '020301' , -1.257 , 0.031 , -0.982 , -0.044 , 5.6 , 8.6 , 61.8 , 229 , '4600485905031420000099m9990000000258000001g2720,N,00E000=-00.000' , 0 , 0 , 1673546644 , 1673546644) [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-01-13T14:03:55+08:00 ] 39.144.13.239 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011587s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-01-13T14:03:55+08:00 ] 111.55.139.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001620s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010870s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2023-01-13T14:04:03+08:00 ] 39.144.13.239 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230113&time=140301&v1=-01.256&v2=+00.062&v3=-00.977&v4=-00.043&v5=05.7&t=+06.9&h=62.0&rssi=+230&ccid=4600485905031420000099m9990000000262000001g2720,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.010109s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230113',`time`='140301',`v1`=-1.256,`v2`=0.062,`v3`=-0.977,`v4`=-0.043,`v5`=5.7,`t`=6.9,`h`=62,`rssi`=230,`ccid`='4600485905031420000099m9990000000262000001g2720,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673589843 WHERE `imei` = '868922055643643' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011837s ] [ 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' , '230113' , '140301' , -1.256 , 0.062 , -0.977 , -0.043 , 5.7 , 6.9 , 62 , 230 , '4600485905031420000099m9990000000262000001g2720,N,00E000=-00.000' , 0 , 0 , 1673589843 , 1673589843) [ RunTime:0.000825s ] --------------------------------------------------------------- [ 2023-01-13T14:04:04+08:00 ] 111.55.139.41 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230113&time=140301&v1=-00.199&v2=+00.001&v3=-00.149&v4=-00.011&v5=05.9&t=+07.0&h=64.6&rssi=+227&ccid=4600485905031430000099m9990000000005000000g2090,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.010957s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230113',`time`='140301',`v1`=-0.199,`v2`=0.001,`v3`=-0.149,`v4`=-0.011,`v5`=5.9,`t`=7,`h`=64.6,`rssi`=227,`ccid`='4600485905031430000099m9990000000005000000g2090,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673589844 WHERE `imei` = '868922055644013' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010945s ] [ 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' , '230113' , '140301' , -0.199 , 0.001 , -0.149 , -0.011 , 5.9 , 7 , 64.6 , 227 , '4600485905031430000099m9990000000005000000g2090,N,00E000=-00.000' , 0 , 0 , 1673589844 , 1673589844) [ RunTime:0.000908s ]