生意区

［SQL语句］

SELECT * FROM `128dir` . `yzm_website` WHERE (id = '15549') LIMIT 1;

UPDATE `128dir` . `yzm_website` SET `click` = `click`+1 WHERE (id = '15549');

SELECT title,url FROM `128dir` . `yzm_website` WHERE (id< '15549' AND status = '1' AND catid = '180') ORDER BY id DESC LIMIT 1;

SELECT title,url FROM `128dir` . `yzm_website` WHERE (id> '15549' AND status = '1' AND catid = '180') ORDER BY id ASC LIMIT 1;

SELECT count(*) AS count,catid from yzm_category LIMIT 20;

SELECT count(*) AS count,id from yzm_website where status='1' LIMIT 20;

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

SELECT start_time, end_time, code FROM `128dir` . `yzm_adver` WHERE (id = '1') LIMIT 1;

SELECT start_time, end_time, code FROM `128dir` . `yzm_adver` WHERE (id = '9') LIMIT 1;

SELECT id,tag FROM `128dir` . `yzm_tag_content` INNER JOIN yzm_tag b ON yzm_tag_content.tagid=b.id WHERE yzm_tag_content.modelid=4 AND yzm_tag_content.aid=15549 ORDER BY id ASC LIMIT 10;

SELECT title,updatetime,url,color,weburl,flag FROM `128dir` . `yzm_website` WHERE status=1 ORDER BY RAND() LIMIT 10;

SELECT start_time, end_time, code FROM `128dir` . `yzm_adver` WHERE (id = '10') LIMIT 1;

SELECT id,title,thumb,url,color,click,description,inputtime FROM `128dir` . `yzm_website` WHERE status=1 ORDER BY id DESC LIMIT 8;

SELECT id,title,thumb,url,color,click,description,inputtime,flag FROM `128dir` . `yzm_website` WHERE status=1 AND FIND_IN_SET('9',flag) ORDER BY id DESC LIMIT 8;

SELECT id,title,thumb,url,color,click,description,inputtime,flag FROM `128dir` . `yzm_website` WHERE status=1 AND FIND_IN_SET('8',flag) ORDER BY id DESC LIMIT 8;

SELECT id,title,thumb,url,color,click,description,inputtime FROM `128dir` . `yzm_website` WHERE status=1 ORDER BY RAND() LIMIT 8;

［其他信息］

服务器信息：nginx/1.18.0

会话ID：

框架版本：2.0 查看新版