干货满满！一图读懂省党代会报告

［SQL语句］

SELECT * FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE (id = '21250') LIMIT 1;

UPDATE `www_qdnzzb_gov_c` . `yzm_article` SET `click` = `click`+1 WHERE (id = '21250');

SELECT id,catid,title,url FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE (id<'21250' AND status = '1' AND catid = '157') ORDER BY id DESC LIMIT 1;

SELECT id,catid,title,url FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE (id>'21250' AND status = '1' AND catid = '157') ORDER BY id ASC LIMIT 1;

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 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;

［其他信息］

服务器信息：nginx/1.21.1

会话ID：

框架版本：2.2 查看新版