I have been trying to optimize my site by optimizing sql queries generated by uri mapping. I have used "General Query Log' to analyze repetitive queries.
I just found the following query twice for each product listing whenever I browse through product listing page.
Code:
1 Query SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'document_product_info'
AND
associated_db_id = '30353'
AND
language_id = '1'
AND
current_uri = '1'
1 Query select p2c.categories_id
from zen_products p, zen_products_to_categories p2c
where p.products_id = '30353'
and p.products_status = '1'
and p.products_id = p2c.products_id limit 1
1 Query select products_description
from zen_products_description
where products_id = '30353'
and language_id = '1'
1 Query select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call, products_type from zen_products where products_id = '30353' limit 1
------------------------------------------------------------------
1 Query SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'document_product_info'
AND
associated_db_id = '30353'
AND
language_id = '1'
AND
current_uri = '1'
1 Query select p2c.categories_id
from zen_products p, zen_products_to_categories p2c
where p.products_id = '30353'
and p.products_status = '1'
and p.products_id = p2c.products_id limit 1
1 Query SELECT
uri
FROM
zen_ceon_uri_mappings
WHERE
main_page = 'document_product_info'
AND
associated_db_id = '30353'
AND
language_id = '1'
AND
current_uri = '1'
1 Query select p2c.categories_id
from zen_products p, zen_products_to_categories p2c
where p.products_id = '30353'
and p.products_status = '1'
and p.products_id = p2c.products_id limit 1
If you see these four queries can be cut down by just one query through Join or Union.
Is there any suggestion how to optimize this code?
Thanks.
Bookmarks