使用连接进行限制X，Y MySQL查询运行速度更快

I have a MySQL query with a particular structure that I want to rewrite so that it runs faster. It currently runs very slow taking about 255 seconds to execute. If I remove the join it runs in < 10 seconds. Its purpose is to get records from table A, 100 rows at a time, for as long as a user wants to see more rows. I have a MySQL query with a particular structur