|
楼主 |
发表于 2015-9-9 14:52:02
|
显示全部楼层
我这是不显示的,有什么办法把它弄出来?
我按照那上面的方法把sql打出来了,你看一下。
--> sql:SELECT s1.sID AS s1, s1.VERSION AS version, s1.SPERSONID AS sPersonID, s1.STHEMEACTIVITY AS sThemeActivity, s1.SFUNCTREE AS sFunctree, s1.SPORTAL AS sPortal, s1.SOTHER AS sOther, s1.SPUBLISHTYPE AS sPublishType, s1.STHEMENAME AS sThemeName FROM SA_Portal2Profiles s1 WHERE (s1.SPERSONID = ? ) AND (s1.SPUBLISHTYPE = ? )
--> binds:[PSN01, person4portal3]
2015-09-09 14:49:55 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT t1.* FROM Portal2Profiles t1 where t1.sThemeActivity='activity' and t1 IN (SELECT s1.sThemeID FROM Portal2ProfileManager s1 where s1.sOrgID=rgid and s1.sPublishType=:type)
--> sql:SELECT t1.sID AS t1, t1.VERSION AS version, t1.SPERSONID AS sPersonID, t1.STHEMEACTIVITY AS sThemeActivity, t1.SFUNCTREE AS sFunctree, t1.SPORTAL AS sPortal, t1.SOTHER AS sOther, t1.SPUBLISHTYPE AS sPublishType, t1.STHEMENAME AS sThemeName FROM SA_Portal2Profiles t1 WHERE (t1.STHEMEACTIVITY = ?) AND (t1.sID IN (SELECT s1.STHEMEID AS sThemeID FROM SA_Portal2ProfileManager s1 WHERE (s1.SORGID = ? ) AND (s1.SPUBLISHTYPE = ? ) ))
--> binds:[activity, PSN01@ORG01, portal3]
2015-09-09 14:49:55 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT s1.sParent FROM SA_OPOrg s1 where s1='PSN01@ORG01'
--> sql:SELECT s1.sParent AS sParent FROM SA_OPOrg s1 WHERE s1.sID = ?
--> binds:[PSN01@ORG01]
2015-09-09 14:49:55 [SQL Time]sql 执行时间:0ms, exec KSQL: SELECT t1.* FROM Portal2Profiles t1 where t1.sThemeActivity='activity' and t1 IN (SELECT s1.sThemeID FROM Portal2ProfileManager s1 where s1.sOrgID=rgid and s1.sPublishType=:type)
--> sql:SELECT t1.sID AS t1, t1.VERSION AS version, t1.SPERSONID AS sPersonID, t1.STHEMEACTIVITY AS sThemeActivity, t1.SFUNCTREE AS sFunctree, t1.SPORTAL AS sPortal, t1.SOTHER AS sOther, t1.SPUBLISHTYPE AS sPublishType, t1.STHEMENAME AS sThemeName FROM SA_Portal2Profiles t1 WHERE (t1.STHEMEACTIVITY = ?) AND (t1.sID IN (SELECT s1.STHEMEID AS sThemeID FROM SA_Portal2ProfileManager s1 WHERE (s1.SORGID = ? ) AND (s1.SPUBLISHTYPE = ? ) ))
--> binds:[activity, ORG01, portal3]
2015-09-09 14:49:55 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT s1.sParent FROM SA_OPOrg s1 where s1='ORG01'
--> sql:SELECT s1.sParent AS sParent FROM SA_OPOrg s1 WHERE s1.sID = ?
--> binds:[ORG01]
2015-09-09 14:49:55 [SQL Time]sql 执行时间:0ms, exec KSQL: SELECT t1.* FROM Portal2Profiles t1 where t1.sThemeActivity='activity' and t1 IN (SELECT s1.sThemeID FROM Portal2ProfileManager s1 where s1.sOrgID=rgid and s1.sPublishType=:type)
--> sql:SELECT t1.sID AS t1, t1.VERSION AS version, t1.SPERSONID AS sPersonID, t1.STHEMEACTIVITY AS sThemeActivity, t1.SFUNCTREE AS sFunctree, t1.SPORTAL AS sPortal, t1.SOTHER AS sOther, t1.SPUBLISHTYPE AS sPublishType, t1.STHEMENAME AS sThemeName FROM SA_Portal2Profiles t1 WHERE (t1.STHEMEACTIVITY = ?) AND (t1.sID IN (SELECT s1.STHEMEID AS sThemeID FROM SA_Portal2ProfileManager s1 WHERE (s1.SORGID = ? ) AND (s1.SPUBLISHTYPE = ? ) ))
--> binds:[activity, null, portal3]
2015-09-09 14:49:55 [SQL Time]sql 执行时间:0ms, exec KSQL: SELECT s1.sParent FROM SA_OPOrg s1 where s1='null'
--> sql:SELECT s1.sParent AS sParent FROM SA_OPOrg s1 WHERE s1.sID = ?
--> binds:[null] |
|