--------------------------------------------------------------- [ 2023-01-02T02:03:51+08:00 ] 39.144.17.135 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2023-01-02T02:03:55+08:00 ] 39.144.1.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002231s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010182s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2023-01-02T02:03:55+08:00 ] 218.204.253.225 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009889s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2023-01-02T02:04:00+08:00 ] 39.144.17.135 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230102&time=020301&v1=-01.267&v2=+00.017&v3=-01.104&v4=-00.685&v5=05.6&t=-02.8&h=80.5&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.193&a2=01.282&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010698s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000803s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230102',`time`='020301',`v1`=-1.267,`v2`=0.017,`v3`=-1.104,`v4`=-0.685,`v5`=5.6,`t`=-2.8,`h`=80.5,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.193,`a2`=1.282,`update_time`=1672596240 WHERE `imei` = '868922055684076' [ RunTime:0.000677s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011739s ] [ 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' , '230102' , '020301' , -1.267 , 0.017 , -1.104 , -0.685 , 5.6 , -2.8 , 80.5 , 227 , '460044618415249' , -0 , 0.193 , 1.282 , 1672596240 , 1672596240) [ RunTime:0.002495s ] --------------------------------------------------------------- [ 2023-01-02T02:04:03+08:00 ] 39.144.1.56 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230102&time=020301&v1=-00.267&v2=+00.001&v3=+00.002&v4=-00.016&v5=05.6&t=-03.1&h=64.2&rssi=+227&ccid=4600485905031430000099m9990000000034000000g3190,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230102',`time`='020301',`v1`=-0.267,`v2`=0.001,`v3`=0.002,`v4`=-0.016,`v5`=5.6,`t`=-3.1,`h`=64.2,`rssi`=227,`ccid`='4600485905031430000099m9990000000034000000g3190,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672596243 WHERE `imei` = '868922055644013' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009194s ] [ 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' , '230102' , '020301' , -0.267 , 0.001 , 0.002 , -0.016 , 5.6 , -3.1 , 64.2 , 227 , '4600485905031430000099m9990000000034000000g3190,N,00E000=-00.000' , 0 , 0 , 1672596243 , 1672596243) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2023-01-02T02:04:04+08:00 ] 218.204.253.225 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230102&time=020301&v1=-01.263&v2=+00.026&v3=-01.008&v4=-00.043&v5=05.6&t=-03.8&h=60.8&rssi=+229&ccid=4600485905031420000099m9990000000230000001g2790,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002021s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010705s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000789s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230102',`time`='020301',`v1`=-1.263,`v2`=0.026,`v3`=-1.008,`v4`=-0.043,`v5`=5.6,`t`=-3.8,`h`=60.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000230000001g2790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672596244 WHERE `imei` = '868922055643643' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010447s ] [ 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' , '230102' , '020301' , -1.263 , 0.026 , -1.008 , -0.043 , 5.6 , -3.8 , 60.8 , 229 , '4600485905031420000099m9990000000230000001g2790,N,00E000=-00.000' , 0 , 0 , 1672596244 , 1672596244) [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-01-02T14:03:55+08:00 ] 39.144.14.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011820s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000792s ] --------------------------------------------------------------- [ 2023-01-02T14:03:56+08:00 ] 39.144.14.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010201s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-01-02T14:04:04+08:00 ] 39.144.14.180 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230102&time=140301&v1=-00.260&v2=+00.001&v3=+00.019&v4=-00.015&v5=05.9&t=+06.8&h=64.9&rssi=+226&ccid=4600485905031430000099m9990000000037000000g3160,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012301s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230102',`time`='140301',`v1`=-0.26,`v2`=0.001,`v3`=0.019,`v4`=-0.015,`v5`=5.9,`t`=6.8,`h`=64.9,`rssi`=226,`ccid`='4600485905031430000099m9990000000037000000g3160,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672639444 WHERE `imei` = '868922055644013' [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012933s ] [ 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' , '230102' , '140301' , -0.26 , 0.001 , 0.019 , -0.015 , 5.9 , 6.8 , 64.9 , 226 , '4600485905031430000099m9990000000037000000g3160,N,00E000=-00.000' , 0 , 0 , 1672639444 , 1672639444) [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2023-01-02T14:04:04+08:00 ] 39.144.14.148 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230102&time=140301&v1=-01.262&v2=+00.064&v3=-00.987&v4=-00.043&v5=05.7&t=+04.0&h=59.9&rssi=+229&ccid=4600485905031420000099m9990000000247000001g2780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001797s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010947s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230102',`time`='140301',`v1`=-1.262,`v2`=0.064,`v3`=-0.987,`v4`=-0.043,`v5`=5.7,`t`=4,`h`=59.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000247000001g2780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1672639444 WHERE `imei` = '868922055643643' [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009199s ] [ 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' , '230102' , '140301' , -1.262 , 0.064 , -0.987 , -0.043 , 5.7 , 4 , 59.9 , 229 , '4600485905031420000099m9990000000247000001g2780,N,00E000=-00.000' , 0 , 0 , 1672639444 , 1672639444) [ RunTime:0.000630s ]