A quick update. Today I found a very nice Yii plugin which allows for profiling of your sql queries. Very usefull if you want to analyze the performance of your application.

The plugin can be found at : http://www.yiiframework.com/extension/dbprofiler/