SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.011341s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.024548s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000748s ]
SELECT * FROM `aws_config` [ RunTime:0.000719s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000785s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000601s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000664s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000624s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1765006947 [ RunTime:0.045218s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000730s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000461s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000404s ]
SELECT * FROM `aws_topic` WHERE `id` = 2 LIMIT 1 [ RunTime:0.008045s ]
SHOW FULL COLUMNS FROM `aws_topic_focus` [ RunTime:0.003364s ]
SELECT `uid` FROM `aws_topic_focus` WHERE `topic_id` = 2 ORDER BY RAND() LIMIT 0,10 [ RunTime:0.000397s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.008533s ]
SELECT `item_id`,`item_type` FROM `aws_topic_relation` WHERE ( status=1 AND topic_id IN(2) ) [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.001521s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') AND `item_id` IN (1,22,9,33,27,36,40,43,46,47,51,52,42,53,54,55,58,16,59,61,60,65,66,67,68,69,70,71,72,32,34,74,78,83,84) AND `item_type` IN ('question','article') LIMIT 1 [ RunTime:0.003075s ]
SELECT `id`,`item_id`,`item_type`,`uid` FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') AND `item_id` IN (1,22,9,33,27,36,40,43,46,47,51,52,42,53,54,55,58,16,59,61,60,65,66,67,68,69,70,71,72,32,34,74,78,83,84) AND `item_type` IN ('question','article') ORDER BY `set_top_time` DESC,`create_time` DESC LIMIT 15,15 [ RunTime:0.021103s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000909s ]
SELECT `last_answer` FROM `aws_question` WHERE `id` = 16 AND `status` = 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000685s ]
SELECT * FROM `aws_answer` WHERE `status` = 1 AND `id` = 1 [ RunTime:0.000422s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` = 16 AND `item_type` = 'question' [ RunTime:0.000440s ]
SELECT * FROM `aws_topic` WHERE `id` IN (78,2) [ RunTime:0.000394s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` = 16 [ RunTime:0.010984s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (66,65,61,60,59,58,55,54,53,52,51,47,46,43) AND `item_type` = 'article' [ RunTime:0.000772s ]
SELECT * FROM `aws_topic` WHERE `id` IN (2,59,60,66,67,27,69,70,72,55,73,74,77,80) [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.000891s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` IN (66,65,61,60,59,58,55,54,53,52,51,47,46,43) [ RunTime:0.001807s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.001055s ]
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 (56,65,1,32) [ RunTime:0.000692s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000281s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000255s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 32 LIMIT 1 [ RunTime:0.000266s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 32 LIMIT 1 [ RunTime:0.000225s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 56 LIMIT 1 [ RunTime:0.000227s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 56 LIMIT 1 [ RunTime:0.000214s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000222s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000223s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000510s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 66 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000301s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 65 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000283s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 61 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000295s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 60 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000295s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 59 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000445s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 16 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000290s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 58 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000276s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 55 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000289s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 54 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000300s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 53 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000342s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 52 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000284s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 51 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000293s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 47 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000277s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 46 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000291s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 43 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 LIMIT 1 [ RunTime:0.000466s ]
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.000791s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 31 LIMIT 1 [ RunTime:0.000318s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 48 LIMIT 1 [ RunTime:0.000276s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 67 LIMIT 1 [ RunTime:0.000267s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 6 LIMIT 1 [ RunTime:0.000236s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 30 LIMIT 1 [ RunTime:0.000246s ]
林威
发起了提问
2022-05-31 01:29
