基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-20 07:43:03 HTTP/1.1 GET : youthra.cn/ask/group/%E6%88%91%E6%96%B0%E5%BB%BA%E7%9A%84.html?type=activity
- 运行时间 : 0.044538s [ 吞吐率：22.45req/s ] 内存消耗：5,114.94kb 文件加载：158
- 查询信息 : 19 queries 0 writes
- 缓存信息 : 1 reads,1 writes
- 配置加载 : 74
- [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000014s ]
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run \addons\xunsearch\Xunsearch @app_init [ RunTime:0.001985s ]
- [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.002006s ]
- [ LANG ] /www/wwwroot/www.youthra.cn/thinkphp/lang/zh-cn.php
- [ BEHAVIOR ] Run app\common\behavior\Common @app_dispatch [ RunTime:0.000164s ]
- [ ROUTE ] array (
'type' => 'method',
'method' =>
array (
0 => '\\think\\addons\\Route',
1 => 'execute',
),
'var' =>
array (
'addon' => 'ask',
'controller' => 'group',
'action' => 'show',
),
)
- [ HEADER ] array (
'host' => 'youthra.cn',
'accept-encoding' => 'gzip, br, zstd, deflate',
'cookie' => 'PHPSESSID=1l6apguc8v2hs7ir9rb28ffl2k',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept' => '*/*',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'type' => 'activity',
'name' => '我新建的',
)
- [ RUN ] think\addons\Route->execute[ /www/wwwroot/www.youthra.cn/vendor/karsonzhang/fastadmin-addons/src/addons/Route.php ]
- [ LANG ] /www/wwwroot/www.youthra.cn/public/../application/common/lang/zh-cn/addon.php
- [ BEHAVIOR ] Run app\common\behavior\Common @addon_begin [ RunTime:0.001020s ]
- [ LANG ] /www/wwwroot/www.youthra.cn/addons/ask/lang/zh-cn.php
- [ DB ] INIT mysql
- [ VIEW ] /www/wwwroot/www.youthra.cn/addons/ask/view/group/show.html [ array (
0 => 'config',
1 => 'user',
2 => 'site',
3 => 'isAdmin',
4 => 'askConfig',
5 => 'topZoneList',
6 => 'activityList',
7 => 'userContributeList',
8 => 'group_admin_userList',
9 => 'groupType',
10 => '__group__',
11 => '__groupTag__',
12 => 'title',
) ]
- [ BEHAVIOR ] Run \addons\ask\Ask @view_filter [ RunTime:0.000090s ]
- [ DB ] CONNECT:[ UseTime:0.000309s ] mysql:host=127.0.0.1;port=3306;dbname=www_youthra_cn;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `fa_ask_group` [ RunTime:0.000621s ]
- [ SQL ] SELECT * FROM `fa_ask_group` WHERE `name` = '我新建的' LIMIT 1 [ RunTime:0.000193s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_question` [ RunTime:0.000556s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_question` INNER JOIN `fa_ask_group_content_map` `pivot` ON `pivot`.`source_id`=`fa_ask_question`.`id` WHERE ( `pivot`.`type` = 'question' AND `pivot`.`group_id` = 37 ) AND `fa_ask_question`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000315s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_article` [ RunTime:0.000544s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_article` INNER JOIN `fa_ask_group_content_map` `pivot` ON `pivot`.`source_id`=`fa_ask_article`.`id` WHERE ( `pivot`.`type` = 'article' AND `pivot`.`group_id` = 37 ) AND `fa_ask_article`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000141s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_group_activity` [ RunTime:0.000457s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_group_activity` WHERE `group_id` = 37 LIMIT 1 [ RunTime:0.000135s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_user` [ RunTime:0.000458s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_user` INNER JOIN `fa_ask_group_admin_map` `pivot` ON `pivot`.`user_id`=`fa_ask_user`.`user_id` WHERE `pivot`.`user_id` IS NULL AND `pivot`.`group_id` = 37 LIMIT 1 [ RunTime:0.000218s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_group_activity` WHERE `group_id` = 37 LIMIT 1 [ RunTime:0.000148s ]
- [ SQL ] SELECT * FROM `fa_ask_group_activity` WHERE `group_id` = 37 LIMIT 0,30 [ RunTime:0.000205s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_attention` [ RunTime:0.000475s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `fa_ask_attention` `a` LEFT JOIN `fa_ask_group_content_map` `m` ON `a`.`source_id`=`m`.`group_id` LEFT JOIN (SELECT user_id, COUNT(*) AS count FROM fa_ask_group_content_map t GROUP BY user_id) t ON `a`.`user_id`=`t`.`user_id` LEFT JOIN `fa_user` `u` ON `u`.`id`=`a`.`user_id` LEFT JOIN (SELECT source_id FROM fa_ask_attention WHERE user_id = 1 AND type = 'user') n ON `a`.`user_id`=`n`.`source_id` WHERE `a`.`type` = 'group' AND `a`.`source_id` = 37 GROUP BY a.user_id, a.source_id ) `_group_count_` LIMIT 1 [ RunTime:0.000211s ]
- [ SQL ] SELECT a.user_id, a.source_id, NVL(t.count,0) as count, u.username,u.nickname,u.avatar, NVL2(n.source_id, 1, 0) followed FROM `fa_ask_attention` `a` LEFT JOIN `fa_ask_group_content_map` `m` ON `a`.`source_id`=`m`.`group_id` LEFT JOIN (SELECT user_id, COUNT(*) AS count FROM fa_ask_group_content_map t GROUP BY user_id) t ON `a`.`user_id`=`t`.`user_id` LEFT JOIN `fa_user` `u` ON `u`.`id`=`a`.`user_id` LEFT JOIN (SELECT source_id FROM fa_ask_attention WHERE user_id = 1 AND type = 'user') n ON `a`.`user_id`=`n`.`source_id` WHERE `a`.`type` = 'group' AND `a`.`source_id` = 37 GROUP BY a.user_id, a.source_id ORDER BY `count` DESC LIMIT 0,100 [ RunTime:0.000194s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_group` `t` LEFT JOIN `fa_ask_tag` `tag` ON `t`.`task_tag_id`=`tag`.`id` LEFT JOIN `fa_ask_tag` `tag2` ON `t`.`method_tag_id`=`tag2`.`id` WHERE ( 1=1 ) AND `t`.`name` = '我新建的' LIMIT 1 [ RunTime:0.000143s ]
- [ SQL ] SELECT `t`.*,tag.name task_tag_name,tag2.name method_tag_name FROM `fa_ask_group` `t` LEFT JOIN `fa_ask_tag` `tag` ON `t`.`task_tag_id`=`tag`.`id` LEFT JOIN `fa_ask_tag` `tag2` ON `t`.`method_tag_id`=`tag2`.`id` WHERE ( 1=1 ) AND `t`.`name` = '我新建的' LIMIT 0,100 [ RunTime:0.000138s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_group` `t` LEFT JOIN `fa_ask_group_admin_map` `a` ON `t`.`id`=`a`.`group_id` LEFT JOIN `fa_user` `u` ON `u`.`id`=`a`.`user_id` WHERE ( 1=1 ) AND `t`.`name` = '我新建的' LIMIT 1 [ RunTime:0.000113s ]
- [ SQL ] SELECT `t`.*,`u`.`username`,`u`.`nickname`,`u`.`avatar`,`a`.`user_id` FROM `fa_ask_group` `t` LEFT JOIN `fa_ask_group_admin_map` `a` ON `t`.`id`=`a`.`group_id` LEFT JOIN `fa_user` `u` ON `u`.`id`=`a`.`user_id` WHERE ( 1=1 ) AND `t`.`name` = '我新建的' LIMIT 0,100 [ RunTime:0.000134s ]
0.049412s
