Why does magento2 calls following query in category page?
INSERT INTO `search_tmp_58aad5dedee6e0_33744149` SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0)) * 1) AS score FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id WHERE (category_ids_index.category_id = 4)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 200000
Even there is no need of any search functionality. Have anyone got any clarification of this? I have a category that has lot of products and that category loads in about 15 second for the first time. So I am debugging and found above query is much slow.
Thanks in advance.