---------------------------------------------------------------
[ 2023-06-07T00:09:18+08:00 ] 39.144.7.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010018s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000666s ]
---------------------------------------------------------------
[ 2023-06-07T00:09:19+08:00 ] 39.144.7.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686067758&v1=0.021341&v2=0.013456&v3=0.018572&v4=-0.006231&v5=12.420000&t=24.600601&h=79.144043&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.184764,35.986660&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009153s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000717s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686067758,`v1`=0.021341,`v2`=0.013456,`v3`=0.018572,`v4`=-0.006231,`v5`=12.42,`t`=24.600601,`h`=79.144043,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.184764,35.986660',`update_time`=1686067759 WHERE `imei` = '868922055680850' [ RunTime:0.000650s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010684s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1686067758 , 0.021341 , 0.013456 , 0.018572 , -0.006231 , 12.42 , 24.600601 , 79.144043 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.184764,35.986660' , 1686067759) [ RunTime:0.001221s ]
---------------------------------------------------------------
[ 2023-06-07T02:03:54+08:00 ] 218.204.252.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002853s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011789s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2023-06-07T02:03:55+08:00 ] 111.55.139.214 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002065s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011395s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000771s ]
---------------------------------------------------------------
[ 2023-06-07T02:04:03+08:00 ] 218.204.252.116 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230607&time=020301&v1=-01.384&v2=+00.014&v3=-00.987&v4=-00.042&v5=06.2&t=+21.8&h=59.9&rssi=+228&ccid=4600485905031420000099m9990000000399000001g3920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010337s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000709s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230607',`time`='020301',`v1`=-1.384,`v2`=0.014,`v3`=-0.987,`v4`=-0.042,`v5`=6.2,`t`=21.8,`h`=59.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000399000001g3920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686074643 WHERE `imei` = '868922055643643' [ RunTime:0.000639s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011233s ]
[ 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' , '230607' , '020301' , -1.384 , 0.014 , -0.987 , -0.042 , 6.2 , 21.8 , 59.9 , 228 , '4600485905031420000099m9990000000399000001g3920,N,00E000=-00.000' , 0 , 0 , 1686074643 , 1686074643) [ RunTime:0.001274s ]
---------------------------------------------------------------
[ 2023-06-07T02:04:03+08:00 ] 111.55.139.214 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230607&time=020301&v1=-00.472&v2=+00.001&v3=-00.110&v4=-00.002&v5=06.0&t=+21.9&h=62.9&rssi=+223&ccid=4600485905031430000099m9990000000036000000g4890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011035s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230607',`time`='020301',`v1`=-0.472,`v2`=0.001,`v3`=-0.11,`v4`=-0.002,`v5`=6,`t`=21.9,`h`=62.9,`rssi`=223,`ccid`='4600485905031430000099m9990000000036000000g4890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686074643 WHERE `imei` = '868922055644013' [ RunTime:0.000563s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010670s ]
[ 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' , '230607' , '020301' , -0.472 , 0.001 , -0.11 , -0.002 , 6 , 21.9 , 62.9 , 223 , '4600485905031430000099m9990000000036000000g4890,N,00E000=-00.000' , 0 , 0 , 1686074643 , 1686074643) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-06-07T11:27:27+08:00 ] 111.55.140.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012596s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000755s ]
---------------------------------------------------------------
[ 2023-06-07T11:27:28+08:00 ] 111.55.140.134 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686108447&v1=0.029468&v2=0.015855&v3=0.026549&v4=0.001475&v5=12.420000&t=25.673111&h=78.991455&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001730s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000713s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686108447,`v1`=0.029468,`v2`=0.015855,`v3`=0.026549,`v4`=0.001475,`v5`=12.42,`t`=25.673111,`h`=78.991455,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686108448 WHERE `imei` = '868922055678110' [ RunTime:0.000720s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011445s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686108447 , 0.029468 , 0.015855 , 0.026549 , 0.001475 , 12.42 , 25.673111 , 78.991455 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1686108448) [ RunTime:0.000923s ]
---------------------------------------------------------------
[ 2023-06-07T14:03:54+08:00 ] 39.144.11.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011983s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000672s ]
---------------------------------------------------------------
[ 2023-06-07T14:03:55+08:00 ] 39.144.8.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010895s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000706s ]
---------------------------------------------------------------
[ 2023-06-07T14:04:02+08:00 ] 39.144.11.76 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230607&time=140301&v1=-01.383&v2=+00.025&v3=-00.984&v4=-00.042&v5=06.4&t=+40.8&h=54.1&rssi=+227&ccid=4600485905031420000099m9990000000398000001g3900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010993s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000693s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230607',`time`='140301',`v1`=-1.383,`v2`=0.025,`v3`=-0.984,`v4`=-0.042,`v5`=6.4,`t`=40.8,`h`=54.1,`rssi`=227,`ccid`='4600485905031420000099m9990000000398000001g3900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686117842 WHERE `imei` = '868922055643643' [ RunTime:0.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012103s ]
[ 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' , '230607' , '140301' , -1.383 , 0.025 , -0.984 , -0.042 , 6.4 , 40.8 , 54.1 , 227 , '4600485905031420000099m9990000000398000001g3900,N,00E000=-00.000' , 0 , 0 , 1686117842 , 1686117842) [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2023-06-07T14:04:03+08:00 ] 39.144.8.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230607&time=140301&v1=-00.463&v2=+00.001&v3=+00.018&v4=-00.001&v5=06.2&t=+38.2&h=58.7&rssi=+222&ccid=4600485905031430000099m9990000000050000000g4830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009950s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230607',`time`='140301',`v1`=-0.463,`v2`=0.001,`v3`=0.018,`v4`=-0.001,`v5`=6.2,`t`=38.2,`h`=58.7,`rssi`=222,`ccid`='4600485905031430000099m9990000000050000000g4830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686117843 WHERE `imei` = '868922055644013' [ RunTime:0.000588s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009679s ]
[ 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' , '230607' , '140301' , -0.463 , 0.001 , 0.018 , -0.001 , 6.2 , 38.2 , 58.7 , 222 , '4600485905031430000099m9990000000050000000g4830,N,00E000=-00.000' , 0 , 0 , 1686117843 , 1686117843) [ RunTime:0.000512s ]
---------------------------------------------------------------
[ 2023-06-07T14:54:22+08:00 ] 111.55.141.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.006154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016113s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000774s ]
---------------------------------------------------------------
[ 2023-06-07T14:54:23+08:00 ] 111.55.141.122 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686120862&v1=0.016766&v2=0.013456&v3=0.014749&v4=-0.011769&v5=12.420000&t=26.391691&h=77.572388&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010657s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000672s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686120862,`v1`=0.016766,`v2`=0.013456,`v3`=0.014749,`v4`=-0.011769,`v5`=12.42,`t`=26.391691,`h`=77.572388,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686120863 WHERE `imei` = '868922055684548' [ RunTime:0.000603s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010865s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686120862 , 0.016766 , 0.013456 , 0.014749 , -0.011769 , 12.42 , 26.391691 , 77.572388 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1686120863) [ RunTime:0.001307s ]
---------------------------------------------------------------
[ 2023-06-07T15:50:32+08:00 ] 183.162.198.49 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014717s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001312s ]
---------------------------------------------------------------
[ 2023-06-07T15:50:34+08:00 ] 183.162.198.49 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001517s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013453s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001248s ]
[ 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.000634s ]
---------------------------------------------------------------
[ 2023-06-07T15:52:52+08:00 ] 183.162.198.46 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009121s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000593s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000896s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000656s ]
---------------------------------------------------------------
[ 2023-06-07T15:52:54+08:00 ] 183.162.198.46 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011050s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2023-06-07T15:53:03+08:00 ] 183.162.198.45 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009958s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000558s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000560s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2023-06-07T15:53:06+08:00 ] 183.162.198.45 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000537s ]
---------------------------------------------------------------
[ 2023-06-07T15:54:10+08:00 ] 183.162.198.12 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001746s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009893s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000605s ]
---------------------------------------------------------------
[ 2023-06-07T15:54:13+08:00 ] 183.162.198.12 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010759s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2023-06-07T15:55:12+08:00 ] 183.162.198.11 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010284s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2023-06-07T15:55:14+08:00 ] 183.162.198.11 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.009818s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2023-06-07T15:55:16+08:00 ] 183.162.198.11 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011221s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000554s ]
---------------------------------------------------------------
[ 2023-06-07T15:59:58+08:00 ] 183.162.198.50 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012783s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000588s ]
---------------------------------------------------------------
[ 2023-06-07T16:00:03+08:00 ] 183.162.198.50 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012683s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2023-06-07T16:00:04+08:00 ] 183.162.198.50 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001850s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009566s ]
[ 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.000589s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000551s ]
---------------------------------------------------------------
[ 2023-06-07T16:00:06+08:00 ] 183.162.198.50 GET /home/device/group.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002517s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012685s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2023-06-07T17:06:02+08:00 ] 221.178.126.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010836s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000696s ]
---------------------------------------------------------------
[ 2023-06-07T17:06:03+08:00 ] 221.178.126.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686128762&v1=0.018331&v2=0.014499&v3=0.015231&v4=-0.000211&v5=12.420000&t=26.552568&h=79.388184&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185147,35.986644&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008777s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.001744s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686128762,`v1`=0.018331,`v2`=0.014499,`v3`=0.015231,`v4`=-0.000211,`v5`=12.42,`t`=26.552568,`h`=79.388184,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185147,35.986644',`update_time`=1686128763 WHERE `imei` = '868922055647586' [ RunTime:0.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010974s ]
[ 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' , 1686128762 , 0.018331 , 0.014499 , 0.015231 , -0.000211 , 12.42 , 26.552568 , 79.388184 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.185147,35.986644' , 1686128763) [ RunTime:0.001558s ]
---------------------------------------------------------------
[ 2023-06-07T17:48:53+08:00 ] 221.178.125.99 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012758s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000717s ]
---------------------------------------------------------------
[ 2023-06-07T17:48:54+08:00 ] 221.178.125.99 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686131333&v1=0.027060&v2=0.012830&v3=0.027722&v4=0.015562&v5=12.240000&t=26.198641&h=77.343506&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184701,35.984396&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011287s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686131333,`v1`=0.02706,`v2`=0.01283,`v3`=0.027722,`v4`=0.015562,`v5`=12.24,`t`=26.198641,`h`=77.343506,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184701,35.984396',`update_time`=1686131334 WHERE `imei` = '868922056976208' [ RunTime:0.000796s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011114s ]
[ 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' , 1686131333 , 0.02706 , 0.01283 , 0.027722 , 0.015562 , 12.24 , 26.198641 , 77.343506 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184701,35.984396' , 1686131334) [ RunTime:0.001386s ]
---------------------------------------------------------------
[ 2023-06-07T17:48:57+08:00 ] 221.178.125.99 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686044821&v1=0.026880&v2=0.012934&v3=0.027120&v4=0.015803&v5=12.420000&t=25.083229&h=77.534241&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001507s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.019986s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686044821,`v1`=0.02688,`v2`=0.012934,`v3`=0.02712,`v4`=0.015803,`v5`=12.42,`t`=25.083229,`h`=77.534241,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1686131337 WHERE `imei` = '868922056976208' [ RunTime:0.000613s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009618s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1686044821 , 0.02688 , 0.012934 , 0.02712 , 0.015803 , 12.42 , 25.083229 , 77.534241 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1686131337) [ RunTime:0.000495s ]
---------------------------------------------------------------
[ 2023-06-07T17:54:20+08:00 ] 111.55.141.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011121s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000743s ]
---------------------------------------------------------------
[ 2023-06-07T17:54:21+08:00 ] 111.55.141.244 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686131660&v1=0.020860&v2=0.014082&v3=0.017007&v4=-0.006953&v5=12.420000&t=26.316616&h=79.342407&rssi=28&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000774s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686131660,`v1`=0.02086,`v2`=0.014082,`v3`=0.017007,`v4`=-0.006953,`v5`=12.42,`t`=26.316616,`h`=79.342407,`rssi`=28,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686131661 WHERE `imei` = '868922055684209' [ RunTime:0.000643s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010590s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686131660 , 0.02086 , 0.014082 , 0.017007 , -0.006953 , 12.42 , 26.316616 , 79.342407 , 28 , '898604650119C1078511' , '460048590708511' , -0 , 1686131661) [ RunTime:0.001222s ]
---------------------------------------------------------------
[ 2023-06-07T18:19:20+08:00 ] 221.178.127.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2023-06-07T18:19:22+08:00 ] 221.178.127.163 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686133160&v1=0.019114&v2=0.013769&v3=0.016495&v4=-0.004846&v5=12.420000&t=26.091389&h=82.905334&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010929s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000628s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686133160,`v1`=0.019114,`v2`=0.013769,`v3`=0.016495,`v4`=-0.004846,`v5`=12.42,`t`=26.091389,`h`=82.905334,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686133162 WHERE `imei` = '868922055683920' [ RunTime:0.000584s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011343s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686133160 , 0.019114 , 0.013769 , 0.016495 , -0.004846 , 12.42 , 26.091389 , 82.905334 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686133162) [ RunTime:0.000605s ]
---------------------------------------------------------------
[ 2023-06-07T21:04:02+08:00 ] 223.104.255.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013126s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000774s ]
---------------------------------------------------------------
[ 2023-06-07T21:04:04+08:00 ] 223.104.255.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686143042&v1=0.030853&v2=0.014812&v3=0.029047&v4=0.008037&v5=12.600000&t=25.619484&h=81.516785&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185468,35.987378&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.013512s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000873s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686143042,`v1`=0.030853,`v2`=0.014812,`v3`=0.029047,`v4`=0.008037,`v5`=12.6,`t`=25.619484,`h`=81.516785,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185468,35.987378',`update_time`=1686143044 WHERE `imei` = '868922055683912' [ RunTime:0.000669s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010497s ]
[ 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' , 1686143042 , 0.030853 , 0.014812 , 0.029047 , 0.008037 , 12.6 , 25.619484 , 81.516785 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185468,35.987378' , 1686143044) [ RunTime:0.001332s ]
---------------------------------------------------------------
[ 2023-06-07T21:10:59+08:00 ] 218.204.252.50 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.002394s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011142s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.001016s ]
---------------------------------------------------------------
[ 2023-06-07T21:11:01+08:00 ] 218.204.252.50 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686143459&v1=0.019355&v2=0.014395&v3=0.016164&v4=-0.017308&v5=12.420000&t=25.662386&h=82.371277&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185606,35.987861&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010024s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000772s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686143459,`v1`=0.019355,`v2`=0.014395,`v3`=0.016164,`v4`=-0.017308,`v5`=12.42,`t`=25.662386,`h`=82.371277,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185606,35.987861',`update_time`=1686143461 WHERE `imei` = '868922055683771' [ RunTime:0.000591s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011629s ]
[ 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' , 1686143459 , 0.019355 , 0.014395 , 0.016164 , -0.017308 , 12.42 , 25.662386 , 82.371277 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.185606,35.987861' , 1686143461) [ RunTime:0.000541s ]
---------------------------------------------------------------
[ 2023-06-07T22:14:53+08:00 ] 111.55.139.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002202s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011263s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000691s ]
---------------------------------------------------------------
[ 2023-06-07T22:14:59+08:00 ] 111.55.139.195 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230607&time=221401&v1=-01.224&v2=+00.014&v3=-01.109&v4=-00.278&v5=06.0&t=+26.1&h=78.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.137&a2=01.264&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009736s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230607',`time`='221401',`v1`=-1.224,`v2`=0.014,`v3`=-1.109,`v4`=-0.278,`v5`=6,`t`=26.1,`h`=78.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.137,`a2`=1.264,`update_time`=1686147299 WHERE `imei` = '868922055684076' [ RunTime:0.000574s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011542s ]
[ 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' , '230607' , '221401' , -1.224 , 0.014 , -1.109 , -0.278 , 6 , 26.1 , 78.5 , 228 , '460044618415249' , -0 , 0.137 , 1.264 , 1686147299 , 1686147299) [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2023-06-07T23:49:24+08:00 ] 117.132.197.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002795s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012504s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000799s ]
---------------------------------------------------------------
[ 2023-06-07T23:49:25+08:00 ] 117.132.197.124 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686152964&v1=0.007796&v2=0.013664&v3=0.005207&v4=-0.015803&v5=12.420000&t=25.640936&h=80.524963&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011630s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000649s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686152964,`v1`=0.007796,`v2`=0.013664,`v3`=0.005207,`v4`=-0.015803,`v5`=12.42,`t`=25.640936,`h`=80.524963,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686152965 WHERE `imei` = '868922055644021' [ RunTime:0.000618s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012320s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686152964 , 0.007796 , 0.013664 , 0.005207 , -0.015803 , 12.42 , 25.640936 , 80.524963 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686152965) [ RunTime:0.000602s ]