--------------------------------------------------------------- [ 2023-05-24T02:03:54+08:00 ] 39.144.4.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011229s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-05-24T02:03:55+08:00 ] 221.178.124.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-05-24T02:04:03+08:00 ] 39.144.4.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230524&time=020301&v1=-01.373&v2=+00.019&v3=-00.955&v4=-00.045&v5=06.2&t=+20.3&h=59.7&rssi=+228&ccid=4600485905031420000099m9990000000421000001g3810,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230524',`time`='020301',`v1`=-1.373,`v2`=0.019,`v3`=-0.955,`v4`=-0.045,`v5`=6.2,`t`=20.3,`h`=59.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000421000001g3810,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684865043 WHERE `imei` = '868922055643643' [ RunTime:0.000722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011844s ] [ 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' , '230524' , '020301' , -1.373 , 0.019 , -0.955 , -0.045 , 6.2 , 20.3 , 59.7 , 228 , '4600485905031420000099m9990000000421000001g3810,N,00E000=-00.000' , 0 , 0 , 1684865043 , 1684865043) [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-05-24T02:04:03+08:00 ] 221.178.124.245 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230524&time=020301&v1=-00.313&v2=+00.001&v3=+00.020&v4=-00.005&v5=06.0&t=+20.9&h=62.7&rssi=+224&ccid=4600485905031430000099m9990000000039000000g3370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010715s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230524',`time`='020301',`v1`=-0.313,`v2`=0.001,`v3`=0.02,`v4`=-0.005,`v5`=6,`t`=20.9,`h`=62.7,`rssi`=224,`ccid`='4600485905031430000099m9990000000039000000g3370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684865043 WHERE `imei` = '868922055644013' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009789s ] [ 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' , '230524' , '020301' , -0.313 , 0.001 , 0.02 , -0.005 , 6 , 20.9 , 62.7 , 224 , '4600485905031430000099m9990000000039000000g3370,N,00E000=-00.000' , 0 , 0 , 1684865043 , 1684865043) [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-05-24T09:24:06+08:00 ] 124.129.96.125 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002300s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013229s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'na' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001286s ] --------------------------------------------------------------- [ 2023-05-24T09:24:07+08:00 ] 124.129.96.125 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.014783s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000740s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2023-05-24T09:24:58+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011040s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000985s ] --------------------------------------------------------------- [ 2023-05-24T11:13:28+08:00 ] 39.144.15.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002867s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011079s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000830s ] --------------------------------------------------------------- [ 2023-05-24T11:13:30+08:00 ] 39.144.15.130 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1684898008&v1=0.030371&v2=0.014082&v3=0.027632&v4=0.001174&v5=12.420000&t=24.085796&h=78.579468&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001930s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011518s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1684898008,`v1`=0.030371,`v2`=0.014082,`v3`=0.027632,`v4`=0.001174,`v5`=12.42,`t`=24.085796,`h`=78.579468,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1684898010 WHERE `imei` = '868922055678110' [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011763s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1684898008 , 0.030371 , 0.014082 , 0.027632 , 0.001174 , 12.42 , 24.085796 , 78.579468 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1684898010) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-05-24T14:03:54+08:00 ] 39.144.10.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002375s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010999s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000779s ] --------------------------------------------------------------- [ 2023-05-24T14:03:54+08:00 ] 111.55.138.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-05-24T14:04:02+08:00 ] 39.144.10.185 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230524&time=140301&v1=-01.374&v2=+00.028&v3=-00.973&v4=-00.043&v5=06.4&t=+34.2&h=54.9&rssi=+229&ccid=4600485905031420000099m9990000000400000001g3810,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012107s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230524',`time`='140301',`v1`=-1.374,`v2`=0.028,`v3`=-0.973,`v4`=-0.043,`v5`=6.4,`t`=34.2,`h`=54.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000400000001g3810,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684908242 WHERE `imei` = '868922055643643' [ RunTime:0.000687s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010794s ] [ 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' , '230524' , '140301' , -1.374 , 0.028 , -0.973 , -0.043 , 6.4 , 34.2 , 54.9 , 229 , '4600485905031420000099m9990000000400000001g3810,N,00E000=-00.000' , 0 , 0 , 1684908242 , 1684908242) [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-05-24T14:04:03+08:00 ] 111.55.138.10 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230524&time=140301&v1=-00.339&v2=+00.001&v3=+00.020&v4=-00.003&v5=06.0&t=+31.3&h=59.8&rssi=+226&ccid=4600485905031430000099m9990000000042000000g3660,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230524',`time`='140301',`v1`=-0.339,`v2`=0.001,`v3`=0.02,`v4`=-0.003,`v5`=6,`t`=31.3,`h`=59.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000042000000g3660,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684908243 WHERE `imei` = '868922055644013' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010781s ] [ 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' , '230524' , '140301' , -0.339 , 0.001 , 0.02 , -0.003 , 6 , 31.3 , 59.8 , 226 , '4600485905031430000099m9990000000042000000g3660,N,00E000=-00.000' , 0 , 0 , 1684908243 , 1684908243) [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2023-05-24T14:40:23+08:00 ] 117.132.197.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.003291s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012700s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.002578s ] --------------------------------------------------------------- [ 2023-05-24T14:40:25+08:00 ] 117.132.197.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1684910423&v1=0.016766&v2=0.015020&v3=0.014027&v4=-0.011589&v5=12.420000&t=24.396824&h=76.939148&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010140s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1684910423,`v1`=0.016766,`v2`=0.01502,`v3`=0.014027,`v4`=-0.011589,`v5`=12.42,`t`=24.396824,`h`=76.939148,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1684910425 WHERE `imei` = '868922055684548' [ RunTime:0.000777s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013561s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1684910423 , 0.016766 , 0.01502 , 0.014027 , -0.011589 , 12.42 , 24.396824 , 76.939148 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1684910425) [ RunTime:0.000776s ] --------------------------------------------------------------- [ 2023-05-24T15:45:12+08:00 ] 124.129.96.125 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010747s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000657s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2023-05-24T15:45:14+08:00 ] 124.129.96.125 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009302s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-05-24T15:45:17+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011186s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-05-24T15:51:09+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001763s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010406s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000842s ] --------------------------------------------------------------- [ 2023-05-24T15:51:30+08:00 ] 124.129.96.125 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008509s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'na' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-05-24T15:51:31+08:00 ] 124.129.96.125 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009870s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2023-05-24T15:51:59+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001778s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011024s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2023-05-24T16:29:11+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003333s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011563s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-05-24T16:55:16+08:00 ] 39.144.11.241 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002122s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-05-24T16:55:17+08:00 ] 39.144.11.241 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1684918516&v1=0.018632&v2=0.014499&v3=0.015562&v4=-0.000331&v5=12.420000&t=24.182322&h=79.838318&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184946,35.985589&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002304s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010384s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1684918516,`v1`=0.018632,`v2`=0.014499,`v3`=0.015562,`v4`=-0.000331,`v5`=12.42,`t`=24.182322,`h`=79.838318,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184946,35.985589',`update_time`=1684918517 WHERE `imei` = '868922055647586' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014505s ] [ 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' , 1684918516 , 0.018632 , 0.014499 , 0.015562 , -0.000331 , 12.42 , 24.182322 , 79.838318 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.184946,35.985589' , 1684918517) [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-05-24T17:02:16+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002144s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011881s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-05-24T17:35:13+08:00 ] 39.144.16.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002445s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013938s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-05-24T17:35:15+08:00 ] 39.144.16.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1684920913&v1=0.027843&v2=0.012830&v3=0.026067&v4=0.015863&v5=12.240000&t=24.300299&h=77.328247&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184850,35.985244&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011123s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1684920913,`v1`=0.027843,`v2`=0.01283,`v3`=0.026067,`v4`=0.015863,`v5`=12.24,`t`=24.300299,`h`=77.328247,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184850,35.985244',`update_time`=1684920915 WHERE `imei` = '868922056976208' [ RunTime:0.000774s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010468s ] [ 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' , 1684920913 , 0.027843 , 0.01283 , 0.026067 , 0.015863 , 12.24 , 24.300299 , 77.328247 , 26 , '898604650119C1053139' , '460048590503139' , -0 , '120.184850,35.985244' , 1684920915) [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-05-24T17:40:20+08:00 ] 111.55.139.74 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002777s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-05-24T17:40:21+08:00 ] 111.55.139.74 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1684921220&v1=0.019836&v2=0.014082&v3=0.016645&v4=-0.007074&v5=12.420000&t=24.278847&h=79.273743&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010167s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1684921220,`v1`=0.019836,`v2`=0.014082,`v3`=0.016645,`v4`=-0.007074,`v5`=12.42,`t`=24.278847,`h`=79.273743,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1684921221 WHERE `imei` = '868922055684209' [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010413s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1684921220 , 0.019836 , 0.014082 , 0.016645 , -0.007074 , 12.42 , 24.278847 , 79.273743 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1684921221) [ RunTime:0.001168s ] --------------------------------------------------------------- [ 2023-05-24T18:05:20+08:00 ] 117.132.196.140 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002870s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013423s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2023-05-24T18:05:21+08:00 ] 117.132.196.140 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1684922720&v1=0.018873&v2=0.014290&v3=0.015983&v4=-0.004666&v5=12.420000&t=24.203772&h=81.814331&rssi=27&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001741s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010293s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1684922720,`v1`=0.018873,`v2`=0.01429,`v3`=0.015983,`v4`=-0.004666,`v5`=12.42,`t`=24.203772,`h`=81.814331,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1684922721 WHERE `imei` = '868922055683920' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012326s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1684922720 , 0.018873 , 0.01429 , 0.015983 , -0.004666 , 12.42 , 24.203772 , 81.814331 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1684922721) [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2023-05-24T18:09:50+08:00 ] 39.144.8.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002128s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-05-24T18:09:59+08:00 ] 39.144.8.103 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230524&time=180901&v1=-00.311&v2=+00.006&v3=-00.220&v4=+00.251&v5=06.0&t=+27.6&h=78.4&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.156&a2=00.461&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001924s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010521s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230524',`time`='180901',`v1`=-0.311,`v2`=0.006,`v3`=-0.22,`v4`=0.251,`v5`=6,`t`=27.6,`h`=78.4,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=0.461,`update_time`=1684922999 WHERE `imei` = '868922055684076' [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011327s ] [ 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' , '230524' , '180901' , -0.311 , 0.006 , -0.22 , 0.251 , 6 , 27.6 , 78.4 , 227 , '460044618415249' , -0 , 0.156 , 0.461 , 1684922999 , 1684922999) [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-05-24T20:52:24+08:00 ] 117.132.191.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.012191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012354s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-05-24T20:52:25+08:00 ] 117.132.191.122 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1684932744&v1=0.031936&v2=0.014290&v3=0.028565&v4=0.008278&v5=12.600000&t=23.356489&h=80.616516&rssi=29&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009977s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1684932744,`v1`=0.031936,`v2`=0.01429,`v3`=0.028565,`v4`=0.008278,`v5`=12.6,`t`=23.356489,`h`=80.616516,`rssi`=29,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1684932745 WHERE `imei` = '868922055683912' [ RunTime:0.001285s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010821s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1684932744 , 0.031936 , 0.01429 , 0.028565 , 0.008278 , 12.6 , 23.356489 , 80.616516 , 29 , '898604650119C1053138' , '460048590503138' , -0 , 1684932745) [ RunTime:0.001481s ] --------------------------------------------------------------- [ 2023-05-24T20:57:02+08:00 ] 39.144.13.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009891s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-05-24T20:57:04+08:00 ] 39.144.13.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1684933022&v1=0.019234&v2=0.014603&v3=0.015803&v4=-0.017247&v5=12.420000&t=23.292139&h=81.425232&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184325,35.985555&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009558s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1684933022,`v1`=0.019234,`v2`=0.014603,`v3`=0.015803,`v4`=-0.017247,`v5`=12.42,`t`=23.292139,`h`=81.425232,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184325,35.985555',`update_time`=1684933024 WHERE `imei` = '868922055683771' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009528s ] [ 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' , 1684933022 , 0.019234 , 0.014603 , 0.015803 , -0.017247 , 12.42 , 23.292139 , 81.425232 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184325,35.985555' , 1684933024) [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-05-24T23:35:23+08:00 ] 39.144.13.241 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002572s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012676s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2023-05-24T23:35:25+08:00 ] 39.144.13.241 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1684942523&v1=0.006893&v2=0.015020&v3=0.004816&v4=-0.015803&v5=12.420000&t=23.024012&h=80.013794&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009861s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1684942523,`v1`=0.006893,`v2`=0.01502,`v3`=0.004816,`v4`=-0.015803,`v5`=12.42,`t`=23.024012,`h`=80.013794,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1684942525 WHERE `imei` = '868922055644021' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012544s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1684942523 , 0.006893 , 0.01502 , 0.004816 , -0.015803 , 12.42 , 23.024012 , 80.013794 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1684942525) [ RunTime:0.001356s ] --------------------------------------------------------------- [ 2023-05-24T23:56:03+08:00 ] 39.144.15.243 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002916s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011963s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-05-24T23:56:04+08:00 ] 39.144.15.243 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1684943763&v1=0.021161&v2=0.012621&v3=0.018181&v4=-0.006291&v5=12.240000&t=23.141987&h=78.960938&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.183065,35.986169&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.001533s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1684943763,`v1`=0.021161,`v2`=0.012621,`v3`=0.018181,`v4`=-0.006291,`v5`=12.24,`t`=23.141987,`h`=78.960938,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.183065,35.986169',`update_time`=1684943764 WHERE `imei` = '868922055680850' [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011993s ] [ 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' , 1684943763 , 0.021161 , 0.012621 , 0.018181 , -0.006291 , 12.24 , 23.141987 , 78.960938 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.183065,35.986169' , 1684943764) [ RunTime:0.001514s ]