［系统信息］

［SQL语句］

SELECT p.title,p.description,p.url,p.thumb FROM `sz1` . `yzm_tag_content` tc INNER JOIN yzm_tag t ON tc.tagid=t.id INNER JOIN yzm_product_www_wellchipgo_com p on p.id = tc.aid WHERE t.catid = 162 GROUP BY tc.aid ORDER BY p.listorder desc, p.id desc;

SELECT * FROM `sz1` . `yzm_tag` WHERE catid = 162 ORDER BY inputtime desc, id desc;

SELECT catid,catimg,area,modelid,arrchildid,catname,pclink,target FROM `sz1` . `yzm_category` WHERE siteid = 4 AND `display`=1 AND parentid!=0 and display=1 and area=1 ORDER BY listorder desc,catid asc LIMIT 20;

SELECT title,description,url,thumb FROM `sz1` . `yzm_product_www_wellchipgo_com` WHERE status=1 AND catid=162 ORDER BY listorder ASC,id DESC LIMIT 20;

［其他信息］

服务器信息：nginx/1.18.0

路由信息：模块( site )，控制器( index )，方法( lists )，参数( catid=162&siteid=4 )

框架版本：2.7 查看新版