SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000553s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000587s ]
SELECT * FROM `aws_config` [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000511s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000397s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000427s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1746492144 [ RunTime:0.007068s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000443s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000393s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000292s ]
SHOW FULL COLUMNS FROM `aws_links` [ RunTime:0.000472s ]
SELECT * FROM `aws_links` WHERE `status` = 1 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.000548s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `item_type` IN ('question','article','') LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`item_id`,`item_type`,`uid` FROM `aws_post_relation` WHERE `item_type` IN ('question','article','') ORDER BY RAND(),`is_recommend` DESC LIMIT 105,15 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000556s ]
SELECT `last_answer` FROM `aws_question` WHERE `id` IN (23,22) AND `status` = 1 [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000490s ]
SELECT * FROM `aws_answer` WHERE `status` = 1 AND `id` = 0 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.000427s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (23,22) AND `item_type` = 'question' [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000420s ]
SELECT * FROM `aws_topic` WHERE `id` = 18 [ RunTime:0.000266s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` IN (23,22) [ RunTime:0.000575s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` IN (36,66,33,83,80,20,39,46) AND `item_type` = 'article' [ RunTime:0.000361s ]
SELECT * FROM `aws_topic` WHERE `id` IN (32,33,2,29,27,66,67,80,86) [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.000780s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` IN (36,66,33,83,80,20,39,46) [ RunTime:0.003028s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.000766s ]
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,56,5,1,65) [ RunTime:0.000502s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000238s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000219s ]
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.000204s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000220s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 55 LIMIT 1 [ RunTime:0.000200s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 56 LIMIT 1 [ RunTime:0.000220s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 56 LIMIT 1 [ RunTime:0.000199s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000235s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000449s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 36 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000319s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 66 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000258s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 33 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000465s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 23 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000258s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 83 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000268s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 80 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000235s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 20 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000255s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 22 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000234s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 39 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000248s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 46 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `aws_announce` [ RunTime:0.000467s ]
SELECT * FROM `aws_announce` WHERE `status` = 1 ORDER BY `set_top_time` DESC,`sort` DESC LIMIT 0,3 [ RunTime:0.000277s ]
SELECT COUNT(*) AS think_count FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 LIMIT 1 [ RunTime:0.000376s ]
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.000535s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 70 LIMIT 1 [ RunTime:0.000267s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 43 LIMIT 1 [ RunTime:0.000237s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 17 LIMIT 1 [ RunTime:0.000220s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 73 LIMIT 1 [ RunTime:0.000208s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 75 LIMIT 1 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `aws_column` [ RunTime:0.000485s ]
SELECT * FROM `aws_column` WHERE `verify` = 1 ORDER BY RAND(),`view_count` DESC LIMIT 0,5 [ RunTime:0.000439s ]
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.000975s ]
SHOW FULL COLUMNS FROM `aws_users_follow` [ RunTime:0.000402s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 5 LIMIT 1 [ RunTime:0.000243s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 44 LIMIT 1 [ RunTime:0.000210s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 44 LIMIT 1 [ RunTime:0.000210s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 15 LIMIT 1 [ RunTime:0.000210s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 15 LIMIT 1 [ RunTime:0.000212s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 33 LIMIT 1 [ RunTime:0.000231s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 33 LIMIT 1 [ RunTime:0.000212s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 56 LIMIT 1 [ RunTime:0.000215s ]
长尾科技
发起了提问
2022-06-07 10:29
