[SQL语句]
SELECT catid,catname,arrchildid,pclink,type FROM `myshenchouwolia` . `yzm_category` WHERE parentid=0 AND `display`=1 ORDER BY listorder ASC LIMIT 20;
SELECT title,thumb,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 AND thumb != '' ORDER BY listorder ASC,id DESC LIMIT 3;
SELECT id,tag,total FROM `myshenchouwolia` . `yzm_tag` ORDER BY id DESC LIMIT 20;
SELECT start_time, end_time, code FROM `myshenchouwolia` . `yzm_adver` WHERE (id = '2') LIMIT 1;
SELECT title,inputtime,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 AND FIND_IN_SET('3',flag) ORDER BY listorder ASC,id DESC LIMIT 5;
SELECT title,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 ORDER BY listorder ASC,id DESC LIMIT 10;
SELECT title,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 AND catid IN (1,2,3) ORDER BY listorder ASC,id DESC LIMIT 11;
SELECT title,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 AND catid=2 ORDER BY listorder ASC,id DESC LIMIT 11;
SELECT title,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 AND catid=3 ORDER BY listorder ASC,id DESC LIMIT 11;
SELECT start_time, end_time, code FROM `myshenchouwolia` . `yzm_adver` WHERE (id = '1') LIMIT 1;
SELECT title,thumb,url FROM `myshenchouwolia` . `yzm_article` WHERE status=1 AND catid=2 AND thumb != '' ORDER BY listorder ASC,id DESC LIMIT 5;
SELECT url,logo,name FROM `myshenchouwolia` . `yzm_link` WHERE status = 1 ORDER BY listorder ASC, id DESC LIMIT 20;
[其他信息]
服务器信息:Microsoft-IIS/8.5
会话ID: