--------------------------------------------------------------- [ 2023-05-16T02:03:54+08:00 ] 39.144.1.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014292s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2023-05-16T02:03:55+08:00 ] 39.144.10.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001684s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011291s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-05-16T02:04:03+08:00 ] 39.144.1.144 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230516&time=020301&v1=-01.373&v2=+00.015&v3=-01.020&v4=-00.040&v5=06.2&t=+22.9&h=60.5&rssi=+229&ccid=4600485905031420000099m9990000000355000001g3810,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010835s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230516',`time`='020301',`v1`=-1.373,`v2`=0.015,`v3`=-1.02,`v4`=-0.04,`v5`=6.2,`t`=22.9,`h`=60.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000355000001g3810,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684173843 WHERE `imei` = '868922055643643' [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012205s ] [ 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' , '230516' , '020301' , -1.373 , 0.015 , -1.02 , -0.04 , 6.2 , 22.9 , 60.5 , 229 , '4600485905031420000099m9990000000355000001g3810,N,00E000=-00.000' , 0 , 0 , 1684173843 , 1684173843) [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2023-05-16T02:04:03+08:00 ] 39.144.10.49 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230516&time=020301&v1=-00.260&v2=+00.001&v3=+00.016&v4=-00.008&v5=06.0&t=+23.9&h=62.9&rssi=+225&ccid=4600485905031430000099m9990000000039000000g2820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009314s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230516',`time`='020301',`v1`=-0.26,`v2`=0.001,`v3`=0.016,`v4`=-0.008,`v5`=6,`t`=23.9,`h`=62.9,`rssi`=225,`ccid`='4600485905031430000099m9990000000039000000g2820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684173843 WHERE `imei` = '868922055644013' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009788s ] [ 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' , '230516' , '020301' , -0.26 , 0.001 , 0.016 , -0.008 , 6 , 23.9 , 62.9 , 225 , '4600485905031430000099m9990000000039000000g2820,N,00E000=-00.000' , 0 , 0 , 1684173843 , 1684173843) [ RunTime:0.000818s ] --------------------------------------------------------------- [ 2023-05-16T11:05:27+08:00 ] 218.204.253.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013273s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.003142s ] --------------------------------------------------------------- [ 2023-05-16T11:05:29+08:00 ] 218.204.253.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1684206327&v1=0.029589&v2=0.013560&v3=0.028445&v4=0.001355&v5=12.420000&t=24.782927&h=77.839417&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1684206327,`v1`=0.029589,`v2`=0.01356,`v3`=0.028445,`v4`=0.001355,`v5`=12.42,`t`=24.782927,`h`=77.839417,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1684206329 WHERE `imei` = '868922055678110' [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011983s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1684206327 , 0.029589 , 0.01356 , 0.028445 , 0.001355 , 12.42 , 24.782927 , 77.839417 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1684206329) [ RunTime:0.001149s ] --------------------------------------------------------------- [ 2023-05-16T12:27:02+08:00 ] 124.129.66.114 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011505s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2023-05-16T12:27:12+08:00 ] 124.129.66.114 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011796s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000922s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001094s ] --------------------------------------------------------------- [ 2023-05-16T12:27:39+08:00 ] 124.129.66.114 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002101s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010702s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000843s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001030s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001052s ] --------------------------------------------------------------- [ 2023-05-16T12:28:02+08:00 ] 124.129.66.114 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.002222s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010687s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000510s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001197s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001106s ] --------------------------------------------------------------- [ 2023-05-16T13:44:52+08:00 ] 124.129.66.114 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003057s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011977s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-05-16T13:44:58+08:00 ] 124.129.66.114 GET /admin/shelves/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001720s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_shelves` [ RunTime:0.013571s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_shelves` LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000643s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC [ RunTime:0.000518s ] --------------------------------------------------------------- [ 2023-05-16T13:45:05+08:00 ] 124.129.66.114 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010222s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000361s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001003s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2023-05-16T13:45:07+08:00 ] 124.129.66.114 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008326s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2023-05-16T13:51:39+08:00 ] 124.129.66.114 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002303s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011035s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-05-16T13:51:45+08:00 ] 124.129.66.114 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001743s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008945s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000363s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.001325s ] --------------------------------------------------------------- [ 2023-05-16T13:51:49+08:00 ] 124.129.66.114 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002110s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009566s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2023-05-16T14:03:54+08:00 ] 117.132.195.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002230s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-05-16T14:03:54+08:00 ] 39.144.14.230 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001872s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009481s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000660s ] --------------------------------------------------------------- [ 2023-05-16T14:04:03+08:00 ] 117.132.195.19 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230516&time=140301&v1=-01.372&v2=+00.030&v3=-00.983&v4=-00.039&v5=06.4&t=+39.8&h=54.8&rssi=+229&ccid=4600485905031420000099m9990000000391000001g3790,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.009240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230516',`time`='140301',`v1`=-1.372,`v2`=0.03,`v3`=-0.983,`v4`=-0.039,`v5`=6.4,`t`=39.8,`h`=54.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000391000001g3790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684217043 WHERE `imei` = '868922055643643' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014915s ] [ 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' , '230516' , '140301' , -1.372 , 0.03 , -0.983 , -0.039 , 6.4 , 39.8 , 54.8 , 229 , '4600485905031420000099m9990000000391000001g3790,N,00E000=-00.000' , 0 , 0 , 1684217043 , 1684217043) [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2023-05-16T14:04:03+08:00 ] 39.144.14.230 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230516&time=140301&v1=-00.242&v2=+00.001&v3=+00.021&v4=-00.006&v5=06.2&t=+37.3&h=60.0&rssi=+224&ccid=4600485905031430000099m9990000000044000000g2620,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011071s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230516',`time`='140301',`v1`=-0.242,`v2`=0.001,`v3`=0.021,`v4`=-0.006,`v5`=6.2,`t`=37.3,`h`=60,`rssi`=224,`ccid`='4600485905031430000099m9990000000044000000g2620,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684217043 WHERE `imei` = '868922055644013' [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012859s ] [ 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' , '230516' , '140301' , -0.242 , 0.001 , 0.021 , -0.006 , 6.2 , 37.3 , 60 , 224 , '4600485905031430000099m9990000000044000000g2620,N,00E000=-00.000' , 0 , 0 , 1684217043 , 1684217043) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-05-16T14:32:22+08:00 ] 39.144.3.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009977s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000748s ] --------------------------------------------------------------- [ 2023-05-16T14:32:24+08:00 ] 39.144.3.73 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1684218742&v1=0.016826&v2=0.013977&v3=0.014207&v4=-0.011709&v5=12.420000&t=25.115406&h=75.993103&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002504s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009579s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1684218742,`v1`=0.016826,`v2`=0.013977,`v3`=0.014207,`v4`=-0.011709,`v5`=12.42,`t`=25.115406,`h`=75.993103,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1684218744 WHERE `imei` = '868922055684548' [ RunTime:0.000909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011232s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1684218742 , 0.016826 , 0.013977 , 0.014207 , -0.011709 , 12.42 , 25.115406 , 75.993103 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1684218744) [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-05-16T16:41:00+08:00 ] 124.129.66.114 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009499s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-05-16T16:49:56+08:00 ] 111.55.138.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2023-05-16T16:49:57+08:00 ] 111.55.138.159 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1684226996&v1=0.018993&v2=0.013977&v3=0.016013&v4=-0.000632&v5=12.240000&t=25.437159&h=79.914612&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184863,35.985634&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010672s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1684226996,`v1`=0.018993,`v2`=0.013977,`v3`=0.016013,`v4`=-0.000632,`v5`=12.24,`t`=25.437159,`h`=79.914612,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184863,35.985634',`update_time`=1684226997 WHERE `imei` = '868922055647586' [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009591s ] [ 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' , 1684226996 , 0.018993 , 0.013977 , 0.016013 , -0.000632 , 12.24 , 25.437159 , 79.914612 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.184863,35.985634' , 1684226997) [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2023-05-16T17:27:24+08:00 ] 117.132.196.184 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011359s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2023-05-16T17:27:25+08:00 ] 117.132.196.184 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1684229244&v1=0.027722&v2=0.012830&v3=0.026669&v4=0.015742&v5=12.240000&t=25.265556&h=76.679749&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185168,35.985928&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1684229244,`v1`=0.027722,`v2`=0.01283,`v3`=0.026669,`v4`=0.015742,`v5`=12.24,`t`=25.265556,`h`=76.679749,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185168,35.985928',`update_time`=1684229245 WHERE `imei` = '868922056976208' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011242s ] [ 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' , 1684229244 , 0.027722 , 0.01283 , 0.026669 , 0.015742 , 12.24 , 25.265556 , 76.679749 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.185168,35.985928' , 1684229245) [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-05-16T17:32:21+08:00 ] 39.144.11.246 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.003043s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-05-16T17:32:23+08:00 ] 39.144.11.246 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1684229541&v1=0.019475&v2=0.015229&v3=0.017127&v4=-0.007013&v5=12.420000&t=25.340631&h=78.411621&rssi=28&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010543s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1684229541,`v1`=0.019475,`v2`=0.015229,`v3`=0.017127,`v4`=-0.007013,`v5`=12.42,`t`=25.340631,`h`=78.411621,`rssi`=28,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1684229543 WHERE `imei` = '868922055684209' [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010500s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1684229541 , 0.019475 , 0.015229 , 0.017127 , -0.007013 , 12.42 , 25.340631 , 78.411621 , 28 , '898604650119C1078511' , '460048590708511' , -0 , 1684229543) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2023-05-16T17:57:20+08:00 ] 117.132.195.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012623s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000892s ] --------------------------------------------------------------- [ 2023-05-16T17:57:21+08:00 ] 117.132.195.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1684231040&v1=0.018933&v2=0.013664&v3=0.016164&v4=-0.004786&v5=12.420000&t=25.136856&h=80.563110&rssi=27&ccid=89860426102071188500&imsi=460044618415250&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.011742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1684231040,`v1`=0.018933,`v2`=0.013664,`v3`=0.016164,`v4`=-0.004786,`v5`=12.42,`t`=25.136856,`h`=80.56311,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1684231041 WHERE `imei` = '868922055683920' [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012257s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1684231040 , 0.018933 , 0.013664 , 0.016164 , -0.004786 , 12.42 , 25.136856 , 80.56311 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1684231041) [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2023-05-16T18:15:50+08:00 ] 39.144.15.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013375s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2023-05-16T18:15:59+08:00 ] 39.144.15.141 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230516&time=181501&v1=-00.158&v2=+00.007&v3=-00.083&v4=+00.391&v5=06.0&t=+31.9&h=79.8&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.140&a2=00.265&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011307s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230516',`time`='181501',`v1`=-0.158,`v2`=0.007,`v3`=-0.083,`v4`=0.391,`v5`=6,`t`=31.9,`h`=79.8,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.14,`a2`=0.265,`update_time`=1684232159 WHERE `imei` = '868922055684076' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010215s ] [ 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' , '230516' , '181501' , -0.158 , 0.007 , -0.083 , 0.391 , 6 , 31.9 , 79.8 , 227 , '460044618415249' , -0 , 0.14 , 0.265 , 1684232159 , 1684232159) [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-05-16T20:45:04+08:00 ] 111.55.140.238 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012636s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000805s ] --------------------------------------------------------------- [ 2023-05-16T20:45:05+08:00 ] 111.55.140.238 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1684241104&v1=0.031997&v2=0.013977&v3=0.028987&v4=0.008338&v5=12.420000&t=24.450449&h=79.472107&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.183891,35.985503&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011217s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1684241104,`v1`=0.031997,`v2`=0.013977,`v3`=0.028987,`v4`=0.008338,`v5`=12.42,`t`=24.450449,`h`=79.472107,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.183891,35.985503',`update_time`=1684241105 WHERE `imei` = '868922055683912' [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012274s ] [ 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' , 1684241104 , 0.031997 , 0.013977 , 0.028987 , 0.008338 , 12.42 , 24.450449 , 79.472107 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.183891,35.985503' , 1684241105) [ RunTime:0.001309s ] --------------------------------------------------------------- [ 2023-05-16T20:49:24+08:00 ] 39.144.15.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002328s ] 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` = '868922055683771' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-05-16T20:49:25+08:00 ] 39.144.15.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1684241364&v1=0.019174&v2=0.014290&v3=0.016375&v4=-0.017308&v5=12.420000&t=24.450449&h=80.502075&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012508s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1684241364,`v1`=0.019174,`v2`=0.01429,`v3`=0.016375,`v4`=-0.017308,`v5`=12.42,`t`=24.450449,`h`=80.502075,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1684241365 WHERE `imei` = '868922055683771' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010409s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1684241364 , 0.019174 , 0.01429 , 0.016375 , -0.017308 , 12.42 , 24.450449 , 80.502075 , 17 , '898604650119C1053136' , '460048590503136' , -0 , 1684241365) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-05-16T23:27:23+08:00 ] 39.144.10.248 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002562s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012870s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-05-16T23:27:24+08:00 ] 39.144.10.248 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1684250843&v1=0.007134&v2=0.014603&v3=0.005087&v4=-0.015682&v5=12.420000&t=24.300299&h=78.861755&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000777s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1684250843,`v1`=0.007134,`v2`=0.014603,`v3`=0.005087,`v4`=-0.015682,`v5`=12.42,`t`=24.300299,`h`=78.861755,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1684250844 WHERE `imei` = '868922055644021' [ RunTime:0.000755s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011078s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1684250843 , 0.007134 , 0.014603 , 0.005087 , -0.015682 , 12.42 , 24.300299 , 78.861755 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1684250844) [ RunTime:0.001316s ] --------------------------------------------------------------- [ 2023-05-16T23:48:24+08:00 ] 117.132.197.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002439s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-05-16T23:48:25+08:00 ] 117.132.197.60 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1684252104&v1=0.021341&v2=0.013247&v3=0.018452&v4=-0.006652&v5=12.420000&t=24.235947&h=78.350586&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185512,35.984388&end=$ [ 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.010352s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1684252104,`v1`=0.021341,`v2`=0.013247,`v3`=0.018452,`v4`=-0.006652,`v5`=12.42,`t`=24.235947,`h`=78.350586,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185512,35.984388',`update_time`=1684252105 WHERE `imei` = '868922055680850' [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011557s ] [ 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' , 1684252104 , 0.021341 , 0.013247 , 0.018452 , -0.006652 , 12.42 , 24.235947 , 78.350586 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.185512,35.984388' , 1684252105) [ RunTime:0.001425s ]