Designing variant for database entity

I have database design at http://ift.tt/1i1ch4B. Item has one to many relationship with Variant table. Variant table has one to many with dependent1 and dependent2 tables. I think this design is not optimized for search. e.g when a requests to get all the Items based on the user filtering mechanism like dependent1 title or dependent2 it has to search all the variants and gives response back with matching variant.

Can some one help me in redesigning keeping in mind the search performance. I have gone through some of the variant type questions but could not come to a conclusion ?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1PxQLin
via IFTTT