7 Nov
2011
7 Nov
'11
12:29 p.m.
Hi
I know, the page cache was not the problem in this case, but since
Ludovic mentioned it I wanted to share our experiences on page cache.
Around spring / summer while migrating old servers to (fewer) new ones
we ran into performance problems. We found the page cache to be
responsible and after fiddling around a while we figured out that (for
us) the performance was good when the page cache has a size of around
1/3 - 1/2 of the total number of pages over all wikis on a server.
e.g. on one server we have 75k wiki pages and currently a page cache
of 30k and are thinking about changing it to 40k (this runs fine on
4GB memory).
Edo
2011/11/4 Ludovic Dubost <ludovic(a)xwiki.com>om>:
I think I know what is happening. You must have a lot
of different
documents in your activity stream and you must have a low cache setting.
By default the cache setting is "100". However if you have a larger number
of documents it's better to set it to 2000 or 3000. At the same time you
need to raise the -Xmx setting of your Java virtual machine.
The fact that you have a lot of queries clearly shows that the wiki is
re-reading documents from the database, which it should not do unless the
documents are out of cache. Normally documents shown in the activity stream
should not be out of cache, particularly if you reload the page a second
time.
Ludovic
2011/11/4 Yang Li <yang.lee.cool(a)gmail.com>
于 2011/11/4 19:18, Edo Beutler 写道:
Hi
--
Ludovic Dubost
Founder and CEO
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…