工程案例

［SQL语句］

SELECT * FROM `www_wiremesh_qz_` . `yzm_article` WHERE (id = '35') LIMIT 1;

UPDATE `www_wiremesh_qz_` . `yzm_article` SET `click` = `click`+1 WHERE (id = '35');

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

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

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

SELECT title,image,url,introduce FROM `www_wiremesh_qz_` . `yzm_banner` WHERE `status` = 1 ORDER BY listorder ASC,id DESC LIMIT 3;

［其他信息］

服务器信息：nginx/1.18.0

会话ID：

框架版本：2.5 查看新版