--------------------------------------------------------------- [ 2021-12-12T20:03:58+08:00 ] 127.0.0.1 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.120947s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.028868s ] --------------------------------------------------------------- [ 2021-12-12T20:03:59+08:00 ] 127.0.0.1 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035300s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.015501s ] --------------------------------------------------------------- [ 2021-12-12T20:04:01+08:00 ] 127.0.0.1 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007674s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.020595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001292s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2021-12-12T20:04:03+08:00 ] 127.0.0.1 GET /home/show/read/id/6/imei/862810047308591.html [ sql ] [ DB ] CONNECT:[ UseTime:0.019235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011487s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 6 LIMIT 1 [ RunTime:0.054375s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.058110s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '862810047308591' LIMIT 1 [ RunTime:0.015040s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '862810047308591' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001581s ] --------------------------------------------------------------- [ 2021-12-12T20:04:13+08:00 ] 127.0.0.1 GET /home/show/read/id/6/imei/862810047308591.htm [ sql ] [ DB ] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009426s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '862810047308591.htm' LIMIT 1 [ RunTime:0.014985s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '862810047308591.htm' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2021-12-12T20:04:21+08:00 ] 127.0.0.1 GET /home/show/read/id/6/im [ error ] [0]方法参数错误:imei --------------------------------------------------------------- [ 2021-12-12T20:19:28+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.048739s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001304s ] --------------------------------------------------------------- [ 2021-12-12T20:20:33+08:00 ] 39.144.7.140 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680157 [ sql ] [ DB ] CONNECT:[ UseTime:0.001816s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.000988s ] --------------------------------------------------------------- [ 2021-12-12T20:20:42+08:00 ] 39.144.7.140 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055680157&date=211212&time=111158&v1=+00.014&v2=+00.021&v3=+00.014&v4=+00.015&v5=04.8&t=+09.2&h=69.6&rssi=+213&imsi=460044618415250&v6=-00.000&a1=00.028&a2=00.025&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020971s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680157',`date`='211212',`time`='111158',`v1`=0.014,`v2`=0.021,`v3`=0.014,`v4`=0.015,`v5`=4.8,`t`=9.2,`h`=69.6,`rssi`=213,`imsi`='460044618415250',`v6`=-0,`a1`=0.028,`a2`=0.025,`update_time`=1639311642 WHERE `imei` = '868922055680157' [ RunTime:0.001352s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.053541s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055680157' , '211212' , '111158' , 0.014 , 0.021 , 0.014 , 0.015 , 4.8 , 9.2 , 69.6 , '460044618415250' , -0 , 0.028 , 0.025 , 1639311642 , 1639311642) [ RunTime:0.000859s ] --------------------------------------------------------------- [ 2021-12-12T20:20:49+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022305s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000395s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001171s ] --------------------------------------------------------------- [ 2021-12-12T20:21:58+08:00 ] 39.144.4.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680157 [ sql ] [ DB ] CONNECT:[ UseTime:0.002277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.000805s ] --------------------------------------------------------------- [ 2021-12-12T20:22:07+08:00 ] 39.144.4.240 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055680157&date=211212&time=202101&v1=+00.014&v2=+00.020&v3=+00.014&v4=+00.015&v5=04.8&t=+09.6&h=68.0&rssi=+214&imsi=460044618415250&v6=-00.000&a1=00.028&a2=00.025&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.000848s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680157',`date`='211212',`time`='202101',`v1`=0.014,`v2`=0.02,`v3`=0.014,`v4`=0.015,`v5`=4.8,`t`=9.6,`h`=68,`rssi`=214,`imsi`='460044618415250',`v6`=-0,`a1`=0.028,`a2`=0.025,`update_time`=1639311727 WHERE `imei` = '868922055680157' [ RunTime:0.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017205s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055680157' , '211212' , '202101' , 0.014 , 0.02 , 0.014 , 0.015 , 4.8 , 9.6 , 68 , '460044618415250' , -0 , 0.028 , 0.025 , 1639311727 , 1639311727) [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2021-12-12T20:22:14+08:00 ] 123.234.86.34 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030287s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001160s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001367s ] --------------------------------------------------------------- [ 2021-12-12T20:23:11+08:00 ] 123.234.86.34 GET /admin/show/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024630s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001814s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001469s ] --------------------------------------------------------------- [ 2021-12-12T20:23:29+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001776s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.303079s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000916s ] --------------------------------------------------------------- [ 2021-12-12T20:23:30+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.025647s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024939s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001065s ] --------------------------------------------------------------- [ 2021-12-12T20:23:32+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002120s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023285s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000869s ] --------------------------------------------------------------- [ 2021-12-12T20:23:33+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002388s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026727s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001085s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015980s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.005180s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001487s ] --------------------------------------------------------------- [ 2021-12-12T20:23:38+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.040521s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000979s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001166s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001027s ] --------------------------------------------------------------- [ 2021-12-12T20:23:39+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023894s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001145s ] --------------------------------------------------------------- [ 2021-12-12T20:25:18+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002021s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032114s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001340s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001230s ] --------------------------------------------------------------- [ 2021-12-12T20:25:20+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001955s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022631s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000916s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018467s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000986s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001349s ] --------------------------------------------------------------- [ 2021-12-12T20:27:58+08:00 ] 39.144.3.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003107s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023943s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2021-12-12T20:28:05+08:00 ] 39.144.3.186 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211212&time=202701&v1=-01.245&v2=+00.006&v3=-01.107&v4=-00.720&v5=05.6&t=-00.6&h=72.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.165&a2=01.269&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211212',`time`='202701',`v1`=-1.245,`v2`=0.006,`v3`=-1.107,`v4`=-0.72,`v5`=5.6,`t`=-0.6,`h`=72.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.165,`a2`=1.269,`update_time`=1639312085 WHERE `imei` = '868922055684076' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015484s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211212' , '202701' , -1.245 , 0.006 , -1.107 , -0.72 , 5.6 , -0.6 , 72.1 , '460044618415249' , -0 , 0.165 , 1.269 , 1639312085 , 1639312085) [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2021-12-12T20:44:27+08:00 ] 39.144.13.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680157 [ sql ] [ DB ] CONNECT:[ UseTime:0.004011s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2021-12-12T20:44:35+08:00 ] 39.144.13.226 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055680157&date=211212&time=111158&v1=+00.020&v2=+00.009&v3=+00.014&v4=+00.015&v5=05.7&t=+09.9&h=70.0&rssi=+216&imsi=460044618415250&v6=-00.000&a1=00.028&a2=00.052&a3=00.001&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680157' LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680157',`date`='211212',`time`='111158',`v1`=0.02,`v2`=0.009,`v3`=0.014,`v4`=0.015,`v5`=5.7,`t`=9.9,`h`=70,`rssi`=216,`imsi`='460044618415250',`v6`=-0,`a1`=0.028,`a2`=0.052,`update_time`=1639313075 WHERE `imei` = '868922055680157' [ RunTime:0.000845s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016277s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055680157' , '211212' , '111158' , 0.02 , 0.009 , 0.014 , 0.015 , 5.7 , 9.9 , 70 , '460044618415250' , -0 , 0.028 , 0.052 , 1639313075 , 1639313075) [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2021-12-12T20:45:12+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004172s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036018s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001582s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001448s ] --------------------------------------------------------------- [ 2021-12-12T20:45:47+08:00 ] 123.234.86.34 GET /admin [ sql ] [ DB ] CONNECT:[ UseTime:0.002583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024831s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001268s ] --------------------------------------------------------------- [ 2021-12-12T21:04:56+08:00 ] 221.178.126.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034694s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000813s ] --------------------------------------------------------------- [ 2021-12-12T21:05:05+08:00 ] 221.178.126.249 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211212&time=210401&v1=-01.586&v2=+01.152&v3=-01.400&v4=+00.028&v5=06.0&t=-02.7&h=86.3&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.074&a2=17.111&a3=00.330&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027498s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211212',`time`='210401',`v1`=-1.586,`v2`=1.152,`v3`=-1.4,`v4`=0.028,`v5`=6,`t`=-2.7,`h`=86.3,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.074,`a2`=17.111,`update_time`=1639314305 WHERE `imei` = '868922055681221' [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018476s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681221' , '211212' , '210401' , -1.586 , 1.152 , -1.4 , 0.028 , 6 , -2.7 , 86.3 , '460044618415257' , -0 , 0.074 , 17.111 , 1639314305 , 1639314305) [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2021-12-12T21:58:08+08:00 ] 112.224.65.132 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029045s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000870s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021086s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001155s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001549s ] --------------------------------------------------------------- [ 2021-12-12T21:58:17+08:00 ] 112.224.65.132 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002457s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001270s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2021-12-12T22:27:57+08:00 ] 117.132.198.95 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003226s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.051548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001582s ] --------------------------------------------------------------- [ 2021-12-12T22:28:05+08:00 ] 117.132.198.95 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211212&time=222701&v1=-01.247&v2=+00.006&v3=-01.110&v4=-00.723&v5=05.9&t=-01.9&h=72.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.162&a2=01.269&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002428s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023947s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211212',`time`='222701',`v1`=-1.247,`v2`=0.006,`v3`=-1.11,`v4`=-0.723,`v5`=5.9,`t`=-1.9,`h`=72.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.162,`a2`=1.269,`update_time`=1639319285 WHERE `imei` = '868922055684076' [ RunTime:0.000854s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017540s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '211212' , '222701' , -1.247 , 0.006 , -1.11 , -0.723 , 5.9 , -1.9 , 72.1 , '460044618415249' , -0 , 0.162 , 1.269 , 1639319285 , 1639319285) [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2021-12-12T23:28:05+08:00 ] 223.80.204.39 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035599s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2021-12-12T23:31:09+08:00 ] 223.80.204.39 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025774s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001039s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2021-12-12T23:31:46+08:00 ] 223.80.204.39 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023475s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000717s ]