--------------------------------------------------------------- [ 2023-05-22T02:03:54+08:00 ] 39.144.16.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-05-22T02:03:55+08:00 ] 39.144.2.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014597s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-05-22T02:04:03+08:00 ] 39.144.16.100 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230522&time=020301&v1=-01.374&v2=+00.017&v3=-00.940&v4=-00.041&v5=05.7&t=+16.1&h=59.8&rssi=+231&ccid=4600485905031420000099m9990000000437000001g3820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001673s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230522',`time`='020301',`v1`=-1.374,`v2`=0.017,`v3`=-0.94,`v4`=-0.041,`v5`=5.7,`t`=16.1,`h`=59.8,`rssi`=231,`ccid`='4600485905031420000099m9990000000437000001g3820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684692243 WHERE `imei` = '868922055643643' [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011268s ] [ 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' , '230522' , '020301' , -1.374 , 0.017 , -0.94 , -0.041 , 5.7 , 16.1 , 59.8 , 231 , '4600485905031420000099m9990000000437000001g3820,N,00E000=-00.000' , 0 , 0 , 1684692243 , 1684692243) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-05-22T02:04:03+08:00 ] 39.144.2.224 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230522&time=020301&v1=-00.223&v2=+00.001&v3=+00.018&v4=-00.005&v5=05.9&t=+16.3&h=62.8&rssi=+224&ccid=4600485905031430000099m9990000000037000000g2390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230522',`time`='020301',`v1`=-0.223,`v2`=0.001,`v3`=0.018,`v4`=-0.005,`v5`=5.9,`t`=16.3,`h`=62.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000037000000g2390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684692243 WHERE `imei` = '868922055644013' [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009826s ] [ 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' , '230522' , '020301' , -0.223 , 0.001 , 0.018 , -0.005 , 5.9 , 16.3 , 62.8 , 224 , '4600485905031430000099m9990000000037000000g2390,N,00E000=-00.000' , 0 , 0 , 1684692243 , 1684692243) [ RunTime:0.000585s ] --------------------------------------------------------------- [ 2023-05-22T08:51:04+08:00 ] 124.129.96.125 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014465s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-05-22T08:52:03+08:00 ] 124.129.96.125 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010510s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000932s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001291s ] --------------------------------------------------------------- [ 2023-05-22T08:53:26+08:00 ] 124.129.96.125 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009433s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000434s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001819s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001202s ] --------------------------------------------------------------- [ 2023-05-22T08:53:44+08:00 ] 124.129.96.125 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010399s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000399s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001067s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000989s ] --------------------------------------------------------------- [ 2023-05-22T09:42:09+08:00 ] 124.129.96.125 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010447s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2023-05-22T11:11:28+08:00 ] 117.132.195.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010988s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2023-05-22T11:11:29+08:00 ] 117.132.195.65 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1684725088&v1=0.030311&v2=0.013039&v3=0.027482&v4=0.001174&v5=12.420000&t=22.294704&h=78.671021&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009654s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1684725088,`v1`=0.030311,`v2`=0.013039,`v3`=0.027482,`v4`=0.001174,`v5`=12.42,`t`=22.294704,`h`=78.671021,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1684725089 WHERE `imei` = '868922055678110' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011818s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1684725088 , 0.030311 , 0.013039 , 0.027482 , 0.001174 , 12.42 , 22.294704 , 78.671021 , 28 , '898604650119C1078513' , '460048590708513' , -0 , 1684725089) [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2023-05-22T14:03:54+08:00 ] 111.55.139.251 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.012959s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-05-22T14:03:55+08:00 ] 39.144.16.51 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-05-22T14:04:02+08:00 ] 111.55.139.251 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230522&time=140301&v1=-01.375&v2=+00.030&v3=-00.944&v4=-00.044&v5=06.2&t=+29.6&h=56.4&rssi=+229&ccid=4600485905031420000099m9990000000432000001g3820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230522',`time`='140301',`v1`=-1.375,`v2`=0.03,`v3`=-0.944,`v4`=-0.044,`v5`=6.2,`t`=29.6,`h`=56.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000432000001g3820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684735442 WHERE `imei` = '868922055643643' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010439s ] [ 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' , '230522' , '140301' , -1.375 , 0.03 , -0.944 , -0.044 , 6.2 , 29.6 , 56.4 , 229 , '4600485905031420000099m9990000000432000001g3820,N,00E000=-00.000' , 0 , 0 , 1684735442 , 1684735442) [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2023-05-22T14:04:03+08:00 ] 39.144.16.51 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230522&time=140301&v1=-00.236&v2=+00.002&v3=+00.021&v4=-00.004&v5=06.0&t=+29.5&h=60.5&rssi=+227&ccid=4600485905031430000099m9990000000041000000g2560,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002021s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230522',`time`='140301',`v1`=-0.236,`v2`=0.002,`v3`=0.021,`v4`=-0.004,`v5`=6,`t`=29.5,`h`=60.5,`rssi`=227,`ccid`='4600485905031430000099m9990000000041000000g2560,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684735443 WHERE `imei` = '868922055644013' [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011489s ] [ 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' , '230522' , '140301' , -0.236 , 0.002 , 0.021 , -0.004 , 6 , 29.5 , 60.5 , 227 , '4600485905031430000099m9990000000041000000g2560,N,00E000=-00.000' , 0 , 0 , 1684735443 , 1684735443) [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-05-22T14:38:24+08:00 ] 111.55.138.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002650s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-05-22T14:38:25+08:00 ] 111.55.138.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1684737504&v1=0.016585&v2=0.013456&v3=0.013876&v4=-0.011769&v5=12.420000&t=23.013287&h=76.969666&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001793s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000914s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1684737504,`v1`=0.016585,`v2`=0.013456,`v3`=0.013876,`v4`=-0.011769,`v5`=12.42,`t`=23.013287,`h`=76.969666,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1684737505 WHERE `imei` = '868922055684548' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010325s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1684737504 , 0.016585 , 0.013456 , 0.013876 , -0.011769 , 12.42 , 23.013287 , 76.969666 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1684737505) [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-05-22T16:53:03+08:00 ] 218.204.253.110 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.003060s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000870s ] --------------------------------------------------------------- [ 2023-05-22T16:53:05+08:00 ] 218.204.253.110 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1684745583&v1=0.018632&v2=0.013560&v3=0.015622&v4=-0.000211&v5=12.420000&t=23.302864&h=79.998535&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184767,35.985118&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002027s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.019700s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1684745583,`v1`=0.018632,`v2`=0.01356,`v3`=0.015622,`v4`=-0.000211,`v5`=12.42,`t`=23.302864,`h`=79.998535,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184767,35.985118',`update_time`=1684745585 WHERE `imei` = '868922055647586' [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011595s ] [ 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' , 1684745583 , 0.018632 , 0.01356 , 0.015622 , -0.000211 , 12.42 , 23.302864 , 79.998535 , 28 , '898604650119C1078512' , '460048590708512' , -0 , '120.184767,35.985118' , 1684745585) [ RunTime:0.001398s ] --------------------------------------------------------------- [ 2023-05-22T17:33:16+08:00 ] 117.132.193.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2023-05-22T17:33:18+08:00 ] 117.132.193.2 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1684747996&v1=0.027542&v2=0.011995&v3=0.026157&v4=0.015803&v5=12.420000&t=23.227789&h=77.457947&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184768,35.984909&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011309s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000785s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1684747996,`v1`=0.027542,`v2`=0.011995,`v3`=0.026157,`v4`=0.015803,`v5`=12.42,`t`=23.227789,`h`=77.457947,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184768,35.984909',`update_time`=1684747998 WHERE `imei` = '868922056976208' [ RunTime:0.001223s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011207s ] [ 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' , 1684747996 , 0.027542 , 0.011995 , 0.026157 , 0.015803 , 12.42 , 23.227789 , 77.457947 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184768,35.984909' , 1684747998) [ RunTime:0.001399s ] --------------------------------------------------------------- [ 2023-05-22T17:38:21+08:00 ] 39.144.12.234 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001869s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009860s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-05-22T17:38:22+08:00 ] 39.144.12.234 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1684748301&v1=0.019535&v2=0.015855&v3=0.016555&v4=-0.007134&v5=12.420000&t=23.238514&h=79.311890&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009451s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1684748301,`v1`=0.019535,`v2`=0.015855,`v3`=0.016555,`v4`=-0.007134,`v5`=12.42,`t`=23.238514,`h`=79.31189,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1684748302 WHERE `imei` = '868922055684209' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009533s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1684748301 , 0.019535 , 0.015855 , 0.016555 , -0.007134 , 12.42 , 23.238514 , 79.31189 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1684748302) [ RunTime:0.001135s ] --------------------------------------------------------------- [ 2023-05-22T18:03:20+08:00 ] 39.144.17.115 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2023-05-22T18:03:22+08:00 ] 39.144.17.115 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1684749800&v1=0.018692&v2=0.012934&v3=0.015893&v4=-0.004545&v5=12.420000&t=23.024012&h=81.661743&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1684749800,`v1`=0.018692,`v2`=0.012934,`v3`=0.015893,`v4`=-0.004545,`v5`=12.42,`t`=23.024012,`h`=81.661743,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1684749802 WHERE `imei` = '868922055683920' [ RunTime:0.001749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010882s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1684749800 , 0.018692 , 0.012934 , 0.015893 , -0.004545 , 12.42 , 23.024012 , 81.661743 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1684749802) [ RunTime:0.001282s ] --------------------------------------------------------------- [ 2023-05-22T18:11:50+08:00 ] 111.55.136.205 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002128s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-05-22T18:11:58+08:00 ] 111.55.136.205 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230522&time=181101&v1=-01.213&v2=+00.016&v3=-01.079&v4=-00.601&v5=06.0&t=+27.7&h=78.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.254&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230522',`time`='181101',`v1`=-1.213,`v2`=0.016,`v3`=-1.079,`v4`=-0.601,`v5`=6,`t`=27.7,`h`=78.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.254,`update_time`=1684750318 WHERE `imei` = '868922055684076' [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009715s ] [ 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' , '230522' , '181101' , -1.213 , 0.016 , -1.079 , -0.601 , 6 , 27.7 , 78.1 , 228 , '460044618415249' , -0 , 0.158 , 1.254 , 1684750318 , 1684750318) [ RunTime:0.001290s ] --------------------------------------------------------------- [ 2023-05-22T20:50:57+08:00 ] 39.144.6.166 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002870s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012124s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-05-22T20:50:58+08:00 ] 39.144.6.166 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1684759857&v1=0.031876&v2=0.013039&v3=0.028595&v4=0.008217&v5=12.600000&t=22.380505&h=80.502075&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185038,35.985394&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.009622s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1684759857,`v1`=0.031876,`v2`=0.013039,`v3`=0.028595,`v4`=0.008217,`v5`=12.6,`t`=22.380505,`h`=80.502075,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185038,35.985394',`update_time`=1684759858 WHERE `imei` = '868922055683912' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012118s ] [ 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' , 1684759857 , 0.031876 , 0.013039 , 0.028595 , 0.008217 , 12.6 , 22.380505 , 80.502075 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185038,35.985394' , 1684759858) [ RunTime:0.001422s ] --------------------------------------------------------------- [ 2023-05-22T20:55:24+08:00 ] 39.144.3.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001886s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010663s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-05-22T20:55:25+08:00 ] 39.144.3.86 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1684760124&v1=0.019114&v2=0.013456&v3=0.016013&v4=-0.017247&v5=12.420000&t=22.326880&h=81.310791&rssi=26&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185480,35.985559&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010294s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1684760124,`v1`=0.019114,`v2`=0.013456,`v3`=0.016013,`v4`=-0.017247,`v5`=12.42,`t`=22.32688,`h`=81.310791,`rssi`=26,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185480,35.985559',`update_time`=1684760125 WHERE `imei` = '868922055683771' [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010333s ] [ 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' , 1684760124 , 0.019114 , 0.013456 , 0.016013 , -0.017247 , 12.42 , 22.32688 , 81.310791 , 26 , '898604650119C1053136' , '460048590503136' , -0 , '120.185480,35.985559' , 1684760125) [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-05-22T23:33:23+08:00 ] 39.144.4.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ 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.012921s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2023-05-22T23:33:25+08:00 ] 39.144.4.178 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1684769603&v1=0.006893&v2=0.015125&v3=0.004756&v4=-0.015983&v5=12.420000&t=22.133827&h=79.952759&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009177s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1684769603,`v1`=0.006893,`v2`=0.015125,`v3`=0.004756,`v4`=-0.015983,`v5`=12.42,`t`=22.133827,`h`=79.952759,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1684769604 WHERE `imei` = '868922055644021' [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011346s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1684769603 , 0.006893 , 0.015125 , 0.004756 , -0.015983 , 12.42 , 22.133827 , 79.952759 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1684769605) [ RunTime:0.001214s ] --------------------------------------------------------------- [ 2023-05-22T23:54:24+08:00 ] 111.55.139.161 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011098s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-05-22T23:54:25+08:00 ] 111.55.139.161 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1684770864&v1=0.021100&v2=0.014707&v3=0.018120&v4=-0.006231&v5=12.240000&t=22.198179&h=78.999084&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001935s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010361s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1684770864,`v1`=0.0211,`v2`=0.014707,`v3`=0.01812,`v4`=-0.006231,`v5`=12.24,`t`=22.198179,`h`=78.999084,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1684770865 WHERE `imei` = '868922055680850' [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012732s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1684770864 , 0.0211 , 0.014707 , 0.01812 , -0.006231 , 12.24 , 22.198179 , 78.999084 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1684770865) [ RunTime:0.001282s ]