[ BEHAVIOR ] Run \addons\ask\Ask @view_filter [ RunTime:0.000104s ]
[ DB ] CONNECT:[ UseTime:0.000301s ] mysql:host=127.0.0.1;port=3306;dbname=www_youthra_cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fa_ask_group` [ RunTime:0.000626s ]
[ SQL ] SELECT * FROM `fa_ask_group` WHERE `name` = '测试呀' LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_question` [ RunTime:0.000548s ]
[ 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` = 19 ) AND `fa_ask_question`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_article` [ RunTime:0.000534s ]
[ 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` = 19 ) AND `fa_ask_article`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_group_activity` [ RunTime:0.000488s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_group_activity` WHERE `group_id` = 19 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_user` [ RunTime:0.000481s ]
[ 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` = 19 LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_group_content_map` [ RunTime:0.000456s ]
[ 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` = 19 ) AND `fa_ask_article`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SELECT `fa_ask_article`.*,pivot.id AS pivot__id,pivot.group_id AS pivot__group_id,pivot.user_id AS pivot__user_id,pivot.type AS pivot__type,pivot.source_id AS pivot__source_id,pivot.best AS pivot__best,pivot.top AS pivot__top 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` = 19 ) AND `fa_ask_article`.`deletetime` IS NULL LIMIT 0,30 [ RunTime:0.000338s ]
[ SQL ] SHOW COLUMNS FROM `fa_user` [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (1) [ RunTime:0.000160s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_taggable` [ RunTime:0.000461s ]
[ SQL ] SELECT `t`.*,`ta`.`source_id` FROM `fa_ask_taggable` `ta` LEFT JOIN `fa_ask_tag` `t` ON `ta`.`tag_id`=`t`.`id` WHERE `source_id` IN (40) AND `type` = 'article' AND `t`.`deletetime` IS NULL [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_attention` [ RunTime:0.000459s ]
[ 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` = 19 GROUP BY a.user_id, a.source_id ) `_group_count_` LIMIT 1 [ RunTime:0.000196s ]
[ 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` = 19 GROUP BY a.user_id, a.source_id ORDER BY `count` DESC LIMIT 0,100 [ RunTime:0.000192s ]
[ 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.000132s ]
[ 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.000111s ]
[ 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.000102s ]
[ 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.000113s ]
