当前时间： 1970-01-01 08:00:00
分类：办公文件
评论(0)
Excel10个函数学会直接起飞~还在用VLOOKUP艰难地反向查找？为筛选数据写长长的数组公式？盘点了Excel中10个超强新函数，从“查找之王”XLOOKUP，到数据去重UNIQUE，再到万能筛选FILTER，以及文本合并TEXTJOIN、表格堆叠VSTACK……
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-29 00:22:05 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/813077.html
- 运行时间 : 0.172058s [ 吞吐率：5.81req/s ] 内存消耗：4,623.98kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=37ea02767871bfc38ee7b0f88c2a611c
- CONNECT:[ UseTime:0.000969s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000899s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000321s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000309s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000464s ]
- SELECT * FROM `set` [ RunTime:0.000230s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000649s ]
- SELECT * FROM `article` WHERE `id` = 813077 LIMIT 1 [ RunTime:0.000487s ]
- UPDATE `article` SET `lasttime` = 1782663726 WHERE `id` = 813077 [ RunTime:0.000975s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000258s ]
- SELECT * FROM `article` WHERE `id` < 813077 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
- SELECT * FROM `article` WHERE `id` > 813077 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000346s ]
- SELECT * FROM `article` WHERE `id` < 813077 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000650s ]
- SELECT * FROM `article` WHERE `id` < 813077 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000837s ]
- SELECT * FROM `article` WHERE `id` < 813077 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000561s ]
0.173751s
夜雨聆风