--------------------------------------------------------------- [ 2023-01-09T02:02:51+08:00 ] 117.132.194.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004360s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001038s ] --------------------------------------------------------------- [ 2023-01-09T02:03:00+08:00 ] 117.132.194.232 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230109&time=020201&v1=-01.262&v2=+00.022&v3=-01.099&v4=-00.681&v5=05.7&t=+00.7&h=81.1&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.193&a2=01.277&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010665s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230109',`time`='020201',`v1`=-1.262,`v2`=0.022,`v3`=-1.099,`v4`=-0.681,`v5`=5.7,`t`=0.7,`h`=81.1,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.193,`a2`=1.277,`update_time`=1673200980 WHERE `imei` = '868922055684076' [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012428s ] [ 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' , '230109' , '020201' , -1.262 , 0.022 , -1.099 , -0.681 , 5.7 , 0.7 , 81.1 , 227 , '460044618415249' , -0 , 0.193 , 1.277 , 1673200980 , 1673200980) [ RunTime:0.001441s ] --------------------------------------------------------------- [ 2023-01-09T02:03:55+08:00 ] 39.144.10.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002109s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008820s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-01-09T02:03:55+08:00 ] 39.144.6.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011134s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-01-09T02:04:03+08:00 ] 39.144.10.49 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230109&time=020301&v1=-00.228&v2=+00.001&v3=+00.000&v4=-00.017&v5=05.7&t=-00.3&h=65.0&rssi=+223&ccid=4600485905031430000099m9990000000032000000g2720,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230109',`time`='020301',`v1`=-0.228,`v2`=0.001,`v3`=0,`v4`=-0.017,`v5`=5.7,`t`=-0.3,`h`=65,`rssi`=223,`ccid`='4600485905031430000099m9990000000032000000g2720,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673201043 WHERE `imei` = '868922055644013' [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010508s ] [ 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' , '230109' , '020301' , -0.228 , 0.001 , 0 , -0.017 , 5.7 , -0.3 , 65 , 223 , '4600485905031430000099m9990000000032000000g2720,N,00E000=-00.000' , 0 , 0 , 1673201043 , 1673201043) [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2023-01-09T02:04:04+08:00 ] 39.144.6.213 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230109&time=020301&v1=-00.145&v2=+00.004&v3=-00.014&v4=+00.189&v5=06.0&t=-00.9&h=61.6&rssi=+229&ccid=4600485905031420000099m9990000010006000001g0170,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011415s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230109',`time`='020301',`v1`=-0.145,`v2`=0.004,`v3`=-0.014,`v4`=0.189,`v5`=6,`t`=-0.9,`h`=61.6,`rssi`=229,`ccid`='4600485905031420000099m9990000010006000001g0170,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673201044 WHERE `imei` = '868922055643643' [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010010s ] [ 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' , '230109' , '020301' , -0.145 , 0.004 , -0.014 , 0.189 , 6 , -0.9 , 61.6 , 229 , '4600485905031420000099m9990000010006000001g0170,N,00E000=-00.000' , 0 , 0 , 1673201044 , 1673201044) [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2023-01-09T14:03:55+08:00 ] 117.132.195.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002127s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012063s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2023-01-09T14:03:56+08:00 ] 39.144.7.164 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010009s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2023-01-09T14:04:03+08:00 ] 117.132.195.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230109&time=140301&v1=-00.224&v2=+00.001&v3=+00.019&v4=-00.017&v5=05.9&t=+08.6&h=64.8&rssi=+225&ccid=4600485905031430000099m9990000000037000000g2710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002015s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230109',`time`='140301',`v1`=-0.224,`v2`=0.001,`v3`=0.019,`v4`=-0.017,`v5`=5.9,`t`=8.6,`h`=64.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g2710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673244243 WHERE `imei` = '868922055644013' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012041s ] [ 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' , '230109' , '140301' , -0.224 , 0.001 , 0.019 , -0.017 , 5.9 , 8.6 , 64.8 , 225 , '4600485905031430000099m9990000000037000000g2710,N,00E000=-00.000' , 0 , 0 , 1673244243 , 1673244243) [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-01-09T14:04:04+08:00 ] 39.144.7.164 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230109&time=140301&v1=-00.135&v2=+00.008&v3=-00.010&v4=+00.182&v5=06.0&t=+06.7&h=60.5&rssi=+231&ccid=4600485905031420000099m9990000010018000001g0290,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002411s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009242s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230109',`time`='140301',`v1`=-0.135,`v2`=0.008,`v3`=-0.01,`v4`=0.182,`v5`=6,`t`=6.7,`h`=60.5,`rssi`=231,`ccid`='4600485905031420000099m9990000010018000001g0290,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673244244 WHERE `imei` = '868922055643643' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010293s ] [ 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' , '230109' , '140301' , -0.135 , 0.008 , -0.01 , 0.182 , 6 , 6.7 , 60.5 , 231 , '4600485905031420000099m9990000010018000001g0290,N,00E000=-00.000' , 0 , 0 , 1673244244 , 1673244244) [ RunTime:0.000570s ]