--------------------------------------------------------------- [ 2023-03-29T02:03:55+08:00 ] 39.144.16.230 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010284s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-03-29T02:03:55+08:00 ] 39.144.4.234 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014616s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001154s ] --------------------------------------------------------------- [ 2023-03-29T02:04:03+08:00 ] 39.144.16.230 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230329&time=020301&v1=-01.318&v2=+00.023&v3=-00.960&v4=-00.019&v5=05.7&t=+08.4&h=61.8&rssi=+229&ccid=4600485905031420000099m9990000000359000001g3320,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230329',`time`='020301',`v1`=-1.318,`v2`=0.023,`v3`=-0.96,`v4`=-0.019,`v5`=5.7,`t`=8.4,`h`=61.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000359000001g3320,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680026643 WHERE `imei` = '868922055643643' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011400s ] [ 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' , '230329' , '020301' , -1.318 , 0.023 , -0.96 , -0.019 , 5.7 , 8.4 , 61.8 , 229 , '4600485905031420000099m9990000000359000001g3320,N,00E000=-00.000' , 0 , 0 , 1680026643 , 1680026643) [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-03-29T02:04:04+08:00 ] 39.144.4.234 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230329&time=020301&v1=-00.217&v2=+00.001&v3=-00.056&v4=-00.018&v5=05.9&t=+09.6&h=64.8&rssi=+226&ccid=4600485905031430000099m9990000000002000000g2530,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002077s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230329',`time`='020301',`v1`=-0.217,`v2`=0.001,`v3`=-0.056,`v4`=-0.018,`v5`=5.9,`t`=9.6,`h`=64.8,`rssi`=226,`ccid`='4600485905031430000099m9990000000002000000g2530,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680026644 WHERE `imei` = '868922055644013' [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011119s ] [ 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' , '230329' , '020301' , -0.217 , 0.001 , -0.056 , -0.018 , 5.9 , 9.6 , 64.8 , 226 , '4600485905031430000099m9990000000002000000g2530,N,00E000=-00.000' , 0 , 0 , 1680026644 , 1680026644) [ RunTime:0.000610s ] --------------------------------------------------------------- [ 2023-03-29T10:15:50+08:00 ] 117.132.193.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010079s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-03-29T10:15:59+08:00 ] 117.132.193.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230329&time=101501&v1=-01.278&v2=+00.022&v3=-01.035&v4=-00.394&v5=06.0&t=+24.8&h=79.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.261&a2=01.293&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009927s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230329',`time`='101501',`v1`=-1.278,`v2`=0.022,`v3`=-1.035,`v4`=-0.394,`v5`=6,`t`=24.8,`h`=79,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.261,`a2`=1.293,`update_time`=1680056159 WHERE `imei` = '868922055684076' [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011709s ] [ 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' , '230329' , '101501' , -1.278 , 0.022 , -1.035 , -0.394 , 6 , 24.8 , 79 , 228 , '460044618415249' , -0 , 0.261 , 1.293 , 1680056159 , 1680056159) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-03-29T14:03:54+08:00 ] 221.178.126.160 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003090s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011535s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-03-29T14:03:55+08:00 ] 111.55.136.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-03-29T14:04:03+08:00 ] 221.178.126.160 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230329&time=140301&v1=-01.294&v2=+00.043&v3=-00.929&v4=-00.023&v5=05.9&t=+22.6&h=59.3&rssi=+230&ccid=4600485905031420000099m9990000000361000001g3040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230329',`time`='140301',`v1`=-1.294,`v2`=0.043,`v3`=-0.929,`v4`=-0.023,`v5`=5.9,`t`=22.6,`h`=59.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000361000001g3040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680069843 WHERE `imei` = '868922055643643' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010831s ] [ 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' , '230329' , '140301' , -1.294 , 0.043 , -0.929 , -0.023 , 5.9 , 22.6 , 59.3 , 230 , '4600485905031420000099m9990000000361000001g3040,N,00E000=-00.000' , 0 , 0 , 1680069843 , 1680069843) [ RunTime:0.001701s ] --------------------------------------------------------------- [ 2023-03-29T14:04:03+08:00 ] 111.55.136.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230329&time=140301&v1=-00.189&v2=+00.001&v3=+00.020&v4=-00.018&v5=06.0&t=+25.5&h=63.1&rssi=+227&ccid=4600485905031430000099m9990000000039000000g2220,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009971s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230329',`time`='140301',`v1`=-0.189,`v2`=0.001,`v3`=0.02,`v4`=-0.018,`v5`=6,`t`=25.5,`h`=63.1,`rssi`=227,`ccid`='4600485905031430000099m9990000000039000000g2220,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680069843 WHERE `imei` = '868922055644013' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011872s ] [ 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' , '230329' , '140301' , -0.189 , 0.001 , 0.02 , -0.018 , 6 , 25.5 , 63.1 , 227 , '4600485905031430000099m9990000000039000000g2220,N,00E000=-00.000' , 0 , 0 , 1680069843 , 1680069843) [ RunTime:0.001078s ]