--------------------------------------------------------------- [ 2022-10-11T05:20:18+08:00 ] 39.144.1.230 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2022-10-11T05:20:19+08:00 ] 39.144.1.230 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665436818&v1=0.018151&v2=0.016272&v3=0.015261&v4=-0.004666&v5=12.060000&t=14.347407&h=63.686890&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001847s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010335s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665436818,`v1`=0.018151,`v2`=0.016272,`v3`=0.015261,`v4`=-0.004666,`v5`=12.06,`t`=14.347407,`h`=63.68689,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665436819 WHERE `imei` = '868922055683920' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009830s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665436818 , 0.018151 , 0.016272 , 0.015261 , -0.004666 , 12.06 , 14.347407 , 63.68689 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665436819) [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2022-10-11T10:43:08+08:00 ] 117.132.196.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2022-10-11T10:43:10+08:00 ] 117.132.196.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665456188&v1=0.007074&v2=0.161991&v3=0.007405&v4=0.007856&v5=11.880000&t=18.572989&h=70.019341&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001712s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665456188,`v1`=0.007074,`v2`=0.161991,`v3`=0.007405,`v4`=0.007856,`v5`=11.88,`t`=18.572989,`h`=70.019341,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665456190 WHERE `imei` = '868922055677740' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022924s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665456188 , 0.007074 , 0.161991 , 0.007405 , 0.007856 , 11.88 , 18.572989 , 70.019341 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665456190) [ RunTime:0.000859s ] --------------------------------------------------------------- [ 2022-10-11T17:20:18+08:00 ] 117.132.195.228 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012149s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2022-10-11T17:20:19+08:00 ] 117.132.195.228 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665480018&v1=0.018512&v2=0.015333&v3=0.015652&v4=-0.004605&v5=12.240000&t=18.144093&h=64.426941&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000583s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665480018,`v1`=0.018512,`v2`=0.015333,`v3`=0.015652,`v4`=-0.004605,`v5`=12.24,`t`=18.144093,`h`=64.426941,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665480019 WHERE `imei` = '868922055683920' [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011126s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665480018 , 0.018512 , 0.015333 , 0.015652 , -0.004605 , 12.24 , 18.144093 , 64.426941 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665480019) [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2022-10-11T19:44:13+08:00 ] 39.144.14.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011597s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2022-10-11T19:44:15+08:00 ] 39.144.14.191 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665488653&v1=0.025977&v2=0.056013&v3=0.021763&v4=-0.002498&v5=6.660000&t=10.325496&h=65.624756&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010530s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000851s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665488653,`v1`=0.025977,`v2`=0.056013,`v3`=0.021763,`v4`=-0.002498,`v5`=6.66,`t`=10.325496,`h`=65.624756,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665488655 WHERE `imei` = '868922055644211' [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010625s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1665488653 , 0.025977 , 0.056013 , 0.021763 , -0.002498 , 6.66 , 10.325496 , 65.624756 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1665488655) [ RunTime:0.000804s ] --------------------------------------------------------------- [ 2022-10-11T22:15:51+08:00 ] 117.132.198.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010983s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2022-10-11T22:15:59+08:00 ] 117.132.198.123 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221011&time=221501&v1=-01.283&v2=+00.025&v3=-01.141&v4=-00.747&v5=05.9&t=+08.6&h=81.3&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.167&a2=01.301&a3=00.000&end=$ [ 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.008824s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221011',`time`='221501',`v1`=-1.283,`v2`=0.025,`v3`=-1.141,`v4`=-0.747,`v5`=5.9,`t`=8.6,`h`=81.3,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.167,`a2`=1.301,`update_time`=1665497759 WHERE `imei` = '868922055684076' [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012061s ] [ 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' , '221011' , '221501' , -1.283 , 0.025 , -1.141 , -0.747 , 5.9 , 8.6 , 81.3 , 227 , '460044618415249' , -0 , 0.167 , 1.301 , 1665497759 , 1665497759) [ RunTime:0.000901s ] --------------------------------------------------------------- [ 2022-10-11T22:43:28+08:00 ] 39.144.10.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011068s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2022-10-11T22:43:29+08:00 ] 39.144.10.114 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665499408&v1=0.007013&v2=0.049025&v3=0.007254&v4=0.007495&v5=12.060000&t=16.245646&h=69.981194&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012161s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665499408,`v1`=0.007013,`v2`=0.049025,`v3`=0.007254,`v4`=0.007495,`v5`=12.06,`t`=16.245646,`h`=69.981194,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665499409 WHERE `imei` = '868922055677740' [ RunTime:0.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012393s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665499408 , 0.007013 , 0.049025 , 0.007254 , 0.007495 , 12.06 , 16.245646 , 69.981194 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665499409) [ RunTime:0.000840s ]