--------------------------------------------------------------- [ 2023-01-27T02:03:55+08:00 ] 117.132.195.52 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012693s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2023-01-27T02:03:55+08:00 ] 117.132.197.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001730s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-01-27T02:04:04+08:00 ] 117.132.195.52 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230127&time=020301&v1=-00.298&v2=+00.001&v3=-00.140&v4=-00.011&v5=05.6&t=-07.0&h=64.4&rssi=+226&ccid=4600485905031430000099m9990000000006000000g3510,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230127',`time`='020301',`v1`=-0.298,`v2`=0.001,`v3`=-0.14,`v4`=-0.011,`v5`=5.6,`t`=-7,`h`=64.4,`rssi`=226,`ccid`='4600485905031430000099m9990000000006000000g3510,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674756244 WHERE `imei` = '868922055644013' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009676s ] [ 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' , '230127' , '020301' , -0.298 , 0.001 , -0.14 , -0.011 , 5.6 , -7 , 64.4 , 226 , '4600485905031430000099m9990000000006000000g3510,N,00E000=-00.000' , 0 , 0 , 1674756244 , 1674756244) [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2023-01-27T02:04:04+08:00 ] 117.132.197.190 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230127&time=020301&v1=-01.243&v2=+00.013&v3=-00.940&v4=-00.038&v5=05.9&t=-07.7&h=61.8&rssi=+230&ccid=4600485905031420000099m9990000000277000001g2590,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230127',`time`='020301',`v1`=-1.243,`v2`=0.013,`v3`=-0.94,`v4`=-0.038,`v5`=5.9,`t`=-7.7,`h`=61.8,`rssi`=230,`ccid`='4600485905031420000099m9990000000277000001g2590,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674756244 WHERE `imei` = '868922055643643' [ RunTime:0.000536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010142s ] [ 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' , '230127' , '020301' , -1.243 , 0.013 , -0.94 , -0.038 , 5.9 , -7.7 , 61.8 , 230 , '4600485905031420000099m9990000000277000001g2590,N,00E000=-00.000' , 0 , 0 , 1674756244 , 1674756244) [ RunTime:0.000902s ] --------------------------------------------------------------- [ 2023-01-27T14:03:55+08:00 ] 39.144.10.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002201s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013045s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-01-27T14:03:56+08:00 ] 39.144.18.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001614s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2023-01-27T14:04:04+08:00 ] 39.144.10.100 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230127&time=140301&v1=-00.289&v2=+00.001&v3=+00.019&v4=-00.015&v5=05.7&t=+00.5&h=64.6&rssi=+220&ccid=4600485905031430000099m9990000000036000000g3490,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012943s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.002492s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230127',`time`='140301',`v1`=-0.289,`v2`=0.001,`v3`=0.019,`v4`=-0.015,`v5`=5.7,`t`=0.5,`h`=64.6,`rssi`=220,`ccid`='4600485905031430000099m9990000000036000000g3490,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674799444 WHERE `imei` = '868922055644013' [ RunTime:0.000781s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013595s ] [ 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' , '230127' , '140301' , -0.289 , 0.001 , 0.019 , -0.015 , 5.7 , 0.5 , 64.6 , 220 , '4600485905031430000099m9990000000036000000g3490,N,00E000=-00.000' , 0 , 0 , 1674799444 , 1674799444) [ RunTime:0.000871s ] --------------------------------------------------------------- [ 2023-01-27T14:04:04+08:00 ] 39.144.18.107 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230127&time=140301&v1=-01.243&v2=+00.012&v3=-00.919&v4=-00.038&v5=05.6&t=-00.3&h=61.3&rssi=+231&ccid=4600485905031420000099m9990000000297000001g2570,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002617s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000933s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230127',`time`='140301',`v1`=-1.243,`v2`=0.012,`v3`=-0.919,`v4`=-0.038,`v5`=5.6,`t`=-0.3,`h`=61.3,`rssi`=231,`ccid`='4600485905031420000099m9990000000297000001g2570,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674799444 WHERE `imei` = '868922055643643' [ RunTime:0.000749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013203s ] [ 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' , '230127' , '140301' , -1.243 , 0.012 , -0.919 , -0.038 , 5.6 , -0.3 , 61.3 , 231 , '4600485905031420000099m9990000000297000001g2570,N,00E000=-00.000' , 0 , 0 , 1674799444 , 1674799444) [ RunTime:0.000690s ]