SHOW FULL COLUMNS FROM `aws_hook_plugins` [ RunTime:0.000742s ]
SELECT `hook`,`plugins` FROM `aws_hook_plugins` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `aws_config` [ RunTime:0.000651s ]
SELECT * FROM `aws_config` [ RunTime:0.000726s ]
SHOW FULL COLUMNS FROM `aws_forbidden_ip` [ RunTime:0.000649s ]
SELECT `ip` FROM `aws_forbidden_ip` [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `aws_admin_group` [ RunTime:0.000586s ]
SELECT `permission` FROM `aws_admin_group` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `aws_users_online` [ RunTime:0.000578s ]
DELETE FROM `aws_users_online` WHERE `last_login_time` < 1773779034 [ RunTime:0.035162s ]
SHOW FULL COLUMNS FROM `aws_menu_rule` [ RunTime:0.050338s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'nav' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007786s ]
SELECT * FROM `aws_menu_rule` WHERE `status` = 1 AND `group` = 'footer' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.017627s ]
SHOW FULL COLUMNS FROM `aws_article` [ RunTime:0.024008s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` = 42 LIMIT 1 [ RunTime:0.002246s ]
UPDATE `aws_article` SET `view_count` = `view_count` + 1 WHERE `id` = 42 [ RunTime:0.019128s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` = 42 LIMIT 1 [ RunTime:0.000794s ]
UPDATE `aws_article` SET `popular_value` = '0.0002257958852484' , `popular_value_update` = 1773782634 WHERE `id` = 42 [ RunTime:0.016884s ]
SHOW FULL COLUMNS FROM `aws_post_relation` [ RunTime:0.000744s ]
UPDATE `aws_post_relation` SET `popular_value` = '0.0002257958852484' WHERE `item_id` = 42 AND `item_type` = 'article' [ RunTime:0.008182s ]
SHOW FULL COLUMNS FROM `aws_report` [ RunTime:0.000632s ]
SELECT * FROM `aws_report` WHERE `item_id` = 42 AND `uid` = 0 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `aws_article_vote` [ RunTime:0.000631s ]
SELECT `vote_value` FROM `aws_article_vote` WHERE `uid` = 0 AND `item_id` = 42 AND `item_type` = 'article' LIMIT 1 [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `aws_users_favorite` [ RunTime:0.000673s ]
SELECT `id` FROM `aws_users_favorite` WHERE `item_type` = 'article' AND `item_id` = 42 AND `uid` = 0 LIMIT 1 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `aws_users` [ RunTime:0.000846s ]
SELECT * FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000607s ]
SHOW FULL COLUMNS FROM `aws_users_extends` [ RunTime:0.000577s ]
SELECT `uid`,`notify_setting`,`inbox_setting` FROM `aws_users_extends` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000329s ]
SELECT `last_login_time` FROM `aws_users_online` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.001497s ]
SELECT `user_name`,`url_token` FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.004313s ]
SELECT `reputation_group_id`,`group_id`,`integral_group_id` FROM `aws_users` WHERE `uid` = 65 LIMIT 1 [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `aws_users_reputation_group` [ RunTime:0.000617s ]
SELECT title as group_name,`permission`,`group_icon` FROM `aws_users_reputation_group` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `aws_users_permission` [ RunTime:0.000575s ]
SELECT `value`,`name` FROM `aws_users_permission` WHERE ( `group` = 'common' OR `group`='reputation' ) [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `aws_topic_relation` [ RunTime:0.010396s ]
SELECT `topic_id` FROM `aws_topic_relation` WHERE `item_type` = 'article' AND `item_id` = 42 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `aws_topic` [ RunTime:0.000731s ]
SELECT `id`,`title`,`url_token` FROM `aws_topic` WHERE `id` = 2 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `aws_column` [ RunTime:0.000788s ]
SELECT `name`,`description`,`cover`,`focus_count`,`view_count`,`post_count` FROM `aws_column` WHERE `id` = 5 AND `verify` = 1 LIMIT 1 [ RunTime:0.000371s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` = 42 LIMIT 1 [ RunTime:0.000841s ]
SELECT * FROM `aws_article` WHERE ( status=1 and (title regexp'物理|图像|如何') ) ORDER BY RAND(),`view_count` DESC LIMIT 10 [ RunTime:0.016341s ]
SELECT * FROM `aws_article` WHERE `status` = 1 AND `id` IN (72,10,16,60,18,78,33,59,26) [ RunTime:0.007019s ]
SELECT `item_id`,`item_type` FROM `aws_topic_relation` WHERE ( item_type="article" AND status=1 AND item_type!="article" AND item_id!=42 AND topic_id IN(2) ) [ RunTime:0.000509s ]
SELECT COUNT(*) AS think_count FROM `aws_post_relation` WHERE `item_id` = 0 AND `popular_value` > '1' AND `item_type` = '' LIMIT 1 [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `aws_article_comment` [ RunTime:0.000750s ]
SELECT COUNT(*) AS think_count FROM `aws_article_comment` WHERE `article_id` = 42 AND `status` = 1 LIMIT 1 [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `aws_attach` [ RunTime:0.000765s ]
SELECT * FROM `aws_attach` WHERE `item_type` = 'article_attach' AND `item_id` = 42 ORDER BY `id` DESC [ RunTime:0.000502s ]
。
全部 0条评论