SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000470s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000646s ]
SELECT * FROM `aws_config` [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000727s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000453s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000452s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000506s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1765003079 [ RunTime:0.004528s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000761s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000512s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000446s ]
SELECT * FROM `aws_topic` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `aws_topic_focus` [ RunTime:0.000608s ]
SELECT `uid` FROM `aws_topic_focus` WHERE `topic_id` = 2 ORDER BY RAND() LIMIT 0,10 [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.000666s ]
SELECT `item_id`,`item_type` FROM `aws_topic_relation` WHERE ( status=1 AND topic_id IN(2) ) [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.000617s ]
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.000833s ]
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.000845s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000832s ]
SELECT `last_answer` FROM `aws_question` WHERE `id` = 16 AND `status` = 1 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000640s ]
SELECT * FROM `aws_answer` WHERE `status` = 1 AND `id` = 1 [ RunTime:0.000363s ]
SELECT `topic_id`,`item_type`,`item_id` FROM `aws_topic_relation` WHERE `item_id` = 16 AND `item_type` = 'question' [ RunTime:0.000408s ]
SELECT * FROM `aws_topic` WHERE `id` IN (78,2) [ RunTime:0.000441s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` = 16 [ RunTime:0.000647s ]
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.000781s ]
SELECT * FROM `aws_topic` WHERE `id` IN (2,59,60,66,67,27,69,70,72,55,73,74,77,80) [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.000864s ]
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.002302s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.001017s ]
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.000585s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000324s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 1 LIMIT 1 [ RunTime:0.000294s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 32 LIMIT 1 [ RunTime:0.000296s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 32 LIMIT 1 [ RunTime:0.000266s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 56 LIMIT 1 [ RunTime:0.000229s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 56 LIMIT 1 [ RunTime:0.000202s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000208s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000488s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 66 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000267s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 65 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000248s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 61 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000237s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 60 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000254s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 59 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000416s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 16 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000248s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 58 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000265s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 55 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000252s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 54 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000241s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 53 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000267s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 52 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000294s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 51 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000261s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 47 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000275s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 46 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000248s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 43 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000265s ]
SELECT COUNT(*) AS think_count FROM `aws_topic` WHERE `status` = 1 AND `discuss_month` > 0 LIMIT 1 [ RunTime:0.000405s ]
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.000688s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 18 LIMIT 1 [ RunTime:0.000255s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 75 LIMIT 1 [ RunTime:0.000255s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 78 LIMIT 1 [ RunTime:0.000241s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 17 LIMIT 1 [ RunTime:0.000217s ]
SELECT `id` FROM `aws_topic_focus` WHERE `uid` = 0 AND `topic_id` = 29 LIMIT 1 [ RunTime:0.000204s ]
林威
发起了提问
2022-05-31 01:29
