in reply to which method is more faster?

Now this porblem has been solved by adding INDEX in the tab columns.It spent about 50s totally by method 1 .How stupid it is if forget adding INDEX in some columns!