Primary index is being used, not the one which is on the field present in the where condition
Possibly these composite indexes will speed it up:

cat: (acc_id, islive_in, cat_id)
cat_brand: (acc_id, cat_id, brand_id)


SHOW CREATE TABLE may give more clues as to why the Optimizer picked what it did.