sqlexplain
SELECT `info_info`.*, `a`.`name` AS `d1name`
FROM `info_info`
LEFT JOIN (SELECT * FROM `common_diqu`) `a` ON a.id=d1 WHERE `status`=1
ORDER BY `tid` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE info_info ref status status 1 const 129947 Using where; Using filesort
1 SIMPLE common_diqu eq_ref PRIMARY PRIMARY 3 info_info.d1 1 Using where
explain
select i.*,a.name as d1name
from info_info i
left join common_diqu a on i.d1=a.id
where status=1
order by tid desc
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE i ref status status 1 const 129948 Using where; Using filesort
1 SIMPLE a eq_ref PRIMARY PRIMARY 3 i.d1 1 Using where