基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-09-23 07:32:14 HTTP/2.0 GET : https://www.medtcm.com/yaowu/SZL?page=7
- 运行时间 : 0.909968s [ 吞吐率:1.10req/s ] 内存消耗:4,948.86kb 文件加载:177
- 查询信息 : 4 queries
- 缓存信息 : 2 reads,0 writes
- 会话信息 : SESSION_ID=797fc6be7e8be897c58de5e9aab75ea0
- CONNECT:[ UseTime:0.000550s ] mysql:host=127.0.0.1;port=3306;dbname=www_medtcm_com;charset=utf8
- SHOW FULL COLUMNS FROM `lay_tcm_yaowu` [ RunTime:0.004053s ]
- SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `lay_tcm_yaowu` `tcm_yaowu` LEFT JOIN `lay_tcm_yaowu_attr` `tcm_yaowu_attr` ON `tcm_yaowu_attr`.`yaowu_id`=`tcm_yaowu`.`id` GROUP BY `tcm_yaowu`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.157873s ]
- SELECT `tcm_yaowu`.*,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='nature' THEN attr_value END) AS nature,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='taste' THEN attr_value END) AS taste,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='meridian' THEN attr_value END) AS meridian FROM `lay_tcm_yaowu` `tcm_yaowu` LEFT JOIN `lay_tcm_yaowu_attr` `tcm_yaowu_attr` ON `tcm_yaowu_attr`.`yaowu_id`=`tcm_yaowu`.`id` GROUP BY `tcm_yaowu`.`id` LIMIT 120,20 [ RunTime:0.357798s ]
- SELECT COUNT(*) AS think_count FROM ( SELECT `tcm_yaowu`.*,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='nature' THEN attr_value END) AS nature,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='taste' THEN attr_value END) AS taste,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='meridian' THEN attr_value END) AS meridian,count(*) AS think_count FROM `lay_tcm_yaowu` `tcm_yaowu` LEFT JOIN `lay_tcm_yaowu_attr` `tcm_yaowu_attr` ON `tcm_yaowu_attr`.`yaowu_id`=`tcm_yaowu`.`id` GROUP BY `tcm_yaowu`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.305287s ]

0.911544s