基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-08-04 12:49:03 HTTP/2.0 GET : https://medtcm.com/yaowu/jml.html?page=13
- 运行时间 : 1.007243s [ 吞吐率:0.99req/s ] 内存消耗:4,942.15kb 文件加载:177
- 查询信息 : 4 queries
- 缓存信息 : 2 reads,0 writes
- 会话信息 : SESSION_ID=9b14629a78a2f05994b4e137cfc1ab3c
- CONNECT:[ UseTime:0.000755s ] mysql:host=127.0.0.1;port=3306;dbname=www_medtcm_com;charset=utf8
- SHOW FULL COLUMNS FROM `lay_tcm_yaowu` [ RunTime:0.000897s ]
- 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.136409s ]
- 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 240,20 [ RunTime:0.397158s ]
- 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.418945s ]

1.009341s