［SQL語句］

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

UPDATE `fainro_tianguang` . `fr_products` SET `click` = `click`+1 WHERE (id = '7');

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

SELECT title,url FROM `fainro_tianguang` . `fr_products` WHERE (id> '7' AND status = '1' AND catid = '8') 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 查看新版