基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-08-04 07:00:41 HTTP/2.0 GET : https://medtcm.com/yaowu/PBL?page=7
- 运行时间 : 1.796507s [ 吞吐率:0.56req/s ] 内存消耗:4,943.23kb 文件加载:177
- 查询信息 : 4 queries
- 缓存信息 : 2 reads,0 writes
- 会话信息 : SESSION_ID=a545f2a18055d2001e80dcea6b7e215c
- CONNECT:[ UseTime:0.005928s ] mysql:host=127.0.0.1;port=3306;dbname=www_medtcm_com;charset=utf8
- SHOW FULL COLUMNS FROM `lay_tcm_yaowu` [ RunTime:0.000901s ]
- 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.269790s ]
- 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.949711s ]
- 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.466142s ]

1.798139s