我的感情只要你一个人懂

空间相册2017-04-17 14:44:081495

— 运行信息( 0.0278 秒):

［SQL语句］

SELECT * FROM `qqhao_yzm` . `yzm_article` WHERE (id = '8496') LIMIT 1;

UPDATE `qqhao_yzm` . `yzm_article` SET `click` = `click`+1 WHERE (id = '8496');

SELECT title,url FROM `qqhao_yzm` . `yzm_article` WHERE (id< '8496' AND status = '1' AND catid = '9') ORDER BY id DESC LIMIT 1;

SELECT title,url FROM `qqhao_yzm` . `yzm_article` WHERE (id> '8496' AND status = '1' AND catid = '9') ORDER BY id ASC LIMIT 1;

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

SELECT title,url,updatetime,color,thumb FROM `qqhao_yzm` . `yzm_article` WHERE status=1 AND catid=9 ORDER BY RAND() LIMIT 8;

SELECT title,url,color,inputtime FROM `qqhao_yzm` . `yzm_article` WHERE status=1 AND catid=9 ORDER BY `click` DESC LIMIT 15;

SELECT id,tag,total,remarks FROM `qqhao_yzm` . `yzm_tag` ORDER BY id DESC LIMIT 27;

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

［其他信息］

服务器信息：nginx/1.20.1

会话ID：

框架版本：2.1 查看新版

0.0278s