Yii打印Sql

想查看如下结果&＃xff0c;但由于较大&＃xff0c;var_dump时浏览器会崩溃&＃xff0c;于是想到如果知道执行的sql是什么&＃xff0c;那么就可以推出执行后的结果是什么。 


//1&＃xff0c;在 ../config/main.php里增加&＃39;class&＃39;&＃61;>&＃39;CProfileLogRoute&＃39;
&＃39;log&＃39;&＃61;>array( &＃39;class&＃39;&＃61;>&＃39;CLogRouter&＃39;, &＃39;routes&＃39;&＃61;>array( array( &＃39;class&＃39;&＃61;>&＃39;CFileLogRoute&＃39;, &＃39;levels&＃39;&＃61;>&＃39;error, warning&＃39;, ), /* 此处为本次增加 */ array( &＃39;class&＃39;&＃61;>&＃39;CProfileLogRoute&＃39;, ), // uncomment the following to show log messages on web pages /* array( &＃39;class&＃39;&＃61;>&＃39;CWebLogRoute&＃39;, ), */ ), ), //2&＃xff0c;在源码处增加三行代码
$c &＃61; new CDbCriteria();
$c->join &＃61; "JOIN idc_user on t.id&＃61;idc_user.user_id";
$c->condition &＃61; "idc_user.idc_id&＃61;$idc_id"; Yii::beginProfile(&＃39;block1&＃39;);
$r &＃61; User::model()->with(&＃39;Idcs&＃39;)->findAll($c);
Yii::endProfile(&＃39;block1&＃39;); //整理打印结果如下
SELECT &＃96;t&＃96;.&＃96;id&＃96; AS &＃96;t0_c0&＃96; , &＃96;t&＃96;.&＃96;username&＃96; AS &＃96;t0_c1&＃96; , &＃96;t&＃96;.&＃96;password&＃96; AS &＃96;t0_c2&＃96; , &＃96;t&＃96;.&＃96;display_name&＃96; AS &＃96;t0_c3&＃96; , &＃96;t&＃96;.&＃96;tel&＃96; AS &＃96;t0_c4&＃96; , &＃96;t&＃96;.&＃96;mobile&＃96; AS &＃96;t0_c5&＃96; , &＃96;t&＃96;.&＃96;email&＃96; AS &＃96;t0_c6&＃96; , &＃96;t&＃96;.&＃96;hi_id&＃96; AS &＃96;t0_c7&＃96; , &＃96;t&＃96;.&＃96;company_id&＃96; AS &＃96;t0_c8&＃96; , &＃96;t&＃96;.&＃96;last_login_at&＃96; AS &＃96;t0_c9&＃96; , &＃96;t&＃96;.&＃96;last_pwd_updated_at&＃96; AS &＃96;t0_c10&＃96; , &＃96;t&＃96;.&＃96;created_at&＃96; AS &＃96;t0_c11&＃96; , &＃96;Idcs&＃96;.&＃96;id&＃96; AS &＃96;t1_c0&＃96; , &＃96;Idcs&＃96;.&＃96;name&＃96; AS &＃96;t1_c1&＃96; , &＃96;Idcs&＃96;.&＃96;desc&＃96; AS &＃96;t1_c2&＃96; , &＃96;Idcs&＃96;.&＃96;created_at&＃96; AS &＃96;t1_c3&＃96; , &＃96;Idcs&＃96;.&＃96;chinese_name&＃96; AS &＃96;t1_c4&＃96; , &＃96;Idcs&＃96;.&＃96;clientele&＃96; AS &＃96;t1_c5&＃96; , &＃96;Idcs&＃96;.&＃96;contact_man&＃96; AS &＃96;t1_c6&＃96; , &＃96;Idcs&＃96;.&＃96;contact_phone&＃96; AS &＃96;t1_c7&＃96; , &＃96;Idcs&＃96;.&＃96;post_code&＃96; AS &＃96;t1_c8&＃96; , &＃96;Idcs&＃96;.&＃96;address&＃96; AS &＃96;t1_c9&＃96; , &＃96;Idcs&＃96;.&＃96;email&＃96; AS &＃96;t1_c10&＃96; , &＃96;Idcs&＃96;.&＃96;weight&＃96; AS &＃96;t1_c11&＃96; , &＃96;Idcs&＃96;.&＃96;pool_id&＃96; AS &＃96;t1_c12&＃96; , &＃96;Idcs&＃96;.&＃96;provider_id&＃96; AS &＃96;t1_c13&＃96;
FROM &＃96;user&＃96; &＃96;t&＃96;
JOIN idc_user ON t.id &＃61; idc_user.user_id
LEFT OUTER JOIN &＃96;idc_user&＃96; &＃96;Idcs_Idcs&＃96; ON ( &＃96;t&＃96;.&＃96;id&＃96; &＃61; &＃96;Idcs_Idcs&＃96;.&＃96;user_id&＃96; )
LEFT OUTER JOIN &＃96;idc&＃96; &＃96;Idcs&＃96; ON ( &＃96;Idcs&＃96;.&＃96;id&＃96; &＃61; &＃96;Idcs_Idcs&＃96;.&＃96;idc_id&＃96; )
WHERE (
idc_user.idc_id &＃61;6
) //打印结果如下
block2 1 0.01122 0.01122 0.01122 0.01122
system.db.CDbCommand.query(SELECT &＃96;t&＃96;.&＃96;id&＃96; AS &＃96;t0_c0&＃96;, &＃96;t&＃96;.&＃96;username&＃96; AS &＃96;t0_c1&＃96;, &＃96;t&＃96;.&＃96;password&＃96; AS &＃96;t0_c2&＃96;, &＃96;t&＃96;.&＃96;display_name&＃96; AS &＃96;t0_c3&＃96;, &＃96;t&＃96;.&＃96;tel&＃96; AS &＃96;t0_c4&＃96;, &＃96;t&＃96;.&＃96;mobile&＃96; AS &＃96;t0_c5&＃96;, &＃96;t&＃96;.&＃96;email&＃96; AS &＃96;t0_c6&＃96;, &＃96;t&＃96;.&＃96;hi_id&＃96; AS &＃96;t0_c7&＃96;, &＃96;t&＃96;.&＃96;company_id&＃96; AS &＃96;t0_c8&＃96;, &＃96;t&＃96;.&＃96;last_login_at&＃96; AS &＃96;t0_c9&＃96;, &＃96;t&＃96;.&＃96;last_pwd_updated_at&＃96; AS &＃96;t0_c10&＃96;, &＃96;t&＃96;.&＃96;created_at&＃96; AS &＃96;t0_c11&＃96;, &＃96;Idcs&＃96;.&＃96;id&＃96; AS &＃96;t1_c0&＃96;, &＃96;Idcs&＃96;.&＃96;name&＃96; AS &＃96;t1_c1&＃96;, &＃96;Idcs&＃96;.&＃96;desc&＃96; AS &＃96;t1_c2&＃96;, &＃96;Idcs&＃96;.&＃96;created_at&＃96; AS &＃96;t1_c3&＃96;, &＃96;Idcs&＃96;.&＃96;chinese_name&＃96; AS &＃96;t1_c4&＃96;, &＃96;Idcs&＃96;.&＃96;clientele&＃96; AS &＃96;t1_c5&＃96;, &＃96;Idcs&＃96;.&＃96;contact_man&＃96; AS &＃96;t1_c6&＃96;, &＃96;Idcs&＃96;.&＃96;contact_phone&＃96; AS &＃96;t1_c7&＃96;, &＃96;Idcs&＃96;.&＃96;post_code&＃96; AS &＃96;t1_c8&＃96;, &＃96;Idcs&＃96;.&＃96;address&＃96; AS &＃96;t1_c9&＃96;, &＃96;Idcs&＃96;.&＃96;email&＃96; AS &＃96;t1_c10&＃96;, &＃96;Idcs&＃96;.&＃96;weight&＃96; AS &＃96;t1_c11&＃96;, &＃96;Idcs&＃96;.&＃96;pool_id&＃96; AS &＃96;t1_c12&＃96;, &＃96;Idcs&＃96;.&＃96;provider_id&＃96; AS &＃96;t1_c13&＃96; FROM &＃96;user&＃96; &＃96;t&＃96; JOIN idc_user on t.id&＃61;idc_user.user_id LEFT OUTER JOIN &＃96;idc_user&＃96; &＃96;Idcs_Idcs&＃96; ON (&＃96;t&＃96;.&＃96;id&＃96;&＃61;&＃96;Idcs_Idcs&＃96;.&＃96;user_id&＃96;) LEFT OUTER JOIN &＃96;idc&＃96; &＃96;Idcs&＃96; ON (&＃96;Idcs&＃96;.&＃96;id&＃96;&＃61;&＃96;Idcs_Idcs&＃96;.&＃96;idc_id&＃96;) WHERE (idc_user.idc_id&＃61;6)) 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SHOW COLUMNS FROM &＃96;user&＃96;) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SHOW COLUMNS FROM &＃96;idc&＃96;) 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SHOW COLUMNS FROM &＃96;idc_user&＃96;) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query( SELECT data FROM YiiSession WHERE expire>1339135578 AND id&＃61;:id ) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM &＃96;user&＃96; &＃96;t&＃96; WHERE &＃96;t&＃96;.&＃96;id&＃96;&＃61;8 LIMIT 1) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SHOW CREATE TABLE &＃96;user&＃96;) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE &＃96;idc&＃96;) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE &＃96;idc_user&＃96;) 1 0.00036 0.00036 0.00036 0.00036