--------------------------------------------------------------- [ 2023-02-18T02:03:55+08:00 ] 39.144.5.170 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-02-18T02:03:55+08:00 ] 39.144.7.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001650s ] 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` = '868922055643643' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-02-18T02:04:03+08:00 ] 39.144.5.170 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230218&time=020301&v1=-00.282&v2=+00.001&v3=-00.025&v4=-00.016&v5=05.7&t=+05.6&h=64.8&rssi=+225&ccid=4600485905031430000099m9990000000035000000g3240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230218',`time`='020301',`v1`=-0.282,`v2`=0.001,`v3`=-0.025,`v4`=-0.016,`v5`=5.7,`t`=5.6,`h`=64.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000035000000g3240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1676657043 WHERE `imei` = '868922055644013' [ RunTime:0.001203s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011265s ] [ 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' , '230218' , '020301' , -0.282 , 0.001 , -0.025 , -0.016 , 5.7 , 5.6 , 64.8 , 225 , '4600485905031430000099m9990000000035000000g3240,N,00E000=-00.000' , 0 , 0 , 1676657043 , 1676657043) [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2023-02-18T02:04:03+08:00 ] 39.144.7.10 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230218&time=020301&v1=-01.265&v2=+00.029&v3=-00.989&v4=-00.027&v5=05.6&t=+04.6&h=62.4&rssi=+229&ccid=4600485905031420000099m9990000000250000001g2780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002094s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230218',`time`='020301',`v1`=-1.265,`v2`=0.029,`v3`=-0.989,`v4`=-0.027,`v5`=5.6,`t`=4.6,`h`=62.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000250000001g2780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1676657043 WHERE `imei` = '868922055643643' [ RunTime:0.000514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017551s ] [ 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' , '230218' , '020301' , -1.265 , 0.029 , -0.989 , -0.027 , 5.6 , 4.6 , 62.4 , 229 , '4600485905031420000099m9990000000250000001g2780,N,00E000=-00.000' , 0 , 0 , 1676657043 , 1676657043) [ RunTime:0.000558s ] --------------------------------------------------------------- [ 2023-02-18T06:10:51+08:00 ] 39.144.15.188 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002279s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-02-18T06:10:59+08:00 ] 39.144.15.188 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230218&time=061001&v1=-01.262&v2=+00.021&v3=-01.035&v4=-00.618&v5=05.7&t=+04.5&h=80.8&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.255&a2=01.277&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009752s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000823s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230218',`time`='061001',`v1`=-1.262,`v2`=0.021,`v3`=-1.035,`v4`=-0.618,`v5`=5.7,`t`=4.5,`h`=80.8,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.255,`a2`=1.277,`update_time`=1676671859 WHERE `imei` = '868922055684076' [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011386s ] [ 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' , '230218' , '061001' , -1.262 , 0.021 , -1.035 , -0.618 , 5.7 , 4.5 , 80.8 , 229 , '460044618415249' , -0 , 0.255 , 1.277 , 1676671859 , 1676671859) [ RunTime:0.001227s ] --------------------------------------------------------------- [ 2023-02-18T14:03:54+08:00 ] 39.144.1.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012293s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-02-18T14:03:55+08:00 ] 39.144.13.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011061s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-02-18T14:04:03+08:00 ] 39.144.1.252 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230218&time=140301&v1=-00.271&v2=+00.001&v3=+00.009&v4=-00.017&v5=05.9&t=+09.9&h=64.3&rssi=+224&ccid=4600485905031430000099m9990000000037000000g3200,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013511s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000990s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230218',`time`='140301',`v1`=-0.271,`v2`=0.001,`v3`=0.009,`v4`=-0.017,`v5`=5.9,`t`=9.9,`h`=64.3,`rssi`=224,`ccid`='4600485905031430000099m9990000000037000000g3200,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1676700243 WHERE `imei` = '868922055644013' [ RunTime:0.000918s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015476s ] [ 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' , '230218' , '140301' , -0.271 , 0.001 , 0.009 , -0.017 , 5.9 , 9.9 , 64.3 , 224 , '4600485905031430000099m9990000000037000000g3200,N,00E000=-00.000' , 0 , 0 , 1676700243 , 1676700243) [ RunTime:0.001386s ] --------------------------------------------------------------- [ 2023-02-18T14:04:04+08:00 ] 39.144.13.163 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230218&time=140301&v1=-01.264&v2=+00.069&v3=-00.951&v4=-00.026&v5=05.7&t=+09.5&h=61.8&rssi=+228&ccid=4600485905031420000099m9990000000287000001g2780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001997s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010118s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230218',`time`='140301',`v1`=-1.264,`v2`=0.069,`v3`=-0.951,`v4`=-0.026,`v5`=5.7,`t`=9.5,`h`=61.8,`rssi`=228,`ccid`='4600485905031420000099m9990000000287000001g2780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1676700244 WHERE `imei` = '868922055643643' [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010109s ] [ 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' , '230218' , '140301' , -1.264 , 0.069 , -0.951 , -0.026 , 5.7 , 9.5 , 61.8 , 228 , '4600485905031420000099m9990000000287000001g2780,N,00E000=-00.000' , 0 , 0 , 1676700244 , 1676700244) [ RunTime:0.000556s ]