SELECT * from pm_metric where metric_id in (SELECT metric_id from pm_metric_pair where metric_pair_id in (SELECT metric_pair_id from pm_metric_group_pair_relation where base_group_id =150));
2.性能界面指标组下指标数据的验证
select t1.metric_group_id, t1.base_group_id, t1.metric_group_name, t3.metric_pair_id,
t3.metric_pair_name, t3.metric_unit from pm_metric_group t1
left join pm_metric_group_pair_relation t2 on t1.base_group_id = t2.base_group_id
left join pm_metric_pair_name t3 on t2.metric_pair_id = t3.metric_pair_id
left join pm_metric_pair t4 on t2.metric_pair_id = t4.metric_pair_id
where t1.metric_group_id in
(
select distinct(metric_group_id) from pm_cardtype_porttype where fixed_netype_id = 817
union all select distinct(metric_group_id) from pm_netype_metype where fixed_netype_id = 817
)
and t4.metric_id in #list