SELECT p.*, c.name as category_name, c.slug as category_slug
FROM products p
LEFT JOIN product_categories c ON p.category_id = c.id
WHERE 1=1 AND p.category_id = 4
ORDER BY p.id DESC
LIMIT 0, 12
未找到产品，尝试更简单的查询
SELECT p.*, c.name as category_name, c.slug as category_slug
FROM products p
LEFT JOIN product_categories c ON p.category_id = c.id
ORDER BY p.id DESC
LIMIT 10
