SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000696s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000395s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000814s ]
SELECT * FROM `aws_config` [ RunTime:0.000665s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000777s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000610s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000522s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1765004188 [ RunTime:0.005296s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000503s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000345s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `aws_links` [ RunTime:0.000517s ]
SELECT * FROM `aws_links` WHERE `status` = 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.000574s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`item_id`,`item_type`,`uid` FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') ORDER BY `set_top_time` DESC,`update_time` DESC,`create_time` DESC LIMIT 60,15 [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000661s ]
SELECT `last_answer` FROM `aws_question` WHERE `id` IN (12,10) AND `status` = 1 [ RunTime:0.000347s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000531s ]
SELECT * FROM `aws_answer` WHERE `status` = 1 AND `id` IN (13,15) [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.000512s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (12,10) AND `item_type` = 'question' [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000518s ]
SELECT * FROM `aws_topic` WHERE `id` IN (9,61,3) [ RunTime:0.000380s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` IN (12,10) [ RunTime:0.000706s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (48,47,46,45,44,43,42,41,40,39,38,37,36) AND `item_type` = 'article' [ RunTime:0.000563s ]
SELECT * FROM `aws_topic` WHERE `id` IN (2,53,54,19,18,27,55,57,58,62,20,65,59,60,66,67) [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.000775s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` IN (48,47,46,45,44,43,42,41,40,39,38,37,36) [ RunTime:0.006367s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.001009s ]
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 (90,65,12,87,76,55,1,13) [ RunTime:0.000561s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000245s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000213s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 12 LIMIT 1 [ RunTime:0.000207s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 12 LIMIT 1 [ RunTime:0.000217s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 13 LIMIT 1 [ RunTime:0.000203s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 13 LIMIT 1 [ RunTime:0.000211s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000214s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000210s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000204s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000199s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 76 LIMIT 1 [ RunTime:0.000201s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 76 LIMIT 1 [ RunTime:0.000198s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 87 LIMIT 1 [ RunTime:0.000206s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 87 LIMIT 1 [ RunTime:0.000197s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 90 LIMIT 1 [ RunTime:0.000201s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 90 LIMIT 1 [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000501s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 48 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000299s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 47 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000265s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 46 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000244s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 45 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000281s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 44 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000474s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 15 AND `item_type` = 'answer' LIMIT 1 [ RunTime:0.000259s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 12 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000243s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 43 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000260s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 42 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000246s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 41 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000311s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 13 AND `item_type` = 'answer' LIMIT 1 [ RunTime:0.000252s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 10 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000253s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 40 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000250s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 39 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000245s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 38 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000293s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 37 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000286s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 36 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `aws_announce` [ RunTime:0.000601s ]
SELECT * FROM `aws_announce` WHERE `status` = 1 ORDER BY `set_top_time` DESC,`sort` DESC LIMIT 0,3 [ RunTime:0.000294s ]
SELECT COUNT(*) AS think_count FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 LIMIT 1 [ RunTime:0.000395s ]
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.000678s ]
SHOW FULL COLUMNS FROM `aws_topic_focus` [ RunTime:0.000418s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 42 LIMIT 1 [ RunTime:0.000239s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 62 LIMIT 1 [ RunTime:0.000224s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 27 LIMIT 1 [ RunTime:0.000211s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 86 LIMIT 1 [ RunTime:0.000219s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 18 LIMIT 1 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `aws_column` [ RunTime:0.000508s ]
SELECT * FROM `aws_column` WHERE `verify` = 1 ORDER BY RAND(),`view_count` DESC LIMIT 0,5 [ RunTime:0.000459s ]
SELECT * FROM `aws_users` WHERE `uid` <> 0 AND `status` = 1 AND `reputation` > 0 ORDER BY RAND(),`reputation` DESC,`answer_count` DESC LIMIT 5 [ RunTime:0.000988s ]
SHOW FULL COLUMNS FROM `aws_users_follow` [ RunTime:0.000401s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 12 LIMIT 1 [ RunTime:0.000246s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 36 LIMIT 1 [ RunTime:0.000209s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 36 LIMIT 1 [ RunTime:0.000216s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 37 LIMIT 1 [ RunTime:0.000197s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 37 LIMIT 1 [ RunTime:0.000228s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 10 LIMIT 1 [ RunTime:0.000209s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 10 LIMIT 1 [ RunTime:0.000236s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 65 LIMIT 1 [ RunTime:0.000237s ]
Jakob齐斋
回复了问题
2022-05-27 23:01
林威
回复了问题
2022-05-27 02:43
