［SQL语句］

SELECT catid,catname,catdir FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE (parentid = '0' AND status = '1' AND display = '1') ORDER BY listorder asc;

SELECT arrchildid FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE status = 1 AND display = 1 AND catid = 163 LIMIT 1;

SELECT * FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE status = 1 AND display = 1 AND catid in (32,43,44,48,49,50,51,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135) ORDER BY listorder asc;

SELECT * FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE status = 1 AND display = 1 AND catid = 163 LIMIT 1;

SELECT * FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE status = 1 AND display = 1 AND catid = 31 LIMIT 1;

SELECT * FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE status = 1 AND display = 1 AND catid = 163 LIMIT 1;

SELECT * FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE status = 1 AND display = 1 AND parentid = 31 ORDER BY listorder asc;

SELECT COUNT(*) AS total FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE status=1 AND catid IN (163,32,43,44,48,49,50,51,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135);

SELECT id,title,thumb,url,catid,inputtime FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE status=1 AND catid IN (163,32,43,44,48,49,50,51,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135) ORDER BY inputtime desc LIMIT 100,20;

SELECT typeid FROM `www_qdnzzb_gov_c` . `yzm_link` GROUP BY typeid;

SELECT url,logo,name FROM `www_qdnzzb_gov_c` . `yzm_link` WHERE typeid=0;

SELECT url,logo,name FROM `www_qdnzzb_gov_c` . `yzm_link` WHERE typeid=1;

SELECT url,logo,name FROM `www_qdnzzb_gov_c` . `yzm_link` WHERE typeid=2;

［其他信息］

服务器信息：Apache/2.4.38 (Win64) PHP/5.6.40

会话ID：

框架版本：2.2 查看新版