[SQL语句]
SELECT * FROM `f_cp1` . `yzm_article` WHERE (id = '4') LIMIT 1;
UPDATE `f_cp1` . `yzm_article` SET `click` = `click`+1 WHERE (id = '4');
SELECT title,url FROM `f_cp1` . `yzm_article` WHERE (id< '4' AND status = '1' AND catid = '11') ORDER BY id DESC LIMIT 1;
SELECT title,url FROM `f_cp1` . `yzm_article` WHERE (id> '4' AND status = '1' AND catid = '11') ORDER BY id ASC LIMIT 1;
SELECT COUNT(*) AS total FROM `f_cp1` . `yzm_article` WHERE status=1 AND catid=11;
SELECT title,inputtime,url,status FROM `f_cp1` . `yzm_article` WHERE status=1 AND catid=11 ORDER BY listorder ASC,id DESC LIMIT 0,20;
[其他信息]
服务器信息:nginx/1.26.2
路由信息:模块( index ),控制器( index ),方法( show ),参数( catid=11&id=4 )