/json.cmd POST |
|
57
|
572
|
66
|
11
|
0.00
|
21
|
42
|
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.60 |
0
|
8
|
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.34 |
0
|
15
|
1
|
|
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.34 |
2
|
8
|
1
|
|
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.74 |
27
|
47
|
6
|
|
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.29 |
2
|
143
|
10
|
|
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.34 |
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.81 |
0
|
21
|
1
|
|
0.00
|
|
|
|
0.72 |
1
|
103
|
7
|
|
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.71 |
1
|
50
|
4
|
|
0.00
|
|
|
|
0.72 |
0
|
23
|
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.72 |
0
|
15
|
1
|
|
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.53 |
3
|
155
|
13
|
|
0.00
|
|
|
|
0.34 |
0
|
3
|
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
|
12
|
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.71 |
1
|
76
|
5
|
|
0.00
|
|
|
|
0.37 |
0
|
27
|
3
|
|
0.00
|
|
|
|
9.07 |
0
|
5
|
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.34 |
0
|
4
|
0
|
|
0.00
|
|
|
|
0.34 |
0
|
2
|
0
|
|
0.00
|
|
|
|
0.02 |
4
|
21
|
9
|
|
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.04 |
4
|
40
|
11
|
|
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.01 |
0
|
0
|
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.09 |
3
|
41
|
8
|
|
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.04 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.02 |
5
|
29
|
11
|
|
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
|
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.10 |
1
|
29
|
5
|
|
0.00
|
|
|
|
0.26 |
1
|
36
|
4
|
|
0.00
|
|
|
|
0.04 |
1
|
9
|
2
|
|
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.03 |
12
|
79
|
27
|
|
0.00
|
|
|
|
0.03 |
3
|
18
|
6
|
|
0.00
|
|
|
|
0.24 |
0
|
16
|
2
|
|
0.00
|
|
|
|
0.03 |
4
|
23
|
8
|
|
0.00
|
|
|
|
0.03 |
4
|
28
|
10
|
|
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.03 |
3
|
22
|
8
|
|
0.00
|
|
|
|
0.03 |
5
|
36
|
13
|
|
0.00
|
|
|
|
0.03 |
5
|
34
|
12
|
|
0.00
|
|
|
|
0.03 |
2
|
15
|
5
|
|
0.00
|
|
|
|
0.03 |
3
|
20
|
7
|
|
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 |
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.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
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.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
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.00 |
186
|
186
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
9
|
27
|
15
|
|
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.09 |
15
|
70
|
19
|
|
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.03 |
6
|
9
|
2
|
|
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 |
23
|
248
|
74
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
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
|
1
|
0
|
|
0.00
|
|
|
|
0.04 |
3
|
26
|
7
|
|
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.04 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
0
|
|
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.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.01 |
35
|
69
|
47
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|
|
0.01 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.07 |
0
|
1
|
0
|
|
0.00
|
|
|
|
0.00 |
198
|
198
|
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.00 |
0
|
0
|
0
|
|
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.00 |
0
|
0
|
0
|
|
0.00
|
|
|
|
0.00 |
1
|
1
|
0
|
|
0.00
|
|
|