MySQL Statement Optimization

SELECT * from b_common_product_param where cname = ' Type ' ORDER by ename limit 100000, 10;

SELECT * FROM B_common_product_param INNER JOIN
(select ID from b_common_product_param where cname = ' Type ' ORDER by ename limit 100000,) as x using (ID);


#第一条Sql查询时间: 49.612
#第二条Sql查询时间: 22.545

Table data: 12740129

A given join condition (which can be understood as shorthand) for table joins, such as

SELECT *  fromtable1JOINtable2 ontable1.id = table2.id

use using can be written as :

select  *   from   table1   join   Table2 using (ID)

MySQL Statement Optimization