SELECT 
  a.* 
FROM 
  cscart_label_manager_artists a 
WHERE 
  a.artist_id = 7491 
  AND a.status = 'A'

Query time 0.00011

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY,status PRIMARY 3 const 1

Result

artist_id name status facebook twitter soundcloud youtube motd_slug created_at updated_at lang_code
7491 Sole Traders A # 1428790827 EN