基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-09-23 09:09:28 HTTP/2.0 GET : https://www.medtcm.com/yaowu/QCL?page=7
- 运行时间 : 1.047899s [ 吞吐率:0.95req/s ] 内存消耗:4,948.86kb 文件加载:177
- 查询信息 : 4 queries
- 缓存信息 : 2 reads,0 writes
- 会话信息 : SESSION_ID=968fbdd55d0da8a45064761c529f890a
- CONNECT:[ UseTime:0.000784s ] mysql:host=127.0.0.1;port=3306;dbname=www_medtcm_com;charset=utf8
- SHOW FULL COLUMNS FROM `lay_tcm_yaowu` [ RunTime:0.001207s ]
- 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.108695s ]
- 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.404415s ]
- 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.462725s ]

1.049725s