--------------------------------------------------------------- [ 2023-03-05T02:03:55+08:00 ] 39.144.10.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001112s ] --------------------------------------------------------------- [ 2023-03-05T02:03:55+08:00 ] 223.104.255.15 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002084s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009032s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001284s ] --------------------------------------------------------------- [ 2023-03-05T02:04:04+08:00 ] 39.144.10.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230305&time=020301&v1=-00.206&v2=+00.001&v3=-00.022&v4=-00.019&v5=05.7&t=+06.9&h=65.3&rssi=+225&ccid=4600485905031430000099m9990000000017000000g2400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230305',`time`='020301',`v1`=-0.206,`v2`=0.001,`v3`=-0.022,`v4`=-0.019,`v5`=5.7,`t`=6.9,`h`=65.3,`rssi`=225,`ccid`='4600485905031430000099m9990000000017000000g2400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677953044 WHERE `imei` = '868922055644013' [ RunTime:0.000916s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011652s ] [ 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' , '230305' , '020301' , -0.206 , 0.001 , -0.022 , -0.019 , 5.7 , 6.9 , 65.3 , 225 , '4600485905031430000099m9990000000017000000g2400,N,00E000=-00.000' , 0 , 0 , 1677953044 , 1677953044) [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-03-05T02:04:04+08:00 ] 223.104.255.15 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230305&time=020301&v1=-01.317&v2=+00.018&v3=-00.991&v4=-00.016&v5=05.7&t=+05.5&h=62.6&rssi=+229&ccid=4600485905031420000099m9990000000319000001g3300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011049s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230305',`time`='020301',`v1`=-1.317,`v2`=0.018,`v3`=-0.991,`v4`=-0.016,`v5`=5.7,`t`=5.5,`h`=62.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000319000001g3300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677953044 WHERE `imei` = '868922055643643' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009554s ] [ 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' , '230305' , '020301' , -1.317 , 0.018 , -0.991 , -0.016 , 5.7 , 5.5 , 62.6 , 229 , '4600485905031420000099m9990000000319000001g3300,N,00E000=-00.000' , 0 , 0 , 1677953044 , 1677953044) [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2023-03-05T06:09:49+08:00 ] 39.144.5.208 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013258s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-03-05T06:09:57+08:00 ] 39.144.5.208 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230305&time=060901&v1=-01.267&v2=+00.021&v3=-01.039&v4=-00.655&v5=05.7&t=+03.7&h=81.5&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.257&a2=01.283&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009039s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230305',`time`='060901',`v1`=-1.267,`v2`=0.021,`v3`=-1.039,`v4`=-0.655,`v5`=5.7,`t`=3.7,`h`=81.5,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.257,`a2`=1.283,`update_time`=1677967797 WHERE `imei` = '868922055684076' [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010946s ] [ 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' , '230305' , '060901' , -1.267 , 0.021 , -1.039 , -0.655 , 5.7 , 3.7 , 81.5 , 227 , '460044618415249' , -0 , 0.257 , 1.283 , 1677967797 , 1677967797) [ RunTime:0.001339s ] --------------------------------------------------------------- [ 2023-03-05T14:03:55+08:00 ] 117.132.194.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-03-05T14:03:55+08:00 ] 39.144.8.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001824s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009932s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-03-05T14:04:03+08:00 ] 117.132.194.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230305&time=140301&v1=-00.215&v2=+00.001&v3=+00.019&v4=-00.018&v5=06.0&t=+17.6&h=64.7&rssi=+227&ccid=4600485905031430000099m9990000000038000000g2520,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230305',`time`='140301',`v1`=-0.215,`v2`=0.001,`v3`=0.019,`v4`=-0.018,`v5`=6,`t`=17.6,`h`=64.7,`rssi`=227,`ccid`='4600485905031430000099m9990000000038000000g2520,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677996243 WHERE `imei` = '868922055644013' [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010427s ] [ 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' , '230305' , '140301' , -0.215 , 0.001 , 0.019 , -0.018 , 6 , 17.6 , 64.7 , 227 , '4600485905031430000099m9990000000038000000g2520,N,00E000=-00.000' , 0 , 0 , 1677996243 , 1677996243) [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2023-03-05T14:04:04+08:00 ] 39.144.8.18 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230305&time=140301&v1=-01.302&v2=+00.033&v3=-00.991&v4=-00.018&v5=05.7&t=+15.3&h=61.1&rssi=+229&ccid=4600485905031420000099m9990000000301000001g3130,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011263s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230305',`time`='140301',`v1`=-1.302,`v2`=0.033,`v3`=-0.991,`v4`=-0.018,`v5`=5.7,`t`=15.3,`h`=61.1,`rssi`=229,`ccid`='4600485905031420000099m9990000000301000001g3130,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677996244 WHERE `imei` = '868922055643643' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010602s ] [ 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' , '230305' , '140301' , -1.302 , 0.033 , -0.991 , -0.018 , 5.7 , 15.3 , 61.1 , 229 , '4600485905031420000099m9990000000301000001g3130,N,00E000=-00.000' , 0 , 0 , 1677996244 , 1677996244) [ RunTime:0.000532s ]