--------------------------------------------------------------- [ 2022-10-14T05:20:16+08:00 ] 39.144.4.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010348s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000660s ] --------------------------------------------------------------- [ 2022-10-14T05:20:17+08:00 ] 39.144.4.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665696016&v1=0.018271&v2=0.011578&v3=0.015652&v4=-0.004726&v5=12.060000&t=17.650738&h=63.252014&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012190s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665696016,`v1`=0.018271,`v2`=0.011578,`v3`=0.015652,`v4`=-0.004726,`v5`=12.06,`t`=17.650738,`h`=63.252014,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665696017 WHERE `imei` = '868922055683920' [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011185s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665696016 , 0.018271 , 0.011578 , 0.015652 , -0.004726 , 12.06 , 17.650738 , 63.252014 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665696017) [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2022-10-14T10:45:08+08:00 ] 39.144.17.81 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012083s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2022-10-14T10:45:09+08:00 ] 39.144.17.81 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665715508&v1=0.007856&v2=0.486910&v3=0.007766&v4=0.008157&v5=11.880000&t=23.710300&h=70.553398&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009927s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665715508,`v1`=0.007856,`v2`=0.48691,`v3`=0.007766,`v4`=0.008157,`v5`=11.88,`t`=23.7103,`h`=70.553398,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665715509 WHERE `imei` = '868922055677740' [ RunTime:0.000546s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010040s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665715508 , 0.007856 , 0.48691 , 0.007766 , 0.008157 , 11.88 , 23.7103 , 70.553398 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665715509) [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2022-10-14T17:20:18+08:00 ] 117.132.194.233 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002283s ] 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` = '868922055683920' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2022-10-14T17:20:19+08:00 ] 117.132.194.233 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1665739218&v1=0.018572&v2=0.014290&v3=0.015893&v4=-0.004425&v5=12.060000&t=20.921892&h=64.632935&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001857s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009725s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1665739218,`v1`=0.018572,`v2`=0.01429,`v3`=0.015893,`v4`=-0.004425,`v5`=12.06,`t`=20.921892,`h`=64.632935,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1665739219 WHERE `imei` = '868922055683920' [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010675s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1665739218 , 0.018572 , 0.01429 , 0.015893 , -0.004425 , 12.06 , 20.921892 , 64.632935 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1665739219) [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2022-10-14T19:44:15+08:00 ] 39.144.7.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000760s ] --------------------------------------------------------------- [ 2022-10-14T19:44:16+08:00 ] 39.144.7.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1665747855&v1=0.026278&v2=0.046417&v3=0.022967&v4=-0.001836&v5=6.660000&t=15.741670&h=65.136475&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010302s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1665747855,`v1`=0.026278,`v2`=0.046417,`v3`=0.022967,`v4`=-0.001836,`v5`=6.66,`t`=15.74167,`h`=65.136475,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1665747856 WHERE `imei` = '868922055644211' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011813s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1665747855 , 0.026278 , 0.046417 , 0.022967 , -0.001836 , 6.66 , 15.74167 , 65.136475 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1665747856) [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2022-10-14T22:13:51+08:00 ] 218.204.252.158 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010624s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2022-10-14T22:13:59+08:00 ] 218.204.252.158 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221014&time=221301&v1=-01.276&v2=+00.024&v3=-01.135&v4=-00.749&v5=06.0&t=+15.2&h=81.1&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.165&a2=01.293&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.009769s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221014',`time`='221301',`v1`=-1.276,`v2`=0.024,`v3`=-1.135,`v4`=-0.749,`v5`=6,`t`=15.2,`h`=81.1,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.165,`a2`=1.293,`update_time`=1665756839 WHERE `imei` = '868922055684076' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011793s ] [ 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' , '221014' , '221301' , -1.276 , 0.024 , -1.135 , -0.749 , 6 , 15.2 , 81.1 , 228 , '460044618415249' , -0 , 0.165 , 1.293 , 1665756839 , 1665756839) [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2022-10-14T22:45:28+08:00 ] 221.178.125.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2022-10-14T22:45:29+08:00 ] 221.178.125.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1665758728&v1=0.007375&v2=0.044122&v3=0.007465&v4=0.007856&v5=11.880000&t=19.645496&h=69.637871&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1665758728,`v1`=0.007375,`v2`=0.044122,`v3`=0.007465,`v4`=0.007856,`v5`=11.88,`t`=19.645496,`h`=69.637871,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1665758729 WHERE `imei` = '868922055677740' [ RunTime:0.000507s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009731s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1665758728 , 0.007375 , 0.044122 , 0.007465 , 0.007856 , 11.88 , 19.645496 , 69.637871 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1665758729) [ RunTime:0.000838s ]