how can i see what sql is used

If you're in development mode, the SQL queries are all available in the development.log file.

Alternatively if you run script/server and keep the terminal window open you'll see them live in there too.

Ross