[SQL語句]
SELECT * FROM `fainro_tianguang` . `fr_products` WHERE (id = '4') LIMIT 1;
UPDATE `fainro_tianguang` . `fr_products` SET `click` = `click`+1 WHERE (id = '4');
SELECT title,url FROM `fainro_tianguang` . `fr_products` WHERE (id< '4' AND status = '1' AND catid = '7') ORDER BY id DESC LIMIT 1;
SELECT title,url FROM `fainro_tianguang` . `fr_products` WHERE (id> '4' AND status = '1' AND catid = '7') 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;
[其他信息]
服務器信息:nginx/1.18.0
會話ID: