The SQL error !
select r.*,b.name from `hm_6300_brand_product_relat` r left join `hm_6300_brand` b on r.bid = b.id where `tid` = order by `hit` desc limit 10
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by `hit` desc limit 10' at line 1