MYSQL，很慢的顺序

似乎您正遭受MySQL无法进行后期行查找的困扰：

• MySQL ORDER BY / LIMIT性能：晚行查找
• 后排查询：InnoDB

尝试这个：

SELECt  p.*, u.*FROM    (        SELECt  id        FROM    photo        ORDER BY     uploaddate DESC, id DESC        LIMIT   10        OFFSET  100000        ) piJOIN    photo pON      p.id = pi.idJOIN    user uON      u.user_id = p.user_id