--------------------------------------------------------------- [ 2023-01-20T02:00:51+08:00 ] 39.144.5.220 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013029s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2023-01-20T02:01:00+08:00 ] 39.144.5.220 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230120&time=020001&v1=-01.263&v2=+00.017&v3=-01.098&v4=-00.679&v5=05.6&t=-02.1&h=80.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.196&a2=01.279&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011272s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230120',`time`='020001',`v1`=-1.263,`v2`=0.017,`v3`=-1.098,`v4`=-0.679,`v5`=5.6,`t`=-2.1,`h`=80.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.196,`a2`=1.279,`update_time`=1674151260 WHERE `imei` = '868922055684076' [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010793s ] [ 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' , '230120' , '020001' , -1.263 , 0.017 , -1.098 , -0.679 , 5.6 , -2.1 , 80.9 , 227 , '460044618415249' , -0 , 0.196 , 1.279 , 1674151260 , 1674151260) [ RunTime:0.001384s ] --------------------------------------------------------------- [ 2023-01-20T02:03:55+08:00 ] 39.144.15.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009657s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-01-20T02:03:55+08:00 ] 117.132.191.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002292s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-01-20T02:04:04+08:00 ] 39.144.15.236 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230120&time=020301&v1=-00.266&v2=+00.001&v3=+00.018&v4=-00.016&v5=05.6&t=-01.6&h=64.8&rssi=+225&ccid=4600485905031430000099m9990000000035000000g3200,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230120',`time`='020301',`v1`=-0.266,`v2`=0.001,`v3`=0.018,`v4`=-0.016,`v5`=5.6,`t`=-1.6,`h`=64.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000035000000g3200,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674151444 WHERE `imei` = '868922055644013' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010293s ] [ 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' , '230120' , '020301' , -0.266 , 0.001 , 0.018 , -0.016 , 5.6 , -1.6 , 64.8 , 225 , '4600485905031430000099m9990000000035000000g3200,N,00E000=-00.000' , 0 , 0 , 1674151444 , 1674151444) [ RunTime:0.000517s ] --------------------------------------------------------------- [ 2023-01-20T02:04:05+08:00 ] 117.132.191.129 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230120&time=020301&v1=-01.271&v2=+00.013&v3=-00.948&v4=-00.041&v5=06.0&t=-02.0&h=61.9&rssi=+229&ccid=4600485905031420000099m9990000000301000001g2860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230120',`time`='020301',`v1`=-1.271,`v2`=0.013,`v3`=-0.948,`v4`=-0.041,`v5`=6,`t`=-2,`h`=61.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000301000001g2860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674151445 WHERE `imei` = '868922055643643' [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010899s ] [ 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' , '230120' , '020301' , -1.271 , 0.013 , -0.948 , -0.041 , 6 , -2 , 61.9 , 229 , '4600485905031420000099m9990000000301000001g2860,N,00E000=-00.000' , 0 , 0 , 1674151445 , 1674151445) [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-01-20T14:03:55+08:00 ] 39.144.7.12 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012784s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000790s ] --------------------------------------------------------------- [ 2023-01-20T14:03:56+08:00 ] 39.144.4.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010199s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-01-20T14:04:04+08:00 ] 39.144.7.12 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230120&time=140301&v1=-00.262&v2=+00.001&v3=+00.019&v4=-00.015&v5=05.7&t=+01.8&h=65.3&rssi=+228&ccid=4600485905031430000099m9990000000036000000g3160,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003570s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000939s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230120',`time`='140301',`v1`=-0.262,`v2`=0.001,`v3`=0.019,`v4`=-0.015,`v5`=5.7,`t`=1.8,`h`=65.3,`rssi`=228,`ccid`='4600485905031430000099m9990000000036000000g3160,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674194644 WHERE `imei` = '868922055644013' [ RunTime:0.000865s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014324s ] [ 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' , '230120' , '140301' , -0.262 , 0.001 , 0.019 , -0.015 , 5.7 , 1.8 , 65.3 , 228 , '4600485905031430000099m9990000000036000000g3160,N,00E000=-00.000' , 0 , 0 , 1674194644 , 1674194644) [ RunTime:0.001002s ] --------------------------------------------------------------- [ 2023-01-20T14:04:04+08:00 ] 39.144.4.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230120&time=140301&v1=-01.271&v2=+00.013&v3=-00.941&v4=-00.041&v5=05.6&t=+00.0&h=61.3&rssi=+230&ccid=4600485905031420000099m9990000000309000001g2850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013192s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000962s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230120',`time`='140301',`v1`=-1.271,`v2`=0.013,`v3`=-0.941,`v4`=-0.041,`v5`=5.6,`t`=0,`h`=61.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000309000001g2850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674194644 WHERE `imei` = '868922055643643' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013247s ] [ 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' , '230120' , '140301' , -1.271 , 0.013 , -0.941 , -0.041 , 5.6 , 0 , 61.3 , 230 , '4600485905031420000099m9990000000309000001g2850,N,00E000=-00.000' , 0 , 0 , 1674194644 , 1674194644) [ RunTime:0.000725s ]