--------------------------------------------------------------- [ 2023-06-02T00:04:05+08:00 ] 111.55.136.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002346s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2023-06-02T00:04:06+08:00 ] 111.55.136.32 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1685635445&v1=0.021161&v2=0.013873&v3=0.018572&v4=-0.006351&v5=12.420000&t=23.034737&h=79.319519&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185264,35.985626&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001633s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008740s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1685635445,`v1`=0.021161,`v2`=0.013873,`v3`=0.018572,`v4`=-0.006351,`v5`=12.42,`t`=23.034737,`h`=79.319519,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185264,35.985626',`update_time`=1685635446 WHERE `imei` = '868922055680850' [ RunTime:0.000777s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009667s ] [ 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' , 1685635445 , 0.021161 , 0.013873 , 0.018572 , -0.006351 , 12.42 , 23.034737 , 79.319519 , 26 , '898604650119C1078510' , '460048590708510' , -0 , '120.185264,35.985626' , 1685635446) [ RunTime:0.001096s ] --------------------------------------------------------------- [ 2023-06-02T02:03:54+08:00 ] 39.144.2.96 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2023-06-02T02:03:55+08:00 ] 39.144.2.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001667s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011184s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-06-02T02:04:03+08:00 ] 39.144.2.96 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230602&time=020301&v1=-01.384&v2=+00.017&v3=-00.989&v4=-00.043&v5=06.2&t=+19.8&h=60.3&rssi=+228&ccid=4600485905031420000099m9990000000396000001g3920,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009767s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230602',`time`='020301',`v1`=-1.384,`v2`=0.017,`v3`=-0.989,`v4`=-0.043,`v5`=6.2,`t`=19.8,`h`=60.3,`rssi`=228,`ccid`='4600485905031420000099m9990000000396000001g3920,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685642643 WHERE `imei` = '868922055643643' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012083s ] [ 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' , '230602' , '020301' , -1.384 , 0.017 , -0.989 , -0.043 , 6.2 , 19.8 , 60.3 , 228 , '4600485905031420000099m9990000000396000001g3920,N,00E000=-00.000' , 0 , 0 , 1685642643 , 1685642643) [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-06-02T02:04:04+08:00 ] 39.144.2.252 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230602&time=020301&v1=-00.550&v2=+00.001&v3=-00.284&v4=-00.002&v5=06.0&t=+19.9&h=62.7&rssi=+224&ccid=4600485905031430000099m9990000000057000000g5690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010021s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230602',`time`='020301',`v1`=-0.55,`v2`=0.001,`v3`=-0.284,`v4`=-0.002,`v5`=6,`t`=19.9,`h`=62.7,`rssi`=224,`ccid`='4600485905031430000099m9990000000057000000g5690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685642644 WHERE `imei` = '868922055644013' [ RunTime:0.000568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011364s ] [ 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' , '230602' , '020301' , -0.55 , 0.001 , -0.284 , -0.002 , 6 , 19.9 , 62.7 , 224 , '4600485905031430000099m9990000000057000000g5690,N,00E000=-00.000' , 0 , 0 , 1685642644 , 1685642644) [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2023-06-02T09:07:23+08:00 ] 124.129.68.101 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002814s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010896s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-06-02T09:07:24+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001901s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010128s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000498s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-06-02T09:23:02+08:00 ] 124.129.68.101 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010758s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-06-02T09:23:03+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012727s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000529s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2023-06-02T09:28:55+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009506s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000517s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2023-06-02T09:28:57+08:00 ] 124.129.68.101 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011521s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000553s ] --------------------------------------------------------------- [ 2023-06-02T09:29:03+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010016s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000611s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-06-02T09:29:47+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010297s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000515s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-06-02T09:29:49+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011381s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000474s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-06-02T09:30:55+08:00 ] 124.129.68.101 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010477s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2023-06-02T09:36:06+08:00 ] 124.129.68.101 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009238s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2023-06-02T09:36:28+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003290s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010959s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000540s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2023-06-02T09:39:31+08:00 ] 124.129.68.101 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004184s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008534s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000570s ] --------------------------------------------------------------- [ 2023-06-02T09:39:42+08:00 ] 124.129.68.101 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002393s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010832s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000556s ] --------------------------------------------------------------- [ 2023-06-02T09:43:43+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001546s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009092s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000586s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-06-02T09:45:00+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009348s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000617s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2023-06-02T09:45:00+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002202s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011434s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-06-02T09:45:01+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001769s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010138s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000585s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-06-02T09:45:44+08:00 ] 124.129.68.101 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001821s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010030s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.001760s ] --------------------------------------------------------------- [ 2023-06-02T09:45:56+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002297s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010604s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000643s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-06-02T09:46:03+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010652s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000470s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2023-06-02T09:46:04+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002783s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011581s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000495s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000565s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001018s ] --------------------------------------------------------------- [ 2023-06-02T09:46:07+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009788s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2023-06-02T09:48:07+08:00 ] 124.129.68.101 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010264s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-06-02T11:22:28+08:00 ] 218.204.252.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001357s ] --------------------------------------------------------------- [ 2023-06-02T11:22:30+08:00 ] 218.204.252.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1685676148&v1=0.030552&v2=0.013351&v3=0.035699&v4=0.001415&v5=12.420000&t=24.439724&h=78.968567&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002025s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010147s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1685676148,`v1`=0.030552,`v2`=0.013351,`v3`=0.035699,`v4`=0.001415,`v5`=12.42,`t`=24.439724,`h`=78.968567,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1685676150 WHERE `imei` = '868922055678110' [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013027s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1685676148 , 0.030552 , 0.013351 , 0.035699 , 0.001415 , 12.42 , 24.439724 , 78.968567 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1685676150) [ RunTime:0.001502s ] --------------------------------------------------------------- [ 2023-06-02T14:03:54+08:00 ] 223.104.255.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001211s ] --------------------------------------------------------------- [ 2023-06-02T14:03:55+08:00 ] 39.144.3.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001974s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010208s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001024s ] --------------------------------------------------------------- [ 2023-06-02T14:04:03+08:00 ] 223.104.255.11 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230602&time=140301&v1=-01.382&v2=+00.024&v3=-00.955&v4=-00.042&v5=06.4&t=+32.3&h=56.4&rssi=+228&ccid=4600485905031420000099m9990000000427000001g3890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009969s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230602',`time`='140301',`v1`=-1.382,`v2`=0.024,`v3`=-0.955,`v4`=-0.042,`v5`=6.4,`t`=32.3,`h`=56.4,`rssi`=228,`ccid`='4600485905031420000099m9990000000427000001g3890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685685843 WHERE `imei` = '868922055643643' [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010710s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230602' , '140301' , -1.382 , 0.024 , -0.955 , -0.042 , 6.4 , 32.3 , 56.4 , 228 , '4600485905031420000099m9990000000427000001g3890,N,00E000=-00.000' , 0 , 0 , 1685685843 , 1685685843) [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-06-02T14:04:03+08:00 ] 39.144.3.111 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230602&time=140301&v1=-00.577&v2=+00.001&v3=+00.016&v4=-00.001&v5=06.0&t=+31.6&h=59.9&rssi=+224&ccid=4600485905031430000099m9990000000050000000g6010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.009471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230602',`time`='140301',`v1`=-0.577,`v2`=0.001,`v3`=0.016,`v4`=-0.001,`v5`=6,`t`=31.6,`h`=59.9,`rssi`=224,`ccid`='4600485905031430000099m9990000000050000000g6010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685685843 WHERE `imei` = '868922055644013' [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008015s ] [ 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' , '230602' , '140301' , -0.577 , 0.001 , 0.016 , -0.001 , 6 , 31.6 , 59.9 , 224 , '4600485905031430000099m9990000000050000000g6010,N,00E000=-00.000' , 0 , 0 , 1685685843 , 1685685843) [ RunTime:0.000503s ] --------------------------------------------------------------- [ 2023-06-02T14:49:24+08:00 ] 39.144.5.99 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009710s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-06-02T14:49:25+08:00 ] 39.144.5.99 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1685688564&v1=0.016826&v2=0.013664&v3=0.014719&v4=-0.011709&v5=12.420000&t=26.520393&h=77.084106&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-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.010972s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1685688564,`v1`=0.016826,`v2`=0.013664,`v3`=0.014719,`v4`=-0.011709,`v5`=12.42,`t`=26.520393,`h`=77.084106,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1685688565 WHERE `imei` = '868922055684548' [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021877s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1685688564 , 0.016826 , 0.013664 , 0.014719 , -0.011709 , 12.42 , 26.520393 , 77.084106 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1685688565) [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-06-02T17:00:57+08:00 ] 221.178.127.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002137s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.222190s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-06-02T17:00:58+08:00 ] 221.178.127.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1685696457&v1=0.018452&v2=0.013664&v3=0.016043&v4=-0.000030&v5=12.240000&t=26.069939&h=79.571289&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184768,35.984979&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.075935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1685696457,`v1`=0.018452,`v2`=0.013664,`v3`=0.016043,`v4`=-3.0E-5,`v5`=12.24,`t`=26.069939,`h`=79.571289,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184768,35.984979',`update_time`=1685696458 WHERE `imei` = '868922055647586' [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011779s ] [ 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' , 1685696457 , 0.018452 , 0.013664 , 0.016043 , -3.0E-5 , 12.24 , 26.069939 , 79.571289 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.184768,35.984979' , 1685696458) [ RunTime:0.001249s ] --------------------------------------------------------------- [ 2023-06-02T17:44:04+08:00 ] 39.144.3.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002340s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010457s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-06-02T17:44:05+08:00 ] 39.144.3.123 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1685699044&v1=0.027241&v2=0.013664&v3=0.027331&v4=0.015803&v5=12.240000&t=25.522959&h=77.312988&rssi=29&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184778,35.985108&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002227s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011065s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001105s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1685699044,`v1`=0.027241,`v2`=0.013664,`v3`=0.027331,`v4`=0.015803,`v5`=12.24,`t`=25.522959,`h`=77.312988,`rssi`=29,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184778,35.985108',`update_time`=1685699045 WHERE `imei` = '868922056976208' [ RunTime:0.000797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017280s ] [ 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' , 1685699044 , 0.027241 , 0.013664 , 0.027331 , 0.015803 , 12.24 , 25.522959 , 77.312988 , 29 , '898604650119C1053139' , '460048590503139' , -0 , '120.184778,35.985108' , 1685699045) [ RunTime:0.001331s ] --------------------------------------------------------------- [ 2023-06-02T17:49:21+08:00 ] 218.204.252.251 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011474s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-06-02T17:49:23+08:00 ] 218.204.252.251 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1685699361&v1=0.020860&v2=0.013351&v3=0.017067&v4=-0.006953&v5=12.420000&t=25.619484&h=79.395813&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001900s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010907s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1685699361,`v1`=0.02086,`v2`=0.013351,`v3`=0.017067,`v4`=-0.006953,`v5`=12.42,`t`=25.619484,`h`=79.395813,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1685699363 WHERE `imei` = '868922055684209' [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010615s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1685699361 , 0.02086 , 0.013351 , 0.017067 , -0.006953 , 12.42 , 25.619484 , 79.395813 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1685699363) [ RunTime:0.001126s ] --------------------------------------------------------------- [ 2023-06-02T18:02:50+08:00 ] 111.55.141.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-06-02T18:02:59+08:00 ] 111.55.141.16 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230602&time=180201&v1=-01.238&v2=+00.015&v3=-01.128&v4=-00.331&v5=06.0&t=+25.0&h=78.5&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.131&a2=01.271&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] 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` = '868922055684076' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230602',`time`='180201',`v1`=-1.238,`v2`=0.015,`v3`=-1.128,`v4`=-0.331,`v5`=6,`t`=25,`h`=78.5,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.131,`a2`=1.271,`update_time`=1685700179 WHERE `imei` = '868922055684076' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011777s ] [ 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' , '230602' , '180201' , -1.238 , 0.015 , -1.128 , -0.331 , 6 , 25 , 78.5 , 229 , '460044618415249' , -0 , 0.131 , 1.271 , 1685700179 , 1685700179) [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-06-02T18:14:20+08:00 ] 111.55.139.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002376s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012994s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2023-06-02T18:14:22+08:00 ] 111.55.139.26 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1685700860&v1=0.018813&v2=0.015229&v3=0.016194&v4=-0.004666&v5=12.420000&t=25.190481&h=82.516235&rssi=27&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1685700860,`v1`=0.018813,`v2`=0.015229,`v3`=0.016194,`v4`=-0.004666,`v5`=12.42,`t`=25.190481,`h`=82.516235,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1685700862 WHERE `imei` = '868922055683920' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011039s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1685700860 , 0.018813 , 0.015229 , 0.016194 , -0.004666 , 12.42 , 25.190481 , 82.516235 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1685700862) [ RunTime:0.002162s ] --------------------------------------------------------------- [ 2023-06-02T20:59:06+08:00 ] 39.144.6.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012056s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-06-02T20:59:07+08:00 ] 39.144.6.100 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1685710746&v1=0.031696&v2=0.015020&v3=0.028896&v4=0.007977&v5=12.420000&t=24.375374&h=81.257385&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185468,35.989649&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011055s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000736s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1685710746,`v1`=0.031696,`v2`=0.01502,`v3`=0.028896,`v4`=0.007977,`v5`=12.42,`t`=24.375374,`h`=81.257385,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185468,35.989649',`update_time`=1685710747 WHERE `imei` = '868922055683912' [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010161s ] [ 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' , 1685710746 , 0.031696 , 0.01502 , 0.028896 , 0.007977 , 12.42 , 24.375374 , 81.257385 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.185468,35.989649' , 1685710747) [ RunTime:0.001316s ] --------------------------------------------------------------- [ 2023-06-02T21:06:24+08:00 ] 221.178.126.15 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002305s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010295s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-06-02T21:06:25+08:00 ] 221.178.126.15 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1685711184&v1=0.018512&v2=0.014290&v3=0.015351&v4=-0.017067&v5=12.420000&t=24.321749&h=82.119507&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185090,35.991038&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002071s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009817s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1685711184,`v1`=0.018512,`v2`=0.01429,`v3`=0.015351,`v4`=-0.017067,`v5`=12.42,`t`=24.321749,`h`=82.119507,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185090,35.991038',`update_time`=1685711185 WHERE `imei` = '868922055683771' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009048s ] [ 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' , 1685711184 , 0.018512 , 0.01429 , 0.015351 , -0.017067 , 12.42 , 24.321749 , 82.119507 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.185090,35.991038' , 1685711185) [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2023-06-02T23:44:24+08:00 ] 39.144.9.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002780s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000817s ] --------------------------------------------------------------- [ 2023-06-02T23:44:25+08:00 ] 39.144.9.111 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1685720664&v1=0.007615&v2=0.014395&v3=0.004967&v4=-0.015923&v5=12.420000&t=23.753319&h=80.555481&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001836s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009893s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1685720664,`v1`=0.007615,`v2`=0.014395,`v3`=0.004967,`v4`=-0.015923,`v5`=12.42,`t`=23.753319,`h`=80.555481,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1685720665 WHERE `imei` = '868922055644021' [ RunTime:0.001294s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009893s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1685720664 , 0.007615 , 0.014395 , 0.004967 , -0.015923 , 12.42 , 23.753319 , 80.555481 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1685720665) [ RunTime:0.000625s ]