There is a project with MVC framework using MySQL and a products table with description field. I want to use ElasticSearch for full-text search of products.
I have made indexing products to ES and can find products in ElasticSearch. But after that I want still use mysql to get this founded products from Mysql becouse all of products has own relations.
The only one idea I found is getting all ID's of founded results in ES and making query to mysql by this ID's.
It there any another solution to I get data from Mysql using results of ElasticSearch?