I has enabled CProfileLogRoute in the config/main.php as following,
array(
'class' => 'CProfileLogRoute',
'levels' => 'profile',
),
It show all sql query at the bottom of each page.
However, some of the action end up with "return $this->redirect(XXXXX)";
The result of profiling will just show the query of that redirected page,
all the query before redirect just gone…
I tried to change CProfileLogRoute to CFileLogRoute,
but the log are very hard to read, and also not showing the query time…
Do you have any workaround on this?
Thank you very much.