Re: [xwiki-users] Activity performance is slow

于 2011/11/4 19:18, Edo Beutler 写道: slow query log has nothing.... But the general query log shows that there are a large number of queries when I tried to load the user profile page (only once), as follows: ------------------------------------------------------------------------ ikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=695792571 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=409221033 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=409221033 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='项 目：GPS项目.常规组会：Kalman滤波入门' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-797339379 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-797339379 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-797339379 and list0_.XWL_NAME='tags' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=428854445 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=428854445 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=428854445 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=428854445 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=428854445 and integerpro0_.XWI_NAME='replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-187735777 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-187735777 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-187735777 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=-187735777 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-187735777 and integerpro0_.XWI_NAME='replyto' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=239404830 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-230703309 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=-230703309 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='科 研：讨论班和学术报告.讨论班：基于添加短环设计有限长LDPC码' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-194765033 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-194765033 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-194765033 and list0_.XWL_NAME='tags' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=958297315 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=958297315 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=958297315 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=958297315 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=958297315 and integerpro0_.XWI_NAME='replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1800721365 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=1800721365 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=1800721365 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=1800721365 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=1800721365 and integerpro0_.XWI_NAME='replyto' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=2100328150 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=2100328150 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='Blog.信院首届研究生“让运动成为习惯，让生活更加精 彩”校园定向' order by baseobject0_.XWO_NUMBER 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-1017299478 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='Blog.BlogPostClass' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-1789160402 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-1789160402 and stringprop0_.XWS_NAME='sheet' 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-564295929 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-1399729039 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-1399729039 and stringprop0_.XWS_NAME='sheet' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-905319616 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-905319616 and dbstringli0_.XWL_NAME='category' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-905319616 and list0_.XWL_NAME='category' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-905319616 and largestrin0_.XWL_NAME='content' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-905319616 and largestrin0_.XWL_NAME='extract' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-905319616 and integerpro0_.XWI_NAME='hidden' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=-905319616 and dateproper0_.XWS_NAME='publishDate' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-905319616 and integerpro0_.XWI_NAME='published' 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-905319616 and stringprop0_.XWS_NAME='title' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-1804084128 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-1804084128 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=-1804084128 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=-1804084128 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=-1804084128 and integerpro0_.XWI_NAME='replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-1426244230 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-1426244230 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-1426244230 and list0_.XWL_NAME='tags' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1441943570 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=1441943570 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=1441943570 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=1441943570 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=1441943570 and integerpro0_.XWI_NAME='replyto' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1441943571 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=1441943571 and stringprop0_.XWS_NAME='author' 4 Query select largestrin0_.XWL_ID as XWP1_9_0_, largestrin0_.XWL_NAME as XWP2_9_0_, largestrin0_1_.XWP_CLASSTYPE as XWP3_9_0_, largestrin0_.XWL_VALUE as XWL3_16_0_ from xwikilargestrings largestrin0_ inner join xwikiproperties largestrin0_1_ on largestrin0_.XWL_ID=largestrin0_1_.XWP_ID and largestrin0_.XWL_NAME=largestrin0_1_.XWP_NAME where largestrin0_.XWL_ID=1441943571 and largestrin0_.XWL_NAME='comment' 4 Query select dateproper0_.XWS_ID as XWP1_9_0_, dateproper0_.XWS_NAME as XWP2_9_0_, dateproper0_1_.XWP_CLASSTYPE as XWP3_9_0_, dateproper0_.XWS_VALUE as XWS3_15_0_ from xwikidates dateproper0_ inner join xwikiproperties dateproper0_1_ on dateproper0_.XWS_ID=dateproper0_1_.XWP_ID and dateproper0_.XWS_NAME=dateproper0_1_.XWP_NAME where dateproper0_.XWS_ID=1441943571 and dateproper0_.XWS_NAME='date' 4 Query select integerpro0_.XWI_ID as XWP1_9_0_, integerpro0_.XWI_NAME as XWP2_9_0_, integerpro0_1_.XWP_CLASSTYPE as XWP3_9_0_, integerpro0_.XWI_VALUE as XWI3_10_0_ from xwikiintegers integerpro0_ inner join xwikiproperties integerpro0_1_ on integerpro0_.XWI_ID=integerpro0_1_.XWP_ID and integerpro0_.XWI_NAME=integerpro0_1_.XWP_NAME where integerpro0_.XWI_ID=1441943571 and integerpro0_.XWI_NAME='replyto' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-221079827 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-754891244 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=-754891244 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='Sandbox.测试页面2' order by baseobject0_.XWO_NUMBER 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-304499542 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='Presentation.PresentationClass' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=409306478 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=409306478 and stringprop0_.XWS_NAME='sheet' 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-1844699202 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-1844699202 and stringprop0_.XWS_NAME='layout' 4 Query select stringprop0_.XWS_ID as XWP1_9_0_, stringprop0_.XWS_NAME as XWP2_9_0_, stringprop0_1_.XWP_CLASSTYPE as XWP3_9_0_, stringprop0_.XWS_VALUE as XWS3_14_0_ from xwikistrings stringprop0_ inner join xwikiproperties stringprop0_1_ on stringprop0_.XWS_ID=stringprop0_1_.XWP_ID and stringprop0_.XWS_NAME=stringprop0_1_.XWP_NAME where stringprop0_.XWS_ID=-1844699202 and stringprop0_.XWS_NAME='theme' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=-1148819671 4 Query select xwikiattac0_.XWA_ID as XWA1_6_, xwikiattac0_.XWA_DOC_ID as XWA2_6_, xwikiattac0_.XWA_FILENAME as XWA3_6_, xwikiattac0_.XWA_SIZE as XWA4_6_, xwikiattac0_.XWA_DATE as XWA5_6_, xwikiattac0_.XWA_AUTHOR as XWA6_6_, xwikiattac0_.XWA_VERSION as XWA7_6_, xwikiattac0_.XWA_COMMENT as XWA8_6_ from xwikiattachment xwikiattac0_ where xwikiattac0_.XWA_DOC_ID=-1148819671 4 Query select baseobject0_.XWO_ID as XWO1_19_, baseobject0_.XWO_NUMBER as XWO2_19_, baseobject0_.XWO_NAME as XWO3_19_, baseobject0_.XWO_CLASSNAME as XWO4_19_, baseobject0_.XWO_GUID as XWO5_19_ from xwikiobjects baseobject0_ where baseobject0_.XWO_NAME='科 研：讨论班和学术报告.PPT制作技巧' order by baseobject0_.XWO_NUMBER 4 Query select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=-2041405299 4 Query select dbstringli0_.XWL_ID as XWP1_9_0_, dbstringli0_.XWL_NAME as XWP2_9_0_, dbstringli0_1_.XWP_CLASSTYPE as XWP3_9_0_ from xwikilists dbstringli0_ inner join xwikiproperties dbstringli0_1_ on dbstringli0_.XWL_ID=dbstringli0_1_.XWP_ID and dbstringli0_.XWL_NAME=dbstringli0_1_.XWP_NAME where dbstringli0_.XWL_ID=-2041405299 and dbstringli0_.XWL_NAME='tags' 4 Query select list0_.XWL_ID as XWL1_9_0_, list0_.XWL_NAME as XWL2_9_0_, list0_.XWL_VALUE as XWL3_0_, list0_.XWL_NUMBER as XWL4_0_ from xwikilistitems list0_ where list0_.XWL_ID=-2041405299 and list0_.XWL_NAME='tags' 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 4 Query SET autocommit=0 4 Query select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_FULLNAME as XWD2_0_0_, xwikidocum0_.XWD_NAME as XWD3_0_0_, xwikidocum0_.XWD_TITLE as XWD4_0_0_, xwikidocum0_.XWD_LANGUAGE as XWD5_0_0_, xwikidocum0_.XWD_DEFAULT_LANGUAGE as XWD6_0_0_, xwikidocum0_.XWD_TRANSLATION as XWD7_0_0_, xwikidocum0_.XWD_DATE as XWD8_0_0_, xwikidocum0_.XWD_CONTENT_UPDATE_DATE as XWD9_0_0_, xwikidocum0_.XWD_CREATION_DATE as XWD10_0_0_, xwikidocum0_.XWD_AUTHOR as XWD11_0_0_, xwikidocum0_.XWD_CONTENT_AUTHOR as XWD12_0_0_, xwikidocum0_.XWD_CREATOR as XWD13_0_0_, xwikidocum0_.XWD_WEB as XWD14_0_0_, xwikidocum0_.XWD_CONTENT as XWD15_0_0_, xwikidocum0_.XWD_VERSION as XWD16_0_0_, xwikidocum0_.XWD_CUSTOM_CLASS as XWD17_0_0_, xwikidocum0_.XWD_PARENT as XWD18_0_0_, xwikidocum0_.XWD_CLASS_XML as XWD19_0_0_, xwikidocum0_.XWD_ELEMENTS as XWD20_0_0_, xwikidocum0_.XWD_DEFAULT_TEMPLATE as XWD21_0_0_, xwikidocum0_.XWD_VALIDATION_SCRIPT as XWD22_0_0_, xwikidocum0_.XWD_COMMENT as XWD23_0_0_, xwikidocum0_.XWD_MINOREDIT as XWD24_0_0_, xwikidocum0_.XWD_SYNTAX_ID as XWD25_0_0_, xwikidocum0_.XWD_HIDDEN as XWD26_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=1201235099 4 Query rollback 4 Query rollback 4 Query SET autocommit=1 ------------------------------------------------------------------------ Not good at SQL, but it seems to me that each even involves almost 20 queries....and there are a lot of events out there... Is this all right?