explain select d1.id from
doctor_share as d1 inner join
(select id from doctor_share
where check_status=1 and is_delete=0
) as d2
on d1.id=d2.id
where d1.type=1
order by id desc
limit 0,20
explain select d1.id from
doctor_share as d1 inner join
(select id from doctor_share
where check_status=1 and is_delete=0
) as d2
on d1.id=d2.id
where d1.type=1
order by id desc
limit 0,20