---------------------------------------------------------------
[ 2023-05-20T02:03:54+08:00 ] 218.204.253.54 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012997s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001046s ]
---------------------------------------------------------------
[ 2023-05-20T02:03:55+08:00 ] 111.55.140.173 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011093s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ]
---------------------------------------------------------------
[ 2023-05-20T02:04:02+08:00 ] 218.204.253.54 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230520&time=020301&v1=-01.374&v2=+00.016&v3=-00.968&v4=-00.040&v5=05.9&t=+19.0&h=60.7&rssi=+228&ccid=4600485905031420000099m9990000000409000001g3820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001578s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230520',`time`='020301',`v1`=-1.374,`v2`=0.016,`v3`=-0.968,`v4`=-0.04,`v5`=5.9,`t`=19,`h`=60.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000409000001g3820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684519442  WHERE  `imei` = '868922055643643' [ RunTime:0.000596s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009533s ]
[ 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' , '230520' , '020301' , -1.374 , 0.016 , -0.968 , -0.04 , 5.9 , 19 , 60.7 , 228 , '4600485905031420000099m9990000000409000001g3820,N,00E000=-00.000' , 0 , 0 , 1684519442 , 1684519442) [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2023-05-20T02:04:03+08:00 ] 111.55.140.173 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230520&time=020301&v1=-00.188&v2=+00.001&v3=+00.004&v4=-00.006&v5=06.0&t=+19.1&h=63.3&rssi=+224&ccid=4600485905031430000099m9990000000033000000g1970,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009434s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000642s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230520',`time`='020301',`v1`=-0.188,`v2`=0.001,`v3`=0.004,`v4`=-0.006,`v5`=6,`t`=19.1,`h`=63.3,`rssi`=224,`ccid`='4600485905031430000099m9990000000033000000g1970,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684519443  WHERE  `imei` = '868922055644013' [ RunTime:0.000521s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008822s ]
[ 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' , '230520' , '020301' , -0.188 , 0.001 , 0.004 , -0.006 , 6 , 19.1 , 63.3 , 224 , '4600485905031430000099m9990000000033000000g1970,N,00E000=-00.000' , 0 , 0 , 1684519443 , 1684519443) [ RunTime:0.000528s ]
---------------------------------------------------------------
[ 2023-05-20T10:05:39+08:00 ] 124.129.96.125 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.016975s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2023-05-20T10:05:42+08:00 ] 124.129.96.125 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010188s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000339s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001611s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001044s ]
---------------------------------------------------------------
[ 2023-05-20T10:06:12+08:00 ] 124.129.96.125 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002406s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010656s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000364s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001004s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000979s ]
---------------------------------------------------------------
[ 2023-05-20T10:06:42+08:00 ] 124.129.96.125 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001406s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009810s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000362s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001061s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001092s ]
---------------------------------------------------------------
[ 2023-05-20T11:09:28+08:00 ] 111.55.140.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011888s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000768s ]
---------------------------------------------------------------
[ 2023-05-20T11:09:29+08:00 ] 111.55.140.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1684552168&v1=0.029468&v2=0.014707&v3=0.028144&v4=0.001415&v5=12.420000&t=23.377939&h=78.465027&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009617s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055678110',`create_time`=1684552168,`v1`=0.029468,`v2`=0.014707,`v3`=0.028144,`v4`=0.001415,`v5`=12.42,`t`=23.377939,`h`=78.465027,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1684552169  WHERE  `imei` = '868922055678110' [ RunTime:0.001211s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010576s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1684552168 , 0.029468 , 0.014707 , 0.028144 , 0.001415 , 12.42 , 23.377939 , 78.465027 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1684552169) [ RunTime:0.001242s ]
---------------------------------------------------------------
[ 2023-05-20T14:03:54+08:00 ] 221.178.126.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011336s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001304s ]
---------------------------------------------------------------
[ 2023-05-20T14:03:54+08:00 ] 39.144.4.131 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010813s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000678s ]
---------------------------------------------------------------
[ 2023-05-20T14:04:02+08:00 ] 221.178.126.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230520&time=140301&v1=-01.372&v2=+00.026&v3=-00.943&v4=-00.040&v5=05.9&t=+32.8&h=56.9&rssi=+228&ccid=4600485905031420000099m9990000000430000001g3800,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001926s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010015s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000734s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230520',`time`='140301',`v1`=-1.372,`v2`=0.026,`v3`=-0.943,`v4`=-0.04,`v5`=5.9,`t`=32.8,`h`=56.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000430000001g3800,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684562642  WHERE  `imei` = '868922055643643' [ RunTime:0.000625s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012204s ]
[ 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' , '230520' , '140301' , -1.372 , 0.026 , -0.943 , -0.04 , 5.9 , 32.8 , 56.9 , 228 , '4600485905031420000099m9990000000430000001g3800,N,00E000=-00.000' , 0 , 0 , 1684562642 , 1684562642) [ RunTime:0.001297s ]
---------------------------------------------------------------
[ 2023-05-20T14:04:03+08:00 ] 39.144.4.131 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230520&time=140301&v1=-00.160&v2=+00.001&v3=+00.021&v4=-00.005&v5=06.0&t=+32.5&h=60.6&rssi=+225&ccid=4600485905031430000099m9990000000041000000g1700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010726s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230520',`time`='140301',`v1`=-0.16,`v2`=0.001,`v3`=0.021,`v4`=-0.005,`v5`=6,`t`=32.5,`h`=60.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000041000000g1700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684562643  WHERE  `imei` = '868922055644013' [ RunTime:0.000520s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009912s ]
[ 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' , '230520' , '140301' , -0.16 , 0.001 , 0.021 , -0.005 , 6 , 32.5 , 60.6 , 225 , '4600485905031430000099m9990000000041000000g1700,N,00E000=-00.000' , 0 , 0 , 1684562643 , 1684562643) [ RunTime:0.001495s ]
---------------------------------------------------------------
[ 2023-05-20T14:36:22+08:00 ] 117.132.191.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.003422s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011916s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000747s ]
---------------------------------------------------------------
[ 2023-05-20T14:36:23+08:00 ] 117.132.191.129 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1684564582&v1=0.016766&v2=0.013873&v3=0.014117&v4=-0.011829&v5=12.420000&t=23.667517&h=76.725525&rssi=30&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010171s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000826s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1684564582,`v1`=0.016766,`v2`=0.013873,`v3`=0.014117,`v4`=-0.011829,`v5`=12.42,`t`=23.667517,`h`=76.725525,`rssi`=30,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1684564583  WHERE  `imei` = '868922055684548' [ RunTime:0.000801s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013730s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1684564582 , 0.016766 , 0.013873 , 0.014117 , -0.011829 , 12.42 , 23.667517 , 76.725525 , 30 , '898604650119C1053137' , '460048590503137' , -0 , 1684564583) [ RunTime:0.000774s ]
---------------------------------------------------------------
[ 2023-05-20T16:51:11+08:00 ] 111.55.137.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012904s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000706s ]
---------------------------------------------------------------
[ 2023-05-20T16:51:12+08:00 ] 111.55.137.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1684572671&v1=0.018512&v2=0.013873&v3=0.016435&v4=-0.000452&v5=12.420000&t=24.064346&h=80.059570&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184893,35.985222&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001649s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009661s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000662s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055647586',`create_time`=1684572671,`v1`=0.018512,`v2`=0.013873,`v3`=0.016435,`v4`=-0.000452,`v5`=12.42,`t`=24.064346,`h`=80.05957,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184893,35.985222',`update_time`=1684572672  WHERE  `imei` = '868922055647586' [ RunTime:0.000711s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010814s ]
[ 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' , 1684572671 , 0.018512 , 0.013873 , 0.016435 , -0.000452 , 12.42 , 24.064346 , 80.05957 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.184893,35.985222' , 1684572672) [ RunTime:0.001304s ]
---------------------------------------------------------------
[ 2023-05-20T17:31:23+08:00 ] 39.144.1.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002390s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000790s ]
---------------------------------------------------------------
[ 2023-05-20T17:31:24+08:00 ] 39.144.1.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1684575083&v1=0.027662&v2=0.013664&v3=0.026639&v4=0.015863&v5=12.240000&t=23.892744&h=77.297729&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184912,35.985808&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008171s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001011s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1684575083,`v1`=0.027662,`v2`=0.013664,`v3`=0.026639,`v4`=0.015863,`v5`=12.24,`t`=23.892744,`h`=77.297729,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184912,35.985808',`update_time`=1684575084  WHERE  `imei` = '868922056976208' [ RunTime:0.000721s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010380s ]
[ 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' , 1684575083 , 0.027662 , 0.013664 , 0.026639 , 0.015863 , 12.24 , 23.892744 , 77.297729 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184912,35.985808' , 1684575084) [ RunTime:0.001258s ]
---------------------------------------------------------------
[ 2023-05-20T17:36:21+08:00 ] 39.144.7.81 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010715s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000959s ]
---------------------------------------------------------------
[ 2023-05-20T17:36:22+08:00 ] 39.144.7.81 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1684575381&v1=0.019716&v2=0.013873&v3=0.016796&v4=-0.007013&v5=12.420000&t=23.978544&h=79.052490&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009017s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1684575381,`v1`=0.019716,`v2`=0.013873,`v3`=0.016796,`v4`=-0.007013,`v5`=12.42,`t`=23.978544,`h`=79.05249,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1684575382  WHERE  `imei` = '868922055684209' [ RunTime:0.000570s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009506s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1684575381 , 0.019716 , 0.013873 , 0.016796 , -0.007013 , 12.42 , 23.978544 , 79.05249 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1684575382) [ RunTime:0.001269s ]
---------------------------------------------------------------
[ 2023-05-20T18:01:21+08:00 ] 39.144.12.212 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ 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.012425s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000748s ]
---------------------------------------------------------------
[ 2023-05-20T18:01:22+08:00 ] 39.144.12.212 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1684576881&v1=0.018873&v2=0.014290&v3=0.016164&v4=-0.004846&v5=12.420000&t=23.731867&h=81.356567&rssi=27&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010769s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000685s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1684576881,`v1`=0.018873,`v2`=0.01429,`v3`=0.016164,`v4`=-0.004846,`v5`=12.42,`t`=23.731867,`h`=81.356567,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1684576882  WHERE  `imei` = '868922055683920' [ RunTime:0.000616s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023890s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1684576881 , 0.018873 , 0.01429 , 0.016164 , -0.004846 , 12.42 , 23.731867 , 81.356567 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1684576882) [ RunTime:0.000643s ]
---------------------------------------------------------------
[ 2023-05-20T18:12:50+08:00 ] 111.55.137.115 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.003068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011382s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2023-05-20T18:12:59+08:00 ] 111.55.137.115 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230520&time=181201&v1=-01.247&v2=+00.017&v3=-01.124&v4=-00.634&v5=06.2&t=+26.9&h=80.0&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.143&a2=01.274&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009368s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230520',`time`='181201',`v1`=-1.247,`v2`=0.017,`v3`=-1.124,`v4`=-0.634,`v5`=6.2,`t`=26.9,`h`=80,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.143,`a2`=1.274,`update_time`=1684577579  WHERE  `imei` = '868922055684076' [ RunTime:0.000583s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011074s ]
[ 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' , '230520' , '181201' , -1.247 , 0.017 , -1.124 , -0.634 , 6.2 , 26.9 , 80 , 227 , '460044618415249' , -0 , 0.143 , 1.274 , 1684577579 , 1684577579) [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2023-05-20T20:49:07+08:00 ] 221.178.124.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012650s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000729s ]
---------------------------------------------------------------
[ 2023-05-20T20:49:08+08:00 ] 221.178.124.178 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1684586947&v1=0.031154&v2=0.014499&v3=0.028957&v4=0.008157&v5=12.420000&t=23.442289&h=80.181641&rssi=17&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184581,35.985775&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002043s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009992s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000703s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1684586947,`v1`=0.031154,`v2`=0.014499,`v3`=0.028957,`v4`=0.008157,`v5`=12.42,`t`=23.442289,`h`=80.181641,`rssi`=17,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184581,35.985775',`update_time`=1684586948  WHERE  `imei` = '868922055683912' [ RunTime:0.000629s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013278s ]
[ 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' , 1684586947 , 0.031154 , 0.014499 , 0.028957 , 0.008157 , 12.42 , 23.442289 , 80.181641 , 17 , '898604650119C1053138' , '460048590503138' , -0 , '120.184581,35.985775' , 1684586948) [ RunTime:0.001274s ]
---------------------------------------------------------------
[ 2023-05-20T20:53:04+08:00 ] 39.144.1.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.003011s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011265s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2023-05-20T20:53:05+08:00 ] 39.144.1.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1684587184&v1=0.019294&v2=0.014290&v3=0.016284&v4=-0.017247&v5=12.420000&t=23.474464&h=81.013245&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184054,35.985839&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009510s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.001055s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1684587184,`v1`=0.019294,`v2`=0.01429,`v3`=0.016284,`v4`=-0.017247,`v5`=12.42,`t`=23.474464,`h`=81.013245,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184054,35.985839',`update_time`=1684587185  WHERE  `imei` = '868922055683771' [ RunTime:0.000586s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009763s ]
[ 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' , 1684587184 , 0.019294 , 0.01429 , 0.016284 , -0.017247 , 12.42 , 23.474464 , 81.013245 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184054,35.985839' , 1684587185) [ RunTime:0.000505s ]
---------------------------------------------------------------
[ 2023-05-20T23:31:23+08:00 ] 117.132.193.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002476s ] 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` = '868922055644021' LIMIT 1 [ RunTime:0.000760s ]
---------------------------------------------------------------
[ 2023-05-20T23:31:25+08:00 ] 117.132.193.176 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1684596683&v1=0.007134&v2=0.014916&v3=0.004936&v4=-0.015923&v5=12.420000&t=23.324314&h=79.563660&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010574s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000679s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1684596683,`v1`=0.007134,`v2`=0.014916,`v3`=0.004936,`v4`=-0.015923,`v5`=12.42,`t`=23.324314,`h`=79.56366,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1684596685  WHERE  `imei` = '868922055644021' [ RunTime:0.000655s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010570s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1684596683 , 0.007134 , 0.014916 , 0.004936 , -0.015923 , 12.42 , 23.324314 , 79.56366 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1684596685) [ RunTime:0.000652s ]
---------------------------------------------------------------
[ 2023-05-20T23:41:14+08:00 ] 123.235.63.238 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013247s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'user'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001232s ]
---------------------------------------------------------------
[ 2023-05-20T23:41:16+08:00 ] 123.235.63.238 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.014347s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'user' LIMIT 1 [ RunTime:0.001107s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000657s ]
---------------------------------------------------------------
[ 2023-05-20T23:52:24+08:00 ] 218.204.252.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011531s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000751s ]
---------------------------------------------------------------
[ 2023-05-20T23:52:26+08:00 ] 218.204.252.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1684597944&v1=0.021341&v2=0.013664&v3=0.018331&v4=-0.006050&v5=12.240000&t=23.259964&h=78.800720&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-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.011654s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000740s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055680850',`create_time`=1684597944,`v1`=0.021341,`v2`=0.013664,`v3`=0.018331,`v4`=-0.00605,`v5`=12.24,`t`=23.259964,`h`=78.80072,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1684597946  WHERE  `imei` = '868922055680850' [ RunTime:0.000711s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010650s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1684597944 , 0.021341 , 0.013664 , 0.018331 , -0.00605 , 12.24 , 23.259964 , 78.80072 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1684597946) [ RunTime:0.001293s ]