--------------------------------------------------------------- [ 2023-07-08T00:19:23+08:00 ] 111.55.141.229 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002816s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011572s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-07-08T00:19:25+08:00 ] 111.55.141.229 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1688746763&v1=0.008097&v2=0.014290&v3=0.007134&v4=-0.015923&v5=12.420000&t=28.869190&h=81.593079&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009918s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1688746763,`v1`=0.008097,`v2`=0.01429,`v3`=0.007134,`v4`=-0.015923,`v5`=12.42,`t`=28.86919,`h`=81.593079,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1688746765 WHERE `imei` = '868922055644021' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010732s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1688746763 , 0.008097 , 0.01429 , 0.007134 , -0.015923 , 12.42 , 28.86919 , 81.593079 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1688746765) [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-07-08T00:39:23+08:00 ] 117.132.193.205 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002487s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-07-08T00:39:24+08:00 ] 117.132.193.205 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1688747963&v1=0.021462&v2=0.012726&v3=0.019565&v4=-0.006893&v5=12.240000&t=28.826288&h=78.892273&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002261s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1688747963,`v1`=0.021462,`v2`=0.012726,`v3`=0.019565,`v4`=-0.006893,`v5`=12.24,`t`=28.826288,`h`=78.892273,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1688747964 WHERE `imei` = '868922055680850' [ RunTime:0.000556s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011674s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1688747963 , 0.021462 , 0.012726 , 0.019565 , -0.006893 , 12.24 , 28.826288 , 78.892273 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1688747964) [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2023-07-08T02:03:54+08:00 ] 39.144.15.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012432s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-07-08T02:03:55+08:00 ] 117.132.197.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009373s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2023-07-08T02:04:02+08:00 ] 39.144.15.72 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230708&time=020301&v1=-01.340&v2=+00.022&v3=-01.065&v4=-00.028&v5=06.2&t=+26.2&h=60.1&rssi=+227&ccid=4600485905031420000099m9990000000278000001g3450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.010833s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230708',`time`='020301',`v1`=-1.34,`v2`=0.022,`v3`=-1.065,`v4`=-0.028,`v5`=6.2,`t`=26.2,`h`=60.1,`rssi`=227,`ccid`='4600485905031420000099m9990000000278000001g3450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688753042 WHERE `imei` = '868922055643643' [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012702s ] [ 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' , '230708' , '020301' , -1.34 , 0.022 , -1.065 , -0.028 , 6.2 , 26.2 , 60.1 , 227 , '4600485905031420000099m9990000000278000001g3450,N,00E000=-00.000' , 0 , 0 , 1688753042 , 1688753042) [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-07-08T02:04:03+08:00 ] 117.132.197.216 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230708&time=020301&v1=-00.517&v2=+00.001&v3=-00.477&v4=-00.003&v5=06.0&t=+25.9&h=63.7&rssi=+222&ccid=4600485905031430000099m9990000000006000000g5220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230708',`time`='020301',`v1`=-0.517,`v2`=0.001,`v3`=-0.477,`v4`=-0.003,`v5`=6,`t`=25.9,`h`=63.7,`rssi`=222,`ccid`='4600485905031430000099m9990000000006000000g5220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688753043 WHERE `imei` = '868922055644013' [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011540s ] [ 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' , '230708' , '020301' , -0.517 , 0.001 , -0.477 , -0.003 , 6 , 25.9 , 63.7 , 222 , '4600485905031430000099m9990000000006000000g5220,N,00E000=-00.000' , 0 , 0 , 1688753043 , 1688753043) [ RunTime:0.000526s ] --------------------------------------------------------------- [ 2023-07-08T02:09:50+08:00 ] 117.132.194.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011232s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2023-07-08T02:09:59+08:00 ] 117.132.194.76 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230708&time=020901&v1=-01.167&v2=+00.007&v3=-01.072&v4=-00.583&v5=06.0&t=+25.0&h=77.4&rssi=+231&imsi=460044618415249&v6=-00.000&a1=00.115&a2=01.211&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001977s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011153s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000895s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230708',`time`='020901',`v1`=-1.167,`v2`=0.007,`v3`=-1.072,`v4`=-0.583,`v5`=6,`t`=25,`h`=77.4,`rssi`=231,`imsi`='460044618415249',`v6`=-0,`a1`=0.115,`a2`=1.211,`update_time`=1688753399 WHERE `imei` = '868922055684076' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010187s ] [ 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' , '230708' , '020901' , -1.167 , 0.007 , -1.072 , -0.583 , 6 , 25 , 77.4 , 231 , '460044618415249' , -0 , 0.115 , 1.211 , 1688753399 , 1688753399) [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2023-07-08T11:58:28+08:00 ] 39.144.7.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001781s ] --------------------------------------------------------------- [ 2023-07-08T11:58:29+08:00 ] 39.144.7.240 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1688788708&v1=0.030793&v2=0.014395&v3=0.041268&v4=0.001355&v5=12.240000&t=29.963150&h=79.304260&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010855s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1688788708,`v1`=0.030793,`v2`=0.014395,`v3`=0.041268,`v4`=0.001355,`v5`=12.24,`t`=29.96315,`h`=79.30426,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1688788709 WHERE `imei` = '868922055678110' [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015970s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1688788708 , 0.030793 , 0.014395 , 0.041268 , 0.001355 , 12.24 , 29.96315 , 79.30426 , 28 , '898604650119C1078513' , '460048590708513' , -0 , 1688788709) [ RunTime:0.001275s ] --------------------------------------------------------------- [ 2023-07-08T14:03:54+08:00 ] 39.144.13.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002453s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001809s ] --------------------------------------------------------------- [ 2023-07-08T14:03:55+08:00 ] 117.132.198.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002112s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010711s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2023-07-08T14:04:02+08:00 ] 39.144.13.49 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230708&time=140301&v1=-01.334&v2=+00.036&v3=-01.060&v4=-00.029&v5=06.4&t=+37.7&h=57.8&rssi=+229&ccid=4600485905031420000099m9990000000276000001g3390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001948s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011245s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230708',`time`='140301',`v1`=-1.334,`v2`=0.036,`v3`=-1.06,`v4`=-0.029,`v5`=6.4,`t`=37.7,`h`=57.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000276000001g3390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688796242 WHERE `imei` = '868922055643643' [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010710s ] [ 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' , '230708' , '140301' , -1.334 , 0.036 , -1.06 , -0.029 , 6.4 , 37.7 , 57.8 , 229 , '4600485905031420000099m9990000000276000001g3390,N,00E000=-00.000' , 0 , 0 , 1688796242 , 1688796242) [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2023-07-08T14:04:03+08:00 ] 117.132.198.156 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230708&time=140301&v1=-00.493&v2=+00.002&v3=-00.311&v4=-00.002&v5=06.2&t=+35.9&h=62.5&rssi=+224&ccid=4600485905031430000099m9990000000094000000g5010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001484s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230708',`time`='140301',`v1`=-0.493,`v2`=0.002,`v3`=-0.311,`v4`=-0.002,`v5`=6.2,`t`=35.9,`h`=62.5,`rssi`=224,`ccid`='4600485905031430000099m9990000000094000000g5010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688796243 WHERE `imei` = '868922055644013' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010667s ] [ 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' , '230708' , '140301' , -0.493 , 0.002 , -0.311 , -0.002 , 6.2 , 35.9 , 62.5 , 224 , '4600485905031430000099m9990000000094000000g5010,N,00E000=-00.000' , 0 , 0 , 1688796243 , 1688796243) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-07-08T15:25:22+08:00 ] 39.144.2.88 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002131s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012102s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000889s ] --------------------------------------------------------------- [ 2023-07-08T15:25:23+08:00 ] 39.144.2.88 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1688801122&v1=0.017127&v2=0.014812&v3=0.017157&v4=-0.011649&v5=12.420000&t=30.499405&h=78.442139&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010668s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1688801122,`v1`=0.017127,`v2`=0.014812,`v3`=0.017157,`v4`=-0.011649,`v5`=12.42,`t`=30.499405,`h`=78.442139,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1688801123 WHERE `imei` = '868922055684548' [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011828s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1688801122 , 0.017127 , 0.014812 , 0.017157 , -0.011649 , 12.42 , 30.499405 , 78.442139 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1688801123) [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-07-08T17:36:04+08:00 ] 39.144.16.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012764s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-07-08T17:36:05+08:00 ] 39.144.16.124 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1688808964&v1=0.018271&v2=0.014603&v3=0.018722&v4=-0.000030&v5=12.420000&t=29.469795&h=79.212708&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184289,35.984526&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001795s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011226s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1688808964,`v1`=0.018271,`v2`=0.014603,`v3`=0.018722,`v4`=-3.0E-5,`v5`=12.42,`t`=29.469795,`h`=79.212708,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184289,35.984526',`update_time`=1688808965 WHERE `imei` = '868922055647586' [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011783s ] [ 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' , 1688808964 , 0.018271 , 0.014603 , 0.018722 , -3.0E-5 , 12.42 , 29.469795 , 79.212708 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.184289,35.984526' , 1688808965) [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2023-07-08T17:42:38+08:00 ] 220.178.4.248 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013340s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001174s ] --------------------------------------------------------------- [ 2023-07-08T17:42:39+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010360s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000596s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000608s ] --------------------------------------------------------------- [ 2023-07-08T17:45:52+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002190s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011960s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000515s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000618s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2023-07-08T17:45:54+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005077s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012574s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000589s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-07-08T17:45:55+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013147s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000606s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-07-08T17:45:56+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012598s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000845s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-07-08T17:45:57+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002286s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010697s ] [ 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.000553s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-07-08T17:46:00+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001909s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010251s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000478s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001107s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-07-08T17:48:08+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.023158s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000955s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000618s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2023-07-08T17:48:11+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001945s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011388s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000558s ] --------------------------------------------------------------- [ 2023-07-08T17:49:34+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010692s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000536s ] [ 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.000616s ] --------------------------------------------------------------- [ 2023-07-08T17:49:37+08:00 ] 220.178.4.248 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001696s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011082s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-07-08T17:49:43+08:00 ] 220.178.4.248 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010727s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2023-07-08T17:49:45+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010593s ] [ 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.000786s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001083s ] --------------------------------------------------------------- [ 2023-07-08T17:49:50+08:00 ] 220.178.4.248 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011317s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2023-07-08T17:50:30+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001949s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011268s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000598s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000601s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2023-07-08T17:55:57+08:00 ] 220.178.4.248 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011474s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-07-08T17:56:03+08:00 ] 220.178.4.248 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008449s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000466s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000543s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2023-07-08T17:56:05+08:00 ] 220.178.4.248 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002038s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010943s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2023-07-08T18:16:59+08:00 ] 111.55.136.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.020914s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013431s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2023-07-08T18:17:00+08:00 ] 111.55.136.67 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1688811419&v1=0.027783&v2=0.011995&v3=0.034826&v4=0.015622&v5=12.240000&t=29.448345&h=77.045959&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184984,35.989491&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1688811419,`v1`=0.027783,`v2`=0.011995,`v3`=0.034826,`v4`=0.015622,`v5`=12.24,`t`=29.448345,`h`=77.045959,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184984,35.989491',`update_time`=1688811420 WHERE `imei` = '868922056976208' [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013330s ] [ 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' , 1688811419 , 0.027783 , 0.011995 , 0.034826 , 0.015622 , 12.24 , 29.448345 , 77.045959 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184984,35.989491' , 1688811420) [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2023-07-08T18:25:22+08:00 ] 39.144.15.99 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.003454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010134s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-07-08T18:25:23+08:00 ] 39.144.15.99 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1688811922&v1=0.021281&v2=0.012413&v3=0.018783&v4=-0.006773&v5=12.420000&t=29.480520&h=79.250854&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001742s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010954s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000748s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1688811922,`v1`=0.021281,`v2`=0.012413,`v3`=0.018783,`v4`=-0.006773,`v5`=12.42,`t`=29.48052,`h`=79.250854,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1688811923 WHERE `imei` = '868922055684209' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011159s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1688811922 , 0.021281 , 0.012413 , 0.018783 , -0.006773 , 12.42 , 29.48052 , 79.250854 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1688811923) [ RunTime:0.014036s ] --------------------------------------------------------------- [ 2023-07-08T18:50:21+08:00 ] 39.144.7.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012270s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2023-07-08T18:50:23+08:00 ] 39.144.7.94 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1688813421&v1=0.019415&v2=0.014499&v3=0.018090&v4=-0.004545&v5=12.420000&t=29.448345&h=84.614319&rssi=25&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1688813421,`v1`=0.019415,`v2`=0.014499,`v3`=0.01809,`v4`=-0.004545,`v5`=12.42,`t`=29.448345,`h`=84.614319,`rssi`=25,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1688813423 WHERE `imei` = '868922055683920' [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011635s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1688813421 , 0.019415 , 0.014499 , 0.01809 , -0.004545 , 12.42 , 29.448345 , 84.614319 , 25 , '89860426102071188500' , '460044618415250' , -0 , 1688813423) [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-07-08T21:31:13+08:00 ] 111.55.138.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014756s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000791s ] --------------------------------------------------------------- [ 2023-07-08T21:31:15+08:00 ] 111.55.138.185 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1688823073&v1=0.032117&v2=0.015333&v3=0.033532&v4=0.007856&v5=12.600000&t=29.126593&h=83.027405&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185191,35.985388&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002421s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011984s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1688823073,`v1`=0.032117,`v2`=0.015333,`v3`=0.033532,`v4`=0.007856,`v5`=12.6,`t`=29.126593,`h`=83.027405,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185191,35.985388',`update_time`=1688823075 WHERE `imei` = '868922055683912' [ RunTime:0.000880s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011887s ] [ 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' , 1688823073 , 0.032117 , 0.015333 , 0.033532 , 0.007856 , 12.6 , 29.126593 , 83.027405 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185191,35.985388' , 1688823075) [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2023-07-08T21:40:57+08:00 ] 221.178.127.113 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002707s ] 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` = '868922055683771' LIMIT 1 [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-07-08T21:40:58+08:00 ] 221.178.127.113 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1688823657&v1=0.019535&v2=0.013664&v3=0.017338&v4=-0.017187&v5=12.420000&t=29.115868&h=84.080261&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.178443,35.985480&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001859s ] 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` = '868922055683771' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1688823657,`v1`=0.019535,`v2`=0.013664,`v3`=0.017338,`v4`=-0.017187,`v5`=12.42,`t`=29.115868,`h`=84.080261,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.178443,35.985480',`update_time`=1688823658 WHERE `imei` = '868922055683771' [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011296s ] [ 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' , 1688823657 , 0.019535 , 0.013664 , 0.017338 , -0.017187 , 12.42 , 29.115868 , 84.080261 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.178443,35.985480' , 1688823658) [ RunTime:0.001192s ]