--------------------------------------------------------------- [ 2023-03-13T02:03:55+08:00 ] 39.144.13.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010414s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-03-13T02:03:56+08:00 ] 117.132.196.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010035s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000644s ] --------------------------------------------------------------- [ 2023-03-13T02:04:04+08:00 ] 39.144.13.250 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230313&time=020301&v1=-01.304&v2=+00.015&v3=-00.989&v4=-00.021&v5=06.0&t=+00.9&h=62.2&rssi=+228&ccid=4600485905031420000099m9990000000312000001g3160,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008103s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230313',`time`='020301',`v1`=-1.304,`v2`=0.015,`v3`=-0.989,`v4`=-0.021,`v5`=6,`t`=0.9,`h`=62.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000312000001g3160,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678644244 WHERE `imei` = '868922055643643' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011650s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230313' , '020301' , -1.304 , 0.015 , -0.989 , -0.021 , 6 , 0.9 , 62.2 , 228 , '4600485905031420000099m9990000000312000001g3160,N,00E000=-00.000' , 0 , 0 , 1678644244 , 1678644244) [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2023-03-13T02:04:04+08:00 ] 117.132.196.231 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230313&time=020301&v1=-00.246&v2=+00.001&v3=+00.013&v4=-00.017&v5=05.7&t=+02.3&h=65.0&rssi=+225&ccid=4600485905031430000099m9990000000035000000g2850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002282s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010870s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230313',`time`='020301',`v1`=-0.246,`v2`=0.001,`v3`=0.013,`v4`=-0.017,`v5`=5.7,`t`=2.3,`h`=65,`rssi`=225,`ccid`='4600485905031430000099m9990000000035000000g2850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678644244 WHERE `imei` = '868922055644013' [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011120s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '230313' , '020301' , -0.246 , 0.001 , 0.013 , -0.017 , 5.7 , 2.3 , 65 , 225 , '4600485905031430000099m9990000000035000000g2850,N,00E000=-00.000' , 0 , 0 , 1678644244 , 1678644244) [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2023-03-13T06:05:51+08:00 ] 111.55.137.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-03-13T06:06:00+08:00 ] 111.55.137.244 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230313&time=060501&v1=-01.225&v2=+00.018&v3=-01.018&v4=-00.594&v5=05.7&t=+02.5&h=81.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.237&a2=01.256&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011267s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230313',`time`='060501',`v1`=-1.225,`v2`=0.018,`v3`=-1.018,`v4`=-0.594,`v5`=5.7,`t`=2.5,`h`=81.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.237,`a2`=1.256,`update_time`=1678658760 WHERE `imei` = '868922055684076' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011373s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '230313' , '060501' , -1.225 , 0.018 , -1.018 , -0.594 , 5.7 , 2.5 , 81.1 , 228 , '460044618415249' , -0 , 0.237 , 1.256 , 1678658760 , 1678658760) [ RunTime:0.001306s ] --------------------------------------------------------------- [ 2023-03-13T09:24:41+08:00 ] 223.80.202.168 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.015023s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001139s ] --------------------------------------------------------------- [ 2023-03-13T09:24:42+08:00 ] 223.80.202.168 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2023-03-13T09:24:52+08:00 ] 223.80.202.168 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011968s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000510s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000726s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012773s ] [ 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.000548s ] [ 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.000597s ] --------------------------------------------------------------- [ 2023-03-13T09:25:05+08:00 ] 223.80.202.168 GET /home/data/index.html?keyword=868922055684076&start_date=2023-01-01&end_date=2023-03-13 [ sql ] [ DB ] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011126s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000555s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000966s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009644s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1672502400 AND `update_time` <= 1678636800 ) LIMIT 1 [ RunTime:0.024895s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1672502400 AND `update_time` <= 1678636800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.013463s ] --------------------------------------------------------------- [ 2023-03-13T09:51:24+08:00 ] 223.80.202.168 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002270s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011051s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-03-13T09:51:25+08:00 ] 223.80.202.168 GET /home/map/index.html [ 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.010517s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000930s ] --------------------------------------------------------------- [ 2023-03-13T09:51:27+08:00 ] 223.80.202.168 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015245s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011899s ] [ 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.000417s ] [ 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.000469s ] --------------------------------------------------------------- [ 2023-03-13T09:51:46+08:00 ] 223.80.202.168 GET /home/data/index.html?keyword=868922055684076&start_date=2022-06-01&end_date=2023-03-13 [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010969s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000434s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010923s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1654012800 AND `update_time` <= 1678636800 ) LIMIT 1 [ RunTime:0.009109s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1654012800 AND `update_time` <= 1678636800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.011703s ] --------------------------------------------------------------- [ 2023-03-13T10:17:49+08:00 ] 119.164.109.106 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009734s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-03-13T10:17:51+08:00 ] 119.164.109.106 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010011s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2023-03-13T10:17:56+08:00 ] 119.164.109.106 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002213s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011318s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2023-03-13T10:17:59+08:00 ] 119.164.109.106 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-03-13T10:18:01+08:00 ] 119.164.109.106 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008728s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000675s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011519s ] [ 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.000394s ] [ 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.000438s ] --------------------------------------------------------------- [ 2023-03-13T10:18:08+08:00 ] 119.164.109.106 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009708s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-03-13T10:19:05+08:00 ] 119.164.109.106 POST /home/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010274s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='',`user_email`='',`introduce`=' ',`update_time`=1678673945 WHERE `id` = 14 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-03-13T10:19:13+08:00 ] 119.164.109.106 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009310s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-03-13T10:19:51+08:00 ] 119.164.109.106 POST /home/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001578s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010939s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='',`user_email`='',`introduce`=' ',`update_time`=1678673991 WHERE `id` = 14 [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2023-03-13T10:19:56+08:00 ] 119.164.109.106 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002101s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009525s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-03-13T10:20:22+08:00 ] 119.164.109.106 POST /home/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009680s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='',`user_email`='',`introduce`=' ',`update_time`=1678674022 WHERE `id` = 14 [ RunTime:0.001151s ] --------------------------------------------------------------- [ 2023-03-13T10:20:28+08:00 ] 119.164.109.106 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002112s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009653s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-03-13T10:20:52+08:00 ] 119.164.109.106 POST /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010915s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-03-13T10:20:59+08:00 ] 119.164.109.106 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.009113s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='',`user_email`='',`introduce`=' ',`update_time`=1678674059 WHERE `id` = 14 [ RunTime:0.000874s ] --------------------------------------------------------------- [ 2023-03-13T10:21:03+08:00 ] 119.164.109.106 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003259s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010778s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000591s ] --------------------------------------------------------------- [ 2023-03-13T10:21:51+08:00 ] 119.164.109.106 POST /home/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010400s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE ( `id` = 14 ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `user_phone`='',`user_email`='',`introduce`=' ',`user_logo`='\\uploads\\20230313\\a089dc8f761d3cea98e23af48ab26cdb.png',`update_time`=1678674111 WHERE `id` = 14 [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2023-03-13T10:22:04+08:00 ] 119.164.109.106 GET /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010692s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2023-03-13T10:22:54+08:00 ] 119.164.109.106 POST /home/user/edit.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008561s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-03-13T14:03:54+08:00 ] 39.144.3.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002437s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013186s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000843s ] --------------------------------------------------------------- [ 2023-03-13T14:03:55+08:00 ] 117.132.195.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001631s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009532s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2023-03-13T14:04:03+08:00 ] 39.144.3.104 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230313&time=140301&v1=-00.262&v2=+00.002&v3=+00.020&v4=-00.015&v5=06.0&t=+21.6&h=64.5&rssi=+224&ccid=4600485905031430000099m9990000000039000000g3020,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001937s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010563s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230313',`time`='140301',`v1`=-0.262,`v2`=0.002,`v3`=0.02,`v4`=-0.015,`v5`=6,`t`=21.6,`h`=64.5,`rssi`=224,`ccid`='4600485905031430000099m9990000000039000000g3020,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678687443 WHERE `imei` = '868922055644013' [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011320s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '230313' , '140301' , -0.262 , 0.002 , 0.02 , -0.015 , 6 , 21.6 , 64.5 , 224 , '4600485905031430000099m9990000000039000000g3020,N,00E000=-00.000' , 0 , 0 , 1678687443 , 1678687443) [ RunTime:0.001067s ] --------------------------------------------------------------- [ 2023-03-13T14:04:04+08:00 ] 117.132.195.73 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230313&time=140301&v1=-01.301&v2=+00.047&v3=-00.979&v4=-00.020&v5=05.7&t=+17.1&h=60.3&rssi=+228&ccid=4600485905031420000099m9990000000313000001g3120,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010049s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230313',`time`='140301',`v1`=-1.301,`v2`=0.047,`v3`=-0.979,`v4`=-0.02,`v5`=5.7,`t`=17.1,`h`=60.3,`rssi`=228,`ccid`='4600485905031420000099m9990000000313000001g3120,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678687444 WHERE `imei` = '868922055643643' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010972s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230313' , '140301' , -1.301 , 0.047 , -0.979 , -0.02 , 5.7 , 17.1 , 60.3 , 228 , '4600485905031420000099m9990000000313000001g3120,N,00E000=-00.000' , 0 , 0 , 1678687444 , 1678687444) [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-03-13T15:34:24+08:00 ] 119.164.105.154 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002303s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011829s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-03-13T15:34:25+08:00 ] 119.164.105.154 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001775s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011333s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000806s ] --------------------------------------------------------------- [ 2023-03-13T15:34:50+08:00 ] 119.164.105.154 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009897s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000699s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000574s ] --------------------------------------------------------------- [ 2023-03-13T15:34:56+08:00 ] 119.164.105.154 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002037s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008822s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2023-03-13T15:34:59+08:00 ] 119.164.105.154 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001902s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010074s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012058s ] [ 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.000426s ] [ 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.000459s ] --------------------------------------------------------------- [ 2023-03-13T15:35:56+08:00 ] 119.164.105.154 GET /home/data/index.html?keyword=868922055644013&start_date=0201-02-01&end_date=2023-03-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.002176s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011028s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000516s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008840s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 0 AND `update_time` <= 1678550400 ) LIMIT 1 [ RunTime:0.003925s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 0 AND `update_time` <= 1678550400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.008440s ]