基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-07-27 22:31:41 HTTP/1.1 GET : http://www.zsswhg.com/portal/list/index.html?id=29
- 运行时间 : 0.350107s [ 吞吐率:2.86req/s ] 内存消耗:2,828.24kb 文件加载:189
- 查询信息 : 5 queries
- 缓存信息 : 8 reads,0 writes
- 会话信息 : SESSION_ID=c08e0d78647886651479e381a287adea
- CONNECT:[ UseTime:0.015635s ] mysql:host=172.21.13.105;port=3306;dbname=wenhuaguan;charset=utf8mb4
- SELECT `config` FROM `whg_plugin` WHERE `name` = 'TcSwitchTheme' LIMIT 1 [ RunTime:0.010594s ]
- SELECT * FROM `whg_portal_category` WHERE `id` = 29 AND `status` = 1 LIMIT 1 [ RunTime:0.016469s ]
- SELECT * FROM `whg_portal_category` WHERE `delete_time` = 0 [ RunTime:0.004730s ]
- SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `whg_portal_post` `post` INNER JOIN `whg_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `delete_time` = 0 AND `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '29' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1722090701' ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.011868s ]
- SELECT post.*,min(category_post.category_id) as category_id FROM `whg_portal_post` `post` INNER JOIN `whg_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `delete_time` = 0 AND `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '29' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1722090701' ) GROUP BY `post`.`id` ORDER BY `post`.`is_top` DESC,`post`.`published_time` DESC LIMIT 0,10 [ RunTime:0.126547s ]
0.418889s