/json.cmd POST |
|
66
|
6,023
|
109
|
20
|
0.00
|
27
|
41
|
select AgtLicenseKey.LIC_KEY_IDX as LIC1_59_0_, AgtLicenseKey.ACTIVE as ACTIVE59_0_, AgtLicenseKey.ACT_FAL_CAU_IDX as ACT3_59_0_, AgtLicenseKey.PARENT_IDX as PARENT4_59_0_, AgtLicenseKey.ACT_FAL_ID as ACT5_59_0_, AgtLicenseKey.LIC_IDX as LIC6_59_0_, AgtLicenseKey.USR_IDX as USR7_59_0_, AgtLicenseKey.STATUS as STATUS59_0_, AgtLicenseKey.BEFORE_STATUS as BEFORE9_59_0_, AgtLicenseKey.LIC_KEY as LIC10_59_0_, AgtLicenseKey.TEMP_LIC_KEY as TEMP11_59_0_, AgtLicenseKey.STA_0_SND_MAIL_CNT as STA12_59_0_, AgtLicenseKey.STA_2_SND_MAIL_CNT as STA13_59_0_, AgtLicenseKey.IS_UPDATE as IS14_59_0_, AgtLicenseKey.IS_DELETE as IS15_59_0_, AgtLicenseKey.IS_PUBLIC as IS16_59_0_, AgtLicenseKey.IS_DELETE_SHOW as IS17_59_0_, AgtLicenseKey.STATUS_0_SEND_MAIL_REG_DATE as STATUS18_59_0_, AgtLicenseKey.USR_IDX_REG_DATE as USR19_59_0_, AgtLicenseKey.DELETE_REG_DATE as DELETE20_59_0_, AgtLicenseKey.UPDATE_REG_DATE as UPDATE21_59_0_, AgtLicenseKey.REG_ADMIN_IDX as REG22_59_0_, AgtLicenseKey.DEL_ADMIN_IDX as DEL23_59_0_, AgtLicenseKey.ENC_DUE_DATE as ENC24_59_0_, AgtLicenseKey.ENC_DEL_DATE as ENC25_59_0_, AgtLicenseKey.KEY_DATA as KEY26_59_0_, AgtLicenseKey.DELETE_DATE as DELETE27_59_0_, AgtLicenseKey.UPDATE_DATE as UPDATE28_59_0_, AgtLicenseKey.REG_DATE as REG29_59_0_ from AGT_LICENSE_KEY AgtLicenseKey ORDER BY LIC_KEY DESC LIMIT 1 |
1.17 |
1
|
327
|
4
|
|
0.00
|
|
|
select agtuser0_.USR_IDX as USR1_8_0_, agtuser0_.ID as ID8_0_, agtuser0_.ORG_PASSWORD as ORG3_8_0_, agtuser0_.PASSWORD as PASSWORD8_0_, agtuser0_.FIRST_PWD as FIRST5_8_0_, agtuser0_.PWD_TYPE as PWD6_8_0_, agtuser0_.PWD_UPDATE_DATE as PWD7_8_0_, agtuser0_.PWD_DUE_DATE as PWD8_8_0_, agtuser0_.ORG_WEB_PASSWORD as ORG9_8_0_, agtuser0_.WEB_PASSWORD as WEB10_8_0_, agtuser0_.IS_CHG_WEB_PWD as IS11_8_0_, agtuser0_.WEB_PWD_UPDATE_DATE as WEB12_8_0_, agtuser0_.WEB_PWD_DUE_DATE as WEB13_8_0_, agtuser0_.ORG_SIGNER_PASSWORD as ORG14_8_0_, agtuser0_.SIGNER_PASSWORD as SIGNER15_8_0_, agtuser0_.IS_CHG_SIGNER_PWD as IS16_8_0_, agtuser0_.SIGNER_PWD_UPDATE_DATE as SIGNER17_8_0_, agtuser0_.SIGNER_PWD_DUE_DATE as SIGNER18_8_0_, agtuser0_.QUE_IDX as QUE19_8_0_, agtuser0_.ANSWER as ANSWER8_0_, agtuser0_.NAME as NAME8_0_, agtuser0_.TEL as TEL8_0_, agtuser0_.PHONE as PHONE8_0_, agtuser0_.EMAIL as EMAIL8_0_, agtuser0_.DEPARTMENT as DEPARTMENT8_0_, agtuser0_.POSITION as POSITION8_0_, agtuser0_.MEMO as MEMO8_0_, agtuser0_.ACTIVE as ACTIVE8_0_, agtuser0_.ACT_FAL_CAU_IDX as ACT29_8_0_, agtuser0_.PARENT_IDX as PARENT30_8_0_, agtuser0_.ACT_FAL_ID as ACT31_8_0_, agtuser0_.REG_DATE as REG32_8_0_, agtuser0_.UPDATE_DATE as UPDATE33_8_0_ from AGT_USER agtuser0_ where agtuser0_.USR_IDX=? |
0.69 |
0
|
89
|
2
|
|
0.00
|
|
|
select AgtConfig.CONF_IDX as CONF1_34_0_, AgtConfig.PLY_MIN_CYC as PLY2_34_0_, AgtConfig.LOG_UPL_MIN_CYC as LOG3_34_0_, AgtConfig.LOG_SAVE_DAY as LOG4_34_0_, AgtConfig.FIL_OUT_SIGN as FIL5_34_0_, AgtConfig.FIL_IN_SIGN as FIL6_34_0_, AgtConfig.AGT_VER as AGT7_34_0_, AgtConfig.PW_SPE_CHAR as PW8_34_0_, AgtConfig.PW_UPPERCASE as PW9_34_0_, AgtConfig.PW_LOWERCASE as PW10_34_0_, AgtConfig.PW_NUMBER as PW11_34_0_, AgtConfig.PW_SEL_LEN as PW12_34_0_, AgtConfig.PW_LENGTH as PW13_34_0_, AgtConfig.PW_TYPE as PW14_34_0_, AgtConfig.PW_MONTH as PW15_34_0_, AgtConfig.PW_DAY as PW16_34_0_, AgtConfig.PW_CNT_OF_WEEK as PW17_34_0_, AgtConfig.PW_WEEK as PW18_34_0_, AgtConfig.FAIL_CNT as FAIL19_34_0_, AgtConfig.FAIL_MIN as FAIL20_34_0_, AgtConfig.LOGOFF_MIN as LOGOFF21_34_0_, AgtConfig.REP_SCH_CHK_TYPE as REP22_34_0_, AgtConfig.REP_SCH_CHK_MONTH as REP23_34_0_, AgtConfig.REP_SCH_CHK_DAY as REP24_34_0_, AgtConfig.REP_SCH_CHK_CNT_OF_WEEK as REP25_34_0_, AgtConfig.REP_SCH_CHK_WEEK as REP26_34_0_, AgtConfig.REP_SCH_CHK_USR_IDX as REP27_34_0_, AgtConfig.REP_SCH_CURR_DATE as REP28_34_0_, AgtConfig.REP_SCH_REG_DATE as REP29_34_0_, AgtConfig.LICENSE_DUE_DATE_CHECKING as LICENSE30_34_0_, AgtConfig.IS_USE_SEND_MAIL_ENC_FILE as IS31_34_0_, AgtConfig.IS_USE_NETWORK as IS32_34_0_, AgtConfig.IS_USE_WATER_MARK as IS33_34_0_, AgtConfig.IS_USE_USER_LOGIN as IS34_34_0_, AgtConfig.IS_USE_SEL_FILE_TYPE as IS35_34_0_, AgtConfig.IS_USE_SECURITY as IS36_34_0_, AgtConfig.IS_ENC_KEY as IS37_34_0_, AgtConfig.ENC_KEY as ENC38_34_0_, AgtConfig.IS_SHOW_POLICY_DIALOG as IS39_34_0_, AgtConfig.IS_SIMPLE_INSTALL as IS40_34_0_, AgtConfig.COUNTRY as COUNTRY34_0_, AgtConfig.REG_CAU as REG42_34_0_, AgtConfig.REG_DATE as REG43_34_0_ from AGT_CONFIG AgtConfig |
0.48 |
0
|
148
|
3
|
|
0.00
|
|
|
select this_.LIC_KEY_IDX as LIC1_59_0_, this_.ACTIVE as ACTIVE59_0_, this_.ACT_FAL_CAU_IDX as ACT3_59_0_, this_.PARENT_IDX as PARENT4_59_0_, this_.ACT_FAL_ID as ACT5_59_0_, this_.LIC_IDX as LIC6_59_0_, this_.USR_IDX as USR7_59_0_, this_.STATUS as STATUS59_0_, this_.BEFORE_STATUS as BEFORE9_59_0_, this_.LIC_KEY as LIC10_59_0_, this_.TEMP_LIC_KEY as TEMP11_59_0_, this_.STA_0_SND_MAIL_CNT as STA12_59_0_, this_.STA_2_SND_MAIL_CNT as STA13_59_0_, this_.IS_UPDATE as IS14_59_0_, this_.IS_DELETE as IS15_59_0_, this_.IS_PUBLIC as IS16_59_0_, this_.IS_DELETE_SHOW as IS17_59_0_, this_.STATUS_0_SEND_MAIL_REG_DATE as STATUS18_59_0_, this_.USR_IDX_REG_DATE as USR19_59_0_, this_.DELETE_REG_DATE as DELETE20_59_0_, this_.UPDATE_REG_DATE as UPDATE21_59_0_, this_.REG_ADMIN_IDX as REG22_59_0_, this_.DEL_ADMIN_IDX as DEL23_59_0_, this_.ENC_DUE_DATE as ENC24_59_0_, this_.ENC_DEL_DATE as ENC25_59_0_, this_.KEY_DATA as KEY26_59_0_, this_.DELETE_DATE as DELETE27_59_0_, this_.UPDATE_DATE as UPDATE28_59_0_, this_.REG_DATE as REG29_59_0_ from AGT_LICENSE_KEY this_ where this_.LIC_KEY=? and this_.ACTIVE=? limit ? |
0.37 |
0
|
125
|
1
|
|
0.00
|
|
|
select this_.INS_USR_IDX as INS1_9_0_, this_.USR_IDX as USR2_9_0_, this_.INSTALL_USR_IDX as INSTALL3_9_0_, this_.LIC_KEY as LIC4_9_0_, this_.LIC_KEY_IDX as LIC5_9_0_, this_.PCID as PCID9_0_, this_.DEMO as DEMO9_0_, this_.CONNECT_TIME as CONNECT8_9_0_, this_.INSTALL_TIME as INSTALL9_9_0_, this_.IP as IP9_0_, this_.MAC as MAC9_0_, this_.OS as OS9_0_, this_.PCNAME as PCNAME9_0_, this_.VERSION_INFO as VERSION14_9_0_, this_.STATUS as STATUS9_0_, this_.PLY_NAME as PLY16_9_0_, this_.PLY_IDX as PLY17_9_0_, this_.PROGRESS as PROGRESS9_0_, this_.CHG_TYPE as CHG19_9_0_ from AGT_USER_INSTALL this_ where this_.LIC_KEY=? limit ? |
2.13 |
0
|
186
|
1
|
|
0.00
|
|
|
select AgtAlertConfig.ALE_CONF_IDX as ALE1_69_0_, AgtAlertConfig.ACTIVE as ACTIVE69_0_, AgtAlertConfig.ACT_FAL_CAU_IDX as ACT3_69_0_, AgtAlertConfig.PARENT_IDX as PARENT4_69_0_, AgtAlertConfig.ACT_FAL_ID as ACT5_69_0_, AgtAlertConfig.REG_USR_IDX as REG6_69_0_, AgtAlertConfig.IS_USE as IS7_69_0_, AgtAlertConfig.AGT_LOG_SCH_CHK_MINUTE_DIVIDE as AGT8_69_0_, AgtAlertConfig.AGT_LOG_SCH_CHK_MINUTE as AGT9_69_0_, AgtAlertConfig.AGT_LOG_SCH_CHECKING as AGT10_69_0_, AgtAlertConfig.AGT_PWD_DUE_DATE as AGT11_69_0_, AgtAlertConfig.AGT_LOGIN_FAIL as AGT12_69_0_, AgtAlertConfig.AGT_LOGIN_FAIL_CNT as AGT13_69_0_, AgtAlertConfig.AGT_LOGIN_FAIL_SLP_TIME as AGT14_69_0_, AgtAlertConfig.VAC_INS as VAC15_69_0_, AgtAlertConfig.VAC_RUN as VAC16_69_0_, AgtAlertConfig.VAC_LAST_VER as VAC17_69_0_, AgtAlertConfig.VAC_REALTIME as VAC18_69_0_, AgtAlertConfig.HDD_SPACE as HDD19_69_0_, AgtAlertConfig.HDD_SPACE_REMAIN as HDD20_69_0_, AgtAlertConfig.PUB_FOL as PUB21_69_0_, AgtAlertConfig.WIN_PATCH as WIN22_69_0_, AgtAlertConfig.AGENT_UPDATE as AGENT23_69_0_, AgtAlertConfig.ENC_FIL_OUT as ENC24_69_0_, AgtAlertConfig.ENC_FIL_PRN as ENC25_69_0_, AgtAlertConfig.ENC_FIL_DEL as ENC26_69_0_, AgtAlertConfig.ENC_FIL_OUT_DEC as ENC27_69_0_, AgtAlertConfig.CHG_USR_INFO as CHG28_69_0_, AgtAlertConfig.CHG_PLY as CHG29_69_0_, AgtAlertConfig.ENC_FIL_DEC_SIGN as ENC30_69_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL as MGT31_69_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL_CNT as MGT32_69_0_, AgtAlertConfig.MGT_LOGIN_FAIL_SLP_TIME as MGT33_69_0_, AgtAlertConfig.MGT_USR_LOGIN as MGT34_69_0_, AgtAlertConfig.MGT_PWD_DUE_DATE as MGT35_69_0_, AgtAlertConfig.AGT_USR_DEL_AND_RUN_AGT as AGT36_69_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_CHECKING as AGT37_69_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_CHK_HOUR as AGT38_69_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_CHK_MINUTE as AGT39_69_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_CHECKING as MGT40_69_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_CHK_HOUR as MGT41_69_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_CHK_MINUTE as MGT42_69_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_SND_EMAIL as AGT43_69_0_, AgtAlertConfig.AGT_LOGIN_FAIL_SND_EMAIL as AGT44_69_0_, AgtAlertConfig.MGT_USR_LOGIN_SND_EMAIL as MGT45_69_0_, AgtAlertConfig.VAC_INS_SND_EMAIL as VAC46_69_0_, AgtAlertConfig.VAC_RUN_SND_EMAIL as VAC47_69_0_, AgtAlertConfig.VAC_LAST_VER_SND_EMAIL as VAC48_69_0_, AgtAlertConfig.VAC_REALTIME_SND_EMAIL as VAC49_69_0_, AgtAlertConfig.HDD_SPACE_SND_EMAIL as HDD50_69_0_, AgtAlertConfig.PUB_FOL_SND_EMAIL as PUB51_69_0_, AgtAlertConfig.WIN_PATCH_AND_SND_EMAIL as WIN52_69_0_, AgtAlertConfig.AGENT_UPDATE_AND_SND_EMAIL as AGENT53_69_0_, AgtAlertConfig.ENC_FIL_OUT_SND_EMAIL as ENC54_69_0_, AgtAlertConfig.ENC_FIL_PRN_SND_EMAIL as ENC55_69_0_, AgtAlertConfig.ENC_FIL_DEL_SND_EMAIL as ENC56_69_0_, AgtAlertConfig.ENC_FIL_OUT_DEC_SND_EMAIL as ENC57_69_0_, AgtAlertConfig.CHG_USR_INFO_SND_EMAIL as CHG58_69_0_, AgtAlertConfig.CHG_PLY_SND_EMAIL as CHG59_69_0_, AgtAlertConfig.ENC_FIL_DEC_SIGN_SND_EMAIL as ENC60_69_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL_SND_EMAIL as MGT61_69_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_SND_EMAIL as MGT62_69_0_, AgtAlertConfig.AGT_USR_DEL_AND_RUN_AGT_SND_EMAIL as AGT63_69_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_SND_MESSAGE as AGT64_69_0_, AgtAlertConfig.AGT_LOGIN_FAIL_SND_MESSAGE as AGT65_69_0_, AgtAlertConfig.MGT_USR_LOGIN_SND_MESSAGE as MGT66_69_0_, AgtAlertConfig.VAC_INS_SND_MESSAGE as VAC67_69_0_, AgtAlertConfig.VAC_RUN_SND_MESSAGE as VAC68_69_0_, AgtAlertConfig.VAC_LAST_VER_SND_MESSAGE as VAC69_69_0_, AgtAlertConfig.VAC_REALTIME_SND_MESSAGE as VAC70_69_0_, AgtAlertConfig.HDD_SPACE_SND_MESSAGE as HDD71_69_0_, AgtAlertConfig.PUB_FOL_SND_MESSAGE as PUB72_69_0_, AgtAlertConfig.WIN_PATCH_AND_SND_MESSAGE as WIN73_69_0_, AgtAlertConfig.AGENT_UPDATE_AND_SND_MESSAGE as AGENT74_69_0_, AgtAlertConfig.ENC_FIL_OUT_SND_MESSAGE as ENC75_69_0_, AgtAlertConfig.ENC_FIL_PRN_SND_MESSAGE as ENC76_69_0_, AgtAlertConfig.ENC_FIL_DEL_SND_MESSAGE as ENC77_69_0_, AgtAlertConfig.ENC_FIL_OUT_DEC_SND_MESSAGE as ENC78_69_0_, AgtAlertConfig.CHG_USR_INFO_SND_MESSAGE as CHG79_69_0_, AgtAlertConfig.CHG_PLY_SND_MESSAGE as CHG80_69_0_, AgtAlertConfig.ENC_FIL_DEC_SIGN_SND_MESSAGE as ENC81_69_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL_SND_MESSAGE as MGT82_69_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_SND_MESSAGE as MGT83_69_0_, AgtAlertConfig.AGT_USR_DEL_AND_RUN_AGT_SND_MESSAGE as AGT84_69_0_, AgtAlertConfig.ACT_FAL_CURR_DATE as ACT85_69_0_, AgtAlertConfig.REG_DATE as REG86_69_0_ from AGT_ALERT_CONFIG AgtAlertConfig |
0.10 |
1
|
209
|
7
|
|
0.00
|
|
|
insert into AGT_HDD_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, USED, TOTAL, USR_IDX, GRP_IDX, LIC_KEY_IDX, WORKGROUP, CPU, RAM, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.04 |
3
|
314
|
23
|
|
0.00
|
|
|
|
|
0.03 |
0
|
58
|
4
|
|
0.00
|
|
|
select agthddlog0_.HDD_LOG_IDX as HDD1_97_0_, agthddlog0_.ID as ID97_0_, agthddlog0_.PCID as PCID97_0_, agthddlog0_.MAC as MAC97_0_, agthddlog0_.PCNAME as PCNAME97_0_, agthddlog0_.PAR_NAME as PAR6_97_0_, agthddlog0_.PLY_NAME as PLY7_97_0_, agthddlog0_.OS as OS97_0_, agthddlog0_.IP as IP97_0_, agthddlog0_.LIC_KEY as LIC10_97_0_, agthddlog0_.USR_NAME as USR11_97_0_, agthddlog0_.USED as USED97_0_, agthddlog0_.TOTAL as TOTAL97_0_, agthddlog0_.USR_IDX as USR14_97_0_, agthddlog0_.GRP_IDX as GRP15_97_0_, agthddlog0_.LIC_KEY_IDX as LIC16_97_0_, agthddlog0_.WORKGROUP as WORKGROUP97_0_, agthddlog0_.CPU as CPU97_0_, agthddlog0_.RAM as RAM97_0_, agthddlog0_.CURR_DATE as CURR20_97_0_, agthddlog0_.REG_DATE as REG21_97_0_ from AGT_HDD_LOG agthddlog0_ where agthddlog0_.HDD_LOG_IDX=? |
0.03 |
1
|
60
|
6
|
|
0.00
|
|
|
insert into AGT_HDD_LOG_LATELY (USR_IDX, LIC_KEY_IDX, START_HDD_LOG_IDX, END_HDD_LOG_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?) |
0.04 |
0
|
11
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select this_.COM_IDX as COM1_3046_0_, this_.SITE_IDX as SITE2_3046_0_, this_.BIZ_TYPE as BIZ3_3046_0_, this_.BUS_IDX as BUS4_3046_0_, this_.REGI_NUMBER2 as REGI5_3046_0_, this_.REGI_NUMBER as REGI6_3046_0_, this_.BUSS_COND1 as BUSS7_3046_0_, this_.BUSS_COND2 as BUSS8_3046_0_, this_.LIC_IDX as LIC9_3046_0_, this_.NAME as NAME3046_0_, this_.TEL as TEL3046_0_, this_.FAX as FAX3046_0_, this_.REG_ID as REG13_3046_0_, this_.REG_PHONE as REG14_3046_0_, this_.REG_EMAIL as REG15_3046_0_, this_.REG_NAME as REG16_3046_0_, this_.REG_BUSI as REG17_3046_0_, this_.EMP_NUMBER as EMP18_3046_0_, this_.BOSS_NAME as BOSS19_3046_0_, this_.ASS_PC_NUM as ASS20_3046_0_, this_.ASS_NOT_BOO_NUM as ASS21_3046_0_, this_.ASS_WIN_SER_NUM as ASS22_3046_0_, this_.TOT_ASS_NUM as TOT23_3046_0_, this_.HOMEPAGE as HOMEPAGE3046_0_, this_.ADRESS as ADRESS3046_0_, this_.ADRESS2 as ADRESS26_3046_0_, this_.ZIP_CODE as ZIP27_3046_0_, this_.LOGO as LOGO3046_0_, this_.LOGO_PATH as LOGO29_3046_0_, this_.LOGO_FILE as LOGO30_3046_0_, this_.LOGO_CONTENT_TYPE as LOGO31_3046_0_, this_.REG_DATE as REG32_3046_0_, this_.CURR_DATE as CURR33_3046_0_, this_.STATUS as STATUS3046_0_, this_.DROP_TYPE as DROP35_3046_0_, this_.DROP_DESCRIPTION as DROP36_3046_0_, this_.INIT_AGT_VER as INIT37_3046_0_, this_.IS_ENC_KEY as IS38_3046_0_, this_.ENC_KEY as ENC39_3046_0_, this_.ENC_KEY_REG_DATE as ENC40_3046_0_, this_.SITE_KEY as SITE41_3046_0_ from MGT_COMPANY this_ where this_.SITE_IDX=? and this_.STATUS<>? limit ? |
0.31 |
2
|
44
|
0
|
|
0.00
|
|
|
select this_.INS_USR_IDX as INS1_9_0_, this_.USR_IDX as USR2_9_0_, this_.INSTALL_USR_IDX as INSTALL3_9_0_, this_.LIC_KEY as LIC4_9_0_, this_.LIC_KEY_IDX as LIC5_9_0_, this_.PCID as PCID9_0_, this_.DEMO as DEMO9_0_, this_.CONNECT_TIME as CONNECT8_9_0_, this_.INSTALL_TIME as INSTALL9_9_0_, this_.IP as IP9_0_, this_.MAC as MAC9_0_, this_.OS as OS9_0_, this_.PCNAME as PCNAME9_0_, this_.VERSION_INFO as VERSION14_9_0_, this_.STATUS as STATUS9_0_, this_.PLY_NAME as PLY16_9_0_, this_.PLY_IDX as PLY17_9_0_, this_.PROGRESS as PROGRESS9_0_, this_.CHG_TYPE as CHG19_9_0_ from AGT_USER_INSTALL this_ where this_.LIC_KEY_IDX=? limit ? |
0.25 |
0
|
34
|
0
|
|
0.00
|
|
|
|
|
0.54 |
0
|
171
|
3
|
|
0.00
|
|
|
select agtgroup0_.GRP_IDX as GRP1_38_0_, agtgroup0_.ACTIVE as ACTIVE38_0_, agtgroup0_.ACT_FAL_CAU_IDX as ACT3_38_0_, agtgroup0_.PARENT_IDX as PARENT4_38_0_, agtgroup0_.ACT_FAL_ID as ACT5_38_0_, agtgroup0_.NAME as NAME38_0_, agtgroup0_.DESCRIPTION as DESCRIPT7_38_0_, agtgroup0_.DEPTH as DEPTH38_0_, agtgroup0_.SEP as SEP38_0_, agtgroup0_.PARENT as PARENT38_0_, agtgroup0_.BASED as BASED38_0_, agtgroup0_.REG_DATE as REG12_38_0_ from AGT_GROUP agtgroup0_ where agtgroup0_.GRP_IDX=? |
0.53 |
0
|
133
|
2
|
|
0.00
|
|
|
|
|
0.54 |
0
|
148
|
2
|
|
0.00
|
|
|
select this_.PLY_IDX as PLY1_10_0_, this_.PARENT_IDX as PARENT2_10_0_, this_.ACT_FAL_ID as ACT3_10_0_, this_.ACTIVE as ACTIVE10_0_, this_.CREATE_USR_IDX as CREATE5_10_0_, this_.ACT_FAL_CAU_IDX as ACT6_10_0_, this_.GEN_PLY_IDX as GEN7_10_0_, this_.ENC_PLY_IDX as ENC8_10_0_, this_.PRO_PLY_IDX as PRO9_10_0_, this_.NAME as NAME10_0_, this_.PAT_CHG_TYPE as PAT11_10_0_, this_.DESCRIPTION as DESCRIP12_10_0_, this_.BASED as BASED10_0_, this_.COUNTRY as COUNTRY10_0_, this_.CHG_TYPE as CHG15_10_0_, this_.IDXES as IDXES10_0_, this_.ACT_FAL_CURR_DATE as ACT17_10_0_, this_.REG_DATE as REG18_10_0_ from AGT_POLICY this_ where this_.PLY_IDX=? and this_.ACTIVE=? limit ? |
0.54 |
0
|
138
|
1
|
|
0.00
|
|
|
|
|
0.25 |
0
|
8
|
0
|
|
0.00
|
|
|
select this_.GEN_PLY_IDX as GEN1_13_0_, this_.ACTIVE as ACTIVE13_0_, this_.ACT_FAL_CAU_IDX as ACT3_13_0_, this_.PARENT_IDX as PARENT4_13_0_, this_.ACT_FAL_ID as ACT5_13_0_, this_.PAT_PLY_IDX as PAT6_13_0_, this_.FIL_PLY_IDX as FIL7_13_0_, this_.KWD_PLY_IDX as KWD8_13_0_, this_.FOD_PLY_IDX as FOD9_13_0_, this_.PWD_PLY_IDX as PWD10_13_0_, this_.SCR_PLY_IDX as SCR11_13_0_, this_.WIN_PAC_PLY_IDX as WIN12_13_0_, this_.MDA_PLY_IDX as MDA13_13_0_, this_.FW_PLY_IDX as FW14_13_0_, this_.NTW_PLY_IDX as NTW15_13_0_, this_.VAC_PLY_IDX as VAC16_13_0_, this_.SMA_PHO_PRO_PLY_IDX as SMA17_13_0_, this_.REG_DATE as REG18_13_0_ from AGT_GENERAL_POLICY this_ where this_.GEN_PLY_IDX=? and this_.ACTIVE=? limit ? |
0.28 |
0
|
93
|
2
|
|
0.00
|
|
|
select MgtAgentMetaVersion.MGT_AGT_MET_VER_IDX as MGT1_3073_0_, MgtAgentMetaVersion.ACTIVE as ACTIVE3073_0_, MgtAgentMetaVersion.ACT_FAL_CAU_IDX as ACT3_3073_0_, MgtAgentMetaVersion.ACT_FAL_ID as ACT4_3073_0_, MgtAgentMetaVersion.SITE_IDX as SITE5_3073_0_, MgtAgentMetaVersion.VERSION as VERSION3073_0_, MgtAgentMetaVersion.TYPE as TYPE3073_0_, MgtAgentMetaVersion.MGT_MET_RUL_IDX as MGT8_3073_0_, MgtAgentMetaVersion.COMPLETED as COMPLETED3073_0_, MgtAgentMetaVersion.STATUS as STATUS3073_0_, MgtAgentMetaVersion.FROM_DATE as FROM11_3073_0_, MgtAgentMetaVersion.TO_DATE as TO12_3073_0_, MgtAgentMetaVersion.COUNTRY as COUNTRY3073_0_, MgtAgentMetaVersion.CURR_DATE as CURR14_3073_0_, MgtAgentMetaVersion.REG_DATE as REG15_3073_0_ from MGT_AGENT_META_VERSION MgtAgentMetaVersion where TYPE=? AND SITE_IDX=? AND STATUS=? |
0.75 |
27
|
47
|
4
|
|
0.00
|
|
|
select this_.ENC_PLY_IDX as ENC1_11_0_, this_.ACTIVE as ACTIVE11_0_, this_.ACT_FAL_CAU_IDX as ACT3_11_0_, this_.PARENT_IDX as PARENT4_11_0_, this_.ACT_FAL_ID as ACT5_11_0_, this_.PAT_PLY_IDX as PAT6_11_0_, this_.FIL_PLY_IDX as FIL7_11_0_, this_.KWD_PLY_IDX as KWD8_11_0_, this_.FOD_PLY_IDX as FOD9_11_0_, this_.PWD_PLY_IDX as PWD10_11_0_, this_.SCR_PLY_IDX as SCR11_11_0_, this_.EXT_PLY_IDX as EXT12_11_0_, this_.PRO_FOL_PLY_IDX as PRO13_11_0_, this_.DFOD_PLY_IDX as DFOD14_11_0_, this_.WHI_LIS_PLY_IDX as WHI15_11_0_, this_.AGE_REG_PLY_IDX as AGE16_11_0_, this_.ATT_BLO_PLY_IDX as ATT17_11_0_, this_.REG_DATE as REG18_11_0_ from AGT_ENCRYPT_POLICY this_ where this_.ENC_PLY_IDX=? and this_.ACTIVE=? limit ? |
0.53 |
0
|
183
|
1
|
|
0.00
|
|
|
|
|
0.27 |
0
|
107
|
2
|
|
0.00
|
|
|
|
|
7.69 |
0
|
179
|
0
|
|
0.00
|
|
|
|
|
0.16 |
0
|
47
|
0
|
|
0.00
|
|
|
select agtlicense0_.LIC_IDX as LIC1_58_0_, agtlicense0_.ACTIVE as ACTIVE58_0_, agtlicense0_.ACT_FAL_CAU_IDX as ACT3_58_0_, agtlicense0_.PARENT_IDX as PARENT4_58_0_, agtlicense0_.ACT_FAL_ID as ACT5_58_0_, agtlicense0_.PAY_IDX as PAY6_58_0_, agtlicense0_.COUNT as COUNT58_0_, agtlicense0_.NAME as NAME58_0_, agtlicense0_.DESCRIPTION as DESCRIPT9_58_0_, agtlicense0_.DELAY_DAY_CNT as DELAY10_58_0_, agtlicense0_.DELAY_DAY_REG_DAY as DELAY11_58_0_, agtlicense0_.DUE_DATE as DUE12_58_0_, agtlicense0_.REG_DATE as REG13_58_0_, agtlicense0_.START_DATE as START14_58_0_, agtlicense0_.FIR_START_DATE as FIR15_58_0_, agtlicense0_.DEL_DATE as DEL16_58_0_, agtlicense0_.ENC_DEL_DATE as ENC17_58_0_, agtlicense0_.TYPE as TYPE58_0_ from AGT_LICENSE agtlicense0_ where agtlicense0_.LIC_IDX=? |
0.25 |
0
|
77
|
1
|
|
0.00
|
|
|
|
|
0.25 |
0
|
19
|
0
|
|
0.00
|
|
|
|
|
0.02 |
0
|
88
|
3
|
|
0.00
|
|
|
select this_.IDX as IDX3090_0_, this_.TYPE as TYPE3090_0_, this_.VERSION as VERSION3090_0_, this_.FETCHDATE as FETCHDATE3090_0_, this_.FETCHDESC as FETCHDESC3090_0_, this_.ORGFILENAME as ORGFILEN6_3090_0_, this_.TEMPFILENAME as TEMPFILE7_3090_0_, this_.TOT_SITE_CNT as TOT8_3090_0_, this_.PRO_SITE_CNT as PRO9_3090_0_, this_.LIC_TYPE as LIC10_3090_0_, this_.COUNTRY as COUNTRY3090_0_ from MGT_META_VERSION this_ where this_.TYPE=? and this_.VERSION=? order by this_.IDX desc limit ? |
0.08 |
0
|
48
|
1
|
|
0.00
|
|
|
select agtlicense0_.LIC_KEY_IDX as LIC1_59_0_, agtlicense0_.ACTIVE as ACTIVE59_0_, agtlicense0_.ACT_FAL_CAU_IDX as ACT3_59_0_, agtlicense0_.PARENT_IDX as PARENT4_59_0_, agtlicense0_.ACT_FAL_ID as ACT5_59_0_, agtlicense0_.LIC_IDX as LIC6_59_0_, agtlicense0_.USR_IDX as USR7_59_0_, agtlicense0_.STATUS as STATUS59_0_, agtlicense0_.BEFORE_STATUS as BEFORE9_59_0_, agtlicense0_.LIC_KEY as LIC10_59_0_, agtlicense0_.TEMP_LIC_KEY as TEMP11_59_0_, agtlicense0_.STA_0_SND_MAIL_CNT as STA12_59_0_, agtlicense0_.STA_2_SND_MAIL_CNT as STA13_59_0_, agtlicense0_.IS_UPDATE as IS14_59_0_, agtlicense0_.IS_DELETE as IS15_59_0_, agtlicense0_.IS_PUBLIC as IS16_59_0_, agtlicense0_.IS_DELETE_SHOW as IS17_59_0_, agtlicense0_.STATUS_0_SEND_MAIL_REG_DATE as STATUS18_59_0_, agtlicense0_.USR_IDX_REG_DATE as USR19_59_0_, agtlicense0_.DELETE_REG_DATE as DELETE20_59_0_, agtlicense0_.UPDATE_REG_DATE as UPDATE21_59_0_, agtlicense0_.REG_ADMIN_IDX as REG22_59_0_, agtlicense0_.DEL_ADMIN_IDX as DEL23_59_0_, agtlicense0_.ENC_DUE_DATE as ENC24_59_0_, agtlicense0_.ENC_DEL_DATE as ENC25_59_0_, agtlicense0_.KEY_DATA as KEY26_59_0_, agtlicense0_.DELETE_DATE as DELETE27_59_0_, agtlicense0_.UPDATE_DATE as UPDATE28_59_0_, agtlicense0_.REG_DATE as REG29_59_0_ from AGT_LICENSE_KEY agtlicense0_ where agtlicense0_.LIC_KEY_IDX=? |
0.09 |
0
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_PUBLIC_FOLDER_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, PATH, NAME, IS_ENC, USR_IDX, GRP_IDX, LIC_KEY_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.01 |
6
|
222
|
26
|
|
0.00
|
|
|
insert into AGT_PUBLIC_FOLDER_LOG_LATELY (USR_IDX, LIC_KEY_IDX, COUNT, START_PUB_FOL_LOG_IDX, END_PUB_FOL_LOG_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?) |
0.01 |
0
|
23
|
1
|
|
0.00
|
|
|
|
|
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
|
|
0.04 |
1
|
202
|
5
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.01 |
4
|
170
|
21
|
|
0.00
|
|
|
|
|
0.01 |
0
|
61
|
3
|
|
0.00
|
|
|
|
|
0.02 |
2
|
129
|
11
|
|
0.00
|
|
|
|
|
0.19 |
0
|
4
|
0
|
|
0.00
|
|
|
|
|
0.02 |
1
|
80
|
4
|
|
0.00
|
|
|
|
|
0.02 |
1
|
93
|
6
|
|
0.00
|
|
|
select AgtFirewallPolicy.FW_PLY_IDX as FW1_44_0_, AgtFirewallPolicy.FW_IDX as FW2_44_0_, AgtFirewallPolicy.FW_IDX_FOR_PRESET as FW3_44_0_, AgtFirewallPolicy.ACTIVE as ACTIVE44_0_, AgtFirewallPolicy.ACT_FAL_CAU_IDX as ACT5_44_0_, AgtFirewallPolicy.PARENT_IDX as PARENT6_44_0_, AgtFirewallPolicy.ACT_FAL_ID as ACT7_44_0_, AgtFirewallPolicy.GEN_PLY_IDX as GEN8_44_0_, AgtFirewallPolicy.ENC_PLY_IDX as ENC9_44_0_, AgtFirewallPolicy.PRO_PLY_IDX as PRO10_44_0_, AgtFirewallPolicy.IS_PRESET as IS11_44_0_, AgtFirewallPolicy.IS_USE as IS12_44_0_, AgtFirewallPolicy.REG_DATE as REG13_44_0_ from AGT_FIREWALL_POLICY AgtFirewallPolicy where GEN_PLY_IDX=? and ACTIVE=? |
0.02 |
1
|
146
|
8
|
|
0.00
|
|
|
|
|
0.02 |
1
|
112
|
8
|
|
0.00
|
|
|
|
|
0.01 |
1
|
93
|
8
|
|
0.00
|
|
|
|
|
0.02 |
2
|
119
|
10
|
|
0.00
|
|
|
select agtagentre0_.AGE_REG_IDX as AGE1_22_0_, agtagentre0_.NAME as NAME22_0_, agtagentre0_.DESCRIPTION as DESCRIPT3_22_0_, agtagentre0_.PROTECT_FOLDER as PROTECT4_22_0_, agtagentre0_.WHITE_LIST as WHITE5_22_0_, agtagentre0_.BASED as BASED22_0_, agtagentre0_.ACTIVE as ACTIVE22_0_, agtagentre0_.ACT_FAL_CAU_IDX as ACT8_22_0_, agtagentre0_.PARENT_IDX as PARENT9_22_0_, agtagentre0_.ACT_FAL_ID as ACT10_22_0_, agtagentre0_.PARENT as PARENT22_0_, agtagentre0_.P_ACTIVE as P12_22_0_, agtagentre0_.P_ACT_FAL_CAU_IDX as P13_22_0_, agtagentre0_.REG_DATE as REG14_22_0_ from AGT_AGENT_REGISTER agtagentre0_ where agtagentre0_.AGE_REG_IDX=? |
0.01 |
1
|
101
|
9
|
|
0.00
|
|
|
|
|
0.02 |
2
|
110
|
10
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.02 |
1
|
162
|
7
|
|
0.00
|
|
|
|
|
0.01 |
6
|
149
|
20
|
|
0.00
|
|
|
select AgtMessage.MSG_IDX as MSG1_61_0_, AgtMessage.ACTIVE as ACTIVE61_0_, AgtMessage.ACT_FAL_CAU_IDX as ACT3_61_0_, AgtMessage.PARENT_IDX as PARENT4_61_0_, AgtMessage.ACT_FAL_ID as ACT5_61_0_, AgtMessage.RCV_USR_IDX as RCV6_61_0_, AgtMessage.SND_USR_IDX as SND7_61_0_, AgtMessage.LIC_KEY_IDX as LIC8_61_0_, AgtMessage.SND_GRP_IDX as SND9_61_0_, AgtMessage.SND_LIC_KEY_IDX as SND10_61_0_, AgtMessage.SND_LEVEL as SND11_61_0_, AgtMessage.SND_NAME as SND12_61_0_, AgtMessage.SND_MAIL as SND13_61_0_, AgtMessage.AGENT_MEMBER as AGENT14_61_0_, AgtMessage.RCV_NAME as RCV15_61_0_, AgtMessage.RCV_MAIL as RCV16_61_0_, AgtMessage.PCID as PCID61_0_, AgtMessage.IP as IP61_0_, AgtMessage.PCNAME as PCNAME61_0_, AgtMessage.GRADE as GRADE61_0_, AgtMessage.TARGET as TARGET61_0_, AgtMessage.SOURCE as SOURCE61_0_, AgtMessage.TITLE as TITLE61_0_, AgtMessage.MESSAGE as MESSAGE61_0_, AgtMessage.ENC_FILE_REG_DATE as ENC25_61_0_, AgtMessage.FILE_NAME as FILE26_61_0_, AgtMessage.FILE_HASH_KEY as FILE27_61_0_, AgtMessage.SIGN as SIGN61_0_, AgtMessage.SIGN_DATE as SIGN29_61_0_, AgtMessage.DEC_USR_NAME as DEC30_61_0_, AgtMessage.REG_DATE as REG31_61_0_, AgtMessage.SND_DATE as SND32_61_0_ from AGT_MESSAGE AgtMessage where GRADE=? and LIC_KEY_IDX=? and ACTIVE=? |
0.04 |
8
|
279
|
18
|
|
0.00
|
|
|
select AgtMessage.MSG_IDX as MSG1_61_0_, AgtMessage.ACTIVE as ACTIVE61_0_, AgtMessage.ACT_FAL_CAU_IDX as ACT3_61_0_, AgtMessage.PARENT_IDX as PARENT4_61_0_, AgtMessage.ACT_FAL_ID as ACT5_61_0_, AgtMessage.RCV_USR_IDX as RCV6_61_0_, AgtMessage.SND_USR_IDX as SND7_61_0_, AgtMessage.LIC_KEY_IDX as LIC8_61_0_, AgtMessage.SND_GRP_IDX as SND9_61_0_, AgtMessage.SND_LIC_KEY_IDX as SND10_61_0_, AgtMessage.SND_LEVEL as SND11_61_0_, AgtMessage.SND_NAME as SND12_61_0_, AgtMessage.SND_MAIL as SND13_61_0_, AgtMessage.AGENT_MEMBER as AGENT14_61_0_, AgtMessage.RCV_NAME as RCV15_61_0_, AgtMessage.RCV_MAIL as RCV16_61_0_, AgtMessage.PCID as PCID61_0_, AgtMessage.IP as IP61_0_, AgtMessage.PCNAME as PCNAME61_0_, AgtMessage.GRADE as GRADE61_0_, AgtMessage.TARGET as TARGET61_0_, AgtMessage.SOURCE as SOURCE61_0_, AgtMessage.TITLE as TITLE61_0_, AgtMessage.MESSAGE as MESSAGE61_0_, AgtMessage.ENC_FILE_REG_DATE as ENC25_61_0_, AgtMessage.FILE_NAME as FILE26_61_0_, AgtMessage.FILE_HASH_KEY as FILE27_61_0_, AgtMessage.SIGN as SIGN61_0_, AgtMessage.SIGN_DATE as SIGN29_61_0_, AgtMessage.DEC_USR_NAME as DEC30_61_0_, AgtMessage.REG_DATE as REG31_61_0_, AgtMessage.SND_DATE as SND32_61_0_ from AGT_MESSAGE AgtMessage where RCV_USR_IDX=? and LIC_KEY_IDX=? and ACTIVE=? |
0.01 |
5
|
17
|
3
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_VACCINE_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, NAME, INSTALL, RUN, LAST_UPDATE, REAL_TIME_MONITOR, USR_IDX, GRP_IDX, LIC_KEY_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.05 |
2
|
262
|
18
|
|
0.00
|
|
|
|
|
0.02 |
1
|
108
|
7
|
|
0.00
|
|
|
select agtvaccine0_.VAC_LOG_IDX as VAC1_82_0_, agtvaccine0_.ID as ID82_0_, agtvaccine0_.PCID as PCID82_0_, agtvaccine0_.MAC as MAC82_0_, agtvaccine0_.PCNAME as PCNAME82_0_, agtvaccine0_.PAR_NAME as PAR6_82_0_, agtvaccine0_.PLY_NAME as PLY7_82_0_, agtvaccine0_.OS as OS82_0_, agtvaccine0_.IP as IP82_0_, agtvaccine0_.LIC_KEY as LIC10_82_0_, agtvaccine0_.USR_NAME as USR11_82_0_, agtvaccine0_.NAME as NAME82_0_, agtvaccine0_.INSTALL as INSTALL82_0_, agtvaccine0_.RUN as RUN82_0_, agtvaccine0_.LAST_UPDATE as LAST15_82_0_, agtvaccine0_.REAL_TIME_MONITOR as REAL16_82_0_, agtvaccine0_.USR_IDX as USR17_82_0_, agtvaccine0_.GRP_IDX as GRP18_82_0_, agtvaccine0_.LIC_KEY_IDX as LIC19_82_0_, agtvaccine0_.CURR_DATE as CURR20_82_0_, agtvaccine0_.REG_DATE as REG21_82_0_ from AGT_VACCINE_LOG agtvaccine0_ where agtvaccine0_.VAC_LOG_IDX=? |
0.04 |
0
|
64
|
5
|
|
0.00
|
|
|
insert into AGT_VACCINE_LOG_LATELY (USR_IDX, LIC_KEY_IDX, COUNT, START_VAC_LOG_IDX, END_VAC_LOG_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?) |
0.02 |
0
|
4
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
/* BATCH */ update AGT_USER_INSTALL set USR_IDX=?, INSTALL_USR_IDX=?, LIC_KEY=?, LIC_KEY_IDX=?, PCID=?, DEMO=?, CONNECT_TIME=?, INSTALL_TIME=?, IP=?, MAC=?, OS=?, PCNAME=?, VERSION_INFO=?, STATUS=?, PLY_NAME=?, PLY_IDX=?, PROGRESS=?, CHG_TYPE=? where INS_USR_IDX=? |
0.02 |
0
|
14
|
1
|
|
0.00
|
|
|
insert into AGT_AUTH_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, SRC_TYPE, ACT_TYPE, AGT_LOGIN_SUCESS, FAIL_CNT, LOGOUT_TYPE, LOGIN_FAIL_TYPE, USR_IDX, GRP_IDX, LIC_KEY_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.02 |
6
|
303
|
30
|
|
0.00
|
|
|
|
|
0.01 |
0
|
13
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select this_.PWD_IDX as PWD1_26_0_, this_.NAME as NAME26_0_, this_.BASED as BASED26_0_, this_.SPE_CHAR as SPE4_26_0_, this_.UPPERCASE as UPPERCASE26_0_, this_.LOWERCASE as LOWERCASE26_0_, this_.NUMBER as NUMBER26_0_, this_.SEL_LEN as SEL8_26_0_, this_.LENGTH as LENGTH26_0_, this_.TYPE as TYPE26_0_, this_.MONTH as MONTH26_0_, this_.DAY as DAY26_0_, this_.CNT_OF_WEEK as CNT13_26_0_, this_.WEEK as WEEK26_0_, this_.FAIL_CNT as FAIL15_26_0_, this_.FAIL_MIN as FAIL16_26_0_, this_.LOGOFF_MIN as LOGOFF17_26_0_, this_.MONTH1 as MONTH18_26_0_, this_.MONTH2 as MONTH19_26_0_, this_.MONTH3 as MONTH20_26_0_, this_.MONTH4 as MONTH21_26_0_, this_.MONTH5 as MONTH22_26_0_, this_.MONTH6 as MONTH23_26_0_, this_.MONTH7 as MONTH24_26_0_, this_.MONTH8 as MONTH25_26_0_, this_.MONTH9 as MONTH26_26_0_, this_.MONTH10 as MONTH27_26_0_, this_.MONTH11 as MONTH28_26_0_, this_.MONTH12 as MONTH29_26_0_, this_.IS_SHOW_DIALOG as IS30_26_0_, this_.IS_WIN_LOGIN as IS31_26_0_, this_.DESCRIPTION as DESCRIP32_26_0_, this_.ACTIVE as ACTIVE26_0_, this_.ACT_FAL_CAU_IDX as ACT34_26_0_, this_.PARENT_IDX as PARENT35_26_0_, this_.ACT_FAL_ID as ACT36_26_0_, this_.REG_DATE as REG37_26_0_ from AGT_PASSWORD this_ where this_.PWD_IDX=? and this_.ACTIVE=? limit ? |
0.00 |
1
|
46
|
4
|
|
0.00
|
|
|
insert into AGT_FIREWALL_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, NAME, BRK_IP, POPRT, DIRECTION, TYPE, START_PORT, END_PORT, START_IP, END_IP, PROCESS, URL, FORWARD_URL, USR_IDX, GRP_IDX, LIC_KEY_IDX, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.00 |
13
|
170
|
42
|
|
0.00
|
|
|
insert into AGT_FIREWALL_LOG_DAILY (USR_IDX, LIC_KEY_IDX, GRP_IDX, COUNT, UPDATE_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?) |
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select this_.FW_IDX as FW1_43_0_, this_.NAME as NAME43_0_, this_.BASED as BASED43_0_, this_.ACTIVE as ACTIVE43_0_, this_.ACT_FAL_CAU_IDX as ACT5_43_0_, this_.PARENT_IDX as PARENT6_43_0_, this_.ACT_FAL_ID as ACT7_43_0_, this_.DIRECTION as DIRECTION43_0_, this_.TYPE as TYPE43_0_, this_.START_PORT as START10_43_0_, this_.END_PORT as END11_43_0_, this_.START_IP as START12_43_0_, this_.END_IP as END13_43_0_, this_.PROCESS as PROCESS43_0_, this_.G_SERVERIP as G15_43_0_, this_.URL as URL43_0_, this_.FORWARD_URL as FORWARD17_43_0_, this_.REG_DATE as REG18_43_0_ from AGT_FIREWALL this_ where this_.FW_IDX=? and this_.ACTIVE=? limit ? |
0.04 |
0
|
7
|
4
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select this_.INS_USR_IDX as INS1_1_0_, this_.USR_IDX as USR2_1_0_, this_.INSTALL_USR_IDX as INSTALL3_1_0_, this_.LIC_KEY as LIC4_1_0_, this_.LIC_KEY_IDX as LIC5_1_0_, this_.PCID as PCID1_0_, this_.DEMO as DEMO1_0_, this_.CONNECT_TIME as CONNECT8_1_0_, this_.INSTALL_TIME as INSTALL9_1_0_, this_.IP as IP1_0_, this_.MAC as MAC1_0_, this_.OS as OS1_0_, this_.PCNAME as PCNAME1_0_, this_.VERSION_INFO as VERSION14_1_0_, this_.STATUS as STATUS1_0_, this_.PLY_NAME as PLY16_1_0_, this_.PLY_IDX as PLY17_1_0_, this_.PROGRESS as PROGRESS1_0_, this_.CHG_TYPE as CHG19_1_0_ from AGT_USER_INSTALL this_ where this_.LIC_KEY=? limit ? |
0.96 |
0
|
69
|
0
|
|
0.00
|
|
|
select this_.LIC_KEY_IDX as LIC1_51_0_, this_.ACTIVE as ACTIVE51_0_, this_.ACT_FAL_CAU_IDX as ACT3_51_0_, this_.PARENT_IDX as PARENT4_51_0_, this_.ACT_FAL_ID as ACT5_51_0_, this_.LIC_IDX as LIC6_51_0_, this_.USR_IDX as USR7_51_0_, this_.STATUS as STATUS51_0_, this_.BEFORE_STATUS as BEFORE9_51_0_, this_.LIC_KEY as LIC10_51_0_, this_.TEMP_LIC_KEY as TEMP11_51_0_, this_.STA_0_SND_MAIL_CNT as STA12_51_0_, this_.STA_2_SND_MAIL_CNT as STA13_51_0_, this_.IS_UPDATE as IS14_51_0_, this_.IS_DELETE as IS15_51_0_, this_.IS_PUBLIC as IS16_51_0_, this_.IS_DELETE_SHOW as IS17_51_0_, this_.STATUS_0_SEND_MAIL_REG_DATE as STATUS18_51_0_, this_.USR_IDX_REG_DATE as USR19_51_0_, this_.DELETE_REG_DATE as DELETE20_51_0_, this_.UPDATE_REG_DATE as UPDATE21_51_0_, this_.REG_ADMIN_IDX as REG22_51_0_, this_.DEL_ADMIN_IDX as DEL23_51_0_, this_.ENC_DUE_DATE as ENC24_51_0_, this_.ENC_DEL_DATE as ENC25_51_0_, this_.KEY_DATA as KEY26_51_0_, this_.DELETE_DATE as DELETE27_51_0_, this_.UPDATE_DATE as UPDATE28_51_0_, this_.REG_DATE as REG29_51_0_ from AGT_LICENSE_KEY this_ where this_.LIC_KEY=? and this_.ACTIVE=? limit ? |
0.09 |
0
|
6
|
0
|
|
0.00
|
|
|
select AgtLicenseKey.LIC_KEY_IDX as LIC1_51_0_, AgtLicenseKey.ACTIVE as ACTIVE51_0_, AgtLicenseKey.ACT_FAL_CAU_IDX as ACT3_51_0_, AgtLicenseKey.PARENT_IDX as PARENT4_51_0_, AgtLicenseKey.ACT_FAL_ID as ACT5_51_0_, AgtLicenseKey.LIC_IDX as LIC6_51_0_, AgtLicenseKey.USR_IDX as USR7_51_0_, AgtLicenseKey.STATUS as STATUS51_0_, AgtLicenseKey.BEFORE_STATUS as BEFORE9_51_0_, AgtLicenseKey.LIC_KEY as LIC10_51_0_, AgtLicenseKey.TEMP_LIC_KEY as TEMP11_51_0_, AgtLicenseKey.STA_0_SND_MAIL_CNT as STA12_51_0_, AgtLicenseKey.STA_2_SND_MAIL_CNT as STA13_51_0_, AgtLicenseKey.IS_UPDATE as IS14_51_0_, AgtLicenseKey.IS_DELETE as IS15_51_0_, AgtLicenseKey.IS_PUBLIC as IS16_51_0_, AgtLicenseKey.IS_DELETE_SHOW as IS17_51_0_, AgtLicenseKey.STATUS_0_SEND_MAIL_REG_DATE as STATUS18_51_0_, AgtLicenseKey.USR_IDX_REG_DATE as USR19_51_0_, AgtLicenseKey.DELETE_REG_DATE as DELETE20_51_0_, AgtLicenseKey.UPDATE_REG_DATE as UPDATE21_51_0_, AgtLicenseKey.REG_ADMIN_IDX as REG22_51_0_, AgtLicenseKey.DEL_ADMIN_IDX as DEL23_51_0_, AgtLicenseKey.ENC_DUE_DATE as ENC24_51_0_, AgtLicenseKey.ENC_DEL_DATE as ENC25_51_0_, AgtLicenseKey.KEY_DATA as KEY26_51_0_, AgtLicenseKey.DELETE_DATE as DELETE27_51_0_, AgtLicenseKey.UPDATE_DATE as UPDATE28_51_0_, AgtLicenseKey.REG_DATE as REG29_51_0_ from AGT_LICENSE_KEY AgtLicenseKey ORDER BY LIC_KEY DESC LIMIT 1 |
0.33 |
1
|
37
|
1
|
|
0.00
|
|
|
select AgtConfig.CONF_IDX as CONF1_26_0_, AgtConfig.PLY_MIN_CYC as PLY2_26_0_, AgtConfig.LOG_UPL_MIN_CYC as LOG3_26_0_, AgtConfig.LOG_SAVE_DAY as LOG4_26_0_, AgtConfig.FIL_OUT_SIGN as FIL5_26_0_, AgtConfig.FIL_IN_SIGN as FIL6_26_0_, AgtConfig.AGT_VER as AGT7_26_0_, AgtConfig.PW_SPE_CHAR as PW8_26_0_, AgtConfig.PW_UPPERCASE as PW9_26_0_, AgtConfig.PW_LOWERCASE as PW10_26_0_, AgtConfig.PW_NUMBER as PW11_26_0_, AgtConfig.PW_SEL_LEN as PW12_26_0_, AgtConfig.PW_LENGTH as PW13_26_0_, AgtConfig.PW_TYPE as PW14_26_0_, AgtConfig.PW_MONTH as PW15_26_0_, AgtConfig.PW_DAY as PW16_26_0_, AgtConfig.PW_CNT_OF_WEEK as PW17_26_0_, AgtConfig.PW_WEEK as PW18_26_0_, AgtConfig.FAIL_CNT as FAIL19_26_0_, AgtConfig.FAIL_MIN as FAIL20_26_0_, AgtConfig.LOGOFF_MIN as LOGOFF21_26_0_, AgtConfig.REP_SCH_CHK_TYPE as REP22_26_0_, AgtConfig.REP_SCH_CHK_MONTH as REP23_26_0_, AgtConfig.REP_SCH_CHK_DAY as REP24_26_0_, AgtConfig.REP_SCH_CHK_CNT_OF_WEEK as REP25_26_0_, AgtConfig.REP_SCH_CHK_WEEK as REP26_26_0_, AgtConfig.REP_SCH_CHK_USR_IDX as REP27_26_0_, AgtConfig.REP_SCH_CURR_DATE as REP28_26_0_, AgtConfig.REP_SCH_REG_DATE as REP29_26_0_, AgtConfig.LICENSE_DUE_DATE_CHECKING as LICENSE30_26_0_, AgtConfig.IS_USE_SEND_MAIL_ENC_FILE as IS31_26_0_, AgtConfig.IS_USE_NETWORK as IS32_26_0_, AgtConfig.IS_USE_WATER_MARK as IS33_26_0_, AgtConfig.IS_USE_USER_LOGIN as IS34_26_0_, AgtConfig.IS_USE_SEL_FILE_TYPE as IS35_26_0_, AgtConfig.IS_USE_SECURITY as IS36_26_0_, AgtConfig.IS_ENC_KEY as IS37_26_0_, AgtConfig.ENC_KEY as ENC38_26_0_, AgtConfig.IS_SHOW_POLICY_DIALOG as IS39_26_0_, AgtConfig.IS_SIMPLE_INSTALL as IS40_26_0_, AgtConfig.COUNTRY as COUNTRY26_0_, AgtConfig.REG_CAU as REG42_26_0_, AgtConfig.REG_DATE as REG43_26_0_ from AGT_CONFIG AgtConfig |
0.14 |
0
|
11
|
0
|
|
0.00
|
|
|
select agtuser0_.USR_IDX as USR1_0_0_, agtuser0_.ID as ID0_0_, agtuser0_.ORG_PASSWORD as ORG3_0_0_, agtuser0_.PASSWORD as PASSWORD0_0_, agtuser0_.FIRST_PWD as FIRST5_0_0_, agtuser0_.PWD_TYPE as PWD6_0_0_, agtuser0_.PWD_UPDATE_DATE as PWD7_0_0_, agtuser0_.PWD_DUE_DATE as PWD8_0_0_, agtuser0_.ORG_WEB_PASSWORD as ORG9_0_0_, agtuser0_.WEB_PASSWORD as WEB10_0_0_, agtuser0_.IS_CHG_WEB_PWD as IS11_0_0_, agtuser0_.WEB_PWD_UPDATE_DATE as WEB12_0_0_, agtuser0_.WEB_PWD_DUE_DATE as WEB13_0_0_, agtuser0_.ORG_SIGNER_PASSWORD as ORG14_0_0_, agtuser0_.SIGNER_PASSWORD as SIGNER15_0_0_, agtuser0_.IS_CHG_SIGNER_PWD as IS16_0_0_, agtuser0_.SIGNER_PWD_UPDATE_DATE as SIGNER17_0_0_, agtuser0_.SIGNER_PWD_DUE_DATE as SIGNER18_0_0_, agtuser0_.QUE_IDX as QUE19_0_0_, agtuser0_.ANSWER as ANSWER0_0_, agtuser0_.NAME as NAME0_0_, agtuser0_.TEL as TEL0_0_, agtuser0_.PHONE as PHONE0_0_, agtuser0_.EMAIL as EMAIL0_0_, agtuser0_.DEPARTMENT as DEPARTMENT0_0_, agtuser0_.POSITION as POSITION0_0_, agtuser0_.MEMO as MEMO0_0_, agtuser0_.ACTIVE as ACTIVE0_0_, agtuser0_.ACT_FAL_CAU_IDX as ACT29_0_0_, agtuser0_.PARENT_IDX as PARENT30_0_0_, agtuser0_.ACT_FAL_ID as ACT31_0_0_, agtuser0_.REG_DATE as REG32_0_0_, agtuser0_.UPDATE_DATE as UPDATE33_0_0_ from AGT_USER agtuser0_ where agtuser0_.USR_IDX=? |
0.18 |
0
|
118
|
2
|
|
0.00
|
|
|
|
|
0.14 |
0
|
50
|
1
|
|
0.00
|
|
|
select agtgroup0_.GRP_IDX as GRP1_30_0_, agtgroup0_.ACTIVE as ACTIVE30_0_, agtgroup0_.ACT_FAL_CAU_IDX as ACT3_30_0_, agtgroup0_.PARENT_IDX as PARENT4_30_0_, agtgroup0_.ACT_FAL_ID as ACT5_30_0_, agtgroup0_.NAME as NAME30_0_, agtgroup0_.DESCRIPTION as DESCRIPT7_30_0_, agtgroup0_.DEPTH as DEPTH30_0_, agtgroup0_.SEP as SEP30_0_, agtgroup0_.PARENT as PARENT30_0_, agtgroup0_.BASED as BASED30_0_, agtgroup0_.REG_DATE as REG12_30_0_ from AGT_GROUP agtgroup0_ where agtgroup0_.GRP_IDX=? |
0.13 |
0
|
42
|
1
|
|
0.00
|
|
|
|
|
0.14 |
0
|
7
|
0
|
|
0.00
|
|
|
select this_.PLY_IDX as PLY1_2_0_, this_.PARENT_IDX as PARENT2_2_0_, this_.ACT_FAL_ID as ACT3_2_0_, this_.ACTIVE as ACTIVE2_0_, this_.CREATE_USR_IDX as CREATE5_2_0_, this_.ACT_FAL_CAU_IDX as ACT6_2_0_, this_.GEN_PLY_IDX as GEN7_2_0_, this_.ENC_PLY_IDX as ENC8_2_0_, this_.PRO_PLY_IDX as PRO9_2_0_, this_.NAME as NAME2_0_, this_.PAT_CHG_TYPE as PAT11_2_0_, this_.DESCRIPTION as DESCRIP12_2_0_, this_.BASED as BASED2_0_, this_.COUNTRY as COUNTRY2_0_, this_.CHG_TYPE as CHG15_2_0_, this_.IDXES as IDXES2_0_, this_.ACT_FAL_CURR_DATE as ACT17_2_0_, this_.REG_DATE as REG18_2_0_ from AGT_POLICY this_ where this_.PLY_IDX=? and this_.ACTIVE=? limit ? |
0.14 |
0
|
12
|
0
|
|
0.00
|
|
|
select this_.GEN_PLY_IDX as GEN1_5_0_, this_.ACTIVE as ACTIVE5_0_, this_.ACT_FAL_CAU_IDX as ACT3_5_0_, this_.PARENT_IDX as PARENT4_5_0_, this_.ACT_FAL_ID as ACT5_5_0_, this_.PAT_PLY_IDX as PAT6_5_0_, this_.FIL_PLY_IDX as FIL7_5_0_, this_.KWD_PLY_IDX as KWD8_5_0_, this_.FOD_PLY_IDX as FOD9_5_0_, this_.PWD_PLY_IDX as PWD10_5_0_, this_.SCR_PLY_IDX as SCR11_5_0_, this_.WIN_PAC_PLY_IDX as WIN12_5_0_, this_.MDA_PLY_IDX as MDA13_5_0_, this_.FW_PLY_IDX as FW14_5_0_, this_.NTW_PLY_IDX as NTW15_5_0_, this_.VAC_PLY_IDX as VAC16_5_0_, this_.SMA_PHO_PRO_PLY_IDX as SMA17_5_0_, this_.REG_DATE as REG18_5_0_ from AGT_GENERAL_POLICY this_ where this_.GEN_PLY_IDX=? and this_.ACTIVE=? limit ? |
0.07 |
0
|
13
|
0
|
|
0.00
|
|
|
select this_.ENC_PLY_IDX as ENC1_3_0_, this_.ACTIVE as ACTIVE3_0_, this_.ACT_FAL_CAU_IDX as ACT3_3_0_, this_.PARENT_IDX as PARENT4_3_0_, this_.ACT_FAL_ID as ACT5_3_0_, this_.PAT_PLY_IDX as PAT6_3_0_, this_.FIL_PLY_IDX as FIL7_3_0_, this_.KWD_PLY_IDX as KWD8_3_0_, this_.FOD_PLY_IDX as FOD9_3_0_, this_.PWD_PLY_IDX as PWD10_3_0_, this_.SCR_PLY_IDX as SCR11_3_0_, this_.EXT_PLY_IDX as EXT12_3_0_, this_.PRO_FOL_PLY_IDX as PRO13_3_0_, this_.DFOD_PLY_IDX as DFOD14_3_0_, this_.WHI_LIS_PLY_IDX as WHI15_3_0_, this_.AGE_REG_PLY_IDX as AGE16_3_0_, this_.ATT_BLO_PLY_IDX as ATT17_3_0_, this_.REG_DATE as REG18_3_0_ from AGT_ENCRYPT_POLICY this_ where this_.ENC_PLY_IDX=? and this_.ACTIVE=? limit ? |
0.13 |
0
|
7
|
0
|
|
0.00
|
|
|
|
|
0.07 |
0
|
3
|
0
|
|
0.00
|
|
|
select this_.INS_USR_IDX as INS1_1_0_, this_.USR_IDX as USR2_1_0_, this_.INSTALL_USR_IDX as INSTALL3_1_0_, this_.LIC_KEY as LIC4_1_0_, this_.LIC_KEY_IDX as LIC5_1_0_, this_.PCID as PCID1_0_, this_.DEMO as DEMO1_0_, this_.CONNECT_TIME as CONNECT8_1_0_, this_.INSTALL_TIME as INSTALL9_1_0_, this_.IP as IP1_0_, this_.MAC as MAC1_0_, this_.OS as OS1_0_, this_.PCNAME as PCNAME1_0_, this_.VERSION_INFO as VERSION14_1_0_, this_.STATUS as STATUS1_0_, this_.PLY_NAME as PLY16_1_0_, this_.PLY_IDX as PLY17_1_0_, this_.PROGRESS as PROGRESS1_0_, this_.CHG_TYPE as CHG19_1_0_ from AGT_USER_INSTALL this_ where this_.LIC_KEY_IDX=? limit ? |
0.06 |
0
|
6
|
0
|
|
0.00
|
|
|
|
|
0.06 |
0
|
3
|
0
|
|
0.00
|
|
|
|
|
1.93 |
0
|
1
|
0
|
|
0.00
|
|
|
select agtlicense0_.LIC_IDX as LIC1_50_0_, agtlicense0_.ACTIVE as ACTIVE50_0_, agtlicense0_.ACT_FAL_CAU_IDX as ACT3_50_0_, agtlicense0_.PARENT_IDX as PARENT4_50_0_, agtlicense0_.ACT_FAL_ID as ACT5_50_0_, agtlicense0_.PAY_IDX as PAY6_50_0_, agtlicense0_.COUNT as COUNT50_0_, agtlicense0_.NAME as NAME50_0_, agtlicense0_.DESCRIPTION as DESCRIPT9_50_0_, agtlicense0_.DELAY_DAY_CNT as DELAY10_50_0_, agtlicense0_.DELAY_DAY_REG_DAY as DELAY11_50_0_, agtlicense0_.DUE_DATE as DUE12_50_0_, agtlicense0_.REG_DATE as REG13_50_0_, agtlicense0_.START_DATE as START14_50_0_, agtlicense0_.FIR_START_DATE as FIR15_50_0_, agtlicense0_.DEL_DATE as DEL16_50_0_, agtlicense0_.ENC_DEL_DATE as ENC17_50_0_, agtlicense0_.TYPE as TYPE50_0_ from AGT_LICENSE agtlicense0_ where agtlicense0_.LIC_IDX=? |
0.06 |
0
|
5
|
0
|
|
0.00
|
|
|
|
|
0.06 |
0
|
9
|
0
|
|
0.00
|
|
|
|
|
0.01 |
0
|
45
|
2
|
|
0.00
|
|
|
select agthddlog0_.HDD_LOG_IDX as HDD1_89_0_, agthddlog0_.ID as ID89_0_, agthddlog0_.PCID as PCID89_0_, agthddlog0_.MAC as MAC89_0_, agthddlog0_.PCNAME as PCNAME89_0_, agthddlog0_.PAR_NAME as PAR6_89_0_, agthddlog0_.PLY_NAME as PLY7_89_0_, agthddlog0_.OS as OS89_0_, agthddlog0_.IP as IP89_0_, agthddlog0_.LIC_KEY as LIC10_89_0_, agthddlog0_.USR_NAME as USR11_89_0_, agthddlog0_.USED as USED89_0_, agthddlog0_.TOTAL as TOTAL89_0_, agthddlog0_.USR_IDX as USR14_89_0_, agthddlog0_.GRP_IDX as GRP15_89_0_, agthddlog0_.LIC_KEY_IDX as LIC16_89_0_, agthddlog0_.WORKGROUP as WORKGROUP89_0_, agthddlog0_.CPU as CPU89_0_, agthddlog0_.RAM as RAM89_0_, agthddlog0_.CURR_DATE as CURR20_89_0_, agthddlog0_.REG_DATE as REG21_89_0_ from AGT_HDD_LOG agthddlog0_ where agthddlog0_.HDD_LOG_IDX=? |
0.01 |
0
|
40
|
4
|
|
0.00
|
|
|
select AgtAlertConfig.ALE_CONF_IDX as ALE1_61_0_, AgtAlertConfig.ACTIVE as ACTIVE61_0_, AgtAlertConfig.ACT_FAL_CAU_IDX as ACT3_61_0_, AgtAlertConfig.PARENT_IDX as PARENT4_61_0_, AgtAlertConfig.ACT_FAL_ID as ACT5_61_0_, AgtAlertConfig.REG_USR_IDX as REG6_61_0_, AgtAlertConfig.IS_USE as IS7_61_0_, AgtAlertConfig.AGT_LOG_SCH_CHK_MINUTE_DIVIDE as AGT8_61_0_, AgtAlertConfig.AGT_LOG_SCH_CHK_MINUTE as AGT9_61_0_, AgtAlertConfig.AGT_LOG_SCH_CHECKING as AGT10_61_0_, AgtAlertConfig.AGT_PWD_DUE_DATE as AGT11_61_0_, AgtAlertConfig.AGT_LOGIN_FAIL as AGT12_61_0_, AgtAlertConfig.AGT_LOGIN_FAIL_CNT as AGT13_61_0_, AgtAlertConfig.AGT_LOGIN_FAIL_SLP_TIME as AGT14_61_0_, AgtAlertConfig.VAC_INS as VAC15_61_0_, AgtAlertConfig.VAC_RUN as VAC16_61_0_, AgtAlertConfig.VAC_LAST_VER as VAC17_61_0_, AgtAlertConfig.VAC_REALTIME as VAC18_61_0_, AgtAlertConfig.HDD_SPACE as HDD19_61_0_, AgtAlertConfig.HDD_SPACE_REMAIN as HDD20_61_0_, AgtAlertConfig.PUB_FOL as PUB21_61_0_, AgtAlertConfig.WIN_PATCH as WIN22_61_0_, AgtAlertConfig.AGENT_UPDATE as AGENT23_61_0_, AgtAlertConfig.ENC_FIL_OUT as ENC24_61_0_, AgtAlertConfig.ENC_FIL_PRN as ENC25_61_0_, AgtAlertConfig.ENC_FIL_DEL as ENC26_61_0_, AgtAlertConfig.ENC_FIL_OUT_DEC as ENC27_61_0_, AgtAlertConfig.CHG_USR_INFO as CHG28_61_0_, AgtAlertConfig.CHG_PLY as CHG29_61_0_, AgtAlertConfig.ENC_FIL_DEC_SIGN as ENC30_61_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL as MGT31_61_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL_CNT as MGT32_61_0_, AgtAlertConfig.MGT_LOGIN_FAIL_SLP_TIME as MGT33_61_0_, AgtAlertConfig.MGT_USR_LOGIN as MGT34_61_0_, AgtAlertConfig.MGT_PWD_DUE_DATE as MGT35_61_0_, AgtAlertConfig.AGT_USR_DEL_AND_RUN_AGT as AGT36_61_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_CHECKING as AGT37_61_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_CHK_HOUR as AGT38_61_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_CHK_MINUTE as AGT39_61_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_CHECKING as MGT40_61_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_CHK_HOUR as MGT41_61_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_CHK_MINUTE as MGT42_61_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_SND_EMAIL as AGT43_61_0_, AgtAlertConfig.AGT_LOGIN_FAIL_SND_EMAIL as AGT44_61_0_, AgtAlertConfig.MGT_USR_LOGIN_SND_EMAIL as MGT45_61_0_, AgtAlertConfig.VAC_INS_SND_EMAIL as VAC46_61_0_, AgtAlertConfig.VAC_RUN_SND_EMAIL as VAC47_61_0_, AgtAlertConfig.VAC_LAST_VER_SND_EMAIL as VAC48_61_0_, AgtAlertConfig.VAC_REALTIME_SND_EMAIL as VAC49_61_0_, AgtAlertConfig.HDD_SPACE_SND_EMAIL as HDD50_61_0_, AgtAlertConfig.PUB_FOL_SND_EMAIL as PUB51_61_0_, AgtAlertConfig.WIN_PATCH_AND_SND_EMAIL as WIN52_61_0_, AgtAlertConfig.AGENT_UPDATE_AND_SND_EMAIL as AGENT53_61_0_, AgtAlertConfig.ENC_FIL_OUT_SND_EMAIL as ENC54_61_0_, AgtAlertConfig.ENC_FIL_PRN_SND_EMAIL as ENC55_61_0_, AgtAlertConfig.ENC_FIL_DEL_SND_EMAIL as ENC56_61_0_, AgtAlertConfig.ENC_FIL_OUT_DEC_SND_EMAIL as ENC57_61_0_, AgtAlertConfig.CHG_USR_INFO_SND_EMAIL as CHG58_61_0_, AgtAlertConfig.CHG_PLY_SND_EMAIL as CHG59_61_0_, AgtAlertConfig.ENC_FIL_DEC_SIGN_SND_EMAIL as ENC60_61_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL_SND_EMAIL as MGT61_61_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_SND_EMAIL as MGT62_61_0_, AgtAlertConfig.AGT_USR_DEL_AND_RUN_AGT_SND_EMAIL as AGT63_61_0_, AgtAlertConfig.AGT_PWD_DUE_DATE_SND_MESSAGE as AGT64_61_0_, AgtAlertConfig.AGT_LOGIN_FAIL_SND_MESSAGE as AGT65_61_0_, AgtAlertConfig.MGT_USR_LOGIN_SND_MESSAGE as MGT66_61_0_, AgtAlertConfig.VAC_INS_SND_MESSAGE as VAC67_61_0_, AgtAlertConfig.VAC_RUN_SND_MESSAGE as VAC68_61_0_, AgtAlertConfig.VAC_LAST_VER_SND_MESSAGE as VAC69_61_0_, AgtAlertConfig.VAC_REALTIME_SND_MESSAGE as VAC70_61_0_, AgtAlertConfig.HDD_SPACE_SND_MESSAGE as HDD71_61_0_, AgtAlertConfig.PUB_FOL_SND_MESSAGE as PUB72_61_0_, AgtAlertConfig.WIN_PATCH_AND_SND_MESSAGE as WIN73_61_0_, AgtAlertConfig.AGENT_UPDATE_AND_SND_MESSAGE as AGENT74_61_0_, AgtAlertConfig.ENC_FIL_OUT_SND_MESSAGE as ENC75_61_0_, AgtAlertConfig.ENC_FIL_PRN_SND_MESSAGE as ENC76_61_0_, AgtAlertConfig.ENC_FIL_DEL_SND_MESSAGE as ENC77_61_0_, AgtAlertConfig.ENC_FIL_OUT_DEC_SND_MESSAGE as ENC78_61_0_, AgtAlertConfig.CHG_USR_INFO_SND_MESSAGE as CHG79_61_0_, AgtAlertConfig.CHG_PLY_SND_MESSAGE as CHG80_61_0_, AgtAlertConfig.ENC_FIL_DEC_SIGN_SND_MESSAGE as ENC81_61_0_, AgtAlertConfig.MGT_USR_LOGIN_FAIL_SND_MESSAGE as MGT82_61_0_, AgtAlertConfig.MGT_PWD_DUE_DATE_SND_MESSAGE as MGT83_61_0_, AgtAlertConfig.AGT_USR_DEL_AND_RUN_AGT_SND_MESSAGE as AGT84_61_0_, AgtAlertConfig.ACT_FAL_CURR_DATE as ACT85_61_0_, AgtAlertConfig.REG_DATE as REG86_61_0_ from AGT_ALERT_CONFIG AgtAlertConfig |
0.02 |
1
|
4
|
0
|
|
0.00
|
|
|
select agtlicense0_.LIC_KEY_IDX as LIC1_51_0_, agtlicense0_.ACTIVE as ACTIVE51_0_, agtlicense0_.ACT_FAL_CAU_IDX as ACT3_51_0_, agtlicense0_.PARENT_IDX as PARENT4_51_0_, agtlicense0_.ACT_FAL_ID as ACT5_51_0_, agtlicense0_.LIC_IDX as LIC6_51_0_, agtlicense0_.USR_IDX as USR7_51_0_, agtlicense0_.STATUS as STATUS51_0_, agtlicense0_.BEFORE_STATUS as BEFORE9_51_0_, agtlicense0_.LIC_KEY as LIC10_51_0_, agtlicense0_.TEMP_LIC_KEY as TEMP11_51_0_, agtlicense0_.STA_0_SND_MAIL_CNT as STA12_51_0_, agtlicense0_.STA_2_SND_MAIL_CNT as STA13_51_0_, agtlicense0_.IS_UPDATE as IS14_51_0_, agtlicense0_.IS_DELETE as IS15_51_0_, agtlicense0_.IS_PUBLIC as IS16_51_0_, agtlicense0_.IS_DELETE_SHOW as IS17_51_0_, agtlicense0_.STATUS_0_SEND_MAIL_REG_DATE as STATUS18_51_0_, agtlicense0_.USR_IDX_REG_DATE as USR19_51_0_, agtlicense0_.DELETE_REG_DATE as DELETE20_51_0_, agtlicense0_.UPDATE_REG_DATE as UPDATE21_51_0_, agtlicense0_.REG_ADMIN_IDX as REG22_51_0_, agtlicense0_.DEL_ADMIN_IDX as DEL23_51_0_, agtlicense0_.ENC_DUE_DATE as ENC24_51_0_, agtlicense0_.ENC_DEL_DATE as ENC25_51_0_, agtlicense0_.KEY_DATA as KEY26_51_0_, agtlicense0_.DELETE_DATE as DELETE27_51_0_, agtlicense0_.UPDATE_DATE as UPDATE28_51_0_, agtlicense0_.REG_DATE as REG29_51_0_ from AGT_LICENSE_KEY agtlicense0_ where agtlicense0_.LIC_KEY_IDX=? |
0.03 |
0
|
8
|
0
|
|
0.00
|
|
|
|
|
0.00 |
3
|
51
|
12
|
|
0.00
|
|
|
|
|
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
select agtvaccine0_.VAC_LOG_IDX as VAC1_74_0_, agtvaccine0_.ID as ID74_0_, agtvaccine0_.PCID as PCID74_0_, agtvaccine0_.MAC as MAC74_0_, agtvaccine0_.PCNAME as PCNAME74_0_, agtvaccine0_.PAR_NAME as PAR6_74_0_, agtvaccine0_.PLY_NAME as PLY7_74_0_, agtvaccine0_.OS as OS74_0_, agtvaccine0_.IP as IP74_0_, agtvaccine0_.LIC_KEY as LIC10_74_0_, agtvaccine0_.USR_NAME as USR11_74_0_, agtvaccine0_.NAME as NAME74_0_, agtvaccine0_.INSTALL as INSTALL74_0_, agtvaccine0_.RUN as RUN74_0_, agtvaccine0_.LAST_UPDATE as LAST15_74_0_, agtvaccine0_.REAL_TIME_MONITOR as REAL16_74_0_, agtvaccine0_.USR_IDX as USR17_74_0_, agtvaccine0_.GRP_IDX as GRP18_74_0_, agtvaccine0_.LIC_KEY_IDX as LIC19_74_0_, agtvaccine0_.CURR_DATE as CURR20_74_0_, agtvaccine0_.REG_DATE as REG21_74_0_ from AGT_VACCINE_LOG agtvaccine0_ where agtvaccine0_.VAC_LOG_IDX=? |
0.01 |
1
|
26
|
5
|
|
0.00
|
|
|
|
|
0.00 |
0
|
4
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select AgtMessage.MSG_IDX as MSG1_53_0_, AgtMessage.ACTIVE as ACTIVE53_0_, AgtMessage.ACT_FAL_CAU_IDX as ACT3_53_0_, AgtMessage.PARENT_IDX as PARENT4_53_0_, AgtMessage.ACT_FAL_ID as ACT5_53_0_, AgtMessage.RCV_USR_IDX as RCV6_53_0_, AgtMessage.SND_USR_IDX as SND7_53_0_, AgtMessage.LIC_KEY_IDX as LIC8_53_0_, AgtMessage.SND_GRP_IDX as SND9_53_0_, AgtMessage.SND_LIC_KEY_IDX as SND10_53_0_, AgtMessage.SND_LEVEL as SND11_53_0_, AgtMessage.SND_NAME as SND12_53_0_, AgtMessage.SND_MAIL as SND13_53_0_, AgtMessage.AGENT_MEMBER as AGENT14_53_0_, AgtMessage.RCV_NAME as RCV15_53_0_, AgtMessage.RCV_MAIL as RCV16_53_0_, AgtMessage.PCID as PCID53_0_, AgtMessage.IP as IP53_0_, AgtMessage.PCNAME as PCNAME53_0_, AgtMessage.GRADE as GRADE53_0_, AgtMessage.TARGET as TARGET53_0_, AgtMessage.SOURCE as SOURCE53_0_, AgtMessage.TITLE as TITLE53_0_, AgtMessage.MESSAGE as MESSAGE53_0_, AgtMessage.ENC_FILE_REG_DATE as ENC25_53_0_, AgtMessage.FILE_NAME as FILE26_53_0_, AgtMessage.FILE_HASH_KEY as FILE27_53_0_, AgtMessage.SIGN as SIGN53_0_, AgtMessage.SIGN_DATE as SIGN29_53_0_, AgtMessage.DEC_USR_NAME as DEC30_53_0_, AgtMessage.REG_DATE as REG31_53_0_, AgtMessage.SND_DATE as SND32_53_0_ from AGT_MESSAGE AgtMessage where GRADE=? and LIC_KEY_IDX=? and ACTIVE=? |
0.01 |
8
|
68
|
16
|
|
0.00
|
|
|
select AgtMessage.MSG_IDX as MSG1_53_0_, AgtMessage.ACTIVE as ACTIVE53_0_, AgtMessage.ACT_FAL_CAU_IDX as ACT3_53_0_, AgtMessage.PARENT_IDX as PARENT4_53_0_, AgtMessage.ACT_FAL_ID as ACT5_53_0_, AgtMessage.RCV_USR_IDX as RCV6_53_0_, AgtMessage.SND_USR_IDX as SND7_53_0_, AgtMessage.LIC_KEY_IDX as LIC8_53_0_, AgtMessage.SND_GRP_IDX as SND9_53_0_, AgtMessage.SND_LIC_KEY_IDX as SND10_53_0_, AgtMessage.SND_LEVEL as SND11_53_0_, AgtMessage.SND_NAME as SND12_53_0_, AgtMessage.SND_MAIL as SND13_53_0_, AgtMessage.AGENT_MEMBER as AGENT14_53_0_, AgtMessage.RCV_NAME as RCV15_53_0_, AgtMessage.RCV_MAIL as RCV16_53_0_, AgtMessage.PCID as PCID53_0_, AgtMessage.IP as IP53_0_, AgtMessage.PCNAME as PCNAME53_0_, AgtMessage.GRADE as GRADE53_0_, AgtMessage.TARGET as TARGET53_0_, AgtMessage.SOURCE as SOURCE53_0_, AgtMessage.TITLE as TITLE53_0_, AgtMessage.MESSAGE as MESSAGE53_0_, AgtMessage.ENC_FILE_REG_DATE as ENC25_53_0_, AgtMessage.FILE_NAME as FILE26_53_0_, AgtMessage.FILE_HASH_KEY as FILE27_53_0_, AgtMessage.SIGN as SIGN53_0_, AgtMessage.SIGN_DATE as SIGN29_53_0_, AgtMessage.DEC_USR_NAME as DEC30_53_0_, AgtMessage.REG_DATE as REG31_53_0_, AgtMessage.SND_DATE as SND32_53_0_ from AGT_MESSAGE AgtMessage where RCV_USR_IDX=? and LIC_KEY_IDX=? and ACTIVE=? |
0.00 |
6
|
16
|
3
|
|
0.00
|
|
|
|
|
0.00 |
1
|
54
|
4
|
|
0.00
|
|
|
|
|
0.00 |
0
|
7
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
33
|
2
|
|
0.00
|
|
|
select AgtFirewallPolicy.FW_PLY_IDX as FW1_36_0_, AgtFirewallPolicy.FW_IDX as FW2_36_0_, AgtFirewallPolicy.FW_IDX_FOR_PRESET as FW3_36_0_, AgtFirewallPolicy.ACTIVE as ACTIVE36_0_, AgtFirewallPolicy.ACT_FAL_CAU_IDX as ACT5_36_0_, AgtFirewallPolicy.PARENT_IDX as PARENT6_36_0_, AgtFirewallPolicy.ACT_FAL_ID as ACT7_36_0_, AgtFirewallPolicy.GEN_PLY_IDX as GEN8_36_0_, AgtFirewallPolicy.ENC_PLY_IDX as ENC9_36_0_, AgtFirewallPolicy.PRO_PLY_IDX as PRO10_36_0_, AgtFirewallPolicy.IS_PRESET as IS11_36_0_, AgtFirewallPolicy.IS_USE as IS12_36_0_, AgtFirewallPolicy.REG_DATE as REG13_36_0_ from AGT_FIREWALL_POLICY AgtFirewallPolicy where GEN_PLY_IDX=? and ACTIVE=? |
0.00 |
0
|
16
|
1
|
|
0.00
|
|
|
|
|
0.00 |
0
|
8
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
59
|
5
|
|
0.00
|
|
|
|
|
0.00 |
0
|
67
|
6
|
|
0.00
|
|
|
|
|
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
select agtagentre0_.AGE_REG_IDX as AGE1_14_0_, agtagentre0_.NAME as NAME14_0_, agtagentre0_.DESCRIPTION as DESCRIPT3_14_0_, agtagentre0_.PROTECT_FOLDER as PROTECT4_14_0_, agtagentre0_.WHITE_LIST as WHITE5_14_0_, agtagentre0_.BASED as BASED14_0_, agtagentre0_.ACTIVE as ACTIVE14_0_, agtagentre0_.ACT_FAL_CAU_IDX as ACT8_14_0_, agtagentre0_.PARENT_IDX as PARENT9_14_0_, agtagentre0_.ACT_FAL_ID as ACT10_14_0_, agtagentre0_.PARENT as PARENT14_0_, agtagentre0_.P_ACTIVE as P12_14_0_, agtagentre0_.P_ACT_FAL_CAU_IDX as P13_14_0_, agtagentre0_.REG_DATE as REG14_14_0_ from AGT_AGENT_REGISTER agtagentre0_ where agtagentre0_.AGE_REG_IDX=? |
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_FILE_OCC_PAT_KWD_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, FIL_NAME, FULL_PATH, FIL_HASH_KEY, FIL_ENC_KEY, ENC_SUCESS, PAT_NAME, PAT_OCC_CNT, PAT_CHK_CNT, KEYWORD, KWD_OCC_CNT, KWD_CHK_CNT, USR_IDX, GRP_IDX, LIC_KEY_IDX, PLY_IDX, FIL_OCC_PAT_KWD_LOG_LAT_IDX, PAT_ID, CHG_TYPE, MAS_NAME, AGT_EXIST, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.05 |
4
|
5,927
|
129
|
|
0.00
|
|
|
|
|
0.08 |
0
|
4
|
0
|
|
0.00
|
|
|
|
|
0.05 |
0
|
13
|
0
|
|
0.00
|
|
|
/* BATCH */ update AGT_FILE_OCC_PAT_KWD_LOG set ID=?, PCID=?, MAC=?, PCNAME=?, PAR_NAME=?, PLY_NAME=?, OS=?, IP=?, LIC_KEY=?, USR_NAME=?, FIL_NAME=?, FULL_PATH=?, FIL_HASH_KEY=?, FIL_ENC_KEY=?, ENC_SUCESS=?, PAT_NAME=?, PAT_OCC_CNT=?, PAT_CHK_CNT=?, KEYWORD=?, KWD_OCC_CNT=?, KWD_CHK_CNT=?, USR_IDX=?, GRP_IDX=?, LIC_KEY_IDX=?, PLY_IDX=?, FIL_OCC_PAT_KWD_LOG_LAT_IDX=?, PAT_ID=?, CHG_TYPE=?, MAS_NAME=?, AGT_EXIST=?, CURR_DATE=?, REG_DATE=? where FIL_OCC_PAT_KWD_LOG_IDX=? |
0.05 |
0
|
34
|
1
|
|
0.00
|
|
|
|
|
0.01 |
0
|
95
|
4
|
|
0.00
|
|
|
|
|
0.04 |
0
|
18
|
1
|
|
0.00
|
|
|
select AgtFileOccPatKwdLog.FIL_OCC_PAT_KWD_LOG_IDX as FIL1_91_0_, AgtFileOccPatKwdLog.ID as ID91_0_, AgtFileOccPatKwdLog.PCID as PCID91_0_, AgtFileOccPatKwdLog.MAC as MAC91_0_, AgtFileOccPatKwdLog.PCNAME as PCNAME91_0_, AgtFileOccPatKwdLog.PAR_NAME as PAR6_91_0_, AgtFileOccPatKwdLog.PLY_NAME as PLY7_91_0_, AgtFileOccPatKwdLog.OS as OS91_0_, AgtFileOccPatKwdLog.IP as IP91_0_, AgtFileOccPatKwdLog.LIC_KEY as LIC10_91_0_, AgtFileOccPatKwdLog.USR_NAME as USR11_91_0_, AgtFileOccPatKwdLog.FIL_NAME as FIL12_91_0_, AgtFileOccPatKwdLog.FULL_PATH as FULL13_91_0_, AgtFileOccPatKwdLog.FIL_HASH_KEY as FIL14_91_0_, AgtFileOccPatKwdLog.FIL_ENC_KEY as FIL15_91_0_, AgtFileOccPatKwdLog.ENC_SUCESS as ENC16_91_0_, AgtFileOccPatKwdLog.PAT_NAME as PAT17_91_0_, AgtFileOccPatKwdLog.PAT_OCC_CNT as PAT18_91_0_, AgtFileOccPatKwdLog.PAT_CHK_CNT as PAT19_91_0_, AgtFileOccPatKwdLog.KEYWORD as KEYWORD91_0_, AgtFileOccPatKwdLog.KWD_OCC_CNT as KWD21_91_0_, AgtFileOccPatKwdLog.KWD_CHK_CNT as KWD22_91_0_, AgtFileOccPatKwdLog.USR_IDX as USR23_91_0_, AgtFileOccPatKwdLog.GRP_IDX as GRP24_91_0_, AgtFileOccPatKwdLog.LIC_KEY_IDX as LIC25_91_0_, AgtFileOccPatKwdLog.PLY_IDX as PLY26_91_0_, AgtFileOccPatKwdLog.FIL_OCC_PAT_KWD_LOG_LAT_IDX as FIL27_91_0_, AgtFileOccPatKwdLog.PAT_ID as PAT28_91_0_, AgtFileOccPatKwdLog.CHG_TYPE as CHG29_91_0_, AgtFileOccPatKwdLog.MAS_NAME as MAS30_91_0_, AgtFileOccPatKwdLog.AGT_EXIST as AGT31_91_0_, AgtFileOccPatKwdLog.CURR_DATE as CURR32_91_0_, AgtFileOccPatKwdLog.REG_DATE as REG33_91_0_ from AGT_FILE_OCC_PAT_KWD_LOG AgtFileOccPatKwdLog where FIL_OCC_PAT_KWD_LOG_LAT_IDX=? and LIC_KEY_IDX=? and USR_IDX=? order by REG_DATE desc LIMIT 1 |
0.01 |
30
|
332
|
34
|
|
0.00
|
|
|
|
|
0.01 |
0
|
60
|
2
|
|
0.00
|
|
|
|
|
0.01 |
0
|
13
|
0
|
|
0.00
|
|
|
insert into AGT_FILE_OCC_PAT_KWD_DELETE_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, FIL_NAME, FULL_PATH, FIL_HASH_KEY, FIL_ENC_KEY, ENC_SUCESS, PAT_NAME, PAT_OCC_CNT, PAT_CHK_CNT, KEYWORD, KWD_OCC_CNT, KWD_CHK_CNT, USR_IDX, GRP_IDX, LIC_KEY_IDX, PLY_IDX, PAT_ID, CHG_TYPE, MAS_NAME, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.04 |
2
|
216
|
15
|
|
0.00
|
|
|
select this_.FIL_OCC_PAT_KWD_LOG_IDX as FIL1_91_0_, this_.ID as ID91_0_, this_.PCID as PCID91_0_, this_.MAC as MAC91_0_, this_.PCNAME as PCNAME91_0_, this_.PAR_NAME as PAR6_91_0_, this_.PLY_NAME as PLY7_91_0_, this_.OS as OS91_0_, this_.IP as IP91_0_, this_.LIC_KEY as LIC10_91_0_, this_.USR_NAME as USR11_91_0_, this_.FIL_NAME as FIL12_91_0_, this_.FULL_PATH as FULL13_91_0_, this_.FIL_HASH_KEY as FIL14_91_0_, this_.FIL_ENC_KEY as FIL15_91_0_, this_.ENC_SUCESS as ENC16_91_0_, this_.PAT_NAME as PAT17_91_0_, this_.PAT_OCC_CNT as PAT18_91_0_, this_.PAT_CHK_CNT as PAT19_91_0_, this_.KEYWORD as KEYWORD91_0_, this_.KWD_OCC_CNT as KWD21_91_0_, this_.KWD_CHK_CNT as KWD22_91_0_, this_.USR_IDX as USR23_91_0_, this_.GRP_IDX as GRP24_91_0_, this_.LIC_KEY_IDX as LIC25_91_0_, this_.PLY_IDX as PLY26_91_0_, this_.FIL_OCC_PAT_KWD_LOG_LAT_IDX as FIL27_91_0_, this_.PAT_ID as PAT28_91_0_, this_.CHG_TYPE as CHG29_91_0_, this_.MAS_NAME as MAS30_91_0_, this_.AGT_EXIST as AGT31_91_0_, this_.CURR_DATE as CURR32_91_0_, this_.REG_DATE as REG33_91_0_ from AGT_FILE_OCC_PAT_KWD_LOG this_ where this_.FIL_OCC_PAT_KWD_LOG_LAT_IDX=? and this_.LIC_KEY_IDX=? and this_.USR_IDX=? and this_.FULL_PATH=? and this_.FIL_HASH_KEY=? and this_.PLY_IDX=? limit ? |
0.01 |
33
|
384
|
43
|
|
0.00
|
|
|
select this_.FW_IDX as FW1_35_0_, this_.NAME as NAME35_0_, this_.BASED as BASED35_0_, this_.ACTIVE as ACTIVE35_0_, this_.ACT_FAL_CAU_IDX as ACT5_35_0_, this_.PARENT_IDX as PARENT6_35_0_, this_.ACT_FAL_ID as ACT7_35_0_, this_.DIRECTION as DIRECTION35_0_, this_.TYPE as TYPE35_0_, this_.START_PORT as START10_35_0_, this_.END_PORT as END11_35_0_, this_.START_IP as START12_35_0_, this_.END_IP as END13_35_0_, this_.PROCESS as PROCESS35_0_, this_.G_SERVERIP as G15_35_0_, this_.URL as URL35_0_, this_.FORWARD_URL as FORWARD17_35_0_, this_.REG_DATE as REG18_35_0_ from AGT_FIREWALL this_ where this_.FW_IDX=? and this_.ACTIVE=? limit ? |
0.01 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
2
|
56
|
8
|
|
0.00
|
|
|
insert into AGT_PRINT_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, FULL_PATH, FILE_NAME, PAGES, COPY_CNT, PRT_NAME, TYPE, USR_IDX, GRP_IDX, LIC_KEY_IDX, PAT_NAME, PAT_OCC_CNT, PAT_CHK_CNT, KEYWORD, KWD_OCC_CNT, KWD_CHK_CNT, PAT_ID, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
2.70 |
0
|
758
|
4
|
|
0.33
|
|
|
|
|
0.09 |
0
|
66
|
3
|
|
0.00
|
|
|
|
|
0.04 |
0
|
57
|
4
|
|
0.00
|
|
|
select AgtFileOccPatKwdLog.FIL_OCC_PAT_KWD_LOG_IDX as FIL1_99_0_, AgtFileOccPatKwdLog.ID as ID99_0_, AgtFileOccPatKwdLog.PCID as PCID99_0_, AgtFileOccPatKwdLog.MAC as MAC99_0_, AgtFileOccPatKwdLog.PCNAME as PCNAME99_0_, AgtFileOccPatKwdLog.PAR_NAME as PAR6_99_0_, AgtFileOccPatKwdLog.PLY_NAME as PLY7_99_0_, AgtFileOccPatKwdLog.OS as OS99_0_, AgtFileOccPatKwdLog.IP as IP99_0_, AgtFileOccPatKwdLog.LIC_KEY as LIC10_99_0_, AgtFileOccPatKwdLog.USR_NAME as USR11_99_0_, AgtFileOccPatKwdLog.FIL_NAME as FIL12_99_0_, AgtFileOccPatKwdLog.FULL_PATH as FULL13_99_0_, AgtFileOccPatKwdLog.FIL_HASH_KEY as FIL14_99_0_, AgtFileOccPatKwdLog.FIL_ENC_KEY as FIL15_99_0_, AgtFileOccPatKwdLog.ENC_SUCESS as ENC16_99_0_, AgtFileOccPatKwdLog.PAT_NAME as PAT17_99_0_, AgtFileOccPatKwdLog.PAT_OCC_CNT as PAT18_99_0_, AgtFileOccPatKwdLog.PAT_CHK_CNT as PAT19_99_0_, AgtFileOccPatKwdLog.KEYWORD as KEYWORD99_0_, AgtFileOccPatKwdLog.KWD_OCC_CNT as KWD21_99_0_, AgtFileOccPatKwdLog.KWD_CHK_CNT as KWD22_99_0_, AgtFileOccPatKwdLog.USR_IDX as USR23_99_0_, AgtFileOccPatKwdLog.GRP_IDX as GRP24_99_0_, AgtFileOccPatKwdLog.LIC_KEY_IDX as LIC25_99_0_, AgtFileOccPatKwdLog.PLY_IDX as PLY26_99_0_, AgtFileOccPatKwdLog.FIL_OCC_PAT_KWD_LOG_LAT_IDX as FIL27_99_0_, AgtFileOccPatKwdLog.PAT_ID as PAT28_99_0_, AgtFileOccPatKwdLog.CHG_TYPE as CHG29_99_0_, AgtFileOccPatKwdLog.MAS_NAME as MAS30_99_0_, AgtFileOccPatKwdLog.AGT_EXIST as AGT31_99_0_, AgtFileOccPatKwdLog.CURR_DATE as CURR32_99_0_, AgtFileOccPatKwdLog.REG_DATE as REG33_99_0_ from AGT_FILE_OCC_PAT_KWD_LOG AgtFileOccPatKwdLog where FIL_OCC_PAT_KWD_LOG_LAT_IDX=? and LIC_KEY_IDX=? and USR_IDX=? order by REG_DATE desc LIMIT 1 |
0.02 |
41
|
1,271
|
88
|
|
0.00
|
|
|
|
|
0.04 |
0
|
71
|
2
|
|
0.00
|
|
|
|
|
0.04 |
0
|
18
|
0
|
|
0.00
|
|
|
select this_.FIL_OCC_PAT_KWD_LOG_IDX as FIL1_99_0_, this_.ID as ID99_0_, this_.PCID as PCID99_0_, this_.MAC as MAC99_0_, this_.PCNAME as PCNAME99_0_, this_.PAR_NAME as PAR6_99_0_, this_.PLY_NAME as PLY7_99_0_, this_.OS as OS99_0_, this_.IP as IP99_0_, this_.LIC_KEY as LIC10_99_0_, this_.USR_NAME as USR11_99_0_, this_.FIL_NAME as FIL12_99_0_, this_.FULL_PATH as FULL13_99_0_, this_.FIL_HASH_KEY as FIL14_99_0_, this_.FIL_ENC_KEY as FIL15_99_0_, this_.ENC_SUCESS as ENC16_99_0_, this_.PAT_NAME as PAT17_99_0_, this_.PAT_OCC_CNT as PAT18_99_0_, this_.PAT_CHK_CNT as PAT19_99_0_, this_.KEYWORD as KEYWORD99_0_, this_.KWD_OCC_CNT as KWD21_99_0_, this_.KWD_CHK_CNT as KWD22_99_0_, this_.USR_IDX as USR23_99_0_, this_.GRP_IDX as GRP24_99_0_, this_.LIC_KEY_IDX as LIC25_99_0_, this_.PLY_IDX as PLY26_99_0_, this_.FIL_OCC_PAT_KWD_LOG_LAT_IDX as FIL27_99_0_, this_.PAT_ID as PAT28_99_0_, this_.CHG_TYPE as CHG29_99_0_, this_.MAS_NAME as MAS30_99_0_, this_.AGT_EXIST as AGT31_99_0_, this_.CURR_DATE as CURR32_99_0_, this_.REG_DATE as REG33_99_0_ from AGT_FILE_OCC_PAT_KWD_LOG this_ where this_.FIL_OCC_PAT_KWD_LOG_LAT_IDX=? and this_.LIC_KEY_IDX=? and this_.USR_IDX=? and this_.FULL_PATH=? and this_.FIL_HASH_KEY=? and this_.PLY_IDX=? limit ? |
0.03 |
29
|
1,357
|
78
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
insert into CTL_TR_LOG (MOD1, MOD2, MOD3, TR_CODE, USR_IDX, SITE_IDX, ERR_CODE, IP, TR_TIME, TR_DB_TIME, DAY_OF_WEEK, RESULT, REG_DATE, CURR_DATE, DUE_DATE, REQ_LAW_DATA, RES_LAW_DATA) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.00 |
18
|
99
|
36
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
4
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select this_.PWD_IDX as PWD1_18_0_, this_.NAME as NAME18_0_, this_.BASED as BASED18_0_, this_.SPE_CHAR as SPE4_18_0_, this_.UPPERCASE as UPPERCASE18_0_, this_.LOWERCASE as LOWERCASE18_0_, this_.NUMBER as NUMBER18_0_, this_.SEL_LEN as SEL8_18_0_, this_.LENGTH as LENGTH18_0_, this_.TYPE as TYPE18_0_, this_.MONTH as MONTH18_0_, this_.DAY as DAY18_0_, this_.CNT_OF_WEEK as CNT13_18_0_, this_.WEEK as WEEK18_0_, this_.FAIL_CNT as FAIL15_18_0_, this_.FAIL_MIN as FAIL16_18_0_, this_.LOGOFF_MIN as LOGOFF17_18_0_, this_.MONTH1 as MONTH18_18_0_, this_.MONTH2 as MONTH19_18_0_, this_.MONTH3 as MONTH20_18_0_, this_.MONTH4 as MONTH21_18_0_, this_.MONTH5 as MONTH22_18_0_, this_.MONTH6 as MONTH23_18_0_, this_.MONTH7 as MONTH24_18_0_, this_.MONTH8 as MONTH25_18_0_, this_.MONTH9 as MONTH26_18_0_, this_.MONTH10 as MONTH27_18_0_, this_.MONTH11 as MONTH28_18_0_, this_.MONTH12 as MONTH29_18_0_, this_.IS_SHOW_DIALOG as IS30_18_0_, this_.IS_WIN_LOGIN as IS31_18_0_, this_.DESCRIPTION as DESCRIP32_18_0_, this_.ACTIVE as ACTIVE18_0_, this_.ACT_FAL_CAU_IDX as ACT34_18_0_, this_.PARENT_IDX as PARENT35_18_0_, this_.ACT_FAL_ID as ACT36_18_0_, this_.REG_DATE as REG37_18_0_ from AGT_PASSWORD this_ where this_.PWD_IDX=? and this_.ACTIVE=? limit ? |
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
select this_.FIL_ENC_DEC_IDX as FIL1_3051_0_, this_.ACTIVE as ACTIVE3051_0_, this_.IS_OUT as IS3_3051_0_, this_.RCV_MAIL as RCV4_3051_0_, this_.SND_MAIL as SND5_3051_0_, this_.MOB_NUM as MOB6_3051_0_, this_.SIGN_KEY1 as SIGN7_3051_0_, this_.FIL_NAME as FIL8_3051_0_, this_.FIL_HASH_KEY as FIL9_3051_0_, this_.SITE_IDX as SITE10_3051_0_, this_.FIL_OUT_ENC_DEC_IDX as FIL11_3051_0_, this_.FIL_IN_ENC_DEC_IDX as FIL12_3051_0_, this_.REG_DATE as REG13_3051_0_ from MGT_FILE_ENC_DEC this_ where this_.RCV_MAIL=? and this_.FIL_NAME=? and this_.FIL_HASH_KEY=? and this_.IS_OUT=? and this_.ACTIVE=? limit ? |
0.05 |
57
|
117
|
4
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select AgtFileEncryptLog.FIL_ENC_LOG_IDX as FIL1_80_0_, AgtFileEncryptLog.ID as ID80_0_, AgtFileEncryptLog.PCID as PCID80_0_, AgtFileEncryptLog.MAC as MAC80_0_, AgtFileEncryptLog.PCNAME as PCNAME80_0_, AgtFileEncryptLog.PAR_NAME as PAR6_80_0_, AgtFileEncryptLog.PLY_NAME as PLY7_80_0_, AgtFileEncryptLog.OS as OS80_0_, AgtFileEncryptLog.IP as IP80_0_, AgtFileEncryptLog.LIC_KEY as LIC10_80_0_, AgtFileEncryptLog.USR_NAME as USR11_80_0_, AgtFileEncryptLog.FIL_NAME as FIL12_80_0_, AgtFileEncryptLog.FULL_PATH as FULL13_80_0_, AgtFileEncryptLog.PRO_FULL_PATH as PRO14_80_0_, AgtFileEncryptLog.EVENT as EVENT80_0_, AgtFileEncryptLog.FIL_HASH_KEY as FIL16_80_0_, AgtFileEncryptLog.FIL_ENC_KEY as FIL17_80_0_, AgtFileEncryptLog.ENC_SUCESS as ENC18_80_0_, AgtFileEncryptLog.PAT_NAME as PAT19_80_0_, AgtFileEncryptLog.PAT_OCC_CNT as PAT20_80_0_, AgtFileEncryptLog.PAT_CHK_CNT as PAT21_80_0_, AgtFileEncryptLog.KEYWORD as KEYWORD80_0_, AgtFileEncryptLog.KWD_OCC_CNT as KWD23_80_0_, AgtFileEncryptLog.KWD_CHK_CNT as KWD24_80_0_, AgtFileEncryptLog.USR_IDX as USR25_80_0_, AgtFileEncryptLog.GRP_IDX as GRP26_80_0_, AgtFileEncryptLog.LIC_KEY_IDX as LIC27_80_0_, AgtFileEncryptLog.PLY_IDX as PLY28_80_0_, AgtFileEncryptLog.FIL_ENC_LOG_LAT_IDX as FIL29_80_0_, AgtFileEncryptLog.PAT_ID as PAT30_80_0_, AgtFileEncryptLog.CHG_TYPE as CHG31_80_0_, AgtFileEncryptLog.MAS_NAME as MAS32_80_0_, AgtFileEncryptLog.AGT_EXIST as AGT33_80_0_, AgtFileEncryptLog.ENC_DATE as ENC34_80_0_, AgtFileEncryptLog.CURR_DATE as CURR35_80_0_, AgtFileEncryptLog.REG_DATE as REG36_80_0_ from AGT_FILE_ENCRYPT_LOG AgtFileEncryptLog where FIL_ENC_LOG_LAT_IDX=? and LIC_KEY_IDX=? and USR_IDX=? order by REG_DATE desc LIMIT 1 |
0.01 |
1
|
25
|
4
|
|
0.00
|
|
|
|
|
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
select AgtKeywordPolicy.KWD_PLY_IDX as KWD1_9_0_, AgtKeywordPolicy.KWD_IDX as KWD2_9_0_, AgtKeywordPolicy.ACTIVE as ACTIVE9_0_, AgtKeywordPolicy.ACT_FAL_CAU_IDX as ACT4_9_0_, AgtKeywordPolicy.PARENT_IDX as PARENT5_9_0_, AgtKeywordPolicy.ACT_FAL_ID as ACT6_9_0_, AgtKeywordPolicy.GEN_PLY_IDX as GEN7_9_0_, AgtKeywordPolicy.ENC_PLY_IDX as ENC8_9_0_, AgtKeywordPolicy.PRO_PLY_IDX as PRO9_9_0_, AgtKeywordPolicy.COUNT as COUNT9_0_, AgtKeywordPolicy.REG_DATE as REG11_9_0_ from AGT_KEYWORD_POLICY AgtKeywordPolicy where ENC_PLY_IDX=? and ACTIVE=? |
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
29
|
53
|
33
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
16
|
147
|
43
|
|
0.00
|
|
|
|
|
0.01 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select MgtMetaAgtPattern.PAT_IDX as PAT1_3063_0_, MgtMetaAgtPattern.NAME as NAME3063_0_, MgtMetaAgtPattern.DIST_KEY as DIST3_3063_0_, MgtMetaAgtPattern.KEY_DATA as KEY4_3063_0_, MgtMetaAgtPattern.PATTERN as PATTERN3063_0_, MgtMetaAgtPattern.DESCRIPTION as DESCRIPT6_3063_0_, MgtMetaAgtPattern.DAT_TYPE as DAT7_3063_0_, MgtMetaAgtPattern.DAT_LEN as DAT8_3063_0_, MgtMetaAgtPattern.SEQUENCE as SEQUENCE3063_0_, MgtMetaAgtPattern.ACTIVE as ACTIVE3063_0_, MgtMetaAgtPattern.ACT_FAL_CAU_IDX as ACT11_3063_0_, MgtMetaAgtPattern.ACT_FAL_ID as ACT12_3063_0_, MgtMetaAgtPattern.COUNTRY as COUNTRY3063_0_, MgtMetaAgtPattern.REG_DATE as REG14_3063_0_ from MGT_META_AGT_PATTERN MgtMetaAgtPattern where ACTIVE=1 |
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
select agtprotect0_.PRO_FOL_IDX as PRO1_24_0_, agtprotect0_.NAME as NAME24_0_, agtprotect0_.PROTECT_FOLDER as PROTECT3_24_0_, agtprotect0_.DESCRIPTION as DESCRIPT4_24_0_, agtprotect0_.BASED as BASED24_0_, agtprotect0_.ACTIVE as ACTIVE24_0_, agtprotect0_.ACT_FAL_CAU_IDX as ACT7_24_0_, agtprotect0_.PARENT_IDX as PARENT8_24_0_, agtprotect0_.ACT_FAL_ID as ACT9_24_0_, agtprotect0_.PARENT as PARENT24_0_, agtprotect0_.P_ACTIVE as P11_24_0_, agtprotect0_.P_ACT_FAL_CAU_IDX as P12_24_0_, agtprotect0_.REG_DATE as REG13_24_0_ from AGT_PROTECT_FOLDER agtprotect0_ where agtprotect0_.PRO_FOL_IDX=? |
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
8
|
21
|
11
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
10
|
1
|
|
0.00
|
|
|
|
|
0.00 |
0
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
5
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
107
|
477
|
206
|
|
0.00
|
|
|
select AgtPatternPolicy.PAT_PLY_IDX as PAT1_29_0_, AgtPatternPolicy.GEN_PLY_IDX as GEN2_29_0_, AgtPatternPolicy.ENC_PLY_IDX as ENC3_29_0_, AgtPatternPolicy.PRO_PLY_IDX as PRO4_29_0_, AgtPatternPolicy.PAT_IDX as PAT5_29_0_, AgtPatternPolicy.ACTIVE as ACTIVE29_0_, AgtPatternPolicy.ACT_FAL_CAU_IDX as ACT7_29_0_, AgtPatternPolicy.PARENT_IDX as PARENT8_29_0_, AgtPatternPolicy.ACT_FAL_ID as ACT9_29_0_, AgtPatternPolicy.COUNT as COUNT29_0_, AgtPatternPolicy.REG_DATE as REG11_29_0_ from AGT_PATTERN_POLICY AgtPatternPolicy where ENC_PLY_IDX=? and ACTIVE=? |
0.00 |
6
|
208
|
30
|
|
0.00
|
|
|
select this_.PAT_IDX as PAT1_3063_0_, this_.NAME as NAME3063_0_, this_.DIST_KEY as DIST3_3063_0_, this_.KEY_DATA as KEY4_3063_0_, this_.PATTERN as PATTERN3063_0_, this_.DESCRIPTION as DESCRIPT6_3063_0_, this_.DAT_TYPE as DAT7_3063_0_, this_.DAT_LEN as DAT8_3063_0_, this_.SEQUENCE as SEQUENCE3063_0_, this_.ACTIVE as ACTIVE3063_0_, this_.ACT_FAL_CAU_IDX as ACT11_3063_0_, this_.ACT_FAL_ID as ACT12_3063_0_, this_.COUNTRY as COUNTRY3063_0_, this_.REG_DATE as REG14_3063_0_ from MGT_META_AGT_PATTERN this_ where this_.PAT_IDX=? and this_.ACTIVE=? limit ? |
0.01 |
0
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
select AgtFileEncryptLog.FIL_ENC_LOG_IDX as FIL1_88_0_, AgtFileEncryptLog.ID as ID88_0_, AgtFileEncryptLog.PCID as PCID88_0_, AgtFileEncryptLog.MAC as MAC88_0_, AgtFileEncryptLog.PCNAME as PCNAME88_0_, AgtFileEncryptLog.PAR_NAME as PAR6_88_0_, AgtFileEncryptLog.PLY_NAME as PLY7_88_0_, AgtFileEncryptLog.OS as OS88_0_, AgtFileEncryptLog.IP as IP88_0_, AgtFileEncryptLog.LIC_KEY as LIC10_88_0_, AgtFileEncryptLog.USR_NAME as USR11_88_0_, AgtFileEncryptLog.FIL_NAME as FIL12_88_0_, AgtFileEncryptLog.FULL_PATH as FULL13_88_0_, AgtFileEncryptLog.PRO_FULL_PATH as PRO14_88_0_, AgtFileEncryptLog.EVENT as EVENT88_0_, AgtFileEncryptLog.FIL_HASH_KEY as FIL16_88_0_, AgtFileEncryptLog.FIL_ENC_KEY as FIL17_88_0_, AgtFileEncryptLog.ENC_SUCESS as ENC18_88_0_, AgtFileEncryptLog.PAT_NAME as PAT19_88_0_, AgtFileEncryptLog.PAT_OCC_CNT as PAT20_88_0_, AgtFileEncryptLog.PAT_CHK_CNT as PAT21_88_0_, AgtFileEncryptLog.KEYWORD as KEYWORD88_0_, AgtFileEncryptLog.KWD_OCC_CNT as KWD23_88_0_, AgtFileEncryptLog.KWD_CHK_CNT as KWD24_88_0_, AgtFileEncryptLog.USR_IDX as USR25_88_0_, AgtFileEncryptLog.GRP_IDX as GRP26_88_0_, AgtFileEncryptLog.LIC_KEY_IDX as LIC27_88_0_, AgtFileEncryptLog.PLY_IDX as PLY28_88_0_, AgtFileEncryptLog.FIL_ENC_LOG_LAT_IDX as FIL29_88_0_, AgtFileEncryptLog.PAT_ID as PAT30_88_0_, AgtFileEncryptLog.CHG_TYPE as CHG31_88_0_, AgtFileEncryptLog.MAS_NAME as MAS32_88_0_, AgtFileEncryptLog.AGT_EXIST as AGT33_88_0_, AgtFileEncryptLog.ENC_DATE as ENC34_88_0_, AgtFileEncryptLog.CURR_DATE as CURR35_88_0_, AgtFileEncryptLog.REG_DATE as REG36_88_0_ from AGT_FILE_ENCRYPT_LOG AgtFileEncryptLog where FIL_ENC_LOG_LAT_IDX=? and FIL_ENC_LOG_IDX BETWEEN ? and ? and FULL_PATH=? and PLY_IDX=? |
0.00 |
32
|
445
|
86
|
|
0.00
|
|
|
|
|
0.00 |
1
|
12
|
2
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
19
|
56
|
32
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
select AgtFileEncryptLog.FIL_ENC_LOG_IDX as FIL1_88_0_, AgtFileEncryptLog.ID as ID88_0_, AgtFileEncryptLog.PCID as PCID88_0_, AgtFileEncryptLog.MAC as MAC88_0_, AgtFileEncryptLog.PCNAME as PCNAME88_0_, AgtFileEncryptLog.PAR_NAME as PAR6_88_0_, AgtFileEncryptLog.PLY_NAME as PLY7_88_0_, AgtFileEncryptLog.OS as OS88_0_, AgtFileEncryptLog.IP as IP88_0_, AgtFileEncryptLog.LIC_KEY as LIC10_88_0_, AgtFileEncryptLog.USR_NAME as USR11_88_0_, AgtFileEncryptLog.FIL_NAME as FIL12_88_0_, AgtFileEncryptLog.FULL_PATH as FULL13_88_0_, AgtFileEncryptLog.PRO_FULL_PATH as PRO14_88_0_, AgtFileEncryptLog.EVENT as EVENT88_0_, AgtFileEncryptLog.FIL_HASH_KEY as FIL16_88_0_, AgtFileEncryptLog.FIL_ENC_KEY as FIL17_88_0_, AgtFileEncryptLog.ENC_SUCESS as ENC18_88_0_, AgtFileEncryptLog.PAT_NAME as PAT19_88_0_, AgtFileEncryptLog.PAT_OCC_CNT as PAT20_88_0_, AgtFileEncryptLog.PAT_CHK_CNT as PAT21_88_0_, AgtFileEncryptLog.KEYWORD as KEYWORD88_0_, AgtFileEncryptLog.KWD_OCC_CNT as KWD23_88_0_, AgtFileEncryptLog.KWD_CHK_CNT as KWD24_88_0_, AgtFileEncryptLog.USR_IDX as USR25_88_0_, AgtFileEncryptLog.GRP_IDX as GRP26_88_0_, AgtFileEncryptLog.LIC_KEY_IDX as LIC27_88_0_, AgtFileEncryptLog.PLY_IDX as PLY28_88_0_, AgtFileEncryptLog.FIL_ENC_LOG_LAT_IDX as FIL29_88_0_, AgtFileEncryptLog.PAT_ID as PAT30_88_0_, AgtFileEncryptLog.CHG_TYPE as CHG31_88_0_, AgtFileEncryptLog.MAS_NAME as MAS32_88_0_, AgtFileEncryptLog.AGT_EXIST as AGT33_88_0_, AgtFileEncryptLog.ENC_DATE as ENC34_88_0_, AgtFileEncryptLog.CURR_DATE as CURR35_88_0_, AgtFileEncryptLog.REG_DATE as REG36_88_0_ from AGT_FILE_ENCRYPT_LOG AgtFileEncryptLog where FIL_ENC_LOG_LAT_IDX=? and LIC_KEY_IDX=? and USR_IDX=? order by REG_DATE desc LIMIT 1 |
0.02 |
2
|
78
|
11
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
20
|
60
|
25
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_FILE_ENCRYPT_DELETE_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, FULL_PATH, FILE_NAME, FIL_HASH_KEY, FIL_ENC_KEY, USR_IDX, GRP_IDX, LIC_KEY_IDX, PAT_NAME, PAT_OCC_CNT, PAT_CHK_CNT, KEYWORD, KWD_OCC_CNT, KWD_CHK_CNT, PLY_IDX, PAT_ID, CHG_TYPE, MAS_NAME, DEL_TYPE, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.00 |
5
|
81
|
17
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
25
|
60
|
28
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
6
|
51
|
15
|
|
0.00
|
|
|
select agtwhiteli0_.WHI_LIS_IDX as WHI1_20_0_, agtwhiteli0_.NAME as NAME20_0_, agtwhiteli0_.WHITE_LIST as WHITE3_20_0_, agtwhiteli0_.DESCRIPTION as DESCRIPT4_20_0_, agtwhiteli0_.BASED as BASED20_0_, agtwhiteli0_.ACTIVE as ACTIVE20_0_, agtwhiteli0_.ACT_FAL_CAU_IDX as ACT7_20_0_, agtwhiteli0_.PARENT_IDX as PARENT8_20_0_, agtwhiteli0_.ACT_FAL_ID as ACT9_20_0_, agtwhiteli0_.PARENT as PARENT20_0_, agtwhiteli0_.P_ACTIVE as P11_20_0_, agtwhiteli0_.P_ACT_FAL_CAU_IDX as P12_20_0_, agtwhiteli0_.REG_DATE as REG13_20_0_ from AGT_WHITE_LIST agtwhiteli0_ where agtwhiteli0_.WHI_LIS_IDX=? |
0.01 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select AgtPublicFolderMessage.PUB_FOL_MSG_IDX as PUB1_66_0_, AgtPublicFolderMessage.ACTIVE as ACTIVE66_0_, AgtPublicFolderMessage.ACT_FAL_CAU_IDX as ACT3_66_0_, AgtPublicFolderMessage.PARENT_IDX as PARENT4_66_0_, AgtPublicFolderMessage.ACT_FAL_ID as ACT5_66_0_, AgtPublicFolderMessage.RCV_USR_IDX as RCV6_66_0_, AgtPublicFolderMessage.SND_USR_IDX as SND7_66_0_, AgtPublicFolderMessage.LIC_KEY_IDX as LIC8_66_0_, AgtPublicFolderMessage.NAME as NAME66_0_, AgtPublicFolderMessage.REG_DATE as REG10_66_0_, AgtPublicFolderMessage.SND_DATE as SND11_66_0_ from AGT_PUBLIC_FOLDER_MESSAGE AgtPublicFolderMessage where RCV_USR_IDX=? and LIC_KEY_IDX=? and ACTIVE=? |
0.00 |
25
|
112
|
41
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_ENC_FIL_TRAN_LOG_DAILY (USR_IDX, LIC_KEY_IDX, GRP_IDX, TRN_COUNT, PRN_COUNT, UPDATE_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?) |
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
176
|
176
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
select AgtKeywordPolicy.KWD_PLY_IDX as KWD1_17_0_, AgtKeywordPolicy.KWD_IDX as KWD2_17_0_, AgtKeywordPolicy.ACTIVE as ACTIVE17_0_, AgtKeywordPolicy.ACT_FAL_CAU_IDX as ACT4_17_0_, AgtKeywordPolicy.PARENT_IDX as PARENT5_17_0_, AgtKeywordPolicy.ACT_FAL_ID as ACT6_17_0_, AgtKeywordPolicy.GEN_PLY_IDX as GEN7_17_0_, AgtKeywordPolicy.ENC_PLY_IDX as ENC8_17_0_, AgtKeywordPolicy.PRO_PLY_IDX as PRO9_17_0_, AgtKeywordPolicy.COUNT as COUNT17_0_, AgtKeywordPolicy.REG_DATE as REG11_17_0_ from AGT_KEYWORD_POLICY AgtKeywordPolicy where ENC_PLY_IDX=? and ACTIVE=? |
0.00 |
0
|
13
|
2
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
12
|
12
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
select AgtPatternPolicy.PAT_PLY_IDX as PAT1_21_0_, AgtPatternPolicy.GEN_PLY_IDX as GEN2_21_0_, AgtPatternPolicy.ENC_PLY_IDX as ENC3_21_0_, AgtPatternPolicy.PRO_PLY_IDX as PRO4_21_0_, AgtPatternPolicy.PAT_IDX as PAT5_21_0_, AgtPatternPolicy.ACTIVE as ACTIVE21_0_, AgtPatternPolicy.ACT_FAL_CAU_IDX as ACT7_21_0_, AgtPatternPolicy.PARENT_IDX as PARENT8_21_0_, AgtPatternPolicy.ACT_FAL_ID as ACT9_21_0_, AgtPatternPolicy.COUNT as COUNT21_0_, AgtPatternPolicy.REG_DATE as REG11_21_0_ from AGT_PATTERN_POLICY AgtPatternPolicy where ENC_PLY_IDX=? and ACTIVE=? |
0.00 |
12
|
195
|
46
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
select AgtMedia.MDA_IDX as MDA1_33_0_, AgtMedia.ACTIVE as ACTIVE33_0_, AgtMedia.ACT_FAL_CAU_IDX as ACT3_33_0_, AgtMedia.PARENT_IDX as PARENT4_33_0_, AgtMedia.ACT_FAL_ID as ACT5_33_0_, AgtMedia.TYPE as TYPE33_0_, AgtMedia.MDA_PLY_IDX as MDA7_33_0_, AgtMedia.SMA_PHO_PRO_IDX as SMA8_33_0_, AgtMedia.COMPANY_ID as COMPANY9_33_0_, AgtMedia.DEVICE_NAME as DEVICE10_33_0_, AgtMedia.WHI_NAME as WHI11_33_0_, AgtMedia.BLA_NAME as BLA12_33_0_, AgtMedia.REG_DATE as REG13_33_0_ from AGT_MEDIA AgtMedia where MDA_PLY_IDX=? |
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
5
|
5
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
/* BATCH */ update AGT_FILE_ENCRYPT_DELETE_LOG set ID=?, PCID=?, MAC=?, PCNAME=?, PAR_NAME=?, PLY_NAME=?, OS=?, IP=?, LIC_KEY=?, USR_NAME=?, FULL_PATH=?, FILE_NAME=?, FIL_HASH_KEY=?, FIL_ENC_KEY=?, USR_IDX=?, GRP_IDX=?, LIC_KEY_IDX=?, PAT_NAME=?, PAT_OCC_CNT=?, PAT_CHK_CNT=?, KEYWORD=?, KWD_OCC_CNT=?, KWD_CHK_CNT=?, PLY_IDX=?, PAT_ID=?, CHG_TYPE=?, MAS_NAME=?, DEL_TYPE=?, CURR_DATE=?, REG_DATE=? where FIL_ENC_DEL_LOG_IDX=? |
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_FILE_ENCRYPT_LOG (ID, PCID, MAC, PCNAME, PAR_NAME, PLY_NAME, OS, IP, LIC_KEY, USR_NAME, FIL_NAME, FULL_PATH, PRO_FULL_PATH, EVENT, FIL_HASH_KEY, FIL_ENC_KEY, ENC_SUCESS, PAT_NAME, PAT_OCC_CNT, PAT_CHK_CNT, KEYWORD, KWD_OCC_CNT, KWD_CHK_CNT, USR_IDX, GRP_IDX, LIC_KEY_IDX, PLY_IDX, FIL_ENC_LOG_LAT_IDX, PAT_ID, CHG_TYPE, MAS_NAME, AGT_EXIST, ENC_DATE, CURR_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.00 |
1
|
20
|
3
|
|
0.00
|
|
|
|
|
0.00 |
0
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
/* BATCH */ update AGT_FILE_ENCRYPT_LOG set ID=?, PCID=?, MAC=?, PCNAME=?, PAR_NAME=?, PLY_NAME=?, OS=?, IP=?, LIC_KEY=?, USR_NAME=?, FIL_NAME=?, FULL_PATH=?, PRO_FULL_PATH=?, EVENT=?, FIL_HASH_KEY=?, FIL_ENC_KEY=?, ENC_SUCESS=?, PAT_NAME=?, PAT_OCC_CNT=?, PAT_CHK_CNT=?, KEYWORD=?, KWD_OCC_CNT=?, KWD_CHK_CNT=?, USR_IDX=?, GRP_IDX=?, LIC_KEY_IDX=?, PLY_IDX=?, FIL_ENC_LOG_LAT_IDX=?, PAT_ID=?, CHG_TYPE=?, MAS_NAME=?, AGT_EXIST=?, ENC_DATE=?, CURR_DATE=?, REG_DATE=? where FIL_ENC_LOG_IDX=? |
0.00 |
1
|
13
|
2
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
23
|
57
|
28
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
42
|
145
|
69
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
26
|
167
|
42
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
16
|
16
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
55
|
91
|
41
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
37
|
40
|
3
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
29
|
2
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
select AgtFileEncryptLog.FIL_ENC_LOG_IDX as FIL1_80_0_, AgtFileEncryptLog.ID as ID80_0_, AgtFileEncryptLog.PCID as PCID80_0_, AgtFileEncryptLog.MAC as MAC80_0_, AgtFileEncryptLog.PCNAME as PCNAME80_0_, AgtFileEncryptLog.PAR_NAME as PAR6_80_0_, AgtFileEncryptLog.PLY_NAME as PLY7_80_0_, AgtFileEncryptLog.OS as OS80_0_, AgtFileEncryptLog.IP as IP80_0_, AgtFileEncryptLog.LIC_KEY as LIC10_80_0_, AgtFileEncryptLog.USR_NAME as USR11_80_0_, AgtFileEncryptLog.FIL_NAME as FIL12_80_0_, AgtFileEncryptLog.FULL_PATH as FULL13_80_0_, AgtFileEncryptLog.PRO_FULL_PATH as PRO14_80_0_, AgtFileEncryptLog.EVENT as EVENT80_0_, AgtFileEncryptLog.FIL_HASH_KEY as FIL16_80_0_, AgtFileEncryptLog.FIL_ENC_KEY as FIL17_80_0_, AgtFileEncryptLog.ENC_SUCESS as ENC18_80_0_, AgtFileEncryptLog.PAT_NAME as PAT19_80_0_, AgtFileEncryptLog.PAT_OCC_CNT as PAT20_80_0_, AgtFileEncryptLog.PAT_CHK_CNT as PAT21_80_0_, AgtFileEncryptLog.KEYWORD as KEYWORD80_0_, AgtFileEncryptLog.KWD_OCC_CNT as KWD23_80_0_, AgtFileEncryptLog.KWD_CHK_CNT as KWD24_80_0_, AgtFileEncryptLog.USR_IDX as USR25_80_0_, AgtFileEncryptLog.GRP_IDX as GRP26_80_0_, AgtFileEncryptLog.LIC_KEY_IDX as LIC27_80_0_, AgtFileEncryptLog.PLY_IDX as PLY28_80_0_, AgtFileEncryptLog.FIL_ENC_LOG_LAT_IDX as FIL29_80_0_, AgtFileEncryptLog.PAT_ID as PAT30_80_0_, AgtFileEncryptLog.CHG_TYPE as CHG31_80_0_, AgtFileEncryptLog.MAS_NAME as MAS32_80_0_, AgtFileEncryptLog.AGT_EXIST as AGT33_80_0_, AgtFileEncryptLog.ENC_DATE as ENC34_80_0_, AgtFileEncryptLog.CURR_DATE as CURR35_80_0_, AgtFileEncryptLog.REG_DATE as REG36_80_0_ from AGT_FILE_ENCRYPT_LOG AgtFileEncryptLog where FIL_ENC_LOG_LAT_IDX=? and FIL_ENC_LOG_IDX BETWEEN ? and ? and FULL_PATH=? and PLY_IDX=? |
0.00 |
4
|
20
|
5
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
178
|
178
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
14
|
14
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
/* BATCH */ update AGT_MESSAGE set ACTIVE=?, ACT_FAL_CAU_IDX=?, PARENT_IDX=?, ACT_FAL_ID=?, RCV_USR_IDX=?, SND_USR_IDX=?, LIC_KEY_IDX=?, SND_GRP_IDX=?, SND_LIC_KEY_IDX=?, SND_LEVEL=?, SND_NAME=?, SND_MAIL=?, AGENT_MEMBER=?, RCV_NAME=?, RCV_MAIL=?, PCID=?, IP=?, PCNAME=?, GRADE=?, TARGET=?, SOURCE=?, TITLE=?, MESSAGE=?, ENC_FILE_REG_DATE=?, FILE_NAME=?, FILE_HASH_KEY=?, SIGN=?, SIGN_DATE=?, DEC_USR_NAME=?, REG_DATE=?, SND_DATE=? where MSG_IDX=? |
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
20
|
44
|
21
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
3
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
14
|
15
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
8
|
16
|
11
|
|
0.00
|
|
|
|
|
0.00 |
14
|
15
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
select agtextenti0_.EXT_IDX as EXT1_18_0_, agtextenti0_.NAME as NAME18_0_, agtextenti0_.EXTENTION as EXTENTION18_0_, agtextenti0_.DESCRIPTION as DESCRIPT4_18_0_, agtextenti0_.BASED as BASED18_0_, agtextenti0_.ACTIVE as ACTIVE18_0_, agtextenti0_.ACT_FAL_CAU_IDX as ACT7_18_0_, agtextenti0_.PARENT_IDX as PARENT8_18_0_, agtextenti0_.ACT_FAL_ID as ACT9_18_0_, agtextenti0_.PARENT as PARENT18_0_, agtextenti0_.P_ACTIVE as P11_18_0_, agtextenti0_.P_ACT_FAL_CAU_IDX as P12_18_0_, agtextenti0_.REG_DATE as REG13_18_0_ from AGT_EXTENTION agtextenti0_ where agtextenti0_.EXT_IDX=? |
0.00 |
0
|
3
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
11
|
42
|
20
|
|
0.00
|
|
|
|
|
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
18
|
18
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
select AgtMedia.MDA_IDX as MDA1_41_0_, AgtMedia.ACTIVE as ACTIVE41_0_, AgtMedia.ACT_FAL_CAU_IDX as ACT3_41_0_, AgtMedia.PARENT_IDX as PARENT4_41_0_, AgtMedia.ACT_FAL_ID as ACT5_41_0_, AgtMedia.TYPE as TYPE41_0_, AgtMedia.MDA_PLY_IDX as MDA7_41_0_, AgtMedia.SMA_PHO_PRO_IDX as SMA8_41_0_, AgtMedia.COMPANY_ID as COMPANY9_41_0_, AgtMedia.DEVICE_NAME as DEVICE10_41_0_, AgtMedia.WHI_NAME as WHI11_41_0_, AgtMedia.BLA_NAME as BLA12_41_0_, AgtMedia.REG_DATE as REG13_41_0_ from AGT_MEDIA AgtMedia where MDA_PLY_IDX=? |
0.00 |
0
|
2
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
13
|
26
|
17
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
14
|
15
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
46
|
138
|
79
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
15
|
16
|
1
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
156
|
441
|
246
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
Details
Return
Main page
Update
Online help
Desktop
Day
Week
Month
Year