--------------------------------------------------------------- [ 2024-03-29T01:45:34+08:00 ] 117.132.197.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002350s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013350s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000784s ] --------------------------------------------------------------- [ 2024-03-29T01:45:43+08:00 ] 117.132.197.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=240329&time=014501&v1=-01.262&v2=+00.038&v3=-00.775&v4=-00.037&v5=05.7&t=+11.6&h=67.8&rssi=+227&ccid=4600485905031420000099m9990000000483000001g2710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001980s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='240329',`time`='014501',`v1`=-1.262,`v2`=0.038,`v3`=-0.775,`v4`=-0.037,`v5`=5.7,`t`=11.6,`h`=67.8,`rssi`=227,`ccid`='4600485905031420000099m9990000000483000001g2710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711647943 WHERE `imei` = '868922055643643' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013395s ] [ 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' , '240329' , '014501' , -1.262 , 0.038 , -0.775 , -0.037 , 5.7 , 11.6 , 67.8 , 227 , '4600485905031420000099m9990000000483000001g2710,N,00E000=-00.000' , 0 , 0 , 1711647943 , 1711647943) [ RunTime:0.001404s ] --------------------------------------------------------------- [ 2024-03-29T01:57:51+08:00 ] 39.144.112.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011663s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2024-03-29T01:58:00+08:00 ] 39.144.112.46 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240329&time=015701&v1=-00.076&v2=+00.001&v3=+00.006&v4=-00.004&v5=04.8&t=+12.4&h=71.2&rssi=+222&ccid=4600485905031430000099m9990000000028000000g0740,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013106s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240329',`time`='015701',`v1`=-0.076,`v2`=0.001,`v3`=0.006,`v4`=-0.004,`v5`=4.8,`t`=12.4,`h`=71.2,`rssi`=222,`ccid`='4600485905031430000099m9990000000028000000g0740,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711648680 WHERE `imei` = '868922055644013' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010526s ] [ 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' , '240329' , '015701' , -0.076 , 0.001 , 0.006 , -0.004 , 4.8 , 12.4 , 71.2 , 222 , '4600485905031430000099m9990000000028000000g0740,N,00E000=-00.000' , 0 , 0 , 1711648680 , 1711648680) [ RunTime:0.000568s ] --------------------------------------------------------------- [ 2024-03-29T08:36:23+08:00 ] 221.178.124.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011770s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2024-03-29T08:36:25+08:00 ] 221.178.124.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711672583&v1=-2.889543&v2=0.566052&v3=-0.949124&v4=-0.672171&v5=6.300000&t=16.556778&h=77.297729&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428502,36.323069&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011944s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711672583,`v1`=-2.889543,`v2`=0.566052,`v3`=-0.949124,`v4`=-0.672171,`v5`=6.3,`t`=16.556778,`h`=77.297729,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428502,36.323069',`update_time`=1711672585 WHERE `imei` = '868922055684209' [ RunTime:0.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011280s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1711672583 , -2.889543 , 0.566052 , -0.949124 , -0.672171 , 6.3 , 16.556778 , 77.297729 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428502,36.323069' , 1711672585) [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2024-03-29T09:00:05+08:00 ] 111.55.136.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002742s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012159s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2024-03-29T09:00:07+08:00 ] 111.55.136.215 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711674005&v1=-1.180566&v2=0.068620&v3=-1.051766&v4=-0.517515&v5=6.300000&t=15.655869&h=76.519531&rssi=27&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010098s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711674005,`v1`=-1.180566,`v2`=0.06862,`v3`=-1.051766,`v4`=-0.517515,`v5`=6.3,`t`=15.655869,`h`=76.519531,`rssi`=27,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711674007 WHERE `imei` = '868922055644021' [ RunTime:0.000885s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013315s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711674005 , -1.180566 , 0.06862 , -1.051766 , -0.517515 , 6.3 , 15.655869 , 76.519531 , 27 , '898604650119C1053141' , '460048590503141' , -0 , 1711674007) [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2024-03-29T09:00:08+08:00 ] 111.55.136.215 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711630561&v1=-1.185081&v2=0.048794&v3=-1.053151&v4=-0.517335&v5=6.660000&t=13.017495&h=78.541321&rssi=27&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011121s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711630561,`v1`=-1.185081,`v2`=0.048794,`v3`=-1.053151,`v4`=-0.517335,`v5`=6.66,`t`=13.017495,`h`=78.541321,`rssi`=27,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711674008 WHERE `imei` = '868922055644021' [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012024s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711630561 , -1.185081 , 0.048794 , -1.053151 , -0.517335 , 6.66 , 13.017495 , 78.541321 , 27 , '898604650119C1053141' , '460048590503141' , -0 , 1711674008) [ RunTime:0.000538s ] --------------------------------------------------------------- [ 2024-03-29T20:37:59+08:00 ] 39.144.14.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.005285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016364s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001710s ] --------------------------------------------------------------- [ 2024-03-29T20:38:01+08:00 ] 39.144.14.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711715879&v1=-1.203623&v2=0.586102&v3=-0.898014&v4=-0.755910&v5=6.120000&t=11.365830&h=79.426331&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427635,36.322900&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011731s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000840s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711715879,`v1`=-1.203623,`v2`=0.586102,`v3`=-0.898014,`v4`=-0.75591,`v5`=6.12,`t`=11.36583,`h`=79.426331,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427635,36.322900',`update_time`=1711715881 WHERE `imei` = '868922055684209' [ RunTime:0.000868s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026391s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1711715879 , -1.203623 , 0.586102 , -0.898014 , -0.75591 , 6.12 , 11.36583 , 79.426331 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.427635,36.322900' , 1711715881) [ RunTime:0.003066s ] --------------------------------------------------------------- [ 2024-03-29T21:02:10+08:00 ] 39.144.12.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001388s ] --------------------------------------------------------------- [ 2024-03-29T21:02:11+08:00 ] 39.144.12.118 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711717330&v1=-1.183576&v2=0.055147&v3=-1.050171&v4=-0.513121&v5=6.300000&t=10.808125&h=79.334778&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711717330,`v1`=-1.183576,`v2`=0.055147,`v3`=-1.050171,`v4`=-0.513121,`v5`=6.3,`t`=10.808125,`h`=79.334778,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711717331 WHERE `imei` = '868922055644021' [ RunTime:0.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012082s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711717330 , -1.183576 , 0.055147 , -1.050171 , -0.513121 , 6.3 , 10.808125 , 79.334778 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1711717331) [ RunTime:0.000618s ]