How to debug a Paged Record Query?

If you’re developing locally and using MySQL, I would very much recommend setting things up so you have access to the query log. This will show you exactly what queries are run, as they’re executed - not showing variables etc.

This has cropped up in a few threads, eg this one which suggested using Wappler’s terminal. I actually prefer to display the log in a text editor most of the time, set so the output is automatically updated.