---------------------------------------------------------------
[ 2023-02-22T02:03:55+08:00 ] 111.55.139.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011363s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000750s ]
---------------------------------------------------------------
[ 2023-02-22T02:03:56+08:00 ] 39.144.14.200 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001909s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011633s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000761s ]
---------------------------------------------------------------
[ 2023-02-22T02:04:04+08:00 ] 111.55.139.66 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230222&time=020301&v1=-01.275&v2=+00.027&v3=-00.968&v4=-00.026&v5=05.6&t=-04.1&h=62.2&rssi=+229&ccid=4600485905031420000099m9990000000283000001g2890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001812s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011030s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230222',`time`='020301',`v1`=-1.275,`v2`=0.027,`v3`=-0.968,`v4`=-0.026,`v5`=5.6,`t`=-4.1,`h`=62.2,`rssi`=229,`ccid`='4600485905031420000099m9990000000283000001g2890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677002644 WHERE `imei` = '868922055643643' [ RunTime:0.000665s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012356s ]
[ 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' , '230222' , '020301' , -1.275 , 0.027 , -0.968 , -0.026 , 5.6 , -4.1 , 62.2 , 229 , '4600485905031420000099m9990000000283000001g2890,N,00E000=-00.000' , 0 , 0 , 1677002644 , 1677002644) [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2023-02-22T02:04:04+08:00 ] 39.144.14.200 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230222&time=020301&v1=-00.262&v2=+00.001&v3=-00.056&v4=-00.016&v5=05.6&t=-02.8&h=65.0&rssi=+226&ccid=4600485905031430000099m9990000000041000000g2980,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011562s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000747s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230222',`time`='020301',`v1`=-0.262,`v2`=0.001,`v3`=-0.056,`v4`=-0.016,`v5`=5.6,`t`=-2.8,`h`=65,`rssi`=226,`ccid`='4600485905031430000099m9990000000041000000g2980,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677002644 WHERE `imei` = '868922055644013' [ RunTime:0.000639s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011210s ]
[ 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' , '230222' , '020301' , -0.262 , 0.001 , -0.056 , -0.016 , 5.6 , -2.8 , 65 , 226 , '4600485905031430000099m9990000000041000000g2980,N,00E000=-00.000' , 0 , 0 , 1677002644 , 1677002644) [ RunTime:0.000545s ]
---------------------------------------------------------------
[ 2023-02-22T06:10:51+08:00 ] 117.132.196.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010355s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2023-02-22T06:11:00+08:00 ] 117.132.196.58 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230222&time=061001&v1=-01.264&v2=+00.021&v3=-01.054&v4=-00.615&v5=04.8&t=-04.4&h=80.4&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.242&a2=01.280&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001853s ] 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` = '868922055684076' LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230222',`time`='061001',`v1`=-1.264,`v2`=0.021,`v3`=-1.054,`v4`=-0.615,`v5`=4.8,`t`=-4.4,`h`=80.4,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.242,`a2`=1.28,`update_time`=1677017460 WHERE `imei` = '868922055684076' [ RunTime:0.000711s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011949s ]
[ 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' , '230222' , '061001' , -1.264 , 0.021 , -1.054 , -0.615 , 4.8 , -4.4 , 80.4 , 227 , '460044618415249' , -0 , 0.242 , 1.28 , 1677017460 , 1677017460) [ RunTime:0.001884s ]
---------------------------------------------------------------
[ 2023-02-22T14:03:55+08:00 ] 39.144.4.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002673s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011839s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000692s ]
---------------------------------------------------------------
[ 2023-02-22T14:03:55+08:00 ] 223.104.254.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011794s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000863s ]
---------------------------------------------------------------
[ 2023-02-22T14:04:03+08:00 ] 39.144.4.176 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230222&time=140301&v1=-00.248&v2=+00.002&v3=+00.019&v4=-00.016&v5=05.9&t=+09.3&h=64.3&rssi=+225&ccid=4600485905031430000099m9990000000037000000g2910,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002515s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011309s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000714s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230222',`time`='140301',`v1`=-0.248,`v2`=0.002,`v3`=0.019,`v4`=-0.016,`v5`=5.9,`t`=9.3,`h`=64.3,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g2910,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677045843 WHERE `imei` = '868922055644013' [ RunTime:0.000684s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013763s ]
[ 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' , '230222' , '140301' , -0.248 , 0.002 , 0.019 , -0.016 , 5.9 , 9.3 , 64.3 , 225 , '4600485905031430000099m9990000000037000000g2910,N,00E000=-00.000' , 0 , 0 , 1677045843 , 1677045843) [ RunTime:0.000808s ]
---------------------------------------------------------------
[ 2023-02-22T14:04:04+08:00 ] 223.104.254.35 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230222&time=140301&v1=-01.274&v2=+00.072&v3=-00.965&v4=-00.026&v5=05.7&t=+09.4&h=61.2&rssi=+229&ccid=4600485905031420000099m9990000000285000001g2880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.010400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012181s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000810s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230222',`time`='140301',`v1`=-1.274,`v2`=0.072,`v3`=-0.965,`v4`=-0.026,`v5`=5.7,`t`=9.4,`h`=61.2,`rssi`=229,`ccid`='4600485905031420000099m9990000000285000001g2880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677045844 WHERE `imei` = '868922055643643' [ RunTime:0.000587s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010824s ]
[ 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' , '230222' , '140301' , -1.274 , 0.072 , -0.965 , -0.026 , 5.7 , 9.4 , 61.2 , 229 , '4600485905031420000099m9990000000285000001g2880,N,00E000=-00.000' , 0 , 0 , 1677045844 , 1677045844) [ RunTime:0.000621s ]