cancel
Showing results for 
Search instead for 
Did you mean: 

Getting query in show processlist magento2

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Getting query in show processlist magento2

I am using magento2.3.2 and getting below error in processlist. Please provide any solution.

INSERT IGNORE INTO `temp_79f4cf2544cff197ab51cb7e77ffe5da89ef3065` SELECT `e`.`entity_id` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1AND cat_index.visibility IN(2, 4) AND cat_index.category_id=123
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_product_index_eav` AS `layered_nav_style__501` ON `layered_nav_style__501`.`entity_id` = `e`.`entity_id` AND `layered_nav_style__501`.`attribute_id` = '168' AND `layered_nav_style__501`.`store_id` = '1' AND `layered_nav_style__501`.`value` = '501'
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_style__501__stock` ON `layered_nav_style__501`.`source_id` = `layered_nav_style__501__stock`.`product_id` AND `layered_nav_style__501__stock`.`website_id` = 0 AND `layered_nav_style__501__stock`.`stock_id` = 1 AND `layered_nav_style__501__stock`.`stock_status` = 1
INNER JOIN `catalog_product_index_eav` AS `layered_nav_style__509` ON `layered_nav_style__509`.`entity_id` = `e`.`entity_id` AND `layered_nav_style__509`.`attribute_id` = '168' AND `layered_nav_style__509`.`store_id` = '1' AND `layered_nav_style__509`.`value` = '509'
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_style__509__stock` ON `layered_nav_style__509`.`source_id` = `layered_nav_style__509__stock`.`product_id` AND `layered_nav_style__509__stock`.`website_id` = 0 AND `layered_nav_style__509__stock`.`stock_id` = 1 AND `layered_nav_style__509__stock`.`stock_status` = 1
INNER JOIN `catalog_product_index_eav` AS `layered_nav_hight` ON `layered_nav_hight`.`entity_id` = `e`.`entity_id` AND `layered_nav_hight`.`attribute_id` = '195' AND `layered_nav_hight`.`store_id` = '1' AND `layered_nav_hight`.`value` IN (934,860)
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_hight__stock` ON `layered_nav_hight`.`source_id` = `layered_nav_hight__stock`.`product_id` AND `layered_nav_hight__stock`.`website_id` = 0 AND `layered_nav_hight__stock`.`stock_id` = 1 AND `layered_nav_hight__stock`.`stock_status` = 1
INNER JOIN `catalog_product_index_eav` AS `layered_nav_industryy__465` ON `layered_nav_industryy__465`.`entity_id` = `e`.`entity_id` AND `layered_nav_industryy__465`.`attribute_id` = '180' AND `layered_nav_industryy__465`.`store_id` = '1' AND `layered_nav_industryy__465`.`value` = '465'
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_industryy__465__stock` ON `layered_nav_industryy__465`.`source_id` = `layered_nav_industryy__465__stock`.`product_id` AND `layered_nav_industryy__465__stock`.`website_id` = 0 AND `layered_nav_industryy__465__stock`.`stock_id` = 1 AND `layered_nav_industryy__465__stock`.`stock_status` = 1
INNER JOIN `catalog_product_index_eav` AS `layered_nav_featuress__466` ON `layered_nav_featuress__466`.`entity_id` = `e`.`entity_id` AND `layered_nav_featuress__466`.`attribute_id` = '181' AND `layered_nav_featuress__466`.`store_id` = '1' AND `layered_nav_featuress__466`.`value` = '466'
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_featuress__466__stock` ON `layered_nav_featuress__466`.`source_id` = `layered_nav_featuress__466__stock`.`product_id` AND `layered_nav_featuress__466__stock`.`website_id` = 0 AND `layered_nav_featuress__466__stock`.`stock_id` = 1 AND `layered_nav_featuress__466__stock`.`stock_status` = 1
INNER JOIN `catalog_product_index_eav` AS `layered_nav_featuress__473` ON `layered_nav_featuress__473`.`entity_id` = `e`.`entity_id` AND `layered_nav_featuress__473`.`attribute_id` = '181' AND `layered_nav_featuress__473`.`store_id` = '1' AND `layered_nav_featuress__473`.`value` = '473'
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_featuress__473__stock` ON `layered_nav_featuress__473`.`source_id` = `layered_nav_featuress__473__stock`.`product_id` AND `layered_nav_featuress__473__stock`.`website_id` = 0 AND `layered_nav_featuress__473__stock`.`stock_id` = 1 AND `layered_nav_featuress__473__stock`.`stock_status` = 1
INNER JOIN `catalog_product_index_eav` AS `layered_nav_featuress__846` ON `layered_nav_featuress__846`.`entity_id` = `e`.`entity_id` AND `layered_nav_featuress__846`.`attribute_id` = '181' AND `layered_nav_featuress__846`.`store_id` = '1' AND `layered_nav_featuress__846`.`value` = '846'
INNER JOIN `cataloginventory_stock_status` AS `layered_nav_featuress__846__stock` ON `layered_nav_featuress__846`.`source_id` = `layered_nav_featuress__846__stock`.`product_id` AND `layered_nav_featuress__846__stock`.`website_id` = 0 AND `layered_nav_featuress__846__stock`.`stock_id` = 1 AND `layered_nav_featuress__846__stock`.`stock_status` = 1
2 REPLIES 2

Re: Getting query in show processlist magento2

Hi @pradeeppal 

These are the magento default queries for indexing in magento.

What issue you are getting due to this?

Re: Getting query in show processlist magento2

@pradeeppal  If not already then set indexing "Update on schedule" instead of "Update on Save".

- Tarandeep
Problem solved?Please give 'Kudos' and accept 'Answer as Solution'.