select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.action_name,a.rate,a.rate_hot,ROUND(sum(a.rate+a.rate_hot/100),4) 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_sjcj_cmpkzq' array(1) { [0]=> array(7) { ["wl_num"]=> string(4) "1099" ["parent_id"]=> string(2) "39" ["lb"]=> string(32) "数据采集 触摸屏控制器" ["action_name"]=> string(2) "s5" ["rate"]=> string(5) "1.068" ["rate_hot"]=> string(2) "35" ["moq_rate"]=> string(6) "1.4180" } }

封装：-

外壳：-

描述： IC SCREEN CNTRL

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.action_name,a.rate,a.rate_hot,ROUND(sum(a.rate+a.rate_hot/100),4) 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_cgq_ydcgq_qxkg' array(1) { [0]=> array(7) { ["wl_num"]=> string(4) "1237" ["parent_id"]=> string(3) "225" ["lb"]=> string(48) "颜色传感器- 运动传感器 - 倾斜开关" ["action_name"]=> string(5) "cgq25" ["rate"]=> string(5) "1.127" ["rate_hot"]=> string(2) "35" ["moq_rate"]=> string(6) "1.4770" } }

封装：-

描述： SENSOR TILT SW 30-60DEG 20MA TH