子站点2

［SQL语句］

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,typeid,image,url,introduce FROM `sz1` . `yzm_banner` WHERE `status` = 1 AND typeid in ('7_type','8_type','9_type') AND `siteid`=4 ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT title,url,thumb,description FROM `sz1` . `yzm_product_www_wellchipgo_com` WHERE status=1 AND FIND_IN_SET('3',flag) ORDER BY id asc LIMIT 20;

SELECT title,typeid,image,url,introduce FROM `sz1` . `yzm_banner` WHERE `status` = 1 AND typeid in ('10_type') AND `siteid`=4 ORDER BY listorder ASC,id DESC LIMIT 3;

SELECT id,title,image,url,introduce FROM `sz1` . `yzm_banner` WHERE `status` = 1 AND typeid in ('11_type') AND `siteid`=4 ORDER BY listorder ASC,id DESC LIMIT 9;

［其他信息］

服务器信息：nginx/1.18.0

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

框架版本：2.7 查看新版

Products quick navigation

Discover our products