--------------------------------------------------------------- [ 2023-04-18T02:03:54+08:00 ] 39.144.7.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.004403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012170s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001383s ] --------------------------------------------------------------- [ 2023-04-18T02:03:55+08:00 ] 117.132.192.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2023-04-18T02:04:03+08:00 ] 39.144.7.1 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230418&time=020301&v1=-01.334&v2=+00.015&v3=-00.998&v4=-00.025&v5=05.7&t=+13.5&h=60.9&rssi=+228&ccid=4600485905031420000099m9990000000338000001g3440,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230418',`time`='020301',`v1`=-1.334,`v2`=0.015,`v3`=-0.998,`v4`=-0.025,`v5`=5.7,`t`=13.5,`h`=60.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000338000001g3440,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681754643 WHERE `imei` = '868922055643643' [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013321s ] [ 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' , '230418' , '020301' , -1.334 , 0.015 , -0.998 , -0.025 , 5.7 , 13.5 , 60.9 , 228 , '4600485905031420000099m9990000000338000001g3440,N,00E000=-00.000' , 0 , 0 , 1681754643 , 1681754643) [ RunTime:0.001307s ] --------------------------------------------------------------- [ 2023-04-18T02:04:03+08:00 ] 117.132.192.219 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230418&time=020301&v1=-00.236&v2=+00.001&v3=-00.096&v4=-00.013&v5=05.9&t=+13.8&h=63.8&rssi=+225&ccid=4600485905031430000099m9990000000004000000g2450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230418',`time`='020301',`v1`=-0.236,`v2`=0.001,`v3`=-0.096,`v4`=-0.013,`v5`=5.9,`t`=13.8,`h`=63.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000004000000g2450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681754643 WHERE `imei` = '868922055644013' [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009398s ] [ 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' , '230418' , '020301' , -0.236 , 0.001 , -0.096 , -0.013 , 5.9 , 13.8 , 63.8 , 225 , '4600485905031430000099m9990000000004000000g2450,N,00E000=-00.000' , 0 , 0 , 1681754643 , 1681754643) [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-04-18T10:04:50+08:00 ] 218.204.252.168 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003234s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012677s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2023-04-18T10:04:58+08:00 ] 218.204.252.168 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230418&time=100401&v1=-01.277&v2=+00.049&v3=-01.162&v4=-00.400&v5=05.9&t=+21.2&h=78.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.131&a2=01.291&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230418',`time`='100401',`v1`=-1.277,`v2`=0.049,`v3`=-1.162,`v4`=-0.4,`v5`=5.9,`t`=21.2,`h`=78.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.131,`a2`=1.291,`update_time`=1681783498 WHERE `imei` = '868922055684076' [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011866s ] [ 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' , '230418' , '100401' , -1.277 , 0.049 , -1.162 , -0.4 , 5.9 , 21.2 , 78.9 , 228 , '460044618415249' , -0 , 0.131 , 1.291 , 1681783498 , 1681783498) [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2023-04-18T14:03:55+08:00 ] 39.144.16.183 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012163s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-04-18T14:03:55+08:00 ] 111.55.137.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003333s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013824s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000914s ] --------------------------------------------------------------- [ 2023-04-18T14:04:03+08:00 ] 39.144.16.183 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230418&time=140301&v1=-00.223&v2=+00.001&v3=+00.019&v4=-00.013&v5=06.0&t=+29.6&h=61.1&rssi=+227&ccid=4600485905031430000099m9990000000044000000g2450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010736s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230418',`time`='140301',`v1`=-0.223,`v2`=0.001,`v3`=0.019,`v4`=-0.013,`v5`=6,`t`=29.6,`h`=61.1,`rssi`=227,`ccid`='4600485905031430000099m9990000000044000000g2450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681797843 WHERE `imei` = '868922055644013' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011613s ] [ 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' , '230418' , '140301' , -0.223 , 0.001 , 0.019 , -0.013 , 6 , 29.6 , 61.1 , 227 , '4600485905031430000099m9990000000044000000g2450,N,00E000=-00.000' , 0 , 0 , 1681797843 , 1681797843) [ RunTime:0.003407s ] --------------------------------------------------------------- [ 2023-04-18T14:04:04+08:00 ] 111.55.137.46 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230418&time=140301&v1=-01.333&v2=+00.034&v3=-01.002&v4=-00.025&v5=05.9&t=+26.3&h=58.2&rssi=+228&ccid=4600485905031420000099m9990000000331000001g3420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001642s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009980s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230418',`time`='140301',`v1`=-1.333,`v2`=0.034,`v3`=-1.002,`v4`=-0.025,`v5`=5.9,`t`=26.3,`h`=58.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000331000001g3420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681797844 WHERE `imei` = '868922055643643' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010666s ] [ 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' , '230418' , '140301' , -1.333 , 0.034 , -1.002 , -0.025 , 5.9 , 26.3 , 58.2 , 228 , '4600485905031420000099m9990000000331000001g3420,N,00E000=-00.000' , 0 , 0 , 1681797844 , 1681797844) [ RunTime:0.001124s ] --------------------------------------------------------------- [ 2023-04-18T14:09:41+08:00 ] 223.81.89.208 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012808s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001233s ] --------------------------------------------------------------- [ 2023-04-18T14:09:42+08:00 ] 223.81.89.208 GET /home/map/index.html [ 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.011292s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001774s ] --------------------------------------------------------------- [ 2023-04-18T14:10:13+08:00 ] 223.81.89.208 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011480s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000518s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-04-18T14:10:49+08:00 ] 223.81.89.208 GET /home/show/read/id/26/imei/868922055684076.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001537s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009458s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009568s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.004089s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.020723s ]