[ DB ] CONNECT:[ UseTime:0.000608s ] mysql:host=localhost;port=8306;dbname=nhzhaopin_2018_db;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_company` [ RunTime:0.000877s ]
[ SQL ] SELECT `tp_company`.`ID`,`tp_company`.`Uid`,`tp_company`.`Name`,`tp_company`.`Logo`,`tp_company`.`Address`,`a`.`Updatetime` FROM `tp_company` LEFT JOIN `tp_member` `b` ON `tp_company`.`Uid`=`b`.`ID` LEFT JOIN (select max(Updatetime) Updatetime,Uid from tp_job where Updatetime + INTERVAL `Validity` DAY >= NOW() group by Uid) a ON `tp_company`.`Uid`=`a`.`Uid` WHERE ( (b.Status=4 or b.Status=5) and tp_company.Name is not null ) ORDER BY tp_company.Hottime asc LIMIT 8 [ RunTime:0.026914s ]
[ SQL ] SHOW COLUMNS FROM `tp_job` [ RunTime:0.000645s ]
[ SQL ] SELECT `tp_job`.`ID`,`tp_job`.`Job_Name`,`tp_job`.`Uid`,`tp_job`.`Updatetime`,a.Name as j_name FROM `tp_job` LEFT JOIN `tp_jobclass` `a` ON `tp_job`.`Cid`=`a`.`ID` WHERE ( tp_job.Status=1 and Uid in (2015,1689,39518,1956,52420,1980,720,1588) and tp_job.Updatetime + INTERVAL tp_job.`Validity` DAY >= NOW() ) ORDER BY tp_job.Updatetime desc [ RunTime:0.012353s ]
[ SQL ] SELECT `tp_company`.`ID`,`tp_company`.`Uid`,`tp_company`.`Name`,`tp_company`.`Logo`,`tp_company`.`Address`,`a`.`Updatetime` FROM `tp_company` LEFT JOIN `tp_member` `b` ON `tp_company`.`Uid`=`b`.`ID` LEFT JOIN (select max(Updatetime) Updatetime,Uid from tp_job where Updatetime + INTERVAL `Validity` DAY >= NOW() group by Uid) a ON `tp_company`.`Uid`=`a`.`Uid` WHERE ( b.Status in (3,4,5) and tp_company.Name is not null ) ORDER BY a.Updatetime desc LIMIT 8 [ RunTime:0.020809s ]
[ SQL ] SELECT `tp_job`.`ID`,`tp_job`.`Job_Name`,`tp_job`.`Uid`,`tp_job`.`Updatetime`,a.Name as j_name FROM `tp_job` LEFT JOIN `tp_jobclass` `a` ON `tp_job`.`Cid`=`a`.`ID` WHERE ( tp_job.Status=1 and tp_job.Uid in (1588,46355,45563,333,22496,1058,38800,250) and tp_job.Updatetime + INTERVAL tp_job.`Validity` DAY >= NOW() ) ORDER BY tp_job.Updatetime desc [ RunTime:0.012304s ]