Create index for opencart database

The loading of my opencart website is really getting slow after enabling seo URLs. I noticed that the problem is that there is no database index for URL alias table so finding something really takes time in database. I need some mysql expert to create index for following tables in my opencart database: index on query column in url_alias table index on keyword column in url_alias table Index on parent_id column in category table Index on category_id column in product_to_category table Index on language_id column in category_description table Index on store_id column in category_to_store table Index on attribute_id AND language_id columns in product_attribute table Index on manufacturer_id column in product table Index on language_id column in product_description table Index on store_id column in product_to_store table