/json.cmd POST |
|
59
|
298
|
108
|
18
|
0.00
|
15
|
33
|
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.05 |
0
|
6
|
1
|
|
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.05 |
0
|
1
|
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 |
1.17 |
1
|
8
|
10
|
|
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.65 |
0
|
26
|
5
|
|
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.45 |
1
|
102
|
8
|
|
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.40 |
0
|
2
|
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.49 |
1
|
66
|
9
|
|
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.18 |
1
|
17
|
2
|
|
0.00
|
|
|
|
0.05 |
0
|
1
|
0
|
|
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.05 |
7
|
52
|
16
|
|
0.00
|
|
|
|
0.00 |
1
|
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.23 |
2
|
3
|
0
|
|
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.50 |
28
|
34
|
3
|
|
0.00
|
|
|
|
0.49 |
1
|
35
|
12
|
|
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.49 |
2
|
67
|
13
|
|
0.00
|
|
|
|
0.49 |
1
|
26
|
5
|
|
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.49 |
1
|
22
|
5
|
|
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.25 |
1
|
36
|
4
|
|
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.49 |
1
|
31
|
5
|
|
0.00
|
|
|
|
0.25 |
2
|
171
|
18
|
|
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.23 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.23 |
0
|
2
|
0
|
|
0.00
|
|
|
|
6.27 |
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.23 |
0
|
24
|
2
|
|
0.00
|
|
|
|
0.23 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.23 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.12 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.02 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.02 |
2
|
5
|
3
|
|
0.00
|
|
|
|
0.02 |
11
|
33
|
26
|
|
0.00
|
|
|
|
0.02 |
1
|
4
|
3
|
|
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.02 |
2
|
3
|
2
|
|
0.00
|
|
|
|
0.02 |
1
|
2
|
1
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.02 |
9
|
26
|
21
|
|
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.01 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.02 |
4
|
11
|
9
|
|
0.00
|
|
|
|
0.07 |
0
|
1
|
0
|
|
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.06 |
0
|
1
|
0
|
|
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.11 |
8
|
75
|
32
|
|
0.00
|
|
|
|
0.05 |
1
|
9
|
4
|
|
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.07 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.02 |
22
|
134
|
54
|
|
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.01 |
41
|
82
|
57
|
|
0.00
|
|
|
|
0.01 |
3
|
4
|
3
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
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.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
8
|
17
|
12
|
|
0.00
|
|
|
|
0.02 |
7
|
25
|
17
|
|
0.00
|
|
|
|
0.01 |
27
|
54
|
38
|
|
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 |
125
|
152
|
37
|
|
0.00
|
|
|
|
0.01 |
10
|
20
|
14
|
|
0.00
|
|
|
|
0.02 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
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.03 |
37
|
93
|
88
|
|
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.01 |
7
|
9
|
3
|
|
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.06 |
2
|
19
|
8
|
|
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
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.02 |
3
|
25
|
8
|
|
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.06 |
9
|
20
|
21
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
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.05 |
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.02 |
5
|
18
|
8
|
|
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
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
44
|
44
|
0
|
|
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) |
0.01 |
1
|
2
|
1
|
|
0.00
|
|
|
|
0.01 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.03 |
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 |
6
|
6
|
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
|
|
|
select agtprotect0_.PRO_FOL_IDX as PRO1_16_0_, agtprotect0_.NAME as NAME16_0_, agtprotect0_.PROTECT_FOLDER as PROTECT3_16_0_, agtprotect0_.DESCRIPTION as DESCRIPT4_16_0_, agtprotect0_.BASED as BASED16_0_, agtprotect0_.ACTIVE as ACTIVE16_0_, agtprotect0_.ACT_FAL_CAU_IDX as ACT7_16_0_, agtprotect0_.PARENT_IDX as PARENT8_16_0_, agtprotect0_.ACT_FAL_ID as ACT9_16_0_, agtprotect0_.PARENT as PARENT16_0_, agtprotect0_.P_ACTIVE as P11_16_0_, agtprotect0_.P_ACT_FAL_CAU_IDX as P12_16_0_, agtprotect0_.REG_DATE as REG13_16_0_ from AGT_PROTECT_FOLDER agtprotect0_ where agtprotect0_.PRO_FOL_IDX=? |
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
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.01 |
1
|
1
|
0
|
|
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 |
8
|
28
|
13
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
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.01 |
1
|
1
|
0
|
|
0.00
|
|
|
insert into AGT_FIREWALL_LOG_DAILY (USR_IDX, LIC_KEY_IDX, GRP_IDX, COUNT, UPDATE_DATE, REG_DATE) values (?, ?, ?, ?, ?, ?) |
0.01 |
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.01 |
14
|
15
|
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 |
0
|
0
|
0
|
|
0.00
|
|
|