150629 16:49:56 1077314 Connect mGuest@125.141.205.118 as anonymous on mrs
|
1077314 Query /* mysql-connector-java-5.1.31 ( Revision: alexander.soklakov@oracle.com-
|
|
20140520065950-groqzzbvxprqdmnz ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name =
|
|
'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name =
|
|
'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR
|
|
Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR
|
|
Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name
|
|
= 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR
|
|
Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR
|
|
Variable_name = 'query_cache_size' OR Variable_name = 'init_connect'
|
1077314 Query /* mysql-connector-java-5.1.31 ( Revision: alexander.soklakov@oracle.com-
|
|
20140520065950-groqzzbvxprqdmnz ) */SELECT @@session.auto_increment_increment
|
1077314 Query SET character_set_results = NULL
|
1077314 Query SET autocommit=1
|
1077314 Query SET sql_mode='STRICT_TRANS_TABLES'
|
1077314 Query select 1
|
1077314 Query SET autocommit=0
|
1077314 Query SELECT USER()
|
1077314 Query SELECT
|
A.applicant_SN
|
,A.jobnotice_SN
|
,A.name
|
,A.password
|
,A.submit_yn
|
FROM Applicant A
|
INNER JOIN ApplicantContact AS AC ON AC.Applicant_SN = A.Applicant_SN AND
|
|
AC.Contact_Type_Code= '04'
|
WHERE
|
A.Jobnotice_SN = 53
|
AND A.name = '源€뚯쁺'
|
AND A.birthday = '1988-11-02'
|
AND A.gender_flag = 0
|
AND AC.contents = '3SFX0qq3d0yAg2cTQlUkcqMqqXafsjWoovW6UeYVP0g='
|
|
LIMIT 1
|
1077314 Query SELECT
|
A.applicant_SN
|
,A.jobnotice_SN
|
,A.name
|
,A.password
|
,A.submit_yn
|
FROM Applicant A
|
INNER JOIN ApplicantContact AS AC ON AC.Applicant_SN = A.Applicant_SN AND
|
|
AC.Contact_Type_Code= '04'
|
WHERE
|
A.Jobnotice_SN = 53
|
AND A.name = '源€뚯쁺'
|
AND A.birthday = '1988-11-02'
|
AND A.gender_flag = 0
|
AND AC.contents = '3SFX0qq3d0yAg2cTQlUkcqMqqXafsjWoovW6UeYVP0g='
|
|
AND A.password = 'v2lntSczZRg61jUQ4sVtFA=='
|
|
LIMIT 1
|
1077314 Query select
|
amp.contents
|
from (
|
select
|
jsa.jobnotice_sn
|
,jsa.step_sn
|
,jsa.applicant_sn
|
,jsa.recruitfield_sn
|
,jsa.applicant_state_code
|
|
from
|
applicant as a
|
inner join announcement as am
|
on am.jobnotice_sn = a.jobnotice_sn
|
and now() between am.post_start_date and am.post_end_date
|
inner join jobnoticeStepApplicant as jsa
|
on jsa.jobnotice_sn = am.jobnotice_sn
|
and jsa.step_sn = am.step_sn
|
and jsa.applicant_sn = a.applicant_sn
|
where
|
a.applicant_sn = 24593
|
order by jsa.applicant_state_code desc
|
limit 1
|
) a
|
inner join announcementPost as amp
|
on amp.jobnotice_sn = a.jobnotice_sn
|
and amp.step_sn = a.step_sn
|
and amp.applicant_state_code = a.applicant_state_code
|
1077314 Query commit
|
1077314 Query SET autocommit=1
|
1077313 Init DB mrs
|
1077313 Query set @groupSn = -1
|
1077313 Query update MailLog AS M^M
|
left outer join (^M
|
select^M
|
M.log_sn^M
|
,M.group_sn^M
|
,a.applicant_view_no^M
|
,a.name^M
|
,fn_recruitfieldname(M.recruitfield_sn) AS recruitfield_name^M
|
,concat(fn_filepath(apf.file_Uid) , apf.file_uid) as picture_path^M
|
,CONVERT(DATE_FORMAT(a.birthday,GET_FORMAT(DATE,'ISO')) ,CHAR(10)) as birthday^M
|
,(SELECT group_name FROM interviewstepgroup AS ISG^M
|
WHERE ISG.jobnotice_sn = ISA.jobnotice_sn^M
|
AND ISG.step_sn = ISA.step_sn^M
|
AND ISG.group_sn = ISA.group_sn ) AS group_name^M
|
, (SELECT place_name FROM interviewstepplace AS ISP^M
|
select
|
jsa.jobnotice_sn
|
,jsa.step_sn
|
,jsa.applicant_sn
|
,jsa.recruitfield_sn
|
,jsa.applicant_state_code
|
|
from
|
applicant as a
|
inner join announcement as am
|
on am.jobnotice_sn = a.jobnotice_sn
|
and now() between am.post_start_date and am.post_end_date
|
inner join jobnoticeStepApplicant as jsa
|
on jsa.jobnotice_sn = am.jobnotice_sn
|
and jsa.step_sn = am.step_sn
|
and jsa.applicant_sn = a.applicant_sn
|
where
|
a.applicant_sn = 24593
|
order by jsa.applicant_state_code desc
|
limit 1
|
) a
|
inner join announcementPost as amp
|
on amp.jobnotice_sn = a.jobnotice_sn
|
and amp.step_sn = a.step_sn
|
and amp.applicant_state_code = a.applicant_state_code
|
1077314 Query commit
|
1077314 Query SET autocommit=1
|
1077313 Init DB mrs
|
1077313 Query set @groupSn = -1
|
1077313 Query update MailLog AS M^M
|
left outer join (^M
|
select^M
|
M.log_sn^M
|
,M.group_sn^M
|
,a.applicant_view_no^M
|
,a.name^M
|
,fn_recruitfieldname(M.recruitfield_sn) AS recruitfield_name^M
|
,concat(fn_filepath(apf.file_Uid) , apf.file_uid) as picture_path^M
|
,CONVERT(DATE_FORMAT(a.birthday,GET_FORMAT(DATE,'ISO')) ,CHAR(10)) as birthday^M
|
,(SELECT group_name FROM interviewstepgroup AS ISG^M
|
WHERE ISG.jobnotice_sn = ISA.jobnotice_sn^M
|
AND ISG.step_sn = ISA.step_sn^M
|
AND ISG.group_sn = ISA.group_sn ) AS group_name^M
|
, (SELECT place_name FROM interviewstepplace AS ISP^M
|
WHERE ISP.jobnotice_sn = ISA.jobnotice_sn^M
|
AND ISP.step_sn = ISA.step_sn^M
|
AND ISP.place_sn = ISA.place_sn ) AS place_name^M
|
, REPLACE( CONVERT(FORMAT(isa.interview_fee,4),CHAR),'.0000','') as interview_fee^M
|
,concat(CONVERT(DATE_FORMAT(isa.start_date,GET_FORMAT(DATE,'ISO')) ,CHAR(10))^M
|
,'('^M
|
, DAYNAME(isa.start_date) ,') '^M
|
, CONVERT(DATE_FORMAT(isa.start_date, '%H:%i'),CHAR(5))^M
|
) as interview_date^M
|
,c.company_name^M
|
,j.jobnotice_name^M
|
from^M
|
maillog AS M^M
|
LEFT OUTER JOIN mrs.vw_company AS c ON c.Company_SN = M.company_sn^M
|
LEFT OUTER JOIN jobnotice as j on M.jobnotice_sn = j.Jobnotice_SN^M
|
LEFT outer join mailgroup AS MG ON MG.Group_SN = M.group_sn^M
|
LEFT outer JOIN applicant AS A ON A.Applicant_SN = M.applicant_sn^M
|