Search results don’t show products

my website is a woocommerce site and it has blog posts and some pages. My problem is the search box. Everytime I searched it only shows the posts and pages results. It is not showing woocommerce products. How can I fix this wordpress search result?

Here is my wordpress search.php

https://pastebin.com/SQqihtd0

You have in your query WHERE p.post_type IN ('post', 'page'), that is why it shows only the posts and pages. Add post type product to query:
WHERE p.post_type IN ('post', 'page', 'product')