--------------------------------------------------------------- [ 2023-03-19T02:03:55+08:00 ] 117.132.194.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000953s ] --------------------------------------------------------------- [ 2023-03-19T02:03:56+08:00 ] 117.132.193.131 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2023-03-19T02:04:03+08:00 ] 117.132.194.22 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230319&time=020301&v1=-00.210&v2=+00.001&v3=+00.000&v4=-00.019&v5=05.7&t=+03.0&h=65.0&rssi=+226&ccid=4600485905031430000099m9990000000033000000g2370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230319',`time`='020301',`v1`=-0.21,`v2`=0.001,`v3`=0,`v4`=-0.019,`v5`=5.7,`t`=3,`h`=65,`rssi`=226,`ccid`='4600485905031430000099m9990000000033000000g2370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679162643 WHERE `imei` = '868922055644013' [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012889s ] [ 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' , '230319' , '020301' , -0.21 , 0.001 , 0 , -0.019 , 5.7 , 3 , 65 , 226 , '4600485905031430000099m9990000000033000000g2370,N,00E000=-00.000' , 0 , 0 , 1679162643 , 1679162643) [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-03-19T02:04:04+08:00 ] 117.132.193.131 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230319&time=020301&v1=-01.291&v2=+00.023&v3=-00.960&v4=-00.023&v5=06.0&t=+02.1&h=62.3&rssi=+230&ccid=4600485905031420000099m9990000000323000001g3030,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002150s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230319',`time`='020301',`v1`=-1.291,`v2`=0.023,`v3`=-0.96,`v4`=-0.023,`v5`=6,`t`=2.1,`h`=62.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000323000001g3030,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679162644 WHERE `imei` = '868922055643643' [ RunTime:0.001148s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009882s ] [ 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' , '230319' , '020301' , -1.291 , 0.023 , -0.96 , -0.023 , 6 , 2.1 , 62.3 , 230 , '4600485905031420000099m9990000000323000001g3030,N,00E000=-00.000' , 0 , 0 , 1679162644 , 1679162644) [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2023-03-19T02:32:25+08:00 ] 39.144.10.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002892s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011036s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2023-03-19T02:32:27+08:00 ] 39.144.10.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679164345&v1=0.028144&v2=0.627309&v3=0.028595&v4=0.028023&v5=12.420000&t=11.601782&h=41.142029&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009802s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679164345,`v1`=0.028144,`v2`=0.627309,`v3`=0.028595,`v4`=0.028023,`v5`=12.42,`t`=11.601782,`h`=41.142029,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679164347 WHERE `imei` = '868922056976109' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010697s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679164345 , 0.028144 , 0.627309 , 0.028595 , 0.028023 , 12.42 , 11.601782 , 41.142029 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679164347) [ RunTime:0.000644s ] --------------------------------------------------------------- [ 2023-03-19T06:04:50+08:00 ] 221.178.127.145 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-03-19T06:04:59+08:00 ] 221.178.127.145 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230319&time=060401&v1=-01.206&v2=+00.021&v3=-00.913&v4=-00.541&v5=05.7&t=+02.7&h=81.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.297&a2=01.241&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010923s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000807s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230319',`time`='060401',`v1`=-1.206,`v2`=0.021,`v3`=-0.913,`v4`=-0.541,`v5`=5.7,`t`=2.7,`h`=81.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.297,`a2`=1.241,`update_time`=1679177099 WHERE `imei` = '868922055684076' [ RunTime:0.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011385s ] [ 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' , '230319' , '060401' , -1.206 , 0.021 , -0.913 , -0.541 , 5.7 , 2.7 , 81.2 , 227 , '460044618415249' , -0 , 0.297 , 1.241 , 1679177099 , 1679177099) [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-03-19T14:03:54+08:00 ] 111.55.136.135 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002284s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011891s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-03-19T14:03:55+08:00 ] 39.144.14.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009568s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-03-19T14:04:03+08:00 ] 111.55.136.135 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230319&time=140301&v1=-00.203&v2=+00.001&v3=+00.020&v4=-00.018&v5=06.0&t=+19.6&h=64.0&rssi=+223&ccid=4600485905031430000099m9990000000038000000g2340,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009808s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230319',`time`='140301',`v1`=-0.203,`v2`=0.001,`v3`=0.02,`v4`=-0.018,`v5`=6,`t`=19.6,`h`=64,`rssi`=223,`ccid`='4600485905031430000099m9990000000038000000g2340,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679205843 WHERE `imei` = '868922055644013' [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009784s ] [ 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' , '230319' , '140301' , -0.203 , 0.001 , 0.02 , -0.018 , 6 , 19.6 , 64 , 223 , '4600485905031430000099m9990000000038000000g2340,N,00E000=-00.000' , 0 , 0 , 1679205843 , 1679205843) [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-03-19T14:04:03+08:00 ] 39.144.14.79 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230319&time=140301&v1=-01.290&v2=+00.040&v3=-00.946&v4=-00.022&v5=05.7&t=+17.8&h=60.0&rssi=+231&ccid=4600485905031420000099m9990000000334000001g3000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&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.011125s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001158s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230319',`time`='140301',`v1`=-1.29,`v2`=0.04,`v3`=-0.946,`v4`=-0.022,`v5`=5.7,`t`=17.8,`h`=60,`rssi`=231,`ccid`='4600485905031420000099m9990000000334000001g3000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679205843 WHERE `imei` = '868922055643643' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011338s ] [ 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' , '230319' , '140301' , -1.29 , 0.04 , -0.946 , -0.022 , 5.7 , 17.8 , 60 , 231 , '4600485905031420000099m9990000000334000001g3000,N,00E000=-00.000' , 0 , 0 , 1679205843 , 1679205843) [ RunTime:0.001284s ] --------------------------------------------------------------- [ 2023-03-19T14:32:24+08:00 ] 39.144.13.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013170s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-03-19T14:32:25+08:00 ] 39.144.13.176 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679207544&v1=0.028204&v2=1.083449&v3=0.028896&v4=0.028023&v5=12.420000&t=16.492426&h=40.852112&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010918s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679207544,`v1`=0.028204,`v2`=1.083449,`v3`=0.028896,`v4`=0.028023,`v5`=12.42,`t`=16.492426,`h`=40.852112,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679207545 WHERE `imei` = '868922056976109' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012130s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679207544 , 0.028204 , 1.083449 , 0.028896 , 0.028023 , 12.42 , 16.492426 , 40.852112 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679207545) [ RunTime:0.000635s ]