orderby的时候select上的列导致的影响分析

create table t1 (
a1 bigint  not null primary key auto_increment,
c10 char(10),
c100 char(100),
c200 char(200),
c30 char(255),
c300 text
)

insert into t1 (c10,c100,c200,c30,c300)values ('a','a','a','a','a');

insert into t1 (c10,c100,c200,c30,c300) select lpad(c10,10,'1'),lpad(c100,100,'1'),lpad(c200,190,'a'),lpad(c30,250,'1'),lpad(c300,2000,'1') from t1;


root@localhost [test]>select count(a1) from t1;
+-----------+
| count(a1) |
+-----------+
|     65536 |

select SQL_NO_CACHE count(1) from (
       select a1 from t1 IGNORE INDEX (primary)   order by c10 desc  limit  1000 ) a;


select SQL_NO_CACHE count(1) from (
       select a1,c100 from t1 IGNORE INDEX (primary)   order by c10 desc  limit  1000 ) a;

select SQL_NO_CACHE count(1) from (
       select a1,c100,c200 from t1 IGNORE INDEX (primary)   order by c10 desc  limit  1000 ) a;
   
   
select SQL_NO_CACHE count(1) from (
       select a1,c100,c200,c30 from t1 IGNORE INDEX (primary)   order by c10 desc  limit  1000 ) a; 

select SQL_NO_CACHE count(1) from (
       select a1,c100,c200,c30 ,c300 from t1 IGNORE INDEX (primary)   order by c10 desc  limit  1000 ) a;    

select SQL_NO_CACHE count(1) from (
       select * from t1 IGNORE INDEX (primary)   order by c10 desc  limit  1000 ) a;
   
   

在做网站、网站建设过程中，需要针对客户的行业特点、产品特性、目标受众和市场情况进行定位分析，以确定网站的风格、色彩、版式、交互等方面的设计方向。创新互联还需要根据客户的需求进行功能模块的开发和设计，包括内容管理、前台展示、用户权限管理、数据统计和安全保护等功能。