How to optimize this query?

Question

MySQL

This query is running for a long time, it is necessary to reduce the time

SELECT 
taxon.name, 
test.domain d, 
(select id from taxon where name = (select name from test where id = d limit 1) limit 1) 
FROM `test` 
join taxon on taxon.name = test.name