SELECT COUNT(*) AS cnt FROM g5_shop_item WHERE 1 AND (it_origin LIKE '%%' OR it_name LIKE '%%' OR it_basic LIKE '%%' OR it_explan LIKE '%%' ) AND (ca_id like '1080%' or ca_id2 like '1080%' or ca_id3 like '1080%') and it_use = '1'
select * from `g5_shop_item` where it_use = '1' and ( ca_id like '1060%' or ca_id2 like '1060%' or ca_id3 like '1060%' ) ORDER BY it_price desc , it_order, it_id desc limit 1512 , 24