Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

repeated queries for every product


sportstolen

Recommended Posts

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...