---------------------------------------------------------------
[ 2023-04-25T00:39:28+08:00 ] 112.224.69.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002219s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012670s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000749s ]
---------------------------------------------------------------
[ 2023-04-25T00:39:30+08:00 ] 112.224.69.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682354368&v1=0.031033&v2=0.014290&v3=0.026398&v4=0.001174&v5=12.420000&t=15.881096&h=48.916382&rssi=24&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001733s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009749s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682354368,`v1`=0.031033,`v2`=0.01429,`v3`=0.026398,`v4`=0.001174,`v5`=12.42,`t`=15.881096,`h`=48.916382,`rssi`=24,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1682354370 WHERE `imei` = '868922055678110' [ RunTime:0.000672s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011914s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682354368 , 0.031033 , 0.01429 , 0.026398 , 0.001174 , 12.42 , 15.881096 , 48.916382 , 24 , '89860118803392574452' , '460015788115318' , -0 , 1682354370) [ RunTime:0.000714s ]
---------------------------------------------------------------
[ 2023-04-25T02:03:55+08:00 ] 218.204.252.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.003345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010684s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-04-25T02:03:56+08:00 ] 39.144.11.240 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001911s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.018352s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000689s ]
---------------------------------------------------------------
[ 2023-04-25T02:04:03+08:00 ] 39.144.11.240 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230425&time=020301&v1=-01.332&v2=+00.017&v3=-00.980&v4=-00.030&v5=05.7&t=+10.3&h=60.8&rssi=+228&ccid=4600485905031420000099m9990000000354000001g3410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001776s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010080s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000666s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230425',`time`='020301',`v1`=-1.332,`v2`=0.017,`v3`=-0.98,`v4`=-0.03,`v5`=5.7,`t`=10.3,`h`=60.8,`rssi`=228,`ccid`='4600485905031420000099m9990000000354000001g3410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682359443 WHERE `imei` = '868922055643643' [ RunTime:0.000616s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012203s ]
[ 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' , '230425' , '020301' , -1.332 , 0.017 , -0.98 , -0.03 , 5.7 , 10.3 , 60.8 , 228 , '4600485905031420000099m9990000000354000001g3410,N,00E000=-00.000' , 0 , 0 , 1682359443 , 1682359443) [ RunTime:0.001386s ]
---------------------------------------------------------------
[ 2023-04-25T02:04:03+08:00 ] 218.204.252.114 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230425&time=020301&v1=-00.239&v2=+00.001&v3=+00.018&v4=-00.013&v5=05.9&t=+10.9&h=63.7&rssi=+225&ccid=4600485905031430000099m9990000000037000000g2580,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001638s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010221s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000629s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230425',`time`='020301',`v1`=-0.239,`v2`=0.001,`v3`=0.018,`v4`=-0.013,`v5`=5.9,`t`=10.9,`h`=63.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g2580,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682359443 WHERE `imei` = '868922055644013' [ RunTime:0.000529s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009287s ]
[ 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' , '230425' , '020301' , -0.239 , 0.001 , 0.018 , -0.013 , 5.9 , 10.9 , 63.7 , 225 , '4600485905031430000099m9990000000037000000g2580,N,00E000=-00.000' , 0 , 0 , 1682359443 , 1682359443) [ RunTime:0.001098s ]
---------------------------------------------------------------
[ 2023-04-25T04:40:02+08:00 ] 112.224.75.92 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002304s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011493s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000681s ]
---------------------------------------------------------------
[ 2023-04-25T04:40:04+08:00 ] 112.224.75.92 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682368802&v1=0.030973&v2=0.016272&v3=0.026368&v4=0.001054&v5=12.420000&t=15.484267&h=48.389954&rssi=24&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184452,35.986705&end=$
[ 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.012061s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000780s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682368802,`v1`=0.030973,`v2`=0.016272,`v3`=0.026368,`v4`=0.001054,`v5`=12.42,`t`=15.484267,`h`=48.389954,`rssi`=24,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184452,35.986705',`update_time`=1682368804 WHERE `imei` = '868922055678110' [ RunTime:0.000709s ]
[ 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 ('868922055678110' , 1682368802 , 0.030973 , 0.016272 , 0.026368 , 0.001054 , 12.42 , 15.484267 , 48.389954 , 24 , '89860118803392574452' , '460015788115318' , -0 , '120.184452,35.986705' , 1682368804) [ RunTime:0.000755s ]
---------------------------------------------------------------
[ 2023-04-25T05:59:45+08:00 ] 116.62.194.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002080s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012084s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000730s ]
---------------------------------------------------------------
[ 2023-04-25T06:00:26+08:00 ] 116.62.194.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.001772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011037s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000706s ]
---------------------------------------------------------------
[ 2023-04-25T06:00:26+08:00 ] 116.62.194.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010882s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000689s ]
---------------------------------------------------------------
[ 2023-04-25T08:24:24+08:00 ] 124.129.96.215 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.009924s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000577s ]
---------------------------------------------------------------
[ 2023-04-25T08:24:26+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010153s ]
[ 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.001086s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000920s ]
---------------------------------------------------------------
[ 2023-04-25T08:24:34+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010055s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000644s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012582s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001211s ]
---------------------------------------------------------------
[ 2023-04-25T08:24:43+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011221s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=480,`gps`='120.184452,35.986705',`username`='admin',`introduce`=' ',`update_time`=1682382283 WHERE `id` = 58 [ RunTime:0.000829s ]
---------------------------------------------------------------
[ 2023-04-25T08:24:44+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003041s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010688s ]
[ 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.000898s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001703s ]
---------------------------------------------------------------
[ 2023-04-25T08:25:00+08:00 ] 124.129.96.215 GET /admin/show/read/id/58/imei/868922055678110.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001955s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013079s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000740s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010074s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000724s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002273s ]
---------------------------------------------------------------
[ 2023-04-25T08:25:10+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011202s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000833s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000874s ]
---------------------------------------------------------------
[ 2023-04-25T08:25:39+08:00 ] 124.129.96.215 GET /admin/show/read/id/58/imei/868922055678110.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002077s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011654s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000670s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009278s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000503s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000860s ]
---------------------------------------------------------------
[ 2023-04-25T08:25:54+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002019s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010531s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000912s ]
---------------------------------------------------------------
[ 2023-04-25T08:41:25+08:00 ] 112.224.69.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012920s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000737s ]
---------------------------------------------------------------
[ 2023-04-25T08:41:27+08:00 ] 112.224.69.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682383285&v1=0.030913&v2=0.014290&v3=0.026398&v4=0.001355&v5=12.420000&t=16.149223&h=50.671143&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184655,35.985178&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001756s ] 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` = '868922055678110' LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682383285,`v1`=0.030913,`v2`=0.01429,`v3`=0.026398,`v4`=0.001355,`v5`=12.42,`t`=16.149223,`h`=50.671143,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184655,35.985178',`update_time`=1682383287 WHERE `imei` = '868922055678110' [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010170s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682383285 , 0.030913 , 0.01429 , 0.026398 , 0.001355 , 12.42 , 16.149223 , 50.671143 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.184655,35.985178' , 1682383287) [ RunTime:0.000673s ]
---------------------------------------------------------------
[ 2023-04-25T14:03:53+08:00 ] 39.144.4.114 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002102s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010705s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000721s ]
---------------------------------------------------------------
[ 2023-04-25T14:03:54+08:00 ] 218.204.252.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009683s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000691s ]
---------------------------------------------------------------
[ 2023-04-25T14:04:02+08:00 ] 39.144.4.114 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230425&time=140301&v1=-01.332&v2=+00.040&v3=-00.988&v4=-00.029&v5=05.7&t=+20.1&h=58.8&rssi=+229&ccid=4600485905031420000099m9990000000345000001g3410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001658s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010150s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000693s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230425',`time`='140301',`v1`=-1.332,`v2`=0.04,`v3`=-0.988,`v4`=-0.029,`v5`=5.7,`t`=20.1,`h`=58.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000345000001g3410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682402642 WHERE `imei` = '868922055643643' [ RunTime:0.000945s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010477s ]
[ 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' , '230425' , '140301' , -1.332 , 0.04 , -0.988 , -0.029 , 5.7 , 20.1 , 58.8 , 229 , '4600485905031420000099m9990000000345000001g3410,N,00E000=-00.000' , 0 , 0 , 1682402642 , 1682402642) [ RunTime:0.000617s ]
---------------------------------------------------------------
[ 2023-04-25T14:04:03+08:00 ] 218.204.252.181 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230425&time=140301&v1=-00.223&v2=+00.002&v3=+00.020&v4=-00.011&v5=06.0&t=+21.0&h=61.2&rssi=+227&ccid=4600485905031430000099m9990000000039000000g2410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ 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.010373s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000859s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230425',`time`='140301',`v1`=-0.223,`v2`=0.002,`v3`=0.02,`v4`=-0.011,`v5`=6,`t`=21,`h`=61.2,`rssi`=227,`ccid`='4600485905031430000099m9990000000039000000g2410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682402643 WHERE `imei` = '868922055644013' [ RunTime:0.001304s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010005s ]
[ 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' , '230425' , '140301' , -0.223 , 0.002 , 0.02 , -0.011 , 6 , 21 , 61.2 , 227 , '4600485905031430000099m9990000000039000000g2410,N,00E000=-00.000' , 0 , 0 , 1682402643 , 1682402643) [ RunTime:0.000525s ]
---------------------------------------------------------------
[ 2023-04-25T14:15:50+08:00 ] 111.55.141.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010530s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000735s ]
---------------------------------------------------------------
[ 2023-04-25T14:15:58+08:00 ] 111.55.141.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230425&time=141501&v1=-01.206&v2=+00.041&v3=-01.098&v4=-00.314&v5=06.0&t=+23.1&h=77.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.135&a2=01.249&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011577s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000737s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230425',`time`='141501',`v1`=-1.206,`v2`=0.041,`v3`=-1.098,`v4`=-0.314,`v5`=6,`t`=23.1,`h`=77.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.135,`a2`=1.249,`update_time`=1682403358 WHERE `imei` = '868922055684076' [ RunTime:0.000647s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012661s ]
[ 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' , '230425' , '141501' , -1.206 , 0.041 , -1.098 , -0.314 , 6 , 23.1 , 77.9 , 227 , '460044618415249' , -0 , 0.135 , 1.249 , 1682403358 , 1682403358) [ RunTime:0.001259s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:07+08:00 ] 124.129.96.215 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011860s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000597s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:10+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002113s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012837s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000839s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000860s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:15+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001673s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011208s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000751s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000928s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:23+08:00 ] 124.129.96.215 GET /admin/show/edit/id/35.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.008998s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012305s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000526s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:32+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011187s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试1',`interval`=2,`gps`='120.184891,35.984889',`username`='admin',`introduce`=' ',`update_time`=1682409632 WHERE `id` = 35 [ RunTime:0.000897s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:38+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011692s ]
[ 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.000798s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000909s ]
---------------------------------------------------------------
[ 2023-04-25T16:00:48+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011311s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000493s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000758s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000903s ]
---------------------------------------------------------------
[ 2023-04-25T16:01:03+08:00 ] 124.129.96.215 GET /admin/show/edit/id/35.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.010199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010919s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000703s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010448s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000451s ]
---------------------------------------------------------------
[ 2023-04-25T16:01:24+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002324s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010723s ]
[ 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.001123s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000872s ]
---------------------------------------------------------------
[ 2023-04-25T16:01:32+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001874s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009703s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000418s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000654s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000890s ]
---------------------------------------------------------------
[ 2023-04-25T16:02:32+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ 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.010299s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000466s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000677s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000952s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:13+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008938s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000467s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000922s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:18+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009882s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000463s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001438s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000987s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:33+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008912s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055684209%' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055684209%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000959s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:41+08:00 ] 124.129.96.215 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009724s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000640s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009876s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000488s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:48+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010230s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=2,`gps`='120.184861,35.985146',`username`='admin',`introduce`=' ',`update_time`=1682409828 WHERE `id` = 47 [ RunTime:0.000834s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:50+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ 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.011170s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000888s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-04-25T16:03:55+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009907s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000395s ]
[ 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.000867s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:06+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002139s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009629s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000713s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001911s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:20+08:00 ] 111.55.139.54 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001925s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010914s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000714s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:21+08:00 ] 111.55.139.54 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682409860&v1=0.027662&v2=0.020966&v3=0.025043&v4=0.015983&v5=12.240000&t=20.482162&h=43.804688&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682409860,`v1`=0.027662,`v2`=0.020966,`v3`=0.025043,`v4`=0.015983,`v5`=12.24,`t`=20.482162,`h`=43.804688,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1682409861 WHERE `imei` = '868922056976208' [ RunTime:0.000566s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012202s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1682409860 , 0.027662 , 0.020966 , 0.025043 , 0.015983 , 12.24 , 20.482162 , 43.804688 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1682409861) [ RunTime:0.001254s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:23+08:00 ] 111.55.139.54 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1575515471&v1=0.027000&v2=0.022009&v3=0.025013&v4=0.016224&v5=11.700000&t=17.875965&h=47.276062&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011252s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1575515471,`v1`=0.027,`v2`=0.022009,`v3`=0.025013,`v4`=0.016224,`v5`=11.7,`t`=17.875965,`h`=47.276062,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1682409863 WHERE `imei` = '868922056976208' [ RunTime:0.000594s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010757s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1575515471 , 0.027 , 0.022009 , 0.025013 , 0.016224 , 11.7 , 17.875965 , 47.276062 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1682409863) [ RunTime:0.000504s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:34+08:00 ] 39.144.15.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003237s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011427s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:35+08:00 ] 124.129.96.215 GET /admin/show/read/id/35/imei/868922056976208.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010302s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010707s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000665s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007912s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:36+08:00 ] 39.144.15.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682409874&v1=0.018993&v2=0.018358&v3=0.016344&v4=-0.006953&v5=12.420000&t=17.661463&h=48.740906&rssi=13&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012733s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000969s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682409874,`v1`=0.018993,`v2`=0.018358,`v3`=0.016344,`v4`=-0.006953,`v5`=12.42,`t`=17.661463,`h`=48.740906,`rssi`=13,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682409876 WHERE `imei` = '868922055684209' [ RunTime:0.000777s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012780s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682409874 , 0.018993 , 0.018358 , 0.016344 , -0.006953 , 12.42 , 17.661463 , 48.740906 , 13 , '898604650119C1078511' , '460048590708511' , -0 , 1682409876) [ RunTime:0.000801s ]
---------------------------------------------------------------
[ 2023-04-25T16:04:40+08:00 ] 124.129.96.215 GET /admin/show/read/id/35/imei/868922056976208.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001950s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009451s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011437s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000686s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003569s ]
---------------------------------------------------------------
[ 2023-04-25T16:05:14+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010694s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000385s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000773s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000911s ]
---------------------------------------------------------------
[ 2023-04-25T16:05:25+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.001566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009997s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' LIMIT 1 [ RunTime:0.000490s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000754s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000885s ]
---------------------------------------------------------------
[ 2023-04-25T16:05:53+08:00 ] 124.129.96.215 GET /admin/show/edit/id/35.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010746s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000720s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009954s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000483s ]
---------------------------------------------------------------
[ 2023-04-25T16:05:57+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009700s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试1',`interval`=60,`gps`='120.184891,35.984889',`username`='admin',`introduce`=' ',`update_time`=1682409957 WHERE `id` = 35 [ RunTime:0.000914s ]
---------------------------------------------------------------
[ 2023-04-25T16:05:58+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002582s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011036s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000830s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001032s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:00+08:00 ] 117.132.191.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002033s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010564s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000693s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:02+08:00 ] 117.132.191.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682409960&v1=0.027421&v2=0.016585&v3=0.025224&v4=0.015923&v5=12.420000&t=20.975517&h=43.247742&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012413s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682409960,`v1`=0.027421,`v2`=0.016585,`v3`=0.025224,`v4`=0.015923,`v5`=12.42,`t`=20.975517,`h`=43.247742,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1682409962 WHERE `imei` = '868922056976208' [ RunTime:0.000709s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012206s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1682409960 , 0.027421 , 0.016585 , 0.025224 , 0.015923 , 12.42 , 20.975517 , 43.247742 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1682409962) [ RunTime:0.000524s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:05+08:00 ] 124.129.96.215 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002029s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010006s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000705s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010134s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000467s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:09+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009717s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=60,`gps`='120.184861,35.985146',`username`='admin',`introduce`=' ',`update_time`=1682409969 WHERE `id` = 47 [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:10+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001837s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010885s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000471s ]
[ 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.000925s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:20+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011487s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000669s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009259s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000526s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:26+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011744s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.184655,35.985178',`username`='admin',`introduce`=' ',`update_time`=1682409986 WHERE `id` = 58 [ RunTime:0.000665s ]
---------------------------------------------------------------
[ 2023-04-25T16:06:27+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011376s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000361s ]
[ 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.000961s ]
---------------------------------------------------------------
[ 2023-04-25T16:07:19+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009989s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055647586%' LIMIT 1 [ RunTime:0.000478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055647586%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000657s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-04-25T16:07:21+08:00 ] 124.129.96.215 GET /admin/show/edit/id/44.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010356s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000695s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010072s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000492s ]
---------------------------------------------------------------
[ 2023-04-25T16:07:29+08:00 ] 117.132.195.204 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001783s ] 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` = '868922055684209' LIMIT 1 [ RunTime:0.000961s ]
---------------------------------------------------------------
[ 2023-04-25T16:07:31+08:00 ] 117.132.195.204 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682410049&v1=0.019355&v2=0.020131&v3=0.016164&v4=-0.007074&v5=12.420000&t=18.980650&h=46.536011&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002185s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009778s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000766s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682410049,`v1`=0.019355,`v2`=0.020131,`v3`=0.016164,`v4`=-0.007074,`v5`=12.42,`t`=18.98065,`h`=46.536011,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682410051 WHERE `imei` = '868922055684209' [ RunTime:0.000678s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010940s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682410049 , 0.019355 , 0.020131 , 0.016164 , -0.007074 , 12.42 , 18.98065 , 46.536011 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1682410051) [ RunTime:0.000502s ]
---------------------------------------------------------------
[ 2023-04-25T16:07:36+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001879s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010753s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试3',`interval`=2,`gps`='120.185121,35.985750',`username`='admin',`introduce`=' ',`update_time`=1682410056 WHERE `id` = 44 [ RunTime:0.000573s ]
---------------------------------------------------------------
[ 2023-04-25T16:07:37+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.010725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010304s ]
[ 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.000802s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000957s ]
---------------------------------------------------------------
[ 2023-04-25T16:08:10+08:00 ] 218.204.253.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010951s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000816s ]
---------------------------------------------------------------
[ 2023-04-25T16:08:11+08:00 ] 218.204.253.219 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682410090&v1=0.017789&v2=0.014395&v3=0.014900&v4=0.000030&v5=12.420000&t=17.543486&h=50.457520&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011722s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.001036s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682410090,`v1`=0.017789,`v2`=0.014395,`v3`=0.0149,`v4`=3.0E-5,`v5`=12.42,`t`=17.543486,`h`=50.45752,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682410091 WHERE `imei` = '868922055647586' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011480s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682410090 , 0.017789 , 0.014395 , 0.0149 , 3.0E-5 , 12.42 , 17.543486 , 50.45752 , 28 , '898604650119C1078512' , '460048590708512' , -0 , 1682410091) [ RunTime:0.001236s ]
---------------------------------------------------------------
[ 2023-04-25T16:11:30+08:00 ] 223.104.254.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.001720s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009926s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000686s ]
---------------------------------------------------------------
[ 2023-04-25T16:11:31+08:00 ] 223.104.254.100 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682410290&v1=0.017549&v2=0.014707&v3=0.014870&v4=-0.000090&v5=12.420000&t=18.862673&h=48.855347&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009580s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000658s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682410290,`v1`=0.017549,`v2`=0.014707,`v3`=0.01487,`v4`=-9.0E-5,`v5`=12.42,`t`=18.862673,`h`=48.855347,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682410291 WHERE `imei` = '868922055647586' [ RunTime:0.000543s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010725s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682410290 , 0.017549 , 0.014707 , 0.01487 , -9.0E-5 , 12.42 , 18.862673 , 48.855347 , 29 , '898604650119C1078512' , '460048590708512' , -0 , 1682410291) [ RunTime:0.000511s ]
---------------------------------------------------------------
[ 2023-04-25T16:14:30+08:00 ] 117.132.194.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002188s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010523s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000669s ]
---------------------------------------------------------------
[ 2023-04-25T16:14:31+08:00 ] 117.132.194.219 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682410470&v1=0.017669&v2=0.016481&v3=0.014930&v4=0.000030&v5=12.420000&t=19.559805&h=48.351807&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010655s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000777s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682410470,`v1`=0.017669,`v2`=0.016481,`v3`=0.01493,`v4`=3.0E-5,`v5`=12.42,`t`=19.559805,`h`=48.351807,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682410471 WHERE `imei` = '868922055647586' [ RunTime:0.000760s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012537s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682410470 , 0.017669 , 0.016481 , 0.01493 , 3.0E-5 , 12.42 , 19.559805 , 48.351807 , 28 , '898604650119C1078512' , '460048590708512' , -0 , 1682410471) [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2023-04-25T16:17:30+08:00 ] 39.144.4.121 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010300s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000672s ]
---------------------------------------------------------------
[ 2023-04-25T16:17:31+08:00 ] 39.144.4.121 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682410650&v1=0.018271&v2=0.015959&v3=0.015562&v4=-0.000030&v5=12.240000&t=20.138960&h=48.046631&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001869s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010736s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682410650,`v1`=0.018271,`v2`=0.015959,`v3`=0.015562,`v4`=-3.0E-5,`v5`=12.24,`t`=20.13896,`h`=48.046631,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682410651 WHERE `imei` = '868922055647586' [ RunTime:0.000618s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009943s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682410650 , 0.018271 , 0.015959 , 0.015562 , -3.0E-5 , 12.24 , 20.13896 , 48.046631 , 29 , '898604650119C1078512' , '460048590708512' , -0 , 1682410651) [ RunTime:0.000531s ]
---------------------------------------------------------------
[ 2023-04-25T16:20:30+08:00 ] 218.204.253.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.001880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010257s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000730s ]
---------------------------------------------------------------
[ 2023-04-25T16:20:31+08:00 ] 218.204.253.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682410830&v1=0.017729&v2=0.014499&v3=0.014990&v4=0.000090&v5=12.420000&t=20.535789&h=47.962708&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002974s ] 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` = '868922055647586' LIMIT 1 [ RunTime:0.000805s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682410830,`v1`=0.017729,`v2`=0.014499,`v3`=0.01499,`v4`=9.0E-5,`v5`=12.42,`t`=20.535789,`h`=47.962708,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682410831 WHERE `imei` = '868922055647586' [ RunTime:0.000746s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022166s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682410830 , 0.017729 , 0.014499 , 0.01499 , 9.0E-5 , 12.42 , 20.535789 , 47.962708 , 27 , '898604650119C1078512' , '460048590708512' , -0 , 1682410831) [ RunTime:0.000702s ]
---------------------------------------------------------------
[ 2023-04-25T16:23:29+08:00 ] 39.144.4.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002261s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2023-04-25T16:23:31+08:00 ] 39.144.4.67 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682411009&v1=0.017729&v2=0.016481&v3=0.014960&v4=0.000030&v5=12.420000&t=20.836092&h=47.977966&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&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.009835s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682411009,`v1`=0.017729,`v2`=0.016481,`v3`=0.01496,`v4`=3.0E-5,`v5`=12.42,`t`=20.836092,`h`=47.977966,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682411011 WHERE `imei` = '868922055647586' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010151s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682411009 , 0.017729 , 0.016481 , 0.01496 , 3.0E-5 , 12.42 , 20.836092 , 47.977966 , 29 , '898604650119C1078512' , '460048590708512' , -0 , 1682411011) [ RunTime:0.000517s ]
---------------------------------------------------------------
[ 2023-04-25T16:23:40+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010852s ]
[ 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.000771s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000916s ]
---------------------------------------------------------------
[ 2023-04-25T16:24:51+08:00 ] 124.129.96.215 GET /admin/show/edit/id/44.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010985s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011715s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000973s ]
---------------------------------------------------------------
[ 2023-04-25T16:24:56+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011545s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试3',`interval`=60,`gps`='120.185121,35.985750',`username`='admin',`introduce`=' ',`update_time`=1682411096 WHERE `id` = 44 [ RunTime:0.000616s ]
---------------------------------------------------------------
[ 2023-04-25T16:24:57+08:00 ] 124.129.96.215 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.011053s ]
[ 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.000905s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000970s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:03+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001999s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009877s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000376s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000959s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000932s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:10+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010495s ]
[ 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 10,10 [ RunTime:0.001016s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001001s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:30+08:00 ] 124.129.96.215 GET /admin/show/edit/id/35.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.009480s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000669s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011854s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000475s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:43+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ 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.012619s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试1',`interval`=360,`gps`='120.184891,35.984889',`username`='admin',`introduce`=' ',`update_time`=1682411143 WHERE `id` = 35 [ RunTime:0.000646s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:44+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001789s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011725s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000342s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000804s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000988s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:52+08:00 ] 124.129.96.215 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010350s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000660s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000447s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:55+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011468s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=360,`gps`='120.184861,35.985146',`username`='admin',`introduce`=' ',`update_time`=1682411155 WHERE `id` = 47 [ RunTime:0.000908s ]
---------------------------------------------------------------
[ 2023-04-25T16:25:57+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009143s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000375s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000780s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000926s ]
---------------------------------------------------------------
[ 2023-04-25T16:26:03+08:00 ] 124.129.96.215 GET /admin/show/edit/id/44.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002582s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011579s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000734s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010436s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000475s ]
---------------------------------------------------------------
[ 2023-04-25T16:26:07+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001997s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012079s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试3',`interval`=360,`gps`='120.185121,35.985750',`username`='admin',`introduce`=' ',`update_time`=1682411167 WHERE `id` = 44 [ RunTime:0.000628s ]
---------------------------------------------------------------
[ 2023-04-25T16:26:08+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010485s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000408s ]
[ 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.000974s ]
---------------------------------------------------------------
[ 2023-04-25T16:26:30+08:00 ] 117.132.196.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.001662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008485s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000673s ]
---------------------------------------------------------------
[ 2023-04-25T16:26:32+08:00 ] 117.132.196.39 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682411190&v1=0.017789&v2=0.015333&v3=0.014990&v4=0.000030&v5=12.240000&t=21.018417&h=48.168701&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012283s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000704s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682411190,`v1`=0.017789,`v2`=0.015333,`v3`=0.01499,`v4`=3.0E-5,`v5`=12.24,`t`=21.018417,`h`=48.168701,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682411192 WHERE `imei` = '868922055647586' [ RunTime:0.000574s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010926s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682411190 , 0.017789 , 0.015333 , 0.01499 , 3.0E-5 , 12.24 , 21.018417 , 48.168701 , 29 , '898604650119C1078512' , '460048590708512' , -0 , 1682411192) [ RunTime:0.000594s ]
---------------------------------------------------------------
[ 2023-04-25T16:42:21+08:00 ] 112.224.74.160 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009911s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000718s ]
---------------------------------------------------------------
[ 2023-04-25T16:42:22+08:00 ] 112.224.74.160 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682412141&v1=0.031274&v2=0.013143&v3=0.026518&v4=0.001234&v5=12.420000&t=17.296808&h=52.403015&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184843,35.984991&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009299s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682412141,`v1`=0.031274,`v2`=0.013143,`v3`=0.026518,`v4`=0.001234,`v5`=12.42,`t`=17.296808,`h`=52.403015,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184843,35.984991',`update_time`=1682412142 WHERE `imei` = '868922055678110' [ RunTime:0.000784s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009845s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682412141 , 0.031274 , 0.013143 , 0.026518 , 0.001234 , 12.42 , 17.296808 , 52.403015 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.184843,35.984991' , 1682412142) [ RunTime:0.001139s ]
---------------------------------------------------------------
[ 2023-04-25T17:06:57+08:00 ] 221.178.125.110 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010934s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000712s ]
---------------------------------------------------------------
[ 2023-04-25T17:06:59+08:00 ] 221.178.125.110 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682413617&v1=0.027361&v2=0.013560&v3=0.024983&v4=0.016104&v5=12.420000&t=17.672188&h=47.543091&rssi=29&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184875,35.985681&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002216s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010103s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000765s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682413617,`v1`=0.027361,`v2`=0.01356,`v3`=0.024983,`v4`=0.016104,`v5`=12.42,`t`=17.672188,`h`=47.543091,`rssi`=29,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184875,35.985681',`update_time`=1682413619 WHERE `imei` = '868922056976208' [ RunTime:0.000722s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010770s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1682413617 , 0.027361 , 0.01356 , 0.024983 , 0.016104 , 12.42 , 17.672188 , 47.543091 , 29 , '898604650119C1053139' , '460048590503139' , -0 , '120.184875,35.985681' , 1682413619) [ RunTime:0.000689s ]
---------------------------------------------------------------
[ 2023-04-25T17:08:29+08:00 ] 218.204.253.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009807s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001408s ]
---------------------------------------------------------------
[ 2023-04-25T17:08:31+08:00 ] 218.204.253.134 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682413709&v1=0.019475&v2=0.014812&v3=0.016013&v4=-0.007074&v5=12.600000&t=17.554211&h=49.595398&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001739s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009533s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000705s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682413709,`v1`=0.019475,`v2`=0.014812,`v3`=0.016013,`v4`=-0.007074,`v5`=12.6,`t`=17.554211,`h`=49.595398,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682413711 WHERE `imei` = '868922055684209' [ RunTime:0.000550s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008621s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682413709 , 0.019475 , 0.014812 , 0.016013 , -0.007074 , 12.6 , 17.554211 , 49.595398 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1682413711) [ RunTime:0.000511s ]
---------------------------------------------------------------
[ 2023-04-25T22:27:30+08:00 ] 39.144.8.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011068s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2023-04-25T22:27:32+08:00 ] 39.144.8.66 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682432850&v1=0.018151&v2=0.013039&v3=0.015411&v4=-0.000030&v5=12.240000&t=16.299376&h=65.434021&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&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.009666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000696s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682432850,`v1`=0.018151,`v2`=0.013039,`v3`=0.015411,`v4`=-3.0E-5,`v5`=12.24,`t`=16.299376,`h`=65.434021,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682432852 WHERE `imei` = '868922055647586' [ RunTime:0.000643s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011584s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682432850 , 0.018151 , 0.013039 , 0.015411 , -3.0E-5 , 12.24 , 16.299376 , 65.434021 , 27 , '898604650119C1078512' , '460048590708512' , -0 , 1682432852) [ RunTime:0.000681s ]
---------------------------------------------------------------
[ 2023-04-25T23:07:03+08:00 ] 111.55.139.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.073711s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000759s ]
---------------------------------------------------------------
[ 2023-04-25T23:07:04+08:00 ] 111.55.139.87 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682435223&v1=0.027060&v2=0.011578&v3=0.025013&v4=0.015983&v5=12.420000&t=16.524603&h=51.746887&rssi=29&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184885,35.996151&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002040s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000796s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682435223,`v1`=0.02706,`v2`=0.011578,`v3`=0.025013,`v4`=0.015983,`v5`=12.42,`t`=16.524603,`h`=51.746887,`rssi`=29,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184885,35.996151',`update_time`=1682435224 WHERE `imei` = '868922056976208' [ RunTime:0.000798s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010588s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1682435223 , 0.02706 , 0.011578 , 0.025013 , 0.015983 , 12.42 , 16.524603 , 51.746887 , 29 , '898604650119C1053139' , '460048590503139' , -0 , '120.184885,35.996151' , 1682435224) [ RunTime:0.000708s ]
---------------------------------------------------------------
[ 2023-04-25T23:09:26+08:00 ] 111.55.139.165 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002986s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011959s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000782s ]
---------------------------------------------------------------
[ 2023-04-25T23:09:27+08:00 ] 111.55.139.165 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682435366&v1=0.019234&v2=0.014395&v3=0.015923&v4=-0.007194&v5=12.420000&t=16.406626&h=57.911438&rssi=28&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002410s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008936s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682435366,`v1`=0.019234,`v2`=0.014395,`v3`=0.015923,`v4`=-0.007194,`v5`=12.42,`t`=16.406626,`h`=57.911438,`rssi`=28,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682435367 WHERE `imei` = '868922055684209' [ RunTime:0.000569s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012151s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682435366 , 0.019234 , 0.014395 , 0.015923 , -0.007194 , 12.42 , 16.406626 , 57.911438 , 28 , '898604650119C1078511' , '460048590708511' , -0 , 1682435367) [ RunTime:0.000544s ]