--------------------------------------------------------------- [ 2023-07-03T00:14:23+08:00 ] 218.204.252.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011325s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-07-03T00:14:25+08:00 ] 218.204.252.42 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1688314463&v1=0.008037&v2=0.014395&v3=0.006833&v4=-0.015923&v5=12.420000&t=27.689428&h=81.478638&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002030s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009943s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1688314463,`v1`=0.008037,`v2`=0.014395,`v3`=0.006833,`v4`=-0.015923,`v5`=12.42,`t`=27.689428,`h`=81.478638,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1688314465 WHERE `imei` = '868922055644021' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010531s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1688314463 , 0.008037 , 0.014395 , 0.006833 , -0.015923 , 12.42 , 27.689428 , 81.478638 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1688314465) [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-07-03T00:34:03+08:00 ] 39.144.16.238 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002533s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016245s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-07-03T00:34:04+08:00 ] 39.144.16.238 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1688315643&v1=0.021462&v2=0.012830&v3=0.019385&v4=-0.006171&v5=12.240000&t=27.700153&h=78.861755&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185942,35.986256&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001590s ] 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` = '868922055680850' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1688315643,`v1`=0.021462,`v2`=0.01283,`v3`=0.019385,`v4`=-0.006171,`v5`=12.24,`t`=27.700153,`h`=78.861755,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185942,35.986256',`update_time`=1688315644 WHERE `imei` = '868922055680850' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010766s ] [ 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' , 1688315643 , 0.021462 , 0.01283 , 0.019385 , -0.006171 , 12.24 , 27.700153 , 78.861755 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.185942,35.986256' , 1688315644) [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2023-07-03T02:03:54+08:00 ] 39.144.5.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2023-07-03T02:03:55+08:00 ] 39.144.16.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001170s ] --------------------------------------------------------------- [ 2023-07-03T02:04:02+08:00 ] 39.144.5.94 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230703&time=020301&v1=-01.370&v2=+00.015&v3=-01.083&v4=-00.030&v5=06.2&t=+24.6&h=60.0&rssi=+228&ccid=4600485905031420000099m9990000000292000001g3760,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.011382s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230703',`time`='020301',`v1`=-1.37,`v2`=0.015,`v3`=-1.083,`v4`=-0.03,`v5`=6.2,`t`=24.6,`h`=60,`rssi`=228,`ccid`='4600485905031420000099m9990000000292000001g3760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688321042 WHERE `imei` = '868922055643643' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010871s ] [ 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' , '230703' , '020301' , -1.37 , 0.015 , -1.083 , -0.03 , 6.2 , 24.6 , 60 , 228 , '4600485905031420000099m9990000000292000001g3760,N,00E000=-00.000' , 0 , 0 , 1688321042 , 1688321042) [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2023-07-03T02:04:03+08:00 ] 39.144.16.192 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230703&time=020301&v1=-00.035&v2=+00.001&v3=+00.016&v4=+00.094&v5=06.0&t=+24.5&h=63.4&rssi=+222&ccid=4600485905031430000099m9990000000070000000g0790,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.010724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230703',`time`='020301',`v1`=-0.035,`v2`=0.001,`v3`=0.016,`v4`=0.094,`v5`=6,`t`=24.5,`h`=63.4,`rssi`=222,`ccid`='4600485905031430000099m9990000000070000000g0790,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688321043 WHERE `imei` = '868922055644013' [ RunTime:0.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011108s ] [ 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' , '230703' , '020301' , -0.035 , 0.001 , 0.016 , 0.094 , 6 , 24.5 , 63.4 , 222 , '4600485905031430000099m9990000000070000000g0790,N,00E000=-00.000' , 0 , 0 , 1688321043 , 1688321043) [ RunTime:0.000510s ] --------------------------------------------------------------- [ 2023-07-03T02:12:51+08:00 ] 111.55.136.111 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002316s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012237s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2023-07-03T02:12:59+08:00 ] 111.55.136.111 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230703&time=021201&v1=-01.195&v2=+00.009&v3=-01.097&v4=-00.605&v5=06.0&t=+23.0&h=77.4&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.119&a2=01.233&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010036s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000971s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230703',`time`='021201',`v1`=-1.195,`v2`=0.009,`v3`=-1.097,`v4`=-0.605,`v5`=6,`t`=23,`h`=77.4,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.119,`a2`=1.233,`update_time`=1688321579 WHERE `imei` = '868922055684076' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009903s ] [ 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' , '230703' , '021201' , -1.195 , 0.009 , -1.097 , -0.605 , 6 , 23 , 77.4 , 227 , '460044618415249' , -0 , 0.119 , 1.233 , 1688321579 , 1688321579) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-07-03T11:53:28+08:00 ] 117.132.192.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013499s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000801s ] --------------------------------------------------------------- [ 2023-07-03T11:53:29+08:00 ] 117.132.192.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1688356408&v1=0.030672&v2=0.016376&v3=0.041839&v4=0.001415&v5=12.240000&t=27.131723&h=79.472107&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002321s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000777s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1688356408,`v1`=0.030672,`v2`=0.016376,`v3`=0.041839,`v4`=0.001415,`v5`=12.24,`t`=27.131723,`h`=79.472107,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1688356409 WHERE `imei` = '868922055678110' [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012311s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1688356408 , 0.030672 , 0.016376 , 0.041839 , 0.001415 , 12.24 , 27.131723 , 79.472107 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1688356409) [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-07-03T13:25:38+08:00 ] 124.129.68.88 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002397s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013650s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001798s ] --------------------------------------------------------------- [ 2023-07-03T13:25:39+08:00 ] 124.129.68.88 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010940s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000954s ] --------------------------------------------------------------- [ 2023-07-03T13:25:53+08:00 ] 124.129.68.88 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010687s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2023-07-03T13:25:55+08:00 ] 124.129.68.88 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011232s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000539s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-07-03T13:25:59+08:00 ] 124.129.68.88 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009443s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-07-03T14:03:54+08:00 ] 39.144.15.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010977s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-07-03T14:03:54+08:00 ] 39.144.15.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001918s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012221s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2023-07-03T14:04:02+08:00 ] 39.144.15.175 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230703&time=140301&v1=-01.364&v2=+00.035&v3=-01.072&v4=-00.030&v5=06.4&t=+33.7&h=56.3&rssi=+224&ccid=4600485905031420000099m9990000000296000001g3700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.011134s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230703',`time`='140301',`v1`=-1.364,`v2`=0.035,`v3`=-1.072,`v4`=-0.03,`v5`=6.4,`t`=33.7,`h`=56.3,`rssi`=224,`ccid`='4600485905031420000099m9990000000296000001g3700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688364242 WHERE `imei` = '868922055643643' [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011346s ] [ 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' , '230703' , '140301' , -1.364 , 0.035 , -1.072 , -0.03 , 6.4 , 33.7 , 56.3 , 224 , '4600485905031420000099m9990000000296000001g3700,N,00E000=-00.000' , 0 , 0 , 1688364242 , 1688364242) [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-07-03T14:04:03+08:00 ] 39.144.15.124 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230703&time=140301&v1=+00.086&v2=+00.001&v3=+00.137&v4=+00.138&v5=06.0&t=+31.8&h=60.5&rssi=+222&ccid=4600485905031430000099m9990000000063000000g0400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001762s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010854s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230703',`time`='140301',`v1`=0.086,`v2`=0.001,`v3`=0.137,`v4`=0.138,`v5`=6,`t`=31.8,`h`=60.5,`rssi`=222,`ccid`='4600485905031430000099m9990000000063000000g0400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1688364243 WHERE `imei` = '868922055644013' [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010930s ] [ 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' , '230703' , '140301' , 0.086 , 0.001 , 0.137 , 0.138 , 6 , 31.8 , 60.5 , 222 , '4600485905031430000099m9990000000063000000g0400,N,00E000=-00.000' , 0 , 0 , 1688364243 , 1688364243) [ RunTime:0.000878s ] --------------------------------------------------------------- [ 2023-07-03T15:20:22+08:00 ] 39.144.8.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012492s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-07-03T15:20:24+08:00 ] 39.144.8.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1688368822&v1=0.017067&v2=0.014603&v3=0.015893&v4=-0.011649&v5=12.240000&t=27.496376&h=78.617615&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1688368822,`v1`=0.017067,`v2`=0.014603,`v3`=0.015893,`v4`=-0.011649,`v5`=12.24,`t`=27.496376,`h`=78.617615,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1688368824 WHERE `imei` = '868922055684548' [ RunTime:0.000633s ] [ 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` , `update_time`) VALUES ('868922055684548' , 1688368822 , 0.017067 , 0.014603 , 0.015893 , -0.011649 , 12.24 , 27.496376 , 78.617615 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1688368824) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-07-03T17:31:24+08:00 ] 117.132.197.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011196s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-07-03T17:31:25+08:00 ] 117.132.197.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1688376684&v1=0.018331&v2=0.014082&v3=0.019234&v4=-0.000271&v5=12.240000&t=27.421301&h=79.350037&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184885,35.985272&end=$ [ 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.010779s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1688376684,`v1`=0.018331,`v2`=0.014082,`v3`=0.019234,`v4`=-0.000271,`v5`=12.24,`t`=27.421301,`h`=79.350037,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184885,35.985272',`update_time`=1688376685 WHERE `imei` = '868922055647586' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010802s ] [ 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' , 1688376684 , 0.018331 , 0.014082 , 0.019234 , -0.000271 , 12.24 , 27.421301 , 79.350037 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.184885,35.985272' , 1688376685) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-07-03T18:12:24+08:00 ] 39.144.8.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011555s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-07-03T18:12:25+08:00 ] 39.144.8.53 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1688379144&v1=0.027662&v2=0.012517&v3=0.033020&v4=0.015803&v5=12.240000&t=27.560728&h=77.206177&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184696,35.985877&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1688379144,`v1`=0.027662,`v2`=0.012517,`v3`=0.03302,`v4`=0.015803,`v5`=12.24,`t`=27.560728,`h`=77.206177,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184696,35.985877',`update_time`=1688379145 WHERE `imei` = '868922056976208' [ RunTime:0.000755s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012089s ] [ 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' , 1688379144 , 0.027662 , 0.012517 , 0.03302 , 0.015803 , 12.24 , 27.560728 , 77.206177 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184696,35.985877' , 1688379145) [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-07-03T18:20:21+08:00 ] 111.55.141.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012206s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2023-07-03T18:20:22+08:00 ] 111.55.141.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1688379621&v1=0.020980&v2=0.013560&v3=0.018211&v4=-0.006773&v5=12.420000&t=27.560728&h=79.395813&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013231s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000935s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1688379621,`v1`=0.02098,`v2`=0.01356,`v3`=0.018211,`v4`=-0.006773,`v5`=12.42,`t`=27.560728,`h`=79.395813,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1688379622 WHERE `imei` = '868922055684209' [ RunTime:0.000908s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017642s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1688379621 , 0.02098 , 0.01356 , 0.018211 , -0.006773 , 12.42 , 27.560728 , 79.395813 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1688379622) [ RunTime:0.000942s ] --------------------------------------------------------------- [ 2023-07-03T18:45:19+08:00 ] 39.144.10.121 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002213s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010973s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-07-03T18:45:21+08:00 ] 39.144.10.121 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1688381119&v1=0.018933&v2=0.013873&v3=0.018211&v4=-0.004545&v5=12.420000&t=27.517828&h=84.438843&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001978s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012141s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1688381119,`v1`=0.018933,`v2`=0.013873,`v3`=0.018211,`v4`=-0.004545,`v5`=12.42,`t`=27.517828,`h`=84.438843,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1688381121 WHERE `imei` = '868922055683920' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010717s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1688381119 , 0.018933 , 0.013873 , 0.018211 , -0.004545 , 12.42 , 27.517828 , 84.438843 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1688381121) [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-07-03T21:26:56+08:00 ] 39.144.16.138 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.003512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012206s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2023-07-03T21:26:58+08:00 ] 39.144.16.138 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1688390816&v1=0.032057&v2=0.013873&v3=0.033411&v4=0.007977&v5=12.420000&t=27.260426&h=82.882446&rssi=30&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184896,35.985139&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.010230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1688390816,`v1`=0.032057,`v2`=0.013873,`v3`=0.033411,`v4`=0.007977,`v5`=12.42,`t`=27.260426,`h`=82.882446,`rssi`=30,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184896,35.985139',`update_time`=1688390818 WHERE `imei` = '868922055683912' [ RunTime:0.001241s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011436s ] [ 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' , 1688390816 , 0.032057 , 0.013873 , 0.033411 , 0.007977 , 12.42 , 27.260426 , 82.882446 , 30 , '898604650119C1053138' , '460048590503138' , -0 , '120.184896,35.985139' , 1688390818) [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2023-07-03T21:36:01+08:00 ] 117.132.193.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012923s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2023-07-03T21:36:02+08:00 ] 117.132.193.25 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1688391361&v1=0.019595&v2=0.014916&v3=0.019084&v4=-0.017127&v5=12.420000&t=27.185349&h=83.935303&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185395,35.987658&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1688391361,`v1`=0.019595,`v2`=0.014916,`v3`=0.019084,`v4`=-0.017127,`v5`=12.42,`t`=27.185349,`h`=83.935303,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185395,35.987658',`update_time`=1688391362 WHERE `imei` = '868922055683771' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009595s ] [ 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' , 1688391361 , 0.019595 , 0.014916 , 0.019084 , -0.017127 , 12.42 , 27.185349 , 83.935303 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.185395,35.987658' , 1688391362) [ RunTime:0.000590s ]