--------------------------------------------------------------- [ 2021-12-13T00:27:57+08:00 ] 39.144.1.128 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028686s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000763s ] --------------------------------------------------------------- [ 2021-12-13T00:28:05+08:00 ] 39.144.1.128 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=002701&v1=-01.294&v2=+00.006&v3=-01.155&v4=-00.766&v5=05.9&t=-03.1&h=72.1&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.313&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022516s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='002701',`v1`=-1.294,`v2`=0.006,`v3`=-1.155,`v4`=-0.766,`v5`=5.9,`t`=-3.1,`h`=72.1,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.313,`update_time`=1639326485 WHERE `imei` = '868922055684076' [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016851s ] [ 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' , '211213' , '002701' , -1.294 , 0.006 , -1.155 , -0.766 , 5.9 , -3.1 , 72.1 , '460044618415249' , -0 , 0.163 , 1.313 , 1639326485 , 1639326485) [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2021-12-13T02:27:57+08:00 ] 39.144.17.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003134s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026980s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2021-12-13T02:28:06+08:00 ] 39.144.17.148 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=022701&v1=-01.299&v2=+00.005&v3=-01.160&v4=-00.771&v5=05.9&t=-03.9&h=72.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.317&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001956s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033978s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001027s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='022701',`v1`=-1.299,`v2`=0.005,`v3`=-1.16,`v4`=-0.771,`v5`=5.9,`t`=-3.9,`h`=72,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.317,`update_time`=1639333686 WHERE `imei` = '868922055684076' [ RunTime:0.001056s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017922s ] [ 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' , '211213' , '022701' , -1.299 , 0.005 , -1.16 , -0.771 , 5.9 , -3.9 , 72 , '460044618415249' , -0 , 0.163 , 1.317 , 1639333686 , 1639333686) [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2021-12-13T03:04:57+08:00 ] 218.204.253.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.040104s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000836s ] --------------------------------------------------------------- [ 2021-12-13T03:05:06+08:00 ] 218.204.253.144 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211213&time=030401&v1=-01.203&v2=+00.514&v3=-01.218&v4=+00.028&v5=06.0&t=-06.4&h=86.1&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.019&a2=02.701&a3=00.004&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002180s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022697s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211213',`time`='030401',`v1`=-1.203,`v2`=0.514,`v3`=-1.218,`v4`=0.028,`v5`=6,`t`=-6.4,`h`=86.1,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.019,`a2`=2.701,`update_time`=1639335906 WHERE `imei` = '868922055681221' [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016199s ] [ 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' , '211213' , '030401' , -1.203 , 0.514 , -1.218 , 0.028 , 6 , -6.4 , 86.1 , '460044618415257' , -0 , 0.019 , 2.701 , 1639335906 , 1639335906) [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2021-12-13T04:27:58+08:00 ] 39.144.17.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003372s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031979s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2021-12-13T04:28:06+08:00 ] 39.144.17.232 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=042701&v1=-01.300&v2=+00.005&v3=-01.162&v4=-00.772&v5=05.9&t=-04.4&h=72.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.318&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002028s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='042701',`v1`=-1.3,`v2`=0.005,`v3`=-1.162,`v4`=-0.772,`v5`=5.9,`t`=-4.4,`h`=72,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.318,`update_time`=1639340886 WHERE `imei` = '868922055684076' [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017686s ] [ 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' , '211213' , '042701' , -1.3 , 0.005 , -1.162 , -0.772 , 5.9 , -4.4 , 72 , '460044618415249' , -0 , 0.163 , 1.318 , 1639340886 , 1639340886) [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2021-12-13T06:27:57+08:00 ] 39.144.5.169 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029462s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2021-12-13T06:28:06+08:00 ] 39.144.5.169 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=062701&v1=-01.300&v2=+00.005&v3=-01.162&v4=-00.773&v5=05.9&t=-05.0&h=72.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.163&a2=01.318&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='062701',`v1`=-1.3,`v2`=0.005,`v3`=-1.162,`v4`=-0.773,`v5`=5.9,`t`=-5,`h`=72,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.163,`a2`=1.318,`update_time`=1639348086 WHERE `imei` = '868922055684076' [ RunTime:0.000823s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018172s ] [ 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' , '211213' , '062701' , -1.3 , 0.005 , -1.162 , -0.773 , 5.9 , -5 , 72 , '460044618415249' , -0 , 0.163 , 1.318 , 1639348086 , 1639348086) [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2021-12-13T08:27:58+08:00 ] 223.104.255.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038274s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000791s ] --------------------------------------------------------------- [ 2021-12-13T08:28:06+08:00 ] 223.104.255.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=082701&v1=-01.250&v2=+00.005&v3=-01.114&v4=-00.726&v5=05.9&t=+00.6&h=71.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.161&a2=01.270&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021412s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='082701',`v1`=-1.25,`v2`=0.005,`v3`=-1.114,`v4`=-0.726,`v5`=5.9,`t`=0.6,`h`=71,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.161,`a2`=1.27,`update_time`=1639355286 WHERE `imei` = '868922055684076' [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013956s ] [ 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' , '211213' , '082701' , -1.25 , 0.005 , -1.114 , -0.726 , 5.9 , 0.6 , 71 , '460044618415249' , -0 , 0.161 , 1.27 , 1639355286 , 1639355286) [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2021-12-13T08:32:59+08:00 ] 223.80.204.39 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025905s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2021-12-13T08:33:10+08:00 ] 223.80.204.39 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023111s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000715s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2021-12-13T08:33:17+08:00 ] 223.80.204.39 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021280s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000578s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.001663s ] --------------------------------------------------------------- [ 2021-12-13T08:34:58+08:00 ] 223.80.204.39 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029279s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016642s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002416s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001516s ] --------------------------------------------------------------- [ 2021-12-13T09:04:57+08:00 ] 39.144.5.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028809s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2021-12-13T09:05:05+08:00 ] 39.144.5.250 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211213&time=090401&v1=-01.196&v2=+00.434&v3=-01.254&v4=+00.028&v5=06.0&t=+01.4&h=85.5&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.018&a2=01.321&a3=00.004&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211213',`time`='090401',`v1`=-1.196,`v2`=0.434,`v3`=-1.254,`v4`=0.028,`v5`=6,`t`=1.4,`h`=85.5,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.018,`a2`=1.321,`update_time`=1639357505 WHERE `imei` = '868922055681221' [ RunTime:0.000781s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017900s ] [ 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' , '211213' , '090401' , -1.196 , 0.434 , -1.254 , 0.028 , 6 , 1.4 , 85.5 , '460044618415257' , -0 , 0.018 , 1.321 , 1639357505 , 1639357505) [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2021-12-13T09:06:15+08:00 ] 112.224.65.122 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002379s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017139s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001686s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001304s ] --------------------------------------------------------------- [ 2021-12-13T10:14:48+08:00 ] 112.224.65.193 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025535s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018067s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001480s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.002594s ] --------------------------------------------------------------- [ 2021-12-13T10:14:52+08:00 ] 112.224.65.193 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023451s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000556s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000750s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2021-12-13T10:27:57+08:00 ] 117.132.193.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002986s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023725s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2021-12-13T10:28:06+08:00 ] 112.224.65.193 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031076s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017445s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001009s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001329s ] --------------------------------------------------------------- [ 2021-12-13T10:28:06+08:00 ] 117.132.193.224 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=102701&v1=-01.233&v2=+00.004&v3=-01.098&v4=-00.709&v5=06.0&t=+05.6&h=71.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.160&a2=01.254&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028010s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000815s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='102701',`v1`=-1.233,`v2`=0.004,`v3`=-1.098,`v4`=-0.709,`v5`=6,`t`=5.6,`h`=71,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=1.254,`update_time`=1639362486 WHERE `imei` = '868922055684076' [ RunTime:0.000871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016984s ] [ 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' , '211213' , '102701' , -1.233 , 0.004 , -1.098 , -0.709 , 6 , 5.6 , 71 , '460044618415249' , -0 , 0.16 , 1.254 , 1639362486 , 1639362486) [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2021-12-13T10:28:09+08:00 ] 112.224.65.193 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023930s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000747s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017502s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.005332s ] --------------------------------------------------------------- [ 2021-12-13T11:10:00+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.004329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.044465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023529s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002652s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.007712s ] --------------------------------------------------------------- [ 2021-12-13T11:36:52+08:00 ] 112.224.65.193 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028957s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018289s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000951s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.004587s ] --------------------------------------------------------------- [ 2021-12-13T12:27:58+08:00 ] 39.144.5.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003066s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2021-12-13T12:28:06+08:00 ] 39.144.5.219 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=122701&v1=-01.247&v2=+00.003&v3=-01.112&v4=-00.722&v5=05.6&t=+01.7&h=71.8&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.267&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003876s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039203s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001386s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='122701',`v1`=-1.247,`v2`=0.003,`v3`=-1.112,`v4`=-0.722,`v5`=5.6,`t`=1.7,`h`=71.8,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.267,`update_time`=1639369686 WHERE `imei` = '868922055684076' [ RunTime:0.000951s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023743s ] [ 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' , '211213' , '122701' , -1.247 , 0.003 , -1.112 , -0.722 , 5.6 , 1.7 , 71.8 , '460044618415249' , -0 , 0.159 , 1.267 , 1639369686 , 1639369686) [ RunTime:0.001196s ] --------------------------------------------------------------- [ 2021-12-13T12:38:37+08:00 ] 223.80.204.39 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033017s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018719s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000998s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.006531s ] --------------------------------------------------------------- [ 2021-12-13T13:11:44+08:00 ] 112.224.65.175 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003128s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017897s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001024s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.004784s ] --------------------------------------------------------------- [ 2021-12-13T13:51:32+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029088s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000842s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015894s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000980s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.004651s ] --------------------------------------------------------------- [ 2021-12-13T14:24:18+08:00 ] 39.144.3.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033209s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.004203s ] --------------------------------------------------------------- [ 2021-12-13T14:24:19+08:00 ] 39.144.3.120 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639376658&v1=0.030010&v2=16.867668&v3=0.007224&v4=0.007856&v5=5.220000&t=17.125103&h=62.069508&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ 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.022099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000960s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639376658,`v1`=0.03001,`v2`=16.867668,`v3`=0.007224,`v4`=0.007856,`v5`=5.22,`t`=17.125103,`h`=62.069508,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639376659 WHERE `imei` = '868922055677740' [ RunTime:0.001130s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019588s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639376658 , 0.03001 , 16.867668 , 0.007224 , 0.007856 , 5.22 , 17.125103 , 62.069508 , '89860426102071188502' , '460044618415252' , -0 , 1639376659) [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2021-12-13T14:24:46+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.038512s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000771s ] --------------------------------------------------------------- [ 2021-12-13T14:24:48+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026498s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001049s ] --------------------------------------------------------------- [ 2021-12-13T14:24:50+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022116s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000961s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000912s ] --------------------------------------------------------------- [ 2021-12-13T14:27:57+08:00 ] 39.144.5.154 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003930s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.277496s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2021-12-13T14:28:06+08:00 ] 39.144.5.154 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=142701&v1=-01.249&v2=+00.005&v3=-01.115&v4=-00.725&v5=06.0&t=+02.3&h=71.5&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.271&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026647s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='142701',`v1`=-1.249,`v2`=0.005,`v3`=-1.115,`v4`=-0.725,`v5`=6,`t`=2.3,`h`=71.5,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.271,`update_time`=1639376885 WHERE `imei` = '868922055684076' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010999s ] [ 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' , '211213' , '142701' , -1.249 , 0.005 , -1.115 , -0.725 , 6 , 2.3 , 71.5 , '460044618415249' , -0 , 0.159 , 1.271 , 1639376886 , 1639376886) [ RunTime:0.000568s ] --------------------------------------------------------------- [ 2021-12-13T14:34:31+08:00 ] 39.144.15.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003079s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000842s ] --------------------------------------------------------------- [ 2021-12-13T14:34:33+08:00 ] 39.144.15.245 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639377271&v1=0.007615&v2=1.528531&v3=0.007706&v4=0.008278&v5=11.880000&t=23.259848&h=46.116432&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&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.022037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000815s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639377271,`v1`=0.007615,`v2`=1.528531,`v3`=0.007706,`v4`=0.008278,`v5`=11.88,`t`=23.259848,`h`=46.116432,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639377273 WHERE `imei` = '868922055677740' [ RunTime:0.000924s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015880s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639377271 , 0.007615 , 1.528531 , 0.007706 , 0.008278 , 11.88 , 23.259848 , 46.116432 , '89860426102071188502' , '460044618415252' , -0 , 1639377273) [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2021-12-13T14:34:55+08:00 ] 123.234.86.34 GET /home/show/index.html?keyword=868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025331s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055677740%' AND `username` = 'user' LIMIT 1 [ RunTime:0.002218s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055677740%' AND `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001016s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000803s ] --------------------------------------------------------------- [ 2021-12-13T14:36:09+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034360s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001145s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001014s ] --------------------------------------------------------------- [ 2021-12-13T14:36:13+08:00 ] 123.234.86.34 GET /home/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002041s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000970s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.016319s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2021-12-13T14:36:17+08:00 ] 123.234.86.34 POST /home/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002264s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031394s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `interval`=2,`gps`='120.082436,36.159645',`introduce`=' ',`update_time`=1639377377 WHERE `id` = 22 [ RunTime:0.001379s ] --------------------------------------------------------------- [ 2021-12-13T14:36:18+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026019s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000555s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000941s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2021-12-13T14:36:48+08:00 ] 39.144.15.254 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021931s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000818s ] --------------------------------------------------------------- [ 2021-12-13T14:36:50+08:00 ] 39.144.15.254 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639377408&v1=0.007254&v2=0.827581&v3=0.007585&v4=0.008398&v5=12.060000&t=20.921780&h=52.723492&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002710s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000829s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639377408,`v1`=0.007254,`v2`=0.827581,`v3`=0.007585,`v4`=0.008398,`v5`=12.06,`t`=20.92178,`h`=52.723492,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639377410 WHERE `imei` = '868922055677740' [ RunTime:0.000954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014984s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639377408 , 0.007254 , 0.827581 , 0.007585 , 0.008398 , 12.06 , 20.92178 , 52.723492 , '89860426102071188502' , '460044618415252' , -0 , 1639377410) [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2021-12-13T14:37:02+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025567s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001061s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2021-12-13T14:37:06+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023055s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000551s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000901s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000786s ] --------------------------------------------------------------- [ 2021-12-13T14:37:08+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.022705s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000556s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000773s ] --------------------------------------------------------------- [ 2021-12-13T14:37:09+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023967s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000901s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2021-12-13T14:37:11+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022704s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001003s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000883s ] --------------------------------------------------------------- [ 2021-12-13T14:37:12+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023439s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001019s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000864s ] --------------------------------------------------------------- [ 2021-12-13T14:37:13+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002234s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021819s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2021-12-13T14:37:15+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022580s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000958s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000826s ] --------------------------------------------------------------- [ 2021-12-13T14:37:31+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002314s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021502s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000928s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2021-12-13T14:37:32+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024570s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000996s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000860s ] --------------------------------------------------------------- [ 2021-12-13T14:39:10+08:00 ] 218.204.253.241 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002318s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024335s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000883s ] --------------------------------------------------------------- [ 2021-12-13T14:39:11+08:00 ] 218.204.253.241 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639377550&v1=0.006050&v2=0.376761&v3=0.007375&v4=0.007977&v5=12.060000&t=19.313019&h=59.147446&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002166s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022000s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639377550,`v1`=0.00605,`v2`=0.376761,`v3`=0.007375,`v4`=0.007977,`v5`=12.06,`t`=19.313019,`h`=59.147446,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639377551 WHERE `imei` = '868922055677740' [ RunTime:0.000947s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015208s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639377550 , 0.00605 , 0.376761 , 0.007375 , 0.007977 , 12.06 , 19.313019 , 59.147446 , '89860426102071188502' , '460044618415252' , -0 , 1639377551) [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2021-12-13T14:39:20+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034703s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000824s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001183s ] --------------------------------------------------------------- [ 2021-12-13T14:41:33+08:00 ] 39.144.17.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025958s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000986s ] --------------------------------------------------------------- [ 2021-12-13T14:41:35+08:00 ] 39.144.17.219 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639377693&v1=0.007074&v2=0.406906&v3=0.007344&v4=0.007916&v5=12.060000&t=18.572989&h=58.697311&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024048s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000952s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639377693,`v1`=0.007074,`v2`=0.406906,`v3`=0.007344,`v4`=0.007916,`v5`=12.06,`t`=18.572989,`h`=58.697311,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639377695 WHERE `imei` = '868922055677740' [ RunTime:0.000952s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016515s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639377693 , 0.007074 , 0.406906 , 0.007344 , 0.007916 , 12.06 , 18.572989 , 58.697311 , '89860426102071188502' , '460044618415252' , -0 , 1639377695) [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2021-12-13T14:41:40+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022232s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000530s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000945s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000916s ] --------------------------------------------------------------- [ 2021-12-13T15:04:56+08:00 ] 117.132.196.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031189s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000948s ] --------------------------------------------------------------- [ 2021-12-13T15:05:05+08:00 ] 117.132.196.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211213&time=150401&v1=-01.434&v2=+01.050&v3=-01.440&v4=+00.029&v5=06.2&t=+13.1&h=85.8&rssi=+222&imsi=460044618415257&v6=-00.000&a1=00.120&a2=00.216&a3=00.108&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003288s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034577s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211213',`time`='150401',`v1`=-1.434,`v2`=1.05,`v3`=-1.44,`v4`=0.029,`v5`=6.2,`t`=13.1,`h`=85.8,`rssi`=222,`imsi`='460044618415257',`v6`=-0,`a1`=0.12,`a2`=0.216,`update_time`=1639379105 WHERE `imei` = '868922055681221' [ RunTime:0.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019436s ] [ 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' , '211213' , '150401' , -1.434 , 1.05 , -1.44 , 0.029 , 6.2 , 13.1 , 85.8 , '460044618415257' , -0 , 0.12 , 0.216 , 1639379105 , 1639379105) [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2021-12-13T15:48:06+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026957s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001141s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021813s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.012990s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 140,10 [ RunTime:0.004828s ] --------------------------------------------------------------- [ 2021-12-13T15:48:13+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001901s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023632s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015604s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000928s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001393s ] --------------------------------------------------------------- [ 2021-12-13T15:48:23+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022501s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015166s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000939s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.004490s ] --------------------------------------------------------------- [ 2021-12-13T16:27:58+08:00 ] 39.144.15.145 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003066s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031300s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2021-12-13T16:28:06+08:00 ] 39.144.15.145 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=162701&v1=-01.251&v2=+00.006&v3=-01.117&v4=-00.727&v5=06.0&t=+01.6&h=71.7&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.273&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002172s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029074s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000973s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='162701',`v1`=-1.251,`v2`=0.006,`v3`=-1.117,`v4`=-0.727,`v5`=6,`t`=1.6,`h`=71.7,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.273,`update_time`=1639384086 WHERE `imei` = '868922055684076' [ RunTime:0.000931s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021526s ] [ 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' , '211213' , '162701' , -1.251 , 0.006 , -1.117 , -0.727 , 6 , 1.6 , 71.7 , '460044618415249' , -0 , 0.159 , 1.273 , 1639384086 , 1639384086) [ RunTime:0.000919s ] --------------------------------------------------------------- [ 2021-12-13T18:27:57+08:00 ] 117.132.195.77 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005211s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.058240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001354s ] --------------------------------------------------------------- [ 2021-12-13T18:28:05+08:00 ] 117.132.195.77 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=182701&v1=-01.261&v2=+00.005&v3=-01.126&v4=-00.736&v5=05.6&t=-01.6&h=72.3&rssi=+230&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.281&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002256s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025709s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='182701',`v1`=-1.261,`v2`=0.005,`v3`=-1.126,`v4`=-0.736,`v5`=5.6,`t`=-1.6,`h`=72.3,`rssi`=230,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.281,`update_time`=1639391285 WHERE `imei` = '868922055684076' [ RunTime:0.000865s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019279s ] [ 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' , '211213' , '182701' , -1.261 , 0.005 , -1.126 , -0.736 , 5.6 , -1.6 , 72.3 , '460044618415249' , -0 , 0.159 , 1.281 , 1639391285 , 1639391285) [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2021-12-13T18:30:08+08:00 ] 223.80.204.39 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018489s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001048s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005221s ] --------------------------------------------------------------- [ 2021-12-13T18:56:15+08:00 ] 223.80.204.39 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003096s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000817s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015485s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.004642s ] --------------------------------------------------------------- [ 2021-12-13T20:27:59+08:00 ] 117.132.195.131 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.024143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.051642s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000905s ] --------------------------------------------------------------- [ 2021-12-13T20:28:06+08:00 ] 117.132.195.131 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=202701&v1=-01.264&v2=+00.003&v3=-01.130&v4=-00.739&v5=05.4&t=-00.9&h=71.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.286&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003767s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000776s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='202701',`v1`=-1.264,`v2`=0.003,`v3`=-1.13,`v4`=-0.739,`v5`=5.4,`t`=-0.9,`h`=71.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.286,`update_time`=1639398486 WHERE `imei` = '868922055684076' [ RunTime:0.000742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.044455s ] [ 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' , '211213' , '202701' , -1.264 , 0.003 , -1.13 , -0.739 , 5.4 , -0.9 , 71.7 , '460044618415249' , -0 , 0.159 , 1.286 , 1639398486 , 1639398486) [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2021-12-13T21:04:57+08:00 ] 39.144.4.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2021-12-13T21:05:06+08:00 ] 39.144.4.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211213&time=210401&v1=-01.377&v2=+00.523&v3=-01.375&v4=+00.028&v5=06.0&t=-00.5&h=86.2&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.021&a2=02.313&a3=00.010&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036029s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.001001s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211213',`time`='210401',`v1`=-1.377,`v2`=0.523,`v3`=-1.375,`v4`=0.028,`v5`=6,`t`=-0.5,`h`=86.2,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.021,`a2`=2.313,`update_time`=1639400706 WHERE `imei` = '868922055681221' [ RunTime:0.001033s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.038181s ] [ 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' , '211213' , '210401' , -1.377 , 0.523 , -1.375 , 0.028 , 6 , -0.5 , 86.2 , '460044618415257' , -0 , 0.021 , 2.313 , 1639400706 , 1639400706) [ RunTime:0.001021s ] --------------------------------------------------------------- [ 2021-12-13T22:27:56+08:00 ] 39.144.16.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038710s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001336s ] --------------------------------------------------------------- [ 2021-12-13T22:28:04+08:00 ] 39.144.16.28 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211213&time=222701&v1=-01.271&v2=+00.004&v3=-01.137&v4=-00.747&v5=05.9&t=-00.8&h=71.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.292&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002156s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000872s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211213',`time`='222701',`v1`=-1.271,`v2`=0.004,`v3`=-1.137,`v4`=-0.747,`v5`=5.9,`t`=-0.8,`h`=71.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.292,`update_time`=1639405684 WHERE `imei` = '868922055684076' [ RunTime:0.000817s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018274s ] [ 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' , '211213' , '222701' , -1.271 , 0.004 , -1.137 , -0.747 , 5.9 , -0.8 , 71.8 , '460044618415249' , -0 , 0.159 , 1.292 , 1639405684 , 1639405684) [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2021-12-13T22:37:11+08:00 ] 112.224.67.88 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003264s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026291s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015202s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001025s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005632s ]