[ BEHAVIOR ] Run \addons\ask\Ask @view_filter [ RunTime:0.000205s ]
[ DB ] CONNECT:[ UseTime:0.000319s ] mysql:host=127.0.0.1;port=3306;dbname=www_youthra_cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fa_ask_question` [ RunTime:0.000699s ]
[ SQL ] SELECT * FROM `fa_ask_question` WHERE ( `id` = 23928 ) AND `fa_ask_question`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_category` [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` = 0 [ RunTime:0.000134s ]
[ SQL ] UPDATE `fa_ask_question` SET `views`=`views`+1 WHERE `id` = 23928 [ RunTime:0.002693s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_user` [ RunTime:0.000552s ]
[ SQL ] SELECT * FROM `fa_ask_user` WHERE `user_id` = 20 LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SHOW COLUMNS FROM `fa_user` [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_tag` [ RunTime:0.000471s ]
[ SQL ] SELECT `t`.*,`ta`.`source_id`,ta.id AS taggable_id FROM `fa_ask_tag` `t` RIGHT JOIN `fa_ask_taggable` `ta` ON `ta`.`tag_id`=`t`.`id` WHERE ( `ta`.`source_id` = 23928 AND `ta`.`type` = 'question' ) AND `t`.`deletetime` IS NULL [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_taggable` [ RunTime:0.000720s ]
[ SQL ] SELECT * FROM `fa_ask_question` WHERE ( ( `id` IN ( SELECT `source_id` FROM `fa_ask_taggable` WHERE `tag_id` IN (9640) AND `type` = 'question' ) AND `id` <> 23928 ) AND `status` <> 'hidden' ) AND `fa_ask_question`.`deletetime` IS NULL LIMIT 10 [ RunTime:0.004213s ]
[ SQL ] SELECT * FROM `fa_ask_question` WHERE ( `id` = 23928 ) AND `fa_ask_question`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SHOW COLUMNS FROM `fa_ask_answer` [ RunTime:0.000507s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_answer` WHERE ( `question_id` = 23928 AND `status` = 'normal' AND `id` NOT IN (0) ) AND `fa_ask_answer`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT *,(1.*`voteup`-`votedown`) AS vote FROM `fa_ask_answer` WHERE ( `question_id` = 23928 AND `status` = 'normal' AND `id` NOT IN (0) ) AND `fa_ask_answer`.`deletetime` IS NULL ORDER BY `vote` DESC,`id` ASC LIMIT 0,50 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` IN (0) [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (1) [ RunTime:0.000138s ]
[ 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 (34,73,71,55,76,68,69,75,74,40) AND `type` = 'article' AND `t`.`deletetime` IS NULL [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` IN (0) [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (1) [ RunTime:0.000133s ]
[ 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 (73,71,57,75,66,79,68,82,78,60) AND `type` = 'question' AND `t`.`deletetime` IS NULL [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` IN (0) [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (15,1,3) [ RunTime:0.000156s ]
[ 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 (88,82,81,80,78,74,73,72,71,70) AND `type` = 'question' AND `t`.`deletetime` IS NULL [ RunTime:0.000180s ]