--------------------------------------------------------------- [ 2022-09-28T05:20:17+08:00 ] 218.204.253.24 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2022-09-28T05:20:18+08:00 ] 218.204.253.24 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664313617&v1=0.018753&v2=0.013769&v3=0.015893&v4=-0.004666&v5=12.240000&t=22.112377&h=64.037842&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001352s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008449s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664313617,`v1`=0.018753,`v2`=0.013769,`v3`=0.015893,`v4`=-0.004666,`v5`=12.24,`t`=22.112377,`h`=64.037842,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664313618 WHERE `imei` = '868922055683920' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009677s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664313617 , 0.018753 , 0.013769 , 0.015893 , -0.004666 , 12.24 , 22.112377 , 64.037842 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664313618) [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2022-09-28T10:34:29+08:00 ] 117.132.195.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2022-09-28T10:34:30+08:00 ] 117.132.195.215 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664332469&v1=0.008097&v2=0.115365&v3=0.008097&v4=0.008759&v5=12.060000&t=27.367554&h=71.491814&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012317s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664332469,`v1`=0.008097,`v2`=0.115365,`v3`=0.008097,`v4`=0.008759,`v5`=12.06,`t`=27.367554,`h`=71.491814,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664332470 WHERE `imei` = '868922055677740' [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010794s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664332469 , 0.008097 , 0.115365 , 0.008097 , 0.008759 , 12.06 , 27.367554 , 71.491814 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1664332470) [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2022-09-28T17:20:16+08:00 ] 117.132.197.248 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002639s ] 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 `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2022-09-28T17:20:17+08:00 ] 117.132.197.248 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1664356816&v1=0.018993&v2=0.014916&v3=0.016284&v4=-0.004666&v5=12.240000&t=25.244106&h=64.610046&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1664356816,`v1`=0.018993,`v2`=0.014916,`v3`=0.016284,`v4`=-0.004666,`v5`=12.24,`t`=25.244106,`h`=64.610046,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1664356817 WHERE `imei` = '868922055683920' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008957s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1664356816 , 0.018993 , 0.014916 , 0.016284 , -0.004666 , 12.24 , 25.244106 , 64.610046 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1664356817) [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2022-09-28T18:08:51+08:00 ] 39.144.13.206 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.010318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2022-09-28T18:08:59+08:00 ] 39.144.13.206 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220928&time=180801&v1=-00.801&v2=+00.024&v3=-00.675&v4=-00.072&v5=06.0&t=+20.5&h=81.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.171&a2=00.856&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001688s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009614s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220928',`time`='180801',`v1`=-0.801,`v2`=0.024,`v3`=-0.675,`v4`=-0.072,`v5`=6,`t`=20.5,`h`=81.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.171,`a2`=0.856,`update_time`=1664359739 WHERE `imei` = '868922055684076' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010218s ] [ 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' , '220928' , '180801' , -0.801 , 0.024 , -0.675 , -0.072 , 6 , 20.5 , 81.1 , 228 , '460044618415249' , -0 , 0.171 , 0.856 , 1664359739 , 1664359739) [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2022-09-28T19:44:17+08:00 ] 221.178.126.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.001987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010135s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2022-09-28T19:44:19+08:00 ] 221.178.126.226 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1664365457&v1=0.026338&v2=0.033066&v3=0.022726&v4=-0.003823&v5=6.660000&t=17.543486&h=65.723938&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001374s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1664365457,`v1`=0.026338,`v2`=0.033066,`v3`=0.022726,`v4`=-0.003823,`v5`=6.66,`t`=17.543486,`h`=65.723938,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1664365459 WHERE `imei` = '868922055644211' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010437s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1664365457 , 0.026338 , 0.033066 , 0.022726 , -0.003823 , 6.66 , 17.543486 , 65.723938 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1664365459) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2022-09-28T22:34:49+08:00 ] 39.144.1.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002280s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010279s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000627s ] --------------------------------------------------------------- [ 2022-09-28T22:34:50+08:00 ] 39.144.1.25 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1664375689&v1=0.007796&v2=0.080839&v3=0.007736&v4=0.008157&v5=12.060000&t=23.538700&h=70.538139&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ 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.009809s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1664375689,`v1`=0.007796,`v2`=0.080839,`v3`=0.007736,`v4`=0.008157,`v5`=12.06,`t`=23.5387,`h`=70.538139,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1664375690 WHERE `imei` = '868922055677740' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010684s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1664375689 , 0.007796 , 0.080839 , 0.007736 , 0.008157 , 12.06 , 23.5387 , 70.538139 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1664375690) [ RunTime:0.000627s ]