Ttdfjt

Who is the Umpire in this picture?

Realistic Necromancy?

How to reduce LED flash rate (frequency)

A Strange Latex Symbol

What does it mean to express a gate in Dirac notation?

Why do Computer Science majors learn Calculus?

A ​Note ​on ​N!

Is there any limitation with Arduino Nano serial communication distance?

Apply MapThread to all but one variable

Does this extra sentence in the description of the warlock's Eyes of the Rune Keeper eldritch invocation appear in any official reference?

Pulling the rope with one hand is as heavy as with two hands?

how to sum variables from file in bash

Don’t seats that recline flat defeat the purpose of having seatbelts?

a sore throat vs a strep throat vs strep throat

US visa is under administrative processing, I need the passport back ASAP

Examples of non trivial equivalence relations , I mean equivalence relations without the expression " same ... as" in their definition?

With a Canadian student visa, can I spend a night at Vancouver before continuing to Toronto?

Rivers without rain

Error message with tabularx

Using a Lyapunov function to classify stability and sketching a phase portrait

What are the potential pitfalls when using metals as a currency?

How can I place the product on a social media post better?

The Defining Moment

Is contacting this expert in the field something acceptable or would it be discourteous?

Huge slow query for products, categories, filters

Convert SQL Select to Magento SQL queryUpgrade from 1.9.1 to 1.9.2 Error`getLastPageNumber()` returning wrong number of pagesProduct List Attribute Filter QuerySQL Syntax Error near 'cat_index.is_parent=1'Magento 1.9.3.2 search returns empty resultMagento 1.9: Product Price tables - how they work?Slow SQL query with many joinsMagento 1.9.3.1 Quck Search Not workingMagento more than 61 product attribute database tables in join query

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I run a Magento 1.9 based store with around 40 thousand active products. Using an FPC I am able to keep the server stable sometimes, and other unstable. While checking for highest hardware consumption I found the following query with thousands of numbers related to product IDs inside the query where I wrote ...

Have you been through this problem and came to a solution ? Do you have any ideas on how to solve it ?

Best regards,
Gustavo Ulyssea

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, 
IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), 
price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e`

 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_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id 
 AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' 
 WHERE (`e`.`entity_id` IN(36873, 43340, 43334, 43318, ...))


 ORDER BY FIELD(`e`.`entity_id`, 36873, 43340, 43334, ...)) ASC LIMIT 7

magento-1.9 sql

share|improve this question

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1

add a comment | 

0

I run a Magento 1.9 based store with around 40 thousand active products. Using an FPC I am able to keep the server stable sometimes, and other unstable. While checking for highest hardware consumption I found the following query with thousands of numbers related to product IDs inside the query where I wrote ...

Have you been through this problem and came to a solution ? Do you have any ideas on how to solve it ?

Best regards,
Gustavo Ulyssea

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, 
IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), 
price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e`

 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_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id 
 AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' 
 WHERE (`e`.`entity_id` IN(36873, 43340, 43334, 43318, ...))


 ORDER BY FIELD(`e`.`entity_id`, 36873, 43340, 43334, ...)) ASC LIMIT 7

magento-1.9 sql

share|improve this question

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1

add a comment | 

I run a Magento 1.9 based store with around 40 thousand active products. Using an FPC I am able to keep the server stable sometimes, and other unstable. While checking for highest hardware consumption I found the following query with thousands of numbers related to product IDs inside the query where I wrote ...

Have you been through this problem and came to a solution ? Do you have any ideas on how to solve it ?

Best regards,
Gustavo Ulyssea

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, 
IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), 
price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e`

 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_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id 
 AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' 
 WHERE (`e`.`entity_id` IN(36873, 43340, 43334, 43318, ...))


 ORDER BY FIELD(`e`.`entity_id`, 36873, 43340, 43334, ...)) ASC LIMIT 7

magento-1.9 sql

share|improve this question

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, 
IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), 
price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e`

 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_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id 
 AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' 
 WHERE (`e`.`entity_id` IN(36873, 43340, 43334, 43318, ...))


 ORDER BY FIELD(`e`.`entity_id`, 36873, 43340, 43334, ...)) ASC LIMIT 7

share|improve this question

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1

share|improve this question

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1

asked Apr 24 at 13:32

Gustavo UlysseaGustavo Ulyssea

1