--------------------------------------------------------------- [ 2021-12-14T00:27:57+08:00 ] 39.144.3.229 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2021-12-14T00:28:06+08:00 ] 39.144.3.229 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=002701&v1=-01.271&v2=+00.004&v3=-01.136&v4=-00.746&v5=05.9&t=+00.1&h=71.5&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.292&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002202s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='002701',`v1`=-1.271,`v2`=0.004,`v3`=-1.136,`v4`=-0.746,`v5`=5.9,`t`=0.1,`h`=71.5,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.292,`update_time`=1639412886 WHERE `imei` = '868922055684076' [ RunTime:0.000792s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020642s ] [ 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' , '211214' , '002701' , -1.271 , 0.004 , -1.136 , -0.746 , 5.9 , 0.1 , 71.5 , '460044618415249' , -0 , 0.159 , 1.292 , 1639412886 , 1639412886) [ RunTime:0.001976s ] --------------------------------------------------------------- [ 2021-12-14T02:27:58+08:00 ] 39.144.2.241 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003168s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030073s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000839s ] --------------------------------------------------------------- [ 2021-12-14T02:28:06+08:00 ] 39.144.2.241 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=022701&v1=-01.268&v2=+00.005&v3=-01.134&v4=-00.744&v5=05.9&t=+00.8&h=71.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.159&a2=01.290&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002283s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='022701',`v1`=-1.268,`v2`=0.005,`v3`=-1.134,`v4`=-0.744,`v5`=5.9,`t`=0.8,`h`=71.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.159,`a2`=1.29,`update_time`=1639420086 WHERE `imei` = '868922055684076' [ RunTime:0.000745s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016495s ] [ 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' , '211214' , '022701' , -1.268 , 0.005 , -1.134 , -0.744 , 5.9 , 0.8 , 71.5 , '460044618415249' , -0 , 0.159 , 1.29 , 1639420086 , 1639420086) [ RunTime:0.000776s ] --------------------------------------------------------------- [ 2021-12-14T03:04:57+08:00 ] 221.178.125.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003638s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039493s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2021-12-14T03:05:05+08:00 ] 221.178.125.75 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211214&time=030401&v1=-01.407&v2=+00.325&v3=-01.415&v4=+00.028&v5=06.0&t=+02.6&h=86.3&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.018&a2=01.410&a3=00.003&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002064s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022783s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211214',`time`='030401',`v1`=-1.407,`v2`=0.325,`v3`=-1.415,`v4`=0.028,`v5`=6,`t`=2.6,`h`=86.3,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.018,`a2`=1.41,`update_time`=1639422305 WHERE `imei` = '868922055681221' [ RunTime:0.000687s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019936s ] [ 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' , '211214' , '030401' , -1.407 , 0.325 , -1.415 , 0.028 , 6 , 2.6 , 86.3 , '460044618415257' , -0 , 0.018 , 1.41 , 1639422305 , 1639422305) [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2021-12-14T04:27:57+08:00 ] 117.132.197.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.006785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.055671s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001557s ] --------------------------------------------------------------- [ 2021-12-14T04:28:06+08:00 ] 117.132.197.148 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=042701&v1=-01.263&v2=+00.004&v3=-01.129&v4=-00.739&v5=06.0&t=+03.3&h=71.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.158&a2=01.285&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025619s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000781s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='042701',`v1`=-1.263,`v2`=0.004,`v3`=-1.129,`v4`=-0.739,`v5`=6,`t`=3.3,`h`=71,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.158,`a2`=1.285,`update_time`=1639427286 WHERE `imei` = '868922055684076' [ RunTime:0.000925s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020502s ] [ 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' , '211214' , '042701' , -1.263 , 0.004 , -1.129 , -0.739 , 6 , 3.3 , 71 , '460044618415249' , -0 , 0.158 , 1.285 , 1639427286 , 1639427286) [ RunTime:0.001081s ] --------------------------------------------------------------- [ 2021-12-14T06:27:58+08:00 ] 221.178.124.177 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032291s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2021-12-14T06:28:06+08:00 ] 221.178.124.177 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=062701&v1=-01.264&v2=+00.004&v3=-01.131&v4=-00.741&v5=06.0&t=+03.7&h=71.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.285&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033526s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001353s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='062701',`v1`=-1.264,`v2`=0.004,`v3`=-1.131,`v4`=-0.741,`v5`=6,`t`=3.7,`h`=71.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.285,`update_time`=1639434486 WHERE `imei` = '868922055684076' [ RunTime:0.001107s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023557s ] [ 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' , '211214' , '062701' , -1.264 , 0.004 , -1.131 , -0.741 , 6 , 3.7 , 71.2 , '460044618415249' , -0 , 0.157 , 1.285 , 1639434486 , 1639434486) [ RunTime:0.001010s ] --------------------------------------------------------------- [ 2021-12-14T08:27:57+08:00 ] 223.104.255.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003370s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028118s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000854s ] --------------------------------------------------------------- [ 2021-12-14T08:28:05+08:00 ] 223.104.255.146 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=082701&v1=-01.263&v2=+00.004&v3=-01.130&v4=-00.741&v5=06.0&t=+04.4&h=71.2&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.284&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002300s ] 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.001007s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='082701',`v1`=-1.263,`v2`=0.004,`v3`=-1.13,`v4`=-0.741,`v5`=6,`t`=4.4,`h`=71.2,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.284,`update_time`=1639441685 WHERE `imei` = '868922055684076' [ RunTime:0.001101s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017854s ] [ 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' , '211214' , '082701' , -1.263 , 0.004 , -1.13 , -0.741 , 6 , 4.4 , 71.2 , '460044618415249' , -0 , 0.157 , 1.284 , 1639441685 , 1639441685) [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2021-12-14T09:04:56+08:00 ] 221.178.124.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028594s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2021-12-14T09:05:05+08:00 ] 221.178.124.73 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211214&time=090401&v1=-01.334&v2=+00.930&v3=-01.350&v4=+00.028&v5=06.0&t=+05.9&h=86.2&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.042&a2=20.472&a3=00.375&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000757s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211214',`time`='090401',`v1`=-1.334,`v2`=0.93,`v3`=-1.35,`v4`=0.028,`v5`=6,`t`=5.9,`h`=86.2,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.042,`a2`=20.472,`update_time`=1639443905 WHERE `imei` = '868922055681221' [ RunTime:0.000735s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020620s ] [ 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' , '211214' , '090401' , -1.334 , 0.93 , -1.35 , 0.028 , 6 , 5.9 , 86.2 , '460044618415257' , -0 , 0.042 , 20.472 , 1639443905 , 1639443905) [ RunTime:0.002597s ] --------------------------------------------------------------- [ 2021-12-14T10:27:57+08:00 ] 223.104.255.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.043428s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001150s ] --------------------------------------------------------------- [ 2021-12-14T10:28:06+08:00 ] 223.104.255.122 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=102701&v1=-01.262&v2=+00.006&v3=-01.129&v4=-00.737&v5=06.0&t=+09.4&h=69.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.283&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001010s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='102701',`v1`=-1.262,`v2`=0.006,`v3`=-1.129,`v4`=-0.737,`v5`=6,`t`=9.4,`h`=69.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.283,`update_time`=1639448886 WHERE `imei` = '868922055684076' [ RunTime:0.000730s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020704s ] [ 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' , '211214' , '102701' , -1.262 , 0.006 , -1.129 , -0.737 , 6 , 9.4 , 69.9 , '460044618415249' , -0 , 0.156 , 1.283 , 1639448886 , 1639448886) [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2021-12-14T10:50:55+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.037870s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2021-12-14T10:50:56+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025095s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.002696s ] --------------------------------------------------------------- [ 2021-12-14T10:51:07+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034402s ] [ 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.001078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.001011s ] --------------------------------------------------------------- [ 2021-12-14T10:51:10+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023994s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019475s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001002s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001665s ] --------------------------------------------------------------- [ 2021-12-14T10:51:21+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=17 [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024254s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016033s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000989s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 160,10 [ RunTime:0.005053s ] --------------------------------------------------------------- [ 2021-12-14T10:51:24+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030156s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016583s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005346s ] --------------------------------------------------------------- [ 2021-12-14T10:52:28+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.002708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024621s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017005s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001436s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001308s ] --------------------------------------------------------------- [ 2021-12-14T10:52:32+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=17 [ sql ] [ DB ] CONNECT:[ UseTime:0.003476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035772s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000908s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017886s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001010s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 160,10 [ RunTime:0.007146s ] --------------------------------------------------------------- [ 2021-12-14T10:57:53+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002701s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028308s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2021-12-14T10:57:55+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002886s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.001199s ] --------------------------------------------------------------- [ 2021-12-14T10:58:45+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.029199s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000894s ] --------------------------------------------------------------- [ 2021-12-14T10:58:46+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025173s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000852s ] --------------------------------------------------------------- [ 2021-12-14T10:59:44+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035723s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2021-12-14T10:59:48+08:00 ] 123.234.86.34 GET /home/show/edit/id/26.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002248s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027234s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014586s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000461s ] --------------------------------------------------------------- [ 2021-12-14T11:00:26+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024142s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000919s ] --------------------------------------------------------------- [ 2021-12-14T11:00:46+08:00 ] 123.234.86.34 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022221s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000669s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016452s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000441s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000484s ] --------------------------------------------------------------- [ 2021-12-14T11:01:04+08:00 ] 123.234.86.34 GET /home/data/index.html?keyword=868922055684076&start_date=2021-11-05&end_date=2021-12-14 [ sql ] [ DB ] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000776s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.001165s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016336s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1636041600 AND `update_time` <= 1639411200 ) LIMIT 1 [ RunTime:0.001133s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1636041600 AND `update_time` <= 1639411200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.005642s ] --------------------------------------------------------------- [ 2021-12-14T11:05:05+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002844s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028657s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000880s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2021-12-14T11:05:13+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025763s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000711s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2021-12-14T11:05:15+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022117s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017905s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001031s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001333s ] --------------------------------------------------------------- [ 2021-12-14T11:08:07+08:00 ] 123.234.86.34 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.034537s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2021-12-14T11:10:34+08:00 ] 123.234.86.34 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.003080s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023859s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2021-12-14T11:21:25+08:00 ] 123.234.86.34 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003581s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.026008s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2021-12-14T11:29:53+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006057s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.030582s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2021-12-14T11:29:54+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001086s ] --------------------------------------------------------------- [ 2021-12-14T11:29:56+08:00 ] 123.234.86.34 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002257s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.023380s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2021-12-14T11:30:06+08:00 ] 123.234.86.34 POST /home/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002159s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.025345s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='11111111',`user_email`='2343525',`introduce`=' ',`update_time`=1639452606 WHERE `id` = 1 [ RunTime:0.001075s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `password`='b8c6b861afec5f2a9a13ad8f963df1c7',`update_time`=1639452606 WHERE `id` = 1 [ RunTime:0.001582s ] --------------------------------------------------------------- [ 2021-12-14T11:30:19+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.026180s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2021-12-14T11:30:20+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002292s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001160s ] --------------------------------------------------------------- [ 2021-12-14T11:30:23+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029774s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001098s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001002s ] --------------------------------------------------------------- [ 2021-12-14T12:27:58+08:00 ] 39.144.2.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.056304s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001423s ] --------------------------------------------------------------- [ 2021-12-14T12:28:06+08:00 ] 39.144.2.116 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=122701&v1=-01.262&v2=+00.004&v3=-01.130&v4=-00.739&v5=06.0&t=+10.7&h=70.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.154&a2=01.282&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.020935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='122701',`v1`=-1.262,`v2`=0.004,`v3`=-1.13,`v4`=-0.739,`v5`=6,`t`=10.7,`h`=70.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.154,`a2`=1.282,`update_time`=1639456086 WHERE `imei` = '868922055684076' [ RunTime:0.000728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016286s ] [ 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' , '211214' , '122701' , -1.262 , 0.004 , -1.13 , -0.739 , 6 , 10.7 , 70.5 , '460044618415249' , -0 , 0.154 , 1.282 , 1639456086 , 1639456086) [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2021-12-14T13:11:53+08:00 ] 223.80.204.39 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003304s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028839s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018499s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001096s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005415s ] --------------------------------------------------------------- [ 2021-12-14T13:54:40+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003237s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026749s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001334s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005043s ] --------------------------------------------------------------- [ 2021-12-14T14:27:57+08:00 ] 221.178.124.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000796s ] --------------------------------------------------------------- [ 2021-12-14T14:28:06+08:00 ] 221.178.124.89 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=142701&v1=-01.267&v2=+00.006&v3=-01.135&v4=-00.744&v5=06.0&t=+10.7&h=70.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.154&a2=01.288&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024013s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='142701',`v1`=-1.267,`v2`=0.006,`v3`=-1.135,`v4`=-0.744,`v5`=6,`t`=10.7,`h`=70.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.154,`a2`=1.288,`update_time`=1639463286 WHERE `imei` = '868922055684076' [ RunTime:0.000838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024347s ] [ 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' , '211214' , '142701' , -1.267 , 0.006 , -1.135 , -0.744 , 6 , 10.7 , 70.9 , '460044618415249' , -0 , 0.154 , 1.288 , 1639463286 , 1639463286) [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2021-12-14T14:36:02+08:00 ] 221.178.127.233 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027524s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000884s ] --------------------------------------------------------------- [ 2021-12-14T14:36:03+08:00 ] 221.178.127.233 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639463762&v1=0.009963&v2=5.618244&v3=0.007284&v4=0.010023&v5=10.980000&t=17.157278&h=59.864609&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002002s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032363s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000951s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639463762,`v1`=0.009963,`v2`=5.618244,`v3`=0.007284,`v4`=0.010023,`v5`=10.98,`t`=17.157278,`h`=59.864609,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639463763 WHERE `imei` = '868922055677740' [ RunTime:0.001061s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017191s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639463762 , 0.009963 , 5.618244 , 0.007284 , 0.010023 , 10.98 , 17.157278 , 59.864609 , '89860426102071188502' , '460044618415252' , -0 , 1639463763) [ RunTime:0.002202s ] --------------------------------------------------------------- [ 2021-12-14T14:36:35+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.024138s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2021-12-14T14:36:45+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.026826s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2021-12-14T14:36:46+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002096s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022264s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001047s ] --------------------------------------------------------------- [ 2021-12-14T14:36:48+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002205s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026384s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000923s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2021-12-14T14:38:26+08:00 ] 117.132.193.183 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024121s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000824s ] --------------------------------------------------------------- [ 2021-12-14T14:38:54+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025018s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000841s ] --------------------------------------------------------------- [ 2021-12-14T14:38:58+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021606s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000545s ] [ 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.000846s ] --------------------------------------------------------------- [ 2021-12-14T14:38:59+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002227s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026196s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001146s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000877s ] --------------------------------------------------------------- [ 2021-12-14T14:39:01+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ 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.031673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.028000s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001576s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.002092s ] --------------------------------------------------------------- [ 2021-12-14T14:39:05+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=51 [ sql ] [ DB ] CONNECT:[ UseTime:0.003080s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001260s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022428s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001585s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 500,10 [ RunTime:0.023635s ] --------------------------------------------------------------- [ 2021-12-14T14:39:23+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=51 [ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024450s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017376s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000996s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 500,10 [ RunTime:0.014800s ] --------------------------------------------------------------- [ 2021-12-14T14:39:24+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=51 [ sql ] [ DB ] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023084s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000865s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017352s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001015s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 500,10 [ RunTime:0.014813s ] --------------------------------------------------------------- [ 2021-12-14T14:40:31+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=50 [ sql ] [ DB ] CONNECT:[ UseTime:0.003670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027936s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016206s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000912s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 490,10 [ RunTime:0.015239s ] --------------------------------------------------------------- [ 2021-12-14T14:40:41+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000997s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000950s ] --------------------------------------------------------------- [ 2021-12-14T14:40:49+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025654s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001132s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001007s ] --------------------------------------------------------------- [ 2021-12-14T14:40:51+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024191s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000576s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000887s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2021-12-14T14:41:42+08:00 ] 221.178.124.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023981s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001144s ] --------------------------------------------------------------- [ 2021-12-14T14:41:43+08:00 ] 221.178.124.202 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464102&v1=0.013154&v2=8.243993&v3=0.007194&v4=0.010746&v5=10.800000&t=14.669059&h=67.188835&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002358s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000855s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464102,`v1`=0.013154,`v2`=8.243993,`v3`=0.007194,`v4`=0.010746,`v5`=10.8,`t`=14.669059,`h`=67.188835,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464103 WHERE `imei` = '868922055677740' [ RunTime:0.001150s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014436s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464102 , 0.013154 , 8.243993 , 0.007194 , 0.010746 , 10.8 , 14.669059 , 67.188835 , '89860426102071188502' , '460044618415252' , -0 , 1639464103) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2021-12-14T14:41:44+08:00 ] 221.178.124.202 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639463905&v1=0.000000&v2=5.660000&v3=0.000000&v4=0.000000&v5=11.160000&t=15.490000&h=63.660000&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002216s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000859s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639463905,`v1`=0,`v2`=5.66,`v3`=0,`v4`=0,`v5`=11.16,`t`=15.49,`h`=63.66,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464104 WHERE `imei` = '868922055677740' [ RunTime:0.000927s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016225s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639463905 , 0 , 5.66 , 0 , 0 , 11.16 , 15.49 , 63.66 , '89860426102071188502' , '460044618415252' , -0 , 1639464104) [ RunTime:0.000540s ] --------------------------------------------------------------- [ 2021-12-14T14:41:57+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026829s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001125s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000995s ] --------------------------------------------------------------- [ 2021-12-14T14:43:11+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024951s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018129s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001066s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.007146s ] --------------------------------------------------------------- [ 2021-12-14T14:44:06+08:00 ] 39.144.4.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002995s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027091s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000879s ] --------------------------------------------------------------- [ 2021-12-14T14:44:07+08:00 ] 39.144.4.40 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464246&v1=0.012793&v2=7.768139&v3=0.007194&v4=0.010144&v5=11.160000&t=14.443832&h=67.486382&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002406s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024633s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464246,`v1`=0.012793,`v2`=7.768139,`v3`=0.007194,`v4`=0.010144,`v5`=11.16,`t`=14.443832,`h`=67.486382,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464247 WHERE `imei` = '868922055677740' [ RunTime:0.000994s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017739s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464246 , 0.012793 , 7.768139 , 0.007194 , 0.010144 , 11.16 , 14.443832 , 67.486382 , '89860426102071188502' , '460044618415252' , -0 , 1639464247) [ RunTime:0.000538s ] --------------------------------------------------------------- [ 2021-12-14T14:44:13+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024925s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001050s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000902s ] --------------------------------------------------------------- [ 2021-12-14T14:46:28+08:00 ] 221.178.127.7 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002936s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024893s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000802s ] --------------------------------------------------------------- [ 2021-12-14T14:46:30+08:00 ] 221.178.127.7 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464388&v1=0.012191&v2=7.852211&v3=0.007224&v4=0.010144&v5=11.160000&t=14.358031&h=68.012810&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002244s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023667s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000881s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464388,`v1`=0.012191,`v2`=7.852211,`v3`=0.007224,`v4`=0.010144,`v5`=11.16,`t`=14.358031,`h`=68.01281,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464390 WHERE `imei` = '868922055677740' [ RunTime:0.000940s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016021s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464388 , 0.012191 , 7.852211 , 0.007224 , 0.010144 , 11.16 , 14.358031 , 68.01281 , '89860426102071188502' , '460044618415252' , -0 , 1639464390) [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2021-12-14T14:48:06+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028097s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001153s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2021-12-14T14:48:50+08:00 ] 117.132.195.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000921s ] --------------------------------------------------------------- [ 2021-12-14T14:48:52+08:00 ] 117.132.195.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464530&v1=0.012191&v2=7.885173&v3=0.007104&v4=0.011468&v5=10.980000&t=14.293681&h=68.142509&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002159s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023302s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001314s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464530,`v1`=0.012191,`v2`=7.885173,`v3`=0.007104,`v4`=0.011468,`v5`=10.98,`t`=14.293681,`h`=68.142509,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464532 WHERE `imei` = '868922055677740' [ RunTime:0.000985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022268s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464530 , 0.012191 , 7.885173 , 0.007104 , 0.011468 , 10.98 , 14.293681 , 68.142509 , '89860426102071188502' , '460044618415252' , -0 , 1639464532) [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2021-12-14T14:51:12+08:00 ] 117.132.195.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.026243s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000874s ] --------------------------------------------------------------- [ 2021-12-14T14:51:14+08:00 ] 117.132.195.152 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464672&v1=0.012973&v2=7.786810&v3=0.007104&v4=0.010144&v5=10.800000&t=14.240056&h=68.325615&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002032s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022333s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000799s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464672,`v1`=0.012973,`v2`=7.78681,`v3`=0.007104,`v4`=0.010144,`v5`=10.8,`t`=14.240056,`h`=68.325615,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464674 WHERE `imei` = '868922055677740' [ RunTime:0.001050s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023780s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464672 , 0.012973 , 7.78681 , 0.007104 , 0.010144 , 10.8 , 14.240056 , 68.325615 , '89860426102071188502' , '460044618415252' , -0 , 1639464674) [ RunTime:0.001030s ] --------------------------------------------------------------- [ 2021-12-14T14:51:28+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002059s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028251s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001017s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000853s ] --------------------------------------------------------------- [ 2021-12-14T14:53:34+08:00 ] 39.144.2.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027633s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000943s ] --------------------------------------------------------------- [ 2021-12-14T14:53:36+08:00 ] 39.144.2.163 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464814&v1=0.011709&v2=7.758334&v3=0.007134&v4=0.009662&v5=10.980000&t=14.175705&h=68.508720&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002218s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024865s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001001s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464814,`v1`=0.011709,`v2`=7.758334,`v3`=0.007134,`v4`=0.009662,`v5`=10.98,`t`=14.175705,`h`=68.50872,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464816 WHERE `imei` = '868922055677740' [ RunTime:0.001115s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018601s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464814 , 0.011709 , 7.758334 , 0.007134 , 0.009662 , 10.98 , 14.175705 , 68.50872 , '89860426102071188502' , '460044618415252' , -0 , 1639464816) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2021-12-14T14:55:56+08:00 ] 117.132.194.110 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027849s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000918s ] --------------------------------------------------------------- [ 2021-12-14T14:55:58+08:00 ] 117.132.194.110 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639464956&v1=0.010746&v2=7.713273&v3=0.007194&v4=0.009602&v5=10.980000&t=14.164980&h=68.501091&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025126s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000974s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639464956,`v1`=0.010746,`v2`=7.713273,`v3`=0.007194,`v4`=0.009602,`v5`=10.98,`t`=14.16498,`h`=68.501091,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639464958 WHERE `imei` = '868922055677740' [ RunTime:0.001028s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016847s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639464956 , 0.010746 , 7.713273 , 0.007194 , 0.009602 , 10.98 , 14.16498 , 68.501091 , '89860426102071188502' , '460044618415252' , -0 , 1639464958) [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2021-12-14T14:58:18+08:00 ] 39.144.14.161 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.028048s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2021-12-14T14:58:20+08:00 ] 39.144.14.161 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465098&v1=0.010625&v2=7.790670&v3=0.007104&v4=0.009542&v5=10.980000&t=14.164980&h=68.707085&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002222s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028517s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465098,`v1`=0.010625,`v2`=7.79067,`v3`=0.007104,`v4`=0.009542,`v5`=10.98,`t`=14.16498,`h`=68.707085,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465100 WHERE `imei` = '868922055677740' [ RunTime:0.000934s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018183s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465098 , 0.010625 , 7.79067 , 0.007104 , 0.009542 , 10.98 , 14.16498 , 68.707085 , '89860426102071188502' , '460044618415252' , -0 , 1639465100) [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2021-12-14T15:00:42+08:00 ] 218.204.253.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003337s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000846s ] --------------------------------------------------------------- [ 2021-12-14T15:00:43+08:00 ] 218.204.253.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465242&v1=0.010866&v2=7.864416&v3=0.007104&v4=0.009482&v5=10.980000&t=14.164980&h=68.577385&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025186s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000912s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465242,`v1`=0.010866,`v2`=7.864416,`v3`=0.007104,`v4`=0.009482,`v5`=10.98,`t`=14.16498,`h`=68.577385,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465243 WHERE `imei` = '868922055677740' [ RunTime:0.001277s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016477s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465242 , 0.010866 , 7.864416 , 0.007104 , 0.009482 , 10.98 , 14.16498 , 68.577385 , '89860426102071188502' , '460044618415252' , -0 , 1639465243) [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2021-12-14T15:02:02+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001986s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024721s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000882s ] --------------------------------------------------------------- [ 2021-12-14T15:02:05+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022712s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000942s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2021-12-14T15:02:23+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002167s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023911s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2021-12-14T15:02:24+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002095s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024382s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2021-12-14T15:02:25+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024405s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001207s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2021-12-14T15:02:26+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.040362s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031171s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000522s ] [ 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.000803s ] --------------------------------------------------------------- [ 2021-12-14T15:03:05+08:00 ] 117.132.191.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002422s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024667s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000952s ] --------------------------------------------------------------- [ 2021-12-14T15:03:06+08:00 ] 117.132.191.97 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465385&v1=0.011288&v2=8.431435&v3=0.007104&v4=0.009602&v5=10.980000&t=14.175705&h=68.424797&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002137s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032450s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001195s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465385,`v1`=0.011288,`v2`=8.431435,`v3`=0.007104,`v4`=0.009602,`v5`=10.98,`t`=14.175705,`h`=68.424797,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465386 WHERE `imei` = '868922055677740' [ RunTime:0.000926s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016279s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465385 , 0.011288 , 8.431435 , 0.007104 , 0.009602 , 10.98 , 14.175705 , 68.424797 , '89860426102071188502' , '460044618415252' , -0 , 1639465386) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2021-12-14T15:03:11+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024678s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000560s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000987s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000825s ] --------------------------------------------------------------- [ 2021-12-14T15:04:56+08:00 ] 218.204.253.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.002521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029707s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000794s ] --------------------------------------------------------------- [ 2021-12-14T15:05:05+08:00 ] 218.204.253.123 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211214&time=150401&v1=-01.326&v2=+00.683&v3=-01.282&v4=+00.029&v5=06.2&t=+15.0&h=85.7&rssi=+222&imsi=460044618415257&v6=-00.000&a1=00.025&a2=11.641&a3=00.148&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.024507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000957s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211214',`time`='150401',`v1`=-1.326,`v2`=0.683,`v3`=-1.282,`v4`=0.029,`v5`=6.2,`t`=15,`h`=85.7,`rssi`=222,`imsi`='460044618415257',`v6`=-0,`a1`=0.025,`a2`=11.641,`update_time`=1639465505 WHERE `imei` = '868922055681221' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016534s ] [ 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' , '211214' , '150401' , -1.326 , 0.683 , -1.282 , 0.029 , 6.2 , 15 , 85.7 , '460044618415257' , -0 , 0.025 , 11.641 , 1639465505 , 1639465505) [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2021-12-14T15:05:27+08:00 ] 117.132.198.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.025658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2021-12-14T15:05:28+08:00 ] 117.132.198.73 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465527&v1=0.010746&v2=8.082941&v3=0.007104&v4=0.009301&v5=10.980000&t=14.154255&h=68.577385&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024627s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000857s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465527,`v1`=0.010746,`v2`=8.082941,`v3`=0.007104,`v4`=0.009301,`v5`=10.98,`t`=14.154255,`h`=68.577385,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465528 WHERE `imei` = '868922055677740' [ RunTime:0.001700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015537s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465527 , 0.010746 , 8.082941 , 0.007104 , 0.009301 , 10.98 , 14.154255 , 68.577385 , '89860426102071188502' , '460044618415252' , -0 , 1639465528) [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2021-12-14T15:05:38+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024146s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000997s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000866s ] --------------------------------------------------------------- [ 2021-12-14T15:07:53+08:00 ] 218.204.252.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002382s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001396s ] --------------------------------------------------------------- [ 2021-12-14T15:07:54+08:00 ] 218.204.252.109 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465673&v1=0.010565&v2=7.974252&v3=0.007104&v4=0.009301&v5=10.980000&t=14.122080&h=68.791008&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002252s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029197s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001934s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465673,`v1`=0.010565,`v2`=7.974252,`v3`=0.007104,`v4`=0.009301,`v5`=10.98,`t`=14.12208,`h`=68.791008,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465674 WHERE `imei` = '868922055677740' [ RunTime:0.001711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.028146s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465673 , 0.010565 , 7.974252 , 0.007104 , 0.009301 , 10.98 , 14.12208 , 68.791008 , '89860426102071188502' , '460044618415252' , -0 , 1639465674) [ RunTime:0.000929s ] --------------------------------------------------------------- [ 2021-12-14T15:10:16+08:00 ] 39.144.1.31 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023745s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2021-12-14T15:10:17+08:00 ] 39.144.1.31 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465816&v1=0.021582&v2=8.073240&v3=0.007104&v4=0.010565&v5=10.980000&t=14.079180&h=69.050407&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002031s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023829s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000840s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465816,`v1`=0.021582,`v2`=8.07324,`v3`=0.007104,`v4`=0.010565,`v5`=10.98,`t`=14.07918,`h`=69.050407,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465817 WHERE `imei` = '868922055677740' [ RunTime:0.001074s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016948s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465816 , 0.021582 , 8.07324 , 0.007104 , 0.010565 , 10.98 , 14.07918 , 69.050407 , '89860426102071188502' , '460044618415252' , -0 , 1639465817) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2021-12-14T15:10:20+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026315s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000910s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000783s ] --------------------------------------------------------------- [ 2021-12-14T15:10:25+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023563s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016308s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000992s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001450s ] --------------------------------------------------------------- [ 2021-12-14T15:10:29+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=52 [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025414s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000924s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017258s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001019s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 510,10 [ RunTime:0.015632s ] --------------------------------------------------------------- [ 2021-12-14T15:12:38+08:00 ] 39.144.1.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024682s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000825s ] --------------------------------------------------------------- [ 2021-12-14T15:12:39+08:00 ] 39.144.1.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639465958&v1=0.012130&v2=8.072719&v3=0.007104&v4=0.009963&v5=10.980000&t=13.982654&h=68.806267&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002509s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022588s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000886s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639465958,`v1`=0.01213,`v2`=8.072719,`v3`=0.007104,`v4`=0.009963,`v5`=10.98,`t`=13.982654,`h`=68.806267,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639465959 WHERE `imei` = '868922055677740' [ RunTime:0.001075s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016944s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639465958 , 0.01213 , 8.072719 , 0.007104 , 0.009963 , 10.98 , 13.982654 , 68.806267 , '89860426102071188502' , '460044618415252' , -0 , 1639465959) [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2021-12-14T15:14:48+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025596s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001068s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000900s ] --------------------------------------------------------------- [ 2021-12-14T15:14:50+08:00 ] 123.234.86.34 GET /home/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] 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` = 22 LIMIT 1 [ RunTime:0.000932s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.017508s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2021-12-14T15:14:55+08:00 ] 123.234.86.34 POST /home/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002182s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022338s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `interval`=30,`gps`='120.082436,36.159645',`introduce`=' ',`update_time`=1639466095 WHERE `id` = 22 [ RunTime:0.001116s ] --------------------------------------------------------------- [ 2021-12-14T15:14:56+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001822s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021086s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000938s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2021-12-14T15:15:00+08:00 ] 39.144.3.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000813s ] --------------------------------------------------------------- [ 2021-12-14T15:15:01+08:00 ] 39.144.3.53 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639466100&v1=0.011227&v2=7.979572&v3=0.007104&v4=0.009722&v5=10.980000&t=13.875403&h=69.141960&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025484s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000937s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639466100,`v1`=0.011227,`v2`=7.979572,`v3`=0.007104,`v4`=0.009722,`v5`=10.98,`t`=13.875403,`h`=69.14196,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639466101 WHERE `imei` = '868922055677740' [ RunTime:0.001112s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016829s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639466100 , 0.011227 , 7.979572 , 0.007104 , 0.009722 , 10.98 , 13.875403 , 69.14196 , '89860426102071188502' , '460044618415252' , -0 , 1639466101) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2021-12-14T15:27:13+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000974s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026992s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001152s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001505s ] --------------------------------------------------------------- [ 2021-12-14T15:27:17+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022663s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000787s ] --------------------------------------------------------------- [ 2021-12-14T15:43:01+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003146s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025573s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001072s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001491s ] --------------------------------------------------------------- [ 2021-12-14T15:43:03+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002367s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000934s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000831s ] --------------------------------------------------------------- [ 2021-12-14T15:45:22+08:00 ] 117.132.191.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033434s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001078s ] --------------------------------------------------------------- [ 2021-12-14T15:45:23+08:00 ] 117.132.191.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639467922&v1=0.010324&v2=8.404419&v3=0.007224&v4=0.009482&v5=10.980000&t=15.494890&h=68.707085&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000827s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639467922,`v1`=0.010324,`v2`=8.404419,`v3`=0.007224,`v4`=0.009482,`v5`=10.98,`t`=15.49489,`h`=68.707085,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639467923 WHERE `imei` = '868922055677740' [ RunTime:0.001048s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015030s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639467922 , 0.010324 , 8.404419 , 0.007224 , 0.009482 , 10.98 , 15.49489 , 68.707085 , '89860426102071188502' , '460044618415252' , -0 , 1639467923) [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2021-12-14T15:53:12+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026570s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000862s ] --------------------------------------------------------------- [ 2021-12-14T16:15:45+08:00 ] 39.144.4.52 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003945s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.076224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000833s ] --------------------------------------------------------------- [ 2021-12-14T16:15:46+08:00 ] 39.144.4.52 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639469745&v1=0.011890&v2=9.854406&v3=0.007314&v4=0.010324&v5=10.800000&t=16.996401&h=67.318535&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002231s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033945s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000935s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639469745,`v1`=0.01189,`v2`=9.854406,`v3`=0.007314,`v4`=0.010324,`v5`=10.8,`t`=16.996401,`h`=67.318535,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639469746 WHERE `imei` = '868922055677740' [ RunTime:0.001090s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021283s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639469745 , 0.01189 , 9.854406 , 0.007314 , 0.010324 , 10.8 , 16.996401 , 67.318535 , '89860426102071188502' , '460044618415252' , -0 , 1639469746) [ RunTime:0.002096s ] --------------------------------------------------------------- [ 2021-12-14T16:24:29+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000856s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022370s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.003997s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005467s ] --------------------------------------------------------------- [ 2021-12-14T16:27:57+08:00 ] 39.144.2.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002730s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026309s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001308s ] --------------------------------------------------------------- [ 2021-12-14T16:28:06+08:00 ] 39.144.2.100 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=162701&v1=-01.278&v2=+00.005&v3=-01.146&v4=-00.755&v5=06.0&t=+08.4&h=71.7&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.298&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002097s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='162701',`v1`=-1.278,`v2`=0.005,`v3`=-1.146,`v4`=-0.755,`v5`=6,`t`=8.4,`h`=71.7,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.298,`update_time`=1639470486 WHERE `imei` = '868922055684076' [ RunTime:0.000891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015570s ] [ 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' , '211214' , '162701' , -1.278 , 0.005 , -1.146 , -0.755 , 6 , 8.4 , 71.7 , '460044618415249' , -0 , 0.155 , 1.298 , 1639470486 , 1639470486) [ RunTime:0.001307s ] --------------------------------------------------------------- [ 2021-12-14T16:46:07+08:00 ] 39.144.16.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.005289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037576s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001385s ] --------------------------------------------------------------- [ 2021-12-14T16:46:08+08:00 ] 39.144.16.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639471567&v1=0.011288&v2=12.296989&v3=0.007435&v4=0.018391&v5=10.980000&t=17.639906&h=67.043877&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023689s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000942s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639471567,`v1`=0.011288,`v2`=12.296989,`v3`=0.007435,`v4`=0.018391,`v5`=10.98,`t`=17.639906,`h`=67.043877,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639471568 WHERE `imei` = '868922055677740' [ RunTime:0.000925s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015795s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639471567 , 0.011288 , 12.296989 , 0.007435 , 0.018391 , 10.98 , 17.639906 , 67.043877 , '89860426102071188502' , '460044618415252' , -0 , 1639471568) [ RunTime:0.000585s ] --------------------------------------------------------------- [ 2021-12-14T16:56:44+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038952s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000969s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2021-12-14T17:16:29+08:00 ] 117.132.194.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003180s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037150s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000881s ] --------------------------------------------------------------- [ 2021-12-14T17:16:31+08:00 ] 117.132.194.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639473389&v1=0.008518&v2=11.491731&v3=0.007104&v4=0.017850&v5=10.980000&t=15.001536&h=71.941948&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ 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.022703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000916s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639473389,`v1`=0.008518,`v2`=11.491731,`v3`=0.007104,`v4`=0.01785,`v5`=10.98,`t`=15.001536,`h`=71.941948,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639473391 WHERE `imei` = '868922055677740' [ RunTime:0.001132s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017006s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639473389 , 0.008518 , 11.491731 , 0.007104 , 0.01785 , 10.98 , 15.001536 , 71.941948 , '89860426102071188502' , '460044618415252' , -0 , 1639473391) [ RunTime:0.000908s ] --------------------------------------------------------------- [ 2021-12-14T17:46:51+08:00 ] 39.144.3.96 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.043832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001467s ] --------------------------------------------------------------- [ 2021-12-14T17:46:53+08:00 ] 39.144.3.96 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639475211&v1=0.004906&v2=11.012122&v3=0.006983&v4=0.015923&v5=10.980000&t=13.328424&h=75.054749&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.003448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.040061s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.002093s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639475211,`v1`=0.004906,`v2`=11.012122,`v3`=0.006983,`v4`=0.015923,`v5`=10.98,`t`=13.328424,`h`=75.054749,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639475213 WHERE `imei` = '868922055677740' [ RunTime:0.002129s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.032649s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639475211 , 0.004906 , 11.012122 , 0.006983 , 0.015923 , 10.98 , 13.328424 , 75.054749 , '89860426102071188502' , '460044618415252' , -0 , 1639475213) [ RunTime:0.001279s ] --------------------------------------------------------------- [ 2021-12-14T18:27:58+08:00 ] 223.104.255.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030124s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000878s ] --------------------------------------------------------------- [ 2021-12-14T18:28:06+08:00 ] 223.104.255.125 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=182701&v1=-01.284&v2=+00.004&v3=-01.151&v4=-00.760&v5=06.0&t=+05.6&h=72.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.155&a2=01.303&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001324s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='182701',`v1`=-1.284,`v2`=0.004,`v3`=-1.151,`v4`=-0.76,`v5`=6,`t`=5.6,`h`=72.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.155,`a2`=1.303,`update_time`=1639477686 WHERE `imei` = '868922055684076' [ RunTime:0.001421s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.031809s ] [ 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' , '211214' , '182701' , -1.284 , 0.004 , -1.151 , -0.76 , 6 , 5.6 , 72.2 , '460044618415249' , -0 , 0.155 , 1.303 , 1639477686 , 1639477686) [ RunTime:0.002866s ] --------------------------------------------------------------- [ 2021-12-14T18:45:35+08:00 ] 223.80.204.39 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025143s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000828s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015332s ] [ 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.005665s ] --------------------------------------------------------------- [ 2021-12-14T19:10:47+08:00 ] 112.224.67.122 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.003204s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036241s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.001061s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018465s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001067s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005343s ] --------------------------------------------------------------- [ 2021-12-14T19:21:31+08:00 ] 39.144.10.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.004941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032838s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000962s ] --------------------------------------------------------------- [ 2021-12-14T19:21:32+08:00 ] 39.144.10.123 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639480891&v1=0.028565&v2=7.361755&v3=0.006863&v4=0.066672&v5=10.980000&t=11.279934&h=78.480347&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.003635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023574s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001771s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639480891,`v1`=0.028565,`v2`=7.361755,`v3`=0.006863,`v4`=0.066672,`v5`=10.98,`t`=11.279934,`h`=78.480347,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639480892 WHERE `imei` = '868922055677740' [ RunTime:0.002210s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.033106s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639480891 , 0.028565 , 7.361755 , 0.006863 , 0.066672 , 10.98 , 11.279934 , 78.480347 , '89860426102071188502' , '460044618415252' , -0 , 1639480892) [ RunTime:0.003412s ] --------------------------------------------------------------- [ 2021-12-14T19:21:49+08:00 ] 112.224.67.122 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026896s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016864s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001014s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.006639s ] --------------------------------------------------------------- [ 2021-12-14T19:37:26+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.033895s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.002050s ] --------------------------------------------------------------- [ 2021-12-14T19:37:27+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002522s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001306s ] --------------------------------------------------------------- [ 2021-12-14T19:37:29+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027453s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001053s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000926s ] --------------------------------------------------------------- [ 2021-12-14T19:37:36+08:00 ] 123.234.86.34 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.035069s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000952s ] --------------------------------------------------------------- [ 2021-12-14T19:37:43+08:00 ] 123.234.86.34 POST /home/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.023720s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='11111111',`user_email`='2343525',`introduce`=' ',`update_time`=1639481863 WHERE `id` = 1 [ RunTime:0.000998s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `password`='ba3c4352a7a9e9c182e1a1ca75b7e844',`update_time`=1639481863 WHERE `id` = 1 [ RunTime:0.000952s ] --------------------------------------------------------------- [ 2021-12-14T19:37:52+08:00 ] 123.234.86.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.043271s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2021-12-14T19:37:54+08:00 ] 123.234.86.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001055s ] --------------------------------------------------------------- [ 2021-12-14T19:37:56+08:00 ] 123.234.86.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010658s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028926s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001835s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001545s ] --------------------------------------------------------------- [ 2021-12-14T19:37:58+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002875s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030171s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001340s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016638s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.002264s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 0,10 [ RunTime:0.001365s ] --------------------------------------------------------------- [ 2021-12-14T19:38:00+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=53 [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021908s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001103s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016817s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001091s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 520,10 [ RunTime:0.015593s ] --------------------------------------------------------------- [ 2021-12-14T19:51:54+08:00 ] 117.132.191.109 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003317s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029180s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001053s ] --------------------------------------------------------------- [ 2021-12-14T19:51:55+08:00 ] 117.132.191.109 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639482714&v1=0.000331&v2=7.554099&v3=0.006863&v4=0.019355&v5=10.980000&t=11.215583&h=80.303772&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002158s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027521s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001033s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639482714,`v1`=0.000331,`v2`=7.554099,`v3`=0.006863,`v4`=0.019355,`v5`=10.98,`t`=11.215583,`h`=80.303772,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639482715 WHERE `imei` = '868922055677740' [ RunTime:0.001136s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018159s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639482714 , 0.000331 , 7.554099 , 0.006863 , 0.019355 , 10.98 , 11.215583 , 80.303772 , '89860426102071188502' , '460044618415252' , -0 , 1639482715) [ RunTime:0.000789s ] --------------------------------------------------------------- [ 2021-12-14T19:53:01+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=53 [ sql ] [ DB ] CONNECT:[ UseTime:0.002293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029165s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001008s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.020069s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001077s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 520,10 [ RunTime:0.018678s ] --------------------------------------------------------------- [ 2021-12-14T20:22:16+08:00 ] 221.178.127.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030818s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001141s ] --------------------------------------------------------------- [ 2021-12-14T20:22:17+08:00 ] 221.178.127.65 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639484536&v1=0.003100&v2=6.592899&v3=0.006833&v4=0.013936&v5=10.980000&t=11.033257&h=77.740295&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002216s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024601s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001023s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639484536,`v1`=0.0031,`v2`=6.592899,`v3`=0.006833,`v4`=0.013936,`v5`=10.98,`t`=11.033257,`h`=77.740295,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639484537 WHERE `imei` = '868922055677740' [ RunTime:0.001055s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016477s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639484536 , 0.0031 , 6.592899 , 0.006833 , 0.013936 , 10.98 , 11.033257 , 77.740295 , '89860426102071188502' , '460044618415252' , -0 , 1639484537) [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2021-12-14T20:22:56+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=53 [ sql ] [ DB ] CONNECT:[ UseTime:0.022747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031966s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000993s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024402s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.003144s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 520,10 [ RunTime:0.016460s ] --------------------------------------------------------------- [ 2021-12-14T20:24:21+08:00 ] 123.234.86.34 GET /home/show/read/id/22/imei/868922055677740.html?page=53 [ sql ] [ DB ] CONNECT:[ UseTime:0.002348s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032125s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001049s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022667s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001100s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` ASC LIMIT 520,10 [ RunTime:0.016153s ] --------------------------------------------------------------- [ 2021-12-14T20:27:48+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022014s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016092s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001057s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005422s ] --------------------------------------------------------------- [ 2021-12-14T20:27:57+08:00 ] 117.132.194.246 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.023720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000774s ] --------------------------------------------------------------- [ 2021-12-14T20:28:06+08:00 ] 117.132.194.246 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=202701&v1=-01.280&v2=+00.004&v3=-01.148&v4=-00.757&v5=06.0&t=+04.9&h=72.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.157&a2=01.301&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002219s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027345s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001142s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='202701',`v1`=-1.28,`v2`=0.004,`v3`=-1.148,`v4`=-0.757,`v5`=6,`t`=4.9,`h`=72.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.157,`a2`=1.301,`update_time`=1639484886 WHERE `imei` = '868922055684076' [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026972s ] [ 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' , '211214' , '202701' , -1.28 , 0.004 , -1.148 , -0.757 , 6 , 4.9 , 72.1 , '460044618415249' , -0 , 0.157 , 1.301 , 1639484886 , 1639484886) [ RunTime:0.000931s ] --------------------------------------------------------------- [ 2021-12-14T20:52:39+08:00 ] 39.144.18.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.005214s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.044193s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001514s ] --------------------------------------------------------------- [ 2021-12-14T20:53:43+08:00 ] 117.132.192.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002382s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025265s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000872s ] --------------------------------------------------------------- [ 2021-12-14T20:53:45+08:00 ] 117.132.192.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639486423&v1=0.041749&v2=29.251650&v3=0.006863&v4=0.008639&v5=10.980000&t=11.601686&h=76.351746&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024950s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001130s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639486423,`v1`=0.041749,`v2`=29.25165,`v3`=0.006863,`v4`=0.008639,`v5`=10.98,`t`=11.601686,`h`=76.351746,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639486424 WHERE `imei` = '868922055677740' [ RunTime:0.001435s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022329s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639486423 , 0.041749 , 29.25165 , 0.006863 , 0.008639 , 10.98 , 11.601686 , 76.351746 , '89860426102071188502' , '460044618415252' , -0 , 1639486425) [ RunTime:0.002278s ] --------------------------------------------------------------- [ 2021-12-14T20:53:46+08:00 ] 117.132.192.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639486359&v1=0.000000&v2=5.560000&v3=0.000000&v4=0.010000&v5=10.980000&t=10.990000&h=77.739998&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end= [ 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.031757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001744s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639486359,`v1`=0,`v2`=5.56,`v3`=0,`v4`=0.01,`v5`=10.98,`t`=10.99,`h`=77.739998,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639486426 WHERE `imei` = '868922055677740' [ RunTime:0.001418s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024488s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639486359 , 0 , 5.56 , 0 , 0.01 , 10.98 , 10.99 , 77.739998 , '89860426102071188502' , '460044618415252' , -0 , 1639486426) [ RunTime:0.000913s ] --------------------------------------------------------------- [ 2021-12-14T21:04:57+08:00 ] 39.144.4.203 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681221 [ sql ] [ DB ] CONNECT:[ UseTime:0.003417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2021-12-14T21:05:06+08:00 ] 39.144.4.203 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681221&date=211214&time=210401&v1=-01.204&v2=+01.084&v3=-01.332&v4=+00.028&v5=06.0&t=+05.6&h=86.4&rssi=+221&imsi=460044618415257&v6=-00.000&a1=00.041&a2=15.750&a3=00.297&end=$ [ 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.021096s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681221' LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681221',`date`='211214',`time`='210401',`v1`=-1.204,`v2`=1.084,`v3`=-1.332,`v4`=0.028,`v5`=6,`t`=5.6,`h`=86.4,`rssi`=221,`imsi`='460044618415257',`v6`=-0,`a1`=0.041,`a2`=15.75,`update_time`=1639487106 WHERE `imei` = '868922055681221' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023364s ] [ 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' , '211214' , '210401' , -1.204 , 1.084 , -1.332 , 0.028 , 6 , 5.6 , 86.4 , '460044618415257' , -0 , 0.041 , 15.75 , 1639487106 , 1639487106) [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2021-12-14T21:24:07+08:00 ] 39.144.1.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031203s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001004s ] --------------------------------------------------------------- [ 2021-12-14T21:24:08+08:00 ] 39.144.1.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639488247&v1=0.001595&v2=14.051973&v3=0.006773&v4=0.015261&v5=11.340000&t=10.893830&h=78.884705&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.003677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038091s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001841s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639488247,`v1`=0.001595,`v2`=14.051973,`v3`=0.006773,`v4`=0.015261,`v5`=11.34,`t`=10.89383,`h`=78.884705,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639488248 WHERE `imei` = '868922055677740' [ RunTime:0.002007s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.034508s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639488247 , 0.001595 , 14.051973 , 0.006773 , 0.015261 , 11.34 , 10.89383 , 78.884705 , '89860426102071188502' , '460044618415252' , -0 , 1639488248) [ RunTime:0.001449s ] --------------------------------------------------------------- [ 2021-12-14T21:27:11+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018205s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001878s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005534s ] --------------------------------------------------------------- [ 2021-12-14T21:28:10+08:00 ] 123.234.86.34 GET /home/show/read/id/26/imei/868922055684076.html?page=16 [ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025766s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000777s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015925s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001013s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` ASC LIMIT 150,10 [ RunTime:0.005180s ] --------------------------------------------------------------- [ 2021-12-14T21:54:30+08:00 ] 39.144.6.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001069s ] --------------------------------------------------------------- [ 2021-12-14T21:54:31+08:00 ] 39.144.6.66 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1639490070&v1=0.000331&v2=14.575392&v3=0.006863&v4=0.016405&v5=11.160000&t=10.808030&h=80.021484&rssi=99&ccid=89860426102071188502&imsi=460044618415252&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002158s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022688s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000857s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1639490070,`v1`=0.000331,`v2`=14.575392,`v3`=0.006863,`v4`=0.016405,`v5`=11.16,`t`=10.80803,`h`=80.021484,`rssi`=99,`ccid`='89860426102071188502',`imsi`='460044618415252',`v6`=-0,`update_time`=1639490071 WHERE `imei` = '868922055677740' [ RunTime:0.001087s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015553s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1639490070 , 0.000331 , 14.575392 , 0.006863 , 0.016405 , 11.16 , 10.80803 , 80.021484 , '89860426102071188502' , '460044618415252' , -0 , 1639490071) [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2021-12-14T22:27:58+08:00 ] 39.144.14.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.041262s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001042s ] --------------------------------------------------------------- [ 2021-12-14T22:28:06+08:00 ] 39.144.14.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=211214&time=222701&v1=-01.286&v2=+00.005&v3=-01.153&v4=-00.763&v5=06.0&t=+04.7&h=72.0&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.156&a2=01.305&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002284s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025028s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000848s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='211214',`time`='222701',`v1`=-1.286,`v2`=0.005,`v3`=-1.153,`v4`=-0.763,`v5`=6,`t`=4.7,`h`=72,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=1.305,`update_time`=1639492086 WHERE `imei` = '868922055684076' [ RunTime:0.000772s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018060s ] [ 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' , '211214' , '222701' , -1.286 , 0.005 , -1.153 , -0.763 , 6 , 4.7 , 72 , '460044618415249' , -0 , 0.156 , 1.305 , 1639492086 , 1639492086) [ RunTime:0.000755s ]