--------------------------------------------------------------- [ 2023-03-23T02:03:55+08:00 ] 223.104.254.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.004287s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001410s ] --------------------------------------------------------------- [ 2023-03-23T02:03:55+08:00 ] 218.204.253.80 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-03-23T02:04:04+08:00 ] 223.104.254.75 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230323&time=020301&v1=-00.190&v2=+00.001&v3=-00.080&v4=-00.018&v5=05.9&t=+08.2&h=64.6&rssi=+223&ccid=4600485905031430000099m9990000000025000000g2040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009478s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230323',`time`='020301',`v1`=-0.19,`v2`=0.001,`v3`=-0.08,`v4`=-0.018,`v5`=5.9,`t`=8.2,`h`=64.6,`rssi`=223,`ccid`='4600485905031430000099m9990000000025000000g2040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679508244 WHERE `imei` = '868922055644013' [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013253s ] [ 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' , '230323' , '020301' , -0.19 , 0.001 , -0.08 , -0.018 , 5.9 , 8.2 , 64.6 , 223 , '4600485905031430000099m9990000000025000000g2040,N,00E000=-00.000' , 0 , 0 , 1679508244 , 1679508244) [ RunTime:0.001208s ] --------------------------------------------------------------- [ 2023-03-23T02:04:04+08:00 ] 218.204.253.80 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230323&time=020301&v1=-01.290&v2=+00.021&v3=-00.974&v4=-00.024&v5=05.7&t=+08.0&h=62.3&rssi=+228&ccid=4600485905031420000099m9990000000308000001g3010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002922s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010701s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230323',`time`='020301',`v1`=-1.29,`v2`=0.021,`v3`=-0.974,`v4`=-0.024,`v5`=5.7,`t`=8,`h`=62.3,`rssi`=228,`ccid`='4600485905031420000099m9990000000308000001g3010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679508244 WHERE `imei` = '868922055643643' [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009647s ] [ 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' , '230323' , '020301' , -1.29 , 0.021 , -0.974 , -0.024 , 5.7 , 8 , 62.3 , 228 , '4600485905031420000099m9990000000308000001g3010,N,00E000=-00.000' , 0 , 0 , 1679508244 , 1679508244) [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2023-03-23T02:32:27+08:00 ] 111.55.139.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012294s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-03-23T02:32:28+08:00 ] 111.55.139.104 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679509947&v1=0.028144&v2=0.663295&v3=0.028595&v4=0.027903&v5=12.420000&t=12.663567&h=43.324036&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010843s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679509947,`v1`=0.028144,`v2`=0.663295,`v3`=0.028595,`v4`=0.027903,`v5`=12.42,`t`=12.663567,`h`=43.324036,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679509948 WHERE `imei` = '868922056976109' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011885s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679509947 , 0.028144 , 0.663295 , 0.028595 , 0.027903 , 12.42 , 12.663567 , 43.324036 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679509948) [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-03-23T06:02:50+08:00 ] 111.55.136.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012850s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000803s ] --------------------------------------------------------------- [ 2023-03-23T06:02:59+08:00 ] 111.55.136.72 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230323&time=060201&v1=-01.209&v2=+00.020&v3=-01.034&v4=-00.571&v5=05.7&t=+07.2&h=80.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.208&a2=01.246&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009323s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000750s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230323',`time`='060201',`v1`=-1.209,`v2`=0.02,`v3`=-1.034,`v4`=-0.571,`v5`=5.7,`t`=7.2,`h`=80.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.208,`a2`=1.246,`update_time`=1679522579 WHERE `imei` = '868922055684076' [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012508s ] [ 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' , '230323' , '060201' , -1.209 , 0.02 , -1.034 , -0.571 , 5.7 , 7.2 , 80.9 , 228 , '460044618415249' , -0 , 0.208 , 1.246 , 1679522579 , 1679522579) [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-03-23T14:03:55+08:00 ] 39.144.6.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011247s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-03-23T14:03:55+08:00 ] 39.144.14.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001769s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009329s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-03-23T14:04:03+08:00 ] 39.144.6.21 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230323&time=140301&v1=-00.196&v2=+00.001&v3=+00.020&v4=-00.018&v5=06.0&t=+18.9&h=63.5&rssi=+223&ccid=4600485905031430000099m9990000000038000000g2300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230323',`time`='140301',`v1`=-0.196,`v2`=0.001,`v3`=0.02,`v4`=-0.018,`v5`=6,`t`=18.9,`h`=63.5,`rssi`=223,`ccid`='4600485905031430000099m9990000000038000000g2300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679551443 WHERE `imei` = '868922055644013' [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012721s ] [ 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' , '230323' , '140301' , -0.196 , 0.001 , 0.02 , -0.018 , 6 , 18.9 , 63.5 , 223 , '4600485905031430000099m9990000000038000000g2300,N,00E000=-00.000' , 0 , 0 , 1679551443 , 1679551443) [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-03-23T14:04:04+08:00 ] 39.144.14.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230323&time=140301&v1=-01.292&v2=+00.058&v3=-00.960&v4=-00.023&v5=05.7&t=+17.0&h=60.7&rssi=+228&ccid=4600485905031420000099m9990000000322000001g3030,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011069s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230323',`time`='140301',`v1`=-1.292,`v2`=0.058,`v3`=-0.96,`v4`=-0.023,`v5`=5.7,`t`=17,`h`=60.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000322000001g3030,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679551444 WHERE `imei` = '868922055643643' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010579s ] [ 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' , '230323' , '140301' , -1.292 , 0.058 , -0.96 , -0.023 , 5.7 , 17 , 60.7 , 228 , '4600485905031420000099m9990000000322000001g3030,N,00E000=-00.000' , 0 , 0 , 1679551444 , 1679551444) [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2023-03-23T14:32:23+08:00 ] 117.132.197.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.002426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012992s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-03-23T14:32:25+08:00 ] 117.132.197.125 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679553143&v1=0.028144&v2=0.494316&v3=0.029017&v4=0.028023&v5=12.420000&t=17.296808&h=43.034119&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679553143,`v1`=0.028144,`v2`=0.494316,`v3`=0.029017,`v4`=0.028023,`v5`=12.42,`t`=17.296808,`h`=43.034119,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679553144 WHERE `imei` = '868922056976109' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011500s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679553143 , 0.028144 , 0.494316 , 0.029017 , 0.028023 , 12.42 , 17.296808 , 43.034119 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679553144) [ RunTime:0.000596s ]