Debug pagination sql and set limit in controller

Hi,
i am unable to debug pagination query in controller and its limit is not working.

Any help or suggestion will be thankful and appreciating.