于 2011/11/4 19:18, Edo Beutler 写道:
Hi
My first guess would have been also the indices. Since you checked
those I would try to activate MySQL's slow query log and try to
identify if it is a certain DB query that takes so long.
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?
Hope this helps
Edo