建立新闻管理系统（全文）

AND n。发布`< =现在（） GROUP BY n .id`，u .screenname` ORDER BY n。 `sticky` DESC，n。发表`DESC LIMIT 12" COUNT（f .id`）AS''fullbody''是确定是否有一个阅读更多 链接应该出现。 为什么哦为什么这么慢？我真的希望有人可以提供帮助，因为我现在已经花了好几个星期的时间尝试了几个星期但是无法理解...... :( Frizzle。get_news = mysql_query("SELECT n.`id`, n.`published`, n.`title`,n.`url`, n.`body`, n.`commentable`,COUNT(f.`id`) AS ''fullbody'',COUNT(c.`id`) AS ''no_of_comments'',u.`screenname`, u.`email`FROM `ne_topics` nLEFT JOIN`ne_fulltopic` fON(f.`id` = n.`id`)LEFT JOIN`ne_comments` cON(c.`topic_id` = n.`id`)LEFT JOIN`gl_users` uON(u.`id` = n.`author_id`)WHEREn.`visible` = 1ANDn.`published` <= NOW()GROUP BYn.`id`, u.`screenname`ORDER BY n.`sticky` DESC, n.`published` DESCLIMIT 12"COUNT(f.`id`) AS ''fullbody'' is to determine wheter or not a "read more"link should appear.Why oh why is this sooo slow? I really hope someone can help, since i''mtrying things for weeks now but just cannot figure it out ... :(Frizzle. 这篇关于建立新闻管理系统（全文）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！