id, content_type_id, thumb, title, url, push_time, sub_title select cp.id, cp.thumb, cp.content_type_id, cp.title, cp.url, cp.push_time, cp.sub_title, ct.id, ct.name, ct.can_into, ct.display_mode from cab_content_push cp inner join cab_content_type ct on cp.content_type_id = ct.id where locate(#{contentTypeId,jdbcType=VARCHAR}, content_type_id) = 1