| 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 | |