--------------------------------------------------------------- [ 2023-06-16T00:18:24+08:00 ] 39.144.7.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012936s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000758s ] --------------------------------------------------------------- [ 2023-06-16T00:18:25+08:00 ] 39.144.7.252 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1686845904&v1=0.021401&v2=0.013351&v3=0.018512&v4=-0.006291&v5=12.240000&t=25.362083&h=79.083008&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185149,35.987336&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010761s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1686845904,`v1`=0.021401,`v2`=0.013351,`v3`=0.018512,`v4`=-0.006291,`v5`=12.24,`t`=25.362083,`h`=79.083008,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185149,35.987336',`update_time`=1686845905 WHERE `imei` = '868922055680850' [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011638s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1686845904 , 0.021401 , 0.013351 , 0.018512 , -0.006291 , 12.24 , 25.362083 , 79.083008 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.185149,35.987336' , 1686845905) [ RunTime:0.001263s ] --------------------------------------------------------------- [ 2023-06-16T02:03:57+08:00 ] 117.132.191.225 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012225s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2023-06-16T02:03:58+08:00 ] 117.132.195.162 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001849s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011937s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-06-16T02:04:02+08:00 ] 117.132.191.225 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230616&time=020301&v1=-01.394&v2=+00.013&v3=-01.011&v4=-00.045&v5=06.2&t=+21.7&h=59.4&rssi=+227&ccid=4600485905031420000099m9990000000386000001g4010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010140s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230616',`time`='020301',`v1`=-1.394,`v2`=0.013,`v3`=-1.011,`v4`=-0.045,`v5`=6.2,`t`=21.7,`h`=59.4,`rssi`=227,`ccid`='4600485905031420000099m9990000000386000001g4010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686852242 WHERE `imei` = '868922055643643' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011226s ] [ 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' , '230616' , '020301' , -1.394 , 0.013 , -1.011 , -0.045 , 6.2 , 21.7 , 59.4 , 227 , '4600485905031420000099m9990000000386000001g4010,N,00E000=-00.000' , 0 , 0 , 1686852242 , 1686852242) [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-06-16T02:04:03+08:00 ] 117.132.195.162 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230616&time=020301&v1=-00.348&v2=+00.001&v3=-00.039&v4=-00.001&v5=06.0&t=+21.7&h=62.6&rssi=+222&ccid=4600485905031430000099m9990000000028000000g3620,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011065s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230616',`time`='020301',`v1`=-0.348,`v2`=0.001,`v3`=-0.039,`v4`=-0.001,`v5`=6,`t`=21.7,`h`=62.6,`rssi`=222,`ccid`='4600485905031430000099m9990000000028000000g3620,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686852243 WHERE `imei` = '868922055644013' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012379s ] [ 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' , '230616' , '020301' , -0.348 , 0.001 , -0.039 , -0.001 , 6 , 21.7 , 62.6 , 222 , '4600485905031430000099m9990000000028000000g3620,N,00E000=-00.000' , 0 , 0 , 1686852243 , 1686852243) [ RunTime:0.000576s ] --------------------------------------------------------------- [ 2023-06-16T11:36:28+08:00 ] 218.204.253.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002926s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014435s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001278s ] --------------------------------------------------------------- [ 2023-06-16T11:36:30+08:00 ] 218.204.253.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1686886588&v1=0.030431&v2=0.017107&v3=0.034736&v4=0.001415&v5=12.240000&t=26.230816&h=79.121155&rssi=86&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001699s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015093s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000684s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1686886588,`v1`=0.030431,`v2`=0.017107,`v3`=0.034736,`v4`=0.001415,`v5`=12.24,`t`=26.230816,`h`=79.121155,`rssi`=86,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1686886590 WHERE `imei` = '868922055678110' [ RunTime:0.000678s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019157s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1686886588 , 0.030431 , 0.017107 , 0.034736 , 0.001415 , 12.24 , 26.230816 , 79.121155 , 86 , '898604650119C1078513' , '460048590708513' , -0 , 1686886590) [ RunTime:0.002894s ] --------------------------------------------------------------- [ 2023-06-16T14:03:51+08:00 ] 39.144.18.81 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.013851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001338s ] --------------------------------------------------------------- [ 2023-06-16T14:03:52+08:00 ] 111.55.139.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001649s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010249s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-06-16T14:03:59+08:00 ] 39.144.18.81 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230616&time=140301&v1=-01.389&v2=+00.020&v3=-00.962&v4=-00.045&v5=06.4&t=+38.3&h=54.4&rssi=+230&ccid=4600485905031420000099m9990000000429000001g3950,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010358s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230616',`time`='140301',`v1`=-1.389,`v2`=0.02,`v3`=-0.962,`v4`=-0.045,`v5`=6.4,`t`=38.3,`h`=54.4,`rssi`=230,`ccid`='4600485905031420000099m9990000000429000001g3950,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686895439 WHERE `imei` = '868922055643643' [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014700s ] [ 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' , '230616' , '140301' , -1.389 , 0.02 , -0.962 , -0.045 , 6.4 , 38.3 , 54.4 , 230 , '4600485905031420000099m9990000000429000001g3950,N,00E000=-00.000' , 0 , 0 , 1686895439 , 1686895439) [ RunTime:0.001174s ] --------------------------------------------------------------- [ 2023-06-16T14:04:00+08:00 ] 111.55.139.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230616&time=140301&v1=-00.501&v2=+00.001&v3=+00.017&v4=+00.000&v5=06.0&t=+34.3&h=59.5&rssi=+222&ccid=4600485905031430000099m9990000000047000000g5240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002581s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011334s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230616',`time`='140301',`v1`=-0.501,`v2`=0.001,`v3`=0.017,`v4`=0,`v5`=6,`t`=34.3,`h`=59.5,`rssi`=222,`ccid`='4600485905031430000099m9990000000047000000g5240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1686895440 WHERE `imei` = '868922055644013' [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010996s ] [ 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' , '230616' , '140301' , -0.501 , 0.001 , 0.017 , 0 , 6 , 34.3 , 59.5 , 222 , '4600485905031430000099m9990000000047000000g5240,N,00E000=-00.000' , 0 , 0 , 1686895440 , 1686895440) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-06-16T15:03:24+08:00 ] 117.132.195.102 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012099s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-06-16T15:03:25+08:00 ] 117.132.195.102 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1686899004&v1=0.016886&v2=0.014499&v3=0.014839&v4=-0.011769&v5=12.420000&t=26.809971&h=77.900452&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001658s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011007s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1686899004,`v1`=0.016886,`v2`=0.014499,`v3`=0.014839,`v4`=-0.011769,`v5`=12.42,`t`=26.809971,`h`=77.900452,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1686899005 WHERE `imei` = '868922055684548' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012989s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1686899004 , 0.016886 , 0.014499 , 0.014839 , -0.011769 , 12.42 , 26.809971 , 77.900452 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1686899005) [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2023-06-16T17:15:07+08:00 ] 39.144.14.155 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.003997s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016413s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.001055s ] --------------------------------------------------------------- [ 2023-06-16T17:15:08+08:00 ] 39.144.14.155 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1686906907&v1=0.018391&v2=0.014395&v3=0.016645&v4=-0.000090&v5=12.420000&t=26.745621&h=79.266113&rssi=26&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184834,35.986415&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011229s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1686906907,`v1`=0.018391,`v2`=0.014395,`v3`=0.016645,`v4`=-9.0E-5,`v5`=12.42,`t`=26.745621,`h`=79.266113,`rssi`=26,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184834,35.986415',`update_time`=1686906908 WHERE `imei` = '868922055647586' [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012244s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1686906907 , 0.018391 , 0.014395 , 0.016645 , -9.0E-5 , 12.42 , 26.745621 , 79.266113 , 26 , '898604650119C1078512' , '460048590708512' , -0 , '120.184834,35.986415' , 1686906908) [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-06-16T17:55:16+08:00 ] 117.132.191.165 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-06-16T17:55:18+08:00 ] 117.132.191.165 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1686909316&v1=0.027421&v2=0.012413&v3=0.028084&v4=0.015682&v5=12.240000&t=26.531118&h=77.290100&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184971,35.985376&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1686909316,`v1`=0.027421,`v2`=0.012413,`v3`=0.028084,`v4`=0.015682,`v5`=12.24,`t`=26.531118,`h`=77.2901,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184971,35.985376',`update_time`=1686909318 WHERE `imei` = '868922056976208' [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012076s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1686909316 , 0.027421 , 0.012413 , 0.028084 , 0.015682 , 12.24 , 26.531118 , 77.2901 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184971,35.985376' , 1686909318) [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-06-16T18:03:20+08:00 ] 117.132.197.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002338s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010493s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001102s ] --------------------------------------------------------------- [ 2023-06-16T18:03:22+08:00 ] 117.132.197.34 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1686909800&v1=0.020860&v2=0.015751&v3=0.017037&v4=-0.006893&v5=12.420000&t=26.563293&h=79.411072&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.019664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001105s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1686909800,`v1`=0.02086,`v2`=0.015751,`v3`=0.017037,`v4`=-0.006893,`v5`=12.42,`t`=26.563293,`h`=79.411072,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1686909802 WHERE `imei` = '868922055684209' [ RunTime:0.000936s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015481s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1686909800 , 0.02086 , 0.015751 , 0.017037 , -0.006893 , 12.42 , 26.563293 , 79.411072 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1686909802) [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-06-16T18:28:21+08:00 ] 221.178.127.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002391s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011430s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-06-16T18:28:22+08:00 ] 221.178.127.124 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1686911301&v1=0.018993&v2=0.016376&v3=0.016555&v4=-0.004545&v5=12.420000&t=26.380966&h=83.508057&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010859s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1686911301,`v1`=0.018993,`v2`=0.016376,`v3`=0.016555,`v4`=-0.004545,`v5`=12.42,`t`=26.380966,`h`=83.508057,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1686911302 WHERE `imei` = '868922055683920' [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010827s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1686911301 , 0.018993 , 0.016376 , 0.016555 , -0.004545 , 12.42 , 26.380966 , 83.508057 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1686911302) [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-06-16T21:13:03+08:00 ] 39.144.4.167 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.003281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013298s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [ 2023-06-16T21:13:04+08:00 ] 39.144.4.167 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1686921183&v1=0.030371&v2=0.013664&v3=0.029258&v4=0.007916&v5=12.420000&t=25.984138&h=82.066101&rssi=19&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.185070,35.986606&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010487s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1686921183,`v1`=0.030371,`v2`=0.013664,`v3`=0.029258,`v4`=0.007916,`v5`=12.42,`t`=25.984138,`h`=82.066101,`rssi`=19,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.185070,35.986606',`update_time`=1686921184 WHERE `imei` = '868922055683912' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010616s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1686921183 , 0.030371 , 0.013664 , 0.029258 , 0.007916 , 12.42 , 25.984138 , 82.066101 , 19 , '898604650119C1053138' , '460048590503138' , -0 , '120.185070,35.986606' , 1686921184) [ RunTime:0.001223s ] --------------------------------------------------------------- [ 2023-06-16T21:20:24+08:00 ] 111.55.138.127 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011109s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2023-06-16T21:20:25+08:00 ] 111.55.138.127 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1686921624&v1=0.019415&v2=0.013456&v3=0.016405&v4=-0.017247&v5=12.420000&t=25.962688&h=83.004517&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.186523,35.986929&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002103s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012925s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1686921624,`v1`=0.019415,`v2`=0.013456,`v3`=0.016405,`v4`=-0.017247,`v5`=12.42,`t`=25.962688,`h`=83.004517,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.186523,35.986929',`update_time`=1686921625 WHERE `imei` = '868922055683771' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011797s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1686921624 , 0.019415 , 0.013456 , 0.016405 , -0.017247 , 12.42 , 25.962688 , 83.004517 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.186523,35.986929' , 1686921625) [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2023-06-16T22:08:51+08:00 ] 39.144.17.223 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ 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.013457s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000789s ] --------------------------------------------------------------- [ 2023-06-16T22:08:59+08:00 ] 39.144.17.223 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230616&time=220801&v1=-01.142&v2=+00.017&v3=-01.014&v4=-00.207&v5=06.0&t=+21.4&h=78.6&rssi=+226&imsi=460044618415249&v6=-00.000&a1=00.160&a2=01.206&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010927s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230616',`time`='220801',`v1`=-1.142,`v2`=0.017,`v3`=-1.014,`v4`=-0.207,`v5`=6,`t`=21.4,`h`=78.6,`rssi`=226,`imsi`='460044618415249',`v6`=-0,`a1`=0.16,`a2`=1.206,`update_time`=1686924539 WHERE `imei` = '868922055684076' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011245s ] [ 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' , '230616' , '220801' , -1.142 , 0.017 , -1.014 , -0.207 , 6 , 21.4 , 78.6 , 226 , '460044618415249' , -0 , 0.16 , 1.206 , 1686924539 , 1686924539) [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-06-16T23:58:24+08:00 ] 218.204.252.151 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002888s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-06-16T23:58:25+08:00 ] 218.204.252.151 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1686931104&v1=0.008037&v2=0.015751&v3=0.005358&v4=-0.015803&v5=12.420000&t=25.791086&h=81.028503&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001905s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011317s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1686931104,`v1`=0.008037,`v2`=0.015751,`v3`=0.005358,`v4`=-0.015803,`v5`=12.42,`t`=25.791086,`h`=81.028503,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1686931105 WHERE `imei` = '868922055644021' [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012118s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1686931104 , 0.008037 , 0.015751 , 0.005358 , -0.015803 , 12.42 , 25.791086 , 81.028503 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1686931105) [ RunTime:0.001275s ]