--------------------------------------------------------------- [ 2023-06-12T00:14:24+08:00 ] 39.144.1.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010914s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-06-12T00:14:25+08:00 ] 39.144.1.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686500064&v1=0.021221&v2=0.014186&v3=0.018572&v4=-0.006291&v5=12.240000&t=25.362083&h=79.083008&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012421s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686500064,`v1`=0.021221,`v2`=0.014186,`v3`=0.018572,`v4`=-0.006291,`v5`=12.24,`t`=25.362083,`h`=79.083008,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1686500065 WHERE `imei` = '868922055680850' [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011388s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1686500064 , 0.021221 , 0.014186 , 0.018572 , -0.006291 , 12.24 , 25.362083 , 79.083008 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1686500065) [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-06-12T02:03:54+08:00 ] 111.55.137.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013243s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-06-12T02:03:55+08:00 ] 39.144.5.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002064s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010986s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-06-12T02:04:03+08:00 ] 111.55.137.118 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230612&time=020301&v1=-01.387&v2=+00.011&v3=-01.005&v4=-00.044&v5=06.2&t=+20.1&h=60.1&rssi=+227&ccid=4600485905031420000099m9990000000386000001g3960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001811s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230612',`time`='020301',`v1`=-1.387,`v2`=0.011,`v3`=-1.005,`v4`=-0.044,`v5`=6.2,`t`=20.1,`h`=60.1,`rssi`=227,`ccid`='4600485905031420000099m9990000000386000001g3960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686506643 WHERE `imei` = '868922055643643' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010996s ] [ 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' , '230612' , '020301' , -1.387 , 0.011 , -1.005 , -0.044 , 6.2 , 20.1 , 60.1 , 227 , '4600485905031420000099m9990000000386000001g3960,N,00E000=-00.000' , 0 , 0 , 1686506643 , 1686506643) [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-06-12T02:04:03+08:00 ] 39.144.5.247 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230612&time=020301&v1=-00.500&v2=+00.001&v3=-00.016&v4=-00.001&v5=06.0&t=+20.3&h=63.1&rssi=+222&ccid=4600485905031430000099m9990000000039000000g5240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011446s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230612',`time`='020301',`v1`=-0.5,`v2`=0.001,`v3`=-0.016,`v4`=-0.001,`v5`=6,`t`=20.3,`h`=63.1,`rssi`=222,`ccid`='4600485905031430000099m9990000000039000000g5240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686506643 WHERE `imei` = '868922055644013' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012616s ] [ 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' , '230612' , '020301' , -0.5 , 0.001 , -0.016 , -0.001 , 6 , 20.3 , 63.1 , 222 , '4600485905031430000099m9990000000039000000g5240,N,00E000=-00.000' , 0 , 0 , 1686506643 , 1686506643) [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2023-06-12T11:32:29+08:00 ] 39.144.18.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002952s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001341s ] --------------------------------------------------------------- [ 2023-06-12T11:32:31+08:00 ] 39.144.18.68 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686540749&v1=0.030672&v2=0.013456&v3=0.026579&v4=0.001475&v5=12.240000&t=26.327341&h=79.029602&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002034s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010044s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686540749,`v1`=0.030672,`v2`=0.013456,`v3`=0.026579,`v4`=0.001475,`v5`=12.24,`t`=26.327341,`h`=79.029602,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686540751 WHERE `imei` = '868922055678110' [ RunTime:0.000752s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016114s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686540749 , 0.030672 , 0.013456 , 0.026579 , 0.001475 , 12.24 , 26.327341 , 79.029602 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1686540751) [ RunTime:0.001306s ] --------------------------------------------------------------- [ 2023-06-12T14:03:54+08:00 ] 39.144.8.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012001s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001282s ] --------------------------------------------------------------- [ 2023-06-12T14:03:54+08:00 ] 39.144.14.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010598s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-06-12T14:04:03+08:00 ] 39.144.8.35 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230612&time=140301&v1=-01.387&v2=+00.022&v3=-01.008&v4=-00.044&v5=06.4&t=+31.2&h=56.9&rssi=+227&ccid=4600485905031420000099m9990000000380000001g3940,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010606s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230612',`time`='140301',`v1`=-1.387,`v2`=0.022,`v3`=-1.008,`v4`=-0.044,`v5`=6.4,`t`=31.2,`h`=56.9,`rssi`=227,`ccid`='4600485905031420000099m9990000000380000001g3940,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686549843 WHERE `imei` = '868922055643643' [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011581s ] [ 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' , '230612' , '140301' , -1.387 , 0.022 , -1.008 , -0.044 , 6.4 , 31.2 , 56.9 , 227 , '4600485905031420000099m9990000000380000001g3940,N,00E000=-00.000' , 0 , 0 , 1686549843 , 1686549843) [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-06-12T14:04:03+08:00 ] 39.144.14.181 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230612&time=140301&v1=-00.438&v2=+00.001&v3=+00.020&v4=+00.000&v5=06.0&t=+31.0&h=60.5&rssi=+224&ccid=4600485905031430000099m9990000000043000000g4610,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000967s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230612',`time`='140301',`v1`=-0.438,`v2`=0.001,`v3`=0.02,`v4`=0,`v5`=6,`t`=31,`h`=60.5,`rssi`=224,`ccid`='4600485905031430000099m9990000000043000000g4610,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686549843 WHERE `imei` = '868922055644013' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010401s ] [ 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' , '230612' , '140301' , -0.438 , 0.001 , 0.02 , 0 , 6 , 31 , 60.5 , 224 , '4600485905031430000099m9990000000043000000g4610,N,00E000=-00.000' , 0 , 0 , 1686549843 , 1686549843) [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2023-06-12T14:59:23+08:00 ] 39.144.16.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002473s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011844s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2023-06-12T14:59:25+08:00 ] 39.144.16.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686553163&v1=0.016766&v2=0.013873&v3=0.014358&v4=-0.011769&v5=12.420000&t=25.415709&h=78.091187&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002244s ] 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` = '868922055684548' LIMIT 1 [ RunTime:0.001005s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686553163,`v1`=0.016766,`v2`=0.013873,`v3`=0.014358,`v4`=-0.011769,`v5`=12.42,`t`=25.415709,`h`=78.091187,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686553165 WHERE `imei` = '868922055684548' [ RunTime:0.000766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013315s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686553163 , 0.016766 , 0.013873 , 0.014358 , -0.011769 , 12.42 , 25.415709 , 78.091187 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1686553165) [ RunTime:0.001117s ] --------------------------------------------------------------- [ 2023-06-12T15:20:14+08:00 ] 36.7.131.154 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002163s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013830s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001214s ] --------------------------------------------------------------- [ 2023-06-12T15:20:15+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.019895s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001130s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000759s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2023-06-12T15:21:50+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010638s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000523s ] [ 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.000618s ] --------------------------------------------------------------- [ 2023-06-12T15:21:52+08:00 ] 36.7.131.154 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009439s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000545s ] --------------------------------------------------------------- [ 2023-06-12T15:21:56+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010693s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000572s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2023-06-12T15:21:59+08:00 ] 36.7.131.154 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.020730s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-06-12T15:24:00+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010040s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000568s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000574s ] --------------------------------------------------------------- [ 2023-06-12T15:24:10+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010332s ] [ 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.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-06-12T15:24:11+08:00 ] 36.7.131.154 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010408s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2023-06-12T16:15:42+08:00 ] 36.7.131.154 GET /home/device/group.html?cmd=redirect&arubalp=12345 [ sql ] [ DB ] CONNECT:[ UseTime:0.002359s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012505s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2023-06-12T16:15:44+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012812s ] [ 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.000596s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000572s ] --------------------------------------------------------------- [ 2023-06-12T16:15:45+08:00 ] 36.7.131.154 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011765s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-06-12T16:44:58+08:00 ] 36.7.131.154 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002184s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009016s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-06-12T16:45:02+08:00 ] 36.7.131.154 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011827s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-06-12T16:45:04+08:00 ] 36.7.131.154 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011485s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-06-12T17:11:22+08:00 ] 117.132.191.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002271s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013154s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-06-12T17:11:24+08:00 ] 117.132.191.109 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686561082&v1=0.018452&v2=0.016272&v3=0.015923&v4=-0.000151&v5=12.240000&t=26.080664&h=79.296631&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000904s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686561082,`v1`=0.018452,`v2`=0.016272,`v3`=0.015923,`v4`=-0.000151,`v5`=12.24,`t`=26.080664,`h`=79.296631,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1686561084 WHERE `imei` = '868922055647586' [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011461s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1686561082 , 0.018452 , 0.016272 , 0.015923 , -0.000151 , 12.24 , 26.080664 , 79.296631 , 28 , '898604650119C1078512' , '460048590708512' , -0 , 1686561084) [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2023-06-12T17:52:04+08:00 ] 117.132.197.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2023-06-12T17:52:06+08:00 ] 117.132.197.118 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686563524&v1=0.026819&v2=0.013039&v3=0.027181&v4=0.015803&v5=12.420000&t=26.112839&h=77.328247&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184935,35.985914&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010008s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686563524,`v1`=0.026819,`v2`=0.013039,`v3`=0.027181,`v4`=0.015803,`v5`=12.42,`t`=26.112839,`h`=77.328247,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184935,35.985914',`update_time`=1686563526 WHERE `imei` = '868922056976208' [ RunTime:0.000798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012368s ] [ 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' , 1686563524 , 0.026819 , 0.013039 , 0.027181 , 0.015803 , 12.42 , 26.112839 , 77.328247 , 26 , '898604650119C1053139' , '460048590503139' , -0 , '120.184935,35.985914' , 1686563526) [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-06-12T17:59:20+08:00 ] 117.132.197.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.003075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000787s ] --------------------------------------------------------------- [ 2023-06-12T17:59:21+08:00 ] 117.132.197.57 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686563960&v1=0.020920&v2=0.014603&v3=0.017007&v4=-0.006833&v5=12.420000&t=26.123564&h=79.441589&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010825s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000804s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686563960,`v1`=0.02092,`v2`=0.014603,`v3`=0.017007,`v4`=-0.006833,`v5`=12.42,`t`=26.123564,`h`=79.441589,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686563961 WHERE `imei` = '868922055684209' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011255s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686563960 , 0.02092 , 0.014603 , 0.017007 , -0.006833 , 12.42 , 26.123564 , 79.441589 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1686563961) [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-06-12T18:24:20+08:00 ] 221.178.127.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011817s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-06-12T18:24:21+08:00 ] 221.178.127.104 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686565460&v1=0.019054&v2=0.015125&v3=0.016344&v4=-0.004726&v5=12.420000&t=25.994864&h=83.309692&rssi=26&ccid=89860426102071188500&imsi=460044618415250&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.011953s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686565460,`v1`=0.019054,`v2`=0.015125,`v3`=0.016344,`v4`=-0.004726,`v5`=12.42,`t`=25.994864,`h`=83.309692,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686565461 WHERE `imei` = '868922055683920' [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013050s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686565460 , 0.019054 , 0.015125 , 0.016344 , -0.004726 , 12.42 , 25.994864 , 83.309692 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686565461) [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-06-12T21:09:19+08:00 ] 117.132.194.105 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2023-06-12T21:09:20+08:00 ] 117.132.194.105 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686575359&v1=0.031876&v2=0.013456&v3=0.028926&v4=0.008037&v5=12.420000&t=25.662386&h=81.837219&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185332,35.985489&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010244s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686575359,`v1`=0.031876,`v2`=0.013456,`v3`=0.028926,`v4`=0.008037,`v5`=12.42,`t`=25.662386,`h`=81.837219,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185332,35.985489',`update_time`=1686575360 WHERE `imei` = '868922055683912' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011735s ] [ 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' , 1686575359 , 0.031876 , 0.013456 , 0.028926 , 0.008037 , 12.42 , 25.662386 , 81.837219 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185332,35.985489' , 1686575360) [ RunTime:0.001821s ] --------------------------------------------------------------- [ 2023-06-12T21:16:24+08:00 ] 39.144.11.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010917s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-06-12T21:16:25+08:00 ] 39.144.11.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686575784&v1=0.019475&v2=0.014707&v3=0.015953&v4=-0.017308&v5=12.420000&t=25.640936&h=82.775635&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014259s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000972s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686575784,`v1`=0.019475,`v2`=0.014707,`v3`=0.015953,`v4`=-0.017308,`v5`=12.42,`t`=25.640936,`h`=82.775635,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1686575785 WHERE `imei` = '868922055683771' [ RunTime:0.001261s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015843s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1686575784 , 0.019475 , 0.014707 , 0.015953 , -0.017308 , 12.42 , 25.640936 , 82.775635 , 27 , '898604650119C1053136' , '460048590503136' , -0 , 1686575785) [ RunTime:0.001009s ] --------------------------------------------------------------- [ 2023-06-12T22:11:50+08:00 ] 117.132.192.228 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002341s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.019447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2023-06-12T22:11:59+08:00 ] 117.132.192.228 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230612&time=221101&v1=-01.184&v2=+00.021&v3=-01.057&v4=-00.236&v5=06.0&t=+22.3&h=78.5&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.242&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011126s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230612',`time`='221101',`v1`=-1.184,`v2`=0.021,`v3`=-1.057,`v4`=-0.236,`v5`=6,`t`=22.3,`h`=78.5,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.242,`update_time`=1686579119 WHERE `imei` = '868922055684076' [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010913s ] [ 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' , '230612' , '221101' , -1.184 , 0.021 , -1.057 , -0.236 , 6 , 22.3 , 78.5 , 227 , '460044618415249' , -0 , 0.155 , 1.242 , 1686579119 , 1686579119) [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2023-06-12T23:54:23+08:00 ] 117.132.192.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011877s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001032s ] --------------------------------------------------------------- [ 2023-06-12T23:54:25+08:00 ] 117.132.192.179 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686585263&v1=0.007796&v2=0.014916&v3=0.005177&v4=-0.015923&v5=12.420000&t=25.469334&h=80.860657&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002466s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010316s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686585263,`v1`=0.007796,`v2`=0.014916,`v3`=0.005177,`v4`=-0.015923,`v5`=12.42,`t`=25.469334,`h`=80.860657,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686585265 WHERE `imei` = '868922055644021' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013226s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686585263 , 0.007796 , 0.014916 , 0.005177 , -0.015923 , 12.42 , 25.469334 , 80.860657 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686585265) [ RunTime:0.000670s ]