［SQL語句］

SELECT * FROM `fainro_tianguang` . `fr_cases` WHERE (id = '4') LIMIT 1;

UPDATE `fainro_tianguang` . `fr_cases` SET `click` = `click`+1 WHERE (id = '4');

SELECT title,url FROM `fainro_tianguang` . `fr_cases` WHERE (id< '4' AND status = '1' AND catid = '11') ORDER BY id DESC LIMIT 1;

SELECT title,url FROM `fainro_tianguang` . `fr_cases` WHERE (id> '4' AND status = '1' AND catid = '11') ORDER BY id ASC LIMIT 1;

SELECT * FROM `fainro_tianguang` . `fr_adver` WHERE (id = '1') LIMIT 1;

SELECT catid,catname,arrchildid,pclink,target FROM `fainro_tianguang` . `fr_category` WHERE parentid=0 AND `display`=1 ORDER BY listorder ASC LIMIT 100;

SELECT catid,catname,arrchildid,pclink,target,icons FROM `fainro_tianguang` . `fr_category` WHERE parentid=0 AND `display`=1 ORDER BY listorder ASC LIMIT 100;

SELECT * FROM `fainro_tianguang` . `fr_adver` WHERE (id = '2') LIMIT 1;

［其他(tā)信息］

服務器信息：nginx/1.18.0

會話(huà)ID：

框架版本：2.0 查看新版