/json.cmd POST |
|
47
|
137
|
48
|
13
|
0.00
|
20
|
31
|
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.33 |
2
|
7
|
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.67 |
27
|
33
|
5
|
|
0.00
|
|
|
|
0.28 |
0
|
2
|
0
|
|
0.00
|
|
|
|
0.14 |
0
|
3
|
0
|
|
0.00
|
|
|
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.16 |
1
|
10
|
2
|
|
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.33 |
0
|
6
|
0
|
|
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.80 |
0
|
3
|
0
|
|
0.00
|
|
|
|
0.73 |
0
|
1
|
0
|
|
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.73 |
0
|
2
|
0
|
|
0.00
|
|
|
|
0.73 |
0
|
2
|
0
|
|
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.73 |
0
|
19
|
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.46 |
1
|
9
|
1
|
|
0.00
|
|
|
|
0.33 |
0
|
1
|
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.37 |
0
|
7
|
1
|
|
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.73 |
0
|
5
|
0
|
|
0.00
|
|
|
|
0.37 |
0
|
2
|
0
|
|
0.00
|
|
|
|
9.56 |
0
|
0
|
0
|
|
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.48 |
0
|
3
|
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.33 |
0
|
2
|
0
|
|
0.00
|
|
|
|
0.33 |
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.07 |
0
|
2
|
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 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
0
|
0
|
|
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
|
|
|
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 ? |
0.23 |
0
|
2
|
0
|
|
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.06 |
0
|
1
|
0
|
|
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.03 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.02 |
1
|
2
|
0
|
|
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.05 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.09 |
1
|
1
|
0
|
|
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.05 |
15
|
34
|
23
|
|
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.02 |
7
|
8
|
0
|
|
0.00
|
|
|
|
0.01 |
2
|
4
|
1
|
|
0.00
|
|
|
|
0.12 |
1
|
2
|
3
|
|
0.00
|
|
|
|
0.01 |
2
|
6
|
2
|
|
0.00
|
|
|
|
0.02 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
17
|
49
|
27
|
|
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.01 |
3
|
8
|
4
|
|
0.00
|
|
|
|
0.01 |
4
|
11
|
6
|
|
0.00
|
|
|
|
0.01 |
9
|
27
|
15
|
|
0.00
|
|
|
|
0.01 |
3
|
9
|
5
|
|
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 |
3
|
8
|
4
|
|
0.00
|
|
|
|
0.01 |
4
|
12
|
6
|
|
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 |
5
|
16
|
9
|
|
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
|
|
|
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.02 |
7
|
26
|
12
|
|
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.02 |
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.01 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.02 |
1
|
2
|
0
|
|
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.02 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
2
|
0
|
|
0.00
|
|
|
|
0.00 |
2
|
2
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
5
|
9
|
5
|
|
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 |
2
|
2
|
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.02 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|