0

we are seeing this SQL query in our DB and are unsure what is generating this, we have flat catalog index enabled so it should not be asking for this

sql query select `e`.*, if(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) as `visibility`, if(at_status.value_id > 0, at_status.value, at_status_default.value) as `status`, `cat_index`.`position` as `cat_index_position`, `at_inventory_in_stock`.`is_in_stock` as `inventory_in_stock` from `catalog_product_entity` as `e` inner join `catalog_product_entity_int` as `at_visibility_default` on (`at_visibility_default`.`entity_id` = `e`.`entity_id`) and (`at_visibility_default`.`attribute_id` = '102') and `at_visibility_default`.`store_id` = 0 left join `catalog_product_entity_int` as `at_visibility` on (`at_visibility`.`entity_id` = `e`.`entity_id`) and (`at_visibility`.`attribute_id` = '102') and (`at_visibility`.`store_id` = 1) inner join `catalog_product_entity_int` as `at_status_default` on (`at_status_default`.`entity_id` = `e`.`entity_id`) and (`at_status_default`.`attribute_id` = '96') and `at_status_default`.`store_id` = 0 left join `catalog_product_entity_int[...]

anyone knows why is this and where is this being generated from?

  • I’m voting to close this question because Magento version not mentioned – Teja Bhagavan Kollepara Dec 14 '20 at 7:59
0

This looks like a regular query that retrieves a list of products filtered by status active.

  • hi thank you for your reply, yes i figure that, but it is puttin huge load on server, and my site is way too slow over 100 sec for home page, and i dont have any product at all on home page., shoudnt enabling flat_category index resolve this? as it shouldnt be then requesting this much data in each url request? as for server i have huge server with 2 gold xeon CPU's with 16core each so server is not the problem, i have tried changing server as well and no use. – shafiq Apr 10 '20 at 22:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.