--------------------------------------------------------------- [ 2023-05-30T00:01:23+08:00 ] 221.178.127.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000848s ] --------------------------------------------------------------- [ 2023-05-30T00:01:24+08:00 ] 221.178.127.186 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1685376083&v1=0.021221&v2=0.012413&v3=0.018452&v4=-0.006291&v5=12.240000&t=22.745159&h=79.212708&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010029s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1685376083,`v1`=0.021221,`v2`=0.012413,`v3`=0.018452,`v4`=-0.006291,`v5`=12.24,`t`=22.745159,`h`=79.212708,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1685376084 WHERE `imei` = '868922055680850' [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010363s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1685376083 , 0.021221 , 0.012413 , 0.018452 , -0.006291 , 12.24 , 22.745159 , 79.212708 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1685376084) [ RunTime:0.001101s ] --------------------------------------------------------------- [ 2023-05-30T02:03:54+08:00 ] 223.104.255.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-05-30T02:03:55+08:00 ] 223.104.255.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.009852s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001104s ] --------------------------------------------------------------- [ 2023-05-30T02:04:03+08:00 ] 223.104.255.249 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230530&time=020301&v1=-01.376&v2=+00.016&v3=-00.970&v4=-00.045&v5=05.7&t=+19.0&h=59.8&rssi=+228&ccid=4600485905031420000099m9990000000408000001g3840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010925s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230530',`time`='020301',`v1`=-1.376,`v2`=0.016,`v3`=-0.97,`v4`=-0.045,`v5`=5.7,`t`=19,`h`=59.8,`rssi`=228,`ccid`='4600485905031420000099m9990000000408000001g3840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685383443 WHERE `imei` = '868922055643643' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010708s ] [ 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' , '230530' , '020301' , -1.376 , 0.016 , -0.97 , -0.045 , 5.7 , 19 , 59.8 , 228 , '4600485905031420000099m9990000000408000001g3840,N,00E000=-00.000' , 0 , 0 , 1685383443 , 1685383443) [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-05-30T02:04:03+08:00 ] 223.104.255.27 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230530&time=020301&v1=-00.295&v2=+00.001&v3=-00.077&v4=-00.003&v5=06.0&t=+19.2&h=62.5&rssi=+225&ccid=4600485905031430000099m9990000000030000000g3100,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230530',`time`='020301',`v1`=-0.295,`v2`=0.001,`v3`=-0.077,`v4`=-0.003,`v5`=6,`t`=19.2,`h`=62.5,`rssi`=225,`ccid`='4600485905031430000099m9990000000030000000g3100,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685383443 WHERE `imei` = '868922055644013' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010560s ] [ 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' , '230530' , '020301' , -0.295 , 0.001 , -0.077 , -0.003 , 6 , 19.2 , 62.5 , 225 , '4600485905031430000099m9990000000030000000g3100,N,00E000=-00.000' , 0 , 0 , 1685383443 , 1685383443) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2023-05-30T11:19:29+08:00 ] 39.144.14.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012291s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001289s ] --------------------------------------------------------------- [ 2023-05-30T11:19:30+08:00 ] 39.144.14.40 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1685416769&v1=0.029528&v2=0.014603&v3=0.036060&v4=0.001415&v5=12.420000&t=23.731867&h=78.877014&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001575s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1685416769,`v1`=0.029528,`v2`=0.014603,`v3`=0.03606,`v4`=0.001415,`v5`=12.42,`t`=23.731867,`h`=78.877014,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1685416770 WHERE `imei` = '868922055678110' [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015259s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1685416769 , 0.029528 , 0.014603 , 0.03606 , 0.001415 , 12.42 , 23.731867 , 78.877014 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1685416770) [ RunTime:0.001162s ] --------------------------------------------------------------- [ 2023-05-30T14:03:54+08:00 ] 221.178.126.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ 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.013299s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001453s ] --------------------------------------------------------------- [ 2023-05-30T14:03:55+08:00 ] 117.132.194.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010280s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-05-30T14:04:03+08:00 ] 221.178.126.179 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230530&time=140301&v1=-01.377&v2=+00.028&v3=-00.962&v4=-00.044&v5=06.2&t=+26.3&h=57.9&rssi=+228&ccid=4600485905031420000099m9990000000414000001g3840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011046s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001005s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230530',`time`='140301',`v1`=-1.377,`v2`=0.028,`v3`=-0.962,`v4`=-0.044,`v5`=6.2,`t`=26.3,`h`=57.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000414000001g3840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685426643 WHERE `imei` = '868922055643643' [ RunTime:0.000734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012247s ] [ 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' , '230530' , '140301' , -1.377 , 0.028 , -0.962 , -0.044 , 6.2 , 26.3 , 57.9 , 228 , '4600485905031420000099m9990000000414000001g3840,N,00E000=-00.000' , 0 , 0 , 1685426643 , 1685426643) [ RunTime:0.001018s ] --------------------------------------------------------------- [ 2023-05-30T14:04:03+08:00 ] 117.132.194.13 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230530&time=140301&v1=-00.298&v2=+00.001&v3=+00.014&v4=-00.003&v5=06.0&t=+25.9&h=60.7&rssi=+223&ccid=4600485905031430000099m9990000000041000000g3260,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011359s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230530',`time`='140301',`v1`=-0.298,`v2`=0.001,`v3`=0.014,`v4`=-0.003,`v5`=6,`t`=25.9,`h`=60.7,`rssi`=223,`ccid`='4600485905031430000099m9990000000041000000g3260,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685426643 WHERE `imei` = '868922055644013' [ RunTime:0.000549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011030s ] [ 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' , '230530' , '140301' , -0.298 , 0.001 , 0.014 , -0.003 , 6 , 25.9 , 60.7 , 223 , '4600485905031430000099m9990000000041000000g3260,N,00E000=-00.000' , 0 , 0 , 1685426643 , 1685426643) [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2023-05-30T14:46:23+08:00 ] 39.144.5.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.003016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012134s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.001048s ] --------------------------------------------------------------- [ 2023-05-30T14:46:25+08:00 ] 39.144.5.150 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1685429183&v1=0.016766&v2=0.013456&v3=0.014358&v4=-0.011769&v5=12.420000&t=24.471899&h=77.297729&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002015s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009279s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1685429183,`v1`=0.016766,`v2`=0.013456,`v3`=0.014358,`v4`=-0.011769,`v5`=12.42,`t`=24.471899,`h`=77.297729,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1685429185 WHERE `imei` = '868922055684548' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009871s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1685429183 , 0.016766 , 0.013456 , 0.014358 , -0.011769 , 12.42 , 24.471899 , 77.297729 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1685429185) [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2023-05-30T14:58:58+08:00 ] 183.162.198.48 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002090s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011560s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001316s ] --------------------------------------------------------------- [ 2023-05-30T14:58:59+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011882s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000567s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2023-05-30T14:59:10+08:00 ] 183.162.198.39 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011250s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000498s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000589s ] --------------------------------------------------------------- [ 2023-05-30T14:59:33+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010195s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001054s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000603s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2023-05-30T14:59:36+08:00 ] 183.162.198.33 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001415s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008976s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2023-05-30T14:59:39+08:00 ] 183.162.198.33 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009858s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-05-30T15:00:25+08:00 ] 183.162.198.36 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001952s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012146s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000598s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2023-05-30T15:00:30+08:00 ] 183.162.198.36 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002057s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010400s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-05-30T15:00:36+08:00 ] 183.162.198.46 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009920s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2023-05-30T15:08:01+08:00 ] 183.162.198.41 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009506s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000662s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-05-30T15:08:26+08:00 ] 183.162.198.48 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009478s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2023-05-30T15:08:29+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009383s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000556s ] --------------------------------------------------------------- [ 2023-05-30T15:08:31+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011107s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-05-30T15:08:31+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002031s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010708s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000551s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-05-30T15:08:32+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000615s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2023-05-30T15:08:47+08:00 ] 183.162.198.48 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001701s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009525s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-05-30T15:08:49+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012134s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-05-30T15:08:52+08:00 ] 183.162.198.48 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004295s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012518s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-05-30T15:08:57+08:00 ] 183.162.198.48 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004350s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012007s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000585s ] --------------------------------------------------------------- [ 2023-05-30T15:09:01+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010797s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000588s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-05-30T15:09:38+08:00 ] 183.162.198.42 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005776s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011538s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000649s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2023-05-30T15:11:57+08:00 ] 183.162.198.24 GET /home/device/index.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_device` [ RunTime:0.011183s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-05-30T15:13:46+08:00 ] 183.162.198.35 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009751s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001031s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000766s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2023-05-30T15:13:50+08:00 ] 183.162.198.35 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008548s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2023-05-30T16:20:03+08:00 ] 183.162.198.21 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002213s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011372s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2023-05-30T16:22:44+08:00 ] 183.162.198.9 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001602s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008313s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2023-05-30T16:22:48+08:00 ] 183.162.198.14 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010779s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-05-30T17:00:55+08:00 ] 39.144.7.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002370s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.001137s ] --------------------------------------------------------------- [ 2023-05-30T17:00:56+08:00 ] 39.144.7.182 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1685437255&v1=0.018331&v2=0.015125&v3=0.015682&v4=0.000030&v5=12.420000&t=24.643501&h=79.731506&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184567,35.984555&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001973s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010488s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1685437255,`v1`=0.018331,`v2`=0.015125,`v3`=0.015682,`v4`=3.0E-5,`v5`=12.42,`t`=24.643501,`h`=79.731506,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184567,35.984555',`update_time`=1685437256 WHERE `imei` = '868922055647586' [ RunTime:0.000984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009639s ] [ 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' , 1685437255 , 0.018331 , 0.015125 , 0.015682 , 3.0E-5 , 12.42 , 24.643501 , 79.731506 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.184567,35.984555' , 1685437256) [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-05-30T17:41:18+08:00 ] 223.104.255.51 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-05-30T17:41:20+08:00 ] 223.104.255.51 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1685439678&v1=0.027181&v2=0.012726&v3=0.027241&v4=0.015742&v5=12.240000&t=24.353924&h=77.488464&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.186496,35.986317&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1685439678,`v1`=0.027181,`v2`=0.012726,`v3`=0.027241,`v4`=0.015742,`v5`=12.24,`t`=24.353924,`h`=77.488464,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.186496,35.986317',`update_time`=1685439680 WHERE `imei` = '868922056976208' [ RunTime:0.000729s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009811s ] [ 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' , 1685439678 , 0.027181 , 0.012726 , 0.027241 , 0.015742 , 12.24 , 24.353924 , 77.488464 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.186496,35.986317' , 1685439680) [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-05-30T17:46:21+08:00 ] 117.132.194.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010941s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2023-05-30T17:46:22+08:00 ] 117.132.194.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1685439981&v1=0.019475&v2=0.013977&v3=0.016886&v4=-0.006893&v5=12.420000&t=24.428999&h=79.449219&rssi=28&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009994s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1685439981,`v1`=0.019475,`v2`=0.013977,`v3`=0.016886,`v4`=-0.006893,`v5`=12.42,`t`=24.428999,`h`=79.449219,`rssi`=28,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1685439982 WHERE `imei` = '868922055684209' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011599s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1685439981 , 0.019475 , 0.013977 , 0.016886 , -0.006893 , 12.42 , 24.428999 , 79.449219 , 28 , '898604650119C1078511' , '460048590708511' , -0 , 1685439982) [ RunTime:0.000627s ] --------------------------------------------------------------- [ 2023-05-30T18:05:50+08:00 ] 111.55.138.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003137s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008881s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-05-30T18:05:58+08:00 ] 111.55.138.143 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230530&time=180501&v1=-01.269&v2=+00.014&v3=-01.158&v4=-00.631&v5=06.0&t=+25.2&h=77.6&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.128&a2=01.290&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.012902s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009499s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230530',`time`='180501',`v1`=-1.269,`v2`=0.014,`v3`=-1.158,`v4`=-0.631,`v5`=6,`t`=25.2,`h`=77.6,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.128,`a2`=1.29,`update_time`=1685441158 WHERE `imei` = '868922055684076' [ RunTime:0.000907s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008261s ] [ 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' , '230530' , '180501' , -1.269 , 0.014 , -1.158 , -0.631 , 6 , 25.2 , 77.6 , 228 , '460044618415249' , -0 , 0.128 , 1.29 , 1685441158 , 1685441158) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-05-30T18:11:27+08:00 ] 111.55.139.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002844s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011498s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000660s ] --------------------------------------------------------------- [ 2023-05-30T18:11:28+08:00 ] 111.55.139.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1685441487&v1=0.018813&v2=0.013351&v3=0.016284&v4=-0.004666&v5=12.420000&t=24.193047&h=82.371277&rssi=27&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009565s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1685441487,`v1`=0.018813,`v2`=0.013351,`v3`=0.016284,`v4`=-0.004666,`v5`=12.42,`t`=24.193047,`h`=82.371277,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1685441488 WHERE `imei` = '868922055683920' [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011592s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1685441487 , 0.018813 , 0.013351 , 0.016284 , -0.004666 , 12.42 , 24.193047 , 82.371277 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1685441488) [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2023-05-30T20:56:56+08:00 ] 39.144.4.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002301s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012401s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000848s ] --------------------------------------------------------------- [ 2023-05-30T20:56:58+08:00 ] 39.144.4.123 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1685451416&v1=0.031756&v2=0.013143&v3=0.028836&v4=0.008278&v5=12.420000&t=23.560266&h=81.059021&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185025,35.985754&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009580s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1685451416,`v1`=0.031756,`v2`=0.013143,`v3`=0.028836,`v4`=0.008278,`v5`=12.42,`t`=23.560266,`h`=81.059021,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185025,35.985754',`update_time`=1685451417 WHERE `imei` = '868922055683912' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011422s ] [ 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' , 1685451416 , 0.031756 , 0.013143 , 0.028836 , 0.008278 , 12.42 , 23.560266 , 81.059021 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185025,35.985754' , 1685451418) [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2023-05-30T21:03:06+08:00 ] 117.132.193.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010172s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-05-30T21:03:07+08:00 ] 117.132.193.116 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1685451786&v1=0.019294&v2=0.015229&v3=0.016164&v4=-0.017247&v5=12.240000&t=23.538816&h=81.944031&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185711,35.990644&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001783s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010887s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1685451786,`v1`=0.019294,`v2`=0.015229,`v3`=0.016164,`v4`=-0.017247,`v5`=12.24,`t`=23.538816,`h`=81.944031,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185711,35.990644',`update_time`=1685451787 WHERE `imei` = '868922055683771' [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011166s ] [ 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' , 1685451786 , 0.019294 , 0.015229 , 0.016164 , -0.017247 , 12.24 , 23.538816 , 81.944031 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.185711,35.990644' , 1685451787) [ RunTime:0.000517s ] --------------------------------------------------------------- [ 2023-05-30T23:41:23+08:00 ] 223.104.255.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002317s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012900s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2023-05-30T23:41:25+08:00 ] 223.104.255.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1685461283&v1=0.006893&v2=0.013351&v3=0.004967&v4=-0.015923&v5=12.420000&t=23.217064&h=80.402893&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001832s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1685461283,`v1`=0.006893,`v2`=0.013351,`v3`=0.004967,`v4`=-0.015923,`v5`=12.42,`t`=23.217064,`h`=80.402893,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1685461285 WHERE `imei` = '868922055644021' [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012544s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1685461283 , 0.006893 , 0.013351 , 0.004967 , -0.015923 , 12.42 , 23.217064 , 80.402893 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1685461285) [ RunTime:0.000692s ]