cancel
Showing results for 
Search instead for 
Did you mean: 

Getting query in show processlist magento2

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'.