56,677
社区成员
发帖
与我相关
我的任务
分享
Count: 204677 Time=6.27s (1283970s) Lock=0.01s (1284s) Rows=10.0 (2046671), 2users@localhost
SELECT SQL_CALC_FOUND_ROWS padwp_posts.* FROM padwp_posts WHERE N=N AND padwp_posts.post_type = 'S' AND (padwp_posts.post_status = 'S') ORDER BY RAND() DESC LIMIT N, N
Count: 3967 Time=25.99s (103090s) Lock=21.13s (83834s) Rows=8.0 (31736), 2users@localhost
SELECT arc.*, category.namerule, category.typedir, category.moresite, category.siteurl, category.sitepath, mem.userid
FROM dede_archives arc
LEFT JOIN dede_arctype category ON category.id=arc.typeid
LEFT JOIN dede_member mem ON mem.mid=arc.mid
WHERE arc.arcrank > -N
ORDER BY arc.sortrank DESC LIMIT N