原sql select * from sys_user WHERE create_date is not null LIMIT 0,10 优化后的sql SELECT * FROM sys_user main_table RIGHT JOIN ( SELECT id FROM sys_user WHERE create_date is not NULL LIMIT 0,10 ) temp_table ON temp_table.id = main_table.id 数据量巨大的时候查询差别巨大