cgi-bin/stat.pl?a=pay_log
долго открывается, при 31075 записях
Покажи debug. А еще лучше - в mysql сделай
explain select ...
и покажи
SELECT SQL_CALC_FOUND_ROWS p.*, u.fio, u.name FROM pays p LEFT JOIN users u ON p.mid = u.id WHERE 1 AND p.category<>3 ORDER BY time DESC LIMIT 0,15
Время выполнения sql: 15.9470 сек
mysql> explain SELECT SQL_CALC_FOUND_ROWS p.*, u.fio, u.name FROM pays p LEFT JOIN users u ON p.mid = u.id WHERE 1 AND p.category<>3 ORDER BY time DESC LIMIT 0,15;
+----+-------------+-------+--------+---------------+---------+---------+------------+--------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+---------------+---------+---------+------------+--------+-----------------------------+
| 1 | SIMPLE | p | ALL | category | NULL | NULL | NULL | 425302 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | bill.p.mid | 1 | |
+----+-------------+-------+--------+---------------+---------+---------+------------+--------+-----------------------------+