select count(*) as cnt from shop_goods
where shop_state = '0'
and isopen IN('1','2')
and (use_aff = '0')
and find_in_set('admin', use_hide) = '0'
and (ca_id like '006005005004004%' or ca_id2 like '006005005004004%' or ca_id3 like '006005005004004%') and (only_mb_id = '' or only_mb_id='admin') select * from shop_goods
where shop_state = '0'
and isopen IN('1','2')
and (use_aff = '0')
and find_in_set('admin', use_hide) = '0'
and (ca_id like '006005005004004%' or ca_id2 like '006005005004004%' or ca_id3 like '006005005004004%') and (only_mb_id = '' or only_mb_id='admin') order by index_no desc limit 0, 25