SELECT a.id, a.cat_id, a.name, a.price, a.content, a.image, a.add_time, a.description, a.filepath, a.prd_type, b.click FROM `dou_product` a FORCE INDEX (idx_cat_id_id) INNER JOIN `dou_product_click` b ON a.id = b.product_id WHERE cat_id IN (147) LIMIT 100, 20