--------------------------------------------------------------- [ 2023-04-23T02:03:54+08:00 ] 39.144.3.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003079s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012542s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001520s ] --------------------------------------------------------------- [ 2023-04-23T02:03:54+08:00 ] 221.178.127.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010106s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2023-04-23T02:04:03+08:00 ] 39.144.3.27 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230423&time=020301&v1=-01.338&v2=+00.016&v3=-01.015&v4=-00.029&v5=05.7&t=+09.2&h=61.2&rssi=+228&ccid=4600485905031420000099m9990000000325000001g3480,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002107s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230423',`time`='020301',`v1`=-1.338,`v2`=0.016,`v3`=-1.015,`v4`=-0.029,`v5`=5.7,`t`=9.2,`h`=61.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000325000001g3480,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682186643 WHERE `imei` = '868922055643643' [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014620s ] [ 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' , '230423' , '020301' , -1.338 , 0.016 , -1.015 , -0.029 , 5.7 , 9.2 , 61.2 , 228 , '4600485905031420000099m9990000000325000001g3480,N,00E000=-00.000' , 0 , 0 , 1682186643 , 1682186643) [ RunTime:0.002880s ] --------------------------------------------------------------- [ 2023-04-23T02:04:03+08:00 ] 221.178.127.252 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230423&time=020301&v1=-00.251&v2=+00.001&v3=-00.034&v4=-00.012&v5=05.9&t=+09.7&h=64.0&rssi=+225&ccid=4600485905031430000099m9990000000033000000g2630,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230423',`time`='020301',`v1`=-0.251,`v2`=0.001,`v3`=-0.034,`v4`=-0.012,`v5`=5.9,`t`=9.7,`h`=64,`rssi`=225,`ccid`='4600485905031430000099m9990000000033000000g2630,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682186643 WHERE `imei` = '868922055644013' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009991s ] [ 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' , '230423' , '020301' , -0.251 , 0.001 , -0.034 , -0.012 , 5.9 , 9.7 , 64 , 225 , '4600485905031430000099m9990000000033000000g2630,N,00E000=-00.000' , 0 , 0 , 1682186643 , 1682186643) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2023-04-23T10:00:51+08:00 ] 39.144.4.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002279s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010185s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2023-04-23T10:00:59+08:00 ] 39.144.4.101 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230423&time=100001&v1=-01.199&v2=+00.043&v3=-01.081&v4=-00.411&v5=05.9&t=+12.6&h=79.6&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.134&a2=01.229&a3=00.000&end=$ [ 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.010364s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230423',`time`='100001',`v1`=-1.199,`v2`=0.043,`v3`=-1.081,`v4`=-0.411,`v5`=5.9,`t`=12.6,`h`=79.6,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.134,`a2`=1.229,`update_time`=1682215259 WHERE `imei` = '868922055684076' [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012046s ] [ 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' , '230423' , '100001' , -1.199 , 0.043 , -1.081 , -0.411 , 5.9 , 12.6 , 79.6 , 227 , '460044618415249' , -0 , 0.134 , 1.229 , 1682215259 , 1682215259) [ RunTime:0.000722s ] --------------------------------------------------------------- [ 2023-04-23T10:26:09+08:00 ] 124.129.96.215 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012730s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-04-23T10:26:11+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011513s ] [ 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.000786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001034s ] --------------------------------------------------------------- [ 2023-04-23T10:26:16+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009558s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000503s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001090s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000995s ] --------------------------------------------------------------- [ 2023-04-23T10:26:19+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.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.010210s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013406s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001069s ] --------------------------------------------------------------- [ 2023-04-23T10:26:46+08:00 ] 112.224.69.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001754s ] 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` = '868922055678110' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-04-23T10:26:47+08:00 ] 112.224.69.174 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682216806&v1=0.031154&v2=0.012413&v3=0.026518&v4=0.001294&v5=12.240000&t=17.586388&h=49.091858&rssi=26&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002205s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010803s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001170s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682216806,`v1`=0.031154,`v2`=0.012413,`v3`=0.026518,`v4`=0.001294,`v5`=12.24,`t`=17.586388,`h`=49.091858,`rssi`=26,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1682216807 WHERE `imei` = '868922055678110' [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009863s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682216806 , 0.031154 , 0.012413 , 0.026518 , 0.001294 , 12.24 , 17.586388 , 49.091858 , 26 , '89860118803392574452' , '460015788115318' , -0 , 1682216807) [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-04-23T10:26:57+08:00 ] 124.129.96.215 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001812s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009441s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=60,`gps`='120.185932,35.985124',`username`='admin',`introduce`=' ',`update_time`=1682216817 WHERE `id` = 58 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2023-04-23T10:26:58+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008649s ] [ 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.000752s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000990s ] --------------------------------------------------------------- [ 2023-04-23T10:27:32+08:00 ] 124.129.96.215 GET /admin/show/delete/id/52.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 52 [ RunTime:0.000662s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 52 [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2023-04-23T10:27:33+08:00 ] 124.129.96.215 GET /admin/show/index.html [ 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.010701s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000392s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000978s ] --------------------------------------------------------------- [ 2023-04-23T10:27:37+08:00 ] 124.129.96.215 GET /admin/show/delete/id/51.html [ 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.012876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 51 [ RunTime:0.000767s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 51 [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2023-04-23T10:27:38+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011150s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000403s ] [ 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.001011s ] --------------------------------------------------------------- [ 2023-04-23T10:27:42+08:00 ] 124.129.96.215 GET /admin/show/delete/id/48.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009577s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 48 [ RunTime:0.000693s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 48 [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2023-04-23T10:27:43+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003401s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010117s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000777s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001080s ] --------------------------------------------------------------- [ 2023-04-23T10:27:47+08:00 ] 124.129.96.215 GET /admin/show/delete/id/50.html [ sql ] [ DB ] CONNECT:[ UseTime:0.009833s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010924s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 50 [ RunTime:0.000715s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 50 [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2023-04-23T10:27:48+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001845s ] 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 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.000840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001009s ] --------------------------------------------------------------- [ 2023-04-23T10:27:51+08:00 ] 124.129.96.215 GET /admin/show/delete/id/49.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.009874s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 49 [ RunTime:0.000613s ] [ sql ] [ SQL ] DELETE FROM `collect_show` WHERE `id` = 49 [ RunTime:0.008802s ] --------------------------------------------------------------- [ 2023-04-23T10:27:52+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002018s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000392s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000805s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001258s ] --------------------------------------------------------------- [ 2023-04-23T10:28:01+08:00 ] 124.129.96.215 GET /admin/show/read/id/40/imei/868922055683771.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009607s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000801s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005306s ] --------------------------------------------------------------- [ 2023-04-23T10:28:03+08:00 ] 124.129.96.215 GET /admin/show/read/id/40/imei/868922055683771.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010790s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000494s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2023-04-23T10:28:05+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002166s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009918s ] [ 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.000834s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000915s ] --------------------------------------------------------------- [ 2023-04-23T10:28:34+08:00 ] 124.129.96.215 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.013140s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000376s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000391s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000378s ] --------------------------------------------------------------- [ 2023-04-23T10:28:37+08:00 ] 124.129.96.215 GET /admin/shelves/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_shelves` [ RunTime:0.024044s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_shelves` LIMIT 1 [ RunTime:0.000456s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000719s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC [ RunTime:0.000504s ] --------------------------------------------------------------- [ 2023-04-23T10:28:40+08:00 ] 124.129.96.215 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013482s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001213s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2023-04-23T10:28:42+08:00 ] 124.129.96.215 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002096s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.008663s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000413s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000405s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000407s ] --------------------------------------------------------------- [ 2023-04-23T10:28:58+08:00 ] 112.224.67.189 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010315s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-04-23T10:28:59+08:00 ] 112.224.67.189 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682216938&v1=0.031274&v2=0.013039&v3=0.026488&v4=0.001355&v5=12.420000&t=18.197718&h=44.926208&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184951,35.987321&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682216938,`v1`=0.031274,`v2`=0.013039,`v3`=0.026488,`v4`=0.001355,`v5`=12.42,`t`=18.197718,`h`=44.926208,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184951,35.987321',`update_time`=1682216939 WHERE `imei` = '868922055678110' [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010727s ] [ 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' , 1682216938 , 0.031274 , 0.013039 , 0.026488 , 0.001355 , 12.42 , 18.197718 , 44.926208 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.184951,35.987321' , 1682216939) [ RunTime:0.000520s ] --------------------------------------------------------------- [ 2023-04-23T10:29:01+08:00 ] 124.129.96.215 GET /admin/user/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009862s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-04-23T10:29:22+08:00 ] 124.129.96.215 GET /admin/user/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010151s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE ( `id` = 12 ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-04-23T10:29:51+08:00 ] 124.129.96.215 GET /admin/user/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002183s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009220s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE ( `id` = 12 ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2023-04-23T10:30:18+08:00 ] 124.129.96.215 POST /admin/user/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001575s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009402s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE ( `id` = 12 ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000586s ] [ sql ] [ SQL ] UPDATE `collect_user` SET `password`='ba3c4352a7a9e9c182e1a1ca75b7e844',`user_phone`='',`user_email`='',`user_type`='collect',`introduce`=' ',`user_logo`='\\uploads\\20230423\\9daa74e0ba00e9406ccaad6aa274645a.jpg',`update_time`=1682217018 WHERE `id` = 12 [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2023-04-23T10:30:19+08:00 ] 124.129.96.215 GET /admin/user/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010609s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000853s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2023-04-23T10:51:06+08:00 ] 124.129.96.215 GET /admin/user/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002212s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009263s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000538s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-04-23T11:29:58+08:00 ] 112.224.70.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011950s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-04-23T11:29:59+08:00 ] 112.224.70.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682220598&v1=0.031033&v2=0.014707&v3=0.026308&v4=0.001054&v5=12.420000&t=15.881096&h=50.686401&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.186545,35.985033&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002533s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009809s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682220598,`v1`=0.031033,`v2`=0.014707,`v3`=0.026308,`v4`=0.001054,`v5`=12.42,`t`=15.881096,`h`=50.686401,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.186545,35.985033',`update_time`=1682220599 WHERE `imei` = '868922055678110' [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011684s ] [ 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' , 1682220598 , 0.031033 , 0.014707 , 0.026308 , 0.001054 , 12.42 , 15.881096 , 50.686401 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.186545,35.985033' , 1682220599) [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-04-23T11:42:10+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004045s ] 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.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000831s ] --------------------------------------------------------------- [ 2023-04-23T11:42:16+08:00 ] 124.129.96.215 GET /admin/show/read/id/58/imei/868922055678110.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009773s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011603s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2023-04-23T12:30:19+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011713s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000959s ] --------------------------------------------------------------- [ 2023-04-23T12:30:21+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001889s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011171s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011882s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000479s ] --------------------------------------------------------------- [ 2023-04-23T12:30:31+08:00 ] 124.129.96.215 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002292s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010388s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=240,`gps`='120.186545,35.985033',`username`='admin',`introduce`=' ',`update_time`=1682224231 WHERE `id` = 58 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-04-23T12:30:32+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009914s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000821s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000912s ] --------------------------------------------------------------- [ 2023-04-23T12:31:19+08:00 ] 112.224.75.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ 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.010411s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-04-23T12:31:20+08:00 ] 112.224.75.33 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682224279&v1=0.030973&v2=0.012726&v3=0.026428&v4=0.001234&v5=12.240000&t=16.031248&h=49.709839&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184702,35.985135&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008854s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682224279,`v1`=0.030973,`v2`=0.012726,`v3`=0.026428,`v4`=0.001234,`v5`=12.24,`t`=16.031248,`h`=49.709839,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184702,35.985135',`update_time`=1682224280 WHERE `imei` = '868922055678110' [ RunTime:0.000542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010918s ] [ 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' , 1682224279 , 0.030973 , 0.012726 , 0.026428 , 0.001234 , 12.24 , 16.031248 , 49.709839 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.184702,35.985135' , 1682224280) [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-04-23T14:03:55+08:00 ] 39.144.7.96 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010105s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-04-23T14:03:55+08:00 ] 39.144.1.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010888s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001476s ] --------------------------------------------------------------- [ 2023-04-23T14:04:04+08:00 ] 39.144.7.96 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230423&time=140301&v1=-00.243&v2=+00.001&v3=+00.017&v4=-00.011&v5=05.9&t=+15.0&h=62.5&rssi=+227&ccid=4600485905031430000099m9990000000037000000g2630,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002390s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016307s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001030s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230423',`time`='140301',`v1`=-0.243,`v2`=0.001,`v3`=0.017,`v4`=-0.011,`v5`=5.9,`t`=15,`h`=62.5,`rssi`=227,`ccid`='4600485905031430000099m9990000000037000000g2630,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682229844 WHERE `imei` = '868922055644013' [ RunTime:0.000879s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011047s ] [ 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' , '230423' , '140301' , -0.243 , 0.001 , 0.017 , -0.011 , 5.9 , 15 , 62.5 , 227 , '4600485905031430000099m9990000000037000000g2630,N,00E000=-00.000' , 0 , 0 , 1682229844 , 1682229844) [ RunTime:0.000826s ] --------------------------------------------------------------- [ 2023-04-23T14:04:04+08:00 ] 39.144.1.14 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230423&time=140301&v1=-01.331&v2=+00.035&v3=-00.998&v4=-00.029&v5=05.7&t=+15.2&h=59.7&rssi=+228&ccid=4600485905031420000099m9990000000334000001g3410,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230423',`time`='140301',`v1`=-1.331,`v2`=0.035,`v3`=-0.998,`v4`=-0.029,`v5`=5.7,`t`=15.2,`h`=59.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000334000001g3410,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682229844 WHERE `imei` = '868922055643643' [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010470s ] [ 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' , '230423' , '140301' , -1.331 , 0.035 , -0.998 , -0.029 , 5.7 , 15.2 , 59.7 , 228 , '4600485905031420000099m9990000000334000001g3410,N,00E000=-00.000' , 0 , 0 , 1682229844 , 1682229844) [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2023-04-23T16:32:28+08:00 ] 112.224.74.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002732s ] 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.000742s ] --------------------------------------------------------------- [ 2023-04-23T16:32:29+08:00 ] 112.224.74.22 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682238748&v1=0.031154&v2=0.014290&v3=0.026458&v4=0.001294&v5=12.420000&t=16.117048&h=50.098938&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184800,35.985054&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001858s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010082s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682238748,`v1`=0.031154,`v2`=0.01429,`v3`=0.026458,`v4`=0.001294,`v5`=12.42,`t`=16.117048,`h`=50.098938,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184800,35.985054',`update_time`=1682238749 WHERE `imei` = '868922055678110' [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011960s ] [ 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' , 1682238748 , 0.031154 , 0.01429 , 0.026458 , 0.001294 , 12.42 , 16.117048 , 50.098938 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.184800,35.985054' , 1682238749) [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-04-23T20:33:17+08:00 ] 112.224.69.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013511s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-04-23T20:33:18+08:00 ] 112.224.69.130 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682253197&v1=0.031094&v2=0.013456&v3=0.026398&v4=0.001355&v5=12.420000&t=15.655869&h=54.684204&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.185831,35.986443&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009443s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682253197,`v1`=0.031094,`v2`=0.013456,`v3`=0.026398,`v4`=0.001355,`v5`=12.42,`t`=15.655869,`h`=54.684204,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.185831,35.986443',`update_time`=1682253198 WHERE `imei` = '868922055678110' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011264s ] [ 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' , 1682253197 , 0.031094 , 0.013456 , 0.026398 , 0.001355 , 12.42 , 15.655869 , 54.684204 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.185831,35.986443' , 1682253198) [ RunTime:0.000630s ]