How do I log all sql queries?

Yii 2.0 General Discussions
1

I highly suspect I’m being stupid here, but how would I go about logging all SQL queries. We’re about to launch a site, and whilst it’s in a closed beta I’d like to log everything to make it easier to debug the feedback we’re getting from customers, but I can’t figure a way to do it? I’m sure it’s something trivial.

Help greatly appreciated,

Cheers

Alan

2

Well, one of the easiest way to do it, is to setup monitoring on the database level. Problem, in many databases this is costly tools.

3

Aye :). We’re using MariaDB and I don’t really want to turn something like the general_log for this, it also makes debugging harder as you can’t see the application logging / database logs in the same file.