SQL

Call Time (ms) Avg. Time (ms) Invocation count

org.apache.commons.dbcp.DelegatingStatement.close()
1,698 1 % 0 2,186

select 1 from DUAL
4,513 2 % 4 992

SHOW VARIABLES LIKE 'tx_isolation'
6,292 3 % 6 992

org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close()
369 0 % 0 992

org.apache.commons.dbcp.DelegatingConnection.createStatement()
368 0 % 0 992

com.mysql.jdbc.Statement.close()
256 0 % 0 992

com.mysql.jdbc.Connection.createStatement()
386 0 % 0 991

org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit()
2,110 1 % 2 905

select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T unreadstat1_ where messageimp0_.surrogateKey=? and unreadstat1_.USER_C=? and messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0_.DRAFT=0 and messageimp0_.DELETED=0
2,051 1 % 4 420

select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_ where messageimp0_.surrogateKey=? and messageimp0_.DRAFT=0 and messageimp0_.DELETED=0
1,627 1 % 3 420

select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_ where messageimp0_.surrogateKey=? and messageimp0_.DRAFT=0 and messageimp0_.DELETED=0 and messageimp0_.CREATED_BY=?
1,232 1 % 5 210

select EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EVENT_CODE,SESSION_SERVER from SAKAI_EVENT,SAKAI_SESSION where (SAKAI_EVENT.SESSION_ID = SAKAI_SESSION.SESSION_ID) and (EVENT_ID > ?)
687 0 % 27 25

select openforumi0_.ID as ID128_0_, areaimpl1_.ID as ID124_1_, topicsset2_.ID as ID125_2_, openforumi0_.VERSION as VERSION128_0_, openforumi0_.UUID as UUID128_0_, openforumi0_.CREATED as CREATED128_0_, openforumi0_.CREATED_BY as CREATED6_128_0_, openforumi0_.MODIFIED as MODIFIED128_0_, openforumi0_.MODIFIED_BY as MODIFIED8_128_0_, openforumi0_.DEFAULTASSIGNNAME as DEFAULTA9_128_0_, openforumi0_.TITLE as TITLE128_0_, openforumi0_.SHORT_DESCRIPTION as SHORT11_128_0_, openforumi0_.EXTENDED_DESCRIPTION as EXTENDED12_128_0_, openforumi0_.TYPE_UUID as TYPE13_128_0_, openforumi0_.SORT_INDEX as SORT14_128_0_, openforumi0_.LOCKED as LOCKED128_0_, openforumi0_.DRAFT as DRAFT128_0_, openforumi0_.surrogateKey as surroga17_128_0_, openforumi0_.MODERATED as MODERATED128_0_, openforumi0_.FORUM_DTYPE as FORUM2_128_0_, areaimpl1_.VERSION as VERSION124_1_, areaimpl1_.UUID as UUID124_1_, areaimpl1_.CREATED as CREATED124_1_, areaimpl1_.CREATED_BY as CREATED5_124_1_, areaimpl1_.MODIFIED as MODIFIED124_1_, areaimpl1_.MODIFIED_BY as MODIFIED7_124_1_, areaimpl1_.CONTEXT_ID as CONTEXT8_124_1_, areaimpl1_.NAME as NAME124_1_, areaimpl1_.HIDDEN as HIDDEN124_1_, areaimpl1_.TYPE_UUID as TYPE11_124_1_, areaimpl1_.ENABLED as ENABLED124_1_, areaimpl1_.LOCKED as LOCKED124_1_, areaimpl1_.MODERATED as MODERATED124_1_, topicsset2_.VERSION as VERSION125_2_, topicsset2_.UUID as UUID125_2_, topicsset2_.CREATED as CREATED125_2_, topicsset2_.CREATED_BY as CREATED6_125_2_, topicsset2_.MODIFIED as MODIFIED125_2_, topicsset2_.MODIFIED_BY as MODIFIED8_125_2_, topicsset2_.DEFAULTASSIGNNAME as DEFAULTA9_125_2_, topicsset2_.TITLE as TITLE125_2_, topicsset2_.SHORT_DESCRIPTION as SHORT11_125_2_, topicsset2_.EXTENDED_DESCRIPTION as EXTENDED12_125_2_, topicsset2_.MODERATED as MODERATED125_2_, topicsset2_.MUTABLE as MUTABLE125_2_, topicsset2_.SORT_INDEX as SORT15_125_2_, topicsset2_.TYPE_UUID as TYPE16_125_2_, topicsset2_.of_surrogateKey as of17_125_2_, topicsset2_.pf_surrogateKey as pf18_125_2_, topicsset2_.USER_ID as USER19_125_2_, topicsset2_.CONTEXT_ID as CONTEXT20_125_2_, topicsset2_.pt_surrogateKey as pt21_125_2_, topicsset2_.LOCKED as LOCKED125_2_, topicsset2_.DRAFT as DRAFT125_2_, topicsset2_.CONFIDENTIAL_RESPONSES as CONFIDE24_125_2_, topicsset2_.MUST_RESPOND_BEFORE_READING as MUST25_125_2_, topicsset2_.HOUR_BEFORE_RESPONSES_VISIBLE as HOUR26_125_2_, topicsset2_.GRADEBOOK as GRADEBOOK125_2_, topicsset2_.GRADEBOOK_ASSIGNMENT as GRADEBOOK28_125_2_, topicsset2_.TOPIC_DTYPE as TOPIC2_125_2_, topicsset2_.of_surrogateKey as of17_0__, topicsset2_.ID as ID0__ from MFR_OPEN_FORUM_T openforumi0_ inner join MFR_AREA_T areaimpl1_ on openforumi0_.surrogateKey=areaimpl1_.ID left outer join MFR_TOPIC_T topicsset2_ on openforumi0_.ID=topicsset2_.of_surrogateKey where openforumi0_.TYPE_UUID=? and areaimpl1_.CONTEXT_ID=? order by topicsset2_.SORT_INDEX asc, topicsset2_.created desc
1,781 1 % 84 21

select SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,SAKAI_USER.PW,SAKAI_USER.CREATEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON from SAKAI_USER where ( USER_ID = ? )
275 0 % 13 21

select privatefor0_.ID as ID129_0_, areaimpl1_.ID as ID124_1_, topicsset2_.ID as ID125_2_, privatefor0_.VERSION as VERSION129_0_, privatefor0_.UUID as UUID129_0_, privatefor0_.CREATED as CREATED129_0_, privatefor0_.CREATED_BY as CREATED5_129_0_, privatefor0_.MODIFIED as MODIFIED129_0_, privatefor0_.MODIFIED_BY as MODIFIED7_129_0_, privatefor0_.TITLE as TITLE129_0_, privatefor0_.SHORT_DESCRIPTION as SHORT9_129_0_, privatefor0_.EXTENDED_DESCRIPTION as EXTENDED10_129_0_, privatefor0_.TYPE_UUID as TYPE11_129_0_, privatefor0_.SORT_INDEX as SORT12_129_0_, privatefor0_.OWNER as OWNER129_0_, privatefor0_.AUTO_FORWARD as AUTO14_129_0_, privatefor0_.AUTO_FORWARD_EMAIL as AUTO15_129_0_, privatefor0_.PREVIEW_PANE_ENABLED as PREVIEW16_129_0_, privatefor0_.surrogateKey as surroga17_129_0_, areaimpl1_.VERSION as VERSION124_1_, areaimpl1_.UUID as UUID124_1_, areaimpl1_.CREATED as CREATED124_1_, areaimpl1_.CREATED_BY as CREATED5_124_1_, areaimpl1_.MODIFIED as MODIFIED124_1_, areaimpl1_.MODIFIED_BY as MODIFIED7_124_1_, areaimpl1_.CONTEXT_ID as CONTEXT8_124_1_, areaimpl1_.NAME as NAME124_1_, areaimpl1_.HIDDEN as HIDDEN124_1_, areaimpl1_.TYPE_UUID as TYPE11_124_1_, areaimpl1_.ENABLED as ENABLED124_1_, areaimpl1_.LOCKED as LOCKED124_1_, areaimpl1_.MODERATED as MODERATED124_1_, topicsset2_.VERSION as VERSION125_2_, topicsset2_.UUID as UUID125_2_, topicsset2_.CREATED as CREATED125_2_, topicsset2_.CREATED_BY as CREATED6_125_2_, topicsset2_.MODIFIED as MODIFIED125_2_, topicsset2_.MODIFIED_BY as MODIFIED8_125_2_, topicsset2_.DEFAULTASSIGNNAME as DEFAULTA9_125_2_, topicsset2_.TITLE as TITLE125_2_, topicsset2_.SHORT_DESCRIPTION as SHORT11_125_2_, topicsset2_.EXTENDED_DESCRIPTION as EXTENDED12_125_2_, topicsset2_.MODERATED as MODERATED125_2_, topicsset2_.MUTABLE as MUTABLE125_2_, topicsset2_.SORT_INDEX as SORT15_125_2_, topicsset2_.TYPE_UUID as TYPE16_125_2_, topicsset2_.of_surrogateKey as of17_125_2_, topicsset2_.pf_surrogateKey as pf18_125_2_, topicsset2_.USER_ID as USER19_125_2_, topicsset2_.CONTEXT_ID as CONTEXT20_125_2_, topicsset2_.pt_surrogateKey as pt21_125_2_, topicsset2_.LOCKED as LOCKED125_2_, topicsset2_.DRAFT as DRAFT125_2_, topicsset2_.CONFIDENTIAL_RESPONSES as CONFIDE24_125_2_, topicsset2_.MUST_RESPOND_BEFORE_READING as MUST25_125_2_, topicsset2_.HOUR_BEFORE_RESPONSES_VISIBLE as HOUR26_125_2_, topicsset2_.GRADEBOOK as GRADEBOOK125_2_, topicsset2_.GRADEBOOK_ASSIGNMENT as GRADEBOOK28_125_2_, topicsset2_.TOPIC_DTYPE as TOPIC2_125_2_, topicsset2_.pf_surrogateKey as pf18_0__, topicsset2_.ID as ID0__ from MFR_PRIVATE_FORUM_T privatefor0_ inner join MFR_AREA_T areaimpl1_ on privatefor0_.surrogateKey=areaimpl1_.ID left outer join MFR_TOPIC_T topicsset2_ on privatefor0_.ID=topicsset2_.pf_surrogateKey where privatefor0_.TYPE_UUID=? and areaimpl1_.CONTEXT_ID=? order by topicsset2_.created desc
1,320 1 % 62 21

select count(*) from searchbuilderitem where searchstate = ?
126 0 % 9 13

select txid, indexwriter, status, txts from search_journal
338 0 % 26 13

org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.createStatement()
26 0 % 2 13

SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = ? AND NEXT_FIRE_TIME >= 0
50 0 % 10 5

UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = ? WHERE (TRIGGER_STATE = ? OR TRIGGER_STATE = ?) AND NEXT_FIRE_TIME < ?
45 0 % 9 5

select NAME, VALUE from SAKAI_REALM_PROPERTY where ( REALM_KEY = ? )
6 0 % 3 2

select jid from search_node_status where serverid = ?
22 0 % 11 2

SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_ROLE_DESC.DESCRIPTION, SAKAI_REALM_ROLE_DESC.PROVIDER_ONLY FROM SAKAI_REALM_ROLE_DESC INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_ROLE_DESC.REALM_KEY AND SAKAI_REALM.REALM_ID = ? INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_ROLE_DESC.ROLE_KEY
13 0 % 6 2

select SAKAI_REALM.REALM_ID,SAKAI_REALM.PROVIDER_ID,(select MAX(ROLE_NAME) from SAKAI_REALM_ROLE where ROLE_KEY = MAINTAIN_ROLE),SAKAI_REALM.CREATEDBY,SAKAI_REALM.MODIFIEDBY,SAKAI_REALM.CREATEDON,SAKAI_REALM.MODIFIEDON,SAKAI_REALM.REALM_KEY from SAKAI_REALM where ( REALM_ID = ? )
16 0 % 8 2

SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = ?
16 0 % 8 2

SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_FUNCTION.FUNCTION_NAME FROM SAKAI_REALM_RL_FN INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_FN.REALM_KEY AND SAKAI_REALM.REALM_ID = ? INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_FN.ROLE_KEY INNER JOIN SAKAI_REALM_FUNCTION ON SAKAI_REALM_FUNCTION.FUNCTION_KEY = SAKAI_REALM_RL_FN.FUNCTION_KEY
519 0 % 259 2

SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_RL_GR.USER_ID, SAKAI_REALM_RL_GR.ACTIVE, SAKAI_REALM_RL_GR.PROVIDED FROM SAKAI_REALM_RL_GR INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_GR.REALM_KEY AND SAKAI_REALM.REALM_ID = ? INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_GR.ROLE_KEY
32 0 % 16 2

select privacyrec0_.id as id141_, privacyrec0_.lockId as lockId141_, privacyrec0_.contextId as contextId141_, privacyrec0_.recordType as recordType141_, privacyrec0_.userId as userId141_, privacyrec0_.viewable as viewable141_ from SAKAI_PRIVACY_RECORD privacyrec0_ where privacyrec0_.contextId=? and privacyrec0_.recordType=? and (privacyrec0_.userId in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))
38 0 % 19 2

select txid from search_journal where txid > ? and status = 'commited' order by txid asc
28 0 % 14 2

select SERVER_ID from SAKAI_CLUSTER where SERVER_ID = ?
3 0 % 3 1

update SAKAI_CLUSTER set UPDATE_TIME = CURRENT_TIMESTAMP() where SERVER_ID = ?
1 0 % 1 1