［SQL語句］

SELECT title,url,inputtime,thumb,description FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=12 AND FIND_IN_SET('1',flag) ORDER BY listorder ASC,id DESC LIMIT 1;

SELECT title,url,inputtime FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=12 ORDER BY inputtime desc LIMIT 5;

SELECT title,url,inputtime,thumb,description FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=13 ORDER BY listorder ASC,id DESC LIMIT 1;

SELECT title,url,inputtime FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=13 ORDER BY inputtime desc LIMIT 5;

SELECT title,url,inputtime,thumb,description FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=16 AND FIND_IN_SET('1',flag) ORDER BY listorder ASC,id DESC LIMIT 1;

SELECT title,url,inputtime FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=16 ORDER BY inputtime desc LIMIT 5;

SELECT title,description,thumb,inputtime,url,status FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=14 ORDER BY inputtime desc LIMIT 1;

SELECT title,url,inputtime FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=14 ORDER BY inputtime desc LIMIT 4;

SELECT title,description,thumb,inputtime,url,status FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=15 ORDER BY inputtime desc LIMIT 1;

SELECT title,description,thumb,inputtime,url,status FROM `lhasajk_com` . `yzm_article` WHERE status=1 AND catid=15 ORDER BY inputtime desc LIMIT 4;

［其他信息］

服務器信息：nginx/1.16.1

會話ID：

框架版本：1.0 查看新版