总数查询SQL: SELECT COUNT(*) as total FROM (SELECT p.*, pi.catid, pi.brandid
FROM tbl_product p
LEFT JOIN tbl_product_idx pi ON p.id = pi.prodid
WHERE p.status = 1 AND pi.catid = ? AND pi.brandid = ? ORDER BY p.id DESC) as subquery
数据查询SQL: SELECT p.*, pi.catid, pi.brandid
FROM tbl_product p
LEFT JOIN tbl_product_idx pi ON p.id = pi.prodid
WHERE p.status = 1 AND pi.catid = ? AND pi.brandid = ? ORDER BY p.id DESC LIMIT ?, ?