--------------------------------------------------------------- [ 2023-06-24T00:05:23+08:00 ] 39.144.2.218 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002247s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013441s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-06-24T00:05:24+08:00 ] 39.144.2.218 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1687536323&v1=0.008458&v2=0.015333&v3=0.005809&v4=-0.015682&v5=12.420000&t=29.148043&h=80.791992&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011270s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1687536323,`v1`=0.008458,`v2`=0.015333,`v3`=0.005809,`v4`=-0.015682,`v5`=12.42,`t`=29.148043,`h`=80.791992,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1687536324 WHERE `imei` = '868922055644021' [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010351s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1687536323 , 0.008458 , 0.015333 , 0.005809 , -0.015682 , 12.42 , 29.148043 , 80.791992 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1687536324) [ RunTime:0.000988s ] --------------------------------------------------------------- [ 2023-06-24T00:24:59+08:00 ] 39.144.13.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ 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.011537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-06-24T00:25:01+08:00 ] 39.144.13.29 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1687537499&v1=0.021582&v2=0.013977&v3=0.018993&v4=-0.006231&v5=12.240000&t=29.062241&h=78.449768&rssi=28&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.184330,35.982409&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1687537499,`v1`=0.021582,`v2`=0.013977,`v3`=0.018993,`v4`=-0.006231,`v5`=12.24,`t`=29.062241,`h`=78.449768,`rssi`=28,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.184330,35.982409',`update_time`=1687537501 WHERE `imei` = '868922055680850' [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010645s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1687537499 , 0.021582 , 0.013977 , 0.018993 , -0.006231 , 12.24 , 29.062241 , 78.449768 , 28 , '898604650119C1078510' , '460048590708510' , -0 , '120.184330,35.982409' , 1687537501) [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2023-06-24T02:03:54+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002498s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2023-06-24T02:03:55+08:00 ] 39.144.3.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010320s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-06-24T02:04:03+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230624&time=020301&v1=-01.380&v2=+00.014&v3=-00.939&v4=-00.045&v5=06.2&t=+24.9&h=59.7&rssi=+227&ccid=4600485905031420000099m9990000000453000001g3880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011110s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230624',`time`='020301',`v1`=-1.38,`v2`=0.014,`v3`=-0.939,`v4`=-0.045,`v5`=6.2,`t`=24.9,`h`=59.7,`rssi`=227,`ccid`='4600485905031420000099m9990000000453000001g3880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687543443 WHERE `imei` = '868922055643643' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012151s ] [ 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' , '230624' , '020301' , -1.38 , 0.014 , -0.939 , -0.045 , 6.2 , 24.9 , 59.7 , 227 , '4600485905031420000099m9990000000453000001g3880,N,00E000=-00.000' , 0 , 0 , 1687543443 , 1687543443) [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2023-06-24T02:04:03+08:00 ] 39.144.3.199 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230624&time=020301&v1=-00.439&v2=+00.001&v3=-00.094&v4=+00.001&v5=06.0&t=+25.2&h=63.5&rssi=+221&ccid=4600485905031430000099m9990000000031000000g4580,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011012s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230624',`time`='020301',`v1`=-0.439,`v2`=0.001,`v3`=-0.094,`v4`=0.001,`v5`=6,`t`=25.2,`h`=63.5,`rssi`=221,`ccid`='4600485905031430000099m9990000000031000000g4580,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687543443 WHERE `imei` = '868922055644013' [ RunTime:0.000514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010532s ] [ 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' , '230624' , '020301' , -0.439 , 0.001 , -0.094 , 0.001 , 6 , 25.2 , 63.5 , 221 , '4600485905031430000099m9990000000031000000g4580,N,00E000=-00.000' , 0 , 0 , 1687543443 , 1687543443) [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-06-24T11:44:28+08:00 ] 39.144.14.220 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.004151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014050s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001288s ] --------------------------------------------------------------- [ 2023-06-24T11:44:29+08:00 ] 39.144.14.220 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1687578268&v1=0.029769&v2=0.013456&v3=0.036271&v4=0.001355&v5=12.240000&t=29.405445&h=78.953308&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001792s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011111s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1687578268,`v1`=0.029769,`v2`=0.013456,`v3`=0.036271,`v4`=0.001355,`v5`=12.24,`t`=29.405445,`h`=78.953308,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1687578269 WHERE `imei` = '868922055678110' [ RunTime:0.000786s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017164s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1687578268 , 0.029769 , 0.013456 , 0.036271 , 0.001355 , 12.24 , 29.405445 , 78.953308 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1687578269) [ RunTime:0.001305s ] --------------------------------------------------------------- [ 2023-06-24T14:03:54+08:00 ] 223.104.255.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001311s ] --------------------------------------------------------------- [ 2023-06-24T14:03:56+08:00 ] 39.144.16.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011708s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000988s ] --------------------------------------------------------------- [ 2023-06-24T14:04:03+08:00 ] 223.104.255.70 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230624&time=140301&v1=-01.379&v2=+00.017&v3=-00.957&v4=-00.045&v5=06.4&t=+40.8&h=54.2&rssi=+228&ccid=4600485905031420000099m9990000000428000001g3850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001960s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011641s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230624',`time`='140301',`v1`=-1.379,`v2`=0.017,`v3`=-0.957,`v4`=-0.045,`v5`=6.4,`t`=40.8,`h`=54.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000428000001g3850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687586643 WHERE `imei` = '868922055643643' [ RunTime:0.000914s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011653s ] [ 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' , '230624' , '140301' , -1.379 , 0.017 , -0.957 , -0.045 , 6.4 , 40.8 , 54.2 , 228 , '4600485905031420000099m9990000000428000001g3850,N,00E000=-00.000' , 0 , 0 , 1687586643 , 1687586643) [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-06-24T14:04:03+08:00 ] 39.144.16.209 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230624&time=140301&v1=-00.367&v2=+00.001&v3=+00.020&v4=+00.002&v5=06.2&t=+36.5&h=60.3&rssi=+223&ccid=4600485905031430000099m9990000000045000000g3890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011294s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230624',`time`='140301',`v1`=-0.367,`v2`=0.001,`v3`=0.02,`v4`=0.002,`v5`=6.2,`t`=36.5,`h`=60.3,`rssi`=223,`ccid`='4600485905031430000099m9990000000045000000g3890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1687586643 WHERE `imei` = '868922055644013' [ RunTime:0.000513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011134s ] [ 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' , '230624' , '140301' , -0.367 , 0.001 , 0.02 , 0.002 , 6.2 , 36.5 , 60.3 , 223 , '4600485905031430000099m9990000000045000000g3890,N,00E000=-00.000' , 0 , 0 , 1687586643 , 1687586643) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-06-24T15:11:23+08:00 ] 39.144.6.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014273s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2023-06-24T15:11:24+08:00 ] 39.144.6.143 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1687590683&v1=0.017067&v2=0.013769&v3=0.015472&v4=-0.011649&v5=12.420000&t=29.544870&h=77.900452&rssi=27&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010929s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1687590683,`v1`=0.017067,`v2`=0.013769,`v3`=0.015472,`v4`=-0.011649,`v5`=12.42,`t`=29.54487,`h`=77.900452,`rssi`=27,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1687590684 WHERE `imei` = '868922055684548' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011726s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1687590683 , 0.017067 , 0.013769 , 0.015472 , -0.011649 , 12.42 , 29.54487 , 77.900452 , 27 , '898604650119C1053137' , '460048590503137' , -0 , 1687590684) [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-06-24T17:22:02+08:00 ] 39.144.3.74 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002491s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011690s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2023-06-24T17:22:03+08:00 ] 39.144.3.74 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1687598522&v1=0.018391&v2=0.013873&v3=0.016465&v4=-0.000151&v5=12.420000&t=28.386560&h=78.976196&rssi=26&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185207,35.984950&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1687598522,`v1`=0.018391,`v2`=0.013873,`v3`=0.016465,`v4`=-0.000151,`v5`=12.42,`t`=28.38656,`h`=78.976196,`rssi`=26,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185207,35.984950',`update_time`=1687598523 WHERE `imei` = '868922055647586' [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011630s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1687598522 , 0.018391 , 0.013873 , 0.016465 , -0.000151 , 12.42 , 28.38656 , 78.976196 , 26 , '898604650119C1078512' , '460048590708512' , -0 , '120.185207,35.984950' , 1687598523) [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2023-06-24T18:03:23+08:00 ] 111.55.136.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002741s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-06-24T18:03:25+08:00 ] 111.55.136.5 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1687601003&v1=0.027482&v2=0.013456&v3=0.029017&v4=0.015622&v5=12.240000&t=28.472361&h=76.969666&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011290s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1687601003,`v1`=0.027482,`v2`=0.013456,`v3`=0.029017,`v4`=0.015622,`v5`=12.24,`t`=28.472361,`h`=76.969666,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1687601004 WHERE `imei` = '868922056976208' [ RunTime:0.001463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011789s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1687601003 , 0.027482 , 0.013456 , 0.029017 , 0.015622 , 12.24 , 28.472361 , 76.969666 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1687601005) [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2023-06-24T18:11:21+08:00 ] 221.178.125.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010741s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-06-24T18:11:23+08:00 ] 221.178.125.224 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1687601481&v1=0.021161&v2=0.013977&v3=0.017850&v4=-0.006712&v5=12.420000&t=28.515261&h=79.205078&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001933s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001037s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1687601481,`v1`=0.021161,`v2`=0.013977,`v3`=0.01785,`v4`=-0.006712,`v5`=12.42,`t`=28.515261,`h`=79.205078,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1687601483 WHERE `imei` = '868922055684209' [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011480s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1687601481 , 0.021161 , 0.013977 , 0.01785 , -0.006712 , 12.42 , 28.515261 , 79.205078 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1687601483) [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-06-24T18:36:19+08:00 ] 39.144.15.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002280s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013850s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2023-06-24T18:36:21+08:00 ] 39.144.15.70 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1687602979&v1=0.019234&v2=0.014395&v3=0.017428&v4=-0.004666&v5=12.420000&t=28.515261&h=83.843750&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011629s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1687602979,`v1`=0.019234,`v2`=0.014395,`v3`=0.017428,`v4`=-0.004666,`v5`=12.42,`t`=28.515261,`h`=83.84375,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1687602981 WHERE `imei` = '868922055683920' [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011375s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1687602979 , 0.019234 , 0.014395 , 0.017428 , -0.004666 , 12.42 , 28.515261 , 83.84375 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1687602981) [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-06-24T21:19:55+08:00 ] 221.178.127.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001023s ] --------------------------------------------------------------- [ 2023-06-24T21:19:57+08:00 ] 221.178.127.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1687612795&v1=0.032298&v2=0.012517&v3=0.029559&v4=0.007916&v5=12.420000&t=28.440186&h=82.226318&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185094,35.985397&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001901s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012087s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001015s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1687612795,`v1`=0.032298,`v2`=0.012517,`v3`=0.029559,`v4`=0.007916,`v5`=12.42,`t`=28.440186,`h`=82.226318,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185094,35.985397',`update_time`=1687612797 WHERE `imei` = '868922055683912' [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011093s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1687612795 , 0.032298 , 0.012517 , 0.029559 , 0.007916 , 12.42 , 28.440186 , 82.226318 , 30 , '898604650119C1053138' , '460048590503138' , -0 , '120.185094,35.985397' , 1687612797) [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-06-24T21:27:04+08:00 ] 111.55.140.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.003266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000806s ] --------------------------------------------------------------- [ 2023-06-24T21:27:05+08:00 ] 111.55.140.35 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687613224&v1=0.019776&v2=0.015020&v3=0.016585&v4=-0.017187&v5=12.240000&t=28.397285&h=83.202881&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185493,35.985846&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687613224,`v1`=0.019776,`v2`=0.01502,`v3`=0.016585,`v4`=-0.017187,`v5`=12.24,`t`=28.397285,`h`=83.202881,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185493,35.985846',`update_time`=1687613225 WHERE `imei` = '868922055683771' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010897s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1687613224 , 0.019776 , 0.01502 , 0.016585 , -0.017187 , 12.24 , 28.397285 , 83.202881 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.185493,35.985846' , 1687613225) [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2023-06-24T21:27:06+08:00 ] 111.55.140.35 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1687526758&v1=0.019836&v2=0.013143&v3=0.016435&v4=-0.017187&v5=12.420000&t=29.459070&h=82.966370&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011226s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1687526758,`v1`=0.019836,`v2`=0.013143,`v3`=0.016435,`v4`=-0.017187,`v5`=12.42,`t`=29.45907,`h`=82.96637,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1687613226 WHERE `imei` = '868922055683771' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011248s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1687526758 , 0.019836 , 0.013143 , 0.016435 , -0.017187 , 12.42 , 29.45907 , 82.96637 , 27 , '898604650119C1053136' , '460048590503136' , -0 , 1687613226) [ RunTime:0.000518s ] --------------------------------------------------------------- [ 2023-06-24T22:03:50+08:00 ] 39.144.6.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-06-24T22:03:59+08:00 ] 39.144.6.27 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230624&time=220301&v1=-01.084&v2=+00.014&v3=-00.955&v4=-00.231&v5=06.0&t=+22.4&h=78.9&rssi=+231&imsi=460044618415249&v6=-00.000&a1=00.164&a2=01.155&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001602s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011233s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230624',`time`='220301',`v1`=-1.084,`v2`=0.014,`v3`=-0.955,`v4`=-0.231,`v5`=6,`t`=22.4,`h`=78.9,`rssi`=231,`imsi`='460044618415249',`v6`=-0,`a1`=0.164,`a2`=1.155,`update_time`=1687615439 WHERE `imei` = '868922055684076' [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011940s ] [ 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' , '230624' , '220301' , -1.084 , 0.014 , -0.955 , -0.231 , 6 , 22.4 , 78.9 , 231 , '460044618415249' , -0 , 0.164 , 1.155 , 1687615439 , 1687615439) [ RunTime:0.000628s ]