［SQL语句］

SELECT catid,catname,arrchildid,pclink,type,catimg,subtitle FROM `muyangxiaobai` . `yzm_category` WHERE parentid=0 AND `display`=1 ORDER BY listorder ASC LIMIT 20;

SELECT start_time, end_time, code FROM `muyangxiaobai` . `yzm_adver` WHERE (id = '8') LIMIT 1;

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

SELECT * FROM `muyangxiaobai` . `yzm_article` WHERE status=1 AND catid=19 ORDER BY listorder ASC,id DESC LIMIT 0,20;

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

SELECT title,url,catid,thumb,description,inputtime FROM `muyangxiaobai` . `yzm_article` WHERE status=1 AND catid=19 ORDER BY id DESC LIMIT 0,12;

SELECT url,logo,name FROM `muyangxiaobai` . `yzm_link` WHERE status=1 ORDER BY listorder ASC LIMIT 20;

［其他信息］

服务器信息：nginx/1.12.2

会话ID：

框架版本：2.2 查看新版