基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-10-21 06:29:51 HTTP/1.1 GET : https://meta.librarydata.cn/chartpage?lib_num=1407
- 运行时间 : 0.583515s [ 吞吐率:1.71req/s ] 内存消耗:4,478.75kb 文件加载:140
- 查询信息 : 5 queries
- 缓存信息 : 4 reads,4 writes
- 会话信息 : SESSION_ID=62b40af9be28c73dff2216cbab7f7879
- CONNECT:[ UseTime:0.010405s ] mysql:host=127.0.0.1;port=3306;dbname=meta_system;charset=utf8
- SHOW FULL COLUMNS FROM `_tsg_datalist` [ RunTime:0.004474s ]
- SELECT taskyear,sum(num) as num FROM `_tsg_datalist` WHERE `libnum` = '1407' GROUP BY `taskyear` [ RunTime:0.000891s ]
- SELECT dataType,sum(num) as issue_sum FROM `_tsg_datalist` WHERE `libnum` = '1407' GROUP BY `dataType` ORDER BY `dataType` [ RunTime:0.001257s ]
- CONNECT:[ UseTime:0.000018s ] mongodb://web:metaData_987&*(@116.204.118.255:27017
- [ RunTime:0.077032s ]
- SELECT a.dataType,sum(a.num) as num,b.zyType FROM `_tsg_datalist` `a` INNER JOIN `_tsg_zylist` `b` ON `a`.`libnum`=b.libnum and a.bag = b.bag and a.taskyear = b.taskyear WHERE `a`.`libnum` = '1407' AND `a`.`dataType` <> '100' GROUP BY `b`.`zyType`,`a`.`dataType` ORDER BY `b`.`zyType` [ RunTime:0.001821s ]

0.594162s