CREATE TABLE `data` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `uid` int(11) unsigned NOT NULL,
   `chr_string1` varchar(255) NOT NULL,
   `chr_string2` varchar(255) NOT NULL,
   `chr_string3` varchar(255) NOT NULL,
   `dec_value1` decimal(6,2) unsigned NOT NULL,
   `dec_value2` decimal(6,2) unsigned NOT NULL,
   `time` datetime NOT NULL,
   `boolen1` enum('0','1') NOT NULL default '1',
   PRIMARY KEY  (`id`),
   KEY `time` (`time`),
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251;

SELECT COUNT(*) as count, SUM(`dec_value1`) - SUM(`dec_value2`)   as  sum,  DATE_FORMAT(`time`, '%e.%m.%Y') as time from data where uid =  1   and  time BETWEEN STR_TO_DATE('$dstart', '%Y-%m-%d %H:%i:%s')  and    STR_TO_DATE('$dend', '%Y-%m-%d %H:%i:%s') and `boolen1` = '1' group by     DATE_FORMAT(`time`, '%e%m%Y') order by time+0

+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref    | rows  | Extra                                        |
+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+
|  1 | SIMPLE      | data  | ALL  | time          | NULL | NULL    |   NULL | 96885 | Using where; Using temporary; Using filesort |
+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+

SELECT `chr_string1`, `chr_string2`, `chr_string3`, COUNT(*) as    count, SUM(`dec_value1`) - SUM(`dec_value2`)  as sum FROM data where   uid  = 1 and `chr_string1` <> '' and time BETWEEN     STR_TO_DATE('$dstart', '%Y-%m-%d %H:%i:%s') and  STR_TO_DATE('$dend',    '%Y-%m-%d %H:%i:%s') and `boolen1` = '1' group by CONCAT(`chr_string1`,    `chr_string2`, `chr_string3`) order by `chr_string1`, `chr_string2`,    `chr_string3`+0 DESC

+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref    | rows  | Extra                                        |
+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+
|  1 | SIMPLE      | data  | ALL  | time          | NULL | NULL    |   NULL | 96885 | Using where; Using temporary; Using filesort |
+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+