CREATE TABLE test.fh_download (
  id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  ip int(10) UNSIGNED NOT NULL,

  ..............

  PRIMARY KEY (id, date),
  INDEX IDX_fh_download (ip, user_file_id, date),
  INDEX IX_download_copy_type_date (type, date),
  INDEX IX_download_date_file (date, ip, project_name, type, file_id),
  INDEX IX_download_date_user_file (date, user_file_id),
  INDEX IX_download_ip (ip, status),
  INDEX IX_status (status, user_id),
  INDEX IX_test (file_owner_id, status, ip, user_id, date),
  UNIQUE INDEX IX_unique_key (unique_key, date)
)
ENGINE = INNODB
AUTO_INCREMENT = 222476207
AVG_ROW_LENGTH = 103
CHARACTER SET latin1
COLLATE latin1_swedish_ci
PARTITION BY RANGE (DAYOFWEEK(date))
(
PARTITION p00 VALUES LESS THAN (2)
ENGINE = INNODB,
PARTITION p01 VALUES LESS THAN (3)
ENGINE = INNODB,
PARTITION p02 VALUES LESS THAN (4)
ENGINE = INNODB,
PARTITION p03 VALUES LESS THAN (5)
ENGINE = INNODB,
PARTITION p04 VALUES LESS THAN (6)
ENGINE = INNODB,
PARTITION p05 VALUES LESS THAN (7)
ENGINE = INNODB,
PARTITION p06 VALUES LESS THAN (8)
ENGINE = INNODB
);

SELECT SQL_NO_CACHE * 
  FROM `fh_download` `t` 
   FORCE INDEX (IX_download_date_file)
  WHERE t.project_name = 'xxx'
  AND ip = INET_ATON('127.0.0.1')
  AND date > NOW() - INTERVAL 1 DAY
  ORDER BY type = "free" DESC, date DESC LIMIT 1;