magento 2.4.4-p2 i have 13750 products. I have crated one dropdown attribute with 4 values it is required attribute. After that i have assigned attribute data to product it showing frontend also.
in admin pannel catalog->product search by keyword i am trying to search some string getting 504 error event
SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (`sku` LIKE '%oil%') UNION ALL SELECT `t1`.`entity_id` FROM `catalog_product_entity_varchar` AS `t1`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id WHERE (t1.attribute_id IN (73, 121)) AND (t1.store_id = 0) AND (IFNULL(t2.value, t1.value) LIKE '%oil%') UNION ALL SELECT * FROM (SELECT `catalog_product_entity_int`.`entity_id` FROM `catalog_product_entity_int` WHERE ((attribute_id=152 AND store_id=0 AND value = '821') OR (attribute_id=387 AND store_id=1 AND value = '5032'))) AS inoptionsql))
this is query i am seeing in logs pls give any solution how to solve this