--------------------------------------------------------------- [ 2023-06-10T00:12:23+08:00 ] 39.144.6.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002606s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010912s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-06-10T00:12:24+08:00 ] 39.144.6.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686327143&v1=0.021582&v2=0.011370&v3=0.018602&v4=-0.006351&v5=12.240000&t=26.402416&h=78.884644&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009783s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000777s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686327143,`v1`=0.021582,`v2`=0.01137,`v3`=0.018602,`v4`=-0.006351,`v5`=12.24,`t`=26.402416,`h`=78.884644,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1686327144 WHERE `imei` = '868922055680850' [ RunTime:0.000941s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011032s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1686327143 , 0.021582 , 0.01137 , 0.018602 , -0.006351 , 12.24 , 26.402416 , 78.884644 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1686327144) [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-06-10T02:03:54+08:00 ] 223.104.255.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010850s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-06-10T02:03:55+08:00 ] 39.144.14.205 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002038s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011499s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-06-10T02:04:02+08:00 ] 223.104.255.62 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230610&time=020301&v1=-01.388&v2=+00.015&v3=-01.014&v4=-00.043&v5=06.2&t=+21.6&h=59.9&rssi=+227&ccid=4600485905031420000099m9990000000376000001g3960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013243s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230610',`time`='020301',`v1`=-1.388,`v2`=0.015,`v3`=-1.014,`v4`=-0.043,`v5`=6.2,`t`=21.6,`h`=59.9,`rssi`=227,`ccid`='4600485905031420000099m9990000000376000001g3960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686333842 WHERE `imei` = '868922055643643' [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010372s ] [ 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' , '230610' , '020301' , -1.388 , 0.015 , -1.014 , -0.043 , 6.2 , 21.6 , 59.9 , 227 , '4600485905031420000099m9990000000376000001g3960,N,00E000=-00.000' , 0 , 0 , 1686333842 , 1686333842) [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2023-06-10T02:04:03+08:00 ] 39.144.14.205 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230610&time=020301&v1=-00.411&v2=+00.001&v3=-00.054&v4=-00.002&v5=06.0&t=+21.9&h=62.9&rssi=+223&ccid=4600485905031430000099m9990000000038000000g4310,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010789s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230610',`time`='020301',`v1`=-0.411,`v2`=0.001,`v3`=-0.054,`v4`=-0.002,`v5`=6,`t`=21.9,`h`=62.9,`rssi`=223,`ccid`='4600485905031430000099m9990000000038000000g4310,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686333843 WHERE `imei` = '868922055644013' [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008628s ] [ 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' , '230610' , '020301' , -0.411 , 0.001 , -0.054 , -0.002 , 6 , 21.9 , 62.9 , 223 , '4600485905031430000099m9990000000038000000g4310,N,00E000=-00.000' , 0 , 0 , 1686333843 , 1686333843) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-06-10T11:30:28+08:00 ] 221.178.126.99 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001215s ] --------------------------------------------------------------- [ 2023-06-10T11:30:30+08:00 ] 221.178.126.99 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686367828&v1=0.030552&v2=0.012726&v3=0.029829&v4=0.001294&v5=12.240000&t=25.801811&h=79.090637&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001819s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011032s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686367828,`v1`=0.030552,`v2`=0.012726,`v3`=0.029829,`v4`=0.001294,`v5`=12.24,`t`=25.801811,`h`=79.090637,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686367830 WHERE `imei` = '868922055678110' [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015323s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686367828 , 0.030552 , 0.012726 , 0.029829 , 0.001294 , 12.24 , 25.801811 , 79.090637 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1686367830) [ RunTime:0.001167s ] --------------------------------------------------------------- [ 2023-06-10T14:03:54+08:00 ] 39.144.1.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012004s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001254s ] --------------------------------------------------------------- [ 2023-06-10T14:03:54+08:00 ] 221.178.126.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001902s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011313s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2023-06-10T14:04:02+08:00 ] 39.144.1.124 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230610&time=140301&v1=-01.388&v2=+00.021&v3=-01.009&v4=-00.043&v5=06.4&t=+34.3&h=54.9&rssi=+230&ccid=4600485905031420000099m9990000000379000001g3940,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001632s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010059s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230610',`time`='140301',`v1`=-1.388,`v2`=0.021,`v3`=-1.009,`v4`=-0.043,`v5`=6.4,`t`=34.3,`h`=54.9,`rssi`=230,`ccid`='4600485905031420000099m9990000000379000001g3940,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686377042 WHERE `imei` = '868922055643643' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012048s ] [ 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' , '230610' , '140301' , -1.388 , 0.021 , -1.009 , -0.043 , 6.4 , 34.3 , 54.9 , 230 , '4600485905031420000099m9990000000379000001g3940,N,00E000=-00.000' , 0 , 0 , 1686377042 , 1686377042) [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-06-10T14:04:03+08:00 ] 221.178.126.249 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230610&time=140301&v1=-00.475&v2=+00.001&v3=+00.019&v4=+00.000&v5=06.0&t=+32.7&h=59.0&rssi=+226&ccid=4600485905031430000099m9990000000045000000g4970,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009423s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230610',`time`='140301',`v1`=-0.475,`v2`=0.001,`v3`=0.019,`v4`=0,`v5`=6,`t`=32.7,`h`=59,`rssi`=226,`ccid`='4600485905031430000099m9990000000045000000g4970,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686377043 WHERE `imei` = '868922055644013' [ RunTime:0.000795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009965s ] [ 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' , '230610' , '140301' , -0.475 , 0.001 , 0.019 , 0 , 6 , 32.7 , 59 , 226 , '4600485905031430000099m9990000000045000000g4970,N,00E000=-00.000' , 0 , 0 , 1686377043 , 1686377043) [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2023-06-10T14:57:22+08:00 ] 223.104.255.184 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011496s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-06-10T14:57:23+08:00 ] 223.104.255.184 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686380242&v1=0.016886&v2=0.014082&v3=0.014599&v4=-0.011649&v5=12.240000&t=26.391691&h=77.686829&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.001707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686380242,`v1`=0.016886,`v2`=0.014082,`v3`=0.014599,`v4`=-0.011649,`v5`=12.24,`t`=26.391691,`h`=77.686829,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686380243 WHERE `imei` = '868922055684548' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010447s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686380242 , 0.016886 , 0.014082 , 0.014599 , -0.011649 , 12.24 , 26.391691 , 77.686829 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1686380243) [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-06-10T17:09:24+08:00 ] 39.144.3.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013503s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000958s ] --------------------------------------------------------------- [ 2023-06-10T17:09:26+08:00 ] 39.144.3.163 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686388164&v1=0.018452&v2=0.015333&v3=0.015201&v4=-0.000090&v5=12.240000&t=26.112839&h=79.372925&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001620s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686388164,`v1`=0.018452,`v2`=0.015333,`v3`=0.015201,`v4`=-9.0E-5,`v5`=12.24,`t`=26.112839,`h`=79.372925,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1686388166 WHERE `imei` = '868922055647586' [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012300s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1686388164 , 0.018452 , 0.015333 , 0.015201 , -9.0E-5 , 12.24 , 26.112839 , 79.372925 , 29 , '898604650119C1078512' , '460048590708512' , -0 , 1686388166) [ RunTime:0.000731s ] --------------------------------------------------------------- [ 2023-06-10T17:50:02+08:00 ] 39.144.16.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012907s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-06-10T17:50:07+08:00 ] 39.144.16.222 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686390602&v1=0.027181&v2=0.013456&v3=0.027241&v4=0.015682&v5=12.240000&t=26.027039&h=77.305359&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185089,35.987518&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001753s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686390602,`v1`=0.027181,`v2`=0.013456,`v3`=0.027241,`v4`=0.015682,`v5`=12.24,`t`=26.027039,`h`=77.305359,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185089,35.987518',`update_time`=1686390607 WHERE `imei` = '868922056976208' [ RunTime:0.000877s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014582s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1686390602 , 0.027181 , 0.013456 , 0.027241 , 0.015682 , 12.24 , 26.027039 , 77.305359 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.185089,35.987518' , 1686390607) [ RunTime:0.000857s ] --------------------------------------------------------------- [ 2023-06-10T17:57:20+08:00 ] 39.144.3.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001870s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-06-10T17:57:21+08:00 ] 39.144.3.236 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686391040&v1=0.020860&v2=0.013351&v3=0.016946&v4=-0.006773&v5=12.420000&t=25.973413&h=79.533142&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010200s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001021s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686391040,`v1`=0.02086,`v2`=0.013351,`v3`=0.016946,`v4`=-0.006773,`v5`=12.42,`t`=25.973413,`h`=79.533142,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686391041 WHERE `imei` = '868922055684209' [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013963s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686391040 , 0.02086 , 0.013351 , 0.016946 , -0.006773 , 12.42 , 25.973413 , 79.533142 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1686391041) [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-06-10T18:22:21+08:00 ] 117.132.197.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002420s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012001s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-06-10T18:22:22+08:00 ] 117.132.197.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686392541&v1=0.018993&v2=0.015751&v3=0.016284&v4=-0.004906&v5=12.420000&t=25.898338&h=83.179993&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001418s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686392541,`v1`=0.018993,`v2`=0.015751,`v3`=0.016284,`v4`=-0.004906,`v5`=12.42,`t`=25.898338,`h`=83.179993,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686392542 WHERE `imei` = '868922055683920' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010014s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686392541 , 0.018993 , 0.015751 , 0.016284 , -0.004906 , 12.42 , 25.898338 , 83.179993 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686392542) [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-06-10T21:07:24+08:00 ] 39.144.5.119 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013725s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2023-06-10T21:07:25+08:00 ] 39.144.5.119 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686402444&v1=0.031816&v2=0.013247&v3=0.028926&v4=0.008157&v5=12.420000&t=25.254831&h=81.829590&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001884s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686402444,`v1`=0.031816,`v2`=0.013247,`v3`=0.028926,`v4`=0.008157,`v5`=12.42,`t`=25.254831,`h`=81.82959,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1686402445 WHERE `imei` = '868922055683912' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012146s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1686402444 , 0.031816 , 0.013247 , 0.028926 , 0.008157 , 12.42 , 25.254831 , 81.82959 , 18 , '898604650119C1053138' , '460048590503138' , -0 , 1686402445) [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-06-10T21:14:24+08:00 ] 221.178.126.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014444s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000758s ] --------------------------------------------------------------- [ 2023-06-10T21:14:25+08:00 ] 221.178.126.125 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686402864&v1=0.019415&v2=0.014603&v3=0.016043&v4=-0.017368&v5=12.420000&t=25.222656&h=82.691711&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185093,35.986092&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001925s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000801s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686402864,`v1`=0.019415,`v2`=0.014603,`v3`=0.016043,`v4`=-0.017368,`v5`=12.42,`t`=25.222656,`h`=82.691711,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185093,35.986092',`update_time`=1686402865 WHERE `imei` = '868922055683771' [ RunTime:0.000999s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011146s ] [ 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' , 1686402864 , 0.019415 , 0.014603 , 0.016043 , -0.017368 , 12.42 , 25.222656 , 82.691711 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.185093,35.986092' , 1686402865) [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-06-10T22:12:51+08:00 ] 39.144.17.115 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012603s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2023-06-10T22:12:59+08:00 ] 39.144.17.115 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230610&time=221201&v1=-01.197&v2=+00.025&v3=-01.080&v4=-00.244&v5=05.9&t=+18.7&h=79.2&rssi=+225&imsi=460044618415249&v6=-00.000&a1=00.143&a2=01.244&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010736s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230610',`time`='221201',`v1`=-1.197,`v2`=0.025,`v3`=-1.08,`v4`=-0.244,`v5`=5.9,`t`=18.7,`h`=79.2,`rssi`=225,`imsi`='460044618415249',`v6`=-0,`a1`=0.143,`a2`=1.244,`update_time`=1686406379 WHERE `imei` = '868922055684076' [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012155s ] [ 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' , '230610' , '221201' , -1.197 , 0.025 , -1.08 , -0.244 , 5.9 , 18.7 , 79.2 , 225 , '460044618415249' , -0 , 0.143 , 1.244 , 1686406379 , 1686406379) [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-06-10T23:52:23+08:00 ] 39.144.4.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013590s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-06-10T23:52:25+08:00 ] 39.144.4.70 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686412343&v1=0.007736&v2=0.013143&v3=0.004967&v4=-0.015863&v5=12.240000&t=25.136856&h=80.853027&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003047s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001019s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686412343,`v1`=0.007736,`v2`=0.013143,`v3`=0.004967,`v4`=-0.015863,`v5`=12.24,`t`=25.136856,`h`=80.853027,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686412345 WHERE `imei` = '868922055644021' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013086s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686412343 , 0.007736 , 0.013143 , 0.004967 , -0.015863 , 12.24 , 25.136856 , 80.853027 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686412345) [ RunTime:0.000702s ]