[ DB ] CONNECT:[ UseTime:0.000665s ] mysql:host=localhost;port=333306;dbname=nhzhaopin_2018_db;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_job` [ RunTime:0.000750s ]
[ SQL ] SELECT * FROM `tp_job` LEFT JOIN (select Name j_name,ID as jid from tp_jobclass) e ON `tp_job`.`Cid`=`e`.`jid` LEFT JOIN (select ID as cid,Logo,Name as c_name,Uid as c_uid,Industry,area from tp_company) a ON `tp_job`.`Uid`=`a`.`c_uid` LEFT JOIN (select Name industry_name,ID as iid from tp_industry) b ON `a`.`Industry`=`b`.`iid` LEFT JOIN (select Name area_name,ID as aid from tp_area) c ON `a`.`area`=`c`.`aid` LEFT JOIN (select Name j_area_name,ID as j_id from tp_area) f ON `tp_job`.`Wokesite`=`f`.`j_id` WHERE ( tp_job.ID=106389 ) LIMIT 1 [ RunTime:0.009782s ]
[ SQL ] SELECT `tp_job`.*,e.Name as j_name,e.ID as jid FROM `tp_job` LEFT JOIN `tp_jobclass` `e` ON `tp_job`.`Cid`=`e`.`ID` WHERE ( tp_job.Status=1 and tp_job.Uid=39421 ) [ RunTime:0.026041s ]
[ SQL ] SHOW COLUMNS FROM `tp_company` [ RunTime:0.000816s ]
[ SQL ] SELECT * FROM `tp_company` LEFT JOIN (select Name industry_name,ID as iid from tp_industry) a ON `tp_company`.`Industry`=`a`.`iid` LEFT JOIN (select Name area_name,ID as aid from tp_area) b ON `tp_company`.`area`=`b`.`aid` LEFT JOIN (select Mpid,ID mid from tp_member) c ON `tp_company`.`Uid`=`c`.`mid` WHERE ( tp_company.Uid = 39421 ) LIMIT 1 [ RunTime:0.059394s ]
[ SQL ] UPDATE `tp_job` SET `Click`=`Click`+1 WHERE ( ID = 106389 ) [ RunTime:0.003207s ]