基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-07-27 22:17:17 HTTP/1.1 GET : http://www.zsswhg.com/portal/list/index.html?id=28
- 运行时间 : 0.248282s [ 吞吐率:4.03req/s ] 内存消耗:922.28kb 文件加载:191
- 查询信息 : 6 queries
- 缓存信息 : 8 reads,0 writes
- 会话信息 : SESSION_ID=feb9c4f23cbcbaf320d176b54301fb1f
- CONNECT:[ UseTime:0.010985s ] mysql:host=172.21.13.105;port=3306;dbname=wenhuaguan;charset=utf8mb4
- SELECT `config` FROM `whg_plugin` WHERE `name` = 'TcSwitchTheme' LIMIT 1 [ RunTime:0.003655s ]
- SELECT * FROM `whg_portal_category` WHERE `id` = 28 AND `status` = 1 LIMIT 1 [ RunTime:0.002588s ]
- SELECT * FROM `whg_portal_category` WHERE `id` = 11 AND `status` = 1 LIMIT 1 [ RunTime:0.001793s ]
- SELECT * FROM `whg_portal_category` WHERE `delete_time` = 0 [ RunTime:0.001551s ]
- 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` = '28' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1722089837' ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.007553s ]
- 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` = '28' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1722089837' ) GROUP BY `post`.`id` ORDER BY `post`.`is_top` DESC,`post`.`published_time` DESC LIMIT 0,12 [ RunTime:0.015440s ]
0.315051s