--------------------------------------------------------------- [ 2023-01-12T02:02:51+08:00 ] 39.144.13.77 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-01-12T02:02:59+08:00 ] 39.144.13.77 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230112&time=020201&v1=-01.260&v2=+00.015&v3=-01.098&v4=-00.680&v5=05.9&t=+07.2&h=80.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.190&a2=01.275&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230112',`time`='020201',`v1`=-1.26,`v2`=0.015,`v3`=-1.098,`v4`=-0.68,`v5`=5.9,`t`=7.2,`h`=80.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.19,`a2`=1.275,`update_time`=1673460179 WHERE `imei` = '868922055684076' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010144s ] [ 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' , '230112' , '020201' , -1.26 , 0.015 , -1.098 , -0.68 , 5.9 , 7.2 , 80.8 , 228 , '460044618415249' , -0 , 0.19 , 1.275 , 1673460179 , 1673460179) [ RunTime:0.001332s ] --------------------------------------------------------------- [ 2023-01-12T02:03:55+08:00 ] 39.144.15.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009819s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-01-12T02:03:55+08:00 ] 39.144.6.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009640s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-01-12T02:04:03+08:00 ] 39.144.15.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230112&time=020301&v1=-00.251&v2=+00.001&v3=-00.138&v4=-00.013&v5=05.9&t=+07.6&h=64.1&rssi=+225&ccid=4600485905031430000099m9990000000005000000g2800,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230112',`time`='020301',`v1`=-0.251,`v2`=0.001,`v3`=-0.138,`v4`=-0.013,`v5`=5.9,`t`=7.6,`h`=64.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000005000000g2800,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673460243 WHERE `imei` = '868922055644013' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011068s ] [ 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' , '230112' , '020301' , -0.251 , 0.001 , -0.138 , -0.013 , 5.9 , 7.6 , 64.1 , 225 , '4600485905031430000099m9990000000005000000g2800,N,00E000=-00.000' , 0 , 0 , 1673460243 , 1673460243) [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-01-12T02:04:04+08:00 ] 39.144.6.116 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230112&time=020301&v1=-01.263&v2=+00.030&v3=-01.017&v4=-00.049&v5=05.7&t=+06.3&h=61.0&rssi=+229&ccid=4600485905031420000099m9990000000223000001g2770,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002018s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230112',`time`='020301',`v1`=-1.263,`v2`=0.03,`v3`=-1.017,`v4`=-0.049,`v5`=5.7,`t`=6.3,`h`=61,`rssi`=229,`ccid`='4600485905031420000099m9990000000223000001g2770,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673460244 WHERE `imei` = '868922055643643' [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010613s ] [ 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' , '230112' , '020301' , -1.263 , 0.03 , -1.017 , -0.049 , 5.7 , 6.3 , 61 , 229 , '4600485905031420000099m9990000000223000001g2770,N,00E000=-00.000' , 0 , 0 , 1673460244 , 1673460244) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-01-12T14:03:54+08:00 ] 39.144.7.168 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-01-12T14:03:55+08:00 ] 39.144.4.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001806s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011796s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2023-01-12T14:04:03+08:00 ] 39.144.7.168 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230112&time=140301&v1=-00.248&v2=+00.001&v3=-00.142&v4=-00.014&v5=05.9&t=+11.6&h=64.1&rssi=+224&ccid=4600485905031430000099m9990000000014000000g2810,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000952s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230112',`time`='140301',`v1`=-0.248,`v2`=0.001,`v3`=-0.142,`v4`=-0.014,`v5`=5.9,`t`=11.6,`h`=64.1,`rssi`=224,`ccid`='4600485905031430000099m9990000000014000000g2810,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673503443 WHERE `imei` = '868922055644013' [ RunTime:0.000865s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015789s ] [ 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' , '230112' , '140301' , -0.248 , 0.001 , -0.142 , -0.014 , 5.9 , 11.6 , 64.1 , 224 , '4600485905031430000099m9990000000014000000g2810,N,00E000=-00.000' , 0 , 0 , 1673503443 , 1673503443) [ RunTime:0.001022s ] --------------------------------------------------------------- [ 2023-01-12T14:04:04+08:00 ] 39.144.4.1 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230112&time=140301&v1=-01.261&v2=+00.065&v3=-00.998&v4=-00.046&v5=05.7&t=+11.7&h=60.9&rssi=+228&ccid=4600485905031420000099m9990000000239000001g2760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230112',`time`='140301',`v1`=-1.261,`v2`=0.065,`v3`=-0.998,`v4`=-0.046,`v5`=5.7,`t`=11.7,`h`=60.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000239000001g2760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1673503444 WHERE `imei` = '868922055643643' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011547s ] [ 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' , '230112' , '140301' , -1.261 , 0.065 , -0.998 , -0.046 , 5.7 , 11.7 , 60.9 , 228 , '4600485905031420000099m9990000000239000001g2760,N,00E000=-00.000' , 0 , 0 , 1673503444 , 1673503444) [ RunTime:0.000563s ]