商品目录【辰科物联】

首页 >> 商品目录 >> >>

元器件型号：1411 件

当前类别共件相关商品

商品描述	综合参数	综合参数	封装规格/资料	操作
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39162B8813P810复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 5SMD	系列：- 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： AFS14A04-1575.42-T3复制状态：在售修改品牌： Abracon/艾博康复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 1.575GHZ 5SMD	系列：- 频率-中心：1.575GHz 带宽：40MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： F6QG2G140P2KA-J复制状态：在售修改品牌： TAIYO/太诱复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 2.14GHZ 5SMD	系列：F6 频率-中心：2.14GHz 带宽：60MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： AFS20A42-1575.42-T3复制状态：在售修改品牌： Abracon/艾博康复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 1.575GHZ 4SMD	系列：- 频率-中心：1.575GHz 带宽：42MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： ECS-D480A复制状态：在售修改品牌： ECS Inc.复制封装： - 外壳：TO-205AD，TO-39-3 金属罐描述： FILTER SAW 480MHZ TO205AD	系列：- 频率-中心：480MHz 带宽：2MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：通孔大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： RSF-915.000-26000-2015-TR复制状态：在售修改品牌： Raltron Electronics复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 915MHZ 4SMD	系列：RSF 频率-中心：915MHz 带宽：26MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39401R0983H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： SAW RESONATOR SMD	系列：B39401 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39321B3719H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 315MHZ 6SMD	系列：- 频率-中心：315MHz 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39242B3912U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 2.45GHZ 6SMD	系列：- 频率-中心：2.45GHz 带宽：97MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39431B3933H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 433.92MHZ 6SMD	系列：- 频率-中心：433.92MHz 带宽：120kHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39751B4318P810复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 751MHZ 5SMD	系列：- 频率-中心：751MHz 带宽：10MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39401R983U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： SAW RES 403.5500MHZ SMD	系列：B39401 频率-中心：403.5MHz 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39202B3668U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 1.95GHZ 6SMD	系列：- 频率-中心：1.95GHz 带宽：60MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39841B9003E910复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 836.5MHZ CSSPLUS SMD	系列：- 频率-中心：836.5MHz 带宽：25MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39242B7501P810复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：- 描述： FILTER SAW 2.442GHZ 5SMD	系列：* 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：- 大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39791B5380U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：- 描述： FILTER SAW BANDPASS SMD	系列：* 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：- 大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39262B8366L210复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：- 描述： SAW FILTER MOBILE 1411	系列：- 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：- 大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39321B3731H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 315MHZ 6SMD	系列：- 频率-中心：315MHz 带宽：120kHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： SF16-0908M4UU01复制状态：在售修改品牌： Kyocera/京瓷复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 908.42MHZ 4SMD	系列：SF, Kyocera 频率-中心：908.42MHz 带宽：19MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： RSF-433.920-1600-3030-TR-NS2复制状态：在售修改品牌： Raltron Electronics复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 433.92MHZ 6SMD	系列：RSF 频率-中心：433.92MHz 带宽：1.6MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页

已成功加入询盘！

去购物车结算继续采购

复制成功

业务介绍

购物指南

注册登录

找回密码

购物流程

常见问题

支付方式

配送方式

联系我们

直线：0755-28435922

总部地址：广东省深圳市龙岗区坂田上雪村金鹏工业区新一栋5楼

联系我们

公司简介

关注我们

辰科物联介绍

粤公网安备号

粤ICP备2023141824号-1

销售在线销售在线工程师在线工程师在线电话咨询

商品描述	综合参数	综合参数	封装规格/资料	操作
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39162B8813P810复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 5SMD	系列：- 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： AFS14A04-1575.42-T3复制状态：在售修改品牌： Abracon/艾博康复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 1.575GHZ 5SMD	系列：- 频率-中心：1.575GHz 带宽：40MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： F6QG2G140P2KA-J复制状态：在售修改品牌： TAIYO/太诱复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 2.14GHZ 5SMD	系列：F6 频率-中心：2.14GHz 带宽：60MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： AFS20A42-1575.42-T3复制状态：在售修改品牌： Abracon/艾博康复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 1.575GHZ 4SMD	系列：- 频率-中心：1.575GHz 带宽：42MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： ECS-D480A复制状态：在售修改品牌： ECS Inc.复制封装： - 外壳：TO-205AD，TO-39-3 金属罐描述： FILTER SAW 480MHZ TO205AD	系列：- 频率-中心：480MHz 带宽：2MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：通孔大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： RSF-915.000-26000-2015-TR复制状态：在售修改品牌： Raltron Electronics复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 915MHZ 4SMD	系列：RSF 频率-中心：915MHz 带宽：26MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39401R0983H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： SAW RESONATOR SMD	系列：B39401 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39321B3719H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 315MHZ 6SMD	系列：- 频率-中心：315MHz 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39242B3912U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 2.45GHZ 6SMD	系列：- 频率-中心：2.45GHz 带宽：97MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39431B3933H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 433.92MHZ 6SMD	系列：- 频率-中心：433.92MHz 带宽：120kHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39751B4318P810复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：5-SMD，无引线描述： FILTER SAW 751MHZ 5SMD	系列：- 频率-中心：751MHz 带宽：10MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39401R983U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： SAW RES 403.5500MHZ SMD	系列：B39401 频率-中心：403.5MHz 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39202B3668U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 1.95GHZ 6SMD	系列：- 频率-中心：1.95GHz 带宽：60MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39841B9003E910复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 836.5MHZ CSSPLUS SMD	系列：- 频率-中心：836.5MHz 带宽：25MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39242B7501P810复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：- 描述： FILTER SAW 2.442GHZ 5SMD	系列：* 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：- 大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39791B5380U410复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：- 描述： FILTER SAW BANDPASS SMD	系列：* 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：- 大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39262B8366L210复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：- 描述： SAW FILTER MOBILE 1411	系列：- 频率-中心：- 带宽：- 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：- 大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： -	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： B39321B3731H110复制状态：在售修改品牌： Qualcomm/高通复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 315MHZ 6SMD	系列：- 频率-中心：315MHz 带宽：120kHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： SF16-0908M4UU01复制状态：在售修改品牌： Kyocera/京瓷复制封装： - 外壳：4-SMD，无引线描述： FILTER SAW 908.42MHZ 4SMD	系列：SF, Kyocera 频率-中心：908.42MHz 带宽：19MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页
select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_lbq_sawlbq' 型号： RSF-433.920-1600-3030-TR-NS2复制状态：在售修改品牌： Raltron Electronics复制封装： - 外壳：6-SMD，无引线描述： FILTER SAW 433.92MHZ 6SMD	系列：RSF 频率-中心：433.92MHz 带宽：1.6MHz 插损： - 应用： -	string(27) "'xl','pl_zx','kd','cs','yy'" SELECT COLUMN_NAME as bt,COLUMN_COMMENT as title FROM INFORMATION_SCHEMA.Columns WHERE ORDINAL_POSITION >=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='ms')+1 and ORDINAL_POSITION <=(SELECT ORDINAL_POSITION FROM INFORMATION_SCHEMA.Columns WHERE table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME='is_new_time') and table_name='golon_lbq_sawlbq' AND table_schema='golon' and COLUMN_NAME not in('tdxl','gysqjfz','lm','fz_wk','zzs','tag','wk_cc','zzs_old','zzs_new','ljzt','spq','sqp','is_rohs','bz','gys_id','gm_gys_id','xysl','cfkc','dj','price_addtime','zddgs','spq','moq''gl_zz','gl_dm','gl_dmtp','symbol','gl_vdd','gl_gnd','gl_jz','gl_bdm','gl_bdmsm','gl_kbc','gl_dmgx','pcbfzk_id','pcbfzk','jyid','cat_id','wl_num','admin_id','mpn_bm','ch_bm','lock_dm','is_use_cat_id','is_new_time','gl_zz','gl_pin') and COLUMN_NAME not in ('xl','pl_zx','kd','cs','yy') limit 8 安装类型：表面贴装型大小 / 尺寸： - 高度(最大值)： - 工作温度：- 元器件等级： - 最小起订MOQ：- 热销或爆款：1	类别： SAW 滤波器等级： - 标识：(VIP会员显示) 资料：规格书/封装库	查询价格详情页

今日热搜

制造商

封装外壳

带宽

频率-中心

系列

插损

应用

安装类型

大小 / 尺寸

高度(最大值)

工作温度

元器件等级

热销或爆款

业务介绍

购物指南

联系我们

关注我们

销售在线

销售在线

工程师在线

工程师在线

电话咨询