--------------------------------------------------------------- [ 2023-04-10T02:03:54+08:00 ] 111.55.141.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002858s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001318s ] --------------------------------------------------------------- [ 2023-04-10T02:03:55+08:00 ] 221.178.127.143 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.011301s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-04-10T02:04:02+08:00 ] 111.55.141.8 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230410&time=020301&v1=-01.328&v2=+00.013&v3=-01.003&v4=-00.023&v5=06.2&t=+13.4&h=61.4&rssi=+229&ccid=4600485905031420000099m9990000000325000001g3380,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230410',`time`='020301',`v1`=-1.328,`v2`=0.013,`v3`=-1.003,`v4`=-0.023,`v5`=6.2,`t`=13.4,`h`=61.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000325000001g3380,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681063442 WHERE `imei` = '868922055643643' [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011660s ] [ 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' , '230410' , '020301' , -1.328 , 0.013 , -1.003 , -0.023 , 6.2 , 13.4 , 61.4 , 229 , '4600485905031420000099m9990000000325000001g3380,N,00E000=-00.000' , 0 , 0 , 1681063442 , 1681063442) [ RunTime:0.001255s ] --------------------------------------------------------------- [ 2023-04-10T02:04:03+08:00 ] 221.178.127.143 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230410&time=020301&v1=-00.218&v2=+00.001&v3=+00.140&v4=-00.020&v5=05.9&t=+14.5&h=64.2&rssi=+225&ccid=4600485905031430000099m9990000000255000000g2590,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002008s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230410',`time`='020301',`v1`=-0.218,`v2`=0.001,`v3`=0.14,`v4`=-0.02,`v5`=5.9,`t`=14.5,`h`=64.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000255000000g2590,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681063443 WHERE `imei` = '868922055644013' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010581s ] [ 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' , '230410' , '020301' , -0.218 , 0.001 , 0.14 , -0.02 , 5.9 , 14.5 , 64.2 , 225 , '4600485905031430000099m9990000000255000000g2590,N,00E000=-00.000' , 0 , 0 , 1681063443 , 1681063443) [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-04-10T10:09:50+08:00 ] 39.144.6.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002927s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012828s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2023-04-10T10:09:58+08:00 ] 39.144.6.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230410&time=100901&v1=-01.263&v2=+00.021&v3=-00.993&v4=-00.381&v5=06.0&t=+28.3&h=78.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.258&a2=01.281&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009630s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230410',`time`='100901',`v1`=-1.263,`v2`=0.021,`v3`=-0.993,`v4`=-0.381,`v5`=6,`t`=28.3,`h`=78.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.258,`a2`=1.281,`update_time`=1681092598 WHERE `imei` = '868922055684076' [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012105s ] [ 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' , '230410' , '100901' , -1.263 , 0.021 , -0.993 , -0.381 , 6 , 28.3 , 78.1 , 228 , '460044618415249' , -0 , 0.258 , 1.281 , 1681092598 , 1681092598) [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-04-10T14:03:54+08:00 ] 111.55.136.194 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-04-10T14:03:55+08:00 ] 223.104.255.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009627s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-04-10T14:04:03+08:00 ] 111.55.136.194 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230410&time=140301&v1=-00.152&v2=+00.001&v3=+00.162&v4=-00.018&v5=06.0&t=+29.3&h=62.7&rssi=+227&ccid=4600485905031430000099m9990000000236000000g1830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230410',`time`='140301',`v1`=-0.152,`v2`=0.001,`v3`=0.162,`v4`=-0.018,`v5`=6,`t`=29.3,`h`=62.7,`rssi`=227,`ccid`='4600485905031430000099m9990000000236000000g1830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681106643 WHERE `imei` = '868922055644013' [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010100s ] [ 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' , '230410' , '140301' , -0.152 , 0.001 , 0.162 , -0.018 , 6 , 29.3 , 62.7 , 227 , '4600485905031430000099m9990000000236000000g1830,N,00E000=-00.000' , 0 , 0 , 1681106643 , 1681106643) [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-04-10T14:04:03+08:00 ] 223.104.255.244 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230410&time=140301&v1=-01.336&v2=+00.034&v3=-01.012&v4=-00.020&v5=05.9&t=+26.9&h=59.0&rssi=+229&ccid=4600485905031420000099m9990000000321000001g3450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010301s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230410',`time`='140301',`v1`=-1.336,`v2`=0.034,`v3`=-1.012,`v4`=-0.02,`v5`=5.9,`t`=26.9,`h`=59,`rssi`=229,`ccid`='4600485905031420000099m9990000000321000001g3450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681106643 WHERE `imei` = '868922055643643' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011359s ] [ 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' , '230410' , '140301' , -1.336 , 0.034 , -1.012 , -0.02 , 5.9 , 26.9 , 59 , 229 , '4600485905031420000099m9990000000321000001g3450,N,00E000=-00.000' , 0 , 0 , 1681106643 , 1681106643) [ RunTime:0.000540s ]