SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000670s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000870s ]
SELECT * FROM `aws_config` [ RunTime:0.000668s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000753s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000254s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000588s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000683s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1769885367 [ RunTime:0.045722s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000833s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000481s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `aws_links` [ RunTime:0.000734s ]
SELECT * FROM `aws_links` WHERE `status` = 1 [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.002205s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `status` = 1 AND `item_type` IN ('question','article','') LIMIT 1 [ RunTime:0.000507s ]
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 90,15 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000823s ]
SELECT `last_answer` FROM `aws_question` WHERE `id` = 7 AND `status` = 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000712s ]
SELECT * FROM `aws_answer` WHERE `status` = 1 AND `id` = 7 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.000603s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` = 7 AND `item_type` = 'question' [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000660s ]
SELECT * FROM `aws_topic` WHERE `id` = 3 [ RunTime:0.000382s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` = 7 [ RunTime:0.000583s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (25,24,22,21,20,18,15,16,17,13,14,12,11,9) AND `item_type` = 'article' [ RunTime:0.000736s ]
SELECT * FROM `aws_topic` WHERE `id` IN (20,13,28,19,29,30,31,32,33,34,38,36,2,35,18) [ RunTime:0.000555s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.010817s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` IN (25,24,22,21,20,18,15,16,17,13,14,12,11,9) [ RunTime:0.018317s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.001881s ]
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 (55,4,9,5,12) [ RunTime:0.000770s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 4 LIMIT 1 [ RunTime:0.000360s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 4 LIMIT 1 [ RunTime:0.000307s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000302s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000332s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 9 LIMIT 1 [ RunTime:0.000285s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 9 LIMIT 1 [ RunTime:0.000276s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 12 LIMIT 1 [ RunTime:0.000298s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 12 LIMIT 1 [ RunTime:0.000271s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000309s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000650s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 25 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000560s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 7 AND `item_type` = 'answer' LIMIT 1 [ RunTime:0.000359s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 7 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000321s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 24 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000358s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 22 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000340s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 21 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000382s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 20 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000381s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 18 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000362s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 15 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000340s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 16 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000357s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 17 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000343s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 13 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000364s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 14 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000400s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 12 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000357s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 11 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000338s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 9 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `aws_announce` [ RunTime:0.000756s ]
SELECT * FROM `aws_announce` WHERE `status` = 1 ORDER BY `set_top_time` DESC,`sort` DESC LIMIT 0,3 [ RunTime:0.000385s ]
SELECT COUNT(*) AS think_count FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 LIMIT 1 [ RunTime:0.000554s ]
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.001030s ]
SHOW FULL COLUMNS FROM `aws_topic_focus` [ RunTime:0.000585s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 40 LIMIT 1 [ RunTime:0.000340s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 84 LIMIT 1 [ RunTime:0.000299s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 35 LIMIT 1 [ RunTime:0.000313s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 81 LIMIT 1 [ RunTime:0.000291s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 75 LIMIT 1 [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `aws_column` [ RunTime:0.000663s ]
SELECT * FROM `aws_column` WHERE `verify` = 1 ORDER BY RAND(),`view_count` DESC LIMIT 0,5 [ RunTime:0.000642s ]
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.001553s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 36 LIMIT 1 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `aws_users_follow` [ RunTime:0.000608s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 36 LIMIT 1 [ RunTime:0.000305s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 32 LIMIT 1 [ RunTime:0.000284s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 32 LIMIT 1 [ RunTime:0.000299s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 5 LIMIT 1 [ RunTime:0.000293s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 9 LIMIT 1 [ RunTime:0.000311s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 10 LIMIT 1 [ RunTime:0.000274s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 10 LIMIT 1 [ RunTime:0.000296s ]
一块石头
回复了问题
2022-05-17 20:02
