--------------------------------------------------------------- [ 2024-01-25T02:00:53+08:00 ] 223.104.255.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.004652s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.019999s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001867s ] --------------------------------------------------------------- [ 2024-01-25T02:01:03+08:00 ] 223.104.255.215 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240125&time=020001&v1=+00.015&v2=+00.001&v3=+00.048&v4=+00.007&v5=05.4&t=-06.0&h=70.7&rssi=+221&ccid=4600485905031430000099m9990000000023000000g0070,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011594s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240125',`time`='020001',`v1`=0.015,`v2`=0.001,`v3`=0.048,`v4`=0.007,`v5`=5.4,`t`=-6,`h`=70.7,`rssi`=221,`ccid`='4600485905031430000099m9990000000023000000g0070,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1706119263 WHERE `imei` = '868922055644013' [ RunTime:0.000771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024698s ] [ 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' , '240125' , '020001' , 0.015 , 0.001 , 0.048 , 0.007 , 5.4 , -6 , 70.7 , 221 , '4600485905031430000099m9990000000023000000g0070,N,00E000=-00.000' , 0 , 0 , 1706119263 , 1706119263) [ RunTime:0.002355s ] --------------------------------------------------------------- [ 2024-01-25T12:45:56+08:00 ] 223.104.194.183 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002240s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013052s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001235s ] --------------------------------------------------------------- [ 2024-01-25T12:45:57+08:00 ] 223.104.194.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000732s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012194s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001465s ] --------------------------------------------------------------- [ 2024-01-25T12:46:07+08:00 ] 223.104.194.183 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012599s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000624s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2024-01-25T12:46:13+08:00 ] 223.104.194.183 GET /home/show/index.html?keyword= [ 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.009677s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000614s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2024-01-25T12:46:25+08:00 ] 223.104.194.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001617s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011506s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001349s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001247s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012202s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.066779s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003449s ] --------------------------------------------------------------- [ 2024-01-25T12:47:01+08:00 ] 223.104.194.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002230s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011767s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011900s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001483s ] --------------------------------------------------------------- [ 2024-01-25T12:47:42+08:00 ] 223.104.194.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000776s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012020s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001440s ] --------------------------------------------------------------- [ 2024-01-25T12:47:45+08:00 ] 223.104.194.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002179s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010496s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001390s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001256s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011225s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003066s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003340s ] --------------------------------------------------------------- [ 2024-01-25T12:47:48+08:00 ] 223.104.194.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001634s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011480s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000553s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001437s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001259s ] --------------------------------------------------------------- [ 2024-01-25T12:48:50+08:00 ] 223.104.194.183 GET /home/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001794s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010761s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001029s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010822s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.003753s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003658s ] --------------------------------------------------------------- [ 2024-01-25T12:56:10+08:00 ] 223.104.194.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002269s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011402s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001393s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001255s ] --------------------------------------------------------------- [ 2024-01-25T12:56:10+08:00 ] 223.104.194.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001984s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010137s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000490s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001331s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001270s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011028s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.002997s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003323s ] --------------------------------------------------------------- [ 2024-01-25T12:56:11+08:00 ] 223.104.194.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001699s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011489s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001996s ] --------------------------------------------------------------- [ 2024-01-25T12:56:12+08:00 ] 223.104.194.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013953s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001422s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001295s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.023533s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003085s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003005s ] --------------------------------------------------------------- [ 2024-01-25T12:56:12+08:00 ] 223.104.194.183 GET /home/show/index.html?keyword= [ sql ] [ DB ] CONNECT:[ UseTime:0.001945s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011050s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000654s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2024-01-25T12:56:13+08:00 ] 223.104.194.183 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010673s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000556s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000653s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2024-01-25T12:56:14+08:00 ] 223.104.194.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010611s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010902s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001529s ] --------------------------------------------------------------- [ 2024-01-25T15:24:15+08:00 ] 218.56.88.206 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012034s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000881s ] --------------------------------------------------------------- [ 2024-01-25T15:24:19+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001371s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001181s ]