--------------------------------------------------------------- [ 2024-03-23T01:57:52+08:00 ] 39.144.112.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.004076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013749s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2024-03-23T01:58:00+08:00 ] 39.144.112.42 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240323&time=015701&v1=-00.078&v2=+00.001&v3=+00.009&v4=-00.007&v5=05.7&t=+06.3&h=72.6&rssi=+222&ccid=4600485905031430000099m9990000000030000000g0760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240323',`time`='015701',`v1`=-0.078,`v2`=0.001,`v3`=0.009,`v4`=-0.007,`v5`=5.7,`t`=6.3,`h`=72.6,`rssi`=222,`ccid`='4600485905031430000099m9990000000030000000g0760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711130280 WHERE `imei` = '868922055644013' [ RunTime:0.000987s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010786s ] [ 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' , '240323' , '015701' , -0.078 , 0.001 , 0.009 , -0.007 , 5.7 , 6.3 , 72.6 , 222 , '4600485905031430000099m9990000000030000000g0760,N,00E000=-00.000' , 0 , 0 , 1711130280 , 1711130280) [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2024-03-23T08:24:26+08:00 ] 39.144.112.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015008s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001692s ] --------------------------------------------------------------- [ 2024-03-23T08:24:28+08:00 ] 39.144.112.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711153466&v1=-0.895756&v2=0.493260&v3=-0.939552&v4=-0.781556&v5=6.300000&t=13.285623&h=77.465576&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428503,36.323164&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002575s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015653s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001336s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711153466,`v1`=-0.895756,`v2`=0.49326,`v3`=-0.939552,`v4`=-0.781556,`v5`=6.3,`t`=13.285623,`h`=77.465576,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428503,36.323164',`update_time`=1711153468 WHERE `imei` = '868922055684209' [ RunTime:0.001155s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019867s ] [ 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' , 1711153466 , -0.895756 , 0.49326 , -0.939552 , -0.781556 , 6.3 , 13.285623 , 77.465576 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428503,36.323164' , 1711153468) [ RunTime:0.001810s ] --------------------------------------------------------------- [ 2024-03-23T08:36:09+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013429s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2024-03-23T08:36:10+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711154169&v1=-1.182131&v2=0.057978&v3=-1.043218&v4=-0.525582&v5=6.300000&t=9.907217&h=77.129883&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011913s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711154169,`v1`=-1.182131,`v2`=0.057978,`v3`=-1.043218,`v4`=-0.525582,`v5`=6.3,`t`=9.907217,`h`=77.129883,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711154170 WHERE `imei` = '868922055644021' [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018691s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711154169 , -1.182131 , 0.057978 , -1.043218 , -0.525582 , 6.3 , 9.907217 , 77.129883 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1711154170) [ RunTime:0.001244s ] --------------------------------------------------------------- [ 2024-03-23T20:24:58+08:00 ] 39.144.112.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.005470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001307s ] --------------------------------------------------------------- [ 2024-03-23T20:25:00+08:00 ] 39.144.112.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711196698&v1=-0.655616&v2=0.553867&v3=-0.880977&v4=-0.754766&v5=6.480000&t=10.765224&h=79.166931&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427961,36.322969&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013105s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711196698,`v1`=-0.655616,`v2`=0.553867,`v3`=-0.880977,`v4`=-0.754766,`v5`=6.48,`t`=10.765224,`h`=79.166931,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427961,36.322969',`update_time`=1711196700 WHERE `imei` = '868922055684209' [ RunTime:0.000892s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020104s ] [ 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' , 1711196698 , -0.655616 , 0.553867 , -0.880977 , -0.754766 , 6.48 , 10.765224 , 79.166931 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.427961,36.322969' , 1711196700) [ RunTime:0.004572s ] --------------------------------------------------------------- [ 2024-03-23T20:38:08+08:00 ] 111.55.141.194 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001545s ] --------------------------------------------------------------- [ 2024-03-23T20:38:10+08:00 ] 111.55.141.194 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711197488&v1=-1.178158&v2=0.050848&v3=-1.047402&v4=-0.521549&v5=6.300000&t=10.743774&h=79.029602&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002179s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711197488,`v1`=-1.178158,`v2`=0.050848,`v3`=-1.047402,`v4`=-0.521549,`v5`=6.3,`t`=10.743774,`h`=79.029602,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711197490 WHERE `imei` = '868922055644021' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012008s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711197488 , -1.178158 , 0.050848 , -1.047402 , -0.521549 , 6.3 , 10.743774 , 79.029602 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1711197490) [ RunTime:0.001140s ]