［SQL语句］

SELECT title,url,description,catid,id FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE status = '1' AND FIND_IN_SET(2,flag) AND id not in (0) ORDER BY inputtime DESC LIMIT 1;

SELECT title,url,thumb,catid,id FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE thumb <> '' AND FIND_IN_SET(4,flag) AND `status`=1 AND id not in (0,20948) ORDER BY id DESC LIMIT 5;

SELECT title,url,description,catid,id,inputtime FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE `status` = 1 AND id not in (0,20948,21376,21358,21335,21334,21310) ORDER BY inputtime DESC LIMIT 9;

SELECT catid,catname FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE `status`=1 AND `display`=1 AND catdir = "tongzhigonggao" LIMIT 1;

SELECT title,url,description,catid,id,inputtime FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE `status`=1 AND id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368) AND catid = 16 ORDER BY inputtime DESC LIMIT 9;

SELECT catid,catname,arrchildid FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE `status`=1 AND `display`=1 AND parentid = 0 ORDER BY listorder asc LIMIT 6;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `www_qdnzzb_gov_c` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) AND a.catid in (1,2,3,8,9,10,23,156,157,158,159,160,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `www_qdnzzb_gov_c` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) AND a.catid in (15,16,17,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `www_qdnzzb_gov_c` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) AND a.catid in (31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,77,78,79,80,81,82,83,84,85,86,87,88,89,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,162,163,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `www_qdnzzb_gov_c` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) AND a.catid in (161,7,11,12,13,14,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,70,72,73,74,75,76,100,101,102,103,104,152,153,154,155,164,165,166,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `www_qdnzzb_gov_c` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) AND a.catid in (67,68,69,71,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `www_qdnzzb_gov_c` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) AND a.catid in (90,18,19,24,25,26,91,92,93,94,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT title,url,thumb,catid,id FROM `www_qdnzzb_gov_c` . `yzm_article` WHERE thumb <> '' AND FIND_IN_SET(4,flag) AND `status`=1 AND id not in (0,20948,21376,21358,21335,21334,21310,21377,21375,21374,21373,21372,21371,21370,21369,21368,21363,21362,21361,21359,21336,21323,21305,21285,21272) ORDER BY id DESC LIMIT 7;

SELECT catid,catname,catdir FROM `www_qdnzzb_gov_c` . `yzm_category` WHERE (parentid = '0' AND status = '1' AND display = '1') ORDER BY listorder asc;

SELECT title,image,url,typeid,status FROM `www_qdnzzb_gov_c` . `yzm_banner` WHERE `status` = 1 AND typeid=3 ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT typeid FROM `www_qdnzzb_gov_c` . `yzm_link` GROUP BY typeid;

SELECT url,logo,name FROM `www_qdnzzb_gov_c` . `yzm_link` WHERE typeid=0;

SELECT url,logo,name FROM `www_qdnzzb_gov_c` . `yzm_link` WHERE typeid=1;

SELECT url,logo,name FROM `www_qdnzzb_gov_c` . `yzm_link` WHERE typeid=2;

［其他信息］

服务器信息：nginx/1.21.1

会话ID：

框架版本：2.2 查看新版