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