EXPLAIN SELECT t.*,c.depth,c.basic,c.catname,c.subname,c.codename,c.urlrules,c.prefix,c.caturl,c.target,c.color ,ti.attachment,ti.remote,ti.thumb,ti.preview,ti.attachimg,f.voteup,f.votedown,f.voters,f.totalscore,f.credits,m.*
FROM pc_threads t
LEFT JOIN pc_category c USING(catid) LEFT JOIN pc_thread_image ti USING(tid) LEFT JOIN pc_thread_field f USING(tid) LEFT JOIN pc_article_thread m ON t.tid=m.tid
WHERE t.status='1' AND t.rootid='80' AND t.topline='1' AND t.digest='5' ORDER BY t.tid DESC LIMIT 5;
EXPLAIN SELECT t.*,c.depth,c.basic,c.catname,c.subname,c.codename,c.urlrules,c.prefix,c.caturl,c.target,c.color ,ti.attachment,ti.remote,ti.thumb,ti.preview,ti.attachimg,f.voteup,f.votedown,f.voters,f.totalscore,f.credits,m.*
FROM pc_threads t
LEFT JOIN pc_category c USING(catid) LEFT JOIN pc_thread_image ti USING(tid) LEFT JOIN pc_thread_field f USING(tid) LEFT JOIN pc_article_thread m ON t.tid=m.tid
WHERE t.status='1' AND t.rootid='86' AND t.dateline>='1748707200' ORDER BY t.hits DESC, t.dateline DESC LIMIT 5;
EXPLAIN SELECT t.*,c.depth,c.basic,c.catname,c.subname,c.codename,c.urlrules,c.prefix,c.caturl,c.target,c.color ,ti.attachment,ti.remote,ti.thumb,ti.preview,ti.attachimg,f.voteup,f.votedown,f.voters,f.totalscore,f.credits,m.*
FROM pc_threads t
LEFT JOIN pc_category c USING(catid) LEFT JOIN pc_thread_image ti USING(tid) LEFT JOIN pc_thread_field f USING(tid) LEFT JOIN pc_soft_thread m ON t.tid=m.tid
WHERE t.status='1' AND t.catid='128' AND t.topline='1' AND t.digest='1' AND m.softsize > '0' ORDER BY t.tid DESC LIMIT 6;
倩女幽魂手游
无限射击
雷电2016
找毛线手游
天天酷跑
开心萌宠
EXPLAIN SELECT t.*,c.depth,c.basic,c.catname,c.subname,c.codename,c.urlrules,c.prefix,c.caturl,c.target,c.color ,ti.attachment,ti.remote,ti.thumb,ti.preview,ti.attachimg,f.voteup,f.votedown,f.voters,f.totalscore,f.credits,m.*
FROM pc_threads t
LEFT JOIN pc_category c USING(catid) LEFT JOIN pc_thread_image ti USING(tid) LEFT JOIN pc_thread_field f USING(tid) LEFT JOIN pc_soft_thread m ON t.tid=m.tid
WHERE t.status='1' AND t.catid='128' AND m.softsize > '0' ORDER BY t.tid DESC LIMIT 6;
鄂公网安 42011102000603