SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000655s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000782s ]
SELECT * FROM `aws_config` [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000765s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000604s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000533s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000627s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1750231923 [ RunTime:0.008036s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000644s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000426s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000383s ]
SELECT * FROM `aws_topic` WHERE `id` = 82 LIMIT 1 [ RunTime:0.000377s ]
SHOW FULL COLUMNS FROM `aws_topic_focus` [ RunTime:0.000517s ]
SELECT `uid` FROM `aws_topic_focus` WHERE `topic_id` = 82 ORDER BY RAND() LIMIT 0,10 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.000561s ]
SELECT `item_id`,`item_type` FROM `aws_topic_relation` WHERE ( status=1 AND topic_id IN(82) ) [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.000512s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') AND `item_id` IN (20,75,35,76,77,79,81,82) AND `item_type` IN ('question','article') LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`item_id`,`item_type`,`uid` FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') AND `item_id` IN (20,75,35,76,77,79,81,82) AND `item_type` IN ('question','article') ORDER BY `set_top_time` DESC,`create_time` DESC LIMIT 0,15 [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000678s ]
SELECT `last_answer` FROM `aws_question` WHERE `id` IN (35,20) AND `status` = 1 [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000526s ]
SELECT * FROM `aws_answer` WHERE `status` = 1 AND `id` IN (31,34) [ RunTime:0.000404s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (35,20) AND `item_type` = 'question' [ RunTime:0.000361s ]
SELECT * FROM `aws_topic` WHERE `id` = 82 [ RunTime:0.000417s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` IN (35,20) [ RunTime:0.000487s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (82,81,79,77,76,35,20) AND `item_type` = 'article' [ RunTime:0.000378s ]
SELECT * FROM `aws_topic` WHERE `id` IN (32,33,51,52,82,71) [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.000737s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` IN (82,81,79,77,76,35,20) [ RunTime:0.001909s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.000886s ]
SELECT `uid`,`nick_name`,`user_name`,`salt`,`email`,`mobile`,`sex`,`is_first_login`,`inbox_unread`,`notify_unread`,`fans_count`,`friend_count`,`available_invite_count`,`is_valid_email`,`is_valid_mobile`,`integral`,`reputation`,`reputation_update_time`,`avatar`,`signature`,`verified`,`group_id`,`integral_group_id`,`reputation_group_id`,`last_login_time`,`last_login_ip`,`reg_ip`,`money`,`frozen_money`,`deal_password`,`birthday`,`url_token`,`views_count`,`agree_count`,`question_count`,`answer_count`,`article_count`,`draft_count`,`topic_focus_count`,`column_count`,`extend`,`status`,`theme`,`create_time`,`update_time` FROM `aws_users` WHERE `status` = 1 AND `uid` IN (35,62,1,124,55,5) [ RunTime:0.000541s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000290s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000220s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000221s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000200s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 35 LIMIT 1 [ RunTime:0.000200s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 35 LIMIT 1 [ RunTime:0.000204s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000201s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000209s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 62 LIMIT 1 [ RunTime:0.000217s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 62 LIMIT 1 [ RunTime:0.000190s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 124 LIMIT 1 [ RunTime:0.000199s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 124 LIMIT 1 [ RunTime:0.000196s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000522s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 82 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000276s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 81 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000286s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 79 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000442s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 34 AND `item_type` = 'answer' LIMIT 1 [ RunTime:0.000284s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 35 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000252s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 77 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000251s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 76 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000251s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 31 AND `item_type` = 'answer' LIMIT 1 [ RunTime:0.000233s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 20 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000232s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 35 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000282s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 20 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000249s ]
SELECT COUNT(*) AS think_count FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 ORDER BY RAND(),`top` DESC,`focus` DESC,`discuss_month` DESC LIMIT 0,5 [ RunTime:0.000744s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 45 LIMIT 1 [ RunTime:0.000268s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 41 LIMIT 1 [ RunTime:0.000237s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 11 LIMIT 1 [ RunTime:0.000220s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 54 LIMIT 1 [ RunTime:0.000228s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 53 LIMIT 1 [ RunTime:0.000219s ]
林威
回复了问题
2022-06-09 17:53
Giacomo
回复了问题
2022-06-06 23:03
