# Debug pagination sql and set limit in controller

**URL:** <https://discourse.cakephp.org/t/debug-pagination-sql-and-set-limit-in-controller/2066>\
**Category:** Need Help\
**Created:** [February 14, 2017, 10:22am UTC](https://discourse.cakephp.org/t/debug-pagination-sql-and-set-limit-in-controller/2066 "2017-02-14T10:22:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shakil](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@shakil](https://discourse.cakephp.org/u/shakil)\
**Post date:** [February 14, 2017, 10:22am UTC](https://discourse.cakephp.org/t/debug-pagination-sql-and-set-limit-in-controller/2066/1 "2017-02-14T10:22:08Z")

</div>

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.