Yii Framework: logging DB queries and params

gistfile1.php

// In the app configuration:

  'components' => array(
  	'db' => array(
			'enableParamLogging' => true, // self explanatory
		), 

  	'log' => array(
			'routes' => array(
				array(
					'class' => 'CFileLogRoute',
				  'categories' => 'system.db.CDbCommand', // and other properties appropriate for the log route, e. g. filename
				),
			),
		),
  ),