--------------------------------------------------------------- [ 2024-03-22T01:57:51+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003619s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014311s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001477s ] --------------------------------------------------------------- [ 2024-03-22T01:58:00+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240322&time=015701&v1=-00.081&v2=+00.001&v3=+00.005&v4=-00.007&v5=05.7&t=+09.6&h=70.8&rssi=+221&ccid=4600485905031430000099m9990000000029000000g0790,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012070s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240322',`time`='015701',`v1`=-0.081,`v2`=0.001,`v3`=0.005,`v4`=-0.007,`v5`=5.7,`t`=9.6,`h`=70.8,`rssi`=221,`ccid`='4600485905031430000099m9990000000029000000g0790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1711043880 WHERE `imei` = '868922055644013' [ RunTime:0.001337s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014212s ] [ 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' , '240322' , '015701' , -0.081 , 0.001 , 0.005 , -0.007 , 5.7 , 9.6 , 70.8 , 221 , '4600485905031430000099m9990000000029000000g0790,N,00E000=-00.000' , 0 , 0 , 1711043880 , 1711043880) [ RunTime:0.008974s ] --------------------------------------------------------------- [ 2024-03-22T08:22:00+08:00 ] 117.132.197.105 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.003255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.041018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001880s ] --------------------------------------------------------------- [ 2024-03-22T08:22:01+08:00 ] 117.132.197.105 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711066920&v1=1.153716&v2=0.642920&v3=-1.037168&v4=-0.783061&v5=6.300000&t=13.875503&h=77.633423&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427024,36.322975&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001944s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012640s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000832s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711066920,`v1`=1.153716,`v2`=0.64292,`v3`=-1.037168,`v4`=-0.783061,`v5`=6.3,`t`=13.875503,`h`=77.633423,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427024,36.322975',`update_time`=1711066921 WHERE `imei` = '868922055684209' [ RunTime:0.000968s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023763s ] [ 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' , 1711066920 , 1.153716 , 0.64292 , -1.037168 , -0.783061 , 6.3 , 13.875503 , 77.633423 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.427024,36.322975' , 1711066921) [ RunTime:0.003715s ] --------------------------------------------------------------- [ 2024-03-22T08:32:09+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013096s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001483s ] --------------------------------------------------------------- [ 2024-03-22T08:32:10+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711067529&v1=-1.174245&v2=0.052817&v3=-1.036445&v4=-0.514746&v5=6.300000&t=12.942419&h=76.931519&rssi=22&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002237s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013057s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000824s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711067529,`v1`=-1.174245,`v2`=0.052817,`v3`=-1.036445,`v4`=-0.514746,`v5`=6.3,`t`=12.942419,`h`=76.931519,`rssi`=22,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1711067530 WHERE `imei` = '868922055644021' [ RunTime:0.000833s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009710s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1711067529 , -1.174245 , 0.052817 , -1.036445 , -0.514746 , 6.3 , 12.942419 , 76.931519 , 22 , '898604650119C1053141' , '460048590503141' , -0 , 1711067530) [ RunTime:0.001136s ] --------------------------------------------------------------- [ 2024-03-22T20:23:01+08:00 ] 111.55.138.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013439s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002040s ] --------------------------------------------------------------- [ 2024-03-22T20:23:10+08:00 ] 111.55.138.247 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=240322&time=202401&v1=-00.960&v2=+00.011&v3=-00.827&v4=-00.288&v5=05.7&t=+12.1&h=82.5&rssi=+223&imsi=460044618415249&v6=-00.000&a1=00.176&a2=01.058&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013587s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='240322',`time`='202401',`v1`=-0.96,`v2`=0.011,`v3`=-0.827,`v4`=-0.288,`v5`=5.7,`t`=12.1,`h`=82.5,`rssi`=223,`imsi`='460044618415249',`v6`=-0,`a1`=0.176,`a2`=1.058,`update_time`=1711110190 WHERE `imei` = '868922055684076' [ RunTime:0.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012237s ] [ 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' , '240322' , '202401' , -0.96 , 0.011 , -0.827 , -0.288 , 5.7 , 12.1 , 82.5 , 223 , '460044618415249' , -0 , 0.176 , 1.058 , 1711110190 , 1711110190) [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2024-03-22T20:23:21+08:00 ] 39.144.16.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014729s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000790s ] --------------------------------------------------------------- [ 2024-03-22T20:23:22+08:00 ] 39.144.16.174 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1711110201&v1=-1.916820&v2=0.481661&v3=-1.093877&v4=-0.810271&v5=6.480000&t=11.097703&h=79.937500&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428341,36.322649&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002005s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011429s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1711110201,`v1`=-1.91682,`v2`=0.481661,`v3`=-1.093877,`v4`=-0.810271,`v5`=6.48,`t`=11.097703,`h`=79.9375,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428341,36.322649',`update_time`=1711110202 WHERE `imei` = '868922055684209' [ RunTime:0.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011677s ] [ 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' , 1711110201 , -1.91682 , 0.481661 , -1.093877 , -0.810271 , 6.48 , 11.097703 , 79.9375 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428341,36.322649' , 1711110202) [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2024-03-22T20:34:03+08:00 ] 39.144.112.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011751s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001144s ] --------------------------------------------------------------- [ 2024-03-22T20:34:04+08:00 ] 39.144.112.42 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1711110843&v1=-1.170091&v2=0.054094&v3=-1.038974&v4=-0.518840&v5=6.300000&t=10.690149&h=79.830688&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&gps=120.422351,36.325480&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002125s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011929s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000812s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1711110843,`v1`=-1.170091,`v2`=0.054094,`v3`=-1.038974,`v4`=-0.51884,`v5`=6.3,`t`=10.690149,`h`=79.830688,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`gps`='120.422351,36.325480',`update_time`=1711110844 WHERE `imei` = '868922055644021' [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012481s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055644021' , 1711110843 , -1.170091 , 0.054094 , -1.038974 , -0.51884 , 6.3 , 10.690149 , 79.830688 , 23 , '898604650119C1053141' , '460048590503141' , -0 , '120.422351,36.325480' , 1711110844) [ RunTime:0.000548s ]