--------------------------------------------------------------- [ 2023-03-03T02:03:55+08:00 ] 39.144.3.207 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002078s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013328s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2023-03-03T02:03:55+08:00 ] 218.204.253.220 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001950s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-03-03T02:04:04+08:00 ] 39.144.3.207 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230303&time=020301&v1=-01.276&v2=+00.031&v3=-00.941&v4=-00.024&v5=05.6&t=+02.0&h=62.3&rssi=+229&ccid=4600485905031420000099m9990000000318000001g2890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001859s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009843s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230303',`time`='020301',`v1`=-1.276,`v2`=0.031,`v3`=-0.941,`v4`=-0.024,`v5`=5.6,`t`=2,`h`=62.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000318000001g2890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677780244 WHERE `imei` = '868922055643643' [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010776s ] [ 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' , '230303' , '020301' , -1.276 , 0.031 , -0.941 , -0.024 , 5.6 , 2 , 62.3 , 229 , '4600485905031420000099m9990000000318000001g2890,N,00E000=-00.000' , 0 , 0 , 1677780244 , 1677780244) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-03-03T02:04:04+08:00 ] 218.204.253.220 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230303&time=020301&v1=-00.241&v2=+00.001&v3=-00.011&v4=-00.018&v5=05.7&t=+04.4&h=65.1&rssi=+225&ccid=4600485905031430000099m9990000000028000000g2820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009221s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230303',`time`='020301',`v1`=-0.241,`v2`=0.001,`v3`=-0.011,`v4`=-0.018,`v5`=5.7,`t`=4.4,`h`=65.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000028000000g2820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677780244 WHERE `imei` = '868922055644013' [ RunTime:0.000550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011271s ] [ 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' , '230303' , '020301' , -0.241 , 0.001 , -0.011 , -0.018 , 5.7 , 4.4 , 65.1 , 225 , '4600485905031430000099m9990000000028000000g2820,N,00E000=-00.000' , 0 , 0 , 1677780244 , 1677780244) [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-03-03T06:09:52+08:00 ] 39.144.16.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002912s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012010s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001126s ] --------------------------------------------------------------- [ 2023-03-03T06:09:59+08:00 ] 39.144.16.112 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230303&time=060901&v1=-01.267&v2=+00.021&v3=-00.995&v4=-00.618&v5=05.7&t=+03.4&h=80.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.298&a2=01.282&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009295s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230303',`time`='060901',`v1`=-1.267,`v2`=0.021,`v3`=-0.995,`v4`=-0.618,`v5`=5.7,`t`=3.4,`h`=80.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.298,`a2`=1.282,`update_time`=1677794999 WHERE `imei` = '868922055684076' [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011702s ] [ 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' , '230303' , '060901' , -1.267 , 0.021 , -0.995 , -0.618 , 5.7 , 3.4 , 80.9 , 228 , '460044618415249' , -0 , 0.298 , 1.282 , 1677794999 , 1677794999) [ RunTime:0.001257s ] --------------------------------------------------------------- [ 2023-03-03T14:03:55+08:00 ] 39.144.11.169 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011137s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2023-03-03T14:03:55+08:00 ] 111.55.138.246 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-03-03T14:04:03+08:00 ] 39.144.11.169 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230303&time=140301&v1=-00.231&v2=+00.001&v3=+00.020&v4=-00.017&v5=06.0&t=+18.9&h=64.5&rssi=+223&ccid=4600485905031430000099m9990000000039000000g2690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001547s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008912s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230303',`time`='140301',`v1`=-0.231,`v2`=0.001,`v3`=0.02,`v4`=-0.017,`v5`=6,`t`=18.9,`h`=64.5,`rssi`=223,`ccid`='4600485905031430000099m9990000000039000000g2690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677823443 WHERE `imei` = '868922055644013' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009783s ] [ 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' , '230303' , '140301' , -0.231 , 0.001 , 0.02 , -0.017 , 6 , 18.9 , 64.5 , 223 , '4600485905031430000099m9990000000039000000g2690,N,00E000=-00.000' , 0 , 0 , 1677823443 , 1677823443) [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-03-03T14:04:03+08:00 ] 111.55.138.246 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230303&time=140301&v1=-01.273&v2=+00.067&v3=-00.936&v4=-00.023&v5=05.7&t=+17.0&h=60.5&rssi=+231&ccid=4600485905031420000099m9990000000317000001g2850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230303',`time`='140301',`v1`=-1.273,`v2`=0.067,`v3`=-0.936,`v4`=-0.023,`v5`=5.7,`t`=17,`h`=60.5,`rssi`=231,`ccid`='4600485905031420000099m9990000000317000001g2850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677823443 WHERE `imei` = '868922055643643' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010162s ] [ 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' , '230303' , '140301' , -1.273 , 0.067 , -0.936 , -0.023 , 5.7 , 17 , 60.5 , 231 , '4600485905031420000099m9990000000317000001g2850,N,00E000=-00.000' , 0 , 0 , 1677823443 , 1677823443) [ RunTime:0.000515s ]