[ DB ] CONNECT:[ UseTime:0.000632s ] mysql:host=localhost;port=333306;dbname=nhzhaopin_2018_db;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_job` [ RunTime:0.000834s ]
[ 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=112803 ) LIMIT 1 [ RunTime:0.008352s ]
[ 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=950 ) [ RunTime:0.025020s ]
[ SQL ] SHOW COLUMNS FROM `tp_company` [ RunTime:0.000843s ]
[ 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 = 950 ) LIMIT 1 [ RunTime:0.056378s ]
[ SQL ] UPDATE `tp_job` SET `Click`=`Click`+1 WHERE ( ID = 112803 ) [ RunTime:0.002830s ]