sql优化

[lzdohh]

执行时间20秒左右

select
    address, `type`, balance, restricting_balance, staking_value, delegate_value, redeemed_value, 
    tx_qty, transfer_qty, delegate_qty, staking_qty, proposal_qty, candidate_count, delegate_hes, 
    delegate_locked, delegate_released, contract_name, contract_create, contract_createHash, 
    contract_destroy_hash, create_time, update_time, have_reward, erc1155_tx_qty, erc721_tx_qty, erc20_tx_qty
from address
order by create_time limit 951000,1000

执行时间2秒左右

SELECT `address`.`address`, `address`.`type`, `address`.`balance`, `address`.`restricting_balance`, `address`.`staking_value`
 , `address`.`delegate_value`, `address`.`redeemed_value`, `address`.`tx_qty`, `address`.`transfer_qty`, `address`.`delegate_qty`
 , `address`.`staking_qty`, `address`.`proposal_qty`, `address`.`candidate_count`, `address`.`delegate_hes`, `address`.`delegate_locked`
 , `address`.`delegate_released`, `address`.`contract_name`, `address`.`contract_create`, `address`.`contract_createHash`, `address`.`contract_destroy_hash`
 , `address`.`create_time`, `address`.`update_time`, `address`.`have_reward`, `address`.`erc1155_tx_qty`, `address`.`erc721_tx_qty`
 , `address`.`erc20_tx_qty`
FROM `address`
 INNER JOIN (
  SELECT `address`
  FROM `address`
  ORDER BY `create_time`
  LIMIT 951000, 1000
 ) `tmp_0` USING (`address`);