取出文章标题表前十个(到文章内容表中找对应内容)
select uid, username, pre_home_blog.blogid, subject, FROM_UNIXTIME(dateline, '%Y-%m-%d %H:%i:%S') shijian, message from pre_home_blog
left join (select blogid, message from pre_home_blogfield order by blogid desc) blogcontent on pre_home_blog.blogid = blogcontent.blogid
order by dateline desc limit 0, 10哪里的问题呢
select uid, username, pre_home_blog.blogid, subject, FROM_UNIXTIME(dateline, '%Y-%m-%d %H:%i:%S') shijian, message from pre_home_blog
left join (select blogid, message from pre_home_blogfield order by blogid desc) blogcontent on pre_home_blog.blogid = blogcontent.blogid
order by dateline desc limit 0, 10哪里的问题呢
left join (select blogid, message from pre_home_blogfield order by blogid desc) blogcontent on pre_home_blog.blogid = blogcontent.blogid
order by dateline desc limit 0, 10贴出来看一下,估计是语句执行需要过长时间,如果有可能建议优化一下。