multi-column index has 1 unique column vs single column
I would suggest both,


Making comment_id a PRIMARY KEY: which is both UNIQUE and NOT NULL
If shop_name is frequently a part of the query, making shop_name it's own index.