Slow search by LIKE and other values (1 million rows+)
Not sure about mysql but in mssql like '%val' is a full scan 

Multiple keywords in a varchar(200) column is probably not the best design.  Spit the keyswords into separate words into a separate table with a FK back to company.ID.  So each word would be a row. Then you can search on keyword.value = 'xxx' and use an index.