--------------------------------------------------------------- [ 2023-04-16T02:03:54+08:00 ] 39.144.18.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003935s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012419s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001392s ] --------------------------------------------------------------- [ 2023-04-16T02:03:54+08:00 ] 221.178.124.121 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009087s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2023-04-16T02:04:03+08:00 ] 39.144.18.132 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230416&time=020301&v1=-00.259&v2=+00.001&v3=-00.139&v4=-00.018&v5=05.9&t=+09.9&h=64.8&rssi=+224&ccid=4600485905031430000099m9990000000008000000g2680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010425s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230416',`time`='020301',`v1`=-0.259,`v2`=0.001,`v3`=-0.139,`v4`=-0.018,`v5`=5.9,`t`=9.9,`h`=64.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000008000000g2680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681581843 WHERE `imei` = '868922055644013' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013071s ] [ 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' , '230416' , '020301' , -0.259 , 0.001 , -0.139 , -0.018 , 5.9 , 9.9 , 64.8 , 224 , '4600485905031430000099m9990000000008000000g2680,N,00E000=-00.000' , 0 , 0 , 1681581843 , 1681581843) [ RunTime:0.002174s ] --------------------------------------------------------------- [ 2023-04-16T02:04:03+08:00 ] 221.178.124.121 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230416&time=020301&v1=-01.334&v2=+00.018&v3=-01.006&v4=-00.025&v5=05.7&t=+09.4&h=61.8&rssi=+228&ccid=4600485905031420000099m9990000000330000001g3450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230416',`time`='020301',`v1`=-1.334,`v2`=0.018,`v3`=-1.006,`v4`=-0.025,`v5`=5.7,`t`=9.4,`h`=61.8,`rssi`=228,`ccid`='4600485905031420000099m9990000000330000001g3450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681581843 WHERE `imei` = '868922055643643' [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010102s ] [ 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' , '230416' , '020301' , -1.334 , 0.018 , -1.006 , -0.025 , 5.7 , 9.4 , 61.8 , 228 , '4600485905031420000099m9990000000330000001g3450,N,00E000=-00.000' , 0 , 0 , 1681581843 , 1681581843) [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-04-16T10:05:53+08:00 ] 39.144.16.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.004034s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001319s ] --------------------------------------------------------------- [ 2023-04-16T10:05:59+08:00 ] 39.144.16.68 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230416&time=100501&v1=-01.182&v2=+00.028&v3=-01.075&v4=-00.288&v5=05.9&t=+20.0&h=79.7&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.129&a2=01.236&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009772s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230416',`time`='100501',`v1`=-1.182,`v2`=0.028,`v3`=-1.075,`v4`=-0.288,`v5`=5.9,`t`=20,`h`=79.7,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.129,`a2`=1.236,`update_time`=1681610759 WHERE `imei` = '868922055684076' [ RunTime:0.000830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014810s ] [ 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' , '230416' , '100501' , -1.182 , 0.028 , -1.075 , -0.288 , 5.9 , 20 , 79.7 , 227 , '460044618415249' , -0 , 0.129 , 1.236 , 1681610759 , 1681610759) [ RunTime:0.001303s ] --------------------------------------------------------------- [ 2023-04-16T14:03:55+08:00 ] 39.144.14.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010524s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-04-16T14:03:55+08:00 ] 223.104.255.208 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001821s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009286s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-04-16T14:04:03+08:00 ] 39.144.14.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230416&time=140301&v1=-00.292&v2=+00.001&v3=+00.019&v4=-00.016&v5=06.0&t=+22.3&h=62.7&rssi=+225&ccid=4600485905031430000099m9990000000042000000g3210,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009207s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230416',`time`='140301',`v1`=-0.292,`v2`=0.001,`v3`=0.019,`v4`=-0.016,`v5`=6,`t`=22.3,`h`=62.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000042000000g3210,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681625043 WHERE `imei` = '868922055644013' [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011635s ] [ 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' , '230416' , '140301' , -0.292 , 0.001 , 0.019 , -0.016 , 6 , 22.3 , 62.7 , 225 , '4600485905031430000099m9990000000042000000g3210,N,00E000=-00.000' , 0 , 0 , 1681625043 , 1681625043) [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-04-16T14:04:04+08:00 ] 223.104.255.208 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230416&time=140301&v1=-01.333&v2=+00.024&v3=-00.983&v4=-00.025&v5=05.9&t=+19.8&h=59.4&rssi=+228&ccid=4600485905031420000099m9990000000353000001g3430,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010790s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230416',`time`='140301',`v1`=-1.333,`v2`=0.024,`v3`=-0.983,`v4`=-0.025,`v5`=5.9,`t`=19.8,`h`=59.4,`rssi`=228,`ccid`='4600485905031420000099m9990000000353000001g3430,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681625044 WHERE `imei` = '868922055643643' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011252s ] [ 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' , '230416' , '140301' , -1.333 , 0.024 , -0.983 , -0.025 , 5.9 , 19.8 , 59.4 , 228 , '4600485905031420000099m9990000000353000001g3430,N,00E000=-00.000' , 0 , 0 , 1681625044 , 1681625044) [ RunTime:0.000533s ]