--------------------------------------------------------------- [ 2023-06-01T00:03:23+08:00 ] 39.144.8.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002102s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012629s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-06-01T00:03:25+08:00 ] 39.144.8.174 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1685549003&v1=0.021221&v2=0.013977&v3=0.018512&v4=-0.006171&v5=12.240000&t=23.141987&h=79.258484&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001547s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010585s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1685549003,`v1`=0.021221,`v2`=0.013977,`v3`=0.018512,`v4`=-0.006171,`v5`=12.24,`t`=23.141987,`h`=79.258484,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1685549004 WHERE `imei` = '868922055680850' [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011620s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1685549003 , 0.021221 , 0.013977 , 0.018512 , -0.006171 , 12.24 , 23.141987 , 79.258484 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1685549005) [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2023-06-01T02:03:54+08:00 ] 39.144.1.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002833s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-06-01T02:03:55+08:00 ] 39.144.16.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011710s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-06-01T02:04:03+08:00 ] 39.144.1.182 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230601&time=020301&v1=-01.380&v2=+00.015&v3=-00.983&v4=-00.044&v5=06.2&t=+20.0&h=59.9&rssi=+228&ccid=4600485905031420000099m9990000000398000001g3880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230601',`time`='020301',`v1`=-1.38,`v2`=0.015,`v3`=-0.983,`v4`=-0.044,`v5`=6.2,`t`=20,`h`=59.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000398000001g3880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685556243 WHERE `imei` = '868922055643643' [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010990s ] [ 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' , '230601' , '020301' , -1.38 , 0.015 , -0.983 , -0.044 , 6.2 , 20 , 59.9 , 228 , '4600485905031420000099m9990000000398000001g3880,N,00E000=-00.000' , 0 , 0 , 1685556243 , 1685556243) [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-06-01T02:04:03+08:00 ] 39.144.16.22 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230601&time=020301&v1=-00.235&v2=+00.001&v3=-00.035&v4=-00.004&v5=05.7&t=+19.9&h=62.7&rssi=+223&ccid=4600485905031430000099m9990000000031000000g2490,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011854s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000889s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230601',`time`='020301',`v1`=-0.235,`v2`=0.001,`v3`=-0.035,`v4`=-0.004,`v5`=5.7,`t`=19.9,`h`=62.7,`rssi`=223,`ccid`='4600485905031430000099m9990000000031000000g2490,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685556243 WHERE `imei` = '868922055644013' [ RunTime:0.000973s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010072s ] [ 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' , '230601' , '020301' , -0.235 , 0.001 , -0.035 , -0.004 , 5.7 , 19.9 , 62.7 , 223 , '4600485905031430000099m9990000000031000000g2490,N,00E000=-00.000' , 0 , 0 , 1685556243 , 1685556243) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2023-06-01T11:21:30+08:00 ] 111.55.139.88 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.004002s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016206s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001406s ] --------------------------------------------------------------- [ 2023-06-01T11:21:31+08:00 ] 111.55.139.88 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1685589690&v1=0.029468&v2=0.013143&v3=0.034405&v4=0.001294&v5=12.420000&t=22.906034&h=79.159302&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1685589690,`v1`=0.029468,`v2`=0.013143,`v3`=0.034405,`v4`=0.001294,`v5`=12.42,`t`=22.906034,`h`=79.159302,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1685589691 WHERE `imei` = '868922055678110' [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015505s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1685589690 , 0.029468 , 0.013143 , 0.034405 , 0.001294 , 12.42 , 22.906034 , 79.159302 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1685589691) [ RunTime:0.001308s ] --------------------------------------------------------------- [ 2023-06-01T14:03:54+08:00 ] 111.55.141.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002353s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014006s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001380s ] --------------------------------------------------------------- [ 2023-06-01T14:03:54+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010487s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000909s ] --------------------------------------------------------------- [ 2023-06-01T14:04:03+08:00 ] 111.55.141.134 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230601&time=140301&v1=-00.232&v2=+00.001&v3=+00.019&v4=-00.003&v5=06.0&t=+32.9&h=59.8&rssi=+223&ccid=4600485905031430000099m9990000000044000000g2530,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009879s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230601',`time`='140301',`v1`=-0.232,`v2`=0.001,`v3`=0.019,`v4`=-0.003,`v5`=6,`t`=32.9,`h`=59.8,`rssi`=223,`ccid`='4600485905031430000099m9990000000044000000g2530,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685599443 WHERE `imei` = '868922055644013' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011583s ] [ 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' , '230601' , '140301' , -0.232 , 0.001 , 0.019 , -0.003 , 6 , 32.9 , 59.8 , 223 , '4600485905031430000099m9990000000044000000g2530,N,00E000=-00.000' , 0 , 0 , 1685599443 , 1685599443) [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-06-01T14:04:04+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230601&time=140301&v1=-01.382&v2=+00.025&v3=-00.960&v4=-00.043&v5=06.4&t=+36.2&h=55.1&rssi=+231&ccid=4600485905031420000099m9990000000420000001g3890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010645s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230601',`time`='140301',`v1`=-1.382,`v2`=0.025,`v3`=-0.96,`v4`=-0.043,`v5`=6.4,`t`=36.2,`h`=55.1,`rssi`=231,`ccid`='4600485905031420000099m9990000000420000001g3890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685599444 WHERE `imei` = '868922055643643' [ RunTime:0.000514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011060s ] [ 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' , '230601' , '140301' , -1.382 , 0.025 , -0.96 , -0.043 , 6.4 , 36.2 , 55.1 , 231 , '4600485905031420000099m9990000000420000001g3890,N,00E000=-00.000' , 0 , 0 , 1685599444 , 1685599444) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2023-06-01T14:48:23+08:00 ] 39.144.14.82 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010913s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-06-01T14:48:24+08:00 ] 39.144.14.82 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1685602103&v1=0.016585&v2=0.015125&v3=0.014358&v4=-0.011649&v5=12.420000&t=23.742592&h=77.595276&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001855s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010561s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1685602103,`v1`=0.016585,`v2`=0.015125,`v3`=0.014358,`v4`=-0.011649,`v5`=12.42,`t`=23.742592,`h`=77.595276,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1685602104 WHERE `imei` = '868922055684548' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011398s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1685602103 , 0.016585 , 0.015125 , 0.014358 , -0.011649 , 12.42 , 23.742592 , 77.595276 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1685602104) [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-06-01T16:40:35+08:00 ] 124.129.68.101 POST /home/login/login.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_user` [ RunTime:0.014416s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001333s ] --------------------------------------------------------------- [ 2023-06-01T16:40:36+08:00 ] 124.129.68.101 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001911s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2023-06-01T16:40:57+08:00 ] 124.129.68.101 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010050s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2023-06-01T16:40:58+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001372s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009510s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000468s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-06-01T16:41:01+08:00 ] 124.129.68.101 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010132s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-06-01T17:00:55+08:00 ] 117.132.197.71 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010976s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000784s ] --------------------------------------------------------------- [ 2023-06-01T17:00:57+08:00 ] 117.132.197.71 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1685610055&v1=0.018331&v2=0.013977&v3=0.016254&v4=-0.000030&v5=12.240000&t=23.678242&h=79.922241&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184833,35.985171&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1685610055,`v1`=0.018331,`v2`=0.013977,`v3`=0.016254,`v4`=-3.0E-5,`v5`=12.24,`t`=23.678242,`h`=79.922241,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184833,35.985171',`update_time`=1685610057 WHERE `imei` = '868922055647586' [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011041s ] [ 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' , 1685610055 , 0.018331 , 0.013977 , 0.016254 , -3.0E-5 , 12.24 , 23.678242 , 79.922241 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.184833,35.985171' , 1685610057) [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-06-01T17:08:30+08:00 ] 124.129.68.101 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009388s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-06-01T17:08:52+08:00 ] 124.129.68.101 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002080s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010145s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-06-01T17:24:31+08:00 ] 124.129.68.101 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003193s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011182s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2023-06-01T17:24:34+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011986s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.011346s ] --------------------------------------------------------------- [ 2023-06-01T17:24:36+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009962s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000507s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000953s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000579s ] --------------------------------------------------------------- [ 2023-06-01T17:24:38+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009997s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-06-01T17:27:46+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009538s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000499s ] [ 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.000624s ] --------------------------------------------------------------- [ 2023-06-01T17:43:05+08:00 ] 223.104.255.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011360s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-06-01T17:43:06+08:00 ] 223.104.255.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1685612585&v1=0.027181&v2=0.011265&v3=0.027241&v4=0.015923&v5=12.240000&t=23.592442&h=77.786011&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184417,35.984062&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1685612585,`v1`=0.027181,`v2`=0.011265,`v3`=0.027241,`v4`=0.015923,`v5`=12.24,`t`=23.592442,`h`=77.786011,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184417,35.984062',`update_time`=1685612586 WHERE `imei` = '868922056976208' [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009673s ] [ 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' , 1685612585 , 0.027181 , 0.011265 , 0.027241 , 0.015923 , 12.24 , 23.592442 , 77.786011 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184417,35.984062' , 1685612586) [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2023-06-01T17:48:21+08:00 ] 117.132.195.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011057s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000731s ] --------------------------------------------------------------- [ 2023-06-01T17:48:23+08:00 ] 117.132.195.79 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1685612901&v1=0.020739&v2=0.012934&v3=0.016977&v4=-0.007013&v5=12.420000&t=23.517366&h=79.693359&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1685612901,`v1`=0.020739,`v2`=0.012934,`v3`=0.016977,`v4`=-0.007013,`v5`=12.42,`t`=23.517366,`h`=79.693359,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1685612903 WHERE `imei` = '868922055684209' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010583s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1685612901 , 0.020739 , 0.012934 , 0.016977 , -0.007013 , 12.42 , 23.517366 , 79.693359 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1685612903) [ RunTime:0.000828s ] --------------------------------------------------------------- [ 2023-06-01T18:03:50+08:00 ] 39.144.15.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002519s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010315s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2023-06-01T18:03:59+08:00 ] 39.144.15.216 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230601&time=180301&v1=-01.241&v2=+00.018&v3=-01.129&v4=-00.371&v5=06.2&t=+29.2&h=78.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.132&a2=01.272&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230601',`time`='180301',`v1`=-1.241,`v2`=0.018,`v3`=-1.129,`v4`=-0.371,`v5`=6.2,`t`=29.2,`h`=78.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.132,`a2`=1.272,`update_time`=1685613839 WHERE `imei` = '868922055684076' [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009771s ] [ 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' , '230601' , '180301' , -1.241 , 0.018 , -1.129 , -0.371 , 6.2 , 29.2 , 78.2 , 227 , '460044618415249' , -0 , 0.132 , 1.272 , 1685613839 , 1685613839) [ RunTime:0.000505s ] --------------------------------------------------------------- [ 2023-06-01T18:13:20+08:00 ] 39.144.5.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002744s ] 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` = '868922055683920' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-06-01T18:13:21+08:00 ] 39.144.5.182 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1685614400&v1=0.018753&v2=0.014395&v3=0.016375&v4=-0.004786&v5=12.420000&t=23.141987&h=82.645935&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001746s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009418s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1685614400,`v1`=0.018753,`v2`=0.014395,`v3`=0.016375,`v4`=-0.004786,`v5`=12.42,`t`=23.141987,`h`=82.645935,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1685614401 WHERE `imei` = '868922055683920' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020457s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1685614400 , 0.018753 , 0.014395 , 0.016375 , -0.004786 , 12.42 , 23.141987 , 82.645935 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1685614401) [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-06-01T20:58:23+08:00 ] 111.55.136.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012736s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2023-06-01T20:58:24+08:00 ] 111.55.136.159 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1685624303&v1=0.031756&v2=0.015646&v3=0.029077&v4=0.008157&v5=12.420000&t=23.281414&h=81.287903&rssi=19&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184916,35.985324&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011342s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1685624303,`v1`=0.031756,`v2`=0.015646,`v3`=0.029077,`v4`=0.008157,`v5`=12.42,`t`=23.281414,`h`=81.287903,`rssi`=19,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184916,35.985324',`update_time`=1685624304 WHERE `imei` = '868922055683912' [ RunTime:0.000763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011664s ] [ 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' , 1685624303 , 0.031756 , 0.015646 , 0.029077 , 0.008157 , 12.42 , 23.281414 , 81.287903 , 19 , '898604650119C1053138' , '460048590503138' , -0 , '120.184916,35.985324' , 1685624304) [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-06-01T21:05:24+08:00 ] 117.132.192.158 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012106s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-06-01T21:05:25+08:00 ] 117.132.192.158 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1685624724&v1=0.018993&v2=0.014186&v3=0.016375&v4=-0.017127&v5=12.240000&t=23.281414&h=82.088989&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184451,35.985676&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002035s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1685624724,`v1`=0.018993,`v2`=0.014186,`v3`=0.016375,`v4`=-0.017127,`v5`=12.24,`t`=23.281414,`h`=82.088989,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184451,35.985676',`update_time`=1685624725 WHERE `imei` = '868922055683771' [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011186s ] [ 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' , 1685624724 , 0.018993 , 0.014186 , 0.016375 , -0.017127 , 12.24 , 23.281414 , 82.088989 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184451,35.985676' , 1685624725) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-06-01T23:43:23+08:00 ] 39.144.6.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002510s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011635s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000818s ] --------------------------------------------------------------- [ 2023-06-01T23:43:25+08:00 ] 39.144.6.100 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1685634203&v1=0.007375&v2=0.015020&v3=0.005177&v4=-0.015923&v5=12.420000&t=23.024012&h=80.517334&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1685634203,`v1`=0.007375,`v2`=0.01502,`v3`=0.005177,`v4`=-0.015923,`v5`=12.42,`t`=23.024012,`h`=80.517334,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1685634205 WHERE `imei` = '868922055644021' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011761s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1685634203 , 0.007375 , 0.01502 , 0.005177 , -0.015923 , 12.42 , 23.024012 , 80.517334 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1685634205) [ RunTime:0.001305s ]