--------------------------------------------------------------- [ 2023-03-22T02:03:54+08:00 ] 39.144.6.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012038s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2023-03-22T02:03:54+08:00 ] 111.55.139.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009857s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-03-22T02:04:03+08:00 ] 39.144.6.20 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230322&time=020301&v1=-01.292&v2=+00.025&v3=-00.953&v4=-00.023&v5=05.7&t=+10.8&h=61.8&rssi=+229&ccid=4600485905031420000099m9990000000331000001g3030,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230322',`time`='020301',`v1`=-1.292,`v2`=0.025,`v3`=-0.953,`v4`=-0.023,`v5`=5.7,`t`=10.8,`h`=61.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000331000001g3030,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679421843 WHERE `imei` = '868922055643643' [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013231s ] [ 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' , '230322' , '020301' , -1.292 , 0.025 , -0.953 , -0.023 , 5.7 , 10.8 , 61.8 , 229 , '4600485905031420000099m9990000000331000001g3030,N,00E000=-00.000' , 0 , 0 , 1679421843 , 1679421843) [ RunTime:0.001178s ] --------------------------------------------------------------- [ 2023-03-22T02:04:03+08:00 ] 111.55.139.252 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230322&time=020301&v1=-00.202&v2=+00.001&v3=-00.001&v4=-00.019&v5=05.9&t=+11.1&h=64.2&rssi=+227&ccid=4600485905031430000099m9990000000026000000g2370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230322',`time`='020301',`v1`=-0.202,`v2`=0.001,`v3`=-0.001,`v4`=-0.019,`v5`=5.9,`t`=11.1,`h`=64.2,`rssi`=227,`ccid`='4600485905031430000099m9990000000026000000g2370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679421843 WHERE `imei` = '868922055644013' [ RunTime:0.000514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010699s ] [ 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' , '230322' , '020301' , -0.202 , 0.001 , -0.001 , -0.019 , 5.9 , 11.1 , 64.2 , 227 , '4600485905031430000099m9990000000026000000g2370,N,00E000=-00.000' , 0 , 0 , 1679421843 , 1679421843) [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-03-22T02:32:23+08:00 ] 218.204.252.154 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011165s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-03-22T02:32:25+08:00 ] 218.204.252.154 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679423543&v1=0.028084&v2=0.562951&v3=0.028595&v4=0.028023&v5=12.420000&t=13.199821&h=42.713684&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002256s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679423543,`v1`=0.028084,`v2`=0.562951,`v3`=0.028595,`v4`=0.028023,`v5`=12.42,`t`=13.199821,`h`=42.713684,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679423545 WHERE `imei` = '868922056976109' [ RunTime:0.000591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010627s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679423543 , 0.028084 , 0.562951 , 0.028595 , 0.028023 , 12.42 , 13.199821 , 42.713684 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679423545) [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2023-03-22T06:02:51+08:00 ] 117.132.198.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002059s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-03-22T06:02:59+08:00 ] 117.132.198.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230322&time=060201&v1=-01.153&v2=+00.020&v3=-00.979&v4=-00.525&v5=05.7&t=+09.2&h=80.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.207&a2=01.209&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001998s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011203s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230322',`time`='060201',`v1`=-1.153,`v2`=0.02,`v3`=-0.979,`v4`=-0.525,`v5`=5.7,`t`=9.2,`h`=80.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.207,`a2`=1.209,`update_time`=1679436179 WHERE `imei` = '868922055684076' [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011510s ] [ 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' , '230322' , '060201' , -1.153 , 0.02 , -0.979 , -0.525 , 5.7 , 9.2 , 80.9 , 227 , '460044618415249' , -0 , 0.207 , 1.209 , 1679436179 , 1679436179) [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-03-22T14:03:55+08:00 ] 39.144.6.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001285s ] --------------------------------------------------------------- [ 2023-03-22T14:03:55+08:00 ] 39.144.14.164 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009410s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2023-03-22T14:04:04+08:00 ] 39.144.6.227 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230322&time=140301&v1=-01.288&v2=+00.057&v3=-00.974&v4=-00.024&v5=05.7&t=+10.7&h=61.7&rssi=+231&ccid=4600485905031420000099m9990000000307000001g2980,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010261s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230322',`time`='140301',`v1`=-1.288,`v2`=0.057,`v3`=-0.974,`v4`=-0.024,`v5`=5.7,`t`=10.7,`h`=61.7,`rssi`=231,`ccid`='4600485905031420000099m9990000000307000001g2980,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679465044 WHERE `imei` = '868922055643643' [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015404s ] [ 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' , '230322' , '140301' , -1.288 , 0.057 , -0.974 , -0.024 , 5.7 , 10.7 , 61.7 , 231 , '4600485905031420000099m9990000000307000001g2980,N,00E000=-00.000' , 0 , 0 , 1679465044 , 1679465044) [ RunTime:0.001197s ] --------------------------------------------------------------- [ 2023-03-22T14:04:04+08:00 ] 39.144.14.164 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230322&time=140301&v1=-00.191&v2=+00.002&v3=-00.111&v4=-00.017&v5=05.9&t=+10.7&h=64.1&rssi=+225&ccid=4600485905031430000099m9990000000010000000g2060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230322',`time`='140301',`v1`=-0.191,`v2`=0.002,`v3`=-0.111,`v4`=-0.017,`v5`=5.9,`t`=10.7,`h`=64.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000010000000g2060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679465044 WHERE `imei` = '868922055644013' [ RunTime:0.000512s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010658s ] [ 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' , '230322' , '140301' , -0.191 , 0.002 , -0.111 , -0.017 , 5.9 , 10.7 , 64.1 , 225 , '4600485905031430000099m9990000000010000000g2060,N,00E000=-00.000' , 0 , 0 , 1679465044 , 1679465044) [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-03-22T14:32:24+08:00 ] 218.204.253.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000841s ] --------------------------------------------------------------- [ 2023-03-22T14:32:26+08:00 ] 218.204.253.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679466744&v1=0.028445&v2=1.019403&v3=0.028505&v4=0.024953&v5=12.420000&t=14.036380&h=42.828125&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010197s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679466744,`v1`=0.028445,`v2`=1.019403,`v3`=0.028505,`v4`=0.024953,`v5`=12.42,`t`=14.03638,`h`=42.828125,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679466746 WHERE `imei` = '868922056976109' [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011570s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679466744 , 0.028445 , 1.019403 , 0.028505 , 0.024953 , 12.42 , 14.03638 , 42.828125 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679466746) [ RunTime:0.000784s ]