--------------------------------------------------------------- [ 2023-03-16T02:03:55+08:00 ] 39.144.4.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013617s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2023-03-16T02:03:56+08:00 ] 221.178.126.4 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001765s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-03-16T02:04:03+08:00 ] 39.144.4.94 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230316&time=020301&v1=-01.307&v2=+00.023&v3=-00.966&v4=-00.020&v5=05.6&t=+00.7&h=62.2&rssi=+228&ccid=4600485905031420000099m9990000000336000001g3190,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012600s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230316',`time`='020301',`v1`=-1.307,`v2`=0.023,`v3`=-0.966,`v4`=-0.02,`v5`=5.6,`t`=0.7,`h`=62.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000336000001g3190,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678903443 WHERE `imei` = '868922055643643' [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011520s ] [ 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' , '230316' , '020301' , -1.307 , 0.023 , -0.966 , -0.02 , 5.6 , 0.7 , 62.2 , 228 , '4600485905031420000099m9990000000336000001g3190,N,00E000=-00.000' , 0 , 0 , 1678903443 , 1678903443) [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-03-16T02:04:04+08:00 ] 221.178.126.4 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230316&time=020301&v1=-00.216&v2=+00.001&v3=+00.012&v4=-00.019&v5=05.7&t=+01.4&h=65.1&rssi=+225&ccid=4600485905031430000099m9990000000034000000g2500,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.011693s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000827s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230316',`time`='020301',`v1`=-0.216,`v2`=0.001,`v3`=0.012,`v4`=-0.019,`v5`=5.7,`t`=1.4,`h`=65.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000034000000g2500,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678903444 WHERE `imei` = '868922055644013' [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011574s ] [ 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' , '230316' , '020301' , -0.216 , 0.001 , 0.012 , -0.019 , 5.7 , 1.4 , 65.1 , 225 , '4600485905031430000099m9990000000034000000g2500,N,00E000=-00.000' , 0 , 0 , 1678903444 , 1678903444) [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-03-16T06:04:51+08:00 ] 39.144.10.80 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002128s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012210s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000798s ] --------------------------------------------------------------- [ 2023-03-16T06:05:00+08:00 ] 39.144.10.80 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230316&time=060401&v1=-01.117&v2=+00.025&v3=-00.845&v4=-00.507&v5=05.7&t=-00.2&h=81.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.299&a2=01.199&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230316',`time`='060401',`v1`=-1.117,`v2`=0.025,`v3`=-0.845,`v4`=-0.507,`v5`=5.7,`t`=-0.2,`h`=81,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.299,`a2`=1.199,`update_time`=1678917900 WHERE `imei` = '868922055684076' [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013459s ] [ 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' , '230316' , '060401' , -1.117 , 0.025 , -0.845 , -0.507 , 5.7 , -0.2 , 81 , 228 , '460044618415249' , -0 , 0.299 , 1.199 , 1678917900 , 1678917900) [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2023-03-16T08:29:56+08:00 ] 111.55.138.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012932s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2023-03-16T08:29:57+08:00 ] 111.55.138.172 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678926596&v1=0.028144&v2=1.100659&v3=0.028114&v4=0.028385&v5=12.420000&t=13.028220&h=37.777466&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011245s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678926596,`v1`=0.028144,`v2`=1.100659,`v3`=0.028114,`v4`=0.028385,`v5`=12.42,`t`=13.02822,`h`=37.777466,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678926597 WHERE `imei` = '868922056976109' [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012664s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678926596 , 0.028144 , 1.100659 , 0.028114 , 0.028385 , 12.42 , 13.02822 , 37.777466 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1678926597) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-03-16T08:30:44+08:00 ] 112.224.70.150 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010510s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001316s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2023-03-16T08:30:48+08:00 ] 112.224.70.150 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009898s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000736s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009936s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000499s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-03-16T08:30:55+08:00 ] 112.224.70.150 GET /admin/show/index.html [ 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.010584s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000425s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000862s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000873s ] --------------------------------------------------------------- [ 2023-03-16T08:31:00+08:00 ] 112.224.70.150 GET /admin/show/edit/id/43.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009834s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011548s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001235s ] --------------------------------------------------------------- [ 2023-03-16T08:31:08+08:00 ] 112.224.70.150 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010709s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='',`interval`=720,`gps`='',`username`='admin',`introduce`=' ',`update_time`=1678926668 WHERE `id` = 43 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-03-16T08:31:10+08:00 ] 112.224.70.150 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010525s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000385s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.002079s ] --------------------------------------------------------------- [ 2023-03-16T08:31:21+08:00 ] 112.224.70.150 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010989s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2023-03-16T08:31:26+08:00 ] 112.224.70.150 GET /admin/show/edit/id/43.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009818s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000493s ] --------------------------------------------------------------- [ 2023-03-16T08:31:28+08:00 ] 223.104.255.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.001728s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010648s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-03-16T08:31:30+08:00 ] 223.104.255.68 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678926688&v1=0.028204&v2=1.126632&v3=0.028806&v4=0.028084&v5=12.240000&t=14.079280&h=36.526245&rssi=16&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678926688,`v1`=0.028204,`v2`=1.126632,`v3`=0.028806,`v4`=0.028084,`v5`=12.24,`t`=14.07928,`h`=36.526245,`rssi`=16,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678926690 WHERE `imei` = '868922056976109' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011263s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678926688 , 0.028204 , 1.126632 , 0.028806 , 0.028084 , 12.24 , 14.07928 , 36.526245 , 16 , '898604650119C1078513' , '460048590708513' , -0 , 1678926690) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2023-03-16T08:31:35+08:00 ] 112.224.70.150 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001771s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='',`interval`=60,`gps`='',`username`='admin',`introduce`=' ',`update_time`=1678926695 WHERE `id` = 43 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-03-16T08:31:37+08:00 ] 112.224.70.150 GET /admin/show/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.010584s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000862s ] --------------------------------------------------------------- [ 2023-03-16T09:05:20+08:00 ] 112.224.70.150 GET /admin/show/index.html [ 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.010298s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000418s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000833s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000816s ] --------------------------------------------------------------- [ 2023-03-16T10:05:14+08:00 ] 112.226.123.19 POST /admin/login/login.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_manager` [ RunTime:0.014533s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-03-16T10:05:25+08:00 ] 112.226.123.19 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011949s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000826s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2023-03-16T10:05:31+08:00 ] 112.226.123.19 GET /admin/show/delete/id/46.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001755s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 46 [ RunTime:0.000745s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 46 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2023-03-16T10:05:33+08:00 ] 112.226.123.19 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001507s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011331s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000789s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000817s ] --------------------------------------------------------------- [ 2023-03-16T14:03:54+08:00 ] 117.132.198.214 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012122s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [ 2023-03-16T14:03:55+08:00 ] 117.132.194.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2023-03-16T14:04:03+08:00 ] 117.132.198.214 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230316&time=140301&v1=-00.235&v2=+00.002&v3=+00.020&v4=-00.017&v5=05.9&t=+11.5&h=64.3&rssi=+228&ccid=4600485905031430000099m9990000000037000000g2710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010040s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230316',`time`='140301',`v1`=-0.235,`v2`=0.002,`v3`=0.02,`v4`=-0.017,`v5`=5.9,`t`=11.5,`h`=64.3,`rssi`=228,`ccid`='4600485905031430000099m9990000000037000000g2710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678946643 WHERE `imei` = '868922055644013' [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011825s ] [ 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' , '230316' , '140301' , -0.235 , 0.002 , 0.02 , -0.017 , 5.9 , 11.5 , 64.3 , 228 , '4600485905031430000099m9990000000037000000g2710,N,00E000=-00.000' , 0 , 0 , 1678946643 , 1678946643) [ RunTime:0.001326s ] --------------------------------------------------------------- [ 2023-03-16T14:04:03+08:00 ] 117.132.194.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230316&time=140301&v1=-01.297&v2=+00.059&v3=-00.950&v4=-00.021&v5=06.0&t=+11.2&h=61.5&rssi=+231&ccid=4600485905031420000099m9990000000342000001g3090,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002104s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000913s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230316',`time`='140301',`v1`=-1.297,`v2`=0.059,`v3`=-0.95,`v4`=-0.021,`v5`=6,`t`=11.2,`h`=61.5,`rssi`=231,`ccid`='4600485905031420000099m9990000000342000001g3090,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678946643 WHERE `imei` = '868922055643643' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008812s ] [ 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' , '230316' , '140301' , -1.297 , 0.059 , -0.95 , -0.021 , 6 , 11.2 , 61.5 , 231 , '4600485905031420000099m9990000000342000001g3090,N,00E000=-00.000' , 0 , 0 , 1678946643 , 1678946643) [ RunTime:0.001133s ] --------------------------------------------------------------- [ 2023-03-16T19:18:35+08:00 ] 112.224.70.150 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015238s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000446s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001433s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000894s ] --------------------------------------------------------------- [ 2023-03-16T20:31:24+08:00 ] 39.144.18.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002502s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012508s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-03-16T20:31:25+08:00 ] 39.144.18.104 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678969884&v1=0.028023&v2=0.653177&v3=0.028565&v4=0.028084&v5=12.420000&t=12.588491&h=39.104980&rssi=18&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001882s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678969884,`v1`=0.028023,`v2`=0.653177,`v3`=0.028565,`v4`=0.028084,`v5`=12.42,`t`=12.588491,`h`=39.10498,`rssi`=18,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678969885 WHERE `imei` = '868922056976109' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013494s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678969884 , 0.028023 , 0.653177 , 0.028565 , 0.028084 , 12.42 , 12.588491 , 39.10498 , 18 , '898604650119C1078513' , '460048590708513' , -0 , 1678969885) [ RunTime:0.001285s ] --------------------------------------------------------------- [ 2023-03-16T21:31:32+08:00 ] 39.144.18.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-03-16T22:31:26+08:00 ] 218.204.253.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.011551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010756s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2023-03-16T22:31:28+08:00 ] 218.204.253.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678977086&v1=0.028144&v2=0.706270&v3=0.028535&v4=0.028023&v5=12.420000&t=12.459790&h=39.150757&rssi=18&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009480s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678977086,`v1`=0.028144,`v2`=0.70627,`v3`=0.028535,`v4`=0.028023,`v5`=12.42,`t`=12.45979,`h`=39.150757,`rssi`=18,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678977088 WHERE `imei` = '868922056976109' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011241s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678977086 , 0.028144 , 0.70627 , 0.028535 , 0.028023 , 12.42 , 12.45979 , 39.150757 , 18 , '898604650119C1078513' , '460048590708513' , -0 , 1678977088) [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-03-16T22:31:31+08:00 ] 218.204.253.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678973461&v1=0.028144&v2=1.286224&v3=0.028595&v4=0.028023&v5=12.420000&t=12.513415&h=39.135498&rssi=18&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001633s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010228s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678973461,`v1`=0.028144,`v2`=1.286224,`v3`=0.028595,`v4`=0.028023,`v5`=12.42,`t`=12.513415,`h`=39.135498,`rssi`=18,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678977090 WHERE `imei` = '868922056976109' [ RunTime:0.000515s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010937s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678973461 , 0.028144 , 1.286224 , 0.028595 , 0.028023 , 12.42 , 12.513415 , 39.135498 , 18 , '898604650119C1078513' , '460048590708513' , -0 , 1678977091) [ RunTime:0.000471s ] --------------------------------------------------------------- [ 2023-03-16T23:31:28+08:00 ] 111.55.137.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011782s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000878s ] --------------------------------------------------------------- [ 2023-03-16T23:31:29+08:00 ] 111.55.137.111 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678980688&v1=0.028084&v2=1.291960&v3=0.028505&v4=0.028023&v5=12.420000&t=12.352539&h=39.211792&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009813s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678980688,`v1`=0.028084,`v2`=1.29196,`v3`=0.028505,`v4`=0.028023,`v5`=12.42,`t`=12.352539,`h`=39.211792,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678980689 WHERE `imei` = '868922056976109' [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012699s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678980688 , 0.028084 , 1.29196 , 0.028505 , 0.028023 , 12.42 , 12.352539 , 39.211792 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1678980689) [ RunTime:0.000657s ]