SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000537s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000553s ]
SELECT * FROM `aws_config` [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000573s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000507s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000497s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1773775383 [ RunTime:0.005174s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.000673s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000411s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `aws_question` [ RunTime:0.000665s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` = 31 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `aws_question` SET `view_count` = `view_count` + 1 WHERE `id` = 31 [ RunTime:0.005315s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` = 31 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `aws_question` SET `popular_value` = '0.00017234062509673' , `popular_value_update` = 1773778983 WHERE `id` = 31 [ RunTime:0.004687s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.000555s ]
UPDATE `aws_post_relation` SET `popular_value` = '0.00017234062509673' WHERE `item_id` = 31 AND `item_type` = 'question' [ RunTime:0.005613s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.000668s ]
SELECT * FROM `aws_users` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `aws_users_extends` [ RunTime:0.000477s ]
SELECT `uid`,`notify_setting`,`inbox_setting` FROM `aws_users_extends` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000344s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000310s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000343s ]
SELECT `reputation_group_id`,`group_id`,`integral_group_id` FROM `aws_users` WHERE `uid` = 5 LIMIT 1 [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `aws_users_reputation_group` [ RunTime:0.000445s ]
SELECT title as group_name,`permission`,`group_icon` FROM `aws_users_reputation_group` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `aws_users_permission` [ RunTime:0.000408s ]
SELECT `value`,`name` FROM `aws_users_permission` WHERE ( `group` = 'common' OR `group`='reputation' ) [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `aws_users_follow` [ RunTime:0.000550s ]
SELECT `id` FROM `aws_users_follow` WHERE `fans_uid` = 0 AND `friend_uid` = 5 LIMIT 1 [ RunTime:0.000341s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.000585s ]
SELECT `topic_id` FROM `aws_topic_relation` WHERE `item_type` = 'question' AND `item_id` = 31 [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000621s ]
SELECT `id`,`title`,`url_token` FROM `aws_topic` WHERE `id` = 18 [ RunTime:0.000311s ]
SELECT * FROM `aws_question` WHERE `status` = 1 AND `id` = 31 LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `aws_question` WHERE ( status=1 AND (`title` regexp '如何|看待|格里菲斯|电动力学导论' OR `detail` regexp '如何|看待|格里菲斯|电动力学导论') ) AND `id` <> 31 ORDER BY RAND(),`view_count` DESC LIMIT 10 [ RunTime:0.002954s ]
SHOW FULL COLUMNS FROM `aws_report` [ RunTime:0.000570s ]
SELECT * FROM `aws_report` WHERE `item_id` = 31 AND `uid` = 0 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `aws_question_vote` [ RunTime:0.000515s ]
SELECT `vote_value` FROM `aws_question_vote` WHERE `uid` = 0 AND `item_id` = 31 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `aws_users_favorite` [ RunTime:0.000478s ]
SELECT * FROM `aws_users_favorite` WHERE `uid` = 0 AND `item_id` = 31 AND `item_type` = 'question' LIMIT 1 [ RunTime:0.000338s ]
SELECT `item_id`,`item_type` FROM `aws_topic_relation` WHERE ( item_type="question" AND status=1 AND item_type!="question" AND item_id!=31 AND topic_id IN(18) ) [ RunTime:0.000272s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `item_id` = 0 AND `popular_value` > '1' AND `item_type` = '' LIMIT 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `aws_answer` [ RunTime:0.000617s ]
SELECT COUNT(*) AS think_count FROM `aws_answer` WHERE `question_id` = 31 AND `is_best` = 1 LIMIT 1 [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `aws_attach` [ RunTime:0.000505s ]
SELECT * FROM `aws_attach` WHERE `item_type` = 'question_attach' AND `item_id` = 31 ORDER BY `id` DESC [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `aws_action` [ RunTime:0.000501s ]
SELECT `id` FROM `aws_action` WHERE `name` = 'publish_question' AND `status` = 1 [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `aws_action_log` [ RunTime:0.000479s ]
SELECT COUNT(*) AS think_count FROM `aws_action_log` WHERE `status` = 1 AND `uid` = 5 AND `action_id` = 2 AND `anonymous` = 0 LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `aws_action` WHERE `name` = 'publish_answer' AND `status` = 1 [ RunTime:0.000293s ]
SELECT COUNT(*) AS think_count FROM `aws_action_log` WHERE `status` = 1 AND `uid` = 5 AND `action_id` = 4 AND `anonymous` = 0 LIMIT 1 [ RunTime:0.000350s ]
SELECT `id` FROM `aws_action` WHERE `name` = 'publish_article' AND `status` = 1 [ RunTime:0.000312s ]
SELECT COUNT(*) AS think_count FROM `aws_action_log` WHERE `status` = 1 AND `uid` = 5 AND `action_id` = 3 AND `anonymous` = 0 LIMIT 1 [ RunTime:0.000336s ]
SELECT COUNT(*) AS think_count FROM `aws_answer` WHERE `question_id` = 31 AND `status` = 1 LIMIT 1 [ RunTime:0.000302s ]
暂无回答
