repeated queries for every product

[sportstolen]

Hi.

When i go in to some category i get this repeated query for every product thats in that category.

 

it feels like this can be retrived in one query?

 

Has read the store optimizing by chemo but didnt found this one.

 

For this category i get

current Parse Time: 0.511 s with 468 queries

 

[33] => select
  c.categories_id
  FROM
  products p,
  products_to_categories pc,
  categories c,
  categories_description cd
  WHERE 
  p.products_id = pc.products_id AND c.categories_id = pc.categories_id AND
  p.products_status = '1' AND
  c.categories_id = 86 AND
  c.categories_id = cd.categories_id AND 
  cd.language_id = '4' LIMIT 1
	    [34] => select
  c.categories_id
  FROM
  products p,
  products_to_categories pc,
  categories c,
  categories_description cd
  WHERE 
  p.products_id = pc.products_id AND c.categories_id = pc.categories_id AND
  p.products_status = '1' AND
  c.categories_id = 89 AND
  c.categories_id = cd.categories_id AND 
  cd.language_id = '4' LIMIT 1

[sportstolen]

Well, it was related to ymm contribution.

 

Long gone