--------------------------------------------------------------- [ 2023-01-05T02:03:51+08:00 ] 39.144.2.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011347s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-01-05T02:03:55+08:00 ] 39.144.4.80 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011496s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-01-05T02:03:55+08:00 ] 39.144.3.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001998s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000668s ] --------------------------------------------------------------- [ 2023-01-05T02:04:00+08:00 ] 39.144.2.85 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230105&time=020301&v1=-01.264&v2=+00.023&v3=-01.101&v4=-00.683&v5=05.7&t=-00.9&h=80.7&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.193&a2=01.280&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230105',`time`='020301',`v1`=-1.264,`v2`=0.023,`v3`=-1.101,`v4`=-0.683,`v5`=5.7,`t`=-0.9,`h`=80.7,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.193,`a2`=1.28,`update_time`=1672855440 WHERE `imei` = '868922055684076' [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012483s ] [ 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' , '230105' , '020301' , -1.264 , 0.023 , -1.101 , -0.683 , 5.7 , -0.9 , 80.7 , 227 , '460044618415249' , -0 , 0.193 , 1.28 , 1672855440 , 1672855440) [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2023-01-05T02:04:03+08:00 ] 39.144.4.80 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230105&time=020301&v1=-00.248&v2=+00.001&v3=-00.058&v4=-00.015&v5=05.6&t=-03.0&h=64.2&rssi=+225&ccid=4600485905031430000099m9990000000039000000g2860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001966s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011182s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230105',`time`='020301',`v1`=-0.248,`v2`=0.001,`v3`=-0.058,`v4`=-0.015,`v5`=5.6,`t`=-3,`h`=64.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000039000000g2860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672855443 WHERE `imei` = '868922055644013' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010737s ] [ 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' , '230105' , '020301' , -0.248 , 0.001 , -0.058 , -0.015 , 5.6 , -3 , 64.2 , 225 , '4600485905031430000099m9990000000039000000g2860,N,00E000=-00.000' , 0 , 0 , 1672855443 , 1672855443) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-01-05T02:04:04+08:00 ] 39.144.3.149 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230105&time=020301&v1=-01.236&v2=+00.032&v3=-00.989&v4=-00.040&v5=05.6&t=-03.7&h=61.0&rssi=+229&ccid=4600485905031420000099m9990000000222000001g2510,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011278s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000860s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230105',`time`='020301',`v1`=-1.236,`v2`=0.032,`v3`=-0.989,`v4`=-0.04,`v5`=5.6,`t`=-3.7,`h`=61,`rssi`=229,`ccid`='4600485905031420000099m9990000000222000001g2510,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672855444 WHERE `imei` = '868922055643643' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011781s ] [ 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' , '230105' , '020301' , -1.236 , 0.032 , -0.989 , -0.04 , 5.6 , -3.7 , 61 , 229 , '4600485905031420000099m9990000000222000001g2510,N,00E000=-00.000' , 0 , 0 , 1672855444 , 1672855444) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-01-05T14:03:55+08:00 ] 39.144.10.113 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003547s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000788s ] --------------------------------------------------------------- [ 2023-01-05T14:03:55+08:00 ] 39.144.7.4 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010226s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000908s ] --------------------------------------------------------------- [ 2023-01-05T14:04:03+08:00 ] 39.144.10.113 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230105&time=140301&v1=-00.242&v2=+00.001&v3=+00.016&v4=-00.016&v5=05.9&t=+08.2&h=63.6&rssi=+225&ccid=4600485905031430000099m9990000000036000000g2950,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002008s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000967s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230105',`time`='140301',`v1`=-0.242,`v2`=0.001,`v3`=0.016,`v4`=-0.016,`v5`=5.9,`t`=8.2,`h`=63.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000036000000g2950,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672898643 WHERE `imei` = '868922055644013' [ RunTime:0.001064s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011082s ] [ 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' , '230105' , '140301' , -0.242 , 0.001 , 0.016 , -0.016 , 5.9 , 8.2 , 63.6 , 225 , '4600485905031430000099m9990000000036000000g2950,N,00E000=-00.000' , 0 , 0 , 1672898643 , 1672898643) [ RunTime:0.000926s ] --------------------------------------------------------------- [ 2023-01-05T14:04:04+08:00 ] 39.144.7.4 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230105&time=140301&v1=-01.236&v2=+00.075&v3=-00.983&v4=-00.038&v5=06.0&t=+06.6&h=59.7&rssi=+231&ccid=4600485905031420000099m9990000000232000001g2520,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010007s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230105',`time`='140301',`v1`=-1.236,`v2`=0.075,`v3`=-0.983,`v4`=-0.038,`v5`=6,`t`=6.6,`h`=59.7,`rssi`=231,`ccid`='4600485905031420000099m9990000000232000001g2520,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672898644 WHERE `imei` = '868922055643643' [ RunTime:0.000558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009064s ] [ 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' , '230105' , '140301' , -1.236 , 0.075 , -0.983 , -0.038 , 6 , 6.6 , 59.7 , 231 , '4600485905031420000099m9990000000232000001g2520,N,00E000=-00.000' , 0 , 0 , 1672898644 , 1672898644) [ RunTime:0.000813s ]