基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-08-05 05:45:31 HTTP/2.0 GET : https://www.medtcm.com/yaowu/ZZL?page=15
- 运行时间 : 1.014207s [ 吞吐率：0.99req/s ] 内存消耗：4,871.72kb 文件加载：177
- 查询信息 : 4 queries
- 缓存信息 : 2 reads,0 writes
- 会话信息 : SESSION_ID=e2a23ba1c7d97f641f14bc0dcd069764
- CONNECT:[ UseTime:0.000875s ] mysql:host=127.0.0.1;port=3306;dbname=www_medtcm_com;charset=utf8
- SHOW FULL COLUMNS FROM `lay_tcm_yaowu` [ RunTime:0.001271s ]
- 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.128694s ]
- 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 280,20 [ RunTime:0.396631s ]
- 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.420543s ]
1.015463s
