Форум пользователей MySQL

 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 |
+----+-------------+-------+------+---------------+------+---------+------+-------+----------------------------------------------+