- 论坛徽章:
- 0
|
先修改SQL为:
SELECT pd.products_name
, p.products_id
, p.manufacturers_id
, p.products_price
, p.products_tax_class_id
, p.products_price
FROM products_description pd, products p, products_to_categories p2c
WHERE p.products_status = 1
AND p.products_id = p2c.products_id
AND pd.products_id = p2c.products_id
AND pd.language_id = 1
AND p2c.categories_id = 15264
ORDER BY p.products_id;
再贴出执行计划:
EXPLAIN
SELECT pd.products_name
, p.products_id
, p.manufacturers_id
, p.products_price
, p.products_tax_class_id
, p.products_price
FROM products_description pd, products p, products_to_categories p2c
WHERE p.products_status = 1
AND p.products_id = p2c.products_id
AND pd.products_id = p2c.products_id
AND pd.language_id = 1
AND p2c.categories_id = 15264
ORDER BY p.products_id\G |
|