［SQL语句］

SELECT COUNT(*) AS total FROM `yzm_article` WHERE status=1 AND catid=10 AND FIND_IN_SET('2',flag);

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

SELECT COUNT(*) AS total FROM `yzm_article` WHERE status=1 AND catid=10 AND FIND_IN_SET('3',flag);

SELECT title,inputtime,url FROM `yzm_article` WHERE status=1 AND catid=10 AND FIND_IN_SET('3',flag) ORDER BY listorder ASC,id DESC LIMIT 0,4;

SELECT COUNT(*) AS total FROM `yzm_article` WHERE status=1 AND catid=7;

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

SELECT COUNT(*) AS total FROM `yzm_article` WHERE status=1 AND catid=6;

SELECT title,inputtime,url,description,thumb,click FROM `yzm_article` WHERE status=1 AND catid=6 ORDER BY listorder ASC,id DESC LIMIT 0,7;

SELECT COUNT(*) AS total FROM `yzm_article` WHERE status=1 AND catid=11;

SELECT title,inputtime,url,status FROM `yzm_article` WHERE status=1 AND catid=11 ORDER BY listorder ASC,id DESC LIMIT 0,20;

［其他信息］

服务器信息：nginx/1.21.1

会话ID：

框架版本：1.0 查看新版