更有效地连接10行的SQL自连接？

SELECT t1.column1, t2.column2
FROM table1 t1, (SELECT column1, column2 FROM table1) t2
WHERE t1.column3 = t2.column1
LIMIT 10;

CREATE TEMPORARY TABLE temp_table AS
SELECT column1, column2 FROM table1;

SELECT t1.column1, t2.column2
FROM table1 t1, temp_table t2
WHERE t1.column3 = t2.column1
LIMIT 10;

SELECT t1.column1, t2.column2
FROM table1 t1, table1 t2
WHERE t1.column3 = t2.column1
LIMIT 10;