--------------------------------------------------------------- [ 2023-01-30T02:03:55+08:00 ] 111.55.139.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.017450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014087s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.003231s ] --------------------------------------------------------------- [ 2023-01-30T02:03:55+08:00 ] 39.144.5.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002753s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010965s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-01-30T02:04:04+08:00 ] 111.55.139.210 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230130&time=020301&v1=-00.258&v2=+00.001&v3=+00.011&v4=-00.016&v5=05.2&t=-04.4&h=64.8&rssi=+226&ccid=4600485905031430000099m9990000000035000000g3140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010355s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230130',`time`='020301',`v1`=-0.258,`v2`=0.001,`v3`=0.011,`v4`=-0.016,`v5`=5.2,`t`=-4.4,`h`=64.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000035000000g3140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675015444 WHERE `imei` = '868922055644013' [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015131s ] [ 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' , '230130' , '020301' , -0.258 , 0.001 , 0.011 , -0.016 , 5.2 , -4.4 , 64.8 , 226 , '4600485905031430000099m9990000000035000000g3140,N,00E000=-00.000' , 0 , 0 , 1675015444 , 1675015444) [ RunTime:0.001505s ] --------------------------------------------------------------- [ 2023-01-30T02:04:04+08:00 ] 39.144.5.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230130&time=020301&v1=-01.252&v2=+00.024&v3=-00.928&v4=-00.034&v5=06.0&t=-06.0&h=61.8&rssi=+229&ccid=4600485905031420000099m9990000000299000001g2660,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010170s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230130',`time`='020301',`v1`=-1.252,`v2`=0.024,`v3`=-0.928,`v4`=-0.034,`v5`=6,`t`=-6,`h`=61.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000299000001g2660,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675015444 WHERE `imei` = '868922055643643' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009896s ] [ 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' , '230130' , '020301' , -1.252 , 0.024 , -0.928 , -0.034 , 6 , -6 , 61.8 , 229 , '4600485905031420000099m9990000000299000001g2660,N,00E000=-00.000' , 0 , 0 , 1675015444 , 1675015444) [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2023-01-30T06:13:52+08:00 ] 39.144.13.95 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002208s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-01-30T06:14:00+08:00 ] 39.144.13.95 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230130&time=061301&v1=-01.260&v2=+00.016&v3=-01.088&v4=-00.671&v5=05.6&t=-03.4&h=80.6&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.205&a2=01.276&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001450s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230130',`time`='061301',`v1`=-1.26,`v2`=0.016,`v3`=-1.088,`v4`=-0.671,`v5`=5.6,`t`=-3.4,`h`=80.6,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.205,`a2`=1.276,`update_time`=1675030440 WHERE `imei` = '868922055684076' [ RunTime:0.000871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015713s ] [ 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' , '230130' , '061301' , -1.26 , 0.016 , -1.088 , -0.671 , 5.6 , -3.4 , 80.6 , 227 , '460044618415249' , -0 , 0.205 , 1.276 , 1675030440 , 1675030440) [ RunTime:0.000826s ] --------------------------------------------------------------- [ 2023-01-30T09:11:10+08:00 ] 223.80.200.34 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013789s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001341s ] --------------------------------------------------------------- [ 2023-01-30T09:11:11+08:00 ] 223.80.200.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002117s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011402s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2023-01-30T09:11:28+08:00 ] 223.80.200.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] 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` = 'biandianzhan' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2023-01-30T09:11:34+08:00 ] 223.80.200.34 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011453s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011431s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.008489s ] --------------------------------------------------------------- [ 2023-01-30T09:12:17+08:00 ] 223.80.200.34 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001449s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012915s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001102s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011613s ] [ 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.000606s ] [ 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.000482s ] --------------------------------------------------------------- [ 2023-01-30T09:12:29+08:00 ] 223.80.200.34 GET /home/data/index.html?keyword=868922055644013&start_date=2023-01-01&end_date=2023-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011197s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000493s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000556s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009130s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1672502400 AND `update_time` <= 1675008000 ) LIMIT 1 [ RunTime:0.003362s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1672502400 AND `update_time` <= 1675008000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004191s ] --------------------------------------------------------------- [ 2023-01-30T09:13:01+08:00 ] 223.80.200.34 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-01&end_date=2023-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.002117s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010674s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012411s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1664553600 AND `update_time` <= 1675008000 ) LIMIT 1 [ RunTime:0.003267s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1664553600 AND `update_time` <= 1675008000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.007452s ] --------------------------------------------------------------- [ 2023-01-30T09:13:12+08:00 ] 223.80.200.34 GET /home/data/index.html?keyword=868922055644013&start_date=2022-12-01&end_date=2023-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.002278s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011943s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1669824000 AND `update_time` <= 1675008000 ) LIMIT 1 [ RunTime:0.003218s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1669824000 AND `update_time` <= 1675008000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004293s ] --------------------------------------------------------------- [ 2023-01-30T09:15:12+08:00 ] 223.80.200.34 GET /home/data/index.html?keyword=868922055643643&start_date=2022-12-01&end_date=2023-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.002618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010210s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011615s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1669824000 AND `update_time` <= 1675008000 ) LIMIT 1 [ RunTime:0.002676s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1669824000 AND `update_time` <= 1675008000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003610s ] --------------------------------------------------------------- [ 2023-01-30T09:17:10+08:00 ] 223.80.200.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002775s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010626s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000566s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000962s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2023-01-30T09:17:31+08:00 ] 223.80.200.34 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009969s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003295s ] --------------------------------------------------------------- [ 2023-01-30T09:17:35+08:00 ] 223.80.200.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002050s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011184s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001147s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-01-30T09:17:41+08:00 ] 223.80.200.34 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010399s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011326s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002766s ] --------------------------------------------------------------- [ 2023-01-30T09:17:55+08:00 ] 223.80.200.34 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009733s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000689s ] [ 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.011611s ] [ 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.000352s ] [ 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.000445s ] --------------------------------------------------------------- [ 2023-01-30T09:17:58+08:00 ] 223.80.200.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011897s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000786s ] --------------------------------------------------------------- [ 2023-01-30T09:20:41+08:00 ] 223.80.200.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011223s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000953s ] --------------------------------------------------------------- [ 2023-01-30T09:20:43+08:00 ] 223.80.200.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001823s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012387s ] [ 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.000740s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-01-30T09:20:46+08:00 ] 223.80.200.34 GET /home/data/index.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_show` [ RunTime:0.011743s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000704s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010892s ] [ 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.000443s ] [ 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.000407s ] --------------------------------------------------------------- [ 2023-01-30T09:21:45+08:00 ] 223.80.200.34 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000709s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000932s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011026s ] [ 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.000440s ] [ 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.000458s ] --------------------------------------------------------------- [ 2023-01-30T09:21:47+08:00 ] 223.80.200.34 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002578s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010494s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000796s ] --------------------------------------------------------------- [ 2023-01-30T09:21:48+08:00 ] 223.80.200.34 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002109s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010156s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2023-01-30T09:21:51+08:00 ] 223.80.200.34 GET /home/show/edit/id/33.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002040s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009591s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012364s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000483s ] --------------------------------------------------------------- [ 2023-01-30T14:03:55+08:00 ] 221.178.126.200 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010567s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2023-01-30T14:03:55+08:00 ] 117.132.195.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009992s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-01-30T14:04:04+08:00 ] 221.178.126.200 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230130&time=140301&v1=-00.244&v2=+00.001&v3=+00.019&v4=-00.015&v5=05.9&t=+11.9&h=64.9&rssi=+228&ccid=4600485905031430000099m9990000000037000000g2970,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.014281s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001072s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230130',`time`='140301',`v1`=-0.244,`v2`=0.001,`v3`=0.019,`v4`=-0.015,`v5`=5.9,`t`=11.9,`h`=64.9,`rssi`=228,`ccid`='4600485905031430000099m9990000000037000000g2970,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675058644 WHERE `imei` = '868922055644013' [ RunTime:0.000924s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013583s ] [ 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' , '230130' , '140301' , -0.244 , 0.001 , 0.019 , -0.015 , 5.9 , 11.9 , 64.9 , 228 , '4600485905031430000099m9990000000037000000g2970,N,00E000=-00.000' , 0 , 0 , 1675058644 , 1675058644) [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-01-30T14:04:04+08:00 ] 117.132.195.210 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230130&time=140301&v1=-01.250&v2=+00.055&v3=-00.923&v4=-00.033&v5=05.6&t=+08.3&h=60.5&rssi=+231&ccid=4600485905031420000099m9990000000299000001g2640,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010091s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230130',`time`='140301',`v1`=-1.25,`v2`=0.055,`v3`=-0.923,`v4`=-0.033,`v5`=5.6,`t`=8.3,`h`=60.5,`rssi`=231,`ccid`='4600485905031420000099m9990000000299000001g2640,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1675058644 WHERE `imei` = '868922055643643' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011887s ] [ 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' , '230130' , '140301' , -1.25 , 0.055 , -0.923 , -0.033 , 5.6 , 8.3 , 60.5 , 231 , '4600485905031420000099m9990000000299000001g2640,N,00E000=-00.000' , 0 , 0 , 1675058644 , 1675058644) [ RunTime:0.000561s ]