世界语工作室 Esperanto-Studio

— 运行信息( 0.1252 秒):

［SQL语句］

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

SELECT title,thumb,url FROM `yzm_article` WHERE status=1 AND thumb != '' ORDER BY listorder ASC,id DESC LIMIT 5;

SELECT title,url FROM `yzm_article` WHERE status=1 AND catid=12 ORDER BY listorder ASC,id DESC LIMIT 5;

SELECT title,inputtime,url FROM `yzm_article` WHERE status=1 AND FIND_IN_SET('3',flag) ORDER BY listorder ASC,id DESC LIMIT 5;

SELECT title,url FROM `yzm_article` WHERE status=1 ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT title,url FROM `yzm_article` WHERE status=1 AND catid IN (1,2,3) ORDER BY listorder ASC,id DESC LIMIT 7;

SELECT title,url FROM `yzm_article` WHERE status=1 AND catid=10 ORDER BY listorder ASC,id DESC LIMIT 8;

SELECT title,url FROM `yzm_article` WHERE status=1 AND catid=11 ORDER BY listorder ASC,id DESC LIMIT 11;

SELECT title,url FROM `yzm_article` WHERE status=1 AND catid=9 ORDER BY listorder ASC,id DESC LIMIT 11;

SELECT title,url FROM `yzm_article` WHERE status=1 AND catid=6 ORDER BY listorder ASC,id DESC LIMIT 11;

SELECT title,thumb,url FROM `yzm_article` WHERE status=1 AND thumb != '' ORDER BY listorder ASC,id DESC LIMIT 5;

SELECT url,logo,name FROM `yzm_link` WHERE status=1 ORDER BY listorder ASC LIMIT 50;

［其他信息］

服务器信息：Apache

会话ID：

框架版本：1.0 查看新版

Pli>>观点