--------------------------------------------------------------- [ 2023-04-15T02:03:54+08:00 ] 117.132.197.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012214s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001292s ] --------------------------------------------------------------- [ 2023-04-15T02:03:55+08:00 ] 218.204.252.187 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010729s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-04-15T02:04:03+08:00 ] 117.132.197.100 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230415&time=020301&v1=-01.340&v2=+00.018&v3=-01.004&v4=-00.024&v5=05.7&t=+10.1&h=61.9&rssi=+229&ccid=4600485905031420000099m9990000000337000001g3500,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001262s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230415',`time`='020301',`v1`=-1.34,`v2`=0.018,`v3`=-1.004,`v4`=-0.024,`v5`=5.7,`t`=10.1,`h`=61.9,`rssi`=229,`ccid`='4600485905031420000099m9990000000337000001g3500,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681495443 WHERE `imei` = '868922055643643' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011296s ] [ 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' , '230415' , '020301' , -1.34 , 0.018 , -1.004 , -0.024 , 5.7 , 10.1 , 61.9 , 229 , '4600485905031420000099m9990000000337000001g3500,N,00E000=-00.000' , 0 , 0 , 1681495443 , 1681495443) [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2023-04-15T02:04:04+08:00 ] 218.204.252.187 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230415&time=020301&v1=-00.262&v2=+00.001&v3=-00.243&v4=-00.024&v5=05.9&t=+10.7&h=64.9&rssi=+226&ccid=4600485905031430000099m9990000000068000000g2670,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230415',`time`='020301',`v1`=-0.262,`v2`=0.001,`v3`=-0.243,`v4`=-0.024,`v5`=5.9,`t`=10.7,`h`=64.9,`rssi`=226,`ccid`='4600485905031430000099m9990000000068000000g2670,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681495444 WHERE `imei` = '868922055644013' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011129s ] [ 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' , '230415' , '020301' , -0.262 , 0.001 , -0.243 , -0.024 , 5.9 , 10.7 , 64.9 , 226 , '4600485905031430000099m9990000000068000000g2670,N,00E000=-00.000' , 0 , 0 , 1681495444 , 1681495444) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-04-15T08:54:17+08:00 ] 27.193.87.152 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.012307s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000765s ] --------------------------------------------------------------- [ 2023-04-15T08:54:22+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012877s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001020s ] --------------------------------------------------------------- [ 2023-04-15T09:04:22+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002315s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009756s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000838s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001020s ] --------------------------------------------------------------- [ 2023-04-15T09:04:24+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002112s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010827s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000384s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001056s ] --------------------------------------------------------------- [ 2023-04-15T09:10:35+08:00 ] 112.224.69.207 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009829s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-04-15T09:10:37+08:00 ] 112.224.69.207 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681521035&v1=0.057642&v2=0.020236&v3=0.057161&v4=0.056498&v5=12.420000&t=20.857542&h=50.915283&rssi=36&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184971,35.985812&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000780s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681521035,`v1`=0.057642,`v2`=0.020236,`v3`=0.057161,`v4`=0.056498,`v5`=12.42,`t`=20.857542,`h`=50.915283,`rssi`=36,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184971,35.985812',`update_time`=1681521037 WHERE `imei` = '863412049967592' [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009570s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681521035 , 0.057642 , 0.020236 , 0.057161 , 0.056498 , 12.42 , 20.857542 , 50.915283 , 36 , '89860118803392574452' , '460015788115318' , -0 , '120.184971,35.985812' , 1681521037) [ RunTime:0.001318s ] --------------------------------------------------------------- [ 2023-04-15T09:10:38+08:00 ] 112.224.69.207 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1575516091&v1=0.058124&v2=0.019506&v3=0.057582&v4=0.056799&v5=12.600000&t=21.533222&h=49.580139&rssi=36&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017226s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1575516091,`v1`=0.058124,`v2`=0.019506,`v3`=0.057582,`v4`=0.056799,`v5`=12.6,`t`=21.533222,`h`=49.580139,`rssi`=36,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681521038 WHERE `imei` = '863412049967592' [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010577s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1575516091 , 0.058124 , 0.019506 , 0.057582 , 0.056799 , 12.6 , 21.533222 , 49.580139 , 36 , '89860118803392574452' , '460015788115318' , -0 , 1681521038) [ RunTime:0.000489s ] --------------------------------------------------------------- [ 2023-04-15T09:10:50+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010207s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000423s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000796s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001000s ] --------------------------------------------------------------- [ 2023-04-15T09:11:10+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010189s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001092s ] --------------------------------------------------------------- [ 2023-04-15T09:29:19+08:00 ] 112.224.69.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ 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.010339s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2023-04-15T09:29:21+08:00 ] 112.224.69.104 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681522159&v1=0.057221&v2=0.065088&v3=0.057070&v4=0.056860&v5=12.420000&t=21.672649&h=48.481506&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001856s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008483s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681522159,`v1`=0.057221,`v2`=0.065088,`v3`=0.05707,`v4`=0.05686,`v5`=12.42,`t`=21.672649,`h`=48.481506,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681522161 WHERE `imei` = '863412049967592' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011406s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681522159 , 0.057221 , 0.065088 , 0.05707 , 0.05686 , 12.42 , 21.672649 , 48.481506 , 26 , '89860118803392574452' , '460015788115318' , -0 , 1681522161) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-04-15T09:29:22+08:00 ] 112.224.69.104 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=4294938496&v1=0.057401&v2=1.360804&v3=0.056980&v4=0.056318&v5=-4.500000&t=19.656330&h=50.587219&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001914s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010367s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=4294938496,`v1`=0.057401,`v2`=1.360804,`v3`=0.05698,`v4`=0.056318,`v5`=-4.5,`t`=19.65633,`h`=50.587219,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681522162 WHERE `imei` = '863412049967592' [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010628s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 4294938496 , 0.057401 , 1.360804 , 0.05698 , 0.056318 , -4.5 , 19.65633 , 50.587219 , 26 , '89860118803392574452' , '460015788115318' , -0 , 1681522162) [ RunTime:0.000464s ] --------------------------------------------------------------- [ 2023-04-15T09:29:52+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009500s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001094s ] --------------------------------------------------------------- [ 2023-04-15T09:29:57+08:00 ] 27.193.87.152 GET /admin/show/index.html [ 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.009175s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000948s ] --------------------------------------------------------------- [ 2023-04-15T09:33:09+08:00 ] 112.224.74.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ 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.011917s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2023-04-15T09:33:10+08:00 ] 112.224.74.64 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681522389&v1=0.057702&v2=0.063628&v3=0.057281&v4=0.055896&v5=12.420000&t=21.179295&h=43.858093&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001927s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000850s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681522389,`v1`=0.057702,`v2`=0.063628,`v3`=0.057281,`v4`=0.055896,`v5`=12.42,`t`=21.179295,`h`=43.858093,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681522390 WHERE `imei` = '863412049967592' [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011599s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681522389 , 0.057702 , 0.063628 , 0.057281 , 0.055896 , 12.42 , 21.179295 , 43.858093 , 26 , '89860118803392574452' , '460015788115318' , -0 , 1681522390) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-04-15T09:35:11+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010172s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000815s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001047s ] --------------------------------------------------------------- [ 2023-04-15T09:35:30+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010161s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000775s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001781s ] --------------------------------------------------------------- [ 2023-04-15T09:35:34+08:00 ] 112.224.75.48 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ 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.012433s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-04-15T09:35:35+08:00 ] 112.224.75.48 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681522534&v1=0.057642&v2=0.070512&v3=0.057251&v4=0.056679&v5=12.420000&t=22.037302&h=42.652649&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184517,35.986956&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011488s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681522534,`v1`=0.057642,`v2`=0.070512,`v3`=0.057251,`v4`=0.056679,`v5`=12.42,`t`=22.037302,`h`=42.652649,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184517,35.986956',`update_time`=1681522535 WHERE `imei` = '863412049967592' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010836s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681522534 , 0.057642 , 0.070512 , 0.057251 , 0.056679 , 12.42 , 22.037302 , 42.652649 , 26 , '89860118803392574452' , '460015788115318' , -0 , '120.184517,35.986956' , 1681522535) [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2023-04-15T09:35:39+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010091s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000789s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000927s ] --------------------------------------------------------------- [ 2023-04-15T09:36:06+08:00 ] 27.193.87.152 GET /admin/map/index.html [ 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.010673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001107s ] --------------------------------------------------------------- [ 2023-04-15T09:41:06+08:00 ] 112.224.70.61 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001855s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010567s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2023-04-15T09:41:18+08:00 ] 112.224.70.61 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681522866&v1=0.057281&v2=0.054866&v3=0.057010&v4=0.056318&v5=12.240000&t=20.332012&h=42.988342&rssi=46&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.185073,35.985305&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002074s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013613s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000730s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681522866,`v1`=0.057281,`v2`=0.054866,`v3`=0.05701,`v4`=0.056318,`v5`=12.24,`t`=20.332012,`h`=42.988342,`rssi`=46,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.185073,35.985305',`update_time`=1681522878 WHERE `imei` = '863412049967592' [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011836s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681522866 , 0.057281 , 0.054866 , 0.05701 , 0.056318 , 12.24 , 20.332012 , 42.988342 , 46 , '89860118803392574452' , '460015788115318' , -0 , '120.185073,35.985305' , 1681522878) [ RunTime:0.000553s ] --------------------------------------------------------------- [ 2023-04-15T09:42:58+08:00 ] 112.224.69.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001727s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-04-15T09:43:00+08:00 ] 112.224.69.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681522978&v1=0.057823&v2=0.060707&v3=0.057492&v4=0.056679&v5=12.420000&t=22.595007&h=42.019409&rssi=16&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010727s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681522978,`v1`=0.057823,`v2`=0.060707,`v3`=0.057492,`v4`=0.056679,`v5`=12.42,`t`=22.595007,`h`=42.019409,`rssi`=16,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681522980 WHERE `imei` = '863412049967592' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011779s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681522978 , 0.057823 , 0.060707 , 0.057492 , 0.056679 , 12.42 , 22.595007 , 42.019409 , 16 , '89860118803392574452' , '460015788115318' , -0 , 1681522980) [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-04-15T09:43:02+08:00 ] 112.224.69.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681522866&v1=0.057281&v2=0.054866&v3=0.057010&v4=0.056318&v5=15.120000&t=20.332012&h=42.988342&rssi=16&ccid=89860118803392574452&imsi=460015788115318&v6=-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.008801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681522866,`v1`=0.057281,`v2`=0.054866,`v3`=0.05701,`v4`=0.056318,`v5`=15.12,`t`=20.332012,`h`=42.988342,`rssi`=16,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681522982 WHERE `imei` = '863412049967592' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011536s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681522866 , 0.057281 , 0.054866 , 0.05701 , 0.056318 , 15.12 , 20.332012 , 42.988342 , 16 , '89860118803392574452' , '460015788115318' , -0 , 1681522982) [ RunTime:0.000495s ] --------------------------------------------------------------- [ 2023-04-15T09:43:17+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009145s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001078s ] --------------------------------------------------------------- [ 2023-04-15T09:45:04+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001235s ] --------------------------------------------------------------- [ 2023-04-15T09:50:18+08:00 ] 27.193.87.152 GET /admin/show/index.html [ 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.012296s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001050s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001128s ] --------------------------------------------------------------- [ 2023-04-15T09:50:54+08:00 ] 27.193.87.152 GET /admin/show/edit/id/54.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.022713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011797s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001189s ] --------------------------------------------------------------- [ 2023-04-15T10:00:32+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012133s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-04-15T10:00:38+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001767s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010044s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000983s ] --------------------------------------------------------------- [ 2023-04-15T10:05:09+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011144s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000357s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000981s ] --------------------------------------------------------------- [ 2023-04-15T10:05:11+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009828s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000369s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000954s ] --------------------------------------------------------------- [ 2023-04-15T10:05:21+08:00 ] 27.193.87.152 GET /admin/show/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_show` [ RunTime:0.010677s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000330s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000743s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000939s ] --------------------------------------------------------------- [ 2023-04-15T10:05:22+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001742s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010429s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000363s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000985s ] --------------------------------------------------------------- [ 2023-04-15T10:05:23+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011650s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000368s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000785s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000957s ] --------------------------------------------------------------- [ 2023-04-15T10:05:24+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000785s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000941s ] --------------------------------------------------------------- [ 2023-04-15T10:05:24+08:00 ] 112.224.70.110 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644062 [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009688s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644062' LIMIT 1 [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2023-04-15T10:05:25+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010126s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000402s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000947s ] --------------------------------------------------------------- [ 2023-04-15T10:05:25+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001944s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011017s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000818s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001000s ] --------------------------------------------------------------- [ 2023-04-15T10:05:30+08:00 ] 112.224.70.110 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644062&create_time=1681524324&v1=0.025555&v2=0.072911&v3=0.021522&v4=0.003100&v5=12.600000&t=20.010260&h=35.542053&rssi=12&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.185604,35.984938&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010679s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644062' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644062',`create_time`=1681524324,`v1`=0.025555,`v2`=0.072911,`v3`=0.021522,`v4`=0.0031,`v5`=12.6,`t`=20.01026,`h`=35.542053,`rssi`=12,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.185604,35.984938',`update_time`=1681524330 WHERE `imei` = '868922055644062' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012059s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055644062' , 1681524324 , 0.025555 , 0.072911 , 0.021522 , 0.0031 , 12.6 , 20.01026 , 35.542053 , 12 , '89860118803392574452' , '460015788115318' , -0 , '120.185604,35.984938' , 1681524330) [ RunTime:0.001207s ] --------------------------------------------------------------- [ 2023-04-15T10:05:32+08:00 ] 27.193.87.152 GET /admin/show/index.html [ 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.011174s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000421s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000847s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001038s ] --------------------------------------------------------------- [ 2023-04-15T10:05:34+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002456s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012265s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000411s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001064s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001153s ] --------------------------------------------------------------- [ 2023-04-15T10:05:51+08:00 ] 39.144.18.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010297s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2023-04-15T10:05:59+08:00 ] 39.144.18.85 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230415&time=100501&v1=-01.277&v2=+00.040&v3=-01.166&v4=-00.375&v5=06.0&t=+23.8&h=79.0&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.126&a2=01.291&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230415',`time`='100501',`v1`=-1.277,`v2`=0.04,`v3`=-1.166,`v4`=-0.375,`v5`=6,`t`=23.8,`h`=79,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.126,`a2`=1.291,`update_time`=1681524359 WHERE `imei` = '868922055684076' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010231s ] [ 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' , '230415' , '100501' , -1.277 , 0.04 , -1.166 , -0.375 , 6 , 23.8 , 79 , 227 , '460044618415249' , -0 , 0.126 , 1.291 , 1681524359 , 1681524359) [ RunTime:0.001067s ] --------------------------------------------------------------- [ 2023-04-15T10:08:16+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001977s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008279s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000764s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000942s ] --------------------------------------------------------------- [ 2023-04-15T10:29:35+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011027s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001099s ] --------------------------------------------------------------- [ 2023-04-15T10:37:32+08:00 ] 112.224.71.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.003543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011870s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000852s ] --------------------------------------------------------------- [ 2023-04-15T10:37:33+08:00 ] 112.224.71.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681526252&v1=0.057341&v2=0.242412&v3=0.057040&v4=0.056318&v5=12.600000&t=19.280952&h=40.386719&rssi=20&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184820,35.985018&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010413s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681526252,`v1`=0.057341,`v2`=0.242412,`v3`=0.05704,`v4`=0.056318,`v5`=12.6,`t`=19.280952,`h`=40.386719,`rssi`=20,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184820,35.985018',`update_time`=1681526253 WHERE `imei` = '863412049967592' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011662s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681526252 , 0.057341 , 0.242412 , 0.05704 , 0.056318 , 12.6 , 19.280952 , 40.386719 , 20 , '89860118803392574452' , '460015788115318' , -0 , '120.184820,35.985018' , 1681526253) [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2023-04-15T10:37:36+08:00 ] 112.224.71.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=4294938496&v1=0.057281&v2=0.129551&v3=0.057010&v4=0.056197&v5=12.780000&t=19.216602&h=40.058655&rssi=20&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010432s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=4294938496,`v1`=0.057281,`v2`=0.129551,`v3`=0.05701,`v4`=0.056197,`v5`=12.78,`t`=19.216602,`h`=40.058655,`rssi`=20,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681526256 WHERE `imei` = '863412049967592' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011477s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 4294938496 , 0.057281 , 0.129551 , 0.05701 , 0.056197 , 12.78 , 19.216602 , 40.058655 , 20 , '89860118803392574452' , '460015788115318' , -0 , 1681526256) [ RunTime:0.000517s ] --------------------------------------------------------------- [ 2023-04-15T10:37:37+08:00 ] 112.224.71.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=4294938496&v1=0.057341&v2=0.127673&v3=0.056980&v4=0.056378&v5=12.600000&t=19.591980&h=40.882629&rssi=20&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002229s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010948s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000744s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=4294938496,`v1`=0.057341,`v2`=0.127673,`v3`=0.05698,`v4`=0.056378,`v5`=12.6,`t`=19.59198,`h`=40.882629,`rssi`=20,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681526257 WHERE `imei` = '863412049967592' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010801s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 4294938496 , 0.057341 , 0.127673 , 0.05698 , 0.056378 , 12.6 , 19.59198 , 40.882629 , 20 , '89860118803392574452' , '460015788115318' , -0 , 1681526257) [ RunTime:0.000485s ] --------------------------------------------------------------- [ 2023-04-15T10:37:44+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001416s ] 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` ORDER BY `id` DESC [ RunTime:0.001127s ] --------------------------------------------------------------- [ 2023-04-15T10:41:34+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010288s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000416s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000995s ] --------------------------------------------------------------- [ 2023-04-15T10:42:28+08:00 ] 112.224.70.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2023-04-15T10:42:29+08:00 ] 112.224.70.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681526548&v1=0.057462&v2=0.157923&v3=0.057010&v4=0.056378&v5=12.600000&t=19.827932&h=40.112061&rssi=21&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184833,35.985126&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002060s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681526548,`v1`=0.057462,`v2`=0.157923,`v3`=0.05701,`v4`=0.056378,`v5`=12.6,`t`=19.827932,`h`=40.112061,`rssi`=21,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184833,35.985126',`update_time`=1681526549 WHERE `imei` = '863412049967592' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011812s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681526548 , 0.057462 , 0.157923 , 0.05701 , 0.056378 , 12.6 , 19.827932 , 40.112061 , 21 , '89860118803392574452' , '460015788115318' , -0 , '120.184833,35.985126' , 1681526549) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-04-15T10:42:32+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010518s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000427s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000808s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001010s ] --------------------------------------------------------------- [ 2023-04-15T10:44:50+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009224s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000861s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001163s ] --------------------------------------------------------------- [ 2023-04-15T10:44:53+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011072s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000419s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000861s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001016s ] --------------------------------------------------------------- [ 2023-04-15T10:44:54+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009679s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000809s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-04-15T10:45:05+08:00 ] 112.224.74.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-04-15T10:45:07+08:00 ] 112.224.74.132 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681526705&v1=0.057642&v2=0.154272&v3=0.057161&v4=0.056438&v5=12.600000&t=20.718115&h=38.113159&rssi=20&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184875,35.985221&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009080s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681526705,`v1`=0.057642,`v2`=0.154272,`v3`=0.057161,`v4`=0.056438,`v5`=12.6,`t`=20.718115,`h`=38.113159,`rssi`=20,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184875,35.985221',`update_time`=1681526707 WHERE `imei` = '863412049967592' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010895s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681526705 , 0.057642 , 0.154272 , 0.057161 , 0.056438 , 12.6 , 20.718115 , 38.113159 , 20 , '89860118803392574452' , '460015788115318' , -0 , '120.184875,35.985221' , 1681526707) [ RunTime:0.000504s ] --------------------------------------------------------------- [ 2023-04-15T10:45:09+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001510s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014301s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000831s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001054s ] --------------------------------------------------------------- [ 2023-04-15T10:52:14+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011406s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001488s ] --------------------------------------------------------------- [ 2023-04-15T10:52:16+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002025s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009685s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000761s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001158s ] --------------------------------------------------------------- [ 2023-04-15T10:52:25+08:00 ] 112.224.67.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010141s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2023-04-15T10:52:26+08:00 ] 112.224.67.67 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681527145&v1=0.056679&v2=0.061542&v3=-0.002017&v4=0.056980&v5=12.600000&t=19.913733&h=40.028137&rssi=20&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184903,35.984826&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002367s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011287s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681527145,`v1`=0.056679,`v2`=0.061542,`v3`=-0.002017,`v4`=0.05698,`v5`=12.6,`t`=19.913733,`h`=40.028137,`rssi`=20,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184903,35.984826',`update_time`=1681527146 WHERE `imei` = '863412049967592' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011208s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681527145 , 0.056679 , 0.061542 , -0.002017 , 0.05698 , 12.6 , 19.913733 , 40.028137 , 20 , '89860118803392574452' , '460015788115318' , -0 , '120.184903,35.984826' , 1681527146) [ RunTime:0.000776s ] --------------------------------------------------------------- [ 2023-04-15T10:53:21+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010576s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000898s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001014s ] --------------------------------------------------------------- [ 2023-04-15T10:54:33+08:00 ] 27.193.87.152 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001081s ] --------------------------------------------------------------- [ 2023-04-15T10:55:06+08:00 ] 112.224.75.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010821s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-04-15T10:55:08+08:00 ] 112.224.75.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681527306&v1=0.056860&v2=0.049129&v3=-0.002017&v4=0.056739&v5=12.600000&t=20.632315&h=38.487000&rssi=20&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184803,35.985121&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.011052s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681527306,`v1`=0.05686,`v2`=0.049129,`v3`=-0.002017,`v4`=0.056739,`v5`=12.6,`t`=20.632315,`h`=38.487,`rssi`=20,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184803,35.985121',`update_time`=1681527308 WHERE `imei` = '863412049967592' [ RunTime:0.001392s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010714s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('863412049967592' , 1681527306 , 0.05686 , 0.049129 , -0.002017 , 0.056739 , 12.6 , 20.632315 , 38.487 , 20 , '89860118803392574452' , '460015788115318' , -0 , '120.184803,35.985121' , 1681527308) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-04-15T10:55:27+08:00 ] 27.193.87.152 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001992s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009879s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000820s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000965s ] --------------------------------------------------------------- [ 2023-04-15T10:55:35+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002889s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000908s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011294s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003140s ] --------------------------------------------------------------- [ 2023-04-15T11:16:20+08:00 ] 112.224.75.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.003004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-04-15T11:16:21+08:00 ] 112.224.75.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681528580&v1=0.057040&v2=64.420807&v3=-0.002017&v4=1.075094&v5=13.140000&t=17.983215&h=46.322388&rssi=15&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010910s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681528580,`v1`=0.05704,`v2`=64.420807,`v3`=-0.002017,`v4`=1.075094,`v5`=13.14,`t`=17.983215,`h`=46.322388,`rssi`=15,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681528581 WHERE `imei` = '863412049967592' [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012132s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681528580 , 0.05704 , 64.420807 , -0.002017 , 1.075094 , 13.14 , 17.983215 , 46.322388 , 15 , '89860118803392574452' , '460015788115318' , -0 , 1681528581) [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-04-15T11:16:30+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009356s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000805s ] --------------------------------------------------------------- [ 2023-04-15T11:19:13+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011597s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016858s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000959s ] --------------------------------------------------------------- [ 2023-04-15T11:19:14+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001647s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009218s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2023-04-15T11:19:15+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001966s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011302s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012081s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000832s ] --------------------------------------------------------------- [ 2023-04-15T11:19:16+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001489s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009328s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011415s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000465s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2023-04-15T11:19:18+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002509s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009884s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010581s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000534s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001391s ] --------------------------------------------------------------- [ 2023-04-15T11:19:19+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009941s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010657s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2023-04-15T11:19:20+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002001s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010588s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010800s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000794s ] --------------------------------------------------------------- [ 2023-04-15T11:19:20+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001967s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011766s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010325s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000555s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2023-04-15T11:19:21+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011895s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000843s ] --------------------------------------------------------------- [ 2023-04-15T11:19:22+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002059s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010231s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011070s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000827s ] --------------------------------------------------------------- [ 2023-04-15T11:19:23+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010176s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000453s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2023-04-15T11:19:25+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002125s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011046s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010805s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000891s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000907s ] --------------------------------------------------------------- [ 2023-04-15T11:19:27+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001781s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.001450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2023-04-15T11:19:28+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002167s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010310s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011505s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000888s ] --------------------------------------------------------------- [ 2023-04-15T11:19:28+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009765s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000795s ] --------------------------------------------------------------- [ 2023-04-15T11:19:39+08:00 ] 112.224.75.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001850s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010908s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-04-15T11:19:40+08:00 ] 112.224.75.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681528779&v1=1.073890&v2=0.030771&v3=-0.002017&v4=0.057161&v5=13.140000&t=19.495455&h=42.805237&rssi=11&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681528779,`v1`=1.07389,`v2`=0.030771,`v3`=-0.002017,`v4`=0.057161,`v5`=13.14,`t`=19.495455,`h`=42.805237,`rssi`=11,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681528780 WHERE `imei` = '863412049967592' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011705s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681528779 , 1.07389 , 0.030771 , -0.002017 , 0.057161 , 13.14 , 19.495455 , 42.805237 , 11 , '89860118803392574452' , '460015788115318' , -0 , 1681528780) [ RunTime:0.000498s ] --------------------------------------------------------------- [ 2023-04-15T11:22:04+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012165s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012736s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001067s ] --------------------------------------------------------------- [ 2023-04-15T11:22:34+08:00 ] 112.224.67.160 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002203s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009655s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000724s ] --------------------------------------------------------------- [ 2023-04-15T11:22:35+08:00 ] 112.224.67.160 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681528954&v1=1.074793&v2=0.033274&v3=-0.002017&v4=0.057642&v5=12.960000&t=20.439262&h=40.905518&rssi=76&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681528954,`v1`=1.074793,`v2`=0.033274,`v3`=-0.002017,`v4`=0.057642,`v5`=12.96,`t`=20.439262,`h`=40.905518,`rssi`=76,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681528955 WHERE `imei` = '863412049967592' [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009998s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681528954 , 1.074793 , 0.033274 , -0.002017 , 0.057642 , 12.96 , 20.439262 , 40.905518 , 76 , '89860118803392574452' , '460015788115318' , -0 , 1681528955) [ RunTime:0.000643s ] --------------------------------------------------------------- [ 2023-04-15T11:22:41+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010000s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012175s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000514s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2023-04-15T11:46:39+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002362s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011348s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000955s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011325s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000910s ] --------------------------------------------------------------- [ 2023-04-15T11:46:40+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010582s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009825s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-04-15T11:46:42+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014791s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.001052s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015371s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001313s ] --------------------------------------------------------------- [ 2023-04-15T11:46:45+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009490s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011653s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000499s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000876s ] --------------------------------------------------------------- [ 2023-04-15T11:46:47+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010189s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011355s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2023-04-15T11:46:49+08:00 ] 112.224.70.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001708s ] 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` = '863412049967592' LIMIT 1 [ RunTime:0.000933s ] --------------------------------------------------------------- [ 2023-04-15T11:46:50+08:00 ] 112.224.70.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681530409&v1=0.056799&v2=88.481560&v3=0.056739&v4=1.076539&v5=13.140000&t=17.757988&h=49.122375&rssi=12&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010727s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.001248s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681530409,`v1`=0.056799,`v2`=88.48156,`v3`=0.056739,`v4`=1.076539,`v5`=13.14,`t`=17.757988,`h`=49.122375,`rssi`=12,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681530410 WHERE `imei` = '863412049967592' [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010378s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681530409 , 0.056799 , 88.48156 , 0.056739 , 1.076539 , 13.14 , 17.757988 , 49.122375 , 12 , '89860118803392574452' , '460015788115318' , -0 , 1681530410) [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-04-15T11:46:52+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ 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.009878s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.001409s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010163s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000887s ] --------------------------------------------------------------- [ 2023-04-15T11:46:54+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ 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.011769s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011931s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000917s ] --------------------------------------------------------------- [ 2023-04-15T11:49:04+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011172s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008770s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2023-04-15T11:49:07+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010348s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010336s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000894s ] --------------------------------------------------------------- [ 2023-04-15T11:49:11+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ 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.010844s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.001103s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011113s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001590s ] --------------------------------------------------------------- [ 2023-04-15T11:49:32+08:00 ] 112.224.75.251 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011547s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2023-04-15T11:49:34+08:00 ] 112.224.75.251 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681530572&v1=1.058780&v2=0.051007&v3=1.059472&v4=0.055656&v5=13.140000&t=19.602705&h=46.764893&rssi=12&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010264s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681530572,`v1`=1.05878,`v2`=0.051007,`v3`=1.059472,`v4`=0.055656,`v5`=13.14,`t`=19.602705,`h`=46.764893,`rssi`=12,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681530574 WHERE `imei` = '863412049967592' [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009923s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681530572 , 1.05878 , 0.051007 , 1.059472 , 0.055656 , 13.14 , 19.602705 , 46.764893 , 12 , '89860118803392574452' , '460015788115318' , -0 , 1681530574) [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2023-04-15T11:49:34+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002092s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010756s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000798s ] --------------------------------------------------------------- [ 2023-04-15T11:52:04+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008531s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010892s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000445s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000819s ] --------------------------------------------------------------- [ 2023-04-15T11:52:07+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014316s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012581s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000961s ] --------------------------------------------------------------- [ 2023-04-15T11:52:08+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012429s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011189s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000535s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000861s ] --------------------------------------------------------------- [ 2023-04-15T11:52:14+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010415s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010749s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000998s ] --------------------------------------------------------------- [ 2023-04-15T11:52:17+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ 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.015001s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.001573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015192s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001436s ] --------------------------------------------------------------- [ 2023-04-15T11:52:18+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009953s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000933s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011906s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001169s ] --------------------------------------------------------------- [ 2023-04-15T11:52:19+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009210s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011102s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2023-04-15T11:52:21+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002194s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011005s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019019s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000857s ] --------------------------------------------------------------- [ 2023-04-15T11:52:22+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002335s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010198s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010515s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2023-04-15T11:52:23+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001781s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010975s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010849s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2023-04-15T11:52:34+08:00 ] 112.224.69.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001884s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009619s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2023-04-15T11:52:35+08:00 ] 112.224.69.22 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1681530754&v1=1.077081&v2=0.063002&v3=0.063602&v4=0.057582&v5=13.140000&t=20.299837&h=45.292419&rssi=11&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011149s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1681530754,`v1`=1.077081,`v2`=0.063002,`v3`=0.063602,`v4`=0.057582,`v5`=13.14,`t`=20.299837,`h`=45.292419,`rssi`=11,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1681530755 WHERE `imei` = '863412049967592' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010771s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1681530754 , 1.077081 , 0.063002 , 0.063602 , 0.057582 , 13.14 , 20.299837 , 45.292419 , 11 , '89860118803392574452' , '460015788115318' , -0 , 1681530755) [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2023-04-15T11:52:59+08:00 ] 27.193.87.152 GET /admin/show/read/id/54/imei/863412049967592.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001680s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 54 LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010061s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '863412049967592' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000870s ] --------------------------------------------------------------- [ 2023-04-15T14:03:55+08:00 ] 39.144.5.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012067s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2023-04-15T14:03:56+08:00 ] 111.55.139.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011634s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-04-15T14:04:03+08:00 ] 39.144.5.112 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230415&time=140301&v1=-01.334&v2=+00.034&v3=-01.000&v4=-00.024&v5=05.7&t=+25.6&h=57.9&rssi=+228&ccid=4600485905031420000099m9990000000334000001g3430,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002246s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009423s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230415',`time`='140301',`v1`=-1.334,`v2`=0.034,`v3`=-1,`v4`=-0.024,`v5`=5.7,`t`=25.6,`h`=57.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000334000001g3430,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681538643 WHERE `imei` = '868922055643643' [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011244s ] [ 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' , '230415' , '140301' , -1.334 , 0.034 , -1 , -0.024 , 5.7 , 25.6 , 57.9 , 228 , '4600485905031420000099m9990000000334000001g3430,N,00E000=-00.000' , 0 , 0 , 1681538643 , 1681538643) [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-04-15T14:04:03+08:00 ] 111.55.139.104 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230415&time=140301&v1=-00.252&v2=+00.002&v3=+00.018&v4=-00.022&v5=06.0&t=+28.8&h=61.7&rssi=+227&ccid=4600485905031430000099m9990000000044000000g2700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001957s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230415',`time`='140301',`v1`=-0.252,`v2`=0.002,`v3`=0.018,`v4`=-0.022,`v5`=6,`t`=28.8,`h`=61.7,`rssi`=227,`ccid`='4600485905031430000099m9990000000044000000g2700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681538643 WHERE `imei` = '868922055644013' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011396s ] [ 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' , '230415' , '140301' , -0.252 , 0.002 , 0.018 , -0.022 , 6 , 28.8 , 61.7 , 227 , '4600485905031430000099m9990000000044000000g2700,N,00E000=-00.000' , 0 , 0 , 1681538643 , 1681538643) [ RunTime:0.000572s ]